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