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_CLM_PKG dependencies on OKC_MLP_TEMPLATE_USAGES

Line 1422: SELECT 'Y' FROM okc_mlp_template_usages

1418:
1419: l_temp_exists VARCHAR2(1) := 'N';
1420:
1421: CURSOR l_get_temp_already_exists_csr IS
1422: SELECT 'Y' FROM okc_mlp_template_usages
1423: WHERE document_type = p_document_type
1424: AND document_id = p_document_id
1425: AND template_id = p_template_id;
1426:

Line 1455: INSERT INTO okc_mlp_template_usages(

1451: FETCH l_get_temp_already_exists_csr INTO l_temp_exists;
1452: CLOSE l_get_temp_already_exists_csr;
1453:
1454: IF l_temp_exists <> 'Y' THEN
1455: INSERT INTO okc_mlp_template_usages(
1456: DOCUMENT_TYPE,
1457: DOCUMENT_ID,
1458: TEMPLATE_ID,
1459: DOC_NUMBERING_SCHEME,

Line 1536: FROM OKC_MLP_TEMPLATE_USAGES

1532: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1533:
1534: CURSOR lock_csr (cp_document_type VARCHAR2, cp_document_id NUMBER, cp_object_version_number NUMBER) IS
1535: SELECT object_version_number
1536: FROM OKC_MLP_TEMPLATE_USAGES
1537: WHERE DOCUMENT_TYPE = cp_document_type AND DOCUMENT_ID = cp_document_id
1538: AND (object_version_number = cp_object_version_number OR cp_object_version_number IS NULL)
1539: FOR UPDATE OF object_version_number NOWAIT;
1540:

Line 1543: FROM OKC_MLP_TEMPLATE_USAGES

1539: FOR UPDATE OF object_version_number NOWAIT;
1540:
1541: CURSOR lchk_csr (cp_document_type VARCHAR2, cp_document_id NUMBER) IS
1542: SELECT object_version_number
1543: FROM OKC_MLP_TEMPLATE_USAGES
1544: WHERE DOCUMENT_TYPE = cp_document_type AND DOCUMENT_ID = cp_document_id;
1545:
1546: l_return_status VARCHAR2(1);
1547: l_api_name CONSTANT VARCHAR2(30) := 'lock_row';

Line 1588: 'ENTITYNAME','OKC_MLP_TEMPLATE_USAGES',

1584: CLOSE lchk_csr;
1585:
1586: IF (l_row_notfound) THEN
1587: Okc_Api.Set_Message(G_FND_APP,G_LOCK_RECORD_DELETED,
1588: 'ENTITYNAME','OKC_MLP_TEMPLATE_USAGES',
1589: 'PKEY',p_document_type||':'||p_document_id,
1590: 'OVN',p_object_version_number
1591: );
1592: ELSIF l_object_version_number > p_object_version_number THEN

Line 1662: DELETE FROM OKC_MLP_TEMPLATE_USAGES WHERE DOCUMENT_TYPE = p_document_type AND DOCUMENT_ID = p_document_id;

1658: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1659: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'300: Removing rows');
1660: END IF;
1661:
1662: DELETE FROM OKC_MLP_TEMPLATE_USAGES WHERE DOCUMENT_TYPE = p_document_type AND DOCUMENT_ID = p_document_id;
1663:
1664: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1665: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1666: ELSIF (x_return_status = G_RET_STS_ERROR) THEN

Line 1713: SELECT template_id FROM okc_mlp_template_usages

1709: SELECT 'Y' FROM dual WHERE p_template_id IN (
1710: SELECT template_id FROM okc_template_usages
1711: WHERE document_type = p_document_type AND document_id = p_document_id
1712: UNION ALL
1713: SELECT template_id FROM okc_mlp_template_usages
1714: WHERE document_type = p_document_type AND document_id = p_document_id);
1715:
1716: l_template_exists VARCHAR2(1) := 'N';
1717:

Line 1770: TYPE TemplateIdList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.TEMPLATE_ID%TYPE INDEX BY BINARY_INTEGER;

1766: x_msg_count OUT NOCOPY NUMBER)
1767: IS
1768: l_api_name CONSTANT VARCHAR2(30) := 'copy_usages_row';
1769:
1770: TYPE TemplateIdList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.TEMPLATE_ID%TYPE INDEX BY BINARY_INTEGER;
1771: TYPE DocNumSchemeList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.DOC_NUMBERING_SCHEME%TYPE INDEX BY BINARY_INTEGER;
1772: TYPE DocumentNumberList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.DOCUMENT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
1773: TYPE ArticleEffectiveDateList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.ARTICLE_EFFECTIVE_DATE%TYPE INDEX BY BINARY_INTEGER;
1774: TYPE ConfigHeaderIdList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.CONFIG_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;

Line 1771: TYPE DocNumSchemeList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.DOC_NUMBERING_SCHEME%TYPE INDEX BY BINARY_INTEGER;

1767: IS
1768: l_api_name CONSTANT VARCHAR2(30) := 'copy_usages_row';
1769:
1770: TYPE TemplateIdList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.TEMPLATE_ID%TYPE INDEX BY BINARY_INTEGER;
1771: TYPE DocNumSchemeList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.DOC_NUMBERING_SCHEME%TYPE INDEX BY BINARY_INTEGER;
1772: TYPE DocumentNumberList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.DOCUMENT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
1773: TYPE ArticleEffectiveDateList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.ARTICLE_EFFECTIVE_DATE%TYPE INDEX BY BINARY_INTEGER;
1774: TYPE ConfigHeaderIdList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.CONFIG_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
1775: TYPE ConfigRevisionNumberList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.CONFIG_REVISION_NUMBER%TYPE INDEX BY BINARY_INTEGER;

Line 1772: TYPE DocumentNumberList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.DOCUMENT_NUMBER%TYPE INDEX BY BINARY_INTEGER;

1768: l_api_name CONSTANT VARCHAR2(30) := 'copy_usages_row';
1769:
1770: TYPE TemplateIdList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.TEMPLATE_ID%TYPE INDEX BY BINARY_INTEGER;
1771: TYPE DocNumSchemeList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.DOC_NUMBERING_SCHEME%TYPE INDEX BY BINARY_INTEGER;
1772: TYPE DocumentNumberList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.DOCUMENT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
1773: TYPE ArticleEffectiveDateList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.ARTICLE_EFFECTIVE_DATE%TYPE INDEX BY BINARY_INTEGER;
1774: TYPE ConfigHeaderIdList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.CONFIG_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
1775: TYPE ConfigRevisionNumberList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.CONFIG_REVISION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
1776: TYPE ValidConfigYNList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.VALID_CONFIG_YN%TYPE INDEX BY BINARY_INTEGER;

Line 1773: TYPE ArticleEffectiveDateList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.ARTICLE_EFFECTIVE_DATE%TYPE INDEX BY BINARY_INTEGER;

1769:
1770: TYPE TemplateIdList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.TEMPLATE_ID%TYPE INDEX BY BINARY_INTEGER;
1771: TYPE DocNumSchemeList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.DOC_NUMBERING_SCHEME%TYPE INDEX BY BINARY_INTEGER;
1772: TYPE DocumentNumberList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.DOCUMENT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
1773: TYPE ArticleEffectiveDateList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.ARTICLE_EFFECTIVE_DATE%TYPE INDEX BY BINARY_INTEGER;
1774: TYPE ConfigHeaderIdList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.CONFIG_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
1775: TYPE ConfigRevisionNumberList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.CONFIG_REVISION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
1776: TYPE ValidConfigYNList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.VALID_CONFIG_YN%TYPE INDEX BY BINARY_INTEGER;
1777: TYPE OrigSystemRefCodeList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.ORIG_SYSTEM_REFERENCE_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 1774: TYPE ConfigHeaderIdList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.CONFIG_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;

1770: TYPE TemplateIdList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.TEMPLATE_ID%TYPE INDEX BY BINARY_INTEGER;
1771: TYPE DocNumSchemeList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.DOC_NUMBERING_SCHEME%TYPE INDEX BY BINARY_INTEGER;
1772: TYPE DocumentNumberList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.DOCUMENT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
1773: TYPE ArticleEffectiveDateList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.ARTICLE_EFFECTIVE_DATE%TYPE INDEX BY BINARY_INTEGER;
1774: TYPE ConfigHeaderIdList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.CONFIG_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
1775: TYPE ConfigRevisionNumberList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.CONFIG_REVISION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
1776: TYPE ValidConfigYNList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.VALID_CONFIG_YN%TYPE INDEX BY BINARY_INTEGER;
1777: TYPE OrigSystemRefCodeList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.ORIG_SYSTEM_REFERENCE_CODE%TYPE INDEX BY BINARY_INTEGER;
1778: TYPE OrigSystemRefIdList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.ORIG_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER;

Line 1775: TYPE ConfigRevisionNumberList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.CONFIG_REVISION_NUMBER%TYPE INDEX BY BINARY_INTEGER;

1771: TYPE DocNumSchemeList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.DOC_NUMBERING_SCHEME%TYPE INDEX BY BINARY_INTEGER;
1772: TYPE DocumentNumberList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.DOCUMENT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
1773: TYPE ArticleEffectiveDateList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.ARTICLE_EFFECTIVE_DATE%TYPE INDEX BY BINARY_INTEGER;
1774: TYPE ConfigHeaderIdList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.CONFIG_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
1775: TYPE ConfigRevisionNumberList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.CONFIG_REVISION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
1776: TYPE ValidConfigYNList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.VALID_CONFIG_YN%TYPE INDEX BY BINARY_INTEGER;
1777: TYPE OrigSystemRefCodeList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.ORIG_SYSTEM_REFERENCE_CODE%TYPE INDEX BY BINARY_INTEGER;
1778: TYPE OrigSystemRefIdList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.ORIG_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER;
1779: TYPE LockTermsList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.lock_terms_flag%TYPE INDEX BY BINARY_INTEGER;

Line 1776: TYPE ValidConfigYNList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.VALID_CONFIG_YN%TYPE INDEX BY BINARY_INTEGER;

1772: TYPE DocumentNumberList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.DOCUMENT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
1773: TYPE ArticleEffectiveDateList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.ARTICLE_EFFECTIVE_DATE%TYPE INDEX BY BINARY_INTEGER;
1774: TYPE ConfigHeaderIdList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.CONFIG_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
1775: TYPE ConfigRevisionNumberList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.CONFIG_REVISION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
1776: TYPE ValidConfigYNList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.VALID_CONFIG_YN%TYPE INDEX BY BINARY_INTEGER;
1777: TYPE OrigSystemRefCodeList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.ORIG_SYSTEM_REFERENCE_CODE%TYPE INDEX BY BINARY_INTEGER;
1778: TYPE OrigSystemRefIdList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.ORIG_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER;
1779: TYPE LockTermsList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.lock_terms_flag%TYPE INDEX BY BINARY_INTEGER;
1780: TYPE LockedByUserIdList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.locked_by_user_id%TYPE INDEX BY BINARY_INTEGER;

Line 1777: TYPE OrigSystemRefCodeList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.ORIG_SYSTEM_REFERENCE_CODE%TYPE INDEX BY BINARY_INTEGER;

1773: TYPE ArticleEffectiveDateList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.ARTICLE_EFFECTIVE_DATE%TYPE INDEX BY BINARY_INTEGER;
1774: TYPE ConfigHeaderIdList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.CONFIG_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
1775: TYPE ConfigRevisionNumberList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.CONFIG_REVISION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
1776: TYPE ValidConfigYNList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.VALID_CONFIG_YN%TYPE INDEX BY BINARY_INTEGER;
1777: TYPE OrigSystemRefCodeList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.ORIG_SYSTEM_REFERENCE_CODE%TYPE INDEX BY BINARY_INTEGER;
1778: TYPE OrigSystemRefIdList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.ORIG_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER;
1779: TYPE LockTermsList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.lock_terms_flag%TYPE INDEX BY BINARY_INTEGER;
1780: TYPE LockedByUserIdList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.locked_by_user_id%TYPE INDEX BY BINARY_INTEGER;
1781: TYPE PrimaryTemplateList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.primary_template%TYPE INDEX BY BINARY_INTEGER;

Line 1778: TYPE OrigSystemRefIdList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.ORIG_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER;

1774: TYPE ConfigHeaderIdList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.CONFIG_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
1775: TYPE ConfigRevisionNumberList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.CONFIG_REVISION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
1776: TYPE ValidConfigYNList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.VALID_CONFIG_YN%TYPE INDEX BY BINARY_INTEGER;
1777: TYPE OrigSystemRefCodeList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.ORIG_SYSTEM_REFERENCE_CODE%TYPE INDEX BY BINARY_INTEGER;
1778: TYPE OrigSystemRefIdList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.ORIG_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER;
1779: TYPE LockTermsList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.lock_terms_flag%TYPE INDEX BY BINARY_INTEGER;
1780: TYPE LockedByUserIdList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.locked_by_user_id%TYPE INDEX BY BINARY_INTEGER;
1781: TYPE PrimaryTemplateList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.primary_template%TYPE INDEX BY BINARY_INTEGER;
1782:

Line 1779: TYPE LockTermsList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.lock_terms_flag%TYPE INDEX BY BINARY_INTEGER;

1775: TYPE ConfigRevisionNumberList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.CONFIG_REVISION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
1776: TYPE ValidConfigYNList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.VALID_CONFIG_YN%TYPE INDEX BY BINARY_INTEGER;
1777: TYPE OrigSystemRefCodeList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.ORIG_SYSTEM_REFERENCE_CODE%TYPE INDEX BY BINARY_INTEGER;
1778: TYPE OrigSystemRefIdList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.ORIG_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER;
1779: TYPE LockTermsList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.lock_terms_flag%TYPE INDEX BY BINARY_INTEGER;
1780: TYPE LockedByUserIdList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.locked_by_user_id%TYPE INDEX BY BINARY_INTEGER;
1781: TYPE PrimaryTemplateList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.primary_template%TYPE INDEX BY BINARY_INTEGER;
1782:
1783: TemplateIdTbl TemplateIdList;

Line 1780: TYPE LockedByUserIdList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.locked_by_user_id%TYPE INDEX BY BINARY_INTEGER;

1776: TYPE ValidConfigYNList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.VALID_CONFIG_YN%TYPE INDEX BY BINARY_INTEGER;
1777: TYPE OrigSystemRefCodeList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.ORIG_SYSTEM_REFERENCE_CODE%TYPE INDEX BY BINARY_INTEGER;
1778: TYPE OrigSystemRefIdList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.ORIG_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER;
1779: TYPE LockTermsList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.lock_terms_flag%TYPE INDEX BY BINARY_INTEGER;
1780: TYPE LockedByUserIdList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.locked_by_user_id%TYPE INDEX BY BINARY_INTEGER;
1781: TYPE PrimaryTemplateList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.primary_template%TYPE INDEX BY BINARY_INTEGER;
1782:
1783: TemplateIdTbl TemplateIdList;
1784: DocNumSchemeTbl DocNumSchemeList;

Line 1781: TYPE PrimaryTemplateList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.primary_template%TYPE INDEX BY BINARY_INTEGER;

1777: TYPE OrigSystemRefCodeList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.ORIG_SYSTEM_REFERENCE_CODE%TYPE INDEX BY BINARY_INTEGER;
1778: TYPE OrigSystemRefIdList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.ORIG_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER;
1779: TYPE LockTermsList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.lock_terms_flag%TYPE INDEX BY BINARY_INTEGER;
1780: TYPE LockedByUserIdList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.locked_by_user_id%TYPE INDEX BY BINARY_INTEGER;
1781: TYPE PrimaryTemplateList IS TABLE OF OKC_MLP_TEMPLATE_USAGES.primary_template%TYPE INDEX BY BINARY_INTEGER;
1782:
1783: TemplateIdTbl TemplateIdList;
1784: DocNumSchemeTbl DocNumSchemeList;
1785: DocumentNumberTbl DocumentNumberList;

Line 1811: FROM okc_mlp_template_usages

1807: ORIG_SYSTEM_REFERENCE_ID2,
1808: LOCK_TERMS_FLAG,
1809: LOCKED_BY_USER_ID,
1810: PRIMARY_TEMPLATE
1811: FROM okc_mlp_template_usages
1812: WHERE document_type = p_source_doc_type
1813: AND document_id = p_source_doc_id;
1814:
1815: BEGIN

Line 1843: INSERT INTO okc_mlp_template_usages(

1839:
1840: IF TemplateIdTbl.COUNT > 0 THEN
1841: FORALL i IN TemplateIdTbl.FIRST..TemplateIdTbl.LAST
1842:
1843: INSERT INTO okc_mlp_template_usages(
1844: DOCUMENT_TYPE,
1845: DOCUMENT_ID,
1846: TEMPLATE_ID,
1847: DOC_NUMBERING_SCHEME,