816: g_proc_name := l_proc_name;
817:
818: /* Determine value of commit size. If the profile is not defined,
819: assume 100 rows. */
820: IF FND_PROFILE.DEFINED('BIX_DM_DELETE_SIZE')
821: THEN
822: g_commit_chunk_size := TO_NUMBER(FND_PROFILE.VALUE('BIX_DM_DELETE_SIZE'));
823: ELSE
824: g_commit_chunk_size := 100;
818: /* Determine value of commit size. If the profile is not defined,
819: assume 100 rows. */
820: IF FND_PROFILE.DEFINED('BIX_DM_DELETE_SIZE')
821: THEN
822: g_commit_chunk_size := TO_NUMBER(FND_PROFILE.VALUE('BIX_DM_DELETE_SIZE'));
823: ELSE
824: g_commit_chunk_size := 100;
825: END IF;
826:
823: ELSE
824: g_commit_chunk_size := 100;
825: END IF;
826:
827: IF (FND_PROFILE.DEFINED('BIX_DBI_DEBUG')) THEN
828: g_debug_flag := nvl(FND_PROFILE.VALUE('BIX_DBI_DEBUG'), 'N');
829: END IF;
830:
831: /* Concurrent program is passing date as YYYY/MM/DD HH24:MI:SS. */
824: g_commit_chunk_size := 100;
825: END IF;
826:
827: IF (FND_PROFILE.DEFINED('BIX_DBI_DEBUG')) THEN
828: g_debug_flag := nvl(FND_PROFILE.VALUE('BIX_DBI_DEBUG'), 'N');
829: END IF;
830:
831: /* Concurrent program is passing date as YYYY/MM/DD HH24:MI:SS. */
832: g_collect_start_date := TO_DATE(p_start_date,'YYYY/MM/DD HH24:MI:SS');