1 PACKAGE MSC_ANALYSIS_PKG AS
2 /* $Header: MSCANLSS.pls 120.2 2007/04/30 18:31:27 minduvad ship $ */
3
4 PROCEDURE populate_cost_savings(arg_ret_val IN OUT NOCOPY VARCHAR2,
5 arg_period_type IN VARCHAR2,
6 arg_detail_level IN VARCHAR2,
7 arg_viewby IN VARCHAR2,
8 arg_plan_list IN VARCHAR2,
9 arg_org_list IN VARCHAR2 DEFAULT NULL,
10 arg_category_list IN VARCHAR2 DEFAULT NULL,
11 arg_item_list IN VARCHAR2 DEFAULT NULL,
12 arg_date_list IN DATE DEFAULT NULL,
13 arg_round in NUMBER DEFAULT NULL);
14
15 PROCEDURE populate_srvlvl_breakdown(arg_ret_val IN OUT NOCOPY VARCHAR2,
16 arg_period_type IN VARCHAR2,
17 arg_detail_level IN VARCHAR2,
18 arg_viewby IN VARCHAR2,
19 arg_plan_list IN VARCHAR2,
20 arg_org_list IN VARCHAR2 DEFAULT NULL,
21 arg_category_list IN VARCHAR2 DEFAULT NULL,
22 arg_item_list IN VARCHAR2 DEFAULT NULL,
23 arg_demand_class_list IN VARCHAR2 DEFAULT NULL,
24 arg_year_from IN DATE DEFAULT NULL,
25 arg_year_to IN DATE DEFAULT NULL,
26 arg_date_list IN DATE DEFAULT NULL,
27 arg_round in NUMBER DEFAULT NULL);
28
29 PROCEDURE populate_cost_breakdown(arg_ret_val IN OUT NOCOPY VARCHAR2,
30 arg_period_type IN VARCHAR2,
31 arg_detail_level IN VARCHAR2,
32 arg_viewby IN VARCHAR2,
33 arg_plan_list IN VARCHAR2,
34 arg_org_list IN VARCHAR2 DEFAULT NULL,
35 arg_category_list IN VARCHAR2 DEFAULT NULL,
36 arg_item_list IN VARCHAR2 DEFAULT NULL,
37 arg_year_from IN DATE DEFAULT NULL,
38 arg_year_to IN DATE DEFAULT NULL,
39 arg_date_list IN DATE DEFAULT NULL,
40 arg_round in NUMBER DEFAULT NULL);
41
42 PROCEDURE populate_srvlvl_profit(arg_ret_val IN OUT NOCOPY VARCHAR2,
43 arg_period_type IN VARCHAR2,
44 arg_viewby IN VARCHAR2,
45 arg_plan_list IN VARCHAR2,
46 arg_round in NUMBER DEFAULT NULL);
47
48 function get_tp_cost ( arg_period_type IN VARCHAR2, arg_detail_level IN VARCHAR2,
49 arg_plan in number, arg_instance in number, arg_org in number,
50 arg_item in number, arg_detail_date date) return number;
51
52 procedure store_user_pref (p_plan_type varchar2);
53
54 FUNCTION get_cat_set_id(arg_plan_list varchar2) RETURN NUMBER;
55
56 function get_plan_service_level(p_plan_id number, p_type number,
57 p_instance_id in number default null, p_organization_id in number default null,
58 p_item_id in number default null,
59 p_start_date date default null, p_end_date date default null) return number;
60
61 function get_plan_dflt_value(p_plan_id number) return number;
62
63 FUNCTION get_num_periods(p_plan_id IN NUMBER, p_calendar_type IN NUMBER) RETURN NUMBER;
64
65 function get_dflt_value(p_plan_id number,
66 p_cate_set_id number default null,
67 p_definition_level number default null,
68 p_inst_id number default null, p_org_id number default null,
69 p_item_id number default null,
70 p_demand_class varchar2 default null,
71 p_customer_id number default null,
72 p_customer_site_id number default null,
73 p_cate_id number default null) return number;
74
75 END MSC_ANALYSIS_PKG;