APPS.BIX_CALLS_HANDLED_RPT_PKG dependencies on BIX_DM_REPORT

Line 26: INSERT /*+ PARALLEL(tr,2) */ INTO bix_dm_report tr (

22: g_sqlstmt := NULL;
23:
24: /* Form the SQL string to insert the rows into the temp table */
25: g_sqlstmt := '
26: INSERT /*+ PARALLEL(tr,2) */ INTO bix_dm_report tr (
27: session_id
28: , report_code
29: , col3
30: , col4

Line 211: INSERT /*+ PARALLEL(tr,2) */ INTO bix_dm_report tr (

207: g_sqlstmt := NULL;
208:
209: /* Form the SQL string to insert the rows into the temp table */
210: g_sqlstmt := '
211: INSERT /*+ PARALLEL(tr,2) */ INTO bix_dm_report tr (
212: session_id
213: , report_code
214: , col2
215: , col3

Line 491: /* Delete the rows from the table bix_dm_report for the current icx session and report */

487: SELECT icx_sec.g_session_id
488: INTO g_session_id
489: FROM dual;
490:
491: /* Delete the rows from the table bix_dm_report for the current icx session and report */
492: /* so that we donot display the leftover rows from the previous execution of the report */
493: DELETE bix_dm_report
494: WHERE report_code = 'BIX_CALLS_HANDLED_RPT'
495: AND session_id = g_session_id;

Line 493: DELETE bix_dm_report

489: FROM dual;
490:
491: /* Delete the rows from the table bix_dm_report for the current icx session and report */
492: /* so that we donot display the leftover rows from the previous execution of the report */
493: DELETE bix_dm_report
494: WHERE report_code = 'BIX_CALLS_HANDLED_RPT'
495: AND session_id = g_session_id;
496:
497: /* Fetch the sysdate */

Line 563: UPDATE bix_dm_report

559: /* l_drill_down_ind = 'n' : we have to display the detail rows of the agent */
560: IF (l_drill_down_ind = 'n') THEN
561: /* Update the temp table so that next time the user clicked on the */
562: /* same agent we donot display the detail rows of the agent again */
563: UPDATE bix_dm_report
564: SET col3 = 'p' || l_group_id || 'c' || to_char(l_agent_id) || 'y'
565: WHERE col3 = 'p' || l_group_id || 'c' || to_char(l_agent_id) || 'n'
566: AND report_code = 'BIX_CALLS_HANDLED_RPT'
567: AND session_id = g_session_id;