[Home] [Help]
PACKAGE: APPS.OE_HOLDS_PUB
Source
1 PACKAGE OE_Holds_PUB AS
2 /* $Header: OEXPHLDS.pls 120.5.12010000.4 2008/11/12 06:57:56 cpati 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 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
52 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
53 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
54 );
55
56 -----------------------------------
57 -- New Overloaded APPLY_HOLD API --
58 -----------------------------------
59 Procedure Apply_Holds (
60 p_api_version IN NUMBER,
61 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
62 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
63 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
64 p_order_tbl IN OE_HOLDS_PVT.order_tbl_type,
65 p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE,
66 p_hold_until_date IN OE_HOLD_SOURCES.HOLD_UNTIL_DATE%TYPE DEFAULT NULL,
67 p_hold_comment IN OE_HOLD_SOURCES.HOLD_COMMENT%TYPE DEFAULT NULL,
68 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
69 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
70 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 );
71
72 Procedure Apply_Holds(
73 p_api_version IN NUMBER,
74 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
75 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
76 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
77 p_hold_source_rec IN OE_HOLDS_PVT.Hold_Source_Rec_Type
78 DEFAULT OE_HOLDS_PVT.G_MISS_HOLD_SOURCE_REC,
79 p_hold_existing_flg IN VARCHAR2 DEFAULT 'Y',
80 p_hold_future_flg IN VARCHAR2 DEFAULT 'Y',
81 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
82 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
83 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 );
84
85
86
87 -- Check Holds
88
89 PROCEDURE Check_Holds
90 ( p_api_version IN NUMBER
91 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
92 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
93 , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
94 , p_header_id IN NUMBER DEFAULT NULL
95 , p_line_id IN NUMBER DEFAULT NULL
96 , p_hold_id IN NUMBER DEFAULT NULL
97 , p_wf_item IN VARCHAR2 DEFAULT NULL
98 , p_wf_activity IN VARCHAR2 DEFAULT NULL
99 , p_entity_code IN VARCHAR2 DEFAULT NULL
100 --ER#7479609, p_entity_id IN NUMBER DEFAULT NULL
101 , p_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE DEFAULT NULL --ER#7479609
102 , p_entity_code2 IN VARCHAR2 DEFAULT NULL
103 --ER#7479609, p_entity_id2 IN NUMBER DEFAULT NULL
104 , p_entity_id2 IN oe_hold_sources_all.hold_entity_id2%TYPE DEFAULT NULL --ER#7479609
105 , p_chk_act_hold_only IN VARCHAR2 DEFAULT 'N'
106 , x_result_out OUT NOCOPY /* file.sql.39 change */ VARCHAR2
107 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
108 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
109 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
110 );
111
112 /* Added 12-15-2005. see bug#4888425 */
113 PROCEDURE Check_Holds_line (
114 p_hdr_id IN NUMBER
115 , p_line_id IN NUMBER DEFAULT NULL
116 , p_hold_id IN NUMBER DEFAULT NULL
117 , p_wf_item IN VARCHAR2 DEFAULT NULL
118 , p_wf_activity IN VARCHAR2 DEFAULT NULL
119 , p_entity_code IN VARCHAR2 DEFAULT NULL
120 --ER#7479609, p_entity_id IN NUMBER DEFAULT NULL
121 , p_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE DEFAULT NULL --ER#7479609
122 , p_entity_code2 IN VARCHAR2 DEFAULT NULL
123 --ER#7479609, p_entity_id2 IN NUMBER DEFAULT NULL
124 , p_entity_id2 IN oe_hold_sources_all.hold_entity_id2%TYPE DEFAULT NULL --ER#7479609
125 , p_chk_act_hold_only IN VARCHAR2 DEFAULT 'N'
126 , p_ii_parent_flag IN VARCHAR2 DEFAULT 'N'
127 , x_result_out OUT NOCOPY /* file.sql.39 change */ VARCHAR2
128 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
129 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
130 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
131 );
132
133 PROCEDURE Check_Hold_Sources
134 ( p_api_version IN NUMBER
135 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
136 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
137 , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
138 , p_hold_id IN NUMBER DEFAULT NULL
139 , p_wf_item IN VARCHAR2 DEFAULT NULL
140 , p_wf_activity IN VARCHAR2 DEFAULT NULL
141 , p_hold_entity_code IN VARCHAR2 DEFAULT NULL
142 --ER#7479609 , p_hold_entity_id IN NUMBER DEFAULT NULL
143 , p_hold_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE DEFAULT NULL --ER#7479609
144 , p_hold_entity_code2 IN VARCHAR2 DEFAULT NULL
145 --ER#7479609 , p_hold_entity_id2 IN NUMBER DEFAULT NULL
146 , p_hold_entity_id2 IN oe_hold_sources_all.hold_entity_id2%TYPE DEFAULT NULL --ER#7479609
147 , p_chk_act_hold_only IN VARCHAR2 DEFAULT 'N'
148 , x_result_out OUT NOCOPY /* file.sql.39 change */ VARCHAR2
149 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
150 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
151 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
152 );
153
154 -- Release Holds
155
156 PROCEDURE Release_Holds
157 ( p_api_version IN NUMBER DEFAULT 1.0
158 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
159 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
160 , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
161 , p_header_id IN NUMBER DEFAULT NULL
162 , p_line_id IN NUMBER DEFAULT NULL
163 , p_hold_id IN NUMBER DEFAULT NULL
164 , p_entity_code IN VARCHAR2 DEFAULT NULL
165 , p_entity_id IN NUMBER DEFAULT NULL
166 , p_entity_code2 IN VARCHAR2 DEFAULT NULL
167 , p_entity_id2 IN NUMBER DEFAULT NULL
168 , p_hold_release_rec IN OE_Hold_Sources_Pvt.Hold_Release_REC
169 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
170 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
171 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
172 );
173
174
175 ------------------------------------
176 -- New Release Holds API --
177 ------------------------------------
178 Procedure Release_Holds (
179 p_api_version IN NUMBER DEFAULT 1.0,
180 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
181 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
182 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
183 p_hold_source_rec IN OE_HOLDS_PVT.hold_source_rec_type,
184 p_hold_release_rec IN OE_HOLDS_PVT.Hold_Release_Rec_Type,
185 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
186 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
187 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
188
189 Procedure Release_Holds (
190 p_api_version IN NUMBER DEFAULT 1.0,
191 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
192 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
193 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
194 p_order_tbl IN OE_HOLDS_PVT.order_tbl_type,
195 p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE DEFAULT NULL,
196 p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE,
197 p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE
198 DEFAULT NULL,
199 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
200 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
201 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
202
203 -- Delete Holds
204
205 PROCEDURE Delete_Holds
206 ( p_header_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
207 , p_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
208 );
209
210
211
212 PROCEDURE evaluate_holds( p_entity_code IN VARCHAR2
213 , p_entity_id IN NUMBER
214 , p_hold_entity_code IN VARCHAR2
215 --ER#7479609 , p_hold_entity_id IN NUMBER
216 , p_hold_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE --ER#7479609
217 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
218 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
219 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
220 );
221 PROCEDURE evaluate_holds_post_write
222 ( p_entity_code IN VARCHAR2
223 , p_entity_id IN NUMBER
224 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
225 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
226 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
227 );
228
229 PROCEDURE eval_post_write_header
230 ( p_entity_code IN VARCHAR2
231 , p_entity_id IN NUMBER
232 , p_hold_entity_code IN VARCHAR2
233 --ER#7479609 , p_hold_entity_id IN NUMBER
234 , p_hold_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE --ER#7479609
235 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
236 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
237 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
238 );
239
240
241 PROCEDURE RELEASE_EXPIRED_HOLDS
242 (
243 p_dummy1 OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
244 p_dummy2 OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
245 p_org_id IN NUMBER
246 );
247
248 PROCEDURE UPDATE_HOLD_COMMENTS (
249 p_hold_source_rec IN OE_HOLDS_PVT.Hold_Source_Rec_Type,
250 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
251 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
252 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 );
253
254
255 -- For customer global holds
256
257 PROCEDURE Process_Holds
258 ( p_api_version IN NUMBER
259 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
260 , p_hold_entity_code IN VARCHAR2
261 --ER#7479609 , p_hold_entity_id IN NUMBER
262 , p_hold_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE --ER#7479609
263 , p_hold_id IN NUMBER DEFAULT 1
264 , p_release_reason_code IN VARCHAR2 DEFAULT NULL
265 , p_action IN VARCHAR2
266 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
267 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
268 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
269 );
270
271 END OE_Holds_PUB;