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_ORS_DEL dependencies on PER_ORS_SHD

Line 52: (p_rec in per_ors_shd.g_rec_type

48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml
52: (p_rec in per_ors_shd.g_rec_type
53: ) is
54: --
55: l_proc varchar2(72) := g_package||'delete_dml';
56: --

Line 60: per_ors_shd.g_api_dml := true; -- Set the api dml status

56: --
57: Begin
58: hr_utility.set_location('Entering:'||l_proc, 5);
59: --
60: per_ors_shd.g_api_dml := true; -- Set the api dml status
61: --
62: -- Delete the per_organization_structures row.
63: --
64: delete from per_organization_structures

Line 67: per_ors_shd.g_api_dml := false; -- Unset the api dml status

63: --
64: delete from per_organization_structures
65: where organization_structure_id = p_rec.organization_structure_id;
66: --
67: per_ors_shd.g_api_dml := false; -- Unset the api dml status
68: --
69: hr_utility.set_location(' Leaving:'||l_proc, 10);
70: --
71: Exception

Line 74: per_ors_shd.g_api_dml := false; -- Unset the api dml status

70: --
71: Exception
72: When hr_api.child_integrity_violated then
73: -- Child integrity has been violated
74: per_ors_shd.g_api_dml := false; -- Unset the api dml status
75: per_ors_shd.constraint_error
76: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
77: When Others Then
78: per_ors_shd.g_api_dml := false; -- Unset the api dml status

Line 75: per_ors_shd.constraint_error

71: Exception
72: When hr_api.child_integrity_violated then
73: -- Child integrity has been violated
74: per_ors_shd.g_api_dml := false; -- Unset the api dml status
75: per_ors_shd.constraint_error
76: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
77: When Others Then
78: per_ors_shd.g_api_dml := false; -- Unset the api dml status
79: Raise;

Line 78: per_ors_shd.g_api_dml := false; -- Unset the api dml status

74: per_ors_shd.g_api_dml := false; -- Unset the api dml status
75: per_ors_shd.constraint_error
76: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
77: When Others Then
78: per_ors_shd.g_api_dml := false; -- Unset the api dml status
79: Raise;
80: End delete_dml;
81: --
82: -- ----------------------------------------------------------------------------

Line 114: Procedure pre_delete(p_rec in per_ors_shd.g_rec_type) is

110: -- Internal Row Handler Use Only.
111: --
112: -- {End Of Comments}
113: -- ----------------------------------------------------------------------------
114: Procedure pre_delete(p_rec in per_ors_shd.g_rec_type) is
115: --
116: l_proc varchar2(72) := g_package||'pre_delete';
117: --
118: Begin

Line 156: Procedure post_delete(p_rec in per_ors_shd.g_rec_type) is

152: -- Internal Row Handler Use Only.
153: --
154: -- {End Of Comments}
155: -- -----------------------------------------------------------------------------
156: Procedure post_delete(p_rec in per_ors_shd.g_rec_type) is
157: --
158: l_proc varchar2(72) := g_package||'post_delete';
159: --
160: Begin

Line 168: => per_ors_shd.g_old_rec.business_group_id

164: per_ors_rkd.after_delete
165: (p_organization_structure_id
166: => p_rec.organization_structure_id
167: ,p_business_group_id_o
168: => per_ors_shd.g_old_rec.business_group_id
169: ,p_name_o
170: => per_ors_shd.g_old_rec.name
171: ,p_comments_o
172: => per_ors_shd.g_old_rec.comments

Line 170: => per_ors_shd.g_old_rec.name

166: => p_rec.organization_structure_id
167: ,p_business_group_id_o
168: => per_ors_shd.g_old_rec.business_group_id
169: ,p_name_o
170: => per_ors_shd.g_old_rec.name
171: ,p_comments_o
172: => per_ors_shd.g_old_rec.comments
173: ,p_primary_structure_flag_o
174: => per_ors_shd.g_old_rec.primary_structure_flag

Line 172: => per_ors_shd.g_old_rec.comments

168: => per_ors_shd.g_old_rec.business_group_id
169: ,p_name_o
170: => per_ors_shd.g_old_rec.name
171: ,p_comments_o
172: => per_ors_shd.g_old_rec.comments
173: ,p_primary_structure_flag_o
174: => per_ors_shd.g_old_rec.primary_structure_flag
175: ,p_request_id_o
176: => per_ors_shd.g_old_rec.request_id

Line 174: => per_ors_shd.g_old_rec.primary_structure_flag

170: => per_ors_shd.g_old_rec.name
171: ,p_comments_o
172: => per_ors_shd.g_old_rec.comments
173: ,p_primary_structure_flag_o
174: => per_ors_shd.g_old_rec.primary_structure_flag
175: ,p_request_id_o
176: => per_ors_shd.g_old_rec.request_id
177: ,p_program_application_id_o
178: => per_ors_shd.g_old_rec.program_application_id

Line 176: => per_ors_shd.g_old_rec.request_id

172: => per_ors_shd.g_old_rec.comments
173: ,p_primary_structure_flag_o
174: => per_ors_shd.g_old_rec.primary_structure_flag
175: ,p_request_id_o
176: => per_ors_shd.g_old_rec.request_id
177: ,p_program_application_id_o
178: => per_ors_shd.g_old_rec.program_application_id
179: ,p_program_id_o
180: => per_ors_shd.g_old_rec.program_id

Line 178: => per_ors_shd.g_old_rec.program_application_id

174: => per_ors_shd.g_old_rec.primary_structure_flag
175: ,p_request_id_o
176: => per_ors_shd.g_old_rec.request_id
177: ,p_program_application_id_o
178: => per_ors_shd.g_old_rec.program_application_id
179: ,p_program_id_o
180: => per_ors_shd.g_old_rec.program_id
181: ,p_program_update_date_o
182: => per_ors_shd.g_old_rec.program_update_date

Line 180: => per_ors_shd.g_old_rec.program_id

176: => per_ors_shd.g_old_rec.request_id
177: ,p_program_application_id_o
178: => per_ors_shd.g_old_rec.program_application_id
179: ,p_program_id_o
180: => per_ors_shd.g_old_rec.program_id
181: ,p_program_update_date_o
182: => per_ors_shd.g_old_rec.program_update_date
183: ,p_attribute_category_o
184: => per_ors_shd.g_old_rec.attribute_category

Line 182: => per_ors_shd.g_old_rec.program_update_date

178: => per_ors_shd.g_old_rec.program_application_id
179: ,p_program_id_o
180: => per_ors_shd.g_old_rec.program_id
181: ,p_program_update_date_o
182: => per_ors_shd.g_old_rec.program_update_date
183: ,p_attribute_category_o
184: => per_ors_shd.g_old_rec.attribute_category
185: ,p_attribute1_o
186: => per_ors_shd.g_old_rec.attribute1

Line 184: => per_ors_shd.g_old_rec.attribute_category

180: => per_ors_shd.g_old_rec.program_id
181: ,p_program_update_date_o
182: => per_ors_shd.g_old_rec.program_update_date
183: ,p_attribute_category_o
184: => per_ors_shd.g_old_rec.attribute_category
185: ,p_attribute1_o
186: => per_ors_shd.g_old_rec.attribute1
187: ,p_attribute2_o
188: => per_ors_shd.g_old_rec.attribute2

Line 186: => per_ors_shd.g_old_rec.attribute1

182: => per_ors_shd.g_old_rec.program_update_date
183: ,p_attribute_category_o
184: => per_ors_shd.g_old_rec.attribute_category
185: ,p_attribute1_o
186: => per_ors_shd.g_old_rec.attribute1
187: ,p_attribute2_o
188: => per_ors_shd.g_old_rec.attribute2
189: ,p_attribute3_o
190: => per_ors_shd.g_old_rec.attribute3

Line 188: => per_ors_shd.g_old_rec.attribute2

184: => per_ors_shd.g_old_rec.attribute_category
185: ,p_attribute1_o
186: => per_ors_shd.g_old_rec.attribute1
187: ,p_attribute2_o
188: => per_ors_shd.g_old_rec.attribute2
189: ,p_attribute3_o
190: => per_ors_shd.g_old_rec.attribute3
191: ,p_attribute4_o
192: => per_ors_shd.g_old_rec.attribute4

Line 190: => per_ors_shd.g_old_rec.attribute3

186: => per_ors_shd.g_old_rec.attribute1
187: ,p_attribute2_o
188: => per_ors_shd.g_old_rec.attribute2
189: ,p_attribute3_o
190: => per_ors_shd.g_old_rec.attribute3
191: ,p_attribute4_o
192: => per_ors_shd.g_old_rec.attribute4
193: ,p_attribute5_o
194: => per_ors_shd.g_old_rec.attribute5

Line 192: => per_ors_shd.g_old_rec.attribute4

188: => per_ors_shd.g_old_rec.attribute2
189: ,p_attribute3_o
190: => per_ors_shd.g_old_rec.attribute3
191: ,p_attribute4_o
192: => per_ors_shd.g_old_rec.attribute4
193: ,p_attribute5_o
194: => per_ors_shd.g_old_rec.attribute5
195: ,p_attribute6_o
196: => per_ors_shd.g_old_rec.attribute6

Line 194: => per_ors_shd.g_old_rec.attribute5

190: => per_ors_shd.g_old_rec.attribute3
191: ,p_attribute4_o
192: => per_ors_shd.g_old_rec.attribute4
193: ,p_attribute5_o
194: => per_ors_shd.g_old_rec.attribute5
195: ,p_attribute6_o
196: => per_ors_shd.g_old_rec.attribute6
197: ,p_attribute7_o
198: => per_ors_shd.g_old_rec.attribute7

Line 196: => per_ors_shd.g_old_rec.attribute6

192: => per_ors_shd.g_old_rec.attribute4
193: ,p_attribute5_o
194: => per_ors_shd.g_old_rec.attribute5
195: ,p_attribute6_o
196: => per_ors_shd.g_old_rec.attribute6
197: ,p_attribute7_o
198: => per_ors_shd.g_old_rec.attribute7
199: ,p_attribute8_o
200: => per_ors_shd.g_old_rec.attribute8

Line 198: => per_ors_shd.g_old_rec.attribute7

194: => per_ors_shd.g_old_rec.attribute5
195: ,p_attribute6_o
196: => per_ors_shd.g_old_rec.attribute6
197: ,p_attribute7_o
198: => per_ors_shd.g_old_rec.attribute7
199: ,p_attribute8_o
200: => per_ors_shd.g_old_rec.attribute8
201: ,p_attribute9_o
202: => per_ors_shd.g_old_rec.attribute9

Line 200: => per_ors_shd.g_old_rec.attribute8

196: => per_ors_shd.g_old_rec.attribute6
197: ,p_attribute7_o
198: => per_ors_shd.g_old_rec.attribute7
199: ,p_attribute8_o
200: => per_ors_shd.g_old_rec.attribute8
201: ,p_attribute9_o
202: => per_ors_shd.g_old_rec.attribute9
203: ,p_attribute10_o
204: => per_ors_shd.g_old_rec.attribute10

Line 202: => per_ors_shd.g_old_rec.attribute9

198: => per_ors_shd.g_old_rec.attribute7
199: ,p_attribute8_o
200: => per_ors_shd.g_old_rec.attribute8
201: ,p_attribute9_o
202: => per_ors_shd.g_old_rec.attribute9
203: ,p_attribute10_o
204: => per_ors_shd.g_old_rec.attribute10
205: ,p_attribute11_o
206: => per_ors_shd.g_old_rec.attribute11

Line 204: => per_ors_shd.g_old_rec.attribute10

200: => per_ors_shd.g_old_rec.attribute8
201: ,p_attribute9_o
202: => per_ors_shd.g_old_rec.attribute9
203: ,p_attribute10_o
204: => per_ors_shd.g_old_rec.attribute10
205: ,p_attribute11_o
206: => per_ors_shd.g_old_rec.attribute11
207: ,p_attribute12_o
208: => per_ors_shd.g_old_rec.attribute12

Line 206: => per_ors_shd.g_old_rec.attribute11

202: => per_ors_shd.g_old_rec.attribute9
203: ,p_attribute10_o
204: => per_ors_shd.g_old_rec.attribute10
205: ,p_attribute11_o
206: => per_ors_shd.g_old_rec.attribute11
207: ,p_attribute12_o
208: => per_ors_shd.g_old_rec.attribute12
209: ,p_attribute13_o
210: => per_ors_shd.g_old_rec.attribute13

Line 208: => per_ors_shd.g_old_rec.attribute12

204: => per_ors_shd.g_old_rec.attribute10
205: ,p_attribute11_o
206: => per_ors_shd.g_old_rec.attribute11
207: ,p_attribute12_o
208: => per_ors_shd.g_old_rec.attribute12
209: ,p_attribute13_o
210: => per_ors_shd.g_old_rec.attribute13
211: ,p_attribute14_o
212: => per_ors_shd.g_old_rec.attribute14

Line 210: => per_ors_shd.g_old_rec.attribute13

206: => per_ors_shd.g_old_rec.attribute11
207: ,p_attribute12_o
208: => per_ors_shd.g_old_rec.attribute12
209: ,p_attribute13_o
210: => per_ors_shd.g_old_rec.attribute13
211: ,p_attribute14_o
212: => per_ors_shd.g_old_rec.attribute14
213: ,p_attribute15_o
214: => per_ors_shd.g_old_rec.attribute15

Line 212: => per_ors_shd.g_old_rec.attribute14

208: => per_ors_shd.g_old_rec.attribute12
209: ,p_attribute13_o
210: => per_ors_shd.g_old_rec.attribute13
211: ,p_attribute14_o
212: => per_ors_shd.g_old_rec.attribute14
213: ,p_attribute15_o
214: => per_ors_shd.g_old_rec.attribute15
215: ,p_attribute16_o
216: => per_ors_shd.g_old_rec.attribute16

Line 214: => per_ors_shd.g_old_rec.attribute15

210: => per_ors_shd.g_old_rec.attribute13
211: ,p_attribute14_o
212: => per_ors_shd.g_old_rec.attribute14
213: ,p_attribute15_o
214: => per_ors_shd.g_old_rec.attribute15
215: ,p_attribute16_o
216: => per_ors_shd.g_old_rec.attribute16
217: ,p_attribute17_o
218: => per_ors_shd.g_old_rec.attribute17

Line 216: => per_ors_shd.g_old_rec.attribute16

212: => per_ors_shd.g_old_rec.attribute14
213: ,p_attribute15_o
214: => per_ors_shd.g_old_rec.attribute15
215: ,p_attribute16_o
216: => per_ors_shd.g_old_rec.attribute16
217: ,p_attribute17_o
218: => per_ors_shd.g_old_rec.attribute17
219: ,p_attribute18_o
220: => per_ors_shd.g_old_rec.attribute18

Line 218: => per_ors_shd.g_old_rec.attribute17

214: => per_ors_shd.g_old_rec.attribute15
215: ,p_attribute16_o
216: => per_ors_shd.g_old_rec.attribute16
217: ,p_attribute17_o
218: => per_ors_shd.g_old_rec.attribute17
219: ,p_attribute18_o
220: => per_ors_shd.g_old_rec.attribute18
221: ,p_attribute19_o
222: => per_ors_shd.g_old_rec.attribute19

Line 220: => per_ors_shd.g_old_rec.attribute18

216: => per_ors_shd.g_old_rec.attribute16
217: ,p_attribute17_o
218: => per_ors_shd.g_old_rec.attribute17
219: ,p_attribute18_o
220: => per_ors_shd.g_old_rec.attribute18
221: ,p_attribute19_o
222: => per_ors_shd.g_old_rec.attribute19
223: ,p_attribute20_o
224: => per_ors_shd.g_old_rec.attribute20

Line 222: => per_ors_shd.g_old_rec.attribute19

218: => per_ors_shd.g_old_rec.attribute17
219: ,p_attribute18_o
220: => per_ors_shd.g_old_rec.attribute18
221: ,p_attribute19_o
222: => per_ors_shd.g_old_rec.attribute19
223: ,p_attribute20_o
224: => per_ors_shd.g_old_rec.attribute20
225: ,p_position_control_structure_o
226: => per_ors_shd.g_old_rec.position_control_structure_flg

Line 224: => per_ors_shd.g_old_rec.attribute20

220: => per_ors_shd.g_old_rec.attribute18
221: ,p_attribute19_o
222: => per_ors_shd.g_old_rec.attribute19
223: ,p_attribute20_o
224: => per_ors_shd.g_old_rec.attribute20
225: ,p_position_control_structure_o
226: => per_ors_shd.g_old_rec.position_control_structure_flg
227: ,p_object_version_number_o
228: => per_ors_shd.g_old_rec.object_version_number

Line 226: => per_ors_shd.g_old_rec.position_control_structure_flg

222: => per_ors_shd.g_old_rec.attribute19
223: ,p_attribute20_o
224: => per_ors_shd.g_old_rec.attribute20
225: ,p_position_control_structure_o
226: => per_ors_shd.g_old_rec.position_control_structure_flg
227: ,p_object_version_number_o
228: => per_ors_shd.g_old_rec.object_version_number
229: );
230: --

Line 228: => per_ors_shd.g_old_rec.object_version_number

224: => per_ors_shd.g_old_rec.attribute20
225: ,p_position_control_structure_o
226: => per_ors_shd.g_old_rec.position_control_structure_flg
227: ,p_object_version_number_o
228: => per_ors_shd.g_old_rec.object_version_number
229: );
230: --
231: exception
232: --

Line 248: (p_rec in per_ors_shd.g_rec_type

244: -- ----------------------------------------------------------------------------
245: -- |---------------------------------< del >----------------------------------|
246: -- ----------------------------------------------------------------------------
247: Procedure del
248: (p_rec in per_ors_shd.g_rec_type
249: ) is
250: --
251: l_proc varchar2(72) := g_package||'del';
252: --

Line 258: per_ors_shd.lck

254: hr_utility.set_location('Entering:'||l_proc, 5);
255: --
256: -- We must lock the row which we need to delete.
257: --
258: per_ors_shd.lck
259: (p_rec.organization_structure_id
260: ,p_rec.object_version_number
261: );
262: --

Line 289: l_rec per_ors_shd.g_rec_type;

285: (p_organization_structure_id in number
286: ,p_object_version_number in number
287: ) is
288: --
289: l_rec per_ors_shd.g_rec_type;
290: l_proc varchar2(72) := g_package||'del';
291: --
292: Begin
293: hr_utility.set_location('Entering:'||l_proc, 5);