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_K_ARTICLES_B

Line 107: l_from_table := 'OKC_K_ARTICLES_B';

103: END IF;
104:
105: IF p_entity_name = G_CLAUSE_ENTITY
106: THEN
107: l_from_table := 'OKC_K_ARTICLES_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

Line 606: FROM okc_k_articles_b SOURCE -- Modification Doc

602: -- Get the list of source clauses from the Modification document
603: CURSOR c_clauses
604: IS
605: SELECT SOURCE.orig_system_reference_id1 old_id, target.ID new_id , klock.LOCK_by_entity_id
606: FROM okc_k_articles_b SOURCE -- Modification Doc
607: ,
608: okc_k_articles_b target -- Base Doc
609: ,
610: okc_k_entity_locks klock -- Locks Table

Line 608: okc_k_articles_b target -- Base Doc

604: IS
605: SELECT SOURCE.orig_system_reference_id1 old_id, target.ID new_id , klock.LOCK_by_entity_id
606: FROM okc_k_articles_b SOURCE -- Modification Doc
607: ,
608: okc_k_articles_b target -- Base Doc
609: ,
610: okc_k_entity_locks klock -- Locks Table
611: WHERE SOURCE.document_type = p_update_from_doc_type
612: AND SOURCE.document_id = p_update_from_doc_id

Line 702: UPDATE OKC_K_ARTICLES_B

698: AND entity_name = G_CLAUSE_ENTITY;
699:
700: -- Update the Lock By articles with the correct orig_sys_ref.
701: FORALL i IN l_new_clause_id_tbl.first..l_new_clause_id_tbl.LAST
702: UPDATE OKC_K_ARTICLES_B
703: SET orig_system_reference_id1 = l_new_clause_id_tbl(i)
704: WHERE id = l_upd_clause_id_tbl(i);
705:
706: -- b) Rebuild locks for sections

Line 1083: FROM okc_k_articles_b kart

1079: kart.mandatory_rwa, kart.label, kart.display_sequence,
1080: kart.ref_article_id, kart.ref_article_version_id,
1081: kart.orig_article_id, NULL amend_operation_code,
1082: kart.orig_system_reference_id1 src_orig_system_reference_id1
1083: FROM okc_k_articles_b kart
1084: WHERE kart.ID = p_source_doc_clause_id;
1085:
1086: l_doc_clause_rec l_get_art_csr%ROWTYPE;
1087: x_article_version_id NUMBER;

Line 1095: FROM okc_k_articles_b

1091:
1092: CURSOR cur_get_clause_scn (cp_clause_id NUMBER)
1093: IS
1094: SELECT scn_id, orig_system_reference_id1
1095: FROM okc_k_articles_b
1096: WHERE ID = cp_clause_id;
1097:
1098: l_target_scn_id NUMBER;
1099: l_target_art_orig_ref_id1 NUMBER;

Line 1209: -- Insert the record into okc_k_articles_b

1205: l_doc_clause_rec.article_version_id := x_article_version_id;
1206: l_doc_clause_rec.sav_sae_id := x_article_id;
1207: END IF;
1208:
1209: -- Insert the record into okc_k_articles_b
1210: INSERT INTO okc_k_articles_b
1211: (ID, sav_sae_id,
1212: document_type, document_id,
1213: chr_id,

Line 1210: INSERT INTO okc_k_articles_b

1206: l_doc_clause_rec.sav_sae_id := x_article_id;
1207: END IF;
1208:
1209: -- Insert the record into okc_k_articles_b
1210: INSERT INTO okc_k_articles_b
1211: (ID, sav_sae_id,
1212: document_type, document_id,
1213: chr_id,
1214: dnz_chr_id,

Line 1241: VALUES (okc_k_articles_b_s.NEXTVAL, l_doc_clause_rec.sav_sae_id,

1237: created_by, creation_date, last_updated_by,
1238: last_update_login, last_update_date,
1239: orig_article_id
1240: )
1241: VALUES (okc_k_articles_b_s.NEXTVAL, l_doc_clause_rec.sav_sae_id,
1242: p_target_document_type, p_target_document_id,
1243: DECODE (p_target_document_type,
1244: 'OKC_BUY', p_target_document_id,
1245: 'OKC_SELL', p_target_document_id,

Line 1493: FROM okc_k_articles_b

1489: cp_document_id IN NUMBER
1490: )
1491: IS
1492: SELECT ID
1493: FROM okc_k_articles_b
1494: WHERE document_type = cp_document_type
1495: AND document_id = cp_document_id
1496: AND source_flag = 'R';
1497:

Line 1516: FROM okc_k_articles_b

1512: cp_document_id IN NUMBER
1513: )
1514: IS
1515: SELECT TO_CHAR (orig_system_reference_id1)
1516: FROM okc_k_articles_b
1517: WHERE document_type = cp_document_type
1518: AND document_id = cp_document_id
1519: AND source_flag = 'R'
1520: AND orig_system_reference_id1 IS NOT NULL;

Line 1559: DELETE FROM okc_k_articles_b

1555: end if;
1556: --------------------------------------------
1557: -- Delete contract expert suggested clauses
1558: --------------------------------------------
1559: DELETE FROM okc_k_articles_b
1560: WHERE document_type = p_target_document_type
1561: AND document_id = p_target_document_id
1562: AND source_flag = 'R'
1563: ;

Line 1729: okc_k_articles_b kart,

1725: busvar.value_set_id, var.variable_value,
1726: var.variable_value_id, var.override_global_yn,
1727: var.mr_variable_html, var.mr_variable_xml, busvar.mrv_flag
1728: FROM okc_k_art_variables var,
1729: okc_k_articles_b kart,
1730: okc_k_articles_b kart_tar,
1731: okc_bus_variables_b busvar
1732: WHERE kart.ID = p_source_doc_clause_id
1733: AND var.cat_id = kart.ID

Line 1730: okc_k_articles_b kart_tar,

1726: var.variable_value_id, var.override_global_yn,
1727: var.mr_variable_html, var.mr_variable_xml, busvar.mrv_flag
1728: FROM okc_k_art_variables var,
1729: okc_k_articles_b kart,
1730: okc_k_articles_b kart_tar,
1731: okc_bus_variables_b busvar
1732: WHERE kart.ID = p_source_doc_clause_id
1733: AND var.cat_id = kart.ID
1734: AND busvar.variable_code = var.variable_code;

Line 2087: UPDATE okc_k_articles_b

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;
2086:
2087: UPDATE okc_k_articles_b
2088: SET scn_id = x_new_section_id
2089: WHERE document_type = p_target_document_type
2090: AND document_id = p_target_document_id
2091: AND scn_id = p_target_doc_section_id;

Line 2672: FROM okc_k_articles_b kart

2668: BEGIN
2669: IF p_entity_name = G_CLAUSE_ENTITY THEN
2670: SELECT okc_terms_util_pvt.get_article_name(kart.sav_sae_id, kart.article_version_id)
2671: INTO l_title
2672: FROM okc_k_articles_b kart
2673: WHERE id=To_Number(p_entity_pk1);
2674: ELSIF p_entity_name = G_SECTION_ENTITY THEN
2675: SELECT heading
2676: INTO l_title

Line 2850: FROM okc_k_Articles_b

2846:
2847: CURSOR cur_src_art_details(cp_article_id NUMBER)
2848: IS
2849: SELECT document_type,document_id
2850: FROM okc_k_Articles_b
2851: WHERE id= cp_article_id;
2852:
2853:
2854: CURSOR cur_src_sec_details(cp_sec_id NUMBER)

Line 3017: okc_k_articles_b k

3013: CURSOR cur_lock_exists
3014: IS
3015: SELECT 'Y'
3016: FROM okc_k_art_variables v,
3017: okc_k_articles_b k
3018: WHERE k.id = v.cat_id
3019: AND v.variable_code = p_variable_code
3020: AND k.document_type = p_tgt_document_type
3021: AND k.document_id = p_tgt_document_id

Line 3124: FROM okc_k_entity_locks lck, okc_k_articles_b kart

3120: BEGIN
3121: -- check for clauses
3122: SELECT 'Y'
3123: INTO l_lock_exists
3124: FROM okc_k_entity_locks lck, okc_k_articles_b kart
3125: WHERE lck.entity_name=G_CLAUSE_ENTITY
3126: AND lck.entity_pk1= To_Char(kart.id)
3127: AND kart.document_type= l_src_doc_type
3128: AND kart.document_id= l_src_doc_id

Line 3395: okc_k_articles_b tgtAward

3391: CURSOR cur_kart_ids
3392: IS
3393: SELECT tgtAward.id,srcMod.orig_system_reference_id1
3394: FROM
3395: okc_k_articles_b tgtAward
3396: ,okc_k_articles_b srcMod
3397: WHERE srcMod.document_type= p_update_from_doc_type
3398: AND srcMod.document_id= p_update_from_doc_id
3399: AND tgtAward.document_type= p_update_to_doc_type

Line 3396: ,okc_k_articles_b srcMod

3392: IS
3393: SELECT tgtAward.id,srcMod.orig_system_reference_id1
3394: FROM
3395: okc_k_articles_b tgtAward
3396: ,okc_k_articles_b srcMod
3397: WHERE srcMod.document_type= p_update_from_doc_type
3398: AND srcMod.document_id= p_update_from_doc_id
3399: AND tgtAward.document_type= p_update_to_doc_type
3400: AND tgtAward.document_id= p_update_to_doc_id

Line 3473: UPDATE okc_k_articles_b

3469: AND document_type= p_update_to_doc_type
3470: AND document_id=p_update_from_doc_id;
3471:
3472: FORALL i IN l_tgt_id_tbl.first..l_tgt_id_tbl.last
3473: UPDATE okc_k_articles_b
3474: SET scn_id= l_src_ref_id_tbl(i)
3475: WHERE scn_id= l_tgt_id_tbl(i)
3476: AND document_type= p_update_to_doc_type
3477: AND document_id=p_update_from_doc_id;

Line 3491: update okc_k_articles_b

3487: -- update variable values and clauses.
3488: IF l_tgt_id_tbl.Count>0 then
3489:
3490: forall i in l_tgt_id_tbl.first..l_tgt_id_tbl.last
3491: update okc_k_articles_b
3492: set cat_id= l_src_ref_id_tbl(i)
3493: where id=l_tgt_id_tbl(i);
3494:
3495:

Line 3594: FROM okc_k_articles_b

3590:
3591: CURSOR cur_clause
3592: IS
3593: SELECT 'Y'
3594: FROM okc_k_articles_b
3595: WHERE document_type= p_doc_type
3596: AND document_id= p_doc_id
3597: AND amendment_operation_code IS NOT NULL;
3598:

Line 3603: FROM okc_k_articles_b

3599:
3600: CURSOR cur_deliverable
3601: IS
3602: SELECT 'Y'
3603: FROM okc_k_articles_b
3604: WHERE document_type= p_doc_type
3605: AND document_id= p_doc_id
3606: AND amendment_operation_code IS NOT NULL;
3607:

Line 3660: FROM okc_k_articles_b

3656: AND document_id= p_doc_id
3657: AND summary_amend_operation_code IN ('UPDATED','DELETED')
3658: UNION ALL
3659: SELECT 'CLAUSE' entity, orig_system_reference_id1 , amendment_operation_code, summary_amend_operation_code
3660: FROM okc_k_articles_b
3661: WHERE document_type= p_doc_type
3662: AND document_id = p_doc_id
3663: AND summary_amend_operation_code IN ('UPDATED','DELETED')
3664: UNION ALL

Line 3733: FROM okc_k_articles_b

3729: orig_system_reference_code,
3730: orig_system_reference_id1,
3731: orig_system_reference_id2,
3732: scn_id
3733: FROM okc_k_articles_b
3734: WHERE document_type = p_src_doc_type
3735: AND document_id = p_src_doc_id
3736: AND amendment_operation_code IS NOT NULL;
3737:

Line 3743: FROM okc_k_articles_b

3739:
3740: CURSOR cur_get_tar_kartid (cp_kart_id NUMBER)
3741: IS
3742: SELECT id
3743: FROM okc_k_articles_b
3744: WHERE document_type = p_target_doc_type
3745: AND document_id = p_target_doc_id
3746: AND orig_system_reference_id1 = cp_kart_id;
3747: