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

Line 55: (p_rec in out nocopy per_ors_shd.g_rec_type

51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy per_ors_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --

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

62: --
63: -- Increment the object version
64: p_rec.object_version_number := p_rec.object_version_number + 1;
65: --
66: per_ors_shd.g_api_dml := true; -- Set the api dml status
67: --
68: -- Update the per_organization_structures Row
69: --
70: update per_organization_structures

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

102: ,position_control_structure_flg = p_rec.position_control_structure_flg
103: ,object_version_number = p_rec.object_version_number
104: where organization_structure_id = p_rec.organization_structure_id;
105: --
106: per_ors_shd.g_api_dml := false; -- Unset the api dml status
107: --
108: hr_utility.set_location(' Leaving:'||l_proc, 10);
109: --
110: Exception

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

109: --
110: Exception
111: When hr_api.check_integrity_violated Then
112: -- A check constraint has been violated
113: per_ors_shd.g_api_dml := false; -- Unset the api dml status
114: per_ors_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.parent_integrity_violated Then
117: -- Parent integrity has been violated

Line 114: per_ors_shd.constraint_error

110: Exception
111: When hr_api.check_integrity_violated Then
112: -- A check constraint has been violated
113: per_ors_shd.g_api_dml := false; -- Unset the api dml status
114: per_ors_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.parent_integrity_violated Then
117: -- Parent integrity has been violated
118: per_ors_shd.g_api_dml := false; -- Unset the api dml status

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

114: per_ors_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.parent_integrity_violated Then
117: -- Parent integrity has been violated
118: per_ors_shd.g_api_dml := false; -- Unset the api dml status
119: per_ors_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When hr_api.unique_integrity_violated Then
122: -- Unique integrity has been violated

Line 119: per_ors_shd.constraint_error

115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.parent_integrity_violated Then
117: -- Parent integrity has been violated
118: per_ors_shd.g_api_dml := false; -- Unset the api dml status
119: per_ors_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When hr_api.unique_integrity_violated Then
122: -- Unique integrity has been violated
123: per_ors_shd.g_api_dml := false; -- Unset the api dml status

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

119: per_ors_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When hr_api.unique_integrity_violated Then
122: -- Unique integrity has been violated
123: per_ors_shd.g_api_dml := false; -- Unset the api dml status
124: per_ors_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When Others Then
127: per_ors_shd.g_api_dml := false; -- Unset the api dml status

Line 124: per_ors_shd.constraint_error

120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When hr_api.unique_integrity_violated Then
122: -- Unique integrity has been violated
123: per_ors_shd.g_api_dml := false; -- Unset the api dml status
124: per_ors_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When Others Then
127: per_ors_shd.g_api_dml := false; -- Unset the api dml status
128: Raise;

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

123: per_ors_shd.g_api_dml := false; -- Unset the api dml status
124: per_ors_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When Others Then
127: per_ors_shd.g_api_dml := false; -- Unset the api dml status
128: Raise;
129: End update_dml;
130: --
131: -- ----------------------------------------------------------------------------

Line 164: (p_rec in per_ors_shd.g_rec_type

160: --
161: -- {End Of Comments}
162: -- ----------------------------------------------------------------------------
163: Procedure pre_update
164: (p_rec in per_ors_shd.g_rec_type
165: ) is
166: --
167: l_proc varchar2(72) := g_package||'pre_update';
168: --

Line 209: ,p_rec in per_ors_shd.g_rec_type

205: -- {End Of Comments}
206: -- ----------------------------------------------------------------------------
207: Procedure post_update
208: (p_effective_date in date
209: ,p_rec in per_ors_shd.g_rec_type
210: ) is
211: --
212: l_proc varchar2(72) := g_package||'post_update';
213: --

Line 285: => per_ors_shd.g_old_rec.business_group_id

281: => p_rec.position_control_structure_flg
282: ,p_object_version_number
283: => p_rec.object_version_number
284: ,p_business_group_id_o
285: => per_ors_shd.g_old_rec.business_group_id
286: ,p_name_o
287: => per_ors_shd.g_old_rec.name
288: ,p_comments_o
289: => per_ors_shd.g_old_rec.comments

Line 287: => per_ors_shd.g_old_rec.name

283: => p_rec.object_version_number
284: ,p_business_group_id_o
285: => per_ors_shd.g_old_rec.business_group_id
286: ,p_name_o
287: => per_ors_shd.g_old_rec.name
288: ,p_comments_o
289: => per_ors_shd.g_old_rec.comments
290: ,p_primary_structure_flag_o
291: => per_ors_shd.g_old_rec.primary_structure_flag

Line 289: => per_ors_shd.g_old_rec.comments

285: => per_ors_shd.g_old_rec.business_group_id
286: ,p_name_o
287: => per_ors_shd.g_old_rec.name
288: ,p_comments_o
289: => per_ors_shd.g_old_rec.comments
290: ,p_primary_structure_flag_o
291: => per_ors_shd.g_old_rec.primary_structure_flag
292: ,p_request_id_o
293: => per_ors_shd.g_old_rec.request_id

Line 291: => per_ors_shd.g_old_rec.primary_structure_flag

287: => per_ors_shd.g_old_rec.name
288: ,p_comments_o
289: => per_ors_shd.g_old_rec.comments
290: ,p_primary_structure_flag_o
291: => per_ors_shd.g_old_rec.primary_structure_flag
292: ,p_request_id_o
293: => per_ors_shd.g_old_rec.request_id
294: ,p_program_application_id_o
295: => per_ors_shd.g_old_rec.program_application_id

Line 293: => per_ors_shd.g_old_rec.request_id

289: => per_ors_shd.g_old_rec.comments
290: ,p_primary_structure_flag_o
291: => per_ors_shd.g_old_rec.primary_structure_flag
292: ,p_request_id_o
293: => per_ors_shd.g_old_rec.request_id
294: ,p_program_application_id_o
295: => per_ors_shd.g_old_rec.program_application_id
296: ,p_program_id_o
297: => per_ors_shd.g_old_rec.program_id

Line 295: => per_ors_shd.g_old_rec.program_application_id

291: => per_ors_shd.g_old_rec.primary_structure_flag
292: ,p_request_id_o
293: => per_ors_shd.g_old_rec.request_id
294: ,p_program_application_id_o
295: => per_ors_shd.g_old_rec.program_application_id
296: ,p_program_id_o
297: => per_ors_shd.g_old_rec.program_id
298: ,p_program_update_date_o
299: => per_ors_shd.g_old_rec.program_update_date

Line 297: => per_ors_shd.g_old_rec.program_id

293: => per_ors_shd.g_old_rec.request_id
294: ,p_program_application_id_o
295: => per_ors_shd.g_old_rec.program_application_id
296: ,p_program_id_o
297: => per_ors_shd.g_old_rec.program_id
298: ,p_program_update_date_o
299: => per_ors_shd.g_old_rec.program_update_date
300: ,p_attribute_category_o
301: => per_ors_shd.g_old_rec.attribute_category

Line 299: => per_ors_shd.g_old_rec.program_update_date

295: => per_ors_shd.g_old_rec.program_application_id
296: ,p_program_id_o
297: => per_ors_shd.g_old_rec.program_id
298: ,p_program_update_date_o
299: => per_ors_shd.g_old_rec.program_update_date
300: ,p_attribute_category_o
301: => per_ors_shd.g_old_rec.attribute_category
302: ,p_attribute1_o
303: => per_ors_shd.g_old_rec.attribute1

Line 301: => per_ors_shd.g_old_rec.attribute_category

297: => per_ors_shd.g_old_rec.program_id
298: ,p_program_update_date_o
299: => per_ors_shd.g_old_rec.program_update_date
300: ,p_attribute_category_o
301: => per_ors_shd.g_old_rec.attribute_category
302: ,p_attribute1_o
303: => per_ors_shd.g_old_rec.attribute1
304: ,p_attribute2_o
305: => per_ors_shd.g_old_rec.attribute2

Line 303: => per_ors_shd.g_old_rec.attribute1

299: => per_ors_shd.g_old_rec.program_update_date
300: ,p_attribute_category_o
301: => per_ors_shd.g_old_rec.attribute_category
302: ,p_attribute1_o
303: => per_ors_shd.g_old_rec.attribute1
304: ,p_attribute2_o
305: => per_ors_shd.g_old_rec.attribute2
306: ,p_attribute3_o
307: => per_ors_shd.g_old_rec.attribute3

Line 305: => per_ors_shd.g_old_rec.attribute2

301: => per_ors_shd.g_old_rec.attribute_category
302: ,p_attribute1_o
303: => per_ors_shd.g_old_rec.attribute1
304: ,p_attribute2_o
305: => per_ors_shd.g_old_rec.attribute2
306: ,p_attribute3_o
307: => per_ors_shd.g_old_rec.attribute3
308: ,p_attribute4_o
309: => per_ors_shd.g_old_rec.attribute4

Line 307: => per_ors_shd.g_old_rec.attribute3

303: => per_ors_shd.g_old_rec.attribute1
304: ,p_attribute2_o
305: => per_ors_shd.g_old_rec.attribute2
306: ,p_attribute3_o
307: => per_ors_shd.g_old_rec.attribute3
308: ,p_attribute4_o
309: => per_ors_shd.g_old_rec.attribute4
310: ,p_attribute5_o
311: => per_ors_shd.g_old_rec.attribute5

Line 309: => per_ors_shd.g_old_rec.attribute4

305: => per_ors_shd.g_old_rec.attribute2
306: ,p_attribute3_o
307: => per_ors_shd.g_old_rec.attribute3
308: ,p_attribute4_o
309: => per_ors_shd.g_old_rec.attribute4
310: ,p_attribute5_o
311: => per_ors_shd.g_old_rec.attribute5
312: ,p_attribute6_o
313: => per_ors_shd.g_old_rec.attribute6

Line 311: => per_ors_shd.g_old_rec.attribute5

307: => per_ors_shd.g_old_rec.attribute3
308: ,p_attribute4_o
309: => per_ors_shd.g_old_rec.attribute4
310: ,p_attribute5_o
311: => per_ors_shd.g_old_rec.attribute5
312: ,p_attribute6_o
313: => per_ors_shd.g_old_rec.attribute6
314: ,p_attribute7_o
315: => per_ors_shd.g_old_rec.attribute7

Line 313: => per_ors_shd.g_old_rec.attribute6

309: => per_ors_shd.g_old_rec.attribute4
310: ,p_attribute5_o
311: => per_ors_shd.g_old_rec.attribute5
312: ,p_attribute6_o
313: => per_ors_shd.g_old_rec.attribute6
314: ,p_attribute7_o
315: => per_ors_shd.g_old_rec.attribute7
316: ,p_attribute8_o
317: => per_ors_shd.g_old_rec.attribute8

Line 315: => per_ors_shd.g_old_rec.attribute7

311: => per_ors_shd.g_old_rec.attribute5
312: ,p_attribute6_o
313: => per_ors_shd.g_old_rec.attribute6
314: ,p_attribute7_o
315: => per_ors_shd.g_old_rec.attribute7
316: ,p_attribute8_o
317: => per_ors_shd.g_old_rec.attribute8
318: ,p_attribute9_o
319: => per_ors_shd.g_old_rec.attribute9

Line 317: => per_ors_shd.g_old_rec.attribute8

313: => per_ors_shd.g_old_rec.attribute6
314: ,p_attribute7_o
315: => per_ors_shd.g_old_rec.attribute7
316: ,p_attribute8_o
317: => per_ors_shd.g_old_rec.attribute8
318: ,p_attribute9_o
319: => per_ors_shd.g_old_rec.attribute9
320: ,p_attribute10_o
321: => per_ors_shd.g_old_rec.attribute10

Line 319: => per_ors_shd.g_old_rec.attribute9

315: => per_ors_shd.g_old_rec.attribute7
316: ,p_attribute8_o
317: => per_ors_shd.g_old_rec.attribute8
318: ,p_attribute9_o
319: => per_ors_shd.g_old_rec.attribute9
320: ,p_attribute10_o
321: => per_ors_shd.g_old_rec.attribute10
322: ,p_attribute11_o
323: => per_ors_shd.g_old_rec.attribute11

Line 321: => per_ors_shd.g_old_rec.attribute10

317: => per_ors_shd.g_old_rec.attribute8
318: ,p_attribute9_o
319: => per_ors_shd.g_old_rec.attribute9
320: ,p_attribute10_o
321: => per_ors_shd.g_old_rec.attribute10
322: ,p_attribute11_o
323: => per_ors_shd.g_old_rec.attribute11
324: ,p_attribute12_o
325: => per_ors_shd.g_old_rec.attribute12

Line 323: => per_ors_shd.g_old_rec.attribute11

319: => per_ors_shd.g_old_rec.attribute9
320: ,p_attribute10_o
321: => per_ors_shd.g_old_rec.attribute10
322: ,p_attribute11_o
323: => per_ors_shd.g_old_rec.attribute11
324: ,p_attribute12_o
325: => per_ors_shd.g_old_rec.attribute12
326: ,p_attribute13_o
327: => per_ors_shd.g_old_rec.attribute13

Line 325: => per_ors_shd.g_old_rec.attribute12

321: => per_ors_shd.g_old_rec.attribute10
322: ,p_attribute11_o
323: => per_ors_shd.g_old_rec.attribute11
324: ,p_attribute12_o
325: => per_ors_shd.g_old_rec.attribute12
326: ,p_attribute13_o
327: => per_ors_shd.g_old_rec.attribute13
328: ,p_attribute14_o
329: => per_ors_shd.g_old_rec.attribute14

Line 327: => per_ors_shd.g_old_rec.attribute13

323: => per_ors_shd.g_old_rec.attribute11
324: ,p_attribute12_o
325: => per_ors_shd.g_old_rec.attribute12
326: ,p_attribute13_o
327: => per_ors_shd.g_old_rec.attribute13
328: ,p_attribute14_o
329: => per_ors_shd.g_old_rec.attribute14
330: ,p_attribute15_o
331: => per_ors_shd.g_old_rec.attribute15

Line 329: => per_ors_shd.g_old_rec.attribute14

325: => per_ors_shd.g_old_rec.attribute12
326: ,p_attribute13_o
327: => per_ors_shd.g_old_rec.attribute13
328: ,p_attribute14_o
329: => per_ors_shd.g_old_rec.attribute14
330: ,p_attribute15_o
331: => per_ors_shd.g_old_rec.attribute15
332: ,p_attribute16_o
333: => per_ors_shd.g_old_rec.attribute16

Line 331: => per_ors_shd.g_old_rec.attribute15

327: => per_ors_shd.g_old_rec.attribute13
328: ,p_attribute14_o
329: => per_ors_shd.g_old_rec.attribute14
330: ,p_attribute15_o
331: => per_ors_shd.g_old_rec.attribute15
332: ,p_attribute16_o
333: => per_ors_shd.g_old_rec.attribute16
334: ,p_attribute17_o
335: => per_ors_shd.g_old_rec.attribute17

Line 333: => per_ors_shd.g_old_rec.attribute16

329: => per_ors_shd.g_old_rec.attribute14
330: ,p_attribute15_o
331: => per_ors_shd.g_old_rec.attribute15
332: ,p_attribute16_o
333: => per_ors_shd.g_old_rec.attribute16
334: ,p_attribute17_o
335: => per_ors_shd.g_old_rec.attribute17
336: ,p_attribute18_o
337: => per_ors_shd.g_old_rec.attribute18

Line 335: => per_ors_shd.g_old_rec.attribute17

331: => per_ors_shd.g_old_rec.attribute15
332: ,p_attribute16_o
333: => per_ors_shd.g_old_rec.attribute16
334: ,p_attribute17_o
335: => per_ors_shd.g_old_rec.attribute17
336: ,p_attribute18_o
337: => per_ors_shd.g_old_rec.attribute18
338: ,p_attribute19_o
339: => per_ors_shd.g_old_rec.attribute19

Line 337: => per_ors_shd.g_old_rec.attribute18

333: => per_ors_shd.g_old_rec.attribute16
334: ,p_attribute17_o
335: => per_ors_shd.g_old_rec.attribute17
336: ,p_attribute18_o
337: => per_ors_shd.g_old_rec.attribute18
338: ,p_attribute19_o
339: => per_ors_shd.g_old_rec.attribute19
340: ,p_attribute20_o
341: => per_ors_shd.g_old_rec.attribute20

Line 339: => per_ors_shd.g_old_rec.attribute19

335: => per_ors_shd.g_old_rec.attribute17
336: ,p_attribute18_o
337: => per_ors_shd.g_old_rec.attribute18
338: ,p_attribute19_o
339: => per_ors_shd.g_old_rec.attribute19
340: ,p_attribute20_o
341: => per_ors_shd.g_old_rec.attribute20
342: ,p_position_control_structure_o
343: => per_ors_shd.g_old_rec.position_control_structure_flg

Line 341: => per_ors_shd.g_old_rec.attribute20

337: => per_ors_shd.g_old_rec.attribute18
338: ,p_attribute19_o
339: => per_ors_shd.g_old_rec.attribute19
340: ,p_attribute20_o
341: => per_ors_shd.g_old_rec.attribute20
342: ,p_position_control_structure_o
343: => per_ors_shd.g_old_rec.position_control_structure_flg
344: ,p_object_version_number_o
345: => per_ors_shd.g_old_rec.object_version_number

Line 343: => per_ors_shd.g_old_rec.position_control_structure_flg

339: => per_ors_shd.g_old_rec.attribute19
340: ,p_attribute20_o
341: => per_ors_shd.g_old_rec.attribute20
342: ,p_position_control_structure_o
343: => per_ors_shd.g_old_rec.position_control_structure_flg
344: ,p_object_version_number_o
345: => per_ors_shd.g_old_rec.object_version_number
346: );
347: --

Line 345: => per_ors_shd.g_old_rec.object_version_number

341: => per_ors_shd.g_old_rec.attribute20
342: ,p_position_control_structure_o
343: => per_ors_shd.g_old_rec.position_control_structure_flg
344: ,p_object_version_number_o
345: => per_ors_shd.g_old_rec.object_version_number
346: );
347: --
348: exception
349: --

Line 405: (p_rec in out nocopy per_ors_shd.g_rec_type

401: --
402: -- {End Of Comments}
403: -- ----------------------------------------------------------------------------
404: Procedure convert_defs
405: (p_rec in out nocopy per_ors_shd.g_rec_type
406: ) is
407: --
408: Begin
409: --

Line 417: per_ors_shd.g_old_rec.business_group_id;

413: -- is being used then we must set to the 'current' argument value.
414: --
415: If (p_rec.business_group_id = hr_api.g_number) then
416: p_rec.business_group_id :=
417: per_ors_shd.g_old_rec.business_group_id;
418: End If;
419: If (p_rec.name = hr_api.g_varchar2) then
420: p_rec.name :=
421: per_ors_shd.g_old_rec.name;

Line 421: per_ors_shd.g_old_rec.name;

417: per_ors_shd.g_old_rec.business_group_id;
418: End If;
419: If (p_rec.name = hr_api.g_varchar2) then
420: p_rec.name :=
421: per_ors_shd.g_old_rec.name;
422: End If;
423: If (p_rec.comments = hr_api.g_varchar2) then
424: p_rec.comments :=
425: per_ors_shd.g_old_rec.comments;

Line 425: per_ors_shd.g_old_rec.comments;

421: per_ors_shd.g_old_rec.name;
422: End If;
423: If (p_rec.comments = hr_api.g_varchar2) then
424: p_rec.comments :=
425: per_ors_shd.g_old_rec.comments;
426: End If;
427: If (p_rec.primary_structure_flag = hr_api.g_varchar2) then
428: p_rec.primary_structure_flag :=
429: per_ors_shd.g_old_rec.primary_structure_flag;

Line 429: per_ors_shd.g_old_rec.primary_structure_flag;

425: per_ors_shd.g_old_rec.comments;
426: End If;
427: If (p_rec.primary_structure_flag = hr_api.g_varchar2) then
428: p_rec.primary_structure_flag :=
429: per_ors_shd.g_old_rec.primary_structure_flag;
430: End If;
431: If (p_rec.request_id = hr_api.g_number) then
432: p_rec.request_id :=
433: per_ors_shd.g_old_rec.request_id;

Line 433: per_ors_shd.g_old_rec.request_id;

429: per_ors_shd.g_old_rec.primary_structure_flag;
430: End If;
431: If (p_rec.request_id = hr_api.g_number) then
432: p_rec.request_id :=
433: per_ors_shd.g_old_rec.request_id;
434: End If;
435: If (p_rec.program_application_id = hr_api.g_number) then
436: p_rec.program_application_id :=
437: per_ors_shd.g_old_rec.program_application_id;

Line 437: per_ors_shd.g_old_rec.program_application_id;

433: per_ors_shd.g_old_rec.request_id;
434: End If;
435: If (p_rec.program_application_id = hr_api.g_number) then
436: p_rec.program_application_id :=
437: per_ors_shd.g_old_rec.program_application_id;
438: End If;
439: If (p_rec.program_id = hr_api.g_number) then
440: p_rec.program_id :=
441: per_ors_shd.g_old_rec.program_id;

Line 441: per_ors_shd.g_old_rec.program_id;

437: per_ors_shd.g_old_rec.program_application_id;
438: End If;
439: If (p_rec.program_id = hr_api.g_number) then
440: p_rec.program_id :=
441: per_ors_shd.g_old_rec.program_id;
442: End If;
443: If (p_rec.program_update_date = hr_api.g_date) then
444: p_rec.program_update_date :=
445: per_ors_shd.g_old_rec.program_update_date;

Line 445: per_ors_shd.g_old_rec.program_update_date;

441: per_ors_shd.g_old_rec.program_id;
442: End If;
443: If (p_rec.program_update_date = hr_api.g_date) then
444: p_rec.program_update_date :=
445: per_ors_shd.g_old_rec.program_update_date;
446: End If;
447: If (p_rec.attribute_category = hr_api.g_varchar2) then
448: p_rec.attribute_category :=
449: per_ors_shd.g_old_rec.attribute_category;

Line 449: per_ors_shd.g_old_rec.attribute_category;

445: per_ors_shd.g_old_rec.program_update_date;
446: End If;
447: If (p_rec.attribute_category = hr_api.g_varchar2) then
448: p_rec.attribute_category :=
449: per_ors_shd.g_old_rec.attribute_category;
450: End If;
451: If (p_rec.attribute1 = hr_api.g_varchar2) then
452: p_rec.attribute1 :=
453: per_ors_shd.g_old_rec.attribute1;

Line 453: per_ors_shd.g_old_rec.attribute1;

449: per_ors_shd.g_old_rec.attribute_category;
450: End If;
451: If (p_rec.attribute1 = hr_api.g_varchar2) then
452: p_rec.attribute1 :=
453: per_ors_shd.g_old_rec.attribute1;
454: End If;
455: If (p_rec.attribute2 = hr_api.g_varchar2) then
456: p_rec.attribute2 :=
457: per_ors_shd.g_old_rec.attribute2;

Line 457: per_ors_shd.g_old_rec.attribute2;

453: per_ors_shd.g_old_rec.attribute1;
454: End If;
455: If (p_rec.attribute2 = hr_api.g_varchar2) then
456: p_rec.attribute2 :=
457: per_ors_shd.g_old_rec.attribute2;
458: End If;
459: If (p_rec.attribute3 = hr_api.g_varchar2) then
460: p_rec.attribute3 :=
461: per_ors_shd.g_old_rec.attribute3;

Line 461: per_ors_shd.g_old_rec.attribute3;

457: per_ors_shd.g_old_rec.attribute2;
458: End If;
459: If (p_rec.attribute3 = hr_api.g_varchar2) then
460: p_rec.attribute3 :=
461: per_ors_shd.g_old_rec.attribute3;
462: End If;
463: If (p_rec.attribute4 = hr_api.g_varchar2) then
464: p_rec.attribute4 :=
465: per_ors_shd.g_old_rec.attribute4;

Line 465: per_ors_shd.g_old_rec.attribute4;

461: per_ors_shd.g_old_rec.attribute3;
462: End If;
463: If (p_rec.attribute4 = hr_api.g_varchar2) then
464: p_rec.attribute4 :=
465: per_ors_shd.g_old_rec.attribute4;
466: End If;
467: If (p_rec.attribute5 = hr_api.g_varchar2) then
468: p_rec.attribute5 :=
469: per_ors_shd.g_old_rec.attribute5;

Line 469: per_ors_shd.g_old_rec.attribute5;

465: per_ors_shd.g_old_rec.attribute4;
466: End If;
467: If (p_rec.attribute5 = hr_api.g_varchar2) then
468: p_rec.attribute5 :=
469: per_ors_shd.g_old_rec.attribute5;
470: End If;
471: If (p_rec.attribute6 = hr_api.g_varchar2) then
472: p_rec.attribute6 :=
473: per_ors_shd.g_old_rec.attribute6;

Line 473: per_ors_shd.g_old_rec.attribute6;

469: per_ors_shd.g_old_rec.attribute5;
470: End If;
471: If (p_rec.attribute6 = hr_api.g_varchar2) then
472: p_rec.attribute6 :=
473: per_ors_shd.g_old_rec.attribute6;
474: End If;
475: If (p_rec.attribute7 = hr_api.g_varchar2) then
476: p_rec.attribute7 :=
477: per_ors_shd.g_old_rec.attribute7;

Line 477: per_ors_shd.g_old_rec.attribute7;

473: per_ors_shd.g_old_rec.attribute6;
474: End If;
475: If (p_rec.attribute7 = hr_api.g_varchar2) then
476: p_rec.attribute7 :=
477: per_ors_shd.g_old_rec.attribute7;
478: End If;
479: If (p_rec.attribute8 = hr_api.g_varchar2) then
480: p_rec.attribute8 :=
481: per_ors_shd.g_old_rec.attribute8;

Line 481: per_ors_shd.g_old_rec.attribute8;

477: per_ors_shd.g_old_rec.attribute7;
478: End If;
479: If (p_rec.attribute8 = hr_api.g_varchar2) then
480: p_rec.attribute8 :=
481: per_ors_shd.g_old_rec.attribute8;
482: End If;
483: If (p_rec.attribute9 = hr_api.g_varchar2) then
484: p_rec.attribute9 :=
485: per_ors_shd.g_old_rec.attribute9;

Line 485: per_ors_shd.g_old_rec.attribute9;

481: per_ors_shd.g_old_rec.attribute8;
482: End If;
483: If (p_rec.attribute9 = hr_api.g_varchar2) then
484: p_rec.attribute9 :=
485: per_ors_shd.g_old_rec.attribute9;
486: End If;
487: If (p_rec.attribute10 = hr_api.g_varchar2) then
488: p_rec.attribute10 :=
489: per_ors_shd.g_old_rec.attribute10;

Line 489: per_ors_shd.g_old_rec.attribute10;

485: per_ors_shd.g_old_rec.attribute9;
486: End If;
487: If (p_rec.attribute10 = hr_api.g_varchar2) then
488: p_rec.attribute10 :=
489: per_ors_shd.g_old_rec.attribute10;
490: End If;
491: If (p_rec.attribute11 = hr_api.g_varchar2) then
492: p_rec.attribute11 :=
493: per_ors_shd.g_old_rec.attribute11;

Line 493: per_ors_shd.g_old_rec.attribute11;

489: per_ors_shd.g_old_rec.attribute10;
490: End If;
491: If (p_rec.attribute11 = hr_api.g_varchar2) then
492: p_rec.attribute11 :=
493: per_ors_shd.g_old_rec.attribute11;
494: End If;
495: If (p_rec.attribute12 = hr_api.g_varchar2) then
496: p_rec.attribute12 :=
497: per_ors_shd.g_old_rec.attribute12;

Line 497: per_ors_shd.g_old_rec.attribute12;

493: per_ors_shd.g_old_rec.attribute11;
494: End If;
495: If (p_rec.attribute12 = hr_api.g_varchar2) then
496: p_rec.attribute12 :=
497: per_ors_shd.g_old_rec.attribute12;
498: End If;
499: If (p_rec.attribute13 = hr_api.g_varchar2) then
500: p_rec.attribute13 :=
501: per_ors_shd.g_old_rec.attribute13;

Line 501: per_ors_shd.g_old_rec.attribute13;

497: per_ors_shd.g_old_rec.attribute12;
498: End If;
499: If (p_rec.attribute13 = hr_api.g_varchar2) then
500: p_rec.attribute13 :=
501: per_ors_shd.g_old_rec.attribute13;
502: End If;
503: If (p_rec.attribute14 = hr_api.g_varchar2) then
504: p_rec.attribute14 :=
505: per_ors_shd.g_old_rec.attribute14;

Line 505: per_ors_shd.g_old_rec.attribute14;

501: per_ors_shd.g_old_rec.attribute13;
502: End If;
503: If (p_rec.attribute14 = hr_api.g_varchar2) then
504: p_rec.attribute14 :=
505: per_ors_shd.g_old_rec.attribute14;
506: End If;
507: If (p_rec.attribute15 = hr_api.g_varchar2) then
508: p_rec.attribute15 :=
509: per_ors_shd.g_old_rec.attribute15;

Line 509: per_ors_shd.g_old_rec.attribute15;

505: per_ors_shd.g_old_rec.attribute14;
506: End If;
507: If (p_rec.attribute15 = hr_api.g_varchar2) then
508: p_rec.attribute15 :=
509: per_ors_shd.g_old_rec.attribute15;
510: End If;
511: If (p_rec.attribute16 = hr_api.g_varchar2) then
512: p_rec.attribute16 :=
513: per_ors_shd.g_old_rec.attribute16;

Line 513: per_ors_shd.g_old_rec.attribute16;

509: per_ors_shd.g_old_rec.attribute15;
510: End If;
511: If (p_rec.attribute16 = hr_api.g_varchar2) then
512: p_rec.attribute16 :=
513: per_ors_shd.g_old_rec.attribute16;
514: End If;
515: If (p_rec.attribute17 = hr_api.g_varchar2) then
516: p_rec.attribute17 :=
517: per_ors_shd.g_old_rec.attribute17;

Line 517: per_ors_shd.g_old_rec.attribute17;

513: per_ors_shd.g_old_rec.attribute16;
514: End If;
515: If (p_rec.attribute17 = hr_api.g_varchar2) then
516: p_rec.attribute17 :=
517: per_ors_shd.g_old_rec.attribute17;
518: End If;
519: If (p_rec.attribute18 = hr_api.g_varchar2) then
520: p_rec.attribute18 :=
521: per_ors_shd.g_old_rec.attribute18;

Line 521: per_ors_shd.g_old_rec.attribute18;

517: per_ors_shd.g_old_rec.attribute17;
518: End If;
519: If (p_rec.attribute18 = hr_api.g_varchar2) then
520: p_rec.attribute18 :=
521: per_ors_shd.g_old_rec.attribute18;
522: End If;
523: If (p_rec.attribute19 = hr_api.g_varchar2) then
524: p_rec.attribute19 :=
525: per_ors_shd.g_old_rec.attribute19;

Line 525: per_ors_shd.g_old_rec.attribute19;

521: per_ors_shd.g_old_rec.attribute18;
522: End If;
523: If (p_rec.attribute19 = hr_api.g_varchar2) then
524: p_rec.attribute19 :=
525: per_ors_shd.g_old_rec.attribute19;
526: End If;
527: If (p_rec.attribute20 = hr_api.g_varchar2) then
528: p_rec.attribute20 :=
529: per_ors_shd.g_old_rec.attribute20;

Line 529: per_ors_shd.g_old_rec.attribute20;

525: per_ors_shd.g_old_rec.attribute19;
526: End If;
527: If (p_rec.attribute20 = hr_api.g_varchar2) then
528: p_rec.attribute20 :=
529: per_ors_shd.g_old_rec.attribute20;
530: End If;
531: If (p_rec.position_control_structure_flg = hr_api.g_varchar2) then
532: p_rec.position_control_structure_flg :=
533: per_ors_shd.g_old_rec.position_control_structure_flg;

Line 533: per_ors_shd.g_old_rec.position_control_structure_flg;

529: per_ors_shd.g_old_rec.attribute20;
530: End If;
531: If (p_rec.position_control_structure_flg = hr_api.g_varchar2) then
532: p_rec.position_control_structure_flg :=
533: per_ors_shd.g_old_rec.position_control_structure_flg;
534: End If;
535: --
536: End convert_defs;
537: --

Line 543: ,p_rec in out nocopy per_ors_shd.g_rec_type

539: -- |---------------------------------< upd >----------------------------------|
540: -- ----------------------------------------------------------------------------
541: Procedure upd
542: (p_effective_date in date
543: ,p_rec in out nocopy per_ors_shd.g_rec_type
544: ) is
545: --
546: l_proc varchar2(72) := g_package||'upd';
547: --

Line 553: per_ors_shd.lck

549: hr_utility.set_location('Entering:'||l_proc, 5);
550: --
551: -- We must lock the row which we need to update.
552: --
553: per_ors_shd.lck
554: (p_rec.organization_structure_id
555: ,p_rec.object_version_number
556: );
557: --

Line 625: l_rec per_ors_shd.g_rec_type;

621: ,p_attribute20 in varchar2 default hr_api.g_varchar2
622: ,p_position_control_structure_f in varchar2 default hr_api.g_varchar2
623: ) is
624: --
625: l_rec per_ors_shd.g_rec_type;
626: l_proc varchar2(72) := g_package||'upd';
627: --
628: Begin
629: hr_utility.set_location('Entering:'||l_proc, 5);

Line 635: per_ors_shd.convert_args

631: -- Call conversion function to turn arguments into the
632: -- l_rec structure.
633: --
634: l_rec :=
635: per_ors_shd.convert_args
636: (p_organization_structure_id
637: ,p_business_group_id
638: ,p_name
639: ,p_comments