200: l_tab_document_id.delete;
201: l_tab_title.delete;
202:
203: --If the max size of attachment is less than 1, then exit.
204: IF (TO_NUMBER(FND_PROFILE.Value('CSM_MAX_ATTACHMENT_SIZE')) < 1) THEN
205: /*Update the last run date*/
206: UPDATE jtm_con_request_data SET last_run_date = l_run_date
207: WHERE package_name = 'CSM_LOBS_EVENT_PKG'
208: AND procedure_name = 'CONC_DOWNLOAD_ATTACHMENTS';
680: l_tab_document_id.delete;
681: l_tab_title.delete;
682:
683: --If the max size of attachment is less than 1, then exit.
684: IF (TO_NUMBER(FND_PROFILE.Value('CSM_MAX_ATTACHMENT_SIZE')) < 1) THEN
685: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
686: jtm_message_log_pkg.Log_Msg
687: ( 0
688: , g_table_name
1085: END IF;
1086:
1087: --If the max size of attachment is less than 1, then exit.(this should be done only
1088: --for SR and TASK attachments)
1089: IF (TO_NUMBER(FND_PROFILE.Value('CSM_MAX_ATTACHMENT_SIZE')) < 1) THEN
1090: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1091: jtm_message_log_pkg.Log_Msg
1092: ( 0
1093: , g_table_name
1623: );
1624: END IF;
1625: --If the max size of attachment is less than 1, then exit.(this should be done only
1626: --for SR and TASK attachments)
1627: IF (TO_NUMBER(FND_PROFILE.Value('CSM_MAX_ATTACHMENT_SIZE')) < 1) THEN
1628: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1629: jtm_message_log_pkg.Log_Msg
1630: ( 0
1631: , g_table_name