APPS.PY_ROLLBACK_PKG dependencies on PAY_ACTION_INTERLOCKS

Line 1620: delete from pay_action_interlocks lck

1616: -- which are locking other assignment actions.
1617: if g_debug then
1618: hr_utility.set_location(c_indent, 30);
1619: end if;
1620: delete from pay_action_interlocks lck
1621: where lck.locking_action_id = p_info.assact_id;
1622: --
1623: remove_archive_items(p_info, p_info.assact_id, 'AAC');
1624: remove_action_information(p_info.assact_id, 'AAC');

Line 1644: delete from pay_action_interlocks lck

1640: --
1641: delete from pay_assignment_actions
1642: where source_action_id = p_info.assact_id;
1643: --
1644: delete from pay_action_interlocks lck
1645: where lck.locking_action_id = p_info.assact_id;
1646: --
1647: end if;
1648: end if;

Line 1711: delete from pay_action_interlocks

1707: purge_child := FALSE;
1708: end if;
1709: --
1710: if (purge_child = TRUE) then
1711: delete from pay_action_interlocks
1712: where locking_action_id = chld_info.assact_id;
1713: if g_debug then
1714: hr_utility.set_location('About to remove assg actions' , 11);
1715: end if;

Line 2162: from pay_action_interlocks int,

2158: into dummy
2159: from dual
2160: where not exists (
2161: select null
2162: from pay_action_interlocks int,
2163: pay_assignment_actions act
2164: where int.locked_action_id = p_info.assact_id
2165: and act.assignment_action_id = int.locking_action_id
2166: and ((exists

Line 2188: from pay_action_interlocks int

2184: into dummy
2185: from dual
2186: where not exists (
2187: select null
2188: from pay_action_interlocks int
2189: where int.locked_action_id = p_info.assact_id);
2190: end if;
2191: --
2192: -- Now, the following checks are only applicable to sequenced

Line 2410: pay_action_interlocks pai

2406: where not exists (select null
2407: from
2408: pay_assignment_actions paac2,
2409: pay_assignment_actions paac,
2410: pay_action_interlocks pai
2411: where pai.locking_action_id = p_info.assact_id
2412: and pai.locked_action_id = paac.assignment_action_id
2413: and paac.pre_payment_id = paac2.pre_payment_id
2414: and paac2.action_sequence > paac.action_sequence);

Line 2809: pay_action_interlocks pai,

2805:
2806: cursor chk_dep is
2807: select distinct pac.payroll_action_id
2808: from pay_assignment_actions act2,
2809: pay_action_interlocks pai,
2810: pay_assignment_actions act,
2811: pay_payroll_actions pac,
2812: pay_payroll_actions pac2
2813: where pac2.payroll_action_id = p_info.pact_id

Line 3210: pay_action_interlocks locks

3206: into l_date_earned
3207: from pay_payroll_actions locked_pact,
3208: pay_assignment_actions locked,
3209: pay_assignment_actions locking,
3210: pay_action_interlocks locks
3211: where locking.payroll_action_id =info.pact_id
3212: and locking.assignment_action_id =locks.locking_action_id
3213: and locked.assignment_action_id =locks.locked_action_id
3214: and locked.payroll_action_id =locked_pact.payroll_action_id;

Line 3356: pay_action_interlocks locks,

3352: into l_date_earned, l_current_date_earned
3353: from pay_payroll_actions locked_pact,
3354: pay_assignment_actions locked,
3355: pay_assignment_actions locking,
3356: pay_action_interlocks locks,
3357: pay_payroll_actions locking_pact
3358: where locking_pact.payroll_action_id =info.pact_id
3359: and locking.payroll_action_id =locking_pact.payroll_action_id
3360: and locking.assignment_action_id =locks.locking_action_id