APPS.GME_TRANSACTIONS_PVT dependencies on MTL_TRANSACTION_LOTS_INTERFACE

Line 1789: UPDATE mtl_transaction_lots_interface

1785:
1786: -- Bug 13925279 - Assign the user entered expiration date.
1787: IF (x_mmti_rec.transaction_type_id <> gme_common_pvt.g_ing_issue AND
1788: l_mmli_tbl(i).lot_expiration_date IS NOT NULL) THEN
1789: UPDATE mtl_transaction_lots_interface
1790: SET lot_expiration_date = l_mmli_tbl(i).lot_expiration_date
1791: WHERE transaction_interface_id = x_mmti_rec.transaction_interface_id;
1792: END IF;
1793:

Line 2302: ,p_mmli_rec IN mtl_transaction_lots_interface%ROWTYPE

2298: ,p_inventory_item_id IN NUMBER
2299: ,p_subinventory_code IN VARCHAR2
2300: ,p_locator_id IN NUMBER
2301: ,p_lpn_id IN NUMBER DEFAULT NULL
2302: ,p_mmli_rec IN mtl_transaction_lots_interface%ROWTYPE
2303: ,x_mmli_rec OUT NOCOPY mtl_transaction_lots_interface%ROWTYPE
2304: ,x_return_status OUT NOCOPY VARCHAR2)
2305: IS
2306: l_api_name CONSTANT VARCHAR2 (30) := 'BUILD_TXN_INTER_LOT';

Line 2303: ,x_mmli_rec OUT NOCOPY mtl_transaction_lots_interface%ROWTYPE

2299: ,p_subinventory_code IN VARCHAR2
2300: ,p_locator_id IN NUMBER
2301: ,p_lpn_id IN NUMBER DEFAULT NULL
2302: ,p_mmli_rec IN mtl_transaction_lots_interface%ROWTYPE
2303: ,x_mmli_rec OUT NOCOPY mtl_transaction_lots_interface%ROWTYPE
2304: ,x_return_status OUT NOCOPY VARCHAR2)
2305: IS
2306: l_api_name CONSTANT VARCHAR2 (30) := 'BUILD_TXN_INTER_LOT';
2307: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;

Line 2308: l_mmli_rec mtl_transaction_lots_interface%ROWTYPE;

2304: ,x_return_status OUT NOCOPY VARCHAR2)
2305: IS
2306: l_api_name CONSTANT VARCHAR2 (30) := 'BUILD_TXN_INTER_LOT';
2307: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;
2308: l_mmli_rec mtl_transaction_lots_interface%ROWTYPE;
2309: l_transaction_type_id NUMBER;
2310: l_inventory_item_id NUMBER;
2311: l_item VARCHAR2(100);
2312: l_type VARCHAR2(100);

Line 2390: INSERT INTO mtl_transaction_lots_interface

2386: || l_mmli_rec.transaction_quantity);
2387: END IF;
2388: /* Bug#7226474 Added attribute columns as the lot attribute information DFF
2389: * fields can be entered using api */
2390: INSERT INTO mtl_transaction_lots_interface
2391: (transaction_interface_id, last_update_date
2392: ,last_updated_by, last_update_login
2393: ,creation_date, created_by,parent_lot_number
2394: ,lot_number, transaction_quantity

Line 2808: -- construct mtl_transaction_lots_interface

2804: --x_mmti_rec.reservation_quantity := l_mmt_rec.reservation_quantity;
2805: -- x_mmti_rec.transaction_sequence_id := l_mmt_rec.transaction_sequence_id;
2806: --x_mmti_rec.transaction_reference := l_mmt_rec.transaction_reference;
2807:
2808: -- construct mtl_transaction_lots_interface
2809: IF (l_mmln_tbl.COUNT > 0) THEN
2810: FOR i IN 1 .. l_mmln_tbl.COUNT LOOP
2811: x_mmli_tbl (i).last_update_date :=
2812: l_mmln_tbl (i).last_update_date;

Line 3402: FROM mtl_transaction_lots_interface

3398:
3399: CURSOR cur_lot_input (v_trans_inter_id NUMBER)
3400: IS
3401: SELECT lot_number, SUM (transaction_quantity) l_mtli_lot_qty
3402: FROM mtl_transaction_lots_interface
3403: WHERE transaction_interface_id = v_trans_inter_id
3404: GROUP BY lot_number;
3405:
3406: l_mmti_rec mtl_transactions_interface%ROWTYPE;

Line 3560: FOR get_lots IN (SELECT DISTINCT lot_number FROM mtl_transaction_lots_interface WHERE transaction_interface_id = p_transaction_interface_id) LOOP

3556: END IF;
3557:
3558: /* Bug 5358129 for ingredients lots should exist */
3559: IF (l_mat_dtl_rec.line_type = gme_common_pvt.g_line_type_ing AND l_mat_dtl_rec.phantom_type = 0 AND l_item_rec.lot_control_code = 2) THEN
3560: FOR get_lots IN (SELECT DISTINCT lot_number FROM mtl_transaction_lots_interface WHERE transaction_interface_id = p_transaction_interface_id) LOOP
3561: gme_transactions_pvt.validate_lot_for_ing(p_organization_id => l_mmti_rec.organization_id,
3562: p_inventory_item_id => l_mmti_rec.inventory_item_id,
3563: p_lot_number => get_lots.lot_number,
3564: x_return_status => l_return_status);

Line 4621: UPDATE mtl_transaction_lots_interface mti

4617: (SELECT transaction_interface_id, inventory_item_id, organization_id
4618: FROM mtl_Transactions_interface
4619: WHERE transaction_header_id = p_header_id
4620: AND process_flag = 1) LOOP
4621: UPDATE mtl_transaction_lots_interface mti
4622: SET (grade_code, supplier_lot_number) =
4623: (SELECT grade_code, supplier_lot_number
4624: FROM mtl_lot_numbers mln
4625: WHERE mln.lot_number = mti.lot_number