[Home] [Help]
76: --
77: -- {End Of Comments}
78: -- ----------------------------------------------------------------------------
79: Procedure dt_insert_dml
80: (p_rec in out nocopy pay_uci_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_user_column_instances_f t
92: where t.user_column_instance_id = p_rec.user_column_instance_id
93: and t.effective_start_date =
94: pay_uci_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_user_column_instances_f.created_by%TYPE;
148: l_last_updated_by := fnd_global.user_id;
149: l_last_update_login := fnd_global.login_id;
150: End If;
151: --
152: pay_uci_shd.g_api_dml := true; -- Set the api dml status
153: --
154: -- Insert the row into: pay_user_column_instances_f
155: --
156: insert into pay_user_column_instances_f
185: ,l_last_updated_by
186: ,l_last_update_login
187: );
188: --
189: pay_uci_shd.g_api_dml := false; -- Unset the api dml status
190: hr_utility.set_location(' Leaving:'||l_proc, 15);
191: --
192: Exception
193: When hr_api.check_integrity_violated Then
191: --
192: Exception
193: When hr_api.check_integrity_violated Then
194: -- A check constraint has been violated
195: pay_uci_shd.g_api_dml := false; -- Unset the api dml status
196: pay_uci_shd.constraint_error
197: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
198: When hr_api.unique_integrity_violated Then
199: -- Unique integrity has been violated
192: Exception
193: When hr_api.check_integrity_violated Then
194: -- A check constraint has been violated
195: pay_uci_shd.g_api_dml := false; -- Unset the api dml status
196: pay_uci_shd.constraint_error
197: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
198: When hr_api.unique_integrity_violated Then
199: -- Unique integrity has been violated
200: pay_uci_shd.g_api_dml := false; -- Unset the api dml status
196: pay_uci_shd.constraint_error
197: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
198: When hr_api.unique_integrity_violated Then
199: -- Unique integrity has been violated
200: pay_uci_shd.g_api_dml := false; -- Unset the api dml status
201: pay_uci_shd.constraint_error
202: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
203: When Others Then
204: pay_uci_shd.g_api_dml := false; -- Unset the api dml status
197: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
198: When hr_api.unique_integrity_violated Then
199: -- Unique integrity has been violated
200: pay_uci_shd.g_api_dml := false; -- Unset the api dml status
201: pay_uci_shd.constraint_error
202: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
203: When Others Then
204: pay_uci_shd.g_api_dml := false; -- Unset the api dml status
205: Raise;
200: pay_uci_shd.g_api_dml := false; -- Unset the api dml status
201: pay_uci_shd.constraint_error
202: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
203: When Others Then
204: pay_uci_shd.g_api_dml := false; -- Unset the api dml status
205: Raise;
206: End dt_insert_dml;
207: --
208: -- ----------------------------------------------------------------------------
256: -- ----------------------------------------------------------------------------
257: -- |------------------------------< insert_dml >------------------------------|
258: -- ----------------------------------------------------------------------------
259: Procedure insert_dml
260: (p_rec in out nocopy pay_uci_shd.g_rec_type
261: ,p_effective_date in date
262: ,p_datetrack_mode in varchar2
263: ,p_validation_start_date in date
264: ,p_validation_end_date in date
319: --
320: -- {End Of Comments}
321: -- ----------------------------------------------------------------------------
322: Procedure pre_insert
323: (p_rec in out nocopy pay_uci_shd.g_rec_type
324: ,p_effective_date in date
325: ,p_datetrack_mode in varchar2
326: ,p_validation_start_date in date
327: ,p_validation_end_date in date
411: --
412: -- {End Of Comments}
413: -- ----------------------------------------------------------------------------
414: Procedure post_insert
415: (p_rec in pay_uci_shd.g_rec_type
416: ,p_effective_date in date
417: ,p_datetrack_mode in varchar2
418: ,p_validation_start_date in date
419: ,p_validation_end_date in date
509: -- ----------------------------------------------------------------------------
510: Procedure ins_lck
511: (p_effective_date in date
512: ,p_datetrack_mode in varchar2
513: ,p_rec in pay_uci_shd.g_rec_type
514: ,p_validation_start_date out nocopy date
515: ,p_validation_end_date out nocopy date
516: ) is
517: --
552: -- |---------------------------------< ins >----------------------------------|
553: -- ----------------------------------------------------------------------------
554: Procedure ins
555: (p_effective_date in date
556: ,p_rec in out nocopy pay_uci_shd.g_rec_type
557: ) is
558: --
559: l_proc varchar2(72) := g_package||'ins';
560: l_datetrack_mode varchar2(30) := hr_api.g_insert;
638: ,p_effective_start_date out nocopy date
639: ,p_effective_end_date out nocopy date
640: ) is
641: --
642: l_rec pay_uci_shd.g_rec_type;
643: l_proc varchar2(72) := g_package||'ins';
644: --
645: Begin
646: hr_utility.set_location('Entering:'||l_proc, 5);
648: -- Call conversion function to turn arguments into the
649: -- p_rec structure.
650: --
651: l_rec :=
652: pay_uci_shd.convert_args
653: (null
654: ,null
655: ,null
656: ,p_user_row_id