[Home] [Help]
54: --
55: -- {End Of Comments}
56: -- ---------------------------------------------------------------------------+
57: Procedure dt_insert_dml
58: (p_rec in out nocopy pqp_aat_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
68: t.creation_date
69: from pqp_assignment_attributes_f t
70: where t.assignment_attribute_id = p_rec.assignment_attribute_id
71: and t.effective_start_date =
72: pqp_aat_shd.g_old_rec.effective_start_date
73: and t.effective_end_date = (p_validation_start_date - 1);
74: --
75: l_proc varchar2(72) := g_package||'dt_insert_dml';
76: l_created_by pqp_assignment_attributes_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: pqp_aat_shd.g_api_dml := true; -- Set the api dml status
131: --
132: -- Insert the row into: pqp_assignment_attributes_f
133: --
134: insert into pqp_assignment_attributes_f
309: ,l_last_updated_by
310: ,l_last_update_login
311: );
312: --
313: pqp_aat_shd.g_api_dml := false; -- Unset the api dml status
314: hr_utility.set_location(' Leaving:'||l_proc, 15);
315: --
316: Exception
317: When hr_api.check_integrity_violated Then
315: --
316: Exception
317: When hr_api.check_integrity_violated Then
318: -- A check constraint has been violated
319: pqp_aat_shd.g_api_dml := false; -- Unset the api dml status
320: pqp_aat_shd.constraint_error
321: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
322: When hr_api.unique_integrity_violated Then
323: -- Unique integrity has been violated
316: Exception
317: When hr_api.check_integrity_violated Then
318: -- A check constraint has been violated
319: pqp_aat_shd.g_api_dml := false; -- Unset the api dml status
320: pqp_aat_shd.constraint_error
321: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
322: When hr_api.unique_integrity_violated Then
323: -- Unique integrity has been violated
324: pqp_aat_shd.g_api_dml := false; -- Unset the api dml status
320: pqp_aat_shd.constraint_error
321: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
322: When hr_api.unique_integrity_violated Then
323: -- Unique integrity has been violated
324: pqp_aat_shd.g_api_dml := false; -- Unset the api dml status
325: pqp_aat_shd.constraint_error
326: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
327: When Others Then
328: pqp_aat_shd.g_api_dml := false; -- Unset the api dml status
321: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
322: When hr_api.unique_integrity_violated Then
323: -- Unique integrity has been violated
324: pqp_aat_shd.g_api_dml := false; -- Unset the api dml status
325: pqp_aat_shd.constraint_error
326: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
327: When Others Then
328: pqp_aat_shd.g_api_dml := false; -- Unset the api dml status
329: Raise;
324: pqp_aat_shd.g_api_dml := false; -- Unset the api dml status
325: pqp_aat_shd.constraint_error
326: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
327: When Others Then
328: pqp_aat_shd.g_api_dml := false; -- Unset the api dml status
329: Raise;
330: End dt_insert_dml;
331: --
332: -- ---------------------------------------------------------------------------+
332: -- ---------------------------------------------------------------------------+
333: -- |------------------------------< insert_dml >------------------------------|
334: -- ---------------------------------------------------------------------------+
335: Procedure insert_dml
336: (p_rec in out nocopy pqp_aat_shd.g_rec_type
337: ,p_effective_date in date
338: ,p_datetrack_mode in varchar2
339: ,p_validation_start_date in date
340: ,p_validation_end_date in date
395: --
396: -- {End Of Comments}
397: -- ---------------------------------------------------------------------------+
398: Procedure pre_insert
399: (p_rec in out nocopy pqp_aat_shd.g_rec_type
400: ,p_effective_date in date
401: ,p_datetrack_mode in varchar2
402: ,p_validation_start_date in date
403: ,p_validation_end_date in date
453: --
454: -- {End Of Comments}
455: -- ---------------------------------------------------------------------------+
456: Procedure post_insert
457: (p_rec in pqp_aat_shd.g_rec_type
458: ,p_effective_date in date
459: ,p_datetrack_mode in varchar2
460: ,p_validation_start_date in date
461: ,p_validation_end_date in date
691: -- ---------------------------------------------------------------------------+
692: Procedure ins_lck
693: (p_effective_date in date
694: ,p_datetrack_mode in varchar2
695: ,p_rec in pqp_aat_shd.g_rec_type
696: ,p_validation_start_date out nocopy date
697: ,p_validation_end_date out nocopy date
698: ) is
699: --
731: -- |---------------------------------< ins >----------------------------------|
732: -- ---------------------------------------------------------------------------+
733: Procedure ins
734: (p_effective_date in date
735: ,p_rec in out nocopy pqp_aat_shd.g_rec_type
736: ) is
737: --
738: l_proc varchar2(72) := g_package||'ins';
739: l_datetrack_mode varchar2(30) := hr_api.g_insert;
884: ,p_effective_start_date out nocopy date
885: ,p_effective_end_date out nocopy date
886: ) is
887: --
888: l_rec pqp_aat_shd.g_rec_type;
889: l_proc varchar2(72) := g_package||'ins';
890: --
891: Begin
892: hr_utility.set_location('Entering:'||l_proc, 5);
894: -- Call conversion function to turn arguments into the
895: -- p_rec structure.
896: --
897: l_rec :=
898: pqp_aat_shd.convert_args
899: (null
900: ,null
901: ,null
902: ,p_business_group_id