119: select NAV_UNIT_ID
120: into X_NAV_UNIT_ID
121: from HR_NAVIGATION_UNITS
122: where FORM_NAME = X_NAV_FORM_NAME
123: and nvl(BLOCK_NAME,hr_api.g_varchar2) = nvl(X_BLOCK_NAME,hr_api.g_varchar2);
124: else
125: X_NAV_UNIT_ID := null;
126: end if;
127:
152: from PAY_CUSTOMIZED_RESTRICTIONS
153: where NAME = X_CUSTOMIZATION_NAME
154: and APPLICATION_ID = X_APPLICATION_ID
155: and FORM_NAME = X_CUSTOMIZED_FORM_NAME
156: and nvl(BUSINESS_GROUP_ID,hr_api.g_number) =
157: nvl(X_BUSINESS_GROUP_ID,hr_api.g_number)
158: and nvl(LEGISLATION_CODE,hr_api.g_varchar2) =
159: nvl(X_LEGISLATION_CODE,hr_api.g_varchar2);
160: EXCEPTION
153: where NAME = X_CUSTOMIZATION_NAME
154: and APPLICATION_ID = X_APPLICATION_ID
155: and FORM_NAME = X_CUSTOMIZED_FORM_NAME
156: and nvl(BUSINESS_GROUP_ID,hr_api.g_number) =
157: nvl(X_BUSINESS_GROUP_ID,hr_api.g_number)
158: and nvl(LEGISLATION_CODE,hr_api.g_varchar2) =
159: nvl(X_LEGISLATION_CODE,hr_api.g_varchar2);
160: EXCEPTION
161: when no_data_found then
154: and APPLICATION_ID = X_APPLICATION_ID
155: and FORM_NAME = X_CUSTOMIZED_FORM_NAME
156: and nvl(BUSINESS_GROUP_ID,hr_api.g_number) =
157: nvl(X_BUSINESS_GROUP_ID,hr_api.g_number)
158: and nvl(LEGISLATION_CODE,hr_api.g_varchar2) =
159: nvl(X_LEGISLATION_CODE,hr_api.g_varchar2);
160: EXCEPTION
161: when no_data_found then
162: X_CUSTOMIZED_RESTRICTION_ID := null;
155: and FORM_NAME = X_CUSTOMIZED_FORM_NAME
156: and nvl(BUSINESS_GROUP_ID,hr_api.g_number) =
157: nvl(X_BUSINESS_GROUP_ID,hr_api.g_number)
158: and nvl(LEGISLATION_CODE,hr_api.g_varchar2) =
159: nvl(X_LEGISLATION_CODE,hr_api.g_varchar2);
160: EXCEPTION
161: when no_data_found then
162: X_CUSTOMIZED_RESTRICTION_ID := null;
163: when others then