APPS.OKL_MASS_REBOOK_PVT dependencies on OKC_RULES_V

Line 1696: CURSOR slh_csr (p_stream_id OKC_RULES_V.OBJECT1_ID1%TYPE,

1692: WHERE dnz_chr_id = p_chr_id
1693: AND cle_id = p_cle_id
1694: AND rgd_code = 'LALEVL';
1695:
1696: CURSOR slh_csr (p_stream_id OKC_RULES_V.OBJECT1_ID1%TYPE,
1697: p_rgp_id OKC_RULES_V.RGP_ID%TYPE) IS
1698: SELECT id
1699: FROM okc_rules_v
1700: WHERE object1_id1 = p_stream_id

Line 1697: p_rgp_id OKC_RULES_V.RGP_ID%TYPE) IS

1693: AND cle_id = p_cle_id
1694: AND rgd_code = 'LALEVL';
1695:
1696: CURSOR slh_csr (p_stream_id OKC_RULES_V.OBJECT1_ID1%TYPE,
1697: p_rgp_id OKC_RULES_V.RGP_ID%TYPE) IS
1698: SELECT id
1699: FROM okc_rules_v
1700: WHERE object1_id1 = p_stream_id
1701: AND rgp_id = p_rgp_id

Line 1699: FROM okc_rules_v

1695:
1696: CURSOR slh_csr (p_stream_id OKC_RULES_V.OBJECT1_ID1%TYPE,
1697: p_rgp_id OKC_RULES_V.RGP_ID%TYPE) IS
1698: SELECT id
1699: FROM okc_rules_v
1700: WHERE object1_id1 = p_stream_id
1701: AND rgp_id = p_rgp_id
1702: AND rule_information_category = 'LASLH';
1703:

Line 1705: p_slh_id OKC_RULES_V.ID%TYPE,

1701: AND rgp_id = p_rgp_id
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

Line 1708: FROM okc_rules_v

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
1711: AND object2_id1 = p_slh_id
1712: AND rule_information_category = 'LASLL';

Line 1733: l_slh_rule_id OKC_RULES_V.ID%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:
1737: BEGIN

Line 2020: CURSOR slh_csr (p_stream_id OKC_RULES_V.OBJECT1_ID1%TYPE,

2016: WHERE dnz_chr_id = p_chr_id
2017: AND cle_id = p_cle_id
2018: AND rgd_code = 'LALEVL';
2019:
2020: CURSOR slh_csr (p_stream_id OKC_RULES_V.OBJECT1_ID1%TYPE,
2021: p_rgp_id OKC_RULES_V.RGP_ID%TYPE) IS
2022: SELECT id
2023: FROM okc_rules_v
2024: WHERE object1_id1 = p_stream_id

Line 2021: p_rgp_id OKC_RULES_V.RGP_ID%TYPE) IS

2017: AND cle_id = p_cle_id
2018: AND rgd_code = 'LALEVL';
2019:
2020: CURSOR slh_csr (p_stream_id OKC_RULES_V.OBJECT1_ID1%TYPE,
2021: p_rgp_id OKC_RULES_V.RGP_ID%TYPE) IS
2022: SELECT id
2023: FROM okc_rules_v
2024: WHERE object1_id1 = p_stream_id
2025: AND rgp_id = p_rgp_id

Line 2023: FROM okc_rules_v

2019:
2020: CURSOR slh_csr (p_stream_id OKC_RULES_V.OBJECT1_ID1%TYPE,
2021: p_rgp_id OKC_RULES_V.RGP_ID%TYPE) IS
2022: SELECT id
2023: FROM okc_rules_v
2024: WHERE object1_id1 = p_stream_id
2025: AND rgp_id = p_rgp_id
2026: AND rule_information_category = 'LASLH';
2027:

Line 2029: p_slh_id OKC_RULES_V.ID%TYPE,

2025: AND rgp_id = p_rgp_id
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

Line 2032: FROM okc_rules_v

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
2035: AND object2_id1 = p_slh_id
2036: AND rule_information_category = 'LASLL';

Line 2057: l_slh_rule_id OKC_RULES_V.ID%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;
2061: