APPS.BIV_RT_AGENT_MGR_PKG dependencies on FND_PROFILE

Line 18: l_dt_fmt varchar2(50) := fnd_profile.value('ICX_DATE_FORMAT_MASK');

14: x_param_str varchar2(500);
15: l_new_param_str varchar2(200);
16: l_session_id varchar2(50);
17: l_dt varchar2(20);
18: l_dt_fmt varchar2(50) := fnd_profile.value('ICX_DATE_FORMAT_MASK');
19: l_ttl_recs number;
20: l_url1 varchar2(2000);
21: l_url3 varchar2(2000);
22: l_url5 varchar2(2000);

Line 27: l_debug varchar2(30) := fnd_profile.value('BIV:DEBUG');

23: l_url7 varchar2(2000);
24: l_url9 varchar2(2000);
25: l_url_base_col varchar2(2000);
26: l_ttl_desc fnd_lookups.meaning % type;
27: l_debug varchar2(30) := fnd_profile.value('BIV:DEBUG');
28: begin
29: biv_core_pkg.clean_dcf_table('biv_tmp_rt2');
30: biv_core_pkg.g_report_id := 'BIV_RT_AGENT_REPORT';
31: l_dt := to_char(sysdate,l_dt_fmt);

Line 378: l_dt_fmt varchar2(50) := fnd_profile.value('ICX_DATE_FORMAT_MASK');

374: l_ttl_param_str varchar2(200);
375: l_dummy number;
376: l_session_id biv_tmp_rt2.session_id % type;
377: l_pos varchar2(50);
378: l_dt_fmt varchar2(50) := fnd_profile.value('ICX_DATE_FORMAT_MASK');
379: l_dt varchar2(50);
380: l_ttl_recs number;
381: l_ttl_desc fnd_lookups.meaning % type;
382: l_debug varchar2(30) := fnd_profile.value('BIV:DEBUG');

Line 382: l_debug varchar2(30) := fnd_profile.value('BIV:DEBUG');

378: l_dt_fmt varchar2(50) := fnd_profile.value('ICX_DATE_FORMAT_MASK');
379: l_dt varchar2(50);
380: l_ttl_recs number;
381: l_ttl_desc fnd_lookups.meaning % type;
382: l_debug varchar2(30) := fnd_profile.value('BIV:DEBUG');
383: begin
384: biv_core_pkg.clean_dcf_table('biv_tmp_rt2');
385: l_dt := to_char(sysdate,l_dt_fmt);
386: biv_core_pkg.g_report_id := 'BIV_RT_MANAGER_REPORT';