[Home] [Help]
PACKAGE: APPS.OKC_RULE_PVT
Source
1 PACKAGE OKC_RULE_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKCCRULS.pls 120.0 2005/05/25 18:52:07 appldev noship $ */
3
4 -- simple entity object subtype definitions
5 subtype rulv_rec_type is OKC_RUL_PVT.rulv_rec_type;
6 subtype rulv_tbl_type is OKC_RUL_PVT.rulv_tbl_type;
7 subtype rgpv_rec_type is OKC_RGP_PVT.rgpv_rec_type;
8 subtype rgpv_tbl_type is OKC_RGP_PVT.rgpv_tbl_type;
9 subtype rmpv_rec_type is OKC_RMP_PVT.rmpv_rec_type;
10 subtype rmpv_tbl_type is OKC_RMP_PVT.rmpv_tbl_type;
11 subtype ctiv_rec_type is OKC_CTI_PVT.ctiv_rec_type;
12 subtype ctiv_tbl_type is OKC_CTI_PVT.ctiv_tbl_type;
13 subtype rilv_rec_type is OKC_RIL_PVT.rilv_rec_type;
14 subtype rilv_tbl_type is OKC_RIL_PVT.rilv_tbl_type;
15
16 ---------------------------------------------------------------------------
17 -- GLOBAL MESSAGE CONSTANTS
18 ---------------------------------------------------------------------------
19 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
20 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
21 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
22 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
23 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
24 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
25 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
26 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
27 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
28 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
29 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
30 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
31 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
32 G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_UPPERCASE_REQUIRED';
33
34 ------------------------------------------------------------------------------------
35 -- GLOBAL EXCEPTION
36 ---------------------------------------------------------------------------
37 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
38
39 -- GLOBAL VARIABLES
40 ---------------------------------------------------------------------------
41 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_RULE_PVT';
42 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
43 ---------------------------------------------------------------------------
44
45 PROCEDURE create_rule(
46 p_api_version IN NUMBER,
47 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
48 x_return_status OUT NOCOPY VARCHAR2,
49 x_msg_count OUT NOCOPY NUMBER,
50 x_msg_data OUT NOCOPY VARCHAR2,
51 p_rulv_rec IN rulv_rec_type,
52 x_rulv_rec OUT NOCOPY rulv_rec_type,
53 p_euro_conv_yn IN VARCHAR2);
54
55 PROCEDURE update_rule(
56 p_api_version IN NUMBER,
57 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
58 x_return_status OUT NOCOPY VARCHAR2,
59 x_msg_count OUT NOCOPY NUMBER,
60 x_msg_data OUT NOCOPY VARCHAR2,
61 p_rulv_rec IN rulv_rec_type,
62 x_rulv_rec OUT NOCOPY rulv_rec_type);
63
64 PROCEDURE delete_rule(
65 p_api_version IN NUMBER,
66 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
67 x_return_status OUT NOCOPY VARCHAR2,
68 x_msg_count OUT NOCOPY NUMBER,
69 x_msg_data OUT NOCOPY VARCHAR2,
70 p_rulv_rec IN rulv_rec_type);
71
72 PROCEDURE lock_rule(
73 p_api_version IN NUMBER,
74 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
75 x_return_status OUT NOCOPY VARCHAR2,
76 x_msg_count OUT NOCOPY NUMBER,
77 x_msg_data OUT NOCOPY VARCHAR2,
78 p_rulv_rec IN rulv_rec_type);
79
80 PROCEDURE validate_rule(
81 p_api_version IN NUMBER,
82 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
83 x_return_status OUT NOCOPY VARCHAR2,
84 x_msg_count OUT NOCOPY NUMBER,
85 x_msg_data OUT NOCOPY VARCHAR2,
86 p_rulv_rec IN rulv_rec_type);
87
88 PROCEDURE create_rule_group(
89 p_api_version IN NUMBER,
90 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
91 x_return_status OUT NOCOPY VARCHAR2,
92 x_msg_count OUT NOCOPY NUMBER,
93 x_msg_data OUT NOCOPY VARCHAR2,
94 p_rgpv_rec IN rgpv_rec_type,
95 x_rgpv_rec OUT NOCOPY rgpv_rec_type);
96
97 PROCEDURE update_rule_group(
98 p_api_version IN NUMBER,
99 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
100 x_return_status OUT NOCOPY VARCHAR2,
101 x_msg_count OUT NOCOPY NUMBER,
102 x_msg_data OUT NOCOPY VARCHAR2,
103 p_rgpv_rec IN rgpv_rec_type,
104 x_rgpv_rec OUT NOCOPY rgpv_rec_type);
105
106 PROCEDURE delete_rule_group(
107 p_api_version IN NUMBER,
108 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
109 x_return_status OUT NOCOPY VARCHAR2,
110 x_msg_count OUT NOCOPY NUMBER,
111 x_msg_data OUT NOCOPY VARCHAR2,
112 p_rgpv_rec IN rgpv_rec_type);
113
114 PROCEDURE lock_rule_group(
115 p_api_version IN NUMBER,
116 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
117 x_return_status OUT NOCOPY VARCHAR2,
118 x_msg_count OUT NOCOPY NUMBER,
119 x_msg_data OUT NOCOPY VARCHAR2,
120 p_rgpv_rec IN rgpv_rec_type);
121
122 PROCEDURE validate_rule_group(
123 p_api_version IN NUMBER,
124 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
125 x_return_status OUT NOCOPY VARCHAR2,
126 x_msg_count OUT NOCOPY NUMBER,
127 x_msg_data OUT NOCOPY VARCHAR2,
128 p_rgpv_rec IN rgpv_rec_type);
129
130 PROCEDURE create_rg_mode_pty_role(
131 p_api_version IN NUMBER,
132 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
133 x_return_status OUT NOCOPY VARCHAR2,
134 x_msg_count OUT NOCOPY NUMBER,
135 x_msg_data OUT NOCOPY VARCHAR2,
136 p_rmpv_rec IN rmpv_rec_type,
137 x_rmpv_rec OUT NOCOPY rmpv_rec_type);
138
139 PROCEDURE update_rg_mode_pty_role(
140 p_api_version IN NUMBER,
141 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
142 x_return_status OUT NOCOPY VARCHAR2,
143 x_msg_count OUT NOCOPY NUMBER,
144 x_msg_data OUT NOCOPY VARCHAR2,
145 p_rmpv_rec IN rmpv_rec_type,
146 x_rmpv_rec OUT NOCOPY rmpv_rec_type);
147
148 PROCEDURE delete_rg_mode_pty_role(
149 p_api_version IN NUMBER,
150 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
151 x_return_status OUT NOCOPY VARCHAR2,
152 x_msg_count OUT NOCOPY NUMBER,
153 x_msg_data OUT NOCOPY VARCHAR2,
154 p_rmpv_rec IN rmpv_rec_type);
155
156 PROCEDURE lock_rg_mode_pty_role(
157 p_api_version IN NUMBER,
158 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
159 x_return_status OUT NOCOPY VARCHAR2,
160 x_msg_count OUT NOCOPY NUMBER,
161 x_msg_data OUT NOCOPY VARCHAR2,
162 p_rmpv_rec IN rmpv_rec_type);
163
164 PROCEDURE validate_rg_mode_pty_role(
165 p_api_version IN NUMBER,
166 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
167 x_return_status OUT NOCOPY VARCHAR2,
168 x_msg_count OUT NOCOPY NUMBER,
169 x_msg_data OUT NOCOPY VARCHAR2,
170 p_rmpv_rec IN rmpv_rec_type);
171
172 PROCEDURE create_cover_time(
173 p_api_version IN NUMBER,
174 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
175 x_return_status OUT NOCOPY VARCHAR2,
176 x_msg_count OUT NOCOPY NUMBER,
177 x_msg_data OUT NOCOPY VARCHAR2,
178 p_ctiv_rec IN ctiv_rec_type,
179 x_ctiv_rec OUT NOCOPY ctiv_rec_type);
180
181 PROCEDURE update_cover_time(
182 p_api_version IN NUMBER,
183 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
184 x_return_status OUT NOCOPY VARCHAR2,
185 x_msg_count OUT NOCOPY NUMBER,
186 x_msg_data OUT NOCOPY VARCHAR2,
187 p_ctiv_rec IN ctiv_rec_type,
188 x_ctiv_rec OUT NOCOPY ctiv_rec_type);
189
190 PROCEDURE delete_cover_time(
191 p_api_version IN NUMBER,
192 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
193 x_return_status OUT NOCOPY VARCHAR2,
194 x_msg_count OUT NOCOPY NUMBER,
195 x_msg_data OUT NOCOPY VARCHAR2,
196 p_ctiv_rec IN ctiv_rec_type);
197
198 PROCEDURE lock_cover_time(
199 p_api_version IN NUMBER,
200 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
201 x_return_status OUT NOCOPY VARCHAR2,
202 x_msg_count OUT NOCOPY NUMBER,
203 x_msg_data OUT NOCOPY VARCHAR2,
204 p_ctiv_rec IN ctiv_rec_type);
205
206 PROCEDURE validate_cover_time(
207 p_api_version IN NUMBER,
208 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
209 x_return_status OUT NOCOPY VARCHAR2,
210 x_msg_count OUT NOCOPY NUMBER,
211 x_msg_data OUT NOCOPY VARCHAR2,
212 p_ctiv_rec IN ctiv_rec_type);
213
214 PROCEDURE create_react_interval(
215 p_api_version IN NUMBER,
216 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
217 x_return_status OUT NOCOPY VARCHAR2,
218 x_msg_count OUT NOCOPY NUMBER,
219 x_msg_data OUT NOCOPY VARCHAR2,
220 p_rilv_rec IN rilv_rec_type,
221 x_rilv_rec OUT NOCOPY rilv_rec_type);
222
223 PROCEDURE update_react_interval(
224 p_api_version IN NUMBER,
225 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
226 x_return_status OUT NOCOPY VARCHAR2,
227 x_msg_count OUT NOCOPY NUMBER,
228 x_msg_data OUT NOCOPY VARCHAR2,
229 p_rilv_rec IN rilv_rec_type,
230 x_rilv_rec OUT NOCOPY rilv_rec_type);
231
232 PROCEDURE delete_react_interval(
233 p_api_version IN NUMBER,
234 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
235 x_return_status OUT NOCOPY VARCHAR2,
236 x_msg_count OUT NOCOPY NUMBER,
237 x_msg_data OUT NOCOPY VARCHAR2,
238 p_rilv_rec IN rilv_rec_type);
239
240 PROCEDURE lock_react_interval(
241 p_api_version IN NUMBER,
242 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
243 x_return_status OUT NOCOPY VARCHAR2,
244 x_msg_count OUT NOCOPY NUMBER,
245 x_msg_data OUT NOCOPY VARCHAR2,
246 p_rilv_rec IN rilv_rec_type);
247
248 PROCEDURE validate_react_interval(
249 p_api_version IN NUMBER,
250 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
251 x_return_status OUT NOCOPY VARCHAR2,
252 x_msg_count OUT NOCOPY NUMBER,
253 x_msg_data OUT NOCOPY VARCHAR2,
254 p_rilv_rec IN rilv_rec_type);
255
256 PROCEDURE add_language;
257
258 END OKC_RULE_PVT;