DBA Data[Home] [Help]

APPS.GME_TRANSACTIONS_PVT dependencies on GME_BATCH_HEADER

Line 3409: l_batch_hdr_rec gme_batch_header%ROWTYPE;

3405:
3406: l_mmti_rec mtl_transactions_interface%ROWTYPE;
3407: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
3408: l_mat_dtl_rec gme_material_details%ROWTYPE;
3409: l_batch_hdr_rec gme_batch_header%ROWTYPE;
3410: l_item_rec mtl_system_items_b%ROWTYPE;
3411: l_available_qty NUMBER;
3412: l_step_status NUMBER;
3413: l_rel_type NUMBER;

Line 3451: IF NOT gme_batch_header_dbl.fetch_row

3447:
3448: IF l_mmti_rec.transaction_source_id IS NOT NULL THEN
3449: l_batch_hdr_rec.batch_id := l_mmti_rec.transaction_source_id;
3450:
3451: IF NOT gme_batch_header_dbl.fetch_row
3452: (p_batch_header => l_batch_hdr_rec
3453: ,x_batch_header => l_batch_hdr_rec) THEN
3454: RAISE fnd_api.g_exc_error;
3455: END IF;-- batch fetch

Line 5803: l_batch_hdr_rec gme_batch_header%ROWTYPE;

5799: FROM gme_batch_steps s, gme_batch_step_items i
5800: WHERE s.batchstep_id = i.batchstep_id
5801: AND i.material_detail_id = v_matl_dtl_id;
5802: l_mat_dtl_rec gme_material_details%ROWTYPE;
5803: l_batch_hdr_rec gme_batch_header%ROWTYPE;
5804: l_item_rec mtl_system_items_b%ROWTYPE;
5805: l_available_qty NUMBER;
5806: l_step_status NUMBER;
5807: l_rel_type NUMBER;

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

5828: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.transaction_type_id: '||p_mmti_rec.transaction_type_id);
5829: END IF;
5830: IF p_mmti_rec.transaction_source_id IS NOT NULL THEN
5831: l_batch_hdr_rec.batch_id := p_mmti_rec.transaction_source_id;
5832: IF NOT gme_batch_header_dbl.fetch_row(l_batch_hdr_rec, l_batch_hdr_rec) THEN
5833: RAISE fnd_api.g_exc_error;
5834: END IF;
5835: ELSE
5836: RAISE fnd_api.g_exc_error;