DBA Data[Home] [Help]

APPS.PQP_PCV_SHD dependencies on PQP_PCV_SHD

Line 1: Package Body pqp_pcv_shd as

1: Package Body pqp_pcv_shd as
2: /* $Header: pqpcvrhi.pkb 120.0 2005/05/29 01:55:22 appldev noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

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

Line 113: = pqp_pcv_shd.g_old_rec.configuration_value_id and

109: --
110: l_fct_ret := false;
111: Else
112: If (p_configuration_value_id
113: = pqp_pcv_shd.g_old_rec.configuration_value_id and
114: p_object_version_number
115: = pqp_pcv_shd.g_old_rec.object_version_number
116: ) Then
117: --

Line 115: = pqp_pcv_shd.g_old_rec.object_version_number

111: Else
112: If (p_configuration_value_id
113: = pqp_pcv_shd.g_old_rec.configuration_value_id and
114: p_object_version_number
115: = pqp_pcv_shd.g_old_rec.object_version_number
116: ) Then
117: --
118: -- The g_old_rec is current therefore we must
119: -- set the returning function to true

Line 127: Fetch C_Sel1 Into pqp_pcv_shd.g_old_rec;

123: --
124: -- Select the current row into g_old_rec
125: --
126: Open C_Sel1;
127: Fetch C_Sel1 Into pqp_pcv_shd.g_old_rec;
128: If C_Sel1%notfound Then
129: Close C_Sel1;
130: --
131: -- The primary key is invalid therefore we must error

Line 138: <> pqp_pcv_shd.g_old_rec.object_version_number) Then

134: fnd_message.raise_error;
135: End If;
136: Close C_Sel1;
137: If (p_object_version_number
138: <> pqp_pcv_shd.g_old_rec.object_version_number) Then
139: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
140: fnd_message.raise_error;
141: End If;
142: l_fct_ret := true;

Line 230: Fetch C_Sel1 Into pqp_pcv_shd.g_old_rec;

226: ,p_argument_value => p_object_version_number
227: );
228: --
229: Open C_Sel1;
230: Fetch C_Sel1 Into pqp_pcv_shd.g_old_rec;
231: If C_Sel1%notfound then
232: Close C_Sel1;
233: --
234: -- The primary key is invalid therefore we must error

Line 241: <> pqp_pcv_shd.g_old_rec.object_version_number) Then

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

Line 376: end pqp_pcv_shd;

372: Return(l_rec);
373: --
374: End convert_args;
375: --
376: end pqp_pcv_shd;