47: --
48: --Determine value of commit size, if profile not defined, assume 100 rows.
49: --
50:
51: IF FND_PROFILE.DEFINED('BIX_DM_DELETE_SIZE')
52: THEN
53: v_delete_size := TO_NUMBER(FND_PROFILE.VALUE('BIX_DM_DELETE_SIZE'));
54: ELSE
55: v_delete_size := 100;
49: --
50:
51: IF FND_PROFILE.DEFINED('BIX_DM_DELETE_SIZE')
52: THEN
53: v_delete_size := TO_NUMBER(FND_PROFILE.VALUE('BIX_DM_DELETE_SIZE'));
54: ELSE
55: v_delete_size := 100;
56: END IF;
57:
54: ELSE
55: v_delete_size := 100;
56: END IF;
57:
58: IF (FND_PROFILE.DEFINED('BIX_DBI_DEBUG')) THEN
59: g_debug_flag := nvl(FND_PROFILE.VALUE('BIX_DBI_DEBUG'), 'N');
60: END IF;
61:
62: --
55: v_delete_size := 100;
56: END IF;
57:
58: IF (FND_PROFILE.DEFINED('BIX_DBI_DEBUG')) THEN
59: g_debug_flag := nvl(FND_PROFILE.VALUE('BIX_DBI_DEBUG'), 'N');
60: END IF;
61:
62: --
63: --Concurrent program is passing date as YYYY/MM/DD HH24:MI:SS.