DBA Data[Home] [Help]

APPS.AZ_PROFILEVALUE_CONVERT_PKG dependencies on FND_GLOBAL

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

321:
322: SQL_STR := LTRIM( UPPER(SQL_STR) ); -- SQL_STR should be like 'SQL="..."...
323: SQL_STR := LTRIM( SUBSTR(SQL_STR,4) ); -- getting rid of 'SQL'
324: SQL_STR := LTRIM( SUBSTR(SQL_STR,2) ); -- getting rid of '='.
325: SQL_STR := REPLACE( SQL_STR, FND_GLOBAL.LOCAL_CHR(10), ' ' ); -- replacing \n with space
326:
327: TMP_STR := LTRIM( SQL_STR ); -- saving a copy in tmp str
328: TMP_STR := REPLACE( TMP_STR, '\"', 'TT' ); -- replace \" to anything(doesn't have to be 'TT'), but be of length 2
329: FOR idx IN 2..LENGTH(TMP_STR) LOOP

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

461:
462: ELSIF ( P_CONVERT_METHOD = 'UPLOAD' ) THEN
463:
464: v_SelectStmt := 'SELECT ' || SEL_CODE || ' FROM ' || STR_FROM || ' WHERE LTRIM(RTRIM(' || SEL_DISPLAY || ')) = '
465: || FND_GLOBAL.LOCAL_CHR(39) || LTRIM(RTRIM(P_PROFILE_VALUE)) || FND_GLOBAL.LOCAL_CHR(39);
466: IF ( STR_WHERE IS NOT NULL AND LENGTH( LTRIM(RTRIM(STR_WHERE)) ) > 0 ) THEN
467: v_SelectStmt := v_SelectStmt || ' AND ' || STR_WHERE;
468: END IF;
469: