APPS.PAY_GB_MULTI_DML_AND_VAL dependencies on PAY_GB_MP_MASTER_REQUEST_DET

Line 149: FROM PAY_GB_MP_MASTER_REQUEST_DET PGPMMRD

145: V_STATUS:=1;
146: hr_utility.trace('V_STATUS:'||V_STATUS);
147: SELECT CONCURRENT_REQUEST_ID
148: INTO V_CONC_ID
149: FROM PAY_GB_MP_MASTER_REQUEST_DET PGPMMRD
150: WHERE PGPMMRD.CONCURRENT_REQUEST_ID=P_CONCURRENT_REQUEST_ID
151: AND PGPMMRD.PAYROLL_GROUP_ID=P_PAYROLL_GROUP_ID;
152:
153: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 177: PAY_GB_MP_MASTER_REQUEST_DET PGMMRD

173:
174: SELECT PGMPCRD.CHILD_CONCURRENT_REQUEST_ID
175: INTO V_CONC_ID
176: FROM PAY_GB_MP_CHILD_REQUEST_DET PGMPCRD,
177: PAY_GB_MP_MASTER_REQUEST_DET PGMMRD
178: WHERE PGMPCRD.CHILD_CONCURRENT_REQUEST_ID=P_CHILD_CONCURRENT_REQUEST_ID
179: AND PGMPCRD.PARENT_CONCURRENT_REQUEST_ID=PGMMRD.CONCURRENT_REQUEST_ID
180: AND PGMMRD.CONCURRENT_REQUEST_ID=P_PARENT_CONC_REQUEST_ID;
181:

Line 332: INSERT INTO PAY_GB_MP_MASTER_REQUEST_DET

328: BEGIN
329:
330: IF VAL_MASTER_CONCURRENT_REQUEST(P_CONCURRENT_REQUEST_ID,P_PAYROLL_GROUP_ID)=1 THEN
331:
332: INSERT INTO PAY_GB_MP_MASTER_REQUEST_DET
333: (
334: CONCURRENT_REQUEST_ID
335: ,PAYROLL_GROUP_ID
336: ,PROCESS_NAME

Line 394: PAY_GB_MP_MASTER_REQUEST_DET table updated

390:
391:
392:
393: /*
394: PAY_GB_MP_MASTER_REQUEST_DET table updated
395: */
396: PROCEDURE UPDATE_MASTER_ROLLBACK_DETAILS
397: (
398: P_MASTER_REQUEST_ID IN NUMBER

Line 408: FROM PAY_GB_MP_MASTER_REQUEST_DET

404: CURR_OBJ_VERS NUMBER;
405: BEGIN
406:
407: SELECT OBJECT_VERSION_NUMBER INTO CURR_OBJ_VERS
408: FROM PAY_GB_MP_MASTER_REQUEST_DET
409: WHERE CONCURRENT_REQUEST_ID=P_MASTER_REQUEST_ID;
410: hr_utility.trace('object version is for master is:'||CURR_OBJ_VERS);
411:
412: UPDATE PAY_GB_MP_MASTER_REQUEST_DET

Line 412: UPDATE PAY_GB_MP_MASTER_REQUEST_DET

408: FROM PAY_GB_MP_MASTER_REQUEST_DET
409: WHERE CONCURRENT_REQUEST_ID=P_MASTER_REQUEST_ID;
410: hr_utility.trace('object version is for master is:'||CURR_OBJ_VERS);
411:
412: UPDATE PAY_GB_MP_MASTER_REQUEST_DET
413: SET
414: ROLLBACK_REQUEST_ID=P_ROLLBACK_REQUEST_ID
415: ,LAST_UPDATE_DATE=SYSDATE
416: ,OBJECT_VERSION_NUMBER=(CURR_OBJ_VERS+1)