APPS.CSM_RESCODE_MAPPING_EVENT_PKG dependencies on ASG_DOWNLOAD

Line 26: l_map_access_list asg_download.access_list;

22: l_sqlerrno VARCHAR2(20);
23: l_sqlerrmsg varchar2(2000);
24: l_mark_dirty boolean;
25: l_pub_item varchar2(30) := 'CSM_RESCODE_MAPPING';
26: l_map_access_list asg_download.access_list;
27: l_all_omfs_resource_list asg_download.user_list;
28: l_null_omfs_resource_list asg_download.user_list;
29: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
30: l_resol_map_id_tbl res_map_id_tbl_typ;

Line 27: l_all_omfs_resource_list asg_download.user_list;

23: l_sqlerrmsg varchar2(2000);
24: l_mark_dirty boolean;
25: l_pub_item varchar2(30) := 'CSM_RESCODE_MAPPING';
26: l_map_access_list asg_download.access_list;
27: l_all_omfs_resource_list asg_download.user_list;
28: l_null_omfs_resource_list asg_download.user_list;
29: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
30: l_resol_map_id_tbl res_map_id_tbl_typ;
31:

Line 28: l_null_omfs_resource_list asg_download.user_list;

24: l_mark_dirty boolean;
25: l_pub_item varchar2(30) := 'CSM_RESCODE_MAPPING';
26: l_map_access_list asg_download.access_list;
27: l_all_omfs_resource_list asg_download.user_list;
28: l_null_omfs_resource_list asg_download.user_list;
29: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
30: l_resol_map_id_tbl res_map_id_tbl_typ;
31:
32: --Cursor Declarations

Line 103: asg_download.del,

99: FOR j IN 1..l_all_omfs_resource_list.count LOOP
100: l_mark_dirty := csm_util_pkg.MakeDirtyForResource(l_pub_item,
101: l_map_access_list(i),
102: l_all_omfs_resource_list(j),
103: asg_download.del,
104: sysdate);
105:
106: END LOOP;
107: END LOOP;

Line 130: asg_download.upd,

126: FOR j IN 1..l_all_omfs_resource_list.count LOOP
127: l_mark_dirty := csm_util_pkg.MakeDirtyForResource(l_pub_item,
128: l_map_access_list(i),
129: l_all_omfs_resource_list(j),
130: asg_download.upd,
131: sysdate);
132:
133: END LOOP;
134: END LOOP;

Line 156: asg_download.ins,

152: FOR j IN 1..l_all_omfs_resource_list.count LOOP
153: l_mark_dirty := csm_util_pkg.MakeDirtyForResource(l_pub_item,
154: l_map_access_list(i),
155: l_all_omfs_resource_list(j),
156: asg_download.ins,
157: sysdate);
158:
159: END LOOP;
160: END LOOP;