eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ASO_QUOTE_UTIL_PVT dependencies on JTF_DATE_TABLE

Line 155: p_creation_date IN jtf_date_table := NULL,

151: )
152: RETURN ASO_Quote_Pub.Qte_Header_Rec_Type;
153:
154: FUNCTION Construct_Qte_Line_Tbl(
155: p_creation_date IN jtf_date_table := NULL,
156: p_created_by IN jtf_number_table := NULL,
157: p_last_updated_by IN jtf_number_table := NULL,
158: p_last_update_date IN jtf_date_table := NULL,
159: p_last_update_login IN jtf_number_table := NULL,

Line 158: p_last_update_date IN jtf_date_table := NULL,

154: FUNCTION Construct_Qte_Line_Tbl(
155: p_creation_date IN jtf_date_table := NULL,
156: p_created_by IN jtf_number_table := NULL,
157: p_last_updated_by IN jtf_number_table := NULL,
158: p_last_update_date IN jtf_date_table := NULL,
159: p_last_update_login IN jtf_number_table := NULL,
160: p_request_id IN jtf_number_table := NULL,
161: p_program_application_id IN jtf_number_table := NULL,
162: p_program_id IN jtf_number_table := NULL,

Line 163: p_program_update_date IN jtf_date_table := NULL,

159: p_last_update_login IN jtf_number_table := NULL,
160: p_request_id IN jtf_number_table := NULL,
161: p_program_application_id IN jtf_number_table := NULL,
162: p_program_id IN jtf_number_table := NULL,
163: p_program_update_date IN jtf_date_table := NULL,
164: p_quote_line_id IN jtf_number_table := NULL,
165: p_quote_header_id IN jtf_number_table := NULL,
166: p_org_id IN jtf_number_table := NULL,
167: p_line_number IN jtf_number_table := NULL,

Line 174: p_start_date_active IN jtf_date_table := NULL,

170: p_inventory_item_id IN jtf_number_table := NULL,
171: p_organization_id IN jtf_number_table := NULL,
172: p_quantity IN jtf_number_table := NULL,
173: p_uom_code IN jtf_varchar2_table_100 := NULL,
174: p_start_date_active IN jtf_date_table := NULL,
175: p_end_date_active IN jtf_date_table := NULL,
176: p_order_line_type_id IN jtf_number_table := NULL,
177: p_price_list_id IN jtf_number_table := NULL,
178: p_price_list_line_id IN jtf_number_table := NULL,

Line 175: p_end_date_active IN jtf_date_table := NULL,

171: p_organization_id IN jtf_number_table := NULL,
172: p_quantity IN jtf_number_table := NULL,
173: p_uom_code IN jtf_varchar2_table_100 := NULL,
174: p_start_date_active IN jtf_date_table := NULL,
175: p_end_date_active IN jtf_date_table := NULL,
176: p_order_line_type_id IN jtf_number_table := NULL,
177: p_price_list_id IN jtf_number_table := NULL,
178: p_price_list_line_id IN jtf_number_table := NULL,
179: p_currency_code IN jtf_varchar2_table_100 := NULL,

Line 341: p_creation_date IN jtf_date_table := NULL,

337:
338:
339: FUNCTION Construct_Qte_Line_Dtl_Tbl(
340: p_quote_line_detail_id IN jtf_number_table := NULL,
341: p_creation_date IN jtf_date_table := NULL,
342: p_created_by IN jtf_number_table := NULL,
343: p_last_update_date IN jtf_date_table := NULL,
344: p_last_updated_by IN jtf_number_table := NULL,
345: p_last_update_login IN jtf_number_table := NULL,

Line 343: p_last_update_date IN jtf_date_table := NULL,

339: FUNCTION Construct_Qte_Line_Dtl_Tbl(
340: p_quote_line_detail_id IN jtf_number_table := NULL,
341: p_creation_date IN jtf_date_table := NULL,
342: p_created_by IN jtf_number_table := NULL,
343: p_last_update_date IN jtf_date_table := NULL,
344: p_last_updated_by IN jtf_number_table := NULL,
345: p_last_update_login IN jtf_number_table := NULL,
346: p_request_id IN jtf_number_table := NULL,
347: p_program_application_id IN jtf_number_table := NULL,

Line 349: p_program_update_date IN jtf_date_table := NULL,

345: p_last_update_login IN jtf_number_table := NULL,
346: p_request_id IN jtf_number_table := NULL,
347: p_program_application_id IN jtf_number_table := NULL,
348: p_program_id IN jtf_number_table := NULL,
349: p_program_update_date IN jtf_date_table := NULL,
350: p_quote_line_id IN jtf_number_table := NULL,
351: p_config_header_id IN jtf_number_table := NULL,
352: p_config_revision_num IN jtf_number_table := NULL,
353: p_config_item_id IN jtf_number_table := NULL,

Line 513: p_creation_date IN jtf_date_table := NULL,

509: RETURN ASO_Quote_Pub.Qte_Line_Dtl_Rec_Type;
510:
511: FUNCTION Construct_Line_Rltship_Tbl(
512: p_line_relationship_id IN jtf_number_table := NULL,
513: p_creation_date IN jtf_date_table := NULL,
514: p_created_by IN jtf_number_table := NULL,
515: p_last_updated_by IN jtf_number_table := NULL,
516: p_last_update_date IN jtf_date_table := NULL,
517: p_last_update_login IN jtf_number_table := NULL,

Line 516: p_last_update_date IN jtf_date_table := NULL,

512: p_line_relationship_id IN jtf_number_table := NULL,
513: p_creation_date IN jtf_date_table := NULL,
514: p_created_by IN jtf_number_table := NULL,
515: p_last_updated_by IN jtf_number_table := NULL,
516: p_last_update_date IN jtf_date_table := NULL,
517: p_last_update_login IN jtf_number_table := NULL,
518: p_request_id IN jtf_number_table := NULL,
519: p_program_application_id IN jtf_number_table := NULL,
520: p_program_id IN jtf_number_table := NULL,

Line 521: p_program_update_date IN jtf_date_table := NULL,

517: p_last_update_login IN jtf_number_table := NULL,
518: p_request_id IN jtf_number_table := NULL,
519: p_program_application_id IN jtf_number_table := NULL,
520: p_program_id IN jtf_number_table := NULL,
521: p_program_update_date IN jtf_date_table := NULL,
522: p_quote_line_id IN jtf_number_table := NULL,
523: p_related_quote_line_id IN jtf_number_table := NULL,
524: p_relationship_type_code IN jtf_varchar2_table_100 := NULL,
525: p_reciprocal_flag IN jtf_varchar2_table_100 := NULL,

Line 537: p_creation_date IN jtf_date_table := NULL,

533: FUNCTION Construct_Payment_Tbl(
534: p_operation_code IN jtf_varchar2_table_100 := NULL,
535: p_qte_line_index IN jtf_number_table := NULL,
536: p_payment_id IN jtf_number_table := NULL,
537: p_creation_date IN jtf_date_table := NULL,
538: p_created_by IN jtf_number_table := NULL,
539: p_last_update_date IN jtf_date_table := NULL,
540: p_last_updated_by IN jtf_number_table := NULL,
541: p_last_update_login IN jtf_number_table := NULL,

Line 539: p_last_update_date IN jtf_date_table := NULL,

535: p_qte_line_index IN jtf_number_table := NULL,
536: p_payment_id IN jtf_number_table := NULL,
537: p_creation_date IN jtf_date_table := NULL,
538: p_created_by IN jtf_number_table := NULL,
539: p_last_update_date IN jtf_date_table := NULL,
540: p_last_updated_by IN jtf_number_table := NULL,
541: p_last_update_login IN jtf_number_table := NULL,
542: p_request_id IN jtf_number_table := NULL,
543: p_program_application_id IN jtf_number_table := NULL,

Line 545: p_program_update_date IN jtf_date_table := NULL,

541: p_last_update_login IN jtf_number_table := NULL,
542: p_request_id IN jtf_number_table := NULL,
543: p_program_application_id IN jtf_number_table := NULL,
544: p_program_id IN jtf_number_table := NULL,
545: p_program_update_date IN jtf_date_table := NULL,
546: p_quote_header_id IN jtf_number_table := NULL,
547: p_quote_line_id IN jtf_number_table := NULL,
548: p_payment_type_code IN jtf_varchar2_table_100 := NULL,
549: p_payment_ref_number IN jtf_varchar2_table_300 := NULL,

Line 554: p_credit_card_exp_date IN jtf_date_table := NULL,

550: p_payment_option IN jtf_varchar2_table_300 := NULL,
551: p_payment_term_id IN jtf_number_table := NULL,
552: p_credit_card_code IN jtf_varchar2_table_100 := NULL,
553: p_credit_card_holder_name IN jtf_varchar2_table_100 := NULL,
554: p_credit_card_exp_date IN jtf_date_table := NULL,
555: p_credit_card_approval_code IN jtf_varchar2_table_100 := NULL,
556: p_credit_card_approval_date IN jtf_date_table := NULL,
557: p_payment_amount IN jtf_number_table := NULL,
558: p_attribute_category IN jtf_varchar2_table_100 := NULL,

Line 556: p_credit_card_approval_date IN jtf_date_table := NULL,

552: p_credit_card_code IN jtf_varchar2_table_100 := NULL,
553: p_credit_card_holder_name IN jtf_varchar2_table_100 := NULL,
554: p_credit_card_exp_date IN jtf_date_table := NULL,
555: p_credit_card_approval_code IN jtf_varchar2_table_100 := NULL,
556: p_credit_card_approval_date IN jtf_date_table := NULL,
557: p_payment_amount IN jtf_number_table := NULL,
558: p_attribute_category IN jtf_varchar2_table_100 := NULL,
559: p_attribute1 IN jtf_varchar2_table_300 := NULL,
560: p_attribute2 IN jtf_varchar2_table_300 := NULL,

Line 736: p_creation_date IN jtf_date_table := NULL,

732: FUNCTION Construct_Shipment_Tbl(
733: p_operation_code IN jtf_varchar2_table_100 := NULL,
734: p_qte_line_index IN jtf_number_table := NULL,
735: p_shipment_id IN jtf_number_table := NULL,
736: p_creation_date IN jtf_date_table := NULL,
737: p_created_by IN jtf_number_table := NULL,
738: p_last_update_date IN jtf_date_table := NULL,
739: p_last_updated_by IN jtf_number_table := NULL,
740: p_last_update_login IN jtf_number_table := NULL,

Line 738: p_last_update_date IN jtf_date_table := NULL,

734: p_qte_line_index IN jtf_number_table := NULL,
735: p_shipment_id IN jtf_number_table := NULL,
736: p_creation_date IN jtf_date_table := NULL,
737: p_created_by IN jtf_number_table := NULL,
738: p_last_update_date IN jtf_date_table := NULL,
739: p_last_updated_by IN jtf_number_table := NULL,
740: p_last_update_login IN jtf_number_table := NULL,
741: p_request_id IN jtf_number_table := NULL,
742: p_program_application_id IN jtf_number_table := NULL,

Line 744: p_program_update_date IN jtf_date_table := NULL,

740: p_last_update_login IN jtf_number_table := NULL,
741: p_request_id IN jtf_number_table := NULL,
742: p_program_application_id IN jtf_number_table := NULL,
743: p_program_id IN jtf_number_table := NULL,
744: p_program_update_date IN jtf_date_table := NULL,
745: p_quote_header_id IN jtf_number_table := NULL,
746: p_quote_line_id IN jtf_number_table := NULL,
747: p_promise_date IN jtf_date_table := NULL,
748: p_request_date IN jtf_date_table := NULL,

Line 747: p_promise_date IN jtf_date_table := NULL,

743: p_program_id IN jtf_number_table := NULL,
744: p_program_update_date IN jtf_date_table := NULL,
745: p_quote_header_id IN jtf_number_table := NULL,
746: p_quote_line_id IN jtf_number_table := NULL,
747: p_promise_date IN jtf_date_table := NULL,
748: p_request_date IN jtf_date_table := NULL,
749: p_schedule_ship_date IN jtf_date_table := NULL,
750: p_ship_to_party_site_id IN jtf_number_table := NULL,
751: p_ship_to_party_id IN jtf_number_table := NULL,

Line 748: p_request_date IN jtf_date_table := NULL,

744: p_program_update_date IN jtf_date_table := NULL,
745: p_quote_header_id IN jtf_number_table := NULL,
746: p_quote_line_id IN jtf_number_table := NULL,
747: p_promise_date IN jtf_date_table := NULL,
748: p_request_date IN jtf_date_table := NULL,
749: p_schedule_ship_date IN jtf_date_table := NULL,
750: p_ship_to_party_site_id IN jtf_number_table := NULL,
751: p_ship_to_party_id IN jtf_number_table := NULL,
752: p_ship_to_cust_account_id IN jtf_number_table := NULL,

Line 749: p_schedule_ship_date IN jtf_date_table := NULL,

745: p_quote_header_id IN jtf_number_table := NULL,
746: p_quote_line_id IN jtf_number_table := NULL,
747: p_promise_date IN jtf_date_table := NULL,
748: p_request_date IN jtf_date_table := NULL,
749: p_schedule_ship_date IN jtf_date_table := NULL,
750: p_ship_to_party_site_id IN jtf_number_table := NULL,
751: p_ship_to_party_id IN jtf_number_table := NULL,
752: p_ship_to_cust_account_id IN jtf_number_table := NULL,
753: p_ship_partial_flag IN jtf_varchar2_table_300 := NULL,

Line 820: p_creation_date IN jtf_date_table := NULL,

816: p_tax_detail_id IN jtf_number_table := NULL,
817: p_quote_header_id IN jtf_number_table := NULL,
818: p_quote_line_id IN jtf_number_table := NULL,
819: p_quote_shipment_id IN jtf_number_table := NULL,
820: p_creation_date IN jtf_date_table := NULL,
821: p_created_by IN jtf_number_table := NULL,
822: p_last_update_date IN jtf_date_table := NULL,
823: p_last_updated_by IN jtf_number_table := NULL,
824: p_last_update_login IN jtf_number_table := NULL,

Line 822: p_last_update_date IN jtf_date_table := NULL,

818: p_quote_line_id IN jtf_number_table := NULL,
819: p_quote_shipment_id IN jtf_number_table := NULL,
820: p_creation_date IN jtf_date_table := NULL,
821: p_created_by IN jtf_number_table := NULL,
822: p_last_update_date IN jtf_date_table := NULL,
823: p_last_updated_by IN jtf_number_table := NULL,
824: p_last_update_login IN jtf_number_table := NULL,
825: p_request_id IN jtf_number_table := NULL,
826: p_program_application_id IN jtf_number_table := NULL,

Line 828: p_program_update_date IN jtf_date_table := NULL,

824: p_last_update_login IN jtf_number_table := NULL,
825: p_request_id IN jtf_number_table := NULL,
826: p_program_application_id IN jtf_number_table := NULL,
827: p_program_id IN jtf_number_table := NULL,
828: p_program_update_date IN jtf_date_table := NULL,
829: p_orig_tax_code IN jtf_varchar2_table_300 := NULL,
830: p_tax_code IN jtf_varchar2_table_100 := NULL,
831: p_tax_rate IN jtf_number_table := NULL,
832: p_tax_date IN jtf_date_table := NULL,

Line 832: p_tax_date IN jtf_date_table := NULL,

828: p_program_update_date IN jtf_date_table := NULL,
829: p_orig_tax_code IN jtf_varchar2_table_300 := NULL,
830: p_tax_code IN jtf_varchar2_table_100 := NULL,
831: p_tax_rate IN jtf_number_table := NULL,
832: p_tax_date IN jtf_date_table := NULL,
833: p_tax_amount IN jtf_number_table := NULL,
834: p_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,
835: p_tax_exempt_number IN jtf_varchar2_table_100 := NULL,
836: p_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,

Line 919: p_creation_date IN jtf_date_table := NULL,

915: FUNCTION Construct_Price_Attributes_Tbl(
916: p_operation_code IN jtf_varchar2_table_100 := NULL,
917: p_qte_line_index IN jtf_number_table := NULL,
918: p_price_attribute_id IN jtf_number_table := NULL,
919: p_creation_date IN jtf_date_table := NULL,
920: p_created_by IN jtf_number_table := NULL,
921: p_last_update_date IN jtf_date_table := NULL,
922: p_last_updated_by IN jtf_number_table := NULL,
923: p_last_update_login IN jtf_number_table := NULL,

Line 921: p_last_update_date IN jtf_date_table := NULL,

917: p_qte_line_index IN jtf_number_table := NULL,
918: p_price_attribute_id IN jtf_number_table := NULL,
919: p_creation_date IN jtf_date_table := NULL,
920: p_created_by IN jtf_number_table := NULL,
921: p_last_update_date IN jtf_date_table := NULL,
922: p_last_updated_by IN jtf_number_table := NULL,
923: p_last_update_login IN jtf_number_table := NULL,
924: p_request_id IN jtf_number_table := NULL,
925: p_program_application_id IN jtf_number_table := NULL,

Line 927: p_program_update_date IN jtf_date_table := NULL,

923: p_last_update_login IN jtf_number_table := NULL,
924: p_request_id IN jtf_number_table := NULL,
925: p_program_application_id IN jtf_number_table := NULL,
926: p_program_id IN jtf_number_table := NULL,
927: p_program_update_date IN jtf_date_table := NULL,
928: p_quote_header_id IN jtf_number_table := NULL,
929: p_quote_line_id IN jtf_number_table := NULL,
930: p_flex_title IN jtf_varchar2_table_100 := NULL,
931: p_pricing_context IN jtf_varchar2_table_100 := NULL,

Line 1061: p_creation_date IN jtf_date_table := NULL,

1057: FUNCTION Construct_Price_Adj_Tbl(
1058: p_operation_code IN jtf_varchar2_table_100 := NULL,
1059: p_qte_line_index IN jtf_number_table := NULL,
1060: p_price_adjustment_id IN jtf_number_table := NULL,
1061: p_creation_date IN jtf_date_table := NULL,
1062: p_created_by IN jtf_number_table := NULL,
1063: p_last_update_date IN jtf_date_table := NULL,
1064: p_last_updated_by IN jtf_number_table := NULL,
1065: p_last_update_login IN jtf_number_table := NULL,

Line 1063: p_last_update_date IN jtf_date_table := NULL,

1059: p_qte_line_index IN jtf_number_table := NULL,
1060: p_price_adjustment_id IN jtf_number_table := NULL,
1061: p_creation_date IN jtf_date_table := NULL,
1062: p_created_by IN jtf_number_table := NULL,
1063: p_last_update_date IN jtf_date_table := NULL,
1064: p_last_updated_by IN jtf_number_table := NULL,
1065: p_last_update_login IN jtf_number_table := NULL,
1066: p_program_application_id IN jtf_number_table := NULL,
1067: p_program_id IN jtf_number_table := NULL,

Line 1068: p_program_update_date IN jtf_date_table := NULL,

1064: p_last_updated_by IN jtf_number_table := NULL,
1065: p_last_update_login IN jtf_number_table := NULL,
1066: p_program_application_id IN jtf_number_table := NULL,
1067: p_program_id IN jtf_number_table := NULL,
1068: p_program_update_date IN jtf_date_table := NULL,
1069: p_request_id IN jtf_number_table := NULL,
1070: p_quote_header_id IN jtf_number_table := NULL,
1071: p_quote_line_id IN jtf_number_table := NULL,
1072: p_modifier_header_id IN jtf_number_table := NULL,

Line 1129: p_expiration_date IN jtf_date_table := NULL,

1125: p_source_system_code IN jtf_varchar2_table_100 := NULL,
1126: p_benefit_qty IN jtf_number_table := NULL,
1127: p_benefit_uom_code IN jtf_varchar2_table_100 := NULL,
1128: p_print_on_invoice_flag IN jtf_varchar2_table_100 := NULL,
1129: p_expiration_date IN jtf_date_table := NULL,
1130: p_rebate_trans_type_code IN jtf_varchar2_table_100 := NULL,
1131: p_rebate_trans_reference IN jtf_varchar2_table_100 := NULL,
1132: p_rebate_pay_system_code IN jtf_varchar2_table_100 := NULL,
1133: p_redeemed_date IN jtf_date_table := NULL,

Line 1133: p_redeemed_date IN jtf_date_table := NULL,

1129: p_expiration_date IN jtf_date_table := NULL,
1130: p_rebate_trans_type_code IN jtf_varchar2_table_100 := NULL,
1131: p_rebate_trans_reference IN jtf_varchar2_table_100 := NULL,
1132: p_rebate_pay_system_code IN jtf_varchar2_table_100 := NULL,
1133: p_redeemed_date IN jtf_date_table := NULL,
1134: p_redeemed_flag IN jtf_varchar2_table_100 := NULL,
1135: p_modifier_level_code IN jtf_varchar2_table_100 := NULL,
1136: p_price_break_type_code IN jtf_varchar2_table_100 := NULL,
1137: p_substitution_attribute IN jtf_varchar2_table_100 := NULL,

Line 1156: p_creation_date IN jtf_date_table := NULL,

1152: FUNCTION Construct_Sales_Credit_Tbl(
1153: p_operation_code IN jtf_varchar2_table_100 := NULL,
1154: p_qte_line_index IN jtf_number_table := NULL,
1155: p_sales_credit_id IN jtf_number_table := NULL,
1156: p_creation_date IN jtf_date_table := NULL,
1157: p_created_by IN jtf_number_table := NULL,
1158: p_last_updated_by IN jtf_varchar2_table_300 := NULL,
1159: p_last_update_date IN jtf_date_table := NULL,
1160: p_last_update_login IN jtf_number_table := NULL,

Line 1159: p_last_update_date IN jtf_date_table := NULL,

1155: p_sales_credit_id IN jtf_number_table := NULL,
1156: p_creation_date IN jtf_date_table := NULL,
1157: p_created_by IN jtf_number_table := NULL,
1158: p_last_updated_by IN jtf_varchar2_table_300 := NULL,
1159: p_last_update_date IN jtf_date_table := NULL,
1160: p_last_update_login IN jtf_number_table := NULL,
1161: p_request_id IN jtf_number_table := NULL,
1162: p_program_application_id IN jtf_number_table := NULL,
1163: p_program_id IN jtf_number_table := NULL,

Line 1164: p_program_update_date IN jtf_date_table := NULL,

1160: p_last_update_login IN jtf_number_table := NULL,
1161: p_request_id IN jtf_number_table := NULL,
1162: p_program_application_id IN jtf_number_table := NULL,
1163: p_program_id IN jtf_number_table := NULL,
1164: p_program_update_date IN jtf_date_table := NULL,
1165: p_quote_header_id IN jtf_number_table := NULL,
1166: p_quote_line_id IN jtf_number_table := NULL,
1167: p_percent IN jtf_number_table := NULL,
1168: p_resource_id IN jtf_number_table := NULL,

Line 1235: p_creation_date IN jtf_date_table := NULL,

1231: p_quote_number IN jtf_number_table := NULL,
1232: p_resource_id IN jtf_number_table := NULL,
1233: p_resource_grp_id IN jtf_number_table := NULL,
1234: p_created_by IN jtf_number_table := NULL,
1235: p_creation_date IN jtf_date_table := NULL,
1236: p_last_updated_by IN jtf_number_table := NULL,
1237: p_last_update_login IN jtf_number_table := NULL,
1238: p_last_update_date IN jtf_date_table := NULL,
1239: p_request_id IN jtf_number_table := NULL,

Line 1238: p_last_update_date IN jtf_date_table := NULL,

1234: p_created_by IN jtf_number_table := NULL,
1235: p_creation_date IN jtf_date_table := NULL,
1236: p_last_updated_by IN jtf_number_table := NULL,
1237: p_last_update_login IN jtf_number_table := NULL,
1238: p_last_update_date IN jtf_date_table := NULL,
1239: p_request_id IN jtf_number_table := NULL,
1240: p_program_application_id IN jtf_number_table := NULL,
1241: p_program_id IN jtf_number_table := NULL,
1242: p_program_update_date IN jtf_date_table := NULL,

Line 1242: p_program_update_date IN jtf_date_table := NULL,

1238: p_last_update_date IN jtf_date_table := NULL,
1239: p_request_id IN jtf_number_table := NULL,
1240: p_program_application_id IN jtf_number_table := NULL,
1241: p_program_id IN jtf_number_table := NULL,
1242: p_program_update_date IN jtf_date_table := NULL,
1243: p_keep_flag IN jtf_varchar2_table_100 := NULL,
1244: p_update_access_flag IN jtf_varchar2_table_100 := NULL,
1245: p_created_by_tap_flag IN jtf_varchar2_table_100 := NULL,
1246: p_role_id IN jtf_number_table := NULL,

Line 1352: x_last_update_date OUT NOCOPY jtf_date_table

1348:
1349: PROCEDURE Set_Qte_Header_Tbl_Out(
1350: p_qte_header_tbl IN ASO_Quote_Pub.Qte_Header_Tbl_Type,
1351: x_quote_header_id OUT NOCOPY jtf_number_table,
1352: x_last_update_date OUT NOCOPY jtf_date_table
1353:
1354: /*-- The following output parameters are ignored
1355: x_creation_date OUT NOCOPY jtf_date_table,
1356: x_created_by OUT NOCOPY jtf_number_table,

Line 1355: x_creation_date OUT NOCOPY jtf_date_table,

1351: x_quote_header_id OUT NOCOPY jtf_number_table,
1352: x_last_update_date OUT NOCOPY jtf_date_table
1353:
1354: /*-- The following output parameters are ignored
1355: x_creation_date OUT NOCOPY jtf_date_table,
1356: x_created_by OUT NOCOPY jtf_number_table,
1357: x_last_updated_by OUT NOCOPY jtf_number_table,
1358: x_last_update_login OUT NOCOPY jtf_number_table,
1359: x_request_id OUT NOCOPY jtf_number_table,

Line 1362: x_program_update_date OUT NOCOPY jtf_date_table,

1358: x_last_update_login OUT NOCOPY jtf_number_table,
1359: x_request_id OUT NOCOPY jtf_number_table,
1360: x_program_application_id OUT NOCOPY jtf_number_table,
1361: x_program_id OUT NOCOPY jtf_number_table,
1362: x_program_update_date OUT NOCOPY jtf_date_table,
1363: x_org_id OUT NOCOPY jtf_number_table,
1364: x_quote_name OUT NOCOPY jtf_varchar2_table_100,
1365: x_quote_number OUT NOCOPY jtf_number_table,
1366: x_quote_version OUT NOCOPY jtf_number_table,

Line 1369: x_quote_expiration_date OUT NOCOPY jtf_date_table,

1365: x_quote_number OUT NOCOPY jtf_number_table,
1366: x_quote_version OUT NOCOPY jtf_number_table,
1367: x_quote_status_id OUT NOCOPY jtf_number_table,
1368: x_quote_source_code OUT NOCOPY jtf_varchar2_table_300,
1369: x_quote_expiration_date OUT NOCOPY jtf_date_table,
1370: x_price_frozen_date OUT NOCOPY jtf_date_table,
1371: x_quote_password OUT NOCOPY jtf_varchar2_table_300,
1372: x_original_system_reference OUT NOCOPY jtf_varchar2_table_300,
1373: x_party_id OUT NOCOPY jtf_number_table,

Line 1370: x_price_frozen_date OUT NOCOPY jtf_date_table,

1366: x_quote_version OUT NOCOPY jtf_number_table,
1367: x_quote_status_id OUT NOCOPY jtf_number_table,
1368: x_quote_source_code OUT NOCOPY jtf_varchar2_table_300,
1369: x_quote_expiration_date OUT NOCOPY jtf_date_table,
1370: x_price_frozen_date OUT NOCOPY jtf_date_table,
1371: x_quote_password OUT NOCOPY jtf_varchar2_table_300,
1372: x_original_system_reference OUT NOCOPY jtf_varchar2_table_300,
1373: x_party_id OUT NOCOPY jtf_number_table,
1374: x_cust_account_id OUT NOCOPY jtf_number_table,

Line 1384: x_ordered_date OUT NOCOPY jtf_date_table,

1380: x_orig_mktg_source_code_id OUT NOCOPY jtf_number_table,
1381: x_marketing_source_code_id OUT NOCOPY jtf_number_table,
1382: x_order_type_id OUT NOCOPY jtf_number_table,
1383: x_quote_category_code OUT NOCOPY jtf_varchar2_table_300,
1384: x_ordered_date OUT NOCOPY jtf_date_table,
1385: x_accounting_rule_id OUT NOCOPY jtf_number_table,
1386: x_invoicing_rule_id OUT NOCOPY jtf_number_table,
1387: x_employee_person_id OUT NOCOPY jtf_number_table,
1388: x_price_list_id OUT NOCOPY jtf_number_table,

Line 1400: x_exchange_rate_date OUT NOCOPY jtf_date_table,

1396: x_total_quote_price OUT NOCOPY jtf_number_table,
1397: x_payment_amount OUT NOCOPY jtf_number_table,
1398: x_exchange_rate OUT NOCOPY jtf_number_table,
1399: x_exchange_type_code OUT NOCOPY jtf_varchar2_table_100,
1400: x_exchange_rate_date OUT NOCOPY jtf_date_table,
1401: x_contract_id OUT NOCOPY jtf_number_table,
1402: x_sales_channel_code OUT NOCOPY jtf_varchar2_table_100,
1403: x_order_id OUT NOCOPY jtf_number_table,
1404: x_order_number OUT NOCOPY jtf_number_table,

Line 1461: x_creation_date OUT NOCOPY jtf_date_table,

1457: x_quote_line_id OUT NOCOPY jtf_number_table
1458:
1459: /*-- The following output parameters are ignored
1460: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
1461: x_creation_date OUT NOCOPY jtf_date_table,
1462: x_created_by OUT NOCOPY jtf_number_table,
1463: x_last_update_date OUT NOCOPY jtf_date_table,
1464: x_last_updated_by OUT NOCOPY jtf_number_table,
1465: x_last_update_login OUT NOCOPY jtf_number_table,

Line 1463: x_last_update_date OUT NOCOPY jtf_date_table,

1459: /*-- The following output parameters are ignored
1460: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
1461: x_creation_date OUT NOCOPY jtf_date_table,
1462: x_created_by OUT NOCOPY jtf_number_table,
1463: x_last_update_date OUT NOCOPY jtf_date_table,
1464: x_last_updated_by OUT NOCOPY jtf_number_table,
1465: x_last_update_login OUT NOCOPY jtf_number_table,
1466: x_request_id OUT NOCOPY jtf_number_table,
1467: x_program_application_id OUT NOCOPY jtf_number_table,

Line 1469: x_program_update_date OUT NOCOPY jtf_date_table,

1465: x_last_update_login OUT NOCOPY jtf_number_table,
1466: x_request_id OUT NOCOPY jtf_number_table,
1467: x_program_application_id OUT NOCOPY jtf_number_table,
1468: x_program_id OUT NOCOPY jtf_number_table,
1469: x_program_update_date OUT NOCOPY jtf_date_table,
1470: x_quote_header_id OUT NOCOPY jtf_number_table,
1471: x_org_id OUT NOCOPY jtf_number_table,
1472: x_line_category_code OUT NOCOPY jtf_varchar2_table_100,
1473: x_item_type_code OUT NOCOPY jtf_varchar2_table_100,

Line 1475: x_start_date_active OUT NOCOPY jtf_date_table,

1471: x_org_id OUT NOCOPY jtf_number_table,
1472: x_line_category_code OUT NOCOPY jtf_varchar2_table_100,
1473: x_item_type_code OUT NOCOPY jtf_varchar2_table_100,
1474: x_line_number OUT NOCOPY jtf_number_table,
1475: x_start_date_active OUT NOCOPY jtf_date_table,
1476: x_end_date_active OUT NOCOPY jtf_date_table,
1477: x_order_line_type_id OUT NOCOPY jtf_number_table,
1478: x_invoice_to_party_site_id OUT NOCOPY jtf_number_table,
1479: x_invoice_to_party_id OUT NOCOPY jtf_number_table,

Line 1476: x_end_date_active OUT NOCOPY jtf_date_table,

1472: x_line_category_code OUT NOCOPY jtf_varchar2_table_100,
1473: x_item_type_code OUT NOCOPY jtf_varchar2_table_100,
1474: x_line_number OUT NOCOPY jtf_number_table,
1475: x_start_date_active OUT NOCOPY jtf_date_table,
1476: x_end_date_active OUT NOCOPY jtf_date_table,
1477: x_order_line_type_id OUT NOCOPY jtf_number_table,
1478: x_invoice_to_party_site_id OUT NOCOPY jtf_number_table,
1479: x_invoice_to_party_id OUT NOCOPY jtf_number_table,
1480: x_invoice_to_cust_account_id OUT NOCOPY jtf_number_table,

Line 1536: x_creation_date OUT NOCOPY jtf_date_table,

1532:
1533: /*-- The following output parameters are ignored
1534: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
1535: x_qte_line_index OUT NOCOPY jtf_number_table,
1536: x_creation_date OUT NOCOPY jtf_date_table,
1537: x_created_by OUT NOCOPY jtf_number_table,
1538: x_last_update_date OUT NOCOPY jtf_date_table,
1539: x_last_updated_by OUT NOCOPY jtf_number_table,
1540: x_last_update_login OUT NOCOPY jtf_number_table,

Line 1538: x_last_update_date OUT NOCOPY jtf_date_table,

1534: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
1535: x_qte_line_index OUT NOCOPY jtf_number_table,
1536: x_creation_date OUT NOCOPY jtf_date_table,
1537: x_created_by OUT NOCOPY jtf_number_table,
1538: x_last_update_date OUT NOCOPY jtf_date_table,
1539: x_last_updated_by OUT NOCOPY jtf_number_table,
1540: x_last_update_login OUT NOCOPY jtf_number_table,
1541: x_request_id OUT NOCOPY jtf_number_table,
1542: x_program_application_id OUT NOCOPY jtf_number_table,

Line 1544: x_program_update_date OUT NOCOPY jtf_date_table,

1540: x_last_update_login OUT NOCOPY jtf_number_table,
1541: x_request_id OUT NOCOPY jtf_number_table,
1542: x_program_application_id OUT NOCOPY jtf_number_table,
1543: x_program_id OUT NOCOPY jtf_number_table,
1544: x_program_update_date OUT NOCOPY jtf_date_table,
1545: x_quote_line_id OUT NOCOPY jtf_number_table,
1546: x_config_header_id OUT NOCOPY jtf_number_table,
1547: x_config_revision_num OUT NOCOPY jtf_number_table,
1548: x_config_item_id OUT NOCOPY jtf_number_table,

Line 1613: x_creation_date OUT NOCOPY jtf_date_table,

1609: x_line_relationship_id OUT NOCOPY jtf_number_table
1610:
1611: /*-- The following output parameters are ignored
1612: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
1613: x_creation_date OUT NOCOPY jtf_date_table,
1614: x_created_by OUT NOCOPY jtf_number_table,
1615: x_last_update_date OUT NOCOPY jtf_date_table,
1616: x_last_updated_by OUT NOCOPY jtf_number_table,
1617: x_last_update_login OUT NOCOPY jtf_number_table,

Line 1615: x_last_update_date OUT NOCOPY jtf_date_table,

1611: /*-- The following output parameters are ignored
1612: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
1613: x_creation_date OUT NOCOPY jtf_date_table,
1614: x_created_by OUT NOCOPY jtf_number_table,
1615: x_last_update_date OUT NOCOPY jtf_date_table,
1616: x_last_updated_by OUT NOCOPY jtf_number_table,
1617: x_last_update_login OUT NOCOPY jtf_number_table,
1618: x_request_id OUT NOCOPY jtf_number_table,
1619: x_program_application_id OUT NOCOPY jtf_number_table,

Line 1621: x_program_update_date OUT NOCOPY jtf_date_table,

1617: x_last_update_login OUT NOCOPY jtf_number_table,
1618: x_request_id OUT NOCOPY jtf_number_table,
1619: x_program_application_id OUT NOCOPY jtf_number_table,
1620: x_program_id OUT NOCOPY jtf_number_table,
1621: x_program_update_date OUT NOCOPY jtf_date_table,
1622: x_quote_line_id OUT NOCOPY jtf_number_table,
1623: x_qte_line_index OUT NOCOPY jtf_number_table,
1624: x_related_quote_line_id OUT NOCOPY jtf_number_table,
1625: x_related_qte_line_index OUT NOCOPY jtf_number_table,

Line 1639: x_creation_date OUT NOCOPY jtf_date_table,

1635: /*-- The following output parameters are ignored
1636: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
1637: x_qte_line_index OUT NOCOPY jtf_number_table,
1638: x_shipment_index OUT NOCOPY jtf_number_table,
1639: x_creation_date OUT NOCOPY jtf_date_table,
1640: x_created_by OUT NOCOPY jtf_number_table,
1641: x_last_update_date OUT NOCOPY jtf_date_table,
1642: x_last_updated_by OUT NOCOPY jtf_number_table,
1643: x_last_update_login OUT NOCOPY jtf_number_table,

Line 1641: x_last_update_date OUT NOCOPY jtf_date_table,

1637: x_qte_line_index OUT NOCOPY jtf_number_table,
1638: x_shipment_index OUT NOCOPY jtf_number_table,
1639: x_creation_date OUT NOCOPY jtf_date_table,
1640: x_created_by OUT NOCOPY jtf_number_table,
1641: x_last_update_date OUT NOCOPY jtf_date_table,
1642: x_last_updated_by OUT NOCOPY jtf_number_table,
1643: x_last_update_login OUT NOCOPY jtf_number_table,
1644: x_request_id OUT NOCOPY jtf_number_table,
1645: x_program_application_id OUT NOCOPY jtf_number_table,

Line 1647: x_program_update_date OUT NOCOPY jtf_date_table,

1643: x_last_update_login OUT NOCOPY jtf_number_table,
1644: x_request_id OUT NOCOPY jtf_number_table,
1645: x_program_application_id OUT NOCOPY jtf_number_table,
1646: x_program_id OUT NOCOPY jtf_number_table,
1647: x_program_update_date OUT NOCOPY jtf_date_table,
1648: x_quote_header_id OUT NOCOPY jtf_number_table,
1649: x_quote_line_id OUT NOCOPY jtf_number_table,
1650: x_quote_shipment_id OUT NOCOPY jtf_number_table,
1651: x_payment_type_code OUT NOCOPY jtf_varchar2_table_100,

Line 1657: x_credit_card_exp_date OUT NOCOPY jtf_date_table,

1653: x_payment_option OUT NOCOPY jtf_varchar2_table_300,
1654: x_payment_term_id OUT NOCOPY jtf_number_table,
1655: x_credit_card_code OUT NOCOPY jtf_varchar2_table_100,
1656: x_credit_card_holder_name OUT NOCOPY jtf_varchar2_table_100,
1657: x_credit_card_exp_date OUT NOCOPY jtf_date_table,
1658: x_credit_card_approval_code OUT NOCOPY jtf_varchar2_table_100,
1659: x_credit_card_approval_date OUT NOCOPY jtf_date_table,
1660: x_payment_amount OUT NOCOPY jtf_number_table,
1661: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,

Line 1659: x_credit_card_approval_date OUT NOCOPY jtf_date_table,

1655: x_credit_card_code OUT NOCOPY jtf_varchar2_table_100,
1656: x_credit_card_holder_name OUT NOCOPY jtf_varchar2_table_100,
1657: x_credit_card_exp_date OUT NOCOPY jtf_date_table,
1658: x_credit_card_approval_code OUT NOCOPY jtf_varchar2_table_100,
1659: x_credit_card_approval_date OUT NOCOPY jtf_date_table,
1660: x_payment_amount OUT NOCOPY jtf_number_table,
1661: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
1662: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
1663: x_attribute2 OUT NOCOPY jtf_varchar2_table_200,

Line 1688: x_creation_date OUT NOCOPY jtf_date_table,

1684:
1685: /*-- The following output parameters are ignored
1686: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
1687: x_qte_line_index OUT NOCOPY jtf_number_table,
1688: x_creation_date OUT NOCOPY jtf_date_table,
1689: x_created_by OUT NOCOPY jtf_number_table,
1690: x_last_update_date OUT NOCOPY jtf_date_table,
1691: x_last_updated_by OUT NOCOPY jtf_number_table,
1692: x_last_update_login OUT NOCOPY jtf_number_table,

Line 1690: x_last_update_date OUT NOCOPY jtf_date_table,

1686: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
1687: x_qte_line_index OUT NOCOPY jtf_number_table,
1688: x_creation_date OUT NOCOPY jtf_date_table,
1689: x_created_by OUT NOCOPY jtf_number_table,
1690: x_last_update_date OUT NOCOPY jtf_date_table,
1691: x_last_updated_by OUT NOCOPY jtf_number_table,
1692: x_last_update_login OUT NOCOPY jtf_number_table,
1693: x_request_id OUT NOCOPY jtf_number_table,
1694: x_program_application_id OUT NOCOPY jtf_number_table,

Line 1696: x_program_update_date OUT NOCOPY jtf_date_table,

1692: x_last_update_login OUT NOCOPY jtf_number_table,
1693: x_request_id OUT NOCOPY jtf_number_table,
1694: x_program_application_id OUT NOCOPY jtf_number_table,
1695: x_program_id OUT NOCOPY jtf_number_table,
1696: x_program_update_date OUT NOCOPY jtf_date_table,
1697: x_quote_header_id OUT NOCOPY jtf_number_table,
1698: x_quote_line_id OUT NOCOPY jtf_number_table,
1699: x_promise_date OUT NOCOPY jtf_date_table,
1700: x_request_date OUT NOCOPY jtf_date_table,

Line 1699: x_promise_date OUT NOCOPY jtf_date_table,

1695: x_program_id OUT NOCOPY jtf_number_table,
1696: x_program_update_date OUT NOCOPY jtf_date_table,
1697: x_quote_header_id OUT NOCOPY jtf_number_table,
1698: x_quote_line_id OUT NOCOPY jtf_number_table,
1699: x_promise_date OUT NOCOPY jtf_date_table,
1700: x_request_date OUT NOCOPY jtf_date_table,
1701: x_schedule_ship_date OUT NOCOPY jtf_date_table,
1702: x_ship_to_party_site_id OUT NOCOPY jtf_number_table,
1703: x_ship_to_party_id OUT NOCOPY jtf_number_table,

Line 1700: x_request_date OUT NOCOPY jtf_date_table,

1696: x_program_update_date OUT NOCOPY jtf_date_table,
1697: x_quote_header_id OUT NOCOPY jtf_number_table,
1698: x_quote_line_id OUT NOCOPY jtf_number_table,
1699: x_promise_date OUT NOCOPY jtf_date_table,
1700: x_request_date OUT NOCOPY jtf_date_table,
1701: x_schedule_ship_date OUT NOCOPY jtf_date_table,
1702: x_ship_to_party_site_id OUT NOCOPY jtf_number_table,
1703: x_ship_to_party_id OUT NOCOPY jtf_number_table,
1704: x_ship_to_cust_account_id OUT NOCOPY jtf_number_table,

Line 1701: x_schedule_ship_date OUT NOCOPY jtf_date_table,

1697: x_quote_header_id OUT NOCOPY jtf_number_table,
1698: x_quote_line_id OUT NOCOPY jtf_number_table,
1699: x_promise_date OUT NOCOPY jtf_date_table,
1700: x_request_date OUT NOCOPY jtf_date_table,
1701: x_schedule_ship_date OUT NOCOPY jtf_date_table,
1702: x_ship_to_party_site_id OUT NOCOPY jtf_number_table,
1703: x_ship_to_party_id OUT NOCOPY jtf_number_table,
1704: x_ship_to_cust_account_id OUT NOCOPY jtf_number_table,
1705: x_ship_partial_flag OUT NOCOPY jtf_varchar2_table_300,

Line 1766: x_creation_date OUT NOCOPY jtf_date_table,

1762: x_shipment_index OUT NOCOPY jtf_number_table,
1763: x_quote_header_id OUT NOCOPY jtf_number_table,
1764: x_quote_line_id OUT NOCOPY jtf_number_table,
1765: x_quote_shipment_id OUT NOCOPY jtf_number_table,
1766: x_creation_date OUT NOCOPY jtf_date_table,
1767: x_created_by OUT NOCOPY jtf_number_table,
1768: x_last_update_date OUT NOCOPY jtf_date_table,
1769: x_last_updated_by OUT NOCOPY jtf_number_table,
1770: x_last_update_login OUT NOCOPY jtf_number_table,

Line 1768: x_last_update_date OUT NOCOPY jtf_date_table,

1764: x_quote_line_id OUT NOCOPY jtf_number_table,
1765: x_quote_shipment_id OUT NOCOPY jtf_number_table,
1766: x_creation_date OUT NOCOPY jtf_date_table,
1767: x_created_by OUT NOCOPY jtf_number_table,
1768: x_last_update_date OUT NOCOPY jtf_date_table,
1769: x_last_updated_by OUT NOCOPY jtf_number_table,
1770: x_last_update_login OUT NOCOPY jtf_number_table,
1771: x_request_id OUT NOCOPY jtf_number_table,
1772: x_program_application_id OUT NOCOPY jtf_number_table,

Line 1774: x_program_update_date OUT NOCOPY jtf_date_table,

1770: x_last_update_login OUT NOCOPY jtf_number_table,
1771: x_request_id OUT NOCOPY jtf_number_table,
1772: x_program_application_id OUT NOCOPY jtf_number_table,
1773: x_program_id OUT NOCOPY jtf_number_table,
1774: x_program_update_date OUT NOCOPY jtf_date_table,
1775: x_orig_tax_code OUT NOCOPY jtf_varchar2_table_300,
1776: x_tax_code OUT NOCOPY jtf_varchar2_table_100,
1777: x_tax_rate OUT NOCOPY jtf_number_table,
1778: x_tax_date OUT NOCOPY jtf_date_table,

Line 1778: x_tax_date OUT NOCOPY jtf_date_table,

1774: x_program_update_date OUT NOCOPY jtf_date_table,
1775: x_orig_tax_code OUT NOCOPY jtf_varchar2_table_300,
1776: x_tax_code OUT NOCOPY jtf_varchar2_table_100,
1777: x_tax_rate OUT NOCOPY jtf_number_table,
1778: x_tax_date OUT NOCOPY jtf_date_table,
1779: x_tax_amount OUT NOCOPY jtf_number_table,
1780: x_tax_exempt_flag OUT NOCOPY jtf_varchar2_table_100,
1781: x_tax_exempt_number OUT NOCOPY jtf_varchar2_table_100,
1782: x_tax_exempt_reason_code OUT NOCOPY jtf_varchar2_table_100,

Line 1810: x_creation_date OUT NOCOPY jtf_date_table,

1806: /*-- The following output parameters are ignored
1807: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
1808: x_qte_line_index OUT NOCOPY jtf_number_table,
1809: x_shipment_index OUT NOCOPY jtf_number_table,
1810: x_creation_date OUT NOCOPY jtf_date_table,
1811: x_created_by OUT NOCOPY jtf_number_table,
1812: x_last_update_date OUT NOCOPY jtf_date_table,
1813: x_last_updated_by OUT NOCOPY jtf_number_table,
1814: x_last_update_login OUT NOCOPY jtf_number_table,

Line 1812: x_last_update_date OUT NOCOPY jtf_date_table,

1808: x_qte_line_index OUT NOCOPY jtf_number_table,
1809: x_shipment_index OUT NOCOPY jtf_number_table,
1810: x_creation_date OUT NOCOPY jtf_date_table,
1811: x_created_by OUT NOCOPY jtf_number_table,
1812: x_last_update_date OUT NOCOPY jtf_date_table,
1813: x_last_updated_by OUT NOCOPY jtf_number_table,
1814: x_last_update_login OUT NOCOPY jtf_number_table,
1815: x_program_application_id OUT NOCOPY jtf_number_table,
1816: x_program_id OUT NOCOPY jtf_number_table,

Line 1817: x_program_update_date OUT NOCOPY jtf_date_table,

1813: x_last_updated_by OUT NOCOPY jtf_number_table,
1814: x_last_update_login OUT NOCOPY jtf_number_table,
1815: x_program_application_id OUT NOCOPY jtf_number_table,
1816: x_program_id OUT NOCOPY jtf_number_table,
1817: x_program_update_date OUT NOCOPY jtf_date_table,
1818: x_request_id OUT NOCOPY jtf_number_table,
1819: x_quote_header_id OUT NOCOPY jtf_number_table,
1820: x_quote_line_id OUT NOCOPY jtf_number_table,
1821: x_quote_shipment_id OUT NOCOPY jtf_number_table,

Line 1879: x_expiration_date OUT NOCOPY jtf_date_table,

1875: x_source_system_code OUT NOCOPY jtf_varchar2_table_100,
1876: x_benefit_qty OUT NOCOPY jtf_number_table,
1877: x_benefit_uom_code OUT NOCOPY jtf_varchar2_table_100,
1878: x_print_on_invoice_flag OUT NOCOPY jtf_varchar2_table_100,
1879: x_expiration_date OUT NOCOPY jtf_date_table,
1880: x_rebate_transaction_type_code OUT NOCOPY jtf_varchar2_table_100,
1881: x_rebate_transaction_reference OUT NOCOPY jtf_varchar2_table_100,
1882: x_rebate_payment_system_code OUT NOCOPY jtf_varchar2_table_100,
1883: x_redeemed_date OUT NOCOPY jtf_date_table,

Line 1883: x_redeemed_date OUT NOCOPY jtf_date_table,

1879: x_expiration_date OUT NOCOPY jtf_date_table,
1880: x_rebate_transaction_type_code OUT NOCOPY jtf_varchar2_table_100,
1881: x_rebate_transaction_reference OUT NOCOPY jtf_varchar2_table_100,
1882: x_rebate_payment_system_code OUT NOCOPY jtf_varchar2_table_100,
1883: x_redeemed_date OUT NOCOPY jtf_date_table,
1884: x_redeemed_flag OUT NOCOPY jtf_varchar2_table_100,
1885: x_modifier_level_code OUT NOCOPY jtf_varchar2_table_100,
1886: x_price_break_type_code OUT NOCOPY jtf_varchar2_table_100,
1887: x_substitution_attribute OUT NOCOPY jtf_varchar2_table_100,

Line 1901: x_creation_date OUT NOCOPY jtf_date_table,

1897:
1898: /*-- The following output parameters are ignored
1899: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
1900: x_qte_line_index OUT NOCOPY jtf_number_table,
1901: x_creation_date OUT NOCOPY jtf_date_table,
1902: x_created_by OUT NOCOPY jtf_number_table,
1903: x_last_update_date OUT NOCOPY jtf_date_table,
1904: x_last_updated_by OUT NOCOPY jtf_number_table,
1905: x_last_update_login OUT NOCOPY jtf_number_table,

Line 1903: x_last_update_date OUT NOCOPY jtf_date_table,

1899: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
1900: x_qte_line_index OUT NOCOPY jtf_number_table,
1901: x_creation_date OUT NOCOPY jtf_date_table,
1902: x_created_by OUT NOCOPY jtf_number_table,
1903: x_last_update_date OUT NOCOPY jtf_date_table,
1904: x_last_updated_by OUT NOCOPY jtf_number_table,
1905: x_last_update_login OUT NOCOPY jtf_number_table,
1906: x_request_id OUT NOCOPY jtf_number_table,
1907: x_program_application_id OUT NOCOPY jtf_number_table,

Line 1909: x_program_update_date OUT NOCOPY jtf_date_table,

1905: x_last_update_login OUT NOCOPY jtf_number_table,
1906: x_request_id OUT NOCOPY jtf_number_table,
1907: x_program_application_id OUT NOCOPY jtf_number_table,
1908: x_program_id OUT NOCOPY jtf_number_table,
1909: x_program_update_date OUT NOCOPY jtf_date_table,
1910: x_quote_header_id OUT NOCOPY jtf_number_table,
1911: x_quote_line_id OUT NOCOPY jtf_number_table,
1912: x_flex_title OUT NOCOPY jtf_varchar2_table_100,
1913: x_pricing_context OUT NOCOPY jtf_varchar2_table_100,

Line 2040: x_creation_date OUT NOCOPY jtf_date_table,

2036:
2037: /*-- The following output parameters are ignored
2038: x_qte_line_index OUT NOCOPY jtf_number_table,
2039: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
2040: x_creation_date OUT NOCOPY jtf_date_table,
2041: x_created_by OUT NOCOPY jtf_number_table,
2042: x_last_updated_by OUT NOCOPY jtf_number_table,
2043: x_last_update_date OUT NOCOPY jtf_date_table,
2044: x_last_update_login OUT NOCOPY jtf_number_table,

Line 2043: x_last_update_date OUT NOCOPY jtf_date_table,

2039: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
2040: x_creation_date OUT NOCOPY jtf_date_table,
2041: x_created_by OUT NOCOPY jtf_number_table,
2042: x_last_updated_by OUT NOCOPY jtf_number_table,
2043: x_last_update_date OUT NOCOPY jtf_date_table,
2044: x_last_update_login OUT NOCOPY jtf_number_table,
2045: x_request_id OUT NOCOPY jtf_number_table,
2046: x_program_application_id OUT NOCOPY jtf_number_table,
2047: x_program_id OUT NOCOPY jtf_number_table,

Line 2048: x_program_update_date OUT NOCOPY jtf_date_table,

2044: x_last_update_login OUT NOCOPY jtf_number_table,
2045: x_request_id OUT NOCOPY jtf_number_table,
2046: x_program_application_id OUT NOCOPY jtf_number_table,
2047: x_program_id OUT NOCOPY jtf_number_table,
2048: x_program_update_date OUT NOCOPY jtf_date_table,
2049: x_quote_header_id OUT NOCOPY jtf_number_table,
2050: x_quote_line_id OUT NOCOPY jtf_number_table,
2051: x_percent OUT NOCOPY jtf_number_table,
2052: x_resource_id OUT NOCOPY jtf_number_table,

Line 2089: x_date_sent OUT NOCOPY jtf_date_table,

2085: x_approver_sequence OUT NOCOPY jtf_number_table,
2086: x_approver_status OUT NOCOPY jtf_varchar2_table_100,
2087: x_approver_name OUT NOCOPY jtf_varchar2_table_100,
2088: x_approval_comments OUT NOCOPY jtf_varchar2_table_300,
2089: x_date_sent OUT NOCOPY jtf_date_table,
2090: x_date_received OUT NOCOPY jtf_date_table
2091: );
2092:
2093: PROCEDURE Set_Rules_List_Tbl_Out(

Line 2090: x_date_received OUT NOCOPY jtf_date_table

2086: x_approver_status OUT NOCOPY jtf_varchar2_table_100,
2087: x_approver_name OUT NOCOPY jtf_varchar2_table_100,
2088: x_approval_comments OUT NOCOPY jtf_varchar2_table_300,
2089: x_date_sent OUT NOCOPY jtf_date_table,
2090: x_date_received OUT NOCOPY jtf_date_table
2091: );
2092:
2093: PROCEDURE Set_Rules_List_Tbl_Out(
2094: p_qte_rules_list_tbl IN ASO_Apr_Pub.Rules_List_Tbl_Type,

Line 2137: x_requested_ship_date OUT NOCOPY JTF_DATE_TABLE,

2133: x_customer_site_id OUT NOCOPY JTF_NUMBER_TABLE,
2134: x_quantity_ordered OUT NOCOPY JTF_NUMBER_TABLE,
2135: x_quantity_uom OUT NOCOPY JTF_VARCHAR2_TABLE_100,
2136: x_uom_meaning OUT NOCOPY JTF_VARCHAR2_TABLE_100,
2137: x_requested_ship_date OUT NOCOPY JTF_DATE_TABLE,
2138: x_ship_date OUT NOCOPY JTF_DATE_TABLE,
2139: x_available_quantity OUT NOCOPY JTF_NUMBER_TABLE,
2140: x_request_date_quantity OUT NOCOPY JTF_NUMBER_TABLE,
2141: x_error_code OUT NOCOPY JTF_NUMBER_TABLE,

Line 2138: x_ship_date OUT NOCOPY JTF_DATE_TABLE,

2134: x_quantity_ordered OUT NOCOPY JTF_NUMBER_TABLE,
2135: x_quantity_uom OUT NOCOPY JTF_VARCHAR2_TABLE_100,
2136: x_uom_meaning OUT NOCOPY JTF_VARCHAR2_TABLE_100,
2137: x_requested_ship_date OUT NOCOPY JTF_DATE_TABLE,
2138: x_ship_date OUT NOCOPY JTF_DATE_TABLE,
2139: x_available_quantity OUT NOCOPY JTF_NUMBER_TABLE,
2140: x_request_date_quantity OUT NOCOPY JTF_NUMBER_TABLE,
2141: x_error_code OUT NOCOPY JTF_NUMBER_TABLE,
2142: x_message OUT NOCOPY JTF_VARCHAR2_TABLE_2000,

Line 2150: x_group_ship_date OUT NOCOPY jtf_date_table,

2146: x_demand_class_meaning OUT NOCOPY jtf_varchar2_table_300,
2147: x_ship_set_name OUT NOCOPY jtf_varchar2_table_300,
2148: x_arrival_set_name OUT NOCOPY jtf_varchar2_table_300,
2149: x_line_number OUT NOCOPY jtf_varchar2_table_800,
2150: x_group_ship_date OUT NOCOPY jtf_date_table,
2151: x_requested_arrival_date OUT NOCOPY jtf_date_table,
2152: x_ship_method_code OUT NOCOPY jtf_varchar2_table_300,
2153: x_ship_method_meaning OUT NOCOPY jtf_varchar2_table_300,
2154: x_quantity_on_hand OUT NOCOPY jtf_number_table,

Line 2151: x_requested_arrival_date OUT NOCOPY jtf_date_table,

2147: x_ship_set_name OUT NOCOPY jtf_varchar2_table_300,
2148: x_arrival_set_name OUT NOCOPY jtf_varchar2_table_300,
2149: x_line_number OUT NOCOPY jtf_varchar2_table_800,
2150: x_group_ship_date OUT NOCOPY jtf_date_table,
2151: x_requested_arrival_date OUT NOCOPY jtf_date_table,
2152: x_ship_method_code OUT NOCOPY jtf_varchar2_table_300,
2153: x_ship_method_meaning OUT NOCOPY jtf_varchar2_table_300,
2154: x_quantity_on_hand OUT NOCOPY jtf_number_table,
2155: x_quote_header_id OUT NOCOPY jtf_number_table,

Line 2162: x_arrival_date OUT NOCOPY jtf_date_table,

2158: x_ato_line_id OUT NOCOPY jtf_number_table,
2159: x_ref_line_id OUT NOCOPY jtf_number_table,
2160: x_top_model_line_id OUT NOCOPY jtf_number_table,
2161: x_action OUT NOCOPY jtf_number_table,
2162: x_arrival_date OUT NOCOPY jtf_date_table,
2163: x_organization_id OUT NOCOPY jtf_number_table,
2164: x_component_code OUT NOCOPY jtf_varchar2_table_1200,
2165: x_component_sequence_id OUT NOCOPY jtf_number_table,
2166: x_included_item_flag OUT NOCOPY jtf_number_table,

Line 2657: p_CREATION_DATE IN jtf_date_table := null,

2653:
2654: FUNCTION Construct_Related_Obj_Tbl(
2655: p_operation_code IN jtf_varchar2_table_100 := NULL,
2656: p_RELATED_OBJECT_ID IN jtf_number_table := NULL,
2657: p_CREATION_DATE IN jtf_date_table := null,
2658: p_CREATED_BY IN jtf_number_table := NULL,
2659: p_LAST_UPDATE_DATE IN jtf_date_table := null,
2660: p_LAST_UPDATED_BY IN jtf_number_table := NULL,
2661: p_LAST_UPDATE_LOGIN IN jtf_number_table := NULL,

Line 2659: p_LAST_UPDATE_DATE IN jtf_date_table := null,

2655: p_operation_code IN jtf_varchar2_table_100 := NULL,
2656: p_RELATED_OBJECT_ID IN jtf_number_table := NULL,
2657: p_CREATION_DATE IN jtf_date_table := null,
2658: p_CREATED_BY IN jtf_number_table := NULL,
2659: p_LAST_UPDATE_DATE IN jtf_date_table := null,
2660: p_LAST_UPDATED_BY IN jtf_number_table := NULL,
2661: p_LAST_UPDATE_LOGIN IN jtf_number_table := NULL,
2662: p_REQUEST_ID IN jtf_number_table := NULL,
2663: p_PROGRAM_APPLICATION_ID IN jtf_number_table := NULL,

Line 2665: p_PROGRAM_UPDATE_DATE IN jtf_date_table := null,

2661: p_LAST_UPDATE_LOGIN IN jtf_number_table := NULL,
2662: p_REQUEST_ID IN jtf_number_table := NULL,
2663: p_PROGRAM_APPLICATION_ID IN jtf_number_table := NULL,
2664: p_PROGRAM_ID IN jtf_number_table := NULL,
2665: p_PROGRAM_UPDATE_DATE IN jtf_date_table := null,
2666: p_QUOTE_OBJECT_TYPE_CODE IN jtf_varchar2_table_300 := NULL,
2667: p_QUOTE_OBJECT_ID IN jtf_number_table := NULL,
2668: p_OBJECT_TYPE_CODE IN jtf_varchar2_table_300 := NULL,
2669: p_OBJECT_ID IN jtf_number_table := NULL,