eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_TROLIN_UTIL dependencies on INV_TROLIN_UTIL

Line 1: PACKAGE BODY inv_trolin_util AS

1: PACKAGE BODY inv_trolin_util AS
2: /* $Header: INVUTRLB.pls 120.4.12020000.2 2012/12/07 05:54:17 alxue ship $ */
3:
4: -- Global constant holding the package name
5:

Line 6: g_pkg_name CONSTANT VARCHAR2(30) := 'INV_Trolin_Util';

2: /* $Header: INVUTRLB.pls 120.4.12020000.2 2012/12/07 05:54:17 alxue ship $ */
3:
4: -- Global constant holding the package name
5:
6: g_pkg_name CONSTANT VARCHAR2(30) := 'INV_Trolin_Util';
7:
8: -- Procedure Clear_Dependent_Attr
9:
10: PROCEDURE clear_dependent_attr(

Line 30: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute1;

26:
27: IF p_attr_id = fnd_api.g_miss_num THEN
28: IF NOT inv_globals.equal(p_trolin_rec.attribute1, p_old_trolin_rec.attribute1) THEN
29: l_index := l_index + 1;
30: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute1;
31: END IF;
32:
33: IF NOT inv_globals.equal(p_trolin_rec.attribute10, p_old_trolin_rec.attribute10) THEN
34: l_index := l_index + 1;

Line 35: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute10;

31: END IF;
32:
33: IF NOT inv_globals.equal(p_trolin_rec.attribute10, p_old_trolin_rec.attribute10) THEN
34: l_index := l_index + 1;
35: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute10;
36: END IF;
37:
38: IF NOT inv_globals.equal(p_trolin_rec.attribute11, p_old_trolin_rec.attribute11) THEN
39: l_index := l_index + 1;

Line 40: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute11;

36: END IF;
37:
38: IF NOT inv_globals.equal(p_trolin_rec.attribute11, p_old_trolin_rec.attribute11) THEN
39: l_index := l_index + 1;
40: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute11;
41: END IF;
42:
43: IF NOT inv_globals.equal(p_trolin_rec.attribute12, p_old_trolin_rec.attribute12) THEN
44: l_index := l_index + 1;

Line 45: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute12;

41: END IF;
42:
43: IF NOT inv_globals.equal(p_trolin_rec.attribute12, p_old_trolin_rec.attribute12) THEN
44: l_index := l_index + 1;
45: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute12;
46: END IF;
47:
48: IF NOT inv_globals.equal(p_trolin_rec.attribute13, p_old_trolin_rec.attribute13) THEN
49: l_index := l_index + 1;

Line 50: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute13;

46: END IF;
47:
48: IF NOT inv_globals.equal(p_trolin_rec.attribute13, p_old_trolin_rec.attribute13) THEN
49: l_index := l_index + 1;
50: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute13;
51: END IF;
52:
53: IF NOT inv_globals.equal(p_trolin_rec.attribute14, p_old_trolin_rec.attribute14) THEN
54: l_index := l_index + 1;

Line 55: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute14;

51: END IF;
52:
53: IF NOT inv_globals.equal(p_trolin_rec.attribute14, p_old_trolin_rec.attribute14) THEN
54: l_index := l_index + 1;
55: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute14;
56: END IF;
57:
58: IF NOT inv_globals.equal(p_trolin_rec.attribute15, p_old_trolin_rec.attribute15) THEN
59: l_index := l_index + 1;

Line 60: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute15;

56: END IF;
57:
58: IF NOT inv_globals.equal(p_trolin_rec.attribute15, p_old_trolin_rec.attribute15) THEN
59: l_index := l_index + 1;
60: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute15;
61: END IF;
62:
63: IF NOT inv_globals.equal(p_trolin_rec.attribute2, p_old_trolin_rec.attribute2) THEN
64: l_index := l_index + 1;

Line 65: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute2;

61: END IF;
62:
63: IF NOT inv_globals.equal(p_trolin_rec.attribute2, p_old_trolin_rec.attribute2) THEN
64: l_index := l_index + 1;
65: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute2;
66: END IF;
67:
68: IF NOT inv_globals.equal(p_trolin_rec.attribute3, p_old_trolin_rec.attribute3) THEN
69: l_index := l_index + 1;

Line 70: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute3;

66: END IF;
67:
68: IF NOT inv_globals.equal(p_trolin_rec.attribute3, p_old_trolin_rec.attribute3) THEN
69: l_index := l_index + 1;
70: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute3;
71: END IF;
72:
73: IF NOT inv_globals.equal(p_trolin_rec.attribute4, p_old_trolin_rec.attribute4) THEN
74: l_index := l_index + 1;

Line 75: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute4;

71: END IF;
72:
73: IF NOT inv_globals.equal(p_trolin_rec.attribute4, p_old_trolin_rec.attribute4) THEN
74: l_index := l_index + 1;
75: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute4;
76: END IF;
77:
78: IF NOT inv_globals.equal(p_trolin_rec.attribute5, p_old_trolin_rec.attribute5) THEN
79: l_index := l_index + 1;

Line 80: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute5;

76: END IF;
77:
78: IF NOT inv_globals.equal(p_trolin_rec.attribute5, p_old_trolin_rec.attribute5) THEN
79: l_index := l_index + 1;
80: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute5;
81: END IF;
82:
83: IF NOT inv_globals.equal(p_trolin_rec.attribute6, p_old_trolin_rec.attribute6) THEN
84: l_index := l_index + 1;

Line 85: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute6;

81: END IF;
82:
83: IF NOT inv_globals.equal(p_trolin_rec.attribute6, p_old_trolin_rec.attribute6) THEN
84: l_index := l_index + 1;
85: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute6;
86: END IF;
87:
88: IF NOT inv_globals.equal(p_trolin_rec.attribute7, p_old_trolin_rec.attribute7) THEN
89: l_index := l_index + 1;

Line 90: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute7;

86: END IF;
87:
88: IF NOT inv_globals.equal(p_trolin_rec.attribute7, p_old_trolin_rec.attribute7) THEN
89: l_index := l_index + 1;
90: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute7;
91: END IF;
92:
93: IF NOT inv_globals.equal(p_trolin_rec.attribute8, p_old_trolin_rec.attribute8) THEN
94: l_index := l_index + 1;

Line 95: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute8;

91: END IF;
92:
93: IF NOT inv_globals.equal(p_trolin_rec.attribute8, p_old_trolin_rec.attribute8) THEN
94: l_index := l_index + 1;
95: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute8;
96: END IF;
97:
98: IF NOT inv_globals.equal(p_trolin_rec.attribute9, p_old_trolin_rec.attribute9) THEN
99: l_index := l_index + 1;

Line 100: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute9;

96: END IF;
97:
98: IF NOT inv_globals.equal(p_trolin_rec.attribute9, p_old_trolin_rec.attribute9) THEN
99: l_index := l_index + 1;
100: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute9;
101: END IF;
102:
103: IF NOT inv_globals.equal(p_trolin_rec.attribute_category, p_old_trolin_rec.attribute_category) THEN
104: l_index := l_index + 1;

Line 105: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute_category;

101: END IF;
102:
103: IF NOT inv_globals.equal(p_trolin_rec.attribute_category, p_old_trolin_rec.attribute_category) THEN
104: l_index := l_index + 1;
105: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute_category;
106: END IF;
107:
108: IF NOT inv_globals.equal(p_trolin_rec.created_by, p_old_trolin_rec.created_by) THEN
109: l_index := l_index + 1;

Line 110: l_src_attr_tbl(l_index) := inv_trolin_util.g_created_by;

106: END IF;
107:
108: IF NOT inv_globals.equal(p_trolin_rec.created_by, p_old_trolin_rec.created_by) THEN
109: l_index := l_index + 1;
110: l_src_attr_tbl(l_index) := inv_trolin_util.g_created_by;
111: END IF;
112:
113: IF NOT inv_globals.equal(p_trolin_rec.creation_date, p_old_trolin_rec.creation_date) THEN
114: l_index := l_index + 1;

Line 115: l_src_attr_tbl(l_index) := inv_trolin_util.g_creation_date;

111: END IF;
112:
113: IF NOT inv_globals.equal(p_trolin_rec.creation_date, p_old_trolin_rec.creation_date) THEN
114: l_index := l_index + 1;
115: l_src_attr_tbl(l_index) := inv_trolin_util.g_creation_date;
116: END IF;
117:
118: IF NOT inv_globals.equal(p_trolin_rec.date_required, p_old_trolin_rec.date_required) THEN
119: l_index := l_index + 1;

Line 120: l_src_attr_tbl(l_index) := inv_trolin_util.g_date_required;

116: END IF;
117:
118: IF NOT inv_globals.equal(p_trolin_rec.date_required, p_old_trolin_rec.date_required) THEN
119: l_index := l_index + 1;
120: l_src_attr_tbl(l_index) := inv_trolin_util.g_date_required;
121: END IF;
122:
123: IF NOT inv_globals.equal(p_trolin_rec.from_locator_id, p_old_trolin_rec.from_locator_id) THEN
124: l_index := l_index + 1;

Line 125: l_src_attr_tbl(l_index) := inv_trolin_util.g_from_locator;

121: END IF;
122:
123: IF NOT inv_globals.equal(p_trolin_rec.from_locator_id, p_old_trolin_rec.from_locator_id) THEN
124: l_index := l_index + 1;
125: l_src_attr_tbl(l_index) := inv_trolin_util.g_from_locator;
126: END IF;
127:
128: IF NOT inv_globals.equal(p_trolin_rec.from_subinventory_code, p_old_trolin_rec.from_subinventory_code) THEN
129: l_index := l_index + 1;

Line 130: l_src_attr_tbl(l_index) := inv_trolin_util.g_from_subinventory;

126: END IF;
127:
128: IF NOT inv_globals.equal(p_trolin_rec.from_subinventory_code, p_old_trolin_rec.from_subinventory_code) THEN
129: l_index := l_index + 1;
130: l_src_attr_tbl(l_index) := inv_trolin_util.g_from_subinventory;
131: END IF;
132:
133: IF NOT inv_globals.equal(p_trolin_rec.from_subinventory_id, p_old_trolin_rec.from_subinventory_id) THEN
134: l_index := l_index + 1;

Line 135: l_src_attr_tbl(l_index) := inv_trolin_util.g_from_subinventory;

131: END IF;
132:
133: IF NOT inv_globals.equal(p_trolin_rec.from_subinventory_id, p_old_trolin_rec.from_subinventory_id) THEN
134: l_index := l_index + 1;
135: l_src_attr_tbl(l_index) := inv_trolin_util.g_from_subinventory;
136: END IF;
137:
138: IF NOT inv_globals.equal(p_trolin_rec.header_id, p_old_trolin_rec.header_id) THEN
139: l_index := l_index + 1;

Line 140: l_src_attr_tbl(l_index) := inv_trolin_util.g_header;

136: END IF;
137:
138: IF NOT inv_globals.equal(p_trolin_rec.header_id, p_old_trolin_rec.header_id) THEN
139: l_index := l_index + 1;
140: l_src_attr_tbl(l_index) := inv_trolin_util.g_header;
141: END IF;
142:
143: IF NOT inv_globals.equal(p_trolin_rec.inventory_item_id, p_old_trolin_rec.inventory_item_id) THEN
144: l_index := l_index + 1;

Line 145: l_src_attr_tbl(l_index) := inv_trolin_util.g_inventory_item;

141: END IF;
142:
143: IF NOT inv_globals.equal(p_trolin_rec.inventory_item_id, p_old_trolin_rec.inventory_item_id) THEN
144: l_index := l_index + 1;
145: l_src_attr_tbl(l_index) := inv_trolin_util.g_inventory_item;
146: END IF;
147:
148: IF NOT inv_globals.equal(p_trolin_rec.last_updated_by, p_old_trolin_rec.last_updated_by) THEN
149: l_index := l_index + 1;

Line 150: l_src_attr_tbl(l_index) := inv_trolin_util.g_last_updated_by;

146: END IF;
147:
148: IF NOT inv_globals.equal(p_trolin_rec.last_updated_by, p_old_trolin_rec.last_updated_by) THEN
149: l_index := l_index + 1;
150: l_src_attr_tbl(l_index) := inv_trolin_util.g_last_updated_by;
151: END IF;
152:
153: IF NOT inv_globals.equal(p_trolin_rec.last_update_date, p_old_trolin_rec.last_update_date) THEN
154: l_index := l_index + 1;

Line 155: l_src_attr_tbl(l_index) := inv_trolin_util.g_last_update_date;

151: END IF;
152:
153: IF NOT inv_globals.equal(p_trolin_rec.last_update_date, p_old_trolin_rec.last_update_date) THEN
154: l_index := l_index + 1;
155: l_src_attr_tbl(l_index) := inv_trolin_util.g_last_update_date;
156: END IF;
157:
158: IF NOT inv_globals.equal(p_trolin_rec.last_update_login, p_old_trolin_rec.last_update_login) THEN
159: l_index := l_index + 1;

Line 160: l_src_attr_tbl(l_index) := inv_trolin_util.g_last_update_login;

156: END IF;
157:
158: IF NOT inv_globals.equal(p_trolin_rec.last_update_login, p_old_trolin_rec.last_update_login) THEN
159: l_index := l_index + 1;
160: l_src_attr_tbl(l_index) := inv_trolin_util.g_last_update_login;
161: END IF;
162:
163: IF NOT inv_globals.equal(p_trolin_rec.line_id, p_old_trolin_rec.line_id) THEN
164: l_index := l_index + 1;

Line 165: l_src_attr_tbl(l_index) := inv_trolin_util.g_line;

161: END IF;
162:
163: IF NOT inv_globals.equal(p_trolin_rec.line_id, p_old_trolin_rec.line_id) THEN
164: l_index := l_index + 1;
165: l_src_attr_tbl(l_index) := inv_trolin_util.g_line;
166: END IF;
167:
168: IF NOT inv_globals.equal(p_trolin_rec.line_number, p_old_trolin_rec.line_number) THEN
169: l_index := l_index + 1;

Line 170: l_src_attr_tbl(l_index) := inv_trolin_util.g_line_number;

166: END IF;
167:
168: IF NOT inv_globals.equal(p_trolin_rec.line_number, p_old_trolin_rec.line_number) THEN
169: l_index := l_index + 1;
170: l_src_attr_tbl(l_index) := inv_trolin_util.g_line_number;
171: END IF;
172:
173: IF NOT inv_globals.equal(p_trolin_rec.line_status, p_old_trolin_rec.line_status) THEN
174: l_index := l_index + 1;

Line 175: l_src_attr_tbl(l_index) := inv_trolin_util.g_line_status;

171: END IF;
172:
173: IF NOT inv_globals.equal(p_trolin_rec.line_status, p_old_trolin_rec.line_status) THEN
174: l_index := l_index + 1;
175: l_src_attr_tbl(l_index) := inv_trolin_util.g_line_status;
176: END IF;
177:
178: IF NOT inv_globals.equal(p_trolin_rec.lot_number, p_old_trolin_rec.lot_number) THEN
179: l_index := l_index + 1;

Line 180: l_src_attr_tbl(l_index) := inv_trolin_util.g_lot_number;

176: END IF;
177:
178: IF NOT inv_globals.equal(p_trolin_rec.lot_number, p_old_trolin_rec.lot_number) THEN
179: l_index := l_index + 1;
180: l_src_attr_tbl(l_index) := inv_trolin_util.g_lot_number;
181: END IF;
182:
183: IF NOT inv_globals.equal(p_trolin_rec.organization_id, p_old_trolin_rec.organization_id) THEN
184: l_index := l_index + 1;

Line 185: l_src_attr_tbl(l_index) := inv_trolin_util.g_organization;

181: END IF;
182:
183: IF NOT inv_globals.equal(p_trolin_rec.organization_id, p_old_trolin_rec.organization_id) THEN
184: l_index := l_index + 1;
185: l_src_attr_tbl(l_index) := inv_trolin_util.g_organization;
186: END IF;
187:
188: IF NOT inv_globals.equal(p_trolin_rec.program_application_id, p_old_trolin_rec.program_application_id) THEN
189: l_index := l_index + 1;

Line 190: l_src_attr_tbl(l_index) := inv_trolin_util.g_program_application;

186: END IF;
187:
188: IF NOT inv_globals.equal(p_trolin_rec.program_application_id, p_old_trolin_rec.program_application_id) THEN
189: l_index := l_index + 1;
190: l_src_attr_tbl(l_index) := inv_trolin_util.g_program_application;
191: END IF;
192:
193: IF NOT inv_globals.equal(p_trolin_rec.program_id, p_old_trolin_rec.program_id) THEN
194: l_index := l_index + 1;

Line 195: l_src_attr_tbl(l_index) := inv_trolin_util.g_program;

191: END IF;
192:
193: IF NOT inv_globals.equal(p_trolin_rec.program_id, p_old_trolin_rec.program_id) THEN
194: l_index := l_index + 1;
195: l_src_attr_tbl(l_index) := inv_trolin_util.g_program;
196: END IF;
197:
198: IF NOT inv_globals.equal(p_trolin_rec.program_update_date, p_old_trolin_rec.program_update_date) THEN
199: l_index := l_index + 1;

Line 200: l_src_attr_tbl(l_index) := inv_trolin_util.g_program_update_date;

196: END IF;
197:
198: IF NOT inv_globals.equal(p_trolin_rec.program_update_date, p_old_trolin_rec.program_update_date) THEN
199: l_index := l_index + 1;
200: l_src_attr_tbl(l_index) := inv_trolin_util.g_program_update_date;
201: END IF;
202:
203: IF NOT inv_globals.equal(p_trolin_rec.project_id, p_old_trolin_rec.project_id) THEN
204: l_index := l_index + 1;

Line 205: l_src_attr_tbl(l_index) := inv_trolin_util.g_project;

201: END IF;
202:
203: IF NOT inv_globals.equal(p_trolin_rec.project_id, p_old_trolin_rec.project_id) THEN
204: l_index := l_index + 1;
205: l_src_attr_tbl(l_index) := inv_trolin_util.g_project;
206: END IF;
207:
208: IF NOT inv_globals.equal(p_trolin_rec.quantity, p_old_trolin_rec.quantity) THEN
209: l_index := l_index + 1;

Line 210: l_src_attr_tbl(l_index) := inv_trolin_util.g_quantity;

206: END IF;
207:
208: IF NOT inv_globals.equal(p_trolin_rec.quantity, p_old_trolin_rec.quantity) THEN
209: l_index := l_index + 1;
210: l_src_attr_tbl(l_index) := inv_trolin_util.g_quantity;
211: END IF;
212:
213: IF NOT inv_globals.equal(p_trolin_rec.quantity_delivered, p_old_trolin_rec.quantity_delivered) THEN
214: l_index := l_index + 1;

Line 215: l_src_attr_tbl(l_index) := inv_trolin_util.g_quantity_delivered;

211: END IF;
212:
213: IF NOT inv_globals.equal(p_trolin_rec.quantity_delivered, p_old_trolin_rec.quantity_delivered) THEN
214: l_index := l_index + 1;
215: l_src_attr_tbl(l_index) := inv_trolin_util.g_quantity_delivered;
216: END IF;
217:
218: IF NOT inv_globals.equal(p_trolin_rec.quantity_detailed, p_old_trolin_rec.quantity_detailed) THEN
219: l_index := l_index + 1;

Line 220: l_src_attr_tbl(l_index) := inv_trolin_util.g_quantity_detailed;

216: END IF;
217:
218: IF NOT inv_globals.equal(p_trolin_rec.quantity_detailed, p_old_trolin_rec.quantity_detailed) THEN
219: l_index := l_index + 1;
220: l_src_attr_tbl(l_index) := inv_trolin_util.g_quantity_detailed;
221: END IF;
222:
223: IF NOT inv_globals.equal(p_trolin_rec.reason_id, p_old_trolin_rec.reason_id) THEN
224: l_index := l_index + 1;

Line 225: l_src_attr_tbl(l_index) := inv_trolin_util.g_reason;

221: END IF;
222:
223: IF NOT inv_globals.equal(p_trolin_rec.reason_id, p_old_trolin_rec.reason_id) THEN
224: l_index := l_index + 1;
225: l_src_attr_tbl(l_index) := inv_trolin_util.g_reason;
226: END IF;
227:
228: IF NOT inv_globals.equal(p_trolin_rec.REFERENCE, p_old_trolin_rec.REFERENCE) THEN
229: l_index := l_index + 1;

Line 230: l_src_attr_tbl(l_index) := inv_trolin_util.g_reference;

226: END IF;
227:
228: IF NOT inv_globals.equal(p_trolin_rec.REFERENCE, p_old_trolin_rec.REFERENCE) THEN
229: l_index := l_index + 1;
230: l_src_attr_tbl(l_index) := inv_trolin_util.g_reference;
231: END IF;
232:
233: IF NOT inv_globals.equal(p_trolin_rec.reference_id, p_old_trolin_rec.reference_id) THEN
234: l_index := l_index + 1;

Line 235: l_src_attr_tbl(l_index) := inv_trolin_util.g_reference;

231: END IF;
232:
233: IF NOT inv_globals.equal(p_trolin_rec.reference_id, p_old_trolin_rec.reference_id) THEN
234: l_index := l_index + 1;
235: l_src_attr_tbl(l_index) := inv_trolin_util.g_reference;
236: END IF;
237:
238: IF NOT inv_globals.equal(p_trolin_rec.reference_type_code, p_old_trolin_rec.reference_type_code) THEN
239: l_index := l_index + 1;

Line 240: l_src_attr_tbl(l_index) := inv_trolin_util.g_reference_type;

236: END IF;
237:
238: IF NOT inv_globals.equal(p_trolin_rec.reference_type_code, p_old_trolin_rec.reference_type_code) THEN
239: l_index := l_index + 1;
240: l_src_attr_tbl(l_index) := inv_trolin_util.g_reference_type;
241: END IF;
242:
243: IF NOT inv_globals.equal(p_trolin_rec.request_id, p_old_trolin_rec.request_id) THEN
244: l_index := l_index + 1;

Line 245: l_src_attr_tbl(l_index) := inv_trolin_util.g_request;

241: END IF;
242:
243: IF NOT inv_globals.equal(p_trolin_rec.request_id, p_old_trolin_rec.request_id) THEN
244: l_index := l_index + 1;
245: l_src_attr_tbl(l_index) := inv_trolin_util.g_request;
246: END IF;
247:
248: IF NOT inv_globals.equal(p_trolin_rec.revision, p_old_trolin_rec.revision) THEN
249: l_index := l_index + 1;

Line 250: l_src_attr_tbl(l_index) := inv_trolin_util.g_revision;

246: END IF;
247:
248: IF NOT inv_globals.equal(p_trolin_rec.revision, p_old_trolin_rec.revision) THEN
249: l_index := l_index + 1;
250: l_src_attr_tbl(l_index) := inv_trolin_util.g_revision;
251: END IF;
252:
253: IF NOT inv_globals.equal(p_trolin_rec.serial_number_end, p_old_trolin_rec.serial_number_end) THEN
254: l_index := l_index + 1;

Line 255: l_src_attr_tbl(l_index) := inv_trolin_util.g_serial_number_end;

251: END IF;
252:
253: IF NOT inv_globals.equal(p_trolin_rec.serial_number_end, p_old_trolin_rec.serial_number_end) THEN
254: l_index := l_index + 1;
255: l_src_attr_tbl(l_index) := inv_trolin_util.g_serial_number_end;
256: END IF;
257:
258: IF NOT inv_globals.equal(p_trolin_rec.serial_number_start, p_old_trolin_rec.serial_number_start) THEN
259: l_index := l_index + 1;

Line 260: l_src_attr_tbl(l_index) := inv_trolin_util.g_serial_number_start;

256: END IF;
257:
258: IF NOT inv_globals.equal(p_trolin_rec.serial_number_start, p_old_trolin_rec.serial_number_start) THEN
259: l_index := l_index + 1;
260: l_src_attr_tbl(l_index) := inv_trolin_util.g_serial_number_start;
261: END IF;
262:
263: IF NOT inv_globals.equal(p_trolin_rec.status_date, p_old_trolin_rec.status_date) THEN
264: l_index := l_index + 1;

Line 265: l_src_attr_tbl(l_index) := inv_trolin_util.g_status_date;

261: END IF;
262:
263: IF NOT inv_globals.equal(p_trolin_rec.status_date, p_old_trolin_rec.status_date) THEN
264: l_index := l_index + 1;
265: l_src_attr_tbl(l_index) := inv_trolin_util.g_status_date;
266: END IF;
267:
268: IF NOT inv_globals.equal(p_trolin_rec.task_id, p_old_trolin_rec.task_id) THEN
269: l_index := l_index + 1;

Line 270: l_src_attr_tbl(l_index) := inv_trolin_util.g_task;

266: END IF;
267:
268: IF NOT inv_globals.equal(p_trolin_rec.task_id, p_old_trolin_rec.task_id) THEN
269: l_index := l_index + 1;
270: l_src_attr_tbl(l_index) := inv_trolin_util.g_task;
271: END IF;
272:
273: IF NOT inv_globals.equal(p_trolin_rec.to_account_id, p_old_trolin_rec.to_account_id) THEN
274: l_index := l_index + 1;

Line 275: l_src_attr_tbl(l_index) := inv_trolin_util.g_to_account;

271: END IF;
272:
273: IF NOT inv_globals.equal(p_trolin_rec.to_account_id, p_old_trolin_rec.to_account_id) THEN
274: l_index := l_index + 1;
275: l_src_attr_tbl(l_index) := inv_trolin_util.g_to_account;
276: END IF;
277:
278: IF NOT inv_globals.equal(p_trolin_rec.to_locator_id, p_old_trolin_rec.to_locator_id) THEN
279: l_index := l_index + 1;

Line 280: l_src_attr_tbl(l_index) := inv_trolin_util.g_to_locator;

276: END IF;
277:
278: IF NOT inv_globals.equal(p_trolin_rec.to_locator_id, p_old_trolin_rec.to_locator_id) THEN
279: l_index := l_index + 1;
280: l_src_attr_tbl(l_index) := inv_trolin_util.g_to_locator;
281: END IF;
282:
283: IF NOT inv_globals.equal(p_trolin_rec.to_subinventory_code, p_old_trolin_rec.to_subinventory_code) THEN
284: l_index := l_index + 1;

Line 285: l_src_attr_tbl(l_index) := inv_trolin_util.g_to_subinventory;

281: END IF;
282:
283: IF NOT inv_globals.equal(p_trolin_rec.to_subinventory_code, p_old_trolin_rec.to_subinventory_code) THEN
284: l_index := l_index + 1;
285: l_src_attr_tbl(l_index) := inv_trolin_util.g_to_subinventory;
286: END IF;
287:
288: IF NOT inv_globals.equal(p_trolin_rec.to_subinventory_id, p_old_trolin_rec.to_subinventory_id) THEN
289: l_index := l_index + 1;

Line 290: l_src_attr_tbl(l_index) := inv_trolin_util.g_to_subinventory;

286: END IF;
287:
288: IF NOT inv_globals.equal(p_trolin_rec.to_subinventory_id, p_old_trolin_rec.to_subinventory_id) THEN
289: l_index := l_index + 1;
290: l_src_attr_tbl(l_index) := inv_trolin_util.g_to_subinventory;
291: END IF;
292:
293: IF NOT inv_globals.equal(p_trolin_rec.transaction_header_id, p_old_trolin_rec.transaction_header_id) THEN
294: l_index := l_index + 1;

Line 295: l_src_attr_tbl(l_index) := inv_trolin_util.g_transaction_header;

291: END IF;
292:
293: IF NOT inv_globals.equal(p_trolin_rec.transaction_header_id, p_old_trolin_rec.transaction_header_id) THEN
294: l_index := l_index + 1;
295: l_src_attr_tbl(l_index) := inv_trolin_util.g_transaction_header;
296: END IF;
297:
298: IF NOT inv_globals.equal(p_trolin_rec.uom_code, p_old_trolin_rec.uom_code) THEN
299: l_index := l_index + 1;

Line 300: l_src_attr_tbl(l_index) := inv_trolin_util.g_uom;

296: END IF;
297:
298: IF NOT inv_globals.equal(p_trolin_rec.uom_code, p_old_trolin_rec.uom_code) THEN
299: l_index := l_index + 1;
300: l_src_attr_tbl(l_index) := inv_trolin_util.g_uom;
301: END IF;
302:
303: IF NOT inv_globals.equal(p_trolin_rec.transaction_type_id, p_old_trolin_rec.transaction_type_id) THEN
304: l_index := l_index + 1;

Line 305: l_src_attr_tbl(l_index) := inv_trolin_util.g_transaction_type_id;

301: END IF;
302:
303: IF NOT inv_globals.equal(p_trolin_rec.transaction_type_id, p_old_trolin_rec.transaction_type_id) THEN
304: l_index := l_index + 1;
305: l_src_attr_tbl(l_index) := inv_trolin_util.g_transaction_type_id;
306: END IF;
307:
308: IF NOT inv_globals.equal(p_trolin_rec.to_organization_id, p_old_trolin_rec.to_organization_id) THEN
309: l_index := l_index + 1;

Line 310: l_src_attr_tbl(l_index) := inv_trolin_util.g_to_organization_id;

306: END IF;
307:
308: IF NOT inv_globals.equal(p_trolin_rec.to_organization_id, p_old_trolin_rec.to_organization_id) THEN
309: l_index := l_index + 1;
310: l_src_attr_tbl(l_index) := inv_trolin_util.g_to_organization_id;
311: END IF;
312:
313: IF NOT inv_globals.equal(p_trolin_rec.primary_quantity, p_old_trolin_rec.primary_quantity) THEN
314: l_index := l_index + 1;

Line 315: l_src_attr_tbl(l_index) := inv_trolin_util.g_primary_quantity;

311: END IF;
312:
313: IF NOT inv_globals.equal(p_trolin_rec.primary_quantity, p_old_trolin_rec.primary_quantity) THEN
314: l_index := l_index + 1;
315: l_src_attr_tbl(l_index) := inv_trolin_util.g_primary_quantity;
316: END IF;
317:
318: IF NOT inv_globals.equal(p_trolin_rec.txn_source_id, p_old_trolin_rec.txn_source_id) THEN
319: l_index := l_index + 1;

Line 320: l_src_attr_tbl(l_index) := inv_trolin_util.g_txn_source_id;

316: END IF;
317:
318: IF NOT inv_globals.equal(p_trolin_rec.txn_source_id, p_old_trolin_rec.txn_source_id) THEN
319: l_index := l_index + 1;
320: l_src_attr_tbl(l_index) := inv_trolin_util.g_txn_source_id;
321: END IF;
322:
323: IF NOT inv_globals.equal(p_trolin_rec.txn_source_line_id, p_old_trolin_rec.txn_source_line_id) THEN
324: l_index := l_index + 1;

Line 325: l_src_attr_tbl(l_index) := inv_trolin_util.g_txn_source_line_id;

321: END IF;
322:
323: IF NOT inv_globals.equal(p_trolin_rec.txn_source_line_id, p_old_trolin_rec.txn_source_line_id) THEN
324: l_index := l_index + 1;
325: l_src_attr_tbl(l_index) := inv_trolin_util.g_txn_source_line_id;
326: END IF;
327:
328: IF NOT inv_globals.equal(p_trolin_rec.txn_source_line_detail_id, p_old_trolin_rec.txn_source_line_detail_id) THEN
329: l_index := l_index + 1;

Line 330: l_src_attr_tbl(l_index) := inv_trolin_util.g_txn_source_line_detail_id;

326: END IF;
327:
328: IF NOT inv_globals.equal(p_trolin_rec.txn_source_line_detail_id, p_old_trolin_rec.txn_source_line_detail_id) THEN
329: l_index := l_index + 1;
330: l_src_attr_tbl(l_index) := inv_trolin_util.g_txn_source_line_detail_id;
331: END IF;
332:
333: IF NOT inv_globals.equal(p_trolin_rec.transaction_source_type_id, p_old_trolin_rec.transaction_source_type_id) THEN
334: l_index := l_index + 1;

Line 335: l_src_attr_tbl(l_index) := inv_trolin_util.g_transaction_source_type_id;

331: END IF;
332:
333: IF NOT inv_globals.equal(p_trolin_rec.transaction_source_type_id, p_old_trolin_rec.transaction_source_type_id) THEN
334: l_index := l_index + 1;
335: l_src_attr_tbl(l_index) := inv_trolin_util.g_transaction_source_type_id;
336: END IF;
337:
338: IF NOT inv_globals.equal(p_trolin_rec.put_away_strategy_id, p_old_trolin_rec.put_away_strategy_id) THEN
339: l_index := l_index + 1;

Line 340: l_src_attr_tbl(l_index) := inv_trolin_util.g_put_away_strategy_id;

336: END IF;
337:
338: IF NOT inv_globals.equal(p_trolin_rec.put_away_strategy_id, p_old_trolin_rec.put_away_strategy_id) THEN
339: l_index := l_index + 1;
340: l_src_attr_tbl(l_index) := inv_trolin_util.g_put_away_strategy_id;
341: END IF;
342:
343: IF NOT inv_globals.equal(p_trolin_rec.pick_strategy_id, p_old_trolin_rec.pick_strategy_id) THEN
344: l_index := l_index + 1;

Line 345: l_src_attr_tbl(l_index) := inv_trolin_util.g_pick_strategy_id;

341: END IF;
342:
343: IF NOT inv_globals.equal(p_trolin_rec.pick_strategy_id, p_old_trolin_rec.pick_strategy_id) THEN
344: l_index := l_index + 1;
345: l_src_attr_tbl(l_index) := inv_trolin_util.g_pick_strategy_id;
346: END IF;
347:
348: IF NOT inv_globals.equal(p_trolin_rec.unit_number, p_old_trolin_rec.unit_number) THEN
349: l_index := l_index + 1;

Line 350: l_src_attr_tbl(l_index) := inv_trolin_util.g_unit_number;

346: END IF;
347:
348: IF NOT inv_globals.equal(p_trolin_rec.unit_number, p_old_trolin_rec.unit_number) THEN
349: l_index := l_index + 1;
350: l_src_attr_tbl(l_index) := inv_trolin_util.g_unit_number;
351: END IF;
352:
353: IF NOT inv_globals.equal(p_trolin_rec.ship_to_location_id, p_old_trolin_rec.ship_to_location_id) THEN
354: l_index := l_index + 1;

Line 355: l_src_attr_tbl(l_index) := inv_trolin_util.g_ship_to_location_id;

351: END IF;
352:
353: IF NOT inv_globals.equal(p_trolin_rec.ship_to_location_id, p_old_trolin_rec.ship_to_location_id) THEN
354: l_index := l_index + 1;
355: l_src_attr_tbl(l_index) := inv_trolin_util.g_ship_to_location_id;
356: END IF;
357:
358: IF NOT inv_globals.equal(p_trolin_rec.from_cost_group_id, p_old_trolin_rec.from_cost_group_id) THEN
359: l_index := l_index + 1;

Line 360: l_src_attr_tbl(l_index) := inv_trolin_util.g_from_cost_group_id;

356: END IF;
357:
358: IF NOT inv_globals.equal(p_trolin_rec.from_cost_group_id, p_old_trolin_rec.from_cost_group_id) THEN
359: l_index := l_index + 1;
360: l_src_attr_tbl(l_index) := inv_trolin_util.g_from_cost_group_id;
361: END IF;
362:
363: IF NOT inv_globals.equal(p_trolin_rec.to_cost_group_id, p_old_trolin_rec.to_cost_group_id) THEN
364: l_index := l_index + 1;

Line 365: l_src_attr_tbl(l_index) := inv_trolin_util.g_to_cost_group_id;

361: END IF;
362:
363: IF NOT inv_globals.equal(p_trolin_rec.to_cost_group_id, p_old_trolin_rec.to_cost_group_id) THEN
364: l_index := l_index + 1;
365: l_src_attr_tbl(l_index) := inv_trolin_util.g_to_cost_group_id;
366: END IF;
367:
368: IF NOT inv_globals.equal(p_trolin_rec.lpn_id, p_old_trolin_rec.lpn_id) THEN
369: l_index := l_index + 1;

Line 370: l_src_attr_tbl(l_index) := inv_trolin_util.g_lpn_id;

366: END IF;
367:
368: IF NOT inv_globals.equal(p_trolin_rec.lpn_id, p_old_trolin_rec.lpn_id) THEN
369: l_index := l_index + 1;
370: l_src_attr_tbl(l_index) := inv_trolin_util.g_lpn_id;
371: END IF;
372:
373: IF NOT inv_globals.equal(p_trolin_rec.to_lpn_id, p_old_trolin_rec.to_lpn_id) THEN
374: l_index := l_index + 1;

Line 375: l_src_attr_tbl(l_index) := inv_trolin_util.g_to_lpn_id;

371: END IF;
372:
373: IF NOT inv_globals.equal(p_trolin_rec.to_lpn_id, p_old_trolin_rec.to_lpn_id) THEN
374: l_index := l_index + 1;
375: l_src_attr_tbl(l_index) := inv_trolin_util.g_to_lpn_id;
376: END IF;
377:
378: IF NOT inv_globals.equal(p_trolin_rec.pick_methodology_id, p_old_trolin_rec.pick_methodology_id) THEN
379: l_index := l_index + 1;

Line 380: l_src_attr_tbl(l_index) := inv_trolin_util.g_pick_methodology_id;

376: END IF;
377:
378: IF NOT inv_globals.equal(p_trolin_rec.pick_methodology_id, p_old_trolin_rec.pick_methodology_id) THEN
379: l_index := l_index + 1;
380: l_src_attr_tbl(l_index) := inv_trolin_util.g_pick_methodology_id;
381: END IF;
382:
383: IF NOT inv_globals.equal(p_trolin_rec.container_item_id, p_old_trolin_rec.container_item_id) THEN
384: l_index := l_index + 1;

Line 385: l_src_attr_tbl(l_index) := inv_trolin_util.g_container_item_id;

381: END IF;
382:
383: IF NOT inv_globals.equal(p_trolin_rec.container_item_id, p_old_trolin_rec.container_item_id) THEN
384: l_index := l_index + 1;
385: l_src_attr_tbl(l_index) := inv_trolin_util.g_container_item_id;
386: END IF;
387:
388: IF NOT inv_globals.equal(p_trolin_rec.carton_grouping_id, p_old_trolin_rec.carton_grouping_id) THEN
389: l_index := l_index + 1;

Line 390: l_src_attr_tbl(l_index) := inv_trolin_util.g_carton_grouping_id;

386: END IF;
387:
388: IF NOT inv_globals.equal(p_trolin_rec.carton_grouping_id, p_old_trolin_rec.carton_grouping_id) THEN
389: l_index := l_index + 1;
390: l_src_attr_tbl(l_index) := inv_trolin_util.g_carton_grouping_id;
391: END IF;
392:
393: IF NOT inv_globals.equal(p_trolin_rec.pick_slip_number, p_old_trolin_rec.pick_slip_number) THEN
394: l_index := l_index + 1;

Line 395: l_src_attr_tbl(l_index) := inv_trolin_util.g_pick_slip_number;

391: END IF;
392:
393: IF NOT inv_globals.equal(p_trolin_rec.pick_slip_number, p_old_trolin_rec.pick_slip_number) THEN
394: l_index := l_index + 1;
395: l_src_attr_tbl(l_index) := inv_trolin_util.g_pick_slip_number;
396: END IF;
397:
398: IF NOT inv_globals.equal(p_trolin_rec.pick_slip_date, p_old_trolin_rec.pick_slip_date) THEN
399: l_index := l_index + 1;

Line 400: l_src_attr_tbl(l_index) := inv_trolin_util.g_pick_slip_date;

396: END IF;
397:
398: IF NOT inv_globals.equal(p_trolin_rec.pick_slip_date, p_old_trolin_rec.pick_slip_date) THEN
399: l_index := l_index + 1;
400: l_src_attr_tbl(l_index) := inv_trolin_util.g_pick_slip_date;
401: END IF;
402:
403: IF NOT inv_globals.equal(p_trolin_rec.ship_set_id, p_old_trolin_rec.ship_set_id) THEN
404: l_index := l_index + 1;

Line 405: l_src_attr_tbl(l_index) := inv_trolin_util.g_ship_set_id;

401: END IF;
402:
403: IF NOT inv_globals.equal(p_trolin_rec.ship_set_id, p_old_trolin_rec.ship_set_id) THEN
404: l_index := l_index + 1;
405: l_src_attr_tbl(l_index) := inv_trolin_util.g_ship_set_id;
406: END IF;
407:
408: IF NOT inv_globals.equal(p_trolin_rec.ship_model_id, p_old_trolin_rec.ship_model_id) THEN
409: l_index := l_index + 1;

Line 410: l_src_attr_tbl(l_index) := inv_trolin_util.g_ship_model_id;

406: END IF;
407:
408: IF NOT inv_globals.equal(p_trolin_rec.ship_model_id, p_old_trolin_rec.ship_model_id) THEN
409: l_index := l_index + 1;
410: l_src_attr_tbl(l_index) := inv_trolin_util.g_ship_model_id;
411: END IF;
412:
413: IF NOT inv_globals.equal(p_trolin_rec.model_quantity, p_old_trolin_rec.model_quantity) THEN
414: l_index := l_index + 1;

Line 415: l_src_attr_tbl(l_index) := inv_trolin_util.g_model_quantity;

411: END IF;
412:
413: IF NOT inv_globals.equal(p_trolin_rec.model_quantity, p_old_trolin_rec.model_quantity) THEN
414: l_index := l_index + 1;
415: l_src_attr_tbl(l_index) := inv_trolin_util.g_model_quantity;
416: END IF;
417:
418: IF NOT inv_globals.equal(p_trolin_rec.required_quantity, p_old_trolin_rec.required_quantity) THEN
419: l_index := l_index + 1;

Line 420: l_src_attr_tbl(l_index) := inv_trolin_util.g_required_quantity;

416: END IF;
417:
418: IF NOT inv_globals.equal(p_trolin_rec.required_quantity, p_old_trolin_rec.required_quantity) THEN
419: l_index := l_index + 1;
420: l_src_attr_tbl(l_index) := inv_trolin_util.g_required_quantity;
421: END IF;
422: --INVCONV BEGIN
423: IF NOT inv_globals.equal(p_trolin_rec.secondary_quantity, p_old_trolin_rec.secondary_quantity) THEN
424: l_index := l_index + 1;

Line 425: l_src_attr_tbl(l_index) := inv_trolin_util.g_secondary_quantity;

421: END IF;
422: --INVCONV BEGIN
423: IF NOT inv_globals.equal(p_trolin_rec.secondary_quantity, p_old_trolin_rec.secondary_quantity) THEN
424: l_index := l_index + 1;
425: l_src_attr_tbl(l_index) := inv_trolin_util.g_secondary_quantity;
426: END IF;
427:
428: IF NOT inv_globals.equal(p_trolin_rec.secondary_quantity_delivered, p_old_trolin_rec.secondary_quantity_delivered) THEN
429: l_index := l_index + 1;

Line 430: l_src_attr_tbl(l_index) := inv_trolin_util.g_secondary_quantity_delivered;

426: END IF;
427:
428: IF NOT inv_globals.equal(p_trolin_rec.secondary_quantity_delivered, p_old_trolin_rec.secondary_quantity_delivered) THEN
429: l_index := l_index + 1;
430: l_src_attr_tbl(l_index) := inv_trolin_util.g_secondary_quantity_delivered;
431: END IF;
432:
433: IF NOT inv_globals.equal(p_trolin_rec.secondary_quantity_detailed, p_old_trolin_rec.secondary_quantity_detailed) THEN
434: l_index := l_index + 1;

Line 435: l_src_attr_tbl(l_index) := inv_trolin_util.g_secondary_quantity_detailed;

431: END IF;
432:
433: IF NOT inv_globals.equal(p_trolin_rec.secondary_quantity_detailed, p_old_trolin_rec.secondary_quantity_detailed) THEN
434: l_index := l_index + 1;
435: l_src_attr_tbl(l_index) := inv_trolin_util.g_secondary_quantity_detailed;
436: END IF;
437:
438: IF NOT inv_globals.equal(p_trolin_rec.secondary_uom, p_old_trolin_rec.secondary_uom) THEN
439: l_index := l_index + 1;

Line 440: l_src_attr_tbl(l_index) := inv_trolin_util.g_secondary_uom;

436: END IF;
437:
438: IF NOT inv_globals.equal(p_trolin_rec.secondary_uom, p_old_trolin_rec.secondary_uom) THEN
439: l_index := l_index + 1;
440: l_src_attr_tbl(l_index) := inv_trolin_util.g_secondary_uom;
441: END IF;
442:
443: IF NOT inv_globals.equal(p_trolin_rec.grade_code, p_old_trolin_rec.grade_code) THEN
444: l_index := l_index + 1;

Line 445: l_src_attr_tbl(l_index) := inv_trolin_util.g_grade_code;

441: END IF;
442:
443: IF NOT inv_globals.equal(p_trolin_rec.grade_code, p_old_trolin_rec.grade_code) THEN
444: l_index := l_index + 1;
445: l_src_attr_tbl(l_index) := inv_trolin_util.g_grade_code;
446: END IF;
447:
448: IF NOT inv_globals.equal(p_trolin_rec.secondary_required_quantity, p_old_trolin_rec.secondary_required_quantity) THEN
449: l_index := l_index + 1;

Line 450: l_src_attr_tbl(l_index) := inv_trolin_util.g_secondary_required_quantity;

446: END IF;
447:
448: IF NOT inv_globals.equal(p_trolin_rec.secondary_required_quantity, p_old_trolin_rec.secondary_required_quantity) THEN
449: l_index := l_index + 1;
450: l_src_attr_tbl(l_index) := inv_trolin_util.g_secondary_required_quantity;
451: END IF;
452: --INVCONV END;
453: ELSIF p_attr_id = g_attribute1 THEN
454: l_index := l_index + 1;

Line 455: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute1;

451: END IF;
452: --INVCONV END;
453: ELSIF p_attr_id = g_attribute1 THEN
454: l_index := l_index + 1;
455: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute1;
456: ELSIF p_attr_id = g_attribute10 THEN
457: l_index := l_index + 1;
458: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute10;
459: ELSIF p_attr_id = g_attribute11 THEN

Line 458: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute10;

454: l_index := l_index + 1;
455: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute1;
456: ELSIF p_attr_id = g_attribute10 THEN
457: l_index := l_index + 1;
458: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute10;
459: ELSIF p_attr_id = g_attribute11 THEN
460: l_index := l_index + 1;
461: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute11;
462: ELSIF p_attr_id = g_attribute12 THEN

Line 461: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute11;

457: l_index := l_index + 1;
458: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute10;
459: ELSIF p_attr_id = g_attribute11 THEN
460: l_index := l_index + 1;
461: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute11;
462: ELSIF p_attr_id = g_attribute12 THEN
463: l_index := l_index + 1;
464: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute12;
465: ELSIF p_attr_id = g_attribute13 THEN

Line 464: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute12;

460: l_index := l_index + 1;
461: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute11;
462: ELSIF p_attr_id = g_attribute12 THEN
463: l_index := l_index + 1;
464: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute12;
465: ELSIF p_attr_id = g_attribute13 THEN
466: l_index := l_index + 1;
467: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute13;
468: ELSIF p_attr_id = g_attribute14 THEN

Line 467: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute13;

463: l_index := l_index + 1;
464: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute12;
465: ELSIF p_attr_id = g_attribute13 THEN
466: l_index := l_index + 1;
467: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute13;
468: ELSIF p_attr_id = g_attribute14 THEN
469: l_index := l_index + 1;
470: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute14;
471: ELSIF p_attr_id = g_attribute15 THEN

Line 470: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute14;

466: l_index := l_index + 1;
467: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute13;
468: ELSIF p_attr_id = g_attribute14 THEN
469: l_index := l_index + 1;
470: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute14;
471: ELSIF p_attr_id = g_attribute15 THEN
472: l_index := l_index + 1;
473: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute15;
474: ELSIF p_attr_id = g_attribute2 THEN

Line 473: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute15;

469: l_index := l_index + 1;
470: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute14;
471: ELSIF p_attr_id = g_attribute15 THEN
472: l_index := l_index + 1;
473: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute15;
474: ELSIF p_attr_id = g_attribute2 THEN
475: l_index := l_index + 1;
476: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute2;
477: ELSIF p_attr_id = g_attribute3 THEN

Line 476: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute2;

472: l_index := l_index + 1;
473: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute15;
474: ELSIF p_attr_id = g_attribute2 THEN
475: l_index := l_index + 1;
476: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute2;
477: ELSIF p_attr_id = g_attribute3 THEN
478: l_index := l_index + 1;
479: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute3;
480: ELSIF p_attr_id = g_attribute4 THEN

Line 479: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute3;

475: l_index := l_index + 1;
476: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute2;
477: ELSIF p_attr_id = g_attribute3 THEN
478: l_index := l_index + 1;
479: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute3;
480: ELSIF p_attr_id = g_attribute4 THEN
481: l_index := l_index + 1;
482: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute4;
483: ELSIF p_attr_id = g_attribute5 THEN

Line 482: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute4;

478: l_index := l_index + 1;
479: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute3;
480: ELSIF p_attr_id = g_attribute4 THEN
481: l_index := l_index + 1;
482: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute4;
483: ELSIF p_attr_id = g_attribute5 THEN
484: l_index := l_index + 1;
485: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute5;
486: ELSIF p_attr_id = g_attribute6 THEN

Line 485: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute5;

481: l_index := l_index + 1;
482: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute4;
483: ELSIF p_attr_id = g_attribute5 THEN
484: l_index := l_index + 1;
485: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute5;
486: ELSIF p_attr_id = g_attribute6 THEN
487: l_index := l_index + 1;
488: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute6;
489: ELSIF p_attr_id = g_attribute7 THEN

Line 488: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute6;

484: l_index := l_index + 1;
485: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute5;
486: ELSIF p_attr_id = g_attribute6 THEN
487: l_index := l_index + 1;
488: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute6;
489: ELSIF p_attr_id = g_attribute7 THEN
490: l_index := l_index + 1;
491: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute7;
492: ELSIF p_attr_id = g_attribute8 THEN

Line 491: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute7;

487: l_index := l_index + 1;
488: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute6;
489: ELSIF p_attr_id = g_attribute7 THEN
490: l_index := l_index + 1;
491: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute7;
492: ELSIF p_attr_id = g_attribute8 THEN
493: l_index := l_index + 1;
494: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute8;
495: ELSIF p_attr_id = g_attribute9 THEN

Line 494: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute8;

490: l_index := l_index + 1;
491: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute7;
492: ELSIF p_attr_id = g_attribute8 THEN
493: l_index := l_index + 1;
494: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute8;
495: ELSIF p_attr_id = g_attribute9 THEN
496: l_index := l_index + 1;
497: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute9;
498: ELSIF p_attr_id = g_attribute_category THEN

Line 497: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute9;

493: l_index := l_index + 1;
494: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute8;
495: ELSIF p_attr_id = g_attribute9 THEN
496: l_index := l_index + 1;
497: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute9;
498: ELSIF p_attr_id = g_attribute_category THEN
499: l_index := l_index + 1;
500: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute_category;
501: ELSIF p_attr_id = g_created_by THEN

Line 500: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute_category;

496: l_index := l_index + 1;
497: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute9;
498: ELSIF p_attr_id = g_attribute_category THEN
499: l_index := l_index + 1;
500: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute_category;
501: ELSIF p_attr_id = g_created_by THEN
502: l_index := l_index + 1;
503: l_src_attr_tbl(l_index) := inv_trolin_util.g_created_by;
504: ELSIF p_attr_id = g_creation_date THEN

Line 503: l_src_attr_tbl(l_index) := inv_trolin_util.g_created_by;

499: l_index := l_index + 1;
500: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute_category;
501: ELSIF p_attr_id = g_created_by THEN
502: l_index := l_index + 1;
503: l_src_attr_tbl(l_index) := inv_trolin_util.g_created_by;
504: ELSIF p_attr_id = g_creation_date THEN
505: l_index := l_index + 1;
506: l_src_attr_tbl(l_index) := inv_trolin_util.g_creation_date;
507: ELSIF p_attr_id = g_date_required THEN

Line 506: l_src_attr_tbl(l_index) := inv_trolin_util.g_creation_date;

502: l_index := l_index + 1;
503: l_src_attr_tbl(l_index) := inv_trolin_util.g_created_by;
504: ELSIF p_attr_id = g_creation_date THEN
505: l_index := l_index + 1;
506: l_src_attr_tbl(l_index) := inv_trolin_util.g_creation_date;
507: ELSIF p_attr_id = g_date_required THEN
508: l_index := l_index + 1;
509: l_src_attr_tbl(l_index) := inv_trolin_util.g_date_required;
510: ELSIF p_attr_id = g_from_locator THEN

Line 509: l_src_attr_tbl(l_index) := inv_trolin_util.g_date_required;

505: l_index := l_index + 1;
506: l_src_attr_tbl(l_index) := inv_trolin_util.g_creation_date;
507: ELSIF p_attr_id = g_date_required THEN
508: l_index := l_index + 1;
509: l_src_attr_tbl(l_index) := inv_trolin_util.g_date_required;
510: ELSIF p_attr_id = g_from_locator THEN
511: l_index := l_index + 1;
512: l_src_attr_tbl(l_index) := inv_trolin_util.g_from_locator;
513: ELSIF p_attr_id = g_from_subinventory THEN

Line 512: l_src_attr_tbl(l_index) := inv_trolin_util.g_from_locator;

508: l_index := l_index + 1;
509: l_src_attr_tbl(l_index) := inv_trolin_util.g_date_required;
510: ELSIF p_attr_id = g_from_locator THEN
511: l_index := l_index + 1;
512: l_src_attr_tbl(l_index) := inv_trolin_util.g_from_locator;
513: ELSIF p_attr_id = g_from_subinventory THEN
514: l_index := l_index + 1;
515: l_src_attr_tbl(l_index) := inv_trolin_util.g_from_subinventory;
516: ELSIF p_attr_id = g_from_subinventory THEN

Line 515: l_src_attr_tbl(l_index) := inv_trolin_util.g_from_subinventory;

511: l_index := l_index + 1;
512: l_src_attr_tbl(l_index) := inv_trolin_util.g_from_locator;
513: ELSIF p_attr_id = g_from_subinventory THEN
514: l_index := l_index + 1;
515: l_src_attr_tbl(l_index) := inv_trolin_util.g_from_subinventory;
516: ELSIF p_attr_id = g_from_subinventory THEN
517: l_index := l_index + 1;
518: l_src_attr_tbl(l_index) := inv_trolin_util.g_from_subinventory;
519: ELSIF p_attr_id = g_header THEN

Line 518: l_src_attr_tbl(l_index) := inv_trolin_util.g_from_subinventory;

514: l_index := l_index + 1;
515: l_src_attr_tbl(l_index) := inv_trolin_util.g_from_subinventory;
516: ELSIF p_attr_id = g_from_subinventory THEN
517: l_index := l_index + 1;
518: l_src_attr_tbl(l_index) := inv_trolin_util.g_from_subinventory;
519: ELSIF p_attr_id = g_header THEN
520: l_index := l_index + 1;
521: l_src_attr_tbl(l_index) := inv_trolin_util.g_header;
522: ELSIF p_attr_id = g_inventory_item THEN

Line 521: l_src_attr_tbl(l_index) := inv_trolin_util.g_header;

517: l_index := l_index + 1;
518: l_src_attr_tbl(l_index) := inv_trolin_util.g_from_subinventory;
519: ELSIF p_attr_id = g_header THEN
520: l_index := l_index + 1;
521: l_src_attr_tbl(l_index) := inv_trolin_util.g_header;
522: ELSIF p_attr_id = g_inventory_item THEN
523: l_index := l_index + 1;
524: l_src_attr_tbl(l_index) := inv_trolin_util.g_inventory_item;
525: ELSIF p_attr_id = g_last_updated_by THEN

Line 524: l_src_attr_tbl(l_index) := inv_trolin_util.g_inventory_item;

520: l_index := l_index + 1;
521: l_src_attr_tbl(l_index) := inv_trolin_util.g_header;
522: ELSIF p_attr_id = g_inventory_item THEN
523: l_index := l_index + 1;
524: l_src_attr_tbl(l_index) := inv_trolin_util.g_inventory_item;
525: ELSIF p_attr_id = g_last_updated_by THEN
526: l_index := l_index + 1;
527: l_src_attr_tbl(l_index) := inv_trolin_util.g_last_updated_by;
528: ELSIF p_attr_id = g_last_update_date THEN

Line 527: l_src_attr_tbl(l_index) := inv_trolin_util.g_last_updated_by;

523: l_index := l_index + 1;
524: l_src_attr_tbl(l_index) := inv_trolin_util.g_inventory_item;
525: ELSIF p_attr_id = g_last_updated_by THEN
526: l_index := l_index + 1;
527: l_src_attr_tbl(l_index) := inv_trolin_util.g_last_updated_by;
528: ELSIF p_attr_id = g_last_update_date THEN
529: l_index := l_index + 1;
530: l_src_attr_tbl(l_index) := inv_trolin_util.g_last_update_date;
531: ELSIF p_attr_id = g_last_update_login THEN

Line 530: l_src_attr_tbl(l_index) := inv_trolin_util.g_last_update_date;

526: l_index := l_index + 1;
527: l_src_attr_tbl(l_index) := inv_trolin_util.g_last_updated_by;
528: ELSIF p_attr_id = g_last_update_date THEN
529: l_index := l_index + 1;
530: l_src_attr_tbl(l_index) := inv_trolin_util.g_last_update_date;
531: ELSIF p_attr_id = g_last_update_login THEN
532: l_index := l_index + 1;
533: l_src_attr_tbl(l_index) := inv_trolin_util.g_last_update_login;
534: ELSIF p_attr_id = g_line THEN

Line 533: l_src_attr_tbl(l_index) := inv_trolin_util.g_last_update_login;

529: l_index := l_index + 1;
530: l_src_attr_tbl(l_index) := inv_trolin_util.g_last_update_date;
531: ELSIF p_attr_id = g_last_update_login THEN
532: l_index := l_index + 1;
533: l_src_attr_tbl(l_index) := inv_trolin_util.g_last_update_login;
534: ELSIF p_attr_id = g_line THEN
535: l_index := l_index + 1;
536: l_src_attr_tbl(l_index) := inv_trolin_util.g_line;
537: ELSIF p_attr_id = g_line_number THEN

Line 536: l_src_attr_tbl(l_index) := inv_trolin_util.g_line;

532: l_index := l_index + 1;
533: l_src_attr_tbl(l_index) := inv_trolin_util.g_last_update_login;
534: ELSIF p_attr_id = g_line THEN
535: l_index := l_index + 1;
536: l_src_attr_tbl(l_index) := inv_trolin_util.g_line;
537: ELSIF p_attr_id = g_line_number THEN
538: l_index := l_index + 1;
539: l_src_attr_tbl(l_index) := inv_trolin_util.g_line_number;
540: ELSIF p_attr_id = g_line_status THEN

Line 539: l_src_attr_tbl(l_index) := inv_trolin_util.g_line_number;

535: l_index := l_index + 1;
536: l_src_attr_tbl(l_index) := inv_trolin_util.g_line;
537: ELSIF p_attr_id = g_line_number THEN
538: l_index := l_index + 1;
539: l_src_attr_tbl(l_index) := inv_trolin_util.g_line_number;
540: ELSIF p_attr_id = g_line_status THEN
541: l_index := l_index + 1;
542: l_src_attr_tbl(l_index) := inv_trolin_util.g_line_status;
543: ELSIF p_attr_id = g_lot_number THEN

Line 542: l_src_attr_tbl(l_index) := inv_trolin_util.g_line_status;

538: l_index := l_index + 1;
539: l_src_attr_tbl(l_index) := inv_trolin_util.g_line_number;
540: ELSIF p_attr_id = g_line_status THEN
541: l_index := l_index + 1;
542: l_src_attr_tbl(l_index) := inv_trolin_util.g_line_status;
543: ELSIF p_attr_id = g_lot_number THEN
544: l_index := l_index + 1;
545: l_src_attr_tbl(l_index) := inv_trolin_util.g_lot_number;
546: ELSIF p_attr_id = g_organization THEN

Line 545: l_src_attr_tbl(l_index) := inv_trolin_util.g_lot_number;

541: l_index := l_index + 1;
542: l_src_attr_tbl(l_index) := inv_trolin_util.g_line_status;
543: ELSIF p_attr_id = g_lot_number THEN
544: l_index := l_index + 1;
545: l_src_attr_tbl(l_index) := inv_trolin_util.g_lot_number;
546: ELSIF p_attr_id = g_organization THEN
547: l_index := l_index + 1;
548: l_src_attr_tbl(l_index) := inv_trolin_util.g_organization;
549: ELSIF p_attr_id = g_program_application THEN

Line 548: l_src_attr_tbl(l_index) := inv_trolin_util.g_organization;

544: l_index := l_index + 1;
545: l_src_attr_tbl(l_index) := inv_trolin_util.g_lot_number;
546: ELSIF p_attr_id = g_organization THEN
547: l_index := l_index + 1;
548: l_src_attr_tbl(l_index) := inv_trolin_util.g_organization;
549: ELSIF p_attr_id = g_program_application THEN
550: l_index := l_index + 1;
551: l_src_attr_tbl(l_index) := inv_trolin_util.g_program_application;
552: ELSIF p_attr_id = g_program THEN

Line 551: l_src_attr_tbl(l_index) := inv_trolin_util.g_program_application;

547: l_index := l_index + 1;
548: l_src_attr_tbl(l_index) := inv_trolin_util.g_organization;
549: ELSIF p_attr_id = g_program_application THEN
550: l_index := l_index + 1;
551: l_src_attr_tbl(l_index) := inv_trolin_util.g_program_application;
552: ELSIF p_attr_id = g_program THEN
553: l_index := l_index + 1;
554: l_src_attr_tbl(l_index) := inv_trolin_util.g_program;
555: ELSIF p_attr_id = g_program_update_date THEN

Line 554: l_src_attr_tbl(l_index) := inv_trolin_util.g_program;

550: l_index := l_index + 1;
551: l_src_attr_tbl(l_index) := inv_trolin_util.g_program_application;
552: ELSIF p_attr_id = g_program THEN
553: l_index := l_index + 1;
554: l_src_attr_tbl(l_index) := inv_trolin_util.g_program;
555: ELSIF p_attr_id = g_program_update_date THEN
556: l_index := l_index + 1;
557: l_src_attr_tbl(l_index) := inv_trolin_util.g_program_update_date;
558: ELSIF p_attr_id = g_project THEN

Line 557: l_src_attr_tbl(l_index) := inv_trolin_util.g_program_update_date;

553: l_index := l_index + 1;
554: l_src_attr_tbl(l_index) := inv_trolin_util.g_program;
555: ELSIF p_attr_id = g_program_update_date THEN
556: l_index := l_index + 1;
557: l_src_attr_tbl(l_index) := inv_trolin_util.g_program_update_date;
558: ELSIF p_attr_id = g_project THEN
559: l_index := l_index + 1;
560: l_src_attr_tbl(l_index) := inv_trolin_util.g_project;
561: ELSIF p_attr_id = g_quantity THEN

Line 560: l_src_attr_tbl(l_index) := inv_trolin_util.g_project;

556: l_index := l_index + 1;
557: l_src_attr_tbl(l_index) := inv_trolin_util.g_program_update_date;
558: ELSIF p_attr_id = g_project THEN
559: l_index := l_index + 1;
560: l_src_attr_tbl(l_index) := inv_trolin_util.g_project;
561: ELSIF p_attr_id = g_quantity THEN
562: l_index := l_index + 1;
563: l_src_attr_tbl(l_index) := inv_trolin_util.g_quantity;
564: ELSIF p_attr_id = g_quantity_delivered THEN

Line 563: l_src_attr_tbl(l_index) := inv_trolin_util.g_quantity;

559: l_index := l_index + 1;
560: l_src_attr_tbl(l_index) := inv_trolin_util.g_project;
561: ELSIF p_attr_id = g_quantity THEN
562: l_index := l_index + 1;
563: l_src_attr_tbl(l_index) := inv_trolin_util.g_quantity;
564: ELSIF p_attr_id = g_quantity_delivered THEN
565: l_index := l_index + 1;
566: l_src_attr_tbl(l_index) := inv_trolin_util.g_quantity_delivered;
567: ELSIF p_attr_id = g_quantity_detailed THEN

Line 566: l_src_attr_tbl(l_index) := inv_trolin_util.g_quantity_delivered;

562: l_index := l_index + 1;
563: l_src_attr_tbl(l_index) := inv_trolin_util.g_quantity;
564: ELSIF p_attr_id = g_quantity_delivered THEN
565: l_index := l_index + 1;
566: l_src_attr_tbl(l_index) := inv_trolin_util.g_quantity_delivered;
567: ELSIF p_attr_id = g_quantity_detailed THEN
568: l_index := l_index + 1;
569: l_src_attr_tbl(l_index) := inv_trolin_util.g_quantity_detailed;
570: ELSIF p_attr_id = g_reason THEN

Line 569: l_src_attr_tbl(l_index) := inv_trolin_util.g_quantity_detailed;

565: l_index := l_index + 1;
566: l_src_attr_tbl(l_index) := inv_trolin_util.g_quantity_delivered;
567: ELSIF p_attr_id = g_quantity_detailed THEN
568: l_index := l_index + 1;
569: l_src_attr_tbl(l_index) := inv_trolin_util.g_quantity_detailed;
570: ELSIF p_attr_id = g_reason THEN
571: l_index := l_index + 1;
572: l_src_attr_tbl(l_index) := inv_trolin_util.g_reason;
573: ELSIF p_attr_id = g_reference THEN

Line 572: l_src_attr_tbl(l_index) := inv_trolin_util.g_reason;

568: l_index := l_index + 1;
569: l_src_attr_tbl(l_index) := inv_trolin_util.g_quantity_detailed;
570: ELSIF p_attr_id = g_reason THEN
571: l_index := l_index + 1;
572: l_src_attr_tbl(l_index) := inv_trolin_util.g_reason;
573: ELSIF p_attr_id = g_reference THEN
574: l_index := l_index + 1;
575: l_src_attr_tbl(l_index) := inv_trolin_util.g_reference;
576: ELSIF p_attr_id = g_reference THEN

Line 575: l_src_attr_tbl(l_index) := inv_trolin_util.g_reference;

571: l_index := l_index + 1;
572: l_src_attr_tbl(l_index) := inv_trolin_util.g_reason;
573: ELSIF p_attr_id = g_reference THEN
574: l_index := l_index + 1;
575: l_src_attr_tbl(l_index) := inv_trolin_util.g_reference;
576: ELSIF p_attr_id = g_reference THEN
577: l_index := l_index + 1;
578: l_src_attr_tbl(l_index) := inv_trolin_util.g_reference;
579: ELSIF p_attr_id = g_reference_type THEN

Line 578: l_src_attr_tbl(l_index) := inv_trolin_util.g_reference;

574: l_index := l_index + 1;
575: l_src_attr_tbl(l_index) := inv_trolin_util.g_reference;
576: ELSIF p_attr_id = g_reference THEN
577: l_index := l_index + 1;
578: l_src_attr_tbl(l_index) := inv_trolin_util.g_reference;
579: ELSIF p_attr_id = g_reference_type THEN
580: l_index := l_index + 1;
581: l_src_attr_tbl(l_index) := inv_trolin_util.g_reference_type;
582: ELSIF p_attr_id = g_request THEN

Line 581: l_src_attr_tbl(l_index) := inv_trolin_util.g_reference_type;

577: l_index := l_index + 1;
578: l_src_attr_tbl(l_index) := inv_trolin_util.g_reference;
579: ELSIF p_attr_id = g_reference_type THEN
580: l_index := l_index + 1;
581: l_src_attr_tbl(l_index) := inv_trolin_util.g_reference_type;
582: ELSIF p_attr_id = g_request THEN
583: l_index := l_index + 1;
584: l_src_attr_tbl(l_index) := inv_trolin_util.g_request;
585: ELSIF p_attr_id = g_revision THEN

Line 584: l_src_attr_tbl(l_index) := inv_trolin_util.g_request;

580: l_index := l_index + 1;
581: l_src_attr_tbl(l_index) := inv_trolin_util.g_reference_type;
582: ELSIF p_attr_id = g_request THEN
583: l_index := l_index + 1;
584: l_src_attr_tbl(l_index) := inv_trolin_util.g_request;
585: ELSIF p_attr_id = g_revision THEN
586: l_index := l_index + 1;
587: l_src_attr_tbl(l_index) := inv_trolin_util.g_revision;
588: ELSIF p_attr_id = g_serial_number_end THEN

Line 587: l_src_attr_tbl(l_index) := inv_trolin_util.g_revision;

583: l_index := l_index + 1;
584: l_src_attr_tbl(l_index) := inv_trolin_util.g_request;
585: ELSIF p_attr_id = g_revision THEN
586: l_index := l_index + 1;
587: l_src_attr_tbl(l_index) := inv_trolin_util.g_revision;
588: ELSIF p_attr_id = g_serial_number_end THEN
589: l_index := l_index + 1;
590: l_src_attr_tbl(l_index) := inv_trolin_util.g_serial_number_end;
591: ELSIF p_attr_id = g_serial_number_start THEN

Line 590: l_src_attr_tbl(l_index) := inv_trolin_util.g_serial_number_end;

586: l_index := l_index + 1;
587: l_src_attr_tbl(l_index) := inv_trolin_util.g_revision;
588: ELSIF p_attr_id = g_serial_number_end THEN
589: l_index := l_index + 1;
590: l_src_attr_tbl(l_index) := inv_trolin_util.g_serial_number_end;
591: ELSIF p_attr_id = g_serial_number_start THEN
592: l_index := l_index + 1;
593: l_src_attr_tbl(l_index) := inv_trolin_util.g_serial_number_start;
594: ELSIF p_attr_id = g_status_date THEN

Line 593: l_src_attr_tbl(l_index) := inv_trolin_util.g_serial_number_start;

589: l_index := l_index + 1;
590: l_src_attr_tbl(l_index) := inv_trolin_util.g_serial_number_end;
591: ELSIF p_attr_id = g_serial_number_start THEN
592: l_index := l_index + 1;
593: l_src_attr_tbl(l_index) := inv_trolin_util.g_serial_number_start;
594: ELSIF p_attr_id = g_status_date THEN
595: l_index := l_index + 1;
596: l_src_attr_tbl(l_index) := inv_trolin_util.g_status_date;
597: ELSIF p_attr_id = g_task THEN

Line 596: l_src_attr_tbl(l_index) := inv_trolin_util.g_status_date;

592: l_index := l_index + 1;
593: l_src_attr_tbl(l_index) := inv_trolin_util.g_serial_number_start;
594: ELSIF p_attr_id = g_status_date THEN
595: l_index := l_index + 1;
596: l_src_attr_tbl(l_index) := inv_trolin_util.g_status_date;
597: ELSIF p_attr_id = g_task THEN
598: l_index := l_index + 1;
599: l_src_attr_tbl(l_index) := inv_trolin_util.g_task;
600: ELSIF p_attr_id = g_to_account THEN

Line 599: l_src_attr_tbl(l_index) := inv_trolin_util.g_task;

595: l_index := l_index + 1;
596: l_src_attr_tbl(l_index) := inv_trolin_util.g_status_date;
597: ELSIF p_attr_id = g_task THEN
598: l_index := l_index + 1;
599: l_src_attr_tbl(l_index) := inv_trolin_util.g_task;
600: ELSIF p_attr_id = g_to_account THEN
601: l_index := l_index + 1;
602: l_src_attr_tbl(l_index) := inv_trolin_util.g_to_account;
603: ELSIF p_attr_id = g_to_locator THEN

Line 602: l_src_attr_tbl(l_index) := inv_trolin_util.g_to_account;

598: l_index := l_index + 1;
599: l_src_attr_tbl(l_index) := inv_trolin_util.g_task;
600: ELSIF p_attr_id = g_to_account THEN
601: l_index := l_index + 1;
602: l_src_attr_tbl(l_index) := inv_trolin_util.g_to_account;
603: ELSIF p_attr_id = g_to_locator THEN
604: l_index := l_index + 1;
605: l_src_attr_tbl(l_index) := inv_trolin_util.g_to_locator;
606: ELSIF p_attr_id = g_to_subinventory THEN

Line 605: l_src_attr_tbl(l_index) := inv_trolin_util.g_to_locator;

601: l_index := l_index + 1;
602: l_src_attr_tbl(l_index) := inv_trolin_util.g_to_account;
603: ELSIF p_attr_id = g_to_locator THEN
604: l_index := l_index + 1;
605: l_src_attr_tbl(l_index) := inv_trolin_util.g_to_locator;
606: ELSIF p_attr_id = g_to_subinventory THEN
607: l_index := l_index + 1;
608: l_src_attr_tbl(l_index) := inv_trolin_util.g_to_subinventory;
609: ELSIF p_attr_id = g_to_subinventory THEN

Line 608: l_src_attr_tbl(l_index) := inv_trolin_util.g_to_subinventory;

604: l_index := l_index + 1;
605: l_src_attr_tbl(l_index) := inv_trolin_util.g_to_locator;
606: ELSIF p_attr_id = g_to_subinventory THEN
607: l_index := l_index + 1;
608: l_src_attr_tbl(l_index) := inv_trolin_util.g_to_subinventory;
609: ELSIF p_attr_id = g_to_subinventory THEN
610: l_index := l_index + 1;
611: l_src_attr_tbl(l_index) := inv_trolin_util.g_to_subinventory;
612: ELSIF p_attr_id = g_transaction_header THEN

Line 611: l_src_attr_tbl(l_index) := inv_trolin_util.g_to_subinventory;

607: l_index := l_index + 1;
608: l_src_attr_tbl(l_index) := inv_trolin_util.g_to_subinventory;
609: ELSIF p_attr_id = g_to_subinventory THEN
610: l_index := l_index + 1;
611: l_src_attr_tbl(l_index) := inv_trolin_util.g_to_subinventory;
612: ELSIF p_attr_id = g_transaction_header THEN
613: l_index := l_index + 1;
614: l_src_attr_tbl(l_index) := inv_trolin_util.g_transaction_header;
615: ELSIF p_attr_id = g_uom THEN

Line 614: l_src_attr_tbl(l_index) := inv_trolin_util.g_transaction_header;

610: l_index := l_index + 1;
611: l_src_attr_tbl(l_index) := inv_trolin_util.g_to_subinventory;
612: ELSIF p_attr_id = g_transaction_header THEN
613: l_index := l_index + 1;
614: l_src_attr_tbl(l_index) := inv_trolin_util.g_transaction_header;
615: ELSIF p_attr_id = g_uom THEN
616: l_index := l_index + 1;
617: l_src_attr_tbl(l_index) := inv_trolin_util.g_uom;
618: ELSIF p_attr_id = g_txn_source_id THEN

Line 617: l_src_attr_tbl(l_index) := inv_trolin_util.g_uom;

613: l_index := l_index + 1;
614: l_src_attr_tbl(l_index) := inv_trolin_util.g_transaction_header;
615: ELSIF p_attr_id = g_uom THEN
616: l_index := l_index + 1;
617: l_src_attr_tbl(l_index) := inv_trolin_util.g_uom;
618: ELSIF p_attr_id = g_txn_source_id THEN
619: l_index := l_index + 1;
620: l_src_attr_tbl(l_index) := inv_trolin_util.g_txn_source_id;
621: ELSIF p_attr_id = g_txn_source_line_id THEN

Line 620: l_src_attr_tbl(l_index) := inv_trolin_util.g_txn_source_id;

616: l_index := l_index + 1;
617: l_src_attr_tbl(l_index) := inv_trolin_util.g_uom;
618: ELSIF p_attr_id = g_txn_source_id THEN
619: l_index := l_index + 1;
620: l_src_attr_tbl(l_index) := inv_trolin_util.g_txn_source_id;
621: ELSIF p_attr_id = g_txn_source_line_id THEN
622: l_index := l_index + 1;
623: l_src_attr_tbl(l_index) := inv_trolin_util.g_txn_source_line_id;
624: ELSIF p_attr_id = g_txn_source_line_detail_id THEN

Line 623: l_src_attr_tbl(l_index) := inv_trolin_util.g_txn_source_line_id;

619: l_index := l_index + 1;
620: l_src_attr_tbl(l_index) := inv_trolin_util.g_txn_source_id;
621: ELSIF p_attr_id = g_txn_source_line_id THEN
622: l_index := l_index + 1;
623: l_src_attr_tbl(l_index) := inv_trolin_util.g_txn_source_line_id;
624: ELSIF p_attr_id = g_txn_source_line_detail_id THEN
625: l_index := l_index + 1;
626: l_src_attr_tbl(l_index) := inv_trolin_util.g_txn_source_line_detail_id;
627: ELSIF p_attr_id = g_transaction_type_id THEN

Line 626: l_src_attr_tbl(l_index) := inv_trolin_util.g_txn_source_line_detail_id;

622: l_index := l_index + 1;
623: l_src_attr_tbl(l_index) := inv_trolin_util.g_txn_source_line_id;
624: ELSIF p_attr_id = g_txn_source_line_detail_id THEN
625: l_index := l_index + 1;
626: l_src_attr_tbl(l_index) := inv_trolin_util.g_txn_source_line_detail_id;
627: ELSIF p_attr_id = g_transaction_type_id THEN
628: l_index := l_index + 1;
629: l_src_attr_tbl(l_index) := inv_trolin_util.g_transaction_type_id;
630: ELSIF p_attr_id = g_transaction_source_type_id THEN

Line 629: l_src_attr_tbl(l_index) := inv_trolin_util.g_transaction_type_id;

625: l_index := l_index + 1;
626: l_src_attr_tbl(l_index) := inv_trolin_util.g_txn_source_line_detail_id;
627: ELSIF p_attr_id = g_transaction_type_id THEN
628: l_index := l_index + 1;
629: l_src_attr_tbl(l_index) := inv_trolin_util.g_transaction_type_id;
630: ELSIF p_attr_id = g_transaction_source_type_id THEN
631: l_index := l_index + 1;
632: l_src_attr_tbl(l_index) := inv_trolin_util.g_transaction_source_type_id;
633: ELSIF p_attr_id = g_primary_quantity THEN

Line 632: l_src_attr_tbl(l_index) := inv_trolin_util.g_transaction_source_type_id;

628: l_index := l_index + 1;
629: l_src_attr_tbl(l_index) := inv_trolin_util.g_transaction_type_id;
630: ELSIF p_attr_id = g_transaction_source_type_id THEN
631: l_index := l_index + 1;
632: l_src_attr_tbl(l_index) := inv_trolin_util.g_transaction_source_type_id;
633: ELSIF p_attr_id = g_primary_quantity THEN
634: l_index := l_index + 1;
635: l_src_attr_tbl(l_index) := inv_trolin_util.g_primary_quantity;
636: ELSIF p_attr_id = g_to_organization_id THEN

Line 635: l_src_attr_tbl(l_index) := inv_trolin_util.g_primary_quantity;

631: l_index := l_index + 1;
632: l_src_attr_tbl(l_index) := inv_trolin_util.g_transaction_source_type_id;
633: ELSIF p_attr_id = g_primary_quantity THEN
634: l_index := l_index + 1;
635: l_src_attr_tbl(l_index) := inv_trolin_util.g_primary_quantity;
636: ELSIF p_attr_id = g_to_organization_id THEN
637: l_index := l_index + 1;
638: l_src_attr_tbl(l_index) := inv_trolin_util.g_to_organization_id;
639: ELSIF p_attr_id = g_put_away_strategy_id THEN

Line 638: l_src_attr_tbl(l_index) := inv_trolin_util.g_to_organization_id;

634: l_index := l_index + 1;
635: l_src_attr_tbl(l_index) := inv_trolin_util.g_primary_quantity;
636: ELSIF p_attr_id = g_to_organization_id THEN
637: l_index := l_index + 1;
638: l_src_attr_tbl(l_index) := inv_trolin_util.g_to_organization_id;
639: ELSIF p_attr_id = g_put_away_strategy_id THEN
640: l_index := l_index + 1;
641: l_src_attr_tbl(l_index) := inv_trolin_util.g_put_away_strategy_id;
642: ELSIF p_attr_id = g_pick_strategy_id THEN

Line 641: l_src_attr_tbl(l_index) := inv_trolin_util.g_put_away_strategy_id;

637: l_index := l_index + 1;
638: l_src_attr_tbl(l_index) := inv_trolin_util.g_to_organization_id;
639: ELSIF p_attr_id = g_put_away_strategy_id THEN
640: l_index := l_index + 1;
641: l_src_attr_tbl(l_index) := inv_trolin_util.g_put_away_strategy_id;
642: ELSIF p_attr_id = g_pick_strategy_id THEN
643: l_index := l_index + 1;
644: l_src_attr_tbl(l_index) := inv_trolin_util.g_pick_strategy_id;
645: ELSIF p_attr_id = g_unit_number THEN

Line 644: l_src_attr_tbl(l_index) := inv_trolin_util.g_pick_strategy_id;

640: l_index := l_index + 1;
641: l_src_attr_tbl(l_index) := inv_trolin_util.g_put_away_strategy_id;
642: ELSIF p_attr_id = g_pick_strategy_id THEN
643: l_index := l_index + 1;
644: l_src_attr_tbl(l_index) := inv_trolin_util.g_pick_strategy_id;
645: ELSIF p_attr_id = g_unit_number THEN
646: l_index := l_index + 1;
647: l_src_attr_tbl(l_index) := inv_trolin_util.g_unit_number;
648: ELSIF p_attr_id = g_ship_to_location_id THEN

Line 647: l_src_attr_tbl(l_index) := inv_trolin_util.g_unit_number;

643: l_index := l_index + 1;
644: l_src_attr_tbl(l_index) := inv_trolin_util.g_pick_strategy_id;
645: ELSIF p_attr_id = g_unit_number THEN
646: l_index := l_index + 1;
647: l_src_attr_tbl(l_index) := inv_trolin_util.g_unit_number;
648: ELSIF p_attr_id = g_ship_to_location_id THEN
649: l_index := l_index + 1;
650: l_src_attr_tbl(l_index) := inv_trolin_util.g_ship_to_location_id;
651: ELSIF p_attr_id = g_from_cost_group_id THEN

Line 650: l_src_attr_tbl(l_index) := inv_trolin_util.g_ship_to_location_id;

646: l_index := l_index + 1;
647: l_src_attr_tbl(l_index) := inv_trolin_util.g_unit_number;
648: ELSIF p_attr_id = g_ship_to_location_id THEN
649: l_index := l_index + 1;
650: l_src_attr_tbl(l_index) := inv_trolin_util.g_ship_to_location_id;
651: ELSIF p_attr_id = g_from_cost_group_id THEN
652: l_index := l_index + 1;
653: l_src_attr_tbl(l_index) := inv_trolin_util.g_from_cost_group_id;
654: ELSIF p_attr_id = g_to_cost_group_id THEN

Line 653: l_src_attr_tbl(l_index) := inv_trolin_util.g_from_cost_group_id;

649: l_index := l_index + 1;
650: l_src_attr_tbl(l_index) := inv_trolin_util.g_ship_to_location_id;
651: ELSIF p_attr_id = g_from_cost_group_id THEN
652: l_index := l_index + 1;
653: l_src_attr_tbl(l_index) := inv_trolin_util.g_from_cost_group_id;
654: ELSIF p_attr_id = g_to_cost_group_id THEN
655: l_index := l_index + 1;
656: l_src_attr_tbl(l_index) := inv_trolin_util.g_to_cost_group_id;
657: ELSIF p_attr_id = g_lpn_id THEN

Line 656: l_src_attr_tbl(l_index) := inv_trolin_util.g_to_cost_group_id;

652: l_index := l_index + 1;
653: l_src_attr_tbl(l_index) := inv_trolin_util.g_from_cost_group_id;
654: ELSIF p_attr_id = g_to_cost_group_id THEN
655: l_index := l_index + 1;
656: l_src_attr_tbl(l_index) := inv_trolin_util.g_to_cost_group_id;
657: ELSIF p_attr_id = g_lpn_id THEN
658: l_index := l_index + 1;
659: l_src_attr_tbl(l_index) := inv_trolin_util.g_lpn_id;
660: ELSIF p_attr_id = g_to_lpn_id THEN

Line 659: l_src_attr_tbl(l_index) := inv_trolin_util.g_lpn_id;

655: l_index := l_index + 1;
656: l_src_attr_tbl(l_index) := inv_trolin_util.g_to_cost_group_id;
657: ELSIF p_attr_id = g_lpn_id THEN
658: l_index := l_index + 1;
659: l_src_attr_tbl(l_index) := inv_trolin_util.g_lpn_id;
660: ELSIF p_attr_id = g_to_lpn_id THEN
661: l_index := l_index + 1;
662: l_src_attr_tbl(l_index) := inv_trolin_util.g_to_lpn_id;
663: ELSIF p_attr_id = g_pick_methodology_id THEN

Line 662: l_src_attr_tbl(l_index) := inv_trolin_util.g_to_lpn_id;

658: l_index := l_index + 1;
659: l_src_attr_tbl(l_index) := inv_trolin_util.g_lpn_id;
660: ELSIF p_attr_id = g_to_lpn_id THEN
661: l_index := l_index + 1;
662: l_src_attr_tbl(l_index) := inv_trolin_util.g_to_lpn_id;
663: ELSIF p_attr_id = g_pick_methodology_id THEN
664: l_index := l_index + 1;
665: l_src_attr_tbl(l_index) := inv_trolin_util.g_pick_methodology_id;
666: ELSIF p_attr_id = g_container_item_id THEN

Line 665: l_src_attr_tbl(l_index) := inv_trolin_util.g_pick_methodology_id;

661: l_index := l_index + 1;
662: l_src_attr_tbl(l_index) := inv_trolin_util.g_to_lpn_id;
663: ELSIF p_attr_id = g_pick_methodology_id THEN
664: l_index := l_index + 1;
665: l_src_attr_tbl(l_index) := inv_trolin_util.g_pick_methodology_id;
666: ELSIF p_attr_id = g_container_item_id THEN
667: l_index := l_index + 1;
668: l_src_attr_tbl(l_index) := inv_trolin_util.g_container_item_id;
669: ELSIF p_attr_id = g_carton_grouping_id THEN

Line 668: l_src_attr_tbl(l_index) := inv_trolin_util.g_container_item_id;

664: l_index := l_index + 1;
665: l_src_attr_tbl(l_index) := inv_trolin_util.g_pick_methodology_id;
666: ELSIF p_attr_id = g_container_item_id THEN
667: l_index := l_index + 1;
668: l_src_attr_tbl(l_index) := inv_trolin_util.g_container_item_id;
669: ELSIF p_attr_id = g_carton_grouping_id THEN
670: l_index := l_index + 1;
671: l_src_attr_tbl(l_index) := inv_trolin_util.g_carton_grouping_id;
672: ELSIF p_attr_id = g_pick_slip_number THEN

Line 671: l_src_attr_tbl(l_index) := inv_trolin_util.g_carton_grouping_id;

667: l_index := l_index + 1;
668: l_src_attr_tbl(l_index) := inv_trolin_util.g_container_item_id;
669: ELSIF p_attr_id = g_carton_grouping_id THEN
670: l_index := l_index + 1;
671: l_src_attr_tbl(l_index) := inv_trolin_util.g_carton_grouping_id;
672: ELSIF p_attr_id = g_pick_slip_number THEN
673: l_index := l_index + 1;
674: l_src_attr_tbl(l_index) := inv_trolin_util.g_pick_slip_number;
675: ELSIF p_attr_id = g_pick_slip_date THEN

Line 674: l_src_attr_tbl(l_index) := inv_trolin_util.g_pick_slip_number;

670: l_index := l_index + 1;
671: l_src_attr_tbl(l_index) := inv_trolin_util.g_carton_grouping_id;
672: ELSIF p_attr_id = g_pick_slip_number THEN
673: l_index := l_index + 1;
674: l_src_attr_tbl(l_index) := inv_trolin_util.g_pick_slip_number;
675: ELSIF p_attr_id = g_pick_slip_date THEN
676: l_index := l_index + 1;
677: l_src_attr_tbl(l_index) := inv_trolin_util.g_pick_slip_date;
678: ELSIF p_attr_id = g_ship_set_id THEN

Line 677: l_src_attr_tbl(l_index) := inv_trolin_util.g_pick_slip_date;

673: l_index := l_index + 1;
674: l_src_attr_tbl(l_index) := inv_trolin_util.g_pick_slip_number;
675: ELSIF p_attr_id = g_pick_slip_date THEN
676: l_index := l_index + 1;
677: l_src_attr_tbl(l_index) := inv_trolin_util.g_pick_slip_date;
678: ELSIF p_attr_id = g_ship_set_id THEN
679: l_index := l_index + 1;
680: l_src_attr_tbl(l_index) := inv_trolin_util.g_ship_set_id;
681: ELSIF p_attr_id = g_ship_model_id THEN

Line 680: l_src_attr_tbl(l_index) := inv_trolin_util.g_ship_set_id;

676: l_index := l_index + 1;
677: l_src_attr_tbl(l_index) := inv_trolin_util.g_pick_slip_date;
678: ELSIF p_attr_id = g_ship_set_id THEN
679: l_index := l_index + 1;
680: l_src_attr_tbl(l_index) := inv_trolin_util.g_ship_set_id;
681: ELSIF p_attr_id = g_ship_model_id THEN
682: l_index := l_index + 1;
683: l_src_attr_tbl(l_index) := inv_trolin_util.g_ship_model_id;
684: ELSIF p_attr_id = g_model_quantity THEN

Line 683: l_src_attr_tbl(l_index) := inv_trolin_util.g_ship_model_id;

679: l_index := l_index + 1;
680: l_src_attr_tbl(l_index) := inv_trolin_util.g_ship_set_id;
681: ELSIF p_attr_id = g_ship_model_id THEN
682: l_index := l_index + 1;
683: l_src_attr_tbl(l_index) := inv_trolin_util.g_ship_model_id;
684: ELSIF p_attr_id = g_model_quantity THEN
685: l_index := l_index + 1;
686: l_src_attr_tbl(l_index) := inv_trolin_util.g_model_quantity;
687: ELSIF p_attr_id = g_required_quantity THEN

Line 686: l_src_attr_tbl(l_index) := inv_trolin_util.g_model_quantity;

682: l_index := l_index + 1;
683: l_src_attr_tbl(l_index) := inv_trolin_util.g_ship_model_id;
684: ELSIF p_attr_id = g_model_quantity THEN
685: l_index := l_index + 1;
686: l_src_attr_tbl(l_index) := inv_trolin_util.g_model_quantity;
687: ELSIF p_attr_id = g_required_quantity THEN
688: l_index := l_index + 1;
689: l_src_attr_tbl(l_index) := inv_trolin_util.g_required_quantity;
690: --INVCONV BEGIN

Line 689: l_src_attr_tbl(l_index) := inv_trolin_util.g_required_quantity;

685: l_index := l_index + 1;
686: l_src_attr_tbl(l_index) := inv_trolin_util.g_model_quantity;
687: ELSIF p_attr_id = g_required_quantity THEN
688: l_index := l_index + 1;
689: l_src_attr_tbl(l_index) := inv_trolin_util.g_required_quantity;
690: --INVCONV BEGIN
691: ELSIF p_attr_id = g_secondary_quantity THEN
692: l_index := l_index + 1;
693: l_src_attr_tbl(l_index) := inv_trolin_util.g_secondary_quantity;

Line 693: l_src_attr_tbl(l_index) := inv_trolin_util.g_secondary_quantity;

689: l_src_attr_tbl(l_index) := inv_trolin_util.g_required_quantity;
690: --INVCONV BEGIN
691: ELSIF p_attr_id = g_secondary_quantity THEN
692: l_index := l_index + 1;
693: l_src_attr_tbl(l_index) := inv_trolin_util.g_secondary_quantity;
694: ELSIF p_attr_id = g_secondary_quantity_delivered THEN
695: l_index := l_index + 1;
696: l_src_attr_tbl(l_index) := inv_trolin_util.g_secondary_quantity_delivered;
697: ELSIF p_attr_id = g_secondary_quantity_detailed THEN

Line 696: l_src_attr_tbl(l_index) := inv_trolin_util.g_secondary_quantity_delivered;

692: l_index := l_index + 1;
693: l_src_attr_tbl(l_index) := inv_trolin_util.g_secondary_quantity;
694: ELSIF p_attr_id = g_secondary_quantity_delivered THEN
695: l_index := l_index + 1;
696: l_src_attr_tbl(l_index) := inv_trolin_util.g_secondary_quantity_delivered;
697: ELSIF p_attr_id = g_secondary_quantity_detailed THEN
698: l_index := l_index + 1;
699: l_src_attr_tbl(l_index) := inv_trolin_util.g_secondary_quantity_detailed;
700: ELSIF p_attr_id = g_secondary_required_quantity THEN

Line 699: l_src_attr_tbl(l_index) := inv_trolin_util.g_secondary_quantity_detailed;

695: l_index := l_index + 1;
696: l_src_attr_tbl(l_index) := inv_trolin_util.g_secondary_quantity_delivered;
697: ELSIF p_attr_id = g_secondary_quantity_detailed THEN
698: l_index := l_index + 1;
699: l_src_attr_tbl(l_index) := inv_trolin_util.g_secondary_quantity_detailed;
700: ELSIF p_attr_id = g_secondary_required_quantity THEN
701: l_index := l_index + 1;
702: l_src_attr_tbl(l_index) := inv_trolin_util.g_secondary_required_quantity;
703: ELSIF p_attr_id = g_secondary_uom THEN

Line 702: l_src_attr_tbl(l_index) := inv_trolin_util.g_secondary_required_quantity;

698: l_index := l_index + 1;
699: l_src_attr_tbl(l_index) := inv_trolin_util.g_secondary_quantity_detailed;
700: ELSIF p_attr_id = g_secondary_required_quantity THEN
701: l_index := l_index + 1;
702: l_src_attr_tbl(l_index) := inv_trolin_util.g_secondary_required_quantity;
703: ELSIF p_attr_id = g_secondary_uom THEN
704: l_index := l_index + 1;
705: l_src_attr_tbl(l_index) := inv_trolin_util.g_secondary_uom;
706: ELSIF p_attr_id = g_grade_code THEN

Line 705: l_src_attr_tbl(l_index) := inv_trolin_util.g_secondary_uom;

701: l_index := l_index + 1;
702: l_src_attr_tbl(l_index) := inv_trolin_util.g_secondary_required_quantity;
703: ELSIF p_attr_id = g_secondary_uom THEN
704: l_index := l_index + 1;
705: l_src_attr_tbl(l_index) := inv_trolin_util.g_secondary_uom;
706: ELSIF p_attr_id = g_grade_code THEN
707: l_index := l_index + 1;
708: l_src_attr_tbl(l_index) := inv_trolin_util.g_grade_code;
709: --INVCONV END

Line 708: l_src_attr_tbl(l_index) := inv_trolin_util.g_grade_code;

704: l_index := l_index + 1;
705: l_src_attr_tbl(l_index) := inv_trolin_util.g_secondary_uom;
706: ELSIF p_attr_id = g_grade_code THEN
707: l_index := l_index + 1;
708: l_src_attr_tbl(l_index) := inv_trolin_util.g_grade_code;
709: --INVCONV END
710: END IF;
711: END clear_dependent_attr;
712:

Line 1697: l_trolin_rec := inv_trolin_util.convert_miss_to_null(p_trolin_rec => l_trolin_rec);

1693: RETURN inv_move_order_pub.trolin_rec_type IS
1694: l_trolin_rec inv_move_order_pub.trolin_rec_type := p_trolin_rec;
1695:
1696: BEGIN
1697: l_trolin_rec := inv_trolin_util.convert_miss_to_null(p_trolin_rec => l_trolin_rec);
1698:
1699: IF l_trolin_rec.transaction_type_id = FND_API.G_MISS_NUM THEN
1700: l_trolin_rec.transaction_type_id := NULL;
1701: END IF;

Line 1998: l_trolin_rec := inv_trolin_util.query_row(p_line_id);

1994:
1995: PROCEDURE update_row_status(p_line_id IN NUMBER, p_status IN NUMBER) IS
1996: l_trolin_rec inv_move_order_pub.trolin_rec_type;
1997: BEGIN
1998: l_trolin_rec := inv_trolin_util.query_row(p_line_id);
1999: l_trolin_rec.line_status := p_status;
2000: l_trolin_rec.last_update_date := SYSDATE;
2001: l_trolin_rec.status_date := SYSDATE; -- For Bug # 5053725
2002: l_trolin_rec.last_updated_by := fnd_global.user_id;

Line 2004: inv_trolin_util.update_row(l_trolin_rec);

2000: l_trolin_rec.last_update_date := SYSDATE;
2001: l_trolin_rec.status_date := SYSDATE; -- For Bug # 5053725
2002: l_trolin_rec.last_updated_by := fnd_global.user_id;
2003: l_trolin_rec.last_update_login := fnd_global.login_id;
2004: inv_trolin_util.update_row(l_trolin_rec);
2005: EXCEPTION
2006: WHEN OTHERS THEN
2007: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2008: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Update_Row_Status');

Line 3779: END inv_trolin_util;

3775: x_return_status := fnd_api.g_ret_sts_error;
3776: RAISE fnd_api.g_exc_unexpected_error;
3777: END insert_mo_lines_bulk;
3778:
3779: END inv_trolin_util;