APPS.BEN_CTK_INS dependencies on BEN_CTK_SHD

Line 84: (p_rec in out nocopy ben_ctk_shd.g_rec_type

80: --
81: -- {End Of Comments}
82: -- ----------------------------------------------------------------------------
83: Procedure insert_dml
84: (p_rec in out nocopy ben_ctk_shd.g_rec_type
85: ) is
86: --
87: l_proc varchar2(72) := g_package||'insert_dml';
88: --

Line 95: ben_ctk_shd.g_api_dml := true; -- Set the api dml status

91: hr_utility.set_location('Entering:'||l_proc, 5);
92: end if;
93: p_rec.object_version_number := 1; -- Initialise the object version
94: --
95: ben_ctk_shd.g_api_dml := true; -- Set the api dml status
96: --
97: -- Insert the row into: ben_cwb_person_tasks
98: --
99: insert into ben_cwb_person_tasks

Line 122: ben_ctk_shd.g_api_dml := false; -- Unset the api dml status

118: ,p_rec.task_last_update_by
119: ,p_rec.object_version_number
120: );
121: --
122: ben_ctk_shd.g_api_dml := false; -- Unset the api dml status
123: --
124: if g_debug then
125: hr_utility.set_location(' Leaving:'||l_proc, 10);
126: end if;

Line 130: ben_ctk_shd.g_api_dml := false; -- Unset the api dml status

126: end if;
127: Exception
128: When hr_api.check_integrity_violated Then
129: -- A check constraint has been violated
130: ben_ctk_shd.g_api_dml := false; -- Unset the api dml status
131: ben_ctk_shd.constraint_error
132: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
133: When hr_api.parent_integrity_violated Then
134: -- Parent integrity has been violated

Line 131: ben_ctk_shd.constraint_error

127: Exception
128: When hr_api.check_integrity_violated Then
129: -- A check constraint has been violated
130: ben_ctk_shd.g_api_dml := false; -- Unset the api dml status
131: ben_ctk_shd.constraint_error
132: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
133: When hr_api.parent_integrity_violated Then
134: -- Parent integrity has been violated
135: ben_ctk_shd.g_api_dml := false; -- Unset the api dml status

Line 135: ben_ctk_shd.g_api_dml := false; -- Unset the api dml status

131: ben_ctk_shd.constraint_error
132: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
133: When hr_api.parent_integrity_violated Then
134: -- Parent integrity has been violated
135: ben_ctk_shd.g_api_dml := false; -- Unset the api dml status
136: ben_ctk_shd.constraint_error
137: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
138: When hr_api.unique_integrity_violated Then
139: -- Unique integrity has been violated

Line 136: ben_ctk_shd.constraint_error

132: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
133: When hr_api.parent_integrity_violated Then
134: -- Parent integrity has been violated
135: ben_ctk_shd.g_api_dml := false; -- Unset the api dml status
136: ben_ctk_shd.constraint_error
137: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
138: When hr_api.unique_integrity_violated Then
139: -- Unique integrity has been violated
140: ben_ctk_shd.g_api_dml := false; -- Unset the api dml status

Line 140: ben_ctk_shd.g_api_dml := false; -- Unset the api dml status

136: ben_ctk_shd.constraint_error
137: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
138: When hr_api.unique_integrity_violated Then
139: -- Unique integrity has been violated
140: ben_ctk_shd.g_api_dml := false; -- Unset the api dml status
141: ben_ctk_shd.constraint_error
142: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
143: When Others Then
144: ben_ctk_shd.g_api_dml := false; -- Unset the api dml status

Line 141: ben_ctk_shd.constraint_error

137: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
138: When hr_api.unique_integrity_violated Then
139: -- Unique integrity has been violated
140: ben_ctk_shd.g_api_dml := false; -- Unset the api dml status
141: ben_ctk_shd.constraint_error
142: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
143: When Others Then
144: ben_ctk_shd.g_api_dml := false; -- Unset the api dml status
145: Raise;

Line 144: ben_ctk_shd.g_api_dml := false; -- Unset the api dml status

140: ben_ctk_shd.g_api_dml := false; -- Unset the api dml status
141: ben_ctk_shd.constraint_error
142: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
143: When Others Then
144: ben_ctk_shd.g_api_dml := false; -- Unset the api dml status
145: Raise;
146: End insert_dml;
147: --
148: -- ----------------------------------------------------------------------------

Line 186: (p_rec in out nocopy ben_ctk_shd.g_rec_type

182: --
183: -- {End Of Comments}
184: -- ----------------------------------------------------------------------------
185: Procedure pre_insert
186: (p_rec in out nocopy ben_ctk_shd.g_rec_type
187: ) is
188: --
189: Cursor C_Sel2 is
190: Select null

Line 282: (p_rec in ben_ctk_shd.g_rec_type

278: --
279: -- {End Of Comments}
280: -- ----------------------------------------------------------------------------
281: Procedure post_insert
282: (p_rec in ben_ctk_shd.g_rec_type
283: ) is
284: --
285: l_proc varchar2(72) := g_package||'post_insert';
286: --

Line 333: (p_rec in out nocopy ben_ctk_shd.g_rec_type

329: -- ----------------------------------------------------------------------------
330: -- |---------------------------------< ins >----------------------------------|
331: -- ----------------------------------------------------------------------------
332: Procedure ins
333: (p_rec in out nocopy ben_ctk_shd.g_rec_type
334: ) is
335: --
336: l_proc varchar2(72) := g_package||'ins';
337: --

Line 389: l_rec ben_ctk_shd.g_rec_type;

385: ,p_task_last_update_by in number default null
386: ,p_object_version_number out nocopy number
387: ) is
388: --
389: l_rec ben_ctk_shd.g_rec_type;
390: l_proc varchar2(72) := g_package||'ins';
391: --
392: Begin
393: if g_debug then

Line 401: ben_ctk_shd.convert_args

397: -- Call conversion function to turn arguments into the
398: -- p_rec structure.
399: --
400: l_rec :=
401: ben_ctk_shd.convert_args
402: (p_group_per_in_ler_id
403: ,p_task_id
404: ,p_group_pl_id
405: ,p_lf_evt_ocrd_dt