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_RHT_BUS dependencies on PQH_RHT_SHD

Line 46: l_api_updating := pqh_rht_shd.api_updating

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

Line 52: <> pqh_rht_shd.g_old_rec.routing_history_id) then

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

Line 56: pqh_rht_shd.constraint_error('PQH_ROUTING_HISTORY_PK');

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

Line 66: pqh_rht_shd.constraint_error('PQH_ROUTING_HISTORY_PK');

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

Line 118: l_api_updating := pqh_rht_shd.api_updating

114: Begin
115: --
116: hr_utility.set_location('Entering:'||l_proc,5);
117: --
118: l_api_updating := pqh_rht_shd.api_updating
119: (p_routing_history_id => p_routing_history_id,
120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating

Line 124: <> nvl(pqh_rht_shd.g_old_rec.pos_structure_version_id,hr_api.g_number)

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

Line 140: pqh_rht_shd.constraint_error('PQH_ROUTING_HISTORY_FK7');

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

Line 194: l_api_updating := pqh_rht_shd.api_updating

190: Begin
191: --
192: hr_utility.set_location('Entering:'||l_proc,5);
193: --
194: l_api_updating := pqh_rht_shd.api_updating
195: (p_routing_history_id => p_routing_history_id,
196: p_object_version_number => p_object_version_number);
197: --
198: if (l_api_updating

Line 200: <> nvl(pqh_rht_shd.g_old_rec.forwarded_to_member_id,hr_api.g_number)

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

Line 216: pqh_rht_shd.constraint_error('PQH_ROUTING_HISTORY_FK6');

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

Line 270: l_api_updating := pqh_rht_shd.api_updating

266: Begin
267: --
268: hr_utility.set_location('Entering:'||l_proc,5);
269: --
270: l_api_updating := pqh_rht_shd.api_updating
271: (p_routing_history_id => p_routing_history_id,
272: p_object_version_number => p_object_version_number);
273: --
274: if (l_api_updating

Line 276: <> nvl(pqh_rht_shd.g_old_rec.forwarded_by_member_id,hr_api.g_number)

272: p_object_version_number => p_object_version_number);
273: --
274: if (l_api_updating
275: and nvl(p_forwarded_by_member_id,hr_api.g_number)
276: <> nvl(pqh_rht_shd.g_old_rec.forwarded_by_member_id,hr_api.g_number)
277: or not l_api_updating) and
278: p_forwarded_by_member_id is not null then
279: --
280: -- check if forwarded_by_member_id value exists in pqh_routing_list_members table

Line 292: pqh_rht_shd.constraint_error('PQH_ROUTING_HISTORY_FK5');

288: --
289: -- raise error as FK does not relate to PK in pqh_routing_list_members
290: -- table.
291: --
292: pqh_rht_shd.constraint_error('PQH_ROUTING_HISTORY_FK5');
293: --
294: end if;
295: --
296: close c1;

Line 346: l_api_updating := pqh_rht_shd.api_updating

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

Line 352: <> nvl(pqh_rht_shd.g_old_rec.transaction_category_id,hr_api.g_number)

348: p_object_version_number => p_object_version_number);
349: --
350: if (l_api_updating
351: and nvl(p_transaction_category_id,hr_api.g_number)
352: <> nvl(pqh_rht_shd.g_old_rec.transaction_category_id,hr_api.g_number)
353: or not l_api_updating) then
354: --
355: -- check if transaction_category_id value exists in pqh_transaction_categories table
356: --

Line 367: pqh_rht_shd.constraint_error('PQH_ROUTING_HISTORY_FK4');

363: --
364: -- raise error as FK does not relate to PK in pqh_transaction_categories
365: -- table.
366: --
367: pqh_rht_shd.constraint_error('PQH_ROUTING_HISTORY_FK4');
368: --
369: end if;
370: --
371: close c1;

Line 421: l_api_updating := pqh_rht_shd.api_updating

417: Begin
418: --
419: hr_utility.set_location('Entering:'||l_proc,5);
420: --
421: l_api_updating := pqh_rht_shd.api_updating
422: (p_routing_history_id => p_routing_history_id,
423: p_object_version_number => p_object_version_number);
424: --
425: if (l_api_updating

Line 427: <> nvl(pqh_rht_shd.g_old_rec.forwarded_to_position_id,hr_api.g_number)

423: p_object_version_number => p_object_version_number);
424: --
425: if (l_api_updating
426: and nvl(p_forwarded_to_position_id,hr_api.g_number)
427: <> nvl(pqh_rht_shd.g_old_rec.forwarded_to_position_id,hr_api.g_number)
428: or not l_api_updating) and
429: p_forwarded_to_position_id is not null then
430: --
431: -- check if forwarded_to_position_id value exists in per_all_positions table

Line 443: pqh_rht_shd.constraint_error('PQH_ROUTING_HISTORY_FK3');

439: --
440: -- raise error as FK does not relate to PK in per_all_positions
441: -- table.
442: --
443: pqh_rht_shd.constraint_error('PQH_ROUTING_HISTORY_FK3');
444: --
445: end if;
446: --
447: close c1;

Line 497: l_api_updating := pqh_rht_shd.api_updating

493: Begin
494: --
495: hr_utility.set_location('Entering:'||l_proc,5);
496: --
497: l_api_updating := pqh_rht_shd.api_updating
498: (p_routing_history_id => p_routing_history_id,
499: p_object_version_number => p_object_version_number);
500: --
501: if (l_api_updating

Line 503: <> nvl(pqh_rht_shd.g_old_rec.forwarded_by_position_id,hr_api.g_number)

499: p_object_version_number => p_object_version_number);
500: --
501: if (l_api_updating
502: and nvl(p_forwarded_by_position_id,hr_api.g_number)
503: <> nvl(pqh_rht_shd.g_old_rec.forwarded_by_position_id,hr_api.g_number)
504: or not l_api_updating) and
505: p_forwarded_by_position_id is not null then
506: --
507: -- check if forwarded_by_position_id value exists in per_all_positions table

Line 519: pqh_rht_shd.constraint_error('PQH_ROUTING_HISTORY_FK2');

515: --
516: -- raise error as FK does not relate to PK in per_all_positions
517: -- table.
518: --
519: pqh_rht_shd.constraint_error('PQH_ROUTING_HISTORY_FK2');
520: --
521: end if;
522: --
523: close c1;

Line 573: l_api_updating := pqh_rht_shd.api_updating

569: Begin
570: --
571: hr_utility.set_location('Entering:'||l_proc,5);
572: --
573: l_api_updating := pqh_rht_shd.api_updating
574: (p_routing_history_id => p_routing_history_id,
575: p_object_version_number => p_object_version_number);
576: --
577: if (l_api_updating

Line 579: <> nvl(pqh_rht_shd.g_old_rec.routing_category_id,hr_api.g_number)

575: p_object_version_number => p_object_version_number);
576: --
577: if (l_api_updating
578: and nvl(p_routing_category_id,hr_api.g_number)
579: <> nvl(pqh_rht_shd.g_old_rec.routing_category_id,hr_api.g_number)
580: or not l_api_updating)
581: and p_routing_category_id is not null then
582: --
583: -- check if routing_category_id value exists in pqh_routing_categories table

Line 595: pqh_rht_shd.constraint_error('PQH_ROUTING_HISTORY_FK1');

591: --
592: -- raise error as FK does not relate to PK in pqh_routing_categories
593: -- table.
594: --
595: pqh_rht_shd.constraint_error('PQH_ROUTING_HISTORY_FK1');
596: --
597: end if;
598: --
599: close c1;

Line 645: l_api_updating := pqh_rht_shd.api_updating

641: Begin
642: --
643: hr_utility.set_location('Entering:'||l_proc, 5);
644: --
645: l_api_updating := pqh_rht_shd.api_updating
646: (p_routing_history_id => p_routing_history_id,
647: p_object_version_number => p_object_version_number);
648: --
649: if (l_api_updating

Line 651: <> nvl(pqh_rht_shd.g_old_rec.approval_cd,hr_api.g_varchar2)

647: p_object_version_number => p_object_version_number);
648: --
649: if (l_api_updating
650: and p_approval_cd
651: <> nvl(pqh_rht_shd.g_old_rec.approval_cd,hr_api.g_varchar2)
652: or not l_api_updating)
653: and p_approval_cd is not null then
654: --
655: -- check if value of lookup falls within lookup type.

Line 713: l_api_updating := pqh_rht_shd.api_updating

709: Begin
710: --
711: hr_utility.set_location('Entering:'||l_proc, 5);
712: --
713: l_api_updating := pqh_rht_shd.api_updating
714: (p_routing_history_id => p_routing_history_id,
715: p_object_version_number => p_object_version_number);
716: --
717: if (l_api_updating

Line 719: <> nvl(pqh_rht_shd.g_old_rec.user_action_cd,hr_api.g_varchar2)

715: p_object_version_number => p_object_version_number);
716: --
717: if (l_api_updating
718: and p_user_action_cd
719: <> nvl(pqh_rht_shd.g_old_rec.user_action_cd,hr_api.g_varchar2)
720: or not l_api_updating) then
721: --
722: -- check if value of lookup falls within lookup type.
723: --

Line 788: l_api_updating := pqh_rht_shd.api_updating

784: Begin
785: --
786: hr_utility.set_location('Entering:'||l_proc,5);
787: --
788: l_api_updating := pqh_rht_shd.api_updating
789: (p_routing_history_id => p_routing_history_id,
790: p_object_version_number => p_object_version_number);
791: --
792: if (l_api_updating

Line 794: <> nvl(pqh_rht_shd.g_old_rec.forwarded_to_assignment_id,hr_api.g_number)

790: p_object_version_number => p_object_version_number);
791: --
792: if (l_api_updating
793: and nvl(p_forwarded_to_assignment_id,hr_api.g_number)
794: <> nvl(pqh_rht_shd.g_old_rec.forwarded_to_assignment_id,hr_api.g_number)
795: or not l_api_updating) and
796: p_forwarded_to_assignment_id is not null then
797: --
798: -- check if forwarded_to_assignment_id value exists in per_all_assignments table

Line 867: l_api_updating := pqh_rht_shd.api_updating

863: Begin
864: --
865: hr_utility.set_location('Entering:'||l_proc,5);
866: --
867: l_api_updating := pqh_rht_shd.api_updating
868: (p_routing_history_id => p_routing_history_id,
869: p_object_version_number => p_object_version_number);
870: --
871: if (l_api_updating

Line 873: <> nvl(pqh_rht_shd.g_old_rec.forwarded_by_assignment_id,hr_api.g_number)

869: p_object_version_number => p_object_version_number);
870: --
871: if (l_api_updating
872: and nvl(p_forwarded_by_assignment_id,hr_api.g_number)
873: <> nvl(pqh_rht_shd.g_old_rec.forwarded_by_assignment_id,hr_api.g_number)
874: or not l_api_updating) and
875: p_forwarded_by_assignment_id is not null then
876: --
877: -- check if forwarded_by_assignment_id value exists in per_all_assignments table

Line 945: l_api_updating := pqh_rht_shd.api_updating

941: Begin
942: --
943: hr_utility.set_location('Entering:'||l_proc,5);
944: --
945: l_api_updating := pqh_rht_shd.api_updating
946: (p_routing_history_id => p_routing_history_id,
947: p_object_version_number => p_object_version_number);
948: --
949: if (l_api_updating

Line 951: <> nvl(pqh_rht_shd.g_old_rec.forwarded_to_role_id,hr_api.g_number)

947: p_object_version_number => p_object_version_number);
948: --
949: if (l_api_updating
950: and nvl(p_forwarded_to_role_id,hr_api.g_number)
951: <> nvl(pqh_rht_shd.g_old_rec.forwarded_to_role_id,hr_api.g_number)
952: or not l_api_updating) and
953: p_forwarded_to_role_id is not null then
954: --
955: -- check if forwarded_to_role_id value exists in pqh_roles table

Line 1025: l_api_updating := pqh_rht_shd.api_updating

1021: Begin
1022: --
1023: hr_utility.set_location('Entering:'||l_proc,5);
1024: --
1025: l_api_updating := pqh_rht_shd.api_updating
1026: (p_routing_history_id => p_routing_history_id,
1027: p_object_version_number => p_object_version_number);
1028: --
1029: if (l_api_updating

Line 1031: <> nvl(pqh_rht_shd.g_old_rec.forwarded_by_role_id,hr_api.g_number)

1027: p_object_version_number => p_object_version_number);
1028: --
1029: if (l_api_updating
1030: and nvl(p_forwarded_by_role_id,hr_api.g_number)
1031: <> nvl(pqh_rht_shd.g_old_rec.forwarded_by_role_id,hr_api.g_number)
1032: or not l_api_updating) and
1033: p_forwarded_by_role_id is not null then
1034: --
1035: -- check if forwarded_by_role_id value exists in pqh_roles table

Line 1103: l_api_updating := pqh_rht_shd.api_updating

1099: Begin
1100: --
1101: hr_utility.set_location('Entering:'||l_proc,5);
1102: --
1103: l_api_updating := pqh_rht_shd.api_updating
1104: (p_routing_history_id => p_routing_history_id,
1105: p_object_version_number => p_object_version_number);
1106: --
1107: if (l_api_updating

Line 1109: <> nvl(pqh_rht_shd.g_old_rec.forwarded_to_user_id,hr_api.g_number)

1105: p_object_version_number => p_object_version_number);
1106: --
1107: if (l_api_updating
1108: and nvl(p_forwarded_to_user_id,hr_api.g_number)
1109: <> nvl(pqh_rht_shd.g_old_rec.forwarded_to_user_id,hr_api.g_number)
1110: or not l_api_updating) and
1111: p_forwarded_to_user_id is not null then
1112: --
1113: -- check if forwarded_to_user_id value exists in fnd_user table

Line 1181: l_api_updating := pqh_rht_shd.api_updating

1177: Begin
1178: --
1179: hr_utility.set_location('Entering:'||l_proc,5);
1180: --
1181: l_api_updating := pqh_rht_shd.api_updating
1182: (p_routing_history_id => p_routing_history_id,
1183: p_object_version_number => p_object_version_number);
1184: --
1185: if (l_api_updating

Line 1187: <> nvl(pqh_rht_shd.g_old_rec.forwarded_by_user_id,hr_api.g_number)

1183: p_object_version_number => p_object_version_number);
1184: --
1185: if (l_api_updating
1186: and nvl(p_forwarded_by_user_id,hr_api.g_number)
1187: <> nvl(pqh_rht_shd.g_old_rec.forwarded_by_user_id,hr_api.g_number)
1188: or not l_api_updating) and
1189: p_forwarded_by_user_id is not null then
1190: --
1191: -- check if forwarded_by_user_id value exists in fnd_user table

Line 1219: Procedure insert_validate(p_rec in pqh_rht_shd.g_rec_type

1215: --
1216: -- ----------------------------------------------------------------------------
1217: -- |---------------------------< insert_validate >----------------------------|
1218: -- ----------------------------------------------------------------------------
1219: Procedure insert_validate(p_rec in pqh_rht_shd.g_rec_type
1220: ,p_effective_date in date) is
1221: --
1222: l_proc varchar2(72) := g_package||'insert_validate';
1223: --

Line 1319: Procedure update_validate(p_rec in pqh_rht_shd.g_rec_type

1315: --
1316: -- ----------------------------------------------------------------------------
1317: -- |---------------------------< update_validate >----------------------------|
1318: -- ----------------------------------------------------------------------------
1319: Procedure update_validate(p_rec in pqh_rht_shd.g_rec_type
1320: ,p_effective_date in date) is
1321: --
1322: l_proc varchar2(72) := g_package||'update_validate';
1323: --

Line 1421: Procedure delete_validate(p_rec in pqh_rht_shd.g_rec_type

1417: --
1418: -- ----------------------------------------------------------------------------
1419: -- |---------------------------< delete_validate >----------------------------|
1420: -- ----------------------------------------------------------------------------
1421: Procedure delete_validate(p_rec in pqh_rht_shd.g_rec_type
1422: ,p_effective_date in date) is
1423: --
1424: l_proc varchar2(72) := g_package||'delete_validate';
1425: --