APPS.MRP_FORECAST dependencies on MRP_FORECAST

Line 1: PACKAGE BODY MRP_FORECAST AS

1: PACKAGE BODY MRP_FORECAST AS
2: /* $Header: MRFCSTBB.pls 115.6 2004/02/19 07:39:51 rgurugub ship $ */
3: TYPE_DAILY_BUCKET CONSTANT NUMBER := 1;
4: TYPE_WEEKLY_BUCKET CONSTANT NUMBER := 2;
5: TYPE_MONTHLY_BUCKET CONSTANT NUMBER := 3;

Line 67: mrp_forecast_designators desig

63: SELECT cal1.calendar_date
64: INTO var_fc_begin_date
65: FROM bom_calendar_dates cal1,
66: bom_calendar_dates cal2,
67: mrp_forecast_designators desig
68: WHERE cal1.seq_num =
69: cal2.prior_seq_num -
70: LEAST(NVL(desig.backward_update_time_fence, 0),
71: cal2.seq_num - 1)

Line 92: FROM mrp_forecast_dates

88: original_forecast_quantity,
89: forecast_designator,
90: NVL(bucket_type, 0),
91: arg_org_id
92: FROM mrp_forecast_dates
93: WHERE DECODE(arg_past_due, SYS_YES, arg_start_date,
94: DECODE(bucket_type, 1,
95: DECODE(rate_end_date, NULL,
96: forecast_date, rate_end_date), arg_start_date))

Line 752: FROM mrp_forecast_designators

748: ELSE
749: DECLARE
750: CURSOR FORECAST_DESIGS IS
751: SELECT forecast_designator
752: FROM mrp_forecast_designators
753: WHERE organization_id = arg_org_id
754: AND (forecast_set = arg_forecast_set
755: OR forecast_designator = arg_forecast_set);
756: BEGIN

Line 800: END MRP_FORECAST;

796: dbms_output.put_line(sqlerrm);
797: */
798: END BUCKET_ENTRIES;
799:
800: END MRP_FORECAST;