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 294: update HR_NAVIGATION_UNITS set

290: l_language_code := x_language_code;
291: hr_api.validate_language_code(p_language_code => l_language_code);
292:
293:
294: update HR_NAVIGATION_UNITS set
295: DEFAULT_WORKFLOW_ID = X_DEFAULT_WORKFLOW_ID,
296: APPLICATION_ABBREV = X_APPLICATION_ABBREV,
297: DEFAULT_LABEL = X_DEFAULT_LABEL,
298: FORM_NAME = X_FORM_NAME,

Line 481: select HR_NAVIGATION_UNITS_S.NEXTVAL

477: END IF;
478:
479: exception
480: when no_data_found then
481: select HR_NAVIGATION_UNITS_S.NEXTVAL
482: into X_NAV_UNIT_ID
483: from dual;
484:
485: INSERT_ROW(