DBA Data[Home] [Help]

APPS.MRP_FLOW_SCHEDULE_UTIL dependencies on MRP_CALENDAR

Line 6071: l_from_end_date := mrp_calendar.next_work_day(p_organization_id,

6067: -- Bug 2213859 no work day conversion required for FROM DATE ranges
6068: --fix bug#3170105 l_from_end_date := to_date(p_from_end_date, 'YYYY/MM/DD');
6069: null;
6070: /************** Commented - Bug 2213859 *********************
6071: l_from_end_date := mrp_calendar.next_work_day(p_organization_id,
6072: 1, to_date(p_from_end_date, 'YYYY/MM/DD'));
6073: IF to_date(p_from_end_date, 'YYYY/MM/DD') <> l_from_end_date THEN
6074: FND_MESSAGE.set_name('MRP','MRP_FROM_DATE_CHANGED');
6075: FND_MESSAGE.set_token('ORIG_DATE',p_from_end_date);

Line 6085: l_temp_date := mrp_calendar.next_work_day(p_organization_id,

6081: END IF;
6082:
6083: --fix bug#3170105
6084: IF p_spread_qty <> 3 THEN
6085: l_temp_date := mrp_calendar.next_work_day(p_organization_id,
6086: 1, flm_timezone.server_to_calendar(l_to_start_date));
6087: --TZ BOM Calendar bug 3832684
6088: l_temp_date := flm_timezone.calendar_to_server(l_temp_date,l_to_start_time);
6089:

Line 6120: l_temp_date := mrp_calendar.next_work_day(p_organization_id,

6116: IF p_to_end_date is NULL THEN
6117: l_to_end_date := l_to_start_date;
6118: ELSE
6119: --fix bug#3170105
6120: l_temp_date := mrp_calendar.next_work_day(p_organization_id,
6121: 1, flm_timezone.server_to_calendar(l_to_end_date));
6122: --TZ BOM Calendar bug 3832684
6123: l_temp_date := flm_timezone.calendar_to_server(l_temp_date,l_to_end_time);
6124:

Line 6143: l_to_start_date := mrp_calendar.next_work_day(p_organization_id,

6139: END IF;
6140:
6141: /**** Bug 2213859 - Code is moved up before to_end_date validation
6142: IF p_spread_qty <> 3 THEN
6143: l_to_start_date := mrp_calendar.next_work_day(p_organization_id,
6144: 1, to_date(p_to_start_date, 'YYYY/MM/DD'));
6145: IF to_date(p_to_start_date, 'YYYY/MM/DD') <> l_to_end_date AND
6146: (p_spread_qty = 2 ) THEN
6147: FND_MESSAGE.set_name('MRP','MRP_TO_DATE_CHANGED');