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_PAYROLL_XML_EXTRACT_PKG

Line 135: pay_payroll_xml_extract_pkg.load_xml_data('CS','US_EMPLOYER_ADDRESS',null);

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');
138: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS1',lv_employer_address1);
139: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS2',lv_employer_address2);

Line 136: pay_payroll_xml_extract_pkg.load_xml_data('D','ORGANIZATION_ID',ln_organization_id);

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');
138: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS1',lv_employer_address1);
139: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS2',lv_employer_address2);
140: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS3',lv_employer_address3);

Line 137: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS_TYPE','US Employer Address');

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');
138: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS1',lv_employer_address1);
139: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS2',lv_employer_address2);
140: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS3',lv_employer_address3);
141: pay_payroll_xml_extract_pkg.load_xml_data('D','CITY',lv_employer_city);

Line 138: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS1',lv_employer_address1);

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');
138: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS1',lv_employer_address1);
139: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS2',lv_employer_address2);
140: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS3',lv_employer_address3);
141: pay_payroll_xml_extract_pkg.load_xml_data('D','CITY',lv_employer_city);
142: pay_payroll_xml_extract_pkg.load_xml_data('D','STATE',lv_employer_state);

Line 139: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS2',lv_employer_address2);

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');
138: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS1',lv_employer_address1);
139: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS2',lv_employer_address2);
140: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS3',lv_employer_address3);
141: pay_payroll_xml_extract_pkg.load_xml_data('D','CITY',lv_employer_city);
142: pay_payroll_xml_extract_pkg.load_xml_data('D','STATE',lv_employer_state);
143: pay_payroll_xml_extract_pkg.load_xml_data('D','ZIP_CODE',lv_employer_zip_code);

Line 140: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS3',lv_employer_address3);

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');
138: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS1',lv_employer_address1);
139: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS2',lv_employer_address2);
140: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS3',lv_employer_address3);
141: pay_payroll_xml_extract_pkg.load_xml_data('D','CITY',lv_employer_city);
142: pay_payroll_xml_extract_pkg.load_xml_data('D','STATE',lv_employer_state);
143: pay_payroll_xml_extract_pkg.load_xml_data('D','ZIP_CODE',lv_employer_zip_code);
144: pay_payroll_xml_extract_pkg.load_xml_data('D','COUNTRY',lv_employer_country);

Line 141: pay_payroll_xml_extract_pkg.load_xml_data('D','CITY',lv_employer_city);

137: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS_TYPE','US Employer Address');
138: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS1',lv_employer_address1);
139: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS2',lv_employer_address2);
140: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS3',lv_employer_address3);
141: pay_payroll_xml_extract_pkg.load_xml_data('D','CITY',lv_employer_city);
142: pay_payroll_xml_extract_pkg.load_xml_data('D','STATE',lv_employer_state);
143: pay_payroll_xml_extract_pkg.load_xml_data('D','ZIP_CODE',lv_employer_zip_code);
144: pay_payroll_xml_extract_pkg.load_xml_data('D','COUNTRY',lv_employer_country);
145: pay_payroll_xml_extract_pkg.load_xml_data('CE','US_EMPLOYER_ADDRESS',null);

Line 142: pay_payroll_xml_extract_pkg.load_xml_data('D','STATE',lv_employer_state);

138: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS1',lv_employer_address1);
139: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS2',lv_employer_address2);
140: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS3',lv_employer_address3);
141: pay_payroll_xml_extract_pkg.load_xml_data('D','CITY',lv_employer_city);
142: pay_payroll_xml_extract_pkg.load_xml_data('D','STATE',lv_employer_state);
143: pay_payroll_xml_extract_pkg.load_xml_data('D','ZIP_CODE',lv_employer_zip_code);
144: pay_payroll_xml_extract_pkg.load_xml_data('D','COUNTRY',lv_employer_country);
145: pay_payroll_xml_extract_pkg.load_xml_data('CE','US_EMPLOYER_ADDRESS',null);
146:

Line 143: pay_payroll_xml_extract_pkg.load_xml_data('D','ZIP_CODE',lv_employer_zip_code);

139: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS2',lv_employer_address2);
140: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS3',lv_employer_address3);
141: pay_payroll_xml_extract_pkg.load_xml_data('D','CITY',lv_employer_city);
142: pay_payroll_xml_extract_pkg.load_xml_data('D','STATE',lv_employer_state);
143: pay_payroll_xml_extract_pkg.load_xml_data('D','ZIP_CODE',lv_employer_zip_code);
144: pay_payroll_xml_extract_pkg.load_xml_data('D','COUNTRY',lv_employer_country);
145: pay_payroll_xml_extract_pkg.load_xml_data('CE','US_EMPLOYER_ADDRESS',null);
146:
147: hr_utility.set_location(gv_package || lv_procedure_name, 50);

Line 144: pay_payroll_xml_extract_pkg.load_xml_data('D','COUNTRY',lv_employer_country);

140: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS3',lv_employer_address3);
141: pay_payroll_xml_extract_pkg.load_xml_data('D','CITY',lv_employer_city);
142: pay_payroll_xml_extract_pkg.load_xml_data('D','STATE',lv_employer_state);
143: pay_payroll_xml_extract_pkg.load_xml_data('D','ZIP_CODE',lv_employer_zip_code);
144: pay_payroll_xml_extract_pkg.load_xml_data('D','COUNTRY',lv_employer_country);
145: pay_payroll_xml_extract_pkg.load_xml_data('CE','US_EMPLOYER_ADDRESS',null);
146:
147: hr_utility.set_location(gv_package || lv_procedure_name, 50);
148:

Line 145: pay_payroll_xml_extract_pkg.load_xml_data('CE','US_EMPLOYER_ADDRESS',null);

141: pay_payroll_xml_extract_pkg.load_xml_data('D','CITY',lv_employer_city);
142: pay_payroll_xml_extract_pkg.load_xml_data('D','STATE',lv_employer_state);
143: pay_payroll_xml_extract_pkg.load_xml_data('D','ZIP_CODE',lv_employer_zip_code);
144: pay_payroll_xml_extract_pkg.load_xml_data('D','COUNTRY',lv_employer_country);
145: pay_payroll_xml_extract_pkg.load_xml_data('CE','US_EMPLOYER_ADDRESS',null);
146:
147: hr_utility.set_location(gv_package || lv_procedure_name, 50);
148:
149: OPEN get_employer_name_phone(ln_organization_id);

Line 153: pay_payroll_xml_extract_pkg.load_xml_data('CS','US_EMPLOYER_DETAILS',null);

149: OPEN get_employer_name_phone(ln_organization_id);
150: FETCH get_employer_name_phone INTO lv_employer_name,lv_phone_number;
151: CLOSE get_employer_name_phone;
152:
153: pay_payroll_xml_extract_pkg.load_xml_data('CS','US_EMPLOYER_DETAILS',null);
154: pay_payroll_xml_extract_pkg.load_xml_data('D','US_EMPLOYER_NAME',lv_employer_name);
155: pay_payroll_xml_extract_pkg.load_xml_data('D','US_EMPLOYER_PHONE',lv_phone_number);
156: pay_payroll_xml_extract_pkg.load_xml_data('CE','US_EMPLOYER_DETAILS',null);
157:

Line 154: pay_payroll_xml_extract_pkg.load_xml_data('D','US_EMPLOYER_NAME',lv_employer_name);

150: FETCH get_employer_name_phone INTO lv_employer_name,lv_phone_number;
151: CLOSE get_employer_name_phone;
152:
153: pay_payroll_xml_extract_pkg.load_xml_data('CS','US_EMPLOYER_DETAILS',null);
154: pay_payroll_xml_extract_pkg.load_xml_data('D','US_EMPLOYER_NAME',lv_employer_name);
155: pay_payroll_xml_extract_pkg.load_xml_data('D','US_EMPLOYER_PHONE',lv_phone_number);
156: pay_payroll_xml_extract_pkg.load_xml_data('CE','US_EMPLOYER_DETAILS',null);
157:
158: hr_utility.set_location(gv_package || lv_procedure_name, 60);

Line 155: pay_payroll_xml_extract_pkg.load_xml_data('D','US_EMPLOYER_PHONE',lv_phone_number);

151: CLOSE get_employer_name_phone;
152:
153: pay_payroll_xml_extract_pkg.load_xml_data('CS','US_EMPLOYER_DETAILS',null);
154: pay_payroll_xml_extract_pkg.load_xml_data('D','US_EMPLOYER_NAME',lv_employer_name);
155: pay_payroll_xml_extract_pkg.load_xml_data('D','US_EMPLOYER_PHONE',lv_phone_number);
156: pay_payroll_xml_extract_pkg.load_xml_data('CE','US_EMPLOYER_DETAILS',null);
157:
158: hr_utility.set_location(gv_package || lv_procedure_name, 60);
159:

Line 156: pay_payroll_xml_extract_pkg.load_xml_data('CE','US_EMPLOYER_DETAILS',null);

152:
153: pay_payroll_xml_extract_pkg.load_xml_data('CS','US_EMPLOYER_DETAILS',null);
154: pay_payroll_xml_extract_pkg.load_xml_data('D','US_EMPLOYER_NAME',lv_employer_name);
155: pay_payroll_xml_extract_pkg.load_xml_data('D','US_EMPLOYER_PHONE',lv_phone_number);
156: pay_payroll_xml_extract_pkg.load_xml_data('CE','US_EMPLOYER_DETAILS',null);
157:
158: hr_utility.set_location(gv_package || lv_procedure_name, 60);
159:
160: END IF;

Line 172: pay_payroll_xml_extract_pkg.load_xml_data('D','NET_PAY_YTD',ln_net_pay_ytd );

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);
175:
176: END IF;

Line 186: pay_payroll_xml_extract_pkg.load_xml_data('D','NET_PAY',ln_amount);

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);
189:
190: END IF;

Line 327: PAY_PAYROLL_XML_EXTRACT_PKG.GENERATE.

323: /* Procedure : generate_xml
324: Purpose : This procedure is used to generate the XML Data necessary
325: to generate the Payroll Simulation Output. This procedure
326: is similar to the current XML generation procedure
327: PAY_PAYROLL_XML_EXTRACT_PKG.GENERATE.
328: Important : This procedure will be executed by Core Payroll post the
329: Database level rollback of changes made during Payroll
330: Simulation run. Hence any information required for
331: generating Output, that will not be available due to