71:
72: if (l_debug = 'Y') then
73: biv_core_pkg.biv_debug(x_sql_sttmnt,biv_core_pkg.g_report_id);
74: end if;
75: x_cur := dbms_sql.open_cursor;
76: dbms_sql.parse(x_cur,x_sql_sttmnt,dbms_sql.native);
77: biv_core_pkg.bind_all_variables(x_cur);
78: dbms_sql.bind_variable(x_cur,':x_stat1', x_status1);
79: dbms_sql.bind_variable(x_cur,':x_stat2', x_status2);
72: if (l_debug = 'Y') then
73: biv_core_pkg.biv_debug(x_sql_sttmnt,biv_core_pkg.g_report_id);
74: end if;
75: x_cur := dbms_sql.open_cursor;
76: dbms_sql.parse(x_cur,x_sql_sttmnt,dbms_sql.native);
77: biv_core_pkg.bind_all_variables(x_cur);
78: dbms_sql.bind_variable(x_cur,':x_stat1', x_status1);
79: dbms_sql.bind_variable(x_cur,':x_stat2', x_status2);
80: dbms_sql.bind_variable(x_cur,':x_stat3', x_status3);
74: end if;
75: x_cur := dbms_sql.open_cursor;
76: dbms_sql.parse(x_cur,x_sql_sttmnt,dbms_sql.native);
77: biv_core_pkg.bind_all_variables(x_cur);
78: dbms_sql.bind_variable(x_cur,':x_stat1', x_status1);
79: dbms_sql.bind_variable(x_cur,':x_stat2', x_status2);
80: dbms_sql.bind_variable(x_cur,':x_stat3', x_status3);
81: dbms_sql.bind_variable(x_cur,':session_id', l_session_id);
82: x_dummy := dbms_sql.execute(x_cur);
75: x_cur := dbms_sql.open_cursor;
76: dbms_sql.parse(x_cur,x_sql_sttmnt,dbms_sql.native);
77: biv_core_pkg.bind_all_variables(x_cur);
78: dbms_sql.bind_variable(x_cur,':x_stat1', x_status1);
79: dbms_sql.bind_variable(x_cur,':x_stat2', x_status2);
80: dbms_sql.bind_variable(x_cur,':x_stat3', x_status3);
81: dbms_sql.bind_variable(x_cur,':session_id', l_session_id);
82: x_dummy := dbms_sql.execute(x_cur);
83:
76: dbms_sql.parse(x_cur,x_sql_sttmnt,dbms_sql.native);
77: biv_core_pkg.bind_all_variables(x_cur);
78: dbms_sql.bind_variable(x_cur,':x_stat1', x_status1);
79: dbms_sql.bind_variable(x_cur,':x_stat2', x_status2);
80: dbms_sql.bind_variable(x_cur,':x_stat3', x_status3);
81: dbms_sql.bind_variable(x_cur,':session_id', l_session_id);
82: x_dummy := dbms_sql.execute(x_cur);
83:
84: biv_core_pkg.update_base_col_desc('biv_tmp_rt2');
77: biv_core_pkg.bind_all_variables(x_cur);
78: dbms_sql.bind_variable(x_cur,':x_stat1', x_status1);
79: dbms_sql.bind_variable(x_cur,':x_stat2', x_status2);
80: dbms_sql.bind_variable(x_cur,':x_stat3', x_status3);
81: dbms_sql.bind_variable(x_cur,':session_id', l_session_id);
82: x_dummy := dbms_sql.execute(x_cur);
83:
84: biv_core_pkg.update_base_col_desc('biv_tmp_rt2');
85: update biv_tmp_rt2
78: dbms_sql.bind_variable(x_cur,':x_stat1', x_status1);
79: dbms_sql.bind_variable(x_cur,':x_stat2', x_status2);
80: dbms_sql.bind_variable(x_cur,':x_stat3', x_status3);
81: dbms_sql.bind_variable(x_cur,':session_id', l_session_id);
82: x_dummy := dbms_sql.execute(x_cur);
83:
84: biv_core_pkg.update_base_col_desc('biv_tmp_rt2');
85: update biv_tmp_rt2
86: set col12 = col4 - col6 - col8 - col10
269: ' group by ' || biv_core_pkg.g_base_column || ')';
270: if (l_debug = 'Y') then
271: biv_core_pkg.biv_debug(l_sql_sttmnt,'BIV_RT_TASK_ACTIVITY');
272: end if;
273: l_cur := dbms_sql.open_cursor;
274: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);
275: biv_core_pkg.bind_all_variables(l_cur);
276: dbms_sql.bind_variable(l_cur,':session_id',l_session_id);
277: l_dummy := dbms_sql.execute(l_cur);
270: if (l_debug = 'Y') then
271: biv_core_pkg.biv_debug(l_sql_sttmnt,'BIV_RT_TASK_ACTIVITY');
272: end if;
273: l_cur := dbms_sql.open_cursor;
274: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);
275: biv_core_pkg.bind_all_variables(l_cur);
276: dbms_sql.bind_variable(l_cur,':session_id',l_session_id);
277: l_dummy := dbms_sql.execute(l_cur);
278: biv_core_pkg.update_base_col_desc('biv_tmp_rt2');
272: end if;
273: l_cur := dbms_sql.open_cursor;
274: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);
275: biv_core_pkg.bind_all_variables(l_cur);
276: dbms_sql.bind_variable(l_cur,':session_id',l_session_id);
277: l_dummy := dbms_sql.execute(l_cur);
278: biv_core_pkg.update_base_col_desc('biv_tmp_rt2');
279:
280: select decode(biv_core_pkg.g_srt_by,'2','to_number(col4) desc',
273: l_cur := dbms_sql.open_cursor;
274: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);
275: biv_core_pkg.bind_all_variables(l_cur);
276: dbms_sql.bind_variable(l_cur,':session_id',l_session_id);
277: l_dummy := dbms_sql.execute(l_cur);
278: biv_core_pkg.update_base_col_desc('biv_tmp_rt2');
279:
280: select decode(biv_core_pkg.g_srt_by,'2','to_number(col4) desc',
281: '3','to_number(col6) desc',
455:
456: if (l_debug = 'Y') then
457: biv_core_pkg.biv_debug(l_sql_sttmnt,biv_core_pkg.g_report_id);
458: end if;
459: l_cur := dbms_sql.open_cursor;
460: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);
461: biv_core_pkg.bind_all_variables(l_cur);
462: dbms_sql.bind_variable(l_cur,':session_id',l_session_id);
463: l_dummy := dbms_sql.execute(l_cur);
456: if (l_debug = 'Y') then
457: biv_core_pkg.biv_debug(l_sql_sttmnt,biv_core_pkg.g_report_id);
458: end if;
459: l_cur := dbms_sql.open_cursor;
460: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);
461: biv_core_pkg.bind_all_variables(l_cur);
462: dbms_sql.bind_variable(l_cur,':session_id',l_session_id);
463: l_dummy := dbms_sql.execute(l_cur);
464: biv_core_pkg.update_description('P_AGENT_ID','col3' ,'col4' , 'biv_tmp_rt2');
458: end if;
459: l_cur := dbms_sql.open_cursor;
460: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);
461: biv_core_pkg.bind_all_variables(l_cur);
462: dbms_sql.bind_variable(l_cur,':session_id',l_session_id);
463: l_dummy := dbms_sql.execute(l_cur);
464: biv_core_pkg.update_description('P_AGENT_ID','col3' ,'col4' , 'biv_tmp_rt2');
465: biv_core_pkg.update_description('P_AGENT_ID','col17','col18', 'biv_tmp_rt2');
466: biv_core_pkg.update_description('P_PRD_ID' ,'col19','col20', 'biv_tmp_rt2');
459: l_cur := dbms_sql.open_cursor;
460: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);
461: biv_core_pkg.bind_all_variables(l_cur);
462: dbms_sql.bind_variable(l_cur,':session_id',l_session_id);
463: l_dummy := dbms_sql.execute(l_cur);
464: biv_core_pkg.update_description('P_AGENT_ID','col3' ,'col4' , 'biv_tmp_rt2');
465: biv_core_pkg.update_description('P_AGENT_ID','col17','col18', 'biv_tmp_rt2');
466: biv_core_pkg.update_description('P_PRD_ID' ,'col19','col20', 'biv_tmp_rt2');
467: exception
539:
540: if (l_debug = 'Y') then
541: biv_core_pkg.biv_debug(l_sql_sttmnt,biv_core_pkg.g_report_id);
542: end if;
543: l_cur := dbms_sql.open_cursor;
544: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);
545: biv_core_pkg.bind_all_variables(l_cur);
546: dbms_sql.bind_variable(l_cur,':session_id',l_session_id);
547: l_dummy := dbms_sql.execute(l_cur);
540: if (l_debug = 'Y') then
541: biv_core_pkg.biv_debug(l_sql_sttmnt,biv_core_pkg.g_report_id);
542: end if;
543: l_cur := dbms_sql.open_cursor;
544: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);
545: biv_core_pkg.bind_all_variables(l_cur);
546: dbms_sql.bind_variable(l_cur,':session_id',l_session_id);
547: l_dummy := dbms_sql.execute(l_cur);
548: commit;
542: end if;
543: l_cur := dbms_sql.open_cursor;
544: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);
545: biv_core_pkg.bind_all_variables(l_cur);
546: dbms_sql.bind_variable(l_cur,':session_id',l_session_id);
547: l_dummy := dbms_sql.execute(l_cur);
548: commit;
549:
550: l_pos := 'updating resource name';
543: l_cur := dbms_sql.open_cursor;
544: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);
545: biv_core_pkg.bind_all_variables(l_cur);
546: dbms_sql.bind_variable(l_cur,':session_id',l_session_id);
547: l_dummy := dbms_sql.execute(l_cur);
548: commit;
549:
550: l_pos := 'updating resource name';
551: begin