APPS.ITG_SYNCUOMINBOUND_PVT dependencies on MTL_UOM_CLASS_CONVERSIONS

Line 373: p_ccv_rec IN mtl_uom_class_conversions%ROWTYPE

369: AND t.language = l.language_code);
370: END insert_uom_class;
371:
372: PROCEDURE delete_uom_class_conv(
373: p_ccv_rec IN mtl_uom_class_conversions%ROWTYPE
374: ) IS
375: BEGIN
376: g_action := 'UOMClass-conversion parameter validation';
377: IF p_ccv_rec.disable_date IS NULL THEN

Line 383: UPDATE mtl_uom_class_conversions

379: RAISE FND_API.G_EXC_ERROR;
380: END IF;
381:
382: g_action := 'UOMClassConversion delete';
383: UPDATE mtl_uom_class_conversions
384: SET disable_date = p_ccv_rec.disable_date,
385: last_update_date = p_ccv_rec.last_update_date,
386: last_updated_by = p_ccv_rec.last_updated_by
387: WHERE from_unit_of_measure = p_ccv_rec.from_unit_of_measure

Line 401: p_ccv_rec IN mtl_uom_class_conversions%ROWTYPE

397: END IF;
398: END delete_uom_class_conv;
399:
400: PROCEDURE update_uom_class_conv(
401: p_ccv_rec IN mtl_uom_class_conversions%ROWTYPE
402: ) IS
403: BEGIN
404: g_action := 'UOMClassConversion update';
405: UPDATE mtl_uom_class_conversions

Line 405: UPDATE mtl_uom_class_conversions

401: p_ccv_rec IN mtl_uom_class_conversions%ROWTYPE
402: ) IS
403: BEGIN
404: g_action := 'UOMClassConversion update';
405: UPDATE mtl_uom_class_conversions
406: SET conversion_rate = p_ccv_rec.conversion_rate,
407: disable_date = p_ccv_rec.disable_date,
408: last_update_date = p_ccv_rec.last_update_date,
409: last_updated_by = p_ccv_rec.last_updated_by

Line 425: p_ccv_rec IN mtl_uom_class_conversions%ROWTYPE

421: END update_uom_class_conv;
422:
423:
424: PROCEDURE insert_uom_class_conv(
425: p_ccv_rec IN mtl_uom_class_conversions%ROWTYPE
426: ) IS
427: l_count NUMBER;
428: BEGIN
429: g_action := 'UOMClass-conv insert';

Line 434: FROM mtl_uom_class_conversions

430: l_count := 0;
431:
432: SELECT count(*)
433: INTO l_count
434: FROM mtl_uom_class_conversions
435: WHERE inventory_item_id = p_ccv_rec.inventory_item_id AND
436: ( to_uom_code = p_ccv_rec.to_uom_code OR
437: to_uom_class = p_ccv_rec.to_uom_class OR
438: to_unit_of_measure = p_ccv_rec.to_unit_of_measure );

Line 445: INSERT INTO mtl_uom_class_conversions (

441: itg_msg.dup_uomclass_conv;
442: RAISE FND_API.G_EXC_ERROR;
443: END IF;
444:
445: INSERT INTO mtl_uom_class_conversions (
446: from_unit_of_measure,
447: from_uom_code,
448: from_uom_class,
449: to_unit_of_measure,

Line 609: l_ccv_rec mtl_uom_class_conversions%ROWTYPE;

605: /* Working storage */
606: l_cls_rec mtl_uom_classes%ROWTYPE;
607: l_uom_rec mtl_units_of_measure%ROWTYPE;
608: l_con_rec mtl_uom_conversions%ROWTYPE;
609: l_ccv_rec mtl_uom_class_conversions%ROWTYPE;
610: l_param VARCHAR2(200);
611: l_value VARCHAR2(200);
612: BEGIN
613:

Line 828: l_ccv_rec mtl_uom_class_conversions%ROWTYPE;

824: p_conv_rate IN VARCHAR2,
825: p_dt_creation IN DATE,
826: p_dt_expiration IN DATE
827: ) IS
828: l_ccv_rec mtl_uom_class_conversions%ROWTYPE;
829: l_dummy mtl_units_of_measure.base_uom_flag%TYPE;
830:
831: /* Get uom and default the value of uom_class. */
832: CURSOR l_uom_csr(l_uom_code VARCHAR2) IS