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.CZ_NETWORK_API_PUB dependencies on CZ_DB_SETTINGS

Line 481: v_cfg_delete cz_db_settings.value%TYPE;

477: --------------------------------------------------------------------------
478: PROCEDURE delete_dummy_config(p_dummy_hdr_id IN NUMBER)
479: IS
480:
481: v_cfg_delete cz_db_settings.value%TYPE;
482:
483: BEGIN
484:
485: -----delete based on setting in cz_db_settings

Line 485: -----delete based on setting in cz_db_settings

481: v_cfg_delete cz_db_settings.value%TYPE;
482:
483: BEGIN
484:
485: -----delete based on setting in cz_db_settings
486: BEGIN
487: SELECT value INTO v_cfg_delete
488: FROM cz_db_settings
489: WHERE setting_id = 'BatchValConfigInputDelete';

Line 488: FROM cz_db_settings

484:
485: -----delete based on setting in cz_db_settings
486: BEGIN
487: SELECT value INTO v_cfg_delete
488: FROM cz_db_settings
489: WHERE setting_id = 'BatchValConfigInputDelete';
490: EXCEPTION
491: WHEN OTHERS THEN
492: v_cfg_delete := 'NO';

Line 744: l_trace_value cz_db_settings.value%type;

740: PRAGMA AUTONOMOUS_TRANSACTION;
741: TYPE trace_tbl IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
742: l_trace_tbl trace_tbl ;
743: l_trace_count NUMBER := 0;
744: l_trace_value cz_db_settings.value%type;
745:
746: BEGIN
747: BEGIN
748: SELECT value

Line 750: FROM cz_db_settings

746: BEGIN
747: BEGIN
748: SELECT value
749: INTO l_trace_value
750: FROM cz_db_settings
751: WHERE cz_db_settings.setting_id = 'NetworkApiTrace';
752: EXCEPTION
753: WHEN OTHERS THEN
754: l_trace_value := 'NO';

Line 751: WHERE cz_db_settings.setting_id = 'NetworkApiTrace';

747: BEGIN
748: SELECT value
749: INTO l_trace_value
750: FROM cz_db_settings
751: WHERE cz_db_settings.setting_id = 'NetworkApiTrace';
752: EXCEPTION
753: WHEN OTHERS THEN
754: l_trace_value := 'NO';
755: END;

Line 846: l_trace_value cz_db_settings.value%type;

842: PRAGMA AUTONOMOUS_TRANSACTION;
843: TYPE trace_tbl IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
844: l_trace_tbl trace_tbl ;
845: l_trace_count NUMBER := 0;
846: l_trace_value cz_db_settings.value%type;
847:
848: BEGIN
849: BEGIN
850: SELECT value

Line 852: FROM cz_db_settings

848: BEGIN
849: BEGIN
850: SELECT value
851: INTO l_trace_value
852: FROM cz_db_settings
853: WHERE cz_db_settings.setting_id = 'NetworkApiTrace';
854: EXCEPTION
855: WHEN OTHERS THEN
856: l_trace_value := 'NO';

Line 853: WHERE cz_db_settings.setting_id = 'NetworkApiTrace';

849: BEGIN
850: SELECT value
851: INTO l_trace_value
852: FROM cz_db_settings
853: WHERE cz_db_settings.setting_id = 'NetworkApiTrace';
854: EXCEPTION
855: WHEN OTHERS THEN
856: l_trace_value := 'NO';
857: END;

Line 1006: l_value cz_db_settings.value%TYPE;

1002: l_dummy_config_hdr_id NUMBER;
1003:
1004: --Sungard ER Bug7673721
1005: l_instance_number_tbl cz_api_pub.number_tbl_type;
1006: l_value cz_db_settings.value%TYPE;
1007:
1008:
1009: NO_INPUT_RECORDS EXCEPTION;
1010: INPUT_TREE_MODE_NULL EXCEPTION;

Line 1076: SELECT UPPER(value) INTO l_value FROM cz_db_settings WHERE UPPER(section_name) = 'CONFIG'

1072:
1073: --Sungard ER Bug7673721
1074:
1075: BEGIN
1076: SELECT UPPER(value) INTO l_value FROM cz_db_settings WHERE UPPER(section_name) = 'CONFIG'
1077: AND UPPER(setting_id) = 'OPTIMIZECONFIGTREE';
1078: EXCEPTION
1079: WHEN OTHERS THEN
1080: l_value := 'N';