APPS.CSM_LOBS_EVENT_PKG dependencies on JTM_CON_REQUEST_DATA

Line 27: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;

23: p_message OUT NOCOPY VARCHAR2)
24: IS
25: PRAGMA AUTONOMOUS_TRANSACTION;
26: l_pub_item VARCHAR2(30) := 'CSF_M_LOBS';
27: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
28: l_run_date date;
29: l_sqlerrno varchar2(20);
30: l_sqlerrmsg varchar2(2000);
31: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;

Line 206: UPDATE jtm_con_request_data SET last_run_date = l_run_date

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';
209:
210: COMMIT;

Line 455: -- set the program update date in jtm_con_request_data to sysdate

451:
452: END IF;
453:
454:
455: -- set the program update date in jtm_con_request_data to sysdate
456: UPDATE jtm_con_request_data
457: SET last_run_date = l_run_date
458: WHERE package_name = 'CSM_LOBS_EVENT_PKG'
459: AND procedure_name = 'CONC_DOWNLOAD_ATTACHMENTS';

Line 456: UPDATE jtm_con_request_data

452: END IF;
453:
454:
455: -- set the program update date in jtm_con_request_data to sysdate
456: UPDATE jtm_con_request_data
457: SET last_run_date = l_run_date
458: WHERE package_name = 'CSM_LOBS_EVENT_PKG'
459: AND procedure_name = 'CONC_DOWNLOAD_ATTACHMENTS';
460: