APPS.PER_APL_UPD dependencies on HR_API

Line 50: -- by raising and handling the exception hr_api.validate_enabled. We use

46: -- default is false. The validation is controlled by a savepoint and
47: -- rollback mechanism. The savepoint is issued at the beginning of the
48: -- process and is rollbacked at the end of the process
49: -- when all the processing has been completed. The rollback is controlled
50: -- by raising and handling the exception hr_api.validate_enabled. We use
51: -- the exception because, by raising the exception with the
52: -- process, we can exit successfully without having any of the 'OUT'
53: -- parameters being set.
54: --

Line 133: p_date_received in date default hr_api.g_date,

129: -- ----------------------------------------------------------------------------
130: Procedure upd
131: (
132: p_application_id in number,
133: p_date_received in date default hr_api.g_date,
134: p_comments in varchar2 default hr_api.g_varchar2,
135: p_current_employer in varchar2 default hr_api.g_varchar2,
136: p_date_end in date default hr_api.g_date,
137: p_projected_hire_date in date default hr_api.g_date,

Line 134: p_comments in varchar2 default hr_api.g_varchar2,

130: Procedure upd
131: (
132: p_application_id in number,
133: p_date_received in date default hr_api.g_date,
134: p_comments in varchar2 default hr_api.g_varchar2,
135: p_current_employer in varchar2 default hr_api.g_varchar2,
136: p_date_end in date default hr_api.g_date,
137: p_projected_hire_date in date default hr_api.g_date,
138: p_successful_flag in varchar2 default hr_api.g_varchar2,

Line 135: p_current_employer in varchar2 default hr_api.g_varchar2,

131: (
132: p_application_id in number,
133: p_date_received in date default hr_api.g_date,
134: p_comments in varchar2 default hr_api.g_varchar2,
135: p_current_employer in varchar2 default hr_api.g_varchar2,
136: p_date_end in date default hr_api.g_date,
137: p_projected_hire_date in date default hr_api.g_date,
138: p_successful_flag in varchar2 default hr_api.g_varchar2,
139: p_termination_reason in varchar2 default hr_api.g_varchar2,

Line 136: p_date_end in date default hr_api.g_date,

132: p_application_id in number,
133: p_date_received in date default hr_api.g_date,
134: p_comments in varchar2 default hr_api.g_varchar2,
135: p_current_employer in varchar2 default hr_api.g_varchar2,
136: p_date_end in date default hr_api.g_date,
137: p_projected_hire_date in date default hr_api.g_date,
138: p_successful_flag in varchar2 default hr_api.g_varchar2,
139: p_termination_reason in varchar2 default hr_api.g_varchar2,
140: p_request_id in number default hr_api.g_number,

Line 137: p_projected_hire_date in date default hr_api.g_date,

133: p_date_received in date default hr_api.g_date,
134: p_comments in varchar2 default hr_api.g_varchar2,
135: p_current_employer in varchar2 default hr_api.g_varchar2,
136: p_date_end in date default hr_api.g_date,
137: p_projected_hire_date in date default hr_api.g_date,
138: p_successful_flag in varchar2 default hr_api.g_varchar2,
139: p_termination_reason in varchar2 default hr_api.g_varchar2,
140: p_request_id in number default hr_api.g_number,
141: p_program_application_id in number default hr_api.g_number,

Line 138: p_successful_flag in varchar2 default hr_api.g_varchar2,

134: p_comments in varchar2 default hr_api.g_varchar2,
135: p_current_employer in varchar2 default hr_api.g_varchar2,
136: p_date_end in date default hr_api.g_date,
137: p_projected_hire_date in date default hr_api.g_date,
138: p_successful_flag in varchar2 default hr_api.g_varchar2,
139: p_termination_reason in varchar2 default hr_api.g_varchar2,
140: p_request_id in number default hr_api.g_number,
141: p_program_application_id in number default hr_api.g_number,
142: p_program_id in number default hr_api.g_number,

Line 139: p_termination_reason in varchar2 default hr_api.g_varchar2,

135: p_current_employer in varchar2 default hr_api.g_varchar2,
136: p_date_end in date default hr_api.g_date,
137: p_projected_hire_date in date default hr_api.g_date,
138: p_successful_flag in varchar2 default hr_api.g_varchar2,
139: p_termination_reason in varchar2 default hr_api.g_varchar2,
140: p_request_id in number default hr_api.g_number,
141: p_program_application_id in number default hr_api.g_number,
142: p_program_id in number default hr_api.g_number,
143: p_program_update_date in date default hr_api.g_date,

Line 140: p_request_id in number default hr_api.g_number,

136: p_date_end in date default hr_api.g_date,
137: p_projected_hire_date in date default hr_api.g_date,
138: p_successful_flag in varchar2 default hr_api.g_varchar2,
139: p_termination_reason in varchar2 default hr_api.g_varchar2,
140: p_request_id in number default hr_api.g_number,
141: p_program_application_id in number default hr_api.g_number,
142: p_program_id in number default hr_api.g_number,
143: p_program_update_date in date default hr_api.g_date,
144: p_appl_attribute_category in varchar2 default hr_api.g_varchar2,

Line 141: p_program_application_id in number default hr_api.g_number,

137: p_projected_hire_date in date default hr_api.g_date,
138: p_successful_flag in varchar2 default hr_api.g_varchar2,
139: p_termination_reason in varchar2 default hr_api.g_varchar2,
140: p_request_id in number default hr_api.g_number,
141: p_program_application_id in number default hr_api.g_number,
142: p_program_id in number default hr_api.g_number,
143: p_program_update_date in date default hr_api.g_date,
144: p_appl_attribute_category in varchar2 default hr_api.g_varchar2,
145: p_appl_attribute1 in varchar2 default hr_api.g_varchar2,

Line 142: p_program_id in number default hr_api.g_number,

138: p_successful_flag in varchar2 default hr_api.g_varchar2,
139: p_termination_reason in varchar2 default hr_api.g_varchar2,
140: p_request_id in number default hr_api.g_number,
141: p_program_application_id in number default hr_api.g_number,
142: p_program_id in number default hr_api.g_number,
143: p_program_update_date in date default hr_api.g_date,
144: p_appl_attribute_category in varchar2 default hr_api.g_varchar2,
145: p_appl_attribute1 in varchar2 default hr_api.g_varchar2,
146: p_appl_attribute2 in varchar2 default hr_api.g_varchar2,

Line 143: p_program_update_date in date default hr_api.g_date,

139: p_termination_reason in varchar2 default hr_api.g_varchar2,
140: p_request_id in number default hr_api.g_number,
141: p_program_application_id in number default hr_api.g_number,
142: p_program_id in number default hr_api.g_number,
143: p_program_update_date in date default hr_api.g_date,
144: p_appl_attribute_category in varchar2 default hr_api.g_varchar2,
145: p_appl_attribute1 in varchar2 default hr_api.g_varchar2,
146: p_appl_attribute2 in varchar2 default hr_api.g_varchar2,
147: p_appl_attribute3 in varchar2 default hr_api.g_varchar2,

Line 144: p_appl_attribute_category in varchar2 default hr_api.g_varchar2,

140: p_request_id in number default hr_api.g_number,
141: p_program_application_id in number default hr_api.g_number,
142: p_program_id in number default hr_api.g_number,
143: p_program_update_date in date default hr_api.g_date,
144: p_appl_attribute_category in varchar2 default hr_api.g_varchar2,
145: p_appl_attribute1 in varchar2 default hr_api.g_varchar2,
146: p_appl_attribute2 in varchar2 default hr_api.g_varchar2,
147: p_appl_attribute3 in varchar2 default hr_api.g_varchar2,
148: p_appl_attribute4 in varchar2 default hr_api.g_varchar2,

Line 145: p_appl_attribute1 in varchar2 default hr_api.g_varchar2,

141: p_program_application_id in number default hr_api.g_number,
142: p_program_id in number default hr_api.g_number,
143: p_program_update_date in date default hr_api.g_date,
144: p_appl_attribute_category in varchar2 default hr_api.g_varchar2,
145: p_appl_attribute1 in varchar2 default hr_api.g_varchar2,
146: p_appl_attribute2 in varchar2 default hr_api.g_varchar2,
147: p_appl_attribute3 in varchar2 default hr_api.g_varchar2,
148: p_appl_attribute4 in varchar2 default hr_api.g_varchar2,
149: p_appl_attribute5 in varchar2 default hr_api.g_varchar2,

Line 146: p_appl_attribute2 in varchar2 default hr_api.g_varchar2,

142: p_program_id in number default hr_api.g_number,
143: p_program_update_date in date default hr_api.g_date,
144: p_appl_attribute_category in varchar2 default hr_api.g_varchar2,
145: p_appl_attribute1 in varchar2 default hr_api.g_varchar2,
146: p_appl_attribute2 in varchar2 default hr_api.g_varchar2,
147: p_appl_attribute3 in varchar2 default hr_api.g_varchar2,
148: p_appl_attribute4 in varchar2 default hr_api.g_varchar2,
149: p_appl_attribute5 in varchar2 default hr_api.g_varchar2,
150: p_appl_attribute6 in varchar2 default hr_api.g_varchar2,

Line 147: p_appl_attribute3 in varchar2 default hr_api.g_varchar2,

143: p_program_update_date in date default hr_api.g_date,
144: p_appl_attribute_category in varchar2 default hr_api.g_varchar2,
145: p_appl_attribute1 in varchar2 default hr_api.g_varchar2,
146: p_appl_attribute2 in varchar2 default hr_api.g_varchar2,
147: p_appl_attribute3 in varchar2 default hr_api.g_varchar2,
148: p_appl_attribute4 in varchar2 default hr_api.g_varchar2,
149: p_appl_attribute5 in varchar2 default hr_api.g_varchar2,
150: p_appl_attribute6 in varchar2 default hr_api.g_varchar2,
151: p_appl_attribute7 in varchar2 default hr_api.g_varchar2,

Line 148: p_appl_attribute4 in varchar2 default hr_api.g_varchar2,

144: p_appl_attribute_category in varchar2 default hr_api.g_varchar2,
145: p_appl_attribute1 in varchar2 default hr_api.g_varchar2,
146: p_appl_attribute2 in varchar2 default hr_api.g_varchar2,
147: p_appl_attribute3 in varchar2 default hr_api.g_varchar2,
148: p_appl_attribute4 in varchar2 default hr_api.g_varchar2,
149: p_appl_attribute5 in varchar2 default hr_api.g_varchar2,
150: p_appl_attribute6 in varchar2 default hr_api.g_varchar2,
151: p_appl_attribute7 in varchar2 default hr_api.g_varchar2,
152: p_appl_attribute8 in varchar2 default hr_api.g_varchar2,

Line 149: p_appl_attribute5 in varchar2 default hr_api.g_varchar2,

145: p_appl_attribute1 in varchar2 default hr_api.g_varchar2,
146: p_appl_attribute2 in varchar2 default hr_api.g_varchar2,
147: p_appl_attribute3 in varchar2 default hr_api.g_varchar2,
148: p_appl_attribute4 in varchar2 default hr_api.g_varchar2,
149: p_appl_attribute5 in varchar2 default hr_api.g_varchar2,
150: p_appl_attribute6 in varchar2 default hr_api.g_varchar2,
151: p_appl_attribute7 in varchar2 default hr_api.g_varchar2,
152: p_appl_attribute8 in varchar2 default hr_api.g_varchar2,
153: p_appl_attribute9 in varchar2 default hr_api.g_varchar2,

Line 150: p_appl_attribute6 in varchar2 default hr_api.g_varchar2,

146: p_appl_attribute2 in varchar2 default hr_api.g_varchar2,
147: p_appl_attribute3 in varchar2 default hr_api.g_varchar2,
148: p_appl_attribute4 in varchar2 default hr_api.g_varchar2,
149: p_appl_attribute5 in varchar2 default hr_api.g_varchar2,
150: p_appl_attribute6 in varchar2 default hr_api.g_varchar2,
151: p_appl_attribute7 in varchar2 default hr_api.g_varchar2,
152: p_appl_attribute8 in varchar2 default hr_api.g_varchar2,
153: p_appl_attribute9 in varchar2 default hr_api.g_varchar2,
154: p_appl_attribute10 in varchar2 default hr_api.g_varchar2,

Line 151: p_appl_attribute7 in varchar2 default hr_api.g_varchar2,

147: p_appl_attribute3 in varchar2 default hr_api.g_varchar2,
148: p_appl_attribute4 in varchar2 default hr_api.g_varchar2,
149: p_appl_attribute5 in varchar2 default hr_api.g_varchar2,
150: p_appl_attribute6 in varchar2 default hr_api.g_varchar2,
151: p_appl_attribute7 in varchar2 default hr_api.g_varchar2,
152: p_appl_attribute8 in varchar2 default hr_api.g_varchar2,
153: p_appl_attribute9 in varchar2 default hr_api.g_varchar2,
154: p_appl_attribute10 in varchar2 default hr_api.g_varchar2,
155: p_appl_attribute11 in varchar2 default hr_api.g_varchar2,

Line 152: p_appl_attribute8 in varchar2 default hr_api.g_varchar2,

148: p_appl_attribute4 in varchar2 default hr_api.g_varchar2,
149: p_appl_attribute5 in varchar2 default hr_api.g_varchar2,
150: p_appl_attribute6 in varchar2 default hr_api.g_varchar2,
151: p_appl_attribute7 in varchar2 default hr_api.g_varchar2,
152: p_appl_attribute8 in varchar2 default hr_api.g_varchar2,
153: p_appl_attribute9 in varchar2 default hr_api.g_varchar2,
154: p_appl_attribute10 in varchar2 default hr_api.g_varchar2,
155: p_appl_attribute11 in varchar2 default hr_api.g_varchar2,
156: p_appl_attribute12 in varchar2 default hr_api.g_varchar2,

Line 153: p_appl_attribute9 in varchar2 default hr_api.g_varchar2,

149: p_appl_attribute5 in varchar2 default hr_api.g_varchar2,
150: p_appl_attribute6 in varchar2 default hr_api.g_varchar2,
151: p_appl_attribute7 in varchar2 default hr_api.g_varchar2,
152: p_appl_attribute8 in varchar2 default hr_api.g_varchar2,
153: p_appl_attribute9 in varchar2 default hr_api.g_varchar2,
154: p_appl_attribute10 in varchar2 default hr_api.g_varchar2,
155: p_appl_attribute11 in varchar2 default hr_api.g_varchar2,
156: p_appl_attribute12 in varchar2 default hr_api.g_varchar2,
157: p_appl_attribute13 in varchar2 default hr_api.g_varchar2,

Line 154: p_appl_attribute10 in varchar2 default hr_api.g_varchar2,

150: p_appl_attribute6 in varchar2 default hr_api.g_varchar2,
151: p_appl_attribute7 in varchar2 default hr_api.g_varchar2,
152: p_appl_attribute8 in varchar2 default hr_api.g_varchar2,
153: p_appl_attribute9 in varchar2 default hr_api.g_varchar2,
154: p_appl_attribute10 in varchar2 default hr_api.g_varchar2,
155: p_appl_attribute11 in varchar2 default hr_api.g_varchar2,
156: p_appl_attribute12 in varchar2 default hr_api.g_varchar2,
157: p_appl_attribute13 in varchar2 default hr_api.g_varchar2,
158: p_appl_attribute14 in varchar2 default hr_api.g_varchar2,

Line 155: p_appl_attribute11 in varchar2 default hr_api.g_varchar2,

151: p_appl_attribute7 in varchar2 default hr_api.g_varchar2,
152: p_appl_attribute8 in varchar2 default hr_api.g_varchar2,
153: p_appl_attribute9 in varchar2 default hr_api.g_varchar2,
154: p_appl_attribute10 in varchar2 default hr_api.g_varchar2,
155: p_appl_attribute11 in varchar2 default hr_api.g_varchar2,
156: p_appl_attribute12 in varchar2 default hr_api.g_varchar2,
157: p_appl_attribute13 in varchar2 default hr_api.g_varchar2,
158: p_appl_attribute14 in varchar2 default hr_api.g_varchar2,
159: p_appl_attribute15 in varchar2 default hr_api.g_varchar2,

Line 156: p_appl_attribute12 in varchar2 default hr_api.g_varchar2,

152: p_appl_attribute8 in varchar2 default hr_api.g_varchar2,
153: p_appl_attribute9 in varchar2 default hr_api.g_varchar2,
154: p_appl_attribute10 in varchar2 default hr_api.g_varchar2,
155: p_appl_attribute11 in varchar2 default hr_api.g_varchar2,
156: p_appl_attribute12 in varchar2 default hr_api.g_varchar2,
157: p_appl_attribute13 in varchar2 default hr_api.g_varchar2,
158: p_appl_attribute14 in varchar2 default hr_api.g_varchar2,
159: p_appl_attribute15 in varchar2 default hr_api.g_varchar2,
160: p_appl_attribute16 in varchar2 default hr_api.g_varchar2,

Line 157: p_appl_attribute13 in varchar2 default hr_api.g_varchar2,

153: p_appl_attribute9 in varchar2 default hr_api.g_varchar2,
154: p_appl_attribute10 in varchar2 default hr_api.g_varchar2,
155: p_appl_attribute11 in varchar2 default hr_api.g_varchar2,
156: p_appl_attribute12 in varchar2 default hr_api.g_varchar2,
157: p_appl_attribute13 in varchar2 default hr_api.g_varchar2,
158: p_appl_attribute14 in varchar2 default hr_api.g_varchar2,
159: p_appl_attribute15 in varchar2 default hr_api.g_varchar2,
160: p_appl_attribute16 in varchar2 default hr_api.g_varchar2,
161: p_appl_attribute17 in varchar2 default hr_api.g_varchar2,

Line 158: p_appl_attribute14 in varchar2 default hr_api.g_varchar2,

154: p_appl_attribute10 in varchar2 default hr_api.g_varchar2,
155: p_appl_attribute11 in varchar2 default hr_api.g_varchar2,
156: p_appl_attribute12 in varchar2 default hr_api.g_varchar2,
157: p_appl_attribute13 in varchar2 default hr_api.g_varchar2,
158: p_appl_attribute14 in varchar2 default hr_api.g_varchar2,
159: p_appl_attribute15 in varchar2 default hr_api.g_varchar2,
160: p_appl_attribute16 in varchar2 default hr_api.g_varchar2,
161: p_appl_attribute17 in varchar2 default hr_api.g_varchar2,
162: p_appl_attribute18 in varchar2 default hr_api.g_varchar2,

Line 159: p_appl_attribute15 in varchar2 default hr_api.g_varchar2,

155: p_appl_attribute11 in varchar2 default hr_api.g_varchar2,
156: p_appl_attribute12 in varchar2 default hr_api.g_varchar2,
157: p_appl_attribute13 in varchar2 default hr_api.g_varchar2,
158: p_appl_attribute14 in varchar2 default hr_api.g_varchar2,
159: p_appl_attribute15 in varchar2 default hr_api.g_varchar2,
160: p_appl_attribute16 in varchar2 default hr_api.g_varchar2,
161: p_appl_attribute17 in varchar2 default hr_api.g_varchar2,
162: p_appl_attribute18 in varchar2 default hr_api.g_varchar2,
163: p_appl_attribute19 in varchar2 default hr_api.g_varchar2,

Line 160: p_appl_attribute16 in varchar2 default hr_api.g_varchar2,

156: p_appl_attribute12 in varchar2 default hr_api.g_varchar2,
157: p_appl_attribute13 in varchar2 default hr_api.g_varchar2,
158: p_appl_attribute14 in varchar2 default hr_api.g_varchar2,
159: p_appl_attribute15 in varchar2 default hr_api.g_varchar2,
160: p_appl_attribute16 in varchar2 default hr_api.g_varchar2,
161: p_appl_attribute17 in varchar2 default hr_api.g_varchar2,
162: p_appl_attribute18 in varchar2 default hr_api.g_varchar2,
163: p_appl_attribute19 in varchar2 default hr_api.g_varchar2,
164: p_appl_attribute20 in varchar2 default hr_api.g_varchar2,

Line 161: p_appl_attribute17 in varchar2 default hr_api.g_varchar2,

157: p_appl_attribute13 in varchar2 default hr_api.g_varchar2,
158: p_appl_attribute14 in varchar2 default hr_api.g_varchar2,
159: p_appl_attribute15 in varchar2 default hr_api.g_varchar2,
160: p_appl_attribute16 in varchar2 default hr_api.g_varchar2,
161: p_appl_attribute17 in varchar2 default hr_api.g_varchar2,
162: p_appl_attribute18 in varchar2 default hr_api.g_varchar2,
163: p_appl_attribute19 in varchar2 default hr_api.g_varchar2,
164: p_appl_attribute20 in varchar2 default hr_api.g_varchar2,
165: p_object_version_number in out nocopy number,

Line 162: p_appl_attribute18 in varchar2 default hr_api.g_varchar2,

158: p_appl_attribute14 in varchar2 default hr_api.g_varchar2,
159: p_appl_attribute15 in varchar2 default hr_api.g_varchar2,
160: p_appl_attribute16 in varchar2 default hr_api.g_varchar2,
161: p_appl_attribute17 in varchar2 default hr_api.g_varchar2,
162: p_appl_attribute18 in varchar2 default hr_api.g_varchar2,
163: p_appl_attribute19 in varchar2 default hr_api.g_varchar2,
164: p_appl_attribute20 in varchar2 default hr_api.g_varchar2,
165: p_object_version_number in out nocopy number,
166: p_effective_date in date,

Line 163: p_appl_attribute19 in varchar2 default hr_api.g_varchar2,

159: p_appl_attribute15 in varchar2 default hr_api.g_varchar2,
160: p_appl_attribute16 in varchar2 default hr_api.g_varchar2,
161: p_appl_attribute17 in varchar2 default hr_api.g_varchar2,
162: p_appl_attribute18 in varchar2 default hr_api.g_varchar2,
163: p_appl_attribute19 in varchar2 default hr_api.g_varchar2,
164: p_appl_attribute20 in varchar2 default hr_api.g_varchar2,
165: p_object_version_number in out nocopy number,
166: p_effective_date in date,
167: p_validate in boolean default false

Line 164: p_appl_attribute20 in varchar2 default hr_api.g_varchar2,

160: p_appl_attribute16 in varchar2 default hr_api.g_varchar2,
161: p_appl_attribute17 in varchar2 default hr_api.g_varchar2,
162: p_appl_attribute18 in varchar2 default hr_api.g_varchar2,
163: p_appl_attribute19 in varchar2 default hr_api.g_varchar2,
164: p_appl_attribute20 in varchar2 default hr_api.g_varchar2,
165: p_object_version_number in out nocopy number,
166: p_effective_date in date,
167: p_validate in boolean default false
168: );