[Home] [Help]
PACKAGE: APPS.CN_RULESET_PUB_CUHK
Source
1 PACKAGE CN_RULESET_PUB_CUHK AUTHID CURRENT_USER as
2 -- $Header: cncrsets.pls 120.1 2005/06/20 17:17:09 appldev ship $
3
4 -------------------------------------------------------------------------------------+
5 -- Start of comments
6 -- API name : create_ruleset_pre
7 -- Type : Public.
8 -- Pre-reqs : None.
9 -- Usage : Customization before creating a ruleset
10 --
11 -- Desc :
12 --
13 -- Parameters :
14 -- IN : p_api_version IN NUMBER Required
15 -- p_init_msg_list IN VARCHAR2 Optional
16 -- Default = FND_API.G_FALSE
17 -- p_commit IN VARCHAR2 Optional
18 -- Default = FND_API.G_FALSE
19 -- p_validation_level IN NUMBER Optional
20 -- Default = FND_API.G_VALID_LEVEL_FULL
21 -- OUT : x_return_status OUT VARCHAR2(1)
22 -- x_msg_count OUT NUMBER
23 -- x_msg_data OUT VARCHAR2(2000)
24 -- IN : p_ruleset_id IN CN_Ruleset_PUB.ruleset_rec_type;
25 --
26 -- OUT : x_loading_status OUT VARCHAR2(50)
27 -- Detailed error code returned from procedure.
28 --
29 --
30 -- Version : Current version 1.0
31 -- Initial version 1.0
32 --
33 -- Notes :
34 --
35 -- End of comments
36 --------------------------------------------------------------------------------------+
37 PROCEDURE create_ruleset_pre
38 ( p_api_version IN NUMBER,
39 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
40 p_commit IN VARCHAR2 := FND_API.G_FALSE,
41 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
42 x_return_status OUT NOCOPY VARCHAR2,
43 x_msg_count OUT NOCOPY NUMBER,
44 x_msg_data OUT NOCOPY VARCHAR2,
45 x_loading_status OUT NOCOPY VARCHAR2,
46 p_ruleset_rec IN CN_Ruleset_PUB.ruleset_rec_type
47 );
48
49 -------------------------------------------------------------------------------------+
50 -- Start of comments
51 -- API name : create_ruleset_post
52 -- Type : Public.
53 -- Pre-reqs : None.
54 -- Usage : Customization after creating a ruleset
55 --
56 -- Desc :
57 --
58 -- Parameters :
59 -- IN : p_api_version IN NUMBER Required
60 -- p_init_msg_list IN VARCHAR2 Optional
61 -- Default = FND_API.G_FALSE
62 -- p_commit IN VARCHAR2 Optional
63 -- Default = FND_API.G_FALSE
64 -- p_validation_level IN NUMBER Optional
65 -- Default = FND_API.G_VALID_LEVEL_FULL
66 -- OUT : x_return_status OUT VARCHAR2(1)
67 -- x_msg_count OUT NUMBER
68 -- x_msg_data OUT VARCHAR2(2000)
69 -- IN : p_ruleset_id IN CN_Ruleset_PUB.ruleset_rec_type;
70 --
71 -- OUT : x_loading_status OUT VARCHAR2(50)
72 -- Detailed error code returned from procedure.
73 --
74 --
75 -- Version : Current version 1.0
76 -- Initial version 1.0
77 --
78 -- Notes :
79 --
80 -- End of comments
81 --------------------------------------------------------------------------------------+
82 PROCEDURE create_ruleset_post
83 ( p_api_version IN NUMBER,
84 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
85 p_commit IN VARCHAR2 := FND_API.G_FALSE,
86 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
87 x_return_status OUT NOCOPY VARCHAR2,
88 x_msg_count OUT NOCOPY NUMBER,
89 x_msg_data OUT NOCOPY VARCHAR2,
90 x_loading_status OUT NOCOPY VARCHAR2,
91 p_ruleset_rec IN CN_Ruleset_PUB.ruleset_rec_type
92 );
93
94
95 -------------------------------------------------------------------------------------+
96 -- Start of comments
97 -- API name : update_ruleset_pre
98 -- Type : Public.
99 -- Pre-reqs : None.
100 -- Usage : Customization before updating a ruleset
101 --
102 -- Desc :
103 --
104 -- Parameters :
105 -- IN : p_api_version IN NUMBER Required
106 -- p_init_msg_list IN VARCHAR2 Optional
107 -- Default = FND_API.G_FALSE
108 -- p_commit IN VARCHAR2 Optional
109 -- Default = FND_API.G_FALSE
110 -- p_validation_level IN NUMBER Optional
111 -- Default = FND_API.G_VALID_LEVEL_FULL
112 -- OUT : x_return_status OUT VARCHAR2(1)
113 -- x_msg_count OUT NUMBER
114 -- x_msg_data OUT VARCHAR2(2000)
115 -- IN OUT : p_old_ruleset_id IN CN_Ruleset_PUB.ruleset_rec_type
116 -- IN OUT : p_ruleset_id IN CN_Ruleset_PUB.ruleset_rec_type
117 --
118 -- OUT : x_loading_status OUT VARCHAR2(50)
119 -- Detailed error code returned from procedure.
120 --
121 --
122 -- Version : Current version 1.0
123 -- Initial version 1.0
124 --
125 -- Notes :
126 --
127 -- End of comments
128 --------------------------------------------------------------------------------------+
129 PROCEDURE update_ruleset_pre
130 ( p_api_version IN NUMBER,
131 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
132 p_commit IN VARCHAR2 := FND_API.G_FALSE,
133 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
134 x_return_status OUT NOCOPY VARCHAR2,
135 x_msg_count OUT NOCOPY NUMBER,
136 x_msg_data OUT NOCOPY VARCHAR2,
137 x_loading_status OUT NOCOPY VARCHAR2,
138 p_old_ruleset_rec IN OUT NOCOPY CN_Ruleset_PUB.ruleset_rec_type,
139 p_ruleset_rec IN OUT NOCOPY CN_Ruleset_PUB.ruleset_rec_type
140 );
141
142
143 -------------------------------------------------------------------------------------+
144 -- Start of comments
145 -- API name : update_ruleset_post
146 -- Type : Public.
147 -- Pre-reqs : None.
148 -- Usage : Customization before updating a ruleset
149 --
150 -- Desc :
151 --
152 -- Parameters :
153 -- IN : p_api_version IN NUMBER Required
154 -- p_init_msg_list IN VARCHAR2 Optional
155 -- Default = FND_API.G_FALSE
156 -- p_commit IN VARCHAR2 Optional
157 -- Default = FND_API.G_FALSE
158 -- p_validation_level IN NUMBER Optional
159 -- Default = FND_API.G_VALID_LEVEL_FULL
160 -- OUT : x_return_status OUT VARCHAR2(1)
161 -- x_msg_count OUT NUMBER
162 -- x_msg_data OUT VARCHAR2(2000)
163 -- IN OUT : p_old_ruleset_id IN CN_Ruleset_PUB.ruleset_rec_type
164 -- IN OUT : p_ruleset_id IN CN_Ruleset_PUB.ruleset_rec_type
165 --
166 -- OUT : x_loading_status OUT VARCHAR2(50)
167 -- Detailed error code returned from procedure.
168 --
169 --
170 -- Version : Current version 1.0
171 -- Initial version 1.0
172 --
173 -- Notes :
174 --
175 -- End of comments
176 --------------------------------------------------------------------------------------+
177 PROCEDURE update_ruleset_post
178 ( p_api_version IN NUMBER,
179 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
180 p_commit IN VARCHAR2 := FND_API.G_FALSE,
181 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
182 x_return_status OUT NOCOPY VARCHAR2,
183 x_msg_count OUT NOCOPY NUMBER,
184 x_msg_data OUT NOCOPY VARCHAR2,
185 x_loading_status OUT NOCOPY VARCHAR2,
186 p_old_ruleset_rec IN OUT NOCOPY CN_Ruleset_PUB.ruleset_rec_type,
187 p_ruleset_rec IN OUT NOCOPY CN_Ruleset_PUB.ruleset_rec_type
188 );
189
190 --------------------------------------------------------------------------------------+
191 -- Start of comments
192 -- API name : ok_to_generate_msg
193 -- Type : Public.
194 -- Pre-reqs : None.
195 -- Usage : Function to decide whether message needs to be generated
196 --
197 -- Desc :
198 --
199 -- Parameters :
200 -- IN :
201 -- OUT :
202 -- Version : Current version 1.0
203 -- Initial version 1.0
204 --
205 -- End of comments
206 --------------------------------------------------------------------------------------+
207 FUNCTION ok_to_generate_msg
208 (p_ruleset_rec IN CN_Ruleset_PUB.ruleset_rec_type)
209 RETURN BOOLEAN;
210
211
212 END CN_RULESET_PUB_CUHK;