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 FND_CURRENCIES

Line 44: FROM fnd_currencies curr,

40:
41: CURSOR l_deletes_csr(p_last_upd_date date)
42: IS
43: SELECT acc.access_id, curr.currency_code, curr_tl.language
44: FROM fnd_currencies curr,
45: fnd_currencies_tl curr_tl,
46: csm_currencies_acc acc
47: WHERE curr.currency_code = curr_tl.currency_code
48: AND curr.currency_code = acc.currency_code

Line 45: fnd_currencies_tl curr_tl,

41: CURSOR l_deletes_csr(p_last_upd_date date)
42: IS
43: SELECT acc.access_id, curr.currency_code, curr_tl.language
44: FROM fnd_currencies curr,
45: fnd_currencies_tl curr_tl,
46: csm_currencies_acc acc
47: WHERE curr.currency_code = curr_tl.currency_code
48: AND curr.currency_code = acc.currency_code
49: AND ((SYSDATE not BETWEEN nvl(curr.start_date_active, sysdate) AND nvl(curr.end_date_active, sysdate))

Line 59: l_curr_last_update_date fnd_currencies.LAST_UPDATE_DATE%TYPE;

55: CURSOR l_access_id_csr IS
56: select csm_currencies_acc_s.NEXTVAL from dual;
57:
58: l_mark_dirty boolean;
59: l_curr_last_update_date fnd_currencies.LAST_UPDATE_DATE%TYPE;
60: l_curr_tl_last_update_date fnd_currencies.LAST_UPDATE_DATE%TYPE;
61: l_max_update_date fnd_currencies.LAST_UPDATE_DATE%TYPE;
62: l_language fnd_currencies_tl.language%TYPE;
63: l_currency_code fnd_currencies.currency_code%TYPE;

Line 60: l_curr_tl_last_update_date fnd_currencies.LAST_UPDATE_DATE%TYPE;

56: select csm_currencies_acc_s.NEXTVAL from dual;
57:
58: l_mark_dirty boolean;
59: l_curr_last_update_date fnd_currencies.LAST_UPDATE_DATE%TYPE;
60: l_curr_tl_last_update_date fnd_currencies.LAST_UPDATE_DATE%TYPE;
61: l_max_update_date fnd_currencies.LAST_UPDATE_DATE%TYPE;
62: l_language fnd_currencies_tl.language%TYPE;
63: l_currency_code fnd_currencies.currency_code%TYPE;
64: l_access_id CSM_currencies_ACC.ACCESS_ID%TYPE;

Line 61: l_max_update_date fnd_currencies.LAST_UPDATE_DATE%TYPE;

57:
58: l_mark_dirty boolean;
59: l_curr_last_update_date fnd_currencies.LAST_UPDATE_DATE%TYPE;
60: l_curr_tl_last_update_date fnd_currencies.LAST_UPDATE_DATE%TYPE;
61: l_max_update_date fnd_currencies.LAST_UPDATE_DATE%TYPE;
62: l_language fnd_currencies_tl.language%TYPE;
63: l_currency_code fnd_currencies.currency_code%TYPE;
64: l_access_id CSM_currencies_ACC.ACCESS_ID%TYPE;
65: l_tl_omfs_palm_resource_list asg_download.user_list;

Line 62: l_language fnd_currencies_tl.language%TYPE;

58: l_mark_dirty boolean;
59: l_curr_last_update_date fnd_currencies.LAST_UPDATE_DATE%TYPE;
60: l_curr_tl_last_update_date fnd_currencies.LAST_UPDATE_DATE%TYPE;
61: l_max_update_date fnd_currencies.LAST_UPDATE_DATE%TYPE;
62: l_language fnd_currencies_tl.language%TYPE;
63: l_currency_code fnd_currencies.currency_code%TYPE;
64: l_access_id CSM_currencies_ACC.ACCESS_ID%TYPE;
65: l_tl_omfs_palm_resource_list asg_download.user_list;
66: l_single_access_id_list asg_download.access_list;

Line 63: l_currency_code fnd_currencies.currency_code%TYPE;

59: l_curr_last_update_date fnd_currencies.LAST_UPDATE_DATE%TYPE;
60: l_curr_tl_last_update_date fnd_currencies.LAST_UPDATE_DATE%TYPE;
61: l_max_update_date fnd_currencies.LAST_UPDATE_DATE%TYPE;
62: l_language fnd_currencies_tl.language%TYPE;
63: l_currency_code fnd_currencies.currency_code%TYPE;
64: l_access_id CSM_currencies_ACC.ACCESS_ID%TYPE;
65: l_tl_omfs_palm_resource_list asg_download.user_list;
66: l_single_access_id_list asg_download.access_list;
67: --a null list

Line 123: fnd_currencies curr,

119: --generate sql for updates
120: l_dsql :=
121: 'select acc.access_id, curr_tl.language, curr.last_update_date, curr_tl.last_update_date
122: from csm_currencies_acc acc,
123: fnd_currencies curr,
124: fnd_currencies_tl curr_tl
125: where acc.currency_code = curr.currency_code
126: and curr_tl.currency_code = curr.currency_code
127: AND SYSDATE BETWEEN nvl(curr.start_date_active, sysdate) AND nvl(curr.end_date_active, sysdate)

Line 124: fnd_currencies_tl curr_tl

120: l_dsql :=
121: 'select acc.access_id, curr_tl.language, curr.last_update_date, curr_tl.last_update_date
122: from csm_currencies_acc acc,
123: fnd_currencies curr,
124: fnd_currencies_tl curr_tl
125: where acc.currency_code = curr.currency_code
126: and curr_tl.currency_code = curr.currency_code
127: AND SYSDATE BETWEEN nvl(curr.start_date_active, sysdate) AND nvl(curr.end_date_active, sysdate)
128: AND curr.enabled_flag = ''Y''

Line 183: FROM fnd_currencies curr

179: --generate sql for inserts
180:
181: l_dsql :=
182: 'SELECT curr.currency_code, curr.last_update_date
183: FROM fnd_currencies curr
184: WHERE SYSDATE BETWEEN nvl(curr.start_date_active, sysdate) AND nvl(curr.end_date_active, sysdate)
185: AND curr.enabled_flag = ''Y''
186: AND NOT EXISTS
187: (SELECT 1

Line 266: FROM fnd_currencies curr,

262:
263: CURSOR l_currency_ins_csr(p_last_upd_date date)
264: IS
265: SELECT curr.currency_code, curr_tl.language, curr.last_update_date
266: FROM fnd_currencies curr,
267: fnd_currencies_tl curr_tl
268: WHERE curr.currency_code = curr_tl.currency_code
269: AND SYSDATE BETWEEN nvl(curr.start_date_active, sysdate) AND nvl(curr.end_date_active, sysdate)
270: AND curr.enabled_flag = 'Y'

Line 267: fnd_currencies_tl curr_tl

263: CURSOR l_currency_ins_csr(p_last_upd_date date)
264: IS
265: SELECT curr.currency_code, curr_tl.language, curr.last_update_date
266: FROM fnd_currencies curr,
267: fnd_currencies_tl curr_tl
268: WHERE curr.currency_code = curr_tl.currency_code
269: AND SYSDATE BETWEEN nvl(curr.start_date_active, sysdate) AND nvl(curr.end_date_active, sysdate)
270: AND curr.enabled_flag = 'Y'
271: AND (curr.creation_date > p_last_upd_date

Line 277: FROM fnd_currencies curr,

273:
274: CURSOR l_currency_upd_csr(p_last_upd_date date)
275: IS
276: SELECT curr.currency_code, curr_tl.language
277: FROM fnd_currencies curr,
278: fnd_currencies_tl curr_tl
279: WHERE curr.currency_code = curr_tl.currency_code
280: AND SYSDATE BETWEEN nvl(curr.start_date_active, sysdate) AND nvl(curr.end_date_active, sysdate)
281: AND curr.enabled_flag = 'Y'

Line 278: fnd_currencies_tl curr_tl

274: CURSOR l_currency_upd_csr(p_last_upd_date date)
275: IS
276: SELECT curr.currency_code, curr_tl.language
277: FROM fnd_currencies curr,
278: fnd_currencies_tl curr_tl
279: WHERE curr.currency_code = curr_tl.currency_code
280: AND SYSDATE BETWEEN nvl(curr.start_date_active, sysdate) AND nvl(curr.end_date_active, sysdate)
281: AND curr.enabled_flag = 'Y'
282: AND ((curr.creation_date < p_last_upd_date AND curr.last_update_date > p_last_upd_date)

Line 289: FROM fnd_currencies curr,

285:
286: CURSOR l_currency_del_csr(p_last_upd_date date)
287: IS
288: SELECT curr.currency_code, curr_tl.language
289: FROM fnd_currencies curr,
290: fnd_currencies_tl curr_tl
291: WHERE curr.currency_code = curr_tl.currency_code
292: AND ((SYSDATE not BETWEEN nvl(curr.start_date_active, sysdate) AND nvl(curr.end_date_active, sysdate))
293: OR curr.enabled_flag <> 'Y')

Line 290: fnd_currencies_tl curr_tl

286: CURSOR l_currency_del_csr(p_last_upd_date date)
287: IS
288: SELECT curr.currency_code, curr_tl.language
289: FROM fnd_currencies curr,
290: fnd_currencies_tl curr_tl
291: WHERE curr.currency_code = curr_tl.currency_code
292: AND ((SYSDATE not BETWEEN nvl(curr.start_date_active, sysdate) AND nvl(curr.end_date_active, sysdate))
293: OR curr.enabled_flag <> 'Y')
294: AND ((curr.creation_date < p_last_upd_date AND curr.last_update_date > p_last_upd_date)