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_PST_UPD dependencies on PER_PST_SHD

Line 55: (p_rec in out nocopy per_pst_shd.g_rec_type

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

Line 66: per_pst_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_pst_shd.g_api_dml := true; -- Set the api dml status
67: --
68: -- Update the per_position_structures Row
69: --
70: update per_position_structures

Line 105: per_pst_shd.g_api_dml := false; -- Unset the api dml status

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

Line 112: per_pst_shd.g_api_dml := false; -- Unset the api dml status

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

Line 113: per_pst_shd.constraint_error

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

Line 117: per_pst_shd.g_api_dml := false; -- Unset the api dml status

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

Line 118: per_pst_shd.constraint_error

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

Line 122: per_pst_shd.g_api_dml := false; -- Unset the api dml status

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

Line 123: per_pst_shd.constraint_error

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

Line 126: per_pst_shd.g_api_dml := false; -- Unset the api dml status

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

Line 163: (p_rec in per_pst_shd.g_rec_type

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

Line 208: ,p_rec in per_pst_shd.g_rec_type

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

Line 282: => per_pst_shd.g_old_rec.business_group_id

278: => p_rec.attribute20
279: ,p_object_version_number
280: => p_rec.object_version_number
281: ,p_business_group_id_o
282: => per_pst_shd.g_old_rec.business_group_id
283: ,p_name_o
284: => per_pst_shd.g_old_rec.name
285: ,p_comments_o
286: => per_pst_shd.g_old_rec.comments

Line 284: => per_pst_shd.g_old_rec.name

280: => p_rec.object_version_number
281: ,p_business_group_id_o
282: => per_pst_shd.g_old_rec.business_group_id
283: ,p_name_o
284: => per_pst_shd.g_old_rec.name
285: ,p_comments_o
286: => per_pst_shd.g_old_rec.comments
287: ,p_primary_position_flag_o
288: => per_pst_shd.g_old_rec.primary_position_flag

Line 286: => per_pst_shd.g_old_rec.comments

282: => per_pst_shd.g_old_rec.business_group_id
283: ,p_name_o
284: => per_pst_shd.g_old_rec.name
285: ,p_comments_o
286: => per_pst_shd.g_old_rec.comments
287: ,p_primary_position_flag_o
288: => per_pst_shd.g_old_rec.primary_position_flag
289: ,p_request_id_o
290: => per_pst_shd.g_old_rec.request_id

Line 288: => per_pst_shd.g_old_rec.primary_position_flag

284: => per_pst_shd.g_old_rec.name
285: ,p_comments_o
286: => per_pst_shd.g_old_rec.comments
287: ,p_primary_position_flag_o
288: => per_pst_shd.g_old_rec.primary_position_flag
289: ,p_request_id_o
290: => per_pst_shd.g_old_rec.request_id
291: ,p_program_application_id_o
292: => per_pst_shd.g_old_rec.program_application_id

Line 290: => per_pst_shd.g_old_rec.request_id

286: => per_pst_shd.g_old_rec.comments
287: ,p_primary_position_flag_o
288: => per_pst_shd.g_old_rec.primary_position_flag
289: ,p_request_id_o
290: => per_pst_shd.g_old_rec.request_id
291: ,p_program_application_id_o
292: => per_pst_shd.g_old_rec.program_application_id
293: ,p_program_id_o
294: => per_pst_shd.g_old_rec.program_id

Line 292: => per_pst_shd.g_old_rec.program_application_id

288: => per_pst_shd.g_old_rec.primary_position_flag
289: ,p_request_id_o
290: => per_pst_shd.g_old_rec.request_id
291: ,p_program_application_id_o
292: => per_pst_shd.g_old_rec.program_application_id
293: ,p_program_id_o
294: => per_pst_shd.g_old_rec.program_id
295: ,p_program_update_date_o
296: => per_pst_shd.g_old_rec.program_update_date

Line 294: => per_pst_shd.g_old_rec.program_id

290: => per_pst_shd.g_old_rec.request_id
291: ,p_program_application_id_o
292: => per_pst_shd.g_old_rec.program_application_id
293: ,p_program_id_o
294: => per_pst_shd.g_old_rec.program_id
295: ,p_program_update_date_o
296: => per_pst_shd.g_old_rec.program_update_date
297: ,p_attribute_category_o
298: => per_pst_shd.g_old_rec.attribute_category

Line 296: => per_pst_shd.g_old_rec.program_update_date

292: => per_pst_shd.g_old_rec.program_application_id
293: ,p_program_id_o
294: => per_pst_shd.g_old_rec.program_id
295: ,p_program_update_date_o
296: => per_pst_shd.g_old_rec.program_update_date
297: ,p_attribute_category_o
298: => per_pst_shd.g_old_rec.attribute_category
299: ,p_attribute1_o
300: => per_pst_shd.g_old_rec.attribute1

Line 298: => per_pst_shd.g_old_rec.attribute_category

294: => per_pst_shd.g_old_rec.program_id
295: ,p_program_update_date_o
296: => per_pst_shd.g_old_rec.program_update_date
297: ,p_attribute_category_o
298: => per_pst_shd.g_old_rec.attribute_category
299: ,p_attribute1_o
300: => per_pst_shd.g_old_rec.attribute1
301: ,p_attribute2_o
302: => per_pst_shd.g_old_rec.attribute2

Line 300: => per_pst_shd.g_old_rec.attribute1

296: => per_pst_shd.g_old_rec.program_update_date
297: ,p_attribute_category_o
298: => per_pst_shd.g_old_rec.attribute_category
299: ,p_attribute1_o
300: => per_pst_shd.g_old_rec.attribute1
301: ,p_attribute2_o
302: => per_pst_shd.g_old_rec.attribute2
303: ,p_attribute3_o
304: => per_pst_shd.g_old_rec.attribute3

Line 302: => per_pst_shd.g_old_rec.attribute2

298: => per_pst_shd.g_old_rec.attribute_category
299: ,p_attribute1_o
300: => per_pst_shd.g_old_rec.attribute1
301: ,p_attribute2_o
302: => per_pst_shd.g_old_rec.attribute2
303: ,p_attribute3_o
304: => per_pst_shd.g_old_rec.attribute3
305: ,p_attribute4_o
306: => per_pst_shd.g_old_rec.attribute4

Line 304: => per_pst_shd.g_old_rec.attribute3

300: => per_pst_shd.g_old_rec.attribute1
301: ,p_attribute2_o
302: => per_pst_shd.g_old_rec.attribute2
303: ,p_attribute3_o
304: => per_pst_shd.g_old_rec.attribute3
305: ,p_attribute4_o
306: => per_pst_shd.g_old_rec.attribute4
307: ,p_attribute5_o
308: => per_pst_shd.g_old_rec.attribute5

Line 306: => per_pst_shd.g_old_rec.attribute4

302: => per_pst_shd.g_old_rec.attribute2
303: ,p_attribute3_o
304: => per_pst_shd.g_old_rec.attribute3
305: ,p_attribute4_o
306: => per_pst_shd.g_old_rec.attribute4
307: ,p_attribute5_o
308: => per_pst_shd.g_old_rec.attribute5
309: ,p_attribute6_o
310: => per_pst_shd.g_old_rec.attribute6

Line 308: => per_pst_shd.g_old_rec.attribute5

304: => per_pst_shd.g_old_rec.attribute3
305: ,p_attribute4_o
306: => per_pst_shd.g_old_rec.attribute4
307: ,p_attribute5_o
308: => per_pst_shd.g_old_rec.attribute5
309: ,p_attribute6_o
310: => per_pst_shd.g_old_rec.attribute6
311: ,p_attribute7_o
312: => per_pst_shd.g_old_rec.attribute7

Line 310: => per_pst_shd.g_old_rec.attribute6

306: => per_pst_shd.g_old_rec.attribute4
307: ,p_attribute5_o
308: => per_pst_shd.g_old_rec.attribute5
309: ,p_attribute6_o
310: => per_pst_shd.g_old_rec.attribute6
311: ,p_attribute7_o
312: => per_pst_shd.g_old_rec.attribute7
313: ,p_attribute8_o
314: => per_pst_shd.g_old_rec.attribute8

Line 312: => per_pst_shd.g_old_rec.attribute7

308: => per_pst_shd.g_old_rec.attribute5
309: ,p_attribute6_o
310: => per_pst_shd.g_old_rec.attribute6
311: ,p_attribute7_o
312: => per_pst_shd.g_old_rec.attribute7
313: ,p_attribute8_o
314: => per_pst_shd.g_old_rec.attribute8
315: ,p_attribute9_o
316: => per_pst_shd.g_old_rec.attribute9

Line 314: => per_pst_shd.g_old_rec.attribute8

310: => per_pst_shd.g_old_rec.attribute6
311: ,p_attribute7_o
312: => per_pst_shd.g_old_rec.attribute7
313: ,p_attribute8_o
314: => per_pst_shd.g_old_rec.attribute8
315: ,p_attribute9_o
316: => per_pst_shd.g_old_rec.attribute9
317: ,p_attribute10_o
318: => per_pst_shd.g_old_rec.attribute10

Line 316: => per_pst_shd.g_old_rec.attribute9

312: => per_pst_shd.g_old_rec.attribute7
313: ,p_attribute8_o
314: => per_pst_shd.g_old_rec.attribute8
315: ,p_attribute9_o
316: => per_pst_shd.g_old_rec.attribute9
317: ,p_attribute10_o
318: => per_pst_shd.g_old_rec.attribute10
319: ,p_attribute11_o
320: => per_pst_shd.g_old_rec.attribute11

Line 318: => per_pst_shd.g_old_rec.attribute10

314: => per_pst_shd.g_old_rec.attribute8
315: ,p_attribute9_o
316: => per_pst_shd.g_old_rec.attribute9
317: ,p_attribute10_o
318: => per_pst_shd.g_old_rec.attribute10
319: ,p_attribute11_o
320: => per_pst_shd.g_old_rec.attribute11
321: ,p_attribute12_o
322: => per_pst_shd.g_old_rec.attribute12

Line 320: => per_pst_shd.g_old_rec.attribute11

316: => per_pst_shd.g_old_rec.attribute9
317: ,p_attribute10_o
318: => per_pst_shd.g_old_rec.attribute10
319: ,p_attribute11_o
320: => per_pst_shd.g_old_rec.attribute11
321: ,p_attribute12_o
322: => per_pst_shd.g_old_rec.attribute12
323: ,p_attribute13_o
324: => per_pst_shd.g_old_rec.attribute13

Line 322: => per_pst_shd.g_old_rec.attribute12

318: => per_pst_shd.g_old_rec.attribute10
319: ,p_attribute11_o
320: => per_pst_shd.g_old_rec.attribute11
321: ,p_attribute12_o
322: => per_pst_shd.g_old_rec.attribute12
323: ,p_attribute13_o
324: => per_pst_shd.g_old_rec.attribute13
325: ,p_attribute14_o
326: => per_pst_shd.g_old_rec.attribute14

Line 324: => per_pst_shd.g_old_rec.attribute13

320: => per_pst_shd.g_old_rec.attribute11
321: ,p_attribute12_o
322: => per_pst_shd.g_old_rec.attribute12
323: ,p_attribute13_o
324: => per_pst_shd.g_old_rec.attribute13
325: ,p_attribute14_o
326: => per_pst_shd.g_old_rec.attribute14
327: ,p_attribute15_o
328: => per_pst_shd.g_old_rec.attribute15

Line 326: => per_pst_shd.g_old_rec.attribute14

322: => per_pst_shd.g_old_rec.attribute12
323: ,p_attribute13_o
324: => per_pst_shd.g_old_rec.attribute13
325: ,p_attribute14_o
326: => per_pst_shd.g_old_rec.attribute14
327: ,p_attribute15_o
328: => per_pst_shd.g_old_rec.attribute15
329: ,p_attribute16_o
330: => per_pst_shd.g_old_rec.attribute16

Line 328: => per_pst_shd.g_old_rec.attribute15

324: => per_pst_shd.g_old_rec.attribute13
325: ,p_attribute14_o
326: => per_pst_shd.g_old_rec.attribute14
327: ,p_attribute15_o
328: => per_pst_shd.g_old_rec.attribute15
329: ,p_attribute16_o
330: => per_pst_shd.g_old_rec.attribute16
331: ,p_attribute17_o
332: => per_pst_shd.g_old_rec.attribute17

Line 330: => per_pst_shd.g_old_rec.attribute16

326: => per_pst_shd.g_old_rec.attribute14
327: ,p_attribute15_o
328: => per_pst_shd.g_old_rec.attribute15
329: ,p_attribute16_o
330: => per_pst_shd.g_old_rec.attribute16
331: ,p_attribute17_o
332: => per_pst_shd.g_old_rec.attribute17
333: ,p_attribute18_o
334: => per_pst_shd.g_old_rec.attribute18

Line 332: => per_pst_shd.g_old_rec.attribute17

328: => per_pst_shd.g_old_rec.attribute15
329: ,p_attribute16_o
330: => per_pst_shd.g_old_rec.attribute16
331: ,p_attribute17_o
332: => per_pst_shd.g_old_rec.attribute17
333: ,p_attribute18_o
334: => per_pst_shd.g_old_rec.attribute18
335: ,p_attribute19_o
336: => per_pst_shd.g_old_rec.attribute19

Line 334: => per_pst_shd.g_old_rec.attribute18

330: => per_pst_shd.g_old_rec.attribute16
331: ,p_attribute17_o
332: => per_pst_shd.g_old_rec.attribute17
333: ,p_attribute18_o
334: => per_pst_shd.g_old_rec.attribute18
335: ,p_attribute19_o
336: => per_pst_shd.g_old_rec.attribute19
337: ,p_attribute20_o
338: => per_pst_shd.g_old_rec.attribute20

Line 336: => per_pst_shd.g_old_rec.attribute19

332: => per_pst_shd.g_old_rec.attribute17
333: ,p_attribute18_o
334: => per_pst_shd.g_old_rec.attribute18
335: ,p_attribute19_o
336: => per_pst_shd.g_old_rec.attribute19
337: ,p_attribute20_o
338: => per_pst_shd.g_old_rec.attribute20
339: ,p_object_version_number_o
340: => per_pst_shd.g_old_rec.object_version_number

Line 338: => per_pst_shd.g_old_rec.attribute20

334: => per_pst_shd.g_old_rec.attribute18
335: ,p_attribute19_o
336: => per_pst_shd.g_old_rec.attribute19
337: ,p_attribute20_o
338: => per_pst_shd.g_old_rec.attribute20
339: ,p_object_version_number_o
340: => per_pst_shd.g_old_rec.object_version_number
341: );
342: --

Line 340: => per_pst_shd.g_old_rec.object_version_number

336: => per_pst_shd.g_old_rec.attribute19
337: ,p_attribute20_o
338: => per_pst_shd.g_old_rec.attribute20
339: ,p_object_version_number_o
340: => per_pst_shd.g_old_rec.object_version_number
341: );
342: --
343: exception
344: --

Line 400: (p_rec in out nocopy per_pst_shd.g_rec_type

396: --
397: -- {End Of Comments}
398: -- ----------------------------------------------------------------------------
399: Procedure convert_defs
400: (p_rec in out nocopy per_pst_shd.g_rec_type
401: ) is
402: --
403: Begin
404: --

Line 412: per_pst_shd.g_old_rec.business_group_id;

408: -- is being used then we must set to the 'current' argument value.
409: --
410: If (p_rec.business_group_id = hr_api.g_number) then
411: p_rec.business_group_id :=
412: per_pst_shd.g_old_rec.business_group_id;
413: End If;
414: If (p_rec.name = hr_api.g_varchar2) then
415: p_rec.name :=
416: per_pst_shd.g_old_rec.name;

Line 416: per_pst_shd.g_old_rec.name;

412: per_pst_shd.g_old_rec.business_group_id;
413: End If;
414: If (p_rec.name = hr_api.g_varchar2) then
415: p_rec.name :=
416: per_pst_shd.g_old_rec.name;
417: End If;
418: If (p_rec.comments = hr_api.g_varchar2) then
419: p_rec.comments :=
420: per_pst_shd.g_old_rec.comments;

Line 420: per_pst_shd.g_old_rec.comments;

416: per_pst_shd.g_old_rec.name;
417: End If;
418: If (p_rec.comments = hr_api.g_varchar2) then
419: p_rec.comments :=
420: per_pst_shd.g_old_rec.comments;
421: End If;
422: If (p_rec.primary_position_flag = hr_api.g_varchar2) then
423: p_rec.primary_position_flag :=
424: per_pst_shd.g_old_rec.primary_position_flag;

Line 424: per_pst_shd.g_old_rec.primary_position_flag;

420: per_pst_shd.g_old_rec.comments;
421: End If;
422: If (p_rec.primary_position_flag = hr_api.g_varchar2) then
423: p_rec.primary_position_flag :=
424: per_pst_shd.g_old_rec.primary_position_flag;
425: End If;
426: If (p_rec.request_id = hr_api.g_number) then
427: p_rec.request_id :=
428: per_pst_shd.g_old_rec.request_id;

Line 428: per_pst_shd.g_old_rec.request_id;

424: per_pst_shd.g_old_rec.primary_position_flag;
425: End If;
426: If (p_rec.request_id = hr_api.g_number) then
427: p_rec.request_id :=
428: per_pst_shd.g_old_rec.request_id;
429: End If;
430: If (p_rec.program_application_id = hr_api.g_number) then
431: p_rec.program_application_id :=
432: per_pst_shd.g_old_rec.program_application_id;

Line 432: per_pst_shd.g_old_rec.program_application_id;

428: per_pst_shd.g_old_rec.request_id;
429: End If;
430: If (p_rec.program_application_id = hr_api.g_number) then
431: p_rec.program_application_id :=
432: per_pst_shd.g_old_rec.program_application_id;
433: End If;
434: If (p_rec.program_id = hr_api.g_number) then
435: p_rec.program_id :=
436: per_pst_shd.g_old_rec.program_id;

Line 436: per_pst_shd.g_old_rec.program_id;

432: per_pst_shd.g_old_rec.program_application_id;
433: End If;
434: If (p_rec.program_id = hr_api.g_number) then
435: p_rec.program_id :=
436: per_pst_shd.g_old_rec.program_id;
437: End If;
438: If (p_rec.program_update_date = hr_api.g_date) then
439: p_rec.program_update_date :=
440: per_pst_shd.g_old_rec.program_update_date;

Line 440: per_pst_shd.g_old_rec.program_update_date;

436: per_pst_shd.g_old_rec.program_id;
437: End If;
438: If (p_rec.program_update_date = hr_api.g_date) then
439: p_rec.program_update_date :=
440: per_pst_shd.g_old_rec.program_update_date;
441: End If;
442: If (p_rec.attribute_category = hr_api.g_varchar2) then
443: p_rec.attribute_category :=
444: per_pst_shd.g_old_rec.attribute_category;

Line 444: per_pst_shd.g_old_rec.attribute_category;

440: per_pst_shd.g_old_rec.program_update_date;
441: End If;
442: If (p_rec.attribute_category = hr_api.g_varchar2) then
443: p_rec.attribute_category :=
444: per_pst_shd.g_old_rec.attribute_category;
445: End If;
446: If (p_rec.attribute1 = hr_api.g_varchar2) then
447: p_rec.attribute1 :=
448: per_pst_shd.g_old_rec.attribute1;

Line 448: per_pst_shd.g_old_rec.attribute1;

444: per_pst_shd.g_old_rec.attribute_category;
445: End If;
446: If (p_rec.attribute1 = hr_api.g_varchar2) then
447: p_rec.attribute1 :=
448: per_pst_shd.g_old_rec.attribute1;
449: End If;
450: If (p_rec.attribute2 = hr_api.g_varchar2) then
451: p_rec.attribute2 :=
452: per_pst_shd.g_old_rec.attribute2;

Line 452: per_pst_shd.g_old_rec.attribute2;

448: per_pst_shd.g_old_rec.attribute1;
449: End If;
450: If (p_rec.attribute2 = hr_api.g_varchar2) then
451: p_rec.attribute2 :=
452: per_pst_shd.g_old_rec.attribute2;
453: End If;
454: If (p_rec.attribute3 = hr_api.g_varchar2) then
455: p_rec.attribute3 :=
456: per_pst_shd.g_old_rec.attribute3;

Line 456: per_pst_shd.g_old_rec.attribute3;

452: per_pst_shd.g_old_rec.attribute2;
453: End If;
454: If (p_rec.attribute3 = hr_api.g_varchar2) then
455: p_rec.attribute3 :=
456: per_pst_shd.g_old_rec.attribute3;
457: End If;
458: If (p_rec.attribute4 = hr_api.g_varchar2) then
459: p_rec.attribute4 :=
460: per_pst_shd.g_old_rec.attribute4;

Line 460: per_pst_shd.g_old_rec.attribute4;

456: per_pst_shd.g_old_rec.attribute3;
457: End If;
458: If (p_rec.attribute4 = hr_api.g_varchar2) then
459: p_rec.attribute4 :=
460: per_pst_shd.g_old_rec.attribute4;
461: End If;
462: If (p_rec.attribute5 = hr_api.g_varchar2) then
463: p_rec.attribute5 :=
464: per_pst_shd.g_old_rec.attribute5;

Line 464: per_pst_shd.g_old_rec.attribute5;

460: per_pst_shd.g_old_rec.attribute4;
461: End If;
462: If (p_rec.attribute5 = hr_api.g_varchar2) then
463: p_rec.attribute5 :=
464: per_pst_shd.g_old_rec.attribute5;
465: End If;
466: If (p_rec.attribute6 = hr_api.g_varchar2) then
467: p_rec.attribute6 :=
468: per_pst_shd.g_old_rec.attribute6;

Line 468: per_pst_shd.g_old_rec.attribute6;

464: per_pst_shd.g_old_rec.attribute5;
465: End If;
466: If (p_rec.attribute6 = hr_api.g_varchar2) then
467: p_rec.attribute6 :=
468: per_pst_shd.g_old_rec.attribute6;
469: End If;
470: If (p_rec.attribute7 = hr_api.g_varchar2) then
471: p_rec.attribute7 :=
472: per_pst_shd.g_old_rec.attribute7;

Line 472: per_pst_shd.g_old_rec.attribute7;

468: per_pst_shd.g_old_rec.attribute6;
469: End If;
470: If (p_rec.attribute7 = hr_api.g_varchar2) then
471: p_rec.attribute7 :=
472: per_pst_shd.g_old_rec.attribute7;
473: End If;
474: If (p_rec.attribute8 = hr_api.g_varchar2) then
475: p_rec.attribute8 :=
476: per_pst_shd.g_old_rec.attribute8;

Line 476: per_pst_shd.g_old_rec.attribute8;

472: per_pst_shd.g_old_rec.attribute7;
473: End If;
474: If (p_rec.attribute8 = hr_api.g_varchar2) then
475: p_rec.attribute8 :=
476: per_pst_shd.g_old_rec.attribute8;
477: End If;
478: If (p_rec.attribute9 = hr_api.g_varchar2) then
479: p_rec.attribute9 :=
480: per_pst_shd.g_old_rec.attribute9;

Line 480: per_pst_shd.g_old_rec.attribute9;

476: per_pst_shd.g_old_rec.attribute8;
477: End If;
478: If (p_rec.attribute9 = hr_api.g_varchar2) then
479: p_rec.attribute9 :=
480: per_pst_shd.g_old_rec.attribute9;
481: End If;
482: If (p_rec.attribute10 = hr_api.g_varchar2) then
483: p_rec.attribute10 :=
484: per_pst_shd.g_old_rec.attribute10;

Line 484: per_pst_shd.g_old_rec.attribute10;

480: per_pst_shd.g_old_rec.attribute9;
481: End If;
482: If (p_rec.attribute10 = hr_api.g_varchar2) then
483: p_rec.attribute10 :=
484: per_pst_shd.g_old_rec.attribute10;
485: End If;
486: If (p_rec.attribute11 = hr_api.g_varchar2) then
487: p_rec.attribute11 :=
488: per_pst_shd.g_old_rec.attribute11;

Line 488: per_pst_shd.g_old_rec.attribute11;

484: per_pst_shd.g_old_rec.attribute10;
485: End If;
486: If (p_rec.attribute11 = hr_api.g_varchar2) then
487: p_rec.attribute11 :=
488: per_pst_shd.g_old_rec.attribute11;
489: End If;
490: If (p_rec.attribute12 = hr_api.g_varchar2) then
491: p_rec.attribute12 :=
492: per_pst_shd.g_old_rec.attribute12;

Line 492: per_pst_shd.g_old_rec.attribute12;

488: per_pst_shd.g_old_rec.attribute11;
489: End If;
490: If (p_rec.attribute12 = hr_api.g_varchar2) then
491: p_rec.attribute12 :=
492: per_pst_shd.g_old_rec.attribute12;
493: End If;
494: If (p_rec.attribute13 = hr_api.g_varchar2) then
495: p_rec.attribute13 :=
496: per_pst_shd.g_old_rec.attribute13;

Line 496: per_pst_shd.g_old_rec.attribute13;

492: per_pst_shd.g_old_rec.attribute12;
493: End If;
494: If (p_rec.attribute13 = hr_api.g_varchar2) then
495: p_rec.attribute13 :=
496: per_pst_shd.g_old_rec.attribute13;
497: End If;
498: If (p_rec.attribute14 = hr_api.g_varchar2) then
499: p_rec.attribute14 :=
500: per_pst_shd.g_old_rec.attribute14;

Line 500: per_pst_shd.g_old_rec.attribute14;

496: per_pst_shd.g_old_rec.attribute13;
497: End If;
498: If (p_rec.attribute14 = hr_api.g_varchar2) then
499: p_rec.attribute14 :=
500: per_pst_shd.g_old_rec.attribute14;
501: End If;
502: If (p_rec.attribute15 = hr_api.g_varchar2) then
503: p_rec.attribute15 :=
504: per_pst_shd.g_old_rec.attribute15;

Line 504: per_pst_shd.g_old_rec.attribute15;

500: per_pst_shd.g_old_rec.attribute14;
501: End If;
502: If (p_rec.attribute15 = hr_api.g_varchar2) then
503: p_rec.attribute15 :=
504: per_pst_shd.g_old_rec.attribute15;
505: End If;
506: If (p_rec.attribute16 = hr_api.g_varchar2) then
507: p_rec.attribute16 :=
508: per_pst_shd.g_old_rec.attribute16;

Line 508: per_pst_shd.g_old_rec.attribute16;

504: per_pst_shd.g_old_rec.attribute15;
505: End If;
506: If (p_rec.attribute16 = hr_api.g_varchar2) then
507: p_rec.attribute16 :=
508: per_pst_shd.g_old_rec.attribute16;
509: End If;
510: If (p_rec.attribute17 = hr_api.g_varchar2) then
511: p_rec.attribute17 :=
512: per_pst_shd.g_old_rec.attribute17;

Line 512: per_pst_shd.g_old_rec.attribute17;

508: per_pst_shd.g_old_rec.attribute16;
509: End If;
510: If (p_rec.attribute17 = hr_api.g_varchar2) then
511: p_rec.attribute17 :=
512: per_pst_shd.g_old_rec.attribute17;
513: End If;
514: If (p_rec.attribute18 = hr_api.g_varchar2) then
515: p_rec.attribute18 :=
516: per_pst_shd.g_old_rec.attribute18;

Line 516: per_pst_shd.g_old_rec.attribute18;

512: per_pst_shd.g_old_rec.attribute17;
513: End If;
514: If (p_rec.attribute18 = hr_api.g_varchar2) then
515: p_rec.attribute18 :=
516: per_pst_shd.g_old_rec.attribute18;
517: End If;
518: If (p_rec.attribute19 = hr_api.g_varchar2) then
519: p_rec.attribute19 :=
520: per_pst_shd.g_old_rec.attribute19;

Line 520: per_pst_shd.g_old_rec.attribute19;

516: per_pst_shd.g_old_rec.attribute18;
517: End If;
518: If (p_rec.attribute19 = hr_api.g_varchar2) then
519: p_rec.attribute19 :=
520: per_pst_shd.g_old_rec.attribute19;
521: End If;
522: If (p_rec.attribute20 = hr_api.g_varchar2) then
523: p_rec.attribute20 :=
524: per_pst_shd.g_old_rec.attribute20;

Line 524: per_pst_shd.g_old_rec.attribute20;

520: per_pst_shd.g_old_rec.attribute19;
521: End If;
522: If (p_rec.attribute20 = hr_api.g_varchar2) then
523: p_rec.attribute20 :=
524: per_pst_shd.g_old_rec.attribute20;
525: End If;
526: --
527: End convert_defs;
528: --

Line 534: ,p_rec in out nocopy per_pst_shd.g_rec_type

530: -- |---------------------------------< upd >----------------------------------|
531: -- ----------------------------------------------------------------------------
532: Procedure upd
533: (p_effective_date in date
534: ,p_rec in out nocopy per_pst_shd.g_rec_type
535: ) is
536: --
537: l_proc varchar2(72) := g_package||'upd';
538: --

Line 544: per_pst_shd.lck

540: hr_utility.set_location('Entering:'||l_proc, 5);
541: --
542: -- We must lock the row which we need to update.
543: --
544: per_pst_shd.lck
545: (p_rec.position_structure_id
546: ,p_rec.object_version_number
547: );
548: --

Line 615: l_rec per_pst_shd.g_rec_type;

611: ,p_attribute19 in varchar2 default hr_api.g_varchar2
612: ,p_attribute20 in varchar2 default hr_api.g_varchar2
613: ) is
614: --
615: l_rec per_pst_shd.g_rec_type;
616: l_proc varchar2(72) := g_package||'upd';
617: --
618: Begin
619: hr_utility.set_location('Entering:'||l_proc, 5);

Line 625: per_pst_shd.convert_args

621: -- Call conversion function to turn arguments into the
622: -- l_rec structure.
623: --
624: l_rec :=
625: per_pst_shd.convert_args
626: (p_position_structure_id
627: ,p_business_group_id
628: ,p_name
629: ,p_comments