[Home] [Help]
PACKAGE: APPS.OKL_SYP_PVT
Source
1 PACKAGE OKL_SYP_PVT AS
2 /* $Header: OKLSSYPS.pls 120.21.12010000.3 2008/11/13 13:59:58 kkorrapo ship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 -- OKL_SYSTEM_PARAMS_ALL_V Record Spec
7 TYPE sypv_rec_type IS RECORD (
8 id NUMBER := OKL_API.G_MISS_NUM
9 ,delink_yn OKL_SYSTEM_PARAMS.DELINK_YN%TYPE := OKL_API.G_MISS_CHAR
10 -- SECHAWLA 28-SEP-04 3924244: Added the following new columns : begin
11 ,REMK_SUBINVENTORY OKL_SYSTEM_PARAMS.REMK_SUBINVENTORY%TYPE := OKL_API.G_MISS_CHAR
12 ,REMK_ORGANIZATION_ID OKL_SYSTEM_PARAMS.REMK_ORGANIZATION_ID%TYPE := OKL_API.G_MISS_NUM
13 ,REMK_PRICE_LIST_ID OKL_SYSTEM_PARAMS.REMK_PRICE_LIST_ID%TYPE := OKL_API.G_MISS_NUM
14 ,REMK_PROCESS_CODE OKL_SYSTEM_PARAMS.REMK_PROCESS_CODE%TYPE := OKL_API.G_MISS_CHAR
15 ,REMK_ITEM_TEMPLATE_ID OKL_SYSTEM_PARAMS.REMK_ITEM_TEMPLATE_ID%TYPE := OKL_API.G_MISS_NUM
16 ,REMK_ITEM_INVOICED_CODE OKL_SYSTEM_PARAMS.REMK_ITEM_INVOICED_CODE%TYPE := OKL_API.G_MISS_CHAR
17 -- SECHAWLA 28-SEP-04 3924244: Added the following new columns : end
18 -- PAGARG 24-JAN-05 4044659: Added the new column LEASE_INV_ORG_YN: begin
19 ,LEASE_INV_ORG_YN OKL_SYSTEM_PARAMS.LEASE_INV_ORG_YN%TYPE := OKL_API.G_MISS_CHAR
20 --SECHAWLA 28-MAR-05 4274575 : Added 3 new columns
21 ,TAX_UPFRONT_YN OKL_SYSTEM_PARAMS.TAX_UPFRONT_YN%TYPE := OKL_API.G_MISS_CHAR
22 ,TAX_INVOICE_YN OKL_SYSTEM_PARAMS.TAX_INVOICE_YN%TYPE := OKL_API.G_MISS_CHAR
23 ,TAX_SCHEDULE_YN OKL_SYSTEM_PARAMS.TAX_SCHEDULE_YN%TYPE := OKL_API.G_MISS_CHAR
24 -- SECHAWLA 07-Jul-05 4274575 : added 1 new column
25 ,TAX_UPFRONT_STY_ID OKL_SYSTEM_PARAMS.TAX_UPFRONT_STY_ID%TYPE := OKL_API.G_MISS_NUM
26 -- PAGARG 24-JAN-05 4044659: Added the new column LEASE_INV_ORG_YN: end
27 -- asawanka 24-MAY-05 : Added the new column CATEGORY_SET_ID for Pricing Enhancements : begin
28 ,CATEGORY_SET_ID OKL_SYSTEM_PARAMS.CATEGORY_SET_ID%TYPE := OKL_API.G_MISS_NUM
29 -- asawanka 24-MAY-05 : Added the new column CATEGORY_SET_ID for Pricing Enhancements : end
30 -- ssdeshpa 2-SEP-05 : Added the new column VALIDATION_SET_ID for Sales Quote Enhancements : begin
31 ,VALIDATION_SET_ID OKL_SYSTEM_PARAMS.VALIDATION_SET_ID%TYPE := OKL_API.G_MISS_NUM
32 -- ssdeshpa 2-SEP-05 : Added the new column VALIDATION_SET_ID for Sales Quote Enhancements : end
33 ,CANCEL_QUOTES_YN OKL_SYSTEM_PARAMS.CANCEL_QUOTES_YN%TYPE := OKL_API.G_MISS_CHAR --RMUNJULU 4556370
34 ,CHK_ACCRUAL_PREVIOUS_MNTH_YN OKL_SYSTEM_PARAMS.CHK_ACCRUAL_PREVIOUS_MNTH_YN%TYPE := OKL_API.G_MISS_CHAR --RMUNJULU 4769094
35 -- gboomina 10-Apr-2005 - Added New Columns for Bug 5128517 - start
36 ,TASK_TEMPLATE_GROUP_ID OKL_SYSTEM_PARAMS.TASK_TEMPLATE_GROUP_ID%type := OKL_API.G_MISS_NUM
37 ,OWNER_TYPE_CODE OKL_SYSTEM_PARAMS.OWNER_TYPE_CODE%type := OKL_API.G_MISS_CHAR
38 ,OWNER_ID OKL_SYSTEM_PARAMS.OWNER_ID%type := OKL_API.G_MISS_NUM
39 -- gboomina Bug 5128517 - End
40 -- dcshanmu begin MOAC change for moving three new profiles to System Options
41 ,ITEM_INV_ORG_ID OKL_SYSTEM_PARAMS.ITEM_INV_ORG_ID%type :=
42 OKL_API.G_MISS_NUM
43 , RPT_PROD_BOOK_TYPE_CODE OKL_SYSTEM_PARAMS.RPT_PROD_BOOK_TYPE_CODE%type :=
44 OKL_API.G_MISS_CHAR
45 ,ASST_ADD_BOOK_TYPE_CODE OKL_SYSTEM_PARAMS.ASST_ADD_BOOK_TYPE_CODE%type :=
46 OKL_API.G_MISS_CHAR
47 ,CCARD_REMITTANCE_ID OKL_SYSTEM_PARAMS.CCARD_REMITTANCE_ID%type := OKL_API.G_MISS_NUM
48 -- dcshanmu end MOAC change for moving three new profiles to System Options
49
50 -- DJANASWA Bug 6653304 begin
51 ,CORPORATE_BOOK OKL_SYSTEM_PARAMS.CORPORATE_BOOK%type := OKL_API.G_MISS_CHAR
52 ,TAX_BOOK_1 OKL_SYSTEM_PARAMS.TAX_BOOK_1%type := OKL_API.G_MISS_CHAR
53 ,TAX_BOOK_2 OKL_SYSTEM_PARAMS.TAX_BOOK_2%type := OKL_API.G_MISS_CHAR
54 ,DEPRECIATE_YN OKL_SYSTEM_PARAMS.DEPRECIATE_YN%type := OKL_API.G_MISS_CHAR
55 ,FA_LOCATION_ID OKL_SYSTEM_PARAMS.FA_LOCATION_ID%type := OKL_API.G_MISS_NUM
56 ,FORMULA_ID OKL_SYSTEM_PARAMS.FORMULA_ID%type := OKL_API.G_MISS_NUM
57 ,ASSET_KEY_ID OKL_SYSTEM_PARAMS.ASSET_KEY_ID%type := OKL_API.G_MISS_NUM
58 -- DJANASWA Bug 6653304 end
59 -- Bug 5568328
60 ,part_trmnt_apply_round_diff okl_system_params.part_trmnt_apply_round_diff%type := okl_api.g_miss_char
61 ,object_version_number NUMBER := OKL_API.G_MISS_NUM
62 ,org_id NUMBER := OKL_API.G_MISS_NUM
63 ,request_id NUMBER := OKL_API.G_MISS_NUM
64 ,program_application_id NUMBER := OKL_API.G_MISS_NUM
65 ,program_id NUMBER := OKL_API.G_MISS_NUM
66 ,program_update_date OKL_SYSTEM_PARAMS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
67 ,attribute_category OKL_SYSTEM_PARAMS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
68 ,attribute1 OKL_SYSTEM_PARAMS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
69 ,attribute2 OKL_SYSTEM_PARAMS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
70 ,attribute3 OKL_SYSTEM_PARAMS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
71 ,attribute4 OKL_SYSTEM_PARAMS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
72 ,attribute5 OKL_SYSTEM_PARAMS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
73 ,attribute6 OKL_SYSTEM_PARAMS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
74 ,attribute7 OKL_SYSTEM_PARAMS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
75 ,attribute8 OKL_SYSTEM_PARAMS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
76 ,attribute9 OKL_SYSTEM_PARAMS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
77 ,attribute10 OKL_SYSTEM_PARAMS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
78 ,attribute11 OKL_SYSTEM_PARAMS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
79 ,attribute12 OKL_SYSTEM_PARAMS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
80 ,attribute13 OKL_SYSTEM_PARAMS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
81 ,attribute14 OKL_SYSTEM_PARAMS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
82 ,attribute15 OKL_SYSTEM_PARAMS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
83 ,created_by NUMBER := OKL_API.G_MISS_NUM
84 ,creation_date OKL_SYSTEM_PARAMS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
85 ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
86 ,last_update_date OKL_SYSTEM_PARAMS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
87 ,last_update_login NUMBER := OKL_API.G_MISS_NUM
88 --Bug 7022258-Added new columns by kkorrapo
89 ,lseapp_seq_prefix_txt OKL_SYSTEM_PARAMS.LSEAPP_SEQ_PREFIX_TXT%TYPE := OKL_API.G_MISS_CHAR
90 ,lseopp_seq_prefix_txt OKL_SYSTEM_PARAMS.LSEOPP_SEQ_PREFIX_TXT%TYPE := OKL_API.G_MISS_CHAR
91 ,qckqte_seq_prefix_txt OKL_SYSTEM_PARAMS.QCKQTE_SEQ_PREFIX_TXT%TYPE := OKL_API.G_MISS_CHAR
92 ,lseqte_seq_prefix_txt OKL_SYSTEM_PARAMS.LSEQTE_SEQ_PREFIX_TXT%TYPE := OKL_API.G_MISS_CHAR
93 --Bug 7022258-Addition end
94 );
95 G_Miss_sypv_rec sypv_rec_type;
96 TYPE sypv_tbl_type IS TABLE OF sypv_rec_type
97 INDEX BY BINARY_INTEGER;
98 -- OKL_SYSTEM_PARAMS_ALL Record Spec
99 TYPE syp_rec_type IS RECORD (
100 id NUMBER := OKL_API.G_MISS_NUM
101 ,delink_yn OKL_SYSTEM_PARAMS_ALL.DELINK_YN%TYPE := OKL_API.G_MISS_CHAR
102 -- SECHAWLA 28-SEP-04 3924244: Added the following new columns : begin
103 ,REMK_SUBINVENTORY OKL_SYSTEM_PARAMS_ALL.REMK_SUBINVENTORY%TYPE := OKL_API.G_MISS_CHAR
104 ,REMK_ORGANIZATION_ID OKL_SYSTEM_PARAMS_ALL.REMK_ORGANIZATION_ID%TYPE := OKL_API.G_MISS_NUM
105 ,REMK_PRICE_LIST_ID OKL_SYSTEM_PARAMS_ALL.REMK_PRICE_LIST_ID%TYPE := OKL_API.G_MISS_NUM
106 ,REMK_PROCESS_CODE OKL_SYSTEM_PARAMS_ALL.REMK_PROCESS_CODE%TYPE := OKL_API.G_MISS_CHAR
107 ,REMK_ITEM_TEMPLATE_ID OKL_SYSTEM_PARAMS_ALL.REMK_ITEM_TEMPLATE_ID%TYPE := OKL_API.G_MISS_NUM
108 ,REMK_ITEM_INVOICED_CODE OKL_SYSTEM_PARAMS_ALL.REMK_ITEM_INVOICED_CODE%TYPE := OKL_API.G_MISS_CHAR
109 -- SECHAWLA 28-SEP-04 3924244: Added the following new columns : end
110 -- PAGARG 24-JAN-05 4044659: Added the new column LEASE_INV_ORG_YN: begin
111 ,LEASE_INV_ORG_YN OKL_SYSTEM_PARAMS.LEASE_INV_ORG_YN%TYPE := OKL_API.G_MISS_CHAR
112 --28-MAR-05 SECHAWLA 4274575 : Added 3 new columns
113 ,TAX_UPFRONT_YN OKL_SYSTEM_PARAMS.TAX_UPFRONT_YN%TYPE := OKL_API.G_MISS_CHAR
114 ,TAX_INVOICE_YN OKL_SYSTEM_PARAMS.TAX_INVOICE_YN%TYPE := OKL_API.G_MISS_CHAR
115 ,TAX_SCHEDULE_YN OKL_SYSTEM_PARAMS.TAX_SCHEDULE_YN%TYPE := OKL_API.G_MISS_CHAR
116 --07-Jul-05 SECHAWLA 4274575 : Added 1 new column
117 ,TAX_UPFRONT_STY_ID OKL_SYSTEM_PARAMS.TAX_UPFRONT_STY_ID%TYPE := OKL_API.G_MISS_NUM
118 -- PAGARG 24-JAN-05 4044659: Added the new column LEASE_INV_ORG_YN: end
119 -- asawanka 24-MAY-05 : Added the new column CATEGORY_SET_ID for Pricing Enhancements : begin
120 ,CATEGORY_SET_ID OKL_SYSTEM_PARAMS_ALL.CATEGORY_SET_ID%TYPE := OKL_API.G_MISS_NUM
121 -- asawanka 24-MAY-05 : Added the new column CATEGORY_SET_ID for Pricing Enhancements : end
122 -- ssdeshpa 2-SEP-05 : Added the new column VALIDATION_SET_ID for Sales Quote Enhancements :
123 ,VALIDATION_SET_ID OKL_SYSTEM_PARAMS.VALIDATION_SET_ID%TYPE := OKL_API.G_MISS_NUM
124 -- ssdeshpa 2-SEP-05 : Added the new column VALIDATION_SET_ID for Sales Quote Enhancements :
125 ,CANCEL_QUOTES_YN OKL_SYSTEM_PARAMS_ALL.CANCEL_QUOTES_YN%TYPE := OKL_API.G_MISS_CHAR --RMUNJULU 4556370
126 ,CHK_ACCRUAL_PREVIOUS_MNTH_YN OKL_SYSTEM_PARAMS_ALL.CHK_ACCRUAL_PREVIOUS_MNTH_YN%TYPE := OKL_API.G_MISS_CHAR --RMUNJULU 4769094
127 -- gboomina 10-Apr-2005 - Added New Columns for Bug 5128517 - start
128 ,TASK_TEMPLATE_GROUP_ID OKL_SYSTEM_PARAMS.task_template_group_id%type := OKL_API.G_MISS_NUM
129 ,OWNER_TYPE_CODE OKL_SYSTEM_PARAMS.OWNER_TYPE_CODE%type := OKL_API.G_MISS_CHAR
130 ,OWNER_ID OKL_SYSTEM_PARAMS.owner_id%type := OKL_API.G_MISS_NUM
131 -- gboomina Bug 5128517 - End
132
133 -- DJANASWA Bug 6653304 begin
134 ,CORPORATE_BOOK OKL_SYSTEM_PARAMS_ALL.CORPORATE_BOOK%type := OKL_API.G_MISS_CHAR
135 ,TAX_BOOK_1 OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_1%type := OKL_API.G_MISS_CHAR
136 ,TAX_BOOK_2 OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_2%type := OKL_API.G_MISS_CHAR
137 ,DEPRECIATE_YN OKL_SYSTEM_PARAMS_ALL.DEPRECIATE_YN%type := OKL_API.G_MISS_CHAR
138 ,FA_LOCATION_ID OKL_SYSTEM_PARAMS_ALL.FA_LOCATION_ID%type := OKL_API.G_MISS_NUM
139 ,FORMULA_ID OKL_SYSTEM_PARAMS_ALL.FORMULA_ID%type := OKL_API.G_MISS_NUM
140 ,ASSET_KEY_ID OKL_SYSTEM_PARAMS_ALL.ASSET_KEY_ID%type := OKL_API.G_MISS_NUM
141 -- DJANASWA Bug 6653304 end
142 -- Bug 5568328
143 ,part_trmnt_apply_round_diff okl_system_params.part_trmnt_apply_round_diff%type := okl_api.g_miss_char
144 ,object_version_number NUMBER := OKL_API.G_MISS_NUM
145 ,org_id NUMBER := OKL_API.G_MISS_NUM
146 ,request_id NUMBER := OKL_API.G_MISS_NUM
147 ,program_application_id NUMBER := OKL_API.G_MISS_NUM
148 ,program_id NUMBER := OKL_API.G_MISS_NUM
149 ,program_update_date OKL_SYSTEM_PARAMS_ALL.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
150 ,attribute_category OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
151 ,attribute1 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
152 ,attribute2 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
153 ,attribute3 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
154 ,attribute4 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
155 ,attribute5 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
156 ,attribute6 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
157 ,attribute7 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
158 ,attribute8 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
159 ,attribute9 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
160 ,attribute10 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
161 ,attribute11 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
162 ,attribute12 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
163 ,attribute13 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
164 ,attribute14 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
165 ,attribute15 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
166 ,created_by NUMBER := OKL_API.G_MISS_NUM
167 ,creation_date OKL_SYSTEM_PARAMS_ALL.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
168 ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
169 ,last_update_date OKL_SYSTEM_PARAMS_ALL.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
170 ,last_update_login NUMBER := OKL_API.G_MISS_NUM
171 --added by akrangan on 28/07/2006 since new columns were added to the table as part of moac changes
172 ,item_inv_org_id NUMBER := OKL_API.G_MISS_NUM
173 ,rpt_prod_book_type_code OKL_SYSTEM_PARAMS_ALL.RPT_PROD_BOOK_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
174 ,asst_add_book_type_code OKL_SYSTEM_PARAMS_ALL.ASST_ADD_BOOK_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
175 ,ccard_remittance_id OKL_SYSTEM_PARAMS_ALL.CCARD_REMITTANCE_ID%TYPE := OKL_API.G_MISS_NUM
176 --Bug 7022258-Added new columns by kkorrapo
177 ,lseapp_seq_prefix_txt OKL_SYSTEM_PARAMS_ALL.LSEAPP_SEQ_PREFIX_TXT%TYPE := OKL_API.G_MISS_CHAR
178 ,lseopp_seq_prefix_txt OKL_SYSTEM_PARAMS_ALL.LSEOPP_SEQ_PREFIX_TXT%TYPE := OKL_API.G_MISS_CHAR
179 ,qckqte_seq_prefix_txt OKL_SYSTEM_PARAMS_ALL.QCKQTE_SEQ_PREFIX_TXT%TYPE := OKL_API.G_MISS_CHAR
180 ,lseqte_seq_prefix_txt OKL_SYSTEM_PARAMS_ALL.LSEQTE_SEQ_PREFIX_TXT%TYPE := OKL_API.G_MISS_CHAR
181 --Bug 7022258-Addition end
182 );
183 G_MISS_syp_rec syp_rec_type;
184 TYPE syp_tbl_type IS TABLE OF syp_rec_type
185 INDEX BY BINARY_INTEGER;
186 ---------------------------------------------------------------------------
187 -- GLOBAL MESSAGE CONSTANTS
188 ---------------------------------------------------------------------------
189 G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
190 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
191 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
192 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
193 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
194 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
195 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
196 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
197 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
198 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
199 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
200 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
201 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
202
203 ---------------------------------------------------------------------------
204 -- GLOBAL EXCEPTIONS
205 ---------------------------------------------------------------------------
206 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
207 -- SECHAWLA Added
208 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
209 ---------------------------------------------------------------------------
210 -- GLOBAL VARIABLES
211 ---------------------------------------------------------------------------
212 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_SYP_PVT';
213 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
214 G_APP_NAME_1 CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
215 ---------------------------------------------------------------------------
216 -- Procedures and Functions
217 ---------------------------------------------------------------------------
218
219 PROCEDURE qc;
220 PROCEDURE change_version;
221 PROCEDURE api_copy;
222 PROCEDURE insert_row(
223 p_api_version IN NUMBER,
224 p_init_msg_list IN VARCHAR2,
225 x_return_status OUT NOCOPY VARCHAR2,
226 x_msg_count OUT NOCOPY NUMBER,
227 x_msg_data OUT NOCOPY VARCHAR2,
228 p_sypv_rec IN sypv_rec_type,
229 x_sypv_rec OUT NOCOPY sypv_rec_type);
230 PROCEDURE insert_row(
231 p_api_version IN NUMBER,
232 p_init_msg_list IN VARCHAR2,
233 x_return_status OUT NOCOPY VARCHAR2,
234 x_msg_count OUT NOCOPY NUMBER,
235 x_msg_data OUT NOCOPY VARCHAR2,
236 p_sypv_tbl IN sypv_tbl_type,
237 x_sypv_tbl OUT NOCOPY sypv_tbl_type,
238 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
239 PROCEDURE insert_row(
240 p_api_version IN NUMBER,
241 p_init_msg_list IN VARCHAR2,
242 x_return_status OUT NOCOPY VARCHAR2,
243 x_msg_count OUT NOCOPY NUMBER,
244 x_msg_data OUT NOCOPY VARCHAR2,
245 p_sypv_tbl IN sypv_tbl_type,
246 x_sypv_tbl OUT NOCOPY sypv_tbl_type);
247 PROCEDURE lock_row(
248 p_api_version IN NUMBER,
249 p_init_msg_list IN VARCHAR2,
250 x_return_status OUT NOCOPY VARCHAR2,
251 x_msg_count OUT NOCOPY NUMBER,
252 x_msg_data OUT NOCOPY VARCHAR2,
253 p_sypv_rec IN sypv_rec_type);
254 PROCEDURE lock_row(
255 p_api_version IN NUMBER,
256 p_init_msg_list IN VARCHAR2,
257 x_return_status OUT NOCOPY VARCHAR2,
258 x_msg_count OUT NOCOPY NUMBER,
259 x_msg_data OUT NOCOPY VARCHAR2,
260 p_sypv_tbl IN sypv_tbl_type,
261 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
262 PROCEDURE lock_row(
263 p_api_version IN NUMBER,
264 p_init_msg_list IN VARCHAR2,
265 x_return_status OUT NOCOPY VARCHAR2,
266 x_msg_count OUT NOCOPY NUMBER,
267 x_msg_data OUT NOCOPY VARCHAR2,
268 p_sypv_tbl IN sypv_tbl_type);
269 PROCEDURE update_row(
270 p_api_version IN NUMBER,
271 p_init_msg_list IN VARCHAR2,
272 x_return_status OUT NOCOPY VARCHAR2,
273 x_msg_count OUT NOCOPY NUMBER,
274 x_msg_data OUT NOCOPY VARCHAR2,
275 p_sypv_rec IN sypv_rec_type,
276 x_sypv_rec OUT NOCOPY sypv_rec_type);
277 PROCEDURE update_row(
278 p_api_version IN NUMBER,
279 p_init_msg_list IN VARCHAR2,
280 x_return_status OUT NOCOPY VARCHAR2,
281 x_msg_count OUT NOCOPY NUMBER,
282 x_msg_data OUT NOCOPY VARCHAR2,
283 p_sypv_tbl IN sypv_tbl_type,
284 x_sypv_tbl OUT NOCOPY sypv_tbl_type,
285 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
286 PROCEDURE update_row(
287 p_api_version IN NUMBER,
288 p_init_msg_list IN VARCHAR2,
289 x_return_status OUT NOCOPY VARCHAR2,
290 x_msg_count OUT NOCOPY NUMBER,
291 x_msg_data OUT NOCOPY VARCHAR2,
292 p_sypv_tbl IN sypv_tbl_type,
293 x_sypv_tbl OUT NOCOPY sypv_tbl_type);
294 PROCEDURE delete_row(
295 p_api_version IN NUMBER,
296 p_init_msg_list IN VARCHAR2,
297 x_return_status OUT NOCOPY VARCHAR2,
298 x_msg_count OUT NOCOPY NUMBER,
299 x_msg_data OUT NOCOPY VARCHAR2,
300 p_sypv_rec IN sypv_rec_type);
301 PROCEDURE delete_row(
302 p_api_version IN NUMBER,
303 p_init_msg_list IN VARCHAR2,
304 x_return_status OUT NOCOPY VARCHAR2,
305 x_msg_count OUT NOCOPY NUMBER,
306 x_msg_data OUT NOCOPY VARCHAR2,
307 p_sypv_tbl IN sypv_tbl_type,
308 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
309 PROCEDURE delete_row(
310 p_api_version IN NUMBER,
311 p_init_msg_list IN VARCHAR2,
312 x_return_status OUT NOCOPY VARCHAR2,
313 x_msg_count OUT NOCOPY NUMBER,
314 x_msg_data OUT NOCOPY VARCHAR2,
315 p_sypv_tbl IN sypv_tbl_type);
316 PROCEDURE validate_row(
317 p_api_version IN NUMBER,
318 p_init_msg_list IN VARCHAR2,
319 x_return_status OUT NOCOPY VARCHAR2,
320 x_msg_count OUT NOCOPY NUMBER,
321 x_msg_data OUT NOCOPY VARCHAR2,
322 p_sypv_rec IN sypv_rec_type);
323 PROCEDURE validate_row(
324 p_api_version IN NUMBER,
325 p_init_msg_list IN VARCHAR2,
326 x_return_status OUT NOCOPY VARCHAR2,
327 x_msg_count OUT NOCOPY NUMBER,
328 x_msg_data OUT NOCOPY VARCHAR2,
329 p_sypv_tbl IN sypv_tbl_type,
330 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
331 PROCEDURE validate_row(
332 p_api_version IN NUMBER,
333 p_init_msg_list IN VARCHAR2,
334 x_return_status OUT NOCOPY VARCHAR2,
335 x_msg_count OUT NOCOPY NUMBER,
336 x_msg_data OUT NOCOPY VARCHAR2,
337 p_sypv_tbl IN sypv_tbl_type);
338 END OKL_SYP_PVT;