31: l_pub_item VARCHAR2(30) := 'CSM_MTL_SECONDARY_LOCATORS';
32: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
33: l_access_id jtm_fnd_lookups_acc.access_id%TYPE;
34: l_mark_dirty boolean;
35: l_all_omfs_palm_resource_list asg_download.user_list;
36: l_null_resource_list asg_download.user_list;
37: l_single_access_id_list asg_download.access_list;
38: --a null list
39: l_null_access_list asg_download.access_list;
32: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
33: l_access_id jtm_fnd_lookups_acc.access_id%TYPE;
34: l_mark_dirty boolean;
35: l_all_omfs_palm_resource_list asg_download.user_list;
36: l_null_resource_list asg_download.user_list;
37: l_single_access_id_list asg_download.access_list;
38: --a null list
39: l_null_access_list asg_download.access_list;
40: l_run_date date;
33: l_access_id jtm_fnd_lookups_acc.access_id%TYPE;
34: l_mark_dirty boolean;
35: l_all_omfs_palm_resource_list asg_download.user_list;
36: l_null_resource_list asg_download.user_list;
37: l_single_access_id_list asg_download.access_list;
38: --a null list
39: l_null_access_list asg_download.access_list;
40: l_run_date date;
41: l_sqlerrno varchar2(20);
35: l_all_omfs_palm_resource_list asg_download.user_list;
36: l_null_resource_list asg_download.user_list;
37: l_single_access_id_list asg_download.access_list;
38: --a null list
39: l_null_access_list asg_download.access_list;
40: l_run_date date;
41: l_sqlerrno varchar2(20);
42: l_sqlerrmsg varchar2(2000);
43: