DBA Data[Home] [Help]

APPS.HR_WORKFLOWS_PKG dependencies on PER_RIC_PKG

Line 37: per_ric_pkg.Chk_integrity (

33: -- Added the following code as a part of Zero Downtime Patching Project.
34: -- Code Starts Here.
35: --
36: BEGIN
37: per_ric_pkg.Chk_integrity (
38: p_entity_name => 'HR_NAVIGATION_PATHS',
39: p_ref_entity => 'HR_NAVIGATION_PATHS_TL',
40: p_ref_column_name => 'NAV_PATH_ID',
41: p_ref_col_value_number => l_nav_path_id,

Line 62: per_ric_pkg.Chk_integrity (

58: -- Added the following code as a part of Zero Downtime Patching Project.
59: -- Code Starts Here.
60: --
61: BEGIN
62: per_ric_pkg.Chk_integrity (
63: p_entity_name => 'HR_NAVIGATION_NODE_USAGES',
64: p_ref_entity => 'HR_NAVIGATION_PATHS',
65: p_ref_column_info => PER_RIC_PKG.column_info_tbl(
66: PER_RIC_PKG.col_info_rec('FROM_NAV_NODE_USAGE_ID', NULL,l_nav_node_usage_id,NULL),

Line 65: p_ref_column_info => PER_RIC_PKG.column_info_tbl(

61: BEGIN
62: per_ric_pkg.Chk_integrity (
63: p_entity_name => 'HR_NAVIGATION_NODE_USAGES',
64: p_ref_entity => 'HR_NAVIGATION_PATHS',
65: p_ref_column_info => PER_RIC_PKG.column_info_tbl(
66: PER_RIC_PKG.col_info_rec('FROM_NAV_NODE_USAGE_ID', NULL,l_nav_node_usage_id,NULL),
67: PER_RIC_PKG.col_info_rec('TO_NAV_NODE_USAGE_ID', NULL, l_nav_node_usage_id, NULL)
68: ),
69: p_ref_type => 'DEL');

Line 66: PER_RIC_PKG.col_info_rec('FROM_NAV_NODE_USAGE_ID', NULL,l_nav_node_usage_id,NULL),

62: per_ric_pkg.Chk_integrity (
63: p_entity_name => 'HR_NAVIGATION_NODE_USAGES',
64: p_ref_entity => 'HR_NAVIGATION_PATHS',
65: p_ref_column_info => PER_RIC_PKG.column_info_tbl(
66: PER_RIC_PKG.col_info_rec('FROM_NAV_NODE_USAGE_ID', NULL,l_nav_node_usage_id,NULL),
67: PER_RIC_PKG.col_info_rec('TO_NAV_NODE_USAGE_ID', NULL, l_nav_node_usage_id, NULL)
68: ),
69: p_ref_type => 'DEL');
70: END;

Line 67: PER_RIC_PKG.col_info_rec('TO_NAV_NODE_USAGE_ID', NULL, l_nav_node_usage_id, NULL)

63: p_entity_name => 'HR_NAVIGATION_NODE_USAGES',
64: p_ref_entity => 'HR_NAVIGATION_PATHS',
65: p_ref_column_info => PER_RIC_PKG.column_info_tbl(
66: PER_RIC_PKG.col_info_rec('FROM_NAV_NODE_USAGE_ID', NULL,l_nav_node_usage_id,NULL),
67: PER_RIC_PKG.col_info_rec('TO_NAV_NODE_USAGE_ID', NULL, l_nav_node_usage_id, NULL)
68: ),
69: p_ref_type => 'DEL');
70: END;
71:

Line 163: PER_RIC_PKG.chk_integrity (

159: --
160:
161: BEGIN
162:
163: PER_RIC_PKG.chk_integrity (
164: p_entity_name => 'HR_WORKFLOWS',
165: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
166: PER_RIC_PKG.ref_info_rec('HR_NAVIGATION_UNITS', PER_RIC_PKG.column_info_tbl(
167: PER_RIC_PKG.col_info_rec('DEFAULT_WORKFLOW_ID',NULL,X_WORKFLOW_ID,NULL))),

Line 165: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(

161: BEGIN
162:
163: PER_RIC_PKG.chk_integrity (
164: p_entity_name => 'HR_WORKFLOWS',
165: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
166: PER_RIC_PKG.ref_info_rec('HR_NAVIGATION_UNITS', PER_RIC_PKG.column_info_tbl(
167: PER_RIC_PKG.col_info_rec('DEFAULT_WORKFLOW_ID',NULL,X_WORKFLOW_ID,NULL))),
168: PER_RIC_PKG.ref_info_rec('HR_NAVIGATION_NODE_USAGES', PER_RIC_PKG.column_info_tbl(
169: PER_RIC_PKG.col_info_rec('WORKFLOW_ID',NULL,X_WORKFLOW_ID,NULL)))),

Line 166: PER_RIC_PKG.ref_info_rec('HR_NAVIGATION_UNITS', PER_RIC_PKG.column_info_tbl(

162:
163: PER_RIC_PKG.chk_integrity (
164: p_entity_name => 'HR_WORKFLOWS',
165: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
166: PER_RIC_PKG.ref_info_rec('HR_NAVIGATION_UNITS', PER_RIC_PKG.column_info_tbl(
167: PER_RIC_PKG.col_info_rec('DEFAULT_WORKFLOW_ID',NULL,X_WORKFLOW_ID,NULL))),
168: PER_RIC_PKG.ref_info_rec('HR_NAVIGATION_NODE_USAGES', PER_RIC_PKG.column_info_tbl(
169: PER_RIC_PKG.col_info_rec('WORKFLOW_ID',NULL,X_WORKFLOW_ID,NULL)))),
170: p_ref_type => 'DEL');

Line 167: PER_RIC_PKG.col_info_rec('DEFAULT_WORKFLOW_ID',NULL,X_WORKFLOW_ID,NULL))),

163: PER_RIC_PKG.chk_integrity (
164: p_entity_name => 'HR_WORKFLOWS',
165: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
166: PER_RIC_PKG.ref_info_rec('HR_NAVIGATION_UNITS', PER_RIC_PKG.column_info_tbl(
167: PER_RIC_PKG.col_info_rec('DEFAULT_WORKFLOW_ID',NULL,X_WORKFLOW_ID,NULL))),
168: PER_RIC_PKG.ref_info_rec('HR_NAVIGATION_NODE_USAGES', PER_RIC_PKG.column_info_tbl(
169: PER_RIC_PKG.col_info_rec('WORKFLOW_ID',NULL,X_WORKFLOW_ID,NULL)))),
170: p_ref_type => 'DEL');
171:

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

164: p_entity_name => 'HR_WORKFLOWS',
165: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
166: PER_RIC_PKG.ref_info_rec('HR_NAVIGATION_UNITS', PER_RIC_PKG.column_info_tbl(
167: PER_RIC_PKG.col_info_rec('DEFAULT_WORKFLOW_ID',NULL,X_WORKFLOW_ID,NULL))),
168: PER_RIC_PKG.ref_info_rec('HR_NAVIGATION_NODE_USAGES', PER_RIC_PKG.column_info_tbl(
169: PER_RIC_PKG.col_info_rec('WORKFLOW_ID',NULL,X_WORKFLOW_ID,NULL)))),
170: p_ref_type => 'DEL');
171:
172: END;

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

165: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
166: PER_RIC_PKG.ref_info_rec('HR_NAVIGATION_UNITS', PER_RIC_PKG.column_info_tbl(
167: PER_RIC_PKG.col_info_rec('DEFAULT_WORKFLOW_ID',NULL,X_WORKFLOW_ID,NULL))),
168: PER_RIC_PKG.ref_info_rec('HR_NAVIGATION_NODE_USAGES', PER_RIC_PKG.column_info_tbl(
169: PER_RIC_PKG.col_info_rec('WORKFLOW_ID',NULL,X_WORKFLOW_ID,NULL)))),
170: p_ref_type => 'DEL');
171:
172: END;
173: