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 349: FROM jtm_con_request_data

345:
346: CURSOR l_last_run_date_csr
347: IS
348: SELECT nvl(last_run_date, (sysdate - 365*50))
349: FROM jtm_con_request_data
350: WHERE package_name = 'CSM_SYSTEM_ITEM_EVENT_PKG'
351: AND procedure_name = 'REFRESH_ACC';
352:
353: CURSOR c_max_last_upd_date_b

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

533: p_status := 'FINE';
534: p_message := 'CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_SYSTEM_ITEMS Executed successfully - No updates';
535: csm_util_pkg.log('No updates for csm_system_items_event_new_pkg', 'CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_SYSTEM_ITEMS ');
536:
537: -- set the program update date in jtm_con_request_data to sysdate
538: UPDATE jtm_con_request_data
539: SET last_run_date = l_current_run_date
540: WHERE package_name = 'CSM_SYSTEM_ITEM_EVENT_PKG'
541: AND procedure_name = 'REFRESH_ACC';

Line 538: UPDATE jtm_con_request_data

534: p_message := 'CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_SYSTEM_ITEMS Executed successfully - No updates';
535: csm_util_pkg.log('No updates for csm_system_items_event_new_pkg', 'CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_SYSTEM_ITEMS ');
536:
537: -- set the program update date in jtm_con_request_data to sysdate
538: UPDATE jtm_con_request_data
539: SET last_run_date = l_current_run_date
540: WHERE package_name = 'CSM_SYSTEM_ITEM_EVENT_PKG'
541: AND procedure_name = 'REFRESH_ACC';
542:

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

679: END IF;
680: END LOOP;
681: CLOSE l_systemitems_ins_csr;
682: END IF;
683: -- set the program update date in jtm_con_request_data to sysdate
684: UPDATE jtm_con_request_data
685: SET last_run_date = l_current_run_date
686: WHERE package_name = 'CSM_SYSTEM_ITEM_EVENT_PKG'
687: AND procedure_name = 'REFRESH_ACC';

Line 684: UPDATE jtm_con_request_data

680: END LOOP;
681: CLOSE l_systemitems_ins_csr;
682: END IF;
683: -- set the program update date in jtm_con_request_data to sysdate
684: UPDATE jtm_con_request_data
685: SET last_run_date = l_current_run_date
686: WHERE package_name = 'CSM_SYSTEM_ITEM_EVENT_PKG'
687: AND procedure_name = 'REFRESH_ACC';
688:

Line 710: l_last_run_date jtm_con_request_data.last_run_date%TYPE;

706: p_message OUT NOCOPY VARCHAR2)
707: IS
708: PRAGMA AUTONOMOUS_TRANSACTION;
709: g_pub_item VARCHAR2(30) := 'CSF_M_INVENTORY';
710: l_last_run_date jtm_con_request_data.last_run_date%TYPE;
711: l_sqlerrno varchar2(20);
712: l_sqlerrmsg varchar2(2000);
713:
714: CURSOR l_onhand_acc_seq IS

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

1080: END IF;
1081: END LOOP;
1082: CLOSE l_onhand_insert_csr;
1083:
1084: -- set the program update date in jtm_con_request_data to sysdate
1085: UPDATE jtm_con_request_data
1086: SET last_run_date = l_current_run_date
1087: WHERE product_code = 'CSM'
1088: AND package_name = 'CSM_SYSTEM_ITEM_EVENT_PKG'

Line 1085: UPDATE jtm_con_request_data

1081: END LOOP;
1082: CLOSE l_onhand_insert_csr;
1083:
1084: -- set the program update date in jtm_con_request_data to sysdate
1085: UPDATE jtm_con_request_data
1086: SET last_run_date = l_current_run_date
1087: WHERE product_code = 'CSM'
1088: AND package_name = 'CSM_SYSTEM_ITEM_EVENT_PKG'
1089: AND procedure_name = 'REFRESH_MTL_ONHAND_QUANTITY';