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

APPS.INV_TROHDR_UTIL dependencies on INV_GLOBALS

Line 17: l_src_attr_tbl inv_globals.number_tbl_type;

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:

Line 18: l_dep_attr_tbl inv_globals.number_tbl_type;

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;

Line 28: IF NOT inv_globals.equal(p_trohdr_rec.attribute1, p_old_trohdr_rec.attribute1) THEN

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:

Line 33: IF NOT inv_globals.equal(p_trohdr_rec.attribute10, p_old_trohdr_rec.attribute10) THEN

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:

Line 38: IF NOT inv_globals.equal(p_trohdr_rec.attribute11, p_old_trohdr_rec.attribute11) THEN

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:

Line 43: IF NOT inv_globals.equal(p_trohdr_rec.attribute12, p_old_trohdr_rec.attribute12) THEN

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:

Line 48: IF NOT inv_globals.equal(p_trohdr_rec.attribute13, p_old_trohdr_rec.attribute13) THEN

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:

Line 53: IF NOT inv_globals.equal(p_trohdr_rec.attribute14, p_old_trohdr_rec.attribute14) THEN

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:

Line 58: IF NOT inv_globals.equal(p_trohdr_rec.attribute15, p_old_trohdr_rec.attribute15) THEN

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:

Line 63: IF NOT inv_globals.equal(p_trohdr_rec.attribute2, p_old_trohdr_rec.attribute2) THEN

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:

Line 68: IF NOT inv_globals.equal(p_trohdr_rec.attribute3, p_old_trohdr_rec.attribute3) THEN

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:

Line 73: IF NOT inv_globals.equal(p_trohdr_rec.attribute4, p_old_trohdr_rec.attribute4) THEN

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:

Line 78: IF NOT inv_globals.equal(p_trohdr_rec.attribute5, p_old_trohdr_rec.attribute5) THEN

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:

Line 83: IF NOT inv_globals.equal(p_trohdr_rec.attribute6, p_old_trohdr_rec.attribute6) THEN

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:

Line 88: IF NOT inv_globals.equal(p_trohdr_rec.attribute7, p_old_trohdr_rec.attribute7) THEN

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:

Line 93: IF NOT inv_globals.equal(p_trohdr_rec.attribute8, p_old_trohdr_rec.attribute8) THEN

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:

Line 98: IF NOT inv_globals.equal(p_trohdr_rec.attribute9, p_old_trohdr_rec.attribute9) THEN

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:

Line 103: IF NOT inv_globals.equal(p_trohdr_rec.attribute_category, p_old_trohdr_rec.attribute_category) THEN

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:

Line 108: IF NOT inv_globals.equal(p_trohdr_rec.created_by, p_old_trohdr_rec.created_by) THEN

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:

Line 113: IF NOT inv_globals.equal(p_trohdr_rec.creation_date, p_old_trohdr_rec.creation_date) THEN

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:

Line 118: IF NOT inv_globals.equal(p_trohdr_rec.date_required, p_old_trohdr_rec.date_required) THEN

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:

Line 123: IF NOT inv_globals.equal(p_trohdr_rec.description, p_old_trohdr_rec.description) THEN

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:

Line 128: IF NOT inv_globals.equal(p_trohdr_rec.from_subinventory_code, p_old_trohdr_rec.from_subinventory_code) THEN

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:

Line 133: IF NOT inv_globals.equal(p_trohdr_rec.header_id, p_old_trohdr_rec.header_id) THEN

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:

Line 138: IF NOT inv_globals.equal(p_trohdr_rec.header_status, p_old_trohdr_rec.header_status) THEN

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:

Line 143: IF NOT inv_globals.equal(p_trohdr_rec.last_updated_by, p_old_trohdr_rec.last_updated_by) THEN

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:

Line 148: IF NOT inv_globals.equal(p_trohdr_rec.last_update_date, p_old_trohdr_rec.last_update_date) 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:
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:

Line 153: IF NOT inv_globals.equal(p_trohdr_rec.last_update_login, p_old_trohdr_rec.last_update_login) 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:
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:

Line 158: IF NOT inv_globals.equal(p_trohdr_rec.organization_id, p_old_trohdr_rec.organization_id) 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:
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:

Line 163: IF NOT inv_globals.equal(p_trohdr_rec.program_application_id, p_old_trohdr_rec.program_application_id) THEN

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:

Line 168: IF NOT inv_globals.equal(p_trohdr_rec.program_id, p_old_trohdr_rec.program_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:
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:

Line 173: IF NOT inv_globals.equal(p_trohdr_rec.program_update_date, p_old_trohdr_rec.program_update_date) THEN

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:

Line 178: IF NOT inv_globals.equal(p_trohdr_rec.request_id, p_old_trohdr_rec.request_id) 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:
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:

Line 183: IF NOT inv_globals.equal(p_trohdr_rec.request_number, p_old_trohdr_rec.request_number) THEN

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:

Line 188: IF NOT inv_globals.equal(p_trohdr_rec.status_date, p_old_trohdr_rec.status_date) THEN

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:

Line 193: IF NOT inv_globals.equal(p_trohdr_rec.to_account_id, p_old_trohdr_rec.to_account_id) THEN

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:

Line 198: IF NOT inv_globals.equal(p_trohdr_rec.to_subinventory_code, p_old_trohdr_rec.to_subinventory_code) THEN

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:

Line 203: IF NOT inv_globals.equal(p_trohdr_rec.move_order_type, p_old_trohdr_rec.move_order_type) THEN

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:

Line 208: IF NOT inv_globals.equal(p_trohdr_rec.transaction_type_id, p_old_trohdr_rec.transaction_type_id) 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:
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:

Line 213: IF NOT inv_globals.equal(p_trohdr_rec.ship_to_location_id, p_old_trohdr_rec.ship_to_location_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:
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

Line 342: IF NOT inv_globals.equal(p_trohdr_rec.attribute1, p_old_trohdr_rec.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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

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

Line 1225: IF inv_globals.equal(p_trohdr_rec.attribute1, l_trohdr_rec.attribute1)

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)

Line 1226: AND inv_globals.equal(p_trohdr_rec.attribute10, l_trohdr_rec.attribute10)

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)

Line 1227: AND inv_globals.equal(p_trohdr_rec.attribute11, l_trohdr_rec.attribute11)

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)

Line 1228: AND inv_globals.equal(p_trohdr_rec.attribute12, l_trohdr_rec.attribute12)

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)

Line 1229: AND inv_globals.equal(p_trohdr_rec.attribute13, l_trohdr_rec.attribute13)

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)

Line 1230: AND inv_globals.equal(p_trohdr_rec.attribute14, l_trohdr_rec.attribute14)

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)

Line 1231: AND inv_globals.equal(p_trohdr_rec.attribute15, l_trohdr_rec.attribute15)

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)

Line 1232: AND inv_globals.equal(p_trohdr_rec.attribute2, l_trohdr_rec.attribute2)

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)

Line 1233: AND inv_globals.equal(p_trohdr_rec.attribute3, l_trohdr_rec.attribute3)

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)

Line 1234: AND inv_globals.equal(p_trohdr_rec.attribute4, l_trohdr_rec.attribute4)

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)

Line 1235: AND inv_globals.equal(p_trohdr_rec.attribute5, l_trohdr_rec.attribute5)

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)

Line 1236: AND inv_globals.equal(p_trohdr_rec.attribute6, l_trohdr_rec.attribute6)

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)

Line 1237: AND inv_globals.equal(p_trohdr_rec.attribute7, l_trohdr_rec.attribute7)

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)

Line 1238: AND inv_globals.equal(p_trohdr_rec.attribute8, l_trohdr_rec.attribute8)

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)

Line 1239: AND inv_globals.equal(p_trohdr_rec.attribute9, l_trohdr_rec.attribute9)

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)

Line 1240: AND inv_globals.equal(p_trohdr_rec.attribute_category, l_trohdr_rec.attribute_category)

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)

Line 1241: AND inv_globals.equal(p_trohdr_rec.created_by, l_trohdr_rec.created_by)

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)

Line 1242: AND inv_globals.equal(p_trohdr_rec.creation_date, l_trohdr_rec.creation_date)

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)

Line 1243: AND inv_globals.equal(p_trohdr_rec.date_required, l_trohdr_rec.date_required)

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)

Line 1244: AND inv_globals.equal(p_trohdr_rec.description, l_trohdr_rec.description)

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)

Line 1245: AND inv_globals.equal(p_trohdr_rec.from_subinventory_code, l_trohdr_rec.from_subinventory_code)

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)

Line 1246: AND inv_globals.equal(p_trohdr_rec.header_id, l_trohdr_rec.header_id)

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)

Line 1247: AND inv_globals.equal(p_trohdr_rec.header_status, l_trohdr_rec.header_status)

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)

Line 1248: AND inv_globals.equal(p_trohdr_rec.last_updated_by, l_trohdr_rec.last_updated_by)

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)

Line 1249: AND inv_globals.equal(p_trohdr_rec.last_update_date, l_trohdr_rec.last_update_date)

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)

Line 1250: AND inv_globals.equal(p_trohdr_rec.last_update_login, l_trohdr_rec.last_update_login)

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)

Line 1251: AND inv_globals.equal(p_trohdr_rec.organization_id, l_trohdr_rec.organization_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)
1255: AND inv_globals.equal(p_trohdr_rec.request_id, l_trohdr_rec.request_id)

Line 1252: AND inv_globals.equal(p_trohdr_rec.program_application_id, l_trohdr_rec.program_application_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)

Line 1253: AND inv_globals.equal(p_trohdr_rec.program_id, l_trohdr_rec.program_id)

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)

Line 1254: AND inv_globals.equal(p_trohdr_rec.program_update_date, l_trohdr_rec.program_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)
1258: AND inv_globals.equal(p_trohdr_rec.to_account_id, l_trohdr_rec.to_account_id)

Line 1255: AND inv_globals.equal(p_trohdr_rec.request_id, l_trohdr_rec.request_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)

Line 1256: AND inv_globals.equal(p_trohdr_rec.request_number, l_trohdr_rec.request_number)

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)

Line 1257: AND inv_globals.equal(p_trohdr_rec.status_date, l_trohdr_rec.status_date)

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)

Line 1258: AND inv_globals.equal(p_trohdr_rec.to_account_id, l_trohdr_rec.to_account_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)

Line 1259: AND inv_globals.equal(p_trohdr_rec.to_subinventory_code, l_trohdr_rec.to_subinventory_code)

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

Line 1260: AND inv_globals.equal(p_trohdr_rec.move_order_type, l_trohdr_rec.move_order_type)

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.

Line 1261: AND inv_globals.equal(p_trohdr_rec.transaction_type_id, l_trohdr_rec.transaction_type_id)

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:

Line 1262: AND inv_globals.equal(p_trohdr_rec.grouping_rule_id, l_trohdr_rec.grouping_rule_id)

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;

Line 1263: AND inv_globals.equal(p_trohdr_rec.ship_to_location_id, l_trohdr_rec.ship_to_location_id) THEN

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

Line 1316: -- NOT INV_GLOBALS.Equal(p_trohdr_rec.from_subinventory_code,

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

Line 1326: AND NOT inv_globals.equal(p_trohdr_rec.header_id, p_old_trohdr_rec.header_id) THEN

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

Line 1332: AND NOT inv_globals.equal(p_trohdr_rec.organization_id, p_old_trohdr_rec.organization_id) THEN

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

Line 1338: AND NOT inv_globals.equal(p_trohdr_rec.to_account_id, p_old_trohdr_rec.to_account_id) THEN

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

Line 1344: -- NOT INV_GLOBALS.Equal(p_trohdr_rec.to_subinventory_code,

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

Line 1354: AND NOT inv_globals.equal(p_trohdr_rec.move_order_type, p_old_trohdr_rec.move_order_type) THEN

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

Line 1360: NOT INV_GLOBALS.Equal(p_trohdr_rec.transaction_type_id,

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