APPS.OKL_MAINTAIN_FEE_PVT dependencies on OKC_K_ITEMS_V

Line 3695: l_object1_id1 okc_k_items_v.object1_id1%type := null;

3691: lp_lastrm_rulv_rec Okl_Rule_Pub.rulv_rec_type;
3692: lx_lastrm_rulv_rec Okl_Rule_Pub.rulv_rec_type;
3693:
3694: l_chr_id okc_k_headers_b.id%type;
3695: l_object1_id1 okc_k_items_v.object1_id1%type := null;
3696: l_object1_id2 okc_k_items_v.object1_id2%type := null;
3697:
3698: l_api_name CONSTANT VARCHAR2(30) := 'create_strmtp_rul';
3699: l_api_version CONSTANT NUMBER := 1.0;

Line 3696: l_object1_id2 okc_k_items_v.object1_id2%type := null;

3692: lx_lastrm_rulv_rec Okl_Rule_Pub.rulv_rec_type;
3693:
3694: l_chr_id okc_k_headers_b.id%type;
3695: l_object1_id1 okc_k_items_v.object1_id1%type := null;
3696: l_object1_id2 okc_k_items_v.object1_id2%type := null;
3697:
3698: l_api_name CONSTANT VARCHAR2(30) := 'create_strmtp_rul';
3699: l_api_version CONSTANT NUMBER := 1.0;
3700:

Line 3703: from okc_k_items_v

3699: l_api_version CONSTANT NUMBER := 1.0;
3700:
3701: CURSOR l_strm_type_item_csr IS
3702: select object1_id1,object1_id2
3703: from okc_k_items_v
3704: where cle_id = p_cle_id
3705: and dnz_chr_id = p_chr_id;
3706:
3707: CURSOR l_strm_type_rul_csr IS

Line 3872: l_object1_id1 okc_k_items_v.object1_id1%type := null;

3868: lx_lastrm_rulv_rec Okl_Rule_Pub.rulv_rec_type;
3869:
3870: l_chr_id okc_k_headers_b.id%type;
3871: l_rgp_id okc_k_headers_b.id%type;
3872: l_object1_id1 okc_k_items_v.object1_id1%type := null;
3873: l_object1_id2 okc_k_items_v.object1_id2%type := null;
3874:
3875: l_api_name CONSTANT VARCHAR2(30) := 'update_strmtp_rul';
3876: l_api_version CONSTANT NUMBER := 1.0;

Line 3873: l_object1_id2 okc_k_items_v.object1_id2%type := null;

3869:
3870: l_chr_id okc_k_headers_b.id%type;
3871: l_rgp_id okc_k_headers_b.id%type;
3872: l_object1_id1 okc_k_items_v.object1_id1%type := null;
3873: l_object1_id2 okc_k_items_v.object1_id2%type := null;
3874:
3875: l_api_name CONSTANT VARCHAR2(30) := 'update_strmtp_rul';
3876: l_api_version CONSTANT NUMBER := 1.0;
3877:

Line 3880: from okc_k_items_v

3876: l_api_version CONSTANT NUMBER := 1.0;
3877:
3878: CURSOR l_strm_type_item_csr IS
3879: select object1_id1,object1_id2
3880: from okc_k_items_v
3881: where cle_id = p_cle_id
3882: and dnz_chr_id = p_chr_id;
3883:
3884:

Line 5470: FROM okc_k_items_v

5466: -- cursor to get okc_k_items id
5467:
5468: CURSOR get_okc_k_items_csr (fee_line_id IN NUMBER) IS
5469: SELECT id
5470: FROM okc_k_items_v
5471: WHERE cle_id = fee_line_id;
5472:
5473:
5474: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;