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_MLIST_INFO_PKG dependencies on FND_PROFILE

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

136: end if;
137: END LOOP;
138:
139:
140: l_fnd_user_id := fnd_profile.value('USER_ID');
141:
142:
143:
144: l_curr_rec := null;

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

179: if p_action_key in ('astuminb_cust_notes','astuminb_cont_notes','astuminb_cust_notes_man','astuminb_cont_notes_man') then
180: l_cur_ind := 'DESC' ;
181:
182: elsif p_action_key in ('astuminb_prof_cust_notes','astuminb_prof_cont_notes','astuminb_prof_cust_notes_man','astuminb_prof_cont_notes_man') then
183: l_months := nvl(FND_PROFILE.VALUE('AST_DEFAULT_MONTHS_TO_VIEW'), 1);
184: l_from_date := add_months(sysdate, -1 * l_months );
185: l_cur_ind := 'MON' ;
186: end if;
187:

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

191: l_object_code,
192: l_object_id)
193: LOOP
194: --Code added for BugFix#4451689 --Start
195: if fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS')='Y' THEN
196: l_client_tz_id := to_number ( fnd_profile.value('CLIENT_TIMEZONE_ID'));
197: l_server_tz_id := to_number( fnd_profile.value('SERVER_TIMEZONE_ID'));
198: --modified with c2_rec.entered_date instead of c2_rec.creation_date for bug#4177915
199: c2_rec.entered_date:=HZ_TIMEZONE_PUB.Convert_DateTime(l_server_tz_id,l_client_tz_id,c2_rec.entered_date);

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

192: l_object_id)
193: LOOP
194: --Code added for BugFix#4451689 --Start
195: if fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS')='Y' THEN
196: l_client_tz_id := to_number ( fnd_profile.value('CLIENT_TIMEZONE_ID'));
197: l_server_tz_id := to_number( fnd_profile.value('SERVER_TIMEZONE_ID'));
198: --modified with c2_rec.entered_date instead of c2_rec.creation_date for bug#4177915
199: c2_rec.entered_date:=HZ_TIMEZONE_PUB.Convert_DateTime(l_server_tz_id,l_client_tz_id,c2_rec.entered_date);
200:

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

193: LOOP
194: --Code added for BugFix#4451689 --Start
195: if fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS')='Y' THEN
196: l_client_tz_id := to_number ( fnd_profile.value('CLIENT_TIMEZONE_ID'));
197: l_server_tz_id := to_number( fnd_profile.value('SERVER_TIMEZONE_ID'));
198: --modified with c2_rec.entered_date instead of c2_rec.creation_date for bug#4177915
199: c2_rec.entered_date:=HZ_TIMEZONE_PUB.Convert_DateTime(l_server_tz_id,l_client_tz_id,c2_rec.entered_date);
200:
201: end if;

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

223: l_object_code,
224: l_object_id, l_from_date)
225: LOOP
226: --Code added for BugFix#4451689 --Start
227: if fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS')='Y' THEN
228: l_client_tz_id := to_number ( fnd_profile.value('CLIENT_TIMEZONE_ID'));
229: l_server_tz_id := to_number( fnd_profile.value('SERVER_TIMEZONE_ID'));
230: --modified with c2_rec.entered_date instead of c2_rec.creation_date for bug#4177915
231: c2_rec.entered_date:=HZ_TIMEZONE_PUB.Convert_DateTime(l_server_tz_id,l_client_tz_id,c2_rec.entered_date);

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

224: l_object_id, l_from_date)
225: LOOP
226: --Code added for BugFix#4451689 --Start
227: if fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS')='Y' THEN
228: l_client_tz_id := to_number ( fnd_profile.value('CLIENT_TIMEZONE_ID'));
229: l_server_tz_id := to_number( fnd_profile.value('SERVER_TIMEZONE_ID'));
230: --modified with c2_rec.entered_date instead of c2_rec.creation_date for bug#4177915
231: c2_rec.entered_date:=HZ_TIMEZONE_PUB.Convert_DateTime(l_server_tz_id,l_client_tz_id,c2_rec.entered_date);
232:

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

225: LOOP
226: --Code added for BugFix#4451689 --Start
227: if fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS')='Y' THEN
228: l_client_tz_id := to_number ( fnd_profile.value('CLIENT_TIMEZONE_ID'));
229: l_server_tz_id := to_number( fnd_profile.value('SERVER_TIMEZONE_ID'));
230: --modified with c2_rec.entered_date instead of c2_rec.creation_date for bug#4177915
231: c2_rec.entered_date:=HZ_TIMEZONE_PUB.Convert_DateTime(l_server_tz_id,l_client_tz_id,c2_rec.entered_date);
232:
233: end if;