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 2782: l_rgp_id okc_rules_v.id%type := null;

2778: lx_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
2779: lx_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
2780:
2781: l_chr_id okc_k_headers_b.id%type := p_fee_types_rec.dnz_chr_id;
2782: l_rgp_id okc_rules_v.id%type := null;
2783: l_rul_id okc_rules_v.id%type := null;
2784:
2785: l_api_name CONSTANT VARCHAR2(30) := 'update_fee_type';
2786: l_api_version CONSTANT NUMBER := 1.0;

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

2779: lx_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
2780:
2781: l_chr_id okc_k_headers_b.id%type := p_fee_types_rec.dnz_chr_id;
2782: l_rgp_id okc_rules_v.id%type := null;
2783: l_rul_id okc_rules_v.id%type := null;
2784:
2785: l_api_name CONSTANT VARCHAR2(30) := 'update_fee_type';
2786: l_api_version CONSTANT NUMBER := 1.0;
2787: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;

Line 2792: from okc_rules_v rul,

2788:
2789: CURSOR l_strm_type_rul_csr IS
2790: select rgp.id,
2791: rul.id
2792: from okc_rules_v rul,
2793: okc_rule_groups_v rgp
2794: where rgp.id = rul.rgp_id
2795: and rgp.rgd_code = 'LAPSTH'
2796: and rul.rule_information_category = 'LASTRM'

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

3416: lp_lastrm_rulv_rec Okl_Rule_Pub.rulv_rec_type;
3417: lx_lastrm_rulv_rec Okl_Rule_Pub.rulv_rec_type;
3418:
3419: l_chr_id okc_k_headers_b.id%type;
3420: l_rul_id okc_rules_v.id%type := null;
3421: l_rgp_id okc_rules_v.id%type := null;
3422: l_lapsth_rgp_id okc_rules_v.id%type := null;
3423:
3424: l_api_name CONSTANT VARCHAR2(30) := 'process_strmtp_rul';

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

3417: lx_lastrm_rulv_rec Okl_Rule_Pub.rulv_rec_type;
3418:
3419: l_chr_id okc_k_headers_b.id%type;
3420: l_rul_id okc_rules_v.id%type := null;
3421: l_rgp_id okc_rules_v.id%type := null;
3422: l_lapsth_rgp_id okc_rules_v.id%type := null;
3423:
3424: l_api_name CONSTANT VARCHAR2(30) := 'process_strmtp_rul';
3425: l_api_version CONSTANT NUMBER := 1.0;

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

3418:
3419: l_chr_id okc_k_headers_b.id%type;
3420: l_rul_id okc_rules_v.id%type := null;
3421: l_rgp_id okc_rules_v.id%type := null;
3422: l_lapsth_rgp_id okc_rules_v.id%type := null;
3423:
3424: l_api_name CONSTANT VARCHAR2(30) := 'process_strmtp_rul';
3425: l_api_version CONSTANT NUMBER := 1.0;
3426:

Line 3438: from okc_rules_v rul,

3434:
3435: CURSOR l_strm_type_rul_csr IS
3436: select rgp.id,
3437: rul.id
3438: from okc_rules_v rul,
3439: okc_rule_groups_v rgp
3440: where rgp.id = rul.rgp_id
3441: and rgp.rgd_code = 'LAPSTH'
3442: and rul.rule_information_category = 'LASTRM'

Line 3697: from okc_rules_v rul,

3693:
3694: CURSOR l_strm_type_rul_csr IS
3695: select rul.object1_id1,
3696: rul.object1_id2
3697: from okc_rules_v rul,
3698: okc_rule_groups_v rgp
3699: where rgp.id = rul.rgp_id
3700: and rgp.rgd_code = 'LAPSTH'
3701: and rul.rule_information_category = 'LASTRM'

Line 5418: FROM okc_rules_v rul, okc_rule_groups_v rgb

5414:
5415: -- cursor to get check box value
5416: CURSOR get_rvi_check_value_csr (p_chr_id in NUMBER) IS
5417: SELECT rule_information1
5418: FROM okc_rules_v rul, okc_rule_groups_v rgb
5419: WHERE rul.dnz_chr_id = p_chr_id AND
5420: rule_information_category = 'LARVAU' AND
5421: rgb.id = rul.rgp_id AND rgd_code like 'LARVIN';
5422: