1: Package Body per_sps_shd as
2: /* $Header: pespsrhi.pkb 120.5.12000000.1 2007/01/22 04:39:24 appldev noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' per_sps_shd.'; -- Global package name
9: --
10: -- ----------------------------------------------------------------------------
11: -- |------------------------< return_api_dml_status >-------------------------|
12: -- ----------------------------------------------------------------------------
127: --
128: l_fct_ret := false;
129: Else
130: If (p_step_id =
131: per_sps_shd.g_old_rec.step_id and
132: p_object_version_number =
133: per_sps_shd.g_old_rec.object_version_number
134: ) Then
135: --
129: Else
130: If (p_step_id =
131: per_sps_shd.g_old_rec.step_id and
132: p_object_version_number =
133: per_sps_shd.g_old_rec.object_version_number
134: ) Then
135: --
136: -- The g_old_rec is current therefore we must
137: -- set the returning function to true
141: --
142: -- Select the current row
143: --
144: Open C_Sel1;
145: Fetch C_Sel1 Into per_sps_shd.g_old_rec;
146: If C_Sel1%notfound Then
147: Close C_Sel1;
148: --
149: -- The primary key is invalid therefore we must error
152: fnd_message.raise_error;
153: End If;
154: Close C_Sel1;
155: If (p_object_version_number
156: <> per_sps_shd.g_old_rec.object_version_number) Then
157: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
158: fnd_message.raise_error;
159: End If;
160: l_fct_ret := true;
282: ,p_base_key_value => p_base_key_value
283: );
284: --
285: hr_utility.set_location(l_proc, 10);
286: per_sps_shd.g_api_dml := true; -- Set the api dml status
287: --
288: -- Update the specified datetrack row setting the effective
289: -- end date to the specified new effective end date.
290: --
294: where t.step_id = p_base_key_value
295: and p_effective_date
296: between t.effective_start_date and t.effective_end_date;
297: --
298: per_sps_shd.g_api_dml := false; -- Unset the api dml status
299: p_object_version_number := l_object_version_number;
300: hr_utility.set_location(' Leaving:'||l_proc, 15);
301: --
302: Exception
300: hr_utility.set_location(' Leaving:'||l_proc, 15);
301: --
302: Exception
303: When Others Then
304: per_sps_shd.g_api_dml := false; -- Unset the api dml status
305: Raise;
306: --
307: End upd_effective_end_date;
308: --
412: --
413: -- We must select and lock the current row.
414: --
415: Open C_Sel1;
416: Fetch C_Sel1 Into per_sps_shd.g_old_rec;
417: If C_Sel1%notfound then
418: Close C_Sel1;
419: --
420: -- The primary key is invalid therefore we must error
423: fnd_message.raise_error;
424: End If;
425: Close C_Sel1;
426: If (p_object_version_number
427: <> per_sps_shd.g_old_rec.object_version_number) Then
428: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
429: fnd_message.raise_error;
430: End If;
431:
443: ,p_base_key_column => 'step_id'
444: ,p_base_key_value => p_step_id
445: ,p_parent_table_name1 => 'per_grade_spines_f'
446: ,p_parent_key_column1 => 'grade_spine_id'
447: ,p_parent_key_value1 => per_sps_shd.g_old_rec.grade_spine_id
448: ,p_child_table_name1 => 'per_cagr_entitlement_lines_f'
449: ,p_child_key_column1 => 'cagr_entitlement_line_id'
450: ,p_child_table_name2 => 'hr_all_positions_f'
451: ,p_child_key_column2 => 'position_id'
595: Return(l_rec);
596: --
597: End convert_args;
598: --
599: end per_sps_shd;