PACKAGE: APPS.MSC_ANALYSIS_SAFETY_STOCK_PERF

Source

1 PACKAGE MSC_ANALYSIS_SAFETY_STOCK_PERF 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;