DBA Data[Home] [Help]

APPS.HR_NAVIGATION_NODES_PKG dependencies on HR_API

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

162: select NAV_UNIT_ID
163: into X_NAV_UNIT_ID
164: from HR_NAVIGATION_UNITS
165: where FORM_NAME = X_NAV_FORM_NAME
166: and nvl(BLOCK_NAME,hr_api.g_varchar2) = nvl(X_BLOCK_NAME,hr_api.g_varchar2);
167: else
168: X_NAV_UNIT_ID := null;
169: end if;
170:

Line 199: and nvl(BUSINESS_GROUP_ID,hr_api.g_number) =

195: from PAY_CUSTOMIZED_RESTRICTIONS
196: where NAME = X_CUSTOMIZATION_NAME
197: and APPLICATION_ID = X_APPLICATION_ID
198: and FORM_NAME = X_CUSTOMIZED_FORM_NAME
199: and nvl(BUSINESS_GROUP_ID,hr_api.g_number) =
200: nvl(X_BUSINESS_GROUP_ID,hr_api.g_number)
201: and nvl(LEGISLATION_CODE,hr_api.g_varchar2) =
202: nvl(X_LEGISLATION_CODE,hr_api.g_varchar2);
203: EXCEPTION

Line 200: nvl(X_BUSINESS_GROUP_ID,hr_api.g_number)

196: where NAME = X_CUSTOMIZATION_NAME
197: and APPLICATION_ID = X_APPLICATION_ID
198: and FORM_NAME = X_CUSTOMIZED_FORM_NAME
199: and nvl(BUSINESS_GROUP_ID,hr_api.g_number) =
200: nvl(X_BUSINESS_GROUP_ID,hr_api.g_number)
201: and nvl(LEGISLATION_CODE,hr_api.g_varchar2) =
202: nvl(X_LEGISLATION_CODE,hr_api.g_varchar2);
203: EXCEPTION
204: when no_data_found then

Line 201: and nvl(LEGISLATION_CODE,hr_api.g_varchar2) =

197: and APPLICATION_ID = X_APPLICATION_ID
198: and FORM_NAME = X_CUSTOMIZED_FORM_NAME
199: and nvl(BUSINESS_GROUP_ID,hr_api.g_number) =
200: nvl(X_BUSINESS_GROUP_ID,hr_api.g_number)
201: and nvl(LEGISLATION_CODE,hr_api.g_varchar2) =
202: nvl(X_LEGISLATION_CODE,hr_api.g_varchar2);
203: EXCEPTION
204: when no_data_found then
205: X_CUSTOMIZED_RESTRICTION_ID := null;

Line 202: nvl(X_LEGISLATION_CODE,hr_api.g_varchar2);

198: and FORM_NAME = X_CUSTOMIZED_FORM_NAME
199: and nvl(BUSINESS_GROUP_ID,hr_api.g_number) =
200: nvl(X_BUSINESS_GROUP_ID,hr_api.g_number)
201: and nvl(LEGISLATION_CODE,hr_api.g_varchar2) =
202: nvl(X_LEGISLATION_CODE,hr_api.g_varchar2);
203: EXCEPTION
204: when no_data_found then
205: X_CUSTOMIZED_RESTRICTION_ID := null;
206: when others then