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
4363: g_preferred_currency := 'USD';
4364: END IF;
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
4363: g_preferred_currency := 'USD';
4364: END IF;
4365:
4362: ELSE
4363: g_preferred_currency := 'USD';
4364: END IF;
4365:
4366: IF (FND_PROFILE.DEFINED('BIX_DM_CURR_CONVERSION_TYPE')) THEN
4367: g_conversion_type := FND_PROFILE.VALUE('BIX_DM_CURR_CONVERSION_TYPE');
4368: ELSE
4369: g_preferred_currency := 'Corporate';
4370: END IF;
4363: g_preferred_currency := 'USD';
4364: END IF;
4365:
4366: IF (FND_PROFILE.DEFINED('BIX_DM_CURR_CONVERSION_TYPE')) THEN
4367: g_conversion_type := FND_PROFILE.VALUE('BIX_DM_CURR_CONVERSION_TYPE');
4368: ELSE
4369: g_preferred_currency := 'Corporate';
4370: END IF;
4371:
4388: l_collect_end_date := g_collect_end_date;
4389:
4390:
4391:
4392: IF (FND_PROFILE.DEFINED('BIX_DM_DELETE_SIZE')) THEN
4393: g_commit_chunk_size := TO_NUMBER(FND_PROFILE.VALUE('BIX_DM_DELETE_SIZE'));
4394: ELSE
4395: g_commit_chunk_size := 100;
4396: END IF;
4389:
4390:
4391:
4392: IF (FND_PROFILE.DEFINED('BIX_DM_DELETE_SIZE')) THEN
4393: g_commit_chunk_size := TO_NUMBER(FND_PROFILE.VALUE('BIX_DM_DELETE_SIZE'));
4394: ELSE
4395: g_commit_chunk_size := 100;
4396: END IF;
4397:
4394: ELSE
4395: g_commit_chunk_size := 100;
4396: END IF;
4397:
4398: IF (FND_PROFILE.DEFINED('BIX_DBI_DEBUG')) THEN
4399: g_debug_flag := nvl(FND_PROFILE.VALUE('BIX_DBI_DEBUG'), 'N');
4400: ELSE
4401: g_debug_flag := 'N';
4402: END IF;
4395: g_commit_chunk_size := 100;
4396: END IF;
4397:
4398: IF (FND_PROFILE.DEFINED('BIX_DBI_DEBUG')) THEN
4399: g_debug_flag := nvl(FND_PROFILE.VALUE('BIX_DBI_DEBUG'), 'N');
4400: ELSE
4401: g_debug_flag := 'N';
4402: END IF;
4403:
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
4584: g_preferred_currency := 'USD';
4585: END IF;
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
4584: g_preferred_currency := 'USD';
4585: END IF;
4586:
4583: ELSE
4584: g_preferred_currency := 'USD';
4585: END IF;
4586:
4587: IF (FND_PROFILE.DEFINED('BIX_DM_CURR_CONVERSION_TYPE')) THEN
4588: g_conversion_type := FND_PROFILE.VALUE('BIX_DM_CURR_CONVERSION_TYPE');
4589: ELSE
4590: g_preferred_currency := 'Corporate';
4591: END IF;
4584: g_preferred_currency := 'USD';
4585: END IF;
4586:
4587: IF (FND_PROFILE.DEFINED('BIX_DM_CURR_CONVERSION_TYPE')) THEN
4588: g_conversion_type := FND_PROFILE.VALUE('BIX_DM_CURR_CONVERSION_TYPE');
4589: ELSE
4590: g_preferred_currency := 'Corporate';
4591: END IF;
4592:
4608: l_collect_start_date := g_collect_start_date;
4609: l_collect_end_date := g_collect_end_date;
4610:
4611:
4612: IF (FND_PROFILE.DEFINED('BIX_DM_DELETE_SIZE')) THEN
4613: g_commit_chunk_size := TO_NUMBER(FND_PROFILE.VALUE('BIX_DM_DELETE_SIZE'));
4614: ELSE
4615: g_commit_chunk_size := 100;
4616: END IF;
4609: l_collect_end_date := g_collect_end_date;
4610:
4611:
4612: IF (FND_PROFILE.DEFINED('BIX_DM_DELETE_SIZE')) THEN
4613: g_commit_chunk_size := TO_NUMBER(FND_PROFILE.VALUE('BIX_DM_DELETE_SIZE'));
4614: ELSE
4615: g_commit_chunk_size := 100;
4616: END IF;
4617:
4614: ELSE
4615: g_commit_chunk_size := 100;
4616: END IF;
4617:
4618: IF (FND_PROFILE.DEFINED('BIX_DBI_DEBUG')) THEN
4619: g_debug_flag := nvl(FND_PROFILE.VALUE('BIX_DBI_DEBUG'), 'N');
4620: ELSE
4621: g_debug_flag := 'N';
4622: END IF;
4615: g_commit_chunk_size := 100;
4616: END IF;
4617:
4618: IF (FND_PROFILE.DEFINED('BIX_DBI_DEBUG')) THEN
4619: g_debug_flag := nvl(FND_PROFILE.VALUE('BIX_DBI_DEBUG'), 'N');
4620: ELSE
4621: g_debug_flag := 'N';
4622: END IF;
4623:
4667: FROM DUAL;
4668:
4669: /* Get the commit size from the profile value. if the profile is not defined assume commit size as 100 */
4670:
4671: IF (FND_PROFILE.DEFINED('BIX_DM_DELETE_SIZE')) THEN
4672: g_commit_chunk_size := TO_NUMBER(FND_PROFILE.VALUE('BIX_DM_DELETE_SIZE'));
4673: ELSE
4674: g_commit_chunk_size := 100;
4675: END IF;
4668:
4669: /* Get the commit size from the profile value. if the profile is not defined assume commit size as 100 */
4670:
4671: IF (FND_PROFILE.DEFINED('BIX_DM_DELETE_SIZE')) THEN
4672: g_commit_chunk_size := TO_NUMBER(FND_PROFILE.VALUE('BIX_DM_DELETE_SIZE'));
4673: ELSE
4674: g_commit_chunk_size := 100;
4675: END IF;
4676: