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.3 2010/08/30 03:17:50 kaizhao ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'EGO_DEF_FUNCTIONA_AREA_PKG';
5:

Line 24: -- Functional Validations before updating MTL_DEFAULT_CATEGORY_SETS

20: FUNCTION val_process_cost_class_cat_set(P_Category_Set_Id NUMBER) return number;--bug: 9965888
21: -- FUNCTION Check_Mult_Assign_Flag RETURN VARCHAR2;
22:
23: --**********************************************************************
24: -- Functional Validations before updating MTL_DEFAULT_CATEGORY_SETS
25: --**********************************************************************
26:
27: PROCEDURE validate_all_cat_sets(P_Functional_area_id NUMBER,
28: P_Category_Set_Id NUMBER,

Line 154: From MTL_DEFAULT_CATEGORY_SETS

150: Select STRUCTURE_ID
151: Into Old_Structure_id
152: From MTL_CATEGORY_SETS_B
153: WHERE CATEGORY_SET_ID = (select category_set_id
154: From MTL_DEFAULT_CATEGORY_SETS
155: Where FUNCTIONAL_AREA_ID = 2);
156:
157: Sql_Stmt := 3;
158: Select STRUCTURE_ID

Line 314: From MTL_DEFAULT_CATEGORY_SETS

310: Select STRUCTURE_ID
311: Into Old_Structure_id
312: From MTL_CATEGORY_SETS_B
313: WHERE CATEGORY_SET_ID = (select category_set_id
314: From MTL_DEFAULT_CATEGORY_SETS
315: Where FUNCTIONAL_AREA_ID = 5);
316:
317: Sql_Stmt := 3;
318: Select STRUCTURE_ID

Line 632: MTL_DEFAULT_CATEGORY_SETS DefCat

628:
629: Select 'X'
630: Into buffer
631: From MTL_ITEM_CATEGORIES Cat,
632: MTL_DEFAULT_CATEGORY_SETS DefCat
633: Where DefCat.FUNCTIONAL_AREA_ID = 12
634: And DefCat.CATEGORY_SET_ID = Cat.CATEGORY_SET_ID
635: And NOT EXISTS
636: ( Select 'X'

Line 663: MTL_DEFAULT_CATEGORY_SETS DefCat

659:
660: Select 'X'
661: Into buffer
662: From MTL_ITEM_CATEGORIES Cat,
663: MTL_DEFAULT_CATEGORY_SETS DefCat
664: Where DefCat.FUNCTIONAL_AREA_ID = 21
665: And DefCat.CATEGORY_SET_ID = Cat.CATEGORY_SET_ID
666: And NOT EXISTS
667: ( Select 'X'

Line 697: FROM mtl_default_category_sets

693: SELECT structure_id
694: INTO old_structure_id
695: FROM mtl_category_sets_b
696: WHERE category_set_id = (SELECT category_set_id
697: FROM mtl_default_category_sets
698: WHERE functional_area_id = 19);
699:
700: sql_stmt := 3;
701:

Line 784: END MTL_DEFAULT_CATEGORY_SETS_PKG;

780: THEN
781: RETURN -1;
782: END val_process_cost_class_cat_set;
783:
784: END MTL_DEFAULT_CATEGORY_SETS_PKG;