APPS.FTE_BULK_DTT_PKG dependencies on FTE_MILE_DOWNLOAD_LINES

Line 438: -- destination ids from fte_mile_download_lines and --

434: -- --
435: -- RETURN: n/a --
436: -- --
437: -- DESCRIPTION: Reads the DTT data file. Gets the relevant origin and --
438: -- destination ids from fte_mile_download_lines and --
439: -- stores the information in a global temp table: --
440: -- FTE_DISTANCE_LOADER_TMP and then inserts or updates --
441: -- the values into the FTE_LOCATION_MILEAGES table --
442: -- --

Line 533: from fte_mile_download_lines fmdl

529:
530:
531: cursor c_check_download_lines(cp_download_file_id NUMBER) IS
532: select count(fmdl.download_file_id)
533: from fte_mile_download_lines fmdl
534: where fmdl.download_file_id = cp_download_file_id;
535:
536:
537: cursor c_get_file_info(cp_file_name VARCHAR2) IS

Line 550: from fte_mile_download_lines fmdl

546:
547: cursor c_get_download_lines(cp_download_file_id NUMBER) IS
548: select fmdl.origin_id,
549: fmdl.destination_id
550: from fte_mile_download_lines fmdl
551: where fmdl.download_file_id = cp_download_file_id;
552:
553:
554: cursor c_get_ret_col_info(cp_column_type VARCHAR2,

Line 2413: delete fte_mile_download_lines

2409: --
2410: --
2411: -- Delete the lines
2412: --
2413: delete fte_mile_download_lines
2414: where download_file_id = l_download_file_id
2415: returning download_file_id BULK COLLECT INTO l_deleted_download_ids;
2416:
2417: commit;