APPS.OKL_OPEN_INTERFACE_PVT dependencies on OKL_LA_RELEASE_ASSETS_UV

Line 1773: x_asset_id OUT NOCOPY OKL_LA_RELEASE_ASSETS_UV.ASSET_ID%TYPE

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

Line 1779: FROM OKL_LA_RELEASE_ASSETS_UV

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

Line 2171: x_asset_id OKL_LA_RELEASE_ASSETS_UV.ASSET_ID%TYPE;

2167: l_supp_name OKL_PARTY_ROLES_INTERFACE.SERVICE_VENDOR_NAME%TYPE;
2168: l_supp_id OKL_PARTY_ROLES_INTERFACE.SERVICE_VENDOR_ID%TYPE;
2169:
2170: x_id1 okl_strmtyp_source_v.id1%TYPE;
2171: x_asset_id OKL_LA_RELEASE_ASSETS_UV.ASSET_ID%TYPE;
2172: x_release_asset VARCHAR2(1) := 'N';
2173:
2174: halt_validation EXCEPTION;
2175: l_return_status VARCHAR2(1);

Line 26451: p_asset_id IN OKL_LA_RELEASE_ASSETS_UV.ASSET_ID%TYPE,

26447: x_msg_data OUT NOCOPY VARCHAR2,
26448: p_chr_id IN VARCHAR2,
26449: p_contract_number IN VARCHAR2,
26450: p_asset_number IN VARCHAR2,
26451: p_asset_id IN OKL_LA_RELEASE_ASSETS_UV.ASSET_ID%TYPE,
26452: p_line_number IN NUMBER,
26453: p_re_lease_yn IN VARCHAR2, -- Bug #15992711 : added new parameter, to pass value of re_lease_yn flag
26454: p_install_site_id IN okl_lines_interface.install_site_id%TYPE,
26455: p_install_site_num IN okl_lines_interface.install_site_number%TYPE,

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

28614: FROM okl_k_headers
28615: WHERE deal_type = 'LOAN-REVOLVING'
28616: AND id = p_chr_id;
28617:
28618: CURSOR c_asset (p_asset_number OKL_LA_RELEASE_ASSETS_UV.ASSET_NUMBER%TYPE) IS
28619: SELECT asset_id
28620: FROM FA_ADDITIONS_B
28621: WHERE asset_number = p_asset_number;
28622:

Line 28637: x_asset_id OKL_LA_RELEASE_ASSETS_UV.ASSET_ID%TYPE;

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