DBA Data[Home] [Help]

APPS.GME_CLOSE_BATCH_PVT dependencies on GME_MATERIAL_DETAILS_DBL

Line 216: IF NOT (gme_material_details_dbl.fetch_tab

212: CLOSE cur_lock_material_lines;
213:
214: -- Bug 10100973 - Let's remove Open orphan Move order records if they exist.
215: l_material_details_rec.batch_id := x_batch_header_rec.batch_id;
216: IF NOT (gme_material_details_dbl.fetch_tab
217: (p_material_detail => l_material_details_rec
218: ,x_material_detail => l_material_details_tab) ) THEN
219: RAISE material_details_fetch_err;
220: END IF;

Line 419: IF NOT gme_material_details_dbl.update_row(l_product_rec) THEN

415: /* dynamic cost factor is ratio of actual qty to total product qty */
416: l_product_rec.cost_alloc := l_qty/l_total_actual_output;
417:
418: /* updating the material detail record with new cost factor*/
419: IF NOT gme_material_details_dbl.update_row(l_product_rec) THEN
420: RAISE MATERIAL_DETAIL_UPD_ERR;
421: END IF;
422: END LOOP;
423: END IF;