DBA Data[Home] [Help]

APPS.OKL_MAINTAIN_FEE_PVT dependencies on OKC_K_ITEMS

Line 3107: from okc_k_items cim,

3103: cursor l_cov_ast_csr (p_cle_id in number) is
3104: select kle_fee.fee_type,
3105: cim.object1_id1,
3106: cim.dnz_chr_id
3107: from okc_k_items cim,
3108: okc_k_lines_b cleb,
3109: okl_k_lines kle_fee,
3110: okc_k_lines_b cleb_fee,
3111: okc_line_styles_b lseb_fee

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 5242: okc_k_items cov_ast_cim

5238: p_fin_ast_id IN NUMBER) IS
5239: SELECT cov_ast_cle.id cov_ast_cle_id,
5240: cov_ast_cim.id cov_ast_cim_id
5241: FROM okc_k_lines_b cov_ast_cle,
5242: okc_k_items cov_ast_cim
5243: WHERE cov_ast_cle.dnz_chr_id = p_chr_id
5244: AND cov_ast_cle.cle_id = p_fee_cle_id
5245: AND cov_ast_cim.cle_id = cov_ast_cle.id
5246: AND cov_ast_cim.object1_id1 = TO_CHAR(p_fin_ast_id)

Line 5439: okc_k_items cim,

5435:
5436: CURSOR get_stream_name_csr (p_chr_id in NUMBER) IS
5437: SELECT styb.id, styb.code
5438: FROM okl_strm_type_b styb,
5439: okc_k_items cim,
5440: okc_k_lines_b cleb,
5441: okl_k_lines kle
5442: WHERE styb.id = cim.object1_id1
5443: AND '#' = cim.object1_id2

Line 5453: -- cursor to get okc_k_items id

5449: AND kle.fee_type = 'ABSORBED'
5450: AND kle.fee_purpose_code = 'RVI'
5451: AND cleb.dnz_chr_id = p_chr_id;
5452:
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

Line 5455: CURSOR get_okc_k_items_csr (fee_line_id IN NUMBER) IS

5451: AND cleb.dnz_chr_id = p_chr_id;
5452:
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:

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;

Line 5581: open get_okc_k_items_csr (l_fee_line_id);

5577: end if;
5578:
5579: if ((l_strm_id IS NOT NULL) AND (l_strm_id <> OKL_API.G_MISS_NUM)) THEN
5580:
5581: open get_okc_k_items_csr (l_fee_line_id);
5582: fetch get_okc_k_items_csr into l_cim_id;
5583: close get_okc_k_items_csr;
5584:
5585: l_fee_types_rec.line_id := l_fee_line_id;

Line 5582: fetch get_okc_k_items_csr into l_cim_id;

5578:
5579: if ((l_strm_id IS NOT NULL) AND (l_strm_id <> OKL_API.G_MISS_NUM)) THEN
5580:
5581: open get_okc_k_items_csr (l_fee_line_id);
5582: fetch get_okc_k_items_csr into l_cim_id;
5583: close get_okc_k_items_csr;
5584:
5585: l_fee_types_rec.line_id := l_fee_line_id;
5586: l_fee_types_rec.item_id := l_cim_id;

Line 5583: close get_okc_k_items_csr;

5579: if ((l_strm_id IS NOT NULL) AND (l_strm_id <> OKL_API.G_MISS_NUM)) THEN
5580:
5581: open get_okc_k_items_csr (l_fee_line_id);
5582: fetch get_okc_k_items_csr into l_cim_id;
5583: close get_okc_k_items_csr;
5584:
5585: l_fee_types_rec.line_id := l_fee_line_id;
5586: l_fee_types_rec.item_id := l_cim_id;
5587: -- l_fee_types_rec.fee_type := 'ABSORBED';

Line 5656: open get_okc_k_items_csr (l_fee_line_id);

5652:
5653: if ((l_strm_id IS NOT NULL) AND (l_strm_id <> OKL_API.G_MISS_NUM)) THEN
5654: IF (l_check_box_value = 'Y') THEN
5655:
5656: open get_okc_k_items_csr (l_fee_line_id);
5657: fetch get_okc_k_items_csr into l_cim_id;
5658: close get_okc_k_items_csr;
5659:
5660: l_fee_types_rec.line_id := l_fee_line_id;

Line 5657: fetch get_okc_k_items_csr into l_cim_id;

5653: if ((l_strm_id IS NOT NULL) AND (l_strm_id <> OKL_API.G_MISS_NUM)) THEN
5654: IF (l_check_box_value = 'Y') THEN
5655:
5656: open get_okc_k_items_csr (l_fee_line_id);
5657: fetch get_okc_k_items_csr into l_cim_id;
5658: close get_okc_k_items_csr;
5659:
5660: l_fee_types_rec.line_id := l_fee_line_id;
5661: l_fee_types_rec.item_id := l_cim_id;

Line 5658: close get_okc_k_items_csr;

5654: IF (l_check_box_value = 'Y') THEN
5655:
5656: open get_okc_k_items_csr (l_fee_line_id);
5657: fetch get_okc_k_items_csr into l_cim_id;
5658: close get_okc_k_items_csr;
5659:
5660: l_fee_types_rec.line_id := l_fee_line_id;
5661: l_fee_types_rec.item_id := l_cim_id;
5662: l_fee_types_rec.fee_purpose_code:= 'RVI_DUMMY'; -- since rvi can't be delted from delte screen