[Home] [Help]
PACKAGE BODY: APPS.HR_JP_ASSIGNMENT_PKG
Source
1 Package Body hr_jp_assignment_pkg as
2 /* $Header: hrjppasg.pkb 115.1 99/07/17 16:39:01 porting ship $ */
3 --
4 -- Package Variables
5 --
6 g_package varchar2(33) := ' hr_jp_assignment_pkg.';
7 --
8 -- ----------------------------------------------------------------------------
9 -- |---------------------< update_jp_emp_asg_criteria >-----------------------|
10 -- ----------------------------------------------------------------------------
11 --
12 procedure update_jp_emp_asg_criteria
13 (p_validate in boolean default false
14 ,p_effective_date in date
15 ,p_datetrack_update_mode in varchar2
16 ,p_assignment_id in number
17 ,p_object_version_number in out number
18 ,p_grade_id in number default hr_api.g_number
19 ,p_position_id in number default hr_api.g_number
20 ,p_job_id in number default hr_api.g_number
21 ,p_payroll_id in number default hr_api.g_number
22 ,p_location_id in number default hr_api.g_number
23 ,p_special_ceiling_step_id in out number
24 ,p_organization_id in number default hr_api.g_number
25 ,p_pay_basis_id in number default hr_api.g_number
26 ,p_segment1 in varchar2 default hr_api.g_varchar2
27 ,p_segment2 in varchar2 default hr_api.g_varchar2
28 ,p_segment3 in varchar2 default hr_api.g_varchar2
29 ,p_segment4 in varchar2 default hr_api.g_varchar2
30 ,p_segment5 in varchar2 default hr_api.g_varchar2
31 ,p_segment6 in varchar2 default hr_api.g_varchar2
32 ,p_segment7 in varchar2 default hr_api.g_varchar2
33 ,p_segment8 in varchar2 default hr_api.g_varchar2
34 ,p_segment9 in varchar2 default hr_api.g_varchar2
35 ,p_segment10 in varchar2 default hr_api.g_varchar2
36 ,p_segment11 in varchar2 default hr_api.g_varchar2
37 ,p_segment12 in varchar2 default hr_api.g_varchar2
38 ,p_segment13 in varchar2 default hr_api.g_varchar2
39 ,p_segment14 in varchar2 default hr_api.g_varchar2
40 ,p_segment15 in varchar2 default hr_api.g_varchar2
41 ,p_segment16 in varchar2 default hr_api.g_varchar2
42 ,p_segment17 in varchar2 default hr_api.g_varchar2
43 ,p_segment18 in varchar2 default hr_api.g_varchar2
44 ,p_segment19 in varchar2 default hr_api.g_varchar2
45 ,p_segment20 in varchar2 default hr_api.g_varchar2
46 ,p_segment21 in varchar2 default hr_api.g_varchar2
47 ,p_segment22 in varchar2 default hr_api.g_varchar2
48 ,p_segment23 in varchar2 default hr_api.g_varchar2
49 ,p_segment24 in varchar2 default hr_api.g_varchar2
50 ,p_segment25 in varchar2 default hr_api.g_varchar2
51 ,p_segment26 in varchar2 default hr_api.g_varchar2
52 ,p_segment27 in varchar2 default hr_api.g_varchar2
53 ,p_segment28 in varchar2 default hr_api.g_varchar2
54 ,p_segment29 in varchar2 default hr_api.g_varchar2
55 ,p_segment30 in varchar2 default hr_api.g_varchar2
56 ,p_employment_category_code in varchar2 default hr_api.g_varchar2
57 ,p_effective_start_date out date
58 ,p_effective_end_date out date
59 ,p_people_group_id out number
60 ,p_group_name out varchar2
61 ,p_org_now_no_manager_warning out boolean
62 ,p_other_manager_warning out boolean
63 ,p_spp_delete_warning out boolean
64 ,p_entries_changed_warning out varchar2
65 ,p_tax_district_changed_warning out boolean
66 ) is
67 --
68 -- Declare cursors and local variables
69 --
70 l_proc varchar2(72) :=
71 g_package || 'update_jp_emp_asg_criteria';
72 --
73 begin
74 hr_utility.set_location('Entering:'|| l_proc, 1);
75 --
76 hr_utility.set_location(l_proc, 10);
77 --
78 --
79 hr_assignment_api.update_emp_asg_criteria
80 (p_validate => p_validate
81 ,p_effective_date => p_effective_date
82 ,p_datetrack_update_mode => p_datetrack_update_mode
83 ,p_assignment_id => p_assignment_id
84 ,p_object_version_number => p_object_version_number
85 ,p_grade_id => p_grade_id
86 ,p_position_id => p_position_id
87 ,p_job_id => p_job_id
88 ,p_payroll_id => p_payroll_id
89 ,p_location_id => p_location_id
90 ,p_special_ceiling_step_id => p_special_ceiling_step_id
91 ,p_organization_id => p_organization_id
92 ,p_pay_basis_id => p_pay_basis_id
93 ,p_segment1 => p_segment1
94 ,p_segment2 => p_segment2
95 ,p_segment3 => p_segment3
96 ,p_segment4 => p_segment4
97 ,p_segment5 => p_segment5
98 ,p_segment6 => p_segment6
99 ,p_segment7 => p_segment7
100 ,p_segment8 => p_segment8
101 ,p_segment9 => p_segment9
102 ,p_segment10 => p_segment10
103 ,p_segment11 => p_segment11
104 ,p_segment12 => p_segment12
105 ,p_segment13 => p_segment13
106 ,p_segment14 => p_segment14
107 ,p_segment15 => p_segment15
108 ,p_segment16 => p_segment16
109 ,p_segment17 => p_segment17
110 ,p_segment18 => p_segment18
111 ,p_segment19 => p_segment19
112 ,p_segment20 => p_segment20
113 ,p_segment21 => p_segment21
114 ,p_segment22 => p_segment22
115 ,p_segment23 => p_segment23
116 ,p_segment24 => p_segment24
117 ,p_segment25 => p_segment25
118 ,p_segment26 => p_segment26
119 ,p_segment27 => p_segment27
120 ,p_segment28 => p_segment28
121 ,p_segment29 => p_segment29
122 ,p_segment30 => p_segment30
123 ,p_employment_category => p_employment_category_code
124 ,p_effective_start_date => p_effective_start_date
125 ,p_effective_end_date => p_effective_end_date
126 ,p_people_group_id => p_people_group_id
127 ,p_group_name => p_group_name
128 ,p_org_now_no_manager_warning => p_org_now_no_manager_warning
129 ,p_other_manager_warning => p_other_manager_warning
130 ,p_spp_delete_warning => p_spp_delete_warning
131 ,p_entries_changed_warning => p_entries_changed_warning
132 ,p_tax_district_changed_warning => p_tax_district_changed_warning
133 );
134 --
135 hr_utility.set_location(' Leaving:'||l_proc, 270);
136 --
137 end update_jp_emp_asg_criteria;
138 --
139 end hr_jp_assignment_pkg;