[Home] [Help]
425: IF (L_QUALIFYING_SCHEME_EXISTS ='Y') AND L_AUTO_ENROL_DATE IS NULL THEN -- Qualifying scheme already exists.
426: RETURN 0; -- Do Nothing if Qualifying Scheme Exists Already
427: END IF;
428: --Bug 14793919
429: IF (NVL(fnd_date.canonical_to_date(L_OPTOUT_DATE),G_END_OF_TIME) > L_PRP_END_DATE) THEN
430: IF (NVL(fnd_date.canonical_to_date(L_POSTPONEMENT_DATE),L_PRP_START_DATE) < L_PRP_END_DATE) THEN
431: IF (L_EMPLOYEE_STATUS =1) THEN
432: IF L_AUTO_ENROL_DATE IS NULL THEN
433: L_ERROR :=1; -- Qualified Yet Not Automatically Enrolled - Could be any reason like Postponement or Qualifying scheme already exists.
426: RETURN 0; -- Do Nothing if Qualifying Scheme Exists Already
427: END IF;
428: --Bug 14793919
429: IF (NVL(fnd_date.canonical_to_date(L_OPTOUT_DATE),G_END_OF_TIME) > L_PRP_END_DATE) THEN
430: IF (NVL(fnd_date.canonical_to_date(L_POSTPONEMENT_DATE),L_PRP_START_DATE) < L_PRP_END_DATE) THEN
431: IF (L_EMPLOYEE_STATUS =1) THEN
432: IF L_AUTO_ENROL_DATE IS NULL THEN
433: L_ERROR :=1; -- Qualified Yet Not Automatically Enrolled - Could be any reason like Postponement or Qualifying scheme already exists.
434: ELSIF L_AUTO_ENROL_DATE IS NOT NULL AND fnd_date.canonical_to_date(L_AUTO_ENROL_DATE) BETWEEN L_PRP_START_DATE AND L_PRP_END_DATE THEN
430: IF (NVL(fnd_date.canonical_to_date(L_POSTPONEMENT_DATE),L_PRP_START_DATE) < L_PRP_END_DATE) THEN
431: IF (L_EMPLOYEE_STATUS =1) THEN
432: IF L_AUTO_ENROL_DATE IS NULL THEN
433: L_ERROR :=1; -- Qualified Yet Not Automatically Enrolled - Could be any reason like Postponement or Qualifying scheme already exists.
434: ELSIF L_AUTO_ENROL_DATE IS NOT NULL AND fnd_date.canonical_to_date(L_AUTO_ENROL_DATE) BETWEEN L_PRP_START_DATE AND L_PRP_END_DATE THEN
435: L_ERROR :=3; --Qualified and Automatically Enrolled
436: END IF;
437: END IF;
438: END IF;--Postponement
437: END IF;
438: END IF;--Postponement
439: END IF; --Opt Out
440: IF (L_EMPLOYEE_STATUS <>1) THEN
441: IF L_AUTO_ENROL_DATE IS NOT NULL AND fnd_date.canonical_to_date(L_AUTO_ENROL_DATE) BETWEEN L_PRP_START_DATE AND L_PRP_END_DATE THEN
442: L_ERROR :=2; -- Not qualified, but has been automatically enrolled.
443: END IF;
444: END IF;
445: RETURN NVL(L_ERROR,0);
929: -- setting the contexts
930: P_INPUTS(1).name := 'ASSIGNMENT_ID';
931: P_INPUTS(1).value := P_ASSIGNMENT_ID;
932: P_INPUTS(2).name := 'DATE_EARNED';
933: P_INPUTS(2).value := FND_DATE.DATE_TO_CANONICAL(G_PAYROLL_END_DATE);
934: P_INPUTS(3).name := 'BUSINESS_GROUP_ID';
935: P_INPUTS(3).value := G_BUSINESS_GROUP_ID;
936: P_INPUTS(4).name := 'PAYROLL_ID';
937: P_INPUTS(4).value := G_PAYROLL_ID;
945: P_INPUTS(7).value := NVL(l_original_entry_id, P_ELEM_ENTRY_ID);
946: -- Bug 14080693
947: --Bug 14615369
948: P_INPUTS(8).name := 'BALANCE_DATE';
949: P_INPUTS(8).value := FND_DATE.DATE_TO_CANONICAL(G_PAYROLL_END_DATE); -- Date Earned
950:
951: --Bug 14615369
952: OPEN C_ACTION_IDS(P_ASSIGNMENT_ID);
953: FETCH C_ACTION_IDS INTO C_ACTION_IDS_ROW;
1006: END IF;
1007: HR_UTILITY.trace(' PAYROLL_ACTION_ID '|| P_INPUTS(5).value);
1008: HR_UTILITY.trace(' ASSIGNMENT_ACTION_ID '||P_INPUTS(6).value );
1009: HR_UTILITY.trace(' p_assignment_id '||P_ASSIGNMENT_ID);
1010: HR_UTILITY.trace(' Date earned '|| FND_DATE.DATE_TO_CANONICAL(G_PRP_END_DATE));
1011: HR_UTILITY.trace(' p_payroll_id '||G_PAYROLL_ID);
1012: FF_EXEC.INIT_FORMULA(P_FORMULA_ID, G_PRP_END_DATE , L_INPUTS, L_OUTPUTS);
1013: HR_UTILITY.trace('L_INPUTS.COUNT Count:'||L_INPUTS.COUNT);
1014: HR_UTILITY.trace('P_INPUTS.COUNT Count:'||P_INPUTS.COUNT);
3080: L_POSTPONEMENT_TYPE , G_ELEMENT_DETAILS.G_POSTPONEMENT_END_DATE_ID, L_POSTPONEMENT_DATE , G_ELEMENT_DETAILS.G_EMPLOYEE_CLASS_ID, L_EMPLOYEE_CLASS_FOR_PENSION , G_ELEMENT_DETAILS.G_OPT_IN_DATE_ID,
3081: L_OPTIN_DATE , G_ELEMENT_DETAILS.G_OPT_OUT_DATE_ID, L_OPTOUT_DATE , G_ELEMENT_DETAILS.G_MAIN_ENTRY_ID, P_PENSION_INPUT_VALUES_DUMMY.G_MAIN_ENTRY -- Main Entry has to be retained as before
3082: , G_ELEMENT_DETAILS.G_TOTAL_EARNING_PRP_ID, L_EARNINGS , G_ELEMENT_DETAILS.G_OPT_OUT_END_DATE_ID, L_OPTOUT_END_DATE , G_ELEMENT_DETAILS.G_ELIGIBLE_JH_DATE_ID ,
3083: /*Bug 14622818*/
3084: to_char (l_eligible_jh_date ,fnd_date.name_in_mask) );
3085: hr_utility.trace('---------------------------------------------------------------------------------------------');
3086: END LOOP;
3087: END;
3088: PROCEDURE WRITE_OUTPUT
3136: IS
3137: SELECT PAI.ACTION_INFORMATION15 assignment_number,
3138: PAI.ACTION_INFORMATION14 full_name,
3139: NVL(PAI.ACTION_INFORMATION7,'NA') classification,
3140: NVL(TO_CHAR(fnd_date.canonical_to_date(PAI.ACTION_INFORMATION9)),'NA') auto_en_date
3141: FROM PAY_ACTION_INFORMATION PAI
3142: WHERE PAI.assignment_id =p_assignment_id
3143: AND PAI.ACTION_CONTEXT_ID =p_asg_actid
3144: AND PAI.ACTION_CONTEXT_TYPE='AAP';
3317: /* IF G_PENSION_STAGING_DATE IS NULL THEN
3318: fnd_file.put_line(fnd_file.OUTPUT,'Staging Date has not been Set.');
3319: RAISE_APPLICATION_ERROR (-20001,'Please enter a Staging Date.') ;
3320: END IF;
3321: IF (G_PRP_END_DATE < FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE)) THEN-- Staging Date
3322: fnd_file.put_line(fnd_file.OUTPUT,'Staging Date Not Yet Reached in this Pay Reference Period.');
3323: RAISE_APPLICATION_ERROR (-20001,'Please check the Staging Date / Default Pension Scheme if they are properly set up.') ;
3324: END IF;-- Staging Date
3325: bug 16178067 */
3495: --G_MODE='GB_VALIDATE_COMMIT')
3496: SELECT DECODE(G_MODE,'GB_VALIDATE','Validate Only','GB_VALIDATE_COMMIT','Validate and Commit','NA')
3497: INTO l_mode
3498: FROM DUAL;
3499: l_request_id := fnd_request.submit_request (application => 'PAY' ,program => 'PYGBPAER' ,argument1 => pactid ,argument2 =>fnd_date.date_to_canonical( G_PAYROLL_START_DATE) ,
3500: argument3 => fnd_date.date_to_canonical(G_PAYROLL_END_DATE) ,argument4 =>fnd_date.date_to_canonical( G_PRP_START_DATE) ,argument5 => fnd_date.date_to_canonical(G_PRP_END_DATE) ,
3501: argument6 => L_MODE ,argument7 => G_PAYROLL_NAME ,argument8 => G_PERIOD_NAME );
3502: -- Commit;
3503: IF l_request_id = 0 THEN
3496: SELECT DECODE(G_MODE,'GB_VALIDATE','Validate Only','GB_VALIDATE_COMMIT','Validate and Commit','NA')
3497: INTO l_mode
3498: FROM DUAL;
3499: l_request_id := fnd_request.submit_request (application => 'PAY' ,program => 'PYGBPAER' ,argument1 => pactid ,argument2 =>fnd_date.date_to_canonical( G_PAYROLL_START_DATE) ,
3500: argument3 => fnd_date.date_to_canonical(G_PAYROLL_END_DATE) ,argument4 =>fnd_date.date_to_canonical( G_PRP_START_DATE) ,argument5 => fnd_date.date_to_canonical(G_PRP_END_DATE) ,
3501: argument6 => L_MODE ,argument7 => G_PAYROLL_NAME ,argument8 => G_PERIOD_NAME );
3502: -- Commit;
3503: IF l_request_id = 0 THEN
3504: hr_utility.set_location('Error spawning new process',1);
3513: --G_MODE='GB_VALIDATE_COMMIT')
3514: SELECT DECODE(G_MODE,'GB_VALIDATE','Validate Only','GB_VALIDATE_COMMIT','Validate and Commit','NA')
3515: INTO l_mode
3516: FROM DUAL;
3517: l_request_id := fnd_request.submit_request (application => 'PAY' ,program => 'PYGBPAENR' ,argument1 => pactid ,argument2 =>fnd_date.date_to_canonical( G_PAYROLL_START_DATE) ,
3518: argument3 => fnd_date.date_to_canonical(G_PAYROLL_END_DATE) ,argument4 =>fnd_date.date_to_canonical( G_PRP_START_DATE) ,argument5 => fnd_date.date_to_canonical(G_PRP_END_DATE) ,
3519: argument6 => L_MODE ,argument7 => G_PAYROLL_NAME ,argument8 => G_PERIOD_NAME );
3520: -- Commit;
3521: IF l_request_id = 0 THEN
3514: SELECT DECODE(G_MODE,'GB_VALIDATE','Validate Only','GB_VALIDATE_COMMIT','Validate and Commit','NA')
3515: INTO l_mode
3516: FROM DUAL;
3517: l_request_id := fnd_request.submit_request (application => 'PAY' ,program => 'PYGBPAENR' ,argument1 => pactid ,argument2 =>fnd_date.date_to_canonical( G_PAYROLL_START_DATE) ,
3518: argument3 => fnd_date.date_to_canonical(G_PAYROLL_END_DATE) ,argument4 =>fnd_date.date_to_canonical( G_PRP_START_DATE) ,argument5 => fnd_date.date_to_canonical(G_PRP_END_DATE) ,
3519: argument6 => L_MODE ,argument7 => G_PAYROLL_NAME ,argument8 => G_PERIOD_NAME );
3520: -- Commit;
3521: IF l_request_id = 0 THEN
3522: hr_utility.set_location('Error spawning new process',1);
3532: --G_MODE='GB_VALIDATE_COMMIT')
3533: SELECT DECODE(G_MODE,'GB_VALIDATE','Validate Only','GB_VALIDATE_COMMIT','Validate and Commit','NA')
3534: INTO l_mode
3535: FROM DUAL;
3536: l_request_id := fnd_request.submit_request (application => 'PAY' ,program => 'PYGBPAEQ' ,argument1 => pactid ,argument2 =>fnd_date.date_to_canonical( G_PAYROLL_START_DATE) ,
3537: argument3 => fnd_date.date_to_canonical(G_PAYROLL_END_DATE) ,argument4 =>fnd_date.date_to_canonical( G_PRP_START_DATE) ,argument5 => fnd_date.date_to_canonical(G_PRP_END_DATE) ,
3538: argument6 => L_MODE ,argument7 => G_PAYROLL_NAME ,argument8 => G_PERIOD_NAME );
3539: -- Commit;
3540: IF l_request_id = 0 THEN
3533: SELECT DECODE(G_MODE,'GB_VALIDATE','Validate Only','GB_VALIDATE_COMMIT','Validate and Commit','NA')
3534: INTO l_mode
3535: FROM DUAL;
3536: l_request_id := fnd_request.submit_request (application => 'PAY' ,program => 'PYGBPAEQ' ,argument1 => pactid ,argument2 =>fnd_date.date_to_canonical( G_PAYROLL_START_DATE) ,
3537: argument3 => fnd_date.date_to_canonical(G_PAYROLL_END_DATE) ,argument4 =>fnd_date.date_to_canonical( G_PRP_START_DATE) ,argument5 => fnd_date.date_to_canonical(G_PRP_END_DATE) ,
3538: argument6 => L_MODE ,argument7 => G_PAYROLL_NAME ,argument8 => G_PERIOD_NAME );
3539: -- Commit;
3540: IF l_request_id = 0 THEN
3541: hr_utility.set_location('Error spawning new process',1);
3557: --To fetch the dates paid which do not have a payroll/assignment action for the assignment id as on period in which staging date falls
3558: -- to get prp_start_date , prp_end_date and regular_payment_date of period in which staging date falls
3559: CURSOR C_STAGING_PRP_PERIOD
3560: is
3561: select start_date , end_date , REGULAR_PAYMENT_DATE from per_time_periods where payroll_id = G_PAYROLL_ID and FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE) between START_DATE and END_DATE;
3562:
3563: CURSOR C_DATES_PAID_MISSED(L_PRP_END_DATE date, L_PRP_START_DATE date)
3564: IS
3565: SELECT TIME_PERIOD_ID,
3794: L_DATE_OF_BIRTH PER_ALL_PEOPLE_F.DATE_OF_BIRTH%type;
3795: L_NUM_DATE_BIRTH VARCHAR2(10);
3796: CURSOR C_AGE_SEX
3797: IS
3798: SELECT MONTHS_BETWEEN(FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE),DATE_OF_BIRTH)/12,
3799: DATE_OF_BIRTH,
3800: SEX
3801: FROM PER_ALL_PEOPLE_F
3802: WHERE PERSON_ID = P_PERSON_ID;
4153: AND PCV.PCV_INFORMATION2 = PETF.ELEMENT_NAME
4154: AND PETF.BUSINESS_GROUP_ID = G_BUSINESS_GROUP_ID
4155: AND PEEF.ELEMENT_TYPE_ID = PETF.ELEMENT_TYPE_ID
4156: AND PEEF.ASSIGNMENT_ID = P_ASSIGNMENT_ID
4157: AND FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE) BETWEEN PETF.EFFECTIVE_START_DATE AND PETF.EFFECTIVE_END_DATE
4158: AND FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE) BETWEEN PEEF.EFFECTIVE_START_DATE AND PEEF.EFFECTIVE_END_DATE
4159: ORDER BY PETF.EFFECTIVE_START_DATE DESC;
4160:
4161: /*
4154: AND PETF.BUSINESS_GROUP_ID = G_BUSINESS_GROUP_ID
4155: AND PEEF.ELEMENT_TYPE_ID = PETF.ELEMENT_TYPE_ID
4156: AND PEEF.ASSIGNMENT_ID = P_ASSIGNMENT_ID
4157: AND FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE) BETWEEN PETF.EFFECTIVE_START_DATE AND PETF.EFFECTIVE_END_DATE
4158: AND FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE) BETWEEN PEEF.EFFECTIVE_START_DATE AND PEEF.EFFECTIVE_END_DATE
4159: ORDER BY PETF.EFFECTIVE_START_DATE DESC;
4160:
4161: /*
4162: CURSOR C_ERROR_MSG IS
4334: populate_run_msg(p_assactid,'Staging Date has not been set for this employee at any level, hence this assignment is being skipped.');
4335: hr_utility.trace('Staging Date has not been Set.');
4336: RAISE L_EXCEPTION_NO_ERROR;
4337: END IF;
4338: IF (G_PRP_END_DATE < FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE)) THEN-- Staging Date
4339: populate_run_msg(p_assactid,'Staging Date not yet reached for this employee, hence this assignment is being skipped.');
4340: hr_utility.trace('Staging Date Not Yet Reached for this employee.');
4341: RAISE L_EXCEPTION_NO_ERROR;
4342: END IF;
4379: ---CHECK
4380: --Assignment to Local Variables
4381: L_QUALIFYING_SCHEME_NAME :=P_PENSION_INPUT_VALUES.G_QUALIFYING_SCHEME_NAME;
4382: L_AGGREGATION_FLAG :=P_PENSION_INPUT_VALUES.G_AGG_EARNINGS_PENSIONS;
4383: L_AUTO_ENROLLMENT_DATE :=fnd_date.canonical_to_date(P_PENSION_INPUT_VALUES.G_AUTO_ENROLLMENT_DATE);
4384: L_QUALIFYING_SCHEME_EXISTS :=P_PENSION_INPUT_VALUES.G_QUALIFYING_PS_EXISTS;
4385: L_POSTPONEMENT_TYPE :=P_PENSION_INPUT_VALUES.G_POSTPONEMENT_TYPE;
4386: L_POSTPONEMENT_DATE :=fnd_date.canonical_to_date(P_PENSION_INPUT_VALUES.G_POSTPONEMENT_END_DATE);
4387: L_EMPLOYEE_CLASS_FOR_PENSION :=P_PENSION_INPUT_VALUES.G_EMPLOYEE_CLASS;
4382: L_AGGREGATION_FLAG :=P_PENSION_INPUT_VALUES.G_AGG_EARNINGS_PENSIONS;
4383: L_AUTO_ENROLLMENT_DATE :=fnd_date.canonical_to_date(P_PENSION_INPUT_VALUES.G_AUTO_ENROLLMENT_DATE);
4384: L_QUALIFYING_SCHEME_EXISTS :=P_PENSION_INPUT_VALUES.G_QUALIFYING_PS_EXISTS;
4385: L_POSTPONEMENT_TYPE :=P_PENSION_INPUT_VALUES.G_POSTPONEMENT_TYPE;
4386: L_POSTPONEMENT_DATE :=fnd_date.canonical_to_date(P_PENSION_INPUT_VALUES.G_POSTPONEMENT_END_DATE);
4387: L_EMPLOYEE_CLASS_FOR_PENSION :=P_PENSION_INPUT_VALUES.G_EMPLOYEE_CLASS;
4388: L_OPTIN_DATE :=fnd_date.canonical_to_date(P_PENSION_INPUT_VALUES.G_OPT_IN_DATE);
4389: L_OPTOUT_DATE :=fnd_date.canonical_to_date(P_PENSION_INPUT_VALUES.G_OPT_OUT_DATE);
4390: L_MAIN_ENTRY :=P_PENSION_INPUT_VALUES.G_MAIN_ENTRY;
4384: L_QUALIFYING_SCHEME_EXISTS :=P_PENSION_INPUT_VALUES.G_QUALIFYING_PS_EXISTS;
4385: L_POSTPONEMENT_TYPE :=P_PENSION_INPUT_VALUES.G_POSTPONEMENT_TYPE;
4386: L_POSTPONEMENT_DATE :=fnd_date.canonical_to_date(P_PENSION_INPUT_VALUES.G_POSTPONEMENT_END_DATE);
4387: L_EMPLOYEE_CLASS_FOR_PENSION :=P_PENSION_INPUT_VALUES.G_EMPLOYEE_CLASS;
4388: L_OPTIN_DATE :=fnd_date.canonical_to_date(P_PENSION_INPUT_VALUES.G_OPT_IN_DATE);
4389: L_OPTOUT_DATE :=fnd_date.canonical_to_date(P_PENSION_INPUT_VALUES.G_OPT_OUT_DATE);
4390: L_MAIN_ENTRY :=P_PENSION_INPUT_VALUES.G_MAIN_ENTRY;
4391: L_EARNINGS :=P_PENSION_INPUT_VALUES.G_TOTAL_EARNING_PRP;
4392: L_OPTOUT_END_DATE :=fnd_date.canonical_to_date(P_PENSION_INPUT_VALUES.G_OPT_OUT_END_DATE);
4385: L_POSTPONEMENT_TYPE :=P_PENSION_INPUT_VALUES.G_POSTPONEMENT_TYPE;
4386: L_POSTPONEMENT_DATE :=fnd_date.canonical_to_date(P_PENSION_INPUT_VALUES.G_POSTPONEMENT_END_DATE);
4387: L_EMPLOYEE_CLASS_FOR_PENSION :=P_PENSION_INPUT_VALUES.G_EMPLOYEE_CLASS;
4388: L_OPTIN_DATE :=fnd_date.canonical_to_date(P_PENSION_INPUT_VALUES.G_OPT_IN_DATE);
4389: L_OPTOUT_DATE :=fnd_date.canonical_to_date(P_PENSION_INPUT_VALUES.G_OPT_OUT_DATE);
4390: L_MAIN_ENTRY :=P_PENSION_INPUT_VALUES.G_MAIN_ENTRY;
4391: L_EARNINGS :=P_PENSION_INPUT_VALUES.G_TOTAL_EARNING_PRP;
4392: L_OPTOUT_END_DATE :=fnd_date.canonical_to_date(P_PENSION_INPUT_VALUES.G_OPT_OUT_END_DATE);
4393: L_ELIGIBLE_JH_DATE :=fnd_date.canonical_to_date(P_PENSION_INPUT_VALUES.G_ELIGIBLE_JH_DATE);
4388: L_OPTIN_DATE :=fnd_date.canonical_to_date(P_PENSION_INPUT_VALUES.G_OPT_IN_DATE);
4389: L_OPTOUT_DATE :=fnd_date.canonical_to_date(P_PENSION_INPUT_VALUES.G_OPT_OUT_DATE);
4390: L_MAIN_ENTRY :=P_PENSION_INPUT_VALUES.G_MAIN_ENTRY;
4391: L_EARNINGS :=P_PENSION_INPUT_VALUES.G_TOTAL_EARNING_PRP;
4392: L_OPTOUT_END_DATE :=fnd_date.canonical_to_date(P_PENSION_INPUT_VALUES.G_OPT_OUT_END_DATE);
4393: L_ELIGIBLE_JH_DATE :=fnd_date.canonical_to_date(P_PENSION_INPUT_VALUES.G_ELIGIBLE_JH_DATE);
4394: --New Worker or Staging Date
4395: OPEN C_SERVICE_START (L_PERSON_ID) ;
4396: FETCH C_SERVICE_START INTO L_SERVICE_START;
4389: L_OPTOUT_DATE :=fnd_date.canonical_to_date(P_PENSION_INPUT_VALUES.G_OPT_OUT_DATE);
4390: L_MAIN_ENTRY :=P_PENSION_INPUT_VALUES.G_MAIN_ENTRY;
4391: L_EARNINGS :=P_PENSION_INPUT_VALUES.G_TOTAL_EARNING_PRP;
4392: L_OPTOUT_END_DATE :=fnd_date.canonical_to_date(P_PENSION_INPUT_VALUES.G_OPT_OUT_END_DATE);
4393: L_ELIGIBLE_JH_DATE :=fnd_date.canonical_to_date(P_PENSION_INPUT_VALUES.G_ELIGIBLE_JH_DATE);
4394: --New Worker or Staging Date
4395: OPEN C_SERVICE_START (L_PERSON_ID) ;
4396: FETCH C_SERVICE_START INTO L_SERVICE_START;
4397: CLOSE C_SERVICE_START;
4441: /*Bug 14622818 Modified the condition*/
4442: IF (L_ELIGIBLE_JH_DATE IS NOT NULL and l_eligible_jh_date <> hr_api.g_eot) THEN
4443: L_MAX_POSTPO_DATE := L_ELIGIBLE_JH_DATE;
4444: ELSE
4445: L_MAX_POSTPO_DATE := GREATEST(L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE));
4446: END IF;
4447: hr_utility.trace('L_MAX_POSTPO_DATE Value::'||L_MAX_POSTPO_DATE);
4448: IF (ADD_MONTHS(L_MAX_POSTPO_DATE,3) - 1 ) < L_POSTPONEMENT_DATE THEN
4449: hr_utility.trace('More than three months postponement - error');
4589: /*Bug 14622818 Modified the condition*/
4590: IF l_eligible_jh_date IS NULL then
4591: hr_utility.trace ('Eligible Job Holder Date is not already set, means employee assessed for the first time');
4592: l_eligible_jh_date := hr_api.g_eot;
4593: /*IF ((FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE) BETWEEN G_PRP_START_DATE AND G_PRP_END_DATE) OR ( L_SERVICE_START BETWEEN G_PRP_START_DATE AND G_PRP_END_DATE))THEN*/
4594: IF(NVL(G_WORKER_POSTPONEMENT_RULE,'NONE')='NONE') THEN
4595: L_WORKER_POSTP_FLAG := 'N';
4596: ELSE
4597: l_postponement_date := C_PAYROLL_MAX_DATE(GREATEST(L_SERVICE_START,l_asg_start_date,FND_DATE.canonical_to_date( G_PENSION_STAGING_DATE) ),G_WORKER_POSTPONEMENT_RULE);
4593: /*IF ((FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE) BETWEEN G_PRP_START_DATE AND G_PRP_END_DATE) OR ( L_SERVICE_START BETWEEN G_PRP_START_DATE AND G_PRP_END_DATE))THEN*/
4594: IF(NVL(G_WORKER_POSTPONEMENT_RULE,'NONE')='NONE') THEN
4595: L_WORKER_POSTP_FLAG := 'N';
4596: ELSE
4597: l_postponement_date := C_PAYROLL_MAX_DATE(GREATEST(L_SERVICE_START,l_asg_start_date,FND_DATE.canonical_to_date( G_PENSION_STAGING_DATE) ),G_WORKER_POSTPONEMENT_RULE);
4598:
4599: l_worker_postp_flag := 'Y';
4600:
4601: IF l_postponement_date < g_prp_end_date THEN
4606: END IF;
4607: End if;
4608: /* ELSIF (G_WORKER_POSTPONEMENT_RULE ='MAX_DEFER_PERIOD_START_DATE') THEN
4609: L_POSTPONEMENT_DATE := ADD_MONTHS(G_PRP_START_DATE,3)-1;
4610: IF ( FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE) BETWEEN G_PRP_START_DATE AND G_PRP_END_DATE) THEN
4611: L_POSTPONEMENT_DATE := C_PAYROLL_MAX_DATE (FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE));
4612: ELSIF (L_SERVICE_START BETWEEN G_PRP_START_DATE AND G_PRP_END_DATE) THEN
4613: L_POSTPONEMENT_DATE := C_PAYROLL_MAX_DATE (L_SERVICE_START);
4614: ELSE
4607: End if;
4608: /* ELSIF (G_WORKER_POSTPONEMENT_RULE ='MAX_DEFER_PERIOD_START_DATE') THEN
4609: L_POSTPONEMENT_DATE := ADD_MONTHS(G_PRP_START_DATE,3)-1;
4610: IF ( FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE) BETWEEN G_PRP_START_DATE AND G_PRP_END_DATE) THEN
4611: L_POSTPONEMENT_DATE := C_PAYROLL_MAX_DATE (FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE));
4612: ELSIF (L_SERVICE_START BETWEEN G_PRP_START_DATE AND G_PRP_END_DATE) THEN
4613: L_POSTPONEMENT_DATE := C_PAYROLL_MAX_DATE (L_SERVICE_START);
4614: ELSE
4615: L_POSTPONEMENT_DATE := C_PAYROLL_MAX_DATE (G_PRP_START_DATE);
4614: ELSE
4615: L_POSTPONEMENT_DATE := C_PAYROLL_MAX_DATE (G_PRP_START_DATE);
4616: END IF;
4617: l_postponement_date := c_payroll_max_date (greatest (l_service_start
4618: ,fnd_date.canonical_to_date (g_pension_staging_date)));
4619: L_WORKER_POSTP_FLAG := 'Y';
4620: IF l_postponement_date < g_prp_end_date THEN --Bug 14622818
4621: l_worker_postp_flag := 'N';
4622: l_postponement_date := NULL;
4622: l_postponement_date := NULL;
4623: END IF;
4624:
4625: ELSIF (G_WORKER_POSTPONEMENT_RULE ='NEXT_PAYROLL_PERIOD_START_DATE') THEN
4626: l_postponement_date := ADD_MONTHS(GREATEST(L_SERVICE_START,FND_DATE.canonical_to_date( G_PENSION_STAGING_DATE) ),1)-1;
4627: l_worker_postp_flag := 'Y';
4628:
4629: IF l_postponement_date < g_prp_end_date THEN--Bug 14622818
4630: l_worker_postp_flag := 'N';
4714: L_EMPLOYEE_CLASS_FOR_PENSION :='Eligible Job Holder';
4715: hr_utility.trace('Person Id'|| L_PERSON_ID);
4716: IF NVL(L_ELIGIBLE_JH_DATE,G_END_OF_TIME) = G_END_OF_TIME THEN -- Never Found eligible
4717: IF (L_DOB_TT BETWEEN G_PRP_START_DATE AND G_PRP_END_DATE) THEN
4718: L_ELIGIBLE_JH_DATE := GREATEST(L_DOB_TT,L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE),nvl(FND_DATE.canonical_to_date(L_POSTPONEMENT_DATE)+1,to_date('0001-01-01','YYYY-MM-DD')));
4719: --L_ELIGIBLE_JH_DATE := GREATEST(L_DOB_TT,L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE));
4720: ELSE
4721: L_ELIGIBLE_JH_DATE := GREATEST(G_PRP_START_DATE,L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE),nvl(FND_DATE.canonical_to_date(L_POSTPONEMENT_DATE)+1,to_date('0001-01-01','YYYY-MM-DD')));
4722: --L_ELIGIBLE_JH_DATE := GREATEST(G_PRP_START_DATE,L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE));
4715: hr_utility.trace('Person Id'|| L_PERSON_ID);
4716: IF NVL(L_ELIGIBLE_JH_DATE,G_END_OF_TIME) = G_END_OF_TIME THEN -- Never Found eligible
4717: IF (L_DOB_TT BETWEEN G_PRP_START_DATE AND G_PRP_END_DATE) THEN
4718: L_ELIGIBLE_JH_DATE := GREATEST(L_DOB_TT,L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE),nvl(FND_DATE.canonical_to_date(L_POSTPONEMENT_DATE)+1,to_date('0001-01-01','YYYY-MM-DD')));
4719: --L_ELIGIBLE_JH_DATE := GREATEST(L_DOB_TT,L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE));
4720: ELSE
4721: L_ELIGIBLE_JH_DATE := GREATEST(G_PRP_START_DATE,L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE),nvl(FND_DATE.canonical_to_date(L_POSTPONEMENT_DATE)+1,to_date('0001-01-01','YYYY-MM-DD')));
4722: --L_ELIGIBLE_JH_DATE := GREATEST(G_PRP_START_DATE,L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE));
4723: END IF;
4717: IF (L_DOB_TT BETWEEN G_PRP_START_DATE AND G_PRP_END_DATE) THEN
4718: L_ELIGIBLE_JH_DATE := GREATEST(L_DOB_TT,L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE),nvl(FND_DATE.canonical_to_date(L_POSTPONEMENT_DATE)+1,to_date('0001-01-01','YYYY-MM-DD')));
4719: --L_ELIGIBLE_JH_DATE := GREATEST(L_DOB_TT,L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE));
4720: ELSE
4721: L_ELIGIBLE_JH_DATE := GREATEST(G_PRP_START_DATE,L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE),nvl(FND_DATE.canonical_to_date(L_POSTPONEMENT_DATE)+1,to_date('0001-01-01','YYYY-MM-DD')));
4722: --L_ELIGIBLE_JH_DATE := GREATEST(G_PRP_START_DATE,L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE));
4723: END IF;
4724: END IF;
4725: -- Found Eligible previously
4718: L_ELIGIBLE_JH_DATE := GREATEST(L_DOB_TT,L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE),nvl(FND_DATE.canonical_to_date(L_POSTPONEMENT_DATE)+1,to_date('0001-01-01','YYYY-MM-DD')));
4719: --L_ELIGIBLE_JH_DATE := GREATEST(L_DOB_TT,L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE));
4720: ELSE
4721: L_ELIGIBLE_JH_DATE := GREATEST(G_PRP_START_DATE,L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE),nvl(FND_DATE.canonical_to_date(L_POSTPONEMENT_DATE)+1,to_date('0001-01-01','YYYY-MM-DD')));
4722: --L_ELIGIBLE_JH_DATE := GREATEST(G_PRP_START_DATE,L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE));
4723: END IF;
4724: END IF;
4725: -- Found Eligible previously
4726: -- IF (L_ELIGIBLE_JH_DATE IS NOT NULL ) THEN -- Bug 13945549
4726: -- IF (L_ELIGIBLE_JH_DATE IS NOT NULL ) THEN -- Bug 13945549
4727: IF NVL(L_ELIGIBLE_JH_DATE,G_END_OF_TIME) <> G_END_OF_TIME THEN
4728: -- IF (G_PRP_START_DATE-1)=L_POSTPONEMENT_DATE THEN -- To check if Last Period was the period when the assignment was first assessed as EJH
4729: IF (L_POSTPONEMENT_DATE IS NOT NULL ) AND L_POSTPONEMENT_TYPE = 'Eligible Job Holder Postponement' AND (L_POSTPONEMENT_DATE< GREATEST(G_PRP_START_DATE,L_DOB_TT,
4730: L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE))-1)THEN
4731: hr_utility.trace('One Day after the postponement end date , this PRP starts.');
4732: -- ELSE
4733: IF (L_DOB_TT BETWEEN G_PRP_START_DATE AND G_PRP_END_DATE) THEN
4734: L_ELIGIBLE_JH_DATE := GREATEST(L_DOB_TT,L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE),nvl(FND_DATE.canonical_to_date(L_POSTPONEMENT_DATE)+1,to_date('0001-01-01','YYYY-MM-DD')));
4730: L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE))-1)THEN
4731: hr_utility.trace('One Day after the postponement end date , this PRP starts.');
4732: -- ELSE
4733: IF (L_DOB_TT BETWEEN G_PRP_START_DATE AND G_PRP_END_DATE) THEN
4734: L_ELIGIBLE_JH_DATE := GREATEST(L_DOB_TT,L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE),nvl(FND_DATE.canonical_to_date(L_POSTPONEMENT_DATE)+1,to_date('0001-01-01','YYYY-MM-DD')));
4735: --L_ELIGIBLE_JH_DATE := GREATEST(L_DOB_TT,L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE));
4736: ELSE
4737: L_ELIGIBLE_JH_DATE := GREATEST(G_PRP_START_DATE,L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE),nvl(FND_DATE.canonical_to_date(L_POSTPONEMENT_DATE)+1,to_date('0001-01-01','YYYY-MM-DD')));
4738: --L_ELIGIBLE_JH_DATE := GREATEST(G_PRP_START_DATE,L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE));
4731: hr_utility.trace('One Day after the postponement end date , this PRP starts.');
4732: -- ELSE
4733: IF (L_DOB_TT BETWEEN G_PRP_START_DATE AND G_PRP_END_DATE) THEN
4734: L_ELIGIBLE_JH_DATE := GREATEST(L_DOB_TT,L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE),nvl(FND_DATE.canonical_to_date(L_POSTPONEMENT_DATE)+1,to_date('0001-01-01','YYYY-MM-DD')));
4735: --L_ELIGIBLE_JH_DATE := GREATEST(L_DOB_TT,L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE));
4736: ELSE
4737: L_ELIGIBLE_JH_DATE := GREATEST(G_PRP_START_DATE,L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE),nvl(FND_DATE.canonical_to_date(L_POSTPONEMENT_DATE)+1,to_date('0001-01-01','YYYY-MM-DD')));
4738: --L_ELIGIBLE_JH_DATE := GREATEST(G_PRP_START_DATE,L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE));
4739: END IF;
4733: IF (L_DOB_TT BETWEEN G_PRP_START_DATE AND G_PRP_END_DATE) THEN
4734: L_ELIGIBLE_JH_DATE := GREATEST(L_DOB_TT,L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE),nvl(FND_DATE.canonical_to_date(L_POSTPONEMENT_DATE)+1,to_date('0001-01-01','YYYY-MM-DD')));
4735: --L_ELIGIBLE_JH_DATE := GREATEST(L_DOB_TT,L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE));
4736: ELSE
4737: L_ELIGIBLE_JH_DATE := GREATEST(G_PRP_START_DATE,L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE),nvl(FND_DATE.canonical_to_date(L_POSTPONEMENT_DATE)+1,to_date('0001-01-01','YYYY-MM-DD')));
4738: --L_ELIGIBLE_JH_DATE := GREATEST(G_PRP_START_DATE,L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE));
4739: END IF;
4740: END IF;
4741: END IF;
4734: L_ELIGIBLE_JH_DATE := GREATEST(L_DOB_TT,L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE),nvl(FND_DATE.canonical_to_date(L_POSTPONEMENT_DATE)+1,to_date('0001-01-01','YYYY-MM-DD')));
4735: --L_ELIGIBLE_JH_DATE := GREATEST(L_DOB_TT,L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE));
4736: ELSE
4737: L_ELIGIBLE_JH_DATE := GREATEST(G_PRP_START_DATE,L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE),nvl(FND_DATE.canonical_to_date(L_POSTPONEMENT_DATE)+1,to_date('0001-01-01','YYYY-MM-DD')));
4738: --L_ELIGIBLE_JH_DATE := GREATEST(G_PRP_START_DATE,L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE));
4739: END IF;
4740: END IF;
4741: END IF;
4742: IF (L_NOMINAL_FLAG ='N') THEN --Nominal Check
4754: --Greatest() -- Needed in cases where EJH is retained from the previous run itself.
4755: hr_utility.trace('G_PRP_START_DATE:: '||G_PRP_START_DATE);
4756: hr_utility.trace('L_ELIGIBLE_JH_DATE:: '||L_ELIGIBLE_JH_DATE);
4757: hr_utility.trace('L_POSTPONEMENT_DATE:: '||L_POSTPONEMENT_DATE);
4758: IF (L_POSTPONEMENT_DATE IS NOT NULL ) AND (L_POSTPONEMENT_DATE< GREATEST(G_PRP_START_DATE,L_DOB_TT,L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE),L_ELIGIBLE_JH_DATE)-1) THEN
4759: L_EJH_POSTP_FLAG := 'Y';
4760: hr_utility.trace('CAREFUL!! Worker Postp applied before One Day ');
4761: ELSIF L_POSTPONEMENT_DATE IS NULL THEN
4762: L_EJH_POSTP_FLAG := 'Y';
4824: END IF; --Nominal Check
4825: hr_utility.trace('NOMINAL FLAG::'||L_NOMINAL_FLAG);
4826: IF (L_NOMINAL_FLAG ='Y') THEN
4827: IF (L_DOB_TT BETWEEN G_PRP_START_DATE AND G_PRP_END_DATE) THEN
4828: L_NOMINAL_AUTO_ENROLL_DATE := GREATEST(L_DOB_TT,L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE));
4829: ELSE
4830: L_NOMINAL_AUTO_ENROLL_DATE := GREATEST(G_PRP_START_DATE,L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE));
4831: END IF;
4832: --Bug 14387977
4826: IF (L_NOMINAL_FLAG ='Y') THEN
4827: IF (L_DOB_TT BETWEEN G_PRP_START_DATE AND G_PRP_END_DATE) THEN
4828: L_NOMINAL_AUTO_ENROLL_DATE := GREATEST(L_DOB_TT,L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE));
4829: ELSE
4830: L_NOMINAL_AUTO_ENROLL_DATE := GREATEST(G_PRP_START_DATE,L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE));
4831: END IF;
4832: --Bug 14387977
4833: IF L_POSTPONEMENT_DATE IS NOT NULL THEN
4834: L_NOMINAL_AUTO_ENROLL_DATE := GREATEST(L_NOMINAL_AUTO_ENROLL_DATE,L_POSTPONEMENT_DATE+1);
4838: END IF;
4839: -- Check for Eligible Job Holder Postponement to be ADDED Here
4840: IF(L_EJH_POSTP_FLAG = 'N') AND (L_NOMINAL_FLAG ='N') THEN --EJH Postponement is not there
4841: IF (L_DOB_TT BETWEEN G_PRP_START_DATE AND G_PRP_END_DATE) THEN
4842: L_AUTO_ENROLLMENT_DATE := GREATEST(L_DOB_TT,l_asg_start_date,L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE));
4843: ELSE
4844: L_AUTO_ENROLLMENT_DATE :=GREATEST(G_PRP_START_DATE,l_asg_start_date,L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE));
4845: END IF;
4846: -- Bug 14387977
4840: IF(L_EJH_POSTP_FLAG = 'N') AND (L_NOMINAL_FLAG ='N') THEN --EJH Postponement is not there
4841: IF (L_DOB_TT BETWEEN G_PRP_START_DATE AND G_PRP_END_DATE) THEN
4842: L_AUTO_ENROLLMENT_DATE := GREATEST(L_DOB_TT,l_asg_start_date,L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE));
4843: ELSE
4844: L_AUTO_ENROLLMENT_DATE :=GREATEST(G_PRP_START_DATE,l_asg_start_date,L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE));
4845: END IF;
4846: -- Bug 14387977
4847: IF L_POSTPONEMENT_DATE IS NOT NULL THEN
4848: L_AUTO_ENROLLMENT_DATE := GREATEST(L_AUTO_ENROLLMENT_DATE,L_POSTPONEMENT_DATE+1);
4892:
4893: hr_utility.trace('L_QUALIFYING_SCHEME_NAME :'||L_QUALIFYING_SCHEME_NAME);
4894:
4895: if l_postponement_date < g_prp_end_date and g_prp_start_date < l_postponement_date then
4896: l_custom_eff_date := GREATEST(l_postponement_date+1,L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE));
4897: else
4898: l_custom_eff_date := GREATEST(L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE));
4899: end if;
4900:
4894:
4895: if l_postponement_date < g_prp_end_date and g_prp_start_date < l_postponement_date then
4896: l_custom_eff_date := GREATEST(l_postponement_date+1,L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE));
4897: else
4898: l_custom_eff_date := GREATEST(L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE));
4899: end if;
4900:
4901: open C_VALIDATE_CONFIG_VALUE('PAY_GB_ENROLMENT_CUSTOM_PROC',L_QUALIFYING_SCHEME_NAME);
4902: fetch C_VALIDATE_CONFIG_VALUE into l_custom_procedure;
4994: hr_utility.trace('Employee assessed again as there is a change in pensions classification/Earnings');
4995: if (NVL(L_EMPLOYEE_STATUS_FOR_PENSION,'3')='1') THEN
4996: IF NVL(L_ELIGIBLE_JH_DATE,G_END_OF_TIME) = G_END_OF_TIME THEN -- Never Found eligible
4997: IF (L_DOB_TT BETWEEN G_PRP_START_DATE AND G_PRP_END_DATE) THEN
4998: L_ELIGIBLE_JH_DATE := GREATEST(L_DOB_TT,L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE),
4999: nvl(FND_DATE.canonical_to_date(L_POSTPONEMENT_DATE)+1,to_date('0001-01-01','YYYY-MM-DD')));
5000: ELSE
5001: L_ELIGIBLE_JH_DATE := GREATEST(G_PRP_START_DATE,L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE),
5002: nvl(FND_DATE.canonical_to_date(L_POSTPONEMENT_DATE)+1,to_date('0001-01-01','YYYY-MM-DD')));
4995: if (NVL(L_EMPLOYEE_STATUS_FOR_PENSION,'3')='1') THEN
4996: IF NVL(L_ELIGIBLE_JH_DATE,G_END_OF_TIME) = G_END_OF_TIME THEN -- Never Found eligible
4997: IF (L_DOB_TT BETWEEN G_PRP_START_DATE AND G_PRP_END_DATE) THEN
4998: L_ELIGIBLE_JH_DATE := GREATEST(L_DOB_TT,L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE),
4999: nvl(FND_DATE.canonical_to_date(L_POSTPONEMENT_DATE)+1,to_date('0001-01-01','YYYY-MM-DD')));
5000: ELSE
5001: L_ELIGIBLE_JH_DATE := GREATEST(G_PRP_START_DATE,L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE),
5002: nvl(FND_DATE.canonical_to_date(L_POSTPONEMENT_DATE)+1,to_date('0001-01-01','YYYY-MM-DD')));
5003: END IF;
4997: IF (L_DOB_TT BETWEEN G_PRP_START_DATE AND G_PRP_END_DATE) THEN
4998: L_ELIGIBLE_JH_DATE := GREATEST(L_DOB_TT,L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE),
4999: nvl(FND_DATE.canonical_to_date(L_POSTPONEMENT_DATE)+1,to_date('0001-01-01','YYYY-MM-DD')));
5000: ELSE
5001: L_ELIGIBLE_JH_DATE := GREATEST(G_PRP_START_DATE,L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE),
5002: nvl(FND_DATE.canonical_to_date(L_POSTPONEMENT_DATE)+1,to_date('0001-01-01','YYYY-MM-DD')));
5003: END IF;
5004: END IF;
5005: -- Found Eligible previously
4998: L_ELIGIBLE_JH_DATE := GREATEST(L_DOB_TT,L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE),
4999: nvl(FND_DATE.canonical_to_date(L_POSTPONEMENT_DATE)+1,to_date('0001-01-01','YYYY-MM-DD')));
5000: ELSE
5001: L_ELIGIBLE_JH_DATE := GREATEST(G_PRP_START_DATE,L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE),
5002: nvl(FND_DATE.canonical_to_date(L_POSTPONEMENT_DATE)+1,to_date('0001-01-01','YYYY-MM-DD')));
5003: END IF;
5004: END IF;
5005: -- Found Eligible previously
5006: IF NVL(L_ELIGIBLE_JH_DATE,G_END_OF_TIME) <> G_END_OF_TIME THEN
5004: END IF;
5005: -- Found Eligible previously
5006: IF NVL(L_ELIGIBLE_JH_DATE,G_END_OF_TIME) <> G_END_OF_TIME THEN
5007: IF (L_POSTPONEMENT_DATE IS NOT NULL ) AND L_POSTPONEMENT_TYPE = 'Eligible Job Holder Postponement' AND
5008: (L_POSTPONEMENT_DATE< GREATEST(G_PRP_START_DATE,L_DOB_TT,L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE))-1)THEN
5009: hr_utility.trace('One Day after the postponement end date , this PRP starts.');
5010: IF (L_DOB_TT BETWEEN G_PRP_START_DATE AND G_PRP_END_DATE) THEN
5011: L_ELIGIBLE_JH_DATE := GREATEST(L_DOB_TT,L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE),
5012: nvl(FND_DATE.canonical_to_date(L_POSTPONEMENT_DATE)+1,to_date('0001-01-01','YYYY-MM-DD')));
5007: IF (L_POSTPONEMENT_DATE IS NOT NULL ) AND L_POSTPONEMENT_TYPE = 'Eligible Job Holder Postponement' AND
5008: (L_POSTPONEMENT_DATE< GREATEST(G_PRP_START_DATE,L_DOB_TT,L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE))-1)THEN
5009: hr_utility.trace('One Day after the postponement end date , this PRP starts.');
5010: IF (L_DOB_TT BETWEEN G_PRP_START_DATE AND G_PRP_END_DATE) THEN
5011: L_ELIGIBLE_JH_DATE := GREATEST(L_DOB_TT,L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE),
5012: nvl(FND_DATE.canonical_to_date(L_POSTPONEMENT_DATE)+1,to_date('0001-01-01','YYYY-MM-DD')));
5013: ELSE
5014: L_ELIGIBLE_JH_DATE := GREATEST(G_PRP_START_DATE,L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE),
5015: nvl(FND_DATE.canonical_to_date(L_POSTPONEMENT_DATE)+1,to_date('0001-01-01','YYYY-MM-DD')));
5008: (L_POSTPONEMENT_DATE< GREATEST(G_PRP_START_DATE,L_DOB_TT,L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE))-1)THEN
5009: hr_utility.trace('One Day after the postponement end date , this PRP starts.');
5010: IF (L_DOB_TT BETWEEN G_PRP_START_DATE AND G_PRP_END_DATE) THEN
5011: L_ELIGIBLE_JH_DATE := GREATEST(L_DOB_TT,L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE),
5012: nvl(FND_DATE.canonical_to_date(L_POSTPONEMENT_DATE)+1,to_date('0001-01-01','YYYY-MM-DD')));
5013: ELSE
5014: L_ELIGIBLE_JH_DATE := GREATEST(G_PRP_START_DATE,L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE),
5015: nvl(FND_DATE.canonical_to_date(L_POSTPONEMENT_DATE)+1,to_date('0001-01-01','YYYY-MM-DD')));
5016: END IF;
5010: IF (L_DOB_TT BETWEEN G_PRP_START_DATE AND G_PRP_END_DATE) THEN
5011: L_ELIGIBLE_JH_DATE := GREATEST(L_DOB_TT,L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE),
5012: nvl(FND_DATE.canonical_to_date(L_POSTPONEMENT_DATE)+1,to_date('0001-01-01','YYYY-MM-DD')));
5013: ELSE
5014: L_ELIGIBLE_JH_DATE := GREATEST(G_PRP_START_DATE,L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE),
5015: nvl(FND_DATE.canonical_to_date(L_POSTPONEMENT_DATE)+1,to_date('0001-01-01','YYYY-MM-DD')));
5016: END IF;
5017: END IF;
5018: end if;
5011: L_ELIGIBLE_JH_DATE := GREATEST(L_DOB_TT,L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE),
5012: nvl(FND_DATE.canonical_to_date(L_POSTPONEMENT_DATE)+1,to_date('0001-01-01','YYYY-MM-DD')));
5013: ELSE
5014: L_ELIGIBLE_JH_DATE := GREATEST(G_PRP_START_DATE,L_SERVICE_START,FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE),
5015: nvl(FND_DATE.canonical_to_date(L_POSTPONEMENT_DATE)+1,to_date('0001-01-01','YYYY-MM-DD')));
5016: END IF;
5017: END IF;
5018: end if;
5019: end if;
5059: L_POSTPONEMENT_TYPE , G_ELEMENT_DETAILS.G_POSTPONEMENT_END_DATE_ID, L_POSTPONEMENT_DATE , G_ELEMENT_DETAILS.G_EMPLOYEE_CLASS_ID, L_EMPLOYEE_CLASS_FOR_PENSION , G_ELEMENT_DETAILS.G_OPT_IN_DATE_ID,
5060: L_OPTIN_DATE , G_ELEMENT_DETAILS.G_OPT_OUT_DATE_ID, L_OPTOUT_DATE , G_ELEMENT_DETAILS.G_MAIN_ENTRY_ID, L_MAIN_ENTRY , G_ELEMENT_DETAILS.G_TOTAL_EARNING_PRP_ID, L_EARNINGS ,
5061: G_ELEMENT_DETAILS.G_OPT_OUT_END_DATE_ID, L_OPTOUT_END_DATE , G_ELEMENT_DETAILS.G_ELIGIBLE_JH_DATE_ID , to_char (l_eligible_jh_date
5062: /*Bug 14622818*/
5063: ,fnd_date.name_in_mask) );
5064: END IF;
5065: --*****************************************************************************************
5066: --AGGREGATION
5067: IF (NVL(L_AGGREGATION_FLAG,'N')='Y') THEN
5079: hr_utility.trace('INSIDE EXCEPTION: L_EXCEPTION_UPDATE');
5080: --*****************************************************-
5081: pay_action_information_api.create_action_information( p_action_information_id => l_action_id, p_object_version_number => l_ovn, p_action_information_category => 'GB_ENROLL_PENSIONS', p_action_context_id => p_assactid,
5082: p_action_context_type => 'AAP', p_assignment_id => L_ASSIGNMENT_ID, p_effective_date =>G_PRP_END_DATE, p_action_information1 =>L_QUALIFYING_SCHEME_NAME, p_action_information2 =>L_AGGREGATION_FLAG,
5083: p_action_information3 =>L_MAIN_ENTRY, p_action_information4 =>L_QUALIFYING_SCHEME_EXISTS, p_action_information5 =>L_POSTPONEMENT_TYPE, p_action_information6 =>FND_DATE.DATE_TO_CANONICAL(L_POSTPONEMENT_DATE),
5084: p_action_information7 =>L_EMPLOYEE_CLASS_FOR_PENSION, p_action_information8 =>FND_DATE.DATE_TO_CANONICAL(L_ELIGIBLE_JH_DATE), p_action_information9 =>FND_DATE.DATE_TO_CANONICAL(L_AUTO_ENROLLMENT_DATE),
5085: p_action_information10 =>FND_DATE.DATE_TO_CANONICAL(L_OPTOUT_END_DATE), p_action_information11 =>FND_DATE.DATE_TO_CANONICAL(L_OPTIN_DATE), p_action_information12 =>
5086: FND_DATE.DATE_TO_CANONICAL(L_OPTOUT_DATE), p_action_information13 =>L_EARNINGS, p_action_information14 =>L_FULL_NAME, p_action_information15 =>L_ASSIGNMENT_NUMBER,
5087: p_action_information16 =>FND_DATE.DATE_TO_CANONICAL(G_PRP_END_DATE), p_action_information17 =>FND_DATE.DATE_TO_CANONICAL(L_NOMINAL_AUTO_ENROLL_DATE), p_action_information18 =>floor(L_AGE) );
5080: --*****************************************************-
5081: pay_action_information_api.create_action_information( p_action_information_id => l_action_id, p_object_version_number => l_ovn, p_action_information_category => 'GB_ENROLL_PENSIONS', p_action_context_id => p_assactid,
5082: p_action_context_type => 'AAP', p_assignment_id => L_ASSIGNMENT_ID, p_effective_date =>G_PRP_END_DATE, p_action_information1 =>L_QUALIFYING_SCHEME_NAME, p_action_information2 =>L_AGGREGATION_FLAG,
5083: p_action_information3 =>L_MAIN_ENTRY, p_action_information4 =>L_QUALIFYING_SCHEME_EXISTS, p_action_information5 =>L_POSTPONEMENT_TYPE, p_action_information6 =>FND_DATE.DATE_TO_CANONICAL(L_POSTPONEMENT_DATE),
5084: p_action_information7 =>L_EMPLOYEE_CLASS_FOR_PENSION, p_action_information8 =>FND_DATE.DATE_TO_CANONICAL(L_ELIGIBLE_JH_DATE), p_action_information9 =>FND_DATE.DATE_TO_CANONICAL(L_AUTO_ENROLLMENT_DATE),
5085: p_action_information10 =>FND_DATE.DATE_TO_CANONICAL(L_OPTOUT_END_DATE), p_action_information11 =>FND_DATE.DATE_TO_CANONICAL(L_OPTIN_DATE), p_action_information12 =>
5086: FND_DATE.DATE_TO_CANONICAL(L_OPTOUT_DATE), p_action_information13 =>L_EARNINGS, p_action_information14 =>L_FULL_NAME, p_action_information15 =>L_ASSIGNMENT_NUMBER,
5087: p_action_information16 =>FND_DATE.DATE_TO_CANONICAL(G_PRP_END_DATE), p_action_information17 =>FND_DATE.DATE_TO_CANONICAL(L_NOMINAL_AUTO_ENROLL_DATE), p_action_information18 =>floor(L_AGE) );
5088: --**************************************
5081: pay_action_information_api.create_action_information( p_action_information_id => l_action_id, p_object_version_number => l_ovn, p_action_information_category => 'GB_ENROLL_PENSIONS', p_action_context_id => p_assactid,
5082: p_action_context_type => 'AAP', p_assignment_id => L_ASSIGNMENT_ID, p_effective_date =>G_PRP_END_DATE, p_action_information1 =>L_QUALIFYING_SCHEME_NAME, p_action_information2 =>L_AGGREGATION_FLAG,
5083: p_action_information3 =>L_MAIN_ENTRY, p_action_information4 =>L_QUALIFYING_SCHEME_EXISTS, p_action_information5 =>L_POSTPONEMENT_TYPE, p_action_information6 =>FND_DATE.DATE_TO_CANONICAL(L_POSTPONEMENT_DATE),
5084: p_action_information7 =>L_EMPLOYEE_CLASS_FOR_PENSION, p_action_information8 =>FND_DATE.DATE_TO_CANONICAL(L_ELIGIBLE_JH_DATE), p_action_information9 =>FND_DATE.DATE_TO_CANONICAL(L_AUTO_ENROLLMENT_DATE),
5085: p_action_information10 =>FND_DATE.DATE_TO_CANONICAL(L_OPTOUT_END_DATE), p_action_information11 =>FND_DATE.DATE_TO_CANONICAL(L_OPTIN_DATE), p_action_information12 =>
5086: FND_DATE.DATE_TO_CANONICAL(L_OPTOUT_DATE), p_action_information13 =>L_EARNINGS, p_action_information14 =>L_FULL_NAME, p_action_information15 =>L_ASSIGNMENT_NUMBER,
5087: p_action_information16 =>FND_DATE.DATE_TO_CANONICAL(G_PRP_END_DATE), p_action_information17 =>FND_DATE.DATE_TO_CANONICAL(L_NOMINAL_AUTO_ENROLL_DATE), p_action_information18 =>floor(L_AGE) );
5088: --**************************************
5089: --Update Info Element
5082: p_action_context_type => 'AAP', p_assignment_id => L_ASSIGNMENT_ID, p_effective_date =>G_PRP_END_DATE, p_action_information1 =>L_QUALIFYING_SCHEME_NAME, p_action_information2 =>L_AGGREGATION_FLAG,
5083: p_action_information3 =>L_MAIN_ENTRY, p_action_information4 =>L_QUALIFYING_SCHEME_EXISTS, p_action_information5 =>L_POSTPONEMENT_TYPE, p_action_information6 =>FND_DATE.DATE_TO_CANONICAL(L_POSTPONEMENT_DATE),
5084: p_action_information7 =>L_EMPLOYEE_CLASS_FOR_PENSION, p_action_information8 =>FND_DATE.DATE_TO_CANONICAL(L_ELIGIBLE_JH_DATE), p_action_information9 =>FND_DATE.DATE_TO_CANONICAL(L_AUTO_ENROLLMENT_DATE),
5085: p_action_information10 =>FND_DATE.DATE_TO_CANONICAL(L_OPTOUT_END_DATE), p_action_information11 =>FND_DATE.DATE_TO_CANONICAL(L_OPTIN_DATE), p_action_information12 =>
5086: FND_DATE.DATE_TO_CANONICAL(L_OPTOUT_DATE), p_action_information13 =>L_EARNINGS, p_action_information14 =>L_FULL_NAME, p_action_information15 =>L_ASSIGNMENT_NUMBER,
5087: p_action_information16 =>FND_DATE.DATE_TO_CANONICAL(G_PRP_END_DATE), p_action_information17 =>FND_DATE.DATE_TO_CANONICAL(L_NOMINAL_AUTO_ENROLL_DATE), p_action_information18 =>floor(L_AGE) );
5088: --**************************************
5089: --Update Info Element
5090: IF (NVL(L_AGGREGATION_FLAG,'N')='N') THEN
5083: p_action_information3 =>L_MAIN_ENTRY, p_action_information4 =>L_QUALIFYING_SCHEME_EXISTS, p_action_information5 =>L_POSTPONEMENT_TYPE, p_action_information6 =>FND_DATE.DATE_TO_CANONICAL(L_POSTPONEMENT_DATE),
5084: p_action_information7 =>L_EMPLOYEE_CLASS_FOR_PENSION, p_action_information8 =>FND_DATE.DATE_TO_CANONICAL(L_ELIGIBLE_JH_DATE), p_action_information9 =>FND_DATE.DATE_TO_CANONICAL(L_AUTO_ENROLLMENT_DATE),
5085: p_action_information10 =>FND_DATE.DATE_TO_CANONICAL(L_OPTOUT_END_DATE), p_action_information11 =>FND_DATE.DATE_TO_CANONICAL(L_OPTIN_DATE), p_action_information12 =>
5086: FND_DATE.DATE_TO_CANONICAL(L_OPTOUT_DATE), p_action_information13 =>L_EARNINGS, p_action_information14 =>L_FULL_NAME, p_action_information15 =>L_ASSIGNMENT_NUMBER,
5087: p_action_information16 =>FND_DATE.DATE_TO_CANONICAL(G_PRP_END_DATE), p_action_information17 =>FND_DATE.DATE_TO_CANONICAL(L_NOMINAL_AUTO_ENROLL_DATE), p_action_information18 =>floor(L_AGE) );
5088: --**************************************
5089: --Update Info Element
5090: IF (NVL(L_AGGREGATION_FLAG,'N')='N') THEN
5091: hr_utility.trace('Exception Update-- NON-AGGREGATED Case');
5095: L_POSTPONEMENT_TYPE , G_ELEMENT_DETAILS.G_POSTPONEMENT_END_DATE_ID, L_POSTPONEMENT_DATE , G_ELEMENT_DETAILS.G_EMPLOYEE_CLASS_ID, L_EMPLOYEE_CLASS_FOR_PENSION , G_ELEMENT_DETAILS.G_OPT_IN_DATE_ID,
5096: L_OPTIN_DATE , G_ELEMENT_DETAILS.G_OPT_OUT_DATE_ID, L_OPTOUT_DATE , G_ELEMENT_DETAILS.G_MAIN_ENTRY_ID, L_MAIN_ENTRY , G_ELEMENT_DETAILS.G_TOTAL_EARNING_PRP_ID, L_EARNINGS ,
5097: G_ELEMENT_DETAILS.G_OPT_OUT_END_DATE_ID, L_OPTOUT_END_DATE , G_ELEMENT_DETAILS.G_ELIGIBLE_JH_DATE_ID , to_char (l_eligible_jh_date
5098: /*Bug 14622818*/
5099: ,fnd_date.name_in_mask) );
5100: END IF;
5101: --*****************************************************************************************
5102: --AGGREGATION
5103: IF (NVL(L_AGGREGATION_FLAG,'N')='Y') THEN
5120: hr_utility.trace('INSIDE EXCEPTION: G_EXCEPTION_NO_UPDATE');
5121: --*****************************************************-
5122: pay_action_information_api.create_action_information( p_action_information_id => l_action_id, p_object_version_number => l_ovn, p_action_information_category => 'GB_ENROLL_PENSIONS', p_action_context_id => p_assactid,
5123: p_action_context_type => 'AAP', p_assignment_id => L_ASSIGNMENT_ID, p_effective_date =>G_PRP_END_DATE, p_action_information1 =>L_QUALIFYING_SCHEME_NAME, p_action_information2 =>L_AGGREGATION_FLAG,
5124: p_action_information3 =>L_MAIN_ENTRY, p_action_information4 =>L_QUALIFYING_SCHEME_EXISTS, p_action_information5 =>L_POSTPONEMENT_TYPE, p_action_information6 =>FND_DATE.DATE_TO_CANONICAL(L_POSTPONEMENT_DATE),
5125: p_action_information7 =>L_EMPLOYEE_CLASS_FOR_PENSION, p_action_information8 =>FND_DATE.DATE_TO_CANONICAL(L_ELIGIBLE_JH_DATE), p_action_information9 =>FND_DATE.DATE_TO_CANONICAL(L_AUTO_ENROLLMENT_DATE),
5126: p_action_information10 =>FND_DATE.DATE_TO_CANONICAL(L_OPTOUT_END_DATE), p_action_information11 =>FND_DATE.DATE_TO_CANONICAL(L_OPTIN_DATE), p_action_information12 =>FND_DATE.DATE_TO_CANONICAL(L_OPTOUT_DATE),
5127: p_action_information13 =>L_EARNINGS, p_action_information14 =>L_FULL_NAME, p_action_information15 =>L_ASSIGNMENT_NUMBER, p_action_information16 =>FND_DATE.DATE_TO_CANONICAL(G_PRP_END_DATE),
5128: p_action_information17 =>FND_DATE.DATE_TO_CANONICAL(L_NOMINAL_AUTO_ENROLL_DATE), p_action_information18 =>floor (l_age) );
5121: --*****************************************************-
5122: pay_action_information_api.create_action_information( p_action_information_id => l_action_id, p_object_version_number => l_ovn, p_action_information_category => 'GB_ENROLL_PENSIONS', p_action_context_id => p_assactid,
5123: p_action_context_type => 'AAP', p_assignment_id => L_ASSIGNMENT_ID, p_effective_date =>G_PRP_END_DATE, p_action_information1 =>L_QUALIFYING_SCHEME_NAME, p_action_information2 =>L_AGGREGATION_FLAG,
5124: p_action_information3 =>L_MAIN_ENTRY, p_action_information4 =>L_QUALIFYING_SCHEME_EXISTS, p_action_information5 =>L_POSTPONEMENT_TYPE, p_action_information6 =>FND_DATE.DATE_TO_CANONICAL(L_POSTPONEMENT_DATE),
5125: p_action_information7 =>L_EMPLOYEE_CLASS_FOR_PENSION, p_action_information8 =>FND_DATE.DATE_TO_CANONICAL(L_ELIGIBLE_JH_DATE), p_action_information9 =>FND_DATE.DATE_TO_CANONICAL(L_AUTO_ENROLLMENT_DATE),
5126: p_action_information10 =>FND_DATE.DATE_TO_CANONICAL(L_OPTOUT_END_DATE), p_action_information11 =>FND_DATE.DATE_TO_CANONICAL(L_OPTIN_DATE), p_action_information12 =>FND_DATE.DATE_TO_CANONICAL(L_OPTOUT_DATE),
5127: p_action_information13 =>L_EARNINGS, p_action_information14 =>L_FULL_NAME, p_action_information15 =>L_ASSIGNMENT_NUMBER, p_action_information16 =>FND_DATE.DATE_TO_CANONICAL(G_PRP_END_DATE),
5128: p_action_information17 =>FND_DATE.DATE_TO_CANONICAL(L_NOMINAL_AUTO_ENROLL_DATE), p_action_information18 =>floor (l_age) );
5129: --**************************************
5122: pay_action_information_api.create_action_information( p_action_information_id => l_action_id, p_object_version_number => l_ovn, p_action_information_category => 'GB_ENROLL_PENSIONS', p_action_context_id => p_assactid,
5123: p_action_context_type => 'AAP', p_assignment_id => L_ASSIGNMENT_ID, p_effective_date =>G_PRP_END_DATE, p_action_information1 =>L_QUALIFYING_SCHEME_NAME, p_action_information2 =>L_AGGREGATION_FLAG,
5124: p_action_information3 =>L_MAIN_ENTRY, p_action_information4 =>L_QUALIFYING_SCHEME_EXISTS, p_action_information5 =>L_POSTPONEMENT_TYPE, p_action_information6 =>FND_DATE.DATE_TO_CANONICAL(L_POSTPONEMENT_DATE),
5125: p_action_information7 =>L_EMPLOYEE_CLASS_FOR_PENSION, p_action_information8 =>FND_DATE.DATE_TO_CANONICAL(L_ELIGIBLE_JH_DATE), p_action_information9 =>FND_DATE.DATE_TO_CANONICAL(L_AUTO_ENROLLMENT_DATE),
5126: p_action_information10 =>FND_DATE.DATE_TO_CANONICAL(L_OPTOUT_END_DATE), p_action_information11 =>FND_DATE.DATE_TO_CANONICAL(L_OPTIN_DATE), p_action_information12 =>FND_DATE.DATE_TO_CANONICAL(L_OPTOUT_DATE),
5127: p_action_information13 =>L_EARNINGS, p_action_information14 =>L_FULL_NAME, p_action_information15 =>L_ASSIGNMENT_NUMBER, p_action_information16 =>FND_DATE.DATE_TO_CANONICAL(G_PRP_END_DATE),
5128: p_action_information17 =>FND_DATE.DATE_TO_CANONICAL(L_NOMINAL_AUTO_ENROLL_DATE), p_action_information18 =>floor (l_age) );
5129: --**************************************
5130: /*
5123: p_action_context_type => 'AAP', p_assignment_id => L_ASSIGNMENT_ID, p_effective_date =>G_PRP_END_DATE, p_action_information1 =>L_QUALIFYING_SCHEME_NAME, p_action_information2 =>L_AGGREGATION_FLAG,
5124: p_action_information3 =>L_MAIN_ENTRY, p_action_information4 =>L_QUALIFYING_SCHEME_EXISTS, p_action_information5 =>L_POSTPONEMENT_TYPE, p_action_information6 =>FND_DATE.DATE_TO_CANONICAL(L_POSTPONEMENT_DATE),
5125: p_action_information7 =>L_EMPLOYEE_CLASS_FOR_PENSION, p_action_information8 =>FND_DATE.DATE_TO_CANONICAL(L_ELIGIBLE_JH_DATE), p_action_information9 =>FND_DATE.DATE_TO_CANONICAL(L_AUTO_ENROLLMENT_DATE),
5126: p_action_information10 =>FND_DATE.DATE_TO_CANONICAL(L_OPTOUT_END_DATE), p_action_information11 =>FND_DATE.DATE_TO_CANONICAL(L_OPTIN_DATE), p_action_information12 =>FND_DATE.DATE_TO_CANONICAL(L_OPTOUT_DATE),
5127: p_action_information13 =>L_EARNINGS, p_action_information14 =>L_FULL_NAME, p_action_information15 =>L_ASSIGNMENT_NUMBER, p_action_information16 =>FND_DATE.DATE_TO_CANONICAL(G_PRP_END_DATE),
5128: p_action_information17 =>FND_DATE.DATE_TO_CANONICAL(L_NOMINAL_AUTO_ENROLL_DATE), p_action_information18 =>floor (l_age) );
5129: --**************************************
5130: /*
5131: OPEN C_ERROR_MSG;
5124: p_action_information3 =>L_MAIN_ENTRY, p_action_information4 =>L_QUALIFYING_SCHEME_EXISTS, p_action_information5 =>L_POSTPONEMENT_TYPE, p_action_information6 =>FND_DATE.DATE_TO_CANONICAL(L_POSTPONEMENT_DATE),
5125: p_action_information7 =>L_EMPLOYEE_CLASS_FOR_PENSION, p_action_information8 =>FND_DATE.DATE_TO_CANONICAL(L_ELIGIBLE_JH_DATE), p_action_information9 =>FND_DATE.DATE_TO_CANONICAL(L_AUTO_ENROLLMENT_DATE),
5126: p_action_information10 =>FND_DATE.DATE_TO_CANONICAL(L_OPTOUT_END_DATE), p_action_information11 =>FND_DATE.DATE_TO_CANONICAL(L_OPTIN_DATE), p_action_information12 =>FND_DATE.DATE_TO_CANONICAL(L_OPTOUT_DATE),
5127: p_action_information13 =>L_EARNINGS, p_action_information14 =>L_FULL_NAME, p_action_information15 =>L_ASSIGNMENT_NUMBER, p_action_information16 =>FND_DATE.DATE_TO_CANONICAL(G_PRP_END_DATE),
5128: p_action_information17 =>FND_DATE.DATE_TO_CANONICAL(L_NOMINAL_AUTO_ENROLL_DATE), p_action_information18 =>floor (l_age) );
5129: --**************************************
5130: /*
5131: OPEN C_ERROR_MSG;
5132: FETCH C_ERROR_MSG INTO L_ERR_MSG;