DBA Data[Home] [Help]

APPS.GML_BATCH_OM_RES_PVT dependencies on FND_PROFILE

Line 478: IF nvl(fnd_profile.value('WSH_OVERPICK_ENABLED'),'N') = 'N' THEN

474: * then
475: * 1) adjust the trans_qty and trans_qty2
476: * 2) set l_over_alloc = 1
477: */
478: IF nvl(fnd_profile.value('WSH_OVERPICK_ENABLED'),'N') = 'N' THEN
479: Open check_alloc_qty (res_rec.so_line_id);
480: Fetch check_alloc_qty Into l_total_alloc, l_total_alloc2;
481: Close check_alloc_qty;
482: l_total_req := l_total_alloc + abs(l_dft_tran_rec.trans_qty) ;