APPS.PER_PMS_SHD dependencies on PER_PMS_SHD

Line 1: Package Body per_pms_shd as

1: Package Body per_pms_shd as
2: /* $Header: pepmsrhi.pkb 120.2.12010000.2 2008/09/02 10:51:07 arumukhe ship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

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

Line 108: = per_pms_shd.g_old_rec.scorecard_id and

104: --
105: l_fct_ret := false;
106: Else
107: If (p_scorecard_id
108: = per_pms_shd.g_old_rec.scorecard_id and
109: p_object_version_number
110: = per_pms_shd.g_old_rec.object_version_number
111: ) Then
112: --

Line 110: = per_pms_shd.g_old_rec.object_version_number

106: Else
107: If (p_scorecard_id
108: = per_pms_shd.g_old_rec.scorecard_id and
109: p_object_version_number
110: = per_pms_shd.g_old_rec.object_version_number
111: ) Then
112: --
113: -- The g_old_rec is current therefore we must
114: -- set the returning function to true

Line 122: Fetch C_Sel1 Into per_pms_shd.g_old_rec;

118: --
119: -- Select the current row into g_old_rec
120: --
121: Open C_Sel1;
122: Fetch C_Sel1 Into per_pms_shd.g_old_rec;
123: If C_Sel1%notfound Then
124: Close C_Sel1;
125: --
126: -- The primary key is invalid therefore we must error

Line 133: <> per_pms_shd.g_old_rec.object_version_number) Then

129: fnd_message.raise_error;
130: End If;
131: Close C_Sel1;
132: If (p_object_version_number
133: <> per_pms_shd.g_old_rec.object_version_number) Then
134: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
135: fnd_message.raise_error;
136: End If;
137: l_fct_ret := true;

Line 220: Fetch C_Sel1 Into per_pms_shd.g_old_rec;

216: ,p_argument_value => p_object_version_number
217: );
218: --
219: Open C_Sel1;
220: Fetch C_Sel1 Into per_pms_shd.g_old_rec;
221: If C_Sel1%notfound then
222: Close C_Sel1;
223: --
224: -- The primary key is invalid therefore we must error

Line 231: <> per_pms_shd.g_old_rec.object_version_number) Then

227: fnd_message.raise_error;
228: End If;
229: Close C_Sel1;
230: If (p_object_version_number
231: <> per_pms_shd.g_old_rec.object_version_number) Then
232: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
233: fnd_message.raise_error;
234: End If;
235: --

Line 355: end per_pms_shd;

351: Return(l_rec);
352: --
353: End convert_args;
354: --
355: end per_pms_shd;