25: g_sqlstmt := NULL;
26:
27: /* Form the SQL string to insert the rows into the temp table */
28: g_sqlstmt := '
29: INSERT /*+ PARALLEL(tr,2) */ INTO BIX_DM_REPORT tr (
30: session_id,
31: report_code
32: , col3
33: , col4
215: g_sqlstmt := NULL;
216:
217: /* Form the SQL string to insert the rows into the temp table */
218: g_sqlstmt := '
219: INSERT /*+ PARALLEL(tr,2) */ INTO BIX_DM_REPORT tr (
220: session_id,
221: report_code
222: , col2
223: , col3
593: l_prefix VARCHAR2(100);
594:
595: Cursor getPrefix is
596: select col32 prefix
597: from BIX_DM_REPORT
598: where report_code = 'BIX_AGENT_CLASS_REPORT'
599: and col34 = 'LIST'
600: and session_id = l_session_id
601: and col5= to_char(v_agent_id);
604:
605: /* Get the ICX Session Id */
606: l_session_id:= bix_util_pkg.get_icx_session_id;
607:
608: delete from BIX_DM_REPORT
609: where session_id = l_session_id
610: and report_code = 'BIX_AGENT_CLASS_REPORT';
611:
612: /* Fetch the sysdate */
682: v_drill_down_ind := substr(g_parent, length(g_parent), 1);
683:
684: /* v_drill_down_ind = 'n' : we have to display the detail rows of the agent */
685: IF (v_drill_down_ind = 'n') THEN
686: UPDATE BIX_DM_REPORT
687: SET col3 = 'p' || v_group_id || 'c' || to_char(v_agent_id) || 'y'
688: WHERE col3 = 'p' || v_group_id || 'c' || to_char(v_agent_id) || 'n';
689:
690: /* Fetch the detail rows of data for the agent from the */
695: l_prefix :=rec.prefix;
696: end loop;
697:
698: /* update index order that the detail get listed under the agent */
699: update BIX_DM_REPORT
700: set col32 = concat(l_prefix, col32)
701: where report_code = 'BIX_AGENT_CLASS_REPORT'
702: and session_id = l_session_id
703: and col34 = 'DETAIL';
705: END IF;
706:
707:
708: /*
709: update BIX_DM_REPORT
710: set col32 = concat(l_prefix, col32)
711: where report_code = 'BIX_AGENT_CLASS_REPORT'
712: and session_id = l_session_id
713: and col34 = 'DETAIL'; */