[Home] [Help]
PACKAGE BODY: APPS.OZF_SD_REQUEST_HEADER_PKG
Source
1 PACKAGE BODY OZF_SD_REQUEST_HEADER_PKG AS
2 /* $Header: ozftshdb.pls 120.0.12010000.2 2009/02/04 09:20:21 bkunjan ship $ */
3
4 G_PKG_NAME CONSTANT VARCHAR2(30):= 'OZF_SD_REQUEST_HEADER_PKG';
5 G_FILE_NAME CONSTANT VARCHAR2(15) := 'ozftshdb.pls';
6
7 PROCEDURE Insert_Row(
8 p_request_header_id NUMBER,
9 p_object_version_NUMBER NUMBER,
10 p_last_update_date DATE,
11 p_last_updated_by NUMBER,
12 p_creation_date DATE,
13 p_created_by NUMBER,
14 p_last_update_login NUMBER,
15 p_request_id NUMBER,
16 p_program_application_id NUMBER,
17 p_program_update_date DATE,
18 p_program_id NUMBER,
19 p_created_from VARCHAR2,
20 p_request_number VARCHAR2,
21 p_request_class VARCHAR2,
22 p_offer_type VARCHAR2,
23 p_offer_id NUMBER,
24 p_root_request_header_id NUMBER,
25 p_linked_request_header_id NUMBER,
26 p_request_start_date DATE,
27 p_request_end_date DATE,
28 p_user_status_id VARCHAR2,
29 p_request_outcome VARCHAR2,
30 p_decline_reason_code VARCHAR2,
31 p_return_reason_code VARCHAR2,
32 p_request_currency_code VARCHAR2,
33 p_authorization_number VARCHAR2,
34 p_sd_requested_budget_amount NUMBER,
35 p_sd_approved_budget_amount NUMBER,
36 p_attribute_category VARCHAR2,
37 p_attribute1 VARCHAR2,
38 p_attribute2 VARCHAR2,
39 p_attribute3 VARCHAR2,
40 p_attribute4 VARCHAR2,
41 p_attribute5 VARCHAR2,
42 p_attribute6 VARCHAR2,
43 p_attribute7 VARCHAR2,
44 p_attribute8 VARCHAR2,
45 p_attribute9 VARCHAR2,
46 p_attribute10 VARCHAR2,
47 p_attribute11 VARCHAR2,
48 p_attribute12 VARCHAR2,
49 p_attribute13 VARCHAR2,
50 p_attribute14 VARCHAR2,
51 p_attribute15 VARCHAR2,
52 p_supplier_id NUMBER,
53 p_supplier_site_id NUMBER,
54 p_supplier_contact_id NUMBER,
55 p_internal_submission_date DATE,
56 p_assignee_response_by_date DATE,
57 p_assignee_response_date DATE,
58 p_submtd_by_for_supp_appr VARCHAR2,
59 p_supplier_response_by_date DATE,
60 p_supplier_response_date DATE,
61 p_supplier_submission_date DATE,
62 p_requestor_id NUMBER,
63 p_supplier_quote_number VARCHAR2,
64 p_internal_order_number NUMBER,
65 p_sales_order_currency VARCHAR2,
66 p_request_source VARCHAR2,
67 p_assignee_resource_id NUMBER,
68 p_org_id NUMBER,
69 p_security_group_id NUMBER,
70 p_accrual_type VARCHAR2,
71 p_cust_account_id VARCHAR2,
72 p_supplier_email VARCHAR2,
73 p_supplier_phone VARCHAR2,
74 p_request_type_setup_id NUMBER,
75 p_request_basis VARCHAR2,
76 p_supplier_contact_name VARCHAR2) --//Bugfix 7822442
77 IS
78
79 BEGIN
80 INSERT INTO ozf_sd_request_headers_all_b(
81 request_header_id,
82 object_version_number,
83 last_update_date,
84 last_updated_by,
85 creation_date,
86 created_by,
87 last_update_login,
88 request_id,
89 program_application_id,
90 program_update_date,
91 program_id,
92 created_from,
93 request_number,
94 request_class,
95 offer_type,
96 offer_id,
97 root_request_header_id,
98 linked_request_header_id,
99 request_start_date,
100 request_end_date,
101 user_status_id,
102 request_outcome,
103 decline_reason_code,
104 return_reason_code,
105 request_currency_code,
106 authorization_number,
107 requested_budget_amount,
108 approved_budget_amount,
109 attribute_category,
110 attribute1,
111 attribute2,
112 attribute3,
113 attribute4,
114 attribute5,
115 attribute6,
116 attribute7,
117 attribute8,
118 attribute9,
119 attribute10,
120 attribute11,
121 attribute12,
122 attribute13,
123 attribute14,
124 attribute15,
125 supplier_id,
126 supplier_site_id,
127 supplier_contact_id,
128 internal_submission_date,
129 asignee_response_by_date,
130 asignee_response_date,
131 submtd_by_for_supp_approval,
132 supplier_response_by_date,
133 supplier_response_date,
134 supplier_submission_date,
135 requestor_id,
136 supplier_quote_number,
137 internal_order_number,
138 sales_order_currency,
139 request_source,
140 asignee_resource_id,
141 org_id,
142 security_group_id,
143 accrual_type,
144 cust_account_id,
145 supplier_contact_email_address,
146 supplier_contact_phone_number,
147 request_type_setup_id,
148 request_basis,
149 supplier_contact_name)
150 VALUES(
151 p_request_header_id,
152 p_object_version_number,
153 p_last_update_date,
154 p_last_updated_by,
155 p_creation_date,
156 p_created_by,
157 p_last_update_login,
158 p_request_id,
159 p_program_application_id,
160 p_program_update_date,
161 p_program_id,
162 p_created_from,
163 p_request_number,
164 p_request_class,
165 p_offer_type,
166 p_offer_id,
167 p_root_request_header_id,
168 p_linked_request_header_id,
169 p_request_start_date,
170 p_request_end_date,
171 p_user_status_id,
172 p_request_outcome,
173 p_decline_reason_code,
174 p_return_reason_code,
175 p_request_currency_code,
176 p_authorization_number,
177 p_sd_requested_budget_amount,
178 p_sd_approved_budget_amount,
179 p_attribute_category,
180 p_attribute1,
181 p_attribute2,
182 p_attribute3,
183 p_attribute4,
184 p_attribute5,
185 p_attribute6,
186 p_attribute7,
187 p_attribute8,
188 p_attribute9,
189 p_attribute10,
190 p_attribute11,
191 p_attribute12,
192 p_attribute13,
193 p_attribute14,
194 p_attribute15,
195 p_supplier_id,
196 p_supplier_site_id,
197 p_supplier_contact_id,
198 p_internal_submission_date,
199 p_assignee_response_by_date,
200 p_assignee_response_date,
201 p_submtd_by_for_supp_appr,
202 p_supplier_response_by_date,
203 p_supplier_response_date,
204 p_supplier_submission_date,
205 p_requestor_id,
206 p_supplier_quote_number,
207 p_internal_order_number,
208 p_sales_order_currency,
209 p_request_source,
210 p_assignee_resource_id,
211 p_org_id,
212 p_security_group_id,
213 p_accrual_type,
214 p_cust_account_id,
215 p_supplier_email,
216 p_supplier_phone,
217 p_request_type_setup_id,
218 p_request_basis,
219 p_supplier_contact_name);
220
221 END Insert_Row;
222
223 PROCEDURE Update_Row(
224 p_request_header_id NUMBER,
225 p_object_version_number NUMBER,
226 p_last_update_date DATE,
227 p_last_updated_by NUMBER,
228 p_last_update_login NUMBER,
229 p_request_id NUMBER,
230 p_program_application_id NUMBER,
231 p_program_update_date DATE,
232 p_program_id NUMBER,
233 p_created_from VARCHAR2,
234 p_request_number VARCHAR2,
235 p_request_class VARCHAR2,
236 p_offer_type VARCHAR2,
237 p_offer_id NUMBER,
238 p_root_request_header_id NUMBER,
239 p_linked_request_header_id NUMBER,
240 p_request_start_date DATE,
241 p_request_end_date DATE,
242 p_user_status_id VARCHAR2,
243 p_request_outcome VARCHAR2,
244 p_decline_reason_code VARCHAR2,
245 p_return_reason_code VARCHAR2,
246 p_request_currency_code VARCHAR2,
247 p_authorization_number VARCHAR2,
248 p_sd_requested_budget_amount NUMBER,
249 p_sd_approved_budget_amount NUMBER,
250 p_attribute_category VARCHAR2,
251 p_attribute1 VARCHAR2,
252 p_attribute2 VARCHAR2,
253 p_attribute3 VARCHAR2,
254 p_attribute4 VARCHAR2,
255 p_attribute5 VARCHAR2,
256 p_attribute6 VARCHAR2,
257 p_attribute7 VARCHAR2,
258 p_attribute8 VARCHAR2,
259 p_attribute9 VARCHAR2,
260 p_attribute10 VARCHAR2,
261 p_attribute11 VARCHAR2,
262 p_attribute12 VARCHAR2,
263 p_attribute13 VARCHAR2,
264 p_attribute14 VARCHAR2,
265 p_attribute15 VARCHAR2,
266 p_supplier_id NUMBER,
267 p_supplier_site_id NUMBER,
268 p_supplier_contact_id NUMBER,
269 p_internal_submission_date DATE,
270 p_assignee_response_by_date DATE,
271 p_assignee_response_date DATE,
272 p_submtd_by_for_supp_appr VARCHAR2,
273 p_supplier_response_by_date DATE,
274 p_supplier_response_date DATE,
275 p_supplier_submission_date DATE,
276 p_requestor_id NUMBER,
277 p_supplier_quote_number VARCHAR2,
278 p_internal_order_number NUMBER,
279 p_sales_order_currency VARCHAR2,
280 p_request_source VARCHAR2,
281 p_assignee_resource_id NUMBER,
282 p_org_id NUMBER,
283 p_security_group_id NUMBER,
284 p_accrual_type VARCHAR2,
285 p_cust_account_id VARCHAR2,
286 p_supplier_email VARCHAR2,
287 p_supplier_phone VARCHAR2,
288 p_request_type_setup_id NUMBER,
289 p_request_basis VARCHAR2,
290 p_supplier_contact_name VARCHAR2) --//Bugfix 7822442
291 IS
292 BEGIN
293 UPDATE OZF_SD_REQUEST_HEADERS_ALL_B
294 SET
295 object_version_number = p_object_version_number,
296 last_update_date = p_last_update_date,
297 last_updated_by = p_last_updated_by,
298 last_update_login = p_last_update_login,
299 request_id = p_request_id,
300 program_application_id = p_program_application_id,
301 program_update_date = p_program_update_date,
302 program_id = p_program_id,
303 created_from = p_created_from,
304 request_number = p_request_number,
305 request_class = p_request_class,
306 offer_type = p_offer_type,
307 offer_id = p_offer_id,
308 root_request_header_id = p_root_request_header_id,
309 linked_request_header_id = p_linked_request_header_id,
310 request_start_date = p_request_start_date,
311 request_end_date = p_request_end_date,
312 user_status_id = p_user_status_id,
313 request_outcome = p_request_outcome,
314 decline_reason_code = p_decline_reason_code,
315 return_reason_code = p_return_reason_code,
316 request_currency_code = p_request_currency_code,
317 authorization_number = p_authorization_number,
318 requested_budget_amount = p_sd_requested_budget_amount,
319 approved_budget_amount = p_sd_approved_budget_amount,
320 attribute_category = p_attribute_category,
321 attribute1 = p_attribute1,
322 attribute2 = p_attribute2,
323 attribute3 = p_attribute3,
324 attribute4 = p_attribute4,
325 attribute5 = p_attribute5,
326 attribute6 = p_attribute6,
327 attribute7 = p_attribute7,
328 attribute8 = p_attribute8,
329 attribute9 = p_attribute9,
330 attribute10 = p_attribute10,
331 attribute11 = p_attribute11,
332 attribute12 = p_attribute12,
333 attribute13 = p_attribute13,
334 attribute14 = p_attribute14,
335 attribute15 = p_attribute15,
336 supplier_id = p_supplier_id,
337 supplier_site_id = p_supplier_site_id,
338 supplier_contact_id = p_supplier_contact_id,
339 internal_submission_date = p_internal_submission_date,
340 asignee_response_by_date = p_assignee_response_by_date,
341 asignee_response_date = p_assignee_response_date,
342 submtd_by_for_supp_approval = p_submtd_by_for_supp_appr,
343 supplier_response_by_date = p_supplier_response_by_date,
344 supplier_response_date = p_supplier_response_date,
345 supplier_submission_date = p_supplier_submission_date,
346 requestor_id = p_requestor_id,
347 supplier_quote_number = p_supplier_quote_number,
348 internal_order_number = p_internal_order_number,
349 sales_order_currency = p_sales_order_currency,
350 request_source = p_request_source,
351 asignee_resource_id = p_assignee_resource_id,
352 org_id = p_org_id,
353 security_group_id = p_security_group_id,
354 accrual_type = p_accrual_type,
355 cust_account_id = p_cust_account_id,
356 supplier_contact_email_address = p_supplier_email,
357 supplier_contact_phone_number = p_supplier_phone,
358 request_type_setup_id = p_request_type_setup_id,
359 request_basis = p_request_basis,
360 supplier_contact_name = p_supplier_contact_name --//Bugfix 7822442
361 WHERE
362 request_header_id=p_request_header_id;
363
364 END Update_Row;
365 END OZF_SD_REQUEST_HEADER_PKG;