DBA Data[Home] [Help]

APPS.HR_NAVIGATION_NODES_PKG dependencies on HR_API

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

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:

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

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

Line 157: nvl(X_BUSINESS_GROUP_ID,hr_api.g_number)

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

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

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;

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

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