APPS.GME_API_PUB dependencies on MTL_MATERIAL_TRANSACTIONS

Line 4912: ,x_mmt_rec OUT NOCOPY mtl_material_transactions%ROWTYPE

4908: ,p_line_type IN NUMBER := NULL
4909: ,p_create_lot IN VARCHAR2 := NULL
4910: ,p_generate_lot IN VARCHAR2 := NULL
4911: ,p_generate_parent_lot IN VARCHAR2 := NULL
4912: ,x_mmt_rec OUT NOCOPY mtl_material_transactions%ROWTYPE
4913: ,x_mmln_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_num_tbl)
4914: IS
4915: CURSOR cur_get_item_rec (v_item_id NUMBER, v_org_id NUMBER)
4916: IS

Line 4924: FROM mtl_material_transactions

4920:
4921: CURSOR cur_get_trans (v_header_id IN NUMBER)
4922: IS
4923: SELECT *
4924: FROM mtl_material_transactions
4925: WHERE transaction_set_id = v_header_id;
4926:
4927: l_api_name CONSTANT VARCHAR2 (30) := 'CREATE_MATERIAL_TXN';
4928: l_mmti_rec mtl_transactions_interface%ROWTYPE;

Line 5271: ,x_mmt_rec OUT NOCOPY mtl_material_transactions%ROWTYPE

5267: ,p_mmli_tbl IN gme_common_pvt.mtl_trans_lots_inter_tbl
5268: ,p_create_lot IN VARCHAR2 := NULL
5269: ,p_generate_lot IN VARCHAR2 := NULL
5270: ,p_generate_parent_lot IN VARCHAR2 := NULL
5271: ,x_mmt_rec OUT NOCOPY mtl_material_transactions%ROWTYPE
5272: ,x_mmln_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_num_tbl)
5273: IS
5274: CURSOR cur_get_item_rec (v_item_id NUMBER, v_org_id NUMBER)
5275: IS

Line 5283: FROM mtl_material_transactions

5279:
5280: CURSOR cur_get_trans (v_header_id IN NUMBER)
5281: IS
5282: SELECT *
5283: FROM mtl_material_transactions
5284: WHERE transaction_set_id = v_header_id;
5285:
5286: CURSOR cur_trans_org (v_transaction_id IN NUMBER)
5287: IS

Line 5289: FROM mtl_material_transactions

5285:
5286: CURSOR cur_trans_org (v_transaction_id IN NUMBER)
5287: IS
5288: SELECT organization_id, transaction_source_id, trx_source_line_id, transaction_type_id
5289: FROM mtl_material_transactions
5290: WHERE transaction_id = v_transaction_id;
5291:
5292: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_MATERIAL_TXN';
5293: l_transaction_id NUMBER;

Line 5294: l_mmt_rec mtl_material_transactions%ROWTYPE;

5290: WHERE transaction_id = v_transaction_id;
5291:
5292: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_MATERIAL_TXN';
5293: l_transaction_id NUMBER;
5294: l_mmt_rec mtl_material_transactions%ROWTYPE;
5295: l_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;
5296: l_mmti_rec mtl_transactions_interface%ROWTYPE;
5297: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
5298: l_mat_dtl_rec gme_material_details%ROWTYPE;

Line 5632: FROM mtl_material_transactions

5628:
5629: CURSOR cur_trans_org (v_transaction_id IN NUMBER)
5630: IS
5631: SELECT organization_id
5632: FROM mtl_material_transactions
5633: WHERE transaction_id = v_transaction_id;
5634: BEGIN
5635: IF (g_debug <> -1) THEN
5636: gme_debug.log_initialize ('DeleteTxn');