DBA Data[Home] [Help]

APPS.GME_API_GRP dependencies on GME_MATERIAL_DETAILS_DBL

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

274: END IF;
275:
276: /* Retrieve material details record */
277: l_material_details_rec.material_detail_id := p_supply_demand_line_id;
278: IF (NOT(gme_material_details_dbl.fetch_row(l_material_details_rec, l_material_details_rec))) THEN
279: IF g_debug <= gme_debug.g_log_statement THEN
280: gme_debug.put_line(g_pkg_name||'.'||l_api_name||
281: 'Fetch failure against gme_material_details using id of '||p_supply_demand_line_id);
282: END IF;

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

503: END IF;
504:
505: /* Retrieve material details record */
506: l_material_details_rec.material_detail_id := p_supply_demand_line_id;
507: IF (NOT(gme_material_details_dbl.fetch_row(l_material_details_rec, l_material_details_rec))) THEN
508: IF g_debug <= gme_debug.g_log_statement THEN
509: gme_debug.put_line(g_pkg_name||'.'||l_api_name||
510: 'Fetch failure against gme_material_details using id of '||p_supply_demand_line_id);
511: END IF;

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

1315:
1316: -- Fetch material record for the rec.material_detail_id;
1317: l_material_detail_rec.material_detail_id := rec.material_detail_id;
1318:
1319: IF NOT gme_material_details_dbl.fetch_row (p_material_detail => l_material_detail_rec,
1320: x_material_detail => l_material_detail_rec
1321: ) THEN
1322: l_oneitem_error := TRUE;
1323: gme_common_pvt.count_and_get (x_count => l_message_count,

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

1638: END IF; --IF l_new_item_rec.mtl_transactions_enabled_flag = 'Y'
1639: END IF; -- IF l_batch_header_rec.update_inventory_ind = 'Y' THEN
1640:
1641: --Call material_line_dbl.update_rec
1642: l_return := gme_material_details_dbl.update_row (l_material_detail_rec);
1643:
1644: IF (l_return = FALSE) THEN
1645: gme_common_pvt.count_and_get (x_count => l_message_count,
1646: p_encoded => fnd_api.g_false,

Line 1692: using gme_material_details_dbl.update_row procedure */

1688: FETCH c_batchsteps INTO l_batchstep_rec;
1689: CLOSE c_batchsteps;
1690:
1691: /* FPBug#4351032 update original primary qty field as this field dont get updated
1692: using gme_material_details_dbl.update_row procedure */
1693: UPDATE gme_material_details
1694: SET original_primary_qty = l_material_detail_rec.original_primary_qty
1695: WHERE material_detail_id = l_material_detail_rec.material_detail_id;
1696: