DBA Data[Home] [Help]

APPS.GME_API_GRP dependencies on GME_MATERIAL_DETAILS_DBL

Line 264: IF (NOT(gme_material_details_dbl.fetch_row(l_material_details_rec, l_material_details_rec))) THEN

260: END IF;
261:
262: /* Retrieve material details record */
263: l_material_details_rec.material_detail_id := p_supply_demand_line_id;
264: IF (NOT(gme_material_details_dbl.fetch_row(l_material_details_rec, l_material_details_rec))) THEN
265: IF g_debug <= gme_debug.g_log_statement THEN
266: gme_debug.put_line(g_pkg_name||'.'||l_api_name||
267: 'Fetch failure against gme_material_details using id of '||p_supply_demand_line_id);
268: END IF;

Line 486: IF (NOT(gme_material_details_dbl.fetch_row(l_material_details_rec, l_material_details_rec))) THEN

482: END IF;
483:
484: /* Retrieve material details record */
485: l_material_details_rec.material_detail_id := p_supply_demand_line_id;
486: IF (NOT(gme_material_details_dbl.fetch_row(l_material_details_rec, l_material_details_rec))) THEN
487: IF g_debug <= gme_debug.g_log_statement THEN
488: gme_debug.put_line(g_pkg_name||'.'||l_api_name||
489: 'Fetch failure against gme_material_details using id of '||p_supply_demand_line_id);
490: END IF;

Line 1290: IF NOT gme_material_details_dbl.fetch_row (p_material_detail => l_material_detail_rec,

1286:
1287: -- Fetch material record for the rec.material_detail_id;
1288: l_material_detail_rec.material_detail_id := rec.material_detail_id;
1289:
1290: IF NOT gme_material_details_dbl.fetch_row (p_material_detail => l_material_detail_rec,
1291: x_material_detail => l_material_detail_rec
1292: ) THEN
1293: l_oneitem_error := TRUE;
1294: gme_common_pvt.count_and_get (x_count => l_message_count,

Line 1593: l_return := gme_material_details_dbl.update_row (l_material_detail_rec);

1589: END IF; --IF l_new_item_rec.mtl_transactions_enabled_flag = 'Y'
1590: END IF; -- IF l_batch_header_rec.update_inventory_ind = 'Y' THEN
1591:
1592: --Call material_line_dbl.update_rec
1593: l_return := gme_material_details_dbl.update_row (l_material_detail_rec);
1594:
1595: IF (l_return = FALSE) THEN
1596: gme_common_pvt.count_and_get (x_count => l_message_count,
1597: p_encoded => fnd_api.g_false,

Line 1640: using gme_material_details_dbl.update_row procedure */

1636: FETCH c_batchsteps INTO l_batchstep_rec;
1637: CLOSE c_batchsteps;
1638:
1639: /* FPBug#4351032 update original primary qty field as this field dont get updated
1640: using gme_material_details_dbl.update_row procedure */
1641: UPDATE gme_material_details
1642: SET original_primary_qty = l_material_detail_rec.original_primary_qty
1643: WHERE material_detail_id = l_material_detail_rec.material_detail_id;
1644: