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.IBE_QUOTE_W1_PVT dependencies on JTF_VARCHAR2_TABLE_100

Line 17: p_operation_code IN jtf_varchar2_table_100 ,

13: G_FILE_NAME CONSTANT VARCHAR2(12) := 'IBEVQW1B.PLS';
14: l_true VARCHAR2(1) := FND_API.G_TRUE;
15:
16: FUNCTION Construct_Payment_Tbl(
17: p_operation_code IN jtf_varchar2_table_100 ,
18: p_qte_line_index IN jtf_number_table ,
19: p_payment_id IN jtf_number_table ,
20: p_creation_date IN jtf_date_table ,
21: p_created_by IN jtf_number_table ,

Line 31: p_payment_type_code IN jtf_varchar2_table_100 ,

27: p_program_id IN jtf_number_table ,
28: p_program_update_date IN jtf_date_table ,
29: p_quote_header_id IN jtf_number_table ,
30: p_quote_line_id IN jtf_number_table ,
31: p_payment_type_code IN jtf_varchar2_table_100 ,
32: p_payment_ref_number IN jtf_varchar2_table_300 ,
33: p_payment_option IN jtf_varchar2_table_300 ,
34: p_payment_term_id IN jtf_number_table ,
35: p_credit_card_code IN jtf_varchar2_table_100 ,

Line 35: p_credit_card_code IN jtf_varchar2_table_100 ,

31: p_payment_type_code IN jtf_varchar2_table_100 ,
32: p_payment_ref_number IN jtf_varchar2_table_300 ,
33: p_payment_option IN jtf_varchar2_table_300 ,
34: p_payment_term_id IN jtf_number_table ,
35: p_credit_card_code IN jtf_varchar2_table_100 ,
36: p_credit_card_holder_name IN jtf_varchar2_table_100 ,
37: p_credit_card_exp_date IN jtf_date_table ,
38: p_credit_card_approval_code IN jtf_varchar2_table_100 ,
39: p_credit_card_approval_date IN jtf_date_table ,

Line 36: p_credit_card_holder_name IN jtf_varchar2_table_100 ,

32: p_payment_ref_number IN jtf_varchar2_table_300 ,
33: p_payment_option IN jtf_varchar2_table_300 ,
34: p_payment_term_id IN jtf_number_table ,
35: p_credit_card_code IN jtf_varchar2_table_100 ,
36: p_credit_card_holder_name IN jtf_varchar2_table_100 ,
37: p_credit_card_exp_date IN jtf_date_table ,
38: p_credit_card_approval_code IN jtf_varchar2_table_100 ,
39: p_credit_card_approval_date IN jtf_date_table ,
40: p_payment_amount IN jtf_number_table ,

Line 38: p_credit_card_approval_code IN jtf_varchar2_table_100 ,

34: p_payment_term_id IN jtf_number_table ,
35: p_credit_card_code IN jtf_varchar2_table_100 ,
36: p_credit_card_holder_name IN jtf_varchar2_table_100 ,
37: p_credit_card_exp_date IN jtf_date_table ,
38: p_credit_card_approval_code IN jtf_varchar2_table_100 ,
39: p_credit_card_approval_date IN jtf_date_table ,
40: p_payment_amount IN jtf_number_table ,
41: p_cust_po_number IN jtf_varchar2_table_100 ,
42: p_attribute_category IN jtf_varchar2_table_100 ,

Line 41: p_cust_po_number IN jtf_varchar2_table_100 ,

37: p_credit_card_exp_date IN jtf_date_table ,
38: p_credit_card_approval_code IN jtf_varchar2_table_100 ,
39: p_credit_card_approval_date IN jtf_date_table ,
40: p_payment_amount IN jtf_number_table ,
41: p_cust_po_number IN jtf_varchar2_table_100 ,
42: p_attribute_category IN jtf_varchar2_table_100 ,
43: p_attribute1 IN jtf_varchar2_table_200 ,
44: p_attribute2 IN jtf_varchar2_table_200 ,
45: p_attribute3 IN jtf_varchar2_table_200 ,

Line 42: p_attribute_category IN jtf_varchar2_table_100 ,

38: p_credit_card_approval_code IN jtf_varchar2_table_100 ,
39: p_credit_card_approval_date IN jtf_date_table ,
40: p_payment_amount IN jtf_number_table ,
41: p_cust_po_number IN jtf_varchar2_table_100 ,
42: p_attribute_category IN jtf_varchar2_table_100 ,
43: p_attribute1 IN jtf_varchar2_table_200 ,
44: p_attribute2 IN jtf_varchar2_table_200 ,
45: p_attribute3 IN jtf_varchar2_table_200 ,
46: p_attribute4 IN jtf_varchar2_table_200 ,

Line 358: p_operation_code IN jtf_varchar2_table_100 ,

354: END Set_Control_Rec_W;
355:
356:
357: FUNCTION Construct_Price_Adj_Rel_Tbl(
358: p_operation_code IN jtf_varchar2_table_100 ,
359: p_adj_relationship_id IN jtf_number_table ,
360: p_creation_date IN jtf_date_table ,
361: p_created_by IN jtf_number_table ,
362: p_last_update_date IN jtf_date_table ,

Line 478: p_operation_code IN jtf_varchar2_table_100 ,

474: END Construct_Price_Adj_Rel_Tbl;
475:
476:
477: FUNCTION Construct_Price_Adj_Tbl(
478: p_operation_code IN jtf_varchar2_table_100 ,
479: p_qte_line_index IN jtf_number_table ,
480: p_price_adjustment_id IN jtf_number_table ,
481: p_creation_date IN jtf_date_table ,
482: p_created_by IN jtf_number_table ,

Line 494: p_mod_line_type_code IN jtf_varchar2_table_100 ,

490: p_quote_header_id IN jtf_number_table ,
491: p_quote_line_id IN jtf_number_table ,
492: p_modifier_header_id IN jtf_number_table ,
493: p_modifier_line_id IN jtf_number_table ,
494: p_mod_line_type_code IN jtf_varchar2_table_100 ,
495: p_mod_mech_type_code IN jtf_varchar2_table_100 ,
496: p_modified_from IN jtf_number_table ,
497: p_modified_to IN jtf_number_table ,
498: p_operand IN jtf_number_table ,

Line 495: p_mod_mech_type_code IN jtf_varchar2_table_100 ,

491: p_quote_line_id IN jtf_number_table ,
492: p_modifier_header_id IN jtf_number_table ,
493: p_modifier_line_id IN jtf_number_table ,
494: p_mod_line_type_code IN jtf_varchar2_table_100 ,
495: p_mod_mech_type_code IN jtf_varchar2_table_100 ,
496: p_modified_from IN jtf_number_table ,
497: p_modified_to IN jtf_number_table ,
498: p_operand IN jtf_number_table ,
499: p_arithmetic_operator IN jtf_varchar2_table_100 ,

Line 499: p_arithmetic_operator IN jtf_varchar2_table_100 ,

495: p_mod_mech_type_code IN jtf_varchar2_table_100 ,
496: p_modified_from IN jtf_number_table ,
497: p_modified_to IN jtf_number_table ,
498: p_operand IN jtf_number_table ,
499: p_arithmetic_operator IN jtf_varchar2_table_100 ,
500: p_automatic_flag IN jtf_varchar2_table_100 ,
501: p_update_allowable_flag IN jtf_varchar2_table_100 ,
502: p_updated_flag IN jtf_varchar2_table_100 ,
503: p_applied_flag IN jtf_varchar2_table_100 ,

Line 500: p_automatic_flag IN jtf_varchar2_table_100 ,

496: p_modified_from IN jtf_number_table ,
497: p_modified_to IN jtf_number_table ,
498: p_operand IN jtf_number_table ,
499: p_arithmetic_operator IN jtf_varchar2_table_100 ,
500: p_automatic_flag IN jtf_varchar2_table_100 ,
501: p_update_allowable_flag IN jtf_varchar2_table_100 ,
502: p_updated_flag IN jtf_varchar2_table_100 ,
503: p_applied_flag IN jtf_varchar2_table_100 ,
504: p_on_invoice_flag IN jtf_varchar2_table_100 ,

Line 501: p_update_allowable_flag IN jtf_varchar2_table_100 ,

497: p_modified_to IN jtf_number_table ,
498: p_operand IN jtf_number_table ,
499: p_arithmetic_operator IN jtf_varchar2_table_100 ,
500: p_automatic_flag IN jtf_varchar2_table_100 ,
501: p_update_allowable_flag IN jtf_varchar2_table_100 ,
502: p_updated_flag IN jtf_varchar2_table_100 ,
503: p_applied_flag IN jtf_varchar2_table_100 ,
504: p_on_invoice_flag IN jtf_varchar2_table_100 ,
505: p_pricing_phase_id IN jtf_number_table ,

Line 502: p_updated_flag IN jtf_varchar2_table_100 ,

498: p_operand IN jtf_number_table ,
499: p_arithmetic_operator IN jtf_varchar2_table_100 ,
500: p_automatic_flag IN jtf_varchar2_table_100 ,
501: p_update_allowable_flag IN jtf_varchar2_table_100 ,
502: p_updated_flag IN jtf_varchar2_table_100 ,
503: p_applied_flag IN jtf_varchar2_table_100 ,
504: p_on_invoice_flag IN jtf_varchar2_table_100 ,
505: p_pricing_phase_id IN jtf_number_table ,
506: p_attribute_category IN jtf_varchar2_table_100 ,

Line 503: p_applied_flag IN jtf_varchar2_table_100 ,

499: p_arithmetic_operator IN jtf_varchar2_table_100 ,
500: p_automatic_flag IN jtf_varchar2_table_100 ,
501: p_update_allowable_flag IN jtf_varchar2_table_100 ,
502: p_updated_flag IN jtf_varchar2_table_100 ,
503: p_applied_flag IN jtf_varchar2_table_100 ,
504: p_on_invoice_flag IN jtf_varchar2_table_100 ,
505: p_pricing_phase_id IN jtf_number_table ,
506: p_attribute_category IN jtf_varchar2_table_100 ,
507: p_attribute1 IN jtf_varchar2_table_200 ,

Line 504: p_on_invoice_flag IN jtf_varchar2_table_100 ,

500: p_automatic_flag IN jtf_varchar2_table_100 ,
501: p_update_allowable_flag IN jtf_varchar2_table_100 ,
502: p_updated_flag IN jtf_varchar2_table_100 ,
503: p_applied_flag IN jtf_varchar2_table_100 ,
504: p_on_invoice_flag IN jtf_varchar2_table_100 ,
505: p_pricing_phase_id IN jtf_number_table ,
506: p_attribute_category IN jtf_varchar2_table_100 ,
507: p_attribute1 IN jtf_varchar2_table_200 ,
508: p_attribute2 IN jtf_varchar2_table_200 ,

Line 506: p_attribute_category IN jtf_varchar2_table_100 ,

502: p_updated_flag IN jtf_varchar2_table_100 ,
503: p_applied_flag IN jtf_varchar2_table_100 ,
504: p_on_invoice_flag IN jtf_varchar2_table_100 ,
505: p_pricing_phase_id IN jtf_number_table ,
506: p_attribute_category IN jtf_varchar2_table_100 ,
507: p_attribute1 IN jtf_varchar2_table_200 ,
508: p_attribute2 IN jtf_varchar2_table_200 ,
509: p_attribute3 IN jtf_varchar2_table_200 ,
510: p_attribute4 IN jtf_varchar2_table_200 ,

Line 522: p_orig_sys_discount_ref IN jtf_varchar2_table_100 ,

518: p_attribute12 IN jtf_varchar2_table_200 ,
519: p_attribute13 IN jtf_varchar2_table_200 ,
520: p_attribute14 IN jtf_varchar2_table_200 ,
521: p_attribute15 IN jtf_varchar2_table_200 ,
522: p_orig_sys_discount_ref IN jtf_varchar2_table_100 ,
523: p_change_sequence IN jtf_varchar2_table_100 ,
524: p_update_allowed IN jtf_varchar2_table_100 ,
525: p_change_reason_code IN jtf_varchar2_table_100 ,
526: p_change_reason_text IN jtf_varchar2_table_2000 ,

Line 523: p_change_sequence IN jtf_varchar2_table_100 ,

519: p_attribute13 IN jtf_varchar2_table_200 ,
520: p_attribute14 IN jtf_varchar2_table_200 ,
521: p_attribute15 IN jtf_varchar2_table_200 ,
522: p_orig_sys_discount_ref IN jtf_varchar2_table_100 ,
523: p_change_sequence IN jtf_varchar2_table_100 ,
524: p_update_allowed IN jtf_varchar2_table_100 ,
525: p_change_reason_code IN jtf_varchar2_table_100 ,
526: p_change_reason_text IN jtf_varchar2_table_2000 ,
527: p_cost_id IN jtf_number_table ,

Line 524: p_update_allowed IN jtf_varchar2_table_100 ,

520: p_attribute14 IN jtf_varchar2_table_200 ,
521: p_attribute15 IN jtf_varchar2_table_200 ,
522: p_orig_sys_discount_ref IN jtf_varchar2_table_100 ,
523: p_change_sequence IN jtf_varchar2_table_100 ,
524: p_update_allowed IN jtf_varchar2_table_100 ,
525: p_change_reason_code IN jtf_varchar2_table_100 ,
526: p_change_reason_text IN jtf_varchar2_table_2000 ,
527: p_cost_id IN jtf_number_table ,
528: p_tax_code IN jtf_varchar2_table_100 ,

Line 525: p_change_reason_code IN jtf_varchar2_table_100 ,

521: p_attribute15 IN jtf_varchar2_table_200 ,
522: p_orig_sys_discount_ref IN jtf_varchar2_table_100 ,
523: p_change_sequence IN jtf_varchar2_table_100 ,
524: p_update_allowed IN jtf_varchar2_table_100 ,
525: p_change_reason_code IN jtf_varchar2_table_100 ,
526: p_change_reason_text IN jtf_varchar2_table_2000 ,
527: p_cost_id IN jtf_number_table ,
528: p_tax_code IN jtf_varchar2_table_100 ,
529: p_tax_exempt_flag IN jtf_varchar2_table_100 ,

Line 528: p_tax_code IN jtf_varchar2_table_100 ,

524: p_update_allowed IN jtf_varchar2_table_100 ,
525: p_change_reason_code IN jtf_varchar2_table_100 ,
526: p_change_reason_text IN jtf_varchar2_table_2000 ,
527: p_cost_id IN jtf_number_table ,
528: p_tax_code IN jtf_varchar2_table_100 ,
529: p_tax_exempt_flag IN jtf_varchar2_table_100 ,
530: p_tax_exempt_number IN jtf_varchar2_table_100 ,
531: p_tax_exempt_reason_code IN jtf_varchar2_table_100 ,
532: p_parent_adjustment_id IN jtf_number_table ,

Line 529: p_tax_exempt_flag IN jtf_varchar2_table_100 ,

525: p_change_reason_code IN jtf_varchar2_table_100 ,
526: p_change_reason_text IN jtf_varchar2_table_2000 ,
527: p_cost_id IN jtf_number_table ,
528: p_tax_code IN jtf_varchar2_table_100 ,
529: p_tax_exempt_flag IN jtf_varchar2_table_100 ,
530: p_tax_exempt_number IN jtf_varchar2_table_100 ,
531: p_tax_exempt_reason_code IN jtf_varchar2_table_100 ,
532: p_parent_adjustment_id IN jtf_number_table ,
533: p_invoiced_flag IN jtf_varchar2_table_100 ,

Line 530: p_tax_exempt_number IN jtf_varchar2_table_100 ,

526: p_change_reason_text IN jtf_varchar2_table_2000 ,
527: p_cost_id IN jtf_number_table ,
528: p_tax_code IN jtf_varchar2_table_100 ,
529: p_tax_exempt_flag IN jtf_varchar2_table_100 ,
530: p_tax_exempt_number IN jtf_varchar2_table_100 ,
531: p_tax_exempt_reason_code IN jtf_varchar2_table_100 ,
532: p_parent_adjustment_id IN jtf_number_table ,
533: p_invoiced_flag IN jtf_varchar2_table_100 ,
534: p_estimated_flag IN jtf_varchar2_table_100 ,

Line 531: p_tax_exempt_reason_code IN jtf_varchar2_table_100 ,

527: p_cost_id IN jtf_number_table ,
528: p_tax_code IN jtf_varchar2_table_100 ,
529: p_tax_exempt_flag IN jtf_varchar2_table_100 ,
530: p_tax_exempt_number IN jtf_varchar2_table_100 ,
531: p_tax_exempt_reason_code IN jtf_varchar2_table_100 ,
532: p_parent_adjustment_id IN jtf_number_table ,
533: p_invoiced_flag IN jtf_varchar2_table_100 ,
534: p_estimated_flag IN jtf_varchar2_table_100 ,
535: p_inc_in_sales_perfce IN jtf_varchar2_table_100 ,

Line 533: p_invoiced_flag IN jtf_varchar2_table_100 ,

529: p_tax_exempt_flag IN jtf_varchar2_table_100 ,
530: p_tax_exempt_number IN jtf_varchar2_table_100 ,
531: p_tax_exempt_reason_code IN jtf_varchar2_table_100 ,
532: p_parent_adjustment_id IN jtf_number_table ,
533: p_invoiced_flag IN jtf_varchar2_table_100 ,
534: p_estimated_flag IN jtf_varchar2_table_100 ,
535: p_inc_in_sales_perfce IN jtf_varchar2_table_100 ,
536: p_split_action_code IN jtf_varchar2_table_100 ,
537: p_adjusted_amount IN jtf_number_table ,

Line 534: p_estimated_flag IN jtf_varchar2_table_100 ,

530: p_tax_exempt_number IN jtf_varchar2_table_100 ,
531: p_tax_exempt_reason_code IN jtf_varchar2_table_100 ,
532: p_parent_adjustment_id IN jtf_number_table ,
533: p_invoiced_flag IN jtf_varchar2_table_100 ,
534: p_estimated_flag IN jtf_varchar2_table_100 ,
535: p_inc_in_sales_perfce IN jtf_varchar2_table_100 ,
536: p_split_action_code IN jtf_varchar2_table_100 ,
537: p_adjusted_amount IN jtf_number_table ,
538: p_charge_type_code IN jtf_varchar2_table_100 ,

Line 535: p_inc_in_sales_perfce IN jtf_varchar2_table_100 ,

531: p_tax_exempt_reason_code IN jtf_varchar2_table_100 ,
532: p_parent_adjustment_id IN jtf_number_table ,
533: p_invoiced_flag IN jtf_varchar2_table_100 ,
534: p_estimated_flag IN jtf_varchar2_table_100 ,
535: p_inc_in_sales_perfce IN jtf_varchar2_table_100 ,
536: p_split_action_code IN jtf_varchar2_table_100 ,
537: p_adjusted_amount IN jtf_number_table ,
538: p_charge_type_code IN jtf_varchar2_table_100 ,
539: p_charge_subtype_code IN jtf_varchar2_table_100 ,

Line 536: p_split_action_code IN jtf_varchar2_table_100 ,

532: p_parent_adjustment_id IN jtf_number_table ,
533: p_invoiced_flag IN jtf_varchar2_table_100 ,
534: p_estimated_flag IN jtf_varchar2_table_100 ,
535: p_inc_in_sales_perfce IN jtf_varchar2_table_100 ,
536: p_split_action_code IN jtf_varchar2_table_100 ,
537: p_adjusted_amount IN jtf_number_table ,
538: p_charge_type_code IN jtf_varchar2_table_100 ,
539: p_charge_subtype_code IN jtf_varchar2_table_100 ,
540: p_range_break_quantity IN jtf_number_table ,

Line 538: p_charge_type_code IN jtf_varchar2_table_100 ,

534: p_estimated_flag IN jtf_varchar2_table_100 ,
535: p_inc_in_sales_perfce IN jtf_varchar2_table_100 ,
536: p_split_action_code IN jtf_varchar2_table_100 ,
537: p_adjusted_amount IN jtf_number_table ,
538: p_charge_type_code IN jtf_varchar2_table_100 ,
539: p_charge_subtype_code IN jtf_varchar2_table_100 ,
540: p_range_break_quantity IN jtf_number_table ,
541: p_accrual_conv_rate IN jtf_number_table ,
542: p_pricing_group_sequence IN jtf_number_table ,

Line 539: p_charge_subtype_code IN jtf_varchar2_table_100 ,

535: p_inc_in_sales_perfce IN jtf_varchar2_table_100 ,
536: p_split_action_code IN jtf_varchar2_table_100 ,
537: p_adjusted_amount IN jtf_number_table ,
538: p_charge_type_code IN jtf_varchar2_table_100 ,
539: p_charge_subtype_code IN jtf_varchar2_table_100 ,
540: p_range_break_quantity IN jtf_number_table ,
541: p_accrual_conv_rate IN jtf_number_table ,
542: p_pricing_group_sequence IN jtf_number_table ,
543: p_accrual_flag IN jtf_varchar2_table_100 ,

Line 543: p_accrual_flag IN jtf_varchar2_table_100 ,

539: p_charge_subtype_code IN jtf_varchar2_table_100 ,
540: p_range_break_quantity IN jtf_number_table ,
541: p_accrual_conv_rate IN jtf_number_table ,
542: p_pricing_group_sequence IN jtf_number_table ,
543: p_accrual_flag IN jtf_varchar2_table_100 ,
544: p_list_line_no IN jtf_varchar2_table_300 ,
545: p_source_system_code IN jtf_varchar2_table_100 ,
546: p_benefit_qty IN jtf_number_table ,
547: p_benefit_uom_code IN jtf_varchar2_table_100 ,

Line 545: p_source_system_code IN jtf_varchar2_table_100 ,

541: p_accrual_conv_rate IN jtf_number_table ,
542: p_pricing_group_sequence IN jtf_number_table ,
543: p_accrual_flag IN jtf_varchar2_table_100 ,
544: p_list_line_no IN jtf_varchar2_table_300 ,
545: p_source_system_code IN jtf_varchar2_table_100 ,
546: p_benefit_qty IN jtf_number_table ,
547: p_benefit_uom_code IN jtf_varchar2_table_100 ,
548: p_print_on_invoice_flag IN jtf_varchar2_table_100 ,
549: p_expiration_date IN jtf_date_table ,

Line 547: p_benefit_uom_code IN jtf_varchar2_table_100 ,

543: p_accrual_flag IN jtf_varchar2_table_100 ,
544: p_list_line_no IN jtf_varchar2_table_300 ,
545: p_source_system_code IN jtf_varchar2_table_100 ,
546: p_benefit_qty IN jtf_number_table ,
547: p_benefit_uom_code IN jtf_varchar2_table_100 ,
548: p_print_on_invoice_flag IN jtf_varchar2_table_100 ,
549: p_expiration_date IN jtf_date_table ,
550: p_rebate_trans_type_code IN jtf_varchar2_table_100 ,
551: p_rebate_trans_reference IN jtf_varchar2_table_100 ,

Line 548: p_print_on_invoice_flag IN jtf_varchar2_table_100 ,

544: p_list_line_no IN jtf_varchar2_table_300 ,
545: p_source_system_code IN jtf_varchar2_table_100 ,
546: p_benefit_qty IN jtf_number_table ,
547: p_benefit_uom_code IN jtf_varchar2_table_100 ,
548: p_print_on_invoice_flag IN jtf_varchar2_table_100 ,
549: p_expiration_date IN jtf_date_table ,
550: p_rebate_trans_type_code IN jtf_varchar2_table_100 ,
551: p_rebate_trans_reference IN jtf_varchar2_table_100 ,
552: p_rebate_pay_system_code IN jtf_varchar2_table_100 ,

Line 550: p_rebate_trans_type_code IN jtf_varchar2_table_100 ,

546: p_benefit_qty IN jtf_number_table ,
547: p_benefit_uom_code IN jtf_varchar2_table_100 ,
548: p_print_on_invoice_flag IN jtf_varchar2_table_100 ,
549: p_expiration_date IN jtf_date_table ,
550: p_rebate_trans_type_code IN jtf_varchar2_table_100 ,
551: p_rebate_trans_reference IN jtf_varchar2_table_100 ,
552: p_rebate_pay_system_code IN jtf_varchar2_table_100 ,
553: p_redeemed_date IN jtf_date_table ,
554: p_redeemed_flag IN jtf_varchar2_table_100 ,

Line 551: p_rebate_trans_reference IN jtf_varchar2_table_100 ,

547: p_benefit_uom_code IN jtf_varchar2_table_100 ,
548: p_print_on_invoice_flag IN jtf_varchar2_table_100 ,
549: p_expiration_date IN jtf_date_table ,
550: p_rebate_trans_type_code IN jtf_varchar2_table_100 ,
551: p_rebate_trans_reference IN jtf_varchar2_table_100 ,
552: p_rebate_pay_system_code IN jtf_varchar2_table_100 ,
553: p_redeemed_date IN jtf_date_table ,
554: p_redeemed_flag IN jtf_varchar2_table_100 ,
555: p_modifier_level_code IN jtf_varchar2_table_100 ,

Line 552: p_rebate_pay_system_code IN jtf_varchar2_table_100 ,

548: p_print_on_invoice_flag IN jtf_varchar2_table_100 ,
549: p_expiration_date IN jtf_date_table ,
550: p_rebate_trans_type_code IN jtf_varchar2_table_100 ,
551: p_rebate_trans_reference IN jtf_varchar2_table_100 ,
552: p_rebate_pay_system_code IN jtf_varchar2_table_100 ,
553: p_redeemed_date IN jtf_date_table ,
554: p_redeemed_flag IN jtf_varchar2_table_100 ,
555: p_modifier_level_code IN jtf_varchar2_table_100 ,
556: p_price_break_type_code IN jtf_varchar2_table_100 ,

Line 554: p_redeemed_flag IN jtf_varchar2_table_100 ,

550: p_rebate_trans_type_code IN jtf_varchar2_table_100 ,
551: p_rebate_trans_reference IN jtf_varchar2_table_100 ,
552: p_rebate_pay_system_code IN jtf_varchar2_table_100 ,
553: p_redeemed_date IN jtf_date_table ,
554: p_redeemed_flag IN jtf_varchar2_table_100 ,
555: p_modifier_level_code IN jtf_varchar2_table_100 ,
556: p_price_break_type_code IN jtf_varchar2_table_100 ,
557: p_substitution_attribute IN jtf_varchar2_table_100 ,
558: p_proration_type_code IN jtf_varchar2_table_100 ,

Line 555: p_modifier_level_code IN jtf_varchar2_table_100 ,

551: p_rebate_trans_reference IN jtf_varchar2_table_100 ,
552: p_rebate_pay_system_code IN jtf_varchar2_table_100 ,
553: p_redeemed_date IN jtf_date_table ,
554: p_redeemed_flag IN jtf_varchar2_table_100 ,
555: p_modifier_level_code IN jtf_varchar2_table_100 ,
556: p_price_break_type_code IN jtf_varchar2_table_100 ,
557: p_substitution_attribute IN jtf_varchar2_table_100 ,
558: p_proration_type_code IN jtf_varchar2_table_100 ,
559: p_include_on_ret_flag IN jtf_varchar2_table_100 ,

Line 556: p_price_break_type_code IN jtf_varchar2_table_100 ,

552: p_rebate_pay_system_code IN jtf_varchar2_table_100 ,
553: p_redeemed_date IN jtf_date_table ,
554: p_redeemed_flag IN jtf_varchar2_table_100 ,
555: p_modifier_level_code IN jtf_varchar2_table_100 ,
556: p_price_break_type_code IN jtf_varchar2_table_100 ,
557: p_substitution_attribute IN jtf_varchar2_table_100 ,
558: p_proration_type_code IN jtf_varchar2_table_100 ,
559: p_include_on_ret_flag IN jtf_varchar2_table_100 ,
560: p_credit_or_charge_flag IN jtf_varchar2_table_100

Line 557: p_substitution_attribute IN jtf_varchar2_table_100 ,

553: p_redeemed_date IN jtf_date_table ,
554: p_redeemed_flag IN jtf_varchar2_table_100 ,
555: p_modifier_level_code IN jtf_varchar2_table_100 ,
556: p_price_break_type_code IN jtf_varchar2_table_100 ,
557: p_substitution_attribute IN jtf_varchar2_table_100 ,
558: p_proration_type_code IN jtf_varchar2_table_100 ,
559: p_include_on_ret_flag IN jtf_varchar2_table_100 ,
560: p_credit_or_charge_flag IN jtf_varchar2_table_100
561: )

Line 558: p_proration_type_code IN jtf_varchar2_table_100 ,

554: p_redeemed_flag IN jtf_varchar2_table_100 ,
555: p_modifier_level_code IN jtf_varchar2_table_100 ,
556: p_price_break_type_code IN jtf_varchar2_table_100 ,
557: p_substitution_attribute IN jtf_varchar2_table_100 ,
558: p_proration_type_code IN jtf_varchar2_table_100 ,
559: p_include_on_ret_flag IN jtf_varchar2_table_100 ,
560: p_credit_or_charge_flag IN jtf_varchar2_table_100
561: )
562: RETURN ASO_Quote_Pub.Price_Adj_Tbl_Type

Line 559: p_include_on_ret_flag IN jtf_varchar2_table_100 ,

555: p_modifier_level_code IN jtf_varchar2_table_100 ,
556: p_price_break_type_code IN jtf_varchar2_table_100 ,
557: p_substitution_attribute IN jtf_varchar2_table_100 ,
558: p_proration_type_code IN jtf_varchar2_table_100 ,
559: p_include_on_ret_flag IN jtf_varchar2_table_100 ,
560: p_credit_or_charge_flag IN jtf_varchar2_table_100
561: )
562: RETURN ASO_Quote_Pub.Price_Adj_Tbl_Type
563: IS

Line 560: p_credit_or_charge_flag IN jtf_varchar2_table_100

556: p_price_break_type_code IN jtf_varchar2_table_100 ,
557: p_substitution_attribute IN jtf_varchar2_table_100 ,
558: p_proration_type_code IN jtf_varchar2_table_100 ,
559: p_include_on_ret_flag IN jtf_varchar2_table_100 ,
560: p_credit_or_charge_flag IN jtf_varchar2_table_100
561: )
562: RETURN ASO_Quote_Pub.Price_Adj_Tbl_Type
563: IS
564: l_price_adj_tbl ASO_Quote_Pub.Price_Adj_Tbl_Type;

Line 777: p_operation_code IN jtf_varchar2_table_100 ,

773: END Construct_Price_Adj_Tbl;
774:
775:
776: FUNCTION Construct_Price_Adj_Attr_Tbl(
777: p_operation_code IN jtf_varchar2_table_100 ,
778: p_qte_line_index IN jtf_number_table ,
779: p_price_adj_index IN jtf_number_table ,
780: p_price_adj_attrib_id IN jtf_number_table ,
781: p_creation_date IN jtf_date_table ,

Line 791: p_pricing_context IN jtf_varchar2_table_100 ,

787: p_program_id IN jtf_number_table ,
788: p_program_update_date IN jtf_date_table ,
789: p_request_id IN jtf_number_table ,
790: p_price_adjustment_id IN jtf_number_table ,
791: p_pricing_context IN jtf_varchar2_table_100 ,
792: p_pricing_attribute IN jtf_varchar2_table_100 ,
793: p_prc_attr_value_from IN jtf_varchar2_table_300 ,
794: p_pricing_attr_value_to IN jtf_varchar2_table_300 ,
795: p_comparison_operator IN jtf_varchar2_table_100 ,

Line 792: p_pricing_attribute IN jtf_varchar2_table_100 ,

788: p_program_update_date IN jtf_date_table ,
789: p_request_id IN jtf_number_table ,
790: p_price_adjustment_id IN jtf_number_table ,
791: p_pricing_context IN jtf_varchar2_table_100 ,
792: p_pricing_attribute IN jtf_varchar2_table_100 ,
793: p_prc_attr_value_from IN jtf_varchar2_table_300 ,
794: p_pricing_attr_value_to IN jtf_varchar2_table_300 ,
795: p_comparison_operator IN jtf_varchar2_table_100 ,
796: p_flex_title IN jtf_varchar2_table_100

Line 795: p_comparison_operator IN jtf_varchar2_table_100 ,

791: p_pricing_context IN jtf_varchar2_table_100 ,
792: p_pricing_attribute IN jtf_varchar2_table_100 ,
793: p_prc_attr_value_from IN jtf_varchar2_table_300 ,
794: p_pricing_attr_value_to IN jtf_varchar2_table_300 ,
795: p_comparison_operator IN jtf_varchar2_table_100 ,
796: p_flex_title IN jtf_varchar2_table_100
797: )
798: RETURN ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type
799: IS

Line 796: p_flex_title IN jtf_varchar2_table_100

792: p_pricing_attribute IN jtf_varchar2_table_100 ,
793: p_prc_attr_value_from IN jtf_varchar2_table_300 ,
794: p_pricing_attr_value_to IN jtf_varchar2_table_300 ,
795: p_comparison_operator IN jtf_varchar2_table_100 ,
796: p_flex_title IN jtf_varchar2_table_100
797: )
798: RETURN ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type
799: IS
800: l_price_adj_attr_tbl ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type;

Line 905: p_attribute_type_code IN jtf_varchar2_table_100 ,

901: p_program_update_date IN jtf_date_table ,
902: p_quote_header_id IN jtf_number_table ,
903: p_quote_line_id IN jtf_number_table ,
904: p_quote_shipment_id IN jtf_number_table ,
905: p_attribute_type_code IN jtf_varchar2_table_100 ,
906: p_name IN jtf_varchar2_table_100 ,
907: p_value IN jtf_varchar2_table_2000 ,
908: p_value_type IN jtf_varchar2_table_300 ,
909: p_status IN jtf_varchar2_table_100 ,

Line 906: p_name IN jtf_varchar2_table_100 ,

902: p_quote_header_id IN jtf_number_table ,
903: p_quote_line_id IN jtf_number_table ,
904: p_quote_shipment_id IN jtf_number_table ,
905: p_attribute_type_code IN jtf_varchar2_table_100 ,
906: p_name IN jtf_varchar2_table_100 ,
907: p_value IN jtf_varchar2_table_2000 ,
908: p_value_type IN jtf_varchar2_table_300 ,
909: p_status IN jtf_varchar2_table_100 ,
910: p_application_id IN jtf_number_table ,

Line 909: p_status IN jtf_varchar2_table_100 ,

905: p_attribute_type_code IN jtf_varchar2_table_100 ,
906: p_name IN jtf_varchar2_table_100 ,
907: p_value IN jtf_varchar2_table_2000 ,
908: p_value_type IN jtf_varchar2_table_300 ,
909: p_status IN jtf_varchar2_table_100 ,
910: p_application_id IN jtf_number_table ,
911: p_start_date_active IN jtf_date_table ,
912: p_end_date_active IN jtf_date_table ,
913: p_operation_code IN jtf_varchar2_table_100

Line 913: p_operation_code IN jtf_varchar2_table_100

909: p_status IN jtf_varchar2_table_100 ,
910: p_application_id IN jtf_number_table ,
911: p_start_date_active IN jtf_date_table ,
912: p_end_date_active IN jtf_date_table ,
913: p_operation_code IN jtf_varchar2_table_100
914: )
915: RETURN ASO_Quote_Pub.Line_Attribs_Ext_Tbl_Type
916: IS
917: l_line_attribs_ext_tbl ASO_Quote_Pub.Line_Attribs_Ext_Tbl_Type;

Line 1031: p_operation_code IN jtf_varchar2_table_100 ,

1027: END Construct_Line_Attribs_Ext_Tbl;
1028:
1029:
1030: FUNCTION Construct_Freight_Charge_Tbl(
1031: p_operation_code IN jtf_varchar2_table_100 ,
1032: p_qte_line_index IN jtf_number_table ,
1033: p_shipment_index IN jtf_number_table ,
1034: p_freight_charge_id IN jtf_number_table ,
1035: p_last_update_date IN jtf_date_table ,

Line 1182: p_operation_code IN jtf_varchar2_table_100 ,

1178: END Construct_Freight_Charge_Tbl;
1179:
1180:
1181: FUNCTION Construct_Price_Attributes_Tbl(
1182: p_operation_code IN jtf_varchar2_table_100 ,
1183: p_qte_line_index IN jtf_number_table ,
1184: p_price_attribute_id IN jtf_number_table ,
1185: p_creation_date IN jtf_date_table ,
1186: p_created_by IN jtf_number_table ,

Line 1196: p_flex_title IN jtf_varchar2_table_100 ,

1192: p_program_id IN jtf_number_table ,
1193: p_program_update_date IN jtf_date_table ,
1194: p_quote_header_id IN jtf_number_table ,
1195: p_quote_line_id IN jtf_number_table ,
1196: p_flex_title IN jtf_varchar2_table_100 ,
1197: p_pricing_context IN jtf_varchar2_table_100 ,
1198: p_pricing_attribute1 IN jtf_varchar2_table_300 ,
1199: p_pricing_attribute2 IN jtf_varchar2_table_300 ,
1200: p_pricing_attribute3 IN jtf_varchar2_table_300 ,

Line 1197: p_pricing_context IN jtf_varchar2_table_100 ,

1193: p_program_update_date IN jtf_date_table ,
1194: p_quote_header_id IN jtf_number_table ,
1195: p_quote_line_id IN jtf_number_table ,
1196: p_flex_title IN jtf_varchar2_table_100 ,
1197: p_pricing_context IN jtf_varchar2_table_100 ,
1198: p_pricing_attribute1 IN jtf_varchar2_table_300 ,
1199: p_pricing_attribute2 IN jtf_varchar2_table_300 ,
1200: p_pricing_attribute3 IN jtf_varchar2_table_300 ,
1201: p_pricing_attribute4 IN jtf_varchar2_table_300 ,

Line 1298: p_context IN jtf_varchar2_table_100 ,

1294: p_pricing_attribute97 IN jtf_varchar2_table_300 ,
1295: p_pricing_attribute98 IN jtf_varchar2_table_300 ,
1296: p_pricing_attribute99 IN jtf_varchar2_table_300 ,
1297: p_pricing_attribute100 IN jtf_varchar2_table_300 ,
1298: p_context IN jtf_varchar2_table_100 ,
1299: p_attribute1 IN jtf_varchar2_table_300 ,
1300: p_attribute2 IN jtf_varchar2_table_300 ,
1301: p_attribute3 IN jtf_varchar2_table_300 ,
1302: p_attribute4 IN jtf_varchar2_table_300 ,

Line 1757: p_operation_code IN jtf_varchar2_table_100 ,

1753:
1754: --
1755:
1756: FUNCTION Construct_Shipment_Tbl(
1757: p_operation_code IN jtf_varchar2_table_100 ,
1758: p_qte_line_index IN jtf_number_table ,
1759: p_shipment_id IN jtf_number_table ,
1760: p_creation_date IN jtf_date_table ,
1761: p_created_by IN jtf_number_table ,

Line 1779: p_ship_method_code IN jtf_varchar2_table_100 ,

1775: p_ship_to_party_id IN jtf_number_table ,
1776: p_ship_to_cust_acct_id IN jtf_number_table ,
1777: p_ship_partial_flag IN jtf_varchar2_table_300 ,
1778: p_ship_set_id IN jtf_number_table ,
1779: p_ship_method_code IN jtf_varchar2_table_100 ,
1780: p_freight_terms_code IN jtf_varchar2_table_100 ,
1781: p_freight_carrier_code IN jtf_varchar2_table_100 ,
1782: p_fob_code IN jtf_varchar2_table_100 ,
1783: p_shipment_priority_code IN jtf_varchar2_table_100 ,

Line 1780: p_freight_terms_code IN jtf_varchar2_table_100 ,

1776: p_ship_to_cust_acct_id IN jtf_number_table ,
1777: p_ship_partial_flag IN jtf_varchar2_table_300 ,
1778: p_ship_set_id IN jtf_number_table ,
1779: p_ship_method_code IN jtf_varchar2_table_100 ,
1780: p_freight_terms_code IN jtf_varchar2_table_100 ,
1781: p_freight_carrier_code IN jtf_varchar2_table_100 ,
1782: p_fob_code IN jtf_varchar2_table_100 ,
1783: p_shipment_priority_code IN jtf_varchar2_table_100 ,
1784: p_shipping_instructions IN jtf_varchar2_table_2000 ,

Line 1781: p_freight_carrier_code IN jtf_varchar2_table_100 ,

1777: p_ship_partial_flag IN jtf_varchar2_table_300 ,
1778: p_ship_set_id IN jtf_number_table ,
1779: p_ship_method_code IN jtf_varchar2_table_100 ,
1780: p_freight_terms_code IN jtf_varchar2_table_100 ,
1781: p_freight_carrier_code IN jtf_varchar2_table_100 ,
1782: p_fob_code IN jtf_varchar2_table_100 ,
1783: p_shipment_priority_code IN jtf_varchar2_table_100 ,
1784: p_shipping_instructions IN jtf_varchar2_table_2000 ,
1785: p_packing_instructions IN jtf_varchar2_table_2000 ,

Line 1782: p_fob_code IN jtf_varchar2_table_100 ,

1778: p_ship_set_id IN jtf_number_table ,
1779: p_ship_method_code IN jtf_varchar2_table_100 ,
1780: p_freight_terms_code IN jtf_varchar2_table_100 ,
1781: p_freight_carrier_code IN jtf_varchar2_table_100 ,
1782: p_fob_code IN jtf_varchar2_table_100 ,
1783: p_shipment_priority_code IN jtf_varchar2_table_100 ,
1784: p_shipping_instructions IN jtf_varchar2_table_2000 ,
1785: p_packing_instructions IN jtf_varchar2_table_2000 ,
1786: p_quantity IN jtf_number_table ,

Line 1783: p_shipment_priority_code IN jtf_varchar2_table_100 ,

1779: p_ship_method_code IN jtf_varchar2_table_100 ,
1780: p_freight_terms_code IN jtf_varchar2_table_100 ,
1781: p_freight_carrier_code IN jtf_varchar2_table_100 ,
1782: p_fob_code IN jtf_varchar2_table_100 ,
1783: p_shipment_priority_code IN jtf_varchar2_table_100 ,
1784: p_shipping_instructions IN jtf_varchar2_table_2000 ,
1785: p_packing_instructions IN jtf_varchar2_table_2000 ,
1786: p_quantity IN jtf_number_table ,
1787: p_reserved_quantity IN jtf_number_table ,

Line 1791: p_ship_to_cont_fst_name IN jtf_varchar2_table_100 ,

1787: p_reserved_quantity IN jtf_number_table ,
1788: p_reservation_id IN jtf_number_table ,
1789: p_order_line_id IN jtf_number_table ,
1790: p_ship_to_party_name IN jtf_varchar2_table_300 ,
1791: p_ship_to_cont_fst_name IN jtf_varchar2_table_100 ,
1792: p_ship_to_cont_mid_name IN jtf_varchar2_table_100 ,
1793: p_ship_to_cont_lst_name IN jtf_varchar2_table_100 ,
1794: p_ship_to_address1 IN jtf_varchar2_table_300 ,
1795: p_ship_to_address2 IN jtf_varchar2_table_300 ,

Line 1792: p_ship_to_cont_mid_name IN jtf_varchar2_table_100 ,

1788: p_reservation_id IN jtf_number_table ,
1789: p_order_line_id IN jtf_number_table ,
1790: p_ship_to_party_name IN jtf_varchar2_table_300 ,
1791: p_ship_to_cont_fst_name IN jtf_varchar2_table_100 ,
1792: p_ship_to_cont_mid_name IN jtf_varchar2_table_100 ,
1793: p_ship_to_cont_lst_name IN jtf_varchar2_table_100 ,
1794: p_ship_to_address1 IN jtf_varchar2_table_300 ,
1795: p_ship_to_address2 IN jtf_varchar2_table_300 ,
1796: p_ship_to_address3 IN jtf_varchar2_table_300 ,

Line 1793: p_ship_to_cont_lst_name IN jtf_varchar2_table_100 ,

1789: p_order_line_id IN jtf_number_table ,
1790: p_ship_to_party_name IN jtf_varchar2_table_300 ,
1791: p_ship_to_cont_fst_name IN jtf_varchar2_table_100 ,
1792: p_ship_to_cont_mid_name IN jtf_varchar2_table_100 ,
1793: p_ship_to_cont_lst_name IN jtf_varchar2_table_100 ,
1794: p_ship_to_address1 IN jtf_varchar2_table_300 ,
1795: p_ship_to_address2 IN jtf_varchar2_table_300 ,
1796: p_ship_to_address3 IN jtf_varchar2_table_300 ,
1797: p_ship_to_address4 IN jtf_varchar2_table_300 ,

Line 1798: p_ship_to_country_code IN jtf_varchar2_table_100 ,

1794: p_ship_to_address1 IN jtf_varchar2_table_300 ,
1795: p_ship_to_address2 IN jtf_varchar2_table_300 ,
1796: p_ship_to_address3 IN jtf_varchar2_table_300 ,
1797: p_ship_to_address4 IN jtf_varchar2_table_300 ,
1798: p_ship_to_country_code IN jtf_varchar2_table_100 ,
1799: p_ship_to_country IN jtf_varchar2_table_100 ,
1800: p_ship_to_city IN jtf_varchar2_table_100 ,
1801: p_ship_to_postal_code IN jtf_varchar2_table_100 ,
1802: p_ship_to_state IN jtf_varchar2_table_100 ,

Line 1799: p_ship_to_country IN jtf_varchar2_table_100 ,

1795: p_ship_to_address2 IN jtf_varchar2_table_300 ,
1796: p_ship_to_address3 IN jtf_varchar2_table_300 ,
1797: p_ship_to_address4 IN jtf_varchar2_table_300 ,
1798: p_ship_to_country_code IN jtf_varchar2_table_100 ,
1799: p_ship_to_country IN jtf_varchar2_table_100 ,
1800: p_ship_to_city IN jtf_varchar2_table_100 ,
1801: p_ship_to_postal_code IN jtf_varchar2_table_100 ,
1802: p_ship_to_state IN jtf_varchar2_table_100 ,
1803: p_ship_to_province IN jtf_varchar2_table_100 ,

Line 1800: p_ship_to_city IN jtf_varchar2_table_100 ,

1796: p_ship_to_address3 IN jtf_varchar2_table_300 ,
1797: p_ship_to_address4 IN jtf_varchar2_table_300 ,
1798: p_ship_to_country_code IN jtf_varchar2_table_100 ,
1799: p_ship_to_country IN jtf_varchar2_table_100 ,
1800: p_ship_to_city IN jtf_varchar2_table_100 ,
1801: p_ship_to_postal_code IN jtf_varchar2_table_100 ,
1802: p_ship_to_state IN jtf_varchar2_table_100 ,
1803: p_ship_to_province IN jtf_varchar2_table_100 ,
1804: p_ship_to_county IN jtf_varchar2_table_100 ,

Line 1801: p_ship_to_postal_code IN jtf_varchar2_table_100 ,

1797: p_ship_to_address4 IN jtf_varchar2_table_300 ,
1798: p_ship_to_country_code IN jtf_varchar2_table_100 ,
1799: p_ship_to_country IN jtf_varchar2_table_100 ,
1800: p_ship_to_city IN jtf_varchar2_table_100 ,
1801: p_ship_to_postal_code IN jtf_varchar2_table_100 ,
1802: p_ship_to_state IN jtf_varchar2_table_100 ,
1803: p_ship_to_province IN jtf_varchar2_table_100 ,
1804: p_ship_to_county IN jtf_varchar2_table_100 ,
1805: p_attribute_category IN jtf_varchar2_table_100 ,

Line 1802: p_ship_to_state IN jtf_varchar2_table_100 ,

1798: p_ship_to_country_code IN jtf_varchar2_table_100 ,
1799: p_ship_to_country IN jtf_varchar2_table_100 ,
1800: p_ship_to_city IN jtf_varchar2_table_100 ,
1801: p_ship_to_postal_code IN jtf_varchar2_table_100 ,
1802: p_ship_to_state IN jtf_varchar2_table_100 ,
1803: p_ship_to_province IN jtf_varchar2_table_100 ,
1804: p_ship_to_county IN jtf_varchar2_table_100 ,
1805: p_attribute_category IN jtf_varchar2_table_100 ,
1806: p_attribute1 IN jtf_varchar2_table_200 ,

Line 1803: p_ship_to_province IN jtf_varchar2_table_100 ,

1799: p_ship_to_country IN jtf_varchar2_table_100 ,
1800: p_ship_to_city IN jtf_varchar2_table_100 ,
1801: p_ship_to_postal_code IN jtf_varchar2_table_100 ,
1802: p_ship_to_state IN jtf_varchar2_table_100 ,
1803: p_ship_to_province IN jtf_varchar2_table_100 ,
1804: p_ship_to_county IN jtf_varchar2_table_100 ,
1805: p_attribute_category IN jtf_varchar2_table_100 ,
1806: p_attribute1 IN jtf_varchar2_table_200 ,
1807: p_attribute2 IN jtf_varchar2_table_200 ,

Line 1804: p_ship_to_county IN jtf_varchar2_table_100 ,

1800: p_ship_to_city IN jtf_varchar2_table_100 ,
1801: p_ship_to_postal_code IN jtf_varchar2_table_100 ,
1802: p_ship_to_state IN jtf_varchar2_table_100 ,
1803: p_ship_to_province IN jtf_varchar2_table_100 ,
1804: p_ship_to_county IN jtf_varchar2_table_100 ,
1805: p_attribute_category IN jtf_varchar2_table_100 ,
1806: p_attribute1 IN jtf_varchar2_table_200 ,
1807: p_attribute2 IN jtf_varchar2_table_200 ,
1808: p_attribute3 IN jtf_varchar2_table_200 ,

Line 1805: p_attribute_category IN jtf_varchar2_table_100 ,

1801: p_ship_to_postal_code IN jtf_varchar2_table_100 ,
1802: p_ship_to_state IN jtf_varchar2_table_100 ,
1803: p_ship_to_province IN jtf_varchar2_table_100 ,
1804: p_ship_to_county IN jtf_varchar2_table_100 ,
1805: p_attribute_category IN jtf_varchar2_table_100 ,
1806: p_attribute1 IN jtf_varchar2_table_200 ,
1807: p_attribute2 IN jtf_varchar2_table_200 ,
1808: p_attribute3 IN jtf_varchar2_table_200 ,
1809: p_attribute4 IN jtf_varchar2_table_200 ,

Line 2106: p_operation_code IN jtf_varchar2_table_100 ,

2102:
2103:
2104:
2105: FUNCTION Construct_Tax_Detail_Tbl(
2106: p_operation_code IN jtf_varchar2_table_100 ,
2107: p_qte_line_index IN jtf_number_table ,
2108: p_shipment_index IN jtf_number_table ,
2109: p_tax_detail_id IN jtf_number_table ,
2110: p_quote_header_id IN jtf_number_table ,

Line 2123: p_tax_code IN jtf_varchar2_table_100 ,

2119: p_program_application_id IN jtf_number_table ,
2120: p_program_id IN jtf_number_table ,
2121: p_program_update_date IN jtf_date_table ,
2122: p_orig_tax_code IN jtf_varchar2_table_300 ,
2123: p_tax_code IN jtf_varchar2_table_100 ,
2124: p_tax_rate IN jtf_number_table ,
2125: p_tax_date IN jtf_date_table ,
2126: p_tax_amount IN jtf_number_table ,
2127: p_tax_exempt_flag IN jtf_varchar2_table_100 ,

Line 2127: p_tax_exempt_flag IN jtf_varchar2_table_100 ,

2123: p_tax_code IN jtf_varchar2_table_100 ,
2124: p_tax_rate IN jtf_number_table ,
2125: p_tax_date IN jtf_date_table ,
2126: p_tax_amount IN jtf_number_table ,
2127: p_tax_exempt_flag IN jtf_varchar2_table_100 ,
2128: p_tax_exempt_number IN jtf_varchar2_table_100 ,
2129: p_tax_exempt_reason_code IN jtf_varchar2_table_100 ,
2130: p_attribute_category IN jtf_varchar2_table_100 ,
2131: p_attribute1 IN jtf_varchar2_table_200 ,

Line 2128: p_tax_exempt_number IN jtf_varchar2_table_100 ,

2124: p_tax_rate IN jtf_number_table ,
2125: p_tax_date IN jtf_date_table ,
2126: p_tax_amount IN jtf_number_table ,
2127: p_tax_exempt_flag IN jtf_varchar2_table_100 ,
2128: p_tax_exempt_number IN jtf_varchar2_table_100 ,
2129: p_tax_exempt_reason_code IN jtf_varchar2_table_100 ,
2130: p_attribute_category IN jtf_varchar2_table_100 ,
2131: p_attribute1 IN jtf_varchar2_table_200 ,
2132: p_attribute2 IN jtf_varchar2_table_200 ,

Line 2129: p_tax_exempt_reason_code IN jtf_varchar2_table_100 ,

2125: p_tax_date IN jtf_date_table ,
2126: p_tax_amount IN jtf_number_table ,
2127: p_tax_exempt_flag IN jtf_varchar2_table_100 ,
2128: p_tax_exempt_number IN jtf_varchar2_table_100 ,
2129: p_tax_exempt_reason_code IN jtf_varchar2_table_100 ,
2130: p_attribute_category IN jtf_varchar2_table_100 ,
2131: p_attribute1 IN jtf_varchar2_table_200 ,
2132: p_attribute2 IN jtf_varchar2_table_200 ,
2133: p_attribute3 IN jtf_varchar2_table_200 ,

Line 2130: p_attribute_category IN jtf_varchar2_table_100 ,

2126: p_tax_amount IN jtf_number_table ,
2127: p_tax_exempt_flag IN jtf_varchar2_table_100 ,
2128: p_tax_exempt_number IN jtf_varchar2_table_100 ,
2129: p_tax_exempt_reason_code IN jtf_varchar2_table_100 ,
2130: p_attribute_category IN jtf_varchar2_table_100 ,
2131: p_attribute1 IN jtf_varchar2_table_200 ,
2132: p_attribute2 IN jtf_varchar2_table_200 ,
2133: p_attribute3 IN jtf_varchar2_table_200 ,
2134: p_attribute4 IN jtf_varchar2_table_200 ,

Line 2778: p_line_category_code IN jtf_varchar2_table_100 ,

2774: p_quote_line_id IN jtf_number_table ,
2775: p_quote_header_id IN jtf_number_table ,
2776: p_org_id IN jtf_number_table ,
2777: p_line_number IN jtf_number_table ,
2778: p_line_category_code IN jtf_varchar2_table_100 ,
2779: p_item_type_code IN jtf_varchar2_table_100 ,
2780: p_inventory_item_id IN jtf_number_table ,
2781: p_organization_id IN jtf_number_table ,
2782: p_quantity IN jtf_number_table ,

Line 2779: p_item_type_code IN jtf_varchar2_table_100 ,

2775: p_quote_header_id IN jtf_number_table ,
2776: p_org_id IN jtf_number_table ,
2777: p_line_number IN jtf_number_table ,
2778: p_line_category_code IN jtf_varchar2_table_100 ,
2779: p_item_type_code IN jtf_varchar2_table_100 ,
2780: p_inventory_item_id IN jtf_number_table ,
2781: p_organization_id IN jtf_number_table ,
2782: p_quantity IN jtf_number_table ,
2783: p_uom_code IN jtf_varchar2_table_100 ,

Line 2783: p_uom_code IN jtf_varchar2_table_100 ,

2779: p_item_type_code IN jtf_varchar2_table_100 ,
2780: p_inventory_item_id IN jtf_number_table ,
2781: p_organization_id IN jtf_number_table ,
2782: p_quantity IN jtf_number_table ,
2783: p_uom_code IN jtf_varchar2_table_100 ,
2784: p_start_date_active IN jtf_date_table ,
2785: p_end_date_active IN jtf_date_table ,
2786: p_order_line_type_id IN jtf_number_table ,
2787: p_price_list_id IN jtf_number_table ,

Line 2789: p_currency_code IN jtf_varchar2_table_100 ,

2785: p_end_date_active IN jtf_date_table ,
2786: p_order_line_type_id IN jtf_number_table ,
2787: p_price_list_id IN jtf_number_table ,
2788: p_price_list_line_id IN jtf_number_table ,
2789: p_currency_code IN jtf_varchar2_table_100 ,
2790: p_line_list_price IN jtf_number_table ,
2791: p_line_adjusted_amount IN jtf_number_table ,
2792: p_line_adjusted_percent IN jtf_number_table ,
2793: p_line_quote_price IN jtf_number_table ,

Line 2795: p_item_relationship_type IN jtf_varchar2_table_100 ,

2791: p_line_adjusted_amount IN jtf_number_table ,
2792: p_line_adjusted_percent IN jtf_number_table ,
2793: p_line_quote_price IN jtf_number_table ,
2794: p_related_item_id IN jtf_number_table ,
2795: p_item_relationship_type IN jtf_varchar2_table_100 ,
2796: p_split_shipment_flag IN jtf_varchar2_table_100 ,
2797: p_backorder_flag IN jtf_varchar2_table_100 ,
2798: p_selling_price_change IN jtf_varchar2_table_100 ,
2799: p_recalculate_flag IN jtf_varchar2_table_100 ,

Line 2796: p_split_shipment_flag IN jtf_varchar2_table_100 ,

2792: p_line_adjusted_percent IN jtf_number_table ,
2793: p_line_quote_price IN jtf_number_table ,
2794: p_related_item_id IN jtf_number_table ,
2795: p_item_relationship_type IN jtf_varchar2_table_100 ,
2796: p_split_shipment_flag IN jtf_varchar2_table_100 ,
2797: p_backorder_flag IN jtf_varchar2_table_100 ,
2798: p_selling_price_change IN jtf_varchar2_table_100 ,
2799: p_recalculate_flag IN jtf_varchar2_table_100 ,
2800: p_attribute_category IN jtf_varchar2_table_100 ,

Line 2797: p_backorder_flag IN jtf_varchar2_table_100 ,

2793: p_line_quote_price IN jtf_number_table ,
2794: p_related_item_id IN jtf_number_table ,
2795: p_item_relationship_type IN jtf_varchar2_table_100 ,
2796: p_split_shipment_flag IN jtf_varchar2_table_100 ,
2797: p_backorder_flag IN jtf_varchar2_table_100 ,
2798: p_selling_price_change IN jtf_varchar2_table_100 ,
2799: p_recalculate_flag IN jtf_varchar2_table_100 ,
2800: p_attribute_category IN jtf_varchar2_table_100 ,
2801: p_attribute1 IN jtf_varchar2_table_300 ,

Line 2798: p_selling_price_change IN jtf_varchar2_table_100 ,

2794: p_related_item_id IN jtf_number_table ,
2795: p_item_relationship_type IN jtf_varchar2_table_100 ,
2796: p_split_shipment_flag IN jtf_varchar2_table_100 ,
2797: p_backorder_flag IN jtf_varchar2_table_100 ,
2798: p_selling_price_change IN jtf_varchar2_table_100 ,
2799: p_recalculate_flag IN jtf_varchar2_table_100 ,
2800: p_attribute_category IN jtf_varchar2_table_100 ,
2801: p_attribute1 IN jtf_varchar2_table_300 ,
2802: p_attribute2 IN jtf_varchar2_table_300 ,

Line 2799: p_recalculate_flag IN jtf_varchar2_table_100 ,

2795: p_item_relationship_type IN jtf_varchar2_table_100 ,
2796: p_split_shipment_flag IN jtf_varchar2_table_100 ,
2797: p_backorder_flag IN jtf_varchar2_table_100 ,
2798: p_selling_price_change IN jtf_varchar2_table_100 ,
2799: p_recalculate_flag IN jtf_varchar2_table_100 ,
2800: p_attribute_category IN jtf_varchar2_table_100 ,
2801: p_attribute1 IN jtf_varchar2_table_300 ,
2802: p_attribute2 IN jtf_varchar2_table_300 ,
2803: p_attribute3 IN jtf_varchar2_table_300 ,

Line 2800: p_attribute_category IN jtf_varchar2_table_100 ,

2796: p_split_shipment_flag IN jtf_varchar2_table_100 ,
2797: p_backorder_flag IN jtf_varchar2_table_100 ,
2798: p_selling_price_change IN jtf_varchar2_table_100 ,
2799: p_recalculate_flag IN jtf_varchar2_table_100 ,
2800: p_attribute_category IN jtf_varchar2_table_100 ,
2801: p_attribute1 IN jtf_varchar2_table_300 ,
2802: p_attribute2 IN jtf_varchar2_table_300 ,
2803: p_attribute3 IN jtf_varchar2_table_300 ,
2804: p_attribute4 IN jtf_varchar2_table_300 ,

Line 2832: p_operation_code IN jtf_varchar2_table_100 ,

2828: p_commitment_id IN jtf_number_table ,
2829: p_agreement_id IN jtf_number_table ,
2830: p_minisite_id IN jtf_number_table ,
2831: p_section_id IN jtf_number_table ,
2832: p_operation_code IN jtf_varchar2_table_100 ,
2833: p_end_customer_party_id IN jtf_number_table ,
2834: p_end_customer_cust_party_id IN jtf_number_table ,
2835: p_end_customer_party_site_id IN jtf_number_table ,
2836: p_end_customer_cust_account_id IN jtf_number_table

Line 3166: p_complete_configuration IN jtf_varchar2_table_100 ,

3162: p_quote_line_id IN jtf_number_table ,
3163: p_config_header_id IN jtf_number_table ,
3164: p_config_revision_num IN jtf_number_table ,
3165: p_config_item_id IN jtf_number_table ,
3166: p_complete_configuration IN jtf_varchar2_table_100 ,
3167: p_valid_configuration_flag IN jtf_varchar2_table_100 ,
3168: p_component_code IN jtf_varchar2_table_1000 ,
3169: p_service_coterminate_flag IN jtf_varchar2_table_100 ,
3170: p_service_duration IN jtf_number_table ,

Line 3167: p_valid_configuration_flag IN jtf_varchar2_table_100 ,

3163: p_config_header_id IN jtf_number_table ,
3164: p_config_revision_num IN jtf_number_table ,
3165: p_config_item_id IN jtf_number_table ,
3166: p_complete_configuration IN jtf_varchar2_table_100 ,
3167: p_valid_configuration_flag IN jtf_varchar2_table_100 ,
3168: p_component_code IN jtf_varchar2_table_1000 ,
3169: p_service_coterminate_flag IN jtf_varchar2_table_100 ,
3170: p_service_duration IN jtf_number_table ,
3171: p_service_period IN jtf_varchar2_table_100 ,

Line 3168: p_component_code IN jtf_varchar2_table_1000 ,

3164: p_config_revision_num IN jtf_number_table ,
3165: p_config_item_id IN jtf_number_table ,
3166: p_complete_configuration IN jtf_varchar2_table_100 ,
3167: p_valid_configuration_flag IN jtf_varchar2_table_100 ,
3168: p_component_code IN jtf_varchar2_table_1000 ,
3169: p_service_coterminate_flag IN jtf_varchar2_table_100 ,
3170: p_service_duration IN jtf_number_table ,
3171: p_service_period IN jtf_varchar2_table_100 ,
3172: p_service_unit_selling IN jtf_number_table ,

Line 3169: p_service_coterminate_flag IN jtf_varchar2_table_100 ,

3165: p_config_item_id IN jtf_number_table ,
3166: p_complete_configuration IN jtf_varchar2_table_100 ,
3167: p_valid_configuration_flag IN jtf_varchar2_table_100 ,
3168: p_component_code IN jtf_varchar2_table_1000 ,
3169: p_service_coterminate_flag IN jtf_varchar2_table_100 ,
3170: p_service_duration IN jtf_number_table ,
3171: p_service_period IN jtf_varchar2_table_100 ,
3172: p_service_unit_selling IN jtf_number_table ,
3173: p_service_unit_list IN jtf_number_table ,

Line 3171: p_service_period IN jtf_varchar2_table_100 ,

3167: p_valid_configuration_flag IN jtf_varchar2_table_100 ,
3168: p_component_code IN jtf_varchar2_table_1000 ,
3169: p_service_coterminate_flag IN jtf_varchar2_table_100 ,
3170: p_service_duration IN jtf_number_table ,
3171: p_service_period IN jtf_varchar2_table_100 ,
3172: p_service_unit_selling IN jtf_number_table ,
3173: p_service_unit_list IN jtf_number_table ,
3174: p_service_number IN jtf_number_table ,
3175: p_unit_percent_base_price IN jtf_number_table ,

Line 3176: p_attribute_category IN jtf_varchar2_table_100 ,

3172: p_service_unit_selling IN jtf_number_table ,
3173: p_service_unit_list IN jtf_number_table ,
3174: p_service_number IN jtf_number_table ,
3175: p_unit_percent_base_price IN jtf_number_table ,
3176: p_attribute_category IN jtf_varchar2_table_100 ,
3177: p_attribute1 IN jtf_varchar2_table_200 ,
3178: p_attribute2 IN jtf_varchar2_table_200 ,
3179: p_attribute3 IN jtf_varchar2_table_200 ,
3180: p_attribute4 IN jtf_varchar2_table_200 ,

Line 3192: p_service_ref_type_code IN jtf_varchar2_table_100 ,

3188: p_attribute12 IN jtf_varchar2_table_200 ,
3189: p_attribute13 IN jtf_varchar2_table_200 ,
3190: p_attribute14 IN jtf_varchar2_table_200 ,
3191: p_attribute15 IN jtf_varchar2_table_200 ,
3192: p_service_ref_type_code IN jtf_varchar2_table_100 ,
3193: p_service_ref_order_number IN jtf_number_table ,
3194: p_service_ref_line_number IN jtf_number_table ,
3195: p_service_ref_qte_line_ind IN jtf_number_table ,
3196: p_service_ref_line_id IN jtf_number_table ,

Line 3200: p_return_ref_type IN jtf_varchar2_table_100 ,

3196: p_service_ref_line_id IN jtf_number_table ,
3197: p_service_ref_system_id IN jtf_number_table ,
3198: p_service_ref_option_numb IN jtf_number_table ,
3199: p_service_ref_shipment IN jtf_number_table ,
3200: p_return_ref_type IN jtf_varchar2_table_100 ,
3201: p_return_ref_header_id IN jtf_number_table ,
3202: p_return_ref_line_id IN jtf_number_table ,
3203: p_return_attribute1 IN jtf_varchar2_table_300 ,
3204: p_return_attribute2 IN jtf_varchar2_table_300 ,

Line 3218: p_operation_code IN jtf_varchar2_table_100 ,

3214: p_return_attribute12 IN jtf_varchar2_table_300 ,
3215: p_return_attribute13 IN jtf_varchar2_table_300 ,
3216: p_return_attribute14 IN jtf_varchar2_table_300 ,
3217: p_return_attribute15 IN jtf_varchar2_table_300 ,
3218: p_operation_code IN jtf_varchar2_table_100 ,
3219: p_qte_line_index IN jtf_number_table ,
3220: p_return_attr_category IN jtf_varchar2_table_100 ,
3221: p_return_reason_code IN jtf_varchar2_table_100
3222: )

Line 3220: p_return_attr_category IN jtf_varchar2_table_100 ,

3216: p_return_attribute14 IN jtf_varchar2_table_300 ,
3217: p_return_attribute15 IN jtf_varchar2_table_300 ,
3218: p_operation_code IN jtf_varchar2_table_100 ,
3219: p_qte_line_index IN jtf_number_table ,
3220: p_return_attr_category IN jtf_varchar2_table_100 ,
3221: p_return_reason_code IN jtf_varchar2_table_100
3222: )
3223: RETURN ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type
3224: IS

Line 3221: p_return_reason_code IN jtf_varchar2_table_100

3217: p_return_attribute15 IN jtf_varchar2_table_300 ,
3218: p_operation_code IN jtf_varchar2_table_100 ,
3219: p_qte_line_index IN jtf_number_table ,
3220: p_return_attr_category IN jtf_varchar2_table_100 ,
3221: p_return_reason_code IN jtf_varchar2_table_100
3222: )
3223: RETURN ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type
3224: IS
3225: l_qte_line_dtl_tbl ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type;

Line 3441: p_relationship_type_code IN jtf_varchar2_table_100 ,

3437: p_program_id IN jtf_number_table ,
3438: p_program_update_date IN jtf_date_table ,
3439: p_quote_line_id IN jtf_number_table ,
3440: p_related_quote_line_id IN jtf_number_table ,
3441: p_relationship_type_code IN jtf_varchar2_table_100 ,
3442: p_reciprocal_flag IN jtf_varchar2_table_100 ,
3443: p_qte_line_index IN jtf_number_table ,
3444: p_related_qte_line_index IN jtf_number_table ,
3445: p_operation_code IN jtf_varchar2_table_100

Line 3442: p_reciprocal_flag IN jtf_varchar2_table_100 ,

3438: p_program_update_date IN jtf_date_table ,
3439: p_quote_line_id IN jtf_number_table ,
3440: p_related_quote_line_id IN jtf_number_table ,
3441: p_relationship_type_code IN jtf_varchar2_table_100 ,
3442: p_reciprocal_flag IN jtf_varchar2_table_100 ,
3443: p_qte_line_index IN jtf_number_table ,
3444: p_related_qte_line_index IN jtf_number_table ,
3445: p_operation_code IN jtf_varchar2_table_100
3446: )

Line 3445: p_operation_code IN jtf_varchar2_table_100

3441: p_relationship_type_code IN jtf_varchar2_table_100 ,
3442: p_reciprocal_flag IN jtf_varchar2_table_100 ,
3443: p_qte_line_index IN jtf_number_table ,
3444: p_related_qte_line_index IN jtf_number_table ,
3445: p_operation_code IN jtf_varchar2_table_100
3446: )
3447: RETURN ASO_Quote_Pub.Line_Rltship_Tbl_Type
3448: IS
3449: l_line_rltship_tbl ASO_Quote_Pub.Line_Rltship_Tbl_Type;

Line 3686: p_ql_line_category_code IN jtf_varchar2_table_100 := NULL,

3682: p_ql_quote_line_id IN jtf_number_table := NULL,
3683: p_ql_quote_header_id IN jtf_number_table := NULL,
3684: p_ql_org_id IN jtf_number_table := NULL,
3685: p_ql_line_number IN jtf_number_table := NULL,
3686: p_ql_line_category_code IN jtf_varchar2_table_100 := NULL,
3687: p_ql_item_type_code IN jtf_varchar2_table_100 := NULL,
3688: p_ql_inventory_item_id IN jtf_number_table := NULL,
3689: p_ql_organization_id IN jtf_number_table := NULL,
3690: p_ql_quantity IN jtf_number_table := NULL,

Line 3687: p_ql_item_type_code IN jtf_varchar2_table_100 := NULL,

3683: p_ql_quote_header_id IN jtf_number_table := NULL,
3684: p_ql_org_id IN jtf_number_table := NULL,
3685: p_ql_line_number IN jtf_number_table := NULL,
3686: p_ql_line_category_code IN jtf_varchar2_table_100 := NULL,
3687: p_ql_item_type_code IN jtf_varchar2_table_100 := NULL,
3688: p_ql_inventory_item_id IN jtf_number_table := NULL,
3689: p_ql_organization_id IN jtf_number_table := NULL,
3690: p_ql_quantity IN jtf_number_table := NULL,
3691: p_ql_uom_code IN jtf_varchar2_table_100 := NULL,

Line 3691: p_ql_uom_code IN jtf_varchar2_table_100 := NULL,

3687: p_ql_item_type_code IN jtf_varchar2_table_100 := NULL,
3688: p_ql_inventory_item_id IN jtf_number_table := NULL,
3689: p_ql_organization_id IN jtf_number_table := NULL,
3690: p_ql_quantity IN jtf_number_table := NULL,
3691: p_ql_uom_code IN jtf_varchar2_table_100 := NULL,
3692: p_ql_start_date_active IN jtf_date_table := NULL,
3693: p_ql_end_date_active IN jtf_date_table := NULL,
3694: p_ql_order_line_type_id IN jtf_number_table := NULL,
3695: p_ql_price_list_id IN jtf_number_table := NULL,

Line 3697: p_ql_currency_code IN jtf_varchar2_table_100 := NULL,

3693: p_ql_end_date_active IN jtf_date_table := NULL,
3694: p_ql_order_line_type_id IN jtf_number_table := NULL,
3695: p_ql_price_list_id IN jtf_number_table := NULL,
3696: p_ql_price_list_line_id IN jtf_number_table := NULL,
3697: p_ql_currency_code IN jtf_varchar2_table_100 := NULL,
3698: p_ql_line_list_price IN jtf_number_table := NULL,
3699: p_ql_line_adjusted_amount IN jtf_number_table := NULL,
3700: p_ql_line_adjusted_percent IN jtf_number_table := NULL,
3701: p_ql_line_quote_price IN jtf_number_table := NULL,

Line 3703: p_ql_item_relationship_type IN jtf_varchar2_table_100 := NULL,

3699: p_ql_line_adjusted_amount IN jtf_number_table := NULL,
3700: p_ql_line_adjusted_percent IN jtf_number_table := NULL,
3701: p_ql_line_quote_price IN jtf_number_table := NULL,
3702: p_ql_related_item_id IN jtf_number_table := NULL,
3703: p_ql_item_relationship_type IN jtf_varchar2_table_100 := NULL,
3704: p_ql_split_shipment_flag IN jtf_varchar2_table_100 := NULL,
3705: p_ql_backorder_flag IN jtf_varchar2_table_100 := NULL,
3706: p_ql_selling_price_change IN jtf_varchar2_table_100 := NULL,
3707: p_ql_recalculate_flag IN jtf_varchar2_table_100 := NULL,

Line 3704: p_ql_split_shipment_flag IN jtf_varchar2_table_100 := NULL,

3700: p_ql_line_adjusted_percent IN jtf_number_table := NULL,
3701: p_ql_line_quote_price IN jtf_number_table := NULL,
3702: p_ql_related_item_id IN jtf_number_table := NULL,
3703: p_ql_item_relationship_type IN jtf_varchar2_table_100 := NULL,
3704: p_ql_split_shipment_flag IN jtf_varchar2_table_100 := NULL,
3705: p_ql_backorder_flag IN jtf_varchar2_table_100 := NULL,
3706: p_ql_selling_price_change IN jtf_varchar2_table_100 := NULL,
3707: p_ql_recalculate_flag IN jtf_varchar2_table_100 := NULL,
3708: p_ql_attribute_category IN jtf_varchar2_table_100 := NULL,

Line 3705: p_ql_backorder_flag IN jtf_varchar2_table_100 := NULL,

3701: p_ql_line_quote_price IN jtf_number_table := NULL,
3702: p_ql_related_item_id IN jtf_number_table := NULL,
3703: p_ql_item_relationship_type IN jtf_varchar2_table_100 := NULL,
3704: p_ql_split_shipment_flag IN jtf_varchar2_table_100 := NULL,
3705: p_ql_backorder_flag IN jtf_varchar2_table_100 := NULL,
3706: p_ql_selling_price_change IN jtf_varchar2_table_100 := NULL,
3707: p_ql_recalculate_flag IN jtf_varchar2_table_100 := NULL,
3708: p_ql_attribute_category IN jtf_varchar2_table_100 := NULL,
3709: p_ql_attribute1 IN jtf_varchar2_table_300 := NULL,

Line 3706: p_ql_selling_price_change IN jtf_varchar2_table_100 := NULL,

3702: p_ql_related_item_id IN jtf_number_table := NULL,
3703: p_ql_item_relationship_type IN jtf_varchar2_table_100 := NULL,
3704: p_ql_split_shipment_flag IN jtf_varchar2_table_100 := NULL,
3705: p_ql_backorder_flag IN jtf_varchar2_table_100 := NULL,
3706: p_ql_selling_price_change IN jtf_varchar2_table_100 := NULL,
3707: p_ql_recalculate_flag IN jtf_varchar2_table_100 := NULL,
3708: p_ql_attribute_category IN jtf_varchar2_table_100 := NULL,
3709: p_ql_attribute1 IN jtf_varchar2_table_300 := NULL,
3710: p_ql_attribute2 IN jtf_varchar2_table_300 := NULL,

Line 3707: p_ql_recalculate_flag IN jtf_varchar2_table_100 := NULL,

3703: p_ql_item_relationship_type IN jtf_varchar2_table_100 := NULL,
3704: p_ql_split_shipment_flag IN jtf_varchar2_table_100 := NULL,
3705: p_ql_backorder_flag IN jtf_varchar2_table_100 := NULL,
3706: p_ql_selling_price_change IN jtf_varchar2_table_100 := NULL,
3707: p_ql_recalculate_flag IN jtf_varchar2_table_100 := NULL,
3708: p_ql_attribute_category IN jtf_varchar2_table_100 := NULL,
3709: p_ql_attribute1 IN jtf_varchar2_table_300 := NULL,
3710: p_ql_attribute2 IN jtf_varchar2_table_300 := NULL,
3711: p_ql_attribute3 IN jtf_varchar2_table_300 := NULL,

Line 3708: p_ql_attribute_category IN jtf_varchar2_table_100 := NULL,

3704: p_ql_split_shipment_flag IN jtf_varchar2_table_100 := NULL,
3705: p_ql_backorder_flag IN jtf_varchar2_table_100 := NULL,
3706: p_ql_selling_price_change IN jtf_varchar2_table_100 := NULL,
3707: p_ql_recalculate_flag IN jtf_varchar2_table_100 := NULL,
3708: p_ql_attribute_category IN jtf_varchar2_table_100 := NULL,
3709: p_ql_attribute1 IN jtf_varchar2_table_300 := NULL,
3710: p_ql_attribute2 IN jtf_varchar2_table_300 := NULL,
3711: p_ql_attribute3 IN jtf_varchar2_table_300 := NULL,
3712: p_ql_attribute4 IN jtf_varchar2_table_300 := NULL,

Line 3736: p_ql_operation_code IN jtf_varchar2_table_100 := NULL,

3732: p_ql_invoice_to_party_site_id IN jtf_number_table := NULL,
3733: p_ql_invoice_to_cust_acct_id IN jtf_number_table := NULL,
3734: p_ql_invoicing_rule_id IN jtf_number_table := NULL,
3735: p_ql_marketing_source_code_id IN jtf_number_table := NULL,
3736: p_ql_operation_code IN jtf_varchar2_table_100 := NULL,
3737: p_ql_commitment_id IN jtf_number_table := NULL,
3738: p_ql_agreement_id IN jtf_number_table := NULL,
3739: p_ql_minisite_id IN jtf_number_table := NULL,
3740: p_ql_section_id IN jtf_number_table := NULL,

Line 3758: p_qrl_relationship_type_code IN jtf_varchar2_table_100 := NULL,

3754: p_qrl_program_id IN jtf_number_table := NULL,
3755: p_qrl_program_update_date IN jtf_date_table := NULL,
3756: p_qrl_quote_line_id IN jtf_number_table := NULL,
3757: p_qrl_related_quote_line_id IN jtf_number_table := NULL,
3758: p_qrl_relationship_type_code IN jtf_varchar2_table_100 := NULL,
3759: p_qrl_reciprocal_flag IN jtf_varchar2_table_100 := NULL,
3760: p_qrl_qte_line_index IN jtf_number_table := NULL,
3761: p_qrl_related_qte_line_index IN jtf_number_table := NULL,
3762: p_qrl_operation_code IN JTF_VARCHAR2_TABLE_100 := null,

Line 3759: p_qrl_reciprocal_flag IN jtf_varchar2_table_100 := NULL,

3755: p_qrl_program_update_date IN jtf_date_table := NULL,
3756: p_qrl_quote_line_id IN jtf_number_table := NULL,
3757: p_qrl_related_quote_line_id IN jtf_number_table := NULL,
3758: p_qrl_relationship_type_code IN jtf_varchar2_table_100 := NULL,
3759: p_qrl_reciprocal_flag IN jtf_varchar2_table_100 := NULL,
3760: p_qrl_qte_line_index IN jtf_number_table := NULL,
3761: p_qrl_related_qte_line_index IN jtf_number_table := NULL,
3762: p_qrl_operation_code IN JTF_VARCHAR2_TABLE_100 := null,
3763: p_qdl_quote_line_detail_id IN jtf_number_table := NULL,

Line 3762: p_qrl_operation_code IN JTF_VARCHAR2_TABLE_100 := null,

3758: p_qrl_relationship_type_code IN jtf_varchar2_table_100 := NULL,
3759: p_qrl_reciprocal_flag IN jtf_varchar2_table_100 := NULL,
3760: p_qrl_qte_line_index IN jtf_number_table := NULL,
3761: p_qrl_related_qte_line_index IN jtf_number_table := NULL,
3762: p_qrl_operation_code IN JTF_VARCHAR2_TABLE_100 := null,
3763: p_qdl_quote_line_detail_id IN jtf_number_table := NULL,
3764: p_qdl_creation_date IN jtf_date_table := NULL,
3765: p_qdl_created_by IN jtf_number_table := NULL,
3766: p_qdl_last_update_date IN jtf_date_table := NULL,

Line 3777: p_qdl_complete_configuration IN jtf_varchar2_table_100 := NULL,

3773: p_qdl_quote_line_id IN jtf_number_table := NULL,
3774: p_qdl_config_header_id IN jtf_number_table := NULL,
3775: p_qdl_config_revision_num IN jtf_number_table := NULL,
3776: p_qdl_config_item_id IN jtf_number_table := NULL,
3777: p_qdl_complete_configuration IN jtf_varchar2_table_100 := NULL,
3778: p_qdl_valid_configuration_flag IN jtf_varchar2_table_100 := NULL,
3779: p_qdl_component_code IN jtf_varchar2_table_1000 := NULL,
3780: p_qdl_service_coterminate_flag IN jtf_varchar2_table_100 := NULL,
3781: p_qdl_service_duration IN jtf_number_table := NULL,

Line 3778: p_qdl_valid_configuration_flag IN jtf_varchar2_table_100 := NULL,

3774: p_qdl_config_header_id IN jtf_number_table := NULL,
3775: p_qdl_config_revision_num IN jtf_number_table := NULL,
3776: p_qdl_config_item_id IN jtf_number_table := NULL,
3777: p_qdl_complete_configuration IN jtf_varchar2_table_100 := NULL,
3778: p_qdl_valid_configuration_flag IN jtf_varchar2_table_100 := NULL,
3779: p_qdl_component_code IN jtf_varchar2_table_1000 := NULL,
3780: p_qdl_service_coterminate_flag IN jtf_varchar2_table_100 := NULL,
3781: p_qdl_service_duration IN jtf_number_table := NULL,
3782: p_qdl_service_period IN jtf_varchar2_table_100 := NULL,

Line 3779: p_qdl_component_code IN jtf_varchar2_table_1000 := NULL,

3775: p_qdl_config_revision_num IN jtf_number_table := NULL,
3776: p_qdl_config_item_id IN jtf_number_table := NULL,
3777: p_qdl_complete_configuration IN jtf_varchar2_table_100 := NULL,
3778: p_qdl_valid_configuration_flag IN jtf_varchar2_table_100 := NULL,
3779: p_qdl_component_code IN jtf_varchar2_table_1000 := NULL,
3780: p_qdl_service_coterminate_flag IN jtf_varchar2_table_100 := NULL,
3781: p_qdl_service_duration IN jtf_number_table := NULL,
3782: p_qdl_service_period IN jtf_varchar2_table_100 := NULL,
3783: p_qdl_service_unit_selling IN jtf_number_table := NULL,

Line 3780: p_qdl_service_coterminate_flag IN jtf_varchar2_table_100 := NULL,

3776: p_qdl_config_item_id IN jtf_number_table := NULL,
3777: p_qdl_complete_configuration IN jtf_varchar2_table_100 := NULL,
3778: p_qdl_valid_configuration_flag IN jtf_varchar2_table_100 := NULL,
3779: p_qdl_component_code IN jtf_varchar2_table_1000 := NULL,
3780: p_qdl_service_coterminate_flag IN jtf_varchar2_table_100 := NULL,
3781: p_qdl_service_duration IN jtf_number_table := NULL,
3782: p_qdl_service_period IN jtf_varchar2_table_100 := NULL,
3783: p_qdl_service_unit_selling IN jtf_number_table := NULL,
3784: p_qdl_service_unit_list IN jtf_number_table := NULL,

Line 3782: p_qdl_service_period IN jtf_varchar2_table_100 := NULL,

3778: p_qdl_valid_configuration_flag IN jtf_varchar2_table_100 := NULL,
3779: p_qdl_component_code IN jtf_varchar2_table_1000 := NULL,
3780: p_qdl_service_coterminate_flag IN jtf_varchar2_table_100 := NULL,
3781: p_qdl_service_duration IN jtf_number_table := NULL,
3782: p_qdl_service_period IN jtf_varchar2_table_100 := NULL,
3783: p_qdl_service_unit_selling IN jtf_number_table := NULL,
3784: p_qdl_service_unit_list IN jtf_number_table := NULL,
3785: p_qdl_service_number IN jtf_number_table := NULL,
3786: p_qdl_unit_percent_base_price IN jtf_number_table := NULL,

Line 3787: p_qdl_attribute_category IN jtf_varchar2_table_100 := NULL,

3783: p_qdl_service_unit_selling IN jtf_number_table := NULL,
3784: p_qdl_service_unit_list IN jtf_number_table := NULL,
3785: p_qdl_service_number IN jtf_number_table := NULL,
3786: p_qdl_unit_percent_base_price IN jtf_number_table := NULL,
3787: p_qdl_attribute_category IN jtf_varchar2_table_100 := NULL,
3788: p_qdl_attribute1 IN jtf_varchar2_table_200 := NULL,
3789: p_qdl_attribute2 IN jtf_varchar2_table_200 := NULL,
3790: p_qdl_attribute3 IN jtf_varchar2_table_200 := NULL,
3791: p_qdl_attribute4 IN jtf_varchar2_table_200 := NULL,

Line 3803: p_qdl_service_ref_type_code IN jtf_varchar2_table_100 := NULL,

3799: p_qdl_attribute12 IN jtf_varchar2_table_200 := NULL,
3800: p_qdl_attribute13 IN jtf_varchar2_table_200 := NULL,
3801: p_qdl_attribute14 IN jtf_varchar2_table_200 := NULL,
3802: p_qdl_attribute15 IN jtf_varchar2_table_200 := NULL,
3803: p_qdl_service_ref_type_code IN jtf_varchar2_table_100 := NULL,
3804: p_qdl_service_ref_order_number IN jtf_number_table := NULL,
3805: p_qdl_service_ref_line_number IN jtf_number_table := NULL,
3806: p_qdl_service_ref_qte_line_ind IN jtf_number_table := NULL,
3807: p_qdl_service_ref_line_id IN jtf_number_table := NULL,

Line 3811: p_qdl_return_ref_type IN jtf_varchar2_table_100 := NULL,

3807: p_qdl_service_ref_line_id IN jtf_number_table := NULL,
3808: p_qdl_service_ref_system_id IN jtf_number_table := NULL,
3809: p_qdl_service_ref_option_numb IN jtf_number_table := NULL,
3810: p_qdl_service_ref_shipment IN jtf_number_table := NULL,
3811: p_qdl_return_ref_type IN jtf_varchar2_table_100 := NULL,
3812: p_qdl_return_ref_header_id IN jtf_number_table := NULL,
3813: p_qdl_return_ref_line_id IN jtf_number_table := NULL,
3814: p_qdl_return_attribute1 IN jtf_varchar2_table_300 := NULL,
3815: p_qdl_return_attribute2 IN jtf_varchar2_table_300 := NULL,

Line 3829: p_qdl_operation_code IN jtf_varchar2_table_100 := NULL,

3825: p_qdl_return_attribute12 IN jtf_varchar2_table_300 := NULL,
3826: p_qdl_return_attribute13 IN jtf_varchar2_table_300 := NULL,
3827: p_qdl_return_attribute14 IN jtf_varchar2_table_300 := NULL,
3828: p_qdl_return_attribute15 IN jtf_varchar2_table_300 := NULL,
3829: p_qdl_operation_code IN jtf_varchar2_table_100 := NULL,
3830: p_qdl_qte_line_index IN jtf_number_table := NULL,
3831: p_qdl_return_attr_category IN jtf_varchar2_table_100 := NULL,
3832: p_qdl_return_reason_code IN jtf_varchar2_table_100 := NULL,
3833: p_qpa_operation_code IN jtf_varchar2_table_100 := NULL,

Line 3831: p_qdl_return_attr_category IN jtf_varchar2_table_100 := NULL,

3827: p_qdl_return_attribute14 IN jtf_varchar2_table_300 := NULL,
3828: p_qdl_return_attribute15 IN jtf_varchar2_table_300 := NULL,
3829: p_qdl_operation_code IN jtf_varchar2_table_100 := NULL,
3830: p_qdl_qte_line_index IN jtf_number_table := NULL,
3831: p_qdl_return_attr_category IN jtf_varchar2_table_100 := NULL,
3832: p_qdl_return_reason_code IN jtf_varchar2_table_100 := NULL,
3833: p_qpa_operation_code IN jtf_varchar2_table_100 := NULL,
3834: p_qpa_qte_line_index IN jtf_number_table := NULL,
3835: p_qpa_price_attribute_id IN jtf_number_table := NULL,

Line 3832: p_qdl_return_reason_code IN jtf_varchar2_table_100 := NULL,

3828: p_qdl_return_attribute15 IN jtf_varchar2_table_300 := NULL,
3829: p_qdl_operation_code IN jtf_varchar2_table_100 := NULL,
3830: p_qdl_qte_line_index IN jtf_number_table := NULL,
3831: p_qdl_return_attr_category IN jtf_varchar2_table_100 := NULL,
3832: p_qdl_return_reason_code IN jtf_varchar2_table_100 := NULL,
3833: p_qpa_operation_code IN jtf_varchar2_table_100 := NULL,
3834: p_qpa_qte_line_index IN jtf_number_table := NULL,
3835: p_qpa_price_attribute_id IN jtf_number_table := NULL,
3836: p_qpa_creation_date IN jtf_date_table := NULL,

Line 3833: p_qpa_operation_code IN jtf_varchar2_table_100 := NULL,

3829: p_qdl_operation_code IN jtf_varchar2_table_100 := NULL,
3830: p_qdl_qte_line_index IN jtf_number_table := NULL,
3831: p_qdl_return_attr_category IN jtf_varchar2_table_100 := NULL,
3832: p_qdl_return_reason_code IN jtf_varchar2_table_100 := NULL,
3833: p_qpa_operation_code IN jtf_varchar2_table_100 := NULL,
3834: p_qpa_qte_line_index IN jtf_number_table := NULL,
3835: p_qpa_price_attribute_id IN jtf_number_table := NULL,
3836: p_qpa_creation_date IN jtf_date_table := NULL,
3837: p_qpa_created_by IN jtf_number_table := NULL,

Line 3847: p_qpa_flex_title IN jtf_varchar2_table_100 := NULL,

3843: p_qpa_program_id IN jtf_number_table := NULL,
3844: p_qpa_program_update_date IN jtf_date_table := NULL,
3845: p_qpa_quote_header_id IN jtf_number_table := NULL,
3846: p_qpa_quote_line_id IN jtf_number_table := NULL,
3847: p_qpa_flex_title IN jtf_varchar2_table_100 := NULL,
3848: p_qpa_pricing_context IN jtf_varchar2_table_100 := NULL,
3849: p_qpa_pricing_attribute1 IN jtf_varchar2_table_300 := NULL,
3850: p_qpa_pricing_attribute2 IN jtf_varchar2_table_300 := NULL,
3851: p_qpa_pricing_attribute3 IN jtf_varchar2_table_300 := NULL,

Line 3848: p_qpa_pricing_context IN jtf_varchar2_table_100 := NULL,

3844: p_qpa_program_update_date IN jtf_date_table := NULL,
3845: p_qpa_quote_header_id IN jtf_number_table := NULL,
3846: p_qpa_quote_line_id IN jtf_number_table := NULL,
3847: p_qpa_flex_title IN jtf_varchar2_table_100 := NULL,
3848: p_qpa_pricing_context IN jtf_varchar2_table_100 := NULL,
3849: p_qpa_pricing_attribute1 IN jtf_varchar2_table_300 := NULL,
3850: p_qpa_pricing_attribute2 IN jtf_varchar2_table_300 := NULL,
3851: p_qpa_pricing_attribute3 IN jtf_varchar2_table_300 := NULL,
3852: p_qpa_pricing_attribute4 IN jtf_varchar2_table_300 := NULL,

Line 3949: p_qpa_context IN jtf_varchar2_table_100 := NULL,

3945: p_qpa_pricing_attribute97 IN jtf_varchar2_table_300 := NULL,
3946: p_qpa_pricing_attribute98 IN jtf_varchar2_table_300 := NULL,
3947: p_qpa_pricing_attribute99 IN jtf_varchar2_table_300 := NULL,
3948: p_qpa_pricing_attribute100 IN jtf_varchar2_table_300 := NULL,
3949: p_qpa_context IN jtf_varchar2_table_100 := NULL,
3950: p_qpa_attribute1 IN jtf_varchar2_table_300 := NULL,
3951: p_qpa_attribute2 IN jtf_varchar2_table_300 := NULL,
3952: p_qpa_attribute3 IN jtf_varchar2_table_300 := NULL,
3953: p_qpa_attribute4 IN jtf_varchar2_table_300 := NULL,

Line 3965: p_qp_operation_code IN jtf_varchar2_table_100 := NULL,

3961: p_qpa_attribute12 IN jtf_varchar2_table_300 := NULL,
3962: p_qpa_attribute13 IN jtf_varchar2_table_300 := NULL,
3963: p_qpa_attribute14 IN jtf_varchar2_table_300 := NULL,
3964: p_qpa_attribute15 IN jtf_varchar2_table_300 := NULL,
3965: p_qp_operation_code IN jtf_varchar2_table_100 := NULL,
3966: p_qp_qte_line_index IN jtf_number_table := NULL,
3967: p_qp_payment_id IN jtf_number_table := NULL,
3968: p_qp_creation_date IN jtf_date_table := NULL,
3969: p_qp_created_by IN jtf_number_table := NULL,

Line 3979: p_qp_payment_type_code IN jtf_varchar2_table_100 := NULL,

3975: p_qp_program_id IN jtf_number_table := NULL,
3976: p_qp_program_update_date IN jtf_date_table := NULL,
3977: p_qp_quote_header_id IN jtf_number_table := NULL,
3978: p_qp_quote_line_id IN jtf_number_table := NULL,
3979: p_qp_payment_type_code IN jtf_varchar2_table_100 := NULL,
3980: p_qp_payment_ref_number IN jtf_varchar2_table_300 := NULL,
3981: p_qp_payment_option IN jtf_varchar2_table_300 := NULL,
3982: p_qp_payment_term_id IN jtf_number_table := NULL,
3983: p_qp_credit_card_code IN jtf_varchar2_table_100 := NULL,

Line 3983: p_qp_credit_card_code IN jtf_varchar2_table_100 := NULL,

3979: p_qp_payment_type_code IN jtf_varchar2_table_100 := NULL,
3980: p_qp_payment_ref_number IN jtf_varchar2_table_300 := NULL,
3981: p_qp_payment_option IN jtf_varchar2_table_300 := NULL,
3982: p_qp_payment_term_id IN jtf_number_table := NULL,
3983: p_qp_credit_card_code IN jtf_varchar2_table_100 := NULL,
3984: p_qp_credit_card_holder_name IN jtf_varchar2_table_100 := NULL,
3985: p_qp_credit_card_exp_date IN jtf_date_table := NULL,
3986: p_qp_credit_card_approval_code IN jtf_varchar2_table_100 := NULL,
3987: p_qp_credit_card_approval_date IN jtf_date_table := NULL,

Line 3984: p_qp_credit_card_holder_name IN jtf_varchar2_table_100 := NULL,

3980: p_qp_payment_ref_number IN jtf_varchar2_table_300 := NULL,
3981: p_qp_payment_option IN jtf_varchar2_table_300 := NULL,
3982: p_qp_payment_term_id IN jtf_number_table := NULL,
3983: p_qp_credit_card_code IN jtf_varchar2_table_100 := NULL,
3984: p_qp_credit_card_holder_name IN jtf_varchar2_table_100 := NULL,
3985: p_qp_credit_card_exp_date IN jtf_date_table := NULL,
3986: p_qp_credit_card_approval_code IN jtf_varchar2_table_100 := NULL,
3987: p_qp_credit_card_approval_date IN jtf_date_table := NULL,
3988: p_qp_payment_amount IN jtf_number_table := NULL,

Line 3986: p_qp_credit_card_approval_code IN jtf_varchar2_table_100 := NULL,

3982: p_qp_payment_term_id IN jtf_number_table := NULL,
3983: p_qp_credit_card_code IN jtf_varchar2_table_100 := NULL,
3984: p_qp_credit_card_holder_name IN jtf_varchar2_table_100 := NULL,
3985: p_qp_credit_card_exp_date IN jtf_date_table := NULL,
3986: p_qp_credit_card_approval_code IN jtf_varchar2_table_100 := NULL,
3987: p_qp_credit_card_approval_date IN jtf_date_table := NULL,
3988: p_qp_payment_amount IN jtf_number_table := NULL,
3989: p_qp_cust_po_number IN jtf_varchar2_table_100 := NULL,
3990: p_qp_attribute_category IN jtf_varchar2_table_100 := NULL,

Line 3989: p_qp_cust_po_number IN jtf_varchar2_table_100 := NULL,

3985: p_qp_credit_card_exp_date IN jtf_date_table := NULL,
3986: p_qp_credit_card_approval_code IN jtf_varchar2_table_100 := NULL,
3987: p_qp_credit_card_approval_date IN jtf_date_table := NULL,
3988: p_qp_payment_amount IN jtf_number_table := NULL,
3989: p_qp_cust_po_number IN jtf_varchar2_table_100 := NULL,
3990: p_qp_attribute_category IN jtf_varchar2_table_100 := NULL,
3991: p_qp_attribute1 IN jtf_varchar2_table_200 := NULL,
3992: p_qp_attribute2 IN jtf_varchar2_table_200 := NULL,
3993: p_qp_attribute3 IN jtf_varchar2_table_200 := NULL,

Line 3990: p_qp_attribute_category IN jtf_varchar2_table_100 := NULL,

3986: p_qp_credit_card_approval_code IN jtf_varchar2_table_100 := NULL,
3987: p_qp_credit_card_approval_date IN jtf_date_table := NULL,
3988: p_qp_payment_amount IN jtf_number_table := NULL,
3989: p_qp_cust_po_number IN jtf_varchar2_table_100 := NULL,
3990: p_qp_attribute_category IN jtf_varchar2_table_100 := NULL,
3991: p_qp_attribute1 IN jtf_varchar2_table_200 := NULL,
3992: p_qp_attribute2 IN jtf_varchar2_table_200 := NULL,
3993: p_qp_attribute3 IN jtf_varchar2_table_200 := NULL,
3994: p_qp_attribute4 IN jtf_varchar2_table_200 := NULL,

Line 4008: p_qs_operation_code IN jtf_varchar2_table_100 := NULL,

4004: p_qp_attribute14 IN jtf_varchar2_table_200 := NULL,
4005: p_qp_attribute15 IN jtf_varchar2_table_200 := NULL,
4006: p_qp_assignment_id IN jtf_number_table := NULL,
4007: p_qp_cvv2 IN jtf_varchar2_table_200 := NULL,
4008: p_qs_operation_code IN jtf_varchar2_table_100 := NULL,
4009: p_qs_qte_line_index IN jtf_number_table := NULL,
4010: p_qs_shipment_id IN jtf_number_table := NULL,
4011: p_qs_creation_date IN jtf_date_table := NULL,
4012: p_qs_created_by IN jtf_number_table := NULL,

Line 4030: p_qs_ship_method_code IN jtf_varchar2_table_100 := NULL,

4026: p_qs_ship_to_party_id IN jtf_number_table := NULL,
4027: p_qs_ship_to_cust_acct_id IN jtf_number_table := NULL,
4028: p_qs_ship_partial_flag IN jtf_varchar2_table_300 := NULL,
4029: p_qs_ship_set_id IN jtf_number_table := NULL,
4030: p_qs_ship_method_code IN jtf_varchar2_table_100 := NULL,
4031: p_qs_freight_terms_code IN jtf_varchar2_table_100 := NULL,
4032: p_qs_freight_carrier_code IN jtf_varchar2_table_100 := NULL,
4033: p_qs_fob_code IN jtf_varchar2_table_100 := NULL,
4034: p_qs_shipment_priority_code IN jtf_varchar2_table_100 := NULL,

Line 4031: p_qs_freight_terms_code IN jtf_varchar2_table_100 := NULL,

4027: p_qs_ship_to_cust_acct_id IN jtf_number_table := NULL,
4028: p_qs_ship_partial_flag IN jtf_varchar2_table_300 := NULL,
4029: p_qs_ship_set_id IN jtf_number_table := NULL,
4030: p_qs_ship_method_code IN jtf_varchar2_table_100 := NULL,
4031: p_qs_freight_terms_code IN jtf_varchar2_table_100 := NULL,
4032: p_qs_freight_carrier_code IN jtf_varchar2_table_100 := NULL,
4033: p_qs_fob_code IN jtf_varchar2_table_100 := NULL,
4034: p_qs_shipment_priority_code IN jtf_varchar2_table_100 := NULL,
4035: p_qs_shipping_instructions IN jtf_varchar2_table_2000 := NULL,

Line 4032: p_qs_freight_carrier_code IN jtf_varchar2_table_100 := NULL,

4028: p_qs_ship_partial_flag IN jtf_varchar2_table_300 := NULL,
4029: p_qs_ship_set_id IN jtf_number_table := NULL,
4030: p_qs_ship_method_code IN jtf_varchar2_table_100 := NULL,
4031: p_qs_freight_terms_code IN jtf_varchar2_table_100 := NULL,
4032: p_qs_freight_carrier_code IN jtf_varchar2_table_100 := NULL,
4033: p_qs_fob_code IN jtf_varchar2_table_100 := NULL,
4034: p_qs_shipment_priority_code IN jtf_varchar2_table_100 := NULL,
4035: p_qs_shipping_instructions IN jtf_varchar2_table_2000 := NULL,
4036: p_qs_packing_instructions IN jtf_varchar2_table_2000 := NULL,

Line 4033: p_qs_fob_code IN jtf_varchar2_table_100 := NULL,

4029: p_qs_ship_set_id IN jtf_number_table := NULL,
4030: p_qs_ship_method_code IN jtf_varchar2_table_100 := NULL,
4031: p_qs_freight_terms_code IN jtf_varchar2_table_100 := NULL,
4032: p_qs_freight_carrier_code IN jtf_varchar2_table_100 := NULL,
4033: p_qs_fob_code IN jtf_varchar2_table_100 := NULL,
4034: p_qs_shipment_priority_code IN jtf_varchar2_table_100 := NULL,
4035: p_qs_shipping_instructions IN jtf_varchar2_table_2000 := NULL,
4036: p_qs_packing_instructions IN jtf_varchar2_table_2000 := NULL,
4037: p_qs_quantity IN jtf_number_table := NULL,

Line 4034: p_qs_shipment_priority_code IN jtf_varchar2_table_100 := NULL,

4030: p_qs_ship_method_code IN jtf_varchar2_table_100 := NULL,
4031: p_qs_freight_terms_code IN jtf_varchar2_table_100 := NULL,
4032: p_qs_freight_carrier_code IN jtf_varchar2_table_100 := NULL,
4033: p_qs_fob_code IN jtf_varchar2_table_100 := NULL,
4034: p_qs_shipment_priority_code IN jtf_varchar2_table_100 := NULL,
4035: p_qs_shipping_instructions IN jtf_varchar2_table_2000 := NULL,
4036: p_qs_packing_instructions IN jtf_varchar2_table_2000 := NULL,
4037: p_qs_quantity IN jtf_number_table := NULL,
4038: p_qs_reserved_quantity IN jtf_number_table := NULL,

Line 4042: p_qs_ship_to_cont_fst_name IN jtf_varchar2_table_100 := NULL,

4038: p_qs_reserved_quantity IN jtf_number_table := NULL,
4039: p_qs_reservation_id IN jtf_number_table := NULL,
4040: p_qs_order_line_id IN jtf_number_table := NULL,
4041: p_qs_ship_to_party_name IN jtf_varchar2_table_300 := NULL,
4042: p_qs_ship_to_cont_fst_name IN jtf_varchar2_table_100 := NULL,
4043: p_qs_ship_to_cont_mid_name IN jtf_varchar2_table_100 := NULL,
4044: p_qs_ship_to_cont_lst_name IN jtf_varchar2_table_100 := NULL,
4045: p_qs_ship_to_address1 IN jtf_varchar2_table_300 := NULL,
4046: p_qs_ship_to_address2 IN jtf_varchar2_table_300 := NULL,

Line 4043: p_qs_ship_to_cont_mid_name IN jtf_varchar2_table_100 := NULL,

4039: p_qs_reservation_id IN jtf_number_table := NULL,
4040: p_qs_order_line_id IN jtf_number_table := NULL,
4041: p_qs_ship_to_party_name IN jtf_varchar2_table_300 := NULL,
4042: p_qs_ship_to_cont_fst_name IN jtf_varchar2_table_100 := NULL,
4043: p_qs_ship_to_cont_mid_name IN jtf_varchar2_table_100 := NULL,
4044: p_qs_ship_to_cont_lst_name IN jtf_varchar2_table_100 := NULL,
4045: p_qs_ship_to_address1 IN jtf_varchar2_table_300 := NULL,
4046: p_qs_ship_to_address2 IN jtf_varchar2_table_300 := NULL,
4047: p_qs_ship_to_address3 IN jtf_varchar2_table_300 := NULL,

Line 4044: p_qs_ship_to_cont_lst_name IN jtf_varchar2_table_100 := NULL,

4040: p_qs_order_line_id IN jtf_number_table := NULL,
4041: p_qs_ship_to_party_name IN jtf_varchar2_table_300 := NULL,
4042: p_qs_ship_to_cont_fst_name IN jtf_varchar2_table_100 := NULL,
4043: p_qs_ship_to_cont_mid_name IN jtf_varchar2_table_100 := NULL,
4044: p_qs_ship_to_cont_lst_name IN jtf_varchar2_table_100 := NULL,
4045: p_qs_ship_to_address1 IN jtf_varchar2_table_300 := NULL,
4046: p_qs_ship_to_address2 IN jtf_varchar2_table_300 := NULL,
4047: p_qs_ship_to_address3 IN jtf_varchar2_table_300 := NULL,
4048: p_qs_ship_to_address4 IN jtf_varchar2_table_300 := NULL,

Line 4049: p_qs_ship_to_country_code IN jtf_varchar2_table_100 := NULL,

4045: p_qs_ship_to_address1 IN jtf_varchar2_table_300 := NULL,
4046: p_qs_ship_to_address2 IN jtf_varchar2_table_300 := NULL,
4047: p_qs_ship_to_address3 IN jtf_varchar2_table_300 := NULL,
4048: p_qs_ship_to_address4 IN jtf_varchar2_table_300 := NULL,
4049: p_qs_ship_to_country_code IN jtf_varchar2_table_100 := NULL,
4050: p_qs_ship_to_country IN jtf_varchar2_table_100 := NULL,
4051: p_qs_ship_to_city IN jtf_varchar2_table_100 := NULL,
4052: p_qs_ship_to_postal_code IN jtf_varchar2_table_100 := NULL,
4053: p_qs_ship_to_state IN jtf_varchar2_table_100 := NULL,

Line 4050: p_qs_ship_to_country IN jtf_varchar2_table_100 := NULL,

4046: p_qs_ship_to_address2 IN jtf_varchar2_table_300 := NULL,
4047: p_qs_ship_to_address3 IN jtf_varchar2_table_300 := NULL,
4048: p_qs_ship_to_address4 IN jtf_varchar2_table_300 := NULL,
4049: p_qs_ship_to_country_code IN jtf_varchar2_table_100 := NULL,
4050: p_qs_ship_to_country IN jtf_varchar2_table_100 := NULL,
4051: p_qs_ship_to_city IN jtf_varchar2_table_100 := NULL,
4052: p_qs_ship_to_postal_code IN jtf_varchar2_table_100 := NULL,
4053: p_qs_ship_to_state IN jtf_varchar2_table_100 := NULL,
4054: p_qs_ship_to_province IN jtf_varchar2_table_100 := NULL,

Line 4051: p_qs_ship_to_city IN jtf_varchar2_table_100 := NULL,

4047: p_qs_ship_to_address3 IN jtf_varchar2_table_300 := NULL,
4048: p_qs_ship_to_address4 IN jtf_varchar2_table_300 := NULL,
4049: p_qs_ship_to_country_code IN jtf_varchar2_table_100 := NULL,
4050: p_qs_ship_to_country IN jtf_varchar2_table_100 := NULL,
4051: p_qs_ship_to_city IN jtf_varchar2_table_100 := NULL,
4052: p_qs_ship_to_postal_code IN jtf_varchar2_table_100 := NULL,
4053: p_qs_ship_to_state IN jtf_varchar2_table_100 := NULL,
4054: p_qs_ship_to_province IN jtf_varchar2_table_100 := NULL,
4055: p_qs_ship_to_county IN jtf_varchar2_table_100 := NULL,

Line 4052: p_qs_ship_to_postal_code IN jtf_varchar2_table_100 := NULL,

4048: p_qs_ship_to_address4 IN jtf_varchar2_table_300 := NULL,
4049: p_qs_ship_to_country_code IN jtf_varchar2_table_100 := NULL,
4050: p_qs_ship_to_country IN jtf_varchar2_table_100 := NULL,
4051: p_qs_ship_to_city IN jtf_varchar2_table_100 := NULL,
4052: p_qs_ship_to_postal_code IN jtf_varchar2_table_100 := NULL,
4053: p_qs_ship_to_state IN jtf_varchar2_table_100 := NULL,
4054: p_qs_ship_to_province IN jtf_varchar2_table_100 := NULL,
4055: p_qs_ship_to_county IN jtf_varchar2_table_100 := NULL,
4056: p_qs_attribute_category IN jtf_varchar2_table_100 := NULL,

Line 4053: p_qs_ship_to_state IN jtf_varchar2_table_100 := NULL,

4049: p_qs_ship_to_country_code IN jtf_varchar2_table_100 := NULL,
4050: p_qs_ship_to_country IN jtf_varchar2_table_100 := NULL,
4051: p_qs_ship_to_city IN jtf_varchar2_table_100 := NULL,
4052: p_qs_ship_to_postal_code IN jtf_varchar2_table_100 := NULL,
4053: p_qs_ship_to_state IN jtf_varchar2_table_100 := NULL,
4054: p_qs_ship_to_province IN jtf_varchar2_table_100 := NULL,
4055: p_qs_ship_to_county IN jtf_varchar2_table_100 := NULL,
4056: p_qs_attribute_category IN jtf_varchar2_table_100 := NULL,
4057: p_qs_attribute1 IN jtf_varchar2_table_200 := NULL,

Line 4054: p_qs_ship_to_province IN jtf_varchar2_table_100 := NULL,

4050: p_qs_ship_to_country IN jtf_varchar2_table_100 := NULL,
4051: p_qs_ship_to_city IN jtf_varchar2_table_100 := NULL,
4052: p_qs_ship_to_postal_code IN jtf_varchar2_table_100 := NULL,
4053: p_qs_ship_to_state IN jtf_varchar2_table_100 := NULL,
4054: p_qs_ship_to_province IN jtf_varchar2_table_100 := NULL,
4055: p_qs_ship_to_county IN jtf_varchar2_table_100 := NULL,
4056: p_qs_attribute_category IN jtf_varchar2_table_100 := NULL,
4057: p_qs_attribute1 IN jtf_varchar2_table_200 := NULL,
4058: p_qs_attribute2 IN jtf_varchar2_table_200 := NULL,

Line 4055: p_qs_ship_to_county IN jtf_varchar2_table_100 := NULL,

4051: p_qs_ship_to_city IN jtf_varchar2_table_100 := NULL,
4052: p_qs_ship_to_postal_code IN jtf_varchar2_table_100 := NULL,
4053: p_qs_ship_to_state IN jtf_varchar2_table_100 := NULL,
4054: p_qs_ship_to_province IN jtf_varchar2_table_100 := NULL,
4055: p_qs_ship_to_county IN jtf_varchar2_table_100 := NULL,
4056: p_qs_attribute_category IN jtf_varchar2_table_100 := NULL,
4057: p_qs_attribute1 IN jtf_varchar2_table_200 := NULL,
4058: p_qs_attribute2 IN jtf_varchar2_table_200 := NULL,
4059: p_qs_attribute3 IN jtf_varchar2_table_200 := NULL,

Line 4056: p_qs_attribute_category IN jtf_varchar2_table_100 := NULL,

4052: p_qs_ship_to_postal_code IN jtf_varchar2_table_100 := NULL,
4053: p_qs_ship_to_state IN jtf_varchar2_table_100 := NULL,
4054: p_qs_ship_to_province IN jtf_varchar2_table_100 := NULL,
4055: p_qs_ship_to_county IN jtf_varchar2_table_100 := NULL,
4056: p_qs_attribute_category IN jtf_varchar2_table_100 := NULL,
4057: p_qs_attribute1 IN jtf_varchar2_table_200 := NULL,
4058: p_qs_attribute2 IN jtf_varchar2_table_200 := NULL,
4059: p_qs_attribute3 IN jtf_varchar2_table_200 := NULL,
4060: p_qs_attribute4 IN jtf_varchar2_table_200 := NULL,

Line 4072: p_qt_operation_code IN jtf_varchar2_table_100 := NULL,

4068: p_qs_attribute12 IN jtf_varchar2_table_200 := NULL,
4069: p_qs_attribute13 IN jtf_varchar2_table_200 := NULL,
4070: p_qs_attribute14 IN jtf_varchar2_table_200 := NULL,
4071: p_qs_attribute15 IN jtf_varchar2_table_200 := NULL,
4072: p_qt_operation_code IN jtf_varchar2_table_100 := NULL,
4073: p_qt_qte_line_index IN jtf_number_table := NULL,
4074: p_qt_shipment_index IN jtf_number_table := NULL,
4075: p_qt_tax_detail_id IN jtf_number_table := NULL,
4076: p_qt_quote_header_id IN jtf_number_table := NULL,

Line 4089: p_qt_tax_code IN jtf_varchar2_table_100 := NULL,

4085: p_qt_program_application_id IN jtf_number_table := NULL,
4086: p_qt_program_id IN jtf_number_table := NULL,
4087: p_qt_program_update_date IN jtf_date_table := NULL,
4088: p_qt_orig_tax_code IN jtf_varchar2_table_300 := NULL,
4089: p_qt_tax_code IN jtf_varchar2_table_100 := NULL,
4090: p_qt_tax_rate IN jtf_number_table := NULL,
4091: p_qt_tax_date IN jtf_date_table := NULL,
4092: p_qt_tax_amount IN jtf_number_table := NULL,
4093: p_qt_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,

Line 4093: p_qt_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,

4089: p_qt_tax_code IN jtf_varchar2_table_100 := NULL,
4090: p_qt_tax_rate IN jtf_number_table := NULL,
4091: p_qt_tax_date IN jtf_date_table := NULL,
4092: p_qt_tax_amount IN jtf_number_table := NULL,
4093: p_qt_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,
4094: p_qt_tax_exempt_number IN jtf_varchar2_table_100 := NULL,
4095: p_qt_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,
4096: p_qt_attribute_category IN jtf_varchar2_table_100 := NULL,
4097: p_qt_attribute1 IN jtf_varchar2_table_200 := NULL,

Line 4094: p_qt_tax_exempt_number IN jtf_varchar2_table_100 := NULL,

4090: p_qt_tax_rate IN jtf_number_table := NULL,
4091: p_qt_tax_date IN jtf_date_table := NULL,
4092: p_qt_tax_amount IN jtf_number_table := NULL,
4093: p_qt_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,
4094: p_qt_tax_exempt_number IN jtf_varchar2_table_100 := NULL,
4095: p_qt_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,
4096: p_qt_attribute_category IN jtf_varchar2_table_100 := NULL,
4097: p_qt_attribute1 IN jtf_varchar2_table_200 := NULL,
4098: p_qt_attribute2 IN jtf_varchar2_table_200 := NULL,

Line 4095: p_qt_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,

4091: p_qt_tax_date IN jtf_date_table := NULL,
4092: p_qt_tax_amount IN jtf_number_table := NULL,
4093: p_qt_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,
4094: p_qt_tax_exempt_number IN jtf_varchar2_table_100 := NULL,
4095: p_qt_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,
4096: p_qt_attribute_category IN jtf_varchar2_table_100 := NULL,
4097: p_qt_attribute1 IN jtf_varchar2_table_200 := NULL,
4098: p_qt_attribute2 IN jtf_varchar2_table_200 := NULL,
4099: p_qt_attribute3 IN jtf_varchar2_table_200 := NULL,

Line 4096: p_qt_attribute_category IN jtf_varchar2_table_100 := NULL,

4092: p_qt_tax_amount IN jtf_number_table := NULL,
4093: p_qt_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,
4094: p_qt_tax_exempt_number IN jtf_varchar2_table_100 := NULL,
4095: p_qt_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,
4096: p_qt_attribute_category IN jtf_varchar2_table_100 := NULL,
4097: p_qt_attribute1 IN jtf_varchar2_table_200 := NULL,
4098: p_qt_attribute2 IN jtf_varchar2_table_200 := NULL,
4099: p_qt_attribute3 IN jtf_varchar2_table_200 := NULL,
4100: p_qt_attribute4 IN jtf_varchar2_table_200 := NULL,

Line 4112: p_qlpa_operation_code IN jtf_varchar2_table_100 := NULL,

4108: p_qt_attribute12 IN jtf_varchar2_table_200 := NULL,
4109: p_qt_attribute13 IN jtf_varchar2_table_200 := NULL,
4110: p_qt_attribute14 IN jtf_varchar2_table_200 := NULL,
4111: p_qt_attribute15 IN jtf_varchar2_table_200 := NULL,
4112: p_qlpa_operation_code IN jtf_varchar2_table_100 := NULL,
4113: p_qlpa_qte_line_index IN jtf_number_table := NULL,
4114: p_qlpa_price_attribute_id IN jtf_number_table := NULL,
4115: p_qlpa_creation_date IN jtf_date_table := NULL,
4116: p_qlpa_created_by IN jtf_number_table := NULL,

Line 4126: p_qlpa_flex_title IN jtf_varchar2_table_100 := NULL,

4122: p_qlpa_program_id IN jtf_number_table := NULL,
4123: p_qlpa_program_update_date IN jtf_date_table := NULL,
4124: p_qlpa_quote_header_id IN jtf_number_table := NULL,
4125: p_qlpa_quote_line_id IN jtf_number_table := NULL,
4126: p_qlpa_flex_title IN jtf_varchar2_table_100 := NULL,
4127: p_qlpa_pricing_context IN jtf_varchar2_table_100 := NULL,
4128: p_qlpa_pricing_attribute1 IN jtf_varchar2_table_300 := NULL,
4129: p_qlpa_pricing_attribute2 IN jtf_varchar2_table_300 := NULL,
4130: p_qlpa_pricing_attribute3 IN jtf_varchar2_table_300 := NULL,

Line 4127: p_qlpa_pricing_context IN jtf_varchar2_table_100 := NULL,

4123: p_qlpa_program_update_date IN jtf_date_table := NULL,
4124: p_qlpa_quote_header_id IN jtf_number_table := NULL,
4125: p_qlpa_quote_line_id IN jtf_number_table := NULL,
4126: p_qlpa_flex_title IN jtf_varchar2_table_100 := NULL,
4127: p_qlpa_pricing_context IN jtf_varchar2_table_100 := NULL,
4128: p_qlpa_pricing_attribute1 IN jtf_varchar2_table_300 := NULL,
4129: p_qlpa_pricing_attribute2 IN jtf_varchar2_table_300 := NULL,
4130: p_qlpa_pricing_attribute3 IN jtf_varchar2_table_300 := NULL,
4131: p_qlpa_pricing_attribute4 IN jtf_varchar2_table_300 := NULL,

Line 4228: p_qlpa_context IN jtf_varchar2_table_100 := NULL,

4224: p_qlpa_pricing_attribute97 IN jtf_varchar2_table_300 := NULL,
4225: p_qlpa_pricing_attribute98 IN jtf_varchar2_table_300 := NULL,
4226: p_qlpa_pricing_attribute99 IN jtf_varchar2_table_300 := NULL,
4227: p_qlpa_pricing_attribute100 IN jtf_varchar2_table_300 := NULL,
4228: p_qlpa_context IN jtf_varchar2_table_100 := NULL,
4229: p_qlpa_attribute1 IN jtf_varchar2_table_300 := NULL,
4230: p_qlpa_attribute2 IN jtf_varchar2_table_300 := NULL,
4231: p_qlpa_attribute3 IN jtf_varchar2_table_300 := NULL,
4232: p_qlpa_attribute4 IN jtf_varchar2_table_300 := NULL,

Line 4244: p_qlp_operation_code IN jtf_varchar2_table_100 := NULL,

4240: p_qlpa_attribute12 IN jtf_varchar2_table_300 := NULL,
4241: p_qlpa_attribute13 IN jtf_varchar2_table_300 := NULL,
4242: p_qlpa_attribute14 IN jtf_varchar2_table_300 := NULL,
4243: p_qlpa_attribute15 IN jtf_varchar2_table_300 := NULL,
4244: p_qlp_operation_code IN jtf_varchar2_table_100 := NULL,
4245: p_qlp_qte_line_index IN jtf_number_table := NULL,
4246: p_qlp_payment_id IN jtf_number_table := NULL,
4247: p_qlp_creation_date IN jtf_date_table := NULL,
4248: p_qlp_created_by IN jtf_number_table := NULL,

Line 4258: p_qlp_payment_type_code IN jtf_varchar2_table_100 := NULL,

4254: p_qlp_program_id IN jtf_number_table := NULL,
4255: p_qlp_program_update_date IN jtf_date_table := NULL,
4256: p_qlp_quote_header_id IN jtf_number_table := NULL,
4257: p_qlp_quote_line_id IN jtf_number_table := NULL,
4258: p_qlp_payment_type_code IN jtf_varchar2_table_100 := NULL,
4259: p_qlp_payment_ref_number IN jtf_varchar2_table_300 := NULL,
4260: p_qlp_payment_option IN jtf_varchar2_table_300 := NULL,
4261: p_qlp_payment_term_id IN jtf_number_table := NULL,
4262: p_qlp_credit_card_code IN jtf_varchar2_table_100 := NULL,

Line 4262: p_qlp_credit_card_code IN jtf_varchar2_table_100 := NULL,

4258: p_qlp_payment_type_code IN jtf_varchar2_table_100 := NULL,
4259: p_qlp_payment_ref_number IN jtf_varchar2_table_300 := NULL,
4260: p_qlp_payment_option IN jtf_varchar2_table_300 := NULL,
4261: p_qlp_payment_term_id IN jtf_number_table := NULL,
4262: p_qlp_credit_card_code IN jtf_varchar2_table_100 := NULL,
4263: p_qlp_credit_card_holder_name IN jtf_varchar2_table_100 := NULL,
4264: p_qlp_credit_card_exp_date IN jtf_date_table := NULL,
4265: p_qlp_credit_card_aprv_code IN jtf_varchar2_table_100 := NULL,
4266: p_qlp_credit_card_aprv_date IN jtf_date_table := NULL,

Line 4263: p_qlp_credit_card_holder_name IN jtf_varchar2_table_100 := NULL,

4259: p_qlp_payment_ref_number IN jtf_varchar2_table_300 := NULL,
4260: p_qlp_payment_option IN jtf_varchar2_table_300 := NULL,
4261: p_qlp_payment_term_id IN jtf_number_table := NULL,
4262: p_qlp_credit_card_code IN jtf_varchar2_table_100 := NULL,
4263: p_qlp_credit_card_holder_name IN jtf_varchar2_table_100 := NULL,
4264: p_qlp_credit_card_exp_date IN jtf_date_table := NULL,
4265: p_qlp_credit_card_aprv_code IN jtf_varchar2_table_100 := NULL,
4266: p_qlp_credit_card_aprv_date IN jtf_date_table := NULL,
4267: p_qlp_payment_amount IN jtf_number_table := NULL,

Line 4265: p_qlp_credit_card_aprv_code IN jtf_varchar2_table_100 := NULL,

4261: p_qlp_payment_term_id IN jtf_number_table := NULL,
4262: p_qlp_credit_card_code IN jtf_varchar2_table_100 := NULL,
4263: p_qlp_credit_card_holder_name IN jtf_varchar2_table_100 := NULL,
4264: p_qlp_credit_card_exp_date IN jtf_date_table := NULL,
4265: p_qlp_credit_card_aprv_code IN jtf_varchar2_table_100 := NULL,
4266: p_qlp_credit_card_aprv_date IN jtf_date_table := NULL,
4267: p_qlp_payment_amount IN jtf_number_table := NULL,
4268: p_qlp_cust_po_number IN jtf_varchar2_table_100 := NULL,
4269: p_qlp_attribute_category IN jtf_varchar2_table_100 := NULL,

Line 4268: p_qlp_cust_po_number IN jtf_varchar2_table_100 := NULL,

4264: p_qlp_credit_card_exp_date IN jtf_date_table := NULL,
4265: p_qlp_credit_card_aprv_code IN jtf_varchar2_table_100 := NULL,
4266: p_qlp_credit_card_aprv_date IN jtf_date_table := NULL,
4267: p_qlp_payment_amount IN jtf_number_table := NULL,
4268: p_qlp_cust_po_number IN jtf_varchar2_table_100 := NULL,
4269: p_qlp_attribute_category IN jtf_varchar2_table_100 := NULL,
4270: p_qlp_attribute1 IN jtf_varchar2_table_200 := NULL,
4271: p_qlp_attribute2 IN jtf_varchar2_table_200 := NULL,
4272: p_qlp_attribute3 IN jtf_varchar2_table_200 := NULL,

Line 4269: p_qlp_attribute_category IN jtf_varchar2_table_100 := NULL,

4265: p_qlp_credit_card_aprv_code IN jtf_varchar2_table_100 := NULL,
4266: p_qlp_credit_card_aprv_date IN jtf_date_table := NULL,
4267: p_qlp_payment_amount IN jtf_number_table := NULL,
4268: p_qlp_cust_po_number IN jtf_varchar2_table_100 := NULL,
4269: p_qlp_attribute_category IN jtf_varchar2_table_100 := NULL,
4270: p_qlp_attribute1 IN jtf_varchar2_table_200 := NULL,
4271: p_qlp_attribute2 IN jtf_varchar2_table_200 := NULL,
4272: p_qlp_attribute3 IN jtf_varchar2_table_200 := NULL,
4273: p_qlp_attribute4 IN jtf_varchar2_table_200 := NULL,

Line 4285: p_qls_operation_code IN jtf_varchar2_table_100 := NULL,

4281: p_qlp_attribute12 IN jtf_varchar2_table_200 := NULL,
4282: p_qlp_attribute13 IN jtf_varchar2_table_200 := NULL,
4283: p_qlp_attribute14 IN jtf_varchar2_table_200 := NULL,
4284: p_qlp_attribute15 IN jtf_varchar2_table_200 := NULL,
4285: p_qls_operation_code IN jtf_varchar2_table_100 := NULL,
4286: p_qls_qte_line_index IN jtf_number_table := NULL,
4287: p_qls_shipment_id IN jtf_number_table := NULL,
4288: p_qls_creation_date IN jtf_date_table := NULL,
4289: p_qls_created_by IN jtf_number_table := NULL,

Line 4307: p_qls_ship_method_code IN jtf_varchar2_table_100 := NULL,

4303: p_qls_ship_to_party_id IN jtf_number_table := NULL,
4304: p_qls_ship_to_cust_acct_id IN jtf_number_table := NULL,
4305: p_qls_ship_partial_flag IN jtf_varchar2_table_300 := NULL,
4306: p_qls_ship_set_id IN jtf_number_table := NULL,
4307: p_qls_ship_method_code IN jtf_varchar2_table_100 := NULL,
4308: p_qls_freight_terms_code IN jtf_varchar2_table_100 := NULL,
4309: p_qls_freight_carrier_code IN jtf_varchar2_table_100 := NULL,
4310: p_qls_fob_code IN jtf_varchar2_table_100 := NULL,
4311: p_qls_shipment_priority_code IN jtf_varchar2_table_100 := NULL,

Line 4308: p_qls_freight_terms_code IN jtf_varchar2_table_100 := NULL,

4304: p_qls_ship_to_cust_acct_id IN jtf_number_table := NULL,
4305: p_qls_ship_partial_flag IN jtf_varchar2_table_300 := NULL,
4306: p_qls_ship_set_id IN jtf_number_table := NULL,
4307: p_qls_ship_method_code IN jtf_varchar2_table_100 := NULL,
4308: p_qls_freight_terms_code IN jtf_varchar2_table_100 := NULL,
4309: p_qls_freight_carrier_code IN jtf_varchar2_table_100 := NULL,
4310: p_qls_fob_code IN jtf_varchar2_table_100 := NULL,
4311: p_qls_shipment_priority_code IN jtf_varchar2_table_100 := NULL,
4312: p_qls_shipping_instructions IN jtf_varchar2_table_2000 := NULL,

Line 4309: p_qls_freight_carrier_code IN jtf_varchar2_table_100 := NULL,

4305: p_qls_ship_partial_flag IN jtf_varchar2_table_300 := NULL,
4306: p_qls_ship_set_id IN jtf_number_table := NULL,
4307: p_qls_ship_method_code IN jtf_varchar2_table_100 := NULL,
4308: p_qls_freight_terms_code IN jtf_varchar2_table_100 := NULL,
4309: p_qls_freight_carrier_code IN jtf_varchar2_table_100 := NULL,
4310: p_qls_fob_code IN jtf_varchar2_table_100 := NULL,
4311: p_qls_shipment_priority_code IN jtf_varchar2_table_100 := NULL,
4312: p_qls_shipping_instructions IN jtf_varchar2_table_2000 := NULL,
4313: p_qls_packing_instructions IN jtf_varchar2_table_2000 := NULL,

Line 4310: p_qls_fob_code IN jtf_varchar2_table_100 := NULL,

4306: p_qls_ship_set_id IN jtf_number_table := NULL,
4307: p_qls_ship_method_code IN jtf_varchar2_table_100 := NULL,
4308: p_qls_freight_terms_code IN jtf_varchar2_table_100 := NULL,
4309: p_qls_freight_carrier_code IN jtf_varchar2_table_100 := NULL,
4310: p_qls_fob_code IN jtf_varchar2_table_100 := NULL,
4311: p_qls_shipment_priority_code IN jtf_varchar2_table_100 := NULL,
4312: p_qls_shipping_instructions IN jtf_varchar2_table_2000 := NULL,
4313: p_qls_packing_instructions IN jtf_varchar2_table_2000 := NULL,
4314: p_qls_quantity IN jtf_number_table := NULL,

Line 4311: p_qls_shipment_priority_code IN jtf_varchar2_table_100 := NULL,

4307: p_qls_ship_method_code IN jtf_varchar2_table_100 := NULL,
4308: p_qls_freight_terms_code IN jtf_varchar2_table_100 := NULL,
4309: p_qls_freight_carrier_code IN jtf_varchar2_table_100 := NULL,
4310: p_qls_fob_code IN jtf_varchar2_table_100 := NULL,
4311: p_qls_shipment_priority_code IN jtf_varchar2_table_100 := NULL,
4312: p_qls_shipping_instructions IN jtf_varchar2_table_2000 := NULL,
4313: p_qls_packing_instructions IN jtf_varchar2_table_2000 := NULL,
4314: p_qls_quantity IN jtf_number_table := NULL,
4315: p_qls_reserved_quantity IN jtf_number_table := NULL,

Line 4319: p_qls_ship_to_cont_fst_name IN jtf_varchar2_table_100 := NULL,

4315: p_qls_reserved_quantity IN jtf_number_table := NULL,
4316: p_qls_reservation_id IN jtf_number_table := NULL,
4317: p_qls_order_line_id IN jtf_number_table := NULL,
4318: p_qls_ship_to_party_name IN jtf_varchar2_table_300 := NULL,
4319: p_qls_ship_to_cont_fst_name IN jtf_varchar2_table_100 := NULL,
4320: p_qls_ship_to_cont_mid_name IN jtf_varchar2_table_100 := NULL,
4321: p_qls_ship_to_cont_lst_name IN jtf_varchar2_table_100 := NULL,
4322: p_qls_ship_to_address1 IN jtf_varchar2_table_300 := NULL,
4323: p_qls_ship_to_address2 IN jtf_varchar2_table_300 := NULL,

Line 4320: p_qls_ship_to_cont_mid_name IN jtf_varchar2_table_100 := NULL,

4316: p_qls_reservation_id IN jtf_number_table := NULL,
4317: p_qls_order_line_id IN jtf_number_table := NULL,
4318: p_qls_ship_to_party_name IN jtf_varchar2_table_300 := NULL,
4319: p_qls_ship_to_cont_fst_name IN jtf_varchar2_table_100 := NULL,
4320: p_qls_ship_to_cont_mid_name IN jtf_varchar2_table_100 := NULL,
4321: p_qls_ship_to_cont_lst_name IN jtf_varchar2_table_100 := NULL,
4322: p_qls_ship_to_address1 IN jtf_varchar2_table_300 := NULL,
4323: p_qls_ship_to_address2 IN jtf_varchar2_table_300 := NULL,
4324: p_qls_ship_to_address3 IN jtf_varchar2_table_300 := NULL,

Line 4321: p_qls_ship_to_cont_lst_name IN jtf_varchar2_table_100 := NULL,

4317: p_qls_order_line_id IN jtf_number_table := NULL,
4318: p_qls_ship_to_party_name IN jtf_varchar2_table_300 := NULL,
4319: p_qls_ship_to_cont_fst_name IN jtf_varchar2_table_100 := NULL,
4320: p_qls_ship_to_cont_mid_name IN jtf_varchar2_table_100 := NULL,
4321: p_qls_ship_to_cont_lst_name IN jtf_varchar2_table_100 := NULL,
4322: p_qls_ship_to_address1 IN jtf_varchar2_table_300 := NULL,
4323: p_qls_ship_to_address2 IN jtf_varchar2_table_300 := NULL,
4324: p_qls_ship_to_address3 IN jtf_varchar2_table_300 := NULL,
4325: p_qls_ship_to_address4 IN jtf_varchar2_table_300 := NULL,

Line 4326: p_qls_ship_to_country_code IN jtf_varchar2_table_100 := NULL,

4322: p_qls_ship_to_address1 IN jtf_varchar2_table_300 := NULL,
4323: p_qls_ship_to_address2 IN jtf_varchar2_table_300 := NULL,
4324: p_qls_ship_to_address3 IN jtf_varchar2_table_300 := NULL,
4325: p_qls_ship_to_address4 IN jtf_varchar2_table_300 := NULL,
4326: p_qls_ship_to_country_code IN jtf_varchar2_table_100 := NULL,
4327: p_qls_ship_to_country IN jtf_varchar2_table_100 := NULL,
4328: p_qls_ship_to_city IN jtf_varchar2_table_100 := NULL,
4329: p_qls_ship_to_postal_code IN jtf_varchar2_table_100 := NULL,
4330: p_qls_ship_to_state IN jtf_varchar2_table_100 := NULL,

Line 4327: p_qls_ship_to_country IN jtf_varchar2_table_100 := NULL,

4323: p_qls_ship_to_address2 IN jtf_varchar2_table_300 := NULL,
4324: p_qls_ship_to_address3 IN jtf_varchar2_table_300 := NULL,
4325: p_qls_ship_to_address4 IN jtf_varchar2_table_300 := NULL,
4326: p_qls_ship_to_country_code IN jtf_varchar2_table_100 := NULL,
4327: p_qls_ship_to_country IN jtf_varchar2_table_100 := NULL,
4328: p_qls_ship_to_city IN jtf_varchar2_table_100 := NULL,
4329: p_qls_ship_to_postal_code IN jtf_varchar2_table_100 := NULL,
4330: p_qls_ship_to_state IN jtf_varchar2_table_100 := NULL,
4331: p_qls_ship_to_province IN jtf_varchar2_table_100 := NULL,

Line 4328: p_qls_ship_to_city IN jtf_varchar2_table_100 := NULL,

4324: p_qls_ship_to_address3 IN jtf_varchar2_table_300 := NULL,
4325: p_qls_ship_to_address4 IN jtf_varchar2_table_300 := NULL,
4326: p_qls_ship_to_country_code IN jtf_varchar2_table_100 := NULL,
4327: p_qls_ship_to_country IN jtf_varchar2_table_100 := NULL,
4328: p_qls_ship_to_city IN jtf_varchar2_table_100 := NULL,
4329: p_qls_ship_to_postal_code IN jtf_varchar2_table_100 := NULL,
4330: p_qls_ship_to_state IN jtf_varchar2_table_100 := NULL,
4331: p_qls_ship_to_province IN jtf_varchar2_table_100 := NULL,
4332: p_qls_ship_to_county IN jtf_varchar2_table_100 := NULL,

Line 4329: p_qls_ship_to_postal_code IN jtf_varchar2_table_100 := NULL,

4325: p_qls_ship_to_address4 IN jtf_varchar2_table_300 := NULL,
4326: p_qls_ship_to_country_code IN jtf_varchar2_table_100 := NULL,
4327: p_qls_ship_to_country IN jtf_varchar2_table_100 := NULL,
4328: p_qls_ship_to_city IN jtf_varchar2_table_100 := NULL,
4329: p_qls_ship_to_postal_code IN jtf_varchar2_table_100 := NULL,
4330: p_qls_ship_to_state IN jtf_varchar2_table_100 := NULL,
4331: p_qls_ship_to_province IN jtf_varchar2_table_100 := NULL,
4332: p_qls_ship_to_county IN jtf_varchar2_table_100 := NULL,
4333: p_qls_attribute_category IN jtf_varchar2_table_100 := NULL,

Line 4330: p_qls_ship_to_state IN jtf_varchar2_table_100 := NULL,

4326: p_qls_ship_to_country_code IN jtf_varchar2_table_100 := NULL,
4327: p_qls_ship_to_country IN jtf_varchar2_table_100 := NULL,
4328: p_qls_ship_to_city IN jtf_varchar2_table_100 := NULL,
4329: p_qls_ship_to_postal_code IN jtf_varchar2_table_100 := NULL,
4330: p_qls_ship_to_state IN jtf_varchar2_table_100 := NULL,
4331: p_qls_ship_to_province IN jtf_varchar2_table_100 := NULL,
4332: p_qls_ship_to_county IN jtf_varchar2_table_100 := NULL,
4333: p_qls_attribute_category IN jtf_varchar2_table_100 := NULL,
4334: p_qls_attribute1 IN jtf_varchar2_table_200 := NULL,

Line 4331: p_qls_ship_to_province IN jtf_varchar2_table_100 := NULL,

4327: p_qls_ship_to_country IN jtf_varchar2_table_100 := NULL,
4328: p_qls_ship_to_city IN jtf_varchar2_table_100 := NULL,
4329: p_qls_ship_to_postal_code IN jtf_varchar2_table_100 := NULL,
4330: p_qls_ship_to_state IN jtf_varchar2_table_100 := NULL,
4331: p_qls_ship_to_province IN jtf_varchar2_table_100 := NULL,
4332: p_qls_ship_to_county IN jtf_varchar2_table_100 := NULL,
4333: p_qls_attribute_category IN jtf_varchar2_table_100 := NULL,
4334: p_qls_attribute1 IN jtf_varchar2_table_200 := NULL,
4335: p_qls_attribute2 IN jtf_varchar2_table_200 := NULL,

Line 4332: p_qls_ship_to_county IN jtf_varchar2_table_100 := NULL,

4328: p_qls_ship_to_city IN jtf_varchar2_table_100 := NULL,
4329: p_qls_ship_to_postal_code IN jtf_varchar2_table_100 := NULL,
4330: p_qls_ship_to_state IN jtf_varchar2_table_100 := NULL,
4331: p_qls_ship_to_province IN jtf_varchar2_table_100 := NULL,
4332: p_qls_ship_to_county IN jtf_varchar2_table_100 := NULL,
4333: p_qls_attribute_category IN jtf_varchar2_table_100 := NULL,
4334: p_qls_attribute1 IN jtf_varchar2_table_200 := NULL,
4335: p_qls_attribute2 IN jtf_varchar2_table_200 := NULL,
4336: p_qls_attribute3 IN jtf_varchar2_table_200 := NULL,

Line 4333: p_qls_attribute_category IN jtf_varchar2_table_100 := NULL,

4329: p_qls_ship_to_postal_code IN jtf_varchar2_table_100 := NULL,
4330: p_qls_ship_to_state IN jtf_varchar2_table_100 := NULL,
4331: p_qls_ship_to_province IN jtf_varchar2_table_100 := NULL,
4332: p_qls_ship_to_county IN jtf_varchar2_table_100 := NULL,
4333: p_qls_attribute_category IN jtf_varchar2_table_100 := NULL,
4334: p_qls_attribute1 IN jtf_varchar2_table_200 := NULL,
4335: p_qls_attribute2 IN jtf_varchar2_table_200 := NULL,
4336: p_qls_attribute3 IN jtf_varchar2_table_200 := NULL,
4337: p_qls_attribute4 IN jtf_varchar2_table_200 := NULL,

Line 4349: p_qlt_operation_code IN jtf_varchar2_table_100 := NULL,

4345: p_qls_attribute12 IN jtf_varchar2_table_200 := NULL,
4346: p_qls_attribute13 IN jtf_varchar2_table_200 := NULL,
4347: p_qls_attribute14 IN jtf_varchar2_table_200 := NULL,
4348: p_qls_attribute15 IN jtf_varchar2_table_200 := NULL,
4349: p_qlt_operation_code IN jtf_varchar2_table_100 := NULL,
4350: p_qlt_qte_line_index IN jtf_number_table := NULL,
4351: p_qlt_shipment_index IN jtf_number_table := NULL,
4352: p_qlt_tax_detail_id IN jtf_number_table := NULL,
4353: p_qlt_quote_header_id IN jtf_number_table := NULL,

Line 4366: p_qlt_tax_code IN jtf_varchar2_table_100 := NULL,

4362: p_qlt_program_application_id IN jtf_number_table := NULL,
4363: p_qlt_program_id IN jtf_number_table := NULL,
4364: p_qlt_program_update_date IN jtf_date_table := NULL,
4365: p_qlt_orig_tax_code IN jtf_varchar2_table_300 := NULL,
4366: p_qlt_tax_code IN jtf_varchar2_table_100 := NULL,
4367: p_qlt_tax_rate IN jtf_number_table := NULL,
4368: p_qlt_tax_date IN jtf_date_table := NULL,
4369: p_qlt_tax_amount IN jtf_number_table := NULL,
4370: p_qlt_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,

Line 4370: p_qlt_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,

4366: p_qlt_tax_code IN jtf_varchar2_table_100 := NULL,
4367: p_qlt_tax_rate IN jtf_number_table := NULL,
4368: p_qlt_tax_date IN jtf_date_table := NULL,
4369: p_qlt_tax_amount IN jtf_number_table := NULL,
4370: p_qlt_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,
4371: p_qlt_tax_exempt_number IN jtf_varchar2_table_100 := NULL,
4372: p_qlt_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,
4373: p_qlt_attribute_category IN jtf_varchar2_table_100 := NULL,
4374: p_qlt_attribute1 IN jtf_varchar2_table_200 := NULL,

Line 4371: p_qlt_tax_exempt_number IN jtf_varchar2_table_100 := NULL,

4367: p_qlt_tax_rate IN jtf_number_table := NULL,
4368: p_qlt_tax_date IN jtf_date_table := NULL,
4369: p_qlt_tax_amount IN jtf_number_table := NULL,
4370: p_qlt_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,
4371: p_qlt_tax_exempt_number IN jtf_varchar2_table_100 := NULL,
4372: p_qlt_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,
4373: p_qlt_attribute_category IN jtf_varchar2_table_100 := NULL,
4374: p_qlt_attribute1 IN jtf_varchar2_table_200 := NULL,
4375: p_qlt_attribute2 IN jtf_varchar2_table_200 := NULL,

Line 4372: p_qlt_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,

4368: p_qlt_tax_date IN jtf_date_table := NULL,
4369: p_qlt_tax_amount IN jtf_number_table := NULL,
4370: p_qlt_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,
4371: p_qlt_tax_exempt_number IN jtf_varchar2_table_100 := NULL,
4372: p_qlt_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,
4373: p_qlt_attribute_category IN jtf_varchar2_table_100 := NULL,
4374: p_qlt_attribute1 IN jtf_varchar2_table_200 := NULL,
4375: p_qlt_attribute2 IN jtf_varchar2_table_200 := NULL,
4376: p_qlt_attribute3 IN jtf_varchar2_table_200 := NULL,

Line 4373: p_qlt_attribute_category IN jtf_varchar2_table_100 := NULL,

4369: p_qlt_tax_amount IN jtf_number_table := NULL,
4370: p_qlt_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,
4371: p_qlt_tax_exempt_number IN jtf_varchar2_table_100 := NULL,
4372: p_qlt_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,
4373: p_qlt_attribute_category IN jtf_varchar2_table_100 := NULL,
4374: p_qlt_attribute1 IN jtf_varchar2_table_200 := NULL,
4375: p_qlt_attribute2 IN jtf_varchar2_table_200 := NULL,
4376: p_qlt_attribute3 IN jtf_varchar2_table_200 := NULL,
4377: p_qlt_attribute4 IN jtf_varchar2_table_200 := NULL,

Line 4389: p_qlpaa_operation_code IN jtf_varchar2_table_100 := NULL,

4385: p_qlt_attribute12 IN jtf_varchar2_table_200 := NULL,
4386: p_qlt_attribute13 IN jtf_varchar2_table_200 := NULL,
4387: p_qlt_attribute14 IN jtf_varchar2_table_200 := NULL,
4388: p_qlt_attribute15 IN jtf_varchar2_table_200 := NULL,
4389: p_qlpaa_operation_code IN jtf_varchar2_table_100 := NULL,
4390: p_qlpaa_qte_line_index IN jtf_number_table := NULL,
4391: p_qlpaa_price_adj_index IN jtf_number_table := NULL,
4392: p_qlpaa_price_adj_attrib_id IN jtf_number_table := NULL,
4393: p_qlpaa_creation_date IN jtf_date_table := NULL,

Line 4403: p_qlpaa_pricing_context IN jtf_varchar2_table_100 := NULL,

4399: p_qlpaa_program_id IN jtf_number_table := NULL,
4400: p_qlpaa_program_update_date IN jtf_date_table := NULL,
4401: p_qlpaa_request_id IN jtf_number_table := NULL,
4402: p_qlpaa_price_adjustment_id IN jtf_number_table := NULL,
4403: p_qlpaa_pricing_context IN jtf_varchar2_table_100 := NULL,
4404: p_qlpaa_pricing_attribute IN jtf_varchar2_table_100 := NULL,
4405: p_qlpaa_prc_attr_value_from IN jtf_varchar2_table_300 := NULL,
4406: p_qlpaa_pricing_attr_value_to IN jtf_varchar2_table_300 := NULL,
4407: p_qlpaa_comparison_operator IN jtf_varchar2_table_100 := NULL,

Line 4404: p_qlpaa_pricing_attribute IN jtf_varchar2_table_100 := NULL,

4400: p_qlpaa_program_update_date IN jtf_date_table := NULL,
4401: p_qlpaa_request_id IN jtf_number_table := NULL,
4402: p_qlpaa_price_adjustment_id IN jtf_number_table := NULL,
4403: p_qlpaa_pricing_context IN jtf_varchar2_table_100 := NULL,
4404: p_qlpaa_pricing_attribute IN jtf_varchar2_table_100 := NULL,
4405: p_qlpaa_prc_attr_value_from IN jtf_varchar2_table_300 := NULL,
4406: p_qlpaa_pricing_attr_value_to IN jtf_varchar2_table_300 := NULL,
4407: p_qlpaa_comparison_operator IN jtf_varchar2_table_100 := NULL,
4408: p_qlpaa_flex_title IN jtf_varchar2_table_100 := NULL,

Line 4407: p_qlpaa_comparison_operator IN jtf_varchar2_table_100 := NULL,

4403: p_qlpaa_pricing_context IN jtf_varchar2_table_100 := NULL,
4404: p_qlpaa_pricing_attribute IN jtf_varchar2_table_100 := NULL,
4405: p_qlpaa_prc_attr_value_from IN jtf_varchar2_table_300 := NULL,
4406: p_qlpaa_pricing_attr_value_to IN jtf_varchar2_table_300 := NULL,
4407: p_qlpaa_comparison_operator IN jtf_varchar2_table_100 := NULL,
4408: p_qlpaa_flex_title IN jtf_varchar2_table_100 := NULL,
4409: p_qlpaj_operation_code IN jtf_varchar2_table_100 := NULL,
4410: p_qlpaj_qte_line_index IN jtf_number_table := NULL,
4411: p_qlpaj_price_adjustment_id IN jtf_number_table := NULL,

Line 4408: p_qlpaa_flex_title IN jtf_varchar2_table_100 := NULL,

4404: p_qlpaa_pricing_attribute IN jtf_varchar2_table_100 := NULL,
4405: p_qlpaa_prc_attr_value_from IN jtf_varchar2_table_300 := NULL,
4406: p_qlpaa_pricing_attr_value_to IN jtf_varchar2_table_300 := NULL,
4407: p_qlpaa_comparison_operator IN jtf_varchar2_table_100 := NULL,
4408: p_qlpaa_flex_title IN jtf_varchar2_table_100 := NULL,
4409: p_qlpaj_operation_code IN jtf_varchar2_table_100 := NULL,
4410: p_qlpaj_qte_line_index IN jtf_number_table := NULL,
4411: p_qlpaj_price_adjustment_id IN jtf_number_table := NULL,
4412: p_qlpaj_creation_date IN jtf_date_table := NULL,

Line 4409: p_qlpaj_operation_code IN jtf_varchar2_table_100 := NULL,

4405: p_qlpaa_prc_attr_value_from IN jtf_varchar2_table_300 := NULL,
4406: p_qlpaa_pricing_attr_value_to IN jtf_varchar2_table_300 := NULL,
4407: p_qlpaa_comparison_operator IN jtf_varchar2_table_100 := NULL,
4408: p_qlpaa_flex_title IN jtf_varchar2_table_100 := NULL,
4409: p_qlpaj_operation_code IN jtf_varchar2_table_100 := NULL,
4410: p_qlpaj_qte_line_index IN jtf_number_table := NULL,
4411: p_qlpaj_price_adjustment_id IN jtf_number_table := NULL,
4412: p_qlpaj_creation_date IN jtf_date_table := NULL,
4413: p_qlpaj_created_by IN jtf_number_table := NULL,

Line 4425: p_qlpaj_mod_line_type_code IN jtf_varchar2_table_100 := NULL,

4421: p_qlpaj_quote_header_id IN jtf_number_table := NULL,
4422: p_qlpaj_quote_line_id IN jtf_number_table := NULL,
4423: p_qlpaj_modifier_header_id IN jtf_number_table := NULL,
4424: p_qlpaj_modifier_line_id IN jtf_number_table := NULL,
4425: p_qlpaj_mod_line_type_code IN jtf_varchar2_table_100 := NULL,
4426: p_qlpaj_mod_mech_type_code IN jtf_varchar2_table_100 := NULL,
4427: p_qlpaj_modified_from IN jtf_number_table := NULL,
4428: p_qlpaj_modified_to IN jtf_number_table := NULL,
4429: p_qlpaj_operand IN jtf_number_table := NULL,

Line 4426: p_qlpaj_mod_mech_type_code IN jtf_varchar2_table_100 := NULL,

4422: p_qlpaj_quote_line_id IN jtf_number_table := NULL,
4423: p_qlpaj_modifier_header_id IN jtf_number_table := NULL,
4424: p_qlpaj_modifier_line_id IN jtf_number_table := NULL,
4425: p_qlpaj_mod_line_type_code IN jtf_varchar2_table_100 := NULL,
4426: p_qlpaj_mod_mech_type_code IN jtf_varchar2_table_100 := NULL,
4427: p_qlpaj_modified_from IN jtf_number_table := NULL,
4428: p_qlpaj_modified_to IN jtf_number_table := NULL,
4429: p_qlpaj_operand IN jtf_number_table := NULL,
4430: p_qlpaj_arithmetic_operator IN jtf_varchar2_table_100 := NULL,

Line 4430: p_qlpaj_arithmetic_operator IN jtf_varchar2_table_100 := NULL,

4426: p_qlpaj_mod_mech_type_code IN jtf_varchar2_table_100 := NULL,
4427: p_qlpaj_modified_from IN jtf_number_table := NULL,
4428: p_qlpaj_modified_to IN jtf_number_table := NULL,
4429: p_qlpaj_operand IN jtf_number_table := NULL,
4430: p_qlpaj_arithmetic_operator IN jtf_varchar2_table_100 := NULL,
4431: p_qlpaj_automatic_flag IN jtf_varchar2_table_100 := NULL,
4432: p_qlpaj_update_allowable_flag IN jtf_varchar2_table_100 := NULL,
4433: p_qlpaj_updated_flag IN jtf_varchar2_table_100 := NULL,
4434: p_qlpaj_applied_flag IN jtf_varchar2_table_100 := NULL,

Line 4431: p_qlpaj_automatic_flag IN jtf_varchar2_table_100 := NULL,

4427: p_qlpaj_modified_from IN jtf_number_table := NULL,
4428: p_qlpaj_modified_to IN jtf_number_table := NULL,
4429: p_qlpaj_operand IN jtf_number_table := NULL,
4430: p_qlpaj_arithmetic_operator IN jtf_varchar2_table_100 := NULL,
4431: p_qlpaj_automatic_flag IN jtf_varchar2_table_100 := NULL,
4432: p_qlpaj_update_allowable_flag IN jtf_varchar2_table_100 := NULL,
4433: p_qlpaj_updated_flag IN jtf_varchar2_table_100 := NULL,
4434: p_qlpaj_applied_flag IN jtf_varchar2_table_100 := NULL,
4435: p_qlpaj_on_invoice_flag IN jtf_varchar2_table_100 := NULL,

Line 4432: p_qlpaj_update_allowable_flag IN jtf_varchar2_table_100 := NULL,

4428: p_qlpaj_modified_to IN jtf_number_table := NULL,
4429: p_qlpaj_operand IN jtf_number_table := NULL,
4430: p_qlpaj_arithmetic_operator IN jtf_varchar2_table_100 := NULL,
4431: p_qlpaj_automatic_flag IN jtf_varchar2_table_100 := NULL,
4432: p_qlpaj_update_allowable_flag IN jtf_varchar2_table_100 := NULL,
4433: p_qlpaj_updated_flag IN jtf_varchar2_table_100 := NULL,
4434: p_qlpaj_applied_flag IN jtf_varchar2_table_100 := NULL,
4435: p_qlpaj_on_invoice_flag IN jtf_varchar2_table_100 := NULL,
4436: p_qlpaj_pricing_phase_id IN jtf_number_table := NULL,

Line 4433: p_qlpaj_updated_flag IN jtf_varchar2_table_100 := NULL,

4429: p_qlpaj_operand IN jtf_number_table := NULL,
4430: p_qlpaj_arithmetic_operator IN jtf_varchar2_table_100 := NULL,
4431: p_qlpaj_automatic_flag IN jtf_varchar2_table_100 := NULL,
4432: p_qlpaj_update_allowable_flag IN jtf_varchar2_table_100 := NULL,
4433: p_qlpaj_updated_flag IN jtf_varchar2_table_100 := NULL,
4434: p_qlpaj_applied_flag IN jtf_varchar2_table_100 := NULL,
4435: p_qlpaj_on_invoice_flag IN jtf_varchar2_table_100 := NULL,
4436: p_qlpaj_pricing_phase_id IN jtf_number_table := NULL,
4437: p_qlpaj_attribute_category IN jtf_varchar2_table_100 := NULL,

Line 4434: p_qlpaj_applied_flag IN jtf_varchar2_table_100 := NULL,

4430: p_qlpaj_arithmetic_operator IN jtf_varchar2_table_100 := NULL,
4431: p_qlpaj_automatic_flag IN jtf_varchar2_table_100 := NULL,
4432: p_qlpaj_update_allowable_flag IN jtf_varchar2_table_100 := NULL,
4433: p_qlpaj_updated_flag IN jtf_varchar2_table_100 := NULL,
4434: p_qlpaj_applied_flag IN jtf_varchar2_table_100 := NULL,
4435: p_qlpaj_on_invoice_flag IN jtf_varchar2_table_100 := NULL,
4436: p_qlpaj_pricing_phase_id IN jtf_number_table := NULL,
4437: p_qlpaj_attribute_category IN jtf_varchar2_table_100 := NULL,
4438: p_qlpaj_attribute1 IN jtf_varchar2_table_200 := NULL,

Line 4435: p_qlpaj_on_invoice_flag IN jtf_varchar2_table_100 := NULL,

4431: p_qlpaj_automatic_flag IN jtf_varchar2_table_100 := NULL,
4432: p_qlpaj_update_allowable_flag IN jtf_varchar2_table_100 := NULL,
4433: p_qlpaj_updated_flag IN jtf_varchar2_table_100 := NULL,
4434: p_qlpaj_applied_flag IN jtf_varchar2_table_100 := NULL,
4435: p_qlpaj_on_invoice_flag IN jtf_varchar2_table_100 := NULL,
4436: p_qlpaj_pricing_phase_id IN jtf_number_table := NULL,
4437: p_qlpaj_attribute_category IN jtf_varchar2_table_100 := NULL,
4438: p_qlpaj_attribute1 IN jtf_varchar2_table_200 := NULL,
4439: p_qlpaj_attribute2 IN jtf_varchar2_table_200 := NULL,

Line 4437: p_qlpaj_attribute_category IN jtf_varchar2_table_100 := NULL,

4433: p_qlpaj_updated_flag IN jtf_varchar2_table_100 := NULL,
4434: p_qlpaj_applied_flag IN jtf_varchar2_table_100 := NULL,
4435: p_qlpaj_on_invoice_flag IN jtf_varchar2_table_100 := NULL,
4436: p_qlpaj_pricing_phase_id IN jtf_number_table := NULL,
4437: p_qlpaj_attribute_category IN jtf_varchar2_table_100 := NULL,
4438: p_qlpaj_attribute1 IN jtf_varchar2_table_200 := NULL,
4439: p_qlpaj_attribute2 IN jtf_varchar2_table_200 := NULL,
4440: p_qlpaj_attribute3 IN jtf_varchar2_table_200 := NULL,
4441: p_qlpaj_attribute4 IN jtf_varchar2_table_200 := NULL,

Line 4453: p_qlpaj_orig_sys_discount_ref IN jtf_varchar2_table_100 := NULL,

4449: p_qlpaj_attribute12 IN jtf_varchar2_table_200 := NULL,
4450: p_qlpaj_attribute13 IN jtf_varchar2_table_200 := NULL,
4451: p_qlpaj_attribute14 IN jtf_varchar2_table_200 := NULL,
4452: p_qlpaj_attribute15 IN jtf_varchar2_table_200 := NULL,
4453: p_qlpaj_orig_sys_discount_ref IN jtf_varchar2_table_100 := NULL,
4454: p_qlpaj_change_sequence IN jtf_varchar2_table_100 := NULL,
4455: p_qlpaj_update_allowed IN jtf_varchar2_table_100 := NULL,
4456: p_qlpaj_change_reason_code IN jtf_varchar2_table_100 := NULL,
4457: p_qlpaj_change_reason_text IN jtf_varchar2_table_2000 := NULL,

Line 4454: p_qlpaj_change_sequence IN jtf_varchar2_table_100 := NULL,

4450: p_qlpaj_attribute13 IN jtf_varchar2_table_200 := NULL,
4451: p_qlpaj_attribute14 IN jtf_varchar2_table_200 := NULL,
4452: p_qlpaj_attribute15 IN jtf_varchar2_table_200 := NULL,
4453: p_qlpaj_orig_sys_discount_ref IN jtf_varchar2_table_100 := NULL,
4454: p_qlpaj_change_sequence IN jtf_varchar2_table_100 := NULL,
4455: p_qlpaj_update_allowed IN jtf_varchar2_table_100 := NULL,
4456: p_qlpaj_change_reason_code IN jtf_varchar2_table_100 := NULL,
4457: p_qlpaj_change_reason_text IN jtf_varchar2_table_2000 := NULL,
4458: p_qlpaj_cost_id IN jtf_number_table := NULL,

Line 4455: p_qlpaj_update_allowed IN jtf_varchar2_table_100 := NULL,

4451: p_qlpaj_attribute14 IN jtf_varchar2_table_200 := NULL,
4452: p_qlpaj_attribute15 IN jtf_varchar2_table_200 := NULL,
4453: p_qlpaj_orig_sys_discount_ref IN jtf_varchar2_table_100 := NULL,
4454: p_qlpaj_change_sequence IN jtf_varchar2_table_100 := NULL,
4455: p_qlpaj_update_allowed IN jtf_varchar2_table_100 := NULL,
4456: p_qlpaj_change_reason_code IN jtf_varchar2_table_100 := NULL,
4457: p_qlpaj_change_reason_text IN jtf_varchar2_table_2000 := NULL,
4458: p_qlpaj_cost_id IN jtf_number_table := NULL,
4459: p_qlpaj_tax_code IN jtf_varchar2_table_100 := NULL,

Line 4456: p_qlpaj_change_reason_code IN jtf_varchar2_table_100 := NULL,

4452: p_qlpaj_attribute15 IN jtf_varchar2_table_200 := NULL,
4453: p_qlpaj_orig_sys_discount_ref IN jtf_varchar2_table_100 := NULL,
4454: p_qlpaj_change_sequence IN jtf_varchar2_table_100 := NULL,
4455: p_qlpaj_update_allowed IN jtf_varchar2_table_100 := NULL,
4456: p_qlpaj_change_reason_code IN jtf_varchar2_table_100 := NULL,
4457: p_qlpaj_change_reason_text IN jtf_varchar2_table_2000 := NULL,
4458: p_qlpaj_cost_id IN jtf_number_table := NULL,
4459: p_qlpaj_tax_code IN jtf_varchar2_table_100 := NULL,
4460: p_qlpaj_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,

Line 4459: p_qlpaj_tax_code IN jtf_varchar2_table_100 := NULL,

4455: p_qlpaj_update_allowed IN jtf_varchar2_table_100 := NULL,
4456: p_qlpaj_change_reason_code IN jtf_varchar2_table_100 := NULL,
4457: p_qlpaj_change_reason_text IN jtf_varchar2_table_2000 := NULL,
4458: p_qlpaj_cost_id IN jtf_number_table := NULL,
4459: p_qlpaj_tax_code IN jtf_varchar2_table_100 := NULL,
4460: p_qlpaj_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,
4461: p_qlpaj_tax_exempt_number IN jtf_varchar2_table_100 := NULL,
4462: p_qlpaj_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,
4463: p_qlpaj_parent_adjustment_id IN jtf_number_table := NULL,

Line 4460: p_qlpaj_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,

4456: p_qlpaj_change_reason_code IN jtf_varchar2_table_100 := NULL,
4457: p_qlpaj_change_reason_text IN jtf_varchar2_table_2000 := NULL,
4458: p_qlpaj_cost_id IN jtf_number_table := NULL,
4459: p_qlpaj_tax_code IN jtf_varchar2_table_100 := NULL,
4460: p_qlpaj_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,
4461: p_qlpaj_tax_exempt_number IN jtf_varchar2_table_100 := NULL,
4462: p_qlpaj_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,
4463: p_qlpaj_parent_adjustment_id IN jtf_number_table := NULL,
4464: p_qlpaj_invoiced_flag IN jtf_varchar2_table_100 := NULL,

Line 4461: p_qlpaj_tax_exempt_number IN jtf_varchar2_table_100 := NULL,

4457: p_qlpaj_change_reason_text IN jtf_varchar2_table_2000 := NULL,
4458: p_qlpaj_cost_id IN jtf_number_table := NULL,
4459: p_qlpaj_tax_code IN jtf_varchar2_table_100 := NULL,
4460: p_qlpaj_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,
4461: p_qlpaj_tax_exempt_number IN jtf_varchar2_table_100 := NULL,
4462: p_qlpaj_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,
4463: p_qlpaj_parent_adjustment_id IN jtf_number_table := NULL,
4464: p_qlpaj_invoiced_flag IN jtf_varchar2_table_100 := NULL,
4465: p_qlpaj_estimated_flag IN jtf_varchar2_table_100 := NULL,

Line 4462: p_qlpaj_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,

4458: p_qlpaj_cost_id IN jtf_number_table := NULL,
4459: p_qlpaj_tax_code IN jtf_varchar2_table_100 := NULL,
4460: p_qlpaj_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,
4461: p_qlpaj_tax_exempt_number IN jtf_varchar2_table_100 := NULL,
4462: p_qlpaj_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,
4463: p_qlpaj_parent_adjustment_id IN jtf_number_table := NULL,
4464: p_qlpaj_invoiced_flag IN jtf_varchar2_table_100 := NULL,
4465: p_qlpaj_estimated_flag IN jtf_varchar2_table_100 := NULL,
4466: p_qlpaj_inc_in_sales_perfce IN jtf_varchar2_table_100 := NULL,

Line 4464: p_qlpaj_invoiced_flag IN jtf_varchar2_table_100 := NULL,

4460: p_qlpaj_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,
4461: p_qlpaj_tax_exempt_number IN jtf_varchar2_table_100 := NULL,
4462: p_qlpaj_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,
4463: p_qlpaj_parent_adjustment_id IN jtf_number_table := NULL,
4464: p_qlpaj_invoiced_flag IN jtf_varchar2_table_100 := NULL,
4465: p_qlpaj_estimated_flag IN jtf_varchar2_table_100 := NULL,
4466: p_qlpaj_inc_in_sales_perfce IN jtf_varchar2_table_100 := NULL,
4467: p_qlpaj_split_action_code IN jtf_varchar2_table_100 := NULL,
4468: p_qlpaj_adjusted_amount IN jtf_number_table := NULL,

Line 4465: p_qlpaj_estimated_flag IN jtf_varchar2_table_100 := NULL,

4461: p_qlpaj_tax_exempt_number IN jtf_varchar2_table_100 := NULL,
4462: p_qlpaj_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,
4463: p_qlpaj_parent_adjustment_id IN jtf_number_table := NULL,
4464: p_qlpaj_invoiced_flag IN jtf_varchar2_table_100 := NULL,
4465: p_qlpaj_estimated_flag IN jtf_varchar2_table_100 := NULL,
4466: p_qlpaj_inc_in_sales_perfce IN jtf_varchar2_table_100 := NULL,
4467: p_qlpaj_split_action_code IN jtf_varchar2_table_100 := NULL,
4468: p_qlpaj_adjusted_amount IN jtf_number_table := NULL,
4469: p_qlpaj_charge_type_code IN jtf_varchar2_table_100 := NULL,

Line 4466: p_qlpaj_inc_in_sales_perfce IN jtf_varchar2_table_100 := NULL,

4462: p_qlpaj_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,
4463: p_qlpaj_parent_adjustment_id IN jtf_number_table := NULL,
4464: p_qlpaj_invoiced_flag IN jtf_varchar2_table_100 := NULL,
4465: p_qlpaj_estimated_flag IN jtf_varchar2_table_100 := NULL,
4466: p_qlpaj_inc_in_sales_perfce IN jtf_varchar2_table_100 := NULL,
4467: p_qlpaj_split_action_code IN jtf_varchar2_table_100 := NULL,
4468: p_qlpaj_adjusted_amount IN jtf_number_table := NULL,
4469: p_qlpaj_charge_type_code IN jtf_varchar2_table_100 := NULL,
4470: p_qlpaj_charge_subtype_code IN jtf_varchar2_table_100 := NULL,

Line 4467: p_qlpaj_split_action_code IN jtf_varchar2_table_100 := NULL,

4463: p_qlpaj_parent_adjustment_id IN jtf_number_table := NULL,
4464: p_qlpaj_invoiced_flag IN jtf_varchar2_table_100 := NULL,
4465: p_qlpaj_estimated_flag IN jtf_varchar2_table_100 := NULL,
4466: p_qlpaj_inc_in_sales_perfce IN jtf_varchar2_table_100 := NULL,
4467: p_qlpaj_split_action_code IN jtf_varchar2_table_100 := NULL,
4468: p_qlpaj_adjusted_amount IN jtf_number_table := NULL,
4469: p_qlpaj_charge_type_code IN jtf_varchar2_table_100 := NULL,
4470: p_qlpaj_charge_subtype_code IN jtf_varchar2_table_100 := NULL,
4471: p_qlpaj_range_break_quantity IN jtf_number_table := NULL,

Line 4469: p_qlpaj_charge_type_code IN jtf_varchar2_table_100 := NULL,

4465: p_qlpaj_estimated_flag IN jtf_varchar2_table_100 := NULL,
4466: p_qlpaj_inc_in_sales_perfce IN jtf_varchar2_table_100 := NULL,
4467: p_qlpaj_split_action_code IN jtf_varchar2_table_100 := NULL,
4468: p_qlpaj_adjusted_amount IN jtf_number_table := NULL,
4469: p_qlpaj_charge_type_code IN jtf_varchar2_table_100 := NULL,
4470: p_qlpaj_charge_subtype_code IN jtf_varchar2_table_100 := NULL,
4471: p_qlpaj_range_break_quantity IN jtf_number_table := NULL,
4472: p_qlpaj_accrual_conv_rate IN jtf_number_table := NULL,
4473: p_qlpaj_pricing_group_sequence IN jtf_number_table := NULL,

Line 4470: p_qlpaj_charge_subtype_code IN jtf_varchar2_table_100 := NULL,

4466: p_qlpaj_inc_in_sales_perfce IN jtf_varchar2_table_100 := NULL,
4467: p_qlpaj_split_action_code IN jtf_varchar2_table_100 := NULL,
4468: p_qlpaj_adjusted_amount IN jtf_number_table := NULL,
4469: p_qlpaj_charge_type_code IN jtf_varchar2_table_100 := NULL,
4470: p_qlpaj_charge_subtype_code IN jtf_varchar2_table_100 := NULL,
4471: p_qlpaj_range_break_quantity IN jtf_number_table := NULL,
4472: p_qlpaj_accrual_conv_rate IN jtf_number_table := NULL,
4473: p_qlpaj_pricing_group_sequence IN jtf_number_table := NULL,
4474: p_qlpaj_accrual_flag IN jtf_varchar2_table_100 := NULL,

Line 4474: p_qlpaj_accrual_flag IN jtf_varchar2_table_100 := NULL,

4470: p_qlpaj_charge_subtype_code IN jtf_varchar2_table_100 := NULL,
4471: p_qlpaj_range_break_quantity IN jtf_number_table := NULL,
4472: p_qlpaj_accrual_conv_rate IN jtf_number_table := NULL,
4473: p_qlpaj_pricing_group_sequence IN jtf_number_table := NULL,
4474: p_qlpaj_accrual_flag IN jtf_varchar2_table_100 := NULL,
4475: p_qlpaj_list_line_no IN jtf_varchar2_table_300 := NULL,
4476: p_qlpaj_source_system_code IN jtf_varchar2_table_100 := NULL,
4477: p_qlpaj_benefit_qty IN jtf_number_table := NULL,
4478: p_qlpaj_benefit_uom_code IN jtf_varchar2_table_100 := NULL,

Line 4476: p_qlpaj_source_system_code IN jtf_varchar2_table_100 := NULL,

4472: p_qlpaj_accrual_conv_rate IN jtf_number_table := NULL,
4473: p_qlpaj_pricing_group_sequence IN jtf_number_table := NULL,
4474: p_qlpaj_accrual_flag IN jtf_varchar2_table_100 := NULL,
4475: p_qlpaj_list_line_no IN jtf_varchar2_table_300 := NULL,
4476: p_qlpaj_source_system_code IN jtf_varchar2_table_100 := NULL,
4477: p_qlpaj_benefit_qty IN jtf_number_table := NULL,
4478: p_qlpaj_benefit_uom_code IN jtf_varchar2_table_100 := NULL,
4479: p_qlpaj_print_on_invoice_flag IN jtf_varchar2_table_100 := NULL,
4480: p_qlpaj_expiration_date IN jtf_date_table := NULL,

Line 4478: p_qlpaj_benefit_uom_code IN jtf_varchar2_table_100 := NULL,

4474: p_qlpaj_accrual_flag IN jtf_varchar2_table_100 := NULL,
4475: p_qlpaj_list_line_no IN jtf_varchar2_table_300 := NULL,
4476: p_qlpaj_source_system_code IN jtf_varchar2_table_100 := NULL,
4477: p_qlpaj_benefit_qty IN jtf_number_table := NULL,
4478: p_qlpaj_benefit_uom_code IN jtf_varchar2_table_100 := NULL,
4479: p_qlpaj_print_on_invoice_flag IN jtf_varchar2_table_100 := NULL,
4480: p_qlpaj_expiration_date IN jtf_date_table := NULL,
4481: p_qlpaj_rebate_trans_type_code IN jtf_varchar2_table_100 := NULL,
4482: p_qlpaj_rebate_trans_reference IN jtf_varchar2_table_100 := NULL,

Line 4479: p_qlpaj_print_on_invoice_flag IN jtf_varchar2_table_100 := NULL,

4475: p_qlpaj_list_line_no IN jtf_varchar2_table_300 := NULL,
4476: p_qlpaj_source_system_code IN jtf_varchar2_table_100 := NULL,
4477: p_qlpaj_benefit_qty IN jtf_number_table := NULL,
4478: p_qlpaj_benefit_uom_code IN jtf_varchar2_table_100 := NULL,
4479: p_qlpaj_print_on_invoice_flag IN jtf_varchar2_table_100 := NULL,
4480: p_qlpaj_expiration_date IN jtf_date_table := NULL,
4481: p_qlpaj_rebate_trans_type_code IN jtf_varchar2_table_100 := NULL,
4482: p_qlpaj_rebate_trans_reference IN jtf_varchar2_table_100 := NULL,
4483: p_qlpaj_rebate_pay_system_code IN jtf_varchar2_table_100 := NULL,

Line 4481: p_qlpaj_rebate_trans_type_code IN jtf_varchar2_table_100 := NULL,

4477: p_qlpaj_benefit_qty IN jtf_number_table := NULL,
4478: p_qlpaj_benefit_uom_code IN jtf_varchar2_table_100 := NULL,
4479: p_qlpaj_print_on_invoice_flag IN jtf_varchar2_table_100 := NULL,
4480: p_qlpaj_expiration_date IN jtf_date_table := NULL,
4481: p_qlpaj_rebate_trans_type_code IN jtf_varchar2_table_100 := NULL,
4482: p_qlpaj_rebate_trans_reference IN jtf_varchar2_table_100 := NULL,
4483: p_qlpaj_rebate_pay_system_code IN jtf_varchar2_table_100 := NULL,
4484: p_qlpaj_redeemed_date IN jtf_date_table := NULL,
4485: p_qlpaj_redeemed_flag IN jtf_varchar2_table_100 := NULL,

Line 4482: p_qlpaj_rebate_trans_reference IN jtf_varchar2_table_100 := NULL,

4478: p_qlpaj_benefit_uom_code IN jtf_varchar2_table_100 := NULL,
4479: p_qlpaj_print_on_invoice_flag IN jtf_varchar2_table_100 := NULL,
4480: p_qlpaj_expiration_date IN jtf_date_table := NULL,
4481: p_qlpaj_rebate_trans_type_code IN jtf_varchar2_table_100 := NULL,
4482: p_qlpaj_rebate_trans_reference IN jtf_varchar2_table_100 := NULL,
4483: p_qlpaj_rebate_pay_system_code IN jtf_varchar2_table_100 := NULL,
4484: p_qlpaj_redeemed_date IN jtf_date_table := NULL,
4485: p_qlpaj_redeemed_flag IN jtf_varchar2_table_100 := NULL,
4486: p_qlpaj_modifier_level_code IN jtf_varchar2_table_100 := NULL,

Line 4483: p_qlpaj_rebate_pay_system_code IN jtf_varchar2_table_100 := NULL,

4479: p_qlpaj_print_on_invoice_flag IN jtf_varchar2_table_100 := NULL,
4480: p_qlpaj_expiration_date IN jtf_date_table := NULL,
4481: p_qlpaj_rebate_trans_type_code IN jtf_varchar2_table_100 := NULL,
4482: p_qlpaj_rebate_trans_reference IN jtf_varchar2_table_100 := NULL,
4483: p_qlpaj_rebate_pay_system_code IN jtf_varchar2_table_100 := NULL,
4484: p_qlpaj_redeemed_date IN jtf_date_table := NULL,
4485: p_qlpaj_redeemed_flag IN jtf_varchar2_table_100 := NULL,
4486: p_qlpaj_modifier_level_code IN jtf_varchar2_table_100 := NULL,
4487: p_qlpaj_price_break_type_code IN jtf_varchar2_table_100 := NULL,

Line 4485: p_qlpaj_redeemed_flag IN jtf_varchar2_table_100 := NULL,

4481: p_qlpaj_rebate_trans_type_code IN jtf_varchar2_table_100 := NULL,
4482: p_qlpaj_rebate_trans_reference IN jtf_varchar2_table_100 := NULL,
4483: p_qlpaj_rebate_pay_system_code IN jtf_varchar2_table_100 := NULL,
4484: p_qlpaj_redeemed_date IN jtf_date_table := NULL,
4485: p_qlpaj_redeemed_flag IN jtf_varchar2_table_100 := NULL,
4486: p_qlpaj_modifier_level_code IN jtf_varchar2_table_100 := NULL,
4487: p_qlpaj_price_break_type_code IN jtf_varchar2_table_100 := NULL,
4488: p_qlpaj_substitution_attribute IN jtf_varchar2_table_100 := NULL,
4489: p_qlpaj_proration_type_code IN jtf_varchar2_table_100 := NULL,

Line 4486: p_qlpaj_modifier_level_code IN jtf_varchar2_table_100 := NULL,

4482: p_qlpaj_rebate_trans_reference IN jtf_varchar2_table_100 := NULL,
4483: p_qlpaj_rebate_pay_system_code IN jtf_varchar2_table_100 := NULL,
4484: p_qlpaj_redeemed_date IN jtf_date_table := NULL,
4485: p_qlpaj_redeemed_flag IN jtf_varchar2_table_100 := NULL,
4486: p_qlpaj_modifier_level_code IN jtf_varchar2_table_100 := NULL,
4487: p_qlpaj_price_break_type_code IN jtf_varchar2_table_100 := NULL,
4488: p_qlpaj_substitution_attribute IN jtf_varchar2_table_100 := NULL,
4489: p_qlpaj_proration_type_code IN jtf_varchar2_table_100 := NULL,
4490: p_qlpaj_include_on_ret_flag IN jtf_varchar2_table_100 := NULL,

Line 4487: p_qlpaj_price_break_type_code IN jtf_varchar2_table_100 := NULL,

4483: p_qlpaj_rebate_pay_system_code IN jtf_varchar2_table_100 := NULL,
4484: p_qlpaj_redeemed_date IN jtf_date_table := NULL,
4485: p_qlpaj_redeemed_flag IN jtf_varchar2_table_100 := NULL,
4486: p_qlpaj_modifier_level_code IN jtf_varchar2_table_100 := NULL,
4487: p_qlpaj_price_break_type_code IN jtf_varchar2_table_100 := NULL,
4488: p_qlpaj_substitution_attribute IN jtf_varchar2_table_100 := NULL,
4489: p_qlpaj_proration_type_code IN jtf_varchar2_table_100 := NULL,
4490: p_qlpaj_include_on_ret_flag IN jtf_varchar2_table_100 := NULL,
4491: p_qlpaj_credit_or_charge_flag IN jtf_varchar2_table_100 := NULL,

Line 4488: p_qlpaj_substitution_attribute IN jtf_varchar2_table_100 := NULL,

4484: p_qlpaj_redeemed_date IN jtf_date_table := NULL,
4485: p_qlpaj_redeemed_flag IN jtf_varchar2_table_100 := NULL,
4486: p_qlpaj_modifier_level_code IN jtf_varchar2_table_100 := NULL,
4487: p_qlpaj_price_break_type_code IN jtf_varchar2_table_100 := NULL,
4488: p_qlpaj_substitution_attribute IN jtf_varchar2_table_100 := NULL,
4489: p_qlpaj_proration_type_code IN jtf_varchar2_table_100 := NULL,
4490: p_qlpaj_include_on_ret_flag IN jtf_varchar2_table_100 := NULL,
4491: p_qlpaj_credit_or_charge_flag IN jtf_varchar2_table_100 := NULL,
4492: p_qlpar_operation_code IN jtf_varchar2_table_100 := NULL,

Line 4489: p_qlpaj_proration_type_code IN jtf_varchar2_table_100 := NULL,

4485: p_qlpaj_redeemed_flag IN jtf_varchar2_table_100 := NULL,
4486: p_qlpaj_modifier_level_code IN jtf_varchar2_table_100 := NULL,
4487: p_qlpaj_price_break_type_code IN jtf_varchar2_table_100 := NULL,
4488: p_qlpaj_substitution_attribute IN jtf_varchar2_table_100 := NULL,
4489: p_qlpaj_proration_type_code IN jtf_varchar2_table_100 := NULL,
4490: p_qlpaj_include_on_ret_flag IN jtf_varchar2_table_100 := NULL,
4491: p_qlpaj_credit_or_charge_flag IN jtf_varchar2_table_100 := NULL,
4492: p_qlpar_operation_code IN jtf_varchar2_table_100 := NULL,
4493: p_qlpar_adj_relationship_id IN jtf_number_table := NULL,

Line 4490: p_qlpaj_include_on_ret_flag IN jtf_varchar2_table_100 := NULL,

4486: p_qlpaj_modifier_level_code IN jtf_varchar2_table_100 := NULL,
4487: p_qlpaj_price_break_type_code IN jtf_varchar2_table_100 := NULL,
4488: p_qlpaj_substitution_attribute IN jtf_varchar2_table_100 := NULL,
4489: p_qlpaj_proration_type_code IN jtf_varchar2_table_100 := NULL,
4490: p_qlpaj_include_on_ret_flag IN jtf_varchar2_table_100 := NULL,
4491: p_qlpaj_credit_or_charge_flag IN jtf_varchar2_table_100 := NULL,
4492: p_qlpar_operation_code IN jtf_varchar2_table_100 := NULL,
4493: p_qlpar_adj_relationship_id IN jtf_number_table := NULL,
4494: p_qlpar_creation_date IN jtf_date_table := NULL,

Line 4491: p_qlpaj_credit_or_charge_flag IN jtf_varchar2_table_100 := NULL,

4487: p_qlpaj_price_break_type_code IN jtf_varchar2_table_100 := NULL,
4488: p_qlpaj_substitution_attribute IN jtf_varchar2_table_100 := NULL,
4489: p_qlpaj_proration_type_code IN jtf_varchar2_table_100 := NULL,
4490: p_qlpaj_include_on_ret_flag IN jtf_varchar2_table_100 := NULL,
4491: p_qlpaj_credit_or_charge_flag IN jtf_varchar2_table_100 := NULL,
4492: p_qlpar_operation_code IN jtf_varchar2_table_100 := NULL,
4493: p_qlpar_adj_relationship_id IN jtf_number_table := NULL,
4494: p_qlpar_creation_date IN jtf_date_table := NULL,
4495: p_qlpar_created_by IN jtf_number_table := NULL,

Line 4492: p_qlpar_operation_code IN jtf_varchar2_table_100 := NULL,

4488: p_qlpaj_substitution_attribute IN jtf_varchar2_table_100 := NULL,
4489: p_qlpaj_proration_type_code IN jtf_varchar2_table_100 := NULL,
4490: p_qlpaj_include_on_ret_flag IN jtf_varchar2_table_100 := NULL,
4491: p_qlpaj_credit_or_charge_flag IN jtf_varchar2_table_100 := NULL,
4492: p_qlpar_operation_code IN jtf_varchar2_table_100 := NULL,
4493: p_qlpar_adj_relationship_id IN jtf_number_table := NULL,
4494: p_qlpar_creation_date IN jtf_date_table := NULL,
4495: p_qlpar_created_by IN jtf_number_table := NULL,
4496: p_qlpar_last_update_date IN jtf_date_table := NULL,

Line 4524: p_qlae_attribute_type_code IN jtf_varchar2_table_100 := NULL,

4520: p_qlae_program_update_date IN jtf_date_table := NULL,
4521: p_qlae_quote_header_id IN jtf_number_table := NULL,
4522: p_qlae_quote_line_id IN jtf_number_table := NULL,
4523: p_qlae_quote_shipment_id IN jtf_number_table := NULL,
4524: p_qlae_attribute_type_code IN jtf_varchar2_table_100 := NULL,
4525: p_qlae_name IN jtf_varchar2_table_100 := NULL,
4526: p_qlae_value IN jtf_varchar2_table_2000 := NULL,
4527: p_qlae_value_type IN jtf_varchar2_table_300 := NULL,
4528: p_qlae_status IN jtf_varchar2_table_100 := NULL,

Line 4525: p_qlae_name IN jtf_varchar2_table_100 := NULL,

4521: p_qlae_quote_header_id IN jtf_number_table := NULL,
4522: p_qlae_quote_line_id IN jtf_number_table := NULL,
4523: p_qlae_quote_shipment_id IN jtf_number_table := NULL,
4524: p_qlae_attribute_type_code IN jtf_varchar2_table_100 := NULL,
4525: p_qlae_name IN jtf_varchar2_table_100 := NULL,
4526: p_qlae_value IN jtf_varchar2_table_2000 := NULL,
4527: p_qlae_value_type IN jtf_varchar2_table_300 := NULL,
4528: p_qlae_status IN jtf_varchar2_table_100 := NULL,
4529: p_qlae_application_id IN jtf_number_table := NULL,

Line 4528: p_qlae_status IN jtf_varchar2_table_100 := NULL,

4524: p_qlae_attribute_type_code IN jtf_varchar2_table_100 := NULL,
4525: p_qlae_name IN jtf_varchar2_table_100 := NULL,
4526: p_qlae_value IN jtf_varchar2_table_2000 := NULL,
4527: p_qlae_value_type IN jtf_varchar2_table_300 := NULL,
4528: p_qlae_status IN jtf_varchar2_table_100 := NULL,
4529: p_qlae_application_id IN jtf_number_table := NULL,
4530: p_qlae_start_date_active IN jtf_date_table := NULL,
4531: p_qlae_end_date_active IN jtf_date_table := NULL,
4532: p_qlae_operation_code IN jtf_varchar2_table_100 := NULL,

Line 4532: p_qlae_operation_code IN jtf_varchar2_table_100 := NULL,

4528: p_qlae_status IN jtf_varchar2_table_100 := NULL,
4529: p_qlae_application_id IN jtf_number_table := NULL,
4530: p_qlae_start_date_active IN jtf_date_table := NULL,
4531: p_qlae_end_date_active IN jtf_date_table := NULL,
4532: p_qlae_operation_code IN jtf_varchar2_table_100 := NULL,
4533: p_qfc_operation_code IN jtf_varchar2_table_100 := NULL,
4534: p_qfc_qte_line_index IN jtf_number_table := NULL,
4535: p_qfc_shipment_index IN jtf_number_table := NULL,
4536: p_qfc_freight_charge_id IN jtf_number_table := NULL,

Line 4533: p_qfc_operation_code IN jtf_varchar2_table_100 := NULL,

4529: p_qlae_application_id IN jtf_number_table := NULL,
4530: p_qlae_start_date_active IN jtf_date_table := NULL,
4531: p_qlae_end_date_active IN jtf_date_table := NULL,
4532: p_qlae_operation_code IN jtf_varchar2_table_100 := NULL,
4533: p_qfc_operation_code IN jtf_varchar2_table_100 := NULL,
4534: p_qfc_qte_line_index IN jtf_number_table := NULL,
4535: p_qfc_shipment_index IN jtf_number_table := NULL,
4536: p_qfc_freight_charge_id IN jtf_number_table := NULL,
4537: p_qfc_last_update_date IN jtf_date_table := NULL,

Line 4566: p_qlfc_operation_code IN jtf_varchar2_table_100 := NULL,

4562: p_qfc_attribute12 IN jtf_varchar2_table_200 := NULL,
4563: p_qfc_attribute13 IN jtf_varchar2_table_200 := NULL,
4564: p_qfc_attribute14 IN jtf_varchar2_table_200 := NULL,
4565: p_qfc_attribute15 IN jtf_varchar2_table_200 := NULL,
4566: p_qlfc_operation_code IN jtf_varchar2_table_100 := NULL,
4567: p_qlfc_qte_line_index IN jtf_number_table := NULL,
4568: p_qlfc_shipment_index IN jtf_number_table := NULL,
4569: p_qlfc_freight_charge_id IN jtf_number_table := NULL,
4570: p_qlfc_last_update_date IN jtf_date_table := NULL,

Line 6174: p_ql_line_category_code IN jtf_varchar2_table_100 := NULL,

6170: p_ql_quote_line_id IN jtf_number_table := NULL,
6171: p_ql_quote_header_id IN jtf_number_table := NULL,
6172: p_ql_org_id IN jtf_number_table := NULL,
6173: p_ql_line_number IN jtf_number_table := NULL,
6174: p_ql_line_category_code IN jtf_varchar2_table_100 := NULL,
6175: p_ql_item_type_code IN jtf_varchar2_table_100 := NULL,
6176: p_ql_inventory_item_id IN jtf_number_table := NULL,
6177: p_ql_organization_id IN jtf_number_table := NULL,
6178: p_ql_quantity IN jtf_number_table := NULL,

Line 6175: p_ql_item_type_code IN jtf_varchar2_table_100 := NULL,

6171: p_ql_quote_header_id IN jtf_number_table := NULL,
6172: p_ql_org_id IN jtf_number_table := NULL,
6173: p_ql_line_number IN jtf_number_table := NULL,
6174: p_ql_line_category_code IN jtf_varchar2_table_100 := NULL,
6175: p_ql_item_type_code IN jtf_varchar2_table_100 := NULL,
6176: p_ql_inventory_item_id IN jtf_number_table := NULL,
6177: p_ql_organization_id IN jtf_number_table := NULL,
6178: p_ql_quantity IN jtf_number_table := NULL,
6179: p_ql_uom_code IN jtf_varchar2_table_100 := NULL,

Line 6179: p_ql_uom_code IN jtf_varchar2_table_100 := NULL,

6175: p_ql_item_type_code IN jtf_varchar2_table_100 := NULL,
6176: p_ql_inventory_item_id IN jtf_number_table := NULL,
6177: p_ql_organization_id IN jtf_number_table := NULL,
6178: p_ql_quantity IN jtf_number_table := NULL,
6179: p_ql_uom_code IN jtf_varchar2_table_100 := NULL,
6180: p_ql_start_date_active IN jtf_date_table := NULL,
6181: p_ql_end_date_active IN jtf_date_table := NULL,
6182: p_ql_order_line_type_id IN jtf_number_table := NULL,
6183: p_ql_price_list_id IN jtf_number_table := NULL,

Line 6185: p_ql_currency_code IN jtf_varchar2_table_100 := NULL,

6181: p_ql_end_date_active IN jtf_date_table := NULL,
6182: p_ql_order_line_type_id IN jtf_number_table := NULL,
6183: p_ql_price_list_id IN jtf_number_table := NULL,
6184: p_ql_price_list_line_id IN jtf_number_table := NULL,
6185: p_ql_currency_code IN jtf_varchar2_table_100 := NULL,
6186: p_ql_line_list_price IN jtf_number_table := NULL,
6187: p_ql_line_adjusted_amount IN jtf_number_table := NULL,
6188: p_ql_line_adjusted_percent IN jtf_number_table := NULL,
6189: p_ql_line_quote_price IN jtf_number_table := NULL,

Line 6191: p_ql_item_relationship_type IN jtf_varchar2_table_100 := NULL,

6187: p_ql_line_adjusted_amount IN jtf_number_table := NULL,
6188: p_ql_line_adjusted_percent IN jtf_number_table := NULL,
6189: p_ql_line_quote_price IN jtf_number_table := NULL,
6190: p_ql_related_item_id IN jtf_number_table := NULL,
6191: p_ql_item_relationship_type IN jtf_varchar2_table_100 := NULL,
6192: p_ql_split_shipment_flag IN jtf_varchar2_table_100 := NULL,
6193: p_ql_backorder_flag IN jtf_varchar2_table_100 := NULL,
6194: p_ql_selling_price_change IN jtf_varchar2_table_100 := NULL,
6195: p_ql_recalculate_flag IN jtf_varchar2_table_100 := NULL,

Line 6192: p_ql_split_shipment_flag IN jtf_varchar2_table_100 := NULL,

6188: p_ql_line_adjusted_percent IN jtf_number_table := NULL,
6189: p_ql_line_quote_price IN jtf_number_table := NULL,
6190: p_ql_related_item_id IN jtf_number_table := NULL,
6191: p_ql_item_relationship_type IN jtf_varchar2_table_100 := NULL,
6192: p_ql_split_shipment_flag IN jtf_varchar2_table_100 := NULL,
6193: p_ql_backorder_flag IN jtf_varchar2_table_100 := NULL,
6194: p_ql_selling_price_change IN jtf_varchar2_table_100 := NULL,
6195: p_ql_recalculate_flag IN jtf_varchar2_table_100 := NULL,
6196: p_ql_attribute_category IN jtf_varchar2_table_100 := NULL,

Line 6193: p_ql_backorder_flag IN jtf_varchar2_table_100 := NULL,

6189: p_ql_line_quote_price IN jtf_number_table := NULL,
6190: p_ql_related_item_id IN jtf_number_table := NULL,
6191: p_ql_item_relationship_type IN jtf_varchar2_table_100 := NULL,
6192: p_ql_split_shipment_flag IN jtf_varchar2_table_100 := NULL,
6193: p_ql_backorder_flag IN jtf_varchar2_table_100 := NULL,
6194: p_ql_selling_price_change IN jtf_varchar2_table_100 := NULL,
6195: p_ql_recalculate_flag IN jtf_varchar2_table_100 := NULL,
6196: p_ql_attribute_category IN jtf_varchar2_table_100 := NULL,
6197: p_ql_attribute1 IN jtf_varchar2_table_300 := NULL,

Line 6194: p_ql_selling_price_change IN jtf_varchar2_table_100 := NULL,

6190: p_ql_related_item_id IN jtf_number_table := NULL,
6191: p_ql_item_relationship_type IN jtf_varchar2_table_100 := NULL,
6192: p_ql_split_shipment_flag IN jtf_varchar2_table_100 := NULL,
6193: p_ql_backorder_flag IN jtf_varchar2_table_100 := NULL,
6194: p_ql_selling_price_change IN jtf_varchar2_table_100 := NULL,
6195: p_ql_recalculate_flag IN jtf_varchar2_table_100 := NULL,
6196: p_ql_attribute_category IN jtf_varchar2_table_100 := NULL,
6197: p_ql_attribute1 IN jtf_varchar2_table_300 := NULL,
6198: p_ql_attribute2 IN jtf_varchar2_table_300 := NULL,

Line 6195: p_ql_recalculate_flag IN jtf_varchar2_table_100 := NULL,

6191: p_ql_item_relationship_type IN jtf_varchar2_table_100 := NULL,
6192: p_ql_split_shipment_flag IN jtf_varchar2_table_100 := NULL,
6193: p_ql_backorder_flag IN jtf_varchar2_table_100 := NULL,
6194: p_ql_selling_price_change IN jtf_varchar2_table_100 := NULL,
6195: p_ql_recalculate_flag IN jtf_varchar2_table_100 := NULL,
6196: p_ql_attribute_category IN jtf_varchar2_table_100 := NULL,
6197: p_ql_attribute1 IN jtf_varchar2_table_300 := NULL,
6198: p_ql_attribute2 IN jtf_varchar2_table_300 := NULL,
6199: p_ql_attribute3 IN jtf_varchar2_table_300 := NULL,

Line 6196: p_ql_attribute_category IN jtf_varchar2_table_100 := NULL,

6192: p_ql_split_shipment_flag IN jtf_varchar2_table_100 := NULL,
6193: p_ql_backorder_flag IN jtf_varchar2_table_100 := NULL,
6194: p_ql_selling_price_change IN jtf_varchar2_table_100 := NULL,
6195: p_ql_recalculate_flag IN jtf_varchar2_table_100 := NULL,
6196: p_ql_attribute_category IN jtf_varchar2_table_100 := NULL,
6197: p_ql_attribute1 IN jtf_varchar2_table_300 := NULL,
6198: p_ql_attribute2 IN jtf_varchar2_table_300 := NULL,
6199: p_ql_attribute3 IN jtf_varchar2_table_300 := NULL,
6200: p_ql_attribute4 IN jtf_varchar2_table_300 := NULL,

Line 6224: p_ql_operation_code IN jtf_varchar2_table_100 := NULL,

6220: p_ql_invoice_to_party_site_id IN jtf_number_table := NULL,
6221: p_ql_invoice_to_cust_acct_id IN jtf_number_table := NULL,
6222: p_ql_invoicing_rule_id IN jtf_number_table := NULL,
6223: p_ql_marketing_source_code_id IN jtf_number_table := NULL,
6224: p_ql_operation_code IN jtf_varchar2_table_100 := NULL,
6225: p_ql_commitment_id IN jtf_number_table := NULL,
6226: p_ql_agreement_id IN jtf_number_table := NULL,
6227: p_ql_minisite_id IN jtf_number_table := NULL,
6228: p_ql_section_id IN jtf_number_table := NULL,