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 454: v_cfg_delete cz_db_settings.value%TYPE;

450: --------------------------------------------------------------------------
451: PROCEDURE delete_dummy_config(p_dummy_hdr_id IN NUMBER)
452: IS
453:
454: v_cfg_delete cz_db_settings.value%TYPE;
455:
456: BEGIN
457:
458: -----delete based on setting in cz_db_settings

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

454: v_cfg_delete cz_db_settings.value%TYPE;
455:
456: BEGIN
457:
458: -----delete based on setting in cz_db_settings
459: BEGIN
460: SELECT value INTO v_cfg_delete
461: FROM cz_db_settings
462: WHERE setting_id = 'BatchValConfigInputDelete';

Line 461: FROM cz_db_settings

457:
458: -----delete based on setting in cz_db_settings
459: BEGIN
460: SELECT value INTO v_cfg_delete
461: FROM cz_db_settings
462: WHERE setting_id = 'BatchValConfigInputDelete';
463: EXCEPTION
464: WHEN OTHERS THEN
465: v_cfg_delete := 'NO';

Line 717: l_trace_value cz_db_settings.value%type;

713: PRAGMA AUTONOMOUS_TRANSACTION;
714: TYPE trace_tbl IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
715: l_trace_tbl trace_tbl ;
716: l_trace_count NUMBER := 0;
717: l_trace_value cz_db_settings.value%type;
718:
719: BEGIN
720: BEGIN
721: SELECT value

Line 723: FROM cz_db_settings

719: BEGIN
720: BEGIN
721: SELECT value
722: INTO l_trace_value
723: FROM cz_db_settings
724: WHERE cz_db_settings.setting_id = 'NetworkApiTrace';
725: EXCEPTION
726: WHEN OTHERS THEN
727: l_trace_value := 'NO';

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

720: BEGIN
721: SELECT value
722: INTO l_trace_value
723: FROM cz_db_settings
724: WHERE cz_db_settings.setting_id = 'NetworkApiTrace';
725: EXCEPTION
726: WHEN OTHERS THEN
727: l_trace_value := 'NO';
728: END;

Line 819: l_trace_value cz_db_settings.value%type;

815: PRAGMA AUTONOMOUS_TRANSACTION;
816: TYPE trace_tbl IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
817: l_trace_tbl trace_tbl ;
818: l_trace_count NUMBER := 0;
819: l_trace_value cz_db_settings.value%type;
820:
821: BEGIN
822: BEGIN
823: SELECT value

Line 825: FROM cz_db_settings

821: BEGIN
822: BEGIN
823: SELECT value
824: INTO l_trace_value
825: FROM cz_db_settings
826: WHERE cz_db_settings.setting_id = 'NetworkApiTrace';
827: EXCEPTION
828: WHEN OTHERS THEN
829: l_trace_value := 'NO';

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

822: BEGIN
823: SELECT value
824: INTO l_trace_value
825: FROM cz_db_settings
826: WHERE cz_db_settings.setting_id = 'NetworkApiTrace';
827: EXCEPTION
828: WHEN OTHERS THEN
829: l_trace_value := 'NO';
830: END;