1 PACKAGE OCM_DATA_POINTS_PUB AUTHID CURRENT_USER AS
2 /*$Header: ARCMLDPS.pls 120.2.12010000.2 2009/05/14 13:35:23 mraymond ship $ */
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 * Use this procedure to return a list of all data points that belong
46 * to a given checklist. The list can be further filtered by
47 * category and subcategory.
48 * @rep:scope public
49 * @rep:lifecycle active
50 * @rep:displayname Get Checklist Data Points
51 */
52 PROCEDURE GET_DATA_POINTS (
53 p_api_version IN NUMBER DEFAULT 1.0,
54 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
55 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
56 p_validation_level IN VARCHAR2,
57 p_credit_classification IN VARCHAR2,
58 p_review_type IN VARCHAR2,
59 p_data_point_category IN VARCHAR2 DEFAULT NULL,
60 p_data_point_sub_category IN VARCHAR2 DEFAULT NULL,
61 x_return_status OUT NOCOPY VARCHAR2,
62 x_msg_count OUT NOCOPY NUMBER,
63 x_msg_data OUT NOCOPY VARCHAR2,
64 p_datapoints_tbl OUT NOCOPY data_points_tbl );
65
66
67 END OCM_DATA_POINTS_PUB;