APPS.PER_PDM_UPD dependencies on PER_PDM_SHD

Line 48: Procedure update_dml(p_rec in out nocopy per_pdm_shd.g_rec_type) is

44: -- Internal Row Handler Use Only.
45: --
46: -- {End Of Comments}
47: -- ----------------------------------------------------------------------------
48: Procedure update_dml(p_rec in out nocopy per_pdm_shd.g_rec_type) is
49: --
50: l_proc varchar2(72) := g_package||'update_dml';
51: --
52: Begin

Line 101: per_pdm_shd.constraint_error

97: --
98: Exception
99: When hr_api.check_integrity_violated Then
100: -- A check constraint has been violated
101: per_pdm_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When hr_api.parent_integrity_violated Then
104: -- Parent integrity has been violated
105: per_pdm_shd.constraint_error

Line 105: per_pdm_shd.constraint_error

101: per_pdm_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When hr_api.parent_integrity_violated Then
104: -- Parent integrity has been violated
105: per_pdm_shd.constraint_error
106: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
107: When hr_api.unique_integrity_violated Then
108: -- Unique integrity has been violated
109: per_pdm_shd.constraint_error

Line 109: per_pdm_shd.constraint_error

105: per_pdm_shd.constraint_error
106: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
107: When hr_api.unique_integrity_violated Then
108: -- Unique integrity has been violated
109: per_pdm_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When Others Then
112: Raise;
113: End update_dml;

Line 147: Procedure pre_update(p_rec in per_pdm_shd.g_rec_type) is

143: -- Internal Row Handler Use Only.
144: --
145: -- {End Of Comments}
146: -- ----------------------------------------------------------------------------
147: Procedure pre_update(p_rec in per_pdm_shd.g_rec_type) is
148: --
149: l_proc varchar2(72) := g_package||'pre_update';
150: --
151: Begin

Line 190: p_effective_date in date,p_rec in per_pdm_shd.g_rec_type) is

186: --
187: -- {End Of Comments}
188: -- ----------------------------------------------------------------------------
189: Procedure post_update(
190: p_effective_date in date,p_rec in per_pdm_shd.g_rec_type) is
191: --
192: l_proc varchar2(72) := g_package||'post_update';
193: --
194: Begin

Line 236: ,p_person_id_o =>per_pdm_shd.g_old_rec.person_id

232: ,p_attribute18 =>p_rec.attribute18
233: ,p_attribute19 =>p_rec.attribute19
234: ,p_attribute20 =>p_rec.attribute20
235: ,p_effective_date =>p_effective_date
236: ,p_person_id_o =>per_pdm_shd.g_old_rec.person_id
237: ,p_date_start_o =>per_pdm_shd.g_old_rec.date_start
238: ,p_date_end_o =>per_pdm_shd.g_old_rec.date_end
239: ,p_comm_dlvry_method_o =>per_pdm_shd.g_old_rec.comm_dlvry_method
240: ,p_preferred_flag_o =>per_pdm_shd.g_old_rec.preferred_flag

Line 237: ,p_date_start_o =>per_pdm_shd.g_old_rec.date_start

233: ,p_attribute19 =>p_rec.attribute19
234: ,p_attribute20 =>p_rec.attribute20
235: ,p_effective_date =>p_effective_date
236: ,p_person_id_o =>per_pdm_shd.g_old_rec.person_id
237: ,p_date_start_o =>per_pdm_shd.g_old_rec.date_start
238: ,p_date_end_o =>per_pdm_shd.g_old_rec.date_end
239: ,p_comm_dlvry_method_o =>per_pdm_shd.g_old_rec.comm_dlvry_method
240: ,p_preferred_flag_o =>per_pdm_shd.g_old_rec.preferred_flag
241: ,p_object_version_number_o =>per_pdm_shd.g_old_rec.object_version_number

Line 238: ,p_date_end_o =>per_pdm_shd.g_old_rec.date_end

234: ,p_attribute20 =>p_rec.attribute20
235: ,p_effective_date =>p_effective_date
236: ,p_person_id_o =>per_pdm_shd.g_old_rec.person_id
237: ,p_date_start_o =>per_pdm_shd.g_old_rec.date_start
238: ,p_date_end_o =>per_pdm_shd.g_old_rec.date_end
239: ,p_comm_dlvry_method_o =>per_pdm_shd.g_old_rec.comm_dlvry_method
240: ,p_preferred_flag_o =>per_pdm_shd.g_old_rec.preferred_flag
241: ,p_object_version_number_o =>per_pdm_shd.g_old_rec.object_version_number
242: ,p_request_id_o =>per_pdm_shd.g_old_rec.request_id

Line 239: ,p_comm_dlvry_method_o =>per_pdm_shd.g_old_rec.comm_dlvry_method

235: ,p_effective_date =>p_effective_date
236: ,p_person_id_o =>per_pdm_shd.g_old_rec.person_id
237: ,p_date_start_o =>per_pdm_shd.g_old_rec.date_start
238: ,p_date_end_o =>per_pdm_shd.g_old_rec.date_end
239: ,p_comm_dlvry_method_o =>per_pdm_shd.g_old_rec.comm_dlvry_method
240: ,p_preferred_flag_o =>per_pdm_shd.g_old_rec.preferred_flag
241: ,p_object_version_number_o =>per_pdm_shd.g_old_rec.object_version_number
242: ,p_request_id_o =>per_pdm_shd.g_old_rec.request_id
243: ,p_program_update_date_o =>per_pdm_shd.g_old_rec.program_update_date

Line 240: ,p_preferred_flag_o =>per_pdm_shd.g_old_rec.preferred_flag

236: ,p_person_id_o =>per_pdm_shd.g_old_rec.person_id
237: ,p_date_start_o =>per_pdm_shd.g_old_rec.date_start
238: ,p_date_end_o =>per_pdm_shd.g_old_rec.date_end
239: ,p_comm_dlvry_method_o =>per_pdm_shd.g_old_rec.comm_dlvry_method
240: ,p_preferred_flag_o =>per_pdm_shd.g_old_rec.preferred_flag
241: ,p_object_version_number_o =>per_pdm_shd.g_old_rec.object_version_number
242: ,p_request_id_o =>per_pdm_shd.g_old_rec.request_id
243: ,p_program_update_date_o =>per_pdm_shd.g_old_rec.program_update_date
244: ,p_program_application_id_o =>per_pdm_shd.g_old_rec.program_application_id

Line 241: ,p_object_version_number_o =>per_pdm_shd.g_old_rec.object_version_number

237: ,p_date_start_o =>per_pdm_shd.g_old_rec.date_start
238: ,p_date_end_o =>per_pdm_shd.g_old_rec.date_end
239: ,p_comm_dlvry_method_o =>per_pdm_shd.g_old_rec.comm_dlvry_method
240: ,p_preferred_flag_o =>per_pdm_shd.g_old_rec.preferred_flag
241: ,p_object_version_number_o =>per_pdm_shd.g_old_rec.object_version_number
242: ,p_request_id_o =>per_pdm_shd.g_old_rec.request_id
243: ,p_program_update_date_o =>per_pdm_shd.g_old_rec.program_update_date
244: ,p_program_application_id_o =>per_pdm_shd.g_old_rec.program_application_id
245: ,p_program_id_o =>per_pdm_shd.g_old_rec.program_id

Line 242: ,p_request_id_o =>per_pdm_shd.g_old_rec.request_id

238: ,p_date_end_o =>per_pdm_shd.g_old_rec.date_end
239: ,p_comm_dlvry_method_o =>per_pdm_shd.g_old_rec.comm_dlvry_method
240: ,p_preferred_flag_o =>per_pdm_shd.g_old_rec.preferred_flag
241: ,p_object_version_number_o =>per_pdm_shd.g_old_rec.object_version_number
242: ,p_request_id_o =>per_pdm_shd.g_old_rec.request_id
243: ,p_program_update_date_o =>per_pdm_shd.g_old_rec.program_update_date
244: ,p_program_application_id_o =>per_pdm_shd.g_old_rec.program_application_id
245: ,p_program_id_o =>per_pdm_shd.g_old_rec.program_id
246: ,p_attribute_category_o =>per_pdm_shd.g_old_rec.attribute_category

Line 243: ,p_program_update_date_o =>per_pdm_shd.g_old_rec.program_update_date

239: ,p_comm_dlvry_method_o =>per_pdm_shd.g_old_rec.comm_dlvry_method
240: ,p_preferred_flag_o =>per_pdm_shd.g_old_rec.preferred_flag
241: ,p_object_version_number_o =>per_pdm_shd.g_old_rec.object_version_number
242: ,p_request_id_o =>per_pdm_shd.g_old_rec.request_id
243: ,p_program_update_date_o =>per_pdm_shd.g_old_rec.program_update_date
244: ,p_program_application_id_o =>per_pdm_shd.g_old_rec.program_application_id
245: ,p_program_id_o =>per_pdm_shd.g_old_rec.program_id
246: ,p_attribute_category_o =>per_pdm_shd.g_old_rec.attribute_category
247: ,p_attribute1_o =>per_pdm_shd.g_old_rec.attribute1

Line 244: ,p_program_application_id_o =>per_pdm_shd.g_old_rec.program_application_id

240: ,p_preferred_flag_o =>per_pdm_shd.g_old_rec.preferred_flag
241: ,p_object_version_number_o =>per_pdm_shd.g_old_rec.object_version_number
242: ,p_request_id_o =>per_pdm_shd.g_old_rec.request_id
243: ,p_program_update_date_o =>per_pdm_shd.g_old_rec.program_update_date
244: ,p_program_application_id_o =>per_pdm_shd.g_old_rec.program_application_id
245: ,p_program_id_o =>per_pdm_shd.g_old_rec.program_id
246: ,p_attribute_category_o =>per_pdm_shd.g_old_rec.attribute_category
247: ,p_attribute1_o =>per_pdm_shd.g_old_rec.attribute1
248: ,p_attribute2_o =>per_pdm_shd.g_old_rec.attribute2

Line 245: ,p_program_id_o =>per_pdm_shd.g_old_rec.program_id

241: ,p_object_version_number_o =>per_pdm_shd.g_old_rec.object_version_number
242: ,p_request_id_o =>per_pdm_shd.g_old_rec.request_id
243: ,p_program_update_date_o =>per_pdm_shd.g_old_rec.program_update_date
244: ,p_program_application_id_o =>per_pdm_shd.g_old_rec.program_application_id
245: ,p_program_id_o =>per_pdm_shd.g_old_rec.program_id
246: ,p_attribute_category_o =>per_pdm_shd.g_old_rec.attribute_category
247: ,p_attribute1_o =>per_pdm_shd.g_old_rec.attribute1
248: ,p_attribute2_o =>per_pdm_shd.g_old_rec.attribute2
249: ,p_attribute3_o =>per_pdm_shd.g_old_rec.attribute3

Line 246: ,p_attribute_category_o =>per_pdm_shd.g_old_rec.attribute_category

242: ,p_request_id_o =>per_pdm_shd.g_old_rec.request_id
243: ,p_program_update_date_o =>per_pdm_shd.g_old_rec.program_update_date
244: ,p_program_application_id_o =>per_pdm_shd.g_old_rec.program_application_id
245: ,p_program_id_o =>per_pdm_shd.g_old_rec.program_id
246: ,p_attribute_category_o =>per_pdm_shd.g_old_rec.attribute_category
247: ,p_attribute1_o =>per_pdm_shd.g_old_rec.attribute1
248: ,p_attribute2_o =>per_pdm_shd.g_old_rec.attribute2
249: ,p_attribute3_o =>per_pdm_shd.g_old_rec.attribute3
250: ,p_attribute4_o =>per_pdm_shd.g_old_rec.attribute4

Line 247: ,p_attribute1_o =>per_pdm_shd.g_old_rec.attribute1

243: ,p_program_update_date_o =>per_pdm_shd.g_old_rec.program_update_date
244: ,p_program_application_id_o =>per_pdm_shd.g_old_rec.program_application_id
245: ,p_program_id_o =>per_pdm_shd.g_old_rec.program_id
246: ,p_attribute_category_o =>per_pdm_shd.g_old_rec.attribute_category
247: ,p_attribute1_o =>per_pdm_shd.g_old_rec.attribute1
248: ,p_attribute2_o =>per_pdm_shd.g_old_rec.attribute2
249: ,p_attribute3_o =>per_pdm_shd.g_old_rec.attribute3
250: ,p_attribute4_o =>per_pdm_shd.g_old_rec.attribute4
251: ,p_attribute5_o =>per_pdm_shd.g_old_rec.attribute5

Line 248: ,p_attribute2_o =>per_pdm_shd.g_old_rec.attribute2

244: ,p_program_application_id_o =>per_pdm_shd.g_old_rec.program_application_id
245: ,p_program_id_o =>per_pdm_shd.g_old_rec.program_id
246: ,p_attribute_category_o =>per_pdm_shd.g_old_rec.attribute_category
247: ,p_attribute1_o =>per_pdm_shd.g_old_rec.attribute1
248: ,p_attribute2_o =>per_pdm_shd.g_old_rec.attribute2
249: ,p_attribute3_o =>per_pdm_shd.g_old_rec.attribute3
250: ,p_attribute4_o =>per_pdm_shd.g_old_rec.attribute4
251: ,p_attribute5_o =>per_pdm_shd.g_old_rec.attribute5
252: ,p_attribute6_o =>per_pdm_shd.g_old_rec.attribute6

Line 249: ,p_attribute3_o =>per_pdm_shd.g_old_rec.attribute3

245: ,p_program_id_o =>per_pdm_shd.g_old_rec.program_id
246: ,p_attribute_category_o =>per_pdm_shd.g_old_rec.attribute_category
247: ,p_attribute1_o =>per_pdm_shd.g_old_rec.attribute1
248: ,p_attribute2_o =>per_pdm_shd.g_old_rec.attribute2
249: ,p_attribute3_o =>per_pdm_shd.g_old_rec.attribute3
250: ,p_attribute4_o =>per_pdm_shd.g_old_rec.attribute4
251: ,p_attribute5_o =>per_pdm_shd.g_old_rec.attribute5
252: ,p_attribute6_o =>per_pdm_shd.g_old_rec.attribute6
253: ,p_attribute7_o =>per_pdm_shd.g_old_rec.attribute7

Line 250: ,p_attribute4_o =>per_pdm_shd.g_old_rec.attribute4

246: ,p_attribute_category_o =>per_pdm_shd.g_old_rec.attribute_category
247: ,p_attribute1_o =>per_pdm_shd.g_old_rec.attribute1
248: ,p_attribute2_o =>per_pdm_shd.g_old_rec.attribute2
249: ,p_attribute3_o =>per_pdm_shd.g_old_rec.attribute3
250: ,p_attribute4_o =>per_pdm_shd.g_old_rec.attribute4
251: ,p_attribute5_o =>per_pdm_shd.g_old_rec.attribute5
252: ,p_attribute6_o =>per_pdm_shd.g_old_rec.attribute6
253: ,p_attribute7_o =>per_pdm_shd.g_old_rec.attribute7
254: ,p_attribute8_o =>per_pdm_shd.g_old_rec.attribute8

Line 251: ,p_attribute5_o =>per_pdm_shd.g_old_rec.attribute5

247: ,p_attribute1_o =>per_pdm_shd.g_old_rec.attribute1
248: ,p_attribute2_o =>per_pdm_shd.g_old_rec.attribute2
249: ,p_attribute3_o =>per_pdm_shd.g_old_rec.attribute3
250: ,p_attribute4_o =>per_pdm_shd.g_old_rec.attribute4
251: ,p_attribute5_o =>per_pdm_shd.g_old_rec.attribute5
252: ,p_attribute6_o =>per_pdm_shd.g_old_rec.attribute6
253: ,p_attribute7_o =>per_pdm_shd.g_old_rec.attribute7
254: ,p_attribute8_o =>per_pdm_shd.g_old_rec.attribute8
255: ,p_attribute9_o =>per_pdm_shd.g_old_rec.attribute9

Line 252: ,p_attribute6_o =>per_pdm_shd.g_old_rec.attribute6

248: ,p_attribute2_o =>per_pdm_shd.g_old_rec.attribute2
249: ,p_attribute3_o =>per_pdm_shd.g_old_rec.attribute3
250: ,p_attribute4_o =>per_pdm_shd.g_old_rec.attribute4
251: ,p_attribute5_o =>per_pdm_shd.g_old_rec.attribute5
252: ,p_attribute6_o =>per_pdm_shd.g_old_rec.attribute6
253: ,p_attribute7_o =>per_pdm_shd.g_old_rec.attribute7
254: ,p_attribute8_o =>per_pdm_shd.g_old_rec.attribute8
255: ,p_attribute9_o =>per_pdm_shd.g_old_rec.attribute9
256: ,p_attribute10_o =>per_pdm_shd.g_old_rec.attribute10

Line 253: ,p_attribute7_o =>per_pdm_shd.g_old_rec.attribute7

249: ,p_attribute3_o =>per_pdm_shd.g_old_rec.attribute3
250: ,p_attribute4_o =>per_pdm_shd.g_old_rec.attribute4
251: ,p_attribute5_o =>per_pdm_shd.g_old_rec.attribute5
252: ,p_attribute6_o =>per_pdm_shd.g_old_rec.attribute6
253: ,p_attribute7_o =>per_pdm_shd.g_old_rec.attribute7
254: ,p_attribute8_o =>per_pdm_shd.g_old_rec.attribute8
255: ,p_attribute9_o =>per_pdm_shd.g_old_rec.attribute9
256: ,p_attribute10_o =>per_pdm_shd.g_old_rec.attribute10
257: ,p_attribute11_o =>per_pdm_shd.g_old_rec.attribute11

Line 254: ,p_attribute8_o =>per_pdm_shd.g_old_rec.attribute8

250: ,p_attribute4_o =>per_pdm_shd.g_old_rec.attribute4
251: ,p_attribute5_o =>per_pdm_shd.g_old_rec.attribute5
252: ,p_attribute6_o =>per_pdm_shd.g_old_rec.attribute6
253: ,p_attribute7_o =>per_pdm_shd.g_old_rec.attribute7
254: ,p_attribute8_o =>per_pdm_shd.g_old_rec.attribute8
255: ,p_attribute9_o =>per_pdm_shd.g_old_rec.attribute9
256: ,p_attribute10_o =>per_pdm_shd.g_old_rec.attribute10
257: ,p_attribute11_o =>per_pdm_shd.g_old_rec.attribute11
258: ,p_attribute12_o =>per_pdm_shd.g_old_rec.attribute12

Line 255: ,p_attribute9_o =>per_pdm_shd.g_old_rec.attribute9

251: ,p_attribute5_o =>per_pdm_shd.g_old_rec.attribute5
252: ,p_attribute6_o =>per_pdm_shd.g_old_rec.attribute6
253: ,p_attribute7_o =>per_pdm_shd.g_old_rec.attribute7
254: ,p_attribute8_o =>per_pdm_shd.g_old_rec.attribute8
255: ,p_attribute9_o =>per_pdm_shd.g_old_rec.attribute9
256: ,p_attribute10_o =>per_pdm_shd.g_old_rec.attribute10
257: ,p_attribute11_o =>per_pdm_shd.g_old_rec.attribute11
258: ,p_attribute12_o =>per_pdm_shd.g_old_rec.attribute12
259: ,p_attribute13_o =>per_pdm_shd.g_old_rec.attribute13

Line 256: ,p_attribute10_o =>per_pdm_shd.g_old_rec.attribute10

252: ,p_attribute6_o =>per_pdm_shd.g_old_rec.attribute6
253: ,p_attribute7_o =>per_pdm_shd.g_old_rec.attribute7
254: ,p_attribute8_o =>per_pdm_shd.g_old_rec.attribute8
255: ,p_attribute9_o =>per_pdm_shd.g_old_rec.attribute9
256: ,p_attribute10_o =>per_pdm_shd.g_old_rec.attribute10
257: ,p_attribute11_o =>per_pdm_shd.g_old_rec.attribute11
258: ,p_attribute12_o =>per_pdm_shd.g_old_rec.attribute12
259: ,p_attribute13_o =>per_pdm_shd.g_old_rec.attribute13
260: ,p_attribute14_o =>per_pdm_shd.g_old_rec.attribute14

Line 257: ,p_attribute11_o =>per_pdm_shd.g_old_rec.attribute11

253: ,p_attribute7_o =>per_pdm_shd.g_old_rec.attribute7
254: ,p_attribute8_o =>per_pdm_shd.g_old_rec.attribute8
255: ,p_attribute9_o =>per_pdm_shd.g_old_rec.attribute9
256: ,p_attribute10_o =>per_pdm_shd.g_old_rec.attribute10
257: ,p_attribute11_o =>per_pdm_shd.g_old_rec.attribute11
258: ,p_attribute12_o =>per_pdm_shd.g_old_rec.attribute12
259: ,p_attribute13_o =>per_pdm_shd.g_old_rec.attribute13
260: ,p_attribute14_o =>per_pdm_shd.g_old_rec.attribute14
261: ,p_attribute15_o =>per_pdm_shd.g_old_rec.attribute15

Line 258: ,p_attribute12_o =>per_pdm_shd.g_old_rec.attribute12

254: ,p_attribute8_o =>per_pdm_shd.g_old_rec.attribute8
255: ,p_attribute9_o =>per_pdm_shd.g_old_rec.attribute9
256: ,p_attribute10_o =>per_pdm_shd.g_old_rec.attribute10
257: ,p_attribute11_o =>per_pdm_shd.g_old_rec.attribute11
258: ,p_attribute12_o =>per_pdm_shd.g_old_rec.attribute12
259: ,p_attribute13_o =>per_pdm_shd.g_old_rec.attribute13
260: ,p_attribute14_o =>per_pdm_shd.g_old_rec.attribute14
261: ,p_attribute15_o =>per_pdm_shd.g_old_rec.attribute15
262: ,p_attribute16_o =>per_pdm_shd.g_old_rec.attribute16

Line 259: ,p_attribute13_o =>per_pdm_shd.g_old_rec.attribute13

255: ,p_attribute9_o =>per_pdm_shd.g_old_rec.attribute9
256: ,p_attribute10_o =>per_pdm_shd.g_old_rec.attribute10
257: ,p_attribute11_o =>per_pdm_shd.g_old_rec.attribute11
258: ,p_attribute12_o =>per_pdm_shd.g_old_rec.attribute12
259: ,p_attribute13_o =>per_pdm_shd.g_old_rec.attribute13
260: ,p_attribute14_o =>per_pdm_shd.g_old_rec.attribute14
261: ,p_attribute15_o =>per_pdm_shd.g_old_rec.attribute15
262: ,p_attribute16_o =>per_pdm_shd.g_old_rec.attribute16
263: ,p_attribute17_o =>per_pdm_shd.g_old_rec.attribute17

Line 260: ,p_attribute14_o =>per_pdm_shd.g_old_rec.attribute14

256: ,p_attribute10_o =>per_pdm_shd.g_old_rec.attribute10
257: ,p_attribute11_o =>per_pdm_shd.g_old_rec.attribute11
258: ,p_attribute12_o =>per_pdm_shd.g_old_rec.attribute12
259: ,p_attribute13_o =>per_pdm_shd.g_old_rec.attribute13
260: ,p_attribute14_o =>per_pdm_shd.g_old_rec.attribute14
261: ,p_attribute15_o =>per_pdm_shd.g_old_rec.attribute15
262: ,p_attribute16_o =>per_pdm_shd.g_old_rec.attribute16
263: ,p_attribute17_o =>per_pdm_shd.g_old_rec.attribute17
264: ,p_attribute18_o =>per_pdm_shd.g_old_rec.attribute18

Line 261: ,p_attribute15_o =>per_pdm_shd.g_old_rec.attribute15

257: ,p_attribute11_o =>per_pdm_shd.g_old_rec.attribute11
258: ,p_attribute12_o =>per_pdm_shd.g_old_rec.attribute12
259: ,p_attribute13_o =>per_pdm_shd.g_old_rec.attribute13
260: ,p_attribute14_o =>per_pdm_shd.g_old_rec.attribute14
261: ,p_attribute15_o =>per_pdm_shd.g_old_rec.attribute15
262: ,p_attribute16_o =>per_pdm_shd.g_old_rec.attribute16
263: ,p_attribute17_o =>per_pdm_shd.g_old_rec.attribute17
264: ,p_attribute18_o =>per_pdm_shd.g_old_rec.attribute18
265: ,p_attribute19_o =>per_pdm_shd.g_old_rec.attribute19

Line 262: ,p_attribute16_o =>per_pdm_shd.g_old_rec.attribute16

258: ,p_attribute12_o =>per_pdm_shd.g_old_rec.attribute12
259: ,p_attribute13_o =>per_pdm_shd.g_old_rec.attribute13
260: ,p_attribute14_o =>per_pdm_shd.g_old_rec.attribute14
261: ,p_attribute15_o =>per_pdm_shd.g_old_rec.attribute15
262: ,p_attribute16_o =>per_pdm_shd.g_old_rec.attribute16
263: ,p_attribute17_o =>per_pdm_shd.g_old_rec.attribute17
264: ,p_attribute18_o =>per_pdm_shd.g_old_rec.attribute18
265: ,p_attribute19_o =>per_pdm_shd.g_old_rec.attribute19
266: ,p_attribute20_o =>per_pdm_shd.g_old_rec.attribute20

Line 263: ,p_attribute17_o =>per_pdm_shd.g_old_rec.attribute17

259: ,p_attribute13_o =>per_pdm_shd.g_old_rec.attribute13
260: ,p_attribute14_o =>per_pdm_shd.g_old_rec.attribute14
261: ,p_attribute15_o =>per_pdm_shd.g_old_rec.attribute15
262: ,p_attribute16_o =>per_pdm_shd.g_old_rec.attribute16
263: ,p_attribute17_o =>per_pdm_shd.g_old_rec.attribute17
264: ,p_attribute18_o =>per_pdm_shd.g_old_rec.attribute18
265: ,p_attribute19_o =>per_pdm_shd.g_old_rec.attribute19
266: ,p_attribute20_o =>per_pdm_shd.g_old_rec.attribute20
267: );

Line 264: ,p_attribute18_o =>per_pdm_shd.g_old_rec.attribute18

260: ,p_attribute14_o =>per_pdm_shd.g_old_rec.attribute14
261: ,p_attribute15_o =>per_pdm_shd.g_old_rec.attribute15
262: ,p_attribute16_o =>per_pdm_shd.g_old_rec.attribute16
263: ,p_attribute17_o =>per_pdm_shd.g_old_rec.attribute17
264: ,p_attribute18_o =>per_pdm_shd.g_old_rec.attribute18
265: ,p_attribute19_o =>per_pdm_shd.g_old_rec.attribute19
266: ,p_attribute20_o =>per_pdm_shd.g_old_rec.attribute20
267: );
268: --

Line 265: ,p_attribute19_o =>per_pdm_shd.g_old_rec.attribute19

261: ,p_attribute15_o =>per_pdm_shd.g_old_rec.attribute15
262: ,p_attribute16_o =>per_pdm_shd.g_old_rec.attribute16
263: ,p_attribute17_o =>per_pdm_shd.g_old_rec.attribute17
264: ,p_attribute18_o =>per_pdm_shd.g_old_rec.attribute18
265: ,p_attribute19_o =>per_pdm_shd.g_old_rec.attribute19
266: ,p_attribute20_o =>per_pdm_shd.g_old_rec.attribute20
267: );
268: --
269: exception

Line 266: ,p_attribute20_o =>per_pdm_shd.g_old_rec.attribute20

262: ,p_attribute16_o =>per_pdm_shd.g_old_rec.attribute16
263: ,p_attribute17_o =>per_pdm_shd.g_old_rec.attribute17
264: ,p_attribute18_o =>per_pdm_shd.g_old_rec.attribute18
265: ,p_attribute19_o =>per_pdm_shd.g_old_rec.attribute19
266: ,p_attribute20_o =>per_pdm_shd.g_old_rec.attribute20
267: );
268: --
269: exception
270: --

Line 328: Procedure convert_defs(p_rec in out nocopy per_pdm_shd.g_rec_type) is

324: -- Internal Row Handler Use Only.
325: --
326: -- {End Of Comments}
327: -- ----------------------------------------------------------------------------
328: Procedure convert_defs(p_rec in out nocopy per_pdm_shd.g_rec_type) is
329: --
330: l_proc varchar2(72) := g_package||'convert_defs';
331: --
332: Begin

Line 343: per_pdm_shd.g_old_rec.person_id;

339: -- is being used then we must set to the 'current' argument value.
340: --
341: If (p_rec.person_id = hr_api.g_number) then
342: p_rec.person_id :=
343: per_pdm_shd.g_old_rec.person_id;
344: End If;
345: If (p_rec.date_start = hr_api.g_date) then
346: p_rec.date_start :=
347: per_pdm_shd.g_old_rec.date_start;

Line 347: per_pdm_shd.g_old_rec.date_start;

343: per_pdm_shd.g_old_rec.person_id;
344: End If;
345: If (p_rec.date_start = hr_api.g_date) then
346: p_rec.date_start :=
347: per_pdm_shd.g_old_rec.date_start;
348: End If;
349: If (p_rec.date_end = hr_api.g_date) then
350: p_rec.date_end :=
351: per_pdm_shd.g_old_rec.date_end;

Line 351: per_pdm_shd.g_old_rec.date_end;

347: per_pdm_shd.g_old_rec.date_start;
348: End If;
349: If (p_rec.date_end = hr_api.g_date) then
350: p_rec.date_end :=
351: per_pdm_shd.g_old_rec.date_end;
352: End If;
353: If (p_rec.comm_dlvry_method = hr_api.g_varchar2) then
354: p_rec.comm_dlvry_method :=
355: per_pdm_shd.g_old_rec.comm_dlvry_method;

Line 355: per_pdm_shd.g_old_rec.comm_dlvry_method;

351: per_pdm_shd.g_old_rec.date_end;
352: End If;
353: If (p_rec.comm_dlvry_method = hr_api.g_varchar2) then
354: p_rec.comm_dlvry_method :=
355: per_pdm_shd.g_old_rec.comm_dlvry_method;
356: End If;
357: If (p_rec.preferred_flag = hr_api.g_varchar2) then
358: p_rec.preferred_flag :=
359: per_pdm_shd.g_old_rec.preferred_flag;

Line 359: per_pdm_shd.g_old_rec.preferred_flag;

355: per_pdm_shd.g_old_rec.comm_dlvry_method;
356: End If;
357: If (p_rec.preferred_flag = hr_api.g_varchar2) then
358: p_rec.preferred_flag :=
359: per_pdm_shd.g_old_rec.preferred_flag;
360: End If;
361: If (p_rec.request_id = hr_api.g_number) then
362: p_rec.request_id :=
363: per_pdm_shd.g_old_rec.request_id;

Line 363: per_pdm_shd.g_old_rec.request_id;

359: per_pdm_shd.g_old_rec.preferred_flag;
360: End If;
361: If (p_rec.request_id = hr_api.g_number) then
362: p_rec.request_id :=
363: per_pdm_shd.g_old_rec.request_id;
364: End If;
365: If (p_rec.program_update_date = hr_api.g_date) then
366: p_rec.program_update_date :=
367: per_pdm_shd.g_old_rec.program_update_date;

Line 367: per_pdm_shd.g_old_rec.program_update_date;

363: per_pdm_shd.g_old_rec.request_id;
364: End If;
365: If (p_rec.program_update_date = hr_api.g_date) then
366: p_rec.program_update_date :=
367: per_pdm_shd.g_old_rec.program_update_date;
368: End If;
369: If (p_rec.program_application_id = hr_api.g_number) then
370: p_rec.program_application_id :=
371: per_pdm_shd.g_old_rec.program_application_id;

Line 371: per_pdm_shd.g_old_rec.program_application_id;

367: per_pdm_shd.g_old_rec.program_update_date;
368: End If;
369: If (p_rec.program_application_id = hr_api.g_number) then
370: p_rec.program_application_id :=
371: per_pdm_shd.g_old_rec.program_application_id;
372: End If;
373: If (p_rec.program_id = hr_api.g_number) then
374: p_rec.program_id :=
375: per_pdm_shd.g_old_rec.program_id;

Line 375: per_pdm_shd.g_old_rec.program_id;

371: per_pdm_shd.g_old_rec.program_application_id;
372: End If;
373: If (p_rec.program_id = hr_api.g_number) then
374: p_rec.program_id :=
375: per_pdm_shd.g_old_rec.program_id;
376: End If;
377: If (p_rec.attribute_category = hr_api.g_varchar2) then
378: p_rec.attribute_category :=
379: per_pdm_shd.g_old_rec.attribute_category;

Line 379: per_pdm_shd.g_old_rec.attribute_category;

375: per_pdm_shd.g_old_rec.program_id;
376: End If;
377: If (p_rec.attribute_category = hr_api.g_varchar2) then
378: p_rec.attribute_category :=
379: per_pdm_shd.g_old_rec.attribute_category;
380: End If;
381: If (p_rec.attribute1 = hr_api.g_varchar2) then
382: p_rec.attribute1 :=
383: per_pdm_shd.g_old_rec.attribute1;

Line 383: per_pdm_shd.g_old_rec.attribute1;

379: per_pdm_shd.g_old_rec.attribute_category;
380: End If;
381: If (p_rec.attribute1 = hr_api.g_varchar2) then
382: p_rec.attribute1 :=
383: per_pdm_shd.g_old_rec.attribute1;
384: End If;
385: If (p_rec.attribute2 = hr_api.g_varchar2) then
386: p_rec.attribute2 :=
387: per_pdm_shd.g_old_rec.attribute2;

Line 387: per_pdm_shd.g_old_rec.attribute2;

383: per_pdm_shd.g_old_rec.attribute1;
384: End If;
385: If (p_rec.attribute2 = hr_api.g_varchar2) then
386: p_rec.attribute2 :=
387: per_pdm_shd.g_old_rec.attribute2;
388: End If;
389: If (p_rec.attribute3 = hr_api.g_varchar2) then
390: p_rec.attribute3 :=
391: per_pdm_shd.g_old_rec.attribute3;

Line 391: per_pdm_shd.g_old_rec.attribute3;

387: per_pdm_shd.g_old_rec.attribute2;
388: End If;
389: If (p_rec.attribute3 = hr_api.g_varchar2) then
390: p_rec.attribute3 :=
391: per_pdm_shd.g_old_rec.attribute3;
392: End If;
393: If (p_rec.attribute4 = hr_api.g_varchar2) then
394: p_rec.attribute4 :=
395: per_pdm_shd.g_old_rec.attribute4;

Line 395: per_pdm_shd.g_old_rec.attribute4;

391: per_pdm_shd.g_old_rec.attribute3;
392: End If;
393: If (p_rec.attribute4 = hr_api.g_varchar2) then
394: p_rec.attribute4 :=
395: per_pdm_shd.g_old_rec.attribute4;
396: End If;
397: If (p_rec.attribute5 = hr_api.g_varchar2) then
398: p_rec.attribute5 :=
399: per_pdm_shd.g_old_rec.attribute5;

Line 399: per_pdm_shd.g_old_rec.attribute5;

395: per_pdm_shd.g_old_rec.attribute4;
396: End If;
397: If (p_rec.attribute5 = hr_api.g_varchar2) then
398: p_rec.attribute5 :=
399: per_pdm_shd.g_old_rec.attribute5;
400: End If;
401: If (p_rec.attribute6 = hr_api.g_varchar2) then
402: p_rec.attribute6 :=
403: per_pdm_shd.g_old_rec.attribute6;

Line 403: per_pdm_shd.g_old_rec.attribute6;

399: per_pdm_shd.g_old_rec.attribute5;
400: End If;
401: If (p_rec.attribute6 = hr_api.g_varchar2) then
402: p_rec.attribute6 :=
403: per_pdm_shd.g_old_rec.attribute6;
404: End If;
405: If (p_rec.attribute7 = hr_api.g_varchar2) then
406: p_rec.attribute7 :=
407: per_pdm_shd.g_old_rec.attribute7;

Line 407: per_pdm_shd.g_old_rec.attribute7;

403: per_pdm_shd.g_old_rec.attribute6;
404: End If;
405: If (p_rec.attribute7 = hr_api.g_varchar2) then
406: p_rec.attribute7 :=
407: per_pdm_shd.g_old_rec.attribute7;
408: End If;
409: If (p_rec.attribute8 = hr_api.g_varchar2) then
410: p_rec.attribute8 :=
411: per_pdm_shd.g_old_rec.attribute8;

Line 411: per_pdm_shd.g_old_rec.attribute8;

407: per_pdm_shd.g_old_rec.attribute7;
408: End If;
409: If (p_rec.attribute8 = hr_api.g_varchar2) then
410: p_rec.attribute8 :=
411: per_pdm_shd.g_old_rec.attribute8;
412: End If;
413: If (p_rec.attribute9 = hr_api.g_varchar2) then
414: p_rec.attribute9 :=
415: per_pdm_shd.g_old_rec.attribute9;

Line 415: per_pdm_shd.g_old_rec.attribute9;

411: per_pdm_shd.g_old_rec.attribute8;
412: End If;
413: If (p_rec.attribute9 = hr_api.g_varchar2) then
414: p_rec.attribute9 :=
415: per_pdm_shd.g_old_rec.attribute9;
416: End If;
417: If (p_rec.attribute10 = hr_api.g_varchar2) then
418: p_rec.attribute10 :=
419: per_pdm_shd.g_old_rec.attribute10;

Line 419: per_pdm_shd.g_old_rec.attribute10;

415: per_pdm_shd.g_old_rec.attribute9;
416: End If;
417: If (p_rec.attribute10 = hr_api.g_varchar2) then
418: p_rec.attribute10 :=
419: per_pdm_shd.g_old_rec.attribute10;
420: End If;
421: If (p_rec.attribute11 = hr_api.g_varchar2) then
422: p_rec.attribute11 :=
423: per_pdm_shd.g_old_rec.attribute11;

Line 423: per_pdm_shd.g_old_rec.attribute11;

419: per_pdm_shd.g_old_rec.attribute10;
420: End If;
421: If (p_rec.attribute11 = hr_api.g_varchar2) then
422: p_rec.attribute11 :=
423: per_pdm_shd.g_old_rec.attribute11;
424: End If;
425: If (p_rec.attribute12 = hr_api.g_varchar2) then
426: p_rec.attribute12 :=
427: per_pdm_shd.g_old_rec.attribute12;

Line 427: per_pdm_shd.g_old_rec.attribute12;

423: per_pdm_shd.g_old_rec.attribute11;
424: End If;
425: If (p_rec.attribute12 = hr_api.g_varchar2) then
426: p_rec.attribute12 :=
427: per_pdm_shd.g_old_rec.attribute12;
428: End If;
429: If (p_rec.attribute13 = hr_api.g_varchar2) then
430: p_rec.attribute13 :=
431: per_pdm_shd.g_old_rec.attribute13;

Line 431: per_pdm_shd.g_old_rec.attribute13;

427: per_pdm_shd.g_old_rec.attribute12;
428: End If;
429: If (p_rec.attribute13 = hr_api.g_varchar2) then
430: p_rec.attribute13 :=
431: per_pdm_shd.g_old_rec.attribute13;
432: End If;
433: If (p_rec.attribute14 = hr_api.g_varchar2) then
434: p_rec.attribute14 :=
435: per_pdm_shd.g_old_rec.attribute14;

Line 435: per_pdm_shd.g_old_rec.attribute14;

431: per_pdm_shd.g_old_rec.attribute13;
432: End If;
433: If (p_rec.attribute14 = hr_api.g_varchar2) then
434: p_rec.attribute14 :=
435: per_pdm_shd.g_old_rec.attribute14;
436: End If;
437: If (p_rec.attribute15 = hr_api.g_varchar2) then
438: p_rec.attribute15 :=
439: per_pdm_shd.g_old_rec.attribute15;

Line 439: per_pdm_shd.g_old_rec.attribute15;

435: per_pdm_shd.g_old_rec.attribute14;
436: End If;
437: If (p_rec.attribute15 = hr_api.g_varchar2) then
438: p_rec.attribute15 :=
439: per_pdm_shd.g_old_rec.attribute15;
440: End If;
441: If (p_rec.attribute16 = hr_api.g_varchar2) then
442: p_rec.attribute16 :=
443: per_pdm_shd.g_old_rec.attribute16;

Line 443: per_pdm_shd.g_old_rec.attribute16;

439: per_pdm_shd.g_old_rec.attribute15;
440: End If;
441: If (p_rec.attribute16 = hr_api.g_varchar2) then
442: p_rec.attribute16 :=
443: per_pdm_shd.g_old_rec.attribute16;
444: End If;
445: If (p_rec.attribute17 = hr_api.g_varchar2) then
446: p_rec.attribute17 :=
447: per_pdm_shd.g_old_rec.attribute17;

Line 447: per_pdm_shd.g_old_rec.attribute17;

443: per_pdm_shd.g_old_rec.attribute16;
444: End If;
445: If (p_rec.attribute17 = hr_api.g_varchar2) then
446: p_rec.attribute17 :=
447: per_pdm_shd.g_old_rec.attribute17;
448: End If;
449: If (p_rec.attribute18 = hr_api.g_varchar2) then
450: p_rec.attribute18 :=
451: per_pdm_shd.g_old_rec.attribute18;

Line 451: per_pdm_shd.g_old_rec.attribute18;

447: per_pdm_shd.g_old_rec.attribute17;
448: End If;
449: If (p_rec.attribute18 = hr_api.g_varchar2) then
450: p_rec.attribute18 :=
451: per_pdm_shd.g_old_rec.attribute18;
452: End If;
453: If (p_rec.attribute19 = hr_api.g_varchar2) then
454: p_rec.attribute19 :=
455: per_pdm_shd.g_old_rec.attribute19;

Line 455: per_pdm_shd.g_old_rec.attribute19;

451: per_pdm_shd.g_old_rec.attribute18;
452: End If;
453: If (p_rec.attribute19 = hr_api.g_varchar2) then
454: p_rec.attribute19 :=
455: per_pdm_shd.g_old_rec.attribute19;
456: End If;
457: If (p_rec.attribute20 = hr_api.g_varchar2) then
458: p_rec.attribute20 :=
459: per_pdm_shd.g_old_rec.attribute20;

Line 459: per_pdm_shd.g_old_rec.attribute20;

455: per_pdm_shd.g_old_rec.attribute19;
456: End If;
457: If (p_rec.attribute20 = hr_api.g_varchar2) then
458: p_rec.attribute20 :=
459: per_pdm_shd.g_old_rec.attribute20;
460: End If;
461: --
462: hr_utility.set_location(' Leaving:'||l_proc, 10);
463: --

Line 472: p_rec in out nocopy per_pdm_shd.g_rec_type

468: -- ----------------------------------------------------------------------------
469: Procedure upd
470: (
471: p_effective_date in date,
472: p_rec in out nocopy per_pdm_shd.g_rec_type
473: ) is
474: --
475: l_proc varchar2(72) := g_package||'upd';
476: --

Line 482: per_pdm_shd.lck

478: hr_utility.set_location('Entering:'||l_proc, 5);
479: --
480: -- We must lock the row which we need to update.
481: --
482: per_pdm_shd.lck
483: (
484: p_rec.delivery_method_id,
485: p_rec.object_version_number
486: );

Line 550: l_rec per_pdm_shd.g_rec_type;

546: p_attribute19 in varchar2 default hr_api.g_varchar2,
547: p_attribute20 in varchar2 default hr_api.g_varchar2
548: ) is
549: --
550: l_rec per_pdm_shd.g_rec_type;
551: l_proc varchar2(72) := g_package||'upd';
552: --
553: Begin
554: hr_utility.set_location('Entering:'||l_proc, 5);

Line 560: per_pdm_shd.convert_args

556: -- Call conversion function to turn arguments into the
557: -- l_rec structure.
558: --
559: l_rec :=
560: per_pdm_shd.convert_args
561: (
562: p_delivery_method_id,
563: p_date_start,
564: p_date_end,