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_RULES_V

Line 2795: l_rgp_id okc_rules_v.id%type := null;

2791: lx_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
2792: lx_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
2793:
2794: l_chr_id okc_k_headers_b.id%type := p_fee_types_rec.dnz_chr_id;
2795: l_rgp_id okc_rules_v.id%type := null;
2796: l_rul_id okc_rules_v.id%type := null;
2797:
2798: l_api_name CONSTANT VARCHAR2(30) := 'update_fee_type';
2799: l_api_version CONSTANT NUMBER := 1.0;

Line 2796: l_rul_id okc_rules_v.id%type := null;

2792: lx_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
2793:
2794: l_chr_id okc_k_headers_b.id%type := p_fee_types_rec.dnz_chr_id;
2795: l_rgp_id okc_rules_v.id%type := null;
2796: l_rul_id okc_rules_v.id%type := null;
2797:
2798: l_api_name CONSTANT VARCHAR2(30) := 'update_fee_type';
2799: l_api_version CONSTANT NUMBER := 1.0;
2800: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;

Line 2805: from okc_rules_v rul,

2801:
2802: CURSOR l_strm_type_rul_csr IS
2803: select rgp.id,
2804: rul.id
2805: from okc_rules_v rul,
2806: okc_rule_groups_v rgp
2807: where rgp.id = rul.rgp_id
2808: and rgp.rgd_code = 'LAPSTH'
2809: and rul.rule_information_category = 'LASTRM'

Line 3433: l_rul_id okc_rules_v.id%type := null;

3429: lp_lastrm_rulv_rec Okl_Rule_Pub.rulv_rec_type;
3430: lx_lastrm_rulv_rec Okl_Rule_Pub.rulv_rec_type;
3431:
3432: l_chr_id okc_k_headers_b.id%type;
3433: l_rul_id okc_rules_v.id%type := null;
3434: l_rgp_id okc_rules_v.id%type := null;
3435: l_lapsth_rgp_id okc_rules_v.id%type := null;
3436:
3437: l_api_name CONSTANT VARCHAR2(30) := 'process_strmtp_rul';

Line 3434: l_rgp_id okc_rules_v.id%type := null;

3430: lx_lastrm_rulv_rec Okl_Rule_Pub.rulv_rec_type;
3431:
3432: l_chr_id okc_k_headers_b.id%type;
3433: l_rul_id okc_rules_v.id%type := null;
3434: l_rgp_id okc_rules_v.id%type := null;
3435: l_lapsth_rgp_id okc_rules_v.id%type := null;
3436:
3437: l_api_name CONSTANT VARCHAR2(30) := 'process_strmtp_rul';
3438: l_api_version CONSTANT NUMBER := 1.0;

Line 3435: l_lapsth_rgp_id okc_rules_v.id%type := null;

3431:
3432: l_chr_id okc_k_headers_b.id%type;
3433: l_rul_id okc_rules_v.id%type := null;
3434: l_rgp_id okc_rules_v.id%type := null;
3435: l_lapsth_rgp_id okc_rules_v.id%type := null;
3436:
3437: l_api_name CONSTANT VARCHAR2(30) := 'process_strmtp_rul';
3438: l_api_version CONSTANT NUMBER := 1.0;
3439:

Line 3451: from okc_rules_v rul,

3447:
3448: CURSOR l_strm_type_rul_csr IS
3449: select rgp.id,
3450: rul.id
3451: from okc_rules_v rul,
3452: okc_rule_groups_v rgp
3453: where rgp.id = rul.rgp_id
3454: and rgp.rgd_code = 'LAPSTH'
3455: and rul.rule_information_category = 'LASTRM'

Line 3710: from okc_rules_v rul,

3706:
3707: CURSOR l_strm_type_rul_csr IS
3708: select rul.object1_id1,
3709: rul.object1_id2
3710: from okc_rules_v rul,
3711: okc_rule_groups_v rgp
3712: where rgp.id = rul.rgp_id
3713: and rgp.rgd_code = 'LAPSTH'
3714: and rul.rule_information_category = 'LASTRM'

Line 5431: FROM okc_rules_v rul, okc_rule_groups_v rgb

5427:
5428: -- cursor to get check box value
5429: CURSOR get_rvi_check_value_csr (p_chr_id in NUMBER) IS
5430: SELECT rule_information1
5431: FROM okc_rules_v rul, okc_rule_groups_v rgb
5432: WHERE rul.dnz_chr_id = p_chr_id AND
5433: rule_information_category = 'LARVAU' AND
5434: rgb.id = rul.rgp_id AND rgd_code like 'LARVIN';
5435: