[Home] [Help]
76: --
77: -- {End Of Comments}
78: -- ----------------------------------------------------------------------------
79: Procedure dt_insert_dml
80: (p_rec in out nocopy pay_pgr_shd.g_rec_type
81: ,p_effective_date in date
82: ,p_datetrack_mode in varchar2
83: ,p_validation_start_date in date
84: ,p_validation_end_date in date
90: t.creation_date
91: from pay_grade_rules_f t
92: where t.grade_rule_id = p_rec.grade_rule_id
93: and t.effective_start_date =
94: pay_pgr_shd.g_old_rec.effective_start_date
95: and t.effective_end_date = (p_validation_start_date - 1);
96: --
97: l_proc varchar2(72) := g_package||'dt_insert_dml';
98: l_created_by pay_grade_rules_f.created_by%TYPE;
151: l_last_updated_by := fnd_global.user_id;
152: l_last_update_login := fnd_global.login_id;
153: End If;
154: --
155: pay_pgr_shd.g_api_dml := true; -- Set the api dml status
156: --
157: -- Insert the row into: pay_grade_rules_f
158: --
159: hr_utility.set_location(l_proc, 30);
208: ,l_last_updated_by
209: ,l_last_update_login
210: );
211: --
212: pay_pgr_shd.g_api_dml := false; -- Unset the api dml status
213: hr_utility.set_location(' Leaving:'||l_proc, 15);
214: --
215: Exception
216: When hr_api.check_integrity_violated Then
214: --
215: Exception
216: When hr_api.check_integrity_violated Then
217: -- A check constraint has been violated
218: pay_pgr_shd.g_api_dml := false; -- Unset the api dml status
219: pay_pgr_shd.constraint_error
220: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
221: When hr_api.unique_integrity_violated Then
222: -- Unique integrity has been violated
215: Exception
216: When hr_api.check_integrity_violated Then
217: -- A check constraint has been violated
218: pay_pgr_shd.g_api_dml := false; -- Unset the api dml status
219: pay_pgr_shd.constraint_error
220: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
221: When hr_api.unique_integrity_violated Then
222: -- Unique integrity has been violated
223: pay_pgr_shd.g_api_dml := false; -- Unset the api dml status
219: pay_pgr_shd.constraint_error
220: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
221: When hr_api.unique_integrity_violated Then
222: -- Unique integrity has been violated
223: pay_pgr_shd.g_api_dml := false; -- Unset the api dml status
224: pay_pgr_shd.constraint_error
225: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
226: When Others Then
227: pay_pgr_shd.g_api_dml := false; -- Unset the api dml status
220: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
221: When hr_api.unique_integrity_violated Then
222: -- Unique integrity has been violated
223: pay_pgr_shd.g_api_dml := false; -- Unset the api dml status
224: pay_pgr_shd.constraint_error
225: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
226: When Others Then
227: pay_pgr_shd.g_api_dml := false; -- Unset the api dml status
228: Raise;
223: pay_pgr_shd.g_api_dml := false; -- Unset the api dml status
224: pay_pgr_shd.constraint_error
225: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
226: When Others Then
227: pay_pgr_shd.g_api_dml := false; -- Unset the api dml status
228: Raise;
229: End dt_insert_dml;
230: --
231: -- ----------------------------------------------------------------------------
231: -- ----------------------------------------------------------------------------
232: -- |------------------------------< insert_dml >------------------------------|
233: -- ----------------------------------------------------------------------------
234: Procedure insert_dml
235: (p_rec in out nocopy pay_pgr_shd.g_rec_type
236: ,p_effective_date in date
237: ,p_datetrack_mode in varchar2
238: ,p_validation_start_date in date
239: ,p_validation_end_date in date
294: --
295: -- {End Of Comments}
296: -- ----------------------------------------------------------------------------
297: Procedure pre_insert
298: (p_rec in out nocopy pay_pgr_shd.g_rec_type
299: ,p_effective_date in date
300: ,p_datetrack_mode in varchar2
301: ,p_validation_start_date in date
302: ,p_validation_end_date in date
419: --
420: -- {End Of Comments}
421: -- ----------------------------------------------------------------------------
422: Procedure post_insert
423: (p_rec in pay_pgr_shd.g_rec_type
424: ,p_effective_date in date
425: ,p_datetrack_mode in varchar2
426: ,p_validation_start_date in date
427: ,p_validation_end_date in date
529: -- ----------------------------------------------------------------------------
530: Procedure ins_lck
531: (p_effective_date in date
532: ,p_datetrack_mode in varchar2
533: ,p_rec in pay_pgr_shd.g_rec_type
534: ,p_validation_start_date out nocopy date
535: ,p_validation_end_date out nocopy date
536: ) is
537: --
569: -- |---------------------------------< ins >----------------------------------|
570: -- ----------------------------------------------------------------------------
571: Procedure ins
572: (p_effective_date in date
573: ,p_rec in out nocopy pay_pgr_shd.g_rec_type
574: ) is
575: --
576: l_proc varchar2(72) := g_package||'ins';
577: l_datetrack_mode varchar2(30) := hr_api.g_insert;
660: ,p_effective_start_date out nocopy date
661: ,p_effective_end_date out nocopy date
662: ) is
663: --
664: l_rec pay_pgr_shd.g_rec_type;
665: l_proc varchar2(72) := g_package||'ins';
666: --
667: Begin
668: hr_utility.set_location('Entering:'||l_proc, 5);
670: -- Call conversion function to turn arguments into the
671: -- p_rec structure.
672: --
673: l_rec :=
674: pay_pgr_shd.convert_args
675: (null
676: ,null
677: ,null
678: ,p_business_group_id