APPS.PY_ROLLBACK_PKG dependencies on DUAL

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

1928: --
1929: end do_assact_rollback;
1930: --
1931: /*
1932: * Internal procedure : called for an individual assignment
1933: * action to validate that a rollback or mark for retry is
1934: * legal. Note, it does not guarantee that the rollback
1935: * will succeed, as this does not perform any dml.
1936: *

Line 2159: from dual

2155: hr_utility.set_location(c_indent, 20);
2156: end if;
2157: select null
2158: into dummy
2159: from dual
2160: where not exists (
2161: select null
2162: from pay_action_interlocks int,
2163: pay_assignment_actions act

Line 2185: from dual

2181: hr_utility.set_location(c_indent, 30);
2182: end if;
2183: select null
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);

Line 2221: from dual

2217: --
2218: if (p_info.rollback_mode = 'RETRY')
2219: then
2220: select null into dummy
2221: from dual
2222: where not exists
2223: (select null
2224: from pay_assignment_actions ACT,
2225: pay_payroll_actions PACT,

Line 2235: from dual

2231: and PACT.action_type = CLASS.action_type
2232: and CLASS.classification_name = 'SEQUENCED');
2233: else
2234: select null into dummy
2235: from dual
2236: where not exists
2237: (select null
2238: from pay_assignment_actions ACT,
2239: pay_payroll_actions PACT,

Line 2261: from dual

2257: and p_info.object_type = 'POG') then
2258: if (p_info.rollback_mode = 'RETRY')
2259: then
2260: select null into dummy
2261: from dual
2262: where not exists
2263: (select null
2264: from pay_action_classifications CLASS,
2265: pay_payroll_actions PACT,

Line 2283: from dual

2279: and PACT.action_type = CLASS.action_type
2280: and CLASS.classification_name = 'SEQUENCED');
2281: else
2282: select null into dummy
2283: from dual
2284: where not exists
2285: (select null
2286: from pay_action_classifications CLASS,
2287: pay_payroll_actions PACT,

Line 2309: from dual

2305: if (p_info.rollback_mode = 'RETRY')
2306: then
2307:
2308: select null into dummy
2309: from dual
2310: where not exists
2311: (select null
2312: from pay_action_classifications CLASS,
2313: pay_payroll_actions PACT,

Line 2329: from dual

2325: and PACT.action_type = CLASS.action_type
2326: and CLASS.classification_name = 'SEQUENCED');
2327: else
2328: select null into dummy
2329: from dual
2330: where not exists
2331: (select null
2332: from pay_action_classifications CLASS,
2333: pay_payroll_actions PACT,

Line 2360: from dual

2356: --
2357: if (p_info.rollback_mode = 'RETRY')
2358: then
2359: select null into dummy
2360: from dual
2361: where not exists
2362: (select null
2363: from pay_action_classifications CLASS,
2364: pay_payroll_actions PACT,

Line 2378: from dual

2374: and PACT.action_type = CLASS.action_type
2375: and CLASS.classification_name = 'SEQUENCED');
2376: else
2377: select null into dummy
2378: from dual
2379: where not exists
2380: (select null
2381: from pay_action_classifications CLASS,
2382: pay_payroll_actions PACT,

Line 2405: from dual

2401: --
2402: if p_info.action_type = 'D' then
2403: select null
2404: into dummy
2405: from dual
2406: where not exists (select null
2407: from
2408: pay_assignment_actions paac2,
2409: pay_assignment_actions paac,

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

2863: hr_utility.raise_error;
2864: end if;
2865: else
2866: -- !!!! note - temporary change for RN project.
2867: -- allow rollback of individual Magnetic Transfer assact.
2868: if(p_info.action_type in ('Q', 'U', 'E', 'PRU') or
2869: (p_info.action_type = 'T' and p_info.sub_ledger_acc = 'N'))
2870: then
2871: hr_utility.set_message(801, 'HR_7508_ACTION_ACT_RR_RULE');

Line 2995: from sys.dual

2991: dummy number;
2992: begin
2993: select null
2994: into dummy
2995: from sys.dual
2996: where exists (
2997: select null
2998: from pay_assignment_actions act
2999: where act.payroll_action_id = p_payroll_action_id);