APPS.BIX_KPI_AGENT_RPT_PKG dependencies on BIX_DM_REPORT

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

73: g_sqlstmt := NULL;
74:
75: /* Form the SQL string to insert the rows into the temp table */
76: g_sqlstmt := '
77: INSERT /*+ PARALLEL(tr,2) */ INTO bix_dm_report tr (
78: session_id
79: , report_code
80: , col3
81: , col4

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

240: g_sqlstmt := NULL;
241:
242: /* Form the SQL string to insert the rows into the temp table */
243: g_sqlstmt := '
244: INSERT /*+ PARALLEL(tr,2) */ INTO bix_dm_report tr (
245: session_id
246: , report_code
247: , col2
248: , col3

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

512: SELECT icx_sec.g_session_id
513: INTO g_session_id
514: FROM dual;
515:
516: /* Delete the rows from the table bix_dm_report for the current icx session and report */
517: /* so that we donot display the leftover rows from the previous execution of the report */
518: DELETE bix_dm_report
519: WHERE report_code = 'BIX_KPI_AGENT_RPT'
520: AND session_id = g_session_id;

Line 518: DELETE bix_dm_report

514: FROM dual;
515:
516: /* Delete the rows from the table bix_dm_report for the current icx session and report */
517: /* so that we donot display the leftover rows from the previous execution of the report */
518: DELETE bix_dm_report
519: WHERE report_code = 'BIX_KPI_AGENT_RPT'
520: AND session_id = g_session_id;
521:
522: /* Fetch the sysdate */

Line 591: UPDATE bix_dm_report

587: /* l_drill_down_ind = 'n' : we have to display the detail rows of the agent */
588: IF (l_drill_down_ind = 'n') THEN
589: /* Update the temp table so that next time the user clicked on the */
590: /* same agent we donot display the detail rows of the agent again */
591: UPDATE bix_dm_report
592: SET col3 = 'p' || l_group_id || 'c' || to_char(l_agent_id) || 'y'
593: WHERE col3 = 'p' || l_group_id || 'c' || to_char(l_agent_id) || 'n'
594: AND report_code = 'BIX_KPI_AGENT_RPT'
595: AND session_id = g_session_id;