DBA Data[Home] [Help]

APPS.GMO_SWORKBENCH_PVT dependencies on GME_BATCH_HEADER

Line 796: l_batch_header_rec gme_batch_header%ROWTYPE;

792: ,x_msg_data OUT NOCOPY VARCHAR2
793: , x_msg_count OUT NOCOPY NUMBER
794: , x_return_status OUT NOCOPY VARCHAR2) IS
795: l_api_name VARCHAR2(30) := 'VALIDATE_MTL_FOR_RESERVATION';
796: l_batch_header_rec gme_batch_header%ROWTYPE;
797: l_step_id NUMBER;
798: l_step_status NUMBER;
799: fetch_failure EXCEPTION;
800: demand_line_error EXCEPTION;

Line 805: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header_rec, l_batch_header_rec)) THEN

801: batch_status_error EXCEPTION;
802: BEGIN
803: x_return_status := fnd_api.g_ret_sts_success;
804: l_batch_header_rec.batch_id := p_material_detail_rec.batch_id;
805: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header_rec, l_batch_header_rec)) THEN
806: RAISE fetch_failure;
807: END IF;
808: IF l_batch_header_rec.batch_status = gme_common_pvt.g_batch_pending THEN
809: --pending batch just return