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_UOM_EVENT_PKG dependencies on ASG_DOWNLOAD

Line 38: l_tl_omfs_palm_resource_list asg_download.user_list;

34: l_sqlerrmsg varchar2(2000);
35: l_mark_dirty boolean;
36: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
37: l_access_id jtm_fnd_lookups_acc.access_id%TYPE;
38: l_tl_omfs_palm_resource_list asg_download.user_list;
39: l_null_resource_list asg_download.user_list;
40: l_single_access_id_list asg_download.access_list;
41: l_null_access_list asg_download.access_list;
42: l_pkvalueslist asg_download.pk_list;

Line 39: l_null_resource_list asg_download.user_list;

35: l_mark_dirty boolean;
36: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
37: l_access_id jtm_fnd_lookups_acc.access_id%TYPE;
38: l_tl_omfs_palm_resource_list asg_download.user_list;
39: l_null_resource_list asg_download.user_list;
40: l_single_access_id_list asg_download.access_list;
41: l_null_access_list asg_download.access_list;
42: l_pkvalueslist asg_download.pk_list;
43: l_null_pkvalueslist asg_download.pk_list;

Line 40: l_single_access_id_list asg_download.access_list;

36: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
37: l_access_id jtm_fnd_lookups_acc.access_id%TYPE;
38: l_tl_omfs_palm_resource_list asg_download.user_list;
39: l_null_resource_list asg_download.user_list;
40: l_single_access_id_list asg_download.access_list;
41: l_null_access_list asg_download.access_list;
42: l_pkvalueslist asg_download.pk_list;
43: l_null_pkvalueslist asg_download.pk_list;
44:

Line 41: l_null_access_list asg_download.access_list;

37: l_access_id jtm_fnd_lookups_acc.access_id%TYPE;
38: l_tl_omfs_palm_resource_list asg_download.user_list;
39: l_null_resource_list asg_download.user_list;
40: l_single_access_id_list asg_download.access_list;
41: l_null_access_list asg_download.access_list;
42: l_pkvalueslist asg_download.pk_list;
43: l_null_pkvalueslist asg_download.pk_list;
44:
45: CURSOR l_last_run_date_csr(p_pub_item IN varchar2)

Line 42: l_pkvalueslist asg_download.pk_list;

38: l_tl_omfs_palm_resource_list asg_download.user_list;
39: l_null_resource_list asg_download.user_list;
40: l_single_access_id_list asg_download.access_list;
41: l_null_access_list asg_download.access_list;
42: l_pkvalueslist asg_download.pk_list;
43: l_null_pkvalueslist asg_download.pk_list;
44:
45: CURSOR l_last_run_date_csr(p_pub_item IN varchar2)
46: IS

Line 43: l_null_pkvalueslist asg_download.pk_list;

39: l_null_resource_list asg_download.user_list;
40: l_single_access_id_list asg_download.access_list;
41: l_null_access_list asg_download.access_list;
42: l_pkvalueslist asg_download.pk_list;
43: l_null_pkvalueslist asg_download.pk_list;
44:
45: CURSOR l_last_run_date_csr(p_pub_item IN varchar2)
46: IS
47: SELECT nvl(last_run_date, (sysdate - 365*50))

Line 128: ASG_DOWNLOAD.DEL,

124: IF l_single_access_id_list.count > 0 THEN
125: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForResource(l_pub_item,
126: l_single_access_id_list,
127: l_tl_omfs_palm_resource_list,
128: ASG_DOWNLOAD.DEL,
129: SYSDATE );
130: END IF;
131:
132: -- delete from acc table

Line 157: ASG_DOWNLOAD.UPD,

153: IF l_single_access_id_list.count > 0 THEN
154: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForResource(l_pub_item,
155: l_single_access_id_list,
156: l_tl_omfs_palm_resource_list,
157: ASG_DOWNLOAD.UPD,
158: sysdate);
159: END IF;
160:
161: END LOOP;

Line 186: ASG_DOWNLOAD.INS,

182: IF l_single_access_id_list.count > 0 THEN
183: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForResource(l_pub_item,
184: l_single_access_id_list,
185: l_tl_omfs_palm_resource_list,
186: ASG_DOWNLOAD.INS,
187: sysdate);
188: END IF;
189:
190: -- insert into csm_unit_of_measure_tl_acc