eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_TAT_BUS dependencies on PQH_TAT_SHD

Line 46: l_api_updating := pqh_tat_shd.api_updating

42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := pqh_tat_shd.api_updating
47: (p_template_attribute_id => p_template_attribute_id,
48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating

Line 52: <> pqh_tat_shd.g_old_rec.template_attribute_id) then

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: --
56: pqh_tat_shd.constraint_error('PQH_TEMPLATE_ATTRIBUTES_PK');

Line 56: pqh_tat_shd.constraint_error('PQH_TEMPLATE_ATTRIBUTES_PK');

52: <> pqh_tat_shd.g_old_rec.template_attribute_id) then
53: --
54: -- raise error as PK has changed
55: --
56: pqh_tat_shd.constraint_error('PQH_TEMPLATE_ATTRIBUTES_PK');
57: --
58: elsif not l_api_updating then
59: --
60: -- check if PK is null

Line 66: pqh_tat_shd.constraint_error('PQH_TEMPLATE_ATTRIBUTES_PK');

62: if p_template_attribute_id is not null then
63: --
64: -- raise error as PK is not null
65: --
66: pqh_tat_shd.constraint_error('PQH_TEMPLATE_ATTRIBUTES_PK');
67: --
68: end if;
69: --
70: end if;

Line 119: l_api_updating := pqh_tat_shd.api_updating

115: Begin
116: --
117: hr_utility.set_location('Entering:'||l_proc,5);
118: --
119: l_api_updating := pqh_tat_shd.api_updating
120: (p_template_attribute_id => p_template_attribute_id,
121: p_object_version_number => p_object_version_number);
122: --
123: if (l_api_updating

Line 125: <> nvl(pqh_tat_shd.g_old_rec.template_id,hr_api.g_number)

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

Line 141: pqh_tat_shd.constraint_error('PQH_TEMPLATE_ATTRIBUTES_FK2');

137: --
138: -- raise error as FK does not relate to PK in pqh_templates
139: -- table.
140: --
141: pqh_tat_shd.constraint_error('PQH_TEMPLATE_ATTRIBUTES_FK2');
142: --
143: end if;
144: --
145: close c1;

Line 211: l_api_updating := pqh_tat_shd.api_updating

207: Begin
208: --
209: hr_utility.set_location('Entering:'||l_proc,5);
210: --
211: l_api_updating := pqh_tat_shd.api_updating
212: (p_template_attribute_id => p_template_attribute_id,
213: p_object_version_number => p_object_version_number);
214: --
215: if (l_api_updating

Line 217: <> nvl(pqh_tat_shd.g_old_rec.attribute_id,hr_api.g_number)

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

Line 232: pqh_tat_shd.constraint_error('PQH_TEMPLATE_ATTRIBUTES_FK1');

228: --
229: -- raise error as FK does not relate to PK in pqh_attributes
230: -- table.
231: --
232: pqh_tat_shd.constraint_error('PQH_TEMPLATE_ATTRIBUTES_FK1');
233: --
234: end if;
235: --
236: close c1;

Line 322: l_api_updating := pqh_tat_shd.api_updating

318: Begin
319: --
320: hr_utility.set_location('Entering:'||l_proc,5);
321: --
322: l_api_updating := pqh_tat_shd.api_updating
323: (p_template_attribute_id => p_template_attribute_id,
324: p_object_version_number => p_object_version_number);
325: --
326: /**

Line 329: <> nvl(pqh_tat_shd.g_old_rec.attribute_id,hr_api.g_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: --
333: --

Line 392: l_api_updating := pqh_tat_shd.api_updating

388: --
389: hr_utility.set_location('Entering:'||l_proc,5);
390: --
391:
392: l_api_updating := pqh_tat_shd.api_updating
393: (p_template_attribute_id => p_template_attribute_id,
394: p_object_version_number => p_object_version_number);
395: --
396: if (l_api_updating

Line 398: <> nvl(pqh_tat_shd.g_old_rec.attribute_id,hr_api.g_number)

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;

Line 469: l_api_updating := pqh_tat_shd.api_updating

465: Begin
466: --
467: hr_utility.set_location('Entering:'||l_proc, 5);
468: --
469: l_api_updating := pqh_tat_shd.api_updating
470: (p_template_attribute_id => p_template_attribute_id,
471: p_object_version_number => p_object_version_number);
472: --
473: if (l_api_updating

Line 475: <> nvl(pqh_tat_shd.g_old_rec.edit_flag,hr_api.g_varchar2)

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.

Line 537: l_api_updating := pqh_tat_shd.api_updating

533: Begin
534: --
535: hr_utility.set_location('Entering:'||l_proc, 5);
536: --
537: l_api_updating := pqh_tat_shd.api_updating
538: (p_template_attribute_id => p_template_attribute_id,
539: p_object_version_number => p_object_version_number);
540: --
541: if (l_api_updating

Line 543: <> nvl(pqh_tat_shd.g_old_rec.view_flag,hr_api.g_varchar2)

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.

Line 605: l_api_updating := pqh_tat_shd.api_updating

601: Begin
602: --
603: hr_utility.set_location('Entering:'||l_proc, 5);
604: --
605: l_api_updating := pqh_tat_shd.api_updating
606: (p_template_attribute_id => p_template_attribute_id,
607: p_object_version_number => p_object_version_number);
608: --
609: if (l_api_updating

Line 611: <> nvl(pqh_tat_shd.g_old_rec.required_flag,hr_api.g_varchar2)

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.

Line 708: Procedure insert_validate(p_rec in pqh_tat_shd.g_rec_type

704: End chk_flags_mismatch;
705: -- ----------------------------------------------------------------------------
706: -- |---------------------------< insert_validate >----------------------------|
707: -- ----------------------------------------------------------------------------
708: Procedure insert_validate(p_rec in pqh_tat_shd.g_rec_type
709: ,p_effective_date in date) is
710: --
711: l_proc varchar2(72) := g_package||'insert_validate';
712: --

Line 777: Procedure update_validate(p_rec in pqh_tat_shd.g_rec_type

773: --
774: -- ----------------------------------------------------------------------------
775: -- |---------------------------< update_validate >----------------------------|
776: -- ----------------------------------------------------------------------------
777: Procedure update_validate(p_rec in pqh_tat_shd.g_rec_type
778: ,p_effective_date in date) is
779: --
780: l_proc varchar2(72) := g_package||'update_validate';
781: --

Line 846: Procedure delete_validate(p_rec in pqh_tat_shd.g_rec_type

842: --
843: -- ----------------------------------------------------------------------------
844: -- |---------------------------< delete_validate >----------------------------|
845: -- ----------------------------------------------------------------------------
846: Procedure delete_validate(p_rec in pqh_tat_shd.g_rec_type
847: ,p_effective_date in date) is
848: --
849: l_proc varchar2(72) := g_package||'delete_validate';
850: --