61: --
62: -- {End Of Comments}
63: -- ----------------------------------------------------------------------------
64: procedure chk_appraisal_id
65: ( p_appraisal_id in per_performance_ratings.appraisal_id%TYPE
66: , p_performance_rating_id in
67: per_performance_ratings.performance_rating_id%TYPE
68: ,p_object_version_number in
69: per_performance_ratings.object_version_number%TYPE
63: -- ----------------------------------------------------------------------------
64: procedure chk_appraisal_id
65: ( p_appraisal_id in per_performance_ratings.appraisal_id%TYPE
66: , p_performance_rating_id in
67: per_performance_ratings.performance_rating_id%TYPE
68: ,p_object_version_number in
69: per_performance_ratings.object_version_number%TYPE
70: );
71: -- ----------------------------------------------------------------------------
65: ( p_appraisal_id in per_performance_ratings.appraisal_id%TYPE
66: , p_performance_rating_id in
67: per_performance_ratings.performance_rating_id%TYPE
68: ,p_object_version_number in
69: per_performance_ratings.object_version_number%TYPE
70: );
71: -- ----------------------------------------------------------------------------
72: -- |---------------------------< chk_objective_id >---------------------------|
73: -- ----------------------------------------------------------------------------
79: --
80: -- {End Of Comments}
81: -- ----------------------------------------------------------------------------
82: procedure chk_objective_id
83: ( p_objective_id in per_performance_ratings.objective_id%TYPE
84: , p_appraisal_id in per_performance_ratings.appraisal_id%TYPE
85: , p_performance_rating_id in
86: per_performance_ratings.performance_rating_id%TYPE
87: ,p_object_version_number in
80: -- {End Of Comments}
81: -- ----------------------------------------------------------------------------
82: procedure chk_objective_id
83: ( p_objective_id in per_performance_ratings.objective_id%TYPE
84: , p_appraisal_id in per_performance_ratings.appraisal_id%TYPE
85: , p_performance_rating_id in
86: per_performance_ratings.performance_rating_id%TYPE
87: ,p_object_version_number in
88: per_performance_ratings.object_version_number%TYPE
82: procedure chk_objective_id
83: ( p_objective_id in per_performance_ratings.objective_id%TYPE
84: , p_appraisal_id in per_performance_ratings.appraisal_id%TYPE
85: , p_performance_rating_id in
86: per_performance_ratings.performance_rating_id%TYPE
87: ,p_object_version_number in
88: per_performance_ratings.object_version_number%TYPE
89: );
90: -- ----------------------------------------------------------------------------
84: , p_appraisal_id in per_performance_ratings.appraisal_id%TYPE
85: , p_performance_rating_id in
86: per_performance_ratings.performance_rating_id%TYPE
87: ,p_object_version_number in
88: per_performance_ratings.object_version_number%TYPE
89: );
90: -- ----------------------------------------------------------------------------
91: -- |---------------------------< chk_performance_level_id >-------------------|
92: -- ----------------------------------------------------------------------------
99: -- {End Of Comments}
100: -- ----------------------------------------------------------------------------
101: procedure chk_performance_level_id
102: ( p_performance_rating_id in
103: per_performance_ratings.performance_rating_id%TYPE
104: , p_performance_level_id in
105: per_performance_ratings.performance_level_id%TYPE
106: , p_appraisal_id in
107: per_performance_ratings.appraisal_id%TYPE
101: procedure chk_performance_level_id
102: ( p_performance_rating_id in
103: per_performance_ratings.performance_rating_id%TYPE
104: , p_performance_level_id in
105: per_performance_ratings.performance_level_id%TYPE
106: , p_appraisal_id in
107: per_performance_ratings.appraisal_id%TYPE
108: ,p_object_version_number in
109: per_performance_ratings.object_version_number%TYPE);
103: per_performance_ratings.performance_rating_id%TYPE
104: , p_performance_level_id in
105: per_performance_ratings.performance_level_id%TYPE
106: , p_appraisal_id in
107: per_performance_ratings.appraisal_id%TYPE
108: ,p_object_version_number in
109: per_performance_ratings.object_version_number%TYPE);
110: -- ----------------------------------------------------------------------------
111: -- |---------------------------< insert_validate >----------------------------|
105: per_performance_ratings.performance_level_id%TYPE
106: , p_appraisal_id in
107: per_performance_ratings.appraisal_id%TYPE
108: ,p_object_version_number in
109: per_performance_ratings.object_version_number%TYPE);
110: -- ----------------------------------------------------------------------------
111: -- |---------------------------< insert_validate >----------------------------|
112: -- ----------------------------------------------------------------------------
113: -- {Start Of Comments}
222: -- Pre Conditions:
223: -- This private procedure will be called from the user hook procedures.
224: --
225: -- In Parameters:
226: -- the primary key of the table (per_performance_ratings)
227: --
228: -- Post Success:
229: -- Processing continues.
230: --