APPS.BIV_HS_ESC_ACTVTY_PKG dependencies on FND_PROFILE

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

19: l_bt_param_str varchar2(2000);
20: l_session_id biv_tmp_hs2.session_id % type;
21: l_err varchar2(1000);
22: l_loc varchar2( 100);
23: l_debug varchar2(30) := fnd_profile.value('BIV:DEBUG');
24: begin
25: biv_core_pkg.g_report_id := 'BIV_HS_SR_ESCALATION';
26: l_session_id := biv_core_pkg.get_session_id;
27: biv_core_pkg.clean_dcf_table('biv_tmp_hs2');

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

221: l_start_date date;
222: l_end_date date;
223: l_time_frame varchar2(80);
224: l_session_id biv_tmp_hs2.session_id % type;
225: l_debug varchar2(30) := fnd_profile.value('BIV:DEBUG');
226: begin
227: biv_core_pkg.g_report_id := 'BIV_HS_ESCALATION_VIEW';
228: l_session_id := biv_core_pkg.get_session_id;
229: biv_core_pkg.clean_dcf_table('biv_tmp_hs2');

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

329: l_drilldown_rep varchar2(30);
330: l_ttl_recs number;
331: l_ttl_meaning fnd_lookups.meaning%type :=
332: biv_core_pkg.get_lookup_meaning('TOTAL');
333: l_debug varchar2(30) := fnd_profile.value('BIV:DEBUG');
334: begin
335: l_dt_fmt := FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK');
336: biv_core_pkg.g_report_id := 'BIV_HS_SR_ACTIVITY';
337: l_session_id := biv_core_pkg.get_session_id;

Line 335: l_dt_fmt := FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK');

331: l_ttl_meaning fnd_lookups.meaning%type :=
332: biv_core_pkg.get_lookup_meaning('TOTAL');
333: l_debug varchar2(30) := fnd_profile.value('BIV:DEBUG');
334: begin
335: l_dt_fmt := FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK');
336: biv_core_pkg.g_report_id := 'BIV_HS_SR_ACTIVITY';
337: l_session_id := biv_core_pkg.get_session_id;
338: biv_core_pkg.clean_dcf_table('biv_tmp_hs2');
339: biv_core_pkg.g_srl_no := 1;