1 PACKAGE CN_RuleSet_PVT AUTHID CURRENT_USER AS
2 --$Header: cnvrsets.pls 120.2 2005/10/10 01:05:09 rramakri noship $
3 TYPE ruleset_rec_type IS RECORD
4 (ruleset_id cn_rulesets_all_b.ruleset_id%TYPE,
5 ruleset_name cn_rulesets_all_tl.name%TYPE,
6 module_type cn_rulesets_all_b.module_type%TYPE,
7 end_date cn_rulesets_all_b.end_date%TYPE,
8 start_date cn_rulesets_all_b.start_date%TYPE,
9 sync_flag VARCHAR2(02),
10 object_version_number NUMBER,
11 status cn_rulesets_all_b.ruleset_status%TYPE,
12 org_id number
13 );
14
15 -- NOTE : Due to a bug in FORMS 6.0.4, the record type cannot be initialized
16 -- with the defaults (fnd_api.g_miss_num etc. ) if this API is invoked
17 -- from forms. Hence this version does not initialize the variables
18
19 -- Start of comments
20 -- API name : Create_Rule
21 -- Type : Private
22 -- Function : This Private API can be used to create a ruleset.
23 --
24 -- Pre-reqs : None.
25 -- Parameters :
26 -- IN : p_api_version IN NUMBER Required
27 -- p_init_msg_list IN VARCHAR2 Optional
28 -- Default = FND_API.G_FALSE
29 -- p_commit IN VARCHAR2 Optional
30 -- Default = FND_API.G_FALSE
31 -- p_validation_level IN NUMBER Optional
32 -- Default = FND_API.G_VALID_LEVEL_FULL
33 -- p_ruleset_rec_type IN
34 -- CN_RuleSet_PVT.ruleset_rec_type
35 --
36 -- OUT : x_return_status OUT VARCHAR2(1)
37 -- x_msg_count OUT NUMBER
38 -- x_msg_data OUT VARCHAR2(2000)
39 --
40 -- Version : Current version 1.0
41 -- 25-Mar-99 Renu Chintalapati
42 -- previous version y.y
43 -- Changed....
44 -- Initial version 1.0
45 -- 25-Mar-99 Renu Chintalapati
46 --
47 -- Notes : Note text
48 --
49 -- End of comments
50
51 PROCEDURE create_ruleset
52 ( p_api_version IN NUMBER,
53 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
54 p_commit IN VARCHAR2 := FND_API.G_FALSE,
55 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
56 x_return_status OUT NOCOPY VARCHAR2,
57 x_msg_count OUT NOCOPY NUMBER,
58 x_msg_data OUT NOCOPY VARCHAR2,
59 x_loading_status OUT NOCOPY VARCHAR2,
60 x_ruleset_id OUT NOCOPY NUMBER,
61 p_ruleset_rec IN CN_RuleSet_PVT.ruleset_rec_type
62 );
63
64
65 -- Start of comments
66 -- API name : Update_Ruleset
67 -- Type : Public
68 -- Function : This Public API can be used to update a rule,
69 -- a ruleset or rule attributes in Oracle Sales
70 -- Compensation.
71 -- Pre-reqs : None.
72 -- Parameters :
73 -- IN : p_api_version IN NUMBER Required
74 -- p_init_msg_list IN VARCHAR2 Optional
75 -- Default = FND_API.G_FALSE
76 -- p_commit IN VARCHAR2 Optional
77 -- Default = FND_API.G_FALSE
78 -- p_validation_level IN NUMBER Optional
79 -- Default = FND_API.G_VALID_LEVEL_FULL
80 -- p_ruleset_rec_type IN
81 -- CN_RuleSet_PVT.ruleset_rec_type
82 --
83 -- OUT : x_return_status OUT VARCHAR2(1)
84 -- x_msg_count OUT NUMBER
85 -- x_msg_data OUT VARCHAR2(2000)
86 --
87 -- Version : Current version 1.0
88 -- 25-Mar-99 Renu Chintalapati
89 -- previous version y.y
90 -- Changed....
91 -- Initial version 1.0
92 -- 25-Mar-99 Renu Chintalapati
93 --
94 -- Notes : Note text
95 --
96 -- End of comments
97
98
99 PROCEDURE Update_Ruleset
100 ( p_api_version IN NUMBER,
101 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
102 p_commit IN VARCHAR2 := FND_API.G_FALSE,
103 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
104 x_return_status OUT NOCOPY VARCHAR2,
105 x_msg_count OUT NOCOPY NUMBER,
106 x_msg_data OUT NOCOPY VARCHAR2,
107 x_loading_status OUT NOCOPY VARCHAR2,
108 p_old_ruleset_rec IN OUT NOCOPY CN_RuleSet_PVT.ruleset_rec_type,
109 p_ruleset_rec IN OUT NOCOPY CN_RuleSet_PVT.ruleset_rec_type
110 );
111
112 -- Start of comments
113 -- API name : Delete_Ruleset
114 -- Type : Public
115 -- Function : This Public API can be used to delete a rule or
116 -- it's attributes from Oracle Sales Compensation.
117 -- Pre-reqs : None.
118 -- Parameters :
119 -- IN : p_api_version IN NUMBER Required
120 -- p_init_msg_list IN VARCHAR2 Optional
121 -- Default = FND_API.G_FALSE
122 -- p_commit IN VARCHAR2 Optional
123 -- Default = FND_API.G_FALSE
124 -- p_validation_level IN NUMBER Optional
125 -- Default = FND_API.G_VALID_LEVEL_FULL
126 -- p_ruleset_rec_type IN
127 -- CN_RuleSet_PVT.ruleset_rec_type
128 -- p_rule_attr_rec_tbl_type IN
129 -- CN_RuleSet_PVT.rule_attr_rec_tbl_type
130 --
131 -- OUT : x_return_status OUT VARCHAR2(1)
132 -- x_msg_count OUT NUMBER
133 -- x_msg_data OUT VARCHAR2(2000)
134 --
135 -- Version : Current version 1.0
136 -- 25-Mar-99 Renu Chintalapati
137 -- previous version y.y
138 -- Changed....
139 -- Initial version 1.0
140 -- 25-Mar-99 Renu Chintalapati
141 --
142 -- Notes : Note text
143 --
144 -- End of comments
145 /*
146 PROCEDURE Delete_Ruleset
147 ( p_api_version IN NUMBER,
148 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
149 p_commit IN VARCHAR2 := FND_API.G_FALSE,
150 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
151 x_return_status OUT NOCOPY VARCHAR2,
152 x_msg_count OUT NOCOPY NUMBER,
153 x_msg_data OUT NOCOPY VARCHAR2,
154 x_loading_status OUT NOCOPY VARCHAR2,
155 p_ruleset_id IN cn_rulesets.ruleset_id%TYPE
156 := CN_API.G_MISS_ID
157 );
158 */
159
160 FUNCTION Check_Sync_Allowed (
161 p_name In VARCHAR2,
162 p_ruleset_id NUMBER,
163 p_org_id Number,
164 p_loading_status IN VARCHAR2,
165 x_loading_status OUT NOCOPY VARCHAR2 )RETURN VARCHAR2 ;
166
167
168 END CN_RuleSet_PVT;