DBA Data[Home] [Help]

APPS.GME_TRANSACTIONS_PVT dependencies on GME_BATCH_HEADER

Line 2559: l_batch_hdr_rec gme_batch_header%ROWTYPE;

2555:
2556: l_mmti_rec mtl_transactions_interface%ROWTYPE;
2557: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
2558: l_mat_dtl_rec gme_material_details%ROWTYPE;
2559: l_batch_hdr_rec gme_batch_header%ROWTYPE;
2560: l_item_rec mtl_system_items_b%ROWTYPE;
2561: l_available_qty NUMBER;
2562: l_step_status NUMBER;
2563: l_rel_type NUMBER;

Line 2601: IF NOT gme_batch_header_dbl.fetch_row

2597:
2598: IF l_mmti_rec.transaction_source_id IS NOT NULL THEN
2599: l_batch_hdr_rec.batch_id := l_mmti_rec.transaction_source_id;
2600:
2601: IF NOT gme_batch_header_dbl.fetch_row
2602: (p_batch_header => l_batch_hdr_rec
2603: ,x_batch_header => l_batch_hdr_rec) THEN
2604: RAISE fnd_api.g_exc_error;
2605: END IF;-- batch fetch

Line 4757: l_batch_hdr_rec gme_batch_header%ROWTYPE;

4753: FROM gme_batch_steps s, gme_batch_step_items i
4754: WHERE s.batchstep_id = i.batchstep_id
4755: AND i.material_detail_id = v_matl_dtl_id;
4756: l_mat_dtl_rec gme_material_details%ROWTYPE;
4757: l_batch_hdr_rec gme_batch_header%ROWTYPE;
4758: l_item_rec mtl_system_items_b%ROWTYPE;
4759: l_available_qty NUMBER;
4760: l_step_status NUMBER;
4761: l_rel_type NUMBER;

Line 4786: IF NOT gme_batch_header_dbl.fetch_row(l_batch_hdr_rec, l_batch_hdr_rec) THEN

4782: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.transaction_type_id: '||p_mmti_rec.transaction_type_id);
4783: END IF;
4784: IF p_mmti_rec.transaction_source_id IS NOT NULL THEN
4785: l_batch_hdr_rec.batch_id := p_mmti_rec.transaction_source_id;
4786: IF NOT gme_batch_header_dbl.fetch_row(l_batch_hdr_rec, l_batch_hdr_rec) THEN
4787: RAISE fnd_api.g_exc_error;
4788: END IF;
4789: ELSE
4790: RAISE fnd_api.g_exc_error;