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_PRICING_PVT dependencies on OKL_LEASE_QUOTES_B

Line 443: FROM OKL_LEASE_QUOTES_B QTE,

439: l_ovr_cnt NUMBER;
440: l_ast_cnt NUMBER;
441: CURSOR llo_flag_csr IS
442: SELECT count(*) overriden_assets_count
443: FROM OKL_LEASE_QUOTES_B QTE,
444: OKL_ASSETS_B AST
445: WHERE AST.PARENT_OBJECT_ID = QTE.ID
446: AND ( AST.RATE_TEMPLATE_ID IS NOT NULL
447: OR AST.STRUCTURED_PRICING = 'Y' )

Line 453: FROM OKL_LEASE_QUOTES_B QTE,

449: AND p_line_level_pricing = 'Y';
450:
451: CURSOR rc_llo_flag_csr IS
452: SELECT count(*) overriden_assets_count
453: FROM OKL_LEASE_QUOTES_B QTE,
454: OKL_ASSETS_B AST
455: WHERE AST.PARENT_OBJECT_ID = QTE.ID
456: AND ( AST.RATE_CARD_ID IS NOT NULL
457: OR AST.LEASE_RATE_FACTOR IS NOT NULL )

Line 463: FROM OKL_LEASE_QUOTES_B QTE,

459: AND p_line_level_pricing = 'Y';
460:
461: CURSOR sy_llo_flag_csr IS
462: SELECT count(*) overriden_assets_count
463: FROM OKL_LEASE_QUOTES_B QTE,
464: OKL_ASSETS_B AST
465: WHERE AST.PARENT_OBJECT_ID = QTE.ID
466: AND ( AST.STRUCTURED_PRICING = 'Y')
467: AND QTE.ID = p_quote_id

Line 472: FROM OKL_LEASE_QUOTES_B QTE,

468: AND p_line_level_pricing = 'Y';
469:
470: CURSOR ast_cnt_csr IS
471: SELECT count(*) assets_count
472: FROM OKL_LEASE_QUOTES_B QTE,
473: OKL_ASSETS_B AST
474: WHERE AST.PARENT_OBJECT_ID = QTE.ID
475: AND QTE.ID = p_quote_id;
476:

Line 718: l_quote_id OKL_LEASE_QUOTES_B.ID%TYPE;

714: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'PRICE';
715: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
716: l_debug_enabled VARCHAR2(10);
717:
718: l_quote_id OKL_LEASE_QUOTES_B.ID%TYPE;
719:
720: -- Record/Table Type Declarations
721:
722:

Line 825: l_source_table VARCHAR2(30):= 'OKL_LEASE_QUOTES_B';

821: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'CALCULATE TAX';
822: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
823: l_debug_enabled VARCHAR2(10);
824:
825: l_source_table VARCHAR2(30):= 'OKL_LEASE_QUOTES_B';
826: l_source_trx_name VARCHAR2(15):='Quoting';
827: l_quote_id OKL_LEASE_QUOTES_B.ID%TYPE;
828:
829: -- Record/Table Type Declarations

Line 827: l_quote_id OKL_LEASE_QUOTES_B.ID%TYPE;

823: l_debug_enabled VARCHAR2(10);
824:
825: l_source_table VARCHAR2(30):= 'OKL_LEASE_QUOTES_B';
826: l_source_trx_name VARCHAR2(15):='Quoting';
827: l_quote_id OKL_LEASE_QUOTES_B.ID%TYPE;
828:
829: -- Record/Table Type Declarations
830:
831:

Line 949: FROM OKL_LEASE_QUOTES_B

945:
946: CURSOR get_primary_quote
947: IS
948: SELECT ID
949: FROM OKL_LEASE_QUOTES_B
950: WHERE parent_object_id =p_parent_object_id
951: AND primary_quote = 'Y';
952:
953: BEGIN

Line 1134: CURSOR c_check_cash_flow(p_quote_id OKL_LEASE_QUOTES_B.ID%TYPE)

1130: lv_cash_flow_exists VARCHAR2(3);
1131: l_all_lines_overriden VARCHAR2(3);
1132: l_entered VARCHAR2(3);
1133:
1134: CURSOR c_check_cash_flow(p_quote_id OKL_LEASE_QUOTES_B.ID%TYPE)
1135: IS
1136: SELECT 'YES'
1137: FROM OKL_CASH_FLOW_OBJECTS
1138: WHERE OTY_CODE = 'LEASE_QUOTE'

Line 1139: AND SOURCE_TABLE = 'OKL_LEASE_QUOTES_B'

1135: IS
1136: SELECT 'YES'
1137: FROM OKL_CASH_FLOW_OBJECTS
1138: WHERE OTY_CODE = 'LEASE_QUOTE'
1139: AND SOURCE_TABLE = 'OKL_LEASE_QUOTES_B'
1140: AND SOURCE_ID = p_quote_id;
1141:
1142: CURSOR quote_assets_csr(lc_quote_id IN NUMBER) IS
1143: SELECT ID

Line 1880: FROM okl_lease_quotes_b

1876: l_sp := l_fee_rec.structured_pricing;
1877: l_srt := l_fee_rec.rate_template_id;
1878: SELECT pricing_method
1879: INTO l_pricing_method
1880: FROM okl_lease_quotes_b
1881: where id = l_fee_Rec.parent_object_id;
1882: ELSIF p_payment_header_rec.parent_object_code = 'QUOTED_ASSET' THEN
1883: l_asset_rec := populate_asset_rec(p_asset_rec.id,x_return_status);
1884:

Line 1928: FROM okl_lease_quotes_b

1924: l_sp := l_asset_rec.structured_pricing;
1925: l_srt := l_asset_rec.rate_template_id;
1926: SELECT pricing_method
1927: INTO l_pricing_method
1928: FROM okl_lease_quotes_b
1929: where id = l_asset_rec.parent_object_id;
1930: END IF;
1931: IF l_pricing_method = 'SM' THEN
1932: FOR k IN l_payment_level_tbl.FIRST..l_payment_level_tbl.LAST LOOP

Line 2023: FROM okl_lease_quotes_b where ID = nvl(l_fee_rec.parent_object_id,l_Asset_rec.parent_object_id);

2019: RAISE OKL_API.G_EXCEPTION_ERROR;
2020: END IF;
2021:
2022: /*SELECT parent_object_id,parent_object_code INTO l_p_id,l_p_code
2023: FROM okl_lease_quotes_b where ID = nvl(l_fee_rec.parent_object_id,l_Asset_rec.parent_object_id);
2024:
2025: handle_parent_object_status(
2026: p_api_version => G_API_VERSION
2027: ,p_init_msg_list => G_FALSE

Line 2201: FROM okl_lease_quotes_b where ID = l_fee_rec.parent_object_id;

2197: RAISE OKL_API.G_EXCEPTION_ERROR;
2198: END IF;
2199:
2200: /*SELECT parent_object_id,parent_object_code INTO l_p_id,l_p_code
2201: FROM okl_lease_quotes_b where ID = l_fee_rec.parent_object_id;
2202:
2203: handle_parent_object_status(
2204: p_api_version => G_API_VERSION
2205: ,p_init_msg_list => G_FALSE

Line 2370: FROM okl_lease_quotes_b where ID = l_asset_rec.parent_object_id;

2366: RAISE OKL_API.G_EXCEPTION_ERROR;
2367: END IF;
2368:
2369: /*SELECT parent_object_id,parent_object_code INTO l_p_id,l_p_code
2370: FROM okl_lease_quotes_b where ID = l_asset_rec.parent_object_id;
2371:
2372: handle_parent_object_status(
2373: p_api_version => G_API_VERSION
2374: ,p_init_msg_list => G_FALSE