DBA Data[Home] [Help]

APPS.HR_NAV_CONTEXT_RULES_PKG dependencies on HR_NAVIGATION_CONTEXT_RULES_S

Line 71: update HR_NAVIGATION_CONTEXT_RULES set

67: X_EVALUATION_TYPE_CODE in VARCHAR2,
68: X_VALUE in VARCHAR2
69: ) is
70: begin
71: update HR_NAVIGATION_CONTEXT_RULES set
72: GLOBAL_USAGE_ID = X_GLOBAL_USAGE_ID,
73: EVALUATION_TYPE_CODE = X_EVALUATION_TYPE_CODE,
74: VALUE = X_VALUE
75: where NAV_CONTEXT_RULE_ID = X_NAV_CONTEXT_RULE_ID;

Line 141: select HR_NAVIGATION_CONTEXT_RULES_S.NEXTVAL

137: and nvl(NCR.VALUE,hr_api.g_varchar2) = nvl(X_VALUE,hr_api.g_varchar2)
138: and NCR.GLOBAL_USAGE_ID = X_GLOBAL_USAGE_ID;
139: exception
140: when no_data_found then
141: select HR_NAVIGATION_CONTEXT_RULES_S.NEXTVAL
142: into X_NAV_CONTEXT_RULE_ID
143: from DUAL;
144:
145: INSERT_ROW(