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

Line 1729: SUBTYPE thpv_rec_type IS OKL_TRX_ASSETS_PUB.thpv_rec_type;

1725: p_quote_accpt_date in date default null, -- rmunjulu edat
1726: p_legal_entity_id in number -- rravikir legal entity changes
1727: ) IS
1728:
1729: SUBTYPE thpv_rec_type IS OKL_TRX_ASSETS_PUB.thpv_rec_type;
1730: SUBTYPE tlpv_rec_type IS OKL_TXL_ASSETS_PUB.tlpv_rec_type;
1731:
1732:
1733:

Line 1787: FROM OKL_TRX_ASSETS h, okl_txl_assets_v l

1783: -- This cursor is used to get all the pending transactions for an asset. These transactions are to be calcelled
1784: -- once the asset is retired.
1785: CURSOR l_assettrx_csr IS
1786: SELECT h.id
1787: FROM OKL_TRX_ASSETS h, okl_txl_assets_v l
1788: WHERE h.id = l.tas_id
1789: AND h.tsu_code IN ('ENTERED', 'ERROR')
1790: AND l.kle_id = p_financial_asset_id;
1791:

Line 1865: FROM OKL_TRX_ASSETS h, OKL_TXL_ASSETS_B l

1861: --SECHAWLA 10-FEB-06 5016156 : begin
1862: CURSOR l_offlseassettrx_csr(cp_trx_date IN DATE, cp_asset_number IN VARCHAR2) IS
1863: SELECT h.tsu_code, h.tas_type, h.date_trans_occurred, l.dnz_asset_id,
1864: l.asset_number, l.kle_id ,l.DNZ_KHR_ID
1865: FROM OKL_TRX_ASSETS h, OKL_TXL_ASSETS_B l
1866: WHERE h.id = l.tas_id
1867: AND h.date_trans_occurred <= cp_trx_date
1868: AND h.tas_type in ('AMT','AUD','AUS')
1869: AND l.asset_number = cp_asset_number;

Line 2951: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def( p_api_version => p_api_version,

2947: -- RRAVIKIR Legal Entity Changes
2948: lp_thpv_rec.legal_entity_id := p_legal_entity_id;
2949: -- Legal Entity Changes End
2950:
2951: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def( p_api_version => p_api_version,
2952: p_init_msg_list => OKC_API.G_FALSE,
2953: x_return_status => x_return_status,
2954: x_msg_count => x_msg_count,
2955: x_msg_data => x_msg_data,

Line 3064: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(

3060: lp_thpv_rec := lp_thpv_empty_rec;
3061: lp_thpv_rec.id := lx_thpv_rec.id;
3062: lp_thpv_rec.total_match_amount := lx_total_amount;
3063:
3064: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(
3065: p_api_version => p_api_version,
3066: p_init_msg_list => OKC_API.G_FALSE,
3067: x_return_status => x_return_status,
3068: x_msg_count => x_msg_count,

Line 3190: -- Loop thru all the pending transactions in okl_trx_assets_v and okl_txl_assets_v

3186:
3187:
3188:
3189:
3190: -- Loop thru all the pending transactions in okl_trx_assets_v and okl_txl_assets_v
3191: -- and update the status to 'CANCELED'
3192:
3193: FOR l_assettrx_rec IN l_assettrx_csr LOOP
3194: -- update the staus (tsu_code) in okl_trx_assets_v

Line 3194: -- update the staus (tsu_code) in okl_trx_assets_v

3190: -- Loop thru all the pending transactions in okl_trx_assets_v and okl_txl_assets_v
3191: -- and update the status to 'CANCELED'
3192:
3193: FOR l_assettrx_rec IN l_assettrx_csr LOOP
3194: -- update the staus (tsu_code) in okl_trx_assets_v
3195: lp_thpv_rec := lp_thpv_empty_rec;
3196: lp_thpv_rec.id := l_assettrx_rec.id;
3197: lp_thpv_rec.tsu_code := 'CANCELED';
3198:

Line 3199: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(

3195: lp_thpv_rec := lp_thpv_empty_rec;
3196: lp_thpv_rec.id := l_assettrx_rec.id;
3197: lp_thpv_rec.tsu_code := 'CANCELED';
3198:
3199: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(
3200: p_api_version => p_api_version,
3201: p_init_msg_list => OKC_API.G_FALSE,
3202: x_return_status => x_return_status,
3203: x_msg_count => x_msg_count,

Line 3263: l_fxhv_rec.source_table := 'OKL_TRX_ASSETS';

3259: FOR i IN g_trans_id_tbl.FIRST .. g_trans_id_tbl.LAST
3260: LOOP
3261: -- header record
3262: l_fxhv_rec.source_id := lx_thpv_rec.id;
3263: l_fxhv_rec.source_table := 'OKL_TRX_ASSETS';
3264: l_fxhv_rec.khr_id := lx_tlpv_rec.dnz_khr_id;
3265: l_fxhv_rec.try_id := lx_thpv_rec.try_id;
3266: -- line record
3267: l_fxlv_rec.source_id := lx_tlpv_rec.id;

Line 3511: SUBTYPE thpv_rec_type IS OKL_TRX_ASSETS_PUB.thpv_rec_type;

3507: x_msg_data OUT NOCOPY VARCHAR2,
3508: p_order_line_id IN NUMBER -- SECHAWLA 21-OCT-04 3924244
3509: ) IS
3510:
3511: SUBTYPE thpv_rec_type IS OKL_TRX_ASSETS_PUB.thpv_rec_type;
3512: SUBTYPE tlpv_rec_type IS OKL_TXL_ASSETS_PUB.tlpv_rec_type;
3513:
3514: -- This cursor is used to validate Header ID
3515: CURSOR l_orderheaders_csr(p_header_id NUMBER) IS

Line 3606: FROM OKL_TRX_ASSETS h, okl_txl_assets_v l

3602: -- This cursor is used to get all the pending transactions for an asset. These transactions are to be cancelled
3603: -- once the asset is retired.
3604: CURSOR l_assettrx_csr(p_financial_asset_id NUMBER) IS
3605: SELECT h.id
3606: FROM OKL_TRX_ASSETS h, okl_txl_assets_v l
3607: WHERE h.id = l.tas_id
3608: AND h.tsu_code IN ('ENTERED', 'ERROR')
3609: AND l.kle_id = p_financial_asset_id;
3610:

Line 3678: FROM OKL_TRX_ASSETS h, OKL_TXL_ASSETS_B l

3674: --SECHAWLA 10-FEB-06 5016156
3675: CURSOR l_offlseassettrx_csr(cp_trx_date IN DATE, cp_asset_number IN VARCHAR2) IS
3676: SELECT h.tsu_code, h.tas_type, h.date_trans_occurred, l.dnz_asset_id,
3677: l.asset_number, l.kle_id ,l.DNZ_KHR_ID
3678: FROM OKL_TRX_ASSETS h, OKL_TXL_ASSETS_B l
3679: WHERE h.id = l.tas_id
3680: AND h.date_trans_occurred <= cp_trx_date
3681: AND h.tas_type in ('AMT','AUD','AUS')
3682: AND l.asset_number = cp_asset_number;

Line 4705: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def( p_api_version => p_api_version,

4701: -- RRAVIKIR Legal Entity Changes
4702: lp_thpv_rec.legal_entity_id := l_legal_entity_id;
4703: -- Legal Entity Changes End
4704:
4705: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def( p_api_version => p_api_version,
4706: p_init_msg_list => OKC_API.G_FALSE,
4707: x_return_status => x_return_status,
4708: x_msg_count => x_msg_count,
4709: x_msg_data => x_msg_data,

Line 4789: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(

4785: lp_thpv_rec := lp_thpv_empty_rec;
4786: lp_thpv_rec.id := lx_thpv_rec.id;
4787: lp_thpv_rec.total_match_amount := lx_total_amount;
4788:
4789: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(
4790: p_api_version => p_api_version,
4791: p_init_msg_list => OKC_API.G_FALSE,
4792: x_return_status => x_return_status,
4793: x_msg_count => x_msg_count,

Line 4900: -- Loop thru all the pending transactions in okl_trx_assets_v and okl_txl_assets_v

4896: -- commented call to expire_item djanaswa bug 6736148 end
4897:
4898:
4899:
4900: -- Loop thru all the pending transactions in okl_trx_assets_v and okl_txl_assets_v
4901: -- and update the status to 'CANCELED'
4902:
4903: FOR l_assettrx_rec IN l_assettrx_csr(l_kle_id) LOOP
4904: -- update the staus (tsu_code) in okl_trx_assets_v

Line 4904: -- update the staus (tsu_code) in okl_trx_assets_v

4900: -- Loop thru all the pending transactions in okl_trx_assets_v and okl_txl_assets_v
4901: -- and update the status to 'CANCELED'
4902:
4903: FOR l_assettrx_rec IN l_assettrx_csr(l_kle_id) LOOP
4904: -- update the staus (tsu_code) in okl_trx_assets_v
4905: lp_thpv_rec := lp_thpv_empty_rec;
4906: lp_thpv_rec.id := l_assettrx_rec.id;
4907: lp_thpv_rec.tsu_code := 'CANCELED';
4908: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(

Line 4908: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(

4904: -- update the staus (tsu_code) in okl_trx_assets_v
4905: lp_thpv_rec := lp_thpv_empty_rec;
4906: lp_thpv_rec.id := l_assettrx_rec.id;
4907: lp_thpv_rec.tsu_code := 'CANCELED';
4908: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(
4909: p_api_version => p_api_version,
4910: p_init_msg_list => OKC_API.G_FALSE,
4911: x_return_status => x_return_status,
4912: x_msg_count => x_msg_count,

Line 4969: l_fxhv_rec.source_table := 'OKL_TRX_ASSETS';

4965: FOR i IN g_trans_id_tbl.FIRST .. g_trans_id_tbl.LAST
4966: LOOP
4967: -- header record
4968: l_fxhv_rec.source_id := lx_thpv_rec.id;
4969: l_fxhv_rec.source_table := 'OKL_TRX_ASSETS';
4970: l_fxhv_rec.khr_id := lx_tlpv_rec.dnz_khr_id;
4971: l_fxhv_rec.try_id := lx_thpv_rec.try_id;
4972: -- line record
4973: l_fxlv_rec.source_id := lx_tlpv_rec.id;