[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