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 PQH_TCA_SHD

Line 46: l_api_updating := pqh_tca_shd.api_updating

42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := pqh_tca_shd.api_updating
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

Line 52: <> pqh_tca_shd.g_old_rec.txn_category_attribute_id) then

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

Line 56: pqh_tca_shd.constraint_error('PQH_TXN_CATEGORY_ATTRIBUTES_PK');

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

Line 66: pqh_tca_shd.constraint_error('PQH_TXN_CATEGORY_ATTRIBUTES_PK');

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

Line 118: l_api_updating := pqh_tca_shd.api_updating

114: Begin
115: --
116: hr_utility.set_location('Entering:'||l_proc,5);
117: --
118: l_api_updating := pqh_tca_shd.api_updating
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

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 140: pqh_tca_shd.constraint_error('PQH_TXN_CAT_ATTRIBUTES_FK4');

136: --
137: -- raise error as FK does not relate to PK in pqh_table_route
138: -- table.
139: --
140: pqh_tca_shd.constraint_error('PQH_TXN_CAT_ATTRIBUTES_FK4');
141: --
142: end if;
143: --
144: close c1;

Line 194: l_api_updating := pqh_tca_shd.api_updating

190: Begin
191: --
192: hr_utility.set_location('Entering:'||l_proc,5);
193: --
194: l_api_updating := pqh_tca_shd.api_updating
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

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 216: pqh_tca_shd.constraint_error('PQH_TXN_CAT_ATTRIBUTES_FK5');

212: --
213: -- raise error as FK does not relate to PK in pqh_table_route
214: -- table.
215: --
216: pqh_tca_shd.constraint_error('PQH_TXN_CAT_ATTRIBUTES_FK5');
217: --
218: end if;
219: --
220: close c1;

Line 270: l_api_updating := pqh_tca_shd.api_updating

266: Begin
267: --
268: hr_utility.set_location('Entering:'||l_proc,5);
269: --
270: l_api_updating := pqh_tca_shd.api_updating
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

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 291: pqh_tca_shd.constraint_error('PQH_TXN_CATEGORY_ATTRIBUTE_FK2');

287: --
288: -- raise error as FK does not relate to PK in pqh_transaction_categories
289: -- table.
290: --
291: pqh_tca_shd.constraint_error('PQH_TXN_CATEGORY_ATTRIBUTE_FK2');
292: --
293: end if;
294: --
295: close c1;

Line 345: l_api_updating := pqh_tca_shd.api_updating

341: Begin
342: --
343: hr_utility.set_location('Entering:'||l_proc,5);
344: --
345: l_api_updating := pqh_tca_shd.api_updating
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

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 366: pqh_tca_shd.constraint_error('PQH_TXN_CATEGORY_ATTRIBUTE_FK1');

362: --
363: -- raise error as FK does not relate to PK in pqh_attributes
364: -- table.
365: --
366: pqh_tca_shd.constraint_error('PQH_TXN_CATEGORY_ATTRIBUTE_FK1');
367: --
368: end if;
369: --
370: close c1;

Line 416: l_api_updating := pqh_tca_shd.api_updating

412: Begin
413: --
414: hr_utility.set_location('Entering:'||l_proc, 5);
415: --
416: l_api_updating := pqh_tca_shd.api_updating
417: (p_txn_category_attribute_id => p_txn_category_attribute_id,
418: p_object_version_number => p_object_version_number);
419: --
420: if (l_api_updating

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 484: l_api_updating := pqh_tca_shd.api_updating

480: Begin
481: --
482: hr_utility.set_location('Entering:'||l_proc, 5);
483: --
484: l_api_updating := pqh_tca_shd.api_updating
485: (p_txn_category_attribute_id => p_txn_category_attribute_id,
486: p_object_version_number => p_object_version_number);
487: --
488: if (l_api_updating

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 552: l_api_updating := pqh_tca_shd.api_updating

548: Begin
549: --
550: hr_utility.set_location('Entering:'||l_proc, 5);
551: --
552: l_api_updating := pqh_tca_shd.api_updating
553: (p_txn_category_attribute_id => p_txn_category_attribute_id,
554: p_object_version_number => p_object_version_number);
555: --
556: if (l_api_updating

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 624: l_api_updating := pqh_tca_shd.api_updating

620: Begin
621: --
622: hr_utility.set_location('Entering:'||l_proc, 5);
623: --
624: l_api_updating := pqh_tca_shd.api_updating
625: (p_txn_category_attribute_id => p_txn_category_attribute_id,
626: p_object_version_number => p_object_version_number);
627: --
628: --

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 732: l_api_updating := pqh_tca_shd.api_updating

728: Begin
729: --
730: hr_utility.set_location('Entering:'||l_proc, 5);
731: --
732: l_api_updating := pqh_tca_shd.api_updating
733: (p_txn_category_attribute_id => p_txn_category_attribute_id,
734: p_object_version_number => p_object_version_number);
735: --
736: --

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 833: l_api_updating := pqh_tca_shd.api_updating

829: Begin
830: --
831: hr_utility.set_location('Entering:'||l_proc, 5);
832: --
833: l_api_updating := pqh_tca_shd.api_updating
834: (p_txn_category_attribute_id => p_txn_category_attribute_id,
835: p_object_version_number => p_object_version_number);
836: --
837: if (l_api_updating

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 924: Procedure insert_validate(p_rec in pqh_tca_shd.g_rec_type

920:
921: -- ----------------------------------------------------------------------------
922: -- |---------------------------< insert_validate >----------------------------|
923: -- ----------------------------------------------------------------------------
924: Procedure insert_validate(p_rec in pqh_tca_shd.g_rec_type
925: ,p_effective_date in date) is
926: p_delete_attr_ranges_flag varchar2(10) := 'N';
927: --
928: l_proc varchar2(72) := g_package||'insert_validate';

Line 1014: Procedure update_validate(p_rec in pqh_tca_shd.g_rec_type

1010: --
1011: -- ----------------------------------------------------------------------------
1012: -- |---------------------------< update_validate >----------------------------|
1013: -- ----------------------------------------------------------------------------
1014: Procedure update_validate(p_rec in pqh_tca_shd.g_rec_type
1015: ,p_effective_date in date
1016: ,p_delete_attr_ranges_flag in varchar2) is
1017: --
1018: l_proc varchar2(72) := g_package||'update_validate';

Line 1102: Procedure delete_validate(p_rec in pqh_tca_shd.g_rec_type

1098: --
1099: -- ----------------------------------------------------------------------------
1100: -- |---------------------------< delete_validate >----------------------------|
1101: -- ----------------------------------------------------------------------------
1102: Procedure delete_validate(p_rec in pqh_tca_shd.g_rec_type
1103: ,p_effective_date in date) is
1104: --
1105: l_proc varchar2(72) := g_package||'delete_validate';
1106: --