APPS.OKC_TERMS_SECTIONS_GRP dependencies on OKC_K_ARTICLES_B

Line 477: l_cat_id okc_k_articles_b.id%type;

473: l_ok_to_commit VARCHAR2(1);
474: l_document_id NUMBER;
475: l_document_type VARCHAR2(30);
476: l_scn_id okc_sections_b.id%type;
477: l_cat_id okc_k_articles_b.id%type;
478: l_ovn okc_sections_b.object_version_number%type;
479: l_amendment_operation_code OKC_SECTIONS_B.AMENDMENT_OPERATION_CODE%TYPE;
480: l_summary_amend_operation_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;
481: l_existing_summary_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;

Line 789: FROM okc_k_articles_b

785: 'ARTICLE' object_type,
786: object_version_number,
787: display_sequence,
788: scn_id
789: FROM okc_k_articles_b
790: WHERE document_type=p_document_type
791: AND document_id = p_document_id
792: AND ( (b_scn_id IS NOT NULL AND scn_id=b_scn_id) OR
793: (b_scn_id IS NULL AND scn_id IS NULL)

Line 815: SELECT nvl(max(DISPLAY_SEQUENCE),0) FROM OKC_K_ARTICLES_B

811: (b_scn_id is Null and scn_id is Null)
812: OR
813: (b_scn_id is Not Null and scn_id=b_scn_id));
814: CURSOR l_get_max_art_seq(b_scn_id NUMBER) IS
815: SELECT nvl(max(DISPLAY_SEQUENCE),0) FROM OKC_K_ARTICLES_B
816: WHERE document_type=p_document_type
817: AND document_id=p_document_id
818: and scn_id =b_scn_id;
819:

Line 822: FROM OKC_K_ARTICLES_B

818: and scn_id =b_scn_id;
819:
820: CURSOR l_get_child_art_crs(b_scn_id NUMBER,b_ref_sequence NUMBER) IS
821: SELECT id,object_version_number
822: FROM OKC_K_ARTICLES_B
823: WHERE SCN_ID=b_scn_id
824: AND display_sequence >= b_ref_sequence
825: Order by display_sequence;
826:

Line 1350: l_cat_id okc_k_articles_b.id%type;

1346: l_ok_to_commit VARCHAR2(1);
1347: l_document_id NUMBER;
1348: l_document_type VARCHAR2(30);
1349: l_scn_id okc_sections_b.id%type;
1350: l_cat_id okc_k_articles_b.id%type;
1351: l_ovn okc_sections_b.object_version_number%type;
1352: l_summary_amend_operation_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;
1353: l_existing_summary_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;
1354: l_existing_operation_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;

Line 1367: SELECT ID,OBJECT_VERSION_NUMBER FROM OKC_K_ARTICLES_B

1363: SELECT ID,OBJECT_VERSION_NUMBER FROM OKC_SECTIONS_B
1364: WHERE SCN_ID=b_scn_id;
1365:
1366: CURSOR l_get_article_csr(b_scn_id Number) IS
1367: SELECT ID,OBJECT_VERSION_NUMBER FROM OKC_K_ARTICLES_B
1368: WHERE SCN_ID=b_scn_id;
1369:
1370: CURSOR l_get_summary_code_csr IS
1371: SELECT SUMMARY_AMEND_OPERATION_CODE,AMENDMENT_OPERATION_CODE FROM OKC_SECTIONS_B