APPS.OKL_AM_CALC_QUOTE_PYMNT_PVT dependencies on OKL_CASH_FLOW_OBJECTS

Line 8: g_cfov_tbl_type okl_cash_flow_objects_pub.cfov_tbl_type;

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;

Line 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;

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

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

Line 317: SUBTYPE cfov_rec_type IS okl_cash_flow_objects_pub.cfov_rec_type;

313: /*-----------------------------------------------------------------------+
314: | SubType Declarations
315: +-----------------------------------------------------------------------*/
316:
317: SUBTYPE cfov_rec_type IS okl_cash_flow_objects_pub.cfov_rec_type;
318:
319:
320: /*-----------------------------------------------------------------------+
321: | Local Variable Declarations and initializations |

Line 856: SUBTYPE cfov_rec_type IS okl_cash_flow_objects_pub.cfov_rec_type;

852: /*-----------------------------------------------------------------------+
853: | Subype Declarations |
854: +-----------------------------------------------------------------------*/
855:
856: SUBTYPE cfov_rec_type IS okl_cash_flow_objects_pub.cfov_rec_type;
857: SUBTYPE cafv_rec_type IS okl_cash_flows_pub.cafv_rec_type;
858: SUBTYPE cflv_rec_type IS okl_cash_flow_levels_pub.cflv_rec_type;
859: SUBTYPE qcov_rec_type IS okl_trx_qte_cf_objects_pub.qcov_rec_type;
860:

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

2172:
2173: -- get current payment objects of a particular type
2174: CURSOR l_currpymtobjects_csr(cp_oty_code IN VARCHAR2, cp_quote_id IN NUMBER) IS
2175: SELECT DISTINCT cfo.id, qco.base_source_id
2176: FROM okl_cash_flow_objects cfo, okl_cash_flows caf, OKL_TRX_QTE_CF_OBJECTS qco
2177: WHERE cfo.id = caf.cfo_id
2178: AND cfo.id = qco.cfo_id
2179: AND cfo.oty_code = cp_oty_code
2180: AND cfo.source_table = G_OBJECT_SRC_TABLE