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_TRX_ASSETS

Line 348: and exists (select '1' from OKL_TRX_ASSETS

344: CURRENCY_CONVERSION_DATE
345: FROM Okl_Txl_Assets_V
346: WHERE okl_txl_assets_v.kle_id = p_kle_id
347: and okl_txl_assets_v.tal_type = p_trx_type
348: and exists (select '1' from OKL_TRX_ASSETS
349: where OKL_TRX_ASSETS.TAS_TYPE = p_trx_type
350: and OKL_TRX_ASSETS.TSU_CODE = G_TSU_CODE_ENTERED
351: and OKL_TRX_ASSETS.ID = Okl_txl_assets_v.tas_id);
352: l_talv_rec talv_rec_type;

Line 349: where OKL_TRX_ASSETS.TAS_TYPE = p_trx_type

345: FROM Okl_Txl_Assets_V
346: WHERE okl_txl_assets_v.kle_id = p_kle_id
347: and okl_txl_assets_v.tal_type = p_trx_type
348: and exists (select '1' from OKL_TRX_ASSETS
349: where OKL_TRX_ASSETS.TAS_TYPE = p_trx_type
350: and OKL_TRX_ASSETS.TSU_CODE = G_TSU_CODE_ENTERED
351: and OKL_TRX_ASSETS.ID = Okl_txl_assets_v.tas_id);
352: l_talv_rec talv_rec_type;
353: BEGIN

Line 350: and OKL_TRX_ASSETS.TSU_CODE = G_TSU_CODE_ENTERED

346: WHERE okl_txl_assets_v.kle_id = p_kle_id
347: and okl_txl_assets_v.tal_type = p_trx_type
348: and exists (select '1' from OKL_TRX_ASSETS
349: where OKL_TRX_ASSETS.TAS_TYPE = p_trx_type
350: and OKL_TRX_ASSETS.TSU_CODE = G_TSU_CODE_ENTERED
351: and OKL_TRX_ASSETS.ID = Okl_txl_assets_v.tas_id);
352: l_talv_rec talv_rec_type;
353: BEGIN
354: x_no_data_found := TRUE;

Line 351: and OKL_TRX_ASSETS.ID = Okl_txl_assets_v.tas_id);

347: and okl_txl_assets_v.tal_type = p_trx_type
348: and exists (select '1' from OKL_TRX_ASSETS
349: where OKL_TRX_ASSETS.TAS_TYPE = p_trx_type
350: and OKL_TRX_ASSETS.TSU_CODE = G_TSU_CODE_ENTERED
351: and OKL_TRX_ASSETS.ID = Okl_txl_assets_v.tas_id);
352: l_talv_rec talv_rec_type;
353: BEGIN
354: x_no_data_found := TRUE;
355: -- Get current database values

Line 582: l_thpv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;

578: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
579: l_api_name CONSTANT VARCHAR2(30) := 'update_trx_status';
580: l_api_version CONSTANT NUMBER := 1.0;
581:
582: l_thpv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;
583: l_thpv_rec_out OKL_TRX_ASSETS_PUB.thpv_rec_type;
584: --cursor to check existing tsu code
585: CURSOR tsu_code_csr (p_tas_id IN NUMBER) is
586: SELECT tsu_code

Line 583: l_thpv_rec_out OKL_TRX_ASSETS_PUB.thpv_rec_type;

579: l_api_name CONSTANT VARCHAR2(30) := 'update_trx_status';
580: l_api_version CONSTANT NUMBER := 1.0;
581:
582: l_thpv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;
583: l_thpv_rec_out OKL_TRX_ASSETS_PUB.thpv_rec_type;
584: --cursor to check existing tsu code
585: CURSOR tsu_code_csr (p_tas_id IN NUMBER) is
586: SELECT tsu_code
587: FROM OKL_TRX_ASSETS

Line 587: FROM OKL_TRX_ASSETS

583: l_thpv_rec_out OKL_TRX_ASSETS_PUB.thpv_rec_type;
584: --cursor to check existing tsu code
585: CURSOR tsu_code_csr (p_tas_id IN NUMBER) is
586: SELECT tsu_code
587: FROM OKL_TRX_ASSETS
588: WHERE id = p_tas_id;
589:
590: l_tsu_code OKL_TRX_ASSETS.TSU_CODE%TYPE;
591: BEGIN

Line 590: l_tsu_code OKL_TRX_ASSETS.TSU_CODE%TYPE;

586: SELECT tsu_code
587: FROM OKL_TRX_ASSETS
588: WHERE id = p_tas_id;
589:
590: l_tsu_code OKL_TRX_ASSETS.TSU_CODE%TYPE;
591: BEGIN
592: --call start activity to set savepoint
593: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
594: p_init_msg_list,

Line 623: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(

619: Raise OKL_API.G_EXCEPTION_ERROR;
620: Else
621: l_thpv_rec.id := p_tas_id;
622: l_thpv_rec.tsu_code := p_tsu_code;
623: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(
624: p_api_version => p_api_version,
625: p_init_msg_list => p_init_msg_list,
626: x_return_status => x_return_status,
627: x_msg_count => x_msg_count,

Line 931: -- ID of source OKL_TRX_ASSETS record

927: -- p_adj_salvage_value - salvage value to be adjusted
928: --
929: -- Bug# 6373605 (OKL.R12.B SLA CRs
930: -- p_sla_source_header_id IN Number,
931: -- ID of source OKL_TRX_ASSETS record
932: -- p_sla_source_header_table IN Varchar2,
933: -- 'OKL_TRX_ASSETS'
934: -- p_sla_source_try_id IN Number,
935: -- OKL_TRX_ASSETS.try_id (transaction type id)

Line 933: -- 'OKL_TRX_ASSETS'

929: -- Bug# 6373605 (OKL.R12.B SLA CRs
930: -- p_sla_source_header_id IN Number,
931: -- ID of source OKL_TRX_ASSETS record
932: -- p_sla_source_header_table IN Varchar2,
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

Line 935: -- OKL_TRX_ASSETS.try_id (transaction type id)

931: -- ID of source OKL_TRX_ASSETS record
932: -- p_sla_source_header_table IN Varchar2,
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,

Line 3209: --cursor to fetch transaction number from okl_trx_assets

3205: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
3206: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
3207:
3208: --Bug# 3156924 :
3209: --cursor to fetch transaction number from okl_trx_assets
3210: cursor l_tas_csr(p_tas_id in number) is
3211: select to_char(trans_number),
3212: DATE_TRANS_OCCURRED,
3213: --Bug# 6373605 start

Line 3217: from okl_trx_assets

3213: --Bug# 6373605 start
3214: id tas_id,
3215: try_id
3216: --Bug# 6373605 end
3217: from okl_trx_assets
3218: where id = p_tas_id;
3219:
3220: l_trans_number okl_trx_contracts.trx_number%TYPE := p_trans_number;
3221: l_trans_date okl_trx_assets.date_trans_occurred%TYPE;

Line 3221: l_trans_date okl_trx_assets.date_trans_occurred%TYPE;

3217: from okl_trx_assets
3218: where id = p_tas_id;
3219:
3220: l_trans_number okl_trx_contracts.trx_number%TYPE := p_trans_number;
3221: l_trans_date okl_trx_assets.date_trans_occurred%TYPE;
3222: l_calling_interface varchar2(30) := p_calling_interface;
3223: --Bug# 3156924
3224: --Bug# 6373605 start
3225: l_tas_id okl_trx_assets.id%TYPE;

Line 3225: l_tas_id okl_trx_assets.id%TYPE;

3221: l_trans_date okl_trx_assets.date_trans_occurred%TYPE;
3222: l_calling_interface varchar2(30) := p_calling_interface;
3223: --Bug# 3156924
3224: --Bug# 6373605 start
3225: l_tas_id okl_trx_assets.id%TYPE;
3226: l_try_id okl_trx_assets.try_id%TYPE;
3227: --Bug# 6373605 end
3228:
3229: --Bug# 4028371

Line 3226: l_try_id okl_trx_assets.try_id%TYPE;

3222: l_calling_interface varchar2(30) := p_calling_interface;
3223: --Bug# 3156924
3224: --Bug# 6373605 start
3225: l_tas_id okl_trx_assets.id%TYPE;
3226: l_try_id okl_trx_assets.try_id%TYPE;
3227: --Bug# 6373605 end
3228:
3229: --Bug# 4028371
3230: l_fa_add_date_corp date;

Line 3446: p_sla_source_header_table => 'OKL_TRX_ASSETS',

3442: --Bug# 5261704
3443: p_depreciate_flag => l_depreciate_flag,
3444: --Bug# 6373605--SLA populate source
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,

Line 3609: p_sla_source_header_table => 'OKL_TRX_ASSETS',

3605: --Bug# 5261704
3606: p_depreciate_flag => l_depreciate_flag,
3607: --Bug# 6373605--SLA populate source
3608: p_sla_source_header_id => l_tas_id,
3609: p_sla_source_header_table => 'OKL_TRX_ASSETS',
3610: p_sla_source_try_id => l_try_id,
3611: p_sla_source_line_id => okl_tadv_rec.asd_id,
3612: p_sla_source_line_table => 'OKL_TXD_ASSETS_B',
3613: p_sla_source_chr_id => p_chrv_id,

Line 3812: p_sla_source_header_table => 'OKL_TRX_ASSETS',

3808: --Bug# :5261704
3809: p_depreciate_flag => l_depreciate_flag,
3810: --Bug# 6373605--SLA populate source
3811: p_sla_source_header_id => l_tas_id,
3812: p_sla_source_header_table => 'OKL_TRX_ASSETS',
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,

Line 3927: p_sla_source_header_table => 'OKL_TRX_ASSETS',

3923: --Bug# 3156924
3924: p_adj_date => l_talv_rec.in_service_date,
3925: --Bug# 6373605--SLA populate source
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,

Line 4019: p_sla_source_header_table => 'OKL_TRX_ASSETS',

4015: -- Bug Fix# 2925461
4016: p_adj_date => l_talv_rec.in_service_date,
4017: --Bug# 6373605--SLA populate source
4018: p_sla_source_header_id => l_tas_id,
4019: p_sla_source_header_table => 'OKL_TRX_ASSETS',
4020: p_sla_source_try_id => l_try_id,
4021: p_sla_source_line_id => l_sla_source_line_id,
4022: p_sla_source_line_table => l_sla_source_line_table,
4023: p_sla_source_chr_id => p_chrv_id,

Line 4138: p_sla_source_header_table => 'OKL_TRX_ASSETS',

4134: -- Bug Fix# 2925461
4135: p_adj_date => l_talv_rec.in_service_date,
4136: --Bug# 6373605--SLA populate source
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,

Line 4207: p_sla_source_header_table => 'OKL_TRX_ASSETS',

4203: -- Bug Fix# 2925461
4204: p_adj_date => l_talv_rec.in_service_date,
4205: --Bug# 6373605--SLA populate source
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,

Line 4297: p_sla_source_header_table => 'OKL_TRX_ASSETS',

4293: -- Bug Fix# 2925461
4294: p_adj_date => l_talv_rec.in_service_date,
4295: --Bug# 6373605--SLA populate source
4296: p_sla_source_header_id => l_tas_id,
4297: p_sla_source_header_table => 'OKL_TRX_ASSETS',
4298: p_sla_source_try_id => l_try_id,
4299: p_sla_source_line_id => l_sla_source_line_id,
4300: p_sla_source_line_table => l_sla_source_line_table,
4301: p_sla_source_chr_id => p_chrv_id,

Line 4383: p_sla_source_header_table => 'OKL_TRX_ASSETS',

4379: x_fa_trx_date => l_fa_adj_date_mg,
4380: p_adj_date => okx_ast_rec.in_service_date,
4381: --Bug# 6373605--SLA populate source
4382: p_sla_source_header_id => l_tas_id,
4383: p_sla_source_header_table => 'OKL_TRX_ASSETS',
4384: p_sla_source_try_id => l_try_id,
4385: p_sla_source_line_id => l_sla_source_line_id,
4386: p_sla_source_line_table => l_sla_source_line_table,
4387: p_sla_source_chr_id => p_chrv_id,

Line 4675: l_trans_number okl_trx_assets.trans_number%TYPE := Null;

4671: l_town_rul okc_rules_b.rule_information1%TYPE;
4672: l_town_rul_id okc_rules_b.id%TYPE;
4673:
4674: --Bug# 3156924
4675: l_trans_number okl_trx_assets.trans_number%TYPE := Null;
4676: l_calling_interface varchar2(30) := 'OKLRACAB:Booking';
4677:
4678: --Bug# 3574232
4679: l_adjust_asset_to_zero varchar2(30);

Line 5147: OKL_TRX_ASSETS tas,

5143: --Bug# 6373605 end
5144: FROM OKL_TXL_ASSETS_V txl,
5145: --akrangan bug# 5362977 end
5146: --Bug# 6373605 start
5147: OKL_TRX_ASSETS tas,
5148: --Bug# 6373605 end
5149: OKC_K_LINES_B cle,
5150: OKC_LINE_STYLES_B lse
5151: WHERE txl.kle_id = cle.id

Line 5206: OKL_TRX_ASSETS tas,

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,
5209: OKC_LINE_STYLES_B lse
5210: WHERE txd.tal_id = txl.id

Line 5967: p_sla_source_header_table => 'OKL_TRX_ASSETS',

5963: p_trans_number => l_trx_number,
5964: p_calling_interface => l_calling_interface,
5965: --Bug# 6373605--SLA populate source
5966: p_sla_source_header_id => adj_txl_rec.sla_source_header_id,
5967: p_sla_source_header_table => 'OKL_TRX_ASSETS',
5968: p_sla_source_try_id => adj_txl_rec.sla_source_try_id,
5969: p_sla_source_line_id => adj_txl_rec.sla_source_line_id,
5970: p_sla_source_line_table => adj_txl_rec.sla_source_line_table,
5971: p_sla_source_chr_id => p_rbk_chr_id,

Line 6033: p_sla_source_header_table => 'OKL_TRX_ASSETS',

6029: p_trx_number => l_trx_number,
6030: p_calling_interface => l_calling_interface,
6031: --Bug# 6373605--SLA populate source
6032: p_sla_source_header_id => adj_txl_rec.sla_source_header_id,
6033: p_sla_source_header_table => 'OKL_TRX_ASSETS',
6034: p_sla_source_try_id => adj_txl_rec.sla_source_try_id,
6035: p_sla_source_line_id => adj_txl_rec.sla_source_line_id,
6036: p_sla_source_line_table => adj_txl_rec.sla_source_line_table,
6037: p_sla_source_chr_id => p_rbk_chr_id,

Line 6422: OKL_TRX_ASSETS tas,

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,
6425: OKC_LINE_STYLES_B lse
6426: WHERE txl.kle_id = cle.id

Line 6447: from OKL_TRX_ASSETS TRX

6443: And sts.ste_code in ('HOLD','EXPIRED','TERMINATED','CANCELLED')
6444: )
6445: AND lse.lty_code = G_FA_LINE_LTY_CODE
6446: AND exists (select '1'
6447: from OKL_TRX_ASSETS TRX
6448: Where TRX.ID = Txl.tas_id
6449: And TRX.tas_type = 'CRB'
6450: And TRX.tsu_code = 'ENTERED')
6451: UNION

Line 6477: OKL_TRX_ASSETS tas,

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,
6480: OKC_LINE_STYLES_B lse
6481: WHERE txd.tal_id = txl.id

Line 6502: from OKL_TRX_ASSETS TRX

6498: And sts.ste_code in ('HOLD','EXPIRED','TERMINATED','CANCELLED')
6499: )
6500: AND lse.lty_code = G_FA_LINE_LTY_CODE
6501: AND exists (select '1'
6502: from OKL_TRX_ASSETS TRX
6503: Where TRX.ID = Txl.tas_id
6504: And TRX.tas_type = 'CRB'
6505: And TRX.tsu_code = 'ENTERED');
6506:

Line 6883: p_sla_source_header_table => 'OKL_TRX_ASSETS',

6879: p_trans_number => l_trans_number,
6880: p_calling_interface => l_calling_interface,
6881: --Bug# 6373605--SLA populate source
6882: p_sla_source_header_id => adj_txl_rec.sla_source_header_id,
6883: p_sla_source_header_table => 'OKL_TRX_ASSETS',
6884: p_sla_source_try_id => adj_txl_rec.sla_source_try_id,
6885: p_sla_source_line_id => adj_txl_rec.sla_source_line_id,
6886: p_sla_source_line_table => adj_txl_rec.sla_source_line_table,
6887: p_sla_source_chr_id => p_rbk_chr_id,

Line 7194: p_sla_source_header_table => 'OKL_TRX_ASSETS',

7190: p_trans_number => l_trans_number,
7191: p_calling_interface => l_calling_interface,
7192: --Bug# 6373605--SLA populate source
7193: p_sla_source_header_id => adj_txl_rec.sla_source_header_id,
7194: p_sla_source_header_table => 'OKL_TRX_ASSETS',
7195: p_sla_source_try_id => adj_txl_rec.sla_source_try_id,
7196: p_sla_source_line_id => adj_txl_rec.sla_source_line_id,
7197: p_sla_source_line_table => adj_txl_rec.sla_source_line_table,
7198: p_sla_source_chr_id => p_rbk_chr_id,

Line 7470: OKL_TRX_ASSETS trx,

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,
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

Line 7493: --from OKL_TRX_ASSETS trx,

7489: AND lse.lty_code = G_FA_LINE_LTY_CODE
7490: --Bug# 3156924:
7491: /*----------------------------------------------------
7492: --AND exists (select null
7493: --from OKL_TRX_ASSETS trx,
7494: --OKL_TRX_TYPES_TL ttyp
7495: --where trx.id = txl.tas_id
7496: --and trx.try_id = ttyp.id
7497: --and ttyp.name = 'Internal Asset Creation'

Line 7549: OKL_TRX_ASSETS trx,

7545: trx.try_id sla_source_try_id,
7546: cle.cle_id sla_source_kle_id
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,

Line 7574: --from OKL_TRX_ASSETS trx,

7570: AND lse.lty_code = G_FA_LINE_LTY_CODE
7571: --bug# 3156924
7572: /*-------------------------------------------------------------
7573: --AND exists (select null
7574: --from OKL_TRX_ASSETS trx,
7575: --OKL_TRX_TYPES_TL ttyp
7576: --where trx.id = txl.tas_id
7577: --and trx.try_id = ttyp.id
7578: --and ttyp.name = 'Release'

Line 7689: okl_trx_assets trx,

7685: fa_book_controls fbc,
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

Line 7741: l_trans_number okl_trx_assets.trans_number%TYPE;

7737: --Bug# 6373605 End
7738:
7739: --Bug# 3156924
7740: l_release_date date;
7741: l_trans_number okl_trx_assets.trans_number%TYPE;
7742: l_calling_interface varchar2(30) := 'OKLRACAB:Release';
7743:
7744: --BUG# 3548044
7745: l_release_allowed_on_mg_book varchar2(1);

Line 7753: FROM OKL_TRX_ASSETS trx,

7749: ---------------------------------------------------
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

Line 8225: p_sla_source_header_table => 'OKL_TRX_ASSETS',

8221: --Bug# 5261704
8222: p_depreciate_flag => l_depreciate_flag,
8223: --Bug# 6373605--SLA populate source
8224: p_sla_source_header_id => adj_txl_rec.sla_source_header_id,
8225: p_sla_source_header_table => 'OKL_TRX_ASSETS',
8226: p_sla_source_try_id => adj_txl_rec.sla_source_try_id,
8227: p_sla_source_line_id => adj_txl_rec.sla_source_line_id,
8228: p_sla_source_line_table => adj_txl_rec.sla_source_line_table,
8229: p_sla_source_chr_id => p_rel_chr_id,

Line 8275: p_sla_source_header_table => 'OKL_TRX_ASSETS',

8271: p_calling_interface => l_calling_interface,
8272: p_adj_date => l_release_date,
8273: --Bug# 6373605--SLA populate source
8274: p_sla_source_header_id => adj_txl_rec.sla_source_header_id,
8275: p_sla_source_header_table => 'OKL_TRX_ASSETS',
8276: p_sla_source_try_id => adj_txl_rec.sla_source_try_id,
8277: p_sla_source_line_id => adj_txl_rec.sla_source_line_id,
8278: p_sla_source_line_table => adj_txl_rec.sla_source_line_table,
8279: p_sla_source_chr_id => p_rel_chr_id,

Line 8830: p_sla_source_header_table => 'OKL_TRX_ASSETS',

8826: p_calling_interface => l_calling_interface,
8827: -- Bug# 3156924
8828: --Bug# 6373605--SLA populate source
8829: p_sla_source_header_id => adj_txl_rec.sla_source_header_id,
8830: p_sla_source_header_table => 'OKL_TRX_ASSETS',
8831: p_sla_source_try_id => adj_txl_rec.sla_source_try_id,
8832: p_sla_source_line_id => adj_txl_rec.sla_source_line_id,
8833: p_sla_source_line_table => adj_txl_rec.sla_source_line_table,
8834: p_sla_source_chr_id => p_rel_chr_id,

Line 8894: p_sla_source_header_table => 'OKL_TRX_ASSETS',

8890: p_trans_number => l_trans_number,
8891: p_calling_interface => l_calling_interface,
8892: --Bug# 6373605--SLA populate source
8893: p_sla_source_header_id => adj_txl_rec.sla_source_header_id,
8894: p_sla_source_header_table => 'OKL_TRX_ASSETS',
8895: p_sla_source_try_id => adj_txl_rec.sla_source_try_id,
8896: p_sla_source_line_id => adj_txl_rec.sla_source_line_id,
8897: p_sla_source_line_table => adj_txl_rec.sla_source_line_table,
8898: p_sla_source_chr_id => p_rel_chr_id,

Line 8967: p_sla_source_header_table => 'OKL_TRX_ASSETS',

8963: p_trx_number => l_trans_number,
8964: p_calling_interface => l_calling_interface,
8965: --Bug# 6373605--SLA populate source
8966: p_sla_source_header_id => adj_txl_rec.sla_source_header_id,
8967: p_sla_source_header_table => 'OKL_TRX_ASSETS',
8968: p_sla_source_try_id => adj_txl_rec.sla_source_try_id,
8969: p_sla_source_line_id => adj_txl_rec.sla_source_line_id,
8970: p_sla_source_line_table => adj_txl_rec.sla_source_line_table,
8971: p_sla_source_chr_id => p_rel_chr_id,

Line 9203: p_sla_source_header_table => 'OKL_TRX_ASSETS',

9199: p_trans_number => l_trans_number,
9200: p_calling_interface => l_calling_interface,
9201: --Bug# 6373605--SLA populate source
9202: p_sla_source_header_id => l_asset_rec.sla_source_header_id,
9203: p_sla_source_header_table => 'OKL_TRX_ASSETS',
9204: p_sla_source_try_id => l_Asset_rec.sla_source_try_id,
9205: p_sla_source_line_id => l_sla_source_line_id,
9206: p_sla_source_line_table => l_sla_source_line_table,
9207: p_sla_source_chr_id => p_rel_chr_id,

Line 9321: okl_trx_assets trx,

9317: txl.tal_type,
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

Line 11127: okl_trx_assets trx,

11123: txl.tal_type,
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