DBA Data[Home] [Help]

APPS.GMI_ITEM_LOT_CONV_PUB dependencies on SY_UOMS_MST

Line 89: l_sy_uoms_mst_rec_um1 sy_uoms_mst%ROWTYPE;

85: l_ic_lots_mst_rec ic_lots_mst%ROWTYPE;
86: l_item_cnv_rec item_cnv_rec_typ;
87: l_ic_item_cpg_rec ic_item_cpg%ROWTYPE;
88: l_ic_lots_cpg_rec ic_lots_cpg%ROWTYPE;
89: l_sy_uoms_mst_rec_um1 sy_uoms_mst%ROWTYPE;
90: l_sy_uoms_typ_rec_um1 sy_uoms_typ%ROWTYPE;
91: l_sy_uoms_mst_rec_from sy_uoms_mst%ROWTYPE;
92: l_sy_uoms_typ_rec_from sy_uoms_typ%ROWTYPE;
93: l_sy_uoms_mst_rec_to sy_uoms_mst%ROWTYPE;

Line 91: l_sy_uoms_mst_rec_from sy_uoms_mst%ROWTYPE;

87: l_ic_item_cpg_rec ic_item_cpg%ROWTYPE;
88: l_ic_lots_cpg_rec ic_lots_cpg%ROWTYPE;
89: l_sy_uoms_mst_rec_um1 sy_uoms_mst%ROWTYPE;
90: l_sy_uoms_typ_rec_um1 sy_uoms_typ%ROWTYPE;
91: l_sy_uoms_mst_rec_from sy_uoms_mst%ROWTYPE;
92: l_sy_uoms_typ_rec_from sy_uoms_typ%ROWTYPE;
93: l_sy_uoms_mst_rec_to sy_uoms_mst%ROWTYPE;
94: l_sy_uoms_typ_rec_to sy_uoms_typ%ROWTYPE;
95: l_um_type sy_uoms_mst.um_type%TYPE;

Line 93: l_sy_uoms_mst_rec_to sy_uoms_mst%ROWTYPE;

89: l_sy_uoms_mst_rec_um1 sy_uoms_mst%ROWTYPE;
90: l_sy_uoms_typ_rec_um1 sy_uoms_typ%ROWTYPE;
91: l_sy_uoms_mst_rec_from sy_uoms_mst%ROWTYPE;
92: l_sy_uoms_typ_rec_from sy_uoms_typ%ROWTYPE;
93: l_sy_uoms_mst_rec_to sy_uoms_mst%ROWTYPE;
94: l_sy_uoms_typ_rec_to sy_uoms_typ%ROWTYPE;
95: l_um_type sy_uoms_mst.um_type%TYPE;
96: l_from_um sy_uoms_mst.um_code%TYPE;
97: l_to_um sy_uoms_mst.um_code%TYPE;

Line 95: l_um_type sy_uoms_mst.um_type%TYPE;

91: l_sy_uoms_mst_rec_from sy_uoms_mst%ROWTYPE;
92: l_sy_uoms_typ_rec_from sy_uoms_typ%ROWTYPE;
93: l_sy_uoms_mst_rec_to sy_uoms_mst%ROWTYPE;
94: l_sy_uoms_typ_rec_to sy_uoms_typ%ROWTYPE;
95: l_um_type sy_uoms_mst.um_type%TYPE;
96: l_from_um sy_uoms_mst.um_code%TYPE;
97: l_to_um sy_uoms_mst.um_code%TYPE;
98: l_from_std_um sy_uoms_mst.um_code%TYPE;
99: l_to_std_um sy_uoms_mst.um_code%TYPE;

Line 96: l_from_um sy_uoms_mst.um_code%TYPE;

92: l_sy_uoms_typ_rec_from sy_uoms_typ%ROWTYPE;
93: l_sy_uoms_mst_rec_to sy_uoms_mst%ROWTYPE;
94: l_sy_uoms_typ_rec_to sy_uoms_typ%ROWTYPE;
95: l_um_type sy_uoms_mst.um_type%TYPE;
96: l_from_um sy_uoms_mst.um_code%TYPE;
97: l_to_um sy_uoms_mst.um_code%TYPE;
98: l_from_std_um sy_uoms_mst.um_code%TYPE;
99: l_to_std_um sy_uoms_mst.um_code%TYPE;
100: l_user_name fnd_user.user_name%TYPE;

Line 97: l_to_um sy_uoms_mst.um_code%TYPE;

93: l_sy_uoms_mst_rec_to sy_uoms_mst%ROWTYPE;
94: l_sy_uoms_typ_rec_to sy_uoms_typ%ROWTYPE;
95: l_um_type sy_uoms_mst.um_type%TYPE;
96: l_from_um sy_uoms_mst.um_code%TYPE;
97: l_to_um sy_uoms_mst.um_code%TYPE;
98: l_from_std_um sy_uoms_mst.um_code%TYPE;
99: l_to_std_um sy_uoms_mst.um_code%TYPE;
100: l_user_name fnd_user.user_name%TYPE;
101: l_user_id fnd_user.user_id%TYPE;

Line 98: l_from_std_um sy_uoms_mst.um_code%TYPE;

94: l_sy_uoms_typ_rec_to sy_uoms_typ%ROWTYPE;
95: l_um_type sy_uoms_mst.um_type%TYPE;
96: l_from_um sy_uoms_mst.um_code%TYPE;
97: l_to_um sy_uoms_mst.um_code%TYPE;
98: l_from_std_um sy_uoms_mst.um_code%TYPE;
99: l_to_std_um sy_uoms_mst.um_code%TYPE;
100: l_user_name fnd_user.user_name%TYPE;
101: l_user_id fnd_user.user_id%TYPE;
102:

Line 99: l_to_std_um sy_uoms_mst.um_code%TYPE;

95: l_um_type sy_uoms_mst.um_type%TYPE;
96: l_from_um sy_uoms_mst.um_code%TYPE;
97: l_to_um sy_uoms_mst.um_code%TYPE;
98: l_from_std_um sy_uoms_mst.um_code%TYPE;
99: l_to_std_um sy_uoms_mst.um_code%TYPE;
100: l_user_name fnd_user.user_name%TYPE;
101: l_user_id fnd_user.user_id%TYPE;
102:
103: BEGIN

Line 222: , x_sy_uoms_mst => l_sy_uoms_mst_rec_from

218: -- Get UOM details of the from Unit of Measure
219:
220:
221: GMI_GLOBAL_GRP.Get_Um ( p_um_code => l_item_cnv_rec.from_uom
222: , x_sy_uoms_mst => l_sy_uoms_mst_rec_from
223: , x_sy_uoms_typ => l_sy_uoms_typ_rec_from
224: , x_error_code => l_error_code
225: );
226:

Line 250: , x_sy_uoms_mst => l_sy_uoms_mst_rec_to

246:
247: -- Get UOM details of the to Unit of Measure
248:
249: GMI_GLOBAL_GRP.Get_Um ( p_um_code => l_item_cnv_rec.to_uom
250: , x_sy_uoms_mst => l_sy_uoms_mst_rec_to
251: , x_sy_uoms_typ => l_sy_uoms_typ_rec_to
252: , x_error_code => l_error_code
253: );
254:

Line 291: , x_sy_uoms_mst => l_sy_uoms_mst_rec_um1

287: -- Get UOM details of the item primary Unit of Measure
288: -- This should not produce any errors but we'll check for them anyway.
289:
290: GMI_GLOBAL_GRP.Get_Um ( p_um_code => l_ic_item_mst_rec.item_um
291: , x_sy_uoms_mst => l_sy_uoms_mst_rec_um1
292: , x_sy_uoms_typ => l_sy_uoms_typ_rec_um1
293: , x_error_code => l_error_code
294: );
295:

Line 323: l_um_type := l_sy_uoms_mst_rec_to.um_type;

319:
320: IF (l_sy_uoms_typ_rec_um1.std_um = l_sy_uoms_typ_rec_from.std_um)
321: THEN
322: l_factor := 1 / l_item_cnv_rec.type_factor;
323: l_um_type := l_sy_uoms_mst_rec_to.um_type;
324: l_from_um := l_item_cnv_rec.from_uom;
325: l_from_std_um := l_sy_uoms_typ_rec_from.std_um;
326: l_to_um := l_item_cnv_rec.to_uom;
327: l_to_std_um := l_sy_uoms_typ_rec_to.std_um;

Line 331: l_um_type := l_sy_uoms_mst_rec_from.um_type;

327: l_to_std_um := l_sy_uoms_typ_rec_to.std_um;
328: ELSIF (l_sy_uoms_typ_rec_um1.std_um = l_sy_uoms_typ_rec_to.std_um)
329: THEN
330: l_factor := l_item_cnv_rec.type_factor;
331: l_um_type := l_sy_uoms_mst_rec_from.um_type;
332: l_from_um := l_item_cnv_rec.to_uom;
333: l_from_std_um := l_sy_uoms_typ_rec_to.std_um;
334: l_to_um := l_item_cnv_rec.from_uom;
335: l_to_std_um := l_sy_uoms_typ_rec_from.std_um;