DBA Data[Home] [Help]

APPS.PAY_GB_MULTI_PAYROLL_RUN dependencies on PAY_GB_MULTI_PAYROLL_RUN

Line 1: PACKAGE BODY PAY_GB_MULTI_PAYROLL_RUN

1: PACKAGE BODY PAY_GB_MULTI_PAYROLL_RUN
2: /* $Header: pygbmps.pkb 120.0.12020000.2 2013/03/09 07:57:58 ssanjays noship $ */
3: AS
4:
5:

Line 20: ,P_CHILD_REQ PAY_GB_MULTI_PAYROLL_RUN.CHILD_REQ)

16: ,P_PAYROLL_GROUP_ID IN NUMBER
17: ,P_PROCESS_NAME IN VARCHAR2
18: ,P_REQUEST_PARAMETERS IN VARCHAR2
19: ,P_REQUEST_SUBMISSION_DATE IN DATE
20: ,P_CHILD_REQ PAY_GB_MULTI_PAYROLL_RUN.CHILD_REQ)
21: IS
22:
23: BEGIN
24:

Line 97: hr_utility.trace('Inside '||PAY_GB_MULTI_PAYROLL_RUN.g_package);

93: REQ_COUNT NUMBER;
94:
95: BEGIN
96:
97: hr_utility.trace('Inside '||PAY_GB_MULTI_PAYROLL_RUN.g_package);
98: hr_utility.trace('P_RUN_TYPE:'||P_RUN_TYPE);
99: hr_utility.trace('P_TIME_PERIOD_NAME'||P_TIME_PERIOD_NAME);
100:
101:

Line 158: PAY_GB_MULTI_PAYROLL_RUN.UPDATE_MASTER_CHILD(

154: /*
155: Call to update the master and child record
156: */
157:
158: PAY_GB_MULTI_PAYROLL_RUN.UPDATE_MASTER_CHILD(
159: P_CONCURRENT_REQUEST_ID=>PAR_REQ_ID
160: ,P_PAYROLL_GROUP_ID =>P_PAYROLL_GROUP_ID
161: ,P_PROCESS_NAME =>'Payroll Run UK Multiple'
162: ,P_REQUEST_PARAMETERS =>PAR_REQ_PARAMS

Line 226: hr_utility.trace('Inside:'||PAY_GB_MULTI_PAYROLL_RUN.g_package);

222: BEGIN
223:
224:
225:
226: hr_utility.trace('Inside:'||PAY_GB_MULTI_PAYROLL_RUN.g_package);
227: hr_utility.trace('P_START_DATE'||P_START_DATE);
228: hr_utility.trace('P_END_DATE'||P_END_DATE);
229: hr_utility.trace('P_PAYMENT_METHOD_OVERRIDE:'||P_PAYMENT_OVERRIDE_Y_N);
230:

Line 284: PAY_GB_MULTI_PAYROLL_RUN.UPDATE_MASTER_CHILD(

280: */
281:
282: PAR_REQ_PARAMS:=PAR_REQ_PARAMS || 'ROLLBACK_PARAM=' ||P_END_DATE;
283:
284: PAY_GB_MULTI_PAYROLL_RUN.UPDATE_MASTER_CHILD(
285: P_CONCURRENT_REQUEST_ID=>PAR_REQ_ID
286: ,P_PAYROLL_GROUP_ID =>P_PAYROLL_GROUP_ID
287: ,P_PROCESS_NAME =>'Pre-payments'
288: ,P_REQUEST_PARAMETERS =>PAR_REQ_PARAMS

Line 410: PAY_GB_MULTI_PAYROLL_RUN.UPDATE_MASTER_CHILD(

406: CLOSE CSR_PARENT_REQ_ID;
407:
408: PAR_REQ_PARAMS:=PAR_REQ_PARAMS ||'ROLLBACK_PARAM=' ||P_END_DATE;
409:
410: PAY_GB_MULTI_PAYROLL_RUN.UPDATE_MASTER_CHILD(
411: P_CONCURRENT_REQUEST_ID=>PAR_REQ_ID
412: ,P_PAYROLL_GROUP_ID =>P_PAYROLL_GROUP_ID
413: ,P_PROCESS_NAME =>'Magnetic transfer'
414: ,P_REQUEST_PARAMETERS =>PAR_REQ_PARAMS

Line 539: PAY_GB_MULTI_PAYROLL_RUN.UPDATE_MASTER_CHILD(

535:
536:
537: PAR_REQ_PARAMS:=PAR_REQ_PARAMS ||'ROLLBACK_PARAM=' ||P_END_DATE;
538:
539: PAY_GB_MULTI_PAYROLL_RUN.UPDATE_MASTER_CHILD(
540: P_CONCURRENT_REQUEST_ID=>PAR_REQ_ID
541: ,P_PAYROLL_GROUP_ID =>P_PAYROLL_GROUP_ID
542: ,P_PROCESS_NAME =>'Cheque writer'
543: ,P_REQUEST_PARAMETERS =>PAR_REQ_PARAMS

Line 667: PAY_GB_MULTI_PAYROLL_RUN.UPDATE_MASTER_CHILD(

663: CLOSE CSR_PARENT_REQ_ID;
664:
665: PAR_REQ_PARAMS:=PAR_REQ_PARAMS || 'ROLLBACK_PARAM=' ||P_END_DATE;
666:
667: PAY_GB_MULTI_PAYROLL_RUN.UPDATE_MASTER_CHILD(
668: P_CONCURRENT_REQUEST_ID=>PAR_REQ_ID
669: ,P_PAYROLL_GROUP_ID =>P_PAYROLL_GROUP_ID
670: ,P_PROCESS_NAME =>'Magnetic report'
671: ,P_REQUEST_PARAMETERS =>PAR_REQ_PARAMS

Line 743: PAY_GB_MULTI_PAYROLL_RUN.UPDATE_MASTER_CHILD(

739: CLOSE CSR_PARENT_REQ_ID;
740:
741:
742: PAR_REQ_PARAMS:=PAR_REQ_PARAMS ||'ROLLBACK_PARAM=' ||P_START_DATE;
743: PAY_GB_MULTI_PAYROLL_RUN.UPDATE_MASTER_CHILD(
744: P_CONCURRENT_REQUEST_ID=>PAR_REQ_ID
745: ,P_PAYROLL_GROUP_ID =>P_PAYROLL_GROUP_ID
746: ,P_PROCESS_NAME =>'Retropay by Element'
747: ,P_REQUEST_PARAMETERS =>PAR_REQ_PARAMS

Line 796: V_TIME_PERIOD_ID:=PAY_GB_MULTI_PAYROLL_RUN.GET_PERIOD_NAME(P_TIME_PERIOD_NAME,PAY_RUN.PAYROLL_ID);

792: OPEN CSR_GET_CONS_ID(PAY_RUN.PAYROLL_ID);
793: FETCH CSR_GET_CONS_ID INTO V_CONDOLIDATION_SET_ID;
794: hr_utility.trace('payroll_id:'||PAY_RUN.PAYROLL_ID);
795: hr_utility.trace('P_TIME_PERIOD_NAME:'||P_TIME_PERIOD_NAME);
796: V_TIME_PERIOD_ID:=PAY_GB_MULTI_PAYROLL_RUN.GET_PERIOD_NAME(P_TIME_PERIOD_NAME,PAY_RUN.PAYROLL_ID);
797: L_REQ_ID := FND_REQUEST.SUBMIT_REQUEST(
798: APPLICATION => 'PAY'
799: , PROGRAM => 'PAYRPTPL'
800: , DESCRIPTION => NULL

Line 897: V_TIME_PERIOD_ID:=PAY_GB_MULTI_PAYROLL_RUN.GET_PERIOD_NAME(P_TIME_PERIOD_NAME,PAY_RUN.PAYROLL_ID);

893: FOR PAY_RUN IN CSR_ALL_PAYROLLS(P_PAYROLL_GROUP_ID)
894: LOOP
895:
896:
897: V_TIME_PERIOD_ID:=PAY_GB_MULTI_PAYROLL_RUN.GET_PERIOD_NAME(P_TIME_PERIOD_NAME,PAY_RUN.PAYROLL_ID);
898: L_REQ_ID := FND_REQUEST.SUBMIT_REQUEST(
899: APPLICATION => 'PAY'
900: , PROGRAM => 'PAYGBGTN'
901: , DESCRIPTION => NULL

Line 1186: END PAY_GB_MULTI_PAYROLL_RUN;

1182: END LOOP;
1183:
1184: END RUN_ROLLBACK_ALL_UK;
1185:
1186: END PAY_GB_MULTI_PAYROLL_RUN;