[Home] [Help]
971: into dummy
972: from dual
973: where not exists (
974: select null
975: from pay_action_interlocks int,
976: pay_assignment_actions act
977: where int.locked_action_id = p_assact_rec.assact_id
978: and act.assignment_action_id = int.locking_action_id
979: and act.action_status <> 'M');
985: into dummy
986: from dual
987: where not exists (
988: select null
989: from pay_action_interlocks int
990: where int.locked_action_id = p_assact_rec.assact_id);
991: end if;
992: --
993: -- Now, if we have a balance adjustment or Reversal,
1921: -- which are locking other assignment actions.
1922: if g_debug then
1923: hr_utility.set_location('hrassact.do_assact_rollback',190);
1924: end if;
1925: delete from pay_action_interlocks lck
1926: where lck.locking_action_id = p_assact_rec.assact_id;
1927: --
1928: if g_debug then
1929: hr_utility.set_location('hrassact.do_assact_rollback',200);
1938: if(p_rollback_mode = 'ROLLBACK') then
1939: if g_debug then
1940: hr_utility.set_location('hrassact.do_assact_rollback',210);
1941: end if;
1942: delete from pay_action_interlocks lck
1943: where lck.locking_action_id = p_assact_rec.assact_id;
1944: end if;
1945: end if;
1946: --
3773: --
3774: -- Cursor definitions
3775: cursor interlocks(p_locking_action_id number) is
3776: select int.locked_action_id locked_action_id
3777: from pay_action_interlocks int
3778: where int.locking_action_id = p_locking_action_id
3779: order by int.locked_action_id;
3780: --
3781: -- Local variables
5051: from pay_assignment_actions act
5052: where act.pre_payment_id = p_pre_payment_id
5053: and not exists
5054: ( select null
5055: from pay_action_interlocks loc1,
5056: pay_assignment_actions actv,
5057: pay_payroll_actions pactv
5058: where loc1.locked_action_id = act.assignment_action_id
5059: and loc1.locking_action_id = actv.assignment_action_id
5116: and not exists (
5117: select null
5118: from pay_assignment_actions ac2,
5119: pay_payroll_actions pa3,
5120: pay_action_interlocks int
5121: where int.locked_action_id = act.assignment_action_id
5122: and ac2.assignment_action_id = int.locking_action_id
5123: and pa3.payroll_action_id = ac2.payroll_action_id
5124: and pa3.action_type in ('P', 'U'))
5269: -- We can now insert interlock row.
5270: if g_debug then
5271: hr_utility.set_location('hrassact.qpppassact',40);
5272: end if;
5273: insert into pay_action_interlocks (
5274: locking_action_id,
5275: locked_action_id)
5276: values (l_locking_action_id,
5277: l_locked_action_id);
5468: -- this row.
5469: if g_debug then
5470: hr_utility.set_location('hrassact.reversal',20);
5471: end if;
5472: insert into pay_action_interlocks (
5473: locking_action_id,
5474: locked_action_id)
5475: select rev_assact,
5476: assactid
5478: where not exists (
5479: select null
5480: from pay_assignment_actions ac2,
5481: pay_payroll_actions pa2,
5482: pay_action_interlocks pai
5483: where pai.locked_action_id = assactid
5484: and ac2.assignment_action_id = pai.locking_action_id
5485: and pa2.payroll_action_id = ac2.payroll_action_id
5486: and pa2.action_type = 'V');
5492: hr_utility.set_location('hrassact.reversal',10);
5493: --
5494: -- insert lock to master action if this is a sub action
5495:
5496: insert into pay_action_interlocks (
5497: locking_action_id,
5498: locked_action_id)
5499: select rev_assact, paa1.assignment_action_id
5500: from pay_assignment_actions paa,pay_assignment_actions paa1
5513: where act.payroll_action_id = pactid
5514: and act.assignment_id = asgid;
5515:
5516: --create new interlock if needed
5517: insert into pay_action_interlocks
5518: (locking_action_id,locked_action_id)
5519: select rev_assact,assactid
5520: from dual where not exists (select 1
5521: from pay_action_interlocks
5517: insert into pay_action_interlocks
5518: (locking_action_id,locked_action_id)
5519: select rev_assact,assactid
5520: from dual where not exists (select 1
5521: from pay_action_interlocks
5522: where locking_action_id=rev_assact
5523: and locked_action_id=assactid);
5524:
5525:
5874: If hrassact.gv_cnt_reversal_act_id is null then
5875:
5876: SELECT count(*)
5877: INTO hrassact.gv_cnt_reversal_act_id
5878: FROM pay_action_interlocks pai,
5879: pay_assignment_actions paa
5880: WHERE paa.payroll_action_id = pactid
5881: AND paa.assignment_action_id = pai.locking_action_id;
5882: end if;
5928: pee.entry_type,
5929: pee.element_entry_id
5930: from pay_payroll_actions pac,
5931: pay_assignment_actions act,
5932: pay_action_interlocks pai,
5933: pay_assignment_actions act2,
5934: pay_run_results rr2,
5935: pay_element_entries_f pee,
5936: pay_element_links_f pel,
6102: -- insert a pay action interlock record.
6103: if g_debug then
6104: hr_utility.set_location(c_indent,30);
6105: end if;
6106: insert into PAY_ACTION_INTERLOCKS
6107: (LOCKING_ACTION_ID,
6108: LOCKED_ACTION_ID)
6109: values
6110: (l_assignment_action_id,
8608:
8609: -- determine the master action
8610: SELECT pai.locked_action_id
8611: INTO l_mst_id
8612: FROM pay_action_interlocks pai,pay_assignment_actions paa
8613: WHERE pai.locking_action_id = p_act_id
8614: AND paa.assignment_action_id = pai.locked_action_id
8615: AND paa.source_action_id is null;
8616:
8628: into new_assactid
8629: from pay_assignment_actions mast_asg,
8630: pay_assignment_actions child_asg,
8631: pay_assignment_actions rev_asg,
8632: pay_action_interlocks pai
8633: where l_mst_id=mast_asg.assignment_action_id
8634: and child_asg.source_action_id is not null
8635: and child_asg.assignment_id=mast_asg.assignment_id
8636: and child_asg.payroll_action_id=mast_asg.payroll_action_id