DBA Data[Home] [Help]

PACKAGE: APPS.IRC_AGENCY_VACANCIES_SWI

Source


1 Package irc_agency_vacancies_swi As
2 /* $Header: iriavswi.pkh 120.1.12010000.1 2008/07/28 12:41:49 appldev ship $ */
3 -- ----------------------------------------------------------------------------
4 -- |-------------------------< create_agency_vacancy >------------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start of comments}
7 --
8 -- Description:
9 --  This procedure is the self-service wrapper procedure to the following
10 --  API: irc_agency_vacancies_api.create_agency_vacancy
11 --
12 -- Pre-requisites
13 --  All 'IN' parameters to this procedure have been appropriately derived.
14 --
15 -- Post Success:
16 --  p_return_status will return value indicating success.
17 --
18 -- Post Failure:
19 --  p_return_status will return value indication failure.
20 --
21 -- Access Status:
22 --  Internal Development use only.
23 --
24 -- {End of comments}
25 -- ----------------------------------------------------------------------------
26 PROCEDURE create_agency_vacancy
27   (p_validate                     in     number    default hr_api.g_false_num
28   ,p_agency_id                    in     number
29   ,p_vacancy_id                   in     number
30   ,p_start_date                   in     date      default null
31   ,p_end_date                     in     date      default null
32   ,p_max_allowed_applicants       in     number    default null
33   ,p_manage_applicants_allowed    in     varchar2  default null
34   ,p_attribute_category           in     varchar2  default null
35   ,p_attribute1                   in     varchar2  default null
36   ,p_attribute2                   in     varchar2  default null
37   ,p_attribute3                   in     varchar2  default null
38   ,p_attribute4                   in     varchar2  default null
39   ,p_attribute5                   in     varchar2  default null
40   ,p_attribute6                   in     varchar2  default null
41   ,p_attribute7                   in     varchar2  default null
42   ,p_attribute8                   in     varchar2  default null
43   ,p_attribute9                   in     varchar2  default null
44   ,p_attribute10                  in     varchar2  default null
45   ,p_attribute11                  in     varchar2  default null
46   ,p_attribute12                  in     varchar2  default null
47   ,p_attribute13                  in     varchar2  default null
48   ,p_attribute14                  in     varchar2  default null
49   ,p_attribute15                  in     varchar2  default null
50   ,p_attribute16                  in     varchar2  default null
51   ,p_attribute17                  in     varchar2  default null
52   ,p_attribute18                  in     varchar2  default null
53   ,p_attribute19                  in     varchar2  default null
54   ,p_attribute20                  in     varchar2  default null
55   ,p_attribute21                  in     varchar2  default null
56   ,p_attribute22                  in     varchar2  default null
57   ,p_attribute23                  in     varchar2  default null
58   ,p_attribute24                  in     varchar2  default null
59   ,p_attribute25                  in     varchar2  default null
60   ,p_attribute26                  in     varchar2  default null
61   ,p_attribute27                  in     varchar2  default null
62   ,p_attribute28                  in     varchar2  default null
63   ,p_attribute29                  in     varchar2  default null
64   ,p_attribute30                  in     varchar2  default null
65   ,p_object_version_number           out nocopy number
66   ,p_agency_vacancy_id            in     number
67   ,p_return_status                   out nocopy varchar2
68   );
69 -- ----------------------------------------------------------------------------
70 -- |-------------------------< update_agency_vacancy >------------------------|
71 -- ----------------------------------------------------------------------------
72 -- {Start of comments}
73 --
74 -- Description:
75 --  This procedure is the self-service wrapper procedure to the following
76 --  API: irc_agency_vacancies_api.update_agency_vacancy
77 --
78 -- Pre-requisites
79 --  All 'IN' parameters to this procedure have been appropriately derived.
80 --
81 -- Post Success:
82 --  p_return_status will return value indicating success.
83 --
84 -- Post Failure:
85 --  p_return_status will return value indication failure.
86 --
87 -- Access Status:
88 --  Internal Development use only.
89 --
90 -- {End of comments}
91 -- ----------------------------------------------------------------------------
92 PROCEDURE update_agency_vacancy
93   (p_validate                     in     number    default hr_api.g_false_num
94   ,p_agency_vacancy_id            in     number
95   ,p_agency_id                    in     number
96   ,p_vacancy_id                   in     number
97   ,p_start_date                   in     date
98   ,p_end_date                     in     date
99   ,p_max_allowed_applicants       in     number    default hr_api.g_number
100   ,p_manage_applicants_allowed    in     varchar2  default hr_api.g_varchar2
101   ,p_attribute_category           in     varchar2  default hr_api.g_varchar2
102   ,p_attribute1                   in     varchar2  default hr_api.g_varchar2
103   ,p_attribute2                   in     varchar2  default hr_api.g_varchar2
104   ,p_attribute3                   in     varchar2  default hr_api.g_varchar2
105   ,p_attribute4                   in     varchar2  default hr_api.g_varchar2
106   ,p_attribute5                   in     varchar2  default hr_api.g_varchar2
107   ,p_attribute6                   in     varchar2  default hr_api.g_varchar2
108   ,p_attribute7                   in     varchar2  default hr_api.g_varchar2
109   ,p_attribute8                   in     varchar2  default hr_api.g_varchar2
110   ,p_attribute9                   in     varchar2  default hr_api.g_varchar2
111   ,p_attribute10                  in     varchar2  default hr_api.g_varchar2
112   ,p_attribute11                  in     varchar2  default hr_api.g_varchar2
113   ,p_attribute12                  in     varchar2  default hr_api.g_varchar2
114   ,p_attribute13                  in     varchar2  default hr_api.g_varchar2
115   ,p_attribute14                  in     varchar2  default hr_api.g_varchar2
116   ,p_attribute15                  in     varchar2  default hr_api.g_varchar2
117   ,p_attribute16                  in     varchar2  default hr_api.g_varchar2
118   ,p_attribute17                  in     varchar2  default hr_api.g_varchar2
119   ,p_attribute18                  in     varchar2  default hr_api.g_varchar2
120   ,p_attribute19                  in     varchar2  default hr_api.g_varchar2
121   ,p_attribute20                  in     varchar2  default hr_api.g_varchar2
122   ,p_attribute21                  in     varchar2  default hr_api.g_varchar2
123   ,p_attribute22                  in     varchar2  default hr_api.g_varchar2
124   ,p_attribute23                  in     varchar2  default hr_api.g_varchar2
125   ,p_attribute24                  in     varchar2  default hr_api.g_varchar2
126   ,p_attribute25                  in     varchar2  default hr_api.g_varchar2
127   ,p_attribute26                  in     varchar2  default hr_api.g_varchar2
128   ,p_attribute27                  in     varchar2  default hr_api.g_varchar2
129   ,p_attribute28                  in     varchar2  default hr_api.g_varchar2
130   ,p_attribute29                  in     varchar2  default hr_api.g_varchar2
131   ,p_attribute30                  in     varchar2  default hr_api.g_varchar2
132   ,p_object_version_number        in out nocopy number
133   ,p_return_status                   out nocopy varchar2
134   );
135 -- ----------------------------------------------------------------------------
136 -- |-------------------------< delete_agency_vacancy >------------------------|
137 -- ----------------------------------------------------------------------------
138 -- {Start of comments}
139 --
140 -- Description:
141 --  This procedure is the self-service wrapper procedure to the following
142 --  API: irc_agency_vacancies_api.delete_agency_vacancy
143 --
144 -- Pre-requisites
145 --  All 'IN' parameters to this procedure have been appropriately derived.
146 --
147 -- Post Success:
148 --  p_return_status will return value indicating success.
149 --
150 -- Post Failure:
151 --  p_return_status will return value indication failure.
152 --
153 -- Access Status:
154 --  Internal Development use only.
155 --
156 -- {End of comments}
157 -- ----------------------------------------------------------------------------
158 PROCEDURE delete_agency_vacancy
159   (p_validate                     in     number    default hr_api.g_false_num
160   ,p_agency_vacancy_id            in     number
161   ,p_object_version_number        in     number
162   ,p_return_status                   out nocopy varchar2
163   );
164 --
165 procedure process_api
166 (
167   p_document            in         CLOB
168  ,p_return_status       out nocopy VARCHAR2
169  ,p_validate            in         number    default hr_api.g_false_num
170  ,p_effective_date      in         date      default null
171 );
172 --
173  end irc_agency_vacancies_swi;