1 PACKAGE PQH_FR_ASSIGNMENT_API AUTHID CURRENT_USER As
2 /* $Header: pqasgapi.pkh 120.0.12000000.1 2007/01/16 21:49:49 appldev noship $ */
3 -- ----------------------------------------------------------------------------
4 -- |----------------------------< create_affecation >----------------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start of comments}
7 --
8 -- Description: This is used in French PS, Administrative Sitaution -> Affectation SS Module
9 -- Create affectation will create one secondary assignment for a person
10 -- While creating the secondary assignment, system will reuse primary assignments
11 -- information like , 1. People Group 2. Any other Localization mandatory values 3. Establishment
12 --
13 --
14 -- Pre-requisites
15 -- All 'IN' parameters to this procedure have been appropriately derived.
16 -- Employee Primary assignment must be defined, including the mandatory arguments in PUI
17 --
18 -- Post Success:
19 -- p_return_status will return value indicating success.
20 -- Primary Assinment's (Organization, Job, Position ) field values will be updated with
21 -- primary affecation (Organization, Job, Position ) field values.
22 --
23 --
24 -- Post Failure:
25 -- p_return_status will return value indication failure.
26 --
27 -- Access Status:
28 -- Internal Development use only.
29 --
30 -- Field Description
31 --------------------
32 -- p_validate validate=true, will rollback the txn after validation
33 -- validate=false, will commit the data
34 -- p_organization_id Organization Name
35 -- p_person_id Person Id
36 -- p_affectation_type Is the Affectation is Temporary or Perminent
37 -- p_primary_affectation Is this is a Primary Affectation? possible values Yes (Y)/ No (N)
38 -- {End of comments}
39 -- ----------------------------------------------------------------------------
40 -- create_secondary_emp_asg
41
42 procedure create_affectation
43 (p_validate in boolean default false
44 ,p_effective_date in date
45 ,p_organization_id in number
46 ,p_position_id in number
47 ,p_person_id in number
48 ,p_job_id in number
49 ,p_supervisor_id in number default null
50 ,p_assignment_number in out nocopy varchar2
51 ,p_assignment_status_type_id in number
52
53 ,p_identifier in varchar2
54 ,p_affectation_type in varchar2
55 ,p_percent_effected in varchar2
56 ,p_primary_affectation in varchar2 default 'N'
57 ,p_group_name out nocopy varchar2
58
59 ,p_scl_concat_segments in varchar2 default null
60
61 ,p_assignment_id out nocopy number
62 ,p_soft_coding_keyflex_id in out nocopy number
63
64 ,p_object_version_number out nocopy number
65 ,p_effective_start_date out nocopy date
66 ,p_effective_end_date out nocopy date
67 ,p_assignment_sequence out nocopy number
68 );
69
70 --
71 -- Updating an existing Affectation
72 --
73 procedure update_affectation
74 (p_validate in boolean default false
75 ,p_datetrack_update_mode in varchar2
76 ,p_effective_date in date
77 ,p_organization_id in number default hr_api.g_number
78 ,p_position_id in number default hr_api.g_number
79 ,p_person_id in number
80 ,p_job_id in number default hr_api.g_number
81 ,p_supervisor_id in number default hr_api.g_number
82 ,p_assignment_number in varchar2 default hr_api.g_varchar2
83 ,p_assignment_status_type_id in number default hr_api.g_number
84 ,p_identifier in varchar2 default hr_api.g_varchar2
85 ,p_affectation_type in varchar2 default hr_api.g_varchar2
86 ,p_percent_effected in varchar2 default hr_api.g_varchar2
87 ,p_primary_affectation in varchar2 default 'N'
88 ,p_group_name out nocopy varchar2
89
90 ,p_scl_concat_segments in varchar2 default hr_api.g_varchar2
91
92 ,p_assignment_id in number
93 ,p_soft_coding_keyflex_id out nocopy number
94 ,p_object_version_number in out nocopy number
95 ,p_effective_start_date out nocopy date
96 ,p_effective_end_date out nocopy date
97 ,p_assignment_sequence out nocopy number
98 );
99 --
100 --Employment Terms Update Routine
101 PROCEDURE update_employment_terms
102 (p_validate IN BOOLEAN DEFAULT FALSE
103 ,p_datetrack_update_mode IN VARCHAR2
104 ,p_effective_date IN DATE
105 ,p_assignment_id IN NUMBER
106 ,p_establishment_id IN NUMBER
107 ,p_comments IN VARCHAR2 DEFAULT HR_API.g_varchar2
108 ,p_assignment_category IN VARCHAR2
109 ,p_reason_for_parttime IN VARCHAR2 DEFAULT HR_API.g_varchar2
110 ,p_working_hours_share IN VARCHAR2 DEFAULT HR_API.g_varchar2
111 ,p_contract_id IN NUMBER DEFAULT HR_API.g_number
112 ,p_change_reason IN VARCHAR2 DEFAULT HR_API.g_varchar2
113 ,p_normal_hours IN NUMBER DEFAULT HR_API.g_number
114 ,p_frequency IN VARCHAR2 DEFAULT HR_API.g_varchar2
115 ,p_soft_coding_keyflex_id OUT NOCOPY NUMBER
116 ,p_object_version_number IN OUT NOCOPY NUMBER
117 ,p_effective_start_date OUT NOCOPY DATE
118 ,p_effective_end_date OUT NOCOPY DATE
119 ,p_assignment_sequence OUT NOCOPY NUMBER
120 );
121 --
122 --
123 Procedure update_administrative_career
124 (
125 p_validate in boolean default false
126 ,p_datetrack_update_mode in varchar2
127 ,p_effective_date in date
128 ,p_assignment_id in number
129 ,p_corps_id in number
130 ,p_grade_id in number
131 ,p_step_id in number
132 ,p_progression_speed in varchar2
133 ,p_personal_gross_index in varchar2
134 ,p_employee_category in varchar2
135
136
137 ,p_soft_coding_keyflex_id out nocopy number
138 ,p_object_version_number in out nocopy number
139 ,p_effective_start_date out nocopy date
140 ,p_effective_end_date out nocopy date
141 ,p_assignment_sequence out nocopy number
142
143
144 );
145
146 procedure terminate_affectation
147 (p_validate in boolean
148 ,p_assignment_id in number
149 ,p_effective_date in date
150 ,p_assignment_status_type_id in number
151 ,p_primary_affectation in varchar2 default 'N'
152 ,p_group_name out nocopy varchar2
153 ,p_object_version_number in out nocopy number
154 ,p_effective_start_date out nocopy date
155 ,p_effective_end_date out nocopy date
156 );
157
158 procedure suspend_affectation
159 (p_validate in boolean
160 ,p_assignment_id in number
161 ,p_effective_date in date
162 ,p_assignment_status_type_id in number
163 ,p_object_version_number in out nocopy number
164 ,p_effective_start_date out nocopy date
165 ,p_effective_end_date out nocopy date
166 );
167
168 procedure activate_affectation
169 (p_validate in boolean
170 ,p_assignment_id in number
171 ,p_effective_date in date
172 ,p_assignment_status_type_id in number
173 ,p_object_version_number in out nocopy number
174 ,p_effective_start_date out nocopy date
175 ,p_effective_end_date out nocopy date
176 );
177 --
178 end pqh_fr_assignment_api;