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_TCA_BUS dependencies on HR_API

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

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

Line 123: and nvl(p_transaction_table_route_id,hr_api.g_number)

119: (p_txn_category_attribute_id => p_txn_category_attribute_id,
120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and nvl(p_transaction_table_route_id,hr_api.g_number)
124: <> nvl(pqh_tca_shd.g_old_rec.transaction_table_route_id,hr_api.g_number)
125: or not l_api_updating) and
126: p_transaction_table_route_id is not null then
127: --

Line 124: <> nvl(pqh_tca_shd.g_old_rec.transaction_table_route_id,hr_api.g_number)

120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and nvl(p_transaction_table_route_id,hr_api.g_number)
124: <> nvl(pqh_tca_shd.g_old_rec.transaction_table_route_id,hr_api.g_number)
125: or not l_api_updating) and
126: p_transaction_table_route_id is not null then
127: --
128: -- check if transaction_table_route_id value exists in pqh_table_route table

Line 199: and nvl(p_value_set_id,hr_api.g_number)

195: (p_txn_category_attribute_id => p_txn_category_attribute_id,
196: p_object_version_number => p_object_version_number);
197: --
198: if (l_api_updating
199: and nvl(p_value_set_id,hr_api.g_number)
200: <> nvl(pqh_tca_shd.g_old_rec.value_set_id,hr_api.g_number)
201: or not l_api_updating) and
202: p_value_set_id is not null then
203: --

Line 200: <> nvl(pqh_tca_shd.g_old_rec.value_set_id,hr_api.g_number)

196: p_object_version_number => p_object_version_number);
197: --
198: if (l_api_updating
199: and nvl(p_value_set_id,hr_api.g_number)
200: <> nvl(pqh_tca_shd.g_old_rec.value_set_id,hr_api.g_number)
201: or not l_api_updating) and
202: p_value_set_id is not null then
203: --
204: -- check if value_Set_id value exists in fnd_flex_value_Sets table

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

271: (p_txn_category_attribute_id => p_txn_category_attribute_id,
272: p_object_version_number => p_object_version_number);
273: --
274: if (l_api_updating
275: and nvl(p_transaction_category_id,hr_api.g_number)
276: <> nvl(pqh_tca_shd.g_old_rec.transaction_category_id,hr_api.g_number)
277: or not l_api_updating) then
278: --
279: -- check if transaction_category_id value exists in pqh_transaction_categories table

Line 276: <> nvl(pqh_tca_shd.g_old_rec.transaction_category_id,hr_api.g_number)

272: p_object_version_number => p_object_version_number);
273: --
274: if (l_api_updating
275: and nvl(p_transaction_category_id,hr_api.g_number)
276: <> nvl(pqh_tca_shd.g_old_rec.transaction_category_id,hr_api.g_number)
277: or not l_api_updating) then
278: --
279: -- check if transaction_category_id value exists in pqh_transaction_categories table
280: --

Line 350: and nvl(p_attribute_id,hr_api.g_number)

346: (p_txn_category_attribute_id => p_txn_category_attribute_id,
347: p_object_version_number => p_object_version_number);
348: --
349: if (l_api_updating
350: and nvl(p_attribute_id,hr_api.g_number)
351: <> nvl(pqh_tca_shd.g_old_rec.attribute_id,hr_api.g_number)
352: or not l_api_updating) then
353: --
354: -- check if attribute_id value exists in pqh_attributes table

Line 351: <> nvl(pqh_tca_shd.g_old_rec.attribute_id,hr_api.g_number)

347: p_object_version_number => p_object_version_number);
348: --
349: if (l_api_updating
350: and nvl(p_attribute_id,hr_api.g_number)
351: <> nvl(pqh_tca_shd.g_old_rec.attribute_id,hr_api.g_number)
352: or not l_api_updating) then
353: --
354: -- check if attribute_id value exists in pqh_attributes table
355: --

Line 422: <> nvl(pqh_tca_shd.g_old_rec.value_style_cd,hr_api.g_varchar2)

418: p_object_version_number => p_object_version_number);
419: --
420: if (l_api_updating
421: and p_value_style_cd
422: <> nvl(pqh_tca_shd.g_old_rec.value_style_cd,hr_api.g_varchar2)
423: or not l_api_updating)
424: and p_value_style_cd is not null then
425: --
426: -- check if value of lookup falls within lookup type.

Line 428: if hr_api.not_exists_in_hr_lookups

424: and p_value_style_cd is not null then
425: --
426: -- check if value of lookup falls within lookup type.
427: --
428: if hr_api.not_exists_in_hr_lookups
429: (p_lookup_type => 'PQH_VALUE_STYLE',
430: p_lookup_code => p_value_style_cd,
431: p_effective_date => p_effective_date) then
432: --

Line 490: <> nvl(pqh_tca_shd.g_old_rec.refresh_flag,hr_api.g_varchar2)

486: p_object_version_number => p_object_version_number);
487: --
488: if (l_api_updating
489: and p_refresh_flag
490: <> nvl(pqh_tca_shd.g_old_rec.refresh_flag,hr_api.g_varchar2)
491: or not l_api_updating)
492: and p_refresh_flag is not null then
493: --
494: -- check if value of lookup falls within lookup type.

Line 496: if hr_api.not_exists_in_hr_lookups

492: and p_refresh_flag is not null then
493: --
494: -- check if value of lookup falls within lookup type.
495: --
496: if hr_api.not_exists_in_hr_lookups
497: (p_lookup_type => 'YES_NO',
498: p_lookup_code => p_refresh_flag,
499: p_effective_date => p_effective_date) then
500: --

Line 558: <> nvl(pqh_tca_shd.g_old_rec.select_flag,hr_api.g_varchar2)

554: p_object_version_number => p_object_version_number);
555: --
556: if (l_api_updating
557: and p_select_flag
558: <> nvl(pqh_tca_shd.g_old_rec.select_flag,hr_api.g_varchar2)
559: or not l_api_updating)
560: and p_select_flag is not null then
561: --
562: -- check if value of lookup falls within lookup type.

Line 564: if hr_api.not_exists_in_hr_lookups

560: and p_select_flag is not null then
561: --
562: -- check if value of lookup falls within lookup type.
563: --
564: if hr_api.not_exists_in_hr_lookups
565: (p_lookup_type => 'YES_NO',
566: p_lookup_code => p_select_flag,
567: p_effective_date => p_effective_date) then
568: --

Line 632: and nvl(p_member_identifying_flag,hr_api.g_varchar2)

628: --
629: -- Error if child rows exists in pqh_attribute_ranges
630: --
631: if (l_api_updating
632: and nvl(p_member_identifying_flag,hr_api.g_varchar2)
633: <> nvl(pqh_tca_shd.g_old_rec.member_identifying_flag,hr_api.g_varchar2))
634: then
635: --
636: if p_member_identifying_flag = 'N' then

Line 633: <> nvl(pqh_tca_shd.g_old_rec.member_identifying_flag,hr_api.g_varchar2))

629: -- Error if child rows exists in pqh_attribute_ranges
630: --
631: if (l_api_updating
632: and nvl(p_member_identifying_flag,hr_api.g_varchar2)
633: <> nvl(pqh_tca_shd.g_old_rec.member_identifying_flag,hr_api.g_varchar2))
634: then
635: --
636: if p_member_identifying_flag = 'N' then
637: --

Line 652: <> nvl(pqh_tca_shd.g_old_rec.member_identifying_flag,hr_api.g_varchar2)

648: --
649:
650: if (l_api_updating
651: and p_member_identifying_flag
652: <> nvl(pqh_tca_shd.g_old_rec.member_identifying_flag,hr_api.g_varchar2)
653: or not l_api_updating)
654: and p_member_identifying_flag is not null then
655: --
656: -- check if value of lookup falls within lookup type.

Line 658: if hr_api.not_exists_in_hr_lookups

654: and p_member_identifying_flag is not null then
655: --
656: -- check if value of lookup falls within lookup type.
657: --
658: if hr_api.not_exists_in_hr_lookups
659: (p_lookup_type => 'YES_NO',
660: p_lookup_code => p_member_identifying_flag,
661: p_effective_date => p_effective_date) then
662: --

Line 674: if nvl(p_identifier_flag,hr_api.g_varchar2) <> 'Y' and p_member_identifying_flag = 'Y' then

670: --
671: -- CHECK if identifier_flag is Y
672: -- member_identifying_flag can be Y only if identifier_flag is Y
673: --
674: if nvl(p_identifier_flag,hr_api.g_varchar2) <> 'Y' and p_member_identifying_flag = 'Y' then
675: --
676: -- raise error
677: --
678: hr_utility.set_message(8302,'PQH_INVALID_MEMBER_IDENTIFIER');

Line 740: and nvl(p_list_identifying_flag,hr_api.g_varchar2)

736: --
737: -- Error if records exist in pqh_attribute_ranges for this attribute_id
738: --
739: if (l_api_updating
740: and nvl(p_list_identifying_flag,hr_api.g_varchar2)
741: <> nvl(pqh_tca_shd.g_old_rec.list_identifying_flag,hr_api.g_varchar2)) then
742: --
743: if p_list_identifying_flag = 'N' then
744: --

Line 741: <> nvl(pqh_tca_shd.g_old_rec.list_identifying_flag,hr_api.g_varchar2)) then

737: -- Error if records exist in pqh_attribute_ranges for this attribute_id
738: --
739: if (l_api_updating
740: and nvl(p_list_identifying_flag,hr_api.g_varchar2)
741: <> nvl(pqh_tca_shd.g_old_rec.list_identifying_flag,hr_api.g_varchar2)) then
742: --
743: if p_list_identifying_flag = 'N' then
744: --
745: pqh_ATTRIBUTE_RANGES_pkg.Delete_attribute_ranges

Line 757: <> nvl(pqh_tca_shd.g_old_rec.list_identifying_flag,hr_api.g_varchar2)

753: --
754:
755: if (l_api_updating
756: and p_list_identifying_flag
757: <> nvl(pqh_tca_shd.g_old_rec.list_identifying_flag,hr_api.g_varchar2)
758: or not l_api_updating)
759: and p_list_identifying_flag is not null then
760: --
761: -- check if value of lookup falls within lookup type.

Line 763: if hr_api.not_exists_in_hr_lookups

759: and p_list_identifying_flag is not null then
760: --
761: -- check if value of lookup falls within lookup type.
762: --
763: if hr_api.not_exists_in_hr_lookups
764: (p_lookup_type => 'YES_NO',
765: p_lookup_code => p_list_identifying_flag,
766: p_effective_date => p_effective_date) then
767: --

Line 779: if nvl(p_identifier_flag,hr_api.g_varchar2) <> 'Y' and p_list_identifying_flag = 'Y' then

775: --
776: -- CHECK if identifier_flag is Y
777: -- list_identifying_flag can be Y only if identifier_flag is Y
778: --
779: if nvl(p_identifier_flag,hr_api.g_varchar2) <> 'Y' and p_list_identifying_flag = 'Y' then
780: --
781: -- raise error
782: --
783: hr_utility.set_message(8302,'PQH_INVALID_LIST_IDENTIFIER');

Line 839: <> nvl(pqh_tca_shd.g_old_rec.identifier_flag,hr_api.g_varchar2)

835: p_object_version_number => p_object_version_number);
836: --
837: if (l_api_updating
838: and p_identifier_flag
839: <> nvl(pqh_tca_shd.g_old_rec.identifier_flag,hr_api.g_varchar2)
840: or not l_api_updating)
841: and p_identifier_flag is not null then
842: --
843: -- check if value of lookup falls within lookup type.

Line 845: if hr_api.not_exists_in_hr_lookups

841: and p_identifier_flag is not null then
842: --
843: -- check if value of lookup falls within lookup type.
844: --
845: if hr_api.not_exists_in_hr_lookups
846: (p_lookup_type => 'YES_NO',
847: p_lookup_code => p_identifier_flag,
848: p_effective_date => p_effective_date) then
849: --

Line 899: select nvl(b.freeze_status_cd,hr_api.g_varchar2)

895: l_api_updating boolean;
896: l_freeze_status_cd pqh_transaction_categories.freeze_status_cd%type;
897: --
898: cursor c1 is
899: select nvl(b.freeze_status_cd,hr_api.g_varchar2)
900: from pqh_txn_category_attributes a, pqh_transaction_categories b
901: where a.attribute_id = p_attribute_id
902: AND a.transaction_category_id = b.transaction_category_id;
903: --