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: l_orig_system_reference_id1 NUMBER;

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: l_orig_system_reference_id1 NUMBER;
485:

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: l_orig_system_reference_id1 NUMBER;
485:
486: CURSOR l_document_id_csr IS

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: l_orig_system_reference_id1 NUMBER;
485:
486: CURSOR l_document_id_csr IS
487: SELECT DOCUMENT_ID,DOCUMENT_TYPE,orig_system_reference_id1 FROM OKC_SECTIONS_B

Line 487: SELECT DOCUMENT_ID,DOCUMENT_TYPE,orig_system_reference_id1 FROM OKC_SECTIONS_B

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

Line 492: FROM OKC_SECTIONS_B

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

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

781: ) IS
782:
783: l_api_version CONSTANT NUMBER := 1;
784: l_api_name CONSTANT VARCHAR2(30) := 'g_add_section';
785: l_object_version_number OKC_SECTIONS_B.OBJECT_VERSION_NUMBER%TYPE := 1;
786: l_ok_to_commit VARCHAR2(1);
787: i NUMBER := 0;
788: l_ref_count NUMBER := 0;
789: l_ref_sequence NUMBER := 0;

Line 797: id OKC_SECTIONS_B.id%type,

793: l_scn_id NUMBER ;
794:
795: --Fix for bug 3735048, added object_type
796: TYPE scn_rec_type IS RECORD (
797: id OKC_SECTIONS_B.id%type,
798: display_sequence OKC_SECTIONS_B.section_sequence%type,
799: object_version_number OKC_SECTIONS_B.object_version_number%type,
800: object_type VARCHAR2(30)
801: );

Line 798: display_sequence OKC_SECTIONS_B.section_sequence%type,

794:
795: --Fix for bug 3735048, added object_type
796: TYPE scn_rec_type IS RECORD (
797: id OKC_SECTIONS_B.id%type,
798: display_sequence OKC_SECTIONS_B.section_sequence%type,
799: object_version_number OKC_SECTIONS_B.object_version_number%type,
800: object_type VARCHAR2(30)
801: );
802:

Line 799: object_version_number OKC_SECTIONS_B.object_version_number%type,

795: --Fix for bug 3735048, added object_type
796: TYPE scn_rec_type IS RECORD (
797: id OKC_SECTIONS_B.id%type,
798: display_sequence OKC_SECTIONS_B.section_sequence%type,
799: object_version_number OKC_SECTIONS_B.object_version_number%type,
800: object_type VARCHAR2(30)
801: );
802:
803: TYPE scn_tbl_type IS TABLE OF scn_rec_type INDEX BY BINARY_INTEGER;

Line 815: FROM okc_sections_b

811: 'SECTION' object_type,
812: object_version_number,
813: section_sequence display_sequence,
814: scn_id
815: FROM okc_sections_b
816: WHERE document_type=p_document_type
817: AND document_id = p_document_id
818: AND ( (b_scn_id IS NOT NULL AND scn_id=b_scn_id) OR
819: (b_scn_id IS NULL AND scn_id IS NULL)

Line 837: select scn_id from okc_sections_b

833: ORDER BY display_sequence;
834:
835: -- cursor to get paret of reference scn_id
836: CURSOR l_get_parent_csr IS
837: select scn_id from okc_sections_b
838: where document_type=p_document_type
839: AND document_id = p_document_id
840: AND id=p_ref_scn_id;
841:

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

841:
842:
843: -- Cursor to get sequence of last section in a hierarchy
844: cursor l_get_max_seq_csr(b_scn_id NUMBER) is
845: SELECT nvl(max(SECTION_SEQUENCE),0) FROM OKC_SECTIONS_B
846: WHERE document_type=p_document_type
847: AND document_id=p_document_id
848: and (
849: (b_scn_id is Null and scn_id is Null)

Line 1388: l_scn_id okc_sections_b.id%type;

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

Line 1390: l_ovn okc_sections_b.object_version_number%type;

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

Line 1391: l_summary_amend_operation_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;

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

Line 1392: l_existing_summary_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;

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;
1394: l_delete_rec BOOLEAN :=FALSE;
1395: l_super_user_yn VARCHAR2(1) ;
1396:

Line 1393: l_existing_operation_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%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;
1394: l_delete_rec BOOLEAN :=FALSE;
1395: l_super_user_yn VARCHAR2(1) ;
1396:
1397: l_orig_system_reference_id1 NUMBER;

Line 1400: SELECT DOCUMENT_ID,DOCUMENT_TYPE,orig_system_reference_id1 FROM OKC_SECTIONS_B

1396:
1397: l_orig_system_reference_id1 NUMBER;
1398:
1399: CURSOR l_document_id_csr IS
1400: SELECT DOCUMENT_ID,DOCUMENT_TYPE,orig_system_reference_id1 FROM OKC_SECTIONS_B
1401: WHERE ID=P_ID;
1402:
1403: CURSOR l_subsection_csr(b_scn_id Number) IS
1404: SELECT ID,OBJECT_VERSION_NUMBER FROM OKC_SECTIONS_B

Line 1404: SELECT ID,OBJECT_VERSION_NUMBER FROM OKC_SECTIONS_B

1400: SELECT DOCUMENT_ID,DOCUMENT_TYPE,orig_system_reference_id1 FROM OKC_SECTIONS_B
1401: WHERE ID=P_ID;
1402:
1403: CURSOR l_subsection_csr(b_scn_id Number) IS
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

Line 1412: SELECT SUMMARY_AMEND_OPERATION_CODE,AMENDMENT_OPERATION_CODE FROM OKC_SECTIONS_B

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
1413: WHERE ID=P_ID;
1414:
1415:
1416: BEGIN