APPS.PAY_GB_MULTI_DML_AND_VAL dependencies on PAY_GB_MP_CHILD_REQUEST_DET

Line 176: FROM PAY_GB_MP_CHILD_REQUEST_DET PGMPCRD,

172: V_STATUS:=0;
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;

Line 370: INSERT INTO PAY_GB_MP_CHILD_REQUEST_DET

366: BEGIN
367:
368: IF VAL_CHILD_CONCURRENT_REQUEST(P_CHILD_CON_ID,P_PARENT_CON_ID)=1 THEN
369:
370: INSERT INTO PAY_GB_MP_CHILD_REQUEST_DET
371: (
372: CHILD_CONCURRENT_REQUEST_ID
373: ,PARENT_CONCURRENT_REQUEST_ID
374: ,OBJECT_VERSION_NUMBER

Line 437: FROM PAY_GB_MP_CHILD_REQUEST_DET

433:
434: BEGIN
435:
436: SELECT OBJECT_VERSION_NUMBER INTO CURR_OBJ_VERS
437: FROM PAY_GB_MP_CHILD_REQUEST_DET
438: WHERE CHILD_CONCURRENT_REQUEST_ID=P_CHILD_REQUEST_ID
439: AND PARENT_CONCURRENT_REQUEST_ID=P_MASTER_REQUEST_ID;
440: hr_utility.trace('object version is for CHILD is:'||CURR_OBJ_VERS);
441:

Line 442: UPDATE PAY_GB_MP_CHILD_REQUEST_DET

438: WHERE CHILD_CONCURRENT_REQUEST_ID=P_CHILD_REQUEST_ID
439: AND PARENT_CONCURRENT_REQUEST_ID=P_MASTER_REQUEST_ID;
440: hr_utility.trace('object version is for CHILD is:'||CURR_OBJ_VERS);
441:
442: UPDATE PAY_GB_MP_CHILD_REQUEST_DET
443: SET
444: ROLLBACK_REQUEST_ID=P_ROLLBACK_REQUEST_ID
445: ,LAST_UPDATE_DATE=SYSDATE
446: ,OBJECT_VERSION_NUMBER=(CURR_OBJ_VERS+1)

Line 500: UPDATE PAY_GB_MP_CHILD_REQUEST_DET

496:
497: BEGIN
498:
499:
500: UPDATE PAY_GB_MP_CHILD_REQUEST_DET
501: SET ROLLBACK_REQUEST_ID=-1
502: WHERE CHILD_CONCURRENT_REQUEST_ID=P_REQUEST_ID;
503:
504: COMMIT;