APPS.HR_HRC_BUS dependencies on HR_KI_HIERARCHIES

Line 111: hr_ki_hierarchies hrc

107: CURSOR csr_hrc_key is
108: select
109: distinct 'found'
110: From
111: hr_ki_hierarchies hrc
112: where
113: hrc.hierarchy_key = p_hierarchy_key;
114:
115: -- Variables for API Boolean parameters

Line 148: (p_associated_column1 => 'HR_KI_HIERARCHIES.HIERARCHY_KEY'

144: hr_utility.set_location(' Leaving:' || l_proc,40);
145: Exception
146: when app_exception.application_exception then
147: IF hr_multi_message.exception_add
148: (p_associated_column1 => 'HR_KI_HIERARCHIES.HIERARCHY_KEY'
149: )
150: THEN
151: hr_utility.set_location(' Leaving:'|| l_proc,50);
152: raise;

Line 194: hr_ki_hierarchies hrc

190: cursor csr_hrc_parent_id is
191: select
192: 'found'
193: From
194: hr_ki_hierarchies hrc
195: where
196: hrc.hierarchy_id = p_parent_hierarchy_id;
197:
198: cursor csr_check_null is

Line 202: hr_ki_hierarchies hrc

198: cursor csr_check_null is
199: select
200: 'found'
201: From
202: hr_ki_hierarchies hrc
203: Where
204: hrc.parent_hierarchy_id is null;
205:
206:

Line 261: 'HR_KI_HIERARCHIES.PARENT_HIERARCHY_ID'

257: Exception
258: when app_exception.application_exception then
259: If hr_multi_message.exception_add
260: (p_associated_column1 =>
261: 'HR_KI_HIERARCHIES.PARENT_HIERARCHY_ID'
262: ) THEN
263: hr_utility.set_location(' Leaving:'|| l_proc,70);
264: raise;
265: End If;

Line 323: (p_associated_column1 =>'HR_KI_HIERARCHIES.PARENT_HIERARCHY_ID'

319:
320: Exception
321: when app_exception.application_exception then
322: IF hr_multi_message.exception_add
323: (p_associated_column1 =>'HR_KI_HIERARCHIES.PARENT_HIERARCHY_ID'
324: )THEN
325: hr_utility.set_location(' Leaving:'|| l_proc,40);
326: raise;
327: END IF;

Line 374: from hr_ki_hierarchies hrc

370: p_hierarchy_id in
371: (
372: select
373: hrc.hierarchy_id
374: from hr_ki_hierarchies hrc
375: connect by prior hrc.parent_hierarchy_id = hrc.hierarchy_id
376: start with hrc.hierarchy_id = p_parent_hierarchy_id
377: );
378: -- Variables for API Boolean parameters

Line 405: (p_associated_column1 =>'HR_KI_HIERARCHIES.PARENT_HIERARCHY_ID'

401:
402: Exception
403: when app_exception.application_exception then
404: IF hr_multi_message.exception_add
405: (p_associated_column1 =>'HR_KI_HIERARCHIES.PARENT_HIERARCHY_ID'
406: )THEN
407: hr_utility.set_location(' Leaving:'|| l_proc,40);
408: raise;
409: END IF;

Line 420: -- rows for a record in hr_ki_hierarchies. The tables that contain child rows

416: -- {Start Of Comments}
417: --
418: -- Description:
419: -- This procedure ensures that a delete occurs only if there are no child
420: -- rows for a record in hr_ki_hierarchies. The tables that contain child rows
421: -- are hr_ki_hierarchies, hr_ki_hierarchy_node_maps,hr_ki_hierarchies_tl.
422:
423: -- Pre Conditions:
424: -- g_rec has been populated with details of the values

Line 421: -- are hr_ki_hierarchies, hr_ki_hierarchy_node_maps,hr_ki_hierarchies_tl.

417: --
418: -- Description:
419: -- This procedure ensures that a delete occurs only if there are no child
420: -- rows for a record in hr_ki_hierarchies. The tables that contain child rows
421: -- are hr_ki_hierarchies, hr_ki_hierarchy_node_maps,hr_ki_hierarchies_tl.
422:
423: -- Pre Conditions:
424: -- g_rec has been populated with details of the values
425: -- from the ins or the upd procedures

Line 447: hr_ki_hierarchies hrc

443: CURSOR csr_hrc_id is
444: select
445: distinct 'found'
446: From
447: hr_ki_hierarchies hrc
448: where
449: hrc.parent_hierarchy_id = p_hierarchy_id;
450:
451: CURSOR csr_hnm_id is

Line 463: hr_ki_hierarchies_tl htl

459: CURSOR csr_htl_id is
460: select
461: distinct 'found'
462: From
463: hr_ki_hierarchies_tl htl
464: where
465: htl.hierarchy_id = p_hierarchy_id;
466:
467: l_found varchar2(30);

Line 511: (p_associated_column1 => 'HR_KI_HIERARCHIES.HIERARCHY_ID'

507:
508: Exception
509: when app_exception.application_exception then
510: IF hr_multi_message.exception_add
511: (p_associated_column1 => 'HR_KI_HIERARCHIES.HIERARCHY_ID'
512: )THEN
513: hr_utility.set_location(' Leaving:'|| l_proc,30);
514: raise;
515: END IF;