DBA Data[Home] [Help]

APPS.HR_NAVIGATION_PATHS_PKG dependencies on PER_RIC_PKG

Line 54: PER_RIC_PKG.chk_integrity (

50: --
51:
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) ,

Line 57: p_ref_column_info => PER_RIC_PKG.column_info_tbl(

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: ),
61: p_ref_type => 'INS');

Line 58: PER_RIC_PKG.col_info_rec('NAV_NODE_USAGE_ID',NULL,X_FROM_NAV_NODE_USAGE_ID,NULL) ,

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: ),
61: p_ref_type => 'INS');
62:

Line 59: PER_RIC_PKG.col_info_rec('NAV_NODE_USAGE_ID',NULL,X_TO_NAV_NODE_USAGE_ID,NULL)

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: ),
61: p_ref_type => 'INS');
62:
63: END;*/

Line 66: PER_RIC_PKG.chk_integrity (

62:
63: END;*/
64:
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))),

Line 68: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(

64:
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)))

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 70: PER_RIC_PKG.col_info_rec('NAV_NODE_USAGE_ID',NULL,X_FROM_NAV_NODE_USAGE_ID,NULL))),

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: ),
74: p_ref_type => 'INS');

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 72: PER_RIC_PKG.col_info_rec('NAV_NODE_USAGE_ID',NULL,X_TO_NAV_NODE_USAGE_ID,NULL)))

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:
76: END;

Line 107: PER_RIC_PKG.chk_integrity (

103: -- Code Starts Here.
104: --
105:
106: BEGIN
107: PER_RIC_PKG.chk_integrity (
108: p_entity_name => 'HR_NAVIGATION_PATHS_TL',
109: p_ref_entity => 'HR_NAVIGATION_PATHS',
110: p_ref_column_name => 'NAV_PATH_ID',
111: p_ref_col_value_number => X_NAV_PATH_ID,