eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSM_MTL_SYSTEM_ITEMS_EVENT_PKG dependencies on JTM_CON_REQUEST_DATA

Line 1333: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;

1329: PROCEDURE Refresh_mtl_system_items_acc(p_status OUT NOCOPY VARCHAR2,
1330: p_message OUT NOCOPY VARCHAR2)
1331: IS
1332: PRAGMA AUTONOMOUS_TRANSACTION;
1333: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
1334: l_all_omfs_user_list asg_download.user_list;
1335: l_null_omfs_user_list asg_download.user_list;
1336: l_user_id fnd_user.user_id%TYPE;
1337: l_user_organization_id mtl_system_items.organization_id%TYPE;

Line 1348: FROM jtm_con_request_data

1344:
1345: CURSOR l_last_run_date_csr
1346: IS
1347: SELECT NVL(last_run_date, TO_DATE('1','J'))
1348: FROM jtm_con_request_data
1349: WHERE package_name = 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG'
1350: AND procedure_name = 'REFRESH_MTL_SYSTEM_ITEMS_ACC';
1351:
1352: BEGIN

Line 1405: UPDATE jtm_con_request_data

1401:
1402: END IF;
1403:
1404: -- update last_run_date
1405: UPDATE jtm_con_request_data
1406: SET last_run_date = l_run_date
1407: WHERE package_name = 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG'
1408: AND procedure_name = 'REFRESH_MTL_SYSTEM_ITEMS_ACC';
1409: