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.PAY_OPM_SHD dependencies on PAY_OPM_SHD

Line 1: Package Body pay_opm_shd as

1: Package Body pay_opm_shd as
2: /* $Header: pyopmrhi.pkb 120.4 2005/11/07 01:38:13 pgongada noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

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

Line 157: pay_opm_shd.g_old_rec.org_payment_method_id and

153: --
154: l_fct_ret := false;
155: Else
156: If (p_org_payment_method_id =
157: pay_opm_shd.g_old_rec.org_payment_method_id and
158: p_object_version_number =
159: pay_opm_shd.g_old_rec.object_version_number) Then
160: --
161: -- The g_old_rec is current therefore we must

Line 159: pay_opm_shd.g_old_rec.object_version_number) Then

155: Else
156: If (p_org_payment_method_id =
157: pay_opm_shd.g_old_rec.org_payment_method_id and
158: p_object_version_number =
159: pay_opm_shd.g_old_rec.object_version_number) Then
160: --
161: -- The g_old_rec is current therefore we must
162: -- set the returning function to true
163: --

Line 170: Fetch C_Sel1 Into pay_opm_shd.g_old_rec;

166: --
167: -- Select the current row
168: --
169: Open C_Sel1;
170: Fetch C_Sel1 Into pay_opm_shd.g_old_rec;
171: If C_Sel1%notfound Then
172: Close C_Sel1;
173: --
174: -- The primary key is invalid therefore we must error

Line 181: <> pay_opm_shd.g_old_rec.object_version_number) Then

177: fnd_message.raise_error;
178: End If;
179: Close C_Sel1;
180: If (p_object_version_number
181: <> pay_opm_shd.g_old_rec.object_version_number) Then
182: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
183: fnd_message.raise_error;
184: End If;
185: l_fct_ret := true;

Line 288: pay_opm_shd.g_api_dml := true; -- Set the api dml status

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

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

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

Line 306: pay_opm_shd.g_api_dml := false; -- Unset the api dml status

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

Line 403: where hc.comment_id = pay_opm_shd.g_old_rec.comment_id;

399: --
400: Cursor C_Sel3 is
401: select hc.comment_text
402: from hr_comments hc
403: where hc.comment_id = pay_opm_shd.g_old_rec.comment_id;
404: --
405: Begin
406: hr_utility.set_location('Entering:'||l_proc, 5);
407: --

Line 437: Fetch C_Sel1 Into pay_opm_shd.g_old_rec;

433: --
434: -- We must select and lock the current row.
435: --
436: Open C_Sel1;
437: Fetch C_Sel1 Into pay_opm_shd.g_old_rec;
438: If C_Sel1%notfound then
439: Close C_Sel1;
440: --
441: -- The primary key is invalid therefore we must error

Line 448: <> pay_opm_shd.g_old_rec.object_version_number) Then

444: fnd_message.raise_error;
445: End If;
446: Close C_Sel1;
447: If (p_object_version_number
448: <> pay_opm_shd.g_old_rec.object_version_number) Then
449: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
450: fnd_message.raise_error;
451: End If;
452: --

Line 456: If ((pay_opm_shd.g_old_rec.comment_id is not null) and

452: --
453: -- Providing we are doing an update and a comment_id exists then
454: -- we select the comment text.
455: --
456: If ((pay_opm_shd.g_old_rec.comment_id is not null) and
457: (p_datetrack_mode = hr_api.g_update or
458: p_datetrack_mode = hr_api.g_correction or
459: p_datetrack_mode = hr_api.g_update_override or
460: p_datetrack_mode = hr_api.g_update_change_insert)) then

Line 462: Fetch C_Sel3 Into pay_opm_shd.g_old_rec.comments;

458: p_datetrack_mode = hr_api.g_correction or
459: p_datetrack_mode = hr_api.g_update_override or
460: p_datetrack_mode = hr_api.g_update_change_insert)) then
461: Open C_Sel3;
462: Fetch C_Sel3 Into pay_opm_shd.g_old_rec.comments;
463: If C_Sel3%notfound then
464: --
465: -- The comments for the specified comment_id does not exist.
466: -- We must error due to data integrity problems.

Line 666: end pay_opm_shd;

662: Return(l_rec);
663: --
664: End convert_args;
665: --
666: end pay_opm_shd;