APPS.CREATE_GB_RTI_EPS_RECORD dependencies on FND_GLOBAL

Line 236: where request_id = FND_GLOBAL.CONC_REQUEST_ID;

232: GROUP BY assignment_id;
233:
234: cursor csr_get_request_details is
235: select PROGRAM_APPLICATION_ID,CONCURRENT_PROGRAM_ID,LAST_UPDATE_DATE from fnd_concurrent_requests
236: where request_id = FND_GLOBAL.CONC_REQUEST_ID;
237:
238: l_request_rec csr_get_request_details%rowtype;
239:
240: BEGIN

Line 269: -- L_CREATER_ID := FND_GLOBAL.USER_ID;

265: END IF;
266: CLOSE c_check_eps;
267: GET_GLOBALS;
268: G_RELATED_TAX_YEAR := TO_CHAR(L_DATE_EOY,'YYYY');
269: -- L_CREATER_ID := FND_GLOBAL.USER_ID;
270: select EMPLOYEE_ID INTO L_CREATER_ID FRom FND_USER
271: WHERE USER_ID = FND_GLOBAL.USER_ID;
272: HR_UTILITY.TRACE(' CREATER_ID '||L_CREATER_ID);
273: l_nic_ssp_rate := G_NIC_RATE;

Line 271: WHERE USER_ID = FND_GLOBAL.USER_ID;

267: GET_GLOBALS;
268: G_RELATED_TAX_YEAR := TO_CHAR(L_DATE_EOY,'YYYY');
269: -- L_CREATER_ID := FND_GLOBAL.USER_ID;
270: select EMPLOYEE_ID INTO L_CREATER_ID FRom FND_USER
271: WHERE USER_ID = FND_GLOBAL.USER_ID;
272: HR_UTILITY.TRACE(' CREATER_ID '||L_CREATER_ID);
273: l_nic_ssp_rate := G_NIC_RATE;
274: L_NIC_SMP_RATE := G_NIC_RATE;
275: IF g_ssp_recovery = 'None' THEN

Line 350: FND_GLOBAL.CONC_REQUEST_ID,l_request_rec.PROGRAM_APPLICATION_ID,l_request_rec.CONCURRENT_PROGRAM_ID,l_request_rec.LAST_UPDATE_DATE);

346:
347: --Insert EPS record
348: pay_gb_eps.INSERT_EPS_RECORD ( L_EFF_START_DATE, P_PAYE_REFERENCE, G_ACC_REF_NO, p_business_group_id, G_EMPLOYERS_NAME, G_ECON_NUMBER, G_RELATED_TAX_YEAR, G_SMP_SAP_RATE, G_SSP_RATE, G_NIC_RATE, G_SERVICE_PROVIDER,
349: l_smp/100, l_sap/100, l_spp/100, l_aspp/100, l_ssp/100, L_NIC_SMP/100, l_nic_sap/100, l_nic_spp/100, l_nic_aspp/100, L_NIC_SSP/100, 'Saved', L_CREATER_ID, G_APPROVER_ID ,
350: FND_GLOBAL.CONC_REQUEST_ID,l_request_rec.PROGRAM_APPLICATION_ID,l_request_rec.CONCURRENT_PROGRAM_ID,l_request_rec.LAST_UPDATE_DATE);
351:
352:
353: HR_UTILITY.TRACE(' EPS record insert complete ');
354: --Write Output Information