DBA Data[Home] [Help]

APPS.EGO_USER_ATTRS_COMMON_PVT dependencies on DUAL

Line 743: 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

739: ------------------------------------------------------
740: -- In case the where clause has new line or tabs --
741: -- we need to remove it BugFix:4101091 --
742: ------------------------------------------------------
743: 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
744: SELECT REPLACE(l_where_clause,FND_GLOBAL.LOCAL_CHR(13),FND_GLOBAL.LOCAL_CHR(32)) INTO l_where_clause FROM dual; --removing carriage return
745: -------------------------------------------------------------------------
746: -- well if there is still some special character left we cant help it. --
747: -------------------------------------------------------------------------

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

740: -- In case the where clause has new line or tabs --
741: -- we need to remove it BugFix:4101091 --
742: ------------------------------------------------------
743: 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
744: SELECT REPLACE(l_where_clause,FND_GLOBAL.LOCAL_CHR(13),FND_GLOBAL.LOCAL_CHR(32)) INTO l_where_clause FROM dual; --removing carriage return
745: -------------------------------------------------------------------------
746: -- well if there is still some special character left we cant help it. --
747: -------------------------------------------------------------------------
748:

Line 1773: -- each individual value separately.

1769: -----------------------------------
1770: IF (p_use_binds) THEN
1771:
1772: -- in the case of using binds, we have to parse the value string to bind
1773: -- each individual value separately.
1774: l_prev_string_index := 1;
1775: l_is_last_element := FALSE;
1776:
1777: LOOP