1 PACKAGE OZF_SD_BATCH_FEED_PVT AUTHID CURRENT_USER as
2 /* $Header: ozfvsdfs.pls 120.19.12020000.2 2012/07/26 10:05:38 sariff ship $ */
3
4 -- Start of Comments
5 -- Package name : OZF_SD_BATCH_FEED_PVT
6 -- Purpose :
7 -- History : 20-JUL-2009 - Annsrini - Adjustment related changes
8 -- NOTE :
9 -- End of Comments
10
11
12 --G_PKG_NAME CONSTANT VARCHAR2(30) := 'OZF_SD_BATCH_FEED_PVT';
13 --G_FILE_NAME CONSTANT VARCHAR2(12) := 'ozfvsdfs.pls';
14
15 -- Author : MBHATT
16 -- Created : 11/16/2007 2:39:16 PM
17 -- Purpose :
18 -- Public function and procedure declarations
19
20
21 Type number_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
22
23 PROCEDURE UPDATE_STALE_DATA_BATCH_LINE (P_BATCH_NUMBER IN VARCHAR2,
24 P_BATCH_LINE_NUMBER IN VARCHAR2);
25
26 PROCEDURE POPULATE_INTERFACE
27 (P_BATCH_NUMBER IN VARCHAR2,
28 P_OPERATING_UNIT IN VARCHAR2,
29 P_FRM_CNTCT1_NAME IN VARCHAR2,
30 P_FRM_CNTCT1_EMAIL IN VARCHAR2,
31 P_FRM_CNTCT1_FAX IN VARCHAR2,
32 P_FRM_CNTCT1_PHONE IN VARCHAR2,
33 P_FRM_GBL_PTNR_ROLE_CLASS_CD IN VARCHAR2,
34 P_FRM_GBL_BUSINESS_ID IN VARCHAR2,
35 P_FRM_GBL_SUPPLY_CHAIN_CD IN VARCHAR2,
36 P_FRM_BUSINESS_NAME IN VARCHAR2,
37 P_FRM_PROP_BUSINESS_ID1 IN VARCHAR2,
38 P_FRM_PROP_DOMAIN_ID1 IN VARCHAR2,
39 P_FRM_AUTH_ID1 IN VARCHAR2,
40 P_FRM_GBL_PTNR_CLASS_CD IN VARCHAR2,
41 P_FRM_CNTCT2_NAME IN VARCHAR2,
42 P_FRM_CNTCT2_EMAIL IN VARCHAR2,
43 P_FRM_CNTCT2_FAX IN VARCHAR2,
44 P_FRM_CNTCT2_PHONE IN VARCHAR2,
45 P_FRM_GBL_LOC_ID IN VARCHAR2,
46 P_FRM_PROP_DOMAIN_ID2 IN VARCHAR2,
47 P_FRM_PROP_AUTH_ID2 IN VARCHAR2,
48 P_FRM_PROP_LOC_ID IN VARCHAR2,
49 P_FRM_ADD_LINE1 IN VARCHAR2,
50 P_FRM_ADD_LINE2 IN VARCHAR2,
51 P_FRM_ADD_LINE3 IN VARCHAR2,
52 P_FRM_CITY IN VARCHAR2,
53 P_FRM_COUNTRY IN VARCHAR2,
54 P_FRM_POSTAL_CODE IN VARCHAR2,
55 P_FRM_PO_BOX_ID IN VARCHAR2,
56 P_FRM_REGION IN VARCHAR2,
57 P_GBL_DOC_FUNC_CODE IN VARCHAR2,
58 P_SHIP_FROM_SD_AUTH_ID IN VARCHAR2,
59 P_DIST_BY_GBL_BUSINESS_ID IN VARCHAR2,
60 P_DIST_BY_GBL_SUPP_CHAIN_CD IN VARCHAR2,
61 P_DIST_BY_BUSINESS_NAME IN VARCHAR2,
62 P_DIST_BY_PROP_BUSINESS_ID IN VARCHAR2,
63 P_DIST_BY_PROP_DOMAIN_ID1 IN VARCHAR2,
64 P_DIST_BY_PROP_AUTH_ID1 IN VARCHAR2,
65 P_DIST_BY_GBL_PTNR_CLASS_CD IN VARCHAR2,
66 P_DIST_BY_CNTCT_NAME IN VARCHAR2,
67 P_DIST_BY_CNTCT_EMAIL IN VARCHAR2,
68 P_DIST_BY_CNTCT_FAX IN VARCHAR2,
69 P_DIST_BY_CNTCT_PHONE IN VARCHAR2,
70 P_DIST_BY_GBL_LOC_ID IN VARCHAR2,
71 P_DIST_BY_PROP_DOMAIN_ID2 IN VARCHAR2,
72 P_DIST_BY_PROP_AUTH_ID2 IN VARCHAR2,
73 P_DIST_BY_PROP_LOC_ID IN VARCHAR2,
74 P_DIST_BY_ADD_LINE1 IN VARCHAR2,
75 P_DIST_BY_ADD_LINE2 IN VARCHAR2,
76 P_DIST_BY_ADD_LINE3 IN VARCHAR2,
77 P_DIST_BY_CITY IN VARCHAR2,
78 P_DIST_BY_COUNTRY IN VARCHAR2,
79 P_DIST_BY_POSTAL_CODE IN VARCHAR2,
80 P_DIST_BY_PO_BOX_ID IN VARCHAR2,
81 P_DIST_BY_REGION IN VARCHAR2,
82 P_SHIP_TO_BUSINESS_NAME IN VARCHAR2,
83 P_SHIP_TO_GBL_BUSINESS_ID IN VARCHAR2,
84 P_SHIP_TO_GBL_SUPP_CHAIN_CD IN VARCHAR2,
85 P_SHIP_TO_PROP_BUSINESS_ID IN VARCHAR2,
86 P_SHIP_TO_PROP_DOMAIN_ID1 IN VARCHAR2,
87 P_SHIP_TO_PROP_AUTH_ID1 IN VARCHAR2,
88 P_SHIP_TO_GBL_PTNR_CLASS_CD IN VARCHAR2,
89 P_SHIP_TO_CUST_CNTCT_NAME IN VARCHAR2,
90 P_SHIP_TO_CUST_CNTCT_EMAIL IN VARCHAR2,
91 P_SHIP_TO_CUST_CNTCT_FAX IN VARCHAR2,
92 P_SHIP_TO_CUST_CNTCT_PHONE IN VARCHAR2,
93 P_SHIP_TO_CUST_GBL_LOC_ID IN VARCHAR2,
94 P_SHIP_TO_PROP_DOMAIN_ID2 IN VARCHAR2,
95 P_SHIP_TO_PROP_AUTH_ID2 IN VARCHAR2,
96 P_SHIP_TO_CUST_PROP_LOC_ID IN VARCHAR2,
97 P_SHIP_TO_CUST_ADD1 IN VARCHAR2,
98 P_SHIP_TO_CUST_ADD2 IN VARCHAR2,
99 P_SHIP_TO_CUST_ADD3 IN VARCHAR2,
100 P_SHIP_TO_CUST_CITY IN VARCHAR2,
101 P_SHIP_TO_CUST_COUNTRY IN VARCHAR2,
102 P_SHIP_TO_CUST_POSTAL_CODE IN VARCHAR2,
103 P_SHIP_TO_CUST_PO_BOX_ID IN VARCHAR2,
104 P_SHIP_TO_CUST_REGION IN VARCHAR2,
105 P_SOLD_TO_BUSINESS_NAME IN VARCHAR2,
106 P_SOLD_TO_GBL_BUSINESS_ID IN VARCHAR2,
107 P_SOLD_TO_GBL_SUPP_CHAIN_CD IN VARCHAR2,
108 P_SOLD_TO_PROP_BUSINESS_ID IN VARCHAR2,
109 P_SOLD_TO_PROP_DOMAIN_ID1 IN VARCHAR2,
110 P_SOLD_TO_PROP_AUTH_ID1 IN VARCHAR2,
111 P_SOLD_TO_GBL_PTNR_CLASS_CD IN VARCHAR2,
112 P_SOLD_TO_CUST_CNTCT_NAME IN VARCHAR2,
113 P_SOLD_TO_CUST_CNTCT_EMAIL IN VARCHAR2,
114 P_SOLD_TO_CUST_CNTCT_FAX IN VARCHAR2,
115 P_SOLD_TO_CUST_CNTCT_PHONE IN VARCHAR2,
116 P_SOLD_TO_CUST_GBL_LOC_ID IN VARCHAR2,
117 P_SOLD_TO_PROP_DOMAIN_ID2 IN VARCHAR2,
118 P_SOLD_TO_PROP_AUTH_ID2 IN VARCHAR2,
119 P_SOLD_TO_CUST_PROP_LOC_ID IN VARCHAR2,
120 P_SOLD_TO_CUST_ADD1 IN VARCHAR2,
121 P_SOLD_TO_CUST_ADD2 IN VARCHAR2,
122 P_SOLD_TO_CUST_ADD3 IN VARCHAR2,
123 P_SOLD_TO_CUST_CITY IN VARCHAR2,
124 P_SOLD_TO_CUST_COUNTRY IN VARCHAR2,
125 P_SOLD_TO_CUST_POSTAL_CODE IN VARCHAR2,
126 P_SOLD_TO_CUST_PO_BOX_ID IN VARCHAR2,
127 P_SOLD_TO_CUST_REGION IN VARCHAR2,
128 P_END_CUST_BUSINESS_NAME IN VARCHAR2,
129 P_END_CUST_GBL_BUSINESS_ID IN VARCHAR2,
130 P_END_CUST_GBL_SUPP_CHAIN_CD IN VARCHAR2,
131 P_END_CUST_PROP_BUSINESS_ID IN VARCHAR2,
132 P_END_CUST_PROP_DOMAIN_ID1 IN VARCHAR2,
133 P_END_CUST_PROP_AUTH_ID1 IN VARCHAR2,
134 P_END_CUST_GBL_PTNR_CLASS_CD IN VARCHAR2,
135 P_END_CUST_CNTCT_NAME IN VARCHAR2,
136 P_END_CUST_CNTCT_EMAIL IN VARCHAR2,
137 P_END_CUST_CNTCT_FAX IN VARCHAR2,
138 P_END_CUST_CNTCT_PHONE IN VARCHAR2,
139 P_END_CUST_GBL_LOC_ID IN VARCHAR2,
140 P_END_CUST_PROP_DOMAIN_ID2 IN VARCHAR2,
141 P_END_CUST_PROP_AUTH_ID2 IN VARCHAR2,
142 P_END_CUST_PROP_LOC_ID IN VARCHAR2,
143 P_END_CUST_ADD1 IN VARCHAR2,
144 P_END_CUST_ADD2 IN VARCHAR2,
145 P_END_CUST_ADD3 IN VARCHAR2,
146 P_END_CUST_CITY IN VARCHAR2,
147 P_END_CUST_COUNTRY IN VARCHAR2,
148 P_END_CUST_POSTAL_CODE IN VARCHAR2,
149 P_END_CUST_PO_BOX_ID IN VARCHAR2,
150 P_END_CUST_REGION IN VARCHAR2,
151 P_SHIP_FRM_SD_CLAIM_REQ_DATE IN DATE,
152 P_SHIP_FRM_SD_CLAIM_REQ_ID IN VARCHAR2,
153 P_CREDIT_REF_ID IN VARCHAR2,
154 P_DEBIT_REF_ID IN VARCHAR2,
155 P_BATCH_LINE_ID IN NUMBER,
156 P_BATCH_LINE_NUMBER IN NUMBER,
157 P_ORDER_DATE IN DATE,
158 P_ORDER_LINE_NUMBER IN VARCHAR2,
159 P_ORDER_NUMBER IN VARCHAR2,
160 P_INVOICE_DATE IN DATE,
161 P_INVOICE_LINE_NUMBER IN VARCHAR2,
162 P_INVOICE_NUMBER IN VARCHAR2,
163 P_DISCOUNT_TYPE IN VARCHAR2,
164 P_DISCOUNT_VALUE IN NUMBER,
165 P_DISCOUNT_CURRENCY IN VARCHAR2,
166 P_COST_PRICE IN NUMBER,
167 P_COST_PRICE_CURR_CODE IN VARCHAR2,
168 P_AUTH_PRICE IN NUMBER,
169 P_AUTH_PRICE_CURR_CODE IN VARCHAR2,
170 P_RESALE_PRICE IN NUMBER,
171 P_RESALE_PRICE_CURR_CODE IN VARCHAR2,
172 P_UOM IN VARCHAR2,
173 P_LINE_STATUS IN VARCHAR2,
174 P_DISPOSITION_CODE1 IN VARCHAR2,
175 P_DISPOSITION_CODE2 IN VARCHAR2,
176 P_DISPOSITION_CODE3 IN VARCHAR2,
177 P_DISPOSITION_CODE4 IN VARCHAR2,
178 P_DISPOSITION_CODE5 IN VARCHAR2,
179 P_DISPOSITION_CODE6 IN VARCHAR2,
180 P_DISPOSITION_CODE7 IN VARCHAR2,
181 P_DISPOSITION_CODE8 IN VARCHAR2,
182 P_DISPOSITION_CODE9 IN VARCHAR2,
183 P_DISPOSITION_CODE10 IN VARCHAR2,
184 P_VENDOR_PART_NUMBER IN VARCHAR2,
185 P_DIST_PART_NUMBER IN VARCHAR2,
186 P_DATE_SHIPPED IN DATE,
187 P_QTY_SHIPPED IN NUMBER,
188 P_CLAIM_AMT_CURR_CODE IN VARCHAR2,
189 P_LAST_SUB_CLAIM_AMT IN NUMBER,
190 P_VENDOR_AUTH_LINE_ITEM_NO IN VARCHAR2,
191 P_VENDOR_APPRVD_AMT IN NUMBER,
192 P_VENDOR_APPRVD_AMT_CURR_CD IN VARCHAR2,
193 P_VENDOR_APPRVD_QTY IN NUMBER,
194 P_BATCH_SUBMISSION_DATE IN DATE,
195 P_BATCH_ID IN NUMBER,
196 P_TO_CNTCT1_NAME IN VARCHAR2,
197 P_TO_CNTCT1_EMAIL IN VARCHAR2,
198 P_TO_CNTCT1_FAX IN VARCHAR2,
199 P_TO_CNTCT1_PHONE IN VARCHAR2,
200 P_TO_GBL_PTNR_ROLE_CLASS_CD IN VARCHAR2,
201 P_TO_GBL_BUSINESS_ID IN VARCHAR2,
202 P_TO_GBL_SUPPLY_CHAIN_CD IN VARCHAR2,
203 P_TO_BUSINESS_NAME IN VARCHAR2,
204 P_TO_PROP_BUSINESS_ID1 IN VARCHAR2,
205 P_TO_PROP_DOMAIN_ID1 IN VARCHAR2,
206 P_TO_AUTH_ID1 IN VARCHAR2,
207 P_TO_GBL_PTNR_CLASS_CD IN VARCHAR2,
208 P_TO_CNTCT2_NAME IN VARCHAR2,
209 P_TO_CNTCT2_EMAIL IN VARCHAR2,
210 P_TO_CNTCT2_FAX IN VARCHAR2,
211 P_TO_CNTCT2_PHONE IN VARCHAR2,
212 P_TO_GBL_LOC_ID IN VARCHAR2,
213 P_TO_PROP_DOMAIN_ID2 IN VARCHAR2,
214 P_TO_PROP_AUTH_ID2 IN VARCHAR2,
215 P_TO_PROP_LOC_ID IN VARCHAR2,
216 P_TO_ADD_LINE1 IN VARCHAR2,
217 P_TO_ADD_LINE2 IN VARCHAR2,
218 P_TO_ADD_LINE3 IN VARCHAR2,
219 P_TO_CITY IN VARCHAR2,
220 P_TO_COUNTRY IN VARCHAR2,
221 P_TO_POSTAL_CODE IN VARCHAR2,
222 P_TO_PO_BOX_ID IN VARCHAR2,
223 P_TO_REGION IN VARCHAR2,
224 P_HDR_ATTR_CATG IN VARCHAR2,
225 P_HDR_ATTR1 IN VARCHAR2,
226 P_HDR_ATTR2 IN VARCHAR2,
227 P_HDR_ATTR3 IN VARCHAR2,
228 P_HDR_ATTR4 IN VARCHAR2,
229 P_HDR_ATTR5 IN VARCHAR2,
230 P_HDR_ATTR6 IN VARCHAR2,
231 P_HDR_ATTR7 IN VARCHAR2,
232 P_HDR_ATTR8 IN VARCHAR2,
233 P_HDR_ATTR9 IN VARCHAR2,
234 P_HDR_ATTR10 IN VARCHAR2,
235 P_HDR_ATTR11 IN VARCHAR2,
236 P_HDR_ATTR12 IN VARCHAR2,
237 P_HDR_ATTR13 IN VARCHAR2,
238 P_HDR_ATTR14 IN VARCHAR2,
239 P_HDR_ATTR15 IN VARCHAR2,
240 P_HDR_ATTR16 IN VARCHAR2,
241 P_HDR_ATTR17 IN VARCHAR2,
242 P_HDR_ATTR18 IN VARCHAR2,
243 P_HDR_ATTR19 IN VARCHAR2,
244 P_HDR_ATTR20 IN VARCHAR2,
245 P_HDR_ATTR21 IN VARCHAR2,
246 P_HDR_ATTR22 IN VARCHAR2,
247 P_HDR_ATTR23 IN VARCHAR2,
248 P_HDR_ATTR24 IN VARCHAR2,
249 P_HDR_ATTR25 IN VARCHAR2,
250 P_HDR_ATTR26 IN VARCHAR2,
251 P_HDR_ATTR27 IN VARCHAR2,
252 P_HDR_ATTR28 IN VARCHAR2,
253 P_HDR_ATTR29 IN VARCHAR2,
254 P_HDR_ATTR30 IN VARCHAR2,
255 P_LINE_ATTR_CATG IN VARCHAR2,
256 P_LINE_ATTR1 IN VARCHAR2,
257 P_LINE_ATTR2 IN VARCHAR2,
258 P_LINE_ATTR3 IN VARCHAR2,
259 P_LINE_ATTR4 IN VARCHAR2,
260 P_LINE_ATTR5 IN VARCHAR2,
261 P_LINE_ATTR6 IN VARCHAR2,
262 P_LINE_ATTR7 IN VARCHAR2,
263 P_LINE_ATTR8 IN VARCHAR2,
264 P_LINE_ATTR9 IN VARCHAR2,
265 P_LINE_ATTR10 IN VARCHAR2,
266 P_LINE_ATTR11 IN VARCHAR2,
267 P_LINE_ATTR12 IN VARCHAR2,
268 P_LINE_ATTR13 IN VARCHAR2,
269 P_LINE_ATTR14 IN VARCHAR2,
270 P_LINE_ATTR15 IN VARCHAR2,
271 P_LINE_ATTR16 IN VARCHAR2,
272 P_LINE_ATTR17 IN VARCHAR2,
273 P_LINE_ATTR18 IN VARCHAR2,
274 P_LINE_ATTR19 IN VARCHAR2,
275 P_LINE_ATTR20 IN VARCHAR2,
276 P_LINE_ATTR21 IN VARCHAR2,
277 P_LINE_ATTR22 IN VARCHAR2,
278 P_LINE_ATTR23 IN VARCHAR2,
279 P_LINE_ATTR24 IN VARCHAR2,
280 P_LINE_ATTR25 IN VARCHAR2,
281 P_LINE_ATTR26 IN VARCHAR2,
282 P_LINE_ATTR27 IN VARCHAR2,
283 P_LINE_ATTR28 IN VARCHAR2,
284 P_LINE_ATTR29 IN VARCHAR2,
285 P_LINE_ATTR30 IN VARCHAR2
286 );
287
288 PROCEDURE UPDATE_DATA (
289 P_Batch_Number IN VARCHAR2,
290 x_return_status OUT NOCOPY VARCHAR2, --E,S
291 x_msg_data OUT NOCOPY VARCHAR2 --descr
292 );
293
294 procedure PROCESS_CHILD_BATCH (P_Batch_ID IN NUMBER, x_return_status OUT nocopy VARCHAR2, x_msg_data OUT nocopy VARCHAR2);
295
296 PROCEDURE PROCESS_CHILD_BATCH(p_batch_id IN NUMBER,
297 p_batch_appr_lines_tbl IN number_tbl,
298 p_batch_undr_appr_lines_tbl IN number_tbl,
299 p_batch_over_appr_lines_tbl IN number_tbl,
300 p_batch_comp_appr_lines_tbl IN number_tbl,
301 x_return_status OUT nocopy VARCHAR2,
302 x_msg_data OUT nocopy VARCHAR2);
303
304 PROCEDURE PROCESS_COMP_APPR_BATCH(p_batch_id IN NUMBER,x_return_status OUT nocopy VARCHAR2,x_msg_data OUT nocopy VARCHAR2);
305
306 PROCEDURE PROCESS_CLAIM (p_batch_id IN NUMBER, x_return_status OUT nocopy VARCHAR2, x_msg_data OUT nocopy VARCHAR2, x_claim_id OUT NOCOPY NUMBER);
307
308 PROCEDURE UPDATE_DISPUTE_DATA (p_batch_number varchar2,p_batch_id number);
309
310 END OZF_SD_BATCH_FEED_PVT;
311