APPS.AST_UWQ_OLIST_INFO_PKG dependencies on FND_PROFILE

Line 132: l_fnd_user_id := fnd_profile.value('USER_ID');

128: l_lead_id := l_value ;
129: end if;
130: END LOOP;
131:
132: l_fnd_user_id := fnd_profile.value('USER_ID');
133:
134:
135:
136: l_curr_rec := null;

Line 160: l_months := nvl(FND_PROFILE.VALUE('AST_DEFAULT_MONTHS_TO_VIEW'), 1);

156: if p_action_key in ('astuoinb_cust_notes','astuoinb_cont_notes', 'astuoinb_opp_notes') then
157:
158: l_cur_ind := 'DESC' ;
159: elsif p_action_key in ('astuoinb_prof_cust_notes','astuoinb_prof_cont_notes', 'astuoinb_prof_opp_notes') then
160: l_months := nvl(FND_PROFILE.VALUE('AST_DEFAULT_MONTHS_TO_VIEW'), 1);
161: l_from_date := add_months(sysdate, -1 * l_months );
162: l_cur_ind := 'MON' ;
163: end if;
164:

Line 172: if fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS')='Y' THEN

168: l_object_code,
169: l_object_id)
170: LOOP
171: --Code added for BugFix#4451689 --Start
172: if fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS')='Y' THEN
173: l_client_tz_id := to_number ( fnd_profile.value('CLIENT_TIMEZONE_ID'));
174: l_server_tz_id := to_number( fnd_profile.value('SERVER_TIMEZONE_ID'));
175:
176: --modified with c2_rec.entered_date instead of c2_rec.creation_date_date for bug#4177915

Line 173: l_client_tz_id := to_number ( fnd_profile.value('CLIENT_TIMEZONE_ID'));

169: l_object_id)
170: LOOP
171: --Code added for BugFix#4451689 --Start
172: if fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS')='Y' THEN
173: l_client_tz_id := to_number ( fnd_profile.value('CLIENT_TIMEZONE_ID'));
174: l_server_tz_id := to_number( fnd_profile.value('SERVER_TIMEZONE_ID'));
175:
176: --modified with c2_rec.entered_date instead of c2_rec.creation_date_date for bug#4177915
177: c2_rec.entered_date:=HZ_TIMEZONE_PUB.Convert_DateTime(l_server_tz_id,l_client_tz_id,c2_rec.entered_date);

Line 174: l_server_tz_id := to_number( fnd_profile.value('SERVER_TIMEZONE_ID'));

170: LOOP
171: --Code added for BugFix#4451689 --Start
172: if fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS')='Y' THEN
173: l_client_tz_id := to_number ( fnd_profile.value('CLIENT_TIMEZONE_ID'));
174: l_server_tz_id := to_number( fnd_profile.value('SERVER_TIMEZONE_ID'));
175:
176: --modified with c2_rec.entered_date instead of c2_rec.creation_date_date for bug#4177915
177: c2_rec.entered_date:=HZ_TIMEZONE_PUB.Convert_DateTime(l_server_tz_id,l_client_tz_id,c2_rec.entered_date);
178:

Line 203: if fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS')='Y' THEN

199: l_object_id, l_from_date)
200: LOOP
201:
202: --Code added for BugFix#4451689 --Start
203: if fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS')='Y' THEN
204: l_client_tz_id := to_number ( fnd_profile.value('CLIENT_TIMEZONE_ID'));
205: l_server_tz_id := to_number( fnd_profile.value('SERVER_TIMEZONE_ID'));
206:
207: --modified with c2_rec.entered_date instead of c2_rec.creation_date_date for bug#4177915

Line 204: l_client_tz_id := to_number ( fnd_profile.value('CLIENT_TIMEZONE_ID'));

200: LOOP
201:
202: --Code added for BugFix#4451689 --Start
203: if fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS')='Y' THEN
204: l_client_tz_id := to_number ( fnd_profile.value('CLIENT_TIMEZONE_ID'));
205: l_server_tz_id := to_number( fnd_profile.value('SERVER_TIMEZONE_ID'));
206:
207: --modified with c2_rec.entered_date instead of c2_rec.creation_date_date for bug#4177915
208: c2_rec.entered_date:=HZ_TIMEZONE_PUB.Convert_DateTime(l_server_tz_id,l_client_tz_id,c2_rec.entered_date);

Line 205: l_server_tz_id := to_number( fnd_profile.value('SERVER_TIMEZONE_ID'));

201:
202: --Code added for BugFix#4451689 --Start
203: if fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS')='Y' THEN
204: l_client_tz_id := to_number ( fnd_profile.value('CLIENT_TIMEZONE_ID'));
205: l_server_tz_id := to_number( fnd_profile.value('SERVER_TIMEZONE_ID'));
206:
207: --modified with c2_rec.entered_date instead of c2_rec.creation_date_date for bug#4177915
208: c2_rec.entered_date:=HZ_TIMEZONE_PUB.Convert_DateTime(l_server_tz_id,l_client_tz_id,c2_rec.entered_date);
209: