DBA Data[Home] [Help]

APPS.HXC_EGC_SHD dependencies on HXC_EGC_SHD

Line 1: Package Body hxc_egc_shd as

1: Package Body hxc_egc_shd as
2: /* $Header: hxcegcrhi.pkb 120.2 2005/09/23 10:39:50 sechandr noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

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

Line 114: = hxc_egc_shd.g_old_rec.entity_group_comp_id and

110: --
111: l_fct_ret := false;
112: Else
113: If (p_entity_group_comp_id
114: = hxc_egc_shd.g_old_rec.entity_group_comp_id and
115: p_object_version_number
116: = hxc_egc_shd.g_old_rec.object_version_number
117: ) Then
118: --

Line 116: = hxc_egc_shd.g_old_rec.object_version_number

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

Line 128: Fetch C_Sel1 Into hxc_egc_shd.g_old_rec;

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

Line 139: <> hxc_egc_shd.g_old_rec.object_version_number) Then

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

Line 218: Fetch C_Sel1 Into hxc_egc_shd.g_old_rec;

214: ,p_argument_value => p_entity_group_comp_id
215: );
216: --
217: Open C_Sel1;
218: Fetch C_Sel1 Into hxc_egc_shd.g_old_rec;
219: If C_Sel1%notfound then
220: Close C_Sel1;
221: --
222: -- The primary key is invalid therefore we must error

Line 229: <> hxc_egc_shd.g_old_rec.object_version_number) Then

225: fnd_message.raise_error;
226: End If;
227: Close C_Sel1;
228: If (p_object_version_number
229: <> hxc_egc_shd.g_old_rec.object_version_number) Then
230: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
231: fnd_message.raise_error;
232: End If;
233: --

Line 343: end hxc_egc_shd;

339: Return(l_rec);
340: --
341: End convert_args;
342: --
343: end hxc_egc_shd;