APPS.OKL_CS_PRINCIPAL_PAYDOWN_PVT dependencies on OKL_CASH_FLOWS

Line 2211: SUBTYPE cafv_rec_type IS okl_cash_flows_pub.cafv_rec_type;

2207: p_request_id IN NUMBER)
2208: AS
2209:
2210:
2211: SUBTYPE cafv_rec_type IS okl_cash_flows_pub.cafv_rec_type;
2212: SUBTYPE cflv_rec_type IS okl_cash_flow_levels_pub.cflv_rec_type;
2213:
2214: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2215: l_api_name CONSTANT VARCHAR2(30) := 'delete_payments';

Line 2232: FROM OKL_CASH_FLOWS

2228:
2229: CURSOR l_caf_id_csr(cp_request_id IN NUMBER
2230: ,cp_cfo_id IN NUMBER) IS
2231: SELECT id
2232: FROM OKL_CASH_FLOWS
2233: WHERE cfo_id=cp_cfo_id
2234: AND dnz_qte_id=cp_request_id;
2235:
2236: CURSOR l_cfl_id_csr(cp_caf_id IN NUMBER) IS

Line 2305: okl_cash_flows_pub.delete_cash_flow(

2301: END IF;
2302: END LOOP;
2303: --Delete all the Cashflows for this Request.
2304: lp_cafv_rec.id := l_caf_id;
2305: okl_cash_flows_pub.delete_cash_flow(
2306: p_api_version => p_api_version,
2307: p_init_msg_list => OKL_API.G_FALSE,
2308: x_return_status => l_return_status,
2309: x_msg_count => x_msg_count,

Line 5118: SUBTYPE cafv_rec_type IS okl_cash_flows_pub.cafv_rec_type;

5114: * *
5115: * +-----------------------------------------------------------------------*/
5116:
5117: SUBTYPE cfov_rec_type IS okl_cash_flow_objects_pub.cfov_rec_type;
5118: SUBTYPE cafv_rec_type IS okl_cash_flows_pub.cafv_rec_type;
5119: SUBTYPE cflv_rec_type IS okl_cash_flow_levels_pub.cflv_rec_type;
5120: SUBTYPE qcov_rec_type IS okl_trx_qte_cf_objects_pub.qcov_rec_type;
5121:
5122:

Line 5173: FROM OKL_CASH_FLOWS

5169: CURSOR l_caf_id_csr(cp_qte_id IN NUMBER
5170: ,cp_cfo_id IN NUMBER
5171: ,cp_sty_id IN NUMBER) IS
5172: SELECT id
5173: FROM OKL_CASH_FLOWS
5174: WHERE cfo_id=cp_cfo_id
5175: AND dnz_qte_id=cp_qte_id
5176: AND sty_id = cp_sty_id;
5177:

Line 5347: okl_cash_flows_pub.insert_cash_flow(

5343: lp_cafv_rec.number_of_advance_periods := p_payment_tbl(i).structure;
5344: lp_cafv_rec.dnz_khr_id := p_ppd_khr_id;
5345: lp_cafv_rec.dnz_qte_id := p_ppd_request_id;
5346: --Call the API to create the Cash Flow.
5347: okl_cash_flows_pub.insert_cash_flow(
5348: p_api_version => p_api_version,
5349: p_init_msg_list => OKL_API.G_FALSE,
5350: x_return_status => l_return_status,
5351: x_msg_count => x_msg_count,

Line 5378: okl_cash_flows_pub.update_cash_flow(

5374: lp_cafv_rec.number_of_advance_periods := p_payment_tbl(i).structure;
5375: lp_cafv_rec.dnz_khr_id := p_ppd_khr_id;
5376: lp_cafv_rec.dnz_qte_id := p_ppd_request_id;
5377: --Call the API to create the Cash Flow.
5378: okl_cash_flows_pub.update_cash_flow(
5379: p_api_version => p_api_version,
5380: p_init_msg_list => OKL_API.G_FALSE,
5381: x_return_status => l_return_status,
5382: x_msg_count => x_msg_count,

Line 5606: SUBTYPE cafv_rec_type IS okl_cash_flows_pub.cafv_rec_type;

5602: * | Subype Declarations |
5603: * +-----------------------------------------------------------------------*/
5604:
5605: SUBTYPE cfov_rec_type IS okl_cash_flow_objects_pub.cfov_rec_type;
5606: SUBTYPE cafv_rec_type IS okl_cash_flows_pub.cafv_rec_type;
5607: SUBTYPE cflv_rec_type IS okl_cash_flow_levels_pub.cflv_rec_type;
5608: SUBTYPE qcov_rec_type IS okl_trx_qte_cf_objects_pub.qcov_rec_type;
5609:
5610:

Line 5662: FROM OKL_CASH_FLOWS

5658: CURSOR l_caf_id_csr(cp_qte_id IN NUMBER
5659: ,cp_cfo_id IN NUMBER
5660: ,cp_sty_id IN NUMBER) IS
5661: SELECT id
5662: FROM OKL_CASH_FLOWS
5663: WHERE cfo_id=cp_cfo_id
5664: AND dnz_qte_id=cp_qte_id
5665: AND sty_id = cp_sty_id;
5666:

Line 5885: okl_cash_flows_pub.insert_cash_flow(

5881: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Before Creating CAF');
5882: END IF;
5883:
5884: --Call the API to create the Cash Flow.
5885: okl_cash_flows_pub.insert_cash_flow(
5886: p_api_version => p_api_version,
5887: p_init_msg_list => OKL_API.G_FALSE,
5888: x_return_status => l_return_status,
5889: x_msg_count => x_msg_count,

Line 5917: okl_cash_flows_pub.update_cash_flow(

5913: lp_cafv_rec.dnz_khr_id := p_ppd_khr_id;
5914: lp_cafv_rec.dnz_qte_id := p_ppd_request_id;
5915: lp_cafv_rec.id := l_caf_id;
5916: --Call the API to create the Cash Flow.
5917: okl_cash_flows_pub.update_cash_flow(
5918: p_api_version => p_api_version,
5919: p_init_msg_list => OKL_API.G_FALSE,
5920: x_return_status => l_return_status,
5921: x_msg_count => x_msg_count,