DBA Data[Home] [Help]

APPS.HR_NAVIGATION_NODE_USAGES_PKG dependencies on HR_NAVIGATION_NODE_USAGES_S

Line 70: update HR_NAVIGATION_NODE_USAGES set

66: X_NAV_NODE_ID in NUMBER,
67: X_TOP_NODE in VARCHAR2
68: ) is
69: begin
70: update HR_NAVIGATION_NODE_USAGES set
71: WORKFLOW_ID = X_WORKFLOW_ID,
72: NAV_NODE_ID = X_NAV_NODE_ID,
73: TOP_NODE = X_TOP_NODE
74: where NAV_NODE_USAGE_ID = X_NAV_NODE_USAGE_ID;

Line 134: select HR_NAVIGATION_NODE_USAGES_S.NEXTVAL

130: and NAV_NODE_ID = X_NAV_NODE_ID
131: and TOP_NODE = X_TOP_NODE;
132: exception
133: when no_data_found then
134: select HR_NAVIGATION_NODE_USAGES_S.NEXTVAL
135: into X_NAV_NODE_USAGE_ID
136: from dual;
137: --
138: -- Fix for bug 3274423 starts here.