451:
452: g_proc_name := l_proc_name;
453:
454: BEGIN
455: IF (FND_PROFILE.DEFINED('BIX_DM_AGENT_COST')) THEN
456: l_agent_cost := TO_NUMBER(FND_PROFILE.VALUE('BIX_DM_AGENT_COST'));
457: ELSE
458: g_message := 'Agent cost is not defined. Agent Cost set to zero.';
459: write_log( g_pkg_name, l_proc_name, g_message );
452: g_proc_name := l_proc_name;
453:
454: BEGIN
455: IF (FND_PROFILE.DEFINED('BIX_DM_AGENT_COST')) THEN
456: l_agent_cost := TO_NUMBER(FND_PROFILE.VALUE('BIX_DM_AGENT_COST'));
457: ELSE
458: g_message := 'Agent cost is not defined. Agent Cost set to zero.';
459: write_log( g_pkg_name, l_proc_name, g_message );
460: END IF;
914: g_proc_name := l_proc_name;
915:
916: /* Determine value of commit size. If the profile is not defined,
917: assume 100 rows. */
918: IF FND_PROFILE.DEFINED('BIX_DM_DELETE_SIZE')
919: THEN
920: g_commit_chunk_size := TO_NUMBER(FND_PROFILE.VALUE('BIX_DM_DELETE_SIZE'));
921: ELSE
922: g_commit_chunk_size := 100;
916: /* Determine value of commit size. If the profile is not defined,
917: assume 100 rows. */
918: IF FND_PROFILE.DEFINED('BIX_DM_DELETE_SIZE')
919: THEN
920: g_commit_chunk_size := TO_NUMBER(FND_PROFILE.VALUE('BIX_DM_DELETE_SIZE'));
921: ELSE
922: g_commit_chunk_size := 100;
923: END IF;
924:
921: ELSE
922: g_commit_chunk_size := 100;
923: END IF;
924:
925: IF (FND_PROFILE.DEFINED('BIX_DBI_DEBUG')) THEN
926: g_debug_flag := nvl(FND_PROFILE.VALUE('BIX_DBI_DEBUG'), 'N');
927: END IF;
928:
929: /* Concurrent program is passing date as YYYY/MM/DD HH24:MI:SS. */
922: g_commit_chunk_size := 100;
923: END IF;
924:
925: IF (FND_PROFILE.DEFINED('BIX_DBI_DEBUG')) THEN
926: g_debug_flag := nvl(FND_PROFILE.VALUE('BIX_DBI_DEBUG'), 'N');
927: END IF;
928:
929: /* Concurrent program is passing date as YYYY/MM/DD HH24:MI:SS. */
930: g_collect_start_date := TO_DATE(p_start_date,'YYYY/MM/DD HH24:MI:SS');