DBA Data[Home] [Help]

APPS.OE_PROCESS_REQUISITION_PVT dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 29: l_current_org_id hr_all_organization_units_tl.organization_id%TYPE;

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

Line 569: -- hr_all_organization_units_tl.organization_id%TYPE

565: l_return_status VARCHAR2(1);
566: l_create_notification BOOLEAN := FALSE;
567: l_access_mode VARCHAR2(1) := mo_global.Get_access_mode();
568: l_original_org_id NUMBER := MO_GLOBAL.GET_CURRENT_ORG_ID();
569: -- hr_all_organization_units_tl.organization_id%TYPE
570: -- If context is SINGLE, returns current session ORG_ID
571: -- If context is MULTI, returns NULL
572: l_target_org_id hr_all_organization_units_tl.organization_id%TYPE;
573:

Line 572: l_target_org_id hr_all_organization_units_tl.organization_id%TYPE;

568: l_original_org_id NUMBER := MO_GLOBAL.GET_CURRENT_ORG_ID();
569: -- hr_all_organization_units_tl.organization_id%TYPE
570: -- If context is SINGLE, returns current session ORG_ID
571: -- If context is MULTI, returns NULL
572: l_target_org_id hr_all_organization_units_tl.organization_id%TYPE;
573:
574: l_Req_Line_NeedByDate DATE;
575: l_New_Schedule_Ship_Date DATE;
576: l_New_Schedule_Arrival_Date DATE;