DBA Data[Home] [Help]

APPS.HR_NAVIGATION_NODE_USAGES_PKG dependencies on PER_RIC_PKG

Line 21: PER_RIC_PKG.chk_integrity (

17: -- Code Starts Here.
18: --
19:
20: BEGIN
21: PER_RIC_PKG.chk_integrity (
22: p_entity_name => 'HR_NAVIGATION_NODE_USAGES',
23: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
24: PER_RIC_PKG.ref_info_rec('HR_WORKFLOWS', PER_RIC_PKG.column_info_tbl(
25: PER_RIC_PKG.col_info_rec('WORKFLOW_ID',NULL,X_WORKFLOW_ID,NULL))),

Line 23: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(

19:
20: BEGIN
21: PER_RIC_PKG.chk_integrity (
22: p_entity_name => 'HR_NAVIGATION_NODE_USAGES',
23: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
24: PER_RIC_PKG.ref_info_rec('HR_WORKFLOWS', PER_RIC_PKG.column_info_tbl(
25: PER_RIC_PKG.col_info_rec('WORKFLOW_ID',NULL,X_WORKFLOW_ID,NULL))),
26: PER_RIC_PKG.ref_info_rec('HR_NAVIGATION_NODES', PER_RIC_PKG.column_info_tbl(
27: PER_RIC_PKG.col_info_rec('NAV_NODE_ID',NULL,X_NAV_NODE_ID,NULL)))

Line 24: PER_RIC_PKG.ref_info_rec('HR_WORKFLOWS', PER_RIC_PKG.column_info_tbl(

20: BEGIN
21: PER_RIC_PKG.chk_integrity (
22: p_entity_name => 'HR_NAVIGATION_NODE_USAGES',
23: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
24: PER_RIC_PKG.ref_info_rec('HR_WORKFLOWS', PER_RIC_PKG.column_info_tbl(
25: PER_RIC_PKG.col_info_rec('WORKFLOW_ID',NULL,X_WORKFLOW_ID,NULL))),
26: PER_RIC_PKG.ref_info_rec('HR_NAVIGATION_NODES', PER_RIC_PKG.column_info_tbl(
27: PER_RIC_PKG.col_info_rec('NAV_NODE_ID',NULL,X_NAV_NODE_ID,NULL)))
28: ),

Line 25: PER_RIC_PKG.col_info_rec('WORKFLOW_ID',NULL,X_WORKFLOW_ID,NULL))),

21: PER_RIC_PKG.chk_integrity (
22: p_entity_name => 'HR_NAVIGATION_NODE_USAGES',
23: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
24: PER_RIC_PKG.ref_info_rec('HR_WORKFLOWS', PER_RIC_PKG.column_info_tbl(
25: PER_RIC_PKG.col_info_rec('WORKFLOW_ID',NULL,X_WORKFLOW_ID,NULL))),
26: PER_RIC_PKG.ref_info_rec('HR_NAVIGATION_NODES', PER_RIC_PKG.column_info_tbl(
27: PER_RIC_PKG.col_info_rec('NAV_NODE_ID',NULL,X_NAV_NODE_ID,NULL)))
28: ),
29: p_ref_type => 'INS');

Line 26: PER_RIC_PKG.ref_info_rec('HR_NAVIGATION_NODES', PER_RIC_PKG.column_info_tbl(

22: p_entity_name => 'HR_NAVIGATION_NODE_USAGES',
23: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
24: PER_RIC_PKG.ref_info_rec('HR_WORKFLOWS', PER_RIC_PKG.column_info_tbl(
25: PER_RIC_PKG.col_info_rec('WORKFLOW_ID',NULL,X_WORKFLOW_ID,NULL))),
26: PER_RIC_PKG.ref_info_rec('HR_NAVIGATION_NODES', PER_RIC_PKG.column_info_tbl(
27: PER_RIC_PKG.col_info_rec('NAV_NODE_ID',NULL,X_NAV_NODE_ID,NULL)))
28: ),
29: p_ref_type => 'INS');
30:

Line 27: PER_RIC_PKG.col_info_rec('NAV_NODE_ID',NULL,X_NAV_NODE_ID,NULL)))

23: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
24: PER_RIC_PKG.ref_info_rec('HR_WORKFLOWS', PER_RIC_PKG.column_info_tbl(
25: PER_RIC_PKG.col_info_rec('WORKFLOW_ID',NULL,X_WORKFLOW_ID,NULL))),
26: PER_RIC_PKG.ref_info_rec('HR_NAVIGATION_NODES', PER_RIC_PKG.column_info_tbl(
27: PER_RIC_PKG.col_info_rec('NAV_NODE_ID',NULL,X_NAV_NODE_ID,NULL)))
28: ),
29: p_ref_type => 'INS');
30:
31: END;

Line 113: PER_RIC_PKG.chk_integrity (

109: -- Code Starts Here.
110: --
111:
112: BEGIN
113: PER_RIC_PKG.chk_integrity (
114: p_entity_name => 'HR_NAVIGATION_NODE_USAGES',
115: p_ref_entity => 'HR_NAVIGATION_PATHS',
116: p_ref_column_info => PER_RIC_PKG.column_info_tbl(
117: PER_RIC_PKG.col_info_rec('FROM_NAV_NODE_USAGE_ID',NULL,X_NAV_NODE_USAGE_ID,NULL) ,

Line 116: p_ref_column_info => PER_RIC_PKG.column_info_tbl(

112: BEGIN
113: PER_RIC_PKG.chk_integrity (
114: p_entity_name => 'HR_NAVIGATION_NODE_USAGES',
115: p_ref_entity => 'HR_NAVIGATION_PATHS',
116: p_ref_column_info => PER_RIC_PKG.column_info_tbl(
117: PER_RIC_PKG.col_info_rec('FROM_NAV_NODE_USAGE_ID',NULL,X_NAV_NODE_USAGE_ID,NULL) ,
118: PER_RIC_PKG.col_info_rec('TO_NAV_NODE_USAGE_ID',NULL,X_NAV_NODE_USAGE_ID,NULL)
119: ),
120: p_ref_type => 'DEL');

Line 117: PER_RIC_PKG.col_info_rec('FROM_NAV_NODE_USAGE_ID',NULL,X_NAV_NODE_USAGE_ID,NULL) ,

113: PER_RIC_PKG.chk_integrity (
114: p_entity_name => 'HR_NAVIGATION_NODE_USAGES',
115: p_ref_entity => 'HR_NAVIGATION_PATHS',
116: p_ref_column_info => PER_RIC_PKG.column_info_tbl(
117: PER_RIC_PKG.col_info_rec('FROM_NAV_NODE_USAGE_ID',NULL,X_NAV_NODE_USAGE_ID,NULL) ,
118: PER_RIC_PKG.col_info_rec('TO_NAV_NODE_USAGE_ID',NULL,X_NAV_NODE_USAGE_ID,NULL)
119: ),
120: p_ref_type => 'DEL');
121:

Line 118: PER_RIC_PKG.col_info_rec('TO_NAV_NODE_USAGE_ID',NULL,X_NAV_NODE_USAGE_ID,NULL)

114: p_entity_name => 'HR_NAVIGATION_NODE_USAGES',
115: p_ref_entity => 'HR_NAVIGATION_PATHS',
116: p_ref_column_info => PER_RIC_PKG.column_info_tbl(
117: PER_RIC_PKG.col_info_rec('FROM_NAV_NODE_USAGE_ID',NULL,X_NAV_NODE_USAGE_ID,NULL) ,
118: PER_RIC_PKG.col_info_rec('TO_NAV_NODE_USAGE_ID',NULL,X_NAV_NODE_USAGE_ID,NULL)
119: ),
120: p_ref_type => 'DEL');
121:
122: END;