1: PACKAGE BODY CSM_UOM_EVENT_PKG AS
2: /* $Header: csmeuomb.pls 120.2 2006/04/06 05:19:34 trajasek noship $ */
3:
4: PROCEDURE INSERT_CSM_UOM_TL_ACC (p_access_id IN number,
5: p_uom_code mtl_units_of_measure_tl.uom_code%TYPE,
6: p_language mtl_units_of_measure_tl.language%TYPE
7: )
8: IS
9: l_sysdate DATE;
2: /* $Header: csmeuomb.pls 120.2 2006/04/06 05:19:34 trajasek noship $ */
3:
4: PROCEDURE INSERT_CSM_UOM_TL_ACC (p_access_id IN number,
5: p_uom_code mtl_units_of_measure_tl.uom_code%TYPE,
6: p_language mtl_units_of_measure_tl.language%TYPE
7: )
8: IS
9: l_sysdate DATE;
10: BEGIN
53: CURSOR l_uom_ins_csr
54: IS
55: SELECT uom.uom_code,
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
67: IS
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;
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
88: AND acc.language = uom.language
89: );
90: