APPS.PQH_DOC_SHD dependencies on PQH_DOC_SHD

Line 1: Package Body pqh_doc_shd as

1: Package Body pqh_doc_shd as
2: /* $Header: pqdocrhi.pkb 120.2 2005/09/19 14:55:19 rthiagar noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

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

Line 93: pqh_doc_shd.g_old_rec.document_id and

89: --
90: l_fct_ret := false;
91: Else
92: If (p_document_id =
93: pqh_doc_shd.g_old_rec.document_id and
94: p_object_version_number =
95: pqh_doc_shd.g_old_rec.object_version_number
96: ) Then
97: --

Line 95: pqh_doc_shd.g_old_rec.object_version_number

91: Else
92: If (p_document_id =
93: pqh_doc_shd.g_old_rec.document_id and
94: p_object_version_number =
95: pqh_doc_shd.g_old_rec.object_version_number
96: ) Then
97: --
98: -- The g_old_rec is current therefore we must
99: -- set the returning function to true

Line 107: Fetch C_Sel1 Into pqh_doc_shd.g_old_rec;

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

Line 118: <> pqh_doc_shd.g_old_rec.object_version_number) Then

114: fnd_message.raise_error;
115: End If;
116: Close C_Sel1;
117: If (p_object_version_number
118: <> pqh_doc_shd.g_old_rec.object_version_number) Then
119: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
120: fnd_message.raise_error;
121: End If;
122: l_fct_ret := true;

Line 225: pqh_doc_shd.g_api_dml := true; -- Set the api dml status

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

Line 237: pqh_doc_shd.g_api_dml := false; -- Unset the api dml status

233: where t.document_id = p_base_key_value
234: and p_effective_date
235: between t.effective_start_date and t.effective_end_date;
236: --
237: pqh_doc_shd.g_api_dml := false; -- Unset the api dml status
238: p_object_version_number := l_object_version_number;
239: hr_utility.set_location(' Leaving:'||l_proc, 15);
240: --
241: Exception

Line 243: pqh_doc_shd.g_api_dml := false; -- Unset the api dml status

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

Line 326: Fetch C_Sel1 Into pqh_doc_shd.g_old_rec;

322: --
323: -- We must select and lock the current row.
324: --
325: Open C_Sel1;
326: Fetch C_Sel1 Into pqh_doc_shd.g_old_rec;
327: If C_Sel1%notfound then
328: Close C_Sel1;
329: --
330: -- The primary key is invalid therefore we must error

Line 337: <> pqh_doc_shd.g_old_rec.object_version_number) Then

333: fnd_message.raise_error;
334: End If;
335: Close C_Sel1;
336: If (p_object_version_number
337: <> pqh_doc_shd.g_old_rec.object_version_number) Then
338: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
339: fnd_message.raise_error;
340: End If;
341: --

Line 441: end pqh_doc_shd;

437: Return(l_rec);
438: --
439: End convert_args;
440: --
441: end pqh_doc_shd;