APPS.HR_H2PI_BG_UPLOAD dependencies on HR_ALL_ORGANIZATION_UNITS

Line 379: l_hr_org_id hr_all_organization_units.organization_id%TYPE := NULL;

375: FROM fnd_sessions
376: WHERE session_id = userenv('sessionid');
377: --
378: v_ud_hr_org hr_h2pi_hr_organizations%ROWTYPE;
379: l_hr_org_id hr_all_organization_units.organization_id%TYPE := NULL;
380: l_hr_org_class_id hr_organization_information.org_information_id%TYPE := NULL;
381: l_hr_org_info_id hr_organization_information.org_information_id%TYPE := NULL;
382: l_location_id hr_all_organization_units.location_id%TYPE;
383: l_encoded_message VARCHAR2(200);

Line 382: l_location_id hr_all_organization_units.location_id%TYPE;

378: v_ud_hr_org hr_h2pi_hr_organizations%ROWTYPE;
379: l_hr_org_id hr_all_organization_units.organization_id%TYPE := NULL;
380: l_hr_org_class_id hr_organization_information.org_information_id%TYPE := NULL;
381: l_hr_org_info_id hr_organization_information.org_information_id%TYPE := NULL;
382: l_location_id hr_all_organization_units.location_id%TYPE;
383: l_encoded_message VARCHAR2(200);
384: l_org_info2 VARCHAR2(150);
385: l_ovn NUMBER(9);
386: l_session_date DATE;

Line 436: (p_table_name => 'HR_ALL_ORGANIZATION_UNITS',

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);
440: IF l_hr_org_id = -1 THEN

Line 476: (p_table_name => 'HR_ALL_ORGANIZATION_UNITS',

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
480: hr_utility.set_location(l_proc, 70);

Line 484: FROM hr_all_organization_units org

480: hr_utility.set_location(l_proc, 70);
481: BEGIN
482: SELECT org.object_version_number
483: INTO l_ovn
484: FROM hr_all_organization_units org
485: WHERE org.organization_id = l_hr_org_id;
486: EXCEPTION
487: WHEN NO_DATA_FOUND THEN
488: hr_utility.set_location(l_proc, 75);

Line 541: (p_table_name => 'HR_ALL_ORGANIZATION_UNITS',

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:
545: END IF;

Line 684: (p_table_name => 'HR_ALL_ORGANIZATION_UNITS',

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;
688: END IF;

Line 694: (p_table_name => 'HR_ALL_ORGANIZATION_UNITS',

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;
698: END IF;

Line 705: (p_table_name => 'HR_ALL_ORGANIZATION_UNITS',

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;
709: END IF;