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_SATP_FUNC

Line 1: PACKAGE BODY MSC_SATP_FUNC AS

1: PACKAGE BODY MSC_SATP_FUNC AS
2: /* $Header: MSCSATPB.pls 120.5.12010000.2 2009/08/24 06:58:11 sbnaik ship $ */
3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'MSC_SATP_FUNC';
4: G_INV_CTP NUMBER := FND_PROFILE.value('INV_CTP');
5:

Line 3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'MSC_SATP_FUNC';

1: PACKAGE BODY MSC_SATP_FUNC AS
2: /* $Header: MSCSATPB.pls 120.5.12010000.2 2009/08/24 06:58:11 sbnaik ship $ */
3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'MSC_SATP_FUNC';
4: G_INV_CTP NUMBER := FND_PROFILE.value('INV_CTP');
5:
6:
7: --Following Functions Are used for calculating delivery lead time on the source

Line 523: MSC_SATP_FUNC.Extend_Atp(x_atp_table, x_return_status, 1);

519: -- copy the p_index th elements in p_atp_table and append it to x_atp_table
520:
521: l_count := x_atp_table.Action.COUNT;
522:
523: MSC_SATP_FUNC.Extend_Atp(x_atp_table, x_return_status, 1);
524:
525: -- only under old OE we will have p_atp_table.Row_Id populated.
526:
527: IF p_atp_table.Row_Id.Exists(p_index) THEN

Line 1123: MSC_SATP_FUNC.Extend_Atp(x_atp_table, x_return_status, 1);

1119: END IF;
1120:
1121: FOR l_atp_count in 1..p_atp_table.Action.COUNT LOOP
1122:
1123: MSC_SATP_FUNC.Extend_Atp(x_atp_table, x_return_status, 1);
1124:
1125: x_atp_table.Row_Id(l_count + l_atp_count):= p_atp_table.Row_Id(l_atp_count);
1126: x_atp_table.Instance_Id(l_count + l_atp_count):=
1127: p_atp_table.Instance_Id(l_atp_count);

Line 2903: MSC_SATP_FUNC.Get_Regions_shipping (

2899: IF PG_DEBUG in ('Y', 'C') THEN
2900: msc_sch_wb.atp_debug ('Get_Regions API: API to Use : ' || l_api_to_use);
2901: END IF;
2902: if (l_api_to_use = 1) then
2903: MSC_SATP_FUNC.Get_Regions_shipping (
2904: p_customer_site_id,
2905: p_calling_module,
2906: p_instance_id,
2907: p_session_id,

Line 2916: MSC_SATP_FUNC.Get_Regions_Old (

2912: p_supplier_site_id, -- For supplier intransit LT project
2913: p_party_site_id ); --2814895
2914:
2915: else
2916: MSC_SATP_FUNC.Get_Regions_Old (
2917: p_customer_site_id,
2918: p_calling_module,
2919: p_instance_id,
2920: p_session_id,

Line 4154: l_offsetted_day := MSC_SATP_FUNC.SRC_PREV_WORK_DAY(

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,
4156: p_calendar_date);
4157: ELSIF (p_days_offset = 0) and (p_offset_type = +1) THEN --bug3558412
4158: l_offsetted_day := MSC_SATP_FUNC.SRC_NEXT_WORK_DAY(

Line 4158: l_offsetted_day := MSC_SATP_FUNC.SRC_NEXT_WORK_DAY(

4154: l_offsetted_day := MSC_SATP_FUNC.SRC_PREV_WORK_DAY(
4155: p_calendar_code,
4156: p_calendar_date);
4157: ELSIF (p_days_offset = 0) and (p_offset_type = +1) THEN --bug3558412
4158: l_offsetted_day := MSC_SATP_FUNC.SRC_NEXT_WORK_DAY(
4159: p_calendar_code,
4160: p_calendar_date);
4161: ELSE
4162: IF p_days_offset > 0 THEN

Line 4287: l_first_date := MSC_SATP_FUNC.SRC_PREV_WORK_DAY(

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,
4289: p_input_date);
4290: ELSIF p_first_cal_validation_type = 1 THEN
4291: l_first_date := MSC_SATP_FUNC.SRC_NEXT_WORK_DAY(

Line 4291: l_first_date := MSC_SATP_FUNC.SRC_NEXT_WORK_DAY(

4287: l_first_date := MSC_SATP_FUNC.SRC_PREV_WORK_DAY(
4288: p_first_cal_code,
4289: p_input_date);
4290: ELSIF p_first_cal_validation_type = 1 THEN
4291: l_first_date := MSC_SATP_FUNC.SRC_NEXT_WORK_DAY(
4292: p_first_cal_code,
4293: p_input_date);
4294: ELSE
4295: l_first_date := p_input_date;

Line 4306: l_second_date := MSC_SATP_FUNC.SRC_PREV_WORK_DAY(

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,
4308: l_first_date);
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(

Line 4310: l_second_date := MSC_SATP_FUNC.SRC_NEXT_WORK_DAY(

4306: l_second_date := MSC_SATP_FUNC.SRC_PREV_WORK_DAY(
4307: p_second_cal_code,
4308: l_first_date);
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;

Line 4317: l_first_date:=MSC_SATP_FUNC.SRC_NEXT_WORK_DAY(

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(
4318: p_second_cal_code,
4319: l_first_date);
4320: ---Bug 6625744 end---
4321: l_second_date := MSC_SATP_FUNC.SRC_DATE_OFFSET(

Line 4321: l_second_date := MSC_SATP_FUNC.SRC_DATE_OFFSET(

4317: l_first_date:=MSC_SATP_FUNC.SRC_NEXT_WORK_DAY(
4318: p_second_cal_code,
4319: l_first_date);
4320: ---Bug 6625744 end---
4321: l_second_date := MSC_SATP_FUNC.SRC_DATE_OFFSET(
4322: p_second_cal_code,
4323: l_first_date,
4324: p_offset_days,
4325: +1);

Line 4328: l_first_date:=MSC_SATP_FUNC.SRC_PREV_WORK_DAY(

4324: p_offset_days,
4325: +1);
4326: ELSIF p_offset_days < 0 THEN
4327: ---Bug 6625744 start---
4328: l_first_date:=MSC_SATP_FUNC.SRC_PREV_WORK_DAY(
4329: p_second_cal_code,
4330: l_first_date);
4331: ---Bug 6625744 end---
4332: l_second_date := MSC_SATP_FUNC.SRC_DATE_OFFSET(

Line 4332: l_second_date := MSC_SATP_FUNC.SRC_DATE_OFFSET(

4328: l_first_date:=MSC_SATP_FUNC.SRC_PREV_WORK_DAY(
4329: p_second_cal_code,
4330: l_first_date);
4331: ---Bug 6625744 end---
4332: l_second_date := MSC_SATP_FUNC.SRC_DATE_OFFSET(
4333: p_second_cal_code,
4334: l_first_date,
4335: p_offset_days,
4336: -1);

Line 4349: l_output_date := MSC_SATP_FUNC.SRC_PREV_WORK_DAY(

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,
4351: l_second_date);
4352: ELSIF p_third_cal_validation_type = 1 THEN
4353: l_output_date := MSC_SATP_FUNC.SRC_NEXT_WORK_DAY(

Line 4353: l_output_date := MSC_SATP_FUNC.SRC_NEXT_WORK_DAY(

4349: l_output_date := MSC_SATP_FUNC.SRC_PREV_WORK_DAY(
4350: p_third_cal_code,
4351: l_second_date);
4352: ELSIF p_third_cal_validation_type = 1 THEN
4353: l_output_date := MSC_SATP_FUNC.SRC_NEXT_WORK_DAY(
4354: p_third_cal_code,
4355: l_second_date);
4356: ELSE
4357: l_output_date := l_second_date;

Line 4586: END MSC_SATP_FUNC;

4582: /*--------------------------------------------------------------------------
4583: | End Procedure get_src_to_dstn_profiles added for Multiple allocation enh -3940999
4584: +-------------------------------------------------------------------------*/
4585:
4586: END MSC_SATP_FUNC;