1 PACKAGE OCM_RECOMMENDATIONS_PUB AUTHID CURRENT_USER AS
2 /*$Header: ARCMRECS.pls 120.2 2006/06/30 22:07:23 bsarkar noship $ */
3 /*#
4 * This API returns a list credit recommendations based on a credit request ID or
5 * case folder ID.
6 * @rep:scope public
7 * @rep:doccd 120ocmug.pdf Credit Request Credit Management API User Notes, Oracle credit Management User Guide
8 * @rep:product OCM
9 * @rep:lifecycle active
10 * @rep:displayname Get Recommendations
11 * @rep:category BUSINESS_ENTITY OCM_RECOMMENDATIONS
12 */
13 /*#
14 * Use this procedure to get a list of credit recommendations
15 * @rep:scope public
16 * @rep:lifecycle active
17 * @rep:displayname Get Recommendations
18 */
19
20 /*
21 This procedure returs nlist of recommendations attached to a case folder.
22 Either a credit_request_id or case_folder_id is required. If both are passed,
23 then please make sure the combination exists.
24
25 */
26
27 TYPE recommendations_rec IS RECORD (
28 recommendation_id NUMBER,
29 credit_request_id NUMBER,
30 case_folder_id NUMBER,
31 credit_recommendation VARCHAR2(30),
32 recommendation_value1 VARCHAR2(60),
33 recommendation_value2 VARCHAr2(60),
34 status VARCHAR2(15),
35 credit_type VARCHAr2(30),
36 recommendation_name VARCHAR2(60),
37 appealed_flag VARCHAR2(1) );
38
39 TYPE recommendations_tbl IS TABLE OF recommendations_rec
40 INDEX BY BINARY_INTEGER;
41
42
43 TYPE appealing_reco_rec IS RECORD (
44 recommendation_id NUMBER ,
45 credit_recommendation VARCHAR2(30) default null,
46 recommendation_name VARCHAR2(60) default null );
47
48 TYPE appealing_reco_tbl IS TABLE OF appealing_reco_rec
49 INDEX BY BINARY_INTEGER;
50
51 /************************************************************************
52 ** The API lists all the recommendations based on credit_request_id or
53 ** case_folder_id.
54 ** The API needs either case_folder_id or credit_request_id to return all the
55 ** recommendations. Neither is supplied, the API will raise an errorthe API will raise an error
56 ** Based on the appealed_flag the recommendations will be returned.
57 ** By default the flag is 'N'.
58 *************************************************************************/
59 PROCEDURE get_recommendations (
60 p_api_version IN NUMBER DEFAULT 1.0,
61 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
62 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
63 p_validation_level IN VARCHAR2 DEFAULT NULL,
64 p_credit_request_id IN NUMBER DEFAULT NULL,
65 p_case_folder_id IN NUMBER DEFAULT NULL,
66 p_appealed_flag IN VARCHAR2 DEFAULT 'N',
67 p_recommendations_tbl OUT NOCOPY recommendations_tbl,
68 x_return_status OUT NOCOPY VARCHAR2,
69 x_msg_count OUT NOCOPY NUMBER,
70 x_msg_data OUT NOCOPY VARCHAR2 );
71
72 /************************************************************************
73 ** The API will mark individual recommendations as appealed.
74 ** The API requires either case_folder_id,credit_request_id or appealing_reco_tble
75 ** to be populated. If appealing_reco_tbls is null then the API will mark
76 ** all recommendations based on credit_request_id and case_folder_id.
77 *************************************************************************/
78 /*#
79 * Use this procedure to mark individual recommendations for appealing.
80 * @rep:scope public
81 * @rep:lifecycle active
82 * @rep:displayname Mark Appeal
83 */
84
85 PROCEDURE mark_appeal (
86 p_api_version IN NUMBER DEFAULT 1.0,
87 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
88 p_commit IN VARCHAR2 := FND_API.G_FALSE,
89 p_validation_level IN VARCHAR2 DEFAULT NULL,
90 p_credit_request_id IN NUMBER DEFAULT NULL,
91 p_case_folder_id IN NUMBER DEFAULT NULL ,
92 p_appealing_reco_tbl IN appealing_reco_tbl,
93 x_return_status OUT NOCOPY VARCHAR2,
94 x_msg_count OUT NOCOPY NUMBER,
95 x_msg_data OUT NOCOPY VARCHAR2 ) ;
96
97 END OCM_RECOMMENDATIONS_PUB;