DBA Data[Home] [Help]

APPS.HR_NAVIGATION_UNITS_PKG dependencies on HR_NAVIGATION_UNITS_S

Line 38: CURSOR C2 IS SELECT hr_navigation_units_s.nextval FROM sys.dual;

34: CURSOR C IS SELECT rowid FROM HR_NAVIGATION_UNITS
35:
36: WHERE nav_unit_id = X_Nav_Unit_Id;
37:
38: CURSOR C2 IS SELECT hr_navigation_units_s.nextval FROM sys.dual;
39: l_language_code varchar2(3);
40: BEGIN
41:
42: -- Validate the language parameter. l_language_code should be passed

Line 263: update HR_NAVIGATION_UNITS set

259: l_language_code := x_language_code;
260: hr_api.validate_language_code(p_language_code => l_language_code);
261:
262:
263: update HR_NAVIGATION_UNITS set
264: DEFAULT_WORKFLOW_ID = X_DEFAULT_WORKFLOW_ID,
265: APPLICATION_ABBREV = X_APPLICATION_ABBREV,
266: DEFAULT_LABEL = X_DEFAULT_LABEL,
267: FORM_NAME = X_FORM_NAME,

Line 426: select HR_NAVIGATION_UNITS_S.NEXTVAL

422: END IF;
423:
424: exception
425: when no_data_found then
426: select HR_NAVIGATION_UNITS_S.NEXTVAL
427: into X_NAV_UNIT_ID
428: from dual;
429:
430: INSERT_ROW(