1 PACKAGE OCM_DATA_POINTS_PUB AS
2 /*$Header: ARCMLDPS.pls 120.2 2006/06/30 22:05:38 bsarkar noship $ */
3 /*#
4 * This API returns the list of data points for a given credit classification,
5 * review type, data point category or data point subcategory.
6 * @rep:scope public
7 * @rep:doccd 120ocmug.pdf Credit Management API User Notes, Oracle Credit Management User Guide
8 * @rep:product OCM
9 * @rep:lifecycle active
10 * @rep:displayname Get Data Points
11 * @rep:category BUSINESS_ENTITY OCM_GET_DATA_POINTS
12 */
13
14
15 TYPE data_points_rec IS RECORD (
16 DATA_POINT_ID NUMBER(15) DEFAULT NULL,
17 DATA_POINT_CODE VARCHAR2(60) DEFAULT NULL,
18 DATA_POINT_NAME VARCHAR2(60) DEFAULT NULL,
19 DATA_POINT_CATEGORY VARCHAR2(30) DEFAULT NULL,
20 DESCRIPTION VARCHAR2(120) DEFAULT NULL,
21 SCORABLE_FLAG VARCHAR2(1) DEFAULT NULL,
22 APPLICATION_ID NUMBER(15) DEFAULT NULL,
23 PACKAGE_NAME VARCHAR2(60) DEFAULT NULL,
24 FUNCTION_NAME VARCHAR2(60) DEFAULT NULL,
25 PARENT_DATA_POINT_ID NUMBER(15) DEFAULT NULL,
26 DATA_POINT_SUB_CATEGORY VARCHAR2(30) DEFAULT NULL,
27 FUNCTION_TYPE VARCHAR2(10) DEFAULT NULL,
28 RETURN_DATA_TYPE VARCHAR2(30) DEFAULT NULL,
29 RETURN_DATE_FORMAT VARCHAR2(60) DEFAULT NULL
30 );
31
32 TYPE data_points_tbl IS TABLE OF data_points_rec
33 INDEX BY BINARY_INTEGER;
34
35 /***********************************************************************
36 ** The procedure will return a list of all data points that belong to
37 ** a checklist. Credit_classification and review_type are mandatory parameters.
38 ** If a checklist does not exist, the procedure will raise an error.
39 ** If data_point_category
40 ** (like CREDIT, REFERENCE, etc) or data_point_sub_category(user-defined based
41 ** on lookup types OCM_USER_DATA_POINT_CATEGORIES) has been passed, then
42 ** data points will be filtered based on these values.
43 ************************************************************************/
44
45 PROCEDURE GET_DATA_POINTS (
46 p_api_version IN NUMBER DEFAULT 1.0,
47 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
48 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
49 p_validation_level IN VARCHAR2,
50 p_credit_classification IN VARCHAR2,
51 p_review_type IN VARCHAR2,
52 p_data_point_category IN VARCHAR2 DEFAULT NULL,
53 p_data_point_sub_category IN VARCHAR2 DEFAULT NULL,
54 x_return_status OUT NOCOPY VARCHAR2,
55 x_msg_count OUT NOCOPY NUMBER,
56 x_msg_data OUT NOCOPY VARCHAR2,
57 p_datapoints_tbl OUT NOCOPY data_points_tbl );
58
59
60 END OCM_DATA_POINTS_PUB;