APPS.INV_ITEM_CATEGORY_PVT dependencies on MTL_DEFAULT_CATEGORY_SETS

Line 204: FROM mtl_default_category_sets

200:
201: /* Bug 8208540 :Added the below query, check if the catalog is a GPC catalog or not*/
202: select Decode(Count(1), 0,'N','Y')
203: INTO l_is_gpc_catalog
204: FROM mtl_default_category_sets
205: WHERE functional_area_id = 21
206: AND category_set_id = p_category_set_id;
207:
208: --6355354:Unapproved item can have categories assigned.

Line 216: FROM MTL_DEFAULT_CATEGORY_SETS

212: IF l_approval_status IS NOT NULL AND l_approval_status <> 'A'
213: AND l_is_gpc_catalog = 'N' /* Bug 8208540: Added an extra check, If the catalog is GPC then allow category assignment to an unapproved item. */
214: THEN
215: SELECT COUNT(*) INTO l_default_cats
216: FROM MTL_DEFAULT_CATEGORY_SETS
217: WHERE CATEGORY_SET_ID = p_category_set_id;
218: IF l_default_cats > 0 THEN
219: INV_ITEM_MSG.Add_Message
220: (p_Msg_Name => 'INV_IOI_NIR_NOT_COMPLETE'

Line 590: l_default_catalog_id MTL_DEFAULT_CATEGORY_SETS.CATEGORY_SET_ID%TYPE;

586: FF10 VARCHAR2(1);
587: FF11 VARCHAR2(1);
588: FF12 VARCHAR2(1); --Bug:6485437
589: FF21 VARCHAR2(1);
590: l_default_catalog_id MTL_DEFAULT_CATEGORY_SETS.CATEGORY_SET_ID%TYPE;
591: gdsn_outbound_enabled_flag MTL_SYSTEM_ITEMS_B.GDSN_OUTBOUND_ENABLED_FLAG%TYPE;
592:
593: inv_item_flagg VARCHAR2(1);
594: purch_item_flagg VARCHAR2(1);

Line 627: FROM mtl_default_category_sets

623: --Bug:6485437
624: CURSOR default_catalog_csr(cp_functional_area NUMBER)
625: IS
626: SELECT category_set_id
627: FROM mtl_default_category_sets
628: WHERE functional_area_id = cp_functional_area;
629:
630: CURSOR fetch_gdsn_flag(cp_inventory_item_id NUMBER,
631: cp_organization_id NUMBER)