APPS.CSM_MTL_PARAMETERS_EVENT_PKG dependencies on JTM_CON_REQUEST_DATA

Line 44: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;

40: PROCEDURE Refresh_Acc (p_status OUT NOCOPY VARCHAR2,
41: p_message OUT NOCOPY VARCHAR2)
42: IS
43: PRAGMA AUTONOMOUS_TRANSACTION;
44: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
45: l_access_id jtm_fnd_lookups_acc.access_id%TYPE;
46: l_mark_dirty boolean;
47: l_all_omfs_palm_resource_list asg_download.user_list;
48: l_null_resource_list asg_download.user_list;

Line 57: FROM jtm_con_request_data

53:
54: CURSOR l_last_run_date_csr
55: IS
56: SELECT nvl(last_run_date, (sysdate - 365*50))
57: FROM jtm_con_request_data
58: WHERE package_name = 'CSM_MTL_PARAMETERS_EVENT_PKG'
59: AND procedure_name = 'REFRESH_ACC';
60:
61: -- inserts cur

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

190: );
191:
192: END LOOP;
193:
194: -- set the program update date in jtm_con_request_data to sysdate
195: UPDATE jtm_con_request_data
196: SET last_run_date = sysdate
197: WHERE package_name = 'CSM_MTL_PARAMETERS_EVENT_PKG'
198: AND procedure_name = 'REFRESH_ACC';

Line 195: UPDATE jtm_con_request_data

191:
192: END LOOP;
193:
194: -- set the program update date in jtm_con_request_data to sysdate
195: UPDATE jtm_con_request_data
196: SET last_run_date = sysdate
197: WHERE package_name = 'CSM_MTL_PARAMETERS_EVENT_PKG'
198: AND procedure_name = 'REFRESH_ACC';
199:

Line 218: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;

214:
215: PROCEDURE Refresh_InterOrg_Acc (p_status OUT NOCOPY VARCHAR2,p_message OUT NOCOPY VARCHAR2)
216: IS
217: PRAGMA AUTONOMOUS_TRANSACTION;
218: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
219: l_markdirty boolean;
220: l_sqlerrno varchar2(20);
221: l_sqlerrmsg varchar2(4000);
222:

Line 234: FROM jtm_con_request_data

230:
231: CURSOR l_last_run_date_csr
232: IS
233: SELECT nvl(last_run_date, (sysdate - 365*50))
234: FROM jtm_con_request_data
235: WHERE package_name = 'CSM_MTL_PARAMETERS_EVENT_PKG'
236: AND procedure_name = 'REFRESH_INTERORG_ACC';
237:
238: -- inserts cur

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

377: END LOOP;
378: CLOSE c_mtl_parameters_ins_csr;
379: END LOOP;
380:
381: -- set the program update date in jtm_con_request_data to sysdate
382: UPDATE jtm_con_request_data
383: SET last_run_date = sysdate
384: WHERE package_name = 'CSM_MTL_PARAMETERS_EVENT_PKG'
385: AND procedure_name = 'REFRESH_INTERORG_ACC';

Line 382: UPDATE jtm_con_request_data

378: CLOSE c_mtl_parameters_ins_csr;
379: END LOOP;
380:
381: -- set the program update date in jtm_con_request_data to sysdate
382: UPDATE jtm_con_request_data
383: SET last_run_date = sysdate
384: WHERE package_name = 'CSM_MTL_PARAMETERS_EVENT_PKG'
385: AND procedure_name = 'REFRESH_INTERORG_ACC';
386:

Line 407: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;

403:
404: PROCEDURE REFRESH_FREIGHTS_ACC (p_status OUT NOCOPY VARCHAR2,p_message OUT NOCOPY VARCHAR2)
405: IS
406: PRAGMA AUTONOMOUS_TRANSACTION;
407: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
408: l_sqlerrno varchar2(20);
409: l_sqlerrmsg varchar2(4000);
410:
411: CURSOR l_last_run_date_csr

Line 414: FROM jtm_con_request_data

410:
411: CURSOR l_last_run_date_csr
412: IS
413: SELECT nvl(last_run_date, (sysdate - 365*50))
414: FROM jtm_con_request_data
415: WHERE package_name = 'CSM_MTL_PARAMETERS_EVENT_PKG'
416: AND procedure_name = 'REFRESH_FREIGHTS_ACC';
417:
418: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;

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

592: COMMIT;
593: END LOOP;
594: CLOSE c_inv_org_freights_ins_csr;
595:
596: -- set the program update date in jtm_con_request_data to sysdate
597: UPDATE jtm_con_request_data
598: SET last_run_date = sysdate
599: WHERE package_name = 'CSM_MTL_PARAMETERS_EVENT_PKG'
600: AND procedure_name = 'REFRESH_FREIGHTS_ACC';

Line 597: UPDATE jtm_con_request_data

593: END LOOP;
594: CLOSE c_inv_org_freights_ins_csr;
595:
596: -- set the program update date in jtm_con_request_data to sysdate
597: UPDATE jtm_con_request_data
598: SET last_run_date = sysdate
599: WHERE package_name = 'CSM_MTL_PARAMETERS_EVENT_PKG'
600: AND procedure_name = 'REFRESH_FREIGHTS_ACC';
601: