DBA Data[Home] [Help]

APPS.CSL_LOBS_ACC_PKG dependencies on JTM_CON_REQUEST_DATA

Line 237: from JTM_CON_REQUEST_DATA

233: /*** get the last run date of the concurent program ***/
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

Line 379: UPDATE jtm_con_request_data SET last_run_date = l_current_run_date

375:
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;

Line 537: UPDATE jtm_con_request_data SET last_run_date = l_current_run_date

533: END IF;
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;