DBA Data[Home] [Help]

APPS.HRI_OPL_EVENT_CAPTURE dependencies on FND_PROFILE

Line 87: g_debug_flag VARCHAR2(5) := NVL(fnd_profile.value('HRI_ENBL_DTL_LOG'),'N');

83: g_dbi_collection_start_date DATE := hri_bpl_parameter.get_bis_global_start_date;
84: --
85: -- Global flag which determines whether debugging is turned on
86: --
87: g_debug_flag VARCHAR2(5) := NVL(fnd_profile.value('HRI_ENBL_DTL_LOG'),'N');
88: --
89: -- Global flag which determines whether archiving is turned on
90: --
91: --

Line 272: IF (fnd_profile.value('HRI_IMPL_OBIEE') = 'Y') THEN

268:
269: BEGIN
270:
271: -- Set OBIEE parameters
272: IF (fnd_profile.value('HRI_IMPL_OBIEE') = 'Y') THEN
273: l_implement_obiee := 'Y';
274: IF (fnd_profile.value('HRI_COL_SUP_HRCHY_EQ') = 'Y') THEN
275: l_implement_obiee_mgrh := 'Y';
276: ELSE

Line 274: IF (fnd_profile.value('HRI_COL_SUP_HRCHY_EQ') = 'Y') THEN

270:
271: -- Set OBIEE parameters
272: IF (fnd_profile.value('HRI_IMPL_OBIEE') = 'Y') THEN
273: l_implement_obiee := 'Y';
274: IF (fnd_profile.value('HRI_COL_SUP_HRCHY_EQ') = 'Y') THEN
275: l_implement_obiee_mgrh := 'Y';
276: ELSE
277: l_implement_obiee_mgrh := 'N';
278: END IF;

Line 279: IF (fnd_profile.value('HRI_COL_ORG_HRCHY_EQ') = 'Y') THEN

275: l_implement_obiee_mgrh := 'Y';
276: ELSE
277: l_implement_obiee_mgrh := 'N';
278: END IF;
279: IF (fnd_profile.value('HRI_COL_ORG_HRCHY_EQ') = 'Y') THEN
280: l_implement_obiee_orgh := 'Y';
281: ELSE
282: l_implement_obiee_orgh := 'N';
283: END IF;

Line 2578: g_enable_archive_flag := NVL(fnd_profile.value('HRI_SET_EVENTS_ARCHIVE'),'N');

2574: dbg('Full refresh: ' || g_full_refresh);
2575: --
2576: -- Get the profile value which determines whether Archiving has been turned on
2577: --
2578: g_enable_archive_flag := NVL(fnd_profile.value('HRI_SET_EVENTS_ARCHIVE'),'N');
2579: --
2580: -- 3658545 The Events Collection process should populate the events queues
2581: -- based on the following profile
2582: --

Line 2595: g_col_asg_events_eq := NVL(fnd_profile.value('HRI_COL_ASG_EVENTS_EQ'),'Y');

2591: --
2592: --
2593: -- Get the profile value to determine which events queue is to be populated
2594: --
2595: g_col_asg_events_eq := NVL(fnd_profile.value('HRI_COL_ASG_EVENTS_EQ'),'Y');
2596: g_col_sup_hrchy_eq := NVL(fnd_profile.value('HRI_COL_SUP_HRCHY_EQ'),'Y');
2597: g_col_sup_hstry_eq := NVL(fnd_profile.value('HRI_COL_SUP_STATUS_EQ'),'Y');
2598: g_col_absence_events_eq := NVL(fnd_profile.value('HRI_COL_ABSNCE_DIM_EQ'),'Y');
2599: --

Line 2596: g_col_sup_hrchy_eq := NVL(fnd_profile.value('HRI_COL_SUP_HRCHY_EQ'),'Y');

2592: --
2593: -- Get the profile value to determine which events queue is to be populated
2594: --
2595: g_col_asg_events_eq := NVL(fnd_profile.value('HRI_COL_ASG_EVENTS_EQ'),'Y');
2596: g_col_sup_hrchy_eq := NVL(fnd_profile.value('HRI_COL_SUP_HRCHY_EQ'),'Y');
2597: g_col_sup_hstry_eq := NVL(fnd_profile.value('HRI_COL_SUP_STATUS_EQ'),'Y');
2598: g_col_absence_events_eq := NVL(fnd_profile.value('HRI_COL_ABSNCE_DIM_EQ'),'Y');
2599: --
2600: IF g_col_asg_events_eq = 'N' AND

Line 2597: g_col_sup_hstry_eq := NVL(fnd_profile.value('HRI_COL_SUP_STATUS_EQ'),'Y');

2593: -- Get the profile value to determine which events queue is to be populated
2594: --
2595: g_col_asg_events_eq := NVL(fnd_profile.value('HRI_COL_ASG_EVENTS_EQ'),'Y');
2596: g_col_sup_hrchy_eq := NVL(fnd_profile.value('HRI_COL_SUP_HRCHY_EQ'),'Y');
2597: g_col_sup_hstry_eq := NVL(fnd_profile.value('HRI_COL_SUP_STATUS_EQ'),'Y');
2598: g_col_absence_events_eq := NVL(fnd_profile.value('HRI_COL_ABSNCE_DIM_EQ'),'Y');
2599: --
2600: IF g_col_asg_events_eq = 'N' AND
2601: g_col_sup_hstry_eq = 'N'

Line 2598: g_col_absence_events_eq := NVL(fnd_profile.value('HRI_COL_ABSNCE_DIM_EQ'),'Y');

2594: --
2595: g_col_asg_events_eq := NVL(fnd_profile.value('HRI_COL_ASG_EVENTS_EQ'),'Y');
2596: g_col_sup_hrchy_eq := NVL(fnd_profile.value('HRI_COL_SUP_HRCHY_EQ'),'Y');
2597: g_col_sup_hstry_eq := NVL(fnd_profile.value('HRI_COL_SUP_STATUS_EQ'),'Y');
2598: g_col_absence_events_eq := NVL(fnd_profile.value('HRI_COL_ABSNCE_DIM_EQ'),'Y');
2599: --
2600: IF g_col_asg_events_eq = 'N' AND
2601: g_col_sup_hstry_eq = 'N'
2602: THEN