DBA Data[Home] [Help]

APPS.GMIVILC dependencies on SY_UOMS_MST

Line 87: l_from_type sy_uoms_mst.um_code%TYPE;

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;

Line 88: l_from_std 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;

Line 89: l_to_type 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;

Line 90: l_to_std 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;

Line 91: l_item_type 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:

Line 92: l_item_std 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:
96: l_um_type sy_uoms_mst.um_type%TYPE;

Line 93: l_rec_from_um 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;
97: l_from_um sy_uoms_mst.um_code%TYPE;

Line 94: l_rec_to_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;

Line 96: l_um_type sy_uoms_mst.um_type%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;

Line 97: l_from_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;

Line 98: l_to_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;
102:

Line 99: l_from_std_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:
103:

Line 100: l_to_std_um sy_uoms_mst.um_code%TYPE;

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 */

Line 228: sy_uoms_mst from_std,

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

Line 230: sy_uoms_mst to_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

Line 232: sy_uoms_mst item_std

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