APPS.BIX_KPI_CLS_RPT_PKG dependencies on BIX_DM_REPORT

Line 69: g_sqlstmt := 'INSERT /*+ PARALLEL(tr,2) */ INTO BIX_DM_REPORT tr

65:
66: /* Form the SQL string to insert the rows into the temp table.
67: For null classifications, 'z99' was chosen as the default classifcation
68: id so that it always appears as the last row in the report */
69: g_sqlstmt := 'INSERT /*+ PARALLEL(tr,2) */ INTO BIX_DM_REPORT tr
70: ( session_id, report_code, col1, col2, col3, col4, col6, col8,
71: col10, col12, col14, col16, col18, col20, col22, col24,
72: col26, col28, col30 )
73: (SELECT /*+ PARALLEL(a,2) */ :session_id, ''BIX_KPI_CLS_RPT'' ,

Line 385: DELETE from bix_dm_report

381:
382: l_session_id := bix_util_pkg.get_icx_session_id;
383:
384: /* Delete the table for the current icx session and report */
385: DELETE from bix_dm_report
386: WHERE report_code = 'BIX_KPI_CLS_RPT'
387: AND session_id = l_session_id;
388:
389: /* Get the BIX global currency */

Line 445: UPDATE bix_dm_report

441: classification_id = -999 as classification_id is a number column */
442: IF l_classification_parent = 'z99y'
443: THEN
444: l_classification_id := -999;
445: UPDATE bix_dm_report
446: SET col1 = 'z99n'
447: WHERE col1 = 'z99y'
448: AND report_code = 'BIX_KPI_CLS_RPT'
449: AND session_id = l_session_id;

Line 453: UPDATE bix_dm_report

449: AND session_id = l_session_id;
450: ELSE
451: l_classification_id := to_number( substr(
452: l_classification_parent, 1, length(l_classification_parent)-1));
453: UPDATE bix_dm_report
454: SET col1 = to_char(l_classification_id) || 'n'
455: WHERE col1 = to_char(l_classification_id) || 'y'
456: AND report_code = 'BIX_KPI_CLS_RPT'
457: AND session_id = l_session_id;