APPS.OKL_CS_PRINCIPAL_PAYDOWN_PVT dependencies on OKL_CASH_FLOW_LEVELS

Line 2212: SUBTYPE cflv_rec_type IS okl_cash_flow_levels_pub.cflv_rec_type;

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';
2216: lp_cafv_rec cafv_rec_type;

Line 2238: FROM OKL_CASH_FLOW_LEVELS

2234: AND dnz_qte_id=cp_request_id;
2235:
2236: CURSOR l_cfl_id_csr(cp_caf_id IN NUMBER) IS
2237: SELECT id
2238: FROM OKL_CASH_FLOW_LEVELS
2239: WHERE caf_id=cp_caf_id;
2240:
2241: BEGIN
2242: IF (G_DEBUG_ENABLED = 'Y') THEN

Line 2286: OKL_CASH_FLOW_LEVELS_PUB.delete_cash_flow_level(

2282: FOR cfl_rec IN l_cfl_id_csr(l_caf_id) LOOP
2283:
2284: lp_cflv_rec.id := cfl_rec.id;
2285: --Delete all the Cash flow levels for this Cash flow.
2286: OKL_CASH_FLOW_LEVELS_PUB.delete_cash_flow_level(
2287: p_api_version => p_api_version,
2288: p_init_msg_list => OKL_API.G_FALSE,
2289: x_return_status => l_return_status,
2290: x_msg_count => x_msg_count,

Line 5119: SUBTYPE cflv_rec_type IS okl_cash_flow_levels_pub.cflv_rec_type;

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:
5123: /*-----------------------------------------------------------------------+

Line 5181: FROM OKL_CASH_FLOW_LEVELS

5177:
5178: CURSOR l_cfl_id_csr(cp_caf_id IN NUMBER
5179: ,cp_start_date IN DATE) IS
5180: SELECT id
5181: FROM OKL_CASH_FLOW_LEVELS
5182: WHERE caf_id=cp_caf_id
5183: AND start_date=cp_start_date;
5184:
5185: i NUMBER := 0;

Line 5195: FROM OKL_CASH_FLOW_LEVELS

5191:
5192: CURSOR l_cfl_id_csr_esg(cp_caf_id IN NUMBER
5193: ,cp_amount IN number) IS
5194: SELECT id,number_of_periods,start_date
5195: FROM OKL_CASH_FLOW_LEVELS
5196: WHERE caf_id=cp_caf_id
5197: AND amount = cp_amount
5198: AND stub_days IS null;
5199:

Line 5457: OKL_CASH_FLOW_LEVELS_PUB.insert_cash_flow_level(

5453:
5454: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
5455: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Before Creating CFL');
5456: END IF;
5457: OKL_CASH_FLOW_LEVELS_PUB.insert_cash_flow_level(
5458: p_api_version => p_api_version,
5459: p_init_msg_list => OKL_API.G_FALSE,
5460: x_return_status => l_return_status,
5461: x_msg_count => x_msg_count,

Line 5511: OKL_CASH_FLOW_LEVELS_PUB.update_cash_flow_level(

5507: lp_cflv_rec.id := l_cfl_id;
5508: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
5509: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Before Updating CFL');
5510: END IF;
5511: OKL_CASH_FLOW_LEVELS_PUB.update_cash_flow_level(
5512: p_api_version => p_api_version,
5513: p_init_msg_list => OKL_API.G_FALSE,
5514: x_return_status => l_return_status,
5515: x_msg_count => x_msg_count,

Line 5607: SUBTYPE cflv_rec_type IS okl_cash_flow_levels_pub.cflv_rec_type;

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:
5611: /*-----------------------------------------------------------------------+

Line 5670: FROM OKL_CASH_FLOW_LEVELS

5666:
5667: CURSOR l_cfl_id_csr(cp_caf_id IN NUMBER
5668: ,cp_start_date IN DATE) IS
5669: SELECT id
5670: FROM OKL_CASH_FLOW_LEVELS
5671: WHERE caf_id=cp_caf_id
5672: AND start_date=cp_start_date;
5673:
5674:

Line 5973: OKL_CASH_FLOW_LEVELS_PUB.insert_cash_flow_level(

5969:
5970: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
5971: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Before Creating CFL');
5972: END IF;
5973: OKL_CASH_FLOW_LEVELS_PUB.insert_cash_flow_level(
5974: p_api_version => p_api_version,
5975: p_init_msg_list => OKL_API.G_FALSE,
5976: x_return_status => l_return_status,
5977: x_msg_count => x_msg_count,

Line 6019: OKL_CASH_FLOW_LEVELS_PUB.update_cash_flow_level(

6015: lp_cflv_rec.id := l_cfl_id;
6016: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
6017: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Before Updating CFL');
6018: END IF;
6019: OKL_CASH_FLOW_LEVELS_PUB.update_cash_flow_level(
6020: p_api_version => p_api_version,
6021: p_init_msg_list => OKL_API.G_FALSE,
6022: x_return_status => l_return_status,
6023: x_msg_count => x_msg_count,