DBA Data[Home] [Help]

APPS.CSL_MTL_SEC_LOCATORS_ACC_PKG dependencies on JTM_CON_REQUEST_DATA

Line 459: from JTM_CON_REQUEST_DATA

455: /*** get the last run date of the concurent program ***/
456: CURSOR c_LastRundate
457: IS
458: select LAST_RUN_DATE
459: from JTM_CON_REQUEST_DATA
460: where package_name = 'CSL_MTL_SEC_LOCATORS_ACC_PKG'
461: AND procedure_name = 'CON_REQUEST_SECONDARY_LOCATORS';
462: r_LastRundate c_LastRundate%ROWTYPE;
463: l_current_run_date DATE;

Line 509: UPDATE JTM_CON_REQUEST_DATA

505: );
506: END IF;
507:
508: /*Update the last run date*/
509: UPDATE JTM_CON_REQUEST_DATA
510: SET LAST_RUN_DATE = l_current_run_date
511: WHERE package_name = 'CSL_MTL_SEC_LOCATORS_ACC_PKG'
512: AND procedure_name = 'CON_REQUEST_SECONDARY_LOCATORS';
513: