APPS.PAY_PSD_SHD dependencies on PAY_PSD_SHD

Line 1: Package Body pay_psd_shd as

1: Package Body pay_psd_shd as
2: /* $Header: pypsdrhi.pkb 120.1 2005/12/08 05:08 ssekhar noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

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

Line 93: pay_psd_shd.g_old_rec.sii_details_id and

89: --
90: l_fct_ret := false;
91: Else
92: If (p_sii_details_id =
93: pay_psd_shd.g_old_rec.sii_details_id and
94: p_object_version_number =
95: pay_psd_shd.g_old_rec.object_version_number
96: ) Then
97: --

Line 95: pay_psd_shd.g_old_rec.object_version_number

91: Else
92: If (p_sii_details_id =
93: pay_psd_shd.g_old_rec.sii_details_id and
94: p_object_version_number =
95: pay_psd_shd.g_old_rec.object_version_number
96: ) Then
97: --
98: -- The g_old_rec is current therefore we must
99: -- set the returning function to true

Line 107: Fetch C_Sel1 Into pay_psd_shd.g_old_rec;

103: --
104: -- Select the current row
105: --
106: Open C_Sel1;
107: Fetch C_Sel1 Into pay_psd_shd.g_old_rec;
108: If C_Sel1%notfound Then
109: Close C_Sel1;
110: --
111: -- The primary key is invalid therefore we must error

Line 118: <> pay_psd_shd.g_old_rec.object_version_number) Then

114: fnd_message.raise_error;
115: End If;
116: Close C_Sel1;
117: If (p_object_version_number
118: <> pay_psd_shd.g_old_rec.object_version_number) Then
119: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
120: fnd_message.raise_error;
121: End If;
122: l_fct_ret := true;

Line 347: Fetch C_Sel1 Into pay_psd_shd.g_old_rec;

343: --
344: -- We must select and lock the current row.
345: --
346: Open C_Sel1;
347: Fetch C_Sel1 Into pay_psd_shd.g_old_rec;
348: If C_Sel1%notfound then
349: Close C_Sel1;
350: --
351: -- The primary key is invalid therefore we must error

Line 358: <> pay_psd_shd.g_old_rec.object_version_number) Then

354: fnd_message.raise_error;
355: End If;
356: Close C_Sel1;
357: If (p_object_version_number
358: <> pay_psd_shd.g_old_rec.object_version_number) Then
359: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
360: fnd_message.raise_error;
361: End If;
362: --

Line 516: end pay_psd_shd;

512: Return(l_rec);
513: --
514: End convert_args;
515: --
516: end pay_psd_shd;