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 827: FROM okc_k_articles_b

823: 'ARTICLE' object_type,
824: object_version_number,
825: display_sequence,
826: scn_id
827: FROM okc_k_articles_b
828: WHERE document_type=p_document_type
829: AND document_id = p_document_id
830: AND ( (b_scn_id IS NOT NULL AND scn_id=b_scn_id) OR
831: (b_scn_id IS NULL AND scn_id IS NULL)

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

849: (b_scn_id is Null and scn_id is Null)
850: OR
851: (b_scn_id is Not Null and scn_id=b_scn_id));
852: CURSOR l_get_max_art_seq(b_scn_id NUMBER) IS
853: SELECT nvl(max(DISPLAY_SEQUENCE),0) FROM OKC_K_ARTICLES_B
854: WHERE document_type=p_document_type
855: AND document_id=p_document_id
856: and scn_id =b_scn_id;
857:

Line 860: FROM OKC_K_ARTICLES_B

856: and scn_id =b_scn_id;
857:
858: CURSOR l_get_child_art_crs(b_scn_id NUMBER,b_ref_sequence NUMBER) IS
859: SELECT id,object_version_number
860: FROM OKC_K_ARTICLES_B
861: WHERE SCN_ID=b_scn_id
862: AND display_sequence >= b_ref_sequence
863: Order by display_sequence;
864:

Line 1389: l_cat_id okc_k_articles_b.id%type;

1385: l_ok_to_commit VARCHAR2(1);
1386: l_document_id NUMBER;
1387: l_document_type VARCHAR2(30);
1388: l_scn_id okc_sections_b.id%type;
1389: l_cat_id okc_k_articles_b.id%type;
1390: l_ovn okc_sections_b.object_version_number%type;
1391: l_summary_amend_operation_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;
1392: l_existing_summary_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;
1393: l_existing_operation_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;

Line 1408: SELECT ID,OBJECT_VERSION_NUMBER FROM OKC_K_ARTICLES_B

1404: SELECT ID,OBJECT_VERSION_NUMBER FROM OKC_SECTIONS_B
1405: WHERE SCN_ID=b_scn_id;
1406:
1407: CURSOR l_get_article_csr(b_scn_id Number) IS
1408: SELECT ID,OBJECT_VERSION_NUMBER FROM OKC_K_ARTICLES_B
1409: WHERE SCN_ID=b_scn_id;
1410:
1411: CURSOR l_get_summary_code_csr IS
1412: SELECT SUMMARY_AMEND_OPERATION_CODE,AMENDMENT_OPERATION_CODE FROM OKC_SECTIONS_B