APPS.MSD_DEM_COLLECT_UOMS dependencies on MSD_DEM_COLLECT_UOMS

Line 1: PACKAGE BODY MSD_DEM_COLLECT_UOMS AS

1: PACKAGE BODY MSD_DEM_COLLECT_UOMS AS
2: /* $Header: msddemuomclb.pls 120.3.12000000.2 2007/09/24 11:44:24 nallkuma noship $ */
3:
4: function get_lookup_value(p_lookup_type IN VARCHAR2,
5: p_lookup_code IN VARCHAR2)

Line 271: ' select msd_dem_collect_uoms.msd_dem_uom_conversion(msc.uom_code, ''' || p_uom_code || ''', msc.sr_inventory_item_id)' ||

267: l_stmt := 'update ' || l_table_name || ' tei ';
268: end if;
269:
270: l_stmt := l_stmt || ' set ' || l_column_name || ' = ( ' ||
271: ' select msd_dem_collect_uoms.msd_dem_uom_conversion(msc.uom_code, ''' || p_uom_code || ''', msc.sr_inventory_item_id)' ||
272: ' from msc_system_items msc' ||
273: ' where plan_id = -1 ' ||
274: ' and sr_instance_id = :1 ' ||
275: ' and tei.ebs_item_dest_key = msc.inventory_item_id ' ||

Line 695: END MSD_DEM_COLLECT_UOMS;

691:
692:
693: end;
694:
695: END MSD_DEM_COLLECT_UOMS;
696: