DBA Data[Home] [Help]

PACKAGE: APPS.PQH_FR_EMP_STAT_SIT_UTILITY

Source


1 PACKAGE PQH_FR_EMP_STAT_SIT_UTILITY AS
2 /* $Header: pqfresut.pkh 120.0 2005/05/29 01:53:09 appldev noship $ */
3   --
4   -- ----------------------< create_emp_stat_situation >------------------------
5   -- Description:
6   --  This procedure is the self-service wrapper procedure to the following
7   --  API: pqh_fr_emp_stat_situation_api.create_emp_stat_situation
8   -- ---------------------------------------------------------------------------
9   PROCEDURE create_emp_stat_situation
10   (p_validate                     IN     NUMBER    DEFAULT HR_API.g_false_num
11   ,p_effective_date               IN     DATE
12   ,p_statutory_situation_id       IN     NUMBER
13   ,p_person_id                    IN     NUMBER
14   ,p_provisional_start_date       IN     DATE
15   ,p_provisional_end_date         IN     DATE
16   ,p_actual_start_date            IN     DATE      DEFAULT NULL
17   ,p_actual_end_date              IN     DATE      DEFAULT NULL
18   ,p_approval_flag                IN     VARCHAR2  DEFAULT NULL
19   ,p_comments                     IN     VARCHAR2  DEFAULT NULL
20   ,p_contact_person_id            IN     NUMBER    DEFAULT NULL
21   ,p_contact_relationship         IN     VARCHAR2  DEFAULT NULL
22   ,p_external_organization_id     IN     NUMBER    DEFAULT NULL
23   ,p_renewal_flag                 IN     VARCHAR2  DEFAULT NULL
24   ,p_renew_stat_situation_id      IN     NUMBER    DEFAULT NULL
25   ,p_seconded_career_id           IN     NUMBER    DEFAULT NULL
26   ,p_attribute_category           IN     VARCHAR2  DEFAULT NULL
27   ,p_attribute1                   IN     VARCHAR2  DEFAULT NULL
28   ,p_attribute2                   IN     VARCHAR2  DEFAULT NULL
29   ,p_attribute3                   IN     VARCHAR2  DEFAULT NULL
30   ,p_attribute4                   IN     VARCHAR2  DEFAULT NULL
31   ,p_attribute5                   IN     VARCHAR2  DEFAULT NULL
32   ,p_attribute6                   IN     VARCHAR2  DEFAULT NULL
33   ,p_attribute7                   IN     VARCHAR2  DEFAULT NULL
34   ,p_attribute8                   IN     VARCHAR2  DEFAULT NULL
35   ,p_attribute9                   IN     VARCHAR2  DEFAULT NULL
36   ,p_attribute10                  IN     VARCHAR2  DEFAULT NULL
37   ,p_attribute11                  IN     VARCHAR2  DEFAULT NULL
38   ,p_attribute12                  IN     VARCHAR2  DEFAULT NULL
39   ,p_attribute13                  IN     VARCHAR2  DEFAULT NULL
40   ,p_attribute14                  IN     VARCHAR2  DEFAULT NULL
41   ,p_attribute15                  IN     VARCHAR2  DEFAULT NULL
42   ,p_attribute16                  IN     VARCHAR2  DEFAULT NULL
43   ,p_attribute17                  IN     VARCHAR2  DEFAULT NULL
44   ,p_attribute18                  IN     VARCHAR2  DEFAULT NULL
45   ,p_attribute19                  IN     VARCHAR2  DEFAULT NULL
46   ,p_attribute20                  IN     VARCHAR2  DEFAULT NULL
47   ,p_attribute21                  IN     VARCHAR2  DEFAULT NULL
48   ,p_attribute22                  IN     VARCHAR2  DEFAULT NULL
49   ,p_attribute23                  IN     VARCHAR2  DEFAULT NULL
50   ,p_attribute24                  IN     VARCHAR2  DEFAULT NULL
51   ,p_attribute25                  IN     VARCHAR2  DEFAULT NULL
52   ,p_attribute26                  IN     VARCHAR2  DEFAULT NULL
53   ,p_attribute27                  IN     VARCHAR2  DEFAULT NULL
54   ,p_attribute28                  IN     VARCHAR2  DEFAULT NULL
55   ,p_attribute29                  IN     VARCHAR2  DEFAULT NULL
56   ,p_attribute30                  IN     VARCHAR2  DEFAULT NULL
57   ,p_emp_stat_situation_id    OUT nocopy NUMBER
58   ,p_object_version_number    OUT nocopy NUMBER
59   ,p_return_status            OUT nocopy VARCHAR2
60   );
61   --
62   -- ----------------------< update_emp_stat_situation >------------------------
63   -- Description:
64   --  This procedure is the self-service wrapper procedure to the following
65   --  API: pqh_fr_emp_stat_situation_api.update_emp_stat_situation
66   -- ---------------------------------------------------------------------------
67   PROCEDURE update_emp_stat_situation
68   (p_validate                     IN     NUMBER    DEFAULT HR_API.g_false_num
69   ,p_effective_date               IN     DATE
70   ,p_emp_stat_situation_id        IN     NUMBER
71   ,p_statutory_situation_id       IN     NUMBER    DEFAULT HR_API.g_number
72   ,p_person_id                    IN     NUMBER    DEFAULT HR_API.g_number
73   ,p_provisional_start_date       IN     DATE      DEFAULT HR_API.g_date
74   ,p_provisional_end_date         IN     DATE      DEFAULT HR_API.g_date
75   ,p_actual_start_date            IN     DATE      DEFAULT HR_API.g_date
76   ,p_actual_end_date              IN     DATE      DEFAULT HR_API.g_date
77   ,p_approval_flag                IN     VARCHAR2  DEFAULT HR_API.g_varchar2
78   ,p_comments                     IN     VARCHAR2  DEFAULT HR_API.g_varchar2
79   ,p_contact_person_id            IN     NUMBER    DEFAULT HR_API.g_number
80   ,p_contact_relationship         IN     VARCHAR2  DEFAULT HR_API.g_varchar2
81   ,p_external_organization_id     IN     NUMBER    DEFAULT HR_API.g_number
82   ,p_renewal_flag                 IN     VARCHAR2  DEFAULT HR_API.g_varchar2
83   ,p_renew_stat_situation_id      IN     NUMBER    DEFAULT HR_API.g_number
84   ,p_seconded_career_id           IN     NUMBER    DEFAULT HR_API.g_number
85   ,p_attribute_category           IN     VARCHAR2  DEFAULT HR_API.g_varchar2
86   ,p_attribute1                   IN     VARCHAR2  DEFAULT HR_API.g_varchar2
87   ,p_attribute2                   IN     VARCHAR2  DEFAULT HR_API.g_varchar2
88   ,p_attribute3                   IN     VARCHAR2  DEFAULT HR_API.g_varchar2
89   ,p_attribute4                   IN     VARCHAR2  DEFAULT HR_API.g_varchar2
90   ,p_attribute5                   IN     VARCHAR2  DEFAULT HR_API.g_varchar2
91   ,p_attribute6                   IN     VARCHAR2  DEFAULT HR_API.g_varchar2
92   ,p_attribute7                   IN     VARCHAR2  DEFAULT HR_API.g_varchar2
93   ,p_attribute8                   IN     VARCHAR2  DEFAULT HR_API.g_varchar2
94   ,p_attribute9                   IN     VARCHAR2  DEFAULT HR_API.g_varchar2
95   ,p_attribute10                  IN     VARCHAR2  DEFAULT HR_API.g_varchar2
96   ,p_attribute11                  IN     VARCHAR2  DEFAULT HR_API.g_varchar2
97   ,p_attribute12                  IN     VARCHAR2  DEFAULT HR_API.g_varchar2
98   ,p_attribute13                  IN     VARCHAR2  DEFAULT HR_API.g_varchar2
99   ,p_attribute14                  IN     VARCHAR2  DEFAULT HR_API.g_varchar2
100   ,p_attribute15                  IN     VARCHAR2  DEFAULT HR_API.g_varchar2
101   ,p_attribute16                  IN     VARCHAR2  DEFAULT HR_API.g_varchar2
102   ,p_attribute17                  IN     VARCHAR2  DEFAULT HR_API.g_varchar2
103   ,p_attribute18                  IN     VARCHAR2  DEFAULT HR_API.g_varchar2
104   ,p_attribute19                  IN     VARCHAR2  DEFAULT HR_API.g_varchar2
105   ,p_attribute20                  IN     VARCHAR2  DEFAULT HR_API.g_varchar2
106   ,p_attribute21                  IN     VARCHAR2  DEFAULT HR_API.g_varchar2
107   ,p_attribute22                  IN     VARCHAR2  DEFAULT HR_API.g_varchar2
108   ,p_attribute23                  IN     VARCHAR2  DEFAULT HR_API.g_varchar2
109   ,p_attribute24                  IN     VARCHAR2  DEFAULT HR_API.g_varchar2
110   ,p_attribute25                  IN     VARCHAR2  DEFAULT HR_API.g_varchar2
111   ,p_attribute26                  IN     VARCHAR2  DEFAULT HR_API.g_varchar2
112   ,p_attribute27                  IN     VARCHAR2  DEFAULT HR_API.g_varchar2
113   ,p_attribute28                  IN     VARCHAR2  DEFAULT HR_API.g_varchar2
114   ,p_attribute29                  IN     VARCHAR2  DEFAULT HR_API.g_varchar2
115   ,p_attribute30                  IN     VARCHAR2  DEFAULT HR_API.g_varchar2
116   ,p_object_version_number IN OUT nocopy NUMBER
117   ,p_return_status            OUT nocopy VARCHAR2
118   );
119   --
120   -- --------------------< reinstate_emp_stat_situation >-----------------------
121   -- Description:
122   --  This procedure is the self-service wrapper procedure to the following
123   --  API: pqh_fr_emp_stat_situation_api.reinstate_emp_stat_situation
124   -- ---------------------------------------------------------------------------
125   PROCEDURE reinstate_emp_stat_situation
126   (p_validate                      IN     NUMBER   DEFAULT HR_API.g_false_num
127   ,p_person_id                     IN     NUMBER
128   ,p_emp_stat_situation_id         IN     NUMBER
129   ,p_reinstate_date                IN     DATE
130   ,p_comments                      IN     VARCHAR2
131   ,p_new_emp_stat_situation_id OUT nocopy NUMBER
132   ,p_return_status             OUT nocopy VARCHAR2
133   );
134   --
135   -- ----------------------< renew_emp_stat_situation >-------------------------
136   -- Description:
137   --  This procedure is the self-service wrapper procedure to the following
138   --  API: pqh_fr_emp_stat_situation_api.renew_emp_stat_situation
139   -- ---------------------------------------------------------------------------
140   PROCEDURE renew_emp_stat_situation
141   (p_validate                IN            NUMBER  DEFAULT HR_API.g_false_num
142   ,p_emp_stat_situation_id   IN OUT nocopy NUMBER
143   ,p_renew_stat_situation_id IN            NUMBER
144   ,p_renewal_duration        IN            NUMBER
145   ,p_duration_units          IN            VARCHAR2
146   ,p_approval_flag           IN            VARCHAR2
150   );
147   ,p_comments                IN            VARCHAR2
148   ,p_object_version_number   IN OUT nocopy NUMBER
149   ,p_return_status              OUT nocopy VARCHAR2
151   --
152   -- ---------------------< delete_emp_stat_situation >-------------------------
153   -- Description:
154   --  This procedure is the self-service wrapper procedure to the following
155   --  API: pqh_fr_emp_stat_situation_api.delete_emp_stat_situation
156   -- ---------------------------------------------------------------------------
157   PROCEDURE delete_emp_stat_situation
158   (p_validate              IN     NUMBER DEFAULT HR_API.g_false_num
159   ,p_emp_stat_situation_id IN     NUMBER
160   ,p_object_version_number IN     NUMBER
161   ,p_return_status            OUT nocopy VARCHAR2
162   );
163   --
164   --
165   -- ----------------------------< updt_assign >--------------------------------
166   -- Description:
167   --  This procedure is invoked to call main Update Assignments procedure
168   -- ---------------------------------------------------------------------------
169   PROCEDURE updt_assign
170   (p_person_id              IN NUMBER
171   ,p_statutory_situation_id IN NUMBER
172   ,p_iand_stat_sit_id       IN NUMBER DEFAULT NULL
173   ,p_start_date             IN DATE
174   ,p_end_date               IN DATE
175   );
176   --
177   --
178   -- --------------------------< is_person_active >-----------------------------
179   -- Description:
180   --  This function returns whether person is in active situation or not.
181   -- ---------------------------------------------------------------------------
182   FUNCTION is_person_active
183   (p_person_id      IN NUMBER,
184    p_effective_date IN DATE) RETURN VARCHAR2;
185   --
186 END PQH_FR_EMP_STAT_SIT_UTILITY;