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 356: p_operation_code IN jtf_varchar2_table_100 ,

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

Line 476: p_operation_code IN jtf_varchar2_table_100 ,

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

Line 492: p_mod_line_type_code IN jtf_varchar2_table_100 ,

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

Line 493: p_mod_mech_type_code IN jtf_varchar2_table_100 ,

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

Line 497: p_arithmetic_operator IN jtf_varchar2_table_100 ,

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

Line 498: p_automatic_flag IN jtf_varchar2_table_100 ,

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

Line 499: p_update_allowable_flag IN jtf_varchar2_table_100 ,

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

Line 500: p_updated_flag IN jtf_varchar2_table_100 ,

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

Line 501: p_applied_flag IN jtf_varchar2_table_100 ,

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

Line 502: p_on_invoice_flag IN jtf_varchar2_table_100 ,

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

Line 504: p_attribute_category IN jtf_varchar2_table_100 ,

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

Line 520: p_orig_sys_discount_ref IN jtf_varchar2_table_100 ,

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

Line 521: p_change_sequence IN jtf_varchar2_table_100 ,

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

Line 522: p_update_allowed IN jtf_varchar2_table_100 ,

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

Line 523: p_change_reason_code IN jtf_varchar2_table_100 ,

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

Line 526: p_tax_code IN jtf_varchar2_table_100 ,

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

Line 527: p_tax_exempt_flag IN jtf_varchar2_table_100 ,

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

Line 528: p_tax_exempt_number IN jtf_varchar2_table_100 ,

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

Line 529: p_tax_exempt_reason_code IN jtf_varchar2_table_100 ,

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

Line 531: p_invoiced_flag IN jtf_varchar2_table_100 ,

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

Line 532: p_estimated_flag IN jtf_varchar2_table_100 ,

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

Line 533: p_inc_in_sales_perfce IN jtf_varchar2_table_100 ,

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

Line 534: p_split_action_code IN jtf_varchar2_table_100 ,

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

Line 536: p_charge_type_code IN jtf_varchar2_table_100 ,

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

Line 537: p_charge_subtype_code IN jtf_varchar2_table_100 ,

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

Line 541: p_accrual_flag IN jtf_varchar2_table_100 ,

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

Line 543: p_source_system_code IN jtf_varchar2_table_100 ,

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

Line 545: p_benefit_uom_code IN jtf_varchar2_table_100 ,

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

Line 546: p_print_on_invoice_flag IN jtf_varchar2_table_100 ,

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

Line 548: p_rebate_trans_type_code IN jtf_varchar2_table_100 ,

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

Line 549: p_rebate_trans_reference IN jtf_varchar2_table_100 ,

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

Line 550: p_rebate_pay_system_code IN jtf_varchar2_table_100 ,

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

Line 552: p_redeemed_flag IN jtf_varchar2_table_100 ,

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

Line 553: p_modifier_level_code IN jtf_varchar2_table_100 ,

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

Line 554: p_price_break_type_code IN jtf_varchar2_table_100 ,

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

Line 555: p_substitution_attribute IN jtf_varchar2_table_100 ,

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

Line 556: p_proration_type_code IN jtf_varchar2_table_100 ,

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

Line 557: p_include_on_ret_flag IN jtf_varchar2_table_100 ,

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

Line 558: p_credit_or_charge_flag IN jtf_varchar2_table_100

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

Line 775: p_operation_code IN jtf_varchar2_table_100 ,

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

Line 789: p_pricing_context IN jtf_varchar2_table_100 ,

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

Line 790: p_pricing_attribute IN jtf_varchar2_table_100 ,

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

Line 793: p_comparison_operator IN jtf_varchar2_table_100 ,

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

Line 794: p_flex_title IN jtf_varchar2_table_100

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

Line 903: p_attribute_type_code IN jtf_varchar2_table_100 ,

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

Line 904: p_name IN jtf_varchar2_table_100 ,

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

Line 907: p_status IN jtf_varchar2_table_100 ,

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

Line 911: p_operation_code IN jtf_varchar2_table_100

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

Line 1029: p_operation_code IN jtf_varchar2_table_100 ,

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

Line 1180: p_operation_code IN jtf_varchar2_table_100 ,

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

Line 1194: p_flex_title IN jtf_varchar2_table_100 ,

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

Line 1195: p_pricing_context IN jtf_varchar2_table_100 ,

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

Line 1296: p_context IN jtf_varchar2_table_100 ,

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

Line 1755: p_operation_code IN jtf_varchar2_table_100 ,

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

Line 1777: p_ship_method_code IN jtf_varchar2_table_100 ,

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

Line 1778: p_freight_terms_code IN jtf_varchar2_table_100 ,

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

Line 1779: p_freight_carrier_code IN jtf_varchar2_table_100 ,

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

Line 1780: p_fob_code IN jtf_varchar2_table_100 ,

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

Line 1781: p_shipment_priority_code IN jtf_varchar2_table_100 ,

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

Line 1789: p_ship_to_cont_fst_name IN jtf_varchar2_table_100 ,

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

Line 1790: p_ship_to_cont_mid_name IN jtf_varchar2_table_100 ,

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

Line 1791: p_ship_to_cont_lst_name IN jtf_varchar2_table_100 ,

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

Line 1796: p_ship_to_country_code IN jtf_varchar2_table_100 ,

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

Line 1797: p_ship_to_country IN jtf_varchar2_table_100 ,

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

Line 1798: p_ship_to_city IN jtf_varchar2_table_100 ,

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

Line 1799: p_ship_to_postal_code IN jtf_varchar2_table_100 ,

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

Line 1800: p_ship_to_state IN jtf_varchar2_table_100 ,

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

Line 1801: p_ship_to_province IN jtf_varchar2_table_100 ,

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

Line 1802: p_ship_to_county IN jtf_varchar2_table_100 ,

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

Line 1803: p_attribute_category IN jtf_varchar2_table_100 ,

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

Line 2104: p_operation_code IN jtf_varchar2_table_100 ,

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

Line 2121: p_tax_code IN jtf_varchar2_table_100 ,

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

Line 2125: p_tax_exempt_flag IN jtf_varchar2_table_100 ,

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

Line 2126: p_tax_exempt_number IN jtf_varchar2_table_100 ,

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

Line 2127: p_tax_exempt_reason_code IN jtf_varchar2_table_100 ,

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

Line 2128: p_attribute_category IN jtf_varchar2_table_100 ,

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

Line 2776: p_line_category_code IN jtf_varchar2_table_100 ,

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

Line 2777: p_item_type_code IN jtf_varchar2_table_100 ,

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

Line 2781: p_uom_code IN jtf_varchar2_table_100 ,

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

Line 2787: p_currency_code IN jtf_varchar2_table_100 ,

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

Line 2793: p_item_relationship_type IN jtf_varchar2_table_100 ,

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

Line 2794: p_split_shipment_flag IN jtf_varchar2_table_100 ,

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

Line 2795: p_backorder_flag IN jtf_varchar2_table_100 ,

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

Line 2796: p_selling_price_change IN jtf_varchar2_table_100 ,

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

Line 2797: p_recalculate_flag IN jtf_varchar2_table_100 ,

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

Line 2798: p_attribute_category IN jtf_varchar2_table_100 ,

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

Line 2830: p_operation_code IN jtf_varchar2_table_100 ,

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

Line 3164: p_complete_configuration IN jtf_varchar2_table_100 ,

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

Line 3165: p_valid_configuration_flag IN jtf_varchar2_table_100 ,

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

Line 3166: p_component_code IN jtf_varchar2_table_1000 ,

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

Line 3167: p_service_coterminate_flag IN jtf_varchar2_table_100 ,

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

Line 3169: p_service_period IN jtf_varchar2_table_100 ,

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

Line 3174: p_attribute_category IN jtf_varchar2_table_100 ,

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

Line 3190: p_service_ref_type_code IN jtf_varchar2_table_100 ,

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

Line 3198: p_return_ref_type IN jtf_varchar2_table_100 ,

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

Line 3216: p_operation_code IN jtf_varchar2_table_100 ,

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

Line 3218: p_return_attr_category IN jtf_varchar2_table_100 ,

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

Line 3219: p_return_reason_code IN jtf_varchar2_table_100

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

Line 3439: p_relationship_type_code IN jtf_varchar2_table_100 ,

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

Line 3440: p_reciprocal_flag IN jtf_varchar2_table_100 ,

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

Line 3443: p_operation_code IN jtf_varchar2_table_100

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

Line 3683: p_ql_line_category_code IN jtf_varchar2_table_100 := NULL,

3679: p_ql_quote_line_id IN jtf_number_table := NULL,
3680: p_ql_quote_header_id IN jtf_number_table := NULL,
3681: p_ql_org_id IN jtf_number_table := NULL,
3682: p_ql_line_number IN jtf_number_table := NULL,
3683: p_ql_line_category_code IN jtf_varchar2_table_100 := NULL,
3684: p_ql_item_type_code IN jtf_varchar2_table_100 := NULL,
3685: p_ql_inventory_item_id IN jtf_number_table := NULL,
3686: p_ql_organization_id IN jtf_number_table := NULL,
3687: p_ql_quantity IN jtf_number_table := NULL,

Line 3684: p_ql_item_type_code IN jtf_varchar2_table_100 := NULL,

3680: p_ql_quote_header_id IN jtf_number_table := NULL,
3681: p_ql_org_id IN jtf_number_table := NULL,
3682: p_ql_line_number IN jtf_number_table := NULL,
3683: p_ql_line_category_code IN jtf_varchar2_table_100 := NULL,
3684: p_ql_item_type_code IN jtf_varchar2_table_100 := NULL,
3685: p_ql_inventory_item_id IN jtf_number_table := NULL,
3686: p_ql_organization_id IN jtf_number_table := NULL,
3687: p_ql_quantity IN jtf_number_table := NULL,
3688: p_ql_uom_code IN jtf_varchar2_table_100 := NULL,

Line 3688: p_ql_uom_code IN jtf_varchar2_table_100 := NULL,

3684: p_ql_item_type_code IN jtf_varchar2_table_100 := NULL,
3685: p_ql_inventory_item_id IN jtf_number_table := NULL,
3686: p_ql_organization_id IN jtf_number_table := NULL,
3687: p_ql_quantity IN jtf_number_table := NULL,
3688: p_ql_uom_code IN jtf_varchar2_table_100 := NULL,
3689: p_ql_start_date_active IN jtf_date_table := NULL,
3690: p_ql_end_date_active IN jtf_date_table := NULL,
3691: p_ql_order_line_type_id IN jtf_number_table := NULL,
3692: p_ql_price_list_id IN jtf_number_table := NULL,

Line 3694: p_ql_currency_code IN jtf_varchar2_table_100 := NULL,

3690: p_ql_end_date_active IN jtf_date_table := NULL,
3691: p_ql_order_line_type_id IN jtf_number_table := NULL,
3692: p_ql_price_list_id IN jtf_number_table := NULL,
3693: p_ql_price_list_line_id IN jtf_number_table := NULL,
3694: p_ql_currency_code IN jtf_varchar2_table_100 := NULL,
3695: p_ql_line_list_price IN jtf_number_table := NULL,
3696: p_ql_line_adjusted_amount IN jtf_number_table := NULL,
3697: p_ql_line_adjusted_percent IN jtf_number_table := NULL,
3698: p_ql_line_quote_price IN jtf_number_table := NULL,

Line 3700: p_ql_item_relationship_type IN jtf_varchar2_table_100 := NULL,

3696: p_ql_line_adjusted_amount IN jtf_number_table := NULL,
3697: p_ql_line_adjusted_percent IN jtf_number_table := NULL,
3698: p_ql_line_quote_price IN jtf_number_table := NULL,
3699: p_ql_related_item_id IN jtf_number_table := NULL,
3700: p_ql_item_relationship_type IN jtf_varchar2_table_100 := NULL,
3701: p_ql_split_shipment_flag IN jtf_varchar2_table_100 := NULL,
3702: p_ql_backorder_flag IN jtf_varchar2_table_100 := NULL,
3703: p_ql_selling_price_change IN jtf_varchar2_table_100 := NULL,
3704: p_ql_recalculate_flag IN jtf_varchar2_table_100 := NULL,

Line 3701: p_ql_split_shipment_flag IN jtf_varchar2_table_100 := NULL,

3697: p_ql_line_adjusted_percent IN jtf_number_table := NULL,
3698: p_ql_line_quote_price IN jtf_number_table := NULL,
3699: p_ql_related_item_id IN jtf_number_table := NULL,
3700: p_ql_item_relationship_type IN jtf_varchar2_table_100 := NULL,
3701: p_ql_split_shipment_flag IN jtf_varchar2_table_100 := NULL,
3702: p_ql_backorder_flag IN jtf_varchar2_table_100 := NULL,
3703: p_ql_selling_price_change IN jtf_varchar2_table_100 := NULL,
3704: p_ql_recalculate_flag IN jtf_varchar2_table_100 := NULL,
3705: p_ql_attribute_category IN jtf_varchar2_table_100 := NULL,

Line 3702: p_ql_backorder_flag IN jtf_varchar2_table_100 := NULL,

3698: p_ql_line_quote_price IN jtf_number_table := NULL,
3699: p_ql_related_item_id IN jtf_number_table := NULL,
3700: p_ql_item_relationship_type IN jtf_varchar2_table_100 := NULL,
3701: p_ql_split_shipment_flag IN jtf_varchar2_table_100 := NULL,
3702: p_ql_backorder_flag IN jtf_varchar2_table_100 := NULL,
3703: p_ql_selling_price_change IN jtf_varchar2_table_100 := NULL,
3704: p_ql_recalculate_flag IN jtf_varchar2_table_100 := NULL,
3705: p_ql_attribute_category IN jtf_varchar2_table_100 := NULL,
3706: p_ql_attribute1 IN jtf_varchar2_table_300 := NULL,

Line 3703: p_ql_selling_price_change IN jtf_varchar2_table_100 := NULL,

3699: p_ql_related_item_id IN jtf_number_table := NULL,
3700: p_ql_item_relationship_type IN jtf_varchar2_table_100 := NULL,
3701: p_ql_split_shipment_flag IN jtf_varchar2_table_100 := NULL,
3702: p_ql_backorder_flag IN jtf_varchar2_table_100 := NULL,
3703: p_ql_selling_price_change IN jtf_varchar2_table_100 := NULL,
3704: p_ql_recalculate_flag IN jtf_varchar2_table_100 := NULL,
3705: p_ql_attribute_category IN jtf_varchar2_table_100 := NULL,
3706: p_ql_attribute1 IN jtf_varchar2_table_300 := NULL,
3707: p_ql_attribute2 IN jtf_varchar2_table_300 := NULL,

Line 3704: p_ql_recalculate_flag IN jtf_varchar2_table_100 := NULL,

3700: p_ql_item_relationship_type IN jtf_varchar2_table_100 := NULL,
3701: p_ql_split_shipment_flag IN jtf_varchar2_table_100 := NULL,
3702: p_ql_backorder_flag IN jtf_varchar2_table_100 := NULL,
3703: p_ql_selling_price_change IN jtf_varchar2_table_100 := NULL,
3704: p_ql_recalculate_flag IN jtf_varchar2_table_100 := NULL,
3705: p_ql_attribute_category IN jtf_varchar2_table_100 := NULL,
3706: p_ql_attribute1 IN jtf_varchar2_table_300 := NULL,
3707: p_ql_attribute2 IN jtf_varchar2_table_300 := NULL,
3708: p_ql_attribute3 IN jtf_varchar2_table_300 := NULL,

Line 3705: p_ql_attribute_category IN jtf_varchar2_table_100 := NULL,

3701: p_ql_split_shipment_flag IN jtf_varchar2_table_100 := NULL,
3702: p_ql_backorder_flag IN jtf_varchar2_table_100 := NULL,
3703: p_ql_selling_price_change IN jtf_varchar2_table_100 := NULL,
3704: p_ql_recalculate_flag IN jtf_varchar2_table_100 := NULL,
3705: p_ql_attribute_category IN jtf_varchar2_table_100 := NULL,
3706: p_ql_attribute1 IN jtf_varchar2_table_300 := NULL,
3707: p_ql_attribute2 IN jtf_varchar2_table_300 := NULL,
3708: p_ql_attribute3 IN jtf_varchar2_table_300 := NULL,
3709: p_ql_attribute4 IN jtf_varchar2_table_300 := NULL,

Line 3733: p_ql_operation_code IN jtf_varchar2_table_100 := NULL,

3729: p_ql_invoice_to_party_site_id IN jtf_number_table := NULL,
3730: p_ql_invoice_to_cust_acct_id IN jtf_number_table := NULL,
3731: p_ql_invoicing_rule_id IN jtf_number_table := NULL,
3732: p_ql_marketing_source_code_id IN jtf_number_table := NULL,
3733: p_ql_operation_code IN jtf_varchar2_table_100 := NULL,
3734: p_ql_commitment_id IN jtf_number_table := NULL,
3735: p_ql_agreement_id IN jtf_number_table := NULL,
3736: p_ql_minisite_id IN jtf_number_table := NULL,
3737: p_ql_section_id IN jtf_number_table := NULL,

Line 3755: p_qrl_relationship_type_code IN jtf_varchar2_table_100 := NULL,

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

Line 3756: p_qrl_reciprocal_flag IN jtf_varchar2_table_100 := NULL,

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

Line 3759: p_qrl_operation_code IN JTF_VARCHAR2_TABLE_100 := null,

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

Line 3774: p_qdl_complete_configuration IN jtf_varchar2_table_100 := NULL,

3770: p_qdl_quote_line_id IN jtf_number_table := NULL,
3771: p_qdl_config_header_id IN jtf_number_table := NULL,
3772: p_qdl_config_revision_num IN jtf_number_table := NULL,
3773: p_qdl_config_item_id IN jtf_number_table := NULL,
3774: p_qdl_complete_configuration IN jtf_varchar2_table_100 := NULL,
3775: p_qdl_valid_configuration_flag IN jtf_varchar2_table_100 := NULL,
3776: p_qdl_component_code IN jtf_varchar2_table_1000 := NULL,
3777: p_qdl_service_coterminate_flag IN jtf_varchar2_table_100 := NULL,
3778: p_qdl_service_duration IN jtf_number_table := NULL,

Line 3775: p_qdl_valid_configuration_flag IN jtf_varchar2_table_100 := NULL,

3771: p_qdl_config_header_id IN jtf_number_table := NULL,
3772: p_qdl_config_revision_num IN jtf_number_table := NULL,
3773: p_qdl_config_item_id IN jtf_number_table := NULL,
3774: p_qdl_complete_configuration IN jtf_varchar2_table_100 := NULL,
3775: p_qdl_valid_configuration_flag IN jtf_varchar2_table_100 := NULL,
3776: p_qdl_component_code IN jtf_varchar2_table_1000 := NULL,
3777: p_qdl_service_coterminate_flag IN jtf_varchar2_table_100 := NULL,
3778: p_qdl_service_duration IN jtf_number_table := NULL,
3779: p_qdl_service_period IN jtf_varchar2_table_100 := NULL,

Line 3776: p_qdl_component_code IN jtf_varchar2_table_1000 := NULL,

3772: p_qdl_config_revision_num IN jtf_number_table := NULL,
3773: p_qdl_config_item_id IN jtf_number_table := NULL,
3774: p_qdl_complete_configuration IN jtf_varchar2_table_100 := NULL,
3775: p_qdl_valid_configuration_flag IN jtf_varchar2_table_100 := NULL,
3776: p_qdl_component_code IN jtf_varchar2_table_1000 := NULL,
3777: p_qdl_service_coterminate_flag IN jtf_varchar2_table_100 := NULL,
3778: p_qdl_service_duration IN jtf_number_table := NULL,
3779: p_qdl_service_period IN jtf_varchar2_table_100 := NULL,
3780: p_qdl_service_unit_selling IN jtf_number_table := NULL,

Line 3777: p_qdl_service_coterminate_flag IN jtf_varchar2_table_100 := NULL,

3773: p_qdl_config_item_id IN jtf_number_table := NULL,
3774: p_qdl_complete_configuration IN jtf_varchar2_table_100 := NULL,
3775: p_qdl_valid_configuration_flag IN jtf_varchar2_table_100 := NULL,
3776: p_qdl_component_code IN jtf_varchar2_table_1000 := NULL,
3777: p_qdl_service_coterminate_flag IN jtf_varchar2_table_100 := NULL,
3778: p_qdl_service_duration IN jtf_number_table := NULL,
3779: p_qdl_service_period IN jtf_varchar2_table_100 := NULL,
3780: p_qdl_service_unit_selling IN jtf_number_table := NULL,
3781: p_qdl_service_unit_list IN jtf_number_table := NULL,

Line 3779: p_qdl_service_period IN jtf_varchar2_table_100 := NULL,

3775: p_qdl_valid_configuration_flag IN jtf_varchar2_table_100 := NULL,
3776: p_qdl_component_code IN jtf_varchar2_table_1000 := NULL,
3777: p_qdl_service_coterminate_flag IN jtf_varchar2_table_100 := NULL,
3778: p_qdl_service_duration IN jtf_number_table := NULL,
3779: p_qdl_service_period IN jtf_varchar2_table_100 := NULL,
3780: p_qdl_service_unit_selling IN jtf_number_table := NULL,
3781: p_qdl_service_unit_list IN jtf_number_table := NULL,
3782: p_qdl_service_number IN jtf_number_table := NULL,
3783: p_qdl_unit_percent_base_price IN jtf_number_table := NULL,

Line 3784: p_qdl_attribute_category IN jtf_varchar2_table_100 := NULL,

3780: p_qdl_service_unit_selling IN jtf_number_table := NULL,
3781: p_qdl_service_unit_list IN jtf_number_table := NULL,
3782: p_qdl_service_number IN jtf_number_table := NULL,
3783: p_qdl_unit_percent_base_price IN jtf_number_table := NULL,
3784: p_qdl_attribute_category IN jtf_varchar2_table_100 := NULL,
3785: p_qdl_attribute1 IN jtf_varchar2_table_200 := NULL,
3786: p_qdl_attribute2 IN jtf_varchar2_table_200 := NULL,
3787: p_qdl_attribute3 IN jtf_varchar2_table_200 := NULL,
3788: p_qdl_attribute4 IN jtf_varchar2_table_200 := NULL,

Line 3800: p_qdl_service_ref_type_code IN jtf_varchar2_table_100 := NULL,

3796: p_qdl_attribute12 IN jtf_varchar2_table_200 := NULL,
3797: p_qdl_attribute13 IN jtf_varchar2_table_200 := NULL,
3798: p_qdl_attribute14 IN jtf_varchar2_table_200 := NULL,
3799: p_qdl_attribute15 IN jtf_varchar2_table_200 := NULL,
3800: p_qdl_service_ref_type_code IN jtf_varchar2_table_100 := NULL,
3801: p_qdl_service_ref_order_number IN jtf_number_table := NULL,
3802: p_qdl_service_ref_line_number IN jtf_number_table := NULL,
3803: p_qdl_service_ref_qte_line_ind IN jtf_number_table := NULL,
3804: p_qdl_service_ref_line_id IN jtf_number_table := NULL,

Line 3808: p_qdl_return_ref_type IN jtf_varchar2_table_100 := NULL,

3804: p_qdl_service_ref_line_id IN jtf_number_table := NULL,
3805: p_qdl_service_ref_system_id IN jtf_number_table := NULL,
3806: p_qdl_service_ref_option_numb IN jtf_number_table := NULL,
3807: p_qdl_service_ref_shipment IN jtf_number_table := NULL,
3808: p_qdl_return_ref_type IN jtf_varchar2_table_100 := NULL,
3809: p_qdl_return_ref_header_id IN jtf_number_table := NULL,
3810: p_qdl_return_ref_line_id IN jtf_number_table := NULL,
3811: p_qdl_return_attribute1 IN jtf_varchar2_table_300 := NULL,
3812: p_qdl_return_attribute2 IN jtf_varchar2_table_300 := NULL,

Line 3826: p_qdl_operation_code IN jtf_varchar2_table_100 := NULL,

3822: p_qdl_return_attribute12 IN jtf_varchar2_table_300 := NULL,
3823: p_qdl_return_attribute13 IN jtf_varchar2_table_300 := NULL,
3824: p_qdl_return_attribute14 IN jtf_varchar2_table_300 := NULL,
3825: p_qdl_return_attribute15 IN jtf_varchar2_table_300 := NULL,
3826: p_qdl_operation_code IN jtf_varchar2_table_100 := NULL,
3827: p_qdl_qte_line_index IN jtf_number_table := NULL,
3828: p_qdl_return_attr_category IN jtf_varchar2_table_100 := NULL,
3829: p_qdl_return_reason_code IN jtf_varchar2_table_100 := NULL,
3830: p_qpa_operation_code IN jtf_varchar2_table_100 := NULL,

Line 3828: p_qdl_return_attr_category IN jtf_varchar2_table_100 := NULL,

3824: p_qdl_return_attribute14 IN jtf_varchar2_table_300 := NULL,
3825: p_qdl_return_attribute15 IN jtf_varchar2_table_300 := NULL,
3826: p_qdl_operation_code IN jtf_varchar2_table_100 := NULL,
3827: p_qdl_qte_line_index IN jtf_number_table := NULL,
3828: p_qdl_return_attr_category IN jtf_varchar2_table_100 := NULL,
3829: p_qdl_return_reason_code IN jtf_varchar2_table_100 := NULL,
3830: p_qpa_operation_code IN jtf_varchar2_table_100 := NULL,
3831: p_qpa_qte_line_index IN jtf_number_table := NULL,
3832: p_qpa_price_attribute_id IN jtf_number_table := NULL,

Line 3829: p_qdl_return_reason_code IN jtf_varchar2_table_100 := NULL,

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

Line 3830: p_qpa_operation_code IN jtf_varchar2_table_100 := NULL,

3826: p_qdl_operation_code IN jtf_varchar2_table_100 := NULL,
3827: p_qdl_qte_line_index IN jtf_number_table := NULL,
3828: p_qdl_return_attr_category IN jtf_varchar2_table_100 := NULL,
3829: p_qdl_return_reason_code IN jtf_varchar2_table_100 := NULL,
3830: p_qpa_operation_code IN jtf_varchar2_table_100 := NULL,
3831: p_qpa_qte_line_index IN jtf_number_table := NULL,
3832: p_qpa_price_attribute_id IN jtf_number_table := NULL,
3833: p_qpa_creation_date IN jtf_date_table := NULL,
3834: p_qpa_created_by IN jtf_number_table := NULL,

Line 3844: p_qpa_flex_title IN jtf_varchar2_table_100 := NULL,

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

Line 3845: p_qpa_pricing_context IN jtf_varchar2_table_100 := NULL,

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

Line 3946: p_qpa_context IN jtf_varchar2_table_100 := NULL,

3942: p_qpa_pricing_attribute97 IN jtf_varchar2_table_300 := NULL,
3943: p_qpa_pricing_attribute98 IN jtf_varchar2_table_300 := NULL,
3944: p_qpa_pricing_attribute99 IN jtf_varchar2_table_300 := NULL,
3945: p_qpa_pricing_attribute100 IN jtf_varchar2_table_300 := NULL,
3946: p_qpa_context IN jtf_varchar2_table_100 := NULL,
3947: p_qpa_attribute1 IN jtf_varchar2_table_300 := NULL,
3948: p_qpa_attribute2 IN jtf_varchar2_table_300 := NULL,
3949: p_qpa_attribute3 IN jtf_varchar2_table_300 := NULL,
3950: p_qpa_attribute4 IN jtf_varchar2_table_300 := NULL,

Line 3962: p_qp_operation_code IN jtf_varchar2_table_100 := NULL,

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

Line 3976: p_qp_payment_type_code IN jtf_varchar2_table_100 := NULL,

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

Line 3980: p_qp_credit_card_code IN jtf_varchar2_table_100 := NULL,

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

Line 3981: p_qp_credit_card_holder_name IN jtf_varchar2_table_100 := NULL,

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

Line 3983: p_qp_credit_card_approval_code IN jtf_varchar2_table_100 := NULL,

3979: p_qp_payment_term_id IN jtf_number_table := NULL,
3980: p_qp_credit_card_code IN jtf_varchar2_table_100 := NULL,
3981: p_qp_credit_card_holder_name IN jtf_varchar2_table_100 := NULL,
3982: p_qp_credit_card_exp_date IN jtf_date_table := NULL,
3983: p_qp_credit_card_approval_code IN jtf_varchar2_table_100 := NULL,
3984: p_qp_credit_card_approval_date IN jtf_date_table := NULL,
3985: p_qp_payment_amount IN jtf_number_table := NULL,
3986: p_qp_cust_po_number IN jtf_varchar2_table_100 := NULL,
3987: p_qp_attribute_category IN jtf_varchar2_table_100 := NULL,

Line 3986: p_qp_cust_po_number IN jtf_varchar2_table_100 := NULL,

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

Line 3987: p_qp_attribute_category IN jtf_varchar2_table_100 := NULL,

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

Line 4005: p_qs_operation_code IN jtf_varchar2_table_100 := NULL,

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

Line 4027: p_qs_ship_method_code IN jtf_varchar2_table_100 := NULL,

4023: p_qs_ship_to_party_id IN jtf_number_table := NULL,
4024: p_qs_ship_to_cust_acct_id IN jtf_number_table := NULL,
4025: p_qs_ship_partial_flag IN jtf_varchar2_table_300 := NULL,
4026: p_qs_ship_set_id IN jtf_number_table := NULL,
4027: p_qs_ship_method_code IN jtf_varchar2_table_100 := NULL,
4028: p_qs_freight_terms_code IN jtf_varchar2_table_100 := NULL,
4029: p_qs_freight_carrier_code IN jtf_varchar2_table_100 := NULL,
4030: p_qs_fob_code IN jtf_varchar2_table_100 := NULL,
4031: p_qs_shipment_priority_code IN jtf_varchar2_table_100 := NULL,

Line 4028: p_qs_freight_terms_code IN jtf_varchar2_table_100 := NULL,

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

Line 4029: p_qs_freight_carrier_code IN jtf_varchar2_table_100 := NULL,

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

Line 4030: p_qs_fob_code IN jtf_varchar2_table_100 := NULL,

4026: p_qs_ship_set_id IN jtf_number_table := NULL,
4027: p_qs_ship_method_code IN jtf_varchar2_table_100 := NULL,
4028: p_qs_freight_terms_code IN jtf_varchar2_table_100 := NULL,
4029: p_qs_freight_carrier_code IN jtf_varchar2_table_100 := NULL,
4030: p_qs_fob_code IN jtf_varchar2_table_100 := NULL,
4031: p_qs_shipment_priority_code IN jtf_varchar2_table_100 := NULL,
4032: p_qs_shipping_instructions IN jtf_varchar2_table_2000 := NULL,
4033: p_qs_packing_instructions IN jtf_varchar2_table_2000 := NULL,
4034: p_qs_quantity IN jtf_number_table := NULL,

Line 4031: p_qs_shipment_priority_code IN jtf_varchar2_table_100 := NULL,

4027: p_qs_ship_method_code IN jtf_varchar2_table_100 := NULL,
4028: p_qs_freight_terms_code IN jtf_varchar2_table_100 := NULL,
4029: p_qs_freight_carrier_code IN jtf_varchar2_table_100 := NULL,
4030: p_qs_fob_code IN jtf_varchar2_table_100 := NULL,
4031: p_qs_shipment_priority_code IN jtf_varchar2_table_100 := NULL,
4032: p_qs_shipping_instructions IN jtf_varchar2_table_2000 := NULL,
4033: p_qs_packing_instructions IN jtf_varchar2_table_2000 := NULL,
4034: p_qs_quantity IN jtf_number_table := NULL,
4035: p_qs_reserved_quantity IN jtf_number_table := NULL,

Line 4039: p_qs_ship_to_cont_fst_name IN jtf_varchar2_table_100 := NULL,

4035: p_qs_reserved_quantity IN jtf_number_table := NULL,
4036: p_qs_reservation_id IN jtf_number_table := NULL,
4037: p_qs_order_line_id IN jtf_number_table := NULL,
4038: p_qs_ship_to_party_name IN jtf_varchar2_table_300 := NULL,
4039: p_qs_ship_to_cont_fst_name IN jtf_varchar2_table_100 := NULL,
4040: p_qs_ship_to_cont_mid_name IN jtf_varchar2_table_100 := NULL,
4041: p_qs_ship_to_cont_lst_name IN jtf_varchar2_table_100 := NULL,
4042: p_qs_ship_to_address1 IN jtf_varchar2_table_300 := NULL,
4043: p_qs_ship_to_address2 IN jtf_varchar2_table_300 := NULL,

Line 4040: p_qs_ship_to_cont_mid_name IN jtf_varchar2_table_100 := NULL,

4036: p_qs_reservation_id IN jtf_number_table := NULL,
4037: p_qs_order_line_id IN jtf_number_table := NULL,
4038: p_qs_ship_to_party_name IN jtf_varchar2_table_300 := NULL,
4039: p_qs_ship_to_cont_fst_name IN jtf_varchar2_table_100 := NULL,
4040: p_qs_ship_to_cont_mid_name IN jtf_varchar2_table_100 := NULL,
4041: p_qs_ship_to_cont_lst_name IN jtf_varchar2_table_100 := NULL,
4042: p_qs_ship_to_address1 IN jtf_varchar2_table_300 := NULL,
4043: p_qs_ship_to_address2 IN jtf_varchar2_table_300 := NULL,
4044: p_qs_ship_to_address3 IN jtf_varchar2_table_300 := NULL,

Line 4041: p_qs_ship_to_cont_lst_name IN jtf_varchar2_table_100 := NULL,

4037: p_qs_order_line_id IN jtf_number_table := NULL,
4038: p_qs_ship_to_party_name IN jtf_varchar2_table_300 := NULL,
4039: p_qs_ship_to_cont_fst_name IN jtf_varchar2_table_100 := NULL,
4040: p_qs_ship_to_cont_mid_name IN jtf_varchar2_table_100 := NULL,
4041: p_qs_ship_to_cont_lst_name IN jtf_varchar2_table_100 := NULL,
4042: p_qs_ship_to_address1 IN jtf_varchar2_table_300 := NULL,
4043: p_qs_ship_to_address2 IN jtf_varchar2_table_300 := NULL,
4044: p_qs_ship_to_address3 IN jtf_varchar2_table_300 := NULL,
4045: p_qs_ship_to_address4 IN jtf_varchar2_table_300 := NULL,

Line 4046: p_qs_ship_to_country_code IN jtf_varchar2_table_100 := NULL,

4042: p_qs_ship_to_address1 IN jtf_varchar2_table_300 := NULL,
4043: p_qs_ship_to_address2 IN jtf_varchar2_table_300 := NULL,
4044: p_qs_ship_to_address3 IN jtf_varchar2_table_300 := NULL,
4045: p_qs_ship_to_address4 IN jtf_varchar2_table_300 := NULL,
4046: p_qs_ship_to_country_code IN jtf_varchar2_table_100 := NULL,
4047: p_qs_ship_to_country IN jtf_varchar2_table_100 := NULL,
4048: p_qs_ship_to_city IN jtf_varchar2_table_100 := NULL,
4049: p_qs_ship_to_postal_code IN jtf_varchar2_table_100 := NULL,
4050: p_qs_ship_to_state IN jtf_varchar2_table_100 := NULL,

Line 4047: p_qs_ship_to_country IN jtf_varchar2_table_100 := NULL,

4043: p_qs_ship_to_address2 IN jtf_varchar2_table_300 := NULL,
4044: p_qs_ship_to_address3 IN jtf_varchar2_table_300 := NULL,
4045: p_qs_ship_to_address4 IN jtf_varchar2_table_300 := NULL,
4046: p_qs_ship_to_country_code IN jtf_varchar2_table_100 := NULL,
4047: p_qs_ship_to_country IN jtf_varchar2_table_100 := NULL,
4048: p_qs_ship_to_city IN jtf_varchar2_table_100 := NULL,
4049: p_qs_ship_to_postal_code IN jtf_varchar2_table_100 := NULL,
4050: p_qs_ship_to_state IN jtf_varchar2_table_100 := NULL,
4051: p_qs_ship_to_province IN jtf_varchar2_table_100 := NULL,

Line 4048: p_qs_ship_to_city IN jtf_varchar2_table_100 := NULL,

4044: p_qs_ship_to_address3 IN jtf_varchar2_table_300 := NULL,
4045: p_qs_ship_to_address4 IN jtf_varchar2_table_300 := NULL,
4046: p_qs_ship_to_country_code IN jtf_varchar2_table_100 := NULL,
4047: p_qs_ship_to_country IN jtf_varchar2_table_100 := NULL,
4048: p_qs_ship_to_city IN jtf_varchar2_table_100 := NULL,
4049: p_qs_ship_to_postal_code IN jtf_varchar2_table_100 := NULL,
4050: p_qs_ship_to_state IN jtf_varchar2_table_100 := NULL,
4051: p_qs_ship_to_province IN jtf_varchar2_table_100 := NULL,
4052: p_qs_ship_to_county IN jtf_varchar2_table_100 := NULL,

Line 4049: p_qs_ship_to_postal_code IN jtf_varchar2_table_100 := NULL,

4045: p_qs_ship_to_address4 IN jtf_varchar2_table_300 := NULL,
4046: p_qs_ship_to_country_code IN jtf_varchar2_table_100 := NULL,
4047: p_qs_ship_to_country IN jtf_varchar2_table_100 := NULL,
4048: p_qs_ship_to_city IN jtf_varchar2_table_100 := NULL,
4049: p_qs_ship_to_postal_code IN jtf_varchar2_table_100 := NULL,
4050: p_qs_ship_to_state IN jtf_varchar2_table_100 := NULL,
4051: p_qs_ship_to_province IN jtf_varchar2_table_100 := NULL,
4052: p_qs_ship_to_county IN jtf_varchar2_table_100 := NULL,
4053: p_qs_attribute_category IN jtf_varchar2_table_100 := NULL,

Line 4050: p_qs_ship_to_state IN jtf_varchar2_table_100 := NULL,

4046: p_qs_ship_to_country_code IN jtf_varchar2_table_100 := NULL,
4047: p_qs_ship_to_country IN jtf_varchar2_table_100 := NULL,
4048: p_qs_ship_to_city IN jtf_varchar2_table_100 := NULL,
4049: p_qs_ship_to_postal_code IN jtf_varchar2_table_100 := NULL,
4050: p_qs_ship_to_state IN jtf_varchar2_table_100 := NULL,
4051: p_qs_ship_to_province IN jtf_varchar2_table_100 := NULL,
4052: p_qs_ship_to_county IN jtf_varchar2_table_100 := NULL,
4053: p_qs_attribute_category IN jtf_varchar2_table_100 := NULL,
4054: p_qs_attribute1 IN jtf_varchar2_table_200 := NULL,

Line 4051: p_qs_ship_to_province IN jtf_varchar2_table_100 := NULL,

4047: p_qs_ship_to_country IN jtf_varchar2_table_100 := NULL,
4048: p_qs_ship_to_city IN jtf_varchar2_table_100 := NULL,
4049: p_qs_ship_to_postal_code IN jtf_varchar2_table_100 := NULL,
4050: p_qs_ship_to_state IN jtf_varchar2_table_100 := NULL,
4051: p_qs_ship_to_province IN jtf_varchar2_table_100 := NULL,
4052: p_qs_ship_to_county IN jtf_varchar2_table_100 := NULL,
4053: p_qs_attribute_category IN jtf_varchar2_table_100 := NULL,
4054: p_qs_attribute1 IN jtf_varchar2_table_200 := NULL,
4055: p_qs_attribute2 IN jtf_varchar2_table_200 := NULL,

Line 4052: p_qs_ship_to_county IN jtf_varchar2_table_100 := NULL,

4048: p_qs_ship_to_city IN jtf_varchar2_table_100 := NULL,
4049: p_qs_ship_to_postal_code IN jtf_varchar2_table_100 := NULL,
4050: p_qs_ship_to_state IN jtf_varchar2_table_100 := NULL,
4051: p_qs_ship_to_province IN jtf_varchar2_table_100 := NULL,
4052: p_qs_ship_to_county IN jtf_varchar2_table_100 := NULL,
4053: p_qs_attribute_category IN jtf_varchar2_table_100 := NULL,
4054: p_qs_attribute1 IN jtf_varchar2_table_200 := NULL,
4055: p_qs_attribute2 IN jtf_varchar2_table_200 := NULL,
4056: p_qs_attribute3 IN jtf_varchar2_table_200 := NULL,

Line 4053: p_qs_attribute_category IN jtf_varchar2_table_100 := NULL,

4049: p_qs_ship_to_postal_code IN jtf_varchar2_table_100 := NULL,
4050: p_qs_ship_to_state IN jtf_varchar2_table_100 := NULL,
4051: p_qs_ship_to_province IN jtf_varchar2_table_100 := NULL,
4052: p_qs_ship_to_county IN jtf_varchar2_table_100 := NULL,
4053: p_qs_attribute_category IN jtf_varchar2_table_100 := NULL,
4054: p_qs_attribute1 IN jtf_varchar2_table_200 := NULL,
4055: p_qs_attribute2 IN jtf_varchar2_table_200 := NULL,
4056: p_qs_attribute3 IN jtf_varchar2_table_200 := NULL,
4057: p_qs_attribute4 IN jtf_varchar2_table_200 := NULL,

Line 4069: p_qt_operation_code IN jtf_varchar2_table_100 := NULL,

4065: p_qs_attribute12 IN jtf_varchar2_table_200 := NULL,
4066: p_qs_attribute13 IN jtf_varchar2_table_200 := NULL,
4067: p_qs_attribute14 IN jtf_varchar2_table_200 := NULL,
4068: p_qs_attribute15 IN jtf_varchar2_table_200 := NULL,
4069: p_qt_operation_code IN jtf_varchar2_table_100 := NULL,
4070: p_qt_qte_line_index IN jtf_number_table := NULL,
4071: p_qt_shipment_index IN jtf_number_table := NULL,
4072: p_qt_tax_detail_id IN jtf_number_table := NULL,
4073: p_qt_quote_header_id IN jtf_number_table := NULL,

Line 4086: p_qt_tax_code IN jtf_varchar2_table_100 := NULL,

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

Line 4090: p_qt_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,

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

Line 4091: p_qt_tax_exempt_number IN jtf_varchar2_table_100 := NULL,

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

Line 4092: p_qt_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,

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

Line 4093: p_qt_attribute_category IN jtf_varchar2_table_100 := NULL,

4089: p_qt_tax_amount IN jtf_number_table := NULL,
4090: p_qt_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,
4091: p_qt_tax_exempt_number IN jtf_varchar2_table_100 := NULL,
4092: p_qt_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,
4093: p_qt_attribute_category IN jtf_varchar2_table_100 := NULL,
4094: p_qt_attribute1 IN jtf_varchar2_table_200 := NULL,
4095: p_qt_attribute2 IN jtf_varchar2_table_200 := NULL,
4096: p_qt_attribute3 IN jtf_varchar2_table_200 := NULL,
4097: p_qt_attribute4 IN jtf_varchar2_table_200 := NULL,

Line 4109: p_qlpa_operation_code IN jtf_varchar2_table_100 := NULL,

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

Line 4123: p_qlpa_flex_title IN jtf_varchar2_table_100 := NULL,

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

Line 4124: p_qlpa_pricing_context IN jtf_varchar2_table_100 := NULL,

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

Line 4225: p_qlpa_context IN jtf_varchar2_table_100 := NULL,

4221: p_qlpa_pricing_attribute97 IN jtf_varchar2_table_300 := NULL,
4222: p_qlpa_pricing_attribute98 IN jtf_varchar2_table_300 := NULL,
4223: p_qlpa_pricing_attribute99 IN jtf_varchar2_table_300 := NULL,
4224: p_qlpa_pricing_attribute100 IN jtf_varchar2_table_300 := NULL,
4225: p_qlpa_context IN jtf_varchar2_table_100 := NULL,
4226: p_qlpa_attribute1 IN jtf_varchar2_table_300 := NULL,
4227: p_qlpa_attribute2 IN jtf_varchar2_table_300 := NULL,
4228: p_qlpa_attribute3 IN jtf_varchar2_table_300 := NULL,
4229: p_qlpa_attribute4 IN jtf_varchar2_table_300 := NULL,

Line 4241: p_qlp_operation_code IN jtf_varchar2_table_100 := NULL,

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

Line 4255: p_qlp_payment_type_code IN jtf_varchar2_table_100 := NULL,

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

Line 4259: p_qlp_credit_card_code IN jtf_varchar2_table_100 := NULL,

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

Line 4260: p_qlp_credit_card_holder_name IN jtf_varchar2_table_100 := NULL,

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

Line 4262: p_qlp_credit_card_aprv_code IN jtf_varchar2_table_100 := NULL,

4258: p_qlp_payment_term_id IN jtf_number_table := NULL,
4259: p_qlp_credit_card_code IN jtf_varchar2_table_100 := NULL,
4260: p_qlp_credit_card_holder_name IN jtf_varchar2_table_100 := NULL,
4261: p_qlp_credit_card_exp_date IN jtf_date_table := NULL,
4262: p_qlp_credit_card_aprv_code IN jtf_varchar2_table_100 := NULL,
4263: p_qlp_credit_card_aprv_date IN jtf_date_table := NULL,
4264: p_qlp_payment_amount IN jtf_number_table := NULL,
4265: p_qlp_cust_po_number IN jtf_varchar2_table_100 := NULL,
4266: p_qlp_attribute_category IN jtf_varchar2_table_100 := NULL,

Line 4265: p_qlp_cust_po_number IN jtf_varchar2_table_100 := NULL,

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

Line 4266: p_qlp_attribute_category IN jtf_varchar2_table_100 := NULL,

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

Line 4282: p_qls_operation_code IN jtf_varchar2_table_100 := NULL,

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

Line 4304: p_qls_ship_method_code IN jtf_varchar2_table_100 := NULL,

4300: p_qls_ship_to_party_id IN jtf_number_table := NULL,
4301: p_qls_ship_to_cust_acct_id IN jtf_number_table := NULL,
4302: p_qls_ship_partial_flag IN jtf_varchar2_table_300 := NULL,
4303: p_qls_ship_set_id IN jtf_number_table := NULL,
4304: p_qls_ship_method_code IN jtf_varchar2_table_100 := NULL,
4305: p_qls_freight_terms_code IN jtf_varchar2_table_100 := NULL,
4306: p_qls_freight_carrier_code IN jtf_varchar2_table_100 := NULL,
4307: p_qls_fob_code IN jtf_varchar2_table_100 := NULL,
4308: p_qls_shipment_priority_code IN jtf_varchar2_table_100 := NULL,

Line 4305: p_qls_freight_terms_code IN jtf_varchar2_table_100 := NULL,

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

Line 4306: p_qls_freight_carrier_code IN jtf_varchar2_table_100 := NULL,

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

Line 4307: p_qls_fob_code IN jtf_varchar2_table_100 := NULL,

4303: p_qls_ship_set_id IN jtf_number_table := NULL,
4304: p_qls_ship_method_code IN jtf_varchar2_table_100 := NULL,
4305: p_qls_freight_terms_code IN jtf_varchar2_table_100 := NULL,
4306: p_qls_freight_carrier_code IN jtf_varchar2_table_100 := NULL,
4307: p_qls_fob_code IN jtf_varchar2_table_100 := NULL,
4308: p_qls_shipment_priority_code IN jtf_varchar2_table_100 := NULL,
4309: p_qls_shipping_instructions IN jtf_varchar2_table_2000 := NULL,
4310: p_qls_packing_instructions IN jtf_varchar2_table_2000 := NULL,
4311: p_qls_quantity IN jtf_number_table := NULL,

Line 4308: p_qls_shipment_priority_code IN jtf_varchar2_table_100 := NULL,

4304: p_qls_ship_method_code IN jtf_varchar2_table_100 := NULL,
4305: p_qls_freight_terms_code IN jtf_varchar2_table_100 := NULL,
4306: p_qls_freight_carrier_code IN jtf_varchar2_table_100 := NULL,
4307: p_qls_fob_code IN jtf_varchar2_table_100 := NULL,
4308: p_qls_shipment_priority_code IN jtf_varchar2_table_100 := NULL,
4309: p_qls_shipping_instructions IN jtf_varchar2_table_2000 := NULL,
4310: p_qls_packing_instructions IN jtf_varchar2_table_2000 := NULL,
4311: p_qls_quantity IN jtf_number_table := NULL,
4312: p_qls_reserved_quantity IN jtf_number_table := NULL,

Line 4316: p_qls_ship_to_cont_fst_name IN jtf_varchar2_table_100 := NULL,

4312: p_qls_reserved_quantity IN jtf_number_table := NULL,
4313: p_qls_reservation_id IN jtf_number_table := NULL,
4314: p_qls_order_line_id IN jtf_number_table := NULL,
4315: p_qls_ship_to_party_name IN jtf_varchar2_table_300 := NULL,
4316: p_qls_ship_to_cont_fst_name IN jtf_varchar2_table_100 := NULL,
4317: p_qls_ship_to_cont_mid_name IN jtf_varchar2_table_100 := NULL,
4318: p_qls_ship_to_cont_lst_name IN jtf_varchar2_table_100 := NULL,
4319: p_qls_ship_to_address1 IN jtf_varchar2_table_300 := NULL,
4320: p_qls_ship_to_address2 IN jtf_varchar2_table_300 := NULL,

Line 4317: p_qls_ship_to_cont_mid_name IN jtf_varchar2_table_100 := NULL,

4313: p_qls_reservation_id IN jtf_number_table := NULL,
4314: p_qls_order_line_id IN jtf_number_table := NULL,
4315: p_qls_ship_to_party_name IN jtf_varchar2_table_300 := NULL,
4316: p_qls_ship_to_cont_fst_name IN jtf_varchar2_table_100 := NULL,
4317: p_qls_ship_to_cont_mid_name IN jtf_varchar2_table_100 := NULL,
4318: p_qls_ship_to_cont_lst_name IN jtf_varchar2_table_100 := NULL,
4319: p_qls_ship_to_address1 IN jtf_varchar2_table_300 := NULL,
4320: p_qls_ship_to_address2 IN jtf_varchar2_table_300 := NULL,
4321: p_qls_ship_to_address3 IN jtf_varchar2_table_300 := NULL,

Line 4318: p_qls_ship_to_cont_lst_name IN jtf_varchar2_table_100 := NULL,

4314: p_qls_order_line_id IN jtf_number_table := NULL,
4315: p_qls_ship_to_party_name IN jtf_varchar2_table_300 := NULL,
4316: p_qls_ship_to_cont_fst_name IN jtf_varchar2_table_100 := NULL,
4317: p_qls_ship_to_cont_mid_name IN jtf_varchar2_table_100 := NULL,
4318: p_qls_ship_to_cont_lst_name IN jtf_varchar2_table_100 := NULL,
4319: p_qls_ship_to_address1 IN jtf_varchar2_table_300 := NULL,
4320: p_qls_ship_to_address2 IN jtf_varchar2_table_300 := NULL,
4321: p_qls_ship_to_address3 IN jtf_varchar2_table_300 := NULL,
4322: p_qls_ship_to_address4 IN jtf_varchar2_table_300 := NULL,

Line 4323: p_qls_ship_to_country_code IN jtf_varchar2_table_100 := NULL,

4319: p_qls_ship_to_address1 IN jtf_varchar2_table_300 := NULL,
4320: p_qls_ship_to_address2 IN jtf_varchar2_table_300 := NULL,
4321: p_qls_ship_to_address3 IN jtf_varchar2_table_300 := NULL,
4322: p_qls_ship_to_address4 IN jtf_varchar2_table_300 := NULL,
4323: p_qls_ship_to_country_code IN jtf_varchar2_table_100 := NULL,
4324: p_qls_ship_to_country IN jtf_varchar2_table_100 := NULL,
4325: p_qls_ship_to_city IN jtf_varchar2_table_100 := NULL,
4326: p_qls_ship_to_postal_code IN jtf_varchar2_table_100 := NULL,
4327: p_qls_ship_to_state IN jtf_varchar2_table_100 := NULL,

Line 4324: p_qls_ship_to_country IN jtf_varchar2_table_100 := NULL,

4320: p_qls_ship_to_address2 IN jtf_varchar2_table_300 := NULL,
4321: p_qls_ship_to_address3 IN jtf_varchar2_table_300 := NULL,
4322: p_qls_ship_to_address4 IN jtf_varchar2_table_300 := NULL,
4323: p_qls_ship_to_country_code IN jtf_varchar2_table_100 := NULL,
4324: p_qls_ship_to_country IN jtf_varchar2_table_100 := NULL,
4325: p_qls_ship_to_city IN jtf_varchar2_table_100 := NULL,
4326: p_qls_ship_to_postal_code IN jtf_varchar2_table_100 := NULL,
4327: p_qls_ship_to_state IN jtf_varchar2_table_100 := NULL,
4328: p_qls_ship_to_province IN jtf_varchar2_table_100 := NULL,

Line 4325: p_qls_ship_to_city IN jtf_varchar2_table_100 := NULL,

4321: p_qls_ship_to_address3 IN jtf_varchar2_table_300 := NULL,
4322: p_qls_ship_to_address4 IN jtf_varchar2_table_300 := NULL,
4323: p_qls_ship_to_country_code IN jtf_varchar2_table_100 := NULL,
4324: p_qls_ship_to_country IN jtf_varchar2_table_100 := NULL,
4325: p_qls_ship_to_city IN jtf_varchar2_table_100 := NULL,
4326: p_qls_ship_to_postal_code IN jtf_varchar2_table_100 := NULL,
4327: p_qls_ship_to_state IN jtf_varchar2_table_100 := NULL,
4328: p_qls_ship_to_province IN jtf_varchar2_table_100 := NULL,
4329: p_qls_ship_to_county IN jtf_varchar2_table_100 := NULL,

Line 4326: p_qls_ship_to_postal_code IN jtf_varchar2_table_100 := NULL,

4322: p_qls_ship_to_address4 IN jtf_varchar2_table_300 := NULL,
4323: p_qls_ship_to_country_code IN jtf_varchar2_table_100 := NULL,
4324: p_qls_ship_to_country IN jtf_varchar2_table_100 := NULL,
4325: p_qls_ship_to_city IN jtf_varchar2_table_100 := NULL,
4326: p_qls_ship_to_postal_code IN jtf_varchar2_table_100 := NULL,
4327: p_qls_ship_to_state IN jtf_varchar2_table_100 := NULL,
4328: p_qls_ship_to_province IN jtf_varchar2_table_100 := NULL,
4329: p_qls_ship_to_county IN jtf_varchar2_table_100 := NULL,
4330: p_qls_attribute_category IN jtf_varchar2_table_100 := NULL,

Line 4327: p_qls_ship_to_state IN jtf_varchar2_table_100 := NULL,

4323: p_qls_ship_to_country_code IN jtf_varchar2_table_100 := NULL,
4324: p_qls_ship_to_country IN jtf_varchar2_table_100 := NULL,
4325: p_qls_ship_to_city IN jtf_varchar2_table_100 := NULL,
4326: p_qls_ship_to_postal_code IN jtf_varchar2_table_100 := NULL,
4327: p_qls_ship_to_state IN jtf_varchar2_table_100 := NULL,
4328: p_qls_ship_to_province IN jtf_varchar2_table_100 := NULL,
4329: p_qls_ship_to_county IN jtf_varchar2_table_100 := NULL,
4330: p_qls_attribute_category IN jtf_varchar2_table_100 := NULL,
4331: p_qls_attribute1 IN jtf_varchar2_table_200 := NULL,

Line 4328: p_qls_ship_to_province IN jtf_varchar2_table_100 := NULL,

4324: p_qls_ship_to_country IN jtf_varchar2_table_100 := NULL,
4325: p_qls_ship_to_city IN jtf_varchar2_table_100 := NULL,
4326: p_qls_ship_to_postal_code IN jtf_varchar2_table_100 := NULL,
4327: p_qls_ship_to_state IN jtf_varchar2_table_100 := NULL,
4328: p_qls_ship_to_province IN jtf_varchar2_table_100 := NULL,
4329: p_qls_ship_to_county IN jtf_varchar2_table_100 := NULL,
4330: p_qls_attribute_category IN jtf_varchar2_table_100 := NULL,
4331: p_qls_attribute1 IN jtf_varchar2_table_200 := NULL,
4332: p_qls_attribute2 IN jtf_varchar2_table_200 := NULL,

Line 4329: p_qls_ship_to_county IN jtf_varchar2_table_100 := NULL,

4325: p_qls_ship_to_city IN jtf_varchar2_table_100 := NULL,
4326: p_qls_ship_to_postal_code IN jtf_varchar2_table_100 := NULL,
4327: p_qls_ship_to_state IN jtf_varchar2_table_100 := NULL,
4328: p_qls_ship_to_province IN jtf_varchar2_table_100 := NULL,
4329: p_qls_ship_to_county IN jtf_varchar2_table_100 := NULL,
4330: p_qls_attribute_category IN jtf_varchar2_table_100 := NULL,
4331: p_qls_attribute1 IN jtf_varchar2_table_200 := NULL,
4332: p_qls_attribute2 IN jtf_varchar2_table_200 := NULL,
4333: p_qls_attribute3 IN jtf_varchar2_table_200 := NULL,

Line 4330: p_qls_attribute_category IN jtf_varchar2_table_100 := NULL,

4326: p_qls_ship_to_postal_code IN jtf_varchar2_table_100 := NULL,
4327: p_qls_ship_to_state IN jtf_varchar2_table_100 := NULL,
4328: p_qls_ship_to_province IN jtf_varchar2_table_100 := NULL,
4329: p_qls_ship_to_county IN jtf_varchar2_table_100 := NULL,
4330: p_qls_attribute_category IN jtf_varchar2_table_100 := NULL,
4331: p_qls_attribute1 IN jtf_varchar2_table_200 := NULL,
4332: p_qls_attribute2 IN jtf_varchar2_table_200 := NULL,
4333: p_qls_attribute3 IN jtf_varchar2_table_200 := NULL,
4334: p_qls_attribute4 IN jtf_varchar2_table_200 := NULL,

Line 4346: p_qlt_operation_code IN jtf_varchar2_table_100 := NULL,

4342: p_qls_attribute12 IN jtf_varchar2_table_200 := NULL,
4343: p_qls_attribute13 IN jtf_varchar2_table_200 := NULL,
4344: p_qls_attribute14 IN jtf_varchar2_table_200 := NULL,
4345: p_qls_attribute15 IN jtf_varchar2_table_200 := NULL,
4346: p_qlt_operation_code IN jtf_varchar2_table_100 := NULL,
4347: p_qlt_qte_line_index IN jtf_number_table := NULL,
4348: p_qlt_shipment_index IN jtf_number_table := NULL,
4349: p_qlt_tax_detail_id IN jtf_number_table := NULL,
4350: p_qlt_quote_header_id IN jtf_number_table := NULL,

Line 4363: p_qlt_tax_code IN jtf_varchar2_table_100 := NULL,

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

Line 4367: p_qlt_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,

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

Line 4368: p_qlt_tax_exempt_number IN jtf_varchar2_table_100 := NULL,

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

Line 4369: p_qlt_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,

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

Line 4370: p_qlt_attribute_category IN jtf_varchar2_table_100 := NULL,

4366: p_qlt_tax_amount IN jtf_number_table := NULL,
4367: p_qlt_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,
4368: p_qlt_tax_exempt_number IN jtf_varchar2_table_100 := NULL,
4369: p_qlt_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,
4370: p_qlt_attribute_category IN jtf_varchar2_table_100 := NULL,
4371: p_qlt_attribute1 IN jtf_varchar2_table_200 := NULL,
4372: p_qlt_attribute2 IN jtf_varchar2_table_200 := NULL,
4373: p_qlt_attribute3 IN jtf_varchar2_table_200 := NULL,
4374: p_qlt_attribute4 IN jtf_varchar2_table_200 := NULL,

Line 4386: p_qlpaa_operation_code IN jtf_varchar2_table_100 := NULL,

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

Line 4400: p_qlpaa_pricing_context IN jtf_varchar2_table_100 := NULL,

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

Line 4401: p_qlpaa_pricing_attribute IN jtf_varchar2_table_100 := NULL,

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

Line 4404: p_qlpaa_comparison_operator IN jtf_varchar2_table_100 := NULL,

4400: p_qlpaa_pricing_context IN jtf_varchar2_table_100 := NULL,
4401: p_qlpaa_pricing_attribute IN jtf_varchar2_table_100 := NULL,
4402: p_qlpaa_prc_attr_value_from IN jtf_varchar2_table_300 := NULL,
4403: p_qlpaa_pricing_attr_value_to IN jtf_varchar2_table_300 := NULL,
4404: p_qlpaa_comparison_operator IN jtf_varchar2_table_100 := NULL,
4405: p_qlpaa_flex_title IN jtf_varchar2_table_100 := NULL,
4406: p_qlpaj_operation_code IN jtf_varchar2_table_100 := NULL,
4407: p_qlpaj_qte_line_index IN jtf_number_table := NULL,
4408: p_qlpaj_price_adjustment_id IN jtf_number_table := NULL,

Line 4405: p_qlpaa_flex_title IN jtf_varchar2_table_100 := NULL,

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

Line 4406: p_qlpaj_operation_code IN jtf_varchar2_table_100 := NULL,

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

Line 4422: p_qlpaj_mod_line_type_code IN jtf_varchar2_table_100 := NULL,

4418: p_qlpaj_quote_header_id IN jtf_number_table := NULL,
4419: p_qlpaj_quote_line_id IN jtf_number_table := NULL,
4420: p_qlpaj_modifier_header_id IN jtf_number_table := NULL,
4421: p_qlpaj_modifier_line_id IN jtf_number_table := NULL,
4422: p_qlpaj_mod_line_type_code IN jtf_varchar2_table_100 := NULL,
4423: p_qlpaj_mod_mech_type_code IN jtf_varchar2_table_100 := NULL,
4424: p_qlpaj_modified_from IN jtf_number_table := NULL,
4425: p_qlpaj_modified_to IN jtf_number_table := NULL,
4426: p_qlpaj_operand IN jtf_number_table := NULL,

Line 4423: p_qlpaj_mod_mech_type_code IN jtf_varchar2_table_100 := NULL,

4419: p_qlpaj_quote_line_id IN jtf_number_table := NULL,
4420: p_qlpaj_modifier_header_id IN jtf_number_table := NULL,
4421: p_qlpaj_modifier_line_id IN jtf_number_table := NULL,
4422: p_qlpaj_mod_line_type_code IN jtf_varchar2_table_100 := NULL,
4423: p_qlpaj_mod_mech_type_code IN jtf_varchar2_table_100 := NULL,
4424: p_qlpaj_modified_from IN jtf_number_table := NULL,
4425: p_qlpaj_modified_to IN jtf_number_table := NULL,
4426: p_qlpaj_operand IN jtf_number_table := NULL,
4427: p_qlpaj_arithmetic_operator IN jtf_varchar2_table_100 := NULL,

Line 4427: p_qlpaj_arithmetic_operator IN jtf_varchar2_table_100 := NULL,

4423: p_qlpaj_mod_mech_type_code IN jtf_varchar2_table_100 := NULL,
4424: p_qlpaj_modified_from IN jtf_number_table := NULL,
4425: p_qlpaj_modified_to IN jtf_number_table := NULL,
4426: p_qlpaj_operand IN jtf_number_table := NULL,
4427: p_qlpaj_arithmetic_operator IN jtf_varchar2_table_100 := NULL,
4428: p_qlpaj_automatic_flag IN jtf_varchar2_table_100 := NULL,
4429: p_qlpaj_update_allowable_flag IN jtf_varchar2_table_100 := NULL,
4430: p_qlpaj_updated_flag IN jtf_varchar2_table_100 := NULL,
4431: p_qlpaj_applied_flag IN jtf_varchar2_table_100 := NULL,

Line 4428: p_qlpaj_automatic_flag IN jtf_varchar2_table_100 := NULL,

4424: p_qlpaj_modified_from IN jtf_number_table := NULL,
4425: p_qlpaj_modified_to IN jtf_number_table := NULL,
4426: p_qlpaj_operand IN jtf_number_table := NULL,
4427: p_qlpaj_arithmetic_operator IN jtf_varchar2_table_100 := NULL,
4428: p_qlpaj_automatic_flag IN jtf_varchar2_table_100 := NULL,
4429: p_qlpaj_update_allowable_flag IN jtf_varchar2_table_100 := NULL,
4430: p_qlpaj_updated_flag IN jtf_varchar2_table_100 := NULL,
4431: p_qlpaj_applied_flag IN jtf_varchar2_table_100 := NULL,
4432: p_qlpaj_on_invoice_flag IN jtf_varchar2_table_100 := NULL,

Line 4429: p_qlpaj_update_allowable_flag IN jtf_varchar2_table_100 := NULL,

4425: p_qlpaj_modified_to IN jtf_number_table := NULL,
4426: p_qlpaj_operand IN jtf_number_table := NULL,
4427: p_qlpaj_arithmetic_operator IN jtf_varchar2_table_100 := NULL,
4428: p_qlpaj_automatic_flag IN jtf_varchar2_table_100 := NULL,
4429: p_qlpaj_update_allowable_flag IN jtf_varchar2_table_100 := NULL,
4430: p_qlpaj_updated_flag IN jtf_varchar2_table_100 := NULL,
4431: p_qlpaj_applied_flag IN jtf_varchar2_table_100 := NULL,
4432: p_qlpaj_on_invoice_flag IN jtf_varchar2_table_100 := NULL,
4433: p_qlpaj_pricing_phase_id IN jtf_number_table := NULL,

Line 4430: p_qlpaj_updated_flag IN jtf_varchar2_table_100 := NULL,

4426: p_qlpaj_operand IN jtf_number_table := NULL,
4427: p_qlpaj_arithmetic_operator IN jtf_varchar2_table_100 := NULL,
4428: p_qlpaj_automatic_flag IN jtf_varchar2_table_100 := NULL,
4429: p_qlpaj_update_allowable_flag IN jtf_varchar2_table_100 := NULL,
4430: p_qlpaj_updated_flag IN jtf_varchar2_table_100 := NULL,
4431: p_qlpaj_applied_flag IN jtf_varchar2_table_100 := NULL,
4432: p_qlpaj_on_invoice_flag IN jtf_varchar2_table_100 := NULL,
4433: p_qlpaj_pricing_phase_id IN jtf_number_table := NULL,
4434: p_qlpaj_attribute_category IN jtf_varchar2_table_100 := NULL,

Line 4431: p_qlpaj_applied_flag IN jtf_varchar2_table_100 := NULL,

4427: p_qlpaj_arithmetic_operator IN jtf_varchar2_table_100 := NULL,
4428: p_qlpaj_automatic_flag IN jtf_varchar2_table_100 := NULL,
4429: p_qlpaj_update_allowable_flag IN jtf_varchar2_table_100 := NULL,
4430: p_qlpaj_updated_flag IN jtf_varchar2_table_100 := NULL,
4431: p_qlpaj_applied_flag IN jtf_varchar2_table_100 := NULL,
4432: p_qlpaj_on_invoice_flag IN jtf_varchar2_table_100 := NULL,
4433: p_qlpaj_pricing_phase_id IN jtf_number_table := NULL,
4434: p_qlpaj_attribute_category IN jtf_varchar2_table_100 := NULL,
4435: p_qlpaj_attribute1 IN jtf_varchar2_table_200 := NULL,

Line 4432: p_qlpaj_on_invoice_flag IN jtf_varchar2_table_100 := NULL,

4428: p_qlpaj_automatic_flag IN jtf_varchar2_table_100 := NULL,
4429: p_qlpaj_update_allowable_flag IN jtf_varchar2_table_100 := NULL,
4430: p_qlpaj_updated_flag IN jtf_varchar2_table_100 := NULL,
4431: p_qlpaj_applied_flag IN jtf_varchar2_table_100 := NULL,
4432: p_qlpaj_on_invoice_flag IN jtf_varchar2_table_100 := NULL,
4433: p_qlpaj_pricing_phase_id IN jtf_number_table := NULL,
4434: p_qlpaj_attribute_category IN jtf_varchar2_table_100 := NULL,
4435: p_qlpaj_attribute1 IN jtf_varchar2_table_200 := NULL,
4436: p_qlpaj_attribute2 IN jtf_varchar2_table_200 := NULL,

Line 4434: p_qlpaj_attribute_category IN jtf_varchar2_table_100 := NULL,

4430: p_qlpaj_updated_flag IN jtf_varchar2_table_100 := NULL,
4431: p_qlpaj_applied_flag IN jtf_varchar2_table_100 := NULL,
4432: p_qlpaj_on_invoice_flag IN jtf_varchar2_table_100 := NULL,
4433: p_qlpaj_pricing_phase_id IN jtf_number_table := NULL,
4434: p_qlpaj_attribute_category IN jtf_varchar2_table_100 := NULL,
4435: p_qlpaj_attribute1 IN jtf_varchar2_table_200 := NULL,
4436: p_qlpaj_attribute2 IN jtf_varchar2_table_200 := NULL,
4437: p_qlpaj_attribute3 IN jtf_varchar2_table_200 := NULL,
4438: p_qlpaj_attribute4 IN jtf_varchar2_table_200 := NULL,

Line 4450: p_qlpaj_orig_sys_discount_ref IN jtf_varchar2_table_100 := NULL,

4446: p_qlpaj_attribute12 IN jtf_varchar2_table_200 := NULL,
4447: p_qlpaj_attribute13 IN jtf_varchar2_table_200 := NULL,
4448: p_qlpaj_attribute14 IN jtf_varchar2_table_200 := NULL,
4449: p_qlpaj_attribute15 IN jtf_varchar2_table_200 := NULL,
4450: p_qlpaj_orig_sys_discount_ref IN jtf_varchar2_table_100 := NULL,
4451: p_qlpaj_change_sequence IN jtf_varchar2_table_100 := NULL,
4452: p_qlpaj_update_allowed IN jtf_varchar2_table_100 := NULL,
4453: p_qlpaj_change_reason_code IN jtf_varchar2_table_100 := NULL,
4454: p_qlpaj_change_reason_text IN jtf_varchar2_table_2000 := NULL,

Line 4451: p_qlpaj_change_sequence IN jtf_varchar2_table_100 := NULL,

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

Line 4452: p_qlpaj_update_allowed IN jtf_varchar2_table_100 := NULL,

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

Line 4453: p_qlpaj_change_reason_code IN jtf_varchar2_table_100 := NULL,

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

Line 4456: p_qlpaj_tax_code IN jtf_varchar2_table_100 := NULL,

4452: p_qlpaj_update_allowed IN jtf_varchar2_table_100 := NULL,
4453: p_qlpaj_change_reason_code IN jtf_varchar2_table_100 := NULL,
4454: p_qlpaj_change_reason_text IN jtf_varchar2_table_2000 := NULL,
4455: p_qlpaj_cost_id IN jtf_number_table := NULL,
4456: p_qlpaj_tax_code IN jtf_varchar2_table_100 := NULL,
4457: p_qlpaj_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,
4458: p_qlpaj_tax_exempt_number IN jtf_varchar2_table_100 := NULL,
4459: p_qlpaj_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,
4460: p_qlpaj_parent_adjustment_id IN jtf_number_table := NULL,

Line 4457: p_qlpaj_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,

4453: p_qlpaj_change_reason_code IN jtf_varchar2_table_100 := NULL,
4454: p_qlpaj_change_reason_text IN jtf_varchar2_table_2000 := NULL,
4455: p_qlpaj_cost_id IN jtf_number_table := NULL,
4456: p_qlpaj_tax_code IN jtf_varchar2_table_100 := NULL,
4457: p_qlpaj_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,
4458: p_qlpaj_tax_exempt_number IN jtf_varchar2_table_100 := NULL,
4459: p_qlpaj_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,
4460: p_qlpaj_parent_adjustment_id IN jtf_number_table := NULL,
4461: p_qlpaj_invoiced_flag IN jtf_varchar2_table_100 := NULL,

Line 4458: p_qlpaj_tax_exempt_number IN jtf_varchar2_table_100 := NULL,

4454: p_qlpaj_change_reason_text IN jtf_varchar2_table_2000 := NULL,
4455: p_qlpaj_cost_id IN jtf_number_table := NULL,
4456: p_qlpaj_tax_code IN jtf_varchar2_table_100 := NULL,
4457: p_qlpaj_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,
4458: p_qlpaj_tax_exempt_number IN jtf_varchar2_table_100 := NULL,
4459: p_qlpaj_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,
4460: p_qlpaj_parent_adjustment_id IN jtf_number_table := NULL,
4461: p_qlpaj_invoiced_flag IN jtf_varchar2_table_100 := NULL,
4462: p_qlpaj_estimated_flag IN jtf_varchar2_table_100 := NULL,

Line 4459: p_qlpaj_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,

4455: p_qlpaj_cost_id IN jtf_number_table := NULL,
4456: p_qlpaj_tax_code IN jtf_varchar2_table_100 := NULL,
4457: p_qlpaj_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,
4458: p_qlpaj_tax_exempt_number IN jtf_varchar2_table_100 := NULL,
4459: p_qlpaj_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,
4460: p_qlpaj_parent_adjustment_id IN jtf_number_table := NULL,
4461: p_qlpaj_invoiced_flag IN jtf_varchar2_table_100 := NULL,
4462: p_qlpaj_estimated_flag IN jtf_varchar2_table_100 := NULL,
4463: p_qlpaj_inc_in_sales_perfce IN jtf_varchar2_table_100 := NULL,

Line 4461: p_qlpaj_invoiced_flag IN jtf_varchar2_table_100 := NULL,

4457: p_qlpaj_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,
4458: p_qlpaj_tax_exempt_number IN jtf_varchar2_table_100 := NULL,
4459: p_qlpaj_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,
4460: p_qlpaj_parent_adjustment_id IN jtf_number_table := NULL,
4461: p_qlpaj_invoiced_flag IN jtf_varchar2_table_100 := NULL,
4462: p_qlpaj_estimated_flag IN jtf_varchar2_table_100 := NULL,
4463: p_qlpaj_inc_in_sales_perfce IN jtf_varchar2_table_100 := NULL,
4464: p_qlpaj_split_action_code IN jtf_varchar2_table_100 := NULL,
4465: p_qlpaj_adjusted_amount IN jtf_number_table := NULL,

Line 4462: p_qlpaj_estimated_flag IN jtf_varchar2_table_100 := NULL,

4458: p_qlpaj_tax_exempt_number IN jtf_varchar2_table_100 := NULL,
4459: p_qlpaj_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,
4460: p_qlpaj_parent_adjustment_id IN jtf_number_table := NULL,
4461: p_qlpaj_invoiced_flag IN jtf_varchar2_table_100 := NULL,
4462: p_qlpaj_estimated_flag IN jtf_varchar2_table_100 := NULL,
4463: p_qlpaj_inc_in_sales_perfce IN jtf_varchar2_table_100 := NULL,
4464: p_qlpaj_split_action_code IN jtf_varchar2_table_100 := NULL,
4465: p_qlpaj_adjusted_amount IN jtf_number_table := NULL,
4466: p_qlpaj_charge_type_code IN jtf_varchar2_table_100 := NULL,

Line 4463: p_qlpaj_inc_in_sales_perfce IN jtf_varchar2_table_100 := NULL,

4459: p_qlpaj_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,
4460: p_qlpaj_parent_adjustment_id IN jtf_number_table := NULL,
4461: p_qlpaj_invoiced_flag IN jtf_varchar2_table_100 := NULL,
4462: p_qlpaj_estimated_flag IN jtf_varchar2_table_100 := NULL,
4463: p_qlpaj_inc_in_sales_perfce IN jtf_varchar2_table_100 := NULL,
4464: p_qlpaj_split_action_code IN jtf_varchar2_table_100 := NULL,
4465: p_qlpaj_adjusted_amount IN jtf_number_table := NULL,
4466: p_qlpaj_charge_type_code IN jtf_varchar2_table_100 := NULL,
4467: p_qlpaj_charge_subtype_code IN jtf_varchar2_table_100 := NULL,

Line 4464: p_qlpaj_split_action_code IN jtf_varchar2_table_100 := NULL,

4460: p_qlpaj_parent_adjustment_id IN jtf_number_table := NULL,
4461: p_qlpaj_invoiced_flag IN jtf_varchar2_table_100 := NULL,
4462: p_qlpaj_estimated_flag IN jtf_varchar2_table_100 := NULL,
4463: p_qlpaj_inc_in_sales_perfce IN jtf_varchar2_table_100 := NULL,
4464: p_qlpaj_split_action_code IN jtf_varchar2_table_100 := NULL,
4465: p_qlpaj_adjusted_amount IN jtf_number_table := NULL,
4466: p_qlpaj_charge_type_code IN jtf_varchar2_table_100 := NULL,
4467: p_qlpaj_charge_subtype_code IN jtf_varchar2_table_100 := NULL,
4468: p_qlpaj_range_break_quantity IN jtf_number_table := NULL,

Line 4466: p_qlpaj_charge_type_code IN jtf_varchar2_table_100 := NULL,

4462: p_qlpaj_estimated_flag IN jtf_varchar2_table_100 := NULL,
4463: p_qlpaj_inc_in_sales_perfce IN jtf_varchar2_table_100 := NULL,
4464: p_qlpaj_split_action_code IN jtf_varchar2_table_100 := NULL,
4465: p_qlpaj_adjusted_amount IN jtf_number_table := NULL,
4466: p_qlpaj_charge_type_code IN jtf_varchar2_table_100 := NULL,
4467: p_qlpaj_charge_subtype_code IN jtf_varchar2_table_100 := NULL,
4468: p_qlpaj_range_break_quantity IN jtf_number_table := NULL,
4469: p_qlpaj_accrual_conv_rate IN jtf_number_table := NULL,
4470: p_qlpaj_pricing_group_sequence IN jtf_number_table := NULL,

Line 4467: p_qlpaj_charge_subtype_code IN jtf_varchar2_table_100 := NULL,

4463: p_qlpaj_inc_in_sales_perfce IN jtf_varchar2_table_100 := NULL,
4464: p_qlpaj_split_action_code IN jtf_varchar2_table_100 := NULL,
4465: p_qlpaj_adjusted_amount IN jtf_number_table := NULL,
4466: p_qlpaj_charge_type_code IN jtf_varchar2_table_100 := NULL,
4467: p_qlpaj_charge_subtype_code IN jtf_varchar2_table_100 := NULL,
4468: p_qlpaj_range_break_quantity IN jtf_number_table := NULL,
4469: p_qlpaj_accrual_conv_rate IN jtf_number_table := NULL,
4470: p_qlpaj_pricing_group_sequence IN jtf_number_table := NULL,
4471: p_qlpaj_accrual_flag IN jtf_varchar2_table_100 := NULL,

Line 4471: p_qlpaj_accrual_flag IN jtf_varchar2_table_100 := NULL,

4467: p_qlpaj_charge_subtype_code IN jtf_varchar2_table_100 := NULL,
4468: p_qlpaj_range_break_quantity IN jtf_number_table := NULL,
4469: p_qlpaj_accrual_conv_rate IN jtf_number_table := NULL,
4470: p_qlpaj_pricing_group_sequence IN jtf_number_table := NULL,
4471: p_qlpaj_accrual_flag IN jtf_varchar2_table_100 := NULL,
4472: p_qlpaj_list_line_no IN jtf_varchar2_table_300 := NULL,
4473: p_qlpaj_source_system_code IN jtf_varchar2_table_100 := NULL,
4474: p_qlpaj_benefit_qty IN jtf_number_table := NULL,
4475: p_qlpaj_benefit_uom_code IN jtf_varchar2_table_100 := NULL,

Line 4473: p_qlpaj_source_system_code IN jtf_varchar2_table_100 := NULL,

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

Line 4475: p_qlpaj_benefit_uom_code IN jtf_varchar2_table_100 := NULL,

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

Line 4476: p_qlpaj_print_on_invoice_flag IN jtf_varchar2_table_100 := NULL,

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

Line 4478: p_qlpaj_rebate_trans_type_code IN jtf_varchar2_table_100 := NULL,

4474: p_qlpaj_benefit_qty IN jtf_number_table := NULL,
4475: p_qlpaj_benefit_uom_code IN jtf_varchar2_table_100 := NULL,
4476: p_qlpaj_print_on_invoice_flag IN jtf_varchar2_table_100 := NULL,
4477: p_qlpaj_expiration_date IN jtf_date_table := NULL,
4478: p_qlpaj_rebate_trans_type_code IN jtf_varchar2_table_100 := NULL,
4479: p_qlpaj_rebate_trans_reference IN jtf_varchar2_table_100 := NULL,
4480: p_qlpaj_rebate_pay_system_code IN jtf_varchar2_table_100 := NULL,
4481: p_qlpaj_redeemed_date IN jtf_date_table := NULL,
4482: p_qlpaj_redeemed_flag IN jtf_varchar2_table_100 := NULL,

Line 4479: p_qlpaj_rebate_trans_reference IN jtf_varchar2_table_100 := NULL,

4475: p_qlpaj_benefit_uom_code IN jtf_varchar2_table_100 := NULL,
4476: p_qlpaj_print_on_invoice_flag IN jtf_varchar2_table_100 := NULL,
4477: p_qlpaj_expiration_date IN jtf_date_table := NULL,
4478: p_qlpaj_rebate_trans_type_code IN jtf_varchar2_table_100 := NULL,
4479: p_qlpaj_rebate_trans_reference IN jtf_varchar2_table_100 := NULL,
4480: p_qlpaj_rebate_pay_system_code IN jtf_varchar2_table_100 := NULL,
4481: p_qlpaj_redeemed_date IN jtf_date_table := NULL,
4482: p_qlpaj_redeemed_flag IN jtf_varchar2_table_100 := NULL,
4483: p_qlpaj_modifier_level_code IN jtf_varchar2_table_100 := NULL,

Line 4480: p_qlpaj_rebate_pay_system_code IN jtf_varchar2_table_100 := NULL,

4476: p_qlpaj_print_on_invoice_flag IN jtf_varchar2_table_100 := NULL,
4477: p_qlpaj_expiration_date IN jtf_date_table := NULL,
4478: p_qlpaj_rebate_trans_type_code IN jtf_varchar2_table_100 := NULL,
4479: p_qlpaj_rebate_trans_reference IN jtf_varchar2_table_100 := NULL,
4480: p_qlpaj_rebate_pay_system_code IN jtf_varchar2_table_100 := NULL,
4481: p_qlpaj_redeemed_date IN jtf_date_table := NULL,
4482: p_qlpaj_redeemed_flag IN jtf_varchar2_table_100 := NULL,
4483: p_qlpaj_modifier_level_code IN jtf_varchar2_table_100 := NULL,
4484: p_qlpaj_price_break_type_code IN jtf_varchar2_table_100 := NULL,

Line 4482: p_qlpaj_redeemed_flag IN jtf_varchar2_table_100 := NULL,

4478: p_qlpaj_rebate_trans_type_code IN jtf_varchar2_table_100 := NULL,
4479: p_qlpaj_rebate_trans_reference IN jtf_varchar2_table_100 := NULL,
4480: p_qlpaj_rebate_pay_system_code IN jtf_varchar2_table_100 := NULL,
4481: p_qlpaj_redeemed_date IN jtf_date_table := NULL,
4482: p_qlpaj_redeemed_flag IN jtf_varchar2_table_100 := NULL,
4483: p_qlpaj_modifier_level_code IN jtf_varchar2_table_100 := NULL,
4484: p_qlpaj_price_break_type_code IN jtf_varchar2_table_100 := NULL,
4485: p_qlpaj_substitution_attribute IN jtf_varchar2_table_100 := NULL,
4486: p_qlpaj_proration_type_code IN jtf_varchar2_table_100 := NULL,

Line 4483: p_qlpaj_modifier_level_code IN jtf_varchar2_table_100 := NULL,

4479: p_qlpaj_rebate_trans_reference IN jtf_varchar2_table_100 := NULL,
4480: p_qlpaj_rebate_pay_system_code IN jtf_varchar2_table_100 := NULL,
4481: p_qlpaj_redeemed_date IN jtf_date_table := NULL,
4482: p_qlpaj_redeemed_flag IN jtf_varchar2_table_100 := NULL,
4483: p_qlpaj_modifier_level_code IN jtf_varchar2_table_100 := NULL,
4484: p_qlpaj_price_break_type_code IN jtf_varchar2_table_100 := NULL,
4485: p_qlpaj_substitution_attribute IN jtf_varchar2_table_100 := NULL,
4486: p_qlpaj_proration_type_code IN jtf_varchar2_table_100 := NULL,
4487: p_qlpaj_include_on_ret_flag IN jtf_varchar2_table_100 := NULL,

Line 4484: p_qlpaj_price_break_type_code IN jtf_varchar2_table_100 := NULL,

4480: p_qlpaj_rebate_pay_system_code IN jtf_varchar2_table_100 := NULL,
4481: p_qlpaj_redeemed_date IN jtf_date_table := NULL,
4482: p_qlpaj_redeemed_flag IN jtf_varchar2_table_100 := NULL,
4483: p_qlpaj_modifier_level_code IN jtf_varchar2_table_100 := NULL,
4484: p_qlpaj_price_break_type_code IN jtf_varchar2_table_100 := NULL,
4485: p_qlpaj_substitution_attribute IN jtf_varchar2_table_100 := NULL,
4486: p_qlpaj_proration_type_code IN jtf_varchar2_table_100 := NULL,
4487: p_qlpaj_include_on_ret_flag IN jtf_varchar2_table_100 := NULL,
4488: p_qlpaj_credit_or_charge_flag IN jtf_varchar2_table_100 := NULL,

Line 4485: p_qlpaj_substitution_attribute IN jtf_varchar2_table_100 := NULL,

4481: p_qlpaj_redeemed_date IN jtf_date_table := NULL,
4482: p_qlpaj_redeemed_flag IN jtf_varchar2_table_100 := NULL,
4483: p_qlpaj_modifier_level_code IN jtf_varchar2_table_100 := NULL,
4484: p_qlpaj_price_break_type_code IN jtf_varchar2_table_100 := NULL,
4485: p_qlpaj_substitution_attribute IN jtf_varchar2_table_100 := NULL,
4486: p_qlpaj_proration_type_code IN jtf_varchar2_table_100 := NULL,
4487: p_qlpaj_include_on_ret_flag IN jtf_varchar2_table_100 := NULL,
4488: p_qlpaj_credit_or_charge_flag IN jtf_varchar2_table_100 := NULL,
4489: p_qlpar_operation_code IN jtf_varchar2_table_100 := NULL,

Line 4486: p_qlpaj_proration_type_code IN jtf_varchar2_table_100 := NULL,

4482: p_qlpaj_redeemed_flag IN jtf_varchar2_table_100 := NULL,
4483: p_qlpaj_modifier_level_code IN jtf_varchar2_table_100 := NULL,
4484: p_qlpaj_price_break_type_code IN jtf_varchar2_table_100 := NULL,
4485: p_qlpaj_substitution_attribute IN jtf_varchar2_table_100 := NULL,
4486: p_qlpaj_proration_type_code IN jtf_varchar2_table_100 := NULL,
4487: p_qlpaj_include_on_ret_flag IN jtf_varchar2_table_100 := NULL,
4488: p_qlpaj_credit_or_charge_flag IN jtf_varchar2_table_100 := NULL,
4489: p_qlpar_operation_code IN jtf_varchar2_table_100 := NULL,
4490: p_qlpar_adj_relationship_id IN jtf_number_table := NULL,

Line 4487: p_qlpaj_include_on_ret_flag IN jtf_varchar2_table_100 := NULL,

4483: p_qlpaj_modifier_level_code IN jtf_varchar2_table_100 := NULL,
4484: p_qlpaj_price_break_type_code IN jtf_varchar2_table_100 := NULL,
4485: p_qlpaj_substitution_attribute IN jtf_varchar2_table_100 := NULL,
4486: p_qlpaj_proration_type_code IN jtf_varchar2_table_100 := NULL,
4487: p_qlpaj_include_on_ret_flag IN jtf_varchar2_table_100 := NULL,
4488: p_qlpaj_credit_or_charge_flag IN jtf_varchar2_table_100 := NULL,
4489: p_qlpar_operation_code IN jtf_varchar2_table_100 := NULL,
4490: p_qlpar_adj_relationship_id IN jtf_number_table := NULL,
4491: p_qlpar_creation_date IN jtf_date_table := NULL,

Line 4488: p_qlpaj_credit_or_charge_flag IN jtf_varchar2_table_100 := NULL,

4484: p_qlpaj_price_break_type_code IN jtf_varchar2_table_100 := NULL,
4485: p_qlpaj_substitution_attribute IN jtf_varchar2_table_100 := NULL,
4486: p_qlpaj_proration_type_code IN jtf_varchar2_table_100 := NULL,
4487: p_qlpaj_include_on_ret_flag IN jtf_varchar2_table_100 := NULL,
4488: p_qlpaj_credit_or_charge_flag IN jtf_varchar2_table_100 := NULL,
4489: p_qlpar_operation_code IN jtf_varchar2_table_100 := NULL,
4490: p_qlpar_adj_relationship_id IN jtf_number_table := NULL,
4491: p_qlpar_creation_date IN jtf_date_table := NULL,
4492: p_qlpar_created_by IN jtf_number_table := NULL,

Line 4489: p_qlpar_operation_code IN jtf_varchar2_table_100 := NULL,

4485: p_qlpaj_substitution_attribute IN jtf_varchar2_table_100 := NULL,
4486: p_qlpaj_proration_type_code IN jtf_varchar2_table_100 := NULL,
4487: p_qlpaj_include_on_ret_flag IN jtf_varchar2_table_100 := NULL,
4488: p_qlpaj_credit_or_charge_flag IN jtf_varchar2_table_100 := NULL,
4489: p_qlpar_operation_code IN jtf_varchar2_table_100 := NULL,
4490: p_qlpar_adj_relationship_id IN jtf_number_table := NULL,
4491: p_qlpar_creation_date IN jtf_date_table := NULL,
4492: p_qlpar_created_by IN jtf_number_table := NULL,
4493: p_qlpar_last_update_date IN jtf_date_table := NULL,

Line 4521: p_qlae_attribute_type_code IN jtf_varchar2_table_100 := NULL,

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

Line 4522: p_qlae_name IN jtf_varchar2_table_100 := NULL,

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

Line 4525: p_qlae_status IN jtf_varchar2_table_100 := NULL,

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

Line 4529: p_qlae_operation_code IN jtf_varchar2_table_100 := NULL,

4525: p_qlae_status IN jtf_varchar2_table_100 := NULL,
4526: p_qlae_application_id IN jtf_number_table := NULL,
4527: p_qlae_start_date_active IN jtf_date_table := NULL,
4528: p_qlae_end_date_active IN jtf_date_table := NULL,
4529: p_qlae_operation_code IN jtf_varchar2_table_100 := NULL,
4530: p_qfc_operation_code IN jtf_varchar2_table_100 := NULL,
4531: p_qfc_qte_line_index IN jtf_number_table := NULL,
4532: p_qfc_shipment_index IN jtf_number_table := NULL,
4533: p_qfc_freight_charge_id IN jtf_number_table := NULL,

Line 4530: p_qfc_operation_code IN jtf_varchar2_table_100 := NULL,

4526: p_qlae_application_id IN jtf_number_table := NULL,
4527: p_qlae_start_date_active IN jtf_date_table := NULL,
4528: p_qlae_end_date_active IN jtf_date_table := NULL,
4529: p_qlae_operation_code IN jtf_varchar2_table_100 := NULL,
4530: p_qfc_operation_code IN jtf_varchar2_table_100 := NULL,
4531: p_qfc_qte_line_index IN jtf_number_table := NULL,
4532: p_qfc_shipment_index IN jtf_number_table := NULL,
4533: p_qfc_freight_charge_id IN jtf_number_table := NULL,
4534: p_qfc_last_update_date IN jtf_date_table := NULL,

Line 4563: p_qlfc_operation_code IN jtf_varchar2_table_100 := NULL,

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

Line 6169: p_ql_line_category_code IN jtf_varchar2_table_100 := NULL,

6165: p_ql_quote_line_id IN jtf_number_table := NULL,
6166: p_ql_quote_header_id IN jtf_number_table := NULL,
6167: p_ql_org_id IN jtf_number_table := NULL,
6168: p_ql_line_number IN jtf_number_table := NULL,
6169: p_ql_line_category_code IN jtf_varchar2_table_100 := NULL,
6170: p_ql_item_type_code IN jtf_varchar2_table_100 := NULL,
6171: p_ql_inventory_item_id IN jtf_number_table := NULL,
6172: p_ql_organization_id IN jtf_number_table := NULL,
6173: p_ql_quantity IN jtf_number_table := NULL,

Line 6170: p_ql_item_type_code IN jtf_varchar2_table_100 := NULL,

6166: p_ql_quote_header_id IN jtf_number_table := NULL,
6167: p_ql_org_id IN jtf_number_table := NULL,
6168: p_ql_line_number IN jtf_number_table := NULL,
6169: p_ql_line_category_code IN jtf_varchar2_table_100 := NULL,
6170: p_ql_item_type_code IN jtf_varchar2_table_100 := NULL,
6171: p_ql_inventory_item_id IN jtf_number_table := NULL,
6172: p_ql_organization_id IN jtf_number_table := NULL,
6173: p_ql_quantity IN jtf_number_table := NULL,
6174: p_ql_uom_code IN jtf_varchar2_table_100 := NULL,

Line 6174: p_ql_uom_code IN jtf_varchar2_table_100 := NULL,

6170: p_ql_item_type_code IN jtf_varchar2_table_100 := NULL,
6171: p_ql_inventory_item_id IN jtf_number_table := NULL,
6172: p_ql_organization_id IN jtf_number_table := NULL,
6173: p_ql_quantity IN jtf_number_table := NULL,
6174: p_ql_uom_code IN jtf_varchar2_table_100 := NULL,
6175: p_ql_start_date_active IN jtf_date_table := NULL,
6176: p_ql_end_date_active IN jtf_date_table := NULL,
6177: p_ql_order_line_type_id IN jtf_number_table := NULL,
6178: p_ql_price_list_id IN jtf_number_table := NULL,

Line 6180: p_ql_currency_code IN jtf_varchar2_table_100 := NULL,

6176: p_ql_end_date_active IN jtf_date_table := NULL,
6177: p_ql_order_line_type_id IN jtf_number_table := NULL,
6178: p_ql_price_list_id IN jtf_number_table := NULL,
6179: p_ql_price_list_line_id IN jtf_number_table := NULL,
6180: p_ql_currency_code IN jtf_varchar2_table_100 := NULL,
6181: p_ql_line_list_price IN jtf_number_table := NULL,
6182: p_ql_line_adjusted_amount IN jtf_number_table := NULL,
6183: p_ql_line_adjusted_percent IN jtf_number_table := NULL,
6184: p_ql_line_quote_price IN jtf_number_table := NULL,

Line 6186: p_ql_item_relationship_type IN jtf_varchar2_table_100 := NULL,

6182: p_ql_line_adjusted_amount IN jtf_number_table := NULL,
6183: p_ql_line_adjusted_percent IN jtf_number_table := NULL,
6184: p_ql_line_quote_price IN jtf_number_table := NULL,
6185: p_ql_related_item_id IN jtf_number_table := NULL,
6186: p_ql_item_relationship_type IN jtf_varchar2_table_100 := NULL,
6187: p_ql_split_shipment_flag IN jtf_varchar2_table_100 := NULL,
6188: p_ql_backorder_flag IN jtf_varchar2_table_100 := NULL,
6189: p_ql_selling_price_change IN jtf_varchar2_table_100 := NULL,
6190: p_ql_recalculate_flag IN jtf_varchar2_table_100 := NULL,

Line 6187: p_ql_split_shipment_flag IN jtf_varchar2_table_100 := NULL,

6183: p_ql_line_adjusted_percent IN jtf_number_table := NULL,
6184: p_ql_line_quote_price IN jtf_number_table := NULL,
6185: p_ql_related_item_id IN jtf_number_table := NULL,
6186: p_ql_item_relationship_type IN jtf_varchar2_table_100 := NULL,
6187: p_ql_split_shipment_flag IN jtf_varchar2_table_100 := NULL,
6188: p_ql_backorder_flag IN jtf_varchar2_table_100 := NULL,
6189: p_ql_selling_price_change IN jtf_varchar2_table_100 := NULL,
6190: p_ql_recalculate_flag IN jtf_varchar2_table_100 := NULL,
6191: p_ql_attribute_category IN jtf_varchar2_table_100 := NULL,

Line 6188: p_ql_backorder_flag IN jtf_varchar2_table_100 := NULL,

6184: p_ql_line_quote_price IN jtf_number_table := NULL,
6185: p_ql_related_item_id IN jtf_number_table := NULL,
6186: p_ql_item_relationship_type IN jtf_varchar2_table_100 := NULL,
6187: p_ql_split_shipment_flag IN jtf_varchar2_table_100 := NULL,
6188: p_ql_backorder_flag IN jtf_varchar2_table_100 := NULL,
6189: p_ql_selling_price_change IN jtf_varchar2_table_100 := NULL,
6190: p_ql_recalculate_flag IN jtf_varchar2_table_100 := NULL,
6191: p_ql_attribute_category IN jtf_varchar2_table_100 := NULL,
6192: p_ql_attribute1 IN jtf_varchar2_table_300 := NULL,

Line 6189: p_ql_selling_price_change IN jtf_varchar2_table_100 := NULL,

6185: p_ql_related_item_id IN jtf_number_table := NULL,
6186: p_ql_item_relationship_type IN jtf_varchar2_table_100 := NULL,
6187: p_ql_split_shipment_flag IN jtf_varchar2_table_100 := NULL,
6188: p_ql_backorder_flag IN jtf_varchar2_table_100 := NULL,
6189: p_ql_selling_price_change IN jtf_varchar2_table_100 := NULL,
6190: p_ql_recalculate_flag IN jtf_varchar2_table_100 := NULL,
6191: p_ql_attribute_category IN jtf_varchar2_table_100 := NULL,
6192: p_ql_attribute1 IN jtf_varchar2_table_300 := NULL,
6193: p_ql_attribute2 IN jtf_varchar2_table_300 := NULL,

Line 6190: p_ql_recalculate_flag IN jtf_varchar2_table_100 := NULL,

6186: p_ql_item_relationship_type IN jtf_varchar2_table_100 := NULL,
6187: p_ql_split_shipment_flag IN jtf_varchar2_table_100 := NULL,
6188: p_ql_backorder_flag IN jtf_varchar2_table_100 := NULL,
6189: p_ql_selling_price_change IN jtf_varchar2_table_100 := NULL,
6190: p_ql_recalculate_flag IN jtf_varchar2_table_100 := NULL,
6191: p_ql_attribute_category IN jtf_varchar2_table_100 := NULL,
6192: p_ql_attribute1 IN jtf_varchar2_table_300 := NULL,
6193: p_ql_attribute2 IN jtf_varchar2_table_300 := NULL,
6194: p_ql_attribute3 IN jtf_varchar2_table_300 := NULL,

Line 6191: p_ql_attribute_category IN jtf_varchar2_table_100 := NULL,

6187: p_ql_split_shipment_flag IN jtf_varchar2_table_100 := NULL,
6188: p_ql_backorder_flag IN jtf_varchar2_table_100 := NULL,
6189: p_ql_selling_price_change IN jtf_varchar2_table_100 := NULL,
6190: p_ql_recalculate_flag IN jtf_varchar2_table_100 := NULL,
6191: p_ql_attribute_category IN jtf_varchar2_table_100 := NULL,
6192: p_ql_attribute1 IN jtf_varchar2_table_300 := NULL,
6193: p_ql_attribute2 IN jtf_varchar2_table_300 := NULL,
6194: p_ql_attribute3 IN jtf_varchar2_table_300 := NULL,
6195: p_ql_attribute4 IN jtf_varchar2_table_300 := NULL,

Line 6219: p_ql_operation_code IN jtf_varchar2_table_100 := NULL,

6215: p_ql_invoice_to_party_site_id IN jtf_number_table := NULL,
6216: p_ql_invoice_to_cust_acct_id IN jtf_number_table := NULL,
6217: p_ql_invoicing_rule_id IN jtf_number_table := NULL,
6218: p_ql_marketing_source_code_id IN jtf_number_table := NULL,
6219: p_ql_operation_code IN jtf_varchar2_table_100 := NULL,
6220: p_ql_commitment_id IN jtf_number_table := NULL,
6221: p_ql_agreement_id IN jtf_number_table := NULL,
6222: p_ql_minisite_id IN jtf_number_table := NULL,
6223: p_ql_section_id IN jtf_number_table := NULL,