eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AST_UWQ_LLIST_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 159: l_months := nvl(FND_PROFILE.VALUE('AST_DEFAULT_MONTHS_TO_VIEW'), 1);

155:
156: if p_action_key in ('astulinb_cust_notes','astulinb_cont_notes', 'astulinb_lead_notes') then
157: l_cur_ind := 'DESC' ;
158: elsif p_action_key in ('astulinb_prof_cust_notes','astulinb_prof_cont_notes', 'astulinb_prof_lead_notes') then
159: l_months := nvl(FND_PROFILE.VALUE('AST_DEFAULT_MONTHS_TO_VIEW'), 1);
160: l_from_date := add_months(sysdate, -1 * l_months );
161: l_cur_ind := 'MON' ;
162: end if;
163:

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

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

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

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

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

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

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

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

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

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

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

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