eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HRASSACT dependencies on PAY_ACTION_INTERLOCKS

Line 943: from pay_action_interlocks int,

939: into dummy
940: from dual
941: where not exists (
942: select null
943: from pay_action_interlocks int,
944: pay_assignment_actions act
945: where int.locked_action_id = p_assact_rec.assact_id
946: and act.assignment_action_id = int.locking_action_id
947: and act.action_status <> 'M');

Line 957: from pay_action_interlocks int

953: into dummy
954: from dual
955: where not exists (
956: select null
957: from pay_action_interlocks int
958: where int.locked_action_id = p_assact_rec.assact_id);
959: end if;
960: --
961: -- Now, if we have a balance adjustment or Reversal,

Line 1893: delete from pay_action_interlocks lck

1889: -- which are locking other assignment actions.
1890: if g_debug then
1891: hr_utility.set_location('hrassact.do_assact_rollback',190);
1892: end if;
1893: delete from pay_action_interlocks lck
1894: where lck.locking_action_id = p_assact_rec.assact_id;
1895: --
1896: if g_debug then
1897: hr_utility.set_location('hrassact.do_assact_rollback',200);

Line 1910: delete from pay_action_interlocks lck

1906: if(p_rollback_mode = 'ROLLBACK') then
1907: if g_debug then
1908: hr_utility.set_location('hrassact.do_assact_rollback',210);
1909: end if;
1910: delete from pay_action_interlocks lck
1911: where lck.locking_action_id = p_assact_rec.assact_id;
1912: end if;
1913: end if;
1914: --

Line 3757: from pay_action_interlocks int

3753: --
3754: -- Cursor definitions
3755: cursor interlocks(p_locking_action_id number) is
3756: select int.locked_action_id locked_action_id
3757: from pay_action_interlocks int
3758: where int.locking_action_id = p_locking_action_id
3759: order by int.locked_action_id;
3760: --
3761: -- Local variables

Line 4823: from pay_action_interlocks loc1,

4819: from pay_assignment_actions act
4820: where act.pre_payment_id = p_pre_payment_id
4821: and not exists
4822: ( select null
4823: from pay_action_interlocks loc1,
4824: pay_assignment_actions actv,
4825: pay_payroll_actions pactv
4826: where loc1.locked_action_id = act.assignment_action_id
4827: and loc1.locking_action_id = actv.assignment_action_id

Line 4888: pay_action_interlocks int

4884: and not exists (
4885: select null
4886: from pay_assignment_actions ac2,
4887: pay_payroll_actions pa3,
4888: pay_action_interlocks int
4889: where int.locked_action_id = act.assignment_action_id
4890: and ac2.assignment_action_id = int.locking_action_id
4891: and pa3.payroll_action_id = ac2.payroll_action_id
4892: and pa3.action_type in ('P', 'U'))

Line 5041: insert into pay_action_interlocks (

5037: -- We can now insert interlock row.
5038: if g_debug then
5039: hr_utility.set_location('hrassact.qpppassact',40);
5040: end if;
5041: insert into pay_action_interlocks (
5042: locking_action_id,
5043: locked_action_id)
5044: values (l_locking_action_id,
5045: l_locked_action_id);

Line 5240: insert into pay_action_interlocks (

5236: -- this row.
5237: if g_debug then
5238: hr_utility.set_location('hrassact.reversal',20);
5239: end if;
5240: insert into pay_action_interlocks (
5241: locking_action_id,
5242: locked_action_id)
5243: select rev_assact,
5244: assactid

Line 5250: pay_action_interlocks pai

5246: where not exists (
5247: select null
5248: from pay_assignment_actions ac2,
5249: pay_payroll_actions pa2,
5250: pay_action_interlocks pai
5251: where pai.locked_action_id = assactid
5252: and ac2.assignment_action_id = pai.locking_action_id
5253: and pa2.payroll_action_id = ac2.payroll_action_id
5254: and pa2.action_type = 'V');

Line 5264: insert into pay_action_interlocks (

5260: hr_utility.set_location('hrassact.reversal',10);
5261: --
5262: -- insert lock to master action if this is a sub action
5263:
5264: insert into pay_action_interlocks (
5265: locking_action_id,
5266: locked_action_id)
5267: select rev_assact, paa1.assignment_action_id
5268: from pay_assignment_actions paa,pay_assignment_actions paa1

Line 5285: insert into pay_action_interlocks

5281: where act.payroll_action_id = pactid
5282: and act.assignment_id = asgid;
5283:
5284: --create new interlock if needed
5285: insert into pay_action_interlocks
5286: (locking_action_id,locked_action_id)
5287: select rev_assact,assactid
5288: from dual where not exists (select 1
5289: from pay_action_interlocks

Line 5289: from pay_action_interlocks

5285: insert into pay_action_interlocks
5286: (locking_action_id,locked_action_id)
5287: select rev_assact,assactid
5288: from dual where not exists (select 1
5289: from pay_action_interlocks
5290: where locking_action_id=rev_assact
5291: and locked_action_id=assactid);
5292:
5293:

Line 5668: pay_action_interlocks pai,

5664: pee.entry_type,
5665: pee.element_entry_id
5666: from pay_payroll_actions pac,
5667: pay_assignment_actions act,
5668: pay_action_interlocks pai,
5669: pay_assignment_actions act2,
5670: pay_run_results rr2,
5671: pay_element_entries_f pee,
5672: pay_element_links_f pel,

Line 5842: insert into PAY_ACTION_INTERLOCKS

5838: -- insert a pay action interlock record.
5839: if g_debug then
5840: hr_utility.set_location(c_indent,30);
5841: end if;
5842: insert into PAY_ACTION_INTERLOCKS
5843: (LOCKING_ACTION_ID,
5844: LOCKED_ACTION_ID)
5845: values
5846: (l_assignment_action_id,

Line 8350: FROM pay_action_interlocks pai,pay_assignment_actions paa

8346:
8347: -- determine the master action
8348: SELECT pai.locked_action_id
8349: INTO l_mst_id
8350: FROM pay_action_interlocks pai,pay_assignment_actions paa
8351: WHERE pai.locking_action_id = p_act_id
8352: AND paa.assignment_action_id = pai.locked_action_id
8353: AND paa.source_action_id is null;
8354: