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

Line 185: update pay_assignment_actions AA

181: --
182: -- Sets all successfully processed assignment actions to 'C'omplete.
183: --
184: hr_utility.set_location('pay_us_magtape_reporting.update_action_statuses - updating pay_ assignment_actions', 2);
185: update pay_assignment_actions AA
186: set AA.action_status = 'C'
187: where AA.payroll_action_id = p_payroll_action_id
188: and AA.action_status = 'U';
189: --

Line 452: from pay_assignment_actions AA

448: -- tax_unit_id updated yet.
449: --
450: cursor csr_assignment_action is
451: select AA.assignment_action_id
452: from pay_assignment_actions AA
453: where AA.payroll_action_id = p_payroll_action_id
454: and AA.assignment_id = p_assignment_id
455: and AA.tax_unit_id is null;
456: --

Line 459: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;

455: and AA.tax_unit_id is null;
456: --
457: -- Local variables.
458: --
459: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
460: --
461: begin
462: --
463: -- Create assignment action to identify a specific person's inclusion in the

Line 480: hr_utility.set_location('pay_us_magtape_reporting.create_assignment_action - updating pay_assignment_actions', 3);

476: fetch csr_assignment_action into l_assignment_action_id;
477: close csr_assignment_action;
478: --
479: --
480: hr_utility.set_location('pay_us_magtape_reporting.create_assignment_action - updating pay_assignment_actions', 3);
481: update pay_assignment_actions AA
482: set AA.tax_unit_id = p_tax_unit_id
483: where AA.assignment_action_id = l_assignment_action_id;
484: --

Line 481: update pay_assignment_actions AA

477: close csr_assignment_action;
478: --
479: --
480: hr_utility.set_location('pay_us_magtape_reporting.create_assignment_action - updating pay_assignment_actions', 3);
481: update pay_assignment_actions AA
482: set AA.tax_unit_id = p_tax_unit_id
483: where AA.assignment_action_id = l_assignment_action_id;
484: --
485: -- Return id of new row.

Line 487: hr_utility.set_location('pay_us_magtape_reporting.create_assignment_action - updated pay_assignment_actions', 4);

483: where AA.assignment_action_id = l_assignment_action_id;
484: --
485: -- Return id of new row.
486: --
487: hr_utility.set_location('pay_us_magtape_reporting.create_assignment_action - updated pay_assignment_actions', 4);
488: return (l_assignment_action_id);
489: --
490: end create_assignment_action;
491: --

Line 572: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;

568: -- that are created.
569: --
570: l_payroll_action_created boolean := false;
571: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;
572: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
573: --
574: -- Variable holding the balance to be tested.
575: --
576: l_defined_balance_id pay_defined_balances.defined_balance_id%type;

Line 872: update pay_assignment_actions aa

868:
869: if (p_report_type = 'W2' and p_state <> 'FED' and
870: l_value > 9999999.99) then
871:
872: update pay_assignment_actions aa
873: set aa.serial_number = 999999
874: where aa.assignment_action_id = l_assignment_action_id;
875:
876: end if;

Line 981: hr_utility.set_location('pay_us_magtape_reporting.redo - update pay_assignment_actions', 3);

977: update pay_payroll_actions pa
978: set PA.action_status = 'M'
979: where PA.payroll_action_id = p_payroll_action_id;
980:
981: hr_utility.set_location('pay_us_magtape_reporting.redo - update pay_assignment_actions', 3);
982: update pay_assignment_actions AA
983: set AA.action_status = 'M'
984: where AA.payroll_action_id = p_payroll_action_id;
985:

Line 982: update pay_assignment_actions AA

978: set PA.action_status = 'M'
979: where PA.payroll_action_id = p_payroll_action_id;
980:
981: hr_utility.set_location('pay_us_magtape_reporting.redo - update pay_assignment_actions', 3);
982: update pay_assignment_actions AA
983: set AA.action_status = 'M'
984: where AA.payroll_action_id = p_payroll_action_id;
985:
986: commit;

Line 1005: hr_utility.set_location('pay_us_magtape_reporting.redo - update pay_assignment_actions', 5);

1001: l_trans_legal_co_id,
1002: l_media_type);
1003:
1004: --
1005: hr_utility.set_location('pay_us_magtape_reporting.redo - update pay_assignment_actions', 5);
1006: update pay_assignment_actions AA
1007: set AA.action_status = 'C'
1008: where AA.payroll_action_id = p_payroll_action_id;
1009:

Line 1006: update pay_assignment_actions AA

1002: l_media_type);
1003:
1004: --
1005: hr_utility.set_location('pay_us_magtape_reporting.redo - update pay_assignment_actions', 5);
1006: update pay_assignment_actions AA
1007: set AA.action_status = 'C'
1008: where AA.payroll_action_id = p_payroll_action_id;
1009:
1010: commit;

Line 1104: from pay_assignment_actions aa, per_assignments_f a

1100: l_person_id number;
1101:
1102: cursor get_highly_comp is
1103: select a.person_id
1104: from pay_assignment_actions aa, per_assignments_f a
1105: where aa.payroll_action_id = p_payroll_action_id
1106: and aa.assignment_id = a.assignment_id
1107: and aa.serial_number is NOT NULL;
1108: