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_RESERVATION_UTIL_PVT dependencies on INV_RESERVATION_GLOBAL

Line 79: l_rec inv_reservation_global.item_record;

75: , x_index OUT NOCOPY NUMBER
76: ) IS
77: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
78: l_index NUMBER;
79: l_rec inv_reservation_global.item_record;
80: BEGIN
81: IF inv_reservation_global.g_item_record_cache.EXISTS(p_inventory_item_id) THEN
82: IF inv_reservation_global.g_item_record_cache(p_inventory_item_id).organization_id = p_organization_id THEN
83: l_index := p_inventory_item_id;

Line 81: IF inv_reservation_global.g_item_record_cache.EXISTS(p_inventory_item_id) THEN

77: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
78: l_index NUMBER;
79: l_rec inv_reservation_global.item_record;
80: BEGIN
81: IF inv_reservation_global.g_item_record_cache.EXISTS(p_inventory_item_id) THEN
82: IF inv_reservation_global.g_item_record_cache(p_inventory_item_id).organization_id = p_organization_id THEN
83: l_index := p_inventory_item_id;
84: END IF;
85: END IF;

Line 82: IF inv_reservation_global.g_item_record_cache(p_inventory_item_id).organization_id = p_organization_id THEN

78: l_index NUMBER;
79: l_rec inv_reservation_global.item_record;
80: BEGIN
81: IF inv_reservation_global.g_item_record_cache.EXISTS(p_inventory_item_id) THEN
82: IF inv_reservation_global.g_item_record_cache(p_inventory_item_id).organization_id = p_organization_id THEN
83: l_index := p_inventory_item_id;
84: END IF;
85: END IF;
86:

Line 88: IF inv_reservation_global.g_item_record_cache.count > 0 THEN

84: END IF;
85: END IF;
86:
87: /*
88: IF inv_reservation_global.g_item_record_cache.count > 0 THEN
89: l_index := inv_reservation_global.g_item_record_cache.first ;
90: LOOP
91: IF inv_reservation_global.g_item_record_cache
92: (l_index).inventory_item_id = p_inventory_item_id

Line 89: l_index := inv_reservation_global.g_item_record_cache.first ;

85: END IF;
86:
87: /*
88: IF inv_reservation_global.g_item_record_cache.count > 0 THEN
89: l_index := inv_reservation_global.g_item_record_cache.first ;
90: LOOP
91: IF inv_reservation_global.g_item_record_cache
92: (l_index).inventory_item_id = p_inventory_item_id
93: AND inv_reservation_global.g_item_record_cache

Line 91: IF inv_reservation_global.g_item_record_cache

87: /*
88: IF inv_reservation_global.g_item_record_cache.count > 0 THEN
89: l_index := inv_reservation_global.g_item_record_cache.first ;
90: LOOP
91: IF inv_reservation_global.g_item_record_cache
92: (l_index).inventory_item_id = p_inventory_item_id
93: AND inv_reservation_global.g_item_record_cache
94: (l_index).organization_id = p_organization_id THEN
95: EXIT;

Line 93: AND inv_reservation_global.g_item_record_cache

89: l_index := inv_reservation_global.g_item_record_cache.first ;
90: LOOP
91: IF inv_reservation_global.g_item_record_cache
92: (l_index).inventory_item_id = p_inventory_item_id
93: AND inv_reservation_global.g_item_record_cache
94: (l_index).organization_id = p_organization_id THEN
95: EXIT;
96: ELSE
97: IF l_index = inv_reservation_global.g_item_record_cache.last THEN

Line 97: IF l_index = inv_reservation_global.g_item_record_cache.last THEN

93: AND inv_reservation_global.g_item_record_cache
94: (l_index).organization_id = p_organization_id THEN
95: EXIT;
96: ELSE
97: IF l_index = inv_reservation_global.g_item_record_cache.last THEN
98: l_index := NULL;
99: EXIT;
100: END IF;
101: l_index :=

Line 102: inv_reservation_global.g_item_record_cache.next(l_index) ;

98: l_index := NULL;
99: EXIT;
100: END IF;
101: l_index :=
102: inv_reservation_global.g_item_record_cache.next(l_index) ;
103: END IF;
104: END LOOP;
105: END IF;
106: */

Line 128: , p_item_record IN inv_reservation_global.item_record

124:
125: PROCEDURE add_item_cache
126: (
127: x_return_status OUT NOCOPY VARCHAR2
128: , p_item_record IN inv_reservation_global.item_record
129: , x_index OUT NOCOPY NUMBER
130: ) IS
131: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
132: l_index NUMBER;

Line 134: --l_index := inv_reservation_global.g_item_record_cache.COUNT+1;

130: ) IS
131: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
132: l_index NUMBER;
133: BEGIN
134: --l_index := inv_reservation_global.g_item_record_cache.COUNT+1;
135: l_index := p_item_record.inventory_item_id;
136: inv_reservation_global.g_item_record_cache(l_index)
137: := p_item_record;
138:

Line 136: inv_reservation_global.g_item_record_cache(l_index)

132: l_index NUMBER;
133: BEGIN
134: --l_index := inv_reservation_global.g_item_record_cache.COUNT+1;
135: l_index := p_item_record.inventory_item_id;
136: inv_reservation_global.g_item_record_cache(l_index)
137: := p_item_record;
138:
139: x_index := l_index;
140: x_return_status := l_return_status;

Line 164: l_rec inv_reservation_global.organization_record;

160: , x_index OUT NOCOPY NUMBER
161: ) IS
162: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
163: l_index NUMBER;
164: l_rec inv_reservation_global.organization_record;
165: BEGIN
166: IF inv_reservation_global.g_organization_record_cache.EXISTS(p_organization_id) THEN
167: l_index := p_organization_id;
168: END IF;

Line 166: IF inv_reservation_global.g_organization_record_cache.EXISTS(p_organization_id) THEN

162: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
163: l_index NUMBER;
164: l_rec inv_reservation_global.organization_record;
165: BEGIN
166: IF inv_reservation_global.g_organization_record_cache.EXISTS(p_organization_id) THEN
167: l_index := p_organization_id;
168: END IF;
169:
170: /*

Line 171: IF inv_reservation_global.g_organization_record_cache.count > 0 THEN

167: l_index := p_organization_id;
168: END IF;
169:
170: /*
171: IF inv_reservation_global.g_organization_record_cache.count > 0 THEN
172: l_index := inv_reservation_global.g_organization_record_cache.first ;
173: LOOP
174: IF inv_reservation_global.g_organization_record_cache
175: (l_index).organization_id = p_organization_id THEN

Line 172: l_index := inv_reservation_global.g_organization_record_cache.first ;

168: END IF;
169:
170: /*
171: IF inv_reservation_global.g_organization_record_cache.count > 0 THEN
172: l_index := inv_reservation_global.g_organization_record_cache.first ;
173: LOOP
174: IF inv_reservation_global.g_organization_record_cache
175: (l_index).organization_id = p_organization_id THEN
176: EXIT;

Line 174: IF inv_reservation_global.g_organization_record_cache

170: /*
171: IF inv_reservation_global.g_organization_record_cache.count > 0 THEN
172: l_index := inv_reservation_global.g_organization_record_cache.first ;
173: LOOP
174: IF inv_reservation_global.g_organization_record_cache
175: (l_index).organization_id = p_organization_id THEN
176: EXIT;
177: ELSE
178: IF l_index =

Line 179: inv_reservation_global.g_organization_record_cache.last

175: (l_index).organization_id = p_organization_id THEN
176: EXIT;
177: ELSE
178: IF l_index =
179: inv_reservation_global.g_organization_record_cache.last
180: THEN
181: l_index := NULL;
182: EXIT;
183: END IF;

Line 185: inv_reservation_global.g_organization_record_cache.next(l_index) ;

181: l_index := NULL;
182: EXIT;
183: END IF;
184: l_index :=
185: inv_reservation_global.g_organization_record_cache.next(l_index) ;
186: END IF;
187: END LOOP;
188: END IF;
189: */

Line 211: , p_organization_record IN inv_reservation_global.organization_record

207:
208: PROCEDURE add_organization_cache
209: (
210: x_return_status OUT NOCOPY VARCHAR2
211: , p_organization_record IN inv_reservation_global.organization_record
212: , x_index OUT NOCOPY NUMBER
213: ) IS
214: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
215: l_index NUMBER;

Line 217: --l_index := inv_reservation_global.g_organization_record_cache.COUNT+1;

213: ) IS
214: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
215: l_index NUMBER;
216: BEGIN
217: --l_index := inv_reservation_global.g_organization_record_cache.COUNT+1;
218: l_index := p_organization_record.organization_id;
219: inv_reservation_global.g_organization_record_cache(l_index)
220: := p_organization_record;
221:

Line 219: inv_reservation_global.g_organization_record_cache(l_index)

215: l_index NUMBER;
216: BEGIN
217: --l_index := inv_reservation_global.g_organization_record_cache.COUNT+1;
218: l_index := p_organization_record.organization_id;
219: inv_reservation_global.g_organization_record_cache(l_index)
220: := p_organization_record;
221:
222: x_index := l_index;
223: x_return_status := l_return_status;

Line 250: l_rec inv_reservation_global.demand_record;

246: , x_index OUT NOCOPY NUMBER
247: ) IS
248: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
249: l_index NUMBER;
250: l_rec inv_reservation_global.demand_record;
251: BEGIN
252:
253: -- Bug 7717612, demand_source_line_id can exceed 2^31 if the max value of the sequence
254: -- is modified. In such case EXISTS on a plsql table throws NO_DATA_FOUND

Line 266: IF inv_reservation_global.g_demand_record_cache.EXISTS(MOD(p_demand_source_line_id,2147483648))THEN

262: -- is used as the index in which to store the demand info hence check that
263: -- position first. If it is null then use existing check
264:
265: IF p_demand_source_line_id IS NOT NULL THEN
266: IF inv_reservation_global.g_demand_record_cache.EXISTS(MOD(p_demand_source_line_id,2147483648))THEN
267: -- The orginal code allowed any value including demand_source_line_id to be null.
268: -- In the case where demand_source_line_id is null the demand record is place
269: -- in the first available slot in the table. Hence need to also check if record
270: -- returned is actual record required

Line 271: IF inv_reservation_global.g_demand_record_cache(MOD(p_demand_source_line_id,2147483648)).demand_source_line_id IS NOT NULL THEN

267: -- The orginal code allowed any value including demand_source_line_id to be null.
268: -- In the case where demand_source_line_id is null the demand record is place
269: -- in the first available slot in the table. Hence need to also check if record
270: -- returned is actual record required
271: IF inv_reservation_global.g_demand_record_cache(MOD(p_demand_source_line_id,2147483648)).demand_source_line_id IS NOT NULL THEN
272: l_index := MOD(p_demand_source_line_id,2147483648);
273: END IF;
274: END IF;
275: ELSE -- loop through all

Line 276: IF inv_reservation_global.g_demand_record_cache.count > 0 THEN

272: l_index := MOD(p_demand_source_line_id,2147483648);
273: END IF;
274: END IF;
275: ELSE -- loop through all
276: IF inv_reservation_global.g_demand_record_cache.count > 0 THEN
277: l_index := inv_reservation_global.g_demand_record_cache.first ;
278: LOOP
279: IF (inv_reservation_global.g_demand_record_cache
280: (l_index).demand_source_type_id IS NULL

Line 277: l_index := inv_reservation_global.g_demand_record_cache.first ;

273: END IF;
274: END IF;
275: ELSE -- loop through all
276: IF inv_reservation_global.g_demand_record_cache.count > 0 THEN
277: l_index := inv_reservation_global.g_demand_record_cache.first ;
278: LOOP
279: IF (inv_reservation_global.g_demand_record_cache
280: (l_index).demand_source_type_id IS NULL
281: AND p_demand_source_type_id IS NULL

Line 279: IF (inv_reservation_global.g_demand_record_cache

275: ELSE -- loop through all
276: IF inv_reservation_global.g_demand_record_cache.count > 0 THEN
277: l_index := inv_reservation_global.g_demand_record_cache.first ;
278: LOOP
279: IF (inv_reservation_global.g_demand_record_cache
280: (l_index).demand_source_type_id IS NULL
281: AND p_demand_source_type_id IS NULL
282: OR inv_reservation_global.g_demand_record_cache
283: (l_index).demand_source_type_id = p_demand_source_type_id)

Line 282: OR inv_reservation_global.g_demand_record_cache

278: LOOP
279: IF (inv_reservation_global.g_demand_record_cache
280: (l_index).demand_source_type_id IS NULL
281: AND p_demand_source_type_id IS NULL
282: OR inv_reservation_global.g_demand_record_cache
283: (l_index).demand_source_type_id = p_demand_source_type_id)
284: AND (inv_reservation_global.g_demand_record_cache
285: (l_index).demand_source_header_id IS NULL
286: AND p_demand_source_header_id IS NULL

Line 284: AND (inv_reservation_global.g_demand_record_cache

280: (l_index).demand_source_type_id IS NULL
281: AND p_demand_source_type_id IS NULL
282: OR inv_reservation_global.g_demand_record_cache
283: (l_index).demand_source_type_id = p_demand_source_type_id)
284: AND (inv_reservation_global.g_demand_record_cache
285: (l_index).demand_source_header_id IS NULL
286: AND p_demand_source_header_id IS NULL
287: OR inv_reservation_global.g_demand_record_cache
288: (l_index).demand_source_header_id

Line 287: OR inv_reservation_global.g_demand_record_cache

283: (l_index).demand_source_type_id = p_demand_source_type_id)
284: AND (inv_reservation_global.g_demand_record_cache
285: (l_index).demand_source_header_id IS NULL
286: AND p_demand_source_header_id IS NULL
287: OR inv_reservation_global.g_demand_record_cache
288: (l_index).demand_source_header_id
289: = p_demand_source_header_id)
290: AND (inv_reservation_global.g_demand_record_cache
291: (l_index).demand_source_line_id IS NULL

Line 290: AND (inv_reservation_global.g_demand_record_cache

286: AND p_demand_source_header_id IS NULL
287: OR inv_reservation_global.g_demand_record_cache
288: (l_index).demand_source_header_id
289: = p_demand_source_header_id)
290: AND (inv_reservation_global.g_demand_record_cache
291: (l_index).demand_source_line_id IS NULL
292: AND p_demand_source_line_id IS NULL
293: OR inv_reservation_global.g_demand_record_cache
294: (l_index).demand_source_line_id = p_demand_source_line_id)

Line 293: OR inv_reservation_global.g_demand_record_cache

289: = p_demand_source_header_id)
290: AND (inv_reservation_global.g_demand_record_cache
291: (l_index).demand_source_line_id IS NULL
292: AND p_demand_source_line_id IS NULL
293: OR inv_reservation_global.g_demand_record_cache
294: (l_index).demand_source_line_id = p_demand_source_line_id)
295: AND (inv_reservation_global.g_demand_record_cache
296: (l_index).demand_source_name IS NULL
297: AND p_demand_source_name IS NULL

Line 295: AND (inv_reservation_global.g_demand_record_cache

291: (l_index).demand_source_line_id IS NULL
292: AND p_demand_source_line_id IS NULL
293: OR inv_reservation_global.g_demand_record_cache
294: (l_index).demand_source_line_id = p_demand_source_line_id)
295: AND (inv_reservation_global.g_demand_record_cache
296: (l_index).demand_source_name IS NULL
297: AND p_demand_source_name IS NULL
298: OR inv_reservation_global.g_demand_record_cache
299: (l_index).demand_source_name = p_demand_source_name)

Line 298: OR inv_reservation_global.g_demand_record_cache

294: (l_index).demand_source_line_id = p_demand_source_line_id)
295: AND (inv_reservation_global.g_demand_record_cache
296: (l_index).demand_source_name IS NULL
297: AND p_demand_source_name IS NULL
298: OR inv_reservation_global.g_demand_record_cache
299: (l_index).demand_source_name = p_demand_source_name)
300: THEN
301: EXIT;
302: ELSE

Line 304: inv_reservation_global.g_demand_record_cache.last THEN

300: THEN
301: EXIT;
302: ELSE
303: IF l_index =
304: inv_reservation_global.g_demand_record_cache.last THEN
305: l_index := NULL;
306: EXIT;
307: END IF;
308: l_index :=

Line 309: inv_reservation_global.g_demand_record_cache.next(l_index) ;

305: l_index := NULL;
306: EXIT;
307: END IF;
308: l_index :=
309: inv_reservation_global.g_demand_record_cache.next(l_index) ;
310: END IF;
311: END LOOP;
312: END IF;
313: END IF;

Line 335: , p_demand_record IN inv_reservation_global.demand_record

331:
332: PROCEDURE add_demand_cache
333: (
334: x_return_status OUT NOCOPY VARCHAR2
335: , p_demand_record IN inv_reservation_global.demand_record
336: , x_index OUT NOCOPY NUMBER
337: ) IS
338: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
339: l_index NUMBER;

Line 349: IF inv_reservation_global.g_demand_record_cache.EXISTS(g_next_demand_entry)

345: --#BUG7717612#
346: ELSE
347: -- need to check whether there is a collision and increment accordingly
348: LOOP
349: IF inv_reservation_global.g_demand_record_cache.EXISTS(g_next_demand_entry)
350: THEN g_next_demand_entry := g_next_demand_entry + 1;
351: ELSE
352: exit; --loop
353: END IF;

Line 355: --l_index := inv_reservation_global.g_demand_record_cache.COUNT+1;

351: ELSE
352: exit; --loop
353: END IF;
354: END LOOP;
355: --l_index := inv_reservation_global.g_demand_record_cache.COUNT+1;
356: l_index := g_next_demand_entry;
357: g_next_demand_entry := g_next_demand_entry + 1;
358: END IF;
359: inv_reservation_global.g_demand_record_cache(l_index)

Line 359: inv_reservation_global.g_demand_record_cache(l_index)

355: --l_index := inv_reservation_global.g_demand_record_cache.COUNT+1;
356: l_index := g_next_demand_entry;
357: g_next_demand_entry := g_next_demand_entry + 1;
358: END IF;
359: inv_reservation_global.g_demand_record_cache(l_index)
360: := p_demand_record;
361:
362: x_index := l_index;
363: x_return_status := l_return_status;

Line 390: l_rec inv_reservation_global.supply_record;

386: , x_index OUT NOCOPY NUMBER
387: ) IS
388: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
389: l_index NUMBER;
390: l_rec inv_reservation_global.supply_record;
391: BEGIN
392:
393: IF inv_reservation_global.g_supply_record_cache.count > 0 THEN
394: l_index := inv_reservation_global.g_supply_record_cache.first ;

Line 393: IF inv_reservation_global.g_supply_record_cache.count > 0 THEN

389: l_index NUMBER;
390: l_rec inv_reservation_global.supply_record;
391: BEGIN
392:
393: IF inv_reservation_global.g_supply_record_cache.count > 0 THEN
394: l_index := inv_reservation_global.g_supply_record_cache.first ;
395: LOOP
396: IF (inv_reservation_global.g_supply_record_cache
397: (l_index).supply_source_type_id IS NULL

Line 394: l_index := inv_reservation_global.g_supply_record_cache.first ;

390: l_rec inv_reservation_global.supply_record;
391: BEGIN
392:
393: IF inv_reservation_global.g_supply_record_cache.count > 0 THEN
394: l_index := inv_reservation_global.g_supply_record_cache.first ;
395: LOOP
396: IF (inv_reservation_global.g_supply_record_cache
397: (l_index).supply_source_type_id IS NULL
398: AND p_supply_source_type_id IS NULL

Line 396: IF (inv_reservation_global.g_supply_record_cache

392:
393: IF inv_reservation_global.g_supply_record_cache.count > 0 THEN
394: l_index := inv_reservation_global.g_supply_record_cache.first ;
395: LOOP
396: IF (inv_reservation_global.g_supply_record_cache
397: (l_index).supply_source_type_id IS NULL
398: AND p_supply_source_type_id IS NULL
399: OR inv_reservation_global.g_supply_record_cache
400: (l_index).supply_source_type_id = p_supply_source_type_id)

Line 399: OR inv_reservation_global.g_supply_record_cache

395: LOOP
396: IF (inv_reservation_global.g_supply_record_cache
397: (l_index).supply_source_type_id IS NULL
398: AND p_supply_source_type_id IS NULL
399: OR inv_reservation_global.g_supply_record_cache
400: (l_index).supply_source_type_id = p_supply_source_type_id)
401: AND (inv_reservation_global.g_supply_record_cache
402: (l_index).supply_source_header_id IS NULL
403: AND p_supply_source_header_id IS NULL

Line 401: AND (inv_reservation_global.g_supply_record_cache

397: (l_index).supply_source_type_id IS NULL
398: AND p_supply_source_type_id IS NULL
399: OR inv_reservation_global.g_supply_record_cache
400: (l_index).supply_source_type_id = p_supply_source_type_id)
401: AND (inv_reservation_global.g_supply_record_cache
402: (l_index).supply_source_header_id IS NULL
403: AND p_supply_source_header_id IS NULL
404: OR inv_reservation_global.g_supply_record_cache
405: (l_index).supply_source_header_id

Line 404: OR inv_reservation_global.g_supply_record_cache

400: (l_index).supply_source_type_id = p_supply_source_type_id)
401: AND (inv_reservation_global.g_supply_record_cache
402: (l_index).supply_source_header_id IS NULL
403: AND p_supply_source_header_id IS NULL
404: OR inv_reservation_global.g_supply_record_cache
405: (l_index).supply_source_header_id
406: = p_supply_source_header_id)
407: AND (inv_reservation_global.g_supply_record_cache
408: (l_index).supply_source_line_id IS NULL

Line 407: AND (inv_reservation_global.g_supply_record_cache

403: AND p_supply_source_header_id IS NULL
404: OR inv_reservation_global.g_supply_record_cache
405: (l_index).supply_source_header_id
406: = p_supply_source_header_id)
407: AND (inv_reservation_global.g_supply_record_cache
408: (l_index).supply_source_line_id IS NULL
409: AND p_supply_source_line_id IS NULL
410: OR inv_reservation_global.g_supply_record_cache
411: (l_index).supply_source_line_id = p_supply_source_line_id)

Line 410: OR inv_reservation_global.g_supply_record_cache

406: = p_supply_source_header_id)
407: AND (inv_reservation_global.g_supply_record_cache
408: (l_index).supply_source_line_id IS NULL
409: AND p_supply_source_line_id IS NULL
410: OR inv_reservation_global.g_supply_record_cache
411: (l_index).supply_source_line_id = p_supply_source_line_id)
412: AND (inv_reservation_global.g_supply_record_cache
413: (l_index).supply_source_name IS NULL
414: AND p_supply_source_name IS NULL

Line 412: AND (inv_reservation_global.g_supply_record_cache

408: (l_index).supply_source_line_id IS NULL
409: AND p_supply_source_line_id IS NULL
410: OR inv_reservation_global.g_supply_record_cache
411: (l_index).supply_source_line_id = p_supply_source_line_id)
412: AND (inv_reservation_global.g_supply_record_cache
413: (l_index).supply_source_name IS NULL
414: AND p_supply_source_name IS NULL
415: OR inv_reservation_global.g_supply_record_cache
416: (l_index).supply_source_name = p_supply_source_name)

Line 415: OR inv_reservation_global.g_supply_record_cache

411: (l_index).supply_source_line_id = p_supply_source_line_id)
412: AND (inv_reservation_global.g_supply_record_cache
413: (l_index).supply_source_name IS NULL
414: AND p_supply_source_name IS NULL
415: OR inv_reservation_global.g_supply_record_cache
416: (l_index).supply_source_name = p_supply_source_name)
417: THEN
418: EXIT;
419: ELSE

Line 421: = inv_reservation_global.g_supply_record_cache.last THEN

417: THEN
418: EXIT;
419: ELSE
420: IF l_index
421: = inv_reservation_global.g_supply_record_cache.last THEN
422: l_index := NULL;
423: EXIT;
424: END IF;
425: l_index :=

Line 426: inv_reservation_global.g_supply_record_cache.next(l_index) ;

422: l_index := NULL;
423: EXIT;
424: END IF;
425: l_index :=
426: inv_reservation_global.g_supply_record_cache.next(l_index) ;
427: END IF;
428: END LOOP;
429: END IF;
430:

Line 451: , p_supply_record IN inv_reservation_global.supply_record

447:
448: PROCEDURE add_supply_cache
449: (
450: x_return_status OUT NOCOPY VARCHAR2
451: , p_supply_record IN inv_reservation_global.supply_record
452: , x_index OUT NOCOPY NUMBER
453: ) IS
454: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
455: l_index NUMBER;

Line 457: l_index := inv_reservation_global.g_supply_record_cache.COUNT+1;

453: ) IS
454: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
455: l_index NUMBER;
456: BEGIN
457: l_index := inv_reservation_global.g_supply_record_cache.COUNT+1;
458: inv_reservation_global.g_supply_record_cache(l_index)
459: := p_supply_record;
460:
461: x_index := l_index;

Line 458: inv_reservation_global.g_supply_record_cache(l_index)

454: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
455: l_index NUMBER;
456: BEGIN
457: l_index := inv_reservation_global.g_supply_record_cache.COUNT+1;
458: inv_reservation_global.g_supply_record_cache(l_index)
459: := p_supply_record;
460:
461: x_index := l_index;
462: x_return_status := l_return_status;

Line 491: IF inv_reservation_global.g_sub_record_cache.count > 0 THEN

487: BEGIN
488: -- Modified for common API. Secondary_inventory_name replaces
489: -- subinventory_code
490:
491: IF inv_reservation_global.g_sub_record_cache.count > 0 THEN
492: l_index := inv_reservation_global.g_sub_record_cache.first ;
493: LOOP
494: IF (inv_reservation_global.g_sub_record_cache
495: (l_index).secondary_inventory_name IS NULL

Line 492: l_index := inv_reservation_global.g_sub_record_cache.first ;

488: -- Modified for common API. Secondary_inventory_name replaces
489: -- subinventory_code
490:
491: IF inv_reservation_global.g_sub_record_cache.count > 0 THEN
492: l_index := inv_reservation_global.g_sub_record_cache.first ;
493: LOOP
494: IF (inv_reservation_global.g_sub_record_cache
495: (l_index).secondary_inventory_name IS NULL
496: AND p_subinventory_code IS NULL

Line 494: IF (inv_reservation_global.g_sub_record_cache

490:
491: IF inv_reservation_global.g_sub_record_cache.count > 0 THEN
492: l_index := inv_reservation_global.g_sub_record_cache.first ;
493: LOOP
494: IF (inv_reservation_global.g_sub_record_cache
495: (l_index).secondary_inventory_name IS NULL
496: AND p_subinventory_code IS NULL
497: OR inv_reservation_global.g_sub_record_cache
498: (l_index).secondary_inventory_name= p_subinventory_code)

Line 497: OR inv_reservation_global.g_sub_record_cache

493: LOOP
494: IF (inv_reservation_global.g_sub_record_cache
495: (l_index).secondary_inventory_name IS NULL
496: AND p_subinventory_code IS NULL
497: OR inv_reservation_global.g_sub_record_cache
498: (l_index).secondary_inventory_name= p_subinventory_code)
499: AND (inv_reservation_global.g_sub_record_cache
500: (l_index).organization_id IS NULL
501: AND p_organization_id IS NULL

Line 499: AND (inv_reservation_global.g_sub_record_cache

495: (l_index).secondary_inventory_name IS NULL
496: AND p_subinventory_code IS NULL
497: OR inv_reservation_global.g_sub_record_cache
498: (l_index).secondary_inventory_name= p_subinventory_code)
499: AND (inv_reservation_global.g_sub_record_cache
500: (l_index).organization_id IS NULL
501: AND p_organization_id IS NULL
502: OR inv_reservation_global.g_sub_record_cache
503: (l_index).organization_id = p_organization_id) THEN

Line 502: OR inv_reservation_global.g_sub_record_cache

498: (l_index).secondary_inventory_name= p_subinventory_code)
499: AND (inv_reservation_global.g_sub_record_cache
500: (l_index).organization_id IS NULL
501: AND p_organization_id IS NULL
502: OR inv_reservation_global.g_sub_record_cache
503: (l_index).organization_id = p_organization_id) THEN
504: EXIT;
505: ELSE
506: IF l_index = inv_reservation_global.g_sub_record_cache.last THEN

Line 506: IF l_index = inv_reservation_global.g_sub_record_cache.last THEN

502: OR inv_reservation_global.g_sub_record_cache
503: (l_index).organization_id = p_organization_id) THEN
504: EXIT;
505: ELSE
506: IF l_index = inv_reservation_global.g_sub_record_cache.last THEN
507: l_index := NULL;
508: EXIT;
509: END IF;
510: l_index :=

Line 511: inv_reservation_global.g_sub_record_cache.next(l_index) ;

507: l_index := NULL;
508: EXIT;
509: END IF;
510: l_index :=
511: inv_reservation_global.g_sub_record_cache.next(l_index) ;
512: END IF;
513: END LOOP;
514: END IF;
515:

Line 536: , p_sub_record IN inv_reservation_global.sub_record

532:
533: PROCEDURE add_sub_cache
534: (
535: x_return_status OUT NOCOPY VARCHAR2
536: , p_sub_record IN inv_reservation_global.sub_record
537: , x_index OUT NOCOPY NUMBER
538: ) IS
539: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
540: l_index NUMBER;

Line 542: l_index := inv_reservation_global.g_sub_record_cache.COUNT+1;

538: ) IS
539: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
540: l_index NUMBER;
541: BEGIN
542: l_index := inv_reservation_global.g_sub_record_cache.COUNT+1;
543: inv_reservation_global.g_sub_record_cache(l_index)
544: := p_sub_record;
545:
546: x_index := l_index;

Line 543: inv_reservation_global.g_sub_record_cache(l_index)

539: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
540: l_index NUMBER;
541: BEGIN
542: l_index := inv_reservation_global.g_sub_record_cache.COUNT+1;
543: inv_reservation_global.g_sub_record_cache(l_index)
544: := p_sub_record;
545:
546: x_index := l_index;
547: x_return_status := l_return_status;

Line 596: IF p_org_control = inv_reservation_global.g_locator_control_no THEN

592: l_value NUMBER;
593: l_locator_control NUMBER;
594: BEGIN
595:
596: IF p_org_control = inv_reservation_global.g_locator_control_no THEN
597: l_locator_control := inv_reservation_global.g_locator_control_no;
598: ELSIF p_org_control =
599: inv_reservation_global.g_locator_control_prespecified THEN
600: l_locator_control :=

Line 597: l_locator_control := inv_reservation_global.g_locator_control_no;

593: l_locator_control NUMBER;
594: BEGIN
595:
596: IF p_org_control = inv_reservation_global.g_locator_control_no THEN
597: l_locator_control := inv_reservation_global.g_locator_control_no;
598: ELSIF p_org_control =
599: inv_reservation_global.g_locator_control_prespecified THEN
600: l_locator_control :=
601: inv_reservation_global.g_locator_control_prespecified;

Line 599: inv_reservation_global.g_locator_control_prespecified THEN

595:
596: IF p_org_control = inv_reservation_global.g_locator_control_no THEN
597: l_locator_control := inv_reservation_global.g_locator_control_no;
598: ELSIF p_org_control =
599: inv_reservation_global.g_locator_control_prespecified THEN
600: l_locator_control :=
601: inv_reservation_global.g_locator_control_prespecified;
602: ELSIF p_org_control =
603: inv_reservation_global.g_locator_control_dynamic THEN

Line 601: inv_reservation_global.g_locator_control_prespecified;

597: l_locator_control := inv_reservation_global.g_locator_control_no;
598: ELSIF p_org_control =
599: inv_reservation_global.g_locator_control_prespecified THEN
600: l_locator_control :=
601: inv_reservation_global.g_locator_control_prespecified;
602: ELSIF p_org_control =
603: inv_reservation_global.g_locator_control_dynamic THEN
604: l_locator_control :=
605: inv_reservation_global.g_locator_control_prespecified;

Line 603: inv_reservation_global.g_locator_control_dynamic THEN

599: inv_reservation_global.g_locator_control_prespecified THEN
600: l_locator_control :=
601: inv_reservation_global.g_locator_control_prespecified;
602: ELSIF p_org_control =
603: inv_reservation_global.g_locator_control_dynamic THEN
604: l_locator_control :=
605: inv_reservation_global.g_locator_control_prespecified;
606: ELSIF p_org_control = inv_reservation_global.g_locator_control_by_sub THEN
607: IF p_sub_control = inv_reservation_global.g_locator_control_no THEN

Line 605: inv_reservation_global.g_locator_control_prespecified;

601: inv_reservation_global.g_locator_control_prespecified;
602: ELSIF p_org_control =
603: inv_reservation_global.g_locator_control_dynamic THEN
604: l_locator_control :=
605: inv_reservation_global.g_locator_control_prespecified;
606: ELSIF p_org_control = inv_reservation_global.g_locator_control_by_sub THEN
607: IF p_sub_control = inv_reservation_global.g_locator_control_no THEN
608: l_locator_control := inv_reservation_global.g_locator_control_no;
609: ELSIF p_sub_control =

Line 606: ELSIF p_org_control = inv_reservation_global.g_locator_control_by_sub THEN

602: ELSIF p_org_control =
603: inv_reservation_global.g_locator_control_dynamic THEN
604: l_locator_control :=
605: inv_reservation_global.g_locator_control_prespecified;
606: ELSIF p_org_control = inv_reservation_global.g_locator_control_by_sub THEN
607: IF p_sub_control = inv_reservation_global.g_locator_control_no THEN
608: l_locator_control := inv_reservation_global.g_locator_control_no;
609: ELSIF p_sub_control =
610: inv_reservation_global.g_locator_control_prespecified THEN

Line 607: IF p_sub_control = inv_reservation_global.g_locator_control_no THEN

603: inv_reservation_global.g_locator_control_dynamic THEN
604: l_locator_control :=
605: inv_reservation_global.g_locator_control_prespecified;
606: ELSIF p_org_control = inv_reservation_global.g_locator_control_by_sub THEN
607: IF p_sub_control = inv_reservation_global.g_locator_control_no THEN
608: l_locator_control := inv_reservation_global.g_locator_control_no;
609: ELSIF p_sub_control =
610: inv_reservation_global.g_locator_control_prespecified THEN
611: l_locator_control :=

Line 608: l_locator_control := inv_reservation_global.g_locator_control_no;

604: l_locator_control :=
605: inv_reservation_global.g_locator_control_prespecified;
606: ELSIF p_org_control = inv_reservation_global.g_locator_control_by_sub THEN
607: IF p_sub_control = inv_reservation_global.g_locator_control_no THEN
608: l_locator_control := inv_reservation_global.g_locator_control_no;
609: ELSIF p_sub_control =
610: inv_reservation_global.g_locator_control_prespecified THEN
611: l_locator_control :=
612: inv_reservation_global.g_locator_control_prespecified ;

Line 610: inv_reservation_global.g_locator_control_prespecified THEN

606: ELSIF p_org_control = inv_reservation_global.g_locator_control_by_sub THEN
607: IF p_sub_control = inv_reservation_global.g_locator_control_no THEN
608: l_locator_control := inv_reservation_global.g_locator_control_no;
609: ELSIF p_sub_control =
610: inv_reservation_global.g_locator_control_prespecified THEN
611: l_locator_control :=
612: inv_reservation_global.g_locator_control_prespecified ;
613: ELSIF p_sub_control =
614: inv_reservation_global.g_locator_control_dynamic THEN

Line 612: inv_reservation_global.g_locator_control_prespecified ;

608: l_locator_control := inv_reservation_global.g_locator_control_no;
609: ELSIF p_sub_control =
610: inv_reservation_global.g_locator_control_prespecified THEN
611: l_locator_control :=
612: inv_reservation_global.g_locator_control_prespecified ;
613: ELSIF p_sub_control =
614: inv_reservation_global.g_locator_control_dynamic THEN
615: l_locator_control :=
616: inv_reservation_global.g_locator_control_prespecified;

Line 614: inv_reservation_global.g_locator_control_dynamic THEN

610: inv_reservation_global.g_locator_control_prespecified THEN
611: l_locator_control :=
612: inv_reservation_global.g_locator_control_prespecified ;
613: ELSIF p_sub_control =
614: inv_reservation_global.g_locator_control_dynamic THEN
615: l_locator_control :=
616: inv_reservation_global.g_locator_control_prespecified;
617: ELSIF p_sub_control =
618: inv_reservation_global.g_locator_control_by_item THEN

Line 616: inv_reservation_global.g_locator_control_prespecified;

612: inv_reservation_global.g_locator_control_prespecified ;
613: ELSIF p_sub_control =
614: inv_reservation_global.g_locator_control_dynamic THEN
615: l_locator_control :=
616: inv_reservation_global.g_locator_control_prespecified;
617: ELSIF p_sub_control =
618: inv_reservation_global.g_locator_control_by_item THEN
619: IF p_item_control = inv_reservation_global.g_locator_control_no THEN
620: l_locator_control := inv_reservation_global.g_locator_control_no;

Line 618: inv_reservation_global.g_locator_control_by_item THEN

614: inv_reservation_global.g_locator_control_dynamic THEN
615: l_locator_control :=
616: inv_reservation_global.g_locator_control_prespecified;
617: ELSIF p_sub_control =
618: inv_reservation_global.g_locator_control_by_item THEN
619: IF p_item_control = inv_reservation_global.g_locator_control_no THEN
620: l_locator_control := inv_reservation_global.g_locator_control_no;
621: ELSIF p_item_control =
622: inv_reservation_global.g_locator_control_prespecified THEN

Line 619: IF p_item_control = inv_reservation_global.g_locator_control_no THEN

615: l_locator_control :=
616: inv_reservation_global.g_locator_control_prespecified;
617: ELSIF p_sub_control =
618: inv_reservation_global.g_locator_control_by_item THEN
619: IF p_item_control = inv_reservation_global.g_locator_control_no THEN
620: l_locator_control := inv_reservation_global.g_locator_control_no;
621: ELSIF p_item_control =
622: inv_reservation_global.g_locator_control_prespecified THEN
623: l_locator_control :=

Line 620: l_locator_control := inv_reservation_global.g_locator_control_no;

616: inv_reservation_global.g_locator_control_prespecified;
617: ELSIF p_sub_control =
618: inv_reservation_global.g_locator_control_by_item THEN
619: IF p_item_control = inv_reservation_global.g_locator_control_no THEN
620: l_locator_control := inv_reservation_global.g_locator_control_no;
621: ELSIF p_item_control =
622: inv_reservation_global.g_locator_control_prespecified THEN
623: l_locator_control :=
624: inv_reservation_global.g_locator_control_prespecified;

Line 622: inv_reservation_global.g_locator_control_prespecified THEN

618: inv_reservation_global.g_locator_control_by_item THEN
619: IF p_item_control = inv_reservation_global.g_locator_control_no THEN
620: l_locator_control := inv_reservation_global.g_locator_control_no;
621: ELSIF p_item_control =
622: inv_reservation_global.g_locator_control_prespecified THEN
623: l_locator_control :=
624: inv_reservation_global.g_locator_control_prespecified;
625: ELSIF p_item_control =
626: inv_reservation_global.g_locator_control_dynamic THEN

Line 624: inv_reservation_global.g_locator_control_prespecified;

620: l_locator_control := inv_reservation_global.g_locator_control_no;
621: ELSIF p_item_control =
622: inv_reservation_global.g_locator_control_prespecified THEN
623: l_locator_control :=
624: inv_reservation_global.g_locator_control_prespecified;
625: ELSIF p_item_control =
626: inv_reservation_global.g_locator_control_dynamic THEN
627: l_locator_control :=
628: inv_reservation_global.g_locator_control_prespecified;

Line 626: inv_reservation_global.g_locator_control_dynamic THEN

622: inv_reservation_global.g_locator_control_prespecified THEN
623: l_locator_control :=
624: inv_reservation_global.g_locator_control_prespecified;
625: ELSIF p_item_control =
626: inv_reservation_global.g_locator_control_dynamic THEN
627: l_locator_control :=
628: inv_reservation_global.g_locator_control_prespecified;
629: ELSIF p_item_control IS NULL THEN
630: l_locator_control := p_sub_control;

Line 628: inv_reservation_global.g_locator_control_prespecified;

624: inv_reservation_global.g_locator_control_prespecified;
625: ELSIF p_item_control =
626: inv_reservation_global.g_locator_control_dynamic THEN
627: l_locator_control :=
628: inv_reservation_global.g_locator_control_prespecified;
629: ELSIF p_item_control IS NULL THEN
630: l_locator_control := p_sub_control;
631: ELSE
632: l_value := p_item_control;

Line 667: IF (NOT inv_reservation_global.g_wip_record_cache.EXISTS(p_wip_entity_id)) THEN

663: l_wip_entity_type NUMBER;
664: l_wip_job_type VARCHAR2(15);
665: BEGIN
666:
667: IF (NOT inv_reservation_global.g_wip_record_cache.EXISTS(p_wip_entity_id)) THEN
668: -- call get_wip_entity API
669: inv_reservation_pvt.get_wip_entity_type
670: ( p_api_version_number => 1.0
671: , p_init_msg_lst => fnd_api.g_false

Line 691: inv_reservation_global.g_wip_record_cache(p_wip_entity_id).wip_entity_id

687: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
688: RAISE fnd_api.g_exc_unexpected_error;
689: END IF;
690:
691: inv_reservation_global.g_wip_record_cache(p_wip_entity_id).wip_entity_id
692: := p_wip_entity_id;
693:
694: inv_reservation_global.g_wip_record_cache(p_wip_entity_id).wip_entity_type
695: := l_wip_entity_type;

Line 694: inv_reservation_global.g_wip_record_cache(p_wip_entity_id).wip_entity_type

690:
691: inv_reservation_global.g_wip_record_cache(p_wip_entity_id).wip_entity_id
692: := p_wip_entity_id;
693:
694: inv_reservation_global.g_wip_record_cache(p_wip_entity_id).wip_entity_type
695: := l_wip_entity_type;
696:
697: inv_reservation_global.g_wip_record_cache(p_wip_entity_id).wip_entity_job
698: := l_wip_job_type;

Line 697: inv_reservation_global.g_wip_record_cache(p_wip_entity_id).wip_entity_job

693:
694: inv_reservation_global.g_wip_record_cache(p_wip_entity_id).wip_entity_type
695: := l_wip_entity_type;
696:
697: inv_reservation_global.g_wip_record_cache(p_wip_entity_id).wip_entity_job
698: := l_wip_job_type;
699: END IF;
700:
701: x_return_status := l_return_status;