DBA Data[Home] [Help]

APPS.MRP_FLOW_SCHEDULE_UTIL dependencies on MRP_CALENDAR

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

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

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

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

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

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

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

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