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_TSP_UPD dependencies on OTA_TSP_SHD

Line 54: Procedure update_dml(p_rec in out nocopy ota_tsp_shd.g_rec_type) is

50: -- Internal Development Use Only.
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml(p_rec in out nocopy ota_tsp_shd.g_rec_type) is
55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin

Line 65: ota_tsp_shd.g_api_dml := true; -- Set the api dml status

61: -- Increment the object version
62: --
63: p_rec.object_version_number := p_rec.object_version_number + 1;
64: --
65: ota_tsp_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- Update the ota_skill_provisions Row
68: --
69: update ota_skill_provisions

Line 100: ota_tsp_shd.g_api_dml := false; -- Unset the api dml status

96: tsp_information20 = p_rec.tsp_information20,
97: analysis_criteria_id = p_rec.analysis_criteria_id
98: where skill_provision_id = p_rec.skill_provision_id;
99: --
100: ota_tsp_shd.g_api_dml := false; -- Unset the api dml status
101: --
102: hr_utility.set_location(' Leaving:'||l_proc, 10);
103: --
104: Exception

Line 107: ota_tsp_shd.g_api_dml := false; -- Unset the api dml status

103: --
104: Exception
105: When hr_api.check_integrity_violated Then
106: -- A check constraint has been violated
107: ota_tsp_shd.g_api_dml := false; -- Unset the api dml status
108: ota_tsp_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When hr_api.parent_integrity_violated Then
111: -- Parent integrity has been violated

Line 108: ota_tsp_shd.constraint_error

104: Exception
105: When hr_api.check_integrity_violated Then
106: -- A check constraint has been violated
107: ota_tsp_shd.g_api_dml := false; -- Unset the api dml status
108: ota_tsp_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When hr_api.parent_integrity_violated Then
111: -- Parent integrity has been violated
112: ota_tsp_shd.g_api_dml := false; -- Unset the api dml status

Line 112: ota_tsp_shd.g_api_dml := false; -- Unset the api dml status

108: ota_tsp_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When hr_api.parent_integrity_violated Then
111: -- Parent integrity has been violated
112: ota_tsp_shd.g_api_dml := false; -- Unset the api dml status
113: ota_tsp_shd.constraint_error
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
115: When hr_api.unique_integrity_violated Then
116: -- Unique integrity has been violated

Line 113: ota_tsp_shd.constraint_error

109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When hr_api.parent_integrity_violated Then
111: -- Parent integrity has been violated
112: ota_tsp_shd.g_api_dml := false; -- Unset the api dml status
113: ota_tsp_shd.constraint_error
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
115: When hr_api.unique_integrity_violated Then
116: -- Unique integrity has been violated
117: ota_tsp_shd.g_api_dml := false; -- Unset the api dml status

Line 117: ota_tsp_shd.g_api_dml := false; -- Unset the api dml status

113: ota_tsp_shd.constraint_error
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
115: When hr_api.unique_integrity_violated Then
116: -- Unique integrity has been violated
117: ota_tsp_shd.g_api_dml := false; -- Unset the api dml status
118: ota_tsp_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When Others Then
121: ota_tsp_shd.g_api_dml := false; -- Unset the api dml status

Line 118: ota_tsp_shd.constraint_error

114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
115: When hr_api.unique_integrity_violated Then
116: -- Unique integrity has been violated
117: ota_tsp_shd.g_api_dml := false; -- Unset the api dml status
118: ota_tsp_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When Others Then
121: ota_tsp_shd.g_api_dml := false; -- Unset the api dml status
122: Raise;

Line 121: ota_tsp_shd.g_api_dml := false; -- Unset the api dml status

117: ota_tsp_shd.g_api_dml := false; -- Unset the api dml status
118: ota_tsp_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When Others Then
121: ota_tsp_shd.g_api_dml := false; -- Unset the api dml status
122: Raise;
123: End update_dml;
124: --
125: -- ----------------------------------------------------------------------------

Line 157: Procedure pre_update(p_rec in ota_tsp_shd.g_rec_type) is

153: -- Internal Development Use Only.
154: --
155: -- {End Of Comments}
156: -- ----------------------------------------------------------------------------
157: Procedure pre_update(p_rec in ota_tsp_shd.g_rec_type) is
158: --
159: l_proc varchar2(72) := g_package||'pre_update';
160: --
161: Begin

Line 199: Procedure post_update(p_rec in ota_tsp_shd.g_rec_type) is

195: -- Internal Development Use Only.
196: --
197: -- {End Of Comments}
198: -- ----------------------------------------------------------------------------
199: Procedure post_update(p_rec in ota_tsp_shd.g_rec_type) is
200: --
201: l_proc varchar2(72) := g_package||'post_update';
202: --
203: Begin

Line 252: Function convert_defs(p_rec in out nocopy ota_tsp_shd.g_rec_type)

248: -- Internal Development Use Only.
249: --
250: -- {End Of Comments}
251: -- ----------------------------------------------------------------------------
252: Function convert_defs(p_rec in out nocopy ota_tsp_shd.g_rec_type)
253: Return ota_tsp_shd.g_rec_type is
254: --
255: l_proc varchar2(72) := g_package||'convert_defs';
256: --

Line 253: Return ota_tsp_shd.g_rec_type is

249: --
250: -- {End Of Comments}
251: -- ----------------------------------------------------------------------------
252: Function convert_defs(p_rec in out nocopy ota_tsp_shd.g_rec_type)
253: Return ota_tsp_shd.g_rec_type is
254: --
255: l_proc varchar2(72) := g_package||'convert_defs';
256: --
257: Begin

Line 268: ota_tsp_shd.g_old_rec.activity_version_id;

264: -- is being used then we must set to the 'current' argument value.
265: --
266: If (p_rec.activity_version_id = hr_api.g_number) then
267: p_rec.activity_version_id :=
268: ota_tsp_shd.g_old_rec.activity_version_id;
269: End If;
270: If (p_rec.type = hr_api.g_varchar2) then
271: p_rec.type :=
272: ota_tsp_shd.g_old_rec.type;

Line 272: ota_tsp_shd.g_old_rec.type;

268: ota_tsp_shd.g_old_rec.activity_version_id;
269: End If;
270: If (p_rec.type = hr_api.g_varchar2) then
271: p_rec.type :=
272: ota_tsp_shd.g_old_rec.type;
273: End If;
274: If (p_rec.comments = hr_api.g_varchar2) then
275: p_rec.comments :=
276: ota_tsp_shd.g_old_rec.comments;

Line 276: ota_tsp_shd.g_old_rec.comments;

272: ota_tsp_shd.g_old_rec.type;
273: End If;
274: If (p_rec.comments = hr_api.g_varchar2) then
275: p_rec.comments :=
276: ota_tsp_shd.g_old_rec.comments;
277: End If;
278: If (p_rec.tsp_information_category = hr_api.g_varchar2) then
279: p_rec.tsp_information_category :=
280: ota_tsp_shd.g_old_rec.tsp_information_category;

Line 280: ota_tsp_shd.g_old_rec.tsp_information_category;

276: ota_tsp_shd.g_old_rec.comments;
277: End If;
278: If (p_rec.tsp_information_category = hr_api.g_varchar2) then
279: p_rec.tsp_information_category :=
280: ota_tsp_shd.g_old_rec.tsp_information_category;
281: End If;
282: If (p_rec.tsp_information1 = hr_api.g_varchar2) then
283: p_rec.tsp_information1 :=
284: ota_tsp_shd.g_old_rec.tsp_information1;

Line 284: ota_tsp_shd.g_old_rec.tsp_information1;

280: ota_tsp_shd.g_old_rec.tsp_information_category;
281: End If;
282: If (p_rec.tsp_information1 = hr_api.g_varchar2) then
283: p_rec.tsp_information1 :=
284: ota_tsp_shd.g_old_rec.tsp_information1;
285: End If;
286: If (p_rec.tsp_information2 = hr_api.g_varchar2) then
287: p_rec.tsp_information2 :=
288: ota_tsp_shd.g_old_rec.tsp_information2;

Line 288: ota_tsp_shd.g_old_rec.tsp_information2;

284: ota_tsp_shd.g_old_rec.tsp_information1;
285: End If;
286: If (p_rec.tsp_information2 = hr_api.g_varchar2) then
287: p_rec.tsp_information2 :=
288: ota_tsp_shd.g_old_rec.tsp_information2;
289: End If;
290: If (p_rec.tsp_information3 = hr_api.g_varchar2) then
291: p_rec.tsp_information3 :=
292: ota_tsp_shd.g_old_rec.tsp_information3;

Line 292: ota_tsp_shd.g_old_rec.tsp_information3;

288: ota_tsp_shd.g_old_rec.tsp_information2;
289: End If;
290: If (p_rec.tsp_information3 = hr_api.g_varchar2) then
291: p_rec.tsp_information3 :=
292: ota_tsp_shd.g_old_rec.tsp_information3;
293: End If;
294: If (p_rec.tsp_information4 = hr_api.g_varchar2) then
295: p_rec.tsp_information4 :=
296: ota_tsp_shd.g_old_rec.tsp_information4;

Line 296: ota_tsp_shd.g_old_rec.tsp_information4;

292: ota_tsp_shd.g_old_rec.tsp_information3;
293: End If;
294: If (p_rec.tsp_information4 = hr_api.g_varchar2) then
295: p_rec.tsp_information4 :=
296: ota_tsp_shd.g_old_rec.tsp_information4;
297: End If;
298: If (p_rec.tsp_information5 = hr_api.g_varchar2) then
299: p_rec.tsp_information5 :=
300: ota_tsp_shd.g_old_rec.tsp_information5;

Line 300: ota_tsp_shd.g_old_rec.tsp_information5;

296: ota_tsp_shd.g_old_rec.tsp_information4;
297: End If;
298: If (p_rec.tsp_information5 = hr_api.g_varchar2) then
299: p_rec.tsp_information5 :=
300: ota_tsp_shd.g_old_rec.tsp_information5;
301: End If;
302: If (p_rec.tsp_information6 = hr_api.g_varchar2) then
303: p_rec.tsp_information6 :=
304: ota_tsp_shd.g_old_rec.tsp_information6;

Line 304: ota_tsp_shd.g_old_rec.tsp_information6;

300: ota_tsp_shd.g_old_rec.tsp_information5;
301: End If;
302: If (p_rec.tsp_information6 = hr_api.g_varchar2) then
303: p_rec.tsp_information6 :=
304: ota_tsp_shd.g_old_rec.tsp_information6;
305: End If;
306: If (p_rec.tsp_information7 = hr_api.g_varchar2) then
307: p_rec.tsp_information7 :=
308: ota_tsp_shd.g_old_rec.tsp_information7;

Line 308: ota_tsp_shd.g_old_rec.tsp_information7;

304: ota_tsp_shd.g_old_rec.tsp_information6;
305: End If;
306: If (p_rec.tsp_information7 = hr_api.g_varchar2) then
307: p_rec.tsp_information7 :=
308: ota_tsp_shd.g_old_rec.tsp_information7;
309: End If;
310: If (p_rec.tsp_information8 = hr_api.g_varchar2) then
311: p_rec.tsp_information8 :=
312: ota_tsp_shd.g_old_rec.tsp_information8;

Line 312: ota_tsp_shd.g_old_rec.tsp_information8;

308: ota_tsp_shd.g_old_rec.tsp_information7;
309: End If;
310: If (p_rec.tsp_information8 = hr_api.g_varchar2) then
311: p_rec.tsp_information8 :=
312: ota_tsp_shd.g_old_rec.tsp_information8;
313: End If;
314: If (p_rec.tsp_information9 = hr_api.g_varchar2) then
315: p_rec.tsp_information9 :=
316: ota_tsp_shd.g_old_rec.tsp_information9;

Line 316: ota_tsp_shd.g_old_rec.tsp_information9;

312: ota_tsp_shd.g_old_rec.tsp_information8;
313: End If;
314: If (p_rec.tsp_information9 = hr_api.g_varchar2) then
315: p_rec.tsp_information9 :=
316: ota_tsp_shd.g_old_rec.tsp_information9;
317: End If;
318: If (p_rec.tsp_information10 = hr_api.g_varchar2) then
319: p_rec.tsp_information10 :=
320: ota_tsp_shd.g_old_rec.tsp_information10;

Line 320: ota_tsp_shd.g_old_rec.tsp_information10;

316: ota_tsp_shd.g_old_rec.tsp_information9;
317: End If;
318: If (p_rec.tsp_information10 = hr_api.g_varchar2) then
319: p_rec.tsp_information10 :=
320: ota_tsp_shd.g_old_rec.tsp_information10;
321: End If;
322: If (p_rec.tsp_information11 = hr_api.g_varchar2) then
323: p_rec.tsp_information11 :=
324: ota_tsp_shd.g_old_rec.tsp_information11;

Line 324: ota_tsp_shd.g_old_rec.tsp_information11;

320: ota_tsp_shd.g_old_rec.tsp_information10;
321: End If;
322: If (p_rec.tsp_information11 = hr_api.g_varchar2) then
323: p_rec.tsp_information11 :=
324: ota_tsp_shd.g_old_rec.tsp_information11;
325: End If;
326: If (p_rec.tsp_information12 = hr_api.g_varchar2) then
327: p_rec.tsp_information12 :=
328: ota_tsp_shd.g_old_rec.tsp_information12;

Line 328: ota_tsp_shd.g_old_rec.tsp_information12;

324: ota_tsp_shd.g_old_rec.tsp_information11;
325: End If;
326: If (p_rec.tsp_information12 = hr_api.g_varchar2) then
327: p_rec.tsp_information12 :=
328: ota_tsp_shd.g_old_rec.tsp_information12;
329: End If;
330: If (p_rec.tsp_information13 = hr_api.g_varchar2) then
331: p_rec.tsp_information13 :=
332: ota_tsp_shd.g_old_rec.tsp_information13;

Line 332: ota_tsp_shd.g_old_rec.tsp_information13;

328: ota_tsp_shd.g_old_rec.tsp_information12;
329: End If;
330: If (p_rec.tsp_information13 = hr_api.g_varchar2) then
331: p_rec.tsp_information13 :=
332: ota_tsp_shd.g_old_rec.tsp_information13;
333: End If;
334: If (p_rec.tsp_information14 = hr_api.g_varchar2) then
335: p_rec.tsp_information14 :=
336: ota_tsp_shd.g_old_rec.tsp_information14;

Line 336: ota_tsp_shd.g_old_rec.tsp_information14;

332: ota_tsp_shd.g_old_rec.tsp_information13;
333: End If;
334: If (p_rec.tsp_information14 = hr_api.g_varchar2) then
335: p_rec.tsp_information14 :=
336: ota_tsp_shd.g_old_rec.tsp_information14;
337: End If;
338: If (p_rec.tsp_information15 = hr_api.g_varchar2) then
339: p_rec.tsp_information15 :=
340: ota_tsp_shd.g_old_rec.tsp_information15;

Line 340: ota_tsp_shd.g_old_rec.tsp_information15;

336: ota_tsp_shd.g_old_rec.tsp_information14;
337: End If;
338: If (p_rec.tsp_information15 = hr_api.g_varchar2) then
339: p_rec.tsp_information15 :=
340: ota_tsp_shd.g_old_rec.tsp_information15;
341: End If;
342: If (p_rec.tsp_information16 = hr_api.g_varchar2) then
343: p_rec.tsp_information16 :=
344: ota_tsp_shd.g_old_rec.tsp_information16;

Line 344: ota_tsp_shd.g_old_rec.tsp_information16;

340: ota_tsp_shd.g_old_rec.tsp_information15;
341: End If;
342: If (p_rec.tsp_information16 = hr_api.g_varchar2) then
343: p_rec.tsp_information16 :=
344: ota_tsp_shd.g_old_rec.tsp_information16;
345: End If;
346: If (p_rec.tsp_information17 = hr_api.g_varchar2) then
347: p_rec.tsp_information17 :=
348: ota_tsp_shd.g_old_rec.tsp_information17;

Line 348: ota_tsp_shd.g_old_rec.tsp_information17;

344: ota_tsp_shd.g_old_rec.tsp_information16;
345: End If;
346: If (p_rec.tsp_information17 = hr_api.g_varchar2) then
347: p_rec.tsp_information17 :=
348: ota_tsp_shd.g_old_rec.tsp_information17;
349: End If;
350: If (p_rec.tsp_information18 = hr_api.g_varchar2) then
351: p_rec.tsp_information18 :=
352: ota_tsp_shd.g_old_rec.tsp_information18;

Line 352: ota_tsp_shd.g_old_rec.tsp_information18;

348: ota_tsp_shd.g_old_rec.tsp_information17;
349: End If;
350: If (p_rec.tsp_information18 = hr_api.g_varchar2) then
351: p_rec.tsp_information18 :=
352: ota_tsp_shd.g_old_rec.tsp_information18;
353: End If;
354: If (p_rec.tsp_information19 = hr_api.g_varchar2) then
355: p_rec.tsp_information19 :=
356: ota_tsp_shd.g_old_rec.tsp_information19;

Line 356: ota_tsp_shd.g_old_rec.tsp_information19;

352: ota_tsp_shd.g_old_rec.tsp_information18;
353: End If;
354: If (p_rec.tsp_information19 = hr_api.g_varchar2) then
355: p_rec.tsp_information19 :=
356: ota_tsp_shd.g_old_rec.tsp_information19;
357: End If;
358: If (p_rec.tsp_information20 = hr_api.g_varchar2) then
359: p_rec.tsp_information20 :=
360: ota_tsp_shd.g_old_rec.tsp_information20;

Line 360: ota_tsp_shd.g_old_rec.tsp_information20;

356: ota_tsp_shd.g_old_rec.tsp_information19;
357: End If;
358: If (p_rec.tsp_information20 = hr_api.g_varchar2) then
359: p_rec.tsp_information20 :=
360: ota_tsp_shd.g_old_rec.tsp_information20;
361: End If;
362: If (p_rec.analysis_criteria_id = hr_api.g_number) then
363: p_rec.analysis_criteria_id :=
364: ota_tsp_shd.g_old_rec.analysis_criteria_id;

Line 364: ota_tsp_shd.g_old_rec.analysis_criteria_id;

360: ota_tsp_shd.g_old_rec.tsp_information20;
361: End If;
362: If (p_rec.analysis_criteria_id = hr_api.g_number) then
363: p_rec.analysis_criteria_id :=
364: ota_tsp_shd.g_old_rec.analysis_criteria_id;
365: End If;
366: --
367: -- Return the plsql record structure.
368: --

Line 379: p_rec in out nocopy ota_tsp_shd.g_rec_type,

375: -- |---------------------------------< upd >----------------------------------|
376: -- ----------------------------------------------------------------------------
377: Procedure upd
378: (
379: p_rec in out nocopy ota_tsp_shd.g_rec_type,
380: p_validate in boolean default false
381: ) is
382: --
383: l_proc varchar2(72) := g_package||'upd';

Line 399: ota_tsp_shd.lck

395: End If;
396: --
397: -- We must lock the row which we need to update.
398: --
399: ota_tsp_shd.lck
400: (
401: p_rec.skill_provision_id,
402: p_rec.object_version_number
403: );

Line 476: l_rec ota_tsp_shd.g_rec_type;

472: p_analysis_criteria_id in number default hr_api.g_number,
473: p_validate in boolean default false
474: ) is
475: --
476: l_rec ota_tsp_shd.g_rec_type;
477: l_proc varchar2(72) := g_package||'upd';
478: --
479: Begin
480: hr_utility.set_location('Entering:'||l_proc, 5);

Line 486: ota_tsp_shd.convert_args

482: -- Call conversion function to turn arguments into the
483: -- l_rec structure.
484: --
485: l_rec :=
486: ota_tsp_shd.convert_args
487: (
488: p_skill_provision_id,
489: p_activity_version_id,
490: p_object_version_number,