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

Line 749: l_person_id := hr_h2pi_map.get_to_id

745: OPEN csr_ud_person(p_person_id,
746: p_effective_start_date);
747: FETCH csr_ud_person INTO v_ud_per;
748:
749: l_person_id := hr_h2pi_map.get_to_id
750: (p_table_name => 'PER_ALL_PEOPLE_F',
751: p_from_id => p_person_id);
752:
753: IF l_person_id = -1 THEN

Line 856: hr_h2pi_map.create_id_mapping

852: ,p_orig_hire_warning => l_orig_hire_warning
853: );
854:
855: hr_utility.set_location(l_proc, 30);
856: hr_h2pi_map.create_id_mapping
857: (p_table_name => 'PER_ALL_PEOPLE_F',
858: p_from_id => p_person_id,
859: p_to_id => l_person_id);
860:

Line 869: hr_h2pi_map.create_id_mapping

865: AND asg.client_id = p_from_client_id
866: AND asg.effective_start_date = v_ud_per.effective_start_date
867: AND asg.primary_flag = 'Y';
868:
869: hr_h2pi_map.create_id_mapping
870: (p_table_name => 'PER_ALL_ASSIGNMENTS_F',
871: p_from_id => l_ud_assignment_id,
872: p_to_id => l_assignment_id);
873: BEGIN

Line 887: hr_h2pi_map.create_id_mapping

883: FROM hr_h2pi_periods_of_service_v pos
884: WHERE pos.person_id = l_person_id
885: AND pos.date_start = l_esd;
886:
887: hr_h2pi_map.create_id_mapping
888: (p_table_name => 'PER_PERIODS_OF_SERVICE',
889: p_from_id => l_ud_period_of_service_id,
890: p_to_id => l_period_of_service_id);
891: EXCEPTION

Line 1104: hr_h2pi_map.create_id_mapping

1100: AND asg.client_id = p_from_client_id
1101: AND asg.effective_start_date = v_ud_per.effective_start_date
1102: AND asg.primary_flag = 'Y';
1103:
1104: hr_h2pi_map.create_id_mapping
1105: (p_table_name => 'PER_ALL_ASSIGNMENTS_F',
1106: p_from_id => l_ud_assignment_id,
1107: p_to_id => l_assignment_id);
1108:

Line 1124: hr_h2pi_map.create_id_mapping

1120: FROM hr_h2pi_periods_of_service_v pos
1121: WHERE pos.person_id = l_person_id
1122: AND pos.date_start = l_esd ;
1123:
1124: hr_h2pi_map.create_id_mapping
1125: (p_table_name => 'PER_PERIODS_OF_SERVICE',
1126: p_from_id => l_ud_period_of_service_id,
1127: p_to_id => l_period_of_service_id);
1128: EXCEPTION

Line 1223: l_period_of_service_id := hr_h2pi_map.get_to_id

1219: p_effective_start_date);
1220: FETCH csr_ud_periods_of_service INTO v_ud_pos;
1221: CLOSE csr_ud_periods_of_service;
1222:
1223: l_period_of_service_id := hr_h2pi_map.get_to_id
1224: (p_table_name => 'PER_PERIODS_OF_SERVICE',
1225: p_from_id => v_ud_pos.period_of_service_id,
1226: p_report_error => TRUE);
1227:

Line 1312: l_person_id := hr_h2pi_map.get_to_id

1308:
1309: BEGIN
1310: hr_utility.set_location('Entering:'|| l_proc, 10);
1311:
1312: l_person_id := hr_h2pi_map.get_to_id
1313: (p_table_name => 'PER_ALL_PEOPLE_F',
1314: p_from_id => p_person_id);
1315:
1316: IF l_person_id <> -1 THEN

Line 1320: l_ud_address_id := hr_h2pi_map.get_from_id

1316: IF l_person_id <> -1 THEN
1317:
1318: FOR v_ed_adr IN csr_ed_addresses(l_person_id) LOOP
1319: hr_utility.set_location(l_proc, 20);
1320: l_ud_address_id := hr_h2pi_map.get_from_id
1321: (p_table_name => 'PER_ADDRESSES',
1322: p_to_id => v_ed_adr.address_id);
1323:
1324: IF l_ud_address_id <> -1 THEN

Line 1400: l_person_id := hr_h2pi_map.get_to_id

1396:
1397: OPEN csr_ud_address(p_address_id);
1398: FETCH csr_ud_address INTO v_ud_adr;
1399:
1400: l_person_id := hr_h2pi_map.get_to_id
1401: (p_table_name => 'PER_ALL_PEOPLE_F',
1402: p_from_id => v_ud_adr.person_id,
1403: p_report_error => TRUE);
1404:

Line 1406: l_address_id := hr_h2pi_map.get_to_id

1402: p_from_id => v_ud_adr.person_id,
1403: p_report_error => TRUE);
1404:
1405: hr_utility.set_location(l_proc, 20);
1406: l_address_id := hr_h2pi_map.get_to_id
1407: (p_table_name => 'PER_ADDRESSES',
1408: p_from_id => v_ud_adr.address_id);
1409:
1410: IF l_address_id = -1 THEN

Line 1476: hr_h2pi_map.create_id_mapping

1472: ,p_object_version_number => l_ovn
1473: );
1474:
1475: hr_utility.set_location(l_proc, 40);
1476: hr_h2pi_map.create_id_mapping
1477: (p_table_name => 'PER_ADDRESSES',
1478: p_from_id => v_ud_adr.address_id,
1479: p_to_id => l_address_id);
1480: END IF;

Line 1724: l_assignment_id := hr_h2pi_map.get_to_id

1720:
1721: IF v_ud_asg.last_upd_date = g_eot THEN
1722:
1723: hr_utility.set_location(l_proc, 20);
1724: l_assignment_id := hr_h2pi_map.get_to_id
1725: (p_table_name => 'PER_ALL_ASSIGNMENTS_F',
1726: p_from_id => v_ud_asg.assignment_id,
1727: p_report_error => TRUE);
1728:

Line 1784: l_person_id := hr_h2pi_map.get_to_id

1780:
1781: ELSE
1782:
1783: hr_utility.set_location(l_proc, 70);
1784: l_person_id := hr_h2pi_map.get_to_id
1785: (p_table_name => 'PER_ALL_PEOPLE_F',
1786: p_from_id => v_ud_asg.person_id,
1787: p_report_error => TRUE);
1788:

Line 1789: l_organization_id := hr_h2pi_map.get_to_id

1785: (p_table_name => 'PER_ALL_PEOPLE_F',
1786: p_from_id => v_ud_asg.person_id,
1787: p_report_error => TRUE);
1788:
1789: l_organization_id := hr_h2pi_map.get_to_id
1790: (p_table_name => 'HR_ALL_ORGANIZATION_UNITS',
1791: p_from_id => v_ud_asg.organization_id,
1792: p_report_error => TRUE);
1793:

Line 1794: l_payroll_id := hr_h2pi_map.get_to_id

1790: (p_table_name => 'HR_ALL_ORGANIZATION_UNITS',
1791: p_from_id => v_ud_asg.organization_id,
1792: p_report_error => TRUE);
1793:
1794: l_payroll_id := hr_h2pi_map.get_to_id
1795: (p_table_name => 'PAY_ALL_PAYROLLS_F',
1796: p_from_id => v_ud_asg.payroll_id,
1797: p_report_error => TRUE);
1798:

Line 1799: l_location_id := hr_h2pi_map.get_to_id

1795: (p_table_name => 'PAY_ALL_PAYROLLS_F',
1796: p_from_id => v_ud_asg.payroll_id,
1797: p_report_error => TRUE);
1798:
1799: l_location_id := hr_h2pi_map.get_to_id
1800: (p_table_name => 'HR_LOCATIONS_ALL',
1801: p_from_id => v_ud_asg.location_id,
1802: p_report_error => TRUE);
1803:

Line 1804: l_pay_basis_id := hr_h2pi_map.get_to_id

1800: (p_table_name => 'HR_LOCATIONS_ALL',
1801: p_from_id => v_ud_asg.location_id,
1802: p_report_error => TRUE);
1803:
1804: l_pay_basis_id := hr_h2pi_map.get_to_id
1805: (p_table_name => 'PER_PAY_BASES',
1806: p_from_id => v_ud_asg.pay_basis_id,
1807: p_report_error => TRUE);
1808:

Line 1812: l_gre_id := hr_h2pi_map.get_to_id

1808:
1809: /*****************************************************
1810: * US SPECIFIC - Ideally have generic flexfield mapper
1811: *****************************************************/
1812: l_gre_id := hr_h2pi_map.get_to_id
1813: (p_table_name => 'HR_ALL_ORGANIZATION_UNITS',
1814: p_from_id => v_ud_asg.segment1,
1815: p_report_error => TRUE);
1816: v_ud_asg.segment1 := TO_CHAR(l_gre_id);

Line 1818: l_assignment_id := hr_h2pi_map.get_to_id

1814: p_from_id => v_ud_asg.segment1,
1815: p_report_error => TRUE);
1816: v_ud_asg.segment1 := TO_CHAR(l_gre_id);
1817:
1818: l_assignment_id := hr_h2pi_map.get_to_id
1819: (p_table_name => 'PER_ALL_ASSIGNMENTS_F',
1820: p_from_id => v_ud_asg.assignment_id);
1821:
1822: IF l_assignment_id = -1 THEN

Line 1947: hr_h2pi_map.create_id_mapping

1943: ,p_other_manager_warning => l_other_manager_warning
1944: );
1945:
1946: hr_utility.set_location(l_proc, 90);
1947: hr_h2pi_map.create_id_mapping
1948: (p_table_name => 'PER_ALL_ASSIGNMENTS_F',
1949: p_from_id => v_ud_asg.assignment_id,
1950: p_to_id => l_assignment_id);
1951: ELSE

Line 2063: l_person_id := hr_h2pi_map.get_to_id

2059:
2060: IF v_ud_asg.primary_flag = 'Y' AND
2061: v_ed_asg.primary_flag = 'N' THEN
2062: hr_utility.set_location(l_proc, 160);
2063: l_person_id := hr_h2pi_map.get_to_id
2064: (p_table_name => 'PER_ALL_PEOPLE_F',
2065: p_from_id => v_ud_asg.person_id,
2066: p_report_error => TRUE);
2067:

Line 2273: l_temp_id := hr_h2pi_map.get_from_id(

2269: WHERE assignment_id = l_assignment_id
2270: AND v_ud_asg.effective_start_date BETWEEN effective_start_date
2271: AND effective_end_date;
2272:
2273: l_temp_id := hr_h2pi_map.get_from_id(
2274: p_table_name => 'PAY_US_EMP_FED_TAX_RULES_F',
2275: p_to_id => l_emp_fed_tax_rule_id);
2276: IF l_temp_id = -1 THEN
2277: SELECT emp_fed_tax_rule_id

Line 2285: hr_h2pi_map.create_id_mapping

2281: AND client_id = p_from_client_id
2282: AND v_ud_asg.effective_start_date BETWEEN effective_start_date
2283: AND effective_end_date;
2284:
2285: hr_h2pi_map.create_id_mapping
2286: (p_table_name => 'PAY_US_EMP_FED_TAX_RULES_F',
2287: p_from_id => l_ud_emp_fed_tax_rule_id,
2288: p_to_id => l_emp_fed_tax_rule_id);
2289: END IF;

Line 2298: l_temp_id := hr_h2pi_map.get_from_id(

2294:
2295: hr_utility.set_location(l_proc, 210);
2296: FOR v_sta IN csr_state_tax_rule(l_assignment_id,
2297: v_ud_asg.effective_start_date) LOOP
2298: l_temp_id := hr_h2pi_map.get_from_id(
2299: p_table_name => 'PAY_US_EMP_STATE_TAX_RULES_F',
2300: p_to_id => v_sta.emp_state_tax_rule_id);
2301: IF l_temp_id = -1 THEN
2302:

Line 2312: hr_h2pi_map.create_id_mapping

2308: AND jurisdiction_code = v_sta.jurisdiction_code
2309: AND v_ud_asg.effective_start_date BETWEEN effective_start_date
2310: AND effective_end_date;
2311:
2312: hr_h2pi_map.create_id_mapping
2313: (p_table_name => 'PAY_US_EMP_STATE_TAX_RULES_F',
2314: p_from_id => l_ud_emp_state_tax_rule_id,
2315: p_to_id => v_sta.emp_state_tax_rule_id);
2316:

Line 2323: l_temp_id := hr_h2pi_map.get_from_id(

2319:
2320: hr_utility.set_location(l_proc, 220);
2321: FOR v_cnt IN csr_county_tax_rule(l_assignment_id,
2322: v_ud_asg.effective_start_date) LOOP
2323: l_temp_id := hr_h2pi_map.get_from_id(
2324: p_table_name=> 'PAY_US_EMP_COUNTY_TAX_RULES_F',
2325: p_to_id => v_cnt.emp_county_tax_rule_id);
2326: IF l_temp_id = -1 THEN
2327:

Line 2337: hr_h2pi_map.create_id_mapping

2333: AND jurisdiction_code = v_cnt.jurisdiction_code
2334: AND v_ud_asg.effective_start_date BETWEEN effective_start_date
2335: AND effective_end_date;
2336:
2337: hr_h2pi_map.create_id_mapping
2338: (p_table_name => 'PAY_US_EMP_COUNTY_TAX_RULES_F',
2339: p_from_id => l_ud_emp_county_tax_rule_id,
2340: p_to_id => v_cnt.emp_county_tax_rule_id);
2341:

Line 2348: l_temp_id := hr_h2pi_map.get_from_id(

2344:
2345: hr_utility.set_location(l_proc, 230);
2346: FOR v_cty IN csr_city_tax_rule(l_assignment_id,
2347: v_ud_asg.effective_start_date) LOOP
2348: l_temp_id := hr_h2pi_map.get_from_id(
2349: p_table_name => 'PAY_US_EMP_CITY_TAX_RULES_F',
2350: p_to_id => v_cty.emp_city_tax_rule_id);
2351: IF l_temp_id = -1 THEN
2352:

Line 2362: hr_h2pi_map.create_id_mapping

2358: AND jurisdiction_code = v_cty.jurisdiction_code
2359: AND v_ud_asg.effective_start_date BETWEEN effective_start_date
2360: AND effective_end_date;
2361:
2362: hr_h2pi_map.create_id_mapping
2363: (p_table_name => 'PAY_US_EMP_CITY_TAX_RULES_F',
2364: p_from_id => l_ud_emp_city_tax_rule_id,
2365: p_to_id => v_cty.emp_city_tax_rule_id);
2366:

Line 2429: l_period_of_service_id := hr_h2pi_map.get_to_id

2425:
2426: OPEN csr_ud_periods_of_service(p_period_of_service_id);
2427: FETCH csr_ud_periods_of_service INTO v_ud_pos;
2428:
2429: l_period_of_service_id := hr_h2pi_map.get_to_id
2430: (p_table_name => 'PER_PERIODS_OF_SERVICE',
2431: p_from_id => v_ud_pos.period_of_service_id,
2432: p_report_error => TRUE);
2433:

Line 2520: l_assignment_id := hr_h2pi_map.get_to_id

2516:
2517: OPEN csr_ud_salary(p_pay_proposal_id);
2518: FETCH csr_ud_salary INTO v_ud_ppp;
2519:
2520: l_assignment_id := hr_h2pi_map.get_to_id
2521: (p_table_name => 'PER_ALL_ASSIGNMENTS_F',
2522: p_from_id => v_ud_ppp.assignment_id,
2523: p_report_error => TRUE);
2524:

Line 2526: l_pay_proposal_id := hr_h2pi_map.get_to_id

2522: p_from_id => v_ud_ppp.assignment_id,
2523: p_report_error => TRUE);
2524:
2525: hr_utility.set_location(l_proc, 20);
2526: l_pay_proposal_id := hr_h2pi_map.get_to_id
2527: (p_table_name => 'PER_PAY_PROPOSALS',
2528: p_from_id => v_ud_ppp.pay_proposal_id);
2529:
2530: OPEN csr_sal_ee(l_assignment_id,

Line 2580: hr_h2pi_map.create_id_mapping

2576: hr_utility.set_location(l_proc || ' 2. Element_Entry_ID..' || l_element_entry_ID, 102);
2577: hr_utility.set_location(l_proc || ' 2. Proposed_salary_n..' || v_ud_ppp.proposed_salary_n, 103);
2578: hr_utility.set_location(l_proc || ' 2. Change_Date..' || v_ud_ppp.change_date, 104);
2579: hr_utility.set_location(l_proc, 40);
2580: hr_h2pi_map.create_id_mapping
2581: (p_table_name => 'PER_PAY_PROPOSALS',
2582: p_from_id => v_ud_ppp.pay_proposal_id,
2583: p_to_id => l_pay_proposal_id);
2584:

Line 2741: l_personal_pay_method_id := hr_h2pi_map.get_to_id

2737:
2738: IF v_ud_ppm.last_upd_date = g_eot THEN
2739:
2740: hr_utility.set_location(l_proc, 20);
2741: l_personal_pay_method_id := hr_h2pi_map.get_to_id
2742: (p_table_name => 'PAY_PERSONAL_PAYMENT_METHODS_F',
2743: p_from_id => v_ud_ppm.personal_payment_method_id,
2744: p_report_error => TRUE);
2745:

Line 2770: l_assignment_id := hr_h2pi_map.get_to_id

2766:
2767: ELSE
2768:
2769: hr_utility.set_location(l_proc, 70);
2770: l_assignment_id := hr_h2pi_map.get_to_id
2771: (p_table_name => 'PER_ALL_ASSIGNMENTS_F',
2772: p_from_id => v_ud_ppm.assignment_id,
2773: p_report_error => TRUE);
2774:

Line 2775: l_org_pay_method_id := hr_h2pi_map.get_to_id

2771: (p_table_name => 'PER_ALL_ASSIGNMENTS_F',
2772: p_from_id => v_ud_ppm.assignment_id,
2773: p_report_error => TRUE);
2774:
2775: l_org_pay_method_id := hr_h2pi_map.get_to_id
2776: (p_table_name => 'PAY_ORG_PAYMENT_METHODS_F',
2777: p_from_id => v_ud_ppm.org_payment_method_id,
2778: p_report_error => TRUE);
2779:

Line 2780: l_personal_pay_method_id := hr_h2pi_map.get_to_id

2776: (p_table_name => 'PAY_ORG_PAYMENT_METHODS_F',
2777: p_from_id => v_ud_ppm.org_payment_method_id,
2778: p_report_error => TRUE);
2779:
2780: l_personal_pay_method_id := hr_h2pi_map.get_to_id
2781: (p_table_name => 'PAY_PERSONAL_PAYMENT_METHODS_F',
2782: p_from_id => v_ud_ppm.personal_payment_method_id);
2783:
2784: --

Line 2788: l_payee_id := hr_h2pi_map.get_to_id

2784: --
2785: IF v_ud_ppm.payee_type = 'O' THEN
2786: hr_utility.set_location(l_proc, 71);
2787: l_payee_type := v_ud_ppm.payee_type;
2788: l_payee_id := hr_h2pi_map.get_to_id
2789: (p_table_name => 'HR_ALL_ORGANIZATION_UNITS',
2790: p_from_id => v_ud_ppm.payee_id);
2791:
2792: ELSIF v_ud_ppm.payee_type = 'P' THEN

Line 2881: hr_h2pi_map.create_id_mapping

2877: ,p_comment_id => l_comment_id
2878: );
2879:
2880: hr_utility.set_location(l_proc, 90);
2881: hr_h2pi_map.create_id_mapping
2882: (p_table_name => 'PAY_PERSONAL_PAYMENT_METHODS_F',
2883: p_from_id => v_ud_ppm.personal_payment_method_id,
2884: p_to_id => l_personal_pay_method_id);
2885: ELSE

Line 3131: l_cost_allocation_id := hr_h2pi_map.get_to_id

3127:
3128: IF v_ud_hca.last_upd_date = g_eot THEN
3129:
3130: hr_utility.set_location(l_proc, 20);
3131: l_cost_allocation_id := hr_h2pi_map.get_to_id
3132: (p_table_name => 'PAY_COST_ALLOCATIONS_F',
3133: p_from_id => v_ud_hca.cost_allocation_id,
3134: p_report_error => TRUE);
3135:

Line 3160: l_assignment_id := hr_h2pi_map.get_to_id

3156: CLOSE csr_ed_cost_allocation_ovn;
3157: ELSE
3158:
3159: hr_utility.set_location(l_proc, 40);
3160: l_assignment_id := hr_h2pi_map.get_to_id
3161: (p_table_name => 'PER_ALL_ASSIGNMENTS_F',
3162: p_from_id => v_ud_hca.assignment_id,
3163: p_report_error => TRUE);
3164:

Line 3165: l_cost_allocation_id := hr_h2pi_map.get_to_id

3161: (p_table_name => 'PER_ALL_ASSIGNMENTS_F',
3162: p_from_id => v_ud_hca.assignment_id,
3163: p_report_error => TRUE);
3164:
3165: l_cost_allocation_id := hr_h2pi_map.get_to_id
3166: (p_table_name => 'PAY_COST_ALLOCATIONS_F',
3167: p_from_id => v_ud_hca.cost_allocation_id);
3168:
3169: IF l_cost_allocation_id = -1 THEN

Line 3215: hr_h2pi_map.create_id_mapping

3211: ,p_cost_allocation_keyflex_id => l_cost_allocation_keyflex_id
3212: ,p_object_version_number => l_ovn );
3213:
3214: hr_utility.set_location(l_proc, 60);
3215: hr_h2pi_map.create_id_mapping
3216: (p_table_name => 'PAY_COST_ALLOCATIONS_F',
3217: p_from_id => v_ud_hca.cost_allocation_id,
3218: p_to_id => l_cost_allocation_id);
3219: ELSE

Line 3469: l_element_entry_id := hr_h2pi_map.get_to_id

3465:
3466: IF v_ud_ele.last_upd_date = g_eot THEN
3467:
3468: hr_utility.set_location(l_proc, 20);
3469: l_element_entry_id := hr_h2pi_map.get_to_id
3470: (p_table_name => 'PAY_ELEMENT_ENTRIES_F',
3471: p_from_id => v_ud_ele.element_entry_id,
3472: p_report_error => TRUE);
3473:

Line 3501: a_input_value_id(l_index) := hr_h2pi_map.get_to_id

3497: l_index := 1;
3498: FOR v_ud_eev IN csr_ud_element_entry_value
3499: (v_ud_ele.element_entry_id,
3500: v_ud_ele.effective_start_date) LOOP
3501: a_input_value_id(l_index) := hr_h2pi_map.get_to_id
3502: (p_table_name => 'PAY_INPUT_VALUES_F',
3503: p_from_id => v_ud_eev.input_value_id,
3504: p_report_error => TRUE);
3505: BEGIN

Line 3535: l_assignment_id := hr_h2pi_map.get_to_id

3531: l_index := l_index + 1;
3532: END LOOP;
3533:
3534: hr_utility.set_location(l_proc, 40);
3535: l_assignment_id := hr_h2pi_map.get_to_id
3536: (p_table_name => 'PER_ALL_ASSIGNMENTS_F',
3537: p_from_id => v_ud_ele.assignment_id,
3538: p_report_error => TRUE);
3539:

Line 3540: l_element_entry_id := hr_h2pi_map.get_to_id

3536: (p_table_name => 'PER_ALL_ASSIGNMENTS_F',
3537: p_from_id => v_ud_ele.assignment_id,
3538: p_report_error => TRUE);
3539:
3540: l_element_entry_id := hr_h2pi_map.get_to_id
3541: (p_table_name => 'PAY_ELEMENT_ENTRIES_F',
3542: p_from_id => v_ud_ele.element_entry_id);
3543:
3544: IF v_ud_ele.personal_payment_method_id IS NOT NULL THEN

Line 3545: l_ee_personal_pay_method_id := hr_h2pi_map.get_to_id

3541: (p_table_name => 'PAY_ELEMENT_ENTRIES_F',
3542: p_from_id => v_ud_ele.element_entry_id);
3543:
3544: IF v_ud_ele.personal_payment_method_id IS NOT NULL THEN
3545: l_ee_personal_pay_method_id := hr_h2pi_map.get_to_id
3546: (p_table_name => 'PAY_PERSONAL_PAYMENT_METHODS_F',
3547: p_from_id => v_ud_ele.personal_payment_method_id);
3548: ELSE
3549: l_ee_personal_pay_method_id := NULL;

Line 3565: /* l_id_flex_num := hr_h2pi_map.get_to_id

3561:
3562: -- Get id_flex_num using function
3563: l_id_flex_num := get_costing_id_flex_num;
3564:
3565: /* l_id_flex_num := hr_h2pi_map.get_to_id
3566: (p_table_name => 'COST_ALLOCATION_KEYFLEX',
3567: p_from_id => v_ud_ele.id_flex_num);
3568: */
3569:

Line 3574: l_element_link_id := hr_h2pi_map.get_to_id

3570: hr_utility.set_location('cost_allocation_keyflex 1' || l_id_flex_num, 1020);
3571:
3572: IF l_element_entry_id = -1 THEN
3573: hr_utility.set_location(l_proc, 50);
3574: l_element_link_id := hr_h2pi_map.get_to_id
3575: (p_table_name => 'PAY_ELEMENT_LINKS_F',
3576: p_from_id => v_ud_ele.element_link_id,
3577: p_report_error => TRUE);
3578:

Line 3687: hr_h2pi_map.create_id_mapping

3683: ,p_create_warning => l_create_warning
3684: );
3685:
3686: hr_utility.set_location(l_proc, 60);
3687: hr_h2pi_map.create_id_mapping
3688: (p_table_name => 'PAY_ELEMENT_ENTRIES_F',
3689: p_from_id => v_ud_ele.element_entry_id,
3690: p_to_id => l_element_entry_id);
3691:

Line 3985: l_emp_fed_tax_rule_id := hr_h2pi_map.get_to_id

3981: p_effective_start_date);
3982: FETCH csr_ud_federal_tax_rule INTO v_ud_fed;
3983:
3984: hr_utility.set_location(l_proc, 40);
3985: l_emp_fed_tax_rule_id := hr_h2pi_map.get_to_id
3986: (p_table_name => 'PAY_US_EMP_FED_TAX_RULES_F',
3987: p_from_id => v_ud_fed.emp_fed_tax_rule_id,
3988: p_report_error => TRUE);
3989:

Line 4220: l_assignment_id := hr_h2pi_map.get_to_id

4216: p_effective_start_date);
4217: FETCH csr_ud_state_tax_rule INTO v_ud_sta;
4218:
4219: hr_utility.set_location(l_proc, 20);
4220: l_assignment_id := hr_h2pi_map.get_to_id
4221: (p_table_name => 'PER_ALL_ASSIGNMENTS_F',
4222: p_from_id => v_ud_sta.assignment_id,
4223: p_report_error => TRUE);
4224:

Line 4225: l_emp_state_tax_rule_id := hr_h2pi_map.get_to_id

4221: (p_table_name => 'PER_ALL_ASSIGNMENTS_F',
4222: p_from_id => v_ud_sta.assignment_id,
4223: p_report_error => TRUE);
4224:
4225: l_emp_state_tax_rule_id := hr_h2pi_map.get_to_id
4226: (p_table_name => 'PAY_US_EMP_STATE_TAX_RULES_F',
4227: p_from_id => v_ud_sta.emp_state_tax_rule_id);
4228:
4229: IF l_emp_state_tax_rule_id = -1 THEN

Line 4261: hr_h2pi_map.create_id_mapping

4257: ,p_effective_end_date => l_eed
4258: );
4259:
4260: hr_utility.set_location(l_proc, 40);
4261: hr_h2pi_map.create_id_mapping
4262: (p_table_name => 'PAY_US_EMP_STATE_TAX_RULES_F',
4263: p_from_id => v_ud_sta.emp_state_tax_rule_id,
4264: p_to_id => l_emp_state_tax_rule_id);
4265: ELSE

Line 4501: l_assignment_id := hr_h2pi_map.get_to_id

4497: p_effective_start_date);
4498: FETCH csr_ud_county_tax_rule INTO v_ud_cnt;
4499:
4500: hr_utility.set_location(l_proc, 20);
4501: l_assignment_id := hr_h2pi_map.get_to_id
4502: (p_table_name => 'PER_ALL_ASSIGNMENTS_F',
4503: p_from_id => v_ud_cnt.assignment_id,
4504: p_report_error => TRUE);
4505:

Line 4506: l_emp_county_tax_rule_id := hr_h2pi_map.get_to_id

4502: (p_table_name => 'PER_ALL_ASSIGNMENTS_F',
4503: p_from_id => v_ud_cnt.assignment_id,
4504: p_report_error => TRUE);
4505:
4506: l_emp_county_tax_rule_id := hr_h2pi_map.get_to_id
4507: (p_table_name => 'PAY_US_EMP_COUNTY_TAX_RULES_F',
4508: p_from_id => v_ud_cnt.emp_county_tax_rule_id);
4509:
4510: IF l_emp_county_tax_rule_id = -1 THEN

Line 4534: hr_h2pi_map.create_id_mapping

4530: ,p_effective_end_date => l_eed
4531: );
4532:
4533: hr_utility.set_location(l_proc, 40);
4534: hr_h2pi_map.create_id_mapping
4535: (p_table_name => 'PAY_US_EMP_COUNTY_TAX_RULES_F',
4536: p_from_id => v_ud_cnt.emp_county_tax_rule_id,
4537: p_to_id => l_emp_county_tax_rule_id);
4538: ELSE

Line 4756: l_assignment_id := hr_h2pi_map.get_to_id

4752: p_effective_start_date);
4753: FETCH csr_ud_city_tax_rule INTO v_ud_cty;
4754:
4755: hr_utility.set_location(l_proc, 20);
4756: l_assignment_id := hr_h2pi_map.get_to_id
4757: (p_table_name => 'PER_ALL_ASSIGNMENTS_F',
4758: p_from_id => v_ud_cty.assignment_id,
4759: p_report_error => TRUE);
4760:

Line 4761: l_emp_city_tax_rule_id := hr_h2pi_map.get_to_id

4757: (p_table_name => 'PER_ALL_ASSIGNMENTS_F',
4758: p_from_id => v_ud_cty.assignment_id,
4759: p_report_error => TRUE);
4760:
4761: l_emp_city_tax_rule_id := hr_h2pi_map.get_to_id
4762: (p_table_name => 'PAY_US_EMP_CITY_TAX_RULES_F',
4763: p_from_id => v_ud_cty.emp_city_tax_rule_id);
4764:
4765: IF l_emp_city_tax_rule_id = -1 THEN

Line 4790: hr_h2pi_map.create_id_mapping

4786: ,p_effective_end_date => l_eed
4787: );
4788:
4789: hr_utility.set_location(l_proc, 40);
4790: hr_h2pi_map.create_id_mapping
4791: (p_table_name => 'PAY_US_EMP_CITY_TAX_RULES_F',
4792: p_from_id => v_ud_cty.emp_city_tax_rule_id,
4793: p_to_id => l_emp_city_tax_rule_id);
4794: ELSE

Line 5151: l_person_id := hr_h2pi_map.get_to_id

5147: l_effective_date DATE;
5148:
5149: begin
5150: hr_utility.set_location('Entering:'|| l_proc, 10);
5151: l_person_id := hr_h2pi_map.get_to_id
5152: (p_table_name => 'PER_ALL_PEOPLE_F',
5153: p_from_id => p_person_id,
5154: p_report_error => TRUE);
5155:

Line 5159: l_ud_assignment_id := hr_h2pi_map.get_from_id

5155:
5156: FOR v_asg IN csr_ed_assignment(l_person_id) LOOP
5157:
5158: hr_utility.set_location(l_proc, 20);
5159: l_ud_assignment_id := hr_h2pi_map.get_from_id
5160: (p_table_name => 'PER_ALL_ASSIGNMENTS_F',
5161: p_to_id => v_asg.assignment_id,
5162: p_report_error => TRUE);
5163:

Line 5174: l_ud_input_value_id1 := hr_h2pi_map.get_from_id

5170: FETCH csr_ed_input_values INTO l_input_value_id1,
5171: l_input_value_id2;
5172: CLOSE csr_ed_input_values;
5173:
5174: l_ud_input_value_id1 := hr_h2pi_map.get_from_id
5175: (p_table_name => 'PAY_INPUT_VALUES_F',
5176: p_to_id => l_input_value_id1,
5177: p_report_error => TRUE);
5178: l_ud_input_value_id2 := hr_h2pi_map.get_from_id

Line 5178: l_ud_input_value_id2 := hr_h2pi_map.get_from_id

5174: l_ud_input_value_id1 := hr_h2pi_map.get_from_id
5175: (p_table_name => 'PAY_INPUT_VALUES_F',
5176: p_to_id => l_input_value_id1,
5177: p_report_error => TRUE);
5178: l_ud_input_value_id2 := hr_h2pi_map.get_from_id
5179: (p_table_name => 'PAY_INPUT_VALUES_F',
5180: p_to_id => l_input_value_id2,
5181: p_report_error => TRUE);
5182: