APPS.PER_PAT_BUS dependencies on PER_ALLOCATED_TASKS

Line 33: , per_allocated_tasks pat

29: SELECT pbg.security_group_id,
30: pbg.legislation_code
31: FROM per_business_groups_perf pbg
32: , per_allocated_checklists pac
33: , per_allocated_tasks pat
34: , per_all_people_f paf
35: WHERE pat.allocated_task_id = p_allocated_task_id
36: AND pat.allocated_checklist_id = pac.allocated_checklist_id
37: AND pac.person_id = paf.person_id

Line 110: , per_allocated_tasks pat

106: cursor csr_leg_code is
107: select pbg.legislation_code
108: FROM per_business_groups_perf pbg
109: , per_allocated_checklists pac
110: , per_allocated_tasks pat
111: , per_all_people_f paf
112: WHERE pat.allocated_task_id = p_allocated_task_id
113: AND pat.allocated_checklist_id = pac.allocated_checklist_id
114: AND pac.person_id = paf.person_id

Line 179: (p_task_name IN per_allocated_tasks.task_name%TYPE

175: -- |--------------------------< chk_name_unq >--------------------------------|
176: -- ----------------------------------------------------------------------------
177: --
178: PROCEDURE chk_name_unq
179: (p_task_name IN per_allocated_tasks.task_name%TYPE
180: ,p_allocated_checklist_id IN per_allocated_tasks.allocated_checklist_id%TYPE
181: ,p_allocated_task_id IN per_allocated_tasks.allocated_task_id%TYPE
182: ,p_object_version_number IN per_allocated_tasks.object_version_number%TYPE
183: ) IS

Line 180: ,p_allocated_checklist_id IN per_allocated_tasks.allocated_checklist_id%TYPE

176: -- ----------------------------------------------------------------------------
177: --
178: PROCEDURE chk_name_unq
179: (p_task_name IN per_allocated_tasks.task_name%TYPE
180: ,p_allocated_checklist_id IN per_allocated_tasks.allocated_checklist_id%TYPE
181: ,p_allocated_task_id IN per_allocated_tasks.allocated_task_id%TYPE
182: ,p_object_version_number IN per_allocated_tasks.object_version_number%TYPE
183: ) IS
184: --

Line 181: ,p_allocated_task_id IN per_allocated_tasks.allocated_task_id%TYPE

177: --
178: PROCEDURE chk_name_unq
179: (p_task_name IN per_allocated_tasks.task_name%TYPE
180: ,p_allocated_checklist_id IN per_allocated_tasks.allocated_checklist_id%TYPE
181: ,p_allocated_task_id IN per_allocated_tasks.allocated_task_id%TYPE
182: ,p_object_version_number IN per_allocated_tasks.object_version_number%TYPE
183: ) IS
184: --
185: -- Declare cursor to check name is unique.

Line 182: ,p_object_version_number IN per_allocated_tasks.object_version_number%TYPE

178: PROCEDURE chk_name_unq
179: (p_task_name IN per_allocated_tasks.task_name%TYPE
180: ,p_allocated_checklist_id IN per_allocated_tasks.allocated_checklist_id%TYPE
181: ,p_allocated_task_id IN per_allocated_tasks.allocated_task_id%TYPE
182: ,p_object_version_number IN per_allocated_tasks.object_version_number%TYPE
183: ) IS
184: --
185: -- Declare cursor to check name is unique.
186: --

Line 189: FROM per_allocated_tasks

185: -- Declare cursor to check name is unique.
186: --
187: CURSOR csr_unique_name IS
188: SELECT 'x'
189: FROM per_allocated_tasks
190: WHERE task_name = p_task_name
191: AND allocated_checklist_id = p_allocated_checklist_id
192: AND (allocated_task_id IS NULL OR
193: allocated_task_id <> p_allocated_task_id);

Line 252: (p_associated_column1 => 'PER_ALLOCATED_TASKS.TASK_NAME'

248: --
249: EXCEPTION
250: WHEN app_exception.application_exception THEN
251: IF hr_multi_message.exception_add
252: (p_associated_column1 => 'PER_ALLOCATED_TASKS.TASK_NAME'
253: ) THEN
254: hr_utility.set_location(' Leaving:'|| l_proc, 50);
255: RAISE;
256: END IF;

Line 264: (p_target_start_date IN per_allocated_tasks.target_start_date%TYPE

260: -- |-------------------------< chk_task_dates >-------------------------------|
261: -- ----------------------------------------------------------------------------
262: --
263: PROCEDURE chk_task_dates
264: (p_target_start_date IN per_allocated_tasks.target_start_date%TYPE
265: ,p_target_end_date IN per_allocated_tasks.target_end_date%TYPE
266: ,p_actual_start_date IN per_allocated_tasks.actual_start_date%TYPE
267: ,p_actual_end_date IN per_allocated_tasks.actual_end_date%TYPE
268: ) IS

Line 265: ,p_target_end_date IN per_allocated_tasks.target_end_date%TYPE

261: -- ----------------------------------------------------------------------------
262: --
263: PROCEDURE chk_task_dates
264: (p_target_start_date IN per_allocated_tasks.target_start_date%TYPE
265: ,p_target_end_date IN per_allocated_tasks.target_end_date%TYPE
266: ,p_actual_start_date IN per_allocated_tasks.actual_start_date%TYPE
267: ,p_actual_end_date IN per_allocated_tasks.actual_end_date%TYPE
268: ) IS
269: --

Line 266: ,p_actual_start_date IN per_allocated_tasks.actual_start_date%TYPE

262: --
263: PROCEDURE chk_task_dates
264: (p_target_start_date IN per_allocated_tasks.target_start_date%TYPE
265: ,p_target_end_date IN per_allocated_tasks.target_end_date%TYPE
266: ,p_actual_start_date IN per_allocated_tasks.actual_start_date%TYPE
267: ,p_actual_end_date IN per_allocated_tasks.actual_end_date%TYPE
268: ) IS
269: --
270: -- Declare local variables

Line 267: ,p_actual_end_date IN per_allocated_tasks.actual_end_date%TYPE

263: PROCEDURE chk_task_dates
264: (p_target_start_date IN per_allocated_tasks.target_start_date%TYPE
265: ,p_target_end_date IN per_allocated_tasks.target_end_date%TYPE
266: ,p_actual_start_date IN per_allocated_tasks.actual_start_date%TYPE
267: ,p_actual_end_date IN per_allocated_tasks.actual_end_date%TYPE
268: ) IS
269: --
270: -- Declare local variables
271: --

Line 309: (p_associated_column1 => 'PER_ALLOCATED_TASKS.TARGET/ACTUAL_START/END_DATE'

305: --
306: EXCEPTION
307: WHEN app_exception.application_exception THEN
308: IF hr_multi_message.exception_add
309: (p_associated_column1 => 'PER_ALLOCATED_TASKS.TARGET/ACTUAL_START/END_DATE'
310: ) THEN
311: hr_utility.set_location(' Leaving:'|| l_proc, 50);
312: RAISE;
313: END IF;