1: Package Body pay_amo_shd as
2: /* $Header: pyamorhi.pkb 120.0.12000000.1 2007/01/17 15:29:33 appldev noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
93: --
94: l_fct_ret := false;
95: Else
96: If (p_module_id
97: = pay_amo_shd.g_old_rec.module_id and
98: p_object_version_number
99: = pay_amo_shd.g_old_rec.object_version_number
100: ) Then
101: --
95: Else
96: If (p_module_id
97: = pay_amo_shd.g_old_rec.module_id and
98: p_object_version_number
99: = pay_amo_shd.g_old_rec.object_version_number
100: ) Then
101: --
102: -- The g_old_rec is current therefore we must
103: -- set the returning function to true
107: --
108: -- Select the current row into g_old_rec
109: --
110: Open C_Sel1;
111: Fetch C_Sel1 Into pay_amo_shd.g_old_rec;
112: If C_Sel1%notfound Then
113: Close C_Sel1;
114: --
115: -- The primary key is invalid therefore we must error
118: fnd_message.raise_error;
119: End If;
120: Close C_Sel1;
121: If (p_object_version_number
122: <> pay_amo_shd.g_old_rec.object_version_number) Then
123: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
124: fnd_message.raise_error;
125: End If;
126: l_fct_ret := true;
176: ,p_argument_value => p_object_version_number
177: );
178: --
179: Open C_Sel1;
180: Fetch C_Sel1 Into pay_amo_shd.g_old_rec;
181: If C_Sel1%notfound then
182: Close C_Sel1;
183: --
184: -- The primary key is invalid therefore we must error
187: fnd_message.raise_error;
188: End If;
189: Close C_Sel1;
190: If (p_object_version_number
191: <> pay_amo_shd.g_old_rec.object_version_number) Then
192: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
193: fnd_message.raise_error;
194: End If;
195: --
250: --
251: End convert_args;
252: --
253: begin
254: g_package := ' pay_amo_shd.'; -- Global package name
255: end pay_amo_shd;
251: End convert_args;
252: --
253: begin
254: g_package := ' pay_amo_shd.'; -- Global package name
255: end pay_amo_shd;