[Home] [Help]
13: , p_old_trolin_rec IN inv_move_order_pub.trolin_rec_type := inv_move_order_pub.g_miss_trolin_rec
14: , x_trolin_rec IN OUT NOCOPY inv_move_order_pub.trolin_rec_type
15: ) IS
16: l_index NUMBER := 0;
17: l_src_attr_tbl inv_globals.number_tbl_type;
18: l_dep_attr_tbl inv_globals.number_tbl_type;
19: BEGIN
20: -- Load out record
21:
14: , x_trolin_rec IN OUT NOCOPY inv_move_order_pub.trolin_rec_type
15: ) IS
16: l_index NUMBER := 0;
17: l_src_attr_tbl inv_globals.number_tbl_type;
18: l_dep_attr_tbl inv_globals.number_tbl_type;
19: BEGIN
20: -- Load out record
21:
22: x_trolin_rec := p_trolin_rec;
24: -- If attr_id is missing compare old and new records and for
25: -- every changed attribute clear its dependent fields.
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:
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;
35: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute10;
36: END IF;
37:
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;
40: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute11;
41: END IF;
42:
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;
45: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute12;
46: END IF;
47:
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;
50: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute13;
51: END IF;
52:
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;
55: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute14;
56: END IF;
57:
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;
60: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute15;
61: END IF;
62:
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;
65: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute2;
66: END IF;
67:
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;
70: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute3;
71: END IF;
72:
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;
75: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute4;
76: END IF;
77:
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;
80: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute5;
81: END IF;
82:
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;
85: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute6;
86: END IF;
87:
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;
90: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute7;
91: END IF;
92:
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;
95: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute8;
96: END IF;
97:
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;
100: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute9;
101: END IF;
102:
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;
105: l_src_attr_tbl(l_index) := inv_trolin_util.g_attribute_category;
106: END IF;
107:
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;
110: l_src_attr_tbl(l_index) := inv_trolin_util.g_created_by;
111: END IF;
112:
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;
115: l_src_attr_tbl(l_index) := inv_trolin_util.g_creation_date;
116: END IF;
117:
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;
120: l_src_attr_tbl(l_index) := inv_trolin_util.g_date_required;
121: END IF;
122:
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;
125: l_src_attr_tbl(l_index) := inv_trolin_util.g_from_locator;
126: END IF;
127:
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;
130: l_src_attr_tbl(l_index) := inv_trolin_util.g_from_subinventory;
131: END IF;
132:
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;
135: l_src_attr_tbl(l_index) := inv_trolin_util.g_from_subinventory;
136: END IF;
137:
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;
140: l_src_attr_tbl(l_index) := inv_trolin_util.g_header;
141: END IF;
142:
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;
145: l_src_attr_tbl(l_index) := inv_trolin_util.g_inventory_item;
146: END IF;
147:
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;
150: l_src_attr_tbl(l_index) := inv_trolin_util.g_last_updated_by;
151: END IF;
152:
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;
155: l_src_attr_tbl(l_index) := inv_trolin_util.g_last_update_date;
156: END IF;
157:
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;
160: l_src_attr_tbl(l_index) := inv_trolin_util.g_last_update_login;
161: END IF;
162:
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;
165: l_src_attr_tbl(l_index) := inv_trolin_util.g_line;
166: END IF;
167:
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;
170: l_src_attr_tbl(l_index) := inv_trolin_util.g_line_number;
171: END IF;
172:
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;
175: l_src_attr_tbl(l_index) := inv_trolin_util.g_line_status;
176: END IF;
177:
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;
180: l_src_attr_tbl(l_index) := inv_trolin_util.g_lot_number;
181: END IF;
182:
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;
185: l_src_attr_tbl(l_index) := inv_trolin_util.g_organization;
186: END IF;
187:
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;
190: l_src_attr_tbl(l_index) := inv_trolin_util.g_program_application;
191: END IF;
192:
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;
195: l_src_attr_tbl(l_index) := inv_trolin_util.g_program;
196: END IF;
197:
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;
200: l_src_attr_tbl(l_index) := inv_trolin_util.g_program_update_date;
201: END IF;
202:
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;
205: l_src_attr_tbl(l_index) := inv_trolin_util.g_project;
206: END IF;
207:
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;
210: l_src_attr_tbl(l_index) := inv_trolin_util.g_quantity;
211: END IF;
212:
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;
215: l_src_attr_tbl(l_index) := inv_trolin_util.g_quantity_delivered;
216: END IF;
217:
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;
220: l_src_attr_tbl(l_index) := inv_trolin_util.g_quantity_detailed;
221: END IF;
222:
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;
225: l_src_attr_tbl(l_index) := inv_trolin_util.g_reason;
226: END IF;
227:
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;
230: l_src_attr_tbl(l_index) := inv_trolin_util.g_reference;
231: END IF;
232:
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;
235: l_src_attr_tbl(l_index) := inv_trolin_util.g_reference;
236: END IF;
237:
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;
240: l_src_attr_tbl(l_index) := inv_trolin_util.g_reference_type;
241: END IF;
242:
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;
245: l_src_attr_tbl(l_index) := inv_trolin_util.g_request;
246: END IF;
247:
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;
250: l_src_attr_tbl(l_index) := inv_trolin_util.g_revision;
251: END IF;
252:
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;
255: l_src_attr_tbl(l_index) := inv_trolin_util.g_serial_number_end;
256: END IF;
257:
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;
260: l_src_attr_tbl(l_index) := inv_trolin_util.g_serial_number_start;
261: END IF;
262:
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;
265: l_src_attr_tbl(l_index) := inv_trolin_util.g_status_date;
266: END IF;
267:
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;
270: l_src_attr_tbl(l_index) := inv_trolin_util.g_task;
271: END IF;
272:
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;
275: l_src_attr_tbl(l_index) := inv_trolin_util.g_to_account;
276: END IF;
277:
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;
280: l_src_attr_tbl(l_index) := inv_trolin_util.g_to_locator;
281: END IF;
282:
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;
285: l_src_attr_tbl(l_index) := inv_trolin_util.g_to_subinventory;
286: END IF;
287:
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;
290: l_src_attr_tbl(l_index) := inv_trolin_util.g_to_subinventory;
291: END IF;
292:
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;
295: l_src_attr_tbl(l_index) := inv_trolin_util.g_transaction_header;
296: END IF;
297:
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;
300: l_src_attr_tbl(l_index) := inv_trolin_util.g_uom;
301: END IF;
302:
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;
305: l_src_attr_tbl(l_index) := inv_trolin_util.g_transaction_type_id;
306: END IF;
307:
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;
310: l_src_attr_tbl(l_index) := inv_trolin_util.g_to_organization_id;
311: END IF;
312:
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;
315: l_src_attr_tbl(l_index) := inv_trolin_util.g_primary_quantity;
316: END IF;
317:
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;
320: l_src_attr_tbl(l_index) := inv_trolin_util.g_txn_source_id;
321: END IF;
322:
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;
325: l_src_attr_tbl(l_index) := inv_trolin_util.g_txn_source_line_id;
326: END IF;
327:
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;
330: l_src_attr_tbl(l_index) := inv_trolin_util.g_txn_source_line_detail_id;
331: END IF;
332:
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;
335: l_src_attr_tbl(l_index) := inv_trolin_util.g_transaction_source_type_id;
336: END IF;
337:
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;
340: l_src_attr_tbl(l_index) := inv_trolin_util.g_put_away_strategy_id;
341: END IF;
342:
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;
345: l_src_attr_tbl(l_index) := inv_trolin_util.g_pick_strategy_id;
346: END IF;
347:
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;
350: l_src_attr_tbl(l_index) := inv_trolin_util.g_unit_number;
351: END IF;
352:
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;
355: l_src_attr_tbl(l_index) := inv_trolin_util.g_ship_to_location_id;
356: END IF;
357:
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;
360: l_src_attr_tbl(l_index) := inv_trolin_util.g_from_cost_group_id;
361: END IF;
362:
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;
365: l_src_attr_tbl(l_index) := inv_trolin_util.g_to_cost_group_id;
366: END IF;
367:
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;
370: l_src_attr_tbl(l_index) := inv_trolin_util.g_lpn_id;
371: END IF;
372:
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;
375: l_src_attr_tbl(l_index) := inv_trolin_util.g_to_lpn_id;
376: END IF;
377:
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;
380: l_src_attr_tbl(l_index) := inv_trolin_util.g_pick_methodology_id;
381: END IF;
382:
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;
385: l_src_attr_tbl(l_index) := inv_trolin_util.g_container_item_id;
386: END IF;
387:
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;
390: l_src_attr_tbl(l_index) := inv_trolin_util.g_carton_grouping_id;
391: END IF;
392:
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;
395: l_src_attr_tbl(l_index) := inv_trolin_util.g_pick_slip_number;
396: END IF;
397:
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;
400: l_src_attr_tbl(l_index) := inv_trolin_util.g_pick_slip_date;
401: END IF;
402:
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;
405: l_src_attr_tbl(l_index) := inv_trolin_util.g_ship_set_id;
406: END IF;
407:
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;
410: l_src_attr_tbl(l_index) := inv_trolin_util.g_ship_model_id;
411: END IF;
412:
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;
415: l_src_attr_tbl(l_index) := inv_trolin_util.g_model_quantity;
416: END IF;
417:
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;
420: l_src_attr_tbl(l_index) := inv_trolin_util.g_required_quantity;
421: END IF;
422: --INVCONV BEGIN
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;
425: l_src_attr_tbl(l_index) := inv_trolin_util.g_secondary_quantity;
426: END IF;
427:
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;
430: l_src_attr_tbl(l_index) := inv_trolin_util.g_secondary_quantity_delivered;
431: END IF;
432:
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;
435: l_src_attr_tbl(l_index) := inv_trolin_util.g_secondary_quantity_detailed;
436: END IF;
437:
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;
440: l_src_attr_tbl(l_index) := inv_trolin_util.g_secondary_uom;
441: END IF;
442:
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;
445: l_src_attr_tbl(l_index) := inv_trolin_util.g_grade_code;
446: END IF;
447:
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;
450: l_src_attr_tbl(l_index) := inv_trolin_util.g_secondary_required_quantity;
451: END IF;
452: --INVCONV END;
717: -- Load out record
718:
719: x_trolin_rec := p_trolin_rec;
720:
721: IF NOT inv_globals.equal(p_trolin_rec.attribute1, p_old_trolin_rec.attribute1) THEN
722: NULL;
723: END IF;
724:
725: IF NOT inv_globals.equal(p_trolin_rec.attribute10, p_old_trolin_rec.attribute10) THEN
721: IF NOT inv_globals.equal(p_trolin_rec.attribute1, p_old_trolin_rec.attribute1) THEN
722: NULL;
723: END IF;
724:
725: IF NOT inv_globals.equal(p_trolin_rec.attribute10, p_old_trolin_rec.attribute10) THEN
726: NULL;
727: END IF;
728:
729: IF NOT inv_globals.equal(p_trolin_rec.attribute11, p_old_trolin_rec.attribute11) THEN
725: IF NOT inv_globals.equal(p_trolin_rec.attribute10, p_old_trolin_rec.attribute10) THEN
726: NULL;
727: END IF;
728:
729: IF NOT inv_globals.equal(p_trolin_rec.attribute11, p_old_trolin_rec.attribute11) THEN
730: NULL;
731: END IF;
732:
733: IF NOT inv_globals.equal(p_trolin_rec.attribute12, p_old_trolin_rec.attribute12) THEN
729: IF NOT inv_globals.equal(p_trolin_rec.attribute11, p_old_trolin_rec.attribute11) THEN
730: NULL;
731: END IF;
732:
733: IF NOT inv_globals.equal(p_trolin_rec.attribute12, p_old_trolin_rec.attribute12) THEN
734: NULL;
735: END IF;
736:
737: IF NOT inv_globals.equal(p_trolin_rec.attribute13, p_old_trolin_rec.attribute13) THEN
733: IF NOT inv_globals.equal(p_trolin_rec.attribute12, p_old_trolin_rec.attribute12) THEN
734: NULL;
735: END IF;
736:
737: IF NOT inv_globals.equal(p_trolin_rec.attribute13, p_old_trolin_rec.attribute13) THEN
738: NULL;
739: END IF;
740:
741: IF NOT inv_globals.equal(p_trolin_rec.attribute14, p_old_trolin_rec.attribute14) THEN
737: IF NOT inv_globals.equal(p_trolin_rec.attribute13, p_old_trolin_rec.attribute13) THEN
738: NULL;
739: END IF;
740:
741: IF NOT inv_globals.equal(p_trolin_rec.attribute14, p_old_trolin_rec.attribute14) THEN
742: NULL;
743: END IF;
744:
745: IF NOT inv_globals.equal(p_trolin_rec.attribute15, p_old_trolin_rec.attribute15) THEN
741: IF NOT inv_globals.equal(p_trolin_rec.attribute14, p_old_trolin_rec.attribute14) THEN
742: NULL;
743: END IF;
744:
745: IF NOT inv_globals.equal(p_trolin_rec.attribute15, p_old_trolin_rec.attribute15) THEN
746: NULL;
747: END IF;
748:
749: IF NOT inv_globals.equal(p_trolin_rec.attribute2, p_old_trolin_rec.attribute2) THEN
745: IF NOT inv_globals.equal(p_trolin_rec.attribute15, p_old_trolin_rec.attribute15) THEN
746: NULL;
747: END IF;
748:
749: IF NOT inv_globals.equal(p_trolin_rec.attribute2, p_old_trolin_rec.attribute2) THEN
750: NULL;
751: END IF;
752:
753: IF NOT inv_globals.equal(p_trolin_rec.attribute3, p_old_trolin_rec.attribute3) THEN
749: IF NOT inv_globals.equal(p_trolin_rec.attribute2, p_old_trolin_rec.attribute2) THEN
750: NULL;
751: END IF;
752:
753: IF NOT inv_globals.equal(p_trolin_rec.attribute3, p_old_trolin_rec.attribute3) THEN
754: NULL;
755: END IF;
756:
757: IF NOT inv_globals.equal(p_trolin_rec.attribute4, p_old_trolin_rec.attribute4) THEN
753: IF NOT inv_globals.equal(p_trolin_rec.attribute3, p_old_trolin_rec.attribute3) THEN
754: NULL;
755: END IF;
756:
757: IF NOT inv_globals.equal(p_trolin_rec.attribute4, p_old_trolin_rec.attribute4) THEN
758: NULL;
759: END IF;
760:
761: IF NOT inv_globals.equal(p_trolin_rec.attribute5, p_old_trolin_rec.attribute5) THEN
757: IF NOT inv_globals.equal(p_trolin_rec.attribute4, p_old_trolin_rec.attribute4) THEN
758: NULL;
759: END IF;
760:
761: IF NOT inv_globals.equal(p_trolin_rec.attribute5, p_old_trolin_rec.attribute5) THEN
762: NULL;
763: END IF;
764:
765: IF NOT inv_globals.equal(p_trolin_rec.attribute6, p_old_trolin_rec.attribute6) THEN
761: IF NOT inv_globals.equal(p_trolin_rec.attribute5, p_old_trolin_rec.attribute5) THEN
762: NULL;
763: END IF;
764:
765: IF NOT inv_globals.equal(p_trolin_rec.attribute6, p_old_trolin_rec.attribute6) THEN
766: NULL;
767: END IF;
768:
769: IF NOT inv_globals.equal(p_trolin_rec.attribute7, p_old_trolin_rec.attribute7) THEN
765: IF NOT inv_globals.equal(p_trolin_rec.attribute6, p_old_trolin_rec.attribute6) THEN
766: NULL;
767: END IF;
768:
769: IF NOT inv_globals.equal(p_trolin_rec.attribute7, p_old_trolin_rec.attribute7) THEN
770: NULL;
771: END IF;
772:
773: IF NOT inv_globals.equal(p_trolin_rec.attribute8, p_old_trolin_rec.attribute8) THEN
769: IF NOT inv_globals.equal(p_trolin_rec.attribute7, p_old_trolin_rec.attribute7) THEN
770: NULL;
771: END IF;
772:
773: IF NOT inv_globals.equal(p_trolin_rec.attribute8, p_old_trolin_rec.attribute8) THEN
774: NULL;
775: END IF;
776:
777: IF NOT inv_globals.equal(p_trolin_rec.attribute9, p_old_trolin_rec.attribute9) THEN
773: IF NOT inv_globals.equal(p_trolin_rec.attribute8, p_old_trolin_rec.attribute8) THEN
774: NULL;
775: END IF;
776:
777: IF NOT inv_globals.equal(p_trolin_rec.attribute9, p_old_trolin_rec.attribute9) THEN
778: NULL;
779: END IF;
780:
781: IF NOT inv_globals.equal(p_trolin_rec.attribute_category, p_old_trolin_rec.attribute_category) THEN
777: IF NOT inv_globals.equal(p_trolin_rec.attribute9, p_old_trolin_rec.attribute9) THEN
778: NULL;
779: END IF;
780:
781: IF NOT inv_globals.equal(p_trolin_rec.attribute_category, p_old_trolin_rec.attribute_category) THEN
782: NULL;
783: END IF;
784:
785: IF NOT inv_globals.equal(p_trolin_rec.created_by, p_old_trolin_rec.created_by) THEN
781: IF NOT inv_globals.equal(p_trolin_rec.attribute_category, p_old_trolin_rec.attribute_category) THEN
782: NULL;
783: END IF;
784:
785: IF NOT inv_globals.equal(p_trolin_rec.created_by, p_old_trolin_rec.created_by) THEN
786: NULL;
787: END IF;
788:
789: IF NOT inv_globals.equal(p_trolin_rec.creation_date, p_old_trolin_rec.creation_date) THEN
785: IF NOT inv_globals.equal(p_trolin_rec.created_by, p_old_trolin_rec.created_by) THEN
786: NULL;
787: END IF;
788:
789: IF NOT inv_globals.equal(p_trolin_rec.creation_date, p_old_trolin_rec.creation_date) THEN
790: NULL;
791: END IF;
792:
793: IF NOT inv_globals.equal(p_trolin_rec.date_required, p_old_trolin_rec.date_required) THEN
789: IF NOT inv_globals.equal(p_trolin_rec.creation_date, p_old_trolin_rec.creation_date) THEN
790: NULL;
791: END IF;
792:
793: IF NOT inv_globals.equal(p_trolin_rec.date_required, p_old_trolin_rec.date_required) THEN
794: NULL;
795: END IF;
796:
797: IF NOT inv_globals.equal(p_trolin_rec.from_locator_id, p_old_trolin_rec.from_locator_id) THEN
793: IF NOT inv_globals.equal(p_trolin_rec.date_required, p_old_trolin_rec.date_required) THEN
794: NULL;
795: END IF;
796:
797: IF NOT inv_globals.equal(p_trolin_rec.from_locator_id, p_old_trolin_rec.from_locator_id) THEN
798: NULL;
799: END IF;
800:
801: IF NOT inv_globals.equal(p_trolin_rec.from_subinventory_code, p_old_trolin_rec.from_subinventory_code) THEN
797: IF NOT inv_globals.equal(p_trolin_rec.from_locator_id, p_old_trolin_rec.from_locator_id) THEN
798: NULL;
799: END IF;
800:
801: IF NOT inv_globals.equal(p_trolin_rec.from_subinventory_code, p_old_trolin_rec.from_subinventory_code) THEN
802: NULL;
803: END IF;
804:
805: IF NOT inv_globals.equal(p_trolin_rec.from_subinventory_id, p_old_trolin_rec.from_subinventory_id) THEN
801: IF NOT inv_globals.equal(p_trolin_rec.from_subinventory_code, p_old_trolin_rec.from_subinventory_code) THEN
802: NULL;
803: END IF;
804:
805: IF NOT inv_globals.equal(p_trolin_rec.from_subinventory_id, p_old_trolin_rec.from_subinventory_id) THEN
806: NULL;
807: END IF;
808:
809: IF NOT inv_globals.equal(p_trolin_rec.header_id, p_old_trolin_rec.header_id) THEN
805: IF NOT inv_globals.equal(p_trolin_rec.from_subinventory_id, p_old_trolin_rec.from_subinventory_id) THEN
806: NULL;
807: END IF;
808:
809: IF NOT inv_globals.equal(p_trolin_rec.header_id, p_old_trolin_rec.header_id) THEN
810: NULL;
811: END IF;
812:
813: IF NOT inv_globals.equal(p_trolin_rec.inventory_item_id, p_old_trolin_rec.inventory_item_id) THEN
809: IF NOT inv_globals.equal(p_trolin_rec.header_id, p_old_trolin_rec.header_id) THEN
810: NULL;
811: END IF;
812:
813: IF NOT inv_globals.equal(p_trolin_rec.inventory_item_id, p_old_trolin_rec.inventory_item_id) THEN
814: NULL;
815: END IF;
816:
817: IF NOT inv_globals.equal(p_trolin_rec.last_updated_by, p_old_trolin_rec.last_updated_by) THEN
813: IF NOT inv_globals.equal(p_trolin_rec.inventory_item_id, p_old_trolin_rec.inventory_item_id) THEN
814: NULL;
815: END IF;
816:
817: IF NOT inv_globals.equal(p_trolin_rec.last_updated_by, p_old_trolin_rec.last_updated_by) THEN
818: NULL;
819: END IF;
820:
821: IF NOT inv_globals.equal(p_trolin_rec.last_update_date, p_old_trolin_rec.last_update_date) THEN
817: IF NOT inv_globals.equal(p_trolin_rec.last_updated_by, p_old_trolin_rec.last_updated_by) THEN
818: NULL;
819: END IF;
820:
821: IF NOT inv_globals.equal(p_trolin_rec.last_update_date, p_old_trolin_rec.last_update_date) THEN
822: NULL;
823: END IF;
824:
825: IF NOT inv_globals.equal(p_trolin_rec.last_update_login, p_old_trolin_rec.last_update_login) THEN
821: IF NOT inv_globals.equal(p_trolin_rec.last_update_date, p_old_trolin_rec.last_update_date) THEN
822: NULL;
823: END IF;
824:
825: IF NOT inv_globals.equal(p_trolin_rec.last_update_login, p_old_trolin_rec.last_update_login) THEN
826: NULL;
827: END IF;
828:
829: IF NOT inv_globals.equal(p_trolin_rec.line_id, p_old_trolin_rec.line_id) THEN
825: IF NOT inv_globals.equal(p_trolin_rec.last_update_login, p_old_trolin_rec.last_update_login) THEN
826: NULL;
827: END IF;
828:
829: IF NOT inv_globals.equal(p_trolin_rec.line_id, p_old_trolin_rec.line_id) THEN
830: NULL;
831: END IF;
832:
833: IF NOT inv_globals.equal(p_trolin_rec.line_number, p_old_trolin_rec.line_number) THEN
829: IF NOT inv_globals.equal(p_trolin_rec.line_id, p_old_trolin_rec.line_id) THEN
830: NULL;
831: END IF;
832:
833: IF NOT inv_globals.equal(p_trolin_rec.line_number, p_old_trolin_rec.line_number) THEN
834: NULL;
835: END IF;
836:
837: IF NOT inv_globals.equal(p_trolin_rec.line_status, p_old_trolin_rec.line_status) THEN
833: IF NOT inv_globals.equal(p_trolin_rec.line_number, p_old_trolin_rec.line_number) THEN
834: NULL;
835: END IF;
836:
837: IF NOT inv_globals.equal(p_trolin_rec.line_status, p_old_trolin_rec.line_status) THEN
838: NULL;
839: END IF;
840:
841: IF NOT inv_globals.equal(p_trolin_rec.lot_number, p_old_trolin_rec.lot_number) THEN
837: IF NOT inv_globals.equal(p_trolin_rec.line_status, p_old_trolin_rec.line_status) THEN
838: NULL;
839: END IF;
840:
841: IF NOT inv_globals.equal(p_trolin_rec.lot_number, p_old_trolin_rec.lot_number) THEN
842: NULL;
843: END IF;
844:
845: IF NOT inv_globals.equal(p_trolin_rec.organization_id, p_old_trolin_rec.organization_id) THEN
841: IF NOT inv_globals.equal(p_trolin_rec.lot_number, p_old_trolin_rec.lot_number) THEN
842: NULL;
843: END IF;
844:
845: IF NOT inv_globals.equal(p_trolin_rec.organization_id, p_old_trolin_rec.organization_id) THEN
846: NULL;
847: END IF;
848:
849: IF NOT inv_globals.equal(p_trolin_rec.program_application_id, p_old_trolin_rec.program_application_id) THEN
845: IF NOT inv_globals.equal(p_trolin_rec.organization_id, p_old_trolin_rec.organization_id) THEN
846: NULL;
847: END IF;
848:
849: IF NOT inv_globals.equal(p_trolin_rec.program_application_id, p_old_trolin_rec.program_application_id) THEN
850: NULL;
851: END IF;
852:
853: IF NOT inv_globals.equal(p_trolin_rec.program_id, p_old_trolin_rec.program_id) THEN
849: IF NOT inv_globals.equal(p_trolin_rec.program_application_id, p_old_trolin_rec.program_application_id) THEN
850: NULL;
851: END IF;
852:
853: IF NOT inv_globals.equal(p_trolin_rec.program_id, p_old_trolin_rec.program_id) THEN
854: NULL;
855: END IF;
856:
857: IF NOT inv_globals.equal(p_trolin_rec.program_update_date, p_old_trolin_rec.program_update_date) THEN
853: IF NOT inv_globals.equal(p_trolin_rec.program_id, p_old_trolin_rec.program_id) THEN
854: NULL;
855: END IF;
856:
857: IF NOT inv_globals.equal(p_trolin_rec.program_update_date, p_old_trolin_rec.program_update_date) THEN
858: NULL;
859: END IF;
860:
861: IF NOT inv_globals.equal(p_trolin_rec.project_id, p_old_trolin_rec.project_id) THEN
857: IF NOT inv_globals.equal(p_trolin_rec.program_update_date, p_old_trolin_rec.program_update_date) THEN
858: NULL;
859: END IF;
860:
861: IF NOT inv_globals.equal(p_trolin_rec.project_id, p_old_trolin_rec.project_id) THEN
862: NULL;
863: END IF;
864:
865: IF NOT inv_globals.equal(p_trolin_rec.quantity, p_old_trolin_rec.quantity) THEN
861: IF NOT inv_globals.equal(p_trolin_rec.project_id, p_old_trolin_rec.project_id) THEN
862: NULL;
863: END IF;
864:
865: IF NOT inv_globals.equal(p_trolin_rec.quantity, p_old_trolin_rec.quantity) THEN
866: NULL;
867: END IF;
868:
869: IF NOT inv_globals.equal(p_trolin_rec.quantity_delivered, p_old_trolin_rec.quantity_delivered) THEN
865: IF NOT inv_globals.equal(p_trolin_rec.quantity, p_old_trolin_rec.quantity) THEN
866: NULL;
867: END IF;
868:
869: IF NOT inv_globals.equal(p_trolin_rec.quantity_delivered, p_old_trolin_rec.quantity_delivered) THEN
870: NULL;
871: END IF;
872:
873: IF NOT inv_globals.equal(p_trolin_rec.quantity_detailed, p_old_trolin_rec.quantity_detailed) THEN
869: IF NOT inv_globals.equal(p_trolin_rec.quantity_delivered, p_old_trolin_rec.quantity_delivered) THEN
870: NULL;
871: END IF;
872:
873: IF NOT inv_globals.equal(p_trolin_rec.quantity_detailed, p_old_trolin_rec.quantity_detailed) THEN
874: NULL;
875: END IF;
876:
877: IF NOT inv_globals.equal(p_trolin_rec.reason_id, p_old_trolin_rec.reason_id) THEN
873: IF NOT inv_globals.equal(p_trolin_rec.quantity_detailed, p_old_trolin_rec.quantity_detailed) THEN
874: NULL;
875: END IF;
876:
877: IF NOT inv_globals.equal(p_trolin_rec.reason_id, p_old_trolin_rec.reason_id) THEN
878: NULL;
879: END IF;
880:
881: IF NOT inv_globals.equal(p_trolin_rec.REFERENCE, p_old_trolin_rec.REFERENCE) THEN
877: IF NOT inv_globals.equal(p_trolin_rec.reason_id, p_old_trolin_rec.reason_id) THEN
878: NULL;
879: END IF;
880:
881: IF NOT inv_globals.equal(p_trolin_rec.REFERENCE, p_old_trolin_rec.REFERENCE) THEN
882: NULL;
883: END IF;
884:
885: IF NOT inv_globals.equal(p_trolin_rec.reference_id, p_old_trolin_rec.reference_id) THEN
881: IF NOT inv_globals.equal(p_trolin_rec.REFERENCE, p_old_trolin_rec.REFERENCE) THEN
882: NULL;
883: END IF;
884:
885: IF NOT inv_globals.equal(p_trolin_rec.reference_id, p_old_trolin_rec.reference_id) THEN
886: NULL;
887: END IF;
888:
889: IF NOT inv_globals.equal(p_trolin_rec.reference_type_code, p_old_trolin_rec.reference_type_code) THEN
885: IF NOT inv_globals.equal(p_trolin_rec.reference_id, p_old_trolin_rec.reference_id) THEN
886: NULL;
887: END IF;
888:
889: IF NOT inv_globals.equal(p_trolin_rec.reference_type_code, p_old_trolin_rec.reference_type_code) THEN
890: NULL;
891: END IF;
892:
893: IF NOT inv_globals.equal(p_trolin_rec.request_id, p_old_trolin_rec.request_id) THEN
889: IF NOT inv_globals.equal(p_trolin_rec.reference_type_code, p_old_trolin_rec.reference_type_code) THEN
890: NULL;
891: END IF;
892:
893: IF NOT inv_globals.equal(p_trolin_rec.request_id, p_old_trolin_rec.request_id) THEN
894: NULL;
895: END IF;
896:
897: IF NOT inv_globals.equal(p_trolin_rec.revision, p_old_trolin_rec.revision) THEN
893: IF NOT inv_globals.equal(p_trolin_rec.request_id, p_old_trolin_rec.request_id) THEN
894: NULL;
895: END IF;
896:
897: IF NOT inv_globals.equal(p_trolin_rec.revision, p_old_trolin_rec.revision) THEN
898: NULL;
899: END IF;
900:
901: IF NOT inv_globals.equal(p_trolin_rec.serial_number_end, p_old_trolin_rec.serial_number_end) THEN
897: IF NOT inv_globals.equal(p_trolin_rec.revision, p_old_trolin_rec.revision) THEN
898: NULL;
899: END IF;
900:
901: IF NOT inv_globals.equal(p_trolin_rec.serial_number_end, p_old_trolin_rec.serial_number_end) THEN
902: NULL;
903: END IF;
904:
905: IF NOT inv_globals.equal(p_trolin_rec.serial_number_start, p_old_trolin_rec.serial_number_start) THEN
901: IF NOT inv_globals.equal(p_trolin_rec.serial_number_end, p_old_trolin_rec.serial_number_end) THEN
902: NULL;
903: END IF;
904:
905: IF NOT inv_globals.equal(p_trolin_rec.serial_number_start, p_old_trolin_rec.serial_number_start) THEN
906: NULL;
907: END IF;
908:
909: IF NOT inv_globals.equal(p_trolin_rec.status_date, p_old_trolin_rec.status_date) THEN
905: IF NOT inv_globals.equal(p_trolin_rec.serial_number_start, p_old_trolin_rec.serial_number_start) THEN
906: NULL;
907: END IF;
908:
909: IF NOT inv_globals.equal(p_trolin_rec.status_date, p_old_trolin_rec.status_date) THEN
910: NULL;
911: END IF;
912:
913: IF NOT inv_globals.equal(p_trolin_rec.task_id, p_old_trolin_rec.task_id) THEN
909: IF NOT inv_globals.equal(p_trolin_rec.status_date, p_old_trolin_rec.status_date) THEN
910: NULL;
911: END IF;
912:
913: IF NOT inv_globals.equal(p_trolin_rec.task_id, p_old_trolin_rec.task_id) THEN
914: NULL;
915: END IF;
916:
917: IF NOT inv_globals.equal(p_trolin_rec.to_account_id, p_old_trolin_rec.to_account_id) THEN
913: IF NOT inv_globals.equal(p_trolin_rec.task_id, p_old_trolin_rec.task_id) THEN
914: NULL;
915: END IF;
916:
917: IF NOT inv_globals.equal(p_trolin_rec.to_account_id, p_old_trolin_rec.to_account_id) THEN
918: NULL;
919: END IF;
920:
921: IF NOT inv_globals.equal(p_trolin_rec.to_locator_id, p_old_trolin_rec.to_locator_id) THEN
917: IF NOT inv_globals.equal(p_trolin_rec.to_account_id, p_old_trolin_rec.to_account_id) THEN
918: NULL;
919: END IF;
920:
921: IF NOT inv_globals.equal(p_trolin_rec.to_locator_id, p_old_trolin_rec.to_locator_id) THEN
922: NULL;
923: END IF;
924:
925: IF NOT inv_globals.equal(p_trolin_rec.to_subinventory_code, p_old_trolin_rec.to_subinventory_code) THEN
921: IF NOT inv_globals.equal(p_trolin_rec.to_locator_id, p_old_trolin_rec.to_locator_id) THEN
922: NULL;
923: END IF;
924:
925: IF NOT inv_globals.equal(p_trolin_rec.to_subinventory_code, p_old_trolin_rec.to_subinventory_code) THEN
926: NULL;
927: END IF;
928:
929: IF NOT inv_globals.equal(p_trolin_rec.to_subinventory_id, p_old_trolin_rec.to_subinventory_id) THEN
925: IF NOT inv_globals.equal(p_trolin_rec.to_subinventory_code, p_old_trolin_rec.to_subinventory_code) THEN
926: NULL;
927: END IF;
928:
929: IF NOT inv_globals.equal(p_trolin_rec.to_subinventory_id, p_old_trolin_rec.to_subinventory_id) THEN
930: NULL;
931: END IF;
932:
933: IF NOT inv_globals.equal(p_trolin_rec.transaction_header_id, p_old_trolin_rec.transaction_header_id) THEN
929: IF NOT inv_globals.equal(p_trolin_rec.to_subinventory_id, p_old_trolin_rec.to_subinventory_id) THEN
930: NULL;
931: END IF;
932:
933: IF NOT inv_globals.equal(p_trolin_rec.transaction_header_id, p_old_trolin_rec.transaction_header_id) THEN
934: NULL;
935: END IF;
936:
937: IF NOT inv_globals.equal(p_trolin_rec.uom_code, p_old_trolin_rec.uom_code) THEN
933: IF NOT inv_globals.equal(p_trolin_rec.transaction_header_id, p_old_trolin_rec.transaction_header_id) THEN
934: NULL;
935: END IF;
936:
937: IF NOT inv_globals.equal(p_trolin_rec.uom_code, p_old_trolin_rec.uom_code) THEN
938: NULL;
939: END IF;
940:
941: IF NOT inv_globals.equal(p_trolin_rec.transaction_type_id, p_old_trolin_rec.transaction_type_id) THEN
937: IF NOT inv_globals.equal(p_trolin_rec.uom_code, p_old_trolin_rec.uom_code) THEN
938: NULL;
939: END IF;
940:
941: IF NOT inv_globals.equal(p_trolin_rec.transaction_type_id, p_old_trolin_rec.transaction_type_id) THEN
942: NULL;
943: END IF;
944:
945: IF NOT inv_globals.equal(p_trolin_rec.transaction_source_type_id, p_old_trolin_rec.transaction_source_type_id) THEN
941: IF NOT inv_globals.equal(p_trolin_rec.transaction_type_id, p_old_trolin_rec.transaction_type_id) THEN
942: NULL;
943: END IF;
944:
945: IF NOT inv_globals.equal(p_trolin_rec.transaction_source_type_id, p_old_trolin_rec.transaction_source_type_id) THEN
946: NULL;
947: END IF;
948:
949: IF NOT inv_globals.equal(p_trolin_rec.txn_source_id, p_old_trolin_rec.txn_source_id) THEN
945: IF NOT inv_globals.equal(p_trolin_rec.transaction_source_type_id, p_old_trolin_rec.transaction_source_type_id) THEN
946: NULL;
947: END IF;
948:
949: IF NOT inv_globals.equal(p_trolin_rec.txn_source_id, p_old_trolin_rec.txn_source_id) THEN
950: NULL;
951: END IF;
952:
953: IF NOT inv_globals.equal(p_trolin_rec.txn_source_line_id, p_old_trolin_rec.txn_source_line_id) THEN
949: IF NOT inv_globals.equal(p_trolin_rec.txn_source_id, p_old_trolin_rec.txn_source_id) THEN
950: NULL;
951: END IF;
952:
953: IF NOT inv_globals.equal(p_trolin_rec.txn_source_line_id, p_old_trolin_rec.txn_source_line_id) THEN
954: NULL;
955: END IF;
956:
957: IF NOT inv_globals.equal(p_trolin_rec.txn_source_line_detail_id, p_old_trolin_rec.txn_source_line_detail_id) THEN
953: IF NOT inv_globals.equal(p_trolin_rec.txn_source_line_id, p_old_trolin_rec.txn_source_line_id) THEN
954: NULL;
955: END IF;
956:
957: IF NOT inv_globals.equal(p_trolin_rec.txn_source_line_detail_id, p_old_trolin_rec.txn_source_line_detail_id) THEN
958: NULL;
959: END IF;
960:
961: IF NOT inv_globals.equal(p_trolin_rec.to_organization_id, p_old_trolin_rec.to_organization_id) THEN
957: IF NOT inv_globals.equal(p_trolin_rec.txn_source_line_detail_id, p_old_trolin_rec.txn_source_line_detail_id) THEN
958: NULL;
959: END IF;
960:
961: IF NOT inv_globals.equal(p_trolin_rec.to_organization_id, p_old_trolin_rec.to_organization_id) THEN
962: NULL;
963: END IF;
964:
965: IF NOT inv_globals.equal(p_trolin_rec.primary_quantity, p_old_trolin_rec.primary_quantity) THEN
961: IF NOT inv_globals.equal(p_trolin_rec.to_organization_id, p_old_trolin_rec.to_organization_id) THEN
962: NULL;
963: END IF;
964:
965: IF NOT inv_globals.equal(p_trolin_rec.primary_quantity, p_old_trolin_rec.primary_quantity) THEN
966: NULL;
967: END IF;
968:
969: IF NOT inv_globals.equal(p_trolin_rec.pick_strategy_id, p_old_trolin_rec.pick_strategy_id) THEN
965: IF NOT inv_globals.equal(p_trolin_rec.primary_quantity, p_old_trolin_rec.primary_quantity) THEN
966: NULL;
967: END IF;
968:
969: IF NOT inv_globals.equal(p_trolin_rec.pick_strategy_id, p_old_trolin_rec.pick_strategy_id) THEN
970: NULL;
971: END IF;
972:
973: IF NOT inv_globals.equal(p_trolin_rec.put_away_strategy_id, p_old_trolin_rec.put_away_strategy_id) THEN
969: IF NOT inv_globals.equal(p_trolin_rec.pick_strategy_id, p_old_trolin_rec.pick_strategy_id) THEN
970: NULL;
971: END IF;
972:
973: IF NOT inv_globals.equal(p_trolin_rec.put_away_strategy_id, p_old_trolin_rec.put_away_strategy_id) THEN
974: NULL;
975: END IF;
976:
977: IF NOT inv_globals.equal(p_trolin_rec.unit_number, p_old_trolin_rec.unit_number) THEN
973: IF NOT inv_globals.equal(p_trolin_rec.put_away_strategy_id, p_old_trolin_rec.put_away_strategy_id) THEN
974: NULL;
975: END IF;
976:
977: IF NOT inv_globals.equal(p_trolin_rec.unit_number, p_old_trolin_rec.unit_number) THEN
978: NULL;
979: END IF;
980:
981: IF NOT inv_globals.equal(p_trolin_rec.ship_to_location_id, p_old_trolin_rec.ship_to_location_id) THEN
977: IF NOT inv_globals.equal(p_trolin_rec.unit_number, p_old_trolin_rec.unit_number) THEN
978: NULL;
979: END IF;
980:
981: IF NOT inv_globals.equal(p_trolin_rec.ship_to_location_id, p_old_trolin_rec.ship_to_location_id) THEN
982: NULL;
983: END IF;
984:
985: IF NOT inv_globals.equal(p_trolin_rec.from_cost_group_id, p_old_trolin_rec.from_cost_group_id) THEN
981: IF NOT inv_globals.equal(p_trolin_rec.ship_to_location_id, p_old_trolin_rec.ship_to_location_id) THEN
982: NULL;
983: END IF;
984:
985: IF NOT inv_globals.equal(p_trolin_rec.from_cost_group_id, p_old_trolin_rec.from_cost_group_id) THEN
986: NULL;
987: END IF;
988:
989: IF NOT inv_globals.equal(p_trolin_rec.to_cost_group_id, p_old_trolin_rec.to_cost_group_id) THEN
985: IF NOT inv_globals.equal(p_trolin_rec.from_cost_group_id, p_old_trolin_rec.from_cost_group_id) THEN
986: NULL;
987: END IF;
988:
989: IF NOT inv_globals.equal(p_trolin_rec.to_cost_group_id, p_old_trolin_rec.to_cost_group_id) THEN
990: NULL;
991: END IF;
992:
993: IF NOT inv_globals.equal(p_trolin_rec.lpn_id, p_old_trolin_rec.lpn_id) THEN
989: IF NOT inv_globals.equal(p_trolin_rec.to_cost_group_id, p_old_trolin_rec.to_cost_group_id) THEN
990: NULL;
991: END IF;
992:
993: IF NOT inv_globals.equal(p_trolin_rec.lpn_id, p_old_trolin_rec.lpn_id) THEN
994: NULL;
995: END IF;
996:
997: IF NOT inv_globals.equal(p_trolin_rec.to_lpn_id, p_old_trolin_rec.to_lpn_id) THEN
993: IF NOT inv_globals.equal(p_trolin_rec.lpn_id, p_old_trolin_rec.lpn_id) THEN
994: NULL;
995: END IF;
996:
997: IF NOT inv_globals.equal(p_trolin_rec.to_lpn_id, p_old_trolin_rec.to_lpn_id) THEN
998: NULL;
999: END IF;
1000:
1001: IF NOT inv_globals.equal(p_trolin_rec.pick_methodology_id, p_old_trolin_rec.pick_methodology_id) THEN
997: IF NOT inv_globals.equal(p_trolin_rec.to_lpn_id, p_old_trolin_rec.to_lpn_id) THEN
998: NULL;
999: END IF;
1000:
1001: IF NOT inv_globals.equal(p_trolin_rec.pick_methodology_id, p_old_trolin_rec.pick_methodology_id) THEN
1002: NULL;
1003: END IF;
1004:
1005: IF NOT inv_globals.equal(p_trolin_rec.container_item_id, p_old_trolin_rec.container_item_id) THEN
1001: IF NOT inv_globals.equal(p_trolin_rec.pick_methodology_id, p_old_trolin_rec.pick_methodology_id) THEN
1002: NULL;
1003: END IF;
1004:
1005: IF NOT inv_globals.equal(p_trolin_rec.container_item_id, p_old_trolin_rec.container_item_id) THEN
1006: NULL;
1007: END IF;
1008:
1009: IF NOT inv_globals.equal(p_trolin_rec.carton_grouping_id, p_old_trolin_rec.carton_grouping_id) THEN
1005: IF NOT inv_globals.equal(p_trolin_rec.container_item_id, p_old_trolin_rec.container_item_id) THEN
1006: NULL;
1007: END IF;
1008:
1009: IF NOT inv_globals.equal(p_trolin_rec.carton_grouping_id, p_old_trolin_rec.carton_grouping_id) THEN
1010: NULL;
1011: END IF;
1012:
1013: IF NOT inv_globals.equal(p_trolin_rec.pick_slip_number, p_old_trolin_rec.pick_slip_number) THEN
1009: IF NOT inv_globals.equal(p_trolin_rec.carton_grouping_id, p_old_trolin_rec.carton_grouping_id) THEN
1010: NULL;
1011: END IF;
1012:
1013: IF NOT inv_globals.equal(p_trolin_rec.pick_slip_number, p_old_trolin_rec.pick_slip_number) THEN
1014: NULL;
1015: END IF;
1016:
1017: IF NOT inv_globals.equal(p_trolin_rec.pick_slip_date, p_old_trolin_rec.pick_slip_date) THEN
1013: IF NOT inv_globals.equal(p_trolin_rec.pick_slip_number, p_old_trolin_rec.pick_slip_number) THEN
1014: NULL;
1015: END IF;
1016:
1017: IF NOT inv_globals.equal(p_trolin_rec.pick_slip_date, p_old_trolin_rec.pick_slip_date) THEN
1018: NULL;
1019: END IF;
1020:
1021: IF NOT inv_globals.equal(p_trolin_rec.ship_set_id, p_old_trolin_rec.ship_set_id) THEN
1017: IF NOT inv_globals.equal(p_trolin_rec.pick_slip_date, p_old_trolin_rec.pick_slip_date) THEN
1018: NULL;
1019: END IF;
1020:
1021: IF NOT inv_globals.equal(p_trolin_rec.ship_set_id, p_old_trolin_rec.ship_set_id) THEN
1022: NULL;
1023: END IF;
1024:
1025: IF NOT inv_globals.equal(p_trolin_rec.ship_model_id, p_old_trolin_rec.ship_model_id) THEN
1021: IF NOT inv_globals.equal(p_trolin_rec.ship_set_id, p_old_trolin_rec.ship_set_id) THEN
1022: NULL;
1023: END IF;
1024:
1025: IF NOT inv_globals.equal(p_trolin_rec.ship_model_id, p_old_trolin_rec.ship_model_id) THEN
1026: NULL;
1027: END IF;
1028:
1029: IF NOT inv_globals.equal(p_trolin_rec.model_quantity, p_old_trolin_rec.model_quantity) THEN
1025: IF NOT inv_globals.equal(p_trolin_rec.ship_model_id, p_old_trolin_rec.ship_model_id) THEN
1026: NULL;
1027: END IF;
1028:
1029: IF NOT inv_globals.equal(p_trolin_rec.model_quantity, p_old_trolin_rec.model_quantity) THEN
1030: NULL;
1031: END IF;
1032:
1033: IF NOT inv_globals.equal(p_trolin_rec.required_quantity, p_old_trolin_rec.required_quantity) THEN
1029: IF NOT inv_globals.equal(p_trolin_rec.model_quantity, p_old_trolin_rec.model_quantity) THEN
1030: NULL;
1031: END IF;
1032:
1033: IF NOT inv_globals.equal(p_trolin_rec.required_quantity, p_old_trolin_rec.required_quantity) THEN
1034: NULL;
1035: END IF;
1036: --INVCONV BEGIN
1037: IF NOT inv_globals.equal(p_trolin_rec.secondary_uom, p_old_trolin_rec.secondary_uom) THEN
1033: IF NOT inv_globals.equal(p_trolin_rec.required_quantity, p_old_trolin_rec.required_quantity) THEN
1034: NULL;
1035: END IF;
1036: --INVCONV BEGIN
1037: IF NOT inv_globals.equal(p_trolin_rec.secondary_uom, p_old_trolin_rec.secondary_uom) THEN
1038: NULL;
1039: END IF;
1040:
1041: IF NOT inv_globals.equal(p_trolin_rec.secondary_quantity, p_old_trolin_rec.secondary_quantity) THEN
1037: IF NOT inv_globals.equal(p_trolin_rec.secondary_uom, p_old_trolin_rec.secondary_uom) THEN
1038: NULL;
1039: END IF;
1040:
1041: IF NOT inv_globals.equal(p_trolin_rec.secondary_quantity, p_old_trolin_rec.secondary_quantity) THEN
1042: NULL;
1043: END IF;
1044:
1045: IF NOT inv_globals.equal(p_trolin_rec.secondary_quantity_delivered, p_old_trolin_rec.secondary_quantity_delivered) THEN
1041: IF NOT inv_globals.equal(p_trolin_rec.secondary_quantity, p_old_trolin_rec.secondary_quantity) THEN
1042: NULL;
1043: END IF;
1044:
1045: IF NOT inv_globals.equal(p_trolin_rec.secondary_quantity_delivered, p_old_trolin_rec.secondary_quantity_delivered) THEN
1046: NULL;
1047: END IF;
1048:
1049: IF NOT inv_globals.equal(p_trolin_rec.secondary_quantity_detailed, p_old_trolin_rec.secondary_quantity_detailed) THEN
1045: IF NOT inv_globals.equal(p_trolin_rec.secondary_quantity_delivered, p_old_trolin_rec.secondary_quantity_delivered) THEN
1046: NULL;
1047: END IF;
1048:
1049: IF NOT inv_globals.equal(p_trolin_rec.secondary_quantity_detailed, p_old_trolin_rec.secondary_quantity_detailed) THEN
1050: NULL;
1051: END IF;
1052:
1053: IF NOT inv_globals.equal(p_trolin_rec.grade_code, p_old_trolin_rec.grade_code) THEN
1049: IF NOT inv_globals.equal(p_trolin_rec.secondary_quantity_detailed, p_old_trolin_rec.secondary_quantity_detailed) THEN
1050: NULL;
1051: END IF;
1052:
1053: IF NOT inv_globals.equal(p_trolin_rec.grade_code, p_old_trolin_rec.grade_code) THEN
1054: NULL;
1055: END IF;
1056:
1057: IF NOT inv_globals.equal(p_trolin_rec.secondary_required_quantity, p_old_trolin_rec.secondary_required_quantity) THEN
1053: IF NOT inv_globals.equal(p_trolin_rec.grade_code, p_old_trolin_rec.grade_code) THEN
1054: NULL;
1055: END IF;
1056:
1057: IF NOT inv_globals.equal(p_trolin_rec.secondary_required_quantity, p_old_trolin_rec.secondary_required_quantity) THEN
1058: NULL;
1059: END IF;
1060:
1061: --INVCONV END;
2820: FOR UPDATE NOWAIT;
2821:
2822: -- Row locked. Compare IN attributes to DB attributes.
2823:
2824: IF inv_globals.equal(p_trolin_rec.attribute1, l_trolin_rec.attribute1)
2825: AND inv_globals.equal(p_trolin_rec.attribute10, l_trolin_rec.attribute10)
2826: AND inv_globals.equal(p_trolin_rec.attribute11, l_trolin_rec.attribute11)
2827: AND inv_globals.equal(p_trolin_rec.attribute12, l_trolin_rec.attribute12)
2828: AND inv_globals.equal(p_trolin_rec.attribute13, l_trolin_rec.attribute13)
2821:
2822: -- Row locked. Compare IN attributes to DB attributes.
2823:
2824: IF inv_globals.equal(p_trolin_rec.attribute1, l_trolin_rec.attribute1)
2825: AND inv_globals.equal(p_trolin_rec.attribute10, l_trolin_rec.attribute10)
2826: AND inv_globals.equal(p_trolin_rec.attribute11, l_trolin_rec.attribute11)
2827: AND inv_globals.equal(p_trolin_rec.attribute12, l_trolin_rec.attribute12)
2828: AND inv_globals.equal(p_trolin_rec.attribute13, l_trolin_rec.attribute13)
2829: AND inv_globals.equal(p_trolin_rec.attribute14, l_trolin_rec.attribute14)
2822: -- Row locked. Compare IN attributes to DB attributes.
2823:
2824: IF inv_globals.equal(p_trolin_rec.attribute1, l_trolin_rec.attribute1)
2825: AND inv_globals.equal(p_trolin_rec.attribute10, l_trolin_rec.attribute10)
2826: AND inv_globals.equal(p_trolin_rec.attribute11, l_trolin_rec.attribute11)
2827: AND inv_globals.equal(p_trolin_rec.attribute12, l_trolin_rec.attribute12)
2828: AND inv_globals.equal(p_trolin_rec.attribute13, l_trolin_rec.attribute13)
2829: AND inv_globals.equal(p_trolin_rec.attribute14, l_trolin_rec.attribute14)
2830: AND inv_globals.equal(p_trolin_rec.attribute15, l_trolin_rec.attribute15)
2823:
2824: IF inv_globals.equal(p_trolin_rec.attribute1, l_trolin_rec.attribute1)
2825: AND inv_globals.equal(p_trolin_rec.attribute10, l_trolin_rec.attribute10)
2826: AND inv_globals.equal(p_trolin_rec.attribute11, l_trolin_rec.attribute11)
2827: AND inv_globals.equal(p_trolin_rec.attribute12, l_trolin_rec.attribute12)
2828: AND inv_globals.equal(p_trolin_rec.attribute13, l_trolin_rec.attribute13)
2829: AND inv_globals.equal(p_trolin_rec.attribute14, l_trolin_rec.attribute14)
2830: AND inv_globals.equal(p_trolin_rec.attribute15, l_trolin_rec.attribute15)
2831: AND inv_globals.equal(p_trolin_rec.attribute2, l_trolin_rec.attribute2)
2824: IF inv_globals.equal(p_trolin_rec.attribute1, l_trolin_rec.attribute1)
2825: AND inv_globals.equal(p_trolin_rec.attribute10, l_trolin_rec.attribute10)
2826: AND inv_globals.equal(p_trolin_rec.attribute11, l_trolin_rec.attribute11)
2827: AND inv_globals.equal(p_trolin_rec.attribute12, l_trolin_rec.attribute12)
2828: AND inv_globals.equal(p_trolin_rec.attribute13, l_trolin_rec.attribute13)
2829: AND inv_globals.equal(p_trolin_rec.attribute14, l_trolin_rec.attribute14)
2830: AND inv_globals.equal(p_trolin_rec.attribute15, l_trolin_rec.attribute15)
2831: AND inv_globals.equal(p_trolin_rec.attribute2, l_trolin_rec.attribute2)
2832: AND inv_globals.equal(p_trolin_rec.attribute3, l_trolin_rec.attribute3)
2825: AND inv_globals.equal(p_trolin_rec.attribute10, l_trolin_rec.attribute10)
2826: AND inv_globals.equal(p_trolin_rec.attribute11, l_trolin_rec.attribute11)
2827: AND inv_globals.equal(p_trolin_rec.attribute12, l_trolin_rec.attribute12)
2828: AND inv_globals.equal(p_trolin_rec.attribute13, l_trolin_rec.attribute13)
2829: AND inv_globals.equal(p_trolin_rec.attribute14, l_trolin_rec.attribute14)
2830: AND inv_globals.equal(p_trolin_rec.attribute15, l_trolin_rec.attribute15)
2831: AND inv_globals.equal(p_trolin_rec.attribute2, l_trolin_rec.attribute2)
2832: AND inv_globals.equal(p_trolin_rec.attribute3, l_trolin_rec.attribute3)
2833: AND inv_globals.equal(p_trolin_rec.attribute4, l_trolin_rec.attribute4)
2826: AND inv_globals.equal(p_trolin_rec.attribute11, l_trolin_rec.attribute11)
2827: AND inv_globals.equal(p_trolin_rec.attribute12, l_trolin_rec.attribute12)
2828: AND inv_globals.equal(p_trolin_rec.attribute13, l_trolin_rec.attribute13)
2829: AND inv_globals.equal(p_trolin_rec.attribute14, l_trolin_rec.attribute14)
2830: AND inv_globals.equal(p_trolin_rec.attribute15, l_trolin_rec.attribute15)
2831: AND inv_globals.equal(p_trolin_rec.attribute2, l_trolin_rec.attribute2)
2832: AND inv_globals.equal(p_trolin_rec.attribute3, l_trolin_rec.attribute3)
2833: AND inv_globals.equal(p_trolin_rec.attribute4, l_trolin_rec.attribute4)
2834: AND inv_globals.equal(p_trolin_rec.attribute5, l_trolin_rec.attribute5)
2827: AND inv_globals.equal(p_trolin_rec.attribute12, l_trolin_rec.attribute12)
2828: AND inv_globals.equal(p_trolin_rec.attribute13, l_trolin_rec.attribute13)
2829: AND inv_globals.equal(p_trolin_rec.attribute14, l_trolin_rec.attribute14)
2830: AND inv_globals.equal(p_trolin_rec.attribute15, l_trolin_rec.attribute15)
2831: AND inv_globals.equal(p_trolin_rec.attribute2, l_trolin_rec.attribute2)
2832: AND inv_globals.equal(p_trolin_rec.attribute3, l_trolin_rec.attribute3)
2833: AND inv_globals.equal(p_trolin_rec.attribute4, l_trolin_rec.attribute4)
2834: AND inv_globals.equal(p_trolin_rec.attribute5, l_trolin_rec.attribute5)
2835: AND inv_globals.equal(p_trolin_rec.attribute6, l_trolin_rec.attribute6)
2828: AND inv_globals.equal(p_trolin_rec.attribute13, l_trolin_rec.attribute13)
2829: AND inv_globals.equal(p_trolin_rec.attribute14, l_trolin_rec.attribute14)
2830: AND inv_globals.equal(p_trolin_rec.attribute15, l_trolin_rec.attribute15)
2831: AND inv_globals.equal(p_trolin_rec.attribute2, l_trolin_rec.attribute2)
2832: AND inv_globals.equal(p_trolin_rec.attribute3, l_trolin_rec.attribute3)
2833: AND inv_globals.equal(p_trolin_rec.attribute4, l_trolin_rec.attribute4)
2834: AND inv_globals.equal(p_trolin_rec.attribute5, l_trolin_rec.attribute5)
2835: AND inv_globals.equal(p_trolin_rec.attribute6, l_trolin_rec.attribute6)
2836: AND inv_globals.equal(p_trolin_rec.attribute7, l_trolin_rec.attribute7)
2829: AND inv_globals.equal(p_trolin_rec.attribute14, l_trolin_rec.attribute14)
2830: AND inv_globals.equal(p_trolin_rec.attribute15, l_trolin_rec.attribute15)
2831: AND inv_globals.equal(p_trolin_rec.attribute2, l_trolin_rec.attribute2)
2832: AND inv_globals.equal(p_trolin_rec.attribute3, l_trolin_rec.attribute3)
2833: AND inv_globals.equal(p_trolin_rec.attribute4, l_trolin_rec.attribute4)
2834: AND inv_globals.equal(p_trolin_rec.attribute5, l_trolin_rec.attribute5)
2835: AND inv_globals.equal(p_trolin_rec.attribute6, l_trolin_rec.attribute6)
2836: AND inv_globals.equal(p_trolin_rec.attribute7, l_trolin_rec.attribute7)
2837: AND inv_globals.equal(p_trolin_rec.attribute8, l_trolin_rec.attribute8)
2830: AND inv_globals.equal(p_trolin_rec.attribute15, l_trolin_rec.attribute15)
2831: AND inv_globals.equal(p_trolin_rec.attribute2, l_trolin_rec.attribute2)
2832: AND inv_globals.equal(p_trolin_rec.attribute3, l_trolin_rec.attribute3)
2833: AND inv_globals.equal(p_trolin_rec.attribute4, l_trolin_rec.attribute4)
2834: AND inv_globals.equal(p_trolin_rec.attribute5, l_trolin_rec.attribute5)
2835: AND inv_globals.equal(p_trolin_rec.attribute6, l_trolin_rec.attribute6)
2836: AND inv_globals.equal(p_trolin_rec.attribute7, l_trolin_rec.attribute7)
2837: AND inv_globals.equal(p_trolin_rec.attribute8, l_trolin_rec.attribute8)
2838: AND inv_globals.equal(p_trolin_rec.attribute9, l_trolin_rec.attribute9)
2831: AND inv_globals.equal(p_trolin_rec.attribute2, l_trolin_rec.attribute2)
2832: AND inv_globals.equal(p_trolin_rec.attribute3, l_trolin_rec.attribute3)
2833: AND inv_globals.equal(p_trolin_rec.attribute4, l_trolin_rec.attribute4)
2834: AND inv_globals.equal(p_trolin_rec.attribute5, l_trolin_rec.attribute5)
2835: AND inv_globals.equal(p_trolin_rec.attribute6, l_trolin_rec.attribute6)
2836: AND inv_globals.equal(p_trolin_rec.attribute7, l_trolin_rec.attribute7)
2837: AND inv_globals.equal(p_trolin_rec.attribute8, l_trolin_rec.attribute8)
2838: AND inv_globals.equal(p_trolin_rec.attribute9, l_trolin_rec.attribute9)
2839: AND inv_globals.equal(p_trolin_rec.attribute_category, l_trolin_rec.attribute_category)
2832: AND inv_globals.equal(p_trolin_rec.attribute3, l_trolin_rec.attribute3)
2833: AND inv_globals.equal(p_trolin_rec.attribute4, l_trolin_rec.attribute4)
2834: AND inv_globals.equal(p_trolin_rec.attribute5, l_trolin_rec.attribute5)
2835: AND inv_globals.equal(p_trolin_rec.attribute6, l_trolin_rec.attribute6)
2836: AND inv_globals.equal(p_trolin_rec.attribute7, l_trolin_rec.attribute7)
2837: AND inv_globals.equal(p_trolin_rec.attribute8, l_trolin_rec.attribute8)
2838: AND inv_globals.equal(p_trolin_rec.attribute9, l_trolin_rec.attribute9)
2839: AND inv_globals.equal(p_trolin_rec.attribute_category, l_trolin_rec.attribute_category)
2840: AND (inv_globals.equal(p_trolin_rec.created_by, l_trolin_rec.created_by)
2833: AND inv_globals.equal(p_trolin_rec.attribute4, l_trolin_rec.attribute4)
2834: AND inv_globals.equal(p_trolin_rec.attribute5, l_trolin_rec.attribute5)
2835: AND inv_globals.equal(p_trolin_rec.attribute6, l_trolin_rec.attribute6)
2836: AND inv_globals.equal(p_trolin_rec.attribute7, l_trolin_rec.attribute7)
2837: AND inv_globals.equal(p_trolin_rec.attribute8, l_trolin_rec.attribute8)
2838: AND inv_globals.equal(p_trolin_rec.attribute9, l_trolin_rec.attribute9)
2839: AND inv_globals.equal(p_trolin_rec.attribute_category, l_trolin_rec.attribute_category)
2840: AND (inv_globals.equal(p_trolin_rec.created_by, l_trolin_rec.created_by)
2841: OR (p_trolin_rec.created_by = fnd_api.g_miss_num
2834: AND inv_globals.equal(p_trolin_rec.attribute5, l_trolin_rec.attribute5)
2835: AND inv_globals.equal(p_trolin_rec.attribute6, l_trolin_rec.attribute6)
2836: AND inv_globals.equal(p_trolin_rec.attribute7, l_trolin_rec.attribute7)
2837: AND inv_globals.equal(p_trolin_rec.attribute8, l_trolin_rec.attribute8)
2838: AND inv_globals.equal(p_trolin_rec.attribute9, l_trolin_rec.attribute9)
2839: AND inv_globals.equal(p_trolin_rec.attribute_category, l_trolin_rec.attribute_category)
2840: AND (inv_globals.equal(p_trolin_rec.created_by, l_trolin_rec.created_by)
2841: OR (p_trolin_rec.created_by = fnd_api.g_miss_num
2842: AND l_trolin_rec.created_by IS NULL
2835: AND inv_globals.equal(p_trolin_rec.attribute6, l_trolin_rec.attribute6)
2836: AND inv_globals.equal(p_trolin_rec.attribute7, l_trolin_rec.attribute7)
2837: AND inv_globals.equal(p_trolin_rec.attribute8, l_trolin_rec.attribute8)
2838: AND inv_globals.equal(p_trolin_rec.attribute9, l_trolin_rec.attribute9)
2839: AND inv_globals.equal(p_trolin_rec.attribute_category, l_trolin_rec.attribute_category)
2840: AND (inv_globals.equal(p_trolin_rec.created_by, l_trolin_rec.created_by)
2841: OR (p_trolin_rec.created_by = fnd_api.g_miss_num
2842: AND l_trolin_rec.created_by IS NULL
2843: )
2836: AND inv_globals.equal(p_trolin_rec.attribute7, l_trolin_rec.attribute7)
2837: AND inv_globals.equal(p_trolin_rec.attribute8, l_trolin_rec.attribute8)
2838: AND inv_globals.equal(p_trolin_rec.attribute9, l_trolin_rec.attribute9)
2839: AND inv_globals.equal(p_trolin_rec.attribute_category, l_trolin_rec.attribute_category)
2840: AND (inv_globals.equal(p_trolin_rec.created_by, l_trolin_rec.created_by)
2841: OR (p_trolin_rec.created_by = fnd_api.g_miss_num
2842: AND l_trolin_rec.created_by IS NULL
2843: )
2844: )
2841: OR (p_trolin_rec.created_by = fnd_api.g_miss_num
2842: AND l_trolin_rec.created_by IS NULL
2843: )
2844: )
2845: AND (inv_globals.equal(p_trolin_rec.creation_date, l_trolin_rec.creation_date)
2846: OR (p_trolin_rec.creation_date = fnd_api.g_miss_date
2847: AND l_trolin_rec.creation_date IS NULL
2848: )
2849: )
2846: OR (p_trolin_rec.creation_date = fnd_api.g_miss_date
2847: AND l_trolin_rec.creation_date IS NULL
2848: )
2849: )
2850: AND (inv_globals.equal(p_trolin_rec.date_required, l_trolin_rec.date_required)
2851: OR (p_trolin_rec.date_required = fnd_api.g_miss_date
2852: AND l_trolin_rec.date_required IS NULL
2853: )
2854: )
2851: OR (p_trolin_rec.date_required = fnd_api.g_miss_date
2852: AND l_trolin_rec.date_required IS NULL
2853: )
2854: )
2855: AND (inv_globals.equal(p_trolin_rec.from_locator_id, l_trolin_rec.from_locator_id)
2856: OR (p_trolin_rec.from_locator_id = fnd_api.g_miss_num
2857: AND l_trolin_rec.from_locator_id IS NULL
2858: )
2859: )
2856: OR (p_trolin_rec.from_locator_id = fnd_api.g_miss_num
2857: AND l_trolin_rec.from_locator_id IS NULL
2858: )
2859: )
2860: AND (inv_globals.equal(p_trolin_rec.from_subinventory_code, l_trolin_rec.from_subinventory_code)
2861: OR (p_trolin_rec.from_subinventory_code = fnd_api.g_miss_char
2862: AND l_trolin_rec.from_subinventory_code IS NULL
2863: )
2864: )
2861: OR (p_trolin_rec.from_subinventory_code = fnd_api.g_miss_char
2862: AND l_trolin_rec.from_subinventory_code IS NULL
2863: )
2864: )
2865: AND (inv_globals.equal(p_trolin_rec.from_subinventory_id, l_trolin_rec.from_subinventory_id)
2866: OR (p_trolin_rec.from_subinventory_id = fnd_api.g_miss_num
2867: AND l_trolin_rec.from_subinventory_id IS NULL
2868: )
2869: )
2866: OR (p_trolin_rec.from_subinventory_id = fnd_api.g_miss_num
2867: AND l_trolin_rec.from_subinventory_id IS NULL
2868: )
2869: )
2870: AND (inv_globals.equal(p_trolin_rec.header_id, l_trolin_rec.header_id)
2871: OR (p_trolin_rec.header_id = fnd_api.g_miss_num
2872: AND l_trolin_rec.header_id IS NULL
2873: )
2874: )
2871: OR (p_trolin_rec.header_id = fnd_api.g_miss_num
2872: AND l_trolin_rec.header_id IS NULL
2873: )
2874: )
2875: AND (inv_globals.equal(p_trolin_rec.inventory_item_id, l_trolin_rec.inventory_item_id)
2876: OR (p_trolin_rec.inventory_item_id = fnd_api.g_miss_num
2877: AND l_trolin_rec.inventory_item_id IS NULL
2878: )
2879: )
2876: OR (p_trolin_rec.inventory_item_id = fnd_api.g_miss_num
2877: AND l_trolin_rec.inventory_item_id IS NULL
2878: )
2879: )
2880: AND (inv_globals.equal(p_trolin_rec.last_updated_by, l_trolin_rec.last_updated_by)
2881: OR (p_trolin_rec.last_updated_by = fnd_api.g_miss_num
2882: AND l_trolin_rec.last_updated_by IS NULL
2883: )
2884: )
2881: OR (p_trolin_rec.last_updated_by = fnd_api.g_miss_num
2882: AND l_trolin_rec.last_updated_by IS NULL
2883: )
2884: )
2885: AND (inv_globals.equal(p_trolin_rec.last_update_date, l_trolin_rec.last_update_date)
2886: OR (p_trolin_rec.last_update_date = fnd_api.g_miss_date
2887: AND l_trolin_rec.last_update_date IS NULL
2888: )
2889: )
2886: OR (p_trolin_rec.last_update_date = fnd_api.g_miss_date
2887: AND l_trolin_rec.last_update_date IS NULL
2888: )
2889: )
2890: AND (inv_globals.equal(p_trolin_rec.last_update_login, l_trolin_rec.last_update_login)
2891: OR (p_trolin_rec.last_update_login = fnd_api.g_miss_num
2892: AND l_trolin_rec.last_update_login IS NULL
2893: )
2894: )
2891: OR (p_trolin_rec.last_update_login = fnd_api.g_miss_num
2892: AND l_trolin_rec.last_update_login IS NULL
2893: )
2894: )
2895: AND (inv_globals.equal(p_trolin_rec.line_id, l_trolin_rec.line_id)
2896: OR (p_trolin_rec.line_id = fnd_api.g_miss_num
2897: AND l_trolin_rec.line_id IS NULL
2898: )
2899: )
2896: OR (p_trolin_rec.line_id = fnd_api.g_miss_num
2897: AND l_trolin_rec.line_id IS NULL
2898: )
2899: )
2900: AND (inv_globals.equal(p_trolin_rec.line_number, l_trolin_rec.line_number)
2901: OR (p_trolin_rec.line_number = fnd_api.g_miss_num
2902: AND l_trolin_rec.line_number IS NULL
2903: )
2904: )
2901: OR (p_trolin_rec.line_number = fnd_api.g_miss_num
2902: AND l_trolin_rec.line_number IS NULL
2903: )
2904: )
2905: AND (inv_globals.equal(p_trolin_rec.line_status, l_trolin_rec.line_status)
2906: OR (p_trolin_rec.line_status = fnd_api.g_miss_num
2907: AND l_trolin_rec.line_status IS NULL
2908: )
2909: )
2906: OR (p_trolin_rec.line_status = fnd_api.g_miss_num
2907: AND l_trolin_rec.line_status IS NULL
2908: )
2909: )
2910: AND (inv_globals.equal(p_trolin_rec.lot_number, l_trolin_rec.lot_number)
2911: OR (p_trolin_rec.lot_number = fnd_api.g_miss_char
2912: AND l_trolin_rec.lot_number IS NULL
2913: )
2914: )
2911: OR (p_trolin_rec.lot_number = fnd_api.g_miss_char
2912: AND l_trolin_rec.lot_number IS NULL
2913: )
2914: )
2915: AND (inv_globals.equal(p_trolin_rec.organization_id, l_trolin_rec.organization_id)
2916: OR (p_trolin_rec.organization_id = fnd_api.g_miss_num
2917: AND l_trolin_rec.organization_id IS NULL
2918: )
2919: )
2916: OR (p_trolin_rec.organization_id = fnd_api.g_miss_num
2917: AND l_trolin_rec.organization_id IS NULL
2918: )
2919: )
2920: AND (inv_globals.equal(p_trolin_rec.program_application_id, l_trolin_rec.program_application_id)
2921: OR (p_trolin_rec.program_application_id = fnd_api.g_miss_num
2922: AND l_trolin_rec.program_application_id IS NULL
2923: )
2924: )
2921: OR (p_trolin_rec.program_application_id = fnd_api.g_miss_num
2922: AND l_trolin_rec.program_application_id IS NULL
2923: )
2924: )
2925: AND (inv_globals.equal(p_trolin_rec.program_id, l_trolin_rec.program_id)
2926: OR (p_trolin_rec.program_id = fnd_api.g_miss_num
2927: AND l_trolin_rec.program_id IS NULL
2928: )
2929: )
2926: OR (p_trolin_rec.program_id = fnd_api.g_miss_num
2927: AND l_trolin_rec.program_id IS NULL
2928: )
2929: )
2930: AND (inv_globals.equal(p_trolin_rec.program_update_date, l_trolin_rec.program_update_date)
2931: OR (p_trolin_rec.program_update_date = fnd_api.g_miss_date
2932: AND l_trolin_rec.program_update_date IS NOT NULL
2933: )
2934: )
2931: OR (p_trolin_rec.program_update_date = fnd_api.g_miss_date
2932: AND l_trolin_rec.program_update_date IS NOT NULL
2933: )
2934: )
2935: AND (inv_globals.equal(p_trolin_rec.project_id, l_trolin_rec.project_id)
2936: OR (p_trolin_rec.project_id = fnd_api.g_miss_num
2937: AND l_trolin_rec.project_id IS NULL
2938: )
2939: )
2936: OR (p_trolin_rec.project_id = fnd_api.g_miss_num
2937: AND l_trolin_rec.project_id IS NULL
2938: )
2939: )
2940: AND (inv_globals.equal(p_trolin_rec.quantity, l_trolin_rec.quantity)
2941: OR (p_trolin_rec.quantity = fnd_api.g_miss_num
2942: AND l_trolin_rec.quantity IS NULL
2943: )
2944: )
2941: OR (p_trolin_rec.quantity = fnd_api.g_miss_num
2942: AND l_trolin_rec.quantity IS NULL
2943: )
2944: )
2945: AND (inv_globals.equal(p_trolin_rec.quantity_delivered, l_trolin_rec.quantity_delivered)
2946: OR (p_trolin_rec.quantity_delivered = fnd_api.g_miss_num
2947: AND l_trolin_rec.quantity_delivered IS NULL
2948: )
2949: )
2946: OR (p_trolin_rec.quantity_delivered = fnd_api.g_miss_num
2947: AND l_trolin_rec.quantity_delivered IS NULL
2948: )
2949: )
2950: AND (inv_globals.equal(p_trolin_rec.quantity_detailed, l_trolin_rec.quantity_detailed)
2951: OR (p_trolin_rec.quantity_detailed = fnd_api.g_miss_num
2952: AND l_trolin_rec.quantity_detailed IS NULL
2953: )
2954: )
2951: OR (p_trolin_rec.quantity_detailed = fnd_api.g_miss_num
2952: AND l_trolin_rec.quantity_detailed IS NULL
2953: )
2954: )
2955: AND (inv_globals.equal(p_trolin_rec.reason_id, l_trolin_rec.reason_id)
2956: OR (p_trolin_rec.reason_id = fnd_api.g_miss_num
2957: AND l_trolin_rec.reason_id IS NULL
2958: )
2959: )
2956: OR (p_trolin_rec.reason_id = fnd_api.g_miss_num
2957: AND l_trolin_rec.reason_id IS NULL
2958: )
2959: )
2960: AND (inv_globals.equal(p_trolin_rec.REFERENCE, l_trolin_rec.REFERENCE)
2961: OR (p_trolin_rec.REFERENCE = fnd_api.g_miss_char
2962: AND l_trolin_rec.REFERENCE IS NULL
2963: )
2964: )
2961: OR (p_trolin_rec.REFERENCE = fnd_api.g_miss_char
2962: AND l_trolin_rec.REFERENCE IS NULL
2963: )
2964: )
2965: AND (inv_globals.equal(p_trolin_rec.reference_id, l_trolin_rec.reference_id)
2966: OR (p_trolin_rec.reference_id = fnd_api.g_miss_num
2967: AND l_trolin_rec.reference_id IS NULL
2968: )
2969: )
2966: OR (p_trolin_rec.reference_id = fnd_api.g_miss_num
2967: AND l_trolin_rec.reference_id IS NULL
2968: )
2969: )
2970: AND (inv_globals.equal(p_trolin_rec.reference_type_code, l_trolin_rec.reference_type_code)
2971: OR (l_trolin_rec.reference_type_code = fnd_api.g_miss_num
2972: AND l_trolin_rec.reference_type_code IS NULL
2973: )
2974: )
2971: OR (l_trolin_rec.reference_type_code = fnd_api.g_miss_num
2972: AND l_trolin_rec.reference_type_code IS NULL
2973: )
2974: )
2975: AND (inv_globals.equal(p_trolin_rec.request_id, l_trolin_rec.request_id)
2976: OR (p_trolin_rec.request_id = fnd_api.g_miss_num
2977: AND l_trolin_rec.request_id IS NULL
2978: )
2979: )
2976: OR (p_trolin_rec.request_id = fnd_api.g_miss_num
2977: AND l_trolin_rec.request_id IS NULL
2978: )
2979: )
2980: AND (inv_globals.equal(p_trolin_rec.revision, l_trolin_rec.revision)
2981: OR (p_trolin_rec.revision = fnd_api.g_miss_char
2982: AND l_trolin_rec.revision IS NULL
2983: )
2984: )
2981: OR (p_trolin_rec.revision = fnd_api.g_miss_char
2982: AND l_trolin_rec.revision IS NULL
2983: )
2984: )
2985: AND (inv_globals.equal(p_trolin_rec.serial_number_end, l_trolin_rec.serial_number_end)
2986: OR (p_trolin_rec.serial_number_end = fnd_api.g_miss_char
2987: AND l_trolin_rec.serial_number_end IS NULL
2988: )
2989: )
2986: OR (p_trolin_rec.serial_number_end = fnd_api.g_miss_char
2987: AND l_trolin_rec.serial_number_end IS NULL
2988: )
2989: )
2990: AND (inv_globals.equal(p_trolin_rec.serial_number_start, l_trolin_rec.serial_number_start)
2991: OR (p_trolin_rec.serial_number_start = fnd_api.g_miss_char
2992: AND l_trolin_rec.serial_number_start IS NULL
2993: )
2994: )
2991: OR (p_trolin_rec.serial_number_start = fnd_api.g_miss_char
2992: AND l_trolin_rec.serial_number_start IS NULL
2993: )
2994: )
2995: AND (inv_globals.equal(p_trolin_rec.status_date, l_trolin_rec.status_date)
2996: OR (p_trolin_rec.status_date = fnd_api.g_miss_date
2997: AND l_trolin_rec.status_date IS NULL
2998: )
2999: )
2996: OR (p_trolin_rec.status_date = fnd_api.g_miss_date
2997: AND l_trolin_rec.status_date IS NULL
2998: )
2999: )
3000: AND (inv_globals.equal(p_trolin_rec.task_id, l_trolin_rec.task_id)
3001: OR (p_trolin_rec.task_id = fnd_api.g_miss_num
3002: AND l_trolin_rec.task_id IS NULL
3003: )
3004: )
3001: OR (p_trolin_rec.task_id = fnd_api.g_miss_num
3002: AND l_trolin_rec.task_id IS NULL
3003: )
3004: )
3005: AND (inv_globals.equal(p_trolin_rec.to_account_id, l_trolin_rec.to_account_id)
3006: OR (p_trolin_rec.to_account_id = fnd_api.g_miss_num
3007: AND l_trolin_rec.to_account_id IS NULL
3008: )
3009: )
3006: OR (p_trolin_rec.to_account_id = fnd_api.g_miss_num
3007: AND l_trolin_rec.to_account_id IS NULL
3008: )
3009: )
3010: AND (inv_globals.equal(p_trolin_rec.to_locator_id, l_trolin_rec.to_locator_id)
3011: OR (p_trolin_rec.to_locator_id = fnd_api.g_miss_num
3012: AND l_trolin_rec.to_locator_id IS NULL
3013: )
3014: )
3011: OR (p_trolin_rec.to_locator_id = fnd_api.g_miss_num
3012: AND l_trolin_rec.to_locator_id IS NULL
3013: )
3014: )
3015: AND (inv_globals.equal(p_trolin_rec.to_subinventory_code, l_trolin_rec.to_subinventory_code)
3016: OR (p_trolin_rec.to_subinventory_code = fnd_api.g_miss_char
3017: AND l_trolin_rec.to_subinventory_code IS NULL
3018: )
3019: )
3016: OR (p_trolin_rec.to_subinventory_code = fnd_api.g_miss_char
3017: AND l_trolin_rec.to_subinventory_code IS NULL
3018: )
3019: )
3020: AND (inv_globals.equal(p_trolin_rec.to_subinventory_id, l_trolin_rec.to_subinventory_id)
3021: OR (p_trolin_rec.to_subinventory_id = fnd_api.g_miss_num
3022: AND l_trolin_rec.to_subinventory_id IS NULL
3023: )
3024: )
3021: OR (p_trolin_rec.to_subinventory_id = fnd_api.g_miss_num
3022: AND l_trolin_rec.to_subinventory_id IS NULL
3023: )
3024: )
3025: AND (inv_globals.equal(p_trolin_rec.transaction_header_id, l_trolin_rec.transaction_header_id)
3026: OR (p_trolin_rec.transaction_header_id = fnd_api.g_miss_num
3027: AND l_trolin_rec.transaction_header_id IS NULL
3028: )
3029: )
3026: OR (p_trolin_rec.transaction_header_id = fnd_api.g_miss_num
3027: AND l_trolin_rec.transaction_header_id IS NULL
3028: )
3029: )
3030: AND (inv_globals.equal(p_trolin_rec.uom_code, l_trolin_rec.uom_code)
3031: OR (p_trolin_rec.uom_code = fnd_api.g_miss_char
3032: AND p_trolin_rec.uom_code IS NULL
3033: )
3034: )
3031: OR (p_trolin_rec.uom_code = fnd_api.g_miss_char
3032: AND p_trolin_rec.uom_code IS NULL
3033: )
3034: )
3035: AND (inv_globals.equal(p_trolin_rec.transaction_type_id, l_trolin_rec.transaction_type_id)
3036: OR (p_trolin_rec.transaction_type_id = fnd_api.g_miss_num
3037: AND l_trolin_rec.transaction_type_id IS NULL
3038: )
3039: )
3036: OR (p_trolin_rec.transaction_type_id = fnd_api.g_miss_num
3037: AND l_trolin_rec.transaction_type_id IS NULL
3038: )
3039: )
3040: AND (inv_globals.equal(p_trolin_rec.transaction_source_type_id, l_trolin_rec.transaction_source_type_id)
3041: OR (p_trolin_rec.transaction_source_type_id = fnd_api.g_miss_num
3042: AND l_trolin_rec.transaction_source_type_id IS NULL
3043: )
3044: )
3041: OR (p_trolin_rec.transaction_source_type_id = fnd_api.g_miss_num
3042: AND l_trolin_rec.transaction_source_type_id IS NULL
3043: )
3044: )
3045: AND (inv_globals.equal(p_trolin_rec.txn_source_id, l_trolin_rec.txn_source_id)
3046: OR (p_trolin_rec.txn_source_id = fnd_api.g_miss_num
3047: AND l_trolin_rec.txn_source_id IS NULL
3048: )
3049: )
3046: OR (p_trolin_rec.txn_source_id = fnd_api.g_miss_num
3047: AND l_trolin_rec.txn_source_id IS NULL
3048: )
3049: )
3050: AND inv_globals.equal(p_trolin_rec.txn_source_line_id, l_trolin_rec.txn_source_line_id)
3051: AND (inv_globals.equal(p_trolin_rec.txn_source_line_detail_id, l_trolin_rec.txn_source_line_detail_id)
3052: OR (p_trolin_rec.txn_source_line_detail_id = fnd_api.g_miss_num
3053: AND l_trolin_rec.txn_source_line_detail_id IS NULL
3054: )
3047: AND l_trolin_rec.txn_source_id IS NULL
3048: )
3049: )
3050: AND inv_globals.equal(p_trolin_rec.txn_source_line_id, l_trolin_rec.txn_source_line_id)
3051: AND (inv_globals.equal(p_trolin_rec.txn_source_line_detail_id, l_trolin_rec.txn_source_line_detail_id)
3052: OR (p_trolin_rec.txn_source_line_detail_id = fnd_api.g_miss_num
3053: AND l_trolin_rec.txn_source_line_detail_id IS NULL
3054: )
3055: )
3052: OR (p_trolin_rec.txn_source_line_detail_id = fnd_api.g_miss_num
3053: AND l_trolin_rec.txn_source_line_detail_id IS NULL
3054: )
3055: )
3056: AND (inv_globals.equal(p_trolin_rec.primary_quantity, l_trolin_rec.primary_quantity)
3057: OR (p_trolin_rec.primary_quantity = fnd_api.g_miss_num
3058: AND l_trolin_rec.primary_quantity IS NULL
3059: )
3060: )
3057: OR (p_trolin_rec.primary_quantity = fnd_api.g_miss_num
3058: AND l_trolin_rec.primary_quantity IS NULL
3059: )
3060: )
3061: AND (inv_globals.equal(p_trolin_rec.to_organization_id, l_trolin_rec.to_organization_id)
3062: OR (p_trolin_rec.to_organization_id = fnd_api.g_miss_num
3063: AND l_trolin_rec.to_organization_id IS NULL
3064: )
3065: )
3062: OR (p_trolin_rec.to_organization_id = fnd_api.g_miss_num
3063: AND l_trolin_rec.to_organization_id IS NULL
3064: )
3065: )
3066: AND (inv_globals.equal(p_trolin_rec.pick_strategy_id, l_trolin_rec.pick_strategy_id)
3067: OR (p_trolin_rec.pick_strategy_id = fnd_api.g_miss_num
3068: AND l_trolin_rec.pick_strategy_id IS NULL
3069: )
3070: )
3067: OR (p_trolin_rec.pick_strategy_id = fnd_api.g_miss_num
3068: AND l_trolin_rec.pick_strategy_id IS NULL
3069: )
3070: )
3071: AND (inv_globals.equal(p_trolin_rec.put_away_strategy_id, l_trolin_rec.put_away_strategy_id)
3072: OR (p_trolin_rec.put_away_strategy_id = fnd_api.g_miss_num
3073: AND l_trolin_rec.put_away_strategy_id IS NULL
3074: )
3075: )
3072: OR (p_trolin_rec.put_away_strategy_id = fnd_api.g_miss_num
3073: AND l_trolin_rec.put_away_strategy_id IS NULL
3074: )
3075: )
3076: AND (inv_globals.equal(p_trolin_rec.unit_number, l_trolin_rec.unit_number)
3077: OR (p_trolin_rec.unit_number = fnd_api.g_miss_char
3078: AND l_trolin_rec.unit_number IS NULL
3079: )
3080: )
3077: OR (p_trolin_rec.unit_number = fnd_api.g_miss_char
3078: AND l_trolin_rec.unit_number IS NULL
3079: )
3080: )
3081: AND (inv_globals.equal(p_trolin_rec.ship_to_location_id, l_trolin_rec.ship_to_location_id)
3082: OR (p_trolin_rec.ship_to_location_id = fnd_api.g_miss_num
3083: AND l_trolin_rec.ship_to_location_id IS NULL
3084: )
3085: )
3082: OR (p_trolin_rec.ship_to_location_id = fnd_api.g_miss_num
3083: AND l_trolin_rec.ship_to_location_id IS NULL
3084: )
3085: )
3086: AND (inv_globals.equal(p_trolin_rec.from_cost_group_id, l_trolin_rec.from_cost_group_id)
3087: OR (p_trolin_rec.from_cost_group_id = fnd_api.g_miss_num
3088: AND l_trolin_rec.to_cost_group_id IS NULL
3089: )
3090: )
3087: OR (p_trolin_rec.from_cost_group_id = fnd_api.g_miss_num
3088: AND l_trolin_rec.to_cost_group_id IS NULL
3089: )
3090: )
3091: AND (inv_globals.equal(p_trolin_rec.to_cost_group_id, l_trolin_rec.to_cost_group_id)
3092: OR (p_trolin_rec.to_cost_group_id = fnd_api.g_miss_num
3093: AND l_trolin_rec.to_cost_group_id IS NULL
3094: )
3095: )
3092: OR (p_trolin_rec.to_cost_group_id = fnd_api.g_miss_num
3093: AND l_trolin_rec.to_cost_group_id IS NULL
3094: )
3095: )
3096: AND (inv_globals.equal(p_trolin_rec.lpn_id, l_trolin_rec.lpn_id)
3097: OR (p_trolin_rec.lpn_id = fnd_api.g_miss_num
3098: AND l_trolin_rec.lpn_id IS NULL
3099: )
3100: )
3097: OR (p_trolin_rec.lpn_id = fnd_api.g_miss_num
3098: AND l_trolin_rec.lpn_id IS NULL
3099: )
3100: )
3101: AND (inv_globals.equal(p_trolin_rec.to_lpn_id, l_trolin_rec.to_lpn_id)
3102: OR (p_trolin_rec.to_lpn_id = fnd_api.g_miss_num
3103: AND l_trolin_rec.to_lpn_id IS NULL
3104: )
3105: )
3102: OR (p_trolin_rec.to_lpn_id = fnd_api.g_miss_num
3103: AND l_trolin_rec.to_lpn_id IS NULL
3104: )
3105: )
3106: AND inv_globals.equal(p_trolin_rec.inspection_status, l_trolin_rec.inspection_status)
3107: AND (inv_globals.equal(p_trolin_rec.pick_methodology_id, l_trolin_rec.pick_methodology_id)
3108: OR (p_trolin_rec.pick_methodology_id = fnd_api.g_miss_num
3109: AND l_trolin_rec.pick_methodology_id IS NULL
3110: )
3103: AND l_trolin_rec.to_lpn_id IS NULL
3104: )
3105: )
3106: AND inv_globals.equal(p_trolin_rec.inspection_status, l_trolin_rec.inspection_status)
3107: AND (inv_globals.equal(p_trolin_rec.pick_methodology_id, l_trolin_rec.pick_methodology_id)
3108: OR (p_trolin_rec.pick_methodology_id = fnd_api.g_miss_num
3109: AND l_trolin_rec.pick_methodology_id IS NULL
3110: )
3111: )
3108: OR (p_trolin_rec.pick_methodology_id = fnd_api.g_miss_num
3109: AND l_trolin_rec.pick_methodology_id IS NULL
3110: )
3111: )
3112: AND (inv_globals.equal(p_trolin_rec.container_item_id, l_trolin_rec.container_item_id)
3113: OR (p_trolin_rec.container_item_id = fnd_api.g_miss_num
3114: AND l_trolin_rec.container_item_id IS NULL
3115: )
3116: )
3113: OR (p_trolin_rec.container_item_id = fnd_api.g_miss_num
3114: AND l_trolin_rec.container_item_id IS NULL
3115: )
3116: )
3117: AND (inv_globals.equal(p_trolin_rec.carton_grouping_id, l_trolin_rec.carton_grouping_id)
3118: OR (p_trolin_rec.carton_grouping_id = fnd_api.g_miss_num
3119: AND l_trolin_rec.carton_grouping_id IS NULL
3120: )
3121: )
3118: OR (p_trolin_rec.carton_grouping_id = fnd_api.g_miss_num
3119: AND l_trolin_rec.carton_grouping_id IS NULL
3120: )
3121: )
3122: AND (inv_globals.equal(p_trolin_rec.wms_process_flag, l_trolin_rec.wms_process_flag)
3123: OR (p_trolin_rec.wms_process_flag = fnd_api.g_miss_char
3124: AND l_trolin_rec.wms_process_flag IS NULL
3125: )
3126: )
3123: OR (p_trolin_rec.wms_process_flag = fnd_api.g_miss_char
3124: AND l_trolin_rec.wms_process_flag IS NULL
3125: )
3126: )
3127: AND (inv_globals.equal(p_trolin_rec.pick_slip_number, l_trolin_rec.pick_slip_number)
3128: OR (p_trolin_rec.pick_slip_number = fnd_api.g_miss_num
3129: AND l_trolin_rec.pick_slip_number IS NULL
3130: )
3131: )
3128: OR (p_trolin_rec.pick_slip_number = fnd_api.g_miss_num
3129: AND l_trolin_rec.pick_slip_number IS NULL
3130: )
3131: )
3132: AND (inv_globals.equal(p_trolin_rec.pick_slip_date, l_trolin_rec.pick_slip_date)
3133: OR (p_trolin_rec.pick_slip_date = fnd_api.g_miss_date
3134: AND l_trolin_rec.pick_slip_date IS NULL
3135: )
3136: )
3133: OR (p_trolin_rec.pick_slip_date = fnd_api.g_miss_date
3134: AND l_trolin_rec.pick_slip_date IS NULL
3135: )
3136: )
3137: AND (inv_globals.equal(p_trolin_rec.ship_set_id, l_trolin_rec.ship_set_id)
3138: OR (p_trolin_rec.ship_set_id = fnd_api.g_miss_num
3139: AND l_trolin_rec.ship_set_id IS NULL
3140: )
3141: )
3138: OR (p_trolin_rec.ship_set_id = fnd_api.g_miss_num
3139: AND l_trolin_rec.ship_set_id IS NULL
3140: )
3141: )
3142: AND (inv_globals.equal(p_trolin_rec.ship_model_id, l_trolin_rec.ship_model_id)
3143: OR (p_trolin_rec.ship_model_id = fnd_api.g_miss_num
3144: AND l_trolin_rec.ship_model_id IS NULL
3145: )
3146: )
3143: OR (p_trolin_rec.ship_model_id = fnd_api.g_miss_num
3144: AND l_trolin_rec.ship_model_id IS NULL
3145: )
3146: )
3147: AND (inv_globals.equal(p_trolin_rec.model_quantity, l_trolin_rec.model_quantity)
3148: OR (p_trolin_rec.model_quantity = fnd_api.g_miss_num
3149: AND l_trolin_rec.model_quantity IS NULL
3150: )
3151: ) THEN
3202: BEGIN
3203: -- Line2147
3204: IF p_trolin_rec.from_locator_id IS NOT NULL
3205: AND p_trolin_rec.from_locator_id <> fnd_api.g_miss_num
3206: AND NOT inv_globals.equal(p_trolin_rec.from_locator_id, p_old_trolin_rec.from_locator_id) THEN
3207: l_trolin_val_rec.from_locator := inv_id_to_value.from_locator(p_from_locator_id => p_trolin_rec.from_locator_id);
3208: END IF;
3209:
3210: -- IF p_trolin_rec.from_subinventory_code IS NOT NULL AND
3208: END IF;
3209:
3210: -- IF p_trolin_rec.from_subinventory_code IS NOT NULL AND
3211: -- p_trolin_rec.from_subinventory_code <> FND_API.G_MISS_CHAR AND
3212: -- NOT INV_GLOBALS.Equal(p_trolin_rec.from_subinventory_code,
3213: -- p_old_trolin_rec.from_subinventory_code)
3214: -- THEN
3215: -- l_trolin_val_rec.from_subinventory := INV_Id_To_Value.From_Subinventory
3216: -- ( p_from_subinventory_code => p_trolin_rec.from_subinventory_code
3218: -- END IF; -- Generated
3219: -- Line 2167
3220: IF p_trolin_rec.from_subinventory_id IS NOT NULL
3221: AND p_trolin_rec.from_subinventory_id <> fnd_api.g_miss_num
3222: AND NOT inv_globals.equal(p_trolin_rec.from_subinventory_id, p_old_trolin_rec.from_subinventory_id) THEN
3223: l_trolin_val_rec.from_subinventory := inv_id_to_value.from_subinventory(p_from_subinventory_id => p_trolin_rec.from_subinventory_id);
3224: -- ( p_from_subinventory_id => p_trolin_rec.from_subinventory_id
3225: -- );
3226: END IF;
3226: END IF;
3227:
3228: IF p_trolin_rec.header_id IS NOT NULL
3229: AND p_trolin_rec.header_id <> fnd_api.g_miss_num
3230: AND NOT inv_globals.equal(p_trolin_rec.header_id, p_old_trolin_rec.header_id) THEN
3231: l_trolin_val_rec.header := inv_id_to_value.header(p_header_id => p_trolin_rec.header_id);
3232: END IF;
3233:
3234: IF p_trolin_rec.inventory_item_id IS NOT NULL
3232: END IF;
3233:
3234: IF p_trolin_rec.inventory_item_id IS NOT NULL
3235: AND p_trolin_rec.inventory_item_id <> fnd_api.g_miss_num
3236: AND NOT inv_globals.equal(p_trolin_rec.inventory_item_id, p_old_trolin_rec.inventory_item_id) THEN
3237: l_trolin_val_rec.inventory_item := inv_id_to_value.inventory_item(p_inventory_item_id => p_trolin_rec.inventory_item_id);
3238: END IF;
3239:
3240: IF p_trolin_rec.line_id IS NOT NULL
3238: END IF;
3239:
3240: IF p_trolin_rec.line_id IS NOT NULL
3241: AND p_trolin_rec.line_id <> fnd_api.g_miss_num
3242: AND NOT inv_globals.equal(p_trolin_rec.line_id, p_old_trolin_rec.line_id) THEN
3243: l_trolin_val_rec.line := inv_id_to_value.line(p_line_id => p_trolin_rec.line_id);
3244: END IF;
3245:
3246: IF p_trolin_rec.organization_id IS NOT NULL
3244: END IF;
3245:
3246: IF p_trolin_rec.organization_id IS NOT NULL
3247: AND p_trolin_rec.organization_id <> fnd_api.g_miss_num
3248: AND NOT inv_globals.equal(p_trolin_rec.organization_id, p_old_trolin_rec.organization_id) THEN
3249: l_trolin_val_rec.ORGANIZATION := inv_id_to_value.ORGANIZATION(p_organization_id => p_trolin_rec.organization_id);
3250: END IF;
3251:
3252: IF p_trolin_rec.to_organization_id IS NOT NULL
3250: END IF;
3251:
3252: IF p_trolin_rec.to_organization_id IS NOT NULL
3253: AND p_trolin_rec.to_organization_id <> fnd_api.g_miss_num
3254: AND NOT inv_globals.equal(p_trolin_rec.to_organization_id, p_old_trolin_rec.to_organization_id) THEN
3255: l_trolin_val_rec.to_organization := inv_id_to_value.to_organization(p_to_organization_id => p_trolin_rec.to_organization_id);
3256: END IF;
3257:
3258: IF p_trolin_rec.project_id IS NOT NULL
3256: END IF;
3257:
3258: IF p_trolin_rec.project_id IS NOT NULL
3259: AND p_trolin_rec.project_id <> fnd_api.g_miss_num
3260: AND NOT inv_globals.equal(p_trolin_rec.project_id, p_old_trolin_rec.project_id) THEN
3261: l_trolin_val_rec.project := inv_id_to_value.project(p_project_id => p_trolin_rec.project_id);
3262: END IF;
3263:
3264: IF p_trolin_rec.reason_id IS NOT NULL
3262: END IF;
3263:
3264: IF p_trolin_rec.reason_id IS NOT NULL
3265: AND p_trolin_rec.reason_id <> fnd_api.g_miss_num
3266: AND NOT inv_globals.equal(p_trolin_rec.reason_id, p_old_trolin_rec.reason_id) THEN
3267: l_trolin_val_rec.reason := inv_id_to_value.reason(p_reason_id => p_trolin_rec.reason_id);
3268: END IF;
3269:
3270: IF p_trolin_rec.reference_id IS NOT NULL
3268: END IF;
3269:
3270: IF p_trolin_rec.reference_id IS NOT NULL
3271: AND p_trolin_rec.reference_id <> fnd_api.g_miss_num
3272: AND NOT inv_globals.equal(p_trolin_rec.reference_id, p_old_trolin_rec.reference_id) THEN
3273: l_trolin_val_rec.REFERENCE := inv_id_to_value.REFERENCE(p_reference_id => p_trolin_rec.reference_id);
3274: END IF;
3275:
3276: IF p_trolin_rec.reference_type_code IS NOT NULL
3274: END IF;
3275:
3276: IF p_trolin_rec.reference_type_code IS NOT NULL
3277: AND p_trolin_rec.reference_type_code <> fnd_api.g_miss_num
3278: AND NOT inv_globals.equal(p_trolin_rec.reference_type_code, p_old_trolin_rec.reference_type_code) THEN
3279: l_trolin_val_rec.reference_type := inv_id_to_value.reference_type(p_reference_type_code => p_trolin_rec.reference_type_code);
3280: END IF;
3281:
3282: IF p_trolin_rec.task_id IS NOT NULL
3280: END IF;
3281:
3282: IF p_trolin_rec.task_id IS NOT NULL
3283: AND p_trolin_rec.task_id <> fnd_api.g_miss_num
3284: AND NOT inv_globals.equal(p_trolin_rec.task_id, p_old_trolin_rec.task_id) THEN
3285: l_trolin_val_rec.task := inv_id_to_value.task(p_task_id => p_trolin_rec.task_id);
3286: END IF;
3287:
3288: IF p_trolin_rec.to_account_id IS NOT NULL
3286: END IF;
3287:
3288: IF p_trolin_rec.to_account_id IS NOT NULL
3289: AND p_trolin_rec.to_account_id <> fnd_api.g_miss_num
3290: AND NOT inv_globals.equal(p_trolin_rec.to_account_id, p_old_trolin_rec.to_account_id) THEN
3291: l_trolin_val_rec.to_account := inv_id_to_value.to_account(p_to_account_id => p_trolin_rec.to_account_id);
3292: END IF;
3293:
3294: IF p_trolin_rec.to_locator_id IS NOT NULL
3292: END IF;
3293:
3294: IF p_trolin_rec.to_locator_id IS NOT NULL
3295: AND p_trolin_rec.to_locator_id <> fnd_api.g_miss_num
3296: AND NOT inv_globals.equal(p_trolin_rec.to_locator_id, p_old_trolin_rec.to_locator_id) THEN
3297: l_trolin_val_rec.to_locator := inv_id_to_value.to_locator(p_to_locator_id => p_trolin_rec.to_locator_id);
3298: END IF;
3299:
3300: -- IF p_trolin_rec.to_subinventory_code IS NOT NULL AND
3298: END IF;
3299:
3300: -- IF p_trolin_rec.to_subinventory_code IS NOT NULL AND
3301: -- p_trolin_rec.to_subinventory_code <> FND_API.G_MISS_CHAR AND
3302: -- NOT INV_GLOBALS.Equal(p_trolin_rec.to_subinventory_code,
3303: -- p_old_trolin_rec.to_subinventory_code)
3304: -- THEN
3305: -- l_trolin_val_rec.to_subinventory := INV_Id_To_Value.To_Subinventory
3306: -- ( p_to_subinventory_code => p_trolin_rec.to_subinventory_code
3308: -- END IF; -- Generated
3309:
3310: IF p_trolin_rec.to_subinventory_id IS NOT NULL
3311: AND p_trolin_rec.to_subinventory_id <> fnd_api.g_miss_num
3312: AND NOT inv_globals.equal(p_trolin_rec.to_subinventory_id, p_old_trolin_rec.to_subinventory_id) THEN
3313: l_trolin_val_rec.to_subinventory := inv_id_to_value.to_subinventory(p_to_subinventory_id => p_trolin_rec.to_subinventory_id);
3314: END IF;
3315:
3316: IF p_trolin_rec.transaction_header_id IS NOT NULL
3314: END IF;
3315:
3316: IF p_trolin_rec.transaction_header_id IS NOT NULL
3317: AND p_trolin_rec.transaction_header_id <> fnd_api.g_miss_num
3318: AND NOT inv_globals.equal(p_trolin_rec.transaction_header_id, p_old_trolin_rec.transaction_header_id) THEN
3319: l_trolin_val_rec.transaction_header := inv_id_to_value.transaction_header(p_transaction_header_id => p_trolin_rec.transaction_header_id);
3320: END IF;
3321:
3322: IF p_trolin_rec.transaction_type_id IS NOT NULL
3320: END IF;
3321:
3322: IF p_trolin_rec.transaction_type_id IS NOT NULL
3323: AND p_trolin_rec.transaction_type_id <> fnd_api.g_miss_num
3324: AND NOT inv_globals.equal(p_trolin_rec.transaction_type_id, p_old_trolin_rec.transaction_type_id) THEN
3325: l_trolin_val_rec.transaction_type := inv_id_to_value.transaction_type(p_transaction_type_id => p_trolin_rec.transaction_type_id);
3326: END IF;
3327:
3328: IF p_trolin_rec.uom_code IS NOT NULL
3326: END IF;
3327:
3328: IF p_trolin_rec.uom_code IS NOT NULL
3329: AND p_trolin_rec.uom_code <> fnd_api.g_miss_char
3330: AND NOT inv_globals.equal(p_trolin_rec.uom_code, p_old_trolin_rec.uom_code) THEN
3331: l_trolin_val_rec.uom := inv_id_to_value.uom(p_uom_code => p_trolin_rec.uom_code);
3332: END IF;
3333:
3334: RETURN l_trolin_val_rec;