APPS.OKL_CS_PRINCIPAL_PAYDOWN_PVT dependencies on OKL_TRX_QTE_CF_OBJECTS

Line 4500: FROM okl_cash_flow_objects cfo, OKL_TRX_QTE_CF_OBJECTS qco

4496: cp_source_table IN VARCHAR2,
4497: cp_source_id IN NUMBER,
4498: cp_base_src_id IN NUMBER) IS
4499: SELECT cfo.id
4500: FROM okl_cash_flow_objects cfo, OKL_TRX_QTE_CF_OBJECTS qco
4501: WHERE cfo.id = qco.cfo_id
4502: AND cfo.oty_code = cp_oty_code
4503: AND cfo.source_table = cp_source_table
4504: AND cfo.source_id = cp_source_id

Line 5120: SUBTYPE qcov_rec_type IS okl_trx_qte_cf_objects_pub.qcov_rec_type;

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: /*-----------------------------------------------------------------------+
5124: * * | Local Variable Declarations and initializations |

Line 5164: FROM OKL_TRX_QTE_CF_OBJECTS

5160: CURSOR l_qco_id_csr(cp_qte_id IN NUMBER
5161: ,cp_cfo_id IN NUMBER
5162: ,cp_base_src_id IN NUMBER) IS
5163: SELECT id
5164: FROM OKL_TRX_QTE_CF_OBJECTS
5165: WHERE qte_id=cp_qte_id
5166: AND cfo_id=cp_cfo_id
5167: AND base_source_id=cp_base_src_id;
5168:

Line 5288: OKL_TRX_QTE_CF_OBJECTS_PUB.insert_quote_cf_object(p_api_version => p_api_version,

5284: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
5285: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Before Creating QCO');
5286: END IF;
5287:
5288: OKL_TRX_QTE_CF_OBJECTS_PUB.insert_quote_cf_object(p_api_version => p_api_version,
5289: p_init_msg_list => OKL_API.G_FALSE,
5290: x_return_status => l_return_status,
5291: x_msg_count => x_msg_count,
5292: x_msg_data => x_msg_data,

Line 5608: SUBTYPE qcov_rec_type IS okl_trx_qte_cf_objects_pub.qcov_rec_type;

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: /*-----------------------------------------------------------------------+
5612: * | Local Variable Declarations and initializations |

Line 5653: FROM OKL_TRX_QTE_CF_OBJECTS

5649: CURSOR l_qco_id_csr(cp_qte_id IN NUMBER
5650: ,cp_cfo_id IN NUMBER
5651: ,cp_base_src_id IN NUMBER) IS
5652: SELECT id
5653: FROM OKL_TRX_QTE_CF_OBJECTS
5654: WHERE qte_id=cp_qte_id
5655: AND cfo_id=cp_cfo_id
5656: AND base_source_id=cp_base_src_id;
5657:

Line 5829: OKL_TRX_QTE_CF_OBJECTS_PUB.insert_quote_cf_object(p_api_version => p_api_version,

5825: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
5826: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Before Creating QCO');
5827: END IF;
5828:
5829: OKL_TRX_QTE_CF_OBJECTS_PUB.insert_quote_cf_object(p_api_version => p_api_version,
5830: p_init_msg_list => OKL_API.G_FALSE,
5831: x_return_status => l_return_status,
5832: x_msg_count => x_msg_count,
5833: x_msg_data => x_msg_data,

Line 6676: FROM okl_trx_qte_cf_objects

6672:
6673: CURSOR c_kle_id_csr (a_id NUMBER)
6674: IS
6675: SELECT base_source_id
6676: FROM okl_trx_qte_cf_objects
6677: WHERE qte_id=a_id;
6678:
6679:
6680: BEGIN

Line 7161: FROM okl_trx_qte_cf_objects

7157:
7158: CURSOR c_kle_id_csr (a_id NUMBER)
7159: IS
7160: SELECT base_source_id
7161: FROM okl_trx_qte_cf_objects
7162: WHERE qte_id=a_id;
7163:
7164:
7165: CURSOR try_csr_lpd IS