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_MWS_MAGTAPE_REPORTING dependencies on PAY_MAG_UTILS

Line 24: g_reg_earn_bal_id := Pay_Mag_Utils.Bal_Db_Item(

20: g_pre_tax_bal_id pay_defined_balances.defined_balance_id%type;
21:
22: procedure get_balance_id is
23: begin
24: g_reg_earn_bal_id := Pay_Mag_Utils.Bal_Db_Item(
25: 'REGULAR_EARNINGS_PER_GRE_QTD');
26: g_supp_earn_bal_id := Pay_Mag_Utils.Bal_Db_Item(
27: 'SUPPLEMENTAL_EARNINGS_FOR_FIT_SUBJECT_TO_TAX_PER_GRE_QTD');
28: --

Line 26: g_supp_earn_bal_id := Pay_Mag_Utils.Bal_Db_Item(

22: procedure get_balance_id is
23: begin
24: g_reg_earn_bal_id := Pay_Mag_Utils.Bal_Db_Item(
25: 'REGULAR_EARNINGS_PER_GRE_QTD');
26: g_supp_earn_bal_id := Pay_Mag_Utils.Bal_Db_Item(
27: 'SUPPLEMENTAL_EARNINGS_FOR_FIT_SUBJECT_TO_TAX_PER_GRE_QTD');
28: --
29: -- the following has been commented for the pre-tax enhancements
30: -- by skutteti. Individual pre-tax balances has been replaced

Line 33: --g_def_gre_bal_id := Pay_Mag_Utils.Bal_Db_Item(

29: -- the following has been commented for the pre-tax enhancements
30: -- by skutteti. Individual pre-tax balances has been replaced
31: -- by one balance g_pre_tax_bal_id
32: --
33: --g_def_gre_bal_id := Pay_Mag_Utils.Bal_Db_Item(
34: -- 'DEF_COMP_401K_PER_GRE_QTD');
35: --g_sec_gre_bal_id := Pay_Mag_Utils.Bal_Db_Item(
36: -- 'SECTION_125_PER_GRE_QTD');
37: --g_dep_gre_bal_id := Pay_Mag_Utils.Bal_Db_Item(

Line 35: --g_sec_gre_bal_id := Pay_Mag_Utils.Bal_Db_Item(

31: -- by one balance g_pre_tax_bal_id
32: --
33: --g_def_gre_bal_id := Pay_Mag_Utils.Bal_Db_Item(
34: -- 'DEF_COMP_401K_PER_GRE_QTD');
35: --g_sec_gre_bal_id := Pay_Mag_Utils.Bal_Db_Item(
36: -- 'SECTION_125_PER_GRE_QTD');
37: --g_dep_gre_bal_id := Pay_Mag_Utils.Bal_Db_Item(
38: -- 'DEPENDENT_CARE_PER_GRE_QTD');
39: --

Line 37: --g_dep_gre_bal_id := Pay_Mag_Utils.Bal_Db_Item(

33: --g_def_gre_bal_id := Pay_Mag_Utils.Bal_Db_Item(
34: -- 'DEF_COMP_401K_PER_GRE_QTD');
35: --g_sec_gre_bal_id := Pay_Mag_Utils.Bal_Db_Item(
36: -- 'SECTION_125_PER_GRE_QTD');
37: --g_dep_gre_bal_id := Pay_Mag_Utils.Bal_Db_Item(
38: -- 'DEPENDENT_CARE_PER_GRE_QTD');
39: --
40: g_pre_tax_bal_id := Pay_Mag_Utils.Bal_Db_Item(
41: 'PRE_TAX_DEDUCTIONS_PER_GRE_QTD');

Line 40: g_pre_tax_bal_id := Pay_Mag_Utils.Bal_Db_Item(

36: -- 'SECTION_125_PER_GRE_QTD');
37: --g_dep_gre_bal_id := Pay_Mag_Utils.Bal_Db_Item(
38: -- 'DEPENDENT_CARE_PER_GRE_QTD');
39: --
40: g_pre_tax_bal_id := Pay_Mag_Utils.Bal_Db_Item(
41: 'PRE_TAX_DEDUCTIONS_PER_GRE_QTD');
42:
43: g_supp_nwfit_bal_id := Pay_Mag_Utils.Bal_Db_Item(
44: 'SUPPLEMENTAL_EARNINGS_FOR_NWFIT_SUBJECT_TO_TAX_PER_GRE_QTD');

Line 43: g_supp_nwfit_bal_id := Pay_Mag_Utils.Bal_Db_Item(

39: --
40: g_pre_tax_bal_id := Pay_Mag_Utils.Bal_Db_Item(
41: 'PRE_TAX_DEDUCTIONS_PER_GRE_QTD');
42:
43: g_supp_nwfit_bal_id := Pay_Mag_Utils.Bal_Db_Item(
44: 'SUPPLEMENTAL_EARNINGS_FOR_NWFIT_SUBJECT_TO_TAX_PER_GRE_QTD');
45:
46: end get_balance_id;
47:

Line 149: hr_utility.set_location('pay_mag_utils.create_assignment_action',1);

145: l_serial_no varchar2(30);
146:
147: begin
148:
149: hr_utility.set_location('pay_mag_utils.create_assignment_action',1);
150:
151: /* Create assignment action to identify a specific person's inclusion in the
152: magnetic tape report identified by the parent payroll action. The
153: assignment action has to be sequenced within the other assignment actions

Line 181: hr_utility.set_location('pay_mag_utils.create_assignment_action',2);

177:
178:
179: /* Get the assignment_action_id of the newly created assignment action. */
180:
181: hr_utility.set_location('pay_mag_utils.create_assignment_action',2);
182:
183: open csr_assignment_action;
184: fetch csr_assignment_action INTO l_assignment_action_id;
185: close csr_assignment_action;

Line 192: hr_utility.set_location('pay_mag_utils.create_assignment_action',3);

188: set aa.tax_unit_id = p_tax_unit_id,
189: aa.serial_number = l_serial_no
190: where aa.assignment_action_id = l_assignment_action_id;
191:
192: hr_utility.set_location('pay_mag_utils.create_assignment_action',3);
193:
194: /* Return id of new row. */
195:
196: return (l_assignment_action_id);

Line 381: l_defined_balance_id := Pay_Mag_Utils.Bal_Db_Item(

377: l_end_date3 := to_date('12-'|| to_char(p_quarter_end,
378: 'MM-YYYY'), 'DD-MM-YYYY');
379:
380: /* Get the balance id for the Gross Quarterly wages of a person */
381: l_defined_balance_id := Pay_Mag_Utils.Bal_Db_Item(
382: 'GROSS_EARNINGS_PER_GRE_QTD');
383:
384: /* Get the remaining balance ids */
385:

Line 460: l_payroll_action_id := Pay_Mag_Utils.Create_Payroll_Action

456: if not l_payroll_action_created then
457:
458: /* Create payroll action for the magnetic tape report. */
459:
460: l_payroll_action_id := Pay_Mag_Utils.Create_Payroll_Action
461: (p_report_type,
462: p_state,
463: p_trans_legal_co_id,
464: p_business_group_id,

Line 579: l_format := Pay_Mag_Utils.Lookup_Format(p_effective_date,

575: from sys.dual;
576:
577: /* Get the format to be used to produce the report. */
578:
579: l_format := Pay_Mag_Utils.Lookup_Format(p_effective_date,
580: p_report_type,
581: p_state);
582:
583: /* Assign the name of the output filename */

Line 818: Pay_Mag_Utils.Error_Payroll_Action(p_payroll_action_id);

814: when hr_utility.hr_error then
815:
816: /* If a payroll action exists then error it. */
817: if p_payroll_action_id is not null then
818: Pay_Mag_Utils.Error_Payroll_Action(p_payroll_action_id);
819: end if;
820:
821: /* Set up error message and error return code. */
822: if g_message_text is not null

Line 833: Pay_Mag_Utils.Error_Payroll_Action(p_payroll_action_id);

829:
830: when others then
831: /* If a payroll action exists then error it. */
832: if p_payroll_action_id is not null then
833: Pay_Mag_Utils.Error_Payroll_Action(p_payroll_action_id);
834: end if;
835:
836: /* Set up error message and error return code. */
837: errbuf := sqlerrm;

Line 948: Pay_Mag_Utils.Check_Report_Unique(p_business_group_id,

944: c_reporting_year);
945:
946: /* Check for the uniqueness of the report */
947:
948: Pay_Mag_Utils.Check_Report_Unique(p_business_group_id,
949: c_period_end,
950: l_report_type,
951: l_state);
952:

Line 955: l_format := Pay_Mag_Utils.Lookup_Format(c_period_end,

951: l_state);
952:
953: /* Get the format to be used to produce the report. */
954:
955: l_format := Pay_Mag_Utils.Lookup_Format(c_period_end,
956: l_report_type,
957: l_state);
958:
959: /* See if a transmitter legal company was specified NB. it is not

Line 1013: Pay_Mag_Utils.Update_Action_Status(l_payroll_action_id);

1009:
1010: /* Process completed successfully. Update the status of the payroll and
1011: assignments actions. */
1012:
1013: Pay_Mag_Utils.Update_Action_Status(l_payroll_action_id);
1014:
1015: /* Set up success return code. */
1016:
1017: retcode := 0;

Line 1026: Pay_Mag_Utils.Error_Payroll_Action(l_payroll_action_id);

1022: exception
1023: when hr_utility.hr_error then
1024: /* If a payroll action exists then error it. */
1025: if l_payroll_action_id is not null then
1026: Pay_Mag_Utils.Error_Payroll_Action(l_payroll_action_id);
1027: end if;
1028:
1029: /* Set up error message and error return code. */
1030: if g_message_text is not null

Line 1042: Pay_Mag_Utils.Error_Payroll_Action(l_payroll_action_id);

1038: when others then
1039:
1040: /* If a payroll action exists then error it. */
1041: if l_payroll_action_id is not null then
1042: Pay_Mag_Utils.Error_Payroll_Action(l_payroll_action_id);
1043: end if;
1044:
1045: /* Set up error message and error return code. */
1046: errbuf := sqlerrm;