DBA Data[Home] [Help]

APPS.HR_H2PI_VALIDATE dependencies on HR_H2PI_MAP

Line 85: l_organization_to_id := hr_h2pi_map.get_to_id

81: <>
82: FOR v_ud_rec IN csr_bg_and_gre LOOP
83: SAVEPOINT org_start;
84: hr_utility.set_location(l_proc, 20);
85: l_organization_to_id := hr_h2pi_map.get_to_id
86: (p_table_name => 'HR_ALL_ORGANIZATION_UNITS',
87: p_from_id => v_ud_rec.organization_id);
88:
89: IF l_organization_to_id = -1 THEN

Line 106: l_location_id := hr_h2pi_map.get_to_id

102:
103: l_counter := l_counter + 1 ;
104: bg_and_gre_tab(l_counter) := l_organization_to_id;
105:
106: l_location_id := hr_h2pi_map.get_to_id
107: (p_table_name => 'HR_LOCATIONS_ALL',
108: p_from_id => v_ud_rec.location_id,
109: p_report_error => TRUE);
110: IF l_ed_rec.date_from <> v_ud_rec.date_from OR

Line 246: l_pay_basis_to_id := hr_h2pi_map.get_to_id

242: <>
243: FOR v_ud_rec IN csr_pay_bases LOOP
244: SAVEPOINT pay_basis_start;
245: hr_utility.set_location(l_proc, 20);
246: l_pay_basis_to_id := hr_h2pi_map.get_to_id
247: (p_table_name => 'PER_PAY_BASES',
248: p_from_id => v_ud_rec.pay_basis_id);
249:
250: IF l_pay_basis_to_id = -1 THEN

Line 401: l_payroll_to_id := hr_h2pi_map.get_to_id

397: <>
398: FOR v_ud_rec IN csr_payrolls LOOP
399: SAVEPOINT payroll_start;
400: hr_utility.set_location(l_proc, 20);
401: l_payroll_to_id := hr_h2pi_map.get_to_id
402: (p_table_name => 'PAY_ALL_PAYROLLS_F',
403: p_from_id => v_ud_rec.payroll_id);
404:
405: IF l_payroll_to_id = -1 THEN

Line 563: l_element_type_to_id := hr_h2pi_map.get_to_id

559: <>
560: FOR v_ud_rec IN csr_element_type LOOP
561: SAVEPOINT element_type_start;
562: hr_utility.set_location(l_proc, 20);
563: l_element_type_to_id := hr_h2pi_map.get_to_id
564: (p_table_name => 'PAY_ELEMENT_TYPES_F',
565: p_from_id => v_ud_rec.element_type_id);
566:
567: IF l_element_type_to_id = -1 THEN

Line 723: l_org_payment_method_to_id := hr_h2pi_map.get_to_id

719: <>
720: FOR v_ud_rec IN csr_org_payment_method LOOP
721: SAVEPOINT org_payment_start;
722: hr_utility.set_location(l_proc, 20);
723: l_org_payment_method_to_id := hr_h2pi_map.get_to_id
724: (p_table_name => 'PAY_ORG_PAYMENT_METHODS_F',
725: p_from_id => v_ud_rec.org_payment_method_id);
726:
727: IF l_org_payment_method_to_id = -1 THEN

Line 894: l_element_link_to_id := hr_h2pi_map.get_to_id

890: <>
891: FOR v_ud_rec IN csr_element_link LOOP
892: SAVEPOINT element_link_start;
893: hr_utility.set_location(l_proc, 20);
894: l_element_link_to_id := hr_h2pi_map.get_to_id
895: (p_table_name => 'PAY_ELEMENT_LINKS_F',
896: p_from_id => v_ud_rec.element_link_id);
897:
898: IF l_element_link_to_id = -1 THEN

Line 917: l_payroll_id := hr_h2pi_map.get_to_id

913:
914: l_counter := l_counter + 1 ;
915: element_link_tab(l_counter) := l_element_link_to_id;
916:
917: l_payroll_id := hr_h2pi_map.get_to_id
918: (p_table_name => 'PAY_ALL_PAYROLLS_F',
919: p_from_id => v_ud_rec.payroll_id,
920: p_report_error => TRUE);
921: l_organization_id := hr_h2pi_map.get_to_id

Line 921: l_organization_id := hr_h2pi_map.get_to_id

917: l_payroll_id := hr_h2pi_map.get_to_id
918: (p_table_name => 'PAY_ALL_PAYROLLS_F',
919: p_from_id => v_ud_rec.payroll_id,
920: p_report_error => TRUE);
921: l_organization_id := hr_h2pi_map.get_to_id
922: (p_table_name => 'HR_ALL_ORGANIZATIONS_UNITS',
923: p_from_id => v_ud_rec.organization_id,
924: p_report_error => TRUE);
925: l_pay_basis_id := hr_h2pi_map.get_to_id

Line 925: l_pay_basis_id := hr_h2pi_map.get_to_id

921: l_organization_id := hr_h2pi_map.get_to_id
922: (p_table_name => 'HR_ALL_ORGANIZATIONS_UNITS',
923: p_from_id => v_ud_rec.organization_id,
924: p_report_error => TRUE);
925: l_pay_basis_id := hr_h2pi_map.get_to_id
926: (p_table_name => 'PER_PAY_BASES',
927: p_from_id => v_ud_rec.pay_basis_id,
928: p_report_error => TRUE);
929: IF l_ed_rec.effective_start_date <> v_ud_rec.effective_start_date OR

Line 1155: hr_h2pi_map.get_from_id(p_table_name=>'PAY_INPUT_VALUES_F',

1151: open csr_input_values;
1152: fetch csr_input_values into l_input_value1;
1153: fetch csr_input_values into l_input_value2;
1154: l_input_value1 :=
1155: hr_h2pi_map.get_from_id(p_table_name=>'PAY_INPUT_VALUES_F',
1156: p_to_id => l_input_value1,
1157: p_report_error => TRUE);
1158: l_input_value2 :=
1159: hr_h2pi_map.get_from_id(p_table_name=>'PAY_INPUT_VALUES_F',

Line 1159: hr_h2pi_map.get_from_id(p_table_name=>'PAY_INPUT_VALUES_F',

1155: hr_h2pi_map.get_from_id(p_table_name=>'PAY_INPUT_VALUES_F',
1156: p_to_id => l_input_value1,
1157: p_report_error => TRUE);
1158: l_input_value2 :=
1159: hr_h2pi_map.get_from_id(p_table_name=>'PAY_INPUT_VALUES_F',
1160: p_to_id => l_input_value2,
1161: p_report_error => TRUE);
1162:
1163: --