1 PACKAGE BODY OE_Dependencies_Extn AS
2 /* $Header: OEXEDEPB.pls 120.1 2006/04/03 11:33:12 chhung noship $ */
3
4 -- Global constant holding the package name
5
6 G_PKG_NAME CONSTANT VARCHAR2(30):='OE_Dependencies_Extn';
7
8
9 PROCEDURE Load_Entity_Attributes
10 ( p_entity_code IN VARCHAR2
11 , x_extn_dep_tbl OUT NOCOPY Dep_Tbl_Type)
12
13 IS
14 l_index NUMBER;
15 --
16 l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
17 --
18 BEGIN
19
20 null;
21
22 /*
23 -- In order to start using the package:
24 -- 1)Increase the version number in the header line to a high value
25 -- => Header: OEXEDEPB.pls 115.1000. This would prevent patches
26 -- from over-writing this package in the future.
27 -- 2)Included are some examples on how to enable/disable dependencies
28 -- Please use these guidelines to edit dependencies as per your
29 -- defaulting rules. Please note that:
30 -- i) List of attributes is restricted to those in the earlier
31 -- comments in this file.
32 -- ii) Source attribute and dependent attribute should belong
33 -- to the same entity!
34 -- This API does not support dependencies across entities i.e.
35 -- changing an attribute on order header will not result in
36 -- a change to attributes on order line.
37 -- 3)Uncomment this code and compile.
38
39 oe_debug_pub.add('Enter OE_Dependencies_Extn.LOAD_ENTITY_ATTRIBUTES', 1);
40
41 -- Initializing index value for pl/sql table. Ensure that the index
42 -- value is incremented after setting each dependency record.
43 l_index := 1;
44
45 -- Dependencies for Order Header Entity
46 IF p_entity_code = OE_GLOBALS.G_ENTITY_HEADER THEN
47
48 null;
49
50 -- Sample Code for Disabling dependency of Invoice To on Ship To
51 -- x_extn_dep_tbl(l_index).source_attribute := OE_HEADER_UTIL.G_SHIP_TO_ORG;
52 -- x_extn_dep_tbl(l_index).dependent_attribute := OE_HEADER_UTIL.G_INVOICE_TO_ORG;
53 -- x_extn_dep_tbl(l_index).enabled_flag := 'N';
54 -- l_index := l_index + 1;
55
56 -- Dependencies for Order Line Entity
57 ELSIF p_entity_code = OE_GLOBALS.G_ENTITY_LINE THEN
58
59 null;
60
61 -- Sample Code for Disabling dependency of Invoice To on Ship To
62 -- x_extn_dep_tbl(l_index).source_attribute := OE_LINE_UTIL.G_SHIP_TO_ORG;
63 -- x_extn_dep_tbl(l_index).dependent_attribute := OE_LINE_UTIL.G_INVOICE_TO_ORG;
64 -- x_extn_dep_tbl(l_index).enabled_flag := 'N';
65 -- l_index := l_index + 1;
66
67 -- Sample Code for adding dependency of Source Type on Item
68 -- x_extn_dep_tbl(l_index).source_attribute := OE_LINE_UTIL.G_INVENTORY_ITEM;
69 -- x_extn_dep_tbl(l_index).dependent_attribute := OE_LINE_UTIL.G_SOURCE_TYPE;
70 -- x_extn_dep_tbl(l_index).enabled_flag := 'Y';
71 -- l_index := l_index + 1;
72
73 END IF;
74
75 oe_debug_pub.add('Exit OE_Dependencies_Extn.LOAD_ENTITY_ATTRIBUTES', 1);
76 */
77
78 EXCEPTION
79 WHEN OTHERS THEN
80 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
81 THEN
82 OE_MSG_PUB.Add_Exc_Msg
83 ( G_PKG_NAME
84 , 'Load_Entity_Attributes'
85 );
86 END IF;
87 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
88 END Load_Entity_Attributes;
89
90 END OE_Dependencies_Extn;