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.

[Home] [Help]

APPS.OKC_TERMS_COPY_PVT dependencies on OKC_SECTIONS_B_S

Line 549: OKC_SECTIONS_B SCN

545: ref_article_id,
546: ref_article_version_id,
547: DECODE(p_source_doc_type,G_TEMPLATE_DOC_TYPE,sav_sae_id,orig_article_id) orig_article_id
548: FROM OKC_K_ARTICLES_B KART,
549: OKC_SECTIONS_B SCN
550: WHERE KART.DOCUMENT_TYPE=p_source_doc_type
551: AND KART.DOCUMENT_ID=p_source_doc_id
552: AND SCN.DOCUMENT_TYPE = p_target_doc_type
553: AND SCN.DOCUMENT_ID =p_target_doc_id

Line 590: OKC_SECTIONS_B SCN,

586: KART.ref_article_id,
587: KART.ref_article_version_id,
588: DECODE(p_source_doc_type,G_TEMPLATE_DOC_TYPE,KART.sav_sae_id,KART.orig_article_id) orig_article_id
589: FROM OKC_K_ARTICLES_B KART,
590: OKC_SECTIONS_B SCN,
591: OKC_SECTIONS_B SCN1,
592: OKC_K_ARTICLES_B KART1
593: WHERE KART.DOCUMENT_TYPE= p_source_doc_type
594: AND KART.DOCUMENT_ID= p_source_doc_id

Line 591: OKC_SECTIONS_B SCN1,

587: KART.ref_article_version_id,
588: DECODE(p_source_doc_type,G_TEMPLATE_DOC_TYPE,KART.sav_sae_id,KART.orig_article_id) orig_article_id
589: FROM OKC_K_ARTICLES_B KART,
590: OKC_SECTIONS_B SCN,
591: OKC_SECTIONS_B SCN1,
592: OKC_K_ARTICLES_B KART1
593: WHERE KART.DOCUMENT_TYPE= p_source_doc_type
594: AND KART.DOCUMENT_ID= p_source_doc_id
595: AND SCN.DOCUMENT_TYPE = p_target_doc_type

Line 637: OKC_SECTIONS_B SCN

633: ref_article_id,
634: ref_article_version_id,
635: orig_article_id
636: FROM OKC_K_ARTICLES_BH KART,
637: OKC_SECTIONS_B SCN
638: WHERE KART.DOCUMENT_TYPE=p_source_doc_type
639: AND KART.DOCUMENT_ID=p_source_doc_id
640: AND KART.MAJOR_VERSION = nvl(p_source_version_number,OKC_API.G_MISS_NUM)
641: AND SCN.DOCUMENT_TYPE = p_target_doc_type

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

1358:
1359: l_api_name CONSTANT VARCHAR2(30) := 'copy_sections';
1360: TYPE AttributeCategoryList IS TABLE OF OKC_SECTIONS_B.ATTRIBUTE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
1361: TYPE AttributeList IS TABLE OF OKC_SECTIONS_B.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;
1362: TYPE ScnIdList IS TABLE OF OKC_SECTIONS_B.SCN_ID%TYPE INDEX BY BINARY_INTEGER;
1363: TYPE OrigSystemReferenceId1List IS TABLE OF OKC_SECTIONS_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER;
1364: TYPE SectionSequenceList IS TABLE OF OKC_SECTIONS_B.SECTION_SEQUENCE%TYPE INDEX BY BINARY_INTEGER;
1365: TYPE HeadingList IS TABLE OF OKC_SECTIONS_B.HEADING%TYPE INDEX BY BINARY_INTEGER;
1366: TYPE LabelList IS TABLE OF OKC_SECTIONS_B.LABEL%TYPE INDEX BY BINARY_INTEGER;

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

1360: TYPE AttributeCategoryList IS TABLE OF OKC_SECTIONS_B.ATTRIBUTE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
1361: TYPE AttributeList IS TABLE OF OKC_SECTIONS_B.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;
1362: TYPE ScnIdList IS TABLE OF OKC_SECTIONS_B.SCN_ID%TYPE INDEX BY BINARY_INTEGER;
1363: TYPE OrigSystemReferenceId1List IS TABLE OF OKC_SECTIONS_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER;
1364: TYPE SectionSequenceList IS TABLE OF OKC_SECTIONS_B.SECTION_SEQUENCE%TYPE INDEX BY BINARY_INTEGER;
1365: TYPE HeadingList IS TABLE OF OKC_SECTIONS_B.HEADING%TYPE INDEX BY BINARY_INTEGER;
1366: TYPE LabelList IS TABLE OF OKC_SECTIONS_B.LABEL%TYPE INDEX BY BINARY_INTEGER;
1367: TYPE ScnCodeList IS TABLE OF OKC_SECTIONS_B.SCN_CODE%TYPE INDEX BY BINARY_INTEGER;
1368: TYPE PrintYnList IS TABLE OF OKC_SECTIONS_B.PRINT_YN%TYPE INDEX BY BINARY_INTEGER;

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

1363: TYPE OrigSystemReferenceId1List IS TABLE OF OKC_SECTIONS_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER;
1364: TYPE SectionSequenceList IS TABLE OF OKC_SECTIONS_B.SECTION_SEQUENCE%TYPE INDEX BY BINARY_INTEGER;
1365: TYPE HeadingList IS TABLE OF OKC_SECTIONS_B.HEADING%TYPE INDEX BY BINARY_INTEGER;
1366: TYPE LabelList IS TABLE OF OKC_SECTIONS_B.LABEL%TYPE INDEX BY BINARY_INTEGER;
1367: TYPE ScnCodeList IS TABLE OF OKC_SECTIONS_B.SCN_CODE%TYPE INDEX BY BINARY_INTEGER;
1368: TYPE PrintYnList IS TABLE OF OKC_SECTIONS_B.PRINT_YN%TYPE INDEX BY BINARY_INTEGER;
1369: TYPE IdList IS TABLE OF OKC_SECTIONS_B.ID%TYPE INDEX BY BINARY_INTEGER;
1370: TYPE DescriptionList IS TABLE OF OKC_SECTIONS_B.DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
1371:

Line 1405: SELECT OKC_SECTIONS_B_S.NEXTVAL,

1401: Description_tbl DescriptionList;
1402:
1403:
1404: CURSOR l_get_scn_csr IS
1405: SELECT OKC_SECTIONS_B_S.NEXTVAL,
1406: ATTRIBUTE_CATEGORY,
1407: ATTRIBUTE1,
1408: ATTRIBUTE2,
1409: ATTRIBUTE3,

Line 1438: SELECT OKC_SECTIONS_B_S.NEXTVAL,

1434: AND nvl(SUMMARY_AMEND_OPERATION_CODE,'?')<>G_AMEND_CODE_DELETED;
1435:
1436:
1437: CURSOR l_get_scn_from_archive_csr IS
1438: SELECT OKC_SECTIONS_B_S.NEXTVAL,
1439: ATTRIBUTE_CATEGORY,
1440: ATTRIBUTE1,
1441: ATTRIBUTE2,
1442: ATTRIBUTE3,