APPS.OKL_LIKE_KIND_EXCHANGE_PVT dependencies on OKL_TRX_ASSETS

Line 12: FROM okl_trx_assets trx, okl_txl_assets_v txl, okl_txd_assets_v txd

8: l_total_match_amount NUMBER;
9:
10: CURSOR get_total_match_amt_csr (p_req_asset_id NUMBER, p_tax_book_code VARCHAR2) IS
11: SELECT trx.req_asset_id, sum(trx.total_match_amount)
12: FROM okl_trx_assets trx, okl_txl_assets_v txl, okl_txd_assets_v txd
13: WHERE trx.id = txl.tas_id
14: AND txl.id = txd.tal_id
15: AND trx.total_match_amount IS NOT NULL
16: AND txd.tax_book = p_tax_book_code

Line 543: l_tas_type CONSTANT OKL_TRX_ASSETS.TAS_TYPE%TYPE := 'LKE';

539: IS
540: -- constants
541: l_api_name CONSTANT VARCHAR2(50) := 'CREATE_LIKE_KIND_EXCHANGE';
542: l_api_version CONSTANT NUMBER := 1.0;
543: l_tas_type CONSTANT OKL_TRX_ASSETS.TAS_TYPE%TYPE := 'LKE';
544: l_tal_type CONSTANT OKL_TXL_ASSETS_V.TAL_TYPE%TYPE := 'LKE';
545: l_tsu_code CONSTANT OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
546: l_try_name CONSTANT OKL_TRX_TYPES_V.NAME%TYPE := 'Like Kind Exchange';
547: --variables

Line 564: l_tasv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;

560: l_mass_cpy_book VARCHAR2(1) :='?';
561: l_match_amount_found VARCHAR2(1) := 'N';
562: -- record and table structure variables
563: l_req_asset_tbl req_asset_tbl_type;
564: l_tasv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;
565: l_talv_rec OKL_TXL_ASSETS_PUB.tlpv_rec_type;
566: l_txdv_rec OKL_TXD_ASSETS_PUB.adpv_rec_type;
567: x_tasv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;
568: x_talv_rec OKL_TXL_ASSETS_PUB.tlpv_rec_type;

Line 567: x_tasv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;

563: l_req_asset_tbl req_asset_tbl_type;
564: l_tasv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;
565: l_talv_rec OKL_TXL_ASSETS_PUB.tlpv_rec_type;
566: l_txdv_rec OKL_TXD_ASSETS_PUB.adpv_rec_type;
567: x_tasv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;
568: x_talv_rec OKL_TXL_ASSETS_PUB.tlpv_rec_type;
569: x_txdv_rec OKL_TXD_ASSETS_PUB.adpv_rec_type;
570: l_asdt_rec asset_details_rec_type;
571: l_txdt_rec asset_details_rec_type;

Line 823: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def(

819: END IF;
820:
821:
822: -- call the trx assets public api to create transaction header record
823: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def(
824: p_api_version => p_api_version,
825: p_init_msg_list => p_init_msg_list,
826: x_return_status => l_return_status,
827: x_msg_count => x_msg_count,