APPS.OKL_OPEN_INTERFACE_PVT dependencies on OKL_LA_RELEASE_ASSETS_UV

Line 1770: x_asset_id OUT NOCOPY OKL_LA_RELEASE_ASSETS_UV.ASSET_ID%TYPE

1766: p_asset_number IN VARCHAR2,
1767: p_line_number IN NUMBER,
1768: p_org_id IN NUMBER,
1769: x_release_asset OUT NOCOPY VARCHAR2,
1770: x_asset_id OUT NOCOPY OKL_LA_RELEASE_ASSETS_UV.ASSET_ID%TYPE
1771: ) IS
1772:
1773: CURSOR release_csr (p_asset_number VARCHAR2,
1774: p_org_id NUMBER) IS

Line 1776: FROM OKL_LA_RELEASE_ASSETS_UV

1772:
1773: CURSOR release_csr (p_asset_number VARCHAR2,
1774: p_org_id NUMBER) IS
1775: SELECT asset_id
1776: FROM OKL_LA_RELEASE_ASSETS_UV
1777: WHERE asset_number = p_asset_number
1778: AND organization_id = p_org_id;
1779:
1780: l_proc_name VARCHAR2(35) := 'CHECK_FOR_RELEASE_ASSET';

Line 2077: x_asset_id OKL_LA_RELEASE_ASSETS_UV.ASSET_ID%TYPE;

2073: l_supp_name OKL_PARTY_ROLES_INTERFACE.SERVICE_VENDOR_NAME%TYPE;
2074: l_supp_id OKL_PARTY_ROLES_INTERFACE.SERVICE_VENDOR_ID%TYPE;
2075:
2076: x_id1 okl_strmtyp_source_v.id1%TYPE;
2077: x_asset_id OKL_LA_RELEASE_ASSETS_UV.ASSET_ID%TYPE;
2078: x_release_asset VARCHAR2(1) := 'N';
2079:
2080: halt_validation EXCEPTION;
2081: l_return_status VARCHAR2(1);

Line 26196: p_asset_id IN OKL_LA_RELEASE_ASSETS_UV.ASSET_ID%TYPE,

26192: x_msg_data OUT NOCOPY VARCHAR2,
26193: p_chr_id IN VARCHAR2,
26194: p_contract_number IN VARCHAR2,
26195: p_asset_number IN VARCHAR2,
26196: p_asset_id IN OKL_LA_RELEASE_ASSETS_UV.ASSET_ID%TYPE,
26197: p_line_number IN NUMBER,
26198: p_install_site_id IN okl_lines_interface.install_site_id%TYPE,
26199: p_install_site_num IN okl_lines_interface.install_site_number%TYPE,
26200: p_unit_price IN okl_lines_interface.original_cost%TYPE,

Line 28321: CURSOR c_asset (p_asset_number OKL_LA_RELEASE_ASSETS_UV.ASSET_NUMBER%TYPE) IS

28317: FROM okl_k_headers
28318: WHERE deal_type = 'LOAN-REVOLVING'
28319: AND id = p_chr_id;
28320:
28321: CURSOR c_asset (p_asset_number OKL_LA_RELEASE_ASSETS_UV.ASSET_NUMBER%TYPE) IS
28322: SELECT asset_id
28323: FROM FA_ADDITIONS_B
28324: WHERE asset_number = p_asset_number;
28325:

Line 28340: x_asset_id OKL_LA_RELEASE_ASSETS_UV.ASSET_ID%TYPE;

28336: l_prev_asset_number VARCHAR2(15) := 'NULL';
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;