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.BIV_RT_TASK_BLOG_PKG dependencies on FND_PROFILE

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

26: x_dummy number;
27: l_session_id biv_tmp_rt2.session_id % type;
28: l_ttl_recs number;
29: l_ttl_meaning fnd_lookups.meaning % type;
30: l_debug varchar2(30) := fnd_profile.value('BIV:DEBUG');
31: begin
32: biv_core_pkg.g_report_id := 'BIV_RT_BACKLOG_BY_STATUS';
33: l_session_id := biv_core_pkg.get_session_id;
34: biv_core_pkg.clean_dcf_table('biv_tmp_rt2');

Line 36: x_status1 := fnd_profile.value('BIV:INC_STATUS_1');

32: biv_core_pkg.g_report_id := 'BIV_RT_BACKLOG_BY_STATUS';
33: l_session_id := biv_core_pkg.get_session_id;
34: biv_core_pkg.clean_dcf_table('biv_tmp_rt2');
35:
36: x_status1 := fnd_profile.value('BIV:INC_STATUS_1');
37: x_status2 := fnd_profile.value('BIV:INC_STATUS_2');
38: x_status3 := fnd_profile.value('BIV:INC_STATUS_3');
39:
40: biv_core_pkg.get_report_parameters(p_param_str);

Line 37: x_status2 := fnd_profile.value('BIV:INC_STATUS_2');

33: l_session_id := biv_core_pkg.get_session_id;
34: biv_core_pkg.clean_dcf_table('biv_tmp_rt2');
35:
36: x_status1 := fnd_profile.value('BIV:INC_STATUS_1');
37: x_status2 := fnd_profile.value('BIV:INC_STATUS_2');
38: x_status3 := fnd_profile.value('BIV:INC_STATUS_3');
39:
40: biv_core_pkg.get_report_parameters(p_param_str);
41:

Line 38: x_status3 := fnd_profile.value('BIV:INC_STATUS_3');

34: biv_core_pkg.clean_dcf_table('biv_tmp_rt2');
35:
36: x_status1 := fnd_profile.value('BIV:INC_STATUS_1');
37: x_status2 := fnd_profile.value('BIV:INC_STATUS_2');
38: x_status3 := fnd_profile.value('BIV:INC_STATUS_3');
39:
40: biv_core_pkg.get_report_parameters(p_param_str);
41:
42: if (l_debug = 'Y') then

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

235: l_dummy number;
236: l_session_id biv_tmp_rt2.session_id % type;
237: l_ttl_recs number;
238: l_ttl_meaning fnd_lookups.meaning % type;
239: l_debug varchar2(30) := fnd_profile.value('BIV:DEBUG');
240: begin
241: biv_core_pkg.g_report_id := 'BIV_RT_TASK_ACTIVITY';
242: l_session_id := biv_core_pkg.get_session_id;
243: biv_core_pkg.clean_dcf_table('biv_tmp_rt2');

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

407: l_new_param_str2 varchar2(2000);
408: l_param_name varchar2(80);
409: l_dummy number;
410: l_session_id biv_tmp_rt2.session_id % type;
411: l_debug varchar2(30) := fnd_profile.value('BIV:DEBUG');
412: begin
413: l_session_id := biv_core_pkg.get_session_id;
414: biv_core_pkg.clean_dcf_table('biv_tmp_rt2');
415:

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

482: l_session_id biv_tmp_rt2.session_id % type;
483: l_err varchar2(1000);
484: l_new_param_str varchar2(200);
485: l_pos varchar2(80);
486: l_debug varchar2(30) := fnd_profile.value('BIV:DEBUG');
487: begin
488: biv_core_pkg.g_report_id := 'BIV_SERVICE_REQUEST';
489: l_session_id := biv_core_pkg.get_session_id;
490: biv_core_pkg.clean_dcf_table('biv_tmp_hs2');

Line 787: return(status_descr(fnd_profile.value('BIV:INC_STATUS_1')));

783: return('invalid Status Id');
784: end;
785: function status_descr1(p_param_str varchar2) return varchar2 is
786: begin
787: return(status_descr(fnd_profile.value('BIV:INC_STATUS_1')));
788: end;
789: function status_descr2(p_param_str varchar2) return varchar2 is
790: begin
791: return(status_descr(fnd_profile.value('BIV:INC_STATUS_2')));

Line 791: return(status_descr(fnd_profile.value('BIV:INC_STATUS_2')));

787: return(status_descr(fnd_profile.value('BIV:INC_STATUS_1')));
788: end;
789: function status_descr2(p_param_str varchar2) return varchar2 is
790: begin
791: return(status_descr(fnd_profile.value('BIV:INC_STATUS_2')));
792: end;
793: function status_descr3(p_param_str varchar2) return varchar2 is
794: begin
795: return(status_descr(fnd_profile.value('BIV:INC_STATUS_3')));

Line 795: return(status_descr(fnd_profile.value('BIV:INC_STATUS_3')));

791: return(status_descr(fnd_profile.value('BIV:INC_STATUS_2')));
792: end;
793: function status_descr3(p_param_str varchar2) return varchar2 is
794: begin
795: return(status_descr(fnd_profile.value('BIV:INC_STATUS_3')));
796: end;
797: procedure service_requests_task(p_param_str varchar2) is
798: l_debug varchar2(30) := fnd_profile.value('BIV:DEBUG');
799: begin

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

794: begin
795: return(status_descr(fnd_profile.value('BIV:INC_STATUS_3')));
796: end;
797: procedure service_requests_task(p_param_str varchar2) is
798: l_debug varchar2(30) := fnd_profile.value('BIV:DEBUG');
799: begin
800: service_requests(p_param_str);
801: update biv_tmp_hs2 rep
802: set col26 = (select count(*)