APPS.PQH_RLT_BUS dependencies on HR_API

Line 51: and nvl(p_routing_list_id,hr_api.g_number)

47: (p_routing_list_id => p_routing_list_id,
48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating
51: and nvl(p_routing_list_id,hr_api.g_number)
52: <> pqh_rlt_shd.g_old_rec.routing_list_id) then
53: --
54: -- raise error as PK has changed
55: --

Line 114: where nvl(routing_list_name,hr_api.g_varchar2) = nvl(p_routing_list_name,hr_api.g_varchar2);

110: --
111: cursor c1 is
112: select 'x'
113: from pqh_routing_lists
114: where nvl(routing_list_name,hr_api.g_varchar2) = nvl(p_routing_list_name,hr_api.g_varchar2);
115: Begin
116: --
117: hr_utility.set_location('Entering:'||l_proc, 5);
118: --

Line 124: and nvl(p_routing_list_name,hr_api.g_varchar2)

120: (p_routing_list_id => p_routing_list_id,
121: p_object_version_number => p_object_version_number);
122: --
123: if ((l_api_updating
124: and nvl(p_routing_list_name,hr_api.g_varchar2)
125: <> nvl(pqh_rlt_shd.g_old_rec.routing_list_name,hr_api.g_varchar2)) or not l_api_updating )then
126:
127: if p_routing_list_name is not null then
128: --

Line 125: <> nvl(pqh_rlt_shd.g_old_rec.routing_list_name,hr_api.g_varchar2)) or not l_api_updating )then

121: p_object_version_number => p_object_version_number);
122: --
123: if ((l_api_updating
124: and nvl(p_routing_list_name,hr_api.g_varchar2)
125: <> nvl(pqh_rlt_shd.g_old_rec.routing_list_name,hr_api.g_varchar2)) or not l_api_updating )then
126:
127: if p_routing_list_name is not null then
128: --
129: open c1;