APPS.PY_ROLLBACK_PKG dependencies on DUAL

Line 2011: * Internal procedure : called for an individual assignment

2007: --
2008: end do_assact_rollback;
2009: --
2010: /*
2011: * Internal procedure : called for an individual assignment
2012: * action to validate that a rollback or mark for retry is
2013: * legal. Note, it does not guarantee that the rollback
2014: * will succeed, as this does not perform any dml.
2015: *

Line 2238: from dual

2234: hr_utility.set_location(c_indent, 20);
2235: end if;
2236: select null
2237: into dummy
2238: from dual
2239: where not exists (
2240: select null
2241: from pay_action_interlocks int,
2242: pay_assignment_actions act

Line 2266: from dual

2262: hr_utility.trace('before checking for interlocking in action interlocks');
2263: end if;
2264: select null
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);

Line 2303: from dual

2299: --
2300: if (p_info.rollback_mode = 'RETRY')
2301: then
2302: select null into dummy
2303: from dual
2304: where not exists
2305: (select null
2306: from pay_assignment_actions ACT,
2307: pay_payroll_actions PACT,

Line 2317: from dual

2313: and PACT.action_type = CLASS.action_type
2314: and CLASS.classification_name = 'SEQUENCED');
2315: else
2316: select null into dummy
2317: from dual
2318: where not exists
2319: (select null
2320: from pay_assignment_actions ACT,
2321: pay_payroll_actions PACT,

Line 2345: from dual

2341: and p_info.object_type = 'POG') then
2342: if (p_info.rollback_mode = 'RETRY')
2343: then
2344: select null into dummy
2345: from dual
2346: where not exists
2347: (select null
2348: from pay_action_classifications CLASS,
2349: pay_payroll_actions PACT,

Line 2367: from dual

2363: and PACT.action_type = CLASS.action_type
2364: and CLASS.classification_name = 'SEQUENCED');
2365: else
2366: select null into dummy
2367: from dual
2368: where not exists
2369: (select null
2370: from pay_action_classifications CLASS,
2371: pay_payroll_actions PACT,

Line 2394: from dual

2390: if (p_info.rollback_mode = 'RETRY')
2391: then
2392:
2393: select null into dummy
2394: from dual
2395: where not exists
2396: (select null
2397: from pay_action_classifications CLASS,
2398: pay_payroll_actions PACT,

Line 2414: from dual

2410: and PACT.action_type = CLASS.action_type
2411: and CLASS.classification_name = 'SEQUENCED');
2412: else
2413: select null into dummy
2414: from dual
2415: where not exists
2416: (select null
2417: from pay_action_classifications CLASS,
2418: pay_payroll_actions PACT,

Line 2447: from dual

2443: --
2444: if (p_info.rollback_mode = 'RETRY')
2445: then
2446: select null into dummy
2447: from dual
2448: where not exists
2449: (select null
2450: from pay_action_classifications CLASS,
2451: pay_payroll_actions PACT,

Line 2465: from dual

2461: and PACT.action_type = CLASS.action_type
2462: and CLASS.classification_name = 'SEQUENCED');
2463: else
2464: select null into dummy
2465: from dual
2466: where not exists
2467: (select null
2468: from pay_action_classifications CLASS,
2469: pay_payroll_actions PACT,

Line 2493: from dual

2489: --
2490: if p_info.action_type = 'D' then
2491: select null
2492: into dummy
2493: from dual
2494: where not exists (select null
2495: from
2496: pay_assignment_actions paac2,
2497: pay_assignment_actions paac,

Line 2988: -- allow rollback of individual Magnetic Transfer assact.

2984: hr_utility.raise_error;
2985: end if;
2986: else
2987: -- !!!! note - temporary change for RN project.
2988: -- allow rollback of individual Magnetic Transfer assact.
2989: if(p_info.action_type in ('Q', 'U', 'E', 'PRU') or
2990: (p_info.action_type = 'T' and p_info.sub_ledger_acc = 'N'))
2991: then
2992: hr_utility.set_message(801, 'HR_7508_ACTION_ACT_RR_RULE');

Line 3116: from sys.dual

3112: dummy number;
3113: begin
3114: select null
3115: into dummy
3116: from sys.dual
3117: where exists (
3118: select null
3119: from pay_assignment_actions act
3120: where act.payroll_action_id = p_payroll_action_id);