13: , p_old_trohdr_rec IN inv_move_order_pub.trohdr_rec_type := inv_move_order_pub.g_miss_trohdr_rec
14: , x_trohdr_rec IN OUT NOCOPY inv_move_order_pub.trohdr_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_trohdr_rec IN OUT NOCOPY inv_move_order_pub.trohdr_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_trohdr_rec := p_trohdr_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_trohdr_rec.attribute1, p_old_trohdr_rec.attribute1) THEN
29: l_index := l_index + 1;
30: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute1;
31: END IF;
32:
29: l_index := l_index + 1;
30: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute1;
31: END IF;
32:
33: IF NOT inv_globals.equal(p_trohdr_rec.attribute10, p_old_trohdr_rec.attribute10) THEN
34: l_index := l_index + 1;
35: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute10;
36: END IF;
37:
34: l_index := l_index + 1;
35: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute10;
36: END IF;
37:
38: IF NOT inv_globals.equal(p_trohdr_rec.attribute11, p_old_trohdr_rec.attribute11) THEN
39: l_index := l_index + 1;
40: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute11;
41: END IF;
42:
39: l_index := l_index + 1;
40: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute11;
41: END IF;
42:
43: IF NOT inv_globals.equal(p_trohdr_rec.attribute12, p_old_trohdr_rec.attribute12) THEN
44: l_index := l_index + 1;
45: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute12;
46: END IF;
47:
44: l_index := l_index + 1;
45: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute12;
46: END IF;
47:
48: IF NOT inv_globals.equal(p_trohdr_rec.attribute13, p_old_trohdr_rec.attribute13) THEN
49: l_index := l_index + 1;
50: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute13;
51: END IF;
52:
49: l_index := l_index + 1;
50: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute13;
51: END IF;
52:
53: IF NOT inv_globals.equal(p_trohdr_rec.attribute14, p_old_trohdr_rec.attribute14) THEN
54: l_index := l_index + 1;
55: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute14;
56: END IF;
57:
54: l_index := l_index + 1;
55: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute14;
56: END IF;
57:
58: IF NOT inv_globals.equal(p_trohdr_rec.attribute15, p_old_trohdr_rec.attribute15) THEN
59: l_index := l_index + 1;
60: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute15;
61: END IF;
62:
59: l_index := l_index + 1;
60: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute15;
61: END IF;
62:
63: IF NOT inv_globals.equal(p_trohdr_rec.attribute2, p_old_trohdr_rec.attribute2) THEN
64: l_index := l_index + 1;
65: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute2;
66: END IF;
67:
64: l_index := l_index + 1;
65: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute2;
66: END IF;
67:
68: IF NOT inv_globals.equal(p_trohdr_rec.attribute3, p_old_trohdr_rec.attribute3) THEN
69: l_index := l_index + 1;
70: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute3;
71: END IF;
72:
69: l_index := l_index + 1;
70: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute3;
71: END IF;
72:
73: IF NOT inv_globals.equal(p_trohdr_rec.attribute4, p_old_trohdr_rec.attribute4) THEN
74: l_index := l_index + 1;
75: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute4;
76: END IF;
77:
74: l_index := l_index + 1;
75: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute4;
76: END IF;
77:
78: IF NOT inv_globals.equal(p_trohdr_rec.attribute5, p_old_trohdr_rec.attribute5) THEN
79: l_index := l_index + 1;
80: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute5;
81: END IF;
82:
79: l_index := l_index + 1;
80: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute5;
81: END IF;
82:
83: IF NOT inv_globals.equal(p_trohdr_rec.attribute6, p_old_trohdr_rec.attribute6) THEN
84: l_index := l_index + 1;
85: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute6;
86: END IF;
87:
84: l_index := l_index + 1;
85: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute6;
86: END IF;
87:
88: IF NOT inv_globals.equal(p_trohdr_rec.attribute7, p_old_trohdr_rec.attribute7) THEN
89: l_index := l_index + 1;
90: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute7;
91: END IF;
92:
89: l_index := l_index + 1;
90: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute7;
91: END IF;
92:
93: IF NOT inv_globals.equal(p_trohdr_rec.attribute8, p_old_trohdr_rec.attribute8) THEN
94: l_index := l_index + 1;
95: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute8;
96: END IF;
97:
94: l_index := l_index + 1;
95: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute8;
96: END IF;
97:
98: IF NOT inv_globals.equal(p_trohdr_rec.attribute9, p_old_trohdr_rec.attribute9) THEN
99: l_index := l_index + 1;
100: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute9;
101: END IF;
102:
99: l_index := l_index + 1;
100: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute9;
101: END IF;
102:
103: IF NOT inv_globals.equal(p_trohdr_rec.attribute_category, p_old_trohdr_rec.attribute_category) THEN
104: l_index := l_index + 1;
105: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute_category;
106: END IF;
107:
104: l_index := l_index + 1;
105: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute_category;
106: END IF;
107:
108: IF NOT inv_globals.equal(p_trohdr_rec.created_by, p_old_trohdr_rec.created_by) THEN
109: l_index := l_index + 1;
110: l_src_attr_tbl(l_index) := inv_trohdr_util.g_created_by;
111: END IF;
112:
109: l_index := l_index + 1;
110: l_src_attr_tbl(l_index) := inv_trohdr_util.g_created_by;
111: END IF;
112:
113: IF NOT inv_globals.equal(p_trohdr_rec.creation_date, p_old_trohdr_rec.creation_date) THEN
114: l_index := l_index + 1;
115: l_src_attr_tbl(l_index) := inv_trohdr_util.g_creation_date;
116: END IF;
117:
114: l_index := l_index + 1;
115: l_src_attr_tbl(l_index) := inv_trohdr_util.g_creation_date;
116: END IF;
117:
118: IF NOT inv_globals.equal(p_trohdr_rec.date_required, p_old_trohdr_rec.date_required) THEN
119: l_index := l_index + 1;
120: l_src_attr_tbl(l_index) := inv_trohdr_util.g_date_required;
121: END IF;
122:
119: l_index := l_index + 1;
120: l_src_attr_tbl(l_index) := inv_trohdr_util.g_date_required;
121: END IF;
122:
123: IF NOT inv_globals.equal(p_trohdr_rec.description, p_old_trohdr_rec.description) THEN
124: l_index := l_index + 1;
125: l_src_attr_tbl(l_index) := inv_trohdr_util.g_description;
126: END IF;
127:
124: l_index := l_index + 1;
125: l_src_attr_tbl(l_index) := inv_trohdr_util.g_description;
126: END IF;
127:
128: IF NOT inv_globals.equal(p_trohdr_rec.from_subinventory_code, p_old_trohdr_rec.from_subinventory_code) THEN
129: l_index := l_index + 1;
130: l_src_attr_tbl(l_index) := inv_trohdr_util.g_from_subinventory;
131: END IF;
132:
129: l_index := l_index + 1;
130: l_src_attr_tbl(l_index) := inv_trohdr_util.g_from_subinventory;
131: END IF;
132:
133: IF NOT inv_globals.equal(p_trohdr_rec.header_id, p_old_trohdr_rec.header_id) THEN
134: l_index := l_index + 1;
135: l_src_attr_tbl(l_index) := inv_trohdr_util.g_header;
136: END IF;
137:
134: l_index := l_index + 1;
135: l_src_attr_tbl(l_index) := inv_trohdr_util.g_header;
136: END IF;
137:
138: IF NOT inv_globals.equal(p_trohdr_rec.header_status, p_old_trohdr_rec.header_status) THEN
139: l_index := l_index + 1;
140: l_src_attr_tbl(l_index) := inv_trohdr_util.g_header_status;
141: END IF;
142:
139: l_index := l_index + 1;
140: l_src_attr_tbl(l_index) := inv_trohdr_util.g_header_status;
141: END IF;
142:
143: IF NOT inv_globals.equal(p_trohdr_rec.last_updated_by, p_old_trohdr_rec.last_updated_by) THEN
144: l_index := l_index + 1;
145: l_src_attr_tbl(l_index) := inv_trohdr_util.g_last_updated_by;
146: END IF;
147:
144: l_index := l_index + 1;
145: l_src_attr_tbl(l_index) := inv_trohdr_util.g_last_updated_by;
146: END IF;
147:
148: IF NOT inv_globals.equal(p_trohdr_rec.last_update_date, p_old_trohdr_rec.last_update_date) THEN
149: l_index := l_index + 1;
150: l_src_attr_tbl(l_index) := inv_trohdr_util.g_last_update_date;
151: END IF;
152:
149: l_index := l_index + 1;
150: l_src_attr_tbl(l_index) := inv_trohdr_util.g_last_update_date;
151: END IF;
152:
153: IF NOT inv_globals.equal(p_trohdr_rec.last_update_login, p_old_trohdr_rec.last_update_login) THEN
154: l_index := l_index + 1;
155: l_src_attr_tbl(l_index) := inv_trohdr_util.g_last_update_login;
156: END IF;
157:
154: l_index := l_index + 1;
155: l_src_attr_tbl(l_index) := inv_trohdr_util.g_last_update_login;
156: END IF;
157:
158: IF NOT inv_globals.equal(p_trohdr_rec.organization_id, p_old_trohdr_rec.organization_id) THEN
159: l_index := l_index + 1;
160: l_src_attr_tbl(l_index) := inv_trohdr_util.g_organization;
161: END IF;
162:
159: l_index := l_index + 1;
160: l_src_attr_tbl(l_index) := inv_trohdr_util.g_organization;
161: END IF;
162:
163: IF NOT inv_globals.equal(p_trohdr_rec.program_application_id, p_old_trohdr_rec.program_application_id) THEN
164: l_index := l_index + 1;
165: l_src_attr_tbl(l_index) := inv_trohdr_util.g_program_application;
166: END IF;
167:
164: l_index := l_index + 1;
165: l_src_attr_tbl(l_index) := inv_trohdr_util.g_program_application;
166: END IF;
167:
168: IF NOT inv_globals.equal(p_trohdr_rec.program_id, p_old_trohdr_rec.program_id) THEN
169: l_index := l_index + 1;
170: l_src_attr_tbl(l_index) := inv_trohdr_util.g_program;
171: END IF;
172:
169: l_index := l_index + 1;
170: l_src_attr_tbl(l_index) := inv_trohdr_util.g_program;
171: END IF;
172:
173: IF NOT inv_globals.equal(p_trohdr_rec.program_update_date, p_old_trohdr_rec.program_update_date) THEN
174: l_index := l_index + 1;
175: l_src_attr_tbl(l_index) := inv_trohdr_util.g_program_update_date;
176: END IF;
177:
174: l_index := l_index + 1;
175: l_src_attr_tbl(l_index) := inv_trohdr_util.g_program_update_date;
176: END IF;
177:
178: IF NOT inv_globals.equal(p_trohdr_rec.request_id, p_old_trohdr_rec.request_id) THEN
179: l_index := l_index + 1;
180: l_src_attr_tbl(l_index) := inv_trohdr_util.g_request;
181: END IF;
182:
179: l_index := l_index + 1;
180: l_src_attr_tbl(l_index) := inv_trohdr_util.g_request;
181: END IF;
182:
183: IF NOT inv_globals.equal(p_trohdr_rec.request_number, p_old_trohdr_rec.request_number) THEN
184: l_index := l_index + 1;
185: l_src_attr_tbl(l_index) := inv_trohdr_util.g_request_number;
186: END IF;
187:
184: l_index := l_index + 1;
185: l_src_attr_tbl(l_index) := inv_trohdr_util.g_request_number;
186: END IF;
187:
188: IF NOT inv_globals.equal(p_trohdr_rec.status_date, p_old_trohdr_rec.status_date) THEN
189: l_index := l_index + 1;
190: l_src_attr_tbl(l_index) := inv_trohdr_util.g_status_date;
191: END IF;
192:
189: l_index := l_index + 1;
190: l_src_attr_tbl(l_index) := inv_trohdr_util.g_status_date;
191: END IF;
192:
193: IF NOT inv_globals.equal(p_trohdr_rec.to_account_id, p_old_trohdr_rec.to_account_id) THEN
194: l_index := l_index + 1;
195: l_src_attr_tbl(l_index) := inv_trohdr_util.g_to_account;
196: END IF;
197:
194: l_index := l_index + 1;
195: l_src_attr_tbl(l_index) := inv_trohdr_util.g_to_account;
196: END IF;
197:
198: IF NOT inv_globals.equal(p_trohdr_rec.to_subinventory_code, p_old_trohdr_rec.to_subinventory_code) THEN
199: l_index := l_index + 1;
200: l_src_attr_tbl(l_index) := inv_trohdr_util.g_to_subinventory;
201: END IF;
202:
199: l_index := l_index + 1;
200: l_src_attr_tbl(l_index) := inv_trohdr_util.g_to_subinventory;
201: END IF;
202:
203: IF NOT inv_globals.equal(p_trohdr_rec.move_order_type, p_old_trohdr_rec.move_order_type) THEN
204: l_index := l_index + 1;
205: l_src_attr_tbl(l_index) := inv_trohdr_util.g_move_order_type;
206: END IF;
207:
204: l_index := l_index + 1;
205: l_src_attr_tbl(l_index) := inv_trohdr_util.g_move_order_type;
206: END IF;
207:
208: IF NOT inv_globals.equal(p_trohdr_rec.transaction_type_id, p_old_trohdr_rec.transaction_type_id) THEN
209: l_index := l_index + 1;
210: l_src_attr_tbl(l_index) := inv_trohdr_util.g_transaction_type;
211: END IF;
212:
209: l_index := l_index + 1;
210: l_src_attr_tbl(l_index) := inv_trohdr_util.g_transaction_type;
211: END IF;
212:
213: IF NOT inv_globals.equal(p_trohdr_rec.ship_to_location_id, p_old_trohdr_rec.ship_to_location_id) THEN
214: l_index := l_index + 1;
215: l_src_attr_tbl(l_index) := inv_trohdr_util.g_ship_to_location_id;
216: END IF;
217: ELSIF p_attr_id = g_attribute1 THEN
338: -- Load out record
339:
340: x_trohdr_rec := p_trohdr_rec;
341:
342: IF NOT inv_globals.equal(p_trohdr_rec.attribute1, p_old_trohdr_rec.attribute1) THEN
343: NULL;
344: END IF;
345:
346: IF NOT inv_globals.equal(p_trohdr_rec.attribute10, p_old_trohdr_rec.attribute10) THEN
342: IF NOT inv_globals.equal(p_trohdr_rec.attribute1, p_old_trohdr_rec.attribute1) THEN
343: NULL;
344: END IF;
345:
346: IF NOT inv_globals.equal(p_trohdr_rec.attribute10, p_old_trohdr_rec.attribute10) THEN
347: NULL;
348: END IF;
349:
350: IF NOT inv_globals.equal(p_trohdr_rec.attribute11, p_old_trohdr_rec.attribute11) THEN
346: IF NOT inv_globals.equal(p_trohdr_rec.attribute10, p_old_trohdr_rec.attribute10) THEN
347: NULL;
348: END IF;
349:
350: IF NOT inv_globals.equal(p_trohdr_rec.attribute11, p_old_trohdr_rec.attribute11) THEN
351: NULL;
352: END IF;
353:
354: IF NOT inv_globals.equal(p_trohdr_rec.attribute12, p_old_trohdr_rec.attribute12) THEN
350: IF NOT inv_globals.equal(p_trohdr_rec.attribute11, p_old_trohdr_rec.attribute11) THEN
351: NULL;
352: END IF;
353:
354: IF NOT inv_globals.equal(p_trohdr_rec.attribute12, p_old_trohdr_rec.attribute12) THEN
355: NULL;
356: END IF;
357:
358: IF NOT inv_globals.equal(p_trohdr_rec.attribute13, p_old_trohdr_rec.attribute13) THEN
354: IF NOT inv_globals.equal(p_trohdr_rec.attribute12, p_old_trohdr_rec.attribute12) THEN
355: NULL;
356: END IF;
357:
358: IF NOT inv_globals.equal(p_trohdr_rec.attribute13, p_old_trohdr_rec.attribute13) THEN
359: NULL;
360: END IF;
361:
362: IF NOT inv_globals.equal(p_trohdr_rec.attribute14, p_old_trohdr_rec.attribute14) THEN
358: IF NOT inv_globals.equal(p_trohdr_rec.attribute13, p_old_trohdr_rec.attribute13) THEN
359: NULL;
360: END IF;
361:
362: IF NOT inv_globals.equal(p_trohdr_rec.attribute14, p_old_trohdr_rec.attribute14) THEN
363: NULL;
364: END IF;
365:
366: IF NOT inv_globals.equal(p_trohdr_rec.attribute15, p_old_trohdr_rec.attribute15) THEN
362: IF NOT inv_globals.equal(p_trohdr_rec.attribute14, p_old_trohdr_rec.attribute14) THEN
363: NULL;
364: END IF;
365:
366: IF NOT inv_globals.equal(p_trohdr_rec.attribute15, p_old_trohdr_rec.attribute15) THEN
367: NULL;
368: END IF;
369:
370: IF NOT inv_globals.equal(p_trohdr_rec.attribute2, p_old_trohdr_rec.attribute2) THEN
366: IF NOT inv_globals.equal(p_trohdr_rec.attribute15, p_old_trohdr_rec.attribute15) THEN
367: NULL;
368: END IF;
369:
370: IF NOT inv_globals.equal(p_trohdr_rec.attribute2, p_old_trohdr_rec.attribute2) THEN
371: NULL;
372: END IF;
373:
374: IF NOT inv_globals.equal(p_trohdr_rec.attribute3, p_old_trohdr_rec.attribute3) THEN
370: IF NOT inv_globals.equal(p_trohdr_rec.attribute2, p_old_trohdr_rec.attribute2) THEN
371: NULL;
372: END IF;
373:
374: IF NOT inv_globals.equal(p_trohdr_rec.attribute3, p_old_trohdr_rec.attribute3) THEN
375: NULL;
376: END IF;
377:
378: IF NOT inv_globals.equal(p_trohdr_rec.attribute4, p_old_trohdr_rec.attribute4) THEN
374: IF NOT inv_globals.equal(p_trohdr_rec.attribute3, p_old_trohdr_rec.attribute3) THEN
375: NULL;
376: END IF;
377:
378: IF NOT inv_globals.equal(p_trohdr_rec.attribute4, p_old_trohdr_rec.attribute4) THEN
379: NULL;
380: END IF;
381:
382: IF NOT inv_globals.equal(p_trohdr_rec.attribute5, p_old_trohdr_rec.attribute5) THEN
378: IF NOT inv_globals.equal(p_trohdr_rec.attribute4, p_old_trohdr_rec.attribute4) THEN
379: NULL;
380: END IF;
381:
382: IF NOT inv_globals.equal(p_trohdr_rec.attribute5, p_old_trohdr_rec.attribute5) THEN
383: NULL;
384: END IF;
385:
386: IF NOT inv_globals.equal(p_trohdr_rec.attribute6, p_old_trohdr_rec.attribute6) THEN
382: IF NOT inv_globals.equal(p_trohdr_rec.attribute5, p_old_trohdr_rec.attribute5) THEN
383: NULL;
384: END IF;
385:
386: IF NOT inv_globals.equal(p_trohdr_rec.attribute6, p_old_trohdr_rec.attribute6) THEN
387: NULL;
388: END IF;
389:
390: IF NOT inv_globals.equal(p_trohdr_rec.attribute7, p_old_trohdr_rec.attribute7) THEN
386: IF NOT inv_globals.equal(p_trohdr_rec.attribute6, p_old_trohdr_rec.attribute6) THEN
387: NULL;
388: END IF;
389:
390: IF NOT inv_globals.equal(p_trohdr_rec.attribute7, p_old_trohdr_rec.attribute7) THEN
391: NULL;
392: END IF;
393:
394: IF NOT inv_globals.equal(p_trohdr_rec.attribute8, p_old_trohdr_rec.attribute8) THEN
390: IF NOT inv_globals.equal(p_trohdr_rec.attribute7, p_old_trohdr_rec.attribute7) THEN
391: NULL;
392: END IF;
393:
394: IF NOT inv_globals.equal(p_trohdr_rec.attribute8, p_old_trohdr_rec.attribute8) THEN
395: NULL;
396: END IF;
397:
398: IF NOT inv_globals.equal(p_trohdr_rec.attribute9, p_old_trohdr_rec.attribute9) THEN
394: IF NOT inv_globals.equal(p_trohdr_rec.attribute8, p_old_trohdr_rec.attribute8) THEN
395: NULL;
396: END IF;
397:
398: IF NOT inv_globals.equal(p_trohdr_rec.attribute9, p_old_trohdr_rec.attribute9) THEN
399: NULL;
400: END IF;
401:
402: IF NOT inv_globals.equal(p_trohdr_rec.attribute_category, p_old_trohdr_rec.attribute_category) THEN
398: IF NOT inv_globals.equal(p_trohdr_rec.attribute9, p_old_trohdr_rec.attribute9) THEN
399: NULL;
400: END IF;
401:
402: IF NOT inv_globals.equal(p_trohdr_rec.attribute_category, p_old_trohdr_rec.attribute_category) THEN
403: NULL;
404: END IF;
405:
406: IF NOT inv_globals.equal(p_trohdr_rec.created_by, p_old_trohdr_rec.created_by) THEN
402: IF NOT inv_globals.equal(p_trohdr_rec.attribute_category, p_old_trohdr_rec.attribute_category) THEN
403: NULL;
404: END IF;
405:
406: IF NOT inv_globals.equal(p_trohdr_rec.created_by, p_old_trohdr_rec.created_by) THEN
407: NULL;
408: END IF;
409:
410: IF NOT inv_globals.equal(p_trohdr_rec.creation_date, p_old_trohdr_rec.creation_date) THEN
406: IF NOT inv_globals.equal(p_trohdr_rec.created_by, p_old_trohdr_rec.created_by) THEN
407: NULL;
408: END IF;
409:
410: IF NOT inv_globals.equal(p_trohdr_rec.creation_date, p_old_trohdr_rec.creation_date) THEN
411: NULL;
412: END IF;
413:
414: IF NOT inv_globals.equal(p_trohdr_rec.date_required, p_old_trohdr_rec.date_required) THEN
410: IF NOT inv_globals.equal(p_trohdr_rec.creation_date, p_old_trohdr_rec.creation_date) THEN
411: NULL;
412: END IF;
413:
414: IF NOT inv_globals.equal(p_trohdr_rec.date_required, p_old_trohdr_rec.date_required) THEN
415: NULL;
416: END IF;
417:
418: IF NOT inv_globals.equal(p_trohdr_rec.description, p_old_trohdr_rec.description) THEN
414: IF NOT inv_globals.equal(p_trohdr_rec.date_required, p_old_trohdr_rec.date_required) THEN
415: NULL;
416: END IF;
417:
418: IF NOT inv_globals.equal(p_trohdr_rec.description, p_old_trohdr_rec.description) THEN
419: NULL;
420: END IF;
421:
422: IF NOT inv_globals.equal(p_trohdr_rec.from_subinventory_code, p_old_trohdr_rec.from_subinventory_code) THEN
418: IF NOT inv_globals.equal(p_trohdr_rec.description, p_old_trohdr_rec.description) THEN
419: NULL;
420: END IF;
421:
422: IF NOT inv_globals.equal(p_trohdr_rec.from_subinventory_code, p_old_trohdr_rec.from_subinventory_code) THEN
423: NULL;
424: END IF;
425:
426: IF NOT inv_globals.equal(p_trohdr_rec.header_id, p_old_trohdr_rec.header_id) THEN
422: IF NOT inv_globals.equal(p_trohdr_rec.from_subinventory_code, p_old_trohdr_rec.from_subinventory_code) THEN
423: NULL;
424: END IF;
425:
426: IF NOT inv_globals.equal(p_trohdr_rec.header_id, p_old_trohdr_rec.header_id) THEN
427: NULL;
428: END IF;
429:
430: IF NOT inv_globals.equal(p_trohdr_rec.header_status, p_old_trohdr_rec.header_status) THEN
426: IF NOT inv_globals.equal(p_trohdr_rec.header_id, p_old_trohdr_rec.header_id) THEN
427: NULL;
428: END IF;
429:
430: IF NOT inv_globals.equal(p_trohdr_rec.header_status, p_old_trohdr_rec.header_status) THEN
431: NULL;
432: END IF;
433:
434: IF NOT inv_globals.equal(p_trohdr_rec.last_updated_by, p_old_trohdr_rec.last_updated_by) THEN
430: IF NOT inv_globals.equal(p_trohdr_rec.header_status, p_old_trohdr_rec.header_status) THEN
431: NULL;
432: END IF;
433:
434: IF NOT inv_globals.equal(p_trohdr_rec.last_updated_by, p_old_trohdr_rec.last_updated_by) THEN
435: NULL;
436: END IF;
437:
438: IF NOT inv_globals.equal(p_trohdr_rec.last_update_date, p_old_trohdr_rec.last_update_date) THEN
434: IF NOT inv_globals.equal(p_trohdr_rec.last_updated_by, p_old_trohdr_rec.last_updated_by) THEN
435: NULL;
436: END IF;
437:
438: IF NOT inv_globals.equal(p_trohdr_rec.last_update_date, p_old_trohdr_rec.last_update_date) THEN
439: NULL;
440: END IF;
441:
442: IF NOT inv_globals.equal(p_trohdr_rec.last_update_login, p_old_trohdr_rec.last_update_login) THEN
438: IF NOT inv_globals.equal(p_trohdr_rec.last_update_date, p_old_trohdr_rec.last_update_date) THEN
439: NULL;
440: END IF;
441:
442: IF NOT inv_globals.equal(p_trohdr_rec.last_update_login, p_old_trohdr_rec.last_update_login) THEN
443: NULL;
444: END IF;
445:
446: IF NOT inv_globals.equal(p_trohdr_rec.organization_id, p_old_trohdr_rec.organization_id) THEN
442: IF NOT inv_globals.equal(p_trohdr_rec.last_update_login, p_old_trohdr_rec.last_update_login) THEN
443: NULL;
444: END IF;
445:
446: IF NOT inv_globals.equal(p_trohdr_rec.organization_id, p_old_trohdr_rec.organization_id) THEN
447: NULL;
448: END IF;
449:
450: IF NOT inv_globals.equal(p_trohdr_rec.program_application_id, p_old_trohdr_rec.program_application_id) THEN
446: IF NOT inv_globals.equal(p_trohdr_rec.organization_id, p_old_trohdr_rec.organization_id) THEN
447: NULL;
448: END IF;
449:
450: IF NOT inv_globals.equal(p_trohdr_rec.program_application_id, p_old_trohdr_rec.program_application_id) THEN
451: NULL;
452: END IF;
453:
454: IF NOT inv_globals.equal(p_trohdr_rec.program_id, p_old_trohdr_rec.program_id) THEN
450: IF NOT inv_globals.equal(p_trohdr_rec.program_application_id, p_old_trohdr_rec.program_application_id) THEN
451: NULL;
452: END IF;
453:
454: IF NOT inv_globals.equal(p_trohdr_rec.program_id, p_old_trohdr_rec.program_id) THEN
455: NULL;
456: END IF;
457:
458: IF NOT inv_globals.equal(p_trohdr_rec.program_update_date, p_old_trohdr_rec.program_update_date) THEN
454: IF NOT inv_globals.equal(p_trohdr_rec.program_id, p_old_trohdr_rec.program_id) THEN
455: NULL;
456: END IF;
457:
458: IF NOT inv_globals.equal(p_trohdr_rec.program_update_date, p_old_trohdr_rec.program_update_date) THEN
459: NULL;
460: END IF;
461:
462: IF NOT inv_globals.equal(p_trohdr_rec.request_id, p_old_trohdr_rec.request_id) THEN
458: IF NOT inv_globals.equal(p_trohdr_rec.program_update_date, p_old_trohdr_rec.program_update_date) THEN
459: NULL;
460: END IF;
461:
462: IF NOT inv_globals.equal(p_trohdr_rec.request_id, p_old_trohdr_rec.request_id) THEN
463: NULL;
464: END IF;
465:
466: IF NOT inv_globals.equal(p_trohdr_rec.request_number, p_old_trohdr_rec.request_number) THEN
462: IF NOT inv_globals.equal(p_trohdr_rec.request_id, p_old_trohdr_rec.request_id) THEN
463: NULL;
464: END IF;
465:
466: IF NOT inv_globals.equal(p_trohdr_rec.request_number, p_old_trohdr_rec.request_number) THEN
467: NULL;
468: END IF;
469:
470: IF NOT inv_globals.equal(p_trohdr_rec.status_date, p_old_trohdr_rec.status_date) THEN
466: IF NOT inv_globals.equal(p_trohdr_rec.request_number, p_old_trohdr_rec.request_number) THEN
467: NULL;
468: END IF;
469:
470: IF NOT inv_globals.equal(p_trohdr_rec.status_date, p_old_trohdr_rec.status_date) THEN
471: NULL;
472: END IF;
473:
474: IF NOT inv_globals.equal(p_trohdr_rec.to_account_id, p_old_trohdr_rec.to_account_id) THEN
470: IF NOT inv_globals.equal(p_trohdr_rec.status_date, p_old_trohdr_rec.status_date) THEN
471: NULL;
472: END IF;
473:
474: IF NOT inv_globals.equal(p_trohdr_rec.to_account_id, p_old_trohdr_rec.to_account_id) THEN
475: NULL;
476: END IF;
477:
478: IF NOT inv_globals.equal(p_trohdr_rec.to_subinventory_code, p_old_trohdr_rec.to_subinventory_code) THEN
474: IF NOT inv_globals.equal(p_trohdr_rec.to_account_id, p_old_trohdr_rec.to_account_id) THEN
475: NULL;
476: END IF;
477:
478: IF NOT inv_globals.equal(p_trohdr_rec.to_subinventory_code, p_old_trohdr_rec.to_subinventory_code) THEN
479: NULL;
480: END IF;
481:
482: IF NOT inv_globals.equal(p_trohdr_rec.move_order_type, p_old_trohdr_rec.move_order_type) THEN
478: IF NOT inv_globals.equal(p_trohdr_rec.to_subinventory_code, p_old_trohdr_rec.to_subinventory_code) THEN
479: NULL;
480: END IF;
481:
482: IF NOT inv_globals.equal(p_trohdr_rec.move_order_type, p_old_trohdr_rec.move_order_type) THEN
483: NULL;
484: END IF;
485:
486: IF NOT inv_globals.equal(p_trohdr_rec.transaction_type_id, p_old_trohdr_rec.transaction_type_id) THEN
482: IF NOT inv_globals.equal(p_trohdr_rec.move_order_type, p_old_trohdr_rec.move_order_type) THEN
483: NULL;
484: END IF;
485:
486: IF NOT inv_globals.equal(p_trohdr_rec.transaction_type_id, p_old_trohdr_rec.transaction_type_id) THEN
487: NULL;
488: END IF;
489:
490: IF NOT inv_globals.equal(p_trohdr_rec.ship_to_location_id, p_old_trohdr_rec.ship_to_location_id) THEN
486: IF NOT inv_globals.equal(p_trohdr_rec.transaction_type_id, p_old_trohdr_rec.transaction_type_id) THEN
487: NULL;
488: END IF;
489:
490: IF NOT inv_globals.equal(p_trohdr_rec.ship_to_location_id, p_old_trohdr_rec.ship_to_location_id) THEN
491: NULL;
492: END IF;
493: END apply_attribute_changes;
494:
1221: FOR UPDATE NOWAIT;
1222:
1223: -- Row locked. Compare IN attributes to DB attributes.
1224:
1225: IF inv_globals.equal(p_trohdr_rec.attribute1, l_trohdr_rec.attribute1)
1226: AND inv_globals.equal(p_trohdr_rec.attribute10, l_trohdr_rec.attribute10)
1227: AND inv_globals.equal(p_trohdr_rec.attribute11, l_trohdr_rec.attribute11)
1228: AND inv_globals.equal(p_trohdr_rec.attribute12, l_trohdr_rec.attribute12)
1229: AND inv_globals.equal(p_trohdr_rec.attribute13, l_trohdr_rec.attribute13)
1222:
1223: -- Row locked. Compare IN attributes to DB attributes.
1224:
1225: IF inv_globals.equal(p_trohdr_rec.attribute1, l_trohdr_rec.attribute1)
1226: AND inv_globals.equal(p_trohdr_rec.attribute10, l_trohdr_rec.attribute10)
1227: AND inv_globals.equal(p_trohdr_rec.attribute11, l_trohdr_rec.attribute11)
1228: AND inv_globals.equal(p_trohdr_rec.attribute12, l_trohdr_rec.attribute12)
1229: AND inv_globals.equal(p_trohdr_rec.attribute13, l_trohdr_rec.attribute13)
1230: AND inv_globals.equal(p_trohdr_rec.attribute14, l_trohdr_rec.attribute14)
1223: -- Row locked. Compare IN attributes to DB attributes.
1224:
1225: IF inv_globals.equal(p_trohdr_rec.attribute1, l_trohdr_rec.attribute1)
1226: AND inv_globals.equal(p_trohdr_rec.attribute10, l_trohdr_rec.attribute10)
1227: AND inv_globals.equal(p_trohdr_rec.attribute11, l_trohdr_rec.attribute11)
1228: AND inv_globals.equal(p_trohdr_rec.attribute12, l_trohdr_rec.attribute12)
1229: AND inv_globals.equal(p_trohdr_rec.attribute13, l_trohdr_rec.attribute13)
1230: AND inv_globals.equal(p_trohdr_rec.attribute14, l_trohdr_rec.attribute14)
1231: AND inv_globals.equal(p_trohdr_rec.attribute15, l_trohdr_rec.attribute15)
1224:
1225: IF inv_globals.equal(p_trohdr_rec.attribute1, l_trohdr_rec.attribute1)
1226: AND inv_globals.equal(p_trohdr_rec.attribute10, l_trohdr_rec.attribute10)
1227: AND inv_globals.equal(p_trohdr_rec.attribute11, l_trohdr_rec.attribute11)
1228: AND inv_globals.equal(p_trohdr_rec.attribute12, l_trohdr_rec.attribute12)
1229: AND inv_globals.equal(p_trohdr_rec.attribute13, l_trohdr_rec.attribute13)
1230: AND inv_globals.equal(p_trohdr_rec.attribute14, l_trohdr_rec.attribute14)
1231: AND inv_globals.equal(p_trohdr_rec.attribute15, l_trohdr_rec.attribute15)
1232: AND inv_globals.equal(p_trohdr_rec.attribute2, l_trohdr_rec.attribute2)
1225: IF inv_globals.equal(p_trohdr_rec.attribute1, l_trohdr_rec.attribute1)
1226: AND inv_globals.equal(p_trohdr_rec.attribute10, l_trohdr_rec.attribute10)
1227: AND inv_globals.equal(p_trohdr_rec.attribute11, l_trohdr_rec.attribute11)
1228: AND inv_globals.equal(p_trohdr_rec.attribute12, l_trohdr_rec.attribute12)
1229: AND inv_globals.equal(p_trohdr_rec.attribute13, l_trohdr_rec.attribute13)
1230: AND inv_globals.equal(p_trohdr_rec.attribute14, l_trohdr_rec.attribute14)
1231: AND inv_globals.equal(p_trohdr_rec.attribute15, l_trohdr_rec.attribute15)
1232: AND inv_globals.equal(p_trohdr_rec.attribute2, l_trohdr_rec.attribute2)
1233: AND inv_globals.equal(p_trohdr_rec.attribute3, l_trohdr_rec.attribute3)
1226: AND inv_globals.equal(p_trohdr_rec.attribute10, l_trohdr_rec.attribute10)
1227: AND inv_globals.equal(p_trohdr_rec.attribute11, l_trohdr_rec.attribute11)
1228: AND inv_globals.equal(p_trohdr_rec.attribute12, l_trohdr_rec.attribute12)
1229: AND inv_globals.equal(p_trohdr_rec.attribute13, l_trohdr_rec.attribute13)
1230: AND inv_globals.equal(p_trohdr_rec.attribute14, l_trohdr_rec.attribute14)
1231: AND inv_globals.equal(p_trohdr_rec.attribute15, l_trohdr_rec.attribute15)
1232: AND inv_globals.equal(p_trohdr_rec.attribute2, l_trohdr_rec.attribute2)
1233: AND inv_globals.equal(p_trohdr_rec.attribute3, l_trohdr_rec.attribute3)
1234: AND inv_globals.equal(p_trohdr_rec.attribute4, l_trohdr_rec.attribute4)
1227: AND inv_globals.equal(p_trohdr_rec.attribute11, l_trohdr_rec.attribute11)
1228: AND inv_globals.equal(p_trohdr_rec.attribute12, l_trohdr_rec.attribute12)
1229: AND inv_globals.equal(p_trohdr_rec.attribute13, l_trohdr_rec.attribute13)
1230: AND inv_globals.equal(p_trohdr_rec.attribute14, l_trohdr_rec.attribute14)
1231: AND inv_globals.equal(p_trohdr_rec.attribute15, l_trohdr_rec.attribute15)
1232: AND inv_globals.equal(p_trohdr_rec.attribute2, l_trohdr_rec.attribute2)
1233: AND inv_globals.equal(p_trohdr_rec.attribute3, l_trohdr_rec.attribute3)
1234: AND inv_globals.equal(p_trohdr_rec.attribute4, l_trohdr_rec.attribute4)
1235: AND inv_globals.equal(p_trohdr_rec.attribute5, l_trohdr_rec.attribute5)
1228: AND inv_globals.equal(p_trohdr_rec.attribute12, l_trohdr_rec.attribute12)
1229: AND inv_globals.equal(p_trohdr_rec.attribute13, l_trohdr_rec.attribute13)
1230: AND inv_globals.equal(p_trohdr_rec.attribute14, l_trohdr_rec.attribute14)
1231: AND inv_globals.equal(p_trohdr_rec.attribute15, l_trohdr_rec.attribute15)
1232: AND inv_globals.equal(p_trohdr_rec.attribute2, l_trohdr_rec.attribute2)
1233: AND inv_globals.equal(p_trohdr_rec.attribute3, l_trohdr_rec.attribute3)
1234: AND inv_globals.equal(p_trohdr_rec.attribute4, l_trohdr_rec.attribute4)
1235: AND inv_globals.equal(p_trohdr_rec.attribute5, l_trohdr_rec.attribute5)
1236: AND inv_globals.equal(p_trohdr_rec.attribute6, l_trohdr_rec.attribute6)
1229: AND inv_globals.equal(p_trohdr_rec.attribute13, l_trohdr_rec.attribute13)
1230: AND inv_globals.equal(p_trohdr_rec.attribute14, l_trohdr_rec.attribute14)
1231: AND inv_globals.equal(p_trohdr_rec.attribute15, l_trohdr_rec.attribute15)
1232: AND inv_globals.equal(p_trohdr_rec.attribute2, l_trohdr_rec.attribute2)
1233: AND inv_globals.equal(p_trohdr_rec.attribute3, l_trohdr_rec.attribute3)
1234: AND inv_globals.equal(p_trohdr_rec.attribute4, l_trohdr_rec.attribute4)
1235: AND inv_globals.equal(p_trohdr_rec.attribute5, l_trohdr_rec.attribute5)
1236: AND inv_globals.equal(p_trohdr_rec.attribute6, l_trohdr_rec.attribute6)
1237: AND inv_globals.equal(p_trohdr_rec.attribute7, l_trohdr_rec.attribute7)
1230: AND inv_globals.equal(p_trohdr_rec.attribute14, l_trohdr_rec.attribute14)
1231: AND inv_globals.equal(p_trohdr_rec.attribute15, l_trohdr_rec.attribute15)
1232: AND inv_globals.equal(p_trohdr_rec.attribute2, l_trohdr_rec.attribute2)
1233: AND inv_globals.equal(p_trohdr_rec.attribute3, l_trohdr_rec.attribute3)
1234: AND inv_globals.equal(p_trohdr_rec.attribute4, l_trohdr_rec.attribute4)
1235: AND inv_globals.equal(p_trohdr_rec.attribute5, l_trohdr_rec.attribute5)
1236: AND inv_globals.equal(p_trohdr_rec.attribute6, l_trohdr_rec.attribute6)
1237: AND inv_globals.equal(p_trohdr_rec.attribute7, l_trohdr_rec.attribute7)
1238: AND inv_globals.equal(p_trohdr_rec.attribute8, l_trohdr_rec.attribute8)
1231: AND inv_globals.equal(p_trohdr_rec.attribute15, l_trohdr_rec.attribute15)
1232: AND inv_globals.equal(p_trohdr_rec.attribute2, l_trohdr_rec.attribute2)
1233: AND inv_globals.equal(p_trohdr_rec.attribute3, l_trohdr_rec.attribute3)
1234: AND inv_globals.equal(p_trohdr_rec.attribute4, l_trohdr_rec.attribute4)
1235: AND inv_globals.equal(p_trohdr_rec.attribute5, l_trohdr_rec.attribute5)
1236: AND inv_globals.equal(p_trohdr_rec.attribute6, l_trohdr_rec.attribute6)
1237: AND inv_globals.equal(p_trohdr_rec.attribute7, l_trohdr_rec.attribute7)
1238: AND inv_globals.equal(p_trohdr_rec.attribute8, l_trohdr_rec.attribute8)
1239: AND inv_globals.equal(p_trohdr_rec.attribute9, l_trohdr_rec.attribute9)
1232: AND inv_globals.equal(p_trohdr_rec.attribute2, l_trohdr_rec.attribute2)
1233: AND inv_globals.equal(p_trohdr_rec.attribute3, l_trohdr_rec.attribute3)
1234: AND inv_globals.equal(p_trohdr_rec.attribute4, l_trohdr_rec.attribute4)
1235: AND inv_globals.equal(p_trohdr_rec.attribute5, l_trohdr_rec.attribute5)
1236: AND inv_globals.equal(p_trohdr_rec.attribute6, l_trohdr_rec.attribute6)
1237: AND inv_globals.equal(p_trohdr_rec.attribute7, l_trohdr_rec.attribute7)
1238: AND inv_globals.equal(p_trohdr_rec.attribute8, l_trohdr_rec.attribute8)
1239: AND inv_globals.equal(p_trohdr_rec.attribute9, l_trohdr_rec.attribute9)
1240: AND inv_globals.equal(p_trohdr_rec.attribute_category, l_trohdr_rec.attribute_category)
1233: AND inv_globals.equal(p_trohdr_rec.attribute3, l_trohdr_rec.attribute3)
1234: AND inv_globals.equal(p_trohdr_rec.attribute4, l_trohdr_rec.attribute4)
1235: AND inv_globals.equal(p_trohdr_rec.attribute5, l_trohdr_rec.attribute5)
1236: AND inv_globals.equal(p_trohdr_rec.attribute6, l_trohdr_rec.attribute6)
1237: AND inv_globals.equal(p_trohdr_rec.attribute7, l_trohdr_rec.attribute7)
1238: AND inv_globals.equal(p_trohdr_rec.attribute8, l_trohdr_rec.attribute8)
1239: AND inv_globals.equal(p_trohdr_rec.attribute9, l_trohdr_rec.attribute9)
1240: AND inv_globals.equal(p_trohdr_rec.attribute_category, l_trohdr_rec.attribute_category)
1241: AND inv_globals.equal(p_trohdr_rec.created_by, l_trohdr_rec.created_by)
1234: AND inv_globals.equal(p_trohdr_rec.attribute4, l_trohdr_rec.attribute4)
1235: AND inv_globals.equal(p_trohdr_rec.attribute5, l_trohdr_rec.attribute5)
1236: AND inv_globals.equal(p_trohdr_rec.attribute6, l_trohdr_rec.attribute6)
1237: AND inv_globals.equal(p_trohdr_rec.attribute7, l_trohdr_rec.attribute7)
1238: AND inv_globals.equal(p_trohdr_rec.attribute8, l_trohdr_rec.attribute8)
1239: AND inv_globals.equal(p_trohdr_rec.attribute9, l_trohdr_rec.attribute9)
1240: AND inv_globals.equal(p_trohdr_rec.attribute_category, l_trohdr_rec.attribute_category)
1241: AND inv_globals.equal(p_trohdr_rec.created_by, l_trohdr_rec.created_by)
1242: AND inv_globals.equal(p_trohdr_rec.creation_date, l_trohdr_rec.creation_date)
1235: AND inv_globals.equal(p_trohdr_rec.attribute5, l_trohdr_rec.attribute5)
1236: AND inv_globals.equal(p_trohdr_rec.attribute6, l_trohdr_rec.attribute6)
1237: AND inv_globals.equal(p_trohdr_rec.attribute7, l_trohdr_rec.attribute7)
1238: AND inv_globals.equal(p_trohdr_rec.attribute8, l_trohdr_rec.attribute8)
1239: AND inv_globals.equal(p_trohdr_rec.attribute9, l_trohdr_rec.attribute9)
1240: AND inv_globals.equal(p_trohdr_rec.attribute_category, l_trohdr_rec.attribute_category)
1241: AND inv_globals.equal(p_trohdr_rec.created_by, l_trohdr_rec.created_by)
1242: AND inv_globals.equal(p_trohdr_rec.creation_date, l_trohdr_rec.creation_date)
1243: AND inv_globals.equal(p_trohdr_rec.date_required, l_trohdr_rec.date_required)
1236: AND inv_globals.equal(p_trohdr_rec.attribute6, l_trohdr_rec.attribute6)
1237: AND inv_globals.equal(p_trohdr_rec.attribute7, l_trohdr_rec.attribute7)
1238: AND inv_globals.equal(p_trohdr_rec.attribute8, l_trohdr_rec.attribute8)
1239: AND inv_globals.equal(p_trohdr_rec.attribute9, l_trohdr_rec.attribute9)
1240: AND inv_globals.equal(p_trohdr_rec.attribute_category, l_trohdr_rec.attribute_category)
1241: AND inv_globals.equal(p_trohdr_rec.created_by, l_trohdr_rec.created_by)
1242: AND inv_globals.equal(p_trohdr_rec.creation_date, l_trohdr_rec.creation_date)
1243: AND inv_globals.equal(p_trohdr_rec.date_required, l_trohdr_rec.date_required)
1244: AND inv_globals.equal(p_trohdr_rec.description, l_trohdr_rec.description)
1237: AND inv_globals.equal(p_trohdr_rec.attribute7, l_trohdr_rec.attribute7)
1238: AND inv_globals.equal(p_trohdr_rec.attribute8, l_trohdr_rec.attribute8)
1239: AND inv_globals.equal(p_trohdr_rec.attribute9, l_trohdr_rec.attribute9)
1240: AND inv_globals.equal(p_trohdr_rec.attribute_category, l_trohdr_rec.attribute_category)
1241: AND inv_globals.equal(p_trohdr_rec.created_by, l_trohdr_rec.created_by)
1242: AND inv_globals.equal(p_trohdr_rec.creation_date, l_trohdr_rec.creation_date)
1243: AND inv_globals.equal(p_trohdr_rec.date_required, l_trohdr_rec.date_required)
1244: AND inv_globals.equal(p_trohdr_rec.description, l_trohdr_rec.description)
1245: AND inv_globals.equal(p_trohdr_rec.from_subinventory_code, l_trohdr_rec.from_subinventory_code)
1238: AND inv_globals.equal(p_trohdr_rec.attribute8, l_trohdr_rec.attribute8)
1239: AND inv_globals.equal(p_trohdr_rec.attribute9, l_trohdr_rec.attribute9)
1240: AND inv_globals.equal(p_trohdr_rec.attribute_category, l_trohdr_rec.attribute_category)
1241: AND inv_globals.equal(p_trohdr_rec.created_by, l_trohdr_rec.created_by)
1242: AND inv_globals.equal(p_trohdr_rec.creation_date, l_trohdr_rec.creation_date)
1243: AND inv_globals.equal(p_trohdr_rec.date_required, l_trohdr_rec.date_required)
1244: AND inv_globals.equal(p_trohdr_rec.description, l_trohdr_rec.description)
1245: AND inv_globals.equal(p_trohdr_rec.from_subinventory_code, l_trohdr_rec.from_subinventory_code)
1246: AND inv_globals.equal(p_trohdr_rec.header_id, l_trohdr_rec.header_id)
1239: AND inv_globals.equal(p_trohdr_rec.attribute9, l_trohdr_rec.attribute9)
1240: AND inv_globals.equal(p_trohdr_rec.attribute_category, l_trohdr_rec.attribute_category)
1241: AND inv_globals.equal(p_trohdr_rec.created_by, l_trohdr_rec.created_by)
1242: AND inv_globals.equal(p_trohdr_rec.creation_date, l_trohdr_rec.creation_date)
1243: AND inv_globals.equal(p_trohdr_rec.date_required, l_trohdr_rec.date_required)
1244: AND inv_globals.equal(p_trohdr_rec.description, l_trohdr_rec.description)
1245: AND inv_globals.equal(p_trohdr_rec.from_subinventory_code, l_trohdr_rec.from_subinventory_code)
1246: AND inv_globals.equal(p_trohdr_rec.header_id, l_trohdr_rec.header_id)
1247: AND inv_globals.equal(p_trohdr_rec.header_status, l_trohdr_rec.header_status)
1240: AND inv_globals.equal(p_trohdr_rec.attribute_category, l_trohdr_rec.attribute_category)
1241: AND inv_globals.equal(p_trohdr_rec.created_by, l_trohdr_rec.created_by)
1242: AND inv_globals.equal(p_trohdr_rec.creation_date, l_trohdr_rec.creation_date)
1243: AND inv_globals.equal(p_trohdr_rec.date_required, l_trohdr_rec.date_required)
1244: AND inv_globals.equal(p_trohdr_rec.description, l_trohdr_rec.description)
1245: AND inv_globals.equal(p_trohdr_rec.from_subinventory_code, l_trohdr_rec.from_subinventory_code)
1246: AND inv_globals.equal(p_trohdr_rec.header_id, l_trohdr_rec.header_id)
1247: AND inv_globals.equal(p_trohdr_rec.header_status, l_trohdr_rec.header_status)
1248: AND inv_globals.equal(p_trohdr_rec.last_updated_by, l_trohdr_rec.last_updated_by)
1241: AND inv_globals.equal(p_trohdr_rec.created_by, l_trohdr_rec.created_by)
1242: AND inv_globals.equal(p_trohdr_rec.creation_date, l_trohdr_rec.creation_date)
1243: AND inv_globals.equal(p_trohdr_rec.date_required, l_trohdr_rec.date_required)
1244: AND inv_globals.equal(p_trohdr_rec.description, l_trohdr_rec.description)
1245: AND inv_globals.equal(p_trohdr_rec.from_subinventory_code, l_trohdr_rec.from_subinventory_code)
1246: AND inv_globals.equal(p_trohdr_rec.header_id, l_trohdr_rec.header_id)
1247: AND inv_globals.equal(p_trohdr_rec.header_status, l_trohdr_rec.header_status)
1248: AND inv_globals.equal(p_trohdr_rec.last_updated_by, l_trohdr_rec.last_updated_by)
1249: AND inv_globals.equal(p_trohdr_rec.last_update_date, l_trohdr_rec.last_update_date)
1242: AND inv_globals.equal(p_trohdr_rec.creation_date, l_trohdr_rec.creation_date)
1243: AND inv_globals.equal(p_trohdr_rec.date_required, l_trohdr_rec.date_required)
1244: AND inv_globals.equal(p_trohdr_rec.description, l_trohdr_rec.description)
1245: AND inv_globals.equal(p_trohdr_rec.from_subinventory_code, l_trohdr_rec.from_subinventory_code)
1246: AND inv_globals.equal(p_trohdr_rec.header_id, l_trohdr_rec.header_id)
1247: AND inv_globals.equal(p_trohdr_rec.header_status, l_trohdr_rec.header_status)
1248: AND inv_globals.equal(p_trohdr_rec.last_updated_by, l_trohdr_rec.last_updated_by)
1249: AND inv_globals.equal(p_trohdr_rec.last_update_date, l_trohdr_rec.last_update_date)
1250: AND inv_globals.equal(p_trohdr_rec.last_update_login, l_trohdr_rec.last_update_login)
1243: AND inv_globals.equal(p_trohdr_rec.date_required, l_trohdr_rec.date_required)
1244: AND inv_globals.equal(p_trohdr_rec.description, l_trohdr_rec.description)
1245: AND inv_globals.equal(p_trohdr_rec.from_subinventory_code, l_trohdr_rec.from_subinventory_code)
1246: AND inv_globals.equal(p_trohdr_rec.header_id, l_trohdr_rec.header_id)
1247: AND inv_globals.equal(p_trohdr_rec.header_status, l_trohdr_rec.header_status)
1248: AND inv_globals.equal(p_trohdr_rec.last_updated_by, l_trohdr_rec.last_updated_by)
1249: AND inv_globals.equal(p_trohdr_rec.last_update_date, l_trohdr_rec.last_update_date)
1250: AND inv_globals.equal(p_trohdr_rec.last_update_login, l_trohdr_rec.last_update_login)
1251: AND inv_globals.equal(p_trohdr_rec.organization_id, l_trohdr_rec.organization_id)
1244: AND inv_globals.equal(p_trohdr_rec.description, l_trohdr_rec.description)
1245: AND inv_globals.equal(p_trohdr_rec.from_subinventory_code, l_trohdr_rec.from_subinventory_code)
1246: AND inv_globals.equal(p_trohdr_rec.header_id, l_trohdr_rec.header_id)
1247: AND inv_globals.equal(p_trohdr_rec.header_status, l_trohdr_rec.header_status)
1248: AND inv_globals.equal(p_trohdr_rec.last_updated_by, l_trohdr_rec.last_updated_by)
1249: AND inv_globals.equal(p_trohdr_rec.last_update_date, l_trohdr_rec.last_update_date)
1250: AND inv_globals.equal(p_trohdr_rec.last_update_login, l_trohdr_rec.last_update_login)
1251: AND inv_globals.equal(p_trohdr_rec.organization_id, l_trohdr_rec.organization_id)
1252: AND inv_globals.equal(p_trohdr_rec.program_application_id, l_trohdr_rec.program_application_id)
1245: AND inv_globals.equal(p_trohdr_rec.from_subinventory_code, l_trohdr_rec.from_subinventory_code)
1246: AND inv_globals.equal(p_trohdr_rec.header_id, l_trohdr_rec.header_id)
1247: AND inv_globals.equal(p_trohdr_rec.header_status, l_trohdr_rec.header_status)
1248: AND inv_globals.equal(p_trohdr_rec.last_updated_by, l_trohdr_rec.last_updated_by)
1249: AND inv_globals.equal(p_trohdr_rec.last_update_date, l_trohdr_rec.last_update_date)
1250: AND inv_globals.equal(p_trohdr_rec.last_update_login, l_trohdr_rec.last_update_login)
1251: AND inv_globals.equal(p_trohdr_rec.organization_id, l_trohdr_rec.organization_id)
1252: AND inv_globals.equal(p_trohdr_rec.program_application_id, l_trohdr_rec.program_application_id)
1253: AND inv_globals.equal(p_trohdr_rec.program_id, l_trohdr_rec.program_id)
1246: AND inv_globals.equal(p_trohdr_rec.header_id, l_trohdr_rec.header_id)
1247: AND inv_globals.equal(p_trohdr_rec.header_status, l_trohdr_rec.header_status)
1248: AND inv_globals.equal(p_trohdr_rec.last_updated_by, l_trohdr_rec.last_updated_by)
1249: AND inv_globals.equal(p_trohdr_rec.last_update_date, l_trohdr_rec.last_update_date)
1250: AND inv_globals.equal(p_trohdr_rec.last_update_login, l_trohdr_rec.last_update_login)
1251: AND inv_globals.equal(p_trohdr_rec.organization_id, l_trohdr_rec.organization_id)
1252: AND inv_globals.equal(p_trohdr_rec.program_application_id, l_trohdr_rec.program_application_id)
1253: AND inv_globals.equal(p_trohdr_rec.program_id, l_trohdr_rec.program_id)
1254: AND inv_globals.equal(p_trohdr_rec.program_update_date, l_trohdr_rec.program_update_date)
1247: AND inv_globals.equal(p_trohdr_rec.header_status, l_trohdr_rec.header_status)
1248: AND inv_globals.equal(p_trohdr_rec.last_updated_by, l_trohdr_rec.last_updated_by)
1249: AND inv_globals.equal(p_trohdr_rec.last_update_date, l_trohdr_rec.last_update_date)
1250: AND inv_globals.equal(p_trohdr_rec.last_update_login, l_trohdr_rec.last_update_login)
1251: AND inv_globals.equal(p_trohdr_rec.organization_id, l_trohdr_rec.organization_id)
1252: AND inv_globals.equal(p_trohdr_rec.program_application_id, l_trohdr_rec.program_application_id)
1253: AND inv_globals.equal(p_trohdr_rec.program_id, l_trohdr_rec.program_id)
1254: AND inv_globals.equal(p_trohdr_rec.program_update_date, l_trohdr_rec.program_update_date)
1255: AND inv_globals.equal(p_trohdr_rec.request_id, l_trohdr_rec.request_id)
1248: AND inv_globals.equal(p_trohdr_rec.last_updated_by, l_trohdr_rec.last_updated_by)
1249: AND inv_globals.equal(p_trohdr_rec.last_update_date, l_trohdr_rec.last_update_date)
1250: AND inv_globals.equal(p_trohdr_rec.last_update_login, l_trohdr_rec.last_update_login)
1251: AND inv_globals.equal(p_trohdr_rec.organization_id, l_trohdr_rec.organization_id)
1252: AND inv_globals.equal(p_trohdr_rec.program_application_id, l_trohdr_rec.program_application_id)
1253: AND inv_globals.equal(p_trohdr_rec.program_id, l_trohdr_rec.program_id)
1254: AND inv_globals.equal(p_trohdr_rec.program_update_date, l_trohdr_rec.program_update_date)
1255: AND inv_globals.equal(p_trohdr_rec.request_id, l_trohdr_rec.request_id)
1256: AND inv_globals.equal(p_trohdr_rec.request_number, l_trohdr_rec.request_number)
1249: AND inv_globals.equal(p_trohdr_rec.last_update_date, l_trohdr_rec.last_update_date)
1250: AND inv_globals.equal(p_trohdr_rec.last_update_login, l_trohdr_rec.last_update_login)
1251: AND inv_globals.equal(p_trohdr_rec.organization_id, l_trohdr_rec.organization_id)
1252: AND inv_globals.equal(p_trohdr_rec.program_application_id, l_trohdr_rec.program_application_id)
1253: AND inv_globals.equal(p_trohdr_rec.program_id, l_trohdr_rec.program_id)
1254: AND inv_globals.equal(p_trohdr_rec.program_update_date, l_trohdr_rec.program_update_date)
1255: AND inv_globals.equal(p_trohdr_rec.request_id, l_trohdr_rec.request_id)
1256: AND inv_globals.equal(p_trohdr_rec.request_number, l_trohdr_rec.request_number)
1257: AND inv_globals.equal(p_trohdr_rec.status_date, l_trohdr_rec.status_date)
1250: AND inv_globals.equal(p_trohdr_rec.last_update_login, l_trohdr_rec.last_update_login)
1251: AND inv_globals.equal(p_trohdr_rec.organization_id, l_trohdr_rec.organization_id)
1252: AND inv_globals.equal(p_trohdr_rec.program_application_id, l_trohdr_rec.program_application_id)
1253: AND inv_globals.equal(p_trohdr_rec.program_id, l_trohdr_rec.program_id)
1254: AND inv_globals.equal(p_trohdr_rec.program_update_date, l_trohdr_rec.program_update_date)
1255: AND inv_globals.equal(p_trohdr_rec.request_id, l_trohdr_rec.request_id)
1256: AND inv_globals.equal(p_trohdr_rec.request_number, l_trohdr_rec.request_number)
1257: AND inv_globals.equal(p_trohdr_rec.status_date, l_trohdr_rec.status_date)
1258: AND inv_globals.equal(p_trohdr_rec.to_account_id, l_trohdr_rec.to_account_id)
1251: AND inv_globals.equal(p_trohdr_rec.organization_id, l_trohdr_rec.organization_id)
1252: AND inv_globals.equal(p_trohdr_rec.program_application_id, l_trohdr_rec.program_application_id)
1253: AND inv_globals.equal(p_trohdr_rec.program_id, l_trohdr_rec.program_id)
1254: AND inv_globals.equal(p_trohdr_rec.program_update_date, l_trohdr_rec.program_update_date)
1255: AND inv_globals.equal(p_trohdr_rec.request_id, l_trohdr_rec.request_id)
1256: AND inv_globals.equal(p_trohdr_rec.request_number, l_trohdr_rec.request_number)
1257: AND inv_globals.equal(p_trohdr_rec.status_date, l_trohdr_rec.status_date)
1258: AND inv_globals.equal(p_trohdr_rec.to_account_id, l_trohdr_rec.to_account_id)
1259: AND inv_globals.equal(p_trohdr_rec.to_subinventory_code, l_trohdr_rec.to_subinventory_code)
1252: AND inv_globals.equal(p_trohdr_rec.program_application_id, l_trohdr_rec.program_application_id)
1253: AND inv_globals.equal(p_trohdr_rec.program_id, l_trohdr_rec.program_id)
1254: AND inv_globals.equal(p_trohdr_rec.program_update_date, l_trohdr_rec.program_update_date)
1255: AND inv_globals.equal(p_trohdr_rec.request_id, l_trohdr_rec.request_id)
1256: AND inv_globals.equal(p_trohdr_rec.request_number, l_trohdr_rec.request_number)
1257: AND inv_globals.equal(p_trohdr_rec.status_date, l_trohdr_rec.status_date)
1258: AND inv_globals.equal(p_trohdr_rec.to_account_id, l_trohdr_rec.to_account_id)
1259: AND inv_globals.equal(p_trohdr_rec.to_subinventory_code, l_trohdr_rec.to_subinventory_code)
1260: AND inv_globals.equal(p_trohdr_rec.move_order_type, l_trohdr_rec.move_order_type)
1253: AND inv_globals.equal(p_trohdr_rec.program_id, l_trohdr_rec.program_id)
1254: AND inv_globals.equal(p_trohdr_rec.program_update_date, l_trohdr_rec.program_update_date)
1255: AND inv_globals.equal(p_trohdr_rec.request_id, l_trohdr_rec.request_id)
1256: AND inv_globals.equal(p_trohdr_rec.request_number, l_trohdr_rec.request_number)
1257: AND inv_globals.equal(p_trohdr_rec.status_date, l_trohdr_rec.status_date)
1258: AND inv_globals.equal(p_trohdr_rec.to_account_id, l_trohdr_rec.to_account_id)
1259: AND inv_globals.equal(p_trohdr_rec.to_subinventory_code, l_trohdr_rec.to_subinventory_code)
1260: AND inv_globals.equal(p_trohdr_rec.move_order_type, l_trohdr_rec.move_order_type)
1261: AND inv_globals.equal(p_trohdr_rec.transaction_type_id, l_trohdr_rec.transaction_type_id)
1254: AND inv_globals.equal(p_trohdr_rec.program_update_date, l_trohdr_rec.program_update_date)
1255: AND inv_globals.equal(p_trohdr_rec.request_id, l_trohdr_rec.request_id)
1256: AND inv_globals.equal(p_trohdr_rec.request_number, l_trohdr_rec.request_number)
1257: AND inv_globals.equal(p_trohdr_rec.status_date, l_trohdr_rec.status_date)
1258: AND inv_globals.equal(p_trohdr_rec.to_account_id, l_trohdr_rec.to_account_id)
1259: AND inv_globals.equal(p_trohdr_rec.to_subinventory_code, l_trohdr_rec.to_subinventory_code)
1260: AND inv_globals.equal(p_trohdr_rec.move_order_type, l_trohdr_rec.move_order_type)
1261: AND inv_globals.equal(p_trohdr_rec.transaction_type_id, l_trohdr_rec.transaction_type_id)
1262: AND inv_globals.equal(p_trohdr_rec.grouping_rule_id, l_trohdr_rec.grouping_rule_id)
1255: AND inv_globals.equal(p_trohdr_rec.request_id, l_trohdr_rec.request_id)
1256: AND inv_globals.equal(p_trohdr_rec.request_number, l_trohdr_rec.request_number)
1257: AND inv_globals.equal(p_trohdr_rec.status_date, l_trohdr_rec.status_date)
1258: AND inv_globals.equal(p_trohdr_rec.to_account_id, l_trohdr_rec.to_account_id)
1259: AND inv_globals.equal(p_trohdr_rec.to_subinventory_code, l_trohdr_rec.to_subinventory_code)
1260: AND inv_globals.equal(p_trohdr_rec.move_order_type, l_trohdr_rec.move_order_type)
1261: AND inv_globals.equal(p_trohdr_rec.transaction_type_id, l_trohdr_rec.transaction_type_id)
1262: AND inv_globals.equal(p_trohdr_rec.grouping_rule_id, l_trohdr_rec.grouping_rule_id)
1263: AND inv_globals.equal(p_trohdr_rec.ship_to_location_id, l_trohdr_rec.ship_to_location_id) THEN
1256: AND inv_globals.equal(p_trohdr_rec.request_number, l_trohdr_rec.request_number)
1257: AND inv_globals.equal(p_trohdr_rec.status_date, l_trohdr_rec.status_date)
1258: AND inv_globals.equal(p_trohdr_rec.to_account_id, l_trohdr_rec.to_account_id)
1259: AND inv_globals.equal(p_trohdr_rec.to_subinventory_code, l_trohdr_rec.to_subinventory_code)
1260: AND inv_globals.equal(p_trohdr_rec.move_order_type, l_trohdr_rec.move_order_type)
1261: AND inv_globals.equal(p_trohdr_rec.transaction_type_id, l_trohdr_rec.transaction_type_id)
1262: AND inv_globals.equal(p_trohdr_rec.grouping_rule_id, l_trohdr_rec.grouping_rule_id)
1263: AND inv_globals.equal(p_trohdr_rec.ship_to_location_id, l_trohdr_rec.ship_to_location_id) THEN
1264: -- Row has not changed. Set out parameter.
1257: AND inv_globals.equal(p_trohdr_rec.status_date, l_trohdr_rec.status_date)
1258: AND inv_globals.equal(p_trohdr_rec.to_account_id, l_trohdr_rec.to_account_id)
1259: AND inv_globals.equal(p_trohdr_rec.to_subinventory_code, l_trohdr_rec.to_subinventory_code)
1260: AND inv_globals.equal(p_trohdr_rec.move_order_type, l_trohdr_rec.move_order_type)
1261: AND inv_globals.equal(p_trohdr_rec.transaction_type_id, l_trohdr_rec.transaction_type_id)
1262: AND inv_globals.equal(p_trohdr_rec.grouping_rule_id, l_trohdr_rec.grouping_rule_id)
1263: AND inv_globals.equal(p_trohdr_rec.ship_to_location_id, l_trohdr_rec.ship_to_location_id) THEN
1264: -- Row has not changed. Set out parameter.
1265:
1258: AND inv_globals.equal(p_trohdr_rec.to_account_id, l_trohdr_rec.to_account_id)
1259: AND inv_globals.equal(p_trohdr_rec.to_subinventory_code, l_trohdr_rec.to_subinventory_code)
1260: AND inv_globals.equal(p_trohdr_rec.move_order_type, l_trohdr_rec.move_order_type)
1261: AND inv_globals.equal(p_trohdr_rec.transaction_type_id, l_trohdr_rec.transaction_type_id)
1262: AND inv_globals.equal(p_trohdr_rec.grouping_rule_id, l_trohdr_rec.grouping_rule_id)
1263: AND inv_globals.equal(p_trohdr_rec.ship_to_location_id, l_trohdr_rec.ship_to_location_id) THEN
1264: -- Row has not changed. Set out parameter.
1265:
1266: x_trohdr_rec := l_trohdr_rec;
1259: AND inv_globals.equal(p_trohdr_rec.to_subinventory_code, l_trohdr_rec.to_subinventory_code)
1260: AND inv_globals.equal(p_trohdr_rec.move_order_type, l_trohdr_rec.move_order_type)
1261: AND inv_globals.equal(p_trohdr_rec.transaction_type_id, l_trohdr_rec.transaction_type_id)
1262: AND inv_globals.equal(p_trohdr_rec.grouping_rule_id, l_trohdr_rec.grouping_rule_id)
1263: AND inv_globals.equal(p_trohdr_rec.ship_to_location_id, l_trohdr_rec.ship_to_location_id) THEN
1264: -- Row has not changed. Set out parameter.
1265:
1266: x_trohdr_rec := l_trohdr_rec;
1267: -- Set return status
1312: l_trohdr_val_rec inv_move_order_pub.trohdr_val_rec_type;
1313: BEGIN
1314: -- IF p_trohdr_rec.from_subinventory_code IS NOT NULL AND
1315: -- p_trohdr_rec.from_subinventory_code <> FND_API.G_MISS_CHAR AND
1316: -- NOT INV_GLOBALS.Equal(p_trohdr_rec.from_subinventory_code,
1317: -- p_old_trohdr_rec.from_subinventory_code)
1318: -- THEN
1319: -- l_trohdr_val_rec.from_subinventory := INV_Id_To_Value.From_Subinventory
1320: -- ( p_from_subinventory_code => p_trohdr_rec.from_subinventory_code
1322: -- END IF;
1323:
1324: IF p_trohdr_rec.header_id IS NOT NULL
1325: AND p_trohdr_rec.header_id <> fnd_api.g_miss_num
1326: AND NOT inv_globals.equal(p_trohdr_rec.header_id, p_old_trohdr_rec.header_id) THEN
1327: l_trohdr_val_rec.header := inv_id_to_value.header(p_header_id => p_trohdr_rec.header_id);
1328: END IF;
1329:
1330: IF p_trohdr_rec.organization_id IS NOT NULL
1328: END IF;
1329:
1330: IF p_trohdr_rec.organization_id IS NOT NULL
1331: AND p_trohdr_rec.organization_id <> fnd_api.g_miss_num
1332: AND NOT inv_globals.equal(p_trohdr_rec.organization_id, p_old_trohdr_rec.organization_id) THEN
1333: l_trohdr_val_rec.ORGANIZATION := inv_id_to_value.ORGANIZATION(p_organization_id => p_trohdr_rec.organization_id);
1334: END IF;
1335:
1336: IF p_trohdr_rec.to_account_id IS NOT NULL
1334: END IF;
1335:
1336: IF p_trohdr_rec.to_account_id IS NOT NULL
1337: AND p_trohdr_rec.to_account_id <> fnd_api.g_miss_num
1338: AND NOT inv_globals.equal(p_trohdr_rec.to_account_id, p_old_trohdr_rec.to_account_id) THEN
1339: l_trohdr_val_rec.to_account := inv_id_to_value.to_account(p_to_account_id => p_trohdr_rec.to_account_id);
1340: END IF;
1341:
1342: -- IF p_trohdr_rec.to_subinventory_code IS NOT NULL AND
1340: END IF;
1341:
1342: -- IF p_trohdr_rec.to_subinventory_code IS NOT NULL AND
1343: -- p_trohdr_rec.to_subinventory_code <> FND_API.G_MISS_CHAR AND
1344: -- NOT INV_GLOBALS.Equal(p_trohdr_rec.to_subinventory_code,
1345: -- p_old_trohdr_rec.to_subinventory_code)
1346: -- THEN
1347: -- l_trohdr_val_rec.to_subinventory := INV_Id_To_Value.To_Subinventory
1348: -- ( p_to_subinventory_code => p_trohdr_rec.to_subinventory_code
1350: -- END IF;
1351:
1352: IF p_trohdr_rec.move_order_type IS NOT NULL
1353: AND p_trohdr_rec.move_order_type <> fnd_api.g_miss_num
1354: AND NOT inv_globals.equal(p_trohdr_rec.move_order_type, p_old_trohdr_rec.move_order_type) THEN
1355: l_trohdr_val_rec.move_order_type := inv_id_to_value.move_order_type(p_move_order_type => p_trohdr_rec.move_order_type);
1356: END IF;
1357:
1358: /*IF p_trohdr_rec.transaction_type_id IS NOT NULL AND
1356: END IF;
1357:
1358: /*IF p_trohdr_rec.transaction_type_id IS NOT NULL AND
1359: p_trohdr_rec.transaction_type_id <> FND_API.G_MISS_NUM AND
1360: NOT INV_GLOBALS.Equal(p_trohdr_rec.transaction_type_id,
1361: p_old_trohdr_rec.transaction_type_id)
1362: THEN
1363: l_trohdr_val_rec.transaction_type_id := INV_Id_To_Value.Transaction_Type_Id
1364: ( p_transaction_type_id => p_trohdr_rec.transaction_type_id