[Home] [Help]
65:
66: --------------------------------------------------------------------------------
67: FUNCTION get_db_setting (p_section_name IN VARCHAR2, p_setting IN VARCHAR2)
68: RETURN VARCHAR2 IS
69: l_ret_value cz_db_settings.value%TYPE;
70: BEGIN
71: SELECT value INTO l_ret_value FROM cz_db_settings WHERE Upper(section_name)
72: = Upper(p_section_name) AND Upper(setting_id) = Upper(p_setting);
73: RETURN l_ret_value;
67: FUNCTION get_db_setting (p_section_name IN VARCHAR2, p_setting IN VARCHAR2)
68: RETURN VARCHAR2 IS
69: l_ret_value cz_db_settings.value%TYPE;
70: BEGIN
71: SELECT value INTO l_ret_value FROM cz_db_settings WHERE Upper(section_name)
72: = Upper(p_section_name) AND Upper(setting_id) = Upper(p_setting);
73: RETURN l_ret_value;
74: END;
75:
413: AND CONFIG_REV_NBR=in_config_rev_nbr;
414:
415: --Bug10147623: Delete data from custom config table.
416: BEGIN
417: SELECT UPPER(LTRIM(RTRIM(value))) INTO v_table_name FROM cz_db_settings
418: WHERE UPPER(setting_id) = 'CUSTOM_CONFIG_TABLE'
419: AND UPPER(section_name) = 'CONFIGURATION';
420:
421: EXCEPTION WHEN NO_DATA_FOUND THEN
1301: procedure delete_bv_records(p_pseudo_hdr_id IN NUMBER
1302: ,p_check_db_setting IN BOOLEAN
1303: ,p_delete_ext_attr IN BOOLEAN)
1304: IS
1305: l_no_config_del cz_db_settings.value%TYPE;
1306: BEGIN
1307: l_no_config_del := 'NO';
1308: IF p_check_db_setting THEN
1309: BEGIN
1307: l_no_config_del := 'NO';
1308: IF p_check_db_setting THEN
1309: BEGIN
1310: SELECT upper(value) INTO l_no_config_del
1311: FROM cz_db_settings
1312: WHERE setting_id = 'BatchValConfigInputDelete';
1313: EXCEPTION
1314: WHEN NO_DATA_FOUND THEN
1315: NULL;
1617:
1618: -- Backdoor for providing an alternate URL through a db setting
1619: BEGIN
1620: l_url := get_db_setting('ORAAPPS_INTEGRATE','ALTBATCHVALIDATEURL');
1621: /* bug13043488 ensure cz_db_settings value should not be null */
1622: IF l_url IS NULL THEN
1623: l_url:= p_url;
1624: END IF;
1625: /* end bug13043488 */
2578: END IF;
2579: END IF;
2580:
2581: l_nDebug := 7;
2582: -- delete based on setting in cz_db_settings
2583: l_check_db_setting := TRUE;
2584: IF validation_status = UTL_HTTP_INIT_FAILED OR
2585: validation_status = UTL_HTTP_REQUEST_FAILED THEN
2586: l_check_db_setting := FALSE;
3615: p_lookup_date IN OUT NOCOPY DATE,
3616: p_effective_date IN OUT NOCOPY DATE) IS
3617: l_config_creation_date DATE;
3618: l_config_effective_date DATE;
3619: l_rest_cfg_lookup_setting cz_db_settings.value%TYPE := ' ';
3620:
3621: BEGIN
3622: IF p_config_hdr_id IS NULL OR p_config_rev_nbr IS NULL THEN
3623: RAISE_APPLICATION_ERROR(-20001, 'Config header ID AND config rev nbr ' ||
3648: --- at a customer site.
3649: BEGIN
3650: SELECT value
3651: INTO l_rest_cfg_lookup_setting
3652: FROM cz_db_settings WHERE setting_id = 'RestoredConfigDefaultModelLookupDate';
3653: EXCEPTION
3654: WHEN OTHERS THEN
3655: l_rest_cfg_lookup_setting := NULL;
3656: END;
3961: RETURN VARCHAR2 IS
3962: v_pool_token cz_model_pool_mappings.pool_identifier%TYPE := NULL;
3963: -- vsingava 03 Feb '11. Bug11693636
3964: -- If we do not find any pool-token set up for the product-key,
3965: -- as a fail-over, read the setting value from cz_db_settings
3966:
3967: BEGIN
3968: IF p_product_key IS NOT NULL THEN
3969: SELECT pool_identifier INTO v_pool_token FROM cz_model_pool_mappings WHERE model_product_key = p_product_key;
3970: END IF;
3971: RETURN v_pool_token;
3972: EXCEPTION WHEN NO_DATA_FOUND THEN
3973: BEGIN
3974: SELECT value INTO v_pool_token FROM cz_db_settings WHERE section_name = 'ORAAPPS_INTEGRATE' AND setting_id = 'DefaultPoolIdentifier';
3975: RETURN v_pool_token;
3976: EXCEPTION WHEN NO_DATA_FOUND THEN
3977: RETURN NULL;
3978: END;