APPS.PER_APR_BUS dependencies on PER_APPRAISALS

Line 36: p_appraisal_id in per_appraisals.appraisal_id%TYPE,

32:
33: -- ---------------------------------------------------------------------------+
34: procedure set_security_group_id
35: (
36: p_appraisal_id in per_appraisals.appraisal_id%TYPE,
37: p_associated_column1 in varchar2 default null
38: );
39: -- ---------------------------------------------------------------------------+
40: -- |------------------------< Externalized chk_ procedures >------------------|

Line 54: (p_appraisal_template_id in per_appraisals.appraisal_template_id%TYPE

50:
51: -- {End of Comments}
52: -- ---------------------------------------------------------------------------+
53: procedure chk_appraisal_template
54: (p_appraisal_template_id in per_appraisals.appraisal_template_id%TYPE
55: ,p_business_group_id in per_appraisals.business_group_id%TYPE
56: ,p_effective_date in date
57: );
58: -- ---------------------------------------------------------------------------+

Line 55: ,p_business_group_id in per_appraisals.business_group_id%TYPE

51: -- {End of Comments}
52: -- ---------------------------------------------------------------------------+
53: procedure chk_appraisal_template
54: (p_appraisal_template_id in per_appraisals.appraisal_template_id%TYPE
55: ,p_business_group_id in per_appraisals.business_group_id%TYPE
56: ,p_effective_date in date
57: );
58: -- ---------------------------------------------------------------------------+
59: -- |------------------------< chk_appraisee_appraiser>------------------------|

Line 71: ,p_business_group_id in per_appraisals.business_group_id%TYPE

67: -- {End of Comments}
68: -- ---------------------------------------------------------------------------+
69: procedure chk_appraisee_appraiser
70: (p_person_id in per_people_f.person_id%TYPE
71: ,p_business_group_id in per_appraisals.business_group_id%TYPE
72: ,p_effective_date in date
73: ,p_person_type in varchar2
74: );
75:

Line 89: (p_main_appraiser_id in per_appraisals.main_appraiser_id%TYPE

85:
86: -- {End of Comments}
87:
88: procedure chk_main_appraiser_id
89: (p_main_appraiser_id in per_appraisals.main_appraiser_id%TYPE
90: ,p_business_group_id in per_appraisals.business_group_id%TYPE
91: ,p_effective_date in date
92: );
93:

Line 90: ,p_business_group_id in per_appraisals.business_group_id%TYPE

86: -- {End of Comments}
87:
88: procedure chk_main_appraiser_id
89: (p_main_appraiser_id in per_appraisals.main_appraiser_id%TYPE
90: ,p_business_group_id in per_appraisals.business_group_id%TYPE
91: ,p_effective_date in date
92: );
93:
94:

Line 107: (p_appraisal_id in per_appraisals.appraisal_id%TYPE

103:
104: -- {End of Comments}
105: -- ---------------------------------------------------------------------------+
106: procedure chk_appraisal_type
107: (p_appraisal_id in per_appraisals.appraisal_id%TYPE
108: ,p_object_version_number in per_appraisals.object_version_number%TYPE
109: ,p_type in per_appraisals.type%TYPE
110: ,p_effective_date in date
111: );

Line 108: ,p_object_version_number in per_appraisals.object_version_number%TYPE

104: -- {End of Comments}
105: -- ---------------------------------------------------------------------------+
106: procedure chk_appraisal_type
107: (p_appraisal_id in per_appraisals.appraisal_id%TYPE
108: ,p_object_version_number in per_appraisals.object_version_number%TYPE
109: ,p_type in per_appraisals.type%TYPE
110: ,p_effective_date in date
111: );
112: -- ---------------------------------------------------------------------------+

Line 109: ,p_type in per_appraisals.type%TYPE

105: -- ---------------------------------------------------------------------------+
106: procedure chk_appraisal_type
107: (p_appraisal_id in per_appraisals.appraisal_id%TYPE
108: ,p_object_version_number in per_appraisals.object_version_number%TYPE
109: ,p_type in per_appraisals.type%TYPE
110: ,p_effective_date in date
111: );
112: -- ---------------------------------------------------------------------------+
113: -- |------------------------< chk_appraisal_status >--------------------------|

Line 124: (p_appraisal_id in per_appraisals.appraisal_id%TYPE

120:
121: -- {End of Comments}
122: -- ---------------------------------------------------------------------------+
123: procedure chk_appraisal_status
124: (p_appraisal_id in per_appraisals.appraisal_id%TYPE
125: ,p_object_version_number in per_appraisals.object_version_number%TYPE
126: ,p_status in per_appraisals.status%TYPE
127: ,p_effective_date in date
128: );

Line 125: ,p_object_version_number in per_appraisals.object_version_number%TYPE

121: -- {End of Comments}
122: -- ---------------------------------------------------------------------------+
123: procedure chk_appraisal_status
124: (p_appraisal_id in per_appraisals.appraisal_id%TYPE
125: ,p_object_version_number in per_appraisals.object_version_number%TYPE
126: ,p_status in per_appraisals.status%TYPE
127: ,p_effective_date in date
128: );
129: -- ---------------------------------------------------------------------------+

Line 126: ,p_status in per_appraisals.status%TYPE

122: -- ---------------------------------------------------------------------------+
123: procedure chk_appraisal_status
124: (p_appraisal_id in per_appraisals.appraisal_id%TYPE
125: ,p_object_version_number in per_appraisals.object_version_number%TYPE
126: ,p_status in per_appraisals.status%TYPE
127: ,p_effective_date in date
128: );
129: -- ---------------------------------------------------------------------------+
130: -- |------------------------< chk_appraisal_status >--------------------------|

Line 141: (p_appraisal_id in per_appraisals.appraisal_id%TYPE

137:
138: -- {End of Comments}
139: -- ---------------------------------------------------------------------------+
140: procedure chk_overall_rating
141: (p_appraisal_id in per_appraisals.appraisal_id%TYPE
142: ,p_object_version_number in per_appraisals.object_version_number%TYPE
143: ,p_appraisal_template_id in per_appraisals.appraisal_template_id%TYPE
144: ,p_overall_performance_level_id in per_appraisals.overall_performance_level_id
145: %TYPE

Line 142: ,p_object_version_number in per_appraisals.object_version_number%TYPE

138: -- {End of Comments}
139: -- ---------------------------------------------------------------------------+
140: procedure chk_overall_rating
141: (p_appraisal_id in per_appraisals.appraisal_id%TYPE
142: ,p_object_version_number in per_appraisals.object_version_number%TYPE
143: ,p_appraisal_template_id in per_appraisals.appraisal_template_id%TYPE
144: ,p_overall_performance_level_id in per_appraisals.overall_performance_level_id
145: %TYPE
146: ,p_business_group_id in per_appraisals.business_group_id%TYPE

Line 143: ,p_appraisal_template_id in per_appraisals.appraisal_template_id%TYPE

139: -- ---------------------------------------------------------------------------+
140: procedure chk_overall_rating
141: (p_appraisal_id in per_appraisals.appraisal_id%TYPE
142: ,p_object_version_number in per_appraisals.object_version_number%TYPE
143: ,p_appraisal_template_id in per_appraisals.appraisal_template_id%TYPE
144: ,p_overall_performance_level_id in per_appraisals.overall_performance_level_id
145: %TYPE
146: ,p_business_group_id in per_appraisals.business_group_id%TYPE
147: );

Line 144: ,p_overall_performance_level_id in per_appraisals.overall_performance_level_id

140: procedure chk_overall_rating
141: (p_appraisal_id in per_appraisals.appraisal_id%TYPE
142: ,p_object_version_number in per_appraisals.object_version_number%TYPE
143: ,p_appraisal_template_id in per_appraisals.appraisal_template_id%TYPE
144: ,p_overall_performance_level_id in per_appraisals.overall_performance_level_id
145: %TYPE
146: ,p_business_group_id in per_appraisals.business_group_id%TYPE
147: );
148: -- ---------------------------------------------------------------------------+

Line 146: ,p_business_group_id in per_appraisals.business_group_id%TYPE

142: ,p_object_version_number in per_appraisals.object_version_number%TYPE
143: ,p_appraisal_template_id in per_appraisals.appraisal_template_id%TYPE
144: ,p_overall_performance_level_id in per_appraisals.overall_performance_level_id
145: %TYPE
146: ,p_business_group_id in per_appraisals.business_group_id%TYPE
147: );
148: -- ---------------------------------------------------------------------------+
149: -- |------------------------< chk_appraisal_period_dates >--------------------|
150: -- ---------------------------------------------------------------------------+

Line 160: (p_appraisal_id in per_appraisals.appraisal_id%TYPE

156:
157: -- {End of Comments}
158: -- ---------------------------------------------------------------------------+
159: procedure chk_appraisal_period_dates
160: (p_appraisal_id in per_appraisals.appraisal_id%TYPE
161: ,p_object_version_number in per_appraisals.object_version_number%TYPE
162: ,p_appraisal_period_start_date in
163: per_appraisals.appraisal_period_start_date%TYPE
164: ,p_appraisal_period_end_date in

Line 161: ,p_object_version_number in per_appraisals.object_version_number%TYPE

157: -- {End of Comments}
158: -- ---------------------------------------------------------------------------+
159: procedure chk_appraisal_period_dates
160: (p_appraisal_id in per_appraisals.appraisal_id%TYPE
161: ,p_object_version_number in per_appraisals.object_version_number%TYPE
162: ,p_appraisal_period_start_date in
163: per_appraisals.appraisal_period_start_date%TYPE
164: ,p_appraisal_period_end_date in
165: per_appraisals.appraisal_period_end_date%TYPE

Line 163: per_appraisals.appraisal_period_start_date%TYPE

159: procedure chk_appraisal_period_dates
160: (p_appraisal_id in per_appraisals.appraisal_id%TYPE
161: ,p_object_version_number in per_appraisals.object_version_number%TYPE
162: ,p_appraisal_period_start_date in
163: per_appraisals.appraisal_period_start_date%TYPE
164: ,p_appraisal_period_end_date in
165: per_appraisals.appraisal_period_end_date%TYPE
166: );
167:

Line 165: per_appraisals.appraisal_period_end_date%TYPE

161: ,p_object_version_number in per_appraisals.object_version_number%TYPE
162: ,p_appraisal_period_start_date in
163: per_appraisals.appraisal_period_start_date%TYPE
164: ,p_appraisal_period_end_date in
165: per_appraisals.appraisal_period_end_date%TYPE
166: );
167:
168: -- ---------------------------------------------------------------------------+
169: -- |---------------------------< insert_validate >----------------------------|

Line 284: -- the primary key of the table (per_appraisals)

280: -- Pre Conditions:
281: -- This private procedure will be called from the user hook procedures.
282:
283: -- In Parameters:
284: -- the primary key of the table (per_appraisals)
285:
286: -- Post Success:
287: -- Processing continues.
288: