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 HR_API

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

47: (p_template_id => p_template_id,
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: --

Line 118: and nvl(p_freeze_status_cd,hr_api.g_varchar2)

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

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 187: and nvl(p_transaction_category_id,hr_api.g_number)

183: (p_template_id => p_template_id,
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;

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 249: select nvl(freeze_status_cd,hr_api.g_varchar2)

245: l_dummy varchar2(1);
246: l_freeze_status_cd pqh_transaction_categories.freeze_status_cd%type;
247: --
248: cursor c1 is
249: select nvl(freeze_status_cd,hr_api.g_varchar2)
250: from pqh_transaction_categories_vl a
251: where a.transaction_category_id = p_transaction_category_id;
252: --
253: Begin

Line 263: and nvl(p_transaction_category_id,hr_api.g_number)

259: (p_template_id => p_template_id,
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

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 351: and nvl(p_legislation_code,hr_api.g_varchar2)

347: (p_template_id => p_template_id,
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

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 436: and nvl(p_template_name,hr_api.g_varchar2)

432: (p_template_id => p_template_id,
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

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 541: if hr_api.not_exists_in_hr_lookups

537: and p_under_review_flag is not null then
538: --
539: -- check if value of lookup falls within lookup type.
540: --
541: if hr_api.not_exists_in_hr_lookups
542: (p_lookup_type => 'YES_NO',
543: p_lookup_code => p_under_review_flag,
544: p_effective_date => p_effective_date) then
545: --

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 665: if hr_api.not_exists_in_hr_lookups

661: p_create_flag is not null then
662: --
663: -- check if value of lookup falls within lookup type.
664: --
665: if hr_api.not_exists_in_hr_lookups
666: (p_lookup_type => 'YES_NO',
667: p_lookup_code => p_create_flag,
668: p_effective_date => p_effective_date) then
669: --

Line 683: nvl(p_create_flag,hr_api.g_varchar2)

679: -- Check if create flag can be updated.Should not allow update if the
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: --

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 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 777: if hr_api.not_exists_in_hr_lookups

773: and p_enable_flag is not null then
774: --
775: -- check if value of lookup falls within lookup type.
776: --
777: if hr_api.not_exists_in_hr_lookups
778: (p_lookup_type => 'YES_NO',
779: p_lookup_code => p_enable_flag,
780: p_effective_date => p_effective_date) then
781: --

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 891: if hr_api.not_exists_in_hr_lookups

887: and p_attribute_only_flag is not null then
888: --
889: -- check if value of lookup falls within lookup type.
890: --
891: if hr_api.not_exists_in_hr_lookups
892: (p_lookup_type => 'YES_NO',
893: p_lookup_code => p_attribute_only_flag,
894: p_effective_date => p_effective_date) then
895: --

Line 909: and nvl(p_attribute_only_flag,hr_api.g_varchar2)

905: -- Raise error if attribute_only_flag is updated to Y and reference templates
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: --

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 912: if nvl(p_attribute_only_flag,hr_api.g_varchar2) = 'Y' then

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'
915: open c1;
916: fetch c1 into l_dummy;

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 984: if hr_api.not_exists_in_hr_lookups

980: and p_freeze_status_cd is not null then
981: --
982: -- check if value of lookup falls within lookup type.
983: --
984: if hr_api.not_exists_in_hr_lookups
985: (p_lookup_type => 'PQH_TEMPLATE_FREEZE_STATUS',
986: p_lookup_code => p_freeze_status_cd,
987: p_effective_date => p_effective_date) then
988: --

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 1055: if hr_api.not_exists_in_hr_lookups

1051: and p_template_type_cd is not null then
1052: --
1053: -- check if value of lookup falls within lookup type.
1054: --
1055: if hr_api.not_exists_in_hr_lookups
1056: (p_lookup_type => 'PQH_TEMPLATE_TYPE',
1057: p_lookup_code => p_template_type_cd,
1058: p_effective_date => p_effective_date) then
1059: --

Line 1074: nvl(p_template_type_cd,hr_api.g_varchar2)

1070: -- Check if template type can be updated.Should not allow update if the
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: --

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 1614: and nvl(p_freeze_status_cd,hr_api.g_varchar2)

1610: (p_template_id => p_template_id,
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: --

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