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 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 859: SUBTYPE qcov_rec_type IS okl_trx_qte_cf_objects_pub.qcov_rec_type;

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

Line 942: -- Store Objects in OKL_TRX_QTE_CF_OBJECTS

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

Line 1519: SUBTYPE qcov_rec_type IS okl_trx_qte_cf_objects_pub.qcov_rec_type;

1515: /*-----------------------------------------------------------------------+
1516: | SubType Declarations
1517: +-----------------------------------------------------------------------*/
1518:
1519: SUBTYPE qcov_rec_type IS okl_trx_qte_cf_objects_pub.qcov_rec_type;
1520:
1521: /*-----------------------------------------------------------------------+
1522: | Local Variable Declarations and initializations |
1523: +-----------------------------------------------------------------------*/

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

Line 2198: SUBTYPE qcov_rec_type IS okl_trx_qte_cf_objects_pub.qcov_rec_type;

2194: /*-----------------------------------------------------------------------+
2195: | SubType Declarations |
2196: +-----------------------------------------------------------------------*/
2197:
2198: SUBTYPE qcov_rec_type IS okl_trx_qte_cf_objects_pub.qcov_rec_type;
2199:
2200: /*-----------------------------------------------------------------------+
2201: | Local Variable Declarations and initializations |
2202: +-----------------------------------------------------------------------*/