APPS.EGO_USER_ATTRS_DATA_PVT dependencies on DUAL

Line 1713: EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT||''') FROM DUAL';

1709: -- turn it into a string version of that Date, formatted into --
1710: -- our standard format. --
1711: ----------------------------------------------------------------
1712: l_dynamic_sql := 'SELECT TO_CHAR('||l_formatted_string||', '''||
1713: EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT||''') FROM DUAL';
1714: Debug_Msg('In Format_Sysdate_Expression, l_dynamic_sql is as follows:', 3);
1715: Debug_SQL(l_dynamic_sql);
1716: EXECUTE IMMEDIATE l_dynamic_sql INTO l_formatted_string;
1717:

Line 4473: FROM DUAL;

4469: x_token_table(2).TOKEN_NAME := 'CLASS_MEANING';
4470: BEGIN
4471: SELECT EGO_EXT_FWK_PUB.Get_Class_Meaning(p_object_id, p_class_code_name_value_pairs(1).VALUE)
4472: INTO x_token_table(2).TOKEN_VALUE
4473: FROM DUAL;
4474: EXCEPTION
4475: WHEN OTHERS THEN
4476: x_token_table(2).TOKEN_VALUE := p_class_code_name_value_pairs(1).VALUE;
4477: END;

Line 6977: SELECT EGO_EXTFWK_S.NEXTVAL INTO l_new_extension_id FROM DUAL;

6973: -- If we haven't set it yet, get a sequence-generated extension --
6974: -- ID to use for insertion into both the base and TL tables --
6975: ------------------------------------------------------------------
6976: IF (l_new_extension_id IS NULL) THEN
6977: SELECT EGO_EXTFWK_S.NEXTVAL INTO l_new_extension_id FROM DUAL;
6978: END IF;
6979:
6980: --Start 4105841
6981: Get_Changed_Attributes(

Line 17443: EXECUTE IMMEDIATE 'SELECT '||l_temp_date_str||' FROM DUAL '

17439: l_number_val := NULL;
17440: l_str_val := NULL;
17441: IF(INSTR(UPPER(l_attr_record.DEFAULT_VALUE),'$SYSDATE$') <> 0) THEN
17442: l_temp_date_str := REPLACE(UPPER(l_attr_record.DEFAULT_VALUE),'$'); --bugfix:5228308
17443: EXECUTE IMMEDIATE 'SELECT '||l_temp_date_str||' FROM DUAL '
17444: INTO l_date_val;
17445: ELSE
17446: l_date_val := TO_DATE(l_attr_record.DEFAULT_VALUE,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
17447: END IF;