DBA Data[Home] [Help]

APPS.INL_CHARGE_PVT dependencies on DBMS_SQL

Line 635: l_currency_code DBMS_SQL.varchar2_table;

631: l_charge_ln_index NUMBER := NVL(x_charge_ln_tbl.count,0) + 1;
632: l_pass_line VARCHAR2(1);
633: l_exception_msg VARCHAR2(2000);
634: l_qp_license VARCHAR2(30) := NULL;
635: l_currency_code DBMS_SQL.varchar2_table;
636: l_line_quantities DBMS_SQL.number_table;
637: l_line_1ary_quantities DBMS_SQL.number_table; --BUG#8928845
638:
639: l_request_type_code_tbl QP_PREQ_GRP.varchar_type;

Line 636: l_line_quantities DBMS_SQL.number_table;

632: l_pass_line VARCHAR2(1);
633: l_exception_msg VARCHAR2(2000);
634: l_qp_license VARCHAR2(30) := NULL;
635: l_currency_code DBMS_SQL.varchar2_table;
636: l_line_quantities DBMS_SQL.number_table;
637: l_line_1ary_quantities DBMS_SQL.number_table; --BUG#8928845
638:
639: l_request_type_code_tbl QP_PREQ_GRP.varchar_type;
640: l_line_id_tbl QP_PREQ_GRP.number_type;

Line 637: l_line_1ary_quantities DBMS_SQL.number_table; --BUG#8928845

633: l_exception_msg VARCHAR2(2000);
634: l_qp_license VARCHAR2(30) := NULL;
635: l_currency_code DBMS_SQL.varchar2_table;
636: l_line_quantities DBMS_SQL.number_table;
637: l_line_1ary_quantities DBMS_SQL.number_table; --BUG#8928845
638:
639: l_request_type_code_tbl QP_PREQ_GRP.varchar_type;
640: l_line_id_tbl QP_PREQ_GRP.number_type;
641: l_line_index_tbl QP_PREQ_GRP.pls_integer_type;

Line 2496: l_ship_ln_group_id_tbl DBMS_SQL.number_table;

2492: l_override_default_processing BOOLEAN := FALSE;
2493: l_firm_simulation NUMBER;
2494:
2495: l_ship_ln_group_rec ship_ln_group_rec;
2496: l_ship_ln_group_id_tbl DBMS_SQL.number_table;
2497: l_association_tbl DBMS_SQL.number_table;
2498: l_charge_line_tbl DBMS_SQL.number_table;
2499:
2500: l_charge_ln_tbl charge_ln_tbl;

Line 2497: l_association_tbl DBMS_SQL.number_table;

2493: l_firm_simulation NUMBER;
2494:
2495: l_ship_ln_group_rec ship_ln_group_rec;
2496: l_ship_ln_group_id_tbl DBMS_SQL.number_table;
2497: l_association_tbl DBMS_SQL.number_table;
2498: l_charge_line_tbl DBMS_SQL.number_table;
2499:
2500: l_charge_ln_tbl charge_ln_tbl;
2501:

Line 2498: l_charge_line_tbl DBMS_SQL.number_table;

2494:
2495: l_ship_ln_group_rec ship_ln_group_rec;
2496: l_ship_ln_group_id_tbl DBMS_SQL.number_table;
2497: l_association_tbl DBMS_SQL.number_table;
2498: l_charge_line_tbl DBMS_SQL.number_table;
2499:
2500: l_charge_ln_tbl charge_ln_tbl;
2501:
2502: l_currency_conversion_rate NUMBER;