DBA Data[Home] [Help]

PACKAGE: APPS.MSC_ANALYSIS_SAFETY_STOCK

Source


1 PACKAGE MSC_ANALYSIS_SAFETY_STOCK AS
2 /*  $Header: MSCASSS.pls 120.0 2005/05/25 19:34:55 appldev noship $ */
3 --
4 --
5 -- Purpose: populate a temp table with values displayed in
6 -- Inventory Optimization's Safety Stock and Service Level report
7 --
8 
9    PROCEDURE schedule_retrieve(query_id OUT NOCOPY NUMBER, plan_id IN VARCHAR2, org_id IN VARCHAR2, cat_id IN VARCHAR2,
10                               item_id IN NUMBER, customer_id IN NUMBER, customer_class_code IN VARCHAR2);
11    FUNCTION get_cat_set_id(arg_plan_id number) RETURN NUMBER;
12    FUNCTION get_customer_target_sl(customer_id NUMBER) RETURN NUMBER;
13 
14 END; -- Package spec