[Home] [Help]
PACKAGE: APPS.PQH_TXN_JOB_REQUIREMENTS_API
Source
1 Package PQH_TXN_JOB_REQUIREMENTS_API AUTHID CURRENT_USER as
2 /* $Header: pqtjrapi.pkh 120.0 2005/05/29 02:48:52 appldev noship $ */
3 --
7 -- {Start Of Comments}
4 -- ----------------------------------------------------------------------------
5 -- |--------------------------< CREATE_TXN_JOB_REQUIREMENT >------------------|
6 -- ----------------------------------------------------------------------------
8 --
9 -- Description:
10 --
11 --
12 -- Prerequisites:
13 --
14 --
15 -- In Parameters:
16 -- Name Reqd Type Description
17 --
18 --
19 -- Post Success:
20 --
21 --
22 -- Name Type Description
23 --
24 -- Post Failure:
25 --
26 --
27 -- Access Status:
28 -- Public.
29 --
30 -- {End Of Comments}
31 --
32 procedure CREATE_TXN_JOB_REQUIREMENT
33 (p_validate in boolean default false
34 ,p_effective_date in date
35 ,p_txn_job_requirement_id out nocopy number
36 ,p_object_version_number out nocopy number
37 ,p_business_group_id in number
38 ,p_analysis_criteria_id in number
39 ,p_position_transaction_id in number default null
40 ,p_job_requirement_id in number default null
41 ,p_date_from in date default null
42 ,p_date_to in date default null
43 ,p_essential in varchar2 default null
44 ,p_job_id in number default null
45 ,p_request_id in number default null
46 ,p_program_application_id in number default null
47 ,p_program_id in number default null
48 ,p_program_update_date in date default null
49 ,p_attribute_category in varchar2 default null
50 ,p_attribute1 in varchar2 default null
51 ,p_attribute2 in varchar2 default null
52 ,p_attribute3 in varchar2 default null
53 ,p_attribute4 in varchar2 default null
54 ,p_attribute5 in varchar2 default null
55 ,p_attribute6 in varchar2 default null
56 ,p_attribute7 in varchar2 default null
57 ,p_attribute8 in varchar2 default null
58 ,p_attribute9 in varchar2 default null
59 ,p_attribute10 in varchar2 default null
60 ,p_attribute11 in varchar2 default null
61 ,p_attribute12 in varchar2 default null
62 ,p_attribute13 in varchar2 default null
63 ,p_attribute14 in varchar2 default null
64 ,p_attribute15 in varchar2 default null
65 ,p_attribute16 in varchar2 default null
66 ,p_attribute17 in varchar2 default null
67 ,p_attribute18 in varchar2 default null
68 ,p_attribute19 in varchar2 default null
69 ,p_attribute20 in varchar2 default null
70 ,p_comments in varchar2 default null
71 );
72 --
73 -- ----------------------------------------------------------------------------
74 -- |--------------------------< UPDATE_TXN_JOB_REQUIREMENT >------------------|
75 -- ----------------------------------------------------------------------------
76 -- {Start Of Comments}
77 --
78 -- Description:
79 --
80 --
81 -- Prerequisites:
82 --
83 --
84 -- In Parameters:
85 -- Name Reqd Type Description
86 --
87 --
88 -- Post Success:
89 --
90 --
91 -- Name Type Description
92 --
93 -- Post Failure:
94 --
95 --
96 -- Access Status:
97 -- Public.
98 --
99 -- {End Of Comments}
100 --
101 procedure UPDATE_TXN_JOB_REQUIREMENT
102 (p_validate in boolean default false
103 ,p_effective_date in date
104 ,p_txn_job_requirement_id in number
105 ,p_object_version_number in out nocopy number
106 ,p_business_group_id in number default hr_api.g_number
107 ,p_analysis_criteria_id in number default hr_api.g_number
108 ,p_position_transaction_id in number default hr_api.g_number
109 ,p_job_requirement_id in number default hr_api.g_number
110 ,p_date_from in date default hr_api.g_date
111 ,p_date_to in date default hr_api.g_date
112 ,p_essential in varchar2 default hr_api.g_varchar2
113 ,p_job_id in number default hr_api.g_number
114 ,p_request_id in number default hr_api.g_number
115 ,p_program_application_id in number default hr_api.g_number
116 ,p_program_id in number default hr_api.g_number
117 ,p_program_update_date in date default hr_api.g_date
118 ,p_attribute_category in varchar2 default hr_api.g_varchar2
119 ,p_attribute1 in varchar2 default hr_api.g_varchar2
120 ,p_attribute2 in varchar2 default hr_api.g_varchar2
121 ,p_attribute3 in varchar2 default hr_api.g_varchar2
122 ,p_attribute4 in varchar2 default hr_api.g_varchar2
123 ,p_attribute5 in varchar2 default hr_api.g_varchar2
124 ,p_attribute6 in varchar2 default hr_api.g_varchar2
125 ,p_attribute7 in varchar2 default hr_api.g_varchar2
126 ,p_attribute8 in varchar2 default hr_api.g_varchar2
130 ,p_attribute12 in varchar2 default hr_api.g_varchar2
127 ,p_attribute9 in varchar2 default hr_api.g_varchar2
128 ,p_attribute10 in varchar2 default hr_api.g_varchar2
129 ,p_attribute11 in varchar2 default hr_api.g_varchar2
131 ,p_attribute13 in varchar2 default hr_api.g_varchar2
132 ,p_attribute14 in varchar2 default hr_api.g_varchar2
133 ,p_attribute15 in varchar2 default hr_api.g_varchar2
134 ,p_attribute16 in varchar2 default hr_api.g_varchar2
135 ,p_attribute17 in varchar2 default hr_api.g_varchar2
136 ,p_attribute18 in varchar2 default hr_api.g_varchar2
137 ,p_attribute19 in varchar2 default hr_api.g_varchar2
138 ,p_attribute20 in varchar2 default hr_api.g_varchar2
139 ,p_comments in varchar2 default hr_api.g_varchar2
140 );
141 --
142 --
143 -- ----------------------------------------------------------------------------
144 -- |--------------------------< DELETE_TXN_JOB_REQUIREMENT >------------------|
145 -- ----------------------------------------------------------------------------
146 -- {Start Of Comments}
147 --
148 -- Description:
149 --
150 --
151 -- Prerequisites:
152 --
153 --
154 -- In Parameters:
155 -- Name Reqd Type Description
156 --
157 --
158 -- Post Success:
159 --
160 --
161 -- Name Type Description
162 --
163 -- Post Failure:
164 --
165 --
166 -- Access Status:
167 -- Public.
168 --
169 -- {End Of Comments}
170 --
171 procedure DELETE_TXN_JOB_REQUIREMENT
172 (p_validate in boolean default false
173 ,p_effective_date in date
174 ,p_txn_job_requirement_id in number
175 ,p_object_version_number in number
176 );
177 --
178 --
179 end PQH_TXN_JOB_REQUIREMENTS_API;