DBA Data[Home] [Help]

APPS.HR_NAVIGATION_NODE_USAGES_PKG dependencies on HR_NAVIGATION_NODE_USAGES_S

Line 91: update HR_NAVIGATION_NODE_USAGES set

87: X_NAV_NODE_ID in NUMBER,
88: X_TOP_NODE in VARCHAR2
89: ) is
90: begin
91: update HR_NAVIGATION_NODE_USAGES set
92: WORKFLOW_ID = X_WORKFLOW_ID,
93: NAV_NODE_ID = X_NAV_NODE_ID,
94: TOP_NODE = X_TOP_NODE
95: where NAV_NODE_USAGE_ID = X_NAV_NODE_USAGE_ID;

Line 175: select HR_NAVIGATION_NODE_USAGES_S.NEXTVAL

171: and NAV_NODE_ID = X_NAV_NODE_ID
172: and TOP_NODE = X_TOP_NODE;
173: exception
174: when no_data_found then
175: select HR_NAVIGATION_NODE_USAGES_S.NEXTVAL
176: into X_NAV_NODE_USAGE_ID
177: from dual;
178: --
179: -- Fix for bug 3274423 starts here.