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_ESA_UPD dependencies on PER_ESA_SHD

Line 54: Procedure update_dml(p_rec in out nocopy per_esa_shd.g_rec_type) is

50: -- Internal Table Handler Use Only.
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml(p_rec in out nocopy per_esa_shd.g_rec_type) is
55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin

Line 65: per_esa_shd.g_api_dml := true; -- Set the api dml status

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

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

101: party_id = p_rec.party_id, -- HR/TCA merge
102: address = p_rec.address
103: where attendance_id = p_rec.attendance_id;
104: --
105: per_esa_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_esa_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_esa_shd.g_api_dml := false; -- Unset the api dml status
113: per_esa_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_esa_shd.constraint_error

109: Exception
110: When hr_api.check_integrity_violated Then
111: -- A check constraint has been violated
112: per_esa_shd.g_api_dml := false; -- Unset the api dml status
113: per_esa_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_esa_shd.g_api_dml := false; -- Unset the api dml status

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

113: per_esa_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_esa_shd.g_api_dml := false; -- Unset the api dml status
118: per_esa_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_esa_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_esa_shd.g_api_dml := false; -- Unset the api dml status
118: per_esa_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_esa_shd.g_api_dml := false; -- Unset the api dml status

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

118: per_esa_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_esa_shd.g_api_dml := false; -- Unset the api dml status
123: per_esa_shd.constraint_error
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
125: When Others Then
126: per_esa_shd.g_api_dml := false; -- Unset the api dml status

Line 123: per_esa_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_esa_shd.g_api_dml := false; -- Unset the api dml status
123: per_esa_shd.constraint_error
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
125: When Others Then
126: per_esa_shd.g_api_dml := false; -- Unset the api dml status
127: Raise;

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

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

Line 162: Procedure pre_update(p_rec in per_esa_shd.g_rec_type) is

158: -- Internal Table Handler Use Only.
159: --
160: -- {End Of Comments}
161: -- ----------------------------------------------------------------------------
162: Procedure pre_update(p_rec in per_esa_shd.g_rec_type) is
163: --
164: l_proc varchar2(72) := g_package||'pre_update';
165: --
166: Begin

Line 204: Procedure post_update(p_rec in per_esa_shd.g_rec_type,

200: -- Internal Table Handler Use Only.
201: --
202: -- {End Of Comments}
203: -- ----------------------------------------------------------------------------
204: Procedure post_update(p_rec in per_esa_shd.g_rec_type,
205: p_effective_date in date
206: ) is
207: --
208: l_proc varchar2(72) := g_package||'post_update';

Line 250: p_person_id_o =>per_esa_shd.g_old_rec.person_id,

246: p_business_group_id =>p_rec.business_group_id,
247: p_effective_date =>p_effective_date,
248: p_party_id =>p_rec.party_id, -- HR/TCA merge
249: p_address =>p_rec.address,
250: p_person_id_o =>per_esa_shd.g_old_rec.person_id,
251: p_establishment_id_o =>per_esa_shd.g_old_rec.establishment_id,
252: p_establishment_o =>per_esa_shd.g_old_rec.establishment,
253: p_attended_start_date_o =>per_esa_shd.g_old_rec.attended_start_date,
254: p_attended_end_date_o =>per_esa_shd.g_old_rec.attended_end_date,

Line 251: p_establishment_id_o =>per_esa_shd.g_old_rec.establishment_id,

247: p_effective_date =>p_effective_date,
248: p_party_id =>p_rec.party_id, -- HR/TCA merge
249: p_address =>p_rec.address,
250: p_person_id_o =>per_esa_shd.g_old_rec.person_id,
251: p_establishment_id_o =>per_esa_shd.g_old_rec.establishment_id,
252: p_establishment_o =>per_esa_shd.g_old_rec.establishment,
253: p_attended_start_date_o =>per_esa_shd.g_old_rec.attended_start_date,
254: p_attended_end_date_o =>per_esa_shd.g_old_rec.attended_end_date,
255: p_full_time_o =>per_esa_shd.g_old_rec.full_time,

Line 252: p_establishment_o =>per_esa_shd.g_old_rec.establishment,

248: p_party_id =>p_rec.party_id, -- HR/TCA merge
249: p_address =>p_rec.address,
250: p_person_id_o =>per_esa_shd.g_old_rec.person_id,
251: p_establishment_id_o =>per_esa_shd.g_old_rec.establishment_id,
252: p_establishment_o =>per_esa_shd.g_old_rec.establishment,
253: p_attended_start_date_o =>per_esa_shd.g_old_rec.attended_start_date,
254: p_attended_end_date_o =>per_esa_shd.g_old_rec.attended_end_date,
255: p_full_time_o =>per_esa_shd.g_old_rec.full_time,
256: p_attribute_category_o =>per_esa_shd.g_old_rec.attribute_category,

Line 253: p_attended_start_date_o =>per_esa_shd.g_old_rec.attended_start_date,

249: p_address =>p_rec.address,
250: p_person_id_o =>per_esa_shd.g_old_rec.person_id,
251: p_establishment_id_o =>per_esa_shd.g_old_rec.establishment_id,
252: p_establishment_o =>per_esa_shd.g_old_rec.establishment,
253: p_attended_start_date_o =>per_esa_shd.g_old_rec.attended_start_date,
254: p_attended_end_date_o =>per_esa_shd.g_old_rec.attended_end_date,
255: p_full_time_o =>per_esa_shd.g_old_rec.full_time,
256: p_attribute_category_o =>per_esa_shd.g_old_rec.attribute_category,
257: p_attribute1_o =>per_esa_shd.g_old_rec.attribute1,

Line 254: p_attended_end_date_o =>per_esa_shd.g_old_rec.attended_end_date,

250: p_person_id_o =>per_esa_shd.g_old_rec.person_id,
251: p_establishment_id_o =>per_esa_shd.g_old_rec.establishment_id,
252: p_establishment_o =>per_esa_shd.g_old_rec.establishment,
253: p_attended_start_date_o =>per_esa_shd.g_old_rec.attended_start_date,
254: p_attended_end_date_o =>per_esa_shd.g_old_rec.attended_end_date,
255: p_full_time_o =>per_esa_shd.g_old_rec.full_time,
256: p_attribute_category_o =>per_esa_shd.g_old_rec.attribute_category,
257: p_attribute1_o =>per_esa_shd.g_old_rec.attribute1,
258: p_attribute2_o =>per_esa_shd.g_old_rec.attribute2,

Line 255: p_full_time_o =>per_esa_shd.g_old_rec.full_time,

251: p_establishment_id_o =>per_esa_shd.g_old_rec.establishment_id,
252: p_establishment_o =>per_esa_shd.g_old_rec.establishment,
253: p_attended_start_date_o =>per_esa_shd.g_old_rec.attended_start_date,
254: p_attended_end_date_o =>per_esa_shd.g_old_rec.attended_end_date,
255: p_full_time_o =>per_esa_shd.g_old_rec.full_time,
256: p_attribute_category_o =>per_esa_shd.g_old_rec.attribute_category,
257: p_attribute1_o =>per_esa_shd.g_old_rec.attribute1,
258: p_attribute2_o =>per_esa_shd.g_old_rec.attribute2,
259: p_attribute3_o =>per_esa_shd.g_old_rec.attribute3,

Line 256: p_attribute_category_o =>per_esa_shd.g_old_rec.attribute_category,

252: p_establishment_o =>per_esa_shd.g_old_rec.establishment,
253: p_attended_start_date_o =>per_esa_shd.g_old_rec.attended_start_date,
254: p_attended_end_date_o =>per_esa_shd.g_old_rec.attended_end_date,
255: p_full_time_o =>per_esa_shd.g_old_rec.full_time,
256: p_attribute_category_o =>per_esa_shd.g_old_rec.attribute_category,
257: p_attribute1_o =>per_esa_shd.g_old_rec.attribute1,
258: p_attribute2_o =>per_esa_shd.g_old_rec.attribute2,
259: p_attribute3_o =>per_esa_shd.g_old_rec.attribute3,
260: p_attribute4_o =>per_esa_shd.g_old_rec.attribute4,

Line 257: p_attribute1_o =>per_esa_shd.g_old_rec.attribute1,

253: p_attended_start_date_o =>per_esa_shd.g_old_rec.attended_start_date,
254: p_attended_end_date_o =>per_esa_shd.g_old_rec.attended_end_date,
255: p_full_time_o =>per_esa_shd.g_old_rec.full_time,
256: p_attribute_category_o =>per_esa_shd.g_old_rec.attribute_category,
257: p_attribute1_o =>per_esa_shd.g_old_rec.attribute1,
258: p_attribute2_o =>per_esa_shd.g_old_rec.attribute2,
259: p_attribute3_o =>per_esa_shd.g_old_rec.attribute3,
260: p_attribute4_o =>per_esa_shd.g_old_rec.attribute4,
261: p_attribute5_o =>per_esa_shd.g_old_rec.attribute5,

Line 258: p_attribute2_o =>per_esa_shd.g_old_rec.attribute2,

254: p_attended_end_date_o =>per_esa_shd.g_old_rec.attended_end_date,
255: p_full_time_o =>per_esa_shd.g_old_rec.full_time,
256: p_attribute_category_o =>per_esa_shd.g_old_rec.attribute_category,
257: p_attribute1_o =>per_esa_shd.g_old_rec.attribute1,
258: p_attribute2_o =>per_esa_shd.g_old_rec.attribute2,
259: p_attribute3_o =>per_esa_shd.g_old_rec.attribute3,
260: p_attribute4_o =>per_esa_shd.g_old_rec.attribute4,
261: p_attribute5_o =>per_esa_shd.g_old_rec.attribute5,
262: p_attribute6_o =>per_esa_shd.g_old_rec.attribute6,

Line 259: p_attribute3_o =>per_esa_shd.g_old_rec.attribute3,

255: p_full_time_o =>per_esa_shd.g_old_rec.full_time,
256: p_attribute_category_o =>per_esa_shd.g_old_rec.attribute_category,
257: p_attribute1_o =>per_esa_shd.g_old_rec.attribute1,
258: p_attribute2_o =>per_esa_shd.g_old_rec.attribute2,
259: p_attribute3_o =>per_esa_shd.g_old_rec.attribute3,
260: p_attribute4_o =>per_esa_shd.g_old_rec.attribute4,
261: p_attribute5_o =>per_esa_shd.g_old_rec.attribute5,
262: p_attribute6_o =>per_esa_shd.g_old_rec.attribute6,
263: p_attribute7_o =>per_esa_shd.g_old_rec.attribute7,

Line 260: p_attribute4_o =>per_esa_shd.g_old_rec.attribute4,

256: p_attribute_category_o =>per_esa_shd.g_old_rec.attribute_category,
257: p_attribute1_o =>per_esa_shd.g_old_rec.attribute1,
258: p_attribute2_o =>per_esa_shd.g_old_rec.attribute2,
259: p_attribute3_o =>per_esa_shd.g_old_rec.attribute3,
260: p_attribute4_o =>per_esa_shd.g_old_rec.attribute4,
261: p_attribute5_o =>per_esa_shd.g_old_rec.attribute5,
262: p_attribute6_o =>per_esa_shd.g_old_rec.attribute6,
263: p_attribute7_o =>per_esa_shd.g_old_rec.attribute7,
264: p_attribute8_o =>per_esa_shd.g_old_rec.attribute8,

Line 261: p_attribute5_o =>per_esa_shd.g_old_rec.attribute5,

257: p_attribute1_o =>per_esa_shd.g_old_rec.attribute1,
258: p_attribute2_o =>per_esa_shd.g_old_rec.attribute2,
259: p_attribute3_o =>per_esa_shd.g_old_rec.attribute3,
260: p_attribute4_o =>per_esa_shd.g_old_rec.attribute4,
261: p_attribute5_o =>per_esa_shd.g_old_rec.attribute5,
262: p_attribute6_o =>per_esa_shd.g_old_rec.attribute6,
263: p_attribute7_o =>per_esa_shd.g_old_rec.attribute7,
264: p_attribute8_o =>per_esa_shd.g_old_rec.attribute8,
265: p_attribute9_o =>per_esa_shd.g_old_rec.attribute9,

Line 262: p_attribute6_o =>per_esa_shd.g_old_rec.attribute6,

258: p_attribute2_o =>per_esa_shd.g_old_rec.attribute2,
259: p_attribute3_o =>per_esa_shd.g_old_rec.attribute3,
260: p_attribute4_o =>per_esa_shd.g_old_rec.attribute4,
261: p_attribute5_o =>per_esa_shd.g_old_rec.attribute5,
262: p_attribute6_o =>per_esa_shd.g_old_rec.attribute6,
263: p_attribute7_o =>per_esa_shd.g_old_rec.attribute7,
264: p_attribute8_o =>per_esa_shd.g_old_rec.attribute8,
265: p_attribute9_o =>per_esa_shd.g_old_rec.attribute9,
266: p_attribute10_o =>per_esa_shd.g_old_rec.attribute10,

Line 263: p_attribute7_o =>per_esa_shd.g_old_rec.attribute7,

259: p_attribute3_o =>per_esa_shd.g_old_rec.attribute3,
260: p_attribute4_o =>per_esa_shd.g_old_rec.attribute4,
261: p_attribute5_o =>per_esa_shd.g_old_rec.attribute5,
262: p_attribute6_o =>per_esa_shd.g_old_rec.attribute6,
263: p_attribute7_o =>per_esa_shd.g_old_rec.attribute7,
264: p_attribute8_o =>per_esa_shd.g_old_rec.attribute8,
265: p_attribute9_o =>per_esa_shd.g_old_rec.attribute9,
266: p_attribute10_o =>per_esa_shd.g_old_rec.attribute10,
267: p_attribute11_o =>per_esa_shd.g_old_rec.attribute11,

Line 264: p_attribute8_o =>per_esa_shd.g_old_rec.attribute8,

260: p_attribute4_o =>per_esa_shd.g_old_rec.attribute4,
261: p_attribute5_o =>per_esa_shd.g_old_rec.attribute5,
262: p_attribute6_o =>per_esa_shd.g_old_rec.attribute6,
263: p_attribute7_o =>per_esa_shd.g_old_rec.attribute7,
264: p_attribute8_o =>per_esa_shd.g_old_rec.attribute8,
265: p_attribute9_o =>per_esa_shd.g_old_rec.attribute9,
266: p_attribute10_o =>per_esa_shd.g_old_rec.attribute10,
267: p_attribute11_o =>per_esa_shd.g_old_rec.attribute11,
268: p_attribute12_o =>per_esa_shd.g_old_rec.attribute12,

Line 265: p_attribute9_o =>per_esa_shd.g_old_rec.attribute9,

261: p_attribute5_o =>per_esa_shd.g_old_rec.attribute5,
262: p_attribute6_o =>per_esa_shd.g_old_rec.attribute6,
263: p_attribute7_o =>per_esa_shd.g_old_rec.attribute7,
264: p_attribute8_o =>per_esa_shd.g_old_rec.attribute8,
265: p_attribute9_o =>per_esa_shd.g_old_rec.attribute9,
266: p_attribute10_o =>per_esa_shd.g_old_rec.attribute10,
267: p_attribute11_o =>per_esa_shd.g_old_rec.attribute11,
268: p_attribute12_o =>per_esa_shd.g_old_rec.attribute12,
269: p_attribute13_o =>per_esa_shd.g_old_rec.attribute13,

Line 266: p_attribute10_o =>per_esa_shd.g_old_rec.attribute10,

262: p_attribute6_o =>per_esa_shd.g_old_rec.attribute6,
263: p_attribute7_o =>per_esa_shd.g_old_rec.attribute7,
264: p_attribute8_o =>per_esa_shd.g_old_rec.attribute8,
265: p_attribute9_o =>per_esa_shd.g_old_rec.attribute9,
266: p_attribute10_o =>per_esa_shd.g_old_rec.attribute10,
267: p_attribute11_o =>per_esa_shd.g_old_rec.attribute11,
268: p_attribute12_o =>per_esa_shd.g_old_rec.attribute12,
269: p_attribute13_o =>per_esa_shd.g_old_rec.attribute13,
270: p_attribute14_o =>per_esa_shd.g_old_rec.attribute14,

Line 267: p_attribute11_o =>per_esa_shd.g_old_rec.attribute11,

263: p_attribute7_o =>per_esa_shd.g_old_rec.attribute7,
264: p_attribute8_o =>per_esa_shd.g_old_rec.attribute8,
265: p_attribute9_o =>per_esa_shd.g_old_rec.attribute9,
266: p_attribute10_o =>per_esa_shd.g_old_rec.attribute10,
267: p_attribute11_o =>per_esa_shd.g_old_rec.attribute11,
268: p_attribute12_o =>per_esa_shd.g_old_rec.attribute12,
269: p_attribute13_o =>per_esa_shd.g_old_rec.attribute13,
270: p_attribute14_o =>per_esa_shd.g_old_rec.attribute14,
271: p_attribute15_o =>per_esa_shd.g_old_rec.attribute15,

Line 268: p_attribute12_o =>per_esa_shd.g_old_rec.attribute12,

264: p_attribute8_o =>per_esa_shd.g_old_rec.attribute8,
265: p_attribute9_o =>per_esa_shd.g_old_rec.attribute9,
266: p_attribute10_o =>per_esa_shd.g_old_rec.attribute10,
267: p_attribute11_o =>per_esa_shd.g_old_rec.attribute11,
268: p_attribute12_o =>per_esa_shd.g_old_rec.attribute12,
269: p_attribute13_o =>per_esa_shd.g_old_rec.attribute13,
270: p_attribute14_o =>per_esa_shd.g_old_rec.attribute14,
271: p_attribute15_o =>per_esa_shd.g_old_rec.attribute15,
272: p_attribute16_o =>per_esa_shd.g_old_rec.attribute16,

Line 269: p_attribute13_o =>per_esa_shd.g_old_rec.attribute13,

265: p_attribute9_o =>per_esa_shd.g_old_rec.attribute9,
266: p_attribute10_o =>per_esa_shd.g_old_rec.attribute10,
267: p_attribute11_o =>per_esa_shd.g_old_rec.attribute11,
268: p_attribute12_o =>per_esa_shd.g_old_rec.attribute12,
269: p_attribute13_o =>per_esa_shd.g_old_rec.attribute13,
270: p_attribute14_o =>per_esa_shd.g_old_rec.attribute14,
271: p_attribute15_o =>per_esa_shd.g_old_rec.attribute15,
272: p_attribute16_o =>per_esa_shd.g_old_rec.attribute16,
273: p_attribute17_o =>per_esa_shd.g_old_rec.attribute17,

Line 270: p_attribute14_o =>per_esa_shd.g_old_rec.attribute14,

266: p_attribute10_o =>per_esa_shd.g_old_rec.attribute10,
267: p_attribute11_o =>per_esa_shd.g_old_rec.attribute11,
268: p_attribute12_o =>per_esa_shd.g_old_rec.attribute12,
269: p_attribute13_o =>per_esa_shd.g_old_rec.attribute13,
270: p_attribute14_o =>per_esa_shd.g_old_rec.attribute14,
271: p_attribute15_o =>per_esa_shd.g_old_rec.attribute15,
272: p_attribute16_o =>per_esa_shd.g_old_rec.attribute16,
273: p_attribute17_o =>per_esa_shd.g_old_rec.attribute17,
274: p_attribute18_o =>per_esa_shd.g_old_rec.attribute18,

Line 271: p_attribute15_o =>per_esa_shd.g_old_rec.attribute15,

267: p_attribute11_o =>per_esa_shd.g_old_rec.attribute11,
268: p_attribute12_o =>per_esa_shd.g_old_rec.attribute12,
269: p_attribute13_o =>per_esa_shd.g_old_rec.attribute13,
270: p_attribute14_o =>per_esa_shd.g_old_rec.attribute14,
271: p_attribute15_o =>per_esa_shd.g_old_rec.attribute15,
272: p_attribute16_o =>per_esa_shd.g_old_rec.attribute16,
273: p_attribute17_o =>per_esa_shd.g_old_rec.attribute17,
274: p_attribute18_o =>per_esa_shd.g_old_rec.attribute18,
275: p_attribute19_o =>per_esa_shd.g_old_rec.attribute19,

Line 272: p_attribute16_o =>per_esa_shd.g_old_rec.attribute16,

268: p_attribute12_o =>per_esa_shd.g_old_rec.attribute12,
269: p_attribute13_o =>per_esa_shd.g_old_rec.attribute13,
270: p_attribute14_o =>per_esa_shd.g_old_rec.attribute14,
271: p_attribute15_o =>per_esa_shd.g_old_rec.attribute15,
272: p_attribute16_o =>per_esa_shd.g_old_rec.attribute16,
273: p_attribute17_o =>per_esa_shd.g_old_rec.attribute17,
274: p_attribute18_o =>per_esa_shd.g_old_rec.attribute18,
275: p_attribute19_o =>per_esa_shd.g_old_rec.attribute19,
276: p_attribute20_o =>per_esa_shd.g_old_rec.attribute20,

Line 273: p_attribute17_o =>per_esa_shd.g_old_rec.attribute17,

269: p_attribute13_o =>per_esa_shd.g_old_rec.attribute13,
270: p_attribute14_o =>per_esa_shd.g_old_rec.attribute14,
271: p_attribute15_o =>per_esa_shd.g_old_rec.attribute15,
272: p_attribute16_o =>per_esa_shd.g_old_rec.attribute16,
273: p_attribute17_o =>per_esa_shd.g_old_rec.attribute17,
274: p_attribute18_o =>per_esa_shd.g_old_rec.attribute18,
275: p_attribute19_o =>per_esa_shd.g_old_rec.attribute19,
276: p_attribute20_o =>per_esa_shd.g_old_rec.attribute20,
277: p_object_version_number_o =>per_esa_shd.g_old_rec.object_version_number,

Line 274: p_attribute18_o =>per_esa_shd.g_old_rec.attribute18,

270: p_attribute14_o =>per_esa_shd.g_old_rec.attribute14,
271: p_attribute15_o =>per_esa_shd.g_old_rec.attribute15,
272: p_attribute16_o =>per_esa_shd.g_old_rec.attribute16,
273: p_attribute17_o =>per_esa_shd.g_old_rec.attribute17,
274: p_attribute18_o =>per_esa_shd.g_old_rec.attribute18,
275: p_attribute19_o =>per_esa_shd.g_old_rec.attribute19,
276: p_attribute20_o =>per_esa_shd.g_old_rec.attribute20,
277: p_object_version_number_o =>per_esa_shd.g_old_rec.object_version_number,
278: p_business_group_id_o =>per_esa_shd.g_old_rec.business_group_id,

Line 275: p_attribute19_o =>per_esa_shd.g_old_rec.attribute19,

271: p_attribute15_o =>per_esa_shd.g_old_rec.attribute15,
272: p_attribute16_o =>per_esa_shd.g_old_rec.attribute16,
273: p_attribute17_o =>per_esa_shd.g_old_rec.attribute17,
274: p_attribute18_o =>per_esa_shd.g_old_rec.attribute18,
275: p_attribute19_o =>per_esa_shd.g_old_rec.attribute19,
276: p_attribute20_o =>per_esa_shd.g_old_rec.attribute20,
277: p_object_version_number_o =>per_esa_shd.g_old_rec.object_version_number,
278: p_business_group_id_o =>per_esa_shd.g_old_rec.business_group_id,
279: p_party_id_o =>per_esa_shd.g_old_rec.party_id, -- HR/TCA merge

Line 276: p_attribute20_o =>per_esa_shd.g_old_rec.attribute20,

272: p_attribute16_o =>per_esa_shd.g_old_rec.attribute16,
273: p_attribute17_o =>per_esa_shd.g_old_rec.attribute17,
274: p_attribute18_o =>per_esa_shd.g_old_rec.attribute18,
275: p_attribute19_o =>per_esa_shd.g_old_rec.attribute19,
276: p_attribute20_o =>per_esa_shd.g_old_rec.attribute20,
277: p_object_version_number_o =>per_esa_shd.g_old_rec.object_version_number,
278: p_business_group_id_o =>per_esa_shd.g_old_rec.business_group_id,
279: p_party_id_o =>per_esa_shd.g_old_rec.party_id, -- HR/TCA merge
280: p_address_o =>per_esa_shd.g_old_rec.address

Line 277: p_object_version_number_o =>per_esa_shd.g_old_rec.object_version_number,

273: p_attribute17_o =>per_esa_shd.g_old_rec.attribute17,
274: p_attribute18_o =>per_esa_shd.g_old_rec.attribute18,
275: p_attribute19_o =>per_esa_shd.g_old_rec.attribute19,
276: p_attribute20_o =>per_esa_shd.g_old_rec.attribute20,
277: p_object_version_number_o =>per_esa_shd.g_old_rec.object_version_number,
278: p_business_group_id_o =>per_esa_shd.g_old_rec.business_group_id,
279: p_party_id_o =>per_esa_shd.g_old_rec.party_id, -- HR/TCA merge
280: p_address_o =>per_esa_shd.g_old_rec.address
281: );

Line 278: p_business_group_id_o =>per_esa_shd.g_old_rec.business_group_id,

274: p_attribute18_o =>per_esa_shd.g_old_rec.attribute18,
275: p_attribute19_o =>per_esa_shd.g_old_rec.attribute19,
276: p_attribute20_o =>per_esa_shd.g_old_rec.attribute20,
277: p_object_version_number_o =>per_esa_shd.g_old_rec.object_version_number,
278: p_business_group_id_o =>per_esa_shd.g_old_rec.business_group_id,
279: p_party_id_o =>per_esa_shd.g_old_rec.party_id, -- HR/TCA merge
280: p_address_o =>per_esa_shd.g_old_rec.address
281: );
282: exception

Line 279: p_party_id_o =>per_esa_shd.g_old_rec.party_id, -- HR/TCA merge

275: p_attribute19_o =>per_esa_shd.g_old_rec.attribute19,
276: p_attribute20_o =>per_esa_shd.g_old_rec.attribute20,
277: p_object_version_number_o =>per_esa_shd.g_old_rec.object_version_number,
278: p_business_group_id_o =>per_esa_shd.g_old_rec.business_group_id,
279: p_party_id_o =>per_esa_shd.g_old_rec.party_id, -- HR/TCA merge
280: p_address_o =>per_esa_shd.g_old_rec.address
281: );
282: exception
283: when hr_api.cannot_find_prog_unit then

Line 280: p_address_o =>per_esa_shd.g_old_rec.address

276: p_attribute20_o =>per_esa_shd.g_old_rec.attribute20,
277: p_object_version_number_o =>per_esa_shd.g_old_rec.object_version_number,
278: p_business_group_id_o =>per_esa_shd.g_old_rec.business_group_id,
279: p_party_id_o =>per_esa_shd.g_old_rec.party_id, -- HR/TCA merge
280: p_address_o =>per_esa_shd.g_old_rec.address
281: );
282: exception
283: when hr_api.cannot_find_prog_unit then
284: hr_api.cannot_find_prog_unit_error

Line 338: Procedure convert_defs(p_rec in out nocopy per_esa_shd.g_rec_type) is

334: -- Internal Table Handler Use Only.
335: --
336: -- {End Of Comments}
337: -- ----------------------------------------------------------------------------
338: Procedure convert_defs(p_rec in out nocopy per_esa_shd.g_rec_type) is
339: --
340: l_proc varchar2(72) := g_package||'convert_defs';
341: --
342: Begin

Line 353: per_esa_shd.g_old_rec.person_id;

349: -- is being used then we must set to the 'current' argument value.
350: --
351: If (p_rec.person_id = hr_api.g_number) then
352: p_rec.person_id :=
353: per_esa_shd.g_old_rec.person_id;
354: End If;
355: If (p_rec.establishment_id = hr_api.g_number) then
356: p_rec.establishment_id :=
357: per_esa_shd.g_old_rec.establishment_id;

Line 357: per_esa_shd.g_old_rec.establishment_id;

353: per_esa_shd.g_old_rec.person_id;
354: End If;
355: If (p_rec.establishment_id = hr_api.g_number) then
356: p_rec.establishment_id :=
357: per_esa_shd.g_old_rec.establishment_id;
358: End If;
359: If (p_rec.establishment = hr_api.g_varchar2) then
360: p_rec.establishment :=
361: per_esa_shd.g_old_rec.establishment;

Line 361: per_esa_shd.g_old_rec.establishment;

357: per_esa_shd.g_old_rec.establishment_id;
358: End If;
359: If (p_rec.establishment = hr_api.g_varchar2) then
360: p_rec.establishment :=
361: per_esa_shd.g_old_rec.establishment;
362: End If;
363: If (p_rec.attended_start_date = hr_api.g_date) then
364: p_rec.attended_start_date :=
365: per_esa_shd.g_old_rec.attended_start_date;

Line 365: per_esa_shd.g_old_rec.attended_start_date;

361: per_esa_shd.g_old_rec.establishment;
362: End If;
363: If (p_rec.attended_start_date = hr_api.g_date) then
364: p_rec.attended_start_date :=
365: per_esa_shd.g_old_rec.attended_start_date;
366: End If;
367: If (p_rec.attended_end_date = hr_api.g_date) then
368: p_rec.attended_end_date :=
369: per_esa_shd.g_old_rec.attended_end_date;

Line 369: per_esa_shd.g_old_rec.attended_end_date;

365: per_esa_shd.g_old_rec.attended_start_date;
366: End If;
367: If (p_rec.attended_end_date = hr_api.g_date) then
368: p_rec.attended_end_date :=
369: per_esa_shd.g_old_rec.attended_end_date;
370: End If;
371: If (p_rec.full_time = hr_api.g_varchar2) then
372: p_rec.full_time :=
373: per_esa_shd.g_old_rec.full_time;

Line 373: per_esa_shd.g_old_rec.full_time;

369: per_esa_shd.g_old_rec.attended_end_date;
370: End If;
371: If (p_rec.full_time = hr_api.g_varchar2) then
372: p_rec.full_time :=
373: per_esa_shd.g_old_rec.full_time;
374: End If;
375: If (p_rec.attribute_category = hr_api.g_varchar2) then
376: p_rec.attribute_category :=
377: per_esa_shd.g_old_rec.attribute_category;

Line 377: per_esa_shd.g_old_rec.attribute_category;

373: per_esa_shd.g_old_rec.full_time;
374: End If;
375: If (p_rec.attribute_category = hr_api.g_varchar2) then
376: p_rec.attribute_category :=
377: per_esa_shd.g_old_rec.attribute_category;
378: End If;
379: If (p_rec.attribute1 = hr_api.g_varchar2) then
380: p_rec.attribute1 :=
381: per_esa_shd.g_old_rec.attribute1;

Line 381: per_esa_shd.g_old_rec.attribute1;

377: per_esa_shd.g_old_rec.attribute_category;
378: End If;
379: If (p_rec.attribute1 = hr_api.g_varchar2) then
380: p_rec.attribute1 :=
381: per_esa_shd.g_old_rec.attribute1;
382: End If;
383: If (p_rec.attribute2 = hr_api.g_varchar2) then
384: p_rec.attribute2 :=
385: per_esa_shd.g_old_rec.attribute2;

Line 385: per_esa_shd.g_old_rec.attribute2;

381: per_esa_shd.g_old_rec.attribute1;
382: End If;
383: If (p_rec.attribute2 = hr_api.g_varchar2) then
384: p_rec.attribute2 :=
385: per_esa_shd.g_old_rec.attribute2;
386: End If;
387: If (p_rec.attribute3 = hr_api.g_varchar2) then
388: p_rec.attribute3 :=
389: per_esa_shd.g_old_rec.attribute3;

Line 389: per_esa_shd.g_old_rec.attribute3;

385: per_esa_shd.g_old_rec.attribute2;
386: End If;
387: If (p_rec.attribute3 = hr_api.g_varchar2) then
388: p_rec.attribute3 :=
389: per_esa_shd.g_old_rec.attribute3;
390: End If;
391: If (p_rec.attribute4 = hr_api.g_varchar2) then
392: p_rec.attribute4 :=
393: per_esa_shd.g_old_rec.attribute4;

Line 393: per_esa_shd.g_old_rec.attribute4;

389: per_esa_shd.g_old_rec.attribute3;
390: End If;
391: If (p_rec.attribute4 = hr_api.g_varchar2) then
392: p_rec.attribute4 :=
393: per_esa_shd.g_old_rec.attribute4;
394: End If;
395: If (p_rec.attribute5 = hr_api.g_varchar2) then
396: p_rec.attribute5 :=
397: per_esa_shd.g_old_rec.attribute5;

Line 397: per_esa_shd.g_old_rec.attribute5;

393: per_esa_shd.g_old_rec.attribute4;
394: End If;
395: If (p_rec.attribute5 = hr_api.g_varchar2) then
396: p_rec.attribute5 :=
397: per_esa_shd.g_old_rec.attribute5;
398: End If;
399: If (p_rec.attribute6 = hr_api.g_varchar2) then
400: p_rec.attribute6 :=
401: per_esa_shd.g_old_rec.attribute6;

Line 401: per_esa_shd.g_old_rec.attribute6;

397: per_esa_shd.g_old_rec.attribute5;
398: End If;
399: If (p_rec.attribute6 = hr_api.g_varchar2) then
400: p_rec.attribute6 :=
401: per_esa_shd.g_old_rec.attribute6;
402: End If;
403: If (p_rec.attribute7 = hr_api.g_varchar2) then
404: p_rec.attribute7 :=
405: per_esa_shd.g_old_rec.attribute7;

Line 405: per_esa_shd.g_old_rec.attribute7;

401: per_esa_shd.g_old_rec.attribute6;
402: End If;
403: If (p_rec.attribute7 = hr_api.g_varchar2) then
404: p_rec.attribute7 :=
405: per_esa_shd.g_old_rec.attribute7;
406: End If;
407: If (p_rec.attribute8 = hr_api.g_varchar2) then
408: p_rec.attribute8 :=
409: per_esa_shd.g_old_rec.attribute8;

Line 409: per_esa_shd.g_old_rec.attribute8;

405: per_esa_shd.g_old_rec.attribute7;
406: End If;
407: If (p_rec.attribute8 = hr_api.g_varchar2) then
408: p_rec.attribute8 :=
409: per_esa_shd.g_old_rec.attribute8;
410: End If;
411: If (p_rec.attribute9 = hr_api.g_varchar2) then
412: p_rec.attribute9 :=
413: per_esa_shd.g_old_rec.attribute9;

Line 413: per_esa_shd.g_old_rec.attribute9;

409: per_esa_shd.g_old_rec.attribute8;
410: End If;
411: If (p_rec.attribute9 = hr_api.g_varchar2) then
412: p_rec.attribute9 :=
413: per_esa_shd.g_old_rec.attribute9;
414: End If;
415: If (p_rec.attribute10 = hr_api.g_varchar2) then
416: p_rec.attribute10 :=
417: per_esa_shd.g_old_rec.attribute10;

Line 417: per_esa_shd.g_old_rec.attribute10;

413: per_esa_shd.g_old_rec.attribute9;
414: End If;
415: If (p_rec.attribute10 = hr_api.g_varchar2) then
416: p_rec.attribute10 :=
417: per_esa_shd.g_old_rec.attribute10;
418: End If;
419: If (p_rec.attribute11 = hr_api.g_varchar2) then
420: p_rec.attribute11 :=
421: per_esa_shd.g_old_rec.attribute11;

Line 421: per_esa_shd.g_old_rec.attribute11;

417: per_esa_shd.g_old_rec.attribute10;
418: End If;
419: If (p_rec.attribute11 = hr_api.g_varchar2) then
420: p_rec.attribute11 :=
421: per_esa_shd.g_old_rec.attribute11;
422: End If;
423: If (p_rec.attribute12 = hr_api.g_varchar2) then
424: p_rec.attribute12 :=
425: per_esa_shd.g_old_rec.attribute12;

Line 425: per_esa_shd.g_old_rec.attribute12;

421: per_esa_shd.g_old_rec.attribute11;
422: End If;
423: If (p_rec.attribute12 = hr_api.g_varchar2) then
424: p_rec.attribute12 :=
425: per_esa_shd.g_old_rec.attribute12;
426: End If;
427: If (p_rec.attribute13 = hr_api.g_varchar2) then
428: p_rec.attribute13 :=
429: per_esa_shd.g_old_rec.attribute13;

Line 429: per_esa_shd.g_old_rec.attribute13;

425: per_esa_shd.g_old_rec.attribute12;
426: End If;
427: If (p_rec.attribute13 = hr_api.g_varchar2) then
428: p_rec.attribute13 :=
429: per_esa_shd.g_old_rec.attribute13;
430: End If;
431: If (p_rec.attribute14 = hr_api.g_varchar2) then
432: p_rec.attribute14 :=
433: per_esa_shd.g_old_rec.attribute14;

Line 433: per_esa_shd.g_old_rec.attribute14;

429: per_esa_shd.g_old_rec.attribute13;
430: End If;
431: If (p_rec.attribute14 = hr_api.g_varchar2) then
432: p_rec.attribute14 :=
433: per_esa_shd.g_old_rec.attribute14;
434: End If;
435: If (p_rec.attribute15 = hr_api.g_varchar2) then
436: p_rec.attribute15 :=
437: per_esa_shd.g_old_rec.attribute15;

Line 437: per_esa_shd.g_old_rec.attribute15;

433: per_esa_shd.g_old_rec.attribute14;
434: End If;
435: If (p_rec.attribute15 = hr_api.g_varchar2) then
436: p_rec.attribute15 :=
437: per_esa_shd.g_old_rec.attribute15;
438: End If;
439: If (p_rec.attribute16 = hr_api.g_varchar2) then
440: p_rec.attribute16 :=
441: per_esa_shd.g_old_rec.attribute16;

Line 441: per_esa_shd.g_old_rec.attribute16;

437: per_esa_shd.g_old_rec.attribute15;
438: End If;
439: If (p_rec.attribute16 = hr_api.g_varchar2) then
440: p_rec.attribute16 :=
441: per_esa_shd.g_old_rec.attribute16;
442: End If;
443: If (p_rec.attribute17 = hr_api.g_varchar2) then
444: p_rec.attribute17 :=
445: per_esa_shd.g_old_rec.attribute17;

Line 445: per_esa_shd.g_old_rec.attribute17;

441: per_esa_shd.g_old_rec.attribute16;
442: End If;
443: If (p_rec.attribute17 = hr_api.g_varchar2) then
444: p_rec.attribute17 :=
445: per_esa_shd.g_old_rec.attribute17;
446: End If;
447: If (p_rec.attribute18 = hr_api.g_varchar2) then
448: p_rec.attribute18 :=
449: per_esa_shd.g_old_rec.attribute18;

Line 449: per_esa_shd.g_old_rec.attribute18;

445: per_esa_shd.g_old_rec.attribute17;
446: End If;
447: If (p_rec.attribute18 = hr_api.g_varchar2) then
448: p_rec.attribute18 :=
449: per_esa_shd.g_old_rec.attribute18;
450: End If;
451: If (p_rec.attribute19 = hr_api.g_varchar2) then
452: p_rec.attribute19 :=
453: per_esa_shd.g_old_rec.attribute19;

Line 453: per_esa_shd.g_old_rec.attribute19;

449: per_esa_shd.g_old_rec.attribute18;
450: End If;
451: If (p_rec.attribute19 = hr_api.g_varchar2) then
452: p_rec.attribute19 :=
453: per_esa_shd.g_old_rec.attribute19;
454: End If;
455: If (p_rec.attribute20 = hr_api.g_varchar2) then
456: p_rec.attribute20 :=
457: per_esa_shd.g_old_rec.attribute20;

Line 457: per_esa_shd.g_old_rec.attribute20;

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

Line 461: per_esa_shd.g_old_rec.business_group_id;

457: per_esa_shd.g_old_rec.attribute20;
458: End If;
459: If (p_rec.business_group_id = hr_api.g_number) then
460: p_rec.business_group_id :=
461: per_esa_shd.g_old_rec.business_group_id;
462: End If;
463: If (p_rec.party_id = hr_api.g_number) then -- HR/TCA merge
464: p_rec.party_id :=
465: per_esa_shd.g_old_rec.party_id;

Line 465: per_esa_shd.g_old_rec.party_id;

461: per_esa_shd.g_old_rec.business_group_id;
462: End If;
463: If (p_rec.party_id = hr_api.g_number) then -- HR/TCA merge
464: p_rec.party_id :=
465: per_esa_shd.g_old_rec.party_id;
466: End If;
467: If (p_rec.address = hr_api.g_varchar2) then
468: p_rec.address :=
469: per_esa_shd.g_old_rec.address;

Line 469: per_esa_shd.g_old_rec.address;

465: per_esa_shd.g_old_rec.party_id;
466: End If;
467: If (p_rec.address = hr_api.g_varchar2) then
468: p_rec.address :=
469: per_esa_shd.g_old_rec.address;
470: End If;
471: --
472: hr_utility.set_location(' Leaving:'||l_proc, 10);
473: --

Line 481: p_rec in out nocopy per_esa_shd.g_rec_type,

477: -- |---------------------------------< upd >----------------------------------|
478: -- ----------------------------------------------------------------------------
479: Procedure upd
480: (
481: p_rec in out nocopy per_esa_shd.g_rec_type,
482: p_effective_date in date,
483: p_validate in boolean default false
484: ) is
485: --

Line 502: per_esa_shd.lck

498: End If;
499: --
500: -- We must lock the row which we need to update.
501: --
502: per_esa_shd.lck
503: (
504: p_rec.attendance_id,
505: p_rec.object_version_number
506: );

Line 586: l_rec per_esa_shd.g_rec_type;

582: p_party_id in number default hr_api.g_number,
583: p_address in varchar2 default hr_api.g_varchar2
584: ) is
585: --
586: l_rec per_esa_shd.g_rec_type;
587: l_proc varchar2(72) := g_package||'upd';
588: --
589: Begin
590: hr_utility.set_location('Entering:'||l_proc, 5);

Line 596: per_esa_shd.convert_args

592: -- Call conversion function to turn arguments into the
593: -- l_rec structure.
594: --
595: l_rec :=
596: per_esa_shd.convert_args
597: (
598: p_attendance_id,
599: p_person_id,
600: p_establishment_id,