DBA Data[Home] [Help]

APPS.OKL_QUOTE_TO_CONTRACT_PVT dependencies on OKL_LEASE_APPLICATIONS_B

Line 132: FROM OKL_LEASE_APPLICATIONS_B LAB

128: CURSOR l_uniq_contract_csr(p_qte_id NUMBER)
129: IS
130: SELECT LAB.REFERENCE_NUMBER LSE_APP
131: , CHR.CONTRACT_NUMBER CONTRACT_NUMBER
132: FROM OKL_LEASE_APPLICATIONS_B LAB
133: , OKL_LEASE_QUOTES_B QTE
134: , OKC_K_HEADERS_B CHR
135: , OKC_STATUSES_V CSTS
136: WHERE LAB.LEASE_OPPORTUNITY_ID = QTE.PARENT_OBJECT_ID

Line 307: p_lap_id IN OKL_LEASE_APPLICATIONS_B.ID%TYPE) IS

303: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
304: x_return_status OUT NOCOPY VARCHAR2,
305: x_msg_count OUT NOCOPY NUMBER,
306: x_msg_data OUT NOCOPY VARCHAR2,
307: p_lap_id IN OKL_LEASE_APPLICATIONS_B.ID%TYPE) IS
308: -- Variables Declarations
309: l_api_version CONSTANT NUMBER DEFAULT 1.0;
310: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'UPD_LP_STS';
311: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;