APPS.MSD_COMMON_UTILITIES dependencies on STANDARD

Line 575: CURSOR standard_conversions IS

571:
572: from_class varchar2(10);
573: to_class varchar2(10);
574:
575: CURSOR standard_conversions IS
576: select t.conversion_rate std_to_rate,
577: t.uom_class std_to_class,
578: f.conversion_rate std_from_rate,
579: f.uom_class std_from_class

Line 591: std_rec standard_conversions%rowtype;

587: nvl(f.disable_date, trunc(sysdate) + 1) > trunc(sysdate)
588: order by t.inventory_item_id desc, f.inventory_item_id desc;
589:
590:
591: std_rec standard_conversions%rowtype;
592:
593:
594: CURSOR interclass_conversions(p_from_class VARCHAR2, p_to_class VARCHAR2) IS
595: select decode(from_uom_class, p_from_class, 1, 2) from_flag,

Line 637: ** standard conversion, which is defined for all items, is used.

633: **
634: ** 1. The conversion always starts from the conversion defined, if exists,
635: ** for an specified item.
636: ** 2. If the conversion id not defined for that specific item, then the
637: ** standard conversion, which is defined for all items, is used.
638: ** 3. When the conversion involves two different classes, then
639: ** interclass conversion is activated.
640: */
641:

Line 651: /* Get item specific or standard conversions */

647: goto procedure_end;
648: end if;
649:
650:
651: /* Get item specific or standard conversions */
652: open standard_conversions;
653: std_index := 0;
654: loop
655:

Line 652: open standard_conversions;

648: end if;
649:
650:
651: /* Get item specific or standard conversions */
652: open standard_conversions;
653: std_index := 0;
654: loop
655:
656: std_index := std_index + 1;

Line 658: fetch standard_conversions into std_rec;

654: loop
655:
656: std_index := std_index + 1;
657:
658: fetch standard_conversions into std_rec;
659: exit when standard_conversions%notfound;
660:
661: from_rate_tab(std_index) := std_rec.std_from_rate;
662: from_class_tab(std_index) := std_rec.std_from_class;

Line 659: exit when standard_conversions%notfound;

655:
656: std_index := std_index + 1;
657:
658: fetch standard_conversions into std_rec;
659: exit when standard_conversions%notfound;
660:
661: from_rate_tab(std_index) := std_rec.std_from_rate;
662: from_class_tab(std_index) := std_rec.std_from_class;
663: to_rate_tab(std_index) := std_rec.std_to_rate;

Line 668: close standard_conversions;

664: to_class_tab(std_index) := std_rec.std_to_class;
665:
666: end loop;
667:
668: close standard_conversions;
669:
670: if (std_index = 0) then /* No conversions defined */
671: msgbuf := msgbuf||'Invalid standard conversion : ';
672: msgbuf := msgbuf||'From UOM code: '||from_unit||' ';

Line 671: msgbuf := msgbuf||'Invalid standard conversion : ';

667:
668: close standard_conversions;
669:
670: if (std_index = 0) then /* No conversions defined */
671: msgbuf := msgbuf||'Invalid standard conversion : ';
672: msgbuf := msgbuf||'From UOM code: '||from_unit||' ';
673: msgbuf := msgbuf||'To UOM code: '||to_unit||' ';
674: raise invalid_conversion;
675:

Line 726: ** so seperate calculations are not required for standard/interclass

722: end if; /* End of from_class <> to_class */
723:
724: /*
725: ** conversion rates are defaulted to '1' at the start of the procedure
726: ** so seperate calculations are not required for standard/interclass
727: ** conversions
728: */
729:
730: if (to_rate <> 0 ) then