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_TEM_BUS dependencies on PQH_TEM_SHD

Line 46: l_api_updating := pqh_tem_shd.api_updating

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

Line 52: <> pqh_tem_shd.g_old_rec.template_id) then

48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating
51: and nvl(p_template_id,hr_api.g_number)
52: <> pqh_tem_shd.g_old_rec.template_id) then
53: --
54: -- raise error as PK has changed
55: --
56: pqh_tem_shd.constraint_error('PQH_TEMPLATES_PK');

Line 56: pqh_tem_shd.constraint_error('PQH_TEMPLATES_PK');

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

Line 66: pqh_tem_shd.constraint_error('PQH_TEMPLATES_PK');

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

Line 111: l_api_updating := pqh_tem_shd.api_updating

107: Begin
108: --
109: hr_utility.set_location('Entering:'||l_proc, 5);
110: --
111: l_api_updating := pqh_tem_shd.api_updating
112: (p_template_id => p_template_id,
113: p_object_version_number => p_object_version_number);
114: --
115: /** Updating but not the freeze status cd **/

Line 119: = nvl(pqh_tem_shd.g_old_rec.freeze_status_cd,hr_api.g_varchar2)) then

115: /** Updating but not the freeze status cd **/
116: --
117: if (l_api_updating
118: and nvl(p_freeze_status_cd,hr_api.g_varchar2)
119: = nvl(pqh_tem_shd.g_old_rec.freeze_status_cd,hr_api.g_varchar2)) then
120: --
121: if nvl(pqh_tem_shd.g_old_rec.freeze_status_cd,hr_api.g_varchar2)
122: = 'FREEZE_TEMPLATE' then
123: hr_utility.set_message(8302,'PQH_NO_UPD_FROZEN_TEM');

Line 121: if nvl(pqh_tem_shd.g_old_rec.freeze_status_cd,hr_api.g_varchar2)

117: if (l_api_updating
118: and nvl(p_freeze_status_cd,hr_api.g_varchar2)
119: = nvl(pqh_tem_shd.g_old_rec.freeze_status_cd,hr_api.g_varchar2)) then
120: --
121: if nvl(pqh_tem_shd.g_old_rec.freeze_status_cd,hr_api.g_varchar2)
122: = 'FREEZE_TEMPLATE' then
123: hr_utility.set_message(8302,'PQH_NO_UPD_FROZEN_TEM');
124: hr_utility.raise_error;
125: End if;

Line 182: l_api_updating := pqh_tem_shd.api_updating

178: --
179: hr_utility.set_location('Entering:'||l_proc,5);
180: --
181:
182: l_api_updating := pqh_tem_shd.api_updating
183: (p_template_id => p_template_id,
184: p_object_version_number => p_object_version_number);
185: --
186: if (l_api_updating

Line 188: <> nvl(pqh_tem_shd.g_old_rec.transaction_category_id,hr_api.g_number)) then

184: p_object_version_number => p_object_version_number);
185: --
186: if (l_api_updating
187: and nvl(p_transaction_category_id,hr_api.g_number)
188: <> nvl(pqh_tem_shd.g_old_rec.transaction_category_id,hr_api.g_number)) then
189:
190: open c1;
191: Fetch c1 into l_dummy1;
192: if c1%found then

Line 258: l_api_updating := pqh_tem_shd.api_updating

254: --
255: hr_utility.set_location('Entering:'||l_proc,5);
256: --
257:
258: l_api_updating := pqh_tem_shd.api_updating
259: (p_template_id => p_template_id,
260: p_object_version_number => p_object_version_number);
261: --
262: if (l_api_updating

Line 264: <> nvl(pqh_tem_shd.g_old_rec.transaction_category_id,hr_api.g_number)

260: p_object_version_number => p_object_version_number);
261: --
262: if (l_api_updating
263: and nvl(p_transaction_category_id,hr_api.g_number)
264: <> nvl(pqh_tem_shd.g_old_rec.transaction_category_id,hr_api.g_number)
265: or not l_api_updating) then
266: --
267: -- check if transaction_category_id value exists in
268: -- pqh_transaction_categories table

Line 281: pqh_tem_shd.constraint_error('PQH_TEMPLATES_FK');

277: --
278: -- raise error as FK does not relate to PK in pqh_transaction_categories
279: -- table.
280: --
281: pqh_tem_shd.constraint_error('PQH_TEMPLATES_FK');
282: --
283: end if;
284: --
285: close c1;

Line 346: l_api_updating := pqh_tem_shd.api_updating

342: --
343: hr_utility.set_location('Entering:'||l_proc,5);
344: --
345:
346: l_api_updating := pqh_tem_shd.api_updating
347: (p_template_id => p_template_id,
348: p_object_version_number => p_object_version_number);
349: --
350: if (l_api_updating

Line 352: <> nvl(pqh_tem_shd.g_old_rec.legislation_code,hr_api.g_varchar2)

348: p_object_version_number => p_object_version_number);
349: --
350: if (l_api_updating
351: and nvl(p_legislation_code,hr_api.g_varchar2)
352: <> nvl(pqh_tem_shd.g_old_rec.legislation_code,hr_api.g_varchar2)
353: or not l_api_updating) then
354: --
355: -- check if legislation_code value exists in
356: -- fnd_territories_vl table

Line 369: pqh_tem_shd.constraint_error('PQH_TEMPLATES_FK2');

365: --
366: -- raise error as FK does not relate to PK in fnd_territories_vl
367: -- table.
368: --
369: pqh_tem_shd.constraint_error('PQH_TEMPLATES_FK2');
370: --
371: end if;
372: --
373: close c1;

Line 431: l_api_updating := pqh_tem_shd.api_updating

427: Begin
428: --
429: hr_utility.set_location('Entering:'||l_proc, 5);
430: --
431: l_api_updating := pqh_tem_shd.api_updating
432: (p_template_id => p_template_id,
433: p_object_version_number => p_object_version_number);
434: --
435: if (l_api_updating

Line 437: <> pqh_tem_shd.g_old_rec.template_name)

433: p_object_version_number => p_object_version_number);
434: --
435: if (l_api_updating
436: and nvl(p_template_name,hr_api.g_varchar2)
437: <> pqh_tem_shd.g_old_rec.template_name)
438: or not l_api_updating then
439: --
440: chk_template_name_unique
441: (p_template_id => p_template_id,

Line 529: l_api_updating := pqh_tem_shd.api_updating

525: Begin
526: --
527: hr_utility.set_location('Entering:'||l_proc, 5);
528: --
529: l_api_updating := pqh_tem_shd.api_updating
530: (p_template_id => p_template_id,
531: p_object_version_number => p_object_version_number);
532: --
533: if (l_api_updating

Line 535: <> nvl(pqh_tem_shd.g_old_rec.under_review_flag,hr_api.g_varchar2)

531: p_object_version_number => p_object_version_number);
532: --
533: if (l_api_updating
534: and p_under_review_flag
535: <> nvl(pqh_tem_shd.g_old_rec.under_review_flag,hr_api.g_varchar2)
536: or not l_api_updating)
537: and p_under_review_flag is not null then
538: --
539: -- check if value of lookup falls within lookup type.

Line 653: l_api_updating := pqh_tem_shd.api_updating

649: Begin
650: --
651: hr_utility.set_location('Entering:'||l_proc, 5);
652: --
653: l_api_updating := pqh_tem_shd.api_updating
654: (p_template_id => p_template_id,
655: p_object_version_number => p_object_version_number);
656: --
657: if (l_api_updating

Line 659: <> nvl(pqh_tem_shd.g_old_rec.create_flag,hr_api.g_varchar2)

655: p_object_version_number => p_object_version_number);
656: --
657: if (l_api_updating
658: and p_create_flag
659: <> nvl(pqh_tem_shd.g_old_rec.create_flag,hr_api.g_varchar2)
660: or not l_api_updating) and
661: p_create_flag is not null then
662: --
663: -- check if value of lookup falls within lookup type.

Line 684: <> nvl(pqh_tem_shd.g_old_rec.create_flag,hr_api.g_varchar2) then

680: -- template was used in any transaction.
681: --
682: if l_api_updating AND
683: nvl(p_create_flag,hr_api.g_varchar2)
684: <> nvl(pqh_tem_shd.g_old_rec.create_flag,hr_api.g_varchar2) then
685: --
686: l_applied_flag := chk_if_template_applied(p_template_id => p_template_id);
687: --
688: If l_applied_flag = 'Y' then

Line 765: l_api_updating := pqh_tem_shd.api_updating

761: Begin
762: --
763: hr_utility.set_location('Entering:'||l_proc, 5);
764: --
765: l_api_updating := pqh_tem_shd.api_updating
766: (p_template_id => p_template_id,
767: p_object_version_number => p_object_version_number);
768: --
769: if (l_api_updating

Line 771: <> nvl(pqh_tem_shd.g_old_rec.enable_flag,hr_api.g_varchar2)

767: p_object_version_number => p_object_version_number);
768: --
769: if (l_api_updating
770: and p_enable_flag
771: <> nvl(pqh_tem_shd.g_old_rec.enable_flag,hr_api.g_varchar2)
772: or not l_api_updating)
773: and p_enable_flag is not null then
774: --
775: -- check if value of lookup falls within lookup type.

Line 879: l_api_updating := pqh_tem_shd.api_updating

875: Begin
876: --
877: hr_utility.set_location('Entering:'||l_proc, 5);
878: --
879: l_api_updating := pqh_tem_shd.api_updating
880: (p_template_id => p_template_id,
881: p_object_version_number => p_object_version_number);
882: --
883: if (l_api_updating

Line 885: <> nvl(pqh_tem_shd.g_old_rec.attribute_only_flag,hr_api.g_varchar2)

881: p_object_version_number => p_object_version_number);
882: --
883: if (l_api_updating
884: and p_attribute_only_flag
885: <> nvl(pqh_tem_shd.g_old_rec.attribute_only_flag,hr_api.g_varchar2)
886: or not l_api_updating)
887: and p_attribute_only_flag is not null then
888: --
889: -- check if value of lookup falls within lookup type.

Line 910: <> nvl(pqh_tem_shd.g_old_rec.attribute_only_flag,hr_api.g_varchar2)) then

906: -- exist for the current template.
907: --
908: if (l_api_updating
909: and nvl(p_attribute_only_flag,hr_api.g_varchar2)
910: <> nvl(pqh_tem_shd.g_old_rec.attribute_only_flag,hr_api.g_varchar2)) then
911: --
912: if nvl(p_attribute_only_flag,hr_api.g_varchar2) = 'Y' then
913: --
914: -- Check if the attribute_only_flag is being updated to 'Y'

Line 972: l_api_updating := pqh_tem_shd.api_updating

968: Begin
969: --
970: hr_utility.set_location('Entering:'||l_proc, 5);
971: --
972: l_api_updating := pqh_tem_shd.api_updating
973: (p_template_id => p_template_id,
974: p_object_version_number => p_object_version_number);
975: --
976: if (l_api_updating

Line 978: <> nvl(pqh_tem_shd.g_old_rec.freeze_status_cd,hr_api.g_varchar2)

974: p_object_version_number => p_object_version_number);
975: --
976: if (l_api_updating
977: and p_freeze_status_cd
978: <> nvl(pqh_tem_shd.g_old_rec.freeze_status_cd,hr_api.g_varchar2)
979: or not l_api_updating)
980: and p_freeze_status_cd is not null then
981: --
982: -- check if value of lookup falls within lookup type.

Line 1043: l_api_updating := pqh_tem_shd.api_updating

1039: Begin
1040: --
1041: hr_utility.set_location('Entering:'||l_proc, 5);
1042: --
1043: l_api_updating := pqh_tem_shd.api_updating
1044: (p_template_id => p_template_id,
1045: p_object_version_number => p_object_version_number);
1046: --
1047: if (l_api_updating

Line 1049: <> nvl(pqh_tem_shd.g_old_rec.template_type_cd,hr_api.g_varchar2)

1045: p_object_version_number => p_object_version_number);
1046: --
1047: if (l_api_updating
1048: and p_template_type_cd
1049: <> nvl(pqh_tem_shd.g_old_rec.template_type_cd,hr_api.g_varchar2)
1050: or not l_api_updating)
1051: and p_template_type_cd is not null then
1052: --
1053: -- check if value of lookup falls within lookup type.

Line 1075: <> nvl(pqh_tem_shd.g_old_rec.template_type_cd,hr_api.g_varchar2) then

1071: -- template was used in any transaction.
1072: --
1073: if l_api_updating AND
1074: nvl(p_template_type_cd,hr_api.g_varchar2)
1075: <> nvl(pqh_tem_shd.g_old_rec.template_type_cd,hr_api.g_varchar2) then
1076: --
1077: l_applied_flag := chk_if_template_applied(p_template_id => p_template_id);
1078: --
1079: If l_applied_flag = 'Y' then

Line 1609: l_api_updating := pqh_tem_shd.api_updating

1605: Begin
1606: --
1607: hr_utility.set_location('Entering:'||l_proc, 5);
1608: --
1609: l_api_updating := pqh_tem_shd.api_updating
1610: (p_template_id => p_template_id,
1611: p_object_version_number => p_object_version_number);
1612: --
1613: if (l_api_updating

Line 1615: <> nvl(pqh_tem_shd.g_old_rec.freeze_status_cd,hr_api.g_varchar2)

1611: p_object_version_number => p_object_version_number);
1612: --
1613: if (l_api_updating
1614: and nvl(p_freeze_status_cd,hr_api.g_varchar2)
1615: <> nvl(pqh_tem_shd.g_old_rec.freeze_status_cd,hr_api.g_varchar2)
1616: ) then
1617: --
1618: --
1619: if p_freeze_status_cd = 'FREEZE_TEMPLATE' then

Line 1656: Procedure insert_validate(p_rec in pqh_tem_shd.g_rec_type

1652: --
1653: -- ----------------------------------------------------------------------------
1654: -- |---------------------------< insert_validate >----------------------------|
1655: -- ----------------------------------------------------------------------------
1656: Procedure insert_validate(p_rec in pqh_tem_shd.g_rec_type
1657: ,p_effective_date in date) is
1658: --
1659: l_proc varchar2(72) := g_package||'insert_validate';
1660: --

Line 1734: Procedure update_validate(p_rec in pqh_tem_shd.g_rec_type

1730: --
1731: -- ----------------------------------------------------------------------------
1732: -- |---------------------------< update_validate >----------------------------|
1733: -- ----------------------------------------------------------------------------
1734: Procedure update_validate(p_rec in pqh_tem_shd.g_rec_type
1735: ,p_effective_date in date) is
1736: --
1737: l_proc varchar2(72) := g_package||'update_validate';
1738: --

Line 1827: Procedure delete_validate(p_rec in pqh_tem_shd.g_rec_type

1823: --
1824: -- ----------------------------------------------------------------------------
1825: -- |---------------------------< delete_validate >----------------------------|
1826: -- ----------------------------------------------------------------------------
1827: Procedure delete_validate(p_rec in pqh_tem_shd.g_rec_type
1828: ,p_effective_date in date) is
1829: --
1830: l_proc varchar2(72) := g_package||'delete_validate';
1831: --