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_BG_UPLOAD dependencies on HR_H2PI_MAP

Line 156: l_location_id := hr_h2pi_map.get_to_id

152: SAVEPOINT location_start;
153:
154: BEGIN
155: hr_utility.set_location(l_proc, 20);
156: l_location_id := hr_h2pi_map.get_to_id
157: (p_table_name => 'HR_LOCATIONS_ALL',
158: p_from_id => v_ud_loc.location_id);
159:
160: IF l_location_id = -1 THEN

Line 214: hr_h2pi_map.create_id_mapping

210: ,p_business_group_id => hr_h2pi_upload.g_to_business_group_id
211: ,p_location_id => l_location_id
212: ,p_object_version_number=> l_ovn);
213:
214: hr_h2pi_map.create_id_mapping
215: (p_table_name => 'HR_LOCATIONS_ALL',
216: p_from_id => v_ud_loc.location_id,
217: p_to_id => l_location_id);
218: ELSE

Line 430: l_location_id := hr_h2pi_map.get_to_id

426: FETCH csr_hr_org INTO v_ud_hr_org;
427: CLOSE csr_hr_org;
428:
429: hr_utility.set_location(l_proc, 40);
430: l_location_id := hr_h2pi_map.get_to_id
431: (p_table_name => 'HR_LOCATIONS_ALL',
432: p_from_id => v_ud_hr_org.location_id,
433: p_report_error => TRUE);
434:

Line 435: l_hr_org_id := hr_h2pi_map.get_to_id

431: (p_table_name => 'HR_LOCATIONS_ALL',
432: p_from_id => v_ud_hr_org.location_id,
433: p_report_error => TRUE);
434:
435: l_hr_org_id := hr_h2pi_map.get_to_id
436: (p_table_name => 'HR_ALL_ORGANIZATION_UNITS',
437: p_from_id => v_ud_hr_org.organization_id);
438:
439: hr_utility.set_location(l_proc, 50);

Line 475: hr_h2pi_map.create_id_mapping

471: ,p_organization_id => l_hr_org_id
472: ,p_object_version_number => l_ovn
473: );
474:
475: hr_h2pi_map.create_id_mapping
476: (p_table_name => 'HR_ALL_ORGANIZATION_UNITS',
477: p_from_id => v_ud_hr_org.organization_id,
478: p_to_id => l_hr_org_id);
479: ELSE

Line 540: l_hr_org_id := hr_h2pi_map.get_to_id

536:
537: ELSE
538:
539: hr_utility.set_location(l_proc, 94);
540: l_hr_org_id := hr_h2pi_map.get_to_id
541: (p_table_name => 'HR_ALL_ORGANIZATION_UNITS',
542: p_from_id => v_ud_org.organization_id,
543: p_report_error => TRUE);
544:

Line 553: l_hr_org_class_id := hr_h2pi_map.get_to_id

549: LOOP
550:
551: BEGIN
552: hr_utility.set_location(l_proc, 100);
553: l_hr_org_class_id := hr_h2pi_map.get_to_id
554: (p_table_name => 'HR_ORGANIZATION_INFORMATION',
555: p_from_id => v_ud_hr_org_class.org_information_id);
556:
557: hr_utility.set_location(l_proc, 110);

Line 568: hr_h2pi_map.create_id_mapping

564: ,p_org_information_id => l_hr_org_class_id
565: ,p_object_version_number=> l_ovn
566: );
567:
568: hr_h2pi_map.create_id_mapping
569: (p_table_name => 'HR_ORGANIZATION_INFORMATION',
570: p_from_id => v_ud_hr_org_class.org_information_id,
571: p_to_id => l_hr_org_class_id);
572: END IF;

Line 643: l_hr_org_info_id := hr_h2pi_map.get_to_id

639: FOR v_ud_hr_org_info in csr_hr_org_info(v_ud_org.organization_id)LOOP
640:
641: BEGIN
642: hr_utility.set_location(l_proc, 190);
643: l_hr_org_info_id := hr_h2pi_map.get_to_id
644: (p_table_name => 'HR_ORGANIZATION_INFORMATION',
645: p_from_id => v_ud_hr_org_info.org_information_id);
646:
647: hr_utility.set_location(l_proc, 200);

Line 665: l_org_info12 := hr_h2pi_map.get_to_id

661: -- for MMREF Contact Name
662: hr_utility.trace('Found : ' || v_ud_hr_org_info.org_information_context);
663: IF v_ud_hr_org_info.org_information12 IS NOT NULL THEN
664: hr_utility.set_location(l_proc, 220);
665: l_org_info12 := hr_h2pi_map.get_to_id
666: (p_table_name => 'PER_ALL_PEOPLE_F',
667: p_from_id => v_ud_hr_org_info.org_information12);
668: hr_utility.set_location(l_proc, 220);
669: IF l_org_info12 = -1 THEN

Line 683: l_org_info13 := hr_h2pi_map.get_to_id

679: END IF;
680: -- for Company Name
681: IF v_ud_hr_org_info.org_information13 IS NOT NULL THEN
682: hr_utility.set_location(l_proc, 260);
683: l_org_info13 := hr_h2pi_map.get_to_id
684: (p_table_name => 'HR_ALL_ORGANIZATION_UNITS',
685: p_from_id =>v_ud_hr_org_info.org_information13);
686: ELSE
687: l_org_info13 := v_ud_hr_org_info.org_information13;

Line 693: l_org_info8 := hr_h2pi_map.get_to_id

689: ElSIF v_ud_hr_org_info.org_information_context = 'State Tax Rules' THEN
690: -- for WC Carrier Name
691: hr_utility.trace('Found : ' || v_ud_hr_org_info.org_information_context);
692: IF v_ud_hr_org_info.org_information8 IS NOT NULL THEN
693: l_org_info8 := hr_h2pi_map.get_to_id
694: (p_table_name => 'HR_ALL_ORGANIZATION_UNITS',
695: p_from_id => v_ud_hr_org_info.org_information8);
696: ELSE
697: l_org_info8 := v_ud_hr_org_info.org_information8;

Line 704: l_org_info9 := hr_h2pi_map.get_to_id

700: -- for Company Name
701: hr_utility.trace('Found : ' || v_ud_hr_org_info.org_information_context);
702: IF v_ud_hr_org_info.org_information9 IS NOT NULL THEN
703: hr_utility.set_location(l_proc, 270);
704: l_org_info9 := hr_h2pi_map.get_to_id
705: (p_table_name => 'HR_ALL_ORGANIZATION_UNITS',
706: p_from_id =>v_ud_hr_org_info.org_information9);
707: ELSE
708: l_org_info9 := v_ud_hr_org_info.org_information9;

Line 712: l_org_info10 := hr_h2pi_map.get_to_id

708: l_org_info9 := v_ud_hr_org_info.org_information9;
709: END IF;
710: -- for Contact Name
711: IF v_ud_hr_org_info.org_information10 IS NOT NULL THEN
712: l_org_info10 := hr_h2pi_map.get_to_id
713: (p_table_name => 'PER_ALL_PEOPLE_F',
714: p_from_id => v_ud_hr_org_info.org_information10);
715: IF l_org_info10 = -1 THEN
716: hr_utility.trace(v_ud_hr_org_info.org_information_context || ':' ||

Line 730: l_org_info1 := hr_h2pi_map.get_to_id

726: -- for Schedule Table
727: hr_utility.trace('Found : ' || v_ud_hr_org_info.org_information_context);
728: IF v_ud_hr_org_info.org_information1 IS NOT NULL THEN
729: hr_utility.set_location(l_proc, 210);
730: l_org_info1 := hr_h2pi_map.get_to_id
731: (p_table_name => 'COMPANY_WORK_SCHEDULE',
732: p_from_id => v_ud_hr_org_info.org_information1);
733: IF l_org_info10 = -1 THEN
734: hr_utility.trace(v_ud_hr_org_info.org_information_context || ':' ||

Line 779: hr_h2pi_map.create_id_mapping

775: ,p_org_information_id => l_hr_org_info_id
776: ,p_object_version_number=> l_ovn
777: );
778:
779: hr_h2pi_map.create_id_mapping
780: (p_table_name => 'HR_ORGANIZATION_INFORMATION',
781: p_from_id => v_ud_hr_org_info.org_information_id,
782: p_to_id => l_hr_org_info_id);
783: ELSE

Line 911: l_ele_type_id := hr_h2pi_map.get_to_id

907: SAVEPOINT hr_ele_name_start;
908:
909: BEGIN
910: hr_utility.set_location(l_proc, 30);
911: l_ele_type_id := hr_h2pi_map.get_to_id
912: (p_table_name => 'PAY_ELEMENT_TYPES_F',
913: p_from_id => v_ud_ele_name.element_type_id,
914: p_report_error => TRUE);
915: