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_PAYROLL_ACTIONS

Line 7: pact_id pay_payroll_actions.payroll_action_id%type,

3: /*------------- Payroll and Assignment Action Details ----------------*/
4: type rollback_rec is record
5: (
6: -- Payroll Action Level Details.
7: pact_id pay_payroll_actions.payroll_action_id%type,
8: action_name hr_lookups.meaning%type,
9: action_type pay_payroll_actions.action_type%type,
10: action_status pay_payroll_actions.action_status%type,
11: sequenced_flag boolean,

Line 9: action_type pay_payroll_actions.action_type%type,

5: (
6: -- Payroll Action Level Details.
7: pact_id pay_payroll_actions.payroll_action_id%type,
8: action_name hr_lookups.meaning%type,
9: action_type pay_payroll_actions.action_type%type,
10: action_status pay_payroll_actions.action_status%type,
11: sequenced_flag boolean,
12: action_date date,
13: action_start_date date,

Line 10: action_status pay_payroll_actions.action_status%type,

6: -- Payroll Action Level Details.
7: pact_id pay_payroll_actions.payroll_action_id%type,
8: action_name hr_lookups.meaning%type,
9: action_type pay_payroll_actions.action_type%type,
10: action_status pay_payroll_actions.action_status%type,
11: sequenced_flag boolean,
12: action_date date,
13: action_start_date date,
14: current_date date, -- holds sysdate.

Line 20: purge_phase pay_payroll_actions.purge_phase%type,

16: bg_name hr_organization_units.name%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: --

Line 22: retro_definition_id pay_payroll_actions.retro_definition_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.
26: assact_id pay_assignment_actions.assignment_action_id%type,

Line 23: batch_id pay_payroll_actions.batch_id%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.
26: assact_id pay_assignment_actions.assignment_action_id%type,
27: assignment_id per_all_assignments_f.assignment_id%type,

Line 506: pay_payroll_actions ppa,

502: pay_payment_types ppt,
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

Line 1098: from pay_payroll_actions pac,

1094: p_info.purge_phase,
1095: p_info.retro_definition_id,
1096: p_info.batch_id,
1097: p_info.sub_ledger_acc
1098: from pay_payroll_actions pac,
1099: pay_all_payrolls_f pay,
1100: per_business_groups_perf grp,
1101: hr_lookups hrl
1102: where pac.payroll_action_id = p_info.pact_id

Line 1157: pay_payroll_actions ppa

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
1161: and rownum = 1;

Line 1211: from pay_payroll_actions pac,

1207: hr_utility.set_location(c_indent, 90);
1208: end if;
1209: select ppt.payment_type_name
1210: into l_action_name
1211: from pay_payroll_actions pac,
1212: pay_payment_types ppt
1213: where pac.payroll_action_id = p_info.pact_id
1214: and ppt.payment_type_id = pac.payment_type_id;
1215: else

Line 1768: l_et_id pay_payroll_actions.element_type_id%type;

1764: if (p_info.rollback_mode = 'ROLLBACK' or p_info.action_type = 'I') then
1765: undo_bal_adjust(p_info.action_date, p_info.assact_id);
1766: else
1767: declare
1768: l_et_id pay_payroll_actions.element_type_id%type;
1769: begin
1770: --
1771: select ppa.element_type_id
1772: into l_et_id

Line 1774: pay_payroll_actions ppa

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: --
1778: if (l_et_id is not null) then

Line 2168: from pay_payroll_actions pac

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
2168: from pay_payroll_actions pac
2169: where pac.payroll_action_id = act.payroll_action_id
2170: and action_type in ('A','H','M', 'PP', 'PRU')
2171: and act.action_status = 'M'
2172: )

Line 2225: pay_payroll_actions PACT,

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
2229: and ACT.action_status in ('C', 'S')

Line 2239: pay_payroll_actions PACT,

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
2243: and ACT.action_status in ('C', 'S','M')

Line 2265: pay_payroll_actions PACT,

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

Line 2287: pay_payroll_actions PACT,

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

Line 2313: pay_payroll_actions PACT,

2309: from dual
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'

Line 2333: pay_payroll_actions PACT,

2329: from dual
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'

Line 2364: pay_payroll_actions PACT,

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

Line 2382: pay_payroll_actions PACT,

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

Line 2811: pay_payroll_actions pac,

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
2815: and pac.payroll_action_id = act.payroll_action_id

Line 2812: pay_payroll_actions pac2

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
2815: and pac.payroll_action_id = act.payroll_action_id
2816: and pai.locking_action_id = act.assignment_action_id

Line 2952: from pay_payroll_actions pac,

2948: 1,
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

Line 2971: from pay_payroll_actions pac,

2967: 1,
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;

Line 3196: delete from pay_payroll_actions pac

3192: hr_utility.set_location(c_indent, 30);
3193: end if;
3194: delete from pay_chunk_status
3195: where payroll_action_id = info.pact_id;
3196: delete from pay_payroll_actions pac
3197: where pac.payroll_action_id = info.pact_id;
3198: else
3199: if (info.sequenced_flag=FALSE) then
3200: if (info.rollback_mode <> 'BACKPAY'

Line 3207: from pay_payroll_actions locked_pact,

3203: if info.rollback_level = 'P' then
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

Line 3216: update pay_payroll_actions pac

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;
3215: --
3216: update pay_payroll_actions pac
3217: set pac.date_earned = l_date_earned
3218: where pac.payroll_action_id = info.pact_id;
3219: end if;
3220: end if;

Line 3353: from pay_payroll_actions locked_pact,

3349: -- Handle that the rolled back assignment action
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

Line 3357: pay_payroll_actions locking_pact

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
3361: and locked.assignment_action_id =locks.locked_action_id

Line 3366: update pay_payroll_actions pac

3362: and locked.payroll_action_id =locked_pact.payroll_action_id
3363: group by locking_pact.date_earned;
3364: --
3365: if (l_date_earned < l_current_date_earned) then
3366: update pay_payroll_actions pac
3367: set pac.date_earned = l_date_earned
3368: where pac.payroll_action_id = info.pact_id;
3369: end if;
3370: --

Line 3373: update pay_payroll_actions pac

3369: end if;
3370: --
3371: exception
3372: when others then
3373: update pay_payroll_actions pac
3374: set pac.date_earned = null
3375: where pac.payroll_action_id = info.pact_id;
3376: end;
3377: end if;