eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_LEASE_QUOTE_PVT dependencies on OKL_LEASE_QUOTE_CASHFLOW_PVT

Line 1565: okl_lease_quote_cashflow_pvt.duplicate_cashflows (

1561: CLOSE c_chk_payments;
1562:
1563: -- Copy Header level payments
1564: IF (lv_chk_payment = 'Y') THEN
1565: okl_lease_quote_cashflow_pvt.duplicate_cashflows (
1566: p_api_version => p_api_version
1567: ,p_init_msg_list => p_init_msg_list
1568: ,p_transaction_control => 'T'
1569: ,p_source_object_code => 'LEASE_QUOTE'

Line 1592: okl_lease_quote_cashflow_pvt.duplicate_cashflows (

1588: CLOSE c_chk_payments_cons;
1589:
1590: -- Copy Header level payments
1591: IF (lv_chk_payment = 'Y') THEN
1592: okl_lease_quote_cashflow_pvt.duplicate_cashflows (
1593: p_api_version => p_api_version
1594: ,p_init_msg_list => p_init_msg_list
1595: ,p_transaction_control => 'T'
1596: ,p_source_object_code => 'LEASE_QUOTE_CONSOLIDATED'

Line 3281: lp_cashflow_header_rec OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_header_rec_type;

3277: i NUMBER := 1;
3278: lp_asset_tbl okl_ass_pvt.assv_tbl_type;
3279: lx_asset_rec okl_ass_pvt.assv_rec_type;
3280:
3281: lp_cashflow_header_rec OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_header_rec_type;
3282: lp_cashflow_level_tbl OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_level_tbl_type;
3283:
3284:
3285: CURSOR get_asset_count(lp_quote_id NUMBER) IS

Line 3282: lp_cashflow_level_tbl OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_level_tbl_type;

3278: lp_asset_tbl okl_ass_pvt.assv_tbl_type;
3279: lx_asset_rec okl_ass_pvt.assv_rec_type;
3280:
3281: lp_cashflow_header_rec OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_header_rec_type;
3282: lp_cashflow_level_tbl OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_level_tbl_type;
3283:
3284:
3285: CURSOR get_asset_count(lp_quote_id NUMBER) IS
3286: SELECT COUNT(*)

Line 3336: OKL_LEASE_QUOTE_CASHFLOW_PVT.delete_cashflows (p_api_version => G_API_VERSION

3332: END IF;
3333: i := i + 1;
3334: END LOOP;
3335: --Delete all Lease Quote Consolidated Cash Flows
3336: OKL_LEASE_QUOTE_CASHFLOW_PVT.delete_cashflows (p_api_version => G_API_VERSION
3337: ,p_init_msg_list => G_FALSE
3338: ,p_transaction_control => G_FALSE
3339: ,p_source_object_code => 'LEASE_QUOTE_CONSOLIDATED'
3340: ,p_source_object_id => p_quote_id

Line 3357: OKL_LEASE_QUOTE_CASHFLOW_PVT.delete_cashflows (

3353: lp_lease_qte_rec.RATE_TEMPLATE_ID := NULL;
3354: lp_lease_qte_rec.TARGET_AMOUNT := NULL;
3355:
3356:
3357: OKL_LEASE_QUOTE_CASHFLOW_PVT.delete_cashflows (
3358: p_api_version => G_API_VERSION
3359: ,p_init_msg_list => G_FALSE
3360: ,p_transaction_control => G_TRUE --Check this
3361: ,p_source_object_code => 'LEASE_QUOTE'

Line 3438: OKL_LEASE_QUOTE_CASHFLOW_PVT.delete_cashflows (

3434: lp_asset_tbl(i).rate_template_id := NULL;
3435: lp_asset_tbl(i).TARGET_AMOUNT := NULL;
3436: lp_asset_tbl(i).TARGET_FREQUENCY := NULL;
3437:
3438: OKL_LEASE_QUOTE_CASHFLOW_PVT.delete_cashflows (
3439: p_api_version => G_API_VERSION
3440: ,p_init_msg_list => G_FALSE
3441: ,p_transaction_control => G_FALSE --Check this
3442: ,p_source_object_code => 'QUOTED_ASSET'

Line 3591: l_payment_header_rec okl_lease_quote_cashflow_pvt.cashflow_header_rec_type;

3587:
3588: l_qte_fee_rec lease_qte_fee_rec_type;
3589: l_line_relation_tbl okl_lease_quote_fee_pvt.line_relation_tbl_type;
3590:
3591: l_payment_header_rec okl_lease_quote_cashflow_pvt.cashflow_header_rec_type;
3592: l_payment_level_tbl okl_lease_quote_cashflow_pvt.cashflow_level_tbl_type;
3593:
3594: l_expense_header_rec okl_lease_quote_cashflow_pvt.cashflow_header_rec_type;
3595: l_expense_level_tbl okl_lease_quote_cashflow_pvt.cashflow_level_tbl_type;

Line 3592: l_payment_level_tbl okl_lease_quote_cashflow_pvt.cashflow_level_tbl_type;

3588: l_qte_fee_rec lease_qte_fee_rec_type;
3589: l_line_relation_tbl okl_lease_quote_fee_pvt.line_relation_tbl_type;
3590:
3591: l_payment_header_rec okl_lease_quote_cashflow_pvt.cashflow_header_rec_type;
3592: l_payment_level_tbl okl_lease_quote_cashflow_pvt.cashflow_level_tbl_type;
3593:
3594: l_expense_header_rec okl_lease_quote_cashflow_pvt.cashflow_header_rec_type;
3595: l_expense_level_tbl okl_lease_quote_cashflow_pvt.cashflow_level_tbl_type;
3596:

Line 3594: l_expense_header_rec okl_lease_quote_cashflow_pvt.cashflow_header_rec_type;

3590:
3591: l_payment_header_rec okl_lease_quote_cashflow_pvt.cashflow_header_rec_type;
3592: l_payment_level_tbl okl_lease_quote_cashflow_pvt.cashflow_level_tbl_type;
3593:
3594: l_expense_header_rec okl_lease_quote_cashflow_pvt.cashflow_header_rec_type;
3595: l_expense_level_tbl okl_lease_quote_cashflow_pvt.cashflow_level_tbl_type;
3596:
3597: CURSOR l_get_assets_tax_amount(cp_quote_id IN NUMBER) IS
3598: SELECT SUM(total_tax)

Line 3595: l_expense_level_tbl okl_lease_quote_cashflow_pvt.cashflow_level_tbl_type;

3591: l_payment_header_rec okl_lease_quote_cashflow_pvt.cashflow_header_rec_type;
3592: l_payment_level_tbl okl_lease_quote_cashflow_pvt.cashflow_level_tbl_type;
3593:
3594: l_expense_header_rec okl_lease_quote_cashflow_pvt.cashflow_header_rec_type;
3595: l_expense_level_tbl okl_lease_quote_cashflow_pvt.cashflow_level_tbl_type;
3596:
3597: CURSOR l_get_assets_tax_amount(cp_quote_id IN NUMBER) IS
3598: SELECT SUM(total_tax)
3599: FROM okl_tax_sources