APPS.BIX_CALLS_TYPE_RPT_PKG dependencies on BIX_DM_REPORT

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

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

Line 173: /* detail rows corresponding o the classification in the table bix_dm_report */

169: RAISE;
170: END form_sqlstmt;
171:
172: /* This procedure forms and executes the SQL statement that inserts the */
173: /* detail rows corresponding o the classification in the table bix_dm_report */
174: PROCEDURE insert_detail_rows(p_classification_id IN NUMBER)
175: IS
176: BEGIN
177:

Line 189: /* total row corresponding o the classification in the table bix_dm_report */

185: RAISE;
186: END insert_detail_rows;
187:
188: /* This procedure forms and executes the SQL statement that inserts the */
189: /* total row corresponding o the classification in the table bix_dm_report */
190: PROCEDURE insert_total_rows(p_classification_id IN NUMBER)
191: IS
192: BEGIN
193:

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

273: SELECT icx_sec.g_session_id
274: INTO g_session_id
275: FROM dual;
276:
277: /* Delete the rows from the table bix_dm_report for the current icx session and report */
278: /* so that we donot display the leftover rows from the previous execution of the report */
279: DELETE bix_dm_report
280: WHERE report_code = 'BIX_CALLS_TYPE_RPT'
281: AND session_id = g_session_id;

Line 279: DELETE bix_dm_report

275: FROM dual;
276:
277: /* Delete the rows from the table bix_dm_report for the current icx session and report */
278: /* so that we donot display the leftover rows from the previous execution of the report */
279: DELETE bix_dm_report
280: WHERE report_code = 'BIX_CALLS_TYPE_RPT'
281: AND session_id = g_session_id;
282:
283: /* Fetch the sysdate into variable g_sysdate */

Line 329: UPDATE bix_dm_report

325: l_classification_id := to_number(substr(g_classification_parent, 1, length(g_classification_parent)-1));
326:
327: /* Update the temp table so that next time the user clicked on the */
328: /* same classification we donot display the detail rows again */
329: UPDATE bix_dm_report
330: SET col1 = to_char(l_classification_id) || 'n'
331: WHERE col1 = to_char(l_classification_id) || 'y'
332: AND report_code = 'BIX_CALLS_TYPE_RPT'
333: AND session_id = g_session_id;