22:
23: BEGIN
24:
25:
26: PAY_GB_MULTI_DML_AND_VAL.ADD_MASTER_CON_DETAILS(
27: P_CONCURRENT_REQUEST_ID=>P_CONCURRENT_REQUEST_ID
28: ,P_PAYROLL_GROUP_ID=>P_PAYROLL_GROUP_ID
29: ,P_PROCESS_NAME=>P_PROCESS_NAME
30: ,P_REQUEST_PARAMETERS=>P_REQUEST_PARAMETERS
34:
35: FOR P IN P_CHILD_REQ.FIRST..P_CHILD_REQ.LAST
36: LOOP
37: hr_utility.trace('Child request to be stored:'||P_CHILD_REQ(P));
38: PAY_GB_MULTI_DML_AND_VAL.ADD_CHILD_CON_DETAILS(
39: P_CHILD_CON_ID=>P_CHILD_REQ(P),P_PARENT_CON_ID =>P_CONCURRENT_REQUEST_ID);
40: END LOOP;
41:
42: END UPDATE_MASTER_CHILD;
972:
973: FOR PAY_RUN IN CSR_CHILD_REQUEST(P_PARENT_REQ_ID)
974: LOOP
975: hr_utility.trace('aCTUAL REQUEST iD:'||PAY_RUN.CON_ID);
976: IF PAY_GB_MULTI_DML_AND_VAL.CHK_ALREADY_ROLLED_BACK(PAY_RUN.CON_ID)=1 THEN
977: hr_utility.trace('child requestId:'||PAY_RUN.CON_ID);
978:
979: OPEN CSR_PAYACT_ID(PAY_RUN.CON_ID);
980: FETCH CSR_PAYACT_ID INTO P_PAY_ACTION_ID;
1007: FETCH CSR_PARENT_REQ_ID INTO PAR_REQ_ID, PAR_REQ_PARAMS;
1008: CLOSE CSR_PARENT_REQ_ID;
1009: -- update the child table and parent table with rollback details
1010:
1011: PAY_GB_MULTI_DML_AND_VAL.UPDATE_MASTER_ROLLBACK_DETAILS
1012: (
1013: P_MASTER_REQUEST_ID=>P_PARENT_REQ_ID
1014: ,P_PAYROLL_GROUP_ID=>P_PAYROLL_GROUP_ID
1015: ,P_ROLLBACK_REQUEST_ID=>PAR_REQ_ID
1018:
1019: FOR P IN 1..REQ_COUNT
1020: LOOP
1021:
1022: PAY_GB_MULTI_DML_AND_VAL.UPDATE_CHILD_ROLLBACK_DETAILS
1023: (
1024: P_MASTER_REQUEST_ID=>P_PARENT_REQ_ID
1025: ,P_PAYROLL_GROUP_ID=>P_PAYROLL_GROUP_ID
1026: ,P_ROLLBACK_REQUEST_ID=>T_ROLLBACK_REQ(P)
1029: END LOOP;
1030:
1031: FOR P IN 0..V_AL_COUNT
1032: LOOP
1033: PAY_GB_MULTI_DML_AND_VAL.UPDATE_ALREADY_ROLLEDBACK(P_REQUEST_ID=>T_CHILD_REQ_AL(P));
1034:
1035: END LOOP;
1036:
1037:
1098: LOOP
1099:
1100: hr_utility.trace('PAY_RUN.CON_ID'||PAY_RUN.CON_ID);
1101:
1102: IF PAY_GB_MULTI_DML_AND_VAL.CHK_ALREADY_ROLLED_BACK(PAY_RUN.CON_ID)=1 THEN
1103: hr_utility.trace('child requestId:'||PAY_RUN.CON_ID);
1104:
1105: OPEN CSR_PAYACT_ID(PAY_RUN.CON_ID);
1106: FETCH CSR_PAYACT_ID INTO P_PAY_ACTION_ID;
1105: OPEN CSR_PAYACT_ID(PAY_RUN.CON_ID);
1106: FETCH CSR_PAYACT_ID INTO P_PAY_ACTION_ID;
1107: CLOSE CSR_PAYACT_ID;
1108:
1109: hr_utility.trace('PAY_GB_MULTI_DML_AND_VAL.CHK_ALREADY_ROLLED_BACK(PAY_RUN.CON_ID)=1');
1110: hr_utility.trace('P_PAY_ACTION_ID passed is:'||P_PAY_ACTION_ID);
1111: V_PAYROLL_RUN_HID:='PAYROLL_ACTION_ID='||P_PAY_ACTION_ID;
1112: L_REQ_ID := FND_REQUEST.SUBMIT_REQUEST(
1113: APPLICATION => 'PAY'
1146: CLOSE CSR_PARENT_REQ_ID;
1147:
1148: hr_utility.trace('bEFORE MASTER UPDATE');
1149:
1150: PAY_GB_MULTI_DML_AND_VAL.UPDATE_MASTER_ROLLBACK_DETAILS
1151: (
1152: P_MASTER_REQUEST_ID=>P_PROCESS_NAME
1153: ,P_PAYROLL_GROUP_ID=>P_PAYROLL_GROUP_ID
1154: ,P_ROLLBACK_REQUEST_ID=>PAR_REQ_ID
1161: hr_utility.trace('BEFORE CHILD UPDATE');
1162: FOR P IN 0..V_N_COUNT
1163: LOOP
1164:
1165: PAY_GB_MULTI_DML_AND_VAL.UPDATE_CHILD_ROLLBACK_DETAILS
1166: (
1167: P_MASTER_REQUEST_ID=>P_PROCESS_NAME
1168: ,P_PAYROLL_GROUP_ID=>P_PAYROLL_GROUP_ID
1169: ,P_ROLLBACK_REQUEST_ID=>T_CHILD_REQ_NO_AL(P)
1176: UPDATE FOR ALREADY ROLLEDBACK REQUESTS
1177: */
1178: FOR P IN 0..V_AL_COUNT
1179: LOOP
1180: PAY_GB_MULTI_DML_AND_VAL.UPDATE_ALREADY_ROLLEDBACK(P_REQUEST_ID=>T_CHILD_REQ_AL(P));
1181:
1182: END LOOP;
1183:
1184: END RUN_ROLLBACK_ALL_UK;