APPS.CSM_SERIAL_NUMBERS_EVENT_PKG dependencies on JTM_CON_REQUEST_DATA

Line 366: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;

362:
363: PROCEDURE refresh_mtl_serial_numbers_acc
364: IS
365: PRAGMA AUTONOMOUS_TRANSACTION;
366: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
367: l_all_omfs_palm_resource_list asg_download.user_list;
368: l_valid_omfs_resource_list asg_download.user_list;
369: l_null_palm_omfs_resource_list asg_download.user_list;
370: l_user_palm_organization_id mtl_system_items.organization_id%TYPE;

Line 373: l_last_run_date jtm_con_request_data.last_run_date%TYPE;

369: l_null_palm_omfs_resource_list asg_download.user_list;
370: l_user_palm_organization_id mtl_system_items.organization_id%TYPE;
371: l_usr_list_for_serial asg_download.user_list;
372: l_rsrc_list_for_serial asg_download.user_list;
373: l_last_run_date jtm_con_request_data.last_run_date%TYPE;
374: l_run_date DATE;
375: l_user_id fnd_user.user_id%TYPE;
376: l_sqlerrno varchar2(20);
377: l_sqlerrmsg varchar2(2000);

Line 382: FROM jtm_con_request_data

378:
379: CURSOR l_last_run_date_csr
380: IS
381: SELECT nvl(last_run_date, (sysdate - 365*50))
382: FROM jtm_con_request_data
383: WHERE package_name = 'CSM_SERIAL_NUMBERS_EVENT_PKG'
384: AND procedure_name = 'REFRESH_MTL_SERIAL_NUMBERS_ACC';
385:
386: CURSOR l_user_id_csr (p_resourceid IN number)

Line 439: UPDATE jtm_con_request_data

435: END IF;
436:
437:
438: -- update last_run_date
439: UPDATE jtm_con_request_data
440: SET last_run_date = l_run_date
441: WHERE package_name = 'CSM_SERIAL_NUMBERS_EVENT_PKG'
442: AND procedure_name = 'REFRESH_MTL_SERIAL_NUMBERS_ACC';
443: