[Home] [Help]
PACKAGE: APPS.OE_HOLDS_PUB
Source
1 PACKAGE OE_Holds_PUB AUTHID CURRENT_USER AS
2 /* $Header: OEXPHLDS.pls 120.10 2011/12/30 03:44:43 slagiset ship $ */
3
4 -- Start of Comments
5 -- API name OE_Holds_PUB
6 -- Type Public
7 -- Version Current version = 1.0
8 -- Initial version = 1.0
9
10 --Changes for bug 2673236 :Begin
11
12 G_PAYMENT_HOLD_APPLIED VARCHAR2(1) :='N'; --ER#7479609
13 G_HDR_PAYMENT VARCHAR2(1) :='N'; --ER#7479609
14
15 TYPE Any_Line_Hold_Rec IS RECORD
16 ( HEADER_ID OE_ORDER_HEADERS.HEADER_ID%TYPE := NULL
17 , HOLD_ID OE_Hold_Sources_ALL.HOLD_ID%TYPE := NULL
18 , HOLD_ENTITY_CODE OE_Hold_Sources_ALL.HOLD_ENTITY_CODE%TYPE := NULL
19 , HOLD_ENTITY_ID OE_Hold_Sources_ALL.HOLD_ENTITY_ID%TYPE := NULL
20 , HOLD_ENTITY_CODE2 OE_Hold_Sources_ALL.HOLD_ENTITY_CODE2%TYPE := NULL
21 , HOLD_ENTITY_ID2 OE_Hold_Sources_ALL.HOLD_ENTITY_ID2%TYPE := NULL
22 , WF_ITEM_TYPE VARCHAR2(30) DEFAULT NULL
23 , WF_ACTIVITY_NAME VARCHAR2(30) DEFAULT NULL
24 , p_chk_act_hold_only VARCHAR2(1) DEFAULT 'N'
25 , x_result_out VARCHAR2(30)
26 );
27
28 -- Check_Any_Line_Hold
29
30 PROCEDURE Check_Any_Line_Hold (
31 x_hold_rec IN OUT NOCOPY OE_Holds_PUB.Any_Line_Hold_Rec
32 , x_return_status OUT NOCOPY VARCHAR2
33 , x_msg_count OUT NOCOPY NUMBER
34 , x_msg_data OUT NOCOPY VARCHAR2
35 );
36
37 --Changes for bug 2673236 :End
38
39 -- Apply Holds
40
41 PROCEDURE Apply_Holds
42 ( p_api_version IN NUMBER
43 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
44 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
45 , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
46 , p_header_id IN NUMBER DEFAULT NULL
47 , p_line_id IN NUMBER DEFAULT NULL
48 , p_hold_source_id IN NUMBER DEFAULT NULL
49 , p_hold_source_rec IN OE_Hold_Sources_Pvt.Hold_Source_REC
50 DEFAULT OE_Hold_Sources_Pvt.G_MISS_Hold_Source_REC
51 , p_check_authorization_flag IN VARCHAR2 DEFAULT 'N' -- bug 8477694
52 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
53 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
54 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
55 );
56
57 -----------------------------------
58 -- New Overloaded APPLY_HOLD API --
59 -----------------------------------
60 Procedure Apply_Holds (
61 p_api_version IN NUMBER,
62 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
63 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
64 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
65 p_order_tbl IN OE_HOLDS_PVT.order_tbl_type,
66 p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE,
67 p_hold_until_date IN OE_HOLD_SOURCES.HOLD_UNTIL_DATE%TYPE DEFAULT NULL,
68 p_hold_comment IN OE_HOLD_SOURCES.HOLD_COMMENT%TYPE DEFAULT NULL,
69 p_check_authorization_flag IN VARCHAR2 DEFAULT 'N', -- bug 8477694
70 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
71 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
72 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 );
73
74 Procedure Apply_Holds(
75 p_api_version IN NUMBER,
76 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
77 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
78 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
79 p_hold_source_rec IN OE_HOLDS_PVT.Hold_Source_Rec_Type
80 DEFAULT OE_HOLDS_PVT.G_MISS_HOLD_SOURCE_REC,
81 p_hold_existing_flg IN VARCHAR2 DEFAULT 'Y',
82 p_hold_future_flg IN VARCHAR2 DEFAULT 'Y',
83 p_check_authorization_flag IN VARCHAR2 DEFAULT 'N', -- bug 8477694
84 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
85 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
86 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 );
87
88
89
90 -- Check Holds
91
92 PROCEDURE Check_Holds
93 ( p_api_version IN NUMBER
94 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
95 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
96 , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
97 , p_header_id IN NUMBER DEFAULT NULL
98 , p_line_id IN NUMBER DEFAULT NULL
99 , p_hold_id IN NUMBER DEFAULT NULL
100 , p_wf_item IN VARCHAR2 DEFAULT NULL
101 , p_wf_activity IN VARCHAR2 DEFAULT NULL
102 , p_entity_code IN VARCHAR2 DEFAULT NULL
103 --ER#7479609, p_entity_id IN NUMBER DEFAULT NULL
104 , p_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE DEFAULT NULL --ER#7479609
105 , p_entity_code2 IN VARCHAR2 DEFAULT NULL
106 --ER#7479609, p_entity_id2 IN NUMBER DEFAULT NULL
107 , p_entity_id2 IN oe_hold_sources_all.hold_entity_id2%TYPE DEFAULT NULL --ER#7479609
108 , p_chk_act_hold_only IN VARCHAR2 DEFAULT 'N'
109 , x_result_out OUT NOCOPY /* file.sql.39 change */ VARCHAR2
110 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
111 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
112 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
113 );
114
115 /* Added 12-15-2005. see bug#4888425 */
116 PROCEDURE Check_Holds_line (
117 p_hdr_id IN NUMBER
118 , p_line_id IN NUMBER DEFAULT NULL
119 , p_hold_id IN NUMBER DEFAULT NULL
120 , p_wf_item IN VARCHAR2 DEFAULT NULL
121 , p_wf_activity IN VARCHAR2 DEFAULT NULL
122 , p_entity_code IN VARCHAR2 DEFAULT NULL
123 --ER#7479609, p_entity_id IN NUMBER DEFAULT NULL
124 , p_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE DEFAULT NULL --ER#7479609
125 , p_entity_code2 IN VARCHAR2 DEFAULT NULL
126 --ER#7479609, p_entity_id2 IN NUMBER DEFAULT NULL
127 , p_entity_id2 IN oe_hold_sources_all.hold_entity_id2%TYPE DEFAULT NULL --ER#7479609
128 , p_chk_act_hold_only IN VARCHAR2 DEFAULT 'N'
129 , p_ii_parent_flag IN VARCHAR2 DEFAULT 'N'
130 , x_result_out OUT NOCOPY /* file.sql.39 change */ VARCHAR2
131 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
132 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
133 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
134 );
135
136 PROCEDURE Check_Hold_Sources
137 ( p_api_version IN NUMBER
138 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
139 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
140 , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
141 , p_hold_id IN NUMBER DEFAULT NULL
142 , p_wf_item IN VARCHAR2 DEFAULT NULL
143 , p_wf_activity IN VARCHAR2 DEFAULT NULL
144 , p_hold_entity_code IN VARCHAR2 DEFAULT NULL
145 --ER#7479609 , p_hold_entity_id IN NUMBER DEFAULT NULL
146 , p_hold_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE DEFAULT NULL --ER#7479609
147 , p_hold_entity_code2 IN VARCHAR2 DEFAULT NULL
148 --ER#7479609 , p_hold_entity_id2 IN NUMBER DEFAULT NULL
149 , p_hold_entity_id2 IN oe_hold_sources_all.hold_entity_id2%TYPE DEFAULT NULL --ER#7479609
150 , p_chk_act_hold_only IN VARCHAR2 DEFAULT 'N'
151 , x_result_out OUT NOCOPY /* file.sql.39 change */ VARCHAR2
152 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
153 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
154 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
155 );
156
157 -- Release Holds
158
159 PROCEDURE Release_Holds
160 ( p_api_version IN NUMBER DEFAULT 1.0
161 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
162 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
163 , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
164 , p_header_id IN NUMBER DEFAULT NULL
165 , p_line_id IN NUMBER DEFAULT NULL
166 , p_hold_id IN NUMBER DEFAULT NULL
167 , p_entity_code IN VARCHAR2 DEFAULT NULL
168 , p_entity_id IN NUMBER DEFAULT NULL
169 , p_entity_code2 IN VARCHAR2 DEFAULT NULL
170 , p_entity_id2 IN NUMBER DEFAULT NULL
171 , p_hold_release_rec IN OE_Hold_Sources_Pvt.Hold_Release_REC
172 , p_check_authorization_flag IN VARCHAR2 DEFAULT 'N' -- bug 8477694
173 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
174 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
175 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
176 );
177
178
179 ------------------------------------
180 -- New Release Holds API --
181 ------------------------------------
182 Procedure Release_Holds (
183 p_api_version IN NUMBER DEFAULT 1.0,
184 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
185 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
186 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
187 p_hold_source_rec IN OE_HOLDS_PVT.hold_source_rec_type,
188 p_hold_release_rec IN OE_HOLDS_PVT.Hold_Release_Rec_Type,
189 p_check_authorization_flag IN VARCHAR2 DEFAULT 'N', -- bug 8477694
190 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
191 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
192 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
193
194 Procedure Release_Holds (
195 p_api_version IN NUMBER DEFAULT 1.0,
196 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
197 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
198 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
199 p_order_tbl IN OE_HOLDS_PVT.order_tbl_type,
200 p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE DEFAULT NULL,
201 p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE,
202 p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE
203 DEFAULT NULL,
204 p_check_authorization_flag IN VARCHAR2 DEFAULT 'N', -- bug 8477694
205 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
206 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
207 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
208
209 -- Delete Holds
210
211 PROCEDURE Delete_Holds
212 ( p_header_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
213 , p_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
214 );
215
216
217
218 PROCEDURE evaluate_holds( p_entity_code IN VARCHAR2
219 , p_entity_id IN NUMBER
220 , p_hold_entity_code IN VARCHAR2
221 --ER#7479609 , p_hold_entity_id IN NUMBER
222 , p_hold_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE --ER#7479609
223 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
224 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
225 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
226 );
227 PROCEDURE evaluate_holds_post_write
228 ( p_entity_code IN VARCHAR2
229 , p_entity_id IN NUMBER
230 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
231 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
232 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
233 );
234
235 PROCEDURE eval_post_write_header
236 ( p_entity_code IN VARCHAR2
237 , p_entity_id IN NUMBER
238 , p_hold_entity_code IN VARCHAR2
239 --ER#7479609 , p_hold_entity_id IN NUMBER
240 , p_hold_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE --ER#7479609
241 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
242 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
243 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
244 );
245
246
247 PROCEDURE RELEASE_EXPIRED_HOLDS
248 (
249 p_dummy1 OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
250 p_dummy2 OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
251 p_org_id IN NUMBER
252 );
253
254 PROCEDURE UPDATE_HOLD_COMMENTS (
255 p_hold_source_rec IN OE_HOLDS_PVT.Hold_Source_Rec_Type,
256 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
257 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
258 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 );
259
260
261 -- For customer global holds
262
263 PROCEDURE Process_Holds
264 ( p_api_version IN NUMBER
265 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
266 , p_hold_entity_code IN VARCHAR2
267 --ER#7479609 , p_hold_entity_id IN NUMBER
268 , p_hold_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE --ER#7479609
269 , p_hold_id IN NUMBER DEFAULT 1
270 , p_release_reason_code IN VARCHAR2 DEFAULT NULL
271 , p_action IN VARCHAR2
272 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
273 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
274 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
275 );
276
277 --ER 12363706 start
278
279 FUNCTION Hold_exists
280 ( p_hold_entity_code IN VARCHAR2
281 , p_hold_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE --ER#7479609
282 , p_hold_id IN NUMBER DEFAULT 1
283 , p_org_id IN NUMBER DEFAULT NULL
284 )
285 RETURN boolean;
286
287 --ER 12363706 end
288
289
290 END OE_Holds_PUB;