[Home] [Help]
70: -- {Start Of Comments}
71: --
72: -- Description:
73: -- This procedure ensures that the hierarchy id entered is present in the
74: -- master table hr_ki_hierarchies if not null.
75:
76: -- Pre Conditions:
77: -- g_rec has been populated with details of the values
78: -- from the ins or the upd procedures
80: -- In Arguments:
81: -- p_hierarchy_id
82:
83: -- Post Success:
84: -- Processing continues if hierarchy id is present in hr_ki_hierarchies
85: --
86: -- Post Failure:
87: -- An application error is raised if hierarchy id does not exist in
88: -- hr_ki_hierarchies.
84: -- Processing continues if hierarchy id is present in hr_ki_hierarchies
85: --
86: -- Post Failure:
87: -- An application error is raised if hierarchy id does not exist in
88: -- hr_ki_hierarchies.
89: --
90: -- {End Of Comments}
91: -- ----------------------------------------------------------------------------
92:
99: CURSOR csr_hrc_id is
100: select
101: 'found'
102: From
103: hr_ki_hierarchies hrc
104: where
105: hrc.hierarchy_id = p_hierarchy_id;
106:
107:
111:
112: -- check if the hierarchy id is not null
113: if(p_hierarchy_id is not null)
114: then
115: -- check if the id exists in the hr_ki_hierarchies
116: open csr_hrc_id;
117:
118: fetch csr_hrc_id into l_found;
119:
187:
188: -- if the topic id is not null, check whether it exists in hr_ki_topics
189: if(p_topic_id is not null)
190: then
191: -- check if the id, key combination exists in the hr_ki_hierarchies
192: open csr_tpc_id;
193:
194: fetch csr_tpc_id into l_found;
195:
264:
265: -- if the topic id is not null, check whether it exists in hr_ki_topics
266: if(p_user_interface_id is not null)
267: then
268: -- check if the id, key combination exists in the hr_ki_hierarchies
269: open csr_itf_id;
270:
271: fetch csr_itf_id into l_found;
272:
441: and hnm.hierarchy_id in
442: (
443: select hrc.hierarchy_id
444: from
445: hr_ki_hierarchies hrc
446: connect by prior hrc.parent_hierarchy_id = hrc.hierarchy_id
447: start with hrc.hierarchy_id = p_hierarchy_id
448: );
449:
475: (
476: select
477: hierarchy_id
478: from
479: hr_ki_hierarchies hrc
480: connect by prior hrc.parent_hierarchy_id = hrc.hierarchy_id
481: start with hrc.hierarchy_id in (
482: select
483: hierarchy_id