APPS.GME_TRANSACTIONS_PVT dependencies on GME_MATERIAL_DETAILS_DBL

Line 82: IF NOT gme_material_details_dbl.fetch_row

78: l_mmli_tbl := p_mmli_tbl;
79: l_mat_dtl_rec.material_detail_id := l_mmti_rec.trx_source_line_id;
80:
81: -- Now fetch the material detials for the mateiral
82: IF NOT gme_material_details_dbl.fetch_row
83: (p_material_detail => l_mat_dtl_rec
84: ,x_material_detail => l_mat_dtl_rec) THEN
85: RAISE fnd_api.g_exc_error;
86: END IF;

Line 167: IF NOT gme_material_details_dbl.fetch_row

163: || l_mmti_rec.transaction_type_id);
164: END IF;
165:
166: -- Now fetch the material detials for the phantom line
167: IF NOT gme_material_details_dbl.fetch_row
168: (p_material_detail => m_mat_dtl_rec
169: ,x_material_detail => m_mat_dtl_rec) THEN
170: RAISE fnd_api.g_exc_error;
171: END IF;

Line 796: IF NOT gme_material_details_dbl.fetch_row

792: || 'getting material for '
793: || l_mat_dtl_rec.material_detail_id);
794: END IF;
795:
796: IF NOT gme_material_details_dbl.fetch_row
797: (p_material_detail => l_mat_dtl_rec
798: ,x_material_detail => l_mat_dtl_rec) THEN
799: RAISE fnd_api.g_exc_error;
800: END IF;

Line 2614: IF NOT gme_material_details_dbl.fetch_row

2610: IF l_batch_hdr_rec.update_inventory_ind = 'Y' THEN
2611: IF l_mmti_rec.trx_source_line_id IS NOT NULL THEN
2612: l_mat_dtl_rec.material_detail_id := l_mmti_rec.trx_source_line_id;
2613:
2614: IF NOT gme_material_details_dbl.fetch_row
2615: (p_material_detail => l_mat_dtl_rec
2616: ,x_material_detail => l_mat_dtl_rec) THEN
2617: RAISE fnd_api.g_exc_error;
2618: END IF; -- material fetch

Line 3141: IF NOT gme_material_details_dbl.fetch_row

3137:
3138: -- for transaction pairs
3139: IF l_transaction_reference IS NOT NULL THEN
3140: l_mat_dtl_rec.material_detail_id := l_trx_source_line_id ;
3141: IF NOT gme_material_details_dbl.fetch_row
3142: (p_material_detail => l_mat_dtl_rec
3143: ,x_material_detail => l_mat_dtl_rec) THEN
3144: RAISE fnd_api.g_exc_error;
3145: END IF;

Line 3342: IF NOT gme_material_details_dbl.fetch_row

3338:
3339: -- get the total quantity for actaul qty update of material detail line
3340: l_mat_dtl_rec.material_detail_id := l_trx_source_line_id;
3341:
3342: IF NOT gme_material_details_dbl.fetch_row
3343: (p_material_detail => l_mat_dtl_rec
3344: ,x_material_detail => l_mat_dtl_rec) THEN
3345: RAISE fnd_api.g_exc_error;
3346: END IF;

Line 3376: IF NOT gme_material_details_dbl.update_row

3372: END IF;
3373:
3374: l_mat_dtl_rec.actual_qty := ABS (l_actual_qty);
3375:
3376: IF NOT gme_material_details_dbl.update_row
3377: (p_material_detail => l_mat_dtl_rec) THEN
3378: RAISE fnd_api.g_exc_error;
3379: END IF;
3380:

Line 4796: IF NOT gme_material_details_dbl.fetch_row(l_mat_dtl_rec, l_mat_dtl_rec) THEN

4792:
4793: IF l_batch_hdr_rec.update_inventory_ind = 'Y' THEN
4794: IF p_mmti_rec.trx_source_line_id IS NOT NULL THEN
4795: l_mat_dtl_rec.material_detail_id := p_mmti_rec.trx_source_line_id;
4796: IF NOT gme_material_details_dbl.fetch_row(l_mat_dtl_rec, l_mat_dtl_rec) THEN
4797: RAISE fnd_api.g_exc_error;
4798: END IF; -- material fetch
4799: ELSE
4800: RAISE fnd_api.g_exc_error;