DBA Data[Home] [Help]

APPS.BIV_RT_TASK_BLOG_PKG dependencies on DBMS_SQL

Line 75: x_cur := dbms_sql.open_cursor;

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);

Line 76: dbms_sql.parse(x_cur,x_sql_sttmnt,dbms_sql.native);

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);

Line 78: dbms_sql.bind_variable(x_cur,':x_stat1', x_status1);

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);

Line 79: dbms_sql.bind_variable(x_cur,':x_stat2', x_status2);

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:

Line 80: dbms_sql.bind_variable(x_cur,':x_stat3', x_status3);

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');

Line 81: dbms_sql.bind_variable(x_cur,':session_id', l_session_id);

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

Line 82: x_dummy := dbms_sql.execute(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
86: set col12 = col4 - col6 - col8 - col10

Line 273: l_cur := dbms_sql.open_cursor;

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);

Line 274: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);

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');

Line 276: dbms_sql.bind_variable(l_cur,':session_id',l_session_id);

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',

Line 277: l_dummy := dbms_sql.execute(l_cur);

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',

Line 459: l_cur := dbms_sql.open_cursor;

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);

Line 460: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);

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');

Line 462: dbms_sql.bind_variable(l_cur,':session_id',l_session_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');
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');

Line 463: l_dummy := dbms_sql.execute(l_cur);

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

Line 543: l_cur := dbms_sql.open_cursor;

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);

Line 544: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);

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;

Line 546: dbms_sql.bind_variable(l_cur,':session_id',l_session_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;
549:
550: l_pos := 'updating resource name';

Line 547: l_dummy := dbms_sql.execute(l_cur);

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