1 package hr_sa_periods_of_service_api AUTHID CURRENT_USER as
2 /* $Header: pepdssai.pkh 120.1 2005/10/02 02:20:11 aroussel $ */
3 /*#
4 * This package contains period of service APIs for Saudi Arabia.
5 * @rep:scope public
6 * @rep:product per
7 * @rep:displayname Period of Service for Saudi Arabia
8 */
9 --
10 -- ----------------------------------------------------------------------------
11 -- |--------------------------< update_sa_pds_details >-----------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 -- {Start Of Comments}
15 /*#
16 * This API updates a period of service for an employee in a Saudi Arabia
17 * business group.
18 *
19 * The API calls the generic API update_pds_details, with parameters set as
20 * appropriate for the Saudi person. As this API is effectively an alternative
21 * to the API update_pds_details, see that API for further explanation.
22 *
23 * <p><b>Licensing</b><br>
24 * This API is licensed for use with Human Resources.
25 *
26 * <p><b>Prerequisites</b><br>
27 * See API update_pds_details
28 *
29 * <p><b>Post Success</b><br>
30 * The period of service record is successfully updated in the database.
31 *
32 * <p><b>Post Failure</b><br>
33 * The API does not update the period of service record and raises an error.
34 * @param p_validate If true, then validation alone will be performed and the
35 * database will remain unchanged. If false and all validation checks pass,
36 * then the database will be modified.
37 * @param p_effective_date Determines when the DateTrack operation comes into
38 * force.
39 * @param p_period_of_service_id Period of service that is being terminated.
40 * @param p_termination_accepted_person Person who accepted this termination.
41 * @param p_accepted_termination_date Date when the termination of employment
42 * was accepted
43 * @param p_object_version_number Pass in the current version number of the
44 * period of service to be updated. When the API completes if p_validate is
45 * false, will be set to the new version number of the updated period of
46 * service. If p_validate is true will be set to the same value which was
47 * passed in.
48 * @param p_comments Comment text.
49 * @param p_leaving_reason Termination Reason. Valid values are defined by the
50 * LEAV_REAS lookup type.
51 * @param p_notified_termination_date Date when the termination was notified.
52 * @param p_projected_termination_date Projected termination date.
53 * @param p_attribute_category This context value determines which flexfield
54 * structure to use with the descriptive flexfield segments.
55 * @param p_attribute1 Descriptive flexfield segment.
56 * @param p_attribute2 Descriptive flexfield segment.
57 * @param p_attribute3 Descriptive flexfield segment.
58 * @param p_attribute4 Descriptive flexfield segment.
59 * @param p_attribute5 Descriptive flexfield segment.
60 * @param p_attribute6 Descriptive flexfield segment.
61 * @param p_attribute7 Descriptive flexfield segment.
62 * @param p_attribute8 Descriptive flexfield segment.
63 * @param p_attribute9 Descriptive flexfield segment.
64 * @param p_attribute10 Descriptive flexfield segment.
65 * @param p_attribute11 Descriptive flexfield segment.
66 * @param p_attribute12 Descriptive flexfield segment.
67 * @param p_attribute13 Descriptive flexfield segment.
68 * @param p_attribute14 Descriptive flexfield segment.
69 * @param p_attribute15 Descriptive flexfield segment.
70 * @param p_attribute16 Descriptive flexfield segment.
71 * @param p_attribute17 Descriptive flexfield segment.
72 * @param p_attribute18 Descriptive flexfield segment.
73 * @param p_attribute19 Descriptive flexfield segment.
74 * @param p_attribute20 Descriptive flexfield segment.
75 * @param p_hijrah_termination_date Termination date according to the Hijrah
76 * calendar.
77 * @rep:displayname Update Period of Service for Saudi Arabia
78 * @rep:category BUSINESS_ENTITY PER_EMPLOYEE
79 * @rep:scope public
80 * @rep:lifecycle active
81 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
82 */
83 --
84 -- {End Of Comments}
85 --
86 procedure update_sa_pds_details
87 (p_validate in boolean default false
88 ,p_effective_date in date
89 ,p_period_of_service_id in number
90 ,p_termination_accepted_person in number default hr_api.g_number
91 ,p_accepted_termination_date in date default hr_api.g_date
92 ,p_object_version_number in out nocopy number
93 ,p_comments in varchar2 default hr_api.g_varchar2
94 ,p_leaving_reason in varchar2 default hr_api.g_varchar2
95 ,p_notified_termination_date in date default hr_api.g_date
96 ,p_projected_termination_date in date default hr_api.g_date
97 ,p_attribute_category in varchar2 default hr_api.g_varchar2
98 ,p_attribute1 in varchar2 default hr_api.g_varchar2
99 ,p_attribute2 in varchar2 default hr_api.g_varchar2
100 ,p_attribute3 in varchar2 default hr_api.g_varchar2
101 ,p_attribute4 in varchar2 default hr_api.g_varchar2
102 ,p_attribute5 in varchar2 default hr_api.g_varchar2
103 ,p_attribute6 in varchar2 default hr_api.g_varchar2
104 ,p_attribute7 in varchar2 default hr_api.g_varchar2
105 ,p_attribute8 in varchar2 default hr_api.g_varchar2
106 ,p_attribute9 in varchar2 default hr_api.g_varchar2
107 ,p_attribute10 in varchar2 default hr_api.g_varchar2
108 ,p_attribute11 in varchar2 default hr_api.g_varchar2
109 ,p_attribute12 in varchar2 default hr_api.g_varchar2
110 ,p_attribute13 in varchar2 default hr_api.g_varchar2
111 ,p_attribute14 in varchar2 default hr_api.g_varchar2
112 ,p_attribute15 in varchar2 default hr_api.g_varchar2
113 ,p_attribute16 in varchar2 default hr_api.g_varchar2
114 ,p_attribute17 in varchar2 default hr_api.g_varchar2
115 ,p_attribute18 in varchar2 default hr_api.g_varchar2
116 ,p_attribute19 in varchar2 default hr_api.g_varchar2
117 ,p_attribute20 in varchar2 default hr_api.g_varchar2
118 ,p_hijrah_termination_date in varchar2 default hr_api.g_varchar2
119 );
120 --
121 end hr_sa_periods_of_service_api;
[Home] [Help]