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.OE_OE_FORM_LOT_SERIAL dependencies on OE_LOT_SERIAL_UTIL

Line 220: l_Lot_Serial_val_rec := OE_Lot_Serial_Util.Get_Values

216: x_to_serial_number := l_x_Lot_Serial_rec.to_serial_number;
217:
218: -- Load display out parameters if any
219:
220: l_Lot_Serial_val_rec := OE_Lot_Serial_Util.Get_Values
221: ( p_Lot_Serial_rec => l_x_Lot_Serial_rec
222: );
223: x_line := l_Lot_Serial_val_rec.line;
224: x_lot_serial := l_Lot_Serial_val_rec.lot_serial;

Line 437: IF p_attr_id = OE_Lot_Serial_Util.G_FROM_SERIAL_NUMBER THEN

433: END IF;
434:
435: l_old_Lot_Serial_rec := l_x_Lot_Serial_rec;
436:
437: IF p_attr_id = OE_Lot_Serial_Util.G_FROM_SERIAL_NUMBER THEN
438: l_x_lot_serial_rec.from_serial_number := p_attr_value;
439: ELSIF p_attr_id = OE_Lot_Serial_Util.G_LINE THEN
440: l_x_lot_serial_rec.line_id := TO_NUMBER(p_attr_value);
441: ELSIF p_attr_id = OE_Lot_Serial_Util.G_LOT_NUMBER THEN

Line 439: ELSIF p_attr_id = OE_Lot_Serial_Util.G_LINE THEN

435: l_old_Lot_Serial_rec := l_x_Lot_Serial_rec;
436:
437: IF p_attr_id = OE_Lot_Serial_Util.G_FROM_SERIAL_NUMBER THEN
438: l_x_lot_serial_rec.from_serial_number := p_attr_value;
439: ELSIF p_attr_id = OE_Lot_Serial_Util.G_LINE THEN
440: l_x_lot_serial_rec.line_id := TO_NUMBER(p_attr_value);
441: ELSIF p_attr_id = OE_Lot_Serial_Util.G_LOT_NUMBER THEN
442: l_x_lot_serial_rec.lot_number := p_attr_value;
443: /*ELSIF p_attr_id = OE_Lot_Serial_Util.G_SUBLOT_NUMBER THEN --OPM 2380194 INVCONV

Line 441: ELSIF p_attr_id = OE_Lot_Serial_Util.G_LOT_NUMBER THEN

437: IF p_attr_id = OE_Lot_Serial_Util.G_FROM_SERIAL_NUMBER THEN
438: l_x_lot_serial_rec.from_serial_number := p_attr_value;
439: ELSIF p_attr_id = OE_Lot_Serial_Util.G_LINE THEN
440: l_x_lot_serial_rec.line_id := TO_NUMBER(p_attr_value);
441: ELSIF p_attr_id = OE_Lot_Serial_Util.G_LOT_NUMBER THEN
442: l_x_lot_serial_rec.lot_number := p_attr_value;
443: /*ELSIF p_attr_id = OE_Lot_Serial_Util.G_SUBLOT_NUMBER THEN --OPM 2380194 INVCONV
444: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510'
445: THEN

Line 443: /*ELSIF p_attr_id = OE_Lot_Serial_Util.G_SUBLOT_NUMBER THEN --OPM 2380194 INVCONV

439: ELSIF p_attr_id = OE_Lot_Serial_Util.G_LINE THEN
440: l_x_lot_serial_rec.line_id := TO_NUMBER(p_attr_value);
441: ELSIF p_attr_id = OE_Lot_Serial_Util.G_LOT_NUMBER THEN
442: l_x_lot_serial_rec.lot_number := p_attr_value;
443: /*ELSIF p_attr_id = OE_Lot_Serial_Util.G_SUBLOT_NUMBER THEN --OPM 2380194 INVCONV
444: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510'
445: THEN
446: l_x_lot_serial_rec.sublot_number := p_attr_value;
447: END IF; */

Line 448: ELSIF p_attr_id = OE_Lot_Serial_Util.G_LOT_SERIAL THEN

444: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510'
445: THEN
446: l_x_lot_serial_rec.sublot_number := p_attr_value;
447: END IF; */
448: ELSIF p_attr_id = OE_Lot_Serial_Util.G_LOT_SERIAL THEN
449: l_x_lot_serial_rec.lot_serial_id := TO_NUMBER(p_attr_value);
450: ELSIF p_attr_id = OE_Lot_Serial_Util.G_QUANTITY THEN
451: IF l_debug_level > 0 THEN
452: oe_debug_pub.add( 'IN QUANTITY CHANGE' , 1 ) ;

Line 450: ELSIF p_attr_id = OE_Lot_Serial_Util.G_QUANTITY THEN

446: l_x_lot_serial_rec.sublot_number := p_attr_value;
447: END IF; */
448: ELSIF p_attr_id = OE_Lot_Serial_Util.G_LOT_SERIAL THEN
449: l_x_lot_serial_rec.lot_serial_id := TO_NUMBER(p_attr_value);
450: ELSIF p_attr_id = OE_Lot_Serial_Util.G_QUANTITY THEN
451: IF l_debug_level > 0 THEN
452: oe_debug_pub.add( 'IN QUANTITY CHANGE' , 1 ) ;
453: END IF;
454: l_x_lot_serial_rec.quantity := TO_NUMBER(p_attr_value);

Line 455: ELSIF p_attr_id = OE_Lot_Serial_Util.G_QUANTITY2 THEN --OPM 2380194

451: IF l_debug_level > 0 THEN
452: oe_debug_pub.add( 'IN QUANTITY CHANGE' , 1 ) ;
453: END IF;
454: l_x_lot_serial_rec.quantity := TO_NUMBER(p_attr_value);
455: ELSIF p_attr_id = OE_Lot_Serial_Util.G_QUANTITY2 THEN --OPM 2380194
456: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510'
457: THEN
458: l_x_lot_serial_rec.quantity2 := TO_NUMBER(p_attr_value);
459: END IF;

Line 460: ELSIF p_attr_id = OE_Lot_Serial_Util.G_TO_SERIAL_NUMBER THEN

456: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510'
457: THEN
458: l_x_lot_serial_rec.quantity2 := TO_NUMBER(p_attr_value);
459: END IF;
460: ELSIF p_attr_id = OE_Lot_Serial_Util.G_TO_SERIAL_NUMBER THEN
461: l_x_lot_serial_rec.to_serial_number := p_attr_value;
462: ELSIF p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE1
463: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE10
464: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE12

Line 462: ELSIF p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE1

458: l_x_lot_serial_rec.quantity2 := TO_NUMBER(p_attr_value);
459: END IF;
460: ELSIF p_attr_id = OE_Lot_Serial_Util.G_TO_SERIAL_NUMBER THEN
461: l_x_lot_serial_rec.to_serial_number := p_attr_value;
462: ELSIF p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE1
463: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE10
464: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE12
465: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE13
466: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE14

Line 463: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE10

459: END IF;
460: ELSIF p_attr_id = OE_Lot_Serial_Util.G_TO_SERIAL_NUMBER THEN
461: l_x_lot_serial_rec.to_serial_number := p_attr_value;
462: ELSIF p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE1
463: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE10
464: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE12
465: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE13
466: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE14
467: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE15

Line 464: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE12

460: ELSIF p_attr_id = OE_Lot_Serial_Util.G_TO_SERIAL_NUMBER THEN
461: l_x_lot_serial_rec.to_serial_number := p_attr_value;
462: ELSIF p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE1
463: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE10
464: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE12
465: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE13
466: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE14
467: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE15
468: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE2

Line 465: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE13

461: l_x_lot_serial_rec.to_serial_number := p_attr_value;
462: ELSIF p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE1
463: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE10
464: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE12
465: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE13
466: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE14
467: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE15
468: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE2
469: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE3

Line 466: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE14

462: ELSIF p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE1
463: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE10
464: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE12
465: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE13
466: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE14
467: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE15
468: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE2
469: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE3
470: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE4

Line 467: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE15

463: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE10
464: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE12
465: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE13
466: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE14
467: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE15
468: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE2
469: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE3
470: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE4
471: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE5

Line 468: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE2

464: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE12
465: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE13
466: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE14
467: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE15
468: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE2
469: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE3
470: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE4
471: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE5
472: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE6

Line 469: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE3

465: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE13
466: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE14
467: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE15
468: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE2
469: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE3
470: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE4
471: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE5
472: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE6
473: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE7

Line 470: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE4

466: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE14
467: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE15
468: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE2
469: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE3
470: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE4
471: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE5
472: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE6
473: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE7
474: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE8

Line 471: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE5

467: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE15
468: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE2
469: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE3
470: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE4
471: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE5
472: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE6
473: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE7
474: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE8
475: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE9

Line 472: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE6

468: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE2
469: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE3
470: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE4
471: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE5
472: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE6
473: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE7
474: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE8
475: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE9
476: OR p_attr_id = OE_Lot_Serial_Util.G_CONTEXT

Line 473: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE7

469: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE3
470: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE4
471: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE5
472: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE6
473: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE7
474: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE8
475: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE9
476: OR p_attr_id = OE_Lot_Serial_Util.G_CONTEXT
477: THEN

Line 474: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE8

470: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE4
471: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE5
472: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE6
473: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE7
474: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE8
475: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE9
476: OR p_attr_id = OE_Lot_Serial_Util.G_CONTEXT
477: THEN
478:

Line 475: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE9

471: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE5
472: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE6
473: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE7
474: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE8
475: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE9
476: OR p_attr_id = OE_Lot_Serial_Util.G_CONTEXT
477: THEN
478:
479: l_x_lot_serial_rec.attribute1 := p_attribute1;

Line 476: OR p_attr_id = OE_Lot_Serial_Util.G_CONTEXT

472: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE6
473: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE7
474: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE8
475: OR p_attr_id = OE_Lot_Serial_Util.G_ATTRIBUTE9
476: OR p_attr_id = OE_Lot_Serial_Util.G_CONTEXT
477: THEN
478:
479: l_x_lot_serial_rec.attribute1 := p_attribute1;
480: l_x_lot_serial_rec.attribute10 := p_attribute10;

Line 583: l_Lot_Serial_val_rec := OE_Lot_Serial_Util.Get_Values

579: x_lot_serial := FND_API.G_MISS_CHAR;
580:
581: -- Load display out parameters if any
582:
583: l_Lot_Serial_val_rec := OE_Lot_Serial_Util.Get_Values
584: ( p_Lot_Serial_rec => l_x_Lot_Serial_rec
585: , p_old_Lot_Serial_rec => l_old_Lot_Serial_rec
586: );
587: IF l_debug_level > 0 THEN

Line 588: oe_debug_pub.add( 'AFTER CALLING OE_LOT_SERIAL_UTIL.GET_VALUES' , 1 ) ;

584: ( p_Lot_Serial_rec => l_x_Lot_Serial_rec
585: , p_old_Lot_Serial_rec => l_old_Lot_Serial_rec
586: );
587: IF l_debug_level > 0 THEN
588: oe_debug_pub.add( 'AFTER CALLING OE_LOT_SERIAL_UTIL.GET_VALUES' , 1 ) ;
589: END IF;
590:
591: IF l_debug_level > 0 THEN
592: oe_debug_pub.add( 'QUANTITY '||TO_CHAR ( L_X_LOT_SERIAL_REC.QUANTITY ) , 1 ) ;

Line 1393: -- Call OE_Lot_Serial_Util.lock_row instead of OE_Order_PVT.Lock_order

1389: l_x_Lot_Serial_rec.operation := OE_GLOBALS.G_OPR_LOCK;
1390: l_x_Lot_Serial_rec.lot_serial_id := p_lot_serial_id;
1391: l_x_Lot_Serial_rec.lock_control := p_lock_control;
1392:
1393: -- Call OE_Lot_Serial_Util.lock_row instead of OE_Order_PVT.Lock_order
1394:
1395: OE_Lot_Serial_Util.Lock_Row
1396: ( x_return_status => l_return_status
1397: , p_x_Lot_Serial_rec => l_x_Lot_Serial_rec );

Line 1395: OE_Lot_Serial_Util.Lock_Row

1391: l_x_Lot_Serial_rec.lock_control := p_lock_control;
1392:
1393: -- Call OE_Lot_Serial_Util.lock_row instead of OE_Order_PVT.Lock_order
1394:
1395: OE_Lot_Serial_Util.Lock_Row
1396: ( x_return_status => l_return_status
1397: , p_x_Lot_Serial_rec => l_x_Lot_Serial_rec );
1398:
1399: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 1499: OE_Lot_Serial_Util.Query_Row

1495: THEN
1496:
1497: -- Query row from DB
1498:
1499: OE_Lot_Serial_Util.Query_Row
1500: ( p_lot_serial_id => p_lot_serial_id
1501: , x_lot_serial_rec => g_Lot_Serial_rec
1502: );
1503: