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 2575: g_enable_archive_flag := NVL(fnd_profile.value('HRI_SET_EVENTS_ARCHIVE'),'N');

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

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

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

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

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

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

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'

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

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