eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_SATP_FUNC dependencies on MSC_CALENDAR

Line 234: -- Note: Compared to a similar function in MSC_CALENDAR

230: l_first_work_day DATE; --bug3583705
231: l_last_work_day DATE; --bug3583705
232:
233: BEGIN
234: -- Note: Compared to a similar function in MSC_CALENDAR
235: -- the default of daily bucket is used here
236: -- bug 2974334. Change the SQL into static.
237: SELECT cal.prior_date
238: INTO l_return_date

Line 248: IF MSC_CALENDAR.G_RETAIN_DATE = 'Y' THEN

244: AND org.organization_id = p_organization_id;
245: RETURN l_return_date;
246: EXCEPTION
247: WHEN NO_DATA_FOUND THEN --bug3583705
248: IF MSC_CALENDAR.G_RETAIN_DATE = 'Y' THEN
249: BEGIN
250: SELECT min(calendar_date), max(calendar_date)
251: INTO l_first_work_day, l_last_work_day
252: FROM BOM_CALENDAR_DATES cal,

Line 285: -- Note: Compared to a similar function in MSC_CALENDAR

281: l_return_date DATE;
282: l_first_work_day DATE; --bug3583705
283: l_last_work_day DATE; --bug3583705
284: BEGIN
285: -- Note: Compared to a similar function in MSC_CALENDAR
286: -- the default of daily bucket is used here.
287:
288:
289: -- bug 2974334. Change the SQL into static.

Line 302: IF MSC_CALENDAR.G_RETAIN_DATE = 'Y' THEN

298:
299: RETURN l_return_date;
300: EXCEPTION
301: WHEN NO_DATA_FOUND THEN --bug3583705
302: IF MSC_CALENDAR.G_RETAIN_DATE = 'Y' THEN
303: BEGIN
304: SELECT min(calendar_date), max(calendar_date)
305: INTO l_first_work_day, l_last_work_day
306: FROM BOM_CALENDAR_DATES cal,

Line 343: -- Note: Compared to a similar function in MSC_CALENDAR

339: l_days NUMBER;
340: l_first_work_day DATE; --bug3583705
341: l_last_work_day DATE; --bug3583705
342: BEGIN
343: -- Note: Compared to a similar function in MSC_CALENDAR
344: -- the default of daily bucket is used here
345:
346:
347: IF p_days < 0 THEN

Line 370: IF MSC_CALENDAR.G_RETAIN_DATE = 'Y' THEN

366: RETURN l_return_date;
367:
368: EXCEPTION
369: WHEN NO_DATA_FOUND THEN --bug3583705
370: IF MSC_CALENDAR.G_RETAIN_DATE = 'Y' THEN
371: BEGIN
372: SELECT min(calendar_date), max(calendar_date)
373: INTO l_first_work_day, l_last_work_day
374: FROM BOM_CALENDAR_DATES cal,

Line 3853: l_calendar_code VARCHAR2(14) := MSC_CALENDAR.FOC;

3849: p_ship_method_code IN varchar2,
3850: p_calendar_type IN integer -- One of OSC, CRC or VIC
3851: ) RETURN VARCHAR2
3852: IS
3853: l_calendar_code VARCHAR2(14) := MSC_CALENDAR.FOC;
3854: l_ship_method_code VARCHAR2(50) := NVL(p_ship_method_code, '@@@');
3855: l_customer_site_id NUMBER := NVL(p_customer_site_id, -1);
3856: l_calendar_type VARCHAR2(15); -- Bug 3449812
3857:

Line 3876: IF (p_calendar_type = MSC_CALENDAR.CRC) THEN

3872: -- IF MSC_ATP_PVT.G_USE_SHIP_REC_CAL='Y' THEN
3873: -- l_calendar_code is already initialized to FOC
3874:
3875: -- case 1. Searching for a valid customer receiving calendar (CRC)
3876: IF (p_calendar_type = MSC_CALENDAR.CRC) THEN
3877:
3878: -- Bug 3647208 - Move the check inside individual "IF"s
3879: IF MSC_ATP_PVT.G_USE_SHIP_REC_CAL='Y' THEN
3880: -- l_calendar_code is already initialized to FOC

Line 3914: ELSIF (p_calendar_type = MSC_CALENDAR.OSC OR p_calendar_type = MSC_CALENDAR.ORC) THEN

3910: END IF;
3911:
3912: -- case 2. Org's Shipping Calendar (OSC)
3913: -- Bug 3449812 - Added support for ORC for ISOs
3914: ELSIF (p_calendar_type = MSC_CALENDAR.OSC OR p_calendar_type = MSC_CALENDAR.ORC) THEN
3915:
3916: -- Bug 3647208 - Move the check inside individual "IF"s
3917: IF MSC_ATP_PVT.G_USE_SHIP_REC_CAL='Y' THEN
3918:

Line 3922: IF p_calendar_type = MSC_CALENDAR.ORC THEN

3918:
3919: -- Using the fact the length of association_types carrier_organization (20),
3920: -- organization (12) can be used to order by
3921:
3922: IF p_calendar_type = MSC_CALENDAR.ORC THEN
3923: l_calendar_type := 'RECEIVING';
3924: ELSE
3925: l_calendar_type := 'SHIPPING';
3926: END IF;

Line 3963: ELSIF (p_calendar_type = MSC_CALENDAR.VIC) THEN

3959:
3960: END IF;
3961:
3962: -- case 3. Searching for valid Intransit Calendar (VIC)
3963: ELSIF (p_calendar_type = MSC_CALENDAR.VIC) THEN
3964:
3965: -- Bug 3647208 - Move the check inside individual "IF"s
3966: IF MSC_ATP_PVT.G_USE_SHIP_REC_CAL='Y' THEN
3967: -- l_calendar_code is already initialized to FOC

Line 3994: IF (p_calendar_type = MSC_CALENDAR.ORC OR p_calendar_type = MSC_CALENDAR.OSC) THEN

3990:
3991: EXCEPTION
3992: WHEN NO_DATA_FOUND THEN
3993: -- Bug 3449812 - Added support for ORC for ISOs
3994: IF (p_calendar_type = MSC_CALENDAR.ORC OR p_calendar_type = MSC_CALENDAR.OSC) THEN
3995: -- Return OMC.
3996: SELECT calendar_code
3997: INTO l_calendar_code
3998: FROM MTL_PARAMETERS

Line 4030: IF (p_calendar_code = MSC_CALENDAR.FOC) THEN

4026: --RETURN NULL; bug3583705
4027: RAISE MSC_ATP_PVT.NO_MATCHING_DATE_IN_CAL;
4028: END IF;
4029:
4030: IF (p_calendar_code = MSC_CALENDAR.FOC) THEN
4031: RETURN p_calendar_date;
4032: END IF;
4033:
4034: BEGIN

Line 4045: IF MSC_CALENDAR.G_RETAIN_DATE = 'Y' THEN

4041: AND CALENDAR_DATE = TRUNC(p_calendar_date);
4042:
4043: EXCEPTION
4044: WHEN NO_DATA_FOUND THEN --bug3583705
4045: IF MSC_CALENDAR.G_RETAIN_DATE = 'Y' THEN
4046: BEGIN
4047: SELECT min(calendar_date), max(calendar_date)
4048: INTO l_first_work_day, l_last_work_day
4049: FROM BOM_CALENDAR_DATES

Line 4088: IF (p_calendar_code = MSC_CALENDAR.FOC) THEN

4084: --RETURN NULL; bug3583705
4085: RAISE MSC_ATP_PVT.NO_MATCHING_DATE_IN_CAL;
4086: END IF;
4087:
4088: IF (p_calendar_code = MSC_CALENDAR.FOC) THEN
4089: RETURN p_calendar_date;
4090: END IF;
4091:
4092: BEGIN

Line 4103: IF MSC_CALENDAR.G_RETAIN_DATE = 'Y' THEN

4099: AND CALENDAR_DATE = TRUNC(p_calendar_date);
4100:
4101: EXCEPTION
4102: WHEN NO_DATA_FOUND THEN --bug3583705
4103: IF MSC_CALENDAR.G_RETAIN_DATE = 'Y' THEN
4104: BEGIN
4105: SELECT min(calendar_date), max(calendar_date)
4106: INTO l_first_work_day, l_last_work_day
4107: FROM BOM_CALENDAR_DATES

Line 4151: IF (p_days_offset = 0) and (p_calendar_code = MSC_CALENDAR.FOC) THEN

4147: --RETURN NULL; bug3583705
4148: RAISE MSC_ATP_PVT.NO_MATCHING_DATE_IN_CAL;
4149: END IF;
4150:
4151: IF (p_days_offset = 0) and (p_calendar_code = MSC_CALENDAR.FOC) THEN
4152: RETURN p_calendar_date;
4153: ELSIF (p_days_offset = 0) and (p_offset_type = -1) THEN
4154: l_offsetted_day := MSC_SATP_FUNC.SRC_PREV_WORK_DAY(
4155: p_calendar_code,

Line 4168: IF p_calendar_code = MSC_CALENDAR.FOC THEN

4164: ELSE
4165: l_days_offset := FLOOR(p_days_offset);
4166: END IF;
4167:
4168: IF p_calendar_code = MSC_CALENDAR.FOC THEN
4169: RETURN p_calendar_date + l_days_offset;
4170: END IF;
4171:
4172: IF p_days_offset > 0 THEN

Line 4187: IF MSC_CALENDAR.G_RETAIN_DATE = 'Y' THEN

4183: --AND cal2.seq_num = cal1.next_seq_num + l_days_offset;
4184:
4185: EXCEPTION
4186: WHEN NO_DATA_FOUND THEN --bug3583705
4187: IF MSC_CALENDAR.G_RETAIN_DATE = 'Y' THEN
4188: BEGIN
4189: SELECT min(calendar_date), max(calendar_date)
4190: INTO l_first_work_day, l_last_work_day
4191: FROM BOM_CALENDAR_DATES

Line 4226: IF MSC_CALENDAR.G_RETAIN_DATE = 'Y' THEN

4222: --AND cal2.seq_num = cal1.prior_seq_num + l_days_offset;
4223:
4224: EXCEPTION
4225: WHEN NO_DATA_FOUND THEN --bug3583705
4226: IF MSC_CALENDAR.G_RETAIN_DATE = 'Y' THEN
4227: BEGIN
4228: SELECT min(calendar_date), max(calendar_date)
4229: INTO l_first_work_day, l_last_work_day
4230: FROM BOM_CALENDAR_DATES

Line 4284: IF p_first_cal_code = MSC_CALENDAR.FOC THEN

4280: msc_sch_wb.atp_debug (' Days Offset : ' || p_offset_days );
4281: msc_sch_wb.atp_debug (' ');
4282: END IF;
4283: -- First date is computed using p_input_date, first calendar and its validation_type
4284: IF p_first_cal_code = MSC_CALENDAR.FOC THEN
4285: l_first_date := p_input_date;
4286: ELSIF p_first_cal_validation_type = -1 THEN
4287: l_first_date := MSC_SATP_FUNC.SRC_PREV_WORK_DAY(
4288: p_first_cal_code,

Line 4303: IF (p_offset_days = 0) and (p_second_cal_code = MSC_CALENDAR.FOC) THEN

4299: msc_sch_wb.atp_debug (' Date after validation on first cal: ' || l_first_date );
4300: END IF;
4301:
4302: -- Second date is computed using first date, 2nd calendar and offset days
4303: IF (p_offset_days = 0) and (p_second_cal_code = MSC_CALENDAR.FOC) THEN
4304: l_second_date := l_first_date;
4305: ELSIF (p_offset_days = 0) and (p_second_cal_validation_type = -1) THEN
4306: l_second_date := MSC_SATP_FUNC.SRC_PREV_WORK_DAY(
4307: p_second_cal_code,

Line 4313: ELSIF p_second_cal_code = MSC_CALENDAR.FOC THEN

4309: ELSIF (p_offset_days = 0) and (p_second_cal_validation_type = 1) THEN
4310: l_second_date := MSC_SATP_FUNC.SRC_NEXT_WORK_DAY(
4311: p_second_cal_code,
4312: l_first_date);
4313: ELSIF p_second_cal_code = MSC_CALENDAR.FOC THEN
4314: l_second_date := l_first_date + p_offset_days;
4315: ELSIF p_offset_days > 0 THEN
4316: ---Bug 6625744 start---
4317: l_first_date:=MSC_SATP_FUNC.SRC_NEXT_WORK_DAY(

Line 4346: IF p_third_cal_code = MSC_CALENDAR.FOC THEN

4342: msc_sch_wb.atp_debug (' Date after offset using second cal: ' || l_second_date );
4343: END IF;
4344:
4345: -- Third date = Output Date is computed using 2nd date, 3rd calendar and validation_type
4346: IF p_third_cal_code = MSC_CALENDAR.FOC THEN
4347: l_output_date := l_second_date;
4348: ELSIF p_third_cal_validation_type = -1 THEN
4349: l_output_date := MSC_SATP_FUNC.SRC_PREV_WORK_DAY(
4350: p_third_cal_code,