DBA Data[Home] [Help]

PACKAGE: APPS.IRC_SEARCH_CRITERIA_BK8

Source


1 Package IRC_SEARCH_CRITERIA_BK8 as
2 /* $Header: iriscapi.pkh 120.2 2008/02/21 14:24:29 viviswan noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |-------------------------< UPDATE_WORK_CHOICES_B >-------------------------|
6 -- ----------------------------------------------------------------------------
7 --
8 procedure UPDATE_WORK_CHOICES_B
9   (p_effective_date                in     date
10   ,p_search_criteria_id            in     number
11   ,p_location                      in     varchar2
12   ,p_distance_to_location          in     varchar2
13   ,p_geocode_location              in     varchar2
14   ,p_geocode_country               in     varchar2
15   ,p_derived_location              in     varchar2
16   ,p_location_id                   in     number
17   ,p_longitude                     in     number
18   ,p_latitude                      in     number
19   ,p_employee                      in     varchar2
20   ,p_contractor                    in     varchar2
21   ,p_employment_category           in     varchar2
22   ,p_keywords                      in     varchar2
23   ,p_travel_percentage             in     number
24   ,p_min_salary                    in     number
25   ,p_salary_currency               in     varchar2
26   ,p_salary_period                 in     varchar2
27   ,p_match_competence              in     varchar2
28   ,p_match_qualification           in     varchar2
29   ,p_work_at_home                  in     varchar2
30   ,p_job_title                     in     varchar2
31   ,p_department                    in     varchar2
32   ,p_professional_area             in     varchar2
33   ,p_description                   in     varchar2
34   ,p_attribute_category            in     varchar2
35   ,p_attribute1                    in     varchar2
36   ,p_attribute2                    in     varchar2
37   ,p_attribute3                    in     varchar2
38   ,p_attribute4                    in     varchar2
39   ,p_attribute5                    in     varchar2
40   ,p_attribute6                    in     varchar2
41   ,p_attribute7                    in     varchar2
42   ,p_attribute8                    in     varchar2
43   ,p_attribute9                    in     varchar2
44   ,p_attribute10                   in     varchar2
45   ,p_attribute11                   in     varchar2
46   ,p_attribute12                   in     varchar2
47   ,p_attribute13                   in     varchar2
48   ,p_attribute14                   in     varchar2
49   ,p_attribute15                   in     varchar2
50   ,p_attribute16                   in     varchar2
51   ,p_attribute17                   in     varchar2
52   ,p_attribute18                   in     varchar2
53   ,p_attribute19                   in     varchar2
54   ,p_attribute20                   in     varchar2
55   ,p_attribute21                   in     varchar2
56   ,p_attribute22                   in     varchar2
57   ,p_attribute23                   in     varchar2
58   ,p_attribute24                   in     varchar2
59   ,p_attribute25                   in     varchar2
60   ,p_attribute26                   in     varchar2
61   ,p_attribute27                   in     varchar2
62   ,p_attribute28                   in     varchar2
63   ,p_attribute29                   in     varchar2
64   ,p_attribute30                   in     varchar2
65   ,p_isc_information_category      in     varchar2
66   ,p_isc_information1              in     varchar2
67   ,p_isc_information2              in     varchar2
68   ,p_isc_information3              in     varchar2
69   ,p_isc_information4              in     varchar2
70   ,p_isc_information5              in     varchar2
71   ,p_isc_information6              in     varchar2
72   ,p_isc_information7              in     varchar2
73   ,p_isc_information8              in     varchar2
74   ,p_isc_information9              in     varchar2
75   ,p_isc_information10             in     varchar2
76   ,p_isc_information11             in     varchar2
77   ,p_isc_information12             in     varchar2
78   ,p_isc_information13             in     varchar2
79   ,p_isc_information14             in     varchar2
80   ,p_isc_information15             in     varchar2
81   ,p_isc_information16             in     varchar2
82   ,p_isc_information17             in     varchar2
83   ,p_isc_information18             in     varchar2
84   ,p_isc_information19             in     varchar2
85   ,p_isc_information20             in     varchar2
86   ,p_isc_information21             in     varchar2
87   ,p_isc_information22             in     varchar2
88   ,p_isc_information23             in     varchar2
89   ,p_isc_information24             in     varchar2
90   ,p_isc_information25             in     varchar2
91   ,p_isc_information26             in     varchar2
92   ,p_isc_information27             in     varchar2
93   ,p_isc_information28             in     varchar2
94   ,p_isc_information29             in     varchar2
95   ,p_isc_information30             in     varchar2
96   ,p_object_version_number         in     number
97 );
98 --
99 -- ----------------------------------------------------------------------------
100 -- |-------------------------< UPDATE_WORK_CHOICES_A >-------------------------|
101 -- ----------------------------------------------------------------------------
102 --
103 procedure UPDATE_WORK_CHOICES_A
104   (p_effective_date                in     date
105   ,p_search_criteria_id            in     number
106   ,p_location                      in     varchar2
107   ,p_distance_to_location          in     varchar2
108   ,p_geocode_location              in     varchar2
109   ,p_geocode_country               in     varchar2
110   ,p_derived_location              in     varchar2
111   ,p_location_id                   in     number
112   ,p_longitude                     in     number
113   ,p_latitude                      in     number
114   ,p_employee                      in     varchar2
115   ,p_contractor                    in     varchar2
116   ,p_employment_category           in     varchar2
117   ,p_keywords                      in     varchar2
118   ,p_travel_percentage             in     number
119   ,p_min_salary                    in     number
120   ,p_salary_currency               in     varchar2
121   ,p_salary_period                 in     varchar2
122   ,p_match_competence              in     varchar2
123   ,p_match_qualification           in     varchar2
124   ,p_work_at_home                  in     varchar2
125   ,p_job_title                     in     varchar2
126   ,p_department                    in     varchar2
127   ,p_professional_area             in     varchar2
128   ,p_description                   in     varchar2
129   ,p_attribute_category            in     varchar2
130   ,p_attribute1                    in     varchar2
131   ,p_attribute2                    in     varchar2
132   ,p_attribute3                    in     varchar2
133   ,p_attribute4                    in     varchar2
134   ,p_attribute5                    in     varchar2
135   ,p_attribute6                    in     varchar2
136   ,p_attribute7                    in     varchar2
137   ,p_attribute8                    in     varchar2
138   ,p_attribute9                    in     varchar2
139   ,p_attribute10                   in     varchar2
140   ,p_attribute11                   in     varchar2
141   ,p_attribute12                   in     varchar2
142   ,p_attribute13                   in     varchar2
143   ,p_attribute14                   in     varchar2
144   ,p_attribute15                   in     varchar2
145   ,p_attribute16                   in     varchar2
146   ,p_attribute17                   in     varchar2
147   ,p_attribute18                   in     varchar2
148   ,p_attribute19                   in     varchar2
149   ,p_attribute20                   in     varchar2
150   ,p_attribute21                   in     varchar2
151   ,p_attribute22                   in     varchar2
152   ,p_attribute23                   in     varchar2
153   ,p_attribute24                   in     varchar2
154   ,p_attribute25                   in     varchar2
155   ,p_attribute26                   in     varchar2
156   ,p_attribute27                   in     varchar2
157   ,p_attribute28                   in     varchar2
158   ,p_attribute29                   in     varchar2
159   ,p_attribute30                   in     varchar2
160   ,p_isc_information_category      in     varchar2
161   ,p_isc_information1              in     varchar2
162   ,p_isc_information2              in     varchar2
163   ,p_isc_information3              in     varchar2
164   ,p_isc_information4              in     varchar2
165   ,p_isc_information5              in     varchar2
166   ,p_isc_information6              in     varchar2
167   ,p_isc_information7              in     varchar2
168   ,p_isc_information8              in     varchar2
169   ,p_isc_information9              in     varchar2
170   ,p_isc_information10             in     varchar2
171   ,p_isc_information11             in     varchar2
172   ,p_isc_information12             in     varchar2
173   ,p_isc_information13             in     varchar2
174   ,p_isc_information14             in     varchar2
175   ,p_isc_information15             in     varchar2
176   ,p_isc_information16             in     varchar2
177   ,p_isc_information17             in     varchar2
178   ,p_isc_information18             in     varchar2
179   ,p_isc_information19             in     varchar2
180   ,p_isc_information20             in     varchar2
181   ,p_isc_information21             in     varchar2
182   ,p_isc_information22             in     varchar2
183   ,p_isc_information23             in     varchar2
184   ,p_isc_information24             in     varchar2
185   ,p_isc_information25             in     varchar2
186   ,p_isc_information26             in     varchar2
187   ,p_isc_information27             in     varchar2
188   ,p_isc_information28             in     varchar2
189   ,p_isc_information29             in     varchar2
190   ,p_isc_information30             in     varchar2
191   ,p_object_version_number         in     number
192 );
193 --
194 end IRC_SEARCH_CRITERIA_BK8;