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 935: -- ID of source OKL_TRX_ASSETS record

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

Line 937: -- 'OKL_TRX_ASSETS'

933: -- Bug# 6373605 (OKL.R12.B SLA CRs
934: -- p_sla_source_header_id IN Number,
935: -- ID of source OKL_TRX_ASSETS record
936: -- p_sla_source_header_table IN Varchar2,
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

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

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

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

3214: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
3215: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
3216:
3217: --Bug# 3156924 :
3218: --cursor to fetch transaction number from okl_trx_assets
3219: cursor l_tas_csr(p_tas_id in number) is
3220: select to_char(trans_number),
3221: DATE_TRANS_OCCURRED,
3222: --Bug# 6373605 start

Line 3226: from okl_trx_assets

3222: --Bug# 6373605 start
3223: id tas_id,
3224: try_id
3225: --Bug# 6373605 end
3226: from okl_trx_assets
3227: where id = p_tas_id;
3228:
3229: l_trans_number okl_trx_contracts.trx_number%TYPE := p_trans_number;
3230: l_trans_date okl_trx_assets.date_trans_occurred%TYPE;

Line 3230: l_trans_date okl_trx_assets.date_trans_occurred%TYPE;

3226: from okl_trx_assets
3227: where id = p_tas_id;
3228:
3229: l_trans_number okl_trx_contracts.trx_number%TYPE := p_trans_number;
3230: l_trans_date okl_trx_assets.date_trans_occurred%TYPE;
3231: l_calling_interface varchar2(30) := p_calling_interface;
3232: --Bug# 3156924
3233: --Bug# 6373605 start
3234: l_tas_id okl_trx_assets.id%TYPE;

Line 3234: l_tas_id okl_trx_assets.id%TYPE;

3230: l_trans_date okl_trx_assets.date_trans_occurred%TYPE;
3231: l_calling_interface varchar2(30) := p_calling_interface;
3232: --Bug# 3156924
3233: --Bug# 6373605 start
3234: l_tas_id okl_trx_assets.id%TYPE;
3235: l_try_id okl_trx_assets.try_id%TYPE;
3236: --Bug# 6373605 end
3237:
3238: --Bug# 4028371

Line 3235: l_try_id okl_trx_assets.try_id%TYPE;

3231: l_calling_interface varchar2(30) := p_calling_interface;
3232: --Bug# 3156924
3233: --Bug# 6373605 start
3234: l_tas_id okl_trx_assets.id%TYPE;
3235: l_try_id okl_trx_assets.try_id%TYPE;
3236: --Bug# 6373605 end
3237:
3238: --Bug# 4028371
3239: l_fa_add_date_corp date;

Line 3455: p_sla_source_header_table => 'OKL_TRX_ASSETS',

3451: --Bug# 5261704
3452: p_depreciate_flag => l_depreciate_flag,
3453: --Bug# 6373605--SLA populate source
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,

Line 3618: p_sla_source_header_table => 'OKL_TRX_ASSETS',

3614: --Bug# 5261704
3615: p_depreciate_flag => l_depreciate_flag,
3616: --Bug# 6373605--SLA populate source
3617: p_sla_source_header_id => l_tas_id,
3618: p_sla_source_header_table => 'OKL_TRX_ASSETS',
3619: p_sla_source_try_id => l_try_id,
3620: p_sla_source_line_id => okl_tadv_rec.asd_id,
3621: p_sla_source_line_table => 'OKL_TXD_ASSETS_B',
3622: p_sla_source_chr_id => p_chrv_id,

Line 3821: p_sla_source_header_table => 'OKL_TRX_ASSETS',

3817: --Bug# :5261704
3818: p_depreciate_flag => l_depreciate_flag,
3819: --Bug# 6373605--SLA populate source
3820: p_sla_source_header_id => l_tas_id,
3821: p_sla_source_header_table => 'OKL_TRX_ASSETS',
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,

Line 3936: p_sla_source_header_table => 'OKL_TRX_ASSETS',

3932: --Bug# 3156924
3933: p_adj_date => l_talv_rec.in_service_date,
3934: --Bug# 6373605--SLA populate source
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,

Line 4028: p_sla_source_header_table => 'OKL_TRX_ASSETS',

4024: -- Bug Fix# 2925461
4025: p_adj_date => l_talv_rec.in_service_date,
4026: --Bug# 6373605--SLA populate source
4027: p_sla_source_header_id => l_tas_id,
4028: p_sla_source_header_table => 'OKL_TRX_ASSETS',
4029: p_sla_source_try_id => l_try_id,
4030: p_sla_source_line_id => l_sla_source_line_id,
4031: p_sla_source_line_table => l_sla_source_line_table,
4032: p_sla_source_chr_id => p_chrv_id,

Line 4147: p_sla_source_header_table => 'OKL_TRX_ASSETS',

4143: -- Bug Fix# 2925461
4144: p_adj_date => l_talv_rec.in_service_date,
4145: --Bug# 6373605--SLA populate source
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,

Line 4216: p_sla_source_header_table => 'OKL_TRX_ASSETS',

4212: -- Bug Fix# 2925461
4213: p_adj_date => l_talv_rec.in_service_date,
4214: --Bug# 6373605--SLA populate source
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,

Line 4306: p_sla_source_header_table => 'OKL_TRX_ASSETS',

4302: -- Bug Fix# 2925461
4303: p_adj_date => l_talv_rec.in_service_date,
4304: --Bug# 6373605--SLA populate source
4305: p_sla_source_header_id => l_tas_id,
4306: p_sla_source_header_table => 'OKL_TRX_ASSETS',
4307: p_sla_source_try_id => l_try_id,
4308: p_sla_source_line_id => l_sla_source_line_id,
4309: p_sla_source_line_table => l_sla_source_line_table,
4310: p_sla_source_chr_id => p_chrv_id,

Line 4392: p_sla_source_header_table => 'OKL_TRX_ASSETS',

4388: x_fa_trx_date => l_fa_adj_date_mg,
4389: p_adj_date => okx_ast_rec.in_service_date,
4390: --Bug# 6373605--SLA populate source
4391: p_sla_source_header_id => l_tas_id,
4392: p_sla_source_header_table => 'OKL_TRX_ASSETS',
4393: p_sla_source_try_id => l_try_id,
4394: p_sla_source_line_id => l_sla_source_line_id,
4395: p_sla_source_line_table => l_sla_source_line_table,
4396: p_sla_source_chr_id => p_chrv_id,

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

4680: l_town_rul okc_rules_b.rule_information1%TYPE;
4681: l_town_rul_id okc_rules_b.id%TYPE;
4682:
4683: --Bug# 3156924
4684: l_trans_number okl_trx_assets.trans_number%TYPE := Null;
4685: l_calling_interface varchar2(30) := 'OKLRACAB:Booking';
4686:
4687: --Bug# 3574232
4688: l_adjust_asset_to_zero varchar2(30);

Line 5124: OKL_TRX_ASSETS tas,

5120: txl.asset_key_id asset_key_id
5121: FROM OKL_TXL_ASSETS_V txl,
5122: --akrangan bug# 5362977 end
5123: --Bug# 6373605 start
5124: OKL_TRX_ASSETS tas,
5125: --Bug# 6373605 end
5126: OKC_K_LINES_B cle,
5127: OKC_LINE_STYLES_B lse
5128: WHERE txl.kle_id = cle.id

Line 5181: OKL_TRX_ASSETS tas,

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

Line 5895: p_sla_source_header_table => 'OKL_TRX_ASSETS',

5891: p_trans_number => l_trx_number,
5892: p_calling_interface => l_calling_interface,
5893: --Bug# 6373605--SLA populate source
5894: p_sla_source_header_id => adj_txl_rec.sla_source_header_id,
5895: p_sla_source_header_table => 'OKL_TRX_ASSETS',
5896: p_sla_source_try_id => adj_txl_rec.sla_source_try_id,
5897: p_sla_source_line_id => adj_txl_rec.sla_source_line_id,
5898: p_sla_source_line_table => adj_txl_rec.sla_source_line_table,
5899: p_sla_source_chr_id => p_rbk_chr_id,

Line 5962: p_sla_source_header_table => 'OKL_TRX_ASSETS',

5958: p_trx_number => l_trx_number,
5959: p_calling_interface => l_calling_interface,
5960: --Bug# 6373605--SLA populate source
5961: p_sla_source_header_id => adj_txl_rec.sla_source_header_id,
5962: p_sla_source_header_table => 'OKL_TRX_ASSETS',
5963: p_sla_source_try_id => adj_txl_rec.sla_source_try_id,
5964: p_sla_source_line_id => adj_txl_rec.sla_source_line_id,
5965: p_sla_source_line_table => adj_txl_rec.sla_source_line_table,
5966: p_sla_source_chr_id => p_rbk_chr_id,

Line 6358: OKL_TRX_ASSETS tas,

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

Line 6378: from OKL_TRX_ASSETS TRX

6374: And sts.ste_code in ('HOLD','EXPIRED','TERMINATED','CANCELLED')
6375: )
6376: AND lse.lty_code = G_FA_LINE_LTY_CODE
6377: AND exists (select '1'
6378: from OKL_TRX_ASSETS TRX
6379: Where TRX.ID = Txl.tas_id
6380: And TRX.tas_type = 'CRB'
6381: And TRX.tsu_code = 'ENTERED')
6382: UNION

Line 6410: OKL_TRX_ASSETS tas,

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

Line 6430: from OKL_TRX_ASSETS TRX

6426: And sts.ste_code in ('HOLD','EXPIRED','TERMINATED','CANCELLED')
6427: )
6428: AND lse.lty_code = G_FA_LINE_LTY_CODE
6429: AND exists (select '1'
6430: from OKL_TRX_ASSETS TRX
6431: Where TRX.ID = Txl.tas_id
6432: And TRX.tas_type = 'CRB'
6433: And TRX.tsu_code = 'ENTERED');
6434:

Line 6955: p_sla_source_header_table => 'OKL_TRX_ASSETS',

6951: p_trans_number => l_trans_number,
6952: p_calling_interface => l_calling_interface,
6953: --Bug# 6373605--SLA populate source
6954: p_sla_source_header_id => adj_txl_rec.sla_source_header_id,
6955: p_sla_source_header_table => 'OKL_TRX_ASSETS',
6956: p_sla_source_try_id => adj_txl_rec.sla_source_try_id,
6957: p_sla_source_line_id => adj_txl_rec.sla_source_line_id,
6958: p_sla_source_line_table => adj_txl_rec.sla_source_line_table,
6959: p_sla_source_chr_id => p_rbk_chr_id,

Line 7195: OKL_TRX_ASSETS trx,

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

Line 7218: --from OKL_TRX_ASSETS trx,

7214: AND lse.lty_code = G_FA_LINE_LTY_CODE
7215: --Bug# 3156924:
7216: /*----------------------------------------------------
7217: --AND exists (select null
7218: --from OKL_TRX_ASSETS trx,
7219: --OKL_TRX_TYPES_TL ttyp
7220: --where trx.id = txl.tas_id
7221: --and trx.try_id = ttyp.id
7222: --and ttyp.name = 'Internal Asset Creation'

Line 7274: OKL_TRX_ASSETS trx,

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

Line 7299: --from OKL_TRX_ASSETS trx,

7295: AND lse.lty_code = G_FA_LINE_LTY_CODE
7296: --bug# 3156924
7297: /*-------------------------------------------------------------
7298: --AND exists (select null
7299: --from OKL_TRX_ASSETS trx,
7300: --OKL_TRX_TYPES_TL ttyp
7301: --where trx.id = txl.tas_id
7302: --and trx.try_id = ttyp.id
7303: --and ttyp.name = 'Release'

Line 7414: okl_trx_assets trx,

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

Line 7466: l_trans_number okl_trx_assets.trans_number%TYPE;

7462: --Bug# 6373605 End
7463:
7464: --Bug# 3156924
7465: l_release_date date;
7466: l_trans_number okl_trx_assets.trans_number%TYPE;
7467: l_calling_interface varchar2(30) := 'OKLRACAB:Release';
7468:
7469: --BUG# 3548044
7470: l_release_allowed_on_mg_book varchar2(1);

Line 7478: FROM OKL_TRX_ASSETS trx,

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

Line 7950: p_sla_source_header_table => 'OKL_TRX_ASSETS',

7946: --Bug# 5261704
7947: p_depreciate_flag => l_depreciate_flag,
7948: --Bug# 6373605--SLA populate source
7949: p_sla_source_header_id => adj_txl_rec.sla_source_header_id,
7950: p_sla_source_header_table => 'OKL_TRX_ASSETS',
7951: p_sla_source_try_id => adj_txl_rec.sla_source_try_id,
7952: p_sla_source_line_id => adj_txl_rec.sla_source_line_id,
7953: p_sla_source_line_table => adj_txl_rec.sla_source_line_table,
7954: p_sla_source_chr_id => p_rel_chr_id,

Line 8000: p_sla_source_header_table => 'OKL_TRX_ASSETS',

7996: p_calling_interface => l_calling_interface,
7997: p_adj_date => l_release_date,
7998: --Bug# 6373605--SLA populate source
7999: p_sla_source_header_id => adj_txl_rec.sla_source_header_id,
8000: p_sla_source_header_table => 'OKL_TRX_ASSETS',
8001: p_sla_source_try_id => adj_txl_rec.sla_source_try_id,
8002: p_sla_source_line_id => adj_txl_rec.sla_source_line_id,
8003: p_sla_source_line_table => adj_txl_rec.sla_source_line_table,
8004: p_sla_source_chr_id => p_rel_chr_id,

Line 8555: p_sla_source_header_table => 'OKL_TRX_ASSETS',

8551: p_calling_interface => l_calling_interface,
8552: -- Bug# 3156924
8553: --Bug# 6373605--SLA populate source
8554: p_sla_source_header_id => adj_txl_rec.sla_source_header_id,
8555: p_sla_source_header_table => 'OKL_TRX_ASSETS',
8556: p_sla_source_try_id => adj_txl_rec.sla_source_try_id,
8557: p_sla_source_line_id => adj_txl_rec.sla_source_line_id,
8558: p_sla_source_line_table => adj_txl_rec.sla_source_line_table,
8559: p_sla_source_chr_id => p_rel_chr_id,

Line 8619: p_sla_source_header_table => 'OKL_TRX_ASSETS',

8615: p_trans_number => l_trans_number,
8616: p_calling_interface => l_calling_interface,
8617: --Bug# 6373605--SLA populate source
8618: p_sla_source_header_id => adj_txl_rec.sla_source_header_id,
8619: p_sla_source_header_table => 'OKL_TRX_ASSETS',
8620: p_sla_source_try_id => adj_txl_rec.sla_source_try_id,
8621: p_sla_source_line_id => adj_txl_rec.sla_source_line_id,
8622: p_sla_source_line_table => adj_txl_rec.sla_source_line_table,
8623: p_sla_source_chr_id => p_rel_chr_id,

Line 8692: p_sla_source_header_table => 'OKL_TRX_ASSETS',

8688: p_trx_number => l_trans_number,
8689: p_calling_interface => l_calling_interface,
8690: --Bug# 6373605--SLA populate source
8691: p_sla_source_header_id => adj_txl_rec.sla_source_header_id,
8692: p_sla_source_header_table => 'OKL_TRX_ASSETS',
8693: p_sla_source_try_id => adj_txl_rec.sla_source_try_id,
8694: p_sla_source_line_id => adj_txl_rec.sla_source_line_id,
8695: p_sla_source_line_table => adj_txl_rec.sla_source_line_table,
8696: p_sla_source_chr_id => p_rel_chr_id,

Line 8928: p_sla_source_header_table => 'OKL_TRX_ASSETS',

8924: p_trans_number => l_trans_number,
8925: p_calling_interface => l_calling_interface,
8926: --Bug# 6373605--SLA populate source
8927: p_sla_source_header_id => l_asset_rec.sla_source_header_id,
8928: p_sla_source_header_table => 'OKL_TRX_ASSETS',
8929: p_sla_source_try_id => l_Asset_rec.sla_source_try_id,
8930: p_sla_source_line_id => l_sla_source_line_id,
8931: p_sla_source_line_table => l_sla_source_line_table,
8932: p_sla_source_chr_id => p_rel_chr_id,

Line 9046: okl_trx_assets trx,

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

Line 10852: okl_trx_assets trx,

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