[Home] [Help]
277: mrp_forecast_interface_pk.t_forecast_designator,
278: x_ReturnStatus OUT NOCOPY NUMBER)
279: IS
280: --
281: v_forecast_designator mrp_forecast_designators.forecast_designator%TYPE;
282: x_progress VARCHAR2(3) := '010';
283: v_InterfaceLineId NUMBER;
284: --
285: BEGIN
874: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
875: x_Group_rec IN rlm_dp_sv.t_Group_rec,
876: t_forecast IN OUT NOCOPY mrp_forecast_interface_pk.t_forecast_interface,
877: x_forecast_designator IN
878: mrp_forecast_designators.forecast_designator%TYPE)
879: IS
880:
881:
882: --
1505: END IF;
1506: --
1507: SELECT forecast_designator
1508: INTO x_ForecastDesignator
1509: FROM mrp_forecast_designators
1510: WHERE customer_id=NVL(x_ship_to_customer_id, x_customer_id)
1511: AND (bill_id = v_bill_site_id
1512: OR (bill_id IS NULL AND v_bill_site_id IS NULL))
1513: AND (ship_id = x_Ship_Site_Id
1535: /* To make match only at ShipTo level,additional check for NULL bill_id */
1536: --
1537: SELECT forecast_designator
1538: INTO x_ForecastDesignator
1539: FROM mrp_forecast_designators
1540: WHERE customer_id= nvl(x_ship_to_customer_id, x_customer_id)
1541: AND ship_id = x_Ship_Site_Id
1542: AND bill_id IS NULL
1543: AND organization_id = x_ShipFromOrgId
1566: BEGIN
1567: --
1568: SELECT forecast_designator
1569: INTO x_ForecastDesignator
1570: FROM mrp_forecast_designators
1571: WHERE customer_id= nvl(x_ship_to_customer_id, x_customer_id)
1572: AND ship_id IS NULL
1573: AND bill_id IS NULL
1574: AND organization_id = x_ShipFromOrgId
1608: BEGIN
1609: --{
1610: SELECT forecast_designator
1611: INTO x_ForecastDesignator
1612: FROM mrp_forecast_designators
1613: WHERE customer_id= x_customer_id
1614: AND ship_id IS NULL
1615: AND bill_id IS NULL
1616: AND organization_id = x_ShipFromOrgId