APPS.CSL_LOBS_ACC_PKG dependencies on CSL_LOBS_ACC_PKG

Line 1: PACKAGE BODY CSL_LOBS_ACC_PKG AS

1: PACKAGE BODY CSL_LOBS_ACC_PKG AS
2: /* $Header: csllbacb.pls 120.0 2005/05/30 07:41:21 appldev noship $ */
3:
4: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
5: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_LOBS');

Line 238: where package_name = 'CSL_LOBS_ACC_PKG'

234: CURSOR c_LastRundate
235: IS
236: select LAST_RUN_DATE
237: from JTM_CON_REQUEST_DATA
238: where package_name = 'CSL_LOBS_ACC_PKG'
239: AND procedure_name = 'CONC_DOWNLOAD_ATTACHMENTS';
240:
241: --Cursor to get the SR attachemnts
242: CURSOR c_SRAtt (b_lastRundate date) IS

Line 380: WHERE package_name = 'CSL_LOBS_ACC_PKG'

376: --If the max size of attachment is less than 1, then exit.
377: IF (TO_NUMBER(FND_PROFILE.Value('CSM_MAX_ATTACHMENT_SIZE')) < 1) THEN
378: /*Update the last run date*/
379: UPDATE jtm_con_request_data SET last_run_date = l_current_run_date
380: WHERE package_name = 'CSL_LOBS_ACC_PKG'
381: AND procedure_name = 'CONC_DOWNLOAD_ATTACHMENTS';
382:
383: COMMIT;
384:

Line 386: p_message := 'CSL_LOBS_ACC_PKG.CONC_DOWNLOAD_ATTACHMENTS '

382:
383: COMMIT;
384:
385: p_status := 'FINE';
386: p_message := 'CSL_LOBS_ACC_PKG.CONC_DOWNLOAD_ATTACHMENTS '
387: || ' Executed successfully';
388:
389: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
390: jtm_message_log_pkg.Log_Msg

Line 538: WHERE package_name = 'CSL_LOBS_ACC_PKG'

534: */
535:
536: /*Update the last run date*/
537: UPDATE jtm_con_request_data SET last_run_date = l_current_run_date
538: WHERE package_name = 'CSL_LOBS_ACC_PKG'
539: AND procedure_name = 'CONC_DOWNLOAD_ATTACHMENTS';
540:
541: COMMIT;
542:

Line 544: p_message := 'CSL_LOBS_ACC_PKG.CONC_DOWNLOAD_ATTACHMENTS '

540:
541: COMMIT;
542:
543: p_status := 'FINE';
544: p_message := 'CSL_LOBS_ACC_PKG.CONC_DOWNLOAD_ATTACHMENTS '
545: || ' Executed successfully';
546:
547: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
548: jtm_message_log_pkg.Log_Msg

Line 561: 'CSL_LOBS_ACC_PKG.CONC_DOWNLOAD_ATTACHMENTS: '

557:
558: WHEN OTHERS THEN
559: p_status := 'ERROR';
560: p_message := 'Error in '||
561: 'CSL_LOBS_ACC_PKG.CONC_DOWNLOAD_ATTACHMENTS: '
562: || substr(SQLERRM, 1, 2000);
563:
564:
565: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

Line 957: END CSL_LOBS_ACC_PKG;

953: RAISE;
954:
955: END DELETE_ATTACHMENTS;
956:
957: END CSL_LOBS_ACC_PKG;