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;
13: gx_cafv_tbl_type okl_cash_flows_pub.cafv_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;
17: g_cafv_counter NUMBER := 0;
491: /*-----------------------------------------------------------------------+
492: | SubType Declarations
493: +-----------------------------------------------------------------------*/
494:
495: SUBTYPE cafv_rec_type IS okl_cash_flows_pub.cafv_rec_type;
496: SUBTYPE cflv_rec_type IS okl_cash_flow_levels_pub.cflv_rec_type;
497:
498: /*-----------------------------------------------------------------------+
499: | Local Variable Declarations and initializations |
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:
862: /*-----------------------------------------------------------------------+