DBA Data[Home] [Help]

APPS.HR_NAV_CONTEXT_RULES_PKG dependencies on HR_NAVIGATION_CONTEXT_RULES_S

Line 91: update HR_NAVIGATION_CONTEXT_RULES set

87: X_EVALUATION_TYPE_CODE in VARCHAR2,
88: X_VALUE in VARCHAR2
89: ) is
90: begin
91: update HR_NAVIGATION_CONTEXT_RULES set
92: GLOBAL_USAGE_ID = X_GLOBAL_USAGE_ID,
93: EVALUATION_TYPE_CODE = X_EVALUATION_TYPE_CODE,
94: VALUE = X_VALUE
95: where NAV_CONTEXT_RULE_ID = X_NAV_CONTEXT_RULE_ID;

Line 161: select HR_NAVIGATION_CONTEXT_RULES_S.NEXTVAL

157: and nvl(NCR.VALUE,hr_api.g_varchar2) = nvl(X_VALUE,hr_api.g_varchar2)
158: and NCR.GLOBAL_USAGE_ID = X_GLOBAL_USAGE_ID;
159: exception
160: when no_data_found then
161: select HR_NAVIGATION_CONTEXT_RULES_S.NEXTVAL
162: into X_NAV_CONTEXT_RULE_ID
163: from DUAL;
164:
165: INSERT_ROW(