312: -- for each assignment/pre-payment/reversal).
313:
314: select pay_assignment_actions_s.nextval
315: into lockingactid
316: from dual;
317:
318: hr_utility.set_location(l_procedure_name, 30);
319: -- insert the action record.
320: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
381: close c_state_ueid;
382:
383: hr_utility.set_location(l_procedure_name, 70);
384: c_actions_with_state_sql := c_actions_with_state_sql ||
385: ' AND exists ( select 1 from dual
386: where 1 =
387: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
388: from ff_archive_items fai,
389: ff_archive_item_contexts fic1,
414: close c_state_ueid;
415:
416: hr_utility.set_location(l_procedure_name, 90);
417: c_actions_with_state_sql := c_actions_with_state_sql ||
418: ' AND exists ( select 1 from dual
419: where 1 =
420: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
421: from ff_archive_items fai,
422: ff_archive_item_contexts fic1,
448: hr_utility.trace('l_subj_whable='||l_subj_whable);
449: hr_utility.trace('l_subj_nwhable='||l_subj_nwhable);
450:
451: c_actions_with_state_sql := c_actions_with_state_sql ||
452: ' AND exists ( select 1 from dual
453: where 1 =
454: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
455: from ff_archive_items fai,
456: ff_archive_item_contexts fic1,
479: fetch c_state_ueid into l_subj_nwhable;
480: close c_state_ueid;
481:
482: c_actions_with_state_sql := c_actions_with_state_sql ||
483: ' AND exists ( select 1 from dual
484: where 1 =
485: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
486: from ff_archive_items fai,
487: ff_archive_item_contexts fic1,
516: end if;
517: hr_utility.set_location(l_procedure_name, 160);
518: select pay_assignment_actions_s.nextval
519: into lockingactid
520: from dual;
521:
522: -- insert the action record.
523: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
524:
555:
556: hr_utility.set_location(l_procedure_name, 180);
557: select pay_assignment_actions_s.nextval
558: into lockingactid
559: from dual;
560:
561: -- insert the action record.
562: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
563:
740: --
741: cursor csr_inv_act
742: is
743: select 'Y'
744: from dual
745: where exists(
746: select /*+ ORDERED */
747: null
748: from pay_payroll_actions ppa,