APPS.EGO_USER_ATTRS_DATA_PVT dependencies on DUAL

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

1856: -- turn it into a string version of that Date, formatted into --
1857: -- our standard format. --
1858: ----------------------------------------------------------------
1859: l_dynamic_sql := 'SELECT TO_CHAR('||l_formatted_string||', '''||
1860: EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT||''') FROM DUAL';
1861: Debug_Msg('In Format_Sysdate_Expression, l_dynamic_sql is as follows:', 3);
1862: Debug_SQL(l_dynamic_sql);
1863: EXECUTE IMMEDIATE l_dynamic_sql INTO l_formatted_string;
1864:

Line 3456: SELECT REPLACE(l_vs_where_clause,FND_GLOBAL.LOCAL_CHR(10),FND_GLOBAL.LOCAL_CHR(32)) INTO l_vs_where_clause FROM dual; --replacing new line character

3452: ------------------------------------------------------
3453: -- In case the where clause has new line or tabs --
3454: -- we need to remove it BugFix:4101091 --
3455: ------------------------------------------------------
3456: SELECT REPLACE(l_vs_where_clause,FND_GLOBAL.LOCAL_CHR(10),FND_GLOBAL.LOCAL_CHR(32)) INTO l_vs_where_clause FROM dual; --replacing new line character
3457: SELECT REPLACE(l_vs_where_clause,FND_GLOBAL.LOCAL_CHR(13),FND_GLOBAL.LOCAL_CHR(32)) INTO l_vs_where_clause FROM dual; --removing carriage return
3458: -------------------------------------------------------------------------
3459: -- well if there is still some special character left we cant help it. --
3460: -------------------------------------------------------------------------

Line 3457: SELECT REPLACE(l_vs_where_clause,FND_GLOBAL.LOCAL_CHR(13),FND_GLOBAL.LOCAL_CHR(32)) INTO l_vs_where_clause FROM dual; --removing carriage return

3453: -- In case the where clause has new line or tabs --
3454: -- we need to remove it BugFix:4101091 --
3455: ------------------------------------------------------
3456: SELECT REPLACE(l_vs_where_clause,FND_GLOBAL.LOCAL_CHR(10),FND_GLOBAL.LOCAL_CHR(32)) INTO l_vs_where_clause FROM dual; --replacing new line character
3457: SELECT REPLACE(l_vs_where_clause,FND_GLOBAL.LOCAL_CHR(13),FND_GLOBAL.LOCAL_CHR(32)) INTO l_vs_where_clause FROM dual; --removing carriage return
3458: -------------------------------------------------------------------------
3459: -- well if there is still some special character left we cant help it. --
3460: -------------------------------------------------------------------------
3461:

Line 4939: FROM DUAL;

4935: x_token_table(2).TOKEN_NAME := 'CLASS_MEANING';
4936: BEGIN
4937: SELECT EGO_EXT_FWK_PUB.Get_Class_Meaning(p_object_id, p_class_code_name_value_pairs(1).VALUE)
4938: INTO x_token_table(2).TOKEN_VALUE
4939: FROM DUAL;
4940: EXCEPTION
4941: WHEN OTHERS THEN
4942: x_token_table(2).TOKEN_VALUE := p_class_code_name_value_pairs(1).VALUE;
4943: END;

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

7489: -- If we haven't set it yet, get a sequence-generated extension --
7490: -- ID to use for insertion into both the base and TL tables --
7491: ------------------------------------------------------------------
7492: IF (l_new_extension_id IS NULL) THEN
7493: SELECT EGO_EXTFWK_S.NEXTVAL INTO l_new_extension_id FROM DUAL;
7494: END IF;
7495:
7496: --Start 4105841
7497: Get_Changed_Attributes(

Line 7772: FROM DUAL;

7768: --Added by geguo for 9373845
7769: SELECT NVL(G_WHO_CREATION_DATE, SYSDATE),
7770: NVL(G_WHO_LAST_UPDATE_DATE, SYSDATE)
7771: INTO G_WHO_CREATION_DATE, G_WHO_LAST_UPDATE_DATE
7772: FROM DUAL;
7773:
7774: Add_Bind(p_bind_identifier => 'CREATION_DATE'
7775: ,p_value => G_WHO_CREATION_DATE);
7776: FND_DSQL.Add_Text(', ');

Line 8428: SELECT NVL(G_WHO_LAST_UPDATE_DATE, SYSDATE) INTO G_WHO_LAST_UPDATE_DATE FROM DUAL;

8424: ,p_value => l_current_user_id);
8425: FND_DSQL.Add_Text(', ');
8426: FND_DSQL.Add_Text('LAST_UPDATE_DATE = ');
8427: --Added by geguo for 9373845
8428: SELECT NVL(G_WHO_LAST_UPDATE_DATE, SYSDATE) INTO G_WHO_LAST_UPDATE_DATE FROM DUAL;
8429: Add_Bind(p_bind_identifier => 'LAST_UPDATE_DATE'
8430: ,p_value => G_WHO_LAST_UPDATE_DATE);
8431: FND_DSQL.Add_Text(', ');
8432: FND_DSQL.Add_Text('LAST_UPDATE_LOGIN = ');

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

18602: l_number_val := NULL;
18603: l_str_val := NULL;
18604: IF(INSTR(UPPER(l_attr_record.DEFAULT_VALUE),'$SYSDATE$') <> 0) THEN
18605: l_temp_date_str := REPLACE(UPPER(l_attr_record.DEFAULT_VALUE),'$'); --bugfix:5228308
18606: EXECUTE IMMEDIATE 'SELECT '||l_temp_date_str||' FROM DUAL '
18607: INTO l_date_val;
18608: ELSE
18609: l_date_val := TO_DATE(l_attr_record.DEFAULT_VALUE,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
18610: END IF;