DBA Data[Home] [Help]

APPS.PAY_IN_24QC_ARCHIVE dependencies on HR_NONRUN_ASACT

Line 8282: hr_nonrun_asact.insact(lockingactid => l_action_id

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: );

Line 8288: hr_nonrun_asact.insint(lockingactid => l_action_id

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;

Line 8314: hr_nonrun_asact.insact(lockingactid => l_action_id

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: );

Line 8332: hr_nonrun_asact.insint(lockingactid => l_action_id

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;

Line 8366: hr_nonrun_asact.insact(lockingactid => l_action_id

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: );

Line 8384: hr_nonrun_asact.insint(lockingactid => l_action_id

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;

Line 8903: hr_nonrun_asact.insact(lockingactid => l_action_id

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: );

Line 8919: hr_nonrun_asact.insint(lockingactid => l_action_id

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:

Line 8934: hr_nonrun_asact.insint(lockingactid => l_action_id

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:

Line 8949: hr_nonrun_asact.insint(lockingactid => l_action_id

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;

Line 8976: hr_nonrun_asact.insint(lockingactid => l_dummy

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:

Line 8996: hr_nonrun_asact.insint(lockingactid => l_dummy

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:

Line 9016: hr_nonrun_asact.insint(lockingactid => l_dummy

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;

Line 9052: hr_nonrun_asact.insact(lockingactid => l_action_id

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: );

Line 9068: hr_nonrun_asact.insint(lockingactid => l_action_id

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:

Line 9083: hr_nonrun_asact.insint(lockingactid => l_action_id

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:

Line 9098: hr_nonrun_asact.insint(lockingactid => l_action_id

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:

Line 9126: hr_nonrun_asact.insint(lockingactid => l_dummy

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:

Line 9146: hr_nonrun_asact.insint(lockingactid => l_dummy

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:

Line 9166: hr_nonrun_asact.insint(lockingactid => l_dummy

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;

Line 9203: hr_nonrun_asact.insact(lockingactid => l_action_id

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: );

Line 9219: hr_nonrun_asact.insint(lockingactid => l_action_id

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);

Line 9233: hr_nonrun_asact.insint(lockingactid => l_action_id

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:

Line 9248: hr_nonrun_asact.insint(lockingactid => l_action_id

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;

Line 9275: hr_nonrun_asact.insint(lockingactid => l_dummy

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:

Line 9295: hr_nonrun_asact.insint(lockingactid => l_dummy

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:

Line 9315: hr_nonrun_asact.insint(lockingactid => l_dummy

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;

Line 9366: hr_nonrun_asact.insact(lockingactid => l_action_id

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: );

Line 9382: hr_nonrun_asact.insint(lockingactid => l_action_id

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:

Line 9397: hr_nonrun_asact.insint(lockingactid => l_action_id

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:

Line 9412: hr_nonrun_asact.insint(lockingactid => l_action_id

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;

Line 9442: hr_nonrun_asact.insact(lockingactid => l_action_id

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: );

Line 9458: hr_nonrun_asact.insint(lockingactid => l_action_id

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:

Line 9473: hr_nonrun_asact.insint(lockingactid => l_action_id

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:

Line 9488: hr_nonrun_asact.insint(lockingactid => l_action_id

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:

Line 9522: hr_nonrun_asact.insact(lockingactid => l_action_id

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: );

Line 9538: hr_nonrun_asact.insint(lockingactid => l_action_id

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);

Line 9552: hr_nonrun_asact.insint(lockingactid => l_action_id

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:

Line 9567: hr_nonrun_asact.insint(lockingactid => l_action_id

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;