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 3788: section OKC_TMPL_DRAFT_CLAUSES.SECTION_NAME%TYPE

3784: TYPE draft_art_rec_type IS RECORD (
3785: article_id OKC_ARTICLES_ALL.ARTICLE_ID%TYPE,
3786: article_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE,
3787: title OKC_QA_ERRORS_T.title%TYPE,
3788: section OKC_TMPL_DRAFT_CLAUSES.SECTION_NAME%TYPE
3789: );
3790:
3791: TYPE draft_art_tbl_type IS TABLE OF draft_art_rec_type INDEX BY BINARY_INTEGER;
3792: */

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

3790:
3791: TYPE draft_art_tbl_type IS TABLE OF draft_art_rec_type INDEX BY BINARY_INTEGER;
3792: */
3793:
3794: TYPE art_id_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER;
3795: TYPE ver_id_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;
3796: TYPE title_tbl_type IS TABLE of OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE INDEX BY BINARY_INTEGER;
3797: TYPE sec_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.SECTION_NAME%TYPE INDEX BY BINARY_INTEGER;
3798:

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

3791: TYPE draft_art_tbl_type IS TABLE OF draft_art_rec_type INDEX BY BINARY_INTEGER;
3792: */
3793:
3794: TYPE art_id_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER;
3795: TYPE ver_id_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;
3796: TYPE title_tbl_type IS TABLE of OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE INDEX BY BINARY_INTEGER;
3797: TYPE sec_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.SECTION_NAME%TYPE INDEX BY BINARY_INTEGER;
3798:
3799: l_api_name CONSTANT VARCHAR2(30) := 'check_validate_draft_articles';

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

3793:
3794: TYPE art_id_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER;
3795: TYPE ver_id_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;
3796: TYPE title_tbl_type IS TABLE of OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE INDEX BY BINARY_INTEGER;
3797: TYPE sec_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.SECTION_NAME%TYPE INDEX BY BINARY_INTEGER;
3798:
3799: l_api_name CONSTANT VARCHAR2(30) := 'check_validate_draft_articles';
3800: l_indx NUMBER;
3801:

Line 3838: FROM OKC_TMPL_DRAFT_CLAUSES DRA,

3834: CURSOR l_draft_art_csr IS
3835: SELECT DRA.article_id, DRA.article_version_id,
3836: --NVL(VER.display_name, ART.article_title) title, DRA.section_name section
3837: NVL(VER.display_name, ART.article_title) title,NVL(DRA.section_name, '*') section
3838: FROM OKC_TMPL_DRAFT_CLAUSES DRA,
3839: OKC_ARTICLES_ALL ART, OKC_ARTICLE_VERSIONS VER
3840: WHERE DRA.template_id = p_doc_id and
3841: DRA.selected_yn = 'Y' and
3842: DRA.article_id = ART.article_id and

Line 3845: -- orphaned records in the OKC_TMPL_DRAFT_CLAUSES table

3841: DRA.selected_yn = 'Y' and
3842: DRA.article_id = ART.article_id and
3843: VER.article_version_id = DRA.article_version_id
3844: -- additional check to ensure that we are not checking some
3845: -- orphaned records in the OKC_TMPL_DRAFT_CLAUSES table
3846: AND EXISTS (SELECT '1' FROM OKC_K_ARTICLES_B KART WHERE
3847: KART.document_type = p_doc_type AND
3848: KART.document_id = p_doc_id AND
3849: KART.sav_sae_id = DRA.article_id);

Line 3901: -- Insert records in OKC_TMPL_DRAFT_CLAUSES before validation

3897: RETURN; -- no article validation for other statuses.
3898: END IF;
3899: --
3900: -- muteshev
3901: -- Insert records in OKC_TMPL_DRAFT_CLAUSES before validation
3902: -- bug 4159533 start
3903: declare
3904: l_drafts_present varchar2(1);
3905: x_return_status varchar2(150);

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

3923: end;
3924: -- bug 4159533 end
3925: -- the above code simulates template submittion else the below
3926: -- l_draft_art_csr will never get any rows unless user submits template himself
3927: -- (template submittion populates the OKC_TMPL_DRAFT_CLAUSES table)
3928: --
3929: OPEN l_draft_art_csr;
3930: FETCH l_draft_art_csr BULK COLLECT INTO l_draft_art_id_tbl, l_draft_ver_id_tbl,
3931: l_draft_title_tbl, l_draft_sec_tbl;

Line 4258: FROM OKC_TMPL_DRAFT_CLAUSES DRA,

4254: CURSOR l_rejected_art_csr IS
4255: SELECT DRA.article_id article_id, DRA.article_version_id,
4256: --NVL(VER.display_name, ART.article_title) title, DRA.section_name section
4257: NVL(VER.display_name, ART.article_title) title,NVL(DRA.section_name, '*') section
4258: FROM OKC_TMPL_DRAFT_CLAUSES DRA,
4259: OKC_ARTICLES_ALL ART, OKC_ARTICLE_VERSIONS VER
4260: WHERE DRA.template_id = p_doc_id and
4261: DRA.selected_yn = 'Y' and
4262: DRA.article_id = ART.article_id and

Line 4265: -- orphaned records in the OKC_TMPL_DRAFT_CLAUSES table

4261: DRA.selected_yn = 'Y' and
4262: DRA.article_id = ART.article_id and
4263: VER.article_version_id = DRA.article_version_id
4264: -- additional check to ensure that we are not checking some
4265: -- orphaned records in the OKC_TMPL_DRAFT_CLAUSES table
4266: AND EXISTS (SELECT '1' FROM OKC_K_ARTICLES_B KART WHERE
4267: KART.document_type = p_doc_type AND
4268: KART.document_id = p_doc_id AND
4269: KART.sav_sae_id = DRA.article_id)