DBA Data[Home] [Help]

APPS.PER_PER_INS dependencies on PER_PER_SHD

Line 81: (p_rec in out nocopy per_per_shd.g_rec_type,

77: --
78: -- {End Of Comments}
79: -- ----------------------------------------------------------------------------
80: Procedure dt_insert_dml
81: (p_rec in out nocopy per_per_shd.g_rec_type,
82: p_effective_date in date,
83: p_datetrack_mode in varchar2,
84: p_validation_start_date in date,
85: p_validation_end_date in date) is

Line 95: per_per_shd.g_old_rec.effective_start_date

91: t.creation_date
92: from per_all_people_f t
93: where t.person_id = p_rec.person_id
94: and t.effective_start_date =
95: per_per_shd.g_old_rec.effective_start_date
96: and t.effective_end_date = (p_validation_start_date - 1);
97: --
98: l_proc varchar2(72) := g_package||'dt_insert_dml';
99: l_created_by per_all_people_f.created_by%TYPE;

Line 162: per_per_shd.g_api_dml := true; -- Set the api dml status

158: l_last_updated_by := fnd_global.user_id;
159: l_last_update_login := fnd_global.login_id;
160: End If;
161: --
162: per_per_shd.g_api_dml := true; -- Set the api dml status
163: --
164: -- Insert the row into: per_all_people_f
165: --
166: insert into per_all_people_f

Line 515: per_per_shd.g_api_dml := false; -- Unset the api dml status

511: hr_utility.set_location('Updating party id',10);
512: --
513: end if;
514: --
515: per_per_shd.g_api_dml := false; -- Unset the api dml status
516: hr_utility.set_location(' Leaving:'||l_proc, 15);
517: --
518: Exception
519: When hr_api.check_integrity_violated Then

Line 521: per_per_shd.g_api_dml := false; -- Unset the api dml status

517: --
518: Exception
519: When hr_api.check_integrity_violated Then
520: -- A check constraint has been violated
521: per_per_shd.g_api_dml := false; -- Unset the api dml status
522: per_per_shd.constraint_error
523: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
524: When hr_api.unique_integrity_violated Then
525: -- Unique integrity has been violated

Line 522: per_per_shd.constraint_error

518: Exception
519: When hr_api.check_integrity_violated Then
520: -- A check constraint has been violated
521: per_per_shd.g_api_dml := false; -- Unset the api dml status
522: per_per_shd.constraint_error
523: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
524: When hr_api.unique_integrity_violated Then
525: -- Unique integrity has been violated
526: per_per_shd.g_api_dml := false; -- Unset the api dml status

Line 526: per_per_shd.g_api_dml := false; -- Unset the api dml status

522: per_per_shd.constraint_error
523: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
524: When hr_api.unique_integrity_violated Then
525: -- Unique integrity has been violated
526: per_per_shd.g_api_dml := false; -- Unset the api dml status
527: per_per_shd.constraint_error
528: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
529: When Others Then
530: per_per_shd.g_api_dml := false; -- Unset the api dml status

Line 527: per_per_shd.constraint_error

523: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
524: When hr_api.unique_integrity_violated Then
525: -- Unique integrity has been violated
526: per_per_shd.g_api_dml := false; -- Unset the api dml status
527: per_per_shd.constraint_error
528: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
529: When Others Then
530: per_per_shd.g_api_dml := false; -- Unset the api dml status
531: Raise;

Line 530: per_per_shd.g_api_dml := false; -- Unset the api dml status

526: per_per_shd.g_api_dml := false; -- Unset the api dml status
527: per_per_shd.constraint_error
528: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
529: When Others Then
530: per_per_shd.g_api_dml := false; -- Unset the api dml status
531: Raise;
532: End dt_insert_dml;
533: --
534: -- ----------------------------------------------------------------------------

Line 538: (p_rec in out nocopy per_per_shd.g_rec_type,

534: -- ----------------------------------------------------------------------------
535: -- |------------------------------< insert_dml >------------------------------|
536: -- ----------------------------------------------------------------------------
537: Procedure insert_dml
538: (p_rec in out nocopy per_per_shd.g_rec_type,
539: p_effective_date in date,
540: p_datetrack_mode in varchar2,
541: p_validation_start_date in date,
542: p_validation_end_date in date) is

Line 598: (p_rec in out nocopy per_per_shd.g_rec_type,

594: --
595: -- {End Of Comments}
596: -- ----------------------------------------------------------------------------
597: Procedure pre_insert
598: (p_rec in out nocopy per_per_shd.g_rec_type,
599: p_effective_date in date,
600: p_datetrack_mode in varchar2,
601: p_validation_start_date in date,
602: p_validation_end_date in date) is

Line 696: (p_rec in per_per_shd.g_rec_type,

692: --
693: -- {End Of Comments}
694: -- ----------------------------------------------------------------------------
695: Procedure post_insert
696: (p_rec in per_per_shd.g_rec_type,
697: p_effective_date in date,
698: p_datetrack_mode in varchar2,
699: p_validation_start_date in date,
700: p_validation_end_date in date,

Line 992: p_rec in per_per_shd.g_rec_type,

988: -- ----------------------------------------------------------------------------
989: Procedure ins_lck
990: (p_effective_date in date,
991: p_datetrack_mode in varchar2,
992: p_rec in per_per_shd.g_rec_type,
993: p_validation_start_date out nocopy date,
994: p_validation_end_date out nocopy date) is
995: --
996: l_proc varchar2(72) := g_package||'ins_lck';

Line 1030: p_rec in out nocopy per_per_shd.g_rec_type,

1026: -- |---------------------------------< ins >----------------------------------|
1027: -- ----------------------------------------------------------------------------
1028: Procedure ins
1029: (
1030: p_rec in out nocopy per_per_shd.g_rec_type,
1031: p_effective_date in date,
1032: p_validate in boolean default false,
1033: p_name_combination_warning out nocopy boolean,
1034: p_dob_null_warning out nocopy boolean,

Line 1414: l_rec per_per_shd.g_rec_type;

1410: p_orig_hire_warning out nocopy boolean
1411: )
1412: is
1413: --
1414: l_rec per_per_shd.g_rec_type;
1415: l_proc varchar2(72) := g_package||'ins';
1416: --
1417: Begin
1418: hr_utility.set_location('Entering:'||l_proc, 5);

Line 1424: per_per_shd.convert_args

1420: -- Call conversion function to turn arguments into the
1421: -- p_rec structure.
1422: --
1423: l_rec :=
1424: per_per_shd.convert_args
1425: (
1426: null,
1427: null,
1428: null,