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;
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 521: gme_common_pvt.g_move_to_temp := fnd_api.g_false;

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

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

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

Line 524: gme_common_pvt.set_who;

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

Line 1134: p_header_id => gme_common_pvt.get_txn_header_id,

1130: -- Bug 5533886
1131: -- Call save batch api to save the updated material transactions.
1132: gme_api_pub.save_batch (
1133: X_return_status => l_return_status,
1134: p_header_id => gme_common_pvt.get_txn_header_id,
1135: p_table => 1,
1136: p_commit => 'F',
1137: p_clear_qty_cache => 'T');
1138: