DBA Data[Home] [Help]

APPS.GMD_SPREADSHEET_UPDATE dependencies on GME_MATERIAL_DETAIL_PVT

Line 444: gme_material_detail_pvt.delete_material_line (p_batch_header_rec => l_batch_row

440: /* but was deleted from the spreadsheet */
441: FOR l_del_matl_rec IN Cur_get_del_material LOOP
442: l_material_detail.material_detail_id := l_del_matl_rec.material_detail_id;
443: l_material_detail.batch_id := P_batch_id;
444: gme_material_detail_pvt.delete_material_line (p_batch_header_rec => l_batch_row
445: ,p_material_detail_rec => l_material_detail
446: ,p_batch_step_rec => l_batch_step
447: ,x_transacted => l_transacted
448: ,x_return_status => l_return_status);

Line 483: gme_material_detail_pvt.insert_material_line (p_batch_header_rec => l_batch_row

479: ELSIF (l_batch_row.batch_status = 2) THEN
480: l_material_detail.wip_plan_qty := l_matl_rec.qty;
481: END IF;
482: gmd_debug.put_line(' Inserting line for batch:'||l_material_detail.batch_id||' Item:'||l_material_detail.inventory_item_id);
483: gme_material_detail_pvt.insert_material_line (p_batch_header_rec => l_batch_row
484: ,p_material_detail_rec => l_material_detail
485: ,p_batch_step_rec => l_batch_step
486: ,p_trans_id => NULL
487: ,x_transacted => l_transacted

Line 509: gme_material_detail_pvt.update_material_line (p_batch_header_rec => l_batch_row

505: X_material.plan_qty := l_matl_rec.qty;
506: ELSIF (l_batch_row.batch_status = 2) THEN
507: X_material.wip_plan_qty := l_matl_rec.qty;
508: END IF;
509: gme_material_detail_pvt.update_material_line (p_batch_header_rec => l_batch_row
510: ,p_material_detail_rec => X_material
511: ,p_stored_material_detail_rec => NULL
512: ,p_batch_step_rec => l_batch_step
513: ,p_scale_phantom => fnd_api.g_false