APPS.BIX_EMAILS_LOAD_PKG dependencies on FND_PROFILE

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

91: g_rows_ins_upd := 0;
92:
93: write_log('Getting Commit Size');
94:
95: IF (FND_PROFILE.DEFINED('BIX_DM_DELETE_SIZE')) THEN
96: g_commit_chunk_size := TO_NUMBER(FND_PROFILE.VALUE('BIX_DM_DELETE_SIZE'));
97: END IF;
98:
99: write_log('Commit SIZE : ' || g_commit_chunk_size);

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

92:
93: write_log('Getting Commit Size');
94:
95: IF (FND_PROFILE.DEFINED('BIX_DM_DELETE_SIZE')) THEN
96: g_commit_chunk_size := TO_NUMBER(FND_PROFILE.VALUE('BIX_DM_DELETE_SIZE'));
97: END IF;
98:
99: write_log('Commit SIZE : ' || g_commit_chunk_size);
100:

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

99: write_log('Commit SIZE : ' || g_commit_chunk_size);
100:
101: write_log('Getting Debug Information');
102:
103: IF (FND_PROFILE.DEFINED('BIX_DBI_DEBUG')) THEN
104: g_debug_flag := nvl(FND_PROFILE.VALUE('BIX_DBI_DEBUG'), 'N');
105: END IF;
106:
107: write_log('Debug Flag : ' || g_debug_flag);

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

100:
101: write_log('Getting Debug Information');
102:
103: IF (FND_PROFILE.DEFINED('BIX_DBI_DEBUG')) THEN
104: g_debug_flag := nvl(FND_PROFILE.VALUE('BIX_DBI_DEBUG'), 'N');
105: END IF;
106:
107: write_log('Debug Flag : ' || g_debug_flag);
108:

Line 560: IF (FND_PROFILE.DEFINED('BIX_EMAIL_GOAL')) THEN

556: write_log('Start of the procedure collect_emails at : ' || to_char(sysdate, 'mm/dd/yyyy hh24:mi:ss'));
557:
558: /* Get the service level for the whole email center : if not defined then 1 day is the default */
559: /* Multiply the profile by 60 * 60 to convert from hour to seconds */
560: IF (FND_PROFILE.DEFINED('BIX_EMAIL_GOAL')) THEN
561: l_email_service_level := TO_NUMBER(FND_PROFILE.VALUE('BIX_EMAIL_GOAL')) * 60 * 60;
562: ELSE
563: l_email_service_level := 24 * 60 * 60;
564: END IF;

Line 561: l_email_service_level := TO_NUMBER(FND_PROFILE.VALUE('BIX_EMAIL_GOAL')) * 60 * 60;

557:
558: /* Get the service level for the whole email center : if not defined then 1 day is the default */
559: /* Multiply the profile by 60 * 60 to convert from hour to seconds */
560: IF (FND_PROFILE.DEFINED('BIX_EMAIL_GOAL')) THEN
561: l_email_service_level := TO_NUMBER(FND_PROFILE.VALUE('BIX_EMAIL_GOAL')) * 60 * 60;
562: ELSE
563: l_email_service_level := 24 * 60 * 60;
564: END IF;
565: write_log('The service level for the whole email center : ' || to_char(l_email_service_level) || ' seconds');

Line 3094: l_start_date := to_date(fnd_profile.value('BIS_GLOBAL_START_DATE'),'MM/DD/YYYY');

3090: init;
3091: write_log('End procedure init');
3092:
3093: /* Get the global start date */
3094: l_start_date := to_date(fnd_profile.value('BIS_GLOBAL_START_DATE'),'MM/DD/YYYY');
3095:
3096:
3097: /* Round the start date to the nearest half hour , less than start date */
3098: SELECT