APPS.HR_NAV_CONTEXT_RULES_PKG dependencies on HR_API

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

132: select NAV_UNIT_ID
133: into X_NAV_UNIT_ID
134: from HR_NAVIGATION_UNITS
135: where FORM_NAME = X_FORM_NAME
136: and nvl(BLOCK_NAME,hr_api.g_varchar2) = nvl(X_BLOCK_NAME,hr_api.g_varchar2);
137: end;
138:
139: select GLOBAL_USAGE_ID
140: into X_GLOBAL_USAGE_ID

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

153: select NCR.NAV_CONTEXT_RULE_ID
154: into X_NAV_CONTEXT_RULE_ID
155: from HR_NAVIGATION_CONTEXT_RULES NCR
156: where NCR.EVALUATION_TYPE_CODE = X_EVALUATION_TYPE_CODE
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