APPS.OE_DEPENDENCIES dependencies on OE_DEPENDENCIES

Line 1: PACKAGE BODY OE_Dependencies AS

1: PACKAGE BODY OE_Dependencies AS
2: /* $Header: OEXUDEPB.pls 120.11.12020000.3 2013/02/04 17:25:26 sujithku ship $ */
3:
4: -- Global constant holding the package name
5:

Line 6: G_PKG_NAME CONSTANT VARCHAR2(30):='OE_Dependencies';

2: /* $Header: OEXUDEPB.pls 120.11.12020000.3 2013/02/04 17:25:26 sujithku ship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30):='OE_Dependencies';
7:
8: PROCEDURE Merge_Dependencies_Extn
9: ( p_entity_code IN VARCHAR2
10: )

Line 13: l_extn_dep_tbl OE_Dependencies_Extn.Dep_Tbl_Type;

9: ( p_entity_code IN VARCHAR2
10: )
11: IS
12: l_index NUMBER;
13: l_extn_dep_tbl OE_Dependencies_Extn.Dep_Tbl_Type;
14: l_dep_index NUMBER;
15: l_found BOOLEAN;
16: --
17: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 21: oe_debug_pub.add( 'ENTER OE_DEPENDENCIES.MERGE_DEPENDENCIES_EXTN' , 1 ) ;

17: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
18: --
19: BEGIN
20: IF l_debug_level > 0 THEN
21: oe_debug_pub.add( 'ENTER OE_DEPENDENCIES.MERGE_DEPENDENCIES_EXTN' , 1 ) ;
22: END IF;
23:
24: OE_Dependencies_Extn.Load_Entity_Attributes
25: (p_entity_code => p_entity_code

Line 24: OE_Dependencies_Extn.Load_Entity_Attributes

20: IF l_debug_level > 0 THEN
21: oe_debug_pub.add( 'ENTER OE_DEPENDENCIES.MERGE_DEPENDENCIES_EXTN' , 1 ) ;
22: END IF;
23:
24: OE_Dependencies_Extn.Load_Entity_Attributes
25: (p_entity_code => p_entity_code
26: ,x_extn_dep_tbl => l_extn_dep_tbl
27: );
28:

Line 113: oe_debug_pub.add( 'EXIT OE_DEPENDENCIES.MERGE_DEPENDENCIES_EXTN' , 1 ) ;

109:
110: END LOOP;
111:
112: IF l_debug_level > 0 THEN
113: oe_debug_pub.add( 'EXIT OE_DEPENDENCIES.MERGE_DEPENDENCIES_EXTN' , 1 ) ;
114: END IF;
115: EXCEPTION
116: WHEN OTHERS THEN
117: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 137: oe_debug_pub.add( 'ENTERING OE_DEPENDENCIES.LOAD_ENTITY_ATTRIBUTES' , 1 ) ;

133: --
134: BEGIN
135:
136: IF l_debug_level > 0 THEN
137: oe_debug_pub.add( 'ENTERING OE_DEPENDENCIES.LOAD_ENTITY_ATTRIBUTES' , 1 ) ;
138: END IF;
139:
140: IF g_entity_code <> p_entity_code OR
141: g_entity_code IS NULL

Line 818: -- to the new extension api - OE_Dependencies_Extn (OEXEDEPS/B.pls)

814: --serla end
815: END IF;
816:
817: -- Merge any dependencies that user wants to enable/disable via call
818: -- to the new extension api - OE_Dependencies_Extn (OEXEDEPS/B.pls)
819: Merge_Dependencies_Extn(p_entity_code);
820:
821: END IF;
822:

Line 824: oe_debug_pub.add( 'EXITING OE_DEPENDENCIES.LOAD_ENTITY_ATTRIBUTES' , 1 ) ;

820:
821: END IF;
822:
823: IF l_debug_level > 0 THEN
824: oe_debug_pub.add( 'EXITING OE_DEPENDENCIES.LOAD_ENTITY_ATTRIBUTES' , 1 ) ;
825: END IF;
826:
827: END Load_Entity_Attributes;
828:

Line 855: oe_debug_pub.add( 'ENTERING OE_DEPENDENCIES.MARK_DEPENDENT' , 1 ) ;

851: --
852: BEGIN
853:
854: IF l_debug_level > 0 THEN
855: oe_debug_pub.add( 'ENTERING OE_DEPENDENCIES.MARK_DEPENDENT' , 1 ) ;
856: END IF;
857:
858: -- Init l_src_attr_tbl
859:

Line 934: oe_debug_pub.add( 'EXITING OE_DEPENDENCIES.MARK_DEPENDENT' , 1 ) ;

930:
931: END LOOP;
932:
933: IF l_debug_level > 0 THEN
934: oe_debug_pub.add( 'EXITING OE_DEPENDENCIES.MARK_DEPENDENT' , 1 ) ;
935: END IF;
936:
937: END Mark_Dependent;
938:

Line 948: oe_debug_pub.add( 'ENTERING OE_DEPENDENCIES.CLEAR_DEPENDENT_TABLE' , 1 ) ;

944: --
945: BEGIN
946:
947: IF l_debug_level > 0 THEN
948: oe_debug_pub.add( 'ENTERING OE_DEPENDENCIES.CLEAR_DEPENDENT_TABLE' , 1 ) ;
949: END IF;
950:
951: g_dep_tbl.DELETE;
952: g_entity_code := NULL;

Line 955: oe_debug_pub.add( 'EXITING OE_DEPENDENCIES.CLEAR_DEPENDENT_TABLE' , 1 ) ;

951: g_dep_tbl.DELETE;
952: g_entity_code := NULL;
953:
954: IF l_debug_level > 0 THEN
955: oe_debug_pub.add( 'EXITING OE_DEPENDENCIES.CLEAR_DEPENDENT_TABLE' , 1 ) ;
956: END IF;
957:
958: END clear_dependent_table;
959:

Line 961: END OE_Dependencies;

957:
958: END clear_dependent_table;
959:
960:
961: END OE_Dependencies;