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_TFL_API_UPD dependencies on OTA_TFL_API_SHD

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

Line 66: ota_tfl_api_shd.g_api_dml := true; -- Set the api dml status

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

Line 135: ota_tfl_api_shd.g_api_dml := false; -- Unset the api dml status

131: tfl_information19 = p_rec.tfl_information19,
132: tfl_information20 = p_rec.tfl_information20
133: where finance_line_id = p_rec.finance_line_id;
134: --
135: ota_tfl_api_shd.g_api_dml := false; -- Unset the api dml status
136: --
137: hr_utility.set_location(' Leaving:'||l_proc, 10);
138: --
139: Exception

Line 142: ota_tfl_api_shd.g_api_dml := false; -- Unset the api dml status

138: --
139: Exception
140: When hr_api.check_integrity_violated Then
141: -- A check constraint has been violated
142: ota_tfl_api_shd.g_api_dml := false; -- Unset the api dml status
143: ota_tfl_api_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: When hr_api.parent_integrity_violated Then
146: -- Parent integrity has been violated

Line 143: ota_tfl_api_shd.constraint_error

139: Exception
140: When hr_api.check_integrity_violated Then
141: -- A check constraint has been violated
142: ota_tfl_api_shd.g_api_dml := false; -- Unset the api dml status
143: ota_tfl_api_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: When hr_api.parent_integrity_violated Then
146: -- Parent integrity has been violated
147: ota_tfl_api_shd.g_api_dml := false; -- Unset the api dml status

Line 147: ota_tfl_api_shd.g_api_dml := false; -- Unset the api dml status

143: ota_tfl_api_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: When hr_api.parent_integrity_violated Then
146: -- Parent integrity has been violated
147: ota_tfl_api_shd.g_api_dml := false; -- Unset the api dml status
148: ota_tfl_api_shd.constraint_error
149: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
150: When hr_api.unique_integrity_violated Then
151: -- Unique integrity has been violated

Line 148: ota_tfl_api_shd.constraint_error

144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: When hr_api.parent_integrity_violated Then
146: -- Parent integrity has been violated
147: ota_tfl_api_shd.g_api_dml := false; -- Unset the api dml status
148: ota_tfl_api_shd.constraint_error
149: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
150: When hr_api.unique_integrity_violated Then
151: -- Unique integrity has been violated
152: ota_tfl_api_shd.g_api_dml := false; -- Unset the api dml status

Line 152: ota_tfl_api_shd.g_api_dml := false; -- Unset the api dml status

148: ota_tfl_api_shd.constraint_error
149: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
150: When hr_api.unique_integrity_violated Then
151: -- Unique integrity has been violated
152: ota_tfl_api_shd.g_api_dml := false; -- Unset the api dml status
153: ota_tfl_api_shd.constraint_error
154: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
155: When Others Then
156: ota_tfl_api_shd.g_api_dml := false; -- Unset the api dml status

Line 153: ota_tfl_api_shd.constraint_error

149: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
150: When hr_api.unique_integrity_violated Then
151: -- Unique integrity has been violated
152: ota_tfl_api_shd.g_api_dml := false; -- Unset the api dml status
153: ota_tfl_api_shd.constraint_error
154: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
155: When Others Then
156: ota_tfl_api_shd.g_api_dml := false; -- Unset the api dml status
157: Raise;

Line 156: ota_tfl_api_shd.g_api_dml := false; -- Unset the api dml status

152: ota_tfl_api_shd.g_api_dml := false; -- Unset the api dml status
153: ota_tfl_api_shd.constraint_error
154: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
155: When Others Then
156: ota_tfl_api_shd.g_api_dml := false; -- Unset the api dml status
157: Raise;
158: End update_dml;
159: --
160: -- ----------------------------------------------------------------------------

Line 192: Procedure pre_update(p_rec in out nocopy ota_tfl_api_shd.g_rec_type) is

188: -- Internal Development Use Only.
189: --
190: -- {End Of Comments}
191: -- ----------------------------------------------------------------------------
192: Procedure pre_update(p_rec in out nocopy ota_tfl_api_shd.g_rec_type) is
193: --
194: l_proc varchar2(72) := g_package||'pre_update';
195: --
196: Begin

Line 234: Procedure post_update(p_rec in ota_tfl_api_shd.g_rec_type) is

230: -- Internal Development Use Only.
231: --
232: -- {End Of Comments}
233: -- ----------------------------------------------------------------------------
234: Procedure post_update(p_rec in ota_tfl_api_shd.g_rec_type) is
235: --
236: l_proc varchar2(72) := g_package||'post_update';
237: --
238: Begin

Line 287: Function convert_defs(p_rec in out nocopy ota_tfl_api_shd.g_rec_type)

283: -- Internal Development Use Only.
284: --
285: -- {End Of Comments}
286: -- ----------------------------------------------------------------------------
287: Function convert_defs(p_rec in out nocopy ota_tfl_api_shd.g_rec_type)
288: Return ota_tfl_api_shd.g_rec_type is
289: --
290: l_proc varchar2(72) := g_package||'convert_defs';
291: --

Line 288: Return ota_tfl_api_shd.g_rec_type is

284: --
285: -- {End Of Comments}
286: -- ----------------------------------------------------------------------------
287: Function convert_defs(p_rec in out nocopy ota_tfl_api_shd.g_rec_type)
288: Return ota_tfl_api_shd.g_rec_type is
289: --
290: l_proc varchar2(72) := g_package||'convert_defs';
291: --
292: Begin

Line 303: ota_tfl_api_shd.g_old_rec.finance_header_id;

299: -- is being used then we must set to the 'current' argument value.
300: --
301: If (p_rec.finance_header_id = hr_api.g_number) then
302: p_rec.finance_header_id :=
303: ota_tfl_api_shd.g_old_rec.finance_header_id;
304: End If;
305: If (p_rec.cancelled_flag = hr_api.g_varchar2) then
306: p_rec.cancelled_flag :=
307: ota_tfl_api_shd.g_old_rec.cancelled_flag;

Line 307: ota_tfl_api_shd.g_old_rec.cancelled_flag;

303: ota_tfl_api_shd.g_old_rec.finance_header_id;
304: End If;
305: If (p_rec.cancelled_flag = hr_api.g_varchar2) then
306: p_rec.cancelled_flag :=
307: ota_tfl_api_shd.g_old_rec.cancelled_flag;
308: End If;
309: If (p_rec.date_raised = hr_api.g_date) then
310: p_rec.date_raised :=
311: ota_tfl_api_shd.g_old_rec.date_raised;

Line 311: ota_tfl_api_shd.g_old_rec.date_raised;

307: ota_tfl_api_shd.g_old_rec.cancelled_flag;
308: End If;
309: If (p_rec.date_raised = hr_api.g_date) then
310: p_rec.date_raised :=
311: ota_tfl_api_shd.g_old_rec.date_raised;
312: End If;
313: If (p_rec.line_type = hr_api.g_varchar2) then
314: p_rec.line_type :=
315: ota_tfl_api_shd.g_old_rec.line_type;

Line 315: ota_tfl_api_shd.g_old_rec.line_type;

311: ota_tfl_api_shd.g_old_rec.date_raised;
312: End If;
313: If (p_rec.line_type = hr_api.g_varchar2) then
314: p_rec.line_type :=
315: ota_tfl_api_shd.g_old_rec.line_type;
316: End If;
317: If (p_rec.sequence_number = hr_api.g_number) then
318: p_rec.sequence_number :=
319: ota_tfl_api_shd.g_old_rec.sequence_number;

Line 319: ota_tfl_api_shd.g_old_rec.sequence_number;

315: ota_tfl_api_shd.g_old_rec.line_type;
316: End If;
317: If (p_rec.sequence_number = hr_api.g_number) then
318: p_rec.sequence_number :=
319: ota_tfl_api_shd.g_old_rec.sequence_number;
320: End If;
321: If (p_rec.transfer_status = hr_api.g_varchar2) then
322: p_rec.transfer_status :=
323: ota_tfl_api_shd.g_old_rec.transfer_status;

Line 323: ota_tfl_api_shd.g_old_rec.transfer_status;

319: ota_tfl_api_shd.g_old_rec.sequence_number;
320: End If;
321: If (p_rec.transfer_status = hr_api.g_varchar2) then
322: p_rec.transfer_status :=
323: ota_tfl_api_shd.g_old_rec.transfer_status;
324: End If;
325: If (p_rec.comments = hr_api.g_varchar2) then
326: p_rec.comments :=
327: ota_tfl_api_shd.g_old_rec.comments;

Line 327: ota_tfl_api_shd.g_old_rec.comments;

323: ota_tfl_api_shd.g_old_rec.transfer_status;
324: End If;
325: If (p_rec.comments = hr_api.g_varchar2) then
326: p_rec.comments :=
327: ota_tfl_api_shd.g_old_rec.comments;
328: End If;
329: If (p_rec.currency_code = hr_api.g_varchar2) then
330: p_rec.currency_code :=
331: ota_tfl_api_shd.g_old_rec.currency_code;

Line 331: ota_tfl_api_shd.g_old_rec.currency_code;

327: ota_tfl_api_shd.g_old_rec.comments;
328: End If;
329: If (p_rec.currency_code = hr_api.g_varchar2) then
330: p_rec.currency_code :=
331: ota_tfl_api_shd.g_old_rec.currency_code;
332: End If;
333: If (p_rec.money_amount = hr_api.g_number) then
334: p_rec.money_amount :=
335: ota_tfl_api_shd.g_old_rec.money_amount;

Line 335: ota_tfl_api_shd.g_old_rec.money_amount;

331: ota_tfl_api_shd.g_old_rec.currency_code;
332: End If;
333: If (p_rec.money_amount = hr_api.g_number) then
334: p_rec.money_amount :=
335: ota_tfl_api_shd.g_old_rec.money_amount;
336: End If;
337: If (p_rec.standard_amount = hr_api.g_number) then
338: p_rec.standard_amount :=
339: ota_tfl_api_shd.g_old_rec.standard_amount;

Line 339: ota_tfl_api_shd.g_old_rec.standard_amount;

335: ota_tfl_api_shd.g_old_rec.money_amount;
336: End If;
337: If (p_rec.standard_amount = hr_api.g_number) then
338: p_rec.standard_amount :=
339: ota_tfl_api_shd.g_old_rec.standard_amount;
340: End If;
341: If (p_rec.trans_information_category = hr_api.g_varchar2) then
342: p_rec.trans_information_category :=
343: ota_tfl_api_shd.g_old_rec.trans_information_category;

Line 343: ota_tfl_api_shd.g_old_rec.trans_information_category;

339: ota_tfl_api_shd.g_old_rec.standard_amount;
340: End If;
341: If (p_rec.trans_information_category = hr_api.g_varchar2) then
342: p_rec.trans_information_category :=
343: ota_tfl_api_shd.g_old_rec.trans_information_category;
344: End If;
345: If (p_rec.trans_information1 = hr_api.g_varchar2) then
346: p_rec.trans_information1 :=
347: ota_tfl_api_shd.g_old_rec.trans_information1;

Line 347: ota_tfl_api_shd.g_old_rec.trans_information1;

343: ota_tfl_api_shd.g_old_rec.trans_information_category;
344: End If;
345: If (p_rec.trans_information1 = hr_api.g_varchar2) then
346: p_rec.trans_information1 :=
347: ota_tfl_api_shd.g_old_rec.trans_information1;
348: End If;
349: If (p_rec.trans_information10 = hr_api.g_varchar2) then
350: p_rec.trans_information10 :=
351: ota_tfl_api_shd.g_old_rec.trans_information10;

Line 351: ota_tfl_api_shd.g_old_rec.trans_information10;

347: ota_tfl_api_shd.g_old_rec.trans_information1;
348: End If;
349: If (p_rec.trans_information10 = hr_api.g_varchar2) then
350: p_rec.trans_information10 :=
351: ota_tfl_api_shd.g_old_rec.trans_information10;
352: End If;
353: If (p_rec.trans_information11 = hr_api.g_varchar2) then
354: p_rec.trans_information11 :=
355: ota_tfl_api_shd.g_old_rec.trans_information11;

Line 355: ota_tfl_api_shd.g_old_rec.trans_information11;

351: ota_tfl_api_shd.g_old_rec.trans_information10;
352: End If;
353: If (p_rec.trans_information11 = hr_api.g_varchar2) then
354: p_rec.trans_information11 :=
355: ota_tfl_api_shd.g_old_rec.trans_information11;
356: End If;
357: If (p_rec.trans_information12 = hr_api.g_varchar2) then
358: p_rec.trans_information12 :=
359: ota_tfl_api_shd.g_old_rec.trans_information12;

Line 359: ota_tfl_api_shd.g_old_rec.trans_information12;

355: ota_tfl_api_shd.g_old_rec.trans_information11;
356: End If;
357: If (p_rec.trans_information12 = hr_api.g_varchar2) then
358: p_rec.trans_information12 :=
359: ota_tfl_api_shd.g_old_rec.trans_information12;
360: End If;
361: If (p_rec.trans_information13 = hr_api.g_varchar2) then
362: p_rec.trans_information13 :=
363: ota_tfl_api_shd.g_old_rec.trans_information13;

Line 363: ota_tfl_api_shd.g_old_rec.trans_information13;

359: ota_tfl_api_shd.g_old_rec.trans_information12;
360: End If;
361: If (p_rec.trans_information13 = hr_api.g_varchar2) then
362: p_rec.trans_information13 :=
363: ota_tfl_api_shd.g_old_rec.trans_information13;
364: End If;
365: If (p_rec.trans_information14 = hr_api.g_varchar2) then
366: p_rec.trans_information14 :=
367: ota_tfl_api_shd.g_old_rec.trans_information14;

Line 367: ota_tfl_api_shd.g_old_rec.trans_information14;

363: ota_tfl_api_shd.g_old_rec.trans_information13;
364: End If;
365: If (p_rec.trans_information14 = hr_api.g_varchar2) then
366: p_rec.trans_information14 :=
367: ota_tfl_api_shd.g_old_rec.trans_information14;
368: End If;
369: If (p_rec.trans_information15 = hr_api.g_varchar2) then
370: p_rec.trans_information15 :=
371: ota_tfl_api_shd.g_old_rec.trans_information15;

Line 371: ota_tfl_api_shd.g_old_rec.trans_information15;

367: ota_tfl_api_shd.g_old_rec.trans_information14;
368: End If;
369: If (p_rec.trans_information15 = hr_api.g_varchar2) then
370: p_rec.trans_information15 :=
371: ota_tfl_api_shd.g_old_rec.trans_information15;
372: End If;
373: If (p_rec.trans_information16 = hr_api.g_varchar2) then
374: p_rec.trans_information16 :=
375: ota_tfl_api_shd.g_old_rec.trans_information16;

Line 375: ota_tfl_api_shd.g_old_rec.trans_information16;

371: ota_tfl_api_shd.g_old_rec.trans_information15;
372: End If;
373: If (p_rec.trans_information16 = hr_api.g_varchar2) then
374: p_rec.trans_information16 :=
375: ota_tfl_api_shd.g_old_rec.trans_information16;
376: End If;
377: If (p_rec.trans_information17 = hr_api.g_varchar2) then
378: p_rec.trans_information17 :=
379: ota_tfl_api_shd.g_old_rec.trans_information17;

Line 379: ota_tfl_api_shd.g_old_rec.trans_information17;

375: ota_tfl_api_shd.g_old_rec.trans_information16;
376: End If;
377: If (p_rec.trans_information17 = hr_api.g_varchar2) then
378: p_rec.trans_information17 :=
379: ota_tfl_api_shd.g_old_rec.trans_information17;
380: End If;
381: If (p_rec.trans_information18 = hr_api.g_varchar2) then
382: p_rec.trans_information18 :=
383: ota_tfl_api_shd.g_old_rec.trans_information18;

Line 383: ota_tfl_api_shd.g_old_rec.trans_information18;

379: ota_tfl_api_shd.g_old_rec.trans_information17;
380: End If;
381: If (p_rec.trans_information18 = hr_api.g_varchar2) then
382: p_rec.trans_information18 :=
383: ota_tfl_api_shd.g_old_rec.trans_information18;
384: End If;
385: If (p_rec.trans_information19 = hr_api.g_varchar2) then
386: p_rec.trans_information19 :=
387: ota_tfl_api_shd.g_old_rec.trans_information19;

Line 387: ota_tfl_api_shd.g_old_rec.trans_information19;

383: ota_tfl_api_shd.g_old_rec.trans_information18;
384: End If;
385: If (p_rec.trans_information19 = hr_api.g_varchar2) then
386: p_rec.trans_information19 :=
387: ota_tfl_api_shd.g_old_rec.trans_information19;
388: End If;
389: If (p_rec.trans_information2 = hr_api.g_varchar2) then
390: p_rec.trans_information2 :=
391: ota_tfl_api_shd.g_old_rec.trans_information2;

Line 391: ota_tfl_api_shd.g_old_rec.trans_information2;

387: ota_tfl_api_shd.g_old_rec.trans_information19;
388: End If;
389: If (p_rec.trans_information2 = hr_api.g_varchar2) then
390: p_rec.trans_information2 :=
391: ota_tfl_api_shd.g_old_rec.trans_information2;
392: End If;
393: If (p_rec.trans_information20 = hr_api.g_varchar2) then
394: p_rec.trans_information20 :=
395: ota_tfl_api_shd.g_old_rec.trans_information20;

Line 395: ota_tfl_api_shd.g_old_rec.trans_information20;

391: ota_tfl_api_shd.g_old_rec.trans_information2;
392: End If;
393: If (p_rec.trans_information20 = hr_api.g_varchar2) then
394: p_rec.trans_information20 :=
395: ota_tfl_api_shd.g_old_rec.trans_information20;
396: End If;
397: If (p_rec.trans_information3 = hr_api.g_varchar2) then
398: p_rec.trans_information3 :=
399: ota_tfl_api_shd.g_old_rec.trans_information3;

Line 399: ota_tfl_api_shd.g_old_rec.trans_information3;

395: ota_tfl_api_shd.g_old_rec.trans_information20;
396: End If;
397: If (p_rec.trans_information3 = hr_api.g_varchar2) then
398: p_rec.trans_information3 :=
399: ota_tfl_api_shd.g_old_rec.trans_information3;
400: End If;
401: If (p_rec.trans_information4 = hr_api.g_varchar2) then
402: p_rec.trans_information4 :=
403: ota_tfl_api_shd.g_old_rec.trans_information4;

Line 403: ota_tfl_api_shd.g_old_rec.trans_information4;

399: ota_tfl_api_shd.g_old_rec.trans_information3;
400: End If;
401: If (p_rec.trans_information4 = hr_api.g_varchar2) then
402: p_rec.trans_information4 :=
403: ota_tfl_api_shd.g_old_rec.trans_information4;
404: End If;
405: If (p_rec.trans_information5 = hr_api.g_varchar2) then
406: p_rec.trans_information5 :=
407: ota_tfl_api_shd.g_old_rec.trans_information5;

Line 407: ota_tfl_api_shd.g_old_rec.trans_information5;

403: ota_tfl_api_shd.g_old_rec.trans_information4;
404: End If;
405: If (p_rec.trans_information5 = hr_api.g_varchar2) then
406: p_rec.trans_information5 :=
407: ota_tfl_api_shd.g_old_rec.trans_information5;
408: End If;
409: If (p_rec.trans_information6 = hr_api.g_varchar2) then
410: p_rec.trans_information6 :=
411: ota_tfl_api_shd.g_old_rec.trans_information6;

Line 411: ota_tfl_api_shd.g_old_rec.trans_information6;

407: ota_tfl_api_shd.g_old_rec.trans_information5;
408: End If;
409: If (p_rec.trans_information6 = hr_api.g_varchar2) then
410: p_rec.trans_information6 :=
411: ota_tfl_api_shd.g_old_rec.trans_information6;
412: End If;
413: If (p_rec.trans_information7 = hr_api.g_varchar2) then
414: p_rec.trans_information7 :=
415: ota_tfl_api_shd.g_old_rec.trans_information7;

Line 415: ota_tfl_api_shd.g_old_rec.trans_information7;

411: ota_tfl_api_shd.g_old_rec.trans_information6;
412: End If;
413: If (p_rec.trans_information7 = hr_api.g_varchar2) then
414: p_rec.trans_information7 :=
415: ota_tfl_api_shd.g_old_rec.trans_information7;
416: End If;
417: If (p_rec.trans_information8 = hr_api.g_varchar2) then
418: p_rec.trans_information8 :=
419: ota_tfl_api_shd.g_old_rec.trans_information8;

Line 419: ota_tfl_api_shd.g_old_rec.trans_information8;

415: ota_tfl_api_shd.g_old_rec.trans_information7;
416: End If;
417: If (p_rec.trans_information8 = hr_api.g_varchar2) then
418: p_rec.trans_information8 :=
419: ota_tfl_api_shd.g_old_rec.trans_information8;
420: End If;
421: If (p_rec.trans_information9 = hr_api.g_varchar2) then
422: p_rec.trans_information9 :=
423: ota_tfl_api_shd.g_old_rec.trans_information9;

Line 423: ota_tfl_api_shd.g_old_rec.trans_information9;

419: ota_tfl_api_shd.g_old_rec.trans_information8;
420: End If;
421: If (p_rec.trans_information9 = hr_api.g_varchar2) then
422: p_rec.trans_information9 :=
423: ota_tfl_api_shd.g_old_rec.trans_information9;
424: End If;
425: If (p_rec.transfer_date = hr_api.g_date) then
426: p_rec.transfer_date :=
427: ota_tfl_api_shd.g_old_rec.transfer_date;

Line 427: ota_tfl_api_shd.g_old_rec.transfer_date;

423: ota_tfl_api_shd.g_old_rec.trans_information9;
424: End If;
425: If (p_rec.transfer_date = hr_api.g_date) then
426: p_rec.transfer_date :=
427: ota_tfl_api_shd.g_old_rec.transfer_date;
428: End If;
429: If (p_rec.transfer_message = hr_api.g_varchar2) then
430: p_rec.transfer_message :=
431: ota_tfl_api_shd.g_old_rec.transfer_message;

Line 431: ota_tfl_api_shd.g_old_rec.transfer_message;

427: ota_tfl_api_shd.g_old_rec.transfer_date;
428: End If;
429: If (p_rec.transfer_message = hr_api.g_varchar2) then
430: p_rec.transfer_message :=
431: ota_tfl_api_shd.g_old_rec.transfer_message;
432: End If;
433: If (p_rec.unitary_amount = hr_api.g_number) then
434: p_rec.unitary_amount :=
435: ota_tfl_api_shd.g_old_rec.unitary_amount;

Line 435: ota_tfl_api_shd.g_old_rec.unitary_amount;

431: ota_tfl_api_shd.g_old_rec.transfer_message;
432: End If;
433: If (p_rec.unitary_amount = hr_api.g_number) then
434: p_rec.unitary_amount :=
435: ota_tfl_api_shd.g_old_rec.unitary_amount;
436: End If;
437: If (p_rec.booking_deal_id = hr_api.g_number) then
438: p_rec.booking_deal_id :=
439: ota_tfl_api_shd.g_old_rec.booking_deal_id;

Line 439: ota_tfl_api_shd.g_old_rec.booking_deal_id;

435: ota_tfl_api_shd.g_old_rec.unitary_amount;
436: End If;
437: If (p_rec.booking_deal_id = hr_api.g_number) then
438: p_rec.booking_deal_id :=
439: ota_tfl_api_shd.g_old_rec.booking_deal_id;
440: End If;
441: If (p_rec.booking_id = hr_api.g_number) then
442: p_rec.booking_id :=
443: ota_tfl_api_shd.g_old_rec.booking_id;

Line 443: ota_tfl_api_shd.g_old_rec.booking_id;

439: ota_tfl_api_shd.g_old_rec.booking_deal_id;
440: End If;
441: If (p_rec.booking_id = hr_api.g_number) then
442: p_rec.booking_id :=
443: ota_tfl_api_shd.g_old_rec.booking_id;
444: End If;
445: If (p_rec.resource_allocation_id = hr_api.g_number) then
446: p_rec.resource_allocation_id :=
447: ota_tfl_api_shd.g_old_rec.resource_allocation_id;

Line 447: ota_tfl_api_shd.g_old_rec.resource_allocation_id;

443: ota_tfl_api_shd.g_old_rec.booking_id;
444: End If;
445: If (p_rec.resource_allocation_id = hr_api.g_number) then
446: p_rec.resource_allocation_id :=
447: ota_tfl_api_shd.g_old_rec.resource_allocation_id;
448: End If;
449: If (p_rec.resource_booking_id = hr_api.g_number) then
450: p_rec.resource_booking_id :=
451: ota_tfl_api_shd.g_old_rec.resource_booking_id;

Line 451: ota_tfl_api_shd.g_old_rec.resource_booking_id;

447: ota_tfl_api_shd.g_old_rec.resource_allocation_id;
448: End If;
449: If (p_rec.resource_booking_id = hr_api.g_number) then
450: p_rec.resource_booking_id :=
451: ota_tfl_api_shd.g_old_rec.resource_booking_id;
452: End If;
453: If (p_rec.tfl_information_category = hr_api.g_varchar2) then
454: p_rec.tfl_information_category :=
455: ota_tfl_api_shd.g_old_rec.tfl_information_category;

Line 455: ota_tfl_api_shd.g_old_rec.tfl_information_category;

451: ota_tfl_api_shd.g_old_rec.resource_booking_id;
452: End If;
453: If (p_rec.tfl_information_category = hr_api.g_varchar2) then
454: p_rec.tfl_information_category :=
455: ota_tfl_api_shd.g_old_rec.tfl_information_category;
456: End If;
457: If (p_rec.tfl_information1 = hr_api.g_varchar2) then
458: p_rec.tfl_information1 :=
459: ota_tfl_api_shd.g_old_rec.tfl_information1;

Line 459: ota_tfl_api_shd.g_old_rec.tfl_information1;

455: ota_tfl_api_shd.g_old_rec.tfl_information_category;
456: End If;
457: If (p_rec.tfl_information1 = hr_api.g_varchar2) then
458: p_rec.tfl_information1 :=
459: ota_tfl_api_shd.g_old_rec.tfl_information1;
460: End If;
461: If (p_rec.tfl_information2 = hr_api.g_varchar2) then
462: p_rec.tfl_information2 :=
463: ota_tfl_api_shd.g_old_rec.tfl_information2;

Line 463: ota_tfl_api_shd.g_old_rec.tfl_information2;

459: ota_tfl_api_shd.g_old_rec.tfl_information1;
460: End If;
461: If (p_rec.tfl_information2 = hr_api.g_varchar2) then
462: p_rec.tfl_information2 :=
463: ota_tfl_api_shd.g_old_rec.tfl_information2;
464: End If;
465: If (p_rec.tfl_information3 = hr_api.g_varchar2) then
466: p_rec.tfl_information3 :=
467: ota_tfl_api_shd.g_old_rec.tfl_information3;

Line 467: ota_tfl_api_shd.g_old_rec.tfl_information3;

463: ota_tfl_api_shd.g_old_rec.tfl_information2;
464: End If;
465: If (p_rec.tfl_information3 = hr_api.g_varchar2) then
466: p_rec.tfl_information3 :=
467: ota_tfl_api_shd.g_old_rec.tfl_information3;
468: End If;
469: If (p_rec.tfl_information4 = hr_api.g_varchar2) then
470: p_rec.tfl_information4 :=
471: ota_tfl_api_shd.g_old_rec.tfl_information4;

Line 471: ota_tfl_api_shd.g_old_rec.tfl_information4;

467: ota_tfl_api_shd.g_old_rec.tfl_information3;
468: End If;
469: If (p_rec.tfl_information4 = hr_api.g_varchar2) then
470: p_rec.tfl_information4 :=
471: ota_tfl_api_shd.g_old_rec.tfl_information4;
472: End If;
473: If (p_rec.tfl_information5 = hr_api.g_varchar2) then
474: p_rec.tfl_information5 :=
475: ota_tfl_api_shd.g_old_rec.tfl_information5;

Line 475: ota_tfl_api_shd.g_old_rec.tfl_information5;

471: ota_tfl_api_shd.g_old_rec.tfl_information4;
472: End If;
473: If (p_rec.tfl_information5 = hr_api.g_varchar2) then
474: p_rec.tfl_information5 :=
475: ota_tfl_api_shd.g_old_rec.tfl_information5;
476: End If;
477: If (p_rec.tfl_information6 = hr_api.g_varchar2) then
478: p_rec.tfl_information6 :=
479: ota_tfl_api_shd.g_old_rec.tfl_information6;

Line 479: ota_tfl_api_shd.g_old_rec.tfl_information6;

475: ota_tfl_api_shd.g_old_rec.tfl_information5;
476: End If;
477: If (p_rec.tfl_information6 = hr_api.g_varchar2) then
478: p_rec.tfl_information6 :=
479: ota_tfl_api_shd.g_old_rec.tfl_information6;
480: End If;
481: If (p_rec.tfl_information7 = hr_api.g_varchar2) then
482: p_rec.tfl_information7 :=
483: ota_tfl_api_shd.g_old_rec.tfl_information7;

Line 483: ota_tfl_api_shd.g_old_rec.tfl_information7;

479: ota_tfl_api_shd.g_old_rec.tfl_information6;
480: End If;
481: If (p_rec.tfl_information7 = hr_api.g_varchar2) then
482: p_rec.tfl_information7 :=
483: ota_tfl_api_shd.g_old_rec.tfl_information7;
484: End If;
485: If (p_rec.tfl_information8 = hr_api.g_varchar2) then
486: p_rec.tfl_information8 :=
487: ota_tfl_api_shd.g_old_rec.tfl_information8;

Line 487: ota_tfl_api_shd.g_old_rec.tfl_information8;

483: ota_tfl_api_shd.g_old_rec.tfl_information7;
484: End If;
485: If (p_rec.tfl_information8 = hr_api.g_varchar2) then
486: p_rec.tfl_information8 :=
487: ota_tfl_api_shd.g_old_rec.tfl_information8;
488: End If;
489: If (p_rec.tfl_information9 = hr_api.g_varchar2) then
490: p_rec.tfl_information9 :=
491: ota_tfl_api_shd.g_old_rec.tfl_information9;

Line 491: ota_tfl_api_shd.g_old_rec.tfl_information9;

487: ota_tfl_api_shd.g_old_rec.tfl_information8;
488: End If;
489: If (p_rec.tfl_information9 = hr_api.g_varchar2) then
490: p_rec.tfl_information9 :=
491: ota_tfl_api_shd.g_old_rec.tfl_information9;
492: End If;
493: If (p_rec.tfl_information10 = hr_api.g_varchar2) then
494: p_rec.tfl_information10 :=
495: ota_tfl_api_shd.g_old_rec.tfl_information10;

Line 495: ota_tfl_api_shd.g_old_rec.tfl_information10;

491: ota_tfl_api_shd.g_old_rec.tfl_information9;
492: End If;
493: If (p_rec.tfl_information10 = hr_api.g_varchar2) then
494: p_rec.tfl_information10 :=
495: ota_tfl_api_shd.g_old_rec.tfl_information10;
496: End If;
497: If (p_rec.tfl_information11 = hr_api.g_varchar2) then
498: p_rec.tfl_information11 :=
499: ota_tfl_api_shd.g_old_rec.tfl_information11;

Line 499: ota_tfl_api_shd.g_old_rec.tfl_information11;

495: ota_tfl_api_shd.g_old_rec.tfl_information10;
496: End If;
497: If (p_rec.tfl_information11 = hr_api.g_varchar2) then
498: p_rec.tfl_information11 :=
499: ota_tfl_api_shd.g_old_rec.tfl_information11;
500: End If;
501: If (p_rec.tfl_information12 = hr_api.g_varchar2) then
502: p_rec.tfl_information12 :=
503: ota_tfl_api_shd.g_old_rec.tfl_information12;

Line 503: ota_tfl_api_shd.g_old_rec.tfl_information12;

499: ota_tfl_api_shd.g_old_rec.tfl_information11;
500: End If;
501: If (p_rec.tfl_information12 = hr_api.g_varchar2) then
502: p_rec.tfl_information12 :=
503: ota_tfl_api_shd.g_old_rec.tfl_information12;
504: End If;
505: If (p_rec.tfl_information13 = hr_api.g_varchar2) then
506: p_rec.tfl_information13 :=
507: ota_tfl_api_shd.g_old_rec.tfl_information13;

Line 507: ota_tfl_api_shd.g_old_rec.tfl_information13;

503: ota_tfl_api_shd.g_old_rec.tfl_information12;
504: End If;
505: If (p_rec.tfl_information13 = hr_api.g_varchar2) then
506: p_rec.tfl_information13 :=
507: ota_tfl_api_shd.g_old_rec.tfl_information13;
508: End If;
509: If (p_rec.tfl_information14 = hr_api.g_varchar2) then
510: p_rec.tfl_information14 :=
511: ota_tfl_api_shd.g_old_rec.tfl_information14;

Line 511: ota_tfl_api_shd.g_old_rec.tfl_information14;

507: ota_tfl_api_shd.g_old_rec.tfl_information13;
508: End If;
509: If (p_rec.tfl_information14 = hr_api.g_varchar2) then
510: p_rec.tfl_information14 :=
511: ota_tfl_api_shd.g_old_rec.tfl_information14;
512: End If;
513: If (p_rec.tfl_information15 = hr_api.g_varchar2) then
514: p_rec.tfl_information15 :=
515: ota_tfl_api_shd.g_old_rec.tfl_information15;

Line 515: ota_tfl_api_shd.g_old_rec.tfl_information15;

511: ota_tfl_api_shd.g_old_rec.tfl_information14;
512: End If;
513: If (p_rec.tfl_information15 = hr_api.g_varchar2) then
514: p_rec.tfl_information15 :=
515: ota_tfl_api_shd.g_old_rec.tfl_information15;
516: End If;
517: If (p_rec.tfl_information16 = hr_api.g_varchar2) then
518: p_rec.tfl_information16 :=
519: ota_tfl_api_shd.g_old_rec.tfl_information16;

Line 519: ota_tfl_api_shd.g_old_rec.tfl_information16;

515: ota_tfl_api_shd.g_old_rec.tfl_information15;
516: End If;
517: If (p_rec.tfl_information16 = hr_api.g_varchar2) then
518: p_rec.tfl_information16 :=
519: ota_tfl_api_shd.g_old_rec.tfl_information16;
520: End If;
521: If (p_rec.tfl_information17 = hr_api.g_varchar2) then
522: p_rec.tfl_information17 :=
523: ota_tfl_api_shd.g_old_rec.tfl_information17;

Line 523: ota_tfl_api_shd.g_old_rec.tfl_information17;

519: ota_tfl_api_shd.g_old_rec.tfl_information16;
520: End If;
521: If (p_rec.tfl_information17 = hr_api.g_varchar2) then
522: p_rec.tfl_information17 :=
523: ota_tfl_api_shd.g_old_rec.tfl_information17;
524: End If;
525: If (p_rec.tfl_information18 = hr_api.g_varchar2) then
526: p_rec.tfl_information18 :=
527: ota_tfl_api_shd.g_old_rec.tfl_information18;

Line 527: ota_tfl_api_shd.g_old_rec.tfl_information18;

523: ota_tfl_api_shd.g_old_rec.tfl_information17;
524: End If;
525: If (p_rec.tfl_information18 = hr_api.g_varchar2) then
526: p_rec.tfl_information18 :=
527: ota_tfl_api_shd.g_old_rec.tfl_information18;
528: End If;
529: If (p_rec.tfl_information19 = hr_api.g_varchar2) then
530: p_rec.tfl_information19 :=
531: ota_tfl_api_shd.g_old_rec.tfl_information19;

Line 531: ota_tfl_api_shd.g_old_rec.tfl_information19;

527: ota_tfl_api_shd.g_old_rec.tfl_information18;
528: End If;
529: If (p_rec.tfl_information19 = hr_api.g_varchar2) then
530: p_rec.tfl_information19 :=
531: ota_tfl_api_shd.g_old_rec.tfl_information19;
532: End If;
533: If (p_rec.tfl_information20 = hr_api.g_varchar2) then
534: p_rec.tfl_information20 :=
535: ota_tfl_api_shd.g_old_rec.tfl_information20;

Line 535: ota_tfl_api_shd.g_old_rec.tfl_information20;

531: ota_tfl_api_shd.g_old_rec.tfl_information19;
532: End If;
533: If (p_rec.tfl_information20 = hr_api.g_varchar2) then
534: p_rec.tfl_information20 :=
535: ota_tfl_api_shd.g_old_rec.tfl_information20;
536: End If;
537: --
538: -- Return the plsql record structure.
539: --

Line 550: p_rec in out nocopy ota_tfl_api_shd.g_rec_type,

546: -- |---------------------------------< upd >----------------------------------|
547: -- ----------------------------------------------------------------------------
548: Procedure upd
549: (
550: p_rec in out nocopy ota_tfl_api_shd.g_rec_type,
551: p_validate in boolean default false,
552: p_transaction_type in varchar2
553: ) is
554: --

Line 558: temp_var ota_tfl_api_shd.g_rec_type;

554: --
555: l_proc varchar2(72) := g_package||'upd';
556:
557: -- 06/05/97 Change Begins
558: temp_var ota_tfl_api_shd.g_rec_type;
559: -- 06/05/97 Change Ends
560: --
561: Begin
562: hr_utility.set_location('Entering:'||l_proc, 5);

Line 575: ota_tfl_api_shd.lck

571: End If;
572: --
573: -- We must lock the row which we need to update.
574: --
575: ota_tfl_api_shd.lck
576: (
577: p_rec.finance_line_id,
578: p_rec.object_version_number
579: );

Line 696: l_rec ota_tfl_api_shd.g_rec_type;

692: p_validate in boolean default false,
693: p_transaction_type in varchar2
694: ) is
695: --
696: l_rec ota_tfl_api_shd.g_rec_type;
697: l_proc varchar2(72) := g_package||'upd';
698: --
699: Begin
700: hr_utility.set_location('Entering:'||l_proc, 5);

Line 706: ota_tfl_api_shd.convert_args

702: -- Call conversion function to turn arguments into the
703: -- l_rec structure.
704: --
705: l_rec :=
706: ota_tfl_api_shd.convert_args
707: (
708: p_finance_line_id,
709: p_finance_header_id,
710: p_cancelled_flag,