APPS.AME_CFV_SHD dependencies on AME_CFV_SHD

Line 1: Package Body ame_cfv_shd as

1: Package Body ame_cfv_shd as
2: /* $Header: amcfvrhi.pkb 120.2 2005/11/22 03:15 santosin noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

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

Line 79: ame_cfv_shd.g_old_rec.application_id and

75: --
76: l_fct_ret := false;
77: Else
78: If (p_application_id =
79: ame_cfv_shd.g_old_rec.application_id and
80: p_object_version_number =
81: ame_cfv_shd.g_old_rec.object_version_number) Then
82: --
83: -- The g_old_rec is current therefore we must

Line 81: ame_cfv_shd.g_old_rec.object_version_number) Then

77: Else
78: If (p_application_id =
79: ame_cfv_shd.g_old_rec.application_id and
80: p_object_version_number =
81: ame_cfv_shd.g_old_rec.object_version_number) Then
82: --
83: -- The g_old_rec is current therefore we must
84: -- set the returning function to true
85: --

Line 92: Fetch C_Sel1 Into ame_cfv_shd.g_old_rec;

88: --
89: -- Select the current row
90: --
91: Open C_Sel1;
92: Fetch C_Sel1 Into ame_cfv_shd.g_old_rec;
93: If C_Sel1%notfound Then
94: Close C_Sel1;
95: --
96: -- The primary key is invalid therefore we must error

Line 103: <> ame_cfv_shd.g_old_rec.object_version_number) Then

99: fnd_message.raise_error;
100: End If;
101: Close C_Sel1;
102: If (p_object_version_number
103: <> ame_cfv_shd.g_old_rec.object_version_number) Then
104: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
105: fnd_message.raise_error;
106: End If;
107: l_fct_ret := true;

Line 138: ame_cfv_shd.get_object_version_number

134: -- Because we are updating a row we must get the next object
135: -- version number.
136: --
137: l_object_version_number :=
138: ame_cfv_shd.get_object_version_number
139: (p_application_id => p_application_id
140: ,p_variable_name => p_variable_name
141: );
142: --

Line 239: Fetch C_Sel1 Into ame_cfv_shd.g_old_rec;

235: --
236: -- We must select and lock the current row.
237: --
238: Open C_Sel1;
239: Fetch C_Sel1 Into ame_cfv_shd.g_old_rec;
240: If C_Sel1%notfound then
241: Close C_Sel1;
242: --
243: -- The primary key is invalid therefore we must error

Line 250: <> ame_cfv_shd.g_old_rec.object_version_number) Then

246: fnd_message.raise_error;
247: End If;
248: Close C_Sel1;
249: If (p_object_version_number
250: <> ame_cfv_shd.g_old_rec.object_version_number) Then
251: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
252: fnd_message.raise_error;
253: End If;
254: --

Line 273: p_validation_end_date := ame_cfv_shd.g_old_rec.end_date;

269: -- Set the validation start and end date OUT arguments
270: --
271: if (p_datetrack_mode = hr_api.g_update) then
272: p_validation_start_date := p_effective_date;
273: p_validation_end_date := ame_cfv_shd.g_old_rec.end_date;
274: elsif (p_datetrack_mode = hr_api.g_delete) then
275: p_validation_start_date := p_effective_date;
276: p_validation_end_date := p_effective_date;
277: end if;

Line 358: end ame_cfv_shd;

354: --
355: End get_object_version_number;
356: --
357: --
358: end ame_cfv_shd;