DBA Data[Home] [Help]

APPS.OKL_SPLIT_ASSET_COMP_PVT dependencies on OKL_TXD_ASSETS_B

Line 31: l_id okl_txd_assets_B.ID%TYPE;

27: l_api_version CONSTANT NUMBER := 1.0;
28: l_api_name CONSTANT VARCHAR2(30) := 'calculate_unit_cost';
29: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
30: l_dummy VARCHAR2(1) := OKL_API.G_TRUE;
31: l_id okl_txd_assets_B.ID%TYPE;
32: l_split_percent okl_txd_assets_B.SPLIT_PERCENT%TYPE;
33: l_oec okl_txl_assets_B.ORIGINAL_COST%TYPE;
34: l_units okl_txl_assets_B.CURRENT_UNITS%TYPE;
35: l_asdv_rec Okl_Asd_Pvt.asdv_rec_type;

Line 32: l_split_percent okl_txd_assets_B.SPLIT_PERCENT%TYPE;

28: l_api_name CONSTANT VARCHAR2(30) := 'calculate_unit_cost';
29: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
30: l_dummy VARCHAR2(1) := OKL_API.G_TRUE;
31: l_id okl_txd_assets_B.ID%TYPE;
32: l_split_percent okl_txd_assets_B.SPLIT_PERCENT%TYPE;
33: l_oec okl_txl_assets_B.ORIGINAL_COST%TYPE;
34: l_units okl_txl_assets_B.CURRENT_UNITS%TYPE;
35: l_asdv_rec Okl_Asd_Pvt.asdv_rec_type;
36: x_asdv_rec Okl_Asd_Pvt.asdv_rec_type;

Line 461: l_asset_number okl_txd_assets_B.ASSET_NUMBER%TYPE;

457: ) RETURN VARCHAR2
458: IS
459: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
460: l_dummy VARCHAR2(1) := OKL_API.G_TRUE;
461: l_asset_number okl_txd_assets_B.ASSET_NUMBER%TYPE;
462:
463: --cursor to check duplicate within same transaction
464: CURSOR c(p_tal_id NUMBER)
465: IS

Line 627: l_inventory_item_id okl_txd_assets_B.INVENTORY_ITEM_ID%TYPE;

623: ) RETURN VARCHAR2
624: IS
625: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
626: l_dummy VARCHAR2(1) := OKL_API.G_TRUE;
627: l_inventory_item_id okl_txd_assets_B.INVENTORY_ITEM_ID%TYPE;
628: l_inventory_item_name okx_system_items_v.NAME%TYPE;
629:
630: CURSOR c(p_tal_id NUMBER)
631: IS