DBA Data[Home] [Help]

APPS.ASO_QUOTE_PUB_W1 dependencies on JTF_VARCHAR2_TABLE_100

Line 36: x_atp_quantity_uom OUT NOCOPY jtf_varchar2_table_100,

32: x_atp_identifier OUT NOCOPY jtf_number_table,
33: x_atp_customer_id OUT NOCOPY jtf_number_table,
34: x_atp_customer_site_id OUT NOCOPY jtf_number_table,
35: x_atp_quantity_ordered OUT NOCOPY jtf_number_table,
36: x_atp_quantity_uom OUT NOCOPY jtf_varchar2_table_100,
37: x_atp_uom_meaning OUT NOCOPY JTF_VARCHAR2_TABLE_100,
38: x_atp_requested_ship_date OUT NOCOPY jtf_date_table,
39: x_atp_ship_date OUT NOCOPY jtf_date_table,
40: x_atp_available_quantity OUT NOCOPY jtf_number_table,

Line 37: x_atp_uom_meaning OUT NOCOPY JTF_VARCHAR2_TABLE_100,

33: x_atp_customer_id OUT NOCOPY jtf_number_table,
34: x_atp_customer_site_id OUT NOCOPY jtf_number_table,
35: x_atp_quantity_ordered OUT NOCOPY jtf_number_table,
36: x_atp_quantity_uom OUT NOCOPY jtf_varchar2_table_100,
37: x_atp_uom_meaning OUT NOCOPY JTF_VARCHAR2_TABLE_100,
38: x_atp_requested_ship_date OUT NOCOPY jtf_date_table,
39: x_atp_ship_date OUT NOCOPY jtf_date_table,
40: x_atp_available_quantity OUT NOCOPY jtf_number_table,
41: x_atp_request_date_quantity OUT NOCOPY jtf_number_table,

Line 230: p_ql_line_category_code IN jtf_varchar2_table_100 := NULL,

226: p_ql_quote_line_id IN jtf_number_table := NULL,
227: p_ql_quote_header_id IN jtf_number_table := NULL,
228: p_ql_org_id IN jtf_number_table := NULL,
229: p_ql_line_number IN jtf_number_table := NULL,
230: p_ql_line_category_code IN jtf_varchar2_table_100 := NULL,
231: p_ql_item_type_code IN jtf_varchar2_table_100 := NULL,
232: p_ql_inventory_item_id IN jtf_number_table := NULL,
233: p_ql_organization_id IN jtf_number_table := NULL,
234: p_ql_quantity IN jtf_number_table := NULL,

Line 231: p_ql_item_type_code IN jtf_varchar2_table_100 := NULL,

227: p_ql_quote_header_id IN jtf_number_table := NULL,
228: p_ql_org_id IN jtf_number_table := NULL,
229: p_ql_line_number IN jtf_number_table := NULL,
230: p_ql_line_category_code IN jtf_varchar2_table_100 := NULL,
231: p_ql_item_type_code IN jtf_varchar2_table_100 := NULL,
232: p_ql_inventory_item_id IN jtf_number_table := NULL,
233: p_ql_organization_id IN jtf_number_table := NULL,
234: p_ql_quantity IN jtf_number_table := NULL,
235: p_ql_uom_code IN jtf_varchar2_table_100 := NULL,

Line 235: p_ql_uom_code IN jtf_varchar2_table_100 := NULL,

231: p_ql_item_type_code IN jtf_varchar2_table_100 := NULL,
232: p_ql_inventory_item_id IN jtf_number_table := NULL,
233: p_ql_organization_id IN jtf_number_table := NULL,
234: p_ql_quantity IN jtf_number_table := NULL,
235: p_ql_uom_code IN jtf_varchar2_table_100 := NULL,
236: p_ql_start_date_active IN jtf_date_table := NULL,
237: p_ql_end_date_active IN jtf_date_table := NULL,
238: p_ql_order_line_type_id IN jtf_number_table := NULL,
239: p_ql_price_list_id IN jtf_number_table := NULL,

Line 241: p_ql_currency_code IN jtf_varchar2_table_100 := NULL,

237: p_ql_end_date_active IN jtf_date_table := NULL,
238: p_ql_order_line_type_id IN jtf_number_table := NULL,
239: p_ql_price_list_id IN jtf_number_table := NULL,
240: p_ql_price_list_line_id IN jtf_number_table := NULL,
241: p_ql_currency_code IN jtf_varchar2_table_100 := NULL,
242: p_ql_line_list_price IN jtf_number_table := NULL,
243: p_ql_line_adjusted_amount IN jtf_number_table := NULL,
244: p_ql_line_adjusted_percent IN jtf_number_table := NULL,
245: p_ql_line_quote_price IN jtf_number_table := NULL,

Line 247: p_ql_item_relationship_type IN jtf_varchar2_table_100 := NULL,

243: p_ql_line_adjusted_amount IN jtf_number_table := NULL,
244: p_ql_line_adjusted_percent IN jtf_number_table := NULL,
245: p_ql_line_quote_price IN jtf_number_table := NULL,
246: p_ql_related_item_id IN jtf_number_table := NULL,
247: p_ql_item_relationship_type IN jtf_varchar2_table_100 := NULL,
248: p_ql_split_shipment_flag IN jtf_varchar2_table_100 := NULL,
249: p_ql_backorder_flag IN jtf_varchar2_table_100 := NULL,
250: p_ql_selling_price_change IN jtf_varchar2_table_100 := NULL,
251: p_ql_recalculate_flag IN jtf_varchar2_table_100 := NULL,

Line 248: p_ql_split_shipment_flag IN jtf_varchar2_table_100 := NULL,

244: p_ql_line_adjusted_percent IN jtf_number_table := NULL,
245: p_ql_line_quote_price IN jtf_number_table := NULL,
246: p_ql_related_item_id IN jtf_number_table := NULL,
247: p_ql_item_relationship_type IN jtf_varchar2_table_100 := NULL,
248: p_ql_split_shipment_flag IN jtf_varchar2_table_100 := NULL,
249: p_ql_backorder_flag IN jtf_varchar2_table_100 := NULL,
250: p_ql_selling_price_change IN jtf_varchar2_table_100 := NULL,
251: p_ql_recalculate_flag IN jtf_varchar2_table_100 := NULL,
252: p_ql_attribute_category IN jtf_varchar2_table_100 := NULL,

Line 249: p_ql_backorder_flag IN jtf_varchar2_table_100 := NULL,

245: p_ql_line_quote_price IN jtf_number_table := NULL,
246: p_ql_related_item_id IN jtf_number_table := NULL,
247: p_ql_item_relationship_type IN jtf_varchar2_table_100 := NULL,
248: p_ql_split_shipment_flag IN jtf_varchar2_table_100 := NULL,
249: p_ql_backorder_flag IN jtf_varchar2_table_100 := NULL,
250: p_ql_selling_price_change IN jtf_varchar2_table_100 := NULL,
251: p_ql_recalculate_flag IN jtf_varchar2_table_100 := NULL,
252: p_ql_attribute_category IN jtf_varchar2_table_100 := NULL,
253: p_ql_attribute1 IN jtf_varchar2_table_300 := NULL,

Line 250: p_ql_selling_price_change IN jtf_varchar2_table_100 := NULL,

246: p_ql_related_item_id IN jtf_number_table := NULL,
247: p_ql_item_relationship_type IN jtf_varchar2_table_100 := NULL,
248: p_ql_split_shipment_flag IN jtf_varchar2_table_100 := NULL,
249: p_ql_backorder_flag IN jtf_varchar2_table_100 := NULL,
250: p_ql_selling_price_change IN jtf_varchar2_table_100 := NULL,
251: p_ql_recalculate_flag IN jtf_varchar2_table_100 := NULL,
252: p_ql_attribute_category IN jtf_varchar2_table_100 := NULL,
253: p_ql_attribute1 IN jtf_varchar2_table_300 := NULL,
254: p_ql_attribute2 IN jtf_varchar2_table_300 := NULL,

Line 251: p_ql_recalculate_flag IN jtf_varchar2_table_100 := NULL,

247: p_ql_item_relationship_type IN jtf_varchar2_table_100 := NULL,
248: p_ql_split_shipment_flag IN jtf_varchar2_table_100 := NULL,
249: p_ql_backorder_flag IN jtf_varchar2_table_100 := NULL,
250: p_ql_selling_price_change IN jtf_varchar2_table_100 := NULL,
251: p_ql_recalculate_flag IN jtf_varchar2_table_100 := NULL,
252: p_ql_attribute_category IN jtf_varchar2_table_100 := NULL,
253: p_ql_attribute1 IN jtf_varchar2_table_300 := NULL,
254: p_ql_attribute2 IN jtf_varchar2_table_300 := NULL,
255: p_ql_attribute3 IN jtf_varchar2_table_300 := NULL,

Line 252: p_ql_attribute_category IN jtf_varchar2_table_100 := NULL,

248: p_ql_split_shipment_flag IN jtf_varchar2_table_100 := NULL,
249: p_ql_backorder_flag IN jtf_varchar2_table_100 := NULL,
250: p_ql_selling_price_change IN jtf_varchar2_table_100 := NULL,
251: p_ql_recalculate_flag IN jtf_varchar2_table_100 := NULL,
252: p_ql_attribute_category IN jtf_varchar2_table_100 := NULL,
253: p_ql_attribute1 IN jtf_varchar2_table_300 := NULL,
254: p_ql_attribute2 IN jtf_varchar2_table_300 := NULL,
255: p_ql_attribute3 IN jtf_varchar2_table_300 := NULL,
256: p_ql_attribute4 IN jtf_varchar2_table_300 := NULL,

Line 284: p_ql_operation_code IN jtf_varchar2_table_100 := NULL,

280: p_ql_invoice_to_party_id IN jtf_number_table := NULL,
281: p_ql_invoice_to_party_site_id IN jtf_number_table := NULL,
282: p_ql_invoicing_rule_id IN jtf_number_table := NULL,
283: p_ql_marketing_source_code_id IN jtf_number_table := NULL,
284: p_ql_operation_code IN jtf_varchar2_table_100 := NULL,
285: p_ql_invoice_to_cust_acct_id IN jtf_number_table := NULL,
286: p_ql_pricing_quantity_uom IN jtf_varchar2_table_100 := NULL,
287: p_ql_minisite_id IN jtf_number_table := NULL,
288: p_ql_section_id IN jtf_number_table := NULL,

Line 286: p_ql_pricing_quantity_uom IN jtf_varchar2_table_100 := NULL,

282: p_ql_invoicing_rule_id IN jtf_number_table := NULL,
283: p_ql_marketing_source_code_id IN jtf_number_table := NULL,
284: p_ql_operation_code IN jtf_varchar2_table_100 := NULL,
285: p_ql_invoice_to_cust_acct_id IN jtf_number_table := NULL,
286: p_ql_pricing_quantity_uom IN jtf_varchar2_table_100 := NULL,
287: p_ql_minisite_id IN jtf_number_table := NULL,
288: p_ql_section_id IN jtf_number_table := NULL,
289: p_ql_priced_price_list_id IN jtf_number_table := NULL,
290: p_ql_agreement_id IN jtf_number_table := NULL,

Line 292: p_ql_display_arithmetic_op IN jtf_varchar2_table_100 := NULL,

288: p_ql_section_id IN jtf_number_table := NULL,
289: p_ql_priced_price_list_id IN jtf_number_table := NULL,
290: p_ql_agreement_id IN jtf_number_table := NULL,
291: p_ql_commitment_id IN jtf_number_table := NULL,
292: p_ql_display_arithmetic_op IN jtf_varchar2_table_100 := NULL,
293: p_ql_invoice_to_cust_party_id IN jtf_number_table := NULL,
294:
295: /* parameters for quote shipment record ASO_QUOTE_PUB.Shipment_Tbl_Type */
296: p_qls_operation_code IN jtf_varchar2_table_100 := NULL,

Line 296: p_qls_operation_code IN jtf_varchar2_table_100 := NULL,

292: p_ql_display_arithmetic_op IN jtf_varchar2_table_100 := NULL,
293: p_ql_invoice_to_cust_party_id IN jtf_number_table := NULL,
294:
295: /* parameters for quote shipment record ASO_QUOTE_PUB.Shipment_Tbl_Type */
296: p_qls_operation_code IN jtf_varchar2_table_100 := NULL,
297: p_qls_qte_line_index IN jtf_number_table := NULL,
298: p_qls_shipment_id IN jtf_number_table := NULL,
299: p_qls_creation_date IN jtf_date_table := NULL,
300: p_qls_created_by IN jtf_number_table := NULL,

Line 318: p_qls_ship_method_code IN jtf_varchar2_table_100 := NULL,

314: p_qls_ship_to_party_id IN jtf_number_table := NULL,
315: p_qls_ship_to_cust_account_id IN jtf_number_table := NULL,
316: p_qls_ship_partial_flag IN jtf_varchar2_table_300 := NULL,
317: p_qls_ship_set_id IN jtf_number_table := NULL,
318: p_qls_ship_method_code IN jtf_varchar2_table_100 := NULL,
319: p_qls_freight_terms_code IN jtf_varchar2_table_100 := NULL,
320: p_qls_freight_carrier_code IN jtf_varchar2_table_100 := NULL,
321: p_qls_fob_code IN jtf_varchar2_table_100 := NULL,
322: p_qls_shipping_instructions IN jtf_varchar2_table_2000 := NULL,

Line 319: p_qls_freight_terms_code IN jtf_varchar2_table_100 := NULL,

315: p_qls_ship_to_cust_account_id IN jtf_number_table := NULL,
316: p_qls_ship_partial_flag IN jtf_varchar2_table_300 := NULL,
317: p_qls_ship_set_id IN jtf_number_table := NULL,
318: p_qls_ship_method_code IN jtf_varchar2_table_100 := NULL,
319: p_qls_freight_terms_code IN jtf_varchar2_table_100 := NULL,
320: p_qls_freight_carrier_code IN jtf_varchar2_table_100 := NULL,
321: p_qls_fob_code IN jtf_varchar2_table_100 := NULL,
322: p_qls_shipping_instructions IN jtf_varchar2_table_2000 := NULL,
323: p_qls_packing_instructions IN jtf_varchar2_table_2000 := NULL,

Line 320: p_qls_freight_carrier_code IN jtf_varchar2_table_100 := NULL,

316: p_qls_ship_partial_flag IN jtf_varchar2_table_300 := NULL,
317: p_qls_ship_set_id IN jtf_number_table := NULL,
318: p_qls_ship_method_code IN jtf_varchar2_table_100 := NULL,
319: p_qls_freight_terms_code IN jtf_varchar2_table_100 := NULL,
320: p_qls_freight_carrier_code IN jtf_varchar2_table_100 := NULL,
321: p_qls_fob_code IN jtf_varchar2_table_100 := NULL,
322: p_qls_shipping_instructions IN jtf_varchar2_table_2000 := NULL,
323: p_qls_packing_instructions IN jtf_varchar2_table_2000 := NULL,
324: p_qls_quantity IN jtf_number_table := NULL,

Line 321: p_qls_fob_code IN jtf_varchar2_table_100 := NULL,

317: p_qls_ship_set_id IN jtf_number_table := NULL,
318: p_qls_ship_method_code IN jtf_varchar2_table_100 := NULL,
319: p_qls_freight_terms_code IN jtf_varchar2_table_100 := NULL,
320: p_qls_freight_carrier_code IN jtf_varchar2_table_100 := NULL,
321: p_qls_fob_code IN jtf_varchar2_table_100 := NULL,
322: p_qls_shipping_instructions IN jtf_varchar2_table_2000 := NULL,
323: p_qls_packing_instructions IN jtf_varchar2_table_2000 := NULL,
324: p_qls_quantity IN jtf_number_table := NULL,
325: p_qls_reserved_quantity IN jtf_varchar2_table_300 := NULL,

Line 329: p_qls_ship_to_cont_first_name IN jtf_varchar2_table_100 := NULL,

325: p_qls_reserved_quantity IN jtf_varchar2_table_300 := NULL,
326: p_qls_reservation_id IN jtf_number_table := NULL,
327: p_qls_order_line_id IN jtf_number_table := NULL,
328: p_qls_ship_to_party_name IN jtf_varchar2_table_300 := NULL,
329: p_qls_ship_to_cont_first_name IN jtf_varchar2_table_100 := NULL,
330: p_qls_ship_to_cont_mid_name IN jtf_varchar2_table_100 := NULL,
331: p_qls_ship_to_cont_last_name IN jtf_varchar2_table_100 := NULL,
332: p_qls_ship_to_address1 IN jtf_varchar2_table_300 := NULL,
333: p_qls_ship_to_address2 IN jtf_varchar2_table_300 := NULL,

Line 330: p_qls_ship_to_cont_mid_name IN jtf_varchar2_table_100 := NULL,

326: p_qls_reservation_id IN jtf_number_table := NULL,
327: p_qls_order_line_id IN jtf_number_table := NULL,
328: p_qls_ship_to_party_name IN jtf_varchar2_table_300 := NULL,
329: p_qls_ship_to_cont_first_name IN jtf_varchar2_table_100 := NULL,
330: p_qls_ship_to_cont_mid_name IN jtf_varchar2_table_100 := NULL,
331: p_qls_ship_to_cont_last_name IN jtf_varchar2_table_100 := NULL,
332: p_qls_ship_to_address1 IN jtf_varchar2_table_300 := NULL,
333: p_qls_ship_to_address2 IN jtf_varchar2_table_300 := NULL,
334: p_qls_ship_to_address3 IN jtf_varchar2_table_300 := NULL,

Line 331: p_qls_ship_to_cont_last_name IN jtf_varchar2_table_100 := NULL,

327: p_qls_order_line_id IN jtf_number_table := NULL,
328: p_qls_ship_to_party_name IN jtf_varchar2_table_300 := NULL,
329: p_qls_ship_to_cont_first_name IN jtf_varchar2_table_100 := NULL,
330: p_qls_ship_to_cont_mid_name IN jtf_varchar2_table_100 := NULL,
331: p_qls_ship_to_cont_last_name IN jtf_varchar2_table_100 := NULL,
332: p_qls_ship_to_address1 IN jtf_varchar2_table_300 := NULL,
333: p_qls_ship_to_address2 IN jtf_varchar2_table_300 := NULL,
334: p_qls_ship_to_address3 IN jtf_varchar2_table_300 := NULL,
335: p_qls_ship_to_address4 IN jtf_varchar2_table_300 := NULL,

Line 336: p_qls_ship_to_country_code IN jtf_varchar2_table_100 := NULL,

332: p_qls_ship_to_address1 IN jtf_varchar2_table_300 := NULL,
333: p_qls_ship_to_address2 IN jtf_varchar2_table_300 := NULL,
334: p_qls_ship_to_address3 IN jtf_varchar2_table_300 := NULL,
335: p_qls_ship_to_address4 IN jtf_varchar2_table_300 := NULL,
336: p_qls_ship_to_country_code IN jtf_varchar2_table_100 := NULL,
337: p_qls_ship_to_country IN jtf_varchar2_table_100 := NULL,
338: p_qls_ship_to_city IN jtf_varchar2_table_100 := NULL,
339: p_qls_ship_to_postal_code IN jtf_varchar2_table_100 := NULL,
340: p_qls_ship_to_state IN jtf_varchar2_table_100 := NULL,

Line 337: p_qls_ship_to_country IN jtf_varchar2_table_100 := NULL,

333: p_qls_ship_to_address2 IN jtf_varchar2_table_300 := NULL,
334: p_qls_ship_to_address3 IN jtf_varchar2_table_300 := NULL,
335: p_qls_ship_to_address4 IN jtf_varchar2_table_300 := NULL,
336: p_qls_ship_to_country_code IN jtf_varchar2_table_100 := NULL,
337: p_qls_ship_to_country IN jtf_varchar2_table_100 := NULL,
338: p_qls_ship_to_city IN jtf_varchar2_table_100 := NULL,
339: p_qls_ship_to_postal_code IN jtf_varchar2_table_100 := NULL,
340: p_qls_ship_to_state IN jtf_varchar2_table_100 := NULL,
341: p_qls_ship_to_province IN jtf_varchar2_table_100 := NULL,

Line 338: p_qls_ship_to_city IN jtf_varchar2_table_100 := NULL,

334: p_qls_ship_to_address3 IN jtf_varchar2_table_300 := NULL,
335: p_qls_ship_to_address4 IN jtf_varchar2_table_300 := NULL,
336: p_qls_ship_to_country_code IN jtf_varchar2_table_100 := NULL,
337: p_qls_ship_to_country IN jtf_varchar2_table_100 := NULL,
338: p_qls_ship_to_city IN jtf_varchar2_table_100 := NULL,
339: p_qls_ship_to_postal_code IN jtf_varchar2_table_100 := NULL,
340: p_qls_ship_to_state IN jtf_varchar2_table_100 := NULL,
341: p_qls_ship_to_province IN jtf_varchar2_table_100 := NULL,
342: p_qls_ship_to_county IN jtf_varchar2_table_100 := NULL,

Line 339: p_qls_ship_to_postal_code IN jtf_varchar2_table_100 := NULL,

335: p_qls_ship_to_address4 IN jtf_varchar2_table_300 := NULL,
336: p_qls_ship_to_country_code IN jtf_varchar2_table_100 := NULL,
337: p_qls_ship_to_country IN jtf_varchar2_table_100 := NULL,
338: p_qls_ship_to_city IN jtf_varchar2_table_100 := NULL,
339: p_qls_ship_to_postal_code IN jtf_varchar2_table_100 := NULL,
340: p_qls_ship_to_state IN jtf_varchar2_table_100 := NULL,
341: p_qls_ship_to_province IN jtf_varchar2_table_100 := NULL,
342: p_qls_ship_to_county IN jtf_varchar2_table_100 := NULL,
343: p_qls_attribute_category IN jtf_varchar2_table_100 := NULL,

Line 340: p_qls_ship_to_state IN jtf_varchar2_table_100 := NULL,

336: p_qls_ship_to_country_code IN jtf_varchar2_table_100 := NULL,
337: p_qls_ship_to_country IN jtf_varchar2_table_100 := NULL,
338: p_qls_ship_to_city IN jtf_varchar2_table_100 := NULL,
339: p_qls_ship_to_postal_code IN jtf_varchar2_table_100 := NULL,
340: p_qls_ship_to_state IN jtf_varchar2_table_100 := NULL,
341: p_qls_ship_to_province IN jtf_varchar2_table_100 := NULL,
342: p_qls_ship_to_county IN jtf_varchar2_table_100 := NULL,
343: p_qls_attribute_category IN jtf_varchar2_table_100 := NULL,
344: p_qls_attribute1 IN jtf_varchar2_table_300 := NULL,

Line 341: p_qls_ship_to_province IN jtf_varchar2_table_100 := NULL,

337: p_qls_ship_to_country IN jtf_varchar2_table_100 := NULL,
338: p_qls_ship_to_city IN jtf_varchar2_table_100 := NULL,
339: p_qls_ship_to_postal_code IN jtf_varchar2_table_100 := NULL,
340: p_qls_ship_to_state IN jtf_varchar2_table_100 := NULL,
341: p_qls_ship_to_province IN jtf_varchar2_table_100 := NULL,
342: p_qls_ship_to_county IN jtf_varchar2_table_100 := NULL,
343: p_qls_attribute_category IN jtf_varchar2_table_100 := NULL,
344: p_qls_attribute1 IN jtf_varchar2_table_300 := NULL,
345: p_qls_attribute2 IN jtf_varchar2_table_300 := NULL,

Line 342: p_qls_ship_to_county IN jtf_varchar2_table_100 := NULL,

338: p_qls_ship_to_city IN jtf_varchar2_table_100 := NULL,
339: p_qls_ship_to_postal_code IN jtf_varchar2_table_100 := NULL,
340: p_qls_ship_to_state IN jtf_varchar2_table_100 := NULL,
341: p_qls_ship_to_province IN jtf_varchar2_table_100 := NULL,
342: p_qls_ship_to_county IN jtf_varchar2_table_100 := NULL,
343: p_qls_attribute_category IN jtf_varchar2_table_100 := NULL,
344: p_qls_attribute1 IN jtf_varchar2_table_300 := NULL,
345: p_qls_attribute2 IN jtf_varchar2_table_300 := NULL,
346: p_qls_attribute3 IN jtf_varchar2_table_300 := NULL,

Line 343: p_qls_attribute_category IN jtf_varchar2_table_100 := NULL,

339: p_qls_ship_to_postal_code IN jtf_varchar2_table_100 := NULL,
340: p_qls_ship_to_state IN jtf_varchar2_table_100 := NULL,
341: p_qls_ship_to_province IN jtf_varchar2_table_100 := NULL,
342: p_qls_ship_to_county IN jtf_varchar2_table_100 := NULL,
343: p_qls_attribute_category IN jtf_varchar2_table_100 := NULL,
344: p_qls_attribute1 IN jtf_varchar2_table_300 := NULL,
345: p_qls_attribute2 IN jtf_varchar2_table_300 := NULL,
346: p_qls_attribute3 IN jtf_varchar2_table_300 := NULL,
347: p_qls_attribute4 IN jtf_varchar2_table_300 := NULL,

Line 366: p_qls_shipment_priority_code IN jtf_varchar2_table_100 := NULL,

362: p_qls_attribute19 IN jtf_varchar2_table_300 := NULL,
363: p_qls_attribute20 IN jtf_varchar2_table_300 := NULL,
364: p_qls_ship_quote_price IN jtf_number_table := NULL,
365: p_qls_pricing_quantity IN jtf_number_table := NULL,
366: p_qls_shipment_priority_code IN jtf_varchar2_table_100 := NULL,
367: p_qls_ship_from_org_id IN jtf_number_table := NULL,
368: p_qls_ship_to_cust_party_id IN jtf_number_table := NULL,
369: p_qls_request_date_type IN jtf_varchar2_table_100 := NULL,
370: p_qls_demand_class_code IN jtf_varchar2_table_100 := NULL,

Line 369: p_qls_request_date_type IN jtf_varchar2_table_100 := NULL,

365: p_qls_pricing_quantity IN jtf_number_table := NULL,
366: p_qls_shipment_priority_code IN jtf_varchar2_table_100 := NULL,
367: p_qls_ship_from_org_id IN jtf_number_table := NULL,
368: p_qls_ship_to_cust_party_id IN jtf_number_table := NULL,
369: p_qls_request_date_type IN jtf_varchar2_table_100 := NULL,
370: p_qls_demand_class_code IN jtf_varchar2_table_100 := NULL,
371: p_qls_object_version_number IN jtf_number_table := NULL,
372: /* Standard IN parameters */
373: P_API_VERSION_NUMBER IN NUMBER := 1,

Line 370: p_qls_demand_class_code IN jtf_varchar2_table_100 := NULL,

366: p_qls_shipment_priority_code IN jtf_varchar2_table_100 := NULL,
367: p_qls_ship_from_org_id IN jtf_number_table := NULL,
368: p_qls_ship_to_cust_party_id IN jtf_number_table := NULL,
369: p_qls_request_date_type IN jtf_varchar2_table_100 := NULL,
370: p_qls_demand_class_code IN jtf_varchar2_table_100 := NULL,
371: p_qls_object_version_number IN jtf_number_table := NULL,
372: /* Standard IN parameters */
373: P_API_VERSION_NUMBER IN NUMBER := 1,
374: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_TRUE,

Line 890: x_changed_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100,

886: x_return_status OUT NOCOPY VARCHAR2,
887: x_msg_count OUT NOCOPY VARCHAR2,
888: x_msg_data OUT NOCOPY VARCHAR2,
889: x_quote_line_id OUT NOCOPY JTF_NUMBER_TABLE,
890: x_changed_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100,
891: x_valid_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100,
892: x_complete_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100,
893: p_quote_header_id IN NUMBER :=FND_API.G_MISS_NUM,
894: p_quote_line_id IN NUMBER :=FND_API.G_MISS_NUM,

Line 891: x_valid_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100,

887: x_msg_count OUT NOCOPY VARCHAR2,
888: x_msg_data OUT NOCOPY VARCHAR2,
889: x_quote_line_id OUT NOCOPY JTF_NUMBER_TABLE,
890: x_changed_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100,
891: x_valid_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100,
892: x_complete_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100,
893: p_quote_header_id IN NUMBER :=FND_API.G_MISS_NUM,
894: p_quote_line_id IN NUMBER :=FND_API.G_MISS_NUM,
895: p_update_quote IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 892: x_complete_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100,

888: x_msg_data OUT NOCOPY VARCHAR2,
889: x_quote_line_id OUT NOCOPY JTF_NUMBER_TABLE,
890: x_changed_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100,
891: x_valid_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100,
892: x_complete_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100,
893: p_quote_header_id IN NUMBER :=FND_API.G_MISS_NUM,
894: p_quote_line_id IN NUMBER :=FND_API.G_MISS_NUM,
895: p_update_quote IN VARCHAR2 := FND_API.G_MISS_CHAR,
896: p_config_effective_date IN DATE :=FND_API.G_MISS_DATE,

Line 1204: p_qp_operation_code IN jtf_varchar2_table_100 := NULL,

1200: p_qs_request_date_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
1201: p_qs_demand_class_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1202: p_qs_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
1203: -- hd payment record
1204: p_qp_operation_code IN jtf_varchar2_table_100 := NULL,
1205: p_qp_qte_line_index IN jtf_number_table := NULL,
1206: p_qp_payment_id IN jtf_number_table := NULL,
1207: p_qp_creation_date IN jtf_date_table := NULL,
1208: p_qp_created_by IN jtf_number_table := NULL,

Line 1218: p_qp_payment_type_code IN jtf_varchar2_table_100 := NULL,

1214: p_qp_program_id IN jtf_number_table := NULL,
1215: p_qp_program_update_date IN jtf_date_table := NULL,
1216: p_qp_quote_header_id IN jtf_number_table := NULL,
1217: p_qp_quote_line_id IN jtf_number_table := NULL,
1218: p_qp_payment_type_code IN jtf_varchar2_table_100 := NULL,
1219: p_qp_payment_ref_number IN jtf_varchar2_table_300 := NULL,
1220: p_qp_payment_option IN jtf_varchar2_table_300 := NULL,
1221: p_qp_payment_term_id IN jtf_number_table := NULL,
1222: p_qp_credit_card_code IN jtf_varchar2_table_100 := NULL,

Line 1222: p_qp_credit_card_code IN jtf_varchar2_table_100 := NULL,

1218: p_qp_payment_type_code IN jtf_varchar2_table_100 := NULL,
1219: p_qp_payment_ref_number IN jtf_varchar2_table_300 := NULL,
1220: p_qp_payment_option IN jtf_varchar2_table_300 := NULL,
1221: p_qp_payment_term_id IN jtf_number_table := NULL,
1222: p_qp_credit_card_code IN jtf_varchar2_table_100 := NULL,
1223: p_qp_credit_card_holder_name IN jtf_varchar2_table_100 := NULL,
1224: p_qp_credit_card_exp_date IN jtf_date_table := NULL,
1225: p_qp_credit_card_aprv_code IN jtf_varchar2_table_100 := NULL,
1226: p_qp_credit_card_aprv_date IN jtf_date_table := NULL,

Line 1223: p_qp_credit_card_holder_name IN jtf_varchar2_table_100 := NULL,

1219: p_qp_payment_ref_number IN jtf_varchar2_table_300 := NULL,
1220: p_qp_payment_option IN jtf_varchar2_table_300 := NULL,
1221: p_qp_payment_term_id IN jtf_number_table := NULL,
1222: p_qp_credit_card_code IN jtf_varchar2_table_100 := NULL,
1223: p_qp_credit_card_holder_name IN jtf_varchar2_table_100 := NULL,
1224: p_qp_credit_card_exp_date IN jtf_date_table := NULL,
1225: p_qp_credit_card_aprv_code IN jtf_varchar2_table_100 := NULL,
1226: p_qp_credit_card_aprv_date IN jtf_date_table := NULL,
1227: p_qp_payment_amount IN jtf_number_table := NULL,

Line 1225: p_qp_credit_card_aprv_code IN jtf_varchar2_table_100 := NULL,

1221: p_qp_payment_term_id IN jtf_number_table := NULL,
1222: p_qp_credit_card_code IN jtf_varchar2_table_100 := NULL,
1223: p_qp_credit_card_holder_name IN jtf_varchar2_table_100 := NULL,
1224: p_qp_credit_card_exp_date IN jtf_date_table := NULL,
1225: p_qp_credit_card_aprv_code IN jtf_varchar2_table_100 := NULL,
1226: p_qp_credit_card_aprv_date IN jtf_date_table := NULL,
1227: p_qp_payment_amount IN jtf_number_table := NULL,
1228: p_qp_attribute_category IN jtf_varchar2_table_100 := NULL,
1229: p_qp_attribute1 IN jtf_varchar2_table_300 := NULL,

Line 1228: p_qp_attribute_category IN jtf_varchar2_table_100 := NULL,

1224: p_qp_credit_card_exp_date IN jtf_date_table := NULL,
1225: p_qp_credit_card_aprv_code IN jtf_varchar2_table_100 := NULL,
1226: p_qp_credit_card_aprv_date IN jtf_date_table := NULL,
1227: p_qp_payment_amount IN jtf_number_table := NULL,
1228: p_qp_attribute_category IN jtf_varchar2_table_100 := NULL,
1229: p_qp_attribute1 IN jtf_varchar2_table_300 := NULL,
1230: p_qp_attribute2 IN jtf_varchar2_table_300 := NULL,
1231: p_qp_attribute3 IN jtf_varchar2_table_300 := NULL,
1232: p_qp_attribute4 IN jtf_varchar2_table_300 := NULL,

Line 1251: p_qp_cust_po_number IN jtf_varchar2_table_100 := NULL,

1247: p_qp_attribute19 IN jtf_varchar2_table_300 := NULL,
1248: p_qp_attribute20 IN jtf_varchar2_table_300 := NULL,
1249: p_qp_shipment_index IN jtf_number_table := NULL,
1250: p_qp_quote_shipment_id IN jtf_number_table := NULL,
1251: p_qp_cust_po_number IN jtf_varchar2_table_100 := NULL,
1252: p_qp_cust_po_line_number IN jtf_varchar2_table_100 := NULL,
1253: p_qp_trxn_extension_id IN jtf_number_table := NULL,
1254: p_qp_instrument_id IN jtf_number_table := NULL,
1255: p_qp_instr_assignment_id IN jtf_number_table := NULL,

Line 1252: p_qp_cust_po_line_number IN jtf_varchar2_table_100 := NULL,

1248: p_qp_attribute20 IN jtf_varchar2_table_300 := NULL,
1249: p_qp_shipment_index IN jtf_number_table := NULL,
1250: p_qp_quote_shipment_id IN jtf_number_table := NULL,
1251: p_qp_cust_po_number IN jtf_varchar2_table_100 := NULL,
1252: p_qp_cust_po_line_number IN jtf_varchar2_table_100 := NULL,
1253: p_qp_trxn_extension_id IN jtf_number_table := NULL,
1254: p_qp_instrument_id IN jtf_number_table := NULL,
1255: p_qp_instr_assignment_id IN jtf_number_table := NULL,
1256: p_qp_cvv2 IN jtf_varchar2_table_100 := NULL,

Line 1256: p_qp_cvv2 IN jtf_varchar2_table_100 := NULL,

1252: p_qp_cust_po_line_number IN jtf_varchar2_table_100 := NULL,
1253: p_qp_trxn_extension_id IN jtf_number_table := NULL,
1254: p_qp_instrument_id IN jtf_number_table := NULL,
1255: p_qp_instr_assignment_id IN jtf_number_table := NULL,
1256: p_qp_cvv2 IN jtf_varchar2_table_100 := NULL,
1257: p_qp_object_version_number IN jtf_number_table := NULL,
1258: -- hd price attributes
1259: p_qpa_operation_code IN jtf_varchar2_table_100 := NULL,
1260: p_qpa_qte_line_index IN jtf_number_table := NULL,

Line 1259: p_qpa_operation_code IN jtf_varchar2_table_100 := NULL,

1255: p_qp_instr_assignment_id IN jtf_number_table := NULL,
1256: p_qp_cvv2 IN jtf_varchar2_table_100 := NULL,
1257: p_qp_object_version_number IN jtf_number_table := NULL,
1258: -- hd price attributes
1259: p_qpa_operation_code IN jtf_varchar2_table_100 := NULL,
1260: p_qpa_qte_line_index IN jtf_number_table := NULL,
1261: p_qpa_price_attribute_id IN jtf_number_table := NULL,
1262: p_qpa_creation_date IN jtf_date_table := NULL,
1263: p_qpa_created_by IN jtf_number_table := NULL,

Line 1273: p_qpa_flex_title IN jtf_varchar2_table_100 := NULL,

1269: p_qpa_program_id IN jtf_number_table := NULL,
1270: p_qpa_program_update_date IN jtf_date_table := NULL,
1271: p_qpa_quote_header_id IN jtf_number_table := NULL,
1272: p_qpa_quote_line_id IN jtf_number_table := NULL,
1273: p_qpa_flex_title IN jtf_varchar2_table_100 := NULL,
1274: p_qpa_pricing_context IN jtf_varchar2_table_100 := NULL,
1275: p_qpa_pricing_attribute1 IN jtf_varchar2_table_300 := NULL,
1276: p_qpa_pricing_attribute2 IN jtf_varchar2_table_300 := NULL,
1277: p_qpa_pricing_attribute3 IN jtf_varchar2_table_300 := NULL,

Line 1274: p_qpa_pricing_context IN jtf_varchar2_table_100 := NULL,

1270: p_qpa_program_update_date IN jtf_date_table := NULL,
1271: p_qpa_quote_header_id IN jtf_number_table := NULL,
1272: p_qpa_quote_line_id IN jtf_number_table := NULL,
1273: p_qpa_flex_title IN jtf_varchar2_table_100 := NULL,
1274: p_qpa_pricing_context IN jtf_varchar2_table_100 := NULL,
1275: p_qpa_pricing_attribute1 IN jtf_varchar2_table_300 := NULL,
1276: p_qpa_pricing_attribute2 IN jtf_varchar2_table_300 := NULL,
1277: p_qpa_pricing_attribute3 IN jtf_varchar2_table_300 := NULL,
1278: p_qpa_pricing_attribute4 IN jtf_varchar2_table_300 := NULL,

Line 1375: p_qpa_context IN jtf_varchar2_table_100 := NULL,

1371: p_qpa_pricing_attribute97 IN jtf_varchar2_table_300 := NULL,
1372: p_qpa_pricing_attribute98 IN jtf_varchar2_table_300 := NULL,
1373: p_qpa_pricing_attribute99 IN jtf_varchar2_table_300 := NULL,
1374: p_qpa_pricing_attribute100 IN jtf_varchar2_table_300 := NULL,
1375: p_qpa_context IN jtf_varchar2_table_100 := NULL,
1376: p_qpa_attribute1 IN jtf_varchar2_table_300 := NULL,
1377: p_qpa_attribute2 IN jtf_varchar2_table_300 := NULL,
1378: p_qpa_attribute3 IN jtf_varchar2_table_300 := NULL,
1379: p_qpa_attribute4 IN jtf_varchar2_table_300 := NULL,

Line 1398: p_qt_operation_code IN jtf_varchar2_table_100 := NULL,

1394: p_qpa_attribute19 IN jtf_varchar2_table_300 := NULL,
1395: p_qpa_attribute20 IN jtf_varchar2_table_300 := NULL,
1396: p_qpa_object_version_number IN jtf_number_table := NULL,
1397: --hd tax details
1398: p_qt_operation_code IN jtf_varchar2_table_100 := NULL,
1399: p_qt_qte_line_index IN jtf_number_table := NULL,
1400: p_qt_shipment_index IN jtf_number_table := NULL,
1401: p_qt_tax_detail_id IN jtf_number_table := NULL,
1402: p_qt_quote_header_id IN jtf_number_table := NULL,

Line 1415: p_qt_tax_code IN jtf_varchar2_table_100 := NULL,

1411: p_qt_program_application_id IN jtf_number_table := NULL,
1412: p_qt_program_id IN jtf_number_table := NULL,
1413: p_qt_program_update_date IN jtf_date_table := NULL,
1414: p_qt_orig_tax_code IN jtf_varchar2_table_300 := NULL,
1415: p_qt_tax_code IN jtf_varchar2_table_100 := NULL,
1416: p_qt_tax_rate IN jtf_number_table := NULL,
1417: p_qt_tax_date IN jtf_date_table := NULL,
1418: p_qt_tax_amount IN jtf_number_table := NULL,
1419: p_qt_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,

Line 1419: p_qt_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,

1415: p_qt_tax_code IN jtf_varchar2_table_100 := NULL,
1416: p_qt_tax_rate IN jtf_number_table := NULL,
1417: p_qt_tax_date IN jtf_date_table := NULL,
1418: p_qt_tax_amount IN jtf_number_table := NULL,
1419: p_qt_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,
1420: p_qt_tax_exempt_number IN jtf_varchar2_table_100 := NULL,
1421: p_qt_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,
1422: p_qt_attribute_category IN jtf_varchar2_table_100 := NULL,
1423: p_qt_attribute1 IN jtf_varchar2_table_300 := NULL,

Line 1420: p_qt_tax_exempt_number IN jtf_varchar2_table_100 := NULL,

1416: p_qt_tax_rate IN jtf_number_table := NULL,
1417: p_qt_tax_date IN jtf_date_table := NULL,
1418: p_qt_tax_amount IN jtf_number_table := NULL,
1419: p_qt_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,
1420: p_qt_tax_exempt_number IN jtf_varchar2_table_100 := NULL,
1421: p_qt_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,
1422: p_qt_attribute_category IN jtf_varchar2_table_100 := NULL,
1423: p_qt_attribute1 IN jtf_varchar2_table_300 := NULL,
1424: p_qt_attribute2 IN jtf_varchar2_table_300 := NULL,

Line 1421: p_qt_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,

1417: p_qt_tax_date IN jtf_date_table := NULL,
1418: p_qt_tax_amount IN jtf_number_table := NULL,
1419: p_qt_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,
1420: p_qt_tax_exempt_number IN jtf_varchar2_table_100 := NULL,
1421: p_qt_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,
1422: p_qt_attribute_category IN jtf_varchar2_table_100 := NULL,
1423: p_qt_attribute1 IN jtf_varchar2_table_300 := NULL,
1424: p_qt_attribute2 IN jtf_varchar2_table_300 := NULL,
1425: p_qt_attribute3 IN jtf_varchar2_table_300 := NULL,

Line 1422: p_qt_attribute_category IN jtf_varchar2_table_100 := NULL,

1418: p_qt_tax_amount IN jtf_number_table := NULL,
1419: p_qt_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,
1420: p_qt_tax_exempt_number IN jtf_varchar2_table_100 := NULL,
1421: p_qt_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,
1422: p_qt_attribute_category IN jtf_varchar2_table_100 := NULL,
1423: p_qt_attribute1 IN jtf_varchar2_table_300 := NULL,
1424: p_qt_attribute2 IN jtf_varchar2_table_300 := NULL,
1425: p_qt_attribute3 IN jtf_varchar2_table_300 := NULL,
1426: p_qt_attribute4 IN jtf_varchar2_table_300 := NULL,

Line 1446: p_qsc_operation_code IN jtf_varchar2_table_100 := NULL,

1442: p_qt_attribute20 IN jtf_varchar2_table_300 := NULL,
1443: p_qt_object_version_number IN jtf_number_table := NULL,
1444: p_qt_tax_rate_id IN jtf_number_table := NULL,
1445: -- qh sales credit recore
1446: p_qsc_operation_code IN jtf_varchar2_table_100 := NULL,
1447: p_qsc_qte_line_index IN jtf_number_table := NULL,
1448: p_qsc_sales_credit_id IN jtf_number_table := NULL,
1449: p_qsc_creation_date IN jtf_date_table := NULL,
1450: p_qsc_created_by IN jtf_number_table := NULL,

Line 1468: p_qsc_attribute_category IN jtf_varchar2_table_100 := NULL,

1464: p_qsc_sales_credit_type IN jtf_varchar2_table_300 := NULL,
1465: p_qsc_resource_group_id IN jtf_number_table := NULL,
1466: p_qsc_employee_person_id IN jtf_number_table := NULL,
1467: p_qsc_sales_credit_type_id IN jtf_number_table := NULL,
1468: p_qsc_attribute_category IN jtf_varchar2_table_100 := NULL,
1469: p_qsc_attribute1 IN jtf_varchar2_table_300 := NULL,
1470: p_qsc_attribute2 IN jtf_varchar2_table_300 := NULL,
1471: p_qsc_attribute3 IN jtf_varchar2_table_300 := NULL,
1472: p_qsc_attribute4 IN jtf_varchar2_table_300 := NULL,

Line 1489: p_qsc_system_assigned_flag IN jtf_varchar2_table_100 := NULL,

1485: p_qsc_attribute17 IN jtf_varchar2_table_300 := NULL,
1486: p_qsc_attribute18 IN jtf_varchar2_table_300 := NULL,
1487: p_qsc_attribute19 IN jtf_varchar2_table_300 := NULL,
1488: p_qsc_attribute20 IN jtf_varchar2_table_300 := NULL,
1489: p_qsc_system_assigned_flag IN jtf_varchar2_table_100 := NULL,
1490: p_qsc_credit_rule_id IN jtf_number_table := NULL,
1491: p_qsc_object_version_number IN jtf_number_table := NULL,
1492: -- price adjustment record
1493: p_qlpaj_operation_code IN jtf_varchar2_table_100 := NULL,

Line 1493: p_qlpaj_operation_code IN jtf_varchar2_table_100 := NULL,

1489: p_qsc_system_assigned_flag IN jtf_varchar2_table_100 := NULL,
1490: p_qsc_credit_rule_id IN jtf_number_table := NULL,
1491: p_qsc_object_version_number IN jtf_number_table := NULL,
1492: -- price adjustment record
1493: p_qlpaj_operation_code IN jtf_varchar2_table_100 := NULL,
1494: p_qlpaj_qte_line_index IN jtf_number_table := NULL,
1495: p_qlpaj_price_adjustment_id IN jtf_number_table := NULL,
1496: p_qlpaj_creation_date IN jtf_date_table := NULL,
1497: p_qlpaj_created_by IN jtf_number_table := NULL,

Line 1509: p_qlpaj_mod_line_type_code IN jtf_varchar2_table_100 := NULL,

1505: p_qlpaj_quote_header_id IN jtf_number_table := NULL,
1506: p_qlpaj_quote_line_id IN jtf_number_table := NULL,
1507: p_qlpaj_modifier_header_id IN jtf_number_table := NULL,
1508: p_qlpaj_modifier_line_id IN jtf_number_table := NULL,
1509: p_qlpaj_mod_line_type_code IN jtf_varchar2_table_100 := NULL,
1510: p_qlpaj_mod_mech_type_code IN jtf_varchar2_table_100 := NULL,
1511: p_qlpaj_modified_from IN jtf_number_table := NULL,
1512: p_qlpaj_modified_to IN jtf_number_table := NULL,
1513: p_qlpaj_operand IN jtf_number_table := NULL,

Line 1510: p_qlpaj_mod_mech_type_code IN jtf_varchar2_table_100 := NULL,

1506: p_qlpaj_quote_line_id IN jtf_number_table := NULL,
1507: p_qlpaj_modifier_header_id IN jtf_number_table := NULL,
1508: p_qlpaj_modifier_line_id IN jtf_number_table := NULL,
1509: p_qlpaj_mod_line_type_code IN jtf_varchar2_table_100 := NULL,
1510: p_qlpaj_mod_mech_type_code IN jtf_varchar2_table_100 := NULL,
1511: p_qlpaj_modified_from IN jtf_number_table := NULL,
1512: p_qlpaj_modified_to IN jtf_number_table := NULL,
1513: p_qlpaj_operand IN jtf_number_table := NULL,
1514: p_qlpaj_arithmetic_operator IN jtf_varchar2_table_100 := NULL,

Line 1514: p_qlpaj_arithmetic_operator IN jtf_varchar2_table_100 := NULL,

1510: p_qlpaj_mod_mech_type_code IN jtf_varchar2_table_100 := NULL,
1511: p_qlpaj_modified_from IN jtf_number_table := NULL,
1512: p_qlpaj_modified_to IN jtf_number_table := NULL,
1513: p_qlpaj_operand IN jtf_number_table := NULL,
1514: p_qlpaj_arithmetic_operator IN jtf_varchar2_table_100 := NULL,
1515: p_qlpaj_automatic_flag IN jtf_varchar2_table_100 := NULL,
1516: p_qlpaj_update_allowable_flag IN jtf_varchar2_table_100 := NULL,
1517: p_qlpaj_updated_flag IN jtf_varchar2_table_100 := NULL,
1518: p_qlpaj_applied_flag IN jtf_varchar2_table_100 := NULL,

Line 1515: p_qlpaj_automatic_flag IN jtf_varchar2_table_100 := NULL,

1511: p_qlpaj_modified_from IN jtf_number_table := NULL,
1512: p_qlpaj_modified_to IN jtf_number_table := NULL,
1513: p_qlpaj_operand IN jtf_number_table := NULL,
1514: p_qlpaj_arithmetic_operator IN jtf_varchar2_table_100 := NULL,
1515: p_qlpaj_automatic_flag IN jtf_varchar2_table_100 := NULL,
1516: p_qlpaj_update_allowable_flag IN jtf_varchar2_table_100 := NULL,
1517: p_qlpaj_updated_flag IN jtf_varchar2_table_100 := NULL,
1518: p_qlpaj_applied_flag IN jtf_varchar2_table_100 := NULL,
1519: p_qlpaj_on_invoice_flag IN jtf_varchar2_table_100 := NULL,

Line 1516: p_qlpaj_update_allowable_flag IN jtf_varchar2_table_100 := NULL,

1512: p_qlpaj_modified_to IN jtf_number_table := NULL,
1513: p_qlpaj_operand IN jtf_number_table := NULL,
1514: p_qlpaj_arithmetic_operator IN jtf_varchar2_table_100 := NULL,
1515: p_qlpaj_automatic_flag IN jtf_varchar2_table_100 := NULL,
1516: p_qlpaj_update_allowable_flag IN jtf_varchar2_table_100 := NULL,
1517: p_qlpaj_updated_flag IN jtf_varchar2_table_100 := NULL,
1518: p_qlpaj_applied_flag IN jtf_varchar2_table_100 := NULL,
1519: p_qlpaj_on_invoice_flag IN jtf_varchar2_table_100 := NULL,
1520: p_qlpaj_pricing_phase_id IN jtf_number_table := NULL,

Line 1517: p_qlpaj_updated_flag IN jtf_varchar2_table_100 := NULL,

1513: p_qlpaj_operand IN jtf_number_table := NULL,
1514: p_qlpaj_arithmetic_operator IN jtf_varchar2_table_100 := NULL,
1515: p_qlpaj_automatic_flag IN jtf_varchar2_table_100 := NULL,
1516: p_qlpaj_update_allowable_flag IN jtf_varchar2_table_100 := NULL,
1517: p_qlpaj_updated_flag IN jtf_varchar2_table_100 := NULL,
1518: p_qlpaj_applied_flag IN jtf_varchar2_table_100 := NULL,
1519: p_qlpaj_on_invoice_flag IN jtf_varchar2_table_100 := NULL,
1520: p_qlpaj_pricing_phase_id IN jtf_number_table := NULL,
1521: p_qlpaj_attribute_category IN jtf_varchar2_table_100 := NULL,

Line 1518: p_qlpaj_applied_flag IN jtf_varchar2_table_100 := NULL,

1514: p_qlpaj_arithmetic_operator IN jtf_varchar2_table_100 := NULL,
1515: p_qlpaj_automatic_flag IN jtf_varchar2_table_100 := NULL,
1516: p_qlpaj_update_allowable_flag IN jtf_varchar2_table_100 := NULL,
1517: p_qlpaj_updated_flag IN jtf_varchar2_table_100 := NULL,
1518: p_qlpaj_applied_flag IN jtf_varchar2_table_100 := NULL,
1519: p_qlpaj_on_invoice_flag IN jtf_varchar2_table_100 := NULL,
1520: p_qlpaj_pricing_phase_id IN jtf_number_table := NULL,
1521: p_qlpaj_attribute_category IN jtf_varchar2_table_100 := NULL,
1522: p_qlpaj_attribute1 IN jtf_varchar2_table_300 := NULL,

Line 1519: p_qlpaj_on_invoice_flag IN jtf_varchar2_table_100 := NULL,

1515: p_qlpaj_automatic_flag IN jtf_varchar2_table_100 := NULL,
1516: p_qlpaj_update_allowable_flag IN jtf_varchar2_table_100 := NULL,
1517: p_qlpaj_updated_flag IN jtf_varchar2_table_100 := NULL,
1518: p_qlpaj_applied_flag IN jtf_varchar2_table_100 := NULL,
1519: p_qlpaj_on_invoice_flag IN jtf_varchar2_table_100 := NULL,
1520: p_qlpaj_pricing_phase_id IN jtf_number_table := NULL,
1521: p_qlpaj_attribute_category IN jtf_varchar2_table_100 := NULL,
1522: p_qlpaj_attribute1 IN jtf_varchar2_table_300 := NULL,
1523: p_qlpaj_attribute2 IN jtf_varchar2_table_300 := NULL,

Line 1521: p_qlpaj_attribute_category IN jtf_varchar2_table_100 := NULL,

1517: p_qlpaj_updated_flag IN jtf_varchar2_table_100 := NULL,
1518: p_qlpaj_applied_flag IN jtf_varchar2_table_100 := NULL,
1519: p_qlpaj_on_invoice_flag IN jtf_varchar2_table_100 := NULL,
1520: p_qlpaj_pricing_phase_id IN jtf_number_table := NULL,
1521: p_qlpaj_attribute_category IN jtf_varchar2_table_100 := NULL,
1522: p_qlpaj_attribute1 IN jtf_varchar2_table_300 := NULL,
1523: p_qlpaj_attribute2 IN jtf_varchar2_table_300 := NULL,
1524: p_qlpaj_attribute3 IN jtf_varchar2_table_300 := NULL,
1525: p_qlpaj_attribute4 IN jtf_varchar2_table_300 := NULL,

Line 1542: p_qlpaj_orig_sys_discount_ref IN jtf_varchar2_table_100 := NULL,

1538: p_qlpaj_attribute17 IN jtf_varchar2_table_300 := NULL,
1539: p_qlpaj_attribute18 IN jtf_varchar2_table_300 := NULL,
1540: p_qlpaj_attribute19 IN jtf_varchar2_table_300 := NULL,
1541: p_qlpaj_attribute20 IN jtf_varchar2_table_300 := NULL,
1542: p_qlpaj_orig_sys_discount_ref IN jtf_varchar2_table_100 := NULL,
1543: p_qlpaj_change_sequence IN jtf_varchar2_table_100 := NULL,
1544: p_qlpaj_update_allowed IN jtf_varchar2_table_100 := NULL,
1545: p_qlpaj_change_reason_code IN jtf_varchar2_table_100 := NULL,
1546: p_qlpaj_change_reason_text IN jtf_varchar2_table_2000 := NULL,

Line 1543: p_qlpaj_change_sequence IN jtf_varchar2_table_100 := NULL,

1539: p_qlpaj_attribute18 IN jtf_varchar2_table_300 := NULL,
1540: p_qlpaj_attribute19 IN jtf_varchar2_table_300 := NULL,
1541: p_qlpaj_attribute20 IN jtf_varchar2_table_300 := NULL,
1542: p_qlpaj_orig_sys_discount_ref IN jtf_varchar2_table_100 := NULL,
1543: p_qlpaj_change_sequence IN jtf_varchar2_table_100 := NULL,
1544: p_qlpaj_update_allowed IN jtf_varchar2_table_100 := NULL,
1545: p_qlpaj_change_reason_code IN jtf_varchar2_table_100 := NULL,
1546: p_qlpaj_change_reason_text IN jtf_varchar2_table_2000 := NULL,
1547: p_qlpaj_cost_id IN jtf_number_table := NULL,

Line 1544: p_qlpaj_update_allowed IN jtf_varchar2_table_100 := NULL,

1540: p_qlpaj_attribute19 IN jtf_varchar2_table_300 := NULL,
1541: p_qlpaj_attribute20 IN jtf_varchar2_table_300 := NULL,
1542: p_qlpaj_orig_sys_discount_ref IN jtf_varchar2_table_100 := NULL,
1543: p_qlpaj_change_sequence IN jtf_varchar2_table_100 := NULL,
1544: p_qlpaj_update_allowed IN jtf_varchar2_table_100 := NULL,
1545: p_qlpaj_change_reason_code IN jtf_varchar2_table_100 := NULL,
1546: p_qlpaj_change_reason_text IN jtf_varchar2_table_2000 := NULL,
1547: p_qlpaj_cost_id IN jtf_number_table := NULL,
1548: p_qlpaj_tax_code IN jtf_varchar2_table_100 := NULL,

Line 1545: p_qlpaj_change_reason_code IN jtf_varchar2_table_100 := NULL,

1541: p_qlpaj_attribute20 IN jtf_varchar2_table_300 := NULL,
1542: p_qlpaj_orig_sys_discount_ref IN jtf_varchar2_table_100 := NULL,
1543: p_qlpaj_change_sequence IN jtf_varchar2_table_100 := NULL,
1544: p_qlpaj_update_allowed IN jtf_varchar2_table_100 := NULL,
1545: p_qlpaj_change_reason_code IN jtf_varchar2_table_100 := NULL,
1546: p_qlpaj_change_reason_text IN jtf_varchar2_table_2000 := NULL,
1547: p_qlpaj_cost_id IN jtf_number_table := NULL,
1548: p_qlpaj_tax_code IN jtf_varchar2_table_100 := NULL,
1549: p_qlpaj_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,

Line 1548: p_qlpaj_tax_code IN jtf_varchar2_table_100 := NULL,

1544: p_qlpaj_update_allowed IN jtf_varchar2_table_100 := NULL,
1545: p_qlpaj_change_reason_code IN jtf_varchar2_table_100 := NULL,
1546: p_qlpaj_change_reason_text IN jtf_varchar2_table_2000 := NULL,
1547: p_qlpaj_cost_id IN jtf_number_table := NULL,
1548: p_qlpaj_tax_code IN jtf_varchar2_table_100 := NULL,
1549: p_qlpaj_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,
1550: p_qlpaj_tax_exempt_number IN jtf_varchar2_table_100 := NULL,
1551: p_qlpaj_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,
1552: p_qlpaj_parent_adjustment_id IN jtf_number_table := NULL,

Line 1549: p_qlpaj_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,

1545: p_qlpaj_change_reason_code IN jtf_varchar2_table_100 := NULL,
1546: p_qlpaj_change_reason_text IN jtf_varchar2_table_2000 := NULL,
1547: p_qlpaj_cost_id IN jtf_number_table := NULL,
1548: p_qlpaj_tax_code IN jtf_varchar2_table_100 := NULL,
1549: p_qlpaj_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,
1550: p_qlpaj_tax_exempt_number IN jtf_varchar2_table_100 := NULL,
1551: p_qlpaj_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,
1552: p_qlpaj_parent_adjustment_id IN jtf_number_table := NULL,
1553: p_qlpaj_invoiced_flag IN jtf_varchar2_table_100 := NULL,

Line 1550: p_qlpaj_tax_exempt_number IN jtf_varchar2_table_100 := NULL,

1546: p_qlpaj_change_reason_text IN jtf_varchar2_table_2000 := NULL,
1547: p_qlpaj_cost_id IN jtf_number_table := NULL,
1548: p_qlpaj_tax_code IN jtf_varchar2_table_100 := NULL,
1549: p_qlpaj_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,
1550: p_qlpaj_tax_exempt_number IN jtf_varchar2_table_100 := NULL,
1551: p_qlpaj_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,
1552: p_qlpaj_parent_adjustment_id IN jtf_number_table := NULL,
1553: p_qlpaj_invoiced_flag IN jtf_varchar2_table_100 := NULL,
1554: p_qlpaj_estimated_flag IN jtf_varchar2_table_100 := NULL,

Line 1551: p_qlpaj_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,

1547: p_qlpaj_cost_id IN jtf_number_table := NULL,
1548: p_qlpaj_tax_code IN jtf_varchar2_table_100 := NULL,
1549: p_qlpaj_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,
1550: p_qlpaj_tax_exempt_number IN jtf_varchar2_table_100 := NULL,
1551: p_qlpaj_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,
1552: p_qlpaj_parent_adjustment_id IN jtf_number_table := NULL,
1553: p_qlpaj_invoiced_flag IN jtf_varchar2_table_100 := NULL,
1554: p_qlpaj_estimated_flag IN jtf_varchar2_table_100 := NULL,
1555: p_qlpaj_inc_in_sales_perfce IN jtf_varchar2_table_100 := NULL,

Line 1553: p_qlpaj_invoiced_flag IN jtf_varchar2_table_100 := NULL,

1549: p_qlpaj_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,
1550: p_qlpaj_tax_exempt_number IN jtf_varchar2_table_100 := NULL,
1551: p_qlpaj_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,
1552: p_qlpaj_parent_adjustment_id IN jtf_number_table := NULL,
1553: p_qlpaj_invoiced_flag IN jtf_varchar2_table_100 := NULL,
1554: p_qlpaj_estimated_flag IN jtf_varchar2_table_100 := NULL,
1555: p_qlpaj_inc_in_sales_perfce IN jtf_varchar2_table_100 := NULL,
1556: p_qlpaj_split_action_code IN jtf_varchar2_table_100 := NULL,
1557: p_qlpaj_adjusted_amount IN jtf_number_table := NULL,

Line 1554: p_qlpaj_estimated_flag IN jtf_varchar2_table_100 := NULL,

1550: p_qlpaj_tax_exempt_number IN jtf_varchar2_table_100 := NULL,
1551: p_qlpaj_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,
1552: p_qlpaj_parent_adjustment_id IN jtf_number_table := NULL,
1553: p_qlpaj_invoiced_flag IN jtf_varchar2_table_100 := NULL,
1554: p_qlpaj_estimated_flag IN jtf_varchar2_table_100 := NULL,
1555: p_qlpaj_inc_in_sales_perfce IN jtf_varchar2_table_100 := NULL,
1556: p_qlpaj_split_action_code IN jtf_varchar2_table_100 := NULL,
1557: p_qlpaj_adjusted_amount IN jtf_number_table := NULL,
1558: p_qlpaj_charge_type_code IN jtf_varchar2_table_100 := NULL,

Line 1555: p_qlpaj_inc_in_sales_perfce IN jtf_varchar2_table_100 := NULL,

1551: p_qlpaj_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,
1552: p_qlpaj_parent_adjustment_id IN jtf_number_table := NULL,
1553: p_qlpaj_invoiced_flag IN jtf_varchar2_table_100 := NULL,
1554: p_qlpaj_estimated_flag IN jtf_varchar2_table_100 := NULL,
1555: p_qlpaj_inc_in_sales_perfce IN jtf_varchar2_table_100 := NULL,
1556: p_qlpaj_split_action_code IN jtf_varchar2_table_100 := NULL,
1557: p_qlpaj_adjusted_amount IN jtf_number_table := NULL,
1558: p_qlpaj_charge_type_code IN jtf_varchar2_table_100 := NULL,
1559: p_qlpaj_charge_subtype_code IN jtf_varchar2_table_100 := NULL,

Line 1556: p_qlpaj_split_action_code IN jtf_varchar2_table_100 := NULL,

1552: p_qlpaj_parent_adjustment_id IN jtf_number_table := NULL,
1553: p_qlpaj_invoiced_flag IN jtf_varchar2_table_100 := NULL,
1554: p_qlpaj_estimated_flag IN jtf_varchar2_table_100 := NULL,
1555: p_qlpaj_inc_in_sales_perfce IN jtf_varchar2_table_100 := NULL,
1556: p_qlpaj_split_action_code IN jtf_varchar2_table_100 := NULL,
1557: p_qlpaj_adjusted_amount IN jtf_number_table := NULL,
1558: p_qlpaj_charge_type_code IN jtf_varchar2_table_100 := NULL,
1559: p_qlpaj_charge_subtype_code IN jtf_varchar2_table_100 := NULL,
1560: p_qlpaj_range_break_quantity IN jtf_number_table := NULL,

Line 1558: p_qlpaj_charge_type_code IN jtf_varchar2_table_100 := NULL,

1554: p_qlpaj_estimated_flag IN jtf_varchar2_table_100 := NULL,
1555: p_qlpaj_inc_in_sales_perfce IN jtf_varchar2_table_100 := NULL,
1556: p_qlpaj_split_action_code IN jtf_varchar2_table_100 := NULL,
1557: p_qlpaj_adjusted_amount IN jtf_number_table := NULL,
1558: p_qlpaj_charge_type_code IN jtf_varchar2_table_100 := NULL,
1559: p_qlpaj_charge_subtype_code IN jtf_varchar2_table_100 := NULL,
1560: p_qlpaj_range_break_quantity IN jtf_number_table := NULL,
1561: p_qlpaj_accrual_conv_rate IN jtf_number_table := NULL,
1562: p_qlpaj_pricing_group_sequence IN jtf_number_table := NULL,

Line 1559: p_qlpaj_charge_subtype_code IN jtf_varchar2_table_100 := NULL,

1555: p_qlpaj_inc_in_sales_perfce IN jtf_varchar2_table_100 := NULL,
1556: p_qlpaj_split_action_code IN jtf_varchar2_table_100 := NULL,
1557: p_qlpaj_adjusted_amount IN jtf_number_table := NULL,
1558: p_qlpaj_charge_type_code IN jtf_varchar2_table_100 := NULL,
1559: p_qlpaj_charge_subtype_code IN jtf_varchar2_table_100 := NULL,
1560: p_qlpaj_range_break_quantity IN jtf_number_table := NULL,
1561: p_qlpaj_accrual_conv_rate IN jtf_number_table := NULL,
1562: p_qlpaj_pricing_group_sequence IN jtf_number_table := NULL,
1563: p_qlpaj_accrual_flag IN jtf_varchar2_table_100 := NULL,

Line 1563: p_qlpaj_accrual_flag IN jtf_varchar2_table_100 := NULL,

1559: p_qlpaj_charge_subtype_code IN jtf_varchar2_table_100 := NULL,
1560: p_qlpaj_range_break_quantity IN jtf_number_table := NULL,
1561: p_qlpaj_accrual_conv_rate IN jtf_number_table := NULL,
1562: p_qlpaj_pricing_group_sequence IN jtf_number_table := NULL,
1563: p_qlpaj_accrual_flag IN jtf_varchar2_table_100 := NULL,
1564: p_qlpaj_list_line_no IN jtf_varchar2_table_300 := NULL,
1565: p_qlpaj_source_system_code IN jtf_varchar2_table_100 := NULL,
1566: p_qlpaj_benefit_qty IN jtf_number_table := NULL,
1567: p_qlpaj_benefit_uom_code IN jtf_varchar2_table_100 := NULL,

Line 1565: p_qlpaj_source_system_code IN jtf_varchar2_table_100 := NULL,

1561: p_qlpaj_accrual_conv_rate IN jtf_number_table := NULL,
1562: p_qlpaj_pricing_group_sequence IN jtf_number_table := NULL,
1563: p_qlpaj_accrual_flag IN jtf_varchar2_table_100 := NULL,
1564: p_qlpaj_list_line_no IN jtf_varchar2_table_300 := NULL,
1565: p_qlpaj_source_system_code IN jtf_varchar2_table_100 := NULL,
1566: p_qlpaj_benefit_qty IN jtf_number_table := NULL,
1567: p_qlpaj_benefit_uom_code IN jtf_varchar2_table_100 := NULL,
1568: p_qlpaj_print_on_invoice_flag IN jtf_varchar2_table_100 := NULL,
1569: p_qlpaj_expiration_date IN jtf_date_table := NULL,

Line 1567: p_qlpaj_benefit_uom_code IN jtf_varchar2_table_100 := NULL,

1563: p_qlpaj_accrual_flag IN jtf_varchar2_table_100 := NULL,
1564: p_qlpaj_list_line_no IN jtf_varchar2_table_300 := NULL,
1565: p_qlpaj_source_system_code IN jtf_varchar2_table_100 := NULL,
1566: p_qlpaj_benefit_qty IN jtf_number_table := NULL,
1567: p_qlpaj_benefit_uom_code IN jtf_varchar2_table_100 := NULL,
1568: p_qlpaj_print_on_invoice_flag IN jtf_varchar2_table_100 := NULL,
1569: p_qlpaj_expiration_date IN jtf_date_table := NULL,
1570: p_qlpaj_rebate_trans_type_code IN jtf_varchar2_table_100 := NULL,
1571: p_qlpaj_rebate_trans_reference IN jtf_varchar2_table_100 := NULL,

Line 1568: p_qlpaj_print_on_invoice_flag IN jtf_varchar2_table_100 := NULL,

1564: p_qlpaj_list_line_no IN jtf_varchar2_table_300 := NULL,
1565: p_qlpaj_source_system_code IN jtf_varchar2_table_100 := NULL,
1566: p_qlpaj_benefit_qty IN jtf_number_table := NULL,
1567: p_qlpaj_benefit_uom_code IN jtf_varchar2_table_100 := NULL,
1568: p_qlpaj_print_on_invoice_flag IN jtf_varchar2_table_100 := NULL,
1569: p_qlpaj_expiration_date IN jtf_date_table := NULL,
1570: p_qlpaj_rebate_trans_type_code IN jtf_varchar2_table_100 := NULL,
1571: p_qlpaj_rebate_trans_reference IN jtf_varchar2_table_100 := NULL,
1572: p_qlpaj_rebate_pay_system_code IN jtf_varchar2_table_100 := NULL,

Line 1570: p_qlpaj_rebate_trans_type_code IN jtf_varchar2_table_100 := NULL,

1566: p_qlpaj_benefit_qty IN jtf_number_table := NULL,
1567: p_qlpaj_benefit_uom_code IN jtf_varchar2_table_100 := NULL,
1568: p_qlpaj_print_on_invoice_flag IN jtf_varchar2_table_100 := NULL,
1569: p_qlpaj_expiration_date IN jtf_date_table := NULL,
1570: p_qlpaj_rebate_trans_type_code IN jtf_varchar2_table_100 := NULL,
1571: p_qlpaj_rebate_trans_reference IN jtf_varchar2_table_100 := NULL,
1572: p_qlpaj_rebate_pay_system_code IN jtf_varchar2_table_100 := NULL,
1573: p_qlpaj_redeemed_date IN jtf_date_table := NULL,
1574: p_qlpaj_redeemed_flag IN jtf_varchar2_table_100 := NULL,

Line 1571: p_qlpaj_rebate_trans_reference IN jtf_varchar2_table_100 := NULL,

1567: p_qlpaj_benefit_uom_code IN jtf_varchar2_table_100 := NULL,
1568: p_qlpaj_print_on_invoice_flag IN jtf_varchar2_table_100 := NULL,
1569: p_qlpaj_expiration_date IN jtf_date_table := NULL,
1570: p_qlpaj_rebate_trans_type_code IN jtf_varchar2_table_100 := NULL,
1571: p_qlpaj_rebate_trans_reference IN jtf_varchar2_table_100 := NULL,
1572: p_qlpaj_rebate_pay_system_code IN jtf_varchar2_table_100 := NULL,
1573: p_qlpaj_redeemed_date IN jtf_date_table := NULL,
1574: p_qlpaj_redeemed_flag IN jtf_varchar2_table_100 := NULL,
1575: p_qlpaj_modifier_level_code IN jtf_varchar2_table_100 := NULL,

Line 1572: p_qlpaj_rebate_pay_system_code IN jtf_varchar2_table_100 := NULL,

1568: p_qlpaj_print_on_invoice_flag IN jtf_varchar2_table_100 := NULL,
1569: p_qlpaj_expiration_date IN jtf_date_table := NULL,
1570: p_qlpaj_rebate_trans_type_code IN jtf_varchar2_table_100 := NULL,
1571: p_qlpaj_rebate_trans_reference IN jtf_varchar2_table_100 := NULL,
1572: p_qlpaj_rebate_pay_system_code IN jtf_varchar2_table_100 := NULL,
1573: p_qlpaj_redeemed_date IN jtf_date_table := NULL,
1574: p_qlpaj_redeemed_flag IN jtf_varchar2_table_100 := NULL,
1575: p_qlpaj_modifier_level_code IN jtf_varchar2_table_100 := NULL,
1576: p_qlpaj_price_break_type_code IN jtf_varchar2_table_100 := NULL,

Line 1574: p_qlpaj_redeemed_flag IN jtf_varchar2_table_100 := NULL,

1570: p_qlpaj_rebate_trans_type_code IN jtf_varchar2_table_100 := NULL,
1571: p_qlpaj_rebate_trans_reference IN jtf_varchar2_table_100 := NULL,
1572: p_qlpaj_rebate_pay_system_code IN jtf_varchar2_table_100 := NULL,
1573: p_qlpaj_redeemed_date IN jtf_date_table := NULL,
1574: p_qlpaj_redeemed_flag IN jtf_varchar2_table_100 := NULL,
1575: p_qlpaj_modifier_level_code IN jtf_varchar2_table_100 := NULL,
1576: p_qlpaj_price_break_type_code IN jtf_varchar2_table_100 := NULL,
1577: p_qlpaj_substitution_attribute IN jtf_varchar2_table_100 := NULL,
1578: p_qlpaj_proration_type_code IN jtf_varchar2_table_100 := NULL,

Line 1575: p_qlpaj_modifier_level_code IN jtf_varchar2_table_100 := NULL,

1571: p_qlpaj_rebate_trans_reference IN jtf_varchar2_table_100 := NULL,
1572: p_qlpaj_rebate_pay_system_code IN jtf_varchar2_table_100 := NULL,
1573: p_qlpaj_redeemed_date IN jtf_date_table := NULL,
1574: p_qlpaj_redeemed_flag IN jtf_varchar2_table_100 := NULL,
1575: p_qlpaj_modifier_level_code IN jtf_varchar2_table_100 := NULL,
1576: p_qlpaj_price_break_type_code IN jtf_varchar2_table_100 := NULL,
1577: p_qlpaj_substitution_attribute IN jtf_varchar2_table_100 := NULL,
1578: p_qlpaj_proration_type_code IN jtf_varchar2_table_100 := NULL,
1579: p_qlpaj_include_on_ret_flag IN jtf_varchar2_table_100 := NULL,

Line 1576: p_qlpaj_price_break_type_code IN jtf_varchar2_table_100 := NULL,

1572: p_qlpaj_rebate_pay_system_code IN jtf_varchar2_table_100 := NULL,
1573: p_qlpaj_redeemed_date IN jtf_date_table := NULL,
1574: p_qlpaj_redeemed_flag IN jtf_varchar2_table_100 := NULL,
1575: p_qlpaj_modifier_level_code IN jtf_varchar2_table_100 := NULL,
1576: p_qlpaj_price_break_type_code IN jtf_varchar2_table_100 := NULL,
1577: p_qlpaj_substitution_attribute IN jtf_varchar2_table_100 := NULL,
1578: p_qlpaj_proration_type_code IN jtf_varchar2_table_100 := NULL,
1579: p_qlpaj_include_on_ret_flag IN jtf_varchar2_table_100 := NULL,
1580: p_qlpaj_credit_or_charge_flag IN jtf_varchar2_table_100 := NULL,

Line 1577: p_qlpaj_substitution_attribute IN jtf_varchar2_table_100 := NULL,

1573: p_qlpaj_redeemed_date IN jtf_date_table := NULL,
1574: p_qlpaj_redeemed_flag IN jtf_varchar2_table_100 := NULL,
1575: p_qlpaj_modifier_level_code IN jtf_varchar2_table_100 := NULL,
1576: p_qlpaj_price_break_type_code IN jtf_varchar2_table_100 := NULL,
1577: p_qlpaj_substitution_attribute IN jtf_varchar2_table_100 := NULL,
1578: p_qlpaj_proration_type_code IN jtf_varchar2_table_100 := NULL,
1579: p_qlpaj_include_on_ret_flag IN jtf_varchar2_table_100 := NULL,
1580: p_qlpaj_credit_or_charge_flag IN jtf_varchar2_table_100 := NULL,
1581: p_qlpaj_shipment_index IN jtf_number_table := NULL,

Line 1578: p_qlpaj_proration_type_code IN jtf_varchar2_table_100 := NULL,

1574: p_qlpaj_redeemed_flag IN jtf_varchar2_table_100 := NULL,
1575: p_qlpaj_modifier_level_code IN jtf_varchar2_table_100 := NULL,
1576: p_qlpaj_price_break_type_code IN jtf_varchar2_table_100 := NULL,
1577: p_qlpaj_substitution_attribute IN jtf_varchar2_table_100 := NULL,
1578: p_qlpaj_proration_type_code IN jtf_varchar2_table_100 := NULL,
1579: p_qlpaj_include_on_ret_flag IN jtf_varchar2_table_100 := NULL,
1580: p_qlpaj_credit_or_charge_flag IN jtf_varchar2_table_100 := NULL,
1581: p_qlpaj_shipment_index IN jtf_number_table := NULL,
1582: p_qlpaj_quote_shipment_id IN jtf_number_table := NULL,

Line 1579: p_qlpaj_include_on_ret_flag IN jtf_varchar2_table_100 := NULL,

1575: p_qlpaj_modifier_level_code IN jtf_varchar2_table_100 := NULL,
1576: p_qlpaj_price_break_type_code IN jtf_varchar2_table_100 := NULL,
1577: p_qlpaj_substitution_attribute IN jtf_varchar2_table_100 := NULL,
1578: p_qlpaj_proration_type_code IN jtf_varchar2_table_100 := NULL,
1579: p_qlpaj_include_on_ret_flag IN jtf_varchar2_table_100 := NULL,
1580: p_qlpaj_credit_or_charge_flag IN jtf_varchar2_table_100 := NULL,
1581: p_qlpaj_shipment_index IN jtf_number_table := NULL,
1582: p_qlpaj_quote_shipment_id IN jtf_number_table := NULL,
1583: p_qlpaj_object_version_number IN jtf_number_table := NULL,

Line 1580: p_qlpaj_credit_or_charge_flag IN jtf_varchar2_table_100 := NULL,

1576: p_qlpaj_price_break_type_code IN jtf_varchar2_table_100 := NULL,
1577: p_qlpaj_substitution_attribute IN jtf_varchar2_table_100 := NULL,
1578: p_qlpaj_proration_type_code IN jtf_varchar2_table_100 := NULL,
1579: p_qlpaj_include_on_ret_flag IN jtf_varchar2_table_100 := NULL,
1580: p_qlpaj_credit_or_charge_flag IN jtf_varchar2_table_100 := NULL,
1581: p_qlpaj_shipment_index IN jtf_number_table := NULL,
1582: p_qlpaj_quote_shipment_id IN jtf_number_table := NULL,
1583: p_qlpaj_object_version_number IN jtf_number_table := NULL,
1584: p_api_version_number IN NUMBER := 1 ,