APPS.HXC_DRU_SHD dependencies on HXC_DRU_SHD

Line 1: Package Body hxc_dru_shd as

1: Package Body hxc_dru_shd as
2: /* $Header: hxcdrurhi.pkb 120.2 2005/09/23 08:07:21 sechandr noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

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

Line 98: = hxc_dru_shd.g_old_rec.data_app_rule_usage_id and

94: --
95: l_fct_ret := false;
96: Else
97: If (p_data_app_rule_usage_id
98: = hxc_dru_shd.g_old_rec.data_app_rule_usage_id and
99: p_object_version_number
100: = hxc_dru_shd.g_old_rec.object_version_number
101: ) Then
102: --

Line 100: = hxc_dru_shd.g_old_rec.object_version_number

96: Else
97: If (p_data_app_rule_usage_id
98: = hxc_dru_shd.g_old_rec.data_app_rule_usage_id and
99: p_object_version_number
100: = hxc_dru_shd.g_old_rec.object_version_number
101: ) Then
102: --
103: -- The g_old_rec is current therefore we must
104: -- set the returning function to true

Line 112: Fetch C_Sel1 Into hxc_dru_shd.g_old_rec;

108: --
109: -- Select the current row into g_old_rec
110: --
111: Open C_Sel1;
112: Fetch C_Sel1 Into hxc_dru_shd.g_old_rec;
113: If C_Sel1%notfound Then
114: Close C_Sel1;
115: --
116: -- The primary key is invalid therefore we must error

Line 123: <> hxc_dru_shd.g_old_rec.object_version_number) Then

119: fnd_message.raise_error;
120: End If;
121: Close C_Sel1;
122: If (p_object_version_number
123: <> hxc_dru_shd.g_old_rec.object_version_number) Then
124: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
125: fnd_message.raise_error;
126: End If;
127: l_fct_ret := true;

Line 171: Fetch C_Sel1 Into hxc_dru_shd.g_old_rec;

167: ,p_argument_value => p_data_app_rule_usage_id
168: );
169: --
170: Open C_Sel1;
171: Fetch C_Sel1 Into hxc_dru_shd.g_old_rec;
172: If C_Sel1%notfound then
173: Close C_Sel1;
174: --
175: -- The primary key is invalid therefore we must error

Line 182: <> hxc_dru_shd.g_old_rec.object_version_number) Then

178: fnd_message.raise_error;
179: End If;
180: Close C_Sel1;
181: If (p_object_version_number
182: <> hxc_dru_shd.g_old_rec.object_version_number) Then
183: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
184: fnd_message.raise_error;
185: End If;
186: --

Line 234: end hxc_dru_shd;

230: Return(l_rec);
231: --
232: End convert_args;
233: --
234: end hxc_dru_shd;