APPS.OKC_IMP_TERMS_TEMPLATES_PVT dependencies on STANDARD

Line 628: AND standard_yn = 'Y'

624: IS
625: SELECT 'Y'
626: FROM okc_articles_all
627: WHERE 1 = 1
628: AND standard_yn = 'Y'
629: AND org_id = p_org_id
630: AND article_intent = p_intent
631: AND article_id = p_article_id;
632:

Line 640: AND art.standard_yn = 'Y'

636: FROM okc_articles_all art,
637: okc_article_versions ver,
638: okc_article_adoptions adp
639: WHERE art.article_id = ver.article_id
640: AND art.standard_yn = 'Y'
641: AND ver.global_yn = 'Y'
642: AND ver.article_status = 'APPROVED'
643: AND adp.global_article_version_id = ver.article_version_id
644: AND adp.adoption_type = 'ADOPTED'

Line 2027: -- Indicates if the section refers to a contract header or a standard clause set.

2023: FROM DUAL; */
2024: p_section_rec.ID := NULL;
2025: END IF;
2026:
2027: -- Indicates if the section refers to a contract header or a standard clause set.
2028: IF p_section_rec.scn_type = okc_api.g_miss_char
2029: THEN
2030: p_section_rec.scn_type := NULL;
2031: END IF;

Line 2033: -- Contract header id for this section. If -99, then the section refers to a standard clause set.

2029: THEN
2030: p_section_rec.scn_type := NULL;
2031: END IF;
2032:
2033: -- Contract header id for this section. If -99, then the section refers to a standard clause set.
2034: IF p_section_rec.chr_id = okc_api.g_miss_num
2035: THEN
2036: p_section_rec.chr_id := NULL;
2037: END IF;

Line 2039: -- Standard Clause Set code, for formatting standard clause sets.

2035: THEN
2036: p_section_rec.chr_id := NULL;
2037: END IF;
2038:
2039: -- Standard Clause Set code, for formatting standard clause sets.
2040: -- If -99, then this section refers to a contract.
2041: IF p_section_rec.sat_code = okc_api.g_miss_char
2042: THEN
2043: p_section_rec.sat_code := NULL;