DBA Data[Home] [Help]

PACKAGE: APPS.IRC_PENDING_DATA_SWI

Source


1 Package irc_pending_data_swi As
2 /* $Header: iripdswi.pkh 120.0 2005/07/26 15:10:04 mbocutt noship $ */
3 -- ----------------------------------------------------------------------------
4 -- |--------------------------< create_pending_data >-------------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start of comments}
7 --
8 -- Description:
9 --  This procedure is the self-service wrapper procedure to the following
10 --  API: irc_pending_data_api.create_pending_data
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_pending_data
27   (p_validate                       in     number   default hr_api.g_false_num
28   ,p_email_address                  in     varchar2
29   ,p_last_name                      in     varchar2
30   ,p_vacancy_id                     in     number   default null
31   ,p_first_name                     in     varchar2 default null
32   ,p_user_password                  in     varchar2 default null
33   ,p_resume_file_name               in     varchar2 default null
34   ,p_resume_description             in     varchar2 default null
35   ,p_resume_mime_type               in     varchar2 default null
36   ,p_source_type                    in     varchar2 default null
37   ,p_job_post_source_name           in     varchar2 default null
38   ,p_posting_content_id             in     number   default null
39   ,p_person_id                      in     number   default null
40   ,p_processed                      in     varchar2 default null
41   ,p_sex                            in     varchar2 default null
42   ,p_date_of_birth                  in     date     default null
43   ,p_per_information_category       in     varchar2 default null
44   ,p_per_information1               in     varchar2 default null
45   ,p_per_information2               in     varchar2 default null
46   ,p_per_information3               in     varchar2 default null
47   ,p_per_information4               in     varchar2 default null
48   ,p_per_information5               in     varchar2 default null
49   ,p_per_information6               in     varchar2 default null
50   ,p_per_information7               in     varchar2 default null
51   ,p_per_information8               in     varchar2 default null
52   ,p_per_information9               in     varchar2 default null
53   ,p_per_information10              in     varchar2 default null
54   ,p_per_information11              in     varchar2 default null
55   ,p_per_information12              in     varchar2 default null
56   ,p_per_information13              in     varchar2 default null
57   ,p_per_information14              in     varchar2 default null
58   ,p_per_information15              in     varchar2 default null
59   ,p_per_information16              in     varchar2 default null
60   ,p_per_information17              in     varchar2 default null
61   ,p_per_information18              in     varchar2 default null
62   ,p_per_information19              in     varchar2 default null
63   ,p_per_information20              in     varchar2 default null
64   ,p_per_information21              in     varchar2 default null
65   ,p_per_information22              in     varchar2 default null
66   ,p_per_information23              in     varchar2 default null
67   ,p_per_information24              in     varchar2 default null
68   ,p_per_information25              in     varchar2 default null
69   ,p_per_information26              in     varchar2 default null
70   ,p_per_information27              in     varchar2 default null
71   ,p_per_information28              in     varchar2 default null
72   ,p_per_information29              in     varchar2 default null
73   ,p_per_information30              in     varchar2 default null
74   ,p_error_message                  in     varchar2 default null
75   ,p_creation_date                  in     date
76   ,p_last_update_date               in     date
77   ,p_pending_data_id                in     number
78   ,p_allow_access                   in     varchar2 default null
79   ,p_user_guid                      in     raw      default null
80   ,p_visitor_resp_key               in     varchar2 default null
81   ,p_visitor_resp_appl_id           in     number   default null
82   ,p_security_group_key             in     varchar2 default null
83   ,p_return_status                   out nocopy varchar2
84   );
85 -- ----------------------------------------------------------------------------
86 -- |--------------------------< update_pending_data >-------------------------|
87 -- ----------------------------------------------------------------------------
88 -- {Start of comments}
89 --
90 -- Description:
91 --  This procedure is the self-service wrapper procedure to the following
92 --  API: irc_pending_data_api.update_pending_data
93 --
94 -- Pre-requisites
95 --  All 'IN' parameters to this procedure have been appropriately derived.
96 --
97 -- Post Success:
98 --  p_return_status will return value indicating success.
99 --
100 -- Post Failure:
101 --  p_return_status will return value indication failure.
102 --
103 -- Access Status:
104 --  Internal Development use only.
105 --
106 -- {End of comments}
107 -- ----------------------------------------------------------------------------
108 PROCEDURE update_pending_data
109   (p_validate                     in     number    default hr_api.g_false_num
110   ,p_pending_data_id              in     number
111   ,p_email_address                in     varchar2  default hr_api.g_varchar2
112   ,p_last_name                    in     varchar2  default hr_api.g_varchar2
113   ,p_vacancy_id                   in     number    default hr_api.g_number
114   ,p_first_name                   in     varchar2  default hr_api.g_varchar2
115   ,p_user_password                in     varchar2  default hr_api.g_varchar2
116   ,p_resume_file_name             in     varchar2  default hr_api.g_varchar2
117   ,p_resume_description           in     varchar2  default hr_api.g_varchar2
118   ,p_resume_mime_type             in     varchar2  default hr_api.g_varchar2
119   ,p_source_type                  in     varchar2  default hr_api.g_varchar2
120   ,p_job_post_source_name         in     varchar2  default hr_api.g_varchar2
121   ,p_posting_content_id           in     number    default hr_api.g_number
122   ,p_person_id                    in     number    default hr_api.g_number
123   ,p_processed                    in     varchar2  default hr_api.g_varchar2
124   ,p_sex                          in     varchar2  default hr_api.g_varchar2
125   ,p_date_of_birth                in     date      default hr_api.g_date
126   ,p_per_information_category     in     varchar2  default hr_api.g_varchar2
127   ,p_per_information1             in     varchar2  default hr_api.g_varchar2
128   ,p_per_information2             in     varchar2  default hr_api.g_varchar2
129   ,p_per_information3             in     varchar2  default hr_api.g_varchar2
130   ,p_per_information4             in     varchar2  default hr_api.g_varchar2
131   ,p_per_information5             in     varchar2  default hr_api.g_varchar2
132   ,p_per_information6             in     varchar2  default hr_api.g_varchar2
133   ,p_per_information7             in     varchar2  default hr_api.g_varchar2
134   ,p_per_information8             in     varchar2  default hr_api.g_varchar2
135   ,p_per_information9             in     varchar2  default hr_api.g_varchar2
136   ,p_per_information10            in     varchar2  default hr_api.g_varchar2
137   ,p_per_information11            in     varchar2  default hr_api.g_varchar2
138   ,p_per_information12            in     varchar2  default hr_api.g_varchar2
139   ,p_per_information13            in     varchar2  default hr_api.g_varchar2
140   ,p_per_information14            in     varchar2  default hr_api.g_varchar2
141   ,p_per_information15            in     varchar2  default hr_api.g_varchar2
142   ,p_per_information16            in     varchar2  default hr_api.g_varchar2
143   ,p_per_information17            in     varchar2  default hr_api.g_varchar2
144   ,p_per_information18            in     varchar2  default hr_api.g_varchar2
145   ,p_per_information19            in     varchar2  default hr_api.g_varchar2
146   ,p_per_information20            in     varchar2  default hr_api.g_varchar2
147   ,p_per_information21            in     varchar2  default hr_api.g_varchar2
148   ,p_per_information22            in     varchar2  default hr_api.g_varchar2
149   ,p_per_information23            in     varchar2  default hr_api.g_varchar2
150   ,p_per_information24            in     varchar2  default hr_api.g_varchar2
151   ,p_per_information25            in     varchar2  default hr_api.g_varchar2
152   ,p_per_information26            in     varchar2  default hr_api.g_varchar2
153   ,p_per_information27            in     varchar2  default hr_api.g_varchar2
154   ,p_per_information28            in     varchar2  default hr_api.g_varchar2
155   ,p_per_information29            in     varchar2  default hr_api.g_varchar2
156   ,p_per_information30            in     varchar2  default hr_api.g_varchar2
157   ,p_error_message                in     varchar2  default hr_api.g_varchar2
158   ,p_creation_date                in     date      default hr_api.g_date
159   ,p_last_update_date             in     date      default hr_api.g_date
160   ,p_allow_access                 in     varchar2  default hr_api.g_varchar2
161   ,p_user_guid                    in     raw      default null
162   ,p_visitor_resp_key             in     varchar2 default hr_api.g_varchar2
163   ,p_visitor_resp_appl_id         in     number   default hr_api.g_number
164   ,p_security_group_key           in     varchar2 default hr_api.g_varchar2
165   ,p_return_status                   out nocopy varchar2
166   );
167 -- ----------------------------------------------------------------------------
168 -- |--------------------------< delete_pending_data >-------------------------|
169 -- ----------------------------------------------------------------------------
170 -- {Start of comments}
171 --
172 -- Description:
173 --  This procedure is the self-service wrapper procedure to the following
174 --  API: irc_pending_data_api.delete_pending_data
175 --
176 -- Pre-requisites
177 --  All 'IN' parameters to this procedure have been appropriately derived.
178 --
179 -- Post Success:
180 --  p_return_status will return value indicating success.
181 --
182 -- Post Failure:
183 --  p_return_status will return value indication failure.
184 --
185 -- Access Status:
186 --  Internal Development use only.
187 --
188 -- {End of comments}
189 -- ----------------------------------------------------------------------------
190 PROCEDURE delete_pending_data
191   (p_validate                     in     number    default hr_api.g_false_num
192   ,p_pending_data_id              in     number
193   ,p_return_status                out nocopy varchar2
194   );
195  end irc_pending_data_swi;