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_PQC_SHD dependencies on BEN_PQC_SHD

Line 1: Package Body ben_pqc_shd as

1: Package Body ben_pqc_shd as
2: /* $Header: bepqcrhi.pkb 120.1 2008/02/05 09:47:16 rtagarra noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

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

Line 121: ben_pqc_shd.g_old_rec.prtt_rmt_rqst_ctfn_prvdd_id and

117: --
118: l_fct_ret := false;
119: Else
120: If (p_prtt_rmt_rqst_ctfn_prvdd_id =
121: ben_pqc_shd.g_old_rec.prtt_rmt_rqst_ctfn_prvdd_id and
122: p_object_version_number =
123: ben_pqc_shd.g_old_rec.object_version_number
124: ) Then
125: --

Line 123: ben_pqc_shd.g_old_rec.object_version_number

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

Line 135: Fetch C_Sel1 Into ben_pqc_shd.g_old_rec;

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

Line 146: <> ben_pqc_shd.g_old_rec.object_version_number) Then

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

Line 282: ben_pqc_shd.g_api_dml := true; -- Set the api dml status

278: ,p_base_key_value => p_base_key_value
279: );
280: --
281: hr_utility.set_location(l_proc, 10);
282: ben_pqc_shd.g_api_dml := true; -- Set the api dml status
283: --
284: -- Update the specified datetrack row setting the effective
285: -- end date to the specified new effective end date.
286: --

Line 294: ben_pqc_shd.g_api_dml := false; -- Unset the api dml status

290: where t.prtt_rmt_rqst_ctfn_prvdd_id = p_base_key_value
291: and p_effective_date
292: between t.effective_start_date and t.effective_end_date;
293: --
294: ben_pqc_shd.g_api_dml := false; -- Unset the api dml status
295: p_object_version_number := l_object_version_number;
296: hr_utility.set_location(' Leaving:'||l_proc, 15);
297: --
298: Exception

Line 300: ben_pqc_shd.g_api_dml := false; -- Unset the api dml status

296: hr_utility.set_location(' Leaving:'||l_proc, 15);
297: --
298: Exception
299: When Others Then
300: ben_pqc_shd.g_api_dml := false; -- Unset the api dml status
301: Raise;
302: --
303: End upd_effective_end_date;
304: --

Line 410: Fetch C_Sel1 Into ben_pqc_shd.g_old_rec;

406: --
407: -- We must select and lock the current row.
408: --
409: Open C_Sel1;
410: Fetch C_Sel1 Into ben_pqc_shd.g_old_rec;
411: If C_Sel1%notfound then
412: Close C_Sel1;
413: --
414: -- The primary key is invalid therefore we must error

Line 421: <> ben_pqc_shd.g_old_rec.object_version_number) Then

417: fnd_message.raise_error;
418: End If;
419: Close C_Sel1;
420: If (p_object_version_number
421: <> ben_pqc_shd.g_old_rec.object_version_number) Then
422: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
423: fnd_message.raise_error;
424: End If;
425: --

Line 438: ,p_parent_key_value1 => ben_pqc_shd.g_old_rec.pl_gd_r_svc_ctfn_id

434: ,p_base_key_column => 'prtt_rmt_rqst_ctfn_prvdd_id'
435: ,p_base_key_value => p_prtt_rmt_rqst_ctfn_prvdd_id
436: ,p_parent_table_name1 => 'ben_pl_gd_r_svc_ctfn_f'
437: ,p_parent_key_column1 => 'pl_gd_r_svc_ctfn_id'
438: ,p_parent_key_value1 => ben_pqc_shd.g_old_rec.pl_gd_r_svc_ctfn_id
439: ,p_parent_table_name2 => 'ben_prtt_enrt_actn_f'
440: ,p_parent_key_column2 => 'prtt_enrt_actn_id'
441: ,p_parent_key_value2 => ben_pqc_shd.g_old_rec.prtt_enrt_actn_id
442: ,p_enforce_foreign_locking => false --true

Line 441: ,p_parent_key_value2 => ben_pqc_shd.g_old_rec.prtt_enrt_actn_id

437: ,p_parent_key_column1 => 'pl_gd_r_svc_ctfn_id'
438: ,p_parent_key_value1 => ben_pqc_shd.g_old_rec.pl_gd_r_svc_ctfn_id
439: ,p_parent_table_name2 => 'ben_prtt_enrt_actn_f'
440: ,p_parent_key_column2 => 'prtt_enrt_actn_id'
441: ,p_parent_key_value2 => ben_pqc_shd.g_old_rec.prtt_enrt_actn_id
442: ,p_enforce_foreign_locking => false --true
443: ,p_validation_start_date => l_validation_start_date
444: ,p_validation_end_date => l_validation_end_date
445: );

Line 584: end ben_pqc_shd;

580: Return(l_rec);
581: --
582: End convert_args;
583: --
584: end ben_pqc_shd;