APPS.JE_JEHUIAGE_XMLP_PKG dependencies on FND_PROFILE

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

Line 933: SORT_BY_ALTERNATE := FND_PROFILE.VALUE('AP_SORT_BY_ALTERNATE');

929: ,'AP Profile Exists')*/NULL;
930: END IF;
931: BEGIN
932: /*SRW.REFERENCE(SORT_BY_ALTERNATE)*/NULL;
933: SORT_BY_ALTERNATE := FND_PROFILE.VALUE('AP_SORT_BY_ALTERNATE');
934: EXCEPTION
935: WHEN OTHERS THEN
936: SORT_BY_ALTERNATE := 'N';
937: END;