APPS.AZ_PROFILEVALUE_CONVERT_PKG dependencies on FND_GLOBAL

Line 307: SQL_STR := REPLACE( SQL_STR, FND_GLOBAL.LOCAL_CHR(10), ' ' ); -- replacing \n with space

303:
304: SQL_STR := LTRIM( UPPER(SQL_STR) ); -- SQL_STR should be like 'SQL="..."...
305: SQL_STR := LTRIM( SUBSTR(SQL_STR,4) ); -- getting rid of 'SQL'
306: SQL_STR := LTRIM( SUBSTR(SQL_STR,2) ); -- getting rid of '='.
307: SQL_STR := REPLACE( SQL_STR, FND_GLOBAL.LOCAL_CHR(10), ' ' ); -- replacing \n with space
308:
309: TMP_STR := LTRIM( SQL_STR ); -- saving a copy in tmp str
310: TMP_STR := REPLACE( TMP_STR, '\"', 'TT' ); -- replace \" to anything(doesn't have to be 'TT'), but be of length 2
311: FOR idx IN 2..LENGTH(TMP_STR) LOOP

Line 447: || FND_GLOBAL.LOCAL_CHR(39) || LTRIM(RTRIM(P_PROFILE_VALUE)) || FND_GLOBAL.LOCAL_CHR(39);

443:
444: ELSIF ( P_CONVERT_METHOD = 'UPLOAD' ) THEN
445:
446: v_SelectStmt := 'SELECT ' || SEL_CODE || ' FROM ' || STR_FROM || ' WHERE LTRIM(RTRIM(' || SEL_DISPLAY || ')) = '
447: || FND_GLOBAL.LOCAL_CHR(39) || LTRIM(RTRIM(P_PROFILE_VALUE)) || FND_GLOBAL.LOCAL_CHR(39);
448: IF ( STR_WHERE IS NOT NULL AND LENGTH( LTRIM(RTRIM(STR_WHERE)) ) > 0 ) THEN
449: v_SelectStmt := v_SelectStmt || ' AND ' || STR_WHERE;
450: END IF;
451: