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_ACTIVATE_ASSET_PVT dependencies on OKL_TXL_ASSETS_B

Line 941: -- ID of line table (OKL_TXL_ASSETS_B or

937: -- 'OKL_TRX_ASSETS'
938: -- p_sla_source_try_id IN Number,
939: -- OKL_TRX_ASSETS.try_id (transaction type id)
940: -- p_sla_source_line_id IN Number,
941: -- ID of line table (OKL_TXL_ASSETS_B or
942: -- OKL_TXD_ASSETS_B
943: -- p_sla_source_line_table IN Varchar2,
944: -- OKL_TXL_ASSETS_B or OKL_TXD_ASSETS_B
945: -- p_sla_source_chr_id IN Number,

Line 944: -- OKL_TXL_ASSETS_B or OKL_TXD_ASSETS_B

940: -- p_sla_source_line_id IN Number,
941: -- ID of line table (OKL_TXL_ASSETS_B or
942: -- OKL_TXD_ASSETS_B
943: -- p_sla_source_line_table IN Varchar2,
944: -- OKL_TXL_ASSETS_B or OKL_TXD_ASSETS_B
945: -- p_sla_source_chr_id IN Number,
946: -- Contract id of the contract on which
947: -- source transaction happened
948: -- p_sla_source_kle_id IN Number,

Line 3458: p_sla_source_line_table => 'OKL_TXL_ASSETS_B',

3454: p_sla_source_header_id => l_tas_id,
3455: p_sla_source_header_table => 'OKL_TRX_ASSETS',
3456: p_sla_source_try_id => l_try_id,
3457: p_sla_source_line_id => l_talv_rec.id,
3458: p_sla_source_line_table => 'OKL_TXL_ASSETS_B',
3459: p_sla_source_chr_id => p_chrv_id,
3460: p_sla_source_kle_id => p_fin_ast_line_id,
3461: p_sla_asset_chr_id => p_sla_asset_chr_id,
3462: --Bug# 6373605--SLA populate sources

Line 3826: p_sla_source_line_table => 'OKL_TXL_ASSETS_B',

3822: p_sla_source_try_id => l_try_id,
3823: --as no transaction exists for Multi-Gaap book using the parent
3824: --corporate book transaction as source
3825: p_sla_source_line_id => l_talv_rec.id,
3826: p_sla_source_line_table => 'OKL_TXL_ASSETS_B',
3827: p_sla_source_chr_id => p_chrv_id,
3828: p_sla_source_kle_id => p_fin_ast_line_id,
3829: p_sla_asset_chr_id => p_sla_asset_chr_id,
3830: --Bug# 6373605--SLA populate sources

Line 3939: p_sla_source_line_table => 'OKL_TXL_ASSETS_B',

3935: p_sla_source_header_id => l_tas_id,
3936: p_sla_source_header_table => 'OKL_TRX_ASSETS',
3937: p_sla_source_try_id => l_try_id,
3938: p_sla_source_line_id => l_talv_rec.id,
3939: p_sla_source_line_table => 'OKL_TXL_ASSETS_B',
3940: p_sla_source_chr_id => p_chrv_id,
3941: p_sla_source_kle_id => p_fin_ast_line_id,
3942: p_sla_asset_chr_id => p_sla_asset_chr_id,
3943: --Bug# 6373605--SLA populate sources

Line 3994: 'OKL_TXL_ASSETS_B';

3990: Fetch l_txd_for_book_csr into
3991: l_txd_for_book_rec;
3992: If l_txd_for_book_csr%NOTFOUND then
3993: l_sla_source_line_table :=
3994: 'OKL_TXL_ASSETS_B';
3995: l_sla_source_line_id := l_talv_rec.id;
3996: Else
3997: l_sla_source_line_table :=
3998: 'OKL_TXD_ASSETS_B';

Line 4150: p_sla_source_line_table => 'OKL_TXL_ASSETS_B',

4146: p_sla_source_header_id => l_tas_id,
4147: p_sla_source_header_table => 'OKL_TRX_ASSETS',
4148: p_sla_source_try_id => l_try_id,
4149: p_sla_source_line_id => l_talv_rec.id,
4150: p_sla_source_line_table => 'OKL_TXL_ASSETS_B',
4151: p_sla_source_chr_id => p_chrv_id,
4152: p_sla_source_kle_id => p_fin_ast_line_id,
4153: p_sla_asset_chr_id => p_sla_asset_chr_id,
4154: --Bug# 6373605--SLA populate sources

Line 4219: p_sla_source_line_table => 'OKL_TXL_ASSETS_B',

4215: p_sla_source_header_id => l_tas_id,
4216: p_sla_source_header_table => 'OKL_TRX_ASSETS',
4217: p_sla_source_try_id => l_try_id,
4218: p_sla_source_line_id => l_talv_rec.id,
4219: p_sla_source_line_table => 'OKL_TXL_ASSETS_B',
4220: p_sla_source_chr_id => p_chrv_id,
4221: p_sla_source_kle_id => p_fin_ast_line_id,
4222: p_sla_asset_chr_id => p_sla_asset_chr_id,
4223: --Bug# 6373605--SLA populate sources

Line 4272: 'OKL_TXL_ASSETS_B';

4268: Fetch l_txd_for_book_csr into
4269: l_txd_for_book_rec;
4270: If l_txd_for_book_csr%NOTFOUND then
4271: l_sla_source_line_table :=
4272: 'OKL_TXL_ASSETS_B';
4273: l_sla_source_line_id := l_talv_rec.id;
4274: Else
4275: l_sla_source_line_table :=
4276: 'OKL_TXD_ASSETS_B';

Line 4362: 'OKL_TXL_ASSETS_B';

4358: Fetch l_txd_for_book_csr into
4359: l_txd_for_book_rec;
4360: If l_txd_for_book_csr%NOTFOUND then
4361: l_sla_source_line_table :=
4362: 'OKL_TXL_ASSETS_B';
4363: l_sla_source_line_id := l_talv_rec.id;
4364: Else
4365: l_sla_source_line_table :=
4366: 'OKL_TXD_ASSETS_B';

Line 5113: 'OKL_TXL_ASSETS_B' sla_source_line_table,

5109: txl.description description,
5110: --Bug# 6373605 start
5111: txl.id sla_source_line_id,
5112: txl.tas_id sla_source_header_id,
5113: 'OKL_TXL_ASSETS_B' sla_source_line_table,
5114: tas.try_id sla_source_try_id,
5115: --Bug# 6373605 end
5116:
5117: --sechawla : Bug# 8370324

Line 5179: OKL_TXL_ASSETS_B txl,

5175: cle.start_date line_start_date,
5176: --Bug# 8652738
5177: NULL asset_key_id
5178: FROM OKL_TXD_ASSETS_B txd,
5179: OKL_TXL_ASSETS_B txl,
5180: --Bug# 6373605 start
5181: OKL_TRX_ASSETS tas,
5182: --Bug# 6373605 end
5183: OKC_K_LINES_B cle,

Line 6350: 'OKL_TXL_ASSETS_B' sla_source_line_table,

6346: txl.id tal_id,
6347: --Bug# 6373605 start
6348: txl.id sla_source_line_id,
6349: txl.tas_id sla_source_header_id,
6350: 'OKL_TXL_ASSETS_B' sla_source_line_table,
6351: tas.try_id sla_source_try_id,
6352: cle.cle_id sla_source_kle_id,
6353: --Bug# 6373605 end
6354: --sechawla : Bug# 8370324

Line 6356: FROM OKL_TXL_ASSETS_B txl,

6352: cle.cle_id sla_source_kle_id,
6353: --Bug# 6373605 end
6354: --sechawla : Bug# 8370324
6355: cle.start_date line_start_date
6356: FROM OKL_TXL_ASSETS_B txl,
6357: --Bug# 6373605 start
6358: OKL_TRX_ASSETS tas,
6359: --Bug# 6373605 end
6360: OKC_K_LINES_B cle,

Line 6408: OKL_TXL_ASSETS_B txl,

6404: --Bug# 6373605 end
6405: --sechawla : Bug# 8370324
6406: cle.start_date line_start_date
6407: FROM OKL_TXD_ASSETS_B txd,
6408: OKL_TXL_ASSETS_B txl,
6409: --Bug# 6373605 start
6410: OKL_TRX_ASSETS tas,
6411: --Bug# 6373605 end
6412: OKC_K_LINES_B cle,

Line 7190: 'OKL_TXL_ASSETS_B' sla_source_line_table,

7186: txl.percent_salvage_value corp_pct_salvage_value,
7187: --Bug# 6373605 start
7188: trx.id sla_source_header_id,
7189: txl.id sla_source_line_id,
7190: 'OKL_TXL_ASSETS_B' sla_source_line_table,
7191: trx.try_id sla_source_try_id,
7192: cle.cle_id sla_source_kle_id
7193: --Bug# 6373605 end
7194: FROM OKL_TRX_TYPES_TL ttyp,

Line 7196: OKL_TXL_ASSETS_B txl,

7192: cle.cle_id sla_source_kle_id
7193: --Bug# 6373605 end
7194: FROM OKL_TRX_TYPES_TL ttyp,
7195: OKL_TRX_ASSETS trx,
7196: OKL_TXL_ASSETS_B txl,
7197: OKC_K_LINES_B cle,
7198: OKC_LINE_STYLES_B lse,
7199: -- Bug# 3631094
7200: FA_BOOK_CONTROLS fab

Line 7276: OKL_TXL_ASSETS_B txl,

7272: --Bug# 6373605 end
7273: FROM OKL_TRX_TYPES_TL ttyp,
7274: OKL_TRX_ASSETS trx,
7275: OKL_TXD_ASSETS_B txd,
7276: OKL_TXL_ASSETS_B txl,
7277: OKC_K_LINES_B cle,
7278: OKC_LINE_STYLES_B lse,
7279: -- Bug# 3631094
7280: FA_BOOK_CONTROLS fab

Line 7415: okl_txl_assets_b txl,

7411: --Bug# 6373605 end
7412: okc_k_items fa_cim,
7413: okl_trx_types_tl ttyp,
7414: okl_trx_assets trx,
7415: okl_txl_assets_b txl,
7416: okc_k_lines_b fa_cleb,
7417: okc_line_styles_b fa_lseb,
7418: okc_k_lines_tl ast_clet
7419: where

Line 7479: OKL_TXL_ASSETS_B txl,

7475: --Cursor to set transaction status to Processed
7476: CURSOR tas_csr(p_chr_id in number) IS
7477: SELECT trx.id
7478: FROM OKL_TRX_ASSETS trx,
7479: OKL_TXL_ASSETS_B txl,
7480: OKC_K_LINES_B cle,
7481: OKC_LINE_STYLES_B lse
7482: WHERE txl.kle_id = cle.id
7483: AND cle.dnz_chr_id = p_chr_id

Line 8888: 'OKL_TXL_ASSETS_B';

8884: If l_asset_rec.book_class = 'CORPORATE' then
8885: l_sla_source_line_id :=
8886: l_asset_rec.sla_source_line_id;
8887: l_sla_source_line_table :=
8888: 'OKL_TXL_ASSETS_B';
8889: Elsif l_asset_rec.book_class = 'TAX' then
8890: Open l_txd_from_book_type_csr(p_book_type_code =>
8891: l_asset_rec.book_type_code,
8892: p_tal_id =>

Line 8900: 'OKL_TXL_ASSETS_B';

8896: If l_txd_from_book_type_csr%NOTFOUND then
8897: l_sla_source_line_id :=
8898: l_asset_rec.sla_source_line_id;
8899: l_sla_source_line_table :=
8900: 'OKL_TXL_ASSETS_B';
8901: Else
8902: l_sla_source_line_id :=
8903: l_txd_from_book_type_rec.sla_source_line_id;
8904: l_sla_source_line_table :=

Line 9047: okl_txl_assets_b txl,

9043: txl.id tal_id,
9044: trx.creation_date
9045: from okl_trx_types_tl ttyt,
9046: okl_trx_assets trx,
9047: okl_txl_assets_b txl,
9048: okc_k_lines_b cleb,
9049: okc_line_styles_b lseb
9050: where ttyt.id = trx.try_id
9051: and ttyt.language = 'US'

Line 9160: from okl_txl_Assets_b txl,

9156: fcbd.prorate_convention_code,
9157: txl.depreciation_cost,
9158: txl.depreciation_id,
9159: txl.kle_id
9160: from okl_txl_Assets_b txl,
9161: fa_book_controls fbc,
9162: fa_category_book_defaults fcbd
9163: where fcbd.category_id = txl.depreciation_id
9164: and fcbd.book_type_code = txl.corporate_book

Line 9186: from okl_txl_Assets_b txl,

9182: fcbd.prorate_convention_code,
9183: txl.depreciation_cost,
9184: txl.depreciation_id,
9185: txl.kle_id
9186: from okl_txl_Assets_b txl,
9187: fa_book_controls fbc,
9188: fa_category_book_defaults fcbd,
9189: fa_additions fa
9190: where fcbd.category_id = fa.asset_category_id

Line 10853: okl_txl_assets_b txl,

10849: txl.id tal_id,
10850: trx.creation_date
10851: from okl_trx_types_tl ttyt,
10852: okl_trx_assets trx,
10853: okl_txl_assets_b txl,
10854: okc_k_lines_b cleb,
10855: okc_line_styles_b lseb
10856: where ttyt.id = trx.try_id
10857: and ttyt.language = 'US'

Line 11044: -- Update Depreciation_Cost in Okl_Txl_Assets_B to

11040: If (l_curr_trx_rec.transaction_type) = 'Internal Asset Creation' then
11041: --1. Online rebook new asset addition
11042: If (l_curr_trx_rec.tas_type = 'CFA') and (l_curr_trx_rec.tal_type = 'CFA') then
11043:
11044: -- Update Depreciation_Cost in Okl_Txl_Assets_B to
11045: -- the calculated Line Capital Amount
11046: l_talv_rec.id := l_curr_trx_rec.tal_id;
11047: l_talv_rec.depreciation_cost := l_capital_amount;
11048:

Line 11096: -- Update Depreciation_Cost in Okl_Txl_Assets_B to

11092: -- Do not recalculate asset cost for DF/ST Lease and Loan
11093: NULL;
11094:
11095: ElsIf l_deal_type = 'LEASEOP' Then
11096: -- Update Depreciation_Cost in Okl_Txl_Assets_B to
11097: -- the calculated Line Capital Amount
11098: l_talv_rec.id := l_curr_trx_rec.tal_id;
11099: l_talv_rec.depreciation_cost := l_capital_amount;
11100: