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_TROHDR_UTIL

Line 1: PACKAGE BODY inv_trohdr_util AS

1: PACKAGE BODY inv_trohdr_util AS
2: /* $Header: INVUTRHB.pls 120.0 2005/05/25 06:23:59 appldev noship $ */
3:
4: -- Global constant holding the package name
5:

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

2: /* $Header: INVUTRHB.pls 120.0 2005/05/25 06:23:59 appldev noship $ */
3:
4: -- Global constant holding the package name
5:
6: g_pkg_name CONSTANT VARCHAR2(30) := 'INV_Trohdr_Util';
7:
8: -- Procedure Clear_Dependent_Attr
9:
10: PROCEDURE clear_dependent_attr(

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

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:
33: IF NOT inv_globals.equal(p_trohdr_rec.attribute10, p_old_trohdr_rec.attribute10) THEN
34: l_index := l_index + 1;

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

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:
38: IF NOT inv_globals.equal(p_trohdr_rec.attribute11, p_old_trohdr_rec.attribute11) THEN
39: l_index := l_index + 1;

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

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:
43: IF NOT inv_globals.equal(p_trohdr_rec.attribute12, p_old_trohdr_rec.attribute12) THEN
44: l_index := l_index + 1;

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

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:
48: IF NOT inv_globals.equal(p_trohdr_rec.attribute13, p_old_trohdr_rec.attribute13) THEN
49: l_index := l_index + 1;

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

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:
53: IF NOT inv_globals.equal(p_trohdr_rec.attribute14, p_old_trohdr_rec.attribute14) THEN
54: l_index := l_index + 1;

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

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:
58: IF NOT inv_globals.equal(p_trohdr_rec.attribute15, p_old_trohdr_rec.attribute15) THEN
59: l_index := l_index + 1;

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

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:
63: IF NOT inv_globals.equal(p_trohdr_rec.attribute2, p_old_trohdr_rec.attribute2) THEN
64: l_index := l_index + 1;

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

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:
68: IF NOT inv_globals.equal(p_trohdr_rec.attribute3, p_old_trohdr_rec.attribute3) THEN
69: l_index := l_index + 1;

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

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:
73: IF NOT inv_globals.equal(p_trohdr_rec.attribute4, p_old_trohdr_rec.attribute4) THEN
74: l_index := l_index + 1;

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

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:
78: IF NOT inv_globals.equal(p_trohdr_rec.attribute5, p_old_trohdr_rec.attribute5) THEN
79: l_index := l_index + 1;

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

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:
83: IF NOT inv_globals.equal(p_trohdr_rec.attribute6, p_old_trohdr_rec.attribute6) THEN
84: l_index := l_index + 1;

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

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:
88: IF NOT inv_globals.equal(p_trohdr_rec.attribute7, p_old_trohdr_rec.attribute7) THEN
89: l_index := l_index + 1;

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

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:
93: IF NOT inv_globals.equal(p_trohdr_rec.attribute8, p_old_trohdr_rec.attribute8) THEN
94: l_index := l_index + 1;

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

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:
98: IF NOT inv_globals.equal(p_trohdr_rec.attribute9, p_old_trohdr_rec.attribute9) THEN
99: l_index := l_index + 1;

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

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:
103: IF NOT inv_globals.equal(p_trohdr_rec.attribute_category, p_old_trohdr_rec.attribute_category) THEN
104: l_index := l_index + 1;

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

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:
108: IF NOT inv_globals.equal(p_trohdr_rec.created_by, p_old_trohdr_rec.created_by) THEN
109: l_index := l_index + 1;

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

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:
113: IF NOT inv_globals.equal(p_trohdr_rec.creation_date, p_old_trohdr_rec.creation_date) THEN
114: l_index := l_index + 1;

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

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:
118: IF NOT inv_globals.equal(p_trohdr_rec.date_required, p_old_trohdr_rec.date_required) THEN
119: l_index := l_index + 1;

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

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:
123: IF NOT inv_globals.equal(p_trohdr_rec.description, p_old_trohdr_rec.description) THEN
124: l_index := l_index + 1;

Line 125: l_src_attr_tbl(l_index) := inv_trohdr_util.g_description;

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

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

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:
133: IF NOT inv_globals.equal(p_trohdr_rec.header_id, p_old_trohdr_rec.header_id) THEN
134: l_index := l_index + 1;

Line 135: l_src_attr_tbl(l_index) := inv_trohdr_util.g_header;

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:
138: IF NOT inv_globals.equal(p_trohdr_rec.header_status, p_old_trohdr_rec.header_status) THEN
139: l_index := l_index + 1;

Line 140: l_src_attr_tbl(l_index) := inv_trohdr_util.g_header_status;

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

Line 145: l_src_attr_tbl(l_index) := inv_trohdr_util.g_last_updated_by;

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

Line 150: l_src_attr_tbl(l_index) := inv_trohdr_util.g_last_update_date;

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

Line 155: l_src_attr_tbl(l_index) := inv_trohdr_util.g_last_update_login;

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:
158: IF NOT inv_globals.equal(p_trohdr_rec.organization_id, p_old_trohdr_rec.organization_id) THEN
159: l_index := l_index + 1;

Line 160: l_src_attr_tbl(l_index) := inv_trohdr_util.g_organization;

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

Line 165: l_src_attr_tbl(l_index) := inv_trohdr_util.g_program_application;

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:
168: IF NOT inv_globals.equal(p_trohdr_rec.program_id, p_old_trohdr_rec.program_id) THEN
169: l_index := l_index + 1;

Line 170: l_src_attr_tbl(l_index) := inv_trohdr_util.g_program;

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

Line 175: l_src_attr_tbl(l_index) := inv_trohdr_util.g_program_update_date;

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:
178: IF NOT inv_globals.equal(p_trohdr_rec.request_id, p_old_trohdr_rec.request_id) THEN
179: l_index := l_index + 1;

Line 180: l_src_attr_tbl(l_index) := inv_trohdr_util.g_request;

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:
183: IF NOT inv_globals.equal(p_trohdr_rec.request_number, p_old_trohdr_rec.request_number) THEN
184: l_index := l_index + 1;

Line 185: l_src_attr_tbl(l_index) := inv_trohdr_util.g_request_number;

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:
188: IF NOT inv_globals.equal(p_trohdr_rec.status_date, p_old_trohdr_rec.status_date) THEN
189: l_index := l_index + 1;

Line 190: l_src_attr_tbl(l_index) := inv_trohdr_util.g_status_date;

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

Line 195: l_src_attr_tbl(l_index) := inv_trohdr_util.g_to_account;

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

Line 200: l_src_attr_tbl(l_index) := inv_trohdr_util.g_to_subinventory;

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

Line 205: l_src_attr_tbl(l_index) := inv_trohdr_util.g_move_order_type;

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

Line 210: l_src_attr_tbl(l_index) := inv_trohdr_util.g_transaction_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:
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;

Line 215: l_src_attr_tbl(l_index) := inv_trohdr_util.g_ship_to_location_id;

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
218: l_index := l_index + 1;
219: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute1;

Line 219: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute1;

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
218: l_index := l_index + 1;
219: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute1;
220: ELSIF p_attr_id = g_attribute10 THEN
221: l_index := l_index + 1;
222: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute10;
223: ELSIF p_attr_id = g_attribute11 THEN

Line 222: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute10;

218: l_index := l_index + 1;
219: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute1;
220: ELSIF p_attr_id = g_attribute10 THEN
221: l_index := l_index + 1;
222: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute10;
223: ELSIF p_attr_id = g_attribute11 THEN
224: l_index := l_index + 1;
225: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute11;
226: ELSIF p_attr_id = g_attribute12 THEN

Line 225: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute11;

221: l_index := l_index + 1;
222: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute10;
223: ELSIF p_attr_id = g_attribute11 THEN
224: l_index := l_index + 1;
225: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute11;
226: ELSIF p_attr_id = g_attribute12 THEN
227: l_index := l_index + 1;
228: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute12;
229: ELSIF p_attr_id = g_attribute13 THEN

Line 228: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute12;

224: l_index := l_index + 1;
225: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute11;
226: ELSIF p_attr_id = g_attribute12 THEN
227: l_index := l_index + 1;
228: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute12;
229: ELSIF p_attr_id = g_attribute13 THEN
230: l_index := l_index + 1;
231: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute13;
232: ELSIF p_attr_id = g_attribute14 THEN

Line 231: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute13;

227: l_index := l_index + 1;
228: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute12;
229: ELSIF p_attr_id = g_attribute13 THEN
230: l_index := l_index + 1;
231: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute13;
232: ELSIF p_attr_id = g_attribute14 THEN
233: l_index := l_index + 1;
234: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute14;
235: ELSIF p_attr_id = g_attribute15 THEN

Line 234: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute14;

230: l_index := l_index + 1;
231: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute13;
232: ELSIF p_attr_id = g_attribute14 THEN
233: l_index := l_index + 1;
234: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute14;
235: ELSIF p_attr_id = g_attribute15 THEN
236: l_index := l_index + 1;
237: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute15;
238: ELSIF p_attr_id = g_attribute2 THEN

Line 237: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute15;

233: l_index := l_index + 1;
234: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute14;
235: ELSIF p_attr_id = g_attribute15 THEN
236: l_index := l_index + 1;
237: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute15;
238: ELSIF p_attr_id = g_attribute2 THEN
239: l_index := l_index + 1;
240: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute2;
241: ELSIF p_attr_id = g_attribute3 THEN

Line 240: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute2;

236: l_index := l_index + 1;
237: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute15;
238: ELSIF p_attr_id = g_attribute2 THEN
239: l_index := l_index + 1;
240: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute2;
241: ELSIF p_attr_id = g_attribute3 THEN
242: l_index := l_index + 1;
243: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute3;
244: ELSIF p_attr_id = g_attribute4 THEN

Line 243: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute3;

239: l_index := l_index + 1;
240: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute2;
241: ELSIF p_attr_id = g_attribute3 THEN
242: l_index := l_index + 1;
243: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute3;
244: ELSIF p_attr_id = g_attribute4 THEN
245: l_index := l_index + 1;
246: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute4;
247: ELSIF p_attr_id = g_attribute5 THEN

Line 246: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute4;

242: l_index := l_index + 1;
243: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute3;
244: ELSIF p_attr_id = g_attribute4 THEN
245: l_index := l_index + 1;
246: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute4;
247: ELSIF p_attr_id = g_attribute5 THEN
248: l_index := l_index + 1;
249: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute5;
250: ELSIF p_attr_id = g_attribute6 THEN

Line 249: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute5;

245: l_index := l_index + 1;
246: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute4;
247: ELSIF p_attr_id = g_attribute5 THEN
248: l_index := l_index + 1;
249: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute5;
250: ELSIF p_attr_id = g_attribute6 THEN
251: l_index := l_index + 1;
252: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute6;
253: ELSIF p_attr_id = g_attribute7 THEN

Line 252: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute6;

248: l_index := l_index + 1;
249: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute5;
250: ELSIF p_attr_id = g_attribute6 THEN
251: l_index := l_index + 1;
252: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute6;
253: ELSIF p_attr_id = g_attribute7 THEN
254: l_index := l_index + 1;
255: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute7;
256: ELSIF p_attr_id = g_attribute8 THEN

Line 255: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute7;

251: l_index := l_index + 1;
252: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute6;
253: ELSIF p_attr_id = g_attribute7 THEN
254: l_index := l_index + 1;
255: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute7;
256: ELSIF p_attr_id = g_attribute8 THEN
257: l_index := l_index + 1;
258: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute8;
259: ELSIF p_attr_id = g_attribute9 THEN

Line 258: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute8;

254: l_index := l_index + 1;
255: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute7;
256: ELSIF p_attr_id = g_attribute8 THEN
257: l_index := l_index + 1;
258: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute8;
259: ELSIF p_attr_id = g_attribute9 THEN
260: l_index := l_index + 1;
261: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute9;
262: ELSIF p_attr_id = g_attribute_category THEN

Line 261: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute9;

257: l_index := l_index + 1;
258: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute8;
259: ELSIF p_attr_id = g_attribute9 THEN
260: l_index := l_index + 1;
261: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute9;
262: ELSIF p_attr_id = g_attribute_category THEN
263: l_index := l_index + 1;
264: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute_category;
265: ELSIF p_attr_id = g_created_by THEN

Line 264: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute_category;

260: l_index := l_index + 1;
261: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute9;
262: ELSIF p_attr_id = g_attribute_category THEN
263: l_index := l_index + 1;
264: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute_category;
265: ELSIF p_attr_id = g_created_by THEN
266: l_index := l_index + 1;
267: l_src_attr_tbl(l_index) := inv_trohdr_util.g_created_by;
268: ELSIF p_attr_id = g_creation_date THEN

Line 267: l_src_attr_tbl(l_index) := inv_trohdr_util.g_created_by;

263: l_index := l_index + 1;
264: l_src_attr_tbl(l_index) := inv_trohdr_util.g_attribute_category;
265: ELSIF p_attr_id = g_created_by THEN
266: l_index := l_index + 1;
267: l_src_attr_tbl(l_index) := inv_trohdr_util.g_created_by;
268: ELSIF p_attr_id = g_creation_date THEN
269: l_index := l_index + 1;
270: l_src_attr_tbl(l_index) := inv_trohdr_util.g_creation_date;
271: ELSIF p_attr_id = g_date_required THEN

Line 270: l_src_attr_tbl(l_index) := inv_trohdr_util.g_creation_date;

266: l_index := l_index + 1;
267: l_src_attr_tbl(l_index) := inv_trohdr_util.g_created_by;
268: ELSIF p_attr_id = g_creation_date THEN
269: l_index := l_index + 1;
270: l_src_attr_tbl(l_index) := inv_trohdr_util.g_creation_date;
271: ELSIF p_attr_id = g_date_required THEN
272: l_index := l_index + 1;
273: l_src_attr_tbl(l_index) := inv_trohdr_util.g_date_required;
274: ELSIF p_attr_id = g_description THEN

Line 273: l_src_attr_tbl(l_index) := inv_trohdr_util.g_date_required;

269: l_index := l_index + 1;
270: l_src_attr_tbl(l_index) := inv_trohdr_util.g_creation_date;
271: ELSIF p_attr_id = g_date_required THEN
272: l_index := l_index + 1;
273: l_src_attr_tbl(l_index) := inv_trohdr_util.g_date_required;
274: ELSIF p_attr_id = g_description THEN
275: l_index := l_index + 1;
276: l_src_attr_tbl(l_index) := inv_trohdr_util.g_description;
277: ELSIF p_attr_id = g_from_subinventory THEN

Line 276: l_src_attr_tbl(l_index) := inv_trohdr_util.g_description;

272: l_index := l_index + 1;
273: l_src_attr_tbl(l_index) := inv_trohdr_util.g_date_required;
274: ELSIF p_attr_id = g_description THEN
275: l_index := l_index + 1;
276: l_src_attr_tbl(l_index) := inv_trohdr_util.g_description;
277: ELSIF p_attr_id = g_from_subinventory THEN
278: l_index := l_index + 1;
279: l_src_attr_tbl(l_index) := inv_trohdr_util.g_from_subinventory;
280: ELSIF p_attr_id = g_header THEN

Line 279: l_src_attr_tbl(l_index) := inv_trohdr_util.g_from_subinventory;

275: l_index := l_index + 1;
276: l_src_attr_tbl(l_index) := inv_trohdr_util.g_description;
277: ELSIF p_attr_id = g_from_subinventory THEN
278: l_index := l_index + 1;
279: l_src_attr_tbl(l_index) := inv_trohdr_util.g_from_subinventory;
280: ELSIF p_attr_id = g_header THEN
281: l_index := l_index + 1;
282: l_src_attr_tbl(l_index) := inv_trohdr_util.g_header;
283: ELSIF p_attr_id = g_header_status THEN

Line 282: l_src_attr_tbl(l_index) := inv_trohdr_util.g_header;

278: l_index := l_index + 1;
279: l_src_attr_tbl(l_index) := inv_trohdr_util.g_from_subinventory;
280: ELSIF p_attr_id = g_header THEN
281: l_index := l_index + 1;
282: l_src_attr_tbl(l_index) := inv_trohdr_util.g_header;
283: ELSIF p_attr_id = g_header_status THEN
284: l_index := l_index + 1;
285: l_src_attr_tbl(l_index) := inv_trohdr_util.g_header_status;
286: ELSIF p_attr_id = g_last_updated_by THEN

Line 285: l_src_attr_tbl(l_index) := inv_trohdr_util.g_header_status;

281: l_index := l_index + 1;
282: l_src_attr_tbl(l_index) := inv_trohdr_util.g_header;
283: ELSIF p_attr_id = g_header_status THEN
284: l_index := l_index + 1;
285: l_src_attr_tbl(l_index) := inv_trohdr_util.g_header_status;
286: ELSIF p_attr_id = g_last_updated_by THEN
287: l_index := l_index + 1;
288: l_src_attr_tbl(l_index) := inv_trohdr_util.g_last_updated_by;
289: ELSIF p_attr_id = g_last_update_date THEN

Line 288: l_src_attr_tbl(l_index) := inv_trohdr_util.g_last_updated_by;

284: l_index := l_index + 1;
285: l_src_attr_tbl(l_index) := inv_trohdr_util.g_header_status;
286: ELSIF p_attr_id = g_last_updated_by THEN
287: l_index := l_index + 1;
288: l_src_attr_tbl(l_index) := inv_trohdr_util.g_last_updated_by;
289: ELSIF p_attr_id = g_last_update_date THEN
290: l_index := l_index + 1;
291: l_src_attr_tbl(l_index) := inv_trohdr_util.g_last_update_date;
292: ELSIF p_attr_id = g_last_update_login THEN

Line 291: l_src_attr_tbl(l_index) := inv_trohdr_util.g_last_update_date;

287: l_index := l_index + 1;
288: l_src_attr_tbl(l_index) := inv_trohdr_util.g_last_updated_by;
289: ELSIF p_attr_id = g_last_update_date THEN
290: l_index := l_index + 1;
291: l_src_attr_tbl(l_index) := inv_trohdr_util.g_last_update_date;
292: ELSIF p_attr_id = g_last_update_login THEN
293: l_index := l_index + 1;
294: l_src_attr_tbl(l_index) := inv_trohdr_util.g_last_update_login;
295: ELSIF p_attr_id = g_organization THEN

Line 294: l_src_attr_tbl(l_index) := inv_trohdr_util.g_last_update_login;

290: l_index := l_index + 1;
291: l_src_attr_tbl(l_index) := inv_trohdr_util.g_last_update_date;
292: ELSIF p_attr_id = g_last_update_login THEN
293: l_index := l_index + 1;
294: l_src_attr_tbl(l_index) := inv_trohdr_util.g_last_update_login;
295: ELSIF p_attr_id = g_organization THEN
296: l_index := l_index + 1;
297: l_src_attr_tbl(l_index) := inv_trohdr_util.g_organization;
298: ELSIF p_attr_id = g_program_application THEN

Line 297: l_src_attr_tbl(l_index) := inv_trohdr_util.g_organization;

293: l_index := l_index + 1;
294: l_src_attr_tbl(l_index) := inv_trohdr_util.g_last_update_login;
295: ELSIF p_attr_id = g_organization THEN
296: l_index := l_index + 1;
297: l_src_attr_tbl(l_index) := inv_trohdr_util.g_organization;
298: ELSIF p_attr_id = g_program_application THEN
299: l_index := l_index + 1;
300: l_src_attr_tbl(l_index) := inv_trohdr_util.g_program_application;
301: ELSIF p_attr_id = g_program THEN

Line 300: l_src_attr_tbl(l_index) := inv_trohdr_util.g_program_application;

296: l_index := l_index + 1;
297: l_src_attr_tbl(l_index) := inv_trohdr_util.g_organization;
298: ELSIF p_attr_id = g_program_application THEN
299: l_index := l_index + 1;
300: l_src_attr_tbl(l_index) := inv_trohdr_util.g_program_application;
301: ELSIF p_attr_id = g_program THEN
302: l_index := l_index + 1;
303: l_src_attr_tbl(l_index) := inv_trohdr_util.g_program;
304: ELSIF p_attr_id = g_program_update_date THEN

Line 303: l_src_attr_tbl(l_index) := inv_trohdr_util.g_program;

299: l_index := l_index + 1;
300: l_src_attr_tbl(l_index) := inv_trohdr_util.g_program_application;
301: ELSIF p_attr_id = g_program THEN
302: l_index := l_index + 1;
303: l_src_attr_tbl(l_index) := inv_trohdr_util.g_program;
304: ELSIF p_attr_id = g_program_update_date THEN
305: l_index := l_index + 1;
306: l_src_attr_tbl(l_index) := inv_trohdr_util.g_program_update_date;
307: ELSIF p_attr_id = g_request THEN

Line 306: l_src_attr_tbl(l_index) := inv_trohdr_util.g_program_update_date;

302: l_index := l_index + 1;
303: l_src_attr_tbl(l_index) := inv_trohdr_util.g_program;
304: ELSIF p_attr_id = g_program_update_date THEN
305: l_index := l_index + 1;
306: l_src_attr_tbl(l_index) := inv_trohdr_util.g_program_update_date;
307: ELSIF p_attr_id = g_request THEN
308: l_index := l_index + 1;
309: l_src_attr_tbl(l_index) := inv_trohdr_util.g_request;
310: ELSIF p_attr_id = g_request_number THEN

Line 309: l_src_attr_tbl(l_index) := inv_trohdr_util.g_request;

305: l_index := l_index + 1;
306: l_src_attr_tbl(l_index) := inv_trohdr_util.g_program_update_date;
307: ELSIF p_attr_id = g_request THEN
308: l_index := l_index + 1;
309: l_src_attr_tbl(l_index) := inv_trohdr_util.g_request;
310: ELSIF p_attr_id = g_request_number THEN
311: l_index := l_index + 1;
312: l_src_attr_tbl(l_index) := inv_trohdr_util.g_request_number;
313: ELSIF p_attr_id = g_status_date THEN

Line 312: l_src_attr_tbl(l_index) := inv_trohdr_util.g_request_number;

308: l_index := l_index + 1;
309: l_src_attr_tbl(l_index) := inv_trohdr_util.g_request;
310: ELSIF p_attr_id = g_request_number THEN
311: l_index := l_index + 1;
312: l_src_attr_tbl(l_index) := inv_trohdr_util.g_request_number;
313: ELSIF p_attr_id = g_status_date THEN
314: l_index := l_index + 1;
315: l_src_attr_tbl(l_index) := inv_trohdr_util.g_status_date;
316: ELSIF p_attr_id = g_to_account THEN

Line 315: l_src_attr_tbl(l_index) := inv_trohdr_util.g_status_date;

311: l_index := l_index + 1;
312: l_src_attr_tbl(l_index) := inv_trohdr_util.g_request_number;
313: ELSIF p_attr_id = g_status_date THEN
314: l_index := l_index + 1;
315: l_src_attr_tbl(l_index) := inv_trohdr_util.g_status_date;
316: ELSIF p_attr_id = g_to_account THEN
317: l_index := l_index + 1;
318: l_src_attr_tbl(l_index) := inv_trohdr_util.g_to_account;
319: ELSIF p_attr_id = g_to_subinventory THEN

Line 318: l_src_attr_tbl(l_index) := inv_trohdr_util.g_to_account;

314: l_index := l_index + 1;
315: l_src_attr_tbl(l_index) := inv_trohdr_util.g_status_date;
316: ELSIF p_attr_id = g_to_account THEN
317: l_index := l_index + 1;
318: l_src_attr_tbl(l_index) := inv_trohdr_util.g_to_account;
319: ELSIF p_attr_id = g_to_subinventory THEN
320: l_index := l_index + 1;
321: l_src_attr_tbl(l_index) := inv_trohdr_util.g_to_subinventory;
322: ELSIF p_attr_id = g_move_order_type THEN

Line 321: l_src_attr_tbl(l_index) := inv_trohdr_util.g_to_subinventory;

317: l_index := l_index + 1;
318: l_src_attr_tbl(l_index) := inv_trohdr_util.g_to_account;
319: ELSIF p_attr_id = g_to_subinventory THEN
320: l_index := l_index + 1;
321: l_src_attr_tbl(l_index) := inv_trohdr_util.g_to_subinventory;
322: ELSIF p_attr_id = g_move_order_type THEN
323: l_index := l_index + 1;
324: l_src_attr_tbl(l_index) := inv_trohdr_util.g_move_order_type;
325: ELSIF p_attr_id = g_transaction_type THEN

Line 324: l_src_attr_tbl(l_index) := inv_trohdr_util.g_move_order_type;

320: l_index := l_index + 1;
321: l_src_attr_tbl(l_index) := inv_trohdr_util.g_to_subinventory;
322: ELSIF p_attr_id = g_move_order_type THEN
323: l_index := l_index + 1;
324: l_src_attr_tbl(l_index) := inv_trohdr_util.g_move_order_type;
325: ELSIF p_attr_id = g_transaction_type THEN
326: l_index := l_index + 1;
327: l_src_attr_tbl(l_index) := inv_trohdr_util.g_transaction_type;
328: ELSIF p_attr_id = g_ship_to_location_id THEN

Line 327: l_src_attr_tbl(l_index) := inv_trohdr_util.g_transaction_type;

323: l_index := l_index + 1;
324: l_src_attr_tbl(l_index) := inv_trohdr_util.g_move_order_type;
325: ELSIF p_attr_id = g_transaction_type THEN
326: l_index := l_index + 1;
327: l_src_attr_tbl(l_index) := inv_trohdr_util.g_transaction_type;
328: ELSIF p_attr_id = g_ship_to_location_id THEN
329: l_index := l_index + 1;
330: l_src_attr_tbl(l_index) := inv_trohdr_util.g_ship_to_location_id;
331: END IF;

Line 330: l_src_attr_tbl(l_index) := inv_trohdr_util.g_ship_to_location_id;

326: l_index := l_index + 1;
327: l_src_attr_tbl(l_index) := inv_trohdr_util.g_transaction_type;
328: ELSIF p_attr_id = g_ship_to_location_id THEN
329: l_index := l_index + 1;
330: l_src_attr_tbl(l_index) := inv_trohdr_util.g_ship_to_location_id;
331: END IF;
332: END clear_dependent_attr;
333:
334: -- Procedure Apply_Attribute_Changes

Line 1023: l_trohdr_rec := inv_trohdr_util.query_row(p_header_id);

1019:
1020: PROCEDURE update_row_status(p_header_id IN NUMBER, p_status IN NUMBER) IS
1021: l_trohdr_rec inv_move_order_pub.trohdr_rec_type;
1022: BEGIN
1023: l_trohdr_rec := inv_trohdr_util.query_row(p_header_id);
1024: l_trohdr_rec.header_status := p_status;
1025: l_trohdr_rec.last_update_date := SYSDATE;
1026: l_trohdr_rec.last_updated_by := fnd_global.user_id;
1027: l_trohdr_rec.last_update_login := fnd_global.login_id;

Line 1028: inv_trohdr_util.update_row(l_trohdr_rec);

1024: l_trohdr_rec.header_status := p_status;
1025: l_trohdr_rec.last_update_date := SYSDATE;
1026: l_trohdr_rec.last_updated_by := fnd_global.user_id;
1027: l_trohdr_rec.last_update_login := fnd_global.login_id;
1028: inv_trohdr_util.update_row(l_trohdr_rec);
1029: EXCEPTION
1030: WHEN OTHERS THEN
1031: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1032: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Update_Row_Status');

Line 1515: END inv_trohdr_util;

1511: END IF;
1512: */
1513: RETURN l_trohdr_rec;
1514: END get_ids;
1515: END inv_trohdr_util;