DBA Data[Home] [Help]

APPS.CSL_MTL_ITEM_LOCATIONS_ACC_PKG dependencies on JTM_CON_REQUEST_DATA

Line 515: from JTM_CON_REQUEST_DATA

511: /*** get the last run date of the concurent program ***/
512: CURSOR c_LastRundate
513: IS
514: select LAST_RUN_DATE
515: from JTM_CON_REQUEST_DATA
516: where package_name = 'CSL_MTL_ITEM_LOCATIONS_ACC_PKG'
517: AND procedure_name = 'CON_REQUEST_MTL_ITEM_LOCATIONS';
518: r_LastRundate c_LastRundate%ROWTYPE;
519: l_current_run_date DATE;

Line 565: UPDATE JTM_CON_REQUEST_DATA

561: );
562: END IF;
563:
564: /*Update the last run date*/
565: UPDATE JTM_CON_REQUEST_DATA
566: SET LAST_RUN_DATE = l_current_run_date
567: WHERE package_name = 'CSL_MTL_ITEM_LOCATIONS_ACC_PKG'
568: AND procedure_name = 'CON_REQUEST_ITEM_LOCATIONS';
569: