APPS.BEN_CPD_SHD dependencies on BEN_CPD_SHD

Line 1: Package Body ben_cpd_shd as

1: Package Body ben_cpd_shd as
2: /* $Header: becpdrhi.pkb 120.1 2006/01/04 01:46 steotia noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

Line 8: g_package varchar2(33) := ' ben_cpd_shd.'; -- Global package name

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' ben_cpd_shd.'; -- Global package name
9: --
10: -- ----------------------------------------------------------------------------
11: -- |------------------------< return_api_dml_status >-------------------------|
12: -- ----------------------------------------------------------------------------

Line 173: = ben_cpd_shd.g_old_rec.pl_id and

169: --
170: l_fct_ret := false;
171: Else
172: If (p_pl_id
173: = ben_cpd_shd.g_old_rec.pl_id and
174: p_lf_evt_ocrd_dt
175: = ben_cpd_shd.g_old_rec.lf_evt_ocrd_dt and
176: p_oipl_id
177: = ben_cpd_shd.g_old_rec.oipl_id and

Line 175: = ben_cpd_shd.g_old_rec.lf_evt_ocrd_dt and

171: Else
172: If (p_pl_id
173: = ben_cpd_shd.g_old_rec.pl_id and
174: p_lf_evt_ocrd_dt
175: = ben_cpd_shd.g_old_rec.lf_evt_ocrd_dt and
176: p_oipl_id
177: = ben_cpd_shd.g_old_rec.oipl_id and
178: p_object_version_number
179: = ben_cpd_shd.g_old_rec.object_version_number

Line 177: = ben_cpd_shd.g_old_rec.oipl_id and

173: = ben_cpd_shd.g_old_rec.pl_id and
174: p_lf_evt_ocrd_dt
175: = ben_cpd_shd.g_old_rec.lf_evt_ocrd_dt and
176: p_oipl_id
177: = ben_cpd_shd.g_old_rec.oipl_id and
178: p_object_version_number
179: = ben_cpd_shd.g_old_rec.object_version_number
180: ) Then
181: --

Line 179: = ben_cpd_shd.g_old_rec.object_version_number

175: = ben_cpd_shd.g_old_rec.lf_evt_ocrd_dt and
176: p_oipl_id
177: = ben_cpd_shd.g_old_rec.oipl_id and
178: p_object_version_number
179: = ben_cpd_shd.g_old_rec.object_version_number
180: ) Then
181: --
182: -- The g_old_rec is current therefore we must
183: -- set the returning function to true

Line 191: Fetch C_Sel1 Into ben_cpd_shd.g_old_rec;

187: --
188: -- Select the current row into g_old_rec
189: --
190: Open C_Sel1;
191: Fetch C_Sel1 Into ben_cpd_shd.g_old_rec;
192: If C_Sel1%notfound Then
193: Close C_Sel1;
194: --
195: -- The primary key is invalid therefore we must error

Line 202: <> ben_cpd_shd.g_old_rec.object_version_number) Then

198: fnd_message.raise_error;
199: End If;
200: Close C_Sel1;
201: If (p_object_version_number
202: <> ben_cpd_shd.g_old_rec.object_version_number) Then
203: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
204: fnd_message.raise_error;
205: End If;
206: l_fct_ret := true;

Line 353: Fetch C_Sel1 Into ben_cpd_shd.g_old_rec;

349: ,p_argument_value => p_object_version_number
350: );
351: --
352: Open C_Sel1;
353: Fetch C_Sel1 Into ben_cpd_shd.g_old_rec;
354: If C_Sel1%notfound then
355: Close C_Sel1;
356: --
357: -- The primary key is invalid therefore we must error

Line 364: hr_utility.set_location('old ovn : '||ben_cpd_shd.g_old_rec.object_version_number,999);

360: fnd_message.raise_error;
361: End If;
362: Close C_Sel1;
363: hr_utility.set_location('ovn : '||p_object_version_number,999);
364: hr_utility.set_location('old ovn : '||ben_cpd_shd.g_old_rec.object_version_number,999);
365: If (p_object_version_number
366: <> ben_cpd_shd.g_old_rec.object_version_number) Then
367: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
368: fnd_message.raise_error;

Line 366: <> ben_cpd_shd.g_old_rec.object_version_number) Then

362: Close C_Sel1;
363: hr_utility.set_location('ovn : '||p_object_version_number,999);
364: hr_utility.set_location('old ovn : '||ben_cpd_shd.g_old_rec.object_version_number,999);
365: If (p_object_version_number
366: <> ben_cpd_shd.g_old_rec.object_version_number) Then
367: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
368: fnd_message.raise_error;
369: End If;
370: --

Line 586: end ben_cpd_shd;

582: Return(l_rec);
583: --
584: End convert_args;
585: --
586: end ben_cpd_shd;