APPS.MSC_WS_APS_DATA_SERVICES dependencies on MSC_SAFETY_STOCKS

Line 1785: -- Desc: insert a safety stock into msc_safety_stocks.

1781: raise;
1782: END ValidateProjectDate;
1783:
1784: -- =============================================================
1785: -- Desc: insert a safety stock into msc_safety_stocks.
1786: --
1787: -- Input:
1788: -- PlanId Scenario Id.
1789: -- SafetyStockData A safety stock.

Line 1799: INSERT INTO msc_safety_stocks

1795: SafetyStockData IN MscSafetyStockRec
1796: ) AS
1797: BEGIN
1798: BEGIN
1799: INSERT INTO msc_safety_stocks
1800: (
1801: plan_id, organization_id, sr_instance_id, inventory_item_id,
1802: period_start_date, safety_stock_quantity,
1803: last_update_date, last_updated_by, creation_date, created_by,

Line 1836: -- Desc: update a safety stock in msc_safety_stocks.

1832:
1833: END InsertSafetyStock;
1834:
1835: -- =============================================================
1836: -- Desc: update a safety stock in msc_safety_stocks.
1837: --
1838: -- Input:
1839: -- PlanId Scenario Id.
1840: -- SafetyStockData A safety stock.

Line 1849: UPDATE msc_safety_stocks

1845: PlanId IN NUMBER,
1846: SafetyStockData IN MscSafetyStockRec
1847: ) AS
1848: BEGIN
1849: UPDATE msc_safety_stocks
1850: SET
1851: safety_stock_quantity = SafetyStockData.SafetyStockQty,
1852: last_update_date = sysdate,
1853: last_updated_by = g_UserId,

Line 2003: -- stock into msc_safety_stocks table.

1999: RETURN 'INVALID_TOTAL_UNPOOLED_SS';
2000: END IF;
2001:
2002: -- All parametera pass the validation, insert/update the safety
2003: -- stock into msc_safety_stocks table.
2004: InsertSafetyStock(PlanId, SafetyStockData);
2005:
2006: RETURN 'OK';
2007:

Line 2069: 'FROM msc_safety_stocks ' ||

2065: 'mfg_ltvar_ss_percent, ' ||
2066: 'transit_ltvar_ss_percent, ' ||
2067: 'sup_ltvar_ss_percent, ' ||
2068: 'total_unpooled_safety_stock ' ||
2069: 'FROM msc_safety_stocks ' ||
2070: 'WHERE ' ||
2071: WhereClause;
2072:
2073: /*

Line 2663: -- Desc: Upload safety stocks into msc_safety_stocks table.

2659: END DOWNLOAD_FORECAST;
2660:
2661:
2662: -- =============================================================
2663: -- Desc: Upload safety stocks into msc_safety_stocks table.
2664: --
2665: -- Input:
2666: -- UserName User name.
2667: -- RespName Responsibility name.

Line 2676: -- msc_safety_stocks for plan_id + SrInstanceId + OrganizationId + ItemId

2672: -- OwningOrgId Owning organization id for the plan.
2673: -- SrInstanceId Source instance id.
2674: -- PurgeAllFlag Allowed input is Y or N.
2675: -- If this parameter is set to Y, this operation will delete
2676: -- msc_safety_stocks for plan_id + SrInstanceId + OrganizationId + ItemId
2677: -- before any upload data is inserted/updated.
2678: -- SafetyStockTbl List of safety stocks to be uploaded to ms_safety_stocks.
2679: -- OrganizationId Oragnization id.
2680: -- SrInstanceId Source instance id.

Line 2786: -- if PurgeAllFlag is set, purge all rows in msc_safety_stocks table for l_PlanId.

2782: Status := 'NO_DATA';
2783: RETURN;
2784: END IF;
2785:
2786: -- if PurgeAllFlag is set, purge all rows in msc_safety_stocks table for l_PlanId.
2787: IF MSC_WS_COMMON.BOOL_TO_NUMBER(PurgeAllFlag) = MSC_UTIL.SYS_YES THEN
2788: BEGIN
2789: DELETE FROM msc_safety_stocks
2790: WHERE

Line 2789: DELETE FROM msc_safety_stocks

2785:
2786: -- if PurgeAllFlag is set, purge all rows in msc_safety_stocks table for l_PlanId.
2787: IF MSC_WS_COMMON.BOOL_TO_NUMBER(PurgeAllFlag) = MSC_UTIL.SYS_YES THEN
2788: BEGIN
2789: DELETE FROM msc_safety_stocks
2790: WHERE
2791: plan_id = l_PlanId;
2792: EXCEPTION WHEN others THEN
2793: g_ErrorCode := 'ERROR_UNEXPECTED_02034';