APPS.BIX_CALLS_HANDLED_BIN_PKG dependencies on BIX_DM_BIN

Line 18: /* Delete the rows from table bix_dm_bin for the current icx session and bin */

14: SELECT icx_sec.g_session_id
15: INTO l_session_id
16: FROM dual;
17:
18: /* Delete the rows from table bix_dm_bin for the current icx session and bin */
19: DELETE bix_dm_bin
20: WHERE bin_code = 'BIX_CALLS_HANDLED_BIN'
21: AND session_id = l_session_id;
22:

Line 19: DELETE bix_dm_bin

15: INTO l_session_id
16: FROM dual;
17:
18: /* Delete the rows from table bix_dm_bin for the current icx session and bin */
19: DELETE bix_dm_bin
20: WHERE bin_code = 'BIX_CALLS_HANDLED_BIN'
21: AND session_id = l_session_id;
22:
23: /* Get the default Agent Group of the Agent executing the report */

Line 52: /* l_default_group_id and insert them in the table bix_dm_bin */

48: INTO l_reporting_date
49: FROM bix_dm_agent_call_sum;
50:
51: /* Fetch the records of all the agents belonging to the group */
52: /* l_default_group_id and insert them in the table bix_dm_bin */
53: INSERT /*+ PARALLEL(tb,2) */ INTO bix_dm_bin tb (
54: session_id
55: , bin_code
56: , col1

Line 53: INSERT /*+ PARALLEL(tb,2) */ INTO bix_dm_bin tb (

49: FROM bix_dm_agent_call_sum;
50:
51: /* Fetch the records of all the agents belonging to the group */
52: /* l_default_group_id and insert them in the table bix_dm_bin */
53: INSERT /*+ PARALLEL(tb,2) */ INTO bix_dm_bin tb (
54: session_id
55: , bin_code
56: , col1
57: , col2

Line 81: /* l_default_group_id and insert them in the table bix_dm_bin */

77: AND bac.period_start_date = l_reporting_date
78: GROUP BY rsc.source_name );
79:
80: /* Fetch the records of all the agent groups belonging to the group */
81: /* l_default_group_id and insert them in the table bix_dm_bin */
82: INSERT /*+ PARALLEL(tb,2) */ INTO bix_dm_bin tb (
83: session_id
84: , bin_code
85: , col1

Line 82: INSERT /*+ PARALLEL(tb,2) */ INTO bix_dm_bin tb (

78: GROUP BY rsc.source_name );
79:
80: /* Fetch the records of all the agent groups belonging to the group */
81: /* l_default_group_id and insert them in the table bix_dm_bin */
82: INSERT /*+ PARALLEL(tb,2) */ INTO bix_dm_bin tb (
83: session_id
84: , bin_code
85: , col1
86: , col2