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 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 981: FROM okc_k_articles_b tgt, okc_k_entity_locks lck, okc_sections_b tgtsec

977: -------------------- CONC MOD CHANGES START -------------
978: CURSOR cur_orphan_clauses
979: IS
980: SELECT tgt.id,tgtsec.id, lck.k_entity_lock_id
981: FROM okc_k_articles_b tgt, okc_k_entity_locks lck, okc_sections_b tgtsec
982: WHERE tgt.document_type= p_target_doc_type
983: AND tgt.document_id= p_target_doc_id
984: AND tgt.summary_amend_operation_code = 'ADDED'
985: AND lck.entity_name='DUMMYSEC'

Line 999: ,okc_sections_b tgtsec

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
1003: AND tgtart.document_id= p_target_doc_id

Line 1736: TYPE AttributeCategoryList IS TABLE OF OKC_SECTIONS_B.ATTRIBUTE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

1732: p_retain_clauses IN VARCHAR2 DEFAULT 'N'
1733: ,p_retain_lock_terms_yn IN VARCHAR2 DEFAULT 'N') IS
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;

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

1733: ,p_retain_lock_terms_yn IN VARCHAR2 DEFAULT 'N') IS
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;

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

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

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

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

Line 1745: TYPE IdList IS TABLE OF OKC_SECTIONS_B.ID%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:
1748:
1749: Id_tbl IdList;

Line 1746: TYPE DescriptionList IS TABLE OF OKC_SECTIONS_B.DESCRIPTION%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:
1748:
1749: Id_tbl IdList;
1750: Attribute_category_tbl AttributeCategoryList;

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

1808: SCN_CODE,
1809: HEADING,
1810: PRINT_YN ,
1811: DESCRIPTION
1812: FROM OKC_SECTIONS_B
1813: WHERE DOCUMENT_TYPE=P_SOURCE_DOC_TYPE
1814: AND DOCUMENT_ID=P_SOURCE_DOC_ID
1815: AND nvl(AMENDMENT_OPERATION_CODE,'?')<>G_AMEND_CODE_DELETED
1816: AND nvl(SUMMARY_AMEND_OPERATION_CODE,'?')<>G_AMEND_CODE_DELETED

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 1878: FROM OKC_SECTIONS_BH

1874: SCN_CODE,
1875: HEADING,
1876: PRINT_YN ,
1877: DESCRIPTION
1878: FROM OKC_SECTIONS_BH
1879: WHERE DOCUMENT_TYPE=P_SOURCE_DOC_TYPE
1880: AND DOCUMENT_ID=P_SOURCE_DOC_ID
1881: AND MAJOR_VERSION = nvl(p_source_version_number,OKC_API.G_MISS_NUM)
1882: AND (( l_scn_drp_action = 'DROP_AMEND_SEC' AND

Line 1893: SELECT Max(section_sequence) FROM okc_sections_b

1889: l_scn_drp_action = 'DROP_NOTHING');
1890:
1891: --kkolukul: CLM changes
1892: CURSOR l_scn_sqn_csr IS
1893: SELECT Max(section_sequence) FROM okc_sections_b
1894: WHERE DOCUMENT_TYPE=P_TARGET_DOC_TYPE
1895: AND DOCUMENT_ID=P_TARGET_DOC_ID;
1896:
1897: CURSOR l_get_scn_exists_in_doc(p_scn_code varchar2) IS

Line 1899: FROM okc_sections_b

1895: AND DOCUMENT_ID=P_TARGET_DOC_ID;
1896:
1897: CURSOR l_get_scn_exists_in_doc(p_scn_code varchar2) IS
1898: SELECT 'Y'
1899: FROM okc_sections_b
1900: WHERE document_type = p_target_doc_type
1901: AND document_id = p_target_doc_id
1902: AND scn_code = p_scn_code;
1903:

Line 1908: FROM okc_sections_b tgtsec

1904: -------------------- CONC MOD CHANGES -------------
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

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

Line 1910: ,okc_sections_b tgtsec2

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
1914: AND tgtsec.summary_amend_operation_code IN ('UPDATED','DELTED')

Line 1926: TYPE ScnList IS TABLE OF okc_sections_b.ID%TYPE INDEX BY BINARY_INTEGER;

1922: AND tgtsec2.ORIG_SYSTEM_REFERENCE_ID1=srcsec.scn_id;
1923: -------------------- CONC MOD CHANGES -------------
1924:
1925:
1926: TYPE ScnList IS TABLE OF okc_sections_b.ID%TYPE INDEX BY BINARY_INTEGER;
1927:
1928:
1929:
1930: tgt_id_upd_tbl ScnList;

Line 2060: INSERT INTO OKC_SECTIONS_B(

2056: IF id_tbl.COUNT > 0 THEN
2057:
2058: FORALL i IN id_tbl.FIRST..id_tbl.LAST
2059:
2060: INSERT INTO OKC_SECTIONS_B(
2061: ID,
2062: DOCUMENT_TYPE,
2063: DOCUMENT_ID,
2064: CHR_ID,

Line 2238: FROM OKC_SECTIONS_B

2234: AND SOURCE_FLAG IS NULL;
2235:
2236: CURSOR l_check_unassigned_section_csr IS
2237: SELECT id
2238: FROM OKC_SECTIONS_B
2239: WHERE DOCUMENT_TYPE = p_doc_type
2240: AND DOCUMENT_ID = p_doc_id
2241: AND nvl(AMENDMENT_OPERATION_CODE,'?')<>G_AMEND_CODE_DELETED
2242: AND nvl(SUMMARY_AMEND_OPERATION_CODE,'?')<>G_AMEND_CODE_DELETED

Line 2265: SELECT ROWID FROM OKC_SECTIONS_B

2261: AND DOCUMENT_ID=p_doc_id
2262: AND SOURCE_FLAG IS NOT NULL FOR UPDATE NOWAIT;
2263:
2264: CURSOR lock_scn_for_del_csr(b_scn_id NUMBER) IS
2265: SELECT ROWID FROM OKC_SECTIONS_B
2266: WHERE DOCUMENT_TYPE=p_doc_type
2267: AND DOCUMENT_ID=p_doc_id
2268: AND id <> b_scn_id FOR UPDATE NOWAIT;
2269:

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

2273: FROM OKC_MLP_TEMPLATE_USAGES
2274: WHERE DOCUMENT_TYPE = p_doc_type AND DOCUMENT_ID = p_doc_id;
2275:
2276: l_manual_art_count NUMBER;
2277: l_unassigned_scn_id OKC_SECTIONS_B.ID%TYPE := 0;
2278: l_objnum NUMBER;
2279: l_found BOOLEAN;
2280:
2281:

Line 2395: DELETE FROM OKC_SECTIONS_B WHERE DOCUMENT_TYPE=p_doc_type

2391: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2392: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'170: Deleting Sections ');
2393: END IF;
2394:
2395: DELETE FROM OKC_SECTIONS_B WHERE DOCUMENT_TYPE=p_doc_type
2396: AND DOCUMENT_ID=p_doc_id
2397: AND id <> l_unassigned_scn_id;
2398:
2399: IF p_retain_deliverable ='N' THEN