APPS.ITG_SYNCUOMINBOUND_PVT dependencies on MTL_UOM_CONVERSIONS

Line 241: FROM mtl_uom_conversions

237: l_dummy NUMBER;
238: BEGIN
239: SELECT 1
240: INTO l_dummy
241: FROM mtl_uom_conversions
242: WHERE uom_code = p_uom_code
243: AND uom_class = p_uom_class
244: AND inventory_item_id = 0
245: AND conversion_rate = TO_NUMBER(p_conv_rate);

Line 261: FROM mtl_uom_conversions

257: l_conv_rate NUMBER;
258: BEGIN
259: SELECT conversion_rate
260: INTO l_conv_rate
261: FROM mtl_uom_conversions
262: WHERE uom_code = p_uom_code AND inventory_item_id = p_itemid;
263: RETURN l_conv_rate;
264:
265: EXCEPTION

Line 477: p_con_rec IN mtl_uom_conversions%ROWTYPE

473: );
474: END insert_uom_class_conv;
475:
476: PROCEDURE delete_uom_conv(
477: p_con_rec IN mtl_uom_conversions%ROWTYPE
478: ) IS
479: BEGIN
480: g_action := 'UOM-conversion parameter validation';
481: IF p_con_rec.disable_date IS NULL THEN

Line 486: UPDATE mtl_uom_conversions

482: ITG_MSG.null_disable_date;
483: RAISE FND_API.G_EXC_ERROR;
484: END IF;
485: g_action := 'UOM-conversion update';
486: UPDATE mtl_uom_conversions
487: SET disable_date = p_con_rec.disable_date,
488: last_update_date = p_con_rec.last_update_date,
489: last_updated_by = p_con_rec.last_updated_by
490: WHERE unit_of_measure = p_con_rec.unit_of_measure

Line 501: p_con_rec IN mtl_uom_conversions%ROWTYPE

497: END IF;
498: END delete_uom_conv;
499:
500: PROCEDURE update_uom_conv(
501: p_con_rec IN mtl_uom_conversions%ROWTYPE
502: ) IS
503: BEGIN
504: g_action := 'UOM-conversion update';
505: UPDATE mtl_uom_conversions

Line 505: UPDATE mtl_uom_conversions

501: p_con_rec IN mtl_uom_conversions%ROWTYPE
502: ) IS
503: BEGIN
504: g_action := 'UOM-conversion update';
505: UPDATE mtl_uom_conversions
506: SET conversion_rate = p_con_rec.conversion_rate,
507: disable_date = p_con_rec.disable_date,
508: last_update_date = p_con_rec.last_update_date,
509: last_updated_by = p_con_rec.last_updated_by

Line 521: p_con_rec IN mtl_uom_conversions%ROWTYPE

517: END IF;
518: END update_uom_conv;
519:
520: PROCEDURE insert_uom_conv(
521: p_con_rec IN mtl_uom_conversions%ROWTYPE
522: ) IS
523: l_flag_count NUMBER;
524: l_count NUMBER;
525: BEGIN

Line 536: from mtl_uom_conversions

532:
533:
534: select count(*)
535: into l_count
536: from mtl_uom_conversions
537: where inventory_item_id = p_con_rec.inventory_item_id
538: and ( unit_of_measure = p_con_rec.unit_of_measure
539: OR uom_code = p_con_rec.uom_code );
540:

Line 552: FROM mtl_uom_conversions

548: /* Check for multiple flags */
549: IF p_con_rec.default_conversion_flag = 'Y' THEN
550: SELECT COUNT(*)
551: INTO l_flag_count
552: FROM mtl_uom_conversions
553: WHERE default_conversion_flag = 'Y'
554: AND uom_class = p_con_rec.uom_class;
555: IF l_flag_count > 1 THEN
556: ITG_MSG.toomany_default_conv_flag;

Line 563: INSERT INTO mtl_uom_conversions (

559: END IF;
560:
561: g_action := 'UOM-conversion insert';
562:
563: INSERT INTO mtl_uom_conversions (
564: unit_of_measure,
565: uom_code,
566: uom_class,
567: inventory_item_id,

Line 608: l_con_rec mtl_uom_conversions%ROWTYPE;

604: ) IS
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

Line 918: l_con_rec mtl_uom_conversions%ROWTYPE;

914: p_dt_creation IN DATE,
915: p_dt_expiration IN DATE
916: ) IS
917: /* Working storage */
918: l_con_rec mtl_uom_conversions%ROWTYPE;
919: l_base_flag mtl_units_of_measure.base_uom_flag%TYPE;
920:
921: /* Default the value of uom_class */
922: CURSOR l_def_cls_csr IS