APPS.OKC_TERMS_COPY_PVT dependencies on OKC_K_ENTITY_LOCKS

Line 414: FROM okc_k_entity_locks

410: AND ( p_retain_lock_terms_yn = 'N'
411: OR
412: ( p_retain_lock_terms_yn = 'Y'
413: AND NOT EXISTS ( SELECT 'LOCKEXISTS'
414: FROM okc_k_entity_locks
415: WHERE entity_name='CLAUSE'
416: AND entity_pk1 = To_Char(KART.id)
417: AND lock_by_document_type=p_target_doc_type
418: AND lock_by_document_id=p_target_doc_id

Line 804: FROM okc_k_entity_locks

800: AND ( p_retain_lock_terms_yn = 'N'
801: OR
802: ( p_retain_lock_terms_yn = 'Y'
803: AND NOT EXISTS ( SELECT 'LOCKEXISTS'
804: FROM okc_k_entity_locks
805: WHERE entity_name='CLAUSE'
806: AND entity_pk1 = To_Char(KART.id)
807: AND lock_by_document_type=p_target_doc_type
808: AND lock_by_document_id=p_target_doc_id

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 1574: -- Using the section id from the clause, find the base section id from the okc_k_entity_locks

1570: THEN
1571: -- Add Case
1572: -- Get the orphan records.
1573:
1574: -- Using the section id from the clause, find the base section id from the okc_k_entity_locks
1575: -- using base section find the corresponding section in the current mod
1576:
1577: -- CASE ARTICLE IS ADDED IN THE TARGE DOC
1578: OPEN cur_orphan_clauses;

Line 1590: UPDATE okc_k_entity_locks

1586: WHERE id= tgt_cat_tbl(i);
1587:
1588: -- Re-build the lock table.
1589: FORALL i IN tgt_scn_upd_lock_tbl.first..tgt_scn_upd_lock_tbl.last
1590: UPDATE okc_k_entity_locks
1591: SET lock_by_entity_id = tgt_scn_tbl(i)
1592: WHERE k_entity_lock_id=tgt_scn_upd_lock_tbl(i);
1593: END IF;
1594:

Line 1829: FROM okc_k_entity_locks

1825: AND ( p_retain_lock_terms_yn = 'N'
1826: OR
1827: ( p_retain_lock_terms_yn = 'Y'
1828: AND NOT EXISTS ( SELECT 'LOCKEXISTS'
1829: FROM okc_k_entity_locks
1830: WHERE entity_name='SECTION'
1831: AND entity_pk1 = To_Char(id)
1832: AND lock_by_document_type=p_target_doc_type
1833: AND lock_by_document_id=p_target_doc_id

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 2975: okc_k_entity_locks_grp.isLockExists(P_ENTITY_NAME => okc_k_entity_locks_grp.G_XPRT_ENTITY,

2971: CLOSE l_get_usage_csr;
2972:
2973: -- Conc Mod Changes Start
2974: IF ( p_retain_lock_xprt_yn = 'Y' AND
2975: okc_k_entity_locks_grp.isLockExists(P_ENTITY_NAME => okc_k_entity_locks_grp.G_XPRT_ENTITY,
2976: p_LOCK_BY_DOCUMENT_TYPE => p_target_doc_type,
2977: p_LOCK_BY_DOCUMENT_ID => p_target_doc_id
2978: ) = 'Y'
2979: ) THEN