47: (p_template_attribute_id => p_template_attribute_id,
48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating
51: and nvl(p_template_attribute_id,hr_api.g_number)
52: <> pqh_tat_shd.g_old_rec.template_attribute_id) then
53: --
54: -- raise error as PK has changed
55: --
120: (p_template_attribute_id => p_template_attribute_id,
121: p_object_version_number => p_object_version_number);
122: --
123: if (l_api_updating
124: and nvl(p_template_id,hr_api.g_number)
125: <> nvl(pqh_tat_shd.g_old_rec.template_id,hr_api.g_number)
126: or not l_api_updating) then
127: --
128: -- check if template_id value exists in pqh_templates table
121: p_object_version_number => p_object_version_number);
122: --
123: if (l_api_updating
124: and nvl(p_template_id,hr_api.g_number)
125: <> nvl(pqh_tat_shd.g_old_rec.template_id,hr_api.g_number)
126: or not l_api_updating) then
127: --
128: -- check if template_id value exists in pqh_templates table
129: --
212: (p_template_attribute_id => p_template_attribute_id,
213: p_object_version_number => p_object_version_number);
214: --
215: if (l_api_updating
216: and nvl(p_attribute_id,hr_api.g_number)
217: <> nvl(pqh_tat_shd.g_old_rec.attribute_id,hr_api.g_number)
218: or not l_api_updating) then
219: --
220: -- check if attribute_id value exists in pqh_attributes table
213: p_object_version_number => p_object_version_number);
214: --
215: if (l_api_updating
216: and nvl(p_attribute_id,hr_api.g_number)
217: <> nvl(pqh_tat_shd.g_old_rec.attribute_id,hr_api.g_number)
218: or not l_api_updating) then
219: --
220: -- check if attribute_id value exists in pqh_attributes table
221: --
324: p_object_version_number => p_object_version_number);
325: --
326: /**
327: if (l_api_updating
328: and nvl(p_attribute_id,hr_api.g_number)
329: <> nvl(pqh_tat_shd.g_old_rec.attribute_id,hr_api.g_number)
330: or not l_api_updating) then
331: **/
332: --
325: --
326: /**
327: if (l_api_updating
328: and nvl(p_attribute_id,hr_api.g_number)
329: <> nvl(pqh_tat_shd.g_old_rec.attribute_id,hr_api.g_number)
330: or not l_api_updating) then
331: **/
332: --
333: --
393: (p_template_attribute_id => p_template_attribute_id,
394: p_object_version_number => p_object_version_number);
395: --
396: if (l_api_updating
397: and nvl(p_attribute_id,hr_api.g_number)
398: <> nvl(pqh_tat_shd.g_old_rec.attribute_id,hr_api.g_number)
399: or not l_api_updating) then
400: --
401: open c_template_leg_code;
394: p_object_version_number => p_object_version_number);
395: --
396: if (l_api_updating
397: and nvl(p_attribute_id,hr_api.g_number)
398: <> nvl(pqh_tat_shd.g_old_rec.attribute_id,hr_api.g_number)
399: or not l_api_updating) then
400: --
401: open c_template_leg_code;
402: fetch c_template_leg_code into l_template_leg_code, l_template_name;
471: p_object_version_number => p_object_version_number);
472: --
473: if (l_api_updating
474: and p_edit_flag
475: <> nvl(pqh_tat_shd.g_old_rec.edit_flag,hr_api.g_varchar2)
476: or not l_api_updating)
477: and p_edit_flag is not null then
478: --
479: -- check if value of lookup falls within lookup type.
477: and p_edit_flag is not null then
478: --
479: -- check if value of lookup falls within lookup type.
480: --
481: if hr_api.not_exists_in_hr_lookups
482: (p_lookup_type => 'YES_NO',
483: p_lookup_code => p_edit_flag,
484: p_effective_date => p_effective_date) then
485: --
539: p_object_version_number => p_object_version_number);
540: --
541: if (l_api_updating
542: and p_view_flag
543: <> nvl(pqh_tat_shd.g_old_rec.view_flag,hr_api.g_varchar2)
544: or not l_api_updating)
545: and p_view_flag is not null then
546: --
547: -- check if value of lookup falls within lookup type.
545: and p_view_flag is not null then
546: --
547: -- check if value of lookup falls within lookup type.
548: --
549: if hr_api.not_exists_in_hr_lookups
550: (p_lookup_type => 'YES_NO',
551: p_lookup_code => p_view_flag,
552: p_effective_date => p_effective_date) then
553: --
607: p_object_version_number => p_object_version_number);
608: --
609: if (l_api_updating
610: and p_required_flag
611: <> nvl(pqh_tat_shd.g_old_rec.required_flag,hr_api.g_varchar2)
612: or not l_api_updating)
613: and p_required_flag is not null then
614: --
615: -- check if value of lookup falls within lookup type.
613: and p_required_flag is not null then
614: --
615: -- check if value of lookup falls within lookup type.
616: --
617: if hr_api.not_exists_in_hr_lookups
618: (p_lookup_type => 'YES_NO',
619: p_lookup_code => p_required_flag,
620: p_effective_date => p_effective_date) then
621: --