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_RNG_BUS dependencies on PQH_RNG_SHD

Line 46: l_api_updating := pqh_rng_shd.api_updating

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

Line 52: <> pqh_rng_shd.g_old_rec.attribute_range_id) then

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

Line 56: pqh_rng_shd.constraint_error('PQH_ATTRIBUTE_RANGES_PK');

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

Line 66: pqh_rng_shd.constraint_error('PQH_ATTRIBUTE_RANGES_PK');

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

Line 118: l_api_updating := pqh_rng_shd.api_updating

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

Line 124: <> nvl(pqh_rng_shd.g_old_rec.position_id,hr_api.g_number)

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

Line 140: pqh_rng_shd.constraint_error('PQH_ATTRIBUTE_RANGES_FK4');

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

Line 201: l_api_updating := pqh_rng_shd.api_updating

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

Line 207: <> nvl(pqh_rng_shd.g_old_rec.routing_category_id,hr_api.g_number)

203: p_object_version_number => p_object_version_number);
204: --
205: if (l_api_updating
206: and nvl(p_routing_category_id,hr_api.g_number)
207: <> nvl(pqh_rng_shd.g_old_rec.routing_category_id,hr_api.g_number)
208: or not l_api_updating) then
209: --
210: -- check if routing_category_id value exists in pqh_routing_categories table
211: --

Line 223: pqh_rng_shd.constraint_error('PQH_ATTRIBUTE_RANGES_FK3');

219: --
220: -- raise error as FK does not relate to PK in pqh_routing_categories
221: -- table.
222: --
223: pqh_rng_shd.constraint_error('PQH_ATTRIBUTE_RANGES_FK3');
224: --
225: end if;
226: --
227: close c1;

Line 286: l_api_updating := pqh_rng_shd.api_updating

282: Begin
283: --
284: hr_utility.set_location('Entering:'||l_proc,5);
285: --
286: l_api_updating := pqh_rng_shd.api_updating
287: (p_attribute_range_id => p_attribute_range_id,
288: p_object_version_number => p_object_version_number);
289: --
290: if (l_api_updating

Line 292: <> nvl(pqh_rng_shd.g_old_rec.routing_list_member_id,hr_api.g_number)

288: p_object_version_number => p_object_version_number);
289: --
290: if (l_api_updating
291: and nvl(p_routing_list_member_id,hr_api.g_number)
292: <> nvl(pqh_rng_shd.g_old_rec.routing_list_member_id,hr_api.g_number)
293: or not l_api_updating) and
294: p_routing_list_member_id is not null then
295: --
296: -- check if routing_list_member_id value exists in pqh_routing_list_members table

Line 308: pqh_rng_shd.constraint_error('PQH_ATTRIBUTE_RANGES_FK2');

304: --
305: -- raise error as FK does not relate to PK in pqh_routing_list_members
306: -- table.
307: --
308: pqh_rng_shd.constraint_error('PQH_ATTRIBUTE_RANGES_FK2');
309: --
310: end if;
311: --
312: close c1;

Line 410: l_api_updating := pqh_rng_shd.api_updating

406: Open csr_list_id;
407: Fetch csr_list_id into l_rlist_id1,l_position_structure_id;
408: Close csr_list_id;
409: --
410: l_api_updating := pqh_rng_shd.api_updating
411: (p_attribute_range_id => p_attribute_range_id,
412: p_object_version_number => p_object_version_number);
413: --
414: if (l_api_updating

Line 416: <> nvl(pqh_rng_shd.g_old_rec.routing_list_member_id,hr_api.g_number)

412: p_object_version_number => p_object_version_number);
413: --
414: if (l_api_updating
415: and nvl(p_routing_list_member_id,hr_api.g_number)
416: <> nvl(pqh_rng_shd.g_old_rec.routing_list_member_id,hr_api.g_number)
417: or not l_api_updating) and
418: p_routing_list_member_id is not null then
419: --
420: -- Get the routing list to which the member belongs

Line 463: <> nvl(pqh_rng_shd.g_old_rec.position_id,hr_api.g_number)

459: -- Check if only position_id is not null
460: --
461: if (l_api_updating
462: and nvl(p_position_id,hr_api.g_number)
463: <> nvl(pqh_rng_shd.g_old_rec.position_id,hr_api.g_number)
464: or not l_api_updating) and
465: p_position_id is not null then
466: --
467: -- Get the position structure to which the position belongs

Line 500: <> nvl(pqh_rng_shd.g_old_rec.assignment_id,hr_api.g_number)

496: -- Check if only assignment_id is not null
497: --
498: if (l_api_updating
499: and nvl(p_assignment_id,hr_api.g_number)
500: <> nvl(pqh_rng_shd.g_old_rec.assignment_id,hr_api.g_number)
501: or not l_api_updating) and
502: p_assignment_id is not null then
503: --
504: If p_routing_list_member_id IS NOT NULL OR p_position_id IS NOT NULL then

Line 558: l_api_updating := pqh_rng_shd.api_updating

554: Begin
555: --
556: hr_utility.set_location('Entering:'||l_proc,5);
557: --
558: l_api_updating := pqh_rng_shd.api_updating
559: (p_attribute_range_id => p_attribute_range_id,
560: p_object_version_number => p_object_version_number);
561: --
562: if (l_api_updating

Line 564: <> nvl(pqh_rng_shd.g_old_rec.attribute_id,hr_api.g_number)

560: p_object_version_number => p_object_version_number);
561: --
562: if (l_api_updating
563: and nvl(p_attribute_id,hr_api.g_number)
564: <> nvl(pqh_rng_shd.g_old_rec.attribute_id,hr_api.g_number)
565: or not l_api_updating)
566: and p_attribute_id is not null then
567: --
568: -- check if attribute_id value exists in pqh_attributes table

Line 580: pqh_rng_shd.constraint_error('PQH_ATTRIBUTE_RANGES_FK1');

576: --
577: -- raise error as FK does not relate to PK in pqh_attributes
578: -- table.
579: --
580: pqh_rng_shd.constraint_error('PQH_ATTRIBUTE_RANGES_FK1');
581: --
582: end if;
583: --
584: close c1;

Line 668: l_api_updating := pqh_rng_shd.api_updating

664: Begin
665: --
666: hr_utility.set_location('Entering:'||l_proc,5);
667: --
668: l_api_updating := pqh_rng_shd.api_updating
669: (p_attribute_range_id => p_attribute_range_id,
670: p_object_version_number => p_object_version_number);
671: --
672: -- Attribute id may be null in case of rules for default hiearchy.

Line 815: l_api_updating := pqh_rng_shd.api_updating

811: Begin
812: --
813: hr_utility.set_location('Entering:'||l_proc, 5);
814: --
815: l_api_updating := pqh_rng_shd.api_updating
816: (p_attribute_range_id => p_attribute_range_id,
817: p_object_version_number => p_object_version_number);
818: --
819: if (l_api_updating

Line 821: <> nvl(pqh_rng_shd.g_old_rec.approver_flag,hr_api.g_varchar2)

817: p_object_version_number => p_object_version_number);
818: --
819: if (l_api_updating
820: and p_approver_flag
821: <> nvl(pqh_rng_shd.g_old_rec.approver_flag,hr_api.g_varchar2)
822: or not l_api_updating)
823: and p_approver_flag is not null then
824: --
825: -- check if value of lookup falls within lookup type.

Line 929: l_api_updating := pqh_rng_shd.api_updating

925: Begin
926: --
927: hr_utility.set_location('Entering:'||l_proc, 5);
928: --
929: l_api_updating := pqh_rng_shd.api_updating
930: (p_attribute_range_id => p_attribute_range_id,
931: p_object_version_number => p_object_version_number);
932: --
933: if (l_api_updating

Line 935: <> nvl(pqh_rng_shd.g_old_rec.enable_flag,hr_api.g_varchar2)

931: p_object_version_number => p_object_version_number);
932: --
933: if (l_api_updating
934: and p_enable_flag
935: <> nvl(pqh_rng_shd.g_old_rec.enable_flag,hr_api.g_varchar2)
936: or not l_api_updating)
937: and p_enable_flag is not null then
938: --
939: -- check if value of lookup falls within lookup type.

Line 957: <> nvl(pqh_rng_shd.g_old_rec.enable_flag,hr_api.g_varchar2)

953: end if;
954: --
955: if l_api_updating
956: and p_enable_flag
957: <> nvl(pqh_rng_shd.g_old_rec.enable_flag,hr_api.g_varchar2)
958: and p_enable_flag is not null then
959: --
960: -- check if value of lookup falls within lookup type.
961: --

Line 1026: l_api_updating := pqh_rng_shd.api_updating

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

Line 1032: <> nvl(pqh_rng_shd.g_old_rec.delete_flag,hr_api.g_varchar2)

1028: p_object_version_number => p_object_version_number);
1029: --
1030: if (l_api_updating
1031: and p_delete_flag
1032: <> nvl(pqh_rng_shd.g_old_rec.delete_flag,hr_api.g_varchar2)
1033: or not l_api_updating)
1034: and p_delete_flag is not null then
1035: --
1036: -- check if value of lookup falls within lookup type.

Line 1060: Procedure insert_validate(p_rec in pqh_rng_shd.g_rec_type

1056: --
1057: -- ----------------------------------------------------------------------------
1058: -- |---------------------------< insert_validate >----------------------------|
1059: -- ----------------------------------------------------------------------------
1060: Procedure insert_validate(p_rec in pqh_rng_shd.g_rec_type
1061: ,p_effective_date in date) is
1062: --
1063: l_proc varchar2(72) := g_package||'insert_validate';
1064: --

Line 1147: Procedure update_validate(p_rec in pqh_rng_shd.g_rec_type

1143: --
1144: -- ----------------------------------------------------------------------------
1145: -- |---------------------------< update_validate >----------------------------|
1146: -- ----------------------------------------------------------------------------
1147: Procedure update_validate(p_rec in pqh_rng_shd.g_rec_type
1148: ,p_effective_date in date) is
1149: --
1150: l_proc varchar2(72) := g_package||'update_validate';
1151: --

Line 1234: Procedure delete_validate(p_rec in pqh_rng_shd.g_rec_type

1230: --
1231: -- ----------------------------------------------------------------------------
1232: -- |---------------------------< delete_validate >----------------------------|
1233: -- ----------------------------------------------------------------------------
1234: Procedure delete_validate(p_rec in pqh_rng_shd.g_rec_type
1235: ,p_effective_date in date) is
1236: --
1237: l_proc varchar2(72) := g_package||'delete_validate';
1238: --