1 Package PER_VACANCY_BK2 as
2 /* $Header: pevacapi.pkh 120.1.12000000.1 2007/01/22 04:59:40 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |-------------------------< update_vacancy_b >-------------------------|
6 -- ----------------------------------------------------------------------------
7 --
8 procedure update_vacancy_b
9 ( p_effective_date in date
10 , P_VACANCY_ID in number
11 , P_OBJECT_VERSION_NUMBER in number
12 , P_DATE_FROM in date
13 , P_POSITION_ID in number
14 , P_JOB_ID in number
15 , P_GRADE_ID in number
16 , P_ORGANIZATION_ID in number
17 , P_PEOPLE_GROUP_ID in number
18 , P_LOCATION_ID in number
19 , P_RECRUITER_ID in number
20 , P_DATE_TO in date
21 , P_SECURITY_METHOD in varchar2
22 , P_DESCRIPTION in varchar2
23 , P_NUMBER_OF_OPENINGS in number
24 , P_STATUS in varchar2
25 , P_BUDGET_MEASUREMENT_TYPE in varchar2
26 , P_BUDGET_MEASUREMENT_VALUE in number
27 , P_VACANCY_CATEGORY in varchar2
28 , P_MANAGER_ID in number
29 , P_PRIMARY_POSTING_ID in number
30 , P_ASSESSMENT_ID in number
31 , P_ATTRIBUTE_CATEGORY in varchar2
32 , P_ATTRIBUTE1 in varchar2
33 , P_ATTRIBUTE2 in varchar2
34 , P_ATTRIBUTE3 in varchar2
35 , P_ATTRIBUTE4 in varchar2
36 , P_ATTRIBUTE5 in varchar2
37 , P_ATTRIBUTE6 in varchar2
38 , P_ATTRIBUTE7 in varchar2
39 , P_ATTRIBUTE8 in varchar2
40 , P_ATTRIBUTE9 in varchar2
41 , P_ATTRIBUTE10 in varchar2
42 , P_ATTRIBUTE11 in varchar2
43 , P_ATTRIBUTE12 in varchar2
44 , P_ATTRIBUTE13 in varchar2
45 , P_ATTRIBUTE14 in varchar2
46 , P_ATTRIBUTE15 in varchar2
47 , P_ATTRIBUTE16 in varchar2
48 , P_ATTRIBUTE17 in varchar2
49 , P_ATTRIBUTE18 in varchar2
50 , P_ATTRIBUTE19 in varchar2
51 , P_ATTRIBUTE20 in varchar2
52 , P_ATTRIBUTE21 in varchar2
53 , P_ATTRIBUTE22 in varchar2
54 , P_ATTRIBUTE23 in varchar2
55 , P_ATTRIBUTE24 in varchar2
56 , P_ATTRIBUTE25 in varchar2
57 , P_ATTRIBUTE26 in varchar2
58 , P_ATTRIBUTE27 in varchar2
59 , P_ATTRIBUTE28 in varchar2
60 , P_ATTRIBUTE29 in varchar2
61 , P_ATTRIBUTE30 in varchar2
62 );
63 --
64 -- ----------------------------------------------------------------------------
65 -- |-------------------------< update_vacancy_a >-------------------------|
66 -- ----------------------------------------------------------------------------
67 --
68 procedure update_vacancy_a
69 ( p_effective_date in date
70 , P_VACANCY_ID in number
71 , P_OBJECT_VERSION_NUMBER in number
72 , P_DATE_FROM in date
73 , P_POSITION_ID in number
74 , P_JOB_ID in number
75 , P_GRADE_ID in number
76 , P_ORGANIZATION_ID in number
77 , P_PEOPLE_GROUP_ID in number
78 , P_LOCATION_ID in number
79 , P_RECRUITER_ID in number
80 , P_DATE_TO in date
81 , P_SECURITY_METHOD in varchar2
82 , P_DESCRIPTION in varchar2
83 , P_NUMBER_OF_OPENINGS in number
84 , P_STATUS in varchar2
85 , P_BUDGET_MEASUREMENT_TYPE in varchar2
86 , P_BUDGET_MEASUREMENT_VALUE in number
87 , P_VACANCY_CATEGORY in varchar2
88 , P_MANAGER_ID in number
89 , P_PRIMARY_POSTING_ID in number
90 , P_ASSESSMENT_ID in number
91 , P_ATTRIBUTE_CATEGORY in varchar2
92 , P_ATTRIBUTE1 in varchar2
93 , P_ATTRIBUTE2 in varchar2
94 , P_ATTRIBUTE3 in varchar2
95 , P_ATTRIBUTE4 in varchar2
96 , P_ATTRIBUTE5 in varchar2
97 , P_ATTRIBUTE6 in varchar2
98 , P_ATTRIBUTE7 in varchar2
99 , P_ATTRIBUTE8 in varchar2
100 , P_ATTRIBUTE9 in varchar2
101 , P_ATTRIBUTE10 in varchar2
102 , P_ATTRIBUTE11 in varchar2
103 , P_ATTRIBUTE12 in varchar2
104 , P_ATTRIBUTE13 in varchar2
105 , P_ATTRIBUTE14 in varchar2
106 , P_ATTRIBUTE15 in varchar2
107 , P_ATTRIBUTE16 in varchar2
108 , P_ATTRIBUTE17 in varchar2
109 , P_ATTRIBUTE18 in varchar2
110 , P_ATTRIBUTE19 in varchar2
111 , P_ATTRIBUTE20 in varchar2
112 , P_ATTRIBUTE21 in varchar2
113 , P_ATTRIBUTE22 in varchar2
114 , P_ATTRIBUTE23 in varchar2
115 , P_ATTRIBUTE24 in varchar2
116 , P_ATTRIBUTE25 in varchar2
117 , P_ATTRIBUTE26 in varchar2
118 , P_ATTRIBUTE27 in varchar2
119 , P_ATTRIBUTE28 in varchar2
120 , P_ATTRIBUTE29 in varchar2
121 , P_ATTRIBUTE30 in varchar2
122 , P_ASSIGNMENT_CHANGED in boolean
123 ,p_inv_pos_grade_warning in boolean
124 ,p_inv_job_grade_warning in boolean
125 )
126 ;
127 --
128 end PER_VACANCY_BK2;
[Home] [Help]