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 5072: l_lot_rec mtl_lot_numbers%ROWTYPE;

5068: l_mat_dtl_rec gme_material_details%ROWTYPE;
5069: l_mat_dtl_rec_out gme_material_details%ROWTYPE;
5070: l_batch_header_rec gme_batch_header%ROWTYPE;
5071: l_item_rec mtl_system_items_b%ROWTYPE;
5072: l_lot_rec mtl_lot_numbers%ROWTYPE;
5073: l_parent_gen_lot VARCHAR2 (2000) DEFAULT NULL;
5074: l_gen_lot VARCHAR2 (80) DEFAULT NULL;
5075: l_msg_count NUMBER;
5076: l_row_id ROWID;

Line 5085: x_lot_rec mtl_lot_numbers%ROWTYPE;

5081: l_txn_count NUMBER;
5082: l_header_id NUMBER;
5083: l_return_status VARCHAR2 (1);
5084: l_trans_date DATE ;
5085: x_lot_rec mtl_lot_numbers%ROWTYPE;
5086:
5087: -- Bug 14317532
5088: l_reset_primary NUMBER(1);
5089: l_deviation_is_valid NUMBER(1);

Line 5636: l_lot_rec mtl_lot_numbers%ROWTYPE;

5632: l_msg_data VARCHAR2 (2000);
5633: l_msg_index NUMBER (5);
5634: l_txn_count NUMBER;
5635: l_orgn_id NUMBER;
5636: l_lot_rec mtl_lot_numbers%ROWTYPE;
5637: l_return_status VARCHAR2 (1);
5638: l_parent_gen_lot VARCHAR2 (2000) DEFAULT NULL;
5639: l_gen_lot VARCHAR2 (80) DEFAULT NULL;
5640: l_row_id ROWID;

Line 5644: x_lot_rec mtl_lot_numbers%ROWTYPE;

5640: l_row_id ROWID;
5641: l_api_version NUMBER;
5642: l_source NUMBER;
5643: l_header_id NUMBER;
5644: x_lot_rec mtl_lot_numbers%ROWTYPE;
5645: l_batch_id NUMBER;
5646: l_material_detail_id NUMBER;
5647: l_txn_type_id NUMBER;
5648: update_txn_fail EXCEPTION;

Line 9133: ,p_parent_lot IN mtl_lot_numbers.lot_number%TYPE := NULL

9129: ,p_org_code IN VARCHAR2
9130: ,p_create_lot IN VARCHAR2 := fnd_api.g_false
9131: ,p_generate_lot IN VARCHAR2 := fnd_api.g_false
9132: ,p_generate_parent_lot IN VARCHAR2 := fnd_api.g_false
9133: ,p_parent_lot IN mtl_lot_numbers.lot_number%TYPE := NULL
9134: ,p_material_detail_rec IN gme_material_details%ROWTYPE
9135: /* nsinghi bug#4486074 Added the p_expiration_dt parameter. */
9136: ,p_expiration_date IN mtl_lot_numbers.expiration_date%TYPE := NULL
9137: ,p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE

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

9132: ,p_generate_parent_lot IN VARCHAR2 := fnd_api.g_false
9133: ,p_parent_lot IN mtl_lot_numbers.lot_number%TYPE := NULL
9134: ,p_material_detail_rec IN gme_material_details%ROWTYPE
9135: /* nsinghi bug#4486074 Added the p_expiration_dt parameter. */
9136: ,p_expiration_date IN mtl_lot_numbers.expiration_date%TYPE := NULL
9137: ,p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE
9138: ,x_pending_product_lots_rec OUT NOCOPY gme_pending_product_lots%ROWTYPE)
9139: IS
9140: l_api_name CONSTANT VARCHAR2 (30) := 'CREATE_PENDING_PRODUCT_LOT';