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_LOT_API_PUB dependencies on MTL_LOT_NUMBERS

Line 69: * This procedure inserts a lot into the MTL_LOT_NUMBERS table.

65:
66: PROCEDURE set_firstscan(p_firstscan BOOLEAN);
67:
68: /**
69: * This procedure inserts a lot into the MTL_LOT_NUMBERS table.
70: * It does all the necessary validation before inserting the lot.
71: * It derives the expiration date depending on the controls set
72: * for shelf_life_code and shelf_life_days for the item.
73: * Returns success if it is able to insert the lot.

Line 263: If all the validations go through fine, data is inserted into mtl_lot_numbers

259:
260: This is a procedure that accepts the lot attributes as input parameters.
261: This procedure validates some the input parameters like lot_number, expiration date,
262: INV attributes, C_ATTRIBUTES, N_ATTRIBUTES and D_ATTRIBUTES.
263: If all the validations go through fine, data is inserted into mtl_lot_numbers
264: */
265: -- This procedure has now be converted into a stub and it internally calls
266: -- the overloaded create_inv_lot procedure.
267:

Line 365: If all the validations go through fine, data is updated in mtl_lot_numbers table

361: /*
362: This is a procedure that accepts the lot attributes as input parameters.
363: This procedure validates some the input parameters like lot_number, expiration_date,
364: INV attributes, C_ATTRIBUTES, N_ATTRIBUTES and D_ATTRIBUTES.
365: If all the validations go through fine, data is updated in mtl_lot_numbers table
366: */
367: /*Bug 14835444 Teh default values changed to g_miss_date, g_miss_num and g_miss_char from NULL */
368: PROCEDURE update_inv_lot(
369: x_return_status OUT NOCOPY VARCHAR2

Line 415: If all the validations go through fine, data is updated in mtl_lot_numbers table

411: /*
412: This is a procedure that accepts the lot record as input parameters.
413: This procedure validates some the input parameters like lot_number, expiration_date,
414: INV attributes, C_ATTRIBUTES, N_ATTRIBUTES and D_ATTRIBUTES.
415: If all the validations go through fine, data is updated in mtl_lot_numbers table
416: */
417:
418: PROCEDURE update_inv_lot(
419: x_return_status OUT NOCOPY VARCHAR2

Line 422: , x_lot_rec OUT NOCOPY MTL_LOT_NUMBERS%ROWTYPE

418: PROCEDURE update_inv_lot(
419: x_return_status OUT NOCOPY VARCHAR2
420: , x_msg_count OUT NOCOPY NUMBER
421: , x_msg_data OUT NOCOPY VARCHAR2
422: , x_lot_rec OUT NOCOPY MTL_LOT_NUMBERS%ROWTYPE
423: , p_lot_rec IN MTL_LOT_NUMBERS%ROWTYPE
424: , p_source IN NUMBER
425: , p_api_version IN NUMBER
426: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false

Line 423: , p_lot_rec IN MTL_LOT_NUMBERS%ROWTYPE

419: x_return_status OUT NOCOPY VARCHAR2
420: , x_msg_count OUT NOCOPY NUMBER
421: , x_msg_data OUT NOCOPY VARCHAR2
422: , x_lot_rec OUT NOCOPY MTL_LOT_NUMBERS%ROWTYPE
423: , p_lot_rec IN MTL_LOT_NUMBERS%ROWTYPE
424: , p_source IN NUMBER
425: , p_api_version IN NUMBER
426: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
427: , p_commit IN VARCHAR2 := fnd_api.g_false);

Line 547: -- It inserts a record in mtl_lot_numbers table. Apart from this, it creates a

543:
544:
545: /* INVCONV, NSRIVAST, Start*/
546: -- This is the overloaded procedure for the exisiting Create_Inv_Lot procedure.
547: -- It inserts a record in mtl_lot_numbers table. Apart from this, it creates a
548: -- UOM Conversion record based on the value of copy_lot_uom_conversion.
549:
550: PROCEDURE Create_Inv_lot(
551: x_return_status OUT NOCOPY VARCHAR2

Line 555: , x_lot_rec OUT NOCOPY MTL_LOT_NUMBERS%ROWTYPE

551: x_return_status OUT NOCOPY VARCHAR2
552: , x_msg_count OUT NOCOPY NUMBER
553: , x_msg_data OUT NOCOPY VARCHAR2
554: , x_row_id OUT NOCOPY ROWID
555: , x_lot_rec OUT NOCOPY MTL_LOT_NUMBERS%ROWTYPE
556: , p_lot_rec IN MTL_LOT_NUMBERS%ROWTYPE
557: , p_source IN NUMBER
558: , p_api_version IN NUMBER
559: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false

Line 556: , p_lot_rec IN MTL_LOT_NUMBERS%ROWTYPE

552: , x_msg_count OUT NOCOPY NUMBER
553: , x_msg_data OUT NOCOPY VARCHAR2
554: , x_row_id OUT NOCOPY ROWID
555: , x_lot_rec OUT NOCOPY MTL_LOT_NUMBERS%ROWTYPE
556: , p_lot_rec IN MTL_LOT_NUMBERS%ROWTYPE
557: , p_source IN NUMBER
558: , p_api_version IN NUMBER
559: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
560: , p_commit IN VARCHAR2 := fnd_api.g_false

Line 572: , x_lot_rec OUT NOCOPY MTL_LOT_NUMBERS%ROWTYPE

568: x_return_status OUT NOCOPY VARCHAR2
569: , x_msg_count OUT NOCOPY NUMBER
570: , x_msg_data OUT NOCOPY VARCHAR2
571: , x_row_id OUT NOCOPY ROWID
572: , x_lot_rec OUT NOCOPY MTL_LOT_NUMBERS%ROWTYPE
573: , p_lot_rec IN MTL_LOT_NUMBERS%ROWTYPE
574: , p_source IN NUMBER
575: , p_api_version IN NUMBER
576: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false

Line 573: , p_lot_rec IN MTL_LOT_NUMBERS%ROWTYPE

569: , x_msg_count OUT NOCOPY NUMBER
570: , x_msg_data OUT NOCOPY VARCHAR2
571: , x_row_id OUT NOCOPY ROWID
572: , x_lot_rec OUT NOCOPY MTL_LOT_NUMBERS%ROWTYPE
573: , p_lot_rec IN MTL_LOT_NUMBERS%ROWTYPE
574: , p_source IN NUMBER
575: , p_api_version IN NUMBER
576: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
577: , p_commit IN VARCHAR2 := fnd_api.g_false