APPS.OKL_MASS_REBOOK_PVT dependencies on OKC_RULE_GROUPS_V

Line 1691: FROM okc_rule_groups_v

1687:
1688: CURSOR rgp_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
1689: p_cle_id OKC_K_LINES_V.ID%TYPE) IS
1690: SELECT ID
1691: FROM okc_rule_groups_v
1692: WHERE dnz_chr_id = p_chr_id
1693: AND cle_id = p_cle_id
1694: AND rgd_code = 'LALEVL';
1695:

Line 1706: p_rgp_id OKC_RULE_GROUPS_V.ID%TYPE) IS

1702: AND rule_information_category = 'LASLH';
1703:
1704: CURSOR sll_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
1705: p_slh_id OKC_RULES_V.ID%TYPE,
1706: p_rgp_id OKC_RULE_GROUPS_V.ID%TYPE) IS
1707: SELECT id
1708: FROM okc_rules_v
1709: WHERE dnz_chr_id = p_chr_id
1710: AND rgp_id = p_rgp_id

Line 1732: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE;

1728: x_sll_rulv_tbl rulv_tbl_type;
1729:
1730: l_sll_count NUMBER;
1731: k NUMBER;
1732: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE;
1733: l_slh_rule_id OKC_RULES_V.ID%TYPE;
1734:
1735: update_failed EXCEPTION;
1736:

Line 2015: FROM okc_rule_groups_v

2011:
2012: CURSOR rgp_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
2013: p_cle_id OKC_K_LINES_V.ID%TYPE) IS
2014: SELECT ID
2015: FROM okc_rule_groups_v
2016: WHERE dnz_chr_id = p_chr_id
2017: AND cle_id = p_cle_id
2018: AND rgd_code = 'LALEVL';
2019:

Line 2030: p_rgp_id OKC_RULE_GROUPS_V.ID%TYPE) IS

2026: AND rule_information_category = 'LASLH';
2027:
2028: CURSOR sll_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
2029: p_slh_id OKC_RULES_V.ID%TYPE,
2030: p_rgp_id OKC_RULE_GROUPS_V.ID%TYPE) IS
2031: SELECT id
2032: FROM okc_rules_v
2033: WHERE dnz_chr_id = p_chr_id
2034: AND rgp_id = p_rgp_id

Line 2056: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE;

2052: x_sll_rulv_tbl rulv_tbl_type;
2053:
2054: l_sll_count NUMBER;
2055: k NUMBER;
2056: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE;
2057: l_slh_rule_id OKC_RULES_V.ID%TYPE;
2058:
2059: l_previous_lasll_exists BOOLEAN := FALSE;
2060: update_failed EXCEPTION;