DBA Data[Home] [Help]

APPS.WMS_ZONES_PVT dependencies on MTL_PARAMETERS

Line 2307: FROM mtl_parameters

2303: WHERE zone_id = p_zone_id;
2304:
2305: CURSOR c_org_id IS
2306: SELECT 1
2307: FROM mtl_parameters
2308: WHERE organization_id = p_organization_id;
2309:
2310: CURSOR c_zone_name IS
2311: SELECT 1

Line 2608: FROM mtl_parameters

2604: l_id VARCHAR2(30);
2605:
2606: CURSOR c_org_id IS
2607: SELECT 1
2608: FROM mtl_parameters
2609: WHERE organization_id = p_organization_id;
2610:
2611: CURSOR c_zone_id IS
2612: SELECT 1

Line 2685: * p_organization_id must exist in MTL_PARAMETERS

2681:
2682: l_progress_indicator := '30';
2683:
2684: /**
2685: * p_organization_id must exist in MTL_PARAMETERS
2686: */
2687: OPEN c_org_id;
2688: FETCH c_org_id INTO l_id;
2689: IF c_org_id%NOTFOUND THEN