DBA Data[Home] [Help]

APPS.BSC_DESIGNER_PVT dependencies on FND_PROFILE

Line 2906: This is wrapper for query fnd_profile.get from VB

2902: x_source => 'Dimension_Change');
2903: END Dimension_Change;
2904:
2905: /*-------------------------------------------------------
2906: This is wrapper for query fnd_profile.get from VB
2907: ---------------------------------------------------------*/
2908: FUNCTION FND_PROFILE_GET (name VARCHAR2)
2909: RETURN VARCHAR2 is
2910: val VARCHAR2(32767);

Line 2908: FUNCTION FND_PROFILE_GET (name VARCHAR2)

2904:
2905: /*-------------------------------------------------------
2906: This is wrapper for query fnd_profile.get from VB
2907: ---------------------------------------------------------*/
2908: FUNCTION FND_PROFILE_GET (name VARCHAR2)
2909: RETURN VARCHAR2 is
2910: val VARCHAR2(32767);
2911: BEGIN
2912: -- Now call the stored program

Line 2913: fnd_profile.get(name,val);

2909: RETURN VARCHAR2 is
2910: val VARCHAR2(32767);
2911: BEGIN
2912: -- Now call the stored program
2913: fnd_profile.get(name,val);
2914: --DBMS_OUTPUT.PUT_LINE(SubStr('val = '||val,1,255));
2915: RETURN nvl(val, '');
2916: EXCEPTION
2917: WHEN OTHERS THEN

Line 2919: END FND_PROFILE_GET;

2915: RETURN nvl(val, '');
2916: EXCEPTION
2917: WHEN OTHERS THEN
2918: RETURN '';
2919: END FND_PROFILE_GET;
2920:
2921: /************************************************************************************
2922: -- API name : Copy_Objective_Recors
2923: -- Type : Private