APPS.OKL_LEASE_QUOTE_PVT dependencies on OKL_CASH_FLOW_OBJECTS

Line 240: OKL_CASH_FLOW_OBJECTS cfo

236: -- Cursor to fetch cashflow header id
237: CURSOR lq_cash_flows_csr(p_quote_id NUMBER) IS
238: SELECT cf.id caf_id
239: FROM OKL_CASH_FLOWS cf,
240: OKL_CASH_FLOW_OBJECTS cfo
241: WHERE cf.cfo_id = cfo.id
242: AND cfo.source_table = 'OKL_LEASE_QUOTES_B'
243: AND cfo.source_id = p_quote_id;
244:

Line 1544: FROM OKL_CASH_FLOW_OBJECTS

1540: lv_chk_payment VARCHAR2(1);
1541:
1542: CURSOR c_chk_payments IS
1543: SELECT 'Y'
1544: FROM OKL_CASH_FLOW_OBJECTS
1545: WHERE SOURCE_ID = p_source_quote_id
1546: AND SOURCE_TABLE = 'OKL_LEASE_QUOTES_B'
1547: AND OTY_CODE = 'LEASE_QUOTE';
1548:

Line 1551: FROM OKL_CASH_FLOW_OBJECTS

1547: AND OTY_CODE = 'LEASE_QUOTE';
1548:
1549: CURSOR c_chk_payments_cons IS
1550: SELECT 'Y'
1551: FROM OKL_CASH_FLOW_OBJECTS
1552: WHERE SOURCE_ID = p_source_quote_id
1553: AND SOURCE_TABLE = 'OKL_LEASE_QUOTES_B'
1554: AND OTY_CODE = 'LEASE_QUOTE_CONSOLIDATED';
1555:

Line 3184: CURSOR c_get_cashflow_info(p_src_id OKL_CASH_FLOW_OBJECTS.SOURCE_ID%TYPE

3180: ,x_msg_count OUT NOCOPY NUMBER
3181: ,x_msg_data OUT NOCOPY VARCHAR2) IS
3182:
3183:
3184: CURSOR c_get_cashflow_info(p_src_id OKL_CASH_FLOW_OBJECTS.SOURCE_ID%TYPE
3185: ,p_oty_code OKL_CASH_FLOW_OBJECTS.OTY_CODE%TYPE
3186: ,p_source_table OKL_CASH_FLOW_OBJECTS.SOURCE_TABLE%TYPE)
3187: IS
3188: SELECT CFLOW.ID , CFLOW.OBJECT_VERSION_NUMBER

Line 3185: ,p_oty_code OKL_CASH_FLOW_OBJECTS.OTY_CODE%TYPE

3181: ,x_msg_data OUT NOCOPY VARCHAR2) IS
3182:
3183:
3184: CURSOR c_get_cashflow_info(p_src_id OKL_CASH_FLOW_OBJECTS.SOURCE_ID%TYPE
3185: ,p_oty_code OKL_CASH_FLOW_OBJECTS.OTY_CODE%TYPE
3186: ,p_source_table OKL_CASH_FLOW_OBJECTS.SOURCE_TABLE%TYPE)
3187: IS
3188: SELECT CFLOW.ID , CFLOW.OBJECT_VERSION_NUMBER
3189: FROM OKL_CASH_FLOWS CFLOW, OKL_CASH_FLOW_OBJECTS CFO

Line 3186: ,p_source_table OKL_CASH_FLOW_OBJECTS.SOURCE_TABLE%TYPE)

3182:
3183:
3184: CURSOR c_get_cashflow_info(p_src_id OKL_CASH_FLOW_OBJECTS.SOURCE_ID%TYPE
3185: ,p_oty_code OKL_CASH_FLOW_OBJECTS.OTY_CODE%TYPE
3186: ,p_source_table OKL_CASH_FLOW_OBJECTS.SOURCE_TABLE%TYPE)
3187: IS
3188: SELECT CFLOW.ID , CFLOW.OBJECT_VERSION_NUMBER
3189: FROM OKL_CASH_FLOWS CFLOW, OKL_CASH_FLOW_OBJECTS CFO
3190: WHERE CFO.SOURCE_ID = p_src_id

Line 3189: FROM OKL_CASH_FLOWS CFLOW, OKL_CASH_FLOW_OBJECTS CFO

3185: ,p_oty_code OKL_CASH_FLOW_OBJECTS.OTY_CODE%TYPE
3186: ,p_source_table OKL_CASH_FLOW_OBJECTS.SOURCE_TABLE%TYPE)
3187: IS
3188: SELECT CFLOW.ID , CFLOW.OBJECT_VERSION_NUMBER
3189: FROM OKL_CASH_FLOWS CFLOW, OKL_CASH_FLOW_OBJECTS CFO
3190: WHERE CFO.SOURCE_ID = p_src_id
3191: AND CFO.OTY_CODE = p_oty_code
3192: AND CFO.SOURCE_TABLE=p_source_table
3193: AND CFLOW.CFO_ID = CFO.ID;

Line 3195: lp_source_table OKL_CASH_FLOW_OBJECTS.SOURCE_TABLE%TYPE;

3191: AND CFO.OTY_CODE = p_oty_code
3192: AND CFO.SOURCE_TABLE=p_source_table
3193: AND CFLOW.CFO_ID = CFO.ID;
3194:
3195: lp_source_table OKL_CASH_FLOW_OBJECTS.SOURCE_TABLE%TYPE;
3196: lv_stream_type_purpose VARCHAR2(150);
3197: i BINARY_INTEGER := 0;
3198: l_program_name CONSTANT VARCHAR2(30) := 'ppltu_cfl';
3199: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_program_name;