APPS.HR_CAL_EVENT_MAPPING_PKG dependencies on PER_CAL_ENTRY_VALUES

Line 22: FROM per_cal_entry_values ENV

18: SELECT DISTINCT ENT.org_structure_version_id "OSV_ID"
19: FROM per_calendar_entries ENT
20: WHERE ENT.org_structure_version_id IS NOT NULL
21: AND EXISTS (SELECT 'x'
22: FROM per_cal_entry_values ENV
23: WHERE ENV.calendar_entry_id = ENT.calendar_entry_id
24: );
25: --
26: -- Cursor to fetch the top of the hierarchy

Line 71: ,per_cal_entry_values ENV

67: ,ENV.cal_entry_value_id
68: ,ENV.parent_entry_value_id
69: ,'' "ENTRY_FLAG"
70: FROM per_calendar_entries ENT
71: ,per_cal_entry_values ENV
72: WHERE ENT.org_structure_version_id = cp_osv_id
73: AND ENT.calendar_entry_id = ENV.calendar_entry_id
74: AND ENV.org_structure_element_id IS NOT NULL
75: AND ENV.organization_id IS NOT NULL

Line 182: FROM per_cal_entry_values

178: CURSOR c_org_ovr ( cp_calendar_entry_id NUMBER
179: , cp_organization_id NUMBER
180: ) IS
181: SELECT cal_entry_value_id
182: FROM per_cal_entry_values
183: WHERE usage_flag = 'O'
184: AND calendar_entry_id = cp_calendar_entry_id
185: AND organization_id = cp_organization_id;
186:

Line 187: l_ovr_id per_cal_entry_values.cal_entry_value_id%TYPE;

183: WHERE usage_flag = 'O'
184: AND calendar_entry_id = cp_calendar_entry_id
185: AND organization_id = cp_organization_id;
186:
187: l_ovr_id per_cal_entry_values.cal_entry_value_id%TYPE;
188: l_proc VARCHAR2(100);
189:
190: BEGIN
191: l_proc := 'HR_CAL_EVENT_MAPPING_PKG.write_org_cache';

Line 548: FROM per_cal_entry_values ENV

544: SELECT DISTINCT ENT.hierarchy_id "GHV_ID"
545: FROM per_calendar_entries ENT
546: WHERE ENT.hierarchy_id IS NOT NULL
547: AND EXISTS (SELECT 'x'
548: FROM per_cal_entry_values ENV
549: WHERE ENV.calendar_entry_id = ENT.calendar_entry_id
550: );
551:
552: -- Cursor to fetch the version id of GHV

Line 598: ,per_cal_entry_values ENV

594: ,ENV.cal_entry_value_id
595: ,ENV.parent_entry_value_id
596: ,'' "ENTRY_FLAG"
597: FROM per_calendar_entries ENT
598: ,per_cal_entry_values ENV
599: WHERE ENT.hierarchy_id = cp_ghv_id
600: AND ENT.calendar_entry_id = ENV.calendar_entry_id
601: AND ENV.hierarchy_node_id IS NOT NULL
602: ORDER BY ENT.calendar_entry_id

Line 636: FROM per_cal_entry_values

632: CURSOR c_geo_ovr ( cp_calendar_entry_id NUMBER
633: , cp_hierarchy_node_id NUMBER
634: ) IS
635: SELECT cal_entry_value_id
636: FROM per_cal_entry_values
637: WHERE usage_flag = 'O'
638: AND calendar_entry_id = cp_calendar_entry_id
639: AND hierarchy_node_id = cp_hierarchy_node_id;
640:

Line 641: l_ovr_id per_cal_entry_values.cal_entry_value_id%TYPE;

637: WHERE usage_flag = 'O'
638: AND calendar_entry_id = cp_calendar_entry_id
639: AND hierarchy_node_id = cp_hierarchy_node_id;
640:
641: l_ovr_id per_cal_entry_values.cal_entry_value_id%TYPE;
642: l_proc VARCHAR2(100);
643:
644: BEGIN
645: l_proc := 'HR_CAL_EVENT_MAPPING_PKG.write_geo_cache';

Line 1151: FROM per_cal_entry_values

1147: -- Cursor to fetch event override name and type
1148: CURSOR c_event_ovr (cp_ovr_id NUMBER) IS
1149: SELECT override_name
1150: ,override_type
1151: FROM per_cal_entry_values
1152: WHERE cal_entry_value_id = cp_ovr_id;
1153:
1154: l_proc VARCHAR2(50);
1155: l_cal_event_obj per_cal_event_obj;

Line 1174: l_ovr_name per_cal_entry_values.override_name%TYPE;

1170: l_geo_node_id NUMBER;
1171:
1172: -- Calendar event override attributes
1173: l_ovr_id NUMBER;
1174: l_ovr_name per_cal_entry_values.override_name%TYPE;
1175: l_ovr_type per_cal_entry_values.override_type%TYPE;
1176:
1177: -- Local exceptions
1178: e_param_valdn_fail EXCEPTION;

Line 1175: l_ovr_type per_cal_entry_values.override_type%TYPE;

1171:
1172: -- Calendar event override attributes
1173: l_ovr_id NUMBER;
1174: l_ovr_name per_cal_entry_values.override_name%TYPE;
1175: l_ovr_type per_cal_entry_values.override_type%TYPE;
1176:
1177: -- Local exceptions
1178: e_param_valdn_fail EXCEPTION;
1179: e_bg_leg_not_found EXCEPTION;