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: --
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
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;
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;
2571: dbg('Full refresh: ' || g_full_refresh);
2572: --
2573: -- Get the profile value which determines whether Archiving has been turned on
2574: --
2575: g_enable_archive_flag := NVL(fnd_profile.value('HRI_SET_EVENTS_ARCHIVE'),'N');
2576: --
2577: -- 3658545 The Events Collection process should populate the events queues
2578: -- based on the following profile
2579: --
2588: --
2589: --
2590: -- Get the profile value to determine which events queue is to be populated
2591: --
2592: g_col_asg_events_eq := NVL(fnd_profile.value('HRI_COL_ASG_EVENTS_EQ'),'Y');
2593: g_col_sup_hrchy_eq := NVL(fnd_profile.value('HRI_COL_SUP_HRCHY_EQ'),'Y');
2594: g_col_sup_hstry_eq := NVL(fnd_profile.value('HRI_COL_SUP_STATUS_EQ'),'Y');
2595: g_col_absence_events_eq := NVL(fnd_profile.value('HRI_COL_ABSNCE_DIM_EQ'),'Y');
2596: --
2589: --
2590: -- Get the profile value to determine which events queue is to be populated
2591: --
2592: g_col_asg_events_eq := NVL(fnd_profile.value('HRI_COL_ASG_EVENTS_EQ'),'Y');
2593: g_col_sup_hrchy_eq := NVL(fnd_profile.value('HRI_COL_SUP_HRCHY_EQ'),'Y');
2594: g_col_sup_hstry_eq := NVL(fnd_profile.value('HRI_COL_SUP_STATUS_EQ'),'Y');
2595: g_col_absence_events_eq := NVL(fnd_profile.value('HRI_COL_ABSNCE_DIM_EQ'),'Y');
2596: --
2597: IF g_col_asg_events_eq = 'N' AND
2590: -- Get the profile value to determine which events queue is to be populated
2591: --
2592: g_col_asg_events_eq := NVL(fnd_profile.value('HRI_COL_ASG_EVENTS_EQ'),'Y');
2593: g_col_sup_hrchy_eq := NVL(fnd_profile.value('HRI_COL_SUP_HRCHY_EQ'),'Y');
2594: g_col_sup_hstry_eq := NVL(fnd_profile.value('HRI_COL_SUP_STATUS_EQ'),'Y');
2595: g_col_absence_events_eq := NVL(fnd_profile.value('HRI_COL_ABSNCE_DIM_EQ'),'Y');
2596: --
2597: IF g_col_asg_events_eq = 'N' AND
2598: g_col_sup_hstry_eq = 'N'
2591: --
2592: g_col_asg_events_eq := NVL(fnd_profile.value('HRI_COL_ASG_EVENTS_EQ'),'Y');
2593: g_col_sup_hrchy_eq := NVL(fnd_profile.value('HRI_COL_SUP_HRCHY_EQ'),'Y');
2594: g_col_sup_hstry_eq := NVL(fnd_profile.value('HRI_COL_SUP_STATUS_EQ'),'Y');
2595: g_col_absence_events_eq := NVL(fnd_profile.value('HRI_COL_ABSNCE_DIM_EQ'),'Y');
2596: --
2597: IF g_col_asg_events_eq = 'N' AND
2598: g_col_sup_hstry_eq = 'N'
2599: THEN