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_CS_PRINCIPAL_PAYDOWN_PVT dependencies on OKL_TRX_REQUESTS

Line 214: FROM okl_trx_requests

210: IS
211: SELECT request_status_code,
212: object1_id1,
213: jtot_object1_code
214: FROM okl_trx_requests
215: where id=a_id;
216:
217: CURSOR c_supertrump_csr (a_id IN NUMBER)
218: IS

Line 2382: p_trqv_tbl IN okl_trx_requests_pub.trqv_tbl_type,

2378: p_init_msg_list IN VARCHAR2 := OKL_API.G_FALSE,
2379: x_return_status OUT NOCOPY VARCHAR2,
2380: x_msg_count OUT NOCOPY NUMBER,
2381: x_msg_data OUT NOCOPY VARCHAR2,
2382: p_trqv_tbl IN okl_trx_requests_pub.trqv_tbl_type,
2383: x_trqv_tbl OUT NOCOPY okl_trx_requests_pub.trqv_tbl_type)
2384: AS
2385: l_api_name CONSTANT VARCHAR2(30) := 'CALCULATE';
2386: p_chr_id NUMBER;

Line 2383: x_trqv_tbl OUT NOCOPY okl_trx_requests_pub.trqv_tbl_type)

2379: x_return_status OUT NOCOPY VARCHAR2,
2380: x_msg_count OUT NOCOPY NUMBER,
2381: x_msg_data OUT NOCOPY VARCHAR2,
2382: p_trqv_tbl IN okl_trx_requests_pub.trqv_tbl_type,
2383: x_trqv_tbl OUT NOCOPY okl_trx_requests_pub.trqv_tbl_type)
2384: AS
2385: l_api_name CONSTANT VARCHAR2(30) := 'CALCULATE';
2386: p_chr_id NUMBER;
2387: l_trans_id NUMBER;

Line 2389: l_trqv_tbl okl_trx_requests_pub.trqv_tbl_type;

2385: l_api_name CONSTANT VARCHAR2(30) := 'CALCULATE';
2386: p_chr_id NUMBER;
2387: l_trans_id NUMBER;
2388: l_trans_status VARCHAR2(100);
2389: l_trqv_tbl okl_trx_requests_pub.trqv_tbl_type;
2390: l_upd_trqv_tbl okl_trx_requests_pub.trqv_tbl_type;
2391: l_trqv_rec okl_trx_requests_pub.trqv_rec_type;
2392: lx_trqv_rec okl_trx_requests_pub.trqv_rec_type;
2393: l_prim_sty_id NUMBER;

Line 2390: l_upd_trqv_tbl okl_trx_requests_pub.trqv_tbl_type;

2386: p_chr_id NUMBER;
2387: l_trans_id NUMBER;
2388: l_trans_status VARCHAR2(100);
2389: l_trqv_tbl okl_trx_requests_pub.trqv_tbl_type;
2390: l_upd_trqv_tbl okl_trx_requests_pub.trqv_tbl_type;
2391: l_trqv_rec okl_trx_requests_pub.trqv_rec_type;
2392: lx_trqv_rec okl_trx_requests_pub.trqv_rec_type;
2393: l_prim_sty_id NUMBER;
2394:

Line 2391: l_trqv_rec okl_trx_requests_pub.trqv_rec_type;

2387: l_trans_id NUMBER;
2388: l_trans_status VARCHAR2(100);
2389: l_trqv_tbl okl_trx_requests_pub.trqv_tbl_type;
2390: l_upd_trqv_tbl okl_trx_requests_pub.trqv_tbl_type;
2391: l_trqv_rec okl_trx_requests_pub.trqv_rec_type;
2392: lx_trqv_rec okl_trx_requests_pub.trqv_rec_type;
2393: l_prim_sty_id NUMBER;
2394:
2395: l_skip_prc_engine VARCHAR2(1) := OKL_API.G_FALSE;

Line 2392: lx_trqv_rec okl_trx_requests_pub.trqv_rec_type;

2388: l_trans_status VARCHAR2(100);
2389: l_trqv_tbl okl_trx_requests_pub.trqv_tbl_type;
2390: l_upd_trqv_tbl okl_trx_requests_pub.trqv_tbl_type;
2391: l_trqv_rec okl_trx_requests_pub.trqv_rec_type;
2392: lx_trqv_rec okl_trx_requests_pub.trqv_rec_type;
2393: l_prim_sty_id NUMBER;
2394:
2395: l_skip_prc_engine VARCHAR2(1) := OKL_API.G_FALSE;
2396: l_csm_loan_header okl_create_streams_pvt.csm_loan_rec_type;

Line 2556: from OKL_TRX_REQUESTS

2552: -- added for ppd bug #6657481 ansethur
2553: CURSOR c_get_object_ver (c_trq_id NUMBER)
2554: is
2555: select object_version_number
2556: from OKL_TRX_REQUESTS
2557: where id = c_trq_id ;
2558: l_object_version_number number ;
2559:
2560: BEGIN

Line 2641: okl_trx_requests_pub.insert_trx_requests(

2637:
2638:
2639: IF p_trqv_tbl(1).id IS NULL THEN
2640: -- Call the public API for insertion here.
2641: okl_trx_requests_pub.insert_trx_requests(
2642: p_api_version => p_api_version,
2643: p_init_msg_list =>p_init_msg_list,
2644: x_return_status => x_return_status,
2645: x_msg_count => x_msg_count,

Line 2668: okl_trx_requests_pub.update_trx_requests(

2664: l_upd_trqv_tbl(1).request_status_code := 'ENTERED';
2665:
2666:
2667: --Call update here.
2668: okl_trx_requests_pub.update_trx_requests(
2669: p_api_version => p_api_version,
2670: p_init_msg_list =>p_init_msg_list,
2671: x_return_status => x_return_status,
2672: x_msg_count => x_msg_count,

Line 3010: okl_trx_requests_pub.update_trx_requests(

3006: --Call update here.
3007: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3008: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Updating TRX Requests');
3009: END IF;
3010: okl_trx_requests_pub.update_trx_requests(
3011: p_api_version => p_api_version,
3012: p_init_msg_list =>p_init_msg_list,
3013: x_return_status => x_return_status,
3014: x_msg_count => x_msg_count,

Line 3049: okl_trx_requests_pub.update_trx_requests(

3045: l_trqv_tbl(1).object_version_number := x_trqv_tbl(1).object_version_number;
3046: l_trqv_tbl(1).amount := 0;
3047: l_trqv_tbl(1).request_status_code := 'COMPLETE';
3048: --Call update here.
3049: okl_trx_requests_pub.update_trx_requests(
3050: p_api_version => p_api_version,
3051: p_init_msg_list =>p_init_msg_list,
3052: x_return_status => x_return_status,
3053: x_msg_count => x_msg_count,

Line 3124: okl_trx_requests_pub.update_trx_requests(

3120:
3121: l_trqv_tbl(1).request_status_code := 'COMPLETE';
3122:
3123: --Call update here.
3124: okl_trx_requests_pub.update_trx_requests(
3125: p_api_version => p_api_version,
3126: p_init_msg_list =>p_init_msg_list,
3127: x_return_status => x_return_status,
3128: x_msg_count => x_msg_count,

Line 3300: l_csm_loan_header.jtot_object1_code := 'OKL_TRX_REQUESTS';

3296: END IF;
3297: */
3298:
3299: --Modify the x_csm_loan_header and x_csm_loan_levels_tbl
3300: l_csm_loan_header.jtot_object1_code := 'OKL_TRX_REQUESTS';
3301: l_csm_loan_header.object1_id1 := x_trqv_tbl(1).id;
3302:
3303: --rkuttiya commenting following lines of code for 11i OKL.H PPD Impacts of Variable Rate
3304: /* l_csm_loan_header.orp_code := OKL_CREATE_STREAMS_PUB.G_ORP_CODE_RENEWAL;

Line 3527: okl_trx_requests_pub.update_trx_requests(

3523: l_trqv_tbl(1).request_status_code := 'PRICING';
3524: end if ;
3525:
3526: --Call update here.
3527: okl_trx_requests_pub.update_trx_requests(
3528: p_api_version => p_api_version,
3529: p_init_msg_list =>p_init_msg_list,
3530: x_return_status => x_return_status,
3531: x_msg_count => x_msg_count,

Line 3581: ,p_trqv_rec IN okl_trx_requests_pub.trqv_rec_type

3577: ,p_init_msg_list IN VARCHAR2
3578: ,x_return_status OUT NOCOPY VARCHAR2
3579: ,x_msg_count OUT NOCOPY NUMBER
3580: ,x_msg_data OUT NOCOPY VARCHAR2
3581: ,p_trqv_rec IN okl_trx_requests_pub.trqv_rec_type
3582: ,x_trqv_rec OUT NOCOPY okl_trx_requests_pub.trqv_rec_type)
3583: AS
3584:
3585: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_PPD_REQUEST';

Line 3582: ,x_trqv_rec OUT NOCOPY okl_trx_requests_pub.trqv_rec_type)

3578: ,x_return_status OUT NOCOPY VARCHAR2
3579: ,x_msg_count OUT NOCOPY NUMBER
3580: ,x_msg_data OUT NOCOPY VARCHAR2
3581: ,p_trqv_rec IN okl_trx_requests_pub.trqv_rec_type
3582: ,x_trqv_rec OUT NOCOPY okl_trx_requests_pub.trqv_rec_type)
3583: AS
3584:
3585: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_PPD_REQUEST';
3586: l_trqv_rec okl_trx_requests_pub.trqv_rec_type := p_trqv_rec;

Line 3586: l_trqv_rec okl_trx_requests_pub.trqv_rec_type := p_trqv_rec;

3582: ,x_trqv_rec OUT NOCOPY okl_trx_requests_pub.trqv_rec_type)
3583: AS
3584:
3585: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_PPD_REQUEST';
3586: l_trqv_rec okl_trx_requests_pub.trqv_rec_type := p_trqv_rec;
3587:
3588: CURSOR c_obj_vers_csr (a_id NUMBER)
3589: IS
3590: SELECT object_Version_number

Line 3591: FROM okl_trx_requests

3587:
3588: CURSOR c_obj_vers_csr (a_id NUMBER)
3589: IS
3590: SELECT object_Version_number
3591: FROM okl_trx_requests
3592: WHERE id=a_id;
3593:
3594: BEGIN
3595:

Line 3631: okl_trx_requests_pub.update_trx_requests(

3627: END IF;
3628:
3629:
3630: -- Call the public API for updation here.
3631: okl_trx_requests_pub.update_trx_requests(
3632: p_api_version => p_api_version,
3633: p_init_msg_list =>p_init_msg_list,
3634: x_return_status => x_return_status,
3635: x_msg_count => x_msg_count,

Line 4069: l_trqv_rec okl_trx_requests_pub.trqv_rec_type;

4065: ,p_khr_id IN NUMBER) IS
4066:
4067:
4068: l_api_name CONSTANT VARCHAR2(30) := 'CANCEL_PPD';
4069: l_trqv_rec okl_trx_requests_pub.trqv_rec_type;
4070: x_trqv_rec okl_trx_requests_pub.trqv_rec_type;
4071:
4072: CURSOR c_get_unaccepted_ppd(c_khr_id IN NUMBER)
4073: IS

Line 4070: x_trqv_rec okl_trx_requests_pub.trqv_rec_type;

4066:
4067:
4068: l_api_name CONSTANT VARCHAR2(30) := 'CANCEL_PPD';
4069: l_trqv_rec okl_trx_requests_pub.trqv_rec_type;
4070: x_trqv_rec okl_trx_requests_pub.trqv_rec_type;
4071:
4072: CURSOR c_get_unaccepted_ppd(c_khr_id IN NUMBER)
4073: IS
4074: SELECT ID

Line 4076: FROM OKL_TRX_REQUESTS

4072: CURSOR c_get_unaccepted_ppd(c_khr_id IN NUMBER)
4073: IS
4074: SELECT ID
4075: ,OBJECT_VERSION_NUMBER
4076: FROM OKL_TRX_REQUESTS
4077: WHERE REQUEST_TYPE_CODE='PRINCIPAL_PAYDOWN'
4078: AND REQUEST_STATUS_CODE NOT IN ('ACCEPTED','REJECTED'
4079: ,'ERROR','PROCESSED','CANCELLED'
4080: ,'REBOOK_IN_PROCESS','REBOOK_COMPLETE')

Line 4125: okl_trx_requests_pub.update_trx_requests(

4121: l_trqv_rec.object_version_number := cur_rec.object_version_number;
4122: l_trqv_rec.request_status_code := 'CANCELLED';
4123:
4124: -- Call the public API for updation here.
4125: okl_trx_requests_pub.update_trx_requests(
4126: p_api_version => p_api_version,
4127: p_init_msg_list => p_init_msg_list,
4128: x_return_status => x_return_status,
4129: x_msg_count => x_msg_count,

Line 4202: l_trqv_rec okl_trx_requests_pub.trqv_rec_type;

4198: ,p_trx_id IN NUMBER) IS
4199:
4200:
4201: l_api_name CONSTANT VARCHAR2(30) := 'INVOICE_APPLY_PPD';
4202: l_trqv_rec okl_trx_requests_pub.trqv_rec_type;
4203: lx_trqv_rec okl_trx_requests_pub.trqv_rec_type;
4204: l_trx_id NUMBER := 0;
4205: l_src_trx_id NUMBER := 0;
4206: l_req_id NUMBER := 0;

Line 4203: lx_trqv_rec okl_trx_requests_pub.trqv_rec_type;

4199:
4200:
4201: l_api_name CONSTANT VARCHAR2(30) := 'INVOICE_APPLY_PPD';
4202: l_trqv_rec okl_trx_requests_pub.trqv_rec_type;
4203: lx_trqv_rec okl_trx_requests_pub.trqv_rec_type;
4204: l_trx_id NUMBER := 0;
4205: l_src_trx_id NUMBER := 0;
4206: l_req_id NUMBER := 0;
4207: l_obj_ver VARCHAR2(10);

Line 4226: FROM OKL_TRX_REQUESTS

4222:
4223: CURSOR c_get_req_id_csr (c_trx_id NUMBER)
4224: IS
4225: SELECT ID,object_Version_number
4226: FROM OKL_TRX_REQUESTS
4227: WHERE TCN_ID=c_trx_id;
4228:
4229:
4230: BEGIN

Line 4324: okl_trx_requests_pub.update_trx_requests( p_api_version => p_api_version,

4320:
4321: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4322: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Before updating Request ');
4323: END IF;
4324: okl_trx_requests_pub.update_trx_requests( p_api_version => p_api_version,
4325: p_init_msg_list => p_init_msg_list,
4326: x_return_status => x_return_status,
4327: x_msg_count => x_msg_count,
4328: x_msg_data => x_msg_data,

Line 4427: FROM okl_trx_requests

4423:
4424: CURSOR c_chk_ppd_csr (a_khr_id NUMBER,a_effective_date DATE)
4425: IS
4426: SELECT count(id)
4427: FROM okl_trx_requests
4428: where request_type_code='PRINCIPAL_PAYDOWN'
4429: and dnz_khr_id = a_khr_id
4430: and payment_date > a_effective_date
4431: and request_status_code IN ('ACCEPTED','REBOOK_IN_PROCESS'

Line 4460: FROM okl_trx_requests

4456:
4457: CURSOR c_chk_ppd_csr (a_id NUMBER)
4458: IS
4459: SELECT count(id)
4460: FROM okl_trx_requests
4461: where request_type_code='PRINCIPAL_PAYDOWN'
4462: and id=a_id;
4463:
4464: BEGIN

Line 4657: l_trqv_rec okl_trx_requests_pub.trqv_rec_type;

4653: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
4654: l_api_name CONSTANT VARCHAR2(30) := 'store_esg_payments';
4655: lx_cfo_id NUMBER;
4656:
4657: l_trqv_rec okl_trx_requests_pub.trqv_rec_type;
4658: lx_trqv_rec okl_trx_requests_pub.trqv_rec_type;
4659: l_rent_sty_id NUMBER;
4660: l_upp_sty_id NUMBER;
4661: l_payment_tbl payment_tbl_type := p_payment_tbl;

Line 4658: lx_trqv_rec okl_trx_requests_pub.trqv_rec_type;

4654: l_api_name CONSTANT VARCHAR2(30) := 'store_esg_payments';
4655: lx_cfo_id NUMBER;
4656:
4657: l_trqv_rec okl_trx_requests_pub.trqv_rec_type;
4658: lx_trqv_rec okl_trx_requests_pub.trqv_rec_type;
4659: l_rent_sty_id NUMBER;
4660: l_upp_sty_id NUMBER;
4661: l_payment_tbl payment_tbl_type := p_payment_tbl;
4662: l_store_payment_tbl payment_tbl_type;

Line 4689: FROM okl_trx_requests

4685: IS
4686: SELECT object_Version_number
4687: ,payment_amount
4688: ,payment_date
4689: FROM okl_trx_requests
4690: WHERE id=a_id;
4691:
4692: --Bug#5100215 added cursor start --dkagrawa
4693: CURSOR l_stream_type_csr(p_stream_type IN VARCHAR2

Line 5036: okl_trx_requests_pub.update_trx_requests( p_api_version => p_api_version,

5032:
5033: l_trqv_rec.request_status_code := 'COMPLETE';
5034: l_trqv_rec.id := p_ppd_request_id;
5035:
5036: okl_trx_requests_pub.update_trx_requests( p_api_version => p_api_version,
5037: p_init_msg_list => p_init_msg_list,
5038: x_return_status => x_return_status,
5039: x_msg_count => x_msg_count,
5040: x_msg_data => x_msg_data,

Line 5189: FROM okl_trx_requests

5185: i NUMBER := 0;
5186: --dkagrawa added the following code for bug#5443418 start
5187: CURSOR l_calc_method ( cp_trq_id IN NUMBER) IS
5188: SELECT method_of_calculation_code
5189: FROM okl_trx_requests
5190: WHERE id = cp_trq_id;
5191:
5192: CURSOR l_cfl_id_csr_esg(cp_caf_id IN NUMBER
5193: ,cp_amount IN number) IS

Line 6107: l_trqv_rec okl_trx_requests_pub.trqv_rec_type;

6103: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
6104: l_api_name CONSTANT VARCHAR2(30) := 'store_esg_payments';
6105: lx_cfo_id NUMBER;
6106:
6107: l_trqv_rec okl_trx_requests_pub.trqv_rec_type;
6108: lx_trqv_rec okl_trx_requests_pub.trqv_rec_type;
6109: l_pp_sty_id NUMBER;
6110: l_upp_sty_id NUMBER;
6111: l_payment_tbl payment_tbl_type ;

Line 6108: lx_trqv_rec okl_trx_requests_pub.trqv_rec_type;

6104: l_api_name CONSTANT VARCHAR2(30) := 'store_esg_payments';
6105: lx_cfo_id NUMBER;
6106:
6107: l_trqv_rec okl_trx_requests_pub.trqv_rec_type;
6108: lx_trqv_rec okl_trx_requests_pub.trqv_rec_type;
6109: l_pp_sty_id NUMBER;
6110: l_upp_sty_id NUMBER;
6111: l_payment_tbl payment_tbl_type ;
6112: l_store_payment_tbl payment_tbl_type;

Line 6139: FROM okl_trx_requests

6135: IS
6136: SELECT object_Version_number
6137: ,payment_amount
6138: ,payment_date
6139: FROM okl_trx_requests
6140: WHERE id=a_id;
6141:
6142:
6143:

Line 6653: l_trqv_rec okl_trx_requests_pub.trqv_rec_type;

6649: AS
6650:
6651: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
6652: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS_PPD';
6653: l_trqv_rec okl_trx_requests_pub.trqv_rec_type;
6654: lx_trqv_rec okl_trx_requests_pub.trqv_rec_type;
6655:
6656: l_post_trqv_rec okl_trx_requests_pub.trqv_rec_type;
6657:

Line 6654: lx_trqv_rec okl_trx_requests_pub.trqv_rec_type;

6650:
6651: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
6652: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS_PPD';
6653: l_trqv_rec okl_trx_requests_pub.trqv_rec_type;
6654: lx_trqv_rec okl_trx_requests_pub.trqv_rec_type;
6655:
6656: l_post_trqv_rec okl_trx_requests_pub.trqv_rec_type;
6657:
6658: l_kle_tbl OKL_MASS_REBOOK_PVT.kle_tbl_type;

Line 6656: l_post_trqv_rec okl_trx_requests_pub.trqv_rec_type;

6652: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS_PPD';
6653: l_trqv_rec okl_trx_requests_pub.trqv_rec_type;
6654: lx_trqv_rec okl_trx_requests_pub.trqv_rec_type;
6655:
6656: l_post_trqv_rec okl_trx_requests_pub.trqv_rec_type;
6657:
6658: l_kle_tbl OKL_MASS_REBOOK_PVT.kle_tbl_type;
6659: l_payment_struc okl_mass_rebook_pvt.strm_lalevl_tbl_type;
6660: i NUMBER := 1;

Line 6670: FROM okl_trx_requests

6666: ,payment_date
6667: ,payment_amount
6668: ,object_Version_number
6669: ,request_status_code
6670: FROM okl_trx_requests
6671: WHERE id=a_id;
6672:
6673: CURSOR c_kle_id_csr (a_id NUMBER)
6674: IS

Line 6759: okl_trx_requests_pub.update_trx_requests( p_api_version => p_api_version,

6755: l_trqv_rec.request_status_code := 'ACCEPTED';
6756: l_trqv_rec.tcn_id := l_tcnv_rec.id;
6757:
6758: --Update the status of the Request to "ACCEPTED"
6759: okl_trx_requests_pub.update_trx_requests( p_api_version => p_api_version,
6760: p_init_msg_list => p_init_msg_list,
6761: x_return_status => x_return_status,
6762: x_msg_count => x_msg_count,
6763: x_msg_data => x_msg_data,

Line 6865: okl_trx_requests_pub.update_trx_requests( p_api_version => p_api_version,

6861: IF l_post_trqv_rec.request_status_code NOT IN ('REBOOK_COMPLETE','REBOOK_IN_COMPLETE','PROCESSED') THEN
6862: l_post_trqv_rec.request_status_code := 'REBOOK_IN_PROCESS';
6863: --l_post_trqv_rec.tcn_id := lx_ppd_txn_id;
6864:
6865: okl_trx_requests_pub.update_trx_requests( p_api_version => p_api_version,
6866: p_init_msg_list => p_init_msg_list,
6867: x_return_status => x_return_status,
6868: x_msg_count => x_msg_count,
6869: x_msg_data => x_msg_data,

Line 6966: FROM okl_trx_requests

6962: CURSOR c_get_req_details(c_req_id NUMBER)
6963: IS
6964: SELECT payment_date
6965: ,receipt_id
6966: FROM okl_trx_requests
6967: where id=c_req_id;
6968:
6969: --Bug#5032427 added cursor to get receipt_date by dkagrawa
6970: CURSOR c_get_rcpt_date (c_rcpt_id IN NUMBER)

Line 7120: l_trqv_rec okl_trx_requests_pub.trqv_rec_type;

7116: AS
7117:
7118: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
7119: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS_PPD';
7120: l_trqv_rec okl_trx_requests_pub.trqv_rec_type;
7121: lx_trqv_rec okl_trx_requests_pub.trqv_rec_type;
7122:
7123: l_post_trqv_rec okl_trx_requests_pub.trqv_rec_type;
7124:

Line 7121: lx_trqv_rec okl_trx_requests_pub.trqv_rec_type;

7117:
7118: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
7119: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS_PPD';
7120: l_trqv_rec okl_trx_requests_pub.trqv_rec_type;
7121: lx_trqv_rec okl_trx_requests_pub.trqv_rec_type;
7122:
7123: l_post_trqv_rec okl_trx_requests_pub.trqv_rec_type;
7124:
7125: l_kle_tbl OKL_MASS_REBOOK_PVT.kle_tbl_type;

Line 7123: l_post_trqv_rec okl_trx_requests_pub.trqv_rec_type;

7119: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS_PPD';
7120: l_trqv_rec okl_trx_requests_pub.trqv_rec_type;
7121: lx_trqv_rec okl_trx_requests_pub.trqv_rec_type;
7122:
7123: l_post_trqv_rec okl_trx_requests_pub.trqv_rec_type;
7124:
7125: l_kle_tbl OKL_MASS_REBOOK_PVT.kle_tbl_type;
7126: l_payment_struc okl_mass_rebook_pvt.strm_lalevl_tbl_type;
7127: l_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;

Line 7139: FROM okl_trx_requests

7135: ,payment_amount
7136: ,object_Version_number
7137: ,request_status_code,
7138: paydown_type
7139: FROM okl_trx_requests
7140: WHERE id=a_id;
7141:
7142: CURSOR c_kle_id_csr (a_id NUMBER)
7143: IS

Line 7414: okl_trx_requests_pub.update_trx_requests( p_api_version => p_api_version,

7410: l_trqv_rec.request_status_code := 'ACCEPTED';
7411: l_trqv_rec.tcn_id := l_out_tcnv_rec.id;
7412:
7413: --Update the status of the Request to "ACCEPTED"
7414: okl_trx_requests_pub.update_trx_requests( p_api_version => p_api_version,
7415: p_init_msg_list => p_init_msg_list,
7416: x_return_status => x_return_status,
7417: x_msg_count => x_msg_count,
7418: x_msg_data => x_msg_data,

Line 7770: okl_trx_requests_pub.update_trx_requests( p_api_version => p_api_version,

7766:
7767: /* l_trqv_rec.request_status_code := 'SUBMITTED';
7768:
7769:
7770: okl_trx_requests_pub.update_trx_requests( p_api_version => p_api_version,
7771: p_init_msg_list => p_init_msg_list,
7772: x_return_status => x_return_status,
7773: x_msg_count => x_msg_count,
7774: x_msg_data => x_msg_data,