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_PAYROLL_ACTIONS

Line 144: update pay_payroll_actions PA

140: --
141: -- Sets the payroll action to a status of 'E'rror.
142: --
143: hr_utility.set_location('pay_us_magtape_reporting.error_payroll_action - updating pay_ payrol_actions', 1);
144: update pay_payroll_actions PA
145: set PA.action_status = 'E'
146: where PA.payroll_action_id = p_payroll_action_id;
147: --
148: hr_utility.set_location('pay_us_magtape_reporting.error_payroll_action - updated pay_ payrol_actions', 2);

Line 178: update pay_payroll_actions PA

174: --
175: -- Sets the payroll action to a status of 'C'omplete.
176: --
177: hr_utility.set_location('pay_us_magtape_reporting.update_action_statuses - updating pay_ payrol_actions', 1);
178: update pay_payroll_actions PA
179: set PA.action_status = 'C'
180: where PA.payroll_action_id = p_payroll_action_id;
181: --
182: -- Sets all successfully processed assignment actions to 'C'omplete.

Line 378: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;

374: p_period_end in date,
375: p_media_type in varchar2
376: ) return number is
377: --
378: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;
379: --
380: begin
381: --
382: -- Get the next payroll_action_id value from the sequence.

Line 385: select pay_payroll_actions_s.nextval

381: --
382: -- Get the next payroll_action_id value from the sequence.
383: hr_utility.set_location('pay_us_magtape_reporting.create_payroll_action - getting nextval', 1);
384: --
385: select pay_payroll_actions_s.nextval
386: into l_payroll_action_id
387: from sys.dual;
388: --
389: -- Create a payroll action dated as of the end of the period being reported

Line 397: insert into pay_payroll_actions

393: --
394:
395: -- SQWLD - append p_media_type to parameter string, so redo can detect it
396: hr_utility.set_location('pay_us_magtape_reporting.create_payroll_action - creating payroll action', 2);
397: insert into pay_payroll_actions
398: (payroll_action_id
399: ,action_type
400: ,business_group_id
401: ,action_population_status

Line 571: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;

567: -- Variables used to hold the details of the payroll and assignment actions
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: --

Line 910: hr_utility.set_location('pay_us_magtape_reporting.generate_people_list - updating pay_payroll_actions', 10);

906: --
907: -- Update the population status of the payroll action to indicate that all
908: -- the assignment actions have been created for it.
909: --
910: hr_utility.set_location('pay_us_magtape_reporting.generate_people_list - updating pay_payroll_actions', 10);
911: update pay_payroll_actions PPA
912: set PPA.action_population_status = 'C'
913: where PPA.payroll_action_id = l_payroll_action_id;
914: --

Line 911: update pay_payroll_actions PPA

907: -- Update the population status of the payroll action to indicate that all
908: -- the assignment actions have been created for it.
909: --
910: hr_utility.set_location('pay_us_magtape_reporting.generate_people_list - updating pay_payroll_actions', 10);
911: update pay_payroll_actions PPA
912: set PPA.action_population_status = 'C'
913: where PPA.payroll_action_id = l_payroll_action_id;
914: --
915: -- Make the changes permanent.

Line 972: from pay_payroll_actions PA

968: l_reporting_year,
969: l_reporting_quarter,
970: l_trans_legal_co_id,
971: l_media_type
972: from pay_payroll_actions PA
973: where PA.payroll_action_id = p_payroll_action_id;
974:
975: --
976: hr_utility.set_location('pay_us_magtape_reporting.redo - update pay_payroll_actions', 2);

Line 976: hr_utility.set_location('pay_us_magtape_reporting.redo - update pay_payroll_actions', 2);

972: from pay_payroll_actions PA
973: where PA.payroll_action_id = p_payroll_action_id;
974:
975: --
976: hr_utility.set_location('pay_us_magtape_reporting.redo - update pay_payroll_actions', 2);
977: update pay_payroll_actions pa
978: set PA.action_status = 'M'
979: where PA.payroll_action_id = p_payroll_action_id;
980:

Line 977: update pay_payroll_actions pa

973: where PA.payroll_action_id = p_payroll_action_id;
974:
975: --
976: hr_utility.set_location('pay_us_magtape_reporting.redo - update pay_payroll_actions', 2);
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);

Line 1292: hr_utility.set_location('pay_us_magtape_reporting.run_magtape - update pay_payroll_actions', 5);

1288: --
1289: -- Request has been accepted so update payroll action with the
1290: -- request details.
1291: --
1292: hr_utility.set_location('pay_us_magtape_reporting.run_magtape - update pay_payroll_actions', 5);
1293: update pay_payroll_actions PPA
1294: set PPA.request_id = l_request_id
1295: where PPA.payroll_action_id = p_payroll_action_id;
1296: --

Line 1293: update pay_payroll_actions PPA

1289: -- Request has been accepted so update payroll action with the
1290: -- request details.
1291: --
1292: hr_utility.set_location('pay_us_magtape_reporting.run_magtape - update pay_payroll_actions', 5);
1293: update pay_payroll_actions PPA
1294: set PPA.request_id = l_request_id
1295: where PPA.payroll_action_id = p_payroll_action_id;
1296: --
1297: -- Issue a commit to synchronise the concurrent manager.

Line 1433: from pay_payroll_actions PA

1429: -- the report has already been run.
1430: --
1431: cursor csr_payroll_action is
1432: select PA.payroll_action_id
1433: from pay_payroll_actions PA
1434: where PA.business_group_id = p_business_group_id
1435: and PA.effective_date = p_period_end
1436: and PA.legislative_parameters like 'USMAGTAPE' || '-' ||
1437: lpad(p_report_type, 5) || '-' ||

Line 1440: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;

1436: and PA.legislative_parameters like 'USMAGTAPE' || '-' ||
1437: lpad(p_report_type, 5) || '-' ||
1438: lpad(p_state , 5) || '%';
1439: --
1440: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;
1441: --
1442: begin
1443: --
1444: -- Check report has not already been run.

Line 1598: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;

1594: c_year_start date;
1595: c_year_end date;
1596: c_reporting_year varchar2(4);
1597: c_reporting_quarter varchar2(4);
1598: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;
1599: l_trans_legal_co_id number;
1600: l_request_id number;
1601: l_format varchar2(30);
1602: --