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.GML_MLT_CNTR_RCPT dependencies on IC_LOTS_MST

Line 61: FROM ic_lots_mst

57: RETURN NUMBER IS
58:
59: CURSOR GET_LOT_MASTER IS
60: SELECT lot_id
61: FROM ic_lots_mst
62: WHERE item_id = p_f_item_id AND
63: lot_no = p_f_lot_no AND
64: sublot_no = p_f_sublot_no;
65:

Line 68: FROM ic_lots_mst

64: sublot_no = p_f_sublot_no;
65:
66: CURSOR GET_LOT_MASTER2 IS
67: SELECT lot_id
68: FROM ic_lots_mst
69: WHERE item_id = p_f_item_id AND
70: lot_no = p_f_lot_no;
71:
72: w_lot_id number := 0;

Line 167: l_ic_lots_mst_row ic_lots_mst%ROWTYPE;

163: l_sublot_no VARCHAR2(32) := NULL;
164: l_item_no VARCHAR2(100);
165: l_qc_grade VARCHAR2(100);
166:
167: l_ic_lots_mst_row ic_lots_mst%ROWTYPE;
168: l_ic_lots_cpg_row ic_lots_cpg%ROWTYPE;
169:
170: l_api_version NUMBER := GMIGUTL.api_version;
171: l_dummy_lot VARCHAR2(32);

Line 230: --x_found := 1; -- 1 means combination in ic_lots_mst exists

226: l_dummy_cnt := l_dummy_cnt + 1;
227: l_no_of_sublots := l_no_of_sublots -1;
228:
229: -- Check if this combination of Lot/Sublot already exists in the database
230: --x_found := 1; -- 1 means combination in ic_lots_mst exists
231: --WHILE (x_found = 1)
232: ---LOOP
233: gmi_autolot.generate_lot_number(
234: p_item_id => p_item_id,

Line 283: , x_ic_lots_mst_row => l_ic_lots_mst_row

279: , p_init_msg_list => FND_API.G_TRUE
280: , p_commit => FND_API.G_FALSE
281: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
282: , p_lot_rec =>lot_rec
283: , x_ic_lots_mst_row => l_ic_lots_mst_row
284: , x_ic_lots_cpg_row => l_ic_lots_cpg_row
285: , x_return_status => l_status
286: , x_msg_count => l_count
287: , x_msg_data => l_data

Line 304: l_ic_lots_mst_row.lot_no,

300:
301: IF p_lot_spec_conv = 'Y' THEN
302: PO_GML_DB_COMMON.CREATE_LOT_SPECIFIC_CONVERSION(
303: l_item_no,
304: l_ic_lots_mst_row.lot_no,
305: l_ic_lots_mst_row.sublot_no,
306: p_primary_uom,
307: p_secondary_uom,
308: p_secondary_qty/nvl(p_primary_qty,1),

Line 305: l_ic_lots_mst_row.sublot_no,

301: IF p_lot_spec_conv = 'Y' THEN
302: PO_GML_DB_COMMON.CREATE_LOT_SPECIFIC_CONVERSION(
303: l_item_no,
304: l_ic_lots_mst_row.lot_no,
305: l_ic_lots_mst_row.sublot_no,
306: p_primary_uom,
307: p_secondary_uom,
308: p_secondary_qty/nvl(p_primary_qty,1),
309: l_status,l_data);

Line 321: x_lot_table(l_dummy_cnt).lot_id := l_ic_lots_mst_row.lot_id;

317: raise e_lot_conv_err;
318: END IF;
319: END IF;/* IF p_lot_spec_conv = 'Y' */
320:
321: x_lot_table(l_dummy_cnt).lot_id := l_ic_lots_mst_row.lot_id;
322: x_lot_table(l_dummy_cnt).lot_no := l_ic_lots_mst_row.lot_no;
323: x_lot_table(l_dummy_cnt).sublot_no := l_ic_lots_mst_row.sublot_no;
324: x_lot_table(l_dummy_cnt).expire_date := l_ic_lots_mst_row.expire_date;
325:

Line 322: x_lot_table(l_dummy_cnt).lot_no := l_ic_lots_mst_row.lot_no;

318: END IF;
319: END IF;/* IF p_lot_spec_conv = 'Y' */
320:
321: x_lot_table(l_dummy_cnt).lot_id := l_ic_lots_mst_row.lot_id;
322: x_lot_table(l_dummy_cnt).lot_no := l_ic_lots_mst_row.lot_no;
323: x_lot_table(l_dummy_cnt).sublot_no := l_ic_lots_mst_row.sublot_no;
324: x_lot_table(l_dummy_cnt).expire_date := l_ic_lots_mst_row.expire_date;
325:
326: END LOOP;

Line 323: x_lot_table(l_dummy_cnt).sublot_no := l_ic_lots_mst_row.sublot_no;

319: END IF;/* IF p_lot_spec_conv = 'Y' */
320:
321: x_lot_table(l_dummy_cnt).lot_id := l_ic_lots_mst_row.lot_id;
322: x_lot_table(l_dummy_cnt).lot_no := l_ic_lots_mst_row.lot_no;
323: x_lot_table(l_dummy_cnt).sublot_no := l_ic_lots_mst_row.sublot_no;
324: x_lot_table(l_dummy_cnt).expire_date := l_ic_lots_mst_row.expire_date;
325:
326: END LOOP;
327: END IF; /*IF nvl(l_no_of_sublots,0) > 0 */

Line 324: x_lot_table(l_dummy_cnt).expire_date := l_ic_lots_mst_row.expire_date;

320:
321: x_lot_table(l_dummy_cnt).lot_id := l_ic_lots_mst_row.lot_id;
322: x_lot_table(l_dummy_cnt).lot_no := l_ic_lots_mst_row.lot_no;
323: x_lot_table(l_dummy_cnt).sublot_no := l_ic_lots_mst_row.sublot_no;
324: x_lot_table(l_dummy_cnt).expire_date := l_ic_lots_mst_row.expire_date;
325:
326: END LOOP;
327: END IF; /*IF nvl(l_no_of_sublots,0) > 0 */
328:

Line 341: --x_found := 1; -- 1 means ic_lots_mst exists

337: l_dummy_cnt := l_dummy_cnt + 1;
338:
339: l_no_of_lots :=l_no_of_lots -1;
340:
341: --x_found := 1; -- 1 means ic_lots_mst exists
342: --WHILE (x_found = 1)
343: --LOOP
344: gmi_autolot.generate_lot_number(
345: p_item_id => p_item_id,

Line 393: , x_ic_lots_mst_row => l_ic_lots_mst_row

389: , p_init_msg_list => FND_API.G_TRUE
390: , p_commit => FND_API.G_FALSE
391: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
392: , p_lot_rec =>lot_rec
393: , x_ic_lots_mst_row => l_ic_lots_mst_row
394: , x_ic_lots_cpg_row => l_ic_lots_cpg_row
395: , x_return_status => l_status
396: , x_msg_count => l_count
397: , x_msg_data => l_data

Line 415: l_ic_lots_mst_row.lot_no,

411:
412:
413: PO_GML_DB_COMMON.CREATE_LOT_SPECIFIC_CONVERSION(
414: l_item_no,
415: l_ic_lots_mst_row.lot_no,
416: l_ic_lots_mst_row.sublot_no,
417: p_primary_uom,
418: p_secondary_uom,
419: p_secondary_qty/nvl(p_primary_qty,1),

Line 416: l_ic_lots_mst_row.sublot_no,

412:
413: PO_GML_DB_COMMON.CREATE_LOT_SPECIFIC_CONVERSION(
414: l_item_no,
415: l_ic_lots_mst_row.lot_no,
416: l_ic_lots_mst_row.sublot_no,
417: p_primary_uom,
418: p_secondary_uom,
419: p_secondary_qty/nvl(p_primary_qty,1),
420: l_status,l_data);

Line 436: x_lot_table(l_dummy_cnt).lot_id := l_ic_lots_mst_row.lot_id;

432: END IF;/* IF p_lot_spec_conv = 'Y' */
433:
434: END IF;
435:
436: x_lot_table(l_dummy_cnt).lot_id := l_ic_lots_mst_row.lot_id;
437: x_lot_table(l_dummy_cnt).lot_no := l_ic_lots_mst_row.lot_no;
438: x_lot_table(l_dummy_cnt).sublot_no := l_ic_lots_mst_row.sublot_no;
439: x_lot_table(l_dummy_cnt).expire_date := l_ic_lots_mst_row.expire_date;
440:

Line 437: x_lot_table(l_dummy_cnt).lot_no := l_ic_lots_mst_row.lot_no;

433:
434: END IF;
435:
436: x_lot_table(l_dummy_cnt).lot_id := l_ic_lots_mst_row.lot_id;
437: x_lot_table(l_dummy_cnt).lot_no := l_ic_lots_mst_row.lot_no;
438: x_lot_table(l_dummy_cnt).sublot_no := l_ic_lots_mst_row.sublot_no;
439: x_lot_table(l_dummy_cnt).expire_date := l_ic_lots_mst_row.expire_date;
440:
441: IF nvl(p_no_of_sublots,0) <> 0 THEN

Line 438: x_lot_table(l_dummy_cnt).sublot_no := l_ic_lots_mst_row.sublot_no;

434: END IF;
435:
436: x_lot_table(l_dummy_cnt).lot_id := l_ic_lots_mst_row.lot_id;
437: x_lot_table(l_dummy_cnt).lot_no := l_ic_lots_mst_row.lot_no;
438: x_lot_table(l_dummy_cnt).sublot_no := l_ic_lots_mst_row.sublot_no;
439: x_lot_table(l_dummy_cnt).expire_date := l_ic_lots_mst_row.expire_date;
440:
441: IF nvl(p_no_of_sublots,0) <> 0 THEN
442:

Line 439: x_lot_table(l_dummy_cnt).expire_date := l_ic_lots_mst_row.expire_date;

435:
436: x_lot_table(l_dummy_cnt).lot_id := l_ic_lots_mst_row.lot_id;
437: x_lot_table(l_dummy_cnt).lot_no := l_ic_lots_mst_row.lot_no;
438: x_lot_table(l_dummy_cnt).sublot_no := l_ic_lots_mst_row.sublot_no;
439: x_lot_table(l_dummy_cnt).expire_date := l_ic_lots_mst_row.expire_date;
440:
441: IF nvl(p_no_of_sublots,0) <> 0 THEN
442:
443: l_no_of_sublots := p_no_of_sublots;

Line 452: --x_found := 1; -- 1 means ic_lots_mst exists

448:
449: l_no_of_sublots :=l_no_of_sublots - 1;
450: l_dummy_lot := l_lot_no;
451:
452: --x_found := 1; -- 1 means ic_lots_mst exists
453: --WHILE (x_found = 1)
454: --LOOP
455: gmi_autolot.generate_lot_number(
456: p_item_id => p_item_id,

Line 503: , x_ic_lots_mst_row => l_ic_lots_mst_row

499: , p_init_msg_list => FND_API.G_TRUE
500: , p_commit => FND_API.G_FALSE
501: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
502: , p_lot_rec =>lot_rec
503: , x_ic_lots_mst_row => l_ic_lots_mst_row
504: , x_ic_lots_cpg_row => l_ic_lots_cpg_row
505: , x_return_status => l_status
506: , x_msg_count => l_count
507: , x_msg_data => l_data

Line 520: x_lot_table(l_dummy_cnt1).lot_id := l_ic_lots_mst_row.lot_id;

516: END IF;
517:
518: END IF;
519:
520: x_lot_table(l_dummy_cnt1).lot_id := l_ic_lots_mst_row.lot_id;
521: x_lot_table(l_dummy_cnt1).lot_no := l_ic_lots_mst_row.lot_no;
522: x_lot_table(l_dummy_cnt1).sublot_no := l_ic_lots_mst_row.sublot_no;
523: x_lot_table(l_dummy_cnt1).expire_date := l_ic_lots_mst_row.expire_date;
524:

Line 521: x_lot_table(l_dummy_cnt1).lot_no := l_ic_lots_mst_row.lot_no;

517:
518: END IF;
519:
520: x_lot_table(l_dummy_cnt1).lot_id := l_ic_lots_mst_row.lot_id;
521: x_lot_table(l_dummy_cnt1).lot_no := l_ic_lots_mst_row.lot_no;
522: x_lot_table(l_dummy_cnt1).sublot_no := l_ic_lots_mst_row.sublot_no;
523: x_lot_table(l_dummy_cnt1).expire_date := l_ic_lots_mst_row.expire_date;
524:
525: IF p_lot_spec_conv = 'Y' THEN

Line 522: x_lot_table(l_dummy_cnt1).sublot_no := l_ic_lots_mst_row.sublot_no;

518: END IF;
519:
520: x_lot_table(l_dummy_cnt1).lot_id := l_ic_lots_mst_row.lot_id;
521: x_lot_table(l_dummy_cnt1).lot_no := l_ic_lots_mst_row.lot_no;
522: x_lot_table(l_dummy_cnt1).sublot_no := l_ic_lots_mst_row.sublot_no;
523: x_lot_table(l_dummy_cnt1).expire_date := l_ic_lots_mst_row.expire_date;
524:
525: IF p_lot_spec_conv = 'Y' THEN
526:

Line 523: x_lot_table(l_dummy_cnt1).expire_date := l_ic_lots_mst_row.expire_date;

519:
520: x_lot_table(l_dummy_cnt1).lot_id := l_ic_lots_mst_row.lot_id;
521: x_lot_table(l_dummy_cnt1).lot_no := l_ic_lots_mst_row.lot_no;
522: x_lot_table(l_dummy_cnt1).sublot_no := l_ic_lots_mst_row.sublot_no;
523: x_lot_table(l_dummy_cnt1).expire_date := l_ic_lots_mst_row.expire_date;
524:
525: IF p_lot_spec_conv = 'Y' THEN
526:
527: PO_GML_DB_COMMON.CREATE_LOT_SPECIFIC_CONVERSION(

Line 529: l_ic_lots_mst_row.lot_no,

525: IF p_lot_spec_conv = 'Y' THEN
526:
527: PO_GML_DB_COMMON.CREATE_LOT_SPECIFIC_CONVERSION(
528: l_item_no,
529: l_ic_lots_mst_row.lot_no,
530: l_ic_lots_mst_row.sublot_no,
531: p_primary_uom,
532: p_secondary_uom,
533: p_secondary_qty/nvl(p_primary_qty,1),

Line 530: l_ic_lots_mst_row.sublot_no,

526:
527: PO_GML_DB_COMMON.CREATE_LOT_SPECIFIC_CONVERSION(
528: l_item_no,
529: l_ic_lots_mst_row.lot_no,
530: l_ic_lots_mst_row.sublot_no,
531: p_primary_uom,
532: p_secondary_uom,
533: p_secondary_qty/nvl(p_primary_qty,1),
534: l_status,