APPS.OKL_SSC_WF dependencies on OKL_TRX_ASSETS

Line 699: OKL_TRX_ASSETS TRX

695: from OKL_TXL_ITM_INSTS INX,
696: OKX_PARTY_SITE_USES_V PSU1,
697: OKX_PARTY_SITE_USES_V PSU2,
698: OKL_TXL_ASSETS_B ASX,
699: OKL_TRX_ASSETS TRX
700: where
701: INX.TAS_ID = p_tas_id
702: AND INX.TAL_TYPE = p_tal_type
703: AND ASX.KLE_ID = INX.DNZ_CLE_ID

Line 867: l_trx_date OKL_TRX_ASSETS.DATE_TRANS_OCCURRED%TYPE;

863: l_new_location_id1 VARCHAR2(100);
864: l_new_location_id2 VARCHAR2(100);
865: l_old_location_id1 VARCHAR2(100);
866: l_old_location_id2 VARCHAR2(100);
867: l_trx_date OKL_TRX_ASSETS.DATE_TRANS_OCCURRED%TYPE;
868: l_asset_id OKC_K_LINES_V.ID%TYPE;
869: l_party_site_id okx_party_site_uses_v.PARTY_SITE_ID%TYPE;
870: l_location_id okx_party_site_uses_v.LOCATION_ID%TYPE;
871:

Line 873: l_trxv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;

869: l_party_site_id okx_party_site_uses_v.PARTY_SITE_ID%TYPE;
870: l_location_id okx_party_site_uses_v.LOCATION_ID%TYPE;
871:
872: l_loc_rec OKL_BLK_AST_UPD_PUB.blk_rec_type;
873: l_trxv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;
874: x_trxv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;
875:
876: CURSOR okl_loc_csr (p_id1 IN OKL_TXL_ITM_INSTS.OBJECT_ID1_NEW%TYPE, p_id2 IN OKL_TXL_ITM_INSTS.OBJECT_ID2_NEW%TYPE) IS
877: SELECT

Line 874: x_trxv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;

870: l_location_id okx_party_site_uses_v.LOCATION_ID%TYPE;
871:
872: l_loc_rec OKL_BLK_AST_UPD_PUB.blk_rec_type;
873: l_trxv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;
874: x_trxv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;
875:
876: CURSOR okl_loc_csr (p_id1 IN OKL_TXL_ITM_INSTS.OBJECT_ID1_NEW%TYPE, p_id2 IN OKL_TXL_ITM_INSTS.OBJECT_ID2_NEW%TYPE) IS
877: SELECT
878: PARTY_SITE_ID,