DBA Data[Home] [Help]

APPS.INL_CHARGE_PVT dependencies on DBMS_SQL

Line 577: l_currency_code DBMS_SQL.varchar2_table;

573: l_line_index PLS_INTEGER := 1;
574: l_charge_ln_index NUMBER := 1;
575: l_pass_line VARCHAR2(1);
576: l_exception_msg VARCHAR2(2000);
577: l_currency_code DBMS_SQL.varchar2_table;
578: l_line_quantities DBMS_SQL.number_table;
579:
580: l_request_type_code_tbl QP_PREQ_GRP.varchar_type;
581: l_line_id_tbl QP_PREQ_GRP.number_type;

Line 578: l_line_quantities DBMS_SQL.number_table;

574: l_charge_ln_index NUMBER := 1;
575: l_pass_line VARCHAR2(1);
576: l_exception_msg VARCHAR2(2000);
577: l_currency_code DBMS_SQL.varchar2_table;
578: l_line_quantities DBMS_SQL.number_table;
579:
580: l_request_type_code_tbl QP_PREQ_GRP.varchar_type;
581: l_line_id_tbl QP_PREQ_GRP.number_type;
582: l_line_index_tbl QP_PREQ_GRP.pls_integer_type;

Line 1091: l_ship_ln_group_id_tbl DBMS_SQL.number_table;

1087: l_qp_curr_conv_type VARCHAR2(20);
1088: l_qp_curr_conv_date DATE;
1089:
1090: l_ship_ln_group_rec ship_ln_group_rec;
1091: l_ship_ln_group_id_tbl DBMS_SQL.number_table;
1092: l_association_tbl DBMS_SQL.number_table;
1093: l_charge_line_tbl DBMS_SQL.number_table;
1094: l_ship_ln_tbl ship_ln_tbl;
1095: l_charge_ln_tbl charge_ln_tbl;

Line 1092: l_association_tbl DBMS_SQL.number_table;

1088: l_qp_curr_conv_date DATE;
1089:
1090: l_ship_ln_group_rec ship_ln_group_rec;
1091: l_ship_ln_group_id_tbl DBMS_SQL.number_table;
1092: l_association_tbl DBMS_SQL.number_table;
1093: l_charge_line_tbl DBMS_SQL.number_table;
1094: l_ship_ln_tbl ship_ln_tbl;
1095: l_charge_ln_tbl charge_ln_tbl;
1096: l_currency_conversion_rate NUMBER;

Line 1093: l_charge_line_tbl DBMS_SQL.number_table;

1089:
1090: l_ship_ln_group_rec ship_ln_group_rec;
1091: l_ship_ln_group_id_tbl DBMS_SQL.number_table;
1092: l_association_tbl DBMS_SQL.number_table;
1093: l_charge_line_tbl DBMS_SQL.number_table;
1094: l_ship_ln_tbl ship_ln_tbl;
1095: l_charge_ln_tbl charge_ln_tbl;
1096: l_currency_conversion_rate NUMBER;
1097: