APPS.OKL_OPEN_INTERFACE_PVT dependencies on OKX_ASSETS_V

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

22806: x_msg_data OUT NOCOPY VARCHAR2,
22807: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
22808: p_line_number IN okl_lines_interface.line_number%TYPE,
22809: p_asset_number IN okl_lines_interface.asset_number%TYPE,
22810: x_id1 OUT NOCOPY okx_assets_v.id1%TYPE,
22811: x_id2 OUT NOCOPY okx_assets_v.id2%TYPE
22812: ) IS
22813:
22814: l_proc_name VARCHAR2(35) := 'GET_ASSET_ID';

Line 22811: x_id2 OUT NOCOPY okx_assets_v.id2%TYPE

22807: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
22808: p_line_number IN okl_lines_interface.line_number%TYPE,
22809: p_asset_number IN okl_lines_interface.asset_number%TYPE,
22810: x_id1 OUT NOCOPY okx_assets_v.id1%TYPE,
22811: x_id2 OUT NOCOPY okx_assets_v.id2%TYPE
22812: ) IS
22813:
22814: l_proc_name VARCHAR2(35) := 'GET_ASSET_ID';
22815: asset_failed EXCEPTION;

Line 22816: l_id1 okx_assets_v.id1%TYPE;

22812: ) IS
22813:
22814: l_proc_name VARCHAR2(35) := 'GET_ASSET_ID';
22815: asset_failed EXCEPTION;
22816: l_id1 okx_assets_v.id1%TYPE;
22817: l_id2 okx_assets_v.id2%TYPE;
22818:
22819: CURSOR asset_csr (p_asset_number VARCHAR2) IS
22820: SELECT id1,

Line 22817: l_id2 okx_assets_v.id2%TYPE;

22813:
22814: l_proc_name VARCHAR2(35) := 'GET_ASSET_ID';
22815: asset_failed EXCEPTION;
22816: l_id1 okx_assets_v.id1%TYPE;
22817: l_id2 okx_assets_v.id2%TYPE;
22818:
22819: CURSOR asset_csr (p_asset_number VARCHAR2) IS
22820: SELECT id1,
22821: id2

Line 22822: FROM okx_assets_v

22818:
22819: CURSOR asset_csr (p_asset_number VARCHAR2) IS
22820: SELECT id1,
22821: id2
22822: FROM okx_assets_v
22823: WHERE asset_number = p_asset_number
22824: AND SYSDATE BETWEEN NVL(start_date_active, SYSDATE) AND NVL(end_date_active, SYSDATE);
22825:
22826: BEGIN

Line 27272: x_id1 okx_assets_v.id1%TYPE;

27268: x_customer_account_id NUMBER;
27269: x_inventory_org_id NUMBER;
27270: x_inventory_item_id NUMBER;
27271: x_lse_id NUMBER;
27272: x_id1 okx_assets_v.id1%TYPE;
27273: x_id2 okx_assets_v.id2%TYPE;
27274: l_no_of_lines NUMBER;
27275: l_ib_line_count NUMBER;
27276: -- l_new_yn VARCHAR2(1);

Line 27273: x_id2 okx_assets_v.id2%TYPE;

27269: x_inventory_org_id NUMBER;
27270: x_inventory_item_id NUMBER;
27271: x_lse_id NUMBER;
27272: x_id1 okx_assets_v.id1%TYPE;
27273: x_id2 okx_assets_v.id2%TYPE;
27274: l_no_of_lines NUMBER;
27275: l_ib_line_count NUMBER;
27276: -- l_new_yn VARCHAR2(1);
27277: x_comb_id NUMBER;