eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_QUANTITY_TREE_PVT dependencies on DBMS_SQL

Line 1076: l_cursor := dbms_sql.open_cursor;

1072: l_temp_str VARCHAR2(30);
1073: l_err VARCHAR2(240);
1074: l_pos NUMBER;
1075: BEGIN
1076: l_cursor := dbms_sql.open_cursor;
1077:
1078: --bug 2363739 - we now call unit_effective_item instead of
1079: -- enabled in the pjm_unit_eff API. This will improve performance
1080: -- by limiting the number of times we use the PJM function to determine

Line 1103: dbms_sql.parse(l_cursor,l_sql,dbms_sql.v7);

1099: --dbms_output.put_line('start build sql');
1100: --inv_ppcommon_pvt.showsql(l_sql);
1101: --dbms_output.put_line('end build sql');
1102: BEGIN
1103: dbms_sql.parse(l_cursor,l_sql,dbms_sql.v7);
1104: EXCEPTION
1105: WHEN OTHERS THEN
1106: l_last_error_pos := dbms_sql.last_error_position();
1107: l_temp_str := Substr(l_sql, l_last_error_pos-5, 30);

Line 1106: l_last_error_pos := dbms_sql.last_error_position();

1102: BEGIN
1103: dbms_sql.parse(l_cursor,l_sql,dbms_sql.v7);
1104: EXCEPTION
1105: WHEN OTHERS THEN
1106: l_last_error_pos := dbms_sql.last_error_position();
1107: l_temp_str := Substr(l_sql, l_last_error_pos-5, 30);
1108: RAISE;
1109: END;
1110:

Line 1111: dbms_sql.bind_variable(l_cursor, ':organization_id', p_organization_id);

1107: l_temp_str := Substr(l_sql, l_last_error_pos-5, 30);
1108: RAISE;
1109: END;
1110:
1111: dbms_sql.bind_variable(l_cursor, ':organization_id', p_organization_id);
1112: dbms_sql.bind_variable(l_cursor, ':inventory_item_id', p_inventory_item_id);
1113: --Bug 1387420 - performance
1114: -- no longer check rsvs for txn mode
1115: --IF p_mode IN (g_transaction_mode, g_loose_only_mode) OR

Line 1112: dbms_sql.bind_variable(l_cursor, ':inventory_item_id', p_inventory_item_id);

1108: RAISE;
1109: END;
1110:
1111: dbms_sql.bind_variable(l_cursor, ':organization_id', p_organization_id);
1112: dbms_sql.bind_variable(l_cursor, ':inventory_item_id', p_inventory_item_id);
1113: --Bug 1387420 - performance
1114: -- no longer check rsvs for txn mode
1115: --IF p_mode IN (g_transaction_mode, g_loose_only_mode) OR
1116: IF p_mode IN (g_loose_only_mode) THEN

Line 1117: dbms_sql.bind_variable(l_cursor, ':demand_source_type_id', p_demand_source_type_id);

1113: --Bug 1387420 - performance
1114: -- no longer check rsvs for txn mode
1115: --IF p_mode IN (g_transaction_mode, g_loose_only_mode) OR
1116: IF p_mode IN (g_loose_only_mode) THEN
1117: dbms_sql.bind_variable(l_cursor, ':demand_source_type_id', p_demand_source_type_id);
1118: dbms_sql.bind_variable(l_cursor, ':demand_source_header_id', p_demand_source_header_id);
1119: dbms_sql.bind_variable(l_cursor, ':demand_source_name', p_demand_source_name);
1120: dbms_sql.bind_variable(l_cursor, ':demand_source_delivery', p_demand_source_delivery);
1121: END IF;

Line 1118: dbms_sql.bind_variable(l_cursor, ':demand_source_header_id', p_demand_source_header_id);

1114: -- no longer check rsvs for txn mode
1115: --IF p_mode IN (g_transaction_mode, g_loose_only_mode) OR
1116: IF p_mode IN (g_loose_only_mode) THEN
1117: dbms_sql.bind_variable(l_cursor, ':demand_source_type_id', p_demand_source_type_id);
1118: dbms_sql.bind_variable(l_cursor, ':demand_source_header_id', p_demand_source_header_id);
1119: dbms_sql.bind_variable(l_cursor, ':demand_source_name', p_demand_source_name);
1120: dbms_sql.bind_variable(l_cursor, ':demand_source_delivery', p_demand_source_delivery);
1121: END IF;
1122: --

Line 1119: dbms_sql.bind_variable(l_cursor, ':demand_source_name', p_demand_source_name);

1115: --IF p_mode IN (g_transaction_mode, g_loose_only_mode) OR
1116: IF p_mode IN (g_loose_only_mode) THEN
1117: dbms_sql.bind_variable(l_cursor, ':demand_source_type_id', p_demand_source_type_id);
1118: dbms_sql.bind_variable(l_cursor, ':demand_source_header_id', p_demand_source_header_id);
1119: dbms_sql.bind_variable(l_cursor, ':demand_source_name', p_demand_source_name);
1120: dbms_sql.bind_variable(l_cursor, ':demand_source_delivery', p_demand_source_delivery);
1121: END IF;
1122: --
1123: --Bug 1387420 - performance

Line 1120: dbms_sql.bind_variable(l_cursor, ':demand_source_delivery', p_demand_source_delivery);

1116: IF p_mode IN (g_loose_only_mode) THEN
1117: dbms_sql.bind_variable(l_cursor, ':demand_source_type_id', p_demand_source_type_id);
1118: dbms_sql.bind_variable(l_cursor, ':demand_source_header_id', p_demand_source_header_id);
1119: dbms_sql.bind_variable(l_cursor, ':demand_source_name', p_demand_source_name);
1120: dbms_sql.bind_variable(l_cursor, ':demand_source_delivery', p_demand_source_delivery);
1121: END IF;
1122: --
1123: --Bug 1387420 - performance
1124: -- no longer check rsvs for txn mode

Line 1131: dbms_sql.bind_variable(l_cursor, ':demand_source_line_id', to_number(NULL));

1127: -- Bug 2346202: Since the value of -9999 for demand_source_line_id is
1128: -- equivalent to that being NULL, changed the setting the value of
1129: -- bind variable appropriately.
1130: IF(p_demand_source_line_id = -9999) THEN
1131: dbms_sql.bind_variable(l_cursor, ':demand_source_line_id', to_number(NULL));
1132: ELSE
1133: dbms_sql.bind_variable(l_cursor, ':demand_source_line_id', p_demand_source_line_id);
1134: END IF;
1135: END IF;

Line 1133: dbms_sql.bind_variable(l_cursor, ':demand_source_line_id', p_demand_source_line_id);

1129: -- bind variable appropriately.
1130: IF(p_demand_source_line_id = -9999) THEN
1131: dbms_sql.bind_variable(l_cursor, ':demand_source_line_id', to_number(NULL));
1132: ELSE
1133: dbms_sql.bind_variable(l_cursor, ':demand_source_line_id', p_demand_source_line_id);
1134: END IF;
1135: END IF;
1136:
1137: --

Line 1139: dbms_sql.bind_variable(l_cursor, ':lot_expiration_date'

1135: END IF;
1136:
1137: --
1138: IF p_is_lot_control AND p_lot_expiration_date IS NOT NULL THEN
1139: dbms_sql.bind_variable(l_cursor, ':lot_expiration_date'
1140: , p_lot_expiration_date);
1141: END IF;
1142:
1143: x_cursor := l_cursor;

Line 1149: -- || dbms_sql.last_error_position);

1145:
1146: EXCEPTION
1147: WHEN OTHERS THEN
1148: -- dbms_output.put_line('last_error_position : '
1149: -- || dbms_sql.last_error_position);
1150: -- l_err := Substr(Sqlerrm,1,240);
1151: -- dbms_output.put_line(l_err);
1152: -- l_err := Substr(Sqlerrm,1,240);
1153: -- dbms_output.put_line(l_err);

Line 1154: -- l_pos := dbms_sql.last_error_position;

1150: -- l_err := Substr(Sqlerrm,1,240);
1151: -- dbms_output.put_line(l_err);
1152: -- l_err := Substr(Sqlerrm,1,240);
1153: -- dbms_output.put_line(l_err);
1154: -- l_pos := dbms_sql.last_error_position;
1155: -- l_err := Substr(l_sql,1,240);
1156: -- dbms_output.put_line(l_err);
1157: -- dbms_output.put_line(Sqlerrm);
1158: -- dbms_output.put_line('start');

Line 1265: dbms_sql.define_column(l_cursor,1,l_organization_id);

1261: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1262: RAISE fnd_api.g_exc_unexpected_error;
1263: END IF;
1264:
1265: dbms_sql.define_column(l_cursor,1,l_organization_id);
1266: dbms_sql.define_column(l_cursor,2,l_inventory_item_id);
1267: dbms_sql.define_column(l_cursor,3,l_revision,3);
1268: dbms_sql.define_column(l_cursor,4,l_lot_number,30);
1269: dbms_sql.define_column(l_cursor,5,l_lot_expiration_date);

Line 1266: dbms_sql.define_column(l_cursor,2,l_inventory_item_id);

1262: RAISE fnd_api.g_exc_unexpected_error;
1263: END IF;
1264:
1265: dbms_sql.define_column(l_cursor,1,l_organization_id);
1266: dbms_sql.define_column(l_cursor,2,l_inventory_item_id);
1267: dbms_sql.define_column(l_cursor,3,l_revision,3);
1268: dbms_sql.define_column(l_cursor,4,l_lot_number,30);
1269: dbms_sql.define_column(l_cursor,5,l_lot_expiration_date);
1270: dbms_sql.define_column(l_cursor,6,l_subinventory_code,10);

Line 1267: dbms_sql.define_column(l_cursor,3,l_revision,3);

1263: END IF;
1264:
1265: dbms_sql.define_column(l_cursor,1,l_organization_id);
1266: dbms_sql.define_column(l_cursor,2,l_inventory_item_id);
1267: dbms_sql.define_column(l_cursor,3,l_revision,3);
1268: dbms_sql.define_column(l_cursor,4,l_lot_number,30);
1269: dbms_sql.define_column(l_cursor,5,l_lot_expiration_date);
1270: dbms_sql.define_column(l_cursor,6,l_subinventory_code,10);
1271: dbms_sql.define_column(l_cursor,7,l_reservable_type);

Line 1268: dbms_sql.define_column(l_cursor,4,l_lot_number,30);

1264:
1265: dbms_sql.define_column(l_cursor,1,l_organization_id);
1266: dbms_sql.define_column(l_cursor,2,l_inventory_item_id);
1267: dbms_sql.define_column(l_cursor,3,l_revision,3);
1268: dbms_sql.define_column(l_cursor,4,l_lot_number,30);
1269: dbms_sql.define_column(l_cursor,5,l_lot_expiration_date);
1270: dbms_sql.define_column(l_cursor,6,l_subinventory_code,10);
1271: dbms_sql.define_column(l_cursor,7,l_reservable_type);
1272: dbms_sql.define_column(l_cursor,8,l_locator_id);

Line 1269: dbms_sql.define_column(l_cursor,5,l_lot_expiration_date);

1265: dbms_sql.define_column(l_cursor,1,l_organization_id);
1266: dbms_sql.define_column(l_cursor,2,l_inventory_item_id);
1267: dbms_sql.define_column(l_cursor,3,l_revision,3);
1268: dbms_sql.define_column(l_cursor,4,l_lot_number,30);
1269: dbms_sql.define_column(l_cursor,5,l_lot_expiration_date);
1270: dbms_sql.define_column(l_cursor,6,l_subinventory_code,10);
1271: dbms_sql.define_column(l_cursor,7,l_reservable_type);
1272: dbms_sql.define_column(l_cursor,8,l_locator_id);
1273: dbms_sql.define_column(l_cursor,9,l_primary_quantity);

Line 1270: dbms_sql.define_column(l_cursor,6,l_subinventory_code,10);

1266: dbms_sql.define_column(l_cursor,2,l_inventory_item_id);
1267: dbms_sql.define_column(l_cursor,3,l_revision,3);
1268: dbms_sql.define_column(l_cursor,4,l_lot_number,30);
1269: dbms_sql.define_column(l_cursor,5,l_lot_expiration_date);
1270: dbms_sql.define_column(l_cursor,6,l_subinventory_code,10);
1271: dbms_sql.define_column(l_cursor,7,l_reservable_type);
1272: dbms_sql.define_column(l_cursor,8,l_locator_id);
1273: dbms_sql.define_column(l_cursor,9,l_primary_quantity);
1274: dbms_sql.define_column(l_cursor,10,l_date_received);

Line 1271: dbms_sql.define_column(l_cursor,7,l_reservable_type);

1267: dbms_sql.define_column(l_cursor,3,l_revision,3);
1268: dbms_sql.define_column(l_cursor,4,l_lot_number,30);
1269: dbms_sql.define_column(l_cursor,5,l_lot_expiration_date);
1270: dbms_sql.define_column(l_cursor,6,l_subinventory_code,10);
1271: dbms_sql.define_column(l_cursor,7,l_reservable_type);
1272: dbms_sql.define_column(l_cursor,8,l_locator_id);
1273: dbms_sql.define_column(l_cursor,9,l_primary_quantity);
1274: dbms_sql.define_column(l_cursor,10,l_date_received);
1275: dbms_sql.define_column(l_cursor,11,l_quantity_type);

Line 1272: dbms_sql.define_column(l_cursor,8,l_locator_id);

1268: dbms_sql.define_column(l_cursor,4,l_lot_number,30);
1269: dbms_sql.define_column(l_cursor,5,l_lot_expiration_date);
1270: dbms_sql.define_column(l_cursor,6,l_subinventory_code,10);
1271: dbms_sql.define_column(l_cursor,7,l_reservable_type);
1272: dbms_sql.define_column(l_cursor,8,l_locator_id);
1273: dbms_sql.define_column(l_cursor,9,l_primary_quantity);
1274: dbms_sql.define_column(l_cursor,10,l_date_received);
1275: dbms_sql.define_column(l_cursor,11,l_quantity_type);
1276: dbms_sql.define_column(l_cursor,12,l_cost_group_id);

Line 1273: dbms_sql.define_column(l_cursor,9,l_primary_quantity);

1269: dbms_sql.define_column(l_cursor,5,l_lot_expiration_date);
1270: dbms_sql.define_column(l_cursor,6,l_subinventory_code,10);
1271: dbms_sql.define_column(l_cursor,7,l_reservable_type);
1272: dbms_sql.define_column(l_cursor,8,l_locator_id);
1273: dbms_sql.define_column(l_cursor,9,l_primary_quantity);
1274: dbms_sql.define_column(l_cursor,10,l_date_received);
1275: dbms_sql.define_column(l_cursor,11,l_quantity_type);
1276: dbms_sql.define_column(l_cursor,12,l_cost_group_id);
1277:

Line 1274: dbms_sql.define_column(l_cursor,10,l_date_received);

1270: dbms_sql.define_column(l_cursor,6,l_subinventory_code,10);
1271: dbms_sql.define_column(l_cursor,7,l_reservable_type);
1272: dbms_sql.define_column(l_cursor,8,l_locator_id);
1273: dbms_sql.define_column(l_cursor,9,l_primary_quantity);
1274: dbms_sql.define_column(l_cursor,10,l_date_received);
1275: dbms_sql.define_column(l_cursor,11,l_quantity_type);
1276: dbms_sql.define_column(l_cursor,12,l_cost_group_id);
1277:
1278: l_dummy := dbms_sql.execute(l_cursor);

Line 1275: dbms_sql.define_column(l_cursor,11,l_quantity_type);

1271: dbms_sql.define_column(l_cursor,7,l_reservable_type);
1272: dbms_sql.define_column(l_cursor,8,l_locator_id);
1273: dbms_sql.define_column(l_cursor,9,l_primary_quantity);
1274: dbms_sql.define_column(l_cursor,10,l_date_received);
1275: dbms_sql.define_column(l_cursor,11,l_quantity_type);
1276: dbms_sql.define_column(l_cursor,12,l_cost_group_id);
1277:
1278: l_dummy := dbms_sql.execute(l_cursor);
1279: LOOP

Line 1276: dbms_sql.define_column(l_cursor,12,l_cost_group_id);

1272: dbms_sql.define_column(l_cursor,8,l_locator_id);
1273: dbms_sql.define_column(l_cursor,9,l_primary_quantity);
1274: dbms_sql.define_column(l_cursor,10,l_date_received);
1275: dbms_sql.define_column(l_cursor,11,l_quantity_type);
1276: dbms_sql.define_column(l_cursor,12,l_cost_group_id);
1277:
1278: l_dummy := dbms_sql.execute(l_cursor);
1279: LOOP
1280: IF dbms_sql.fetch_rows(l_cursor) = 0 THEN

Line 1278: l_dummy := dbms_sql.execute(l_cursor);

1274: dbms_sql.define_column(l_cursor,10,l_date_received);
1275: dbms_sql.define_column(l_cursor,11,l_quantity_type);
1276: dbms_sql.define_column(l_cursor,12,l_cost_group_id);
1277:
1278: l_dummy := dbms_sql.execute(l_cursor);
1279: LOOP
1280: IF dbms_sql.fetch_rows(l_cursor) = 0 THEN
1281: EXIT;
1282: END IF;

Line 1280: IF dbms_sql.fetch_rows(l_cursor) = 0 THEN

1276: dbms_sql.define_column(l_cursor,12,l_cost_group_id);
1277:
1278: l_dummy := dbms_sql.execute(l_cursor);
1279: LOOP
1280: IF dbms_sql.fetch_rows(l_cursor) = 0 THEN
1281: EXIT;
1282: END IF;
1283: dbms_sql.column_value(l_cursor,1,l_organization_id);
1284: dbms_sql.column_value(l_cursor,2,l_inventory_item_id);

Line 1283: dbms_sql.column_value(l_cursor,1,l_organization_id);

1279: LOOP
1280: IF dbms_sql.fetch_rows(l_cursor) = 0 THEN
1281: EXIT;
1282: END IF;
1283: dbms_sql.column_value(l_cursor,1,l_organization_id);
1284: dbms_sql.column_value(l_cursor,2,l_inventory_item_id);
1285: dbms_sql.column_value(l_cursor,3,l_revision);
1286: dbms_sql.column_value(l_cursor,4,l_lot_number);
1287: dbms_sql.column_value(l_cursor,5,l_lot_expiration_date);

Line 1284: dbms_sql.column_value(l_cursor,2,l_inventory_item_id);

1280: IF dbms_sql.fetch_rows(l_cursor) = 0 THEN
1281: EXIT;
1282: END IF;
1283: dbms_sql.column_value(l_cursor,1,l_organization_id);
1284: dbms_sql.column_value(l_cursor,2,l_inventory_item_id);
1285: dbms_sql.column_value(l_cursor,3,l_revision);
1286: dbms_sql.column_value(l_cursor,4,l_lot_number);
1287: dbms_sql.column_value(l_cursor,5,l_lot_expiration_date);
1288: dbms_sql.column_value(l_cursor,6,l_subinventory_code);

Line 1285: dbms_sql.column_value(l_cursor,3,l_revision);

1281: EXIT;
1282: END IF;
1283: dbms_sql.column_value(l_cursor,1,l_organization_id);
1284: dbms_sql.column_value(l_cursor,2,l_inventory_item_id);
1285: dbms_sql.column_value(l_cursor,3,l_revision);
1286: dbms_sql.column_value(l_cursor,4,l_lot_number);
1287: dbms_sql.column_value(l_cursor,5,l_lot_expiration_date);
1288: dbms_sql.column_value(l_cursor,6,l_subinventory_code);
1289: dbms_sql.column_value(l_cursor,7,l_reservable_type);

Line 1286: dbms_sql.column_value(l_cursor,4,l_lot_number);

1282: END IF;
1283: dbms_sql.column_value(l_cursor,1,l_organization_id);
1284: dbms_sql.column_value(l_cursor,2,l_inventory_item_id);
1285: dbms_sql.column_value(l_cursor,3,l_revision);
1286: dbms_sql.column_value(l_cursor,4,l_lot_number);
1287: dbms_sql.column_value(l_cursor,5,l_lot_expiration_date);
1288: dbms_sql.column_value(l_cursor,6,l_subinventory_code);
1289: dbms_sql.column_value(l_cursor,7,l_reservable_type);
1290: dbms_sql.column_value(l_cursor,8,l_locator_id);

Line 1287: dbms_sql.column_value(l_cursor,5,l_lot_expiration_date);

1283: dbms_sql.column_value(l_cursor,1,l_organization_id);
1284: dbms_sql.column_value(l_cursor,2,l_inventory_item_id);
1285: dbms_sql.column_value(l_cursor,3,l_revision);
1286: dbms_sql.column_value(l_cursor,4,l_lot_number);
1287: dbms_sql.column_value(l_cursor,5,l_lot_expiration_date);
1288: dbms_sql.column_value(l_cursor,6,l_subinventory_code);
1289: dbms_sql.column_value(l_cursor,7,l_reservable_type);
1290: dbms_sql.column_value(l_cursor,8,l_locator_id);
1291: dbms_sql.column_value(l_cursor,9,l_primary_quantity);

Line 1288: dbms_sql.column_value(l_cursor,6,l_subinventory_code);

1284: dbms_sql.column_value(l_cursor,2,l_inventory_item_id);
1285: dbms_sql.column_value(l_cursor,3,l_revision);
1286: dbms_sql.column_value(l_cursor,4,l_lot_number);
1287: dbms_sql.column_value(l_cursor,5,l_lot_expiration_date);
1288: dbms_sql.column_value(l_cursor,6,l_subinventory_code);
1289: dbms_sql.column_value(l_cursor,7,l_reservable_type);
1290: dbms_sql.column_value(l_cursor,8,l_locator_id);
1291: dbms_sql.column_value(l_cursor,9,l_primary_quantity);
1292: dbms_sql.column_value(l_cursor,10,l_date_received);

Line 1289: dbms_sql.column_value(l_cursor,7,l_reservable_type);

1285: dbms_sql.column_value(l_cursor,3,l_revision);
1286: dbms_sql.column_value(l_cursor,4,l_lot_number);
1287: dbms_sql.column_value(l_cursor,5,l_lot_expiration_date);
1288: dbms_sql.column_value(l_cursor,6,l_subinventory_code);
1289: dbms_sql.column_value(l_cursor,7,l_reservable_type);
1290: dbms_sql.column_value(l_cursor,8,l_locator_id);
1291: dbms_sql.column_value(l_cursor,9,l_primary_quantity);
1292: dbms_sql.column_value(l_cursor,10,l_date_received);
1293: dbms_sql.column_value(l_cursor,11,l_quantity_type);

Line 1290: dbms_sql.column_value(l_cursor,8,l_locator_id);

1286: dbms_sql.column_value(l_cursor,4,l_lot_number);
1287: dbms_sql.column_value(l_cursor,5,l_lot_expiration_date);
1288: dbms_sql.column_value(l_cursor,6,l_subinventory_code);
1289: dbms_sql.column_value(l_cursor,7,l_reservable_type);
1290: dbms_sql.column_value(l_cursor,8,l_locator_id);
1291: dbms_sql.column_value(l_cursor,9,l_primary_quantity);
1292: dbms_sql.column_value(l_cursor,10,l_date_received);
1293: dbms_sql.column_value(l_cursor,11,l_quantity_type);
1294: dbms_sql.column_value(l_cursor,12,l_cost_group_id);

Line 1291: dbms_sql.column_value(l_cursor,9,l_primary_quantity);

1287: dbms_sql.column_value(l_cursor,5,l_lot_expiration_date);
1288: dbms_sql.column_value(l_cursor,6,l_subinventory_code);
1289: dbms_sql.column_value(l_cursor,7,l_reservable_type);
1290: dbms_sql.column_value(l_cursor,8,l_locator_id);
1291: dbms_sql.column_value(l_cursor,9,l_primary_quantity);
1292: dbms_sql.column_value(l_cursor,10,l_date_received);
1293: dbms_sql.column_value(l_cursor,11,l_quantity_type);
1294: dbms_sql.column_value(l_cursor,12,l_cost_group_id);
1295: -- dbms_output.put_line('________________________________________________');

Line 1292: dbms_sql.column_value(l_cursor,10,l_date_received);

1288: dbms_sql.column_value(l_cursor,6,l_subinventory_code);
1289: dbms_sql.column_value(l_cursor,7,l_reservable_type);
1290: dbms_sql.column_value(l_cursor,8,l_locator_id);
1291: dbms_sql.column_value(l_cursor,9,l_primary_quantity);
1292: dbms_sql.column_value(l_cursor,10,l_date_received);
1293: dbms_sql.column_value(l_cursor,11,l_quantity_type);
1294: dbms_sql.column_value(l_cursor,12,l_cost_group_id);
1295: -- dbms_output.put_line('________________________________________________');
1296: -- dbms_output.put('org '||l_organization_id);

Line 1293: dbms_sql.column_value(l_cursor,11,l_quantity_type);

1289: dbms_sql.column_value(l_cursor,7,l_reservable_type);
1290: dbms_sql.column_value(l_cursor,8,l_locator_id);
1291: dbms_sql.column_value(l_cursor,9,l_primary_quantity);
1292: dbms_sql.column_value(l_cursor,10,l_date_received);
1293: dbms_sql.column_value(l_cursor,11,l_quantity_type);
1294: dbms_sql.column_value(l_cursor,12,l_cost_group_id);
1295: -- dbms_output.put_line('________________________________________________');
1296: -- dbms_output.put('org '||l_organization_id);
1297: -- dbms_output.put(', item '||l_inventory_item_id);

Line 1294: dbms_sql.column_value(l_cursor,12,l_cost_group_id);

1290: dbms_sql.column_value(l_cursor,8,l_locator_id);
1291: dbms_sql.column_value(l_cursor,9,l_primary_quantity);
1292: dbms_sql.column_value(l_cursor,10,l_date_received);
1293: dbms_sql.column_value(l_cursor,11,l_quantity_type);
1294: dbms_sql.column_value(l_cursor,12,l_cost_group_id);
1295: -- dbms_output.put_line('________________________________________________');
1296: -- dbms_output.put('org '||l_organization_id);
1297: -- dbms_output.put(', item '||l_inventory_item_id);
1298: -- dbms_output.put(', rev '||l_revision);

Line 1308: dbms_sql.close_cursor(l_cursor);

1304: -- dbms_output.put(', priqty '|| To_char(l_primary_quantity));
1305: -- dbms_output.put(', datercv '||To_char(l_date_received));
1306: -- dbms_output.put_line(', qtytype '||l_quantity_type);
1307: END LOOP;
1308: dbms_sql.close_cursor(l_cursor);
1309:
1310: END test_build_sql;
1311: -- End of test_build_sql ... NO invConv change.
1312:

Line 8117: dbms_sql.define_array(l_cursor, 1,v_organization_id,l_num_recs_fetch,l_index_start);

8113: End IF ;
8114: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
8115: RAISE fnd_api.g_exc_unexpected_error;
8116: End IF;
8117: dbms_sql.define_array(l_cursor, 1,v_organization_id,l_num_recs_fetch,l_index_start);
8118: dbms_sql.define_array(l_cursor, 2,v_inventory_item_id,l_num_recs_fetch,l_index_start);
8119: dbms_sql.define_array(l_cursor, 3,v_revision,l_num_recs_fetch,l_index_start);
8120: dbms_sql.define_array(l_cursor, 4,v_lot_number,l_num_recs_fetch,l_index_start);
8121: dbms_sql.define_array(l_cursor, 5,v_lot_expiration_date,l_num_recs_fetch,l_index_start);

Line 8118: dbms_sql.define_array(l_cursor, 2,v_inventory_item_id,l_num_recs_fetch,l_index_start);

8114: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
8115: RAISE fnd_api.g_exc_unexpected_error;
8116: End IF;
8117: dbms_sql.define_array(l_cursor, 1,v_organization_id,l_num_recs_fetch,l_index_start);
8118: dbms_sql.define_array(l_cursor, 2,v_inventory_item_id,l_num_recs_fetch,l_index_start);
8119: dbms_sql.define_array(l_cursor, 3,v_revision,l_num_recs_fetch,l_index_start);
8120: dbms_sql.define_array(l_cursor, 4,v_lot_number,l_num_recs_fetch,l_index_start);
8121: dbms_sql.define_array(l_cursor, 5,v_lot_expiration_date,l_num_recs_fetch,l_index_start);
8122: dbms_sql.define_array(l_cursor, 6,v_subinventory_code,l_num_recs_fetch,l_index_start);

Line 8119: dbms_sql.define_array(l_cursor, 3,v_revision,l_num_recs_fetch,l_index_start);

8115: RAISE fnd_api.g_exc_unexpected_error;
8116: End IF;
8117: dbms_sql.define_array(l_cursor, 1,v_organization_id,l_num_recs_fetch,l_index_start);
8118: dbms_sql.define_array(l_cursor, 2,v_inventory_item_id,l_num_recs_fetch,l_index_start);
8119: dbms_sql.define_array(l_cursor, 3,v_revision,l_num_recs_fetch,l_index_start);
8120: dbms_sql.define_array(l_cursor, 4,v_lot_number,l_num_recs_fetch,l_index_start);
8121: dbms_sql.define_array(l_cursor, 5,v_lot_expiration_date,l_num_recs_fetch,l_index_start);
8122: dbms_sql.define_array(l_cursor, 6,v_subinventory_code,l_num_recs_fetch,l_index_start);
8123: dbms_sql.define_array(l_cursor, 7,v_reservable_type,l_num_recs_fetch,l_index_start);

Line 8120: dbms_sql.define_array(l_cursor, 4,v_lot_number,l_num_recs_fetch,l_index_start);

8116: End IF;
8117: dbms_sql.define_array(l_cursor, 1,v_organization_id,l_num_recs_fetch,l_index_start);
8118: dbms_sql.define_array(l_cursor, 2,v_inventory_item_id,l_num_recs_fetch,l_index_start);
8119: dbms_sql.define_array(l_cursor, 3,v_revision,l_num_recs_fetch,l_index_start);
8120: dbms_sql.define_array(l_cursor, 4,v_lot_number,l_num_recs_fetch,l_index_start);
8121: dbms_sql.define_array(l_cursor, 5,v_lot_expiration_date,l_num_recs_fetch,l_index_start);
8122: dbms_sql.define_array(l_cursor, 6,v_subinventory_code,l_num_recs_fetch,l_index_start);
8123: dbms_sql.define_array(l_cursor, 7,v_reservable_type,l_num_recs_fetch,l_index_start);
8124: dbms_sql.define_array(l_cursor, 8,v_locator_id,l_num_recs_fetch,l_index_start);

Line 8121: dbms_sql.define_array(l_cursor, 5,v_lot_expiration_date,l_num_recs_fetch,l_index_start);

8117: dbms_sql.define_array(l_cursor, 1,v_organization_id,l_num_recs_fetch,l_index_start);
8118: dbms_sql.define_array(l_cursor, 2,v_inventory_item_id,l_num_recs_fetch,l_index_start);
8119: dbms_sql.define_array(l_cursor, 3,v_revision,l_num_recs_fetch,l_index_start);
8120: dbms_sql.define_array(l_cursor, 4,v_lot_number,l_num_recs_fetch,l_index_start);
8121: dbms_sql.define_array(l_cursor, 5,v_lot_expiration_date,l_num_recs_fetch,l_index_start);
8122: dbms_sql.define_array(l_cursor, 6,v_subinventory_code,l_num_recs_fetch,l_index_start);
8123: dbms_sql.define_array(l_cursor, 7,v_reservable_type,l_num_recs_fetch,l_index_start);
8124: dbms_sql.define_array(l_cursor, 8,v_locator_id,l_num_recs_fetch,l_index_start);
8125: dbms_sql.define_array(l_cursor, 9,v_primary_quantity,l_num_recs_fetch,l_index_start);

Line 8122: dbms_sql.define_array(l_cursor, 6,v_subinventory_code,l_num_recs_fetch,l_index_start);

8118: dbms_sql.define_array(l_cursor, 2,v_inventory_item_id,l_num_recs_fetch,l_index_start);
8119: dbms_sql.define_array(l_cursor, 3,v_revision,l_num_recs_fetch,l_index_start);
8120: dbms_sql.define_array(l_cursor, 4,v_lot_number,l_num_recs_fetch,l_index_start);
8121: dbms_sql.define_array(l_cursor, 5,v_lot_expiration_date,l_num_recs_fetch,l_index_start);
8122: dbms_sql.define_array(l_cursor, 6,v_subinventory_code,l_num_recs_fetch,l_index_start);
8123: dbms_sql.define_array(l_cursor, 7,v_reservable_type,l_num_recs_fetch,l_index_start);
8124: dbms_sql.define_array(l_cursor, 8,v_locator_id,l_num_recs_fetch,l_index_start);
8125: dbms_sql.define_array(l_cursor, 9,v_primary_quantity,l_num_recs_fetch,l_index_start);
8126: dbms_sql.define_array(l_cursor,10,v_secondary_quantity,l_num_recs_fetch,l_index_start);

Line 8123: dbms_sql.define_array(l_cursor, 7,v_reservable_type,l_num_recs_fetch,l_index_start);

8119: dbms_sql.define_array(l_cursor, 3,v_revision,l_num_recs_fetch,l_index_start);
8120: dbms_sql.define_array(l_cursor, 4,v_lot_number,l_num_recs_fetch,l_index_start);
8121: dbms_sql.define_array(l_cursor, 5,v_lot_expiration_date,l_num_recs_fetch,l_index_start);
8122: dbms_sql.define_array(l_cursor, 6,v_subinventory_code,l_num_recs_fetch,l_index_start);
8123: dbms_sql.define_array(l_cursor, 7,v_reservable_type,l_num_recs_fetch,l_index_start);
8124: dbms_sql.define_array(l_cursor, 8,v_locator_id,l_num_recs_fetch,l_index_start);
8125: dbms_sql.define_array(l_cursor, 9,v_primary_quantity,l_num_recs_fetch,l_index_start);
8126: dbms_sql.define_array(l_cursor,10,v_secondary_quantity,l_num_recs_fetch,l_index_start);
8127: dbms_sql.define_array(l_cursor,11,v_date_received,l_num_recs_fetch,l_index_start);

Line 8124: dbms_sql.define_array(l_cursor, 8,v_locator_id,l_num_recs_fetch,l_index_start);

8120: dbms_sql.define_array(l_cursor, 4,v_lot_number,l_num_recs_fetch,l_index_start);
8121: dbms_sql.define_array(l_cursor, 5,v_lot_expiration_date,l_num_recs_fetch,l_index_start);
8122: dbms_sql.define_array(l_cursor, 6,v_subinventory_code,l_num_recs_fetch,l_index_start);
8123: dbms_sql.define_array(l_cursor, 7,v_reservable_type,l_num_recs_fetch,l_index_start);
8124: dbms_sql.define_array(l_cursor, 8,v_locator_id,l_num_recs_fetch,l_index_start);
8125: dbms_sql.define_array(l_cursor, 9,v_primary_quantity,l_num_recs_fetch,l_index_start);
8126: dbms_sql.define_array(l_cursor,10,v_secondary_quantity,l_num_recs_fetch,l_index_start);
8127: dbms_sql.define_array(l_cursor,11,v_date_received,l_num_recs_fetch,l_index_start);
8128: dbms_sql.define_array(l_cursor,12,v_quantity_type,l_num_recs_fetch,l_index_start);

Line 8125: dbms_sql.define_array(l_cursor, 9,v_primary_quantity,l_num_recs_fetch,l_index_start);

8121: dbms_sql.define_array(l_cursor, 5,v_lot_expiration_date,l_num_recs_fetch,l_index_start);
8122: dbms_sql.define_array(l_cursor, 6,v_subinventory_code,l_num_recs_fetch,l_index_start);
8123: dbms_sql.define_array(l_cursor, 7,v_reservable_type,l_num_recs_fetch,l_index_start);
8124: dbms_sql.define_array(l_cursor, 8,v_locator_id,l_num_recs_fetch,l_index_start);
8125: dbms_sql.define_array(l_cursor, 9,v_primary_quantity,l_num_recs_fetch,l_index_start);
8126: dbms_sql.define_array(l_cursor,10,v_secondary_quantity,l_num_recs_fetch,l_index_start);
8127: dbms_sql.define_array(l_cursor,11,v_date_received,l_num_recs_fetch,l_index_start);
8128: dbms_sql.define_array(l_cursor,12,v_quantity_type,l_num_recs_fetch,l_index_start);
8129: dbms_sql.define_array(l_cursor,13,v_cost_group_id,l_num_recs_fetch,l_index_start);

Line 8126: dbms_sql.define_array(l_cursor,10,v_secondary_quantity,l_num_recs_fetch,l_index_start);

8122: dbms_sql.define_array(l_cursor, 6,v_subinventory_code,l_num_recs_fetch,l_index_start);
8123: dbms_sql.define_array(l_cursor, 7,v_reservable_type,l_num_recs_fetch,l_index_start);
8124: dbms_sql.define_array(l_cursor, 8,v_locator_id,l_num_recs_fetch,l_index_start);
8125: dbms_sql.define_array(l_cursor, 9,v_primary_quantity,l_num_recs_fetch,l_index_start);
8126: dbms_sql.define_array(l_cursor,10,v_secondary_quantity,l_num_recs_fetch,l_index_start);
8127: dbms_sql.define_array(l_cursor,11,v_date_received,l_num_recs_fetch,l_index_start);
8128: dbms_sql.define_array(l_cursor,12,v_quantity_type,l_num_recs_fetch,l_index_start);
8129: dbms_sql.define_array(l_cursor,13,v_cost_group_id,l_num_recs_fetch,l_index_start);
8130: dbms_sql.define_array(l_cursor,14,v_lpn_id,l_num_recs_fetch,l_index_start);

Line 8127: dbms_sql.define_array(l_cursor,11,v_date_received,l_num_recs_fetch,l_index_start);

8123: dbms_sql.define_array(l_cursor, 7,v_reservable_type,l_num_recs_fetch,l_index_start);
8124: dbms_sql.define_array(l_cursor, 8,v_locator_id,l_num_recs_fetch,l_index_start);
8125: dbms_sql.define_array(l_cursor, 9,v_primary_quantity,l_num_recs_fetch,l_index_start);
8126: dbms_sql.define_array(l_cursor,10,v_secondary_quantity,l_num_recs_fetch,l_index_start);
8127: dbms_sql.define_array(l_cursor,11,v_date_received,l_num_recs_fetch,l_index_start);
8128: dbms_sql.define_array(l_cursor,12,v_quantity_type,l_num_recs_fetch,l_index_start);
8129: dbms_sql.define_array(l_cursor,13,v_cost_group_id,l_num_recs_fetch,l_index_start);
8130: dbms_sql.define_array(l_cursor,14,v_lpn_id,l_num_recs_fetch,l_index_start);
8131:

Line 8128: dbms_sql.define_array(l_cursor,12,v_quantity_type,l_num_recs_fetch,l_index_start);

8124: dbms_sql.define_array(l_cursor, 8,v_locator_id,l_num_recs_fetch,l_index_start);
8125: dbms_sql.define_array(l_cursor, 9,v_primary_quantity,l_num_recs_fetch,l_index_start);
8126: dbms_sql.define_array(l_cursor,10,v_secondary_quantity,l_num_recs_fetch,l_index_start);
8127: dbms_sql.define_array(l_cursor,11,v_date_received,l_num_recs_fetch,l_index_start);
8128: dbms_sql.define_array(l_cursor,12,v_quantity_type,l_num_recs_fetch,l_index_start);
8129: dbms_sql.define_array(l_cursor,13,v_cost_group_id,l_num_recs_fetch,l_index_start);
8130: dbms_sql.define_array(l_cursor,14,v_lpn_id,l_num_recs_fetch,l_index_start);
8131:
8132: l_dummy := dbms_sql.execute(l_cursor);

Line 8129: dbms_sql.define_array(l_cursor,13,v_cost_group_id,l_num_recs_fetch,l_index_start);

8125: dbms_sql.define_array(l_cursor, 9,v_primary_quantity,l_num_recs_fetch,l_index_start);
8126: dbms_sql.define_array(l_cursor,10,v_secondary_quantity,l_num_recs_fetch,l_index_start);
8127: dbms_sql.define_array(l_cursor,11,v_date_received,l_num_recs_fetch,l_index_start);
8128: dbms_sql.define_array(l_cursor,12,v_quantity_type,l_num_recs_fetch,l_index_start);
8129: dbms_sql.define_array(l_cursor,13,v_cost_group_id,l_num_recs_fetch,l_index_start);
8130: dbms_sql.define_array(l_cursor,14,v_lpn_id,l_num_recs_fetch,l_index_start);
8131:
8132: l_dummy := dbms_sql.execute(l_cursor);
8133:

Line 8130: dbms_sql.define_array(l_cursor,14,v_lpn_id,l_num_recs_fetch,l_index_start);

8126: dbms_sql.define_array(l_cursor,10,v_secondary_quantity,l_num_recs_fetch,l_index_start);
8127: dbms_sql.define_array(l_cursor,11,v_date_received,l_num_recs_fetch,l_index_start);
8128: dbms_sql.define_array(l_cursor,12,v_quantity_type,l_num_recs_fetch,l_index_start);
8129: dbms_sql.define_array(l_cursor,13,v_cost_group_id,l_num_recs_fetch,l_index_start);
8130: dbms_sql.define_array(l_cursor,14,v_lpn_id,l_num_recs_fetch,l_index_start);
8131:
8132: l_dummy := dbms_sql.execute(l_cursor);
8133:
8134: LOOP

Line 8132: l_dummy := dbms_sql.execute(l_cursor);

8128: dbms_sql.define_array(l_cursor,12,v_quantity_type,l_num_recs_fetch,l_index_start);
8129: dbms_sql.define_array(l_cursor,13,v_cost_group_id,l_num_recs_fetch,l_index_start);
8130: dbms_sql.define_array(l_cursor,14,v_lpn_id,l_num_recs_fetch,l_index_start);
8131:
8132: l_dummy := dbms_sql.execute(l_cursor);
8133:
8134: LOOP
8135: l_cur_num_rows:=dbms_sql.fetch_rows(l_cursor);
8136: IF l_cur_num_rows = 0 THEN

Line 8135: l_cur_num_rows:=dbms_sql.fetch_rows(l_cursor);

8131:
8132: l_dummy := dbms_sql.execute(l_cursor);
8133:
8134: LOOP
8135: l_cur_num_rows:=dbms_sql.fetch_rows(l_cursor);
8136: IF l_cur_num_rows = 0 THEN
8137: EXIT;
8138: END IF;
8139: l_tot_num_rows := l_tot_num_rows + l_cur_num_rows;

Line 8140: dbms_sql.column_value(l_cursor,1,v_organization_id);

8136: IF l_cur_num_rows = 0 THEN
8137: EXIT;
8138: END IF;
8139: l_tot_num_rows := l_tot_num_rows + l_cur_num_rows;
8140: dbms_sql.column_value(l_cursor,1,v_organization_id);
8141: dbms_sql.column_value(l_cursor,2,v_inventory_item_id);
8142: dbms_sql.column_value(l_cursor,3,v_revision);
8143: dbms_sql.column_value(l_cursor,4,v_lot_number);
8144: dbms_sql.column_value(l_cursor,5,v_lot_expiration_date);

Line 8141: dbms_sql.column_value(l_cursor,2,v_inventory_item_id);

8137: EXIT;
8138: END IF;
8139: l_tot_num_rows := l_tot_num_rows + l_cur_num_rows;
8140: dbms_sql.column_value(l_cursor,1,v_organization_id);
8141: dbms_sql.column_value(l_cursor,2,v_inventory_item_id);
8142: dbms_sql.column_value(l_cursor,3,v_revision);
8143: dbms_sql.column_value(l_cursor,4,v_lot_number);
8144: dbms_sql.column_value(l_cursor,5,v_lot_expiration_date);
8145: dbms_sql.column_value(l_cursor,6,v_subinventory_code);

Line 8142: dbms_sql.column_value(l_cursor,3,v_revision);

8138: END IF;
8139: l_tot_num_rows := l_tot_num_rows + l_cur_num_rows;
8140: dbms_sql.column_value(l_cursor,1,v_organization_id);
8141: dbms_sql.column_value(l_cursor,2,v_inventory_item_id);
8142: dbms_sql.column_value(l_cursor,3,v_revision);
8143: dbms_sql.column_value(l_cursor,4,v_lot_number);
8144: dbms_sql.column_value(l_cursor,5,v_lot_expiration_date);
8145: dbms_sql.column_value(l_cursor,6,v_subinventory_code);
8146: dbms_sql.column_value(l_cursor,7,v_reservable_type);

Line 8143: dbms_sql.column_value(l_cursor,4,v_lot_number);

8139: l_tot_num_rows := l_tot_num_rows + l_cur_num_rows;
8140: dbms_sql.column_value(l_cursor,1,v_organization_id);
8141: dbms_sql.column_value(l_cursor,2,v_inventory_item_id);
8142: dbms_sql.column_value(l_cursor,3,v_revision);
8143: dbms_sql.column_value(l_cursor,4,v_lot_number);
8144: dbms_sql.column_value(l_cursor,5,v_lot_expiration_date);
8145: dbms_sql.column_value(l_cursor,6,v_subinventory_code);
8146: dbms_sql.column_value(l_cursor,7,v_reservable_type);
8147: dbms_sql.column_value(l_cursor,8,v_locator_id);

Line 8144: dbms_sql.column_value(l_cursor,5,v_lot_expiration_date);

8140: dbms_sql.column_value(l_cursor,1,v_organization_id);
8141: dbms_sql.column_value(l_cursor,2,v_inventory_item_id);
8142: dbms_sql.column_value(l_cursor,3,v_revision);
8143: dbms_sql.column_value(l_cursor,4,v_lot_number);
8144: dbms_sql.column_value(l_cursor,5,v_lot_expiration_date);
8145: dbms_sql.column_value(l_cursor,6,v_subinventory_code);
8146: dbms_sql.column_value(l_cursor,7,v_reservable_type);
8147: dbms_sql.column_value(l_cursor,8,v_locator_id);
8148: dbms_sql.column_value(l_cursor,9,v_primary_quantity);

Line 8145: dbms_sql.column_value(l_cursor,6,v_subinventory_code);

8141: dbms_sql.column_value(l_cursor,2,v_inventory_item_id);
8142: dbms_sql.column_value(l_cursor,3,v_revision);
8143: dbms_sql.column_value(l_cursor,4,v_lot_number);
8144: dbms_sql.column_value(l_cursor,5,v_lot_expiration_date);
8145: dbms_sql.column_value(l_cursor,6,v_subinventory_code);
8146: dbms_sql.column_value(l_cursor,7,v_reservable_type);
8147: dbms_sql.column_value(l_cursor,8,v_locator_id);
8148: dbms_sql.column_value(l_cursor,9,v_primary_quantity);
8149: dbms_sql.column_value(l_cursor,10,v_date_received);

Line 8146: dbms_sql.column_value(l_cursor,7,v_reservable_type);

8142: dbms_sql.column_value(l_cursor,3,v_revision);
8143: dbms_sql.column_value(l_cursor,4,v_lot_number);
8144: dbms_sql.column_value(l_cursor,5,v_lot_expiration_date);
8145: dbms_sql.column_value(l_cursor,6,v_subinventory_code);
8146: dbms_sql.column_value(l_cursor,7,v_reservable_type);
8147: dbms_sql.column_value(l_cursor,8,v_locator_id);
8148: dbms_sql.column_value(l_cursor,9,v_primary_quantity);
8149: dbms_sql.column_value(l_cursor,10,v_date_received);
8150: dbms_sql.column_value(l_cursor,11,v_quantity_type);

Line 8147: dbms_sql.column_value(l_cursor,8,v_locator_id);

8143: dbms_sql.column_value(l_cursor,4,v_lot_number);
8144: dbms_sql.column_value(l_cursor,5,v_lot_expiration_date);
8145: dbms_sql.column_value(l_cursor,6,v_subinventory_code);
8146: dbms_sql.column_value(l_cursor,7,v_reservable_type);
8147: dbms_sql.column_value(l_cursor,8,v_locator_id);
8148: dbms_sql.column_value(l_cursor,9,v_primary_quantity);
8149: dbms_sql.column_value(l_cursor,10,v_date_received);
8150: dbms_sql.column_value(l_cursor,11,v_quantity_type);
8151: dbms_sql.column_value(l_cursor,12,v_cost_group_id);

Line 8148: dbms_sql.column_value(l_cursor,9,v_primary_quantity);

8144: dbms_sql.column_value(l_cursor,5,v_lot_expiration_date);
8145: dbms_sql.column_value(l_cursor,6,v_subinventory_code);
8146: dbms_sql.column_value(l_cursor,7,v_reservable_type);
8147: dbms_sql.column_value(l_cursor,8,v_locator_id);
8148: dbms_sql.column_value(l_cursor,9,v_primary_quantity);
8149: dbms_sql.column_value(l_cursor,10,v_date_received);
8150: dbms_sql.column_value(l_cursor,11,v_quantity_type);
8151: dbms_sql.column_value(l_cursor,12,v_cost_group_id);
8152: dbms_sql.column_value(l_cursor,13,v_lpn_id);

Line 8149: dbms_sql.column_value(l_cursor,10,v_date_received);

8145: dbms_sql.column_value(l_cursor,6,v_subinventory_code);
8146: dbms_sql.column_value(l_cursor,7,v_reservable_type);
8147: dbms_sql.column_value(l_cursor,8,v_locator_id);
8148: dbms_sql.column_value(l_cursor,9,v_primary_quantity);
8149: dbms_sql.column_value(l_cursor,10,v_date_received);
8150: dbms_sql.column_value(l_cursor,11,v_quantity_type);
8151: dbms_sql.column_value(l_cursor,12,v_cost_group_id);
8152: dbms_sql.column_value(l_cursor,13,v_lpn_id);
8153: EXIT WHEN l_cur_num_rows < l_num_recs_fetch;

Line 8150: dbms_sql.column_value(l_cursor,11,v_quantity_type);

8146: dbms_sql.column_value(l_cursor,7,v_reservable_type);
8147: dbms_sql.column_value(l_cursor,8,v_locator_id);
8148: dbms_sql.column_value(l_cursor,9,v_primary_quantity);
8149: dbms_sql.column_value(l_cursor,10,v_date_received);
8150: dbms_sql.column_value(l_cursor,11,v_quantity_type);
8151: dbms_sql.column_value(l_cursor,12,v_cost_group_id);
8152: dbms_sql.column_value(l_cursor,13,v_lpn_id);
8153: EXIT WHEN l_cur_num_rows < l_num_recs_fetch;
8154: END LOOP;

Line 8151: dbms_sql.column_value(l_cursor,12,v_cost_group_id);

8147: dbms_sql.column_value(l_cursor,8,v_locator_id);
8148: dbms_sql.column_value(l_cursor,9,v_primary_quantity);
8149: dbms_sql.column_value(l_cursor,10,v_date_received);
8150: dbms_sql.column_value(l_cursor,11,v_quantity_type);
8151: dbms_sql.column_value(l_cursor,12,v_cost_group_id);
8152: dbms_sql.column_value(l_cursor,13,v_lpn_id);
8153: EXIT WHEN l_cur_num_rows < l_num_recs_fetch;
8154: END LOOP;
8155: */

Line 8152: dbms_sql.column_value(l_cursor,13,v_lpn_id);

8148: dbms_sql.column_value(l_cursor,9,v_primary_quantity);
8149: dbms_sql.column_value(l_cursor,10,v_date_received);
8150: dbms_sql.column_value(l_cursor,11,v_quantity_type);
8151: dbms_sql.column_value(l_cursor,12,v_cost_group_id);
8152: dbms_sql.column_value(l_cursor,13,v_lpn_id);
8153: EXIT WHEN l_cur_num_rows < l_num_recs_fetch;
8154: END LOOP;
8155: */
8156:

Line 8565: --dbms_sql.CLOSE_cursor(l_cursor);

8561:
8562: print_debug('... end of build_tree loop...');
8563:
8564: -- close cursor
8565: --dbms_sql.CLOSE_cursor(l_cursor);
8566: g_rootinfos(p_tree_id).need_refresh := FALSE;
8567: x_return_status := l_return_status;
8568:
8569: IF g_debug = 1 THEN