4: --Bug 4299668 PAGARG declared these table types & counters for bulk insert
5: --**START**--
6: --Define it globally, keep populating the table of records and finally make a
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;
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;
16: g_cfov_counter NUMBER := 0;
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
314: /*-----------------------------------------------------------------------+
315: | SubType Declarations
316: +-----------------------------------------------------------------------*/
317:
318: SUBTYPE cfov_rec_type IS okl_cash_flow_objects_pub.cfov_rec_type;
319:
320:
321: /*-----------------------------------------------------------------------+
322: | Local Variable Declarations and initializations |
853: /*-----------------------------------------------------------------------+
854: | Subype Declarations |
855: +-----------------------------------------------------------------------*/
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:
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