[Home] [Help]
PACKAGE: APPS.OE_ORDER_UTIL
Source
1 PACKAGE OE_ORDER_UTIL AUTHID CURRENT_USER AS
2 /* $Header: OEXUORDS.pls 120.2.12020000.3 2013/01/04 04:36:45 slagiset ship $ */
3
4 -- GET_ATTRIBUTE_NAME
5 -- Returns the translated display name of the attribute from the AK
6 -- dictionary based on the attribute code
7 -- Use this function to resolve message tokens that display attribute
8 -- names.
9 FUNCTION GET_ATTRIBUTE_NAME
10 ( p_attribute_code IN VARCHAR2
11 )
12 RETURN VARCHAR2;
13
14 -- LOCK_ORDER_OBJECT
15 -- Locks the order object: order header, lines, sales credits and
16 -- price adjustments belonging to that order
17 PROCEDURE LOCK_ORDER_OBJECT
18 (p_header_id IN NUMBER
19 ,x_return_status OUT NOCOPY VARCHAR2
20
21 );
22
23 -- this type is defined for 13536089
24 TYPE nameVal_Rec_Type IS RECORD
25 ( name varchar2(200),
26 value varchar2(200)
27 );
28 -- this table type is created for 13536089
29 TYPE nameVal_Tbl_Type IS TABLE OF nameVal_Rec_Type
30 INDEX BY BINARY_INTEGER;
31
32 -- Globals for Notification Framework
33 -- Global to track Recursion since the regular recursion has some exceptions
34 -- to calls made out of workflow activities and treat them as independent as
35 --oppose to recursive.
36
37 G_Recursion_Without_Exception Varchar2(1) := 'N';
38
39 G_nameVal_Tbl nameVal_Tbl_Type ; -- added for 13536089
40
41 G_Header_Rec OE_Order_Pub.Header_Rec_Type :=
42 OE_ORDER_PUB.G_MISS_HEADER_REC;
43 G_old_Header_Rec OE_Order_Pub.Header_Rec_Type :=
44 OE_ORDER_PUB.G_MISS_HEADER_REC;
45
46 G_line_tbl OE_Order_PUB.Line_Tbl_Type :=
47 OE_Order_PUB.G_MISS_LINE_TBL;
48 G_old_line_tbl OE_Order_PUB.Line_Tbl_Type :=
49 OE_Order_PUB.G_MISS_LINE_TBL;
50 G_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type :=
51 OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL;
52
53 G_Old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type :=
54 OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL;
55
56 G_Old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type :=
57 OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL;
58
59 G_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type :=
60 OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL;
61
62 G_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type :=
63 OE_Order_PUB.G_MISS_HEADER_ADJ_TBL;
64
65 G_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type :=
66 OE_Order_PUB.G_MISS_HEADER_ADJ_TBL;
67 G_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type :=
68 OE_Order_PUB.G_MISS_LINE_ADJ_TBL;
69 G_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type :=
70 OE_Order_PUB.G_MISS_LINE_ADJ_TBL;
71
72 G_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type :=
73 OE_Order_PUB.G_MISS_LOT_SERIAL_TBL;
74
75 G_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type :=
76 OE_Order_PUB.G_MISS_LOT_SERIAL_TBL;
77
78 PROCEDURE Update_Global_Picture
79 ( p_Upd_New_Rec_If_Exists IN BOOLEAN := TRUE
80 , p_Header_Rec IN OE_Order_Pub.Header_Rec_Type := NULL
81 , p_Line_Rec IN OE_Order_Pub.Line_Rec_Type := NULL
82 , p_Hdr_Scr_Rec IN OE_Order_Pub.Header_Scredit_Rec_Type := NULL
83 , p_Hdr_Adj_Rec IN OE_Order_Pub.Header_Adj_Rec_Type := NULL
84 , p_Line_Adj_Rec IN OE_Order_Pub.Line_Adj_Rec_Type := NULL
85 , p_Line_Scr_Rec IN OE_Order_Pub.Line_Scredit_Rec_Type := NULL
86 , p_Lot_Serial_Rec IN OE_Order_Pub.Lot_Serial_Rec_Type := NULL
87 , p_old_Header_Rec IN OE_Order_Pub.Header_Rec_Type := NULL
88 , p_old_Line_Rec IN OE_Order_Pub.Line_Rec_Type := NULL
89 , p_old_Hdr_Scr_Rec IN OE_Order_Pub.Header_Scredit_Rec_Type := NULL
90 , p_old_Hdr_Adj_Rec IN OE_Order_Pub.Header_Adj_Rec_Type := NULL
91 , p_old_Line_Adj_Rec IN OE_Order_Pub.Line_Adj_Rec_Type := NULL
92 , p_old_Line_Scr_Rec IN OE_Order_Pub.Line_Scredit_Rec_Type := NULL
93 , p_old_Lot_Serial_Rec IN OE_Order_Pub.Lot_Serial_Rec_Type := NULL
94 , p_header_id IN NUMBER := NULL
95 , p_line_id IN NUMBER := NULL
96 , p_hdr_scr_id IN NUMBER := NULL
97 , p_line_scr_id IN NUMBER := NULL
98 , p_hdr_adj_id IN NUMBER := NULL
99 , p_line_adj_id IN NUMBER := NULL
100 , p_lot_serial_id IN NUMBER := NULL
101 , x_index OUT NOCOPY NUMBER
102
103 , x_return_status OUT NOCOPY VARCHAR2
104
105 );
106
107
108
109 PROCEDURE Return_Glb_Ent_Index
110 ( p_entity_code IN VARCHAR2
111 , p_entity_id IN NUMBER
112 , x_index OUT NOCOPY NUMBER
113
114 , x_result OUT NOCOPY VARCHAR2
115
116 , x_return_status OUT NOCOPY VARCHAR2
117
118 );
119
120 /* Use this procedure to initialize the global pl/sql tables */
121
122
123 PROCEDURE Clear_Global_Picture( x_return_status OUT NOCOPY VARCHAR2);
124
125
126
127 PROCEDURE Initialize_Access_List;
128
129 PROCEDURE Add_Access
130 (Function_Name IN VARCHAR2);
131
132 FUNCTION IS_ACTION_IN_ACCESS_LIST
133 (Action_code IN varchar2) RETURN BOOLEAN;
134
135 G_Access_List_Initialized Varchar2(1);
136
137 PROCEDURE Get_Access_List
138 (
139 p_access_List OUT NOCOPY OE_GLOBALS.ACCESS_LIST);
140
141
142
143 G_Curr_Code Varchar2(80);
144
145 G_Header_Id Number;
146
147 G_Line_Id Number;
148
149 G_precision Number;
150
151 Function Get_Precision(
152 p_currency_code IN Varchar2 Default Null,
153 p_header_id IN Number Default Null,
154 p_line_id IN Number Default Null
155 )
156 RETURN BOOLEAN;
157
158 --OIP SUN ER CHANGES
159 -- Adding parameter nameVal_Tbl_Type for bug 13536089
160 PROCEDURE RAISE_BUSINESS_EVENT(
161 p_header_id IN Number Default Null,
162 p_line_id IN Number Default Null,
163 p_status IN Varchar2 Default Null,
164 p_event_name IN varchar2 Default Null, -- added for bug 13536089
165 p_nameVal_tbl in nameVal_Tbl_Type:=G_nameVal_tbl -- added for 13536089
166 );
167 --End of OIP SUN ER CHANGES
168
169 -- 13633317
170 FUNCTION GET_GLOBAL_OLD_HEADER_ID
171 RETURN NUMBER;
172
173 END OE_ORDER_UTIL;