[Home] [Help]
PACKAGE: APPS.OE_BLANKET_UTIL
Source
1 PACKAGE OE_Blanket_util AUTHID CURRENT_USER AS
2 /* $Header: OEXUBSOS.pls 120.4.12020000.1 2012/06/26 09:22:39 appldev ship $ */
3
4 G_Header_Rec OE_Blanket_PUB.Header_rec_type ;
5 G_Request_Tbl oe_blanket_pub.Request_Tbl_Type ;
6 g_old_header_hist_rec OE_Blanket_PUB.Header_rec_type ;
7 g_old_line_hist_tbl OE_Blanket_PUB.line_tbl_type ;
8 g_old_version_captured BOOLEAN := FALSE;
9
10 -- 11i10 Pricing Change
11 -- Move globals to package spec.
12 g_line_id_tbl OE_BLANKET_PUB.line_tbl_type;
13 g_new_price_list boolean := false ;
14 g_new_modifier_list BOOLEAN := FALSE;
15
16 -- CustomerRelationship Support for BSA
17 g_customer_relations VARCHAR2(1) := NVL(OE_SYS_PARAMETERS.VALUE('CUSTOMER_RELATIONSHIPS_FLAG'), 'N');
18
19 PROCEDURE Validate_Attributes
20 ( p_x_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type
21 , p_old_header_rec IN OE_Blanket_PUB.Header_rec_type
22 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
23 , x_return_status OUT NOCOPY VARCHAR2
24 );
25
26 PROCEDURE Validate_Attributes
27 ( p_x_line_rec IN OUT NOCOPY OE_Blanket_PUB.line_rec_type
28 , p_old_line_rec IN OE_Blanket_PUB.line_rec_type
29 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
30 , x_return_status OUT NOCOPY VARCHAR2
31 );
32
33 PROCEDURE Validate_Entity
34 ( p_line_rec IN OUT NOCOPY OE_Blanket_PUB.line_rec_type
35 , p_old_line_rec IN OE_Blanket_PUB.Line_rec_type :=
36 OE_Blanket_PUB.G_MISS_BLANKET_LINE_REC
37 , x_return_status OUT NOCOPY VARCHAR2
38 );
39
40 PROCEDURE Validate_Entity
41 ( p_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type
42 , p_old_header_rec IN OE_Blanket_PUB.Header_rec_type :=
43 OE_Blanket_PUB.G_MISS_HEADER_REC
44 , x_return_status OUT NOCOPY VARCHAR2
45 );
46
47
48 PROCEDURE Insert_Row
49 ( p_header_rec IN OE_Blanket_PUB.Header_rec_type
50 , x_return_status OUT NOCOPY VARCHAR2
51 );
52
53 PROCEDURE Update_Row
54 ( p_header_rec IN OE_Blanket_PUB.Header_rec_type
55 , x_return_status OUT NOCOPY VARCHAR2
56 );
57
58 PROCEDURE Delete_Row
59 ( p_header_id IN NUMBER
60 , x_return_status OUT NOCOPY VARCHAR2
61 );
62
63 PROCEDURE Insert_Row
64 (p_line_rec IN OE_BLANKET_PUB.Line_Rec_Type
65 , x_return_status OUT NOCOPY VARCHAR2
66 );
67
68 PROCEDURE Update_Row
69 ( p_line_rec IN OE_Blanket_PUB.Line_rec_type
70 , x_return_status OUT NOCOPY VARCHAR2
71 );
72
73 PROCEDURE Delete_Row
74 ( p_line_id IN NUMBER
75 , x_return_status OUT NOCOPY VARCHAR2
76 );
77
78
79 PROCEDURE Query_Header
80 ( p_header_id IN NUMBER
81 , p_version_number IN NUMBER := NULL
82 , p_phase_change_flag IN VARCHAR2 := NULL
83 , x_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type
84 , x_return_status OUT NOCOPY VARCHAR2
85 );
86
87 PROCEDURE Query_Lines
88 ( p_line_id IN NUMBER := NULL
89 , p_header_id IN NUMBER := NULL
90 , p_version_number IN NUMBER := NULL
91 , p_phase_change_flag IN VARCHAR2 := NULL
92 , x_line_tbl IN OUT NOCOPY OE_Blanket_PUB.line_tbl_type
93 , x_return_status OUT NOCOPY VARCHAR2
94 );
95
96 PROCEDURE Query_blanket
97 ( p_header_id IN NUMBER
98 , p_version_number IN NUMBER := NULL
99 , p_phase_change_flag IN VARCHAR2 := NULL
100 , p_x_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type
101 , p_x_line_tbl IN OUT NOCOPY OE_Blanket_PUB.line_tbl_type
102 , x_return_status OUT NOCOPY VARCHAR2
103 );
104
105 FUNCTION Query_Row
106 ( p_line_id NUMBER
107 , p_version_number IN NUMBER := NULL
108 , p_phase_change_flag IN VARCHAR2 := NULL
109 ) RETURN OE_Blanket_PUB.Line_Rec_Type;
110
111 PROCEDURE Lock_Row
112 ( x_return_status OUT NOCOPY VARCHAR2
113 , p_blanket_id IN NUMBER
114 , p_blanket_line_id IN NUMBER
115 , p_x_lock_control IN OUT NOCOPY NUMBER
116 , x_msg_count OUT NOCOPY NUMBER
117 , x_msg_data OUT NOCOPY VARCHAR2
118 );
119
120 PROCEDURE Default_Attributes
121 (p_x_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type
122 , x_return_status OUT NOCOPY VARCHAR2
123 );
124
125 PROCEDURE Default_Attributes
126 (p_x_line_rec IN OUT NOCOPY OE_Blanket_PUB.line_rec_type
127 , p_default_from_header IN BOOLEAN
128 , x_return_status OUT NOCOPY VARCHAR2
129 );
130
131 Procedure Load_Header(p_header_id IN NUMBER
132 , x_return_status OUT NOCOPY VARCHAR2
133 );
134
135 PROCEDURE get_order_number(
136 p_x_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type,
137 x_return_status OUT NOCOPY varchar2 );
138
139 PROCEDURE Process_Object(x_return_status OUT NOCOPY varchar2) ;
140
141 PROCEDURE VALIDATE_LINE_NUMBER( p_req_ind IN NUMBER
142 , x_return_status OUT NOCOPY VARCHAR2
143 );
144 PROCEDURE VALIDATE_ITEM_UNIQUENESS( p_req_ind IN NUMBER
145 , x_return_status OUT NOCOPY VARCHAR2
146 );
147
148 Procedure create_price_list(
149 p_index in NUMBER,
150 x_return_status OUT NOCOPY varchar2);
151 Procedure Add_price_list_line(p_req_ind IN NUMBER,
152 x_return_status OUT NOCOPY varchar2);
153 --for bug 3309427
154 Procedure Clear_price_list_line(p_req_ind IN NUMBER,
155 x_return_status OUT NOCOPY varchar2);
156
157 FUNCTION IS_BLANKET_PRICE_LIST(p_price_list_id NUMBER
158 -- 11i10 Pricing Change
159 ,p_blanket_header_id NUMBER DEFAULT NULL)
160 RETURN BOOLEAN;
161
162 PROCEDURE RECORD_BLANKET_HISTORY(p_version_flag in varchar2 := null,
163 p_phase_change_flag in varchar2 := null,
164 X_return_status out nocopy varchar2);
165
166 Procedure Copy_Blanket (p_header_id IN NUMBER,
167 p_version_number IN NUMBER,
168 x_header_id OUT NOCOPY NUMBER,
169 x_return_status OUT NOCOPY VARCHAR2,
170 x_msg_count OUT NOCOPY NUMBER,
171 x_msg_data OUT NOCOPY VARCHAR2);
172
173 Procedure Return_Lines_Exist( p_application_id IN NUMBER,
174 p_entity_short_name in VARCHAR2,
175 p_validation_entity_short_name in VARCHAR2,
176 p_validation_tmplt_short_name in VARCHAR2,
177 p_record_set_tmplt_short_name in VARCHAR2,
178 p_scope in VARCHAR2,
179 p_result OUT NOCOPY NUMBER );
180
181 Procedure Release_Lines_Exist( p_application_id IN NUMBER,
182 p_entity_short_name in VARCHAR2,
183 p_validation_entity_short_name in VARCHAR2,
184 p_validation_tmplt_short_name in VARCHAR2,
185 p_record_set_tmplt_short_name in VARCHAR2,
186 p_scope in VARCHAR2,
187 p_result OUT NOCOPY NUMBER );
188
189 Procedure Release_Headers_Exist( p_application_id IN NUMBER,
190 p_entity_short_name in VARCHAR2,
191 p_validation_entity_short_name in VARCHAR2,
192 p_validation_tmplt_short_name in VARCHAR2,
193 p_record_set_tmplt_short_name in VARCHAR2,
194 p_scope in VARCHAR2,
195 p_result OUT NOCOPY NUMBER );
196
197 Procedure Open_Release_Lines_Exist( p_application_id IN NUMBER,
198 p_entity_short_name in VARCHAR2,
199 p_validation_entity_short_name in VARCHAR2,
200 p_validation_tmplt_short_name in VARCHAR2,
201 p_record_set_tmplt_short_name in VARCHAR2,
202 p_scope in VARCHAR2,
203 p_result OUT NOCOPY NUMBER );
204
205 Procedure Open_Release_Headers_Exist( p_application_id IN NUMBER,
206 p_entity_short_name in VARCHAR2,
207 p_validation_entity_short_name in VARCHAR2,
208 p_validation_tmplt_short_name in VARCHAR2,
209 p_record_set_tmplt_short_name in VARCHAR2,
210 p_scope in VARCHAR2,
211 p_result OUT NOCOPY NUMBER );
212
213 Procedure Is_Expired( p_application_id IN NUMBER,
214 p_entity_short_name in VARCHAR2,
215 p_validation_entity_short_name in VARCHAR2,
216 p_validation_tmplt_short_name in VARCHAR2,
217 p_record_set_tmplt_short_name in VARCHAR2,
218 p_scope in VARCHAR2,
219 p_result OUT NOCOPY NUMBER );
220
221 Procedure IS_Batch_Call( p_application_id IN NUMBER,
222 p_entity_short_name in VARCHAR2,
223 p_validation_entity_short_name in VARCHAR2,
224 p_validation_tmplt_short_name in VARCHAR2,
225 p_record_set_tmplt_short_name in VARCHAR2,
226 p_scope in VARCHAR2,
227 p_result OUT NOCOPY NUMBER );
228 -- Function to initialize view%rowtype record
229
230 FUNCTION G_MISS_OE_AK_BLKT_HEADER_REC
231 RETURN OE_AK_BLANKET_HEADERS_V%ROWTYPE;
232
233 -- Procedure API_Rec_To_Rowtype_Rec
234
235 PROCEDURE API_Rec_To_Rowtype_Rec
236 ( p_HEADER_rec IN OE_Blanket_PUB.HEADER_Rec_Type
237 , x_rowtype_rec IN OUT NOCOPY OE_AK_BLANKET_HEADERS_V%ROWTYPE
238 );
239
240 -- Procedure Rowtype_Rec_To_API_Rec
241
242 PROCEDURE Rowtype_Rec_To_API_Rec
243 ( p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
244 , x_api_rec IN OUT NOCOPY OE_Blanket_PUB.HEADER_Rec_Type
245 );
246
247 -- Function to initialize view%rowtype record
248
249 FUNCTION G_MISS_OE_AK_BLKT_LINE_REC
250 RETURN OE_AK_BLANKET_LINES_V%ROWTYPE;
251
252 -- Procedure API_Rec_To_Rowtype_Rec
253
254 PROCEDURE Line_API_Rec_To_Rowtype_Rec
255 ( p_LINE_rec IN OE_Blanket_PUB.LINE_Rec_Type
256 , x_rowtype_rec IN OUT NOCOPY OE_AK_BLANKET_LINES_V%ROWTYPE
257 );
258
259 -- Procedure Rowtype_Rec_To_API_Rec
260
261 PROCEDURE Line_Rowtype_Rec_To_API_Rec
262 ( p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
263 , x_api_rec IN OUT NOCOPY OE_Blanket_PUB.LINE_Rec_Type
264 );
265
266 Procedure Get_Inventory_Item
267 ( p_x_line_rec IN OUT NOCOPY OE_Blanket_Pub.Line_Rec_Type
268 ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
269 );
270 --Introduced as a part of the bug #4447494
271 PROCEDURE validate_sold_to
272 ( p_header_id IN NUMBER,
273 p_sold_to_org_id IN NUMBER,
274 x_return_status OUT NOCOPY VARCHAR2);
275 -- New procedure added for 5528599
276 PROCEDURE valid_blanket_dates
277 ( p_header_id IN NUMBER,
278 x_return_status OUT NOCOPY VARCHAR2,
279 x_msg_count OUT NOCOPY NUMBER,
280 x_msg_data OUT NOCOPY VARCHAR2);
281 -- New procedure added for 5528599
282 END OE_Blanket_UTIL;