[Home] [Help]
PACKAGE: APPS.OKC_CONTRACT_GROUP_PUB
Source
1 package okc_contract_group_pub as
2 /* $Header: OKCPCGPS.pls 120.0 2005/05/26 09:51:14 appldev noship $ */
3
4 subtype cgpv_rec_type is okc_contract_group_pvt.cgpv_rec_type;
5 subtype cgpv_tbl_type is okc_contract_group_pvt.cgpv_tbl_type;
6 subtype cgcv_rec_type is okc_contract_group_pvt.cgcv_rec_type;
7 subtype cgcv_tbl_type is okc_contract_group_pvt.cgcv_tbl_type;
8 subtype qry_k_tbl is okc_cgc_pvt.qry_k_tbl;
9
10 g_cgpv_rec cgpv_rec_type;
11 g_cgpv_tbl cgpv_tbl_type;
12 g_cgcv_rec cgcv_rec_type;
13 g_cgcv_tbl cgcv_tbl_type;
14
15 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
16 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
17 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
18 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
19 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CONTRACT_GROUP_PUB';
20 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
21
22 PROCEDURE add_language;
23
24 PROCEDURE create_ctr_group(
25 p_api_version IN NUMBER,
26 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
27 x_return_status OUT NOCOPY VARCHAR2,
28 x_msg_count OUT NOCOPY NUMBER,
29 x_msg_data OUT NOCOPY VARCHAR2,
30 p_cgpv_rec IN cgpv_rec_type,
31 x_cgpv_rec OUT NOCOPY cgpv_rec_type,
32 p_cgcv_tbl IN cgcv_tbl_type,
33 x_cgcv_tbl OUT NOCOPY cgcv_tbl_type);
34
35 PROCEDURE update_ctr_group(
36 p_api_version IN NUMBER,
37 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
38 x_return_status OUT NOCOPY VARCHAR2,
39 x_msg_count OUT NOCOPY NUMBER,
40 x_msg_data OUT NOCOPY VARCHAR2,
41 p_cgpv_rec IN cgpv_rec_type,
42 x_cgpv_rec OUT NOCOPY cgpv_rec_type,
43 p_cgcv_tbl IN cgcv_tbl_type,
44 x_cgcv_tbl OUT NOCOPY cgcv_tbl_type);
45
46 PROCEDURE validate_ctr_group(
47 p_api_version IN NUMBER,
48 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
49 x_return_status OUT NOCOPY VARCHAR2,
50 x_msg_count OUT NOCOPY NUMBER,
51 x_msg_data OUT NOCOPY VARCHAR2,
52 p_cgpv_rec IN cgpv_rec_type,
53 p_cgcv_tbl IN cgcv_tbl_type);
54
55 PROCEDURE create_contract_group(
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_cgpv_rec IN cgpv_rec_type,
62 x_cgpv_rec OUT NOCOPY cgpv_rec_type);
63
64 PROCEDURE create_contract_group(
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_cgpv_tbl IN cgpv_tbl_type,
71 x_cgpv_tbl OUT NOCOPY cgpv_tbl_type);
72
73 PROCEDURE update_contract_group(
74 p_api_version IN NUMBER,
75 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
76 x_return_status OUT NOCOPY VARCHAR2,
77 x_msg_count OUT NOCOPY NUMBER,
78 x_msg_data OUT NOCOPY VARCHAR2,
79 p_cgpv_rec IN cgpv_rec_type,
80 x_cgpv_rec OUT NOCOPY cgpv_rec_type);
81
82 PROCEDURE update_contract_group(
83 p_api_version IN NUMBER,
84 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
85 x_return_status OUT NOCOPY VARCHAR2,
86 x_msg_count OUT NOCOPY NUMBER,
87 x_msg_data OUT NOCOPY VARCHAR2,
88 p_cgpv_tbl IN cgpv_tbl_type,
89 x_cgpv_tbl OUT NOCOPY cgpv_tbl_type);
90
91 PROCEDURE delete_contract_group(
92 p_api_version IN NUMBER,
93 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
94 x_return_status OUT NOCOPY VARCHAR2,
95 x_msg_count OUT NOCOPY NUMBER,
96 x_msg_data OUT NOCOPY VARCHAR2,
97 p_cgpv_rec IN cgpv_rec_type);
98
99 PROCEDURE delete_contract_group(
100 p_api_version IN NUMBER,
101 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
102 x_return_status OUT NOCOPY VARCHAR2,
103 x_msg_count OUT NOCOPY NUMBER,
104 x_msg_data OUT NOCOPY VARCHAR2,
105 p_cgpv_tbl IN cgpv_tbl_type);
106
107 PROCEDURE lock_contract_group(
108 p_api_version IN NUMBER,
109 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
110 x_return_status OUT NOCOPY VARCHAR2,
111 x_msg_count OUT NOCOPY NUMBER,
112 x_msg_data OUT NOCOPY VARCHAR2,
113 p_cgpv_rec IN cgpv_rec_type);
114
115 PROCEDURE lock_contract_group(
116 p_api_version IN NUMBER,
117 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
118 x_return_status OUT NOCOPY VARCHAR2,
119 x_msg_count OUT NOCOPY NUMBER,
120 x_msg_data OUT NOCOPY VARCHAR2,
121 p_cgpv_tbl IN cgpv_tbl_type);
122
123 PROCEDURE validate_contract_group(
124 p_api_version IN NUMBER,
125 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
126 x_return_status OUT NOCOPY VARCHAR2,
127 x_msg_count OUT NOCOPY NUMBER,
128 x_msg_data OUT NOCOPY VARCHAR2,
129 p_cgpv_rec IN cgpv_rec_type);
130
131 PROCEDURE validate_contract_group(
132 p_api_version IN NUMBER,
133 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
134 x_return_status OUT NOCOPY VARCHAR2,
135 x_msg_count OUT NOCOPY NUMBER,
136 x_msg_data OUT NOCOPY VARCHAR2,
137 p_cgpv_tbl IN cgpv_tbl_type);
138
139 PROCEDURE create_contract_grpngs(
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_cgcv_rec IN cgcv_rec_type,
146 x_cgcv_rec OUT NOCOPY cgcv_rec_type);
147
148 PROCEDURE create_contract_grpngs(
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_cgcv_tbl IN cgcv_tbl_type,
155 x_cgcv_tbl OUT NOCOPY cgcv_tbl_type);
156
157 PROCEDURE update_contract_grpngs(
158 p_api_version IN NUMBER,
159 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
160 x_return_status OUT NOCOPY VARCHAR2,
161 x_msg_count OUT NOCOPY NUMBER,
162 x_msg_data OUT NOCOPY VARCHAR2,
163 p_cgcv_rec IN cgcv_rec_type,
164 x_cgcv_rec OUT NOCOPY cgcv_rec_type);
165
166 PROCEDURE update_contract_grpngs(
167 p_api_version IN NUMBER,
168 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
169 x_return_status OUT NOCOPY VARCHAR2,
170 x_msg_count OUT NOCOPY NUMBER,
171 x_msg_data OUT NOCOPY VARCHAR2,
172 p_cgcv_tbl IN cgcv_tbl_type,
173 x_cgcv_tbl OUT NOCOPY cgcv_tbl_type);
174
175 PROCEDURE delete_contract_grpngs(
176 p_api_version IN NUMBER,
177 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
178 x_return_status OUT NOCOPY VARCHAR2,
179 x_msg_count OUT NOCOPY NUMBER,
180 x_msg_data OUT NOCOPY VARCHAR2,
181 p_cgcv_rec IN cgcv_rec_type);
182
183 PROCEDURE delete_contract_grpngs(
184 p_api_version IN NUMBER,
185 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
186 x_return_status OUT NOCOPY VARCHAR2,
187 x_msg_count OUT NOCOPY NUMBER,
188 x_msg_data OUT NOCOPY VARCHAR2,
189 p_cgcv_tbl IN cgcv_tbl_type);
190
191 PROCEDURE lock_contract_grpngs(
192 p_api_version IN NUMBER,
193 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
194 x_return_status OUT NOCOPY VARCHAR2,
195 x_msg_count OUT NOCOPY NUMBER,
196 x_msg_data OUT NOCOPY VARCHAR2,
197 p_cgcv_rec IN cgcv_rec_type);
198
199 PROCEDURE lock_contract_grpngs(
200 p_api_version IN NUMBER,
201 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
202 x_return_status OUT NOCOPY VARCHAR2,
203 x_msg_count OUT NOCOPY NUMBER,
204 x_msg_data OUT NOCOPY VARCHAR2,
205 p_cgcv_tbl IN cgcv_tbl_type);
206
207 PROCEDURE validate_contract_grpngs(
208 p_api_version IN NUMBER,
209 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
210 x_return_status OUT NOCOPY VARCHAR2,
211 x_msg_count OUT NOCOPY NUMBER,
212 x_msg_data OUT NOCOPY VARCHAR2,
213 p_cgcv_rec IN cgcv_rec_type);
214
215 PROCEDURE validate_contract_grpngs(
216 p_api_version IN NUMBER,
217 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
218 x_return_status OUT NOCOPY VARCHAR2,
219 x_msg_count OUT NOCOPY NUMBER,
220 x_msg_data OUT NOCOPY VARCHAR2,
221 p_cgcv_tbl IN cgcv_tbl_type);
222
223 PROCEDURE Validate_Name(x_return_status OUT NOCOPY VARCHAR2,
224 p_cgpv_tbl IN cgpv_tbl_type);
225 PROCEDURE Validate_Public_YN(x_return_status OUT NOCOPY VARCHAR2,
226 p_cgpv_tbl IN cgpv_tbl_type);
227 PROCEDURE Validate_Short_Description(x_return_status OUT NOCOPY VARCHAR2,
228 p_cgpv_tbl IN cgpv_tbl_type);
229
230 FUNCTION Validate_Record(p_cgpv_tbl IN cgpv_tbl_type)
231 RETURN VARCHAR2;
232
233 PROCEDURE Set_Search_String(
234 p_srch_str IN VARCHAR2,
235 x_return_status OUT NOCOPY VARCHAR2);
236
237 PROCEDURE Get_Queried_Contracts(
238 p_cgp_parent_id IN NUMBER,
239 x_qry_k_tbl OUT NOCOPY qry_k_tbl,
240 x_return_status OUT NOCOPY VARCHAR2);
241
242 END OKC_CONTRACT_GROUP_PUB;