DBA Data[Home] [Help]

APPS.OTA_TSR_UPD dependencies on HR_API

Line 120: When hr_api.check_integrity_violated Then

116: --
117: hr_utility.set_location(' Leaving:'||l_proc, 10);
118: --
119: Exception
120: When hr_api.check_integrity_violated Then
121: -- A check constraint has been violated
122: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status
123: ota_tsr_shd.constraint_error
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

120: When hr_api.check_integrity_violated Then
121: -- A check constraint has been violated
122: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status
123: ota_tsr_shd.constraint_error
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
125: When hr_api.parent_integrity_violated Then
126: -- Parent integrity has been violated
127: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status
128: ota_tsr_shd.constraint_error

Line 125: When hr_api.parent_integrity_violated Then

121: -- A check constraint has been violated
122: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status
123: ota_tsr_shd.constraint_error
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
125: When hr_api.parent_integrity_violated Then
126: -- Parent integrity has been violated
127: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status
128: ota_tsr_shd.constraint_error
129: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 129: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

125: When hr_api.parent_integrity_violated Then
126: -- Parent integrity has been violated
127: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status
128: ota_tsr_shd.constraint_error
129: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
130: When hr_api.unique_integrity_violated Then
131: -- Unique integrity has been violated
132: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status
133: ota_tsr_shd.constraint_error

Line 130: When hr_api.unique_integrity_violated Then

126: -- Parent integrity has been violated
127: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status
128: ota_tsr_shd.constraint_error
129: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
130: When hr_api.unique_integrity_violated Then
131: -- Unique integrity has been violated
132: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status
133: ota_tsr_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

130: When hr_api.unique_integrity_violated Then
131: -- Unique integrity has been violated
132: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status
133: ota_tsr_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When Others Then
136: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status
137: Raise;
138: End update_dml;

Line 281: If (p_rec.vendor_id = hr_api.g_number) then

277: -- p_rec plsql record structure
278: -- to see if a system default is being used. If a system default
279: -- is being used then we must set to the 'current' argument value.
280: --
281: If (p_rec.vendor_id = hr_api.g_number) then
282: p_rec.vendor_id :=
283: ota_tsr_shd.g_old_rec.vendor_id;
284: End If;
285: If (p_rec.business_group_id = hr_api.g_number) then

Line 285: If (p_rec.business_group_id = hr_api.g_number) then

281: If (p_rec.vendor_id = hr_api.g_number) then
282: p_rec.vendor_id :=
283: ota_tsr_shd.g_old_rec.vendor_id;
284: End If;
285: If (p_rec.business_group_id = hr_api.g_number) then
286: p_rec.business_group_id :=
287: ota_tsr_shd.g_old_rec.business_group_id;
288: End If;
289: If (p_rec.resource_definition_id = hr_api.g_number) then

Line 289: If (p_rec.resource_definition_id = hr_api.g_number) then

285: If (p_rec.business_group_id = hr_api.g_number) then
286: p_rec.business_group_id :=
287: ota_tsr_shd.g_old_rec.business_group_id;
288: End If;
289: If (p_rec.resource_definition_id = hr_api.g_number) then
290: p_rec.resource_definition_id :=
291: ota_tsr_shd.g_old_rec.resource_definition_id;
292: End If;
293: If (p_rec.consumable_flag = hr_api.g_varchar2) then

Line 293: If (p_rec.consumable_flag = hr_api.g_varchar2) then

289: If (p_rec.resource_definition_id = hr_api.g_number) then
290: p_rec.resource_definition_id :=
291: ota_tsr_shd.g_old_rec.resource_definition_id;
292: End If;
293: If (p_rec.consumable_flag = hr_api.g_varchar2) then
294: p_rec.consumable_flag :=
295: ota_tsr_shd.g_old_rec.consumable_flag;
296: End If;
297: If (p_rec.resource_type = hr_api.g_varchar2) then

Line 297: If (p_rec.resource_type = hr_api.g_varchar2) then

293: If (p_rec.consumable_flag = hr_api.g_varchar2) then
294: p_rec.consumable_flag :=
295: ota_tsr_shd.g_old_rec.consumable_flag;
296: End If;
297: If (p_rec.resource_type = hr_api.g_varchar2) then
298: p_rec.resource_type :=
299: ota_tsr_shd.g_old_rec.resource_type;
300: End If;
301: If (p_rec.start_date = hr_api.g_date) then

Line 301: If (p_rec.start_date = hr_api.g_date) then

297: If (p_rec.resource_type = hr_api.g_varchar2) then
298: p_rec.resource_type :=
299: ota_tsr_shd.g_old_rec.resource_type;
300: End If;
301: If (p_rec.start_date = hr_api.g_date) then
302: p_rec.start_date :=
303: ota_tsr_shd.g_old_rec.start_date;
304: End If;
305: If (p_rec.comments = hr_api.g_varchar2) then

Line 305: If (p_rec.comments = hr_api.g_varchar2) then

301: If (p_rec.start_date = hr_api.g_date) then
302: p_rec.start_date :=
303: ota_tsr_shd.g_old_rec.start_date;
304: End If;
305: If (p_rec.comments = hr_api.g_varchar2) then
306: p_rec.comments :=
307: ota_tsr_shd.g_old_rec.comments;
308: End If;
309: If (p_rec.cost = hr_api.g_number) then

Line 309: If (p_rec.cost = hr_api.g_number) then

305: If (p_rec.comments = hr_api.g_varchar2) then
306: p_rec.comments :=
307: ota_tsr_shd.g_old_rec.comments;
308: End If;
309: If (p_rec.cost = hr_api.g_number) then
310: p_rec.cost :=
311: ota_tsr_shd.g_old_rec.cost;
312: End If;
313: If (p_rec.cost_unit = hr_api.g_varchar2) then

Line 313: If (p_rec.cost_unit = hr_api.g_varchar2) then

309: If (p_rec.cost = hr_api.g_number) then
310: p_rec.cost :=
311: ota_tsr_shd.g_old_rec.cost;
312: End If;
313: If (p_rec.cost_unit = hr_api.g_varchar2) then
314: p_rec.cost_unit :=
315: ota_tsr_shd.g_old_rec.cost_unit;
316: End If;
317: If (p_rec.currency_code = hr_api.g_varchar2) then

Line 317: If (p_rec.currency_code = hr_api.g_varchar2) then

313: If (p_rec.cost_unit = hr_api.g_varchar2) then
314: p_rec.cost_unit :=
315: ota_tsr_shd.g_old_rec.cost_unit;
316: End If;
317: If (p_rec.currency_code = hr_api.g_varchar2) then
318: p_rec.currency_code :=
319: ota_tsr_shd.g_old_rec.currency_code;
320: End If;
321: If (p_rec.end_date = hr_api.g_date) then

Line 321: If (p_rec.end_date = hr_api.g_date) then

317: If (p_rec.currency_code = hr_api.g_varchar2) then
318: p_rec.currency_code :=
319: ota_tsr_shd.g_old_rec.currency_code;
320: End If;
321: If (p_rec.end_date = hr_api.g_date) then
322: p_rec.end_date :=
323: ota_tsr_shd.g_old_rec.end_date;
324: End If;
325: If (p_rec.internal_address_line = hr_api.g_varchar2) then

Line 325: If (p_rec.internal_address_line = hr_api.g_varchar2) then

321: If (p_rec.end_date = hr_api.g_date) then
322: p_rec.end_date :=
323: ota_tsr_shd.g_old_rec.end_date;
324: End If;
325: If (p_rec.internal_address_line = hr_api.g_varchar2) then
326: p_rec.internal_address_line :=
327: ota_tsr_shd.g_old_rec.internal_address_line;
328: End If;
329: If (p_rec.lead_time = hr_api.g_number) then

Line 329: If (p_rec.lead_time = hr_api.g_number) then

325: If (p_rec.internal_address_line = hr_api.g_varchar2) then
326: p_rec.internal_address_line :=
327: ota_tsr_shd.g_old_rec.internal_address_line;
328: End If;
329: If (p_rec.lead_time = hr_api.g_number) then
330: p_rec.lead_time :=
331: ota_tsr_shd.g_old_rec.lead_time;
332: End If;
333: If (p_rec.name = hr_api.g_varchar2) then

Line 333: If (p_rec.name = hr_api.g_varchar2) then

329: If (p_rec.lead_time = hr_api.g_number) then
330: p_rec.lead_time :=
331: ota_tsr_shd.g_old_rec.lead_time;
332: End If;
333: If (p_rec.name = hr_api.g_varchar2) then
334: p_rec.name :=
335: ota_tsr_shd.g_old_rec.name;
336: End If;
337: If (p_rec.supplier_reference = hr_api.g_varchar2) then

Line 337: If (p_rec.supplier_reference = hr_api.g_varchar2) then

333: If (p_rec.name = hr_api.g_varchar2) then
334: p_rec.name :=
335: ota_tsr_shd.g_old_rec.name;
336: End If;
337: If (p_rec.supplier_reference = hr_api.g_varchar2) then
338: p_rec.supplier_reference :=
339: ota_tsr_shd.g_old_rec.supplier_reference;
340: End If;
341: If (p_rec.tsr_information_category = hr_api.g_varchar2) then

Line 341: If (p_rec.tsr_information_category = hr_api.g_varchar2) then

337: If (p_rec.supplier_reference = hr_api.g_varchar2) then
338: p_rec.supplier_reference :=
339: ota_tsr_shd.g_old_rec.supplier_reference;
340: End If;
341: If (p_rec.tsr_information_category = hr_api.g_varchar2) then
342: p_rec.tsr_information_category :=
343: ota_tsr_shd.g_old_rec.tsr_information_category;
344: End If;
345: If (p_rec.tsr_information1 = hr_api.g_varchar2) then

Line 345: If (p_rec.tsr_information1 = hr_api.g_varchar2) then

341: If (p_rec.tsr_information_category = hr_api.g_varchar2) then
342: p_rec.tsr_information_category :=
343: ota_tsr_shd.g_old_rec.tsr_information_category;
344: End If;
345: If (p_rec.tsr_information1 = hr_api.g_varchar2) then
346: p_rec.tsr_information1 :=
347: ota_tsr_shd.g_old_rec.tsr_information1;
348: End If;
349: If (p_rec.tsr_information2 = hr_api.g_varchar2) then

Line 349: If (p_rec.tsr_information2 = hr_api.g_varchar2) then

345: If (p_rec.tsr_information1 = hr_api.g_varchar2) then
346: p_rec.tsr_information1 :=
347: ota_tsr_shd.g_old_rec.tsr_information1;
348: End If;
349: If (p_rec.tsr_information2 = hr_api.g_varchar2) then
350: p_rec.tsr_information2 :=
351: ota_tsr_shd.g_old_rec.tsr_information2;
352: End If;
353: If (p_rec.tsr_information3 = hr_api.g_varchar2) then

Line 353: If (p_rec.tsr_information3 = hr_api.g_varchar2) then

349: If (p_rec.tsr_information2 = hr_api.g_varchar2) then
350: p_rec.tsr_information2 :=
351: ota_tsr_shd.g_old_rec.tsr_information2;
352: End If;
353: If (p_rec.tsr_information3 = hr_api.g_varchar2) then
354: p_rec.tsr_information3 :=
355: ota_tsr_shd.g_old_rec.tsr_information3;
356: End If;
357: If (p_rec.tsr_information4 = hr_api.g_varchar2) then

Line 357: If (p_rec.tsr_information4 = hr_api.g_varchar2) then

353: If (p_rec.tsr_information3 = hr_api.g_varchar2) then
354: p_rec.tsr_information3 :=
355: ota_tsr_shd.g_old_rec.tsr_information3;
356: End If;
357: If (p_rec.tsr_information4 = hr_api.g_varchar2) then
358: p_rec.tsr_information4 :=
359: ota_tsr_shd.g_old_rec.tsr_information4;
360: End If;
361: If (p_rec.tsr_information5 = hr_api.g_varchar2) then

Line 361: If (p_rec.tsr_information5 = hr_api.g_varchar2) then

357: If (p_rec.tsr_information4 = hr_api.g_varchar2) then
358: p_rec.tsr_information4 :=
359: ota_tsr_shd.g_old_rec.tsr_information4;
360: End If;
361: If (p_rec.tsr_information5 = hr_api.g_varchar2) then
362: p_rec.tsr_information5 :=
363: ota_tsr_shd.g_old_rec.tsr_information5;
364: End If;
365: If (p_rec.tsr_information6 = hr_api.g_varchar2) then

Line 365: If (p_rec.tsr_information6 = hr_api.g_varchar2) then

361: If (p_rec.tsr_information5 = hr_api.g_varchar2) then
362: p_rec.tsr_information5 :=
363: ota_tsr_shd.g_old_rec.tsr_information5;
364: End If;
365: If (p_rec.tsr_information6 = hr_api.g_varchar2) then
366: p_rec.tsr_information6 :=
367: ota_tsr_shd.g_old_rec.tsr_information6;
368: End If;
369: If (p_rec.tsr_information7 = hr_api.g_varchar2) then

Line 369: If (p_rec.tsr_information7 = hr_api.g_varchar2) then

365: If (p_rec.tsr_information6 = hr_api.g_varchar2) then
366: p_rec.tsr_information6 :=
367: ota_tsr_shd.g_old_rec.tsr_information6;
368: End If;
369: If (p_rec.tsr_information7 = hr_api.g_varchar2) then
370: p_rec.tsr_information7 :=
371: ota_tsr_shd.g_old_rec.tsr_information7;
372: End If;
373: If (p_rec.tsr_information8 = hr_api.g_varchar2) then

Line 373: If (p_rec.tsr_information8 = hr_api.g_varchar2) then

369: If (p_rec.tsr_information7 = hr_api.g_varchar2) then
370: p_rec.tsr_information7 :=
371: ota_tsr_shd.g_old_rec.tsr_information7;
372: End If;
373: If (p_rec.tsr_information8 = hr_api.g_varchar2) then
374: p_rec.tsr_information8 :=
375: ota_tsr_shd.g_old_rec.tsr_information8;
376: End If;
377: If (p_rec.tsr_information9 = hr_api.g_varchar2) then

Line 377: If (p_rec.tsr_information9 = hr_api.g_varchar2) then

373: If (p_rec.tsr_information8 = hr_api.g_varchar2) then
374: p_rec.tsr_information8 :=
375: ota_tsr_shd.g_old_rec.tsr_information8;
376: End If;
377: If (p_rec.tsr_information9 = hr_api.g_varchar2) then
378: p_rec.tsr_information9 :=
379: ota_tsr_shd.g_old_rec.tsr_information9;
380: End If;
381: If (p_rec.tsr_information10 = hr_api.g_varchar2) then

Line 381: If (p_rec.tsr_information10 = hr_api.g_varchar2) then

377: If (p_rec.tsr_information9 = hr_api.g_varchar2) then
378: p_rec.tsr_information9 :=
379: ota_tsr_shd.g_old_rec.tsr_information9;
380: End If;
381: If (p_rec.tsr_information10 = hr_api.g_varchar2) then
382: p_rec.tsr_information10 :=
383: ota_tsr_shd.g_old_rec.tsr_information10;
384: End If;
385: If (p_rec.tsr_information11 = hr_api.g_varchar2) then

Line 385: If (p_rec.tsr_information11 = hr_api.g_varchar2) then

381: If (p_rec.tsr_information10 = hr_api.g_varchar2) then
382: p_rec.tsr_information10 :=
383: ota_tsr_shd.g_old_rec.tsr_information10;
384: End If;
385: If (p_rec.tsr_information11 = hr_api.g_varchar2) then
386: p_rec.tsr_information11 :=
387: ota_tsr_shd.g_old_rec.tsr_information11;
388: End If;
389: If (p_rec.tsr_information12 = hr_api.g_varchar2) then

Line 389: If (p_rec.tsr_information12 = hr_api.g_varchar2) then

385: If (p_rec.tsr_information11 = hr_api.g_varchar2) then
386: p_rec.tsr_information11 :=
387: ota_tsr_shd.g_old_rec.tsr_information11;
388: End If;
389: If (p_rec.tsr_information12 = hr_api.g_varchar2) then
390: p_rec.tsr_information12 :=
391: ota_tsr_shd.g_old_rec.tsr_information12;
392: End If;
393: If (p_rec.tsr_information13 = hr_api.g_varchar2) then

Line 393: If (p_rec.tsr_information13 = hr_api.g_varchar2) then

389: If (p_rec.tsr_information12 = hr_api.g_varchar2) then
390: p_rec.tsr_information12 :=
391: ota_tsr_shd.g_old_rec.tsr_information12;
392: End If;
393: If (p_rec.tsr_information13 = hr_api.g_varchar2) then
394: p_rec.tsr_information13 :=
395: ota_tsr_shd.g_old_rec.tsr_information13;
396: End If;
397: If (p_rec.tsr_information14 = hr_api.g_varchar2) then

Line 397: If (p_rec.tsr_information14 = hr_api.g_varchar2) then

393: If (p_rec.tsr_information13 = hr_api.g_varchar2) then
394: p_rec.tsr_information13 :=
395: ota_tsr_shd.g_old_rec.tsr_information13;
396: End If;
397: If (p_rec.tsr_information14 = hr_api.g_varchar2) then
398: p_rec.tsr_information14 :=
399: ota_tsr_shd.g_old_rec.tsr_information14;
400: End If;
401: If (p_rec.tsr_information15 = hr_api.g_varchar2) then

Line 401: If (p_rec.tsr_information15 = hr_api.g_varchar2) then

397: If (p_rec.tsr_information14 = hr_api.g_varchar2) then
398: p_rec.tsr_information14 :=
399: ota_tsr_shd.g_old_rec.tsr_information14;
400: End If;
401: If (p_rec.tsr_information15 = hr_api.g_varchar2) then
402: p_rec.tsr_information15 :=
403: ota_tsr_shd.g_old_rec.tsr_information15;
404: End If;
405: If (p_rec.tsr_information16 = hr_api.g_varchar2) then

Line 405: If (p_rec.tsr_information16 = hr_api.g_varchar2) then

401: If (p_rec.tsr_information15 = hr_api.g_varchar2) then
402: p_rec.tsr_information15 :=
403: ota_tsr_shd.g_old_rec.tsr_information15;
404: End If;
405: If (p_rec.tsr_information16 = hr_api.g_varchar2) then
406: p_rec.tsr_information16 :=
407: ota_tsr_shd.g_old_rec.tsr_information16;
408: End If;
409: If (p_rec.tsr_information17 = hr_api.g_varchar2) then

Line 409: If (p_rec.tsr_information17 = hr_api.g_varchar2) then

405: If (p_rec.tsr_information16 = hr_api.g_varchar2) then
406: p_rec.tsr_information16 :=
407: ota_tsr_shd.g_old_rec.tsr_information16;
408: End If;
409: If (p_rec.tsr_information17 = hr_api.g_varchar2) then
410: p_rec.tsr_information17 :=
411: ota_tsr_shd.g_old_rec.tsr_information17;
412: End If;
413: If (p_rec.tsr_information18 = hr_api.g_varchar2) then

Line 413: If (p_rec.tsr_information18 = hr_api.g_varchar2) then

409: If (p_rec.tsr_information17 = hr_api.g_varchar2) then
410: p_rec.tsr_information17 :=
411: ota_tsr_shd.g_old_rec.tsr_information17;
412: End If;
413: If (p_rec.tsr_information18 = hr_api.g_varchar2) then
414: p_rec.tsr_information18 :=
415: ota_tsr_shd.g_old_rec.tsr_information18;
416: End If;
417: If (p_rec.tsr_information19 = hr_api.g_varchar2) then

Line 417: If (p_rec.tsr_information19 = hr_api.g_varchar2) then

413: If (p_rec.tsr_information18 = hr_api.g_varchar2) then
414: p_rec.tsr_information18 :=
415: ota_tsr_shd.g_old_rec.tsr_information18;
416: End If;
417: If (p_rec.tsr_information19 = hr_api.g_varchar2) then
418: p_rec.tsr_information19 :=
419: ota_tsr_shd.g_old_rec.tsr_information19;
420: End If;
421: If (p_rec.tsr_information20 = hr_api.g_varchar2) then

Line 421: If (p_rec.tsr_information20 = hr_api.g_varchar2) then

417: If (p_rec.tsr_information19 = hr_api.g_varchar2) then
418: p_rec.tsr_information19 :=
419: ota_tsr_shd.g_old_rec.tsr_information19;
420: End If;
421: If (p_rec.tsr_information20 = hr_api.g_varchar2) then
422: p_rec.tsr_information20 :=
423: ota_tsr_shd.g_old_rec.tsr_information20;
424: End If;
425: If (p_rec.training_center_id = hr_api.g_number) then

Line 425: If (p_rec.training_center_id = hr_api.g_number) then

421: If (p_rec.tsr_information20 = hr_api.g_varchar2) then
422: p_rec.tsr_information20 :=
423: ota_tsr_shd.g_old_rec.tsr_information20;
424: End If;
425: If (p_rec.training_center_id = hr_api.g_number) then
426: p_rec.training_center_id :=
427: ota_tsr_shd.g_old_rec.training_center_id;
428: End If;
429: If (p_rec.location_id = hr_api.g_number) then

Line 429: If (p_rec.location_id = hr_api.g_number) then

425: If (p_rec.training_center_id = hr_api.g_number) then
426: p_rec.training_center_id :=
427: ota_tsr_shd.g_old_rec.training_center_id;
428: End If;
429: If (p_rec.location_id = hr_api.g_number) then
430: p_rec.location_id :=
431: ota_tsr_shd.g_old_rec.location_id;
432: End If;
433: If (p_rec.trainer_id = hr_api.g_number) then

Line 433: If (p_rec.trainer_id = hr_api.g_number) then

429: If (p_rec.location_id = hr_api.g_number) then
430: p_rec.location_id :=
431: ota_tsr_shd.g_old_rec.location_id;
432: End If;
433: If (p_rec.trainer_id = hr_api.g_number) then
434: p_rec.trainer_id :=
435: ota_tsr_shd.g_old_rec.trainer_id;
436: End If;
437: If (p_rec.special_instruction = hr_api.g_varchar2) then

Line 437: If (p_rec.special_instruction = hr_api.g_varchar2) then

433: If (p_rec.trainer_id = hr_api.g_number) then
434: p_rec.trainer_id :=
435: ota_tsr_shd.g_old_rec.trainer_id;
436: End If;
437: If (p_rec.special_instruction = hr_api.g_varchar2) then
438: p_rec.special_instruction :=
439: ota_tsr_shd.g_old_rec.special_instruction;
440: End If; --
441: -- Return the plsql record structure.

Line 502: Raise HR_Api.Validate_Enabled;

498: --
499: -- If we are validating then raise the Validate_Enabled exception
500: --
501: If p_validate then
502: Raise HR_Api.Validate_Enabled;
503: End If;
504: --
505: hr_utility.set_location(' Leaving:'||l_proc, 10);
506: Exception

Line 507: When HR_Api.Validate_Enabled Then

503: End If;
504: --
505: hr_utility.set_location(' Leaving:'||l_proc, 10);
506: Exception
507: When HR_Api.Validate_Enabled Then
508: --
509: -- As the Validate_Enabled exception has been raised
510: -- we must rollback to the savepoint
511: --