[Home] [Help]
PACKAGE BODY: APPS.ASO_ORDER_FEEDBACK_GET_PVT
Source
1 PACKAGE BODY ASO_ORDER_FEEDBACK_GET_PVT AS
2 /* $Header: asovomgb.pls 120.1 2005/06/29 12:42:29 appldev ship $ */
3
4
5 -- ---------------------------------------------------------
6 -- Define global variables
7 -- ---------------------------------------------------------
8 G_PKG_NAME CONSTANT VARCHAR2(30) := 'ASO_ORDER_FEEDBACK_GET_PVT';
9 G_USER CONSTANT VARCHAR2(30) := FND_GLOBAL.USER_ID;
10
11
12 -- ---------------------------------------------------------
13 -- Define Procedures
14 -- ---------------------------------------------------------
15
16 --------------------------------------------------------------------------
17 -- Header
18
19 PROCEDURE Header_Type_To_Rec
20 (
21 p_header_type IN SYSTEM.ASO_Header_Type,
22 x_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type
23 )
24 IS
25
26 BEGIN
27 IF p_header_type is NULL THEN
28 x_header_rec := OE_Order_PUB.G_MISS_HEADER_REC;
29 return;
30 END IF;
31
32 x_header_rec.accounting_rule_id := p_header_type.accounting_rule_id;
33 x_header_rec.agreement_id := p_header_type.agreement_id;
34 x_header_rec.attribute1 := p_header_type.attribute1;
35 x_header_rec.attribute10 := p_header_type.attribute10;
36 x_header_rec.attribute11 := p_header_type.attribute11;
37 x_header_rec.attribute12 := p_header_type.attribute12;
38 x_header_rec.attribute13 := p_header_type.attribute13;
39 x_header_rec.attribute14 := p_header_type.attribute14;
40 x_header_rec.attribute15 := p_header_type.attribute15;
41 x_header_rec.attribute2 := p_header_type.attribute2;
42 x_header_rec.attribute3 := p_header_type.attribute3;
43 x_header_rec.attribute4 := p_header_type.attribute4;
44 x_header_rec.attribute5 := p_header_type.attribute5;
45 x_header_rec.attribute6 := p_header_type.attribute6;
46 x_header_rec.attribute7 := p_header_type.attribute7;
47 x_header_rec.attribute8 := p_header_type.attribute8;
48 x_header_rec.attribute9 := p_header_type.attribute9;
49 x_header_rec.booked_flag := p_header_type.booked_flag;
50 x_header_rec.cancelled_flag := p_header_type.cancelled_flag;
51 x_header_rec.context := p_header_type.context;
52 x_header_rec.conversion_rate := p_header_type.conversion_rate;
53 x_header_rec.conversion_rate_date := p_header_type.conversion_rate_date;
54 x_header_rec.conversion_type_code := p_header_type.conversion_type_code;
55 x_header_rec.created_by := p_header_type.created_by;
56 x_header_rec.creation_date := p_header_type.creation_date;
57 x_header_rec.cust_po_number := p_header_type.cust_po_number;
58 x_header_rec.deliver_to_contact_id := p_header_type.deliver_to_contact_id;
59 x_header_rec.deliver_to_org_id := p_header_type.deliver_to_org_id;
60 x_header_rec.demand_class_code := p_header_type.demand_class_code;
61 x_header_rec.earliest_schedule_limit := p_header_type.earliest_schedule_limit;
62 x_header_rec.expiration_date := p_header_type.expiration_date;
63 x_header_rec.fob_point_code := p_header_type.fob_point_code;
64 x_header_rec.freight_carrier_code := p_header_type.freight_carrier_code;
65 x_header_rec.freight_terms_code := p_header_type.freight_terms_code;
66 x_header_rec.global_attribute1 := p_header_type.global_attribute1;
67 x_header_rec.global_attribute10 := p_header_type.global_attribute10;
68 x_header_rec.global_attribute11 := p_header_type.global_attribute11;
69 x_header_rec.global_attribute12 := p_header_type.global_attribute12;
70 x_header_rec.global_attribute13 := p_header_type.global_attribute13;
71 x_header_rec.global_attribute14 := p_header_type.global_attribute14;
72 x_header_rec.global_attribute15 := p_header_type.global_attribute15;
73 x_header_rec.global_attribute16 := p_header_type.global_attribute16;
74 x_header_rec.global_attribute17 := p_header_type.global_attribute17;
75 x_header_rec.global_attribute18 := p_header_type.global_attribute18;
76 x_header_rec.global_attribute19 := p_header_type.global_attribute19;
77 x_header_rec.global_attribute2 := p_header_type.global_attribute2;
78 x_header_rec.global_attribute20 := p_header_type.global_attribute20;
79 x_header_rec.global_attribute3 := p_header_type.global_attribute3;
80 x_header_rec.global_attribute4 := p_header_type.global_attribute4;
81 x_header_rec.global_attribute5 := p_header_type.global_attribute5;
82 x_header_rec.global_attribute6 := p_header_type.global_attribute6;
83 x_header_rec.global_attribute7 := p_header_type.global_attribute7;
84 x_header_rec.global_attribute8 := p_header_type.global_attribute8;
85 x_header_rec.global_attribute9 := p_header_type.global_attribute9;
86 x_header_rec.global_attribute_category := p_header_type.global_attribute_category;
87 x_header_rec.TP_CONTEXT := p_header_type.TP_CONTEXT;
88 x_header_rec.TP_ATTRIBUTE1 := p_header_type.TP_ATTRIBUTE1;
89 x_header_rec.TP_ATTRIBUTE2 := p_header_type.TP_ATTRIBUTE2;
90 x_header_rec.TP_ATTRIBUTE3 := p_header_type.TP_ATTRIBUTE3;
91 x_header_rec.TP_ATTRIBUTE4 := p_header_type.TP_ATTRIBUTE4;
92 x_header_rec.TP_ATTRIBUTE5 := p_header_type.TP_ATTRIBUTE5;
93 x_header_rec.TP_ATTRIBUTE6 := p_header_type.TP_ATTRIBUTE6;
94 x_header_rec.TP_ATTRIBUTE7 := p_header_type.TP_ATTRIBUTE7;
95 x_header_rec.TP_ATTRIBUTE8 := p_header_type.TP_ATTRIBUTE8;
96 x_header_rec.TP_ATTRIBUTE9 := p_header_type.TP_ATTRIBUTE9;
97 x_header_rec.TP_ATTRIBUTE10 := p_header_type.TP_ATTRIBUTE10;
98 x_header_rec.TP_ATTRIBUTE11 := p_header_type.TP_ATTRIBUTE11;
99 x_header_rec.TP_ATTRIBUTE12 := p_header_type.TP_ATTRIBUTE12;
100 x_header_rec.TP_ATTRIBUTE13 := p_header_type.TP_ATTRIBUTE13;
101 x_header_rec.TP_ATTRIBUTE14 := p_header_type.TP_ATTRIBUTE14;
102 x_header_rec.TP_ATTRIBUTE15 := p_header_type.TP_ATTRIBUTE15;
103 x_header_rec.header_id := p_header_type.header_id;
104 x_header_rec.invoice_to_contact_id := p_header_type.invoice_to_contact_id;
105 x_header_rec.invoice_to_org_id := p_header_type.invoice_to_org_id;
106 x_header_rec.invoicing_rule_id := p_header_type.invoicing_rule_id;
107 x_header_rec.last_updated_by := p_header_type.last_updated_by;
108 x_header_rec.last_update_date := p_header_type.last_update_date;
109 x_header_rec.last_update_login := p_header_type.last_update_login;
110 x_header_rec.latest_schedule_limit := p_header_type.latest_schedule_limit;
111 x_header_rec.open_flag := p_header_type.open_flag;
112 x_header_rec.order_category_code := p_header_type.order_category_code;
113 x_header_rec.ordered_date := p_header_type.ordered_date;
114 x_header_rec.order_date_type_code := p_header_type.order_date_type_code;
115 x_header_rec.order_number := p_header_type.order_number;
116 x_header_rec.order_source_id := p_header_type.order_source_id;
117 x_header_rec.order_type_id := p_header_type.order_type_id;
118 x_header_rec.org_id := p_header_type.org_id;
119 x_header_rec.orig_sys_document_ref := p_header_type.orig_sys_document_ref;
120 x_header_rec.partial_shipments_allowed := p_header_type.partial_shipments_allowed;
121 x_header_rec.payment_term_id := p_header_type.payment_term_id;
122 x_header_rec.price_list_id := p_header_type.price_list_id;
123 x_header_rec.pricing_date := p_header_type.pricing_date;
124 x_header_rec.program_application_id := p_header_type.program_application_id;
125 x_header_rec.program_id := p_header_type.program_id;
126 x_header_rec.program_update_date := p_header_type.program_update_date;
127 x_header_rec.request_date := p_header_type.request_date;
128 x_header_rec.request_id := p_header_type.request_id;
129 x_header_rec.return_reason_code := p_header_type.return_reason_code;
130 x_header_rec.salesrep_id := p_header_type.salesrep_id;
131 x_header_rec.sales_channel_code := p_header_type.sales_channel_code;
132 x_header_rec.shipment_priority_code := p_header_type.shipment_priority_code;
133 x_header_rec.shipping_method_code := p_header_type.shipping_method_code;
134 x_header_rec.ship_from_org_id := p_header_type.ship_from_org_id;
135 x_header_rec.ship_tolerance_above := p_header_type.ship_tolerance_above;
136 x_header_rec.ship_tolerance_below := p_header_type.ship_tolerance_below;
137 x_header_rec.ship_to_contact_id := p_header_type.ship_to_contact_id;
138 x_header_rec.ship_to_org_id := p_header_type.ship_to_org_id;
139 x_header_rec.sold_from_org_id := p_header_type.sold_from_org_id;
140 x_header_rec.sold_to_contact_id := p_header_type.sold_to_contact_id;
141 x_header_rec.sold_to_org_id := p_header_type.sold_to_org_id;
142 x_header_rec.source_document_id := p_header_type.source_document_id;
143 x_header_rec.source_document_type_id := p_header_type.source_document_type_id;
144 x_header_rec.tax_exempt_flag := p_header_type.tax_exempt_flag;
145 x_header_rec.tax_exempt_number := p_header_type.tax_exempt_number;
146 x_header_rec.tax_exempt_reason_code := p_header_type.tax_exempt_reason_code;
147 x_header_rec.tax_point_code := p_header_type.tax_point_code;
148 x_header_rec.transactional_curr_code := p_header_type.transactional_curr_code;
149 x_header_rec.version_number := p_header_type.version_number;
150 x_header_rec.return_status := p_header_type.return_status;
151 x_header_rec.db_flag := p_header_type.db_flag;
152 x_header_rec.operation := p_header_type.operation;
153 x_header_rec.first_ack_code := p_header_type.first_ack_code;
154 x_header_rec.first_ack_date := p_header_type.first_ack_date;
155 x_header_rec.last_ack_code := p_header_type.last_ack_code;
156 x_header_rec.last_ack_date := p_header_type.last_ack_date;
157 x_header_rec.change_reason := p_header_type.change_reason;
158 x_header_rec.change_comments := p_header_type.change_comments;
159 x_header_rec.change_sequence := p_header_type.change_sequence;
160 x_header_rec.change_request_code := p_header_type.change_request_code;
161 x_header_rec.ready_flag := p_header_type.ready_flag;
162 x_header_rec.status_flag := p_header_type.status_flag;
163 x_header_rec.force_apply_flag := p_header_type.force_apply_flag;
164 x_header_rec.drop_ship_flag := p_header_type.drop_ship_flag;
165 x_header_rec.customer_payment_term_id := p_header_type.customer_payment_term_id;
166 x_header_rec.payment_type_code := p_header_type.payment_type_code;
167 x_header_rec.payment_amount := p_header_type.payment_amount;
168 x_header_rec.check_number := p_header_type.check_number;
169 x_header_rec.credit_card_code := p_header_type.credit_card_code;
170 x_header_rec.credit_card_holder_name := p_header_type.credit_card_holder_name;
171 x_header_rec.credit_card_number := p_header_type.credit_card_number;
172 x_header_rec.credit_card_expiration_date := p_header_type.credit_card_expiration_date;
173 x_header_rec.credit_card_approval_code := p_header_type.credit_card_approval_code;
174 x_header_rec.shipping_instructions := p_header_type.shipping_instructions;
175 x_header_rec.packing_instructions := p_header_type.packing_instructions;
176 x_header_rec.flow_status_code := p_header_type.flow_status_code;
177
178 END Header_Type_To_Rec;
179
180
181 -- Header Adjs
182
183
184 PROCEDURE Header_Adj_Var_To_Tbl
185 (
186 p_header_adj_varray IN SYSTEM.ASO_Header_Adj_Var_Type,
187 x_header_adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type
188 )
189 IS
190 i NUMBER;
191
192 BEGIN
193 IF p_header_adj_varray is NULL THEN
194 x_header_adj_tbl := OE_Order_PUB.G_MISS_HEADER_ADJ_TBL;
195 return;
196 END IF;
197
198 i := p_header_adj_varray.FIRST;
199 WHILE i IS NOT NULL LOOP
200 x_header_adj_tbl(i).attribute1 := p_header_adj_varray(i).attribute1;
201 x_header_adj_tbl(i).attribute10 := p_header_adj_varray(i).attribute10;
202 x_header_adj_tbl(i).attribute11 := p_header_adj_varray(i).attribute11;
203 x_header_adj_tbl(i).attribute12 := p_header_adj_varray(i).attribute12;
204 x_header_adj_tbl(i).attribute13 := p_header_adj_varray(i).attribute13;
205 x_header_adj_tbl(i).attribute14 := p_header_adj_varray(i).attribute14;
206 x_header_adj_tbl(i).attribute15 := p_header_adj_varray(i).attribute15;
207 x_header_adj_tbl(i).attribute2 := p_header_adj_varray(i).attribute2;
208 x_header_adj_tbl(i).attribute3 := p_header_adj_varray(i).attribute3;
209 x_header_adj_tbl(i).attribute4 := p_header_adj_varray(i).attribute4;
210 x_header_adj_tbl(i).attribute5 := p_header_adj_varray(i).attribute5;
211 x_header_adj_tbl(i).attribute6 := p_header_adj_varray(i).attribute6;
212 x_header_adj_tbl(i).attribute7 := p_header_adj_varray(i).attribute7;
213 x_header_adj_tbl(i).attribute8 := p_header_adj_varray(i).attribute8;
214 x_header_adj_tbl(i).attribute9 := p_header_adj_varray(i).attribute9;
215 x_header_adj_tbl(i).automatic_flag := p_header_adj_varray(i).automatic_flag;
216 x_header_adj_tbl(i).context := p_header_adj_varray(i).context;
217 x_header_adj_tbl(i).created_by := p_header_adj_varray(i).created_by;
218 x_header_adj_tbl(i).creation_date := p_header_adj_varray(i).creation_date;
219 x_header_adj_tbl(i).discount_id := p_header_adj_varray(i).discount_id;
220 x_header_adj_tbl(i).discount_line_id := p_header_adj_varray(i).discount_line_id;
221 x_header_adj_tbl(i).header_id := p_header_adj_varray(i).header_id;
222 x_header_adj_tbl(i).last_updated_by := p_header_adj_varray(i
223 ).last_updated_by;
224 x_header_adj_tbl(i).last_update_date := p_header_adj_varray(i).last_update_date;
225 x_header_adj_tbl(i).last_update_login := p_header_adj_varray(i).last_update_login;
226 x_header_adj_tbl(i).line_id := p_header_adj_varray(i).line_id;
227 x_header_adj_tbl(i).percent := p_header_adj_varray(i).percent;
228 x_header_adj_tbl(i).price_adjustment_id := p_header_adj_varray(i).price_adjustment_id;
229 x_header_adj_tbl(i).program_application_id := p_header_adj_varray(i).program_application_id;
230 x_header_adj_tbl(i).program_id := p_header_adj_varray(i).program_id;
234 x_header_adj_tbl(i).db_flag := p_header_adj_varray(i).db_flag;
231 x_header_adj_tbl(i).program_update_date := p_header_adj_varray(i).program_update_date;
232 x_header_adj_tbl(i).request_id := p_header_adj_varray(i).request_id;
233 x_header_adj_tbl(i).return_status := p_header_adj_varray(i).return_status;
235 x_header_adj_tbl(i).operation := p_header_adj_varray(i).operation;
236 x_header_adj_tbl(i).orig_sys_discount_ref := p_header_adj_varray(i).orig_sys_discount_ref;
237 x_header_adj_tbl(i).change_request_code := p_header_adj_varray(i).change_request_code;
238 x_header_adj_tbl(i).status_flag := p_header_adj_varray(i).status_flag;
239 x_header_adj_tbl(i).list_header_id := p_header_adj_varray(i).list_header_id;
240 x_header_adj_tbl(i).list_line_id := p_header_adj_varray(i).list_line_id;
241 x_header_adj_tbl(i).list_line_type_code := p_header_adj_varray(i).list_line_type_code;
242 x_header_adj_tbl(i).modifier_mechanism_type_code := p_header_adj_varray(i).modifier_mechanism_type_code;
243 x_header_adj_tbl(i).modified_from := p_header_adj_varray(i).modified_from;
244 x_header_adj_tbl(i).modified_to := p_header_adj_varray(i).modified_to;
245 x_header_adj_tbl(i).updated_flag := p_header_adj_varray(i).updated_flag;
246 x_header_adj_tbl(i).update_allowed := p_header_adj_varray(i).update_allowed;
247 x_header_adj_tbl(i).applied_flag := p_header_adj_varray(i).applied_flag;
248 x_header_adj_tbl(i).change_reason_code := p_header_adj_varray(i).change_reason_code;
249 x_header_adj_tbl(i).change_reason_text := p_header_adj_varray(i).change_reason_text;
250 x_header_adj_tbl(i).operand := p_header_adj_varray(i).operand;
251 x_header_adj_tbl(i).arithmetic_operator := p_header_adj_varray(i).arithmetic_operator;
252 x_header_adj_tbl(i).cost_id := p_header_adj_varray(i).cost_id;
253 x_header_adj_tbl(i).tax_code := p_header_adj_varray(i).tax_code;
254 x_header_adj_tbl(i).tax_exempt_flag := p_header_adj_varray(i).tax_exempt_flag;
255 x_header_adj_tbl(i).tax_exempt_number := p_header_adj_varray(i).tax_exempt_number;
256 x_header_adj_tbl(i).tax_exempt_reason_code := p_header_adj_varray(i).tax_exempt_reason_code;
257 x_header_adj_tbl(i).parent_adjustment_id := p_header_adj_varray(i).parent_adjustment_id;
258 x_header_adj_tbl(i).invoiced_flag := p_header_adj_varray(i).invoiced_flag;
259 x_header_adj_tbl(i).estimated_flag := p_header_adj_varray(i).estimated_flag;
260 x_header_adj_tbl(i).inc_in_sales_performance := p_header_adj_varray(i).inc_in_sales_performance;
261 x_header_adj_tbl(i).split_action_code := p_header_adj_varray(i).split_action_code;
262 x_header_adj_tbl(i).adjusted_amount := p_header_adj_varray(i).adjusted_amount;
263 x_header_adj_tbl(i).pricing_phase_id := p_header_adj_varray(i).pricing_phase_id;
264
265 i := p_header_adj_varray.NEXT(i);
266
267 END LOOP;
268
269 END Header_Adj_Var_To_Tbl;
270
271
272 -- Header Price Atts
273
274 PROCEDURE Header_Price_Att_Var_To_Tbl
275 (
276 p_header_price_att_varray IN SYSTEM.ASO_Header_Price_Att_Var_Type,
277 x_header_price_att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type
278 )
279 IS
280 i NUMBER;
281
282 BEGIN
283 IF p_header_price_att_varray is NULL THEN
284 x_header_price_att_tbl := OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL;
285 return;
286 END IF;
287
288 i := p_header_price_att_varray.FIRST;
289 WHILE i IS NOT NULL LOOP
290 x_header_price_att_tbl(i).order_price_attrib_id := p_header_price_att_varray(i).order_price_attrib_id;
291 x_header_price_att_tbl(i).header_id := p_header_price_att_varray(i).header_id;
292 x_header_price_att_tbl(i).line_id := p_header_price_att_varray(i).line_id;
293 x_header_price_att_tbl(i).creation_date := p_header_price_att_varray(i).creation_date;
294 x_header_price_att_tbl(i).created_by := p_header_price_att_varray(i).created_by;
295 x_header_price_att_tbl(i).last_update_date := p_header_price_att_varray(i).last_update_date;
296 x_header_price_att_tbl(i).last_updated_by := p_header_price_att_varray(i).last_updated_by;
297 x_header_price_att_tbl(i).last_update_login := p_header_price_att_varray(i).last_update_login;
298 x_header_price_att_tbl(i).program_application_id := p_header_price_att_varray(i).program_application_id;
299 x_header_price_att_tbl(i).program_id := p_header_price_att_varray(i).program_id;
300 x_header_price_att_tbl(i).program_update_date := p_header_price_att_varray(i).program_update_date;
301 x_header_price_att_tbl(i).request_id := p_header_price_att_varray(i).request_id;
302 x_header_price_att_tbl(i).flex_title := p_header_price_att_varray(i).flex_title;
303 x_header_price_att_tbl(i).pricing_context := p_header_price_att_varray(i).pricing_context;
304 x_header_price_att_tbl(i).pricing_attribute1 := p_header_price_att_varray(i).pricing_attribute1;
305 x_header_price_att_tbl(i).pricing_attribute2 := p_header_price_att_varray(i).pricing_attribute2;
309 x_header_price_att_tbl(i).pricing_attribute6 := p_header_price_att_varray(i).pricing_attribute6;
306 x_header_price_att_tbl(i).pricing_attribute3 := p_header_price_att_varray(i).pricing_attribute3;
307 x_header_price_att_tbl(i).pricing_attribute4 := p_header_price_att_varray(i).pricing_attribute4;
308 x_header_price_att_tbl(i).pricing_attribute5 := p_header_price_att_varray(i).pricing_attribute5;
310 x_header_price_att_tbl(i).pricing_attribute7 := p_header_price_att_varray(i).pricing_attribute7;
311 x_header_price_att_tbl(i).pricing_attribute8 := p_header_price_att_varray(i).pricing_attribute8;
312 x_header_price_att_tbl(i).pricing_attribute9 := p_header_price_att_varray(i).pricing_attribute9;
313 x_header_price_att_tbl(i).pricing_attribute10 := p_header_price_att_varray(i).pricing_attribute10;
314 x_header_price_att_tbl(i).pricing_attribute11 := p_header_price_att_varray(i).pricing_attribute11;
315 x_header_price_att_tbl(i).pricing_attribute12 := p_header_price_att_varray(i).pricing_attribute12;
316 x_header_price_att_tbl(i).pricing_attribute13 := p_header_price_att_varray(i).pricing_attribute13;
317 x_header_price_att_tbl(i).pricing_attribute14 := p_header_price_att_varray(i).pricing_attribute14;
318 x_header_price_att_tbl(i).pricing_attribute15 := p_header_price_att_varray(i).pricing_attribute15;
319 x_header_price_att_tbl(i).pricing_attribute16 := p_header_price_att_varray(i).pricing_attribute16;
320 x_header_price_att_tbl(i).pricing_attribute17 := p_header_price_att_varray(i).pricing_attribute17;
321 x_header_price_att_tbl(i).pricing_attribute18 := p_header_price_att_varray(i).pricing_attribute18;
322 x_header_price_att_tbl(i).pricing_attribute19 := p_header_price_att_varray(i).pricing_attribute19;
323 x_header_price_att_tbl(i).pricing_attribute20 := p_header_price_att_varray(i).pricing_attribute20;
324 x_header_price_att_tbl(i).pricing_attribute21 := p_header_price_att_varray(i).pricing_attribute21;
325 x_header_price_att_tbl(i).pricing_attribute22 := p_header_price_att_varray(i).pricing_attribute22;
326 x_header_price_att_tbl(i).pricing_attribute23 := p_header_price_att_varray(i).pricing_attribute23;
327 x_header_price_att_tbl(i).pricing_attribute24 := p_header_price_att_varray(i).pricing_attribute24;
328 x_header_price_att_tbl(i).pricing_attribute25 := p_header_price_att_varray(i).pricing_attribute25;
329 x_header_price_att_tbl(i).pricing_attribute26 := p_header_price_att_varray(i).pricing_attribute26;
330 x_header_price_att_tbl(i).pricing_attribute27 := p_header_price_att_varray(i).pricing_attribute27;
331 x_header_price_att_tbl(i).pricing_attribute28 := p_header_price_att_varray(i).pricing_attribute28;
332 x_header_price_att_tbl(i).pricing_attribute29 := p_header_price_att_varray(i).pricing_attribute29;
333 x_header_price_att_tbl(i).pricing_attribute30 := p_header_price_att_varray(i).pricing_attribute30;
334 x_header_price_att_tbl(i).pricing_attribute31 := p_header_price_att_varray(i).pricing_attribute31;
335 x_header_price_att_tbl(i).pricing_attribute32 := p_header_price_att_varray(i).pricing_attribute32;
336 x_header_price_att_tbl(i).pricing_attribute33 := p_header_price_att_varray(i).pricing_attribute33;
337 x_header_price_att_tbl(i).pricing_attribute34 := p_header_price_att_varray(i).pricing_attribute34;
338 x_header_price_att_tbl(i).pricing_attribute35 := p_header_price_att_varray(i).pricing_attribute35;
339 x_header_price_att_tbl(i).pricing_attribute36 := p_header_price_att_varray(i).pricing_attribute36;
340 x_header_price_att_tbl(i).pricing_attribute37 := p_header_price_att_varray(i).pricing_attribute37;
341 x_header_price_att_tbl(i).pricing_attribute38 := p_header_price_att_varray(i).pricing_attribute38;
342 x_header_price_att_tbl(i).pricing_attribute39 := p_header_price_att_varray(i).pricing_attribute39;
343 x_header_price_att_tbl(i).pricing_attribute40 := p_header_price_att_varray(i).pricing_attribute40;
344 x_header_price_att_tbl(i).pricing_attribute41 := p_header_price_att_varray(i).pricing_attribute41;
345 x_header_price_att_tbl(i).pricing_attribute42 := p_header_price_att_varray(i).pricing_attribute42;
346 x_header_price_att_tbl(i).pricing_attribute43 := p_header_price_att_varray(i).pricing_attribute43;
347 x_header_price_att_tbl(i).pricing_attribute44 := p_header_price_att_varray(i).pricing_attribute44;
348 x_header_price_att_tbl(i).pricing_attribute45 := p_header_price_att_varray(i).pricing_attribute45;
349 x_header_price_att_tbl(i).pricing_attribute46 := p_header_price_att_varray(i).pricing_attribute46;
350 x_header_price_att_tbl(i).pricing_attribute47 := p_header_price_att_varray(i).pricing_attribute47;
351 x_header_price_att_tbl(i).pricing_attribute48 := p_header_price_att_varray(i).pricing_attribute48;
352 x_header_price_att_tbl(i).pricing_attribute49 := p_header_price_att_varray(i).pricing_attribute49;
353 x_header_price_att_tbl(i).pricing_attribute50 := p_header_price_att_varray(i).pricing_attribute50;
354 x_header_price_att_tbl(i).pricing_attribute51 := p_header_price_att_varray(i).pricing_attribute51;
355 x_header_price_att_tbl(i).pricing_attribute52 := p_header_price_att_varray(i).pricing_attribute52;
359 x_header_price_att_tbl(i).pricing_attribute56 := p_header_price_att_varray(i).pricing_attribute56;
356 x_header_price_att_tbl(i).pricing_attribute53 := p_header_price_att_varray(i).pricing_attribute53;
357 x_header_price_att_tbl(i).pricing_attribute54 := p_header_price_att_varray(i).pricing_attribute54;
358 x_header_price_att_tbl(i).pricing_attribute55 := p_header_price_att_varray(i).pricing_attribute55;
360 x_header_price_att_tbl(i).pricing_attribute57 := p_header_price_att_varray(i).pricing_attribute57;
361 x_header_price_att_tbl(i).pricing_attribute58 := p_header_price_att_varray(i).pricing_attribute58;
362 x_header_price_att_tbl(i).pricing_attribute59 := p_header_price_att_varray(i).pricing_attribute59;
363 x_header_price_att_tbl(i).pricing_attribute60 := p_header_price_att_varray(i).pricing_attribute60;
364 x_header_price_att_tbl(i).pricing_attribute61 := p_header_price_att_varray(i).pricing_attribute61;
365 x_header_price_att_tbl(i).pricing_attribute62 := p_header_price_att_varray(i).pricing_attribute62;
366 x_header_price_att_tbl(i).pricing_attribute63 := p_header_price_att_varray(i).pricing_attribute63;
367 x_header_price_att_tbl(i).pricing_attribute64 := p_header_price_att_varray(i).pricing_attribute64;
368 x_header_price_att_tbl(i).pricing_attribute65 := p_header_price_att_varray(i).pricing_attribute65;
369 x_header_price_att_tbl(i).pricing_attribute66 := p_header_price_att_varray(i).pricing_attribute66;
370 x_header_price_att_tbl(i).pricing_attribute67 := p_header_price_att_varray(i).pricing_attribute67;
371 x_header_price_att_tbl(i).pricing_attribute68 := p_header_price_att_varray(i).pricing_attribute68;
372 x_header_price_att_tbl(i).pricing_attribute69 := p_header_price_att_varray(i).pricing_attribute69;
373 x_header_price_att_tbl(i).pricing_attribute70 := p_header_price_att_varray(i).pricing_attribute70;
374 x_header_price_att_tbl(i).pricing_attribute71 := p_header_price_att_varray(i).pricing_attribute71;
375 x_header_price_att_tbl(i).pricing_attribute72 := p_header_price_att_varray(i).pricing_attribute72;
376 x_header_price_att_tbl(i).pricing_attribute73 := p_header_price_att_varray(i).pricing_attribute73;
377 x_header_price_att_tbl(i).pricing_attribute74 := p_header_price_att_varray(i).pricing_attribute74;
378 x_header_price_att_tbl(i).pricing_attribute75 := p_header_price_att_varray(i).pricing_attribute75;
379 x_header_price_att_tbl(i).pricing_attribute76 := p_header_price_att_varray(i).pricing_attribute76;
380 x_header_price_att_tbl(i).pricing_attribute77 := p_header_price_att_varray(i).pricing_attribute77;
381 x_header_price_att_tbl(i).pricing_attribute78 := p_header_price_att_varray(i).pricing_attribute78;
382 x_header_price_att_tbl(i).pricing_attribute79 := p_header_price_att_varray(i).pricing_attribute79;
383 x_header_price_att_tbl(i).pricing_attribute80 := p_header_price_att_varray(i).pricing_attribute80;
384 x_header_price_att_tbl(i).pricing_attribute81 := p_header_price_att_varray(i).pricing_attribute81;
385 x_header_price_att_tbl(i).pricing_attribute82 := p_header_price_att_varray(i).pricing_attribute82;
386 x_header_price_att_tbl(i).pricing_attribute83 := p_header_price_att_varray(i).pricing_attribute83;
387 x_header_price_att_tbl(i).pricing_attribute84 := p_header_price_att_varray(i).pricing_attribute84;
388 x_header_price_att_tbl(i).pricing_attribute85 := p_header_price_att_varray(i).pricing_attribute85;
389 x_header_price_att_tbl(i).pricing_attribute86 := p_header_price_att_varray(i).pricing_attribute86;
390 x_header_price_att_tbl(i).pricing_attribute87 := p_header_price_att_varray(i).pricing_attribute87;
391 x_header_price_att_tbl(i).pricing_attribute88 := p_header_price_att_varray(i).pricing_attribute88;
392 x_header_price_att_tbl(i).pricing_attribute89 := p_header_price_att_varray(i).pricing_attribute89;
393 x_header_price_att_tbl(i).pricing_attribute90 := p_header_price_att_varray(i).pricing_attribute90;
394 x_header_price_att_tbl(i).pricing_attribute91 := p_header_price_att_varray(i).pricing_attribute91;
395 x_header_price_att_tbl(i).pricing_attribute92 := p_header_price_att_varray(i).pricing_attribute92;
396 x_header_price_att_tbl(i).pricing_attribute93 := p_header_price_att_varray(i).pricing_attribute93;
397 x_header_price_att_tbl(i).pricing_attribute94 := p_header_price_att_varray(i).pricing_attribute94;
398 x_header_price_att_tbl(i).pricing_attribute95 := p_header_price_att_varray(i).pricing_attribute95;
399 x_header_price_att_tbl(i).pricing_attribute96 := p_header_price_att_varray(i).pricing_attribute96;
400 x_header_price_att_tbl(i).pricing_attribute97 := p_header_price_att_varray(i).pricing_attribute97;
401 x_header_price_att_tbl(i).pricing_attribute98 := p_header_price_att_varray(i).pricing_attribute98;
402 x_header_price_att_tbl(i).pricing_attribute99 := p_header_price_att_varray(i).pricing_attribute99;
403 x_header_price_att_tbl(i).pricing_attribute100 := p_header_price_att_varray(i).pricing_attribute100;
404 x_header_price_att_tbl(i).context := p_header_price_att_varray(i).context;
405 x_header_price_att_tbl(i).attribute1 := p_header_price_att_varray(i).attribute1;
409 x_header_price_att_tbl(i).attribute5 := p_header_price_att_varray(i).attribute5;
406 x_header_price_att_tbl(i).attribute2 := p_header_price_att_varray(i).attribute2;
407 x_header_price_att_tbl(i).attribute3 := p_header_price_att_varray(i).attribute3;
408 x_header_price_att_tbl(i).attribute4 := p_header_price_att_varray(i).attribute4;
410 x_header_price_att_tbl(i).attribute6 := p_header_price_att_varray(i).attribute6;
411 x_header_price_att_tbl(i).attribute7 := p_header_price_att_varray(i).attribute7;
412 x_header_price_att_tbl(i).attribute8 := p_header_price_att_varray(i).attribute8;
413 x_header_price_att_tbl(i).attribute9 := p_header_price_att_varray(i).attribute9;
414 x_header_price_att_tbl(i).attribute10 := p_header_price_att_varray(i).attribute10;
415 x_header_price_att_tbl(i).attribute11 := p_header_price_att_varray(i).attribute11;
416 x_header_price_att_tbl(i).attribute12 := p_header_price_att_varray(i).attribute12;
417 x_header_price_att_tbl(i).attribute13 := p_header_price_att_varray(i).attribute13;
418 x_header_price_att_tbl(i).attribute14 := p_header_price_att_varray(i).attribute14;
419 x_header_price_att_tbl(i).attribute15 := p_header_price_att_varray(i).attribute15;
420 x_header_price_att_tbl(i).return_status := p_header_price_att_varray(i).return_status;
421 x_header_price_att_tbl(i).db_flag := p_header_price_att_varray(i).db_flag;
422 x_header_price_att_tbl(i).operation := p_header_price_att_varray(i).operation;
423
424 i := p_header_price_att_varray.NEXT(i);
425
426 END LOOP;
427
428 END Header_Price_Att_Var_To_Tbl;
429
430
431 -- Header Adj Atts
432
433
434 PROCEDURE Header_Adj_Att_Var_To_Tbl
435 (
436 p_header_adj_att_varray IN SYSTEM.ASO_Header_Adj_Att_Var_Type,
437 x_header_adj_att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type
438 )
439 IS
440 i NUMBER;
441
442 BEGIN
443 IF p_header_adj_att_varray is NULL THEN
444 x_header_adj_att_tbl := OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL;
445 return;
446 END IF;
447
448 i := p_header_adj_att_varray.FIRST;
449 WHILE i IS NOT NULL LOOP
450 x_header_adj_att_tbl(i).price_adj_attrib_id := p_header_adj_att_varray(i).price_adj_attrib_id;
451 x_header_adj_att_tbl(i).price_adjustment_id := p_header_adj_att_varray(i).price_adjustment_id;
452 x_header_adj_att_tbl(i).adj_index := p_header_adj_att_varray(i).adj_index;
453 x_header_adj_att_tbl(i).flex_title := p_header_adj_att_varray(i).flex_title;
454 x_header_adj_att_tbl(i).pricing_context := p_header_adj_att_varray(i).pricing_context;
455 x_header_adj_att_tbl(i).pricing_attribute := p_header_adj_att_varray(i).pricing_attribute;
456 x_header_adj_att_tbl(i).creation_date := p_header_adj_att_varray(i).creation_date;
457 x_header_adj_att_tbl(i).created_by := p_header_adj_att_varray(i).created_by;
458 x_header_adj_att_tbl(i).last_update_date := p_header_adj_att_varray(i).last_update_date;
459 x_header_adj_att_tbl(i).last_updated_by := p_header_adj_att_varray(i).last_updated_by;
460 x_header_adj_att_tbl(i).last_update_login := p_header_adj_att_varray(i).last_update_login;
461 x_header_adj_att_tbl(i).program_application_id := p_header_adj_att_varray(i).program_application_id;
462 x_header_adj_att_tbl(i).program_id := p_header_adj_att_varray(i).program_id;
463 x_header_adj_att_tbl(i).program_update_date := p_header_adj_att_varray(i).program_update_date;
464 x_header_adj_att_tbl(i).request_id := p_header_adj_att_varray(i).request_id;
465 x_header_adj_att_tbl(i).pricing_attr_value_from := p_header_adj_att_varray(i).pricing_attr_value_from;
466 x_header_adj_att_tbl(i).pricing_attr_value_to := p_header_adj_att_varray(i).pricing_attr_value_to;
467 x_header_adj_att_tbl(i).comparison_operator := p_header_adj_att_varray(i).comparison_operator;
468 x_header_adj_att_tbl(i).return_status := p_header_adj_att_varray(i).return_status;
469 x_header_adj_att_tbl(i).db_flag := p_header_adj_att_varray(i).db_flag;
470 x_header_adj_att_tbl(i).operation := p_header_adj_att_varray(i).operation;
471
472 i := p_header_adj_att_varray.NEXT(i);
473
474 END LOOP;
475
476 END Header_Adj_Att_Var_To_Tbl;
477
478
479 -- Header Adj Assocs
480
481 PROCEDURE Header_Adj_Assoc_Var_To_Tbl
482 (
483 p_header_adj_assoc_varray IN SYSTEM.ASO_Header_Adj_Assoc_Var_Type,
484 x_header_adj_assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
485 )
486 IS
487 i NUMBER;
488
489 BEGIN
490 IF p_header_adj_assoc_varray is NULL THEN
491 x_header_adj_assoc_tbl := OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL;
492 return;
493 END IF;
494
495 i := p_header_adj_assoc_varray.FIRST;
496 WHILE i IS NOT NULL LOOP
497 x_header_adj_assoc_tbl(i).price_adj_assoc_id := p_header_adj_assoc_varray(i).price_adj_assoc_id;
498 x_header_adj_assoc_tbl(i).line_id := p_header_adj_assoc_varray(i).line_id;
502 x_header_adj_assoc_tbl(i).creation_date := p_header_adj_assoc_varray(i).creation_date;
499 x_header_adj_assoc_tbl(i).line_index := p_header_adj_assoc_varray(i).line_index;
500 x_header_adj_assoc_tbl(i).price_adjustment_id := p_header_adj_assoc_varray(i).price_adjustment_id;
501 x_header_adj_assoc_tbl(i).adj_index := p_header_adj_assoc_varray(i).adj_index;
503 x_header_adj_assoc_tbl(i).created_by := p_header_adj_assoc_varray(i).created_by;
504 x_header_adj_assoc_tbl(i).last_update_date := p_header_adj_assoc_varray(i).last_update_date;
505 x_header_adj_assoc_tbl(i).last_updated_by := p_header_adj_assoc_varray(i).last_updated_by;
506 x_header_adj_assoc_tbl(i).last_update_login := p_header_adj_assoc_varray(i).last_update_login;
507 x_header_adj_assoc_tbl(i).program_application_id := p_header_adj_assoc_varray(i).program_application_id;
508 x_header_adj_assoc_tbl(i).program_id := p_header_adj_assoc_varray(i).program_id;
509 x_header_adj_assoc_tbl(i).program_update_date := p_header_adj_assoc_varray(i).program_update_date;
510 x_header_adj_assoc_tbl(i).request_id := p_header_adj_assoc_varray(i).request_id;
511 x_header_adj_assoc_tbl(i).return_status := p_header_adj_assoc_varray(i).return_status;
512 x_header_adj_assoc_tbl(i).db_flag := p_header_adj_assoc_varray(i).db_flag;
513 x_header_adj_assoc_tbl(i).operation := p_header_adj_assoc_varray(i).operation;
514
515 i := p_header_adj_assoc_varray.NEXT(i);
516
517 END LOOP;
518
519 END Header_Adj_Assoc_Var_To_Tbl;
520
521
522 -- Header Scredits
523
524 PROCEDURE Header_Scredit_Var_To_Tbl
525 (
526 p_header_scredit_varray IN SYSTEM.ASO_Header_Scredit_Var_Type,
527 x_header_scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type
528 )
529 IS
530 i NUMBER;
531
532 BEGIN
533 IF p_header_scredit_varray is NULL THEN
534 x_header_scredit_tbl := OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL;
535 return;
536 END IF;
537
538 i := p_header_scredit_varray.FIRST;
539 WHILE i IS NOT NULL LOOP
540 x_header_scredit_tbl(i).attribute1 := p_header_scredit_varray(i).attribute1;
541 x_header_scredit_tbl(i).attribute10 := p_header_scredit_varray(i).attribute10;
542 x_header_scredit_tbl(i).attribute11 := p_header_scredit_varray(i).attribute11;
543 x_header_scredit_tbl(i).attribute12 := p_header_scredit_varray(i).attribute12;
544 x_header_scredit_tbl(i).attribute13 := p_header_scredit_varray(i).attribute13;
545 x_header_scredit_tbl(i).attribute14 := p_header_scredit_varray(i).attribute14;
546 x_header_scredit_tbl(i).attribute15 := p_header_scredit_varray(i).attribute15;
547 x_header_scredit_tbl(i).attribute2 := p_header_scredit_varray(i).attribute2;
548 x_header_scredit_tbl(i).attribute3 := p_header_scredit_varray(i).attribute3;
549 x_header_scredit_tbl(i).attribute4 := p_header_scredit_varray(i).attribute4;
550 x_header_scredit_tbl(i).attribute5 := p_header_scredit_varray(i).attribute5;
551 x_header_scredit_tbl(i).attribute6 := p_header_scredit_varray(i).attribute6;
552 x_header_scredit_tbl(i).attribute7 := p_header_scredit_varray(i).attribute7;
553 x_header_scredit_tbl(i).attribute8 := p_header_scredit_varray(i).attribute8;
554 x_header_scredit_tbl(i).attribute9 := p_header_scredit_varray(i).attribute9;
555 x_header_scredit_tbl(i).context := p_header_scredit_varray(i).context;
556 x_header_scredit_tbl(i).created_by := p_header_scredit_varray(i).created_by;
557 x_header_scredit_tbl(i).creation_date := p_header_scredit_varray(i).creation_date;
558 x_header_scredit_tbl(i).dw_update_advice_flag := p_header_scredit_varray(i).dw_update_advice_flag;
559 x_header_scredit_tbl(i).header_id := p_header_scredit_varray(i).header_id;
560 x_header_scredit_tbl(i).last_updated_by := p_header_scredit_varray(i).last_updated_by;
561 x_header_scredit_tbl(i).last_update_date := p_header_scredit_varray(i).last_update_date;
562 x_header_scredit_tbl(i).last_update_login := p_header_scredit_varray(i).last_update_login;
563 x_header_scredit_tbl(i).line_id := p_header_scredit_varray(i).line_id;
564 x_header_scredit_tbl(i).percent := p_header_scredit_varray(i).percent;
565 x_header_scredit_tbl(i).salesrep_id := p_header_scredit_varray(i).salesrep_id;
566 x_header_scredit_tbl(i).sales_credit_id := p_header_scredit_varray(i).sales_credit_id;
567 x_header_scredit_tbl(i).wh_update_date := p_header_scredit_varray(i).wh_update_date;
568 x_header_scredit_tbl(i).return_status := p_header_scredit_varray(i).return_status;
569 x_header_scredit_tbl(i).db_flag := p_header_scredit_varray(i).db_flag;
570 x_header_scredit_tbl(i).operation := p_header_scredit_varray(i).operation;
571 x_header_scredit_tbl(i).orig_sys_credit_ref := p_header_scredit_varray(i).orig_sys_credit_ref;
572 x_header_scredit_tbl(i).change_request_code := p_header_scredit_varray(i).change_request_code;
573 x_header_scredit_tbl(i).status_flag := p_header_scredit_varray(i).status_flag;
574
575 i := p_header_scredit_varray.NEXT(i);
576
577 END LOOP;
578
579 END Header_Scredit_Var_To_Tbl;
583
580
581
582 -- Lines
584 PROCEDURE Line_Var_To_Tbl
585 (
586 p_line_varray IN SYSTEM.ASO_Line_Var_Type,
587 x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type
588 )
589 IS
590 i NUMBER;
591
592 BEGIN
593 IF p_line_varray is NULL THEN
594 x_line_tbl := OE_Order_PUB.G_MISS_LINE_TBL;
595 return;
596 END IF;
597
598 i := p_line_varray.FIRST;
599 WHILE i IS NOT NULL LOOP
600 x_line_tbl(i).accounting_rule_id := p_line_varray(i).accounting_rule_id;
601 x_line_tbl(i).actual_arrival_date := p_line_varray(i).actual_arrival_date;
602 x_line_tbl(i).actual_shipment_date := p_line_varray(i).actual_shipment_date;
603 x_line_tbl(i).agreement_id := p_line_varray(i).agreement_id;
604 x_line_tbl(i).arrival_set_id := p_line_varray(i).arrival_set_id;
605 x_line_tbl(i).ato_line_id := p_line_varray(i).ato_line_id;
606 x_line_tbl(i).attribute1 := p_line_varray(i).attribute1;
607 x_line_tbl(i).attribute10 := p_line_varray(i).attribute10;
608 x_line_tbl(i).attribute11 := p_line_varray(i).attribute11;
609 x_line_tbl(i).attribute12 := p_line_varray(i).attribute12;
610 x_line_tbl(i).attribute13 := p_line_varray(i).attribute13;
611 x_line_tbl(i).attribute14 := p_line_varray(i).attribute14;
612 x_line_tbl(i).attribute15 := p_line_varray(i).attribute15;
613 x_line_tbl(i).attribute2 := p_line_varray(i).attribute2;
614 x_line_tbl(i).attribute3 := p_line_varray(i).attribute3;
615 x_line_tbl(i).attribute4 := p_line_varray(i).attribute4;
616 x_line_tbl(i).attribute5 := p_line_varray(i).attribute5;
617 x_line_tbl(i).attribute6 := p_line_varray(i).attribute6;
618 x_line_tbl(i).attribute7 := p_line_varray(i).attribute7;
619 x_line_tbl(i).attribute8 := p_line_varray(i).attribute8;
620 x_line_tbl(i).attribute9 := p_line_varray(i).attribute9;
621 x_line_tbl(i).authorized_to_ship_flag := p_line_varray(i).authorized_to_ship_flag;
622 x_line_tbl(i).auto_selected_quantity := p_line_varray(i).auto_selected_quantity;
623 x_line_tbl(i).booked_flag := p_line_varray(i).booked_flag;
624 x_line_tbl(i).cancelled_flag := p_line_varray(i).cancelled_flag;
625 x_line_tbl(i).cancelled_quantity := p_line_varray(i).cancelled_quantity;
626 x_line_tbl(i).commitment_id := p_line_varray(i).commitment_id;
627 x_line_tbl(i).component_code := p_line_varray(i).component_code;
628 x_line_tbl(i).component_number := p_line_varray(i).component_number;
629 x_line_tbl(i).component_sequence_id := p_line_varray(i).component_sequence_id;
630 x_line_tbl(i).config_header_id := p_line_varray(i).config_header_id;
631 x_line_tbl(i).config_rev_nbr := p_line_varray(i).config_rev_nbr;
632 x_line_tbl(i).config_display_sequence := p_line_varray(i).config_display_sequence;
633 x_line_tbl(i).configuration_id := p_line_varray(i).configuration_id;
634 x_line_tbl(i).context := p_line_varray(i).context;
635 x_line_tbl(i).created_by := p_line_varray(i).created_by;
636 x_line_tbl(i).creation_date := p_line_varray(i).creation_date;
637 x_line_tbl(i).credit_invoice_line_id := p_line_varray(i).credit_invoice_line_id;
638 x_line_tbl(i).customer_dock_code := p_line_varray(i).customer_dock_code;
639 x_line_tbl(i).customer_job := p_line_varray(i).customer_job;
640 x_line_tbl(i).customer_production_line := p_line_varray(i).customer_production_line;
641 x_line_tbl(i).customer_trx_line_id := p_line_varray(i).customer_trx_line_id;
642 x_line_tbl(i).cust_model_serial_number := p_line_varray(i).cust_model_serial_number;
643 x_line_tbl(i).cust_po_number := p_line_varray(i).cust_po_number;
644 x_line_tbl(i).cust_production_seq_num := p_line_varray(i).cust_production_seq_num;
645 x_line_tbl(i).delivery_lead_time := p_line_varray(i).delivery_lead_time;
646 x_line_tbl(i).deliver_to_contact_id := p_line_varray(i).deliver_to_contact_id;
647 x_line_tbl(i).deliver_to_org_id := p_line_varray(i).deliver_to_org_id;
648 x_line_tbl(i).demand_bucket_type_code := p_line_varray(i).demand_bucket_type_code;
649 x_line_tbl(i).demand_class_code := p_line_varray(i).demand_class_code;
650 x_line_tbl(i).dep_plan_required_flag := p_line_varray(i).dep_plan_required_flag;
651 x_line_tbl(i).earliest_acceptable_date := p_line_varray(i).earliest_acceptable_date;
652 x_line_tbl(i).end_item_unit_number := p_line_varray(i).end_item_unit_number;
653 x_line_tbl(i).explosion_date := p_line_varray(i).explosion_date;
654 x_line_tbl(i).fob_point_code := p_line_varray(i).fob_point_code;
655 x_line_tbl(i).freight_carrier_code := p_line_varray(i).freight_carrier_code;
659 x_line_tbl(i).global_attribute10 := p_line_varray(i).global_attribute10;
656 x_line_tbl(i).freight_terms_code := p_line_varray(i).freight_terms_code;
657 x_line_tbl(i).fulfilled_quantity := p_line_varray(i).fulfilled_quantity;
658 x_line_tbl(i).global_attribute1 := p_line_varray(i).global_attribute1;
660 x_line_tbl(i).global_attribute11 := p_line_varray(i).global_attribute11;
661 x_line_tbl(i).global_attribute12 := p_line_varray(i).global_attribute12;
662 x_line_tbl(i).global_attribute13 := p_line_varray(i).global_attribute13;
663 x_line_tbl(i).global_attribute14 := p_line_varray(i).global_attribute14;
664 x_line_tbl(i).global_attribute15 := p_line_varray(i).global_attribute15;
665 x_line_tbl(i).global_attribute16 := p_line_varray(i).global_attribute16;
666 x_line_tbl(i).global_attribute17 := p_line_varray(i).global_attribute17;
667 x_line_tbl(i).global_attribute18 := p_line_varray(i).global_attribute18;
668 x_line_tbl(i).global_attribute19 := p_line_varray(i).global_attribute19;
669 x_line_tbl(i).global_attribute2 := p_line_varray(i).global_attribute2;
670 x_line_tbl(i).global_attribute20 := p_line_varray(i).global_attribute20;
671 x_line_tbl(i).global_attribute3 := p_line_varray(i).global_attribute3;
672 x_line_tbl(i).global_attribute4 := p_line_varray(i).global_attribute4;
673 x_line_tbl(i).global_attribute5 := p_line_varray(i).global_attribute5;
674 x_line_tbl(i).global_attribute6 := p_line_varray(i).global_attribute6;
675 x_line_tbl(i).global_attribute7 := p_line_varray(i).global_attribute7;
676 x_line_tbl(i).global_attribute8 := p_line_varray(i).global_attribute8;
677 x_line_tbl(i).global_attribute9 := p_line_varray(i).global_attribute9;
678 x_line_tbl(i).global_attribute_category := p_line_varray(i).global_attribute_category;
679 x_line_tbl(i).header_id := p_line_varray(i).header_id;
680 x_line_tbl(i).industry_attribute1 := p_line_varray(i).industry_attribute1;
681 x_line_tbl(i).industry_attribute10 := p_line_varray(i).industry_attribute10;
682 x_line_tbl(i).industry_attribute11 := p_line_varray(i).industry_attribute11;
683 x_line_tbl(i).industry_attribute12 := p_line_varray(i).industry_attribute12;
684 x_line_tbl(i).industry_attribute13 := p_line_varray(i).industry_attribute13;
685 x_line_tbl(i).industry_attribute14 := p_line_varray(i).industry_attribute14;
686 x_line_tbl(i).industry_attribute15 := p_line_varray(i).industry_attribute15;
687 x_line_tbl(i).industry_attribute16 := p_line_varray(i).industry_attribute16;
688 x_line_tbl(i).industry_attribute17 := p_line_varray(i).industry_attribute17;
689 x_line_tbl(i).industry_attribute18 := p_line_varray(i).industry_attribute18;
690 x_line_tbl(i).industry_attribute19 := p_line_varray(i).industry_attribute19;
691 x_line_tbl(i).industry_attribute20 := p_line_varray(i).industry_attribute20;
692 x_line_tbl(i).industry_attribute21 := p_line_varray(i).industry_attribute21;
693 x_line_tbl(i).industry_attribute22 := p_line_varray(i).industry_attribute22;
694 x_line_tbl(i).industry_attribute23 := p_line_varray(i).industry_attribute23;
695 x_line_tbl(i).industry_attribute24 := p_line_varray(i).industry_attribute24;
696 x_line_tbl(i).industry_attribute25 := p_line_varray(i).industry_attribute25;
697 x_line_tbl(i).industry_attribute26 := p_line_varray(i).industry_attribute26;
698 x_line_tbl(i).industry_attribute27 := p_line_varray(i).industry_attribute27;
699 x_line_tbl(i).industry_attribute28 := p_line_varray(i).industry_attribute28;
700 x_line_tbl(i).industry_attribute29 := p_line_varray(i).industry_attribute29;
701 x_line_tbl(i).industry_attribute30 := p_line_varray(i).industry_attribute30;
702 x_line_tbl(i).industry_attribute2 := p_line_varray(i).industry_attribute2;
703 x_line_tbl(i).industry_attribute3 := p_line_varray(i).industry_attribute3;
704 x_line_tbl(i).industry_attribute4 := p_line_varray(i).industry_attribute4;
705 x_line_tbl(i).industry_attribute5 := p_line_varray(i).industry_attribute5;
706 x_line_tbl(i).industry_attribute6 := p_line_varray(i).industry_attribute6;
707 x_line_tbl(i).industry_attribute7 := p_line_varray(i).industry_attribute7;
708 x_line_tbl(i).industry_attribute8 := p_line_varray(i).industry_attribute8;
709 x_line_tbl(i).industry_attribute9 := p_line_varray(i).industry_attribute9;
710 x_line_tbl(i).industry_context := p_line_varray(i).industry_context;
711 x_line_tbl(i).TP_CONTEXT := p_line_varray(i).TP_CONTEXT;
712 x_line_tbl(i).TP_ATTRIBUTE1 := p_line_varray(i).TP_ATTRIBUTE1;
713 x_line_tbl(i).TP_ATTRIBUTE2 := p_line_varray(i).TP_ATTRIBUTE2;
714 x_line_tbl(i).TP_ATTRIBUTE3 := p_line_varray(i).TP_ATTRIBUTE3;
718 x_line_tbl(i).TP_ATTRIBUTE7 := p_line_varray(i).TP_ATTRIBUTE7;
715 x_line_tbl(i).TP_ATTRIBUTE4 := p_line_varray(i).TP_ATTRIBUTE4;
716 x_line_tbl(i).TP_ATTRIBUTE5 := p_line_varray(i).TP_ATTRIBUTE5;
717 x_line_tbl(i).TP_ATTRIBUTE6 := p_line_varray(i).TP_ATTRIBUTE6;
719 x_line_tbl(i).TP_ATTRIBUTE8 := p_line_varray(i).TP_ATTRIBUTE8;
720 x_line_tbl(i).TP_ATTRIBUTE9 := p_line_varray(i).TP_ATTRIBUTE9;
721 x_line_tbl(i).TP_ATTRIBUTE10 := p_line_varray(i).TP_ATTRIBUTE10;
722 x_line_tbl(i).TP_ATTRIBUTE11 := p_line_varray(i).TP_ATTRIBUTE11;
723 x_line_tbl(i).TP_ATTRIBUTE12 := p_line_varray(i).TP_ATTRIBUTE12;
724 x_line_tbl(i).TP_ATTRIBUTE13 := p_line_varray(i).TP_ATTRIBUTE13;
725 x_line_tbl(i).TP_ATTRIBUTE14 := p_line_varray(i).TP_ATTRIBUTE14;
726 x_line_tbl(i).TP_ATTRIBUTE15 := p_line_varray(i).TP_ATTRIBUTE15;
727 x_line_tbl(i).intermed_ship_to_org_id := p_line_varray(i).intermed_ship_to_org_id;
728 x_line_tbl(i).intermed_ship_to_contact_id := p_line_varray(i).intermed_ship_to_contact_id;
729 x_line_tbl(i).inventory_item_id := p_line_varray(i).inventory_item_id;
730 x_line_tbl(i).invoice_interface_status_code := p_line_varray(i).invoice_interface_status_code;
731 x_line_tbl(i).invoice_to_contact_id := p_line_varray(i).invoice_to_contact_id;
732 x_line_tbl(i).invoice_to_org_id := p_line_varray(i).invoice_to_org_id;
733 x_line_tbl(i).invoicing_rule_id := p_line_varray(i).invoicing_rule_id;
734 x_line_tbl(i).ordered_item := p_line_varray(i).ordered_item;
735 x_line_tbl(i).item_revision := p_line_varray(i).item_revision;
736 x_line_tbl(i).item_type_code := p_line_varray(i).item_type_code;
737 x_line_tbl(i).last_updated_by := p_line_varray(i).last_updated_by;
738 x_line_tbl(i).last_update_date := p_line_varray(i).last_update_date;
739 x_line_tbl(i).last_update_login := p_line_varray(i).last_update_login;
740 x_line_tbl(i).latest_acceptable_date := p_line_varray(i).latest_acceptable_date;
741 x_line_tbl(i).line_category_code := p_line_varray(i).line_category_code;
742 x_line_tbl(i).line_id := p_line_varray(i).line_id;
743 x_line_tbl(i).line_number := p_line_varray(i).line_number;
744 x_line_tbl(i).line_type_id := p_line_varray(i).line_type_id;
745 x_line_tbl(i).link_to_line_ref := p_line_varray(i).link_to_line_ref;
746 x_line_tbl(i).link_to_line_id := p_line_varray(i).link_to_line_id;
747 x_line_tbl(i).link_to_line_index := p_line_varray(i).link_to_line_index;
748 x_line_tbl(i).model_group_number := p_line_varray(i).model_group_number;
749 x_line_tbl(i).mfg_component_sequence_id := p_line_varray(i).mfg_component_sequence_id;
750 x_line_tbl(i).open_flag := p_line_varray(i).open_flag;
751 x_line_tbl(i).option_flag := p_line_varray(i).option_flag;
752 x_line_tbl(i).option_number := p_line_varray(i).option_number;
753 x_line_tbl(i).ordered_quantity := p_line_varray(i).ordered_quantity;
754 x_line_tbl(i).order_quantity_uom := p_line_varray(i).order_quantity_uom;
755 x_line_tbl(i).org_id := p_line_varray(i).org_id;
756 x_line_tbl(i).orig_sys_document_ref := p_line_varray(i).orig_sys_document_ref;
757 x_line_tbl(i).orig_sys_line_ref := p_line_varray(i).orig_sys_line_ref;
758 x_line_tbl(i).over_ship_reason_code := p_line_varray(i).over_ship_reason_code;
759 x_line_tbl(i).over_ship_resolved_flag := p_line_varray(i).over_ship_resolved_flag;
760 x_line_tbl(i).payment_term_id := p_line_varray(i).payment_term_id;
761 x_line_tbl(i).planning_priority := p_line_varray(i).planning_priority;
762 x_line_tbl(i).price_list_id := p_line_varray(i).price_list_id;
763 x_line_tbl(i).pricing_attribute1 := p_line_varray(i).pricing_attribute1;
764 x_line_tbl(i).pricing_attribute10 := p_line_varray(i).pricing_attribute10;
765 x_line_tbl(i).pricing_attribute2 := p_line_varray(i).pricing_attribute2;
766 x_line_tbl(i).pricing_attribute3 := p_line_varray(i).pricing_attribute3;
767 x_line_tbl(i).pricing_attribute4 := p_line_varray(i).pricing_attribute4;
768 x_line_tbl(i).pricing_attribute5 := p_line_varray(i).pricing_attribute5;
769 x_line_tbl(i).pricing_attribute6 := p_line_varray(i).pricing_attribute6;
770 x_line_tbl(i).pricing_attribute7 := p_line_varray(i).pricing_attribute7;
771 x_line_tbl(i).pricing_attribute8 := p_line_varray(i).pricing_attribute8;
772 x_line_tbl(i).pricing_attribute9 := p_line_varray(i).pricing_attribute9;
773 x_line_tbl(i).pricing_context := p_line_varray(i).pricing_context;
774 x_line_tbl(i).pricing_date := p_line_varray(i).pricing_date;
778 x_line_tbl(i).program_id := p_line_varray(i).program_id;
775 x_line_tbl(i).pricing_quantity := p_line_varray(i).pricing_quantity;
776 x_line_tbl(i).pricing_quantity_uom := p_line_varray(i).pricing_quantity_uom;
777 x_line_tbl(i).program_application_id := p_line_varray(i).program_application_id;
779 x_line_tbl(i).program_update_date := p_line_varray(i).program_update_date;
780 x_line_tbl(i).project_id := p_line_varray(i).project_id;
781 x_line_tbl(i).promise_date := p_line_varray(i).promise_date;
782 x_line_tbl(i).re_source_flag := p_line_varray(i).re_source_flag;
783 x_line_tbl(i).reference_customer_trx_line_id := p_line_varray(i).reference_customer_trx_line_id;
784 x_line_tbl(i).reference_header_id := p_line_varray(i).reference_header_id;
785 x_line_tbl(i).reference_line_id := p_line_varray(i).reference_line_id;
786 x_line_tbl(i).reference_type := p_line_varray(i).reference_type;
787 x_line_tbl(i).request_date := p_line_varray(i).request_date;
788 x_line_tbl(i).request_id := p_line_varray(i).request_id;
789 x_line_tbl(i).reserved_quantity := p_line_varray(i).reserved_quantity;
790 x_line_tbl(i).return_attribute1 := p_line_varray(i).return_attribute1;
791 x_line_tbl(i).return_attribute10 := p_line_varray(i).return_attribute10;
792 x_line_tbl(i).return_attribute11 := p_line_varray(i).return_attribute11;
793 x_line_tbl(i).return_attribute12 := p_line_varray(i).return_attribute12;
794 x_line_tbl(i).return_attribute13 := p_line_varray(i).return_attribute13;
795 x_line_tbl(i).return_attribute14 := p_line_varray(i).return_attribute14;
796 x_line_tbl(i).return_attribute15 := p_line_varray(i).return_attribute15;
797 x_line_tbl(i).return_attribute2 := p_line_varray(i).return_attribute2;
798 x_line_tbl(i).return_attribute3 := p_line_varray(i).return_attribute3;
799 x_line_tbl(i).return_attribute4 := p_line_varray(i).return_attribute4;
800 x_line_tbl(i).return_attribute5 := p_line_varray(i).return_attribute5;
801 x_line_tbl(i).return_attribute6 := p_line_varray(i).return_attribute6;
802 x_line_tbl(i).return_attribute7 := p_line_varray(i).return_attribute7;
803 x_line_tbl(i).return_attribute8 := p_line_varray(i).return_attribute8;
804 x_line_tbl(i).return_attribute9 := p_line_varray(i).return_attribute9;
805 x_line_tbl(i).return_context := p_line_varray(i).return_context;
806 x_line_tbl(i).return_reason_code := p_line_varray(i).return_reason_code;
807 x_line_tbl(i).rla_schedule_type_code := p_line_varray(i).rla_schedule_type_code;
808 x_line_tbl(i).salesrep_id := p_line_varray(i).salesrep_id;
809 x_line_tbl(i).schedule_arrival_date := p_line_varray(i).schedule_arrival_date;
810 x_line_tbl(i).schedule_ship_date := p_line_varray(i).schedule_ship_date;
811 x_line_tbl(i).schedule_action_code := p_line_varray(i).schedule_action_code;
812 x_line_tbl(i).schedule_status_code := p_line_varray(i).schedule_status_code;
813 x_line_tbl(i).shipment_number := p_line_varray(i).shipment_number;
814 x_line_tbl(i).shipment_priority_code := p_line_varray(i).shipment_priority_code;
815 x_line_tbl(i).shipped_quantity := p_line_varray(i).shipped_quantity;
816 x_line_tbl(i).shipping_interfaced_flag := p_line_varray(i).shipping_interfaced_flag;
817 x_line_tbl(i).shipping_method_code := p_line_varray(i).shipping_method_code;
818 x_line_tbl(i).shipping_quantity := p_line_varray(i).shipping_quantity;
819 x_line_tbl(i).shipping_quantity_uom := p_line_varray(i).shipping_quantity_uom;
820 x_line_tbl(i).ship_from_org_id := p_line_varray(i).ship_from_org_id;
821 x_line_tbl(i).ship_model_complete_flag := p_line_varray(i).ship_model_complete_flag;
822 x_line_tbl(i).ship_set_id := p_line_varray(i).ship_set_id;
823 x_line_tbl(i).ship_tolerance_above := p_line_varray(i).ship_tolerance_above;
824 x_line_tbl(i).ship_tolerance_below := p_line_varray(i).ship_tolerance_below;
825 x_line_tbl(i).ship_to_contact_id := p_line_varray(i).ship_to_contact_id;
826 x_line_tbl(i).ship_to_org_id := p_line_varray(i).ship_to_org_id;
827 x_line_tbl(i).sold_to_org_id := p_line_varray(i).sold_to_org_id;
828 x_line_tbl(i).sold_from_org_id := p_line_varray(i).sold_from_org_id;
829 x_line_tbl(i).sort_order := p_line_varray(i).sort_order;
830 x_line_tbl(i).source_document_id := p_line_varray(i).source_document_id;
831 x_line_tbl(i).source_document_line_id := p_line_varray(i).source_document_line_id;
832 x_line_tbl(i).source_document_type_id := p_line_varray(i).source_document_type_id;
833 x_line_tbl(i).source_type_code := p_line_varray(i).source_type_code;
834 x_line_tbl(i).split_from_line_id := p_line_varray(i).split_from_line_id;
838 x_line_tbl(i).tax_exempt_flag := p_line_varray(i).tax_exempt_flag;
835 x_line_tbl(i).task_id := p_line_varray(i).task_id;
836 x_line_tbl(i).tax_code := p_line_varray(i).tax_code;
837 x_line_tbl(i).tax_date := p_line_varray(i).tax_date;
839 x_line_tbl(i).tax_exempt_number := p_line_varray(i).tax_exempt_number;
840 x_line_tbl(i).tax_exempt_reason_code := p_line_varray(i).tax_exempt_reason_code;
841 x_line_tbl(i).tax_point_code := p_line_varray(i).tax_point_code;
842 x_line_tbl(i).tax_rate := p_line_varray(i).tax_rate;
843 x_line_tbl(i).tax_value := p_line_varray(i).tax_value;
844 x_line_tbl(i).top_model_line_ref := p_line_varray(i).top_model_line_ref;
845 x_line_tbl(i).top_model_line_id := p_line_varray(i).top_model_line_id;
846 x_line_tbl(i).top_model_line_index := p_line_varray(i).top_model_line_index;
847 x_line_tbl(i).unit_list_price := p_line_varray(i).unit_list_price;
848 x_line_tbl(i).unit_selling_price := p_line_varray(i).unit_selling_price;
849 x_line_tbl(i).veh_cus_item_cum_key_id := p_line_varray(i).veh_cus_item_cum_key_id;
850 x_line_tbl(i).visible_demand_flag := p_line_varray(i).visible_demand_flag;
851 x_line_tbl(i).return_status := p_line_varray(i).return_status;
852 x_line_tbl(i).db_flag := p_line_varray(i).db_flag;
853 x_line_tbl(i).operation := p_line_varray(i).operation;
854 x_line_tbl(i).first_ack_code := p_line_varray(i).first_ack_code;
855 x_line_tbl(i).first_ack_date := p_line_varray(i).first_ack_date;
856 x_line_tbl(i).last_ack_code := p_line_varray(i).last_ack_code;
857 x_line_tbl(i).last_ack_date := p_line_varray(i).last_ack_date;
858 x_line_tbl(i).change_reason := p_line_varray(i).change_reason;
859 x_line_tbl(i).change_comments := p_line_varray(i).change_comments;
860 x_line_tbl(i).arrival_set := p_line_varray(i).arrival_set;
861 x_line_tbl(i).ship_set := p_line_varray(i).ship_set;
862 x_line_tbl(i).order_source_id := p_line_varray(i).order_source_id;
863 x_line_tbl(i).orig_sys_shipment_ref := p_line_varray(i).orig_sys_shipment_ref;
864 x_line_tbl(i).change_sequence := p_line_varray(i).change_sequence;
865 x_line_tbl(i).change_request_code := p_line_varray(i).change_request_code;
866 x_line_tbl(i).status_flag := p_line_varray(i).status_flag;
867 x_line_tbl(i).drop_ship_flag := p_line_varray(i).drop_ship_flag;
868 x_line_tbl(i).customer_line_number := p_line_varray(i).customer_line_number;
869 x_line_tbl(i).customer_shipment_number := p_line_varray(i).customer_shipment_number;
870 x_line_tbl(i).customer_item_net_price := p_line_varray(i).customer_item_net_price;
871 x_line_tbl(i).customer_payment_term_id := p_line_varray(i).customer_payment_term_id;
872 x_line_tbl(i).ordered_item_id := p_line_varray(i).ordered_item_id;
873 x_line_tbl(i).item_identifier_type := p_line_varray(i).item_identifier_type;
874 x_line_tbl(i).shipping_instructions := p_line_varray(i).shipping_instructions;
875 x_line_tbl(i).packing_instructions := p_line_varray(i).packing_instructions;
876 x_line_tbl(i).calculate_price_flag := p_line_varray(i).calculate_price_flag;
877 x_line_tbl(i).invoiced_quantity := p_line_varray(i).invoiced_quantity;
878 x_line_tbl(i).service_txn_reason_code := p_line_varray(i).service_txn_reason_code;
879 x_line_tbl(i).service_txn_comments := p_line_varray(i).service_txn_comments;
880 x_line_tbl(i).service_duration := p_line_varray(i).service_duration;
881 x_line_tbl(i).service_period := p_line_varray(i).service_period;
882 x_line_tbl(i).service_start_date := p_line_varray(i).service_start_date;
883 x_line_tbl(i).service_end_date := p_line_varray(i).service_end_date;
884 x_line_tbl(i).service_coterminate_flag := p_line_varray(i).service_coterminate_flag;
885 x_line_tbl(i).unit_list_percent := p_line_varray(i).unit_list_percent;
886 x_line_tbl(i).unit_selling_percent := p_line_varray(i).unit_selling_percent;
887 x_line_tbl(i).unit_percent_base_price := p_line_varray(i).unit_percent_base_price;
888 x_line_tbl(i).service_number := p_line_varray(i).service_number;
889 x_line_tbl(i).service_reference_type_code := p_line_varray(i).service_reference_type_code;
890 x_line_tbl(i).service_reference_line_id := p_line_varray(i).service_reference_line_id;
891 x_line_tbl(i).service_reference_system_id := p_line_varray(i).service_reference_system_id;
892 x_line_tbl(i).service_ref_order_number := p_line_varray(i).service_ref_order_number;
893 x_line_tbl(i).service_ref_line_number := p_line_varray(i).service_ref_line_number;
894 x_line_tbl(i).service_ref_shipment_number := p_line_varray(i).service_ref_shipment_number;
895 x_line_tbl(i).service_ref_option_number := p_line_varray(i).service_ref_option_number;
899 x_line_tbl(i).Split_Action_Code := p_line_varray(i).Split_Action_Code;
896 x_line_tbl(i).service_line_index := p_line_varray(i).service_line_index;
897 x_line_tbl(i).Line_set_id := p_line_varray(i).Line_set_id;
898 x_line_tbl(i).split_by := p_line_varray(i).split_by;
900 x_line_tbl(i).shippable_flag := p_line_varray(i).shippable_flag;
901 x_line_tbl(i).model_remnant_flag := p_line_varray(i).model_remnant_flag;
902 x_line_tbl(i).flow_status_code := p_line_varray(i).flow_status_code;
903 x_line_tbl(i).fulfilled_flag := p_line_varray(i).fulfilled_flag;
904 x_line_tbl(i).fulfillment_method_code := p_line_varray(i).fulfillment_method_code;
905 x_line_tbl(i).semi_processed_flag := FND_API.To_Boolean(p_line_varray(i).semi_processed_flag);
906
907 i := p_line_varray.NEXT(i);
908
909 END LOOP;
910
911 END Line_Var_To_Tbl;
912
913
914 -- Line Adjs
915
916 PROCEDURE Line_Adj_Var_To_Tbl
917 (
918 p_line_adj_varray IN SYSTEM.ASO_Line_Adj_Var_Type,
919 x_line_adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type
920 )
921 IS
922 i NUMBER;
923
924 BEGIN
925 IF p_line_adj_varray is NULL THEN
926 x_line_adj_tbl := OE_Order_PUB.G_MISS_LINE_ADJ_TBL;
927 return;
928 END IF;
929
930 i := p_line_adj_varray.FIRST;
931 WHILE i IS NOT NULL LOOP
932 x_line_adj_tbl(i).attribute1 := p_line_adj_varray(i).attribute1;
933 x_line_adj_tbl(i).attribute10 := p_line_adj_varray(i).attribute10;
934 x_line_adj_tbl(i).attribute11 := p_line_adj_varray(i).attribute11;
935 x_line_adj_tbl(i).attribute12 := p_line_adj_varray(i).attribute12;
936 x_line_adj_tbl(i).attribute13 := p_line_adj_varray(i).attribute13;
937 x_line_adj_tbl(i).attribute14 := p_line_adj_varray(i).attribute14;
938 x_line_adj_tbl(i).attribute15 := p_line_adj_varray(i).attribute15;
939 x_line_adj_tbl(i).attribute2 := p_line_adj_varray(i).attribute2;
940 x_line_adj_tbl(i).attribute3 := p_line_adj_varray(i).attribute3;
941 x_line_adj_tbl(i).attribute4 := p_line_adj_varray(i).attribute4;
942 x_line_adj_tbl(i).attribute5 := p_line_adj_varray(i).attribute5;
943 x_line_adj_tbl(i).attribute6 := p_line_adj_varray(i).attribute6;
944 x_line_adj_tbl(i).attribute7 := p_line_adj_varray(i).attribute7;
945 x_line_adj_tbl(i).attribute8 := p_line_adj_varray(i).attribute8;
946 x_line_adj_tbl(i).attribute9 := p_line_adj_varray(i).attribute9;
947 x_line_adj_tbl(i).automatic_flag := p_line_adj_varray(i).automatic_flag;
948 x_line_adj_tbl(i).context := p_line_adj_varray(i).context;
949 x_line_adj_tbl(i).created_by := p_line_adj_varray(i).created_by;
950 x_line_adj_tbl(i).creation_date := p_line_adj_varray(i).creation_date;
951 x_line_adj_tbl(i).discount_id := p_line_adj_varray(i).discount_id;
952 x_line_adj_tbl(i).discount_line_id := p_line_adj_varray(i).discount_line_id;
953 x_line_adj_tbl(i).header_id := p_line_adj_varray(i).header_id;
954 x_line_adj_tbl(i).last_updated_by := p_line_adj_varray(i).last_updated_by;
955 x_line_adj_tbl(i).last_update_date := p_line_adj_varray(i).last_update_date;
956 x_line_adj_tbl(i).last_update_login := p_line_adj_varray(i).last_update_login;
957 x_line_adj_tbl(i).line_id := p_line_adj_varray(i).line_id;
958 x_line_adj_tbl(i).percent := p_line_adj_varray(i).percent;
959 x_line_adj_tbl(i).price_adjustment_id := p_line_adj_varray(i).price_adjustment_id;
960 x_line_adj_tbl(i).program_application_id := p_line_adj_varray(i).program_application_id;
961 x_line_adj_tbl(i).program_id := p_line_adj_varray(i).program_id;
962 x_line_adj_tbl(i).program_update_date := p_line_adj_varray(i).program_update_date;
963 x_line_adj_tbl(i).request_id := p_line_adj_varray(i).request_id;
964 x_line_adj_tbl(i).return_status := p_line_adj_varray(i).return_status;
965 x_line_adj_tbl(i).db_flag := p_line_adj_varray(i).db_flag;
966 x_line_adj_tbl(i).operation := p_line_adj_varray(i).operation;
967 x_line_adj_tbl(i).line_index := p_line_adj_varray(i).line_index;
968 x_line_adj_tbl(i).orig_sys_discount_ref := p_line_adj_varray(i).orig_sys_discount_ref;
969 x_line_adj_tbl(i).change_request_code := p_line_adj_varray(i).change_request_code;
970 x_line_adj_tbl(i).status_flag := p_line_adj_varray(i).status_flag;
971 x_line_adj_tbl(i).list_header_id := p_line_adj_varray(i).list_header_id;
972 x_line_adj_tbl(i).list_line_id := p_line_adj_varray(i).list_line_id;
973 x_line_adj_tbl(i).list_line_type_code := p_line_adj_varray(i).list_line_type_code;
974 x_line_adj_tbl(i).modifier_mechanism_type_code := p_line_adj_varray(i).modifier_mechanism_type_code;
975 x_line_adj_tbl(i).modified_from := p_line_adj_varray(i).modified_from;
976 x_line_adj_tbl(i).modified_to := p_line_adj_varray(i).modified_to;
977 x_line_adj_tbl(i).updated_flag := p_line_adj_varray(i).updated_flag;
978 x_line_adj_tbl(i).update_allowed := p_line_adj_varray(i).update_allowed;
982 x_line_adj_tbl(i).operand := p_line_adj_varray(i).operand;
979 x_line_adj_tbl(i).applied_flag := p_line_adj_varray(i).applied_flag;
980 x_line_adj_tbl(i).change_reason_code := p_line_adj_varray(i).change_reason_code;
981 x_line_adj_tbl(i).change_reason_text := p_line_adj_varray(i).change_reason_text;
983 x_line_adj_tbl(i).arithmetic_operator := p_line_adj_varray(i).arithmetic_operator;
984 x_line_adj_tbl(i).cost_id := p_line_adj_varray(i).cost_id;
985 x_line_adj_tbl(i).tax_code := p_line_adj_varray(i).tax_code;
986 x_line_adj_tbl(i).tax_exempt_flag := p_line_adj_varray(i).tax_exempt_flag;
987 x_line_adj_tbl(i).tax_exempt_number := p_line_adj_varray(i).tax_exempt_number;
988 x_line_adj_tbl(i).tax_exempt_reason_code := p_line_adj_varray(i).tax_exempt_reason_code;
989 x_line_adj_tbl(i).parent_adjustment_id := p_line_adj_varray(i).parent_adjustment_id;
990 x_line_adj_tbl(i).invoiced_flag := p_line_adj_varray(i).invoiced_flag;
991 x_line_adj_tbl(i).estimated_flag := p_line_adj_varray(i).estimated_flag;
992 x_line_adj_tbl(i).inc_in_sales_performance := p_line_adj_varray(i).inc_in_sales_performance;
993 x_line_adj_tbl(i).split_action_code := p_line_adj_varray(i).split_action_code;
994 x_line_adj_tbl(i).adjusted_amount := p_line_adj_varray(i).adjusted_amount;
995 x_line_adj_tbl(i).pricing_phase_id := p_line_adj_varray(i).pricing_phase_id;
996
997 i := p_line_adj_varray.NEXT(i);
998
999 END LOOP;
1000
1001 END Line_Adj_Var_To_Tbl;
1002
1003
1004 -- Line Price Atts
1005
1006 PROCEDURE Line_Price_Att_Var_To_Tbl
1007 (
1008 p_line_price_att_varray IN SYSTEM.ASO_Line_Price_Att_Var_Type,
1009 x_line_price_att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type
1010 )
1011 IS
1012 i NUMBER;
1013
1014 BEGIN
1015 IF p_line_price_att_varray is NULL THEN
1016 x_line_price_att_tbl := OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL;
1017 return;
1018 END IF;
1019
1020 i := p_line_price_att_varray.FIRST;
1021 WHILE i IS NOT NULL LOOP
1022 x_line_price_att_tbl(i).order_price_attrib_id := p_line_price_att_varray(i).order_price_attrib_id;
1023 x_line_price_att_tbl(i).header_id := p_line_price_att_varray(i).header_id;
1024 x_line_price_att_tbl(i).line_id := p_line_price_att_varray(i).line_id;
1025 x_line_price_att_tbl(i).line_index := p_line_price_att_varray(i).line_index;
1026 x_line_price_att_tbl(i).creation_date := p_line_price_att_varray(i).creation_date;
1027 x_line_price_att_tbl(i).created_by := p_line_price_att_varray(i).created_by;
1028 x_line_price_att_tbl(i).last_update_date := p_line_price_att_varray(i).last_update_date;
1029 x_line_price_att_tbl(i).last_updated_by := p_line_price_att_varray(i).last_updated_by;
1030 x_line_price_att_tbl(i).last_update_login := p_line_price_att_varray(i).last_update_login;
1031 x_line_price_att_tbl(i).program_application_id := p_line_price_att_varray(i).program_application_id;
1032 x_line_price_att_tbl(i).program_id := p_line_price_att_varray(i).program_id;
1033 x_line_price_att_tbl(i).program_update_date := p_line_price_att_varray(i).program_update_date;
1034 x_line_price_att_tbl(i).request_id := p_line_price_att_varray(i).request_id;
1035 x_line_price_att_tbl(i).flex_title := p_line_price_att_varray(i).flex_title;
1036 x_line_price_att_tbl(i).pricing_context := p_line_price_att_varray(i).pricing_context;
1037 x_line_price_att_tbl(i).pricing_attribute1 := p_line_price_att_varray(i).pricing_attribute1;
1038 x_line_price_att_tbl(i).pricing_attribute2 := p_line_price_att_varray(i).pricing_attribute2;
1039 x_line_price_att_tbl(i).pricing_attribute3 := p_line_price_att_varray(i).pricing_attribute3;
1040 x_line_price_att_tbl(i).pricing_attribute4 := p_line_price_att_varray(i).pricing_attribute4;
1041 x_line_price_att_tbl(i).pricing_attribute5 := p_line_price_att_varray(i).pricing_attribute5;
1042 x_line_price_att_tbl(i).pricing_attribute6 := p_line_price_att_varray(i).pricing_attribute6;
1043 x_line_price_att_tbl(i).pricing_attribute7 := p_line_price_att_varray(i).pricing_attribute7;
1044 x_line_price_att_tbl(i).pricing_attribute8 := p_line_price_att_varray(i).pricing_attribute8;
1045 x_line_price_att_tbl(i).pricing_attribute9 := p_line_price_att_varray(i).pricing_attribute9;
1046 x_line_price_att_tbl(i).pricing_attribute10 := p_line_price_att_varray(i).pricing_attribute10;
1047 x_line_price_att_tbl(i).pricing_attribute11 := p_line_price_att_varray(i).pricing_attribute11;
1048 x_line_price_att_tbl(i).pricing_attribute12 := p_line_price_att_varray(i).pricing_attribute12;
1049 x_line_price_att_tbl(i).pricing_attribute13 := p_line_price_att_varray(i).pricing_attribute13;
1050 x_line_price_att_tbl(i).pricing_attribute14 := p_line_price_att_varray(i).pricing_attribute14;
1051 x_line_price_att_tbl(i).pricing_attribute15 := p_line_price_att_varray(i).pricing_attribute15;
1052 x_line_price_att_tbl(i).pricing_attribute16 := p_line_price_att_varray(i).pricing_attribute16;
1053 x_line_price_att_tbl(i).pricing_attribute17 := p_line_price_att_varray(i).pricing_attribute17;
1057 x_line_price_att_tbl(i).pricing_attribute21 := p_line_price_att_varray(i).pricing_attribute21;
1054 x_line_price_att_tbl(i).pricing_attribute18 := p_line_price_att_varray(i).pricing_attribute18;
1055 x_line_price_att_tbl(i).pricing_attribute19 := p_line_price_att_varray(i).pricing_attribute19;
1056 x_line_price_att_tbl(i).pricing_attribute20 := p_line_price_att_varray(i).pricing_attribute20;
1058 x_line_price_att_tbl(i).pricing_attribute22 := p_line_price_att_varray(i).pricing_attribute22;
1059 x_line_price_att_tbl(i).pricing_attribute23 := p_line_price_att_varray(i).pricing_attribute23;
1060 x_line_price_att_tbl(i).pricing_attribute24 := p_line_price_att_varray(i).pricing_attribute24;
1061 x_line_price_att_tbl(i).pricing_attribute25 := p_line_price_att_varray(i).pricing_attribute25;
1062 x_line_price_att_tbl(i).pricing_attribute26 := p_line_price_att_varray(i).pricing_attribute26;
1063 x_line_price_att_tbl(i).pricing_attribute27 := p_line_price_att_varray(i).pricing_attribute27;
1064 x_line_price_att_tbl(i).pricing_attribute28 := p_line_price_att_varray(i).pricing_attribute28;
1065 x_line_price_att_tbl(i).pricing_attribute29 := p_line_price_att_varray(i).pricing_attribute29;
1066 x_line_price_att_tbl(i).pricing_attribute30 := p_line_price_att_varray(i).pricing_attribute30;
1067 x_line_price_att_tbl(i).pricing_attribute31 := p_line_price_att_varray(i).pricing_attribute31;
1068 x_line_price_att_tbl(i).pricing_attribute32 := p_line_price_att_varray(i).pricing_attribute32;
1069 x_line_price_att_tbl(i).pricing_attribute33 := p_line_price_att_varray(i).pricing_attribute33;
1070 x_line_price_att_tbl(i).pricing_attribute34 := p_line_price_att_varray(i).pricing_attribute34;
1071 x_line_price_att_tbl(i).pricing_attribute35 := p_line_price_att_varray(i).pricing_attribute35;
1072 x_line_price_att_tbl(i).pricing_attribute36 := p_line_price_att_varray(i).pricing_attribute36;
1073 x_line_price_att_tbl(i).pricing_attribute37 := p_line_price_att_varray(i).pricing_attribute37;
1074 x_line_price_att_tbl(i).pricing_attribute38 := p_line_price_att_varray(i).pricing_attribute38;
1075 x_line_price_att_tbl(i).pricing_attribute39 := p_line_price_att_varray(i).pricing_attribute39;
1076 x_line_price_att_tbl(i).pricing_attribute40 := p_line_price_att_varray(i).pricing_attribute40;
1077 x_line_price_att_tbl(i).pricing_attribute41 := p_line_price_att_varray(i).pricing_attribute41;
1078 x_line_price_att_tbl(i).pricing_attribute42 := p_line_price_att_varray(i).pricing_attribute42;
1079 x_line_price_att_tbl(i).pricing_attribute43 := p_line_price_att_varray(i).pricing_attribute43;
1080 x_line_price_att_tbl(i).pricing_attribute44 := p_line_price_att_varray(i).pricing_attribute44;
1081 x_line_price_att_tbl(i).pricing_attribute45 := p_line_price_att_varray(i).pricing_attribute45;
1082 x_line_price_att_tbl(i).pricing_attribute46 := p_line_price_att_varray(i).pricing_attribute46;
1083 x_line_price_att_tbl(i).pricing_attribute47 := p_line_price_att_varray(i).pricing_attribute47;
1084 x_line_price_att_tbl(i).pricing_attribute48 := p_line_price_att_varray(i).pricing_attribute48;
1085 x_line_price_att_tbl(i).pricing_attribute49 := p_line_price_att_varray(i).pricing_attribute49;
1086 x_line_price_att_tbl(i).pricing_attribute50 := p_line_price_att_varray(i).pricing_attribute50;
1087 x_line_price_att_tbl(i).pricing_attribute51 := p_line_price_att_varray(i).pricing_attribute51;
1088 x_line_price_att_tbl(i).pricing_attribute52 := p_line_price_att_varray(i).pricing_attribute52;
1089 x_line_price_att_tbl(i).pricing_attribute53 := p_line_price_att_varray(i).pricing_attribute53;
1090 x_line_price_att_tbl(i).pricing_attribute54 := p_line_price_att_varray(i).pricing_attribute54;
1091 x_line_price_att_tbl(i).pricing_attribute55 := p_line_price_att_varray(i).pricing_attribute55;
1092 x_line_price_att_tbl(i).pricing_attribute56 := p_line_price_att_varray(i).pricing_attribute56;
1093 x_line_price_att_tbl(i).pricing_attribute57 := p_line_price_att_varray(i).pricing_attribute57;
1094 x_line_price_att_tbl(i).pricing_attribute58 := p_line_price_att_varray(i).pricing_attribute58;
1095 x_line_price_att_tbl(i).pricing_attribute59 := p_line_price_att_varray(i).pricing_attribute59;
1096 x_line_price_att_tbl(i).pricing_attribute60 := p_line_price_att_varray(i).pricing_attribute60;
1097 x_line_price_att_tbl(i).pricing_attribute61 := p_line_price_att_varray(i).pricing_attribute61;
1098 x_line_price_att_tbl(i).pricing_attribute62 := p_line_price_att_varray(i).pricing_attribute62;
1099 x_line_price_att_tbl(i).pricing_attribute63 := p_line_price_att_varray(i).pricing_attribute63;
1100 x_line_price_att_tbl(i).pricing_attribute64 := p_line_price_att_varray(i).pricing_attribute64;
1101 x_line_price_att_tbl(i).pricing_attribute65 := p_line_price_att_varray(i).pricing_attribute65;
1102 x_line_price_att_tbl(i).pricing_attribute66 := p_line_price_att_varray(i).pricing_attribute66;
1103 x_line_price_att_tbl(i).pricing_attribute67 := p_line_price_att_varray(i).pricing_attribute67;
1104 x_line_price_att_tbl(i).pricing_attribute68 := p_line_price_att_varray(i).pricing_attribute68;
1105 x_line_price_att_tbl(i).pricing_attribute69 := p_line_price_att_varray(i).pricing_attribute69;
1109 x_line_price_att_tbl(i).pricing_attribute73 := p_line_price_att_varray(i).pricing_attribute73;
1106 x_line_price_att_tbl(i).pricing_attribute70 := p_line_price_att_varray(i).pricing_attribute70;
1107 x_line_price_att_tbl(i).pricing_attribute71 := p_line_price_att_varray(i).pricing_attribute71;
1108 x_line_price_att_tbl(i).pricing_attribute72 := p_line_price_att_varray(i).pricing_attribute72;
1110 x_line_price_att_tbl(i).pricing_attribute74 := p_line_price_att_varray(i).pricing_attribute74;
1111 x_line_price_att_tbl(i).pricing_attribute75 := p_line_price_att_varray(i).pricing_attribute75;
1112 x_line_price_att_tbl(i).pricing_attribute76 := p_line_price_att_varray(i).pricing_attribute76;
1113 x_line_price_att_tbl(i).pricing_attribute77 := p_line_price_att_varray(i).pricing_attribute77;
1114 x_line_price_att_tbl(i).pricing_attribute78 := p_line_price_att_varray(i).pricing_attribute78;
1115 x_line_price_att_tbl(i).pricing_attribute79 := p_line_price_att_varray(i).pricing_attribute79;
1116 x_line_price_att_tbl(i).pricing_attribute80 := p_line_price_att_varray(i).pricing_attribute80;
1117 x_line_price_att_tbl(i).pricing_attribute81 := p_line_price_att_varray(i).pricing_attribute81;
1118 x_line_price_att_tbl(i).pricing_attribute82 := p_line_price_att_varray(i).pricing_attribute82;
1119 x_line_price_att_tbl(i).pricing_attribute83 := p_line_price_att_varray(i).pricing_attribute83;
1120 x_line_price_att_tbl(i).pricing_attribute84 := p_line_price_att_varray(i).pricing_attribute84;
1121 x_line_price_att_tbl(i).pricing_attribute85 := p_line_price_att_varray(i).pricing_attribute85;
1122 x_line_price_att_tbl(i).pricing_attribute86 := p_line_price_att_varray(i).pricing_attribute86;
1123 x_line_price_att_tbl(i).pricing_attribute87 := p_line_price_att_varray(i).pricing_attribute87;
1124 x_line_price_att_tbl(i).pricing_attribute88 := p_line_price_att_varray(i).pricing_attribute88;
1125 x_line_price_att_tbl(i).pricing_attribute89 := p_line_price_att_varray(i).pricing_attribute89;
1126 x_line_price_att_tbl(i).pricing_attribute90 := p_line_price_att_varray(i).pricing_attribute90;
1127 x_line_price_att_tbl(i).pricing_attribute91 := p_line_price_att_varray(i).pricing_attribute91;
1128 x_line_price_att_tbl(i).pricing_attribute92 := p_line_price_att_varray(i).pricing_attribute92;
1129 x_line_price_att_tbl(i).pricing_attribute93 := p_line_price_att_varray(i).pricing_attribute93;
1130 x_line_price_att_tbl(i).pricing_attribute94 := p_line_price_att_varray(i).pricing_attribute94;
1131 x_line_price_att_tbl(i).pricing_attribute95 := p_line_price_att_varray(i).pricing_attribute95;
1132 x_line_price_att_tbl(i).pricing_attribute96 := p_line_price_att_varray(i).pricing_attribute96;
1133 x_line_price_att_tbl(i).pricing_attribute97 := p_line_price_att_varray(i).pricing_attribute97;
1134 x_line_price_att_tbl(i).pricing_attribute98 := p_line_price_att_varray(i).pricing_attribute98;
1135 x_line_price_att_tbl(i).pricing_attribute99 := p_line_price_att_varray(i).pricing_attribute99;
1136 x_line_price_att_tbl(i).pricing_attribute100 := p_line_price_att_varray(i).pricing_attribute100;
1137 x_line_price_att_tbl(i).context := p_line_price_att_varray(i).context;
1138 x_line_price_att_tbl(i).attribute1 := p_line_price_att_varray(i).attribute1;
1139 x_line_price_att_tbl(i).attribute2 := p_line_price_att_varray(i).attribute2;
1140 x_line_price_att_tbl(i).attribute3 := p_line_price_att_varray(i).attribute3;
1141 x_line_price_att_tbl(i).attribute4 := p_line_price_att_varray(i).attribute4;
1142 x_line_price_att_tbl(i).attribute5 := p_line_price_att_varray(i).attribute5;
1143 x_line_price_att_tbl(i).attribute6 := p_line_price_att_varray(i).attribute6;
1144 x_line_price_att_tbl(i).attribute7 := p_line_price_att_varray(i).attribute7;
1145 x_line_price_att_tbl(i).attribute8 := p_line_price_att_varray(i).attribute8;
1146 x_line_price_att_tbl(i).attribute9 := p_line_price_att_varray(i).attribute9;
1147 x_line_price_att_tbl(i).attribute10 := p_line_price_att_varray(i).attribute10;
1148 x_line_price_att_tbl(i).attribute11 := p_line_price_att_varray(i).attribute11;
1149 x_line_price_att_tbl(i).attribute12 := p_line_price_att_varray(i).attribute12;
1150 x_line_price_att_tbl(i).attribute13 := p_line_price_att_varray(i).attribute13;
1151 x_line_price_att_tbl(i).attribute14 := p_line_price_att_varray(i).attribute14;
1152 x_line_price_att_tbl(i).attribute15 := p_line_price_att_varray(i).attribute15;
1153 x_line_price_att_tbl(i).return_status := p_line_price_att_varray(i).return_status;
1154 x_line_price_att_tbl(i).db_flag := p_line_price_att_varray(i).db_flag;
1155 x_line_price_att_tbl(i).operation := p_line_price_att_varray(i).operation;
1156
1157 i := p_line_price_att_varray.NEXT(i);
1158
1159 END LOOP;
1160
1161 END Line_Price_Att_Var_To_Tbl;
1162
1163
1164 -- Line Adj Atts
1165
1166 PROCEDURE Line_Adj_Att_Var_To_Tbl
1167 (
1168 p_line_adj_att_varray IN SYSTEM.ASO_Line_Adj_Att_Var_Type,
1169 x_line_adj_att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type
1170 )
1171 IS
1175 IF p_line_adj_att_varray is NULL THEN
1172 i NUMBER;
1173
1174 BEGIN
1176 x_line_adj_att_tbl := OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL;
1177 return;
1178 END IF;
1179
1180 i := p_line_adj_att_varray.FIRST;
1181 WHILE i IS NOT NULL LOOP
1182 x_line_adj_att_tbl(i).price_adj_attrib_id := p_line_adj_att_varray(i).price_adj_attrib_id;
1183 x_line_adj_att_tbl(i).price_adjustment_id := p_line_adj_att_varray(i).price_adjustment_id;
1184 x_line_adj_att_tbl(i).adj_index := p_line_adj_att_varray(i).adj_index;
1185 x_line_adj_att_tbl(i).flex_title := p_line_adj_att_varray(i).flex_title;
1186 x_line_adj_att_tbl(i).pricing_context := p_line_adj_att_varray(i).pricing_context;
1187 x_line_adj_att_tbl(i).pricing_attribute := p_line_adj_att_varray(i).pricing_attribute;
1188 x_line_adj_att_tbl(i).creation_date := p_line_adj_att_varray(i).creation_date;
1189 x_line_adj_att_tbl(i).created_by := p_line_adj_att_varray(i).created_by;
1190 x_line_adj_att_tbl(i).last_update_date := p_line_adj_att_varray(i).last_update_date;
1191 x_line_adj_att_tbl(i).last_updated_by := p_line_adj_att_varray(i).last_updated_by;
1192 x_line_adj_att_tbl(i).last_update_login := p_line_adj_att_varray(i).last_update_login;
1193 x_line_adj_att_tbl(i).program_application_id := p_line_adj_att_varray(i).program_application_id;
1194 x_line_adj_att_tbl(i).program_id := p_line_adj_att_varray(i).program_id;
1195 x_line_adj_att_tbl(i).program_update_date := p_line_adj_att_varray(i).program_update_date;
1196 x_line_adj_att_tbl(i).request_id := p_line_adj_att_varray(i).request_id;
1197 x_line_adj_att_tbl(i).pricing_attr_value_from := p_line_adj_att_varray(i).pricing_attr_value_from;
1198 x_line_adj_att_tbl(i).pricing_attr_value_to := p_line_adj_att_varray(i).pricing_attr_value_to;
1199 x_line_adj_att_tbl(i).comparison_operator := p_line_adj_att_varray(i).comparison_operator;
1200 x_line_adj_att_tbl(i).return_status := p_line_adj_att_varray(i).return_status;
1201 x_line_adj_att_tbl(i).db_flag := p_line_adj_att_varray(i).db_flag;
1202 x_line_adj_att_tbl(i).operation := p_line_adj_att_varray(i).operation;
1203
1204 i := p_line_adj_att_varray.NEXT(i);
1205
1206 END LOOP;
1207
1208 END Line_Adj_Att_Var_To_Tbl;
1209
1210
1211 -- Line Adj Assocs
1212
1213 PROCEDURE Line_Adj_Assoc_Var_To_Tbl
1214 (
1215 p_line_adj_assoc_varray IN SYSTEM.ASO_Line_Adj_Assoc_Var_Type,
1216 x_line_adj_assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
1217 )
1218 IS
1219 i NUMBER;
1220
1221 BEGIN
1222 IF p_line_adj_assoc_varray is NULL THEN
1223 x_line_adj_assoc_tbl := OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL;
1224 return;
1225 END IF;
1226
1227 i := p_line_adj_assoc_varray.FIRST;
1228 WHILE i IS NOT NULL LOOP
1229 x_line_adj_assoc_tbl(i).price_adj_assoc_id := p_line_adj_assoc_varray(i).price_adj_assoc_id;
1230 x_line_adj_assoc_tbl(i).line_id := p_line_adj_assoc_varray(i).line_id;
1231 x_line_adj_assoc_tbl(i).line_index := p_line_adj_assoc_varray(i).line_index;
1232 x_line_adj_assoc_tbl(i).price_adjustment_id := p_line_adj_assoc_varray(i).price_adjustment_id;
1233 x_line_adj_assoc_tbl(i).adj_index := p_line_adj_assoc_varray(i).adj_index;
1234 x_line_adj_assoc_tbl(i).creation_date := p_line_adj_assoc_varray(i).creation_date;
1235 x_line_adj_assoc_tbl(i).created_by := p_line_adj_assoc_varray(i).created_by;
1236 x_line_adj_assoc_tbl(i).last_update_date := p_line_adj_assoc_varray(i).last_update_date;
1237 x_line_adj_assoc_tbl(i).last_updated_by := p_line_adj_assoc_varray(i).last_updated_by;
1238 x_line_adj_assoc_tbl(i).last_update_login := p_line_adj_assoc_varray(i).last_update_login;
1239 x_line_adj_assoc_tbl(i).program_application_id := p_line_adj_assoc_varray(i).program_application_id;
1240 x_line_adj_assoc_tbl(i).program_id := p_line_adj_assoc_varray(i).program_id;
1241 x_line_adj_assoc_tbl(i).program_update_date := p_line_adj_assoc_varray(i).program_update_date;
1242 x_line_adj_assoc_tbl(i).request_id := p_line_adj_assoc_varray(i).request_id;
1243 x_line_adj_assoc_tbl(i).return_status := p_line_adj_assoc_varray(i).return_status;
1244 x_line_adj_assoc_tbl(i).db_flag := p_line_adj_assoc_varray(i).db_flag;
1245 x_line_adj_assoc_tbl(i).operation := p_line_adj_assoc_varray(i).operation;
1246
1247 i := p_line_adj_assoc_varray.NEXT(i);
1248
1249 END LOOP;
1250
1251 END Line_Adj_Assoc_Var_To_Tbl;
1252
1253
1254 -- Line Scredits
1255
1256 PROCEDURE Line_Scredit_Var_To_Tbl
1257 (
1258 p_line_scredit_varray IN SYSTEM.ASO_Line_Scredit_Var_Type,
1259 x_line_scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type
1260 )
1261 IS
1262 i NUMBER;
1263
1264 BEGIN
1265 IF p_line_scredit_varray is NULL THEN
1266 x_line_scredit_tbl := OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL;
1267 return;
1268 END IF;
1269
1270 i := p_line_scredit_varray.FIRST;
1271 WHILE i IS NOT NULL LOOP
1272 x_line_scredit_tbl(i).attribute1 := p_line_scredit_varray(i).attribute1;
1276 x_line_scredit_tbl(i).attribute13 := p_line_scredit_varray(i).attribute13;
1273 x_line_scredit_tbl(i).attribute10 := p_line_scredit_varray(i).attribute10;
1274 x_line_scredit_tbl(i).attribute11 := p_line_scredit_varray(i).attribute11;
1275 x_line_scredit_tbl(i).attribute12 := p_line_scredit_varray(i).attribute12;
1277 x_line_scredit_tbl(i).attribute14 := p_line_scredit_varray(i).attribute14;
1278 x_line_scredit_tbl(i).attribute15 := p_line_scredit_varray(i).attribute15;
1279 x_line_scredit_tbl(i).attribute2 := p_line_scredit_varray(i).attribute2;
1280 x_line_scredit_tbl(i).attribute3 := p_line_scredit_varray(i).attribute3;
1281 x_line_scredit_tbl(i).attribute4 := p_line_scredit_varray(i).attribute4;
1282 x_line_scredit_tbl(i).attribute5 := p_line_scredit_varray(i).attribute5;
1283 x_line_scredit_tbl(i).attribute6 := p_line_scredit_varray(i).attribute6;
1284 x_line_scredit_tbl(i).attribute7 := p_line_scredit_varray(i).attribute7;
1285 x_line_scredit_tbl(i).attribute8 := p_line_scredit_varray(i).attribute8;
1286 x_line_scredit_tbl(i).attribute9 := p_line_scredit_varray(i).attribute9;
1287 x_line_scredit_tbl(i).context := p_line_scredit_varray(i).context;
1288 x_line_scredit_tbl(i).created_by := p_line_scredit_varray(i).created_by;
1289 x_line_scredit_tbl(i).creation_date := p_line_scredit_varray(i).creation_date;
1290 x_line_scredit_tbl(i).dw_update_advice_flag := p_line_scredit_varray(i).dw_update_advice_flag;
1291 x_line_scredit_tbl(i).header_id := p_line_scredit_varray(i).header_id;
1292 x_line_scredit_tbl(i).last_updated_by := p_line_scredit_varray(i).last_updated_by;
1293 x_line_scredit_tbl(i).last_update_date := p_line_scredit_varray(i).last_update_date;
1294 x_line_scredit_tbl(i).last_update_login := p_line_scredit_varray(i).last_update_login;
1295 x_line_scredit_tbl(i).line_id := p_line_scredit_varray(i).line_id;
1296 x_line_scredit_tbl(i).percent := p_line_scredit_varray(i).percent;
1297 x_line_scredit_tbl(i).salesrep_id := p_line_scredit_varray(i).salesrep_id;
1298 x_line_scredit_tbl(i).sales_credit_id := p_line_scredit_varray(i).sales_credit_id;
1299 x_line_scredit_tbl(i).wh_update_date := p_line_scredit_varray(i).wh_update_date;
1300 x_line_scredit_tbl(i).return_status := p_line_scredit_varray(i).return_status;
1301 x_line_scredit_tbl(i).db_flag := p_line_scredit_varray(i).db_flag;
1302 x_line_scredit_tbl(i).operation := p_line_scredit_varray(i).operation;
1303 x_line_scredit_tbl(i).line_index := p_line_scredit_varray(i).line_index;
1304 x_line_scredit_tbl(i).orig_sys_credit_ref := p_line_scredit_varray(i).orig_sys_credit_ref;
1305 x_line_scredit_tbl(i).change_request_code := p_line_scredit_varray(i).change_request_code;
1306 x_line_scredit_tbl(i).status_flag := p_line_scredit_varray(i).status_flag;
1307
1308 i := p_line_scredit_varray.NEXT(i);
1309
1310 END LOOP;
1311
1312 END Line_Scredit_Var_To_Tbl;
1313
1314
1315 -- Lot Serials
1316
1317 PROCEDURE Lot_Serial_Var_To_Tbl
1318 (
1319 p_lot_serial_varray IN SYSTEM.ASO_Lot_Serial_Var_Type,
1320 x_lot_serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type
1321 )
1322 IS
1323 i NUMBER;
1324
1325 BEGIN
1326 IF p_lot_serial_varray is NULL THEN
1327 x_lot_serial_tbl := OE_Order_PUB.G_MISS_LOT_SERIAL_TBL;
1328 return;
1329 END IF;
1330
1331 i := p_lot_serial_varray.FIRST;
1332 WHILE i IS NOT NULL LOOP
1333 x_lot_serial_tbl(i).attribute1 := p_lot_serial_varray(i).attribute1;
1334 x_lot_serial_tbl(i).attribute10 := p_lot_serial_varray(i).attribute10;
1335 x_lot_serial_tbl(i).attribute11 := p_lot_serial_varray(i).attribute11;
1336 x_lot_serial_tbl(i).attribute12 := p_lot_serial_varray(i).attribute12;
1337 x_lot_serial_tbl(i).attribute13 := p_lot_serial_varray(i).attribute13;
1338 x_lot_serial_tbl(i).attribute14 := p_lot_serial_varray(i).attribute14;
1339 x_lot_serial_tbl(i).attribute15 := p_lot_serial_varray(i).attribute15;
1340 x_lot_serial_tbl(i).attribute2 := p_lot_serial_varray(i).attribute2;
1341 x_lot_serial_tbl(i).attribute3 := p_lot_serial_varray(i).attribute3;
1342 x_lot_serial_tbl(i).attribute4 := p_lot_serial_varray(i).attribute4;
1343 x_lot_serial_tbl(i).attribute5 := p_lot_serial_varray(i).attribute5;
1344 x_lot_serial_tbl(i).attribute6 := p_lot_serial_varray(i).attribute6;
1345 x_lot_serial_tbl(i).attribute7 := p_lot_serial_varray(i).attribute7;
1346 x_lot_serial_tbl(i).attribute8 := p_lot_serial_varray(i).attribute8;
1347 x_lot_serial_tbl(i).attribute9 := p_lot_serial_varray(i).attribute9;
1348 x_lot_serial_tbl(i).context := p_lot_serial_varray(i).context;
1349 x_lot_serial_tbl(i).created_by := p_lot_serial_varray(i).created_by;
1350 x_lot_serial_tbl(i).creation_date := p_lot_serial_varray(i).creation_date;
1351 x_lot_serial_tbl(i).from_serial_number := p_lot_serial_varray(i).from_serial_number;
1352 x_lot_serial_tbl(i).last_updated_by := p_lot_serial_varray(i).last_updated_by;
1353 x_lot_serial_tbl(i).last_update_date := p_lot_serial_varray(i).last_update_date;
1357 x_lot_serial_tbl(i).lot_serial_id := p_lot_serial_varray(i).lot_serial_id;
1354 x_lot_serial_tbl(i).last_update_login := p_lot_serial_varray(i).last_update_login;
1355 x_lot_serial_tbl(i).line_id := p_lot_serial_varray(i).line_id;
1356 x_lot_serial_tbl(i).lot_number := p_lot_serial_varray(i).lot_number;
1358 x_lot_serial_tbl(i).quantity := p_lot_serial_varray(i).quantity;
1359 x_lot_serial_tbl(i).to_serial_number := p_lot_serial_varray(i).to_serial_number;
1360 x_lot_serial_tbl(i).return_status := p_lot_serial_varray(i).return_status;
1361 x_lot_serial_tbl(i).db_flag := p_lot_serial_varray(i).db_flag;
1362 x_lot_serial_tbl(i).operation := p_lot_serial_varray(i).operation;
1363 x_lot_serial_tbl(i).line_index := p_lot_serial_varray(i).line_index;
1364 x_lot_serial_tbl(i).orig_sys_lotserial_ref := p_lot_serial_varray(i).orig_sys_lotserial_ref;
1365 x_lot_serial_tbl(i).change_request_code := p_lot_serial_varray(i).change_request_code;
1366 x_lot_serial_tbl(i).status_flag := p_lot_serial_varray(i).status_flag;
1367 x_lot_serial_tbl(i).line_set_id := p_lot_serial_varray(i).line_set_id;
1368
1369 i := p_lot_serial_varray.NEXT(i);
1370
1371 END LOOP;
1372
1373 END Lot_Serial_Var_To_Tbl;
1374
1375
1376 -- Action Requests
1377
1378 PROCEDURE Action_Request_Var_To_Tbl
1379 (
1380 p_action_request_varray IN SYSTEM.ASO_Request_Var_Type,
1381 x_action_request_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Request_Tbl_Type
1382 )
1383 IS
1384 i NUMBER;
1385
1386 BEGIN
1387 IF p_action_request_varray is NULL THEN
1388 x_action_request_tbl := OE_Order_PUB.G_MISS_REQUEST_TBL;
1389 return;
1390 END IF;
1391
1392 i := p_action_request_varray.FIRST;
1393 WHILE i IS NOT NULL LOOP
1394 x_action_request_tbl(i).entity_code := p_action_request_varray(i).entity_code;
1395 x_action_request_tbl(i).entity_id := p_action_request_varray(i).entity_id;
1396 x_action_request_tbl(i).entity_index := p_action_request_varray(i).entity_index;
1397 x_action_request_tbl(i).request_type := p_action_request_varray(i).request_type;
1398 x_action_request_tbl(i).return_status := p_action_request_varray(i).return_status;
1399 x_action_request_tbl(i).request_unique_key1 := p_action_request_varray(i).request_unique_key1;
1400 x_action_request_tbl(i).request_unique_key2 := p_action_request_varray(i).request_unique_key2;
1401 x_action_request_tbl(i).request_unique_key3 := p_action_request_varray(i).request_unique_key3;
1402 x_action_request_tbl(i).request_unique_key4 := p_action_request_varray(i).request_unique_key4;
1403 x_action_request_tbl(i).request_unique_key5 := p_action_request_varray(i).request_unique_key5;
1404 x_action_request_tbl(i).param1 := p_action_request_varray(i).param1;
1405 x_action_request_tbl(i).param2 := p_action_request_varray(i).param2;
1406 x_action_request_tbl(i).param3 := p_action_request_varray(i).param3;
1407 x_action_request_tbl(i).param4 := p_action_request_varray(i).param4;
1408 x_action_request_tbl(i).param5 := p_action_request_varray(i).param5;
1409 x_action_request_tbl(i).param6 := p_action_request_varray(i).param6;
1410 x_action_request_tbl(i).param7 := p_action_request_varray(i).param7;
1411 x_action_request_tbl(i).param8 := p_action_request_varray(i).param8;
1412 x_action_request_tbl(i).param9 := p_action_request_varray(i).param9;
1413 x_action_request_tbl(i).param10 := p_action_request_varray(i).param10;
1414 x_action_request_tbl(i).param11 := p_action_request_varray(i).param11;
1415 x_action_request_tbl(i).param12 := p_action_request_varray(i).param12;
1416 x_action_request_tbl(i).param13 := p_action_request_varray(i).param13;
1417 x_action_request_tbl(i).param14 := p_action_request_varray(i).param14;
1418 x_action_request_tbl(i).param15 := p_action_request_varray(i).param15;
1419 x_action_request_tbl(i).param16 := p_action_request_varray(i).param16;
1420 x_action_request_tbl(i).param17 := p_action_request_varray(i).param17;
1421 x_action_request_tbl(i).param18 := p_action_request_varray(i).param18;
1422 x_action_request_tbl(i).param19 := p_action_request_varray(i).param19;
1423 x_action_request_tbl(i).param20 := p_action_request_varray(i).param20;
1424 x_action_request_tbl(i).param21 := p_action_request_varray(i).param21;
1425 x_action_request_tbl(i).param22 := p_action_request_varray(i).param22;
1426 x_action_request_tbl(i).param23 := p_action_request_varray(i).param23;
1427 x_action_request_tbl(i).param24 := p_action_request_varray(i).param24;
1428 x_action_request_tbl(i).param25 := p_action_request_varray(i).param25;
1429 x_action_request_tbl(i).long_param1 := p_action_request_varray(i).long_param1;
1430 x_action_request_tbl(i).date_param1 := p_action_request_varray(i).date_param1;
1431 x_action_request_tbl(i).date_param2 := p_action_request_varray(i).date_param2;
1432 x_action_request_tbl(i).date_param3 := p_action_request_varray(i).date_param3;
1436
1433 x_action_request_tbl(i).date_param4 := p_action_request_varray(i).date_param4;
1434 x_action_request_tbl(i).date_param5 := p_action_request_varray(i).date_param5;
1435 x_action_request_tbl(i).processed := p_action_request_varray(i).processed;
1437 i := p_action_request_varray.NEXT(i);
1438
1439 END LOOP;
1440
1441 END Action_Request_Var_To_Tbl;
1442
1443
1444 -- Start of comments
1445 -- API name : GET_NOTICE
1446 -- Type : Private
1447 -- Function : This API is the PRIVATE API that is invoked by CRM Apps
1448 -- to get the data regarding changes (inserts/updates/deletes) to the
1449 -- Order Entities communicated by the Order Management application.
1450 -- Pre-reqs : None.
1451 --
1452 -- Standard IN Parameters:
1453 -- p_api_version IN NUMBER Required
1454 -- p_init_msg_list IN VARCHAR2 Optional
1455 -- Default = FND_API.G_FALSE
1456 -- p_commit IN VARCHAR2 Optional
1457 -- Default = FND_API.G_FALSE
1458 --
1459 -- Standard OUT NOCOPY /* file.sql.39 change */ Parameters:
1460 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2(1)
1461 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1462 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2(2000)
1463 --
1464 -- GET_NOTICE API specific IN Parameters:
1465 -- p_app_short_name IN VARCHAR2 Required
1466 -- p_queue_type IN VARCHAR2 Optional
1467 -- Default = OF_QUEUE
1468 -- p_dequeue_mode IN NUMBER Optional
1469 -- Default = DBMS_AQ.REMOVE
1470 -- p_dequeue_navigation IN NUMBER Optional
1471 -- Default = DBMS_AQ.FIRST_MESSAGE
1472 -- p_wait IN NUMBER Optional
1473 -- Default = DBMS_AQ.NO_WAIT
1474 --
1475 -- GET_NOTICE API specific OUT NOCOPY /* file.sql.39 change */ Parameters:
1476 --
1477 -- x_no_more_messages OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1478 -- x_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type
1479 -- x_old_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type
1480 -- x_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type
1481 -- x_old_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type
1482 -- x_Header_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type
1483 -- x_old_Header_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type
1484 -- x_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type
1485 -- x_old_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type
1486 -- x_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
1487 -- x_old_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
1488 -- x_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type
1489 -- x_old_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type
1490 -- x_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type
1491 -- x_old_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type
1492 -- x_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type
1493 -- x_old_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type
1494 -- x_Line_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type
1495 -- x_old_Line_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type
1496 -- x_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type
1497 -- x_old_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type
1498 -- x_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
1499 -- x_old_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
1500 -- x_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type
1501 -- x_old_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type
1502 -- x_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type
1503 -- x_old_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type
1504 -- x_Action_Request_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Request_Tbl_Type
1505 --
1506 --
1507 -- Version : Current version 1.0
1508 -- Initial version 1.0
1509 --
1510 -- End of comments
1511 --------------------------------------------------------------------------
1512
1513 PROCEDURE GET_NOTICE
1514 (
1515 p_api_version IN NUMBER,
1516 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1517 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1518 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1519 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
1523 p_dequeue_mode IN NUMBER DEFAULT DBMS_AQ.REMOVE,
1520 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1521 p_app_short_name IN VARCHAR2,
1522 p_queue_type IN VARCHAR2 DEFAULT 'OF_QUEUE',
1524 p_navigation IN NUMBER DEFAULT DBMS_AQ.FIRST_MESSAGE,
1525 p_wait IN NUMBER DEFAULT DBMS_AQ.NO_WAIT,
1526 x_no_more_messages OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1527 x_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type,
1528 x_old_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type,
1529 x_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type,
1530 x_old_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type,
1531 x_Header_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type,
1532 x_old_Header_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type,
1533 x_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type,
1534 x_old_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type,
1535 x_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
1536 x_old_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
1537 x_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type,
1538 x_old_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type,
1539 x_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type,
1540 x_old_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type,
1541 x_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type,
1542 x_old_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type,
1543 x_Line_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type,
1544 x_old_Line_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type,
1545 x_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type,
1546 x_old_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type,
1547 x_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
1548 x_old_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
1549 x_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type,
1550 x_old_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type,
1551 x_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type,
1552 x_old_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type,
1553 x_Action_Request_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Request_Tbl_Type
1554 ) IS
1555 i number;
1556 l_api_name CONSTANT VARCHAR2(30) := 'GET_NOTICE';
1557 l_api_version CONSTANT NUMBER := 1.0;
1558 l_queue_name VARCHAR2(30);
1559 l_dequeue_options dbms_aq.dequeue_options_t;
1560 l_message_properties dbms_aq.message_properties_t;
1561 l_msg_id RAW(16);
1562 l_message SYSTEM.ASO_Order_Feedback_Type;
1563 l_Header_rec OE_Order_PUB.Header_Rec_Type;
1564 l_old_Header_rec OE_Order_PUB.Header_Rec_Type;
1565 l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1566 l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1567 l_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1568 l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1569 l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1570 l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1571 l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1572 l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1573 l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1574 l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1575 l_Line_tbl OE_Order_PUB.Line_Tbl_Type;
1576 l_old_Line_tbl OE_Order_PUB.Line_Tbl_Type;
1577 l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1578 l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1579 l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1580 l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1581 l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1582 l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1583 l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
1584 l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
1585 l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1586 l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1587 l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1588 l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1589 l_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;
1590 no_message EXCEPTION;
1591 pragma EXCEPTION_INIT(no_message, -25228);
1592
1593 BEGIN
1594
1598
1595 -- Standard Start of API savepoint
1596
1597 SAVEPOINT GET_NOTICE_PVT;
1599 -- Standard call to check for call compatibility.
1600
1601 IF NOT FND_API.Compatible_API_Call (l_api_version ,
1602 p_api_version ,
1603 l_api_name ,
1604 G_PKG_NAME ) THEN
1605 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1606 END IF;
1607
1608 -- Initialize message list if p_init_msg_list is set to TRUE.
1609
1610 IF FND_API.to_Boolean( p_init_msg_list ) THEN
1611 FND_MSG_PUB.initialize;
1612 END IF;
1613
1614 -- Initialize API return status to success
1615
1616 x_return_status := FND_API.G_RET_STS_SUCCESS;
1617
1618 -- Initialize output no_more_messages to FND_API.G_FALSE;
1619
1620 x_no_more_messages := FND_API.G_FALSE;
1621
1622 -- GET_NOTICE API specific input parameter validation logic
1623
1624 -- API Body
1625
1626 -- Assign dequeue parameters
1627
1628 IF UPPER(p_queue_type) = 'OF_QUEUE' THEN
1629 l_queue_name := ASO_QUEUE.ASO_OF_Q;
1630 ELSIF UPPER(p_queue_type) = 'OF_EXCP_QUEUE' THEN
1631 l_queue_name := ASO_QUEUE.ASO_OF_EXCP_Q;
1632 END IF;
1633
1634 l_dequeue_options.consumer_name := p_app_short_name;
1635
1636 l_dequeue_options.dequeue_mode := p_dequeue_mode;
1637
1638 l_dequeue_options.navigation := p_navigation;
1639
1640 l_dequeue_options.wait := p_wait;
1641
1642
1643 -- Dequeue a message
1644
1645 dbms_aq.dequeue(
1646 queue_name => l_queue_name,
1647 dequeue_options => l_dequeue_options,
1648 message_properties => l_message_properties,
1649 payload => l_message,
1650 msgid => l_msg_id);
1651
1652
1653 -- Convert message object to output records and tables
1654
1655 Header_Type_To_Rec
1656 (p_header_type => l_message.header_type,
1657 x_header_rec => l_header_rec
1658 );
1659
1660 Header_Type_To_Rec
1661 (p_header_type => l_message.old_header_type,
1662 x_header_rec => l_old_header_rec
1663 );
1664
1665 Header_Adj_Var_To_Tbl
1666 (p_header_adj_varray => l_message.header_adj_varray,
1667 x_header_adj_tbl => l_header_adj_tbl
1668 );
1669
1670 Header_Adj_Var_To_Tbl
1671 (p_header_adj_varray => l_message.old_header_adj_varray,
1672 x_header_adj_tbl => l_old_header_adj_tbl
1673 );
1674
1675 Header_Price_Att_Var_To_Tbl
1676 (p_header_price_att_varray => l_message.header_price_att_varray,
1677 x_header_price_att_tbl => l_header_price_att_tbl
1678 );
1679
1680 Header_Price_Att_Var_To_Tbl
1681 (p_header_price_att_varray => l_message.old_header_price_att_varray,
1682 x_header_price_att_tbl => l_old_header_price_att_tbl
1683 );
1684
1685 Header_Adj_Att_Var_To_Tbl
1686 (p_header_adj_att_varray => l_message.header_adj_att_varray,
1687 x_header_adj_att_tbl => l_header_adj_att_tbl
1688 );
1689
1690 Header_Adj_Att_Var_To_Tbl
1691 (p_header_adj_att_varray => l_message.old_header_adj_att_varray,
1692 x_header_adj_att_tbl => l_old_header_adj_att_tbl
1693 );
1694
1695 Header_Adj_Assoc_Var_To_Tbl
1696 (p_header_adj_assoc_varray => l_message.header_adj_assoc_varray,
1697 x_header_adj_assoc_tbl => l_header_adj_assoc_tbl
1698 );
1699
1700 Header_Adj_Assoc_Var_To_Tbl
1701 (p_header_adj_assoc_varray => l_message.old_header_adj_assoc_varray,
1702 x_header_adj_assoc_tbl => l_old_header_adj_assoc_tbl
1703 );
1704
1705 Header_Scredit_Var_To_Tbl
1706 (p_header_scredit_varray => l_message.header_scredit_varray,
1707 x_header_scredit_tbl => l_header_scredit_tbl
1708 );
1709
1710 Header_Scredit_Var_To_Tbl
1711 (p_header_scredit_varray => l_message.old_header_scredit_varray,
1712 x_header_scredit_tbl => l_old_header_scredit_tbl
1713 );
1714
1715 Line_Var_To_Tbl
1716 (p_line_varray => l_message.line_varray,
1717 x_line_tbl => l_line_tbl
1718 );
1719
1720 Line_Var_To_Tbl
1721 (p_line_varray => l_message.old_line_varray,
1722 x_line_tbl => l_old_line_tbl
1723 );
1724
1725 Line_Adj_Var_To_Tbl
1726 (p_line_adj_varray => l_message.line_adj_varray,
1727 x_line_adj_tbl => l_line_adj_tbl
1728 );
1729
1730 Line_Adj_Var_To_Tbl
1731 (p_line_adj_varray => l_message.old_line_adj_varray,
1732 x_line_adj_tbl => l_old_line_adj_tbl
1733 );
1734
1735 Line_Price_Att_Var_To_Tbl
1736 (p_line_price_att_varray => l_message.line_price_att_varray,
1737 x_line_price_att_tbl => l_line_price_att_tbl
1738 );
1739
1740 Line_Price_Att_Var_To_Tbl
1741 (p_line_price_att_varray => l_message.old_line_price_att_varray,
1742 x_line_price_att_tbl => l_old_line_price_att_tbl
1743 );
1744
1745 Line_Adj_Att_Var_To_Tbl
1746 (p_line_adj_att_varray => l_message.line_adj_att_varray,
1747 x_line_adj_att_tbl => l_line_adj_att_tbl
1748 );
1749
1753 );
1750 Line_Adj_Att_Var_To_Tbl
1751 (p_line_adj_att_varray => l_message.old_line_adj_att_varray,
1752 x_line_adj_att_tbl => l_old_line_adj_att_tbl
1754
1755 Line_Adj_Assoc_Var_To_Tbl
1756 (p_line_adj_assoc_varray => l_message.line_adj_assoc_varray,
1757 x_line_adj_assoc_tbl => l_line_adj_assoc_tbl
1758 );
1759
1760 Line_Adj_Assoc_Var_To_Tbl
1761 (p_line_adj_assoc_varray => l_message.old_line_adj_assoc_varray,
1762 x_line_adj_assoc_tbl => l_old_line_adj_assoc_tbl
1763 );
1764
1765 Line_Scredit_Var_To_Tbl
1766 (p_line_scredit_varray => l_message.line_scredit_varray,
1767 x_line_scredit_tbl => l_line_scredit_tbl
1768 );
1769
1770 Line_Scredit_Var_To_Tbl
1771 (p_line_scredit_varray => l_message.old_line_scredit_varray,
1772 x_line_scredit_tbl => l_old_line_scredit_tbl
1773 );
1774
1775 Lot_Serial_Var_To_Tbl
1776 (p_lot_serial_varray => l_message.lot_serial_varray,
1777 x_lot_serial_tbl => l_lot_serial_tbl
1778 );
1779
1780 Lot_Serial_Var_To_Tbl
1781 (p_lot_serial_varray => l_message.old_lot_serial_varray,
1782 x_lot_serial_tbl => l_old_lot_serial_tbl
1783 );
1784
1785 Action_Request_Var_To_Tbl
1786 (p_action_request_varray => l_message.action_request_varray,
1787 x_action_request_tbl => l_action_request_tbl
1788 );
1789
1790
1791
1792 -- Done processing, load OUT NOCOPY /* file.sql.39 change */ parameters
1793
1794 x_Header_rec := l_Header_rec;
1795 x_old_Header_rec := l_old_Header_rec;
1796 x_Header_Adj_tbl := l_Header_Adj_tbl;
1797 x_old_Header_Adj_tbl := l_old_Header_Adj_tbl;
1798 x_Header_Price_Att_tbl := l_Header_Price_Att_tbl;
1799 x_old_Header_Price_Att_tbl := l_old_Header_Price_Att_tbl;
1800 x_Header_Adj_Att_tbl := l_Header_Adj_Att_tbl;
1801 x_old_Header_Adj_Att_tbl := l_old_Header_Adj_Att_tbl;
1802 x_Header_Adj_Assoc_tbl := l_Header_Adj_Assoc_tbl;
1803 x_old_Header_Adj_Assoc_tbl := l_old_Header_Adj_Assoc_tbl;
1804 x_Header_Scredit_tbl := l_Header_Scredit_tbl;
1805 x_old_Header_Scredit_tbl := l_old_Header_Scredit_tbl;
1806 x_Line_tbl := l_Line_tbl;
1807 x_old_Line_tbl := l_old_Line_tbl;
1808 x_Line_Adj_tbl := l_Line_Adj_tbl;
1809 x_old_Line_Adj_tbl := l_old_Line_Adj_tbl;
1810 x_Line_Price_Att_tbl := l_Line_Price_Att_tbl;
1811 x_old_Line_Price_Att_tbl := l_old_Line_Price_Att_tbl;
1812 x_Line_Adj_Att_tbl := l_Line_Adj_Att_tbl;
1813 x_old_Line_Adj_Att_tbl := l_old_Line_Adj_Att_tbl;
1814 x_Line_Adj_Assoc_tbl := l_Line_Adj_Assoc_tbl;
1815 x_old_Line_Adj_Assoc_tbl := l_old_Line_Adj_Assoc_tbl;
1816 x_Line_Scredit_tbl := l_Line_Scredit_tbl;
1817 x_old_Line_Scredit_tbl := l_old_Line_Scredit_tbl;
1818 x_Lot_Serial_tbl := l_Lot_Serial_tbl;
1819 x_old_Lot_Serial_tbl := l_old_Lot_Serial_tbl;
1820 x_Action_Request_tbl := l_Action_Request_tbl;
1821
1822
1823 -- Standard check of p_commit.
1824
1825 IF FND_API.To_Boolean( p_commit ) THEN
1826 COMMIT WORK;
1827 END IF;
1828
1829 -- Standard call to get message count and if count is 1, get message info.
1830
1831 FND_MSG_PUB.Count_And_Get
1832 (p_count => x_msg_count ,
1833 p_data => x_msg_data
1834 );
1835
1836 EXCEPTION
1837
1838 WHEN FND_API.G_EXC_ERROR THEN
1839 ROLLBACK TO GET_NOTICE_PVT;
1840 x_return_status := FND_API.G_RET_STS_ERROR ;
1841 FND_MSG_PUB.Count_And_Get
1842 (p_count => x_msg_count ,
1843 p_data => x_msg_data
1844 );
1845 WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1846 ROLLBACK TO GET_NOTICE_PVT;
1847 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1848 FND_MSG_PUB.Count_And_Get
1849 (p_count => x_msg_count ,
1850 p_data => x_msg_data
1851 );
1852 WHEN no_message then
1853 -- dbms_output.put_line('No more messages');
1854 x_no_more_messages := FND_API.G_TRUE;
1855 WHEN OTHERS THEN
1856 ROLLBACK TO GET_NOTICE_PVT;
1857 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1858 IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1859 FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
1860 END IF;
1861 FND_MSG_PUB.Count_And_Get
1862 (p_count => x_msg_count ,
1863 p_data => x_msg_data
1864 );
1865 END GET_NOTICE;
1866
1867
1868 END ASO_ORDER_FEEDBACK_GET_PVT;