APPS.ARRX_SALES_TAX_REP dependencies on DBMS_SQL

Line 768: c := DBMS_SQL.OPEN_CURSOR;

764: from gl_sets_of_books
765: where set_of_books_id = h_sob_id;
766:
767: -- open cursor
768: c := DBMS_SQL.OPEN_CURSOR;
769: -- parse cursor
770: DBMS_SQL.PARSE
771: (c,
772: select_statement,

Line 770: DBMS_SQL.PARSE

766:
767: -- open cursor
768: c := DBMS_SQL.OPEN_CURSOR;
769: -- parse cursor
770: DBMS_SQL.PARSE
771: (c,
772: select_statement,
773: DBMS_SQL.V7);
774:

Line 773: DBMS_SQL.V7);

769: -- parse cursor
770: DBMS_SQL.PARSE
771: (c,
772: select_statement,
773: DBMS_SQL.V7);
774:
775: -- values for bind variables
776: DBMS_SQL.BIND_VARIABLE(c,'state_low_q', h_state_low);
777: DBMS_SQL.BIND_VARIABLE(c,'state_high_q', h_state_high);

Line 776: DBMS_SQL.BIND_VARIABLE(c,'state_low_q', h_state_low);

772: select_statement,
773: DBMS_SQL.V7);
774:
775: -- values for bind variables
776: DBMS_SQL.BIND_VARIABLE(c,'state_low_q', h_state_low);
777: DBMS_SQL.BIND_VARIABLE(c,'state_high_q', h_state_high);
778: DBMS_SQL.BIND_VARIABLE(c,'gl_date_low_q', h_gl_date_low);
779: DBMS_SQL.BIND_VARIABLE(c,'gl_date_high_q', h_gl_date_high);
780: DBMS_SQL.BIND_VARIABLE(c,'chart_of_accounts_id_q', chart_of_accounts_id);

Line 777: DBMS_SQL.BIND_VARIABLE(c,'state_high_q', h_state_high);

773: DBMS_SQL.V7);
774:
775: -- values for bind variables
776: DBMS_SQL.BIND_VARIABLE(c,'state_low_q', h_state_low);
777: DBMS_SQL.BIND_VARIABLE(c,'state_high_q', h_state_high);
778: DBMS_SQL.BIND_VARIABLE(c,'gl_date_low_q', h_gl_date_low);
779: DBMS_SQL.BIND_VARIABLE(c,'gl_date_high_q', h_gl_date_high);
780: DBMS_SQL.BIND_VARIABLE(c,'chart_of_accounts_id_q', chart_of_accounts_id);
781: if exemption_status is not null then

Line 778: DBMS_SQL.BIND_VARIABLE(c,'gl_date_low_q', h_gl_date_low);

774:
775: -- values for bind variables
776: DBMS_SQL.BIND_VARIABLE(c,'state_low_q', h_state_low);
777: DBMS_SQL.BIND_VARIABLE(c,'state_high_q', h_state_high);
778: DBMS_SQL.BIND_VARIABLE(c,'gl_date_low_q', h_gl_date_low);
779: DBMS_SQL.BIND_VARIABLE(c,'gl_date_high_q', h_gl_date_high);
780: DBMS_SQL.BIND_VARIABLE(c,'chart_of_accounts_id_q', chart_of_accounts_id);
781: if exemption_status is not null then
782: DBMS_SQL.BIND_VARIABLE(c,'exemption_status_q',exemption_status);

Line 779: DBMS_SQL.BIND_VARIABLE(c,'gl_date_high_q', h_gl_date_high);

775: -- values for bind variables
776: DBMS_SQL.BIND_VARIABLE(c,'state_low_q', h_state_low);
777: DBMS_SQL.BIND_VARIABLE(c,'state_high_q', h_state_high);
778: DBMS_SQL.BIND_VARIABLE(c,'gl_date_low_q', h_gl_date_low);
779: DBMS_SQL.BIND_VARIABLE(c,'gl_date_high_q', h_gl_date_high);
780: DBMS_SQL.BIND_VARIABLE(c,'chart_of_accounts_id_q', chart_of_accounts_id);
781: if exemption_status is not null then
782: DBMS_SQL.BIND_VARIABLE(c,'exemption_status_q',exemption_status);
783: end if;

Line 780: DBMS_SQL.BIND_VARIABLE(c,'chart_of_accounts_id_q', chart_of_accounts_id);

776: DBMS_SQL.BIND_VARIABLE(c,'state_low_q', h_state_low);
777: DBMS_SQL.BIND_VARIABLE(c,'state_high_q', h_state_high);
778: DBMS_SQL.BIND_VARIABLE(c,'gl_date_low_q', h_gl_date_low);
779: DBMS_SQL.BIND_VARIABLE(c,'gl_date_high_q', h_gl_date_high);
780: DBMS_SQL.BIND_VARIABLE(c,'chart_of_accounts_id_q', chart_of_accounts_id);
781: if exemption_status is not null then
782: DBMS_SQL.BIND_VARIABLE(c,'exemption_status_q',exemption_status);
783: end if;
784: if currency_low is not null then

Line 782: DBMS_SQL.BIND_VARIABLE(c,'exemption_status_q',exemption_status);

778: DBMS_SQL.BIND_VARIABLE(c,'gl_date_low_q', h_gl_date_low);
779: DBMS_SQL.BIND_VARIABLE(c,'gl_date_high_q', h_gl_date_high);
780: DBMS_SQL.BIND_VARIABLE(c,'chart_of_accounts_id_q', chart_of_accounts_id);
781: if exemption_status is not null then
782: DBMS_SQL.BIND_VARIABLE(c,'exemption_status_q',exemption_status);
783: end if;
784: if currency_low is not null then
785: DBMS_SQL.BIND_VARIABLE(c,'currency_low_q',currency_low);
786: end if;

Line 785: DBMS_SQL.BIND_VARIABLE(c,'currency_low_q',currency_low);

781: if exemption_status is not null then
782: DBMS_SQL.BIND_VARIABLE(c,'exemption_status_q',exemption_status);
783: end if;
784: if currency_low is not null then
785: DBMS_SQL.BIND_VARIABLE(c,'currency_low_q',currency_low);
786: end if;
787: if currency_high is not null then
788: DBMS_SQL.BIND_VARIABLE(c,'currency_high_q',currency_high);
789: end if;

Line 788: DBMS_SQL.BIND_VARIABLE(c,'currency_high_q',currency_high);

784: if currency_low is not null then
785: DBMS_SQL.BIND_VARIABLE(c,'currency_low_q',currency_low);
786: end if;
787: if currency_high is not null then
788: DBMS_SQL.BIND_VARIABLE(c,'currency_high_q',currency_high);
789: end if;
790:
791: -- define the columns in SELECT
792:

Line 793: DBMS_SQL.define_column(c,1, c_currency,15);

789: end if;
790:
791: -- define the columns in SELECT
792:
793: DBMS_SQL.define_column(c,1, c_currency,15);
794: DBMS_SQL.define_column(c,2, c_tax_reference,50);
795: DBMS_SQL.define_column(c,3, c_sic_code,30);
796: DBMS_SQL.define_column(c,4, c_ship_date_actual);
797: DBMS_SQL.define_column(c,5, c_fob_point,30);

Line 794: DBMS_SQL.define_column(c,2, c_tax_reference,50);

790:
791: -- define the columns in SELECT
792:
793: DBMS_SQL.define_column(c,1, c_currency,15);
794: DBMS_SQL.define_column(c,2, c_tax_reference,50);
795: DBMS_SQL.define_column(c,3, c_sic_code,30);
796: DBMS_SQL.define_column(c,4, c_ship_date_actual);
797: DBMS_SQL.define_column(c,5, c_fob_point,30);
798: DBMS_SQL.define_column(c,6, c_inv_number, 20);

Line 795: DBMS_SQL.define_column(c,3, c_sic_code,30);

791: -- define the columns in SELECT
792:
793: DBMS_SQL.define_column(c,1, c_currency,15);
794: DBMS_SQL.define_column(c,2, c_tax_reference,50);
795: DBMS_SQL.define_column(c,3, c_sic_code,30);
796: DBMS_SQL.define_column(c,4, c_ship_date_actual);
797: DBMS_SQL.define_column(c,5, c_fob_point,30);
798: DBMS_SQL.define_column(c,6, c_inv_number, 20);
799: DBMS_SQL.define_column(c,7, c_inv_type, 80);

Line 796: DBMS_SQL.define_column(c,4, c_ship_date_actual);

792:
793: DBMS_SQL.define_column(c,1, c_currency,15);
794: DBMS_SQL.define_column(c,2, c_tax_reference,50);
795: DBMS_SQL.define_column(c,3, c_sic_code,30);
796: DBMS_SQL.define_column(c,4, c_ship_date_actual);
797: DBMS_SQL.define_column(c,5, c_fob_point,30);
798: DBMS_SQL.define_column(c,6, c_inv_number, 20);
799: DBMS_SQL.define_column(c,7, c_inv_type, 80);
800: DBMS_SQL.define_column(c,8, c_inv_type_code, 20);

Line 797: DBMS_SQL.define_column(c,5, c_fob_point,30);

793: DBMS_SQL.define_column(c,1, c_currency,15);
794: DBMS_SQL.define_column(c,2, c_tax_reference,50);
795: DBMS_SQL.define_column(c,3, c_sic_code,30);
796: DBMS_SQL.define_column(c,4, c_ship_date_actual);
797: DBMS_SQL.define_column(c,5, c_fob_point,30);
798: DBMS_SQL.define_column(c,6, c_inv_number, 20);
799: DBMS_SQL.define_column(c,7, c_inv_type, 80);
800: DBMS_SQL.define_column(c,8, c_inv_type_code, 20);
801: DBMS_SQL.define_column(c,9, c_inv_type_code_order, 20);

Line 798: DBMS_SQL.define_column(c,6, c_inv_number, 20);

794: DBMS_SQL.define_column(c,2, c_tax_reference,50);
795: DBMS_SQL.define_column(c,3, c_sic_code,30);
796: DBMS_SQL.define_column(c,4, c_ship_date_actual);
797: DBMS_SQL.define_column(c,5, c_fob_point,30);
798: DBMS_SQL.define_column(c,6, c_inv_number, 20);
799: DBMS_SQL.define_column(c,7, c_inv_type, 80);
800: DBMS_SQL.define_column(c,8, c_inv_type_code, 20);
801: DBMS_SQL.define_column(c,9, c_inv_type_code_order, 20);
802: DBMS_SQL.define_column(c,10, c_adj_number, 20);

Line 799: DBMS_SQL.define_column(c,7, c_inv_type, 80);

795: DBMS_SQL.define_column(c,3, c_sic_code,30);
796: DBMS_SQL.define_column(c,4, c_ship_date_actual);
797: DBMS_SQL.define_column(c,5, c_fob_point,30);
798: DBMS_SQL.define_column(c,6, c_inv_number, 20);
799: DBMS_SQL.define_column(c,7, c_inv_type, 80);
800: DBMS_SQL.define_column(c,8, c_inv_type_code, 20);
801: DBMS_SQL.define_column(c,9, c_inv_type_code_order, 20);
802: DBMS_SQL.define_column(c,10, c_adj_number, 20);
803: DBMS_SQL.define_column(c,11, c_adj_line_amount);

Line 800: DBMS_SQL.define_column(c,8, c_inv_type_code, 20);

796: DBMS_SQL.define_column(c,4, c_ship_date_actual);
797: DBMS_SQL.define_column(c,5, c_fob_point,30);
798: DBMS_SQL.define_column(c,6, c_inv_number, 20);
799: DBMS_SQL.define_column(c,7, c_inv_type, 80);
800: DBMS_SQL.define_column(c,8, c_inv_type_code, 20);
801: DBMS_SQL.define_column(c,9, c_inv_type_code_order, 20);
802: DBMS_SQL.define_column(c,10, c_adj_number, 20);
803: DBMS_SQL.define_column(c,11, c_adj_line_amount);
804: DBMS_SQL.define_column(c,12, c_adj_tax_amount);

Line 801: DBMS_SQL.define_column(c,9, c_inv_type_code_order, 20);

797: DBMS_SQL.define_column(c,5, c_fob_point,30);
798: DBMS_SQL.define_column(c,6, c_inv_number, 20);
799: DBMS_SQL.define_column(c,7, c_inv_type, 80);
800: DBMS_SQL.define_column(c,8, c_inv_type_code, 20);
801: DBMS_SQL.define_column(c,9, c_inv_type_code_order, 20);
802: DBMS_SQL.define_column(c,10, c_adj_number, 20);
803: DBMS_SQL.define_column(c,11, c_adj_line_amount);
804: DBMS_SQL.define_column(c,12, c_adj_tax_amount);
805: DBMS_SQL.define_column(c,13, c_adj_freight_amount);

Line 802: DBMS_SQL.define_column(c,10, c_adj_number, 20);

798: DBMS_SQL.define_column(c,6, c_inv_number, 20);
799: DBMS_SQL.define_column(c,7, c_inv_type, 80);
800: DBMS_SQL.define_column(c,8, c_inv_type_code, 20);
801: DBMS_SQL.define_column(c,9, c_inv_type_code_order, 20);
802: DBMS_SQL.define_column(c,10, c_adj_number, 20);
803: DBMS_SQL.define_column(c,11, c_adj_line_amount);
804: DBMS_SQL.define_column(c,12, c_adj_tax_amount);
805: DBMS_SQL.define_column(c,13, c_adj_freight_amount);
806: DBMS_SQL.define_column(c,14, c_adj_type,30);

Line 803: DBMS_SQL.define_column(c,11, c_adj_line_amount);

799: DBMS_SQL.define_column(c,7, c_inv_type, 80);
800: DBMS_SQL.define_column(c,8, c_inv_type_code, 20);
801: DBMS_SQL.define_column(c,9, c_inv_type_code_order, 20);
802: DBMS_SQL.define_column(c,10, c_adj_number, 20);
803: DBMS_SQL.define_column(c,11, c_adj_line_amount);
804: DBMS_SQL.define_column(c,12, c_adj_tax_amount);
805: DBMS_SQL.define_column(c,13, c_adj_freight_amount);
806: DBMS_SQL.define_column(c,14, c_adj_type,30);
807: DBMS_SQL.define_column(c,15, c_inv_date );

Line 804: DBMS_SQL.define_column(c,12, c_adj_tax_amount);

800: DBMS_SQL.define_column(c,8, c_inv_type_code, 20);
801: DBMS_SQL.define_column(c,9, c_inv_type_code_order, 20);
802: DBMS_SQL.define_column(c,10, c_adj_number, 20);
803: DBMS_SQL.define_column(c,11, c_adj_line_amount);
804: DBMS_SQL.define_column(c,12, c_adj_tax_amount);
805: DBMS_SQL.define_column(c,13, c_adj_freight_amount);
806: DBMS_SQL.define_column(c,14, c_adj_type,30);
807: DBMS_SQL.define_column(c,15, c_inv_date );
808: DBMS_SQL.define_column(c,16, c_ship_to_cust_name, 50);

Line 805: DBMS_SQL.define_column(c,13, c_adj_freight_amount);

801: DBMS_SQL.define_column(c,9, c_inv_type_code_order, 20);
802: DBMS_SQL.define_column(c,10, c_adj_number, 20);
803: DBMS_SQL.define_column(c,11, c_adj_line_amount);
804: DBMS_SQL.define_column(c,12, c_adj_tax_amount);
805: DBMS_SQL.define_column(c,13, c_adj_freight_amount);
806: DBMS_SQL.define_column(c,14, c_adj_type,30);
807: DBMS_SQL.define_column(c,15, c_inv_date );
808: DBMS_SQL.define_column(c,16, c_ship_to_cust_name, 50);
809: DBMS_SQL.define_column(c,17, c_ship_to_cust_number, 30);

Line 806: DBMS_SQL.define_column(c,14, c_adj_type,30);

802: DBMS_SQL.define_column(c,10, c_adj_number, 20);
803: DBMS_SQL.define_column(c,11, c_adj_line_amount);
804: DBMS_SQL.define_column(c,12, c_adj_tax_amount);
805: DBMS_SQL.define_column(c,13, c_adj_freight_amount);
806: DBMS_SQL.define_column(c,14, c_adj_type,30);
807: DBMS_SQL.define_column(c,15, c_inv_date );
808: DBMS_SQL.define_column(c,16, c_ship_to_cust_name, 50);
809: DBMS_SQL.define_column(c,17, c_ship_to_cust_number, 30);
810: DBMS_SQL.define_column(c,18, c_location, 40);

Line 807: DBMS_SQL.define_column(c,15, c_inv_date );

803: DBMS_SQL.define_column(c,11, c_adj_line_amount);
804: DBMS_SQL.define_column(c,12, c_adj_tax_amount);
805: DBMS_SQL.define_column(c,13, c_adj_freight_amount);
806: DBMS_SQL.define_column(c,14, c_adj_type,30);
807: DBMS_SQL.define_column(c,15, c_inv_date );
808: DBMS_SQL.define_column(c,16, c_ship_to_cust_name, 50);
809: DBMS_SQL.define_column(c,17, c_ship_to_cust_number, 30);
810: DBMS_SQL.define_column(c,18, c_location, 40);
811: DBMS_SQL.define_column(c,19, c_cust_tax_code, 50);

Line 808: DBMS_SQL.define_column(c,16, c_ship_to_cust_name, 50);

804: DBMS_SQL.define_column(c,12, c_adj_tax_amount);
805: DBMS_SQL.define_column(c,13, c_adj_freight_amount);
806: DBMS_SQL.define_column(c,14, c_adj_type,30);
807: DBMS_SQL.define_column(c,15, c_inv_date );
808: DBMS_SQL.define_column(c,16, c_ship_to_cust_name, 50);
809: DBMS_SQL.define_column(c,17, c_ship_to_cust_number, 30);
810: DBMS_SQL.define_column(c,18, c_location, 40);
811: DBMS_SQL.define_column(c,19, c_cust_tax_code, 50);
812: DBMS_SQL.define_column(c,20, c_type_flag, 20);

Line 809: DBMS_SQL.define_column(c,17, c_ship_to_cust_number, 30);

805: DBMS_SQL.define_column(c,13, c_adj_freight_amount);
806: DBMS_SQL.define_column(c,14, c_adj_type,30);
807: DBMS_SQL.define_column(c,15, c_inv_date );
808: DBMS_SQL.define_column(c,16, c_ship_to_cust_name, 50);
809: DBMS_SQL.define_column(c,17, c_ship_to_cust_number, 30);
810: DBMS_SQL.define_column(c,18, c_location, 40);
811: DBMS_SQL.define_column(c,19, c_cust_tax_code, 50);
812: DBMS_SQL.define_column(c,20, c_type_flag, 20);
813: DBMS_SQL.define_column(c,21, c_inv_cust_trx_id );

Line 810: DBMS_SQL.define_column(c,18, c_location, 40);

806: DBMS_SQL.define_column(c,14, c_adj_type,30);
807: DBMS_SQL.define_column(c,15, c_inv_date );
808: DBMS_SQL.define_column(c,16, c_ship_to_cust_name, 50);
809: DBMS_SQL.define_column(c,17, c_ship_to_cust_number, 30);
810: DBMS_SQL.define_column(c,18, c_location, 40);
811: DBMS_SQL.define_column(c,19, c_cust_tax_code, 50);
812: DBMS_SQL.define_column(c,20, c_type_flag, 20);
813: DBMS_SQL.define_column(c,21, c_inv_cust_trx_id );
814: DBMS_SQL.define_column(c,22, c_cust_trx_id );

Line 811: DBMS_SQL.define_column(c,19, c_cust_tax_code, 50);

807: DBMS_SQL.define_column(c,15, c_inv_date );
808: DBMS_SQL.define_column(c,16, c_ship_to_cust_name, 50);
809: DBMS_SQL.define_column(c,17, c_ship_to_cust_number, 30);
810: DBMS_SQL.define_column(c,18, c_location, 40);
811: DBMS_SQL.define_column(c,19, c_cust_tax_code, 50);
812: DBMS_SQL.define_column(c,20, c_type_flag, 20);
813: DBMS_SQL.define_column(c,21, c_inv_cust_trx_id );
814: DBMS_SQL.define_column(c,22, c_cust_trx_id );
815: DBMS_SQL.define_column(c,23, c_batch_source_id );

Line 812: DBMS_SQL.define_column(c,20, c_type_flag, 20);

808: DBMS_SQL.define_column(c,16, c_ship_to_cust_name, 50);
809: DBMS_SQL.define_column(c,17, c_ship_to_cust_number, 30);
810: DBMS_SQL.define_column(c,18, c_location, 40);
811: DBMS_SQL.define_column(c,19, c_cust_tax_code, 50);
812: DBMS_SQL.define_column(c,20, c_type_flag, 20);
813: DBMS_SQL.define_column(c,21, c_inv_cust_trx_id );
814: DBMS_SQL.define_column(c,22, c_cust_trx_id );
815: DBMS_SQL.define_column(c,23, c_batch_source_id );
816: DBMS_SQL.define_column(c,24, c_adjustment_id);

Line 813: DBMS_SQL.define_column(c,21, c_inv_cust_trx_id );

809: DBMS_SQL.define_column(c,17, c_ship_to_cust_number, 30);
810: DBMS_SQL.define_column(c,18, c_location, 40);
811: DBMS_SQL.define_column(c,19, c_cust_tax_code, 50);
812: DBMS_SQL.define_column(c,20, c_type_flag, 20);
813: DBMS_SQL.define_column(c,21, c_inv_cust_trx_id );
814: DBMS_SQL.define_column(c,22, c_cust_trx_id );
815: DBMS_SQL.define_column(c,23, c_batch_source_id );
816: DBMS_SQL.define_column(c,24, c_adjustment_id);
817: DBMS_SQL.define_column(c,25, c_trx_line_id );

Line 814: DBMS_SQL.define_column(c,22, c_cust_trx_id );

810: DBMS_SQL.define_column(c,18, c_location, 40);
811: DBMS_SQL.define_column(c,19, c_cust_tax_code, 50);
812: DBMS_SQL.define_column(c,20, c_type_flag, 20);
813: DBMS_SQL.define_column(c,21, c_inv_cust_trx_id );
814: DBMS_SQL.define_column(c,22, c_cust_trx_id );
815: DBMS_SQL.define_column(c,23, c_batch_source_id );
816: DBMS_SQL.define_column(c,24, c_adjustment_id);
817: DBMS_SQL.define_column(c,25, c_trx_line_id );
818: DBMS_SQL.define_column(c,26, c_line_number );

Line 815: DBMS_SQL.define_column(c,23, c_batch_source_id );

811: DBMS_SQL.define_column(c,19, c_cust_tax_code, 50);
812: DBMS_SQL.define_column(c,20, c_type_flag, 20);
813: DBMS_SQL.define_column(c,21, c_inv_cust_trx_id );
814: DBMS_SQL.define_column(c,22, c_cust_trx_id );
815: DBMS_SQL.define_column(c,23, c_batch_source_id );
816: DBMS_SQL.define_column(c,24, c_adjustment_id);
817: DBMS_SQL.define_column(c,25, c_trx_line_id );
818: DBMS_SQL.define_column(c,26, c_line_number );
819: DBMS_SQL.define_column(c,27, c_description, 240);

Line 816: DBMS_SQL.define_column(c,24, c_adjustment_id);

812: DBMS_SQL.define_column(c,20, c_type_flag, 20);
813: DBMS_SQL.define_column(c,21, c_inv_cust_trx_id );
814: DBMS_SQL.define_column(c,22, c_cust_trx_id );
815: DBMS_SQL.define_column(c,23, c_batch_source_id );
816: DBMS_SQL.define_column(c,24, c_adjustment_id);
817: DBMS_SQL.define_column(c,25, c_trx_line_id );
818: DBMS_SQL.define_column(c,26, c_line_number );
819: DBMS_SQL.define_column(c,27, c_description, 240);
820: DBMS_SQL.define_column(c,28, c_line_amount);

Line 817: DBMS_SQL.define_column(c,25, c_trx_line_id );

813: DBMS_SQL.define_column(c,21, c_inv_cust_trx_id );
814: DBMS_SQL.define_column(c,22, c_cust_trx_id );
815: DBMS_SQL.define_column(c,23, c_batch_source_id );
816: DBMS_SQL.define_column(c,24, c_adjustment_id);
817: DBMS_SQL.define_column(c,25, c_trx_line_id );
818: DBMS_SQL.define_column(c,26, c_line_number );
819: DBMS_SQL.define_column(c,27, c_description, 240);
820: DBMS_SQL.define_column(c,28, c_line_amount);
821: DBMS_SQL.define_column(c,29, c_tax_line_number);

Line 818: DBMS_SQL.define_column(c,26, c_line_number );

814: DBMS_SQL.define_column(c,22, c_cust_trx_id );
815: DBMS_SQL.define_column(c,23, c_batch_source_id );
816: DBMS_SQL.define_column(c,24, c_adjustment_id);
817: DBMS_SQL.define_column(c,25, c_trx_line_id );
818: DBMS_SQL.define_column(c,26, c_line_number );
819: DBMS_SQL.define_column(c,27, c_description, 240);
820: DBMS_SQL.define_column(c,28, c_line_amount);
821: DBMS_SQL.define_column(c,29, c_tax_line_number);
822: DBMS_SQL.define_column(c,30, c_tax_cust_trx_line_id);

Line 819: DBMS_SQL.define_column(c,27, c_description, 240);

815: DBMS_SQL.define_column(c,23, c_batch_source_id );
816: DBMS_SQL.define_column(c,24, c_adjustment_id);
817: DBMS_SQL.define_column(c,25, c_trx_line_id );
818: DBMS_SQL.define_column(c,26, c_line_number );
819: DBMS_SQL.define_column(c,27, c_description, 240);
820: DBMS_SQL.define_column(c,28, c_line_amount);
821: DBMS_SQL.define_column(c,29, c_tax_line_number);
822: DBMS_SQL.define_column(c,30, c_tax_cust_trx_line_id);
823: DBMS_SQL.define_column(c,31, c_tax_rate );

Line 820: DBMS_SQL.define_column(c,28, c_line_amount);

816: DBMS_SQL.define_column(c,24, c_adjustment_id);
817: DBMS_SQL.define_column(c,25, c_trx_line_id );
818: DBMS_SQL.define_column(c,26, c_line_number );
819: DBMS_SQL.define_column(c,27, c_description, 240);
820: DBMS_SQL.define_column(c,28, c_line_amount);
821: DBMS_SQL.define_column(c,29, c_tax_line_number);
822: DBMS_SQL.define_column(c,30, c_tax_cust_trx_line_id);
823: DBMS_SQL.define_column(c,31, c_tax_rate );
824: DBMS_SQL.define_column(c,32, c_vat_code, 50);

Line 821: DBMS_SQL.define_column(c,29, c_tax_line_number);

817: DBMS_SQL.define_column(c,25, c_trx_line_id );
818: DBMS_SQL.define_column(c,26, c_line_number );
819: DBMS_SQL.define_column(c,27, c_description, 240);
820: DBMS_SQL.define_column(c,28, c_line_amount);
821: DBMS_SQL.define_column(c,29, c_tax_line_number);
822: DBMS_SQL.define_column(c,30, c_tax_cust_trx_line_id);
823: DBMS_SQL.define_column(c,31, c_tax_rate );
824: DBMS_SQL.define_column(c,32, c_vat_code, 50);
825: DBMS_SQL.define_column(c,33, c_tax_vendor_return_code, 30);

Line 822: DBMS_SQL.define_column(c,30, c_tax_cust_trx_line_id);

818: DBMS_SQL.define_column(c,26, c_line_number );
819: DBMS_SQL.define_column(c,27, c_description, 240);
820: DBMS_SQL.define_column(c,28, c_line_amount);
821: DBMS_SQL.define_column(c,29, c_tax_line_number);
822: DBMS_SQL.define_column(c,30, c_tax_cust_trx_line_id);
823: DBMS_SQL.define_column(c,31, c_tax_rate );
824: DBMS_SQL.define_column(c,32, c_vat_code, 50);
825: DBMS_SQL.define_column(c,33, c_tax_vendor_return_code, 30);
826: DBMS_SQL.define_column(c,34, c_vat_code_type, 30);

Line 823: DBMS_SQL.define_column(c,31, c_tax_rate );

819: DBMS_SQL.define_column(c,27, c_description, 240);
820: DBMS_SQL.define_column(c,28, c_line_amount);
821: DBMS_SQL.define_column(c,29, c_tax_line_number);
822: DBMS_SQL.define_column(c,30, c_tax_cust_trx_line_id);
823: DBMS_SQL.define_column(c,31, c_tax_rate );
824: DBMS_SQL.define_column(c,32, c_vat_code, 50);
825: DBMS_SQL.define_column(c,33, c_tax_vendor_return_code, 30);
826: DBMS_SQL.define_column(c,34, c_vat_code_type, 30);
827: DBMS_SQL.define_column(c,35, c_exempt_number, 80);

Line 824: DBMS_SQL.define_column(c,32, c_vat_code, 50);

820: DBMS_SQL.define_column(c,28, c_line_amount);
821: DBMS_SQL.define_column(c,29, c_tax_line_number);
822: DBMS_SQL.define_column(c,30, c_tax_cust_trx_line_id);
823: DBMS_SQL.define_column(c,31, c_tax_rate );
824: DBMS_SQL.define_column(c,32, c_vat_code, 50);
825: DBMS_SQL.define_column(c,33, c_tax_vendor_return_code, 30);
826: DBMS_SQL.define_column(c,34, c_vat_code_type, 30);
827: DBMS_SQL.define_column(c,35, c_exempt_number, 80);
828: DBMS_SQL.define_column(c,36, c_exempt_reason, 80);

Line 825: DBMS_SQL.define_column(c,33, c_tax_vendor_return_code, 30);

821: DBMS_SQL.define_column(c,29, c_tax_line_number);
822: DBMS_SQL.define_column(c,30, c_tax_cust_trx_line_id);
823: DBMS_SQL.define_column(c,31, c_tax_rate );
824: DBMS_SQL.define_column(c,32, c_vat_code, 50);
825: DBMS_SQL.define_column(c,33, c_tax_vendor_return_code, 30);
826: DBMS_SQL.define_column(c,34, c_vat_code_type, 30);
827: DBMS_SQL.define_column(c,35, c_exempt_number, 80);
828: DBMS_SQL.define_column(c,36, c_exempt_reason, 80);
829: DBMS_SQL.define_column(c,37, c_exempt_percent );

Line 826: DBMS_SQL.define_column(c,34, c_vat_code_type, 30);

822: DBMS_SQL.define_column(c,30, c_tax_cust_trx_line_id);
823: DBMS_SQL.define_column(c,31, c_tax_rate );
824: DBMS_SQL.define_column(c,32, c_vat_code, 50);
825: DBMS_SQL.define_column(c,33, c_tax_vendor_return_code, 30);
826: DBMS_SQL.define_column(c,34, c_vat_code_type, 30);
827: DBMS_SQL.define_column(c,35, c_exempt_number, 80);
828: DBMS_SQL.define_column(c,36, c_exempt_reason, 80);
829: DBMS_SQL.define_column(c,37, c_exempt_percent );
830: DBMS_SQL.define_column(c,38, c_tax_amount);

Line 827: DBMS_SQL.define_column(c,35, c_exempt_number, 80);

823: DBMS_SQL.define_column(c,31, c_tax_rate );
824: DBMS_SQL.define_column(c,32, c_vat_code, 50);
825: DBMS_SQL.define_column(c,33, c_tax_vendor_return_code, 30);
826: DBMS_SQL.define_column(c,34, c_vat_code_type, 30);
827: DBMS_SQL.define_column(c,35, c_exempt_number, 80);
828: DBMS_SQL.define_column(c,36, c_exempt_reason, 80);
829: DBMS_SQL.define_column(c,37, c_exempt_percent );
830: DBMS_SQL.define_column(c,38, c_tax_amount);
831: DBMS_SQL.define_column(c,39, c_tax_except_percent);

Line 828: DBMS_SQL.define_column(c,36, c_exempt_reason, 80);

824: DBMS_SQL.define_column(c,32, c_vat_code, 50);
825: DBMS_SQL.define_column(c,33, c_tax_vendor_return_code, 30);
826: DBMS_SQL.define_column(c,34, c_vat_code_type, 30);
827: DBMS_SQL.define_column(c,35, c_exempt_number, 80);
828: DBMS_SQL.define_column(c,36, c_exempt_reason, 80);
829: DBMS_SQL.define_column(c,37, c_exempt_percent );
830: DBMS_SQL.define_column(c,38, c_tax_amount);
831: DBMS_SQL.define_column(c,39, c_tax_except_percent);
832: DBMS_SQL.define_column(c,40, c_tax_authority_id );

Line 829: DBMS_SQL.define_column(c,37, c_exempt_percent );

825: DBMS_SQL.define_column(c,33, c_tax_vendor_return_code, 30);
826: DBMS_SQL.define_column(c,34, c_vat_code_type, 30);
827: DBMS_SQL.define_column(c,35, c_exempt_number, 80);
828: DBMS_SQL.define_column(c,36, c_exempt_reason, 80);
829: DBMS_SQL.define_column(c,37, c_exempt_percent );
830: DBMS_SQL.define_column(c,38, c_tax_amount);
831: DBMS_SQL.define_column(c,39, c_tax_except_percent);
832: DBMS_SQL.define_column(c,40, c_tax_authority_id );
833: DBMS_SQL.define_column(c,41, c_tax_authority_zip_code, 60);

Line 830: DBMS_SQL.define_column(c,38, c_tax_amount);

826: DBMS_SQL.define_column(c,34, c_vat_code_type, 30);
827: DBMS_SQL.define_column(c,35, c_exempt_number, 80);
828: DBMS_SQL.define_column(c,36, c_exempt_reason, 80);
829: DBMS_SQL.define_column(c,37, c_exempt_percent );
830: DBMS_SQL.define_column(c,38, c_tax_amount);
831: DBMS_SQL.define_column(c,39, c_tax_except_percent);
832: DBMS_SQL.define_column(c,40, c_tax_authority_id );
833: DBMS_SQL.define_column(c,41, c_tax_authority_zip_code, 60);
834: DBMS_SQL.define_column(c,42, c_sales_tax_id );

Line 831: DBMS_SQL.define_column(c,39, c_tax_except_percent);

827: DBMS_SQL.define_column(c,35, c_exempt_number, 80);
828: DBMS_SQL.define_column(c,36, c_exempt_reason, 80);
829: DBMS_SQL.define_column(c,37, c_exempt_percent );
830: DBMS_SQL.define_column(c,38, c_tax_amount);
831: DBMS_SQL.define_column(c,39, c_tax_except_percent);
832: DBMS_SQL.define_column(c,40, c_tax_authority_id );
833: DBMS_SQL.define_column(c,41, c_tax_authority_zip_code, 60);
834: DBMS_SQL.define_column(c,42, c_sales_tax_id );
835: DBMS_SQL.define_column(c,43, c_gltax_inrange_flag,2);

Line 832: DBMS_SQL.define_column(c,40, c_tax_authority_id );

828: DBMS_SQL.define_column(c,36, c_exempt_reason, 80);
829: DBMS_SQL.define_column(c,37, c_exempt_percent );
830: DBMS_SQL.define_column(c,38, c_tax_amount);
831: DBMS_SQL.define_column(c,39, c_tax_except_percent);
832: DBMS_SQL.define_column(c,40, c_tax_authority_id );
833: DBMS_SQL.define_column(c,41, c_tax_authority_zip_code, 60);
834: DBMS_SQL.define_column(c,42, c_sales_tax_id );
835: DBMS_SQL.define_column(c,43, c_gltax_inrange_flag,2);
836: DBMS_SQL.define_column(c,44, c_posted,10);

Line 833: DBMS_SQL.define_column(c,41, c_tax_authority_zip_code, 60);

829: DBMS_SQL.define_column(c,37, c_exempt_percent );
830: DBMS_SQL.define_column(c,38, c_tax_amount);
831: DBMS_SQL.define_column(c,39, c_tax_except_percent);
832: DBMS_SQL.define_column(c,40, c_tax_authority_id );
833: DBMS_SQL.define_column(c,41, c_tax_authority_zip_code, 60);
834: DBMS_SQL.define_column(c,42, c_sales_tax_id );
835: DBMS_SQL.define_column(c,43, c_gltax_inrange_flag,2);
836: DBMS_SQL.define_column(c,44, c_posted,10);
837: DBMS_SQL.define_column(c,45, c_ship_to_customer_id);

Line 834: DBMS_SQL.define_column(c,42, c_sales_tax_id );

830: DBMS_SQL.define_column(c,38, c_tax_amount);
831: DBMS_SQL.define_column(c,39, c_tax_except_percent);
832: DBMS_SQL.define_column(c,40, c_tax_authority_id );
833: DBMS_SQL.define_column(c,41, c_tax_authority_zip_code, 60);
834: DBMS_SQL.define_column(c,42, c_sales_tax_id );
835: DBMS_SQL.define_column(c,43, c_gltax_inrange_flag,2);
836: DBMS_SQL.define_column(c,44, c_posted,10);
837: DBMS_SQL.define_column(c,45, c_ship_to_customer_id);
838: DBMS_SQL.define_column(c,46, c_ship_to_site_use_id);

Line 835: DBMS_SQL.define_column(c,43, c_gltax_inrange_flag,2);

831: DBMS_SQL.define_column(c,39, c_tax_except_percent);
832: DBMS_SQL.define_column(c,40, c_tax_authority_id );
833: DBMS_SQL.define_column(c,41, c_tax_authority_zip_code, 60);
834: DBMS_SQL.define_column(c,42, c_sales_tax_id );
835: DBMS_SQL.define_column(c,43, c_gltax_inrange_flag,2);
836: DBMS_SQL.define_column(c,44, c_posted,10);
837: DBMS_SQL.define_column(c,45, c_ship_to_customer_id);
838: DBMS_SQL.define_column(c,46, c_ship_to_site_use_id);
839: DBMS_SQL.define_column(c,47, c_bill_to_customer_id);

Line 836: DBMS_SQL.define_column(c,44, c_posted,10);

832: DBMS_SQL.define_column(c,40, c_tax_authority_id );
833: DBMS_SQL.define_column(c,41, c_tax_authority_zip_code, 60);
834: DBMS_SQL.define_column(c,42, c_sales_tax_id );
835: DBMS_SQL.define_column(c,43, c_gltax_inrange_flag,2);
836: DBMS_SQL.define_column(c,44, c_posted,10);
837: DBMS_SQL.define_column(c,45, c_ship_to_customer_id);
838: DBMS_SQL.define_column(c,46, c_ship_to_site_use_id);
839: DBMS_SQL.define_column(c,47, c_bill_to_customer_id);
840: DBMS_SQL.define_column(c,48, c_bill_to_site_use_id);

Line 837: DBMS_SQL.define_column(c,45, c_ship_to_customer_id);

833: DBMS_SQL.define_column(c,41, c_tax_authority_zip_code, 60);
834: DBMS_SQL.define_column(c,42, c_sales_tax_id );
835: DBMS_SQL.define_column(c,43, c_gltax_inrange_flag,2);
836: DBMS_SQL.define_column(c,44, c_posted,10);
837: DBMS_SQL.define_column(c,45, c_ship_to_customer_id);
838: DBMS_SQL.define_column(c,46, c_ship_to_site_use_id);
839: DBMS_SQL.define_column(c,47, c_bill_to_customer_id);
840: DBMS_SQL.define_column(c,48, c_bill_to_site_use_id);
841: DBMS_SQL.define_column(c,49, c_sold_to_customer_id);

Line 838: DBMS_SQL.define_column(c,46, c_ship_to_site_use_id);

834: DBMS_SQL.define_column(c,42, c_sales_tax_id );
835: DBMS_SQL.define_column(c,43, c_gltax_inrange_flag,2);
836: DBMS_SQL.define_column(c,44, c_posted,10);
837: DBMS_SQL.define_column(c,45, c_ship_to_customer_id);
838: DBMS_SQL.define_column(c,46, c_ship_to_site_use_id);
839: DBMS_SQL.define_column(c,47, c_bill_to_customer_id);
840: DBMS_SQL.define_column(c,48, c_bill_to_site_use_id);
841: DBMS_SQL.define_column(c,49, c_sold_to_customer_id);
842: DBMS_SQL.define_column(c,50, c_sold_to_site_use_id);

Line 839: DBMS_SQL.define_column(c,47, c_bill_to_customer_id);

835: DBMS_SQL.define_column(c,43, c_gltax_inrange_flag,2);
836: DBMS_SQL.define_column(c,44, c_posted,10);
837: DBMS_SQL.define_column(c,45, c_ship_to_customer_id);
838: DBMS_SQL.define_column(c,46, c_ship_to_site_use_id);
839: DBMS_SQL.define_column(c,47, c_bill_to_customer_id);
840: DBMS_SQL.define_column(c,48, c_bill_to_site_use_id);
841: DBMS_SQL.define_column(c,49, c_sold_to_customer_id);
842: DBMS_SQL.define_column(c,50, c_sold_to_site_use_id);
843: DBMS_SQL.define_column(c,51,c_waybill_number,50);

Line 840: DBMS_SQL.define_column(c,48, c_bill_to_site_use_id);

836: DBMS_SQL.define_column(c,44, c_posted,10);
837: DBMS_SQL.define_column(c,45, c_ship_to_customer_id);
838: DBMS_SQL.define_column(c,46, c_ship_to_site_use_id);
839: DBMS_SQL.define_column(c,47, c_bill_to_customer_id);
840: DBMS_SQL.define_column(c,48, c_bill_to_site_use_id);
841: DBMS_SQL.define_column(c,49, c_sold_to_customer_id);
842: DBMS_SQL.define_column(c,50, c_sold_to_site_use_id);
843: DBMS_SQL.define_column(c,51,c_waybill_number,50);
844: DBMS_SQL.define_column(c,52,c_purchase_order,50);

Line 841: DBMS_SQL.define_column(c,49, c_sold_to_customer_id);

837: DBMS_SQL.define_column(c,45, c_ship_to_customer_id);
838: DBMS_SQL.define_column(c,46, c_ship_to_site_use_id);
839: DBMS_SQL.define_column(c,47, c_bill_to_customer_id);
840: DBMS_SQL.define_column(c,48, c_bill_to_site_use_id);
841: DBMS_SQL.define_column(c,49, c_sold_to_customer_id);
842: DBMS_SQL.define_column(c,50, c_sold_to_site_use_id);
843: DBMS_SQL.define_column(c,51,c_waybill_number,50);
844: DBMS_SQL.define_column(c,52,c_purchase_order,50);
845: DBMS_SQL.define_column(c,53,c_purchase_order_revision,50);

Line 842: DBMS_SQL.define_column(c,50, c_sold_to_site_use_id);

838: DBMS_SQL.define_column(c,46, c_ship_to_site_use_id);
839: DBMS_SQL.define_column(c,47, c_bill_to_customer_id);
840: DBMS_SQL.define_column(c,48, c_bill_to_site_use_id);
841: DBMS_SQL.define_column(c,49, c_sold_to_customer_id);
842: DBMS_SQL.define_column(c,50, c_sold_to_site_use_id);
843: DBMS_SQL.define_column(c,51,c_waybill_number,50);
844: DBMS_SQL.define_column(c,52,c_purchase_order,50);
845: DBMS_SQL.define_column(c,53,c_purchase_order_revision,50);
846: DBMS_SQL.define_column(c,54,c_exchange_rate_type,50);

Line 843: DBMS_SQL.define_column(c,51,c_waybill_number,50);

839: DBMS_SQL.define_column(c,47, c_bill_to_customer_id);
840: DBMS_SQL.define_column(c,48, c_bill_to_site_use_id);
841: DBMS_SQL.define_column(c,49, c_sold_to_customer_id);
842: DBMS_SQL.define_column(c,50, c_sold_to_site_use_id);
843: DBMS_SQL.define_column(c,51,c_waybill_number,50);
844: DBMS_SQL.define_column(c,52,c_purchase_order,50);
845: DBMS_SQL.define_column(c,53,c_purchase_order_revision,50);
846: DBMS_SQL.define_column(c,54,c_exchange_rate_type,50);
847: DBMS_SQL.define_column(c,55,c_exchange_rate_date);

Line 844: DBMS_SQL.define_column(c,52,c_purchase_order,50);

840: DBMS_SQL.define_column(c,48, c_bill_to_site_use_id);
841: DBMS_SQL.define_column(c,49, c_sold_to_customer_id);
842: DBMS_SQL.define_column(c,50, c_sold_to_site_use_id);
843: DBMS_SQL.define_column(c,51,c_waybill_number,50);
844: DBMS_SQL.define_column(c,52,c_purchase_order,50);
845: DBMS_SQL.define_column(c,53,c_purchase_order_revision,50);
846: DBMS_SQL.define_column(c,54,c_exchange_rate_type,50);
847: DBMS_SQL.define_column(c,55,c_exchange_rate_date);
848: DBMS_SQL.define_column(c,56,c_exchange_rate);

Line 845: DBMS_SQL.define_column(c,53,c_purchase_order_revision,50);

841: DBMS_SQL.define_column(c,49, c_sold_to_customer_id);
842: DBMS_SQL.define_column(c,50, c_sold_to_site_use_id);
843: DBMS_SQL.define_column(c,51,c_waybill_number,50);
844: DBMS_SQL.define_column(c,52,c_purchase_order,50);
845: DBMS_SQL.define_column(c,53,c_purchase_order_revision,50);
846: DBMS_SQL.define_column(c,54,c_exchange_rate_type,50);
847: DBMS_SQL.define_column(c,55,c_exchange_rate_date);
848: DBMS_SQL.define_column(c,56,c_exchange_rate);
849: DBMS_SQL.define_column(c,57,c_ship_via,30);

Line 846: DBMS_SQL.define_column(c,54,c_exchange_rate_type,50);

842: DBMS_SQL.define_column(c,50, c_sold_to_site_use_id);
843: DBMS_SQL.define_column(c,51,c_waybill_number,50);
844: DBMS_SQL.define_column(c,52,c_purchase_order,50);
845: DBMS_SQL.define_column(c,53,c_purchase_order_revision,50);
846: DBMS_SQL.define_column(c,54,c_exchange_rate_type,50);
847: DBMS_SQL.define_column(c,55,c_exchange_rate_date);
848: DBMS_SQL.define_column(c,56,c_exchange_rate);
849: DBMS_SQL.define_column(c,57,c_ship_via,30);
850: DBMS_SQL.define_column(c,58,c_uom_code,3);

Line 847: DBMS_SQL.define_column(c,55,c_exchange_rate_date);

843: DBMS_SQL.define_column(c,51,c_waybill_number,50);
844: DBMS_SQL.define_column(c,52,c_purchase_order,50);
845: DBMS_SQL.define_column(c,53,c_purchase_order_revision,50);
846: DBMS_SQL.define_column(c,54,c_exchange_rate_type,50);
847: DBMS_SQL.define_column(c,55,c_exchange_rate_date);
848: DBMS_SQL.define_column(c,56,c_exchange_rate);
849: DBMS_SQL.define_column(c,57,c_ship_via,30);
850: DBMS_SQL.define_column(c,58,c_uom_code,3);
851: DBMS_SQL.define_column(c,59,c_quantity_invoiced);

Line 848: DBMS_SQL.define_column(c,56,c_exchange_rate);

844: DBMS_SQL.define_column(c,52,c_purchase_order,50);
845: DBMS_SQL.define_column(c,53,c_purchase_order_revision,50);
846: DBMS_SQL.define_column(c,54,c_exchange_rate_type,50);
847: DBMS_SQL.define_column(c,55,c_exchange_rate_date);
848: DBMS_SQL.define_column(c,56,c_exchange_rate);
849: DBMS_SQL.define_column(c,57,c_ship_via,30);
850: DBMS_SQL.define_column(c,58,c_uom_code,3);
851: DBMS_SQL.define_column(c,59,c_quantity_invoiced);
852: DBMS_SQL.define_column(c,60,c_unit_selling_price);

Line 849: DBMS_SQL.define_column(c,57,c_ship_via,30);

845: DBMS_SQL.define_column(c,53,c_purchase_order_revision,50);
846: DBMS_SQL.define_column(c,54,c_exchange_rate_type,50);
847: DBMS_SQL.define_column(c,55,c_exchange_rate_date);
848: DBMS_SQL.define_column(c,56,c_exchange_rate);
849: DBMS_SQL.define_column(c,57,c_ship_via,30);
850: DBMS_SQL.define_column(c,58,c_uom_code,3);
851: DBMS_SQL.define_column(c,59,c_quantity_invoiced);
852: DBMS_SQL.define_column(c,60,c_unit_selling_price);
853: DBMS_SQL.define_column(c,61,c_tax_precedence);

Line 850: DBMS_SQL.define_column(c,58,c_uom_code,3);

846: DBMS_SQL.define_column(c,54,c_exchange_rate_type,50);
847: DBMS_SQL.define_column(c,55,c_exchange_rate_date);
848: DBMS_SQL.define_column(c,56,c_exchange_rate);
849: DBMS_SQL.define_column(c,57,c_ship_via,30);
850: DBMS_SQL.define_column(c,58,c_uom_code,3);
851: DBMS_SQL.define_column(c,59,c_quantity_invoiced);
852: DBMS_SQL.define_column(c,60,c_unit_selling_price);
853: DBMS_SQL.define_column(c,61,c_tax_precedence);
854: DBMS_SQL.define_column(c,62,c_sales_order_source,50);

Line 851: DBMS_SQL.define_column(c,59,c_quantity_invoiced);

847: DBMS_SQL.define_column(c,55,c_exchange_rate_date);
848: DBMS_SQL.define_column(c,56,c_exchange_rate);
849: DBMS_SQL.define_column(c,57,c_ship_via,30);
850: DBMS_SQL.define_column(c,58,c_uom_code,3);
851: DBMS_SQL.define_column(c,59,c_quantity_invoiced);
852: DBMS_SQL.define_column(c,60,c_unit_selling_price);
853: DBMS_SQL.define_column(c,61,c_tax_precedence);
854: DBMS_SQL.define_column(c,62,c_sales_order_source,50);
855: DBMS_SQL.define_column(c,63,c_sales_order,50);

Line 852: DBMS_SQL.define_column(c,60,c_unit_selling_price);

848: DBMS_SQL.define_column(c,56,c_exchange_rate);
849: DBMS_SQL.define_column(c,57,c_ship_via,30);
850: DBMS_SQL.define_column(c,58,c_uom_code,3);
851: DBMS_SQL.define_column(c,59,c_quantity_invoiced);
852: DBMS_SQL.define_column(c,60,c_unit_selling_price);
853: DBMS_SQL.define_column(c,61,c_tax_precedence);
854: DBMS_SQL.define_column(c,62,c_sales_order_source,50);
855: DBMS_SQL.define_column(c,63,c_sales_order,50);
856: DBMS_SQL.define_column(c,64,c_sales_order_revision);

Line 853: DBMS_SQL.define_column(c,61,c_tax_precedence);

849: DBMS_SQL.define_column(c,57,c_ship_via,30);
850: DBMS_SQL.define_column(c,58,c_uom_code,3);
851: DBMS_SQL.define_column(c,59,c_quantity_invoiced);
852: DBMS_SQL.define_column(c,60,c_unit_selling_price);
853: DBMS_SQL.define_column(c,61,c_tax_precedence);
854: DBMS_SQL.define_column(c,62,c_sales_order_source,50);
855: DBMS_SQL.define_column(c,63,c_sales_order,50);
856: DBMS_SQL.define_column(c,64,c_sales_order_revision);
857: DBMS_SQL.define_column(c,65,c_sales_order_line);

Line 854: DBMS_SQL.define_column(c,62,c_sales_order_source,50);

850: DBMS_SQL.define_column(c,58,c_uom_code,3);
851: DBMS_SQL.define_column(c,59,c_quantity_invoiced);
852: DBMS_SQL.define_column(c,60,c_unit_selling_price);
853: DBMS_SQL.define_column(c,61,c_tax_precedence);
854: DBMS_SQL.define_column(c,62,c_sales_order_source,50);
855: DBMS_SQL.define_column(c,63,c_sales_order,50);
856: DBMS_SQL.define_column(c,64,c_sales_order_revision);
857: DBMS_SQL.define_column(c,65,c_sales_order_line);
858: DBMS_SQL.define_column(c,66,c_sales_order_date);

Line 855: DBMS_SQL.define_column(c,63,c_sales_order,50);

851: DBMS_SQL.define_column(c,59,c_quantity_invoiced);
852: DBMS_SQL.define_column(c,60,c_unit_selling_price);
853: DBMS_SQL.define_column(c,61,c_tax_precedence);
854: DBMS_SQL.define_column(c,62,c_sales_order_source,50);
855: DBMS_SQL.define_column(c,63,c_sales_order,50);
856: DBMS_SQL.define_column(c,64,c_sales_order_revision);
857: DBMS_SQL.define_column(c,65,c_sales_order_line);
858: DBMS_SQL.define_column(c,66,c_sales_order_date);
859: DBMS_SQL.define_column(c,67,c_inventory_item_id);

Line 856: DBMS_SQL.define_column(c,64,c_sales_order_revision);

852: DBMS_SQL.define_column(c,60,c_unit_selling_price);
853: DBMS_SQL.define_column(c,61,c_tax_precedence);
854: DBMS_SQL.define_column(c,62,c_sales_order_source,50);
855: DBMS_SQL.define_column(c,63,c_sales_order,50);
856: DBMS_SQL.define_column(c,64,c_sales_order_revision);
857: DBMS_SQL.define_column(c,65,c_sales_order_line);
858: DBMS_SQL.define_column(c,66,c_sales_order_date);
859: DBMS_SQL.define_column(c,67,c_inventory_item_id);
860: DBMS_SQL.define_column(c,68,c_header_category,150);

Line 857: DBMS_SQL.define_column(c,65,c_sales_order_line);

853: DBMS_SQL.define_column(c,61,c_tax_precedence);
854: DBMS_SQL.define_column(c,62,c_sales_order_source,50);
855: DBMS_SQL.define_column(c,63,c_sales_order,50);
856: DBMS_SQL.define_column(c,64,c_sales_order_revision);
857: DBMS_SQL.define_column(c,65,c_sales_order_line);
858: DBMS_SQL.define_column(c,66,c_sales_order_date);
859: DBMS_SQL.define_column(c,67,c_inventory_item_id);
860: DBMS_SQL.define_column(c,68,c_header_category,150);
861: DBMS_SQL.define_column(c,69,c_header_attr1,150);

Line 858: DBMS_SQL.define_column(c,66,c_sales_order_date);

854: DBMS_SQL.define_column(c,62,c_sales_order_source,50);
855: DBMS_SQL.define_column(c,63,c_sales_order,50);
856: DBMS_SQL.define_column(c,64,c_sales_order_revision);
857: DBMS_SQL.define_column(c,65,c_sales_order_line);
858: DBMS_SQL.define_column(c,66,c_sales_order_date);
859: DBMS_SQL.define_column(c,67,c_inventory_item_id);
860: DBMS_SQL.define_column(c,68,c_header_category,150);
861: DBMS_SQL.define_column(c,69,c_header_attr1,150);
862: DBMS_SQL.define_column(c,70,c_header_attr2,150);

Line 859: DBMS_SQL.define_column(c,67,c_inventory_item_id);

855: DBMS_SQL.define_column(c,63,c_sales_order,50);
856: DBMS_SQL.define_column(c,64,c_sales_order_revision);
857: DBMS_SQL.define_column(c,65,c_sales_order_line);
858: DBMS_SQL.define_column(c,66,c_sales_order_date);
859: DBMS_SQL.define_column(c,67,c_inventory_item_id);
860: DBMS_SQL.define_column(c,68,c_header_category,150);
861: DBMS_SQL.define_column(c,69,c_header_attr1,150);
862: DBMS_SQL.define_column(c,70,c_header_attr2,150);
863: DBMS_SQL.define_column(c,71,c_header_attr3,150);

Line 860: DBMS_SQL.define_column(c,68,c_header_category,150);

856: DBMS_SQL.define_column(c,64,c_sales_order_revision);
857: DBMS_SQL.define_column(c,65,c_sales_order_line);
858: DBMS_SQL.define_column(c,66,c_sales_order_date);
859: DBMS_SQL.define_column(c,67,c_inventory_item_id);
860: DBMS_SQL.define_column(c,68,c_header_category,150);
861: DBMS_SQL.define_column(c,69,c_header_attr1,150);
862: DBMS_SQL.define_column(c,70,c_header_attr2,150);
863: DBMS_SQL.define_column(c,71,c_header_attr3,150);
864: DBMS_SQL.define_column(c,72,c_header_attr4,150);

Line 861: DBMS_SQL.define_column(c,69,c_header_attr1,150);

857: DBMS_SQL.define_column(c,65,c_sales_order_line);
858: DBMS_SQL.define_column(c,66,c_sales_order_date);
859: DBMS_SQL.define_column(c,67,c_inventory_item_id);
860: DBMS_SQL.define_column(c,68,c_header_category,150);
861: DBMS_SQL.define_column(c,69,c_header_attr1,150);
862: DBMS_SQL.define_column(c,70,c_header_attr2,150);
863: DBMS_SQL.define_column(c,71,c_header_attr3,150);
864: DBMS_SQL.define_column(c,72,c_header_attr4,150);
865: DBMS_SQL.define_column(c,73,c_header_attr5,150);

Line 862: DBMS_SQL.define_column(c,70,c_header_attr2,150);

858: DBMS_SQL.define_column(c,66,c_sales_order_date);
859: DBMS_SQL.define_column(c,67,c_inventory_item_id);
860: DBMS_SQL.define_column(c,68,c_header_category,150);
861: DBMS_SQL.define_column(c,69,c_header_attr1,150);
862: DBMS_SQL.define_column(c,70,c_header_attr2,150);
863: DBMS_SQL.define_column(c,71,c_header_attr3,150);
864: DBMS_SQL.define_column(c,72,c_header_attr4,150);
865: DBMS_SQL.define_column(c,73,c_header_attr5,150);
866: DBMS_SQL.define_column(c,74,c_header_attr6,150);

Line 863: DBMS_SQL.define_column(c,71,c_header_attr3,150);

859: DBMS_SQL.define_column(c,67,c_inventory_item_id);
860: DBMS_SQL.define_column(c,68,c_header_category,150);
861: DBMS_SQL.define_column(c,69,c_header_attr1,150);
862: DBMS_SQL.define_column(c,70,c_header_attr2,150);
863: DBMS_SQL.define_column(c,71,c_header_attr3,150);
864: DBMS_SQL.define_column(c,72,c_header_attr4,150);
865: DBMS_SQL.define_column(c,73,c_header_attr5,150);
866: DBMS_SQL.define_column(c,74,c_header_attr6,150);
867: DBMS_SQL.define_column(c,75,c_header_attr7,150);

Line 864: DBMS_SQL.define_column(c,72,c_header_attr4,150);

860: DBMS_SQL.define_column(c,68,c_header_category,150);
861: DBMS_SQL.define_column(c,69,c_header_attr1,150);
862: DBMS_SQL.define_column(c,70,c_header_attr2,150);
863: DBMS_SQL.define_column(c,71,c_header_attr3,150);
864: DBMS_SQL.define_column(c,72,c_header_attr4,150);
865: DBMS_SQL.define_column(c,73,c_header_attr5,150);
866: DBMS_SQL.define_column(c,74,c_header_attr6,150);
867: DBMS_SQL.define_column(c,75,c_header_attr7,150);
868: DBMS_SQL.define_column(c,76,c_header_attr8,150);

Line 865: DBMS_SQL.define_column(c,73,c_header_attr5,150);

861: DBMS_SQL.define_column(c,69,c_header_attr1,150);
862: DBMS_SQL.define_column(c,70,c_header_attr2,150);
863: DBMS_SQL.define_column(c,71,c_header_attr3,150);
864: DBMS_SQL.define_column(c,72,c_header_attr4,150);
865: DBMS_SQL.define_column(c,73,c_header_attr5,150);
866: DBMS_SQL.define_column(c,74,c_header_attr6,150);
867: DBMS_SQL.define_column(c,75,c_header_attr7,150);
868: DBMS_SQL.define_column(c,76,c_header_attr8,150);
869: DBMS_SQL.define_column(c,77,c_header_attr9,150);

Line 866: DBMS_SQL.define_column(c,74,c_header_attr6,150);

862: DBMS_SQL.define_column(c,70,c_header_attr2,150);
863: DBMS_SQL.define_column(c,71,c_header_attr3,150);
864: DBMS_SQL.define_column(c,72,c_header_attr4,150);
865: DBMS_SQL.define_column(c,73,c_header_attr5,150);
866: DBMS_SQL.define_column(c,74,c_header_attr6,150);
867: DBMS_SQL.define_column(c,75,c_header_attr7,150);
868: DBMS_SQL.define_column(c,76,c_header_attr8,150);
869: DBMS_SQL.define_column(c,77,c_header_attr9,150);
870: DBMS_SQL.define_column(c,78,c_header_attr10,150);

Line 867: DBMS_SQL.define_column(c,75,c_header_attr7,150);

863: DBMS_SQL.define_column(c,71,c_header_attr3,150);
864: DBMS_SQL.define_column(c,72,c_header_attr4,150);
865: DBMS_SQL.define_column(c,73,c_header_attr5,150);
866: DBMS_SQL.define_column(c,74,c_header_attr6,150);
867: DBMS_SQL.define_column(c,75,c_header_attr7,150);
868: DBMS_SQL.define_column(c,76,c_header_attr8,150);
869: DBMS_SQL.define_column(c,77,c_header_attr9,150);
870: DBMS_SQL.define_column(c,78,c_header_attr10,150);
871: DBMS_SQL.define_column(c,79,c_header_attr11,150);

Line 868: DBMS_SQL.define_column(c,76,c_header_attr8,150);

864: DBMS_SQL.define_column(c,72,c_header_attr4,150);
865: DBMS_SQL.define_column(c,73,c_header_attr5,150);
866: DBMS_SQL.define_column(c,74,c_header_attr6,150);
867: DBMS_SQL.define_column(c,75,c_header_attr7,150);
868: DBMS_SQL.define_column(c,76,c_header_attr8,150);
869: DBMS_SQL.define_column(c,77,c_header_attr9,150);
870: DBMS_SQL.define_column(c,78,c_header_attr10,150);
871: DBMS_SQL.define_column(c,79,c_header_attr11,150);
872: DBMS_SQL.define_column(c,80,c_header_attr12,150);

Line 869: DBMS_SQL.define_column(c,77,c_header_attr9,150);

865: DBMS_SQL.define_column(c,73,c_header_attr5,150);
866: DBMS_SQL.define_column(c,74,c_header_attr6,150);
867: DBMS_SQL.define_column(c,75,c_header_attr7,150);
868: DBMS_SQL.define_column(c,76,c_header_attr8,150);
869: DBMS_SQL.define_column(c,77,c_header_attr9,150);
870: DBMS_SQL.define_column(c,78,c_header_attr10,150);
871: DBMS_SQL.define_column(c,79,c_header_attr11,150);
872: DBMS_SQL.define_column(c,80,c_header_attr12,150);
873: DBMS_SQL.define_column(c,81,c_header_attr13,150);

Line 870: DBMS_SQL.define_column(c,78,c_header_attr10,150);

866: DBMS_SQL.define_column(c,74,c_header_attr6,150);
867: DBMS_SQL.define_column(c,75,c_header_attr7,150);
868: DBMS_SQL.define_column(c,76,c_header_attr8,150);
869: DBMS_SQL.define_column(c,77,c_header_attr9,150);
870: DBMS_SQL.define_column(c,78,c_header_attr10,150);
871: DBMS_SQL.define_column(c,79,c_header_attr11,150);
872: DBMS_SQL.define_column(c,80,c_header_attr12,150);
873: DBMS_SQL.define_column(c,81,c_header_attr13,150);
874: DBMS_SQL.define_column(c,82,c_header_attr14,150);

Line 871: DBMS_SQL.define_column(c,79,c_header_attr11,150);

867: DBMS_SQL.define_column(c,75,c_header_attr7,150);
868: DBMS_SQL.define_column(c,76,c_header_attr8,150);
869: DBMS_SQL.define_column(c,77,c_header_attr9,150);
870: DBMS_SQL.define_column(c,78,c_header_attr10,150);
871: DBMS_SQL.define_column(c,79,c_header_attr11,150);
872: DBMS_SQL.define_column(c,80,c_header_attr12,150);
873: DBMS_SQL.define_column(c,81,c_header_attr13,150);
874: DBMS_SQL.define_column(c,82,c_header_attr14,150);
875: DBMS_SQL.define_column(c,83,c_header_attr15,150);

Line 872: DBMS_SQL.define_column(c,80,c_header_attr12,150);

868: DBMS_SQL.define_column(c,76,c_header_attr8,150);
869: DBMS_SQL.define_column(c,77,c_header_attr9,150);
870: DBMS_SQL.define_column(c,78,c_header_attr10,150);
871: DBMS_SQL.define_column(c,79,c_header_attr11,150);
872: DBMS_SQL.define_column(c,80,c_header_attr12,150);
873: DBMS_SQL.define_column(c,81,c_header_attr13,150);
874: DBMS_SQL.define_column(c,82,c_header_attr14,150);
875: DBMS_SQL.define_column(c,83,c_header_attr15,150);
876: DBMS_SQL.define_column(c,84,c_line_category,150);

Line 873: DBMS_SQL.define_column(c,81,c_header_attr13,150);

869: DBMS_SQL.define_column(c,77,c_header_attr9,150);
870: DBMS_SQL.define_column(c,78,c_header_attr10,150);
871: DBMS_SQL.define_column(c,79,c_header_attr11,150);
872: DBMS_SQL.define_column(c,80,c_header_attr12,150);
873: DBMS_SQL.define_column(c,81,c_header_attr13,150);
874: DBMS_SQL.define_column(c,82,c_header_attr14,150);
875: DBMS_SQL.define_column(c,83,c_header_attr15,150);
876: DBMS_SQL.define_column(c,84,c_line_category,150);
877: DBMS_SQL.define_column(c,85,c_line_attr1,150);

Line 874: DBMS_SQL.define_column(c,82,c_header_attr14,150);

870: DBMS_SQL.define_column(c,78,c_header_attr10,150);
871: DBMS_SQL.define_column(c,79,c_header_attr11,150);
872: DBMS_SQL.define_column(c,80,c_header_attr12,150);
873: DBMS_SQL.define_column(c,81,c_header_attr13,150);
874: DBMS_SQL.define_column(c,82,c_header_attr14,150);
875: DBMS_SQL.define_column(c,83,c_header_attr15,150);
876: DBMS_SQL.define_column(c,84,c_line_category,150);
877: DBMS_SQL.define_column(c,85,c_line_attr1,150);
878: DBMS_SQL.define_column(c,86,c_line_attr2,150);

Line 875: DBMS_SQL.define_column(c,83,c_header_attr15,150);

871: DBMS_SQL.define_column(c,79,c_header_attr11,150);
872: DBMS_SQL.define_column(c,80,c_header_attr12,150);
873: DBMS_SQL.define_column(c,81,c_header_attr13,150);
874: DBMS_SQL.define_column(c,82,c_header_attr14,150);
875: DBMS_SQL.define_column(c,83,c_header_attr15,150);
876: DBMS_SQL.define_column(c,84,c_line_category,150);
877: DBMS_SQL.define_column(c,85,c_line_attr1,150);
878: DBMS_SQL.define_column(c,86,c_line_attr2,150);
879: DBMS_SQL.define_column(c,87,c_line_attr3,150);

Line 876: DBMS_SQL.define_column(c,84,c_line_category,150);

872: DBMS_SQL.define_column(c,80,c_header_attr12,150);
873: DBMS_SQL.define_column(c,81,c_header_attr13,150);
874: DBMS_SQL.define_column(c,82,c_header_attr14,150);
875: DBMS_SQL.define_column(c,83,c_header_attr15,150);
876: DBMS_SQL.define_column(c,84,c_line_category,150);
877: DBMS_SQL.define_column(c,85,c_line_attr1,150);
878: DBMS_SQL.define_column(c,86,c_line_attr2,150);
879: DBMS_SQL.define_column(c,87,c_line_attr3,150);
880: DBMS_SQL.define_column(c,88,c_line_attr4,150);

Line 877: DBMS_SQL.define_column(c,85,c_line_attr1,150);

873: DBMS_SQL.define_column(c,81,c_header_attr13,150);
874: DBMS_SQL.define_column(c,82,c_header_attr14,150);
875: DBMS_SQL.define_column(c,83,c_header_attr15,150);
876: DBMS_SQL.define_column(c,84,c_line_category,150);
877: DBMS_SQL.define_column(c,85,c_line_attr1,150);
878: DBMS_SQL.define_column(c,86,c_line_attr2,150);
879: DBMS_SQL.define_column(c,87,c_line_attr3,150);
880: DBMS_SQL.define_column(c,88,c_line_attr4,150);
881: DBMS_SQL.define_column(c,89,c_line_attr5,150);

Line 878: DBMS_SQL.define_column(c,86,c_line_attr2,150);

874: DBMS_SQL.define_column(c,82,c_header_attr14,150);
875: DBMS_SQL.define_column(c,83,c_header_attr15,150);
876: DBMS_SQL.define_column(c,84,c_line_category,150);
877: DBMS_SQL.define_column(c,85,c_line_attr1,150);
878: DBMS_SQL.define_column(c,86,c_line_attr2,150);
879: DBMS_SQL.define_column(c,87,c_line_attr3,150);
880: DBMS_SQL.define_column(c,88,c_line_attr4,150);
881: DBMS_SQL.define_column(c,89,c_line_attr5,150);
882: DBMS_SQL.define_column(c,90,c_line_attr6,150);

Line 879: DBMS_SQL.define_column(c,87,c_line_attr3,150);

875: DBMS_SQL.define_column(c,83,c_header_attr15,150);
876: DBMS_SQL.define_column(c,84,c_line_category,150);
877: DBMS_SQL.define_column(c,85,c_line_attr1,150);
878: DBMS_SQL.define_column(c,86,c_line_attr2,150);
879: DBMS_SQL.define_column(c,87,c_line_attr3,150);
880: DBMS_SQL.define_column(c,88,c_line_attr4,150);
881: DBMS_SQL.define_column(c,89,c_line_attr5,150);
882: DBMS_SQL.define_column(c,90,c_line_attr6,150);
883: DBMS_SQL.define_column(c,91,c_line_attr7,150);

Line 880: DBMS_SQL.define_column(c,88,c_line_attr4,150);

876: DBMS_SQL.define_column(c,84,c_line_category,150);
877: DBMS_SQL.define_column(c,85,c_line_attr1,150);
878: DBMS_SQL.define_column(c,86,c_line_attr2,150);
879: DBMS_SQL.define_column(c,87,c_line_attr3,150);
880: DBMS_SQL.define_column(c,88,c_line_attr4,150);
881: DBMS_SQL.define_column(c,89,c_line_attr5,150);
882: DBMS_SQL.define_column(c,90,c_line_attr6,150);
883: DBMS_SQL.define_column(c,91,c_line_attr7,150);
884: DBMS_SQL.define_column(c,92,c_line_attr8,150);

Line 881: DBMS_SQL.define_column(c,89,c_line_attr5,150);

877: DBMS_SQL.define_column(c,85,c_line_attr1,150);
878: DBMS_SQL.define_column(c,86,c_line_attr2,150);
879: DBMS_SQL.define_column(c,87,c_line_attr3,150);
880: DBMS_SQL.define_column(c,88,c_line_attr4,150);
881: DBMS_SQL.define_column(c,89,c_line_attr5,150);
882: DBMS_SQL.define_column(c,90,c_line_attr6,150);
883: DBMS_SQL.define_column(c,91,c_line_attr7,150);
884: DBMS_SQL.define_column(c,92,c_line_attr8,150);
885: DBMS_SQL.define_column(c,93,c_line_attr9,150);

Line 882: DBMS_SQL.define_column(c,90,c_line_attr6,150);

878: DBMS_SQL.define_column(c,86,c_line_attr2,150);
879: DBMS_SQL.define_column(c,87,c_line_attr3,150);
880: DBMS_SQL.define_column(c,88,c_line_attr4,150);
881: DBMS_SQL.define_column(c,89,c_line_attr5,150);
882: DBMS_SQL.define_column(c,90,c_line_attr6,150);
883: DBMS_SQL.define_column(c,91,c_line_attr7,150);
884: DBMS_SQL.define_column(c,92,c_line_attr8,150);
885: DBMS_SQL.define_column(c,93,c_line_attr9,150);
886: DBMS_SQL.define_column(c,94,c_line_attr10,150);

Line 883: DBMS_SQL.define_column(c,91,c_line_attr7,150);

879: DBMS_SQL.define_column(c,87,c_line_attr3,150);
880: DBMS_SQL.define_column(c,88,c_line_attr4,150);
881: DBMS_SQL.define_column(c,89,c_line_attr5,150);
882: DBMS_SQL.define_column(c,90,c_line_attr6,150);
883: DBMS_SQL.define_column(c,91,c_line_attr7,150);
884: DBMS_SQL.define_column(c,92,c_line_attr8,150);
885: DBMS_SQL.define_column(c,93,c_line_attr9,150);
886: DBMS_SQL.define_column(c,94,c_line_attr10,150);
887: DBMS_SQL.define_column(c,95,c_line_attr11,150);

Line 884: DBMS_SQL.define_column(c,92,c_line_attr8,150);

880: DBMS_SQL.define_column(c,88,c_line_attr4,150);
881: DBMS_SQL.define_column(c,89,c_line_attr5,150);
882: DBMS_SQL.define_column(c,90,c_line_attr6,150);
883: DBMS_SQL.define_column(c,91,c_line_attr7,150);
884: DBMS_SQL.define_column(c,92,c_line_attr8,150);
885: DBMS_SQL.define_column(c,93,c_line_attr9,150);
886: DBMS_SQL.define_column(c,94,c_line_attr10,150);
887: DBMS_SQL.define_column(c,95,c_line_attr11,150);
888: DBMS_SQL.define_column(c,96,c_line_attr12,150);

Line 885: DBMS_SQL.define_column(c,93,c_line_attr9,150);

881: DBMS_SQL.define_column(c,89,c_line_attr5,150);
882: DBMS_SQL.define_column(c,90,c_line_attr6,150);
883: DBMS_SQL.define_column(c,91,c_line_attr7,150);
884: DBMS_SQL.define_column(c,92,c_line_attr8,150);
885: DBMS_SQL.define_column(c,93,c_line_attr9,150);
886: DBMS_SQL.define_column(c,94,c_line_attr10,150);
887: DBMS_SQL.define_column(c,95,c_line_attr11,150);
888: DBMS_SQL.define_column(c,96,c_line_attr12,150);
889: DBMS_SQL.define_column(c,97,c_line_attr13,150);

Line 886: DBMS_SQL.define_column(c,94,c_line_attr10,150);

882: DBMS_SQL.define_column(c,90,c_line_attr6,150);
883: DBMS_SQL.define_column(c,91,c_line_attr7,150);
884: DBMS_SQL.define_column(c,92,c_line_attr8,150);
885: DBMS_SQL.define_column(c,93,c_line_attr9,150);
886: DBMS_SQL.define_column(c,94,c_line_attr10,150);
887: DBMS_SQL.define_column(c,95,c_line_attr11,150);
888: DBMS_SQL.define_column(c,96,c_line_attr12,150);
889: DBMS_SQL.define_column(c,97,c_line_attr13,150);
890: DBMS_SQL.define_column(c,98,c_line_attr14,150);

Line 887: DBMS_SQL.define_column(c,95,c_line_attr11,150);

883: DBMS_SQL.define_column(c,91,c_line_attr7,150);
884: DBMS_SQL.define_column(c,92,c_line_attr8,150);
885: DBMS_SQL.define_column(c,93,c_line_attr9,150);
886: DBMS_SQL.define_column(c,94,c_line_attr10,150);
887: DBMS_SQL.define_column(c,95,c_line_attr11,150);
888: DBMS_SQL.define_column(c,96,c_line_attr12,150);
889: DBMS_SQL.define_column(c,97,c_line_attr13,150);
890: DBMS_SQL.define_column(c,98,c_line_attr14,150);
891: DBMS_SQL.define_column(c,99,c_line_attr15,150);

Line 888: DBMS_SQL.define_column(c,96,c_line_attr12,150);

884: DBMS_SQL.define_column(c,92,c_line_attr8,150);
885: DBMS_SQL.define_column(c,93,c_line_attr9,150);
886: DBMS_SQL.define_column(c,94,c_line_attr10,150);
887: DBMS_SQL.define_column(c,95,c_line_attr11,150);
888: DBMS_SQL.define_column(c,96,c_line_attr12,150);
889: DBMS_SQL.define_column(c,97,c_line_attr13,150);
890: DBMS_SQL.define_column(c,98,c_line_attr14,150);
891: DBMS_SQL.define_column(c,99,c_line_attr15,150);
892: DBMS_SQL.define_column(c,100,c_type_name,20);

Line 889: DBMS_SQL.define_column(c,97,c_line_attr13,150);

885: DBMS_SQL.define_column(c,93,c_line_attr9,150);
886: DBMS_SQL.define_column(c,94,c_line_attr10,150);
887: DBMS_SQL.define_column(c,95,c_line_attr11,150);
888: DBMS_SQL.define_column(c,96,c_line_attr12,150);
889: DBMS_SQL.define_column(c,97,c_line_attr13,150);
890: DBMS_SQL.define_column(c,98,c_line_attr14,150);
891: DBMS_SQL.define_column(c,99,c_line_attr15,150);
892: DBMS_SQL.define_column(c,100,c_type_name,20);
893:

Line 890: DBMS_SQL.define_column(c,98,c_line_attr14,150);

886: DBMS_SQL.define_column(c,94,c_line_attr10,150);
887: DBMS_SQL.define_column(c,95,c_line_attr11,150);
888: DBMS_SQL.define_column(c,96,c_line_attr12,150);
889: DBMS_SQL.define_column(c,97,c_line_attr13,150);
890: DBMS_SQL.define_column(c,98,c_line_attr14,150);
891: DBMS_SQL.define_column(c,99,c_line_attr15,150);
892: DBMS_SQL.define_column(c,100,c_type_name,20);
893:
894:

Line 891: DBMS_SQL.define_column(c,99,c_line_attr15,150);

887: DBMS_SQL.define_column(c,95,c_line_attr11,150);
888: DBMS_SQL.define_column(c,96,c_line_attr12,150);
889: DBMS_SQL.define_column(c,97,c_line_attr13,150);
890: DBMS_SQL.define_column(c,98,c_line_attr14,150);
891: DBMS_SQL.define_column(c,99,c_line_attr15,150);
892: DBMS_SQL.define_column(c,100,c_type_name,20);
893:
894:
895: -- execute the SQL

Line 892: DBMS_SQL.define_column(c,100,c_type_name,20);

888: DBMS_SQL.define_column(c,96,c_line_attr12,150);
889: DBMS_SQL.define_column(c,97,c_line_attr13,150);
890: DBMS_SQL.define_column(c,98,c_line_attr14,150);
891: DBMS_SQL.define_column(c,99,c_line_attr15,150);
892: DBMS_SQL.define_column(c,100,c_type_name,20);
893:
894:
895: -- execute the SQL
896: execute_feedback := DBMS_SQL.execute(c);

Line 896: execute_feedback := DBMS_SQL.execute(c);

892: DBMS_SQL.define_column(c,100,c_type_name,20);
893:
894:
895: -- execute the SQL
896: execute_feedback := DBMS_SQL.execute(c);
897: -- set counter
898: c_counter := 0;
899: -- fetch rows
900: while DBMS_SQL.fetch_rows(c) > 0

Line 900: while DBMS_SQL.fetch_rows(c) > 0

896: execute_feedback := DBMS_SQL.execute(c);
897: -- set counter
898: c_counter := 0;
899: -- fetch rows
900: while DBMS_SQL.fetch_rows(c) > 0
901: loop
902:
903: -- retrieve values from execution using COLUMN_VALUE
904: DBMS_SQL.column_value(c,1, c_currency);

Line 904: DBMS_SQL.column_value(c,1, c_currency);

900: while DBMS_SQL.fetch_rows(c) > 0
901: loop
902:
903: -- retrieve values from execution using COLUMN_VALUE
904: DBMS_SQL.column_value(c,1, c_currency);
905: DBMS_SQL.column_value(c,2, c_tax_reference);
906: DBMS_SQL.column_value(c,3, c_sic_code);
907: DBMS_SQL.column_value(c,4, c_ship_date_actual);
908: DBMS_SQL.column_value(c,5, c_fob_point);

Line 905: DBMS_SQL.column_value(c,2, c_tax_reference);

901: loop
902:
903: -- retrieve values from execution using COLUMN_VALUE
904: DBMS_SQL.column_value(c,1, c_currency);
905: DBMS_SQL.column_value(c,2, c_tax_reference);
906: DBMS_SQL.column_value(c,3, c_sic_code);
907: DBMS_SQL.column_value(c,4, c_ship_date_actual);
908: DBMS_SQL.column_value(c,5, c_fob_point);
909: DBMS_SQL.column_value(c,6, c_inv_number);

Line 906: DBMS_SQL.column_value(c,3, c_sic_code);

902:
903: -- retrieve values from execution using COLUMN_VALUE
904: DBMS_SQL.column_value(c,1, c_currency);
905: DBMS_SQL.column_value(c,2, c_tax_reference);
906: DBMS_SQL.column_value(c,3, c_sic_code);
907: DBMS_SQL.column_value(c,4, c_ship_date_actual);
908: DBMS_SQL.column_value(c,5, c_fob_point);
909: DBMS_SQL.column_value(c,6, c_inv_number);
910: DBMS_SQL.column_value(c,7, c_inv_type);

Line 907: DBMS_SQL.column_value(c,4, c_ship_date_actual);

903: -- retrieve values from execution using COLUMN_VALUE
904: DBMS_SQL.column_value(c,1, c_currency);
905: DBMS_SQL.column_value(c,2, c_tax_reference);
906: DBMS_SQL.column_value(c,3, c_sic_code);
907: DBMS_SQL.column_value(c,4, c_ship_date_actual);
908: DBMS_SQL.column_value(c,5, c_fob_point);
909: DBMS_SQL.column_value(c,6, c_inv_number);
910: DBMS_SQL.column_value(c,7, c_inv_type);
911: DBMS_SQL.column_value(c,8, c_inv_type_code);

Line 908: DBMS_SQL.column_value(c,5, c_fob_point);

904: DBMS_SQL.column_value(c,1, c_currency);
905: DBMS_SQL.column_value(c,2, c_tax_reference);
906: DBMS_SQL.column_value(c,3, c_sic_code);
907: DBMS_SQL.column_value(c,4, c_ship_date_actual);
908: DBMS_SQL.column_value(c,5, c_fob_point);
909: DBMS_SQL.column_value(c,6, c_inv_number);
910: DBMS_SQL.column_value(c,7, c_inv_type);
911: DBMS_SQL.column_value(c,8, c_inv_type_code);
912: DBMS_SQL.column_value(c,9, c_inv_type_code_order);

Line 909: DBMS_SQL.column_value(c,6, c_inv_number);

905: DBMS_SQL.column_value(c,2, c_tax_reference);
906: DBMS_SQL.column_value(c,3, c_sic_code);
907: DBMS_SQL.column_value(c,4, c_ship_date_actual);
908: DBMS_SQL.column_value(c,5, c_fob_point);
909: DBMS_SQL.column_value(c,6, c_inv_number);
910: DBMS_SQL.column_value(c,7, c_inv_type);
911: DBMS_SQL.column_value(c,8, c_inv_type_code);
912: DBMS_SQL.column_value(c,9, c_inv_type_code_order);
913: DBMS_SQL.column_value(c,10, c_adj_number);

Line 910: DBMS_SQL.column_value(c,7, c_inv_type);

906: DBMS_SQL.column_value(c,3, c_sic_code);
907: DBMS_SQL.column_value(c,4, c_ship_date_actual);
908: DBMS_SQL.column_value(c,5, c_fob_point);
909: DBMS_SQL.column_value(c,6, c_inv_number);
910: DBMS_SQL.column_value(c,7, c_inv_type);
911: DBMS_SQL.column_value(c,8, c_inv_type_code);
912: DBMS_SQL.column_value(c,9, c_inv_type_code_order);
913: DBMS_SQL.column_value(c,10, c_adj_number);
914: DBMS_SQL.column_value(c,11, c_adj_line_amount);

Line 911: DBMS_SQL.column_value(c,8, c_inv_type_code);

907: DBMS_SQL.column_value(c,4, c_ship_date_actual);
908: DBMS_SQL.column_value(c,5, c_fob_point);
909: DBMS_SQL.column_value(c,6, c_inv_number);
910: DBMS_SQL.column_value(c,7, c_inv_type);
911: DBMS_SQL.column_value(c,8, c_inv_type_code);
912: DBMS_SQL.column_value(c,9, c_inv_type_code_order);
913: DBMS_SQL.column_value(c,10, c_adj_number);
914: DBMS_SQL.column_value(c,11, c_adj_line_amount);
915: DBMS_SQL.column_value(c,12, c_adj_tax_amount);

Line 912: DBMS_SQL.column_value(c,9, c_inv_type_code_order);

908: DBMS_SQL.column_value(c,5, c_fob_point);
909: DBMS_SQL.column_value(c,6, c_inv_number);
910: DBMS_SQL.column_value(c,7, c_inv_type);
911: DBMS_SQL.column_value(c,8, c_inv_type_code);
912: DBMS_SQL.column_value(c,9, c_inv_type_code_order);
913: DBMS_SQL.column_value(c,10, c_adj_number);
914: DBMS_SQL.column_value(c,11, c_adj_line_amount);
915: DBMS_SQL.column_value(c,12, c_adj_tax_amount);
916: DBMS_SQL.column_value(c,13, c_adj_freight_amount);

Line 913: DBMS_SQL.column_value(c,10, c_adj_number);

909: DBMS_SQL.column_value(c,6, c_inv_number);
910: DBMS_SQL.column_value(c,7, c_inv_type);
911: DBMS_SQL.column_value(c,8, c_inv_type_code);
912: DBMS_SQL.column_value(c,9, c_inv_type_code_order);
913: DBMS_SQL.column_value(c,10, c_adj_number);
914: DBMS_SQL.column_value(c,11, c_adj_line_amount);
915: DBMS_SQL.column_value(c,12, c_adj_tax_amount);
916: DBMS_SQL.column_value(c,13, c_adj_freight_amount);
917: DBMS_SQL.column_value(c,14, c_adj_type);

Line 914: DBMS_SQL.column_value(c,11, c_adj_line_amount);

910: DBMS_SQL.column_value(c,7, c_inv_type);
911: DBMS_SQL.column_value(c,8, c_inv_type_code);
912: DBMS_SQL.column_value(c,9, c_inv_type_code_order);
913: DBMS_SQL.column_value(c,10, c_adj_number);
914: DBMS_SQL.column_value(c,11, c_adj_line_amount);
915: DBMS_SQL.column_value(c,12, c_adj_tax_amount);
916: DBMS_SQL.column_value(c,13, c_adj_freight_amount);
917: DBMS_SQL.column_value(c,14, c_adj_type);
918: DBMS_SQL.column_value(c,15, c_inv_date );

Line 915: DBMS_SQL.column_value(c,12, c_adj_tax_amount);

911: DBMS_SQL.column_value(c,8, c_inv_type_code);
912: DBMS_SQL.column_value(c,9, c_inv_type_code_order);
913: DBMS_SQL.column_value(c,10, c_adj_number);
914: DBMS_SQL.column_value(c,11, c_adj_line_amount);
915: DBMS_SQL.column_value(c,12, c_adj_tax_amount);
916: DBMS_SQL.column_value(c,13, c_adj_freight_amount);
917: DBMS_SQL.column_value(c,14, c_adj_type);
918: DBMS_SQL.column_value(c,15, c_inv_date );
919: DBMS_SQL.column_value(c,16, c_ship_to_cust_name);

Line 916: DBMS_SQL.column_value(c,13, c_adj_freight_amount);

912: DBMS_SQL.column_value(c,9, c_inv_type_code_order);
913: DBMS_SQL.column_value(c,10, c_adj_number);
914: DBMS_SQL.column_value(c,11, c_adj_line_amount);
915: DBMS_SQL.column_value(c,12, c_adj_tax_amount);
916: DBMS_SQL.column_value(c,13, c_adj_freight_amount);
917: DBMS_SQL.column_value(c,14, c_adj_type);
918: DBMS_SQL.column_value(c,15, c_inv_date );
919: DBMS_SQL.column_value(c,16, c_ship_to_cust_name);
920: DBMS_SQL.column_value(c,17, c_ship_to_cust_number);

Line 917: DBMS_SQL.column_value(c,14, c_adj_type);

913: DBMS_SQL.column_value(c,10, c_adj_number);
914: DBMS_SQL.column_value(c,11, c_adj_line_amount);
915: DBMS_SQL.column_value(c,12, c_adj_tax_amount);
916: DBMS_SQL.column_value(c,13, c_adj_freight_amount);
917: DBMS_SQL.column_value(c,14, c_adj_type);
918: DBMS_SQL.column_value(c,15, c_inv_date );
919: DBMS_SQL.column_value(c,16, c_ship_to_cust_name);
920: DBMS_SQL.column_value(c,17, c_ship_to_cust_number);
921: DBMS_SQL.column_value(c,18, c_location);

Line 918: DBMS_SQL.column_value(c,15, c_inv_date );

914: DBMS_SQL.column_value(c,11, c_adj_line_amount);
915: DBMS_SQL.column_value(c,12, c_adj_tax_amount);
916: DBMS_SQL.column_value(c,13, c_adj_freight_amount);
917: DBMS_SQL.column_value(c,14, c_adj_type);
918: DBMS_SQL.column_value(c,15, c_inv_date );
919: DBMS_SQL.column_value(c,16, c_ship_to_cust_name);
920: DBMS_SQL.column_value(c,17, c_ship_to_cust_number);
921: DBMS_SQL.column_value(c,18, c_location);
922: DBMS_SQL.column_value(c,19, c_cust_tax_code);

Line 919: DBMS_SQL.column_value(c,16, c_ship_to_cust_name);

915: DBMS_SQL.column_value(c,12, c_adj_tax_amount);
916: DBMS_SQL.column_value(c,13, c_adj_freight_amount);
917: DBMS_SQL.column_value(c,14, c_adj_type);
918: DBMS_SQL.column_value(c,15, c_inv_date );
919: DBMS_SQL.column_value(c,16, c_ship_to_cust_name);
920: DBMS_SQL.column_value(c,17, c_ship_to_cust_number);
921: DBMS_SQL.column_value(c,18, c_location);
922: DBMS_SQL.column_value(c,19, c_cust_tax_code);
923: DBMS_SQL.column_value(c,20, c_type_flag);

Line 920: DBMS_SQL.column_value(c,17, c_ship_to_cust_number);

916: DBMS_SQL.column_value(c,13, c_adj_freight_amount);
917: DBMS_SQL.column_value(c,14, c_adj_type);
918: DBMS_SQL.column_value(c,15, c_inv_date );
919: DBMS_SQL.column_value(c,16, c_ship_to_cust_name);
920: DBMS_SQL.column_value(c,17, c_ship_to_cust_number);
921: DBMS_SQL.column_value(c,18, c_location);
922: DBMS_SQL.column_value(c,19, c_cust_tax_code);
923: DBMS_SQL.column_value(c,20, c_type_flag);
924: DBMS_SQL.column_value(c,21, c_inv_cust_trx_id );

Line 921: DBMS_SQL.column_value(c,18, c_location);

917: DBMS_SQL.column_value(c,14, c_adj_type);
918: DBMS_SQL.column_value(c,15, c_inv_date );
919: DBMS_SQL.column_value(c,16, c_ship_to_cust_name);
920: DBMS_SQL.column_value(c,17, c_ship_to_cust_number);
921: DBMS_SQL.column_value(c,18, c_location);
922: DBMS_SQL.column_value(c,19, c_cust_tax_code);
923: DBMS_SQL.column_value(c,20, c_type_flag);
924: DBMS_SQL.column_value(c,21, c_inv_cust_trx_id );
925: DBMS_SQL.column_value(c,22, c_cust_trx_id );

Line 922: DBMS_SQL.column_value(c,19, c_cust_tax_code);

918: DBMS_SQL.column_value(c,15, c_inv_date );
919: DBMS_SQL.column_value(c,16, c_ship_to_cust_name);
920: DBMS_SQL.column_value(c,17, c_ship_to_cust_number);
921: DBMS_SQL.column_value(c,18, c_location);
922: DBMS_SQL.column_value(c,19, c_cust_tax_code);
923: DBMS_SQL.column_value(c,20, c_type_flag);
924: DBMS_SQL.column_value(c,21, c_inv_cust_trx_id );
925: DBMS_SQL.column_value(c,22, c_cust_trx_id );
926: DBMS_SQL.column_value(c,23, c_batch_source_id );

Line 923: DBMS_SQL.column_value(c,20, c_type_flag);

919: DBMS_SQL.column_value(c,16, c_ship_to_cust_name);
920: DBMS_SQL.column_value(c,17, c_ship_to_cust_number);
921: DBMS_SQL.column_value(c,18, c_location);
922: DBMS_SQL.column_value(c,19, c_cust_tax_code);
923: DBMS_SQL.column_value(c,20, c_type_flag);
924: DBMS_SQL.column_value(c,21, c_inv_cust_trx_id );
925: DBMS_SQL.column_value(c,22, c_cust_trx_id );
926: DBMS_SQL.column_value(c,23, c_batch_source_id );
927: DBMS_SQL.column_value(c,24, c_adjustment_id);

Line 924: DBMS_SQL.column_value(c,21, c_inv_cust_trx_id );

920: DBMS_SQL.column_value(c,17, c_ship_to_cust_number);
921: DBMS_SQL.column_value(c,18, c_location);
922: DBMS_SQL.column_value(c,19, c_cust_tax_code);
923: DBMS_SQL.column_value(c,20, c_type_flag);
924: DBMS_SQL.column_value(c,21, c_inv_cust_trx_id );
925: DBMS_SQL.column_value(c,22, c_cust_trx_id );
926: DBMS_SQL.column_value(c,23, c_batch_source_id );
927: DBMS_SQL.column_value(c,24, c_adjustment_id);
928: DBMS_SQL.column_value(c,25, c_trx_line_id );

Line 925: DBMS_SQL.column_value(c,22, c_cust_trx_id );

921: DBMS_SQL.column_value(c,18, c_location);
922: DBMS_SQL.column_value(c,19, c_cust_tax_code);
923: DBMS_SQL.column_value(c,20, c_type_flag);
924: DBMS_SQL.column_value(c,21, c_inv_cust_trx_id );
925: DBMS_SQL.column_value(c,22, c_cust_trx_id );
926: DBMS_SQL.column_value(c,23, c_batch_source_id );
927: DBMS_SQL.column_value(c,24, c_adjustment_id);
928: DBMS_SQL.column_value(c,25, c_trx_line_id );
929: DBMS_SQL.column_value(c,26, c_line_number );

Line 926: DBMS_SQL.column_value(c,23, c_batch_source_id );

922: DBMS_SQL.column_value(c,19, c_cust_tax_code);
923: DBMS_SQL.column_value(c,20, c_type_flag);
924: DBMS_SQL.column_value(c,21, c_inv_cust_trx_id );
925: DBMS_SQL.column_value(c,22, c_cust_trx_id );
926: DBMS_SQL.column_value(c,23, c_batch_source_id );
927: DBMS_SQL.column_value(c,24, c_adjustment_id);
928: DBMS_SQL.column_value(c,25, c_trx_line_id );
929: DBMS_SQL.column_value(c,26, c_line_number );
930: DBMS_SQL.column_value(c,27, c_description);

Line 927: DBMS_SQL.column_value(c,24, c_adjustment_id);

923: DBMS_SQL.column_value(c,20, c_type_flag);
924: DBMS_SQL.column_value(c,21, c_inv_cust_trx_id );
925: DBMS_SQL.column_value(c,22, c_cust_trx_id );
926: DBMS_SQL.column_value(c,23, c_batch_source_id );
927: DBMS_SQL.column_value(c,24, c_adjustment_id);
928: DBMS_SQL.column_value(c,25, c_trx_line_id );
929: DBMS_SQL.column_value(c,26, c_line_number );
930: DBMS_SQL.column_value(c,27, c_description);
931: DBMS_SQL.column_value(c,28, c_line_amount);

Line 928: DBMS_SQL.column_value(c,25, c_trx_line_id );

924: DBMS_SQL.column_value(c,21, c_inv_cust_trx_id );
925: DBMS_SQL.column_value(c,22, c_cust_trx_id );
926: DBMS_SQL.column_value(c,23, c_batch_source_id );
927: DBMS_SQL.column_value(c,24, c_adjustment_id);
928: DBMS_SQL.column_value(c,25, c_trx_line_id );
929: DBMS_SQL.column_value(c,26, c_line_number );
930: DBMS_SQL.column_value(c,27, c_description);
931: DBMS_SQL.column_value(c,28, c_line_amount);
932: DBMS_SQL.column_value(c,29, c_tax_line_number);

Line 929: DBMS_SQL.column_value(c,26, c_line_number );

925: DBMS_SQL.column_value(c,22, c_cust_trx_id );
926: DBMS_SQL.column_value(c,23, c_batch_source_id );
927: DBMS_SQL.column_value(c,24, c_adjustment_id);
928: DBMS_SQL.column_value(c,25, c_trx_line_id );
929: DBMS_SQL.column_value(c,26, c_line_number );
930: DBMS_SQL.column_value(c,27, c_description);
931: DBMS_SQL.column_value(c,28, c_line_amount);
932: DBMS_SQL.column_value(c,29, c_tax_line_number);
933: DBMS_SQL.column_value(c,30, c_tax_cust_trx_line_id);

Line 930: DBMS_SQL.column_value(c,27, c_description);

926: DBMS_SQL.column_value(c,23, c_batch_source_id );
927: DBMS_SQL.column_value(c,24, c_adjustment_id);
928: DBMS_SQL.column_value(c,25, c_trx_line_id );
929: DBMS_SQL.column_value(c,26, c_line_number );
930: DBMS_SQL.column_value(c,27, c_description);
931: DBMS_SQL.column_value(c,28, c_line_amount);
932: DBMS_SQL.column_value(c,29, c_tax_line_number);
933: DBMS_SQL.column_value(c,30, c_tax_cust_trx_line_id);
934: DBMS_SQL.column_value(c,31, c_tax_rate );

Line 931: DBMS_SQL.column_value(c,28, c_line_amount);

927: DBMS_SQL.column_value(c,24, c_adjustment_id);
928: DBMS_SQL.column_value(c,25, c_trx_line_id );
929: DBMS_SQL.column_value(c,26, c_line_number );
930: DBMS_SQL.column_value(c,27, c_description);
931: DBMS_SQL.column_value(c,28, c_line_amount);
932: DBMS_SQL.column_value(c,29, c_tax_line_number);
933: DBMS_SQL.column_value(c,30, c_tax_cust_trx_line_id);
934: DBMS_SQL.column_value(c,31, c_tax_rate );
935: DBMS_SQL.column_value(c,32, c_vat_code);

Line 932: DBMS_SQL.column_value(c,29, c_tax_line_number);

928: DBMS_SQL.column_value(c,25, c_trx_line_id );
929: DBMS_SQL.column_value(c,26, c_line_number );
930: DBMS_SQL.column_value(c,27, c_description);
931: DBMS_SQL.column_value(c,28, c_line_amount);
932: DBMS_SQL.column_value(c,29, c_tax_line_number);
933: DBMS_SQL.column_value(c,30, c_tax_cust_trx_line_id);
934: DBMS_SQL.column_value(c,31, c_tax_rate );
935: DBMS_SQL.column_value(c,32, c_vat_code);
936: DBMS_SQL.column_value(c,33, c_tax_vendor_return_code);

Line 933: DBMS_SQL.column_value(c,30, c_tax_cust_trx_line_id);

929: DBMS_SQL.column_value(c,26, c_line_number );
930: DBMS_SQL.column_value(c,27, c_description);
931: DBMS_SQL.column_value(c,28, c_line_amount);
932: DBMS_SQL.column_value(c,29, c_tax_line_number);
933: DBMS_SQL.column_value(c,30, c_tax_cust_trx_line_id);
934: DBMS_SQL.column_value(c,31, c_tax_rate );
935: DBMS_SQL.column_value(c,32, c_vat_code);
936: DBMS_SQL.column_value(c,33, c_tax_vendor_return_code);
937: DBMS_SQL.column_value(c,34, c_vat_code_type);

Line 934: DBMS_SQL.column_value(c,31, c_tax_rate );

930: DBMS_SQL.column_value(c,27, c_description);
931: DBMS_SQL.column_value(c,28, c_line_amount);
932: DBMS_SQL.column_value(c,29, c_tax_line_number);
933: DBMS_SQL.column_value(c,30, c_tax_cust_trx_line_id);
934: DBMS_SQL.column_value(c,31, c_tax_rate );
935: DBMS_SQL.column_value(c,32, c_vat_code);
936: DBMS_SQL.column_value(c,33, c_tax_vendor_return_code);
937: DBMS_SQL.column_value(c,34, c_vat_code_type);
938: DBMS_SQL.column_value(c,35, c_exempt_number);

Line 935: DBMS_SQL.column_value(c,32, c_vat_code);

931: DBMS_SQL.column_value(c,28, c_line_amount);
932: DBMS_SQL.column_value(c,29, c_tax_line_number);
933: DBMS_SQL.column_value(c,30, c_tax_cust_trx_line_id);
934: DBMS_SQL.column_value(c,31, c_tax_rate );
935: DBMS_SQL.column_value(c,32, c_vat_code);
936: DBMS_SQL.column_value(c,33, c_tax_vendor_return_code);
937: DBMS_SQL.column_value(c,34, c_vat_code_type);
938: DBMS_SQL.column_value(c,35, c_exempt_number);
939: DBMS_SQL.column_value(c,36, c_exempt_reason);

Line 936: DBMS_SQL.column_value(c,33, c_tax_vendor_return_code);

932: DBMS_SQL.column_value(c,29, c_tax_line_number);
933: DBMS_SQL.column_value(c,30, c_tax_cust_trx_line_id);
934: DBMS_SQL.column_value(c,31, c_tax_rate );
935: DBMS_SQL.column_value(c,32, c_vat_code);
936: DBMS_SQL.column_value(c,33, c_tax_vendor_return_code);
937: DBMS_SQL.column_value(c,34, c_vat_code_type);
938: DBMS_SQL.column_value(c,35, c_exempt_number);
939: DBMS_SQL.column_value(c,36, c_exempt_reason);
940: DBMS_SQL.column_value(c,37, c_exempt_percent );

Line 937: DBMS_SQL.column_value(c,34, c_vat_code_type);

933: DBMS_SQL.column_value(c,30, c_tax_cust_trx_line_id);
934: DBMS_SQL.column_value(c,31, c_tax_rate );
935: DBMS_SQL.column_value(c,32, c_vat_code);
936: DBMS_SQL.column_value(c,33, c_tax_vendor_return_code);
937: DBMS_SQL.column_value(c,34, c_vat_code_type);
938: DBMS_SQL.column_value(c,35, c_exempt_number);
939: DBMS_SQL.column_value(c,36, c_exempt_reason);
940: DBMS_SQL.column_value(c,37, c_exempt_percent );
941: DBMS_SQL.column_value(c,38, c_tax_amount);

Line 938: DBMS_SQL.column_value(c,35, c_exempt_number);

934: DBMS_SQL.column_value(c,31, c_tax_rate );
935: DBMS_SQL.column_value(c,32, c_vat_code);
936: DBMS_SQL.column_value(c,33, c_tax_vendor_return_code);
937: DBMS_SQL.column_value(c,34, c_vat_code_type);
938: DBMS_SQL.column_value(c,35, c_exempt_number);
939: DBMS_SQL.column_value(c,36, c_exempt_reason);
940: DBMS_SQL.column_value(c,37, c_exempt_percent );
941: DBMS_SQL.column_value(c,38, c_tax_amount);
942: DBMS_SQL.column_value(c,39, c_tax_except_percent);

Line 939: DBMS_SQL.column_value(c,36, c_exempt_reason);

935: DBMS_SQL.column_value(c,32, c_vat_code);
936: DBMS_SQL.column_value(c,33, c_tax_vendor_return_code);
937: DBMS_SQL.column_value(c,34, c_vat_code_type);
938: DBMS_SQL.column_value(c,35, c_exempt_number);
939: DBMS_SQL.column_value(c,36, c_exempt_reason);
940: DBMS_SQL.column_value(c,37, c_exempt_percent );
941: DBMS_SQL.column_value(c,38, c_tax_amount);
942: DBMS_SQL.column_value(c,39, c_tax_except_percent);
943: DBMS_SQL.column_value(c,40, c_tax_authority_id );

Line 940: DBMS_SQL.column_value(c,37, c_exempt_percent );

936: DBMS_SQL.column_value(c,33, c_tax_vendor_return_code);
937: DBMS_SQL.column_value(c,34, c_vat_code_type);
938: DBMS_SQL.column_value(c,35, c_exempt_number);
939: DBMS_SQL.column_value(c,36, c_exempt_reason);
940: DBMS_SQL.column_value(c,37, c_exempt_percent );
941: DBMS_SQL.column_value(c,38, c_tax_amount);
942: DBMS_SQL.column_value(c,39, c_tax_except_percent);
943: DBMS_SQL.column_value(c,40, c_tax_authority_id );
944: DBMS_SQL.column_value(c,41, c_tax_authority_zip_code);

Line 941: DBMS_SQL.column_value(c,38, c_tax_amount);

937: DBMS_SQL.column_value(c,34, c_vat_code_type);
938: DBMS_SQL.column_value(c,35, c_exempt_number);
939: DBMS_SQL.column_value(c,36, c_exempt_reason);
940: DBMS_SQL.column_value(c,37, c_exempt_percent );
941: DBMS_SQL.column_value(c,38, c_tax_amount);
942: DBMS_SQL.column_value(c,39, c_tax_except_percent);
943: DBMS_SQL.column_value(c,40, c_tax_authority_id );
944: DBMS_SQL.column_value(c,41, c_tax_authority_zip_code);
945: DBMS_SQL.column_value(c,42, c_sales_tax_id );

Line 942: DBMS_SQL.column_value(c,39, c_tax_except_percent);

938: DBMS_SQL.column_value(c,35, c_exempt_number);
939: DBMS_SQL.column_value(c,36, c_exempt_reason);
940: DBMS_SQL.column_value(c,37, c_exempt_percent );
941: DBMS_SQL.column_value(c,38, c_tax_amount);
942: DBMS_SQL.column_value(c,39, c_tax_except_percent);
943: DBMS_SQL.column_value(c,40, c_tax_authority_id );
944: DBMS_SQL.column_value(c,41, c_tax_authority_zip_code);
945: DBMS_SQL.column_value(c,42, c_sales_tax_id );
946: DBMS_SQL.column_value(c,43, c_gltax_inrange_flag);

Line 943: DBMS_SQL.column_value(c,40, c_tax_authority_id );

939: DBMS_SQL.column_value(c,36, c_exempt_reason);
940: DBMS_SQL.column_value(c,37, c_exempt_percent );
941: DBMS_SQL.column_value(c,38, c_tax_amount);
942: DBMS_SQL.column_value(c,39, c_tax_except_percent);
943: DBMS_SQL.column_value(c,40, c_tax_authority_id );
944: DBMS_SQL.column_value(c,41, c_tax_authority_zip_code);
945: DBMS_SQL.column_value(c,42, c_sales_tax_id );
946: DBMS_SQL.column_value(c,43, c_gltax_inrange_flag);
947: DBMS_SQL.column_value(c,44, c_posted);

Line 944: DBMS_SQL.column_value(c,41, c_tax_authority_zip_code);

940: DBMS_SQL.column_value(c,37, c_exempt_percent );
941: DBMS_SQL.column_value(c,38, c_tax_amount);
942: DBMS_SQL.column_value(c,39, c_tax_except_percent);
943: DBMS_SQL.column_value(c,40, c_tax_authority_id );
944: DBMS_SQL.column_value(c,41, c_tax_authority_zip_code);
945: DBMS_SQL.column_value(c,42, c_sales_tax_id );
946: DBMS_SQL.column_value(c,43, c_gltax_inrange_flag);
947: DBMS_SQL.column_value(c,44, c_posted);
948: DBMS_SQL.column_value(c,45, c_ship_to_customer_id);

Line 945: DBMS_SQL.column_value(c,42, c_sales_tax_id );

941: DBMS_SQL.column_value(c,38, c_tax_amount);
942: DBMS_SQL.column_value(c,39, c_tax_except_percent);
943: DBMS_SQL.column_value(c,40, c_tax_authority_id );
944: DBMS_SQL.column_value(c,41, c_tax_authority_zip_code);
945: DBMS_SQL.column_value(c,42, c_sales_tax_id );
946: DBMS_SQL.column_value(c,43, c_gltax_inrange_flag);
947: DBMS_SQL.column_value(c,44, c_posted);
948: DBMS_SQL.column_value(c,45, c_ship_to_customer_id);
949: DBMS_SQL.column_value(c,46, c_ship_to_site_use_id);

Line 946: DBMS_SQL.column_value(c,43, c_gltax_inrange_flag);

942: DBMS_SQL.column_value(c,39, c_tax_except_percent);
943: DBMS_SQL.column_value(c,40, c_tax_authority_id );
944: DBMS_SQL.column_value(c,41, c_tax_authority_zip_code);
945: DBMS_SQL.column_value(c,42, c_sales_tax_id );
946: DBMS_SQL.column_value(c,43, c_gltax_inrange_flag);
947: DBMS_SQL.column_value(c,44, c_posted);
948: DBMS_SQL.column_value(c,45, c_ship_to_customer_id);
949: DBMS_SQL.column_value(c,46, c_ship_to_site_use_id);
950: DBMS_SQL.column_value(c,47, c_bill_to_customer_id);

Line 947: DBMS_SQL.column_value(c,44, c_posted);

943: DBMS_SQL.column_value(c,40, c_tax_authority_id );
944: DBMS_SQL.column_value(c,41, c_tax_authority_zip_code);
945: DBMS_SQL.column_value(c,42, c_sales_tax_id );
946: DBMS_SQL.column_value(c,43, c_gltax_inrange_flag);
947: DBMS_SQL.column_value(c,44, c_posted);
948: DBMS_SQL.column_value(c,45, c_ship_to_customer_id);
949: DBMS_SQL.column_value(c,46, c_ship_to_site_use_id);
950: DBMS_SQL.column_value(c,47, c_bill_to_customer_id);
951: DBMS_SQL.column_value(c,48, c_bill_to_site_use_id);

Line 948: DBMS_SQL.column_value(c,45, c_ship_to_customer_id);

944: DBMS_SQL.column_value(c,41, c_tax_authority_zip_code);
945: DBMS_SQL.column_value(c,42, c_sales_tax_id );
946: DBMS_SQL.column_value(c,43, c_gltax_inrange_flag);
947: DBMS_SQL.column_value(c,44, c_posted);
948: DBMS_SQL.column_value(c,45, c_ship_to_customer_id);
949: DBMS_SQL.column_value(c,46, c_ship_to_site_use_id);
950: DBMS_SQL.column_value(c,47, c_bill_to_customer_id);
951: DBMS_SQL.column_value(c,48, c_bill_to_site_use_id);
952: DBMS_SQL.column_value(c,49, c_sold_to_customer_id);

Line 949: DBMS_SQL.column_value(c,46, c_ship_to_site_use_id);

945: DBMS_SQL.column_value(c,42, c_sales_tax_id );
946: DBMS_SQL.column_value(c,43, c_gltax_inrange_flag);
947: DBMS_SQL.column_value(c,44, c_posted);
948: DBMS_SQL.column_value(c,45, c_ship_to_customer_id);
949: DBMS_SQL.column_value(c,46, c_ship_to_site_use_id);
950: DBMS_SQL.column_value(c,47, c_bill_to_customer_id);
951: DBMS_SQL.column_value(c,48, c_bill_to_site_use_id);
952: DBMS_SQL.column_value(c,49, c_sold_to_customer_id);
953: DBMS_SQL.column_value(c,50, c_sold_to_site_use_id);

Line 950: DBMS_SQL.column_value(c,47, c_bill_to_customer_id);

946: DBMS_SQL.column_value(c,43, c_gltax_inrange_flag);
947: DBMS_SQL.column_value(c,44, c_posted);
948: DBMS_SQL.column_value(c,45, c_ship_to_customer_id);
949: DBMS_SQL.column_value(c,46, c_ship_to_site_use_id);
950: DBMS_SQL.column_value(c,47, c_bill_to_customer_id);
951: DBMS_SQL.column_value(c,48, c_bill_to_site_use_id);
952: DBMS_SQL.column_value(c,49, c_sold_to_customer_id);
953: DBMS_SQL.column_value(c,50, c_sold_to_site_use_id);
954: DBMS_SQL.column_value(c,51,c_waybill_number);

Line 951: DBMS_SQL.column_value(c,48, c_bill_to_site_use_id);

947: DBMS_SQL.column_value(c,44, c_posted);
948: DBMS_SQL.column_value(c,45, c_ship_to_customer_id);
949: DBMS_SQL.column_value(c,46, c_ship_to_site_use_id);
950: DBMS_SQL.column_value(c,47, c_bill_to_customer_id);
951: DBMS_SQL.column_value(c,48, c_bill_to_site_use_id);
952: DBMS_SQL.column_value(c,49, c_sold_to_customer_id);
953: DBMS_SQL.column_value(c,50, c_sold_to_site_use_id);
954: DBMS_SQL.column_value(c,51,c_waybill_number);
955: DBMS_SQL.column_value(c,52,c_purchase_order);

Line 952: DBMS_SQL.column_value(c,49, c_sold_to_customer_id);

948: DBMS_SQL.column_value(c,45, c_ship_to_customer_id);
949: DBMS_SQL.column_value(c,46, c_ship_to_site_use_id);
950: DBMS_SQL.column_value(c,47, c_bill_to_customer_id);
951: DBMS_SQL.column_value(c,48, c_bill_to_site_use_id);
952: DBMS_SQL.column_value(c,49, c_sold_to_customer_id);
953: DBMS_SQL.column_value(c,50, c_sold_to_site_use_id);
954: DBMS_SQL.column_value(c,51,c_waybill_number);
955: DBMS_SQL.column_value(c,52,c_purchase_order);
956: DBMS_SQL.column_value(c,53,c_purchase_order_revision);

Line 953: DBMS_SQL.column_value(c,50, c_sold_to_site_use_id);

949: DBMS_SQL.column_value(c,46, c_ship_to_site_use_id);
950: DBMS_SQL.column_value(c,47, c_bill_to_customer_id);
951: DBMS_SQL.column_value(c,48, c_bill_to_site_use_id);
952: DBMS_SQL.column_value(c,49, c_sold_to_customer_id);
953: DBMS_SQL.column_value(c,50, c_sold_to_site_use_id);
954: DBMS_SQL.column_value(c,51,c_waybill_number);
955: DBMS_SQL.column_value(c,52,c_purchase_order);
956: DBMS_SQL.column_value(c,53,c_purchase_order_revision);
957: DBMS_SQL.column_value(c,54,c_exchange_rate_type);

Line 954: DBMS_SQL.column_value(c,51,c_waybill_number);

950: DBMS_SQL.column_value(c,47, c_bill_to_customer_id);
951: DBMS_SQL.column_value(c,48, c_bill_to_site_use_id);
952: DBMS_SQL.column_value(c,49, c_sold_to_customer_id);
953: DBMS_SQL.column_value(c,50, c_sold_to_site_use_id);
954: DBMS_SQL.column_value(c,51,c_waybill_number);
955: DBMS_SQL.column_value(c,52,c_purchase_order);
956: DBMS_SQL.column_value(c,53,c_purchase_order_revision);
957: DBMS_SQL.column_value(c,54,c_exchange_rate_type);
958: DBMS_SQL.column_value(c,55,c_exchange_rate_date);

Line 955: DBMS_SQL.column_value(c,52,c_purchase_order);

951: DBMS_SQL.column_value(c,48, c_bill_to_site_use_id);
952: DBMS_SQL.column_value(c,49, c_sold_to_customer_id);
953: DBMS_SQL.column_value(c,50, c_sold_to_site_use_id);
954: DBMS_SQL.column_value(c,51,c_waybill_number);
955: DBMS_SQL.column_value(c,52,c_purchase_order);
956: DBMS_SQL.column_value(c,53,c_purchase_order_revision);
957: DBMS_SQL.column_value(c,54,c_exchange_rate_type);
958: DBMS_SQL.column_value(c,55,c_exchange_rate_date);
959: DBMS_SQL.column_value(c,56,c_exchange_rate);

Line 956: DBMS_SQL.column_value(c,53,c_purchase_order_revision);

952: DBMS_SQL.column_value(c,49, c_sold_to_customer_id);
953: DBMS_SQL.column_value(c,50, c_sold_to_site_use_id);
954: DBMS_SQL.column_value(c,51,c_waybill_number);
955: DBMS_SQL.column_value(c,52,c_purchase_order);
956: DBMS_SQL.column_value(c,53,c_purchase_order_revision);
957: DBMS_SQL.column_value(c,54,c_exchange_rate_type);
958: DBMS_SQL.column_value(c,55,c_exchange_rate_date);
959: DBMS_SQL.column_value(c,56,c_exchange_rate);
960: DBMS_SQL.column_value(c,57,c_ship_via);

Line 957: DBMS_SQL.column_value(c,54,c_exchange_rate_type);

953: DBMS_SQL.column_value(c,50, c_sold_to_site_use_id);
954: DBMS_SQL.column_value(c,51,c_waybill_number);
955: DBMS_SQL.column_value(c,52,c_purchase_order);
956: DBMS_SQL.column_value(c,53,c_purchase_order_revision);
957: DBMS_SQL.column_value(c,54,c_exchange_rate_type);
958: DBMS_SQL.column_value(c,55,c_exchange_rate_date);
959: DBMS_SQL.column_value(c,56,c_exchange_rate);
960: DBMS_SQL.column_value(c,57,c_ship_via);
961: DBMS_SQL.column_value(c,58,c_uom_code);

Line 958: DBMS_SQL.column_value(c,55,c_exchange_rate_date);

954: DBMS_SQL.column_value(c,51,c_waybill_number);
955: DBMS_SQL.column_value(c,52,c_purchase_order);
956: DBMS_SQL.column_value(c,53,c_purchase_order_revision);
957: DBMS_SQL.column_value(c,54,c_exchange_rate_type);
958: DBMS_SQL.column_value(c,55,c_exchange_rate_date);
959: DBMS_SQL.column_value(c,56,c_exchange_rate);
960: DBMS_SQL.column_value(c,57,c_ship_via);
961: DBMS_SQL.column_value(c,58,c_uom_code);
962: DBMS_SQL.column_value(c,59,c_quantity_invoiced);

Line 959: DBMS_SQL.column_value(c,56,c_exchange_rate);

955: DBMS_SQL.column_value(c,52,c_purchase_order);
956: DBMS_SQL.column_value(c,53,c_purchase_order_revision);
957: DBMS_SQL.column_value(c,54,c_exchange_rate_type);
958: DBMS_SQL.column_value(c,55,c_exchange_rate_date);
959: DBMS_SQL.column_value(c,56,c_exchange_rate);
960: DBMS_SQL.column_value(c,57,c_ship_via);
961: DBMS_SQL.column_value(c,58,c_uom_code);
962: DBMS_SQL.column_value(c,59,c_quantity_invoiced);
963: DBMS_SQL.column_value(c,60,c_unit_selling_price);

Line 960: DBMS_SQL.column_value(c,57,c_ship_via);

956: DBMS_SQL.column_value(c,53,c_purchase_order_revision);
957: DBMS_SQL.column_value(c,54,c_exchange_rate_type);
958: DBMS_SQL.column_value(c,55,c_exchange_rate_date);
959: DBMS_SQL.column_value(c,56,c_exchange_rate);
960: DBMS_SQL.column_value(c,57,c_ship_via);
961: DBMS_SQL.column_value(c,58,c_uom_code);
962: DBMS_SQL.column_value(c,59,c_quantity_invoiced);
963: DBMS_SQL.column_value(c,60,c_unit_selling_price);
964: DBMS_SQL.column_value(c,61,c_tax_precedence);

Line 961: DBMS_SQL.column_value(c,58,c_uom_code);

957: DBMS_SQL.column_value(c,54,c_exchange_rate_type);
958: DBMS_SQL.column_value(c,55,c_exchange_rate_date);
959: DBMS_SQL.column_value(c,56,c_exchange_rate);
960: DBMS_SQL.column_value(c,57,c_ship_via);
961: DBMS_SQL.column_value(c,58,c_uom_code);
962: DBMS_SQL.column_value(c,59,c_quantity_invoiced);
963: DBMS_SQL.column_value(c,60,c_unit_selling_price);
964: DBMS_SQL.column_value(c,61,c_tax_precedence);
965: DBMS_SQL.column_value(c,62,c_sales_order_source);

Line 962: DBMS_SQL.column_value(c,59,c_quantity_invoiced);

958: DBMS_SQL.column_value(c,55,c_exchange_rate_date);
959: DBMS_SQL.column_value(c,56,c_exchange_rate);
960: DBMS_SQL.column_value(c,57,c_ship_via);
961: DBMS_SQL.column_value(c,58,c_uom_code);
962: DBMS_SQL.column_value(c,59,c_quantity_invoiced);
963: DBMS_SQL.column_value(c,60,c_unit_selling_price);
964: DBMS_SQL.column_value(c,61,c_tax_precedence);
965: DBMS_SQL.column_value(c,62,c_sales_order_source);
966: DBMS_SQL.column_value(c,63,c_sales_order);

Line 963: DBMS_SQL.column_value(c,60,c_unit_selling_price);

959: DBMS_SQL.column_value(c,56,c_exchange_rate);
960: DBMS_SQL.column_value(c,57,c_ship_via);
961: DBMS_SQL.column_value(c,58,c_uom_code);
962: DBMS_SQL.column_value(c,59,c_quantity_invoiced);
963: DBMS_SQL.column_value(c,60,c_unit_selling_price);
964: DBMS_SQL.column_value(c,61,c_tax_precedence);
965: DBMS_SQL.column_value(c,62,c_sales_order_source);
966: DBMS_SQL.column_value(c,63,c_sales_order);
967: DBMS_SQL.column_value(c,64,c_sales_order_revision);

Line 964: DBMS_SQL.column_value(c,61,c_tax_precedence);

960: DBMS_SQL.column_value(c,57,c_ship_via);
961: DBMS_SQL.column_value(c,58,c_uom_code);
962: DBMS_SQL.column_value(c,59,c_quantity_invoiced);
963: DBMS_SQL.column_value(c,60,c_unit_selling_price);
964: DBMS_SQL.column_value(c,61,c_tax_precedence);
965: DBMS_SQL.column_value(c,62,c_sales_order_source);
966: DBMS_SQL.column_value(c,63,c_sales_order);
967: DBMS_SQL.column_value(c,64,c_sales_order_revision);
968: DBMS_SQL.column_value(c,65,c_sales_order_line);

Line 965: DBMS_SQL.column_value(c,62,c_sales_order_source);

961: DBMS_SQL.column_value(c,58,c_uom_code);
962: DBMS_SQL.column_value(c,59,c_quantity_invoiced);
963: DBMS_SQL.column_value(c,60,c_unit_selling_price);
964: DBMS_SQL.column_value(c,61,c_tax_precedence);
965: DBMS_SQL.column_value(c,62,c_sales_order_source);
966: DBMS_SQL.column_value(c,63,c_sales_order);
967: DBMS_SQL.column_value(c,64,c_sales_order_revision);
968: DBMS_SQL.column_value(c,65,c_sales_order_line);
969: DBMS_SQL.column_value(c,66,c_sales_order_date);

Line 966: DBMS_SQL.column_value(c,63,c_sales_order);

962: DBMS_SQL.column_value(c,59,c_quantity_invoiced);
963: DBMS_SQL.column_value(c,60,c_unit_selling_price);
964: DBMS_SQL.column_value(c,61,c_tax_precedence);
965: DBMS_SQL.column_value(c,62,c_sales_order_source);
966: DBMS_SQL.column_value(c,63,c_sales_order);
967: DBMS_SQL.column_value(c,64,c_sales_order_revision);
968: DBMS_SQL.column_value(c,65,c_sales_order_line);
969: DBMS_SQL.column_value(c,66,c_sales_order_date);
970: DBMS_SQL.column_value(c,67,c_inventory_item_id);

Line 967: DBMS_SQL.column_value(c,64,c_sales_order_revision);

963: DBMS_SQL.column_value(c,60,c_unit_selling_price);
964: DBMS_SQL.column_value(c,61,c_tax_precedence);
965: DBMS_SQL.column_value(c,62,c_sales_order_source);
966: DBMS_SQL.column_value(c,63,c_sales_order);
967: DBMS_SQL.column_value(c,64,c_sales_order_revision);
968: DBMS_SQL.column_value(c,65,c_sales_order_line);
969: DBMS_SQL.column_value(c,66,c_sales_order_date);
970: DBMS_SQL.column_value(c,67,c_inventory_item_id);
971: DBMS_SQL.column_value(c,68,c_header_category);

Line 968: DBMS_SQL.column_value(c,65,c_sales_order_line);

964: DBMS_SQL.column_value(c,61,c_tax_precedence);
965: DBMS_SQL.column_value(c,62,c_sales_order_source);
966: DBMS_SQL.column_value(c,63,c_sales_order);
967: DBMS_SQL.column_value(c,64,c_sales_order_revision);
968: DBMS_SQL.column_value(c,65,c_sales_order_line);
969: DBMS_SQL.column_value(c,66,c_sales_order_date);
970: DBMS_SQL.column_value(c,67,c_inventory_item_id);
971: DBMS_SQL.column_value(c,68,c_header_category);
972: DBMS_SQL.column_value(c,69,c_header_attr1);

Line 969: DBMS_SQL.column_value(c,66,c_sales_order_date);

965: DBMS_SQL.column_value(c,62,c_sales_order_source);
966: DBMS_SQL.column_value(c,63,c_sales_order);
967: DBMS_SQL.column_value(c,64,c_sales_order_revision);
968: DBMS_SQL.column_value(c,65,c_sales_order_line);
969: DBMS_SQL.column_value(c,66,c_sales_order_date);
970: DBMS_SQL.column_value(c,67,c_inventory_item_id);
971: DBMS_SQL.column_value(c,68,c_header_category);
972: DBMS_SQL.column_value(c,69,c_header_attr1);
973: DBMS_SQL.column_value(c,70,c_header_attr2);

Line 970: DBMS_SQL.column_value(c,67,c_inventory_item_id);

966: DBMS_SQL.column_value(c,63,c_sales_order);
967: DBMS_SQL.column_value(c,64,c_sales_order_revision);
968: DBMS_SQL.column_value(c,65,c_sales_order_line);
969: DBMS_SQL.column_value(c,66,c_sales_order_date);
970: DBMS_SQL.column_value(c,67,c_inventory_item_id);
971: DBMS_SQL.column_value(c,68,c_header_category);
972: DBMS_SQL.column_value(c,69,c_header_attr1);
973: DBMS_SQL.column_value(c,70,c_header_attr2);
974: DBMS_SQL.column_value(c,71,c_header_attr3);

Line 971: DBMS_SQL.column_value(c,68,c_header_category);

967: DBMS_SQL.column_value(c,64,c_sales_order_revision);
968: DBMS_SQL.column_value(c,65,c_sales_order_line);
969: DBMS_SQL.column_value(c,66,c_sales_order_date);
970: DBMS_SQL.column_value(c,67,c_inventory_item_id);
971: DBMS_SQL.column_value(c,68,c_header_category);
972: DBMS_SQL.column_value(c,69,c_header_attr1);
973: DBMS_SQL.column_value(c,70,c_header_attr2);
974: DBMS_SQL.column_value(c,71,c_header_attr3);
975: DBMS_SQL.column_value(c,72,c_header_attr4);

Line 972: DBMS_SQL.column_value(c,69,c_header_attr1);

968: DBMS_SQL.column_value(c,65,c_sales_order_line);
969: DBMS_SQL.column_value(c,66,c_sales_order_date);
970: DBMS_SQL.column_value(c,67,c_inventory_item_id);
971: DBMS_SQL.column_value(c,68,c_header_category);
972: DBMS_SQL.column_value(c,69,c_header_attr1);
973: DBMS_SQL.column_value(c,70,c_header_attr2);
974: DBMS_SQL.column_value(c,71,c_header_attr3);
975: DBMS_SQL.column_value(c,72,c_header_attr4);
976: DBMS_SQL.column_value(c,73,c_header_attr5);

Line 973: DBMS_SQL.column_value(c,70,c_header_attr2);

969: DBMS_SQL.column_value(c,66,c_sales_order_date);
970: DBMS_SQL.column_value(c,67,c_inventory_item_id);
971: DBMS_SQL.column_value(c,68,c_header_category);
972: DBMS_SQL.column_value(c,69,c_header_attr1);
973: DBMS_SQL.column_value(c,70,c_header_attr2);
974: DBMS_SQL.column_value(c,71,c_header_attr3);
975: DBMS_SQL.column_value(c,72,c_header_attr4);
976: DBMS_SQL.column_value(c,73,c_header_attr5);
977: DBMS_SQL.column_value(c,74,c_header_attr6);

Line 974: DBMS_SQL.column_value(c,71,c_header_attr3);

970: DBMS_SQL.column_value(c,67,c_inventory_item_id);
971: DBMS_SQL.column_value(c,68,c_header_category);
972: DBMS_SQL.column_value(c,69,c_header_attr1);
973: DBMS_SQL.column_value(c,70,c_header_attr2);
974: DBMS_SQL.column_value(c,71,c_header_attr3);
975: DBMS_SQL.column_value(c,72,c_header_attr4);
976: DBMS_SQL.column_value(c,73,c_header_attr5);
977: DBMS_SQL.column_value(c,74,c_header_attr6);
978: DBMS_SQL.column_value(c,75,c_header_attr7);

Line 975: DBMS_SQL.column_value(c,72,c_header_attr4);

971: DBMS_SQL.column_value(c,68,c_header_category);
972: DBMS_SQL.column_value(c,69,c_header_attr1);
973: DBMS_SQL.column_value(c,70,c_header_attr2);
974: DBMS_SQL.column_value(c,71,c_header_attr3);
975: DBMS_SQL.column_value(c,72,c_header_attr4);
976: DBMS_SQL.column_value(c,73,c_header_attr5);
977: DBMS_SQL.column_value(c,74,c_header_attr6);
978: DBMS_SQL.column_value(c,75,c_header_attr7);
979: DBMS_SQL.column_value(c,76,c_header_attr8);

Line 976: DBMS_SQL.column_value(c,73,c_header_attr5);

972: DBMS_SQL.column_value(c,69,c_header_attr1);
973: DBMS_SQL.column_value(c,70,c_header_attr2);
974: DBMS_SQL.column_value(c,71,c_header_attr3);
975: DBMS_SQL.column_value(c,72,c_header_attr4);
976: DBMS_SQL.column_value(c,73,c_header_attr5);
977: DBMS_SQL.column_value(c,74,c_header_attr6);
978: DBMS_SQL.column_value(c,75,c_header_attr7);
979: DBMS_SQL.column_value(c,76,c_header_attr8);
980: DBMS_SQL.column_value(c,77,c_header_attr9);

Line 977: DBMS_SQL.column_value(c,74,c_header_attr6);

973: DBMS_SQL.column_value(c,70,c_header_attr2);
974: DBMS_SQL.column_value(c,71,c_header_attr3);
975: DBMS_SQL.column_value(c,72,c_header_attr4);
976: DBMS_SQL.column_value(c,73,c_header_attr5);
977: DBMS_SQL.column_value(c,74,c_header_attr6);
978: DBMS_SQL.column_value(c,75,c_header_attr7);
979: DBMS_SQL.column_value(c,76,c_header_attr8);
980: DBMS_SQL.column_value(c,77,c_header_attr9);
981: DBMS_SQL.column_value(c,78,c_header_attr10);

Line 978: DBMS_SQL.column_value(c,75,c_header_attr7);

974: DBMS_SQL.column_value(c,71,c_header_attr3);
975: DBMS_SQL.column_value(c,72,c_header_attr4);
976: DBMS_SQL.column_value(c,73,c_header_attr5);
977: DBMS_SQL.column_value(c,74,c_header_attr6);
978: DBMS_SQL.column_value(c,75,c_header_attr7);
979: DBMS_SQL.column_value(c,76,c_header_attr8);
980: DBMS_SQL.column_value(c,77,c_header_attr9);
981: DBMS_SQL.column_value(c,78,c_header_attr10);
982: DBMS_SQL.column_value(c,79,c_header_attr11);

Line 979: DBMS_SQL.column_value(c,76,c_header_attr8);

975: DBMS_SQL.column_value(c,72,c_header_attr4);
976: DBMS_SQL.column_value(c,73,c_header_attr5);
977: DBMS_SQL.column_value(c,74,c_header_attr6);
978: DBMS_SQL.column_value(c,75,c_header_attr7);
979: DBMS_SQL.column_value(c,76,c_header_attr8);
980: DBMS_SQL.column_value(c,77,c_header_attr9);
981: DBMS_SQL.column_value(c,78,c_header_attr10);
982: DBMS_SQL.column_value(c,79,c_header_attr11);
983: DBMS_SQL.column_value(c,80,c_header_attr12);

Line 980: DBMS_SQL.column_value(c,77,c_header_attr9);

976: DBMS_SQL.column_value(c,73,c_header_attr5);
977: DBMS_SQL.column_value(c,74,c_header_attr6);
978: DBMS_SQL.column_value(c,75,c_header_attr7);
979: DBMS_SQL.column_value(c,76,c_header_attr8);
980: DBMS_SQL.column_value(c,77,c_header_attr9);
981: DBMS_SQL.column_value(c,78,c_header_attr10);
982: DBMS_SQL.column_value(c,79,c_header_attr11);
983: DBMS_SQL.column_value(c,80,c_header_attr12);
984: DBMS_SQL.column_value(c,81,c_header_attr13);

Line 981: DBMS_SQL.column_value(c,78,c_header_attr10);

977: DBMS_SQL.column_value(c,74,c_header_attr6);
978: DBMS_SQL.column_value(c,75,c_header_attr7);
979: DBMS_SQL.column_value(c,76,c_header_attr8);
980: DBMS_SQL.column_value(c,77,c_header_attr9);
981: DBMS_SQL.column_value(c,78,c_header_attr10);
982: DBMS_SQL.column_value(c,79,c_header_attr11);
983: DBMS_SQL.column_value(c,80,c_header_attr12);
984: DBMS_SQL.column_value(c,81,c_header_attr13);
985: DBMS_SQL.column_value(c,82,c_header_attr14);

Line 982: DBMS_SQL.column_value(c,79,c_header_attr11);

978: DBMS_SQL.column_value(c,75,c_header_attr7);
979: DBMS_SQL.column_value(c,76,c_header_attr8);
980: DBMS_SQL.column_value(c,77,c_header_attr9);
981: DBMS_SQL.column_value(c,78,c_header_attr10);
982: DBMS_SQL.column_value(c,79,c_header_attr11);
983: DBMS_SQL.column_value(c,80,c_header_attr12);
984: DBMS_SQL.column_value(c,81,c_header_attr13);
985: DBMS_SQL.column_value(c,82,c_header_attr14);
986: DBMS_SQL.column_value(c,83,c_header_attr15);

Line 983: DBMS_SQL.column_value(c,80,c_header_attr12);

979: DBMS_SQL.column_value(c,76,c_header_attr8);
980: DBMS_SQL.column_value(c,77,c_header_attr9);
981: DBMS_SQL.column_value(c,78,c_header_attr10);
982: DBMS_SQL.column_value(c,79,c_header_attr11);
983: DBMS_SQL.column_value(c,80,c_header_attr12);
984: DBMS_SQL.column_value(c,81,c_header_attr13);
985: DBMS_SQL.column_value(c,82,c_header_attr14);
986: DBMS_SQL.column_value(c,83,c_header_attr15);
987: DBMS_SQL.column_value(c,84,c_line_category);

Line 984: DBMS_SQL.column_value(c,81,c_header_attr13);

980: DBMS_SQL.column_value(c,77,c_header_attr9);
981: DBMS_SQL.column_value(c,78,c_header_attr10);
982: DBMS_SQL.column_value(c,79,c_header_attr11);
983: DBMS_SQL.column_value(c,80,c_header_attr12);
984: DBMS_SQL.column_value(c,81,c_header_attr13);
985: DBMS_SQL.column_value(c,82,c_header_attr14);
986: DBMS_SQL.column_value(c,83,c_header_attr15);
987: DBMS_SQL.column_value(c,84,c_line_category);
988: DBMS_SQL.column_value(c,85,c_line_attr1);

Line 985: DBMS_SQL.column_value(c,82,c_header_attr14);

981: DBMS_SQL.column_value(c,78,c_header_attr10);
982: DBMS_SQL.column_value(c,79,c_header_attr11);
983: DBMS_SQL.column_value(c,80,c_header_attr12);
984: DBMS_SQL.column_value(c,81,c_header_attr13);
985: DBMS_SQL.column_value(c,82,c_header_attr14);
986: DBMS_SQL.column_value(c,83,c_header_attr15);
987: DBMS_SQL.column_value(c,84,c_line_category);
988: DBMS_SQL.column_value(c,85,c_line_attr1);
989: DBMS_SQL.column_value(c,86,c_line_attr2);

Line 986: DBMS_SQL.column_value(c,83,c_header_attr15);

982: DBMS_SQL.column_value(c,79,c_header_attr11);
983: DBMS_SQL.column_value(c,80,c_header_attr12);
984: DBMS_SQL.column_value(c,81,c_header_attr13);
985: DBMS_SQL.column_value(c,82,c_header_attr14);
986: DBMS_SQL.column_value(c,83,c_header_attr15);
987: DBMS_SQL.column_value(c,84,c_line_category);
988: DBMS_SQL.column_value(c,85,c_line_attr1);
989: DBMS_SQL.column_value(c,86,c_line_attr2);
990: DBMS_SQL.column_value(c,87,c_line_attr3);

Line 987: DBMS_SQL.column_value(c,84,c_line_category);

983: DBMS_SQL.column_value(c,80,c_header_attr12);
984: DBMS_SQL.column_value(c,81,c_header_attr13);
985: DBMS_SQL.column_value(c,82,c_header_attr14);
986: DBMS_SQL.column_value(c,83,c_header_attr15);
987: DBMS_SQL.column_value(c,84,c_line_category);
988: DBMS_SQL.column_value(c,85,c_line_attr1);
989: DBMS_SQL.column_value(c,86,c_line_attr2);
990: DBMS_SQL.column_value(c,87,c_line_attr3);
991: DBMS_SQL.column_value(c,88,c_line_attr4);

Line 988: DBMS_SQL.column_value(c,85,c_line_attr1);

984: DBMS_SQL.column_value(c,81,c_header_attr13);
985: DBMS_SQL.column_value(c,82,c_header_attr14);
986: DBMS_SQL.column_value(c,83,c_header_attr15);
987: DBMS_SQL.column_value(c,84,c_line_category);
988: DBMS_SQL.column_value(c,85,c_line_attr1);
989: DBMS_SQL.column_value(c,86,c_line_attr2);
990: DBMS_SQL.column_value(c,87,c_line_attr3);
991: DBMS_SQL.column_value(c,88,c_line_attr4);
992: DBMS_SQL.column_value(c,89,c_line_attr5);

Line 989: DBMS_SQL.column_value(c,86,c_line_attr2);

985: DBMS_SQL.column_value(c,82,c_header_attr14);
986: DBMS_SQL.column_value(c,83,c_header_attr15);
987: DBMS_SQL.column_value(c,84,c_line_category);
988: DBMS_SQL.column_value(c,85,c_line_attr1);
989: DBMS_SQL.column_value(c,86,c_line_attr2);
990: DBMS_SQL.column_value(c,87,c_line_attr3);
991: DBMS_SQL.column_value(c,88,c_line_attr4);
992: DBMS_SQL.column_value(c,89,c_line_attr5);
993: DBMS_SQL.column_value(c,90,c_line_attr6);

Line 990: DBMS_SQL.column_value(c,87,c_line_attr3);

986: DBMS_SQL.column_value(c,83,c_header_attr15);
987: DBMS_SQL.column_value(c,84,c_line_category);
988: DBMS_SQL.column_value(c,85,c_line_attr1);
989: DBMS_SQL.column_value(c,86,c_line_attr2);
990: DBMS_SQL.column_value(c,87,c_line_attr3);
991: DBMS_SQL.column_value(c,88,c_line_attr4);
992: DBMS_SQL.column_value(c,89,c_line_attr5);
993: DBMS_SQL.column_value(c,90,c_line_attr6);
994: DBMS_SQL.column_value(c,91,c_line_attr7);

Line 991: DBMS_SQL.column_value(c,88,c_line_attr4);

987: DBMS_SQL.column_value(c,84,c_line_category);
988: DBMS_SQL.column_value(c,85,c_line_attr1);
989: DBMS_SQL.column_value(c,86,c_line_attr2);
990: DBMS_SQL.column_value(c,87,c_line_attr3);
991: DBMS_SQL.column_value(c,88,c_line_attr4);
992: DBMS_SQL.column_value(c,89,c_line_attr5);
993: DBMS_SQL.column_value(c,90,c_line_attr6);
994: DBMS_SQL.column_value(c,91,c_line_attr7);
995: DBMS_SQL.column_value(c,92,c_line_attr8);

Line 992: DBMS_SQL.column_value(c,89,c_line_attr5);

988: DBMS_SQL.column_value(c,85,c_line_attr1);
989: DBMS_SQL.column_value(c,86,c_line_attr2);
990: DBMS_SQL.column_value(c,87,c_line_attr3);
991: DBMS_SQL.column_value(c,88,c_line_attr4);
992: DBMS_SQL.column_value(c,89,c_line_attr5);
993: DBMS_SQL.column_value(c,90,c_line_attr6);
994: DBMS_SQL.column_value(c,91,c_line_attr7);
995: DBMS_SQL.column_value(c,92,c_line_attr8);
996: DBMS_SQL.column_value(c,93,c_line_attr9);

Line 993: DBMS_SQL.column_value(c,90,c_line_attr6);

989: DBMS_SQL.column_value(c,86,c_line_attr2);
990: DBMS_SQL.column_value(c,87,c_line_attr3);
991: DBMS_SQL.column_value(c,88,c_line_attr4);
992: DBMS_SQL.column_value(c,89,c_line_attr5);
993: DBMS_SQL.column_value(c,90,c_line_attr6);
994: DBMS_SQL.column_value(c,91,c_line_attr7);
995: DBMS_SQL.column_value(c,92,c_line_attr8);
996: DBMS_SQL.column_value(c,93,c_line_attr9);
997: DBMS_SQL.column_value(c,94,c_line_attr10);

Line 994: DBMS_SQL.column_value(c,91,c_line_attr7);

990: DBMS_SQL.column_value(c,87,c_line_attr3);
991: DBMS_SQL.column_value(c,88,c_line_attr4);
992: DBMS_SQL.column_value(c,89,c_line_attr5);
993: DBMS_SQL.column_value(c,90,c_line_attr6);
994: DBMS_SQL.column_value(c,91,c_line_attr7);
995: DBMS_SQL.column_value(c,92,c_line_attr8);
996: DBMS_SQL.column_value(c,93,c_line_attr9);
997: DBMS_SQL.column_value(c,94,c_line_attr10);
998: DBMS_SQL.column_value(c,95,c_line_attr11);

Line 995: DBMS_SQL.column_value(c,92,c_line_attr8);

991: DBMS_SQL.column_value(c,88,c_line_attr4);
992: DBMS_SQL.column_value(c,89,c_line_attr5);
993: DBMS_SQL.column_value(c,90,c_line_attr6);
994: DBMS_SQL.column_value(c,91,c_line_attr7);
995: DBMS_SQL.column_value(c,92,c_line_attr8);
996: DBMS_SQL.column_value(c,93,c_line_attr9);
997: DBMS_SQL.column_value(c,94,c_line_attr10);
998: DBMS_SQL.column_value(c,95,c_line_attr11);
999: DBMS_SQL.column_value(c,96,c_line_attr12);

Line 996: DBMS_SQL.column_value(c,93,c_line_attr9);

992: DBMS_SQL.column_value(c,89,c_line_attr5);
993: DBMS_SQL.column_value(c,90,c_line_attr6);
994: DBMS_SQL.column_value(c,91,c_line_attr7);
995: DBMS_SQL.column_value(c,92,c_line_attr8);
996: DBMS_SQL.column_value(c,93,c_line_attr9);
997: DBMS_SQL.column_value(c,94,c_line_attr10);
998: DBMS_SQL.column_value(c,95,c_line_attr11);
999: DBMS_SQL.column_value(c,96,c_line_attr12);
1000: DBMS_SQL.column_value(c,97,c_line_attr13);

Line 997: DBMS_SQL.column_value(c,94,c_line_attr10);

993: DBMS_SQL.column_value(c,90,c_line_attr6);
994: DBMS_SQL.column_value(c,91,c_line_attr7);
995: DBMS_SQL.column_value(c,92,c_line_attr8);
996: DBMS_SQL.column_value(c,93,c_line_attr9);
997: DBMS_SQL.column_value(c,94,c_line_attr10);
998: DBMS_SQL.column_value(c,95,c_line_attr11);
999: DBMS_SQL.column_value(c,96,c_line_attr12);
1000: DBMS_SQL.column_value(c,97,c_line_attr13);
1001: DBMS_SQL.column_value(c,98,c_line_attr14);

Line 998: DBMS_SQL.column_value(c,95,c_line_attr11);

994: DBMS_SQL.column_value(c,91,c_line_attr7);
995: DBMS_SQL.column_value(c,92,c_line_attr8);
996: DBMS_SQL.column_value(c,93,c_line_attr9);
997: DBMS_SQL.column_value(c,94,c_line_attr10);
998: DBMS_SQL.column_value(c,95,c_line_attr11);
999: DBMS_SQL.column_value(c,96,c_line_attr12);
1000: DBMS_SQL.column_value(c,97,c_line_attr13);
1001: DBMS_SQL.column_value(c,98,c_line_attr14);
1002: DBMS_SQL.column_value(c,99,c_line_attr15);

Line 999: DBMS_SQL.column_value(c,96,c_line_attr12);

995: DBMS_SQL.column_value(c,92,c_line_attr8);
996: DBMS_SQL.column_value(c,93,c_line_attr9);
997: DBMS_SQL.column_value(c,94,c_line_attr10);
998: DBMS_SQL.column_value(c,95,c_line_attr11);
999: DBMS_SQL.column_value(c,96,c_line_attr12);
1000: DBMS_SQL.column_value(c,97,c_line_attr13);
1001: DBMS_SQL.column_value(c,98,c_line_attr14);
1002: DBMS_SQL.column_value(c,99,c_line_attr15);
1003: DBMS_SQL.column_value(c,100,c_type_name);

Line 1000: DBMS_SQL.column_value(c,97,c_line_attr13);

996: DBMS_SQL.column_value(c,93,c_line_attr9);
997: DBMS_SQL.column_value(c,94,c_line_attr10);
998: DBMS_SQL.column_value(c,95,c_line_attr11);
999: DBMS_SQL.column_value(c,96,c_line_attr12);
1000: DBMS_SQL.column_value(c,97,c_line_attr13);
1001: DBMS_SQL.column_value(c,98,c_line_attr14);
1002: DBMS_SQL.column_value(c,99,c_line_attr15);
1003: DBMS_SQL.column_value(c,100,c_type_name);
1004:

Line 1001: DBMS_SQL.column_value(c,98,c_line_attr14);

997: DBMS_SQL.column_value(c,94,c_line_attr10);
998: DBMS_SQL.column_value(c,95,c_line_attr11);
999: DBMS_SQL.column_value(c,96,c_line_attr12);
1000: DBMS_SQL.column_value(c,97,c_line_attr13);
1001: DBMS_SQL.column_value(c,98,c_line_attr14);
1002: DBMS_SQL.column_value(c,99,c_line_attr15);
1003: DBMS_SQL.column_value(c,100,c_type_name);
1004:
1005:

Line 1002: DBMS_SQL.column_value(c,99,c_line_attr15);

998: DBMS_SQL.column_value(c,95,c_line_attr11);
999: DBMS_SQL.column_value(c,96,c_line_attr12);
1000: DBMS_SQL.column_value(c,97,c_line_attr13);
1001: DBMS_SQL.column_value(c,98,c_line_attr14);
1002: DBMS_SQL.column_value(c,99,c_line_attr15);
1003: DBMS_SQL.column_value(c,100,c_type_name);
1004:
1005:
1006: -- get customer information for ship-to, bill-to and sold-to

Line 1003: DBMS_SQL.column_value(c,100,c_type_name);

999: DBMS_SQL.column_value(c,96,c_line_attr12);
1000: DBMS_SQL.column_value(c,97,c_line_attr13);
1001: DBMS_SQL.column_value(c,98,c_line_attr14);
1002: DBMS_SQL.column_value(c,99,c_line_attr15);
1003: DBMS_SQL.column_value(c,100,c_type_name);
1004:
1005:
1006: -- get customer information for ship-to, bill-to and sold-to
1007: -- first initialize the columns

Line 1307: DBMS_SQL.close_cursor(c);

1303: c_counter := c_counter + 1;
1304: end loop;
1305:
1306: -- close cursor
1307: DBMS_SQL.close_cursor(c);
1308:
1309: success := TRUE;
1310: if c_counter = 0 then
1311: ARRX_SALES_TAX_REP.WRITE_LOG(

Line 1335: if dbms_sql.is_open(c) then

1331: mesg := in_mesg;
1332:
1333:
1334: when others then
1335: if dbms_sql.is_open(c) then
1336: dbms_sql.close_cursor(c);
1337: end if;
1338: success := FALSE;
1339: ARRX_SALES_TAX_REP.WRITE_LOG(

Line 1336: dbms_sql.close_cursor(c);

1332:
1333:
1334: when others then
1335: if dbms_sql.is_open(c) then
1336: dbms_sql.close_cursor(c);
1337: end if;
1338: success := FALSE;
1339: ARRX_SALES_TAX_REP.WRITE_LOG(
1340: fc_which => 1,