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 637: FROM per_cal_entry_values

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

Line 642: l_ovr_id per_cal_entry_values.cal_entry_value_id%TYPE;

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

Line 1189: FROM per_cal_entry_values

1185: -- Cursor to fetch event override name and type
1186: CURSOR c_event_ovr (cp_ovr_id NUMBER) IS
1187: SELECT override_name
1188: ,override_type
1189: FROM per_cal_entry_values
1190: WHERE cal_entry_value_id = cp_ovr_id;
1191:
1192: l_proc VARCHAR2(50);
1193: l_cal_event_obj per_cal_event_obj;

Line 1212: l_ovr_name per_cal_entry_values.override_name%TYPE;

1208: l_geo_node_id NUMBER;
1209:
1210: -- Calendar event override attributes
1211: l_ovr_id NUMBER;
1212: l_ovr_name per_cal_entry_values.override_name%TYPE;
1213: l_ovr_type per_cal_entry_values.override_type%TYPE;
1214:
1215: -- Local exceptions
1216: e_param_valdn_fail EXCEPTION;

Line 1213: l_ovr_type per_cal_entry_values.override_type%TYPE;

1209:
1210: -- Calendar event override attributes
1211: l_ovr_id NUMBER;
1212: l_ovr_name per_cal_entry_values.override_name%TYPE;
1213: l_ovr_type per_cal_entry_values.override_type%TYPE;
1214:
1215: -- Local exceptions
1216: e_param_valdn_fail EXCEPTION;
1217: e_bg_leg_not_found EXCEPTION;