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

Line 112: l_from_table := 'OKC_SECTIONS_B';

108: l_entity_pk1_column := 'ID';
109: l_entity_pk1_n := TO_NUMBER (p_entity_pk1);
110: ELSIF p_entity_name = G_SECTION_ENTITY
111: THEN
112: l_from_table := 'OKC_SECTIONS_B';
113: l_entity_pk1_column := 'ID';
114: l_entity_pk1_n := TO_NUMBER (p_entity_pk1);
115: ELSIF p_entity_name = G_XPRT_ENTITY
116: THEN

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 624: okc_sections_b target -- Base Doc

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
627: WHERE SOURCE.document_type = p_update_from_doc_type
628: AND SOURCE.document_id = p_update_from_doc_id

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 640: okc_sections_b target -- Base Doc

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
643: WHERE SOURCE.document_type = p_update_from_doc_type
644: AND SOURCE.document_id = p_update_from_doc_id

Line 720: UPDATE okc_sections_b

716: SET entity_pk1 = l_new_scn_id_tbl (i)
717: WHERE entity_pk1 = l_old_scn_id_tbl (i) AND entity_name = G_SECTION_ENTITY;
718:
719: FORALL i IN l_new_scn_id_tbl.first..l_new_scn_id_tbl.LAST
720: UPDATE okc_sections_b
721: SET orig_system_reference_id1 = l_new_scn_id_tbl(i)
722: WHERE id = l_upd_sec_id_tbl(i);
723:
724: --c) No need to re-build locks for xprt as the document type and document id will not be changed.

Line 1108: FROM okc_sections_b

1104: CURSOR cur_target_doc_scn (p_scn_id NUMBER)
1105: IS
1106: SELECT orig_system_reference_code, orig_system_reference_id1,
1107: amendment_operation_code
1108: FROM okc_sections_b
1109: WHERE ID = p_scn_id
1110: AND document_type = p_target_document_type
1111: AND document_id = p_target_document_id; */
1112:

Line 1117: FROM okc_sections_b

1113:
1114: CURSOR cur_target_doc_scn1(cp_orig_sys_ref_id1 NUMBER )
1115: IS
1116: SELECT id,amendment_operation_code
1117: FROM okc_sections_b
1118: WHERE 1=1
1119: AND orig_system_reference_id1 = cp_orig_sys_ref_id1
1120: AND document_type = p_target_document_type
1121: AND document_id = p_target_document_id;

Line 1378: FROM okc_sections_b

1374: /*
1375: CURSOR cur_val_scn (cp_scn_id NUMBER)
1376: IS
1377: SELECT 'Y'
1378: FROM okc_sections_b
1379: WHERE ID = cp_scn_id
1380: AND NVL (amendment_operation_code, '?') <> 'DELETED'; */
1381:
1382: l_found VARCHAR2 (1);

Line 1927: FROM okc_sections_b

1923: SELECT ID, scn_id parent_scn_id, scn_code, amendment_operation_code,
1924: orig_system_reference_id1, heading, label, section_sequence ,
1925: amendment_description,
1926: summary_amend_operation_code
1927: FROM okc_sections_b
1928: WHERE ID = cp_scn_id;
1929:
1930:
1931: CURSOR cur_scn_details1 (cp_scn_id number)

Line 1934: FROM okc_sections_b

1930:
1931: CURSOR cur_scn_details1 (cp_scn_id number)
1932: IS SELECT ID, scn_id parent_scn_id, scn_code, amendment_operation_code,
1933: orig_system_reference_id1, heading, label, section_sequence
1934: FROM okc_sections_b
1935: WHERE orig_system_reference_id1 = cp_scn_id
1936: AND document_type = p_target_document_type
1937: AND document_id=p_target_document_id;
1938:

Line 2008: UPDATE okc_sections_b

2004: THEN
2005: -- section is coming from library no need to copy from base document.
2006: -- For PAR merge to MOd we need to stamp the amendment_operation code etc from PAR
2007: IF (Nvl(p_keep_orig_ref,'N') = 'N' ) THEN
2008: UPDATE okc_sections_b
2009: SET amendment_description = NULL,
2010: amendment_operation_code = NULL,
2011: summary_amend_operation_code = NULL,
2012: scn_id = l_parent_scn_id,

Line 2017: UPDATE okc_sections_b

2013: last_amended_by = NULL,
2014: last_amendment_date = NULL
2015: WHERE ID = p_target_doc_section_id;
2016: ELSE
2017: UPDATE okc_sections_b
2018: SET amendment_description = l_par_scn_details_rec.amendment_description,
2019: amendment_operation_code = l_par_scn_details_rec.amendment_operation_code,
2020: summary_amend_operation_code = l_par_scn_details_rec.summary_amend_operation_code,
2021: scn_id = p_scn_id,

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 2031: INSERT INTO okc_sections_b tar_sec

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
2032: (ID, chr_id, heading, description, document_type,
2033: document_id, scn_id, orig_system_reference_code,
2034: orig_system_reference_id1, orig_system_reference_id2,
2035: section_sequence, label, print_yn, attribute_category,

Line 2069: FROM okc_sections_b

2065: ,Decode(p_keep_orig_ref,'Y',amendment_operation_code,null)
2066: ,Decode(p_keep_orig_ref,'Y',summary_amend_operation_code,null)
2067: ,Decode(p_keep_orig_ref,'Y',fnd_global.user_id,null)
2068: ,Decode(p_keep_orig_ref,'Y',sysdate,To_Date(NULL))
2069: FROM okc_sections_b
2070: WHERE ID = p_source_section_id;
2071:
2072: IF SQL%ROWCOUNT = 0 THEN
2073: okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 2081: UPDATE okc_sections_b

2077: RAISE FND_API.G_EXC_ERROR;
2078: END IF;
2079:
2080: -- Update the existsing sub-sections /clauses with the new section id.
2081: UPDATE okc_sections_b
2082: SET scn_id = x_new_section_id
2083: WHERE document_type = p_target_document_type
2084: AND document_id = p_target_document_id
2085: AND scn_id = p_target_doc_section_id;

Line 2113: FROM okc_sections_b

2109: IS
2110: CURSOR cur_tgt_sec_details
2111: IS
2112: SELECT scn_code, ROWID
2113: FROM okc_sections_b
2114: WHERE ID = p_target_doc_section_id;
2115:
2116: l_cur_tgt_rec cur_tgt_sec_details%ROWTYPE;
2117:

Line 2160: DELETE FROM okc_sections_b

2156: THEN
2157: DELETE FROM okc_sections_tl
2158: WHERE ID = p_target_doc_section_id;
2159:
2160: DELETE FROM okc_sections_b
2161: WHERE ROWID = l_cur_tgt_rec.ROWID;
2162: END IF;
2163:
2164: p_target_doc_section_id := l_tgt_scn_id;

Line 2677: FROM okc_sections_b

2673: WHERE id=To_Number(p_entity_pk1);
2674: ELSIF p_entity_name = G_SECTION_ENTITY THEN
2675: SELECT heading
2676: INTO l_title
2677: FROM okc_sections_b
2678: WHERE id=To_Number(p_entity_pk1);
2679: ELSIF p_entity_name = G_DLVBL_ENTITY THEN
2680: SELECT deliverable_name
2681: INTO l_title

Line 2715: FROM okc_sections_b tgt,

2711:
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'

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 2857: FROM okc_sections_b

2853:
2854: CURSOR cur_src_sec_details(cp_sec_id NUMBER)
2855: IS
2856: SELECT document_type,document_id
2857: FROM okc_sections_b
2858: WHERE id= cp_sec_id;
2859:
2860: l_src_doc_type VARCHAR2(30);
2861: l_src_doc_id NUMBER;

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 3380: okc_sections_b tgtAward

3376: CURSOR cur_sec_ids
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

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

Line 3461: update okc_sections_b

3457:
3458: IF l_tgt_id_tbl.Count > 0 THEN
3459:
3460: FORALL i IN l_tgt_id_tbl.first..l_tgt_id_tbl.last
3461: update okc_sections_b
3462: set id= l_src_ref_id_tbl(i)
3463: where id=l_tgt_id_tbl(i);
3464:
3465: FORALL i IN l_tgt_id_tbl.first..l_tgt_id_tbl.last

Line 3466: UPDATE okc_sections_b

3462: set id= l_src_ref_id_tbl(i)
3463: where id=l_tgt_id_tbl(i);
3464:
3465: FORALL i IN l_tgt_id_tbl.first..l_tgt_id_tbl.last
3466: UPDATE okc_sections_b
3467: SET scn_id= l_src_ref_id_tbl(i)
3468: WHERE scn_id= l_tgt_id_tbl(i)
3469: AND document_type= p_update_to_doc_type
3470: AND document_id=p_update_from_doc_id;

Line 3586: FROM okc_sections_b

3582:
3583: CURSOR cur_section
3584: IS
3585: SELECT 'Y'
3586: FROM okc_sections_b
3587: WHERE document_type= p_doc_type
3588: AND document_id= p_doc_id
3589: AND amendment_operation_code IS NOT NULL;
3590:

Line 3654: FROM okc_sections_b

3650: SELECT entity
3651: INTO l_entity
3652: FROM
3653: (SELECT 'SECTION' entity, orig_system_reference_id1 , amendment_operation_code, summary_amend_operation_code
3654: FROM okc_sections_b
3655: WHERE document_type= p_doc_type
3656: AND document_id= p_doc_id
3657: AND summary_amend_operation_code IN ('UPDATED','DELETED')
3658: UNION ALL

Line 3758: FROM okc_sections_b

3754: orig_system_reference_code,
3755: orig_system_reference_id1,
3756: orig_system_reference_id2,
3757: scn_id
3758: FROM okc_sections_b
3759: WHERE document_type = p_src_doc_type
3760: AND document_id = p_src_doc_id
3761: AND amendment_operation_code IS NOT NULL
3762: ORDER BY Nvl(scn_id,-99),id;

Line 3769: FROM okc_sections_b

3765:
3766: CURSOR cur_get_tar_scnid (cp_scn_id NUMBER)
3767: IS
3768: SELECT id
3769: FROM okc_sections_b
3770: WHERE document_type = p_target_doc_type
3771: AND document_id = p_target_doc_id
3772: AND orig_system_reference_id1 = cp_scn_id;
3773: