APPS.MSC_X_RECEIVE_CAPACITY_PKG dependencies on MSC_CALENDAR

Line 436: from msc_calendar_dates

432:
433: begin
434: select sr_instance_id
435: into G_CAL_INSTANCE_ID
436: from msc_calendar_dates
437: where calendar_code = G_MSC_X_DEF_CALENDAR
438: and rownum = 1;
439: LOG_MESSAGE( 'Calendar from Profile: ' || G_MSC_X_DEF_CALENDAR);
440: LOG_MESSAGE( 'Instance id : ' || G_CAL_INSTANCE_ID);

Line 1085: -- of the calendar_code from msc_calendar_dates. The default calendar code for

1081: -- Reason: Example weekly bucket. If we bring in 7-0 calendar code capacity,
1082: -- when running a plan based on a 5-2 calendar code, then will be missing 2 days
1083: -- capacities in PWB.
1084: -- Solution: A new parameter for calendar code is introduced. This LOV is a list
1085: -- of the calendar_code from msc_calendar_dates. The default calendar code for
1086: -- this LOV is based on a production plan (from msc_designator where production = 1)
1087: -- If user not to choose any calendar code, or no calendar code is found, then
1088: -- we use the default 7-0 calendar.
1089: ---------------------------------------------------------------------------------

Line 1092: l_num_day := MSC_CALENDAR.calendar_days_between

1088: -- we use the default 7-0 calendar.
1089: ---------------------------------------------------------------------------------
1090:
1091: IF p_bucket_type = G_MONTH THEN --monthly bucket
1092: l_num_day := MSC_CALENDAR.calendar_days_between
1093: (lv_sr_instance_id,
1094: p_calendar_code,
1095: 1, --using '1' because need to find #days
1096: greatest(p_lv_start_date,sysdate),

Line 1100: l_num_day := MSC_CALENDAR.calendar_days_between

1096: greatest(p_lv_start_date,sysdate),
1097: p_lv_end_date);
1098:
1099: ELSIF p_bucket_type = G_WEEK then --weekly
1100: l_num_day := MSC_CALENDAR.calendar_days_between
1101: (lv_sr_instance_id,
1102: p_calendar_code,
1103: 1, --using '1' because need to find #days
1104: greatest(p_lv_start_date,sysdate),

Line 1124: l_next_work_date := MSC_CALENDAR.calendar_next_work_day(lv_sr_instance_id,

1120: /* if the Item Attribute Rounding flag is yes,
1121: the qty should be whole number
1122: */
1123:
1124: l_next_work_date := MSC_CALENDAR.calendar_next_work_day(lv_sr_instance_id,
1125: p_calendar_code,
1126: 1,
1127: l_from_date);
1128:

Line 1226: l_next_work_date := MSC_CALENDAR.calendar_next_work_day

1222:
1223: END IF;
1224:
1225: --log_message('l_from_date : ' ||l_from_date);
1226: l_next_work_date := MSC_CALENDAR.calendar_next_work_day
1227: (lv_sr_instance_id,
1228: p_calendar_code,
1229: 1,
1230: l_from_date);