APPS.OKL_AM_CALC_QUOTE_PYMNT_PVT dependencies on OKL_TRX_QTE_CF_OBJECTS

Line 11: g_qcov_tbl_type okl_trx_qte_cf_objects_pub.qcov_tbl_type;

7: --call to bulk insert procedure
8: g_cfov_tbl_type okl_cash_flow_objects_pub.cfov_tbl_type;
9: g_cafv_tbl_type okl_cash_flows_pub.cafv_tbl_type;
10: g_cflv_tbl_type okl_cash_flow_levels_pub.cflv_tbl_type;
11: g_qcov_tbl_type okl_trx_qte_cf_objects_pub.qcov_tbl_type;
12: gx_cfov_tbl_type okl_cash_flow_objects_pub.cfov_tbl_type;
13: gx_cafv_tbl_type okl_cash_flows_pub.cafv_tbl_type;
14: gx_cflv_tbl_type okl_cash_flow_levels_pub.cflv_tbl_type;
15: gx_qcov_tbl_type okl_trx_qte_cf_objects_pub.qcov_tbl_type;

Line 15: gx_qcov_tbl_type okl_trx_qte_cf_objects_pub.qcov_tbl_type;

11: g_qcov_tbl_type okl_trx_qte_cf_objects_pub.qcov_tbl_type;
12: gx_cfov_tbl_type okl_cash_flow_objects_pub.cfov_tbl_type;
13: gx_cafv_tbl_type okl_cash_flows_pub.cafv_tbl_type;
14: gx_cflv_tbl_type okl_cash_flow_levels_pub.cflv_tbl_type;
15: gx_qcov_tbl_type okl_trx_qte_cf_objects_pub.qcov_tbl_type;
16: g_cfov_counter NUMBER := 0;
17: g_cafv_counter NUMBER := 0;
18: g_cflv_counter NUMBER := 0;
19: g_qcov_counter NUMBER := 0;

Line 305: FROM okl_cash_flow_objects cfo, okl_cash_flows caf, OKL_TRX_QTE_CF_OBJECTS qco

301: cp_source_id IN NUMBER, cp_sts_code IN VARCHAR2,
302: cp_base_src_id IN NUMBER) IS
303: --SELECT cfo.id
304: SELECT 'x'
305: FROM okl_cash_flow_objects cfo, okl_cash_flows caf, OKL_TRX_QTE_CF_OBJECTS qco
306: WHERE cfo.id = caf.cfo_id
307: AND cfo.id = qco.cfo_id
308: AND cfo.oty_code = cp_oty_code
309: AND cfo.source_table = cp_source_table

Line 860: SUBTYPE qcov_rec_type IS okl_trx_qte_cf_objects_pub.qcov_rec_type;

856:
857: SUBTYPE cfov_rec_type IS okl_cash_flow_objects_pub.cfov_rec_type;
858: SUBTYPE cafv_rec_type IS okl_cash_flows_pub.cafv_rec_type;
859: SUBTYPE cflv_rec_type IS okl_cash_flow_levels_pub.cflv_rec_type;
860: SUBTYPE qcov_rec_type IS okl_trx_qte_cf_objects_pub.qcov_rec_type;
861:
862: /*-----------------------------------------------------------------------+
863: | Local Variable Declarations and initializations |
864: +-----------------------------------------------------------------------*/

Line 943: -- Store Objects in OKL_TRX_QTE_CF_OBJECTS

939: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
940: RAISE OKL_API.G_EXCEPTION_ERROR;
941: END IF;
942:
943: -- Store Objects in OKL_TRX_QTE_CF_OBJECTS
944:
945: lp_qcov_rec.qte_id := p_quote_id;
946: lp_qcov_rec.cfo_id := l_cfo_id;
947: lp_qcov_rec.BASE_SOURCE_ID := p_khr_id;

Line 1527: SUBTYPE qcov_rec_type IS okl_trx_qte_cf_objects_pub.qcov_rec_type;

1523: /*-----------------------------------------------------------------------+
1524: | SubType Declarations
1525: +-----------------------------------------------------------------------*/
1526:
1527: SUBTYPE qcov_rec_type IS okl_trx_qte_cf_objects_pub.qcov_rec_type;
1528:
1529: /*-----------------------------------------------------------------------+
1530: | Local Variable Declarations and initializations |
1531: +-----------------------------------------------------------------------*/

Line 2184: FROM okl_cash_flow_objects cfo, okl_cash_flows caf, OKL_TRX_QTE_CF_OBJECTS qco

2180:
2181: -- get current payment objects of a particular type
2182: CURSOR l_currpymtobjects_csr(cp_oty_code IN VARCHAR2, cp_quote_id IN NUMBER) IS
2183: SELECT DISTINCT cfo.id, qco.base_source_id
2184: FROM okl_cash_flow_objects cfo, okl_cash_flows caf, OKL_TRX_QTE_CF_OBJECTS qco
2185: WHERE cfo.id = caf.cfo_id
2186: AND cfo.id = qco.cfo_id
2187: AND cfo.oty_code = cp_oty_code
2188: AND cfo.source_table = G_OBJECT_SRC_TABLE

Line 2206: SUBTYPE qcov_rec_type IS okl_trx_qte_cf_objects_pub.qcov_rec_type;

2202: /*-----------------------------------------------------------------------+
2203: | SubType Declarations |
2204: +-----------------------------------------------------------------------*/
2205:
2206: SUBTYPE qcov_rec_type IS okl_trx_qte_cf_objects_pub.qcov_rec_type;
2207:
2208: /*-----------------------------------------------------------------------+
2209: | Local Variable Declarations and initializations |
2210: +-----------------------------------------------------------------------*/