[Home] [Help]
PACKAGE: APPS.OZF_SD_REQUEST_PUB
Source
1 PACKAGE OZF_SD_REQUEST_PUB AUTHID CURRENT_USER AS
2 /* $Header: ozfpsdrs.pls 120.14 2011/10/15 06:04:00 nirprasa ship $ */
3 /*#
4 * This package can be used to Create,Update and Copy Ship & Debit Request
5 * @rep:scope public
6 * @rep:product OZF
7 * @rep:lifecycle active
8 * @rep:displayname OZF_SD_REQUEST Public API
9 * @rep:compatibility S
10 * @rep:businessevent None
11 * @rep:category BUSINESS_ENTITY OZF_SSD_REQUEST
12 */
13
14 -- -------------------------------------------------------
15 -- Record name SDR_Hdr_rec_type
16 -- -------------------------------------------------------
17 TYPE SDR_Hdr_rec_type IS RECORD
18 (
19 request_header_id NUMBER,
20 object_version_number NUMBER,
21 request_number VARCHAR2(30),
22 request_start_date DATE,
23 request_end_date DATE,
24 user_status_id NUMBER,
25 request_outcome VARCHAR2(30),
26 request_currency_code VARCHAR2(15),
27 authorization_number VARCHAR2(30),
28 attribute_category VARCHAR2(30),
29 attribute1 VARCHAR2(150),
30 attribute2 VARCHAR2(150),
31 attribute3 VARCHAR2(150),
32 attribute4 VARCHAR2(150),
33 attribute5 VARCHAR2(150),
34 attribute6 VARCHAR2(150),
35 attribute7 VARCHAR2(150),
36 attribute8 VARCHAR2(150),
37 attribute9 VARCHAR2(150),
38 attribute10 VARCHAR2(150),
39 attribute11 VARCHAR2(150),
40 attribute12 VARCHAR2(150),
41 attribute13 VARCHAR2(150),
42 attribute14 VARCHAR2(150),
43 attribute15 VARCHAR2(150),
44 supplier_id NUMBER,
45 supplier_site_id NUMBER,
46 supplier_contact_id NUMBER,
47 internal_submission_date DATE,
48 assignee_response_by_date DATE,
49 assignee_response_date DATE,
50 submtd_by_for_supp_approval NUMBER,
51 supplier_response_by_date DATE,
52 supplier_response_date DATE,
53 supplier_submission_date DATE,
54 requestor_id NUMBER,
55 supplier_quote_number VARCHAR2(250),
56 internal_order_number NUMBER,
57 sales_order_currency VARCHAR2(15),
58 assignee_resource_id NUMBER,
59 org_id NUMBER,
60 accrual_type VARCHAR2(30),
61 cust_account_id NUMBER,
62 request_description VARCHAR2(4000),
63 supplier_contact_email_address VARCHAR2(2000),
64 supplier_contact_phone_number VARCHAR2(60),
65 request_type_setup_id NUMBER,
66 request_basis VARCHAR2(1),
67 user_id NUMBER,
68 supplier_contact_name VARCHAR2(360) --//Bugfix 7822442
69 );
70
71 -- -------------------------------------------------------
72 -- Record name SDR_lines_rec_type
73 -- -------------------------------------------------------
74
75 TYPE SDR_lines_rec_type IS RECORD
76 (
77 request_line_id NUMBER,
78 object_version_number NUMBER,
79 request_header_id NUMBER,
80 product_context VARCHAR2(30),
81 inventory_item_id NUMBER,
82 prod_catg_id NUMBER,
83 product_cat_set_id NUMBER,
84 product_cost NUMBER,
85 item_uom VARCHAR2(30),
86 requested_discount_type VARCHAR2(30),
87 requested_discount_value NUMBER,
88 cost_basis NUMBER,
89 max_qty NUMBER,
90 limit_qty NUMBER,
91 design_win VARCHAR2(30),
92 end_customer_price NUMBER,
93 requested_line_amount NUMBER,
94 approved_discount_type VARCHAR2(30),
95 approved_discount_value NUMBER,
96 approved_max_qty NUMBER,
97 attribute_category VARCHAR2(30),
98 attribute1 VARCHAR2(150),
99 attribute2 VARCHAR2(150),
100 attribute3 VARCHAR2(150),
101 attribute4 VARCHAR2(150),
102 attribute5 VARCHAR2(150),
103 attribute6 VARCHAR2(150),
104 attribute7 VARCHAR2(150),
105 attribute8 VARCHAR2(150),
106 attribute9 VARCHAR2(150),
107 attribute10 VARCHAR2(150),
108 attribute11 VARCHAR2(150),
109 attribute12 VARCHAR2(150),
110 attribute13 VARCHAR2(150),
111 attribute14 VARCHAR2(150),
112 attribute15 VARCHAR2(150),
113 vendor_approved_flag VARCHAR2(1),
114 vendor_item_code VARCHAR2(240),
115 start_date DATE,
116 end_date DATE,
117 end_customer_price_type VARCHAR2(30),
118 end_customer_tolerance_type VARCHAR2(30),
119 end_customer_tolerance_value NUMBER,
120 org_id NUMBER,
121 rejection_code VARCHAR2(30),
122 requested_discount_currency VARCHAR2(15),
123 product_cost_currency VARCHAR2(15),
124 end_customer_currency VARCHAR2(15),
125 approved_discount_currency VARCHAR2(15),
126 create_from VARCHAR2(30)
127 );
128
129 TYPE SDR_lines_tbl_type IS TABLE OF SDR_lines_rec_type
130 INDEX BY BINARY_INTEGER;
131
132 -- -------------------------------------------------------
133 -- Record name SDR_cust_rec_type
134 -- -------------------------------------------------------
135 TYPE SDR_cust_rec_type IS RECORD
136 (
137 request_customer_id NUMBER,
138 object_version_number NUMBER,
139 request_header_id NUMBER,
140 cust_account_id NUMBER,
141 party_id NUMBER,
142 site_use_id NUMBER,
143 cust_usage_code VARCHAR2(30),
144 attribute_category VARCHAR2(30),
145 attribute1 VARCHAR2(150),
146 attribute2 VARCHAR2(150),
147 attribute3 VARCHAR2(150),
148 attribute4 VARCHAR2(150),
149 attribute5 VARCHAR2(150),
150 attribute6 VARCHAR2(150),
151 attribute7 VARCHAR2(150),
152 attribute8 VARCHAR2(150),
153 attribute9 VARCHAR2(150),
154 attribute10 VARCHAR2(150),
155 attribute11 VARCHAR2(150),
156 attribute12 VARCHAR2(150),
157 attribute13 VARCHAR2(150),
158 attribute14 VARCHAR2(150),
159 attribute15 VARCHAR2(150),
160 end_customer_flag VARCHAR2(1),
161 cust_usage_value VARCHAR2(240),
162 operation VARCHAR2(6) --ninarasi fix for bug 12656359
163
164 );
165 TYPE SDR_cust_tbl_type IS TABLE OF SDR_cust_rec_type
166 INDEX BY BINARY_INTEGER;
167
168 ---------------------------------------------------------------------
169 -- API Name
170 -- create_sd_request
171 --Type
172 -- Public
173 -- PURPOSE
174 -- This procedure creates Ship and Debit Request
175 --
176 -- PARAMETERS
177 -- IN
178 -- OUT
179 -- NOTES
180 /*#
181 * This procedure creates a new Ship & Debit Request.
182 * @param p_api_version_number --> Version of the API.
183 * @param p_init_msg_list --> Whether to initialize the message stack.
184 * @param p_commit --> Indicates whether to commit within the program.
185 * @param p_validation_level --> Indicates the level of the validation.
186 * @param x_return_status --> Indicates the status of the program.
187 * @param x_msg_count --> Provides the number of the messages returned by the program.
188 * @param x_msg_data --> Returns messages by the program.
189 * @param p_SDR_hdr_rec --> Contains details of the new SDR to be created
190 * @param p_SDR_lines_tbl --> Table structure contains the product line information for the new SDR
191 * @param p_SDR_cust_tbl --> Table structure contains the Customer information for the new SDR
192 * @param x_request_header_id --> Returns the id of the new SDR created.
193 * @rep:scope public
194 * @rep:lifecycle active
195 * @rep:displayname Create SDR
196 * @rep:compatibility S
197 * @rep:businessevent None
198 */
199
200 ---------------------------------------------------------------------
201 PROCEDURE create_sd_request(
202 p_api_version_number IN NUMBER,
203 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
204 p_commit IN VARCHAR2 := FND_API.G_FALSE,
205 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
206 x_return_status OUT NOCOPY VARCHAR2,
207 x_msg_count OUT NOCOPY NUMBER,
208 x_msg_data OUT NOCOPY VARCHAR2,
209 p_SDR_hdr_rec IN SDR_Hdr_rec_type,
210 p_SDR_lines_tbl IN SDR_lines_tbl_type,
211 p_SDR_cust_tbl IN SDR_cust_tbl_type,
212 x_request_header_id OUT NOCOPY NUMBER
213 );
214 ---------------------------------------------------------------------
215 -- API Name
216 -- update_sd_request
217 --Type
218 -- Public
219 -- PURPOSE
220 -- This procdure updates existing SDR
221 --
222 -- PARAMETERS
223 -- IN
224 -- OUT
225 -- NOTES
226 /*#
227 * This Procedure updates existinf Ship & Debit Request
228 * @param p_api_version_number --> Version of the API.
229 * @param p_init_msg_list --> Whether to initialize the message stack.
230 * @param p_commit --> Indicates whether to commit within the program.
231 * @param p_validation_level --> Indicates the level of the validation.
232 * @param x_return_status --> Indicates the status of the program.
233 * @param x_msg_count --> Provides the number of the messages returned by the program.
234 * @param x_msg_data --> Returns messages by the program.
235 * @param p_SDR_hdr_rec --> Contains details of the new SDR to be created
236 * @param p_SDR_lines_tbl --> Table structure contains the product line information for the new SDR
237 * @param p_SDR_cust_tbl --> Table structure contains the Customer information for the new SDR
238 * @rep:scope public
239 * @rep:lifecycle active
240 * @rep:displayname Update SD Request
241 * @rep:compatibility S
242 * @rep:businessevent None
243 */
244
245 ---------------------------------------------------------------------
246 PROCEDURE update_sd_request(
247 p_api_version_number IN NUMBER,
248 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
249 p_commit IN VARCHAR2 := FND_API.G_FALSE,
250 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
251 x_return_status OUT NOCOPY VARCHAR2,
252 x_msg_count OUT NOCOPY NUMBER,
253 x_msg_data OUT NOCOPY VARCHAR2,
254 p_SDR_hdr_rec IN SDR_Hdr_rec_type,
255 p_SDR_lines_tbl IN SDR_lines_tbl_type,
256 p_SDR_cust_tbl IN SDR_cust_tbl_type
257 );
258 ---------------------------------------------------------------------
259 -- API Name
260 -- copy_sd_request
261 --Type
262 -- Public
263 -- PURPOSE
264 -- This procdure Copies existing SDR
265 --
266 -- PARAMETERS
267 -- IN
268 -- OUT
269 -- NOTES
270 /*#
271 * This procedure Copies existing Ship & Debit Request.
272 * @param p_api_version_number --> Version of the API.
273 * @param p_init_msg_list --> Whether to initialize the message stack.
274 * @param p_commit --> Indicates whether to commit within the program.
275 * @param p_validation_level --> Indicates the level of the validation.
276 * @param x_return_status --> Indicates the status of the program.
277 * @param x_msg_count --> Provides the number of the messages returned by the program.
278 * @param x_msg_data --> Returns messages by the program.
279 * @param p_source_request_id --> Source Request header ID for Copy
280 * @param p_new_request_number --> New Request number
281 * @param p_accrual_type --> Accrual type , SUPPLIER/INTERNAL
282 * @param p_cust_account_id --> Customer Account Id , Mandatory for INTERNAL offers
283 * @param p_request_start_date --> Request Start date
284 * @param p_request_end_date --> Requrest End date
285 * @param p_copy_product_flag --> Flag Indicates weather to copy Product lines
286 * @param p_copy_customer_flag --> Flag Indicates weather to copy Customer Information
287 * @param p_copy_end_customer_flag --> Flag Indicates weather to copy End-Customer Information
288 * @param p_request_source --> Source of the Request : Manual/API
289 * @param x_request_header_id --> Returns new Request Header Id.
290
291 * @rep:scope public
292 * @rep:lifecycle active
293 * @rep:displayname copy_sd_request
294 * @rep:compatibility S
295 * @rep:businessevent None
296 */
297 ---------------------------------------------------------------------
298 PROCEDURE copy_sd_request(
299 p_api_version_number IN NUMBER,
300 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
301 p_commit IN VARCHAR2 := FND_API.G_FALSE,
302 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
303 x_return_status OUT NOCOPY VARCHAR2,
304 x_msg_count OUT NOCOPY NUMBER,
305 x_msg_data OUT NOCOPY VARCHAR2,
306 p_source_request_id IN VARCHAR2,
307 p_new_request_number IN VARCHAR2,
308 p_accrual_type IN VARCHAR2,
309 p_cust_account_id IN NUMBER,
310 p_request_start_date IN DATE,
311 p_request_end_date IN DATE,
312 p_copy_product_flag IN VARCHAR2 DEFAULT 'N',
313 p_copy_customer_flag IN VARCHAR2 DEFAULT 'N',
314 p_copy_end_customer_flag IN VARCHAR2 DEFAULT 'N',
315 p_request_source IN VARCHAR2 DEFAULT 'API',
316 x_request_header_id OUT NOCOPY NUMBER
317 );
318
319 END OZF_SD_REQUEST_PUB;