[Home] [Help]
PACKAGE: APPS.OE_ORDER_UTIL
Source
1 PACKAGE OE_ORDER_UTIL AS
2 /* $Header: OEXUORDS.pls 120.1 2006/03/29 16:48:08 spooruli noship $ */
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 -- Globals for Notification Framework
24 -- Global to track Recursion since the regular recursion has some exceptions
25 -- to calls made out of workflow activities and treat them as independent as
26 --oppose to recursive.
27
28 G_Recursion_Without_Exception Varchar2(1) := 'N';
29
30 G_Header_Rec OE_Order_Pub.Header_Rec_Type :=
31 OE_ORDER_PUB.G_MISS_HEADER_REC;
32 G_old_Header_Rec OE_Order_Pub.Header_Rec_Type :=
33 OE_ORDER_PUB.G_MISS_HEADER_REC;
34
35 G_line_tbl OE_Order_PUB.Line_Tbl_Type :=
36 OE_Order_PUB.G_MISS_LINE_TBL;
37 G_old_line_tbl OE_Order_PUB.Line_Tbl_Type :=
38 OE_Order_PUB.G_MISS_LINE_TBL;
39 G_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type :=
40 OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL;
41
42 G_Old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type :=
43 OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL;
44
45 G_Old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type :=
46 OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL;
47
48 G_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type :=
49 OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL;
50
51 G_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type :=
52 OE_Order_PUB.G_MISS_HEADER_ADJ_TBL;
53
54 G_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type :=
55 OE_Order_PUB.G_MISS_HEADER_ADJ_TBL;
56 G_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type :=
57 OE_Order_PUB.G_MISS_LINE_ADJ_TBL;
58 G_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type :=
59 OE_Order_PUB.G_MISS_LINE_ADJ_TBL;
60
61 G_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type :=
62 OE_Order_PUB.G_MISS_LOT_SERIAL_TBL;
63
64 G_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type :=
65 OE_Order_PUB.G_MISS_LOT_SERIAL_TBL;
66
67 PROCEDURE Update_Global_Picture
68 ( p_Upd_New_Rec_If_Exists IN BOOLEAN := TRUE
69 , p_Header_Rec IN OE_Order_Pub.Header_Rec_Type := NULL
70 , p_Line_Rec IN OE_Order_Pub.Line_Rec_Type := NULL
71 , p_Hdr_Scr_Rec IN OE_Order_Pub.Header_Scredit_Rec_Type := NULL
72 , p_Hdr_Adj_Rec IN OE_Order_Pub.Header_Adj_Rec_Type := NULL
73 , p_Line_Adj_Rec IN OE_Order_Pub.Line_Adj_Rec_Type := NULL
74 , p_Line_Scr_Rec IN OE_Order_Pub.Line_Scredit_Rec_Type := NULL
75 , p_Lot_Serial_Rec IN OE_Order_Pub.Lot_Serial_Rec_Type := NULL
76 , p_old_Header_Rec IN OE_Order_Pub.Header_Rec_Type := NULL
77 , p_old_Line_Rec IN OE_Order_Pub.Line_Rec_Type := NULL
78 , p_old_Hdr_Scr_Rec IN OE_Order_Pub.Header_Scredit_Rec_Type := NULL
79 , p_old_Hdr_Adj_Rec IN OE_Order_Pub.Header_Adj_Rec_Type := NULL
80 , p_old_Line_Adj_Rec IN OE_Order_Pub.Line_Adj_Rec_Type := NULL
81 , p_old_Line_Scr_Rec IN OE_Order_Pub.Line_Scredit_Rec_Type := NULL
82 , p_old_Lot_Serial_Rec IN OE_Order_Pub.Lot_Serial_Rec_Type := NULL
83 , p_header_id IN NUMBER := NULL
84 , p_line_id IN NUMBER := NULL
85 , p_hdr_scr_id IN NUMBER := NULL
86 , p_line_scr_id IN NUMBER := NULL
87 , p_hdr_adj_id IN NUMBER := NULL
88 , p_line_adj_id IN NUMBER := NULL
89 , p_lot_serial_id IN NUMBER := NULL
90 , x_index OUT NOCOPY NUMBER
91
92 , x_return_status OUT NOCOPY VARCHAR2
93
94 );
95
96
97
98 PROCEDURE Return_Glb_Ent_Index
99 ( p_entity_code IN VARCHAR2
100 , p_entity_id IN NUMBER
101 , x_index OUT NOCOPY NUMBER
102
103 , x_result OUT NOCOPY VARCHAR2
104
105 , x_return_status OUT NOCOPY VARCHAR2
106
107 );
108
109 /* Use this procedure to initialize the global pl/sql tables */
110
111
112 PROCEDURE Clear_Global_Picture( x_return_status OUT NOCOPY VARCHAR2);
113
114
115
116 PROCEDURE Initialize_Access_List;
117
118 PROCEDURE Add_Access
119 (Function_Name IN VARCHAR2);
120
121 FUNCTION IS_ACTION_IN_ACCESS_LIST
122 (Action_code IN varchar2) RETURN BOOLEAN;
123
124 G_Access_List_Initialized Varchar2(1);
125
126 PROCEDURE Get_Access_List
127 (
128 p_access_List OUT NOCOPY OE_GLOBALS.ACCESS_LIST);
129
130
131
132 G_Curr_Code Varchar2(80);
133
134 G_Header_Id Number;
135
136 G_Line_Id Number;
137
138 G_precision Number;
139
140 Function Get_Precision(
141 p_currency_code IN Varchar2 Default Null,
142 p_header_id IN Number Default Null,
143 p_line_id IN Number Default Null
144 )
145 RETURN BOOLEAN;
146
147 END OE_ORDER_UTIL;