APPS.POA_EDW_UTIL dependencies on STANDARD

Line 24: cursor standard_conversions is

20: from_class varchar2(10);
21: to_class varchar2(10);
22:
23:
24: cursor standard_conversions is
25: select t.conversion_rate std_to_rate,
26: t.uom_class std_to_class,
27: f.conversion_rate std_from_rate,
28: f.uom_class std_from_class

Line 40: std_rec standard_conversions%rowtype;

36: and nvl(f.disable_date, trunc(sysdate) + 1) > trunc(sysdate)
37: order by t.inventory_item_id desc,
38: f.inventory_item_id desc;
39:
40: std_rec standard_conversions%rowtype;
41:
42:
43: cursor interclass_conversions is
44: select decode(to_uom_class, to_class, 1, 2) to_flag,

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

85: **
86: ** 1. The conversion always starts from the conversion defined, if exists,
87: ** for an specified item.
88: ** 2. If the conversion id not defined for that specific item, then the
89: ** standard conversion, which is defined for all items, is used.
90: ** 3. When the conversion involves two different classes, then
91: ** interclass conversion is activated.
92: */
93:

Line 108: ** Get item specific or standard conversions

104:
105: end if;
106:
107: /*
108: ** Get item specific or standard conversions
109: */
110:
111: open standard_conversions;
112:

Line 111: open standard_conversions;

107: /*
108: ** Get item specific or standard conversions
109: */
110:
111: open standard_conversions;
112:
113: std_index := 0;
114:
115: loop

Line 117: fetch standard_conversions into std_rec;

113: std_index := 0;
114:
115: loop
116:
117: fetch standard_conversions into std_rec;
118: exit when standard_conversions%notfound;
119:
120: std_index := std_index + 1;
121:

Line 118: exit when standard_conversions%notfound;

114:
115: loop
116:
117: fetch standard_conversions into std_rec;
118: exit when standard_conversions%notfound;
119:
120: std_index := std_index + 1;
121:
122: from_rate_tab(std_index) := std_rec.std_from_rate;

Line 129: close standard_conversions;

125: to_class_tab(std_index) := std_rec.std_to_class;
126:
127: end loop;
128:
129: close standard_conversions;
130:
131: /*
132: **
133: */

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

137: /*
138: ** No conversions defined
139: */
140:
141: msgbuf := msgbuf||'Invalid standard conversion : ';
142: msgbuf := msgbuf||'From UOM code: '||from_uom_code||' ';
143: msgbuf := msgbuf||'To UOM code: '||to_uom_code||' ';
144: raise invalid_conversion;
145:

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

234: end if;
235:
236: /*
237: ** conversion rates are defaulted to '1' at the start of the procedure
238: ** so seperate calculations are not required for standard/interclass
239: ** conversions
240: */
241:
242: uom_rate := (from_rate * interclass_rate) / to_rate;