DBA Data[Home] [Help]

APPS.OKL_OPEN_INTERFACE_PVT dependencies on OKL_TXD_ASSETS_B

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

26282: END create_lessee_as_vendor;
26283:
26284: ------------------------------------------------------------------------------
26285: -- PROCEDURE get_txd_id
26286: -- This procedure gets okl_txd_assets_b.id, required to update in case of
26287: -- released asset import with mutiple tax books.
26288: -- Calls:
26289: -- Called By:
26290: -- load_input_record

Line 26299: x_txd_id OUT NOCOPY OKL_TXD_ASSETS_B.ID%TYPE

26295: x_msg_data OUT NOCOPY VARCHAR2,
26296: p_contract_number IN VARCHAR2,
26297: p_tal_id IN NUMBER,
26298: p_tax_book IN VARCHAR2,
26299: x_txd_id OUT NOCOPY OKL_TXD_ASSETS_B.ID%TYPE
26300: ) IS
26301:
26302: CURSOR txd_csr (p_tal_id NUMBER,
26303: p_tax_book VARCHAR2) IS

Line 26305: FROM okl_txd_assets_b

26301:
26302: CURSOR txd_csr (p_tal_id NUMBER,
26303: p_tax_book VARCHAR2) IS
26304: SELECT id
26305: FROM okl_txd_assets_b
26306: WHERE tal_id = p_tal_id
26307: AND tax_book = p_tax_book;
26308:
26309: l_proc_name VARCHAR2(35) := 'GET_TXD_ID';

Line 28638: x_txd_id OKL_TXD_ASSETS_B.ID%TYPE;

28634: l_prev_tax_book VARCHAR2(15) := 'NULL';
28635:
28636: x_release_asset VARCHAR2(1) := 'N';
28637: x_asset_id OKL_LA_RELEASE_ASSETS_UV.ASSET_ID%TYPE;
28638: x_txd_id OKL_TXD_ASSETS_B.ID%TYPE;
28639:
28640: x_party_pmnt_hdr_tbl_out pphv_tbl_type;
28641: l_counter NUMBER;
28642: