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.

[Home] [Help]

APPS.OKL_ACTIVATE_ASSET_PVT dependencies on OKL_TXL_ASSETS_B

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

933: -- 'OKL_TRX_ASSETS'
934: -- p_sla_source_try_id IN Number,
935: -- OKL_TRX_ASSETS.try_id (transaction type id)
936: -- p_sla_source_line_id IN Number,
937: -- ID of line table (OKL_TXL_ASSETS_B or
938: -- OKL_TXD_ASSETS_B
939: -- p_sla_source_line_table IN Varchar2,
940: -- OKL_TXL_ASSETS_B or OKL_TXD_ASSETS_B
941: -- p_sla_source_chr_id IN Number,

Line 940: -- OKL_TXL_ASSETS_B or OKL_TXD_ASSETS_B

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

Line 3449: p_sla_source_line_table => 'OKL_TXL_ASSETS_B',

3445: p_sla_source_header_id => l_tas_id,
3446: p_sla_source_header_table => 'OKL_TRX_ASSETS',
3447: p_sla_source_try_id => l_try_id,
3448: p_sla_source_line_id => l_talv_rec.id,
3449: p_sla_source_line_table => 'OKL_TXL_ASSETS_B',
3450: p_sla_source_chr_id => p_chrv_id,
3451: p_sla_source_kle_id => p_fin_ast_line_id,
3452: p_sla_asset_chr_id => p_sla_asset_chr_id,
3453: --Bug# 6373605--SLA populate sources

Line 3817: p_sla_source_line_table => 'OKL_TXL_ASSETS_B',

3813: p_sla_source_try_id => l_try_id,
3814: --as no transaction exists for Multi-Gaap book using the parent
3815: --corporate book transaction as source
3816: p_sla_source_line_id => l_talv_rec.id,
3817: p_sla_source_line_table => 'OKL_TXL_ASSETS_B',
3818: p_sla_source_chr_id => p_chrv_id,
3819: p_sla_source_kle_id => p_fin_ast_line_id,
3820: p_sla_asset_chr_id => p_sla_asset_chr_id,
3821: --Bug# 6373605--SLA populate sources

Line 3930: p_sla_source_line_table => 'OKL_TXL_ASSETS_B',

3926: p_sla_source_header_id => l_tas_id,
3927: p_sla_source_header_table => 'OKL_TRX_ASSETS',
3928: p_sla_source_try_id => l_try_id,
3929: p_sla_source_line_id => l_talv_rec.id,
3930: p_sla_source_line_table => 'OKL_TXL_ASSETS_B',
3931: p_sla_source_chr_id => p_chrv_id,
3932: p_sla_source_kle_id => p_fin_ast_line_id,
3933: p_sla_asset_chr_id => p_sla_asset_chr_id,
3934: --Bug# 6373605--SLA populate sources

Line 3985: 'OKL_TXL_ASSETS_B';

3981: Fetch l_txd_for_book_csr into
3982: l_txd_for_book_rec;
3983: If l_txd_for_book_csr%NOTFOUND then
3984: l_sla_source_line_table :=
3985: 'OKL_TXL_ASSETS_B';
3986: l_sla_source_line_id := l_talv_rec.id;
3987: Else
3988: l_sla_source_line_table :=
3989: 'OKL_TXD_ASSETS_B';

Line 4141: p_sla_source_line_table => 'OKL_TXL_ASSETS_B',

4137: p_sla_source_header_id => l_tas_id,
4138: p_sla_source_header_table => 'OKL_TRX_ASSETS',
4139: p_sla_source_try_id => l_try_id,
4140: p_sla_source_line_id => l_talv_rec.id,
4141: p_sla_source_line_table => 'OKL_TXL_ASSETS_B',
4142: p_sla_source_chr_id => p_chrv_id,
4143: p_sla_source_kle_id => p_fin_ast_line_id,
4144: p_sla_asset_chr_id => p_sla_asset_chr_id,
4145: --Bug# 6373605--SLA populate sources

Line 4210: p_sla_source_line_table => 'OKL_TXL_ASSETS_B',

4206: p_sla_source_header_id => l_tas_id,
4207: p_sla_source_header_table => 'OKL_TRX_ASSETS',
4208: p_sla_source_try_id => l_try_id,
4209: p_sla_source_line_id => l_talv_rec.id,
4210: p_sla_source_line_table => 'OKL_TXL_ASSETS_B',
4211: p_sla_source_chr_id => p_chrv_id,
4212: p_sla_source_kle_id => p_fin_ast_line_id,
4213: p_sla_asset_chr_id => p_sla_asset_chr_id,
4214: --Bug# 6373605--SLA populate sources

Line 4263: 'OKL_TXL_ASSETS_B';

4259: Fetch l_txd_for_book_csr into
4260: l_txd_for_book_rec;
4261: If l_txd_for_book_csr%NOTFOUND then
4262: l_sla_source_line_table :=
4263: 'OKL_TXL_ASSETS_B';
4264: l_sla_source_line_id := l_talv_rec.id;
4265: Else
4266: l_sla_source_line_table :=
4267: 'OKL_TXD_ASSETS_B';

Line 4353: 'OKL_TXL_ASSETS_B';

4349: Fetch l_txd_for_book_csr into
4350: l_txd_for_book_rec;
4351: If l_txd_for_book_csr%NOTFOUND then
4352: l_sla_source_line_table :=
4353: 'OKL_TXL_ASSETS_B';
4354: l_sla_source_line_id := l_talv_rec.id;
4355: Else
4356: l_sla_source_line_table :=
4357: 'OKL_TXD_ASSETS_B';

Line 5141: 'OKL_TXL_ASSETS_B' sla_source_line_table,

5137: txl.description description,
5138: --Bug# 6373605 start
5139: txl.id sla_source_line_id,
5140: txl.tas_id sla_source_header_id,
5141: 'OKL_TXL_ASSETS_B' sla_source_line_table,
5142: tas.try_id sla_source_try_id
5143: --Bug# 6373605 end
5144: FROM OKL_TXL_ASSETS_V txl,
5145: --akrangan bug# 5362977 end

Line 5204: OKL_TXL_ASSETS_B txl,

5200: 'OKL_TXD_ASSETS_B' sla_source_line_table,
5201: tas.try_id sla_source_try_id
5202: --Bug# 6373605 end
5203: FROM OKL_TXD_ASSETS_B txd,
5204: OKL_TXL_ASSETS_B txl,
5205: --Bug# 6373605 start
5206: OKL_TRX_ASSETS tas,
5207: --Bug# 6373605 end
5208: OKC_K_LINES_B cle,

Line 6416: 'OKL_TXL_ASSETS_B' sla_source_line_table,

6412: txl.id tal_id,
6413: --Bug# 6373605 start
6414: txl.id sla_source_line_id,
6415: txl.tas_id sla_source_header_id,
6416: 'OKL_TXL_ASSETS_B' sla_source_line_table,
6417: tas.try_id sla_source_try_id,
6418: cle.cle_id sla_source_kle_id
6419: --Bug# 6373605 end
6420: FROM OKL_TXL_ASSETS_B txl,

Line 6420: FROM OKL_TXL_ASSETS_B txl,

6416: 'OKL_TXL_ASSETS_B' sla_source_line_table,
6417: tas.try_id sla_source_try_id,
6418: cle.cle_id sla_source_kle_id
6419: --Bug# 6373605 end
6420: FROM OKL_TXL_ASSETS_B txl,
6421: --Bug# 6373605 start
6422: OKL_TRX_ASSETS tas,
6423: --Bug# 6373605 end
6424: OKC_K_LINES_B cle,

Line 6475: OKL_TXL_ASSETS_B txl,

6471: tas.try_id sla_source_try_id,
6472: cle.cle_id sla_source_kle_id
6473: --Bug# 6373605 end
6474: FROM OKL_TXD_ASSETS_B txd,
6475: OKL_TXL_ASSETS_B txl,
6476: --Bug# 6373605 start
6477: OKL_TRX_ASSETS tas,
6478: --Bug# 6373605 end
6479: OKC_K_LINES_B cle,

Line 7465: 'OKL_TXL_ASSETS_B' sla_source_line_table,

7461: txl.percent_salvage_value corp_pct_salvage_value,
7462: --Bug# 6373605 start
7463: trx.id sla_source_header_id,
7464: txl.id sla_source_line_id,
7465: 'OKL_TXL_ASSETS_B' sla_source_line_table,
7466: trx.try_id sla_source_try_id,
7467: cle.cle_id sla_source_kle_id
7468: --Bug# 6373605 end
7469: FROM OKL_TRX_TYPES_TL ttyp,

Line 7471: OKL_TXL_ASSETS_B txl,

7467: cle.cle_id sla_source_kle_id
7468: --Bug# 6373605 end
7469: FROM OKL_TRX_TYPES_TL ttyp,
7470: OKL_TRX_ASSETS trx,
7471: OKL_TXL_ASSETS_B txl,
7472: OKC_K_LINES_B cle,
7473: OKC_LINE_STYLES_B lse,
7474: -- Bug# 3631094
7475: FA_BOOK_CONTROLS fab

Line 7551: OKL_TXL_ASSETS_B txl,

7547: --Bug# 6373605 end
7548: FROM OKL_TRX_TYPES_TL ttyp,
7549: OKL_TRX_ASSETS trx,
7550: OKL_TXD_ASSETS_B txd,
7551: OKL_TXL_ASSETS_B txl,
7552: OKC_K_LINES_B cle,
7553: OKC_LINE_STYLES_B lse,
7554: -- Bug# 3631094
7555: FA_BOOK_CONTROLS fab

Line 7690: okl_txl_assets_b txl,

7686: --Bug# 6373605 end
7687: okc_k_items fa_cim,
7688: okl_trx_types_tl ttyp,
7689: okl_trx_assets trx,
7690: okl_txl_assets_b txl,
7691: okc_k_lines_b fa_cleb,
7692: okc_line_styles_b fa_lseb,
7693: okc_k_lines_tl ast_clet
7694: where

Line 7754: OKL_TXL_ASSETS_B txl,

7750: --Cursor to set transaction status to Processed
7751: CURSOR tas_csr(p_chr_id in number) IS
7752: SELECT trx.id
7753: FROM OKL_TRX_ASSETS trx,
7754: OKL_TXL_ASSETS_B txl,
7755: OKC_K_LINES_B cle,
7756: OKC_LINE_STYLES_B lse
7757: WHERE txl.kle_id = cle.id
7758: AND cle.dnz_chr_id = p_chr_id

Line 9163: 'OKL_TXL_ASSETS_B';

9159: If l_asset_rec.book_class = 'CORPORATE' then
9160: l_sla_source_line_id :=
9161: l_asset_rec.sla_source_line_id;
9162: l_sla_source_line_table :=
9163: 'OKL_TXL_ASSETS_B';
9164: Elsif l_asset_rec.book_class = 'TAX' then
9165: Open l_txd_from_book_type_csr(p_book_type_code =>
9166: l_asset_rec.book_type_code,
9167: p_tal_id =>

Line 9175: 'OKL_TXL_ASSETS_B';

9171: If l_txd_from_book_type_csr%NOTFOUND then
9172: l_sla_source_line_id :=
9173: l_asset_rec.sla_source_line_id;
9174: l_sla_source_line_table :=
9175: 'OKL_TXL_ASSETS_B';
9176: Else
9177: l_sla_source_line_id :=
9178: l_txd_from_book_type_rec.sla_source_line_id;
9179: l_sla_source_line_table :=

Line 9322: okl_txl_assets_b txl,

9318: txl.id tal_id,
9319: trx.creation_date
9320: from okl_trx_types_tl ttyt,
9321: okl_trx_assets trx,
9322: okl_txl_assets_b txl,
9323: okc_k_lines_b cleb,
9324: okc_line_styles_b lseb
9325: where ttyt.id = trx.try_id
9326: and ttyt.language = 'US'

Line 9435: from okl_txl_Assets_b txl,

9431: fcbd.prorate_convention_code,
9432: txl.depreciation_cost,
9433: txl.depreciation_id,
9434: txl.kle_id
9435: from okl_txl_Assets_b txl,
9436: fa_book_controls fbc,
9437: fa_category_book_defaults fcbd
9438: where fcbd.category_id = txl.depreciation_id
9439: and fcbd.book_type_code = txl.corporate_book

Line 9461: from okl_txl_Assets_b txl,

9457: fcbd.prorate_convention_code,
9458: txl.depreciation_cost,
9459: txl.depreciation_id,
9460: txl.kle_id
9461: from okl_txl_Assets_b txl,
9462: fa_book_controls fbc,
9463: fa_category_book_defaults fcbd,
9464: fa_additions fa
9465: where fcbd.category_id = fa.asset_category_id

Line 11128: okl_txl_assets_b txl,

11124: txl.id tal_id,
11125: trx.creation_date
11126: from okl_trx_types_tl ttyt,
11127: okl_trx_assets trx,
11128: okl_txl_assets_b txl,
11129: okc_k_lines_b cleb,
11130: okc_line_styles_b lseb
11131: where ttyt.id = trx.try_id
11132: and ttyt.language = 'US'

Line 11319: -- Update Depreciation_Cost in Okl_Txl_Assets_B to

11315: If (l_curr_trx_rec.transaction_type) = 'Internal Asset Creation' then
11316: --1. Online rebook new asset addition
11317: If (l_curr_trx_rec.tas_type = 'CFA') and (l_curr_trx_rec.tal_type = 'CFA') then
11318:
11319: -- Update Depreciation_Cost in Okl_Txl_Assets_B to
11320: -- the calculated Line Capital Amount
11321: l_talv_rec.id := l_curr_trx_rec.tal_id;
11322: l_talv_rec.depreciation_cost := l_capital_amount;
11323:

Line 11371: -- Update Depreciation_Cost in Okl_Txl_Assets_B to

11367: -- Do not recalculate asset cost for DF/ST Lease and Loan
11368: NULL;
11369:
11370: ElsIf l_deal_type = 'LEASEOP' Then
11371: -- Update Depreciation_Cost in Okl_Txl_Assets_B to
11372: -- the calculated Line Capital Amount
11373: l_talv_rec.id := l_curr_trx_rec.tal_id;
11374: l_talv_rec.depreciation_cost := l_capital_amount;
11375: