APPS.BIX_CALL_UPDATE_PKG dependencies on FND_PROFILE

Line 1625: IF (FND_PROFILE.DEFINED('BIX_CALL_THRESHOLD_SECS')) THEN

1621: --END IF;
1622: --
1623: --Retrieve any required profile values
1624: --
1625: IF (FND_PROFILE.DEFINED('BIX_CALL_THRESHOLD_SECS')) THEN
1626: begin
1627: l_threshold := to_number(FND_PROFILE.VALUE('BIX_CALL_THRESHOLD_SECS'));
1628: exception
1629: when others then

Line 1627: l_threshold := to_number(FND_PROFILE.VALUE('BIX_CALL_THRESHOLD_SECS'));

1623: --Retrieve any required profile values
1624: --
1625: IF (FND_PROFILE.DEFINED('BIX_CALL_THRESHOLD_SECS')) THEN
1626: begin
1627: l_threshold := to_number(FND_PROFILE.VALUE('BIX_CALL_THRESHOLD_SECS'));
1628: exception
1629: when others then
1630: l_threshold:=0;
1631: end;

Line 1636: IF (FND_PROFILE.DEFINED('BIX_CALL_SLGOAL_SECS')) THEN

1632: ELSE
1633: l_threshold := 0;
1634: END IF;
1635:
1636: IF (FND_PROFILE.DEFINED('BIX_CALL_SLGOAL_SECS')) THEN
1637: begin
1638: l_sl_goal := to_number(FND_PROFILE.VALUE('BIX_CALL_SLGOAL_SECS'));
1639: exception
1640: when others then

Line 1638: l_sl_goal := to_number(FND_PROFILE.VALUE('BIX_CALL_SLGOAL_SECS'));

1634: END IF;
1635:
1636: IF (FND_PROFILE.DEFINED('BIX_CALL_SLGOAL_SECS')) THEN
1637: begin
1638: l_sl_goal := to_number(FND_PROFILE.VALUE('BIX_CALL_SLGOAL_SECS'));
1639: exception
1640: when others then
1641: l_sl_goal:=0;
1642: end;

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

5612: l_start_date DATE;
5613:
5614: BEGIN
5615:
5616: IF (FND_PROFILE.DEFINED('BIX_DBI_DEBUG')) THEN
5617: g_debug_flag := nvl(FND_PROFILE.VALUE('BIX_DBI_DEBUG'), 'N');
5618: END IF;
5619:
5620: --g_debug_flag := 'Y';

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

5613:
5614: BEGIN
5615:
5616: IF (FND_PROFILE.DEFINED('BIX_DBI_DEBUG')) THEN
5617: g_debug_flag := nvl(FND_PROFILE.VALUE('BIX_DBI_DEBUG'), 'N');
5618: END IF;
5619:
5620: --g_debug_flag := 'Y';
5621:

Line 5629: --IF (FND_PROFILE.DEFINED('BIX_DM_DELETE_SIZE')) THEN

5625: --IF (g_debug_flag = 'Y') THEN
5626: --write_log('Debug Flag : ' || g_debug_flag);
5627: --END IF;
5628:
5629: --IF (FND_PROFILE.DEFINED('BIX_DM_DELETE_SIZE')) THEN
5630: --g_commit_chunk_size := TO_NUMBER(FND_PROFILE.VALUE('BIX_DM_DELETE_SIZE'));
5631: --END IF;
5632:
5633: g_commit_chunk_size := 1500;

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

5626: --write_log('Debug Flag : ' || g_debug_flag);
5627: --END IF;
5628:
5629: --IF (FND_PROFILE.DEFINED('BIX_DM_DELETE_SIZE')) THEN
5630: --g_commit_chunk_size := TO_NUMBER(FND_PROFILE.VALUE('BIX_DM_DELETE_SIZE'));
5631: --END IF;
5632:
5633: g_commit_chunk_size := 1500;
5634:

Line 5681: l_last_period_to := to_date(fnd_profile.value('BIS_GLOBAL_START_DATE'),

5677:
5678: -- cleanup_oltp; --001 shifted the call just above,after the truncates
5679:
5680: IF l_last_period_to IS NULL THEN
5681: l_last_period_to := to_date(fnd_profile.value('BIS_GLOBAL_START_DATE'),
5682: 'MM/DD/YYYY');
5683: END IF;
5684:
5685: l_last_period_to := l_last_period_to + 1/86400;