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 189: UPDATE jtm_con_request_data SET last_run_date = l_run_date

185:
186: --If the max size of attachment is less than 1, then exit.
187: IF (TO_NUMBER(FND_PROFILE.Value('CSM_MAX_ATTACHMENT_SIZE')) < 1) THEN
188: /*Update the last run date*/
189: UPDATE jtm_con_request_data SET last_run_date = l_run_date
190: WHERE package_name = 'CSM_LOBS_EVENT_PKG'
191: AND procedure_name = 'CONC_DOWNLOAD_ATTACHMENTS';
192:
193: COMMIT;

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

385:
386: END IF;
387:
388:
389: -- set the program update date in jtm_con_request_data to sysdate
390: UPDATE jtm_con_request_data
391: SET last_run_date = l_run_date
392: WHERE package_name = 'CSM_LOBS_EVENT_PKG'
393: AND procedure_name = 'CONC_DOWNLOAD_ATTACHMENTS';

Line 390: UPDATE jtm_con_request_data

386: END IF;
387:
388:
389: -- set the program update date in jtm_con_request_data to sysdate
390: UPDATE jtm_con_request_data
391: SET last_run_date = l_run_date
392: WHERE package_name = 'CSM_LOBS_EVENT_PKG'
393: AND procedure_name = 'CONC_DOWNLOAD_ATTACHMENTS';
394: