DBA Data[Home] [Help]

APPS.EGO_USER_ATTRS_COMMON_PVT dependencies on DUAL

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

849: ------------------------------------------------------
850: -- In case the where clause has new line or tabs --
851: -- we need to remove it BugFix:4101091 --
852: ------------------------------------------------------
853: SELECT REPLACE(l_where_clause,FND_GLOBAL.LOCAL_CHR(10),FND_GLOBAL.LOCAL_CHR(32)) INTO l_where_clause FROM dual; --replacing new line character
854: SELECT REPLACE(l_where_clause,FND_GLOBAL.LOCAL_CHR(13),FND_GLOBAL.LOCAL_CHR(32)) INTO l_where_clause FROM dual; --removing carriage return
855: -------------------------------------------------------------------------
856: -- well if there is still some special character left we cant help it. --
857: -------------------------------------------------------------------------

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

850: -- In case the where clause has new line or tabs --
851: -- we need to remove it BugFix:4101091 --
852: ------------------------------------------------------
853: SELECT REPLACE(l_where_clause,FND_GLOBAL.LOCAL_CHR(10),FND_GLOBAL.LOCAL_CHR(32)) INTO l_where_clause FROM dual; --replacing new line character
854: SELECT REPLACE(l_where_clause,FND_GLOBAL.LOCAL_CHR(13),FND_GLOBAL.LOCAL_CHR(32)) INTO l_where_clause FROM dual; --removing carriage return
855: -------------------------------------------------------------------------
856: -- well if there is still some special character left we cant help it. --
857: -------------------------------------------------------------------------
858:

Line 1884: -- each individual value separately.

1880: -----------------------------------
1881: IF (p_use_binds) THEN
1882:
1883: -- in the case of using binds, we have to parse the value string to bind
1884: -- each individual value separately.
1885: l_prev_string_index := 1;
1886: l_is_last_element := FALSE;
1887:
1888: LOOP

Line 2500: FROM dual

2496: -- fix for 12.2 OLP compatible
2497:
2498: CURSOR c IS
2499: SELECT 1
2500: FROM dual
2501: WHERE exists (SELECT NULL
2502: FROM sys.all_tab_columns
2503: WHERE table_name = p_table_name
2504: AND column_name = p_column_name

Line 2516: FROM dual

2512:
2513: -- bug#15835530 fix for 12.2 OLP compatible
2514: CURSOR c IS
2515: SELECT 1
2516: FROM dual
2517: WHERE exists (SELECT NULL
2518: FROM user_synonyms syn, dba_tab_columns col
2519: WHERE syn.synonym_name = p_table_name
2520: AND col.owner = syn.table_owner