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_RCT_BUS dependencies on PQH_RCT_SHD

Line 47: l_api_updating := pqh_rct_shd.api_updating

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

Line 53: <> pqh_rct_shd.g_old_rec.routing_category_id) then

49: p_object_version_number => p_object_version_number);
50: --
51: if (l_api_updating
52: and nvl(p_routing_category_id,hr_api.g_number)
53: <> pqh_rct_shd.g_old_rec.routing_category_id) then
54: --
55: -- raise error as PK has changed
56: --
57: pqh_rct_shd.constraint_error('PQH_ROUTING_CATEGORIES_PK');

Line 57: pqh_rct_shd.constraint_error('PQH_ROUTING_CATEGORIES_PK');

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

Line 67: pqh_rct_shd.constraint_error('PQH_ROUTING_CATEGORIES_PK');

63: if p_routing_category_id is not null then
64: --
65: -- raise error as PK is not null
66: --
67: pqh_rct_shd.constraint_error('PQH_ROUTING_CATEGORIES_PK');
68: --
69: end if;
70: --
71: end if;

Line 121: l_api_updating := pqh_rct_shd.api_updating

117: Begin
118: --
119: hr_utility.set_location('Entering:'||l_proc,5);
120: --
121: l_api_updating := pqh_rct_shd.api_updating
122: (p_routing_category_id => p_routing_category_id,
123: p_object_version_number => p_object_version_number);
124: --
125: if (l_api_updating AND

Line 127: = nvl(pqh_rct_shd.g_old_rec.transaction_category_id,hr_api.g_number)

123: p_object_version_number => p_object_version_number);
124: --
125: if (l_api_updating AND
126: nvl(p_transaction_category_id,hr_api.g_number)
127: = nvl(pqh_rct_shd.g_old_rec.transaction_category_id,hr_api.g_number)
128: or not l_api_updating) then
129: --
130: -- check if transaction_category_id value exists in
131: -- pqh_transaction_categories table

Line 143: pqh_rct_shd.constraint_error('PQH_ROUTING_CATEGORIES_FK2');

139: --
140: -- raise error as FK does not relate to PK in
141: -- pqh_transaction_categories table.
142: --
143: pqh_rct_shd.constraint_error('PQH_ROUTING_CATEGORIES_FK2');
144: --
145: end if;
146: --
147: close c1;

Line 201: l_api_updating := pqh_rct_shd.api_updating

197: Begin
198: --
199: hr_utility.set_location('Entering:'||l_proc, 5);
200: --
201: l_api_updating := pqh_rct_shd.api_updating
202: (p_routing_category_id => p_routing_category_id,
203: p_object_version_number => p_object_version_number);
204: --
205: if (l_api_updating

Line 207: <> nvl(pqh_rct_shd.g_old_rec.enable_flag,hr_api.g_varchar2)

203: p_object_version_number => p_object_version_number);
204: --
205: if (l_api_updating
206: and p_enable_flag
207: <> nvl(pqh_rct_shd.g_old_rec.enable_flag,hr_api.g_varchar2)
208: or not l_api_updating)
209: and p_enable_flag is not null then
210: --
211: -- check if value of lookup falls within lookup type.

Line 234: p_enable_flag <> nvl(pqh_rct_shd.g_old_rec.enable_flag,hr_api.g_varchar2)

230: -- overlap with any other rule in the same transaction category.
231: --
232: if l_api_updating and
233: p_enable_flag = 'Y' and
234: p_enable_flag <> nvl(pqh_rct_shd.g_old_rec.enable_flag,hr_api.g_varchar2)
235: then
236: --
237: hr_utility.set_location('Enable allow :'||l_proc,8);
238: --

Line 305: l_api_updating := pqh_rct_shd.api_updating

301: Begin
302: --
303: hr_utility.set_location('Entering:'||l_proc, 5);
304: --
305: l_api_updating := pqh_rct_shd.api_updating
306: (p_routing_category_id => p_routing_category_id,
307: p_object_version_number => p_object_version_number);
308: --
309: if (l_api_updating

Line 311: <> nvl(pqh_rct_shd.g_old_rec.default_flag,hr_api.g_varchar2)

307: p_object_version_number => p_object_version_number);
308: --
309: if (l_api_updating
310: and p_default_flag
311: <> nvl(pqh_rct_shd.g_old_rec.default_flag,hr_api.g_varchar2)
312: or not l_api_updating)
313: and p_default_flag is not null then
314: --
315: -- check if value of lookup falls within lookup type.

Line 375: l_api_updating := pqh_rct_shd.api_updating

371: Begin
372: --
373: hr_utility.set_location('Entering:'||l_proc, 5);
374: --
375: l_api_updating := pqh_rct_shd.api_updating
376: (p_routing_category_id => p_routing_category_id,
377: p_object_version_number => p_object_version_number);
378: --
379: if (l_api_updating

Line 381: <> nvl(pqh_rct_shd.g_old_rec.delete_flag,hr_api.g_varchar2)

377: p_object_version_number => p_object_version_number);
378: --
379: if (l_api_updating
380: and p_delete_flag
381: <> nvl(pqh_rct_shd.g_old_rec.delete_flag,hr_api.g_varchar2)
382: or not l_api_updating)
383: and p_delete_flag is not null then
384: --
385: -- check if value of lookup falls within lookup type.

Line 434: l_api_updating := pqh_rct_shd.api_updating

430: Begin
431: --
432: hr_utility.set_location('Entering:'||l_proc,5);
433: --
434: l_api_updating := pqh_rct_shd.api_updating
435: (p_routing_category_id => p_routing_category_id,
436: p_object_version_number => p_object_version_number);
437: --
438: -- Raise Error if trying to update the transaction category of the

Line 443: <> nvl(pqh_rct_shd.g_old_rec.transaction_category_id,hr_api.g_number)) then

439: -- routing category.
440: --
441: if (l_api_updating AND
442: nvl(p_transaction_category_id,hr_api.g_number)
443: <> nvl(pqh_rct_shd.g_old_rec.transaction_category_id,hr_api.g_number)) then
444: --
445: -- Cannot update the transaction category id
446: --
447: hr_utility.set_message(8302,'PQH_NO_UPD_TRAN_CAT_OF_RCAT');

Line 463: pqh_rct_shd.constraint_error('PQH_ROUTING_CATEGORIES_FK2');

459: --
460: -- raise error as FK does not relate to PK in
461: -- pqh_transaction_categories table.
462: --
463: pqh_rct_shd.constraint_error('PQH_ROUTING_CATEGORIES_FK2');
464: --
465: end if;
466: --
467: close c1;

Line 476: If nvl(pqh_rct_shd.g_old_rec.enable_flag,'Y') = 'Y' then

472: If l_freeze_status_cd = 'FREEZE_CATEGORY' then
473: --
474: if l_api_updating then
475: --
476: If nvl(pqh_rct_shd.g_old_rec.enable_flag,'Y') = 'Y' then
477: --
478: hr_utility.set_message(8302,'PQH_NO_RCT_UPD_FROZEN_TCT');
479: hr_utility.raise_error;
480: --

Line 501: = nvl(pqh_rct_shd.g_old_rec.enable_flag,hr_api.g_varchar2) then

497: -- than its enable flag.
498: --
499: if l_api_updating AND
500: nvl(p_enable_flag,hr_api.g_varchar2)
501: = nvl(pqh_rct_shd.g_old_rec.enable_flag,hr_api.g_varchar2) then
502: --
503: hr_utility.set_message(8302,'PQH_NO_UPDATE_ROUT_CAT');
504: hr_utility.raise_error;
505: --

Line 577: l_api_updating := pqh_rct_shd.api_updating

573: Begin
574: --
575: hr_utility.set_location('Entering:'||l_proc,5);
576: --
577: l_api_updating := pqh_rct_shd.api_updating
578: (p_routing_category_id => p_routing_category_id,
579: p_object_version_number => p_object_version_number);
580:
581: open c1;

Line 599: <> nvl(pqh_rct_shd.g_old_rec.routing_list_id,hr_api.g_number)) then

595: hr_utility.raise_error;
596: Else
597: if (l_api_updating AND
598: nvl(p_routing_list_id,hr_api.g_number)
599: <> nvl(pqh_rct_shd.g_old_rec.routing_list_id,hr_api.g_number)) then
600: --
601: -- Disallow updates to routing list id field, if detail recs exist
602: --
603: open c2;

Line 629: <> nvl(pqh_rct_shd.g_old_rec.position_structure_id,hr_api.g_number)) then

625: hr_utility.raise_error;
626: Else
627: if (l_api_updating AND
628: nvl(p_position_structure_id,hr_api.g_number)
629: <> nvl(pqh_rct_shd.g_old_rec.position_structure_id,hr_api.g_number)) then
630: --
631: -- Disallow updates to position_structure_id field, if detail recs exist
632: --
633: open c2;

Line 663: <> nvl(pqh_rct_shd.g_old_rec.routing_list_id,hr_api.g_number) then

659: **/
660:
661: --
662: if l_api_updating and nvl(p_routing_list_id,hr_api.g_number)
663: <> nvl(pqh_rct_shd.g_old_rec.routing_list_id,hr_api.g_number) then
664: --
665: -- Disallow any updates to the routing list id if there are any
666: -- child records for this routing category.
667: --

Line 684: <> nvl(pqh_rct_shd.g_old_rec.routing_list_id,hr_api.g_number))

680: -- Inserting a new routing category or updating the list id of an existing
681: -- category.
682: --
683: if (l_api_updating and nvl(p_routing_list_id,hr_api.g_number)
684: <> nvl(pqh_rct_shd.g_old_rec.routing_list_id,hr_api.g_number))
685: OR NOT l_api_updating then
686: --
687: -- Validate if the member_cd matches the list id and a list_id that
688: -- mismatches the member_cd is not supplied

Line 776: l_api_updating := pqh_rct_shd.api_updating

772: Begin
773: --
774: hr_utility.set_location('Entering:'||l_proc,5);
775: --
776: l_api_updating := pqh_rct_shd.api_updating
777: (p_routing_category_id => p_routing_category_id,
778: p_object_version_number => p_object_version_number);
779: --
780: if (l_api_updating

Line 782: <> nvl(pqh_rct_shd.g_old_rec.routing_list_id,hr_api.g_number)

778: p_object_version_number => p_object_version_number);
779: --
780: if (l_api_updating
781: and nvl(p_routing_list_id,hr_api.g_number)
782: <> nvl(pqh_rct_shd.g_old_rec.routing_list_id,hr_api.g_number)
783: or not l_api_updating) and
784: p_routing_list_id is not null then
785: --
786: -- check if routing_list_id value exists in pqh_routing_lists table

Line 798: pqh_rct_shd.constraint_error('PQH_ROUTING_CATEGORIES_FK1');

794: --
795: -- raise error as FK does not relate to PK in pqh_routing_lists
796: -- table.
797: --
798: pqh_rct_shd.constraint_error('PQH_ROUTING_CATEGORIES_FK1');
799: --
800: end if;
801: --
802: close c1;

Line 862: l_api_updating := pqh_rct_shd.api_updating

858: Begin
859: --
860: hr_utility.set_location('Entering:'||l_proc,5);
861: --
862: l_api_updating := pqh_rct_shd.api_updating
863: (p_routing_category_id => p_routing_category_id,
864: p_object_version_number => p_object_version_number);
865: --
866: if (l_api_updating

Line 868: <> nvl(pqh_rct_shd.g_old_rec.override_role_id,hr_api.g_number)

864: p_object_version_number => p_object_version_number);
865: --
866: if (l_api_updating
867: and nvl(p_override_role_id,hr_api.g_number)
868: <> nvl(pqh_rct_shd.g_old_rec.override_role_id,hr_api.g_number)
869: or not l_api_updating) and
870: p_override_role_id is not null then
871: --
872: -- check if override_role_id value exists in

Line 958: l_api_updating := pqh_rct_shd.api_updating

954: Begin
955: --
956: hr_utility.set_location('Entering:'||l_proc,5);
957: --
958: l_api_updating := pqh_rct_shd.api_updating
959: (p_routing_category_id => p_routing_category_id,
960: p_object_version_number => p_object_version_number);
961: --
962: if (l_api_updating

Line 964: <> nvl(pqh_rct_shd.g_old_rec.override_user_id,hr_api.g_number)

960: p_object_version_number => p_object_version_number);
961: --
962: if (l_api_updating
963: and nvl(p_override_user_id,hr_api.g_number)
964: <> nvl(pqh_rct_shd.g_old_rec.override_user_id,hr_api.g_number)
965: or not l_api_updating) and
966: p_override_user_id is not null then
967: --
968: -- check if override_user_id value exists in

Line 1070: l_api_updating := pqh_rct_shd.api_updating

1066: Begin
1067: --
1068: hr_utility.set_location('Entering:'||l_proc,5);
1069: --
1070: l_api_updating := pqh_rct_shd.api_updating
1071: (p_routing_category_id => p_routing_category_id,
1072: p_object_version_number => p_object_version_number);
1073: --
1074: if (l_api_updating

Line 1076: <> nvl(pqh_rct_shd.g_old_rec.position_structure_id,hr_api.g_number)

1072: p_object_version_number => p_object_version_number);
1073: --
1074: if (l_api_updating
1075: and nvl(p_position_structure_id,hr_api.g_number)
1076: <> nvl(pqh_rct_shd.g_old_rec.position_structure_id,hr_api.g_number)
1077: or not l_api_updating) and
1078: p_position_structure_id is not null then
1079: --
1080: -- check if position_structure_id value exists in per_position_structures table

Line 1092: pqh_rct_shd.constraint_error('PQH_ROUTING_CATEGORIES_FK3');

1088: --
1089: -- raise error as FK does not relate to PK in per_position_structures
1090: -- table.
1091: --
1092: pqh_rct_shd.constraint_error('PQH_ROUTING_CATEGORIES_FK3');
1093: --
1094: end if;
1095: --
1096: close c1;

Line 1159: l_api_updating := pqh_rct_shd.api_updating

1155: Begin
1156: --
1157: hr_utility.set_location('Entering:'||l_proc,5);
1158: --
1159: l_api_updating := pqh_rct_shd.api_updating
1160: (p_routing_category_id => p_routing_category_id,
1161: p_object_version_number => p_object_version_number);
1162: --
1163: if (l_api_updating

Line 1165: <> nvl(pqh_rct_shd.g_old_rec.override_position_id,hr_api.g_number)

1161: p_object_version_number => p_object_version_number);
1162: --
1163: if (l_api_updating
1164: and nvl(p_override_position_id,hr_api.g_number)
1165: <> nvl(pqh_rct_shd.g_old_rec.override_position_id,hr_api.g_number)
1166: or not l_api_updating) and
1167: p_override_position_id is not null then
1168: --
1169: -- check if override_position_id value exists in hr_all_positions_f table

Line 1181: pqh_rct_shd.constraint_error('PQH_ROUTING_CATEGORIES_FK4');

1177: --
1178: -- raise error as FK does not relate to PK in hr_all_positions_f
1179: -- table.
1180: --
1181: pqh_rct_shd.constraint_error('PQH_ROUTING_CATEGORIES_FK4');
1182: --
1183: end if;
1184: --
1185: close c1;

Line 1471: Procedure insert_validate(p_rec in pqh_rct_shd.g_rec_type

1467:
1468: -- ----------------------------------------------------------------------------
1469: -- |---------------------------< insert_validate >----------------------------|
1470: -- ----------------------------------------------------------------------------
1471: Procedure insert_validate(p_rec in pqh_rct_shd.g_rec_type
1472: ,p_effective_date in date) is
1473: --
1474: l_proc varchar2(72) := g_package||'insert_validate';
1475: --

Line 1562: Procedure update_validate(p_rec in pqh_rct_shd.g_rec_type

1558: --
1559: -- ----------------------------------------------------------------------------
1560: -- |---------------------------< update_validate >----------------------------|
1561: -- ----------------------------------------------------------------------------
1562: Procedure update_validate(p_rec in pqh_rct_shd.g_rec_type
1563: ,p_effective_date in date) is
1564: --
1565: l_proc varchar2(72) := g_package||'update_validate';
1566: --

Line 1647: Procedure delete_validate(p_rec in pqh_rct_shd.g_rec_type

1643: --
1644: -- ----------------------------------------------------------------------------
1645: -- |---------------------------< delete_validate >----------------------------|
1646: -- ----------------------------------------------------------------------------
1647: Procedure delete_validate(p_rec in pqh_rct_shd.g_rec_type
1648: ,p_effective_date in date) is
1649: --
1650: l_proc varchar2(72) := g_package||'delete_validate';
1651: --