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_HS_ESC_ACTVTY_PKG dependencies on DBMS_SQL

Line 78: l_cur := dbms_sql.open_cursor;

74: if (l_debug = 'Y') then
75: biv_core_pkg.biv_debug(l_sql_sttmnt,'BIV_HS_SR_ESCALATION');
76: commit;
77: end if;
78: l_cur := dbms_sql.open_cursor;
79: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);
80: biv_core_pkg.bind_all_variables(l_cur);
81: dbms_sql.bind_variable(l_cur,':session_id', l_session_id);
82: l_loc := 'Before Second Execute';

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

75: biv_core_pkg.biv_debug(l_sql_sttmnt,'BIV_HS_SR_ESCALATION');
76: commit;
77: end if;
78: l_cur := dbms_sql.open_cursor;
79: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);
80: biv_core_pkg.bind_all_variables(l_cur);
81: dbms_sql.bind_variable(l_cur,':session_id', l_session_id);
82: l_loc := 'Before Second Execute';
83: l_dummy := dbms_sql.execute(l_cur);

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

77: end if;
78: l_cur := dbms_sql.open_cursor;
79: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);
80: biv_core_pkg.bind_all_variables(l_cur);
81: dbms_sql.bind_variable(l_cur,':session_id', l_session_id);
82: l_loc := 'Before Second Execute';
83: l_dummy := dbms_sql.execute(l_cur);
84:
85: biv_core_pkg.update_base_col_desc('biv_tmp_hs2');

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

79: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);
80: biv_core_pkg.bind_all_variables(l_cur);
81: dbms_sql.bind_variable(l_cur,':session_id', l_session_id);
82: l_loc := 'Before Second Execute';
83: l_dummy := dbms_sql.execute(l_cur);
84:
85: biv_core_pkg.update_base_col_desc('biv_tmp_hs2');
86: -- Here rownum*2 is select so that there are gaps and in those gaps
87: -- we could fit total for groups

Line 269: l_cur := dbms_sql.open_cursor;

265: if (l_debug = 'Y') then
266: biv_core_pkg.biv_debug(l_sql_sttmnt,'BIV_HS_ESCALATION_VIEW');
267: commit;
268: end if;
269: l_cur := dbms_sql.open_cursor;
270: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);
271: biv_core_pkg.bind_all_variables(l_cur);
272: dbms_sql.bind_variable(l_cur,':x_session_id', l_session_id);
273: l_dummy := dbms_sql.execute(l_cur);

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

266: biv_core_pkg.biv_debug(l_sql_sttmnt,'BIV_HS_ESCALATION_VIEW');
267: commit;
268: end if;
269: l_cur := dbms_sql.open_cursor;
270: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);
271: biv_core_pkg.bind_all_variables(l_cur);
272: dbms_sql.bind_variable(l_cur,':x_session_id', l_session_id);
273: l_dummy := dbms_sql.execute(l_cur);
274:

Line 272: dbms_sql.bind_variable(l_cur,':x_session_id', l_session_id);

268: end if;
269: l_cur := dbms_sql.open_cursor;
270: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);
271: biv_core_pkg.bind_all_variables(l_cur);
272: dbms_sql.bind_variable(l_cur,':x_session_id', l_session_id);
273: l_dummy := dbms_sql.execute(l_cur);
274:
275: --biv_core_pkg.update_base_col_desc('biv_tmp_hs2');
276: biv_core_pkg.update_description('P_AGENT_ID','col7' ,'col8' ,'biv_tmp_hs2');

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

269: l_cur := dbms_sql.open_cursor;
270: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);
271: biv_core_pkg.bind_all_variables(l_cur);
272: dbms_sql.bind_variable(l_cur,':x_session_id', l_session_id);
273: l_dummy := dbms_sql.execute(l_cur);
274:
275: --biv_core_pkg.update_base_col_desc('biv_tmp_hs2');
276: biv_core_pkg.update_description('P_AGENT_ID','col7' ,'col8' ,'biv_tmp_hs2');
277: biv_core_pkg.update_description('P_AGENT_ID','col9' ,'col10','biv_tmp_hs2');

Line 483: l_cur := dbms_sql.open_cursor;

479: if (l_debug = 'Y') then
480: biv_core_pkg.biv_debug(l_sql_sttmnt,'BIV_HS_SR_ACTIVITY');
481: commit;
482: end if;
483: l_cur := dbms_sql.open_cursor;
484: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);
485: biv_core_pkg.bind_all_variables(l_cur);
486: l_loc := 'Before bind variables';
487: dbms_sql.bind_variable(l_cur,':y_start_date1' , l_start_date);

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

480: biv_core_pkg.biv_debug(l_sql_sttmnt,'BIV_HS_SR_ACTIVITY');
481: commit;
482: end if;
483: l_cur := dbms_sql.open_cursor;
484: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);
485: biv_core_pkg.bind_all_variables(l_cur);
486: l_loc := 'Before bind variables';
487: dbms_sql.bind_variable(l_cur,':y_start_date1' , l_start_date);
488: dbms_sql.bind_variable(l_cur,':y_start_date2' , l_start_date);

Line 487: dbms_sql.bind_variable(l_cur,':y_start_date1' , l_start_date);

483: l_cur := dbms_sql.open_cursor;
484: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);
485: biv_core_pkg.bind_all_variables(l_cur);
486: l_loc := 'Before bind variables';
487: dbms_sql.bind_variable(l_cur,':y_start_date1' , l_start_date);
488: dbms_sql.bind_variable(l_cur,':y_start_date2' , l_start_date);
489: dbms_sql.bind_variable(l_cur,':y_start_date3' , l_start_date);
490: dbms_sql.bind_variable(l_cur,':y_start_date4' , l_start_date);
491: dbms_sql.bind_variable(l_cur,':y_start_date5' , l_start_date);

Line 488: dbms_sql.bind_variable(l_cur,':y_start_date2' , l_start_date);

484: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);
485: biv_core_pkg.bind_all_variables(l_cur);
486: l_loc := 'Before bind variables';
487: dbms_sql.bind_variable(l_cur,':y_start_date1' , l_start_date);
488: dbms_sql.bind_variable(l_cur,':y_start_date2' , l_start_date);
489: dbms_sql.bind_variable(l_cur,':y_start_date3' , l_start_date);
490: dbms_sql.bind_variable(l_cur,':y_start_date4' , l_start_date);
491: dbms_sql.bind_variable(l_cur,':y_start_date5' , l_start_date);
492: dbms_sql.bind_variable(l_cur,':y_start_date6' , l_start_date);

Line 489: dbms_sql.bind_variable(l_cur,':y_start_date3' , l_start_date);

485: biv_core_pkg.bind_all_variables(l_cur);
486: l_loc := 'Before bind variables';
487: dbms_sql.bind_variable(l_cur,':y_start_date1' , l_start_date);
488: dbms_sql.bind_variable(l_cur,':y_start_date2' , l_start_date);
489: dbms_sql.bind_variable(l_cur,':y_start_date3' , l_start_date);
490: dbms_sql.bind_variable(l_cur,':y_start_date4' , l_start_date);
491: dbms_sql.bind_variable(l_cur,':y_start_date5' , l_start_date);
492: dbms_sql.bind_variable(l_cur,':y_start_date6' , l_start_date);
493: dbms_sql.bind_variable(l_cur,':y_start_date7' , l_start_date);

Line 490: dbms_sql.bind_variable(l_cur,':y_start_date4' , l_start_date);

486: l_loc := 'Before bind variables';
487: dbms_sql.bind_variable(l_cur,':y_start_date1' , l_start_date);
488: dbms_sql.bind_variable(l_cur,':y_start_date2' , l_start_date);
489: dbms_sql.bind_variable(l_cur,':y_start_date3' , l_start_date);
490: dbms_sql.bind_variable(l_cur,':y_start_date4' , l_start_date);
491: dbms_sql.bind_variable(l_cur,':y_start_date5' , l_start_date);
492: dbms_sql.bind_variable(l_cur,':y_start_date6' , l_start_date);
493: dbms_sql.bind_variable(l_cur,':y_start_date7' , l_start_date);
494: dbms_sql.bind_variable(l_cur,':y_start_date8' , l_start_date);

Line 491: dbms_sql.bind_variable(l_cur,':y_start_date5' , l_start_date);

487: dbms_sql.bind_variable(l_cur,':y_start_date1' , l_start_date);
488: dbms_sql.bind_variable(l_cur,':y_start_date2' , l_start_date);
489: dbms_sql.bind_variable(l_cur,':y_start_date3' , l_start_date);
490: dbms_sql.bind_variable(l_cur,':y_start_date4' , l_start_date);
491: dbms_sql.bind_variable(l_cur,':y_start_date5' , l_start_date);
492: dbms_sql.bind_variable(l_cur,':y_start_date6' , l_start_date);
493: dbms_sql.bind_variable(l_cur,':y_start_date7' , l_start_date);
494: dbms_sql.bind_variable(l_cur,':y_start_date8' , l_start_date);
495: dbms_sql.bind_variable(l_cur,':y_start_date9' , l_start_date);

Line 492: dbms_sql.bind_variable(l_cur,':y_start_date6' , l_start_date);

488: dbms_sql.bind_variable(l_cur,':y_start_date2' , l_start_date);
489: dbms_sql.bind_variable(l_cur,':y_start_date3' , l_start_date);
490: dbms_sql.bind_variable(l_cur,':y_start_date4' , l_start_date);
491: dbms_sql.bind_variable(l_cur,':y_start_date5' , l_start_date);
492: dbms_sql.bind_variable(l_cur,':y_start_date6' , l_start_date);
493: dbms_sql.bind_variable(l_cur,':y_start_date7' , l_start_date);
494: dbms_sql.bind_variable(l_cur,':y_start_date8' , l_start_date);
495: dbms_sql.bind_variable(l_cur,':y_start_date9' , l_start_date);
496: dbms_sql.bind_variable(l_cur,':y_start_date10', l_start_date);

Line 493: dbms_sql.bind_variable(l_cur,':y_start_date7' , l_start_date);

489: dbms_sql.bind_variable(l_cur,':y_start_date3' , l_start_date);
490: dbms_sql.bind_variable(l_cur,':y_start_date4' , l_start_date);
491: dbms_sql.bind_variable(l_cur,':y_start_date5' , l_start_date);
492: dbms_sql.bind_variable(l_cur,':y_start_date6' , l_start_date);
493: dbms_sql.bind_variable(l_cur,':y_start_date7' , l_start_date);
494: dbms_sql.bind_variable(l_cur,':y_start_date8' , l_start_date);
495: dbms_sql.bind_variable(l_cur,':y_start_date9' , l_start_date);
496: dbms_sql.bind_variable(l_cur,':y_start_date10', l_start_date);
497: dbms_sql.bind_variable(l_cur,':y_start_date11', l_start_date);

Line 494: dbms_sql.bind_variable(l_cur,':y_start_date8' , l_start_date);

490: dbms_sql.bind_variable(l_cur,':y_start_date4' , l_start_date);
491: dbms_sql.bind_variable(l_cur,':y_start_date5' , l_start_date);
492: dbms_sql.bind_variable(l_cur,':y_start_date6' , l_start_date);
493: dbms_sql.bind_variable(l_cur,':y_start_date7' , l_start_date);
494: dbms_sql.bind_variable(l_cur,':y_start_date8' , l_start_date);
495: dbms_sql.bind_variable(l_cur,':y_start_date9' , l_start_date);
496: dbms_sql.bind_variable(l_cur,':y_start_date10', l_start_date);
497: dbms_sql.bind_variable(l_cur,':y_start_date11', l_start_date);
498: dbms_sql.bind_variable(l_cur,':y_end_date1' , l_end_date );

Line 495: dbms_sql.bind_variable(l_cur,':y_start_date9' , l_start_date);

491: dbms_sql.bind_variable(l_cur,':y_start_date5' , l_start_date);
492: dbms_sql.bind_variable(l_cur,':y_start_date6' , l_start_date);
493: dbms_sql.bind_variable(l_cur,':y_start_date7' , l_start_date);
494: dbms_sql.bind_variable(l_cur,':y_start_date8' , l_start_date);
495: dbms_sql.bind_variable(l_cur,':y_start_date9' , l_start_date);
496: dbms_sql.bind_variable(l_cur,':y_start_date10', l_start_date);
497: dbms_sql.bind_variable(l_cur,':y_start_date11', l_start_date);
498: dbms_sql.bind_variable(l_cur,':y_end_date1' , l_end_date );
499: dbms_sql.bind_variable(l_cur,':y_end_date2' , l_end_date );

Line 496: dbms_sql.bind_variable(l_cur,':y_start_date10', l_start_date);

492: dbms_sql.bind_variable(l_cur,':y_start_date6' , l_start_date);
493: dbms_sql.bind_variable(l_cur,':y_start_date7' , l_start_date);
494: dbms_sql.bind_variable(l_cur,':y_start_date8' , l_start_date);
495: dbms_sql.bind_variable(l_cur,':y_start_date9' , l_start_date);
496: dbms_sql.bind_variable(l_cur,':y_start_date10', l_start_date);
497: dbms_sql.bind_variable(l_cur,':y_start_date11', l_start_date);
498: dbms_sql.bind_variable(l_cur,':y_end_date1' , l_end_date );
499: dbms_sql.bind_variable(l_cur,':y_end_date2' , l_end_date );
500: dbms_sql.bind_variable(l_cur,':y_end_date3' , l_end_date );

Line 497: dbms_sql.bind_variable(l_cur,':y_start_date11', l_start_date);

493: dbms_sql.bind_variable(l_cur,':y_start_date7' , l_start_date);
494: dbms_sql.bind_variable(l_cur,':y_start_date8' , l_start_date);
495: dbms_sql.bind_variable(l_cur,':y_start_date9' , l_start_date);
496: dbms_sql.bind_variable(l_cur,':y_start_date10', l_start_date);
497: dbms_sql.bind_variable(l_cur,':y_start_date11', l_start_date);
498: dbms_sql.bind_variable(l_cur,':y_end_date1' , l_end_date );
499: dbms_sql.bind_variable(l_cur,':y_end_date2' , l_end_date );
500: dbms_sql.bind_variable(l_cur,':y_end_date3' , l_end_date );
501: dbms_sql.bind_variable(l_cur,':y_end_date4' , l_end_date );

Line 498: dbms_sql.bind_variable(l_cur,':y_end_date1' , l_end_date );

494: dbms_sql.bind_variable(l_cur,':y_start_date8' , l_start_date);
495: dbms_sql.bind_variable(l_cur,':y_start_date9' , l_start_date);
496: dbms_sql.bind_variable(l_cur,':y_start_date10', l_start_date);
497: dbms_sql.bind_variable(l_cur,':y_start_date11', l_start_date);
498: dbms_sql.bind_variable(l_cur,':y_end_date1' , l_end_date );
499: dbms_sql.bind_variable(l_cur,':y_end_date2' , l_end_date );
500: dbms_sql.bind_variable(l_cur,':y_end_date3' , l_end_date );
501: dbms_sql.bind_variable(l_cur,':y_end_date4' , l_end_date );
502: dbms_sql.bind_variable(l_cur,':y_end_date5' , l_end_date );

Line 499: dbms_sql.bind_variable(l_cur,':y_end_date2' , l_end_date );

495: dbms_sql.bind_variable(l_cur,':y_start_date9' , l_start_date);
496: dbms_sql.bind_variable(l_cur,':y_start_date10', l_start_date);
497: dbms_sql.bind_variable(l_cur,':y_start_date11', l_start_date);
498: dbms_sql.bind_variable(l_cur,':y_end_date1' , l_end_date );
499: dbms_sql.bind_variable(l_cur,':y_end_date2' , l_end_date );
500: dbms_sql.bind_variable(l_cur,':y_end_date3' , l_end_date );
501: dbms_sql.bind_variable(l_cur,':y_end_date4' , l_end_date );
502: dbms_sql.bind_variable(l_cur,':y_end_date5' , l_end_date );
503: dbms_sql.bind_variable(l_cur,':y_end_date6' , l_end_date );

Line 500: dbms_sql.bind_variable(l_cur,':y_end_date3' , l_end_date );

496: dbms_sql.bind_variable(l_cur,':y_start_date10', l_start_date);
497: dbms_sql.bind_variable(l_cur,':y_start_date11', l_start_date);
498: dbms_sql.bind_variable(l_cur,':y_end_date1' , l_end_date );
499: dbms_sql.bind_variable(l_cur,':y_end_date2' , l_end_date );
500: dbms_sql.bind_variable(l_cur,':y_end_date3' , l_end_date );
501: dbms_sql.bind_variable(l_cur,':y_end_date4' , l_end_date );
502: dbms_sql.bind_variable(l_cur,':y_end_date5' , l_end_date );
503: dbms_sql.bind_variable(l_cur,':y_end_date6' , l_end_date );
504: dbms_sql.bind_variable(l_cur,':y_end_date7' , l_end_date );

Line 501: dbms_sql.bind_variable(l_cur,':y_end_date4' , l_end_date );

497: dbms_sql.bind_variable(l_cur,':y_start_date11', l_start_date);
498: dbms_sql.bind_variable(l_cur,':y_end_date1' , l_end_date );
499: dbms_sql.bind_variable(l_cur,':y_end_date2' , l_end_date );
500: dbms_sql.bind_variable(l_cur,':y_end_date3' , l_end_date );
501: dbms_sql.bind_variable(l_cur,':y_end_date4' , l_end_date );
502: dbms_sql.bind_variable(l_cur,':y_end_date5' , l_end_date );
503: dbms_sql.bind_variable(l_cur,':y_end_date6' , l_end_date );
504: dbms_sql.bind_variable(l_cur,':y_end_date7' , l_end_date );
505: -- dbms_sql.bind_variable(l_cur,':y_end_date8' , l_end_date );

Line 502: dbms_sql.bind_variable(l_cur,':y_end_date5' , l_end_date );

498: dbms_sql.bind_variable(l_cur,':y_end_date1' , l_end_date );
499: dbms_sql.bind_variable(l_cur,':y_end_date2' , l_end_date );
500: dbms_sql.bind_variable(l_cur,':y_end_date3' , l_end_date );
501: dbms_sql.bind_variable(l_cur,':y_end_date4' , l_end_date );
502: dbms_sql.bind_variable(l_cur,':y_end_date5' , l_end_date );
503: dbms_sql.bind_variable(l_cur,':y_end_date6' , l_end_date );
504: dbms_sql.bind_variable(l_cur,':y_end_date7' , l_end_date );
505: -- dbms_sql.bind_variable(l_cur,':y_end_date8' , l_end_date );
506: dbms_sql.bind_variable(l_cur,':y_end_date9' , l_end_date );

Line 503: dbms_sql.bind_variable(l_cur,':y_end_date6' , l_end_date );

499: dbms_sql.bind_variable(l_cur,':y_end_date2' , l_end_date );
500: dbms_sql.bind_variable(l_cur,':y_end_date3' , l_end_date );
501: dbms_sql.bind_variable(l_cur,':y_end_date4' , l_end_date );
502: dbms_sql.bind_variable(l_cur,':y_end_date5' , l_end_date );
503: dbms_sql.bind_variable(l_cur,':y_end_date6' , l_end_date );
504: dbms_sql.bind_variable(l_cur,':y_end_date7' , l_end_date );
505: -- dbms_sql.bind_variable(l_cur,':y_end_date8' , l_end_date );
506: dbms_sql.bind_variable(l_cur,':y_end_date9' , l_end_date );
507: dbms_sql.bind_variable(l_cur,':y_end_date10' , l_end_date );

Line 504: dbms_sql.bind_variable(l_cur,':y_end_date7' , l_end_date );

500: dbms_sql.bind_variable(l_cur,':y_end_date3' , l_end_date );
501: dbms_sql.bind_variable(l_cur,':y_end_date4' , l_end_date );
502: dbms_sql.bind_variable(l_cur,':y_end_date5' , l_end_date );
503: dbms_sql.bind_variable(l_cur,':y_end_date6' , l_end_date );
504: dbms_sql.bind_variable(l_cur,':y_end_date7' , l_end_date );
505: -- dbms_sql.bind_variable(l_cur,':y_end_date8' , l_end_date );
506: dbms_sql.bind_variable(l_cur,':y_end_date9' , l_end_date );
507: dbms_sql.bind_variable(l_cur,':y_end_date10' , l_end_date );
508: dbms_sql.bind_variable(l_cur,':y_end_date11' , l_end_date );

Line 505: -- dbms_sql.bind_variable(l_cur,':y_end_date8' , l_end_date );

501: dbms_sql.bind_variable(l_cur,':y_end_date4' , l_end_date );
502: dbms_sql.bind_variable(l_cur,':y_end_date5' , l_end_date );
503: dbms_sql.bind_variable(l_cur,':y_end_date6' , l_end_date );
504: dbms_sql.bind_variable(l_cur,':y_end_date7' , l_end_date );
505: -- dbms_sql.bind_variable(l_cur,':y_end_date8' , l_end_date );
506: dbms_sql.bind_variable(l_cur,':y_end_date9' , l_end_date );
507: dbms_sql.bind_variable(l_cur,':y_end_date10' , l_end_date );
508: dbms_sql.bind_variable(l_cur,':y_end_date11' , l_end_date );
509: dbms_sql.bind_variable(l_cur,':session_id' , l_session_id);

Line 506: dbms_sql.bind_variable(l_cur,':y_end_date9' , l_end_date );

502: dbms_sql.bind_variable(l_cur,':y_end_date5' , l_end_date );
503: dbms_sql.bind_variable(l_cur,':y_end_date6' , l_end_date );
504: dbms_sql.bind_variable(l_cur,':y_end_date7' , l_end_date );
505: -- dbms_sql.bind_variable(l_cur,':y_end_date8' , l_end_date );
506: dbms_sql.bind_variable(l_cur,':y_end_date9' , l_end_date );
507: dbms_sql.bind_variable(l_cur,':y_end_date10' , l_end_date );
508: dbms_sql.bind_variable(l_cur,':y_end_date11' , l_end_date );
509: dbms_sql.bind_variable(l_cur,':session_id' , l_session_id);
510: l_loc := 'Before first Execute';

Line 507: dbms_sql.bind_variable(l_cur,':y_end_date10' , l_end_date );

503: dbms_sql.bind_variable(l_cur,':y_end_date6' , l_end_date );
504: dbms_sql.bind_variable(l_cur,':y_end_date7' , l_end_date );
505: -- dbms_sql.bind_variable(l_cur,':y_end_date8' , l_end_date );
506: dbms_sql.bind_variable(l_cur,':y_end_date9' , l_end_date );
507: dbms_sql.bind_variable(l_cur,':y_end_date10' , l_end_date );
508: dbms_sql.bind_variable(l_cur,':y_end_date11' , l_end_date );
509: dbms_sql.bind_variable(l_cur,':session_id' , l_session_id);
510: l_loc := 'Before first Execute';
511: l_dummy := dbms_sql.execute(l_cur);

Line 508: dbms_sql.bind_variable(l_cur,':y_end_date11' , l_end_date );

504: dbms_sql.bind_variable(l_cur,':y_end_date7' , l_end_date );
505: -- dbms_sql.bind_variable(l_cur,':y_end_date8' , l_end_date );
506: dbms_sql.bind_variable(l_cur,':y_end_date9' , l_end_date );
507: dbms_sql.bind_variable(l_cur,':y_end_date10' , l_end_date );
508: dbms_sql.bind_variable(l_cur,':y_end_date11' , l_end_date );
509: dbms_sql.bind_variable(l_cur,':session_id' , l_session_id);
510: l_loc := 'Before first Execute';
511: l_dummy := dbms_sql.execute(l_cur);
512: l_loc := 'After first Execute';

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

505: -- dbms_sql.bind_variable(l_cur,':y_end_date8' , l_end_date );
506: dbms_sql.bind_variable(l_cur,':y_end_date9' , l_end_date );
507: dbms_sql.bind_variable(l_cur,':y_end_date10' , l_end_date );
508: dbms_sql.bind_variable(l_cur,':y_end_date11' , l_end_date );
509: dbms_sql.bind_variable(l_cur,':session_id' , l_session_id);
510: l_loc := 'Before first Execute';
511: l_dummy := dbms_sql.execute(l_cur);
512: l_loc := 'After first Execute';
513: biv_core_pkg.update_base_col_desc('biv_tmp_hs2');

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

507: dbms_sql.bind_variable(l_cur,':y_end_date10' , l_end_date );
508: dbms_sql.bind_variable(l_cur,':y_end_date11' , l_end_date );
509: dbms_sql.bind_variable(l_cur,':session_id' , l_session_id);
510: l_loc := 'Before first Execute';
511: l_dummy := dbms_sql.execute(l_cur);
512: l_loc := 'After first Execute';
513: biv_core_pkg.update_base_col_desc('biv_tmp_hs2');
514: l_sql_sttmnt := '
515: insert into biv_tmp_hs2(report_code,rowno,