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_TERMS_SECTIONS_GRP dependencies on OKC_SECTIONS_B

Line 266: l_object_version_number OKC_SECTIONS_B.OBJECT_VERSION_NUMBER%TYPE := 1;

262: ) IS
263:
264: l_api_version CONSTANT NUMBER := 1;
265: l_api_name CONSTANT VARCHAR2(30) := 'g_create_section';
266: l_object_version_number OKC_SECTIONS_B.OBJECT_VERSION_NUMBER%TYPE := 1;
267: l_amendment_operation_code OKC_SECTIONS_B.AMENDMENT_OPERATION_CODE%TYPE;
268: l_summary_amend_operation_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;
269: l_amendment_description OKC_SECTIONS_B.AMENDMENT_DESCRIPTION%TYPE;
270:

Line 267: l_amendment_operation_code OKC_SECTIONS_B.AMENDMENT_OPERATION_CODE%TYPE;

263:
264: l_api_version CONSTANT NUMBER := 1;
265: l_api_name CONSTANT VARCHAR2(30) := 'g_create_section';
266: l_object_version_number OKC_SECTIONS_B.OBJECT_VERSION_NUMBER%TYPE := 1;
267: l_amendment_operation_code OKC_SECTIONS_B.AMENDMENT_OPERATION_CODE%TYPE;
268: l_summary_amend_operation_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;
269: l_amendment_description OKC_SECTIONS_B.AMENDMENT_DESCRIPTION%TYPE;
270:
271: BEGIN

Line 268: l_summary_amend_operation_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;

264: l_api_version CONSTANT NUMBER := 1;
265: l_api_name CONSTANT VARCHAR2(30) := 'g_create_section';
266: l_object_version_number OKC_SECTIONS_B.OBJECT_VERSION_NUMBER%TYPE := 1;
267: l_amendment_operation_code OKC_SECTIONS_B.AMENDMENT_OPERATION_CODE%TYPE;
268: l_summary_amend_operation_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;
269: l_amendment_description OKC_SECTIONS_B.AMENDMENT_DESCRIPTION%TYPE;
270:
271: BEGIN
272:

Line 269: l_amendment_description OKC_SECTIONS_B.AMENDMENT_DESCRIPTION%TYPE;

265: l_api_name CONSTANT VARCHAR2(30) := 'g_create_section';
266: l_object_version_number OKC_SECTIONS_B.OBJECT_VERSION_NUMBER%TYPE := 1;
267: l_amendment_operation_code OKC_SECTIONS_B.AMENDMENT_OPERATION_CODE%TYPE;
268: l_summary_amend_operation_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;
269: l_amendment_description OKC_SECTIONS_B.AMENDMENT_DESCRIPTION%TYPE;
270:
271: BEGIN
272:
273: /*IF (l_debug = 'Y') THEN

Line 476: l_scn_id okc_sections_b.id%type;

472: l_api_name CONSTANT VARCHAR2(30) := 'g_update_section';
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;

Line 478: l_ovn okc_sections_b.object_version_number%type;

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;
482: l_existing_operation_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;

Line 479: l_amendment_operation_code OKC_SECTIONS_B.AMENDMENT_OPERATION_CODE%TYPE;

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;
482: l_existing_operation_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;
483: l_amendment_description OKC_SECTIONS_B.AMENDMENT_DESCRIPTION%TYPE;

Line 480: l_summary_amend_operation_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;

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;
482: l_existing_operation_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;
483: l_amendment_description OKC_SECTIONS_B.AMENDMENT_DESCRIPTION%TYPE;
484:

Line 481: l_existing_summary_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%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;
482: l_existing_operation_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;
483: l_amendment_description OKC_SECTIONS_B.AMENDMENT_DESCRIPTION%TYPE;
484:
485: CURSOR l_document_id_csr IS

Line 482: l_existing_operation_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%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;
482: l_existing_operation_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;
483: l_amendment_description OKC_SECTIONS_B.AMENDMENT_DESCRIPTION%TYPE;
484:
485: CURSOR l_document_id_csr IS
486: SELECT DOCUMENT_ID,DOCUMENT_TYPE FROM OKC_SECTIONS_B

Line 483: l_amendment_description OKC_SECTIONS_B.AMENDMENT_DESCRIPTION%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;
482: l_existing_operation_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;
483: l_amendment_description OKC_SECTIONS_B.AMENDMENT_DESCRIPTION%TYPE;
484:
485: CURSOR l_document_id_csr IS
486: SELECT DOCUMENT_ID,DOCUMENT_TYPE FROM OKC_SECTIONS_B
487: WHERE ID=P_ID;

Line 486: SELECT DOCUMENT_ID,DOCUMENT_TYPE FROM OKC_SECTIONS_B

482: l_existing_operation_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;
483: l_amendment_description OKC_SECTIONS_B.AMENDMENT_DESCRIPTION%TYPE;
484:
485: CURSOR l_document_id_csr IS
486: SELECT DOCUMENT_ID,DOCUMENT_TYPE FROM OKC_SECTIONS_B
487: WHERE ID=P_ID;
488:
489: CURSOR l_get_summary_code_csr IS
490: SELECT SUMMARY_AMEND_OPERATION_CODE ,amendment_operation_code

Line 491: FROM OKC_SECTIONS_B

487: WHERE ID=P_ID;
488:
489: CURSOR l_get_summary_code_csr IS
490: SELECT SUMMARY_AMEND_OPERATION_CODE ,amendment_operation_code
491: FROM OKC_SECTIONS_B
492: WHERE ID=P_ID;
493:
494: BEGIN
495:

Line 747: l_object_version_number OKC_SECTIONS_B.OBJECT_VERSION_NUMBER%TYPE := 1;

743: ) IS
744:
745: l_api_version CONSTANT NUMBER := 1;
746: l_api_name CONSTANT VARCHAR2(30) := 'g_add_section';
747: l_object_version_number OKC_SECTIONS_B.OBJECT_VERSION_NUMBER%TYPE := 1;
748: l_ok_to_commit VARCHAR2(1);
749: i NUMBER := 0;
750: l_ref_count NUMBER := 0;
751: l_ref_sequence NUMBER := 0;

Line 759: id OKC_SECTIONS_B.id%type,

755: l_scn_id NUMBER ;
756:
757: --Fix for bug 3735048, added object_type
758: TYPE scn_rec_type IS RECORD (
759: id OKC_SECTIONS_B.id%type,
760: display_sequence OKC_SECTIONS_B.section_sequence%type,
761: object_version_number OKC_SECTIONS_B.object_version_number%type,
762: object_type VARCHAR2(30)
763: );

Line 760: display_sequence OKC_SECTIONS_B.section_sequence%type,

756:
757: --Fix for bug 3735048, added object_type
758: TYPE scn_rec_type IS RECORD (
759: id OKC_SECTIONS_B.id%type,
760: display_sequence OKC_SECTIONS_B.section_sequence%type,
761: object_version_number OKC_SECTIONS_B.object_version_number%type,
762: object_type VARCHAR2(30)
763: );
764:

Line 761: object_version_number OKC_SECTIONS_B.object_version_number%type,

757: --Fix for bug 3735048, added object_type
758: TYPE scn_rec_type IS RECORD (
759: id OKC_SECTIONS_B.id%type,
760: display_sequence OKC_SECTIONS_B.section_sequence%type,
761: object_version_number OKC_SECTIONS_B.object_version_number%type,
762: object_type VARCHAR2(30)
763: );
764:
765: TYPE scn_tbl_type IS TABLE OF scn_rec_type INDEX BY BINARY_INTEGER;

Line 777: FROM okc_sections_b

773: 'SECTION' object_type,
774: object_version_number,
775: section_sequence display_sequence,
776: scn_id
777: FROM okc_sections_b
778: WHERE document_type=p_document_type
779: AND document_id = p_document_id
780: AND ( (b_scn_id IS NOT NULL AND scn_id=b_scn_id) OR
781: (b_scn_id IS NULL AND scn_id IS NULL)

Line 799: select scn_id from okc_sections_b

795: ORDER BY display_sequence;
796:
797: -- cursor to get paret of reference scn_id
798: CURSOR l_get_parent_csr IS
799: select scn_id from okc_sections_b
800: where document_type=p_document_type
801: AND document_id = p_document_id
802: AND id=p_ref_scn_id;
803:

Line 807: SELECT nvl(max(SECTION_SEQUENCE),0) FROM OKC_SECTIONS_B

803:
804:
805: -- Cursor to get sequence of last section in a hierarchy
806: cursor l_get_max_seq_csr(b_scn_id NUMBER) is
807: SELECT nvl(max(SECTION_SEQUENCE),0) FROM OKC_SECTIONS_B
808: WHERE document_type=p_document_type
809: AND document_id=p_document_id
810: and (
811: (b_scn_id is Null and scn_id is Null)

Line 1349: l_scn_id okc_sections_b.id%type;

1345: l_api_name CONSTANT VARCHAR2(30) := 'g_delete_section';
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;

Line 1351: l_ovn okc_sections_b.object_version_number%type;

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;
1355: l_delete_rec BOOLEAN :=FALSE;

Line 1352: l_summary_amend_operation_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;

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;
1355: l_delete_rec BOOLEAN :=FALSE;
1356: l_super_user_yn VARCHAR2(1) ;

Line 1353: l_existing_summary_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;

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;
1355: l_delete_rec BOOLEAN :=FALSE;
1356: l_super_user_yn VARCHAR2(1) ;
1357:

Line 1354: l_existing_operation_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%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;
1355: l_delete_rec BOOLEAN :=FALSE;
1356: l_super_user_yn VARCHAR2(1) ;
1357:
1358: CURSOR l_document_id_csr IS

Line 1359: SELECT DOCUMENT_ID,DOCUMENT_TYPE FROM OKC_SECTIONS_B

1355: l_delete_rec BOOLEAN :=FALSE;
1356: l_super_user_yn VARCHAR2(1) ;
1357:
1358: CURSOR l_document_id_csr IS
1359: SELECT DOCUMENT_ID,DOCUMENT_TYPE FROM OKC_SECTIONS_B
1360: WHERE ID=P_ID;
1361:
1362: CURSOR l_subsection_csr(b_scn_id Number) IS
1363: SELECT ID,OBJECT_VERSION_NUMBER FROM OKC_SECTIONS_B

Line 1363: SELECT ID,OBJECT_VERSION_NUMBER FROM OKC_SECTIONS_B

1359: SELECT DOCUMENT_ID,DOCUMENT_TYPE FROM OKC_SECTIONS_B
1360: WHERE ID=P_ID;
1361:
1362: CURSOR l_subsection_csr(b_scn_id Number) IS
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

Line 1371: SELECT SUMMARY_AMEND_OPERATION_CODE,AMENDMENT_OPERATION_CODE FROM OKC_SECTIONS_B

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
1372: WHERE ID=P_ID;
1373:
1374:
1375: BEGIN