[Home] [Help]
PACKAGE: APPS.OKL_BTC_PVT
Source
1 PACKAGE Okl_Btc_Pvt AS
2 /*$Header: OKLSBTCS.pls 120.5 2007/09/06 12:30:48 sosharma noship $*/
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE btc_rec_type IS RECORD (
7 id NUMBER := Okl_Api.G_MISS_NUM,
8 object_version_number NUMBER := Okl_Api.G_MISS_NUM,
9 date_entered OKL_TRX_CSH_BATCH_B.DATE_ENTERED%TYPE := Okl_Api.G_MISS_DATE,
10 date_gl_requested OKL_TRX_CSH_BATCH_B.DATE_GL_REQUESTED%TYPE := Okl_Api.G_MISS_DATE,
11 date_deposit OKL_TRX_CSH_BATCH_B.DATE_DEPOSIT%TYPE := Okl_Api.G_MISS_DATE,
12 batch_qty NUMBER := Okl_Api.G_MISS_NUM,
13 batch_total NUMBER := Okl_Api.G_MISS_NUM,
14 batch_currency OKL_TRX_CSH_BATCH_B.BATCH_CURRENCY%TYPE := Okl_Api.G_MISS_CHAR,
15 irm_id OKL_TRX_CSH_BATCH_B.IRM_ID%TYPE := Okl_Api.G_MISS_NUM,
16 request_id NUMBER := Okl_Api.G_MISS_NUM,
17 program_application_id NUMBER := Okl_Api.G_MISS_NUM,
18 program_id NUMBER := Okl_Api.G_MISS_NUM,
19 program_update_date OKL_TRX_CSH_BATCH_B.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
20 org_id NUMBER := Okl_Api.G_MISS_NUM,
21 attribute_category OKL_TRX_CSH_BATCH_B.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
22 attribute1 OKL_TRX_CSH_BATCH_B.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
23 attribute2 OKL_TRX_CSH_BATCH_B.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
24 attribute3 OKL_TRX_CSH_BATCH_B.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
25 attribute4 OKL_TRX_CSH_BATCH_B.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
26 attribute5 OKL_TRX_CSH_BATCH_B.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
27 attribute6 OKL_TRX_CSH_BATCH_B.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
28 attribute7 OKL_TRX_CSH_BATCH_B.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
29 attribute8 OKL_TRX_CSH_BATCH_B.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
30 attribute9 OKL_TRX_CSH_BATCH_B.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
31 attribute10 OKL_TRX_CSH_BATCH_B.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
32 attribute11 OKL_TRX_CSH_BATCH_B.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
33 attribute12 OKL_TRX_CSH_BATCH_B.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
34 attribute13 OKL_TRX_CSH_BATCH_B.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
35 attribute14 OKL_TRX_CSH_BATCH_B.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
36 attribute15 OKL_TRX_CSH_BATCH_B.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
37 created_by NUMBER := Okl_Api.G_MISS_NUM,
38 creation_date OKL_TRX_CSH_BATCH_B.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
39 last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
40 last_update_date OKL_TRX_CSH_BATCH_B.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
41 last_update_login NUMBER := Okl_Api.G_MISS_NUM,
42 trx_status_code OKL_TRX_CSH_BATCH_B.TRX_STATUS_CODE%TYPE := Okl_Api.G_MISS_CHAR,
43 currency_conversion_type OKL_TRX_CSH_BATCH_B.currency_conversion_type%TYPE := Okl_Api.G_MISS_CHAR,
44 currency_conversion_rate OKL_TRX_CSH_BATCH_B.currency_conversion_rate%TYPE := Okl_Api.G_MISS_NUM,
45 currency_conversion_date OKL_TRX_CSH_BATCH_B.currency_conversion_date%TYPE := Okl_Api.G_MISS_DATE,
46 remit_bank_id OKL_TRX_CSH_BATCH_B.REMIT_BANK_ID%TYPE := Okl_Api.G_MISS_NUM
47
48 );
49 g_miss_btc_rec btc_rec_type;
50 TYPE btc_tbl_type IS TABLE OF btc_rec_type
51 INDEX BY BINARY_INTEGER;
52 TYPE okl_trx_csh_batch_tl_rec_type IS RECORD (
53 id NUMBER := Okl_Api.G_MISS_NUM,
54 LANGUAGE OKL_TRX_CSH_BATCH_TL.LANGUAGE%TYPE := Okl_Api.G_MISS_CHAR,
55 source_lang OKL_TRX_CSH_BATCH_TL.SOURCE_LANG%TYPE := Okl_Api.G_MISS_CHAR,
56 sfwt_flag OKL_TRX_CSH_BATCH_TL.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
57 name OKL_TRX_CSH_BATCH_TL.NAME%TYPE := Okl_Api.G_MISS_CHAR,
58 description OKL_TRX_CSH_BATCH_TL.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
59 created_by NUMBER := Okl_Api.G_MISS_NUM,
60 creation_date OKL_TRX_CSH_BATCH_TL.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
61 last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
62 last_update_date OKL_TRX_CSH_BATCH_TL.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
63 last_update_login NUMBER := Okl_Api.G_MISS_NUM);
64 GMissOklTrxCshBatchTlRec okl_trx_csh_batch_tl_rec_type;
65 TYPE okl_trx_csh_batch_tl_tbl_type IS TABLE OF okl_trx_csh_batch_tl_rec_type
66 INDEX BY BINARY_INTEGER;
67 TYPE btcv_rec_type IS RECORD (
68 id NUMBER := Okl_Api.G_MISS_NUM,
69 object_version_number NUMBER := Okl_Api.G_MISS_NUM,
70 sfwt_flag OKL_TRX_CSH_BATCH_V.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
71 name OKL_TRX_CSH_BATCH_V.NAME%TYPE := Okl_Api.G_MISS_CHAR,
72 date_entered OKL_TRX_CSH_BATCH_V.DATE_ENTERED%TYPE := Okl_Api.G_MISS_DATE,
73 date_gl_requested OKL_TRX_CSH_BATCH_V.DATE_GL_REQUESTED%TYPE := Okl_Api.G_MISS_DATE,
74 date_deposit OKL_TRX_CSH_BATCH_V.DATE_DEPOSIT%TYPE := Okl_Api.G_MISS_DATE,
75 batch_qty NUMBER := Okl_Api.G_MISS_NUM,
76 batch_total NUMBER := Okl_Api.G_MISS_NUM,
77 batch_currency OKL_TRX_CSH_BATCH_B.BATCH_CURRENCY%TYPE := Okl_Api.G_MISS_CHAR,
78 irm_id OKL_TRX_CSH_BATCH_B.IRM_ID%TYPE := Okl_Api.G_MISS_NUM,
79 description OKL_TRX_CSH_BATCH_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
80 attribute_category OKL_TRX_CSH_BATCH_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
81 attribute1 OKL_TRX_CSH_BATCH_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
82 attribute2 OKL_TRX_CSH_BATCH_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
83 attribute3 OKL_TRX_CSH_BATCH_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
84 attribute4 OKL_TRX_CSH_BATCH_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
85 attribute5 OKL_TRX_CSH_BATCH_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
86 attribute6 OKL_TRX_CSH_BATCH_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
87 attribute7 OKL_TRX_CSH_BATCH_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
88 attribute8 OKL_TRX_CSH_BATCH_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
89 attribute9 OKL_TRX_CSH_BATCH_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
90 attribute10 OKL_TRX_CSH_BATCH_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
91 attribute11 OKL_TRX_CSH_BATCH_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
92 attribute12 OKL_TRX_CSH_BATCH_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
93 attribute13 OKL_TRX_CSH_BATCH_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
94 attribute14 OKL_TRX_CSH_BATCH_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
95 attribute15 OKL_TRX_CSH_BATCH_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
96 request_id NUMBER := Okl_Api.G_MISS_NUM,
97 program_application_id NUMBER := Okl_Api.G_MISS_NUM,
98 program_id NUMBER := Okl_Api.G_MISS_NUM,
99 program_update_date OKL_TRX_CSH_BATCH_V.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
100 org_id NUMBER := Okl_Api.G_MISS_NUM,
101 created_by NUMBER := Okl_Api.G_MISS_NUM,
102 creation_date OKL_TRX_CSH_BATCH_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
103 last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
104 last_update_date OKL_TRX_CSH_BATCH_V.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
105 last_update_login NUMBER := Okl_Api.G_MISS_NUM,
106 trx_status_code OKL_TRX_CSH_BATCH_V.TRX_STATUS_CODE%TYPE := Okl_Api.G_MISS_CHAR,
107 currency_conversion_type OKL_TRX_CSH_BATCH_B.currency_conversion_type%TYPE := Okl_Api.G_MISS_CHAR,
108 currency_conversion_rate OKL_TRX_CSH_BATCH_B.currency_conversion_rate%TYPE := Okl_Api.G_MISS_NUM,
109 currency_conversion_date OKL_TRX_CSH_BATCH_B.currency_conversion_date%TYPE := Okl_Api.G_MISS_DATE,
110 remit_bank_id OKL_TRX_CSH_BATCH_B.REMIT_BANK_ID%TYPE := Okl_Api.G_MISS_NUM
111 );
112
113 g_miss_btcv_rec btcv_rec_type;
114 TYPE btcv_tbl_type IS TABLE OF btcv_rec_type
115 INDEX BY BINARY_INTEGER;
116 ---------------------------------------------------------------------------
117 -- GLOBAL MESSAGE CONSTANTS
118 ---------------------------------------------------------------------------
119 G_FND_APP CONSTANT VARCHAR2(200) := Okl_Api.G_FND_APP;
120 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_UNABLE_TO_RESERVE_REC;
121 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
122 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
123 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
124 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
125 G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
126 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
127 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
128 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;
129 G_NOT_SAME CONSTANT VARCHAR2(200) := 'OKL_CANNOT_BE_SAME';
130 ---------------------------------------------------------------------------
131 -- GLOBAL VARIABLES
132 ---------------------------------------------------------------------------
133 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_BTC_PVT';
134 G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;
135 ---------------------------------------------------------------------------
136 -- ADDED AFTER TAPI 04/17/2001
137 ---------------------------------------------------------------------------
138 ---------------------------------------------------------------------------
139 -- GLOBAL MESSAGES
140 ---------------------------------------------------------------------------
141 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
142 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
143 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
144 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
145
146 ---------------------------------------------------------------------------
147 -- GLOBAL VARIABLES
148 ---------------------------------------------------------------------------
149 G_VIEW CONSTANT VARCHAR2(30) := 'OKL_TRX_AR_INVOICES_V';
150 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
151
152 ---------------------------------------------------------------------------
153 -- POST GEN TAPI CODE ENDS HERE 04/17/2001
154 ---------------------------------------------------------------------------
155 ---------------------------------------------------------------------------
156 -- Procedures and Functions
157 ---------------------------------------------------------------------------
158
159 PROCEDURE qc;
160 PROCEDURE change_version;
161 PROCEDURE api_copy;
162 PROCEDURE add_language;
163 PROCEDURE insert_row(
164 p_api_version IN NUMBER,
165 p_init_msg_list IN VARCHAR2 DEFAULT Okl_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_btcv_rec IN btcv_rec_type,
170 x_btcv_rec OUT NOCOPY btcv_rec_type);
171
172 PROCEDURE insert_row(
173 p_api_version IN NUMBER,
174 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
175 x_return_status OUT NOCOPY VARCHAR2,
176 x_msg_count OUT NOCOPY NUMBER,
177 x_msg_data OUT NOCOPY VARCHAR2,
178 p_btcv_tbl IN btcv_tbl_type,
179 x_btcv_tbl OUT NOCOPY btcv_tbl_type);
180
181 PROCEDURE lock_row(
182 p_api_version IN NUMBER,
183 p_init_msg_list IN VARCHAR2 DEFAULT Okl_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_btcv_rec IN btcv_rec_type);
188
189 PROCEDURE lock_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_btcv_tbl IN btcv_tbl_type);
196
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_btcv_rec IN btcv_rec_type,
204 x_btcv_rec OUT NOCOPY btcv_rec_type);
205
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_btcv_tbl IN btcv_tbl_type,
213 x_btcv_tbl OUT NOCOPY btcv_tbl_type);
214
215 PROCEDURE delete_row(
216 p_api_version IN NUMBER,
217 p_init_msg_list IN VARCHAR2 DEFAULT Okl_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_btcv_rec IN btcv_rec_type);
222
223 PROCEDURE delete_row(
224 p_api_version IN NUMBER,
225 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
226 x_return_status OUT NOCOPY VARCHAR2,
227 x_msg_count OUT NOCOPY NUMBER,
228 x_msg_data OUT NOCOPY VARCHAR2,
229 p_btcv_tbl IN btcv_tbl_type);
230
231 PROCEDURE validate_row(
232 p_api_version IN NUMBER,
233 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
234 x_return_status OUT NOCOPY VARCHAR2,
235 x_msg_count OUT NOCOPY NUMBER,
236 x_msg_data OUT NOCOPY VARCHAR2,
237 p_btcv_rec IN btcv_rec_type);
238
239 PROCEDURE validate_row(
240 p_api_version IN NUMBER,
241 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
242 x_return_status OUT NOCOPY VARCHAR2,
243 x_msg_count OUT NOCOPY NUMBER,
244 x_msg_data OUT NOCOPY VARCHAR2,
245 p_btcv_tbl IN btcv_tbl_type);
246
247 END Okl_Btc_Pvt;