DBA Data[Home] [Help]

APPS.OTA_TPM_SWI dependencies on HR_API

Line 28: (p_validate IN NUMBER DEFAULT hr_api.g_false_num

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

Line 106: (p_validate IN NUMBER DEFAULT hr_api.g_false_num

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: );

Line 135: (p_validate IN NUMBER DEFAULT hr_api.g_false_num

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

Line 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

Line 140: ,p_activity_definition_id IN NUMBER DEFAULT hr_api.g_number

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

Line 141: ,p_member_status_type_id 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

Line 142: ,p_target_completion_date IN date DEFAULT hr_api.g_date

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

Line 143: ,p_attribute_category 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

Line 144: ,p_attribute1 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

Line 145: ,p_attribute2 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

Line 146: ,p_attribute3 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

Line 147: ,p_attribute4 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

Line 148: ,p_attribute5 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

Line 149: ,p_attribute6 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

Line 150: ,p_attribute7 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

Line 151: ,p_attribute8 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

Line 152: ,p_attribute9 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

Line 153: ,p_attribute10 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

Line 154: ,p_attribute11 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

Line 155: ,p_attribute12 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

Line 156: ,p_attribute13 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

Line 157: ,p_attribute14 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

Line 158: ,p_attribute15 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

Line 159: ,p_attribute16 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

Line 160: ,p_attribute17 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

Line 161: ,p_attribute18 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

Line 162: ,p_attribute19 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

Line 163: ,p_attribute20 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

Line 164: ,p_attribute21 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

Line 165: ,p_attribute22 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

Line 166: ,p_attribute23 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

Line 167: ,p_attribute24 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

Line 168: ,p_attribute25 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

Line 169: ,p_attribute26 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

Line 170: ,p_attribute27 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

Line 171: ,p_attribute28 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
175: ,p_source_id IN NUMBER DEFAULT hr_api.g_number

Line 172: ,p_attribute29 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
176: ,p_source_function IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 173: ,p_attribute30 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

Line 174: ,p_assignment_id IN NUMBER DEFAULT hr_api.g_number

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

Line 175: ,p_source_id IN NUMBER DEFAULT hr_api.g_number

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

Line 176: ,p_source_function 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
180: ,p_return_status OUT NOCOPY VARCHAR2

Line 177: ,p_cancellation_reason 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
181: );

Line 178: ,p_earliest_start_date IN date DEFAULT hr_api.g_date

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;

Line 179: ,p_creator_person_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;