APPS.PQP_AAT_SHD dependencies on PQP_AAT_SHD

Line 1: Package Body pqp_aat_shd as

1: Package Body pqp_aat_shd as
2: /* $Header: pqaatrhi.pkb 120.2.12010000.3 2009/07/01 10:58:37 dchindar ship $ */
3: --
4: -- ---------------------------------------------------------------------------+
5: -- | Private Global Definitions |

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

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

Line 163: pqp_aat_shd.g_old_rec.assignment_attribute_id and

159: --
160: l_fct_ret := false;
161: Else
162: If (p_assignment_attribute_id =
163: pqp_aat_shd.g_old_rec.assignment_attribute_id and
164: p_object_version_number =
165: pqp_aat_shd.g_old_rec.object_version_number) Then
166: --
167: -- The g_old_rec is current therefore we must

Line 165: pqp_aat_shd.g_old_rec.object_version_number) Then

161: Else
162: If (p_assignment_attribute_id =
163: pqp_aat_shd.g_old_rec.assignment_attribute_id and
164: p_object_version_number =
165: pqp_aat_shd.g_old_rec.object_version_number) Then
166: --
167: -- The g_old_rec is current therefore we must
168: -- set the returning function to true
169: --

Line 176: Fetch C_Sel1 Into pqp_aat_shd.g_old_rec;

172: --
173: -- Select the current row
174: --
175: Open C_Sel1;
176: Fetch C_Sel1 Into pqp_aat_shd.g_old_rec;
177: If C_Sel1%notfound Then
178: Close C_Sel1;
179: --
180: -- The primary key is invalid therefore we must error

Line 187: <> pqp_aat_shd.g_old_rec.object_version_number) Then

183: fnd_message.raise_error;
184: End If;
185: Close C_Sel1;
186: If (p_object_version_number
187: <> pqp_aat_shd.g_old_rec.object_version_number) Then
188: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
189: fnd_message.raise_error;
190: End If;
191: l_fct_ret := true;

Line 294: pqp_aat_shd.g_api_dml := true; -- Set the api dml status

290: ,p_base_key_value => p_base_key_value
291: );
292: --
293: hr_utility.set_location(l_proc, 10);
294: pqp_aat_shd.g_api_dml := true; -- Set the api dml status
295: --
296: -- Update the specified datetrack row setting the effective
297: -- end date to the specified new effective end date.
298: --

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

302: where t.assignment_attribute_id = p_base_key_value
303: and p_effective_date
304: between t.effective_start_date and t.effective_end_date;
305: --
306: pqp_aat_shd.g_api_dml := false; -- Unset the api dml status
307: p_object_version_number := l_object_version_number;
308: hr_utility.set_location(' Leaving:'||l_proc, 15);
309: --
310: Exception

Line 312: pqp_aat_shd.g_api_dml := false; -- Unset the api dml status

308: hr_utility.set_location(' Leaving:'||l_proc, 15);
309: --
310: Exception
311: When Others Then
312: pqp_aat_shd.g_api_dml := false; -- Unset the api dml status
313: Raise;
314: --
315: End upd_effective_end_date;
316: --

Line 461: Fetch C_Sel1 Into pqp_aat_shd.g_old_rec;

457: --
458: -- We must select and lock the current row.
459: --
460: Open C_Sel1;
461: Fetch C_Sel1 Into pqp_aat_shd.g_old_rec;
462: If C_Sel1%notfound then
463: Close C_Sel1;
464: --
465: -- The primary key is invalid therefore we must error

Line 472: <> pqp_aat_shd.g_old_rec.object_version_number) Then

468: fnd_message.raise_error;
469: End If;
470: Close C_Sel1;
471: If (p_object_version_number
472: <> pqp_aat_shd.g_old_rec.object_version_number) Then
473: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
474: fnd_message.raise_error;
475: End If;
476: --

Line 708: end pqp_aat_shd;

704: Return(l_rec);
705: --
706: End convert_args;
707: --
708: end pqp_aat_shd;