DBA Data[Home] [Help]

APPS.HR_HNM_BUS dependencies on HR_KI_HIERARCHY_NODE_MAPS

Line 133: 'HR_KI_HIERARCHY_NODE_MAPS.HIERARCHY_ID'

129: Exception
130: when app_exception.application_exception then
131: IF hr_multi_message.exception_add
132: (p_associated_column1 =>
133: 'HR_KI_HIERARCHY_NODE_MAPS.HIERARCHY_ID'
134: ) THEN
135: hr_utility.set_location(' Leaving:'|| l_proc,30);
136: raise;
137: END IF;

Line 209: 'HR_KI_HIERARCHY_NODE_MAPS.TOPIC_ID'

205: Exception
206: when app_exception.application_exception then
207: IF hr_multi_message.exception_add
208: (p_associated_column1 =>
209: 'HR_KI_HIERARCHY_NODE_MAPS.TOPIC_ID'
210: ) THEN
211: hr_utility.set_location(' Leaving:'|| l_proc,30);
212: raise;
213: END IF;

Line 286: 'HR_KI_HIERARCHY_NODE_MAPS.USER_INTERFACE_ID'

282: Exception
283: when app_exception.application_exception then
284: IF hr_multi_message.exception_add
285: (p_associated_column1 =>
286: 'HR_KI_HIERARCHY_NODE_MAPS.USER_INTERFACE_ID'
287: ) THEN
288: hr_utility.set_location(' Leaving:'|| l_proc,30);
289: raise;
290: END IF;

Line 374: 'HR_KI_HIERARCHY_NODE_MAPS.HIERARCHY_ID',

370: Exception
371: when app_exception.application_exception then
372: IF hr_multi_message.exception_add
373: (p_associated_column1 =>
374: 'HR_KI_HIERARCHY_NODE_MAPS.HIERARCHY_ID',
375: p_associated_column2 =>
376: 'HR_KI_HIERARCHY_NODE_MAPS.TOPIC_ID',
377: p_associated_column3 =>
378: 'HR_KI_HIERARCHY_NODE_MAPS.USER_INTERFACE_ID'

Line 376: 'HR_KI_HIERARCHY_NODE_MAPS.TOPIC_ID',

372: IF hr_multi_message.exception_add
373: (p_associated_column1 =>
374: 'HR_KI_HIERARCHY_NODE_MAPS.HIERARCHY_ID',
375: p_associated_column2 =>
376: 'HR_KI_HIERARCHY_NODE_MAPS.TOPIC_ID',
377: p_associated_column3 =>
378: 'HR_KI_HIERARCHY_NODE_MAPS.USER_INTERFACE_ID'
379: ) THEN
380: hr_utility.set_location(' Leaving:'|| l_proc,30);

Line 378: 'HR_KI_HIERARCHY_NODE_MAPS.USER_INTERFACE_ID'

374: 'HR_KI_HIERARCHY_NODE_MAPS.HIERARCHY_ID',
375: p_associated_column2 =>
376: 'HR_KI_HIERARCHY_NODE_MAPS.TOPIC_ID',
377: p_associated_column3 =>
378: 'HR_KI_HIERARCHY_NODE_MAPS.USER_INTERFACE_ID'
379: ) THEN
380: hr_utility.set_location(' Leaving:'|| l_proc,30);
381: raise;
382: END IF;

Line 438: hr_ki_hierarchy_node_maps hnm

434: is
435: select
436: distinct 'found'
437: From
438: hr_ki_hierarchy_node_maps hnm
439: where
440: hnm.topic_id = p_topic_id
441: and hnm.hierarchy_id in
442: (

Line 455: hr_ki_hierarchy_node_maps hnm

451: is
452: select
453: distinct 'found'
454: From
455: hr_ki_hierarchy_node_maps hnm
456: where
457: hnm.hierarchy_id = p_hierarchy_id and
458: hnm.user_interface_id = p_user_interface_id;
459:

Line 465: hr_ki_hierarchy_node_maps hnm

461: is
462: select
463: distinct 'found'
464: from
465: hr_ki_hierarchy_node_maps hnm
466: where
467: (
468: hnm.topic_id = p_topic_id
469: and hnm.user_interface_id = p_user_interface_id

Line 485: hr_ki_hierarchy_node_maps hnm1

481: start with hrc.hierarchy_id in (
482: select
483: hierarchy_id
484: from
485: hr_ki_hierarchy_node_maps hnm1
486: where
487: hnm1.user_interface_id=p_user_interface_id
488: and hnm1.hierarchy_id is not null
489: )

Line 507: 'HR_KI_HIERARCHY_NODE_MAPS.HIERARCHY_ID'

503: -- accomodate errors occuring from the first chk_valid_combination check.
504:
505: if hr_multi_message.no_all_inclusive_error
506: (p_check_column1 =>
507: 'HR_KI_HIERARCHY_NODE_MAPS.HIERARCHY_ID'
508: ,p_check_column2 =>
509: 'HR_KI_HIERARCHY_NODE_MAPS.TOPIC_ID'
510: ,p_check_column3 =>
511: 'HR_KI_HIERARCHY_NODE_MAPS.USER_INTERFACE'

Line 509: 'HR_KI_HIERARCHY_NODE_MAPS.TOPIC_ID'

505: if hr_multi_message.no_all_inclusive_error
506: (p_check_column1 =>
507: 'HR_KI_HIERARCHY_NODE_MAPS.HIERARCHY_ID'
508: ,p_check_column2 =>
509: 'HR_KI_HIERARCHY_NODE_MAPS.TOPIC_ID'
510: ,p_check_column3 =>
511: 'HR_KI_HIERARCHY_NODE_MAPS.USER_INTERFACE'
512: )
513: then

Line 511: 'HR_KI_HIERARCHY_NODE_MAPS.USER_INTERFACE'

507: 'HR_KI_HIERARCHY_NODE_MAPS.HIERARCHY_ID'
508: ,p_check_column2 =>
509: 'HR_KI_HIERARCHY_NODE_MAPS.TOPIC_ID'
510: ,p_check_column3 =>
511: 'HR_KI_HIERARCHY_NODE_MAPS.USER_INTERFACE'
512: )
513: then
514: if p_hierarchy_id is not null and p_topic_id is not null
515: then

Line 579: 'HR_KI_HIERARCHY_NODE_MAPS.HIERARCHY_ID',

575: Exception
576: when app_exception.application_exception then
577: IF hr_multi_message.exception_add
578: (p_associated_column1 =>
579: 'HR_KI_HIERARCHY_NODE_MAPS.HIERARCHY_ID',
580: p_associated_column2 =>
581: 'HR_KI_HIERARCHY_NODE_MAPS.TOPIC_ID',
582: p_associated_column3 =>
583: 'HR_KI_HIERARCHY_NODE_MAPS.USER_INTERFACE_ID'

Line 581: 'HR_KI_HIERARCHY_NODE_MAPS.TOPIC_ID',

577: IF hr_multi_message.exception_add
578: (p_associated_column1 =>
579: 'HR_KI_HIERARCHY_NODE_MAPS.HIERARCHY_ID',
580: p_associated_column2 =>
581: 'HR_KI_HIERARCHY_NODE_MAPS.TOPIC_ID',
582: p_associated_column3 =>
583: 'HR_KI_HIERARCHY_NODE_MAPS.USER_INTERFACE_ID'
584: ) THEN
585: hr_utility.set_location(' Leaving:'|| l_proc,30);

Line 583: 'HR_KI_HIERARCHY_NODE_MAPS.USER_INTERFACE_ID'

579: 'HR_KI_HIERARCHY_NODE_MAPS.HIERARCHY_ID',
580: p_associated_column2 =>
581: 'HR_KI_HIERARCHY_NODE_MAPS.TOPIC_ID',
582: p_associated_column3 =>
583: 'HR_KI_HIERARCHY_NODE_MAPS.USER_INTERFACE_ID'
584: ) THEN
585: hr_utility.set_location(' Leaving:'|| l_proc,30);
586: raise;
587: END IF;