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 511: pay_payroll_actions ppa,

507: pay_payment_types ppt,
508: pay_personal_payment_methods_f ppm,
509: pay_org_payment_methods_f opm,
510: pay_pre_payments ppp,
511: pay_payroll_actions ppa,
512: pay_assignment_actions paa
513: where paa.assignment_action_id = asgact
514: and paa.payroll_action_id = ppa.payroll_action_id
515: and paa.pre_payment_id = ppp.pre_payment_id

Line 1103: from pay_payroll_actions pac,

1099: p_info.purge_phase,
1100: p_info.retro_definition_id,
1101: p_info.batch_id,
1102: p_info.sub_ledger_acc
1103: from pay_payroll_actions pac,
1104: pay_all_payrolls_f pay,
1105: per_business_groups_perf grp,
1106: hr_lookups hrl
1107: where pac.payroll_action_id = p_info.pact_id

Line 1162: pay_payroll_actions ppa

1158: 'PAF', null,
1159: paa.object_type))
1160: into p_info.object_type
1161: from pay_assignment_actions paa,
1162: pay_payroll_actions ppa
1163: where paa.payroll_action_id = p_info.pact_id
1164: and p_info.pact_id = ppa.payroll_action_id
1165: and paa.source_action_id is null
1166: and rownum = 1;

Line 1216: from pay_payroll_actions pac,

1212: hr_utility.set_location(c_indent, 90);
1213: end if;
1214: select ppt.payment_type_name
1215: into l_action_name
1216: from pay_payroll_actions pac,
1217: pay_payment_types ppt
1218: where pac.payroll_action_id = p_info.pact_id
1219: and ppt.payment_type_id = pac.payment_type_id;
1220: else

Line 1791: l_et_id pay_payroll_actions.element_type_id%type;

1787: if (p_info.rollback_mode = 'ROLLBACK' or p_info.action_type = 'I') then
1788: undo_bal_adjust(p_info.action_date, p_info.assact_id);
1789: else
1790: declare
1791: l_et_id pay_payroll_actions.element_type_id%type;
1792: begin
1793: --
1794: select ppa.element_type_id
1795: into l_et_id

Line 1797: pay_payroll_actions ppa

1793: --
1794: select ppa.element_type_id
1795: into l_et_id
1796: from pay_assignment_actions paa,
1797: pay_payroll_actions ppa
1798: where ppa.payroll_action_id = paa.payroll_action_id
1799: and paa.assignment_action_id = p_info.assact_id;
1800: --
1801: if (l_et_id is not null) then

Line 2247: from pay_payroll_actions pac

2243: where int.locked_action_id = p_info.assact_id
2244: and act.assignment_action_id = int.locking_action_id
2245: and ((exists
2246: (select null
2247: from pay_payroll_actions pac
2248: where pac.payroll_action_id = act.payroll_action_id
2249: and action_type in ('A','H','M', 'PP', 'PRU')
2250: and act.action_status = 'M'
2251: )

Line 2307: pay_payroll_actions PACT,

2303: from dual
2304: where not exists
2305: (select null
2306: from pay_assignment_actions ACT,
2307: pay_payroll_actions PACT,
2308: pay_action_classifications CLASS
2309: where ACT.assignment_id = p_info.assignment_id
2310: and ACT.action_sequence > l_action_sequence
2311: and ACT.action_status in ('C', 'S')

Line 2321: pay_payroll_actions PACT,

2317: from dual
2318: where not exists
2319: (select null
2320: from pay_assignment_actions ACT,
2321: pay_payroll_actions PACT,
2322: pay_action_classifications CLASS
2323: where ACT.assignment_id = p_info.assignment_id
2324: and ACT.action_sequence > l_action_sequence
2325: and ACT.action_status in ('C', 'S','M')

Line 2349: pay_payroll_actions PACT,

2345: from dual
2346: where not exists
2347: (select null
2348: from pay_action_classifications CLASS,
2349: pay_payroll_actions PACT,
2350: pay_assignment_actions ACT,
2351: pay_object_groups POG_ASG,
2352: pay_object_groups POG_PER,
2353: pay_assignment_actions PAA_RET

Line 2371: pay_payroll_actions PACT,

2367: from dual
2368: where not exists
2369: (select null
2370: from pay_action_classifications CLASS,
2371: pay_payroll_actions PACT,
2372: pay_assignment_actions ACT,
2373: pay_object_groups POG_ASG,
2374: pay_object_groups POG_PER,
2375: pay_assignment_actions PAA_RET

Line 2398: pay_payroll_actions PACT,

2394: from dual
2395: where not exists
2396: (select null
2397: from pay_action_classifications CLASS,
2398: pay_payroll_actions PACT,
2399: pay_assignment_actions ACT,
2400: pay_object_groups POG_ASG,
2401: pay_object_groups POG_ASG2
2402: where POG_ASG.source_type = 'PAF'

Line 2418: pay_payroll_actions PACT,

2414: from dual
2415: where not exists
2416: (select null
2417: from pay_action_classifications CLASS,
2418: pay_payroll_actions PACT,
2419: pay_assignment_actions ACT,
2420: pay_object_groups POG_ASG,
2421: pay_object_groups POG_ASG2
2422: where POG_ASG.source_type = 'PAF'

Line 2451: pay_payroll_actions PACT,

2447: from dual
2448: where not exists
2449: (select null
2450: from pay_action_classifications CLASS,
2451: pay_payroll_actions PACT,
2452: pay_assignment_actions ACT,
2453: per_all_assignments_f ASS,
2454: per_periods_of_service POS
2455: where POS.person_id = l_person_id

Line 2469: pay_payroll_actions PACT,

2465: from dual
2466: where not exists
2467: (select null
2468: from pay_action_classifications CLASS,
2469: pay_payroll_actions PACT,
2470: pay_assignment_actions ACT,
2471: per_all_assignments_f ASS,
2472: per_periods_of_service POS
2473: where POS.person_id = l_person_id

Line 2932: pay_payroll_actions pac,

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
2935: and act2.payroll_action_id = pac2.payroll_action_id
2936: and pac.payroll_action_id = act.payroll_action_id

Line 2933: pay_payroll_actions pac2

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
2935: and act2.payroll_action_id = pac2.payroll_action_id
2936: and pac.payroll_action_id = act.payroll_action_id
2937: and pai.locking_action_id = act.assignment_action_id

Line 3073: from pay_payroll_actions pac,

3069: 1,
3070: min(asg.person_id),
3071: max(asg.person_id),
3072: 'U'
3073: from pay_payroll_actions pac,
3074: pay_assignment_actions act,
3075: per_all_assignments_f asg
3076: where pac.payroll_action_id = l_payroll_action_id
3077: and act.payroll_action_id = pac.payroll_action_id

Line 3092: from pay_payroll_actions pac,

3088: 1,
3089: min(act.object_id),
3090: max(act.object_id),
3091: 'U'
3092: from pay_payroll_actions pac,
3093: pay_assignment_actions act
3094: where pac.payroll_action_id = l_payroll_action_id
3095: and act.payroll_action_id = pac.payroll_action_id
3096: group by pac.payroll_action_id;

Line 3317: delete from pay_payroll_actions pac

3313: hr_utility.set_location(c_indent, 30);
3314: end if;
3315: delete from pay_chunk_status
3316: where payroll_action_id = info.pact_id;
3317: delete from pay_payroll_actions pac
3318: where pac.payroll_action_id = info.pact_id;
3319: else
3320: if (info.sequenced_flag=FALSE) then
3321: if (info.rollback_mode <> 'BACKPAY'

Line 3328: from pay_payroll_actions locked_pact,

3324: if info.rollback_level = 'P' then
3325: if info.set_date_earned = 'Y' then
3326: select max(date_earned)
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

Line 3337: update pay_payroll_actions pac

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;
3336: --
3337: update pay_payroll_actions pac
3338: set pac.date_earned = l_date_earned
3339: where pac.payroll_action_id = info.pact_id;
3340: end if;
3341: end if;

Line 3474: from pay_payroll_actions locked_pact,

3470: -- Handle that the rolled back assignment action
3471: -- may have been the last one
3472: select max(locked_pact.date_earned), locking_pact.date_earned
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

Line 3478: pay_payroll_actions locking_pact

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

Line 3487: update pay_payroll_actions pac

3483: and locked.payroll_action_id =locked_pact.payroll_action_id
3484: group by locking_pact.date_earned;
3485: --
3486: if (l_date_earned < l_current_date_earned) then
3487: update pay_payroll_actions pac
3488: set pac.date_earned = l_date_earned
3489: where pac.payroll_action_id = info.pact_id;
3490: end if;
3491: --

Line 3494: update pay_payroll_actions pac

3490: end if;
3491: --
3492: exception
3493: when others then
3494: update pay_payroll_actions pac
3495: set pac.date_earned = null
3496: where pac.payroll_action_id = info.pact_id;
3497: end;
3498: end if;