APPS.BIV_BIN_ESC_RSC_PKG dependencies on FND_PROFILE

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

12: l_where_clause varchar2(2000);
13: l_cur number;
14: l_dummy number;
15: l_err varchar2(2000);
16: l_debug varchar2(30) := fnd_profile.value('BIV:DEBUG');
17: begin
18: biv_core_pkg.g_report_id := 'BIV_BIN_SR_ESCALATION';
19:
20: l_session_id := biv_core_pkg.get_session_id;

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

122: l_from_list varchar2(1000);
123: l_where_clause varchar2(2000);
124: l_cur number;
125: l_dummy number;
126: l_debug varchar2(30) := fnd_profile.value('BIV:DEBUG');
127: l_all fnd_lookups.meaning % type :=
128: biv_core_pkg.get_lookup_meaning('ALL');
129: begin
130: biv_core_pkg.g_report_id := 'BIV_BIN_RESOURCE';

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

228: l_from_list varchar2(1000);
229: l_where_clause varchar2(2000);
230: l_cur number;
231: l_dummy number;
232: l_debug varchar2(30) := fnd_profile.value('BIV:DEBUG');
233: begin
234: biv_core_pkg.g_report_id := 'BIV_TASK_SUMMARY';
235: l_session_id := biv_core_pkg.get_session_id;
236: biv_core_pkg.clean_dcf_table('biv_tmp_rt2');

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

333: --------------------------------------------
334: procedure rltd_task_rep(p_sr_id varchar2) is
335: l_sr_id varchar2(20);
336: l_session_id biv_tmp_bin.session_id%type;
337: l_debug varchar2(30) := fnd_profile.value('BIV:DEBUG');
338: begin
339: l_session_id := biv_core_pkg.get_session_id;
340: biv_core_pkg.clean_dcf_table('biv_tmp_rt2');
341: l_sr_id := biv_core_pkg.get_parameter_value(p_sr_id, 'P_SR_ID');