DBA Data[Home] [Help]

APPS.CSM_CSP_REQ_LINES_EVENT_PKG dependencies on JTM_CON_REQUEST_DATA

Line 135: FROM JTM_CON_REQUEST_DATA

131: /*** get the last run date of the concurent program ***/
132: CURSOR c_LastRundate
133: IS
134: SELECT NVL(LAST_RUN_DATE, to_date('1','J')) LAST_RUN_DATE
135: FROM JTM_CON_REQUEST_DATA
136: WHERE package_name = 'CSM_CSP_REQ_LINES_EVENT_PKG'
137: AND procedure_name = 'CONC_ORDER_UPDATE';
138:
139: r_LastRundate c_LastRundate%ROWTYPE;

Line 262: UPDATE JTM_CON_REQUEST_DATA

258: );
259:
260: END LOOP;
261:
262: UPDATE JTM_CON_REQUEST_DATA
263: SET LAST_RUN_DATE = l_current_run_date
264: WHERE package_name = 'CSM_CSP_REQ_LINES_EVENT_PKG'
265: AND procedure_name = 'CONC_ORDER_UPDATE';
266: