DBA Data[Home] [Help]

APPS.BEN_CPE_INS dependencies on BEN_CPE_SHD

Line 76: (p_rec in out nocopy ben_cpe_shd.g_rec_type

72: --
73: -- {End Of Comments}
74: -- ----------------------------------------------------------------------------
75: Procedure insert_dml
76: (p_rec in out nocopy ben_cpe_shd.g_rec_type
77: ) is
78: --
79: l_proc varchar2(72) := g_package||'insert_dml';
80: --

Line 85: ben_cpe_shd.g_api_dml := true; -- Set the api dml status

81: Begin
82: hr_utility.set_location('Entering:'||l_proc, 5);
83: p_rec.object_version_number := 1; -- Initialise the object version
84: --
85: ben_cpe_shd.g_api_dml := true; -- Set the api dml status
86: --
87: -- Insert the row into: ben_copy_entity_results
88: --
89: insert into ben_copy_entity_results

Line 834: ben_cpe_shd.g_api_dml := false; -- Unset the api dml status

830: ,p_rec.datetrack_mode
831: ,p_rec.object_version_number
832: );
833: --
834: ben_cpe_shd.g_api_dml := false; -- Unset the api dml status
835: --
836: hr_utility.set_location(' Leaving:'||l_proc, 10);
837: Exception
838: When hr_api.check_integrity_violated Then

Line 840: ben_cpe_shd.g_api_dml := false; -- Unset the api dml status

836: hr_utility.set_location(' Leaving:'||l_proc, 10);
837: Exception
838: When hr_api.check_integrity_violated Then
839: -- A check constraint has been violated
840: ben_cpe_shd.g_api_dml := false; -- Unset the api dml status
841: ben_cpe_shd.constraint_error
842: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
843: When hr_api.parent_integrity_violated Then
844: -- Parent integrity has been violated

Line 841: ben_cpe_shd.constraint_error

837: Exception
838: When hr_api.check_integrity_violated Then
839: -- A check constraint has been violated
840: ben_cpe_shd.g_api_dml := false; -- Unset the api dml status
841: ben_cpe_shd.constraint_error
842: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
843: When hr_api.parent_integrity_violated Then
844: -- Parent integrity has been violated
845: ben_cpe_shd.g_api_dml := false; -- Unset the api dml status

Line 845: ben_cpe_shd.g_api_dml := false; -- Unset the api dml status

841: ben_cpe_shd.constraint_error
842: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
843: When hr_api.parent_integrity_violated Then
844: -- Parent integrity has been violated
845: ben_cpe_shd.g_api_dml := false; -- Unset the api dml status
846: ben_cpe_shd.constraint_error
847: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
848: When hr_api.unique_integrity_violated Then
849: -- Unique integrity has been violated

Line 846: ben_cpe_shd.constraint_error

842: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
843: When hr_api.parent_integrity_violated Then
844: -- Parent integrity has been violated
845: ben_cpe_shd.g_api_dml := false; -- Unset the api dml status
846: ben_cpe_shd.constraint_error
847: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
848: When hr_api.unique_integrity_violated Then
849: -- Unique integrity has been violated
850: ben_cpe_shd.g_api_dml := false; -- Unset the api dml status

Line 850: ben_cpe_shd.g_api_dml := false; -- Unset the api dml status

846: ben_cpe_shd.constraint_error
847: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
848: When hr_api.unique_integrity_violated Then
849: -- Unique integrity has been violated
850: ben_cpe_shd.g_api_dml := false; -- Unset the api dml status
851: ben_cpe_shd.constraint_error
852: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
853: When Others Then
854: ben_cpe_shd.g_api_dml := false; -- Unset the api dml status

Line 851: ben_cpe_shd.constraint_error

847: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
848: When hr_api.unique_integrity_violated Then
849: -- Unique integrity has been violated
850: ben_cpe_shd.g_api_dml := false; -- Unset the api dml status
851: ben_cpe_shd.constraint_error
852: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
853: When Others Then
854: ben_cpe_shd.g_api_dml := false; -- Unset the api dml status
855: Raise;

Line 854: ben_cpe_shd.g_api_dml := false; -- Unset the api dml status

850: ben_cpe_shd.g_api_dml := false; -- Unset the api dml status
851: ben_cpe_shd.constraint_error
852: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
853: When Others Then
854: ben_cpe_shd.g_api_dml := false; -- Unset the api dml status
855: Raise;
856: End insert_dml;
857: --
858: -- ----------------------------------------------------------------------------

Line 896: (p_rec in out nocopy ben_cpe_shd.g_rec_type

892: --
893: -- {End Of Comments}
894: -- ----------------------------------------------------------------------------
895: Procedure pre_insert
896: (p_rec in out nocopy ben_cpe_shd.g_rec_type
897: ) is
898: --
899: Cursor C_Sel1 is select ben_copy_entity_results_s.nextval from sys.dual;
900: --

Line 984: ,p_rec in ben_cpe_shd.g_rec_type

980: -- {End Of Comments}
981: -- ----------------------------------------------------------------------------
982: Procedure post_insert
983: (p_effective_date in date
984: ,p_rec in ben_cpe_shd.g_rec_type
985: ) is
986: --
987: l_proc varchar2(72) := g_package||'post_insert';
988: --

Line 1736: ,p_rec in out nocopy ben_cpe_shd.g_rec_type

1732: -- |---------------------------------< ins >----------------------------------|
1733: -- ----------------------------------------------------------------------------
1734: Procedure ins
1735: (p_effective_date in date
1736: ,p_rec in out nocopy ben_cpe_shd.g_rec_type
1737: ) is
1738: --
1739: l_proc varchar2(72) := g_package||'ins';
1740: --

Line 2152: l_rec ben_cpe_shd.g_rec_type;

2148: ,p_copy_entity_result_id out nocopy number
2149: ,p_object_version_number out nocopy number
2150: ) is
2151: --
2152: l_rec ben_cpe_shd.g_rec_type;
2153: l_proc varchar2(72) := g_package||'ins';
2154: --
2155: Begin
2156: hr_utility.set_location('Entering:'||l_proc, 5);

Line 2162: ben_cpe_shd.convert_args

2158: -- Call conversion function to turn arguments into the
2159: -- p_rec structure.
2160: --
2161: l_rec :=
2162: ben_cpe_shd.convert_args
2163: (null
2164: ,p_copy_entity_txn_id
2165: ,p_src_copy_entity_result_id
2166: ,p_result_type_cd