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_SHA_DEL dependencies on PER_SHA_SHD

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

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

Line 62: per_sha_shd.constraint_error

58: --
59: Exception
60: When hr_api.child_integrity_violated then
61: -- Child integrity has been violated
62: per_sha_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_sha_shd.g_rec_type) is

96: -- Internal Row Handler Use Only.
97: --
98: -- {End Of Comments}
99: -- ----------------------------------------------------------------------------
100: Procedure pre_delete(p_rec in per_sha_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_sha_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_sha_shd.g_rec_type) is
143: --
144: l_proc varchar2(72) := g_package||'post_delete';
145: --
146: Begin

Line 153: ,p_date_not_taken_o => per_sha_shd.g_old_rec.date_not_taken

149: -- Start of API User Hook for post_delete.
150: begin
151: per_sha_rkd.after_delete
152: (p_std_holiday_absences_id => p_rec.std_holiday_absences_id
153: ,p_date_not_taken_o => per_sha_shd.g_old_rec.date_not_taken
154: ,p_person_id_o => per_sha_shd.g_old_rec.person_id
155: ,p_standard_holiday_id_o => per_sha_shd.g_old_rec.standard_holiday_id
156: ,p_actual_date_taken_o => per_sha_shd.g_old_rec.actual_date_taken
157: ,p_reason_o => per_sha_shd.g_old_rec.reason

Line 154: ,p_person_id_o => per_sha_shd.g_old_rec.person_id

150: begin
151: per_sha_rkd.after_delete
152: (p_std_holiday_absences_id => p_rec.std_holiday_absences_id
153: ,p_date_not_taken_o => per_sha_shd.g_old_rec.date_not_taken
154: ,p_person_id_o => per_sha_shd.g_old_rec.person_id
155: ,p_standard_holiday_id_o => per_sha_shd.g_old_rec.standard_holiday_id
156: ,p_actual_date_taken_o => per_sha_shd.g_old_rec.actual_date_taken
157: ,p_reason_o => per_sha_shd.g_old_rec.reason
158: ,p_expired_o => per_sha_shd.g_old_rec.expired

Line 155: ,p_standard_holiday_id_o => per_sha_shd.g_old_rec.standard_holiday_id

151: per_sha_rkd.after_delete
152: (p_std_holiday_absences_id => p_rec.std_holiday_absences_id
153: ,p_date_not_taken_o => per_sha_shd.g_old_rec.date_not_taken
154: ,p_person_id_o => per_sha_shd.g_old_rec.person_id
155: ,p_standard_holiday_id_o => per_sha_shd.g_old_rec.standard_holiday_id
156: ,p_actual_date_taken_o => per_sha_shd.g_old_rec.actual_date_taken
157: ,p_reason_o => per_sha_shd.g_old_rec.reason
158: ,p_expired_o => per_sha_shd.g_old_rec.expired
159: ,p_attribute_category_o => per_sha_shd.g_old_rec.attribute_category

Line 156: ,p_actual_date_taken_o => per_sha_shd.g_old_rec.actual_date_taken

152: (p_std_holiday_absences_id => p_rec.std_holiday_absences_id
153: ,p_date_not_taken_o => per_sha_shd.g_old_rec.date_not_taken
154: ,p_person_id_o => per_sha_shd.g_old_rec.person_id
155: ,p_standard_holiday_id_o => per_sha_shd.g_old_rec.standard_holiday_id
156: ,p_actual_date_taken_o => per_sha_shd.g_old_rec.actual_date_taken
157: ,p_reason_o => per_sha_shd.g_old_rec.reason
158: ,p_expired_o => per_sha_shd.g_old_rec.expired
159: ,p_attribute_category_o => per_sha_shd.g_old_rec.attribute_category
160: ,p_attribute1_o => per_sha_shd.g_old_rec.attribute1

Line 157: ,p_reason_o => per_sha_shd.g_old_rec.reason

153: ,p_date_not_taken_o => per_sha_shd.g_old_rec.date_not_taken
154: ,p_person_id_o => per_sha_shd.g_old_rec.person_id
155: ,p_standard_holiday_id_o => per_sha_shd.g_old_rec.standard_holiday_id
156: ,p_actual_date_taken_o => per_sha_shd.g_old_rec.actual_date_taken
157: ,p_reason_o => per_sha_shd.g_old_rec.reason
158: ,p_expired_o => per_sha_shd.g_old_rec.expired
159: ,p_attribute_category_o => per_sha_shd.g_old_rec.attribute_category
160: ,p_attribute1_o => per_sha_shd.g_old_rec.attribute1
161: ,p_attribute2_o => per_sha_shd.g_old_rec.attribute2

Line 158: ,p_expired_o => per_sha_shd.g_old_rec.expired

154: ,p_person_id_o => per_sha_shd.g_old_rec.person_id
155: ,p_standard_holiday_id_o => per_sha_shd.g_old_rec.standard_holiday_id
156: ,p_actual_date_taken_o => per_sha_shd.g_old_rec.actual_date_taken
157: ,p_reason_o => per_sha_shd.g_old_rec.reason
158: ,p_expired_o => per_sha_shd.g_old_rec.expired
159: ,p_attribute_category_o => per_sha_shd.g_old_rec.attribute_category
160: ,p_attribute1_o => per_sha_shd.g_old_rec.attribute1
161: ,p_attribute2_o => per_sha_shd.g_old_rec.attribute2
162: ,p_attribute3_o => per_sha_shd.g_old_rec.attribute3

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

155: ,p_standard_holiday_id_o => per_sha_shd.g_old_rec.standard_holiday_id
156: ,p_actual_date_taken_o => per_sha_shd.g_old_rec.actual_date_taken
157: ,p_reason_o => per_sha_shd.g_old_rec.reason
158: ,p_expired_o => per_sha_shd.g_old_rec.expired
159: ,p_attribute_category_o => per_sha_shd.g_old_rec.attribute_category
160: ,p_attribute1_o => per_sha_shd.g_old_rec.attribute1
161: ,p_attribute2_o => per_sha_shd.g_old_rec.attribute2
162: ,p_attribute3_o => per_sha_shd.g_old_rec.attribute3
163: ,p_attribute4_o => per_sha_shd.g_old_rec.attribute4

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

156: ,p_actual_date_taken_o => per_sha_shd.g_old_rec.actual_date_taken
157: ,p_reason_o => per_sha_shd.g_old_rec.reason
158: ,p_expired_o => per_sha_shd.g_old_rec.expired
159: ,p_attribute_category_o => per_sha_shd.g_old_rec.attribute_category
160: ,p_attribute1_o => per_sha_shd.g_old_rec.attribute1
161: ,p_attribute2_o => per_sha_shd.g_old_rec.attribute2
162: ,p_attribute3_o => per_sha_shd.g_old_rec.attribute3
163: ,p_attribute4_o => per_sha_shd.g_old_rec.attribute4
164: ,p_attribute5_o => per_sha_shd.g_old_rec.attribute5

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

157: ,p_reason_o => per_sha_shd.g_old_rec.reason
158: ,p_expired_o => per_sha_shd.g_old_rec.expired
159: ,p_attribute_category_o => per_sha_shd.g_old_rec.attribute_category
160: ,p_attribute1_o => per_sha_shd.g_old_rec.attribute1
161: ,p_attribute2_o => per_sha_shd.g_old_rec.attribute2
162: ,p_attribute3_o => per_sha_shd.g_old_rec.attribute3
163: ,p_attribute4_o => per_sha_shd.g_old_rec.attribute4
164: ,p_attribute5_o => per_sha_shd.g_old_rec.attribute5
165: ,p_attribute6_o => per_sha_shd.g_old_rec.attribute6

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

173: ,p_attribute14_o => per_sha_shd.g_old_rec.attribute14
174: ,p_attribute15_o => per_sha_shd.g_old_rec.attribute15
175: ,p_attribute16_o => per_sha_shd.g_old_rec.attribute16
176: ,p_attribute17_o => per_sha_shd.g_old_rec.attribute17
177: ,p_attribute18_o => per_sha_shd.g_old_rec.attribute18
178: ,p_attribute19_o => per_sha_shd.g_old_rec.attribute19
179: ,p_attribute20_o => per_sha_shd.g_old_rec.attribute20
180: ,p_object_version_number_o => per_sha_shd.g_old_rec.object_version_number
181: );

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

174: ,p_attribute15_o => per_sha_shd.g_old_rec.attribute15
175: ,p_attribute16_o => per_sha_shd.g_old_rec.attribute16
176: ,p_attribute17_o => per_sha_shd.g_old_rec.attribute17
177: ,p_attribute18_o => per_sha_shd.g_old_rec.attribute18
178: ,p_attribute19_o => per_sha_shd.g_old_rec.attribute19
179: ,p_attribute20_o => per_sha_shd.g_old_rec.attribute20
180: ,p_object_version_number_o => per_sha_shd.g_old_rec.object_version_number
181: );
182: exception

Line 179: ,p_attribute20_o => per_sha_shd.g_old_rec.attribute20

175: ,p_attribute16_o => per_sha_shd.g_old_rec.attribute16
176: ,p_attribute17_o => per_sha_shd.g_old_rec.attribute17
177: ,p_attribute18_o => per_sha_shd.g_old_rec.attribute18
178: ,p_attribute19_o => per_sha_shd.g_old_rec.attribute19
179: ,p_attribute20_o => per_sha_shd.g_old_rec.attribute20
180: ,p_object_version_number_o => per_sha_shd.g_old_rec.object_version_number
181: );
182: exception
183: when hr_api.cannot_find_prog_unit then

Line 180: ,p_object_version_number_o => per_sha_shd.g_old_rec.object_version_number

176: ,p_attribute17_o => per_sha_shd.g_old_rec.attribute17
177: ,p_attribute18_o => per_sha_shd.g_old_rec.attribute18
178: ,p_attribute19_o => per_sha_shd.g_old_rec.attribute19
179: ,p_attribute20_o => per_sha_shd.g_old_rec.attribute20
180: ,p_object_version_number_o => per_sha_shd.g_old_rec.object_version_number
181: );
182: exception
183: when hr_api.cannot_find_prog_unit then
184: hr_api.cannot_find_prog_unit_error

Line 199: p_rec in per_sha_shd.g_rec_type

195: -- |---------------------------------< del >----------------------------------|
196: -- ----------------------------------------------------------------------------
197: Procedure del
198: (
199: p_rec in per_sha_shd.g_rec_type
200: ) is
201: --
202: l_proc varchar2(72) := g_package||'del';
203: --

Line 209: per_sha_shd.lck

205: hr_utility.set_location('Entering:'||l_proc, 5);
206: --
207: -- We must lock the row which we need to delete.
208: --
209: per_sha_shd.lck
210: (
211: p_rec.std_holiday_absences_id,
212: p_rec.object_version_number
213: );

Line 241: l_rec per_sha_shd.g_rec_type;

237: p_std_holiday_absences_id in number,
238: p_object_version_number in number
239: ) is
240: --
241: l_rec per_sha_shd.g_rec_type;
242: l_proc varchar2(72) := g_package||'del';
243: --
244: Begin
245: hr_utility.set_location('Entering:'||l_proc, 5);