DBA Data[Home] [Help]

APPS.PAY_ECU_SHD dependencies on PAY_ECU_SHD

Line 1: Package Body pay_ecu_shd as

1: Package Body pay_ecu_shd as
2: /* $Header: pyecurhi.pkb 120.2 2006/02/06 05:37:22 pgongada noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

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

Line 117: pay_ecu_shd.g_old_rec.element_class_usage_id and

113: --
114: l_fct_ret := false;
115: Else
116: If (p_element_class_usage_id =
117: pay_ecu_shd.g_old_rec.element_class_usage_id and
118: p_object_version_number =
119: pay_ecu_shd.g_old_rec.object_version_number
120: ) Then
121: --

Line 119: pay_ecu_shd.g_old_rec.object_version_number

115: Else
116: If (p_element_class_usage_id =
117: pay_ecu_shd.g_old_rec.element_class_usage_id and
118: p_object_version_number =
119: pay_ecu_shd.g_old_rec.object_version_number
120: ) Then
121: --
122: -- The g_old_rec is current therefore we must
123: -- set the returning function to true

Line 131: Fetch C_Sel1 Into pay_ecu_shd.g_old_rec;

127: --
128: -- Select the current row
129: --
130: Open C_Sel1;
131: Fetch C_Sel1 Into pay_ecu_shd.g_old_rec;
132: If C_Sel1%notfound Then
133: Close C_Sel1;
134: --
135: -- The primary key is invalid therefore we must error

Line 142: <> pay_ecu_shd.g_old_rec.object_version_number) Then

138: fnd_message.raise_error;
139: End If;
140: Close C_Sel1;
141: If (p_object_version_number
142: <> pay_ecu_shd.g_old_rec.object_version_number) Then
143: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
144: fnd_message.raise_error;
145: End If;
146: l_fct_ret := true;

Line 337: Fetch C_Sel1 Into pay_ecu_shd.g_old_rec;

333: --
334: -- We must select and lock the current row.
335: --
336: Open C_Sel1;
337: Fetch C_Sel1 Into pay_ecu_shd.g_old_rec;
338: If C_Sel1%notfound then
339: Close C_Sel1;
340: --
341: -- The primary key is invalid therefore we must error

Line 348: <> pay_ecu_shd.g_old_rec.object_version_number) Then

344: fnd_message.raise_error;
345: End If;
346: Close C_Sel1;
347: If (p_object_version_number
348: <> pay_ecu_shd.g_old_rec.object_version_number) Then
349: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
350: fnd_message.raise_error;
351: End If;
352: --

Line 435: end pay_ecu_shd;

431: Return(l_rec);
432: --
433: End convert_args;
434: --
435: end pay_ecu_shd;