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_SPLIT_ASSET_PVT dependencies on OKL_TRX_ASSETS

Line 1169: l_split_trans_id OKL_TRX_ASSETS.ID%TYPE;

1165: l_inv_accrual_rec OKL_GENERATE_ACCRUALS_PVT.adjust_accrual_rec_type;
1166: l_inv_stream_tbl OKL_GENERATE_ACCRUALS_PVT.stream_tbl_type;
1167: l_trxv_rec trxv_rec_type;
1168: lx_trxv_rec trxv_rec_type;
1169: l_split_trans_id OKL_TRX_ASSETS.ID%TYPE;
1170: l_trx_number OKL_TRX_CONTRACTS.TRX_NUMBER%TYPE := null; -- MGAAP
1171: l_trx_reason_asset_split VARCHAR2(20) := OKL_SECURITIZATION_PVT.G_TRX_REASON_ASSET_SPLIT;
1172:
1173: --Cursor to check whether split asset transaction is in progress for the contract

Line 1176: FROM OKL_TXL_ASSETS_B txl, OKL_TRX_ASSETS tas

1172:
1173: --Cursor to check whether split asset transaction is in progress for the contract
1174: CURSOR check_split_trx_csr IS
1175: SELECT tas.id
1176: FROM OKL_TXL_ASSETS_B txl, OKL_TRX_ASSETS tas
1177: WHERE txl.tal_type= 'ALI'
1178: AND txl.dnz_khr_id = p_chr_id
1179: AND txl.tas_id = tas.id
1180: AND tas.tas_type = 'ALI'

Line 1564: p_source_trx_id => l_split_trans_id, --,

1560: p_init_msg_list => p_init_msg_list,
1561: x_return_status => x_return_status,
1562: x_msg_count => x_msg_count,
1563: x_msg_data => x_msg_data,
1564: p_source_trx_id => l_split_trans_id, --,
1565: p_source_trx_name => 'Split Asset',
1566: p_source_table => 'OKL_TRX_ASSETS');
1567:
1568: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1566: p_source_table => 'OKL_TRX_ASSETS');

1562: x_msg_count => x_msg_count,
1563: x_msg_data => x_msg_data,
1564: p_source_trx_id => l_split_trans_id, --,
1565: p_source_trx_name => 'Split Asset',
1566: p_source_table => 'OKL_TRX_ASSETS');
1567:
1568: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1569: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1570: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 1580: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(

1576: ------------------------------------------------------------------------
1577:
1578: l_trxv_rec.id := l_split_trans_id;
1579: l_trxv_rec.tsu_code := 'PROCESSED';
1580: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(
1581: p_api_version => p_api_version,
1582: p_init_msg_list => p_init_msg_list,
1583: x_return_status => x_return_status,
1584: x_msg_count => x_msg_count,

Line 2564: FROM OKL_TRX_ASSETS h, OKL_TXL_ASSETS_B l

2560:
2561: CURSOR l_offlseassettrx_csr(cp_trx_date IN DATE, cp_asset_number IN VARCHAR2) IS
2562: SELECT h.tsu_code, h.tas_type, h.date_trans_occurred, l.dnz_asset_id,
2563: l.asset_number, l.kle_id ,l.DNZ_KHR_ID
2564: FROM OKL_TRX_ASSETS h, OKL_TXL_ASSETS_B l
2565: WHERE h.id = l.tas_id
2566: AND h.date_trans_occurred <= cp_trx_date
2567: AND h.tas_type in ('AMT','AUD','AUS')
2568: AND l.asset_number = cp_asset_number;

Line 3203: FROM okl_trx_Assets trx,

3199: -- Multi-Currency Change
3200: FROM Okl_Txl_Assets_V
3201: WHERE okl_txl_assets_v.kle_id = p_kle_id
3202: AND EXISTS (SELECT NULL
3203: FROM okl_trx_Assets trx,
3204: okl_trx_types_tl ttyp
3205: WHERE trx.id = okl_txl_assets_v.tas_id
3206: AND trx.tsu_code = 'ENTERED'
3207: AND trx.try_id = ttyp.id

Line 3454: FROM okl_trx_Assets trx,

3450: SELECT 'Y'
3451: FROM okl_txd_assets_b txd
3452: WHERE NVL(txd.asset_number,'-999999999999999') = p_asset_number
3453: AND EXISTS (SELECT NULL
3454: FROM okl_trx_Assets trx,
3455: okl_trx_types_tl ttyp,
3456: okl_txl_assets_b txl
3457: WHERE trx.id = txl.tas_id
3458: AND trx.try_id = ttyp.id

Line 3541: okl_trx_assets trx

3537: SELECT 'Y'
3538: FROM okl_txd_assets_b txd,
3539: okl_txl_assets_b txl,
3540: okl_trx_types_tl ttyp,
3541: okl_trx_assets trx
3542: WHERE NVL(txd.asset_number,'-999999999999999') = p_asset_number
3543: AND txd.tal_id = txl.id
3544: AND txl.tas_id = trx.id
3545: AND trx.try_id = ttyp.id

Line 3818: --Procedure to create transaction header (OKL_TRX_ASSETS_V)

3814: END IF;
3815: RETURN(l_return_status);
3816: END Get_fa_Location;
3817: --------------------------------------------------------------------------------
3818: --Procedure to create transaction header (OKL_TRX_ASSETS_V)
3819: --------------------------------------------------------------------------------
3820: PROCEDURE Create_trx_header(
3821: p_api_version IN NUMBER,
3822: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 3846: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def(

3842: RAISE OKL_API.G_EXCEPTION_ERROR;
3843: END IF;
3844: -- evaluate conditions, build outcomes for true conditions and
3845: -- put them on outcome queue
3846: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def(
3847: p_api_version => p_api_version,
3848: p_init_msg_list => p_init_msg_list,
3849: x_return_status => x_return_status,
3850: x_msg_count => x_msg_count,

Line 3889: --PROCEDURE to update transaction_header (OKL_TRX_ASSETS_V)

3885: x_msg_data,
3886: '_PVT');
3887: END Create_trx_header;
3888: --------------------------------------------------------------------------------
3889: --PROCEDURE to update transaction_header (OKL_TRX_ASSETS_V)
3890: --------------------------------------------------------------------------------
3891: PROCEDURE Update_trx_header(
3892: p_api_version IN NUMBER,
3893: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 3917: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(

3913: RAISE OKL_API.G_EXCEPTION_ERROR;
3914: END IF;
3915: -- evaluate conditions, build outcomes for true conditions and
3916: -- put them on outcome queue
3917: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(
3918: p_api_version => p_api_version,
3919: p_init_msg_list => p_init_msg_list,
3920: x_return_status => x_return_status,
3921: x_msg_count => x_msg_count,

Line 5762: -- 3. Create and save source record into okl_trx_assets_v

5758: --Description : Process API to create Split Aseet Transaction Records in
5759: -- OKL_TXL_ASSETS_V and OKL_TXD_ASSETS_V
5760: -- 1. Take the line details to be split
5761: -- 2. Set the status of the contract as inactive
5762: -- 3. Create and save source record into okl_trx_assets_v
5763: -- 4. Create and save target record into okl_txd_assets_v
5764: --History :
5765: -- 10-OCT-2001 avsingh Creation
5766: -- 12-Dec-2002 avsingh Overloaded the procedure to take p_srl_tbl

Line 5807: OKL_TRX_ASSETS tas

5803: --Bug# 3156924
5804: tas.DATE_TRANS_OCCURRED,
5805: tas.ID
5806: FROM OKL_TXL_ASSETS_B txl,
5807: OKL_TRX_ASSETS tas
5808: WHERE txl.kle_id = p_cle_id
5809: AND txl.tas_id = tas.id
5810: AND txl.tal_type = 'ALI'
5811: AND tas.tas_type = 'ALI'

Line 5827: l_trx_date okl_trx_assets.DATE_TRANS_OCCURRED%TYPE;

5823: l_split_into_ind_yn VARCHAR2(1) DEFAULT 'Z';
5824: l_split_units NUMBER DEFAULT 0;
5825: l_tal_id NUMBER;
5826: --Bug# 3156924
5827: l_trx_date okl_trx_assets.DATE_TRANS_OCCURRED%TYPE;
5828: l_tas_id okl_trx_assets.ID%TYPE;
5829:
5830:
5831: l_trxv_rec trxv_rec_type;

Line 5828: l_tas_id okl_trx_assets.ID%TYPE;

5824: l_split_units NUMBER DEFAULT 0;
5825: l_tal_id NUMBER;
5826: --Bug# 3156924
5827: l_trx_date okl_trx_assets.DATE_TRANS_OCCURRED%TYPE;
5828: l_tas_id okl_trx_assets.ID%TYPE;
5829:
5830:
5831: l_trxv_rec trxv_rec_type;
5832: l_txlv_rec txlv_rec_type;

Line 6507: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(

6503: ------------------------------------------------
6504: --update transaction header for transaction date
6505: l_trxv_rec.id := l_tas_id;
6506: l_trxv_rec.date_trans_occurred := p_trx_date;
6507: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(
6508: p_api_version => p_api_version,
6509: p_init_msg_list => p_init_msg_list,
6510: x_return_status => x_return_status,
6511: x_msg_count => x_msg_count,

Line 6990: -- 3. Create and save source record into okl_trx_assets_v

6986: --Description : Process API to create Split Aseet Transaction Records in
6987: -- OKL_TXL_ASSETS_V and OKL_TXD_ASSETS_V
6988: -- 1. Take the line details to be split
6989: -- 2. Set the status of the contract as inactive
6990: -- 3. Create and save source record into okl_trx_assets_v
6991: -- 4. Create and save target record into okl_txd_assets_v
6992: --Note : old signature kept for backward compatability. This will be the
6993: -- the one called from the UI. This will create transactions in OKL
6994: -- _TXL_ITM_INSTS if the asset is serialized ad being split by units

Line 10773: FROM OKL_TRX_ASSETS tas,

10769: l_amortization_start_date DATE:=NULL;
10770: -- CURSOR TO GET MAX OFF LEASE TRX DATESELECT
10771: Cursor tax_off_trx_amt(p_asset_id in number, p_tax_book in varchar2) is
10772: select tas.date_trans_occurred
10773: FROM OKL_TRX_ASSETS tas,
10774: OKL_TXL_ASSETS_B tal,
10775: OKL_TXD_ASSETS_B txl
10776: WHERE tas.id = tal.tas_id
10777: AND tal.id = txl.tal_id

Line 10785: FROM OKL_TRX_ASSETS tas,

10781: And tal.kle_id = p_asset_id;
10782: Cursor corp_off_trx_amt(p_asset_id in number, p_corp_book in varchar2) is
10783: SELECT
10784: tas.date_trans_occurred
10785: FROM OKL_TRX_ASSETS tas,
10786: OKL_TXL_ASSETS_B tal,
10787: OKL_TXD_ASSETS_B txd
10788: WHERE tas.id = tal.tas_id
10789: AND tal.corporate_book = P_corp_book

Line 10797: FROM OKL_TRX_ASSETS tas,

10793: AND tal.id = txd.tal_id(+)
10794: AND TAX_BOOK IS NULL ;
10795: Cursor tax_off_trx_aus(p_asset_id in number, p_tax_book in varchar2) is
10796: select tas.date_trans_occurred
10797: FROM OKL_TRX_ASSETS tas,
10798: OKL_TXL_ASSETS_B tal,
10799: OKL_TXD_ASSETS_B txl
10800: WHERE tas.id = tal.tas_id
10801: AND tal.id = txl.tal_id

Line 10809: FROM OKL_TRX_ASSETS tas,

10805: And tal.kle_id = p_asset_id;
10806: Cursor corp_off_trx_aus(p_asset_id in number, p_corp_book in varchar2) is
10807: SELECT
10808: tas.date_trans_occurred
10809: FROM OKL_TRX_ASSETS tas,
10810: OKL_TXL_ASSETS_B tal,
10811: OKL_TXD_ASSETS_B txd
10812: WHERE tas.id = tal.tas_id
10813: AND tal.corporate_book = P_corp_book

Line 10994: -- ID of source OKL_TRX_ASSETS record

10990: --History :
10991: -- 28-Nov-2001 ashish.singh Created
10992: -- Bug# 6373605 (OKL.R12.B SLA CRs
10993: -- p_sla_source_header_id IN Number,
10994: -- ID of source OKL_TRX_ASSETS record
10995: -- p_sla_source_header_table IN Varchar2,
10996: -- 'OKL_TRX_ASSETS'
10997: -- p_sla_source_try_id IN Number,
10998: -- OKL_TRX_ASSETS.try_id (transaction type id)

Line 10996: -- 'OKL_TRX_ASSETS'

10992: -- Bug# 6373605 (OKL.R12.B SLA CRs
10993: -- p_sla_source_header_id IN Number,
10994: -- ID of source OKL_TRX_ASSETS record
10995: -- p_sla_source_header_table IN Varchar2,
10996: -- 'OKL_TRX_ASSETS'
10997: -- p_sla_source_try_id IN Number,
10998: -- OKL_TRX_ASSETS.try_id (transaction type id)
10999: -- p_sla_source_line_id IN Number,
11000: -- ID of line table (OKL_TXL_ASSETS_B or

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

10994: -- ID of source OKL_TRX_ASSETS record
10995: -- p_sla_source_header_table IN Varchar2,
10996: -- 'OKL_TRX_ASSETS'
10997: -- p_sla_source_try_id IN Number,
10998: -- OKL_TRX_ASSETS.try_id (transaction type id)
10999: -- p_sla_source_line_id IN Number,
11000: -- ID of line table (OKL_TXL_ASSETS_B or
11001: -- OKL_TXD_ASSETS_B
11002: -- p_sla_source_line_table IN Varchar2,

Line 14936: FROM OKL_TRX_ASSETS

14932: TRANS_NUMBER,
14933: --Bug# 6373605 start
14934: TRY_ID
14935: --Bug# 6373605 end
14936: FROM OKL_TRX_ASSETS
14937: WHERE id = ptrxid;
14938:
14939: l_trx_rec l_trx_csr%ROWTYPE;
14940:

Line 15283: p_sla_source_header_table => 'OKL_TRX_ASSETS',

15279: p_trx_date => l_trx_rec.date_trans_occurred,
15280: p_trx_number => l_trx_rec.trans_number,
15281: --Bug# 6373605--SLA populate source
15282: p_sla_source_header_id => l_txlv_rec.tas_id,
15283: p_sla_source_header_table => 'OKL_TRX_ASSETS',
15284: p_sla_source_try_id => l_trx_rec.try_id,
15285: p_sla_source_line_id => l_txlv_rec.id,
15286: p_sla_source_line_table => 'OKL_TXL_ASSETS_B',
15287: p_sla_source_chr_id => l_chr_id,

Line 15458: p_sla_source_header_table => 'OKL_TRX_ASSETS',

15454: p_trx_date => l_trx_rec.date_trans_occurred,
15455: p_trx_number => l_trx_rec.trans_number,
15456: --Bug# 6373605--SLA populate source
15457: p_sla_source_header_id => l_txlv_rec.tas_id,
15458: p_sla_source_header_table => 'OKL_TRX_ASSETS',
15459: p_sla_source_try_id => l_trx_rec.try_id,
15460: p_sla_source_line_id => l_txdv_rec.id,
15461: p_sla_source_line_table => 'OKL_TXD_ASSETS_B',
15462: p_sla_source_chr_id => l_chr_id,

Line 15802: p_sla_source_header_table => 'OKL_TRX_ASSETS',

15798: p_trx_date => l_trx_rec.date_trans_occurred,
15799: p_trx_number => l_trx_rec.trans_number,
15800: --Bug# 6373605--SLA populate source
15801: p_sla_source_header_id => l_txlv_rec.tas_id,
15802: p_sla_source_header_table => 'OKL_TRX_ASSETS',
15803: p_sla_source_try_id => l_trx_rec.try_id,
15804: p_sla_source_line_id => l_txlv_rec.id,
15805: p_sla_source_line_table => 'OKL_TXL_ASSETS_B',
15806: p_sla_source_chr_id => l_chr_id,

Line 16046: p_source_trx_id => p_txlv_rec.tas_id, --,

16042: p_init_msg_list => p_init_msg_list,
16043: x_return_status => x_return_status,
16044: x_msg_count => x_msg_count,
16045: x_msg_data => x_msg_data,
16046: p_source_trx_id => p_txlv_rec.tas_id, --,
16047: p_source_trx_name => 'Split Asset',
16048: p_source_table => 'OKL_TRX_ASSETS');
16049:
16050: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 16048: p_source_table => 'OKL_TRX_ASSETS');

16044: x_msg_count => x_msg_count,
16045: x_msg_data => x_msg_data,
16046: p_source_trx_id => p_txlv_rec.tas_id, --,
16047: p_source_trx_name => 'Split Asset',
16048: p_source_table => 'OKL_TRX_ASSETS');
16049:
16050: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
16051: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
16052: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 16063: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(

16059:
16060: --update the transaction record to processed.
16061: l_trxv_rec.id := p_txlv_rec.tas_id;
16062: l_trxv_rec.tsu_code := 'PROCESSED';
16063: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(
16064: p_api_version => p_api_version,
16065: p_init_msg_list => p_init_msg_list,
16066: x_return_status => x_return_status,
16067: x_msg_count => x_msg_count,

Line 16258: FROM okl_trx_assets tasb

16254: CURSOR l_cle_tas_csr
16255: IS
16256: SELECT cleb.dnz_chr_id,
16257: tasb.date_trans_occurred
16258: FROM okl_trx_assets tasb
16259: ,okl_txl_assets_b txlb
16260: ,okc_k_lines_b cleb
16261: ,okc_line_styles_b lseb
16262: WHERE txlb.tas_id = tasb.id

Line 16593: FROM OKL_TRX_ASSETS TAS,

16589: --Cursor to find kle_id split transaction lines to be cancelled..
16590: CURSOR l_tal_csr(p_fixedasst_line IN NUMBER) IS
16591: SELECT tal.id tal_id,
16592: tas.id tas_id
16593: FROM OKL_TRX_ASSETS TAS,
16594: OKL_TXL_ASSETS_B TAL
16595: WHERE tas.id = tal.tas_id
16596: AND tas.tsu_code = 'ENTERED'
16597: AND tas.tas_type = 'ALI'

Line 16601: l_tas_id OKL_TRX_ASSETS.ID%TYPE;

16597: AND tas.tas_type = 'ALI'
16598: AND tal.tal_type = 'ALI'
16599: AND tal.kle_id = p_fixedasst_line;
16600:
16601: l_tas_id OKL_TRX_ASSETS.ID%TYPE;
16602: l_tal_id OKL_TXL_ASSETS_B.ID%TYPE;
16603: l_cle_id OKC_K_LINES_B.ID%TYPE;
16604:
16605: l_tasv_rec okl_trx_assets_pub.thpv_rec_type;

Line 16605: l_tasv_rec okl_trx_assets_pub.thpv_rec_type;

16601: l_tas_id OKL_TRX_ASSETS.ID%TYPE;
16602: l_tal_id OKL_TXL_ASSETS_B.ID%TYPE;
16603: l_cle_id OKC_K_LINES_B.ID%TYPE;
16604:
16605: l_tasv_rec okl_trx_assets_pub.thpv_rec_type;
16606: lx_tasv_rec okl_trx_assets_pub.thpv_rec_type;
16607:
16608: BEGIN
16609: -- Call start_activity to create savepoint, check compatibility

Line 16606: lx_tasv_rec okl_trx_assets_pub.thpv_rec_type;

16602: l_tal_id OKL_TXL_ASSETS_B.ID%TYPE;
16603: l_cle_id OKC_K_LINES_B.ID%TYPE;
16604:
16605: l_tasv_rec okl_trx_assets_pub.thpv_rec_type;
16606: lx_tasv_rec okl_trx_assets_pub.thpv_rec_type;
16607:
16608: BEGIN
16609: -- Call start_activity to create savepoint, check compatibility
16610: -- and initialize message list

Line 16650: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(

16646: --update the transaction status to cancelled
16647: l_tasv_rec.id := l_tas_id;
16648: l_tasv_rec.tsu_code := 'CANCELED';
16649: --update split transaction header
16650: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(
16651: p_api_version => p_api_version,
16652: p_init_msg_list => p_init_msg_list,
16653: x_return_status => x_return_status,
16654: x_msg_count => x_msg_count,