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.OKC_TERMS_QA_PVT dependencies on OKC_TMPL_DRAFT_CLAUSES

Line 3822: section OKC_TMPL_DRAFT_CLAUSES.SECTION_NAME%TYPE

3818: TYPE draft_art_rec_type IS RECORD (
3819: article_id OKC_ARTICLES_ALL.ARTICLE_ID%TYPE,
3820: article_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE,
3821: title OKC_QA_ERRORS_T.title%TYPE,
3822: section OKC_TMPL_DRAFT_CLAUSES.SECTION_NAME%TYPE
3823: );
3824:
3825: TYPE draft_art_tbl_type IS TABLE OF draft_art_rec_type INDEX BY BINARY_INTEGER;
3826: */

Line 3828: TYPE art_id_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER;

3824:
3825: TYPE draft_art_tbl_type IS TABLE OF draft_art_rec_type INDEX BY BINARY_INTEGER;
3826: */
3827:
3828: TYPE art_id_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER;
3829: TYPE ver_id_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;
3830: TYPE title_tbl_type IS TABLE of OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE INDEX BY BINARY_INTEGER;
3831: TYPE sec_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.SECTION_NAME%TYPE INDEX BY BINARY_INTEGER;
3832:

Line 3829: TYPE ver_id_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;

3825: TYPE draft_art_tbl_type IS TABLE OF draft_art_rec_type INDEX BY BINARY_INTEGER;
3826: */
3827:
3828: TYPE art_id_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER;
3829: TYPE ver_id_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;
3830: TYPE title_tbl_type IS TABLE of OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE INDEX BY BINARY_INTEGER;
3831: TYPE sec_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.SECTION_NAME%TYPE INDEX BY BINARY_INTEGER;
3832:
3833: l_api_name CONSTANT VARCHAR2(30) := 'check_validate_draft_articles';

Line 3831: TYPE sec_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.SECTION_NAME%TYPE INDEX BY BINARY_INTEGER;

3827:
3828: TYPE art_id_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER;
3829: TYPE ver_id_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;
3830: TYPE title_tbl_type IS TABLE of OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE INDEX BY BINARY_INTEGER;
3831: TYPE sec_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.SECTION_NAME%TYPE INDEX BY BINARY_INTEGER;
3832:
3833: l_api_name CONSTANT VARCHAR2(30) := 'check_validate_draft_articles';
3834: l_indx NUMBER;
3835:

Line 3872: FROM OKC_TMPL_DRAFT_CLAUSES DRA,

3868: CURSOR l_draft_art_csr IS
3869: SELECT DRA.article_id, DRA.article_version_id,
3870: --NVL(VER.display_name, ART.article_title) title, DRA.section_name section
3871: NVL(VER.display_name, ART.article_title) title,NVL(DRA.section_name, '*') section
3872: FROM OKC_TMPL_DRAFT_CLAUSES DRA,
3873: OKC_ARTICLES_ALL ART, OKC_ARTICLE_VERSIONS VER
3874: WHERE DRA.template_id = p_doc_id and
3875: DRA.selected_yn = 'Y' and
3876: DRA.article_id = ART.article_id and

Line 3879: -- orphaned records in the OKC_TMPL_DRAFT_CLAUSES table

3875: DRA.selected_yn = 'Y' and
3876: DRA.article_id = ART.article_id and
3877: VER.article_version_id = DRA.article_version_id
3878: -- additional check to ensure that we are not checking some
3879: -- orphaned records in the OKC_TMPL_DRAFT_CLAUSES table
3880: AND EXISTS (SELECT '1' FROM OKC_K_ARTICLES_B KART WHERE
3881: KART.document_type = p_doc_type AND
3882: KART.document_id = p_doc_id AND
3883: KART.sav_sae_id = DRA.article_id);

Line 3935: -- Insert records in OKC_TMPL_DRAFT_CLAUSES before validation

3931: RETURN; -- no article validation for other statuses.
3932: END IF;
3933: --
3934: -- muteshev
3935: -- Insert records in OKC_TMPL_DRAFT_CLAUSES before validation
3936: -- bug 4159533 start
3937: declare
3938: l_drafts_present varchar2(1);
3939: x_return_status varchar2(150);

Line 3961: -- (template submittion populates the OKC_TMPL_DRAFT_CLAUSES table)

3957: end;
3958: -- bug 4159533 end
3959: -- the above code simulates template submittion else the below
3960: -- l_draft_art_csr will never get any rows unless user submits template himself
3961: -- (template submittion populates the OKC_TMPL_DRAFT_CLAUSES table)
3962: --
3963: OPEN l_draft_art_csr;
3964: FETCH l_draft_art_csr BULK COLLECT INTO l_draft_art_id_tbl, l_draft_ver_id_tbl,
3965: l_draft_title_tbl, l_draft_sec_tbl;

Line 4292: FROM OKC_TMPL_DRAFT_CLAUSES DRA,

4288: CURSOR l_rejected_art_csr IS
4289: SELECT DRA.article_id article_id, DRA.article_version_id,
4290: --NVL(VER.display_name, ART.article_title) title, DRA.section_name section
4291: NVL(VER.display_name, ART.article_title) title,NVL(DRA.section_name, '*') section
4292: FROM OKC_TMPL_DRAFT_CLAUSES DRA,
4293: OKC_ARTICLES_ALL ART, OKC_ARTICLE_VERSIONS VER
4294: WHERE DRA.template_id = p_doc_id and
4295: DRA.selected_yn = 'Y' and
4296: DRA.article_id = ART.article_id and

Line 4299: -- orphaned records in the OKC_TMPL_DRAFT_CLAUSES table

4295: DRA.selected_yn = 'Y' and
4296: DRA.article_id = ART.article_id and
4297: VER.article_version_id = DRA.article_version_id
4298: -- additional check to ensure that we are not checking some
4299: -- orphaned records in the OKC_TMPL_DRAFT_CLAUSES table
4300: AND EXISTS (SELECT '1' FROM OKC_K_ARTICLES_B KART WHERE
4301: KART.document_type = p_doc_type AND
4302: KART.document_id = p_doc_id AND
4303: KART.sav_sae_id = DRA.article_id)