Activity #2711
openModule #2640: Pension Claim - Phase III
Module #2663: Online Member Claim
Sub module #2622: Development & unit testing
Sub module #2695: Save online member claim (draft)
Activity #2742: DB Logic
Save - DB Operations
50%
Description
Create a DB procedure to save the member claim (i/p to the sp will be JSON data).
Updated by Thara S Pillai about 2 years ago
- Parent task changed from #2695 to #2742
Updated by Jiji P B about 2 years ago
- Status changed from New to In Progress
- % Done changed from 0 to 50
Updated by Thara S Pillai about 2 years ago
Refer PKG_ONLINE_CLAIM_SERVICE.SAVE_OCS_CLAIM_DATA
to save pension claim data.
V_TRACKING_ID :=GEN_TRACKING_ID_UAN(IN_UAN,IN_CLAIM_TYPE);
To generate Tracking ID may refer and call DB function GEN_TRACKING_ID_UAN (IN_UAN,IN_CLAIM_TYPE);
IN_CLAIM_TYPE = 03
The FUNCTION "UNIFIED_PORTAL".GET_CLAIM_FORM_TYPE_STR defines claim form types as
"Defines and returns claim form types
'01','FORM-19(ONLY PF WITHDRAWAL)',
'02','FORM-20(PF WITHDRAWAL-DEATH CLAIM)',
'03','FORM-10D(MONTHLY PENSION)',
'04','FORM-10C(ONLY PENSION WITHDRAWAL)',
'06','FORM-31(PF ADVANCE)',
'07','EDLI (5IF)'"
Updated by Thara S Pillai about 2 years ago
Tracking ID is composed of UAN (12 digit), Claim form type (03 for pension) and count of previous pension claim (3 digit?)