105: FOR r_uom_del_rec IN l_uom_del_csr LOOP
106:
107: --get the users with this language
108: l_tl_omfs_palm_resource_list := l_null_resource_list;
109: l_tl_omfs_palm_resource_list := csm_util_pkg.get_tl_omfs_palm_resources(r_uom_del_rec.language);
110:
111: l_access_id := r_uom_del_rec.access_id;
112:
113: --nullify the access list
121: l_pkvalueslist(2) := r_uom_del_rec.language;
122:
123: --mark dirty the SDQ for all users
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 );
137: FOR r_uom_upd_rec IN l_uom_upd_csr(l_prog_update_date) LOOP
138:
139: --get the users with this language
140: l_tl_omfs_palm_resource_list := l_null_resource_list;
141: l_tl_omfs_palm_resource_list := csm_util_pkg.get_tl_omfs_palm_resources(r_uom_upd_rec.language);
142:
143: l_access_id := r_uom_upd_rec.access_id;
144:
145: --nullify the access list
150: END LOOP;
151:
152: --mark dirty the SDQ for all users
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);
164: FOR r_uom_ins_rec IN l_uom_ins_csr LOOP
165:
166: --get the users with this language
167: l_tl_omfs_palm_resource_list := l_null_resource_list;
168: l_tl_omfs_palm_resource_list := csm_util_pkg.get_tl_omfs_palm_resources(r_uom_ins_rec.language);
169:
170: SELECT csm_unit_of_measure_tl_acc_s.nextval
171: INTO l_access_id
172: FROM dual;
179: END LOOP;
180:
181: --mark dirty the SDQ for all users
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);