eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_INT_EXT_CSH_APP_PVT dependencies on OKL_TRX_CSH_RECEIPT_V

Line 162: okl_trx_csh_receipt_v rct,

158: rct.attribute13,
159: rct.attribute14,
160: rct.attribute15
161: FROM okl_trx_csh_batch_v btc,
162: okl_trx_csh_receipt_v rct,
163: okl_txl_rcpt_apps_v rca
164: WHERE btc.ID = rct.btc_id
165: AND rct.ID = rca.rct_id_details
166: AND rct.btc_id = cp_btc_id;

Line 176: l_amount okl_trx_csh_receipt_v.amount%TYPE

172: WHERE cust_account_id = c_acct_id;
173:
174: i NUMBER := 0;
175:
176: l_amount okl_trx_csh_receipt_v.amount%TYPE
177: DEFAULT NULL;
178: l_api_version NUMBER DEFAULT 1.0;
179: l_appl_tbl okl_receipts_pvt.appl_tbl_type;
180: l_ar_inv_id okl_txl_rcpt_apps_v.ar_invoice_id%TYPE

Line 182: l_attribute_category okl_trx_csh_receipt_v.attribute_category%TYPE

178: l_api_version NUMBER DEFAULT 1.0;
179: l_appl_tbl okl_receipts_pvt.appl_tbl_type;
180: l_ar_inv_id okl_txl_rcpt_apps_v.ar_invoice_id%TYPE
181: DEFAULT NULL;
182: l_attribute_category okl_trx_csh_receipt_v.attribute_category%TYPE
183: DEFAULT NULL;
184: l_attribute1 okl_trx_csh_receipt_v.attribute1%TYPE
185: DEFAULT NULL;
186: l_attribute2 okl_trx_csh_receipt_v.attribute2%TYPE

Line 184: l_attribute1 okl_trx_csh_receipt_v.attribute1%TYPE

180: l_ar_inv_id okl_txl_rcpt_apps_v.ar_invoice_id%TYPE
181: DEFAULT NULL;
182: l_attribute_category okl_trx_csh_receipt_v.attribute_category%TYPE
183: DEFAULT NULL;
184: l_attribute1 okl_trx_csh_receipt_v.attribute1%TYPE
185: DEFAULT NULL;
186: l_attribute2 okl_trx_csh_receipt_v.attribute2%TYPE
187: DEFAULT NULL;
188: l_attribute3 okl_trx_csh_receipt_v.attribute3%TYPE

Line 186: l_attribute2 okl_trx_csh_receipt_v.attribute2%TYPE

182: l_attribute_category okl_trx_csh_receipt_v.attribute_category%TYPE
183: DEFAULT NULL;
184: l_attribute1 okl_trx_csh_receipt_v.attribute1%TYPE
185: DEFAULT NULL;
186: l_attribute2 okl_trx_csh_receipt_v.attribute2%TYPE
187: DEFAULT NULL;
188: l_attribute3 okl_trx_csh_receipt_v.attribute3%TYPE
189: DEFAULT NULL;
190: l_attribute4 okl_trx_csh_receipt_v.attribute4%TYPE

Line 188: l_attribute3 okl_trx_csh_receipt_v.attribute3%TYPE

184: l_attribute1 okl_trx_csh_receipt_v.attribute1%TYPE
185: DEFAULT NULL;
186: l_attribute2 okl_trx_csh_receipt_v.attribute2%TYPE
187: DEFAULT NULL;
188: l_attribute3 okl_trx_csh_receipt_v.attribute3%TYPE
189: DEFAULT NULL;
190: l_attribute4 okl_trx_csh_receipt_v.attribute4%TYPE
191: DEFAULT NULL;
192: l_attribute5 okl_trx_csh_receipt_v.attribute5%TYPE

Line 190: l_attribute4 okl_trx_csh_receipt_v.attribute4%TYPE

186: l_attribute2 okl_trx_csh_receipt_v.attribute2%TYPE
187: DEFAULT NULL;
188: l_attribute3 okl_trx_csh_receipt_v.attribute3%TYPE
189: DEFAULT NULL;
190: l_attribute4 okl_trx_csh_receipt_v.attribute4%TYPE
191: DEFAULT NULL;
192: l_attribute5 okl_trx_csh_receipt_v.attribute5%TYPE
193: DEFAULT NULL;
194: l_attribute6 okl_trx_csh_receipt_v.attribute6%TYPE

Line 192: l_attribute5 okl_trx_csh_receipt_v.attribute5%TYPE

188: l_attribute3 okl_trx_csh_receipt_v.attribute3%TYPE
189: DEFAULT NULL;
190: l_attribute4 okl_trx_csh_receipt_v.attribute4%TYPE
191: DEFAULT NULL;
192: l_attribute5 okl_trx_csh_receipt_v.attribute5%TYPE
193: DEFAULT NULL;
194: l_attribute6 okl_trx_csh_receipt_v.attribute6%TYPE
195: DEFAULT NULL;
196: l_attribute7 okl_trx_csh_receipt_v.attribute7%TYPE

Line 194: l_attribute6 okl_trx_csh_receipt_v.attribute6%TYPE

190: l_attribute4 okl_trx_csh_receipt_v.attribute4%TYPE
191: DEFAULT NULL;
192: l_attribute5 okl_trx_csh_receipt_v.attribute5%TYPE
193: DEFAULT NULL;
194: l_attribute6 okl_trx_csh_receipt_v.attribute6%TYPE
195: DEFAULT NULL;
196: l_attribute7 okl_trx_csh_receipt_v.attribute7%TYPE
197: DEFAULT NULL;
198: l_attribute8 okl_trx_csh_receipt_v.attribute8%TYPE

Line 196: l_attribute7 okl_trx_csh_receipt_v.attribute7%TYPE

192: l_attribute5 okl_trx_csh_receipt_v.attribute5%TYPE
193: DEFAULT NULL;
194: l_attribute6 okl_trx_csh_receipt_v.attribute6%TYPE
195: DEFAULT NULL;
196: l_attribute7 okl_trx_csh_receipt_v.attribute7%TYPE
197: DEFAULT NULL;
198: l_attribute8 okl_trx_csh_receipt_v.attribute8%TYPE
199: DEFAULT NULL;
200: l_attribute9 okl_trx_csh_receipt_v.attribute9%TYPE

Line 198: l_attribute8 okl_trx_csh_receipt_v.attribute8%TYPE

194: l_attribute6 okl_trx_csh_receipt_v.attribute6%TYPE
195: DEFAULT NULL;
196: l_attribute7 okl_trx_csh_receipt_v.attribute7%TYPE
197: DEFAULT NULL;
198: l_attribute8 okl_trx_csh_receipt_v.attribute8%TYPE
199: DEFAULT NULL;
200: l_attribute9 okl_trx_csh_receipt_v.attribute9%TYPE
201: DEFAULT NULL;
202: l_attribute10 okl_trx_csh_receipt_v.attribute10%TYPE

Line 200: l_attribute9 okl_trx_csh_receipt_v.attribute9%TYPE

196: l_attribute7 okl_trx_csh_receipt_v.attribute7%TYPE
197: DEFAULT NULL;
198: l_attribute8 okl_trx_csh_receipt_v.attribute8%TYPE
199: DEFAULT NULL;
200: l_attribute9 okl_trx_csh_receipt_v.attribute9%TYPE
201: DEFAULT NULL;
202: l_attribute10 okl_trx_csh_receipt_v.attribute10%TYPE
203: DEFAULT NULL;
204: l_attribute11 okl_trx_csh_receipt_v.attribute11%TYPE

Line 202: l_attribute10 okl_trx_csh_receipt_v.attribute10%TYPE

198: l_attribute8 okl_trx_csh_receipt_v.attribute8%TYPE
199: DEFAULT NULL;
200: l_attribute9 okl_trx_csh_receipt_v.attribute9%TYPE
201: DEFAULT NULL;
202: l_attribute10 okl_trx_csh_receipt_v.attribute10%TYPE
203: DEFAULT NULL;
204: l_attribute11 okl_trx_csh_receipt_v.attribute11%TYPE
205: DEFAULT NULL;
206: l_attribute12 okl_trx_csh_receipt_v.attribute12%TYPE

Line 204: l_attribute11 okl_trx_csh_receipt_v.attribute11%TYPE

200: l_attribute9 okl_trx_csh_receipt_v.attribute9%TYPE
201: DEFAULT NULL;
202: l_attribute10 okl_trx_csh_receipt_v.attribute10%TYPE
203: DEFAULT NULL;
204: l_attribute11 okl_trx_csh_receipt_v.attribute11%TYPE
205: DEFAULT NULL;
206: l_attribute12 okl_trx_csh_receipt_v.attribute12%TYPE
207: DEFAULT NULL;
208: l_attribute13 okl_trx_csh_receipt_v.attribute13%TYPE

Line 206: l_attribute12 okl_trx_csh_receipt_v.attribute12%TYPE

202: l_attribute10 okl_trx_csh_receipt_v.attribute10%TYPE
203: DEFAULT NULL;
204: l_attribute11 okl_trx_csh_receipt_v.attribute11%TYPE
205: DEFAULT NULL;
206: l_attribute12 okl_trx_csh_receipt_v.attribute12%TYPE
207: DEFAULT NULL;
208: l_attribute13 okl_trx_csh_receipt_v.attribute13%TYPE
209: DEFAULT NULL;
210: l_attribute14 okl_trx_csh_receipt_v.attribute14%TYPE

Line 208: l_attribute13 okl_trx_csh_receipt_v.attribute13%TYPE

204: l_attribute11 okl_trx_csh_receipt_v.attribute11%TYPE
205: DEFAULT NULL;
206: l_attribute12 okl_trx_csh_receipt_v.attribute12%TYPE
207: DEFAULT NULL;
208: l_attribute13 okl_trx_csh_receipt_v.attribute13%TYPE
209: DEFAULT NULL;
210: l_attribute14 okl_trx_csh_receipt_v.attribute14%TYPE
211: DEFAULT NULL;
212: l_attribute15 okl_trx_csh_receipt_v.attribute15%TYPE

Line 210: l_attribute14 okl_trx_csh_receipt_v.attribute14%TYPE

206: l_attribute12 okl_trx_csh_receipt_v.attribute12%TYPE
207: DEFAULT NULL;
208: l_attribute13 okl_trx_csh_receipt_v.attribute13%TYPE
209: DEFAULT NULL;
210: l_attribute14 okl_trx_csh_receipt_v.attribute14%TYPE
211: DEFAULT NULL;
212: l_attribute15 okl_trx_csh_receipt_v.attribute15%TYPE
213: DEFAULT NULL;
214: l_btc_id okl_trx_csh_batch_v.ID%TYPE DEFAULT NULL;

Line 212: l_attribute15 okl_trx_csh_receipt_v.attribute15%TYPE

208: l_attribute13 okl_trx_csh_receipt_v.attribute13%TYPE
209: DEFAULT NULL;
210: l_attribute14 okl_trx_csh_receipt_v.attribute14%TYPE
211: DEFAULT NULL;
212: l_attribute15 okl_trx_csh_receipt_v.attribute15%TYPE
213: DEFAULT NULL;
214: l_btc_id okl_trx_csh_batch_v.ID%TYPE DEFAULT NULL;
215: l_cash_receipt_id ar_cash_receipts_all.cash_receipt_id%TYPE;
216: l_check_number okl_trx_csh_receipt_v.check_number%TYPE

Line 216: l_check_number okl_trx_csh_receipt_v.check_number%TYPE

212: l_attribute15 okl_trx_csh_receipt_v.attribute15%TYPE
213: DEFAULT NULL;
214: l_btc_id okl_trx_csh_batch_v.ID%TYPE DEFAULT NULL;
215: l_cash_receipt_id ar_cash_receipts_all.cash_receipt_id%TYPE;
216: l_check_number okl_trx_csh_receipt_v.check_number%TYPE
217: DEFAULT NULL;
218: l_cnr_id okl_txl_rcpt_apps_v.cnr_id%TYPE DEFAULT NULL;
219: l_conversion_rate NUMBER;
220: l_counter NUMBER;

Line 221: l_currency_code okl_trx_csh_receipt_v.currency_code%TYPE

217: DEFAULT NULL;
218: l_cnr_id okl_txl_rcpt_apps_v.cnr_id%TYPE DEFAULT NULL;
219: l_conversion_rate NUMBER;
220: l_counter NUMBER;
221: l_currency_code okl_trx_csh_receipt_v.currency_code%TYPE
222: DEFAULT NULL;
223: l_cust_num ar_cash_receipts_all.pay_from_customer%TYPE
224: DEFAULT NULL;
225: l_date_effective okl_trx_csh_receipt_v.date_effective%TYPE

Line 225: l_date_effective okl_trx_csh_receipt_v.date_effective%TYPE

221: l_currency_code okl_trx_csh_receipt_v.currency_code%TYPE
222: DEFAULT NULL;
223: l_cust_num ar_cash_receipts_all.pay_from_customer%TYPE
224: DEFAULT NULL;
225: l_date_effective okl_trx_csh_receipt_v.date_effective%TYPE
226: DEFAULT NULL;
227: l_debit_doc_id NUMBER;
228: l_error VARCHAR2 (2) DEFAULT NULL;
229: l_exchange_rate_type VARCHAR2(30);

Line 230: l_currency_conv_type okl_trx_csh_receipt_v.exchange_rate_type%TYPE

226: DEFAULT NULL;
227: l_debit_doc_id NUMBER;
228: l_error VARCHAR2 (2) DEFAULT NULL;
229: l_exchange_rate_type VARCHAR2(30);
230: l_currency_conv_type okl_trx_csh_receipt_v.exchange_rate_type%TYPE
231: DEFAULT NULL;
232: l_currency_conv_date okl_trx_csh_receipt_v.exchange_rate_date%TYPE
233: DEFAULT NULL;
234: l_currency_conv_rate okl_trx_csh_receipt_v.exchange_rate%TYPE

Line 232: l_currency_conv_date okl_trx_csh_receipt_v.exchange_rate_date%TYPE

228: l_error VARCHAR2 (2) DEFAULT NULL;
229: l_exchange_rate_type VARCHAR2(30);
230: l_currency_conv_type okl_trx_csh_receipt_v.exchange_rate_type%TYPE
231: DEFAULT NULL;
232: l_currency_conv_date okl_trx_csh_receipt_v.exchange_rate_date%TYPE
233: DEFAULT NULL;
234: l_currency_conv_rate okl_trx_csh_receipt_v.exchange_rate%TYPE
235: DEFAULT NULL;
236: l_gl_date okl_trx_csh_receipt_v.gl_date%TYPE

Line 234: l_currency_conv_rate okl_trx_csh_receipt_v.exchange_rate%TYPE

230: l_currency_conv_type okl_trx_csh_receipt_v.exchange_rate_type%TYPE
231: DEFAULT NULL;
232: l_currency_conv_date okl_trx_csh_receipt_v.exchange_rate_date%TYPE
233: DEFAULT NULL;
234: l_currency_conv_rate okl_trx_csh_receipt_v.exchange_rate%TYPE
235: DEFAULT NULL;
236: l_gl_date okl_trx_csh_receipt_v.gl_date%TYPE
237: DEFAULT NULL;
238: l_ile_id okl_trx_csh_receipt_v.ile_id%TYPE

Line 236: l_gl_date okl_trx_csh_receipt_v.gl_date%TYPE

232: l_currency_conv_date okl_trx_csh_receipt_v.exchange_rate_date%TYPE
233: DEFAULT NULL;
234: l_currency_conv_rate okl_trx_csh_receipt_v.exchange_rate%TYPE
235: DEFAULT NULL;
236: l_gl_date okl_trx_csh_receipt_v.gl_date%TYPE
237: DEFAULT NULL;
238: l_ile_id okl_trx_csh_receipt_v.ile_id%TYPE
239: DEFAULT NULL;
240: l_init_msg_list VARCHAR2 (1);

Line 238: l_ile_id okl_trx_csh_receipt_v.ile_id%TYPE

234: l_currency_conv_rate okl_trx_csh_receipt_v.exchange_rate%TYPE
235: DEFAULT NULL;
236: l_gl_date okl_trx_csh_receipt_v.gl_date%TYPE
237: DEFAULT NULL;
238: l_ile_id okl_trx_csh_receipt_v.ile_id%TYPE
239: DEFAULT NULL;
240: l_init_msg_list VARCHAR2 (1);
241: l_inv_tot NUMBER DEFAULT 0;
242: l_invoice_currency_code okl_trx_csh_receipt_v.currency_code%TYPE

Line 242: l_invoice_currency_code okl_trx_csh_receipt_v.currency_code%TYPE

238: l_ile_id okl_trx_csh_receipt_v.ile_id%TYPE
239: DEFAULT NULL;
240: l_init_msg_list VARCHAR2 (1);
241: l_inv_tot NUMBER DEFAULT 0;
242: l_invoice_currency_code okl_trx_csh_receipt_v.currency_code%TYPE
243: DEFAULT NULL;
244: l_irm_id okl_trx_csh_receipt_v.irm_id%TYPE
245: DEFAULT NULL;
246: l_khr_id okl_txl_rcpt_apps_v.khr_id%TYPE DEFAULT NULL;

Line 244: l_irm_id okl_trx_csh_receipt_v.irm_id%TYPE

240: l_init_msg_list VARCHAR2 (1);
241: l_inv_tot NUMBER DEFAULT 0;
242: l_invoice_currency_code okl_trx_csh_receipt_v.currency_code%TYPE
243: DEFAULT NULL;
244: l_irm_id okl_trx_csh_receipt_v.irm_id%TYPE
245: DEFAULT NULL;
246: l_khr_id okl_txl_rcpt_apps_v.khr_id%TYPE DEFAULT NULL;
247: l_msg_count NUMBER;
248: l_msg_data VARCHAR2 (2000);

Line 253: l_rcpt_status_code okl_trx_csh_receipt_v.rcpt_status_code%TYPE;

249: l_msg_index_out NUMBER;
250: l_org_id okl_txl_rcpt_apps_v.org_id%TYPE DEFAULT NULL;
251: l_rca_id okl_txl_rcpt_apps_v.ID%TYPE DEFAULT NULL;
252: l_rcpt_rec okl_receipts_pvt.rcpt_rec_type;
253: l_rcpt_status_code okl_trx_csh_receipt_v.rcpt_status_code%TYPE;
254: l_rct_id okl_trx_csh_receipt_v.ID%TYPE DEFAULT NULL;
255: l_receipt_currency okl_trx_csh_receipt_v.currency_code%TYPE
256: DEFAULT NULL;
257: l_remit_bank_id NUMBER;

Line 254: l_rct_id okl_trx_csh_receipt_v.ID%TYPE DEFAULT NULL;

250: l_org_id okl_txl_rcpt_apps_v.org_id%TYPE DEFAULT NULL;
251: l_rca_id okl_txl_rcpt_apps_v.ID%TYPE DEFAULT NULL;
252: l_rcpt_rec okl_receipts_pvt.rcpt_rec_type;
253: l_rcpt_status_code okl_trx_csh_receipt_v.rcpt_status_code%TYPE;
254: l_rct_id okl_trx_csh_receipt_v.ID%TYPE DEFAULT NULL;
255: l_receipt_currency okl_trx_csh_receipt_v.currency_code%TYPE
256: DEFAULT NULL;
257: l_remit_bank_id NUMBER;
258: l_return_status VARCHAR2 (1);

Line 255: l_receipt_currency okl_trx_csh_receipt_v.currency_code%TYPE

251: l_rca_id okl_txl_rcpt_apps_v.ID%TYPE DEFAULT NULL;
252: l_rcpt_rec okl_receipts_pvt.rcpt_rec_type;
253: l_rcpt_status_code okl_trx_csh_receipt_v.rcpt_status_code%TYPE;
254: l_rct_id okl_trx_csh_receipt_v.ID%TYPE DEFAULT NULL;
255: l_receipt_currency okl_trx_csh_receipt_v.currency_code%TYPE
256: DEFAULT NULL;
257: l_remit_bank_id NUMBER;
258: l_return_status VARCHAR2 (1);
259: l_trx_status_code okl_trx_csh_batch_v.trx_status_code%TYPE := 'PROCESSED';

Line 680: l_rcpt_status_code okl_trx_csh_receipt_v.rcpt_status_code%TYPE;

676: l_return_status VARCHAR2 (1);
677: l_msg_count NUMBER;
678: l_msg_data VARCHAR2 (2000);
679: l_trx_status_code okl_trx_csh_batch_v.trx_status_code%TYPE;
680: l_rcpt_status_code okl_trx_csh_receipt_v.rcpt_status_code%TYPE;
681: l_btc_id okl_trx_csh_batch_v.ID%TYPE DEFAULT NULL;
682: l_btc_name okl_trx_csh_batch_v.NAME%TYPE DEFAULT NULL;
683: l_rct_id okl_trx_csh_receipt_v.ID%TYPE DEFAULT NULL;
684: l_rca_id okl_txl_rcpt_apps_v.ID%TYPE DEFAULT NULL;

Line 683: l_rct_id okl_trx_csh_receipt_v.ID%TYPE DEFAULT NULL;

679: l_trx_status_code okl_trx_csh_batch_v.trx_status_code%TYPE;
680: l_rcpt_status_code okl_trx_csh_receipt_v.rcpt_status_code%TYPE;
681: l_btc_id okl_trx_csh_batch_v.ID%TYPE DEFAULT NULL;
682: l_btc_name okl_trx_csh_batch_v.NAME%TYPE DEFAULT NULL;
683: l_rct_id okl_trx_csh_receipt_v.ID%TYPE DEFAULT NULL;
684: l_rca_id okl_txl_rcpt_apps_v.ID%TYPE DEFAULT NULL;
685: l_ile_id okl_trx_csh_receipt_v.ile_id%TYPE
686: DEFAULT NULL;
687: l_irm_id okl_trx_csh_receipt_v.irm_id%TYPE

Line 685: l_ile_id okl_trx_csh_receipt_v.ile_id%TYPE

681: l_btc_id okl_trx_csh_batch_v.ID%TYPE DEFAULT NULL;
682: l_btc_name okl_trx_csh_batch_v.NAME%TYPE DEFAULT NULL;
683: l_rct_id okl_trx_csh_receipt_v.ID%TYPE DEFAULT NULL;
684: l_rca_id okl_txl_rcpt_apps_v.ID%TYPE DEFAULT NULL;
685: l_ile_id okl_trx_csh_receipt_v.ile_id%TYPE
686: DEFAULT NULL;
687: l_irm_id okl_trx_csh_receipt_v.irm_id%TYPE
688: DEFAULT NULL;
689: l_check_number okl_trx_csh_receipt_v.check_number%TYPE

Line 687: l_irm_id okl_trx_csh_receipt_v.irm_id%TYPE

683: l_rct_id okl_trx_csh_receipt_v.ID%TYPE DEFAULT NULL;
684: l_rca_id okl_txl_rcpt_apps_v.ID%TYPE DEFAULT NULL;
685: l_ile_id okl_trx_csh_receipt_v.ile_id%TYPE
686: DEFAULT NULL;
687: l_irm_id okl_trx_csh_receipt_v.irm_id%TYPE
688: DEFAULT NULL;
689: l_check_number okl_trx_csh_receipt_v.check_number%TYPE
690: DEFAULT NULL;
691: l_currency_code okl_trx_csh_receipt_v.currency_code%TYPE

Line 689: l_check_number okl_trx_csh_receipt_v.check_number%TYPE

685: l_ile_id okl_trx_csh_receipt_v.ile_id%TYPE
686: DEFAULT NULL;
687: l_irm_id okl_trx_csh_receipt_v.irm_id%TYPE
688: DEFAULT NULL;
689: l_check_number okl_trx_csh_receipt_v.check_number%TYPE
690: DEFAULT NULL;
691: l_currency_code okl_trx_csh_receipt_v.currency_code%TYPE
692: DEFAULT NULL;
693: l_currency_conv_type okl_trx_csh_receipt_v.exchange_rate_type%TYPE

Line 691: l_currency_code okl_trx_csh_receipt_v.currency_code%TYPE

687: l_irm_id okl_trx_csh_receipt_v.irm_id%TYPE
688: DEFAULT NULL;
689: l_check_number okl_trx_csh_receipt_v.check_number%TYPE
690: DEFAULT NULL;
691: l_currency_code okl_trx_csh_receipt_v.currency_code%TYPE
692: DEFAULT NULL;
693: l_currency_conv_type okl_trx_csh_receipt_v.exchange_rate_type%TYPE
694: DEFAULT NULL;
695: l_currency_conv_date okl_trx_csh_receipt_v.exchange_rate_date%TYPE

Line 693: l_currency_conv_type okl_trx_csh_receipt_v.exchange_rate_type%TYPE

689: l_check_number okl_trx_csh_receipt_v.check_number%TYPE
690: DEFAULT NULL;
691: l_currency_code okl_trx_csh_receipt_v.currency_code%TYPE
692: DEFAULT NULL;
693: l_currency_conv_type okl_trx_csh_receipt_v.exchange_rate_type%TYPE
694: DEFAULT NULL;
695: l_currency_conv_date okl_trx_csh_receipt_v.exchange_rate_date%TYPE
696: DEFAULT NULL;
697: l_currency_conv_rate okl_trx_csh_receipt_v.exchange_rate%TYPE

Line 695: l_currency_conv_date okl_trx_csh_receipt_v.exchange_rate_date%TYPE

691: l_currency_code okl_trx_csh_receipt_v.currency_code%TYPE
692: DEFAULT NULL;
693: l_currency_conv_type okl_trx_csh_receipt_v.exchange_rate_type%TYPE
694: DEFAULT NULL;
695: l_currency_conv_date okl_trx_csh_receipt_v.exchange_rate_date%TYPE
696: DEFAULT NULL;
697: l_currency_conv_rate okl_trx_csh_receipt_v.exchange_rate%TYPE
698: DEFAULT NULL;
699: l_amount okl_trx_csh_receipt_v.amount%TYPE

Line 697: l_currency_conv_rate okl_trx_csh_receipt_v.exchange_rate%TYPE

693: l_currency_conv_type okl_trx_csh_receipt_v.exchange_rate_type%TYPE
694: DEFAULT NULL;
695: l_currency_conv_date okl_trx_csh_receipt_v.exchange_rate_date%TYPE
696: DEFAULT NULL;
697: l_currency_conv_rate okl_trx_csh_receipt_v.exchange_rate%TYPE
698: DEFAULT NULL;
699: l_amount okl_trx_csh_receipt_v.amount%TYPE
700: DEFAULT NULL;
701: l_date_effective okl_trx_csh_receipt_v.date_effective%TYPE

Line 699: l_amount okl_trx_csh_receipt_v.amount%TYPE

695: l_currency_conv_date okl_trx_csh_receipt_v.exchange_rate_date%TYPE
696: DEFAULT NULL;
697: l_currency_conv_rate okl_trx_csh_receipt_v.exchange_rate%TYPE
698: DEFAULT NULL;
699: l_amount okl_trx_csh_receipt_v.amount%TYPE
700: DEFAULT NULL;
701: l_date_effective okl_trx_csh_receipt_v.date_effective%TYPE
702: DEFAULT NULL;
703: l_gl_date okl_trx_csh_receipt_v.gl_date%TYPE

Line 701: l_date_effective okl_trx_csh_receipt_v.date_effective%TYPE

697: l_currency_conv_rate okl_trx_csh_receipt_v.exchange_rate%TYPE
698: DEFAULT NULL;
699: l_amount okl_trx_csh_receipt_v.amount%TYPE
700: DEFAULT NULL;
701: l_date_effective okl_trx_csh_receipt_v.date_effective%TYPE
702: DEFAULT NULL;
703: l_gl_date okl_trx_csh_receipt_v.gl_date%TYPE
704: DEFAULT NULL;
705: l_cnr_id okl_txl_rcpt_apps_v.cnr_id%TYPE DEFAULT NULL;

Line 703: l_gl_date okl_trx_csh_receipt_v.gl_date%TYPE

699: l_amount okl_trx_csh_receipt_v.amount%TYPE
700: DEFAULT NULL;
701: l_date_effective okl_trx_csh_receipt_v.date_effective%TYPE
702: DEFAULT NULL;
703: l_gl_date okl_trx_csh_receipt_v.gl_date%TYPE
704: DEFAULT NULL;
705: l_cnr_id okl_txl_rcpt_apps_v.cnr_id%TYPE DEFAULT NULL;
706: l_khr_id okl_txl_rcpt_apps_v.khr_id%TYPE DEFAULT NULL;
707: l_ar_inv_id okl_txl_rcpt_apps_v.ar_invoice_id%TYPE

Line 734: l_bank_account_id okl_trx_csh_receipt_v.iba_id%TYPE

730: l_comments okl_trx_csh_receipt_tl.description%TYPE
731: DEFAULT NULL;
732: l_amount_due_remaining ar_payment_schedules_all.amount_due_remaining%TYPE
733: DEFAULT NULL;
734: l_bank_account_id okl_trx_csh_receipt_v.iba_id%TYPE
735: DEFAULT NULL;
736: l_tolerance okl_cash_allctn_rls.amount_tolerance_percent%TYPE;
737: l_days_past_quote_valid okl_cash_allctn_rls.days_past_quote_valid_toleranc%TYPE;
738: l_months_to_bill_ahead okl_cash_allctn_rls.months_to_bill_ahead%TYPE;

Line 742: l_attribute_category okl_trx_csh_receipt_v.attribute_category%TYPE

738: l_months_to_bill_ahead okl_cash_allctn_rls.months_to_bill_ahead%TYPE;
739: l_under_payment okl_cash_allctn_rls.under_payment_allocation_code%TYPE;
740: l_over_payment okl_cash_allctn_rls.over_payment_allocation_code%TYPE;
741: l_receipt_msmtch okl_cash_allctn_rls.receipt_msmtch_allocation_code%TYPE;
742: l_attribute_category okl_trx_csh_receipt_v.attribute_category%TYPE
743: DEFAULT NULL;
744: l_attribute1 okl_trx_csh_receipt_v.attribute1%TYPE
745: DEFAULT NULL;
746: l_attribute2 okl_trx_csh_receipt_v.attribute2%TYPE

Line 744: l_attribute1 okl_trx_csh_receipt_v.attribute1%TYPE

740: l_over_payment okl_cash_allctn_rls.over_payment_allocation_code%TYPE;
741: l_receipt_msmtch okl_cash_allctn_rls.receipt_msmtch_allocation_code%TYPE;
742: l_attribute_category okl_trx_csh_receipt_v.attribute_category%TYPE
743: DEFAULT NULL;
744: l_attribute1 okl_trx_csh_receipt_v.attribute1%TYPE
745: DEFAULT NULL;
746: l_attribute2 okl_trx_csh_receipt_v.attribute2%TYPE
747: DEFAULT NULL;
748: l_attribute3 okl_trx_csh_receipt_v.attribute3%TYPE

Line 746: l_attribute2 okl_trx_csh_receipt_v.attribute2%TYPE

742: l_attribute_category okl_trx_csh_receipt_v.attribute_category%TYPE
743: DEFAULT NULL;
744: l_attribute1 okl_trx_csh_receipt_v.attribute1%TYPE
745: DEFAULT NULL;
746: l_attribute2 okl_trx_csh_receipt_v.attribute2%TYPE
747: DEFAULT NULL;
748: l_attribute3 okl_trx_csh_receipt_v.attribute3%TYPE
749: DEFAULT NULL;
750: l_attribute4 okl_trx_csh_receipt_v.attribute4%TYPE

Line 748: l_attribute3 okl_trx_csh_receipt_v.attribute3%TYPE

744: l_attribute1 okl_trx_csh_receipt_v.attribute1%TYPE
745: DEFAULT NULL;
746: l_attribute2 okl_trx_csh_receipt_v.attribute2%TYPE
747: DEFAULT NULL;
748: l_attribute3 okl_trx_csh_receipt_v.attribute3%TYPE
749: DEFAULT NULL;
750: l_attribute4 okl_trx_csh_receipt_v.attribute4%TYPE
751: DEFAULT NULL;
752: l_attribute5 okl_trx_csh_receipt_v.attribute5%TYPE

Line 750: l_attribute4 okl_trx_csh_receipt_v.attribute4%TYPE

746: l_attribute2 okl_trx_csh_receipt_v.attribute2%TYPE
747: DEFAULT NULL;
748: l_attribute3 okl_trx_csh_receipt_v.attribute3%TYPE
749: DEFAULT NULL;
750: l_attribute4 okl_trx_csh_receipt_v.attribute4%TYPE
751: DEFAULT NULL;
752: l_attribute5 okl_trx_csh_receipt_v.attribute5%TYPE
753: DEFAULT NULL;
754: l_attribute6 okl_trx_csh_receipt_v.attribute6%TYPE

Line 752: l_attribute5 okl_trx_csh_receipt_v.attribute5%TYPE

748: l_attribute3 okl_trx_csh_receipt_v.attribute3%TYPE
749: DEFAULT NULL;
750: l_attribute4 okl_trx_csh_receipt_v.attribute4%TYPE
751: DEFAULT NULL;
752: l_attribute5 okl_trx_csh_receipt_v.attribute5%TYPE
753: DEFAULT NULL;
754: l_attribute6 okl_trx_csh_receipt_v.attribute6%TYPE
755: DEFAULT NULL;
756: l_attribute7 okl_trx_csh_receipt_v.attribute7%TYPE

Line 754: l_attribute6 okl_trx_csh_receipt_v.attribute6%TYPE

750: l_attribute4 okl_trx_csh_receipt_v.attribute4%TYPE
751: DEFAULT NULL;
752: l_attribute5 okl_trx_csh_receipt_v.attribute5%TYPE
753: DEFAULT NULL;
754: l_attribute6 okl_trx_csh_receipt_v.attribute6%TYPE
755: DEFAULT NULL;
756: l_attribute7 okl_trx_csh_receipt_v.attribute7%TYPE
757: DEFAULT NULL;
758: l_attribute8 okl_trx_csh_receipt_v.attribute8%TYPE

Line 756: l_attribute7 okl_trx_csh_receipt_v.attribute7%TYPE

752: l_attribute5 okl_trx_csh_receipt_v.attribute5%TYPE
753: DEFAULT NULL;
754: l_attribute6 okl_trx_csh_receipt_v.attribute6%TYPE
755: DEFAULT NULL;
756: l_attribute7 okl_trx_csh_receipt_v.attribute7%TYPE
757: DEFAULT NULL;
758: l_attribute8 okl_trx_csh_receipt_v.attribute8%TYPE
759: DEFAULT NULL;
760: l_attribute9 okl_trx_csh_receipt_v.attribute9%TYPE

Line 758: l_attribute8 okl_trx_csh_receipt_v.attribute8%TYPE

754: l_attribute6 okl_trx_csh_receipt_v.attribute6%TYPE
755: DEFAULT NULL;
756: l_attribute7 okl_trx_csh_receipt_v.attribute7%TYPE
757: DEFAULT NULL;
758: l_attribute8 okl_trx_csh_receipt_v.attribute8%TYPE
759: DEFAULT NULL;
760: l_attribute9 okl_trx_csh_receipt_v.attribute9%TYPE
761: DEFAULT NULL;
762: l_attribute10 okl_trx_csh_receipt_v.attribute10%TYPE

Line 760: l_attribute9 okl_trx_csh_receipt_v.attribute9%TYPE

756: l_attribute7 okl_trx_csh_receipt_v.attribute7%TYPE
757: DEFAULT NULL;
758: l_attribute8 okl_trx_csh_receipt_v.attribute8%TYPE
759: DEFAULT NULL;
760: l_attribute9 okl_trx_csh_receipt_v.attribute9%TYPE
761: DEFAULT NULL;
762: l_attribute10 okl_trx_csh_receipt_v.attribute10%TYPE
763: DEFAULT NULL;
764: l_attribute11 okl_trx_csh_receipt_v.attribute11%TYPE

Line 762: l_attribute10 okl_trx_csh_receipt_v.attribute10%TYPE

758: l_attribute8 okl_trx_csh_receipt_v.attribute8%TYPE
759: DEFAULT NULL;
760: l_attribute9 okl_trx_csh_receipt_v.attribute9%TYPE
761: DEFAULT NULL;
762: l_attribute10 okl_trx_csh_receipt_v.attribute10%TYPE
763: DEFAULT NULL;
764: l_attribute11 okl_trx_csh_receipt_v.attribute11%TYPE
765: DEFAULT NULL;
766: l_attribute12 okl_trx_csh_receipt_v.attribute12%TYPE

Line 764: l_attribute11 okl_trx_csh_receipt_v.attribute11%TYPE

760: l_attribute9 okl_trx_csh_receipt_v.attribute9%TYPE
761: DEFAULT NULL;
762: l_attribute10 okl_trx_csh_receipt_v.attribute10%TYPE
763: DEFAULT NULL;
764: l_attribute11 okl_trx_csh_receipt_v.attribute11%TYPE
765: DEFAULT NULL;
766: l_attribute12 okl_trx_csh_receipt_v.attribute12%TYPE
767: DEFAULT NULL;
768: l_attribute13 okl_trx_csh_receipt_v.attribute13%TYPE

Line 766: l_attribute12 okl_trx_csh_receipt_v.attribute12%TYPE

762: l_attribute10 okl_trx_csh_receipt_v.attribute10%TYPE
763: DEFAULT NULL;
764: l_attribute11 okl_trx_csh_receipt_v.attribute11%TYPE
765: DEFAULT NULL;
766: l_attribute12 okl_trx_csh_receipt_v.attribute12%TYPE
767: DEFAULT NULL;
768: l_attribute13 okl_trx_csh_receipt_v.attribute13%TYPE
769: DEFAULT NULL;
770: l_attribute14 okl_trx_csh_receipt_v.attribute14%TYPE

Line 768: l_attribute13 okl_trx_csh_receipt_v.attribute13%TYPE

764: l_attribute11 okl_trx_csh_receipt_v.attribute11%TYPE
765: DEFAULT NULL;
766: l_attribute12 okl_trx_csh_receipt_v.attribute12%TYPE
767: DEFAULT NULL;
768: l_attribute13 okl_trx_csh_receipt_v.attribute13%TYPE
769: DEFAULT NULL;
770: l_attribute14 okl_trx_csh_receipt_v.attribute14%TYPE
771: DEFAULT NULL;
772: l_attribute15 okl_trx_csh_receipt_v.attribute15%TYPE

Line 770: l_attribute14 okl_trx_csh_receipt_v.attribute14%TYPE

766: l_attribute12 okl_trx_csh_receipt_v.attribute12%TYPE
767: DEFAULT NULL;
768: l_attribute13 okl_trx_csh_receipt_v.attribute13%TYPE
769: DEFAULT NULL;
770: l_attribute14 okl_trx_csh_receipt_v.attribute14%TYPE
771: DEFAULT NULL;
772: l_attribute15 okl_trx_csh_receipt_v.attribute15%TYPE
773: DEFAULT NULL;
774: l_inv_tot NUMBER DEFAULT 0;

Line 772: l_attribute15 okl_trx_csh_receipt_v.attribute15%TYPE

768: l_attribute13 okl_trx_csh_receipt_v.attribute13%TYPE
769: DEFAULT NULL;
770: l_attribute14 okl_trx_csh_receipt_v.attribute14%TYPE
771: DEFAULT NULL;
772: l_attribute15 okl_trx_csh_receipt_v.attribute15%TYPE
773: DEFAULT NULL;
774: l_inv_tot NUMBER DEFAULT 0;
775: l_error VARCHAR2 (2) DEFAULT NULL;
776: l_create_receipt_flag VARCHAR2 (2) DEFAULT 'YC';

Line 835: FROM okl_trx_csh_receipt_v rct, okl_txl_rcpt_apps_v rca

831: rca.ar_invoice_id,
832: rca.org_id,
833: rct.gl_date,
834: rct.date_effective
835: FROM okl_trx_csh_receipt_v rct, okl_txl_rcpt_apps_v rca
836: WHERE rct.ID = rca.rct_id_details
837: AND rct.btc_id IS NULL
838: AND rct.btc_id = -1; --to be reviewed and tested later
839:

Line 865: FROM okl_trx_csh_receipt_v

861: WHERE creation_date < (SYSDATE - 7)
862: AND btc.trx_status_code IN
863: ('WORKING', 'RESUBMITTED') --akrangan added
864: AND btc.ID NOT IN (SELECT btc_id
865: FROM okl_trx_csh_receipt_v
866: WHERE btc_id = btc.ID);
867:
868: -- get remittance bank
869: CURSOR c_get_rem_bank (