DBA Data[Home] [Help]

APPS.HR_NAVIGATION_NODE_USAGES_PKG dependencies on HR_WORKFLOWS

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 146: if hr_workflows_pkg.g_load_taskflow <> 'N' then

142: X_NAV_NODE_ID NUMBER;
143: X_ROWID VARCHAR2(30);
144: begin
145:
146: if hr_workflows_pkg.g_load_taskflow <> 'N' then
147:
148: if X_WORKFLOW_NAME is not null then
149: select WORKFLOW_ID
150: into X_WORKFLOW_ID

Line 151: from HR_WORKFLOWS

147:
148: if X_WORKFLOW_NAME is not null then
149: select WORKFLOW_ID
150: into X_WORKFLOW_ID
151: from HR_WORKFLOWS
152: where WORKFLOW_NAME = X_WORKFLOW_NAME;
153: else
154: X_WORKFLOW_ID := null;
155: end if;