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_OTP_SHD dependencies on BEN_OTP_SHD

Line 1: Package Body ben_otp_shd as

1: Package Body ben_otp_shd as
2: /* $Header: beotprhi.pkb 115.3 2003/09/25 00:30:57 rpgupta noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

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

Line 121: ben_otp_shd.g_old_rec.optip_id and

117: --
118: l_fct_ret := false;
119: Else
120: If (p_optip_id =
121: ben_otp_shd.g_old_rec.optip_id and
122: p_object_version_number =
123: ben_otp_shd.g_old_rec.object_version_number) Then
124: --
125: -- The g_old_rec is current therefore we must

Line 123: ben_otp_shd.g_old_rec.object_version_number) Then

119: Else
120: If (p_optip_id =
121: ben_otp_shd.g_old_rec.optip_id and
122: p_object_version_number =
123: ben_otp_shd.g_old_rec.object_version_number) Then
124: --
125: -- The g_old_rec is current therefore we must
126: -- set the returning function to true
127: --

Line 134: Fetch C_Sel1 Into ben_otp_shd.g_old_rec;

130: --
131: -- Select the current row
132: --
133: Open C_Sel1;
134: Fetch C_Sel1 Into ben_otp_shd.g_old_rec;
135: If C_Sel1%notfound Then
136: Close C_Sel1;
137: --
138: -- The primary key is invalid therefore we must error

Line 145: <> ben_otp_shd.g_old_rec.object_version_number) Then

141: fnd_message.raise_error;
142: End If;
143: Close C_Sel1;
144: If (p_object_version_number
145: <> ben_otp_shd.g_old_rec.object_version_number) Then
146: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
147: fnd_message.raise_error;
148: End If;
149: l_fct_ret := true;

Line 287: ben_otp_shd.g_api_dml := true; -- Set the api dml status

283: ,p_base_key_value => p_base_key_value
284: );
285: --
286: hr_utility.set_location(l_proc, 10);
287: ben_otp_shd.g_api_dml := true; -- Set the api dml status
288: --
289: -- Update the specified datetrack row setting the effective
290: -- end date to the specified new effective end date.
291: --

Line 299: ben_otp_shd.g_api_dml := false; -- Unset the api dml status

295: where t.optip_id = p_base_key_value
296: and p_effective_date
297: between t.effective_start_date and t.effective_end_date;
298: --
299: ben_otp_shd.g_api_dml := false; -- Unset the api dml status
300: p_object_version_number := l_object_version_number;
301: hr_utility.set_location(' Leaving:'||l_proc, 15);
302: --
303: Exception

Line 305: ben_otp_shd.g_api_dml := false; -- Unset the api dml status

301: hr_utility.set_location(' Leaving:'||l_proc, 15);
302: --
303: Exception
304: When Others Then
305: ben_otp_shd.g_api_dml := false; -- Unset the api dml status
306: Raise;
307: --
308: End upd_effective_end_date;
309: --

Line 415: Fetch C_Sel1 Into ben_otp_shd.g_old_rec;

411: --
412: -- We must select and lock the current row.
413: --
414: Open C_Sel1;
415: Fetch C_Sel1 Into ben_otp_shd.g_old_rec;
416: If C_Sel1%notfound then
417: Close C_Sel1;
418: --
419: -- The primary key is invalid therefore we must error

Line 426: <> ben_otp_shd.g_old_rec.object_version_number) Then

422: fnd_message.raise_error;
423: End If;
424: Close C_Sel1;
425: If (p_object_version_number
426: <> ben_otp_shd.g_old_rec.object_version_number) Then
427: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
428: fnd_message.raise_error;
429: End If;
430: --

Line 443: ,p_parent_key_value1 => ben_otp_shd.g_old_rec.pgm_id

439: ,p_base_key_column => 'optip_id'
440: ,p_base_key_value => p_optip_id
441: ,p_parent_table_name1 => 'ben_pgm_f'
442: ,p_parent_key_column1 => 'pgm_id'
443: ,p_parent_key_value1 => ben_otp_shd.g_old_rec.pgm_id
444: ,p_parent_table_name2 => 'ben_ptip_f'
445: ,p_parent_key_column2 => 'ptip_id'
446: ,p_parent_key_value2 => ben_otp_shd.g_old_rec.ptip_id
447: ,p_parent_table_name3 => 'ben_opt_f'

Line 446: ,p_parent_key_value2 => ben_otp_shd.g_old_rec.ptip_id

442: ,p_parent_key_column1 => 'pgm_id'
443: ,p_parent_key_value1 => ben_otp_shd.g_old_rec.pgm_id
444: ,p_parent_table_name2 => 'ben_ptip_f'
445: ,p_parent_key_column2 => 'ptip_id'
446: ,p_parent_key_value2 => ben_otp_shd.g_old_rec.ptip_id
447: ,p_parent_table_name3 => 'ben_opt_f'
448: ,p_parent_key_column3 => 'opt_id'
449: ,p_parent_key_value3 => ben_otp_shd.g_old_rec.opt_id
450: ,p_enforce_foreign_locking => true

Line 449: ,p_parent_key_value3 => ben_otp_shd.g_old_rec.opt_id

445: ,p_parent_key_column2 => 'ptip_id'
446: ,p_parent_key_value2 => ben_otp_shd.g_old_rec.ptip_id
447: ,p_parent_table_name3 => 'ben_opt_f'
448: ,p_parent_key_column3 => 'opt_id'
449: ,p_parent_key_value3 => ben_otp_shd.g_old_rec.opt_id
450: ,p_enforce_foreign_locking => true
451: ,p_validation_start_date => l_validation_start_date
452: ,p_validation_end_date => l_validation_end_date
453: );

Line 592: end ben_otp_shd;

588: Return(l_rec);
589: --
590: End convert_args;
591: --
592: end ben_otp_shd;