DBA Data[Home] [Help]

APPS.CSM_UOM_EVENT_PKG dependencies on CSM_UTIL_PKG

Line 109: l_tl_omfs_palm_resource_list := csm_util_pkg.get_tl_omfs_palm_resources(r_uom_del_rec.language);

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

Line 125: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForResource(l_pub_item,

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 );

Line 141: l_tl_omfs_palm_resource_list := csm_util_pkg.get_tl_omfs_palm_resources(r_uom_upd_rec.language);

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

Line 154: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForResource(l_pub_item,

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);

Line 168: l_tl_omfs_palm_resource_list := csm_util_pkg.get_tl_omfs_palm_resources(r_uom_ins_rec.language);

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;

Line 183: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForResource(l_pub_item,

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);