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.5.12010000.2 2008/10/30 16:43:22 cpati 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.5.12010000.2 2008/10/30 16:43:22 cpati 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 798: -- to the new extension api - OE_Dependencies_Extn (OEXEDEPS/B.pls)

794: --serla end
795: END IF;
796:
797: -- Merge any dependencies that user wants to enable/disable via call
798: -- to the new extension api - OE_Dependencies_Extn (OEXEDEPS/B.pls)
799: Merge_Dependencies_Extn(p_entity_code);
800:
801: END IF;
802:

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

800:
801: END IF;
802:
803: IF l_debug_level > 0 THEN
804: oe_debug_pub.add( 'EXITING OE_DEPENDENCIES.LOAD_ENTITY_ATTRIBUTES' , 1 ) ;
805: END IF;
806:
807: END Load_Entity_Attributes;
808:

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

831: --
832: BEGIN
833:
834: IF l_debug_level > 0 THEN
835: oe_debug_pub.add( 'ENTERING OE_DEPENDENCIES.MARK_DEPENDENT' , 1 ) ;
836: END IF;
837:
838: -- Init l_src_attr_tbl
839:

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

910:
911: END LOOP;
912:
913: IF l_debug_level > 0 THEN
914: oe_debug_pub.add( 'EXITING OE_DEPENDENCIES.MARK_DEPENDENT' , 1 ) ;
915: END IF;
916:
917: END Mark_Dependent;
918:

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

924: --
925: BEGIN
926:
927: IF l_debug_level > 0 THEN
928: oe_debug_pub.add( 'ENTERING OE_DEPENDENCIES.CLEAR_DEPENDENT_TABLE' , 1 ) ;
929: END IF;
930:
931: g_dep_tbl.DELETE;
932: g_entity_code := NULL;

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

931: g_dep_tbl.DELETE;
932: g_entity_code := NULL;
933:
934: IF l_debug_level > 0 THEN
935: oe_debug_pub.add( 'EXITING OE_DEPENDENCIES.CLEAR_DEPENDENT_TABLE' , 1 ) ;
936: END IF;
937:
938: END clear_dependent_table;
939:

Line 941: END OE_Dependencies;

937:
938: END clear_dependent_table;
939:
940:
941: END OE_Dependencies;