eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSM_CURRENCY_EVENT_PKG dependencies on CSM_UTIL_PKG

Line 25: l_updates_cur CSM_UTIL_PKG.Changed_Records_Cur_Type;

21: procedure Refresh_Acc (p_status OUT NOCOPY VARCHAR2,
22: p_message OUT NOCOPY VARCHAR2)
23: IS
24: PRAGMA AUTONOMOUS_TRANSACTION;
25: l_updates_cur CSM_UTIL_PKG.Changed_Records_Cur_Type;
26: l_inserts_cur CSM_UTIL_PKG.Changed_Records_Cur_Type;
27: l_dsql varchar2(2048);
28: l_pub_item varchar2(30) := 'CSF_M_CURRENCIES';
29: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;

Line 26: l_inserts_cur CSM_UTIL_PKG.Changed_Records_Cur_Type;

22: p_message OUT NOCOPY VARCHAR2)
23: IS
24: PRAGMA AUTONOMOUS_TRANSACTION;
25: l_updates_cur CSM_UTIL_PKG.Changed_Records_Cur_Type;
26: l_inserts_cur CSM_UTIL_PKG.Changed_Records_Cur_Type;
27: l_dsql varchar2(2048);
28: l_pub_item varchar2(30) := 'CSF_M_CURRENCIES';
29: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
30: l_sqlerrno VARCHAR2(20);

Line 81: g_all_palm_res_list := CSM_UTIL_PKG.get_all_omfs_palm_res_list;

77: -- conc program run date
78: l_run_date := SYSDATE;
79:
80: --get all the OMFS Palm users
81: g_all_palm_res_list := CSM_UTIL_PKG.get_all_omfs_palm_res_list;
82:
83: /****** DELETES **********/
84: --open the cursor
85: open l_deletes_csr(l_prog_update_date);

Line 92: l_tl_omfs_palm_resource_list := csm_util_pkg.get_tl_omfs_palm_resources(l_language);

88: FETCH l_deletes_csr INTO l_access_id, l_currency_code, l_language;
89: EXIT WHEN l_deletes_csr%NOTFOUND;
90:
91: --get the users with this language
92: l_tl_omfs_palm_resource_list := csm_util_pkg.get_tl_omfs_palm_resources(l_language);
93:
94: --nullify the access list
95: l_single_access_id_list := l_null_access_list;
96: FOR i in 1 .. l_tl_omfs_palm_resource_list.COUNT LOOP

Line 102: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForResource('CSF_M_CURRENCIES',

98: END LOOP;
99:
100: --mark dirty the SDQ for all users
101: IF l_single_access_id_list.count > 0 THEN
102: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForResource('CSF_M_CURRENCIES',
103: l_single_access_id_list,
104: l_tl_omfs_palm_resource_list,
105: ASG_DOWNLOAD.DEL,
106: SYSDATE);

Line 146: l_tl_omfs_palm_resource_list := csm_util_pkg.get_tl_omfs_palm_resources(l_language);

142: FETCH l_updates_cur INTO l_access_id, l_language, l_curr_last_update_date, l_curr_tl_last_update_date;
143: EXIT WHEN l_updates_cur%NOTFOUND;
144:
145: --get the users with this language
146: l_tl_omfs_palm_resource_list := csm_util_pkg.get_tl_omfs_palm_resources(l_language);
147:
148: --nullify the access list
149: l_single_access_id_list := l_null_access_list;
150: FOR i in 1 .. l_tl_omfs_palm_resource_list.COUNT LOOP

Line 156: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForResource('CSF_M_CURRENCIES',

152: END LOOP;
153:
154: --mark dirty the SDQ for all users
155: IF l_single_access_id_list.count > 0 THEN
156: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForResource('CSF_M_CURRENCIES',
157: l_single_access_id_list, l_tl_omfs_palm_resource_list,
158: ASG_DOWNLOAD.UPD, sysdate);
159: END IF;
160:

Line 206: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForResource('CSF_M_CURRENCIES',

202: FETCH l_access_id_csr INTO l_access_id;
203: CLOSE l_access_id_csr;
204: --mark dirty the SDQ for all users
205: FOR i IN 1 .. g_all_palm_res_list.COUNT LOOP
206: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForResource('CSF_M_CURRENCIES',
207: l_access_id, g_all_palm_res_list(i),
208: ASG_DOWNLOAD.INS, sysdate);
209: END LOOP;
210:

Line 312: l_tl_omfs_palm_resource_list := csm_util_pkg.get_tl_omfs_palm_resources(r_currency_ins_rec.language);

308: FOR r_currency_ins_rec IN l_currency_ins_csr(l_prog_update_date) LOOP
309:
310: --get the users with this language
311: l_tl_omfs_palm_resource_list := l_null_resource_list;
312: l_tl_omfs_palm_resource_list := csm_util_pkg.get_tl_omfs_palm_resources(r_currency_ins_rec.language);
313:
314: -- get the access_id
315: l_access_id := csm_util_pkg.generate_NumPK_FromStr(r_currency_ins_rec.currency_code || '.'
316: || r_currency_ins_rec.language);

Line 315: l_access_id := csm_util_pkg.generate_NumPK_FromStr(r_currency_ins_rec.currency_code || '.'

311: l_tl_omfs_palm_resource_list := l_null_resource_list;
312: l_tl_omfs_palm_resource_list := csm_util_pkg.get_tl_omfs_palm_resources(r_currency_ins_rec.language);
313:
314: -- get the access_id
315: l_access_id := csm_util_pkg.generate_NumPK_FromStr(r_currency_ins_rec.currency_code || '.'
316: || r_currency_ins_rec.language);
317:
318: --nullify the access list
319: l_single_access_id_list := l_null_access_list;

Line 325: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForResource('CSF_M_CURRENCIES',

321: l_single_access_id_list(i) := l_access_id;
322: END LOOP;
323:
324: --mark dirty the SDQ for all users
325: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForResource('CSF_M_CURRENCIES',
326: l_single_access_id_list, l_tl_omfs_palm_resource_list,
327: ASG_DOWNLOAD.INS, sysdate);
328: END LOOP;
329:

Line 334: l_tl_omfs_palm_resource_list := csm_util_pkg.get_tl_omfs_palm_resources(r_currency_upd_rec.language);

330: -- process all updates
331: FOR r_currency_upd_rec IN l_currency_upd_csr(l_prog_update_date) LOOP
332: --get the users with this language
333: l_tl_omfs_palm_resource_list := l_null_resource_list;
334: l_tl_omfs_palm_resource_list := csm_util_pkg.get_tl_omfs_palm_resources(r_currency_upd_rec.language);
335:
336: -- get the access_id
337: l_access_id := csm_util_pkg.generate_NumPK_FromStr(r_currency_upd_rec.currency_code || '.'
338: || r_currency_upd_rec.language);

Line 337: l_access_id := csm_util_pkg.generate_NumPK_FromStr(r_currency_upd_rec.currency_code || '.'

333: l_tl_omfs_palm_resource_list := l_null_resource_list;
334: l_tl_omfs_palm_resource_list := csm_util_pkg.get_tl_omfs_palm_resources(r_currency_upd_rec.language);
335:
336: -- get the access_id
337: l_access_id := csm_util_pkg.generate_NumPK_FromStr(r_currency_upd_rec.currency_code || '.'
338: || r_currency_upd_rec.language);
339:
340: --nullify the access list
341: l_single_access_id_list := l_null_access_list;

Line 347: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForResource('CSF_M_CURRENCIES',

343: l_single_access_id_list(i) := l_access_id;
344: END LOOP;
345:
346: --mark dirty the SDQ for all users
347: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForResource('CSF_M_CURRENCIES',
348: l_single_access_id_list, l_tl_omfs_palm_resource_list,
349: ASG_DOWNLOAD.UPD, sysdate);
350:
351: END LOOP;

Line 357: l_tl_omfs_palm_resource_list := csm_util_pkg.get_tl_omfs_palm_resources(r_currency_del_rec.language);

353: -- process all deletes
354: FOR r_currency_del_rec IN l_currency_del_csr(l_prog_update_date) LOOP
355: --get the users with this language
356: l_tl_omfs_palm_resource_list := l_null_resource_list;
357: l_tl_omfs_palm_resource_list := csm_util_pkg.get_tl_omfs_palm_resources(r_currency_del_rec.language);
358:
359: -- get the access_id
360: l_access_id := csm_util_pkg.generate_NumPK_FromStr(r_currency_del_rec.currency_code || '.'
361: || r_currency_del_rec.language);

Line 360: l_access_id := csm_util_pkg.generate_NumPK_FromStr(r_currency_del_rec.currency_code || '.'

356: l_tl_omfs_palm_resource_list := l_null_resource_list;
357: l_tl_omfs_palm_resource_list := csm_util_pkg.get_tl_omfs_palm_resources(r_currency_del_rec.language);
358:
359: -- get the access_id
360: l_access_id := csm_util_pkg.generate_NumPK_FromStr(r_currency_del_rec.currency_code || '.'
361: || r_currency_del_rec.language);
362:
363: --nullify the access list
364: l_single_access_id_list := l_null_access_list;

Line 370: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForResource('CSF_M_CURRENCIES',

366: l_single_access_id_list(i) := l_access_id;
367: END LOOP;
368:
369: --mark dirty the SDQ for all users
370: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForResource('CSF_M_CURRENCIES',
371: l_single_access_id_list, l_tl_omfs_palm_resource_list,
372: ASG_DOWNLOAD.DEL, sysdate);
373:
374: END LOOP;