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.

[Home] [Help]

APPS.PER_SPP_BUS dependencies on PER_SPP_SHD

Line 95: l_api_updating := per_spp_shd.api_updating

91: hr_utility.set_location(l_proc, 20);
92: --
93: -- Check if inserting or updating with modified values
94: --
95: l_api_updating := per_spp_shd.api_updating
96: (p_placement_id => p_placement_id
97: ,p_effective_date => p_effective_date -- Bug 2488727
98: ,p_object_version_number => p_object_version_number
99: );

Line 101: if ((l_api_updating and per_spp_shd.g_old_rec.assignment_id <> p_assignment_id)

97: ,p_effective_date => p_effective_date -- Bug 2488727
98: ,p_object_version_number => p_object_version_number
99: );
100: --
101: if ((l_api_updating and per_spp_shd.g_old_rec.assignment_id <> p_assignment_id)
102: or
103: (NOT l_api_updating))
104: then
105: hr_utility.set_location(l_proc, 30);

Line 431: l_api_updating := per_spp_shd.api_updating

427: hr_utility.set_location(l_proc, 20);
428: --
429: -- Check if inserting or updating with modified values
430: --
431: l_api_updating := per_spp_shd.api_updating
432: (p_placement_id => p_placement_id
433: ,p_effective_date => p_effective_date
434: ,p_object_version_number => p_object_version_number
435: );

Line 519: l_api_updating := per_spp_shd.api_updating

515: -- will equal new value and l_api_updating will be true.
516: --
517: -- Check if inserting or updating with modified values
518: --
519: l_api_updating := per_spp_shd.api_updating
520: (p_placement_id => p_placement_id
521: ,p_effective_date => l_effective_date not used
522: ,p_object_version_number => p_object_version_number
523: );

Line 525: if ((l_api_updating and per_spp_shd.g_old_rec.auto_increment_flag <> p_auto_increment_flag)

521: ,p_effective_date => l_effective_date not used
522: ,p_object_version_number => p_object_version_number
523: );
524: --
525: if ((l_api_updating and per_spp_shd.g_old_rec.auto_increment_flag <> p_auto_increment_flag)
526: or
527: (NOT l_api_updating))
528: then
529: */

Line 599: (p_rec in per_spp_shd.g_rec_type

595: --
596: -- {End Of Comments}
597: -- ----------------------------------------------------------------------------
598: procedure chk_reason_only_update
599: (p_rec in per_spp_shd.g_rec_type
600: ,p_datetrack_mode in out nocopy varchar2
601: ,p_effective_date in date
602: ,p_validation_start_date in out nocopy date
603: ,p_validation_end_date in out nocopy date

Line 616: l_old_rec per_spp_shd.g_rec_type;

612: l_step_id per_spinal_point_placements_f.step_id%TYPE;
613: l_auto_inc_flag per_spinal_point_placements_f.auto_increment_flag%TYPE;
614: l_parent_spine_id per_spinal_point_placements_f.parent_spine_id%TYPE;
615: l_reason per_spinal_point_placements_f.reason%TYPE;
616: l_old_rec per_spp_shd.g_rec_type;
617: --
618:
619: cursor csr_reason_1 is
620: select placement_id,

Line 800: l_api_updating := per_spp_shd.api_updating

796: hr_utility.set_location(l_proc, 20);
797: --
798: -- Check if inserting or updating with modified values
799: --
800: l_api_updating := per_spp_shd.api_updating
801: (p_placement_id => p_placement_id
802: ,p_effective_date => l_effective_date
803: ,p_object_version_number => p_object_version_number
804: );

Line 808: if ((l_api_updating and (per_spp_shd.g_old_rec.parent_spine_id <> p_parent_spine_id)

804: );
805: --
806: hr_utility.set_location(l_proc, 25);
807: --
808: if ((l_api_updating and (per_spp_shd.g_old_rec.parent_spine_id <> p_parent_spine_id)
809: or (per_spp_shd.g_old_rec.step_id <> p_step_id))
810: or
811: (NOT l_api_updating))
812: then

Line 809: or (per_spp_shd.g_old_rec.step_id <> p_step_id))

805: --
806: hr_utility.set_location(l_proc, 25);
807: --
808: if ((l_api_updating and (per_spp_shd.g_old_rec.parent_spine_id <> p_parent_spine_id)
809: or (per_spp_shd.g_old_rec.step_id <> p_step_id))
810: or
811: (NOT l_api_updating))
812: then
813: hr_utility.set_location(l_proc, 30);

Line 1166: ,p_rec in per_spp_shd.g_rec_type

1162: -- {End Of Comments}
1163: -- ----------------------------------------------------------------------------
1164: Procedure chk_non_updateable_args
1165: (p_effective_date in date
1166: ,p_rec in per_spp_shd.g_rec_type
1167: ) IS
1168: --
1169: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
1170: l_error EXCEPTION;

Line 1179: IF NOT per_spp_shd.api_updating

1175: -- Only proceed with the validation if a row exists for the current
1176: -- record in the HR Schema.
1177: --
1178: hr_utility.set_location(' Entering:'||l_proc,10);
1179: IF NOT per_spp_shd.api_updating
1180: (p_placement_id => p_rec.placement_id
1181: ,p_effective_date => p_effective_date
1182: ,p_object_version_number => p_rec.object_version_number
1183: ) THEN

Line 1432: (p_rec in per_spp_shd.g_rec_type

1428: -- ----------------------------------------------------------------------------
1429: -- |---------------------------< insert_validate >----------------------------|
1430: -- ----------------------------------------------------------------------------
1431: Procedure insert_validate
1432: (p_rec in per_spp_shd.g_rec_type
1433: ,p_effective_date in date
1434: ,p_datetrack_mode in varchar2
1435: ,p_validation_start_date in date
1436: ,p_validation_end_date in date

Line 1505: (p_rec in out nocopy per_spp_shd.g_rec_type

1501: -- ----------------------------------------------------------------------------
1502: -- |---------------------------< update_validate >----------------------------|
1503: -- ----------------------------------------------------------------------------
1504: Procedure update_validate
1505: (p_rec in out nocopy per_spp_shd.g_rec_type
1506: ,p_effective_date in date
1507: ,p_datetrack_mode in out nocopy varchar2
1508: ,p_validation_start_date in out nocopy date
1509: ,p_validation_end_date in out nocopy date

Line 1656: (p_rec in per_spp_shd.g_rec_type

1652: -- ----------------------------------------------------------------------------
1653: -- |---------------------------< delete_validate >----------------------------|
1654: -- ----------------------------------------------------------------------------
1655: Procedure delete_validate
1656: (p_rec in per_spp_shd.g_rec_type
1657: ,p_effective_date in date
1658: ,p_datetrack_mode in varchar2
1659: ,p_validation_start_date in date
1660: ,p_validation_end_date in date