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_AGENT_CALL_SUMMARY_PKG

Line 1: PACKAGE BODY BIX_DM_AGENT_CALL_SUMMARY_PKG AS

1: PACKAGE BODY BIX_DM_AGENT_CALL_SUMMARY_PKG AS
2: /*$Header: bixxcalb.pls 115.109 2004/04/13 11:36:01 suray ship $ */
3:
4: g_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID();
5: g_program_appl_id NUMBER := FND_GLOBAL.PROG_APPL_ID();

Line 217: g_proc_name := 'BIX_DM_AGENT_CALL_SUMMARY_PKG.DELETE_IN_CHUNKS';

213: rows_deleted := l_rows_deleted;
214:
215: EXCEPTION
216: when e_invalid_condition then
217: g_proc_name := 'BIX_DM_AGENT_CALL_SUMMARY_PKG.DELETE_IN_CHUNKS';
218: g_error_mesg := 'Invalid IF condition in delete ';
219: raise;
220: when e_statement_too_long then
221: g_error_mesg := ' SQL Statement too long (4000 char or more). ';

Line 223: g_proc_name := 'BIX_DM_AGENT_CALL_SUMMARY_PKG.DELETE_IN_CHUNKS';

219: raise;
220: when e_statement_too_long then
221: g_error_mesg := ' SQL Statement too long (4000 char or more). ';
222: when others then
223: g_proc_name := 'BIX_DM_AGENT_CALL_SUMMARY_PKG.DELETE_IN_CHUNKS';
224: g_error_mesg := g_proc_name || g_error_mesg ||' : '|| sqlerrm;
225: raise;
226: end;
227:

Line 3060: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'BIX_DM_AGENT_CALL_SUMMARY_PKG.AGENT_SUM: '||' Start Deleting rows in BIM_DM_AGENT_SUM Table', g_proc_name);

3056:
3057: if (l_num_calls > 0) THEN
3058:
3059: IF (g_debug_flag = 'Y') THEN
3060: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'BIX_DM_AGENT_CALL_SUMMARY_PKG.AGENT_SUM: '||' Start Deleting rows in BIM_DM_AGENT_SUM Table', g_proc_name);
3061: END IF;
3062:
3063: -- Delete the rows from summary table for the date range specified
3064:

Line 3083: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'BIX_DM_AGENT_CALL_SUMMARY_PKG.COLLECT_CALLS: '||' Finished Deleting rows in BIX_DM_AGENT_SUM table: ' || 'Row Count:' || g_delete_count, g_proc_name);

3079: COMMIT;
3080:
3081: IF (g_debug_flag = 'Y') THEN
3082:
3083: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'BIX_DM_AGENT_CALL_SUMMARY_PKG.COLLECT_CALLS: '||' Finished Deleting rows in BIX_DM_AGENT_SUM table: ' || 'Row Count:' || g_delete_count, g_proc_name);
3084:
3085: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'BIX_DM_AGENT_CALL_SUMMARY_PKG.SUM_AGENT: '||' Start inserting rows into BIX_DM_AGENT_SUM table: ', g_proc_name);
3086:
3087: END IF;

Line 3085: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'BIX_DM_AGENT_CALL_SUMMARY_PKG.SUM_AGENT: '||' Start inserting rows into BIX_DM_AGENT_SUM table: ', g_proc_name);

3081: IF (g_debug_flag = 'Y') THEN
3082:
3083: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'BIX_DM_AGENT_CALL_SUMMARY_PKG.COLLECT_CALLS: '||' Finished Deleting rows in BIX_DM_AGENT_SUM table: ' || 'Row Count:' || g_delete_count, g_proc_name);
3084:
3085: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'BIX_DM_AGENT_CALL_SUMMARY_PKG.SUM_AGENT: '||' Start inserting rows into BIX_DM_AGENT_SUM table: ', g_proc_name);
3086:
3087: END IF;
3088:
3089:

Line 3247: g_proc_name := 'BIX_DM_AGENT_CALL_SUMMARY_PKG.SUM_AGENT';

3243: IF (g_debug_flag = 'Y') THEN
3244: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||' BIX_DM_AGENT_SUMMARY_PKG.SUM_AGENT: '|| ' Failed to Rolled back data in BIX_DM_AGENT_SUM table ', g_proc_name);
3245: END IF;
3246:
3247: g_proc_name := 'BIX_DM_AGENT_CALL_SUMMARY_PKG.SUM_AGENT';
3248: g_error_mesg := g_proc_name ||' : '|| sqlerrm;
3249: RAISE;
3250:
3251: END SUM_AGENT;

Line 3381: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'BIX_DM_AGENT_CALL_SUMMARY_PKG.GROUP_SUM: '||' Start Deleting rows in BIM_DM_GROUP_SUM Table', g_proc_name);

3377:
3378: if (l_num_calls > 0) THEN
3379:
3380: IF (g_debug_flag = 'Y') THEN
3381: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'BIX_DM_AGENT_CALL_SUMMARY_PKG.GROUP_SUM: '||' Start Deleting rows in BIM_DM_GROUP_SUM Table', g_proc_name);
3382: END IF;
3383:
3384: -- Delete the rows from summary table for the date range specified
3385:

Line 3404: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'BIX_DM_AGENT_CALL_SUMMARY_PKG.SUM_GROUP: '||' Finished Deleting rows in BIX_DM_GROUP_SUM table: ' || 'Row Count:' || g_delete_count, g_proc_name);

3400: COMMIT;
3401:
3402: IF (g_debug_flag = 'Y') THEN
3403:
3404: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'BIX_DM_AGENT_CALL_SUMMARY_PKG.SUM_GROUP: '||' Finished Deleting rows in BIX_DM_GROUP_SUM table: ' || 'Row Count:' || g_delete_count, g_proc_name);
3405:
3406: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'BIX_DM_AGENT_CALL_SUMMARY_PKG.AGENT_SUM: '||' Start inserting rows into BIX_DM_AGENT_SUM table: ', g_proc_name);
3407:
3408: END IF;

Line 3406: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'BIX_DM_AGENT_CALL_SUMMARY_PKG.AGENT_SUM: '||' Start inserting rows into BIX_DM_AGENT_SUM table: ', g_proc_name);

3402: IF (g_debug_flag = 'Y') THEN
3403:
3404: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'BIX_DM_AGENT_CALL_SUMMARY_PKG.SUM_GROUP: '||' Finished Deleting rows in BIX_DM_GROUP_SUM table: ' || 'Row Count:' || g_delete_count, g_proc_name);
3405:
3406: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'BIX_DM_AGENT_CALL_SUMMARY_PKG.AGENT_SUM: '||' Start inserting rows into BIX_DM_AGENT_SUM table: ', g_proc_name);
3407:
3408: END IF;
3409:
3410:

Line 3570: g_proc_name := 'BIX_DM_AGENT_CALL_SUMMARY_PKG.SUM_GROUP';

3566: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||' BIX_DM_AGENT_SUMMARY_PKG.SUM_GROUP: '|| ' Failed to Rolled back data in BIX_DM_GROUP_SUM table ', g_proc_name);
3567:
3568: END IF;
3569:
3570: g_proc_name := 'BIX_DM_AGENT_CALL_SUMMARY_PKG.SUM_GROUP';
3571: g_error_mesg := g_proc_name ||' : '|| sqlerrm;
3572: RAISE;
3573:
3574: END SUM_GROUP;

Line 3685: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'BIX_DM_AGENT_CALL_SUMMARY_PKG.CALL_SUM: '||' Start Deleting rows in BIM_DM_CALL_SUM Table', g_proc_name);

3681:
3682: if (l_num_calls > 0) THEN
3683:
3684: IF (g_debug_flag = 'Y') THEN
3685: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'BIX_DM_AGENT_CALL_SUMMARY_PKG.CALL_SUM: '||' Start Deleting rows in BIM_DM_CALL_SUM Table', g_proc_name);
3686: END IF;
3687:
3688: -- Delete the rows from summary table for the date range specified
3689:

Line 3707: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'BIX_DM_AGENT_CALL_SUMMARY_PKG.CALL_SUM: '||' Finished Deleting rows in BIX_DM_CALL_SUM table: ' || 'Row Count:' || g_delete_count, g_proc_name);

3703:
3704: COMMIT;
3705:
3706: IF (g_debug_flag = 'Y') THEN
3707: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'BIX_DM_AGENT_CALL_SUMMARY_PKG.CALL_SUM: '||' Finished Deleting rows in BIX_DM_CALL_SUM table: ' || 'Row Count:' || g_delete_count, g_proc_name);
3708:
3709: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'BIX_DM_AGENT_CALL_SUMMARY_PKG.SUM_CALL: '||' Start inserting rows into BIX_DM_CALL_SUM table: ', g_proc_name);
3710: END IF;
3711:

Line 3709: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'BIX_DM_AGENT_CALL_SUMMARY_PKG.SUM_CALL: '||' Start inserting rows into BIX_DM_CALL_SUM table: ', g_proc_name);

3705:
3706: IF (g_debug_flag = 'Y') THEN
3707: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'BIX_DM_AGENT_CALL_SUMMARY_PKG.CALL_SUM: '||' Finished Deleting rows in BIX_DM_CALL_SUM table: ' || 'Row Count:' || g_delete_count, g_proc_name);
3708:
3709: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'BIX_DM_AGENT_CALL_SUMMARY_PKG.SUM_CALL: '||' Start inserting rows into BIX_DM_CALL_SUM table: ', g_proc_name);
3710: END IF;
3711:
3712:
3713: for call_row in call_data LOOP

Line 3897: g_proc_name := 'BIX_DM_AGENT_CALL_SUMMARY_PKG.SUM_CALL';

3893: IF (g_debug_flag = 'Y') THEN
3894: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||' BIX_DM_AGENT_SUMMARY_PKG.SUM_CALL: '|| ' Failed to Rolled back data in BIX_DM_CALL_SUM table ', g_proc_name);
3895: END IF;
3896:
3897: g_proc_name := 'BIX_DM_AGENT_CALL_SUMMARY_PKG.SUM_CALL';
3898: g_error_mesg := g_proc_name ||' : '|| sqlerrm;
3899: RAISE;
3900:
3901: END SUM_CALL;

Line 3962: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'BIX_DM_AGENT_CALL_SUMMARY_PKG.SUM_AGENT_OUTCOME: Entered procedure', g_proc_name);

3958: g_insert_count := 0;
3959: g_delete_count := 0;
3960:
3961: IF (g_debug_flag = 'Y') THEN
3962: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'BIX_DM_AGENT_CALL_SUMMARY_PKG.SUM_AGENT_OUTCOME: Entered procedure', g_proc_name);
3963: END IF;
3964:
3965:
3966: /* Get the count of rows from the */

Line 3978: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'BIX_DM_AGENT_CALL_SUMMARY_PKG.SUM_AGENT_OUTCOME: '||' Start Deleting rows in BIM_DM_AGENT_OUTCOME_SUM Table', g_proc_name);

3974:
3975: if (l_num_calls > 0) THEN
3976:
3977: IF (g_debug_flag = 'Y') THEN
3978: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'BIX_DM_AGENT_CALL_SUMMARY_PKG.SUM_AGENT_OUTCOME: '||' Start Deleting rows in BIM_DM_AGENT_OUTCOME_SUM Table', g_proc_name);
3979: END IF;
3980:
3981: -- Delete the rows from summary table for the date range specified
3982:

Line 4001: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'BIX_DM_AGENT_CALL_SUMMARY_PKG.SUM_AGENT_OUTCOME: '||' Finished Deleting rows in BIX_DM_AGENT_OUTCOME_SUM table: ' || 'Row Count:' || g_delete_count, g_proc_name);

3997: COMMIT;
3998:
3999: IF (g_debug_flag = 'Y') THEN
4000:
4001: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'BIX_DM_AGENT_CALL_SUMMARY_PKG.SUM_AGENT_OUTCOME: '||' Finished Deleting rows in BIX_DM_AGENT_OUTCOME_SUM table: ' || 'Row Count:' || g_delete_count, g_proc_name);
4002:
4003: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'BIX_DM_AGENT_CALL_SUMMARY_PKG.SUM_AGENT_OUTCOME: '||' Start inserting rows into BIX_DM_AGENT_OUTCOME_SUM table: ', g_proc_name);
4004:
4005: END IF;

Line 4003: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'BIX_DM_AGENT_CALL_SUMMARY_PKG.SUM_AGENT_OUTCOME: '||' Start inserting rows into BIX_DM_AGENT_OUTCOME_SUM table: ', g_proc_name);

3999: IF (g_debug_flag = 'Y') THEN
4000:
4001: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'BIX_DM_AGENT_CALL_SUMMARY_PKG.SUM_AGENT_OUTCOME: '||' Finished Deleting rows in BIX_DM_AGENT_OUTCOME_SUM table: ' || 'Row Count:' || g_delete_count, g_proc_name);
4002:
4003: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'BIX_DM_AGENT_CALL_SUMMARY_PKG.SUM_AGENT_OUTCOME: '||' Start inserting rows into BIX_DM_AGENT_OUTCOME_SUM table: ', g_proc_name);
4004:
4005: END IF;
4006:
4007:

Line 4068: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'BIX_DM_AGENT_CALL_SUMMARY_PKG.SUM_AGENT_OUTCOME: Ended procedure', g_proc_name);

4064: end if; -- if there are rows in the interface table
4065:
4066: IF (g_debug_flag = 'Y') THEN
4067:
4068: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'BIX_DM_AGENT_CALL_SUMMARY_PKG.SUM_AGENT_OUTCOME: Ended procedure', g_proc_name);
4069:
4070: END IF;
4071:
4072: EXCEPTION

Line 4076: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'BIX_DM_AGENT_CALL_SUMMARY_PKG.SUM_AGENT_OUTCOME: Exception ', g_proc_name);

4072: EXCEPTION
4073: WHEN OTHERS THEN
4074:
4075: IF (g_debug_flag = 'Y') THEN
4076: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'BIX_DM_AGENT_CALL_SUMMARY_PKG.SUM_AGENT_OUTCOME: Exception ', g_proc_name);
4077: END IF;
4078:
4079: g_proc_name := 'BIX_DM_AGENT_CALL_SUMMARY_PKG.SUM_AGENT_OUTCOME';
4080: g_error_mesg := g_proc_name ||' : '|| sqlerrm;

Line 4079: g_proc_name := 'BIX_DM_AGENT_CALL_SUMMARY_PKG.SUM_AGENT_OUTCOME';

4075: IF (g_debug_flag = 'Y') THEN
4076: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'BIX_DM_AGENT_CALL_SUMMARY_PKG.SUM_AGENT_OUTCOME: Exception ', g_proc_name);
4077: END IF;
4078:
4079: g_proc_name := 'BIX_DM_AGENT_CALL_SUMMARY_PKG.SUM_AGENT_OUTCOME';
4080: g_error_mesg := g_proc_name ||' : '|| sqlerrm;
4081: RAISE;
4082:
4083: END SUM_AGENT_OUTCOME;

Line 4214: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'BIX_DM_AGENT_CALL_SUMMARY_PKG.SUM_GROUP_OUTCOME: '||' Start Deleting rows in BIM_DM_GROUP_OUTCOME_SUM Table', g_proc_name);

4210:
4211: if (l_num_calls > 0) THEN
4212:
4213: IF (g_debug_flag = 'Y') THEN
4214: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'BIX_DM_AGENT_CALL_SUMMARY_PKG.SUM_GROUP_OUTCOME: '||' Start Deleting rows in BIM_DM_GROUP_OUTCOME_SUM Table', g_proc_name);
4215: END IF;
4216:
4217: -- Delete the rows from summary table for the date range specified
4218:

Line 4236: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'BIX_DM_AGENT_CALL_SUMMARY_PKG.SUM_GROUP_OUTCOME: '||' Finished Deleting rows in BIX_DM_GROUP_OUTCOME_SUM table: ' || 'Row Count:' || g_delete_count, g_proc_name);

4232:
4233: COMMIT;
4234:
4235: IF (g_debug_flag = 'Y') THEN
4236: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'BIX_DM_AGENT_CALL_SUMMARY_PKG.SUM_GROUP_OUTCOME: '||' Finished Deleting rows in BIX_DM_GROUP_OUTCOME_SUM table: ' || 'Row Count:' || g_delete_count, g_proc_name);
4237:
4238: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'BIX_DM_AGENT_CALL_SUMMARY_PKG.SUM_GROUP_OUTCOME: '||' Start inserting rows into BIX_DM_GROUP_OUTCOME_SUM table: ', g_proc_name);
4239: END IF;
4240:

Line 4238: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'BIX_DM_AGENT_CALL_SUMMARY_PKG.SUM_GROUP_OUTCOME: '||' Start inserting rows into BIX_DM_GROUP_OUTCOME_SUM table: ', g_proc_name);

4234:
4235: IF (g_debug_flag = 'Y') THEN
4236: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'BIX_DM_AGENT_CALL_SUMMARY_PKG.SUM_GROUP_OUTCOME: '||' Finished Deleting rows in BIX_DM_GROUP_OUTCOME_SUM table: ' || 'Row Count:' || g_delete_count, g_proc_name);
4237:
4238: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'BIX_DM_AGENT_CALL_SUMMARY_PKG.SUM_GROUP_OUTCOME: '||' Start inserting rows into BIX_DM_GROUP_OUTCOME_SUM table: ', g_proc_name);
4239: END IF;
4240:
4241:
4242: for outcome_row in outcome_data LOOP

Line 4307: g_proc_name := 'BIX_DM_AGENT_CALL_SUMMARY_PKG.SUM_GROUP_OUTCOME';

4303: IF (g_debug_flag = 'Y') THEN
4304: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||' BIX_DM_AGENT_SUMMARY_PKG.SUM_GROUP_OUTCOME: '|| ' Failed to Roll back data in BIX_DM_GROUP_OUTCOME_SUM table ', g_proc_name);
4305: END IF;
4306:
4307: g_proc_name := 'BIX_DM_AGENT_CALL_SUMMARY_PKG.SUM_GROUP_OUTCOME';
4308: g_error_mesg := g_proc_name ||' : '|| sqlerrm;
4309: RAISE;
4310:
4311: END SUM_GROUP_OUTCOME;

Line 4358: g_proc_name := 'BIX_DM_AGENT_CALL_SUMMARY_PKG.COLLECT_CALLS_SUMMARY';

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');
4362: ELSE

Line 4579: g_proc_name := 'BIX_DM_AGENT_CALL_SUMMARY_PKG.COLLECT_CALLS_SUMMARY';

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');
4583: ELSE

Line 4781: END BIX_DM_AGENT_CALL_SUMMARY_PKG;

4777:
4778: insert_log;
4779: END COLLECT_CALLS_SUMMARY;
4780:
4781: END BIX_DM_AGENT_CALL_SUMMARY_PKG;