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