APPS.CSM_SR_TYPE_MAP_EVENT_PKG dependencies on ASG_DOWNLOAD

Line 28: l_map_access_list asg_download.access_list;

24: l_sqlerrno VARCHAR2(20);
25: l_sqlerrmsg varchar2(2000);
26: l_mark_dirty boolean;
27: l_pub_item varchar2(30) := 'CSM_SR_TYPE_MAPPING';
28: l_map_access_list asg_download.access_list;
29: l_all_omfs_resource_list asg_download.user_list;
30: l_null_omfs_resource_list asg_download.user_list;
31: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
32: l_sr_type_id_tbl incident_type_id_tbl_typ;

Line 29: l_all_omfs_resource_list asg_download.user_list;

25: l_sqlerrmsg varchar2(2000);
26: l_mark_dirty boolean;
27: l_pub_item varchar2(30) := 'CSM_SR_TYPE_MAPPING';
28: l_map_access_list asg_download.access_list;
29: l_all_omfs_resource_list asg_download.user_list;
30: l_null_omfs_resource_list asg_download.user_list;
31: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
32: l_sr_type_id_tbl incident_type_id_tbl_typ;
33: l_responsibility_id_tbl responsibility_id_tbl_typ;

Line 30: l_null_omfs_resource_list asg_download.user_list;

26: l_mark_dirty boolean;
27: l_pub_item varchar2(30) := 'CSM_SR_TYPE_MAPPING';
28: l_map_access_list asg_download.access_list;
29: l_all_omfs_resource_list asg_download.user_list;
30: l_null_omfs_resource_list asg_download.user_list;
31: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
32: l_sr_type_id_tbl incident_type_id_tbl_typ;
33: l_responsibility_id_tbl responsibility_id_tbl_typ;
34: l_user_list asg_download.user_list;

Line 34: l_user_list asg_download.user_list;

30: l_null_omfs_resource_list asg_download.user_list;
31: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
32: l_sr_type_id_tbl incident_type_id_tbl_typ;
33: l_responsibility_id_tbl responsibility_id_tbl_typ;
34: l_user_list asg_download.user_list;
35:
36: --Cursor Declarations
37: --Insert Cursor
38: CURSOR csr_sr_type_map_ins

Line 115: asg_download.del,

111: FOR i IN 1..l_map_access_list.count LOOP
112: l_mark_dirty := csm_util_pkg.MakeDirtyForUser (l_pub_item,
113: l_map_access_list(i),
114: l_user_list(i),
115: asg_download.del,
116: sysdate);
117:
118: END LOOP;
119:

Line 141: asg_download.upd,

137: FOR i IN 1..l_map_access_list.count LOOP
138: l_mark_dirty := csm_util_pkg.MakeDirtyForUser(l_pub_item,
139: l_map_access_list(i),
140: l_user_list(i),
141: asg_download.upd,
142: sysdate);
143:
144: END LOOP;
145:

Line 170: asg_download.ins,

166: FOR i IN 1..l_map_access_list.count LOOP
167: l_mark_dirty := csm_util_pkg.MakeDirtyForUser(l_pub_item,
168: l_map_access_list(i),
169: l_user_list(i),
170: asg_download.ins,
171: sysdate);
172:
173: END LOOP;
174: