APPS.HRI_OPL_SUPH_HST dependencies on FND_PROFILE

Line 187: g_dbi_collection_start_date DATE := TRUNC(TO_DATE(fnd_profile.value

183: g_full_refresh VARCHAR2(30);
184: g_load_helper_table VARCHAR2(30);
185:
186: -- DBI global start date
187: g_dbi_collection_start_date DATE := TRUNC(TO_DATE(fnd_profile.value
188: ('BIS_GLOBAL_START_DATE'),'MM/DD/YYYY'));
189:
190: -- Bug 4105868: Global to store msg_sub_group
191: g_msg_sub_group VARCHAR2(400);

Line 332: IF (fnd_profile.value('HRI_IMPL_DBI') = 'Y') THEN

328: -- time there should only be one record for an assingment and type in the event
329: -- queue which contains the earliest event date for the assignment. Therefore,
330: -- if a record exists for the asg then update the record otherwise, insert a
331: -- new record for the assignment
332: IF (fnd_profile.value('HRI_IMPL_DBI') = 'Y') THEN
333:
334: MERGE INTO hri_eq_asg_sup_wrfc delta_eq
335: USING (SELECT assignment_id,
336: erlst_evnt_effective_date,

Line 358: IF (fnd_profile.value('HRI_COL_ABSNCE_EVENT_EQ') = 'Y') THEN

354:
355: END IF;
356:
357: -- Check if absence is required
358: IF (fnd_profile.value('HRI_COL_ABSNCE_EVENT_EQ') = 'Y') THEN
359:
360: MERGE INTO hri_eq_sup_absnc absnc_eq
361: USING (SELECT person_id,
362: erlst_evnt_effective_date,

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

1095: (p_mthd_action_id);
1096: g_refresh_start_date := g_mthd_action_array.collect_from_date;
1097: g_full_refresh := g_mthd_action_array.full_refresh_flag;
1098: g_load_helper_table := g_mthd_action_array.attribute1;
1099: IF (fnd_profile.value('HRI_IMPL_OBIEE') = 'Y') THEN
1100: g_implement_obiee := 'Y';
1101: ELSE
1102: g_implement_obiee := 'N';
1103: END IF;