APPS.MSD_DEM_COMMON_UTILITIES dependencies on STANDARD

Line 16: CURSOR standard_conversions IS

12:
13: from_class varchar2(10);
14: to_class varchar2(10);
15:
16: CURSOR standard_conversions IS
17: select t.conversion_rate std_to_rate,
18: t.uom_class std_to_class,
19: f.conversion_rate std_from_rate,
20: f.uom_class std_from_class

Line 32: std_rec standard_conversions%rowtype;

28: nvl(f.disable_date, trunc(sysdate) + 1) > trunc(sysdate)
29: order by t.inventory_item_id desc, f.inventory_item_id desc;
30:
31:
32: std_rec standard_conversions%rowtype;
33:
34:
35: CURSOR interclass_conversions(p_from_class VARCHAR2, p_to_class VARCHAR2) IS
36: select decode(from_uom_class, p_from_class, 1, 2) from_flag,

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

74: **
75: ** 1. The conversion always starts from the conversion defined, if exists,
76: ** for an specified item.
77: ** 2. If the conversion id not defined for that specific item, then the
78: ** standard conversion, which is defined for all items, is used.
79: ** 3. When the conversion involves two different classes, then
80: ** interclass conversion is activated.
81: */
82:

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

88: goto procedure_end;
89: end if;
90:
91:
92: /* Get item specific or standard conversions */
93: open standard_conversions;
94: std_index := 0;
95: loop
96:

Line 93: open standard_conversions;

89: end if;
90:
91:
92: /* Get item specific or standard conversions */
93: open standard_conversions;
94: std_index := 0;
95: loop
96:
97: std_index := std_index + 1;

Line 99: fetch standard_conversions into std_rec;

95: loop
96:
97: std_index := std_index + 1;
98:
99: fetch standard_conversions into std_rec;
100: exit when standard_conversions%notfound;
101:
102: from_rate_tab(std_index) := std_rec.std_from_rate;
103: from_class_tab(std_index) := std_rec.std_from_class;

Line 100: exit when standard_conversions%notfound;

96:
97: std_index := std_index + 1;
98:
99: fetch standard_conversions into std_rec;
100: exit when standard_conversions%notfound;
101:
102: from_rate_tab(std_index) := std_rec.std_from_rate;
103: from_class_tab(std_index) := std_rec.std_from_class;
104: to_rate_tab(std_index) := std_rec.std_to_rate;

Line 109: close standard_conversions;

105: to_class_tab(std_index) := std_rec.std_to_class;
106:
107: end loop;
108:
109: close standard_conversions;
110:
111: if (std_index = 0) then /* No conversions defined */
112: msgbuf := msgbuf||'Invalid standard conversion : ';
113: msgbuf := msgbuf||'From UOM code: '||from_unit||' ';

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

108:
109: close standard_conversions;
110:
111: if (std_index = 0) then /* No conversions defined */
112: msgbuf := msgbuf||'Invalid standard conversion : ';
113: msgbuf := msgbuf||'From UOM code: '||from_unit||' ';
114: msgbuf := msgbuf||'To UOM code: '||to_unit||' ';
115: raise invalid_conversion;
116:

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

163: end if; /* End of from_class <> to_class */
164:
165: /*
166: ** conversion rates are defaulted to '1' at the start of the procedure
167: ** so seperate calculations are not required for standard/interclass
168: ** conversions
169: */
170:
171: if (to_rate <> 0 ) then