[Home] [Help]
226: ** 3) create cure refund record
227: **/
228:
229: -- STEP 1
230: --populate the ap invoice header table (okl_trx_ap_invoices_b)
231: IF PG_DEBUG < 11 THEN
232: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
233: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'before creating TAP record ');
234: END IF;
1238: select a.tap_id,
1239: a.cure_refund_id,
1240: a.object_version_number,
1241: b.invoice_number
1242: from okl_cure_refunds a, okl_trx_ap_invoices_b b
1243: where cure_refund_header_id =p_cure_refund_header_id
1244: and a.tap_id =b.id;
1245:
1246: cursor c_getobj(p_cure_refund_header_id IN NUMBER ) is
2184: select crf.tap_id,tap.invoice_number,
2185: crs.object_version_number
2186: ,crs.cure_refund_Stage_id
2187: ,crf.tai_id
2188: from okl_cure_refunds crf,okl_trx_ap_invoices_b tap
2189: ,okl_cure_refund_stage crs
2190: where crf.cure_refund_header_id =p_cure_refund_header_id
2191: and crf.tap_id =tap.id
2192: and crs.cure_refund_stage_id =crf.cure_refund_stage_id;
2198: next_row integer;
2199: tai_next_row integer;
2200:
2201: -- sjalasut, modified the below cursor to have khr_id referred from
2202: -- okl_txl_ap_inv_lns_all_b instead of okl_trx_ap_invoices_b. changes made
2203: -- as part of OKLR12B disbursements project
2204: cursor c_get_accounting(p_cure_refund_header_id IN NUMBER) is
2205: select tap.id tap_id,
2206: tap.try_id try_id,
2209: tap.date_invoiced date_invoiced,
2210: tap.amount amount,
2211: tap.currency_code currency_code,
2212: til.khr_id khr_id
2213: from okl_trx_ap_invoices_b tap,
2214: okl_txl_ap_inv_lns_b til,
2215: okl_cure_refunds crf
2216: where crf.cure_refund_header_id = p_cure_refund_header_id
2217: and tap.id = til.tap_id
2599: x_amount_tbl => l_amount_tbl,
2600: --start: 06/04/07 cklee
2601: -- p_trx_header_id => j.tap_id);
2602: p_trx_header_id => j.tap_id,
2603: p_trx_header_table => 'OKL_TRX_AP_INVOICES_B'); -- cklee 07/06/07
2604: --end: 06/04/07 cklee
2605: -- R12 CHANGE - END
2606: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: submit_cure_refund_hdr : okl_account_dist_pvt.create_accounting_dist : '||l_return_status);
2607:
4039: /*** Logic for refunds ********
4040: ** 1) Invoke the common disbursement API for ap header and line creation
4041: **/
4042: -- STEP 1
4043: --populate the ap invoice header table (okl_trx_ap_invoices_b)
4044: IF PG_DEBUG < 11 THEN
4045: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4046: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'update cure refunds ');
4047: END IF;
4048: END IF;
4049:
4050:
4051: -- STEP 1
4052: --populate the ap invoice header table (okl_trx_ap_invoices_b)
4053: IF PG_DEBUG < 11 THEN
4054: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4055: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'before creating TAP record ');
4056: END IF;
4559: RAISE FND_API.G_EXC_ERROR;
4560: END IF; --refund_status check
4561: END IF; -- if details exists
4562: -- STEP 0
4563: --populate the ap invoice header table (okl_trx_ap_invoices_b)
4564: IF PG_DEBUG < 11 THEN
4565: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4566: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'before creating TAP record ');
4567: END IF;
5467: select a.tap_id,
5468: a.cure_refund_id,
5469: a.object_version_number,
5470: b.invoice_number
5471: from okl_cure_refunds a, okl_trx_ap_invoices_b b
5472: where cure_refund_header_id =p_cure_refund_header_id
5473: and a.tap_id =b.id;
5474:
5475: cursor c_getobj(p_cure_refund_header_id IN NUMBER ) is