APPS.OKL_OPEN_INTERFACE_PVT dependencies on OKX_ASSETS_V

Line 22999: x_id1 OUT NOCOPY okx_assets_v.id1%TYPE,

22995: x_msg_data OUT NOCOPY VARCHAR2,
22996: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
22997: p_line_number IN okl_lines_interface.line_number%TYPE,
22998: p_asset_number IN okl_lines_interface.asset_number%TYPE,
22999: x_id1 OUT NOCOPY okx_assets_v.id1%TYPE,
23000: x_id2 OUT NOCOPY okx_assets_v.id2%TYPE
23001: ) IS
23002:
23003: l_proc_name VARCHAR2(35) := 'GET_ASSET_ID';

Line 23000: x_id2 OUT NOCOPY okx_assets_v.id2%TYPE

22996: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
22997: p_line_number IN okl_lines_interface.line_number%TYPE,
22998: p_asset_number IN okl_lines_interface.asset_number%TYPE,
22999: x_id1 OUT NOCOPY okx_assets_v.id1%TYPE,
23000: x_id2 OUT NOCOPY okx_assets_v.id2%TYPE
23001: ) IS
23002:
23003: l_proc_name VARCHAR2(35) := 'GET_ASSET_ID';
23004: asset_failed EXCEPTION;

Line 23005: l_id1 okx_assets_v.id1%TYPE;

23001: ) IS
23002:
23003: l_proc_name VARCHAR2(35) := 'GET_ASSET_ID';
23004: asset_failed EXCEPTION;
23005: l_id1 okx_assets_v.id1%TYPE;
23006: l_id2 okx_assets_v.id2%TYPE;
23007:
23008: CURSOR asset_csr (p_asset_number VARCHAR2) IS
23009: SELECT id1,

Line 23006: l_id2 okx_assets_v.id2%TYPE;

23002:
23003: l_proc_name VARCHAR2(35) := 'GET_ASSET_ID';
23004: asset_failed EXCEPTION;
23005: l_id1 okx_assets_v.id1%TYPE;
23006: l_id2 okx_assets_v.id2%TYPE;
23007:
23008: CURSOR asset_csr (p_asset_number VARCHAR2) IS
23009: SELECT id1,
23010: id2

Line 23011: FROM okx_assets_v

23007:
23008: CURSOR asset_csr (p_asset_number VARCHAR2) IS
23009: SELECT id1,
23010: id2
23011: FROM okx_assets_v
23012: WHERE asset_number = p_asset_number
23013: AND SYSDATE BETWEEN NVL(start_date_active, SYSDATE) AND NVL(end_date_active, SYSDATE);
23014:
23015: BEGIN

Line 27544: x_id1 okx_assets_v.id1%TYPE;

27540: x_customer_account_id NUMBER;
27541: x_inventory_org_id NUMBER;
27542: x_inventory_item_id NUMBER;
27543: x_lse_id NUMBER;
27544: x_id1 okx_assets_v.id1%TYPE;
27545: x_id2 okx_assets_v.id2%TYPE;
27546: l_no_of_lines NUMBER;
27547: l_ib_line_count NUMBER;
27548: -- l_new_yn VARCHAR2(1);

Line 27545: x_id2 okx_assets_v.id2%TYPE;

27541: x_inventory_org_id NUMBER;
27542: x_inventory_item_id NUMBER;
27543: x_lse_id NUMBER;
27544: x_id1 okx_assets_v.id1%TYPE;
27545: x_id2 okx_assets_v.id2%TYPE;
27546: l_no_of_lines NUMBER;
27547: l_ib_line_count NUMBER;
27548: -- l_new_yn VARCHAR2(1);
27549: x_comb_id NUMBER;