APPS.HR_NAVIGATION_PATHS_PKG dependencies on HR_NAVIGATION_NODE_USAGES

Line 56: p_ref_entity => 'HR_NAVIGATION_NODE_USAGES',

52: /* Commented and Added as a part of fix for bug#12554709 Starts
53: BEGIN
54: PER_RIC_PKG.chk_integrity (
55: p_entity_name => 'HR_NAVIGATION_PATHS',
56: p_ref_entity => 'HR_NAVIGATION_NODE_USAGES',
57: p_ref_column_info => PER_RIC_PKG.column_info_tbl(
58: PER_RIC_PKG.col_info_rec('NAV_NODE_USAGE_ID',NULL,X_FROM_NAV_NODE_USAGE_ID,NULL) ,
59: PER_RIC_PKG.col_info_rec('NAV_NODE_USAGE_ID',NULL,X_TO_NAV_NODE_USAGE_ID,NULL)
60: ),

Line 69: PER_RIC_PKG.ref_info_rec('HR_NAVIGATION_NODE_USAGES', PER_RIC_PKG.column_info_tbl(

65: BEGIN
66: PER_RIC_PKG.chk_integrity (
67: p_entity_name => 'HR_NAVIGATION_PATHS',
68: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
69: PER_RIC_PKG.ref_info_rec('HR_NAVIGATION_NODE_USAGES', PER_RIC_PKG.column_info_tbl(
70: PER_RIC_PKG.col_info_rec('NAV_NODE_USAGE_ID',NULL,X_FROM_NAV_NODE_USAGE_ID,NULL))),
71: PER_RIC_PKG.ref_info_rec('HR_NAVIGATION_NODE_USAGES', PER_RIC_PKG.column_info_tbl(
72: PER_RIC_PKG.col_info_rec('NAV_NODE_USAGE_ID',NULL,X_TO_NAV_NODE_USAGE_ID,NULL)))
73: ),

Line 71: PER_RIC_PKG.ref_info_rec('HR_NAVIGATION_NODE_USAGES', PER_RIC_PKG.column_info_tbl(

67: p_entity_name => 'HR_NAVIGATION_PATHS',
68: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
69: PER_RIC_PKG.ref_info_rec('HR_NAVIGATION_NODE_USAGES', PER_RIC_PKG.column_info_tbl(
70: PER_RIC_PKG.col_info_rec('NAV_NODE_USAGE_ID',NULL,X_FROM_NAV_NODE_USAGE_ID,NULL))),
71: PER_RIC_PKG.ref_info_rec('HR_NAVIGATION_NODE_USAGES', PER_RIC_PKG.column_info_tbl(
72: PER_RIC_PKG.col_info_rec('NAV_NODE_USAGE_ID',NULL,X_TO_NAV_NODE_USAGE_ID,NULL)))
73: ),
74: p_ref_type => 'INS');
75:

Line 373: from HR_NAVIGATION_NODE_USAGES

369: where NAME = X_NODE_NAME_FROM;
370:
371: select NAV_NODE_USAGE_ID
372: into X_FROM_NAV_NODE_USAGE_ID
373: from HR_NAVIGATION_NODE_USAGES
374: where WORKFLOW_ID = X_WORKFLOW_ID
375: and NAV_NODE_ID = X_FROM_NAV_NODE_ID;
376:
377: exception

Line 395: from HR_NAVIGATION_NODE_USAGES

391: where NAME = X_NODE_NAME_TO;
392:
393: select NAV_NODE_USAGE_ID
394: into X_TO_NAV_NODE_USAGE_ID
395: from HR_NAVIGATION_NODE_USAGES
396: where WORKFLOW_ID = X_WORKFLOW_ID
397: and NAV_NODE_ID = X_TO_NAV_NODE_ID;
398:
399: exception

Line 485: from HR_NAVIGATION_NODE_USAGES

481: where NAME = X_NODE_NAME_FROM;
482:
483: select NAV_NODE_USAGE_ID
484: into X_FROM_NAV_NODE_USAGE_ID
485: from HR_NAVIGATION_NODE_USAGES
486: where WORKFLOW_ID = X_WORKFLOW_ID
487: and NAV_NODE_ID = X_FROM_NAV_NODE_ID;
488:
489: exception

Line 507: from HR_NAVIGATION_NODE_USAGES

503: where NAME = X_NODE_NAME_TO;
504:
505: select NAV_NODE_USAGE_ID
506: into X_TO_NAV_NODE_USAGE_ID
507: from HR_NAVIGATION_NODE_USAGES
508: where WORKFLOW_ID = X_WORKFLOW_ID
509: and NAV_NODE_ID = X_TO_NAV_NODE_ID;
510:
511: exception