1: package body biv_bin_esc_rsc_pkg as
2: /* $Header: bivbescb.pls 115.19 2004/01/27 06:59:29 vganeshk ship $ */
3: ---------------------------------------------
4: procedure sr_esc_bin (p_param_str varchar2) is
5: l_profile varchar2(50) := 'BIV_DASH_' || fnd_global.user_id || '_' ||
6: fnd_global.resp_id;
7: l_report_code varchar2(50) := 'BIV_DASH_ESC_BIN';
8: l_session_id biv_tmp_bin.session_id%type;
9: l_new_param_str varchar2(2000);
2: /* $Header: bivbescb.pls 115.19 2004/01/27 06:59:29 vganeshk ship $ */
3: ---------------------------------------------
4: procedure sr_esc_bin (p_param_str varchar2) is
5: l_profile varchar2(50) := 'BIV_DASH_' || fnd_global.user_id || '_' ||
6: fnd_global.resp_id;
7: l_report_code varchar2(50) := 'BIV_DASH_ESC_BIN';
8: l_session_id biv_tmp_bin.session_id%type;
9: l_new_param_str varchar2(2000);
10: l_sql_sttmnt varchar2(4000);