APPS.HR_NAV_CONTEXT_RULES_PKG dependencies on HR_API

Line 116: and nvl(BLOCK_NAME,hr_api.g_varchar2) = nvl(X_BLOCK_NAME,hr_api.g_varchar2);

112: select NAV_UNIT_ID
113: into X_NAV_UNIT_ID
114: from HR_NAVIGATION_UNITS
115: where FORM_NAME = X_FORM_NAME
116: and nvl(BLOCK_NAME,hr_api.g_varchar2) = nvl(X_BLOCK_NAME,hr_api.g_varchar2);
117: end;
118:
119: select GLOBAL_USAGE_ID
120: into X_GLOBAL_USAGE_ID

Line 137: and nvl(NCR.VALUE,hr_api.g_varchar2) = nvl(X_VALUE,hr_api.g_varchar2)

133: select NCR.NAV_CONTEXT_RULE_ID
134: into X_NAV_CONTEXT_RULE_ID
135: from HR_NAVIGATION_CONTEXT_RULES NCR
136: where NCR.EVALUATION_TYPE_CODE = X_EVALUATION_TYPE_CODE
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