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: --
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: --
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: --
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;