8278: pay_in_utils.set_location(g_debug,'Value of l_locked_action_id is '|| c_rec.assignment_action_id, 12);
8279: pay_in_utils.set_location(g_debug,'Value of assignment_id is '|| c_rec.assignment_id, 13);
8280:
8281: pay_in_utils.set_location(g_debug,'Inserting Assignment Actions ', 14);
8282: hr_nonrun_asact.insact(lockingactid => l_action_id
8283: ,assignid => c_rec.assignment_id
8284: ,pactid => p_locking_pay_act_id
8285: ,chunk => p_chunk
8286: );
8284: ,pactid => p_locking_pay_act_id
8285: ,chunk => p_chunk
8286: );
8287: pay_in_utils.set_location(g_debug,'Enforcing Locking ', 15);
8288: hr_nonrun_asact.insint(lockingactid => l_action_id
8289: ,lockedactid => c_rec.assignment_action_id
8290: );
8291: pay_in_utils.set_location(g_debug,'Locking enforced', 16);
8292: END IF;
8310: INTO l_action_id
8311: FROM dual;
8312:
8313: pay_in_utils.set_location(g_debug,'Inserting Assignment Actions as it was null', 14);
8314: hr_nonrun_asact.insact(lockingactid => l_action_id
8315: ,assignid => c_rec.assignment_id
8316: ,pactid => p_locking_pay_act_id
8317: ,chunk => p_chunk
8318: );
8328:
8329: IF (l_flag IS NULL)
8330: THEN
8331: pay_in_utils.set_location(g_debug,'Enforcing Locking ', 15);
8332: hr_nonrun_asact.insint(lockingactid => l_action_id
8333: ,lockedactid => c_rec.assignment_action_id
8334: );
8335: pay_in_utils.set_location(g_debug,'Locking enforced', 16);
8336: END IF;
8362: INTO l_action_id
8363: FROM dual;
8364:
8365: pay_in_utils.set_location(g_debug,'Inserting Assignment Actions as it was null', 14);
8366: hr_nonrun_asact.insact(lockingactid => l_action_id
8367: ,assignid => c_rec.assignment_id
8368: ,pactid => p_locking_pay_act_id
8369: ,chunk => p_chunk
8370: );
8380:
8381: IF (l_flag IS NULL)
8382: THEN
8383: pay_in_utils.set_location(g_debug,'Enforcing Locking ', 15);
8384: hr_nonrun_asact.insint(lockingactid => l_action_id
8385: ,lockedactid => c_rec.assignment_action_id
8386: );
8387: pay_in_utils.set_location(g_debug,'Locking enforced', 16);
8388: END IF;
8899:
8900: pay_in_utils.set_location(g_debug,'Value of l_action_id is '|| l_action_id, 61);
8901: pay_in_utils.set_location(g_debug,'Inserting Assignment action id ',61);
8902:
8903: hr_nonrun_asact.insact(lockingactid => l_action_id
8904: ,assignid => g_sal_data_rec_del(i).assignment_id
8905: ,pactid => p_payroll_action_id
8906: ,chunk => p_chunk
8907: );
8915: pay_in_utils.trace('Value of l_locked_action_id for 24Q is ',l_24q_asg_action_id);
8916:
8917: IF (l_24q_asg_action_id IS NOT NULL)
8918: THEN
8919: hr_nonrun_asact.insint(lockingactid => l_action_id
8920: ,lockedactid => l_24q_asg_action_id
8921: );
8922: END IF;
8923:
8930: pay_in_utils.trace('Value of l_locked_action_id for 24Q Correction is ',l_24q_asg_action_id);
8931:
8932: IF (l_24q_asg_action_id IS NOT NULL)
8933: THEN
8934: hr_nonrun_asact.insint(lockingactid => l_action_id
8935: ,lockedactid => l_24q_asg_action_id
8936: );
8937: END IF;
8938:
8945: pay_in_utils.trace('Value of l_locked_action_id for Previous 24Q Correction is ',l_24q_asg_action_id);
8946:
8947: IF (l_24q_asg_action_id IS NOT NULL)
8948: THEN
8949: hr_nonrun_asact.insint(lockingactid => l_action_id
8950: ,lockedactid => l_24q_asg_action_id
8951: );
8952: END IF;
8953: END IF;
8972: pay_in_utils.trace('Value of l_locked_action_id for 24Q is ',l_24q_asg_action_id);
8973:
8974: IF ((l_24q_asg_action_id IS NOT NULL) AND (l_lock_exists=0))
8975: THEN
8976: hr_nonrun_asact.insint(lockingactid => l_dummy
8977: ,lockedactid => l_24q_asg_action_id
8978: );
8979: END IF;
8980:
8992: pay_in_utils.trace('Value of l_locked_action_id for 24Q Correction is ',l_24q_asg_action_id);
8993:
8994: IF ((l_24q_asg_action_id IS NOT NULL) AND (l_lock_exists=0))
8995: THEN
8996: hr_nonrun_asact.insint(lockingactid => l_dummy
8997: ,lockedactid => l_24q_asg_action_id
8998: );
8999: END IF;
9000:
9012: pay_in_utils.trace('Value of l_locked_action_id for Previous 24Q Correction is ',l_24q_asg_action_id);
9013:
9014: IF ((l_24q_asg_action_id IS NOT NULL) AND (l_lock_exists=0))
9015: THEN
9016: hr_nonrun_asact.insint(lockingactid => l_dummy
9017: ,lockedactid => l_24q_asg_action_id
9018: );
9019: END IF;
9020: END IF;
9048:
9049: pay_in_utils.set_location(g_debug,'Value of l_action_id is '|| l_action_id, 61);
9050: pay_in_utils.set_location(g_debug,'Inserting Assignment action id ',61);
9051:
9052: hr_nonrun_asact.insact(lockingactid => l_action_id
9053: ,assignid => g_sal_data_rec_add(i).assignment_id
9054: ,pactid => p_payroll_action_id
9055: ,chunk => p_chunk
9056: );
9064: pay_in_utils.trace('Value of l_locked_action_id for 24Q is ',l_24q_asg_action_id);
9065:
9066: IF (l_24q_asg_action_id IS NOT NULL)
9067: THEN
9068: hr_nonrun_asact.insint(lockingactid => l_action_id
9069: ,lockedactid => l_24q_asg_action_id
9070: );
9071: END IF;
9072:
9079: pay_in_utils.trace('Value of l_locked_action_id for 24Q Correction is ',l_24q_asg_action_id);
9080:
9081: IF (l_24q_asg_action_id IS NOT NULL)
9082: THEN
9083: hr_nonrun_asact.insint(lockingactid => l_action_id
9084: ,lockedactid => l_24q_asg_action_id
9085: );
9086: END IF;
9087:
9094: pay_in_utils.trace('Value of l_locked_action_id for Previous 24Q Correction is ',l_24q_asg_action_id);
9095:
9096: IF (l_24q_asg_action_id IS NOT NULL)
9097: THEN
9098: hr_nonrun_asact.insint(lockingactid => l_action_id
9099: ,lockedactid => l_24q_asg_action_id
9100: );
9101: END IF;
9102:
9122: pay_in_utils.trace('Value of l_locked_action_id for 24Q is ',l_24q_asg_action_id);
9123:
9124: IF ((l_24q_asg_action_id IS NOT NULL) AND (l_lock_exists=0))
9125: THEN
9126: hr_nonrun_asact.insint(lockingactid => l_dummy
9127: ,lockedactid => l_24q_asg_action_id
9128: );
9129: END IF;
9130:
9142: pay_in_utils.trace('Value of l_locked_action_id for 24Q Correction is ',l_24q_asg_action_id);
9143:
9144: IF ((l_24q_asg_action_id IS NOT NULL) AND (l_lock_exists=0))
9145: THEN
9146: hr_nonrun_asact.insint(lockingactid => l_dummy
9147: ,lockedactid => l_24q_asg_action_id
9148: );
9149: END IF;
9150:
9162: pay_in_utils.trace('Value of l_locked_action_id for Previous 24Q Correction is ',l_24q_asg_action_id);
9163:
9164: IF ((l_24q_asg_action_id IS NOT NULL) AND (l_lock_exists=0))
9165: THEN
9166: hr_nonrun_asact.insint(lockingactid => l_dummy
9167: ,lockedactid => l_24q_asg_action_id
9168: );
9169: END IF;
9170: END IF;
9199:
9200: pay_in_utils.set_location(g_debug,'Value of l_action_id is '|| l_action_id, 61);
9201: pay_in_utils.set_location(g_debug,'Inserting Assignment action id ',61);
9202:
9203: hr_nonrun_asact.insact(lockingactid => l_action_id
9204: ,assignid => g_sal_data_rec_upd(i).assignment_id
9205: ,pactid => p_payroll_action_id
9206: ,chunk => p_chunk
9207: );
9215: pay_in_utils.trace('Value of l_locked_action_id for 24Q is ',l_24q_asg_action_id);
9216:
9217: IF (l_24q_asg_action_id IS NOT NULL)
9218: THEN
9219: hr_nonrun_asact.insint(lockingactid => l_action_id
9220: ,lockedactid => l_24q_asg_action_id
9221: );
9222: END IF;
9223: pay_in_utils.set_location(g_debug,'Enforcing Locking on 24Q Correction', 61);
9229: pay_in_utils.trace('Value of l_locked_action_id for 24Q Correction is ',l_24q_asg_action_id);
9230:
9231: IF (l_24q_asg_action_id IS NOT NULL)
9232: THEN
9233: hr_nonrun_asact.insint(lockingactid => l_action_id
9234: ,lockedactid => l_24q_asg_action_id
9235: );
9236: END IF;
9237:
9244: pay_in_utils.trace('Value of l_locked_action_id for Previous 24Q Correction is ',l_24q_asg_action_id);
9245:
9246: IF (l_24q_asg_action_id IS NOT NULL)
9247: THEN
9248: hr_nonrun_asact.insint(lockingactid => l_action_id
9249: ,lockedactid => l_24q_asg_action_id
9250: );
9251: END IF;
9252: END IF;
9271: pay_in_utils.trace('Value of l_locked_action_id for 24Q is ',l_24q_asg_action_id);
9272:
9273: IF ((l_24q_asg_action_id IS NOT NULL) AND (l_lock_exists=0))
9274: THEN
9275: hr_nonrun_asact.insint(lockingactid => l_dummy
9276: ,lockedactid => l_24q_asg_action_id
9277: );
9278: END IF;
9279:
9291: pay_in_utils.trace('Value of l_locked_action_id for 24Q Correction is ',l_24q_asg_action_id);
9292:
9293: IF ((l_24q_asg_action_id IS NOT NULL) AND (l_lock_exists=0))
9294: THEN
9295: hr_nonrun_asact.insint(lockingactid => l_dummy
9296: ,lockedactid => l_24q_asg_action_id
9297: );
9298: END IF;
9299:
9311: pay_in_utils.trace('Value of l_locked_action_id for Previous 24Q Correction is ',l_24q_asg_action_id);
9312:
9313: IF ((l_24q_asg_action_id IS NOT NULL) AND (l_lock_exists=0))
9314: THEN
9315: hr_nonrun_asact.insint(lockingactid => l_dummy
9316: ,lockedactid => l_24q_asg_action_id
9317: );
9318: END IF;
9319: END IF;
9362:
9363: pay_in_utils.set_location(g_debug,'Value of l_action_id is '|| l_action_id, 61);
9364: pay_in_utils.set_location(g_debug,'Inserting Assignment action id ',61);
9365:
9366: hr_nonrun_asact.insact(lockingactid => l_action_id
9367: ,assignid => g_ee_data_rec_del(i).assignment_id
9368: ,pactid => p_payroll_action_id
9369: ,chunk => p_chunk
9370: );
9378: pay_in_utils.trace('Value of l_locked_action_id for 24Q is ',l_24q_asg_action_id);
9379:
9380: IF (l_24q_asg_action_id IS NOT NULL)
9381: THEN
9382: hr_nonrun_asact.insint(lockingactid => l_action_id
9383: ,lockedactid => l_24q_asg_action_id
9384: );
9385: END IF;
9386:
9393: pay_in_utils.trace('Value of l_locked_action_id for 24Q Correction is ',l_24q_asg_action_id);
9394:
9395: IF (l_24q_asg_action_id IS NOT NULL)
9396: THEN
9397: hr_nonrun_asact.insint(lockingactid => l_action_id
9398: ,lockedactid => l_24q_asg_action_id
9399: );
9400: END IF;
9401:
9408: pay_in_utils.trace('Value of l_locked_action_id for Previous 24Q Correction is ',l_24q_asg_action_id);
9409:
9410: IF (l_24q_asg_action_id IS NOT NULL)
9411: THEN
9412: hr_nonrun_asact.insint(lockingactid => l_action_id
9413: ,lockedactid => l_24q_asg_action_id
9414: );
9415: END IF;
9416: END IF;
9438:
9439: pay_in_utils.set_location(g_debug,'Value of l_action_id is '|| l_action_id, 61);
9440: pay_in_utils.set_location(g_debug,'Inserting Assignment action id ',61);
9441:
9442: hr_nonrun_asact.insact(lockingactid => l_action_id
9443: ,assignid => g_ee_data_rec_add(i).assignment_id
9444: ,pactid => p_payroll_action_id
9445: ,chunk => p_chunk
9446: );
9454: pay_in_utils.trace('Value of l_locked_action_id for 24Q is ',l_24q_asg_action_id);
9455:
9456: IF (l_24q_asg_action_id IS NOT NULL)
9457: THEN
9458: hr_nonrun_asact.insint(lockingactid => l_action_id
9459: ,lockedactid => l_24q_asg_action_id
9460: );
9461: END IF;
9462:
9469: pay_in_utils.trace('Value of l_locked_action_id for 24Q Correction is ',l_24q_asg_action_id);
9470:
9471: IF (l_24q_asg_action_id IS NOT NULL)
9472: THEN
9473: hr_nonrun_asact.insint(lockingactid => l_action_id
9474: ,lockedactid => l_24q_asg_action_id
9475: );
9476: END IF;
9477:
9484: pay_in_utils.trace('Value of l_locked_action_id for Previous 24Q Correction is ',l_24q_asg_action_id);
9485:
9486: IF (l_24q_asg_action_id IS NOT NULL)
9487: THEN
9488: hr_nonrun_asact.insint(lockingactid => l_action_id
9489: ,lockedactid => l_24q_asg_action_id
9490: );
9491: END IF;
9492:
9518:
9519: pay_in_utils.set_location(g_debug,'Value of l_action_id is '|| l_action_id, 61);
9520: pay_in_utils.set_location(g_debug,'Inserting Assignment action id ',61);
9521:
9522: hr_nonrun_asact.insact(lockingactid => l_action_id
9523: ,assignid => g_ee_data_rec_upd(i).assignment_id
9524: ,pactid => p_payroll_action_id
9525: ,chunk => p_chunk
9526: );
9534: pay_in_utils.trace('Value of l_locked_action_id for 24Q is ',l_24q_asg_action_id);
9535:
9536: IF (l_24q_asg_action_id IS NOT NULL)
9537: THEN
9538: hr_nonrun_asact.insint(lockingactid => l_action_id
9539: ,lockedactid => l_24q_asg_action_id
9540: );
9541: END IF;
9542: pay_in_utils.set_location(g_debug,'Enforcing Locking on 24Q Correction', 61);
9548: pay_in_utils.trace('Value of l_locked_action_id for 24Q Correction is ',l_24q_asg_action_id);
9549:
9550: IF (l_24q_asg_action_id IS NOT NULL)
9551: THEN
9552: hr_nonrun_asact.insint(lockingactid => l_action_id
9553: ,lockedactid => l_24q_asg_action_id
9554: );
9555: END IF;
9556:
9563: pay_in_utils.trace('Value of l_locked_action_id for Previous 24Q Correction is ',l_24q_asg_action_id);
9564:
9565: IF (l_24q_asg_action_id IS NOT NULL)
9566: THEN
9567: hr_nonrun_asact.insint(lockingactid => l_action_id
9568: ,lockedactid => l_24q_asg_action_id
9569: );
9570: END IF;
9571: END IF;