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.GME_API_PUB dependencies on MTL_LOT_NUMBERS

Line 4934: l_lot_rec mtl_lot_numbers%ROWTYPE;

4930: l_mat_dtl_rec gme_material_details%ROWTYPE;
4931: l_mat_dtl_rec_out gme_material_details%ROWTYPE;
4932: l_batch_header_rec gme_batch_header%ROWTYPE;
4933: l_item_rec mtl_system_items_b%ROWTYPE;
4934: l_lot_rec mtl_lot_numbers%ROWTYPE;
4935: l_parent_gen_lot VARCHAR2 (2000) DEFAULT NULL;
4936: l_gen_lot VARCHAR2 (80) DEFAULT NULL;
4937: l_msg_count NUMBER;
4938: l_row_id ROWID;

Line 4947: x_lot_rec mtl_lot_numbers%ROWTYPE;

4943: l_txn_count NUMBER;
4944: l_header_id NUMBER;
4945: l_return_status VARCHAR2 (1);
4946: l_trans_date DATE ;
4947: x_lot_rec mtl_lot_numbers%ROWTYPE;
4948:
4949: create_txn_fail EXCEPTION;
4950: BEGIN
4951: IF (g_debug <> -1) THEN

Line 5305: l_lot_rec mtl_lot_numbers%ROWTYPE;

5301: l_msg_data VARCHAR2 (2000);
5302: l_msg_index NUMBER (5);
5303: l_txn_count NUMBER;
5304: l_orgn_id NUMBER;
5305: l_lot_rec mtl_lot_numbers%ROWTYPE;
5306: l_return_status VARCHAR2 (1);
5307: l_parent_gen_lot VARCHAR2 (2000) DEFAULT NULL;
5308: l_gen_lot VARCHAR2 (80) DEFAULT NULL;
5309: l_row_id ROWID;

Line 5313: x_lot_rec mtl_lot_numbers%ROWTYPE;

5309: l_row_id ROWID;
5310: l_api_version NUMBER;
5311: l_source NUMBER;
5312: l_header_id NUMBER;
5313: x_lot_rec mtl_lot_numbers%ROWTYPE;
5314: l_batch_id NUMBER;
5315: l_material_detail_id NUMBER;
5316: l_txn_type_id NUMBER;
5317: update_txn_fail EXCEPTION;

Line 8611: ,p_expiration_date IN mtl_lot_numbers.expiration_date%TYPE := NULL

8607: ,p_generate_lot IN VARCHAR2 := fnd_api.g_false
8608: ,p_generate_parent_lot IN VARCHAR2 := fnd_api.g_false
8609: ,p_material_detail_rec IN gme_material_details%ROWTYPE
8610: /* nsinghi bug#4486074 Added the p_expiration_dt parameter. */
8611: ,p_expiration_date IN mtl_lot_numbers.expiration_date%TYPE := NULL
8612: ,p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE
8613: ,x_pending_product_lots_rec OUT NOCOPY gme_pending_product_lots%ROWTYPE)
8614: IS
8615: l_api_name CONSTANT VARCHAR2 (30) := 'CREATE_PENDING_PRODUCT_LOT';