[Home] [Help]
PACKAGE: APPS.OZF_SD_REQUEST_PUB
Source
1 PACKAGE OZF_SD_REQUEST_PUB AUTHID CURRENT_USER AS
2 /* $Header: ozfpsdrs.pls 120.10.12010000.2 2009/02/04 09:22:16 bkunjan 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 );
127
128 TYPE SDR_lines_tbl_type IS TABLE OF SDR_lines_rec_type
129 INDEX BY BINARY_INTEGER;
130
131 -- -------------------------------------------------------
132 -- Record name SDR_cust_rec_type
133 -- -------------------------------------------------------
134 TYPE SDR_cust_rec_type IS RECORD
135 (
136 request_customer_id NUMBER,
137 object_version_number NUMBER,
138 request_header_id NUMBER,
139 cust_account_id NUMBER,
140 party_id NUMBER,
141 site_use_id NUMBER,
142 cust_usage_code VARCHAR2(30),
143 attribute_category VARCHAR2(30),
144 attribute1 VARCHAR2(150),
145 attribute2 VARCHAR2(150),
146 attribute3 VARCHAR2(150),
147 attribute4 VARCHAR2(150),
148 attribute5 VARCHAR2(150),
149 attribute6 VARCHAR2(150),
150 attribute7 VARCHAR2(150),
151 attribute8 VARCHAR2(150),
152 attribute9 VARCHAR2(150),
153 attribute10 VARCHAR2(150),
154 attribute11 VARCHAR2(150),
155 attribute12 VARCHAR2(150),
156 attribute13 VARCHAR2(150),
157 attribute14 VARCHAR2(150),
158 attribute15 VARCHAR2(150),
159 end_customer_flag VARCHAR2(1)
160 );
161 TYPE SDR_cust_tbl_type IS TABLE OF SDR_cust_rec_type
162 INDEX BY BINARY_INTEGER;
163
164 ---------------------------------------------------------------------
165 -- API Name
166 -- create_sd_request
167 --Type
168 -- Public
169 -- PURPOSE
170 -- This procedure creates Ship and Debit Request
171 --
172 -- PARAMETERS
173 -- IN
174 -- OUT
175 -- NOTES
176 /*#
177 * This procedure creates a new Ship & Debit Request.
178 * @param p_api_version_number --> Version of the API.
179 * @param p_init_msg_list --> Whether to initialize the message stack.
180 * @param p_commit --> Indicates whether to commit within the program.
181 * @param p_validation_level --> Indicates the level of the validation.
182 * @param x_return_status --> Indicates the status of the program.
183 * @param x_msg_count --> Provides the number of the messages returned by the program.
184 * @param x_msg_data --> Returns messages by the program.
185 * @param p_SDR_hdr_rec --> Contains details of the new SDR to be created
186 * @param p_SDR_lines_tbl --> Table structure contains the product line information for the new SDR
187 * @param p_SDR_cust_tbl --> Table structure contains the Customer information for the new SDR
188 * @param x_request_header_id --> Returns the id of the new SDR created.
189 * @rep:scope public
190 * @rep:lifecycle active
191 * @rep:displayname Create SDR
192 * @rep:compatibility S
193 * @rep:businessevent None
194 */
195
196 ---------------------------------------------------------------------
197 PROCEDURE create_sd_request(
198 p_api_version_number IN NUMBER,
199 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
200 p_commit IN VARCHAR2 := FND_API.G_FALSE,
201 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
202 x_return_status OUT NOCOPY VARCHAR2,
203 x_msg_count OUT NOCOPY NUMBER,
204 x_msg_data OUT NOCOPY VARCHAR2,
205 p_SDR_hdr_rec IN SDR_Hdr_rec_type,
206 p_SDR_lines_tbl IN SDR_lines_tbl_type,
207 p_SDR_cust_tbl IN SDR_cust_tbl_type,
208 x_request_header_id OUT NOCOPY NUMBER
209 );
210 ---------------------------------------------------------------------
211 -- API Name
212 -- update_sd_request
213 --Type
214 -- Public
215 -- PURPOSE
216 -- This procdure updates existing SDR
217 --
218 -- PARAMETERS
219 -- IN
220 -- OUT
221 -- NOTES
222 /*#
223 * This Procedure updates existinf Ship & Debit Request
224 * @param p_api_version_number --> Version of the API.
225 * @param p_init_msg_list --> Whether to initialize the message stack.
226 * @param p_commit --> Indicates whether to commit within the program.
227 * @param p_validation_level --> Indicates the level of the validation.
228 * @param x_return_status --> Indicates the status of the program.
229 * @param x_msg_count --> Provides the number of the messages returned by the program.
230 * @param x_msg_data --> Returns messages by the program.
231 * @param p_SDR_hdr_rec --> Contains details of the new SDR to be created
232 * @param p_SDR_lines_tbl --> Table structure contains the product line information for the new SDR
233 * @param p_SDR_cust_tbl --> Table structure contains the Customer information for the new SDR
234 * @rep:scope public
235 * @rep:lifecycle active
236 * @rep:displayname Update SD Request
237 * @rep:compatibility S
238 * @rep:businessevent None
239 */
240
241 ---------------------------------------------------------------------
242 PROCEDURE update_sd_request(
243 p_api_version_number IN NUMBER,
244 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
245 p_commit IN VARCHAR2 := FND_API.G_FALSE,
246 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
247 x_return_status OUT NOCOPY VARCHAR2,
248 x_msg_count OUT NOCOPY NUMBER,
249 x_msg_data OUT NOCOPY VARCHAR2,
250 p_SDR_hdr_rec IN SDR_Hdr_rec_type,
251 p_SDR_lines_tbl IN SDR_lines_tbl_type,
252 p_SDR_cust_tbl IN SDR_cust_tbl_type
253 );
254 ---------------------------------------------------------------------
255 -- API Name
256 -- copy_sd_request
257 --Type
258 -- Public
259 -- PURPOSE
260 -- This procdure Copies existing SDR
261 --
262 -- PARAMETERS
263 -- IN
264 -- OUT
265 -- NOTES
266 /*#
267 * This procedure Copies existing Ship & Debit Request.
268 * @param p_api_version_number --> Version of the API.
269 * @param p_init_msg_list --> Whether to initialize the message stack.
270 * @param p_commit --> Indicates whether to commit within the program.
271 * @param p_validation_level --> Indicates the level of the validation.
272 * @param x_return_status --> Indicates the status of the program.
273 * @param x_msg_count --> Provides the number of the messages returned by the program.
274 * @param x_msg_data --> Returns messages by the program.
275 * @param p_source_request_id --> Source Request header ID for Copy
276 * @param p_new_request_number --> New Request number
277 * @param p_accrual_type --> Accrual type , SUPPLIER/INTERNAL
278 * @param p_cust_account_id --> Customer Account Id , Mandatory for INTERNAL offers
279 * @param p_request_start_date --> Request Start date
280 * @param p_request_end_date --> Requrest End date
281 * @param p_copy_product_flag --> Flag Indicates weather to copy Product lines
282 * @param p_copy_customer_flag --> Flag Indicates weather to copy Customer Information
283 * @param p_copy_end_customer_flag --> Flag Indicates weather to copy End-Customer Information
284 * @param p_request_source --> Source of the Request : Manual/API
285 * @param x_request_header_id --> Returns new Request Header Id.
286
287 * @rep:scope public
288 * @rep:lifecycle active
289 * @rep:displayname copy_sd_request
290 * @rep:compatibility S
291 * @rep:businessevent None
292 */
293 ---------------------------------------------------------------------
294 PROCEDURE copy_sd_request(
295 p_api_version_number IN NUMBER,
296 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
297 p_commit IN VARCHAR2 := FND_API.G_FALSE,
298 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
299 x_return_status OUT NOCOPY VARCHAR2,
300 x_msg_count OUT NOCOPY NUMBER,
301 x_msg_data OUT NOCOPY VARCHAR2,
302 p_source_request_id IN VARCHAR2,
303 p_new_request_number IN VARCHAR2,
304 p_accrual_type IN VARCHAR2,
305 p_cust_account_id IN NUMBER,
306 p_request_start_date IN DATE,
307 p_request_end_date IN DATE,
308 p_copy_product_flag IN VARCHAR2 DEFAULT 'N',
309 p_copy_customer_flag IN VARCHAR2 DEFAULT 'N',
310 p_copy_end_customer_flag IN VARCHAR2 DEFAULT 'N',
311 p_request_source IN VARCHAR2 DEFAULT 'API',
312 x_request_header_id OUT NOCOPY NUMBER
313 );
314
315 END OZF_SD_REQUEST_PUB;