[Home] [Help]
40: var_rowid ROWID;
41:
42: CURSOR form_query IS
43: SELECT number1, rowid
44: FROM mrp_form_query
45: WHERE query_id = arg_query_id1
46: ORDER BY date1;
47:
48: BEGIN
52: var_last_cal_date := mrp_calendar.next_work_day(arg_org_id,
53: TYPE_DAILY_BUCKET, arg_cutoff_date);
54:
55: --
56: -- Populate MRP_FORM_QUERY
57: --
58: -- The view MRP_DAILY_SCHEDULES_V has already:
59: --
60: -- - bucketed the discrete schedule entries into the correct
73:
74: --
75: -- Insert schedules in daily bucket
76: --
77: INSERT INTO mrp_form_query
78: (QUERY_ID,
79: LAST_UPDATE_DATE,
80: LAST_UPDATED_BY,
81: CREATION_DATE,
167: --
168: -- Insert schedules in weekly buckets for those weeks that have
169: -- entries
170: --
171: INSERT INTO mrp_form_query
172: (QUERY_ID,
173: LAST_UPDATE_DATE,
174: LAST_UPDATED_BY,
175: CREATION_DATE,
256: --
257: -- Outer-joined with BOM_CAL_WEEK_START_DATES to get those
258: -- weeks that do not have entries
259: --
260: INSERT INTO mrp_form_query
261: (QUERY_ID,
262: LAST_UPDATE_DATE,
263: LAST_UPDATED_BY,
264: CREATION_DATE,
291: NVL(SUM(query.number9), 0), -- orig: sales order
292: NVL(SUM(query.number11), 0), -- orig: exploded
293: NVL(SUM(query.number12), 0) -- orig: interorg order
294: FROM bom_cal_week_start_dates dates,
295: mrp_form_query query,
296: mtl_parameters param
297: WHERE param.organization_id = arg_org_id
298: AND param.calendar_exception_set_id = dates.exception_set_id
299: AND param.calendar_code = dates.calendar_code
312: --
313: -- Insert schedules in periodic buckets for those periods that have
314: -- entries
315: --
316: INSERT INTO mrp_form_query
317: (QUERY_ID,
318: LAST_UPDATE_DATE,
319: LAST_UPDATED_BY,
320: CREATION_DATE,
401: --
402: -- Outer-joined with BOM_PERIOD_START_DATES to get those
403: -- periods that do not have entries
404: --
405: INSERT INTO mrp_form_query
406: (QUERY_ID,
407: LAST_UPDATE_DATE,
408: LAST_UPDATED_BY,
409: CREATION_DATE,
436: NVL(SUM(query.number9), 0), -- orig: sales order
437: NVL(SUM(query.number11), 0), -- orig: exploded
438: NVL(SUM(query.number12), 0) -- orig: interorg order
439: FROM bom_period_start_dates dates,
440: mrp_form_query query,
441: mtl_parameters param
442: WHERE param.organization_id = arg_org_id
443: AND param.calendar_exception_set_id = dates.exception_set_id
444: AND param.calendar_code = dates.calendar_code
504:
505: --
506: -- Add the past due quantities to the start date bucket
507: --
508: UPDATE MRP_FORM_QUERY
509: SET NUMBER1 = NUMBER1 + var_tmp_quantity,
510: NUMBER5 = NUMBER5 + var_tmp_copied_sched,
511: NUMBER6 = NUMBER6 + var_tmp_mps_plan,
512: NUMBER7 = NUMBER7 + var_tmp_manual,
530: EXIT WHEN form_query%NOTFOUND;
531:
532: var_cum_quantity := var_cum_quantity + var_quantity;
533:
534: UPDATE mrp_form_query
535: SET number3 = var_cum_quantity
536: WHERE rowid = var_rowid;
537: END LOOP;
538:
545: PROCEDURE Get_Nextval( X_query_id1 IN OUT NOCOPY NUMBER,
546: X_query_id2 IN OUT NOCOPY NUMBER ) IS
547: BEGIN
548:
549: SELECT MRP_FORM_QUERY_S.NEXTVAL
550: INTO X_query_id1
551: FROM dual;
552:
553: SELECT MRP_FORM_QUERY_S.NEXTVAL
549: SELECT MRP_FORM_QUERY_S.NEXTVAL
550: INTO X_query_id1
551: FROM dual;
552:
553: SELECT MRP_FORM_QUERY_S.NEXTVAL
554: INTO X_query_id2
555: FROM dual;
556:
557: END Get_Nextval;