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_K_ENTITY_LOCKS_GRP dependencies on OKC_SECTIONS_B_S

Line 622: FROM okc_sections_b SOURCE -- Modification Doc

618:
619: CURSOR c_sections
620: IS
621: SELECT SOURCE.orig_system_reference_id1 old_id, target.ID new_id, klock.lock_by_entity_id
622: FROM okc_sections_b SOURCE -- Modification Doc
623: ,
624: okc_sections_b target -- Base Doc
625: ,
626: okc_k_entity_locks klock -- Locks Table

Line 638: FROM okc_sections_b SOURCE -- Modification Doc

634:
635: CURSOR c_Dummysections -- This is to Achieve Sync Functionality
636: IS
637: SELECT SOURCE.orig_system_reference_id1 old_id, target.ID new_id
638: FROM okc_sections_b SOURCE -- Modification Doc
639: ,
640: okc_sections_b target -- Base Doc
641: ,
642: okc_k_entity_locks klock -- Locks Table

Line 2027: SELECT okc_sections_b_s.NEXTVAL

2023: last_amendment_date = SYSDATE
2024: WHERE ID = p_target_doc_section_id;
2025: END IF;
2026: ELSE
2027: SELECT okc_sections_b_s.NEXTVAL
2028: INTO x_new_section_id
2029: FROM DUAL;
2030:
2031: INSERT INTO okc_sections_b tar_sec

Line 2716: okc_sections_b src

2712: CURSOR cur_get_details_from_sections
2713: IS
2714: SELECT src.document_type, To_Char(src.document_id)
2715: FROM okc_sections_b tgt,
2716: okc_sections_b src
2717: WHERE tgt.document_type= p_doc_type
2718: AND tgt.document_id= p_doc_id
2719: AND tgt.orig_system_reference_code = 'COPY'
2720: AND src.id=tgt.orig_system_reference_id1;

Line 3100: FROM okc_k_entity_locks lck, okc_sections_b sec

3096: x_return_status := G_RET_STS_SUCCESS;
3097: -- Check for sections
3098: SELECT 'Y'
3099: INTO l_lock_exists
3100: FROM okc_k_entity_locks lck, okc_sections_b sec
3101: WHERE lck.entity_name=G_SECTION_ENTITY
3102: AND lck.entity_pk1= To_Char(sec.id)
3103: AND sec.document_type= l_src_doc_type
3104: AND sec.document_id= l_src_doc_id

Line 3381: ,okc_sections_b srcMod

3377: IS
3378: SELECT tgtAward.id,srcMod.orig_system_reference_id1
3379: FROM
3380: okc_sections_b tgtAward
3381: ,okc_sections_b srcMod
3382: WHERE srcMod.document_type= p_update_from_doc_type
3383: AND srcMod.document_id= p_update_from_doc_id
3384: AND tgtAward.document_type= p_update_to_doc_type
3385: AND tgtAward.document_id= p_update_to_doc_id