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 ASG_DOWNLOAD

Line 14: g_all_palm_res_list asg_download.user_list;

10: -- Person Date Comments
11: -- --------- ------ ------------------------------------------
12: -- Enter procedure, function bodies as shown below
13:
14: g_all_palm_res_list asg_download.user_list;
15:
16:
17: /**
18: Makes corresponding entries in to SDQ for all deletes, updates and inserts

Line 65: l_tl_omfs_palm_resource_list asg_download.user_list;

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
68: l_null_access_list asg_download.access_list;
69: l_run_date date;

Line 66: l_single_access_id_list asg_download.access_list;

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
68: l_null_access_list asg_download.access_list;
69: l_run_date date;
70:

Line 68: l_null_access_list asg_download.access_list;

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
68: l_null_access_list asg_download.access_list;
69: l_run_date date;
70:
71: BEGIN
72: -- get last conc program update date

Line 105: ASG_DOWNLOAD.DEL,

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);
107: END IF;
108:
109: --remove from ACC

Line 158: ASG_DOWNLOAD.UPD, sysdate);

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:
161: --get the max update date
162: IF (l_curr_last_update_date > l_curr_tl_last_update_date) THEN

Line 208: ASG_DOWNLOAD.INS, sysdate);

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:
211: --insert into
212: INSERT INTO csm_currencies_acc(currency_code, access_id, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,

Line 249: l_tl_omfs_palm_resource_list asg_download.user_list;

245: l_pub_item varchar2(30) := 'CSF_M_CURRENCIES';
246: l_prog_update_date asg_pub_item.last_run_date%TYPE;
247: l_access_id jtm_fnd_lookups_acc.access_id%TYPE;
248: l_mark_dirty boolean;
249: l_tl_omfs_palm_resource_list asg_download.user_list;
250: l_null_resource_list asg_download.user_list;
251: l_single_access_id_list asg_download.access_list;
252: --a null list
253: l_null_access_list asg_download.access_list;

Line 250: l_null_resource_list asg_download.user_list;

246: l_prog_update_date asg_pub_item.last_run_date%TYPE;
247: l_access_id jtm_fnd_lookups_acc.access_id%TYPE;
248: l_mark_dirty boolean;
249: l_tl_omfs_palm_resource_list asg_download.user_list;
250: l_null_resource_list asg_download.user_list;
251: l_single_access_id_list asg_download.access_list;
252: --a null list
253: l_null_access_list asg_download.access_list;
254: l_run_date date;

Line 251: l_single_access_id_list asg_download.access_list;

247: l_access_id jtm_fnd_lookups_acc.access_id%TYPE;
248: l_mark_dirty boolean;
249: l_tl_omfs_palm_resource_list asg_download.user_list;
250: l_null_resource_list asg_download.user_list;
251: l_single_access_id_list asg_download.access_list;
252: --a null list
253: l_null_access_list asg_download.access_list;
254: l_run_date date;
255:

Line 253: l_null_access_list asg_download.access_list;

249: l_tl_omfs_palm_resource_list asg_download.user_list;
250: l_null_resource_list asg_download.user_list;
251: l_single_access_id_list asg_download.access_list;
252: --a null list
253: l_null_access_list asg_download.access_list;
254: l_run_date date;
255:
256: CURSOR l_last_run_date_csr(p_pub_item IN varchar2)
257: IS

Line 327: ASG_DOWNLOAD.INS, sysdate);

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:
330: -- process all updates
331: FOR r_currency_upd_rec IN l_currency_upd_csr(l_prog_update_date) LOOP

Line 349: ASG_DOWNLOAD.UPD, sysdate);

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;
352:
353: -- process all deletes

Line 372: ASG_DOWNLOAD.DEL, sysdate);

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;
375:
376: -- set the program update date in asg_pub_item to sysdate