[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;
2855: FOR UPDATE NOWAIT;
2856:
2857: -- Row locked. Compare IN attributes to DB attributes.
2858:
2859: IF inv_globals.equal(p_trolin_rec.attribute1, l_trolin_rec.attribute1)
2860: AND inv_globals.equal(p_trolin_rec.attribute10, l_trolin_rec.attribute10)
2861: AND inv_globals.equal(p_trolin_rec.attribute11, l_trolin_rec.attribute11)
2862: AND inv_globals.equal(p_trolin_rec.attribute12, l_trolin_rec.attribute12)
2863: AND inv_globals.equal(p_trolin_rec.attribute13, l_trolin_rec.attribute13)
2856:
2857: -- Row locked. Compare IN attributes to DB attributes.
2858:
2859: IF inv_globals.equal(p_trolin_rec.attribute1, l_trolin_rec.attribute1)
2860: AND inv_globals.equal(p_trolin_rec.attribute10, l_trolin_rec.attribute10)
2861: AND inv_globals.equal(p_trolin_rec.attribute11, l_trolin_rec.attribute11)
2862: AND inv_globals.equal(p_trolin_rec.attribute12, l_trolin_rec.attribute12)
2863: AND inv_globals.equal(p_trolin_rec.attribute13, l_trolin_rec.attribute13)
2864: AND inv_globals.equal(p_trolin_rec.attribute14, l_trolin_rec.attribute14)
2857: -- Row locked. Compare IN attributes to DB attributes.
2858:
2859: IF inv_globals.equal(p_trolin_rec.attribute1, l_trolin_rec.attribute1)
2860: AND inv_globals.equal(p_trolin_rec.attribute10, l_trolin_rec.attribute10)
2861: AND inv_globals.equal(p_trolin_rec.attribute11, l_trolin_rec.attribute11)
2862: AND inv_globals.equal(p_trolin_rec.attribute12, l_trolin_rec.attribute12)
2863: AND inv_globals.equal(p_trolin_rec.attribute13, l_trolin_rec.attribute13)
2864: AND inv_globals.equal(p_trolin_rec.attribute14, l_trolin_rec.attribute14)
2865: AND inv_globals.equal(p_trolin_rec.attribute15, l_trolin_rec.attribute15)
2858:
2859: IF inv_globals.equal(p_trolin_rec.attribute1, l_trolin_rec.attribute1)
2860: AND inv_globals.equal(p_trolin_rec.attribute10, l_trolin_rec.attribute10)
2861: AND inv_globals.equal(p_trolin_rec.attribute11, l_trolin_rec.attribute11)
2862: AND inv_globals.equal(p_trolin_rec.attribute12, l_trolin_rec.attribute12)
2863: AND inv_globals.equal(p_trolin_rec.attribute13, l_trolin_rec.attribute13)
2864: AND inv_globals.equal(p_trolin_rec.attribute14, l_trolin_rec.attribute14)
2865: AND inv_globals.equal(p_trolin_rec.attribute15, l_trolin_rec.attribute15)
2866: AND inv_globals.equal(p_trolin_rec.attribute2, l_trolin_rec.attribute2)
2859: IF inv_globals.equal(p_trolin_rec.attribute1, l_trolin_rec.attribute1)
2860: AND inv_globals.equal(p_trolin_rec.attribute10, l_trolin_rec.attribute10)
2861: AND inv_globals.equal(p_trolin_rec.attribute11, l_trolin_rec.attribute11)
2862: AND inv_globals.equal(p_trolin_rec.attribute12, l_trolin_rec.attribute12)
2863: AND inv_globals.equal(p_trolin_rec.attribute13, l_trolin_rec.attribute13)
2864: AND inv_globals.equal(p_trolin_rec.attribute14, l_trolin_rec.attribute14)
2865: AND inv_globals.equal(p_trolin_rec.attribute15, l_trolin_rec.attribute15)
2866: AND inv_globals.equal(p_trolin_rec.attribute2, l_trolin_rec.attribute2)
2867: AND inv_globals.equal(p_trolin_rec.attribute3, l_trolin_rec.attribute3)
2860: AND inv_globals.equal(p_trolin_rec.attribute10, l_trolin_rec.attribute10)
2861: AND inv_globals.equal(p_trolin_rec.attribute11, l_trolin_rec.attribute11)
2862: AND inv_globals.equal(p_trolin_rec.attribute12, l_trolin_rec.attribute12)
2863: AND inv_globals.equal(p_trolin_rec.attribute13, l_trolin_rec.attribute13)
2864: AND inv_globals.equal(p_trolin_rec.attribute14, l_trolin_rec.attribute14)
2865: AND inv_globals.equal(p_trolin_rec.attribute15, l_trolin_rec.attribute15)
2866: AND inv_globals.equal(p_trolin_rec.attribute2, l_trolin_rec.attribute2)
2867: AND inv_globals.equal(p_trolin_rec.attribute3, l_trolin_rec.attribute3)
2868: AND inv_globals.equal(p_trolin_rec.attribute4, l_trolin_rec.attribute4)
2861: AND inv_globals.equal(p_trolin_rec.attribute11, l_trolin_rec.attribute11)
2862: AND inv_globals.equal(p_trolin_rec.attribute12, l_trolin_rec.attribute12)
2863: AND inv_globals.equal(p_trolin_rec.attribute13, l_trolin_rec.attribute13)
2864: AND inv_globals.equal(p_trolin_rec.attribute14, l_trolin_rec.attribute14)
2865: AND inv_globals.equal(p_trolin_rec.attribute15, l_trolin_rec.attribute15)
2866: AND inv_globals.equal(p_trolin_rec.attribute2, l_trolin_rec.attribute2)
2867: AND inv_globals.equal(p_trolin_rec.attribute3, l_trolin_rec.attribute3)
2868: AND inv_globals.equal(p_trolin_rec.attribute4, l_trolin_rec.attribute4)
2869: AND inv_globals.equal(p_trolin_rec.attribute5, l_trolin_rec.attribute5)
2862: AND inv_globals.equal(p_trolin_rec.attribute12, l_trolin_rec.attribute12)
2863: AND inv_globals.equal(p_trolin_rec.attribute13, l_trolin_rec.attribute13)
2864: AND inv_globals.equal(p_trolin_rec.attribute14, l_trolin_rec.attribute14)
2865: AND inv_globals.equal(p_trolin_rec.attribute15, l_trolin_rec.attribute15)
2866: AND inv_globals.equal(p_trolin_rec.attribute2, l_trolin_rec.attribute2)
2867: AND inv_globals.equal(p_trolin_rec.attribute3, l_trolin_rec.attribute3)
2868: AND inv_globals.equal(p_trolin_rec.attribute4, l_trolin_rec.attribute4)
2869: AND inv_globals.equal(p_trolin_rec.attribute5, l_trolin_rec.attribute5)
2870: AND inv_globals.equal(p_trolin_rec.attribute6, l_trolin_rec.attribute6)
2863: AND inv_globals.equal(p_trolin_rec.attribute13, l_trolin_rec.attribute13)
2864: AND inv_globals.equal(p_trolin_rec.attribute14, l_trolin_rec.attribute14)
2865: AND inv_globals.equal(p_trolin_rec.attribute15, l_trolin_rec.attribute15)
2866: AND inv_globals.equal(p_trolin_rec.attribute2, l_trolin_rec.attribute2)
2867: AND inv_globals.equal(p_trolin_rec.attribute3, l_trolin_rec.attribute3)
2868: AND inv_globals.equal(p_trolin_rec.attribute4, l_trolin_rec.attribute4)
2869: AND inv_globals.equal(p_trolin_rec.attribute5, l_trolin_rec.attribute5)
2870: AND inv_globals.equal(p_trolin_rec.attribute6, l_trolin_rec.attribute6)
2871: AND inv_globals.equal(p_trolin_rec.attribute7, l_trolin_rec.attribute7)
2864: AND inv_globals.equal(p_trolin_rec.attribute14, l_trolin_rec.attribute14)
2865: AND inv_globals.equal(p_trolin_rec.attribute15, l_trolin_rec.attribute15)
2866: AND inv_globals.equal(p_trolin_rec.attribute2, l_trolin_rec.attribute2)
2867: AND inv_globals.equal(p_trolin_rec.attribute3, l_trolin_rec.attribute3)
2868: AND inv_globals.equal(p_trolin_rec.attribute4, l_trolin_rec.attribute4)
2869: AND inv_globals.equal(p_trolin_rec.attribute5, l_trolin_rec.attribute5)
2870: AND inv_globals.equal(p_trolin_rec.attribute6, l_trolin_rec.attribute6)
2871: AND inv_globals.equal(p_trolin_rec.attribute7, l_trolin_rec.attribute7)
2872: AND inv_globals.equal(p_trolin_rec.attribute8, l_trolin_rec.attribute8)
2865: AND inv_globals.equal(p_trolin_rec.attribute15, l_trolin_rec.attribute15)
2866: AND inv_globals.equal(p_trolin_rec.attribute2, l_trolin_rec.attribute2)
2867: AND inv_globals.equal(p_trolin_rec.attribute3, l_trolin_rec.attribute3)
2868: AND inv_globals.equal(p_trolin_rec.attribute4, l_trolin_rec.attribute4)
2869: AND inv_globals.equal(p_trolin_rec.attribute5, l_trolin_rec.attribute5)
2870: AND inv_globals.equal(p_trolin_rec.attribute6, l_trolin_rec.attribute6)
2871: AND inv_globals.equal(p_trolin_rec.attribute7, l_trolin_rec.attribute7)
2872: AND inv_globals.equal(p_trolin_rec.attribute8, l_trolin_rec.attribute8)
2873: AND inv_globals.equal(p_trolin_rec.attribute9, l_trolin_rec.attribute9)
2866: AND inv_globals.equal(p_trolin_rec.attribute2, l_trolin_rec.attribute2)
2867: AND inv_globals.equal(p_trolin_rec.attribute3, l_trolin_rec.attribute3)
2868: AND inv_globals.equal(p_trolin_rec.attribute4, l_trolin_rec.attribute4)
2869: AND inv_globals.equal(p_trolin_rec.attribute5, l_trolin_rec.attribute5)
2870: AND inv_globals.equal(p_trolin_rec.attribute6, l_trolin_rec.attribute6)
2871: AND inv_globals.equal(p_trolin_rec.attribute7, l_trolin_rec.attribute7)
2872: AND inv_globals.equal(p_trolin_rec.attribute8, l_trolin_rec.attribute8)
2873: AND inv_globals.equal(p_trolin_rec.attribute9, l_trolin_rec.attribute9)
2874: AND inv_globals.equal(p_trolin_rec.attribute_category, l_trolin_rec.attribute_category)
2867: AND inv_globals.equal(p_trolin_rec.attribute3, l_trolin_rec.attribute3)
2868: AND inv_globals.equal(p_trolin_rec.attribute4, l_trolin_rec.attribute4)
2869: AND inv_globals.equal(p_trolin_rec.attribute5, l_trolin_rec.attribute5)
2870: AND inv_globals.equal(p_trolin_rec.attribute6, l_trolin_rec.attribute6)
2871: AND inv_globals.equal(p_trolin_rec.attribute7, l_trolin_rec.attribute7)
2872: AND inv_globals.equal(p_trolin_rec.attribute8, l_trolin_rec.attribute8)
2873: AND inv_globals.equal(p_trolin_rec.attribute9, l_trolin_rec.attribute9)
2874: AND inv_globals.equal(p_trolin_rec.attribute_category, l_trolin_rec.attribute_category)
2875: AND (inv_globals.equal(p_trolin_rec.created_by, l_trolin_rec.created_by)
2868: AND inv_globals.equal(p_trolin_rec.attribute4, l_trolin_rec.attribute4)
2869: AND inv_globals.equal(p_trolin_rec.attribute5, l_trolin_rec.attribute5)
2870: AND inv_globals.equal(p_trolin_rec.attribute6, l_trolin_rec.attribute6)
2871: AND inv_globals.equal(p_trolin_rec.attribute7, l_trolin_rec.attribute7)
2872: AND inv_globals.equal(p_trolin_rec.attribute8, l_trolin_rec.attribute8)
2873: AND inv_globals.equal(p_trolin_rec.attribute9, l_trolin_rec.attribute9)
2874: AND inv_globals.equal(p_trolin_rec.attribute_category, l_trolin_rec.attribute_category)
2875: AND (inv_globals.equal(p_trolin_rec.created_by, l_trolin_rec.created_by)
2876: OR (p_trolin_rec.created_by = fnd_api.g_miss_num
2869: AND inv_globals.equal(p_trolin_rec.attribute5, l_trolin_rec.attribute5)
2870: AND inv_globals.equal(p_trolin_rec.attribute6, l_trolin_rec.attribute6)
2871: AND inv_globals.equal(p_trolin_rec.attribute7, l_trolin_rec.attribute7)
2872: AND inv_globals.equal(p_trolin_rec.attribute8, l_trolin_rec.attribute8)
2873: AND inv_globals.equal(p_trolin_rec.attribute9, l_trolin_rec.attribute9)
2874: AND inv_globals.equal(p_trolin_rec.attribute_category, l_trolin_rec.attribute_category)
2875: AND (inv_globals.equal(p_trolin_rec.created_by, l_trolin_rec.created_by)
2876: OR (p_trolin_rec.created_by = fnd_api.g_miss_num
2877: AND l_trolin_rec.created_by IS NULL
2870: AND inv_globals.equal(p_trolin_rec.attribute6, l_trolin_rec.attribute6)
2871: AND inv_globals.equal(p_trolin_rec.attribute7, l_trolin_rec.attribute7)
2872: AND inv_globals.equal(p_trolin_rec.attribute8, l_trolin_rec.attribute8)
2873: AND inv_globals.equal(p_trolin_rec.attribute9, l_trolin_rec.attribute9)
2874: AND inv_globals.equal(p_trolin_rec.attribute_category, l_trolin_rec.attribute_category)
2875: AND (inv_globals.equal(p_trolin_rec.created_by, l_trolin_rec.created_by)
2876: OR (p_trolin_rec.created_by = fnd_api.g_miss_num
2877: AND l_trolin_rec.created_by IS NULL
2878: )
2871: AND inv_globals.equal(p_trolin_rec.attribute7, l_trolin_rec.attribute7)
2872: AND inv_globals.equal(p_trolin_rec.attribute8, l_trolin_rec.attribute8)
2873: AND inv_globals.equal(p_trolin_rec.attribute9, l_trolin_rec.attribute9)
2874: AND inv_globals.equal(p_trolin_rec.attribute_category, l_trolin_rec.attribute_category)
2875: AND (inv_globals.equal(p_trolin_rec.created_by, l_trolin_rec.created_by)
2876: OR (p_trolin_rec.created_by = fnd_api.g_miss_num
2877: AND l_trolin_rec.created_by IS NULL
2878: )
2879: )
2876: OR (p_trolin_rec.created_by = fnd_api.g_miss_num
2877: AND l_trolin_rec.created_by IS NULL
2878: )
2879: )
2880: AND (inv_globals.equal(p_trolin_rec.creation_date, l_trolin_rec.creation_date)
2881: OR (p_trolin_rec.creation_date = fnd_api.g_miss_date
2882: AND l_trolin_rec.creation_date IS NULL
2883: )
2884: )
2881: OR (p_trolin_rec.creation_date = fnd_api.g_miss_date
2882: AND l_trolin_rec.creation_date IS NULL
2883: )
2884: )
2885: AND (inv_globals.equal(p_trolin_rec.date_required, l_trolin_rec.date_required)
2886: OR (p_trolin_rec.date_required = fnd_api.g_miss_date
2887: AND l_trolin_rec.date_required IS NULL
2888: )
2889: )
2886: OR (p_trolin_rec.date_required = fnd_api.g_miss_date
2887: AND l_trolin_rec.date_required IS NULL
2888: )
2889: )
2890: AND (inv_globals.equal(p_trolin_rec.from_locator_id, l_trolin_rec.from_locator_id)
2891: OR (p_trolin_rec.from_locator_id = fnd_api.g_miss_num
2892: AND l_trolin_rec.from_locator_id IS NULL
2893: )
2894: )
2891: OR (p_trolin_rec.from_locator_id = fnd_api.g_miss_num
2892: AND l_trolin_rec.from_locator_id IS NULL
2893: )
2894: )
2895: AND (inv_globals.equal(p_trolin_rec.from_subinventory_code, l_trolin_rec.from_subinventory_code)
2896: OR (p_trolin_rec.from_subinventory_code = fnd_api.g_miss_char
2897: AND l_trolin_rec.from_subinventory_code IS NULL
2898: )
2899: )
2896: OR (p_trolin_rec.from_subinventory_code = fnd_api.g_miss_char
2897: AND l_trolin_rec.from_subinventory_code IS NULL
2898: )
2899: )
2900: AND (inv_globals.equal(p_trolin_rec.from_subinventory_id, l_trolin_rec.from_subinventory_id)
2901: OR (p_trolin_rec.from_subinventory_id = fnd_api.g_miss_num
2902: AND l_trolin_rec.from_subinventory_id IS NULL
2903: )
2904: )
2901: OR (p_trolin_rec.from_subinventory_id = fnd_api.g_miss_num
2902: AND l_trolin_rec.from_subinventory_id IS NULL
2903: )
2904: )
2905: AND (inv_globals.equal(p_trolin_rec.header_id, l_trolin_rec.header_id)
2906: OR (p_trolin_rec.header_id = fnd_api.g_miss_num
2907: AND l_trolin_rec.header_id IS NULL
2908: )
2909: )
2906: OR (p_trolin_rec.header_id = fnd_api.g_miss_num
2907: AND l_trolin_rec.header_id IS NULL
2908: )
2909: )
2910: AND (inv_globals.equal(p_trolin_rec.inventory_item_id, l_trolin_rec.inventory_item_id)
2911: OR (p_trolin_rec.inventory_item_id = fnd_api.g_miss_num
2912: AND l_trolin_rec.inventory_item_id IS NULL
2913: )
2914: )
2911: OR (p_trolin_rec.inventory_item_id = fnd_api.g_miss_num
2912: AND l_trolin_rec.inventory_item_id IS NULL
2913: )
2914: )
2915: AND (inv_globals.equal(p_trolin_rec.last_updated_by, l_trolin_rec.last_updated_by)
2916: OR (p_trolin_rec.last_updated_by = fnd_api.g_miss_num
2917: AND l_trolin_rec.last_updated_by IS NULL
2918: )
2919: )
2916: OR (p_trolin_rec.last_updated_by = fnd_api.g_miss_num
2917: AND l_trolin_rec.last_updated_by IS NULL
2918: )
2919: )
2920: AND (inv_globals.equal(p_trolin_rec.last_update_date, l_trolin_rec.last_update_date)
2921: OR (p_trolin_rec.last_update_date = fnd_api.g_miss_date
2922: AND l_trolin_rec.last_update_date IS NULL
2923: )
2924: )
2921: OR (p_trolin_rec.last_update_date = fnd_api.g_miss_date
2922: AND l_trolin_rec.last_update_date IS NULL
2923: )
2924: )
2925: AND (inv_globals.equal(p_trolin_rec.last_update_login, l_trolin_rec.last_update_login)
2926: OR (p_trolin_rec.last_update_login = fnd_api.g_miss_num
2927: AND l_trolin_rec.last_update_login IS NULL
2928: )
2929: )
2926: OR (p_trolin_rec.last_update_login = fnd_api.g_miss_num
2927: AND l_trolin_rec.last_update_login IS NULL
2928: )
2929: )
2930: AND (inv_globals.equal(p_trolin_rec.line_id, l_trolin_rec.line_id)
2931: OR (p_trolin_rec.line_id = fnd_api.g_miss_num
2932: AND l_trolin_rec.line_id IS NULL
2933: )
2934: )
2931: OR (p_trolin_rec.line_id = fnd_api.g_miss_num
2932: AND l_trolin_rec.line_id IS NULL
2933: )
2934: )
2935: AND (inv_globals.equal(p_trolin_rec.line_number, l_trolin_rec.line_number)
2936: OR (p_trolin_rec.line_number = fnd_api.g_miss_num
2937: AND l_trolin_rec.line_number IS NULL
2938: )
2939: )
2936: OR (p_trolin_rec.line_number = fnd_api.g_miss_num
2937: AND l_trolin_rec.line_number IS NULL
2938: )
2939: )
2940: AND (inv_globals.equal(p_trolin_rec.line_status, l_trolin_rec.line_status)
2941: OR (p_trolin_rec.line_status = fnd_api.g_miss_num
2942: AND l_trolin_rec.line_status IS NULL
2943: )
2944: )
2941: OR (p_trolin_rec.line_status = fnd_api.g_miss_num
2942: AND l_trolin_rec.line_status IS NULL
2943: )
2944: )
2945: AND (inv_globals.equal(p_trolin_rec.lot_number, l_trolin_rec.lot_number)
2946: OR (p_trolin_rec.lot_number = fnd_api.g_miss_char
2947: AND l_trolin_rec.lot_number IS NULL
2948: )
2949: )
2946: OR (p_trolin_rec.lot_number = fnd_api.g_miss_char
2947: AND l_trolin_rec.lot_number IS NULL
2948: )
2949: )
2950: AND (inv_globals.equal(p_trolin_rec.organization_id, l_trolin_rec.organization_id)
2951: OR (p_trolin_rec.organization_id = fnd_api.g_miss_num
2952: AND l_trolin_rec.organization_id IS NULL
2953: )
2954: )
2951: OR (p_trolin_rec.organization_id = fnd_api.g_miss_num
2952: AND l_trolin_rec.organization_id IS NULL
2953: )
2954: )
2955: AND (inv_globals.equal(p_trolin_rec.program_application_id, l_trolin_rec.program_application_id)
2956: OR (p_trolin_rec.program_application_id = fnd_api.g_miss_num
2957: AND l_trolin_rec.program_application_id IS NULL
2958: )
2959: )
2956: OR (p_trolin_rec.program_application_id = fnd_api.g_miss_num
2957: AND l_trolin_rec.program_application_id IS NULL
2958: )
2959: )
2960: AND (inv_globals.equal(p_trolin_rec.program_id, l_trolin_rec.program_id)
2961: OR (p_trolin_rec.program_id = fnd_api.g_miss_num
2962: AND l_trolin_rec.program_id IS NULL
2963: )
2964: )
2961: OR (p_trolin_rec.program_id = fnd_api.g_miss_num
2962: AND l_trolin_rec.program_id IS NULL
2963: )
2964: )
2965: AND (inv_globals.equal(p_trolin_rec.program_update_date, l_trolin_rec.program_update_date)
2966: OR (p_trolin_rec.program_update_date = fnd_api.g_miss_date
2967: AND l_trolin_rec.program_update_date IS NOT NULL
2968: )
2969: )
2966: OR (p_trolin_rec.program_update_date = fnd_api.g_miss_date
2967: AND l_trolin_rec.program_update_date IS NOT NULL
2968: )
2969: )
2970: AND (inv_globals.equal(p_trolin_rec.project_id, l_trolin_rec.project_id)
2971: OR (p_trolin_rec.project_id = fnd_api.g_miss_num
2972: AND l_trolin_rec.project_id IS NULL
2973: )
2974: )
2971: OR (p_trolin_rec.project_id = fnd_api.g_miss_num
2972: AND l_trolin_rec.project_id IS NULL
2973: )
2974: )
2975: AND (inv_globals.equal(p_trolin_rec.quantity, l_trolin_rec.quantity)
2976: OR (p_trolin_rec.quantity = fnd_api.g_miss_num
2977: AND l_trolin_rec.quantity IS NULL
2978: )
2979: )
2976: OR (p_trolin_rec.quantity = fnd_api.g_miss_num
2977: AND l_trolin_rec.quantity IS NULL
2978: )
2979: )
2980: AND (inv_globals.equal(p_trolin_rec.quantity_delivered, l_trolin_rec.quantity_delivered)
2981: OR (p_trolin_rec.quantity_delivered = fnd_api.g_miss_num
2982: AND l_trolin_rec.quantity_delivered IS NULL
2983: )
2984: )
2981: OR (p_trolin_rec.quantity_delivered = fnd_api.g_miss_num
2982: AND l_trolin_rec.quantity_delivered IS NULL
2983: )
2984: )
2985: AND (inv_globals.equal(p_trolin_rec.quantity_detailed, l_trolin_rec.quantity_detailed)
2986: OR (p_trolin_rec.quantity_detailed = fnd_api.g_miss_num
2987: AND l_trolin_rec.quantity_detailed IS NULL
2988: )
2989: )
2986: OR (p_trolin_rec.quantity_detailed = fnd_api.g_miss_num
2987: AND l_trolin_rec.quantity_detailed IS NULL
2988: )
2989: )
2990: AND (inv_globals.equal(p_trolin_rec.reason_id, l_trolin_rec.reason_id)
2991: OR (p_trolin_rec.reason_id = fnd_api.g_miss_num
2992: AND l_trolin_rec.reason_id IS NULL
2993: )
2994: )
2991: OR (p_trolin_rec.reason_id = fnd_api.g_miss_num
2992: AND l_trolin_rec.reason_id IS NULL
2993: )
2994: )
2995: AND (inv_globals.equal(p_trolin_rec.REFERENCE, l_trolin_rec.REFERENCE)
2996: OR (p_trolin_rec.REFERENCE = fnd_api.g_miss_char
2997: AND l_trolin_rec.REFERENCE IS NULL
2998: )
2999: )
2996: OR (p_trolin_rec.REFERENCE = fnd_api.g_miss_char
2997: AND l_trolin_rec.REFERENCE IS NULL
2998: )
2999: )
3000: AND (inv_globals.equal(p_trolin_rec.reference_id, l_trolin_rec.reference_id)
3001: OR (p_trolin_rec.reference_id = fnd_api.g_miss_num
3002: AND l_trolin_rec.reference_id IS NULL
3003: )
3004: )
3001: OR (p_trolin_rec.reference_id = fnd_api.g_miss_num
3002: AND l_trolin_rec.reference_id IS NULL
3003: )
3004: )
3005: AND (inv_globals.equal(p_trolin_rec.reference_type_code, l_trolin_rec.reference_type_code)
3006: OR (l_trolin_rec.reference_type_code = fnd_api.g_miss_num
3007: AND l_trolin_rec.reference_type_code IS NULL
3008: )
3009: )
3006: OR (l_trolin_rec.reference_type_code = fnd_api.g_miss_num
3007: AND l_trolin_rec.reference_type_code IS NULL
3008: )
3009: )
3010: AND (inv_globals.equal(p_trolin_rec.request_id, l_trolin_rec.request_id)
3011: OR (p_trolin_rec.request_id = fnd_api.g_miss_num
3012: AND l_trolin_rec.request_id IS NULL
3013: )
3014: )
3011: OR (p_trolin_rec.request_id = fnd_api.g_miss_num
3012: AND l_trolin_rec.request_id IS NULL
3013: )
3014: )
3015: AND (inv_globals.equal(p_trolin_rec.revision, l_trolin_rec.revision)
3016: OR (p_trolin_rec.revision = fnd_api.g_miss_char
3017: AND l_trolin_rec.revision IS NULL
3018: )
3019: )
3016: OR (p_trolin_rec.revision = fnd_api.g_miss_char
3017: AND l_trolin_rec.revision IS NULL
3018: )
3019: )
3020: AND (inv_globals.equal(p_trolin_rec.serial_number_end, l_trolin_rec.serial_number_end)
3021: OR (p_trolin_rec.serial_number_end = fnd_api.g_miss_char
3022: AND l_trolin_rec.serial_number_end IS NULL
3023: )
3024: )
3021: OR (p_trolin_rec.serial_number_end = fnd_api.g_miss_char
3022: AND l_trolin_rec.serial_number_end IS NULL
3023: )
3024: )
3025: AND (inv_globals.equal(p_trolin_rec.serial_number_start, l_trolin_rec.serial_number_start)
3026: OR (p_trolin_rec.serial_number_start = fnd_api.g_miss_char
3027: AND l_trolin_rec.serial_number_start IS NULL
3028: )
3029: )
3026: OR (p_trolin_rec.serial_number_start = fnd_api.g_miss_char
3027: AND l_trolin_rec.serial_number_start IS NULL
3028: )
3029: )
3030: AND (inv_globals.equal(p_trolin_rec.status_date, l_trolin_rec.status_date)
3031: OR (p_trolin_rec.status_date = fnd_api.g_miss_date
3032: AND l_trolin_rec.status_date IS NULL
3033: )
3034: )
3031: OR (p_trolin_rec.status_date = fnd_api.g_miss_date
3032: AND l_trolin_rec.status_date IS NULL
3033: )
3034: )
3035: AND (inv_globals.equal(p_trolin_rec.task_id, l_trolin_rec.task_id)
3036: OR (p_trolin_rec.task_id = fnd_api.g_miss_num
3037: AND l_trolin_rec.task_id IS NULL
3038: )
3039: )
3036: OR (p_trolin_rec.task_id = fnd_api.g_miss_num
3037: AND l_trolin_rec.task_id IS NULL
3038: )
3039: )
3040: AND (inv_globals.equal(p_trolin_rec.to_account_id, l_trolin_rec.to_account_id)
3041: OR (p_trolin_rec.to_account_id = fnd_api.g_miss_num
3042: AND l_trolin_rec.to_account_id IS NULL
3043: )
3044: )
3041: OR (p_trolin_rec.to_account_id = fnd_api.g_miss_num
3042: AND l_trolin_rec.to_account_id IS NULL
3043: )
3044: )
3045: AND (inv_globals.equal(p_trolin_rec.to_locator_id, l_trolin_rec.to_locator_id)
3046: OR (p_trolin_rec.to_locator_id = fnd_api.g_miss_num
3047: AND l_trolin_rec.to_locator_id IS NULL
3048: )
3049: )
3046: OR (p_trolin_rec.to_locator_id = fnd_api.g_miss_num
3047: AND l_trolin_rec.to_locator_id IS NULL
3048: )
3049: )
3050: AND (inv_globals.equal(p_trolin_rec.to_subinventory_code, l_trolin_rec.to_subinventory_code)
3051: OR (p_trolin_rec.to_subinventory_code = fnd_api.g_miss_char
3052: AND l_trolin_rec.to_subinventory_code IS NULL
3053: )
3054: )
3051: OR (p_trolin_rec.to_subinventory_code = fnd_api.g_miss_char
3052: AND l_trolin_rec.to_subinventory_code IS NULL
3053: )
3054: )
3055: AND (inv_globals.equal(p_trolin_rec.to_subinventory_id, l_trolin_rec.to_subinventory_id)
3056: OR (p_trolin_rec.to_subinventory_id = fnd_api.g_miss_num
3057: AND l_trolin_rec.to_subinventory_id IS NULL
3058: )
3059: )
3056: OR (p_trolin_rec.to_subinventory_id = fnd_api.g_miss_num
3057: AND l_trolin_rec.to_subinventory_id IS NULL
3058: )
3059: )
3060: AND (inv_globals.equal(p_trolin_rec.transaction_header_id, l_trolin_rec.transaction_header_id)
3061: OR (p_trolin_rec.transaction_header_id = fnd_api.g_miss_num
3062: AND l_trolin_rec.transaction_header_id IS NULL
3063: )
3064: )
3061: OR (p_trolin_rec.transaction_header_id = fnd_api.g_miss_num
3062: AND l_trolin_rec.transaction_header_id IS NULL
3063: )
3064: )
3065: AND (inv_globals.equal(p_trolin_rec.uom_code, l_trolin_rec.uom_code)
3066: OR (p_trolin_rec.uom_code = fnd_api.g_miss_char
3067: AND p_trolin_rec.uom_code IS NULL
3068: )
3069: )
3066: OR (p_trolin_rec.uom_code = fnd_api.g_miss_char
3067: AND p_trolin_rec.uom_code IS NULL
3068: )
3069: )
3070: AND (inv_globals.equal(p_trolin_rec.transaction_type_id, l_trolin_rec.transaction_type_id)
3071: OR (p_trolin_rec.transaction_type_id = fnd_api.g_miss_num
3072: AND l_trolin_rec.transaction_type_id IS NULL
3073: )
3074: )
3071: OR (p_trolin_rec.transaction_type_id = fnd_api.g_miss_num
3072: AND l_trolin_rec.transaction_type_id IS NULL
3073: )
3074: )
3075: AND (inv_globals.equal(p_trolin_rec.transaction_source_type_id, l_trolin_rec.transaction_source_type_id)
3076: OR (p_trolin_rec.transaction_source_type_id = fnd_api.g_miss_num
3077: AND l_trolin_rec.transaction_source_type_id IS NULL
3078: )
3079: )
3076: OR (p_trolin_rec.transaction_source_type_id = fnd_api.g_miss_num
3077: AND l_trolin_rec.transaction_source_type_id IS NULL
3078: )
3079: )
3080: AND (inv_globals.equal(p_trolin_rec.txn_source_id, l_trolin_rec.txn_source_id)
3081: OR (p_trolin_rec.txn_source_id = fnd_api.g_miss_num
3082: AND l_trolin_rec.txn_source_id IS NULL
3083: )
3084: )
3081: OR (p_trolin_rec.txn_source_id = fnd_api.g_miss_num
3082: AND l_trolin_rec.txn_source_id IS NULL
3083: )
3084: )
3085: AND inv_globals.equal(p_trolin_rec.txn_source_line_id, l_trolin_rec.txn_source_line_id)
3086: AND (inv_globals.equal(p_trolin_rec.txn_source_line_detail_id, l_trolin_rec.txn_source_line_detail_id)
3087: OR (p_trolin_rec.txn_source_line_detail_id = fnd_api.g_miss_num
3088: AND l_trolin_rec.txn_source_line_detail_id IS NULL
3089: )
3082: AND l_trolin_rec.txn_source_id IS NULL
3083: )
3084: )
3085: AND inv_globals.equal(p_trolin_rec.txn_source_line_id, l_trolin_rec.txn_source_line_id)
3086: AND (inv_globals.equal(p_trolin_rec.txn_source_line_detail_id, l_trolin_rec.txn_source_line_detail_id)
3087: OR (p_trolin_rec.txn_source_line_detail_id = fnd_api.g_miss_num
3088: AND l_trolin_rec.txn_source_line_detail_id IS NULL
3089: )
3090: )
3087: OR (p_trolin_rec.txn_source_line_detail_id = fnd_api.g_miss_num
3088: AND l_trolin_rec.txn_source_line_detail_id IS NULL
3089: )
3090: )
3091: AND (inv_globals.equal(p_trolin_rec.primary_quantity, l_trolin_rec.primary_quantity)
3092: OR (p_trolin_rec.primary_quantity = fnd_api.g_miss_num
3093: AND l_trolin_rec.primary_quantity IS NULL
3094: )
3095: )
3092: OR (p_trolin_rec.primary_quantity = fnd_api.g_miss_num
3093: AND l_trolin_rec.primary_quantity IS NULL
3094: )
3095: )
3096: AND (inv_globals.equal(p_trolin_rec.to_organization_id, l_trolin_rec.to_organization_id)
3097: OR (p_trolin_rec.to_organization_id = fnd_api.g_miss_num
3098: AND l_trolin_rec.to_organization_id IS NULL
3099: )
3100: )
3097: OR (p_trolin_rec.to_organization_id = fnd_api.g_miss_num
3098: AND l_trolin_rec.to_organization_id IS NULL
3099: )
3100: )
3101: AND (inv_globals.equal(p_trolin_rec.pick_strategy_id, l_trolin_rec.pick_strategy_id)
3102: OR (p_trolin_rec.pick_strategy_id = fnd_api.g_miss_num
3103: AND l_trolin_rec.pick_strategy_id IS NULL
3104: )
3105: )
3102: OR (p_trolin_rec.pick_strategy_id = fnd_api.g_miss_num
3103: AND l_trolin_rec.pick_strategy_id IS NULL
3104: )
3105: )
3106: AND (inv_globals.equal(p_trolin_rec.put_away_strategy_id, l_trolin_rec.put_away_strategy_id)
3107: OR (p_trolin_rec.put_away_strategy_id = fnd_api.g_miss_num
3108: AND l_trolin_rec.put_away_strategy_id IS NULL
3109: )
3110: )
3107: OR (p_trolin_rec.put_away_strategy_id = fnd_api.g_miss_num
3108: AND l_trolin_rec.put_away_strategy_id IS NULL
3109: )
3110: )
3111: AND (inv_globals.equal(p_trolin_rec.unit_number, l_trolin_rec.unit_number)
3112: OR (p_trolin_rec.unit_number = fnd_api.g_miss_char
3113: AND l_trolin_rec.unit_number IS NULL
3114: )
3115: )
3112: OR (p_trolin_rec.unit_number = fnd_api.g_miss_char
3113: AND l_trolin_rec.unit_number IS NULL
3114: )
3115: )
3116: AND (inv_globals.equal(p_trolin_rec.ship_to_location_id, l_trolin_rec.ship_to_location_id)
3117: OR (p_trolin_rec.ship_to_location_id = fnd_api.g_miss_num
3118: AND l_trolin_rec.ship_to_location_id IS NULL
3119: )
3120: )
3117: OR (p_trolin_rec.ship_to_location_id = fnd_api.g_miss_num
3118: AND l_trolin_rec.ship_to_location_id IS NULL
3119: )
3120: )
3121: AND (inv_globals.equal(p_trolin_rec.from_cost_group_id, l_trolin_rec.from_cost_group_id)
3122: OR (p_trolin_rec.from_cost_group_id = fnd_api.g_miss_num
3123: AND l_trolin_rec.to_cost_group_id IS NULL
3124: )
3125: )
3122: OR (p_trolin_rec.from_cost_group_id = fnd_api.g_miss_num
3123: AND l_trolin_rec.to_cost_group_id IS NULL
3124: )
3125: )
3126: AND (inv_globals.equal(p_trolin_rec.to_cost_group_id, l_trolin_rec.to_cost_group_id)
3127: OR (p_trolin_rec.to_cost_group_id = fnd_api.g_miss_num
3128: AND l_trolin_rec.to_cost_group_id IS NULL
3129: )
3130: )
3127: OR (p_trolin_rec.to_cost_group_id = fnd_api.g_miss_num
3128: AND l_trolin_rec.to_cost_group_id IS NULL
3129: )
3130: )
3131: AND (inv_globals.equal(p_trolin_rec.lpn_id, l_trolin_rec.lpn_id)
3132: OR (p_trolin_rec.lpn_id = fnd_api.g_miss_num
3133: AND l_trolin_rec.lpn_id IS NULL
3134: )
3135: )
3132: OR (p_trolin_rec.lpn_id = fnd_api.g_miss_num
3133: AND l_trolin_rec.lpn_id IS NULL
3134: )
3135: )
3136: AND (inv_globals.equal(p_trolin_rec.to_lpn_id, l_trolin_rec.to_lpn_id)
3137: OR (p_trolin_rec.to_lpn_id = fnd_api.g_miss_num
3138: AND l_trolin_rec.to_lpn_id IS NULL
3139: )
3140: )
3137: OR (p_trolin_rec.to_lpn_id = fnd_api.g_miss_num
3138: AND l_trolin_rec.to_lpn_id IS NULL
3139: )
3140: )
3141: AND inv_globals.equal(p_trolin_rec.inspection_status, l_trolin_rec.inspection_status)
3142: AND (inv_globals.equal(p_trolin_rec.pick_methodology_id, l_trolin_rec.pick_methodology_id)
3143: OR (p_trolin_rec.pick_methodology_id = fnd_api.g_miss_num
3144: AND l_trolin_rec.pick_methodology_id IS NULL
3145: )
3138: AND l_trolin_rec.to_lpn_id IS NULL
3139: )
3140: )
3141: AND inv_globals.equal(p_trolin_rec.inspection_status, l_trolin_rec.inspection_status)
3142: AND (inv_globals.equal(p_trolin_rec.pick_methodology_id, l_trolin_rec.pick_methodology_id)
3143: OR (p_trolin_rec.pick_methodology_id = fnd_api.g_miss_num
3144: AND l_trolin_rec.pick_methodology_id IS NULL
3145: )
3146: )
3143: OR (p_trolin_rec.pick_methodology_id = fnd_api.g_miss_num
3144: AND l_trolin_rec.pick_methodology_id IS NULL
3145: )
3146: )
3147: AND (inv_globals.equal(p_trolin_rec.container_item_id, l_trolin_rec.container_item_id)
3148: OR (p_trolin_rec.container_item_id = fnd_api.g_miss_num
3149: AND l_trolin_rec.container_item_id IS NULL
3150: )
3151: )
3148: OR (p_trolin_rec.container_item_id = fnd_api.g_miss_num
3149: AND l_trolin_rec.container_item_id IS NULL
3150: )
3151: )
3152: AND (inv_globals.equal(p_trolin_rec.carton_grouping_id, l_trolin_rec.carton_grouping_id)
3153: OR (p_trolin_rec.carton_grouping_id = fnd_api.g_miss_num
3154: AND l_trolin_rec.carton_grouping_id IS NULL
3155: )
3156: )
3153: OR (p_trolin_rec.carton_grouping_id = fnd_api.g_miss_num
3154: AND l_trolin_rec.carton_grouping_id IS NULL
3155: )
3156: )
3157: AND (inv_globals.equal(p_trolin_rec.wms_process_flag, l_trolin_rec.wms_process_flag)
3158: OR (p_trolin_rec.wms_process_flag = fnd_api.g_miss_char
3159: AND l_trolin_rec.wms_process_flag IS NULL
3160: )
3161: )
3158: OR (p_trolin_rec.wms_process_flag = fnd_api.g_miss_char
3159: AND l_trolin_rec.wms_process_flag IS NULL
3160: )
3161: )
3162: AND (inv_globals.equal(p_trolin_rec.pick_slip_number, l_trolin_rec.pick_slip_number)
3163: OR (p_trolin_rec.pick_slip_number = fnd_api.g_miss_num
3164: AND l_trolin_rec.pick_slip_number IS NULL
3165: )
3166: )
3163: OR (p_trolin_rec.pick_slip_number = fnd_api.g_miss_num
3164: AND l_trolin_rec.pick_slip_number IS NULL
3165: )
3166: )
3167: AND (inv_globals.equal(p_trolin_rec.pick_slip_date, l_trolin_rec.pick_slip_date)
3168: OR (p_trolin_rec.pick_slip_date = fnd_api.g_miss_date
3169: AND l_trolin_rec.pick_slip_date IS NULL
3170: )
3171: )
3168: OR (p_trolin_rec.pick_slip_date = fnd_api.g_miss_date
3169: AND l_trolin_rec.pick_slip_date IS NULL
3170: )
3171: )
3172: AND (inv_globals.equal(p_trolin_rec.ship_set_id, l_trolin_rec.ship_set_id)
3173: OR (p_trolin_rec.ship_set_id = fnd_api.g_miss_num
3174: AND l_trolin_rec.ship_set_id IS NULL
3175: )
3176: )
3173: OR (p_trolin_rec.ship_set_id = fnd_api.g_miss_num
3174: AND l_trolin_rec.ship_set_id IS NULL
3175: )
3176: )
3177: AND (inv_globals.equal(p_trolin_rec.ship_model_id, l_trolin_rec.ship_model_id)
3178: OR (p_trolin_rec.ship_model_id = fnd_api.g_miss_num
3179: AND l_trolin_rec.ship_model_id IS NULL
3180: )
3181: )
3178: OR (p_trolin_rec.ship_model_id = fnd_api.g_miss_num
3179: AND l_trolin_rec.ship_model_id IS NULL
3180: )
3181: )
3182: AND (inv_globals.equal(p_trolin_rec.model_quantity, l_trolin_rec.model_quantity)
3183: OR (p_trolin_rec.model_quantity = fnd_api.g_miss_num
3184: AND l_trolin_rec.model_quantity IS NULL
3185: )
3186: ) THEN
3237: BEGIN
3238: -- Line2147
3239: IF p_trolin_rec.from_locator_id IS NOT NULL
3240: AND p_trolin_rec.from_locator_id <> fnd_api.g_miss_num
3241: AND NOT inv_globals.equal(p_trolin_rec.from_locator_id, p_old_trolin_rec.from_locator_id) THEN
3242: l_trolin_val_rec.from_locator := inv_id_to_value.from_locator(p_from_locator_id => p_trolin_rec.from_locator_id);
3243: END IF;
3244:
3245: -- IF p_trolin_rec.from_subinventory_code IS NOT NULL AND
3243: END IF;
3244:
3245: -- IF p_trolin_rec.from_subinventory_code IS NOT NULL AND
3246: -- p_trolin_rec.from_subinventory_code <> FND_API.G_MISS_CHAR AND
3247: -- NOT INV_GLOBALS.Equal(p_trolin_rec.from_subinventory_code,
3248: -- p_old_trolin_rec.from_subinventory_code)
3249: -- THEN
3250: -- l_trolin_val_rec.from_subinventory := INV_Id_To_Value.From_Subinventory
3251: -- ( p_from_subinventory_code => p_trolin_rec.from_subinventory_code
3253: -- END IF; -- Generated
3254: -- Line 2167
3255: IF p_trolin_rec.from_subinventory_id IS NOT NULL
3256: AND p_trolin_rec.from_subinventory_id <> fnd_api.g_miss_num
3257: AND NOT inv_globals.equal(p_trolin_rec.from_subinventory_id, p_old_trolin_rec.from_subinventory_id) THEN
3258: l_trolin_val_rec.from_subinventory := inv_id_to_value.from_subinventory(p_from_subinventory_id => p_trolin_rec.from_subinventory_id);
3259: -- ( p_from_subinventory_id => p_trolin_rec.from_subinventory_id
3260: -- );
3261: END IF;
3261: END IF;
3262:
3263: IF p_trolin_rec.header_id IS NOT NULL
3264: AND p_trolin_rec.header_id <> fnd_api.g_miss_num
3265: AND NOT inv_globals.equal(p_trolin_rec.header_id, p_old_trolin_rec.header_id) THEN
3266: l_trolin_val_rec.header := inv_id_to_value.header(p_header_id => p_trolin_rec.header_id);
3267: END IF;
3268:
3269: IF p_trolin_rec.inventory_item_id IS NOT NULL
3267: END IF;
3268:
3269: IF p_trolin_rec.inventory_item_id IS NOT NULL
3270: AND p_trolin_rec.inventory_item_id <> fnd_api.g_miss_num
3271: AND NOT inv_globals.equal(p_trolin_rec.inventory_item_id, p_old_trolin_rec.inventory_item_id) THEN
3272: l_trolin_val_rec.inventory_item := inv_id_to_value.inventory_item(p_inventory_item_id => p_trolin_rec.inventory_item_id);
3273: END IF;
3274:
3275: IF p_trolin_rec.line_id IS NOT NULL
3273: END IF;
3274:
3275: IF p_trolin_rec.line_id IS NOT NULL
3276: AND p_trolin_rec.line_id <> fnd_api.g_miss_num
3277: AND NOT inv_globals.equal(p_trolin_rec.line_id, p_old_trolin_rec.line_id) THEN
3278: l_trolin_val_rec.line := inv_id_to_value.line(p_line_id => p_trolin_rec.line_id);
3279: END IF;
3280:
3281: IF p_trolin_rec.organization_id IS NOT NULL
3279: END IF;
3280:
3281: IF p_trolin_rec.organization_id IS NOT NULL
3282: AND p_trolin_rec.organization_id <> fnd_api.g_miss_num
3283: AND NOT inv_globals.equal(p_trolin_rec.organization_id, p_old_trolin_rec.organization_id) THEN
3284: l_trolin_val_rec.ORGANIZATION := inv_id_to_value.ORGANIZATION(p_organization_id => p_trolin_rec.organization_id);
3285: END IF;
3286:
3287: IF p_trolin_rec.to_organization_id IS NOT NULL
3285: END IF;
3286:
3287: IF p_trolin_rec.to_organization_id IS NOT NULL
3288: AND p_trolin_rec.to_organization_id <> fnd_api.g_miss_num
3289: AND NOT inv_globals.equal(p_trolin_rec.to_organization_id, p_old_trolin_rec.to_organization_id) THEN
3290: l_trolin_val_rec.to_organization := inv_id_to_value.to_organization(p_to_organization_id => p_trolin_rec.to_organization_id);
3291: END IF;
3292:
3293: IF p_trolin_rec.project_id IS NOT NULL
3291: END IF;
3292:
3293: IF p_trolin_rec.project_id IS NOT NULL
3294: AND p_trolin_rec.project_id <> fnd_api.g_miss_num
3295: AND NOT inv_globals.equal(p_trolin_rec.project_id, p_old_trolin_rec.project_id) THEN
3296: l_trolin_val_rec.project := inv_id_to_value.project(p_project_id => p_trolin_rec.project_id);
3297: END IF;
3298:
3299: IF p_trolin_rec.reason_id IS NOT NULL
3297: END IF;
3298:
3299: IF p_trolin_rec.reason_id IS NOT NULL
3300: AND p_trolin_rec.reason_id <> fnd_api.g_miss_num
3301: AND NOT inv_globals.equal(p_trolin_rec.reason_id, p_old_trolin_rec.reason_id) THEN
3302: l_trolin_val_rec.reason := inv_id_to_value.reason(p_reason_id => p_trolin_rec.reason_id);
3303: END IF;
3304:
3305: IF p_trolin_rec.reference_id IS NOT NULL
3303: END IF;
3304:
3305: IF p_trolin_rec.reference_id IS NOT NULL
3306: AND p_trolin_rec.reference_id <> fnd_api.g_miss_num
3307: AND NOT inv_globals.equal(p_trolin_rec.reference_id, p_old_trolin_rec.reference_id) THEN
3308: l_trolin_val_rec.REFERENCE := inv_id_to_value.REFERENCE(p_reference_id => p_trolin_rec.reference_id);
3309: END IF;
3310:
3311: IF p_trolin_rec.reference_type_code IS NOT NULL
3309: END IF;
3310:
3311: IF p_trolin_rec.reference_type_code IS NOT NULL
3312: AND p_trolin_rec.reference_type_code <> fnd_api.g_miss_num
3313: AND NOT inv_globals.equal(p_trolin_rec.reference_type_code, p_old_trolin_rec.reference_type_code) THEN
3314: l_trolin_val_rec.reference_type := inv_id_to_value.reference_type(p_reference_type_code => p_trolin_rec.reference_type_code);
3315: END IF;
3316:
3317: IF p_trolin_rec.task_id IS NOT NULL
3315: END IF;
3316:
3317: IF p_trolin_rec.task_id IS NOT NULL
3318: AND p_trolin_rec.task_id <> fnd_api.g_miss_num
3319: AND NOT inv_globals.equal(p_trolin_rec.task_id, p_old_trolin_rec.task_id) THEN
3320: l_trolin_val_rec.task := inv_id_to_value.task(p_task_id => p_trolin_rec.task_id);
3321: END IF;
3322:
3323: IF p_trolin_rec.to_account_id IS NOT NULL
3321: END IF;
3322:
3323: IF p_trolin_rec.to_account_id IS NOT NULL
3324: AND p_trolin_rec.to_account_id <> fnd_api.g_miss_num
3325: AND NOT inv_globals.equal(p_trolin_rec.to_account_id, p_old_trolin_rec.to_account_id) THEN
3326: l_trolin_val_rec.to_account := inv_id_to_value.to_account(p_to_account_id => p_trolin_rec.to_account_id);
3327: END IF;
3328:
3329: IF p_trolin_rec.to_locator_id IS NOT NULL
3327: END IF;
3328:
3329: IF p_trolin_rec.to_locator_id IS NOT NULL
3330: AND p_trolin_rec.to_locator_id <> fnd_api.g_miss_num
3331: AND NOT inv_globals.equal(p_trolin_rec.to_locator_id, p_old_trolin_rec.to_locator_id) THEN
3332: l_trolin_val_rec.to_locator := inv_id_to_value.to_locator(p_to_locator_id => p_trolin_rec.to_locator_id);
3333: END IF;
3334:
3335: -- IF p_trolin_rec.to_subinventory_code IS NOT NULL AND
3333: END IF;
3334:
3335: -- IF p_trolin_rec.to_subinventory_code IS NOT NULL AND
3336: -- p_trolin_rec.to_subinventory_code <> FND_API.G_MISS_CHAR AND
3337: -- NOT INV_GLOBALS.Equal(p_trolin_rec.to_subinventory_code,
3338: -- p_old_trolin_rec.to_subinventory_code)
3339: -- THEN
3340: -- l_trolin_val_rec.to_subinventory := INV_Id_To_Value.To_Subinventory
3341: -- ( p_to_subinventory_code => p_trolin_rec.to_subinventory_code
3343: -- END IF; -- Generated
3344:
3345: IF p_trolin_rec.to_subinventory_id IS NOT NULL
3346: AND p_trolin_rec.to_subinventory_id <> fnd_api.g_miss_num
3347: AND NOT inv_globals.equal(p_trolin_rec.to_subinventory_id, p_old_trolin_rec.to_subinventory_id) THEN
3348: l_trolin_val_rec.to_subinventory := inv_id_to_value.to_subinventory(p_to_subinventory_id => p_trolin_rec.to_subinventory_id);
3349: END IF;
3350:
3351: IF p_trolin_rec.transaction_header_id IS NOT NULL
3349: END IF;
3350:
3351: IF p_trolin_rec.transaction_header_id IS NOT NULL
3352: AND p_trolin_rec.transaction_header_id <> fnd_api.g_miss_num
3353: AND NOT inv_globals.equal(p_trolin_rec.transaction_header_id, p_old_trolin_rec.transaction_header_id) THEN
3354: l_trolin_val_rec.transaction_header := inv_id_to_value.transaction_header(p_transaction_header_id => p_trolin_rec.transaction_header_id);
3355: END IF;
3356:
3357: IF p_trolin_rec.transaction_type_id IS NOT NULL
3355: END IF;
3356:
3357: IF p_trolin_rec.transaction_type_id IS NOT NULL
3358: AND p_trolin_rec.transaction_type_id <> fnd_api.g_miss_num
3359: AND NOT inv_globals.equal(p_trolin_rec.transaction_type_id, p_old_trolin_rec.transaction_type_id) THEN
3360: l_trolin_val_rec.transaction_type := inv_id_to_value.transaction_type(p_transaction_type_id => p_trolin_rec.transaction_type_id);
3361: END IF;
3362:
3363: IF p_trolin_rec.uom_code IS NOT NULL
3361: END IF;
3362:
3363: IF p_trolin_rec.uom_code IS NOT NULL
3364: AND p_trolin_rec.uom_code <> fnd_api.g_miss_char
3365: AND NOT inv_globals.equal(p_trolin_rec.uom_code, p_old_trolin_rec.uom_code) THEN
3366: l_trolin_val_rec.uom := inv_id_to_value.uom(p_uom_code => p_trolin_rec.uom_code);
3367: END IF;
3368:
3369: RETURN l_trolin_val_rec;