APPS.CSM_SERIAL_NUMBERS_EVENT_PKG dependencies on JTM_CON_REQUEST_DATA

Line 408: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;

404: PROCEDURE refresh_mtl_serial_numbers_acc(p_status OUT NOCOPY VARCHAR2,
405: p_message OUT NOCOPY VARCHAR2)
406: IS
407: PRAGMA AUTONOMOUS_TRANSACTION;
408: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
409: l_all_omfs_palm_resource_list asg_download.user_list;
410: l_valid_omfs_resource_list asg_download.user_list;
411: l_null_palm_omfs_resource_list asg_download.user_list;
412: l_user_palm_organization_id mtl_system_items.organization_id%TYPE;

Line 415: l_last_run_date jtm_con_request_data.last_run_date%TYPE;

411: l_null_palm_omfs_resource_list asg_download.user_list;
412: l_user_palm_organization_id mtl_system_items.organization_id%TYPE;
413: l_usr_list_for_serial asg_download.user_list;
414: l_rsrc_list_for_serial asg_download.user_list;
415: l_last_run_date jtm_con_request_data.last_run_date%TYPE;
416: l_run_date DATE;
417: l_user_id fnd_user.user_id%TYPE;
418: l_sqlerrno varchar2(20);
419: l_sqlerrmsg varchar2(2000);

Line 424: FROM jtm_con_request_data

420:
421: CURSOR l_last_run_date_csr
422: IS
423: SELECT nvl(last_run_date, (sysdate - 365*50))
424: FROM jtm_con_request_data
425: WHERE package_name = 'CSM_SERIAL_NUMBERS_EVENT_PKG'
426: AND procedure_name = 'REFRESH_MTL_SERIAL_NUMBERS_ACC';
427:
428: CURSOR l_user_id_csr (p_resourceid IN number)

Line 481: UPDATE jtm_con_request_data

477: END LOOP;
478: END IF;
479:
480: -- update last_run_date
481: UPDATE jtm_con_request_data
482: SET last_run_date = l_run_date
483: WHERE package_name = 'CSM_SERIAL_NUMBERS_EVENT_PKG'
484: AND procedure_name = 'REFRESH_MTL_SERIAL_NUMBERS_ACC';
485: