eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIX_DM_AGENT_CALL_SUMMARY_PKG dependencies on BIX_DM_INTERFACE

Line 15: g_table_name VARCHAR2(100) := 'BIX_DM_INTERFACE';

11: g_collect_start_date DATE;
12: g_collect_end_date DATE;
13: g_error_mesg VARCHAR2(4000) := NULL;
14: g_status VARCHAR2(4000) := 'FAILED';
15: g_table_name VARCHAR2(100) := 'BIX_DM_INTERFACE';
16: g_proc_name VARCHAR2(4000);
17: g_min_call_begin_date DATE;
18: g_max_call_begin_date DATE;
19: g_rounded_collect_start_date DATE;

Line 1175: --DELETE_IN_CHUNKS('BIX_DM_INTERFACE',NULL,g_delete_count);

1171:
1172:
1173: -- IGOR : initialize and check for 'no rows returned'
1174:
1175: --DELETE_IN_CHUNKS('BIX_DM_INTERFACE',NULL,g_delete_count);
1176:
1177: --
1178: --Change delete to truncate to avoid performance issue
1179: --with high water mark.

Line 1182: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||g_bix_schema||'.BIX_DM_INTERFACE';

1178: --Change delete to truncate to avoid performance issue
1179: --with high water mark.
1180: --
1181:
1182: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||g_bix_schema||'.BIX_DM_INTERFACE';
1183:
1184: -- DEBUG: dbms_output.put_line('started collecting calls');
1185: --Added filter to include only call medias in following query
1186: --

Line 1647: insert into bix_dm_interface

1643:
1644:
1645: if l_activity_counter > 1 then
1646: -- insert activity row - continue here
1647: insert into bix_dm_interface
1648: (
1649: MEDIA_ID,
1650: RESOURCE_ID,
1651: --CLASSIFICATION_ID,

Line 1771: insert into bix_dm_interface

1767: END LOOP; -- end activity loop 1
1768:
1769: -- IGOR: INSERT... agent row:
1770:
1771: insert into bix_dm_interface
1772: (
1773: MEDIA_ID,
1774: RESOURCE_ID,
1775: --CLASSIFICATION_ID,

Line 2259: insert into bix_dm_interface

2255:
2256:
2257: if l_activity_counter > 1 then
2258: -- insert last activity row - continue here
2259: insert into bix_dm_interface
2260: (
2261: MEDIA_ID,
2262: RESOURCE_ID,
2263: --CLASSIFICATION_ID,

Line 2390: insert into bix_dm_interface

2386: -- DEBUG: dbms_output.put_line('inserting agent record');
2387: -- inserting last agent record:
2388:
2389: -- IGOR: INSERT...
2390: insert into bix_dm_interface
2391: (
2392: MEDIA_ID,
2393: RESOURCE_ID,
2394: --CLASSIFICATION_ID,

Line 2600: insert into bix_dm_interface

2596: --
2597:
2598: IF g_interaction_resource IS NOT NULL
2599: THEN
2600: insert into bix_dm_interface
2601: (
2602: MEDIA_ID,
2603: RESOURCE_ID,
2604: --CLASSIFICATION_ID,

Line 2773: insert into bix_dm_interface

2769: g_nonconnect_count :=0;
2770: g_other_count :=0;
2771: END IF;
2772:
2773: insert into bix_dm_interface
2774: (
2775: MEDIA_ID,
2776: RESOURCE_ID,
2777: --CLASSIFICATION_ID,

Line 3031: FROM bix_dm_interface call_stage

3027: SUM(NVL(OUT_NON_CONNECT_COUNT ,0)) OUT_NON_CONNECT_COUNT,
3028: SUM(NVL(OUT_OTHER_OUTCOME_COUNT,0)) OUT_OTHER_OUTCOME_COUNT,
3029: SUM(NVL(OUT_PREVIEW_TIME,0)) OUT_PREVIEW_TIME,
3030: SUM(NVL(OUT_CONTACT_HANDLE_TIME,0)) OUT_CONTACT_HANDLE_TIME
3031: FROM bix_dm_interface call_stage
3032: where call_stage.RESOURCE_ID is not null
3033: GROUP BY call_stage.SERVER_GROUP_ID,
3034: call_stage.CLASSIFICATION_VALUE_ID,
3035: call_stage.CAMPAIGN_ID,

Line 3055: FROM bix_dm_interface;

3051:
3052: /* Get the count of rows from the */
3053:
3054: SELECT count(*) INTO l_num_calls
3055: FROM bix_dm_interface;
3056:
3057: if (l_num_calls > 0) THEN
3058:
3059: IF (g_debug_flag = 'Y') THEN

Line 3657: FROM bix_dm_interface call_stage

3653: SUM(NVL(OUT_NON_CONNECT_COUNT,0)) OUT_NON_CONNECT_COUNT,
3654: SUM(NVL(OUT_OTHER_OUTCOME_COUNT,0)) OUT_OTHER_OUTCOME_COUNT,
3655: SUM(NVL(OUT_CONTACT_HANDLE_TIME,0)) OUT_CONTACT_HANDLE_TIME,
3656: SUM(NVL(DECODE(ROW_TYPE,'C',OUT_PREVIEW_TIME,0),0)) OUT_PREVIEW_TIME --do only "C" rowtype
3657: FROM bix_dm_interface call_stage
3658: GROUP BY call_stage.SERVER_GROUP_ID,
3659: call_stage.CLASSIFICATION_VALUE_ID,
3660: call_stage.DNIS,
3661: call_stage.campaign_id,

Line 3680: FROM bix_dm_interface;

3676:
3677: /* Get the count of rows from the */
3678:
3679: SELECT count(*) INTO l_num_calls
3680: FROM bix_dm_interface;
3681:
3682: if (l_num_calls > 0) THEN
3683:
3684: IF (g_debug_flag = 'Y') THEN

Line 3930: FROM bix_dm_interface call_stage,

3926: clook.connect_flag CONNECT_FLAG,
3927: clook.contact_flag CONTACT_FLAG,
3928: rlook.positive_response_flag POSITIVE_RESPONSE_FLAG,
3929: sum(call_stage.OUT_CALLS_DIALED) NUMBER_OF_CALLS
3930: FROM bix_dm_interface call_stage,
3931: bix_dm_connect_lookups clook,
3932: bix_dm_response_lookups rlook
3933: WHERE clook.outcome_id (+) = call_stage.outcome_id
3934: --AND rlook.outcome_id (+) = call_stage.outcome_id

Line 3969: FROM bix_dm_interface;

3965:
3966: /* Get the count of rows from the */
3967:
3968: SELECT count(*) INTO l_num_calls
3969: FROM bix_dm_interface;
3970:
3971: IF (g_debug_flag = 'Y') THEN
3972: write_log('No of rows in injterface table is ' ||l_num_calls, g_proc_name);
3973: END IF;

Line 4209: FROM bix_dm_interface;

4205:
4206: /* Get the count of rows from the */
4207:
4208: SELECT count(*) INTO l_num_calls
4209: FROM bix_dm_interface;
4210:
4211: if (l_num_calls > 0) THEN
4212:
4213: IF (g_debug_flag = 'Y') THEN

Line 4328: | 1. GET_CALLS : Which populates the BIX_DM_INTERFACE staging table |

4324:
4325: /*========================================================================================================+
4326: | COLLECT_CALLS_SUMMARY procedure is main procedure calls other procedures to collect the data |
4327: | The following procedures are invoked from this procedure to collect the data. |
4328: | 1. GET_CALLS : Which populates the BIX_DM_INTERFACE staging table |
4329: | 2. AGENT_SUM : Summarizes agent data and inserts it into the BIX_DM_AGENT_SUM table |
4330: | 3. GROUP_SUM : Summarizes agent group data and inserts it into the BIX_DM_GROUP_SUM table|
4331: | 4. BIX_POP_AO_SUM_PKG.populate: Summarizes adv. outbound data and inserts it into the BIX_DM_AO_SUM tbl |
4332: | 5. CALL_SUM : Summarizes call data and inserts it into the BIX_DM_CALL_SUM table |

Line 4334: | The procedure 1 populates BIX_DM_INTERFACE staging table, the others use the staging table to populate |

4330: | 3. GROUP_SUM : Summarizes agent group data and inserts it into the BIX_DM_GROUP_SUM table|
4331: | 4. BIX_POP_AO_SUM_PKG.populate: Summarizes adv. outbound data and inserts it into the BIX_DM_AO_SUM tbl |
4332: | 5. CALL_SUM : Summarizes call data and inserts it into the BIX_DM_CALL_SUM table |
4333: | |
4334: | The procedure 1 populates BIX_DM_INTERFACE staging table, the others use the staging table to populate |
4335: | the other tables. After each procedure the insert_log procedure is called to insert the table data into |
4336: | the log table BIX_DM_COLLECT_LOG. |
4337: | There are two versions of this procedure, one called from the concurrent manager and the other callable |
4338: | from sqlplus for debugging purposses. The version below is the one callable from sqlplus. |

Line 4357: g_table_name := 'BIX_DM_INTERFACE';

4353: g_delete_count := 0;
4354: g_program_start_date := SYSDATE;
4355: g_error_mesg := NULL;
4356: g_status := 'FAILED';
4357: g_table_name := 'BIX_DM_INTERFACE';
4358: g_proc_name := 'BIX_DM_AGENT_CALL_SUMMARY_PKG.COLLECT_CALLS_SUMMARY';
4359:
4360: IF (FND_PROFILE.DEFINED('BIX_DM_PREFERRED_CURRENCY')) THEN
4361: g_preferred_currency := FND_PROFILE.VALUE('BIX_DM_PREFERRED_CURRENCY');

Line 4451: /* Procedure collect calls from OLTP to the temporary table BIX_DM_INTERFACE: */

4447: INTO g_rounded_collect_end_date
4448: FROM DUAL;
4449:
4450:
4451: /* Procedure collect calls from OLTP to the temporary table BIX_DM_INTERFACE: */
4452: GET_CALLS;
4453: g_status := 'SUCCESS';
4454: g_table_name := 'BIX_DM_INTERFACE';
4455: insert_log;

Line 4454: g_table_name := 'BIX_DM_INTERFACE';

4450:
4451: /* Procedure collect calls from OLTP to the temporary table BIX_DM_INTERFACE: */
4452: GET_CALLS;
4453: g_status := 'SUCCESS';
4454: g_table_name := 'BIX_DM_INTERFACE';
4455: insert_log;
4456:
4457: /* Procedure collects all the calls information for the AGENT data */
4458:

Line 4510: /* Cleanup: Delete all from the BIX_DM_INTERFACE table */

4506: g_status := 'SUCCESS';
4507: g_table_name := 'BIX_DM_GROUP_OUTCOME_SUM';
4508: insert_log;
4509:
4510: /* Cleanup: Delete all from the BIX_DM_INTERFACE table */
4511:
4512: -- DELETE_IN_CHUNKS('BIX_DM_INTERFACE',NULL,g_delete_count);
4513: -- g_insert_count := 0;
4514: -- g_status := 'SUCCESS';

Line 4512: -- DELETE_IN_CHUNKS('BIX_DM_INTERFACE',NULL,g_delete_count);

4508: insert_log;
4509:
4510: /* Cleanup: Delete all from the BIX_DM_INTERFACE table */
4511:
4512: -- DELETE_IN_CHUNKS('BIX_DM_INTERFACE',NULL,g_delete_count);
4513: -- g_insert_count := 0;
4514: -- g_status := 'SUCCESS';
4515: -- g_table_name := 'BIX_DM_INTERFACE';
4516: -- insert_log;

Line 4515: -- g_table_name := 'BIX_DM_INTERFACE';

4511:
4512: -- DELETE_IN_CHUNKS('BIX_DM_INTERFACE',NULL,g_delete_count);
4513: -- g_insert_count := 0;
4514: -- g_status := 'SUCCESS';
4515: -- g_table_name := 'BIX_DM_INTERFACE';
4516: -- insert_log;
4517:
4518: g_collect_start_date := g_collect_end_date;
4519:

Line 4548: | 1. GET_CALLS : Which populates the BIX_DM_INTERFACE staging table |

4544:
4545: /*========================================================================================================+
4546: | COLLECT_CALLS_SUMMARY procedure is main procedure calls other procedures to collect the data |
4547: | The following procedures are invoked from this procedure to collect the data. |
4548: | 1. GET_CALLS : Which populates the BIX_DM_INTERFACE staging table |
4549: | 2. AGENT_SUM : Summarizes agent data and inserts it into the BIX_DM_AGENT_SUM table |
4550: | 3. GROUP_SUM : Summarizes agent group data and inserts it into the BIX_DM_GROUP_SUM table|
4551: | 4. BIX_POP_AO_SUM_PKG.populate: Summarizes adv. outbound data and inserts it into the BIX_DM_AO_SUM tbl |
4552: | 5. CALL_SUM : Summarizes call data and inserts it into the BIX_DM_CALL_SUM table |

Line 4554: | The procedure 1 populates BIX_DM_INTERFACE staging table, the others use the staging table to populate |

4550: | 3. GROUP_SUM : Summarizes agent group data and inserts it into the BIX_DM_GROUP_SUM table|
4551: | 4. BIX_POP_AO_SUM_PKG.populate: Summarizes adv. outbound data and inserts it into the BIX_DM_AO_SUM tbl |
4552: | 5. CALL_SUM : Summarizes call data and inserts it into the BIX_DM_CALL_SUM table |
4553: | |
4554: | The procedure 1 populates BIX_DM_INTERFACE staging table, the others use the staging table to populate |
4555: | the other tables. After each procedure the insert_log procedure is called to insert the table data into |
4556: | the log table BIX_DM_COLLECT_LOG. |
4557: | There are two versions of this procedure, one called from the concurrent manager and the other callable |
4558: | from sqlplus for debugging purposses. The version below is the one called from the concurrent manager. |

Line 4578: g_table_name := 'BIX_DM_INTERFACE';

4574: g_delete_count := 0;
4575: g_program_start_date := SYSDATE;
4576: g_error_mesg := NULL;
4577: g_status := 'FAILED';
4578: g_table_name := 'BIX_DM_INTERFACE';
4579: g_proc_name := 'BIX_DM_AGENT_CALL_SUMMARY_PKG.COLLECT_CALLS_SUMMARY';
4580:
4581: IF (FND_PROFILE.DEFINED('BIX_DM_PREFERRED_CURRENCY')) THEN
4582: g_preferred_currency := FND_PROFILE.VALUE('BIX_DM_PREFERRED_CURRENCY');

Line 4677: /* Procedure collect calls from OLTP to the temporary table BIX_DM_INTERFACE: */

4673: ELSE
4674: g_commit_chunk_size := 100;
4675: END IF;
4676:
4677: /* Procedure collect calls from OLTP to the temporary table BIX_DM_INTERFACE: */
4678: GET_CALLS;
4679: g_status := 'SUCCESS';
4680: g_table_name := 'BIX_DM_INTERFACE';
4681: insert_log;

Line 4680: g_table_name := 'BIX_DM_INTERFACE';

4676:
4677: /* Procedure collect calls from OLTP to the temporary table BIX_DM_INTERFACE: */
4678: GET_CALLS;
4679: g_status := 'SUCCESS';
4680: g_table_name := 'BIX_DM_INTERFACE';
4681: insert_log;
4682:
4683: /* Procedure collects all the calls information for the AGENT data */
4684: SUM_AGENT;

Line 4735: /* Cleanup: Delete all from the BIX_DM_INTERFACE table */

4731: g_status := 'SUCCESS';
4732: g_table_name := 'BIX_DM_GROUP_OUTCOME_SUM';
4733: insert_log;
4734:
4735: /* Cleanup: Delete all from the BIX_DM_INTERFACE table */
4736:
4737: --DELETE_IN_CHUNKS('BIX_DM_INTERFACE',NULL,g_delete_count);
4738: g_insert_count := 0;
4739: g_status := 'SUCCESS';

Line 4737: --DELETE_IN_CHUNKS('BIX_DM_INTERFACE',NULL,g_delete_count);

4733: insert_log;
4734:
4735: /* Cleanup: Delete all from the BIX_DM_INTERFACE table */
4736:
4737: --DELETE_IN_CHUNKS('BIX_DM_INTERFACE',NULL,g_delete_count);
4738: g_insert_count := 0;
4739: g_status := 'SUCCESS';
4740: g_table_name := 'BIX_DM_INTERFACE';
4741: insert_log;

Line 4740: g_table_name := 'BIX_DM_INTERFACE';

4736:
4737: --DELETE_IN_CHUNKS('BIX_DM_INTERFACE',NULL,g_delete_count);
4738: g_insert_count := 0;
4739: g_status := 'SUCCESS';
4740: g_table_name := 'BIX_DM_INTERFACE';
4741: insert_log;
4742:
4743:
4744: