DBA Data[Home] [Help]

APPS.HR_ASSIGNMENT_INTERNAL dependencies on PER_SPINAL_POINT_PLACEMENTS_F

Line 141: -- per_spinal_point_placements_f.

137: -- Description:
138: -- This is used in the case that you need to remove next change on the assignemnt
139: -- form and the next record has a grade step placement assigned which is the
140: -- the first date tracked fecord for this assignment on the table
141: -- per_spinal_point_placements_f.
142: -- The process removes next changes until the effective end date of the record
143: -- on per_spinal_point_placements_f matches the validation end date and then
144: -- this single record is then deleted using DML.
145: --

Line 143: -- on per_spinal_point_placements_f matches the validation end date and then

139: -- form and the next record has a grade step placement assigned which is the
140: -- the first date tracked fecord for this assignment on the table
141: -- per_spinal_point_placements_f.
142: -- The process removes next changes until the effective end date of the record
143: -- on per_spinal_point_placements_f matches the validation end date and then
144: -- this single record is then deleted using DML.
145: --
146: -- In Parameters
147: -- Name Reqd Type Description

Line 1835: ,p_placement_id in per_spinal_point_placements_f.placement_id%Type

1831: -- {End Of Comments}
1832: --
1833: procedure chk_valid_placement_id
1834: (p_assignment_id in per_all_assignments_f.assignment_id%Type
1835: ,p_placement_id in per_spinal_point_placements_f.placement_id%Type
1836: ,p_validation_start_date in date);
1837: --
1838: -- ----------------------------------------------------------------------------
1839: -- |-----------------------< ben_delete_assgt_checks >--------------------------|