eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_CTK_BUS dependencies on PER_TASKS_IN_CHECKLIST

Line 32: , per_tasks_in_checklist tic

28: cursor csr_sec_grp is
29: select pbg.security_group_id,
30: pbg.legislation_code
31: from per_business_groups_perf pbg
32: , per_tasks_in_checklist tic
33: , per_checklists ckl
34: where tic.task_in_checklist_id = p_task_in_checklist_id
35: and tic.checklist_id = ckl.checklist_id
36: and pbg.business_group_id = ckl.business_group_id;

Line 104: , per_tasks_in_checklist tic

100: --
101: cursor csr_leg_code is
102: select pbg.legislation_code
103: from per_business_groups_perf pbg
104: , per_tasks_in_checklist tic
105: , per_checklists ckl
106: where tic.task_in_checklist_id = p_task_in_checklist_id
107: and tic.checklist_id = ckl.checklist_id
108: and pbg.business_group_id = ckl.business_group_id;

Line 171: (p_checklist_id in per_tasks_in_checklist.checklist_id%TYPE

167: -- |---------------------------< chk_checklist_id >--------------------------|
168: -- ---------------------------------------------------------------------------
169: --
170: procedure chk_checklist_id
171: (p_checklist_id in per_tasks_in_checklist.checklist_id%TYPE
172: ) is
173: --
174: -- Declare local variables
175: --

Line 228: (p_checklist_task_name in per_tasks_in_checklist.checklist_task_name%TYPE

224: -- |----------------------------< chk_task_name >----------------------------|
225: -- ---------------------------------------------------------------------------
226: --
227: procedure chk_task_name
228: (p_checklist_task_name in per_tasks_in_checklist.checklist_task_name%TYPE
229: ,p_task_in_checklist_id in per_tasks_in_checklist.task_in_checklist_id%TYPE
230: ,p_checklist_id in per_tasks_in_checklist.checklist_id%TYPE
231: ,p_object_version_number in per_tasks_in_checklist.object_version_number%type
232: ) is

Line 229: ,p_task_in_checklist_id in per_tasks_in_checklist.task_in_checklist_id%TYPE

225: -- ---------------------------------------------------------------------------
226: --
227: procedure chk_task_name
228: (p_checklist_task_name in per_tasks_in_checklist.checklist_task_name%TYPE
229: ,p_task_in_checklist_id in per_tasks_in_checklist.task_in_checklist_id%TYPE
230: ,p_checklist_id in per_tasks_in_checklist.checklist_id%TYPE
231: ,p_object_version_number in per_tasks_in_checklist.object_version_number%type
232: ) is
233: --

Line 230: ,p_checklist_id in per_tasks_in_checklist.checklist_id%TYPE

226: --
227: procedure chk_task_name
228: (p_checklist_task_name in per_tasks_in_checklist.checklist_task_name%TYPE
229: ,p_task_in_checklist_id in per_tasks_in_checklist.task_in_checklist_id%TYPE
230: ,p_checklist_id in per_tasks_in_checklist.checklist_id%TYPE
231: ,p_object_version_number in per_tasks_in_checklist.object_version_number%type
232: ) is
233: --
234: -- Declare local variables

Line 231: ,p_object_version_number in per_tasks_in_checklist.object_version_number%type

227: procedure chk_task_name
228: (p_checklist_task_name in per_tasks_in_checklist.checklist_task_name%TYPE
229: ,p_task_in_checklist_id in per_tasks_in_checklist.task_in_checklist_id%TYPE
230: ,p_checklist_id in per_tasks_in_checklist.checklist_id%TYPE
231: ,p_object_version_number in per_tasks_in_checklist.object_version_number%type
232: ) is
233: --
234: -- Declare local variables
235: --

Line 244: from per_tasks_in_checklist tic

240: -- Declare cursor to check name is unique.
241: --
242: cursor csr_ckltsk is
243: select 'X'
244: from per_tasks_in_checklist tic
245: where tic.checklist_task_name = p_checklist_task_name
246: and tic.checklist_id = p_checklist_id;
247: --
248: begin

Line 310: (p_target_duration in per_tasks_in_checklist.target_duration%TYPE

306: -- |----------------------------< chk_duration_uom >-------------------------|
307: -- ---------------------------------------------------------------------------
308: --
309: procedure chk_duration_uom
310: (p_target_duration in per_tasks_in_checklist.target_duration%TYPE
311: ,p_target_duration_uom in per_tasks_in_checklist.target_duration_uom%TYPE
312: ,p_task_in_checklist_id in per_tasks_in_checklist.task_in_checklist_id%TYPE
313: ,p_object_version_number in per_tasks_in_checklist.object_version_number%type
314: ,p_effective_date in date

Line 311: ,p_target_duration_uom in per_tasks_in_checklist.target_duration_uom%TYPE

307: -- ---------------------------------------------------------------------------
308: --
309: procedure chk_duration_uom
310: (p_target_duration in per_tasks_in_checklist.target_duration%TYPE
311: ,p_target_duration_uom in per_tasks_in_checklist.target_duration_uom%TYPE
312: ,p_task_in_checklist_id in per_tasks_in_checklist.task_in_checklist_id%TYPE
313: ,p_object_version_number in per_tasks_in_checklist.object_version_number%type
314: ,p_effective_date in date
315: ) is

Line 312: ,p_task_in_checklist_id in per_tasks_in_checklist.task_in_checklist_id%TYPE

308: --
309: procedure chk_duration_uom
310: (p_target_duration in per_tasks_in_checklist.target_duration%TYPE
311: ,p_target_duration_uom in per_tasks_in_checklist.target_duration_uom%TYPE
312: ,p_task_in_checklist_id in per_tasks_in_checklist.task_in_checklist_id%TYPE
313: ,p_object_version_number in per_tasks_in_checklist.object_version_number%type
314: ,p_effective_date in date
315: ) is
316: --

Line 313: ,p_object_version_number in per_tasks_in_checklist.object_version_number%type

309: procedure chk_duration_uom
310: (p_target_duration in per_tasks_in_checklist.target_duration%TYPE
311: ,p_target_duration_uom in per_tasks_in_checklist.target_duration_uom%TYPE
312: ,p_task_in_checklist_id in per_tasks_in_checklist.task_in_checklist_id%TYPE
313: ,p_object_version_number in per_tasks_in_checklist.object_version_number%type
314: ,p_effective_date in date
315: ) is
316: --
317: -- Declare local variables

Line 406: (p_checklist_id in per_tasks_in_checklist.checklist_id%TYPE

402: -- |--------------------------< chk_ckl_tsk_uinique >------------------------|
403: -- ---------------------------------------------------------------------------
404: --
405: procedure chk_ckl_tsk_unique
406: (p_checklist_id in per_tasks_in_checklist.checklist_id%TYPE
407: ,p_checklist_task_name in per_tasks_in_checklist.checklist_task_name%TYPE
408: ) is
409: --
410: -- Declare local variables

Line 407: ,p_checklist_task_name in per_tasks_in_checklist.checklist_task_name%TYPE

403: -- ---------------------------------------------------------------------------
404: --
405: procedure chk_ckl_tsk_unique
406: (p_checklist_id in per_tasks_in_checklist.checklist_id%TYPE
407: ,p_checklist_task_name in per_tasks_in_checklist.checklist_task_name%TYPE
408: ) is
409: --
410: -- Declare local variables
411: --

Line 419: from per_tasks_in_checklist tic

415: -- Declare cursor to check name is unique.
416: --
417: cursor csr_ckl_tsk is
418: select null
419: from per_tasks_in_checklist tic
420: where tic.checklist_id = p_checklist_id
421: and tic.checklist_task_name = p_checklist_task_name;
422:
423: --

Line 448: (p_eligibility_profile_id in per_tasks_in_checklist.eligibility_profile_id%TYPE

444: -- |---------------------------< CHK_ELIG_PRFL_ID >--------------------------|
445: -- ---------------------------------------------------------------------------
446: --
447: procedure chk_elig_prfl_id
448: (p_eligibility_profile_id in per_tasks_in_checklist.eligibility_profile_id%TYPE
449: ,p_business_group_id in per_checklists.business_group_id%TYPE
450: ,p_effective_date in date
451: ) is
452: --