APPS.HR_TMP_SHD dependencies on HR_TMP_SHD

Line 1: Package Body hr_tmp_shd as

1: Package Body hr_tmp_shd as
2: /* $Header: hrtmprhi.pkb 115.6 2002/12/03 11:31:46 raranjan noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

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

Line 124: = hr_tmp_shd.g_old_rec.form_template_id and

120: --
121: l_fct_ret := false;
122: Else
123: If (p_form_template_id
124: = hr_tmp_shd.g_old_rec.form_template_id and
125: p_object_version_number
126: = hr_tmp_shd.g_old_rec.object_version_number
127: ) Then
128: --

Line 126: = hr_tmp_shd.g_old_rec.object_version_number

122: Else
123: If (p_form_template_id
124: = hr_tmp_shd.g_old_rec.form_template_id and
125: p_object_version_number
126: = hr_tmp_shd.g_old_rec.object_version_number
127: ) Then
128: --
129: -- The g_old_rec is current therefore we must
130: -- set the returning function to true

Line 138: Fetch C_Sel1 Into hr_tmp_shd.g_old_rec;

134: --
135: -- Select the current row into g_old_rec
136: --
137: Open C_Sel1;
138: Fetch C_Sel1 Into hr_tmp_shd.g_old_rec;
139: If C_Sel1%notfound Then
140: Close C_Sel1;
141: --
142: -- The primary key is invalid therefore we must error

Line 149: <> hr_tmp_shd.g_old_rec.object_version_number) Then

145: fnd_message.raise_error;
146: End If;
147: Close C_Sel1;
148: If (p_object_version_number
149: <> hr_tmp_shd.g_old_rec.object_version_number) Then
150: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
151: fnd_message.raise_error;
152: End If;
153: l_fct_ret := true;

Line 232: Fetch C_Sel1 Into hr_tmp_shd.g_old_rec;

228: ,p_argument_value => p_object_version_number
229: );
230: --Bug:1790746 fix End
231: Open C_Sel1;
232: Fetch C_Sel1 Into hr_tmp_shd.g_old_rec;
233: If C_Sel1%notfound then
234: Close C_Sel1;
235: --
236: -- The primary key is invalid therefore we must error

Line 243: <> hr_tmp_shd.g_old_rec.object_version_number) Then

239: fnd_message.raise_error;
240: End If;
241: Close C_Sel1;
242: If (p_object_version_number
243: <> hr_tmp_shd.g_old_rec.object_version_number) Then
244: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
245: fnd_message.raise_error;
246: End If;
247: --

Line 363: end hr_tmp_shd;

359: Return(l_rec);
360: --
361: End convert_args;
362: --
363: end hr_tmp_shd;