1 PACKAGE IEX_METRIC_PVT AS
2 /* $Header: iexvmtrs.pls 120.3 2005/07/07 14:09:34 jypark noship $ */
3
4 TYPE Metric_ID_Tbl_Type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
5 TYPE Metric_Name_Tbl_Type IS TABLE OF VARCHAR2(45) INDEX BY BINARY_INTEGER;
6 TYPE Metric_Value_Tbl_Type IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
7 TYPE Metric_Rating_Tbl_Type IS TABLE OF VARCHAR2(10) INDEX BY BINARY_INTEGER;
8
9 PROCEDURE Get_Metric_Info
10 (p_api_version IN NUMBER := 1.0,
11 p_init_msg_list IN VARCHAR2,
12 p_commit IN VARCHAR2,
13 p_validation_level IN NUMBER,
14 x_return_status OUT NOCOPY VARCHAR2,
15 x_msg_count OUT NOCOPY NUMBER,
16 x_msg_data OUT NOCOPY VARCHAR2,
17 p_party_id IN NUMBER,
18 p_cust_account_id IN NUMBER,
19 p_customer_site_use_id IN NUMBER,
20 p_delinquency_id IN NUMBER,
21 p_filter_by_object IN VARCHAR2,
22 x_metric_id_tbl OUT NOCOPY Metric_ID_Tbl_Type,
23 x_metric_name_tbl OUT NOCOPY Metric_Name_Tbl_Type,
24 x_metric_value_tbl OUT NOCOPY Metric_Value_Tbl_Type,
25 x_metric_rating_tbl OUT NOCOPY Metric_Rating_tbl_Type);
26
27 PROCEDURE Test_Metric
28 (
29 p_filter_id IN NUMBER,
30 p_score_comp_type_id IN NUMBER,
31 x_return_status OUT NOCOPY VARCHAR2,
32 x_metric_value OUT NOCOPY VARCHAR2);
33 END;