APPS.CSM_UOM_EVENT_PKG dependencies on CSM_UNIT_OF_MEASURE_TL_ACC

Line 13: INSERT INTO csm_unit_of_measure_tl_acc (access_id, uom_code, language, created_by, creation_date,

9: l_sysdate DATE;
10: BEGIN
11: l_sysdate := SYSDATE;
12:
13: INSERT INTO csm_unit_of_measure_tl_acc (access_id, uom_code, language, created_by, creation_date,
14: last_updated_by, last_update_date, last_update_login
15: )
16: VALUES (p_access_id, p_uom_code, p_language, fnd_global.user_id, l_sysdate,
17: fnd_global.user_id, l_sysdate, fnd_global.login_id);

Line 60: FROM csm_unit_of_measure_tl_acc acc

56: uom.language
57: FROM mtl_units_of_measure_tl uom
58: WHERE NOT EXISTS
59: (SELECT 1
60: FROM csm_unit_of_measure_tl_acc acc
61: WHERE acc.uom_code = uom.uom_code
62: AND acc.language = uom.language
63: );
64:

Line 72: csm_unit_of_measure_tl_acc acc

68: SELECT acc.access_id,
69: uom.uom_code,
70: uom.language
71: FROM mtl_units_of_measure_tl uom,
72: csm_unit_of_measure_tl_acc acc
73: WHERE acc.uom_code = uom.uom_code
74: AND acc.language = uom.language
75: AND uom.last_update_date > p_last_upd_date;
76:

Line 83: FROM csm_unit_of_measure_tl_acc acc

79: IS
80: SELECT acc.access_id,
81: acc.uom_code,
82: acc.language
83: FROM csm_unit_of_measure_tl_acc acc
84: WHERE NOT EXISTS
85: (SELECT 1
86: FROM mtl_units_of_measure_tl uom
87: WHERE acc.uom_code = uom.uom_code

Line 133: DELETE FROM csm_unit_of_measure_tl_acc WHERE access_id = l_access_id;

129: SYSDATE );
130: END IF;
131:
132: -- delete from acc table
133: DELETE FROM csm_unit_of_measure_tl_acc WHERE access_id = l_access_id;
134: END LOOP;
135:
136: -- process all updates
137: FOR r_uom_upd_rec IN l_uom_upd_csr(l_prog_update_date) LOOP

Line 170: SELECT csm_unit_of_measure_tl_acc_s.nextval

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;
173:
174: --nullify the access list

Line 190: -- insert into csm_unit_of_measure_tl_acc

186: ASG_DOWNLOAD.INS,
187: sysdate);
188: END IF;
189:
190: -- insert into csm_unit_of_measure_tl_acc
191: INSERT_CSM_UOM_TL_ACC (l_access_id, r_uom_ins_rec.uom_code , r_uom_ins_rec.language);
192:
193: END LOOP;
194: