DBA Data[Home] [Help]

APPS.IGS_PE_CONFIG_PVT dependencies on FND_PROFILE

Line 84: l_verify_mode fnd_profile_option_values.profile_option_value%TYPE;

80: FROM IGS_PE_HZ_PARTIES
81: WHERE party_id = p_person_id;
82:
83:
84: l_verify_mode fnd_profile_option_values.profile_option_value%TYPE;
85: l_term_date DATE;
86: l_verify_time DATE;
87:
88: l_api_name CONSTANT VARCHAR2(30) := 'PE_INFO';

Line 120: l_verify_mode := NVL(FND_PROFILE.VALUE('IGS_PE_VERIFY_MODE'), 'E');

116:
117: -- API body
118:
119: --Profile is taken as Every Time Student Logs on to the SS Page
120: l_verify_mode := NVL(FND_PROFILE.VALUE('IGS_PE_VERIFY_MODE'), 'E');
121:
122: IF l_verify_mode = 'E' THEN
123: x_result :='TRUE';
124: RETURN;

Line 152: TO_NUMBER(NVL(FND_PROFILE.VALUE('IGS_PE_VERIFY_INT'), '0')) THEN

148: IF l_verify_mode = 'D' THEN
149:
150:
151: IF (TRUNC(SYSDATE) - TRUNC(l_verify_time)) >=
152: TO_NUMBER(NVL(FND_PROFILE.VALUE('IGS_PE_VERIFY_INT'), '0')) THEN
153:
154: x_result :='TRUE';
155: RETURN;
156: ELSE