APPS.EGO_STYLE_SKU_ITEM_PVT dependencies on MTL_PARAMETERS

Line 349: FROM MTL_PARAMETERS

345: END IF;
346:
347: BEGIN
348: SELECT 'Y' INTO l_org_assignment
349: FROM MTL_PARAMETERS
350: WHERE ORGANIZATION_ID = l_organization_id
351: AND ORGANIZATION_ID <> MASTER_ORGANIZATION_ID;
352: EXCEPTION WHEN NO_DATA_FOUND THEN
353: l_org_assignment := 'N';

Line 882: l_org_code MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;

878: ,x_msg_data OUT NOCOPY VARCHAR2)
879: IS
880: l_menu_id NUMBER;
881: l_menu_disp_name FND_MENUS_VL.USER_MENU_NAME%TYPE;
882: l_org_code MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;
883: --l_object_id NUMBER;
884: l_ss_id NUMBER := EGO_IMPORT_PVT.G_PDH_SOURCE_SYSTEM_ID;
885: BEGIN
886: BEGIN

Line 897: FROM MTL_PARAMETERS

893: END;
894:
895: BEGIN
896: SELECT ORGANIZATION_CODE INTO l_org_code
897: FROM MTL_PARAMETERS
898: WHERE ORGANIZATION_ID = p_organization_id;
899: EXCEPTION WHEN NO_DATA_FOUND THEN
900: l_org_code := '-X-';
901: END;

Line 938: FROM MTL_SYSTEM_ITEMS_B msib, MTL_PARAMETERS mp

934: l_org_code,
935: l_menu_disp_name,
936: l_ss_id,
937: -99
938: FROM MTL_SYSTEM_ITEMS_B msib, MTL_PARAMETERS mp
939: WHERE msib.STYLE_ITEM_ID = p_style_item_id
940: AND msib.ORGANIZATION_ID = mp.MASTER_ORGANIZATION_ID
941: AND mp.ORGANIZATION_ID = p_organization_id
942: AND NOT EXISTS (SELECT NULL FROM FND_GRANTS fg

Line 999: FROM MTL_SYSTEM_ITEMS_B msib, MTL_PARAMETERS mp

995: p_category_set_id,
996: p_category_id,
997: l_ss_id,
998: -99
999: FROM MTL_SYSTEM_ITEMS_B msib, MTL_PARAMETERS mp
1000: WHERE msib.STYLE_ITEM_ID = p_style_item_id
1001: AND msib.ORGANIZATION_ID = mp.MASTER_ORGANIZATION_ID
1002: AND mp.ORGANIZATION_ID = p_organization_id
1003: AND NOT EXISTS (SELECT NULL FROM MTL_ITEM_CATEGORIES mic