APPS.OE_PROCESS_REQUISITION_PVT dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 31: l_current_org_id hr_all_organization_units_tl.organization_id%TYPE;

27: ( p_org_id IN NUMBER
28: ) IS
29:
30: l_progress VARCHAR2(3) := NULL;
31: l_current_org_id hr_all_organization_units_tl.organization_id%TYPE;
32: l_access_mode VARCHAR2(1);
33: l_ou_count NUMBER;
34: l_is_mo_init_done VARCHAR2(1);
35: --

Line 600: -- hr_all_organization_units_tl.organization_id%TYPE

596: l_return_status VARCHAR2(1);
597: l_create_notification BOOLEAN := FALSE;
598: l_access_mode VARCHAR2(1) := mo_global.Get_access_mode();
599: l_original_org_id NUMBER := MO_GLOBAL.GET_CURRENT_ORG_ID();
600: -- hr_all_organization_units_tl.organization_id%TYPE
601: -- If context is SINGLE, returns current session ORG_ID
602: -- If context is MULTI, returns NULL
603: l_target_org_id hr_all_organization_units_tl.organization_id%TYPE;
604:

Line 603: l_target_org_id hr_all_organization_units_tl.organization_id%TYPE;

599: l_original_org_id NUMBER := MO_GLOBAL.GET_CURRENT_ORG_ID();
600: -- hr_all_organization_units_tl.organization_id%TYPE
601: -- If context is SINGLE, returns current session ORG_ID
602: -- If context is MULTI, returns NULL
603: l_target_org_id hr_all_organization_units_tl.organization_id%TYPE;
604:
605: l_Req_Line_NeedByDate DATE;
606: l_New_Schedule_Ship_Date DATE;
607: l_New_Schedule_Arrival_Date DATE;