455: hr_utility.set_location('Status : '||l_status,40);
456: UPDATE
457: PAY_GB_EPS_DETAILS
458: SET STATUS = l_status,
459: REQUEST_ID = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, request_id, FND_GLOBAL.CONC_REQUEST_ID),
460: PROGRAM_APPLICATION_ID = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, program_application_id, FND_GLOBAL.PROG_APPL_ID),
461: PROGRAM_ID = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, program_id, FND_GLOBAL.CONC_PROGRAM_ID),
462: PROGRAM_UPDATE_DATE = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, program_update_date, SYSDATE)
463: WHERE EMP_PAYE_REFERENCE = p_emp_paye_reference
456: UPDATE
457: PAY_GB_EPS_DETAILS
458: SET STATUS = l_status,
459: REQUEST_ID = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, request_id, FND_GLOBAL.CONC_REQUEST_ID),
460: PROGRAM_APPLICATION_ID = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, program_application_id, FND_GLOBAL.PROG_APPL_ID),
461: PROGRAM_ID = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, program_id, FND_GLOBAL.CONC_PROGRAM_ID),
462: PROGRAM_UPDATE_DATE = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, program_update_date, SYSDATE)
463: WHERE EMP_PAYE_REFERENCE = p_emp_paye_reference
464: AND EFFECTIVE_DATE = p_effective_date
457: PAY_GB_EPS_DETAILS
458: SET STATUS = l_status,
459: REQUEST_ID = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, request_id, FND_GLOBAL.CONC_REQUEST_ID),
460: PROGRAM_APPLICATION_ID = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, program_application_id, FND_GLOBAL.PROG_APPL_ID),
461: PROGRAM_ID = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, program_id, FND_GLOBAL.CONC_PROGRAM_ID),
462: PROGRAM_UPDATE_DATE = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, program_update_date, SYSDATE)
463: WHERE EMP_PAYE_REFERENCE = p_emp_paye_reference
464: AND EFFECTIVE_DATE = p_effective_date
465: AND BUSINESS_GROUP_ID = p_business_group_id;
458: SET STATUS = l_status,
459: REQUEST_ID = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, request_id, FND_GLOBAL.CONC_REQUEST_ID),
460: PROGRAM_APPLICATION_ID = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, program_application_id, FND_GLOBAL.PROG_APPL_ID),
461: PROGRAM_ID = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, program_id, FND_GLOBAL.CONC_PROGRAM_ID),
462: PROGRAM_UPDATE_DATE = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, program_update_date, SYSDATE)
463: WHERE EMP_PAYE_REFERENCE = p_emp_paye_reference
464: AND EFFECTIVE_DATE = p_effective_date
465: AND BUSINESS_GROUP_ID = p_business_group_id;
466:
609: CIS_DEDUCTIONS_STUFF = p_cis_deductions_suff,
610: NIC_HOLIDAY_VAL = p_nic_holiday_val,
611: ADV_FROM_HMRC = p_adv_from_hmrc,
612: APPROVER_ID = l_approver_id,
613: REQUEST_ID = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, request_id, FND_GLOBAL.CONC_REQUEST_ID),
614: PROGRAM_APPLICATION_ID = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, program_application_id, FND_GLOBAL.PROG_APPL_ID),
615: PROGRAM_ID = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, program_id, FND_GLOBAL.CONC_PROGRAM_ID),
616: PROGRAM_UPDATE_DATE = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, program_update_date, SYSDATE)
617: WHERE EMP_PAYE_REFERENCE = p_emp_paye_reference
610: NIC_HOLIDAY_VAL = p_nic_holiday_val,
611: ADV_FROM_HMRC = p_adv_from_hmrc,
612: APPROVER_ID = l_approver_id,
613: REQUEST_ID = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, request_id, FND_GLOBAL.CONC_REQUEST_ID),
614: PROGRAM_APPLICATION_ID = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, program_application_id, FND_GLOBAL.PROG_APPL_ID),
615: PROGRAM_ID = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, program_id, FND_GLOBAL.CONC_PROGRAM_ID),
616: PROGRAM_UPDATE_DATE = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, program_update_date, SYSDATE)
617: WHERE EMP_PAYE_REFERENCE = p_emp_paye_reference
618: AND EFFECTIVE_DATE = p_effective_date
611: ADV_FROM_HMRC = p_adv_from_hmrc,
612: APPROVER_ID = l_approver_id,
613: REQUEST_ID = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, request_id, FND_GLOBAL.CONC_REQUEST_ID),
614: PROGRAM_APPLICATION_ID = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, program_application_id, FND_GLOBAL.PROG_APPL_ID),
615: PROGRAM_ID = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, program_id, FND_GLOBAL.CONC_PROGRAM_ID),
616: PROGRAM_UPDATE_DATE = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, program_update_date, SYSDATE)
617: WHERE EMP_PAYE_REFERENCE = p_emp_paye_reference
618: AND EFFECTIVE_DATE = p_effective_date
619: AND BUSINESS_GROUP_ID = p_business_group_id;
612: APPROVER_ID = l_approver_id,
613: REQUEST_ID = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, request_id, FND_GLOBAL.CONC_REQUEST_ID),
614: PROGRAM_APPLICATION_ID = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, program_application_id, FND_GLOBAL.PROG_APPL_ID),
615: PROGRAM_ID = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, program_id, FND_GLOBAL.CONC_PROGRAM_ID),
616: PROGRAM_UPDATE_DATE = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, program_update_date, SYSDATE)
617: WHERE EMP_PAYE_REFERENCE = p_emp_paye_reference
618: AND EFFECTIVE_DATE = p_effective_date
619: AND BUSINESS_GROUP_ID = p_business_group_id;
620: