1 PACKAGE MSC_ANALYSIS_SAFETY_STOCK_PERF AUTHID CURRENT_USER AS
2 /* $Header: MSCIORS.pls 120.1 2007/04/30 18:35:11 minduvad ship $ */
3
4 --
5 --
6 -- Purpose: populate a temp table with values displayed in
7 -- Inventory Optimization's Safety Stock and Service Level report
8 --
9
10 PROCEDURE schedule_details_sl(p_query_id OUT NOCOPY NUMBER, p_period_type NUMBER, plan_id IN VARCHAR2,
11 org_id IN VARCHAR2, cat_id IN VARCHAR2, p_item_id IN NUMBER, customer_id IN NUMBER,
12 customer_class_code IN VARCHAR2, p_abc_id IN VARCHAR2);
13
14 PROCEDURE schedule_details_ss(query_id OUT NOCOPY NUMBER, plan_id IN VARCHAR2, org_id IN VARCHAR2, cat_id IN VARCHAR2,
15 item_id IN NUMBER);
16
17 PROCEDURE schedule_details_iv(p_query_id OUT NOCOPY NUMBER, p_period_type IN NUMBER,
18 p_plan_id IN VARCHAR2, org_id IN VARCHAR2, cat_id IN VARCHAR2, p_abc_id IN VARCHAR2);
19
20 PROCEDURE schedule_aggregate(p_plan_id IN NUMBER);
21 FUNCTION get_cat_set_id(p_plan_id number) RETURN NUMBER;
22
23 END MSC_ANALYSIS_SAFETY_STOCK_PERF;