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;
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: --
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: --
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
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'
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