1 PACKAGE CN_Rule_PUB AUTHID CURRENT_USER AS
2 --$Header: cnprules.pls 120.2 2005/08/25 23:37:34 rramakri noship $
3 TYPE rule_rec_type IS RECORD
4 (ruleset_name cn_rulesets.name%TYPE,
5 start_date cn_rulesets.start_date%TYPE,
6 end_date cn_rulesets.end_date%TYPE,
7 rule_name cn_rules.name%TYPE,
8 parent_rule_name cn_rules.name%TYPE,
9 revenue_class_name cn_revenue_classes.name%TYPE,
10 expense_ccid cn_rules.expense_ccid%TYPE,
11 liability_ccid cn_rules.liability_ccid%TYPE,
12 org_id cn_rules.org_id%TYPE
13 );
14
15 -- Start of comments
16 -- API name : Create_Rule
17 -- Type : Private
18 -- Function : This Private API can be used to create a rule
19 -- Pre-reqs : None.
20 -- Parameters :
21 -- IN : p_api_version IN NUMBER Required
22 -- p_init_msg_list IN VARCHAR2 Optional
23 -- Default = FND_API.G_FALSE
24 -- p_commit IN VARCHAR2 Optional
25 -- Default = FND_API.G_FALSE
26 -- p_validation_level IN NUMBER Optional
27 -- Default = FND_API.G_VALID_LEVEL_FULL
28 -- p_rule_rec_type IN
29 -- CN_Rule_PUB.rule_rec_type
30 --
31 -- OUT : x_return_status OUT VARCHAR2(1)
32 -- x_msg_count OUT NUMBER
33 -- x_msg_data OUT VARCHAR2(2000)
34 --
35 -- Version : Current version 1.0
36 -- 25-Mar-99 Renu Chintalapati
37 -- previous version y.y
38 -- Changed....
39 -- Initial version 1.0
40 -- 25-Mar-99 Renu Chintalapati
41 --
42 -- Notes : Note text
43 --
44 -- End of comments
45
46 PROCEDURE Create_Rule
47 ( p_api_version IN NUMBER,
48 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
49 p_commit IN VARCHAR2 := FND_API.G_FALSE,
50 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
51 x_return_status OUT NOCOPY VARCHAR2,
52 x_msg_count OUT NOCOPY NUMBER,
53 x_msg_data OUT NOCOPY VARCHAR2,
54 x_loading_status OUT NOCOPY VARCHAR2,
55 p_rule_rec IN OUT NOCOPY CN_Rule_PUB.rule_rec_type
56 );
57
58 -- Start of comments
59 -- API name : Update_Rule
60 -- Type : Private
61 -- Function : This Public API can be used to update a rule
62 -- Pre-reqs : None.
63 -- Parameters :
64 -- IN : p_api_version IN NUMBER Required
65 -- p_init_msg_list IN VARCHAR2 Optional
66 -- Default = FND_API.G_FALSE
67 -- p_commit IN VARCHAR2 Optional
68 -- Default = FND_API.G_FALSE
69 -- p_validation_level IN NUMBER Optional
70 -- Default = FND_API.G_VALID_LEVEL_FULL
71 -- p_rule_rec_type IN
72 -- CN_Rule_PUB.rule_rec_type
73 --
74 -- OUT : x_return_status OUT VARCHAR2(1)
75 -- x_msg_count OUT NUMBER
76 -- x_msg_data OUT VARCHAR2(2000)
77 --
78 -- Version : Current version 1.0
79 -- 25-Mar-99 Renu Chintalapati
80 -- previous version y.y
81 -- Changed....
82 -- Initial version 1.0
83 -- 25-Mar-99 Renu Chintalapati
84 --
85 -- Notes : Note text
86 --
87 -- End of comments
88
89
90 PROCEDURE Update_Rule
91 ( p_api_version IN NUMBER,
92 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
93 p_commit IN VARCHAR2 := FND_API.G_FALSE,
94 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
95 x_return_status OUT NOCOPY VARCHAR2,
96 x_msg_count OUT NOCOPY NUMBER,
97 x_msg_data OUT NOCOPY VARCHAR2,
98 x_loading_status OUT NOCOPY VARCHAR2,
99 p_old_rule_rec IN OUT NOCOPY CN_Rule_PUB.rule_rec_type,
100 p_rule_rec IN OUT NOCOPY CN_Rule_PUB.rule_rec_type
101 );
102
103 -- Start of comments
104 -- API name : Delete_Rule
105 -- Type : Private
106 -- Function : This Public API can be used to delete a rule and
107 -- it's attributes from Oracle Sales Compensation.
108 -- Pre-reqs : None.
109 -- Parameters :
110 -- IN : p_api_version IN NUMBER Required
111 -- p_init_msg_list IN VARCHAR2 Optional
112 -- Default = FND_API.G_FALSE
113 -- p_commit IN VARCHAR2 Optional
114 -- Default = FND_API.G_FALSE
115 -- p_validation_level IN NUMBER Optional
116 -- Default = FND_API.G_VALID_LEVEL_FULL
117 -- p_rule_rec_type IN
118 -- CN_Rule_PUB.rule_rec_type
119 -- OUT : x_return_status OUT VARCHAR2(1)
120 -- x_msg_count OUT NUMBER
121 -- x_msg_data OUT VARCHAR2(2000)
122 --
123 -- Version : Current version 1.0
124 -- 25-Mar-99 Renu Chintalapati
125 -- previous version y.y
126 -- Changed....
127 -- Initial version 1.0
128 -- 25-Mar-99 Renu Chintalapati
129 --
130 -- Notes : Note text
131 --
132 -- End of comments
133
134 PROCEDURE Delete_Rule
135 ( p_api_version IN NUMBER,
136 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
137 p_commit IN VARCHAR2 := FND_API.G_FALSE,
138 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
139 x_return_status OUT NOCOPY VARCHAR2,
140 x_msg_count OUT NOCOPY NUMBER,
141 x_msg_data OUT NOCOPY VARCHAR2,
142 x_loading_status OUT NOCOPY VARCHAR2,
143 p_rule_name IN cn_rules.name%TYPE,
144 p_ruleset_name IN cn_rulesets.name%TYPE,
145 p_ruleset_start_date IN cn_rulesets.start_date%TYPE,
146 p_ruleset_end_date IN cn_rulesets.end_date%TYPE
147 ) ;
148
149 ---------------------------+
150 --
151 -- This is called from RuleLOV.java to display the entire hierarchy for the given rule
152 --
153 ---------------------------+
154 function getRuleHierStr
155 (p_rule_id NUMBER,
156 p_ruleset_id NUMBER)
157 RETURN VARCHAR2;
158
159 END CN_Rule_PUB;