[Home] [Help]
PACKAGE: APPS.OKL_SIX_PVT
Source
1 PACKAGE OKL_SIX_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLSSIXS.pls 120.1 2005/10/30 03:18:09 appldev noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 -- OKL_TRX_SUBSIDY_POOLS_V Record Spec
7 TYPE sixv_rec_type IS RECORD (
8 id NUMBER := OKC_API.G_MISS_NUM
9 ,object_version_number NUMBER := OKC_API.G_MISS_NUM
10 ,trx_type_code OKL_TRX_SUBSIDY_POOLS_V.TRX_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
11 ,source_type_code OKL_TRX_SUBSIDY_POOLS_V.SOURCE_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
12 ,source_object_id NUMBER := OKC_API.G_MISS_NUM
13 ,subsidy_pool_id NUMBER := OKC_API.G_MISS_NUM
14 ,dnz_asset_number OKL_TRX_SUBSIDY_POOLS_V.DNZ_ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
15 ,vendor_id NUMBER := OKC_API.G_MISS_NUM
16 ,source_trx_date OKL_TRX_SUBSIDY_POOLS_V.SOURCE_TRX_DATE%TYPE := OKC_API.G_MISS_DATE
17 ,trx_date OKL_TRX_SUBSIDY_POOLS_V.TRX_DATE%TYPE := OKC_API.G_MISS_DATE
18 ,subsidy_id NUMBER := OKC_API.G_MISS_NUM
19 ,trx_reason_code OKL_TRX_SUBSIDY_POOLS_V.TRX_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
20 ,trx_currency_code OKL_TRX_SUBSIDY_POOLS_V.TRX_CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
21 ,trx_amount NUMBER := OKC_API.G_MISS_NUM
22 ,subsidy_pool_currency_code OKL_TRX_SUBSIDY_POOLS_V.SUBSIDY_POOL_CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
23 ,subsidy_pool_amount NUMBER := OKC_API.G_MISS_NUM
24 ,conversion_rate NUMBER := OKC_API.G_MISS_NUM
25 ,attribute_category OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
26 ,attribute1 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
27 ,attribute2 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
28 ,attribute3 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
29 ,attribute4 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
30 ,attribute5 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
31 ,attribute6 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
32 ,attribute7 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
33 ,attribute8 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
34 ,attribute9 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
35 ,attribute10 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
36 ,attribute11 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
37 ,attribute12 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
38 ,attribute13 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
39 ,attribute14 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
40 ,attribute15 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
41 ,created_by NUMBER := OKC_API.G_MISS_NUM
42 ,creation_date OKL_TRX_SUBSIDY_POOLS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
43 ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
44 ,last_update_date OKL_TRX_SUBSIDY_POOLS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
45 ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
46 G_MISS_sixv_rec sixv_rec_type;
47 TYPE sixv_tbl_type IS TABLE OF sixv_rec_type
48 INDEX BY BINARY_INTEGER;
49 -- OKL_TRX_SUBSIDY_POOLS Record Spec
50 TYPE okl_trx_subsidy_pools_rec_type IS RECORD (
51 id NUMBER := OKC_API.G_MISS_NUM
52 ,object_version_number NUMBER := OKC_API.G_MISS_NUM
53 ,trx_type_code OKL_TRX_SUBSIDY_POOLS.TRX_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
54 ,source_type_code OKL_TRX_SUBSIDY_POOLS.SOURCE_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
55 ,source_object_id NUMBER := OKC_API.G_MISS_NUM
56 ,subsidy_pool_id NUMBER := OKC_API.G_MISS_NUM
57 ,dnz_asset_number OKL_TRX_SUBSIDY_POOLS.DNZ_ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
58 ,vendor_id NUMBER := OKC_API.G_MISS_NUM
59 ,source_trx_date OKL_TRX_SUBSIDY_POOLS.SOURCE_TRX_DATE%TYPE := OKC_API.G_MISS_DATE
60 ,trx_date OKL_TRX_SUBSIDY_POOLS.TRX_DATE%TYPE := OKC_API.G_MISS_DATE
61 ,subsidy_id NUMBER := OKC_API.G_MISS_NUM
65 ,subsidy_pool_currency_code OKL_TRX_SUBSIDY_POOLS.SUBSIDY_POOL_CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
62 ,trx_reason_code OKL_TRX_SUBSIDY_POOLS.TRX_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
63 ,trx_currency_code OKL_TRX_SUBSIDY_POOLS.TRX_CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
64 ,trx_amount NUMBER := OKC_API.G_MISS_NUM
66 ,subsidy_pool_amount NUMBER := OKC_API.G_MISS_NUM
67 ,conversion_rate NUMBER := OKC_API.G_MISS_NUM
68 ,attribute_category OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
69 ,attribute1 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
70 ,attribute2 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
71 ,attribute3 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
72 ,attribute4 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
73 ,attribute5 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
74 ,attribute6 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
75 ,attribute7 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
76 ,attribute8 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
77 ,attribute9 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
78 ,attribute10 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
79 ,attribute11 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
80 ,attribute12 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
81 ,attribute13 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
82 ,attribute14 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
83 ,attribute15 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
84 ,created_by NUMBER := OKC_API.G_MISS_NUM
85 ,creation_date OKL_TRX_SUBSIDY_POOLS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
86 ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
87 ,last_update_date OKL_TRX_SUBSIDY_POOLS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
88 ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
89 GMissOklTrxSubsidyPoolsRec okl_trx_subsidy_pools_rec_type;
90 TYPE okl_trx_subsidy_pools_tbl_type IS TABLE OF okl_trx_subsidy_pools_rec_type
91 INDEX BY BINARY_INTEGER;
92 ---------------------------------------------------------------------------
93 -- GLOBAL MESSAGE CONSTANTS
94 ---------------------------------------------------------------------------
95 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
96 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
97 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
98 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
99 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
100 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
101 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
102 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
103 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
104 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
105 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
106 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
107 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
108
109 ---------------------------------------------------------------------------
110 -- GLOBAL EXCEPTIONS
111 ---------------------------------------------------------------------------
112 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
113
114 ---------------------------------------------------------------------------
115 -- GLOBAL VARIABLES
116 ---------------------------------------------------------------------------
117 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_SIX_PVT';
118 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
119 ---------------------------------------------------------------------------
120 -- Procedures and Functions
121 ---------------------------------------------------------------------------
122
123 PROCEDURE qc;
124 PROCEDURE change_version;
125 PROCEDURE api_copy;
126 PROCEDURE insert_row(
127 p_api_version IN NUMBER,
128 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
129 x_return_status OUT NOCOPY VARCHAR2,
130 x_msg_count OUT NOCOPY NUMBER,
131 x_msg_data OUT NOCOPY VARCHAR2,
132 p_sixv_rec IN sixv_rec_type,
133 x_sixv_rec OUT NOCOPY sixv_rec_type);
134 PROCEDURE insert_row(
135 p_api_version IN NUMBER,
136 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
137 x_return_status OUT NOCOPY VARCHAR2,
138 x_msg_count OUT NOCOPY NUMBER,
139 x_msg_data OUT NOCOPY VARCHAR2,
140 p_sixv_tbl IN sixv_tbl_type,
141 x_sixv_tbl OUT NOCOPY sixv_tbl_type,
142 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
143 PROCEDURE insert_row(
144 p_api_version IN NUMBER,
148 x_msg_data OUT NOCOPY VARCHAR2,
145 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
146 x_return_status OUT NOCOPY VARCHAR2,
147 x_msg_count OUT NOCOPY NUMBER,
149 p_sixv_tbl IN sixv_tbl_type,
150 x_sixv_tbl OUT NOCOPY sixv_tbl_type);
151 PROCEDURE lock_row(
152 p_api_version IN NUMBER,
153 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
154 x_return_status OUT NOCOPY VARCHAR2,
155 x_msg_count OUT NOCOPY NUMBER,
156 x_msg_data OUT NOCOPY VARCHAR2,
157 p_sixv_rec IN sixv_rec_type);
158 PROCEDURE lock_row(
159 p_api_version IN NUMBER,
160 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
161 x_return_status OUT NOCOPY VARCHAR2,
162 x_msg_count OUT NOCOPY NUMBER,
163 x_msg_data OUT NOCOPY VARCHAR2,
164 p_sixv_tbl IN sixv_tbl_type,
165 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
166 PROCEDURE lock_row(
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_sixv_tbl IN sixv_tbl_type);
173 PROCEDURE update_row(
174 p_api_version IN NUMBER,
175 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
176 x_return_status OUT NOCOPY VARCHAR2,
177 x_msg_count OUT NOCOPY NUMBER,
178 x_msg_data OUT NOCOPY VARCHAR2,
179 p_sixv_rec IN sixv_rec_type,
180 x_sixv_rec OUT NOCOPY sixv_rec_type);
181 PROCEDURE update_row(
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_sixv_tbl IN sixv_tbl_type,
188 x_sixv_tbl OUT NOCOPY sixv_tbl_type,
189 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
190 PROCEDURE update_row(
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_sixv_tbl IN sixv_tbl_type,
197 x_sixv_tbl OUT NOCOPY sixv_tbl_type);
198 PROCEDURE delete_row(
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_sixv_rec IN sixv_rec_type);
205 PROCEDURE delete_row(
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_sixv_tbl IN sixv_tbl_type,
212 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
213 PROCEDURE delete_row(
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_sixv_tbl IN sixv_tbl_type);
220 PROCEDURE validate_row(
221 p_api_version IN NUMBER,
222 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
223 x_return_status OUT NOCOPY VARCHAR2,
224 x_msg_count OUT NOCOPY NUMBER,
225 x_msg_data OUT NOCOPY VARCHAR2,
226 p_sixv_rec IN sixv_rec_type);
227 PROCEDURE validate_row(
228 p_api_version IN NUMBER,
229 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
230 x_return_status OUT NOCOPY VARCHAR2,
231 x_msg_count OUT NOCOPY NUMBER,
232 x_msg_data OUT NOCOPY VARCHAR2,
233 p_sixv_tbl IN sixv_tbl_type,
234 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
235 PROCEDURE validate_row(
236 p_api_version IN NUMBER,
237 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
238 x_return_status OUT NOCOPY VARCHAR2,
239 x_msg_count OUT NOCOPY NUMBER,
240 x_msg_data OUT NOCOPY VARCHAR2,
241 p_sixv_tbl IN sixv_tbl_type);
242 END OKL_SIX_PVT;