APPS.CZ_CF_API dependencies on CZ_DB_SETTINGS

Line 66: l_ret_value cz_db_settings.value%TYPE;

62:
63: --------------------------------------------------------------------------------
64: FUNCTION get_db_setting (p_section_name IN VARCHAR2, p_setting IN VARCHAR2)
65: RETURN VARCHAR2 IS
66: l_ret_value cz_db_settings.value%TYPE;
67: BEGIN
68: SELECT value INTO l_ret_value FROM cz_db_settings WHERE Upper(section_name)
69: = Upper(p_section_name) AND Upper(setting_id) = Upper(p_setting);
70: RETURN l_ret_value;

Line 68: SELECT value INTO l_ret_value FROM cz_db_settings WHERE Upper(section_name)

64: FUNCTION get_db_setting (p_section_name IN VARCHAR2, p_setting IN VARCHAR2)
65: RETURN VARCHAR2 IS
66: l_ret_value cz_db_settings.value%TYPE;
67: BEGIN
68: SELECT value INTO l_ret_value FROM cz_db_settings WHERE Upper(section_name)
69: = Upper(p_section_name) AND Upper(setting_id) = Upper(p_setting);
70: RETURN l_ret_value;
71: END;
72:

Line 1212: l_no_config_del cz_db_settings.value%TYPE;

1208: procedure delete_bv_records(p_pseudo_hdr_id IN NUMBER
1209: ,p_check_db_setting IN BOOLEAN
1210: ,p_delete_ext_attr IN BOOLEAN)
1211: IS
1212: l_no_config_del cz_db_settings.value%TYPE;
1213: BEGIN
1214: l_no_config_del := 'NO';
1215: IF p_check_db_setting THEN
1216: BEGIN

Line 1218: FROM cz_db_settings

1214: l_no_config_del := 'NO';
1215: IF p_check_db_setting THEN
1216: BEGIN
1217: SELECT upper(value) INTO l_no_config_del
1218: FROM cz_db_settings
1219: WHERE setting_id = 'BatchValConfigInputDelete';
1220: EXCEPTION
1221: WHEN NO_DATA_FOUND THEN
1222: NULL;

Line 2182: -- delete based on setting in cz_db_settings

2178: END IF;
2179: END IF;
2180:
2181: l_nDebug := 7;
2182: -- delete based on setting in cz_db_settings
2183: l_check_db_setting := TRUE;
2184: IF validation_status = UTL_HTTP_INIT_FAILED OR
2185: validation_status = UTL_HTTP_REQUEST_FAILED THEN
2186: l_check_db_setting := FALSE;

Line 3219: l_rest_cfg_lookup_setting cz_db_settings.value%TYPE := ' ';

3215: p_lookup_date IN OUT NOCOPY DATE,
3216: p_effective_date IN OUT NOCOPY DATE) IS
3217: l_config_creation_date DATE;
3218: l_config_effective_date DATE;
3219: l_rest_cfg_lookup_setting cz_db_settings.value%TYPE := ' ';
3220:
3221: BEGIN
3222: IF p_config_hdr_id IS NULL OR p_config_rev_nbr IS NULL THEN
3223: RAISE_APPLICATION_ERROR(-20001, 'Config header ID AND config rev nbr ' ||

Line 3252: FROM cz_db_settings WHERE setting_id = 'RestoredConfigDefaultModelLookupDate';

3248: --- at a customer site.
3249: BEGIN
3250: SELECT value
3251: INTO l_rest_cfg_lookup_setting
3252: FROM cz_db_settings WHERE setting_id = 'RestoredConfigDefaultModelLookupDate';
3253: EXCEPTION
3254: WHEN OTHERS THEN
3255: l_rest_cfg_lookup_setting := NULL;
3256: END;