DBA Data[Home] [Help]

APPS.OE_SPLIT_UTIL dependencies on OE_SYS_PARAMETERS

Line 1473: AND NVL(OE_SYS_PARAMETERS.value('RESCHEDULE_REQUEST_DATE_FLAG'),'Y') = 'Y' THEN -- 12833832

1469: IF NVL(l_option_line.SPLIT_REQUEST_DATE,'N') ='Y' THEN -- 10278858
1470: IF l_option_line.schedule_ship_date IS NOT NULL
1471: --AND NOT OE_GLOBALS.EQUAL(p_x_line_rec.request_date
1472: -- ,l_line_rec.request_date)
1473: AND NVL(OE_SYS_PARAMETERS.value('RESCHEDULE_REQUEST_DATE_FLAG'),'Y') = 'Y' THEN -- 12833832
1474: l_order_date_type_code := NVL(oe_schedule_util.Get_Date_Type(l_option_line.header_id),'SHIP');
1475: IF l_order_date_type_code = 'SHIP' THEN
1476: -- Its a scheduled line. Reschedule with new date
1477: l_option_line.schedule_ship_date := l_option_line.request_date;

Line 1771: AND NVL(OE_SYS_PARAMETERS.value('RESCHEDULE_REQUEST_DATE_FLAG'),'Y') = 'Y' THEN -- 12833832

1767: /*bug 13954474
1768: AND NOT OE_GLOBALS.EQUAL(p_x_line_rec.request_date
1769: ,l_line_rec.request_date)
1770: bug 13954474*/
1771: AND NVL(OE_SYS_PARAMETERS.value('RESCHEDULE_REQUEST_DATE_FLAG'),'Y') = 'Y' THEN -- 12833832
1772: l_order_date_type_code := NVL(oe_schedule_util.Get_Date_Type(l_line_rec.header_id),'SHIP');
1773: IF l_order_date_type_code = 'SHIP' THEN
1774: -- Its a scheduled line. Reschedule with new date
1775: l_line_rec.schedule_ship_date := p_x_line_rec.request_date;

Line 2075: NVL(OE_SYS_PARAMETERS.value('RESCHEDULE_REQUEST_DATE_FLAG'),'Y') = 'Y' THEN -- 12833832

2071: END IF;
2072: IF l_line_rec.schedule_ship_date is NOT NULL AND
2073: NOT OE_GLOBALS.EQUAL(l_line_rec.request_date, l_line_tbl(I).request_date) AND
2074: NVL(l_line_tbl(I).SPLIT_REQUEST_DATE,'N') ='Y' AND -- 10338643
2075: NVL(OE_SYS_PARAMETERS.value('RESCHEDULE_REQUEST_DATE_FLAG'),'Y') = 'Y' THEN -- 12833832
2076: l_order_date_type_code := NVL(oe_schedule_util.Get_Date_Type(l_line_rec.header_id),'SHIP');
2077: IF l_order_date_type_code = 'SHIP' THEN
2078: l_sch_tbl(l_sch_count).schedule_ship_date := l_line_tbl(I).request_date;
2079: ELSE