24: --
25: -- {End of comments}
26: -- ----------------------------------------------------------------------------
27: PROCEDURE create_training_plan_member
28: (p_validate IN NUMBER DEFAULT hr_api.g_false_num
29: ,p_effective_date IN DATE
30: ,p_business_group_id IN NUMBER
31: ,p_training_plan_id IN NUMBER DEFAULT NULL
32: ,p_activity_version_id IN NUMBER
102: --
103: -- {End of comments}
104: -- ----------------------------------------------------------------------------
105: PROCEDURE delete_training_plan_member
106: (p_validate IN NUMBER DEFAULT hr_api.g_false_num
107: ,p_training_plan_member_id IN number
108: ,p_object_version_NUMBER IN number
109: ,p_return_status OUT NOCOPY VARCHAR2
110: );
131: --
132: -- {End of comments}
133: -- ----------------------------------------------------------------------------
134: PROCEDURE update_training_plan_member
135: (p_validate IN NUMBER DEFAULT hr_api.g_false_num
136: ,p_effective_date IN date
137: ,p_training_plan_member_id IN number
138: ,p_object_version_NUMBER IN OUT NOCOPY number
139: ,p_activity_version_id IN NUMBER DEFAULT hr_api.g_number
135: (p_validate IN NUMBER DEFAULT hr_api.g_false_num
136: ,p_effective_date IN date
137: ,p_training_plan_member_id IN number
138: ,p_object_version_NUMBER IN OUT NOCOPY number
139: ,p_activity_version_id IN NUMBER DEFAULT hr_api.g_number
140: ,p_activity_definition_id IN NUMBER DEFAULT hr_api.g_number
141: ,p_member_status_type_id IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
142: ,p_target_completion_date IN date DEFAULT hr_api.g_date
143: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
136: ,p_effective_date IN date
137: ,p_training_plan_member_id IN number
138: ,p_object_version_NUMBER IN OUT NOCOPY number
139: ,p_activity_version_id IN NUMBER DEFAULT hr_api.g_number
140: ,p_activity_definition_id IN NUMBER DEFAULT hr_api.g_number
141: ,p_member_status_type_id IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
142: ,p_target_completion_date IN date DEFAULT hr_api.g_date
143: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
144: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
137: ,p_training_plan_member_id IN number
138: ,p_object_version_NUMBER IN OUT NOCOPY number
139: ,p_activity_version_id IN NUMBER DEFAULT hr_api.g_number
140: ,p_activity_definition_id IN NUMBER DEFAULT hr_api.g_number
141: ,p_member_status_type_id IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
142: ,p_target_completion_date IN date DEFAULT hr_api.g_date
143: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
144: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
145: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
138: ,p_object_version_NUMBER IN OUT NOCOPY number
139: ,p_activity_version_id IN NUMBER DEFAULT hr_api.g_number
140: ,p_activity_definition_id IN NUMBER DEFAULT hr_api.g_number
141: ,p_member_status_type_id IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
142: ,p_target_completion_date IN date DEFAULT hr_api.g_date
143: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
144: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
145: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
146: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
139: ,p_activity_version_id IN NUMBER DEFAULT hr_api.g_number
140: ,p_activity_definition_id IN NUMBER DEFAULT hr_api.g_number
141: ,p_member_status_type_id IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
142: ,p_target_completion_date IN date DEFAULT hr_api.g_date
143: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
144: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
145: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
146: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
147: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
140: ,p_activity_definition_id IN NUMBER DEFAULT hr_api.g_number
141: ,p_member_status_type_id IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
142: ,p_target_completion_date IN date DEFAULT hr_api.g_date
143: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
144: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
145: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
146: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
147: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
148: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
141: ,p_member_status_type_id IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
142: ,p_target_completion_date IN date DEFAULT hr_api.g_date
143: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
144: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
145: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
146: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
147: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
148: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
149: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
142: ,p_target_completion_date IN date DEFAULT hr_api.g_date
143: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
144: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
145: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
146: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
147: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
148: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
149: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
150: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
143: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
144: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
145: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
146: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
147: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
148: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
149: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
150: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
151: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
144: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
145: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
146: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
147: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
148: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
149: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
150: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
151: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
152: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
145: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
146: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
147: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
148: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
149: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
150: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
151: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
152: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
153: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
146: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
147: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
148: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
149: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
150: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
151: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
152: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
153: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
154: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
147: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
148: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
149: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
150: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
151: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
152: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
153: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
154: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
155: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
148: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
149: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
150: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
151: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
152: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
153: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
154: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
155: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
156: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
149: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
150: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
151: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
152: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
153: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
154: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
155: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
156: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
157: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
150: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
151: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
152: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
153: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
154: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
155: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
156: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
157: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
158: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
151: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
152: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
153: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
154: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
155: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
156: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
157: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
158: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
159: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
152: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
153: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
154: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
155: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
156: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
157: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
158: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
159: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
160: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
153: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
154: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
155: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
156: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
157: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
158: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
159: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
160: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
161: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
154: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
155: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
156: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
157: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
158: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
159: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
160: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
161: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
162: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
155: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
156: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
157: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
158: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
159: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
160: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
161: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
162: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
163: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
156: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
157: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
158: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
159: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
160: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
161: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
162: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
163: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
164: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
157: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
158: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
159: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
160: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
161: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
162: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
163: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
164: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
165: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
158: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
159: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
160: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
161: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
162: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
163: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
164: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
165: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
166: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
159: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
160: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
161: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
162: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
163: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
164: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
165: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
166: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
167: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
160: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
161: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
162: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
163: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
164: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
165: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
166: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
167: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
168: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
161: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
162: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
163: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
164: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
165: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
166: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
167: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
168: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
169: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
162: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
163: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
164: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
165: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
166: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
167: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
168: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
169: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
170: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
163: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
164: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
165: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
166: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
167: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
168: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
169: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
170: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
171: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
164: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
165: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
166: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
167: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
168: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
169: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
170: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
171: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
172: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
165: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
166: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
167: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
168: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
169: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
170: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
171: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
172: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
173: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
166: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
167: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
168: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
169: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
170: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
171: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
172: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
173: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
174: ,p_assignment_id IN NUMBER DEFAULT hr_api.g_number
167: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
168: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
169: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
170: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
171: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
172: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
173: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
174: ,p_assignment_id IN NUMBER DEFAULT hr_api.g_number
175: ,p_source_id IN NUMBER DEFAULT hr_api.g_number
168: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
169: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
170: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
171: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
172: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
173: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
174: ,p_assignment_id IN NUMBER DEFAULT hr_api.g_number
175: ,p_source_id IN NUMBER DEFAULT hr_api.g_number
176: ,p_source_function IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
169: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
170: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
171: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
172: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
173: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
174: ,p_assignment_id IN NUMBER DEFAULT hr_api.g_number
175: ,p_source_id IN NUMBER DEFAULT hr_api.g_number
176: ,p_source_function IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
177: ,p_cancellation_reason IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
170: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
171: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
172: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
173: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
174: ,p_assignment_id IN NUMBER DEFAULT hr_api.g_number
175: ,p_source_id IN NUMBER DEFAULT hr_api.g_number
176: ,p_source_function IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
177: ,p_cancellation_reason IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
178: ,p_earliest_start_date IN date DEFAULT hr_api.g_date
171: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
172: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
173: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
174: ,p_assignment_id IN NUMBER DEFAULT hr_api.g_number
175: ,p_source_id IN NUMBER DEFAULT hr_api.g_number
176: ,p_source_function IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
177: ,p_cancellation_reason IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
178: ,p_earliest_start_date IN date DEFAULT hr_api.g_date
179: ,p_creator_person_id IN NUMBER DEFAULT hr_api.g_number
172: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
173: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
174: ,p_assignment_id IN NUMBER DEFAULT hr_api.g_number
175: ,p_source_id IN NUMBER DEFAULT hr_api.g_number
176: ,p_source_function IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
177: ,p_cancellation_reason IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
178: ,p_earliest_start_date IN date DEFAULT hr_api.g_date
179: ,p_creator_person_id IN NUMBER DEFAULT hr_api.g_number
180: ,p_return_status OUT NOCOPY VARCHAR2
173: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
174: ,p_assignment_id IN NUMBER DEFAULT hr_api.g_number
175: ,p_source_id IN NUMBER DEFAULT hr_api.g_number
176: ,p_source_function IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
177: ,p_cancellation_reason IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
178: ,p_earliest_start_date IN date DEFAULT hr_api.g_date
179: ,p_creator_person_id IN NUMBER DEFAULT hr_api.g_number
180: ,p_return_status OUT NOCOPY VARCHAR2
181: );
174: ,p_assignment_id IN NUMBER DEFAULT hr_api.g_number
175: ,p_source_id IN NUMBER DEFAULT hr_api.g_number
176: ,p_source_function IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
177: ,p_cancellation_reason IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
178: ,p_earliest_start_date IN date DEFAULT hr_api.g_date
179: ,p_creator_person_id IN NUMBER DEFAULT hr_api.g_number
180: ,p_return_status OUT NOCOPY VARCHAR2
181: );
182: END ota_tpm_swi;
175: ,p_source_id IN NUMBER DEFAULT hr_api.g_number
176: ,p_source_function IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
177: ,p_cancellation_reason IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
178: ,p_earliest_start_date IN date DEFAULT hr_api.g_date
179: ,p_creator_person_id IN NUMBER DEFAULT hr_api.g_number
180: ,p_return_status OUT NOCOPY VARCHAR2
181: );
182: END ota_tpm_swi;