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.FTE_DIST_DWNLD_PKG dependencies on FTE_MILE_DOWNLOAD_FILES

Line 4364: WSH_DEBUG_SV.logmsg(l_module_name,'populate the FTE_MILE_DOWNLOAD_FILES table NB: download date is null as it has not completed yet');

4360: END IF;
4361:
4362:
4363: IF l_debug_on THEN
4364: WSH_DEBUG_SV.logmsg(l_module_name,'populate the FTE_MILE_DOWNLOAD_FILES table NB: download date is null as it has not completed yet');
4365: END IF;
4366:
4367: --
4368: -- populate the FTE_MILE_DOWNLOAD_FILES table

Line 4368: -- populate the FTE_MILE_DOWNLOAD_FILES table

4364: WSH_DEBUG_SV.logmsg(l_module_name,'populate the FTE_MILE_DOWNLOAD_FILES table NB: download date is null as it has not completed yet');
4365: END IF;
4366:
4367: --
4368: -- populate the FTE_MILE_DOWNLOAD_FILES table
4369: -- NB: download date is null as it has not completed yet.
4370: --
4371: insert into fte_mile_download_files(DOWNLOAD_FILE_ID,
4372: FILE_NAME,

Line 4371: insert into fte_mile_download_files(DOWNLOAD_FILE_ID,

4367: --
4368: -- populate the FTE_MILE_DOWNLOAD_FILES table
4369: -- NB: download date is null as it has not completed yet.
4370: --
4371: insert into fte_mile_download_files(DOWNLOAD_FILE_ID,
4372: FILE_NAME,
4373: DOWNLOAD_FILE_EXTENSION,
4374: TEMPLATE_ID,
4375: DOWNLOAD_DATE,

Line 4388: values(FTE_MILE_DOWNLOAD_FILES_S.NEXTVAL,

4384: PROGRAM_APPLICATION_ID,
4385: PROGRAM_ID,
4386: PROGRAM_UPDATE_DATE,
4387: REQUEST_ID)
4388: values(FTE_MILE_DOWNLOAD_FILES_S.NEXTVAL,
4389: substr(p_file_name,1,8),
4390: p_file_extension,
4391: p_template_id,
4392: null,

Line 4857: -- update the fte_mile_download_files table with the download date

4853:
4854:
4855: --
4856: -- If we are here then all has gone well
4857: -- update the fte_mile_download_files table with the download date
4858: --
4859: IF l_debug_on THEN
4860: WSH_DEBUG_SV.logmsg(l_module_name,'If we are here then all has gone well update the fte_mile_download_files table with the download date');
4861: END IF;

Line 4860: WSH_DEBUG_SV.logmsg(l_module_name,'If we are here then all has gone well update the fte_mile_download_files table with the download date');

4856: -- If we are here then all has gone well
4857: -- update the fte_mile_download_files table with the download date
4858: --
4859: IF l_debug_on THEN
4860: WSH_DEBUG_SV.logmsg(l_module_name,'If we are here then all has gone well update the fte_mile_download_files table with the download date');
4861: END IF;
4862:
4863: update fte_mile_download_files
4864: set download_date = sysdate

Line 4863: update fte_mile_download_files

4859: IF l_debug_on THEN
4860: WSH_DEBUG_SV.logmsg(l_module_name,'If we are here then all has gone well update the fte_mile_download_files table with the download date');
4861: END IF;
4862:
4863: update fte_mile_download_files
4864: set download_date = sysdate
4865: where download_file_id = l_download_file_id;
4866:
4867: