APPS.GME_PENDING_PRODUCT_LOTS_PVT dependencies on GME_PENDING_PRODUCT_LOTS_DBL

Line 410: IF NOT gme_pending_product_lots_dbl.insert_row

406: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
407: END IF;
408: x_return_status := FND_API.G_RET_STS_SUCCESS;
409:
410: IF NOT gme_pending_product_lots_dbl.insert_row
411: (p_pending_product_lots_rec => p_pending_product_lots_rec
412: ,x_pending_product_lots_rec => l_pp_lot_rec) THEN
413: RAISE error_insert_row;
414: END IF;

Line 450: IF NOT gme_pending_product_lots_dbl.update_row

446: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
447: END IF;
448: x_return_status := FND_API.G_RET_STS_SUCCESS;
449:
450: IF NOT gme_pending_product_lots_dbl.update_row
451: (p_pending_product_lots_rec => p_pending_product_lots_rec) THEN
452: RAISE error_update_row;
453: END IF;
454:

Line 455: IF NOT gme_pending_product_lots_dbl.fetch_row

451: (p_pending_product_lots_rec => p_pending_product_lots_rec) THEN
452: RAISE error_update_row;
453: END IF;
454:
455: IF NOT gme_pending_product_lots_dbl.fetch_row
456: (p_pending_product_lots_rec => p_pending_product_lots_rec
457: ,x_pending_product_lots_rec => x_pending_product_lots_rec) THEN
458: RAISE error_fetch_row;
459: END IF;

Line 491: IF NOT gme_pending_product_lots_dbl.delete_row

487: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
488: END IF;
489: x_return_status := FND_API.G_RET_STS_SUCCESS;
490:
491: IF NOT gme_pending_product_lots_dbl.delete_row
492: (p_pending_product_lots_rec => p_pending_product_lots_rec) THEN
493: RAISE error_delete_row;
494: END IF;
495:

Line 538: IF NOT gme_pending_product_lots_dbl.delete_row

534: LOOP
535: FETCH c_get_pending_lots INTO l_pending_product_lots_rec.pending_product_lot_id;
536: EXIT WHEN c_get_pending_lots%NOTFOUND;
537: --call dbl layer
538: IF NOT gme_pending_product_lots_dbl.delete_row
539: (p_pending_product_lots_rec => l_pending_product_lots_rec) THEN
540: CLOSE c_get_pending_lots;
541: RAISE error_delete_row;
542: END IF;

Line 918: IF NOT gme_pending_product_lots_dbl.fetch_row

914: l_in_pending_product_lots_rec := p_pending_product_lots_rec;
915: l_in_pending_product_lots_rec.material_detail_id := p_material_detail_rec.material_detail_id;
916: l_in_pending_product_lots_rec.batch_id := p_material_detail_rec.batch_id;
917:
918: IF NOT gme_pending_product_lots_dbl.fetch_row
919: (p_pending_product_lots_rec => l_in_pending_product_lots_rec
920: ,x_pending_product_lots_rec => l_db_pending_product_lots_rec) THEN
921: RAISE error_fetch_row;
922: END IF;

Line 1146: IF NOT gme_pending_product_lots_dbl.fetch_row

1142: l_in_pending_product_lots_rec := p_pending_product_lots_rec;
1143: l_in_pending_product_lots_rec.material_detail_id := p_material_detail_rec.material_detail_id;
1144: l_in_pending_product_lots_rec.batch_id := p_material_detail_rec.batch_id;
1145:
1146: IF NOT gme_pending_product_lots_dbl.fetch_row
1147: (p_pending_product_lots_rec => l_in_pending_product_lots_rec
1148: ,x_pending_product_lots_rec => x_pending_product_lots_rec) THEN
1149: RAISE error_fetch_row;
1150: END IF;