DBA Data[Home] [Help]

APPS.PER_PJO_INS dependencies on PER_PJO_SHD

Line 76: (p_rec in out nocopy per_pjo_shd.g_rec_type

72: --
73: -- {End Of Comments}
74: -- ----------------------------------------------------------------------------
75: Procedure insert_dml
76: (p_rec in out nocopy per_pjo_shd.g_rec_type
77: ) is
78: --
79: l_proc varchar2(72) := g_package||'insert_dml';
80: --

Line 249: per_pjo_shd.constraint_error

245: Exception
246: When hr_api.check_integrity_violated Then
247: -- A check constraint has been violated
248: --
249: per_pjo_shd.constraint_error
250: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
251: When hr_api.parent_integrity_violated Then
252: -- Parent integrity has been violated
253: --

Line 254: per_pjo_shd.constraint_error

250: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
251: When hr_api.parent_integrity_violated Then
252: -- Parent integrity has been violated
253: --
254: per_pjo_shd.constraint_error
255: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
256: When hr_api.unique_integrity_violated Then
257: -- Unique integrity has been violated
258: --

Line 259: per_pjo_shd.constraint_error

255: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
256: When hr_api.unique_integrity_violated Then
257: -- Unique integrity has been violated
258: --
259: per_pjo_shd.constraint_error
260: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
261: When Others Then
262: --
263: Raise;

Line 304: (p_rec in out nocopy per_pjo_shd.g_rec_type

300: --
301: -- {End Of Comments}
302: -- ----------------------------------------------------------------------------
303: Procedure pre_insert
304: (p_rec in out nocopy per_pjo_shd.g_rec_type
305: ) is
306: --
307: Cursor C_Sel1 is select per_previous_jobs_s.nextval from sys.dual;
308: --

Line 392: ,p_rec in per_pjo_shd.g_rec_type

388: -- {End Of Comments}
389: -- ----------------------------------------------------------------------------
390: Procedure post_insert
391: (p_effective_date in date
392: ,p_rec in per_pjo_shd.g_rec_type
393: ) is
394: --
395: l_proc varchar2(72) := g_package||'post_insert';
396: --

Line 571: ,p_rec in out nocopy per_pjo_shd.g_rec_type

567: -- |---------------------------------< ins >----------------------------------|
568: -- ----------------------------------------------------------------------------
569: Procedure ins
570: (p_effective_date in date
571: ,p_rec in out nocopy per_pjo_shd.g_rec_type
572: ) is
573: --
574: l_proc varchar2(72) := g_package||'ins';
575: --

Line 689: l_rec per_pjo_shd.g_rec_type;

685: ,p_previous_job_id out nocopy number
686: ,p_object_version_number out nocopy number
687: ) is
688: --
689: l_rec per_pjo_shd.g_rec_type;
690: l_proc varchar2(72) := g_package||'ins';
691: --
692: Begin
693: hr_utility.set_location('Entering:'||l_proc, 5);

Line 699: per_pjo_shd.convert_args

695: -- Call conversion function to turn arguments into the
696: -- p_rec structure.
697: --
698: l_rec :=
699: per_pjo_shd.convert_args
700: (null
701: ,p_previous_employer_id
702: ,p_start_date
703: ,p_end_date