[Home] [Help]
PACKAGE: APPS.MST_CMP_KPIS
Source
1 PACKAGE MST_CMP_KPIS AUTHID CURRENT_USER AS
2 /* $Header: MSTCKPIS.pls 120.0 2005/05/26 17:59:58 appldev noship $ */
3
4 FUNCTION Cost_per_Unit_Weight( p_plan_id IN NUMBER,
5 p_level IN NUMBER,
6 p_customer_id IN NUMBER,
7 p_supplier_id IN NUMBER,
8 p_carrier_id IN NUMBER,
9 p_mode_of_transport IN VARCHAR2,
10 p_fac_loc_id IN NUMBER)
11 RETURN NUMBER;
12 -- (KPI - 38)
13
14 FUNCTION Cost_per_Unit_Volume( p_plan_id IN NUMBER,
15 p_level IN NUMBER,
16 p_customer_id IN NUMBER,
17 p_supplier_id IN NUMBER,
18 p_carrier_id IN NUMBER,
19 p_mode_of_transport IN VARCHAR2,
20 p_fac_loc_id IN NUMBER)
21 RETURN NUMBER;
22 -- (KPI - 39)
23
24 FUNCTION TL_Cost_per_Unit_Dist( p_plan_id IN NUMBER,
25 p_level IN NUMBER,
26 p_carrier_id IN NUMBER )
27 RETURN NUMBER;
28 -- (KPI - 40)
29
30 FUNCTION TL_Cost_per_Unit_Cube_Dist(p_plan_id IN NUMBER,
31 p_level IN NUMBER,
32 p_customer_id IN NUMBER,
33 p_supplier_id IN NUMBER,
34 p_carrier_id IN NUMBER,
35 p_fac_loc_id IN NUMBER)
36 RETURN NUMBER;
37 -- (KPI - 41)
38
39 FUNCTION TL_Cost_per_Unit_Wt_Dist(p_plan_id IN NUMBER,
40 p_level IN NUMBER,
41 p_customer_id IN NUMBER,
42 p_supplier_id IN NUMBER,
43 p_carrier_id IN NUMBER,
44 p_fac_loc_id IN NUMBER)
45 RETURN NUMBER;
46 -- (KPI - 42)
47
48 FUNCTION mst_performance_targets(p_target_level IN VARCHAR2,
49 p_dimension_id IN VARCHAR2 )
50 RETURN NUMBER;
51 END MST_CMP_KPIS;