54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_insert_dml
58: (p_rec in out nocopy per_asg_shd.g_rec_type,
59: p_effective_date in date,
60: p_datetrack_mode in varchar2,
61: p_validation_start_date in date,
62: p_validation_end_date in date
69: asg.creation_date
70: from per_all_assignments_f asg
71: where asg.assignment_id = p_rec.assignment_id
72: and asg.effective_start_date =
73: per_asg_shd.g_old_rec.effective_start_date
74: and asg.effective_end_date = (p_validation_start_date - 1);
75: --
76: l_proc varchar2(72) := g_package||'dt_insert_dml';
77: l_created_by per_all_assignments_f.created_by%TYPE;
126: l_last_updated_by := fnd_global.user_id;
127: l_last_update_login := fnd_global.login_id;
128: End If;
129: --
130: per_asg_shd.g_api_dml := true; -- Set the api dml status
131: --
132: -- Insert the row into: per_all_assignments_f
133: --
134: insert into per_all_assignments_f
355: p_rec.project_title,
356: p_rec.applicant_rank
357: );
358: --
359: per_asg_shd.g_api_dml := false; -- Unset the api dml status
360: hr_utility.set_location(' Leaving:'||l_proc, 15);
361: --
362: Exception
363: When hr_api.check_integrity_violated Then
361: --
362: Exception
363: When hr_api.check_integrity_violated Then
364: -- A check constraint has been violated
365: per_asg_shd.g_api_dml := false; -- Unset the api dml status
366: per_asg_shd.constraint_error
367: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
368: When hr_api.unique_integrity_violated Then
369: -- Unique integrity has been violated
362: Exception
363: When hr_api.check_integrity_violated Then
364: -- A check constraint has been violated
365: per_asg_shd.g_api_dml := false; -- Unset the api dml status
366: per_asg_shd.constraint_error
367: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
368: When hr_api.unique_integrity_violated Then
369: -- Unique integrity has been violated
370: per_asg_shd.g_api_dml := false; -- Unset the api dml status
366: per_asg_shd.constraint_error
367: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
368: When hr_api.unique_integrity_violated Then
369: -- Unique integrity has been violated
370: per_asg_shd.g_api_dml := false; -- Unset the api dml status
371: per_asg_shd.constraint_error
372: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
373: When Others Then
374: per_asg_shd.g_api_dml := false; -- Unset the api dml status
367: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
368: When hr_api.unique_integrity_violated Then
369: -- Unique integrity has been violated
370: per_asg_shd.g_api_dml := false; -- Unset the api dml status
371: per_asg_shd.constraint_error
372: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
373: When Others Then
374: per_asg_shd.g_api_dml := false; -- Unset the api dml status
375: Raise;
370: per_asg_shd.g_api_dml := false; -- Unset the api dml status
371: per_asg_shd.constraint_error
372: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
373: When Others Then
374: per_asg_shd.g_api_dml := false; -- Unset the api dml status
375: Raise;
376: End dt_insert_dml;
377: --
378: -- ----------------------------------------------------------------------------
378: -- ----------------------------------------------------------------------------
379: -- |------------------------------< insert_dml >------------------------------|
380: -- ----------------------------------------------------------------------------
381: Procedure insert_dml
382: (p_rec in out nocopy per_asg_shd.g_rec_type,
383: p_effective_date in date,
384: p_datetrack_mode in varchar2,
385: p_validation_start_date in date,
386: p_validation_end_date in date) is
438: --
439: -- {End Of Comments}
440: -- ----------------------------------------------------------------------------
441: Procedure pre_insert
442: (p_rec in out nocopy per_asg_shd.g_rec_type,
443: p_effective_date in date,
444: p_datetrack_mode in varchar2,
445: p_validation_start_date in date,
446: p_validation_end_date in date) is
523: --
524: -- {End Of Comments}
525: -- ----------------------------------------------------------------------------
526: Procedure post_insert
527: (p_rec in per_asg_shd.g_rec_type,
528: p_effective_date in date,
529: p_datetrack_mode in varchar2,
530: p_validation_start_date in date,
531: p_validation_end_date in date) is
766: -- ----------------------------------------------------------------------------
767: Procedure ins_lck
768: (p_effective_date in date,
769: p_datetrack_mode in varchar2,
770: p_rec in per_asg_shd.g_rec_type,
771: p_validation_start_date out nocopy date,
772: p_validation_end_date out nocopy date) is
773: --
774: l_proc varchar2(72) := g_package||'ins_lck';
816: -- |---------------------------------< ins >----------------------------------|
817: -- ----------------------------------------------------------------------------
818: Procedure ins
819: (
820: p_rec in out nocopy per_asg_shd.g_rec_type,
821: p_effective_date in date,
822: p_validate in boolean default false,
823: p_validate_df_flex in boolean default true,
824: p_other_manager_warning out nocopy boolean,
1072: p_applicant_rank in number default null
1073: )
1074: is
1075: --
1076: l_rec per_asg_shd.g_rec_type;
1077: l_proc varchar2(72) := g_package||'ins';
1078: --
1079: Begin
1080: hr_utility.set_location('Entering:'||l_proc, 5);
1082: -- Call conversion function to turn arguments into the
1083: -- p_rec structure.
1084: --
1085: l_rec :=
1086: per_asg_shd.convert_args
1087: (
1088: null,
1089: null,
1090: null,