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