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 1080: p_creation_date IN jtf_date_table := NULL,

1076: END Construct_Qte_Line_Rec;
1077:
1078: -- there IS total 71 fields here IN line
1079: FUNCTION Construct_Qte_Line_Tbl(
1080: p_creation_date IN jtf_date_table := NULL,
1081: p_created_by IN jtf_number_table := NULL,
1082: p_last_updated_by IN jtf_number_table := NULL,
1083: p_last_update_date IN jtf_date_table := NULL,
1084: p_last_update_login IN jtf_number_table := NULL,

Line 1083: p_last_update_date IN jtf_date_table := NULL,

1079: FUNCTION Construct_Qte_Line_Tbl(
1080: p_creation_date IN jtf_date_table := NULL,
1081: p_created_by IN jtf_number_table := NULL,
1082: p_last_updated_by IN jtf_number_table := NULL,
1083: p_last_update_date IN jtf_date_table := NULL,
1084: p_last_update_login IN jtf_number_table := NULL,
1085: p_request_id IN jtf_number_table := NULL,
1086: p_program_application_id IN jtf_number_table := NULL,
1087: p_program_id IN jtf_number_table := NULL,

Line 1088: p_program_update_date IN jtf_date_table := NULL,

1084: p_last_update_login IN jtf_number_table := NULL,
1085: p_request_id IN jtf_number_table := NULL,
1086: p_program_application_id IN jtf_number_table := NULL,
1087: p_program_id IN jtf_number_table := NULL,
1088: p_program_update_date IN jtf_date_table := NULL,
1089: p_quote_line_id IN jtf_number_table := NULL,
1090: p_quote_header_id IN jtf_number_table := NULL,
1091: p_org_id IN jtf_number_table := NULL,
1092: p_line_number IN jtf_number_table := NULL,

Line 1099: p_start_date_active IN jtf_date_table := NULL,

1095: p_inventory_item_id IN jtf_number_table := NULL,
1096: p_organization_id IN jtf_number_table := NULL,
1097: p_quantity IN jtf_number_table := NULL,
1098: p_uom_code IN jtf_varchar2_table_100 := NULL,
1099: p_start_date_active IN jtf_date_table := NULL,
1100: p_end_date_active IN jtf_date_table := NULL,
1101: p_order_line_type_id IN jtf_number_table := NULL,
1102: p_price_list_id IN jtf_number_table := NULL,
1103: p_price_list_line_id IN jtf_number_table := NULL,

Line 1100: p_end_date_active IN jtf_date_table := NULL,

1096: p_organization_id IN jtf_number_table := NULL,
1097: p_quantity IN jtf_number_table := NULL,
1098: p_uom_code IN jtf_varchar2_table_100 := NULL,
1099: p_start_date_active IN jtf_date_table := NULL,
1100: p_end_date_active IN jtf_date_table := NULL,
1101: p_order_line_type_id IN jtf_number_table := NULL,
1102: p_price_list_id IN jtf_number_table := NULL,
1103: p_price_list_line_id IN jtf_number_table := NULL,
1104: p_currency_code IN jtf_varchar2_table_100 := NULL,

Line 1966: p_creation_date IN jtf_date_table := NULL,

1962:
1963: -- there IS total 71 fields here IN line
1964: FUNCTION Construct_Qte_Line_Dtl_Tbl(
1965: p_quote_line_detail_id IN jtf_number_table := NULL,
1966: p_creation_date IN jtf_date_table := NULL,
1967: p_created_by IN jtf_number_table := NULL,
1968: p_last_update_date IN jtf_date_table := NULL,
1969: p_last_updated_by IN jtf_number_table := NULL,
1970: p_last_update_login IN jtf_number_table := NULL,

Line 1968: p_last_update_date IN jtf_date_table := NULL,

1964: FUNCTION Construct_Qte_Line_Dtl_Tbl(
1965: p_quote_line_detail_id IN jtf_number_table := NULL,
1966: p_creation_date IN jtf_date_table := NULL,
1967: p_created_by IN jtf_number_table := NULL,
1968: p_last_update_date IN jtf_date_table := NULL,
1969: p_last_updated_by IN jtf_number_table := NULL,
1970: p_last_update_login IN jtf_number_table := NULL,
1971: p_request_id IN jtf_number_table := NULL,
1972: p_program_application_id IN jtf_number_table := NULL,

Line 1974: p_program_update_date IN jtf_date_table := NULL,

1970: p_last_update_login IN jtf_number_table := NULL,
1971: p_request_id IN jtf_number_table := NULL,
1972: p_program_application_id IN jtf_number_table := NULL,
1973: p_program_id IN jtf_number_table := NULL,
1974: p_program_update_date IN jtf_date_table := NULL,
1975: p_quote_line_id IN jtf_number_table := NULL,
1976: p_config_header_id IN jtf_number_table := NULL,
1977: p_config_revision_num IN jtf_number_table := NULL,
1978: p_config_item_id IN jtf_number_table := NULL,

Line 2464: p_creation_date IN jtf_date_table := NULL,

2460:
2461: -- there IS total 17 fields here IN line
2462: FUNCTION Construct_Line_Rltship_Tbl(
2463: p_line_relationship_id IN jtf_number_table := NULL,
2464: p_creation_date IN jtf_date_table := NULL,
2465: p_created_by IN jtf_number_table := NULL,
2466: p_last_updated_by IN jtf_number_table := NULL,
2467: p_last_update_date IN jtf_date_table := NULL,
2468: p_last_update_login IN jtf_number_table := NULL,

Line 2467: p_last_update_date IN jtf_date_table := NULL,

2463: p_line_relationship_id IN jtf_number_table := NULL,
2464: p_creation_date IN jtf_date_table := NULL,
2465: p_created_by IN jtf_number_table := NULL,
2466: p_last_updated_by IN jtf_number_table := NULL,
2467: p_last_update_date IN jtf_date_table := NULL,
2468: p_last_update_login IN jtf_number_table := NULL,
2469: p_request_id IN jtf_number_table := NULL,
2470: p_program_application_id IN jtf_number_table := NULL,
2471: p_program_id IN jtf_number_table := NULL,

Line 2472: p_program_update_date IN jtf_date_table := NULL,

2468: p_last_update_login IN jtf_number_table := NULL,
2469: p_request_id IN jtf_number_table := NULL,
2470: p_program_application_id IN jtf_number_table := NULL,
2471: p_program_id IN jtf_number_table := NULL,
2472: p_program_update_date IN jtf_date_table := NULL,
2473: p_quote_line_id IN jtf_number_table := NULL,
2474: p_related_quote_line_id IN jtf_number_table := NULL,
2475: p_relationship_type_code IN jtf_varchar2_table_100 := NULL,
2476: p_reciprocal_flag IN jtf_varchar2_table_100 := NULL,

Line 2622: p_creation_date IN jtf_date_table := NULL,

2618: FUNCTION Construct_Payment_Tbl(
2619: p_operation_code IN jtf_varchar2_table_100 := NULL,
2620: p_qte_line_index IN jtf_number_table := NULL,
2621: p_payment_id IN jtf_number_table := NULL,
2622: p_creation_date IN jtf_date_table := NULL,
2623: p_created_by IN jtf_number_table := NULL,
2624: p_last_update_date IN jtf_date_table := NULL,
2625: p_last_updated_by IN jtf_number_table := NULL,
2626: p_last_update_login IN jtf_number_table := NULL,

Line 2624: p_last_update_date IN jtf_date_table := NULL,

2620: p_qte_line_index IN jtf_number_table := NULL,
2621: p_payment_id IN jtf_number_table := NULL,
2622: p_creation_date IN jtf_date_table := NULL,
2623: p_created_by IN jtf_number_table := NULL,
2624: p_last_update_date IN jtf_date_table := NULL,
2625: p_last_updated_by IN jtf_number_table := NULL,
2626: p_last_update_login IN jtf_number_table := NULL,
2627: p_request_id IN jtf_number_table := NULL,
2628: p_program_application_id IN jtf_number_table := NULL,

Line 2630: p_program_update_date IN jtf_date_table := NULL,

2626: p_last_update_login IN jtf_number_table := NULL,
2627: p_request_id IN jtf_number_table := NULL,
2628: p_program_application_id IN jtf_number_table := NULL,
2629: p_program_id IN jtf_number_table := NULL,
2630: p_program_update_date IN jtf_date_table := NULL,
2631: p_quote_header_id IN jtf_number_table := NULL,
2632: p_quote_line_id IN jtf_number_table := NULL,
2633: p_payment_type_code IN jtf_varchar2_table_100 := NULL,
2634: p_payment_ref_number IN jtf_varchar2_table_300 := NULL,

Line 2639: p_credit_card_exp_date IN jtf_date_table := NULL,

2635: p_payment_option IN jtf_varchar2_table_300 := NULL,
2636: p_payment_term_id IN jtf_number_table := NULL,
2637: p_credit_card_code IN jtf_varchar2_table_100 := NULL,
2638: p_credit_card_holder_name IN jtf_varchar2_table_100 := NULL,
2639: p_credit_card_exp_date IN jtf_date_table := NULL,
2640: p_credit_card_approval_code IN jtf_varchar2_table_100 := NULL,
2641: p_credit_card_approval_date IN jtf_date_table := NULL,
2642: p_payment_amount IN jtf_number_table := NULL,
2643: p_attribute_category IN jtf_varchar2_table_100 := NULL,

Line 2641: p_credit_card_approval_date IN jtf_date_table := NULL,

2637: p_credit_card_code IN jtf_varchar2_table_100 := NULL,
2638: p_credit_card_holder_name IN jtf_varchar2_table_100 := NULL,
2639: p_credit_card_exp_date IN jtf_date_table := NULL,
2640: p_credit_card_approval_code IN jtf_varchar2_table_100 := NULL,
2641: p_credit_card_approval_date IN jtf_date_table := NULL,
2642: p_payment_amount IN jtf_number_table := NULL,
2643: p_attribute_category IN jtf_varchar2_table_100 := NULL,
2644: p_attribute1 IN jtf_varchar2_table_300 := NULL,
2645: p_attribute2 IN jtf_varchar2_table_300 := NULL,

Line 3518: p_creation_date IN jtf_date_table := NULL,

3514: FUNCTION Construct_Shipment_Tbl(
3515: p_operation_code IN jtf_varchar2_table_100 := NULL,
3516: p_qte_line_index IN jtf_number_table := NULL,
3517: p_shipment_id IN jtf_number_table := NULL,
3518: p_creation_date IN jtf_date_table := NULL,
3519: p_created_by IN jtf_number_table := NULL,
3520: p_last_update_date IN jtf_date_table := NULL,
3521: p_last_updated_by IN jtf_number_table := NULL,
3522: p_last_update_login IN jtf_number_table := NULL,

Line 3520: p_last_update_date IN jtf_date_table := NULL,

3516: p_qte_line_index IN jtf_number_table := NULL,
3517: p_shipment_id IN jtf_number_table := NULL,
3518: p_creation_date IN jtf_date_table := NULL,
3519: p_created_by IN jtf_number_table := NULL,
3520: p_last_update_date IN jtf_date_table := NULL,
3521: p_last_updated_by IN jtf_number_table := NULL,
3522: p_last_update_login IN jtf_number_table := NULL,
3523: p_request_id IN jtf_number_table := NULL,
3524: p_program_application_id IN jtf_number_table := NULL,

Line 3526: p_program_update_date IN jtf_date_table := NULL,

3522: p_last_update_login IN jtf_number_table := NULL,
3523: p_request_id IN jtf_number_table := NULL,
3524: p_program_application_id IN jtf_number_table := NULL,
3525: p_program_id IN jtf_number_table := NULL,
3526: p_program_update_date IN jtf_date_table := NULL,
3527: p_quote_header_id IN jtf_number_table := NULL,
3528: p_quote_line_id IN jtf_number_table := NULL,
3529: p_promise_date IN jtf_date_table := NULL,
3530: p_request_date IN jtf_date_table := NULL,

Line 3529: p_promise_date IN jtf_date_table := NULL,

3525: p_program_id IN jtf_number_table := NULL,
3526: p_program_update_date IN jtf_date_table := NULL,
3527: p_quote_header_id IN jtf_number_table := NULL,
3528: p_quote_line_id IN jtf_number_table := NULL,
3529: p_promise_date IN jtf_date_table := NULL,
3530: p_request_date IN jtf_date_table := NULL,
3531: p_schedule_ship_date IN jtf_date_table := NULL,
3532: p_ship_to_party_site_id IN jtf_number_table := NULL,
3533: p_ship_to_party_id IN jtf_number_table := NULL,

Line 3530: p_request_date IN jtf_date_table := NULL,

3526: p_program_update_date IN jtf_date_table := NULL,
3527: p_quote_header_id IN jtf_number_table := NULL,
3528: p_quote_line_id IN jtf_number_table := NULL,
3529: p_promise_date IN jtf_date_table := NULL,
3530: p_request_date IN jtf_date_table := NULL,
3531: p_schedule_ship_date IN jtf_date_table := NULL,
3532: p_ship_to_party_site_id IN jtf_number_table := NULL,
3533: p_ship_to_party_id IN jtf_number_table := NULL,
3534: p_ship_to_cust_account_id IN jtf_number_table := NULL,

Line 3531: p_schedule_ship_date IN jtf_date_table := NULL,

3527: p_quote_header_id IN jtf_number_table := NULL,
3528: p_quote_line_id IN jtf_number_table := NULL,
3529: p_promise_date IN jtf_date_table := NULL,
3530: p_request_date IN jtf_date_table := NULL,
3531: p_schedule_ship_date IN jtf_date_table := NULL,
3532: p_ship_to_party_site_id IN jtf_number_table := NULL,
3533: p_ship_to_party_id IN jtf_number_table := NULL,
3534: p_ship_to_cust_account_id IN jtf_number_table := NULL,
3535: p_ship_partial_flag IN jtf_varchar2_table_300 := NULL,

Line 3966: p_creation_date IN jtf_date_table := NULL,

3962: p_tax_detail_id IN jtf_number_table := NULL,
3963: p_quote_header_id IN jtf_number_table := NULL,
3964: p_quote_line_id IN jtf_number_table := NULL,
3965: p_quote_shipment_id IN jtf_number_table := NULL,
3966: p_creation_date IN jtf_date_table := NULL,
3967: p_created_by IN jtf_number_table := NULL,
3968: p_last_update_date IN jtf_date_table := NULL,
3969: p_last_updated_by IN jtf_number_table := NULL,
3970: p_last_update_login IN jtf_number_table := NULL,

Line 3968: p_last_update_date IN jtf_date_table := NULL,

3964: p_quote_line_id IN jtf_number_table := NULL,
3965: p_quote_shipment_id IN jtf_number_table := NULL,
3966: p_creation_date IN jtf_date_table := NULL,
3967: p_created_by IN jtf_number_table := NULL,
3968: p_last_update_date IN jtf_date_table := NULL,
3969: p_last_updated_by IN jtf_number_table := NULL,
3970: p_last_update_login IN jtf_number_table := NULL,
3971: p_request_id IN jtf_number_table := NULL,
3972: p_program_application_id IN jtf_number_table := NULL,

Line 3974: p_program_update_date IN jtf_date_table := NULL,

3970: p_last_update_login IN jtf_number_table := NULL,
3971: p_request_id IN jtf_number_table := NULL,
3972: p_program_application_id IN jtf_number_table := NULL,
3973: p_program_id IN jtf_number_table := NULL,
3974: p_program_update_date IN jtf_date_table := NULL,
3975: p_orig_tax_code IN jtf_varchar2_table_300 := NULL,
3976: p_tax_code IN jtf_varchar2_table_100 := NULL,
3977: p_tax_rate IN jtf_number_table := NULL,
3978: p_tax_date IN jtf_date_table := NULL,

Line 3978: p_tax_date IN jtf_date_table := NULL,

3974: p_program_update_date IN jtf_date_table := NULL,
3975: p_orig_tax_code IN jtf_varchar2_table_300 := NULL,
3976: p_tax_code IN jtf_varchar2_table_100 := NULL,
3977: p_tax_rate IN jtf_number_table := NULL,
3978: p_tax_date IN jtf_date_table := NULL,
3979: p_tax_amount IN jtf_number_table := NULL,
3980: p_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,
3981: p_tax_exempt_number IN jtf_varchar2_table_100 := NULL,
3982: p_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,

Line 4494: p_creation_date IN jtf_date_table := NULL,

4490: FUNCTION Construct_Price_Attributes_Tbl(
4491: p_operation_code IN jtf_varchar2_table_100 := NULL,
4492: p_qte_line_index IN jtf_number_table := NULL,
4493: p_price_attribute_id IN jtf_number_table := NULL,
4494: p_creation_date IN jtf_date_table := NULL,
4495: p_created_by IN jtf_number_table := NULL,
4496: p_last_update_date IN jtf_date_table := NULL,
4497: p_last_updated_by IN jtf_number_table := NULL,
4498: p_last_update_login IN jtf_number_table := NULL,

Line 4496: p_last_update_date IN jtf_date_table := NULL,

4492: p_qte_line_index IN jtf_number_table := NULL,
4493: p_price_attribute_id IN jtf_number_table := NULL,
4494: p_creation_date IN jtf_date_table := NULL,
4495: p_created_by IN jtf_number_table := NULL,
4496: p_last_update_date IN jtf_date_table := NULL,
4497: p_last_updated_by IN jtf_number_table := NULL,
4498: p_last_update_login IN jtf_number_table := NULL,
4499: p_request_id IN jtf_number_table := NULL,
4500: p_program_application_id IN jtf_number_table := NULL,

Line 4502: p_program_update_date IN jtf_date_table := NULL,

4498: p_last_update_login IN jtf_number_table := NULL,
4499: p_request_id IN jtf_number_table := NULL,
4500: p_program_application_id IN jtf_number_table := NULL,
4501: p_program_id IN jtf_number_table := NULL,
4502: p_program_update_date IN jtf_date_table := NULL,
4503: p_quote_header_id IN jtf_number_table := NULL,
4504: p_quote_line_id IN jtf_number_table := NULL,
4505: p_flex_title IN jtf_varchar2_table_100 := NULL,
4506: p_pricing_context IN jtf_varchar2_table_100 := NULL,

Line 5127: p_creation_date IN jtf_date_table := NULL,

5123: FUNCTION Construct_Price_Adj_Tbl(
5124: p_operation_code IN jtf_varchar2_table_100 := NULL,
5125: p_qte_line_index IN jtf_number_table := NULL,
5126: p_price_adjustment_id IN jtf_number_table := NULL,
5127: p_creation_date IN jtf_date_table := NULL,
5128: p_created_by IN jtf_number_table := NULL,
5129: p_last_update_date IN jtf_date_table := NULL,
5130: p_last_updated_by IN jtf_number_table := NULL,
5131: p_last_update_login IN jtf_number_table := NULL,

Line 5129: p_last_update_date IN jtf_date_table := NULL,

5125: p_qte_line_index IN jtf_number_table := NULL,
5126: p_price_adjustment_id IN jtf_number_table := NULL,
5127: p_creation_date IN jtf_date_table := NULL,
5128: p_created_by IN jtf_number_table := NULL,
5129: p_last_update_date IN jtf_date_table := NULL,
5130: p_last_updated_by IN jtf_number_table := NULL,
5131: p_last_update_login IN jtf_number_table := NULL,
5132: p_program_application_id IN jtf_number_table := NULL,
5133: p_program_id IN jtf_number_table := NULL,

Line 5134: p_program_update_date IN jtf_date_table := NULL,

5130: p_last_updated_by IN jtf_number_table := NULL,
5131: p_last_update_login IN jtf_number_table := NULL,
5132: p_program_application_id IN jtf_number_table := NULL,
5133: p_program_id IN jtf_number_table := NULL,
5134: p_program_update_date IN jtf_date_table := NULL,
5135: p_request_id IN jtf_number_table := NULL,
5136: p_quote_header_id IN jtf_number_table := NULL,
5137: p_quote_line_id IN jtf_number_table := NULL,
5138: p_modifier_header_id IN jtf_number_table := NULL,

Line 5195: p_expiration_date IN jtf_date_table := NULL,

5191: p_source_system_code IN jtf_varchar2_table_100 := NULL,
5192: p_benefit_qty IN jtf_number_table := NULL,
5193: p_benefit_uom_code IN jtf_varchar2_table_100 := NULL,
5194: p_print_on_invoice_flag IN jtf_varchar2_table_100 := NULL,
5195: p_expiration_date IN jtf_date_table := NULL,
5196: p_rebate_trans_type_code IN jtf_varchar2_table_100 := NULL,
5197: p_rebate_trans_reference IN jtf_varchar2_table_100 := NULL,
5198: p_rebate_pay_system_code IN jtf_varchar2_table_100 := NULL,
5199: p_redeemed_date IN jtf_date_table := NULL,

Line 5199: p_redeemed_date IN jtf_date_table := NULL,

5195: p_expiration_date IN jtf_date_table := NULL,
5196: p_rebate_trans_type_code IN jtf_varchar2_table_100 := NULL,
5197: p_rebate_trans_reference IN jtf_varchar2_table_100 := NULL,
5198: p_rebate_pay_system_code IN jtf_varchar2_table_100 := NULL,
5199: p_redeemed_date IN jtf_date_table := NULL,
5200: p_redeemed_flag IN jtf_varchar2_table_100 := NULL,
5201: p_modifier_level_code IN jtf_varchar2_table_100 := NULL,
5202: p_price_break_type_code IN jtf_varchar2_table_100 := NULL,
5203: p_substitution_attribute IN jtf_varchar2_table_100 := NULL,

Line 5641: p_creation_date IN jtf_date_table := NULL,

5637: FUNCTION Construct_Sales_Credit_Tbl(
5638: p_operation_code IN jtf_varchar2_table_100 := NULL,
5639: p_qte_line_index IN jtf_number_table := NULL,
5640: p_sales_credit_id IN jtf_number_table := NULL,
5641: p_creation_date IN jtf_date_table := NULL,
5642: p_created_by IN jtf_number_table := NULL,
5643: p_last_updated_by IN jtf_varchar2_table_300 := NULL,
5644: p_last_update_date IN jtf_date_table := NULL,
5645: p_last_update_login IN jtf_number_table := NULL,

Line 5644: p_last_update_date IN jtf_date_table := NULL,

5640: p_sales_credit_id IN jtf_number_table := NULL,
5641: p_creation_date IN jtf_date_table := NULL,
5642: p_created_by IN jtf_number_table := NULL,
5643: p_last_updated_by IN jtf_varchar2_table_300 := NULL,
5644: p_last_update_date IN jtf_date_table := NULL,
5645: p_last_update_login IN jtf_number_table := NULL,
5646: p_request_id IN jtf_number_table := NULL,
5647: p_program_application_id IN jtf_number_table := NULL,
5648: p_program_id IN jtf_number_table := NULL,

Line 5649: p_program_update_date IN jtf_date_table := NULL,

5645: p_last_update_login IN jtf_number_table := NULL,
5646: p_request_id IN jtf_number_table := NULL,
5647: p_program_application_id IN jtf_number_table := NULL,
5648: p_program_id IN jtf_number_table := NULL,
5649: p_program_update_date IN jtf_date_table := NULL,
5650: p_quote_header_id IN jtf_number_table := NULL,
5651: p_quote_line_id IN jtf_number_table := NULL,
5652: p_percent IN jtf_number_table := NULL,
5653: p_resource_id IN jtf_number_table := NULL,

Line 6060: p_creation_date IN jtf_date_table := NULL,

6056: p_quote_number IN jtf_number_table := NULL,
6057: p_resource_id IN jtf_number_table := NULL,
6058: p_resource_grp_id IN jtf_number_table := NULL,
6059: p_created_by IN jtf_number_table := NULL,
6060: p_creation_date IN jtf_date_table := NULL,
6061: p_last_updated_by IN jtf_number_table := NULL,
6062: p_last_update_login IN jtf_number_table := NULL,
6063: p_last_update_date IN jtf_date_table := NULL,
6064: p_request_id IN jtf_number_table := NULL,

Line 6063: p_last_update_date IN jtf_date_table := NULL,

6059: p_created_by IN jtf_number_table := NULL,
6060: p_creation_date IN jtf_date_table := NULL,
6061: p_last_updated_by IN jtf_number_table := NULL,
6062: p_last_update_login IN jtf_number_table := NULL,
6063: p_last_update_date IN jtf_date_table := NULL,
6064: p_request_id IN jtf_number_table := NULL,
6065: p_program_application_id IN jtf_number_table := NULL,
6066: p_program_id IN jtf_number_table := NULL,
6067: p_program_update_date IN jtf_date_table := NULL,

Line 6067: p_program_update_date IN jtf_date_table := NULL,

6063: p_last_update_date IN jtf_date_table := NULL,
6064: p_request_id IN jtf_number_table := NULL,
6065: p_program_application_id IN jtf_number_table := NULL,
6066: p_program_id IN jtf_number_table := NULL,
6067: p_program_update_date IN jtf_date_table := NULL,
6068: p_keep_flag IN jtf_varchar2_table_100 := NULL,
6069: p_update_access_flag IN jtf_varchar2_table_100 := NULL,
6070: p_created_by_tap_flag IN jtf_varchar2_table_100 := NULL,
6071: p_role_id IN jtf_number_table := NULL,

Line 6593: x_last_update_date OUT NOCOPY jtf_date_table

6589: -- copy data OUT NOCOPY /* file.sql.39 change */ from aso quote header table
6590: PROCEDURE Set_Qte_Header_Tbl_Out(
6591: p_qte_header_tbl IN ASO_Quote_Pub.Qte_Header_Tbl_Type,
6592: x_quote_header_id OUT NOCOPY jtf_number_table,
6593: x_last_update_date OUT NOCOPY jtf_date_table
6594:
6595: /*-- The following output parameters are ignored
6596: x_creation_date OUT NOCOPY jtf_date_table,
6597: x_created_by OUT NOCOPY jtf_number_table,

Line 6596: x_creation_date OUT NOCOPY jtf_date_table,

6592: x_quote_header_id OUT NOCOPY jtf_number_table,
6593: x_last_update_date OUT NOCOPY jtf_date_table
6594:
6595: /*-- The following output parameters are ignored
6596: x_creation_date OUT NOCOPY jtf_date_table,
6597: x_created_by OUT NOCOPY jtf_number_table,
6598: x_last_updated_by OUT NOCOPY jtf_number_table,
6599: x_last_update_login OUT NOCOPY jtf_number_table,
6600: x_request_id OUT NOCOPY jtf_number_table,

Line 6603: x_program_update_date OUT NOCOPY jtf_date_table,

6599: x_last_update_login OUT NOCOPY jtf_number_table,
6600: x_request_id OUT NOCOPY jtf_number_table,
6601: x_program_application_id OUT NOCOPY jtf_number_table,
6602: x_program_id OUT NOCOPY jtf_number_table,
6603: x_program_update_date OUT NOCOPY jtf_date_table,
6604: x_org_id OUT NOCOPY jtf_number_table,
6605: x_quote_name OUT NOCOPY jtf_varchar2_table_100,
6606: x_quote_number OUT NOCOPY jtf_number_table,
6607: x_quote_version OUT NOCOPY jtf_number_table,

Line 6610: x_quote_expiration_date OUT NOCOPY jtf_date_table,

6606: x_quote_number OUT NOCOPY jtf_number_table,
6607: x_quote_version OUT NOCOPY jtf_number_table,
6608: x_quote_status_id OUT NOCOPY jtf_number_table,
6609: x_quote_source_code OUT NOCOPY jtf_varchar2_table_300,
6610: x_quote_expiration_date OUT NOCOPY jtf_date_table,
6611: x_price_frozen_date OUT NOCOPY jtf_date_table,
6612: x_quote_password OUT NOCOPY jtf_varchar2_table_300,
6613: x_original_system_reference OUT NOCOPY jtf_varchar2_table_300,
6614: x_party_id OUT NOCOPY jtf_number_table,

Line 6611: x_price_frozen_date OUT NOCOPY jtf_date_table,

6607: x_quote_version OUT NOCOPY jtf_number_table,
6608: x_quote_status_id OUT NOCOPY jtf_number_table,
6609: x_quote_source_code OUT NOCOPY jtf_varchar2_table_300,
6610: x_quote_expiration_date OUT NOCOPY jtf_date_table,
6611: x_price_frozen_date OUT NOCOPY jtf_date_table,
6612: x_quote_password OUT NOCOPY jtf_varchar2_table_300,
6613: x_original_system_reference OUT NOCOPY jtf_varchar2_table_300,
6614: x_party_id OUT NOCOPY jtf_number_table,
6615: x_cust_account_id OUT NOCOPY jtf_number_table,

Line 6625: x_ordered_date OUT NOCOPY jtf_date_table,

6621: x_orig_mktg_source_code_id OUT NOCOPY jtf_number_table,
6622: x_marketing_source_code_id OUT NOCOPY jtf_number_table,
6623: x_order_type_id OUT NOCOPY jtf_number_table,
6624: x_quote_category_code OUT NOCOPY jtf_varchar2_table_300,
6625: x_ordered_date OUT NOCOPY jtf_date_table,
6626: x_accounting_rule_id OUT NOCOPY jtf_number_table,
6627: x_invoicing_rule_id OUT NOCOPY jtf_number_table,
6628: x_employee_person_id OUT NOCOPY jtf_number_table,
6629: x_price_list_id OUT NOCOPY jtf_number_table,

Line 6641: x_exchange_rate_date OUT NOCOPY jtf_date_table,

6637: x_total_quote_price OUT NOCOPY jtf_number_table,
6638: x_payment_amount OUT NOCOPY jtf_number_table,
6639: x_exchange_rate OUT NOCOPY jtf_number_table,
6640: x_exchange_type_code OUT NOCOPY jtf_varchar2_table_100,
6641: x_exchange_rate_date OUT NOCOPY jtf_date_table,
6642: x_contract_id OUT NOCOPY jtf_number_table,
6643: x_sales_channel_code OUT NOCOPY jtf_varchar2_table_100,
6644: x_order_id OUT NOCOPY jtf_number_table,
6645: x_order_number OUT NOCOPY jtf_number_table,

Line 6699: x_last_update_date := jtf_date_table();

6695: AS
6696: ddindx binary_integer; indx binary_integer;
6697: BEGIN
6698: x_quote_header_id := jtf_number_table();
6699: x_last_update_date := jtf_date_table();
6700:
6701: /*-- The following output parameters are ignored
6702: x_creation_date := jtf_date_table();
6703: x_created_by := jtf_number_table();

Line 6702: x_creation_date := jtf_date_table();

6698: x_quote_header_id := jtf_number_table();
6699: x_last_update_date := jtf_date_table();
6700:
6701: /*-- The following output parameters are ignored
6702: x_creation_date := jtf_date_table();
6703: x_created_by := jtf_number_table();
6704: x_last_updated_by := jtf_number_table();
6705: x_last_update_login := jtf_number_table();
6706: x_request_id := jtf_number_table();

Line 6709: x_program_update_date := jtf_date_table();

6705: x_last_update_login := jtf_number_table();
6706: x_request_id := jtf_number_table();
6707: x_program_application_id := jtf_number_table();
6708: x_program_id := jtf_number_table();
6709: x_program_update_date := jtf_date_table();
6710: x_org_id := jtf_number_table();
6711: x_quote_name := jtf_varchar2_table_100();
6712: x_quote_number := jtf_number_table();
6713: x_quote_version := jtf_number_table();

Line 6716: x_quote_expiration_date := jtf_date_table();

6712: x_quote_number := jtf_number_table();
6713: x_quote_version := jtf_number_table();
6714: x_quote_status_id := jtf_number_table();
6715: x_quote_source_code := jtf_varchar2_table_300();
6716: x_quote_expiration_date := jtf_date_table();
6717: x_price_frozen_date := jtf_date_table();
6718: x_quote_password := jtf_varchar2_table_300();
6719: x_original_system_reference := jtf_varchar2_table_300();
6720: x_party_id := jtf_number_table();

Line 6717: x_price_frozen_date := jtf_date_table();

6713: x_quote_version := jtf_number_table();
6714: x_quote_status_id := jtf_number_table();
6715: x_quote_source_code := jtf_varchar2_table_300();
6716: x_quote_expiration_date := jtf_date_table();
6717: x_price_frozen_date := jtf_date_table();
6718: x_quote_password := jtf_varchar2_table_300();
6719: x_original_system_reference := jtf_varchar2_table_300();
6720: x_party_id := jtf_number_table();
6721: x_cust_account_id := jtf_number_table();

Line 6731: x_ordered_date := jtf_date_table();

6727: x_orig_mktg_source_code_id := jtf_number_table();
6728: x_marketing_source_code_id := jtf_number_table();
6729: x_order_type_id := jtf_number_table();
6730: x_quote_category_code := jtf_varchar2_table_300();
6731: x_ordered_date := jtf_date_table();
6732: x_accounting_rule_id := jtf_number_table();
6733: x_invoicing_rule_id := jtf_number_table();
6734: x_employee_person_id := jtf_number_table();
6735: x_price_list_id := jtf_number_table();

Line 6747: x_exchange_rate_date := jtf_date_table();

6743: x_total_quote_price := jtf_number_table();
6744: x_payment_amount := jtf_number_table();
6745: x_exchange_rate := jtf_number_table();
6746: x_exchange_type_code := jtf_varchar2_table_100();
6747: x_exchange_rate_date := jtf_date_table();
6748: x_contract_id := jtf_number_table();
6749: x_sales_channel_code := jtf_varchar2_table_100();
6750: x_order_id := jtf_number_table();
6751: x_order_number := jtf_number_table();

Line 7028: x_creation_date OUT NOCOPY jtf_date_table,

7024: x_quote_line_id OUT NOCOPY jtf_number_table
7025:
7026: /*-- The following output parameters are ignored
7027: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
7028: x_creation_date OUT NOCOPY jtf_date_table,
7029: x_created_by OUT NOCOPY jtf_number_table,
7030: x_last_update_date OUT NOCOPY jtf_date_table,
7031: x_last_updated_by OUT NOCOPY jtf_number_table,
7032: x_last_update_login OUT NOCOPY jtf_number_table,

Line 7030: x_last_update_date OUT NOCOPY jtf_date_table,

7026: /*-- The following output parameters are ignored
7027: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
7028: x_creation_date OUT NOCOPY jtf_date_table,
7029: x_created_by OUT NOCOPY jtf_number_table,
7030: x_last_update_date OUT NOCOPY jtf_date_table,
7031: x_last_updated_by OUT NOCOPY jtf_number_table,
7032: x_last_update_login OUT NOCOPY jtf_number_table,
7033: x_request_id OUT NOCOPY jtf_number_table,
7034: x_program_application_id OUT NOCOPY jtf_number_table,

Line 7036: x_program_update_date OUT NOCOPY jtf_date_table,

7032: x_last_update_login OUT NOCOPY jtf_number_table,
7033: x_request_id OUT NOCOPY jtf_number_table,
7034: x_program_application_id OUT NOCOPY jtf_number_table,
7035: x_program_id OUT NOCOPY jtf_number_table,
7036: x_program_update_date OUT NOCOPY jtf_date_table,
7037: x_quote_header_id OUT NOCOPY jtf_number_table,
7038: x_org_id OUT NOCOPY jtf_number_table,
7039: x_line_category_code OUT NOCOPY jtf_varchar2_table_100,
7040: x_item_type_code OUT NOCOPY jtf_varchar2_table_100,

Line 7042: x_start_date_active OUT NOCOPY jtf_date_table,

7038: x_org_id OUT NOCOPY jtf_number_table,
7039: x_line_category_code OUT NOCOPY jtf_varchar2_table_100,
7040: x_item_type_code OUT NOCOPY jtf_varchar2_table_100,
7041: x_line_number OUT NOCOPY jtf_number_table,
7042: x_start_date_active OUT NOCOPY jtf_date_table,
7043: x_end_date_active OUT NOCOPY jtf_date_table,
7044: x_order_line_type_id OUT NOCOPY jtf_number_table,
7045: x_invoice_to_party_site_id OUT NOCOPY jtf_number_table,
7046: x_invoice_to_party_id OUT NOCOPY jtf_number_table,

Line 7043: x_end_date_active OUT NOCOPY jtf_date_table,

7039: x_line_category_code OUT NOCOPY jtf_varchar2_table_100,
7040: x_item_type_code OUT NOCOPY jtf_varchar2_table_100,
7041: x_line_number OUT NOCOPY jtf_number_table,
7042: x_start_date_active OUT NOCOPY jtf_date_table,
7043: x_end_date_active OUT NOCOPY jtf_date_table,
7044: x_order_line_type_id OUT NOCOPY jtf_number_table,
7045: x_invoice_to_party_site_id OUT NOCOPY jtf_number_table,
7046: x_invoice_to_party_id OUT NOCOPY jtf_number_table,
7047: x_invoice_to_cust_account_id OUT NOCOPY jtf_number_table,

Line 7102: x_creation_date := jtf_date_table();

7098: x_quote_line_id := jtf_number_table();
7099:
7100: /*-- The following output parameters are ignored
7101: x_operation_code := jtf_varchar2_table_100();
7102: x_creation_date := jtf_date_table();
7103: x_created_by := jtf_number_table();
7104: x_last_update_date := jtf_date_table();
7105: x_last_updated_by := jtf_number_table();
7106: x_last_update_login := jtf_number_table();

Line 7104: x_last_update_date := jtf_date_table();

7100: /*-- The following output parameters are ignored
7101: x_operation_code := jtf_varchar2_table_100();
7102: x_creation_date := jtf_date_table();
7103: x_created_by := jtf_number_table();
7104: x_last_update_date := jtf_date_table();
7105: x_last_updated_by := jtf_number_table();
7106: x_last_update_login := jtf_number_table();
7107: x_request_id := jtf_number_table();
7108: x_program_application_id := jtf_number_table();

Line 7110: x_program_update_date := jtf_date_table();

7106: x_last_update_login := jtf_number_table();
7107: x_request_id := jtf_number_table();
7108: x_program_application_id := jtf_number_table();
7109: x_program_id := jtf_number_table();
7110: x_program_update_date := jtf_date_table();
7111: x_quote_header_id := jtf_number_table();
7112: x_org_id := jtf_number_table();
7113: x_line_category_code := jtf_varchar2_table_100();
7114: x_item_type_code := jtf_varchar2_table_100();

Line 7116: x_start_date_active := jtf_date_table();

7112: x_org_id := jtf_number_table();
7113: x_line_category_code := jtf_varchar2_table_100();
7114: x_item_type_code := jtf_varchar2_table_100();
7115: x_line_number := jtf_number_table();
7116: x_start_date_active := jtf_date_table();
7117: x_end_date_active := jtf_date_table();
7118: x_order_line_type_id := jtf_number_table();
7119: x_invoice_to_party_site_id := jtf_number_table();
7120: x_invoice_to_party_id := jtf_number_table();

Line 7117: x_end_date_active := jtf_date_table();

7113: x_line_category_code := jtf_varchar2_table_100();
7114: x_item_type_code := jtf_varchar2_table_100();
7115: x_line_number := jtf_number_table();
7116: x_start_date_active := jtf_date_table();
7117: x_end_date_active := jtf_date_table();
7118: x_order_line_type_id := jtf_number_table();
7119: x_invoice_to_party_site_id := jtf_number_table();
7120: x_invoice_to_party_id := jtf_number_table();
7121: x_invoice_to_cust_account_id := jtf_number_table();

Line 7333: x_creation_date OUT NOCOPY jtf_date_table,

7329:
7330: /*-- The following output parameters are ignored
7331: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
7332: x_qte_line_index OUT NOCOPY jtf_number_table,
7333: x_creation_date OUT NOCOPY jtf_date_table,
7334: x_created_by OUT NOCOPY jtf_number_table,
7335: x_last_update_date OUT NOCOPY jtf_date_table,
7336: x_last_updated_by OUT NOCOPY jtf_number_table,
7337: x_last_update_login OUT NOCOPY jtf_number_table,

Line 7335: x_last_update_date OUT NOCOPY jtf_date_table,

7331: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
7332: x_qte_line_index OUT NOCOPY jtf_number_table,
7333: x_creation_date OUT NOCOPY jtf_date_table,
7334: x_created_by OUT NOCOPY jtf_number_table,
7335: x_last_update_date OUT NOCOPY jtf_date_table,
7336: x_last_updated_by OUT NOCOPY jtf_number_table,
7337: x_last_update_login OUT NOCOPY jtf_number_table,
7338: x_request_id OUT NOCOPY jtf_number_table,
7339: x_program_application_id OUT NOCOPY jtf_number_table,

Line 7341: x_program_update_date OUT NOCOPY jtf_date_table,

7337: x_last_update_login OUT NOCOPY jtf_number_table,
7338: x_request_id OUT NOCOPY jtf_number_table,
7339: x_program_application_id OUT NOCOPY jtf_number_table,
7340: x_program_id OUT NOCOPY jtf_number_table,
7341: x_program_update_date OUT NOCOPY jtf_date_table,
7342: x_quote_line_id OUT NOCOPY jtf_number_table,
7343: x_config_header_id OUT NOCOPY jtf_number_table,
7344: x_config_revision_num OUT NOCOPY jtf_number_table,
7345: x_config_item_id OUT NOCOPY jtf_number_table,

Line 7411: x_creation_date := jtf_date_table();

7407:
7408: /*-- The following output parameters are ignored
7409: x_operation_code := jtf_varchar2_table_100();
7410: x_qte_line_index := jtf_number_table();
7411: x_creation_date := jtf_date_table();
7412: x_created_by := jtf_number_table();
7413: x_last_update_date := jtf_date_table();
7414: x_last_updated_by := jtf_number_table();
7415: x_last_update_login := jtf_number_table();

Line 7413: x_last_update_date := jtf_date_table();

7409: x_operation_code := jtf_varchar2_table_100();
7410: x_qte_line_index := jtf_number_table();
7411: x_creation_date := jtf_date_table();
7412: x_created_by := jtf_number_table();
7413: x_last_update_date := jtf_date_table();
7414: x_last_updated_by := jtf_number_table();
7415: x_last_update_login := jtf_number_table();
7416: x_request_id := jtf_number_table();
7417: x_program_application_id := jtf_number_table();

Line 7419: x_program_update_date := jtf_date_table();

7415: x_last_update_login := jtf_number_table();
7416: x_request_id := jtf_number_table();
7417: x_program_application_id := jtf_number_table();
7418: x_program_id := jtf_number_table();
7419: x_program_update_date := jtf_date_table();
7420: x_quote_line_id := jtf_number_table();
7421: x_config_header_id := jtf_number_table();
7422: x_config_revision_num := jtf_number_table();
7423: x_config_item_id := jtf_number_table();

Line 7652: x_creation_date OUT NOCOPY jtf_date_table,

7648: x_line_relationship_id OUT NOCOPY jtf_number_table
7649:
7650: /*-- The following output parameters are ignored
7651: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
7652: x_creation_date OUT NOCOPY jtf_date_table,
7653: x_created_by OUT NOCOPY jtf_number_table,
7654: x_last_update_date OUT NOCOPY jtf_date_table,
7655: x_last_updated_by OUT NOCOPY jtf_number_table,
7656: x_last_update_login OUT NOCOPY jtf_number_table,

Line 7654: x_last_update_date OUT NOCOPY jtf_date_table,

7650: /*-- The following output parameters are ignored
7651: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
7652: x_creation_date OUT NOCOPY jtf_date_table,
7653: x_created_by OUT NOCOPY jtf_number_table,
7654: x_last_update_date OUT NOCOPY jtf_date_table,
7655: x_last_updated_by OUT NOCOPY jtf_number_table,
7656: x_last_update_login OUT NOCOPY jtf_number_table,
7657: x_request_id OUT NOCOPY jtf_number_table,
7658: x_program_application_id OUT NOCOPY jtf_number_table,

Line 7660: x_program_update_date OUT NOCOPY jtf_date_table,

7656: x_last_update_login OUT NOCOPY jtf_number_table,
7657: x_request_id OUT NOCOPY jtf_number_table,
7658: x_program_application_id OUT NOCOPY jtf_number_table,
7659: x_program_id OUT NOCOPY jtf_number_table,
7660: x_program_update_date OUT NOCOPY jtf_date_table,
7661: x_quote_line_id OUT NOCOPY jtf_number_table,
7662: x_qte_line_index OUT NOCOPY jtf_number_table,
7663: x_related_quote_line_id OUT NOCOPY jtf_number_table,
7664: x_related_qte_line_index OUT NOCOPY jtf_number_table,

Line 7676: x_creation_date := jtf_date_table();

7672: x_line_relationship_id := jtf_number_table();
7673:
7674: /*-- The following output parameters are ignored
7675: x_operation_code := jtf_varchar2_table_100();
7676: x_creation_date := jtf_date_table();
7677: x_created_by := jtf_number_table();
7678: x_last_update_date := jtf_date_table();
7679: x_last_updated_by := jtf_number_table();
7680: x_last_update_login := jtf_number_table();

Line 7678: x_last_update_date := jtf_date_table();

7674: /*-- The following output parameters are ignored
7675: x_operation_code := jtf_varchar2_table_100();
7676: x_creation_date := jtf_date_table();
7677: x_created_by := jtf_number_table();
7678: x_last_update_date := jtf_date_table();
7679: x_last_updated_by := jtf_number_table();
7680: x_last_update_login := jtf_number_table();
7681: x_request_id := jtf_number_table();
7682: x_program_application_id := jtf_number_table();

Line 7684: x_program_update_date := jtf_date_table();

7680: x_last_update_login := jtf_number_table();
7681: x_request_id := jtf_number_table();
7682: x_program_application_id := jtf_number_table();
7683: x_program_id := jtf_number_table();
7684: x_program_update_date := jtf_date_table();
7685: x_quote_line_id := jtf_number_table();
7686: x_qte_line_index := jtf_number_table();
7687: x_related_quote_line_id := jtf_number_table();
7688: x_related_qte_line_index := jtf_number_table();

Line 7758: x_creation_date OUT NOCOPY jtf_date_table,

7754: /*-- The following output parameters are ignored
7755: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
7756: x_qte_line_index OUT NOCOPY jtf_number_table,
7757: x_shipment_index OUT NOCOPY jtf_number_table,
7758: x_creation_date OUT NOCOPY jtf_date_table,
7759: x_created_by OUT NOCOPY jtf_number_table,
7760: x_last_update_date OUT NOCOPY jtf_date_table,
7761: x_last_updated_by OUT NOCOPY jtf_number_table,
7762: x_last_update_login OUT NOCOPY jtf_number_table,

Line 7760: x_last_update_date OUT NOCOPY jtf_date_table,

7756: x_qte_line_index OUT NOCOPY jtf_number_table,
7757: x_shipment_index OUT NOCOPY jtf_number_table,
7758: x_creation_date OUT NOCOPY jtf_date_table,
7759: x_created_by OUT NOCOPY jtf_number_table,
7760: x_last_update_date OUT NOCOPY jtf_date_table,
7761: x_last_updated_by OUT NOCOPY jtf_number_table,
7762: x_last_update_login OUT NOCOPY jtf_number_table,
7763: x_request_id OUT NOCOPY jtf_number_table,
7764: x_program_application_id OUT NOCOPY jtf_number_table,

Line 7766: x_program_update_date OUT NOCOPY jtf_date_table,

7762: x_last_update_login OUT NOCOPY jtf_number_table,
7763: x_request_id OUT NOCOPY jtf_number_table,
7764: x_program_application_id OUT NOCOPY jtf_number_table,
7765: x_program_id OUT NOCOPY jtf_number_table,
7766: x_program_update_date OUT NOCOPY jtf_date_table,
7767: x_quote_header_id OUT NOCOPY jtf_number_table,
7768: x_quote_line_id OUT NOCOPY jtf_number_table,
7769: x_quote_shipment_id OUT NOCOPY jtf_number_table,
7770: x_payment_type_code OUT NOCOPY jtf_varchar2_table_100,

Line 7776: x_credit_card_exp_date OUT NOCOPY jtf_date_table,

7772: x_payment_option OUT NOCOPY jtf_varchar2_table_300,
7773: x_payment_term_id OUT NOCOPY jtf_number_table,
7774: x_credit_card_code OUT NOCOPY jtf_varchar2_table_100,
7775: x_credit_card_holder_name OUT NOCOPY jtf_varchar2_table_100,
7776: x_credit_card_exp_date OUT NOCOPY jtf_date_table,
7777: x_credit_card_approval_code OUT NOCOPY jtf_varchar2_table_100,
7778: x_credit_card_approval_date OUT NOCOPY jtf_date_table,
7779: x_payment_amount OUT NOCOPY jtf_number_table,
7780: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,

Line 7778: x_credit_card_approval_date OUT NOCOPY jtf_date_table,

7774: x_credit_card_code OUT NOCOPY jtf_varchar2_table_100,
7775: x_credit_card_holder_name OUT NOCOPY jtf_varchar2_table_100,
7776: x_credit_card_exp_date OUT NOCOPY jtf_date_table,
7777: x_credit_card_approval_code OUT NOCOPY jtf_varchar2_table_100,
7778: x_credit_card_approval_date OUT NOCOPY jtf_date_table,
7779: x_payment_amount OUT NOCOPY jtf_number_table,
7780: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
7781: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
7782: x_attribute2 OUT NOCOPY jtf_varchar2_table_200,

Line 7808: x_creation_date := jtf_date_table();

7804: /*-- The following output parameters are ignored
7805: x_operation_code := jtf_varchar2_table_100();
7806: x_qte_line_index := jtf_number_table();
7807: x_shipment_index := jtf_number_table();
7808: x_creation_date := jtf_date_table();
7809: x_created_by := jtf_number_table();
7810: x_last_update_date := jtf_date_table();
7811: x_last_updated_by := jtf_number_table();
7812: x_last_update_login := jtf_number_table();

Line 7810: x_last_update_date := jtf_date_table();

7806: x_qte_line_index := jtf_number_table();
7807: x_shipment_index := jtf_number_table();
7808: x_creation_date := jtf_date_table();
7809: x_created_by := jtf_number_table();
7810: x_last_update_date := jtf_date_table();
7811: x_last_updated_by := jtf_number_table();
7812: x_last_update_login := jtf_number_table();
7813: x_request_id := jtf_number_table();
7814: x_program_application_id := jtf_number_table();

Line 7816: x_program_update_date := jtf_date_table();

7812: x_last_update_login := jtf_number_table();
7813: x_request_id := jtf_number_table();
7814: x_program_application_id := jtf_number_table();
7815: x_program_id := jtf_number_table();
7816: x_program_update_date := jtf_date_table();
7817: x_quote_header_id := jtf_number_table();
7818: x_quote_line_id := jtf_number_table();
7819: x_quote_shipment_id := jtf_number_table();
7820: x_payment_type_code := jtf_varchar2_table_100();

Line 7826: x_credit_card_exp_date := jtf_date_table();

7822: x_payment_option := jtf_varchar2_table_300();
7823: x_payment_term_id := jtf_number_table();
7824: x_credit_card_code := jtf_varchar2_table_100();
7825: x_credit_card_holder_name := jtf_varchar2_table_100();
7826: x_credit_card_exp_date := jtf_date_table();
7827: x_credit_card_approval_code := jtf_varchar2_table_100();
7828: x_credit_card_approval_date := jtf_date_table();
7829: x_payment_amount := jtf_number_table();
7830: x_attribute_category := jtf_varchar2_table_100();

Line 7828: x_credit_card_approval_date := jtf_date_table();

7824: x_credit_card_code := jtf_varchar2_table_100();
7825: x_credit_card_holder_name := jtf_varchar2_table_100();
7826: x_credit_card_exp_date := jtf_date_table();
7827: x_credit_card_approval_code := jtf_varchar2_table_100();
7828: x_credit_card_approval_date := jtf_date_table();
7829: x_payment_amount := jtf_number_table();
7830: x_attribute_category := jtf_varchar2_table_100();
7831: x_attribute1 := jtf_varchar2_table_200();
7832: x_attribute2 := jtf_varchar2_table_200();

Line 7964: x_creation_date OUT NOCOPY jtf_date_table,

7960:
7961: /*-- The following output parameters are ignored
7962: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
7963: x_qte_line_index OUT NOCOPY jtf_number_table,
7964: x_creation_date OUT NOCOPY jtf_date_table,
7965: x_created_by OUT NOCOPY jtf_number_table,
7966: x_last_update_date OUT NOCOPY jtf_date_table,
7967: x_last_updated_by OUT NOCOPY jtf_number_table,
7968: x_last_update_login OUT NOCOPY jtf_number_table,

Line 7966: x_last_update_date OUT NOCOPY jtf_date_table,

7962: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
7963: x_qte_line_index OUT NOCOPY jtf_number_table,
7964: x_creation_date OUT NOCOPY jtf_date_table,
7965: x_created_by OUT NOCOPY jtf_number_table,
7966: x_last_update_date OUT NOCOPY jtf_date_table,
7967: x_last_updated_by OUT NOCOPY jtf_number_table,
7968: x_last_update_login OUT NOCOPY jtf_number_table,
7969: x_request_id OUT NOCOPY jtf_number_table,
7970: x_program_application_id OUT NOCOPY jtf_number_table,

Line 7972: x_program_update_date OUT NOCOPY jtf_date_table,

7968: x_last_update_login OUT NOCOPY jtf_number_table,
7969: x_request_id OUT NOCOPY jtf_number_table,
7970: x_program_application_id OUT NOCOPY jtf_number_table,
7971: x_program_id OUT NOCOPY jtf_number_table,
7972: x_program_update_date OUT NOCOPY jtf_date_table,
7973: x_quote_header_id OUT NOCOPY jtf_number_table,
7974: x_quote_line_id OUT NOCOPY jtf_number_table,
7975: x_promise_date OUT NOCOPY jtf_date_table,
7976: x_request_date OUT NOCOPY jtf_date_table,

Line 7975: x_promise_date OUT NOCOPY jtf_date_table,

7971: x_program_id OUT NOCOPY jtf_number_table,
7972: x_program_update_date OUT NOCOPY jtf_date_table,
7973: x_quote_header_id OUT NOCOPY jtf_number_table,
7974: x_quote_line_id OUT NOCOPY jtf_number_table,
7975: x_promise_date OUT NOCOPY jtf_date_table,
7976: x_request_date OUT NOCOPY jtf_date_table,
7977: x_schedule_ship_date OUT NOCOPY jtf_date_table,
7978: x_ship_to_party_site_id OUT NOCOPY jtf_number_table,
7979: x_ship_to_party_id OUT NOCOPY jtf_number_table,

Line 7976: x_request_date OUT NOCOPY jtf_date_table,

7972: x_program_update_date OUT NOCOPY jtf_date_table,
7973: x_quote_header_id OUT NOCOPY jtf_number_table,
7974: x_quote_line_id OUT NOCOPY jtf_number_table,
7975: x_promise_date OUT NOCOPY jtf_date_table,
7976: x_request_date OUT NOCOPY jtf_date_table,
7977: x_schedule_ship_date OUT NOCOPY jtf_date_table,
7978: x_ship_to_party_site_id OUT NOCOPY jtf_number_table,
7979: x_ship_to_party_id OUT NOCOPY jtf_number_table,
7980: x_ship_to_cust_account_id OUT NOCOPY jtf_number_table,

Line 7977: x_schedule_ship_date OUT NOCOPY jtf_date_table,

7973: x_quote_header_id OUT NOCOPY jtf_number_table,
7974: x_quote_line_id OUT NOCOPY jtf_number_table,
7975: x_promise_date OUT NOCOPY jtf_date_table,
7976: x_request_date OUT NOCOPY jtf_date_table,
7977: x_schedule_ship_date OUT NOCOPY jtf_date_table,
7978: x_ship_to_party_site_id OUT NOCOPY jtf_number_table,
7979: x_ship_to_party_id OUT NOCOPY jtf_number_table,
7980: x_ship_to_cust_account_id OUT NOCOPY jtf_number_table,
7981: x_ship_partial_flag OUT NOCOPY jtf_varchar2_table_300,

Line 8038: x_creation_date := jtf_date_table();

8034:
8035: /*-- The following output parameters are ignored
8036: x_operation_code := jtf_varchar2_table_100();
8037: x_qte_line_index := jtf_number_table();
8038: x_creation_date := jtf_date_table();
8039: x_created_by := jtf_number_table();
8040: x_last_update_date := jtf_date_table();
8041: x_last_updated_by := jtf_number_table();
8042: x_last_update_login := jtf_number_table();

Line 8040: x_last_update_date := jtf_date_table();

8036: x_operation_code := jtf_varchar2_table_100();
8037: x_qte_line_index := jtf_number_table();
8038: x_creation_date := jtf_date_table();
8039: x_created_by := jtf_number_table();
8040: x_last_update_date := jtf_date_table();
8041: x_last_updated_by := jtf_number_table();
8042: x_last_update_login := jtf_number_table();
8043: x_request_id := jtf_number_table();
8044: x_program_application_id := jtf_number_table();

Line 8046: x_program_update_date := jtf_date_table();

8042: x_last_update_login := jtf_number_table();
8043: x_request_id := jtf_number_table();
8044: x_program_application_id := jtf_number_table();
8045: x_program_id := jtf_number_table();
8046: x_program_update_date := jtf_date_table();
8047: x_quote_header_id := jtf_number_table();
8048: x_quote_line_id := jtf_number_table();
8049: x_promise_date := jtf_date_table();
8050: x_request_date := jtf_date_table();

Line 8049: x_promise_date := jtf_date_table();

8045: x_program_id := jtf_number_table();
8046: x_program_update_date := jtf_date_table();
8047: x_quote_header_id := jtf_number_table();
8048: x_quote_line_id := jtf_number_table();
8049: x_promise_date := jtf_date_table();
8050: x_request_date := jtf_date_table();
8051: x_schedule_ship_date := jtf_date_table();
8052: x_ship_to_party_site_id := jtf_number_table();
8053: x_ship_to_party_id := jtf_number_table();

Line 8050: x_request_date := jtf_date_table();

8046: x_program_update_date := jtf_date_table();
8047: x_quote_header_id := jtf_number_table();
8048: x_quote_line_id := jtf_number_table();
8049: x_promise_date := jtf_date_table();
8050: x_request_date := jtf_date_table();
8051: x_schedule_ship_date := jtf_date_table();
8052: x_ship_to_party_site_id := jtf_number_table();
8053: x_ship_to_party_id := jtf_number_table();
8054: x_ship_to_cust_account_id := jtf_number_table();

Line 8051: x_schedule_ship_date := jtf_date_table();

8047: x_quote_header_id := jtf_number_table();
8048: x_quote_line_id := jtf_number_table();
8049: x_promise_date := jtf_date_table();
8050: x_request_date := jtf_date_table();
8051: x_schedule_ship_date := jtf_date_table();
8052: x_ship_to_party_site_id := jtf_number_table();
8053: x_ship_to_party_id := jtf_number_table();
8054: x_ship_to_cust_account_id := jtf_number_table();
8055: x_ship_partial_flag := jtf_varchar2_table_300();

Line 8272: x_creation_date OUT NOCOPY jtf_date_table,

8268: x_shipment_index OUT NOCOPY jtf_number_table,
8269: x_quote_header_id OUT NOCOPY jtf_number_table,
8270: x_quote_line_id OUT NOCOPY jtf_number_table,
8271: x_quote_shipment_id OUT NOCOPY jtf_number_table,
8272: x_creation_date OUT NOCOPY jtf_date_table,
8273: x_created_by OUT NOCOPY jtf_number_table,
8274: x_last_update_date OUT NOCOPY jtf_date_table,
8275: x_last_updated_by OUT NOCOPY jtf_number_table,
8276: x_last_update_login OUT NOCOPY jtf_number_table,

Line 8274: x_last_update_date OUT NOCOPY jtf_date_table,

8270: x_quote_line_id OUT NOCOPY jtf_number_table,
8271: x_quote_shipment_id OUT NOCOPY jtf_number_table,
8272: x_creation_date OUT NOCOPY jtf_date_table,
8273: x_created_by OUT NOCOPY jtf_number_table,
8274: x_last_update_date OUT NOCOPY jtf_date_table,
8275: x_last_updated_by OUT NOCOPY jtf_number_table,
8276: x_last_update_login OUT NOCOPY jtf_number_table,
8277: x_request_id OUT NOCOPY jtf_number_table,
8278: x_program_application_id OUT NOCOPY jtf_number_table,

Line 8280: x_program_update_date OUT NOCOPY jtf_date_table,

8276: x_last_update_login OUT NOCOPY jtf_number_table,
8277: x_request_id OUT NOCOPY jtf_number_table,
8278: x_program_application_id OUT NOCOPY jtf_number_table,
8279: x_program_id OUT NOCOPY jtf_number_table,
8280: x_program_update_date OUT NOCOPY jtf_date_table,
8281: x_orig_tax_code OUT NOCOPY jtf_varchar2_table_300,
8282: x_tax_code OUT NOCOPY jtf_varchar2_table_100,
8283: x_tax_rate OUT NOCOPY jtf_number_table,
8284: x_tax_date OUT NOCOPY jtf_date_table,

Line 8284: x_tax_date OUT NOCOPY jtf_date_table,

8280: x_program_update_date OUT NOCOPY jtf_date_table,
8281: x_orig_tax_code OUT NOCOPY jtf_varchar2_table_300,
8282: x_tax_code OUT NOCOPY jtf_varchar2_table_100,
8283: x_tax_rate OUT NOCOPY jtf_number_table,
8284: x_tax_date OUT NOCOPY jtf_date_table,
8285: x_tax_amount OUT NOCOPY jtf_number_table,
8286: x_tax_exempt_flag OUT NOCOPY jtf_varchar2_table_100,
8287: x_tax_exempt_number OUT NOCOPY jtf_varchar2_table_100,
8288: x_tax_exempt_reason_code OUT NOCOPY jtf_varchar2_table_100,

Line 8319: x_creation_date := jtf_date_table();

8315: x_shipment_index := jtf_number_table();
8316: x_quote_header_id := jtf_number_table();
8317: x_quote_line_id := jtf_number_table();
8318: x_quote_shipment_id := jtf_number_table();
8319: x_creation_date := jtf_date_table();
8320: x_created_by := jtf_number_table();
8321: x_last_update_date := jtf_date_table();
8322: x_last_updated_by := jtf_number_table();
8323: x_last_update_login := jtf_number_table();

Line 8321: x_last_update_date := jtf_date_table();

8317: x_quote_line_id := jtf_number_table();
8318: x_quote_shipment_id := jtf_number_table();
8319: x_creation_date := jtf_date_table();
8320: x_created_by := jtf_number_table();
8321: x_last_update_date := jtf_date_table();
8322: x_last_updated_by := jtf_number_table();
8323: x_last_update_login := jtf_number_table();
8324: x_request_id := jtf_number_table();
8325: x_program_application_id := jtf_number_table();

Line 8327: x_program_update_date := jtf_date_table();

8323: x_last_update_login := jtf_number_table();
8324: x_request_id := jtf_number_table();
8325: x_program_application_id := jtf_number_table();
8326: x_program_id := jtf_number_table();
8327: x_program_update_date := jtf_date_table();
8328: x_orig_tax_code := jtf_varchar2_table_300();
8329: x_tax_code := jtf_varchar2_table_100();
8330: x_tax_rate := jtf_number_table();
8331: x_tax_date := jtf_date_table();

Line 8331: x_tax_date := jtf_date_table();

8327: x_program_update_date := jtf_date_table();
8328: x_orig_tax_code := jtf_varchar2_table_300();
8329: x_tax_code := jtf_varchar2_table_100();
8330: x_tax_rate := jtf_number_table();
8331: x_tax_date := jtf_date_table();
8332: x_tax_amount := jtf_number_table();
8333: x_tax_exempt_flag := jtf_varchar2_table_100();
8334: x_tax_exempt_number := jtf_varchar2_table_100();
8335: x_tax_exempt_reason_code := jtf_varchar2_table_100();

Line 8465: x_creation_date OUT NOCOPY jtf_date_table,

8461: /*-- The following output parameters are ignored
8462: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
8463: x_qte_line_index OUT NOCOPY jtf_number_table,
8464: x_shipment_index OUT NOCOPY jtf_number_table,
8465: x_creation_date OUT NOCOPY jtf_date_table,
8466: x_created_by OUT NOCOPY jtf_number_table,
8467: x_last_update_date OUT NOCOPY jtf_date_table,
8468: x_last_updated_by OUT NOCOPY jtf_number_table,
8469: x_last_update_login OUT NOCOPY jtf_number_table,

Line 8467: x_last_update_date OUT NOCOPY jtf_date_table,

8463: x_qte_line_index OUT NOCOPY jtf_number_table,
8464: x_shipment_index OUT NOCOPY jtf_number_table,
8465: x_creation_date OUT NOCOPY jtf_date_table,
8466: x_created_by OUT NOCOPY jtf_number_table,
8467: x_last_update_date OUT NOCOPY jtf_date_table,
8468: x_last_updated_by OUT NOCOPY jtf_number_table,
8469: x_last_update_login OUT NOCOPY jtf_number_table,
8470: x_program_application_id OUT NOCOPY jtf_number_table,
8471: x_program_id OUT NOCOPY jtf_number_table,

Line 8472: x_program_update_date OUT NOCOPY jtf_date_table,

8468: x_last_updated_by OUT NOCOPY jtf_number_table,
8469: x_last_update_login OUT NOCOPY jtf_number_table,
8470: x_program_application_id OUT NOCOPY jtf_number_table,
8471: x_program_id OUT NOCOPY jtf_number_table,
8472: x_program_update_date OUT NOCOPY jtf_date_table,
8473: x_request_id OUT NOCOPY jtf_number_table,
8474: x_quote_header_id OUT NOCOPY jtf_number_table,
8475: x_quote_line_id OUT NOCOPY jtf_number_table,
8476: x_quote_shipment_id OUT NOCOPY jtf_number_table,

Line 8534: x_expiration_date OUT NOCOPY jtf_date_table,

8530: x_source_system_code OUT NOCOPY jtf_varchar2_table_100,
8531: x_benefit_qty OUT NOCOPY jtf_number_table,
8532: x_benefit_uom_code OUT NOCOPY jtf_varchar2_table_100,
8533: x_print_on_invoice_flag OUT NOCOPY jtf_varchar2_table_100,
8534: x_expiration_date OUT NOCOPY jtf_date_table,
8535: x_rebate_transaction_type_code OUT NOCOPY jtf_varchar2_table_100,
8536: x_rebate_transaction_reference OUT NOCOPY jtf_varchar2_table_100,
8537: x_rebate_payment_system_code OUT NOCOPY jtf_varchar2_table_100,
8538: x_redeemed_date OUT NOCOPY jtf_date_table,

Line 8538: x_redeemed_date OUT NOCOPY jtf_date_table,

8534: x_expiration_date OUT NOCOPY jtf_date_table,
8535: x_rebate_transaction_type_code OUT NOCOPY jtf_varchar2_table_100,
8536: x_rebate_transaction_reference OUT NOCOPY jtf_varchar2_table_100,
8537: x_rebate_payment_system_code OUT NOCOPY jtf_varchar2_table_100,
8538: x_redeemed_date OUT NOCOPY jtf_date_table,
8539: x_redeemed_flag OUT NOCOPY jtf_varchar2_table_100,
8540: x_modifier_level_code OUT NOCOPY jtf_varchar2_table_100,
8541: x_price_break_type_code OUT NOCOPY jtf_varchar2_table_100,
8542: x_substitution_attribute OUT NOCOPY jtf_varchar2_table_100,

Line 8557: x_creation_date := jtf_date_table();

8553: /*-- The following output parameters are ignored
8554: x_operation_code := jtf_varchar2_table_100();
8555: x_qte_line_index := jtf_number_table();
8556: x_shipment_index := jtf_number_table();
8557: x_creation_date := jtf_date_table();
8558: x_created_by := jtf_number_table();
8559: x_last_update_date := jtf_date_table();
8560: x_last_updated_by := jtf_number_table();
8561: x_last_update_login := jtf_number_table();

Line 8559: x_last_update_date := jtf_date_table();

8555: x_qte_line_index := jtf_number_table();
8556: x_shipment_index := jtf_number_table();
8557: x_creation_date := jtf_date_table();
8558: x_created_by := jtf_number_table();
8559: x_last_update_date := jtf_date_table();
8560: x_last_updated_by := jtf_number_table();
8561: x_last_update_login := jtf_number_table();
8562: x_program_application_id := jtf_number_table();
8563: x_program_id := jtf_number_table();

Line 8564: x_program_update_date := jtf_date_table();

8560: x_last_updated_by := jtf_number_table();
8561: x_last_update_login := jtf_number_table();
8562: x_program_application_id := jtf_number_table();
8563: x_program_id := jtf_number_table();
8564: x_program_update_date := jtf_date_table();
8565: x_request_id := jtf_number_table();
8566: x_quote_header_id := jtf_number_table();
8567: x_quote_line_id := jtf_number_table();
8568: x_quote_shipment_id := jtf_number_table();

Line 8626: x_expiration_date := jtf_date_table();

8622: x_source_system_code := jtf_varchar2_table_100();
8623: x_benefit_qty := jtf_number_table();
8624: x_benefit_uom_code := jtf_varchar2_table_100();
8625: x_print_on_invoice_flag := jtf_varchar2_table_100();
8626: x_expiration_date := jtf_date_table();
8627: x_rebate_transaction_type_code := jtf_varchar2_table_100();
8628: x_rebate_transaction_reference := jtf_varchar2_table_100();
8629: x_rebate_payment_system_code := jtf_varchar2_table_100();
8630: x_redeemed_date := jtf_date_table();

Line 8630: x_redeemed_date := jtf_date_table();

8626: x_expiration_date := jtf_date_table();
8627: x_rebate_transaction_type_code := jtf_varchar2_table_100();
8628: x_rebate_transaction_reference := jtf_varchar2_table_100();
8629: x_rebate_payment_system_code := jtf_varchar2_table_100();
8630: x_redeemed_date := jtf_date_table();
8631: x_redeemed_flag := jtf_varchar2_table_100();
8632: x_modifier_level_code := jtf_varchar2_table_100();
8633: x_price_break_type_code := jtf_varchar2_table_100();
8634: x_substitution_attribute := jtf_varchar2_table_100();

Line 8840: x_creation_date OUT NOCOPY jtf_date_table,

8836:
8837: /*-- The following output parameters are ignored
8838: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
8839: x_qte_line_index OUT NOCOPY jtf_number_table,
8840: x_creation_date OUT NOCOPY jtf_date_table,
8841: x_created_by OUT NOCOPY jtf_number_table,
8842: x_last_update_date OUT NOCOPY jtf_date_table,
8843: x_last_updated_by OUT NOCOPY jtf_number_table,
8844: x_last_update_login OUT NOCOPY jtf_number_table,

Line 8842: x_last_update_date OUT NOCOPY jtf_date_table,

8838: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
8839: x_qte_line_index OUT NOCOPY jtf_number_table,
8840: x_creation_date OUT NOCOPY jtf_date_table,
8841: x_created_by OUT NOCOPY jtf_number_table,
8842: x_last_update_date OUT NOCOPY jtf_date_table,
8843: x_last_updated_by OUT NOCOPY jtf_number_table,
8844: x_last_update_login OUT NOCOPY jtf_number_table,
8845: x_request_id OUT NOCOPY jtf_number_table,
8846: x_program_application_id OUT NOCOPY jtf_number_table,

Line 8848: x_program_update_date OUT NOCOPY jtf_date_table,

8844: x_last_update_login OUT NOCOPY jtf_number_table,
8845: x_request_id OUT NOCOPY jtf_number_table,
8846: x_program_application_id OUT NOCOPY jtf_number_table,
8847: x_program_id OUT NOCOPY jtf_number_table,
8848: x_program_update_date OUT NOCOPY jtf_date_table,
8849: x_quote_header_id OUT NOCOPY jtf_number_table,
8850: x_quote_line_id OUT NOCOPY jtf_number_table,
8851: x_flex_title OUT NOCOPY jtf_varchar2_table_100,
8852: x_pricing_context OUT NOCOPY jtf_varchar2_table_100,

Line 8979: x_creation_date := jtf_date_table();

8975:
8976: /*-- The following output parameters are ignored
8977: x_operation_code := jtf_varchar2_table_100();
8978: x_qte_line_index := jtf_number_table();
8979: x_creation_date := jtf_date_table();
8980: x_created_by := jtf_number_table();
8981: x_last_update_date := jtf_date_table();
8982: x_last_updated_by := jtf_number_table();
8983: x_last_update_login := jtf_number_table();

Line 8981: x_last_update_date := jtf_date_table();

8977: x_operation_code := jtf_varchar2_table_100();
8978: x_qte_line_index := jtf_number_table();
8979: x_creation_date := jtf_date_table();
8980: x_created_by := jtf_number_table();
8981: x_last_update_date := jtf_date_table();
8982: x_last_updated_by := jtf_number_table();
8983: x_last_update_login := jtf_number_table();
8984: x_request_id := jtf_number_table();
8985: x_program_application_id := jtf_number_table();

Line 8987: x_program_update_date := jtf_date_table();

8983: x_last_update_login := jtf_number_table();
8984: x_request_id := jtf_number_table();
8985: x_program_application_id := jtf_number_table();
8986: x_program_id := jtf_number_table();
8987: x_program_update_date := jtf_date_table();
8988: x_quote_header_id := jtf_number_table();
8989: x_quote_line_id := jtf_number_table();
8990: x_flex_title := jtf_varchar2_table_100();
8991: x_pricing_context := jtf_varchar2_table_100();

Line 9404: x_creation_date OUT NOCOPY jtf_date_table,

9400:
9401: /*-- The following output parameters are ignored
9402: x_qte_line_index OUT NOCOPY jtf_number_table,
9403: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
9404: x_creation_date OUT NOCOPY jtf_date_table,
9405: x_created_by OUT NOCOPY jtf_number_table,
9406: x_last_updated_by OUT NOCOPY jtf_number_table,
9407: x_last_update_date OUT NOCOPY jtf_date_table,
9408: x_last_update_login OUT NOCOPY jtf_number_table,

Line 9407: x_last_update_date OUT NOCOPY jtf_date_table,

9403: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
9404: x_creation_date OUT NOCOPY jtf_date_table,
9405: x_created_by OUT NOCOPY jtf_number_table,
9406: x_last_updated_by OUT NOCOPY jtf_number_table,
9407: x_last_update_date OUT NOCOPY jtf_date_table,
9408: x_last_update_login OUT NOCOPY jtf_number_table,
9409: x_request_id OUT NOCOPY jtf_number_table,
9410: x_program_application_id OUT NOCOPY jtf_number_table,
9411: x_program_id OUT NOCOPY jtf_number_table,

Line 9412: x_program_update_date OUT NOCOPY jtf_date_table,

9408: x_last_update_login OUT NOCOPY jtf_number_table,
9409: x_request_id OUT NOCOPY jtf_number_table,
9410: x_program_application_id OUT NOCOPY jtf_number_table,
9411: x_program_id OUT NOCOPY jtf_number_table,
9412: x_program_update_date OUT NOCOPY jtf_date_table,
9413: x_quote_header_id OUT NOCOPY jtf_number_table,
9414: x_quote_line_id OUT NOCOPY jtf_number_table,
9415: x_percent OUT NOCOPY jtf_number_table,
9416: x_resource_id OUT NOCOPY jtf_number_table,

Line 9449: x_creation_date := jtf_date_table();

9445:
9446: /*-- The following output parameters are ignored
9447: x_qte_line_index := jtf_number_table();
9448: x_operation_code := jtf_varchar2_table_100();
9449: x_creation_date := jtf_date_table();
9450: x_created_by := jtf_number_table();
9451: x_last_updated_by := jtf_number_table();
9452: x_last_update_date := jtf_date_table();
9453: x_last_update_login := jtf_number_table();

Line 9452: x_last_update_date := jtf_date_table();

9448: x_operation_code := jtf_varchar2_table_100();
9449: x_creation_date := jtf_date_table();
9450: x_created_by := jtf_number_table();
9451: x_last_updated_by := jtf_number_table();
9452: x_last_update_date := jtf_date_table();
9453: x_last_update_login := jtf_number_table();
9454: x_request_id := jtf_number_table();
9455: x_program_application_id := jtf_number_table();
9456: x_program_id := jtf_number_table();

Line 9457: x_program_update_date := jtf_date_table();

9453: x_last_update_login := jtf_number_table();
9454: x_request_id := jtf_number_table();
9455: x_program_application_id := jtf_number_table();
9456: x_program_id := jtf_number_table();
9457: x_program_update_date := jtf_date_table();
9458: x_quote_header_id := jtf_number_table();
9459: x_quote_line_id := jtf_number_table();
9460: x_percent := jtf_number_table();
9461: x_resource_id := jtf_number_table();

Line 9595: x_date_sent OUT NOCOPY jtf_date_table,

9591: x_approver_sequence OUT NOCOPY jtf_number_table,
9592: x_approver_status OUT NOCOPY jtf_varchar2_table_100,
9593: x_approver_name OUT NOCOPY jtf_varchar2_table_100,
9594: x_approval_comments OUT NOCOPY jtf_varchar2_table_300,
9595: x_date_sent OUT NOCOPY jtf_date_table,
9596: x_date_received OUT NOCOPY jtf_date_table
9597: )
9598: AS
9599: ddindx binary_integer; indx binary_integer;

Line 9596: x_date_received OUT NOCOPY jtf_date_table

9592: x_approver_status OUT NOCOPY jtf_varchar2_table_100,
9593: x_approver_name OUT NOCOPY jtf_varchar2_table_100,
9594: x_approval_comments OUT NOCOPY jtf_varchar2_table_300,
9595: x_date_sent OUT NOCOPY jtf_date_table,
9596: x_date_received OUT NOCOPY jtf_date_table
9597: )
9598: AS
9599: ddindx binary_integer; indx binary_integer;
9600: BEGIN

Line 9610: x_date_sent := jtf_date_table();

9606: x_approver_sequence := jtf_number_table();
9607: x_approver_status := jtf_varchar2_table_100();
9608: x_approver_name := jtf_varchar2_table_100();
9609: x_approval_comments := jtf_varchar2_table_300();
9610: x_date_sent := jtf_date_table();
9611: x_date_received := jtf_date_table();
9612: IF p_qte_approvers_list_tbl.count > 0 THEN
9613: x_approval_det_id.extend(p_qte_approvers_list_tbl.count);
9614: x_object_approval_id.extend(p_qte_approvers_list_tbl.count);

Line 9611: x_date_received := jtf_date_table();

9607: x_approver_status := jtf_varchar2_table_100();
9608: x_approver_name := jtf_varchar2_table_100();
9609: x_approval_comments := jtf_varchar2_table_300();
9610: x_date_sent := jtf_date_table();
9611: x_date_received := jtf_date_table();
9612: IF p_qte_approvers_list_tbl.count > 0 THEN
9613: x_approval_det_id.extend(p_qte_approvers_list_tbl.count);
9614: x_object_approval_id.extend(p_qte_approvers_list_tbl.count);
9615: x_approver_person_id.extend(p_qte_approvers_list_tbl.count);

Line 9774: x_requested_ship_date OUT NOCOPY JTF_DATE_TABLE,

9770: x_customer_site_id OUT NOCOPY JTF_NUMBER_TABLE,
9771: x_quantity_ordered OUT NOCOPY JTF_NUMBER_TABLE,
9772: x_quantity_uom OUT NOCOPY JTF_VARCHAR2_TABLE_100,
9773: x_uom_meaning OUT NOCOPY JTF_VARCHAR2_TABLE_100,
9774: x_requested_ship_date OUT NOCOPY JTF_DATE_TABLE,
9775: x_ship_date OUT NOCOPY JTF_DATE_TABLE,
9776: x_available_quantity OUT NOCOPY JTF_NUMBER_TABLE,
9777: x_request_date_quantity OUT NOCOPY JTF_NUMBER_TABLE,
9778: x_error_code OUT NOCOPY JTF_NUMBER_TABLE,

Line 9775: x_ship_date OUT NOCOPY JTF_DATE_TABLE,

9771: x_quantity_ordered OUT NOCOPY JTF_NUMBER_TABLE,
9772: x_quantity_uom OUT NOCOPY JTF_VARCHAR2_TABLE_100,
9773: x_uom_meaning OUT NOCOPY JTF_VARCHAR2_TABLE_100,
9774: x_requested_ship_date OUT NOCOPY JTF_DATE_TABLE,
9775: x_ship_date OUT NOCOPY JTF_DATE_TABLE,
9776: x_available_quantity OUT NOCOPY JTF_NUMBER_TABLE,
9777: x_request_date_quantity OUT NOCOPY JTF_NUMBER_TABLE,
9778: x_error_code OUT NOCOPY JTF_NUMBER_TABLE,
9779: x_message OUT NOCOPY JTF_VARCHAR2_TABLE_2000,

Line 9787: x_group_ship_date OUT NOCOPY jtf_date_table,

9783: x_demand_class_meaning OUT NOCOPY jtf_varchar2_table_300,
9784: x_ship_set_name OUT NOCOPY jtf_varchar2_table_300,
9785: x_arrival_set_name OUT NOCOPY jtf_varchar2_table_300,
9786: x_line_number OUT NOCOPY jtf_varchar2_table_800,
9787: x_group_ship_date OUT NOCOPY jtf_date_table,
9788: x_requested_arrival_date OUT NOCOPY jtf_date_table,
9789: x_ship_method_code OUT NOCOPY jtf_varchar2_table_300,
9790: x_ship_method_meaning OUT NOCOPY jtf_varchar2_table_300,
9791: x_quantity_on_hand OUT NOCOPY jtf_number_table,

Line 9788: x_requested_arrival_date OUT NOCOPY jtf_date_table,

9784: x_ship_set_name OUT NOCOPY jtf_varchar2_table_300,
9785: x_arrival_set_name OUT NOCOPY jtf_varchar2_table_300,
9786: x_line_number OUT NOCOPY jtf_varchar2_table_800,
9787: x_group_ship_date OUT NOCOPY jtf_date_table,
9788: x_requested_arrival_date OUT NOCOPY jtf_date_table,
9789: x_ship_method_code OUT NOCOPY jtf_varchar2_table_300,
9790: x_ship_method_meaning OUT NOCOPY jtf_varchar2_table_300,
9791: x_quantity_on_hand OUT NOCOPY jtf_number_table,
9792: x_quote_header_id OUT NOCOPY jtf_number_table,

Line 9799: x_arrival_date OUT NOCOPY jtf_date_table,

9795: x_ato_line_id OUT NOCOPY jtf_number_table,
9796: x_ref_line_id OUT NOCOPY jtf_number_table,
9797: x_top_model_line_id OUT NOCOPY jtf_number_table,
9798: x_action OUT NOCOPY jtf_number_table,
9799: x_arrival_date OUT NOCOPY jtf_date_table,
9800: x_organization_id OUT NOCOPY jtf_number_table,
9801: x_component_code OUT NOCOPY jtf_varchar2_table_1200,
9802: x_component_sequence_id OUT NOCOPY jtf_number_table,
9803: x_included_item_flag OUT NOCOPY jtf_number_table,

Line 9829: x_requested_ship_date := JTF_DATE_TABLE();

9825: x_customer_site_id := JTF_NUMBER_TABLE();
9826: x_quantity_ordered := JTF_NUMBER_TABLE();
9827: x_quantity_uom := JTF_VARCHAR2_TABLE_100();
9828: x_uom_meaning := JTF_VARCHAR2_TABLE_100();
9829: x_requested_ship_date := JTF_DATE_TABLE();
9830: x_ship_date := JTF_DATE_TABLE();
9831: x_available_quantity := JTF_NUMBER_TABLE();
9832: x_request_date_quantity := JTF_NUMBER_TABLE();
9833: x_error_code := JTF_NUMBER_TABLE();

Line 9830: x_ship_date := JTF_DATE_TABLE();

9826: x_quantity_ordered := JTF_NUMBER_TABLE();
9827: x_quantity_uom := JTF_VARCHAR2_TABLE_100();
9828: x_uom_meaning := JTF_VARCHAR2_TABLE_100();
9829: x_requested_ship_date := JTF_DATE_TABLE();
9830: x_ship_date := JTF_DATE_TABLE();
9831: x_available_quantity := JTF_NUMBER_TABLE();
9832: x_request_date_quantity := JTF_NUMBER_TABLE();
9833: x_error_code := JTF_NUMBER_TABLE();
9834: x_message := JTF_VARCHAR2_TABLE_2000();

Line 9843: x_group_ship_date :=jtf_date_table();

9839: x_demand_class_meaning :=jtf_varchar2_table_300();
9840: x_ship_set_name :=jtf_varchar2_table_300();
9841: x_arrival_set_name :=jtf_varchar2_table_300();
9842: x_line_number :=jtf_varchar2_table_800();
9843: x_group_ship_date :=jtf_date_table();
9844: x_requested_arrival_date :=jtf_date_table();
9845: x_ship_method_code :=jtf_varchar2_table_300();
9846: x_ship_method_meaning :=jtf_varchar2_table_300();
9847: x_quantity_on_hand :=jtf_number_table();

Line 9844: x_requested_arrival_date :=jtf_date_table();

9840: x_ship_set_name :=jtf_varchar2_table_300();
9841: x_arrival_set_name :=jtf_varchar2_table_300();
9842: x_line_number :=jtf_varchar2_table_800();
9843: x_group_ship_date :=jtf_date_table();
9844: x_requested_arrival_date :=jtf_date_table();
9845: x_ship_method_code :=jtf_varchar2_table_300();
9846: x_ship_method_meaning :=jtf_varchar2_table_300();
9847: x_quantity_on_hand :=jtf_number_table();
9848: x_quote_header_id :=jtf_number_table();

Line 9855: x_arrival_date :=jtf_date_table();

9851: x_ato_line_id :=jtf_number_table();
9852: x_ref_line_id :=jtf_number_table();
9853: x_top_model_line_id :=jtf_number_table();
9854: x_action :=jtf_number_table();
9855: x_arrival_date :=jtf_date_table();
9856: x_organization_id :=jtf_number_table();
9857: x_component_code :=jtf_varchar2_table_1200();
9858: x_component_sequence_id :=jtf_number_table();
9859: x_included_item_flag :=jtf_number_table();

Line 11071: p_CREATION_DATE IN jtf_date_table := null,

11067:
11068: FUNCTION Construct_Related_Obj_Tbl(
11069: p_operation_code IN jtf_varchar2_table_100 := NULL,
11070: p_RELATED_OBJECT_ID IN jtf_number_table := NULL,
11071: p_CREATION_DATE IN jtf_date_table := null,
11072: p_CREATED_BY IN jtf_number_table := NULL,
11073: p_LAST_UPDATE_DATE IN jtf_date_table := null,
11074: p_LAST_UPDATED_BY IN jtf_number_table := NULL,
11075: p_LAST_UPDATE_LOGIN IN jtf_number_table := NULL,

Line 11073: p_LAST_UPDATE_DATE IN jtf_date_table := null,

11069: p_operation_code IN jtf_varchar2_table_100 := NULL,
11070: p_RELATED_OBJECT_ID IN jtf_number_table := NULL,
11071: p_CREATION_DATE IN jtf_date_table := null,
11072: p_CREATED_BY IN jtf_number_table := NULL,
11073: p_LAST_UPDATE_DATE IN jtf_date_table := null,
11074: p_LAST_UPDATED_BY IN jtf_number_table := NULL,
11075: p_LAST_UPDATE_LOGIN IN jtf_number_table := NULL,
11076: p_REQUEST_ID IN jtf_number_table := NULL,
11077: p_PROGRAM_APPLICATION_ID IN jtf_number_table := NULL,

Line 11079: p_PROGRAM_UPDATE_DATE IN jtf_date_table := null,

11075: p_LAST_UPDATE_LOGIN IN jtf_number_table := NULL,
11076: p_REQUEST_ID IN jtf_number_table := NULL,
11077: p_PROGRAM_APPLICATION_ID IN jtf_number_table := NULL,
11078: p_PROGRAM_ID IN jtf_number_table := NULL,
11079: p_PROGRAM_UPDATE_DATE IN jtf_date_table := null,
11080: p_QUOTE_OBJECT_TYPE_CODE IN jtf_varchar2_table_300 := NULL,
11081: p_QUOTE_OBJECT_ID IN jtf_number_table := NULL,
11082: p_OBJECT_TYPE_CODE IN jtf_varchar2_table_300 := NULL,
11083: p_OBJECT_ID IN jtf_number_table := NULL,