APPS.PQH_RFT_BUS dependencies on HR_API

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

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

Line 114: select nvl(enable_flag,hr_api.g_varchar2),

110: l_attribute_only_flag pqh_templates.attribute_only_flag%type;
111: l_freeze_status_cd pqh_templates.freeze_status_cd%type;
112: --
113: cursor c1 is
114: select nvl(enable_flag,hr_api.g_varchar2),
115: nvl(attribute_only_flag,hr_api.g_varchar2),
116: nvl(freeze_status_cd ,hr_api.g_varchar2)
117: from pqh_templates a
118: where a.template_id = p_base_template_id;

Line 115: nvl(attribute_only_flag,hr_api.g_varchar2),

111: l_freeze_status_cd pqh_templates.freeze_status_cd%type;
112: --
113: cursor c1 is
114: select nvl(enable_flag,hr_api.g_varchar2),
115: nvl(attribute_only_flag,hr_api.g_varchar2),
116: nvl(freeze_status_cd ,hr_api.g_varchar2)
117: from pqh_templates a
118: where a.template_id = p_base_template_id;
119: --

Line 116: nvl(freeze_status_cd ,hr_api.g_varchar2)

112: --
113: cursor c1 is
114: select nvl(enable_flag,hr_api.g_varchar2),
115: nvl(attribute_only_flag,hr_api.g_varchar2),
116: nvl(freeze_status_cd ,hr_api.g_varchar2)
117: from pqh_templates a
118: where a.template_id = p_base_template_id;
119: --
120: Begin

Line 129: and nvl(p_base_template_id,hr_api.g_number)

125: (p_ref_template_id => p_ref_template_id,
126: p_object_version_number => p_object_version_number);
127: --
128: if (l_api_updating
129: and nvl(p_base_template_id,hr_api.g_number)
130: <> nvl(pqh_rft_shd.g_old_rec.base_template_id,hr_api.g_number)
131: or not l_api_updating) then
132:
133: --

Line 130: <> nvl(pqh_rft_shd.g_old_rec.base_template_id,hr_api.g_number)

126: p_object_version_number => p_object_version_number);
127: --
128: if (l_api_updating
129: and nvl(p_base_template_id,hr_api.g_number)
130: <> nvl(pqh_rft_shd.g_old_rec.base_template_id,hr_api.g_number)
131: or not l_api_updating) then
132:
133: --
134: -- check if base_template_id value exists in pqh_templates table

Line 215: select nvl(freeze_status_cd,hr_api.g_varchar2) ,

211: l_freeze_status_cd pqh_templates.freeze_status_cd%type;
212: l_attribute_only_flag pqh_templates.attribute_only_flag%type;
213: --
214: cursor c1 is
215: select nvl(freeze_status_cd,hr_api.g_varchar2) ,
216: nvl(attribute_only_flag,hr_api.g_varchar2)
217: from pqh_templates a
218: where a.template_id = p_parent_template_id;
219: --

Line 216: nvl(attribute_only_flag,hr_api.g_varchar2)

212: l_attribute_only_flag pqh_templates.attribute_only_flag%type;
213: --
214: cursor c1 is
215: select nvl(freeze_status_cd,hr_api.g_varchar2) ,
216: nvl(attribute_only_flag,hr_api.g_varchar2)
217: from pqh_templates a
218: where a.template_id = p_parent_template_id;
219: --
220: Begin

Line 229: and nvl(p_parent_template_id,hr_api.g_number)

225: (p_ref_template_id => p_ref_template_id,
226: p_object_version_number => p_object_version_number);
227: --
228: if (l_api_updating
229: and nvl(p_parent_template_id,hr_api.g_number)
230: <> nvl(pqh_rft_shd.g_old_rec.parent_template_id,hr_api.g_number)
231: or not l_api_updating) and
232: p_parent_template_id is not null then
233: --

Line 230: <> nvl(pqh_rft_shd.g_old_rec.parent_template_id,hr_api.g_number)

226: p_object_version_number => p_object_version_number);
227: --
228: if (l_api_updating
229: and nvl(p_parent_template_id,hr_api.g_number)
230: <> nvl(pqh_rft_shd.g_old_rec.parent_template_id,hr_api.g_number)
231: or not l_api_updating) and
232: p_parent_template_id is not null then
233: --
234: -- check if parent_template_id value exists in pqh_templates table

Line 301: and nvl(p_base_template_id,hr_api.g_number)

297: (p_ref_template_id => p_ref_template_id,
298: p_object_version_number => p_object_version_number);
299: --
300: if (l_api_updating
301: and nvl(p_base_template_id,hr_api.g_number)
302: <> nvl(pqh_rft_shd.g_old_rec.base_template_id,hr_api.g_number)
303: or not l_api_updating) then
304: --
305: open c1(p_parent_template_id);

Line 302: <> nvl(pqh_rft_shd.g_old_rec.base_template_id,hr_api.g_number)

298: p_object_version_number => p_object_version_number);
299: --
300: if (l_api_updating
301: and nvl(p_base_template_id,hr_api.g_number)
302: <> nvl(pqh_rft_shd.g_old_rec.base_template_id,hr_api.g_number)
303: or not l_api_updating) then
304: --
305: open c1(p_parent_template_id);
306: fetch c1 into l_parent_leg_code, l_parent_template_name;

Line 381: <> nvl(pqh_rft_shd.g_old_rec.reference_type_cd,hr_api.g_varchar2)

377: p_object_version_number => p_object_version_number);
378: --
379: if (l_api_updating
380: and p_reference_type_cd
381: <> nvl(pqh_rft_shd.g_old_rec.reference_type_cd,hr_api.g_varchar2)
382: or not l_api_updating) then
383: --
384: -- check if value of lookup falls within lookup type.
385: --

Line 386: if hr_api.not_exists_in_hr_lookups

382: or not l_api_updating) then
383: --
384: -- check if value of lookup falls within lookup type.
385: --
386: if hr_api.not_exists_in_hr_lookups
387: (p_lookup_type => 'PQH_REFERENCE_TYPE',
388: p_lookup_code => p_reference_type_cd,
389: p_effective_date => p_effective_date) then
390: --

Line 458: and nvl(p_parent_template_id,hr_api.g_number)

454: (p_ref_template_id => p_ref_template_id,
455: p_object_version_number => p_object_version_number);
456: --
457: if (l_api_updating
458: and nvl(p_parent_template_id,hr_api.g_number)
459: <> nvl(pqh_rft_shd.g_old_rec.parent_template_id,hr_api.g_number)
460: or not l_api_updating) and
461: p_parent_template_id is not null then
462: --

Line 459: <> nvl(pqh_rft_shd.g_old_rec.parent_template_id,hr_api.g_number)

455: p_object_version_number => p_object_version_number);
456: --
457: if (l_api_updating
458: and nvl(p_parent_template_id,hr_api.g_number)
459: <> nvl(pqh_rft_shd.g_old_rec.parent_template_id,hr_api.g_number)
460: or not l_api_updating) and
461: p_parent_template_id is not null then
462: --
463: --