APPS.HR_H2PI_BG_UPLOAD dependencies on HR_ORGANIZATION_INFORMATION

Line 380: l_hr_org_class_id hr_organization_information.org_information_id%TYPE := NULL;

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);
384: l_org_info2 VARCHAR2(150);

Line 381: l_hr_org_info_id hr_organization_information.org_information_id%TYPE := NULL;

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);
384: l_org_info2 VARCHAR2(150);
385: l_ovn NUMBER(9);

Line 554: (p_table_name => 'HR_ORGANIZATION_INFORMATION',

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);
558: IF l_hr_org_class_id = -1 THEN

Line 569: (p_table_name => 'HR_ORGANIZATION_INFORMATION',

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;
573:

Line 581: FROM hr_organization_information

577: SELECT org_information2,
578: object_version_number
579: INTO l_org_info2,
580: l_ovn
581: FROM hr_organization_information
582: WHERE org_information_id = l_hr_org_class_id;
583: EXCEPTION
584: WHEN NO_DATA_FOUND THEN
585: hr_utility.set_location(l_proc, 135);

Line 644: (p_table_name => 'HR_ORGANIZATION_INFORMATION',

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);
648:

Line 780: (p_table_name => 'HR_ORGANIZATION_INFORMATION',

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
784:

Line 792: FROM hr_organization_information

788: SELECT org_information2,
789: object_version_number
790: INTO l_org_info2,
791: l_ovn
792: FROM hr_organization_information
793: WHERE org_information_id = l_hr_org_info_id;
794: EXCEPTION
795: WHEN NO_DATA_FOUND THEN
796: hr_utility.set_location(l_proc, 50);