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.PER_ASR_DEL dependencies on PER_ASR_SHD

Line 45: Procedure delete_dml(p_rec in per_asr_shd.g_rec_type) is

41: -- Internal Table Handler Use Only.
42: --
43: -- {End Of Comments}
44: -- ----------------------------------------------------------------------------
45: Procedure delete_dml(p_rec in per_asr_shd.g_rec_type) is
46: --
47: l_proc varchar2(72) := g_package||'delete_dml';
48: --
49: Begin

Line 62: per_asr_shd.constraint_error

58: --
59: Exception
60: When hr_api.child_integrity_violated then
61: -- Child integrity has been violated
62: per_asr_shd.constraint_error
63: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
64: When Others Then
65: Raise;
66: End delete_dml;

Line 100: Procedure pre_delete(p_rec in per_asr_shd.g_rec_type) is

96: -- Internal Table Handler Use Only.
97: --
98: -- {End Of Comments}
99: -- ----------------------------------------------------------------------------
100: Procedure pre_delete(p_rec in per_asr_shd.g_rec_type) is
101: --
102: l_proc varchar2(72) := g_package||'pre_delete';
103: --
104: Begin

Line 142: Procedure post_delete(p_rec in per_asr_shd.g_rec_type) is

138: -- Internal table Handler Use Only.
139: --
140: -- {End Of Comments}
141: -- ----------------------------------------------------------------------------
142: Procedure post_delete(p_rec in per_asr_shd.g_rec_type) is
143: --
144: l_proc varchar2(72) := g_package||'post_delete';
145: --
146: Begin

Line 154: p_business_group_id_o => per_asr_shd.g_old_rec.business_group_id ,

150: --
151: begin
152: per_asr_rkd.after_delete (
153: p_assessment_group_id => p_rec.assessment_group_id ,
154: p_business_group_id_o => per_asr_shd.g_old_rec.business_group_id ,
155: p_object_version_number_o => per_asr_shd.g_old_rec.object_version_number ,
156: p_name_o => per_asr_shd.g_old_rec.name ,
157: p_membership_list_o => per_asr_shd.g_old_rec.membership_list ,
158: p_comments_o => per_asr_shd.g_old_rec.comments ,

Line 155: p_object_version_number_o => per_asr_shd.g_old_rec.object_version_number ,

151: begin
152: per_asr_rkd.after_delete (
153: p_assessment_group_id => p_rec.assessment_group_id ,
154: p_business_group_id_o => per_asr_shd.g_old_rec.business_group_id ,
155: p_object_version_number_o => per_asr_shd.g_old_rec.object_version_number ,
156: p_name_o => per_asr_shd.g_old_rec.name ,
157: p_membership_list_o => per_asr_shd.g_old_rec.membership_list ,
158: p_comments_o => per_asr_shd.g_old_rec.comments ,
159: p_attribute_category_o => per_asr_shd.g_old_rec.attribute_category ,

Line 156: p_name_o => per_asr_shd.g_old_rec.name ,

152: per_asr_rkd.after_delete (
153: p_assessment_group_id => p_rec.assessment_group_id ,
154: p_business_group_id_o => per_asr_shd.g_old_rec.business_group_id ,
155: p_object_version_number_o => per_asr_shd.g_old_rec.object_version_number ,
156: p_name_o => per_asr_shd.g_old_rec.name ,
157: p_membership_list_o => per_asr_shd.g_old_rec.membership_list ,
158: p_comments_o => per_asr_shd.g_old_rec.comments ,
159: p_attribute_category_o => per_asr_shd.g_old_rec.attribute_category ,
160: p_attribute1_o => per_asr_shd.g_old_rec.attribute1 ,

Line 157: p_membership_list_o => per_asr_shd.g_old_rec.membership_list ,

153: p_assessment_group_id => p_rec.assessment_group_id ,
154: p_business_group_id_o => per_asr_shd.g_old_rec.business_group_id ,
155: p_object_version_number_o => per_asr_shd.g_old_rec.object_version_number ,
156: p_name_o => per_asr_shd.g_old_rec.name ,
157: p_membership_list_o => per_asr_shd.g_old_rec.membership_list ,
158: p_comments_o => per_asr_shd.g_old_rec.comments ,
159: p_attribute_category_o => per_asr_shd.g_old_rec.attribute_category ,
160: p_attribute1_o => per_asr_shd.g_old_rec.attribute1 ,
161: p_attribute2_o => per_asr_shd.g_old_rec.attribute2 ,

Line 158: p_comments_o => per_asr_shd.g_old_rec.comments ,

154: p_business_group_id_o => per_asr_shd.g_old_rec.business_group_id ,
155: p_object_version_number_o => per_asr_shd.g_old_rec.object_version_number ,
156: p_name_o => per_asr_shd.g_old_rec.name ,
157: p_membership_list_o => per_asr_shd.g_old_rec.membership_list ,
158: p_comments_o => per_asr_shd.g_old_rec.comments ,
159: p_attribute_category_o => per_asr_shd.g_old_rec.attribute_category ,
160: p_attribute1_o => per_asr_shd.g_old_rec.attribute1 ,
161: p_attribute2_o => per_asr_shd.g_old_rec.attribute2 ,
162: p_attribute3_o => per_asr_shd.g_old_rec.attribute3 ,

Line 159: p_attribute_category_o => per_asr_shd.g_old_rec.attribute_category ,

155: p_object_version_number_o => per_asr_shd.g_old_rec.object_version_number ,
156: p_name_o => per_asr_shd.g_old_rec.name ,
157: p_membership_list_o => per_asr_shd.g_old_rec.membership_list ,
158: p_comments_o => per_asr_shd.g_old_rec.comments ,
159: p_attribute_category_o => per_asr_shd.g_old_rec.attribute_category ,
160: p_attribute1_o => per_asr_shd.g_old_rec.attribute1 ,
161: p_attribute2_o => per_asr_shd.g_old_rec.attribute2 ,
162: p_attribute3_o => per_asr_shd.g_old_rec.attribute3 ,
163: p_attribute4_o => per_asr_shd.g_old_rec.attribute4 ,

Line 160: p_attribute1_o => per_asr_shd.g_old_rec.attribute1 ,

156: p_name_o => per_asr_shd.g_old_rec.name ,
157: p_membership_list_o => per_asr_shd.g_old_rec.membership_list ,
158: p_comments_o => per_asr_shd.g_old_rec.comments ,
159: p_attribute_category_o => per_asr_shd.g_old_rec.attribute_category ,
160: p_attribute1_o => per_asr_shd.g_old_rec.attribute1 ,
161: p_attribute2_o => per_asr_shd.g_old_rec.attribute2 ,
162: p_attribute3_o => per_asr_shd.g_old_rec.attribute3 ,
163: p_attribute4_o => per_asr_shd.g_old_rec.attribute4 ,
164: p_attribute5_o => per_asr_shd.g_old_rec.attribute5 ,

Line 161: p_attribute2_o => per_asr_shd.g_old_rec.attribute2 ,

157: p_membership_list_o => per_asr_shd.g_old_rec.membership_list ,
158: p_comments_o => per_asr_shd.g_old_rec.comments ,
159: p_attribute_category_o => per_asr_shd.g_old_rec.attribute_category ,
160: p_attribute1_o => per_asr_shd.g_old_rec.attribute1 ,
161: p_attribute2_o => per_asr_shd.g_old_rec.attribute2 ,
162: p_attribute3_o => per_asr_shd.g_old_rec.attribute3 ,
163: p_attribute4_o => per_asr_shd.g_old_rec.attribute4 ,
164: p_attribute5_o => per_asr_shd.g_old_rec.attribute5 ,
165: p_attribute6_o => per_asr_shd.g_old_rec.attribute6 ,

Line 162: p_attribute3_o => per_asr_shd.g_old_rec.attribute3 ,

158: p_comments_o => per_asr_shd.g_old_rec.comments ,
159: p_attribute_category_o => per_asr_shd.g_old_rec.attribute_category ,
160: p_attribute1_o => per_asr_shd.g_old_rec.attribute1 ,
161: p_attribute2_o => per_asr_shd.g_old_rec.attribute2 ,
162: p_attribute3_o => per_asr_shd.g_old_rec.attribute3 ,
163: p_attribute4_o => per_asr_shd.g_old_rec.attribute4 ,
164: p_attribute5_o => per_asr_shd.g_old_rec.attribute5 ,
165: p_attribute6_o => per_asr_shd.g_old_rec.attribute6 ,
166: p_attribute7_o => per_asr_shd.g_old_rec.attribute7 ,

Line 163: p_attribute4_o => per_asr_shd.g_old_rec.attribute4 ,

159: p_attribute_category_o => per_asr_shd.g_old_rec.attribute_category ,
160: p_attribute1_o => per_asr_shd.g_old_rec.attribute1 ,
161: p_attribute2_o => per_asr_shd.g_old_rec.attribute2 ,
162: p_attribute3_o => per_asr_shd.g_old_rec.attribute3 ,
163: p_attribute4_o => per_asr_shd.g_old_rec.attribute4 ,
164: p_attribute5_o => per_asr_shd.g_old_rec.attribute5 ,
165: p_attribute6_o => per_asr_shd.g_old_rec.attribute6 ,
166: p_attribute7_o => per_asr_shd.g_old_rec.attribute7 ,
167: p_attribute8_o => per_asr_shd.g_old_rec.attribute8 ,

Line 164: p_attribute5_o => per_asr_shd.g_old_rec.attribute5 ,

160: p_attribute1_o => per_asr_shd.g_old_rec.attribute1 ,
161: p_attribute2_o => per_asr_shd.g_old_rec.attribute2 ,
162: p_attribute3_o => per_asr_shd.g_old_rec.attribute3 ,
163: p_attribute4_o => per_asr_shd.g_old_rec.attribute4 ,
164: p_attribute5_o => per_asr_shd.g_old_rec.attribute5 ,
165: p_attribute6_o => per_asr_shd.g_old_rec.attribute6 ,
166: p_attribute7_o => per_asr_shd.g_old_rec.attribute7 ,
167: p_attribute8_o => per_asr_shd.g_old_rec.attribute8 ,
168: p_attribute9_o => per_asr_shd.g_old_rec.attribute9 ,

Line 165: p_attribute6_o => per_asr_shd.g_old_rec.attribute6 ,

161: p_attribute2_o => per_asr_shd.g_old_rec.attribute2 ,
162: p_attribute3_o => per_asr_shd.g_old_rec.attribute3 ,
163: p_attribute4_o => per_asr_shd.g_old_rec.attribute4 ,
164: p_attribute5_o => per_asr_shd.g_old_rec.attribute5 ,
165: p_attribute6_o => per_asr_shd.g_old_rec.attribute6 ,
166: p_attribute7_o => per_asr_shd.g_old_rec.attribute7 ,
167: p_attribute8_o => per_asr_shd.g_old_rec.attribute8 ,
168: p_attribute9_o => per_asr_shd.g_old_rec.attribute9 ,
169: p_attribute10_o => per_asr_shd.g_old_rec.attribute10 ,

Line 166: p_attribute7_o => per_asr_shd.g_old_rec.attribute7 ,

162: p_attribute3_o => per_asr_shd.g_old_rec.attribute3 ,
163: p_attribute4_o => per_asr_shd.g_old_rec.attribute4 ,
164: p_attribute5_o => per_asr_shd.g_old_rec.attribute5 ,
165: p_attribute6_o => per_asr_shd.g_old_rec.attribute6 ,
166: p_attribute7_o => per_asr_shd.g_old_rec.attribute7 ,
167: p_attribute8_o => per_asr_shd.g_old_rec.attribute8 ,
168: p_attribute9_o => per_asr_shd.g_old_rec.attribute9 ,
169: p_attribute10_o => per_asr_shd.g_old_rec.attribute10 ,
170: p_attribute11_o => per_asr_shd.g_old_rec.attribute11 ,

Line 167: p_attribute8_o => per_asr_shd.g_old_rec.attribute8 ,

163: p_attribute4_o => per_asr_shd.g_old_rec.attribute4 ,
164: p_attribute5_o => per_asr_shd.g_old_rec.attribute5 ,
165: p_attribute6_o => per_asr_shd.g_old_rec.attribute6 ,
166: p_attribute7_o => per_asr_shd.g_old_rec.attribute7 ,
167: p_attribute8_o => per_asr_shd.g_old_rec.attribute8 ,
168: p_attribute9_o => per_asr_shd.g_old_rec.attribute9 ,
169: p_attribute10_o => per_asr_shd.g_old_rec.attribute10 ,
170: p_attribute11_o => per_asr_shd.g_old_rec.attribute11 ,
171: p_attribute12_o => per_asr_shd.g_old_rec.attribute12 ,

Line 168: p_attribute9_o => per_asr_shd.g_old_rec.attribute9 ,

164: p_attribute5_o => per_asr_shd.g_old_rec.attribute5 ,
165: p_attribute6_o => per_asr_shd.g_old_rec.attribute6 ,
166: p_attribute7_o => per_asr_shd.g_old_rec.attribute7 ,
167: p_attribute8_o => per_asr_shd.g_old_rec.attribute8 ,
168: p_attribute9_o => per_asr_shd.g_old_rec.attribute9 ,
169: p_attribute10_o => per_asr_shd.g_old_rec.attribute10 ,
170: p_attribute11_o => per_asr_shd.g_old_rec.attribute11 ,
171: p_attribute12_o => per_asr_shd.g_old_rec.attribute12 ,
172: p_attribute13_o => per_asr_shd.g_old_rec.attribute13 ,

Line 169: p_attribute10_o => per_asr_shd.g_old_rec.attribute10 ,

165: p_attribute6_o => per_asr_shd.g_old_rec.attribute6 ,
166: p_attribute7_o => per_asr_shd.g_old_rec.attribute7 ,
167: p_attribute8_o => per_asr_shd.g_old_rec.attribute8 ,
168: p_attribute9_o => per_asr_shd.g_old_rec.attribute9 ,
169: p_attribute10_o => per_asr_shd.g_old_rec.attribute10 ,
170: p_attribute11_o => per_asr_shd.g_old_rec.attribute11 ,
171: p_attribute12_o => per_asr_shd.g_old_rec.attribute12 ,
172: p_attribute13_o => per_asr_shd.g_old_rec.attribute13 ,
173: p_attribute14_o => per_asr_shd.g_old_rec.attribute14 ,

Line 170: p_attribute11_o => per_asr_shd.g_old_rec.attribute11 ,

166: p_attribute7_o => per_asr_shd.g_old_rec.attribute7 ,
167: p_attribute8_o => per_asr_shd.g_old_rec.attribute8 ,
168: p_attribute9_o => per_asr_shd.g_old_rec.attribute9 ,
169: p_attribute10_o => per_asr_shd.g_old_rec.attribute10 ,
170: p_attribute11_o => per_asr_shd.g_old_rec.attribute11 ,
171: p_attribute12_o => per_asr_shd.g_old_rec.attribute12 ,
172: p_attribute13_o => per_asr_shd.g_old_rec.attribute13 ,
173: p_attribute14_o => per_asr_shd.g_old_rec.attribute14 ,
174: p_attribute15_o => per_asr_shd.g_old_rec.attribute15 ,

Line 171: p_attribute12_o => per_asr_shd.g_old_rec.attribute12 ,

167: p_attribute8_o => per_asr_shd.g_old_rec.attribute8 ,
168: p_attribute9_o => per_asr_shd.g_old_rec.attribute9 ,
169: p_attribute10_o => per_asr_shd.g_old_rec.attribute10 ,
170: p_attribute11_o => per_asr_shd.g_old_rec.attribute11 ,
171: p_attribute12_o => per_asr_shd.g_old_rec.attribute12 ,
172: p_attribute13_o => per_asr_shd.g_old_rec.attribute13 ,
173: p_attribute14_o => per_asr_shd.g_old_rec.attribute14 ,
174: p_attribute15_o => per_asr_shd.g_old_rec.attribute15 ,
175: p_attribute16_o => per_asr_shd.g_old_rec.attribute16 ,

Line 172: p_attribute13_o => per_asr_shd.g_old_rec.attribute13 ,

168: p_attribute9_o => per_asr_shd.g_old_rec.attribute9 ,
169: p_attribute10_o => per_asr_shd.g_old_rec.attribute10 ,
170: p_attribute11_o => per_asr_shd.g_old_rec.attribute11 ,
171: p_attribute12_o => per_asr_shd.g_old_rec.attribute12 ,
172: p_attribute13_o => per_asr_shd.g_old_rec.attribute13 ,
173: p_attribute14_o => per_asr_shd.g_old_rec.attribute14 ,
174: p_attribute15_o => per_asr_shd.g_old_rec.attribute15 ,
175: p_attribute16_o => per_asr_shd.g_old_rec.attribute16 ,
176: p_attribute17_o => per_asr_shd.g_old_rec.attribute17 ,

Line 173: p_attribute14_o => per_asr_shd.g_old_rec.attribute14 ,

169: p_attribute10_o => per_asr_shd.g_old_rec.attribute10 ,
170: p_attribute11_o => per_asr_shd.g_old_rec.attribute11 ,
171: p_attribute12_o => per_asr_shd.g_old_rec.attribute12 ,
172: p_attribute13_o => per_asr_shd.g_old_rec.attribute13 ,
173: p_attribute14_o => per_asr_shd.g_old_rec.attribute14 ,
174: p_attribute15_o => per_asr_shd.g_old_rec.attribute15 ,
175: p_attribute16_o => per_asr_shd.g_old_rec.attribute16 ,
176: p_attribute17_o => per_asr_shd.g_old_rec.attribute17 ,
177: p_attribute18_o => per_asr_shd.g_old_rec.attribute18 ,

Line 174: p_attribute15_o => per_asr_shd.g_old_rec.attribute15 ,

170: p_attribute11_o => per_asr_shd.g_old_rec.attribute11 ,
171: p_attribute12_o => per_asr_shd.g_old_rec.attribute12 ,
172: p_attribute13_o => per_asr_shd.g_old_rec.attribute13 ,
173: p_attribute14_o => per_asr_shd.g_old_rec.attribute14 ,
174: p_attribute15_o => per_asr_shd.g_old_rec.attribute15 ,
175: p_attribute16_o => per_asr_shd.g_old_rec.attribute16 ,
176: p_attribute17_o => per_asr_shd.g_old_rec.attribute17 ,
177: p_attribute18_o => per_asr_shd.g_old_rec.attribute18 ,
178: p_attribute19_o => per_asr_shd.g_old_rec.attribute19 ,

Line 175: p_attribute16_o => per_asr_shd.g_old_rec.attribute16 ,

171: p_attribute12_o => per_asr_shd.g_old_rec.attribute12 ,
172: p_attribute13_o => per_asr_shd.g_old_rec.attribute13 ,
173: p_attribute14_o => per_asr_shd.g_old_rec.attribute14 ,
174: p_attribute15_o => per_asr_shd.g_old_rec.attribute15 ,
175: p_attribute16_o => per_asr_shd.g_old_rec.attribute16 ,
176: p_attribute17_o => per_asr_shd.g_old_rec.attribute17 ,
177: p_attribute18_o => per_asr_shd.g_old_rec.attribute18 ,
178: p_attribute19_o => per_asr_shd.g_old_rec.attribute19 ,
179: p_attribute20_o => per_asr_shd.g_old_rec.attribute20 );

Line 176: p_attribute17_o => per_asr_shd.g_old_rec.attribute17 ,

172: p_attribute13_o => per_asr_shd.g_old_rec.attribute13 ,
173: p_attribute14_o => per_asr_shd.g_old_rec.attribute14 ,
174: p_attribute15_o => per_asr_shd.g_old_rec.attribute15 ,
175: p_attribute16_o => per_asr_shd.g_old_rec.attribute16 ,
176: p_attribute17_o => per_asr_shd.g_old_rec.attribute17 ,
177: p_attribute18_o => per_asr_shd.g_old_rec.attribute18 ,
178: p_attribute19_o => per_asr_shd.g_old_rec.attribute19 ,
179: p_attribute20_o => per_asr_shd.g_old_rec.attribute20 );
180: exception

Line 177: p_attribute18_o => per_asr_shd.g_old_rec.attribute18 ,

173: p_attribute14_o => per_asr_shd.g_old_rec.attribute14 ,
174: p_attribute15_o => per_asr_shd.g_old_rec.attribute15 ,
175: p_attribute16_o => per_asr_shd.g_old_rec.attribute16 ,
176: p_attribute17_o => per_asr_shd.g_old_rec.attribute17 ,
177: p_attribute18_o => per_asr_shd.g_old_rec.attribute18 ,
178: p_attribute19_o => per_asr_shd.g_old_rec.attribute19 ,
179: p_attribute20_o => per_asr_shd.g_old_rec.attribute20 );
180: exception
181: when hr_api.cannot_find_prog_unit then

Line 178: p_attribute19_o => per_asr_shd.g_old_rec.attribute19 ,

174: p_attribute15_o => per_asr_shd.g_old_rec.attribute15 ,
175: p_attribute16_o => per_asr_shd.g_old_rec.attribute16 ,
176: p_attribute17_o => per_asr_shd.g_old_rec.attribute17 ,
177: p_attribute18_o => per_asr_shd.g_old_rec.attribute18 ,
178: p_attribute19_o => per_asr_shd.g_old_rec.attribute19 ,
179: p_attribute20_o => per_asr_shd.g_old_rec.attribute20 );
180: exception
181: when hr_api.cannot_find_prog_unit then
182: hr_api.cannot_find_prog_unit_error

Line 179: p_attribute20_o => per_asr_shd.g_old_rec.attribute20 );

175: p_attribute16_o => per_asr_shd.g_old_rec.attribute16 ,
176: p_attribute17_o => per_asr_shd.g_old_rec.attribute17 ,
177: p_attribute18_o => per_asr_shd.g_old_rec.attribute18 ,
178: p_attribute19_o => per_asr_shd.g_old_rec.attribute19 ,
179: p_attribute20_o => per_asr_shd.g_old_rec.attribute20 );
180: exception
181: when hr_api.cannot_find_prog_unit then
182: hr_api.cannot_find_prog_unit_error
183: ( p_module_name => 'PER_ASSESSMENT_GROUPS'

Line 197: p_rec in per_asr_shd.g_rec_type,

193: -- |---------------------------------< del >----------------------------------|
194: -- ----------------------------------------------------------------------------
195: Procedure del
196: (
197: p_rec in per_asr_shd.g_rec_type,
198: p_validate in boolean default false
199: ) is
200: --
201: l_proc varchar2(72) := g_package||'del';

Line 217: per_asr_shd.lck

213: End If;
214: --
215: -- We must lock the row which we need to delete.
216: --
217: per_asr_shd.lck
218: (
219: p_rec.assessment_group_id,
220: p_rec.object_version_number
221: );

Line 265: l_rec per_asr_shd.g_rec_type;

261: p_object_version_number in number,
262: p_validate in boolean default false
263: ) is
264: --
265: l_rec per_asr_shd.g_rec_type;
266: l_proc varchar2(72) := g_package||'del';
267: --
268: Begin
269: hr_utility.set_location('Entering:'||l_proc, 5);