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 1539: okl_lease_quote_cashflow_pvt.duplicate_cashflows (

1535: CLOSE c_chk_payments;
1536:
1537: -- Copy Header level payments
1538: IF (lv_chk_payment = 'Y') THEN
1539: okl_lease_quote_cashflow_pvt.duplicate_cashflows (
1540: p_api_version => p_api_version
1541: ,p_init_msg_list => p_init_msg_list
1542: ,p_transaction_control => 'T'
1543: ,p_source_object_code => 'LEASE_QUOTE'

Line 1566: okl_lease_quote_cashflow_pvt.duplicate_cashflows (

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

Line 3181: lp_cashflow_header_rec OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_header_rec_type;

3177: i NUMBER := 1;
3178: lp_asset_tbl okl_ass_pvt.assv_tbl_type;
3179: lx_asset_rec okl_ass_pvt.assv_rec_type;
3180:
3181: lp_cashflow_header_rec OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_header_rec_type;
3182: lp_cashflow_level_tbl OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_level_tbl_type;
3183:
3184:
3185: CURSOR get_asset_count(lp_quote_id NUMBER) IS

Line 3182: lp_cashflow_level_tbl OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_level_tbl_type;

3178: lp_asset_tbl okl_ass_pvt.assv_tbl_type;
3179: lx_asset_rec okl_ass_pvt.assv_rec_type;
3180:
3181: lp_cashflow_header_rec OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_header_rec_type;
3182: lp_cashflow_level_tbl OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_level_tbl_type;
3183:
3184:
3185: CURSOR get_asset_count(lp_quote_id NUMBER) IS
3186: SELECT COUNT(*)

Line 3236: OKL_LEASE_QUOTE_CASHFLOW_PVT.delete_cashflows (p_api_version => G_API_VERSION

3232: END IF;
3233: i := i + 1;
3234: END LOOP;
3235: --Delete all Lease Quote Consolidated Cash Flows
3236: OKL_LEASE_QUOTE_CASHFLOW_PVT.delete_cashflows (p_api_version => G_API_VERSION
3237: ,p_init_msg_list => G_FALSE
3238: ,p_transaction_control => G_FALSE
3239: ,p_source_object_code => 'LEASE_QUOTE_CONSOLIDATED'
3240: ,p_source_object_id => p_quote_id

Line 3257: OKL_LEASE_QUOTE_CASHFLOW_PVT.delete_cashflows (

3253: lp_lease_qte_rec.RATE_TEMPLATE_ID := NULL;
3254: lp_lease_qte_rec.TARGET_AMOUNT := NULL;
3255:
3256:
3257: OKL_LEASE_QUOTE_CASHFLOW_PVT.delete_cashflows (
3258: p_api_version => G_API_VERSION
3259: ,p_init_msg_list => G_FALSE
3260: ,p_transaction_control => G_TRUE --Check this
3261: ,p_source_object_code => 'LEASE_QUOTE'

Line 3338: OKL_LEASE_QUOTE_CASHFLOW_PVT.delete_cashflows (

3334: lp_asset_tbl(i).rate_template_id := NULL;
3335: lp_asset_tbl(i).TARGET_AMOUNT := NULL;
3336: lp_asset_tbl(i).TARGET_FREQUENCY := NULL;
3337:
3338: OKL_LEASE_QUOTE_CASHFLOW_PVT.delete_cashflows (
3339: p_api_version => G_API_VERSION
3340: ,p_init_msg_list => G_FALSE
3341: ,p_transaction_control => G_FALSE --Check this
3342: ,p_source_object_code => 'QUOTED_ASSET'

Line 3491: l_payment_header_rec okl_lease_quote_cashflow_pvt.cashflow_header_rec_type;

3487:
3488: l_qte_fee_rec lease_qte_fee_rec_type;
3489: l_line_relation_tbl okl_lease_quote_fee_pvt.line_relation_tbl_type;
3490:
3491: l_payment_header_rec okl_lease_quote_cashflow_pvt.cashflow_header_rec_type;
3492: l_payment_level_tbl okl_lease_quote_cashflow_pvt.cashflow_level_tbl_type;
3493:
3494: l_expense_header_rec okl_lease_quote_cashflow_pvt.cashflow_header_rec_type;
3495: l_expense_level_tbl okl_lease_quote_cashflow_pvt.cashflow_level_tbl_type;

Line 3492: l_payment_level_tbl okl_lease_quote_cashflow_pvt.cashflow_level_tbl_type;

3488: l_qte_fee_rec lease_qte_fee_rec_type;
3489: l_line_relation_tbl okl_lease_quote_fee_pvt.line_relation_tbl_type;
3490:
3491: l_payment_header_rec okl_lease_quote_cashflow_pvt.cashflow_header_rec_type;
3492: l_payment_level_tbl okl_lease_quote_cashflow_pvt.cashflow_level_tbl_type;
3493:
3494: l_expense_header_rec okl_lease_quote_cashflow_pvt.cashflow_header_rec_type;
3495: l_expense_level_tbl okl_lease_quote_cashflow_pvt.cashflow_level_tbl_type;
3496:

Line 3494: l_expense_header_rec okl_lease_quote_cashflow_pvt.cashflow_header_rec_type;

3490:
3491: l_payment_header_rec okl_lease_quote_cashflow_pvt.cashflow_header_rec_type;
3492: l_payment_level_tbl okl_lease_quote_cashflow_pvt.cashflow_level_tbl_type;
3493:
3494: l_expense_header_rec okl_lease_quote_cashflow_pvt.cashflow_header_rec_type;
3495: l_expense_level_tbl okl_lease_quote_cashflow_pvt.cashflow_level_tbl_type;
3496:
3497: CURSOR l_get_assets_tax_amount(cp_quote_id IN NUMBER) IS
3498: SELECT SUM(total_tax)

Line 3495: l_expense_level_tbl okl_lease_quote_cashflow_pvt.cashflow_level_tbl_type;

3491: l_payment_header_rec okl_lease_quote_cashflow_pvt.cashflow_header_rec_type;
3492: l_payment_level_tbl okl_lease_quote_cashflow_pvt.cashflow_level_tbl_type;
3493:
3494: l_expense_header_rec okl_lease_quote_cashflow_pvt.cashflow_header_rec_type;
3495: l_expense_level_tbl okl_lease_quote_cashflow_pvt.cashflow_level_tbl_type;
3496:
3497: CURSOR l_get_assets_tax_amount(cp_quote_id IN NUMBER) IS
3498: SELECT SUM(total_tax)
3499: FROM okl_tax_sources