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 445: FROM OKL_LEASE_QUOTES_B QTE,

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

Line 455: FROM OKL_LEASE_QUOTES_B QTE,

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

Line 465: FROM OKL_LEASE_QUOTES_B QTE,

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

Line 474: FROM OKL_LEASE_QUOTES_B QTE,

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

Line 720: l_quote_id OKL_LEASE_QUOTES_B.ID%TYPE;

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

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

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

Line 829: l_quote_id OKL_LEASE_QUOTES_B.ID%TYPE;

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

Line 951: FROM OKL_LEASE_QUOTES_B

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

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

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

Line 1141: AND SOURCE_TABLE = 'OKL_LEASE_QUOTES_B'

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

Line 1882: FROM okl_lease_quotes_b

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

Line 1930: FROM okl_lease_quotes_b

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

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

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

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

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

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

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