DBA Data[Home] [Help]

APPS.JE_JEHUIAGE_XMLP_PKG dependencies on FND_PROFILE_OPTIONS

Line 869: L_PROFILE FND_PROFILE_OPTIONS.PROFILE_OPTION_NAME%TYPE;

865:
866: FUNCTION CHECK_AP_PROFILE RETURN BOOLEAN IS
867: BEGIN
868: DECLARE
869: L_PROFILE FND_PROFILE_OPTIONS.PROFILE_OPTION_NAME%TYPE;
870: L_ENDDATE FND_PROFILE_OPTIONS.END_DATE_ACTIVE%TYPE;
871: BEGIN
872: IF P_DEBUG_SWITCH = 'Y' THEN
873: /*SRW.MESSAGE(100

Line 870: L_ENDDATE FND_PROFILE_OPTIONS.END_DATE_ACTIVE%TYPE;

866: FUNCTION CHECK_AP_PROFILE RETURN BOOLEAN IS
867: BEGIN
868: DECLARE
869: L_PROFILE FND_PROFILE_OPTIONS.PROFILE_OPTION_NAME%TYPE;
870: L_ENDDATE FND_PROFILE_OPTIONS.END_DATE_ACTIVE%TYPE;
871: BEGIN
872: IF P_DEBUG_SWITCH = 'Y' THEN
873: /*SRW.MESSAGE(100
874: ,'In Check_AP_PRofile')*/NULL;

Line 882: FND_PROFILE_OPTIONS

878: ,''),
879: END_DATE_ACTIVE
880: INTO L_PROFILE,L_ENDDATE
881: FROM
882: FND_PROFILE_OPTIONS
883: WHERE PROFILE_OPTION_NAME = 'AP_SORT_BY_ALTERNATE';
884: IF L_PROFILE = '' THEN
885: IF P_DEBUG_SWITCH = 'Y' THEN
886: /*SRW.MESSAGE(108