APPS.HR_NAVIGATION_NODE_USAGES_PKG dependencies on HR_NAVIGATION_NODE_USAGES

Line 1: package body HR_NAVIGATION_NODE_USAGES_PKG as

1: package body HR_NAVIGATION_NODE_USAGES_PKG as
2: /* $Header: hrnvnlct.pkb 115.3 2004/01/08 01:24:36 adudekul noship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out nocopy VARCHAR2,
5: X_NAV_NODE_USAGE_ID in NUMBER,

Line 10: cursor C is select ROWID from HR_NAVIGATION_NODE_USAGES

6: X_WORKFLOW_ID in NUMBER,
7: X_NAV_NODE_ID in NUMBER,
8: X_TOP_NODE in VARCHAR2
9: ) is
10: cursor C is select ROWID from HR_NAVIGATION_NODE_USAGES
11: where NAV_NODE_USAGE_ID = X_NAV_NODE_USAGE_ID
12: ;
13: begin
14: insert into HR_NAVIGATION_NODE_USAGES (

Line 14: insert into HR_NAVIGATION_NODE_USAGES (

10: cursor C is select ROWID from HR_NAVIGATION_NODE_USAGES
11: where NAV_NODE_USAGE_ID = X_NAV_NODE_USAGE_ID
12: ;
13: begin
14: insert into HR_NAVIGATION_NODE_USAGES (
15: NAV_NODE_USAGE_ID,
16: WORKFLOW_ID,
17: NAV_NODE_ID,
18: TOP_NODE

Line 45: from HR_NAVIGATION_NODE_USAGES

41: cursor c1 is select
42: WORKFLOW_ID,
43: NAV_NODE_ID,
44: TOP_NODE
45: from HR_NAVIGATION_NODE_USAGES
46: where NAV_NODE_USAGE_ID = X_NAV_NODE_USAGE_ID
47: for update of NAV_NODE_USAGE_ID nowait;
48: begin
49: for tlinfo in c1 loop

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 85: delete from HR_NAVIGATION_NODE_USAGES

81: procedure DELETE_ROW (
82: X_NAV_NODE_USAGE_ID in NUMBER
83: ) is
84: begin
85: delete from HR_NAVIGATION_NODE_USAGES
86: where NAV_NODE_USAGE_ID = X_NAV_NODE_USAGE_ID;
87:
88: if (sql%notfound) then
89: raise no_data_found;

Line 128: from HR_NAVIGATION_NODE_USAGES

124:
125: begin
126: select NAV_NODE_USAGE_ID
127: into X_NAV_NODE_USAGE_ID
128: from HR_NAVIGATION_NODE_USAGES
129: where WORKFLOW_ID = X_WORKFLOW_ID
130: and NAV_NODE_ID = X_NAV_NODE_ID
131: and TOP_NODE = X_TOP_NODE;
132: exception

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.

Line 171: end HR_NAVIGATION_NODE_USAGES_PKG;

167: end if;
168:
169: end LOAD_ROW;
170:
171: end HR_NAVIGATION_NODE_USAGES_PKG;