DBA Data[Home] [Help]

APPS.HR_NAVIGATION_UNITS_LCT_PKG dependencies on HR_NAVIGATION_UNITS_S

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 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 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))