APPS.MRP_FORECAST dependencies on MRP_CALENDAR

Line 48: mrp_calendar.select_calendar_defaults(arg_org_id,

44: var_item_cost NUMBER;
45: var_first_bucket_workday DATE;
46:
47: BEGIN
48: mrp_calendar.select_calendar_defaults(arg_org_id,
49: var_calendar_code, var_exception_set_id);
50:
51: BEGIN
52: SELECT NVL(item_cost,0)

Line 118: var_end_date := mrp_calendar.date_offset(arg_org_id,

114: var_org_id;
115:
116: IF FORECAST_RECORDS%FOUND THEN -- fetch succeed
117:
118: var_end_date := mrp_calendar.date_offset(arg_org_id,
119: var_bucket_type , var_rate_end_date, 1);
120:
121: var_bucket_start_date := mrp_calendar.prev_work_day(arg_org_id,
122: var_bucket_type, var_start_date);

Line 121: var_bucket_start_date := mrp_calendar.prev_work_day(arg_org_id,

117:
118: var_end_date := mrp_calendar.date_offset(arg_org_id,
119: var_bucket_type , var_rate_end_date, 1);
120:
121: var_bucket_start_date := mrp_calendar.prev_work_day(arg_org_id,
122: var_bucket_type, var_start_date);
123:
124: var_begin_date := mrp_calendar.prev_work_day(arg_org_id,
125: var_bucket_type, var_fc_begin_date);

Line 124: var_begin_date := mrp_calendar.prev_work_day(arg_org_id,

120:
121: var_bucket_start_date := mrp_calendar.prev_work_day(arg_org_id,
122: var_bucket_type, var_start_date);
123:
124: var_begin_date := mrp_calendar.prev_work_day(arg_org_id,
125: var_bucket_type, var_fc_begin_date);
126:
127: IF arg_past_due <> SYS_YES AND var_end_date <= var_begin_date THEN
128: GOTO get_item_loop;

Line 139: | to mrp_calendar.next_work_day. If the first day of the|

135: | not be a workday. In this case, a quantity is |
136: | seen for that day because we were starting with |
137: | the first day of the forecast. |
138: | Fix: Added a variable, var_first_bucket_workday, and a call |
139: | to mrp_calendar.next_work_day. If the first day of the|
140: | forecast is a workday, it will just return that day, |
141: | otherwise, the next valid workday is returned. |
142: +--------------------------------------------------------------*/
143: var_first_bucket_workday := mrp_calendar.next_work_day(arg_org_id,

Line 143: var_first_bucket_workday := mrp_calendar.next_work_day(arg_org_id,

139: | to mrp_calendar.next_work_day. If the first day of the|
140: | forecast is a workday, it will just return that day, |
141: | otherwise, the next valid workday is returned. |
142: +--------------------------------------------------------------*/
143: var_first_bucket_workday := mrp_calendar.next_work_day(arg_org_id,
144: 1,var_start_date);
145: var_temp_date := var_first_bucket_workday;
146:
147: <>

Line 149: var_bucket_end_date := mrp_calendar.date_offset(arg_org_id,

145: var_temp_date := var_first_bucket_workday;
146:
147: <>
148: WHILE(var_temp_date < var_end_date) LOOP
149: var_bucket_end_date := mrp_calendar.date_offset(arg_org_id,
150: var_bucket_type, var_temp_date, 1);
151: var_bucket_start_date := mrp_calendar.next_work_day(arg_org_id,
152: 1,var_bucket_start_date);
153: var_bucket_end_date := mrp_calendar.next_work_day(arg_org_id,

Line 151: var_bucket_start_date := mrp_calendar.next_work_day(arg_org_id,

147: <>
148: WHILE(var_temp_date < var_end_date) LOOP
149: var_bucket_end_date := mrp_calendar.date_offset(arg_org_id,
150: var_bucket_type, var_temp_date, 1);
151: var_bucket_start_date := mrp_calendar.next_work_day(arg_org_id,
152: 1,var_bucket_start_date);
153: var_bucket_end_date := mrp_calendar.next_work_day(arg_org_id,
154: 1,var_bucket_end_date);
155:

Line 153: var_bucket_end_date := mrp_calendar.next_work_day(arg_org_id,

149: var_bucket_end_date := mrp_calendar.date_offset(arg_org_id,
150: var_bucket_type, var_temp_date, 1);
151: var_bucket_start_date := mrp_calendar.next_work_day(arg_org_id,
152: 1,var_bucket_start_date);
153: var_bucket_end_date := mrp_calendar.next_work_day(arg_org_id,
154: 1,var_bucket_end_date);
155:
156: IF (var_bucket_type = TYPE_DAILY_BUCKET) THEN
157: var_days_in_bucket := 1;

Line 159: var_days_in_bucket := mrp_calendar.days_between(arg_org_id,

155:
156: IF (var_bucket_type = TYPE_DAILY_BUCKET) THEN
157: var_days_in_bucket := 1;
158: ELSE
159: var_days_in_bucket := mrp_calendar.days_between(arg_org_id,
160: TYPE_DAILY_BUCKET, var_bucket_start_date,
161: var_bucket_end_date);
162: END IF;
163:

Line 211: var_next_date := mrp_calendar.next_work_day(arg_org_id,

207: var_rep_orig_qty,
208: var_rep_orig_qty - var_rep_curr_qty,
209: arg_forecast_designator); /* (added for web inquiries) */
210:
211: var_next_date := mrp_calendar.next_work_day(arg_org_id,
212: 1, var_curr_date+1);
213: var_curr_date := var_next_date;
214: EXIT WHEN var_curr_date >= var_bucket_end_date;
215: END LOOP;

Line 690: var_start_date := mrp_calendar.prev_work_day(arg_org_id,

686: var_forecast_designator VARCHAR(10);
687: var_start_date DATE;
688: var_bucket_start_date DATE;
689: BEGIN
690: var_start_date := mrp_calendar.prev_work_day(arg_org_id,
691: 1, arg_start_date);
692:
693: var_bucket_start_date := mrp_calendar.prev_work_day(arg_org_id,
694: arg_bucket_type, arg_start_date);

Line 693: var_bucket_start_date := mrp_calendar.prev_work_day(arg_org_id,

689: BEGIN
690: var_start_date := mrp_calendar.prev_work_day(arg_org_id,
691: 1, arg_start_date);
692:
693: var_bucket_start_date := mrp_calendar.prev_work_day(arg_org_id,
694: arg_bucket_type, arg_start_date);
695:
696: -- entry mode, show entries associate with the specific forecast
697: -- or forecast set.