DBA Data[Home] [Help]

PACKAGE: APPS.IRC_POSTING_CONTENT_SWI

Source


1 Package irc_posting_content_swi AUTHID CURRENT_USER As
2 /* $Header: iripcswi.pkh 120.2 2006/09/19 10:18:24 cnholmes noship $ */
3 -- ----------------------------------------------------------------------------
4 -- |------------------------< create_posting_content >------------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start of comments}
7 --
8 -- Description:
9 --  This procedure is the self-service wrapper procedure to the following
10 --  API: irc_posting_content_api.create_posting_content
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_posting_content
27   (p_validate                     in     number    default hr_api.g_false_num
28   ,p_display_manager_info         in     varchar2
29   ,p_display_recruiter_info       in     varchar2
30   ,p_language_code                in     varchar2  default null
31   ,p_name                         in     varchar2
32   ,p_org_name                     in     varchar2  default null
33   ,p_org_description              in     varchar2  default null
34   ,p_job_title                    in     varchar2  default null
35   ,p_brief_description            in     varchar2  default null
36   ,p_detailed_description         in     varchar2  default null
37   ,p_job_requirements             in     varchar2  default null
38   ,p_additional_details           in     varchar2  default null
39   ,p_how_to_apply                 in     varchar2  default null
40   ,p_benefit_info                 in     varchar2  default null
41   ,p_image_url                    in     varchar2  default null
42   ,p_alt_image_url                in     varchar2  default null
43   ,p_attribute_category           in     varchar2  default null
44   ,p_attribute1                   in     varchar2  default null
45   ,p_attribute2                   in     varchar2  default null
46   ,p_attribute3                   in     varchar2  default null
47   ,p_attribute4                   in     varchar2  default null
48   ,p_attribute5                   in     varchar2  default null
49   ,p_attribute6                   in     varchar2  default null
50   ,p_attribute7                   in     varchar2  default null
51   ,p_attribute8                   in     varchar2  default null
52   ,p_attribute9                   in     varchar2  default null
53   ,p_attribute10                  in     varchar2  default null
54   ,p_attribute11                  in     varchar2  default null
55   ,p_attribute12                  in     varchar2  default null
56   ,p_attribute13                  in     varchar2  default null
57   ,p_attribute14                  in     varchar2  default null
58   ,p_attribute15                  in     varchar2  default null
59   ,p_attribute16                  in     varchar2  default null
60   ,p_attribute17                  in     varchar2  default null
61   ,p_attribute18                  in     varchar2  default null
62   ,p_attribute19                  in     varchar2  default null
63   ,p_attribute20                  in     varchar2  default null
64   ,p_attribute21                  in     varchar2  default null
65   ,p_attribute22                  in     varchar2  default null
66   ,p_attribute23                  in     varchar2  default null
67   ,p_attribute24                  in     varchar2  default null
68   ,p_attribute25                  in     varchar2  default null
69   ,p_attribute26                  in     varchar2  default null
70   ,p_attribute27                  in     varchar2  default null
71   ,p_attribute28                  in     varchar2  default null
72   ,p_attribute29                  in     varchar2  default null
73   ,p_attribute30                  in     varchar2  default null
74   ,p_ipc_information_category     in     varchar2  default null
75   ,p_ipc_information1             in     varchar2  default null
76   ,p_ipc_information2             in     varchar2  default null
77   ,p_ipc_information3             in     varchar2  default null
78   ,p_ipc_information4             in     varchar2  default null
79   ,p_ipc_information5             in     varchar2  default null
80   ,p_ipc_information6             in     varchar2  default null
81   ,p_ipc_information7             in     varchar2  default null
82   ,p_ipc_information8             in     varchar2  default null
83   ,p_ipc_information9             in     varchar2  default null
84   ,p_ipc_information10            in     varchar2  default null
85   ,p_ipc_information11            in     varchar2  default null
86   ,p_ipc_information12            in     varchar2  default null
87   ,p_ipc_information13            in     varchar2  default null
88   ,p_ipc_information14            in     varchar2  default null
89   ,p_ipc_information15            in     varchar2  default null
90   ,p_ipc_information16            in     varchar2  default null
91   ,p_ipc_information17            in     varchar2  default null
92   ,p_ipc_information18            in     varchar2  default null
93   ,p_ipc_information19            in     varchar2  default null
94   ,p_ipc_information20            in     varchar2  default null
95   ,p_ipc_information21            in     varchar2  default null
96   ,p_ipc_information22            in     varchar2  default null
97   ,p_ipc_information23            in     varchar2  default null
98   ,p_ipc_information24            in     varchar2  default null
99   ,p_ipc_information25            in     varchar2  default null
100   ,p_ipc_information26            in     varchar2  default null
101   ,p_ipc_information27            in     varchar2  default null
102   ,p_ipc_information28            in     varchar2  default null
103   ,p_ipc_information29            in     varchar2  default null
104   ,p_ipc_information30            in     varchar2  default null
105   ,p_date_approved                in     date      default null
106   ,p_posting_content_id           in     number
107   ,p_object_version_number           out nocopy number
108   ,p_return_status                   out nocopy varchar2
109   );
110 -- ----------------------------------------------------------------------------
111 -- |------------------------< delete_posting_content >------------------------|
112 -- ----------------------------------------------------------------------------
113 -- {Start of comments}
114 --
115 -- Description:
116 --  This procedure is the self-service wrapper procedure to the following
117 --  API: irc_posting_content_api.delete_posting_content
118 --
119 -- Pre-requisites
120 --  All 'IN' parameters to this procedure have been appropriately derived.
121 --
122 -- Post Success:
123 --  p_return_status will return value indicating success.
124 --
125 -- Post Failure:
126 --  p_return_status will return value indication failure.
127 --
128 -- Access Status:
129 --  Internal Development use only.
130 --
131 -- {End of comments}
132 -- ----------------------------------------------------------------------------
133 PROCEDURE delete_posting_content
134   (p_validate                     in     number    default hr_api.g_false_num
135   ,p_posting_content_id           in     number
136   ,p_object_version_number        in     number
137   ,p_return_status                   out nocopy varchar2
138   );
139 -- ----------------------------------------------------------------------------
140 -- |------------------------< update_posting_content >------------------------|
141 -- ----------------------------------------------------------------------------
142 -- {Start of comments}
143 --
144 -- Description:
145 --  This procedure is the self-service wrapper procedure to the following
146 --  API: irc_posting_content_api.update_posting_content
147 --
148 -- Pre-requisites
149 --  All 'IN' parameters to this procedure have been appropriately derived.
150 --
151 -- Post Success:
152 --  p_return_status will return value indicating success.
153 --
154 -- Post Failure:
155 --  p_return_status will return value indication failure.
156 --
157 -- Access Status:
158 --  Internal Development use only.
159 --
160 -- {End of comments}
161 -- ----------------------------------------------------------------------------
162 PROCEDURE update_posting_content
163   (p_validate                     in     number    default hr_api.g_false_num
164   ,p_posting_content_id           in     number
165   ,p_display_manager_info         in     varchar2  default hr_api.g_varchar2
166   ,p_display_recruiter_info       in     varchar2  default hr_api.g_varchar2
167   ,p_language_code                in     varchar2  default hr_api.g_varchar2
168   ,p_name                         in     varchar2  default hr_api.g_varchar2
169   ,p_org_name                     in     varchar2  default hr_api.g_varchar2
170   ,p_org_description              in     varchar2  default hr_api.g_varchar2
171   ,p_job_title                    in     varchar2  default hr_api.g_varchar2
172   ,p_brief_description            in     varchar2  default hr_api.g_varchar2
173   ,p_detailed_description         in     varchar2  default hr_api.g_varchar2
174   ,p_job_requirements             in     varchar2  default hr_api.g_varchar2
175   ,p_additional_details           in     varchar2  default hr_api.g_varchar2
176   ,p_how_to_apply                 in     varchar2  default hr_api.g_varchar2
177   ,p_benefit_info                 in     varchar2  default hr_api.g_varchar2
178   ,p_image_url                    in     varchar2  default hr_api.g_varchar2
179   ,p_alt_image_url                in     varchar2  default hr_api.g_varchar2
180   ,p_attribute_category           in     varchar2  default hr_api.g_varchar2
181   ,p_attribute1                   in     varchar2  default hr_api.g_varchar2
182   ,p_attribute2                   in     varchar2  default hr_api.g_varchar2
183   ,p_attribute3                   in     varchar2  default hr_api.g_varchar2
184   ,p_attribute4                   in     varchar2  default hr_api.g_varchar2
185   ,p_attribute5                   in     varchar2  default hr_api.g_varchar2
186   ,p_attribute6                   in     varchar2  default hr_api.g_varchar2
187   ,p_attribute7                   in     varchar2  default hr_api.g_varchar2
188   ,p_attribute8                   in     varchar2  default hr_api.g_varchar2
189   ,p_attribute9                   in     varchar2  default hr_api.g_varchar2
190   ,p_attribute10                  in     varchar2  default hr_api.g_varchar2
191   ,p_attribute11                  in     varchar2  default hr_api.g_varchar2
192   ,p_attribute12                  in     varchar2  default hr_api.g_varchar2
193   ,p_attribute13                  in     varchar2  default hr_api.g_varchar2
194   ,p_attribute14                  in     varchar2  default hr_api.g_varchar2
195   ,p_attribute15                  in     varchar2  default hr_api.g_varchar2
196   ,p_attribute16                  in     varchar2  default hr_api.g_varchar2
197   ,p_attribute17                  in     varchar2  default hr_api.g_varchar2
198   ,p_attribute18                  in     varchar2  default hr_api.g_varchar2
199   ,p_attribute19                  in     varchar2  default hr_api.g_varchar2
200   ,p_attribute20                  in     varchar2  default hr_api.g_varchar2
201   ,p_attribute21                  in     varchar2  default hr_api.g_varchar2
202   ,p_attribute22                  in     varchar2  default hr_api.g_varchar2
203   ,p_attribute23                  in     varchar2  default hr_api.g_varchar2
204   ,p_attribute24                  in     varchar2  default hr_api.g_varchar2
205   ,p_attribute25                  in     varchar2  default hr_api.g_varchar2
206   ,p_attribute26                  in     varchar2  default hr_api.g_varchar2
207   ,p_attribute27                  in     varchar2  default hr_api.g_varchar2
208   ,p_attribute28                  in     varchar2  default hr_api.g_varchar2
209   ,p_attribute29                  in     varchar2  default hr_api.g_varchar2
210   ,p_attribute30                  in     varchar2  default hr_api.g_varchar2
211   ,p_ipc_information_category     in     varchar2  default hr_api.g_varchar2
212   ,p_ipc_information1             in     varchar2  default hr_api.g_varchar2
213   ,p_ipc_information2             in     varchar2  default hr_api.g_varchar2
214   ,p_ipc_information3             in     varchar2  default hr_api.g_varchar2
215   ,p_ipc_information4             in     varchar2  default hr_api.g_varchar2
216   ,p_ipc_information5             in     varchar2  default hr_api.g_varchar2
217   ,p_ipc_information6             in     varchar2  default hr_api.g_varchar2
218   ,p_ipc_information7             in     varchar2  default hr_api.g_varchar2
219   ,p_ipc_information8             in     varchar2  default hr_api.g_varchar2
220   ,p_ipc_information9             in     varchar2  default hr_api.g_varchar2
221   ,p_ipc_information10            in     varchar2  default hr_api.g_varchar2
222   ,p_ipc_information11            in     varchar2  default hr_api.g_varchar2
223   ,p_ipc_information12            in     varchar2  default hr_api.g_varchar2
224   ,p_ipc_information13            in     varchar2  default hr_api.g_varchar2
225   ,p_ipc_information14            in     varchar2  default hr_api.g_varchar2
226   ,p_ipc_information15            in     varchar2  default hr_api.g_varchar2
227   ,p_ipc_information16            in     varchar2  default hr_api.g_varchar2
228   ,p_ipc_information17            in     varchar2  default hr_api.g_varchar2
229   ,p_ipc_information18            in     varchar2  default hr_api.g_varchar2
230   ,p_ipc_information19            in     varchar2  default hr_api.g_varchar2
231   ,p_ipc_information20            in     varchar2  default hr_api.g_varchar2
232   ,p_ipc_information21            in     varchar2  default hr_api.g_varchar2
233   ,p_ipc_information22            in     varchar2  default hr_api.g_varchar2
234   ,p_ipc_information23            in     varchar2  default hr_api.g_varchar2
235   ,p_ipc_information24            in     varchar2  default hr_api.g_varchar2
236   ,p_ipc_information25            in     varchar2  default hr_api.g_varchar2
237   ,p_ipc_information26            in     varchar2  default hr_api.g_varchar2
238   ,p_ipc_information27            in     varchar2  default hr_api.g_varchar2
239   ,p_ipc_information28            in     varchar2  default hr_api.g_varchar2
240   ,p_ipc_information29            in     varchar2  default hr_api.g_varchar2
241   ,p_ipc_information30            in     varchar2  default hr_api.g_varchar2
242   ,p_date_approved                in     date      default hr_api.g_date
243   ,p_object_version_number        in out nocopy number
244   ,p_return_status                   out nocopy varchar2
245   );
246 --
247 procedure process_api
248 (
249   p_document            in         CLOB
250  ,p_return_status       out nocopy VARCHAR2
251  ,p_validate            in         number    default hr_api.g_false_num
252  ,p_effective_date      in         date      default null
253 );
254 --
255 Function getClobValue(
256   commitNode in xmldom.DOMNode,
257   attributeName in VARCHAR2,
258   gmisc_value in varchar2 default hr_api.g_varchar2)
259 return varchar2;
260 --
261 end irc_posting_content_swi;