APPS.HR_NAVIGATION_UNITS_LCT_PKG dependencies on HR_NAVIGATION_UNITS

Line 1: package body HR_NAVIGATION_UNITS_LCT_PKG as

1: package body HR_NAVIGATION_UNITS_LCT_PKG as
2: /* $Header: penut01t.pkb 115.3 1999/11/05 01:37:54 pkm ship $ */
3:
4: procedure INSERT_ROW (
5: X_NAV_UNIT_ID in out NUMBER,

Line 14: select HR_NAVIGATION_UNITS_S.nextval

10: X_MAX_NUMBER_OF_NAV_BUTTONS in NUMBER,
11: X_DEFAULT_LABEL in VARCHAR2
12: ) is
13: cursor CSR_SEQUENCE is
14: select HR_NAVIGATION_UNITS_S.nextval
15: from dual;
16: begin
17: if X_NAV_UNIT_ID is null then
18: open CSR_SEQUENCE;

Line 22: insert into HR_NAVIGATION_UNITS (

18: open CSR_SEQUENCE;
19: fetch CSR_SEQUENCE into X_NAV_UNIT_ID;
20: close CSR_SEQUENCE;
21: end if;
22: insert into HR_NAVIGATION_UNITS (
23: NAV_UNIT_ID,
24: FORM_NAME,
25: BLOCK_NAME,
26: DEFAULT_WORKFLOW_ID,

Line 57: from HR_NAVIGATION_UNITS

53: BLOCK_NAME,
54: DEFAULT_WORKFLOW_ID,
55: APPLICATION_ABBREV,
56: MAX_NUMBER_OF_NAV_BUTTONS
57: from HR_NAVIGATION_UNITS
58: where NAV_UNIT_ID = X_NAV_UNIT_ID
59: for update of NAV_UNIT_ID nowait;
60: RECINFO CSR_NAVIGATION_UNIT%rowtype;
61: begin

Line 98: update HR_NAVIGATION_UNITS set

94: X_MAX_NUMBER_OF_NAV_BUTTONS in NUMBER,
95: X_DEFAULT_LABEL in VARCHAR2
96: ) is
97: begin
98: update HR_NAVIGATION_UNITS set
99: FORM_NAME = X_FORM_NAME,
100: BLOCK_NAME = X_BLOCK_NAME,
101: DEFAULT_WORKFLOW_ID = X_DEFAULT_WORKFLOW_ID,
102: APPLICATION_ABBREV = X_APPLICATION_ABBREV,

Line 115: delete from HR_NAVIGATION_UNITS

111: procedure DELETE_ROW (
112: X_NAV_UNIT_ID in NUMBER
113: ) is
114: begin
115: delete from HR_NAVIGATION_UNITS
116: where NAV_UNIT_ID = X_NAV_UNIT_ID;
117: if (sql%notfound) then
118: raise no_data_found;
119: end if;

Line 136: from HR_NAVIGATION_UNITS

132: X_FORM_NAME in VARCHAR2,
133: X_BLOCK_NAME in VARCHAR2
134: ) is
135: select NAV_UNIT_ID
136: from HR_NAVIGATION_UNITS
137: where FORM_NAME = X_FORM_NAME
138: and ( (BLOCK_NAME = X_BLOCK_NAME)
139: or (BLOCK_NAME is null and X_BLOCK_NAME is null));
140: cursor CSR_WORKFLOW (

Line 186: update HR_NAVIGATION_UNITS set

182: X_DEFAULT_LABEL in VARCHAR2,
183: X_OWNER in VARCHAR2
184: ) is
185: begin
186: update HR_NAVIGATION_UNITS set
187: DEFAULT_LABEL = X_DEFAULT_LABEL
188: where FORM_NAME = X_FORM_NAME
189: and ( (BLOCK_NAME = X_BLOCK_NAME)
190: or (BLOCK_NAME is null and X_BLOCK_NAME is null))

Line 196: end HR_NAVIGATION_UNITS_LCT_PKG;

192: from FND_LANGUAGES
193: where INSTALLED_FLAG = 'B');
194: end TRANSLATE_ROW;
195: --
196: end HR_NAVIGATION_UNITS_LCT_PKG;