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_TSR_UPD dependencies on OTA_TSR_SHD

Line 54: Procedure update_dml(p_rec in out nocopy ota_tsr_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_tsr_shd.g_rec_type) is
55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin

Line 65: ota_tsr_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_tsr_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- Update the ota_suppliable_resources Row
68: --
69: update ota_suppliable_resources

Line 115: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status

111: trainer_id = p_rec.trainer_id,
112: special_instruction = p_rec.special_instruction
113: where supplied_resource_id = p_rec.supplied_resource_id;
114: --
115: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status
116: --
117: hr_utility.set_location(' Leaving:'||l_proc, 10);
118: --
119: Exception

Line 122: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status

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));
125: When hr_api.parent_integrity_violated Then
126: -- Parent integrity has been violated

Line 123: ota_tsr_shd.constraint_error

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

Line 127: 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));
130: When hr_api.unique_integrity_violated Then
131: -- Unique integrity has been violated

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

Line 132: 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));
135: When Others Then
136: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status

Line 133: 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));
135: When Others Then
136: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status
137: Raise;

Line 136: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status

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;
139: --
140: -- ----------------------------------------------------------------------------

Line 172: Procedure pre_update(p_rec in ota_tsr_shd.g_rec_type) is

168: -- Internal Development Use Only.
169: --
170: -- {End Of Comments}
171: -- ----------------------------------------------------------------------------
172: Procedure pre_update(p_rec in ota_tsr_shd.g_rec_type) is
173: --
174: l_proc varchar2(72) := g_package||'pre_update';
175: --
176: Begin

Line 214: Procedure post_update(p_rec in ota_tsr_shd.g_rec_type) is

210: -- Internal Development Use Only.
211: --
212: -- {End Of Comments}
213: -- ----------------------------------------------------------------------------
214: Procedure post_update(p_rec in ota_tsr_shd.g_rec_type) is
215: --
216: l_proc varchar2(72) := g_package||'post_update';
217: --
218: Begin

Line 267: Function convert_defs(p_rec in out nocopy ota_tsr_shd.g_rec_type)

263: -- Internal Development Use Only.
264: --
265: -- {End Of Comments}
266: -- ----------------------------------------------------------------------------
267: Function convert_defs(p_rec in out nocopy ota_tsr_shd.g_rec_type)
268: Return ota_tsr_shd.g_rec_type is
269: --
270: l_proc varchar2(72) := g_package||'convert_defs';
271: --

Line 268: Return ota_tsr_shd.g_rec_type is

264: --
265: -- {End Of Comments}
266: -- ----------------------------------------------------------------------------
267: Function convert_defs(p_rec in out nocopy ota_tsr_shd.g_rec_type)
268: Return ota_tsr_shd.g_rec_type is
269: --
270: l_proc varchar2(72) := g_package||'convert_defs';
271: --
272: Begin

Line 283: ota_tsr_shd.g_old_rec.vendor_id;

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
286: p_rec.business_group_id :=
287: ota_tsr_shd.g_old_rec.business_group_id;

Line 287: ota_tsr_shd.g_old_rec.business_group_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
290: p_rec.resource_definition_id :=
291: ota_tsr_shd.g_old_rec.resource_definition_id;

Line 291: ota_tsr_shd.g_old_rec.resource_definition_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
294: p_rec.consumable_flag :=
295: ota_tsr_shd.g_old_rec.consumable_flag;

Line 295: ota_tsr_shd.g_old_rec.consumable_flag;

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
298: p_rec.resource_type :=
299: ota_tsr_shd.g_old_rec.resource_type;

Line 299: ota_tsr_shd.g_old_rec.resource_type;

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
302: p_rec.start_date :=
303: ota_tsr_shd.g_old_rec.start_date;

Line 303: ota_tsr_shd.g_old_rec.start_date;

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
306: p_rec.comments :=
307: ota_tsr_shd.g_old_rec.comments;

Line 307: ota_tsr_shd.g_old_rec.comments;

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
310: p_rec.cost :=
311: ota_tsr_shd.g_old_rec.cost;

Line 311: ota_tsr_shd.g_old_rec.cost;

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
314: p_rec.cost_unit :=
315: ota_tsr_shd.g_old_rec.cost_unit;

Line 315: ota_tsr_shd.g_old_rec.cost_unit;

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
318: p_rec.currency_code :=
319: ota_tsr_shd.g_old_rec.currency_code;

Line 319: ota_tsr_shd.g_old_rec.currency_code;

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
322: p_rec.end_date :=
323: ota_tsr_shd.g_old_rec.end_date;

Line 323: ota_tsr_shd.g_old_rec.end_date;

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
326: p_rec.internal_address_line :=
327: ota_tsr_shd.g_old_rec.internal_address_line;

Line 327: ota_tsr_shd.g_old_rec.internal_address_line;

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
330: p_rec.lead_time :=
331: ota_tsr_shd.g_old_rec.lead_time;

Line 331: ota_tsr_shd.g_old_rec.lead_time;

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
334: p_rec.name :=
335: ota_tsr_shd.g_old_rec.name;

Line 335: ota_tsr_shd.g_old_rec.name;

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
338: p_rec.supplier_reference :=
339: ota_tsr_shd.g_old_rec.supplier_reference;

Line 339: ota_tsr_shd.g_old_rec.supplier_reference;

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
342: p_rec.tsr_information_category :=
343: ota_tsr_shd.g_old_rec.tsr_information_category;

Line 343: ota_tsr_shd.g_old_rec.tsr_information_category;

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
346: p_rec.tsr_information1 :=
347: ota_tsr_shd.g_old_rec.tsr_information1;

Line 347: ota_tsr_shd.g_old_rec.tsr_information1;

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
350: p_rec.tsr_information2 :=
351: ota_tsr_shd.g_old_rec.tsr_information2;

Line 351: ota_tsr_shd.g_old_rec.tsr_information2;

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
354: p_rec.tsr_information3 :=
355: ota_tsr_shd.g_old_rec.tsr_information3;

Line 355: ota_tsr_shd.g_old_rec.tsr_information3;

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
358: p_rec.tsr_information4 :=
359: ota_tsr_shd.g_old_rec.tsr_information4;

Line 359: ota_tsr_shd.g_old_rec.tsr_information4;

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
362: p_rec.tsr_information5 :=
363: ota_tsr_shd.g_old_rec.tsr_information5;

Line 363: ota_tsr_shd.g_old_rec.tsr_information5;

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
366: p_rec.tsr_information6 :=
367: ota_tsr_shd.g_old_rec.tsr_information6;

Line 367: ota_tsr_shd.g_old_rec.tsr_information6;

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
370: p_rec.tsr_information7 :=
371: ota_tsr_shd.g_old_rec.tsr_information7;

Line 371: ota_tsr_shd.g_old_rec.tsr_information7;

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
374: p_rec.tsr_information8 :=
375: ota_tsr_shd.g_old_rec.tsr_information8;

Line 375: ota_tsr_shd.g_old_rec.tsr_information8;

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
378: p_rec.tsr_information9 :=
379: ota_tsr_shd.g_old_rec.tsr_information9;

Line 379: ota_tsr_shd.g_old_rec.tsr_information9;

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
382: p_rec.tsr_information10 :=
383: ota_tsr_shd.g_old_rec.tsr_information10;

Line 383: ota_tsr_shd.g_old_rec.tsr_information10;

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
386: p_rec.tsr_information11 :=
387: ota_tsr_shd.g_old_rec.tsr_information11;

Line 387: ota_tsr_shd.g_old_rec.tsr_information11;

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
390: p_rec.tsr_information12 :=
391: ota_tsr_shd.g_old_rec.tsr_information12;

Line 391: ota_tsr_shd.g_old_rec.tsr_information12;

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
394: p_rec.tsr_information13 :=
395: ota_tsr_shd.g_old_rec.tsr_information13;

Line 395: ota_tsr_shd.g_old_rec.tsr_information13;

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
398: p_rec.tsr_information14 :=
399: ota_tsr_shd.g_old_rec.tsr_information14;

Line 399: ota_tsr_shd.g_old_rec.tsr_information14;

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
402: p_rec.tsr_information15 :=
403: ota_tsr_shd.g_old_rec.tsr_information15;

Line 403: ota_tsr_shd.g_old_rec.tsr_information15;

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
406: p_rec.tsr_information16 :=
407: ota_tsr_shd.g_old_rec.tsr_information16;

Line 407: ota_tsr_shd.g_old_rec.tsr_information16;

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
410: p_rec.tsr_information17 :=
411: ota_tsr_shd.g_old_rec.tsr_information17;

Line 411: ota_tsr_shd.g_old_rec.tsr_information17;

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
414: p_rec.tsr_information18 :=
415: ota_tsr_shd.g_old_rec.tsr_information18;

Line 415: ota_tsr_shd.g_old_rec.tsr_information18;

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
418: p_rec.tsr_information19 :=
419: ota_tsr_shd.g_old_rec.tsr_information19;

Line 419: ota_tsr_shd.g_old_rec.tsr_information19;

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
422: p_rec.tsr_information20 :=
423: ota_tsr_shd.g_old_rec.tsr_information20;

Line 423: ota_tsr_shd.g_old_rec.tsr_information20;

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
426: p_rec.training_center_id :=
427: ota_tsr_shd.g_old_rec.training_center_id;

Line 427: ota_tsr_shd.g_old_rec.training_center_id;

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
430: p_rec.location_id :=
431: ota_tsr_shd.g_old_rec.location_id;

Line 431: ota_tsr_shd.g_old_rec.location_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
434: p_rec.trainer_id :=
435: ota_tsr_shd.g_old_rec.trainer_id;

Line 435: ota_tsr_shd.g_old_rec.trainer_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
438: p_rec.special_instruction :=
439: ota_tsr_shd.g_old_rec.special_instruction;

Line 439: ota_tsr_shd.g_old_rec.special_instruction;

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.
442: --
443: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 453: p_rec in out nocopy ota_tsr_shd.g_rec_type,

449: -- |---------------------------------< upd >----------------------------------|
450: -- ----------------------------------------------------------------------------
451: Procedure upd
452: (
453: p_rec in out nocopy ota_tsr_shd.g_rec_type,
454: p_validate in boolean
455: ) is
456: --
457: l_proc varchar2(72) := g_package||'upd';

Line 473: ota_tsr_shd.lck

469: End If;
470: --
471: -- We must lock the row which we need to update.
472: --
473: ota_tsr_shd.lck
474: (
475: p_rec.supplied_resource_id,
476: p_rec.object_version_number
477: );

Line 565: l_rec ota_tsr_shd.g_rec_type;

561: p_special_instruction in varchar2,
562: p_validate in boolean
563: ) is
564: --
565: l_rec ota_tsr_shd.g_rec_type;
566: l_proc varchar2(72) := g_package||'upd';
567: --
568: Begin
569: hr_utility.set_location('Entering:'||l_proc, 5);

Line 575: ota_tsr_shd.convert_args

571: -- Call conversion function to turn arguments into the
572: -- l_rec structure.
573: --
574: l_rec :=
575: ota_tsr_shd.convert_args
576: (
577: p_supplied_resource_id,
578: p_vendor_id,
579: p_business_group_id,