[Home] [Help]
57: entity NUMBER;
58: dummy NUMBER;
59:
60: BEGIN
61: -- Check mrp_forecast_designators table
62: entity := 1;
63:
64: SELECT 1
65: INTO dummy
64: SELECT 1
65: INTO dummy
66: FROM dual
67: WHERE NOT EXISTS (SELECT 1
68: FROM mrp_forecast_designators
69: WHERE forecast_designator = X_schedule_designator
70: AND organization_id = X_organization_id);
71:
72: -- Check mrp_designators table