APPS.PY_ROLLBACK_PKG dependencies on PAY_ACTION_INTERLOCKS

Line 1625: delete from pay_action_interlocks lck

1621: -- which are locking other assignment actions.
1622: if g_debug then
1623: hr_utility.set_location(c_indent, 30);
1624: end if;
1625: delete from pay_action_interlocks lck
1626: where lck.locking_action_id = p_info.assact_id;
1627: --
1628: remove_archive_items(p_info, p_info.assact_id, 'AAC');
1629: remove_action_information(p_info.assact_id, 'AAC');

Line 1649: delete from pay_action_interlocks lck

1645: --
1646: delete from pay_assignment_actions
1647: where source_action_id = p_info.assact_id;
1648: --
1649: delete from pay_action_interlocks lck
1650: where lck.locking_action_id = p_info.assact_id;
1651: --
1652: end if;
1653: end if;

Line 1734: delete from pay_action_interlocks

1730: purge_child := FALSE;
1731: end if;
1732: --
1733: if (purge_child = TRUE) then
1734: delete from pay_action_interlocks
1735: where locking_action_id = chld_info.assact_id;
1736: if g_debug then
1737: hr_utility.set_location('About to remove assg actions' , 11);
1738: end if;

Line 2241: from pay_action_interlocks int,

2237: into dummy
2238: from dual
2239: where not exists (
2240: select null
2241: from pay_action_interlocks int,
2242: pay_assignment_actions act
2243: where int.locked_action_id = p_info.assact_id
2244: and act.assignment_action_id = int.locking_action_id
2245: and ((exists

Line 2269: from pay_action_interlocks int

2265: into dummy
2266: from dual
2267: where not exists (
2268: select null
2269: from pay_action_interlocks int
2270: where int.locked_action_id = p_info.assact_id);
2271: end if;
2272: --
2273: -- Now, the following checks are only applicable to sequenced

Line 2498: pay_action_interlocks pai

2494: where not exists (select null
2495: from
2496: pay_assignment_actions paac2,
2497: pay_assignment_actions paac,
2498: pay_action_interlocks pai
2499: where pai.locking_action_id = p_info.assact_id
2500: and pai.locked_action_id = paac.assignment_action_id
2501: and paac.pre_payment_id = paac2.pre_payment_id
2502: and paac2.action_sequence > paac.action_sequence);

Line 2930: pay_action_interlocks pai,

2926:
2927: cursor chk_dep is
2928: select distinct pac.payroll_action_id
2929: from pay_assignment_actions act2,
2930: pay_action_interlocks pai,
2931: pay_assignment_actions act,
2932: pay_payroll_actions pac,
2933: pay_payroll_actions pac2
2934: where pac2.payroll_action_id = p_info.pact_id

Line 3331: pay_action_interlocks locks

3327: into l_date_earned
3328: from pay_payroll_actions locked_pact,
3329: pay_assignment_actions locked,
3330: pay_assignment_actions locking,
3331: pay_action_interlocks locks
3332: where locking.payroll_action_id =info.pact_id
3333: and locking.assignment_action_id =locks.locking_action_id
3334: and locked.assignment_action_id =locks.locked_action_id
3335: and locked.payroll_action_id =locked_pact.payroll_action_id;

Line 3477: pay_action_interlocks locks,

3473: into l_date_earned, l_current_date_earned
3474: from pay_payroll_actions locked_pact,
3475: pay_assignment_actions locked,
3476: pay_assignment_actions locking,
3477: pay_action_interlocks locks,
3478: pay_payroll_actions locking_pact
3479: where locking_pact.payroll_action_id =info.pact_id
3480: and locking.payroll_action_id =locking_pact.payroll_action_id
3481: and locking.assignment_action_id =locks.locking_action_id