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 1866: FROM OKL_TRX_ASSETS h, OKL_TXL_ASSETS_B l

1862: --Bug# 9838432: Added parameter cp_kle_id
1863: CURSOR l_offlseassettrx_csr(cp_trx_date IN DATE, cp_asset_number IN VARCHAR2, cp_kle_id IN NUMBER) IS
1864: SELECT h.tsu_code, h.tas_type, h.date_trans_occurred, l.dnz_asset_id,
1865: l.asset_number, l.kle_id ,l.DNZ_KHR_ID
1866: FROM OKL_TRX_ASSETS h, OKL_TXL_ASSETS_B l
1867: WHERE h.id = l.tas_id
1868: AND h.date_trans_occurred <= cp_trx_date
1869: AND h.tas_type in ('AMT','AUD','AUS')
1870: AND l.asset_number = cp_asset_number

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

2955: -- RRAVIKIR Legal Entity Changes
2956: lp_thpv_rec.legal_entity_id := p_legal_entity_id;
2957: -- Legal Entity Changes End
2958:
2959: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def( p_api_version => p_api_version,
2960: p_init_msg_list => OKC_API.G_FALSE,
2961: x_return_status => x_return_status,
2962: x_msg_count => x_msg_count,
2963: x_msg_data => x_msg_data,

Line 3072: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(

3068: lp_thpv_rec := lp_thpv_empty_rec;
3069: lp_thpv_rec.id := lx_thpv_rec.id;
3070: lp_thpv_rec.total_match_amount := lx_total_amount;
3071:
3072: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(
3073: p_api_version => p_api_version,
3074: p_init_msg_list => OKC_API.G_FALSE,
3075: x_return_status => x_return_status,
3076: x_msg_count => x_msg_count,

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

3194:
3195:
3196:
3197:
3198: -- Loop thru all the pending transactions in okl_trx_assets_v and okl_txl_assets_v
3199: -- and update the status to 'CANCELED'
3200:
3201: FOR l_assettrx_rec IN l_assettrx_csr LOOP
3202: -- update the staus (tsu_code) in okl_trx_assets_v

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

3198: -- Loop thru all the pending transactions in okl_trx_assets_v and okl_txl_assets_v
3199: -- and update the status to 'CANCELED'
3200:
3201: FOR l_assettrx_rec IN l_assettrx_csr LOOP
3202: -- update the staus (tsu_code) in okl_trx_assets_v
3203: lp_thpv_rec := lp_thpv_empty_rec;
3204: lp_thpv_rec.id := l_assettrx_rec.id;
3205: lp_thpv_rec.tsu_code := 'CANCELED';
3206:

Line 3207: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(

3203: lp_thpv_rec := lp_thpv_empty_rec;
3204: lp_thpv_rec.id := l_assettrx_rec.id;
3205: lp_thpv_rec.tsu_code := 'CANCELED';
3206:
3207: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(
3208: p_api_version => p_api_version,
3209: p_init_msg_list => OKC_API.G_FALSE,
3210: x_return_status => x_return_status,
3211: x_msg_count => x_msg_count,

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

3267: FOR i IN g_trans_id_tbl.FIRST .. g_trans_id_tbl.LAST
3268: LOOP
3269: -- header record
3270: l_fxhv_rec.source_id := lx_thpv_rec.id;
3271: l_fxhv_rec.source_table := 'OKL_TRX_ASSETS';
3272: l_fxhv_rec.khr_id := lx_tlpv_rec.dnz_khr_id;
3273: l_fxhv_rec.try_id := lx_thpv_rec.try_id;
3274: -- line record
3275: l_fxlv_rec.source_id := lx_tlpv_rec.id;

Line 3519: SUBTYPE thpv_rec_type IS OKL_TRX_ASSETS_PUB.thpv_rec_type;

3515: x_msg_data OUT NOCOPY VARCHAR2,
3516: p_order_line_id IN NUMBER -- SECHAWLA 21-OCT-04 3924244
3517: ) IS
3518:
3519: SUBTYPE thpv_rec_type IS OKL_TRX_ASSETS_PUB.thpv_rec_type;
3520: SUBTYPE tlpv_rec_type IS OKL_TXL_ASSETS_PUB.tlpv_rec_type;
3521:
3522: -- This cursor is used to validate Header ID
3523: CURSOR l_orderheaders_csr(p_header_id NUMBER) IS

Line 3614: FROM OKL_TRX_ASSETS h, okl_txl_assets_v l

3610: -- This cursor is used to get all the pending transactions for an asset. These transactions are to be cancelled
3611: -- once the asset is retired.
3612: CURSOR l_assettrx_csr(p_financial_asset_id NUMBER) IS
3613: SELECT h.id
3614: FROM OKL_TRX_ASSETS h, okl_txl_assets_v l
3615: WHERE h.id = l.tas_id
3616: AND h.tsu_code IN ('ENTERED', 'ERROR')
3617: AND l.kle_id = p_financial_asset_id;
3618:

Line 3687: FROM OKL_TRX_ASSETS h, OKL_TXL_ASSETS_B l

3683: --Bug# 9838432: Added parameter cp_kle_id
3684: CURSOR l_offlseassettrx_csr(cp_trx_date IN DATE, cp_asset_number IN VARCHAR2, cp_kle_id IN NUMBER) IS
3685: SELECT h.tsu_code, h.tas_type, h.date_trans_occurred, l.dnz_asset_id,
3686: l.asset_number, l.kle_id ,l.DNZ_KHR_ID
3687: FROM OKL_TRX_ASSETS h, OKL_TXL_ASSETS_B l
3688: WHERE h.id = l.tas_id
3689: AND h.date_trans_occurred <= cp_trx_date
3690: AND h.tas_type in ('AMT','AUD','AUS')
3691: AND l.asset_number = cp_asset_number

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

4716: -- RRAVIKIR Legal Entity Changes
4717: lp_thpv_rec.legal_entity_id := l_legal_entity_id;
4718: -- Legal Entity Changes End
4719:
4720: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def( p_api_version => p_api_version,
4721: p_init_msg_list => OKC_API.G_FALSE,
4722: x_return_status => x_return_status,
4723: x_msg_count => x_msg_count,
4724: x_msg_data => x_msg_data,

Line 4804: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(

4800: lp_thpv_rec := lp_thpv_empty_rec;
4801: lp_thpv_rec.id := lx_thpv_rec.id;
4802: lp_thpv_rec.total_match_amount := lx_total_amount;
4803:
4804: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(
4805: p_api_version => p_api_version,
4806: p_init_msg_list => OKC_API.G_FALSE,
4807: x_return_status => x_return_status,
4808: x_msg_count => x_msg_count,

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

4911: -- commented call to expire_item djanaswa bug 6736148 end
4912:
4913:
4914:
4915: -- Loop thru all the pending transactions in okl_trx_assets_v and okl_txl_assets_v
4916: -- and update the status to 'CANCELED'
4917:
4918: FOR l_assettrx_rec IN l_assettrx_csr(l_kle_id) LOOP
4919: -- update the staus (tsu_code) in okl_trx_assets_v

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

4915: -- Loop thru all the pending transactions in okl_trx_assets_v and okl_txl_assets_v
4916: -- and update the status to 'CANCELED'
4917:
4918: FOR l_assettrx_rec IN l_assettrx_csr(l_kle_id) LOOP
4919: -- update the staus (tsu_code) in okl_trx_assets_v
4920: lp_thpv_rec := lp_thpv_empty_rec;
4921: lp_thpv_rec.id := l_assettrx_rec.id;
4922: lp_thpv_rec.tsu_code := 'CANCELED';
4923: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(

Line 4923: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(

4919: -- update the staus (tsu_code) in okl_trx_assets_v
4920: lp_thpv_rec := lp_thpv_empty_rec;
4921: lp_thpv_rec.id := l_assettrx_rec.id;
4922: lp_thpv_rec.tsu_code := 'CANCELED';
4923: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(
4924: p_api_version => p_api_version,
4925: p_init_msg_list => OKC_API.G_FALSE,
4926: x_return_status => x_return_status,
4927: x_msg_count => x_msg_count,

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

4980: FOR i IN g_trans_id_tbl.FIRST .. g_trans_id_tbl.LAST
4981: LOOP
4982: -- header record
4983: l_fxhv_rec.source_id := lx_thpv_rec.id;
4984: l_fxhv_rec.source_table := 'OKL_TRX_ASSETS';
4985: l_fxhv_rec.khr_id := lx_tlpv_rec.dnz_khr_id;
4986: l_fxhv_rec.try_id := lx_thpv_rec.try_id;
4987: -- line record
4988: l_fxlv_rec.source_id := lx_tlpv_rec.id;