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 6557: x_last_update_date OUT NOCOPY jtf_date_table

6553: -- copy data OUT NOCOPY /* file.sql.39 change */ from aso quote header table
6554: PROCEDURE Set_Qte_Header_Tbl_Out(
6555: p_qte_header_tbl IN ASO_Quote_Pub.Qte_Header_Tbl_Type,
6556: x_quote_header_id OUT NOCOPY jtf_number_table,
6557: x_last_update_date OUT NOCOPY jtf_date_table
6558:
6559: /*-- The following output parameters are ignored
6560: x_creation_date OUT NOCOPY jtf_date_table,
6561: x_created_by OUT NOCOPY jtf_number_table,

Line 6560: x_creation_date OUT NOCOPY jtf_date_table,

6556: x_quote_header_id OUT NOCOPY jtf_number_table,
6557: x_last_update_date OUT NOCOPY jtf_date_table
6558:
6559: /*-- The following output parameters are ignored
6560: x_creation_date OUT NOCOPY jtf_date_table,
6561: x_created_by OUT NOCOPY jtf_number_table,
6562: x_last_updated_by OUT NOCOPY jtf_number_table,
6563: x_last_update_login OUT NOCOPY jtf_number_table,
6564: x_request_id OUT NOCOPY jtf_number_table,

Line 6567: x_program_update_date OUT NOCOPY jtf_date_table,

6563: x_last_update_login OUT NOCOPY jtf_number_table,
6564: x_request_id OUT NOCOPY jtf_number_table,
6565: x_program_application_id OUT NOCOPY jtf_number_table,
6566: x_program_id OUT NOCOPY jtf_number_table,
6567: x_program_update_date OUT NOCOPY jtf_date_table,
6568: x_org_id OUT NOCOPY jtf_number_table,
6569: x_quote_name OUT NOCOPY jtf_varchar2_table_100,
6570: x_quote_number OUT NOCOPY jtf_number_table,
6571: x_quote_version OUT NOCOPY jtf_number_table,

Line 6574: x_quote_expiration_date OUT NOCOPY jtf_date_table,

6570: x_quote_number OUT NOCOPY jtf_number_table,
6571: x_quote_version OUT NOCOPY jtf_number_table,
6572: x_quote_status_id OUT NOCOPY jtf_number_table,
6573: x_quote_source_code OUT NOCOPY jtf_varchar2_table_300,
6574: x_quote_expiration_date OUT NOCOPY jtf_date_table,
6575: x_price_frozen_date OUT NOCOPY jtf_date_table,
6576: x_quote_password OUT NOCOPY jtf_varchar2_table_300,
6577: x_original_system_reference OUT NOCOPY jtf_varchar2_table_300,
6578: x_party_id OUT NOCOPY jtf_number_table,

Line 6575: x_price_frozen_date OUT NOCOPY jtf_date_table,

6571: x_quote_version OUT NOCOPY jtf_number_table,
6572: x_quote_status_id OUT NOCOPY jtf_number_table,
6573: x_quote_source_code OUT NOCOPY jtf_varchar2_table_300,
6574: x_quote_expiration_date OUT NOCOPY jtf_date_table,
6575: x_price_frozen_date OUT NOCOPY jtf_date_table,
6576: x_quote_password OUT NOCOPY jtf_varchar2_table_300,
6577: x_original_system_reference OUT NOCOPY jtf_varchar2_table_300,
6578: x_party_id OUT NOCOPY jtf_number_table,
6579: x_cust_account_id OUT NOCOPY jtf_number_table,

Line 6589: x_ordered_date OUT NOCOPY jtf_date_table,

6585: x_orig_mktg_source_code_id OUT NOCOPY jtf_number_table,
6586: x_marketing_source_code_id OUT NOCOPY jtf_number_table,
6587: x_order_type_id OUT NOCOPY jtf_number_table,
6588: x_quote_category_code OUT NOCOPY jtf_varchar2_table_300,
6589: x_ordered_date OUT NOCOPY jtf_date_table,
6590: x_accounting_rule_id OUT NOCOPY jtf_number_table,
6591: x_invoicing_rule_id OUT NOCOPY jtf_number_table,
6592: x_employee_person_id OUT NOCOPY jtf_number_table,
6593: x_price_list_id OUT NOCOPY jtf_number_table,

Line 6605: x_exchange_rate_date OUT NOCOPY jtf_date_table,

6601: x_total_quote_price OUT NOCOPY jtf_number_table,
6602: x_payment_amount OUT NOCOPY jtf_number_table,
6603: x_exchange_rate OUT NOCOPY jtf_number_table,
6604: x_exchange_type_code OUT NOCOPY jtf_varchar2_table_100,
6605: x_exchange_rate_date OUT NOCOPY jtf_date_table,
6606: x_contract_id OUT NOCOPY jtf_number_table,
6607: x_sales_channel_code OUT NOCOPY jtf_varchar2_table_100,
6608: x_order_id OUT NOCOPY jtf_number_table,
6609: x_order_number OUT NOCOPY jtf_number_table,

Line 6663: x_last_update_date := jtf_date_table();

6659: AS
6660: ddindx binary_integer; indx binary_integer;
6661: BEGIN
6662: x_quote_header_id := jtf_number_table();
6663: x_last_update_date := jtf_date_table();
6664:
6665: /*-- The following output parameters are ignored
6666: x_creation_date := jtf_date_table();
6667: x_created_by := jtf_number_table();

Line 6666: x_creation_date := jtf_date_table();

6662: x_quote_header_id := jtf_number_table();
6663: x_last_update_date := jtf_date_table();
6664:
6665: /*-- The following output parameters are ignored
6666: x_creation_date := jtf_date_table();
6667: x_created_by := jtf_number_table();
6668: x_last_updated_by := jtf_number_table();
6669: x_last_update_login := jtf_number_table();
6670: x_request_id := jtf_number_table();

Line 6673: x_program_update_date := jtf_date_table();

6669: x_last_update_login := jtf_number_table();
6670: x_request_id := jtf_number_table();
6671: x_program_application_id := jtf_number_table();
6672: x_program_id := jtf_number_table();
6673: x_program_update_date := jtf_date_table();
6674: x_org_id := jtf_number_table();
6675: x_quote_name := jtf_varchar2_table_100();
6676: x_quote_number := jtf_number_table();
6677: x_quote_version := jtf_number_table();

Line 6680: x_quote_expiration_date := jtf_date_table();

6676: x_quote_number := jtf_number_table();
6677: x_quote_version := jtf_number_table();
6678: x_quote_status_id := jtf_number_table();
6679: x_quote_source_code := jtf_varchar2_table_300();
6680: x_quote_expiration_date := jtf_date_table();
6681: x_price_frozen_date := jtf_date_table();
6682: x_quote_password := jtf_varchar2_table_300();
6683: x_original_system_reference := jtf_varchar2_table_300();
6684: x_party_id := jtf_number_table();

Line 6681: x_price_frozen_date := jtf_date_table();

6677: x_quote_version := jtf_number_table();
6678: x_quote_status_id := jtf_number_table();
6679: x_quote_source_code := jtf_varchar2_table_300();
6680: x_quote_expiration_date := jtf_date_table();
6681: x_price_frozen_date := jtf_date_table();
6682: x_quote_password := jtf_varchar2_table_300();
6683: x_original_system_reference := jtf_varchar2_table_300();
6684: x_party_id := jtf_number_table();
6685: x_cust_account_id := jtf_number_table();

Line 6695: x_ordered_date := jtf_date_table();

6691: x_orig_mktg_source_code_id := jtf_number_table();
6692: x_marketing_source_code_id := jtf_number_table();
6693: x_order_type_id := jtf_number_table();
6694: x_quote_category_code := jtf_varchar2_table_300();
6695: x_ordered_date := jtf_date_table();
6696: x_accounting_rule_id := jtf_number_table();
6697: x_invoicing_rule_id := jtf_number_table();
6698: x_employee_person_id := jtf_number_table();
6699: x_price_list_id := jtf_number_table();

Line 6711: x_exchange_rate_date := jtf_date_table();

6707: x_total_quote_price := jtf_number_table();
6708: x_payment_amount := jtf_number_table();
6709: x_exchange_rate := jtf_number_table();
6710: x_exchange_type_code := jtf_varchar2_table_100();
6711: x_exchange_rate_date := jtf_date_table();
6712: x_contract_id := jtf_number_table();
6713: x_sales_channel_code := jtf_varchar2_table_100();
6714: x_order_id := jtf_number_table();
6715: x_order_number := jtf_number_table();

Line 6992: x_creation_date OUT NOCOPY jtf_date_table,

6988: x_quote_line_id OUT NOCOPY jtf_number_table
6989:
6990: /*-- The following output parameters are ignored
6991: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
6992: x_creation_date OUT NOCOPY jtf_date_table,
6993: x_created_by OUT NOCOPY jtf_number_table,
6994: x_last_update_date OUT NOCOPY jtf_date_table,
6995: x_last_updated_by OUT NOCOPY jtf_number_table,
6996: x_last_update_login OUT NOCOPY jtf_number_table,

Line 6994: x_last_update_date OUT NOCOPY jtf_date_table,

6990: /*-- The following output parameters are ignored
6991: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
6992: x_creation_date OUT NOCOPY jtf_date_table,
6993: x_created_by OUT NOCOPY jtf_number_table,
6994: x_last_update_date OUT NOCOPY jtf_date_table,
6995: x_last_updated_by OUT NOCOPY jtf_number_table,
6996: x_last_update_login OUT NOCOPY jtf_number_table,
6997: x_request_id OUT NOCOPY jtf_number_table,
6998: x_program_application_id OUT NOCOPY jtf_number_table,

Line 7000: x_program_update_date OUT NOCOPY jtf_date_table,

6996: x_last_update_login OUT NOCOPY jtf_number_table,
6997: x_request_id OUT NOCOPY jtf_number_table,
6998: x_program_application_id OUT NOCOPY jtf_number_table,
6999: x_program_id OUT NOCOPY jtf_number_table,
7000: x_program_update_date OUT NOCOPY jtf_date_table,
7001: x_quote_header_id OUT NOCOPY jtf_number_table,
7002: x_org_id OUT NOCOPY jtf_number_table,
7003: x_line_category_code OUT NOCOPY jtf_varchar2_table_100,
7004: x_item_type_code OUT NOCOPY jtf_varchar2_table_100,

Line 7006: x_start_date_active OUT NOCOPY jtf_date_table,

7002: x_org_id OUT NOCOPY jtf_number_table,
7003: x_line_category_code OUT NOCOPY jtf_varchar2_table_100,
7004: x_item_type_code OUT NOCOPY jtf_varchar2_table_100,
7005: x_line_number OUT NOCOPY jtf_number_table,
7006: x_start_date_active OUT NOCOPY jtf_date_table,
7007: x_end_date_active OUT NOCOPY jtf_date_table,
7008: x_order_line_type_id OUT NOCOPY jtf_number_table,
7009: x_invoice_to_party_site_id OUT NOCOPY jtf_number_table,
7010: x_invoice_to_party_id OUT NOCOPY jtf_number_table,

Line 7007: x_end_date_active OUT NOCOPY jtf_date_table,

7003: x_line_category_code OUT NOCOPY jtf_varchar2_table_100,
7004: x_item_type_code OUT NOCOPY jtf_varchar2_table_100,
7005: x_line_number OUT NOCOPY jtf_number_table,
7006: x_start_date_active OUT NOCOPY jtf_date_table,
7007: x_end_date_active OUT NOCOPY jtf_date_table,
7008: x_order_line_type_id OUT NOCOPY jtf_number_table,
7009: x_invoice_to_party_site_id OUT NOCOPY jtf_number_table,
7010: x_invoice_to_party_id OUT NOCOPY jtf_number_table,
7011: x_invoice_to_cust_account_id OUT NOCOPY jtf_number_table,

Line 7066: x_creation_date := jtf_date_table();

7062: x_quote_line_id := jtf_number_table();
7063:
7064: /*-- The following output parameters are ignored
7065: x_operation_code := jtf_varchar2_table_100();
7066: x_creation_date := jtf_date_table();
7067: x_created_by := jtf_number_table();
7068: x_last_update_date := jtf_date_table();
7069: x_last_updated_by := jtf_number_table();
7070: x_last_update_login := jtf_number_table();

Line 7068: x_last_update_date := jtf_date_table();

7064: /*-- The following output parameters are ignored
7065: x_operation_code := jtf_varchar2_table_100();
7066: x_creation_date := jtf_date_table();
7067: x_created_by := jtf_number_table();
7068: x_last_update_date := jtf_date_table();
7069: x_last_updated_by := jtf_number_table();
7070: x_last_update_login := jtf_number_table();
7071: x_request_id := jtf_number_table();
7072: x_program_application_id := jtf_number_table();

Line 7074: x_program_update_date := jtf_date_table();

7070: x_last_update_login := jtf_number_table();
7071: x_request_id := jtf_number_table();
7072: x_program_application_id := jtf_number_table();
7073: x_program_id := jtf_number_table();
7074: x_program_update_date := jtf_date_table();
7075: x_quote_header_id := jtf_number_table();
7076: x_org_id := jtf_number_table();
7077: x_line_category_code := jtf_varchar2_table_100();
7078: x_item_type_code := jtf_varchar2_table_100();

Line 7080: x_start_date_active := jtf_date_table();

7076: x_org_id := jtf_number_table();
7077: x_line_category_code := jtf_varchar2_table_100();
7078: x_item_type_code := jtf_varchar2_table_100();
7079: x_line_number := jtf_number_table();
7080: x_start_date_active := jtf_date_table();
7081: x_end_date_active := jtf_date_table();
7082: x_order_line_type_id := jtf_number_table();
7083: x_invoice_to_party_site_id := jtf_number_table();
7084: x_invoice_to_party_id := jtf_number_table();

Line 7081: x_end_date_active := jtf_date_table();

7077: x_line_category_code := jtf_varchar2_table_100();
7078: x_item_type_code := jtf_varchar2_table_100();
7079: x_line_number := jtf_number_table();
7080: x_start_date_active := jtf_date_table();
7081: x_end_date_active := jtf_date_table();
7082: x_order_line_type_id := jtf_number_table();
7083: x_invoice_to_party_site_id := jtf_number_table();
7084: x_invoice_to_party_id := jtf_number_table();
7085: x_invoice_to_cust_account_id := jtf_number_table();

Line 7297: x_creation_date OUT NOCOPY jtf_date_table,

7293:
7294: /*-- The following output parameters are ignored
7295: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
7296: x_qte_line_index OUT NOCOPY jtf_number_table,
7297: x_creation_date OUT NOCOPY jtf_date_table,
7298: x_created_by OUT NOCOPY jtf_number_table,
7299: x_last_update_date OUT NOCOPY jtf_date_table,
7300: x_last_updated_by OUT NOCOPY jtf_number_table,
7301: x_last_update_login OUT NOCOPY jtf_number_table,

Line 7299: x_last_update_date OUT NOCOPY jtf_date_table,

7295: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
7296: x_qte_line_index OUT NOCOPY jtf_number_table,
7297: x_creation_date OUT NOCOPY jtf_date_table,
7298: x_created_by OUT NOCOPY jtf_number_table,
7299: x_last_update_date OUT NOCOPY jtf_date_table,
7300: x_last_updated_by OUT NOCOPY jtf_number_table,
7301: x_last_update_login OUT NOCOPY jtf_number_table,
7302: x_request_id OUT NOCOPY jtf_number_table,
7303: x_program_application_id OUT NOCOPY jtf_number_table,

Line 7305: x_program_update_date OUT NOCOPY jtf_date_table,

7301: x_last_update_login OUT NOCOPY jtf_number_table,
7302: x_request_id OUT NOCOPY jtf_number_table,
7303: x_program_application_id OUT NOCOPY jtf_number_table,
7304: x_program_id OUT NOCOPY jtf_number_table,
7305: x_program_update_date OUT NOCOPY jtf_date_table,
7306: x_quote_line_id OUT NOCOPY jtf_number_table,
7307: x_config_header_id OUT NOCOPY jtf_number_table,
7308: x_config_revision_num OUT NOCOPY jtf_number_table,
7309: x_config_item_id OUT NOCOPY jtf_number_table,

Line 7375: x_creation_date := jtf_date_table();

7371:
7372: /*-- The following output parameters are ignored
7373: x_operation_code := jtf_varchar2_table_100();
7374: x_qte_line_index := jtf_number_table();
7375: x_creation_date := jtf_date_table();
7376: x_created_by := jtf_number_table();
7377: x_last_update_date := jtf_date_table();
7378: x_last_updated_by := jtf_number_table();
7379: x_last_update_login := jtf_number_table();

Line 7377: x_last_update_date := jtf_date_table();

7373: x_operation_code := jtf_varchar2_table_100();
7374: x_qte_line_index := jtf_number_table();
7375: x_creation_date := jtf_date_table();
7376: x_created_by := jtf_number_table();
7377: x_last_update_date := jtf_date_table();
7378: x_last_updated_by := jtf_number_table();
7379: x_last_update_login := jtf_number_table();
7380: x_request_id := jtf_number_table();
7381: x_program_application_id := jtf_number_table();

Line 7383: x_program_update_date := jtf_date_table();

7379: x_last_update_login := jtf_number_table();
7380: x_request_id := jtf_number_table();
7381: x_program_application_id := jtf_number_table();
7382: x_program_id := jtf_number_table();
7383: x_program_update_date := jtf_date_table();
7384: x_quote_line_id := jtf_number_table();
7385: x_config_header_id := jtf_number_table();
7386: x_config_revision_num := jtf_number_table();
7387: x_config_item_id := jtf_number_table();

Line 7616: x_creation_date OUT NOCOPY jtf_date_table,

7612: x_line_relationship_id OUT NOCOPY jtf_number_table
7613:
7614: /*-- The following output parameters are ignored
7615: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
7616: x_creation_date OUT NOCOPY jtf_date_table,
7617: x_created_by OUT NOCOPY jtf_number_table,
7618: x_last_update_date OUT NOCOPY jtf_date_table,
7619: x_last_updated_by OUT NOCOPY jtf_number_table,
7620: x_last_update_login OUT NOCOPY jtf_number_table,

Line 7618: x_last_update_date OUT NOCOPY jtf_date_table,

7614: /*-- The following output parameters are ignored
7615: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
7616: x_creation_date OUT NOCOPY jtf_date_table,
7617: x_created_by OUT NOCOPY jtf_number_table,
7618: x_last_update_date OUT NOCOPY jtf_date_table,
7619: x_last_updated_by OUT NOCOPY jtf_number_table,
7620: x_last_update_login OUT NOCOPY jtf_number_table,
7621: x_request_id OUT NOCOPY jtf_number_table,
7622: x_program_application_id OUT NOCOPY jtf_number_table,

Line 7624: x_program_update_date OUT NOCOPY jtf_date_table,

7620: x_last_update_login OUT NOCOPY jtf_number_table,
7621: x_request_id OUT NOCOPY jtf_number_table,
7622: x_program_application_id OUT NOCOPY jtf_number_table,
7623: x_program_id OUT NOCOPY jtf_number_table,
7624: x_program_update_date OUT NOCOPY jtf_date_table,
7625: x_quote_line_id OUT NOCOPY jtf_number_table,
7626: x_qte_line_index OUT NOCOPY jtf_number_table,
7627: x_related_quote_line_id OUT NOCOPY jtf_number_table,
7628: x_related_qte_line_index OUT NOCOPY jtf_number_table,

Line 7640: x_creation_date := jtf_date_table();

7636: x_line_relationship_id := jtf_number_table();
7637:
7638: /*-- The following output parameters are ignored
7639: x_operation_code := jtf_varchar2_table_100();
7640: x_creation_date := jtf_date_table();
7641: x_created_by := jtf_number_table();
7642: x_last_update_date := jtf_date_table();
7643: x_last_updated_by := jtf_number_table();
7644: x_last_update_login := jtf_number_table();

Line 7642: x_last_update_date := jtf_date_table();

7638: /*-- The following output parameters are ignored
7639: x_operation_code := jtf_varchar2_table_100();
7640: x_creation_date := jtf_date_table();
7641: x_created_by := jtf_number_table();
7642: x_last_update_date := jtf_date_table();
7643: x_last_updated_by := jtf_number_table();
7644: x_last_update_login := jtf_number_table();
7645: x_request_id := jtf_number_table();
7646: x_program_application_id := jtf_number_table();

Line 7648: x_program_update_date := jtf_date_table();

7644: x_last_update_login := jtf_number_table();
7645: x_request_id := jtf_number_table();
7646: x_program_application_id := jtf_number_table();
7647: x_program_id := jtf_number_table();
7648: x_program_update_date := jtf_date_table();
7649: x_quote_line_id := jtf_number_table();
7650: x_qte_line_index := jtf_number_table();
7651: x_related_quote_line_id := jtf_number_table();
7652: x_related_qte_line_index := jtf_number_table();

Line 7722: x_creation_date OUT NOCOPY jtf_date_table,

7718: /*-- The following output parameters are ignored
7719: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
7720: x_qte_line_index OUT NOCOPY jtf_number_table,
7721: x_shipment_index OUT NOCOPY jtf_number_table,
7722: x_creation_date OUT NOCOPY jtf_date_table,
7723: x_created_by OUT NOCOPY jtf_number_table,
7724: x_last_update_date OUT NOCOPY jtf_date_table,
7725: x_last_updated_by OUT NOCOPY jtf_number_table,
7726: x_last_update_login OUT NOCOPY jtf_number_table,

Line 7724: x_last_update_date OUT NOCOPY jtf_date_table,

7720: x_qte_line_index OUT NOCOPY jtf_number_table,
7721: x_shipment_index OUT NOCOPY jtf_number_table,
7722: x_creation_date OUT NOCOPY jtf_date_table,
7723: x_created_by OUT NOCOPY jtf_number_table,
7724: x_last_update_date OUT NOCOPY jtf_date_table,
7725: x_last_updated_by OUT NOCOPY jtf_number_table,
7726: x_last_update_login OUT NOCOPY jtf_number_table,
7727: x_request_id OUT NOCOPY jtf_number_table,
7728: x_program_application_id OUT NOCOPY jtf_number_table,

Line 7730: x_program_update_date OUT NOCOPY jtf_date_table,

7726: x_last_update_login OUT NOCOPY jtf_number_table,
7727: x_request_id OUT NOCOPY jtf_number_table,
7728: x_program_application_id OUT NOCOPY jtf_number_table,
7729: x_program_id OUT NOCOPY jtf_number_table,
7730: x_program_update_date OUT NOCOPY jtf_date_table,
7731: x_quote_header_id OUT NOCOPY jtf_number_table,
7732: x_quote_line_id OUT NOCOPY jtf_number_table,
7733: x_quote_shipment_id OUT NOCOPY jtf_number_table,
7734: x_payment_type_code OUT NOCOPY jtf_varchar2_table_100,

Line 7740: x_credit_card_exp_date OUT NOCOPY jtf_date_table,

7736: x_payment_option OUT NOCOPY jtf_varchar2_table_300,
7737: x_payment_term_id OUT NOCOPY jtf_number_table,
7738: x_credit_card_code OUT NOCOPY jtf_varchar2_table_100,
7739: x_credit_card_holder_name OUT NOCOPY jtf_varchar2_table_100,
7740: x_credit_card_exp_date OUT NOCOPY jtf_date_table,
7741: x_credit_card_approval_code OUT NOCOPY jtf_varchar2_table_100,
7742: x_credit_card_approval_date OUT NOCOPY jtf_date_table,
7743: x_payment_amount OUT NOCOPY jtf_number_table,
7744: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,

Line 7742: x_credit_card_approval_date OUT NOCOPY jtf_date_table,

7738: x_credit_card_code OUT NOCOPY jtf_varchar2_table_100,
7739: x_credit_card_holder_name OUT NOCOPY jtf_varchar2_table_100,
7740: x_credit_card_exp_date OUT NOCOPY jtf_date_table,
7741: x_credit_card_approval_code OUT NOCOPY jtf_varchar2_table_100,
7742: x_credit_card_approval_date OUT NOCOPY jtf_date_table,
7743: x_payment_amount OUT NOCOPY jtf_number_table,
7744: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
7745: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
7746: x_attribute2 OUT NOCOPY jtf_varchar2_table_200,

Line 7772: x_creation_date := jtf_date_table();

7768: /*-- The following output parameters are ignored
7769: x_operation_code := jtf_varchar2_table_100();
7770: x_qte_line_index := jtf_number_table();
7771: x_shipment_index := jtf_number_table();
7772: x_creation_date := jtf_date_table();
7773: x_created_by := jtf_number_table();
7774: x_last_update_date := jtf_date_table();
7775: x_last_updated_by := jtf_number_table();
7776: x_last_update_login := jtf_number_table();

Line 7774: x_last_update_date := jtf_date_table();

7770: x_qte_line_index := jtf_number_table();
7771: x_shipment_index := jtf_number_table();
7772: x_creation_date := jtf_date_table();
7773: x_created_by := jtf_number_table();
7774: x_last_update_date := jtf_date_table();
7775: x_last_updated_by := jtf_number_table();
7776: x_last_update_login := jtf_number_table();
7777: x_request_id := jtf_number_table();
7778: x_program_application_id := jtf_number_table();

Line 7780: x_program_update_date := jtf_date_table();

7776: x_last_update_login := jtf_number_table();
7777: x_request_id := jtf_number_table();
7778: x_program_application_id := jtf_number_table();
7779: x_program_id := jtf_number_table();
7780: x_program_update_date := jtf_date_table();
7781: x_quote_header_id := jtf_number_table();
7782: x_quote_line_id := jtf_number_table();
7783: x_quote_shipment_id := jtf_number_table();
7784: x_payment_type_code := jtf_varchar2_table_100();

Line 7790: x_credit_card_exp_date := jtf_date_table();

7786: x_payment_option := jtf_varchar2_table_300();
7787: x_payment_term_id := jtf_number_table();
7788: x_credit_card_code := jtf_varchar2_table_100();
7789: x_credit_card_holder_name := jtf_varchar2_table_100();
7790: x_credit_card_exp_date := jtf_date_table();
7791: x_credit_card_approval_code := jtf_varchar2_table_100();
7792: x_credit_card_approval_date := jtf_date_table();
7793: x_payment_amount := jtf_number_table();
7794: x_attribute_category := jtf_varchar2_table_100();

Line 7792: x_credit_card_approval_date := jtf_date_table();

7788: x_credit_card_code := jtf_varchar2_table_100();
7789: x_credit_card_holder_name := jtf_varchar2_table_100();
7790: x_credit_card_exp_date := jtf_date_table();
7791: x_credit_card_approval_code := jtf_varchar2_table_100();
7792: x_credit_card_approval_date := jtf_date_table();
7793: x_payment_amount := jtf_number_table();
7794: x_attribute_category := jtf_varchar2_table_100();
7795: x_attribute1 := jtf_varchar2_table_200();
7796: x_attribute2 := jtf_varchar2_table_200();

Line 7928: x_creation_date OUT NOCOPY jtf_date_table,

7924:
7925: /*-- The following output parameters are ignored
7926: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
7927: x_qte_line_index OUT NOCOPY jtf_number_table,
7928: x_creation_date OUT NOCOPY jtf_date_table,
7929: x_created_by OUT NOCOPY jtf_number_table,
7930: x_last_update_date OUT NOCOPY jtf_date_table,
7931: x_last_updated_by OUT NOCOPY jtf_number_table,
7932: x_last_update_login OUT NOCOPY jtf_number_table,

Line 7930: x_last_update_date OUT NOCOPY jtf_date_table,

7926: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
7927: x_qte_line_index OUT NOCOPY jtf_number_table,
7928: x_creation_date OUT NOCOPY jtf_date_table,
7929: x_created_by OUT NOCOPY jtf_number_table,
7930: x_last_update_date OUT NOCOPY jtf_date_table,
7931: x_last_updated_by OUT NOCOPY jtf_number_table,
7932: x_last_update_login OUT NOCOPY jtf_number_table,
7933: x_request_id OUT NOCOPY jtf_number_table,
7934: x_program_application_id OUT NOCOPY jtf_number_table,

Line 7936: x_program_update_date OUT NOCOPY jtf_date_table,

7932: x_last_update_login OUT NOCOPY jtf_number_table,
7933: x_request_id OUT NOCOPY jtf_number_table,
7934: x_program_application_id OUT NOCOPY jtf_number_table,
7935: x_program_id OUT NOCOPY jtf_number_table,
7936: x_program_update_date OUT NOCOPY jtf_date_table,
7937: x_quote_header_id OUT NOCOPY jtf_number_table,
7938: x_quote_line_id OUT NOCOPY jtf_number_table,
7939: x_promise_date OUT NOCOPY jtf_date_table,
7940: x_request_date OUT NOCOPY jtf_date_table,

Line 7939: x_promise_date OUT NOCOPY jtf_date_table,

7935: x_program_id OUT NOCOPY jtf_number_table,
7936: x_program_update_date OUT NOCOPY jtf_date_table,
7937: x_quote_header_id OUT NOCOPY jtf_number_table,
7938: x_quote_line_id OUT NOCOPY jtf_number_table,
7939: x_promise_date OUT NOCOPY jtf_date_table,
7940: x_request_date OUT NOCOPY jtf_date_table,
7941: x_schedule_ship_date OUT NOCOPY jtf_date_table,
7942: x_ship_to_party_site_id OUT NOCOPY jtf_number_table,
7943: x_ship_to_party_id OUT NOCOPY jtf_number_table,

Line 7940: x_request_date OUT NOCOPY jtf_date_table,

7936: x_program_update_date OUT NOCOPY jtf_date_table,
7937: x_quote_header_id OUT NOCOPY jtf_number_table,
7938: x_quote_line_id OUT NOCOPY jtf_number_table,
7939: x_promise_date OUT NOCOPY jtf_date_table,
7940: x_request_date OUT NOCOPY jtf_date_table,
7941: x_schedule_ship_date OUT NOCOPY jtf_date_table,
7942: x_ship_to_party_site_id OUT NOCOPY jtf_number_table,
7943: x_ship_to_party_id OUT NOCOPY jtf_number_table,
7944: x_ship_to_cust_account_id OUT NOCOPY jtf_number_table,

Line 7941: x_schedule_ship_date OUT NOCOPY jtf_date_table,

7937: x_quote_header_id OUT NOCOPY jtf_number_table,
7938: x_quote_line_id OUT NOCOPY jtf_number_table,
7939: x_promise_date OUT NOCOPY jtf_date_table,
7940: x_request_date OUT NOCOPY jtf_date_table,
7941: x_schedule_ship_date OUT NOCOPY jtf_date_table,
7942: x_ship_to_party_site_id OUT NOCOPY jtf_number_table,
7943: x_ship_to_party_id OUT NOCOPY jtf_number_table,
7944: x_ship_to_cust_account_id OUT NOCOPY jtf_number_table,
7945: x_ship_partial_flag OUT NOCOPY jtf_varchar2_table_300,

Line 8002: x_creation_date := jtf_date_table();

7998:
7999: /*-- The following output parameters are ignored
8000: x_operation_code := jtf_varchar2_table_100();
8001: x_qte_line_index := jtf_number_table();
8002: x_creation_date := jtf_date_table();
8003: x_created_by := jtf_number_table();
8004: x_last_update_date := jtf_date_table();
8005: x_last_updated_by := jtf_number_table();
8006: x_last_update_login := jtf_number_table();

Line 8004: x_last_update_date := jtf_date_table();

8000: x_operation_code := jtf_varchar2_table_100();
8001: x_qte_line_index := jtf_number_table();
8002: x_creation_date := jtf_date_table();
8003: x_created_by := jtf_number_table();
8004: x_last_update_date := jtf_date_table();
8005: x_last_updated_by := jtf_number_table();
8006: x_last_update_login := jtf_number_table();
8007: x_request_id := jtf_number_table();
8008: x_program_application_id := jtf_number_table();

Line 8010: x_program_update_date := jtf_date_table();

8006: x_last_update_login := jtf_number_table();
8007: x_request_id := jtf_number_table();
8008: x_program_application_id := jtf_number_table();
8009: x_program_id := jtf_number_table();
8010: x_program_update_date := jtf_date_table();
8011: x_quote_header_id := jtf_number_table();
8012: x_quote_line_id := jtf_number_table();
8013: x_promise_date := jtf_date_table();
8014: x_request_date := jtf_date_table();

Line 8013: x_promise_date := jtf_date_table();

8009: x_program_id := jtf_number_table();
8010: x_program_update_date := jtf_date_table();
8011: x_quote_header_id := jtf_number_table();
8012: x_quote_line_id := jtf_number_table();
8013: x_promise_date := jtf_date_table();
8014: x_request_date := jtf_date_table();
8015: x_schedule_ship_date := jtf_date_table();
8016: x_ship_to_party_site_id := jtf_number_table();
8017: x_ship_to_party_id := jtf_number_table();

Line 8014: x_request_date := jtf_date_table();

8010: x_program_update_date := jtf_date_table();
8011: x_quote_header_id := jtf_number_table();
8012: x_quote_line_id := jtf_number_table();
8013: x_promise_date := jtf_date_table();
8014: x_request_date := jtf_date_table();
8015: x_schedule_ship_date := jtf_date_table();
8016: x_ship_to_party_site_id := jtf_number_table();
8017: x_ship_to_party_id := jtf_number_table();
8018: x_ship_to_cust_account_id := jtf_number_table();

Line 8015: x_schedule_ship_date := jtf_date_table();

8011: x_quote_header_id := jtf_number_table();
8012: x_quote_line_id := jtf_number_table();
8013: x_promise_date := jtf_date_table();
8014: x_request_date := jtf_date_table();
8015: x_schedule_ship_date := jtf_date_table();
8016: x_ship_to_party_site_id := jtf_number_table();
8017: x_ship_to_party_id := jtf_number_table();
8018: x_ship_to_cust_account_id := jtf_number_table();
8019: x_ship_partial_flag := jtf_varchar2_table_300();

Line 8236: x_creation_date OUT NOCOPY jtf_date_table,

8232: x_shipment_index OUT NOCOPY jtf_number_table,
8233: x_quote_header_id OUT NOCOPY jtf_number_table,
8234: x_quote_line_id OUT NOCOPY jtf_number_table,
8235: x_quote_shipment_id OUT NOCOPY jtf_number_table,
8236: x_creation_date OUT NOCOPY jtf_date_table,
8237: x_created_by OUT NOCOPY jtf_number_table,
8238: x_last_update_date OUT NOCOPY jtf_date_table,
8239: x_last_updated_by OUT NOCOPY jtf_number_table,
8240: x_last_update_login OUT NOCOPY jtf_number_table,

Line 8238: x_last_update_date OUT NOCOPY jtf_date_table,

8234: x_quote_line_id OUT NOCOPY jtf_number_table,
8235: x_quote_shipment_id OUT NOCOPY jtf_number_table,
8236: x_creation_date OUT NOCOPY jtf_date_table,
8237: x_created_by OUT NOCOPY jtf_number_table,
8238: x_last_update_date OUT NOCOPY jtf_date_table,
8239: x_last_updated_by OUT NOCOPY jtf_number_table,
8240: x_last_update_login OUT NOCOPY jtf_number_table,
8241: x_request_id OUT NOCOPY jtf_number_table,
8242: x_program_application_id OUT NOCOPY jtf_number_table,

Line 8244: x_program_update_date OUT NOCOPY jtf_date_table,

8240: x_last_update_login OUT NOCOPY jtf_number_table,
8241: x_request_id OUT NOCOPY jtf_number_table,
8242: x_program_application_id OUT NOCOPY jtf_number_table,
8243: x_program_id OUT NOCOPY jtf_number_table,
8244: x_program_update_date OUT NOCOPY jtf_date_table,
8245: x_orig_tax_code OUT NOCOPY jtf_varchar2_table_300,
8246: x_tax_code OUT NOCOPY jtf_varchar2_table_100,
8247: x_tax_rate OUT NOCOPY jtf_number_table,
8248: x_tax_date OUT NOCOPY jtf_date_table,

Line 8248: x_tax_date OUT NOCOPY jtf_date_table,

8244: x_program_update_date OUT NOCOPY jtf_date_table,
8245: x_orig_tax_code OUT NOCOPY jtf_varchar2_table_300,
8246: x_tax_code OUT NOCOPY jtf_varchar2_table_100,
8247: x_tax_rate OUT NOCOPY jtf_number_table,
8248: x_tax_date OUT NOCOPY jtf_date_table,
8249: x_tax_amount OUT NOCOPY jtf_number_table,
8250: x_tax_exempt_flag OUT NOCOPY jtf_varchar2_table_100,
8251: x_tax_exempt_number OUT NOCOPY jtf_varchar2_table_100,
8252: x_tax_exempt_reason_code OUT NOCOPY jtf_varchar2_table_100,

Line 8283: x_creation_date := jtf_date_table();

8279: x_shipment_index := jtf_number_table();
8280: x_quote_header_id := jtf_number_table();
8281: x_quote_line_id := jtf_number_table();
8282: x_quote_shipment_id := jtf_number_table();
8283: x_creation_date := jtf_date_table();
8284: x_created_by := jtf_number_table();
8285: x_last_update_date := jtf_date_table();
8286: x_last_updated_by := jtf_number_table();
8287: x_last_update_login := jtf_number_table();

Line 8285: x_last_update_date := jtf_date_table();

8281: x_quote_line_id := jtf_number_table();
8282: x_quote_shipment_id := jtf_number_table();
8283: x_creation_date := jtf_date_table();
8284: x_created_by := jtf_number_table();
8285: x_last_update_date := jtf_date_table();
8286: x_last_updated_by := jtf_number_table();
8287: x_last_update_login := jtf_number_table();
8288: x_request_id := jtf_number_table();
8289: x_program_application_id := jtf_number_table();

Line 8291: x_program_update_date := jtf_date_table();

8287: x_last_update_login := jtf_number_table();
8288: x_request_id := jtf_number_table();
8289: x_program_application_id := jtf_number_table();
8290: x_program_id := jtf_number_table();
8291: x_program_update_date := jtf_date_table();
8292: x_orig_tax_code := jtf_varchar2_table_300();
8293: x_tax_code := jtf_varchar2_table_100();
8294: x_tax_rate := jtf_number_table();
8295: x_tax_date := jtf_date_table();

Line 8295: x_tax_date := jtf_date_table();

8291: x_program_update_date := jtf_date_table();
8292: x_orig_tax_code := jtf_varchar2_table_300();
8293: x_tax_code := jtf_varchar2_table_100();
8294: x_tax_rate := jtf_number_table();
8295: x_tax_date := jtf_date_table();
8296: x_tax_amount := jtf_number_table();
8297: x_tax_exempt_flag := jtf_varchar2_table_100();
8298: x_tax_exempt_number := jtf_varchar2_table_100();
8299: x_tax_exempt_reason_code := jtf_varchar2_table_100();

Line 8429: x_creation_date OUT NOCOPY jtf_date_table,

8425: /*-- The following output parameters are ignored
8426: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
8427: x_qte_line_index OUT NOCOPY jtf_number_table,
8428: x_shipment_index OUT NOCOPY jtf_number_table,
8429: x_creation_date OUT NOCOPY jtf_date_table,
8430: x_created_by OUT NOCOPY jtf_number_table,
8431: x_last_update_date OUT NOCOPY jtf_date_table,
8432: x_last_updated_by OUT NOCOPY jtf_number_table,
8433: x_last_update_login OUT NOCOPY jtf_number_table,

Line 8431: x_last_update_date OUT NOCOPY jtf_date_table,

8427: x_qte_line_index OUT NOCOPY jtf_number_table,
8428: x_shipment_index OUT NOCOPY jtf_number_table,
8429: x_creation_date OUT NOCOPY jtf_date_table,
8430: x_created_by OUT NOCOPY jtf_number_table,
8431: x_last_update_date OUT NOCOPY jtf_date_table,
8432: x_last_updated_by OUT NOCOPY jtf_number_table,
8433: x_last_update_login OUT NOCOPY jtf_number_table,
8434: x_program_application_id OUT NOCOPY jtf_number_table,
8435: x_program_id OUT NOCOPY jtf_number_table,

Line 8436: x_program_update_date OUT NOCOPY jtf_date_table,

8432: x_last_updated_by OUT NOCOPY jtf_number_table,
8433: x_last_update_login OUT NOCOPY jtf_number_table,
8434: x_program_application_id OUT NOCOPY jtf_number_table,
8435: x_program_id OUT NOCOPY jtf_number_table,
8436: x_program_update_date OUT NOCOPY jtf_date_table,
8437: x_request_id OUT NOCOPY jtf_number_table,
8438: x_quote_header_id OUT NOCOPY jtf_number_table,
8439: x_quote_line_id OUT NOCOPY jtf_number_table,
8440: x_quote_shipment_id OUT NOCOPY jtf_number_table,

Line 8498: x_expiration_date OUT NOCOPY jtf_date_table,

8494: x_source_system_code OUT NOCOPY jtf_varchar2_table_100,
8495: x_benefit_qty OUT NOCOPY jtf_number_table,
8496: x_benefit_uom_code OUT NOCOPY jtf_varchar2_table_100,
8497: x_print_on_invoice_flag OUT NOCOPY jtf_varchar2_table_100,
8498: x_expiration_date OUT NOCOPY jtf_date_table,
8499: x_rebate_transaction_type_code OUT NOCOPY jtf_varchar2_table_100,
8500: x_rebate_transaction_reference OUT NOCOPY jtf_varchar2_table_100,
8501: x_rebate_payment_system_code OUT NOCOPY jtf_varchar2_table_100,
8502: x_redeemed_date OUT NOCOPY jtf_date_table,

Line 8502: x_redeemed_date OUT NOCOPY jtf_date_table,

8498: x_expiration_date OUT NOCOPY jtf_date_table,
8499: x_rebate_transaction_type_code OUT NOCOPY jtf_varchar2_table_100,
8500: x_rebate_transaction_reference OUT NOCOPY jtf_varchar2_table_100,
8501: x_rebate_payment_system_code OUT NOCOPY jtf_varchar2_table_100,
8502: x_redeemed_date OUT NOCOPY jtf_date_table,
8503: x_redeemed_flag OUT NOCOPY jtf_varchar2_table_100,
8504: x_modifier_level_code OUT NOCOPY jtf_varchar2_table_100,
8505: x_price_break_type_code OUT NOCOPY jtf_varchar2_table_100,
8506: x_substitution_attribute OUT NOCOPY jtf_varchar2_table_100,

Line 8521: x_creation_date := jtf_date_table();

8517: /*-- The following output parameters are ignored
8518: x_operation_code := jtf_varchar2_table_100();
8519: x_qte_line_index := jtf_number_table();
8520: x_shipment_index := jtf_number_table();
8521: x_creation_date := jtf_date_table();
8522: x_created_by := jtf_number_table();
8523: x_last_update_date := jtf_date_table();
8524: x_last_updated_by := jtf_number_table();
8525: x_last_update_login := jtf_number_table();

Line 8523: x_last_update_date := jtf_date_table();

8519: x_qte_line_index := jtf_number_table();
8520: x_shipment_index := jtf_number_table();
8521: x_creation_date := jtf_date_table();
8522: x_created_by := jtf_number_table();
8523: x_last_update_date := jtf_date_table();
8524: x_last_updated_by := jtf_number_table();
8525: x_last_update_login := jtf_number_table();
8526: x_program_application_id := jtf_number_table();
8527: x_program_id := jtf_number_table();

Line 8528: x_program_update_date := jtf_date_table();

8524: x_last_updated_by := jtf_number_table();
8525: x_last_update_login := jtf_number_table();
8526: x_program_application_id := jtf_number_table();
8527: x_program_id := jtf_number_table();
8528: x_program_update_date := jtf_date_table();
8529: x_request_id := jtf_number_table();
8530: x_quote_header_id := jtf_number_table();
8531: x_quote_line_id := jtf_number_table();
8532: x_quote_shipment_id := jtf_number_table();

Line 8590: x_expiration_date := jtf_date_table();

8586: x_source_system_code := jtf_varchar2_table_100();
8587: x_benefit_qty := jtf_number_table();
8588: x_benefit_uom_code := jtf_varchar2_table_100();
8589: x_print_on_invoice_flag := jtf_varchar2_table_100();
8590: x_expiration_date := jtf_date_table();
8591: x_rebate_transaction_type_code := jtf_varchar2_table_100();
8592: x_rebate_transaction_reference := jtf_varchar2_table_100();
8593: x_rebate_payment_system_code := jtf_varchar2_table_100();
8594: x_redeemed_date := jtf_date_table();

Line 8594: x_redeemed_date := jtf_date_table();

8590: x_expiration_date := jtf_date_table();
8591: x_rebate_transaction_type_code := jtf_varchar2_table_100();
8592: x_rebate_transaction_reference := jtf_varchar2_table_100();
8593: x_rebate_payment_system_code := jtf_varchar2_table_100();
8594: x_redeemed_date := jtf_date_table();
8595: x_redeemed_flag := jtf_varchar2_table_100();
8596: x_modifier_level_code := jtf_varchar2_table_100();
8597: x_price_break_type_code := jtf_varchar2_table_100();
8598: x_substitution_attribute := jtf_varchar2_table_100();

Line 8804: x_creation_date OUT NOCOPY jtf_date_table,

8800:
8801: /*-- The following output parameters are ignored
8802: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
8803: x_qte_line_index OUT NOCOPY jtf_number_table,
8804: x_creation_date OUT NOCOPY jtf_date_table,
8805: x_created_by OUT NOCOPY jtf_number_table,
8806: x_last_update_date OUT NOCOPY jtf_date_table,
8807: x_last_updated_by OUT NOCOPY jtf_number_table,
8808: x_last_update_login OUT NOCOPY jtf_number_table,

Line 8806: x_last_update_date OUT NOCOPY jtf_date_table,

8802: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
8803: x_qte_line_index OUT NOCOPY jtf_number_table,
8804: x_creation_date OUT NOCOPY jtf_date_table,
8805: x_created_by OUT NOCOPY jtf_number_table,
8806: x_last_update_date OUT NOCOPY jtf_date_table,
8807: x_last_updated_by OUT NOCOPY jtf_number_table,
8808: x_last_update_login OUT NOCOPY jtf_number_table,
8809: x_request_id OUT NOCOPY jtf_number_table,
8810: x_program_application_id OUT NOCOPY jtf_number_table,

Line 8812: x_program_update_date OUT NOCOPY jtf_date_table,

8808: x_last_update_login OUT NOCOPY jtf_number_table,
8809: x_request_id OUT NOCOPY jtf_number_table,
8810: x_program_application_id OUT NOCOPY jtf_number_table,
8811: x_program_id OUT NOCOPY jtf_number_table,
8812: x_program_update_date OUT NOCOPY jtf_date_table,
8813: x_quote_header_id OUT NOCOPY jtf_number_table,
8814: x_quote_line_id OUT NOCOPY jtf_number_table,
8815: x_flex_title OUT NOCOPY jtf_varchar2_table_100,
8816: x_pricing_context OUT NOCOPY jtf_varchar2_table_100,

Line 8943: x_creation_date := jtf_date_table();

8939:
8940: /*-- The following output parameters are ignored
8941: x_operation_code := jtf_varchar2_table_100();
8942: x_qte_line_index := jtf_number_table();
8943: x_creation_date := jtf_date_table();
8944: x_created_by := jtf_number_table();
8945: x_last_update_date := jtf_date_table();
8946: x_last_updated_by := jtf_number_table();
8947: x_last_update_login := jtf_number_table();

Line 8945: x_last_update_date := jtf_date_table();

8941: x_operation_code := jtf_varchar2_table_100();
8942: x_qte_line_index := jtf_number_table();
8943: x_creation_date := jtf_date_table();
8944: x_created_by := jtf_number_table();
8945: x_last_update_date := jtf_date_table();
8946: x_last_updated_by := jtf_number_table();
8947: x_last_update_login := jtf_number_table();
8948: x_request_id := jtf_number_table();
8949: x_program_application_id := jtf_number_table();

Line 8951: x_program_update_date := jtf_date_table();

8947: x_last_update_login := jtf_number_table();
8948: x_request_id := jtf_number_table();
8949: x_program_application_id := jtf_number_table();
8950: x_program_id := jtf_number_table();
8951: x_program_update_date := jtf_date_table();
8952: x_quote_header_id := jtf_number_table();
8953: x_quote_line_id := jtf_number_table();
8954: x_flex_title := jtf_varchar2_table_100();
8955: x_pricing_context := jtf_varchar2_table_100();

Line 9368: x_creation_date OUT NOCOPY jtf_date_table,

9364:
9365: /*-- The following output parameters are ignored
9366: x_qte_line_index OUT NOCOPY jtf_number_table,
9367: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
9368: x_creation_date OUT NOCOPY jtf_date_table,
9369: x_created_by OUT NOCOPY jtf_number_table,
9370: x_last_updated_by OUT NOCOPY jtf_number_table,
9371: x_last_update_date OUT NOCOPY jtf_date_table,
9372: x_last_update_login OUT NOCOPY jtf_number_table,

Line 9371: x_last_update_date OUT NOCOPY jtf_date_table,

9367: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
9368: x_creation_date OUT NOCOPY jtf_date_table,
9369: x_created_by OUT NOCOPY jtf_number_table,
9370: x_last_updated_by OUT NOCOPY jtf_number_table,
9371: x_last_update_date OUT NOCOPY jtf_date_table,
9372: x_last_update_login OUT NOCOPY jtf_number_table,
9373: x_request_id OUT NOCOPY jtf_number_table,
9374: x_program_application_id OUT NOCOPY jtf_number_table,
9375: x_program_id OUT NOCOPY jtf_number_table,

Line 9376: x_program_update_date OUT NOCOPY jtf_date_table,

9372: x_last_update_login OUT NOCOPY jtf_number_table,
9373: x_request_id OUT NOCOPY jtf_number_table,
9374: x_program_application_id OUT NOCOPY jtf_number_table,
9375: x_program_id OUT NOCOPY jtf_number_table,
9376: x_program_update_date OUT NOCOPY jtf_date_table,
9377: x_quote_header_id OUT NOCOPY jtf_number_table,
9378: x_quote_line_id OUT NOCOPY jtf_number_table,
9379: x_percent OUT NOCOPY jtf_number_table,
9380: x_resource_id OUT NOCOPY jtf_number_table,

Line 9413: x_creation_date := jtf_date_table();

9409:
9410: /*-- The following output parameters are ignored
9411: x_qte_line_index := jtf_number_table();
9412: x_operation_code := jtf_varchar2_table_100();
9413: x_creation_date := jtf_date_table();
9414: x_created_by := jtf_number_table();
9415: x_last_updated_by := jtf_number_table();
9416: x_last_update_date := jtf_date_table();
9417: x_last_update_login := jtf_number_table();

Line 9416: x_last_update_date := jtf_date_table();

9412: x_operation_code := jtf_varchar2_table_100();
9413: x_creation_date := jtf_date_table();
9414: x_created_by := jtf_number_table();
9415: x_last_updated_by := jtf_number_table();
9416: x_last_update_date := jtf_date_table();
9417: x_last_update_login := jtf_number_table();
9418: x_request_id := jtf_number_table();
9419: x_program_application_id := jtf_number_table();
9420: x_program_id := jtf_number_table();

Line 9421: x_program_update_date := jtf_date_table();

9417: x_last_update_login := jtf_number_table();
9418: x_request_id := jtf_number_table();
9419: x_program_application_id := jtf_number_table();
9420: x_program_id := jtf_number_table();
9421: x_program_update_date := jtf_date_table();
9422: x_quote_header_id := jtf_number_table();
9423: x_quote_line_id := jtf_number_table();
9424: x_percent := jtf_number_table();
9425: x_resource_id := jtf_number_table();

Line 9559: x_date_sent OUT NOCOPY jtf_date_table,

9555: x_approver_sequence OUT NOCOPY jtf_number_table,
9556: x_approver_status OUT NOCOPY jtf_varchar2_table_100,
9557: x_approver_name OUT NOCOPY jtf_varchar2_table_100,
9558: x_approval_comments OUT NOCOPY jtf_varchar2_table_300,
9559: x_date_sent OUT NOCOPY jtf_date_table,
9560: x_date_received OUT NOCOPY jtf_date_table
9561: )
9562: AS
9563: ddindx binary_integer; indx binary_integer;

Line 9560: x_date_received OUT NOCOPY jtf_date_table

9556: x_approver_status OUT NOCOPY jtf_varchar2_table_100,
9557: x_approver_name OUT NOCOPY jtf_varchar2_table_100,
9558: x_approval_comments OUT NOCOPY jtf_varchar2_table_300,
9559: x_date_sent OUT NOCOPY jtf_date_table,
9560: x_date_received OUT NOCOPY jtf_date_table
9561: )
9562: AS
9563: ddindx binary_integer; indx binary_integer;
9564: BEGIN

Line 9574: x_date_sent := jtf_date_table();

9570: x_approver_sequence := jtf_number_table();
9571: x_approver_status := jtf_varchar2_table_100();
9572: x_approver_name := jtf_varchar2_table_100();
9573: x_approval_comments := jtf_varchar2_table_300();
9574: x_date_sent := jtf_date_table();
9575: x_date_received := jtf_date_table();
9576: IF p_qte_approvers_list_tbl.count > 0 THEN
9577: x_approval_det_id.extend(p_qte_approvers_list_tbl.count);
9578: x_object_approval_id.extend(p_qte_approvers_list_tbl.count);

Line 9575: x_date_received := jtf_date_table();

9571: x_approver_status := jtf_varchar2_table_100();
9572: x_approver_name := jtf_varchar2_table_100();
9573: x_approval_comments := jtf_varchar2_table_300();
9574: x_date_sent := jtf_date_table();
9575: x_date_received := jtf_date_table();
9576: IF p_qte_approvers_list_tbl.count > 0 THEN
9577: x_approval_det_id.extend(p_qte_approvers_list_tbl.count);
9578: x_object_approval_id.extend(p_qte_approvers_list_tbl.count);
9579: x_approver_person_id.extend(p_qte_approvers_list_tbl.count);

Line 9738: x_requested_ship_date OUT NOCOPY JTF_DATE_TABLE,

9734: x_customer_site_id OUT NOCOPY JTF_NUMBER_TABLE,
9735: x_quantity_ordered OUT NOCOPY JTF_NUMBER_TABLE,
9736: x_quantity_uom OUT NOCOPY JTF_VARCHAR2_TABLE_100,
9737: x_uom_meaning OUT NOCOPY JTF_VARCHAR2_TABLE_100,
9738: x_requested_ship_date OUT NOCOPY JTF_DATE_TABLE,
9739: x_ship_date OUT NOCOPY JTF_DATE_TABLE,
9740: x_available_quantity OUT NOCOPY JTF_NUMBER_TABLE,
9741: x_request_date_quantity OUT NOCOPY JTF_NUMBER_TABLE,
9742: x_error_code OUT NOCOPY JTF_NUMBER_TABLE,

Line 9739: x_ship_date OUT NOCOPY JTF_DATE_TABLE,

9735: x_quantity_ordered OUT NOCOPY JTF_NUMBER_TABLE,
9736: x_quantity_uom OUT NOCOPY JTF_VARCHAR2_TABLE_100,
9737: x_uom_meaning OUT NOCOPY JTF_VARCHAR2_TABLE_100,
9738: x_requested_ship_date OUT NOCOPY JTF_DATE_TABLE,
9739: x_ship_date OUT NOCOPY JTF_DATE_TABLE,
9740: x_available_quantity OUT NOCOPY JTF_NUMBER_TABLE,
9741: x_request_date_quantity OUT NOCOPY JTF_NUMBER_TABLE,
9742: x_error_code OUT NOCOPY JTF_NUMBER_TABLE,
9743: x_message OUT NOCOPY JTF_VARCHAR2_TABLE_2000,

Line 9751: x_group_ship_date OUT NOCOPY jtf_date_table,

9747: x_demand_class_meaning OUT NOCOPY jtf_varchar2_table_300,
9748: x_ship_set_name OUT NOCOPY jtf_varchar2_table_300,
9749: x_arrival_set_name OUT NOCOPY jtf_varchar2_table_300,
9750: x_line_number OUT NOCOPY jtf_varchar2_table_800,
9751: x_group_ship_date OUT NOCOPY jtf_date_table,
9752: x_requested_arrival_date OUT NOCOPY jtf_date_table,
9753: x_ship_method_code OUT NOCOPY jtf_varchar2_table_300,
9754: x_ship_method_meaning OUT NOCOPY jtf_varchar2_table_300,
9755: x_quantity_on_hand OUT NOCOPY jtf_number_table,

Line 9752: x_requested_arrival_date OUT NOCOPY jtf_date_table,

9748: x_ship_set_name OUT NOCOPY jtf_varchar2_table_300,
9749: x_arrival_set_name OUT NOCOPY jtf_varchar2_table_300,
9750: x_line_number OUT NOCOPY jtf_varchar2_table_800,
9751: x_group_ship_date OUT NOCOPY jtf_date_table,
9752: x_requested_arrival_date OUT NOCOPY jtf_date_table,
9753: x_ship_method_code OUT NOCOPY jtf_varchar2_table_300,
9754: x_ship_method_meaning OUT NOCOPY jtf_varchar2_table_300,
9755: x_quantity_on_hand OUT NOCOPY jtf_number_table,
9756: x_quote_header_id OUT NOCOPY jtf_number_table,

Line 9763: x_arrival_date OUT NOCOPY jtf_date_table,

9759: x_ato_line_id OUT NOCOPY jtf_number_table,
9760: x_ref_line_id OUT NOCOPY jtf_number_table,
9761: x_top_model_line_id OUT NOCOPY jtf_number_table,
9762: x_action OUT NOCOPY jtf_number_table,
9763: x_arrival_date OUT NOCOPY jtf_date_table,
9764: x_organization_id OUT NOCOPY jtf_number_table,
9765: x_component_code OUT NOCOPY jtf_varchar2_table_1200,
9766: x_component_sequence_id OUT NOCOPY jtf_number_table,
9767: x_included_item_flag OUT NOCOPY jtf_number_table,

Line 9793: x_requested_ship_date := JTF_DATE_TABLE();

9789: x_customer_site_id := JTF_NUMBER_TABLE();
9790: x_quantity_ordered := JTF_NUMBER_TABLE();
9791: x_quantity_uom := JTF_VARCHAR2_TABLE_100();
9792: x_uom_meaning := JTF_VARCHAR2_TABLE_100();
9793: x_requested_ship_date := JTF_DATE_TABLE();
9794: x_ship_date := JTF_DATE_TABLE();
9795: x_available_quantity := JTF_NUMBER_TABLE();
9796: x_request_date_quantity := JTF_NUMBER_TABLE();
9797: x_error_code := JTF_NUMBER_TABLE();

Line 9794: x_ship_date := JTF_DATE_TABLE();

9790: x_quantity_ordered := JTF_NUMBER_TABLE();
9791: x_quantity_uom := JTF_VARCHAR2_TABLE_100();
9792: x_uom_meaning := JTF_VARCHAR2_TABLE_100();
9793: x_requested_ship_date := JTF_DATE_TABLE();
9794: x_ship_date := JTF_DATE_TABLE();
9795: x_available_quantity := JTF_NUMBER_TABLE();
9796: x_request_date_quantity := JTF_NUMBER_TABLE();
9797: x_error_code := JTF_NUMBER_TABLE();
9798: x_message := JTF_VARCHAR2_TABLE_2000();

Line 9807: x_group_ship_date :=jtf_date_table();

9803: x_demand_class_meaning :=jtf_varchar2_table_300();
9804: x_ship_set_name :=jtf_varchar2_table_300();
9805: x_arrival_set_name :=jtf_varchar2_table_300();
9806: x_line_number :=jtf_varchar2_table_800();
9807: x_group_ship_date :=jtf_date_table();
9808: x_requested_arrival_date :=jtf_date_table();
9809: x_ship_method_code :=jtf_varchar2_table_300();
9810: x_ship_method_meaning :=jtf_varchar2_table_300();
9811: x_quantity_on_hand :=jtf_number_table();

Line 9808: x_requested_arrival_date :=jtf_date_table();

9804: x_ship_set_name :=jtf_varchar2_table_300();
9805: x_arrival_set_name :=jtf_varchar2_table_300();
9806: x_line_number :=jtf_varchar2_table_800();
9807: x_group_ship_date :=jtf_date_table();
9808: x_requested_arrival_date :=jtf_date_table();
9809: x_ship_method_code :=jtf_varchar2_table_300();
9810: x_ship_method_meaning :=jtf_varchar2_table_300();
9811: x_quantity_on_hand :=jtf_number_table();
9812: x_quote_header_id :=jtf_number_table();

Line 9819: x_arrival_date :=jtf_date_table();

9815: x_ato_line_id :=jtf_number_table();
9816: x_ref_line_id :=jtf_number_table();
9817: x_top_model_line_id :=jtf_number_table();
9818: x_action :=jtf_number_table();
9819: x_arrival_date :=jtf_date_table();
9820: x_organization_id :=jtf_number_table();
9821: x_component_code :=jtf_varchar2_table_1200();
9822: x_component_sequence_id :=jtf_number_table();
9823: x_included_item_flag :=jtf_number_table();

Line 10997: p_CREATION_DATE IN jtf_date_table := null,

10993:
10994: FUNCTION Construct_Related_Obj_Tbl(
10995: p_operation_code IN jtf_varchar2_table_100 := NULL,
10996: p_RELATED_OBJECT_ID IN jtf_number_table := NULL,
10997: p_CREATION_DATE IN jtf_date_table := null,
10998: p_CREATED_BY IN jtf_number_table := NULL,
10999: p_LAST_UPDATE_DATE IN jtf_date_table := null,
11000: p_LAST_UPDATED_BY IN jtf_number_table := NULL,
11001: p_LAST_UPDATE_LOGIN IN jtf_number_table := NULL,

Line 10999: p_LAST_UPDATE_DATE IN jtf_date_table := null,

10995: p_operation_code IN jtf_varchar2_table_100 := NULL,
10996: p_RELATED_OBJECT_ID IN jtf_number_table := NULL,
10997: p_CREATION_DATE IN jtf_date_table := null,
10998: p_CREATED_BY IN jtf_number_table := NULL,
10999: p_LAST_UPDATE_DATE IN jtf_date_table := null,
11000: p_LAST_UPDATED_BY IN jtf_number_table := NULL,
11001: p_LAST_UPDATE_LOGIN IN jtf_number_table := NULL,
11002: p_REQUEST_ID IN jtf_number_table := NULL,
11003: p_PROGRAM_APPLICATION_ID IN jtf_number_table := NULL,

Line 11005: p_PROGRAM_UPDATE_DATE IN jtf_date_table := null,

11001: p_LAST_UPDATE_LOGIN IN jtf_number_table := NULL,
11002: p_REQUEST_ID IN jtf_number_table := NULL,
11003: p_PROGRAM_APPLICATION_ID IN jtf_number_table := NULL,
11004: p_PROGRAM_ID IN jtf_number_table := NULL,
11005: p_PROGRAM_UPDATE_DATE IN jtf_date_table := null,
11006: p_QUOTE_OBJECT_TYPE_CODE IN jtf_varchar2_table_300 := NULL,
11007: p_QUOTE_OBJECT_ID IN jtf_number_table := NULL,
11008: p_OBJECT_TYPE_CODE IN jtf_varchar2_table_300 := NULL,
11009: p_OBJECT_ID IN jtf_number_table := NULL,