[Home] [Help]
PACKAGE: APPS.OKL_ACC_GEN_RULE_PVT
Source
1 PACKAGE okl_acc_gen_rule_pvt AUTHID CURRENT_USER AS
2 /* $Header: OKLCAGRS.pls 115.5 2002/02/18 20:10:26 pkm ship $ */
3
4 SUBTYPE agrv_rec_type IS okl_agr_pvt.agrv_rec_type;
5 SUBTYPE agrv_tbl_type IS okl_agr_pvt.agrv_tbl_type;
6
10 -- Global Variables
7 SUBTYPE aulv_rec_type IS okl_aul_pvt.aulv_rec_type;
8 SUBTYPE aulv_tbl_type IS okl_aul_pvt.aulv_tbl_type;
9 ------------------------------------------------------------------------------
11 G_PKG_NAME CONSTANT VARCHAR2(200) := 'okl_acc_gen_rule_pvt';
12 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
13 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
14 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
15 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
16 ------------------------------------------------------------------------------
17 --Global Exception
18 ------------------------------------------------------------------------------
19 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
20 ------------------------------------------------------------------------------
21
22 --Object type procedure for insert
23 PROCEDURE create_acc_gen_rule(
24 p_api_version IN NUMBER
25 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
26 ,x_return_status OUT NOCOPY VARCHAR2
27 ,x_msg_count OUT NOCOPY NUMBER
28 ,x_msg_data OUT NOCOPY VARCHAR2
29 ,p_agrv_rec IN agrv_rec_type
30 ,p_aulv_tbl IN aulv_tbl_type
31 ,x_agrv_rec OUT NOCOPY agrv_rec_type
32 ,x_aulv_tbl OUT NOCOPY aulv_tbl_type
33 );
34
35 --Object type procedure for update
36 PROCEDURE update_acc_gen_rule(
37 p_api_version IN NUMBER
38 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
39 ,x_return_status OUT NOCOPY VARCHAR2
40 ,x_msg_count OUT NOCOPY NUMBER
41 ,x_msg_data OUT NOCOPY VARCHAR2
42 ,p_agrv_rec IN agrv_rec_type
43 ,p_aulv_tbl IN aulv_tbl_type
44 ,x_agrv_rec OUT NOCOPY agrv_rec_type
45 ,x_aulv_tbl OUT NOCOPY aulv_tbl_type
46 );
47
48 --Object type procedure for validate
49 PROCEDURE validate_acc_gen_rule(
50 p_api_version IN NUMBER
51 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
52 ,x_return_status OUT NOCOPY VARCHAR2
53 ,x_msg_count OUT NOCOPY NUMBER
54 ,x_msg_data OUT NOCOPY VARCHAR2
55 ,p_agrv_rec IN agrv_rec_type
56 ,p_aulv_tbl IN aulv_tbl_type
57 );
58
59
60 PROCEDURE create_acc_gen_rule(
61 p_api_version IN NUMBER,
62 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
63 x_return_status OUT NOCOPY VARCHAR2,
64 x_msg_count OUT NOCOPY NUMBER,
65 x_msg_data OUT NOCOPY VARCHAR2,
66 p_agrv_tbl IN agrv_tbl_type,
67 x_agrv_tbl OUT NOCOPY agrv_tbl_type);
68
69 PROCEDURE create_acc_gen_rule(
70 p_api_version IN NUMBER,
71 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
72 x_return_status OUT NOCOPY VARCHAR2,
73 x_msg_count OUT NOCOPY NUMBER,
74 x_msg_data OUT NOCOPY VARCHAR2,
75 p_agrv_rec IN agrv_rec_type,
76 x_agrv_rec OUT NOCOPY agrv_rec_type);
77
78 PROCEDURE lock_acc_gen_rule(
79 p_api_version IN NUMBER,
80 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
81 x_return_status OUT NOCOPY VARCHAR2,
82 x_msg_count OUT NOCOPY NUMBER,
83 x_msg_data OUT NOCOPY VARCHAR2,
84 p_agrv_tbl IN agrv_tbl_type);
85
86 PROCEDURE lock_acc_gen_rule(
87 p_api_version IN NUMBER,
88 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
89 x_return_status OUT NOCOPY VARCHAR2,
90 x_msg_count OUT NOCOPY NUMBER,
91 x_msg_data OUT NOCOPY VARCHAR2,
92 p_agrv_rec IN agrv_rec_type);
93
94 PROCEDURE update_acc_gen_rule(
95 p_api_version IN NUMBER,
96 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
97 x_return_status OUT NOCOPY VARCHAR2,
98 x_msg_count OUT NOCOPY NUMBER,
99 x_msg_data OUT NOCOPY VARCHAR2,
100 p_agrv_tbl IN agrv_tbl_type,
101 x_agrv_tbl OUT NOCOPY agrv_tbl_type);
102
103 PROCEDURE update_acc_gen_rule(
104 p_api_version IN NUMBER,
105 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
106 x_return_status OUT NOCOPY VARCHAR2,
107 x_msg_count OUT NOCOPY NUMBER,
108 x_msg_data OUT NOCOPY VARCHAR2,
109 p_agrv_rec IN agrv_rec_type,
110 x_agrv_rec OUT NOCOPY agrv_rec_type);
111
112 PROCEDURE delete_acc_gen_rule(
113 p_api_version IN NUMBER,
114 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
115 x_return_status OUT NOCOPY VARCHAR2,
116 x_msg_count OUT NOCOPY NUMBER,
117 x_msg_data OUT NOCOPY VARCHAR2,
118 p_agrv_tbl IN agrv_tbl_type);
119
120 PROCEDURE delete_acc_gen_rule(
121 p_api_version IN NUMBER,
122 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
123 x_return_status OUT NOCOPY VARCHAR2,
124 x_msg_count OUT NOCOPY NUMBER,
125 x_msg_data OUT NOCOPY VARCHAR2,
126 p_agrv_rec IN agrv_rec_type);
127
128 PROCEDURE validate_acc_gen_rule(
129 p_api_version IN NUMBER,
130 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
131 x_return_status OUT NOCOPY VARCHAR2,
132 x_msg_count OUT NOCOPY NUMBER,
133 x_msg_data OUT NOCOPY VARCHAR2,
134 p_agrv_tbl IN agrv_tbl_type);
135
136 PROCEDURE validate_acc_gen_rule(
137 p_api_version IN NUMBER,
138 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
139 x_return_status OUT NOCOPY VARCHAR2,
140 x_msg_count OUT NOCOPY NUMBER,
141 x_msg_data OUT NOCOPY VARCHAR2,
142 p_agrv_rec IN agrv_rec_type);
143
144
145 PROCEDURE create_acc_gen_rule_lns(
146 p_api_version IN NUMBER,
147 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
148 x_return_status OUT NOCOPY VARCHAR2,
149 x_msg_count OUT NOCOPY NUMBER,
150 x_msg_data OUT NOCOPY VARCHAR2,
151 p_aulv_tbl IN aulv_tbl_type,
152 x_aulv_tbl OUT NOCOPY aulv_tbl_type);
153
154 PROCEDURE create_acc_gen_rule_lns(
155 p_api_version IN NUMBER,
156 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
157 x_return_status OUT NOCOPY VARCHAR2,
158 x_msg_count OUT NOCOPY NUMBER,
159 x_msg_data OUT NOCOPY VARCHAR2,
160 p_aulv_rec IN aulv_rec_type,
161 x_aulv_rec OUT NOCOPY aulv_rec_type);
162
163 PROCEDURE lock_acc_gen_rule_lns(
164 p_api_version IN NUMBER,
165 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
166 x_return_status OUT NOCOPY VARCHAR2,
167 x_msg_count OUT NOCOPY NUMBER,
168 x_msg_data OUT NOCOPY VARCHAR2,
169 p_aulv_tbl IN aulv_tbl_type);
170
171 PROCEDURE lock_acc_gen_rule_lns(
172 p_api_version IN NUMBER,
173 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
174 x_return_status OUT NOCOPY VARCHAR2,
175 x_msg_count OUT NOCOPY NUMBER,
176 x_msg_data OUT NOCOPY VARCHAR2,
177 p_aulv_rec IN aulv_rec_type);
178
179 PROCEDURE update_acc_gen_rule_lns(
180 p_api_version IN NUMBER,
181 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
182 x_return_status OUT NOCOPY VARCHAR2,
183 x_msg_count OUT NOCOPY NUMBER,
184 x_msg_data OUT NOCOPY VARCHAR2,
185 p_aulv_tbl IN aulv_tbl_type,
186 x_aulv_tbl OUT NOCOPY aulv_tbl_type);
187
188 PROCEDURE update_acc_gen_rule_lns(
189 p_api_version IN NUMBER,
190 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
191 x_return_status OUT NOCOPY VARCHAR2,
192 x_msg_count OUT NOCOPY NUMBER,
193 x_msg_data OUT NOCOPY VARCHAR2,
194 p_aulv_rec IN aulv_rec_type,
195 x_aulv_rec OUT NOCOPY aulv_rec_type);
196
197 PROCEDURE delete_acc_gen_rule_lns(
198 p_api_version IN NUMBER,
199 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
200 x_return_status OUT NOCOPY VARCHAR2,
201 x_msg_count OUT NOCOPY NUMBER,
202 x_msg_data OUT NOCOPY VARCHAR2,
203 p_aulv_tbl IN aulv_tbl_type);
204
205 PROCEDURE delete_acc_gen_rule_lns(
206 p_api_version IN NUMBER,
207 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
208 x_return_status OUT NOCOPY VARCHAR2,
209 x_msg_count OUT NOCOPY NUMBER,
210 x_msg_data OUT NOCOPY VARCHAR2,
211 p_aulv_rec IN aulv_rec_type);
212
213 PROCEDURE validate_acc_gen_rule_lns(
214 p_api_version IN NUMBER,
215 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
216 x_return_status OUT NOCOPY VARCHAR2,
217 x_msg_count OUT NOCOPY NUMBER,
218 x_msg_data OUT NOCOPY VARCHAR2,
219 p_aulv_tbl IN aulv_tbl_type);
220
221 PROCEDURE validate_acc_gen_rule_lns(
222 p_api_version IN NUMBER,
223 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
224 x_return_status OUT NOCOPY VARCHAR2,
225 x_msg_count OUT NOCOPY NUMBER,
226 x_msg_data OUT NOCOPY VARCHAR2,
227 p_aulv_rec IN aulv_rec_type);
228
229 END okl_acc_gen_rule_pvt;