396: OR NVL(v_nl_trackable, 'N') <> 'Y'
397: Then
398:
399: Begin
400: Insert Into CSI_INV_DISCREPANCY_TEMP
401: (
402: discrepancy_id
403: ,inventory_item_id
404: ,serial_number
925: THEN
926:
927: BEGIN
928:
929: INSERT INTO CSI_INV_DISCREPANCY_TEMP
930: (
931: discrepancy_id
932: ,inventory_item_id
933: ,serial_number
1308: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1309: RAISE fnd_api.g_exc_error;
1310: END IF;
1311:
1312: l_object_name := l_schema_name||'.csi_inv_discrepancy_temp';
1313:
1314: -- Empty the discrepancy table before each run
1315: truncate_table(l_object_name);
1316: --
1328: --
1329: BEGIN
1330: SELECT count(*)
1331: INTO l_disc_count
1332: FROM CSI_INV_DISCREPANCY_TEMP;
1333: END;
1334: --
1335: -- If there are any data discrepancies between IB and INV then display the report
1336: --