APPS.MTL_DEFAULT_CATEGORY_SETS_PKG dependencies on MTL_DEFAULT_CATEGORY_SETS

Line 1: PACKAGE BODY MTL_DEFAULT_CATEGORY_SETS_PKG AS

1: PACKAGE BODY MTL_DEFAULT_CATEGORY_SETS_PKG AS
2: /* $Header: INVDCSTB.pls 120.1 2005/06/29 06:01:14 appldev noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'EGO_DEF_FUNCTIONA_AREA_PKG';
5:

Line 23: -- Functional Validations before updating MTL_DEFAULT_CATEGORY_SETS

19: FUNCTION val_UCCNet_GPC_Cat_Set(P_Category_Set_Id NUMBER) RETURN NUMBER;
20: -- FUNCTION Check_Mult_Assign_Flag RETURN VARCHAR2;
21:
22: --**********************************************************************
23: -- Functional Validations before updating MTL_DEFAULT_CATEGORY_SETS
24: --**********************************************************************
25:
26: PROCEDURE validate_all_cat_sets(P_Functional_area_id NUMBER,
27: P_Category_Set_Id NUMBER,

Line 149: From MTL_DEFAULT_CATEGORY_SETS

145: Select STRUCTURE_ID
146: Into Old_Structure_id
147: From MTL_CATEGORY_SETS_B
148: WHERE CATEGORY_SET_ID = (select category_set_id
149: From MTL_DEFAULT_CATEGORY_SETS
150: Where FUNCTIONAL_AREA_ID = 2);
151:
152: Sql_Stmt := 3;
153: Select STRUCTURE_ID

Line 309: From MTL_DEFAULT_CATEGORY_SETS

305: Select STRUCTURE_ID
306: Into Old_Structure_id
307: From MTL_CATEGORY_SETS_B
308: WHERE CATEGORY_SET_ID = (select category_set_id
309: From MTL_DEFAULT_CATEGORY_SETS
310: Where FUNCTIONAL_AREA_ID = 5);
311:
312: Sql_Stmt := 3;
313: Select STRUCTURE_ID

Line 627: MTL_DEFAULT_CATEGORY_SETS DefCat

623:
624: Select 'X'
625: Into buffer
626: From MTL_ITEM_CATEGORIES Cat,
627: MTL_DEFAULT_CATEGORY_SETS DefCat
628: Where DefCat.FUNCTIONAL_AREA_ID = 12
629: And DefCat.CATEGORY_SET_ID = Cat.CATEGORY_SET_ID
630: And NOT EXISTS
631: ( Select 'X'

Line 658: MTL_DEFAULT_CATEGORY_SETS DefCat

654:
655: Select 'X'
656: Into buffer
657: From MTL_ITEM_CATEGORIES Cat,
658: MTL_DEFAULT_CATEGORY_SETS DefCat
659: Where DefCat.FUNCTIONAL_AREA_ID = 21
660: And DefCat.CATEGORY_SET_ID = Cat.CATEGORY_SET_ID
661: And NOT EXISTS
662: ( Select 'X'

Line 677: END MTL_DEFAULT_CATEGORY_SETS_PKG;

673: return 0;
674: End val_UCCNet_GPC_Cat_Set;
675:
676:
677: END MTL_DEFAULT_CATEGORY_SETS_PKG;