DBA Data[Home] [Help]

APPS.OE_GROUP_SCH_UTIL dependencies on OE_SYS_PARAMETERS

Line 128: IF oe_sys_parameters.value ('ONT_SCHEDULE_LINE_ON_HOLD') = 'N' --moac

124: -- line is getting scheduled due to action OESCH_ACT_SCHEDULE
125: -- or OESCH_ACT_RESERVE.
126:
127: -- IF FND_PROFILE.VALUE('ONT_SCHEDULE_LINE_ON_HOLD') = 'N'
128: IF oe_sys_parameters.value ('ONT_SCHEDULE_LINE_ON_HOLD') = 'N' --moac
129: THEN
130: -- Since the profile is set to NO, we should not schedule
131: -- the line if the line is on hold.
132:

Line 827: --AND OE_SYS_PARAMETERS.value('PARTIAL_RESERVATION_FLAG')= 'Y'

823:
824: -- Pack J
825: IF l_line_rec.reserved_quantity = 0
826: OR ( OE_CODE_CONTROL.Get_Code_Release_Level >= '110510'
827: --AND OE_SYS_PARAMETERS.value('PARTIAL_RESERVATION_FLAG')= 'Y'
828: AND l_line_rec.ordered_quantity >
829: l_line_rec.reserved_quantity) THEN
830:
831:

Line 847: --AND OE_SYS_PARAMETERS.value('PARTIAL_RESERVATION_FLAG')= 'Y'

843: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
844: --Pack J
845: -- To calculate the remaining quantity to be reserved
846: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510'
847: --AND OE_SYS_PARAMETERS.value('PARTIAL_RESERVATION_FLAG')= 'Y'
848: AND l_line_rec.ordered_quantity >
849: l_line_rec.reserved_quantity THEN
850: l_quantity_to_reserve := l_line_rec.ordered_quantity - l_line_rec.reserved_quantity;
851: ELSE

Line 3032: --AND OE_SYS_PARAMETERS.value('PARTIAL_RESERVATION_FLAG')= 'Y'

3028: -- Check for Partial reservation flag when the line is partially reserved
3029: IF nvl(l_line_tbl(I).shippable_flag,'N') = 'Y'
3030: AND ((l_line_tbl(I).reserved_quantity = 0)
3031: OR ( OE_CODE_CONTROL.Get_Code_Release_Level >= '110510'
3032: --AND OE_SYS_PARAMETERS.value('PARTIAL_RESERVATION_FLAG')= 'Y'
3033: AND l_line_tbl(I).ordered_quantity >
3034: l_line_tbl(I).reserved_quantity)) THEN
3035:
3036: IF l_debug_level > 0 THEN

Line 3051: --AND OE_SYS_PARAMETERS.value('PARTIAL_RESERVATION_FLAG')= 'Y'

3047: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
3048: --Pack J
3049: -- To calculate the remaining quantity to be reserved
3050: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510'
3051: --AND OE_SYS_PARAMETERS.value('PARTIAL_RESERVATION_FLAG')= 'Y'
3052: AND l_line_tbl(I).ordered_quantity >
3053: l_line_tbl(I).reserved_quantity THEN
3054: l_quantity_to_reserve := l_line_tbl(I).ordered_quantity - l_line_tbl(I).reserved_quantity;
3055: ELSE

Line 3060: --AND OE_SYS_PARAMETERS.value('PARTIAL_RESERVATION_FLAG')= 'Y'

3056: l_quantity_to_reserve := l_line_tbl(I).ordered_quantity;
3057: END IF;
3058:
3059: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' -- INVCONV
3060: --AND OE_SYS_PARAMETERS.value('PARTIAL_RESERVATION_FLAG')= 'Y'
3061: AND l_line_tbl(I).ordered_quantity2 >
3062: l_line_tbl(I).reserved_quantity2 THEN
3063: l_quantity2_to_reserve := l_line_tbl(I).ordered_quantity2 - l_line_tbl(I).reserved_quantity2;
3064: ELSE

Line 5828: IF NVL(oe_sys_parameters.Value('ONT_AUTO_SCH_SETS',l_org_id),'Y')='Y' THEN

5824: -- set.
5825: --4241385
5826: /* checking the if condition, so that lines will not be removed from the set,
5827: if scheduling fails, in case auto scheduling is turned on.*/
5828: IF NVL(oe_sys_parameters.Value('ONT_AUTO_SCH_SETS',l_org_id),'Y')='Y' THEN
5829: FOR I IN 1..l_line_tbl.count LOOP
5830:
5831: -- IF l_line_tbl(I).schedule_status_code IS NULL --commented for bug3986288
5832: -- THEN