DBA Data[Home] [Help]

APPS.OKL_LEASE_QUOTE_PVT dependencies on OKL_LOP_PVT

Line 1389: ,x_leaseopp_rec OUT NOCOPY okl_lop_pvt.lopv_rec_type

1385: -----------------------------
1386: -- PROCEDURE get_leaseopp_rec
1387: -----------------------------
1388: PROCEDURE get_leaseopp_rec ( p_leaseopp_id IN NUMBER
1389: ,x_leaseopp_rec OUT NOCOPY okl_lop_pvt.lopv_rec_type
1390: ,x_return_status OUT NOCOPY VARCHAR2 ) IS
1391:
1392: l_program_name CONSTANT VARCHAR2(30) := 'get_leaseopp_rec';
1393: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_program_name;

Line 2618: l_lease_opp_rec okl_lop_pvt.lopv_rec_type;

2614: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_program_name;
2615:
2616: l_lease_qte_rec lease_qte_rec_type;
2617: x_lease_qte_rec lease_qte_rec_type;
2618: l_lease_opp_rec okl_lop_pvt.lopv_rec_type;
2619: x_lease_opp_rec okl_lop_pvt.lopv_rec_type;
2620:
2621: l_chk_lease_qte VARCHAR2(1) := 'N';
2622:

Line 2619: x_lease_opp_rec okl_lop_pvt.lopv_rec_type;

2615:
2616: l_lease_qte_rec lease_qte_rec_type;
2617: x_lease_qte_rec lease_qte_rec_type;
2618: l_lease_opp_rec okl_lop_pvt.lopv_rec_type;
2619: x_lease_opp_rec okl_lop_pvt.lopv_rec_type;
2620:
2621: l_chk_lease_qte VARCHAR2(1) := 'N';
2622:
2623: CURSOR c_chk_accept_lease_qte(p_leaseopp_id IN NUMBER) IS

Line 2692: okl_lop_pvt.update_row(

2688: RAISE OKL_API.G_EXCEPTION_ERROR;
2689: END IF;
2690:
2691: l_lease_opp_rec.status := 'ACCEPTED';
2692: okl_lop_pvt.update_row(
2693: p_api_version => G_API_VERSION
2694: ,p_init_msg_list => G_FALSE
2695: ,x_return_status => x_return_status
2696: ,x_msg_count => x_msg_count

Line 2950: l_lease_opp_rec okl_lop_pvt.lopv_rec_type;

2946: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_program_name;
2947:
2948: l_lease_qte_rec lease_qte_rec_type;
2949: x_lease_qte_rec lease_qte_rec_type;
2950: l_lease_opp_rec okl_lop_pvt.lopv_rec_type;
2951: x_lease_opp_rec okl_lop_pvt.lopv_rec_type;
2952:
2953: l_chk_lease_qte VARCHAR2(1) := 'N';
2954:

Line 2951: x_lease_opp_rec okl_lop_pvt.lopv_rec_type;

2947:
2948: l_lease_qte_rec lease_qte_rec_type;
2949: x_lease_qte_rec lease_qte_rec_type;
2950: l_lease_opp_rec okl_lop_pvt.lopv_rec_type;
2951: x_lease_opp_rec okl_lop_pvt.lopv_rec_type;
2952:
2953: l_chk_lease_qte VARCHAR2(1) := 'N';
2954:
2955: CURSOR c_chk_accept_lease_qte(p_leaseopp_id IN NUMBER) IS

Line 3004: okl_lop_pvt.update_row(

3000: RAISE OKL_API.G_EXCEPTION_ERROR;
3001: END IF;
3002:
3003: l_lease_opp_rec.status := 'INCOMPLETE';
3004: okl_lop_pvt.update_row(
3005: p_api_version => G_API_VERSION
3006: ,p_init_msg_list => G_FALSE
3007: ,x_return_status => x_return_status
3008: ,x_msg_count => x_msg_count