DBA Data[Home] [Help]

APPS.OKL_OPEN_INTERFACE_PVT dependencies on OKL_TXD_ASSETS_B

Line 26036: -- This procedure gets okl_txd_assets_b.id, required to update in case of

26032: END create_lessee_as_vendor;
26033:
26034: ------------------------------------------------------------------------------
26035: -- PROCEDURE get_txd_id
26036: -- This procedure gets okl_txd_assets_b.id, required to update in case of
26037: -- released asset import with mutiple tax books.
26038: -- Calls:
26039: -- Called By:
26040: -- load_input_record

Line 26049: x_txd_id OUT NOCOPY OKL_TXD_ASSETS_B.ID%TYPE

26045: x_msg_data OUT NOCOPY VARCHAR2,
26046: p_contract_number IN VARCHAR2,
26047: p_tal_id IN NUMBER,
26048: p_tax_book IN VARCHAR2,
26049: x_txd_id OUT NOCOPY OKL_TXD_ASSETS_B.ID%TYPE
26050: ) IS
26051:
26052: CURSOR txd_csr (p_tal_id NUMBER,
26053: p_tax_book VARCHAR2) IS

Line 26055: FROM okl_txd_assets_b

26051:
26052: CURSOR txd_csr (p_tal_id NUMBER,
26053: p_tax_book VARCHAR2) IS
26054: SELECT id
26055: FROM okl_txd_assets_b
26056: WHERE tal_id = p_tal_id
26057: AND tax_book = p_tax_book;
26058:
26059: l_proc_name VARCHAR2(35) := 'GET_TXD_ID';

Line 28341: x_txd_id OKL_TXD_ASSETS_B.ID%TYPE;

28337: l_prev_tax_book VARCHAR2(15) := 'NULL';
28338:
28339: x_release_asset VARCHAR2(1) := 'N';
28340: x_asset_id OKL_LA_RELEASE_ASSETS_UV.ASSET_ID%TYPE;
28341: x_txd_id OKL_TXD_ASSETS_B.ID%TYPE;
28342:
28343: x_party_pmnt_hdr_tbl_out pphv_tbl_type;
28344: l_counter NUMBER;
28345: