[Home] [Help]
PACKAGE: APPS.OKL_SIP_PVT
Source
1 PACKAGE OKL_SIP_PVT AS
2 /* $Header: OKLSSIPS.pls 120.1 2005/10/30 03:18:06 appldev noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 -- OKL_SUBSIDY_POOLS_V Record Spec
7 TYPE sipv_rec_type IS RECORD (
8 id NUMBER := OKL_API.G_MISS_NUM
9 ,object_version_number NUMBER := OKL_API.G_MISS_NUM
10 ,sfwt_flag OKL_SUBSIDY_POOLS_V.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR
11 ,pool_type_code OKL_SUBSIDY_POOLS_V.POOL_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
12 ,subsidy_pool_name OKL_SUBSIDY_POOLS_V.SUBSIDY_POOL_NAME%TYPE := OKL_API.G_MISS_CHAR
13 ,short_description OKL_SUBSIDY_POOLS_V.SHORT_DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
14 ,description OKL_SUBSIDY_POOLS_V.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
15 ,effective_from_date OKL_SUBSIDY_POOLS_V.EFFECTIVE_FROM_DATE%TYPE := OKL_API.G_MISS_DATE
16 ,effective_to_date OKL_SUBSIDY_POOLS_V.EFFECTIVE_TO_DATE%TYPE := OKL_API.G_MISS_DATE
17 ,currency_code OKL_SUBSIDY_POOLS_V.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
18 ,currency_conversion_type OKL_SUBSIDY_POOLS_V.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR
19 ,decision_status_code OKL_SUBSIDY_POOLS_V.DECISION_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
20 ,subsidy_pool_id NUMBER := OKL_API.G_MISS_NUM
21 ,reporting_pool_limit NUMBER := OKL_API.G_MISS_NUM
22 ,total_budgets NUMBER := OKL_API.G_MISS_NUM
23 ,total_subsidy_amount NUMBER := OKL_API.G_MISS_NUM
24 ,decision_date OKL_SUBSIDY_POOLS_V.DECISION_DATE%TYPE := OKL_API.G_MISS_DATE
25 ,attribute_category OKL_SUBSIDY_POOLS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
26 ,attribute1 OKL_SUBSIDY_POOLS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
27 ,attribute2 OKL_SUBSIDY_POOLS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
28 ,attribute3 OKL_SUBSIDY_POOLS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
29 ,attribute4 OKL_SUBSIDY_POOLS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
30 ,attribute5 OKL_SUBSIDY_POOLS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
31 ,attribute6 OKL_SUBSIDY_POOLS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
32 ,attribute7 OKL_SUBSIDY_POOLS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
33 ,attribute8 OKL_SUBSIDY_POOLS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
34 ,attribute9 OKL_SUBSIDY_POOLS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
35 ,attribute10 OKL_SUBSIDY_POOLS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
36 ,attribute11 OKL_SUBSIDY_POOLS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
37 ,attribute12 OKL_SUBSIDY_POOLS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
38 ,attribute13 OKL_SUBSIDY_POOLS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
39 ,attribute14 OKL_SUBSIDY_POOLS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
40 ,attribute15 OKL_SUBSIDY_POOLS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
41 ,created_by NUMBER := OKL_API.G_MISS_NUM
42 ,creation_date OKL_SUBSIDY_POOLS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
43 ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
44 ,last_update_date OKL_SUBSIDY_POOLS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
45 ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
46 G_MISS_sipv_rec sipv_rec_type;
47 TYPE sipv_tbl_type IS TABLE OF sipv_rec_type
48 INDEX BY BINARY_INTEGER;
49 -- OKL_SUBSIDY_POOLS_TL Record Spec
50 TYPE okl_subsidy_pools_tl_rec_type IS RECORD (
51 id NUMBER := OKL_API.G_MISS_NUM
52 ,short_description OKL_SUBSIDY_POOLS_TL.SHORT_DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
53 ,description OKL_SUBSIDY_POOLS_TL.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
54 ,language OKL_SUBSIDY_POOLS_TL.LANGUAGE%TYPE := OKL_API.G_MISS_CHAR
55 ,source_lang OKL_SUBSIDY_POOLS_TL.SOURCE_LANG%TYPE := OKL_API.G_MISS_CHAR
56 ,sfwt_flag OKL_SUBSIDY_POOLS_TL.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR
57 ,created_by NUMBER := OKL_API.G_MISS_NUM
58 ,creation_date OKL_SUBSIDY_POOLS_TL.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
59 ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
60 ,last_update_date OKL_SUBSIDY_POOLS_TL.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
61 ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
62 GMissOklSubsidyPoolsTlRec okl_subsidy_pools_tl_rec_type;
63 TYPE okl_subsidy_pools_tl_tbl_type IS TABLE OF okl_subsidy_pools_tl_rec_type
64 INDEX BY BINARY_INTEGER;
65 -- OKL_SUBSIDY_POOLS_B Record Spec
66 TYPE sip_rec_type IS RECORD (
67 id NUMBER := OKL_API.G_MISS_NUM
68 ,object_version_number NUMBER := OKL_API.G_MISS_NUM
69 ,pool_type_code OKL_SUBSIDY_POOLS_B.POOL_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
70 ,subsidy_pool_name OKL_SUBSIDY_POOLS_B.SUBSIDY_POOL_NAME%TYPE := OKL_API.G_MISS_CHAR
71 ,effective_from_date OKL_SUBSIDY_POOLS_B.EFFECTIVE_FROM_DATE%TYPE := OKL_API.G_MISS_DATE
72 ,effective_to_date OKL_SUBSIDY_POOLS_B.EFFECTIVE_TO_DATE%TYPE := OKL_API.G_MISS_DATE
73 ,currency_code OKL_SUBSIDY_POOLS_B.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
74 ,currency_conversion_type OKL_SUBSIDY_POOLS_B.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR
75 ,decision_status_code OKL_SUBSIDY_POOLS_B.DECISION_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
76 ,subsidy_pool_id NUMBER := OKL_API.G_MISS_NUM
77 ,reporting_pool_limit NUMBER := OKL_API.G_MISS_NUM
78 ,total_budgets NUMBER := OKL_API.G_MISS_NUM
79 ,total_subsidy_amount NUMBER := OKL_API.G_MISS_NUM
80 ,decision_date OKL_SUBSIDY_POOLS_B.DECISION_DATE%TYPE := OKL_API.G_MISS_DATE
81 ,attribute_category OKL_SUBSIDY_POOLS_B.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
82 ,attribute1 OKL_SUBSIDY_POOLS_B.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
83 ,attribute2 OKL_SUBSIDY_POOLS_B.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
84 ,attribute3 OKL_SUBSIDY_POOLS_B.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
85 ,attribute4 OKL_SUBSIDY_POOLS_B.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
86 ,attribute5 OKL_SUBSIDY_POOLS_B.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
87 ,attribute6 OKL_SUBSIDY_POOLS_B.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
88 ,attribute7 OKL_SUBSIDY_POOLS_B.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
89 ,attribute8 OKL_SUBSIDY_POOLS_B.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
90 ,attribute9 OKL_SUBSIDY_POOLS_B.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
91 ,attribute10 OKL_SUBSIDY_POOLS_B.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
92 ,attribute11 OKL_SUBSIDY_POOLS_B.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
93 ,attribute12 OKL_SUBSIDY_POOLS_B.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
94 ,attribute13 OKL_SUBSIDY_POOLS_B.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
95 ,attribute14 OKL_SUBSIDY_POOLS_B.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
96 ,attribute15 OKL_SUBSIDY_POOLS_B.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
97 ,created_by NUMBER := OKL_API.G_MISS_NUM
98 ,creation_date OKL_SUBSIDY_POOLS_B.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
99 ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
100 ,last_update_date OKL_SUBSIDY_POOLS_B.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
101 ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
102 G_MISS_sip_rec sip_rec_type;
103 TYPE sip_tbl_type IS TABLE OF sip_rec_type
104 INDEX BY BINARY_INTEGER;
105 ---------------------------------------------------------------------------
106 -- GLOBAL MESSAGE CONSTANTS
107 ---------------------------------------------------------------------------
108 G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
109 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
110 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
111 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
112 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
113 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
114 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
115 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
116 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
117 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
118 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
119 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
120 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
121 G_TABLE_TOKEN CONSTANT VARCHAR2(100) := 'OKL_TABLE_NAME';
122 G_UNQS CONSTANT VARCHAR2(200) := 'OKL_NOT_UNIQUE';
123
124 ---------------------------------------------------------------------------
125 -- GLOBAL EXCEPTIONS
126 ---------------------------------------------------------------------------
127 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
128
129 ---------------------------------------------------------------------------
130 -- GLOBAL VARIABLES
131 ---------------------------------------------------------------------------
132 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_SIP_PVT';
133 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
134 ---------------------------------------------------------------------------
135 -- Procedures and Functions
136 ---------------------------------------------------------------------------
137
138 PROCEDURE qc;
139 PROCEDURE change_version;
140 PROCEDURE api_copy;
141 PROCEDURE add_language;
142 PROCEDURE insert_row(
143 p_api_version IN NUMBER,
144 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
145 x_return_status OUT NOCOPY VARCHAR2,
146 x_msg_count OUT NOCOPY NUMBER,
147 x_msg_data OUT NOCOPY VARCHAR2,
148 p_sipv_rec IN sipv_rec_type,
149 x_sipv_rec OUT NOCOPY sipv_rec_type);
150 PROCEDURE insert_row(
151 p_api_version IN NUMBER,
152 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
153 x_return_status OUT NOCOPY VARCHAR2,
154 x_msg_count OUT NOCOPY NUMBER,
155 x_msg_data OUT NOCOPY VARCHAR2,
156 p_sipv_tbl IN sipv_tbl_type,
157 x_sipv_tbl OUT NOCOPY sipv_tbl_type,
158 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
159 PROCEDURE insert_row(
160 p_api_version IN NUMBER,
161 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
162 x_return_status OUT NOCOPY VARCHAR2,
163 x_msg_count OUT NOCOPY NUMBER,
164 x_msg_data OUT NOCOPY VARCHAR2,
165 p_sipv_tbl IN sipv_tbl_type,
166 x_sipv_tbl OUT NOCOPY sipv_tbl_type);
167 PROCEDURE lock_row(
168 p_api_version IN NUMBER,
169 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
170 x_return_status OUT NOCOPY VARCHAR2,
171 x_msg_count OUT NOCOPY NUMBER,
172 x_msg_data OUT NOCOPY VARCHAR2,
173 p_sipv_rec IN sipv_rec_type);
174 PROCEDURE lock_row(
175 p_api_version IN NUMBER,
176 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
177 x_return_status OUT NOCOPY VARCHAR2,
178 x_msg_count OUT NOCOPY NUMBER,
179 x_msg_data OUT NOCOPY VARCHAR2,
180 p_sipv_tbl IN sipv_tbl_type,
181 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
182 PROCEDURE lock_row(
183 p_api_version IN NUMBER,
184 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
185 x_return_status OUT NOCOPY VARCHAR2,
186 x_msg_count OUT NOCOPY NUMBER,
187 x_msg_data OUT NOCOPY VARCHAR2,
188 p_sipv_tbl IN sipv_tbl_type);
189 PROCEDURE update_row(
190 p_api_version IN NUMBER,
191 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
192 x_return_status OUT NOCOPY VARCHAR2,
193 x_msg_count OUT NOCOPY NUMBER,
194 x_msg_data OUT NOCOPY VARCHAR2,
195 p_sipv_rec IN sipv_rec_type,
196 x_sipv_rec OUT NOCOPY sipv_rec_type);
197 PROCEDURE update_row(
198 p_api_version IN NUMBER,
199 p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_sipv_tbl IN sipv_tbl_type,
204 x_sipv_tbl OUT NOCOPY sipv_tbl_type,
205 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
206 PROCEDURE update_row(
207 p_api_version IN NUMBER,
208 p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_sipv_tbl IN sipv_tbl_type,
213 x_sipv_tbl OUT NOCOPY sipv_tbl_type);
214 PROCEDURE delete_row(
215 p_api_version IN NUMBER,
216 p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_sipv_rec IN sipv_rec_type);
221 PROCEDURE delete_row(
222 p_api_version IN NUMBER,
223 p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_sipv_tbl IN sipv_tbl_type,
228 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
229 PROCEDURE delete_row(
230 p_api_version IN NUMBER,
231 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
232 x_return_status OUT NOCOPY VARCHAR2,
233 x_msg_count OUT NOCOPY NUMBER,
234 x_msg_data OUT NOCOPY VARCHAR2,
235 p_sipv_tbl IN sipv_tbl_type);
236 PROCEDURE validate_row(
237 p_api_version IN NUMBER,
238 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
239 x_return_status OUT NOCOPY VARCHAR2,
240 x_msg_count OUT NOCOPY NUMBER,
241 x_msg_data OUT NOCOPY VARCHAR2,
242 p_sipv_rec IN sipv_rec_type);
243 PROCEDURE validate_row(
244 p_api_version IN NUMBER,
245 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
246 x_return_status OUT NOCOPY VARCHAR2,
247 x_msg_count OUT NOCOPY NUMBER,
248 x_msg_data OUT NOCOPY VARCHAR2,
249 p_sipv_tbl IN sipv_tbl_type,
250 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
251 PROCEDURE validate_row(
252 p_api_version IN NUMBER,
253 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
254 x_return_status OUT NOCOPY VARCHAR2,
255 x_msg_count OUT NOCOPY NUMBER,
256 x_msg_data OUT NOCOPY VARCHAR2,
257 p_sipv_tbl IN sipv_tbl_type);
258 END OKL_SIP_PVT;