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.HR_H2PI_MAPPING_SETUP dependencies on HR_UTILITY

Line 17: hr_utility.set_location('Entering:'|| l_proc, 10);

13: l_from_client_id NUMBER(15);
14: l_to_business_group_id hr_all_organization_units.business_group_id%type;
15: --
16: BEGIN
17: hr_utility.set_location('Entering:'|| l_proc, 10);
18: l_from_client_id := p_from_client_id;
19: l_to_business_group_id := hr_h2pi_upload.g_to_business_group_id;
20: --
21: -- Inserts the mapping records for 'HR_LOCATIONS_ALL' table.

Line 43: hr_utility.set_location(l_proc, 20);

39: AND map.to_business_group_id = l_to_business_group_id);
40: --
41: -- Inserts the mapping records for 'PER_PAY_BASES' table.
42: --
43: hr_utility.set_location(l_proc, 20);
44: INSERT INTO hr_h2pi_id_mapping
45: (from_id, to_id, to_business_group_id, table_name)
46: SELECT ppb1.pay_basis_id,
47: ppb2.pay_basis_id,

Line 64: hr_utility.set_location(l_proc, 30);

60: AND map.to_business_group_id = l_to_business_group_id);
61: --
62: -- Inserts the mapping records for 'HR_ALL_ORGANIZATION_UNITS' table.
63: --
64: hr_utility.set_location(l_proc, 30);
65: INSERT INTO hr_h2pi_id_mapping
66: (from_id, to_id, to_business_group_id, table_name)
67: SELECT v1.from_org_id,
68: v2.to_org_id,

Line 91: hr_utility.set_location(l_proc, 40);

87: AND map.to_business_group_id = l_to_business_group_id);
88: --
89: -- Inserts the mapping records for 'HR_ORGANIZATION_INFORMATION' table.
90: --
91: hr_utility.set_location(l_proc, 40);
92: INSERT INTO hr_h2pi_id_mapping
93: (from_id, to_id, to_business_group_id, table_name)
94: SELECT v1.from_org_info_id,
95: v2.to_org_info_id,

Line 128: hr_utility.set_location(l_proc, 50);

124:
125: --
126: -- Inserts the mapping records for 'PAY_ALL_PAYROLLS_F' table.
127: --
128: hr_utility.set_location(l_proc, 50);
129: INSERT INTO hr_h2pi_id_mapping
130: (from_id, to_id, to_business_group_id, table_name)
131: SELECT pay1.payroll_id,
132: pay2.payroll_id,

Line 149: hr_utility.set_location(l_proc, 60);

145: AND map.to_business_group_id = l_to_business_group_id);
146: --
147: -- Inserts the mapping records for 'PAY_ELEMENT_TYPES_F' table.
148: --
149: hr_utility.set_location(l_proc, 60);
150: INSERT INTO hr_h2pi_id_mapping
151: (from_id, to_id, to_business_group_id, table_name)
152: SELECT et1.element_type_id,
153: et2.element_type_id,

Line 173: hr_utility.set_location(l_proc, 70);

169: AND map.to_business_group_id = l_to_business_group_id);
170: --
171: -- Inserts the mapping records for 'PAY_INPUT_VALUES_F' table.
172: --
173: hr_utility.set_location(l_proc, 70);
174: INSERT INTO hr_h2pi_id_mapping
175: (from_id, to_id, to_business_group_id, table_name)
176: SELECT iv1.input_value_id,
177: iv2.input_value_id,

Line 202: hr_utility.set_location(l_proc, 80);

198: AND map.to_business_group_id = l_to_business_group_id);
199: --
200: -- Inserts the mapping records for 'PAY_ELEMENT_LINKS_F' table.
201: --
202: hr_utility.set_location(l_proc, 80);
203: INSERT INTO hr_h2pi_id_mapping
204: (from_id, to_id, to_business_group_id, table_name)
205: SELECT el1.element_link_id,
206: el2.element_link_id,

Line 232: hr_utility.set_location(l_proc, 90);

228: AND map.to_business_group_id = l_to_business_group_id);
229: --
230: -- Inserts the mapping records for 'PAY_ORG_PAYMENT_METHODS_F' table.
231: --
232: hr_utility.set_location(l_proc, 90);
233: INSERT INTO hr_h2pi_id_mapping
234: (from_id, to_id, to_business_group_id, table_name)
235: SELECT opm1.org_payment_method_id,
236: opm2.org_payment_method_id,

Line 250: hr_utility.set_location('Leaving:'|| l_proc, 100);

246: WHERE (map.from_id = opm1.org_payment_method_id
247: OR map.to_id = opm2.org_payment_method_id)
248: AND map.table_name = 'PAY_ORG_PAYMENT_METHODS_F'
249: AND map.to_business_group_id = l_to_business_group_id);
250: hr_utility.set_location('Leaving:'|| l_proc, 100);
251: COMMIT;
252: END mapping_setup;
253: --
254: PROCEDURE mapping_id_upload (p_errbuf OUT NOCOPY VARCHAR2,

Line 266: hr_utility.set_location('Entering:'|| l_proc, 10);

262: l_from_business_group_id hr_all_organization_units.organization_id%TYPE;
263: l_from_client_id hr_all_organization_units.organization_id%TYPE;
264:
265: BEGIN
266: hr_utility.set_location('Entering:'|| l_proc, 10);
267: hr_h2pi_upload.g_request_id :=
268: hr_h2pi_main_upload.get_request_id('H2PI_MAPPING_ID_SETUP');
269: hr_h2pi_upload.g_to_business_group_id := p_business_group_id;
270: l_from_client_id := hr_h2pi_upload.get_from_client_id;

Line 272: hr_utility.set_location(l_proc, 20);

268: hr_h2pi_main_upload.get_request_id('H2PI_MAPPING_ID_SETUP');
269: hr_h2pi_upload.g_to_business_group_id := p_business_group_id;
270: l_from_client_id := hr_h2pi_upload.get_from_client_id;
271:
272: hr_utility.set_location(l_proc, 20);
273: hr_utility.set_location(p_file_name, 20);
274: hr_h2pi_upload.upload(p_errbuf => p_errbuf,
275: p_retcode => p_retcode,
276: p_file_name => p_file_name);

Line 273: hr_utility.set_location(p_file_name, 20);

269: hr_h2pi_upload.g_to_business_group_id := p_business_group_id;
270: l_from_client_id := hr_h2pi_upload.get_from_client_id;
271:
272: hr_utility.set_location(l_proc, 20);
273: hr_utility.set_location(p_file_name, 20);
274: hr_h2pi_upload.upload(p_errbuf => p_errbuf,
275: p_retcode => p_retcode,
276: p_file_name => p_file_name);
277:

Line 278: hr_utility.set_location(l_proc, 30);

274: hr_h2pi_upload.upload(p_errbuf => p_errbuf,
275: p_retcode => p_retcode,
276: p_file_name => p_file_name);
277:
278: hr_utility.set_location(l_proc, 30);
279: mapping_setup(l_from_client_id);
280: hr_h2pi_validate.validate_bg_and_gre(l_from_client_id);
281: hr_h2pi_validate.validate_pay_basis(l_from_client_id);
282: hr_h2pi_validate.validate_payroll(l_from_client_id);

Line 286: hr_utility.set_location(l_proc, 40);

282: hr_h2pi_validate.validate_payroll(l_from_client_id);
283: hr_h2pi_validate.validate_org_payment_method(l_from_client_id);
284: hr_h2pi_validate.validate_element_type(l_from_client_id);
285: hr_h2pi_validate.validate_element_link(l_from_client_id);
286: hr_utility.set_location(l_proc, 40);
287: IF hr_h2pi_error.check_for_errors THEN
288: hr_utility.set_location(l_proc, 50);
289: hr_h2pi_error.generate_error_report;
290: END IF;

Line 288: hr_utility.set_location(l_proc, 50);

284: hr_h2pi_validate.validate_element_type(l_from_client_id);
285: hr_h2pi_validate.validate_element_link(l_from_client_id);
286: hr_utility.set_location(l_proc, 40);
287: IF hr_h2pi_error.check_for_errors THEN
288: hr_utility.set_location(l_proc, 50);
289: hr_h2pi_error.generate_error_report;
290: END IF;
291: hr_utility.set_location(l_proc, 60);
292: hr_h2pi_main_upload.clear_staging_tables(l_from_client_id);

Line 291: hr_utility.set_location(l_proc, 60);

287: IF hr_h2pi_error.check_for_errors THEN
288: hr_utility.set_location(l_proc, 50);
289: hr_h2pi_error.generate_error_report;
290: END IF;
291: hr_utility.set_location(l_proc, 60);
292: hr_h2pi_main_upload.clear_staging_tables(l_from_client_id);
293:
294: hr_utility.set_location('Leaving:'|| l_proc, 70);
295: END;

Line 294: hr_utility.set_location('Leaving:'|| l_proc, 70);

290: END IF;
291: hr_utility.set_location(l_proc, 60);
292: hr_h2pi_main_upload.clear_staging_tables(l_from_client_id);
293:
294: hr_utility.set_location('Leaving:'|| l_proc, 70);
295: END;
296:
297: END hr_h2pi_mapping_setup;