[Home] [Help]
16: FUNCTION Construct_Payment_Tbl(
17: p_operation_code IN jtf_varchar2_table_100 ,
18: p_qte_line_index IN jtf_number_table ,
19: p_payment_id IN jtf_number_table ,
20: p_creation_date IN jtf_date_table ,
21: p_created_by IN jtf_number_table ,
22: p_last_update_date IN jtf_date_table ,
23: p_last_updated_by IN jtf_number_table ,
24: p_last_update_login IN jtf_number_table ,
18: p_qte_line_index IN jtf_number_table ,
19: p_payment_id IN jtf_number_table ,
20: p_creation_date IN jtf_date_table ,
21: p_created_by IN jtf_number_table ,
22: p_last_update_date IN jtf_date_table ,
23: p_last_updated_by IN jtf_number_table ,
24: p_last_update_login IN jtf_number_table ,
25: p_request_id IN jtf_number_table ,
26: p_program_application_id IN jtf_number_table ,
24: p_last_update_login IN jtf_number_table ,
25: p_request_id IN jtf_number_table ,
26: p_program_application_id IN jtf_number_table ,
27: p_program_id IN jtf_number_table ,
28: p_program_update_date IN jtf_date_table ,
29: p_quote_header_id IN jtf_number_table ,
30: p_quote_line_id IN jtf_number_table ,
31: p_payment_type_code IN jtf_varchar2_table_100 ,
32: p_payment_ref_number IN jtf_varchar2_table_300 ,
33: p_payment_option IN jtf_varchar2_table_300 ,
34: p_payment_term_id IN jtf_number_table ,
35: p_credit_card_code IN jtf_varchar2_table_100 ,
36: p_credit_card_holder_name IN jtf_varchar2_table_100 ,
37: p_credit_card_exp_date IN jtf_date_table ,
38: p_credit_card_approval_code IN jtf_varchar2_table_100 ,
39: p_credit_card_approval_date IN jtf_date_table ,
40: p_payment_amount IN jtf_number_table ,
41: p_cust_po_number IN jtf_varchar2_table_100 ,
35: p_credit_card_code IN jtf_varchar2_table_100 ,
36: p_credit_card_holder_name IN jtf_varchar2_table_100 ,
37: p_credit_card_exp_date IN jtf_date_table ,
38: p_credit_card_approval_code IN jtf_varchar2_table_100 ,
39: p_credit_card_approval_date IN jtf_date_table ,
40: p_payment_amount IN jtf_number_table ,
41: p_cust_po_number IN jtf_varchar2_table_100 ,
42: p_attribute_category IN jtf_varchar2_table_100 ,
43: p_attribute1 IN jtf_varchar2_table_200 ,
354:
355: FUNCTION Construct_Price_Adj_Rel_Tbl(
356: p_operation_code IN jtf_varchar2_table_100 ,
357: p_adj_relationship_id IN jtf_number_table ,
358: p_creation_date IN jtf_date_table ,
359: p_created_by IN jtf_number_table ,
360: p_last_update_date IN jtf_date_table ,
361: p_last_updated_by IN jtf_number_table ,
362: p_last_update_login IN jtf_number_table ,
356: p_operation_code IN jtf_varchar2_table_100 ,
357: p_adj_relationship_id IN jtf_number_table ,
358: p_creation_date IN jtf_date_table ,
359: p_created_by IN jtf_number_table ,
360: p_last_update_date IN jtf_date_table ,
361: p_last_updated_by IN jtf_number_table ,
362: p_last_update_login IN jtf_number_table ,
363: p_request_id IN jtf_number_table ,
364: p_program_application_id IN jtf_number_table ,
362: p_last_update_login IN jtf_number_table ,
363: p_request_id IN jtf_number_table ,
364: p_program_application_id IN jtf_number_table ,
365: p_program_id IN jtf_number_table ,
366: p_program_update_date IN jtf_date_table ,
367: p_quote_line_id IN jtf_number_table ,
368: p_qte_line_index IN jtf_number_table ,
369: p_price_adjustment_id IN jtf_number_table ,
370: p_price_adj_index IN jtf_number_table ,
475: FUNCTION Construct_Price_Adj_Tbl(
476: p_operation_code IN jtf_varchar2_table_100 ,
477: p_qte_line_index IN jtf_number_table ,
478: p_price_adjustment_id IN jtf_number_table ,
479: p_creation_date IN jtf_date_table ,
480: p_created_by IN jtf_number_table ,
481: p_last_update_date IN jtf_date_table ,
482: p_last_updated_by IN jtf_number_table ,
483: p_last_update_login IN jtf_number_table ,
477: p_qte_line_index IN jtf_number_table ,
478: p_price_adjustment_id IN jtf_number_table ,
479: p_creation_date IN jtf_date_table ,
480: p_created_by IN jtf_number_table ,
481: p_last_update_date IN jtf_date_table ,
482: p_last_updated_by IN jtf_number_table ,
483: p_last_update_login IN jtf_number_table ,
484: p_program_application_id IN jtf_number_table ,
485: p_program_id IN jtf_number_table ,
482: p_last_updated_by IN jtf_number_table ,
483: p_last_update_login IN jtf_number_table ,
484: p_program_application_id IN jtf_number_table ,
485: p_program_id IN jtf_number_table ,
486: p_program_update_date IN jtf_date_table ,
487: p_request_id IN jtf_number_table ,
488: p_quote_header_id IN jtf_number_table ,
489: p_quote_line_id IN jtf_number_table ,
490: p_modifier_header_id IN jtf_number_table ,
543: p_source_system_code IN jtf_varchar2_table_100 ,
544: p_benefit_qty IN jtf_number_table ,
545: p_benefit_uom_code IN jtf_varchar2_table_100 ,
546: p_print_on_invoice_flag IN jtf_varchar2_table_100 ,
547: p_expiration_date IN jtf_date_table ,
548: p_rebate_trans_type_code IN jtf_varchar2_table_100 ,
549: p_rebate_trans_reference IN jtf_varchar2_table_100 ,
550: p_rebate_pay_system_code IN jtf_varchar2_table_100 ,
551: p_redeemed_date IN jtf_date_table ,
547: p_expiration_date IN jtf_date_table ,
548: p_rebate_trans_type_code IN jtf_varchar2_table_100 ,
549: p_rebate_trans_reference IN jtf_varchar2_table_100 ,
550: p_rebate_pay_system_code IN jtf_varchar2_table_100 ,
551: p_redeemed_date IN jtf_date_table ,
552: p_redeemed_flag IN jtf_varchar2_table_100 ,
553: p_modifier_level_code IN jtf_varchar2_table_100 ,
554: p_price_break_type_code IN jtf_varchar2_table_100 ,
555: p_substitution_attribute IN jtf_varchar2_table_100 ,
775: p_operation_code IN jtf_varchar2_table_100 ,
776: p_qte_line_index IN jtf_number_table ,
777: p_price_adj_index IN jtf_number_table ,
778: p_price_adj_attrib_id IN jtf_number_table ,
779: p_creation_date IN jtf_date_table ,
780: p_created_by IN jtf_number_table ,
781: p_last_update_date IN jtf_date_table ,
782: p_last_updated_by IN jtf_number_table ,
783: p_last_update_login IN jtf_number_table ,
777: p_price_adj_index IN jtf_number_table ,
778: p_price_adj_attrib_id IN jtf_number_table ,
779: p_creation_date IN jtf_date_table ,
780: p_created_by IN jtf_number_table ,
781: p_last_update_date IN jtf_date_table ,
782: p_last_updated_by IN jtf_number_table ,
783: p_last_update_login IN jtf_number_table ,
784: p_program_application_id IN jtf_number_table ,
785: p_program_id IN jtf_number_table ,
782: p_last_updated_by IN jtf_number_table ,
783: p_last_update_login IN jtf_number_table ,
784: p_program_application_id IN jtf_number_table ,
785: p_program_id IN jtf_number_table ,
786: p_program_update_date IN jtf_date_table ,
787: p_request_id IN jtf_number_table ,
788: p_price_adjustment_id IN jtf_number_table ,
789: p_pricing_context IN jtf_varchar2_table_100 ,
790: p_pricing_attribute IN jtf_varchar2_table_100 ,
887: FUNCTION Construct_Line_Attribs_Ext_Tbl(
888: p_qte_line_index IN jtf_number_table ,
889: p_shipment_index IN jtf_number_table ,
890: p_line_attribute_id IN jtf_number_table ,
891: p_creation_date IN jtf_date_table ,
892: p_created_by IN jtf_number_table ,
893: p_last_update_date IN jtf_date_table ,
894: p_last_updated_by IN jtf_number_table ,
895: p_last_update_login IN jtf_number_table ,
889: p_shipment_index IN jtf_number_table ,
890: p_line_attribute_id IN jtf_number_table ,
891: p_creation_date IN jtf_date_table ,
892: p_created_by IN jtf_number_table ,
893: p_last_update_date IN jtf_date_table ,
894: p_last_updated_by IN jtf_number_table ,
895: p_last_update_login IN jtf_number_table ,
896: p_request_id IN jtf_number_table ,
897: p_program_application_id IN jtf_number_table ,
895: p_last_update_login IN jtf_number_table ,
896: p_request_id IN jtf_number_table ,
897: p_program_application_id IN jtf_number_table ,
898: p_program_id IN jtf_number_table ,
899: p_program_update_date IN jtf_date_table ,
900: p_quote_header_id IN jtf_number_table ,
901: p_quote_line_id IN jtf_number_table ,
902: p_quote_shipment_id IN jtf_number_table ,
903: p_attribute_type_code IN jtf_varchar2_table_100 ,
905: p_value IN jtf_varchar2_table_2000 ,
906: p_value_type IN jtf_varchar2_table_300 ,
907: p_status IN jtf_varchar2_table_100 ,
908: p_application_id IN jtf_number_table ,
909: p_start_date_active IN jtf_date_table ,
910: p_end_date_active IN jtf_date_table ,
911: p_operation_code IN jtf_varchar2_table_100
912: )
913: RETURN ASO_Quote_Pub.Line_Attribs_Ext_Tbl_Type
906: p_value_type IN jtf_varchar2_table_300 ,
907: p_status IN jtf_varchar2_table_100 ,
908: p_application_id IN jtf_number_table ,
909: p_start_date_active IN jtf_date_table ,
910: p_end_date_active IN jtf_date_table ,
911: p_operation_code IN jtf_varchar2_table_100
912: )
913: RETURN ASO_Quote_Pub.Line_Attribs_Ext_Tbl_Type
914: IS
1029: p_operation_code IN jtf_varchar2_table_100 ,
1030: p_qte_line_index IN jtf_number_table ,
1031: p_shipment_index IN jtf_number_table ,
1032: p_freight_charge_id IN jtf_number_table ,
1033: p_last_update_date IN jtf_date_table ,
1034: p_last_updated_by IN jtf_number_table ,
1035: p_creation_date IN jtf_date_table ,
1036: p_created_by IN jtf_number_table ,
1037: p_last_update_login IN jtf_number_table ,
1031: p_shipment_index IN jtf_number_table ,
1032: p_freight_charge_id IN jtf_number_table ,
1033: p_last_update_date IN jtf_date_table ,
1034: p_last_updated_by IN jtf_number_table ,
1035: p_creation_date IN jtf_date_table ,
1036: p_created_by IN jtf_number_table ,
1037: p_last_update_login IN jtf_number_table ,
1038: p_program_application_id IN jtf_number_table ,
1039: p_program_id IN jtf_number_table ,
1036: p_created_by IN jtf_number_table ,
1037: p_last_update_login IN jtf_number_table ,
1038: p_program_application_id IN jtf_number_table ,
1039: p_program_id IN jtf_number_table ,
1040: p_program_update_date IN jtf_date_table ,
1041: p_request_id IN jtf_number_table ,
1042: p_quote_shipment_id IN jtf_number_table ,
1043: p_quote_line_id IN jtf_number_table ,
1044: p_freight_charge_type_id IN jtf_number_table ,
1179: FUNCTION Construct_Price_Attributes_Tbl(
1180: p_operation_code IN jtf_varchar2_table_100 ,
1181: p_qte_line_index IN jtf_number_table ,
1182: p_price_attribute_id IN jtf_number_table ,
1183: p_creation_date IN jtf_date_table ,
1184: p_created_by IN jtf_number_table ,
1185: p_last_update_date IN jtf_date_table ,
1186: p_last_updated_by IN jtf_number_table ,
1187: p_last_update_login IN jtf_number_table ,
1181: p_qte_line_index IN jtf_number_table ,
1182: p_price_attribute_id IN jtf_number_table ,
1183: p_creation_date IN jtf_date_table ,
1184: p_created_by IN jtf_number_table ,
1185: p_last_update_date IN jtf_date_table ,
1186: p_last_updated_by IN jtf_number_table ,
1187: p_last_update_login IN jtf_number_table ,
1188: p_request_id IN jtf_number_table ,
1189: p_program_application_id IN jtf_number_table ,
1187: p_last_update_login IN jtf_number_table ,
1188: p_request_id IN jtf_number_table ,
1189: p_program_application_id IN jtf_number_table ,
1190: p_program_id IN jtf_number_table ,
1191: p_program_update_date IN jtf_date_table ,
1192: p_quote_header_id IN jtf_number_table ,
1193: p_quote_line_id IN jtf_number_table ,
1194: p_flex_title IN jtf_varchar2_table_100 ,
1195: p_pricing_context IN jtf_varchar2_table_100 ,
1754: FUNCTION Construct_Shipment_Tbl(
1755: p_operation_code IN jtf_varchar2_table_100 ,
1756: p_qte_line_index IN jtf_number_table ,
1757: p_shipment_id IN jtf_number_table ,
1758: p_creation_date IN jtf_date_table ,
1759: p_created_by IN jtf_number_table ,
1760: p_last_update_date IN jtf_date_table ,
1761: p_last_updated_by IN jtf_number_table ,
1762: p_last_update_login IN jtf_number_table ,
1756: p_qte_line_index IN jtf_number_table ,
1757: p_shipment_id IN jtf_number_table ,
1758: p_creation_date IN jtf_date_table ,
1759: p_created_by IN jtf_number_table ,
1760: p_last_update_date IN jtf_date_table ,
1761: p_last_updated_by IN jtf_number_table ,
1762: p_last_update_login IN jtf_number_table ,
1763: p_request_id IN jtf_number_table ,
1764: p_program_application_id IN jtf_number_table ,
1762: p_last_update_login IN jtf_number_table ,
1763: p_request_id IN jtf_number_table ,
1764: p_program_application_id IN jtf_number_table ,
1765: p_program_id IN jtf_number_table ,
1766: p_program_update_date IN jtf_date_table ,
1767: p_quote_header_id IN jtf_number_table ,
1768: p_quote_line_id IN jtf_number_table ,
1769: p_promise_date IN jtf_date_table ,
1770: p_request_date IN jtf_date_table ,
1765: p_program_id IN jtf_number_table ,
1766: p_program_update_date IN jtf_date_table ,
1767: p_quote_header_id IN jtf_number_table ,
1768: p_quote_line_id IN jtf_number_table ,
1769: p_promise_date IN jtf_date_table ,
1770: p_request_date IN jtf_date_table ,
1771: p_schedule_ship_date IN jtf_date_table ,
1772: p_ship_to_party_site_id IN jtf_number_table ,
1773: p_ship_to_party_id IN jtf_number_table ,
1766: p_program_update_date IN jtf_date_table ,
1767: p_quote_header_id IN jtf_number_table ,
1768: p_quote_line_id IN jtf_number_table ,
1769: p_promise_date IN jtf_date_table ,
1770: p_request_date IN jtf_date_table ,
1771: p_schedule_ship_date IN jtf_date_table ,
1772: p_ship_to_party_site_id IN jtf_number_table ,
1773: p_ship_to_party_id IN jtf_number_table ,
1774: p_ship_to_cust_acct_id IN jtf_number_table ,
1767: p_quote_header_id IN jtf_number_table ,
1768: p_quote_line_id IN jtf_number_table ,
1769: p_promise_date IN jtf_date_table ,
1770: p_request_date IN jtf_date_table ,
1771: p_schedule_ship_date IN jtf_date_table ,
1772: p_ship_to_party_site_id IN jtf_number_table ,
1773: p_ship_to_party_id IN jtf_number_table ,
1774: p_ship_to_cust_acct_id IN jtf_number_table ,
1775: p_ship_partial_flag IN jtf_varchar2_table_300 ,
2107: p_tax_detail_id IN jtf_number_table ,
2108: p_quote_header_id IN jtf_number_table ,
2109: p_quote_line_id IN jtf_number_table ,
2110: p_quote_shipment_id IN jtf_number_table ,
2111: p_creation_date IN jtf_date_table ,
2112: p_created_by IN jtf_number_table ,
2113: p_last_update_date IN jtf_date_table ,
2114: p_last_updated_by IN jtf_number_table ,
2115: p_last_update_login IN jtf_number_table ,
2109: p_quote_line_id IN jtf_number_table ,
2110: p_quote_shipment_id IN jtf_number_table ,
2111: p_creation_date IN jtf_date_table ,
2112: p_created_by IN jtf_number_table ,
2113: p_last_update_date IN jtf_date_table ,
2114: p_last_updated_by IN jtf_number_table ,
2115: p_last_update_login IN jtf_number_table ,
2116: p_request_id IN jtf_number_table ,
2117: p_program_application_id IN jtf_number_table ,
2115: p_last_update_login IN jtf_number_table ,
2116: p_request_id IN jtf_number_table ,
2117: p_program_application_id IN jtf_number_table ,
2118: p_program_id IN jtf_number_table ,
2119: p_program_update_date IN jtf_date_table ,
2120: p_orig_tax_code IN jtf_varchar2_table_300 ,
2121: p_tax_code IN jtf_varchar2_table_100 ,
2122: p_tax_rate IN jtf_number_table ,
2123: p_tax_date IN jtf_date_table ,
2119: p_program_update_date IN jtf_date_table ,
2120: p_orig_tax_code IN jtf_varchar2_table_300 ,
2121: p_tax_code IN jtf_varchar2_table_100 ,
2122: p_tax_rate IN jtf_number_table ,
2123: p_tax_date IN jtf_date_table ,
2124: p_tax_amount IN jtf_number_table ,
2125: p_tax_exempt_flag IN jtf_varchar2_table_100 ,
2126: p_tax_exempt_number IN jtf_varchar2_table_100 ,
2127: p_tax_exempt_reason_code IN jtf_varchar2_table_100 ,
2759: END Construct_Qte_Header_Rec;
2760:
2761:
2762: FUNCTION Construct_Qte_Line_Tbl(
2763: p_creation_date IN jtf_date_table ,
2764: p_created_by IN jtf_number_table ,
2765: p_last_updated_by IN jtf_number_table ,
2766: p_last_update_date IN jtf_date_table ,
2767: p_last_update_login IN jtf_number_table ,
2762: FUNCTION Construct_Qte_Line_Tbl(
2763: p_creation_date IN jtf_date_table ,
2764: p_created_by IN jtf_number_table ,
2765: p_last_updated_by IN jtf_number_table ,
2766: p_last_update_date IN jtf_date_table ,
2767: p_last_update_login IN jtf_number_table ,
2768: p_request_id IN jtf_number_table ,
2769: p_program_application_id IN jtf_number_table ,
2770: p_program_id IN jtf_number_table ,
2767: p_last_update_login IN jtf_number_table ,
2768: p_request_id IN jtf_number_table ,
2769: p_program_application_id IN jtf_number_table ,
2770: p_program_id IN jtf_number_table ,
2771: p_program_update_date IN jtf_date_table ,
2772: p_quote_line_id IN jtf_number_table ,
2773: p_quote_header_id IN jtf_number_table ,
2774: p_org_id IN jtf_number_table ,
2775: p_line_number IN jtf_number_table ,
2778: p_inventory_item_id IN jtf_number_table ,
2779: p_organization_id IN jtf_number_table ,
2780: p_quantity IN jtf_number_table ,
2781: p_uom_code IN jtf_varchar2_table_100 ,
2782: p_start_date_active IN jtf_date_table ,
2783: p_end_date_active IN jtf_date_table ,
2784: p_order_line_type_id IN jtf_number_table ,
2785: p_price_list_id IN jtf_number_table ,
2786: p_price_list_line_id IN jtf_number_table ,
2779: p_organization_id IN jtf_number_table ,
2780: p_quantity IN jtf_number_table ,
2781: p_uom_code IN jtf_varchar2_table_100 ,
2782: p_start_date_active IN jtf_date_table ,
2783: p_end_date_active IN jtf_date_table ,
2784: p_order_line_type_id IN jtf_number_table ,
2785: p_price_list_id IN jtf_number_table ,
2786: p_price_list_line_id IN jtf_number_table ,
2787: p_currency_code IN jtf_varchar2_table_100 ,
3147:
3148:
3149: FUNCTION Construct_Qte_Line_Dtl_Tbl(
3150: p_quote_line_detail_id IN jtf_number_table ,
3151: p_creation_date IN jtf_date_table ,
3152: p_created_by IN jtf_number_table ,
3153: p_last_update_date IN jtf_date_table ,
3154: p_last_updated_by IN jtf_number_table ,
3155: p_last_update_login IN jtf_number_table ,
3149: FUNCTION Construct_Qte_Line_Dtl_Tbl(
3150: p_quote_line_detail_id IN jtf_number_table ,
3151: p_creation_date IN jtf_date_table ,
3152: p_created_by IN jtf_number_table ,
3153: p_last_update_date IN jtf_date_table ,
3154: p_last_updated_by IN jtf_number_table ,
3155: p_last_update_login IN jtf_number_table ,
3156: p_request_id IN jtf_number_table ,
3157: p_program_application_id IN jtf_number_table ,
3155: p_last_update_login IN jtf_number_table ,
3156: p_request_id IN jtf_number_table ,
3157: p_program_application_id IN jtf_number_table ,
3158: p_program_id IN jtf_number_table ,
3159: p_program_update_date IN jtf_date_table ,
3160: p_quote_line_id IN jtf_number_table ,
3161: p_config_header_id IN jtf_number_table ,
3162: p_config_revision_num IN jtf_number_table ,
3163: p_config_item_id IN jtf_number_table ,
3424:
3425:
3426: FUNCTION Construct_Line_Rltship_Tbl(
3427: p_line_relationship_id IN jtf_number_table ,
3428: p_creation_date IN jtf_date_table ,
3429: p_created_by IN jtf_number_table ,
3430: p_last_updated_by IN jtf_number_table ,
3431: p_last_update_date IN jtf_date_table ,
3432: p_last_update_login IN jtf_number_table ,
3427: p_line_relationship_id IN jtf_number_table ,
3428: p_creation_date IN jtf_date_table ,
3429: p_created_by IN jtf_number_table ,
3430: p_last_updated_by IN jtf_number_table ,
3431: p_last_update_date IN jtf_date_table ,
3432: p_last_update_login IN jtf_number_table ,
3433: p_request_id IN jtf_number_table ,
3434: p_program_application_id IN jtf_number_table ,
3435: p_program_id IN jtf_number_table ,
3432: p_last_update_login IN jtf_number_table ,
3433: p_request_id IN jtf_number_table ,
3434: p_program_application_id IN jtf_number_table ,
3435: p_program_id IN jtf_number_table ,
3436: p_program_update_date IN jtf_date_table ,
3437: p_quote_line_id IN jtf_number_table ,
3438: p_related_quote_line_id IN jtf_number_table ,
3439: p_relationship_type_code IN jtf_varchar2_table_100 ,
3440: p_reciprocal_flag IN jtf_varchar2_table_100 ,
3666: p_q_end_cust_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
3667: p_q_end_cust_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
3668: p_q_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
3669: p_q_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
3670: p_ql_creation_date IN jtf_date_table := NULL,
3671: p_ql_created_by IN jtf_number_table := NULL,
3672: p_ql_last_updated_by IN jtf_number_table := NULL,
3673: p_ql_last_update_date IN jtf_date_table := NULL,
3674: p_ql_last_update_login IN jtf_number_table := NULL,
3669: p_q_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
3670: p_ql_creation_date IN jtf_date_table := NULL,
3671: p_ql_created_by IN jtf_number_table := NULL,
3672: p_ql_last_updated_by IN jtf_number_table := NULL,
3673: p_ql_last_update_date IN jtf_date_table := NULL,
3674: p_ql_last_update_login IN jtf_number_table := NULL,
3675: p_ql_request_id IN jtf_number_table := NULL,
3676: p_ql_program_application_id IN jtf_number_table := NULL,
3677: p_ql_program_id IN jtf_number_table := NULL,
3674: p_ql_last_update_login IN jtf_number_table := NULL,
3675: p_ql_request_id IN jtf_number_table := NULL,
3676: p_ql_program_application_id IN jtf_number_table := NULL,
3677: p_ql_program_id IN jtf_number_table := NULL,
3678: p_ql_program_update_date IN jtf_date_table := NULL,
3679: p_ql_quote_line_id IN jtf_number_table := NULL,
3680: p_ql_quote_header_id IN jtf_number_table := NULL,
3681: p_ql_org_id IN jtf_number_table := NULL,
3682: p_ql_line_number IN jtf_number_table := NULL,
3685: p_ql_inventory_item_id IN jtf_number_table := NULL,
3686: p_ql_organization_id IN jtf_number_table := NULL,
3687: p_ql_quantity IN jtf_number_table := NULL,
3688: p_ql_uom_code IN jtf_varchar2_table_100 := NULL,
3689: p_ql_start_date_active IN jtf_date_table := NULL,
3690: p_ql_end_date_active IN jtf_date_table := NULL,
3691: p_ql_order_line_type_id IN jtf_number_table := NULL,
3692: p_ql_price_list_id IN jtf_number_table := NULL,
3693: p_ql_price_list_line_id IN jtf_number_table := NULL,
3686: p_ql_organization_id IN jtf_number_table := NULL,
3687: p_ql_quantity IN jtf_number_table := NULL,
3688: p_ql_uom_code IN jtf_varchar2_table_100 := NULL,
3689: p_ql_start_date_active IN jtf_date_table := NULL,
3690: p_ql_end_date_active IN jtf_date_table := NULL,
3691: p_ql_order_line_type_id IN jtf_number_table := NULL,
3692: p_ql_price_list_id IN jtf_number_table := NULL,
3693: p_ql_price_list_line_id IN jtf_number_table := NULL,
3694: p_ql_currency_code IN jtf_varchar2_table_100 := NULL,
3740: p_ql_end_cust_cust_party_id IN jtf_number_table := NULL,
3741: p_ql_end_cust_party_site_id IN jtf_number_table := NULL,
3742: p_ql_end_cust_cust_account_id IN jtf_number_table := NULL,
3743: p_qrl_line_relationship_id IN jtf_number_table := NULL,
3744: p_qrl_creation_date IN jtf_date_table := NULL,
3745: p_qrl_created_by IN jtf_number_table := NULL,
3746: p_qrl_last_updated_by IN jtf_number_table := NULL,
3747: p_qrl_last_update_date IN jtf_date_table := NULL,
3748: p_qrl_last_update_login IN jtf_number_table := NULL,
3743: p_qrl_line_relationship_id IN jtf_number_table := NULL,
3744: p_qrl_creation_date IN jtf_date_table := NULL,
3745: p_qrl_created_by IN jtf_number_table := NULL,
3746: p_qrl_last_updated_by IN jtf_number_table := NULL,
3747: p_qrl_last_update_date IN jtf_date_table := NULL,
3748: p_qrl_last_update_login IN jtf_number_table := NULL,
3749: p_qrl_request_id IN jtf_number_table := NULL,
3750: p_qrl_program_application_id IN jtf_number_table := NULL,
3751: p_qrl_program_id IN jtf_number_table := NULL,
3748: p_qrl_last_update_login IN jtf_number_table := NULL,
3749: p_qrl_request_id IN jtf_number_table := NULL,
3750: p_qrl_program_application_id IN jtf_number_table := NULL,
3751: p_qrl_program_id IN jtf_number_table := NULL,
3752: p_qrl_program_update_date IN jtf_date_table := NULL,
3753: p_qrl_quote_line_id IN jtf_number_table := NULL,
3754: p_qrl_related_quote_line_id IN jtf_number_table := NULL,
3755: p_qrl_relationship_type_code IN jtf_varchar2_table_100 := NULL,
3756: p_qrl_reciprocal_flag IN jtf_varchar2_table_100 := NULL,
3757: p_qrl_qte_line_index IN jtf_number_table := NULL,
3758: p_qrl_related_qte_line_index IN jtf_number_table := NULL,
3759: p_qrl_operation_code IN JTF_VARCHAR2_TABLE_100 := null,
3760: p_qdl_quote_line_detail_id IN jtf_number_table := NULL,
3761: p_qdl_creation_date IN jtf_date_table := NULL,
3762: p_qdl_created_by IN jtf_number_table := NULL,
3763: p_qdl_last_update_date IN jtf_date_table := NULL,
3764: p_qdl_last_updated_by IN jtf_number_table := NULL,
3765: p_qdl_last_update_login IN jtf_number_table := NULL,
3759: p_qrl_operation_code IN JTF_VARCHAR2_TABLE_100 := null,
3760: p_qdl_quote_line_detail_id IN jtf_number_table := NULL,
3761: p_qdl_creation_date IN jtf_date_table := NULL,
3762: p_qdl_created_by IN jtf_number_table := NULL,
3763: p_qdl_last_update_date IN jtf_date_table := NULL,
3764: p_qdl_last_updated_by IN jtf_number_table := NULL,
3765: p_qdl_last_update_login IN jtf_number_table := NULL,
3766: p_qdl_request_id IN jtf_number_table := NULL,
3767: p_qdl_program_application_id IN jtf_number_table := NULL,
3765: p_qdl_last_update_login IN jtf_number_table := NULL,
3766: p_qdl_request_id IN jtf_number_table := NULL,
3767: p_qdl_program_application_id IN jtf_number_table := NULL,
3768: p_qdl_program_id IN jtf_number_table := NULL,
3769: p_qdl_program_update_date IN jtf_date_table := NULL,
3770: p_qdl_quote_line_id IN jtf_number_table := NULL,
3771: p_qdl_config_header_id IN jtf_number_table := NULL,
3772: p_qdl_config_revision_num IN jtf_number_table := NULL,
3773: p_qdl_config_item_id IN jtf_number_table := NULL,
3829: p_qdl_return_reason_code IN jtf_varchar2_table_100 := NULL,
3830: p_qpa_operation_code IN jtf_varchar2_table_100 := NULL,
3831: p_qpa_qte_line_index IN jtf_number_table := NULL,
3832: p_qpa_price_attribute_id IN jtf_number_table := NULL,
3833: p_qpa_creation_date IN jtf_date_table := NULL,
3834: p_qpa_created_by IN jtf_number_table := NULL,
3835: p_qpa_last_update_date IN jtf_date_table := NULL,
3836: p_qpa_last_updated_by IN jtf_number_table := NULL,
3837: p_qpa_last_update_login IN jtf_number_table := NULL,
3831: p_qpa_qte_line_index IN jtf_number_table := NULL,
3832: p_qpa_price_attribute_id IN jtf_number_table := NULL,
3833: p_qpa_creation_date IN jtf_date_table := NULL,
3834: p_qpa_created_by IN jtf_number_table := NULL,
3835: p_qpa_last_update_date IN jtf_date_table := NULL,
3836: p_qpa_last_updated_by IN jtf_number_table := NULL,
3837: p_qpa_last_update_login IN jtf_number_table := NULL,
3838: p_qpa_request_id IN jtf_number_table := NULL,
3839: p_qpa_program_application_id IN jtf_number_table := NULL,
3837: p_qpa_last_update_login IN jtf_number_table := NULL,
3838: p_qpa_request_id IN jtf_number_table := NULL,
3839: p_qpa_program_application_id IN jtf_number_table := NULL,
3840: p_qpa_program_id IN jtf_number_table := NULL,
3841: p_qpa_program_update_date IN jtf_date_table := NULL,
3842: p_qpa_quote_header_id IN jtf_number_table := NULL,
3843: p_qpa_quote_line_id IN jtf_number_table := NULL,
3844: p_qpa_flex_title IN jtf_varchar2_table_100 := NULL,
3845: p_qpa_pricing_context IN jtf_varchar2_table_100 := NULL,
3961: p_qpa_attribute15 IN jtf_varchar2_table_300 := NULL,
3962: p_qp_operation_code IN jtf_varchar2_table_100 := NULL,
3963: p_qp_qte_line_index IN jtf_number_table := NULL,
3964: p_qp_payment_id IN jtf_number_table := NULL,
3965: p_qp_creation_date IN jtf_date_table := NULL,
3966: p_qp_created_by IN jtf_number_table := NULL,
3967: p_qp_last_update_date IN jtf_date_table := NULL,
3968: p_qp_last_updated_by IN jtf_number_table := NULL,
3969: p_qp_last_update_login IN jtf_number_table := NULL,
3963: p_qp_qte_line_index IN jtf_number_table := NULL,
3964: p_qp_payment_id IN jtf_number_table := NULL,
3965: p_qp_creation_date IN jtf_date_table := NULL,
3966: p_qp_created_by IN jtf_number_table := NULL,
3967: p_qp_last_update_date IN jtf_date_table := NULL,
3968: p_qp_last_updated_by IN jtf_number_table := NULL,
3969: p_qp_last_update_login IN jtf_number_table := NULL,
3970: p_qp_request_id IN jtf_number_table := NULL,
3971: p_qp_program_application_id IN jtf_number_table := NULL,
3969: p_qp_last_update_login IN jtf_number_table := NULL,
3970: p_qp_request_id IN jtf_number_table := NULL,
3971: p_qp_program_application_id IN jtf_number_table := NULL,
3972: p_qp_program_id IN jtf_number_table := NULL,
3973: p_qp_program_update_date IN jtf_date_table := NULL,
3974: p_qp_quote_header_id IN jtf_number_table := NULL,
3975: p_qp_quote_line_id IN jtf_number_table := NULL,
3976: p_qp_payment_type_code IN jtf_varchar2_table_100 := NULL,
3977: p_qp_payment_ref_number IN jtf_varchar2_table_300 := NULL,
3978: p_qp_payment_option IN jtf_varchar2_table_300 := NULL,
3979: p_qp_payment_term_id IN jtf_number_table := NULL,
3980: p_qp_credit_card_code IN jtf_varchar2_table_100 := NULL,
3981: p_qp_credit_card_holder_name IN jtf_varchar2_table_100 := NULL,
3982: p_qp_credit_card_exp_date IN jtf_date_table := NULL,
3983: p_qp_credit_card_approval_code IN jtf_varchar2_table_100 := NULL,
3984: p_qp_credit_card_approval_date IN jtf_date_table := NULL,
3985: p_qp_payment_amount IN jtf_number_table := NULL,
3986: p_qp_cust_po_number IN jtf_varchar2_table_100 := NULL,
3980: p_qp_credit_card_code IN jtf_varchar2_table_100 := NULL,
3981: p_qp_credit_card_holder_name IN jtf_varchar2_table_100 := NULL,
3982: p_qp_credit_card_exp_date IN jtf_date_table := NULL,
3983: p_qp_credit_card_approval_code IN jtf_varchar2_table_100 := NULL,
3984: p_qp_credit_card_approval_date IN jtf_date_table := NULL,
3985: p_qp_payment_amount IN jtf_number_table := NULL,
3986: p_qp_cust_po_number IN jtf_varchar2_table_100 := NULL,
3987: p_qp_attribute_category IN jtf_varchar2_table_100 := NULL,
3988: p_qp_attribute1 IN jtf_varchar2_table_200 := NULL,
4004: p_qp_cvv2 IN jtf_varchar2_table_200 := NULL,
4005: p_qs_operation_code IN jtf_varchar2_table_100 := NULL,
4006: p_qs_qte_line_index IN jtf_number_table := NULL,
4007: p_qs_shipment_id IN jtf_number_table := NULL,
4008: p_qs_creation_date IN jtf_date_table := NULL,
4009: p_qs_created_by IN jtf_number_table := NULL,
4010: p_qs_last_update_date IN jtf_date_table := NULL,
4011: p_qs_last_updated_by IN jtf_number_table := NULL,
4012: p_qs_last_update_login IN jtf_number_table := NULL,
4006: p_qs_qte_line_index IN jtf_number_table := NULL,
4007: p_qs_shipment_id IN jtf_number_table := NULL,
4008: p_qs_creation_date IN jtf_date_table := NULL,
4009: p_qs_created_by IN jtf_number_table := NULL,
4010: p_qs_last_update_date IN jtf_date_table := NULL,
4011: p_qs_last_updated_by IN jtf_number_table := NULL,
4012: p_qs_last_update_login IN jtf_number_table := NULL,
4013: p_qs_request_id IN jtf_number_table := NULL,
4014: p_qs_program_application_id IN jtf_number_table := NULL,
4012: p_qs_last_update_login IN jtf_number_table := NULL,
4013: p_qs_request_id IN jtf_number_table := NULL,
4014: p_qs_program_application_id IN jtf_number_table := NULL,
4015: p_qs_program_id IN jtf_number_table := NULL,
4016: p_qs_program_update_date IN jtf_date_table := NULL,
4017: p_qs_quote_header_id IN jtf_number_table := NULL,
4018: p_qs_quote_line_id IN jtf_number_table := NULL,
4019: p_qs_promise_date IN jtf_date_table := NULL,
4020: p_qs_request_date IN jtf_date_table := NULL,
4015: p_qs_program_id IN jtf_number_table := NULL,
4016: p_qs_program_update_date IN jtf_date_table := NULL,
4017: p_qs_quote_header_id IN jtf_number_table := NULL,
4018: p_qs_quote_line_id IN jtf_number_table := NULL,
4019: p_qs_promise_date IN jtf_date_table := NULL,
4020: p_qs_request_date IN jtf_date_table := NULL,
4021: p_qs_schedule_ship_date IN jtf_date_table := NULL,
4022: p_qs_ship_to_party_site_id IN jtf_number_table := NULL,
4023: p_qs_ship_to_party_id IN jtf_number_table := NULL,
4016: p_qs_program_update_date IN jtf_date_table := NULL,
4017: p_qs_quote_header_id IN jtf_number_table := NULL,
4018: p_qs_quote_line_id IN jtf_number_table := NULL,
4019: p_qs_promise_date IN jtf_date_table := NULL,
4020: p_qs_request_date IN jtf_date_table := NULL,
4021: p_qs_schedule_ship_date IN jtf_date_table := NULL,
4022: p_qs_ship_to_party_site_id IN jtf_number_table := NULL,
4023: p_qs_ship_to_party_id IN jtf_number_table := NULL,
4024: p_qs_ship_to_cust_acct_id IN jtf_number_table := NULL,
4017: p_qs_quote_header_id IN jtf_number_table := NULL,
4018: p_qs_quote_line_id IN jtf_number_table := NULL,
4019: p_qs_promise_date IN jtf_date_table := NULL,
4020: p_qs_request_date IN jtf_date_table := NULL,
4021: p_qs_schedule_ship_date IN jtf_date_table := NULL,
4022: p_qs_ship_to_party_site_id IN jtf_number_table := NULL,
4023: p_qs_ship_to_party_id IN jtf_number_table := NULL,
4024: p_qs_ship_to_cust_acct_id IN jtf_number_table := NULL,
4025: p_qs_ship_partial_flag IN jtf_varchar2_table_300 := NULL,
4072: p_qt_tax_detail_id IN jtf_number_table := NULL,
4073: p_qt_quote_header_id IN jtf_number_table := NULL,
4074: p_qt_quote_line_id IN jtf_number_table := NULL,
4075: p_qt_quote_shipment_id IN jtf_number_table := NULL,
4076: p_qt_creation_date IN jtf_date_table := NULL,
4077: p_qt_created_by IN jtf_number_table := NULL,
4078: p_qt_last_update_date IN jtf_date_table := NULL,
4079: p_qt_last_updated_by IN jtf_number_table := NULL,
4080: p_qt_last_update_login IN jtf_number_table := NULL,
4074: p_qt_quote_line_id IN jtf_number_table := NULL,
4075: p_qt_quote_shipment_id IN jtf_number_table := NULL,
4076: p_qt_creation_date IN jtf_date_table := NULL,
4077: p_qt_created_by IN jtf_number_table := NULL,
4078: p_qt_last_update_date IN jtf_date_table := NULL,
4079: p_qt_last_updated_by IN jtf_number_table := NULL,
4080: p_qt_last_update_login IN jtf_number_table := NULL,
4081: p_qt_request_id IN jtf_number_table := NULL,
4082: p_qt_program_application_id IN jtf_number_table := NULL,
4080: p_qt_last_update_login IN jtf_number_table := NULL,
4081: p_qt_request_id IN jtf_number_table := NULL,
4082: p_qt_program_application_id IN jtf_number_table := NULL,
4083: p_qt_program_id IN jtf_number_table := NULL,
4084: p_qt_program_update_date IN jtf_date_table := NULL,
4085: p_qt_orig_tax_code IN jtf_varchar2_table_300 := NULL,
4086: p_qt_tax_code IN jtf_varchar2_table_100 := NULL,
4087: p_qt_tax_rate IN jtf_number_table := NULL,
4088: p_qt_tax_date IN jtf_date_table := NULL,
4084: p_qt_program_update_date IN jtf_date_table := NULL,
4085: p_qt_orig_tax_code IN jtf_varchar2_table_300 := NULL,
4086: p_qt_tax_code IN jtf_varchar2_table_100 := NULL,
4087: p_qt_tax_rate IN jtf_number_table := NULL,
4088: p_qt_tax_date IN jtf_date_table := NULL,
4089: p_qt_tax_amount IN jtf_number_table := NULL,
4090: p_qt_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,
4091: p_qt_tax_exempt_number IN jtf_varchar2_table_100 := NULL,
4092: p_qt_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,
4108: p_qt_attribute15 IN jtf_varchar2_table_200 := NULL,
4109: p_qlpa_operation_code IN jtf_varchar2_table_100 := NULL,
4110: p_qlpa_qte_line_index IN jtf_number_table := NULL,
4111: p_qlpa_price_attribute_id IN jtf_number_table := NULL,
4112: p_qlpa_creation_date IN jtf_date_table := NULL,
4113: p_qlpa_created_by IN jtf_number_table := NULL,
4114: p_qlpa_last_update_date IN jtf_date_table := NULL,
4115: p_qlpa_last_updated_by IN jtf_number_table := NULL,
4116: p_qlpa_last_update_login IN jtf_number_table := NULL,
4110: p_qlpa_qte_line_index IN jtf_number_table := NULL,
4111: p_qlpa_price_attribute_id IN jtf_number_table := NULL,
4112: p_qlpa_creation_date IN jtf_date_table := NULL,
4113: p_qlpa_created_by IN jtf_number_table := NULL,
4114: p_qlpa_last_update_date IN jtf_date_table := NULL,
4115: p_qlpa_last_updated_by IN jtf_number_table := NULL,
4116: p_qlpa_last_update_login IN jtf_number_table := NULL,
4117: p_qlpa_request_id IN jtf_number_table := NULL,
4118: p_qlpa_program_application_id IN jtf_number_table := NULL,
4116: p_qlpa_last_update_login IN jtf_number_table := NULL,
4117: p_qlpa_request_id IN jtf_number_table := NULL,
4118: p_qlpa_program_application_id IN jtf_number_table := NULL,
4119: p_qlpa_program_id IN jtf_number_table := NULL,
4120: p_qlpa_program_update_date IN jtf_date_table := NULL,
4121: p_qlpa_quote_header_id IN jtf_number_table := NULL,
4122: p_qlpa_quote_line_id IN jtf_number_table := NULL,
4123: p_qlpa_flex_title IN jtf_varchar2_table_100 := NULL,
4124: p_qlpa_pricing_context IN jtf_varchar2_table_100 := NULL,
4240: p_qlpa_attribute15 IN jtf_varchar2_table_300 := NULL,
4241: p_qlp_operation_code IN jtf_varchar2_table_100 := NULL,
4242: p_qlp_qte_line_index IN jtf_number_table := NULL,
4243: p_qlp_payment_id IN jtf_number_table := NULL,
4244: p_qlp_creation_date IN jtf_date_table := NULL,
4245: p_qlp_created_by IN jtf_number_table := NULL,
4246: p_qlp_last_update_date IN jtf_date_table := NULL,
4247: p_qlp_last_updated_by IN jtf_number_table := NULL,
4248: p_qlp_last_update_login IN jtf_number_table := NULL,
4242: p_qlp_qte_line_index IN jtf_number_table := NULL,
4243: p_qlp_payment_id IN jtf_number_table := NULL,
4244: p_qlp_creation_date IN jtf_date_table := NULL,
4245: p_qlp_created_by IN jtf_number_table := NULL,
4246: p_qlp_last_update_date IN jtf_date_table := NULL,
4247: p_qlp_last_updated_by IN jtf_number_table := NULL,
4248: p_qlp_last_update_login IN jtf_number_table := NULL,
4249: p_qlp_request_id IN jtf_number_table := NULL,
4250: p_qlp_program_application_id IN jtf_number_table := NULL,
4248: p_qlp_last_update_login IN jtf_number_table := NULL,
4249: p_qlp_request_id IN jtf_number_table := NULL,
4250: p_qlp_program_application_id IN jtf_number_table := NULL,
4251: p_qlp_program_id IN jtf_number_table := NULL,
4252: p_qlp_program_update_date IN jtf_date_table := NULL,
4253: p_qlp_quote_header_id IN jtf_number_table := NULL,
4254: p_qlp_quote_line_id IN jtf_number_table := NULL,
4255: p_qlp_payment_type_code IN jtf_varchar2_table_100 := NULL,
4256: p_qlp_payment_ref_number IN jtf_varchar2_table_300 := NULL,
4257: p_qlp_payment_option IN jtf_varchar2_table_300 := NULL,
4258: p_qlp_payment_term_id IN jtf_number_table := NULL,
4259: p_qlp_credit_card_code IN jtf_varchar2_table_100 := NULL,
4260: p_qlp_credit_card_holder_name IN jtf_varchar2_table_100 := NULL,
4261: p_qlp_credit_card_exp_date IN jtf_date_table := NULL,
4262: p_qlp_credit_card_aprv_code IN jtf_varchar2_table_100 := NULL,
4263: p_qlp_credit_card_aprv_date IN jtf_date_table := NULL,
4264: p_qlp_payment_amount IN jtf_number_table := NULL,
4265: p_qlp_cust_po_number IN jtf_varchar2_table_100 := NULL,
4259: p_qlp_credit_card_code IN jtf_varchar2_table_100 := NULL,
4260: p_qlp_credit_card_holder_name IN jtf_varchar2_table_100 := NULL,
4261: p_qlp_credit_card_exp_date IN jtf_date_table := NULL,
4262: p_qlp_credit_card_aprv_code IN jtf_varchar2_table_100 := NULL,
4263: p_qlp_credit_card_aprv_date IN jtf_date_table := NULL,
4264: p_qlp_payment_amount IN jtf_number_table := NULL,
4265: p_qlp_cust_po_number IN jtf_varchar2_table_100 := NULL,
4266: p_qlp_attribute_category IN jtf_varchar2_table_100 := NULL,
4267: p_qlp_attribute1 IN jtf_varchar2_table_200 := NULL,
4281: p_qlp_attribute15 IN jtf_varchar2_table_200 := NULL,
4282: p_qls_operation_code IN jtf_varchar2_table_100 := NULL,
4283: p_qls_qte_line_index IN jtf_number_table := NULL,
4284: p_qls_shipment_id IN jtf_number_table := NULL,
4285: p_qls_creation_date IN jtf_date_table := NULL,
4286: p_qls_created_by IN jtf_number_table := NULL,
4287: p_qls_last_update_date IN jtf_date_table := NULL,
4288: p_qls_last_updated_by IN jtf_number_table := NULL,
4289: p_qls_last_update_login IN jtf_number_table := NULL,
4283: p_qls_qte_line_index IN jtf_number_table := NULL,
4284: p_qls_shipment_id IN jtf_number_table := NULL,
4285: p_qls_creation_date IN jtf_date_table := NULL,
4286: p_qls_created_by IN jtf_number_table := NULL,
4287: p_qls_last_update_date IN jtf_date_table := NULL,
4288: p_qls_last_updated_by IN jtf_number_table := NULL,
4289: p_qls_last_update_login IN jtf_number_table := NULL,
4290: p_qls_request_id IN jtf_number_table := NULL,
4291: p_qls_program_application_id IN jtf_number_table := NULL,
4289: p_qls_last_update_login IN jtf_number_table := NULL,
4290: p_qls_request_id IN jtf_number_table := NULL,
4291: p_qls_program_application_id IN jtf_number_table := NULL,
4292: p_qls_program_id IN jtf_number_table := NULL,
4293: p_qls_program_update_date IN jtf_date_table := NULL,
4294: p_qls_quote_header_id IN jtf_number_table := NULL,
4295: p_qls_quote_line_id IN jtf_number_table := NULL,
4296: p_qls_promise_date IN jtf_date_table := NULL,
4297: p_qls_request_date IN jtf_date_table := NULL,
4292: p_qls_program_id IN jtf_number_table := NULL,
4293: p_qls_program_update_date IN jtf_date_table := NULL,
4294: p_qls_quote_header_id IN jtf_number_table := NULL,
4295: p_qls_quote_line_id IN jtf_number_table := NULL,
4296: p_qls_promise_date IN jtf_date_table := NULL,
4297: p_qls_request_date IN jtf_date_table := NULL,
4298: p_qls_schedule_ship_date IN jtf_date_table := NULL,
4299: p_qls_ship_to_party_site_id IN jtf_number_table := NULL,
4300: p_qls_ship_to_party_id IN jtf_number_table := NULL,
4293: p_qls_program_update_date IN jtf_date_table := NULL,
4294: p_qls_quote_header_id IN jtf_number_table := NULL,
4295: p_qls_quote_line_id IN jtf_number_table := NULL,
4296: p_qls_promise_date IN jtf_date_table := NULL,
4297: p_qls_request_date IN jtf_date_table := NULL,
4298: p_qls_schedule_ship_date IN jtf_date_table := NULL,
4299: p_qls_ship_to_party_site_id IN jtf_number_table := NULL,
4300: p_qls_ship_to_party_id IN jtf_number_table := NULL,
4301: p_qls_ship_to_cust_acct_id IN jtf_number_table := NULL,
4294: p_qls_quote_header_id IN jtf_number_table := NULL,
4295: p_qls_quote_line_id IN jtf_number_table := NULL,
4296: p_qls_promise_date IN jtf_date_table := NULL,
4297: p_qls_request_date IN jtf_date_table := NULL,
4298: p_qls_schedule_ship_date IN jtf_date_table := NULL,
4299: p_qls_ship_to_party_site_id IN jtf_number_table := NULL,
4300: p_qls_ship_to_party_id IN jtf_number_table := NULL,
4301: p_qls_ship_to_cust_acct_id IN jtf_number_table := NULL,
4302: p_qls_ship_partial_flag IN jtf_varchar2_table_300 := NULL,
4349: p_qlt_tax_detail_id IN jtf_number_table := NULL,
4350: p_qlt_quote_header_id IN jtf_number_table := NULL,
4351: p_qlt_quote_line_id IN jtf_number_table := NULL,
4352: p_qlt_quote_shipment_id IN jtf_number_table := NULL,
4353: p_qlt_creation_date IN jtf_date_table := NULL,
4354: p_qlt_created_by IN jtf_number_table := NULL,
4355: p_qlt_last_update_date IN jtf_date_table := NULL,
4356: p_qlt_last_updated_by IN jtf_number_table := NULL,
4357: p_qlt_last_update_login IN jtf_number_table := NULL,
4351: p_qlt_quote_line_id IN jtf_number_table := NULL,
4352: p_qlt_quote_shipment_id IN jtf_number_table := NULL,
4353: p_qlt_creation_date IN jtf_date_table := NULL,
4354: p_qlt_created_by IN jtf_number_table := NULL,
4355: p_qlt_last_update_date IN jtf_date_table := NULL,
4356: p_qlt_last_updated_by IN jtf_number_table := NULL,
4357: p_qlt_last_update_login IN jtf_number_table := NULL,
4358: p_qlt_request_id IN jtf_number_table := NULL,
4359: p_qlt_program_application_id IN jtf_number_table := NULL,
4357: p_qlt_last_update_login IN jtf_number_table := NULL,
4358: p_qlt_request_id IN jtf_number_table := NULL,
4359: p_qlt_program_application_id IN jtf_number_table := NULL,
4360: p_qlt_program_id IN jtf_number_table := NULL,
4361: p_qlt_program_update_date IN jtf_date_table := NULL,
4362: p_qlt_orig_tax_code IN jtf_varchar2_table_300 := NULL,
4363: p_qlt_tax_code IN jtf_varchar2_table_100 := NULL,
4364: p_qlt_tax_rate IN jtf_number_table := NULL,
4365: p_qlt_tax_date IN jtf_date_table := NULL,
4361: p_qlt_program_update_date IN jtf_date_table := NULL,
4362: p_qlt_orig_tax_code IN jtf_varchar2_table_300 := NULL,
4363: p_qlt_tax_code IN jtf_varchar2_table_100 := NULL,
4364: p_qlt_tax_rate IN jtf_number_table := NULL,
4365: p_qlt_tax_date IN jtf_date_table := NULL,
4366: p_qlt_tax_amount IN jtf_number_table := NULL,
4367: p_qlt_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,
4368: p_qlt_tax_exempt_number IN jtf_varchar2_table_100 := NULL,
4369: p_qlt_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,
4386: p_qlpaa_operation_code IN jtf_varchar2_table_100 := NULL,
4387: p_qlpaa_qte_line_index IN jtf_number_table := NULL,
4388: p_qlpaa_price_adj_index IN jtf_number_table := NULL,
4389: p_qlpaa_price_adj_attrib_id IN jtf_number_table := NULL,
4390: p_qlpaa_creation_date IN jtf_date_table := NULL,
4391: p_qlpaa_created_by IN jtf_number_table := NULL,
4392: p_qlpaa_last_update_date IN jtf_date_table := NULL,
4393: p_qlpaa_last_updated_by IN jtf_number_table := NULL,
4394: p_qlpaa_last_update_login IN jtf_number_table := NULL,
4388: p_qlpaa_price_adj_index IN jtf_number_table := NULL,
4389: p_qlpaa_price_adj_attrib_id IN jtf_number_table := NULL,
4390: p_qlpaa_creation_date IN jtf_date_table := NULL,
4391: p_qlpaa_created_by IN jtf_number_table := NULL,
4392: p_qlpaa_last_update_date IN jtf_date_table := NULL,
4393: p_qlpaa_last_updated_by IN jtf_number_table := NULL,
4394: p_qlpaa_last_update_login IN jtf_number_table := NULL,
4395: p_qlpaa_program_application_id IN jtf_number_table := NULL,
4396: p_qlpaa_program_id IN jtf_number_table := NULL,
4393: p_qlpaa_last_updated_by IN jtf_number_table := NULL,
4394: p_qlpaa_last_update_login IN jtf_number_table := NULL,
4395: p_qlpaa_program_application_id IN jtf_number_table := NULL,
4396: p_qlpaa_program_id IN jtf_number_table := NULL,
4397: p_qlpaa_program_update_date IN jtf_date_table := NULL,
4398: p_qlpaa_request_id IN jtf_number_table := NULL,
4399: p_qlpaa_price_adjustment_id IN jtf_number_table := NULL,
4400: p_qlpaa_pricing_context IN jtf_varchar2_table_100 := NULL,
4401: p_qlpaa_pricing_attribute IN jtf_varchar2_table_100 := NULL,
4405: p_qlpaa_flex_title IN jtf_varchar2_table_100 := NULL,
4406: p_qlpaj_operation_code IN jtf_varchar2_table_100 := NULL,
4407: p_qlpaj_qte_line_index IN jtf_number_table := NULL,
4408: p_qlpaj_price_adjustment_id IN jtf_number_table := NULL,
4409: p_qlpaj_creation_date IN jtf_date_table := NULL,
4410: p_qlpaj_created_by IN jtf_number_table := NULL,
4411: p_qlpaj_last_update_date IN jtf_date_table := NULL,
4412: p_qlpaj_last_updated_by IN jtf_number_table := NULL,
4413: p_qlpaj_last_update_login IN jtf_number_table := NULL,
4407: p_qlpaj_qte_line_index IN jtf_number_table := NULL,
4408: p_qlpaj_price_adjustment_id IN jtf_number_table := NULL,
4409: p_qlpaj_creation_date IN jtf_date_table := NULL,
4410: p_qlpaj_created_by IN jtf_number_table := NULL,
4411: p_qlpaj_last_update_date IN jtf_date_table := NULL,
4412: p_qlpaj_last_updated_by IN jtf_number_table := NULL,
4413: p_qlpaj_last_update_login IN jtf_number_table := NULL,
4414: p_qlpaj_program_application_id IN jtf_number_table := NULL,
4415: p_qlpaj_program_id IN jtf_number_table := NULL,
4412: p_qlpaj_last_updated_by IN jtf_number_table := NULL,
4413: p_qlpaj_last_update_login IN jtf_number_table := NULL,
4414: p_qlpaj_program_application_id IN jtf_number_table := NULL,
4415: p_qlpaj_program_id IN jtf_number_table := NULL,
4416: p_qlpaj_program_update_date IN jtf_date_table := NULL,
4417: p_qlpaj_request_id IN jtf_number_table := NULL,
4418: p_qlpaj_quote_header_id IN jtf_number_table := NULL,
4419: p_qlpaj_quote_line_id IN jtf_number_table := NULL,
4420: p_qlpaj_modifier_header_id IN jtf_number_table := NULL,
4473: p_qlpaj_source_system_code IN jtf_varchar2_table_100 := NULL,
4474: p_qlpaj_benefit_qty IN jtf_number_table := NULL,
4475: p_qlpaj_benefit_uom_code IN jtf_varchar2_table_100 := NULL,
4476: p_qlpaj_print_on_invoice_flag IN jtf_varchar2_table_100 := NULL,
4477: p_qlpaj_expiration_date IN jtf_date_table := NULL,
4478: p_qlpaj_rebate_trans_type_code IN jtf_varchar2_table_100 := NULL,
4479: p_qlpaj_rebate_trans_reference IN jtf_varchar2_table_100 := NULL,
4480: p_qlpaj_rebate_pay_system_code IN jtf_varchar2_table_100 := NULL,
4481: p_qlpaj_redeemed_date IN jtf_date_table := NULL,
4477: p_qlpaj_expiration_date IN jtf_date_table := NULL,
4478: p_qlpaj_rebate_trans_type_code IN jtf_varchar2_table_100 := NULL,
4479: p_qlpaj_rebate_trans_reference IN jtf_varchar2_table_100 := NULL,
4480: p_qlpaj_rebate_pay_system_code IN jtf_varchar2_table_100 := NULL,
4481: p_qlpaj_redeemed_date IN jtf_date_table := NULL,
4482: p_qlpaj_redeemed_flag IN jtf_varchar2_table_100 := NULL,
4483: p_qlpaj_modifier_level_code IN jtf_varchar2_table_100 := NULL,
4484: p_qlpaj_price_break_type_code IN jtf_varchar2_table_100 := NULL,
4485: p_qlpaj_substitution_attribute IN jtf_varchar2_table_100 := NULL,
4487: p_qlpaj_include_on_ret_flag IN jtf_varchar2_table_100 := NULL,
4488: p_qlpaj_credit_or_charge_flag IN jtf_varchar2_table_100 := NULL,
4489: p_qlpar_operation_code IN jtf_varchar2_table_100 := NULL,
4490: p_qlpar_adj_relationship_id IN jtf_number_table := NULL,
4491: p_qlpar_creation_date IN jtf_date_table := NULL,
4492: p_qlpar_created_by IN jtf_number_table := NULL,
4493: p_qlpar_last_update_date IN jtf_date_table := NULL,
4494: p_qlpar_last_updated_by IN jtf_number_table := NULL,
4495: p_qlpar_last_update_login IN jtf_number_table := NULL,
4489: p_qlpar_operation_code IN jtf_varchar2_table_100 := NULL,
4490: p_qlpar_adj_relationship_id IN jtf_number_table := NULL,
4491: p_qlpar_creation_date IN jtf_date_table := NULL,
4492: p_qlpar_created_by IN jtf_number_table := NULL,
4493: p_qlpar_last_update_date IN jtf_date_table := NULL,
4494: p_qlpar_last_updated_by IN jtf_number_table := NULL,
4495: p_qlpar_last_update_login IN jtf_number_table := NULL,
4496: p_qlpar_request_id IN jtf_number_table := NULL,
4497: p_qlpar_program_application_id IN jtf_number_table := NULL,
4495: p_qlpar_last_update_login IN jtf_number_table := NULL,
4496: p_qlpar_request_id IN jtf_number_table := NULL,
4497: p_qlpar_program_application_id IN jtf_number_table := NULL,
4498: p_qlpar_program_id IN jtf_number_table := NULL,
4499: p_qlpar_program_update_date IN jtf_date_table := NULL,
4500: p_qlpar_quote_line_id IN jtf_number_table := NULL,
4501: p_qlpar_qte_line_index IN jtf_number_table := NULL,
4502: p_qlpar_price_adjustment_id IN jtf_number_table := NULL,
4503: p_qlpar_price_adj_index IN jtf_number_table := NULL,
4505: p_qlpar_rltd_price_adj_index IN jtf_number_table := NULL,
4506: p_qlae_qte_line_index IN jtf_number_table := NULL,
4507: p_qlae_shipment_index IN jtf_number_table := NULL,
4508: p_qlae_line_attribute_id IN jtf_number_table := NULL,
4509: p_qlae_creation_date IN jtf_date_table := NULL,
4510: p_qlae_created_by IN jtf_number_table := NULL,
4511: p_qlae_last_update_date IN jtf_date_table := NULL,
4512: p_qlae_last_updated_by IN jtf_number_table := NULL,
4513: p_qlae_last_update_login IN jtf_number_table := NULL,
4507: p_qlae_shipment_index IN jtf_number_table := NULL,
4508: p_qlae_line_attribute_id IN jtf_number_table := NULL,
4509: p_qlae_creation_date IN jtf_date_table := NULL,
4510: p_qlae_created_by IN jtf_number_table := NULL,
4511: p_qlae_last_update_date IN jtf_date_table := NULL,
4512: p_qlae_last_updated_by IN jtf_number_table := NULL,
4513: p_qlae_last_update_login IN jtf_number_table := NULL,
4514: p_qlae_request_id IN jtf_number_table := NULL,
4515: p_qlae_program_application_id IN jtf_number_table := NULL,
4513: p_qlae_last_update_login IN jtf_number_table := NULL,
4514: p_qlae_request_id IN jtf_number_table := NULL,
4515: p_qlae_program_application_id IN jtf_number_table := NULL,
4516: p_qlae_program_id IN jtf_number_table := NULL,
4517: p_qlae_program_update_date IN jtf_date_table := NULL,
4518: p_qlae_quote_header_id IN jtf_number_table := NULL,
4519: p_qlae_quote_line_id IN jtf_number_table := NULL,
4520: p_qlae_quote_shipment_id IN jtf_number_table := NULL,
4521: p_qlae_attribute_type_code IN jtf_varchar2_table_100 := NULL,
4523: p_qlae_value IN jtf_varchar2_table_2000 := NULL,
4524: p_qlae_value_type IN jtf_varchar2_table_300 := NULL,
4525: p_qlae_status IN jtf_varchar2_table_100 := NULL,
4526: p_qlae_application_id IN jtf_number_table := NULL,
4527: p_qlae_start_date_active IN jtf_date_table := NULL,
4528: p_qlae_end_date_active IN jtf_date_table := NULL,
4529: p_qlae_operation_code IN jtf_varchar2_table_100 := NULL,
4530: p_qfc_operation_code IN jtf_varchar2_table_100 := NULL,
4531: p_qfc_qte_line_index IN jtf_number_table := NULL,
4524: p_qlae_value_type IN jtf_varchar2_table_300 := NULL,
4525: p_qlae_status IN jtf_varchar2_table_100 := NULL,
4526: p_qlae_application_id IN jtf_number_table := NULL,
4527: p_qlae_start_date_active IN jtf_date_table := NULL,
4528: p_qlae_end_date_active IN jtf_date_table := NULL,
4529: p_qlae_operation_code IN jtf_varchar2_table_100 := NULL,
4530: p_qfc_operation_code IN jtf_varchar2_table_100 := NULL,
4531: p_qfc_qte_line_index IN jtf_number_table := NULL,
4532: p_qfc_shipment_index IN jtf_number_table := NULL,
4530: p_qfc_operation_code IN jtf_varchar2_table_100 := NULL,
4531: p_qfc_qte_line_index IN jtf_number_table := NULL,
4532: p_qfc_shipment_index IN jtf_number_table := NULL,
4533: p_qfc_freight_charge_id IN jtf_number_table := NULL,
4534: p_qfc_last_update_date IN jtf_date_table := NULL,
4535: p_qfc_last_updated_by IN jtf_number_table := NULL,
4536: p_qfc_creation_date IN jtf_date_table := NULL,
4537: p_qfc_created_by IN jtf_number_table := NULL,
4538: p_qfc_last_update_login IN jtf_number_table := NULL,
4532: p_qfc_shipment_index IN jtf_number_table := NULL,
4533: p_qfc_freight_charge_id IN jtf_number_table := NULL,
4534: p_qfc_last_update_date IN jtf_date_table := NULL,
4535: p_qfc_last_updated_by IN jtf_number_table := NULL,
4536: p_qfc_creation_date IN jtf_date_table := NULL,
4537: p_qfc_created_by IN jtf_number_table := NULL,
4538: p_qfc_last_update_login IN jtf_number_table := NULL,
4539: p_qfc_program_application_id IN jtf_number_table := NULL,
4540: p_qfc_program_id IN jtf_number_table := NULL,
4537: p_qfc_created_by IN jtf_number_table := NULL,
4538: p_qfc_last_update_login IN jtf_number_table := NULL,
4539: p_qfc_program_application_id IN jtf_number_table := NULL,
4540: p_qfc_program_id IN jtf_number_table := NULL,
4541: p_qfc_program_update_date IN jtf_date_table := NULL,
4542: p_qfc_request_id IN jtf_number_table := NULL,
4543: p_qfc_quote_shipment_id IN jtf_number_table := NULL,
4544: p_qfc_quote_line_id IN jtf_number_table := NULL,
4545: p_qfc_freight_charge_type_id IN jtf_number_table := NULL,
4563: p_qlfc_operation_code IN jtf_varchar2_table_100 := NULL,
4564: p_qlfc_qte_line_index IN jtf_number_table := NULL,
4565: p_qlfc_shipment_index IN jtf_number_table := NULL,
4566: p_qlfc_freight_charge_id IN jtf_number_table := NULL,
4567: p_qlfc_last_update_date IN jtf_date_table := NULL,
4568: p_qlfc_last_updated_by IN jtf_number_table := NULL,
4569: p_qlfc_creation_date IN jtf_date_table := NULL,
4570: p_qlfc_created_by IN jtf_number_table := NULL,
4571: p_qlfc_last_update_login IN jtf_number_table := NULL,
4565: p_qlfc_shipment_index IN jtf_number_table := NULL,
4566: p_qlfc_freight_charge_id IN jtf_number_table := NULL,
4567: p_qlfc_last_update_date IN jtf_date_table := NULL,
4568: p_qlfc_last_updated_by IN jtf_number_table := NULL,
4569: p_qlfc_creation_date IN jtf_date_table := NULL,
4570: p_qlfc_created_by IN jtf_number_table := NULL,
4571: p_qlfc_last_update_login IN jtf_number_table := NULL,
4572: p_qlfc_program_application_id IN jtf_number_table := NULL,
4573: p_qlfc_program_id IN jtf_number_table := NULL,
4570: p_qlfc_created_by IN jtf_number_table := NULL,
4571: p_qlfc_last_update_login IN jtf_number_table := NULL,
4572: p_qlfc_program_application_id IN jtf_number_table := NULL,
4573: p_qlfc_program_id IN jtf_number_table := NULL,
4574: p_qlfc_program_update_date IN jtf_date_table := NULL,
4575: p_qlfc_request_id IN jtf_number_table := NULL,
4576: p_qlfc_quote_shipment_id IN jtf_number_table := NULL,
4577: p_qlfc_quote_line_id IN jtf_number_table := NULL,
4578: p_qlfc_freight_charge_type_id IN jtf_number_table := NULL,
6152: p_q_save_type IN NUMBER := FND_API.G_MISS_NUM,
6153: p_q_minisite_id IN NUMBER := FND_API.G_MISS_NUM,
6154: p_q_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
6155: p_q_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
6156: p_ql_creation_date IN jtf_date_table := NULL,
6157: p_ql_created_by IN jtf_number_table := NULL,
6158: p_ql_last_updated_by IN jtf_number_table := NULL,
6159: p_ql_last_update_date IN jtf_date_table := NULL,
6160: p_ql_last_update_login IN jtf_number_table := NULL,
6155: p_q_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
6156: p_ql_creation_date IN jtf_date_table := NULL,
6157: p_ql_created_by IN jtf_number_table := NULL,
6158: p_ql_last_updated_by IN jtf_number_table := NULL,
6159: p_ql_last_update_date IN jtf_date_table := NULL,
6160: p_ql_last_update_login IN jtf_number_table := NULL,
6161: p_ql_request_id IN jtf_number_table := NULL,
6162: p_ql_program_application_id IN jtf_number_table := NULL,
6163: p_ql_program_id IN jtf_number_table := NULL,
6160: p_ql_last_update_login IN jtf_number_table := NULL,
6161: p_ql_request_id IN jtf_number_table := NULL,
6162: p_ql_program_application_id IN jtf_number_table := NULL,
6163: p_ql_program_id IN jtf_number_table := NULL,
6164: p_ql_program_update_date IN jtf_date_table := NULL,
6165: p_ql_quote_line_id IN jtf_number_table := NULL,
6166: p_ql_quote_header_id IN jtf_number_table := NULL,
6167: p_ql_org_id IN jtf_number_table := NULL,
6168: p_ql_line_number IN jtf_number_table := NULL,
6171: p_ql_inventory_item_id IN jtf_number_table := NULL,
6172: p_ql_organization_id IN jtf_number_table := NULL,
6173: p_ql_quantity IN jtf_number_table := NULL,
6174: p_ql_uom_code IN jtf_varchar2_table_100 := NULL,
6175: p_ql_start_date_active IN jtf_date_table := NULL,
6176: p_ql_end_date_active IN jtf_date_table := NULL,
6177: p_ql_order_line_type_id IN jtf_number_table := NULL,
6178: p_ql_price_list_id IN jtf_number_table := NULL,
6179: p_ql_price_list_line_id IN jtf_number_table := NULL,
6172: p_ql_organization_id IN jtf_number_table := NULL,
6173: p_ql_quantity IN jtf_number_table := NULL,
6174: p_ql_uom_code IN jtf_varchar2_table_100 := NULL,
6175: p_ql_start_date_active IN jtf_date_table := NULL,
6176: p_ql_end_date_active IN jtf_date_table := NULL,
6177: p_ql_order_line_type_id IN jtf_number_table := NULL,
6178: p_ql_price_list_id IN jtf_number_table := NULL,
6179: p_ql_price_list_line_id IN jtf_number_table := NULL,
6180: p_ql_currency_code IN jtf_varchar2_table_100 := NULL,