eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_MAINTAIN_FEE_PVT dependencies on OKC_K_ITEMS

Line 3120: from okc_k_items cim,

3116: cursor l_cov_ast_csr (p_cle_id in number) is
3117: select kle_fee.fee_type,
3118: cim.object1_id1,
3119: cim.dnz_chr_id
3120: from okc_k_items cim,
3121: okc_k_lines_b cleb,
3122: okl_k_lines kle_fee,
3123: okc_k_lines_b cleb_fee,
3124: okc_line_styles_b lseb_fee

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

5251: p_fin_ast_id IN NUMBER) IS
5252: SELECT cov_ast_cle.id cov_ast_cle_id,
5253: cov_ast_cim.id cov_ast_cim_id
5254: FROM okc_k_lines_b cov_ast_cle,
5255: okc_k_items cov_ast_cim
5256: WHERE cov_ast_cle.dnz_chr_id = p_chr_id
5257: AND cov_ast_cle.cle_id = p_fee_cle_id
5258: AND cov_ast_cim.cle_id = cov_ast_cle.id
5259: AND cov_ast_cim.object1_id1 = TO_CHAR(p_fin_ast_id)

Line 5452: okc_k_items cim,

5448:
5449: CURSOR get_stream_name_csr (p_chr_id in NUMBER) IS
5450: SELECT styb.id, styb.code
5451: FROM okl_strm_type_b styb,
5452: okc_k_items cim,
5453: okc_k_lines_b cleb,
5454: okl_k_lines kle
5455: WHERE styb.id = cim.object1_id1
5456: AND '#' = cim.object1_id2

Line 5466: -- cursor to get okc_k_items id

5462: AND kle.fee_type = 'ABSORBED'
5463: AND kle.fee_purpose_code = 'RVI'
5464: AND cleb.dnz_chr_id = p_chr_id;
5465:
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

Line 5468: CURSOR get_okc_k_items_csr (fee_line_id IN NUMBER) IS

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

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;

Line 5599: open get_okc_k_items_csr (l_fee_line_id);

5595: end if;
5596:
5597: if ((l_strm_id IS NOT NULL) AND (l_strm_id <> OKL_API.G_MISS_NUM)) THEN
5598:
5599: open get_okc_k_items_csr (l_fee_line_id);
5600: fetch get_okc_k_items_csr into l_cim_id;
5601: close get_okc_k_items_csr;
5602:
5603: l_fee_types_rec.line_id := l_fee_line_id;

Line 5600: fetch get_okc_k_items_csr into l_cim_id;

5596:
5597: if ((l_strm_id IS NOT NULL) AND (l_strm_id <> OKL_API.G_MISS_NUM)) THEN
5598:
5599: open get_okc_k_items_csr (l_fee_line_id);
5600: fetch get_okc_k_items_csr into l_cim_id;
5601: close get_okc_k_items_csr;
5602:
5603: l_fee_types_rec.line_id := l_fee_line_id;
5604: l_fee_types_rec.item_id := l_cim_id;

Line 5601: close get_okc_k_items_csr;

5597: if ((l_strm_id IS NOT NULL) AND (l_strm_id <> OKL_API.G_MISS_NUM)) THEN
5598:
5599: open get_okc_k_items_csr (l_fee_line_id);
5600: fetch get_okc_k_items_csr into l_cim_id;
5601: close get_okc_k_items_csr;
5602:
5603: l_fee_types_rec.line_id := l_fee_line_id;
5604: l_fee_types_rec.item_id := l_cim_id;
5605: -- l_fee_types_rec.fee_type := 'ABSORBED';

Line 5691: open get_okc_k_items_csr (l_fee_line_id);

5687: if ((l_price_engine is not null) and (l_price_engine = 'EXTERNAL' ))THEN
5688: --Bug# 8652738
5689: if (l_fee_line_id is not null) then
5690:
5691: open get_okc_k_items_csr (l_fee_line_id);
5692: fetch get_okc_k_items_csr into l_cim_id;
5693: close get_okc_k_items_csr;
5694:
5695: l_fee_types_rec.line_id := l_fee_line_id;

Line 5692: fetch get_okc_k_items_csr into l_cim_id;

5688: --Bug# 8652738
5689: if (l_fee_line_id is not null) then
5690:
5691: open get_okc_k_items_csr (l_fee_line_id);
5692: fetch get_okc_k_items_csr into l_cim_id;
5693: close get_okc_k_items_csr;
5694:
5695: l_fee_types_rec.line_id := l_fee_line_id;
5696: l_fee_types_rec.item_id := l_cim_id;

Line 5693: close get_okc_k_items_csr;

5689: if (l_fee_line_id is not null) then
5690:
5691: open get_okc_k_items_csr (l_fee_line_id);
5692: fetch get_okc_k_items_csr into l_cim_id;
5693: close get_okc_k_items_csr;
5694:
5695: l_fee_types_rec.line_id := l_fee_line_id;
5696: l_fee_types_rec.item_id := l_cim_id;
5697: l_fee_types_rec.fee_purpose_code:= 'RVI_DUMMY'; -- since rvi can't be delted from delte screen

Line 5725: open get_okc_k_items_csr (l_fee_line_id);

5721: --Bug# 8652738
5722: elsif ((l_price_engine is not null) and (l_price_engine = 'INTERNAL' ))THEN
5723:
5724: if (l_fee_line_id is not null) then
5725: open get_okc_k_items_csr (l_fee_line_id);
5726: fetch get_okc_k_items_csr into l_cim_id;
5727: close get_okc_k_items_csr;
5728:
5729: l_fee_types_rec.line_id := l_fee_line_id;

Line 5726: fetch get_okc_k_items_csr into l_cim_id;

5722: elsif ((l_price_engine is not null) and (l_price_engine = 'INTERNAL' ))THEN
5723:
5724: if (l_fee_line_id is not null) then
5725: open get_okc_k_items_csr (l_fee_line_id);
5726: fetch get_okc_k_items_csr into l_cim_id;
5727: close get_okc_k_items_csr;
5728:
5729: l_fee_types_rec.line_id := l_fee_line_id;
5730: l_fee_types_rec.item_id := l_cim_id;

Line 5727: close get_okc_k_items_csr;

5723:
5724: if (l_fee_line_id is not null) then
5725: open get_okc_k_items_csr (l_fee_line_id);
5726: fetch get_okc_k_items_csr into l_cim_id;
5727: close get_okc_k_items_csr;
5728:
5729: l_fee_types_rec.line_id := l_fee_line_id;
5730: l_fee_types_rec.item_id := l_cim_id;
5731: l_fee_types_rec.fee_purpose_code:= 'RVI_DUMMY'; -- since rvi can't be delted from delte screen