APPS.PQH_DOA_SHD dependencies on PQH_DOA_SHD

Line 1: Package Body pqh_doa_shd as

1: Package Body pqh_doa_shd as
2: /* $Header: pqdoarhi.pkb 115.0 2003/01/06 09:20:29 svorugan noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

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

Line 90: pqh_doa_shd.g_old_rec.document_attribute_id and

86: --
87: l_fct_ret := false;
88: Else
89: If (p_document_attribute_id =
90: pqh_doa_shd.g_old_rec.document_attribute_id and
91: p_object_version_number =
92: pqh_doa_shd.g_old_rec.object_version_number
93: ) Then
94: --

Line 92: pqh_doa_shd.g_old_rec.object_version_number

88: Else
89: If (p_document_attribute_id =
90: pqh_doa_shd.g_old_rec.document_attribute_id and
91: p_object_version_number =
92: pqh_doa_shd.g_old_rec.object_version_number
93: ) Then
94: --
95: -- The g_old_rec is current therefore we must
96: -- set the returning function to true

Line 104: Fetch C_Sel1 Into pqh_doa_shd.g_old_rec;

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

Line 115: <> pqh_doa_shd.g_old_rec.object_version_number) Then

111: fnd_message.raise_error;
112: End If;
113: Close C_Sel1;
114: If (p_object_version_number
115: <> pqh_doa_shd.g_old_rec.object_version_number) Then
116: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
117: fnd_message.raise_error;
118: End If;
119: l_fct_ret := true;

Line 222: pqh_doa_shd.g_api_dml := true; -- Set the api dml status

218: ,p_base_key_value => p_base_key_value
219: );
220: --
221: hr_utility.set_location(l_proc, 10);
222: pqh_doa_shd.g_api_dml := true; -- Set the api dml status
223: --
224: -- Update the specified datetrack row setting the effective
225: -- end date to the specified new effective end date.
226: --

Line 234: pqh_doa_shd.g_api_dml := false; -- Unset the api dml status

230: where t.document_attribute_id = p_base_key_value
231: and p_effective_date
232: between t.effective_start_date and t.effective_end_date;
233: --
234: pqh_doa_shd.g_api_dml := false; -- Unset the api dml status
235: p_object_version_number := l_object_version_number;
236: hr_utility.set_location(' Leaving:'||l_proc, 15);
237: --
238: Exception

Line 240: pqh_doa_shd.g_api_dml := false; -- Unset the api dml status

236: hr_utility.set_location(' Leaving:'||l_proc, 15);
237: --
238: Exception
239: When Others Then
240: pqh_doa_shd.g_api_dml := false; -- Unset the api dml status
241: Raise;
242: --
243: End upd_effective_end_date;
244: --

Line 314: Fetch C_Sel1 Into pqh_doa_shd.g_old_rec;

310: --
311: -- We must select and lock the current row.
312: --
313: Open C_Sel1;
314: Fetch C_Sel1 Into pqh_doa_shd.g_old_rec;
315: If C_Sel1%notfound then
316: Close C_Sel1;
317: --
318: -- The primary key is invalid therefore we must error

Line 325: <> pqh_doa_shd.g_old_rec.object_version_number) Then

321: fnd_message.raise_error;
322: End If;
323: Close C_Sel1;
324: If (p_object_version_number
325: <> pqh_doa_shd.g_old_rec.object_version_number) Then
326: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
327: fnd_message.raise_error;
328: End If;
329: --

Line 342: ,p_parent_key_value1 => pqh_doa_shd.g_old_rec.document_id

338: ,p_base_key_column => 'document_attribute_id'
339: ,p_base_key_value => p_document_attribute_id
340: ,p_parent_table_name1 => 'pqh_documents_f'
341: ,p_parent_key_column1 => 'document_id'
342: ,p_parent_key_value1 => pqh_doa_shd.g_old_rec.document_id
343: ,p_enforce_foreign_locking => true
344: ,p_validation_start_date => l_validation_start_date
345: ,p_validation_end_date => l_validation_end_date
346: );

Line 413: end pqh_doa_shd;

409: Return(l_rec);
410: --
411: End convert_args;
412: --
413: end pqh_doa_shd;