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_SIMULATION dependencies on PAY_US_PAYSLIP_SIMULATION_MAIN

Line 98: OPEN pay_us_payslip_simulation_main.get_action_details(p_assignment_action_id);

94: IF p_document_type = 'PAYSLIP' AND p_action_information_category IS NULL THEN
95:
96: hr_utility.set_location(gv_package || lv_procedure_name, 20);
97:
98: OPEN pay_us_payslip_simulation_main.get_action_details(p_assignment_action_id);
99: FETCH pay_us_payslip_simulation_main.get_action_details
100: INTO ln_business_group_id,
101: ln_tax_unit_id,
102: ld_effective_date,

Line 99: FETCH pay_us_payslip_simulation_main.get_action_details

95:
96: hr_utility.set_location(gv_package || lv_procedure_name, 20);
97:
98: OPEN pay_us_payslip_simulation_main.get_action_details(p_assignment_action_id);
99: FETCH pay_us_payslip_simulation_main.get_action_details
100: INTO ln_business_group_id,
101: ln_tax_unit_id,
102: ld_effective_date,
103: ln_payroll_action_id,

Line 105: CLOSE pay_us_payslip_simulation_main.get_action_details;

101: ln_tax_unit_id,
102: ld_effective_date,
103: ln_payroll_action_id,
104: ln_assignment_id;
105: CLOSE pay_us_payslip_simulation_main.get_action_details;
106:
107: OPEN get_organization_id(ln_assignment_id,ld_effective_date);
108: FETCH get_organization_id INTO ln_organization_id;
109: CLOSE get_organization_id;

Line 123: OPEN pay_us_payslip_simulation_main.get_us_employer_addr(ln_organization_id,

119: ,ld_effective_date);
120:
121: hr_utility.set_location(gv_package || lv_procedure_name, 40);
122:
123: OPEN pay_us_payslip_simulation_main.get_us_employer_addr(ln_organization_id,
124: ln_payroll_action_id);
125: FETCH pay_us_payslip_simulation_main.get_us_employer_addr
126: INTO lv_employer_address1,
127: lv_employer_address2,

Line 125: FETCH pay_us_payslip_simulation_main.get_us_employer_addr

121: hr_utility.set_location(gv_package || lv_procedure_name, 40);
122:
123: OPEN pay_us_payslip_simulation_main.get_us_employer_addr(ln_organization_id,
124: ln_payroll_action_id);
125: FETCH pay_us_payslip_simulation_main.get_us_employer_addr
126: INTO lv_employer_address1,
127: lv_employer_address2,
128: lv_employer_address3,
129: lv_employer_city,

Line 133: CLOSE pay_us_payslip_simulation_main.get_us_employer_addr;

129: lv_employer_city,
130: lv_employer_state,
131: lv_employer_zip_code,
132: lv_employer_country ;
133: CLOSE pay_us_payslip_simulation_main.get_us_employer_addr;
134:
135: pay_payroll_xml_extract_pkg.load_xml_data('CS','US_EMPLOYER_ADDRESS',null);
136: pay_payroll_xml_extract_pkg.load_xml_data('D','ORGANIZATION_ID',ln_organization_id);
137: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS_TYPE','US Employer Address');

Line 168: OPEN pay_us_payslip_simulation_main.get_net_pay(p_assignment_action_id,'YTD');

164: IF p_action_information_category = 'AC SUMMARY YTD' THEN
165:
166: hr_utility.set_location(gv_package || lv_procedure_name, 80);
167:
168: OPEN pay_us_payslip_simulation_main.get_net_pay(p_assignment_action_id,'YTD');
169: FETCH pay_us_payslip_simulation_main.get_net_pay INTO ln_net_pay_ytd;
170: CLOSE pay_us_payslip_simulation_main.get_net_pay;
171:
172: pay_payroll_xml_extract_pkg.load_xml_data('D','NET_PAY_YTD',ln_net_pay_ytd );

Line 169: FETCH pay_us_payslip_simulation_main.get_net_pay INTO ln_net_pay_ytd;

165:
166: hr_utility.set_location(gv_package || lv_procedure_name, 80);
167:
168: OPEN pay_us_payslip_simulation_main.get_net_pay(p_assignment_action_id,'YTD');
169: FETCH pay_us_payslip_simulation_main.get_net_pay INTO ln_net_pay_ytd;
170: CLOSE pay_us_payslip_simulation_main.get_net_pay;
171:
172: pay_payroll_xml_extract_pkg.load_xml_data('D','NET_PAY_YTD',ln_net_pay_ytd );
173:

Line 170: CLOSE pay_us_payslip_simulation_main.get_net_pay;

166: hr_utility.set_location(gv_package || lv_procedure_name, 80);
167:
168: OPEN pay_us_payslip_simulation_main.get_net_pay(p_assignment_action_id,'YTD');
169: FETCH pay_us_payslip_simulation_main.get_net_pay INTO ln_net_pay_ytd;
170: CLOSE pay_us_payslip_simulation_main.get_net_pay;
171:
172: pay_payroll_xml_extract_pkg.load_xml_data('D','NET_PAY_YTD',ln_net_pay_ytd );
173:
174: hr_utility.set_location(gv_package || lv_procedure_name, 90);

Line 182: OPEN pay_us_payslip_simulation_main.get_net_pay(p_assignment_action_id,'CURRENT');

178: IF p_action_information_category = 'AC SUMMARY CURRENT' THEN
179:
180: hr_utility.set_location(gv_package || lv_procedure_name, 100);
181:
182: OPEN pay_us_payslip_simulation_main.get_net_pay(p_assignment_action_id,'CURRENT');
183: FETCH pay_us_payslip_simulation_main.get_net_pay into ln_amount;
184: CLOSE pay_us_payslip_simulation_main.get_net_pay;
185:
186: pay_payroll_xml_extract_pkg.load_xml_data('D','NET_PAY',ln_amount);

Line 183: FETCH pay_us_payslip_simulation_main.get_net_pay into ln_amount;

179:
180: hr_utility.set_location(gv_package || lv_procedure_name, 100);
181:
182: OPEN pay_us_payslip_simulation_main.get_net_pay(p_assignment_action_id,'CURRENT');
183: FETCH pay_us_payslip_simulation_main.get_net_pay into ln_amount;
184: CLOSE pay_us_payslip_simulation_main.get_net_pay;
185:
186: pay_payroll_xml_extract_pkg.load_xml_data('D','NET_PAY',ln_amount);
187:

Line 184: CLOSE pay_us_payslip_simulation_main.get_net_pay;

180: hr_utility.set_location(gv_package || lv_procedure_name, 100);
181:
182: OPEN pay_us_payslip_simulation_main.get_net_pay(p_assignment_action_id,'CURRENT');
183: FETCH pay_us_payslip_simulation_main.get_net_pay into ln_amount;
184: CLOSE pay_us_payslip_simulation_main.get_net_pay;
185:
186: pay_payroll_xml_extract_pkg.load_xml_data('D','NET_PAY',ln_amount);
187:
188: hr_utility.set_location(gv_package || lv_procedure_name, 110);

Line 242: pay_us_payslip_simulation_main.pre_processing(p_assignment_id => p_assignment_id

238: ld_effective_date := p_effective_date;
239:
240: END IF;
241:
242: pay_us_payslip_simulation_main.pre_processing(p_assignment_id => p_assignment_id
243: ,p_business_group_id => p_business_group_id
244: ,p_legislation_code => p_legislation_code
245: ,p_effective_date => p_effective_date);
246:

Line 277: pay_us_payslip_simulation_main.update_asg_data(

273: BEGIN
274:
275: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
276:
277: pay_us_payslip_simulation_main.update_asg_data(
278: p_source_action_id => p_source_action_id,
279: p_effective_date => p_effective_date);
280:
281: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);

Line 316: pay_us_payslip_simulation_main.archive_data(p_source_action_id => p_source_action_id

312: BEGIN
313:
314: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
315:
316: pay_us_payslip_simulation_main.archive_data(p_source_action_id => p_source_action_id
317: ,p_effective_date => p_effective_date);
318:
319: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);
320:

Line 356: pay_us_payslip_simulation_main.generate_xml(

352: BEGIN
353:
354: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
355:
356: pay_us_payslip_simulation_main.generate_xml(
357: p_assignment_id => p_assignment_id,
358: p_xml_code => p_xml_code,
359: p_xml => p_xml);
360: