eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_CTK_DEL dependencies on BEN_CTK_SHD

Line 53: (p_rec in ben_ctk_shd.g_rec_type

49: --
50: -- {End Of Comments}
51: -- ----------------------------------------------------------------------------
52: Procedure delete_dml
53: (p_rec in ben_ctk_shd.g_rec_type
54: ) is
55: --
56: l_proc varchar2(72) := g_package||'delete_dml';
57: --

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

59: if g_debug then
60: hr_utility.set_location('Entering:'||l_proc, 5);
61: end if;
62: --
63: ben_ctk_shd.g_api_dml := true; -- Set the api dml status
64: --
65: -- Delete the ben_cwb_person_tasks row.
66: --
67: delete from ben_cwb_person_tasks

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

67: delete from ben_cwb_person_tasks
68: where group_per_in_ler_id = p_rec.group_per_in_ler_id
69: and task_id = p_rec.task_id;
70: --
71: ben_ctk_shd.g_api_dml := false; -- Unset the api dml status
72: --
73: if g_debug then
74: hr_utility.set_location(' Leaving:'||l_proc, 10);
75: end if;

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

76: --
77: Exception
78: When hr_api.child_integrity_violated then
79: -- Child integrity has been violated
80: ben_ctk_shd.g_api_dml := false; -- Unset the api dml status
81: ben_ctk_shd.constraint_error
82: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
83: When Others Then
84: ben_ctk_shd.g_api_dml := false; -- Unset the api dml status

Line 81: ben_ctk_shd.constraint_error

77: Exception
78: When hr_api.child_integrity_violated then
79: -- Child integrity has been violated
80: ben_ctk_shd.g_api_dml := false; -- Unset the api dml status
81: ben_ctk_shd.constraint_error
82: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
83: When Others Then
84: ben_ctk_shd.g_api_dml := false; -- Unset the api dml status
85: Raise;

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

80: ben_ctk_shd.g_api_dml := false; -- Unset the api dml status
81: ben_ctk_shd.constraint_error
82: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
83: When Others Then
84: ben_ctk_shd.g_api_dml := false; -- Unset the api dml status
85: Raise;
86: End delete_dml;
87: --
88: -- ----------------------------------------------------------------------------

Line 120: Procedure pre_delete(p_rec in ben_ctk_shd.g_rec_type) is

116: -- Internal Row Handler Use Only.
117: --
118: -- {End Of Comments}
119: -- ----------------------------------------------------------------------------
120: Procedure pre_delete(p_rec in ben_ctk_shd.g_rec_type) is
121: --
122: l_proc varchar2(72) := g_package||'pre_delete';
123: --
124: Begin

Line 166: Procedure post_delete(p_rec in ben_ctk_shd.g_rec_type) is

162: -- Internal Row Handler Use Only.
163: --
164: -- {End Of Comments}
165: -- -----------------------------------------------------------------------------
166: Procedure post_delete(p_rec in ben_ctk_shd.g_rec_type) is
167: --
168: l_proc varchar2(72) := g_package||'post_delete';
169: --
170: Begin

Line 182: => ben_ctk_shd.g_old_rec.group_pl_id

178: => p_rec.group_per_in_ler_id
179: ,p_task_id
180: => p_rec.task_id
181: ,p_group_pl_id_o
182: => ben_ctk_shd.g_old_rec.group_pl_id
183: ,p_lf_evt_ocrd_dt_o
184: => ben_ctk_shd.g_old_rec.lf_evt_ocrd_dt
185: ,p_status_cd_o
186: => ben_ctk_shd.g_old_rec.status_cd

Line 184: => ben_ctk_shd.g_old_rec.lf_evt_ocrd_dt

180: => p_rec.task_id
181: ,p_group_pl_id_o
182: => ben_ctk_shd.g_old_rec.group_pl_id
183: ,p_lf_evt_ocrd_dt_o
184: => ben_ctk_shd.g_old_rec.lf_evt_ocrd_dt
185: ,p_status_cd_o
186: => ben_ctk_shd.g_old_rec.status_cd
187: ,p_access_cd_o
188: => ben_ctk_shd.g_old_rec.access_cd

Line 186: => ben_ctk_shd.g_old_rec.status_cd

182: => ben_ctk_shd.g_old_rec.group_pl_id
183: ,p_lf_evt_ocrd_dt_o
184: => ben_ctk_shd.g_old_rec.lf_evt_ocrd_dt
185: ,p_status_cd_o
186: => ben_ctk_shd.g_old_rec.status_cd
187: ,p_access_cd_o
188: => ben_ctk_shd.g_old_rec.access_cd
189: ,p_task_last_update_date_o
190: => ben_ctk_shd.g_old_rec.task_last_update_date

Line 188: => ben_ctk_shd.g_old_rec.access_cd

184: => ben_ctk_shd.g_old_rec.lf_evt_ocrd_dt
185: ,p_status_cd_o
186: => ben_ctk_shd.g_old_rec.status_cd
187: ,p_access_cd_o
188: => ben_ctk_shd.g_old_rec.access_cd
189: ,p_task_last_update_date_o
190: => ben_ctk_shd.g_old_rec.task_last_update_date
191: ,p_task_last_update_by_o
192: => ben_ctk_shd.g_old_rec.task_last_update_by

Line 190: => ben_ctk_shd.g_old_rec.task_last_update_date

186: => ben_ctk_shd.g_old_rec.status_cd
187: ,p_access_cd_o
188: => ben_ctk_shd.g_old_rec.access_cd
189: ,p_task_last_update_date_o
190: => ben_ctk_shd.g_old_rec.task_last_update_date
191: ,p_task_last_update_by_o
192: => ben_ctk_shd.g_old_rec.task_last_update_by
193: ,p_object_version_number_o
194: => ben_ctk_shd.g_old_rec.object_version_number

Line 192: => ben_ctk_shd.g_old_rec.task_last_update_by

188: => ben_ctk_shd.g_old_rec.access_cd
189: ,p_task_last_update_date_o
190: => ben_ctk_shd.g_old_rec.task_last_update_date
191: ,p_task_last_update_by_o
192: => ben_ctk_shd.g_old_rec.task_last_update_by
193: ,p_object_version_number_o
194: => ben_ctk_shd.g_old_rec.object_version_number
195: );
196: --

Line 194: => ben_ctk_shd.g_old_rec.object_version_number

190: => ben_ctk_shd.g_old_rec.task_last_update_date
191: ,p_task_last_update_by_o
192: => ben_ctk_shd.g_old_rec.task_last_update_by
193: ,p_object_version_number_o
194: => ben_ctk_shd.g_old_rec.object_version_number
195: );
196: --
197: exception
198: --

Line 216: (p_rec in ben_ctk_shd.g_rec_type

212: -- ----------------------------------------------------------------------------
213: -- |---------------------------------< del >----------------------------------|
214: -- ----------------------------------------------------------------------------
215: Procedure del
216: (p_rec in ben_ctk_shd.g_rec_type
217: ) is
218: --
219: l_proc varchar2(72) := g_package||'del';
220: --

Line 228: ben_ctk_shd.lck

224: end if;
225: --
226: -- We must lock the row which we need to delete.
227: --
228: ben_ctk_shd.lck
229: (p_rec.group_per_in_ler_id
230: ,p_rec.task_id
231: ,p_rec.object_version_number
232: );

Line 267: l_rec ben_ctk_shd.g_rec_type;

263: ,p_task_id in number
264: ,p_object_version_number in number
265: ) is
266: --
267: l_rec ben_ctk_shd.g_rec_type;
268: l_proc varchar2(72) := g_package||'del';
269: --
270: Begin
271: if g_debug then