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_COPY_PVT dependencies on OKC_K_ARTICLES_B_S

Line 644: TYPE SavSaeIdList IS TABLE OF OKC_K_ARTICLES_B.SAV_SAE_ID%TYPE INDEX BY BINARY_INTEGER;

640: l_org_id OKC_TERMS_TEMPLATES_ALL.ORG_ID%TYPE;
641: l_art_title OKC_ARTICLES_ALL.ARTICLE_TITLE%TYPE;
642: k NUMBER := 0;
643:
644: TYPE SavSaeIdList IS TABLE OF OKC_K_ARTICLES_B.SAV_SAE_ID%TYPE INDEX BY BINARY_INTEGER;
645: TYPE AttributeCategoryList IS TABLE OF OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
646: TYPE AttributeList IS TABLE OF OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;
647: TYPE SourceFlagList IS TABLE OF OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
648: TYPE ArticleVersionIdList IS TABLE OF OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 647: TYPE SourceFlagList IS TABLE OF OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE INDEX BY BINARY_INTEGER;

643:
644: TYPE SavSaeIdList IS TABLE OF OKC_K_ARTICLES_B.SAV_SAE_ID%TYPE INDEX BY BINARY_INTEGER;
645: TYPE AttributeCategoryList IS TABLE OF OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
646: TYPE AttributeList IS TABLE OF OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;
647: TYPE SourceFlagList IS TABLE OF OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
648: TYPE ArticleVersionIdList IS TABLE OF OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;
649: TYPE MandatoryYnList IS TABLE OF OKC_K_ARTICLES_B.MANDATORY_YN%TYPE INDEX BY BINARY_INTEGER;
650: TYPE MandatoryRwaList IS TABLE OF OKC_K_ARTICLES_B.MANDATORY_RWA%TYPE INDEX BY BINARY_INTEGER;
651: TYPE ChangeNonStdYnList IS TABLE OF OKC_K_ARTICLES_B.CHANGE_NONSTD_YN%TYPE INDEX BY BINARY_INTEGER;

Line 652: TYPE ScnIdList IS TABLE OF OKC_K_ARTICLES_B.SCN_ID%TYPE INDEX BY BINARY_INTEGER;

648: TYPE ArticleVersionIdList IS TABLE OF OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;
649: TYPE MandatoryYnList IS TABLE OF OKC_K_ARTICLES_B.MANDATORY_YN%TYPE INDEX BY BINARY_INTEGER;
650: TYPE MandatoryRwaList IS TABLE OF OKC_K_ARTICLES_B.MANDATORY_RWA%TYPE INDEX BY BINARY_INTEGER;
651: TYPE ChangeNonStdYnList IS TABLE OF OKC_K_ARTICLES_B.CHANGE_NONSTD_YN%TYPE INDEX BY BINARY_INTEGER;
652: TYPE ScnIdList IS TABLE OF OKC_K_ARTICLES_B.SCN_ID%TYPE INDEX BY BINARY_INTEGER;
653: TYPE OrigSystemReferenceId1List IS TABLE OF OKC_K_ARTICLES_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER;
654: TYPE LabelList IS TABLE OF OKC_K_ARTICLES_B.LABEL%TYPE INDEX BY BINARY_INTEGER;
655: TYPE DisplaySequenceList IS TABLE OF OKC_K_ARTICLES_B.DISPLAY_SEQUENCE%TYPE INDEX BY BINARY_INTEGER;
656: TYPE RefArticleIdList IS TABLE OF OKC_K_ARTICLES_B.REF_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 998: ,okc_k_articles_b srcart

994: CURSOR cur_orphan_upd_clauses
995: IS
996: SELECT tgtart.id,tgtsec.id
997: FROM okc_k_articles_b tgtart
998: ,okc_k_articles_b srcart
999: ,okc_sections_b tgtsec
1000: WHERE 1 = 1
1001: -- Target document clauses
1002: AND tgtart.document_type= p_target_doc_type

Line 1517: VALUES(OKC_K_ARTICLES_B_S.nextval,

1513: LAST_UPDATED_BY,
1514: LAST_UPDATE_LOGIN,
1515: LAST_UPDATE_DATE,
1516: ORIG_ARTICLE_ID)
1517: VALUES(OKC_K_ARTICLES_B_S.nextval,
1518: sav_sae_tbl1(i),
1519: p_target_doc_type,
1520: p_target_doc_id,
1521: decode(p_target_doc_type,'OKC_BUY',p_target_doc_id,'OKC_SELL',p_target_doc_id, 'OKO',p_target_doc_id,'OKS',p_target_doc_id,'OKE_BUY',p_target_doc_id, 'OKE_SELL',p_target_doc_id, 'OKL',p_target_doc_id,NULL),