eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_SPP_SHD dependencies on PER_SPP_SHD

Line 1: Package Body per_spp_shd as

1: Package Body per_spp_shd as
2: /* $Header: pespprhi.pkb 120.1.12000000.2 2007/08/30 07:19:59 ande noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

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

Line 139: per_spp_shd.g_old_rec.placement_id and

135: Else
136: hr_utility.set_location('Entering :'||l_proc, 15);
137:
138: If (p_placement_id =
139: per_spp_shd.g_old_rec.placement_id and
140: p_object_version_number =
141: per_spp_shd.g_old_rec.object_version_number) Then
142: --
143: -- The g_old_rec is current therefore we must

Line 141: per_spp_shd.g_old_rec.object_version_number) Then

137:
138: If (p_placement_id =
139: per_spp_shd.g_old_rec.placement_id and
140: p_object_version_number =
141: per_spp_shd.g_old_rec.object_version_number) Then
142: --
143: -- The g_old_rec is current therefore we must
144: -- set the returning function to true
145: --

Line 154: Fetch C_Sel1 Into per_spp_shd.g_old_rec;

150: --
151: -- Select the current row
152: --
153: Open C_Sel1;
154: Fetch C_Sel1 Into per_spp_shd.g_old_rec;
155: If C_Sel1%notfound Then
156: Close C_Sel1;
157: --
158: -- The primary key is invalid therefore we must error

Line 166: <> per_spp_shd.g_old_rec.object_version_number) Then

162: End If;
163: Close C_Sel1;
164: hr_utility.set_location('Entering :'||l_proc, 30);
165: If (p_object_version_number
166: <> per_spp_shd.g_old_rec.object_version_number) Then
167: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
168: fnd_message.raise_error;
169: End If;
170: l_fct_ret := true;

Line 333: per_spp_shd.g_api_dml := true; -- Set the api dml status

329: hr_utility.set_location('PLacement_id: '||p_base_key_value,1);
330: hr_utility.set_location('Object Version Number: '||l_object_version_number,2);
331: hr_utility.set_location('Effective_Date: '||p_effective_date,3);
332: hr_utility.set_location('NEW Effective_End_Date: '||p_new_effective_end_date,4);
333: per_spp_shd.g_api_dml := true; -- Set the api dml status
334: --
335: -- Update the specified datetrack row setting the effective
336: -- end date to the specified new effective end date.
337: --

Line 345: per_spp_shd.g_api_dml := false; -- Unset the api dml status

341: where t.placement_id = p_base_key_value
342: and p_effective_date
343: between t.effective_start_date and t.effective_end_date;
344: --
345: per_spp_shd.g_api_dml := false; -- Unset the api dml status
346: p_object_version_number := l_object_version_number;
347: hr_utility.set_location(' Leaving:'||l_proc, 15);
348: --
349: Exception

Line 351: per_spp_shd.g_api_dml := false; -- Unset the api dml status

347: hr_utility.set_location(' Leaving:'||l_proc, 15);
348: --
349: Exception
350: When Others Then
351: per_spp_shd.g_api_dml := false; -- Unset the api dml status
352: Raise;
353: --
354: End upd_effective_end_date;
355: --

Line 478: Fetch C_Sel1 Into per_spp_shd.g_old_rec;

474: --
475: hr_utility.set_location('Entering:'||l_proc, 10);
476: --
477: Open C_Sel1;
478: Fetch C_Sel1 Into per_spp_shd.g_old_rec;
479:
480: If C_Sel1%notfound then
481: Close C_Sel1;
482: --

Line 490: <> per_spp_shd.g_old_rec.object_version_number) Then

486: fnd_message.raise_error;
487: End If;
488: Close C_Sel1;
489: If (p_object_version_number
490: <> per_spp_shd.g_old_rec.object_version_number) Then
491: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
492: fnd_message.raise_error;
493: End If;
494: --

Line 518: ,p_parent_key_value1 => per_spp_shd.g_old_rec.step_id

514: ,p_base_key_column => 'placement_id'
515: ,p_base_key_value => p_placement_id
516: ,p_parent_table_name1 => 'per_spinal_point_steps_f'
517: ,p_parent_key_column1 => 'step_id'
518: ,p_parent_key_value1 => per_spp_shd.g_old_rec.step_id
519: -- ,p_parent_table_name2 => 'per_all_assignments_f'
520: -- ,p_parent_key_column2 => 'assignment_id'
521: -- ,p_parent_key_value2 => per_spp_shd.g_old_rec.assignment_id
522: ,p_enforce_foreign_locking => l_enforce_foreign_locking

Line 521: -- ,p_parent_key_value2 => per_spp_shd.g_old_rec.assignment_id

517: ,p_parent_key_column1 => 'step_id'
518: ,p_parent_key_value1 => per_spp_shd.g_old_rec.step_id
519: -- ,p_parent_table_name2 => 'per_all_assignments_f'
520: -- ,p_parent_key_column2 => 'assignment_id'
521: -- ,p_parent_key_value2 => per_spp_shd.g_old_rec.assignment_id
522: ,p_enforce_foreign_locking => l_enforce_foreign_locking
523: ,p_validation_start_date => l_validation_start_date1
524: ,p_validation_end_date => l_validation_end_date1
525: );

Line 537: --,p_parent_key_value1 => per_spp_shd.g_old_rec.step_id

533: ,p_base_key_column => 'placement_id'
534: ,p_base_key_value => p_placement_id
535: --,p_parent_table_name1 => 'per_spinal_point_steps_f'
536: --,p_parent_key_column1 => 'step_id'
537: --,p_parent_key_value1 => per_spp_shd.g_old_rec.step_id
538: ,p_parent_table_name2 => 'per_all_assignments_f'
539: ,p_parent_key_column2 => 'assignment_id'
540: ,p_parent_key_value2 => per_spp_shd.g_old_rec.assignment_id
541: ,p_enforce_foreign_locking => true

Line 540: ,p_parent_key_value2 => per_spp_shd.g_old_rec.assignment_id

536: --,p_parent_key_column1 => 'step_id'
537: --,p_parent_key_value1 => per_spp_shd.g_old_rec.step_id
538: ,p_parent_table_name2 => 'per_all_assignments_f'
539: ,p_parent_key_column2 => 'assignment_id'
540: ,p_parent_key_value2 => per_spp_shd.g_old_rec.assignment_id
541: ,p_enforce_foreign_locking => true
542: ,p_validation_start_date => l_validation_start_date2
543: ,p_validation_end_date => l_validation_end_date2
544: );

Line 710: end per_spp_shd;

706: Return(l_rec);
707: --
708: End convert_args;
709: --
710: end per_spp_shd;