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_ECO_UPD dependencies on PER_ECO_SHD

Line 55: (p_rec in out nocopy per_eco_shd.g_rec_type

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

Line 69: per_eco_shd.g_api_dml := true; -- Set the api dml status

65: --
66: -- Increment the object version
67: p_rec.object_version_number := p_rec.object_version_number + 1;
68: --
69: per_eco_shd.g_api_dml := true; -- Set the api dml status
70: --
71: -- Set the who columns
72: --
73: l_last_update_date := sysdate;

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

118: ,last_updated_by = l_last_updated_by
119: ,last_update_login = l_last_update_login
120: where election_constituency_id = p_rec.election_constituency_id;
121: --
122: per_eco_shd.g_api_dml := false; -- Unset the api dml status
123: --
124: hr_utility.set_location(' Leaving:'||l_proc, 10);
125: --
126: Exception

Line 129: per_eco_shd.g_api_dml := false; -- Unset the api dml status

125: --
126: Exception
127: When hr_api.check_integrity_violated Then
128: -- A check constraint has been violated
129: per_eco_shd.g_api_dml := false; -- Unset the api dml status
130: per_eco_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When hr_api.parent_integrity_violated Then
133: -- Parent integrity has been violated

Line 130: per_eco_shd.constraint_error

126: Exception
127: When hr_api.check_integrity_violated Then
128: -- A check constraint has been violated
129: per_eco_shd.g_api_dml := false; -- Unset the api dml status
130: per_eco_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When hr_api.parent_integrity_violated Then
133: -- Parent integrity has been violated
134: per_eco_shd.g_api_dml := false; -- Unset the api dml status

Line 134: per_eco_shd.g_api_dml := false; -- Unset the api dml status

130: per_eco_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When hr_api.parent_integrity_violated Then
133: -- Parent integrity has been violated
134: per_eco_shd.g_api_dml := false; -- Unset the api dml status
135: per_eco_shd.constraint_error
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
137: When hr_api.unique_integrity_violated Then
138: -- Unique integrity has been violated

Line 135: per_eco_shd.constraint_error

131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When hr_api.parent_integrity_violated Then
133: -- Parent integrity has been violated
134: per_eco_shd.g_api_dml := false; -- Unset the api dml status
135: per_eco_shd.constraint_error
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
137: When hr_api.unique_integrity_violated Then
138: -- Unique integrity has been violated
139: per_eco_shd.g_api_dml := false; -- Unset the api dml status

Line 139: per_eco_shd.g_api_dml := false; -- Unset the api dml status

135: per_eco_shd.constraint_error
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
137: When hr_api.unique_integrity_violated Then
138: -- Unique integrity has been violated
139: per_eco_shd.g_api_dml := false; -- Unset the api dml status
140: per_eco_shd.constraint_error
141: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
142: When Others Then
143: per_eco_shd.g_api_dml := false; -- Unset the api dml status

Line 140: per_eco_shd.constraint_error

136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
137: When hr_api.unique_integrity_violated Then
138: -- Unique integrity has been violated
139: per_eco_shd.g_api_dml := false; -- Unset the api dml status
140: per_eco_shd.constraint_error
141: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
142: When Others Then
143: per_eco_shd.g_api_dml := false; -- Unset the api dml status
144: Raise;

Line 143: per_eco_shd.g_api_dml := false; -- Unset the api dml status

139: per_eco_shd.g_api_dml := false; -- Unset the api dml status
140: per_eco_shd.constraint_error
141: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
142: When Others Then
143: per_eco_shd.g_api_dml := false; -- Unset the api dml status
144: Raise;
145: End update_dml;
146: --
147: -- ----------------------------------------------------------------------------

Line 180: (p_rec in per_eco_shd.g_rec_type

176: --
177: -- {End Of Comments}
178: -- ----------------------------------------------------------------------------
179: Procedure pre_update
180: (p_rec in per_eco_shd.g_rec_type
181: ) is
182: --
183: l_proc varchar2(72) := g_package||'pre_update';
184: --

Line 225: ,p_rec in per_eco_shd.g_rec_type

221: -- {End Of Comments}
222: -- ----------------------------------------------------------------------------
223: Procedure post_update
224: (p_effective_date in date
225: ,p_rec in per_eco_shd.g_rec_type
226: ) is
227: --
228: l_proc varchar2(72) := g_package||'post_update';
229: --

Line 309: => per_eco_shd.g_old_rec.election_id

305: => p_rec.attribute30
306: ,p_object_version_number
307: => p_rec.object_version_number
308: ,p_election_id_o
309: => per_eco_shd.g_old_rec.election_id
310: ,p_business_group_id_o
311: => per_eco_shd.g_old_rec.business_group_id
312: ,p_constituency_id_o
313: => per_eco_shd.g_old_rec.constituency_id

Line 311: => per_eco_shd.g_old_rec.business_group_id

307: => p_rec.object_version_number
308: ,p_election_id_o
309: => per_eco_shd.g_old_rec.election_id
310: ,p_business_group_id_o
311: => per_eco_shd.g_old_rec.business_group_id
312: ,p_constituency_id_o
313: => per_eco_shd.g_old_rec.constituency_id
314: ,p_attribute_category_o
315: => per_eco_shd.g_old_rec.attribute_category

Line 313: => per_eco_shd.g_old_rec.constituency_id

309: => per_eco_shd.g_old_rec.election_id
310: ,p_business_group_id_o
311: => per_eco_shd.g_old_rec.business_group_id
312: ,p_constituency_id_o
313: => per_eco_shd.g_old_rec.constituency_id
314: ,p_attribute_category_o
315: => per_eco_shd.g_old_rec.attribute_category
316: ,p_attribute1_o
317: => per_eco_shd.g_old_rec.attribute1

Line 315: => per_eco_shd.g_old_rec.attribute_category

311: => per_eco_shd.g_old_rec.business_group_id
312: ,p_constituency_id_o
313: => per_eco_shd.g_old_rec.constituency_id
314: ,p_attribute_category_o
315: => per_eco_shd.g_old_rec.attribute_category
316: ,p_attribute1_o
317: => per_eco_shd.g_old_rec.attribute1
318: ,p_attribute2_o
319: => per_eco_shd.g_old_rec.attribute2

Line 317: => per_eco_shd.g_old_rec.attribute1

313: => per_eco_shd.g_old_rec.constituency_id
314: ,p_attribute_category_o
315: => per_eco_shd.g_old_rec.attribute_category
316: ,p_attribute1_o
317: => per_eco_shd.g_old_rec.attribute1
318: ,p_attribute2_o
319: => per_eco_shd.g_old_rec.attribute2
320: ,p_attribute3_o
321: => per_eco_shd.g_old_rec.attribute3

Line 319: => per_eco_shd.g_old_rec.attribute2

315: => per_eco_shd.g_old_rec.attribute_category
316: ,p_attribute1_o
317: => per_eco_shd.g_old_rec.attribute1
318: ,p_attribute2_o
319: => per_eco_shd.g_old_rec.attribute2
320: ,p_attribute3_o
321: => per_eco_shd.g_old_rec.attribute3
322: ,p_attribute4_o
323: => per_eco_shd.g_old_rec.attribute4

Line 321: => per_eco_shd.g_old_rec.attribute3

317: => per_eco_shd.g_old_rec.attribute1
318: ,p_attribute2_o
319: => per_eco_shd.g_old_rec.attribute2
320: ,p_attribute3_o
321: => per_eco_shd.g_old_rec.attribute3
322: ,p_attribute4_o
323: => per_eco_shd.g_old_rec.attribute4
324: ,p_attribute5_o
325: => per_eco_shd.g_old_rec.attribute5

Line 323: => per_eco_shd.g_old_rec.attribute4

319: => per_eco_shd.g_old_rec.attribute2
320: ,p_attribute3_o
321: => per_eco_shd.g_old_rec.attribute3
322: ,p_attribute4_o
323: => per_eco_shd.g_old_rec.attribute4
324: ,p_attribute5_o
325: => per_eco_shd.g_old_rec.attribute5
326: ,p_attribute6_o
327: => per_eco_shd.g_old_rec.attribute6

Line 325: => per_eco_shd.g_old_rec.attribute5

321: => per_eco_shd.g_old_rec.attribute3
322: ,p_attribute4_o
323: => per_eco_shd.g_old_rec.attribute4
324: ,p_attribute5_o
325: => per_eco_shd.g_old_rec.attribute5
326: ,p_attribute6_o
327: => per_eco_shd.g_old_rec.attribute6
328: ,p_attribute7_o
329: => per_eco_shd.g_old_rec.attribute7

Line 327: => per_eco_shd.g_old_rec.attribute6

323: => per_eco_shd.g_old_rec.attribute4
324: ,p_attribute5_o
325: => per_eco_shd.g_old_rec.attribute5
326: ,p_attribute6_o
327: => per_eco_shd.g_old_rec.attribute6
328: ,p_attribute7_o
329: => per_eco_shd.g_old_rec.attribute7
330: ,p_attribute8_o
331: => per_eco_shd.g_old_rec.attribute8

Line 329: => per_eco_shd.g_old_rec.attribute7

325: => per_eco_shd.g_old_rec.attribute5
326: ,p_attribute6_o
327: => per_eco_shd.g_old_rec.attribute6
328: ,p_attribute7_o
329: => per_eco_shd.g_old_rec.attribute7
330: ,p_attribute8_o
331: => per_eco_shd.g_old_rec.attribute8
332: ,p_attribute9_o
333: => per_eco_shd.g_old_rec.attribute9

Line 331: => per_eco_shd.g_old_rec.attribute8

327: => per_eco_shd.g_old_rec.attribute6
328: ,p_attribute7_o
329: => per_eco_shd.g_old_rec.attribute7
330: ,p_attribute8_o
331: => per_eco_shd.g_old_rec.attribute8
332: ,p_attribute9_o
333: => per_eco_shd.g_old_rec.attribute9
334: ,p_attribute10_o
335: => per_eco_shd.g_old_rec.attribute10

Line 333: => per_eco_shd.g_old_rec.attribute9

329: => per_eco_shd.g_old_rec.attribute7
330: ,p_attribute8_o
331: => per_eco_shd.g_old_rec.attribute8
332: ,p_attribute9_o
333: => per_eco_shd.g_old_rec.attribute9
334: ,p_attribute10_o
335: => per_eco_shd.g_old_rec.attribute10
336: ,p_attribute11_o
337: => per_eco_shd.g_old_rec.attribute11

Line 335: => per_eco_shd.g_old_rec.attribute10

331: => per_eco_shd.g_old_rec.attribute8
332: ,p_attribute9_o
333: => per_eco_shd.g_old_rec.attribute9
334: ,p_attribute10_o
335: => per_eco_shd.g_old_rec.attribute10
336: ,p_attribute11_o
337: => per_eco_shd.g_old_rec.attribute11
338: ,p_attribute12_o
339: => per_eco_shd.g_old_rec.attribute12

Line 337: => per_eco_shd.g_old_rec.attribute11

333: => per_eco_shd.g_old_rec.attribute9
334: ,p_attribute10_o
335: => per_eco_shd.g_old_rec.attribute10
336: ,p_attribute11_o
337: => per_eco_shd.g_old_rec.attribute11
338: ,p_attribute12_o
339: => per_eco_shd.g_old_rec.attribute12
340: ,p_attribute13_o
341: => per_eco_shd.g_old_rec.attribute13

Line 339: => per_eco_shd.g_old_rec.attribute12

335: => per_eco_shd.g_old_rec.attribute10
336: ,p_attribute11_o
337: => per_eco_shd.g_old_rec.attribute11
338: ,p_attribute12_o
339: => per_eco_shd.g_old_rec.attribute12
340: ,p_attribute13_o
341: => per_eco_shd.g_old_rec.attribute13
342: ,p_attribute14_o
343: => per_eco_shd.g_old_rec.attribute14

Line 341: => per_eco_shd.g_old_rec.attribute13

337: => per_eco_shd.g_old_rec.attribute11
338: ,p_attribute12_o
339: => per_eco_shd.g_old_rec.attribute12
340: ,p_attribute13_o
341: => per_eco_shd.g_old_rec.attribute13
342: ,p_attribute14_o
343: => per_eco_shd.g_old_rec.attribute14
344: ,p_attribute15_o
345: => per_eco_shd.g_old_rec.attribute15

Line 343: => per_eco_shd.g_old_rec.attribute14

339: => per_eco_shd.g_old_rec.attribute12
340: ,p_attribute13_o
341: => per_eco_shd.g_old_rec.attribute13
342: ,p_attribute14_o
343: => per_eco_shd.g_old_rec.attribute14
344: ,p_attribute15_o
345: => per_eco_shd.g_old_rec.attribute15
346: ,p_attribute16_o
347: => per_eco_shd.g_old_rec.attribute16

Line 345: => per_eco_shd.g_old_rec.attribute15

341: => per_eco_shd.g_old_rec.attribute13
342: ,p_attribute14_o
343: => per_eco_shd.g_old_rec.attribute14
344: ,p_attribute15_o
345: => per_eco_shd.g_old_rec.attribute15
346: ,p_attribute16_o
347: => per_eco_shd.g_old_rec.attribute16
348: ,p_attribute17_o
349: => per_eco_shd.g_old_rec.attribute17

Line 347: => per_eco_shd.g_old_rec.attribute16

343: => per_eco_shd.g_old_rec.attribute14
344: ,p_attribute15_o
345: => per_eco_shd.g_old_rec.attribute15
346: ,p_attribute16_o
347: => per_eco_shd.g_old_rec.attribute16
348: ,p_attribute17_o
349: => per_eco_shd.g_old_rec.attribute17
350: ,p_attribute18_o
351: => per_eco_shd.g_old_rec.attribute18

Line 349: => per_eco_shd.g_old_rec.attribute17

345: => per_eco_shd.g_old_rec.attribute15
346: ,p_attribute16_o
347: => per_eco_shd.g_old_rec.attribute16
348: ,p_attribute17_o
349: => per_eco_shd.g_old_rec.attribute17
350: ,p_attribute18_o
351: => per_eco_shd.g_old_rec.attribute18
352: ,p_attribute19_o
353: => per_eco_shd.g_old_rec.attribute19

Line 351: => per_eco_shd.g_old_rec.attribute18

347: => per_eco_shd.g_old_rec.attribute16
348: ,p_attribute17_o
349: => per_eco_shd.g_old_rec.attribute17
350: ,p_attribute18_o
351: => per_eco_shd.g_old_rec.attribute18
352: ,p_attribute19_o
353: => per_eco_shd.g_old_rec.attribute19
354: ,p_attribute20_o
355: => per_eco_shd.g_old_rec.attribute20

Line 353: => per_eco_shd.g_old_rec.attribute19

349: => per_eco_shd.g_old_rec.attribute17
350: ,p_attribute18_o
351: => per_eco_shd.g_old_rec.attribute18
352: ,p_attribute19_o
353: => per_eco_shd.g_old_rec.attribute19
354: ,p_attribute20_o
355: => per_eco_shd.g_old_rec.attribute20
356: ,p_attribute21_o
357: => per_eco_shd.g_old_rec.attribute21

Line 355: => per_eco_shd.g_old_rec.attribute20

351: => per_eco_shd.g_old_rec.attribute18
352: ,p_attribute19_o
353: => per_eco_shd.g_old_rec.attribute19
354: ,p_attribute20_o
355: => per_eco_shd.g_old_rec.attribute20
356: ,p_attribute21_o
357: => per_eco_shd.g_old_rec.attribute21
358: ,p_attribute22_o
359: => per_eco_shd.g_old_rec.attribute22

Line 357: => per_eco_shd.g_old_rec.attribute21

353: => per_eco_shd.g_old_rec.attribute19
354: ,p_attribute20_o
355: => per_eco_shd.g_old_rec.attribute20
356: ,p_attribute21_o
357: => per_eco_shd.g_old_rec.attribute21
358: ,p_attribute22_o
359: => per_eco_shd.g_old_rec.attribute22
360: ,p_attribute23_o
361: => per_eco_shd.g_old_rec.attribute23

Line 359: => per_eco_shd.g_old_rec.attribute22

355: => per_eco_shd.g_old_rec.attribute20
356: ,p_attribute21_o
357: => per_eco_shd.g_old_rec.attribute21
358: ,p_attribute22_o
359: => per_eco_shd.g_old_rec.attribute22
360: ,p_attribute23_o
361: => per_eco_shd.g_old_rec.attribute23
362: ,p_attribute24_o
363: => per_eco_shd.g_old_rec.attribute24

Line 361: => per_eco_shd.g_old_rec.attribute23

357: => per_eco_shd.g_old_rec.attribute21
358: ,p_attribute22_o
359: => per_eco_shd.g_old_rec.attribute22
360: ,p_attribute23_o
361: => per_eco_shd.g_old_rec.attribute23
362: ,p_attribute24_o
363: => per_eco_shd.g_old_rec.attribute24
364: ,p_attribute25_o
365: => per_eco_shd.g_old_rec.attribute25

Line 363: => per_eco_shd.g_old_rec.attribute24

359: => per_eco_shd.g_old_rec.attribute22
360: ,p_attribute23_o
361: => per_eco_shd.g_old_rec.attribute23
362: ,p_attribute24_o
363: => per_eco_shd.g_old_rec.attribute24
364: ,p_attribute25_o
365: => per_eco_shd.g_old_rec.attribute25
366: ,p_attribute26_o
367: => per_eco_shd.g_old_rec.attribute26

Line 365: => per_eco_shd.g_old_rec.attribute25

361: => per_eco_shd.g_old_rec.attribute23
362: ,p_attribute24_o
363: => per_eco_shd.g_old_rec.attribute24
364: ,p_attribute25_o
365: => per_eco_shd.g_old_rec.attribute25
366: ,p_attribute26_o
367: => per_eco_shd.g_old_rec.attribute26
368: ,p_attribute27_o
369: => per_eco_shd.g_old_rec.attribute27

Line 367: => per_eco_shd.g_old_rec.attribute26

363: => per_eco_shd.g_old_rec.attribute24
364: ,p_attribute25_o
365: => per_eco_shd.g_old_rec.attribute25
366: ,p_attribute26_o
367: => per_eco_shd.g_old_rec.attribute26
368: ,p_attribute27_o
369: => per_eco_shd.g_old_rec.attribute27
370: ,p_attribute28_o
371: => per_eco_shd.g_old_rec.attribute28

Line 369: => per_eco_shd.g_old_rec.attribute27

365: => per_eco_shd.g_old_rec.attribute25
366: ,p_attribute26_o
367: => per_eco_shd.g_old_rec.attribute26
368: ,p_attribute27_o
369: => per_eco_shd.g_old_rec.attribute27
370: ,p_attribute28_o
371: => per_eco_shd.g_old_rec.attribute28
372: ,p_attribute29_o
373: => per_eco_shd.g_old_rec.attribute29

Line 371: => per_eco_shd.g_old_rec.attribute28

367: => per_eco_shd.g_old_rec.attribute26
368: ,p_attribute27_o
369: => per_eco_shd.g_old_rec.attribute27
370: ,p_attribute28_o
371: => per_eco_shd.g_old_rec.attribute28
372: ,p_attribute29_o
373: => per_eco_shd.g_old_rec.attribute29
374: ,p_attribute30_o
375: => per_eco_shd.g_old_rec.attribute30

Line 373: => per_eco_shd.g_old_rec.attribute29

369: => per_eco_shd.g_old_rec.attribute27
370: ,p_attribute28_o
371: => per_eco_shd.g_old_rec.attribute28
372: ,p_attribute29_o
373: => per_eco_shd.g_old_rec.attribute29
374: ,p_attribute30_o
375: => per_eco_shd.g_old_rec.attribute30
376: ,p_object_version_number_o
377: => per_eco_shd.g_old_rec.object_version_number

Line 375: => per_eco_shd.g_old_rec.attribute30

371: => per_eco_shd.g_old_rec.attribute28
372: ,p_attribute29_o
373: => per_eco_shd.g_old_rec.attribute29
374: ,p_attribute30_o
375: => per_eco_shd.g_old_rec.attribute30
376: ,p_object_version_number_o
377: => per_eco_shd.g_old_rec.object_version_number
378: );
379: --

Line 377: => per_eco_shd.g_old_rec.object_version_number

373: => per_eco_shd.g_old_rec.attribute29
374: ,p_attribute30_o
375: => per_eco_shd.g_old_rec.attribute30
376: ,p_object_version_number_o
377: => per_eco_shd.g_old_rec.object_version_number
378: );
379: --
380: exception
381: --

Line 437: (p_rec in out nocopy per_eco_shd.g_rec_type

433: --
434: -- {End Of Comments}
435: -- ----------------------------------------------------------------------------
436: Procedure convert_defs
437: (p_rec in out nocopy per_eco_shd.g_rec_type
438: ) is
439: --
440: Begin
441: --

Line 449: per_eco_shd.g_old_rec.election_id;

445: -- is being used then we must set to the 'current' argument value.
446: --
447: If (p_rec.election_id = hr_api.g_number) then
448: p_rec.election_id :=
449: per_eco_shd.g_old_rec.election_id;
450: End If;
451: If (p_rec.business_group_id = hr_api.g_number) then
452: p_rec.business_group_id :=
453: per_eco_shd.g_old_rec.business_group_id;

Line 453: per_eco_shd.g_old_rec.business_group_id;

449: per_eco_shd.g_old_rec.election_id;
450: End If;
451: If (p_rec.business_group_id = hr_api.g_number) then
452: p_rec.business_group_id :=
453: per_eco_shd.g_old_rec.business_group_id;
454: End If;
455: If (p_rec.constituency_id = hr_api.g_number) then
456: p_rec.constituency_id :=
457: per_eco_shd.g_old_rec.constituency_id;

Line 457: per_eco_shd.g_old_rec.constituency_id;

453: per_eco_shd.g_old_rec.business_group_id;
454: End If;
455: If (p_rec.constituency_id = hr_api.g_number) then
456: p_rec.constituency_id :=
457: per_eco_shd.g_old_rec.constituency_id;
458: End If;
459: If (p_rec.attribute_category = hr_api.g_varchar2) then
460: p_rec.attribute_category :=
461: per_eco_shd.g_old_rec.attribute_category;

Line 461: per_eco_shd.g_old_rec.attribute_category;

457: per_eco_shd.g_old_rec.constituency_id;
458: End If;
459: If (p_rec.attribute_category = hr_api.g_varchar2) then
460: p_rec.attribute_category :=
461: per_eco_shd.g_old_rec.attribute_category;
462: End If;
463: If (p_rec.attribute1 = hr_api.g_varchar2) then
464: p_rec.attribute1 :=
465: per_eco_shd.g_old_rec.attribute1;

Line 465: per_eco_shd.g_old_rec.attribute1;

461: per_eco_shd.g_old_rec.attribute_category;
462: End If;
463: If (p_rec.attribute1 = hr_api.g_varchar2) then
464: p_rec.attribute1 :=
465: per_eco_shd.g_old_rec.attribute1;
466: End If;
467: If (p_rec.attribute2 = hr_api.g_varchar2) then
468: p_rec.attribute2 :=
469: per_eco_shd.g_old_rec.attribute2;

Line 469: per_eco_shd.g_old_rec.attribute2;

465: per_eco_shd.g_old_rec.attribute1;
466: End If;
467: If (p_rec.attribute2 = hr_api.g_varchar2) then
468: p_rec.attribute2 :=
469: per_eco_shd.g_old_rec.attribute2;
470: End If;
471: If (p_rec.attribute3 = hr_api.g_varchar2) then
472: p_rec.attribute3 :=
473: per_eco_shd.g_old_rec.attribute3;

Line 473: per_eco_shd.g_old_rec.attribute3;

469: per_eco_shd.g_old_rec.attribute2;
470: End If;
471: If (p_rec.attribute3 = hr_api.g_varchar2) then
472: p_rec.attribute3 :=
473: per_eco_shd.g_old_rec.attribute3;
474: End If;
475: If (p_rec.attribute4 = hr_api.g_varchar2) then
476: p_rec.attribute4 :=
477: per_eco_shd.g_old_rec.attribute4;

Line 477: per_eco_shd.g_old_rec.attribute4;

473: per_eco_shd.g_old_rec.attribute3;
474: End If;
475: If (p_rec.attribute4 = hr_api.g_varchar2) then
476: p_rec.attribute4 :=
477: per_eco_shd.g_old_rec.attribute4;
478: End If;
479: If (p_rec.attribute5 = hr_api.g_varchar2) then
480: p_rec.attribute5 :=
481: per_eco_shd.g_old_rec.attribute5;

Line 481: per_eco_shd.g_old_rec.attribute5;

477: per_eco_shd.g_old_rec.attribute4;
478: End If;
479: If (p_rec.attribute5 = hr_api.g_varchar2) then
480: p_rec.attribute5 :=
481: per_eco_shd.g_old_rec.attribute5;
482: End If;
483: If (p_rec.attribute6 = hr_api.g_varchar2) then
484: p_rec.attribute6 :=
485: per_eco_shd.g_old_rec.attribute6;

Line 485: per_eco_shd.g_old_rec.attribute6;

481: per_eco_shd.g_old_rec.attribute5;
482: End If;
483: If (p_rec.attribute6 = hr_api.g_varchar2) then
484: p_rec.attribute6 :=
485: per_eco_shd.g_old_rec.attribute6;
486: End If;
487: If (p_rec.attribute7 = hr_api.g_varchar2) then
488: p_rec.attribute7 :=
489: per_eco_shd.g_old_rec.attribute7;

Line 489: per_eco_shd.g_old_rec.attribute7;

485: per_eco_shd.g_old_rec.attribute6;
486: End If;
487: If (p_rec.attribute7 = hr_api.g_varchar2) then
488: p_rec.attribute7 :=
489: per_eco_shd.g_old_rec.attribute7;
490: End If;
491: If (p_rec.attribute8 = hr_api.g_varchar2) then
492: p_rec.attribute8 :=
493: per_eco_shd.g_old_rec.attribute8;

Line 493: per_eco_shd.g_old_rec.attribute8;

489: per_eco_shd.g_old_rec.attribute7;
490: End If;
491: If (p_rec.attribute8 = hr_api.g_varchar2) then
492: p_rec.attribute8 :=
493: per_eco_shd.g_old_rec.attribute8;
494: End If;
495: If (p_rec.attribute9 = hr_api.g_varchar2) then
496: p_rec.attribute9 :=
497: per_eco_shd.g_old_rec.attribute9;

Line 497: per_eco_shd.g_old_rec.attribute9;

493: per_eco_shd.g_old_rec.attribute8;
494: End If;
495: If (p_rec.attribute9 = hr_api.g_varchar2) then
496: p_rec.attribute9 :=
497: per_eco_shd.g_old_rec.attribute9;
498: End If;
499: If (p_rec.attribute10 = hr_api.g_varchar2) then
500: p_rec.attribute10 :=
501: per_eco_shd.g_old_rec.attribute10;

Line 501: per_eco_shd.g_old_rec.attribute10;

497: per_eco_shd.g_old_rec.attribute9;
498: End If;
499: If (p_rec.attribute10 = hr_api.g_varchar2) then
500: p_rec.attribute10 :=
501: per_eco_shd.g_old_rec.attribute10;
502: End If;
503: If (p_rec.attribute11 = hr_api.g_varchar2) then
504: p_rec.attribute11 :=
505: per_eco_shd.g_old_rec.attribute11;

Line 505: per_eco_shd.g_old_rec.attribute11;

501: per_eco_shd.g_old_rec.attribute10;
502: End If;
503: If (p_rec.attribute11 = hr_api.g_varchar2) then
504: p_rec.attribute11 :=
505: per_eco_shd.g_old_rec.attribute11;
506: End If;
507: If (p_rec.attribute12 = hr_api.g_varchar2) then
508: p_rec.attribute12 :=
509: per_eco_shd.g_old_rec.attribute12;

Line 509: per_eco_shd.g_old_rec.attribute12;

505: per_eco_shd.g_old_rec.attribute11;
506: End If;
507: If (p_rec.attribute12 = hr_api.g_varchar2) then
508: p_rec.attribute12 :=
509: per_eco_shd.g_old_rec.attribute12;
510: End If;
511: If (p_rec.attribute13 = hr_api.g_varchar2) then
512: p_rec.attribute13 :=
513: per_eco_shd.g_old_rec.attribute13;

Line 513: per_eco_shd.g_old_rec.attribute13;

509: per_eco_shd.g_old_rec.attribute12;
510: End If;
511: If (p_rec.attribute13 = hr_api.g_varchar2) then
512: p_rec.attribute13 :=
513: per_eco_shd.g_old_rec.attribute13;
514: End If;
515: If (p_rec.attribute14 = hr_api.g_varchar2) then
516: p_rec.attribute14 :=
517: per_eco_shd.g_old_rec.attribute14;

Line 517: per_eco_shd.g_old_rec.attribute14;

513: per_eco_shd.g_old_rec.attribute13;
514: End If;
515: If (p_rec.attribute14 = hr_api.g_varchar2) then
516: p_rec.attribute14 :=
517: per_eco_shd.g_old_rec.attribute14;
518: End If;
519: If (p_rec.attribute15 = hr_api.g_varchar2) then
520: p_rec.attribute15 :=
521: per_eco_shd.g_old_rec.attribute15;

Line 521: per_eco_shd.g_old_rec.attribute15;

517: per_eco_shd.g_old_rec.attribute14;
518: End If;
519: If (p_rec.attribute15 = hr_api.g_varchar2) then
520: p_rec.attribute15 :=
521: per_eco_shd.g_old_rec.attribute15;
522: End If;
523: If (p_rec.attribute16 = hr_api.g_varchar2) then
524: p_rec.attribute16 :=
525: per_eco_shd.g_old_rec.attribute16;

Line 525: per_eco_shd.g_old_rec.attribute16;

521: per_eco_shd.g_old_rec.attribute15;
522: End If;
523: If (p_rec.attribute16 = hr_api.g_varchar2) then
524: p_rec.attribute16 :=
525: per_eco_shd.g_old_rec.attribute16;
526: End If;
527: If (p_rec.attribute17 = hr_api.g_varchar2) then
528: p_rec.attribute17 :=
529: per_eco_shd.g_old_rec.attribute17;

Line 529: per_eco_shd.g_old_rec.attribute17;

525: per_eco_shd.g_old_rec.attribute16;
526: End If;
527: If (p_rec.attribute17 = hr_api.g_varchar2) then
528: p_rec.attribute17 :=
529: per_eco_shd.g_old_rec.attribute17;
530: End If;
531: If (p_rec.attribute18 = hr_api.g_varchar2) then
532: p_rec.attribute18 :=
533: per_eco_shd.g_old_rec.attribute18;

Line 533: per_eco_shd.g_old_rec.attribute18;

529: per_eco_shd.g_old_rec.attribute17;
530: End If;
531: If (p_rec.attribute18 = hr_api.g_varchar2) then
532: p_rec.attribute18 :=
533: per_eco_shd.g_old_rec.attribute18;
534: End If;
535: If (p_rec.attribute19 = hr_api.g_varchar2) then
536: p_rec.attribute19 :=
537: per_eco_shd.g_old_rec.attribute19;

Line 537: per_eco_shd.g_old_rec.attribute19;

533: per_eco_shd.g_old_rec.attribute18;
534: End If;
535: If (p_rec.attribute19 = hr_api.g_varchar2) then
536: p_rec.attribute19 :=
537: per_eco_shd.g_old_rec.attribute19;
538: End If;
539: If (p_rec.attribute20 = hr_api.g_varchar2) then
540: p_rec.attribute20 :=
541: per_eco_shd.g_old_rec.attribute20;

Line 541: per_eco_shd.g_old_rec.attribute20;

537: per_eco_shd.g_old_rec.attribute19;
538: End If;
539: If (p_rec.attribute20 = hr_api.g_varchar2) then
540: p_rec.attribute20 :=
541: per_eco_shd.g_old_rec.attribute20;
542: End If;
543: If (p_rec.attribute21 = hr_api.g_varchar2) then
544: p_rec.attribute21 :=
545: per_eco_shd.g_old_rec.attribute21;

Line 545: per_eco_shd.g_old_rec.attribute21;

541: per_eco_shd.g_old_rec.attribute20;
542: End If;
543: If (p_rec.attribute21 = hr_api.g_varchar2) then
544: p_rec.attribute21 :=
545: per_eco_shd.g_old_rec.attribute21;
546: End If;
547: If (p_rec.attribute22 = hr_api.g_varchar2) then
548: p_rec.attribute22 :=
549: per_eco_shd.g_old_rec.attribute22;

Line 549: per_eco_shd.g_old_rec.attribute22;

545: per_eco_shd.g_old_rec.attribute21;
546: End If;
547: If (p_rec.attribute22 = hr_api.g_varchar2) then
548: p_rec.attribute22 :=
549: per_eco_shd.g_old_rec.attribute22;
550: End If;
551: If (p_rec.attribute23 = hr_api.g_varchar2) then
552: p_rec.attribute23 :=
553: per_eco_shd.g_old_rec.attribute23;

Line 553: per_eco_shd.g_old_rec.attribute23;

549: per_eco_shd.g_old_rec.attribute22;
550: End If;
551: If (p_rec.attribute23 = hr_api.g_varchar2) then
552: p_rec.attribute23 :=
553: per_eco_shd.g_old_rec.attribute23;
554: End If;
555: If (p_rec.attribute24 = hr_api.g_varchar2) then
556: p_rec.attribute24 :=
557: per_eco_shd.g_old_rec.attribute24;

Line 557: per_eco_shd.g_old_rec.attribute24;

553: per_eco_shd.g_old_rec.attribute23;
554: End If;
555: If (p_rec.attribute24 = hr_api.g_varchar2) then
556: p_rec.attribute24 :=
557: per_eco_shd.g_old_rec.attribute24;
558: End If;
559: If (p_rec.attribute25 = hr_api.g_varchar2) then
560: p_rec.attribute25 :=
561: per_eco_shd.g_old_rec.attribute25;

Line 561: per_eco_shd.g_old_rec.attribute25;

557: per_eco_shd.g_old_rec.attribute24;
558: End If;
559: If (p_rec.attribute25 = hr_api.g_varchar2) then
560: p_rec.attribute25 :=
561: per_eco_shd.g_old_rec.attribute25;
562: End If;
563: If (p_rec.attribute26 = hr_api.g_varchar2) then
564: p_rec.attribute26 :=
565: per_eco_shd.g_old_rec.attribute26;

Line 565: per_eco_shd.g_old_rec.attribute26;

561: per_eco_shd.g_old_rec.attribute25;
562: End If;
563: If (p_rec.attribute26 = hr_api.g_varchar2) then
564: p_rec.attribute26 :=
565: per_eco_shd.g_old_rec.attribute26;
566: End If;
567: If (p_rec.attribute27 = hr_api.g_varchar2) then
568: p_rec.attribute27 :=
569: per_eco_shd.g_old_rec.attribute27;

Line 569: per_eco_shd.g_old_rec.attribute27;

565: per_eco_shd.g_old_rec.attribute26;
566: End If;
567: If (p_rec.attribute27 = hr_api.g_varchar2) then
568: p_rec.attribute27 :=
569: per_eco_shd.g_old_rec.attribute27;
570: End If;
571: If (p_rec.attribute28 = hr_api.g_varchar2) then
572: p_rec.attribute28 :=
573: per_eco_shd.g_old_rec.attribute28;

Line 573: per_eco_shd.g_old_rec.attribute28;

569: per_eco_shd.g_old_rec.attribute27;
570: End If;
571: If (p_rec.attribute28 = hr_api.g_varchar2) then
572: p_rec.attribute28 :=
573: per_eco_shd.g_old_rec.attribute28;
574: End If;
575: If (p_rec.attribute29 = hr_api.g_varchar2) then
576: p_rec.attribute29 :=
577: per_eco_shd.g_old_rec.attribute29;

Line 577: per_eco_shd.g_old_rec.attribute29;

573: per_eco_shd.g_old_rec.attribute28;
574: End If;
575: If (p_rec.attribute29 = hr_api.g_varchar2) then
576: p_rec.attribute29 :=
577: per_eco_shd.g_old_rec.attribute29;
578: End If;
579: If (p_rec.attribute30 = hr_api.g_varchar2) then
580: p_rec.attribute30 :=
581: per_eco_shd.g_old_rec.attribute30;

Line 581: per_eco_shd.g_old_rec.attribute30;

577: per_eco_shd.g_old_rec.attribute29;
578: End If;
579: If (p_rec.attribute30 = hr_api.g_varchar2) then
580: p_rec.attribute30 :=
581: per_eco_shd.g_old_rec.attribute30;
582: End If;
583: --
584: End convert_defs;
585: --

Line 592: ,p_rec in out nocopy per_eco_shd.g_rec_type

588: -- ----------------------------------------------------------------------------
589: Procedure upd
590: (p_effective_date in date
591: ,p_validate in boolean default false
592: ,p_rec in out nocopy per_eco_shd.g_rec_type
593: ) is
594: --
595: l_proc varchar2(72) := g_package||'upd';
596: --

Line 611: per_eco_shd.lck

607: End If;
608: --
609: -- We must lock the row which we need to update.
610: --
611: per_eco_shd.lck
612: (p_rec.election_constituency_id
613: ,p_rec.object_version_number
614: );
615: --

Line 704: l_rec per_eco_shd.g_rec_type;

700: ,p_attribute29 in varchar2 default hr_api.g_varchar2
701: ,p_attribute30 in varchar2 default hr_api.g_varchar2
702: ) is
703: --
704: l_rec per_eco_shd.g_rec_type;
705: l_proc varchar2(72) := g_package||'upd';
706: --
707: Begin
708: hr_utility.set_location('Entering:'||l_proc, 5);

Line 714: per_eco_shd.convert_args

710: -- Call conversion function to turn arguments into the
711: -- l_rec structure.
712: --
713: l_rec :=
714: per_eco_shd.convert_args
715: (p_election_constituency_id
716: ,p_election_id
717: ,p_business_group_id
718: ,p_constituency_id