[Home] [Help]
167: p_q_end_cust_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
168: p_q_end_cust_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
169: p_q_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
170: p_q_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
171: p_ql_creation_date IN jtf_date_table := NULL,
172: p_ql_created_by IN jtf_number_table := NULL,
173: p_ql_last_updated_by IN jtf_number_table := NULL,
174: p_ql_last_update_date IN jtf_date_table := NULL,
175: p_ql_last_update_login IN jtf_number_table := NULL,
170: p_q_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
171: p_ql_creation_date IN jtf_date_table := NULL,
172: p_ql_created_by IN jtf_number_table := NULL,
173: p_ql_last_updated_by IN jtf_number_table := NULL,
174: p_ql_last_update_date IN jtf_date_table := NULL,
175: p_ql_last_update_login IN jtf_number_table := NULL,
176: p_ql_request_id IN jtf_number_table := NULL,
177: p_ql_program_application_id IN jtf_number_table := NULL,
178: p_ql_program_id IN jtf_number_table := NULL,
175: p_ql_last_update_login IN jtf_number_table := NULL,
176: p_ql_request_id IN jtf_number_table := NULL,
177: p_ql_program_application_id IN jtf_number_table := NULL,
178: p_ql_program_id IN jtf_number_table := NULL,
179: p_ql_program_update_date IN jtf_date_table := NULL,
180: p_ql_quote_line_id IN jtf_number_table := NULL,
181: p_ql_quote_header_id IN jtf_number_table := NULL,
182: p_ql_org_id IN jtf_number_table := NULL,
183: p_ql_line_number IN jtf_number_table := NULL,
186: p_ql_inventory_item_id IN jtf_number_table := NULL,
187: p_ql_organization_id IN jtf_number_table := NULL,
188: p_ql_quantity IN jtf_number_table := NULL,
189: p_ql_uom_code IN jtf_varchar2_table_100 := NULL,
190: p_ql_start_date_active IN jtf_date_table := NULL,
191: p_ql_end_date_active IN jtf_date_table := NULL,
192: p_ql_order_line_type_id IN jtf_number_table := NULL,
193: p_ql_price_list_id IN jtf_number_table := NULL,
194: p_ql_price_list_line_id IN jtf_number_table := NULL,
187: p_ql_organization_id IN jtf_number_table := NULL,
188: p_ql_quantity IN jtf_number_table := NULL,
189: p_ql_uom_code IN jtf_varchar2_table_100 := NULL,
190: p_ql_start_date_active IN jtf_date_table := NULL,
191: p_ql_end_date_active IN jtf_date_table := NULL,
192: p_ql_order_line_type_id IN jtf_number_table := NULL,
193: p_ql_price_list_id IN jtf_number_table := NULL,
194: p_ql_price_list_line_id IN jtf_number_table := NULL,
195: p_ql_currency_code IN jtf_varchar2_table_100 := NULL,
241: p_ql_end_cust_cust_party_id IN jtf_number_table := NULL,
242: p_ql_end_cust_party_site_id IN jtf_number_table := NULL,
243: p_ql_end_cust_cust_account_id IN jtf_number_table := NULL,
244: p_qrl_line_relationship_id IN jtf_number_table := NULL,
245: p_qrl_creation_date IN jtf_date_table := NULL,
246: p_qrl_created_by IN jtf_number_table := NULL,
247: p_qrl_last_updated_by IN jtf_number_table := NULL,
248: p_qrl_last_update_date IN jtf_date_table := NULL,
249: p_qrl_last_update_login IN jtf_number_table := NULL,
244: p_qrl_line_relationship_id IN jtf_number_table := NULL,
245: p_qrl_creation_date IN jtf_date_table := NULL,
246: p_qrl_created_by IN jtf_number_table := NULL,
247: p_qrl_last_updated_by IN jtf_number_table := NULL,
248: p_qrl_last_update_date IN jtf_date_table := NULL,
249: p_qrl_last_update_login IN jtf_number_table := NULL,
250: p_qrl_request_id IN jtf_number_table := NULL,
251: p_qrl_program_application_id IN jtf_number_table := NULL,
252: p_qrl_program_id IN jtf_number_table := NULL,
249: p_qrl_last_update_login IN jtf_number_table := NULL,
250: p_qrl_request_id IN jtf_number_table := NULL,
251: p_qrl_program_application_id IN jtf_number_table := NULL,
252: p_qrl_program_id IN jtf_number_table := NULL,
253: p_qrl_program_update_date IN jtf_date_table := NULL,
254: p_qrl_quote_line_id IN jtf_number_table := NULL,
255: p_qrl_related_quote_line_id IN jtf_number_table := NULL,
256: p_qrl_relationship_type_code IN jtf_varchar2_table_100 := NULL,
257: p_qrl_reciprocal_flag IN jtf_varchar2_table_100 := NULL,
258: p_qrl_qte_line_index IN jtf_number_table := NULL,
259: p_qrl_related_qte_line_index IN jtf_number_table := NULL,
260: p_qrl_operation_code IN JTF_VARCHAR2_TABLE_100 := null,
261: p_qdl_quote_line_detail_id IN jtf_number_table := NULL,
262: p_qdl_creation_date IN jtf_date_table := NULL,
263: p_qdl_created_by IN jtf_number_table := NULL,
264: p_qdl_last_update_date IN jtf_date_table := NULL,
265: p_qdl_last_updated_by IN jtf_number_table := NULL,
266: p_qdl_last_update_login IN jtf_number_table := NULL,
260: p_qrl_operation_code IN JTF_VARCHAR2_TABLE_100 := null,
261: p_qdl_quote_line_detail_id IN jtf_number_table := NULL,
262: p_qdl_creation_date IN jtf_date_table := NULL,
263: p_qdl_created_by IN jtf_number_table := NULL,
264: p_qdl_last_update_date IN jtf_date_table := NULL,
265: p_qdl_last_updated_by IN jtf_number_table := NULL,
266: p_qdl_last_update_login IN jtf_number_table := NULL,
267: p_qdl_request_id IN jtf_number_table := NULL,
268: p_qdl_program_application_id IN jtf_number_table := NULL,
266: p_qdl_last_update_login IN jtf_number_table := NULL,
267: p_qdl_request_id IN jtf_number_table := NULL,
268: p_qdl_program_application_id IN jtf_number_table := NULL,
269: p_qdl_program_id IN jtf_number_table := NULL,
270: p_qdl_program_update_date IN jtf_date_table := NULL,
271: p_qdl_quote_line_id IN jtf_number_table := NULL,
272: p_qdl_config_header_id IN jtf_number_table := NULL,
273: p_qdl_config_revision_num IN jtf_number_table := NULL,
274: p_qdl_config_item_id IN jtf_number_table := NULL,
330: p_qdl_return_reason_code IN jtf_varchar2_table_100 := NULL,
331: p_qpa_operation_code IN jtf_varchar2_table_100 := NULL,
332: p_qpa_qte_line_index IN jtf_number_table := NULL,
333: p_qpa_price_attribute_id IN jtf_number_table := NULL,
334: p_qpa_creation_date IN jtf_date_table := NULL,
335: p_qpa_created_by IN jtf_number_table := NULL,
336: p_qpa_last_update_date IN jtf_date_table := NULL,
337: p_qpa_last_updated_by IN jtf_number_table := NULL,
338: p_qpa_last_update_login IN jtf_number_table := NULL,
332: p_qpa_qte_line_index IN jtf_number_table := NULL,
333: p_qpa_price_attribute_id IN jtf_number_table := NULL,
334: p_qpa_creation_date IN jtf_date_table := NULL,
335: p_qpa_created_by IN jtf_number_table := NULL,
336: p_qpa_last_update_date IN jtf_date_table := NULL,
337: p_qpa_last_updated_by IN jtf_number_table := NULL,
338: p_qpa_last_update_login IN jtf_number_table := NULL,
339: p_qpa_request_id IN jtf_number_table := NULL,
340: p_qpa_program_application_id IN jtf_number_table := NULL,
338: p_qpa_last_update_login IN jtf_number_table := NULL,
339: p_qpa_request_id IN jtf_number_table := NULL,
340: p_qpa_program_application_id IN jtf_number_table := NULL,
341: p_qpa_program_id IN jtf_number_table := NULL,
342: p_qpa_program_update_date IN jtf_date_table := NULL,
343: p_qpa_quote_header_id IN jtf_number_table := NULL,
344: p_qpa_quote_line_id IN jtf_number_table := NULL,
345: p_qpa_flex_title IN jtf_varchar2_table_100 := NULL,
346: p_qpa_pricing_context IN jtf_varchar2_table_100 := NULL,
462: p_qpa_attribute15 IN jtf_varchar2_table_300 := NULL,
463: p_qp_operation_code IN jtf_varchar2_table_100 := NULL,
464: p_qp_qte_line_index IN jtf_number_table := NULL,
465: p_qp_payment_id IN jtf_number_table := NULL,
466: p_qp_creation_date IN jtf_date_table := NULL,
467: p_qp_created_by IN jtf_number_table := NULL,
468: p_qp_last_update_date IN jtf_date_table := NULL,
469: p_qp_last_updated_by IN jtf_number_table := NULL,
470: p_qp_last_update_login IN jtf_number_table := NULL,
464: p_qp_qte_line_index IN jtf_number_table := NULL,
465: p_qp_payment_id IN jtf_number_table := NULL,
466: p_qp_creation_date IN jtf_date_table := NULL,
467: p_qp_created_by IN jtf_number_table := NULL,
468: p_qp_last_update_date IN jtf_date_table := NULL,
469: p_qp_last_updated_by IN jtf_number_table := NULL,
470: p_qp_last_update_login IN jtf_number_table := NULL,
471: p_qp_request_id IN jtf_number_table := NULL,
472: p_qp_program_application_id IN jtf_number_table := NULL,
470: p_qp_last_update_login IN jtf_number_table := NULL,
471: p_qp_request_id IN jtf_number_table := NULL,
472: p_qp_program_application_id IN jtf_number_table := NULL,
473: p_qp_program_id IN jtf_number_table := NULL,
474: p_qp_program_update_date IN jtf_date_table := NULL,
475: p_qp_quote_header_id IN jtf_number_table := NULL,
476: p_qp_quote_line_id IN jtf_number_table := NULL,
477: p_qp_payment_type_code IN jtf_varchar2_table_100 := NULL,
478: p_qp_payment_ref_number IN jtf_varchar2_table_300 := NULL,
479: p_qp_payment_option IN jtf_varchar2_table_300 := NULL,
480: p_qp_payment_term_id IN jtf_number_table := NULL,
481: p_qp_credit_card_code IN jtf_varchar2_table_100 := NULL,
482: p_qp_credit_card_holder_name IN jtf_varchar2_table_100 := NULL,
483: p_qp_credit_card_exp_date IN jtf_date_table := NULL,
484: p_qp_credit_card_approval_code IN jtf_varchar2_table_100 := NULL,
485: p_qp_credit_card_approval_date IN jtf_date_table := NULL,
486: p_qp_payment_amount IN jtf_number_table := NULL,
487: p_qp_cust_po_number IN jtf_varchar2_table_100 := NULL,
481: p_qp_credit_card_code IN jtf_varchar2_table_100 := NULL,
482: p_qp_credit_card_holder_name IN jtf_varchar2_table_100 := NULL,
483: p_qp_credit_card_exp_date IN jtf_date_table := NULL,
484: p_qp_credit_card_approval_code IN jtf_varchar2_table_100 := NULL,
485: p_qp_credit_card_approval_date IN jtf_date_table := NULL,
486: p_qp_payment_amount IN jtf_number_table := NULL,
487: p_qp_cust_po_number IN jtf_varchar2_table_100 := NULL,
488: p_qp_attribute_category IN jtf_varchar2_table_100 := NULL,
489: p_qp_attribute1 IN jtf_varchar2_table_200 := NULL,
505: p_qp_cvv2 IN JTF_VARCHAR2_TABLE_200 := NULL,
506: p_qs_operation_code IN jtf_varchar2_table_100 := NULL,
507: p_qs_qte_line_index IN jtf_number_table := NULL,
508: p_qs_shipment_id IN jtf_number_table := NULL,
509: p_qs_creation_date IN jtf_date_table := NULL,
510: p_qs_created_by IN jtf_number_table := NULL,
511: p_qs_last_update_date IN jtf_date_table := NULL,
512: p_qs_last_updated_by IN jtf_number_table := NULL,
513: p_qs_last_update_login IN jtf_number_table := NULL,
507: p_qs_qte_line_index IN jtf_number_table := NULL,
508: p_qs_shipment_id IN jtf_number_table := NULL,
509: p_qs_creation_date IN jtf_date_table := NULL,
510: p_qs_created_by IN jtf_number_table := NULL,
511: p_qs_last_update_date IN jtf_date_table := NULL,
512: p_qs_last_updated_by IN jtf_number_table := NULL,
513: p_qs_last_update_login IN jtf_number_table := NULL,
514: p_qs_request_id IN jtf_number_table := NULL,
515: p_qs_program_application_id IN jtf_number_table := NULL,
513: p_qs_last_update_login IN jtf_number_table := NULL,
514: p_qs_request_id IN jtf_number_table := NULL,
515: p_qs_program_application_id IN jtf_number_table := NULL,
516: p_qs_program_id IN jtf_number_table := NULL,
517: p_qs_program_update_date IN jtf_date_table := NULL,
518: p_qs_quote_header_id IN jtf_number_table := NULL,
519: p_qs_quote_line_id IN jtf_number_table := NULL,
520: p_qs_promise_date IN jtf_date_table := NULL,
521: p_qs_request_date IN jtf_date_table := NULL,
516: p_qs_program_id IN jtf_number_table := NULL,
517: p_qs_program_update_date IN jtf_date_table := NULL,
518: p_qs_quote_header_id IN jtf_number_table := NULL,
519: p_qs_quote_line_id IN jtf_number_table := NULL,
520: p_qs_promise_date IN jtf_date_table := NULL,
521: p_qs_request_date IN jtf_date_table := NULL,
522: p_qs_schedule_ship_date IN jtf_date_table := NULL,
523: p_qs_ship_to_party_site_id IN jtf_number_table := NULL,
524: p_qs_ship_to_party_id IN jtf_number_table := NULL,
517: p_qs_program_update_date IN jtf_date_table := NULL,
518: p_qs_quote_header_id IN jtf_number_table := NULL,
519: p_qs_quote_line_id IN jtf_number_table := NULL,
520: p_qs_promise_date IN jtf_date_table := NULL,
521: p_qs_request_date IN jtf_date_table := NULL,
522: p_qs_schedule_ship_date IN jtf_date_table := NULL,
523: p_qs_ship_to_party_site_id IN jtf_number_table := NULL,
524: p_qs_ship_to_party_id IN jtf_number_table := NULL,
525: p_qs_ship_to_cust_acct_id IN jtf_number_table := NULL,
518: p_qs_quote_header_id IN jtf_number_table := NULL,
519: p_qs_quote_line_id IN jtf_number_table := NULL,
520: p_qs_promise_date IN jtf_date_table := NULL,
521: p_qs_request_date IN jtf_date_table := NULL,
522: p_qs_schedule_ship_date IN jtf_date_table := NULL,
523: p_qs_ship_to_party_site_id IN jtf_number_table := NULL,
524: p_qs_ship_to_party_id IN jtf_number_table := NULL,
525: p_qs_ship_to_cust_acct_id IN jtf_number_table := NULL,
526: p_qs_ship_partial_flag IN jtf_varchar2_table_300 := NULL,
573: p_qt_tax_detail_id IN jtf_number_table := NULL,
574: p_qt_quote_header_id IN jtf_number_table := NULL,
575: p_qt_quote_line_id IN jtf_number_table := NULL,
576: p_qt_quote_shipment_id IN jtf_number_table := NULL,
577: p_qt_creation_date IN jtf_date_table := NULL,
578: p_qt_created_by IN jtf_number_table := NULL,
579: p_qt_last_update_date IN jtf_date_table := NULL,
580: p_qt_last_updated_by IN jtf_number_table := NULL,
581: p_qt_last_update_login IN jtf_number_table := NULL,
575: p_qt_quote_line_id IN jtf_number_table := NULL,
576: p_qt_quote_shipment_id IN jtf_number_table := NULL,
577: p_qt_creation_date IN jtf_date_table := NULL,
578: p_qt_created_by IN jtf_number_table := NULL,
579: p_qt_last_update_date IN jtf_date_table := NULL,
580: p_qt_last_updated_by IN jtf_number_table := NULL,
581: p_qt_last_update_login IN jtf_number_table := NULL,
582: p_qt_request_id IN jtf_number_table := NULL,
583: p_qt_program_application_id IN jtf_number_table := NULL,
581: p_qt_last_update_login IN jtf_number_table := NULL,
582: p_qt_request_id IN jtf_number_table := NULL,
583: p_qt_program_application_id IN jtf_number_table := NULL,
584: p_qt_program_id IN jtf_number_table := NULL,
585: p_qt_program_update_date IN jtf_date_table := NULL,
586: p_qt_orig_tax_code IN jtf_varchar2_table_300 := NULL,
587: p_qt_tax_code IN jtf_varchar2_table_100 := NULL,
588: p_qt_tax_rate IN jtf_number_table := NULL,
589: p_qt_tax_date IN jtf_date_table := NULL,
585: p_qt_program_update_date IN jtf_date_table := NULL,
586: p_qt_orig_tax_code IN jtf_varchar2_table_300 := NULL,
587: p_qt_tax_code IN jtf_varchar2_table_100 := NULL,
588: p_qt_tax_rate IN jtf_number_table := NULL,
589: p_qt_tax_date IN jtf_date_table := NULL,
590: p_qt_tax_amount IN jtf_number_table := NULL,
591: p_qt_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,
592: p_qt_tax_exempt_number IN jtf_varchar2_table_100 := NULL,
593: p_qt_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,
609: p_qt_attribute15 IN jtf_varchar2_table_200 := NULL,
610: p_qlpa_operation_code IN jtf_varchar2_table_100 := NULL,
611: p_qlpa_qte_line_index IN jtf_number_table := NULL,
612: p_qlpa_price_attribute_id IN jtf_number_table := NULL,
613: p_qlpa_creation_date IN jtf_date_table := NULL,
614: p_qlpa_created_by IN jtf_number_table := NULL,
615: p_qlpa_last_update_date IN jtf_date_table := NULL,
616: p_qlpa_last_updated_by IN jtf_number_table := NULL,
617: p_qlpa_last_update_login IN jtf_number_table := NULL,
611: p_qlpa_qte_line_index IN jtf_number_table := NULL,
612: p_qlpa_price_attribute_id IN jtf_number_table := NULL,
613: p_qlpa_creation_date IN jtf_date_table := NULL,
614: p_qlpa_created_by IN jtf_number_table := NULL,
615: p_qlpa_last_update_date IN jtf_date_table := NULL,
616: p_qlpa_last_updated_by IN jtf_number_table := NULL,
617: p_qlpa_last_update_login IN jtf_number_table := NULL,
618: p_qlpa_request_id IN jtf_number_table := NULL,
619: p_qlpa_program_application_id IN jtf_number_table := NULL,
617: p_qlpa_last_update_login IN jtf_number_table := NULL,
618: p_qlpa_request_id IN jtf_number_table := NULL,
619: p_qlpa_program_application_id IN jtf_number_table := NULL,
620: p_qlpa_program_id IN jtf_number_table := NULL,
621: p_qlpa_program_update_date IN jtf_date_table := NULL,
622: p_qlpa_quote_header_id IN jtf_number_table := NULL,
623: p_qlpa_quote_line_id IN jtf_number_table := NULL,
624: p_qlpa_flex_title IN jtf_varchar2_table_100 := NULL,
625: p_qlpa_pricing_context IN jtf_varchar2_table_100 := NULL,
741: p_qlpa_attribute15 IN jtf_varchar2_table_300 := NULL,
742: p_qlp_operation_code IN jtf_varchar2_table_100 := NULL,
743: p_qlp_qte_line_index IN jtf_number_table := NULL,
744: p_qlp_payment_id IN jtf_number_table := NULL,
745: p_qlp_creation_date IN jtf_date_table := NULL,
746: p_qlp_created_by IN jtf_number_table := NULL,
747: p_qlp_last_update_date IN jtf_date_table := NULL,
748: p_qlp_last_updated_by IN jtf_number_table := NULL,
749: p_qlp_last_update_login IN jtf_number_table := NULL,
743: p_qlp_qte_line_index IN jtf_number_table := NULL,
744: p_qlp_payment_id IN jtf_number_table := NULL,
745: p_qlp_creation_date IN jtf_date_table := NULL,
746: p_qlp_created_by IN jtf_number_table := NULL,
747: p_qlp_last_update_date IN jtf_date_table := NULL,
748: p_qlp_last_updated_by IN jtf_number_table := NULL,
749: p_qlp_last_update_login IN jtf_number_table := NULL,
750: p_qlp_request_id IN jtf_number_table := NULL,
751: p_qlp_program_application_id IN jtf_number_table := NULL,
749: p_qlp_last_update_login IN jtf_number_table := NULL,
750: p_qlp_request_id IN jtf_number_table := NULL,
751: p_qlp_program_application_id IN jtf_number_table := NULL,
752: p_qlp_program_id IN jtf_number_table := NULL,
753: p_qlp_program_update_date IN jtf_date_table := NULL,
754: p_qlp_quote_header_id IN jtf_number_table := NULL,
755: p_qlp_quote_line_id IN jtf_number_table := NULL,
756: p_qlp_payment_type_code IN jtf_varchar2_table_100 := NULL,
757: p_qlp_payment_ref_number IN jtf_varchar2_table_300 := NULL,
758: p_qlp_payment_option IN jtf_varchar2_table_300 := NULL,
759: p_qlp_payment_term_id IN jtf_number_table := NULL,
760: p_qlp_credit_card_code IN jtf_varchar2_table_100 := NULL,
761: p_qlp_credit_card_holder_name IN jtf_varchar2_table_100 := NULL,
762: p_qlp_credit_card_exp_date IN jtf_date_table := NULL,
763: p_qlp_credit_card_aprv_code IN jtf_varchar2_table_100 := NULL,
764: p_qlp_credit_card_aprv_date IN jtf_date_table := NULL,
765: p_qlp_payment_amount IN jtf_number_table := NULL,
766: p_qlp_cust_po_number IN jtf_varchar2_table_100 := NULL,
760: p_qlp_credit_card_code IN jtf_varchar2_table_100 := NULL,
761: p_qlp_credit_card_holder_name IN jtf_varchar2_table_100 := NULL,
762: p_qlp_credit_card_exp_date IN jtf_date_table := NULL,
763: p_qlp_credit_card_aprv_code IN jtf_varchar2_table_100 := NULL,
764: p_qlp_credit_card_aprv_date IN jtf_date_table := NULL,
765: p_qlp_payment_amount IN jtf_number_table := NULL,
766: p_qlp_cust_po_number IN jtf_varchar2_table_100 := NULL,
767: p_qlp_attribute_category IN jtf_varchar2_table_100 := NULL,
768: p_qlp_attribute1 IN jtf_varchar2_table_200 := NULL,
782: p_qlp_attribute15 IN jtf_varchar2_table_200 := NULL,
783: p_qls_operation_code IN jtf_varchar2_table_100 := NULL,
784: p_qls_qte_line_index IN jtf_number_table := NULL,
785: p_qls_shipment_id IN jtf_number_table := NULL,
786: p_qls_creation_date IN jtf_date_table := NULL,
787: p_qls_created_by IN jtf_number_table := NULL,
788: p_qls_last_update_date IN jtf_date_table := NULL,
789: p_qls_last_updated_by IN jtf_number_table := NULL,
790: p_qls_last_update_login IN jtf_number_table := NULL,
784: p_qls_qte_line_index IN jtf_number_table := NULL,
785: p_qls_shipment_id IN jtf_number_table := NULL,
786: p_qls_creation_date IN jtf_date_table := NULL,
787: p_qls_created_by IN jtf_number_table := NULL,
788: p_qls_last_update_date IN jtf_date_table := NULL,
789: p_qls_last_updated_by IN jtf_number_table := NULL,
790: p_qls_last_update_login IN jtf_number_table := NULL,
791: p_qls_request_id IN jtf_number_table := NULL,
792: p_qls_program_application_id IN jtf_number_table := NULL,
790: p_qls_last_update_login IN jtf_number_table := NULL,
791: p_qls_request_id IN jtf_number_table := NULL,
792: p_qls_program_application_id IN jtf_number_table := NULL,
793: p_qls_program_id IN jtf_number_table := NULL,
794: p_qls_program_update_date IN jtf_date_table := NULL,
795: p_qls_quote_header_id IN jtf_number_table := NULL,
796: p_qls_quote_line_id IN jtf_number_table := NULL,
797: p_qls_promise_date IN jtf_date_table := NULL,
798: p_qls_request_date IN jtf_date_table := NULL,
793: p_qls_program_id IN jtf_number_table := NULL,
794: p_qls_program_update_date IN jtf_date_table := NULL,
795: p_qls_quote_header_id IN jtf_number_table := NULL,
796: p_qls_quote_line_id IN jtf_number_table := NULL,
797: p_qls_promise_date IN jtf_date_table := NULL,
798: p_qls_request_date IN jtf_date_table := NULL,
799: p_qls_schedule_ship_date IN jtf_date_table := NULL,
800: p_qls_ship_to_party_site_id IN jtf_number_table := NULL,
801: p_qls_ship_to_party_id IN jtf_number_table := NULL,
794: p_qls_program_update_date IN jtf_date_table := NULL,
795: p_qls_quote_header_id IN jtf_number_table := NULL,
796: p_qls_quote_line_id IN jtf_number_table := NULL,
797: p_qls_promise_date IN jtf_date_table := NULL,
798: p_qls_request_date IN jtf_date_table := NULL,
799: p_qls_schedule_ship_date IN jtf_date_table := NULL,
800: p_qls_ship_to_party_site_id IN jtf_number_table := NULL,
801: p_qls_ship_to_party_id IN jtf_number_table := NULL,
802: p_qls_ship_to_cust_acct_id IN jtf_number_table := NULL,
795: p_qls_quote_header_id IN jtf_number_table := NULL,
796: p_qls_quote_line_id IN jtf_number_table := NULL,
797: p_qls_promise_date IN jtf_date_table := NULL,
798: p_qls_request_date IN jtf_date_table := NULL,
799: p_qls_schedule_ship_date IN jtf_date_table := NULL,
800: p_qls_ship_to_party_site_id IN jtf_number_table := NULL,
801: p_qls_ship_to_party_id IN jtf_number_table := NULL,
802: p_qls_ship_to_cust_acct_id IN jtf_number_table := NULL,
803: p_qls_ship_partial_flag IN jtf_varchar2_table_300 := NULL,
850: p_qlt_tax_detail_id IN jtf_number_table := NULL,
851: p_qlt_quote_header_id IN jtf_number_table := NULL,
852: p_qlt_quote_line_id IN jtf_number_table := NULL,
853: p_qlt_quote_shipment_id IN jtf_number_table := NULL,
854: p_qlt_creation_date IN jtf_date_table := NULL,
855: p_qlt_created_by IN jtf_number_table := NULL,
856: p_qlt_last_update_date IN jtf_date_table := NULL,
857: p_qlt_last_updated_by IN jtf_number_table := NULL,
858: p_qlt_last_update_login IN jtf_number_table := NULL,
852: p_qlt_quote_line_id IN jtf_number_table := NULL,
853: p_qlt_quote_shipment_id IN jtf_number_table := NULL,
854: p_qlt_creation_date IN jtf_date_table := NULL,
855: p_qlt_created_by IN jtf_number_table := NULL,
856: p_qlt_last_update_date IN jtf_date_table := NULL,
857: p_qlt_last_updated_by IN jtf_number_table := NULL,
858: p_qlt_last_update_login IN jtf_number_table := NULL,
859: p_qlt_request_id IN jtf_number_table := NULL,
860: p_qlt_program_application_id IN jtf_number_table := NULL,
858: p_qlt_last_update_login IN jtf_number_table := NULL,
859: p_qlt_request_id IN jtf_number_table := NULL,
860: p_qlt_program_application_id IN jtf_number_table := NULL,
861: p_qlt_program_id IN jtf_number_table := NULL,
862: p_qlt_program_update_date IN jtf_date_table := NULL,
863: p_qlt_orig_tax_code IN jtf_varchar2_table_300 := NULL,
864: p_qlt_tax_code IN jtf_varchar2_table_100 := NULL,
865: p_qlt_tax_rate IN jtf_number_table := NULL,
866: p_qlt_tax_date IN jtf_date_table := NULL,
862: p_qlt_program_update_date IN jtf_date_table := NULL,
863: p_qlt_orig_tax_code IN jtf_varchar2_table_300 := NULL,
864: p_qlt_tax_code IN jtf_varchar2_table_100 := NULL,
865: p_qlt_tax_rate IN jtf_number_table := NULL,
866: p_qlt_tax_date IN jtf_date_table := NULL,
867: p_qlt_tax_amount IN jtf_number_table := NULL,
868: p_qlt_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,
869: p_qlt_tax_exempt_number IN jtf_varchar2_table_100 := NULL,
870: p_qlt_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,
887: p_qlpaa_operation_code IN jtf_varchar2_table_100 := NULL,
888: p_qlpaa_qte_line_index IN jtf_number_table := NULL,
889: p_qlpaa_price_adj_index IN jtf_number_table := NULL,
890: p_qlpaa_price_adj_attrib_id IN jtf_number_table := NULL,
891: p_qlpaa_creation_date IN jtf_date_table := NULL,
892: p_qlpaa_created_by IN jtf_number_table := NULL,
893: p_qlpaa_last_update_date IN jtf_date_table := NULL,
894: p_qlpaa_last_updated_by IN jtf_number_table := NULL,
895: p_qlpaa_last_update_login IN jtf_number_table := NULL,
889: p_qlpaa_price_adj_index IN jtf_number_table := NULL,
890: p_qlpaa_price_adj_attrib_id IN jtf_number_table := NULL,
891: p_qlpaa_creation_date IN jtf_date_table := NULL,
892: p_qlpaa_created_by IN jtf_number_table := NULL,
893: p_qlpaa_last_update_date IN jtf_date_table := NULL,
894: p_qlpaa_last_updated_by IN jtf_number_table := NULL,
895: p_qlpaa_last_update_login IN jtf_number_table := NULL,
896: p_qlpaa_program_application_id IN jtf_number_table := NULL,
897: p_qlpaa_program_id IN jtf_number_table := NULL,
894: p_qlpaa_last_updated_by IN jtf_number_table := NULL,
895: p_qlpaa_last_update_login IN jtf_number_table := NULL,
896: p_qlpaa_program_application_id IN jtf_number_table := NULL,
897: p_qlpaa_program_id IN jtf_number_table := NULL,
898: p_qlpaa_program_update_date IN jtf_date_table := NULL,
899: p_qlpaa_request_id IN jtf_number_table := NULL,
900: p_qlpaa_price_adjustment_id IN jtf_number_table := NULL,
901: p_qlpaa_pricing_context IN jtf_varchar2_table_100 := NULL,
902: p_qlpaa_pricing_attribute IN jtf_varchar2_table_100 := NULL,
906: p_qlpaa_flex_title IN jtf_varchar2_table_100 := NULL,
907: p_qlpaj_operation_code IN jtf_varchar2_table_100 := NULL,
908: p_qlpaj_qte_line_index IN jtf_number_table := NULL,
909: p_qlpaj_price_adjustment_id IN jtf_number_table := NULL,
910: p_qlpaj_creation_date IN jtf_date_table := NULL,
911: p_qlpaj_created_by IN jtf_number_table := NULL,
912: p_qlpaj_last_update_date IN jtf_date_table := NULL,
913: p_qlpaj_last_updated_by IN jtf_number_table := NULL,
914: p_qlpaj_last_update_login IN jtf_number_table := NULL,
908: p_qlpaj_qte_line_index IN jtf_number_table := NULL,
909: p_qlpaj_price_adjustment_id IN jtf_number_table := NULL,
910: p_qlpaj_creation_date IN jtf_date_table := NULL,
911: p_qlpaj_created_by IN jtf_number_table := NULL,
912: p_qlpaj_last_update_date IN jtf_date_table := NULL,
913: p_qlpaj_last_updated_by IN jtf_number_table := NULL,
914: p_qlpaj_last_update_login IN jtf_number_table := NULL,
915: p_qlpaj_program_application_id IN jtf_number_table := NULL,
916: p_qlpaj_program_id IN jtf_number_table := NULL,
913: p_qlpaj_last_updated_by IN jtf_number_table := NULL,
914: p_qlpaj_last_update_login IN jtf_number_table := NULL,
915: p_qlpaj_program_application_id IN jtf_number_table := NULL,
916: p_qlpaj_program_id IN jtf_number_table := NULL,
917: p_qlpaj_program_update_date IN jtf_date_table := NULL,
918: p_qlpaj_request_id IN jtf_number_table := NULL,
919: p_qlpaj_quote_header_id IN jtf_number_table := NULL,
920: p_qlpaj_quote_line_id IN jtf_number_table := NULL,
921: p_qlpaj_modifier_header_id IN jtf_number_table := NULL,
974: p_qlpaj_source_system_code IN jtf_varchar2_table_100 := NULL,
975: p_qlpaj_benefit_qty IN jtf_number_table := NULL,
976: p_qlpaj_benefit_uom_code IN jtf_varchar2_table_100 := NULL,
977: p_qlpaj_print_on_invoice_flag IN jtf_varchar2_table_100 := NULL,
978: p_qlpaj_expiration_date IN jtf_date_table := NULL,
979: p_qlpaj_rebate_trans_type_code IN jtf_varchar2_table_100 := NULL,
980: p_qlpaj_rebate_trans_reference IN jtf_varchar2_table_100 := NULL,
981: p_qlpaj_rebate_pay_system_code IN jtf_varchar2_table_100 := NULL,
982: p_qlpaj_redeemed_date IN jtf_date_table := NULL,
978: p_qlpaj_expiration_date IN jtf_date_table := NULL,
979: p_qlpaj_rebate_trans_type_code IN jtf_varchar2_table_100 := NULL,
980: p_qlpaj_rebate_trans_reference IN jtf_varchar2_table_100 := NULL,
981: p_qlpaj_rebate_pay_system_code IN jtf_varchar2_table_100 := NULL,
982: p_qlpaj_redeemed_date IN jtf_date_table := NULL,
983: p_qlpaj_redeemed_flag IN jtf_varchar2_table_100 := NULL,
984: p_qlpaj_modifier_level_code IN jtf_varchar2_table_100 := NULL,
985: p_qlpaj_price_break_type_code IN jtf_varchar2_table_100 := NULL,
986: p_qlpaj_substitution_attribute IN jtf_varchar2_table_100 := NULL,
988: p_qlpaj_include_on_ret_flag IN jtf_varchar2_table_100 := NULL,
989: p_qlpaj_credit_or_charge_flag IN jtf_varchar2_table_100 := NULL,
990: p_qlpar_operation_code IN jtf_varchar2_table_100 := NULL,
991: p_qlpar_adj_relationship_id IN jtf_number_table := NULL,
992: p_qlpar_creation_date IN jtf_date_table := NULL,
993: p_qlpar_created_by IN jtf_number_table := NULL,
994: p_qlpar_last_update_date IN jtf_date_table := NULL,
995: p_qlpar_last_updated_by IN jtf_number_table := NULL,
996: p_qlpar_last_update_login IN jtf_number_table := NULL,
990: p_qlpar_operation_code IN jtf_varchar2_table_100 := NULL,
991: p_qlpar_adj_relationship_id IN jtf_number_table := NULL,
992: p_qlpar_creation_date IN jtf_date_table := NULL,
993: p_qlpar_created_by IN jtf_number_table := NULL,
994: p_qlpar_last_update_date IN jtf_date_table := NULL,
995: p_qlpar_last_updated_by IN jtf_number_table := NULL,
996: p_qlpar_last_update_login IN jtf_number_table := NULL,
997: p_qlpar_request_id IN jtf_number_table := NULL,
998: p_qlpar_program_application_id IN jtf_number_table := NULL,
996: p_qlpar_last_update_login IN jtf_number_table := NULL,
997: p_qlpar_request_id IN jtf_number_table := NULL,
998: p_qlpar_program_application_id IN jtf_number_table := NULL,
999: p_qlpar_program_id IN jtf_number_table := NULL,
1000: p_qlpar_program_update_date IN jtf_date_table := NULL,
1001: p_qlpar_quote_line_id IN jtf_number_table := NULL,
1002: p_qlpar_qte_line_index IN jtf_number_table := NULL,
1003: p_qlpar_price_adjustment_id IN jtf_number_table := NULL,
1004: p_qlpar_price_adj_index IN jtf_number_table := NULL,
1006: p_qlpar_rltd_price_adj_index IN jtf_number_table := NULL,
1007: p_qlae_qte_line_index IN jtf_number_table := NULL,
1008: p_qlae_shipment_index IN jtf_number_table := NULL,
1009: p_qlae_line_attribute_id IN jtf_number_table := NULL,
1010: p_qlae_creation_date IN jtf_date_table := NULL,
1011: p_qlae_created_by IN jtf_number_table := NULL,
1012: p_qlae_last_update_date IN jtf_date_table := NULL,
1013: p_qlae_last_updated_by IN jtf_number_table := NULL,
1014: p_qlae_last_update_login IN jtf_number_table := NULL,
1008: p_qlae_shipment_index IN jtf_number_table := NULL,
1009: p_qlae_line_attribute_id IN jtf_number_table := NULL,
1010: p_qlae_creation_date IN jtf_date_table := NULL,
1011: p_qlae_created_by IN jtf_number_table := NULL,
1012: p_qlae_last_update_date IN jtf_date_table := NULL,
1013: p_qlae_last_updated_by IN jtf_number_table := NULL,
1014: p_qlae_last_update_login IN jtf_number_table := NULL,
1015: p_qlae_request_id IN jtf_number_table := NULL,
1016: p_qlae_program_application_id IN jtf_number_table := NULL,
1014: p_qlae_last_update_login IN jtf_number_table := NULL,
1015: p_qlae_request_id IN jtf_number_table := NULL,
1016: p_qlae_program_application_id IN jtf_number_table := NULL,
1017: p_qlae_program_id IN jtf_number_table := NULL,
1018: p_qlae_program_update_date IN jtf_date_table := NULL,
1019: p_qlae_quote_header_id IN jtf_number_table := NULL,
1020: p_qlae_quote_line_id IN jtf_number_table := NULL,
1021: p_qlae_quote_shipment_id IN jtf_number_table := NULL,
1022: p_qlae_attribute_type_code IN jtf_varchar2_table_100 := NULL,
1024: p_qlae_value IN jtf_varchar2_table_2000 := NULL,
1025: p_qlae_value_type IN jtf_varchar2_table_300 := NULL,
1026: p_qlae_status IN jtf_varchar2_table_100 := NULL,
1027: p_qlae_application_id IN jtf_number_table := NULL,
1028: p_qlae_start_date_active IN jtf_date_table := NULL,
1029: p_qlae_end_date_active IN jtf_date_table := NULL,
1030: p_qlae_operation_code IN jtf_varchar2_table_100 := NULL,
1031: p_qfc_operation_code IN jtf_varchar2_table_100 := NULL,
1032: p_qfc_qte_line_index IN jtf_number_table := NULL,
1025: p_qlae_value_type IN jtf_varchar2_table_300 := NULL,
1026: p_qlae_status IN jtf_varchar2_table_100 := NULL,
1027: p_qlae_application_id IN jtf_number_table := NULL,
1028: p_qlae_start_date_active IN jtf_date_table := NULL,
1029: p_qlae_end_date_active IN jtf_date_table := NULL,
1030: p_qlae_operation_code IN jtf_varchar2_table_100 := NULL,
1031: p_qfc_operation_code IN jtf_varchar2_table_100 := NULL,
1032: p_qfc_qte_line_index IN jtf_number_table := NULL,
1033: p_qfc_shipment_index IN jtf_number_table := NULL,
1031: p_qfc_operation_code IN jtf_varchar2_table_100 := NULL,
1032: p_qfc_qte_line_index IN jtf_number_table := NULL,
1033: p_qfc_shipment_index IN jtf_number_table := NULL,
1034: p_qfc_freight_charge_id IN jtf_number_table := NULL,
1035: p_qfc_last_update_date IN jtf_date_table := NULL,
1036: p_qfc_last_updated_by IN jtf_number_table := NULL,
1037: p_qfc_creation_date IN jtf_date_table := NULL,
1038: p_qfc_created_by IN jtf_number_table := NULL,
1039: p_qfc_last_update_login IN jtf_number_table := NULL,
1033: p_qfc_shipment_index IN jtf_number_table := NULL,
1034: p_qfc_freight_charge_id IN jtf_number_table := NULL,
1035: p_qfc_last_update_date IN jtf_date_table := NULL,
1036: p_qfc_last_updated_by IN jtf_number_table := NULL,
1037: p_qfc_creation_date IN jtf_date_table := NULL,
1038: p_qfc_created_by IN jtf_number_table := NULL,
1039: p_qfc_last_update_login IN jtf_number_table := NULL,
1040: p_qfc_program_application_id IN jtf_number_table := NULL,
1041: p_qfc_program_id IN jtf_number_table := NULL,
1038: p_qfc_created_by IN jtf_number_table := NULL,
1039: p_qfc_last_update_login IN jtf_number_table := NULL,
1040: p_qfc_program_application_id IN jtf_number_table := NULL,
1041: p_qfc_program_id IN jtf_number_table := NULL,
1042: p_qfc_program_update_date IN jtf_date_table := NULL,
1043: p_qfc_request_id IN jtf_number_table := NULL,
1044: p_qfc_quote_shipment_id IN jtf_number_table := NULL,
1045: p_qfc_quote_line_id IN jtf_number_table := NULL,
1046: p_qfc_freight_charge_type_id IN jtf_number_table := NULL,
1064: p_qlfc_operation_code IN jtf_varchar2_table_100 := NULL,
1065: p_qlfc_qte_line_index IN jtf_number_table := NULL,
1066: p_qlfc_shipment_index IN jtf_number_table := NULL,
1067: p_qlfc_freight_charge_id IN jtf_number_table := NULL,
1068: p_qlfc_last_update_date IN jtf_date_table := NULL,
1069: p_qlfc_last_updated_by IN jtf_number_table := NULL,
1070: p_qlfc_creation_date IN jtf_date_table := NULL,
1071: p_qlfc_created_by IN jtf_number_table := NULL,
1072: p_qlfc_last_update_login IN jtf_number_table := NULL,
1066: p_qlfc_shipment_index IN jtf_number_table := NULL,
1067: p_qlfc_freight_charge_id IN jtf_number_table := NULL,
1068: p_qlfc_last_update_date IN jtf_date_table := NULL,
1069: p_qlfc_last_updated_by IN jtf_number_table := NULL,
1070: p_qlfc_creation_date IN jtf_date_table := NULL,
1071: p_qlfc_created_by IN jtf_number_table := NULL,
1072: p_qlfc_last_update_login IN jtf_number_table := NULL,
1073: p_qlfc_program_application_id IN jtf_number_table := NULL,
1074: p_qlfc_program_id IN jtf_number_table := NULL,
1071: p_qlfc_created_by IN jtf_number_table := NULL,
1072: p_qlfc_last_update_login IN jtf_number_table := NULL,
1073: p_qlfc_program_application_id IN jtf_number_table := NULL,
1074: p_qlfc_program_id IN jtf_number_table := NULL,
1075: p_qlfc_program_update_date IN jtf_date_table := NULL,
1076: p_qlfc_request_id IN jtf_number_table := NULL,
1077: p_qlfc_quote_shipment_id IN jtf_number_table := NULL,
1078: p_qlfc_quote_line_id IN jtf_number_table := NULL,
1079: p_qlfc_freight_charge_type_id IN jtf_number_table := NULL,
1262: p_q_save_type IN NUMBER := FND_API.G_MISS_NUM,
1263: p_q_minisite_id IN NUMBER := FND_API.G_MISS_NUM,
1264: p_q_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
1265: p_q_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
1266: p_ql_creation_date IN jtf_date_table := NULL,
1267: p_ql_created_by IN jtf_number_table := NULL,
1268: p_ql_last_updated_by IN jtf_number_table := NULL,
1269: p_ql_last_update_date IN jtf_date_table := NULL,
1270: p_ql_last_update_login IN jtf_number_table := NULL,
1265: p_q_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
1266: p_ql_creation_date IN jtf_date_table := NULL,
1267: p_ql_created_by IN jtf_number_table := NULL,
1268: p_ql_last_updated_by IN jtf_number_table := NULL,
1269: p_ql_last_update_date IN jtf_date_table := NULL,
1270: p_ql_last_update_login IN jtf_number_table := NULL,
1271: p_ql_request_id IN jtf_number_table := NULL,
1272: p_ql_program_application_id IN jtf_number_table := NULL,
1273: p_ql_program_id IN jtf_number_table := NULL,
1270: p_ql_last_update_login IN jtf_number_table := NULL,
1271: p_ql_request_id IN jtf_number_table := NULL,
1272: p_ql_program_application_id IN jtf_number_table := NULL,
1273: p_ql_program_id IN jtf_number_table := NULL,
1274: p_ql_program_update_date IN jtf_date_table := NULL,
1275: p_ql_quote_line_id IN jtf_number_table := NULL,
1276: p_ql_quote_header_id IN jtf_number_table := NULL,
1277: p_ql_org_id IN jtf_number_table := NULL,
1278: p_ql_line_number IN jtf_number_table := NULL,
1281: p_ql_inventory_item_id IN jtf_number_table := NULL,
1282: p_ql_organization_id IN jtf_number_table := NULL,
1283: p_ql_quantity IN jtf_number_table := NULL,
1284: p_ql_uom_code IN jtf_varchar2_table_100 := NULL,
1285: p_ql_start_date_active IN jtf_date_table := NULL,
1286: p_ql_end_date_active IN jtf_date_table := NULL,
1287: p_ql_order_line_type_id IN jtf_number_table := NULL,
1288: p_ql_price_list_id IN jtf_number_table := NULL,
1289: p_ql_price_list_line_id IN jtf_number_table := NULL,
1282: p_ql_organization_id IN jtf_number_table := NULL,
1283: p_ql_quantity IN jtf_number_table := NULL,
1284: p_ql_uom_code IN jtf_varchar2_table_100 := NULL,
1285: p_ql_start_date_active IN jtf_date_table := NULL,
1286: p_ql_end_date_active IN jtf_date_table := NULL,
1287: p_ql_order_line_type_id IN jtf_number_table := NULL,
1288: p_ql_price_list_id IN jtf_number_table := NULL,
1289: p_ql_price_list_line_id IN jtf_number_table := NULL,
1290: p_ql_currency_code IN jtf_varchar2_table_100 := NULL,