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.PY_ROLLBACK_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 21: object_type pay_assignment_actions.object_type%type,

17: bg_id hr_organization_units.business_group_id%type,
18: independent_periods_flag pay_legislation_rules.rule_mode%type,
19: date_earned date,
20: purge_phase pay_payroll_actions.purge_phase%type,
21: object_type pay_assignment_actions.object_type%type,
22: retro_definition_id pay_payroll_actions.retro_definition_id%type,
23: batch_id pay_payroll_actions.batch_id%type,
24: --
25: -- Assignment Action Level Details.

Line 26: assact_id pay_assignment_actions.assignment_action_id%type,

22: retro_definition_id pay_payroll_actions.retro_definition_id%type,
23: batch_id pay_payroll_actions.batch_id%type,
24: --
25: -- Assignment Action Level Details.
26: assact_id pay_assignment_actions.assignment_action_id%type,
27: assignment_id per_all_assignments_f.assignment_id%type,
28: full_name per_all_people_f.full_name%type,
29: assignment_number per_all_assignments_f.assignment_number%type,
30: payroll_id pay_all_payrolls_f.payroll_id%type,

Line 232: pay_assignment_actions paa

228: c_indent varchar2(40);
229: cursor ceev is
230: select pee.element_entry_id
231: from pay_element_entries_f pee,
232: pay_assignment_actions paa
233: where paa.assignment_action_id = p_assact_id
234: and pee.assignment_id = paa.assignment_id
235: and pee.creator_id = paa.assignment_action_id
236: and pee.creator_type = 'P';

Line 268: pay_assignment_actions paa

264: c_indent varchar2(40);
265: cursor aeev is
266: select pee.element_entry_id
267: from pay_element_entries_f pee,
268: pay_assignment_actions paa
269: where paa.assignment_action_id = p_assact_id
270: and pee.assignment_id = paa.assignment_id
271: and pee.creator_id = paa.assignment_action_id
272: and pee.creator_type = 'D';

Line 302: pay_assignment_actions paa

298: c_indent varchar2(40);
299: cursor aeev is
300: select pee.element_entry_id
301: from pay_element_entries_f pee,
302: pay_assignment_actions paa
303: where paa.assignment_action_id = p_assact_id
304: and pee.assignment_id = paa.assignment_id
305: and pee.creator_id = paa.assignment_action_id
306: and pee.creator_type in ('AD', 'AE','D');

Line 335: pay_assignment_actions paa

331: c_indent varchar2(40);
332: cursor raeev is
333: select pee.element_entry_id
334: from pay_element_entries_f pee,
335: pay_assignment_actions paa
336: where paa.assignment_action_id = p_assact_id
337: and pee.assignment_id = paa.assignment_id
338: and pee.creator_id = paa.assignment_action_id
339: and pee.creator_type = 'R';

Line 369: pay_assignment_actions paa

365: c_indent varchar2(40);
366: cursor remove_eev is
367: select pee.element_entry_id
368: from pay_element_entries_f pee,
369: pay_assignment_actions paa
370: where paa.assignment_action_id = p_assact_id
371: and pee.creator_id = paa.assignment_action_id
372: and pee.creator_type in ('RR', 'EE', 'NR', 'PR') ;
373: --

Line 507: pay_assignment_actions paa

503: pay_personal_payment_methods_f ppm,
504: pay_org_payment_methods_f opm,
505: pay_pre_payments ppp,
506: pay_payroll_actions ppa,
507: pay_assignment_actions paa
508: where paa.assignment_action_id = asgact
509: and paa.payroll_action_id = ppa.payroll_action_id
510: and paa.pre_payment_id = ppp.pre_payment_id
511: and ppp.org_payment_method_id = opm.org_payment_method_id

Line 997: pay_assignment_actions paa

993: -- for an assignment action.
994: cursor c1 is
995: select pee.element_entry_id
996: from pay_element_entries_f pee,
997: pay_assignment_actions paa
998: where paa.assignment_action_id = p_assact_id
999: and pee.assignment_id = paa.assignment_id
1000: and pee.creator_id = paa.assignment_action_id
1001: and pee.creator_type = 'B' -- (B)alance Adjustment

Line 1149: select /+ INDEX(paa PAY_ASSIGNMENT_ACTIONS_N50)/

1145: end;
1146: --
1147: /* get the object Types for this payroll_action */
1148: begin
1149: select /*+ INDEX(paa PAY_ASSIGNMENT_ACTIONS_N50)*/
1150: decode (ppa.action_type,
1151: 'X', paa.object_type,
1152: decode(paa.object_type,
1153: 'PAF', null,

Line 1156: from pay_assignment_actions paa,

1152: decode(paa.object_type,
1153: 'PAF', null,
1154: paa.object_type))
1155: into p_info.object_type
1156: from pay_assignment_actions paa,
1157: pay_payroll_actions ppa
1158: where paa.payroll_action_id = p_info.pact_id
1159: and p_info.pact_id = ppa.payroll_action_id
1160: and paa.source_action_id is null

Line 1593: update pay_assignment_actions

1589: if g_debug then
1590: hr_utility.set_location(c_indent, 10);
1591: end if;
1592: --
1593: update pay_assignment_actions
1594: set action_status = 'M'
1595: where source_action_id = p_info.assact_id;
1596: --
1597: update pay_assignment_actions

Line 1597: update pay_assignment_actions

1593: update pay_assignment_actions
1594: set action_status = 'M'
1595: where source_action_id = p_info.assact_id;
1596: --
1597: update pay_assignment_actions
1598: set action_status = 'M'
1599: where assignment_action_id = p_info.assact_id;
1600: --
1601: elsif(p_info.rollback_mode) = 'BACKPAY' then

Line 1606: update pay_assignment_actions

1602: if g_debug then
1603: hr_utility.set_location(c_indent, 20);
1604: end if;
1605: --
1606: update pay_assignment_actions
1607: set action_status = 'B'
1608: where source_action_id = p_info.assact_id;
1609: --
1610: update pay_assignment_actions

Line 1610: update pay_assignment_actions

1606: update pay_assignment_actions
1607: set action_status = 'B'
1608: where source_action_id = p_info.assact_id;
1609: --
1610: update pay_assignment_actions
1611: set action_status = 'B'
1612: where assignment_action_id = p_info.assact_id;
1613: --
1614: elsif(p_info.rollback_mode) = 'ROLLBACK' then

Line 1626: delete from pay_assignment_actions

1622: --
1623: remove_archive_items(p_info, p_info.assact_id, 'AAC');
1624: remove_action_information(p_info.assact_id, 'AAC');
1625: --
1626: delete from pay_assignment_actions
1627: where source_action_id = p_info.assact_id;
1628: --
1629: delete from pay_assignment_actions
1630: where assignment_action_id = p_info.assact_id;

Line 1629: delete from pay_assignment_actions

1625: --
1626: delete from pay_assignment_actions
1627: where source_action_id = p_info.assact_id;
1628: --
1629: delete from pay_assignment_actions
1630: where assignment_action_id = p_info.assact_id;
1631: end if;
1632: else
1633: -- In the case of rolling back (from the form), we

Line 1641: delete from pay_assignment_actions

1637: --
1638: remove_archive_items(p_info, p_info.assact_id, 'AAC');
1639: remove_action_information(p_info.assact_id, 'AAC');
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;

Line 1674: from pay_assignment_actions paa_chd

1670: --
1671: --
1672: cursor chdact (p_asgact_id in number) is
1673: select paa_chd.assignment_action_id
1674: from pay_assignment_actions paa_chd
1675: where paa_chd.source_action_id = p_asgact_id
1676: order by paa_chd.action_sequence desc;
1677: --
1678: begin

Line 1716: delete from pay_assignment_actions

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;
1716: delete from pay_assignment_actions
1717: where assignment_action_id = chld_info.assact_id;
1718: end if;
1719: end loop;
1720: --

Line 1773: from pay_assignment_actions paa,

1769: begin
1770: --
1771: select ppa.element_type_id
1772: into l_et_id
1773: from pay_assignment_actions paa,
1774: pay_payroll_actions ppa
1775: where ppa.payroll_action_id = paa.payroll_action_id
1776: and paa.assignment_action_id = p_info.assact_id;
1777: --

Line 1942: l_action_sequence pay_assignment_actions.action_sequence%type;

1938: * to obtain payroll action level information.
1939: */
1940: procedure val_assact_rollback(p_info in out nocopy rollback_rec)
1941: is
1942: l_action_sequence pay_assignment_actions.action_sequence%type;
1943: l_action_status pay_assignment_actions.action_status%type;
1944: l_person_id per_all_people_f.person_id%type;
1945: l_sec_status pay_assignment_actions.secondary_status%type;
1946: c_indent varchar2(40);

Line 1943: l_action_status pay_assignment_actions.action_status%type;

1939: */
1940: procedure val_assact_rollback(p_info in out nocopy rollback_rec)
1941: is
1942: l_action_sequence pay_assignment_actions.action_sequence%type;
1943: l_action_status pay_assignment_actions.action_status%type;
1944: l_person_id per_all_people_f.person_id%type;
1945: l_sec_status pay_assignment_actions.secondary_status%type;
1946: c_indent varchar2(40);
1947: begin

Line 1945: l_sec_status pay_assignment_actions.secondary_status%type;

1941: is
1942: l_action_sequence pay_assignment_actions.action_sequence%type;
1943: l_action_status pay_assignment_actions.action_status%type;
1944: l_person_id per_all_people_f.person_id%type;
1945: l_sec_status pay_assignment_actions.secondary_status%type;
1946: c_indent varchar2(40);
1947: begin
1948: -- Obtain information about this assignment action which we will
1949: -- need later on.

Line 1989: pay_assignment_actions ACT

1985: p_info.assignment_number
1986: from
1987: per_all_people_f PEO,
1988: pay_object_groups POG_PER,
1989: pay_assignment_actions ACT
1990: where ACT.assignment_action_id = p_info.assact_id
1991: and ACT.source_action_id is null
1992: and ACT.object_id = POG_PER.object_group_id
1993: and POG_PER.source_id = PEO.person_id

Line 2016: from pay_assignment_actions ACT

2012: p_info.payroll_id,
2013: l_person_id,
2014: p_info.full_name,
2015: p_info.assignment_number
2016: from pay_assignment_actions ACT
2017: where ACT.assignment_action_id = p_info.assact_id;
2018: --
2019: end if;
2020: --

Line 2044: pay_assignment_actions ACT

2040: p_info.full_name,
2041: p_info.assignment_number
2042: from per_all_assignments_f ASS,
2043: per_all_people_f PEO,
2044: pay_assignment_actions ACT
2045: where ACT.assignment_action_id = p_info.assact_id
2046: and ASS.assignment_id = ACT.assignment_id
2047: and PEO.person_id = ASS.person_id
2048: and ((p_info.action_type = 'X'

Line 2163: pay_assignment_actions act

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
2167: (select null

Line 2224: from pay_assignment_actions ACT,

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,
2226: pay_action_classifications CLASS
2227: where ACT.assignment_id = p_info.assignment_id
2228: and ACT.action_sequence > l_action_sequence

Line 2238: from pay_assignment_actions ACT,

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,
2240: pay_action_classifications CLASS
2241: where ACT.assignment_id = p_info.assignment_id
2242: and ACT.action_sequence > l_action_sequence

Line 2266: pay_assignment_actions ACT,

2262: where not exists
2263: (select null
2264: from pay_action_classifications CLASS,
2265: pay_payroll_actions PACT,
2266: pay_assignment_actions ACT,
2267: pay_object_groups POG_ASG,
2268: pay_object_groups POG_PER,
2269: pay_assignment_actions PAA_RET
2270: where PAA_RET.assignment_action_id = p_info.assact_id

Line 2269: pay_assignment_actions PAA_RET

2265: pay_payroll_actions PACT,
2266: pay_assignment_actions ACT,
2267: pay_object_groups POG_ASG,
2268: pay_object_groups POG_PER,
2269: pay_assignment_actions PAA_RET
2270: where PAA_RET.assignment_action_id = p_info.assact_id
2271: and POG_PER.object_group_id = PAA_RET.object_id
2272: and POG_PER.source_type = 'PPF'
2273: and POG_ASG.parent_object_group_id = POG_PER.object_group_id

Line 2288: pay_assignment_actions ACT,

2284: where not exists
2285: (select null
2286: from pay_action_classifications CLASS,
2287: pay_payroll_actions PACT,
2288: pay_assignment_actions ACT,
2289: pay_object_groups POG_ASG,
2290: pay_object_groups POG_PER,
2291: pay_assignment_actions PAA_RET
2292: where PAA_RET.assignment_action_id = p_info.assact_id

Line 2291: pay_assignment_actions PAA_RET

2287: pay_payroll_actions PACT,
2288: pay_assignment_actions ACT,
2289: pay_object_groups POG_ASG,
2290: pay_object_groups POG_PER,
2291: pay_assignment_actions PAA_RET
2292: where PAA_RET.assignment_action_id = p_info.assact_id
2293: and POG_PER.object_group_id = PAA_RET.object_id
2294: and POG_PER.source_type = 'PPF'
2295: and POG_ASG.parent_object_group_id = POG_PER.object_group_id

Line 2314: pay_assignment_actions ACT,

2310: where not exists
2311: (select null
2312: from pay_action_classifications CLASS,
2313: pay_payroll_actions PACT,
2314: pay_assignment_actions ACT,
2315: pay_object_groups POG_ASG,
2316: pay_object_groups POG_ASG2
2317: where POG_ASG.source_type = 'PAF'
2318: and POG_ASG2.source_type = 'PAF'

Line 2334: pay_assignment_actions ACT,

2330: where not exists
2331: (select null
2332: from pay_action_classifications CLASS,
2333: pay_payroll_actions PACT,
2334: pay_assignment_actions ACT,
2335: pay_object_groups POG_ASG,
2336: pay_object_groups POG_ASG2
2337: where POG_ASG.source_type = 'PAF'
2338: and POG_ASG2.source_type = 'PAF'

Line 2365: pay_assignment_actions ACT,

2361: where not exists
2362: (select null
2363: from pay_action_classifications CLASS,
2364: pay_payroll_actions PACT,
2365: pay_assignment_actions ACT,
2366: per_all_assignments_f ASS,
2367: per_periods_of_service POS
2368: where POS.person_id = l_person_id
2369: and ASS.period_of_service_id = POS.period_of_service_id

Line 2383: pay_assignment_actions ACT,

2379: where not exists
2380: (select null
2381: from pay_action_classifications CLASS,
2382: pay_payroll_actions PACT,
2383: pay_assignment_actions ACT,
2384: per_all_assignments_f ASS,
2385: per_periods_of_service POS
2386: where POS.person_id = l_person_id
2387: and ASS.period_of_service_id = POS.period_of_service_id

Line 2408: pay_assignment_actions paac2,

2404: into dummy
2405: from dual
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

Line 2409: pay_assignment_actions paac,

2405: from dual
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

Line 2625: pay_assignment_actions act

2621: cursor c1 is
2622: select /*+ ORDERED*/ act.assignment_action_id,
2623: asg.period_of_service_id
2624: from per_all_assignments_f asg,
2625: pay_assignment_actions act
2626: where act.payroll_action_id = p_info.pact_id
2627: and asg.assignment_id = act.assignment_id
2628: and act.source_action_id is null
2629: and ((p_info.action_type = 'X'

Line 2666: from pay_assignment_actions act

2662: order by act.action_sequence desc;
2663: --
2664: cursor c2 is
2665: select act.assignment_action_id
2666: from pay_assignment_actions act
2667: where act.payroll_action_id = p_info.pact_id
2668: and act.source_action_id is null
2669: and act.object_id between
2670: range_info.starting_person and range_info.ending_person

Line 2785: from pay_assignment_actions act

2781: l_complete number;
2782: begin
2783: select count(*)
2784: into l_complete
2785: from pay_assignment_actions act
2786: where act.payroll_action_id = p_info.pact_id
2787: and act.secondary_status = 'C';
2788: --
2789: if(l_complete > 0) then

Line 2808: from pay_assignment_actions act2,

2804: w_payroll_id_1 number(9);
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

Line 2810: pay_assignment_actions act,

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
2814: and act2.payroll_action_id = pac2.payroll_action_id

Line 2953: pay_assignment_actions act,

2949: min(asg.person_id),
2950: max(asg.person_id),
2951: 'U'
2952: from pay_payroll_actions pac,
2953: pay_assignment_actions act,
2954: per_all_assignments_f asg
2955: where pac.payroll_action_id = l_payroll_action_id
2956: and act.payroll_action_id = pac.payroll_action_id
2957: and asg.assignment_id = act.assignment_id

Line 2972: pay_assignment_actions act

2968: min(act.object_id),
2969: max(act.object_id),
2970: 'U'
2971: from pay_payroll_actions pac,
2972: pay_assignment_actions act
2973: where pac.payroll_action_id = l_payroll_action_id
2974: and act.payroll_action_id = pac.payroll_action_id
2975: group by pac.payroll_action_id;
2976: end if;

Line 2998: from pay_assignment_actions act

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);
3000: --
3001: -- There are still assignment actions.
3002: return(false);

Line 3023: from pay_assignment_actions act

3019: action_count number;
3020: begin
3021: select count(*)
3022: into action_count
3023: from pay_assignment_actions act
3024: where act.payroll_action_id = p_info.pact_id
3025: and rownum < (p_info.max_single_undo + 2);
3026: --
3027: if(action_count > p_info.max_single_undo) then

Line 3208: pay_assignment_actions locked,

3204: if info.set_date_earned = 'Y' then
3205: select max(date_earned)
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

Line 3209: pay_assignment_actions locking,

3205: select max(date_earned)
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

Line 3272: from pay_assignment_actions act

3268: hr_utility.set_location(c_indent, 10);
3269: end if;
3270: select act.payroll_action_id, act.source_action_id, act.object_type
3271: into info.pact_id, src_action_id, info.object_type
3272: from pay_assignment_actions act
3273: where act.assignment_action_id = p_assignment_action_id;
3274: --
3275: -- instantiate the other parameters that are relevant.
3276: info.assact_id := p_assignment_action_id;

Line 3313: from pay_assignment_actions

3309: val_assact_rr_rules(info);
3310: else
3311: select assignment_id
3312: into info.assignment_id
3313: from pay_assignment_actions
3314: where assignment_action_id = info.assact_id;
3315: end if;
3316: --
3317: -- perform the rollback/mark for retry itself.

Line 3354: pay_assignment_actions locked,

3350: -- may have been the last one
3351: select max(locked_pact.date_earned), locking_pact.date_earned
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

Line 3355: pay_assignment_actions locking,

3351: select max(locked_pact.date_earned), locking_pact.date_earned
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