DBA Data[Home] [Help]

APPS.OKL_ACTIVATE_ASSET_PVT dependencies on OKL_TRX_ASSETS_PUB

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