APPS.CSM_MTL_PARAMETERS_EVENT_PKG dependencies on ASG_DOWNLOAD

Line 33: l_all_omfs_palm_resource_list asg_download.user_list;

29: l_pub_item VARCHAR2(30) := 'CSM_MTL_PARAMETERS';
30: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
31: l_access_id jtm_fnd_lookups_acc.access_id%TYPE;
32: l_mark_dirty boolean;
33: l_all_omfs_palm_resource_list asg_download.user_list;
34: l_null_resource_list asg_download.user_list;
35: l_single_access_id_list asg_download.access_list;
36: --a null list
37: l_null_access_list asg_download.access_list;

Line 34: l_null_resource_list asg_download.user_list;

30: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
31: l_access_id jtm_fnd_lookups_acc.access_id%TYPE;
32: l_mark_dirty boolean;
33: l_all_omfs_palm_resource_list asg_download.user_list;
34: l_null_resource_list asg_download.user_list;
35: l_single_access_id_list asg_download.access_list;
36: --a null list
37: l_null_access_list asg_download.access_list;
38: l_run_date date;

Line 35: l_single_access_id_list asg_download.access_list;

31: l_access_id jtm_fnd_lookups_acc.access_id%TYPE;
32: l_mark_dirty boolean;
33: l_all_omfs_palm_resource_list asg_download.user_list;
34: l_null_resource_list asg_download.user_list;
35: l_single_access_id_list asg_download.access_list;
36: --a null list
37: l_null_access_list asg_download.access_list;
38: l_run_date date;
39: l_sqlerrno varchar2(20);

Line 37: l_null_access_list asg_download.access_list;

33: l_all_omfs_palm_resource_list asg_download.user_list;
34: l_null_resource_list asg_download.user_list;
35: l_single_access_id_list asg_download.access_list;
36: --a null list
37: l_null_access_list asg_download.access_list;
38: l_run_date date;
39: l_sqlerrno varchar2(20);
40: l_sqlerrmsg varchar2(2000);
41:

Line 108: ASG_DOWNLOAD.DEL, sysdate);

104: --mark dirty the SDQ for all users
105: IF l_single_access_id_list.count > 0 THEN
106: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForResource('CSM_MTL_PARAMETERS',
107: l_single_access_id_list, l_all_omfs_palm_resource_list,
108: ASG_DOWNLOAD.DEL, sysdate);
109: END IF;
110:
111: -- delete from acc table
112: DELETE FROM csm_mtl_parameters_acc WHERE access_id = l_access_id;

Line 134: ASG_DOWNLOAD.UPD, sysdate);

130: --mark dirty the SDQ for all users
131: IF l_single_access_id_list.count > 0 THEN
132: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForResource('CSM_MTL_PARAMETERS',
133: l_single_access_id_list, l_all_omfs_palm_resource_list,
134: ASG_DOWNLOAD.UPD, sysdate);
135: END IF;
136:
137: END LOOP;
138:

Line 160: ASG_DOWNLOAD.INS, sysdate);

156: --mark dirty the SDQ for all users
157: IF l_single_access_id_list.count > 0 THEN
158: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForResource('CSM_MTL_PARAMETERS',
159: l_single_access_id_list, l_all_omfs_palm_resource_list,
160: ASG_DOWNLOAD.INS, sysdate);
161: END IF;
162:
163: INSERT INTO csm_mtl_parameters_acc (access_id,
164: organization_id,