APPS.OKL_MAINTAIN_FEE_PVT dependencies on OKC_K_ITEMS_V

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

3678: lp_lastrm_rulv_rec Okl_Rule_Pub.rulv_rec_type;
3679: lx_lastrm_rulv_rec Okl_Rule_Pub.rulv_rec_type;
3680:
3681: l_chr_id okc_k_headers_b.id%type;
3682: l_object1_id1 okc_k_items_v.object1_id1%type := null;
3683: l_object1_id2 okc_k_items_v.object1_id2%type := null;
3684:
3685: l_api_name CONSTANT VARCHAR2(30) := 'create_strmtp_rul';
3686: l_api_version CONSTANT NUMBER := 1.0;

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

3679: lx_lastrm_rulv_rec Okl_Rule_Pub.rulv_rec_type;
3680:
3681: l_chr_id okc_k_headers_b.id%type;
3682: l_object1_id1 okc_k_items_v.object1_id1%type := null;
3683: l_object1_id2 okc_k_items_v.object1_id2%type := null;
3684:
3685: l_api_name CONSTANT VARCHAR2(30) := 'create_strmtp_rul';
3686: l_api_version CONSTANT NUMBER := 1.0;
3687:

Line 3690: from okc_k_items_v

3686: l_api_version CONSTANT NUMBER := 1.0;
3687:
3688: CURSOR l_strm_type_item_csr IS
3689: select object1_id1,object1_id2
3690: from okc_k_items_v
3691: where cle_id = p_cle_id
3692: and dnz_chr_id = p_chr_id;
3693:
3694: CURSOR l_strm_type_rul_csr IS

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

3855: lx_lastrm_rulv_rec Okl_Rule_Pub.rulv_rec_type;
3856:
3857: l_chr_id okc_k_headers_b.id%type;
3858: l_rgp_id okc_k_headers_b.id%type;
3859: l_object1_id1 okc_k_items_v.object1_id1%type := null;
3860: l_object1_id2 okc_k_items_v.object1_id2%type := null;
3861:
3862: l_api_name CONSTANT VARCHAR2(30) := 'update_strmtp_rul';
3863: l_api_version CONSTANT NUMBER := 1.0;

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

3856:
3857: l_chr_id okc_k_headers_b.id%type;
3858: l_rgp_id okc_k_headers_b.id%type;
3859: l_object1_id1 okc_k_items_v.object1_id1%type := null;
3860: l_object1_id2 okc_k_items_v.object1_id2%type := null;
3861:
3862: l_api_name CONSTANT VARCHAR2(30) := 'update_strmtp_rul';
3863: l_api_version CONSTANT NUMBER := 1.0;
3864:

Line 3867: from okc_k_items_v

3863: l_api_version CONSTANT NUMBER := 1.0;
3864:
3865: CURSOR l_strm_type_item_csr IS
3866: select object1_id1,object1_id2
3867: from okc_k_items_v
3868: where cle_id = p_cle_id
3869: and dnz_chr_id = p_chr_id;
3870:
3871:

Line 5457: FROM okc_k_items_v

5453: -- cursor to get okc_k_items id
5454:
5455: CURSOR get_okc_k_items_csr (fee_line_id IN NUMBER) IS
5456: SELECT id
5457: FROM okc_k_items_v
5458: WHERE cle_id = fee_line_id;
5459:
5460:
5461: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;