1 PACKAGE OZF_SD_BATCH_FEED_PVT as
2 /* $Header: ozfvsdfs.pls 120.10.12010000.2 2008/08/04 06:37:25 annsrini ship $ */
3
4 -- Start of Comments
5 -- Package name : OZF_SD_BATCH_FEED_PVT
6 -- Purpose :
7 -- History :
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 PROCEDURE UPDATE_STALE_DATA_BATCH_LINE (P_BATCH_NUMBER IN VARCHAR2,
21 P_BATCH_LINE_NUMBER IN VARCHAR2);
22
23 PROCEDURE POPULATE_INTERFACE
24 (P_BATCH_NUMBER IN VARCHAR2,
25 P_OPERATING_UNIT IN VARCHAR2,
26 P_FRM_CNTCT1_NAME IN VARCHAR2,
27 P_FRM_CNTCT1_EMAIL IN VARCHAR2,
28 P_FRM_CNTCT1_FAX IN VARCHAR2,
29 P_FRM_CNTCT1_PHONE IN VARCHAR2,
30 P_FRM_GBL_PTNR_ROLE_CLASS_CD IN VARCHAR2,
31 P_FRM_GBL_BUSINESS_ID IN NUMBER,
32 P_FRM_GBL_SUPPLY_CHAIN_CD IN VARCHAR2,
33 P_FRM_BUSINESS_NAME IN VARCHAR2,
34 P_FRM_PROP_BUSINESS_ID1 IN VARCHAR2,
35 P_FRM_PROP_DOMAIN_ID1 IN VARCHAR2,
36 P_FRM_AUTH_ID1 IN VARCHAR2,
37 P_FRM_GBL_PTNR_CLASS_CD IN VARCHAR2,
38 P_FRM_CNTCT2_NAME IN VARCHAR2,
39 P_FRM_CNTCT2_EMAIL IN VARCHAR2,
40 P_FRM_CNTCT2_FAX IN VARCHAR2,
41 P_FRM_CNTCT2_PHONE IN VARCHAR2,
42 P_FRM_GBL_LOC_ID IN NUMBER,
43 P_FRM_PROP_DOMAIN_ID2 IN VARCHAR2,
44 P_FRM_PROP_AUTH_ID2 IN VARCHAR2,
45 P_FRM_PROP_LOC_ID IN VARCHAR2,
46 P_FRM_ADD_LINE1 IN VARCHAR2,
47 P_FRM_ADD_LINE2 IN VARCHAR2,
48 P_FRM_ADD_LINE3 IN VARCHAR2,
49 P_FRM_CITY IN VARCHAR2,
50 P_FRM_COUNTRY IN VARCHAR2,
51 P_FRM_POSTAL_CODE IN VARCHAR2,
52 P_FRM_PO_BOX_ID IN VARCHAR2,
53 P_FRM_REGION IN VARCHAR2,
54 P_GBL_DOC_FUNC_CODE IN VARCHAR2,
55 P_SHIP_FROM_SD_AUTH_ID IN VARCHAR2,
56 P_DIST_BY_GBL_BUSINESS_ID IN NUMBER,
57 P_DIST_BY_GBL_SUPP_CHAIN_CD IN VARCHAR2,
58 P_DIST_BY_BUSINESS_NAME IN VARCHAR2,
59 P_DIST_BY_PROP_BUSINESS_ID IN VARCHAR2,
60 P_DIST_BY_PROP_DOMAIN_ID1 IN VARCHAR2,
61 P_DIST_BY_PROP_AUTH_ID1 IN VARCHAR2,
62 P_DIST_BY_GBL_PTNR_CLASS_CD IN VARCHAR2,
63 P_DIST_BY_CNTCT_NAME IN VARCHAR2,
64 P_DIST_BY_CNTCT_EMAIL IN VARCHAR2,
65 P_DIST_BY_CNTCT_FAX IN VARCHAR2,
66 P_DIST_BY_CNTCT_PHONE IN VARCHAR2,
67 P_DIST_BY_GBL_LOC_ID IN NUMBER,
68 P_DIST_BY_PROP_DOMAIN_ID2 IN VARCHAR2,
69 P_DIST_BY_PROP_AUTH_ID2 IN VARCHAR2,
70 P_DIST_BY_PROP_LOC_ID IN VARCHAR2,
71 P_DIST_BY_ADD_LINE1 IN VARCHAR2,
72 P_DIST_BY_ADD_LINE2 IN VARCHAR2,
73 P_DIST_BY_ADD_LINE3 IN VARCHAR2,
74 P_DIST_BY_CITY IN VARCHAR2,
75 P_DIST_BY_COUNTRY IN VARCHAR2,
76 P_DIST_BY_POSTAL_CODE IN VARCHAR2,
77 P_DIST_BY_PO_BOX_ID IN VARCHAR2,
78 P_DIST_BY_REGION IN VARCHAR2,
79 P_SHIP_TO_BUSINESS_NAME IN VARCHAR2,
80 P_SHIP_TO_GBL_BUSINESS_ID IN NUMBER,
81 P_SHIP_TO_GBL_SUPP_CHAIN_CD IN VARCHAR2,
82 P_SHIP_TO_PROP_BUSINESS_ID IN VARCHAR2,
83 P_SHIP_TO_PROP_DOMAIN_ID1 IN VARCHAR2,
84 P_SHIP_TO_PROP_AUTH_ID1 IN VARCHAR2,
85 P_SHIP_TO_GBL_PTNR_CLASS_CD IN VARCHAR2,
86 P_SHIP_TO_CUST_CNTCT_NAME IN VARCHAR2,
87 P_SHIP_TO_CUST_CNTCT_EMAIL IN VARCHAR2,
88 P_SHIP_TO_CUST_CNTCT_FAX IN VARCHAR2,
89 P_SHIP_TO_CUST_CNTCT_PHONE IN VARCHAR2,
90 P_SHIP_TO_CUST_GBL_LOC_ID IN NUMBER,
91 P_SHIP_TO_PROP_DOMAIN_ID2 IN VARCHAR2,
92 P_SHIP_TO_PROP_AUTH_ID2 IN VARCHAR2,
93 P_SHIP_TO_CUST_PROP_LOC_ID IN VARCHAR2,
94 P_SHIP_TO_CUST_ADD1 IN VARCHAR2,
95 P_SHIP_TO_CUST_ADD2 IN VARCHAR2,
96 P_SHIP_TO_CUST_ADD3 IN VARCHAR2,
97 P_SHIP_TO_CUST_CITY IN VARCHAR2,
98 P_SHIP_TO_CUST_COUNTRY IN VARCHAR2,
99 P_SHIP_TO_CUST_POSTAL_CODE IN VARCHAR2,
100 P_SHIP_TO_CUST_PO_BOX_ID IN VARCHAR2,
101 P_SHIP_TO_CUST_REGION IN VARCHAR2,
102 P_SOLD_TO_BUSINESS_NAME IN VARCHAR2,
103 P_SOLD_TO_GBL_BUSINESS_ID IN NUMBER,
104 P_SOLD_TO_GBL_SUPP_CHAIN_CD IN VARCHAR2,
105 P_SOLD_TO_PROP_BUSINESS_ID IN VARCHAR2,
106 P_SOLD_TO_PROP_DOMAIN_ID1 IN VARCHAR2,
107 P_SOLD_TO_PROP_AUTH_ID1 IN VARCHAR2,
108 P_SOLD_TO_GBL_PTNR_CLASS_CD IN VARCHAR2,
109 P_SOLD_TO_CUST_CNTCT_NAME IN VARCHAR2,
110 P_SOLD_TO_CUST_CNTCT_EMAIL IN VARCHAR2,
111 P_SOLD_TO_CUST_CNTCT_FAX IN VARCHAR2,
112 P_SOLD_TO_CUST_CNTCT_PHONE IN VARCHAR2,
113 P_SOLD_TO_CUST_GBL_LOC_ID IN NUMBER,
114 P_SOLD_TO_PROP_DOMAIN_ID2 IN VARCHAR2,
115 P_SOLD_TO_PROP_AUTH_ID2 IN VARCHAR2,
116 P_SOLD_TO_CUST_PROP_LOC_ID IN VARCHAR2,
117 P_SOLD_TO_CUST_ADD1 IN VARCHAR2,
118 P_SOLD_TO_CUST_ADD2 IN VARCHAR2,
119 P_SOLD_TO_CUST_ADD3 IN VARCHAR2,
120 P_SOLD_TO_CUST_CITY IN VARCHAR2,
121 P_SOLD_TO_CUST_COUNTRY IN VARCHAR2,
122 P_SOLD_TO_CUST_POSTAL_CODE IN VARCHAR2,
123 P_SOLD_TO_CUST_PO_BOX_ID IN VARCHAR2,
124 P_SOLD_TO_CUST_REGION IN VARCHAR2,
125 P_END_CUST_BUSINESS_NAME IN VARCHAR2,
126 P_END_CUST_GBL_BUSINESS_ID IN NUMBER,
127 P_END_CUST_GBL_SUPP_CHAIN_CD IN VARCHAR2,
128 P_END_CUST_PROP_BUSINESS_ID IN VARCHAR2,
129 P_END_CUST_PROP_DOMAIN_ID1 IN VARCHAR2,
130 P_END_CUST_PROP_AUTH_ID1 IN VARCHAR2,
131 P_END_CUST_GBL_PTNR_CLASS_CD IN VARCHAR2,
132 P_END_CUST_CNTCT_NAME IN VARCHAR2,
133 P_END_CUST_CNTCT_EMAIL IN VARCHAR2,
134 P_END_CUST_CNTCT_FAX IN VARCHAR2,
135 P_END_CUST_CNTCT_PHONE IN VARCHAR2,
136 P_END_CUST_GBL_LOC_ID IN NUMBER,
137 P_END_CUST_PROP_DOMAIN_ID2 IN VARCHAR2,
138 P_END_CUST_PROP_AUTH_ID2 IN VARCHAR2,
139 P_END_CUST_PROP_LOC_ID IN VARCHAR2,
140 P_END_CUST_ADD1 IN VARCHAR2,
141 P_END_CUST_ADD2 IN VARCHAR2,
142 P_END_CUST_ADD3 IN VARCHAR2,
143 P_END_CUST_CITY IN VARCHAR2,
144 P_END_CUST_COUNTRY IN VARCHAR2,
145 P_END_CUST_POSTAL_CODE IN VARCHAR2,
146 P_END_CUST_PO_BOX_ID IN VARCHAR2,
147 P_END_CUST_REGION IN VARCHAR2,
148 P_SHIP_FRM_SD_CLAIM_REQ_DATE IN DATE,
149 P_SHIP_FRM_SD_CLAIM_REQ_ID IN VARCHAR2,
150 P_CREDIT_REF_ID IN VARCHAR2,
151 P_DEBIT_REF_ID IN VARCHAR2,
152 P_BATCH_LINE_ID IN NUMBER,
153 P_BATCH_LINE_NUMBER IN NUMBER,
154 P_ORDER_DATE IN DATE,
155 P_ORDER_LINE_NUMBER IN NUMBER,
156 P_ORDER_NUMBER IN NUMBER,
157 P_INVOICE_DATE IN DATE,
158 P_INVOICE_LINE_NUMBER IN NUMBER,
159 P_INVOICE_NUMBER IN VARCHAR2,
160 P_COST_PRICE IN NUMBER,
161 P_COST_PRICE_CURR_CODE IN VARCHAR2,
162 P_AUTH_PRICE IN NUMBER,
163 P_AUTH_PRICE_CURR_CODE IN VARCHAR2,
164 P_RESALE_PRICE IN NUMBER,
165 P_RESALE_PRICE_CURR_CODE IN VARCHAR2,
166 P_UOM IN VARCHAR2,
167 P_LINE_STATUS IN VARCHAR2,
168 P_DISPOSITION_CODE1 IN VARCHAR2,
169 P_DISPOSITION_CODE2 IN VARCHAR2,
170 P_DISPOSITION_CODE3 IN VARCHAR2,
171 P_DISPOSITION_CODE4 IN VARCHAR2,
172 P_DISPOSITION_CODE5 IN VARCHAR2,
173 P_DISPOSITION_CODE6 IN VARCHAR2,
174 P_DISPOSITION_CODE7 IN VARCHAR2,
175 P_DISPOSITION_CODE8 IN VARCHAR2,
176 P_DISPOSITION_CODE9 IN VARCHAR2,
177 P_DISPOSITION_CODE10 IN VARCHAR2,
178 P_VENDOR_PART_NUMBER IN VARCHAR2,
179 P_DIST_PART_NUMBER IN VARCHAR2,
180 P_DATE_SHIPPED IN DATE,
181 P_QTY_SHIPPED IN NUMBER,
182 P_CLAIM_AMT_CURR_CODE IN VARCHAR2,
183 P_LAST_SUB_CLAIM_AMT IN NUMBER,
184 P_VENDOR_AUTH_LINE_ITEM_NO IN VARCHAR2,
185 P_VENDOR_APPRVD_AMT IN NUMBER,
186 P_VENDOR_APPRVD_AMT_CURR_CD IN VARCHAR2,
187 P_BATCH_SUBMISSION_DATE IN DATE,
188 P_BATCH_ID IN NUMBER,
189 P_TO_CNTCT1_NAME IN VARCHAR2,
190 P_TO_CNTCT1_EMAIL IN VARCHAR2,
191 P_TO_CNTCT1_FAX IN VARCHAR2,
192 P_TO_CNTCT1_PHONE IN VARCHAR2,
193 P_TO_GBL_PTNR_ROLE_CLASS_CD IN VARCHAR2,
194 P_TO_GBL_BUSINESS_ID IN NUMBER,
195 P_TO_GBL_SUPPLY_CHAIN_CD IN VARCHAR2,
196 P_TO_BUSINESS_NAME IN VARCHAR2,
197 P_TO_PROP_BUSINESS_ID1 IN VARCHAR2,
198 P_TO_PROP_DOMAIN_ID1 IN VARCHAR2,
199 P_TO_AUTH_ID1 IN VARCHAR2,
200 P_TO_GBL_PTNR_CLASS_CD IN VARCHAR2,
201 P_TO_CNTCT2_NAME IN VARCHAR2,
202 P_TO_CNTCT2_EMAIL IN VARCHAR2,
203 P_TO_CNTCT2_FAX IN VARCHAR2,
204 P_TO_CNTCT2_PHONE IN VARCHAR2,
205 P_TO_GBL_LOC_ID IN VARCHAR2,
206 P_TO_PROP_DOMAIN_ID2 IN VARCHAR2,
207 P_TO_PROP_AUTH_ID2 IN VARCHAR2,
208 P_TO_PROP_LOC_ID IN VARCHAR2,
209 P_TO_ADD_LINE1 IN VARCHAR2,
210 P_TO_ADD_LINE2 IN VARCHAR2,
211 P_TO_ADD_LINE3 IN VARCHAR2,
212 P_TO_CITY IN VARCHAR2,
213 P_TO_COUNTRY IN VARCHAR2,
214 P_TO_POSTAL_CODE IN VARCHAR2,
215 P_TO_PO_BOX_ID IN VARCHAR2,
216 P_TO_REGION IN VARCHAR2);
217
218 PROCEDURE UPDATE_DATA (
219 P_Batch_Number IN VARCHAR2,
220 x_return_status OUT NOCOPY VARCHAR2, --E,S
221 x_msg_data OUT NOCOPY VARCHAR2 --descr
222 );
223
224 procedure BATCH_CREATE_APPROVED_LINE_NEW(
225 P_Batch_ID IN NUMBER, x_return_status OUT nocopy VARCHAR2, x_msg_data OUT nocopy VARCHAR2
226 );
227
228
229 PROCEDURE PROCESS_CLAIM (p_batch_id IN NUMBER, x_return_status OUT nocopy VARCHAR2, x_msg_data OUT nocopy VARCHAR2);
230
231 PROCEDURE UPDATE_REJECTED_LINE_DATA (p_batch_number varchar2,p_batch_id number, new_batch_id number,
232 x_return_status OUT nocopy VARCHAR2, x_msg_data OUT nocopy VARCHAR2);
233
234
235 PROCEDURE UPDATE_DISPUTE_DATA (p_batch_number varchar2,p_batch_id number,new_batch_id number);
236
237 END OZF_SD_BATCH_FEED_PVT;
238