83: IS
84: l_api_name CONSTANT VARCHAR2 (30) :='Validate Conversion';
85: l_factor NUMBER;
86: l_type_factorrev NUMBER;
87: l_from_type sy_uoms_mst.um_code%TYPE;
88: l_from_std sy_uoms_mst.um_code%TYPE;
89: l_to_type sy_uoms_mst.um_code%TYPE;
90: l_to_std sy_uoms_mst.um_code%TYPE;
91: l_item_type sy_uoms_mst.um_code%TYPE;
84: l_api_name CONSTANT VARCHAR2 (30) :='Validate Conversion';
85: l_factor NUMBER;
86: l_type_factorrev NUMBER;
87: l_from_type sy_uoms_mst.um_code%TYPE;
88: l_from_std sy_uoms_mst.um_code%TYPE;
89: l_to_type sy_uoms_mst.um_code%TYPE;
90: l_to_std sy_uoms_mst.um_code%TYPE;
91: l_item_type sy_uoms_mst.um_code%TYPE;
92: l_item_std sy_uoms_mst.um_code%TYPE;
85: l_factor NUMBER;
86: l_type_factorrev NUMBER;
87: l_from_type sy_uoms_mst.um_code%TYPE;
88: l_from_std sy_uoms_mst.um_code%TYPE;
89: l_to_type sy_uoms_mst.um_code%TYPE;
90: l_to_std sy_uoms_mst.um_code%TYPE;
91: l_item_type sy_uoms_mst.um_code%TYPE;
92: l_item_std sy_uoms_mst.um_code%TYPE;
93: l_rec_from_um sy_uoms_mst.um_code%TYPE;
86: l_type_factorrev NUMBER;
87: l_from_type sy_uoms_mst.um_code%TYPE;
88: l_from_std sy_uoms_mst.um_code%TYPE;
89: l_to_type sy_uoms_mst.um_code%TYPE;
90: l_to_std sy_uoms_mst.um_code%TYPE;
91: l_item_type sy_uoms_mst.um_code%TYPE;
92: l_item_std sy_uoms_mst.um_code%TYPE;
93: l_rec_from_um sy_uoms_mst.um_code%TYPE;
94: l_rec_to_um sy_uoms_mst.um_code%TYPE;
87: l_from_type sy_uoms_mst.um_code%TYPE;
88: l_from_std sy_uoms_mst.um_code%TYPE;
89: l_to_type sy_uoms_mst.um_code%TYPE;
90: l_to_std sy_uoms_mst.um_code%TYPE;
91: l_item_type sy_uoms_mst.um_code%TYPE;
92: l_item_std sy_uoms_mst.um_code%TYPE;
93: l_rec_from_um sy_uoms_mst.um_code%TYPE;
94: l_rec_to_um sy_uoms_mst.um_code%TYPE;
95:
88: l_from_std sy_uoms_mst.um_code%TYPE;
89: l_to_type sy_uoms_mst.um_code%TYPE;
90: l_to_std sy_uoms_mst.um_code%TYPE;
91: l_item_type sy_uoms_mst.um_code%TYPE;
92: l_item_std sy_uoms_mst.um_code%TYPE;
93: l_rec_from_um sy_uoms_mst.um_code%TYPE;
94: l_rec_to_um sy_uoms_mst.um_code%TYPE;
95:
96: l_um_type sy_uoms_mst.um_type%TYPE;
89: l_to_type sy_uoms_mst.um_code%TYPE;
90: l_to_std sy_uoms_mst.um_code%TYPE;
91: l_item_type sy_uoms_mst.um_code%TYPE;
92: l_item_std sy_uoms_mst.um_code%TYPE;
93: l_rec_from_um sy_uoms_mst.um_code%TYPE;
94: l_rec_to_um sy_uoms_mst.um_code%TYPE;
95:
96: l_um_type sy_uoms_mst.um_type%TYPE;
97: l_from_um sy_uoms_mst.um_code%TYPE;
90: l_to_std sy_uoms_mst.um_code%TYPE;
91: l_item_type sy_uoms_mst.um_code%TYPE;
92: l_item_std sy_uoms_mst.um_code%TYPE;
93: l_rec_from_um sy_uoms_mst.um_code%TYPE;
94: l_rec_to_um sy_uoms_mst.um_code%TYPE;
95:
96: l_um_type sy_uoms_mst.um_type%TYPE;
97: l_from_um sy_uoms_mst.um_code%TYPE;
98: l_to_um sy_uoms_mst.um_code%TYPE;
92: l_item_std sy_uoms_mst.um_code%TYPE;
93: l_rec_from_um sy_uoms_mst.um_code%TYPE;
94: l_rec_to_um sy_uoms_mst.um_code%TYPE;
95:
96: l_um_type sy_uoms_mst.um_type%TYPE;
97: l_from_um sy_uoms_mst.um_code%TYPE;
98: l_to_um sy_uoms_mst.um_code%TYPE;
99: l_from_std_um sy_uoms_mst.um_code%TYPE;
100: l_to_std_um sy_uoms_mst.um_code%TYPE;
93: l_rec_from_um sy_uoms_mst.um_code%TYPE;
94: l_rec_to_um sy_uoms_mst.um_code%TYPE;
95:
96: l_um_type sy_uoms_mst.um_type%TYPE;
97: l_from_um sy_uoms_mst.um_code%TYPE;
98: l_to_um sy_uoms_mst.um_code%TYPE;
99: l_from_std_um sy_uoms_mst.um_code%TYPE;
100: l_to_std_um sy_uoms_mst.um_code%TYPE;
101: l_count NUMBER;
94: l_rec_to_um sy_uoms_mst.um_code%TYPE;
95:
96: l_um_type sy_uoms_mst.um_type%TYPE;
97: l_from_um sy_uoms_mst.um_code%TYPE;
98: l_to_um sy_uoms_mst.um_code%TYPE;
99: l_from_std_um sy_uoms_mst.um_code%TYPE;
100: l_to_std_um sy_uoms_mst.um_code%TYPE;
101: l_count NUMBER;
102:
95:
96: l_um_type sy_uoms_mst.um_type%TYPE;
97: l_from_um sy_uoms_mst.um_code%TYPE;
98: l_to_um sy_uoms_mst.um_code%TYPE;
99: l_from_std_um sy_uoms_mst.um_code%TYPE;
100: l_to_std_um sy_uoms_mst.um_code%TYPE;
101: l_count NUMBER;
102:
103:
96: l_um_type sy_uoms_mst.um_type%TYPE;
97: l_from_um sy_uoms_mst.um_code%TYPE;
98: l_to_um sy_uoms_mst.um_code%TYPE;
99: l_from_std_um sy_uoms_mst.um_code%TYPE;
100: l_to_std_um sy_uoms_mst.um_code%TYPE;
101: l_count NUMBER;
102:
103:
104: /* Bug#2880585 - New cursors for insert checks */
224: INTO l_from_type, l_from_std, l_to_type, l_to_std,
225: l_item_type, l_item_std
226: FROM
227: sy_uoms_typ from_type,
228: sy_uoms_mst from_std,
229: sy_uoms_typ to_type,
230: sy_uoms_mst to_std,
231: sy_uoms_typ item_type,
232: sy_uoms_mst item_std
226: FROM
227: sy_uoms_typ from_type,
228: sy_uoms_mst from_std,
229: sy_uoms_typ to_type,
230: sy_uoms_mst to_std,
231: sy_uoms_typ item_type,
232: sy_uoms_mst item_std
233: WHERE
234: from_type.um_type=from_std.um_type AND
228: sy_uoms_mst from_std,
229: sy_uoms_typ to_type,
230: sy_uoms_mst to_std,
231: sy_uoms_typ item_type,
232: sy_uoms_mst item_std
233: WHERE
234: from_type.um_type=from_std.um_type AND
235: from_std.um_code=l_rec_from_um AND
236: from_type.delete_mark=0 AND