APPS.MTL_LOT_UOM_CONV_PVT dependencies on GME_COMMON_PVT

Line 385: AND transaction_source_type_id = 5 -- gme_common_pvt.g_txn_source_type

381: Cursor get_batch_transactions IS
382: SELECT *
383: FROM mtl_material_transactions mmt
384: WHERE transaction_source_id = p_batch_id
385: AND transaction_source_type_id = 5 -- gme_common_pvt.g_txn_source_type
386: AND NOT EXISTS ( SELECT transaction_id1
387: FROM gme_transaction_pairs
388: WHERE transaction_id1 = mmt.transaction_id
389: AND pair_type = 1) --gme_common_pvt.g_pairs_reversal_type

Line 389: AND pair_type = 1) --gme_common_pvt.g_pairs_reversal_type

385: AND transaction_source_type_id = 5 -- gme_common_pvt.g_txn_source_type
386: AND NOT EXISTS ( SELECT transaction_id1
387: FROM gme_transaction_pairs
388: WHERE transaction_id1 = mmt.transaction_id
389: AND pair_type = 1) --gme_common_pvt.g_pairs_reversal_type
390: AND inventory_item_id = p_lot_uom_conv_rec.inventory_item_id
391: AND organization_id = p_lot_uom_conv_rec.organization_id
392: AND EXISTS (select 1
393: From mtl_transaction_lot_numbers

Line 406: l_lot_transactions_tbl GME_COMMON_PVT.mtl_trans_lots_num_tbl;

402: --AND lot_number = p_lot_uom_conv_rec.lot_number; Bug#9744632
403:
404: x_batch_txns mtl_material_transactions%ROWTYPE;
405: x_lot_txns mtl_transaction_lot_numbers%ROWTYPE;
406: l_lot_transactions_tbl GME_COMMON_PVT.mtl_trans_lots_num_tbl;
407: i NUMBER;
408: j NUMBER;
409: txn_ind NUMBER;
410: new_ind NUMBER;

Line 522: gme_common_pvt.g_move_to_temp := fnd_api.g_false;

518: OPEN get_uom_codes;
519: FETCH get_uom_codes INTO l_primary_uom, l_secondary_uom;
520: CLOSE get_uom_codes;
521:
522: gme_common_pvt.g_move_to_temp := fnd_api.g_false;
523:
524: gme_common_pvt.g_setup_done := gme_common_pvt.setup (p_lot_uom_conv_rec.organization_id);
525: gme_common_pvt.set_who;
526:

Line 524: gme_common_pvt.g_setup_done := gme_common_pvt.setup (p_lot_uom_conv_rec.organization_id);

520: CLOSE get_uom_codes;
521:
522: gme_common_pvt.g_move_to_temp := fnd_api.g_false;
523:
524: gme_common_pvt.g_setup_done := gme_common_pvt.setup (p_lot_uom_conv_rec.organization_id);
525: gme_common_pvt.set_who;
526:
527:
528: -- Bug 5533886

Line 525: gme_common_pvt.set_who;

521:
522: gme_common_pvt.g_move_to_temp := fnd_api.g_false;
523:
524: gme_common_pvt.g_setup_done := gme_common_pvt.setup (p_lot_uom_conv_rec.organization_id);
525: gme_common_pvt.set_who;
526:
527:
528: -- Bug 5533886
529: IF (p_update_type_indicator IN ('1','2')) THEN

Line 1152: p_header_id => gme_common_pvt.get_txn_header_id,

1148: -- Bug 5533886
1149: -- Call save batch api to save the updated material transactions.
1150: gme_api_pub.save_batch (
1151: X_return_status => l_return_status,
1152: p_header_id => gme_common_pvt.get_txn_header_id,
1153: p_table => 1,
1154: p_commit => 'F',
1155: p_clear_qty_cache => 'T');
1156: