APPS.OKC_TERMS_VERSION_PVT dependencies on OKC_K_ARTICLES_B

Line 41: l_change_nonstd okc_k_articles_b.change_nonstd_yn%TYPE;

37: p_doc_id IN NUMBER,
38: p_keep_summary IN VARCHAR2
39: ) IS
40: l_api_name CONSTANT VARCHAR2(30) := 'clear_amendment';
41: l_change_nonstd okc_k_articles_b.change_nonstd_yn%TYPE;
42: --Fix for bug# 3990983
43: l_contract_source_code OKC_TEMPLATE_USAGES.CONTRACT_SOURCE_CODE%TYPE;
44:
45: CURSOR scn_crs IS

Line 54: FROM okc_k_articles_b kart,okc_articles_all art

50:
51: CURSOR cat_crs IS
52: SELECT kart.id, kart.object_version_number,kart.amendment_operation_code,kart.summary_amend_operation_code,
53: DECODE(art.standard_yn,'N','Y',NULL) change_nonstd_yn
54: FROM okc_k_articles_b kart,okc_articles_all art
55: WHERE kart.document_type = p_doc_type AND kart.document_id = p_doc_id
56: AND kart.sav_sae_id = art.article_id
57: AND (kart.amendment_operation_code IS NOT NULL OR kart.amendment_description IS NOT NULL
58: OR kart.summary_amend_operation_code IS NOT NULL OR art.standard_yn='N');

Line 75: FROM okc_k_articles_b kart,okc_articles_all

71: AND SUMMARY_AMEND_OPERATION_CODE IS NULL;
72:
73: CURSOR cat_incremental_crs IS
74: SELECT id, kart.object_version_number, amendment_operation_code,standard_yn
75: FROM okc_k_articles_b kart,okc_articles_all
76: WHERE document_type = p_doc_type AND document_id = p_doc_id
77: AND sav_sae_id = article_id
78: AND (amendment_operation_code IS NOT NULL
79: OR standard_yn='N');

Line 83: FROM okc_k_articles_b

79: OR standard_yn='N');
80:
81: CURSOR l_del_cat_crs IS
82: SELECT id, object_version_number
83: FROM okc_k_articles_b
84: WHERE document_type = p_doc_type AND document_id = p_doc_id
85: AND amendment_operation_code = G_AMEND_CODE_DELETED
86: AND SUMMARY_AMEND_OPERATION_CODE IS NULL;
87:

Line 478: l_change_nonstd okc_k_articles_b.change_nonstd_yn%TYPE;

474: ) IS
475: l_api_name CONSTANT VARCHAR2(30) := 'Version_Doc';
476: l_msg_data VARCHAR2(1000);
477: l_msg_count NUMBER;
478: l_change_nonstd okc_k_articles_b.change_nonstd_yn%TYPE;
479:
480: CURSOR scn_crs IS
481: SELECT id, object_version_number, amendment_operation_code
482: FROM okc_sections_b

Line 495: FROM okc_k_articles_b kart,okc_articles_all

491: AND SUMMARY_AMEND_OPERATION_CODE IS NULL;
492:
493: CURSOR cat_crs IS
494: SELECT id, kart.object_version_number, amendment_operation_code,standard_yn
495: FROM okc_k_articles_b kart,okc_articles_all
496: WHERE document_type = p_doc_type AND document_id = p_doc_id
497: AND sav_sae_id = article_id
498: AND (amendment_operation_code IS NOT NULL
499: OR standard_yn='N');

Line 503: FROM okc_k_articles_b

499: OR standard_yn='N');
500:
501: CURSOR l_del_cat_crs IS
502: SELECT id, object_version_number
503: FROM okc_k_articles_b
504: WHERE document_type = p_doc_type AND document_id = p_doc_id
505: AND amendment_operation_code = G_AMEND_CODE_DELETED
506: AND SUMMARY_AMEND_OPERATION_CODE IS NULL;
507: BEGIN