1 Package hr_fr_periods_of_service_api AUTHID CURRENT_USER as
2 /* $Header: pepdsfri.pkh 120.1 2005/10/02 02:20:00 aroussel $ */
3 /*#
4 * This package contains a period of service API for France.
5 * @rep:scope public
6 * @rep:product per
7 * @rep:displayname Periods of Service for France
8 */
9 --
10 -- ----------------------------------------------------------------------------
11 -- |--------------------------< update_fr_pds_details >-----------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 -- {Start Of Comments}
15 /*#
16 * This API updates the periods of service details for an employee for France.
17 *
18 * This API is an alternative API to the generic update_pds_details, see
19 * generic update_pds_details for further details.
20 *
21 * <p><b>Licensing</b><br>
22 * This API is licensed for use with Human Resources.
23 *
24 * <p><b>Prerequisites</b><br>
25 * The employee must exist in the database.
26 *
27 * <p><b>Post Success</b><br>
28 * The periods of service API is successfully updated in the database.
29 *
30 * <p><b>Post Failure</b><br>
31 * The API will not update the period of service record and raises an error.
32 * @param p_validate If true, then validation alone will be performed and the
33 * database will remain unchanged. If false and all validation checks pass,
34 * then the database will be modified.
35 * @param p_effective_date Determines when the DateTrack operation comes into
36 * force.
37 * @param p_period_of_service_id Period of service that is being terminated.
38 * @param p_termination_accepted_person Person who accepted this termination.
39 * @param p_accepted_termination_date Date when the termination of employment
40 * was accepted
41 * @param p_object_version_number Pass in the current version number of the
42 * period of service to be updated. When the API completes if p_validate is
43 * false, will be set to the new version number of the updated period of
44 * service. If p_validate is true will be set to the same value which was
45 * passed in.
46 * @param p_comments Comment text.
47 * @param p_leaving_reason Termination Reason. Valid values are defined by the
48 * LEAV_REAS lookup type.
49 * @param p_notified_termination_date Date when the termination was notified.
50 * @param p_projected_termination_date Projected termination date.
51 * @param p_attribute_category This context value determines which flexfield
52 * structure to use with the descriptive flexfield segments.
53 * @param p_attribute1 Descriptive flexfield segment.
54 * @param p_attribute2 Descriptive flexfield segment.
55 * @param p_attribute3 Descriptive flexfield segment.
56 * @param p_attribute4 Descriptive flexfield segment.
57 * @param p_attribute5 Descriptive flexfield segment.
58 * @param p_attribute6 Descriptive flexfield segment.
59 * @param p_attribute7 Descriptive flexfield segment.
60 * @param p_attribute8 Descriptive flexfield segment.
61 * @param p_attribute9 Descriptive flexfield segment.
62 * @param p_attribute10 Descriptive flexfield segment.
63 * @param p_attribute11 Descriptive flexfield segment.
64 * @param p_attribute12 Descriptive flexfield segment.
65 * @param p_attribute13 Descriptive flexfield segment.
66 * @param p_attribute14 Descriptive flexfield segment.
67 * @param p_attribute15 Descriptive flexfield segment.
68 * @param p_attribute16 Descriptive flexfield segment.
69 * @param p_attribute17 Descriptive flexfield segment.
70 * @param p_attribute18 Descriptive flexfield segment.
71 * @param p_attribute19 Descriptive flexfield segment.
72 * @param p_attribute20 Descriptive flexfield segment.
73 * @param p_starting_reason Starting reason. Valid values exist in the
74 * 'FR_STARTING_REASON' lookup type.
75 * @param p_ending_reason Ending reason. Valid values exist in the
76 * 'FR_ENDING_REASON' lookup type.
77 * @param p_qualification_level Qualification level. Valid values exist in the
78 * 'FR_LEVEL_OF_WORKER' lookup type.
79 * @param p_type_work Type of work. Valid values exist in the
80 * 'FR_TYPE_OF_WORKER' lookup type.
81 * @param p_employee_status Employee status. Valid values exist in the
82 * 'FR_EMPLOYEE_STATUS' lookup type.
83 * @param p_affiliated_alsace_moselle Affiliated Alsace Moselle DSS (Y/N)
84 * @param p_relationship_md Relationship with managing director. Valid values
85 * exist in the 'CONTACT' lookup type.
86 * @param p_final_payment_schedule Final payment schedule. Valid values exist
87 * in the 'FR_FINAL_PAYMENT_TYPES' lookup type.
88 * @param p_social_plan Covered By Social Plan (Y/N)
89 * @rep:displayname Update Period of Service for France
90 * @rep:category BUSINESS_ENTITY PER_EMPLOYEE
91 * @rep:scope public
92 * @rep:lifecycle active
93 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
94 */
95 --
96 -- {End Of Comments}
97 --
98 procedure update_fr_pds_details
99 (p_validate in boolean default false
100 ,p_effective_date in date
101 ,p_period_of_service_id in number
102 ,p_termination_accepted_person in number default hr_api.g_number
103 ,p_accepted_termination_date in date default hr_api.g_date
104 ,p_object_version_number in out nocopy number
105 ,p_comments in varchar2 default hr_api.g_varchar2
106 ,p_leaving_reason in varchar2 default hr_api.g_varchar2
107 ,p_notified_termination_date in date default hr_api.g_date
108 ,p_projected_termination_date in date default hr_api.g_date
109 ,p_attribute_category in varchar2 default hr_api.g_varchar2
110 ,p_attribute1 in varchar2 default hr_api.g_varchar2
111 ,p_attribute2 in varchar2 default hr_api.g_varchar2
112 ,p_attribute3 in varchar2 default hr_api.g_varchar2
113 ,p_attribute4 in varchar2 default hr_api.g_varchar2
114 ,p_attribute5 in varchar2 default hr_api.g_varchar2
115 ,p_attribute6 in varchar2 default hr_api.g_varchar2
116 ,p_attribute7 in varchar2 default hr_api.g_varchar2
117 ,p_attribute8 in varchar2 default hr_api.g_varchar2
118 ,p_attribute9 in varchar2 default hr_api.g_varchar2
119 ,p_attribute10 in varchar2 default hr_api.g_varchar2
120 ,p_attribute11 in varchar2 default hr_api.g_varchar2
121 ,p_attribute12 in varchar2 default hr_api.g_varchar2
122 ,p_attribute13 in varchar2 default hr_api.g_varchar2
123 ,p_attribute14 in varchar2 default hr_api.g_varchar2
124 ,p_attribute15 in varchar2 default hr_api.g_varchar2
125 ,p_attribute16 in varchar2 default hr_api.g_varchar2
126 ,p_attribute17 in varchar2 default hr_api.g_varchar2
127 ,p_attribute18 in varchar2 default hr_api.g_varchar2
128 ,p_attribute19 in varchar2 default hr_api.g_varchar2
129 ,p_attribute20 in varchar2 default hr_api.g_varchar2
130 ,p_starting_reason in varchar2 default hr_api.g_varchar2
131 ,p_ending_reason in varchar2 default hr_api.g_varchar2
132 ,p_qualification_level in varchar2 default hr_api.g_varchar2
133 ,p_type_work in varchar2 default hr_api.g_varchar2
134 ,p_employee_status in varchar2 default hr_api.g_varchar2
135 ,p_affiliated_alsace_moselle in varchar2 default hr_api.g_varchar2
136 ,p_relationship_MD in varchar2 default hr_api.g_varchar2
137 ,p_final_payment_schedule in varchar2 default hr_api.g_varchar2
138 ,p_social_plan in varchar2 default hr_api.g_varchar2
139 );
140 --
141 end hr_fr_periods_of_service_api;