[Home] [Help]
PACKAGE: APPS.OZF_SD_BATCH_PVT
Source
1 PACKAGE OZF_SD_BATCH_PVT AUTHID CURRENT_USER as
2 /* $Header: ozfvsdbs.pls 120.32 2011/08/24 05:44:36 rsatyava ship $ */
3
4 -- Start of Comments
5 -- Package name : OZF_SD_BATCH_PVT
6 -- Purpose :
7 -- History :
8 -- 26-SEP-2008 - ANNSRINI - Modified p_start_date and p_end_date to varchar instead of DATE in create_batch_main
9 -- 19-JUN-2009 - ANNSRINI - 3 APIs added - PROCESS_SD_PENDING_CLM_BATCHES, PROCESS_SUPPLIER_SITES and INVOKE_CLAIM
10 -- 20-JUL-2009 - ANNSRINI - Adjustment related changes
11 -- 07-DEC-2009 - ANNSRINI - changes w.r.t multicurrency
12 -- NOTE :
13 -- End of Comments
14
15 --G_PKG_NAME CONSTANT VARCHAR2(30) := 'OZF_SD_BATCH_PVT';
16 --G_FILE_NAME CONSTANT VARCHAR2(12) := 'ozfvsdbs.pls';
17
18 --Start:Added for fixing the bug#9447673
19 TYPE BatchTypes IS TABLE OF VARCHAR2(30);
20 --Start:Added for fixing the bug#9447673
21
22
23 -- Author : MBHATT
24 -- Created : 11/16/2007 2:39:16 PM
25 -- Purpose :
26 -- Public function and procedure declarations
27 -- Private type declarations
28
29 PROCEDURE create_batch_main(errbuf OUT nocopy VARCHAR2,
30 retcode OUT nocopy NUMBER,
31 p_org_id IN NUMBER,
32 p_supplier_id IN NUMBER,
33 p_supplier_site_id IN NUMBER,
34 --p_category_id IN NUMBER,
35 p_fund_id IN NUMBER,
36 p_request_id IN NUMBER,
37 p_product_id IN NUMBER,
38 p_start_date IN VARCHAR2,
39 p_end_date IN VARCHAR2,
40 p_period IN VARCHAR2,
41 p_owner IN NUMBER,
42 p_attribute1 IN VARCHAR2 := NULL,
43 p_attribute2 IN VARCHAR2 := NULL,
44 p_attribute3 IN VARCHAR2 := NULL,
45 p_attribute4 IN VARCHAR2 := NULL,
46 p_attribute5 IN VARCHAR2 := NULL,
47 p_attribute6 IN VARCHAR2 := NULL,
48 p_attribute7 IN VARCHAR2 := NULL,
49 p_attribute8 IN VARCHAR2 := NULL,
50 p_attribute9 IN VARCHAR2 := NULL,
51 p_attribute10 IN VARCHAR2 := NULL,
52 p_attribute11 IN VARCHAR2 := NULL,
53 p_attribute12 IN VARCHAR2 := NULL,
54 p_attribute13 IN VARCHAR2 := NULL,
55 p_attribute14 IN VARCHAR2 := NULL,
56 p_attribute15 IN VARCHAR2 := NULL);
57
58 PROCEDURE create_batch_sub(p_org_id IN NUMBER,
59 p_supplier_id IN NUMBER,
60 p_supplier_site_id IN NUMBER,
61 --p_category_id IN NUMBER,
62 p_product_id IN NUMBER,
63 p_request_id IN NUMBER,
64 p_fund_id IN NUMBER,
65 p_start_date IN DATE,
66 p_end_date IN DATE,
67 p_period IN VARCHAR2,
68 p_owner IN NUMBER,
69 p_commit IN VARCHAR2 := FND_API.g_false,
70 p_attribute1 IN VARCHAR2 := NULL,
71 p_attribute2 IN VARCHAR2 := NULL,
72 p_attribute3 IN VARCHAR2 := NULL,
73 p_attribute4 IN VARCHAR2 := NULL,
74 p_attribute5 IN VARCHAR2 := NULL,
75 p_attribute6 IN VARCHAR2 := NULL,
76 p_attribute7 IN VARCHAR2 := NULL,
77 p_attribute8 IN VARCHAR2 := NULL,
78 p_attribute9 IN VARCHAR2 := NULL,
79 p_attribute10 IN VARCHAR2 := NULL,
80 p_attribute11 IN VARCHAR2 := NULL,
81 p_attribute12 IN VARCHAR2 := NULL,
82 p_attribute13 IN VARCHAR2 := NULL,
83 p_attribute14 IN VARCHAR2 := NULL,
84 p_attribute15 IN VARCHAR2 := NULL,
85 p_batch_types IN BatchTypes);
86
87 Procedure CREATE_BATCH(p_empty_batch OUT NOCOPY VARCHAR2,
88 p_supplier_id IN NUMBER,
89 p_supplier_site_id IN NUMBER,
90 p_org_id IN NUMBER,
91 --p_category_id IN NUMBER,
92 p_product_id IN NUMBER,
93 p_request_id IN NUMBER,
94 p_fund_id IN NUMBER,
95 p_start_date IN DATE,
96 p_end_date IN DATE,
97 p_period IN VARCHAR2,
98 p_currency_code IN VARCHAR2,
99 p_owner IN NUMBER,
100 p_attribute1 IN VARCHAR2 := NULL,
101 p_attribute2 IN VARCHAR2 := NULL,
102 p_attribute3 IN VARCHAR2 := NULL,
103 p_attribute4 IN VARCHAR2 := NULL,
104 p_attribute5 IN VARCHAR2 := NULL,
105 p_attribute6 IN VARCHAR2 := NULL,
106 p_attribute7 IN VARCHAR2 := NULL,
107 p_attribute8 IN VARCHAR2 := NULL,
108 p_attribute9 IN VARCHAR2 := NULL,
109 p_attribute10 IN VARCHAR2 := NULL,
110 p_attribute11 IN VARCHAR2 := NULL,
111 p_attribute12 IN VARCHAR2 := NULL,
112 p_attribute13 IN VARCHAR2 := NULL,
113 p_attribute14 IN VARCHAR2 := NULL,
114 p_attribute15 IN VARCHAR2 := NULL,
115 p_batch_type IN VARCHAR2);
116
117 Procedure CREATE_BATCH_HEADER(p_supplier_id IN NUMBER,
118 p_supplier_site_id IN NUMBER,
119 p_org_id IN NUMBER,
120 p_batch_threshold NUMBER,
121 p_line_threshold NUMBER,
122 p_batch_currency VARCHAR2,
123 p_batch_new IN VARCHAR2,
124 p_batch_status IN VARCHAR2,
125 p_claim_number IN VARCHAR2,
126 p_claim_minor_version IN NUMBER,
127 p_parent_batch_id IN NUMBER,
128 p_batch_id OUT nocopy NUMBER,
129 p_batch_type IN VARCHAR2,
130 p_owner IN NUMBER);
131
132 Procedure CREATE_OM_BATCH_LINES(p_batch_id IN NUMBER,
133 p_supplier_id IN NUMBER,
134 p_supplier_site_id IN NUMBER,
135 p_org_id IN NUMBER,
136 p_thresh_line_limit IN NUMBER,
137 p_batch_currency IN VARCHAR2,
138 --p_category_id IN NUMBER,
139 p_product_id IN NUMBER,
140 p_request_id IN NUMBER,
141 p_fund_id IN NUMBER,
142 p_start_date IN DATE,
143 p_end_date IN DATE,
144 p_period IN VARCHAR2,
145 p_empty_batch OUT NOCOPY VARCHAR2,
146 p_attribute1 IN VARCHAR2 := NULL,
147 p_attribute2 IN VARCHAR2 := NULL,
148 p_attribute3 IN VARCHAR2 := NULL,
149 p_attribute4 IN VARCHAR2 := NULL,
150 p_attribute5 IN VARCHAR2 := NULL,
151 p_attribute6 IN VARCHAR2 := NULL,
152 p_attribute7 IN VARCHAR2 := NULL,
153 p_attribute8 IN VARCHAR2 := NULL,
154 p_attribute9 IN VARCHAR2 := NULL,
155 p_attribute10 IN VARCHAR2 := NULL,
156 p_attribute11 IN VARCHAR2 := NULL,
157 p_attribute12 IN VARCHAR2 := NULL,
158 p_attribute13 IN VARCHAR2 := NULL,
159 p_attribute14 IN VARCHAR2 := NULL,
160 p_attribute15 IN VARCHAR2 := NULL,
161 p_order_source IN VARCHAR2);
162
163 Procedure CREATE_IDSM_BATCH_LINES(p_batch_id IN NUMBER,
164 p_supplier_id IN NUMBER,
165 p_supplier_site_id IN NUMBER,
166 p_org_id IN NUMBER,
167 p_thresh_line_limit IN NUMBER,
168 p_batch_currency IN VARCHAR2,
169 --p_category_id IN NUMBER,
170 p_product_id IN NUMBER,
171 p_request_id IN NUMBER,
172 p_fund_id IN NUMBER,
173 p_start_date IN DATE,
174 p_end_date IN DATE,
175 p_period IN VARCHAR2,
176 p_empty_batch OUT NOCOPY VARCHAR2,
177 p_attribute1 IN VARCHAR2 := NULL,
178 p_attribute2 IN VARCHAR2 := NULL,
179 p_attribute3 IN VARCHAR2 := NULL,
180 p_attribute4 IN VARCHAR2 := NULL,
181 p_attribute5 IN VARCHAR2 := NULL,
182 p_attribute6 IN VARCHAR2 := NULL,
183 p_attribute7 IN VARCHAR2 := NULL,
184 p_attribute8 IN VARCHAR2 := NULL,
185 p_attribute9 IN VARCHAR2 := NULL,
186 p_attribute10 IN VARCHAR2 := NULL,
187 p_attribute11 IN VARCHAR2 := NULL,
188 p_attribute12 IN VARCHAR2 := NULL,
189 p_attribute13 IN VARCHAR2 := NULL,
190 p_attribute14 IN VARCHAR2 := NULL,
191 p_attribute15 IN VARCHAR2 := NULL,
192 p_order_source IN VARCHAR2);
193
194 Procedure UPDATE_AMOUNTS(p_batch_id IN NUMBER,
195 p_batch_threshold IN NUMBER);
196
197
198 FUNCTION GET_BATCH_CURRENCY_AMOUNT(p_func_currency VARCHAR2,
199 p_batch_currency VARCHAR2,
200 p_acctd_amount NUMBER,
201 p_conv_type VARCHAR2,
202 p_conv_rate NUMBER,
203 p_date DATE) RETURN NUMBER;
204
205 FUNCTION GET_VENDOR_ITEM_ID(p_product_id number, p_supplier_site_id number)
206 return varchar2;
207
208 FUNCTION CONV_DISC_TO_OFFER_CURR_AMOUNT(p_offer_currency VARCHAR2,
209 p_discount_val_currency VARCHAR2,
210 p_discount_val number,
211 p_date date) RETURN number;
212
213 procedure INVOKE_BATCH_AUTO_CLAIM(errbuf OUT nocopy VARCHAR2,
214 retcode OUT nocopy NUMBER,
215 p_batch_id number,
216 p_vendor_id number,
217 p_vendor_site_id number
218 );
219
220 FUNCTION CURR_ROUND_EXT_PREC( p_amount IN NUMBER,
221 p_currency_code IN VARCHAR2
222 ) return number;
223
224 PROCEDURE PROCESS_SD_PENDING_CLM_BATCHES(errbuf OUT nocopy VARCHAR2,
225 retcode OUT nocopy NUMBER,
226 p_org_id NUMBER,
227 p_vendor_id NUMBER,
228 p_vendor_site_id NUMBER,
229 p_batch_id NUMBER);
230
231 PROCEDURE PROCESS_SUPPLIER_SITES(p_org_id IN NUMBER,
232 p_vendor_id IN NUMBER,
233 p_vendor_site_id IN NUMBER,
234 p_batch_id IN NUMBER);
235
236 PROCEDURE INVOKE_CLAIM(p_org_id IN NUMBER,
237 p_vendor_id IN NUMBER,
238 p_vendor_site_id IN NUMBER,
239 p_batch_id IN NUMBER);
240
241
242 --Start:Added For Bug#10011106 fix
243 -- Start of comments
244 -- API name : CONV_AMT_TO_OFFER_CURR_AMOUNT
245 -- Pre-reqs : None.
246 -- Function : Converts Amount value from currency pass for the amount to offer currency
247 -- Conversion is not made if FROM and TO currency are the same.
248 -- Parameters :
249 -- IN : p_offer_currency IN NUMBER Required
250 -- p_amt_val_currency IN VARCHAR2 Required
251 -- p_amt_val IN NUMBER Required
252 -- p_fu_exchange_rate IN DATE Required
253 -- p_exchange_rate_type IN VARCHAR2 Required
254 -- OUT : Converted currency value.
255 -- End of comments
256
257
258 FUNCTION CONV_AMT_TO_OFFER_CURR_AMOUNT(p_offer_currency VARCHAR2,
259 p_amt_val_currency VARCHAR2,
260 p_amt_val number,
261 p_fu_exchange_rate date,
262 p_exchange_rate_type VARCHAR2) return number;
263 --End:Added For Bug#10011106 fix
264
265 END OZF_SD_BATCH_PVT;