APPS.CSM_SYSTEM_ITEM_EVENT_PKG dependencies on JTM_CON_REQUEST_DATA

Line 323: l_last_run_date jtm_con_request_data.last_run_date%TYPE;

319: */
320: PROCEDURE Refresh_Acc (p_status OUT NOCOPY VARCHAR2,
321: p_message OUT NOCOPY VARCHAR2) AS
322: PRAGMA AUTONOMOUS_TRANSACTION;
323: l_last_run_date jtm_con_request_data.last_run_date%TYPE;
324: l_sqlerrno varchar2(20);
325: l_sqlerrmsg varchar2(2000);
326: l_current_run_date DATE;
327: l_max_last_update_date_b DATE;

Line 344: FROM jtm_con_request_data

340:
341: CURSOR l_last_run_date_csr
342: IS
343: SELECT nvl(last_run_date, (sysdate - 365*50))
344: FROM jtm_con_request_data
345: WHERE package_name = 'CSM_SYSTEM_ITEM_EVENT_PKG'
346: AND procedure_name = 'REFRESH_ACC';
347:
348: CURSOR c_max_last_upd_date_b

Line 519: -- set the program update date in jtm_con_request_data to sysdate

515: p_status := 'FINE';
516: p_message := 'CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_SYSTEM_ITEMS Executed successfully - No updates';
517: csm_util_pkg.log('No updates for csm_system_items_event_new_pkg', 'CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_SYSTEM_ITEMS ');
518:
519: -- set the program update date in jtm_con_request_data to sysdate
520: UPDATE jtm_con_request_data
521: SET last_run_date = l_current_run_date
522: WHERE package_name = 'CSM_SYSTEM_ITEM_EVENT_PKG'
523: AND procedure_name = 'REFRESH_ACC';

Line 520: UPDATE jtm_con_request_data

516: p_message := 'CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_SYSTEM_ITEMS Executed successfully - No updates';
517: csm_util_pkg.log('No updates for csm_system_items_event_new_pkg', 'CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_SYSTEM_ITEMS ');
518:
519: -- set the program update date in jtm_con_request_data to sysdate
520: UPDATE jtm_con_request_data
521: SET last_run_date = l_current_run_date
522: WHERE package_name = 'CSM_SYSTEM_ITEM_EVENT_PKG'
523: AND procedure_name = 'REFRESH_ACC';
524:

Line 594: -- set the program update date in jtm_con_request_data to sysdate

590: END IF;
591: END LOOP;
592: CLOSE l_systemitems_ins_csr;
593:
594: -- set the program update date in jtm_con_request_data to sysdate
595: UPDATE jtm_con_request_data
596: SET last_run_date = l_current_run_date
597: WHERE package_name = 'CSM_SYSTEM_ITEM_EVENT_PKG'
598: AND procedure_name = 'REFRESH_ACC';

Line 595: UPDATE jtm_con_request_data

591: END LOOP;
592: CLOSE l_systemitems_ins_csr;
593:
594: -- set the program update date in jtm_con_request_data to sysdate
595: UPDATE jtm_con_request_data
596: SET last_run_date = l_current_run_date
597: WHERE package_name = 'CSM_SYSTEM_ITEM_EVENT_PKG'
598: AND procedure_name = 'REFRESH_ACC';
599:

Line 621: l_last_run_date jtm_con_request_data.last_run_date%TYPE;

617: p_message OUT NOCOPY VARCHAR2)
618: IS
619: PRAGMA AUTONOMOUS_TRANSACTION;
620: g_pub_item VARCHAR2(30) := 'CSF_M_INVENTORY';
621: l_last_run_date jtm_con_request_data.last_run_date%TYPE;
622: l_sqlerrno varchar2(20);
623: l_sqlerrmsg varchar2(2000);
624:
625: CURSOR l_onhand_acc_seq IS

Line 972: -- set the program update date in jtm_con_request_data to sysdate

968: END IF;
969: END LOOP;
970: CLOSE l_onhand_insert_csr;
971:
972: -- set the program update date in jtm_con_request_data to sysdate
973: UPDATE jtm_con_request_data
974: SET last_run_date = l_current_run_date
975: WHERE product_code = 'CSM'
976: AND package_name = 'CSM_SYSTEM_ITEM_EVENT_PKG'

Line 973: UPDATE jtm_con_request_data

969: END LOOP;
970: CLOSE l_onhand_insert_csr;
971:
972: -- set the program update date in jtm_con_request_data to sysdate
973: UPDATE jtm_con_request_data
974: SET last_run_date = l_current_run_date
975: WHERE product_code = 'CSM'
976: AND package_name = 'CSM_SYSTEM_ITEM_EVENT_PKG'
977: AND procedure_name = 'REFRESH_MTL_ONHAND_QUANTITY';