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_SECTIONS_B_S

Line 791: OKC_SECTIONS_B SCN

787: ref_article_id,
788: ref_article_version_id,
789: DECODE(p_source_doc_type,G_TEMPLATE_DOC_TYPE,sav_sae_id,orig_article_id) orig_article_id
790: FROM OKC_K_ARTICLES_B KART,
791: OKC_SECTIONS_B SCN
792: WHERE KART.DOCUMENT_TYPE=p_source_doc_type
793: AND KART.DOCUMENT_ID=p_source_doc_id
794: AND SCN.DOCUMENT_TYPE = p_target_doc_type
795: AND SCN.DOCUMENT_ID =p_target_doc_id

Line 845: OKC_SECTIONS_B SCN,

841: KART.ref_article_id,
842: KART.ref_article_version_id,
843: DECODE(p_source_doc_type,G_TEMPLATE_DOC_TYPE,KART.sav_sae_id,KART.orig_article_id) orig_article_id
844: FROM OKC_K_ARTICLES_B KART,
845: OKC_SECTIONS_B SCN,
846: OKC_SECTIONS_B SCN1,
847: OKC_K_ARTICLES_B KART1
848: WHERE KART.DOCUMENT_TYPE= p_source_doc_type
849: AND KART.DOCUMENT_ID= p_source_doc_id

Line 846: OKC_SECTIONS_B SCN1,

842: KART.ref_article_version_id,
843: DECODE(p_source_doc_type,G_TEMPLATE_DOC_TYPE,KART.sav_sae_id,KART.orig_article_id) orig_article_id
844: FROM OKC_K_ARTICLES_B KART,
845: OKC_SECTIONS_B SCN,
846: OKC_SECTIONS_B SCN1,
847: OKC_K_ARTICLES_B KART1
848: WHERE KART.DOCUMENT_TYPE= p_source_doc_type
849: AND KART.DOCUMENT_ID= p_source_doc_id
850: AND SCN.DOCUMENT_TYPE = p_target_doc_type

Line 893: OKC_SECTIONS_B SCN

889: ref_article_id,
890: ref_article_version_id,
891: orig_article_id
892: FROM OKC_K_ARTICLES_BH KART,
893: OKC_SECTIONS_B SCN
894: WHERE KART.DOCUMENT_TYPE=p_source_doc_type
895: AND KART.DOCUMENT_ID=p_source_doc_id
896: AND KART.MAJOR_VERSION = nvl(p_source_version_number,OKC_API.G_MISS_NUM)
897: AND SCN.DOCUMENT_TYPE = p_target_doc_type

Line 1738: TYPE ScnIdList IS TABLE OF OKC_SECTIONS_B.SCN_ID%TYPE INDEX BY BINARY_INTEGER;

1734:
1735: l_api_name CONSTANT VARCHAR2(30) := 'copy_sections';
1736: TYPE AttributeCategoryList IS TABLE OF OKC_SECTIONS_B.ATTRIBUTE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
1737: TYPE AttributeList IS TABLE OF OKC_SECTIONS_B.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;
1738: TYPE ScnIdList IS TABLE OF OKC_SECTIONS_B.SCN_ID%TYPE INDEX BY BINARY_INTEGER;
1739: TYPE OrigSystemReferenceId1List IS TABLE OF OKC_SECTIONS_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER;
1740: TYPE SectionSequenceList IS TABLE OF OKC_SECTIONS_B.SECTION_SEQUENCE%TYPE INDEX BY BINARY_INTEGER;
1741: TYPE HeadingList IS TABLE OF OKC_SECTIONS_B.HEADING%TYPE INDEX BY BINARY_INTEGER;
1742: TYPE LabelList IS TABLE OF OKC_SECTIONS_B.LABEL%TYPE INDEX BY BINARY_INTEGER;

Line 1740: TYPE SectionSequenceList IS TABLE OF OKC_SECTIONS_B.SECTION_SEQUENCE%TYPE INDEX BY BINARY_INTEGER;

1736: TYPE AttributeCategoryList IS TABLE OF OKC_SECTIONS_B.ATTRIBUTE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
1737: TYPE AttributeList IS TABLE OF OKC_SECTIONS_B.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;
1738: TYPE ScnIdList IS TABLE OF OKC_SECTIONS_B.SCN_ID%TYPE INDEX BY BINARY_INTEGER;
1739: TYPE OrigSystemReferenceId1List IS TABLE OF OKC_SECTIONS_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER;
1740: TYPE SectionSequenceList IS TABLE OF OKC_SECTIONS_B.SECTION_SEQUENCE%TYPE INDEX BY BINARY_INTEGER;
1741: TYPE HeadingList IS TABLE OF OKC_SECTIONS_B.HEADING%TYPE INDEX BY BINARY_INTEGER;
1742: TYPE LabelList IS TABLE OF OKC_SECTIONS_B.LABEL%TYPE INDEX BY BINARY_INTEGER;
1743: TYPE ScnCodeList IS TABLE OF OKC_SECTIONS_B.SCN_CODE%TYPE INDEX BY BINARY_INTEGER;
1744: TYPE PrintYnList IS TABLE OF OKC_SECTIONS_B.PRINT_YN%TYPE INDEX BY BINARY_INTEGER;

Line 1743: TYPE ScnCodeList IS TABLE OF OKC_SECTIONS_B.SCN_CODE%TYPE INDEX BY BINARY_INTEGER;

1739: TYPE OrigSystemReferenceId1List IS TABLE OF OKC_SECTIONS_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER;
1740: TYPE SectionSequenceList IS TABLE OF OKC_SECTIONS_B.SECTION_SEQUENCE%TYPE INDEX BY BINARY_INTEGER;
1741: TYPE HeadingList IS TABLE OF OKC_SECTIONS_B.HEADING%TYPE INDEX BY BINARY_INTEGER;
1742: TYPE LabelList IS TABLE OF OKC_SECTIONS_B.LABEL%TYPE INDEX BY BINARY_INTEGER;
1743: TYPE ScnCodeList IS TABLE OF OKC_SECTIONS_B.SCN_CODE%TYPE INDEX BY BINARY_INTEGER;
1744: TYPE PrintYnList IS TABLE OF OKC_SECTIONS_B.PRINT_YN%TYPE INDEX BY BINARY_INTEGER;
1745: TYPE IdList IS TABLE OF OKC_SECTIONS_B.ID%TYPE INDEX BY BINARY_INTEGER;
1746: TYPE DescriptionList IS TABLE OF OKC_SECTIONS_B.DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
1747:

Line 1787: SELECT OKC_SECTIONS_B_S.NEXTVAL,

1783: l_copy_section_yn VARCHAR2(1);
1784: l_scn_drp_action VARCHAR2(100);
1785:
1786: CURSOR l_get_scn_csr IS
1787: SELECT OKC_SECTIONS_B_S.NEXTVAL,
1788: ATTRIBUTE_CATEGORY,
1789: ATTRIBUTE1,
1790: ATTRIBUTE2,
1791: ATTRIBUTE3,

Line 1839: FROM okc_k_entity_locks lck,okc_sections_b sec

1835: )
1836: /*OR
1837: ( p_retain_lock_terms_yn = 'Y'
1838: AND NOT EXISTS ( SELECT 'LOCKEXISTS'
1839: FROM okc_k_entity_locks lck,okc_sections_b sec
1840: WHERE entity_name='DUMMYSEC'
1841: AND entity_pk1 = To_Char(id)
1842: AND lock_by_document_type=p_target_doc_type
1843: AND lock_by_document_id=p_target_doc_id

Line 1853: SELECT OKC_SECTIONS_B_S.NEXTVAL,

1849: );
1850:
1851:
1852: CURSOR l_get_scn_from_archive_csr IS
1853: SELECT OKC_SECTIONS_B_S.NEXTVAL,
1854: ATTRIBUTE_CATEGORY,
1855: ATTRIBUTE1,
1856: ATTRIBUTE2,
1857: ATTRIBUTE3,

Line 1909: ,okc_sections_b srcsec

1905: CURSOR cur_orphan_upd_sections
1906: IS
1907: SELECT tgtsec.id,tgtsec2.id
1908: FROM okc_sections_b tgtsec
1909: ,okc_sections_b srcsec
1910: ,okc_sections_b tgtsec2
1911: WHERE 1 = 1
1912: AND tgtsec.document_type= p_target_doc_type
1913: AND tgtsec.document_id= p_target_doc_id