[Home] [Help]
46: WHERE calendar_code = var_calendar_code
47: AND exception_set_id = var_exception_set_id
48: AND seq_num IS NOT NULL;
49:
50: DELETE FROM mrp_repetitive_periods
51: WHERE organization_id = arg_org_id;
52:
53: var_curr_date := param.repetitive_anchor_date;
54:
95:
96:
97: WHILE TRUE LOOP
98: -- Keep looping, until you reach the end of the calendar...for each
99: -- period, insert into the table mrp_repetitive_periods
100:
101: -- Get the current workday
102:
103: BEGIN
118: raise;
119: END;
120:
121: IF var_curr_workday <> var_prev_workday THEN
122: INSERT INTO mrp_repetitive_periods
123: (
124: period_start_date,
125: organization_id,
126: last_update_date,
200: -- We want to adjust all non-workday periods to the next valid workday.
201: -- However, we want to make sure that this does not result in duplicates.
202: -- Therefore only update those where a row does not exist for the next
203: -- workday. We'll delete those that are not updated in the next step.
204: UPDATE mrp_repetitive_periods s
205: SET period_start_date =
206: (SELECT next_date
207: FROM bom_calendar_dates
208: WHERE calendar_code = var_calendar_code
212: (SELECT NULL
213: FROM bom_calendar_dates d
214: WHERE NOT EXISTS
215: (SELECT NULL
216: FROM mrp_repetitive_periods
217: WHERE organization_id = s.organization_id
218: AND period_start_date = d.next_date)
219: AND seq_num IS NULL
220: AND calendar_code = var_calendar_code
221: AND exception_set_id = var_exception_set_id
222: AND calendar_date = s.period_start_date)
223: AND organization_id = arg_org_id;
224:
225: DELETE FROM mrp_repetitive_periods s
226: WHERE organization_id = arg_org_id
227: AND EXISTS
228: (SELECT NULL
229: FROM bom_calendar_dates d