eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_TPS_SWI dependencies on HR_API

Line 27: (p_validate IN NUMBER DEFAULT hr_api.g_false_num

23: --
24: -- {End of comments}
25: -- ----------------------------------------------------------------------------
26: PROCEDURE create_training_plan
27: (p_validate IN NUMBER DEFAULT hr_api.g_false_num
28: ,p_effective_date IN date
29: ,p_business_group_id IN number
30: ,p_time_period_id IN NUMBER DEFAULT NULL
31: ,p_plan_status_type_id IN VARCHAR2

Line 104: (p_validate IN NUMBER DEFAULT hr_api.g_false_num

100: --
101: -- {End of comments}
102: -- ----------------------------------------------------------------------------
103: PROCEDURE delete_training_plan
104: (p_validate IN NUMBER DEFAULT hr_api.g_false_num
105: ,p_training_plan_id IN number
106: ,p_object_version_NUMBER IN number
107: ,p_return_status OUT NOCOPY VARCHAR2
108: );

Line 133: (p_validate IN NUMBER DEFAULT hr_api.g_false_num

129: --
130: -- {End of comments}
131: -- ----------------------------------------------------------------------------
132: PROCEDURE update_training_plan
133: (p_validate IN NUMBER DEFAULT hr_api.g_false_num
134: ,p_effective_date IN date
135: ,p_training_plan_id IN number
136: ,p_object_version_NUMBER IN OUT NOCOPY number
137: ,p_time_period_id IN number DEFAULT hr_api.g_number

Line 137: ,p_time_period_id IN number DEFAULT hr_api.g_number

133: (p_validate IN NUMBER DEFAULT hr_api.g_false_num
134: ,p_effective_date IN date
135: ,p_training_plan_id IN number
136: ,p_object_version_NUMBER IN OUT NOCOPY number
137: ,p_time_period_id IN number DEFAULT hr_api.g_number
138: ,p_plan_status_type_id IN VARCHAR2
139: ,p_budget_currency IN VARCHAR2 DEFAULT hr_api.g_varchar2
140: ,p_name IN VARCHAR2
141: ,p_description IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 139: ,p_budget_currency IN VARCHAR2 DEFAULT hr_api.g_varchar2

135: ,p_training_plan_id IN number
136: ,p_object_version_NUMBER IN OUT NOCOPY number
137: ,p_time_period_id IN number DEFAULT hr_api.g_number
138: ,p_plan_status_type_id IN VARCHAR2
139: ,p_budget_currency IN VARCHAR2 DEFAULT hr_api.g_varchar2
140: ,p_name IN VARCHAR2
141: ,p_description IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
142: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
143: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 141: ,p_description IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

137: ,p_time_period_id IN number DEFAULT hr_api.g_number
138: ,p_plan_status_type_id IN VARCHAR2
139: ,p_budget_currency IN VARCHAR2 DEFAULT hr_api.g_varchar2
140: ,p_name IN VARCHAR2
141: ,p_description IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
142: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
143: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
144: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
145: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 142: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

138: ,p_plan_status_type_id IN VARCHAR2
139: ,p_budget_currency IN VARCHAR2 DEFAULT hr_api.g_varchar2
140: ,p_name IN VARCHAR2
141: ,p_description IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
142: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
143: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
144: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
145: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
146: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 143: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

139: ,p_budget_currency IN VARCHAR2 DEFAULT hr_api.g_varchar2
140: ,p_name IN VARCHAR2
141: ,p_description IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
142: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
143: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
144: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
145: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
146: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
147: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 144: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

140: ,p_name IN VARCHAR2
141: ,p_description IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
142: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
143: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
144: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
145: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
146: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
147: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
148: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 145: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

141: ,p_description IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
142: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
143: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
144: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
145: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
146: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
147: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
148: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
149: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 146: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

142: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
143: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
144: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
145: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
146: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
147: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
148: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
149: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
150: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 147: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

143: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
144: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
145: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
146: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
147: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
148: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
149: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
150: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
151: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 148: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

144: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
145: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
146: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
147: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
148: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
149: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
150: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
151: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
152: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 149: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

145: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
146: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
147: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
148: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
149: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
150: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
151: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
152: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
153: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 150: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

146: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
147: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
148: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
149: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
150: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
151: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
152: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
153: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
154: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 151: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

147: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
148: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
149: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
150: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
151: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
152: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
153: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
154: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
155: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 152: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

148: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
149: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
150: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
151: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
152: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
153: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
154: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
155: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
156: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 153: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

149: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
150: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
151: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
152: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
153: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
154: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
155: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
156: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
157: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 154: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

150: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
151: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
152: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
153: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
154: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
155: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
156: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
157: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
158: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 155: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

151: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
152: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
153: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
154: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
155: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
156: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
157: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
158: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
159: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 156: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

152: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
153: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
154: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
155: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
156: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
157: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
158: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
159: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
160: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 157: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

153: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
154: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
155: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
156: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
157: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
158: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
159: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
160: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
161: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 158: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

154: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
155: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
156: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
157: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
158: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
159: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
160: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
161: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
162: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 159: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

155: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
156: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
157: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
158: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
159: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
160: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
161: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
162: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
163: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 160: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

156: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
157: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
158: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
159: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
160: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
161: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
162: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
163: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
164: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 161: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

157: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
158: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
159: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
160: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
161: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
162: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
163: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
164: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
165: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 162: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

158: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
159: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
160: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
161: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
162: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
163: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
164: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
165: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
166: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 163: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

159: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
160: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
161: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
162: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
163: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
164: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
165: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
166: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
167: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 164: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

160: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
161: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
162: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
163: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
164: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
165: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
166: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
167: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
168: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 165: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

161: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
162: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
163: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
164: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
165: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
166: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
167: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
168: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
169: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 166: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

162: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
163: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
164: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
165: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
166: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
167: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
168: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
169: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
170: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 167: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

163: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
164: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
165: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
166: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
167: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
168: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
169: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
170: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
171: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 168: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

164: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
165: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
166: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
167: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
168: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
169: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
170: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
171: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
172: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 169: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

165: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
166: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
167: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
168: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
169: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
170: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
171: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
172: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
173: ,p_plan_source IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 170: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

166: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
167: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
168: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
169: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
170: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
171: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
172: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
173: ,p_plan_source IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
174: ,p_start_date IN date DEFAULT hr_api.g_date

Line 171: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

167: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
168: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
169: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
170: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
171: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
172: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
173: ,p_plan_source IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
174: ,p_start_date IN date DEFAULT hr_api.g_date
175: ,p_end_date IN date DEFAULT hr_api.g_date

Line 172: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

168: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
169: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
170: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
171: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
172: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
173: ,p_plan_source IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
174: ,p_start_date IN date DEFAULT hr_api.g_date
175: ,p_end_date IN date DEFAULT hr_api.g_date
176: ,p_creator_person_id IN NUMBER DEFAULT hr_api.g_number

Line 173: ,p_plan_source IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

169: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
170: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
171: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
172: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
173: ,p_plan_source IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
174: ,p_start_date IN date DEFAULT hr_api.g_date
175: ,p_end_date IN date DEFAULT hr_api.g_date
176: ,p_creator_person_id IN NUMBER DEFAULT hr_api.g_number
177: ,p_additional_member_flag IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 174: ,p_start_date IN date DEFAULT hr_api.g_date

170: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
171: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
172: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
173: ,p_plan_source IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
174: ,p_start_date IN date DEFAULT hr_api.g_date
175: ,p_end_date IN date DEFAULT hr_api.g_date
176: ,p_creator_person_id IN NUMBER DEFAULT hr_api.g_number
177: ,p_additional_member_flag IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
178: ,p_learning_path_id IN NUMBER DEFAULT hr_api.g_number

Line 175: ,p_end_date IN date DEFAULT hr_api.g_date

171: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
172: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
173: ,p_plan_source IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
174: ,p_start_date IN date DEFAULT hr_api.g_date
175: ,p_end_date IN date DEFAULT hr_api.g_date
176: ,p_creator_person_id IN NUMBER DEFAULT hr_api.g_number
177: ,p_additional_member_flag IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
178: ,p_learning_path_id IN NUMBER DEFAULT hr_api.g_number
179: ,p_contact_id IN NUMBER DEFAULT hr_api.g_number

Line 176: ,p_creator_person_id IN NUMBER DEFAULT hr_api.g_number

172: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
173: ,p_plan_source IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
174: ,p_start_date IN date DEFAULT hr_api.g_date
175: ,p_end_date IN date DEFAULT hr_api.g_date
176: ,p_creator_person_id IN NUMBER DEFAULT hr_api.g_number
177: ,p_additional_member_flag IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
178: ,p_learning_path_id IN NUMBER DEFAULT hr_api.g_number
179: ,p_contact_id IN NUMBER DEFAULT hr_api.g_number
180: ,p_return_status OUT NOCOPY VARCHAR2

Line 177: ,p_additional_member_flag IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

173: ,p_plan_source IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
174: ,p_start_date IN date DEFAULT hr_api.g_date
175: ,p_end_date IN date DEFAULT hr_api.g_date
176: ,p_creator_person_id IN NUMBER DEFAULT hr_api.g_number
177: ,p_additional_member_flag IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
178: ,p_learning_path_id IN NUMBER DEFAULT hr_api.g_number
179: ,p_contact_id IN NUMBER DEFAULT hr_api.g_number
180: ,p_return_status OUT NOCOPY VARCHAR2
181: );

Line 178: ,p_learning_path_id IN NUMBER DEFAULT hr_api.g_number

174: ,p_start_date IN date DEFAULT hr_api.g_date
175: ,p_end_date IN date DEFAULT hr_api.g_date
176: ,p_creator_person_id IN NUMBER DEFAULT hr_api.g_number
177: ,p_additional_member_flag IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
178: ,p_learning_path_id IN NUMBER DEFAULT hr_api.g_number
179: ,p_contact_id IN NUMBER DEFAULT hr_api.g_number
180: ,p_return_status OUT NOCOPY VARCHAR2
181: );
182: END ota_tps_swi;

Line 179: ,p_contact_id IN NUMBER DEFAULT hr_api.g_number

175: ,p_end_date IN date DEFAULT hr_api.g_date
176: ,p_creator_person_id IN NUMBER DEFAULT hr_api.g_number
177: ,p_additional_member_flag IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
178: ,p_learning_path_id IN NUMBER DEFAULT hr_api.g_number
179: ,p_contact_id IN NUMBER DEFAULT hr_api.g_number
180: ,p_return_status OUT NOCOPY VARCHAR2
181: );
182: END ota_tps_swi;