DBA Data[Home] [Help]

APPS.BIX_DM_AGENT_CALL_SUMMARY_PKG dependencies on FND_PROFILE

Line 4360: IF (FND_PROFILE.DEFINED('BIX_DM_PREFERRED_CURRENCY')) THEN

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;

Line 4361: g_preferred_currency := FND_PROFILE.VALUE('BIX_DM_PREFERRED_CURRENCY');

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:

Line 4366: IF (FND_PROFILE.DEFINED('BIX_DM_CURR_CONVERSION_TYPE')) THEN

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;

Line 4367: g_conversion_type := FND_PROFILE.VALUE('BIX_DM_CURR_CONVERSION_TYPE');

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:

Line 4392: IF (FND_PROFILE.DEFINED('BIX_DM_DELETE_SIZE')) THEN

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;

Line 4393: g_commit_chunk_size := TO_NUMBER(FND_PROFILE.VALUE('BIX_DM_DELETE_SIZE'));

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:

Line 4398: IF (FND_PROFILE.DEFINED('BIX_DBI_DEBUG')) THEN

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;

Line 4399: g_debug_flag := nvl(FND_PROFILE.VALUE('BIX_DBI_DEBUG'), 'N');

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:

Line 4581: IF (FND_PROFILE.DEFINED('BIX_DM_PREFERRED_CURRENCY')) THEN

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;

Line 4582: g_preferred_currency := FND_PROFILE.VALUE('BIX_DM_PREFERRED_CURRENCY');

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:

Line 4587: IF (FND_PROFILE.DEFINED('BIX_DM_CURR_CONVERSION_TYPE')) THEN

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;

Line 4588: g_conversion_type := FND_PROFILE.VALUE('BIX_DM_CURR_CONVERSION_TYPE');

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:

Line 4612: IF (FND_PROFILE.DEFINED('BIX_DM_DELETE_SIZE')) THEN

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;

Line 4613: g_commit_chunk_size := TO_NUMBER(FND_PROFILE.VALUE('BIX_DM_DELETE_SIZE'));

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:

Line 4618: IF (FND_PROFILE.DEFINED('BIX_DBI_DEBUG')) THEN

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;

Line 4619: g_debug_flag := nvl(FND_PROFILE.VALUE('BIX_DBI_DEBUG'), 'N');

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:

Line 4671: IF (FND_PROFILE.DEFINED('BIX_DM_DELETE_SIZE')) THEN

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;

Line 4672: g_commit_chunk_size := TO_NUMBER(FND_PROFILE.VALUE('BIX_DM_DELETE_SIZE'));

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: