APPS.HR_NAVIGATION_NODES_PKG dependencies on HR_NAVIGATION_NODES

Line 1: package body HR_NAVIGATION_NODES_PKG as

1: package body HR_NAVIGATION_NODES_PKG as
2: /* $Header: hrdwnlct.pkb 120.1 2011/04/28 12:01:35 sidsaxen ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out nocopy VARCHAR2,
5: X_NAV_NODE_ID in NUMBER,

Line 10: cursor C is select ROWID from HR_NAVIGATION_NODES

6: X_NAV_UNIT_ID in NUMBER,
7: X_NAME in VARCHAR2,
8: X_CUSTOMIZED_RESTRICTION_ID in NUMBER
9: ) is
10: cursor C is select ROWID from HR_NAVIGATION_NODES
11: where NAV_NODE_ID = X_NAV_NODE_ID
12: ;
13: begin
14:

Line 23: p_entity_name => 'HR_NAVIGATION_NODES',

19:
20: BEGIN
21:
22: PER_RIC_PKG.chk_integrity (
23: p_entity_name => 'HR_NAVIGATION_NODES',
24: p_ref_entity => 'HR_NAVIGATION_UNITS',
25: p_ref_column_name => 'NAV_UNIT_ID',
26: p_ref_col_value_number => X_NAV_UNIT_ID,
27: p_ref_col_value_varchar => null,

Line 37: insert into HR_NAVIGATION_NODES (

33: --
34: -- Code Ends Here.
35: --
36:
37: insert into HR_NAVIGATION_NODES (
38: NAV_NODE_ID,
39: NAV_UNIT_ID,
40: NAME,
41: CUSTOMIZED_RESTRICTION_ID

Line 68: from HR_NAVIGATION_NODES

64: cursor c1 is select
65: NAV_UNIT_ID,
66: CUSTOMIZED_RESTRICTION_ID,
67: NAME
68: from HR_NAVIGATION_NODES
69: where NAV_NODE_ID = X_NAV_NODE_ID
70: for update of NAV_NODE_ID nowait;
71: begin
72: for tlinfo in c1 loop

Line 94: update HR_NAVIGATION_NODES set

90: X_NAME in VARCHAR2,
91: X_CUSTOMIZED_RESTRICTION_ID in NUMBER
92: ) is
93: begin
94: update HR_NAVIGATION_NODES set
95: NAV_UNIT_ID = X_NAV_UNIT_ID,
96: NAME = X_NAME,
97: CUSTOMIZED_RESTRICTION_ID = X_CUSTOMIZED_RESTRICTION_ID
98: where NAV_NODE_ID = X_NAV_NODE_ID;

Line 116: p_entity_name => 'HR_NAVIGATION_NODES',

112: -- Code Starts Here.
113: --
114: BEGIN
115: PER_RIC_PKG.chk_integrity (
116: p_entity_name => 'HR_NAVIGATION_NODES',
117: p_ref_entity => 'HR_NAVIGATION_NODE_USAGES',
118: p_ref_column_name => 'NAV_NODE_ID',
119: p_ref_col_value_number => X_NAV_NODE_ID,
120: p_ref_col_value_varchar => null,

Line 129: delete from HR_NAVIGATION_NODES

125: --
126: -- Code Ends Here.
127: --
128:
129: delete from HR_NAVIGATION_NODES
130: where NAV_NODE_ID = X_NAV_NODE_ID;
131:
132: if (sql%notfound) then
133: raise no_data_found;

Line 216: from HR_NAVIGATION_NODES

212:
213: begin
214: select NAV_NODE_ID, NAV_UNIT_ID, NAME, CUSTOMIZED_RESTRICTION_ID
215: into X_NAV_NODE_ID, Y_NAV_UNIT_ID, Y_NODE_NAME, Y_CUSTOMIZED_RESTRICTION_ID
216: from HR_NAVIGATION_NODES
217: where NAME = X_NODE_NAME;
218: --
219: -- Fix for bug 3274423 starts here.
220: -- Before updating the record, compare the database row with the row in ldt file.

Line 240: select HR_NAVIGATION_NODES_S.NEXTVAL

236: );
237: END IF;
238: exception
239: when no_data_found then
240: select HR_NAVIGATION_NODES_S.NEXTVAL
241: into X_NAV_NODE_ID
242: from DUAL;
243:
244: INSERT_ROW(

Line 262: end HR_NAVIGATION_NODES_PKG;

258: end if;
259:
260: end LOAD_ROW;
261:
262: end HR_NAVIGATION_NODES_PKG;