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

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 1360: TYPE AttributeCategoryList IS TABLE OF OKC_SECTIONS_B.ATTRIBUTE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

1356: x_msg_data OUT NOCOPY VARCHAR2,
1357: x_msg_count OUT NOCOPY NUMBER) IS
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;

Line 1361: TYPE AttributeList IS TABLE OF OKC_SECTIONS_B.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;

1357: x_msg_count OUT NOCOPY NUMBER) IS
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;

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 1363: TYPE OrigSystemReferenceId1List IS TABLE OF OKC_SECTIONS_B.ORIG_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER;

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;
1367: TYPE ScnCodeList IS TABLE OF OKC_SECTIONS_B.SCN_CODE%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 1365: TYPE HeadingList IS TABLE OF OKC_SECTIONS_B.HEADING%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;
1369: TYPE IdList IS TABLE OF OKC_SECTIONS_B.ID%TYPE INDEX BY BINARY_INTEGER;

Line 1366: TYPE LabelList IS TABLE OF OKC_SECTIONS_B.LABEL%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;
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;

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 1368: TYPE PrintYnList IS TABLE OF OKC_SECTIONS_B.PRINT_YN%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:
1372:

Line 1369: TYPE IdList IS TABLE OF OKC_SECTIONS_B.ID%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:
1372:
1373: Id_tbl IdList;

Line 1370: TYPE DescriptionList IS TABLE OF OKC_SECTIONS_B.DESCRIPTION%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:
1372:
1373: Id_tbl IdList;
1374: Attribute_category_tbl AttributeCategoryList;

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 1430: FROM OKC_SECTIONS_B

1426: SCN_CODE,
1427: HEADING,
1428: PRINT_YN ,
1429: DESCRIPTION
1430: FROM OKC_SECTIONS_B
1431: WHERE DOCUMENT_TYPE=P_SOURCE_DOC_TYPE
1432: AND DOCUMENT_ID=P_SOURCE_DOC_ID
1433: AND nvl(AMENDMENT_OPERATION_CODE,'?')<>G_AMEND_CODE_DELETED
1434: AND nvl(SUMMARY_AMEND_OPERATION_CODE,'?')<>G_AMEND_CODE_DELETED;

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,

Line 1463: FROM OKC_SECTIONS_BH

1459: SCN_CODE,
1460: HEADING,
1461: PRINT_YN ,
1462: DESCRIPTION
1463: FROM OKC_SECTIONS_BH
1464: WHERE DOCUMENT_TYPE=P_SOURCE_DOC_TYPE
1465: AND DOCUMENT_ID=P_SOURCE_DOC_ID
1466: AND MAJOR_VERSION = nvl(p_source_version_number,OKC_API.G_MISS_NUM);
1467:

Line 1563: INSERT INTO OKC_SECTIONS_B(

1559: IF id_tbl.COUNT > 0 THEN
1560:
1561: FORALL i IN id_tbl.FIRST..id_tbl.LAST
1562:
1563: INSERT INTO OKC_SECTIONS_B(
1564: ID,
1565: DOCUMENT_TYPE,
1566: DOCUMENT_ID,
1567: CHR_ID,

Line 1721: FROM OKC_SECTIONS_B

1717: AND SOURCE_FLAG IS NULL;
1718:
1719: CURSOR l_check_unassigned_section_csr IS
1720: SELECT id
1721: FROM OKC_SECTIONS_B
1722: WHERE DOCUMENT_TYPE = p_doc_type
1723: AND DOCUMENT_ID = p_doc_id
1724: AND nvl(AMENDMENT_OPERATION_CODE,'?')<>G_AMEND_CODE_DELETED
1725: AND nvl(SUMMARY_AMEND_OPERATION_CODE,'?')<>G_AMEND_CODE_DELETED

Line 1748: SELECT ROWID FROM OKC_SECTIONS_B

1744: AND DOCUMENT_ID=p_doc_id
1745: AND SOURCE_FLAG IS NOT NULL FOR UPDATE NOWAIT;
1746:
1747: CURSOR lock_scn_for_del_csr(b_scn_id NUMBER) IS
1748: SELECT ROWID FROM OKC_SECTIONS_B
1749: WHERE DOCUMENT_TYPE=p_doc_type
1750: AND DOCUMENT_ID=p_doc_id
1751: AND id <> b_scn_id FOR UPDATE NOWAIT;
1752:

Line 1754: l_unassigned_scn_id OKC_SECTIONS_B.ID%TYPE := 0;

1750: AND DOCUMENT_ID=p_doc_id
1751: AND id <> b_scn_id FOR UPDATE NOWAIT;
1752:
1753: l_manual_art_count NUMBER;
1754: l_unassigned_scn_id OKC_SECTIONS_B.ID%TYPE := 0;
1755:
1756: BEGIN
1757:
1758: x_return_status := G_RET_STS_SUCCESS;

Line 1858: DELETE FROM OKC_SECTIONS_B WHERE DOCUMENT_TYPE=p_doc_type

1854: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1855: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'170: Deleting Sections ');
1856: END IF;
1857:
1858: DELETE FROM OKC_SECTIONS_B WHERE DOCUMENT_TYPE=p_doc_type
1859: AND DOCUMENT_ID=p_doc_id
1860: AND id <> l_unassigned_scn_id;
1861:
1862: IF p_retain_deliverable ='N' THEN