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_SPH_UPD dependencies on PER_SPH_SHD

Line 55: (p_rec in out nocopy per_sph_shd.g_rec_type

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

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

Line 111: per_sph_shd.g_api_dml := false; -- Unset the api dml status

107: ,attribute20 = p_rec.attribute20
108: ,object_version_number = p_rec.object_version_number
109: where plan_id = p_rec.plan_id;
110: --
111: per_sph_shd.g_api_dml := false; -- Unset the api dml status
112: --
113: hr_utility.set_location(' Leaving:'||l_proc, 10);
114: --
115: Exception

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

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

Line 119: per_sph_shd.constraint_error

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

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

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

Line 124: per_sph_shd.constraint_error

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

Line 128: per_sph_shd.g_api_dml := false; -- Unset the api dml status

124: per_sph_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.unique_integrity_violated Then
127: -- Unique integrity has been violated
128: per_sph_shd.g_api_dml := false; -- Unset the api dml status
129: per_sph_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When Others Then
132: per_sph_shd.g_api_dml := false; -- Unset the api dml status

Line 129: per_sph_shd.constraint_error

125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.unique_integrity_violated Then
127: -- Unique integrity has been violated
128: per_sph_shd.g_api_dml := false; -- Unset the api dml status
129: per_sph_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When Others Then
132: per_sph_shd.g_api_dml := false; -- Unset the api dml status
133: Raise;

Line 132: per_sph_shd.g_api_dml := false; -- Unset the api dml status

128: per_sph_shd.g_api_dml := false; -- Unset the api dml status
129: per_sph_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When Others Then
132: per_sph_shd.g_api_dml := false; -- Unset the api dml status
133: Raise;
134: End update_dml;
135: --
136: -- ----------------------------------------------------------------------------

Line 169: (p_rec in per_sph_shd.g_rec_type

165: --
166: -- {End Of Comments}
167: -- ----------------------------------------------------------------------------
168: Procedure pre_update
169: (p_rec in per_sph_shd.g_rec_type
170: ) is
171: --
172: l_proc varchar2(72) := g_package||'pre_update';
173: --

Line 214: ,p_rec in per_sph_shd.g_rec_type

210: -- {End Of Comments}
211: -- ----------------------------------------------------------------------------
212: Procedure post_update
213: (p_effective_date in date
214: ,p_rec in per_sph_shd.g_rec_type
215: ) is
216: --
217: l_proc varchar2(72) := g_package||'post_update';
218: --

Line 300: => per_sph_shd.g_old_rec.plan_type

296: => p_rec.attribute20
297: ,p_object_version_number
298: => p_rec.object_version_number
299: ,p_plan_type_o
300: => per_sph_shd.g_old_rec.plan_type
301: ,p_plan_name_o
302: => per_sph_shd.g_old_rec.plan_name
303: ,p_successee_id_o
304: => per_sph_shd.g_old_rec.successee_id

Line 302: => per_sph_shd.g_old_rec.plan_name

298: => p_rec.object_version_number
299: ,p_plan_type_o
300: => per_sph_shd.g_old_rec.plan_type
301: ,p_plan_name_o
302: => per_sph_shd.g_old_rec.plan_name
303: ,p_successee_id_o
304: => per_sph_shd.g_old_rec.successee_id
305: ,p_business_group_id_o
306: => per_sph_shd.g_old_rec.business_group_id

Line 304: => per_sph_shd.g_old_rec.successee_id

300: => per_sph_shd.g_old_rec.plan_type
301: ,p_plan_name_o
302: => per_sph_shd.g_old_rec.plan_name
303: ,p_successee_id_o
304: => per_sph_shd.g_old_rec.successee_id
305: ,p_business_group_id_o
306: => per_sph_shd.g_old_rec.business_group_id
307: ,p_description_o
308: => per_sph_shd.g_old_rec.description

Line 306: => per_sph_shd.g_old_rec.business_group_id

302: => per_sph_shd.g_old_rec.plan_name
303: ,p_successee_id_o
304: => per_sph_shd.g_old_rec.successee_id
305: ,p_business_group_id_o
306: => per_sph_shd.g_old_rec.business_group_id
307: ,p_description_o
308: => per_sph_shd.g_old_rec.description
309: ,p_status_o
310: => per_sph_shd.g_old_rec.status

Line 308: => per_sph_shd.g_old_rec.description

304: => per_sph_shd.g_old_rec.successee_id
305: ,p_business_group_id_o
306: => per_sph_shd.g_old_rec.business_group_id
307: ,p_description_o
308: => per_sph_shd.g_old_rec.description
309: ,p_status_o
310: => per_sph_shd.g_old_rec.status
311: ,p_plan_owner_o
312: => per_sph_shd.g_old_rec.plan_owner

Line 310: => per_sph_shd.g_old_rec.status

306: => per_sph_shd.g_old_rec.business_group_id
307: ,p_description_o
308: => per_sph_shd.g_old_rec.description
309: ,p_status_o
310: => per_sph_shd.g_old_rec.status
311: ,p_plan_owner_o
312: => per_sph_shd.g_old_rec.plan_owner
313: ,p_start_date_o
314: => per_sph_shd.g_old_rec.start_date

Line 312: => per_sph_shd.g_old_rec.plan_owner

308: => per_sph_shd.g_old_rec.description
309: ,p_status_o
310: => per_sph_shd.g_old_rec.status
311: ,p_plan_owner_o
312: => per_sph_shd.g_old_rec.plan_owner
313: ,p_start_date_o
314: => per_sph_shd.g_old_rec.start_date
315: ,p_end_date_o
316: => per_sph_shd.g_old_rec.end_date

Line 314: => per_sph_shd.g_old_rec.start_date

310: => per_sph_shd.g_old_rec.status
311: ,p_plan_owner_o
312: => per_sph_shd.g_old_rec.plan_owner
313: ,p_start_date_o
314: => per_sph_shd.g_old_rec.start_date
315: ,p_end_date_o
316: => per_sph_shd.g_old_rec.end_date
317: ,p_filled_from_plan_o
318: => per_sph_shd.g_old_rec.filled_from_plan

Line 316: => per_sph_shd.g_old_rec.end_date

312: => per_sph_shd.g_old_rec.plan_owner
313: ,p_start_date_o
314: => per_sph_shd.g_old_rec.start_date
315: ,p_end_date_o
316: => per_sph_shd.g_old_rec.end_date
317: ,p_filled_from_plan_o
318: => per_sph_shd.g_old_rec.filled_from_plan
319: ,p_filled_by_o
320: => per_sph_shd.g_old_rec.filled_by

Line 318: => per_sph_shd.g_old_rec.filled_from_plan

314: => per_sph_shd.g_old_rec.start_date
315: ,p_end_date_o
316: => per_sph_shd.g_old_rec.end_date
317: ,p_filled_from_plan_o
318: => per_sph_shd.g_old_rec.filled_from_plan
319: ,p_filled_by_o
320: => per_sph_shd.g_old_rec.filled_by
321: ,p_filled_on_o
322: => per_sph_shd.g_old_rec.filled_on

Line 320: => per_sph_shd.g_old_rec.filled_by

316: => per_sph_shd.g_old_rec.end_date
317: ,p_filled_from_plan_o
318: => per_sph_shd.g_old_rec.filled_from_plan
319: ,p_filled_by_o
320: => per_sph_shd.g_old_rec.filled_by
321: ,p_filled_on_o
322: => per_sph_shd.g_old_rec.filled_on
323: ,p_next_review_date_o
324: => per_sph_shd.g_old_rec.next_review_date

Line 322: => per_sph_shd.g_old_rec.filled_on

318: => per_sph_shd.g_old_rec.filled_from_plan
319: ,p_filled_by_o
320: => per_sph_shd.g_old_rec.filled_by
321: ,p_filled_on_o
322: => per_sph_shd.g_old_rec.filled_on
323: ,p_next_review_date_o
324: => per_sph_shd.g_old_rec.next_review_date
325: ,p_criteria_set_id_o
326: => per_sph_shd.g_old_rec.criteria_set_id

Line 324: => per_sph_shd.g_old_rec.next_review_date

320: => per_sph_shd.g_old_rec.filled_by
321: ,p_filled_on_o
322: => per_sph_shd.g_old_rec.filled_on
323: ,p_next_review_date_o
324: => per_sph_shd.g_old_rec.next_review_date
325: ,p_criteria_set_id_o
326: => per_sph_shd.g_old_rec.criteria_set_id
327: ,p_attribute_category_o
328: => per_sph_shd.g_old_rec.attribute_category

Line 326: => per_sph_shd.g_old_rec.criteria_set_id

322: => per_sph_shd.g_old_rec.filled_on
323: ,p_next_review_date_o
324: => per_sph_shd.g_old_rec.next_review_date
325: ,p_criteria_set_id_o
326: => per_sph_shd.g_old_rec.criteria_set_id
327: ,p_attribute_category_o
328: => per_sph_shd.g_old_rec.attribute_category
329: ,p_attribute1_o
330: => per_sph_shd.g_old_rec.attribute1

Line 328: => per_sph_shd.g_old_rec.attribute_category

324: => per_sph_shd.g_old_rec.next_review_date
325: ,p_criteria_set_id_o
326: => per_sph_shd.g_old_rec.criteria_set_id
327: ,p_attribute_category_o
328: => per_sph_shd.g_old_rec.attribute_category
329: ,p_attribute1_o
330: => per_sph_shd.g_old_rec.attribute1
331: ,p_attribute2_o
332: => per_sph_shd.g_old_rec.attribute2

Line 330: => per_sph_shd.g_old_rec.attribute1

326: => per_sph_shd.g_old_rec.criteria_set_id
327: ,p_attribute_category_o
328: => per_sph_shd.g_old_rec.attribute_category
329: ,p_attribute1_o
330: => per_sph_shd.g_old_rec.attribute1
331: ,p_attribute2_o
332: => per_sph_shd.g_old_rec.attribute2
333: ,p_attribute3_o
334: => per_sph_shd.g_old_rec.attribute3

Line 332: => per_sph_shd.g_old_rec.attribute2

328: => per_sph_shd.g_old_rec.attribute_category
329: ,p_attribute1_o
330: => per_sph_shd.g_old_rec.attribute1
331: ,p_attribute2_o
332: => per_sph_shd.g_old_rec.attribute2
333: ,p_attribute3_o
334: => per_sph_shd.g_old_rec.attribute3
335: ,p_attribute4_o
336: => per_sph_shd.g_old_rec.attribute4

Line 334: => per_sph_shd.g_old_rec.attribute3

330: => per_sph_shd.g_old_rec.attribute1
331: ,p_attribute2_o
332: => per_sph_shd.g_old_rec.attribute2
333: ,p_attribute3_o
334: => per_sph_shd.g_old_rec.attribute3
335: ,p_attribute4_o
336: => per_sph_shd.g_old_rec.attribute4
337: ,p_attribute5_o
338: => per_sph_shd.g_old_rec.attribute5

Line 336: => per_sph_shd.g_old_rec.attribute4

332: => per_sph_shd.g_old_rec.attribute2
333: ,p_attribute3_o
334: => per_sph_shd.g_old_rec.attribute3
335: ,p_attribute4_o
336: => per_sph_shd.g_old_rec.attribute4
337: ,p_attribute5_o
338: => per_sph_shd.g_old_rec.attribute5
339: ,p_attribute6_o
340: => per_sph_shd.g_old_rec.attribute6

Line 338: => per_sph_shd.g_old_rec.attribute5

334: => per_sph_shd.g_old_rec.attribute3
335: ,p_attribute4_o
336: => per_sph_shd.g_old_rec.attribute4
337: ,p_attribute5_o
338: => per_sph_shd.g_old_rec.attribute5
339: ,p_attribute6_o
340: => per_sph_shd.g_old_rec.attribute6
341: ,p_attribute7_o
342: => per_sph_shd.g_old_rec.attribute7

Line 340: => per_sph_shd.g_old_rec.attribute6

336: => per_sph_shd.g_old_rec.attribute4
337: ,p_attribute5_o
338: => per_sph_shd.g_old_rec.attribute5
339: ,p_attribute6_o
340: => per_sph_shd.g_old_rec.attribute6
341: ,p_attribute7_o
342: => per_sph_shd.g_old_rec.attribute7
343: ,p_attribute8_o
344: => per_sph_shd.g_old_rec.attribute8

Line 342: => per_sph_shd.g_old_rec.attribute7

338: => per_sph_shd.g_old_rec.attribute5
339: ,p_attribute6_o
340: => per_sph_shd.g_old_rec.attribute6
341: ,p_attribute7_o
342: => per_sph_shd.g_old_rec.attribute7
343: ,p_attribute8_o
344: => per_sph_shd.g_old_rec.attribute8
345: ,p_attribute9_o
346: => per_sph_shd.g_old_rec.attribute9

Line 344: => per_sph_shd.g_old_rec.attribute8

340: => per_sph_shd.g_old_rec.attribute6
341: ,p_attribute7_o
342: => per_sph_shd.g_old_rec.attribute7
343: ,p_attribute8_o
344: => per_sph_shd.g_old_rec.attribute8
345: ,p_attribute9_o
346: => per_sph_shd.g_old_rec.attribute9
347: ,p_attribute10_o
348: => per_sph_shd.g_old_rec.attribute10

Line 346: => per_sph_shd.g_old_rec.attribute9

342: => per_sph_shd.g_old_rec.attribute7
343: ,p_attribute8_o
344: => per_sph_shd.g_old_rec.attribute8
345: ,p_attribute9_o
346: => per_sph_shd.g_old_rec.attribute9
347: ,p_attribute10_o
348: => per_sph_shd.g_old_rec.attribute10
349: ,p_attribute11_o
350: => per_sph_shd.g_old_rec.attribute11

Line 348: => per_sph_shd.g_old_rec.attribute10

344: => per_sph_shd.g_old_rec.attribute8
345: ,p_attribute9_o
346: => per_sph_shd.g_old_rec.attribute9
347: ,p_attribute10_o
348: => per_sph_shd.g_old_rec.attribute10
349: ,p_attribute11_o
350: => per_sph_shd.g_old_rec.attribute11
351: ,p_attribute12_o
352: => per_sph_shd.g_old_rec.attribute12

Line 350: => per_sph_shd.g_old_rec.attribute11

346: => per_sph_shd.g_old_rec.attribute9
347: ,p_attribute10_o
348: => per_sph_shd.g_old_rec.attribute10
349: ,p_attribute11_o
350: => per_sph_shd.g_old_rec.attribute11
351: ,p_attribute12_o
352: => per_sph_shd.g_old_rec.attribute12
353: ,p_attribute13_o
354: => per_sph_shd.g_old_rec.attribute13

Line 352: => per_sph_shd.g_old_rec.attribute12

348: => per_sph_shd.g_old_rec.attribute10
349: ,p_attribute11_o
350: => per_sph_shd.g_old_rec.attribute11
351: ,p_attribute12_o
352: => per_sph_shd.g_old_rec.attribute12
353: ,p_attribute13_o
354: => per_sph_shd.g_old_rec.attribute13
355: ,p_attribute14_o
356: => per_sph_shd.g_old_rec.attribute14

Line 354: => per_sph_shd.g_old_rec.attribute13

350: => per_sph_shd.g_old_rec.attribute11
351: ,p_attribute12_o
352: => per_sph_shd.g_old_rec.attribute12
353: ,p_attribute13_o
354: => per_sph_shd.g_old_rec.attribute13
355: ,p_attribute14_o
356: => per_sph_shd.g_old_rec.attribute14
357: ,p_attribute15_o
358: => per_sph_shd.g_old_rec.attribute15

Line 356: => per_sph_shd.g_old_rec.attribute14

352: => per_sph_shd.g_old_rec.attribute12
353: ,p_attribute13_o
354: => per_sph_shd.g_old_rec.attribute13
355: ,p_attribute14_o
356: => per_sph_shd.g_old_rec.attribute14
357: ,p_attribute15_o
358: => per_sph_shd.g_old_rec.attribute15
359: ,p_attribute16_o
360: => per_sph_shd.g_old_rec.attribute16

Line 358: => per_sph_shd.g_old_rec.attribute15

354: => per_sph_shd.g_old_rec.attribute13
355: ,p_attribute14_o
356: => per_sph_shd.g_old_rec.attribute14
357: ,p_attribute15_o
358: => per_sph_shd.g_old_rec.attribute15
359: ,p_attribute16_o
360: => per_sph_shd.g_old_rec.attribute16
361: ,p_attribute17_o
362: => per_sph_shd.g_old_rec.attribute17

Line 360: => per_sph_shd.g_old_rec.attribute16

356: => per_sph_shd.g_old_rec.attribute14
357: ,p_attribute15_o
358: => per_sph_shd.g_old_rec.attribute15
359: ,p_attribute16_o
360: => per_sph_shd.g_old_rec.attribute16
361: ,p_attribute17_o
362: => per_sph_shd.g_old_rec.attribute17
363: ,p_attribute18_o
364: => per_sph_shd.g_old_rec.attribute18

Line 362: => per_sph_shd.g_old_rec.attribute17

358: => per_sph_shd.g_old_rec.attribute15
359: ,p_attribute16_o
360: => per_sph_shd.g_old_rec.attribute16
361: ,p_attribute17_o
362: => per_sph_shd.g_old_rec.attribute17
363: ,p_attribute18_o
364: => per_sph_shd.g_old_rec.attribute18
365: ,p_attribute19_o
366: => per_sph_shd.g_old_rec.attribute19

Line 364: => per_sph_shd.g_old_rec.attribute18

360: => per_sph_shd.g_old_rec.attribute16
361: ,p_attribute17_o
362: => per_sph_shd.g_old_rec.attribute17
363: ,p_attribute18_o
364: => per_sph_shd.g_old_rec.attribute18
365: ,p_attribute19_o
366: => per_sph_shd.g_old_rec.attribute19
367: ,p_attribute20_o
368: => per_sph_shd.g_old_rec.attribute20

Line 366: => per_sph_shd.g_old_rec.attribute19

362: => per_sph_shd.g_old_rec.attribute17
363: ,p_attribute18_o
364: => per_sph_shd.g_old_rec.attribute18
365: ,p_attribute19_o
366: => per_sph_shd.g_old_rec.attribute19
367: ,p_attribute20_o
368: => per_sph_shd.g_old_rec.attribute20
369: ,p_object_version_number_o
370: => per_sph_shd.g_old_rec.object_version_number

Line 368: => per_sph_shd.g_old_rec.attribute20

364: => per_sph_shd.g_old_rec.attribute18
365: ,p_attribute19_o
366: => per_sph_shd.g_old_rec.attribute19
367: ,p_attribute20_o
368: => per_sph_shd.g_old_rec.attribute20
369: ,p_object_version_number_o
370: => per_sph_shd.g_old_rec.object_version_number
371: );
372: --

Line 370: => per_sph_shd.g_old_rec.object_version_number

366: => per_sph_shd.g_old_rec.attribute19
367: ,p_attribute20_o
368: => per_sph_shd.g_old_rec.attribute20
369: ,p_object_version_number_o
370: => per_sph_shd.g_old_rec.object_version_number
371: );
372: --
373: exception
374: --

Line 430: (p_rec in out nocopy per_sph_shd.g_rec_type

426: --
427: -- {End Of Comments}
428: -- ----------------------------------------------------------------------------
429: Procedure convert_defs
430: (p_rec in out nocopy per_sph_shd.g_rec_type
431: ) is
432: --
433: Begin
434: --

Line 442: per_sph_shd.g_old_rec.plan_type;

438: -- is being used then we must set to the 'current' argument value.
439: --
440: If (p_rec.plan_type = hr_api.g_varchar2) then
441: p_rec.plan_type :=
442: per_sph_shd.g_old_rec.plan_type;
443: End If;
444: If (p_rec.plan_name = hr_api.g_varchar2) then
445: p_rec.plan_name :=
446: per_sph_shd.g_old_rec.plan_name;

Line 446: per_sph_shd.g_old_rec.plan_name;

442: per_sph_shd.g_old_rec.plan_type;
443: End If;
444: If (p_rec.plan_name = hr_api.g_varchar2) then
445: p_rec.plan_name :=
446: per_sph_shd.g_old_rec.plan_name;
447: End If;
448: If (p_rec.successee_id = hr_api.g_number) then
449: p_rec.successee_id :=
450: per_sph_shd.g_old_rec.successee_id;

Line 450: per_sph_shd.g_old_rec.successee_id;

446: per_sph_shd.g_old_rec.plan_name;
447: End If;
448: If (p_rec.successee_id = hr_api.g_number) then
449: p_rec.successee_id :=
450: per_sph_shd.g_old_rec.successee_id;
451: End If;
452: If (p_rec.business_group_id = hr_api.g_number) then
453: p_rec.business_group_id :=
454: per_sph_shd.g_old_rec.business_group_id;

Line 454: per_sph_shd.g_old_rec.business_group_id;

450: per_sph_shd.g_old_rec.successee_id;
451: End If;
452: If (p_rec.business_group_id = hr_api.g_number) then
453: p_rec.business_group_id :=
454: per_sph_shd.g_old_rec.business_group_id;
455: End If;
456: If (p_rec.description = hr_api.g_varchar2) then
457: p_rec.description :=
458: per_sph_shd.g_old_rec.description;

Line 458: per_sph_shd.g_old_rec.description;

454: per_sph_shd.g_old_rec.business_group_id;
455: End If;
456: If (p_rec.description = hr_api.g_varchar2) then
457: p_rec.description :=
458: per_sph_shd.g_old_rec.description;
459: End If;
460: If (p_rec.status = hr_api.g_varchar2) then
461: p_rec.status :=
462: per_sph_shd.g_old_rec.status;

Line 462: per_sph_shd.g_old_rec.status;

458: per_sph_shd.g_old_rec.description;
459: End If;
460: If (p_rec.status = hr_api.g_varchar2) then
461: p_rec.status :=
462: per_sph_shd.g_old_rec.status;
463: End If;
464: If (p_rec.plan_owner = hr_api.g_number) then
465: p_rec.plan_owner :=
466: per_sph_shd.g_old_rec.plan_owner;

Line 466: per_sph_shd.g_old_rec.plan_owner;

462: per_sph_shd.g_old_rec.status;
463: End If;
464: If (p_rec.plan_owner = hr_api.g_number) then
465: p_rec.plan_owner :=
466: per_sph_shd.g_old_rec.plan_owner;
467: End If;
468: If (p_rec.start_date = hr_api.g_date) then
469: p_rec.start_date :=
470: per_sph_shd.g_old_rec.start_date;

Line 470: per_sph_shd.g_old_rec.start_date;

466: per_sph_shd.g_old_rec.plan_owner;
467: End If;
468: If (p_rec.start_date = hr_api.g_date) then
469: p_rec.start_date :=
470: per_sph_shd.g_old_rec.start_date;
471: End If;
472: If (p_rec.end_date = hr_api.g_date) then
473: p_rec.end_date :=
474: per_sph_shd.g_old_rec.end_date;

Line 474: per_sph_shd.g_old_rec.end_date;

470: per_sph_shd.g_old_rec.start_date;
471: End If;
472: If (p_rec.end_date = hr_api.g_date) then
473: p_rec.end_date :=
474: per_sph_shd.g_old_rec.end_date;
475: End If;
476: If (p_rec.filled_from_plan = hr_api.g_varchar2) then
477: p_rec.filled_from_plan :=
478: per_sph_shd.g_old_rec.filled_from_plan;

Line 478: per_sph_shd.g_old_rec.filled_from_plan;

474: per_sph_shd.g_old_rec.end_date;
475: End If;
476: If (p_rec.filled_from_plan = hr_api.g_varchar2) then
477: p_rec.filled_from_plan :=
478: per_sph_shd.g_old_rec.filled_from_plan;
479: End If;
480: If (p_rec.filled_by = hr_api.g_number) then
481: p_rec.filled_by :=
482: per_sph_shd.g_old_rec.filled_by;

Line 482: per_sph_shd.g_old_rec.filled_by;

478: per_sph_shd.g_old_rec.filled_from_plan;
479: End If;
480: If (p_rec.filled_by = hr_api.g_number) then
481: p_rec.filled_by :=
482: per_sph_shd.g_old_rec.filled_by;
483: End If;
484: If (p_rec.filled_on = hr_api.g_date) then
485: p_rec.filled_on :=
486: per_sph_shd.g_old_rec.filled_on;

Line 486: per_sph_shd.g_old_rec.filled_on;

482: per_sph_shd.g_old_rec.filled_by;
483: End If;
484: If (p_rec.filled_on = hr_api.g_date) then
485: p_rec.filled_on :=
486: per_sph_shd.g_old_rec.filled_on;
487: End If;
488: If (p_rec.next_review_date = hr_api.g_date) then
489: p_rec.next_review_date :=
490: per_sph_shd.g_old_rec.next_review_date;

Line 490: per_sph_shd.g_old_rec.next_review_date;

486: per_sph_shd.g_old_rec.filled_on;
487: End If;
488: If (p_rec.next_review_date = hr_api.g_date) then
489: p_rec.next_review_date :=
490: per_sph_shd.g_old_rec.next_review_date;
491: End If;
492: If (p_rec.criteria_set_id = hr_api.g_number) then
493: p_rec.criteria_set_id :=
494: per_sph_shd.g_old_rec.criteria_set_id;

Line 494: per_sph_shd.g_old_rec.criteria_set_id;

490: per_sph_shd.g_old_rec.next_review_date;
491: End If;
492: If (p_rec.criteria_set_id = hr_api.g_number) then
493: p_rec.criteria_set_id :=
494: per_sph_shd.g_old_rec.criteria_set_id;
495: End If;
496: If (p_rec.attribute_category = hr_api.g_varchar2) then
497: p_rec.attribute_category :=
498: per_sph_shd.g_old_rec.attribute_category;

Line 498: per_sph_shd.g_old_rec.attribute_category;

494: per_sph_shd.g_old_rec.criteria_set_id;
495: End If;
496: If (p_rec.attribute_category = hr_api.g_varchar2) then
497: p_rec.attribute_category :=
498: per_sph_shd.g_old_rec.attribute_category;
499: End If;
500: If (p_rec.attribute1 = hr_api.g_varchar2) then
501: p_rec.attribute1 :=
502: per_sph_shd.g_old_rec.attribute1;

Line 502: per_sph_shd.g_old_rec.attribute1;

498: per_sph_shd.g_old_rec.attribute_category;
499: End If;
500: If (p_rec.attribute1 = hr_api.g_varchar2) then
501: p_rec.attribute1 :=
502: per_sph_shd.g_old_rec.attribute1;
503: End If;
504: If (p_rec.attribute2 = hr_api.g_varchar2) then
505: p_rec.attribute2 :=
506: per_sph_shd.g_old_rec.attribute2;

Line 506: per_sph_shd.g_old_rec.attribute2;

502: per_sph_shd.g_old_rec.attribute1;
503: End If;
504: If (p_rec.attribute2 = hr_api.g_varchar2) then
505: p_rec.attribute2 :=
506: per_sph_shd.g_old_rec.attribute2;
507: End If;
508: If (p_rec.attribute3 = hr_api.g_varchar2) then
509: p_rec.attribute3 :=
510: per_sph_shd.g_old_rec.attribute3;

Line 510: per_sph_shd.g_old_rec.attribute3;

506: per_sph_shd.g_old_rec.attribute2;
507: End If;
508: If (p_rec.attribute3 = hr_api.g_varchar2) then
509: p_rec.attribute3 :=
510: per_sph_shd.g_old_rec.attribute3;
511: End If;
512: If (p_rec.attribute4 = hr_api.g_varchar2) then
513: p_rec.attribute4 :=
514: per_sph_shd.g_old_rec.attribute4;

Line 514: per_sph_shd.g_old_rec.attribute4;

510: per_sph_shd.g_old_rec.attribute3;
511: End If;
512: If (p_rec.attribute4 = hr_api.g_varchar2) then
513: p_rec.attribute4 :=
514: per_sph_shd.g_old_rec.attribute4;
515: End If;
516: If (p_rec.attribute5 = hr_api.g_varchar2) then
517: p_rec.attribute5 :=
518: per_sph_shd.g_old_rec.attribute5;

Line 518: per_sph_shd.g_old_rec.attribute5;

514: per_sph_shd.g_old_rec.attribute4;
515: End If;
516: If (p_rec.attribute5 = hr_api.g_varchar2) then
517: p_rec.attribute5 :=
518: per_sph_shd.g_old_rec.attribute5;
519: End If;
520: If (p_rec.attribute6 = hr_api.g_varchar2) then
521: p_rec.attribute6 :=
522: per_sph_shd.g_old_rec.attribute6;

Line 522: per_sph_shd.g_old_rec.attribute6;

518: per_sph_shd.g_old_rec.attribute5;
519: End If;
520: If (p_rec.attribute6 = hr_api.g_varchar2) then
521: p_rec.attribute6 :=
522: per_sph_shd.g_old_rec.attribute6;
523: End If;
524: If (p_rec.attribute7 = hr_api.g_varchar2) then
525: p_rec.attribute7 :=
526: per_sph_shd.g_old_rec.attribute7;

Line 526: per_sph_shd.g_old_rec.attribute7;

522: per_sph_shd.g_old_rec.attribute6;
523: End If;
524: If (p_rec.attribute7 = hr_api.g_varchar2) then
525: p_rec.attribute7 :=
526: per_sph_shd.g_old_rec.attribute7;
527: End If;
528: If (p_rec.attribute8 = hr_api.g_varchar2) then
529: p_rec.attribute8 :=
530: per_sph_shd.g_old_rec.attribute8;

Line 530: per_sph_shd.g_old_rec.attribute8;

526: per_sph_shd.g_old_rec.attribute7;
527: End If;
528: If (p_rec.attribute8 = hr_api.g_varchar2) then
529: p_rec.attribute8 :=
530: per_sph_shd.g_old_rec.attribute8;
531: End If;
532: If (p_rec.attribute9 = hr_api.g_varchar2) then
533: p_rec.attribute9 :=
534: per_sph_shd.g_old_rec.attribute9;

Line 534: per_sph_shd.g_old_rec.attribute9;

530: per_sph_shd.g_old_rec.attribute8;
531: End If;
532: If (p_rec.attribute9 = hr_api.g_varchar2) then
533: p_rec.attribute9 :=
534: per_sph_shd.g_old_rec.attribute9;
535: End If;
536: If (p_rec.attribute10 = hr_api.g_varchar2) then
537: p_rec.attribute10 :=
538: per_sph_shd.g_old_rec.attribute10;

Line 538: per_sph_shd.g_old_rec.attribute10;

534: per_sph_shd.g_old_rec.attribute9;
535: End If;
536: If (p_rec.attribute10 = hr_api.g_varchar2) then
537: p_rec.attribute10 :=
538: per_sph_shd.g_old_rec.attribute10;
539: End If;
540: If (p_rec.attribute11 = hr_api.g_varchar2) then
541: p_rec.attribute11 :=
542: per_sph_shd.g_old_rec.attribute11;

Line 542: per_sph_shd.g_old_rec.attribute11;

538: per_sph_shd.g_old_rec.attribute10;
539: End If;
540: If (p_rec.attribute11 = hr_api.g_varchar2) then
541: p_rec.attribute11 :=
542: per_sph_shd.g_old_rec.attribute11;
543: End If;
544: If (p_rec.attribute12 = hr_api.g_varchar2) then
545: p_rec.attribute12 :=
546: per_sph_shd.g_old_rec.attribute12;

Line 546: per_sph_shd.g_old_rec.attribute12;

542: per_sph_shd.g_old_rec.attribute11;
543: End If;
544: If (p_rec.attribute12 = hr_api.g_varchar2) then
545: p_rec.attribute12 :=
546: per_sph_shd.g_old_rec.attribute12;
547: End If;
548: If (p_rec.attribute13 = hr_api.g_varchar2) then
549: p_rec.attribute13 :=
550: per_sph_shd.g_old_rec.attribute13;

Line 550: per_sph_shd.g_old_rec.attribute13;

546: per_sph_shd.g_old_rec.attribute12;
547: End If;
548: If (p_rec.attribute13 = hr_api.g_varchar2) then
549: p_rec.attribute13 :=
550: per_sph_shd.g_old_rec.attribute13;
551: End If;
552: If (p_rec.attribute14 = hr_api.g_varchar2) then
553: p_rec.attribute14 :=
554: per_sph_shd.g_old_rec.attribute14;

Line 554: per_sph_shd.g_old_rec.attribute14;

550: per_sph_shd.g_old_rec.attribute13;
551: End If;
552: If (p_rec.attribute14 = hr_api.g_varchar2) then
553: p_rec.attribute14 :=
554: per_sph_shd.g_old_rec.attribute14;
555: End If;
556: If (p_rec.attribute15 = hr_api.g_varchar2) then
557: p_rec.attribute15 :=
558: per_sph_shd.g_old_rec.attribute15;

Line 558: per_sph_shd.g_old_rec.attribute15;

554: per_sph_shd.g_old_rec.attribute14;
555: End If;
556: If (p_rec.attribute15 = hr_api.g_varchar2) then
557: p_rec.attribute15 :=
558: per_sph_shd.g_old_rec.attribute15;
559: End If;
560: If (p_rec.attribute16 = hr_api.g_varchar2) then
561: p_rec.attribute16 :=
562: per_sph_shd.g_old_rec.attribute16;

Line 562: per_sph_shd.g_old_rec.attribute16;

558: per_sph_shd.g_old_rec.attribute15;
559: End If;
560: If (p_rec.attribute16 = hr_api.g_varchar2) then
561: p_rec.attribute16 :=
562: per_sph_shd.g_old_rec.attribute16;
563: End If;
564: If (p_rec.attribute17 = hr_api.g_varchar2) then
565: p_rec.attribute17 :=
566: per_sph_shd.g_old_rec.attribute17;

Line 566: per_sph_shd.g_old_rec.attribute17;

562: per_sph_shd.g_old_rec.attribute16;
563: End If;
564: If (p_rec.attribute17 = hr_api.g_varchar2) then
565: p_rec.attribute17 :=
566: per_sph_shd.g_old_rec.attribute17;
567: End If;
568: If (p_rec.attribute18 = hr_api.g_varchar2) then
569: p_rec.attribute18 :=
570: per_sph_shd.g_old_rec.attribute18;

Line 570: per_sph_shd.g_old_rec.attribute18;

566: per_sph_shd.g_old_rec.attribute17;
567: End If;
568: If (p_rec.attribute18 = hr_api.g_varchar2) then
569: p_rec.attribute18 :=
570: per_sph_shd.g_old_rec.attribute18;
571: End If;
572: If (p_rec.attribute19 = hr_api.g_varchar2) then
573: p_rec.attribute19 :=
574: per_sph_shd.g_old_rec.attribute19;

Line 574: per_sph_shd.g_old_rec.attribute19;

570: per_sph_shd.g_old_rec.attribute18;
571: End If;
572: If (p_rec.attribute19 = hr_api.g_varchar2) then
573: p_rec.attribute19 :=
574: per_sph_shd.g_old_rec.attribute19;
575: End If;
576: If (p_rec.attribute20 = hr_api.g_varchar2) then
577: p_rec.attribute20 :=
578: per_sph_shd.g_old_rec.attribute20;

Line 578: per_sph_shd.g_old_rec.attribute20;

574: per_sph_shd.g_old_rec.attribute19;
575: End If;
576: If (p_rec.attribute20 = hr_api.g_varchar2) then
577: p_rec.attribute20 :=
578: per_sph_shd.g_old_rec.attribute20;
579: End If;
580: --
581: End convert_defs;
582: --

Line 588: ,p_rec in out nocopy per_sph_shd.g_rec_type

584: -- |---------------------------------< upd >----------------------------------|
585: -- ----------------------------------------------------------------------------
586: Procedure upd
587: (p_effective_date in date
588: ,p_rec in out nocopy per_sph_shd.g_rec_type
589: ) is
590: --
591: l_proc varchar2(72) := g_package||'upd';
592: --

Line 598: per_sph_shd.lck

594: hr_utility.set_location('Entering:'||l_proc, 5);
595: --
596: -- We must lock the row which we need to update.
597: --
598: per_sph_shd.lck
599: (p_rec.plan_id
600: ,p_rec.object_version_number
601: );
602: --

Line 681: l_rec per_sph_shd.g_rec_type;

677: ,p_attribute19 in varchar2 default hr_api.g_varchar2
678: ,p_attribute20 in varchar2 default hr_api.g_varchar2
679: ) is
680: --
681: l_rec per_sph_shd.g_rec_type;
682: l_proc varchar2(72) := g_package||'upd';
683: --
684: Begin
685: hr_utility.set_location('Entering:'||l_proc, 5);

Line 691: per_sph_shd.convert_args

687: -- Call conversion function to turn arguments into the
688: -- l_rec structure.
689: --
690: l_rec :=
691: per_sph_shd.convert_args
692: (p_plan_id
693: ,p_plan_type
694: ,p_plan_name
695: ,p_successee_id