APPS.OKL_LEASE_QUOTE_PVT dependencies on OKL_LOP_PVT

Line 1363: ,x_leaseopp_rec OUT NOCOPY okl_lop_pvt.lopv_rec_type

1359: -----------------------------
1360: -- PROCEDURE get_leaseopp_rec
1361: -----------------------------
1362: PROCEDURE get_leaseopp_rec ( p_leaseopp_id IN NUMBER
1363: ,x_leaseopp_rec OUT NOCOPY okl_lop_pvt.lopv_rec_type
1364: ,x_return_status OUT NOCOPY VARCHAR2 ) IS
1365:
1366: l_program_name CONSTANT VARCHAR2(30) := 'get_leaseopp_rec';
1367: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_program_name;

Line 2519: l_lease_opp_rec okl_lop_pvt.lopv_rec_type;

2515: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_program_name;
2516:
2517: l_lease_qte_rec lease_qte_rec_type;
2518: x_lease_qte_rec lease_qte_rec_type;
2519: l_lease_opp_rec okl_lop_pvt.lopv_rec_type;
2520: x_lease_opp_rec okl_lop_pvt.lopv_rec_type;
2521:
2522: l_chk_lease_qte VARCHAR2(1) := 'N';
2523:

Line 2520: x_lease_opp_rec okl_lop_pvt.lopv_rec_type;

2516:
2517: l_lease_qte_rec lease_qte_rec_type;
2518: x_lease_qte_rec lease_qte_rec_type;
2519: l_lease_opp_rec okl_lop_pvt.lopv_rec_type;
2520: x_lease_opp_rec okl_lop_pvt.lopv_rec_type;
2521:
2522: l_chk_lease_qte VARCHAR2(1) := 'N';
2523:
2524: CURSOR c_chk_accept_lease_qte(p_leaseopp_id IN NUMBER) IS

Line 2592: okl_lop_pvt.update_row(

2588: RAISE OKL_API.G_EXCEPTION_ERROR;
2589: END IF;
2590:
2591: l_lease_opp_rec.status := 'ACCEPTED';
2592: okl_lop_pvt.update_row(
2593: p_api_version => G_API_VERSION
2594: ,p_init_msg_list => G_FALSE
2595: ,x_return_status => x_return_status
2596: ,x_msg_count => x_msg_count

Line 2850: l_lease_opp_rec okl_lop_pvt.lopv_rec_type;

2846: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_program_name;
2847:
2848: l_lease_qte_rec lease_qte_rec_type;
2849: x_lease_qte_rec lease_qte_rec_type;
2850: l_lease_opp_rec okl_lop_pvt.lopv_rec_type;
2851: x_lease_opp_rec okl_lop_pvt.lopv_rec_type;
2852:
2853: l_chk_lease_qte VARCHAR2(1) := 'N';
2854:

Line 2851: x_lease_opp_rec okl_lop_pvt.lopv_rec_type;

2847:
2848: l_lease_qte_rec lease_qte_rec_type;
2849: x_lease_qte_rec lease_qte_rec_type;
2850: l_lease_opp_rec okl_lop_pvt.lopv_rec_type;
2851: x_lease_opp_rec okl_lop_pvt.lopv_rec_type;
2852:
2853: l_chk_lease_qte VARCHAR2(1) := 'N';
2854:
2855: CURSOR c_chk_accept_lease_qte(p_leaseopp_id IN NUMBER) IS

Line 2904: okl_lop_pvt.update_row(

2900: RAISE OKL_API.G_EXCEPTION_ERROR;
2901: END IF;
2902:
2903: l_lease_opp_rec.status := 'INCOMPLETE';
2904: okl_lop_pvt.update_row(
2905: p_api_version => G_API_VERSION
2906: ,p_init_msg_list => G_FALSE
2907: ,x_return_status => x_return_status
2908: ,x_msg_count => x_msg_count