DBA Data[Home] [Help]

APPS.HR_NAV_UNIT_GLOBAL_USAGES_PKG dependencies on HR_NAV_UNIT_GLOBAL_USAGES_S

Line 97: update HR_NAV_UNIT_GLOBAL_USAGES set

93: X_IN_OR_OUT in VARCHAR2,
94: X_MANDATORY_FLAG in VARCHAR2
95: ) is
96: begin
97: update HR_NAV_UNIT_GLOBAL_USAGES set
98: NAV_UNIT_ID = X_NAV_UNIT_ID,
99: GLOBAL_NAME = X_GLOBAL_NAME,
100: IN_OR_OUT = X_IN_OR_OUT,
101: MANDATORY_FLAG = X_MANDATORY_FLAG

Line 189: select HR_NAV_UNIT_GLOBAL_USAGES_S.NEXTVAL

185: END IF;
186:
187: exception
188: when no_data_found then
189: select HR_NAV_UNIT_GLOBAL_USAGES_S.NEXTVAL
190: into X_GLOBAL_USAGE_ID
191: from DUAL;
192:
193: INSERT_ROW(