DBA Data[Home] [Help]

APPS.HR_TRS_UPD dependencies on HR_TRS_SHD

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

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

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

Line 120: hr_trs_shd.g_api_dml := false; -- Unset the api dml status

116: information29 = p_rec.information29,
117: information30 = p_rec.information30
118: where transaction_step_id = p_rec.transaction_step_id;
119: --
120: hr_trs_shd.g_api_dml := false; -- Unset the api dml status
121: --
122: hr_utility.set_location(' Leaving:'||l_proc, 10);
123: --
124: Exception

Line 127: hr_trs_shd.g_api_dml := false; -- Unset the api dml status

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

Line 128: hr_trs_shd.constraint_error

124: Exception
125: When hr_api.check_integrity_violated Then
126: -- A check constraint has been violated
127: hr_trs_shd.g_api_dml := false; -- Unset the api dml status
128: hr_trs_shd.constraint_error
129: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
130: When hr_api.parent_integrity_violated Then
131: -- Parent integrity has been violated
132: hr_trs_shd.g_api_dml := false; -- Unset the api dml status

Line 132: hr_trs_shd.g_api_dml := false; -- Unset the api dml status

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

Line 133: hr_trs_shd.constraint_error

129: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
130: When hr_api.parent_integrity_violated Then
131: -- Parent integrity has been violated
132: hr_trs_shd.g_api_dml := false; -- Unset the api dml status
133: hr_trs_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.unique_integrity_violated Then
136: -- Unique integrity has been violated
137: hr_trs_shd.g_api_dml := false; -- Unset the api dml status

Line 137: hr_trs_shd.g_api_dml := false; -- Unset the api dml status

133: hr_trs_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.unique_integrity_violated Then
136: -- Unique integrity has been violated
137: hr_trs_shd.g_api_dml := false; -- Unset the api dml status
138: hr_trs_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When Others Then
141: hr_trs_shd.g_api_dml := false; -- Unset the api dml status

Line 138: hr_trs_shd.constraint_error

134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.unique_integrity_violated Then
136: -- Unique integrity has been violated
137: hr_trs_shd.g_api_dml := false; -- Unset the api dml status
138: hr_trs_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When Others Then
141: hr_trs_shd.g_api_dml := false; -- Unset the api dml status
142: Raise;

Line 141: hr_trs_shd.g_api_dml := false; -- Unset the api dml status

137: hr_trs_shd.g_api_dml := false; -- Unset the api dml status
138: hr_trs_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When Others Then
141: hr_trs_shd.g_api_dml := false; -- Unset the api dml status
142: Raise;
143: End update_dml;
144: --
145: -- ----------------------------------------------------------------------------

Line 177: Procedure pre_update(p_rec in hr_trs_shd.g_rec_type) is

173: -- Internal Table Handler Use Only.
174: --
175: -- {End Of Comments}
176: -- ----------------------------------------------------------------------------
177: Procedure pre_update(p_rec in hr_trs_shd.g_rec_type) is
178: --
179: l_proc varchar2(72) := g_package||'pre_update';
180: --
181: Begin

Line 219: Procedure post_update(p_rec in hr_trs_shd.g_rec_type) is

215: -- Internal Table Handler Use Only.
216: --
217: -- {End Of Comments}
218: -- ----------------------------------------------------------------------------
219: Procedure post_update(p_rec in hr_trs_shd.g_rec_type) is
220: --
221: l_proc varchar2(72) := g_package||'post_update';
222: --
223: Begin

Line 273: Procedure convert_defs(p_rec in out nocopy hr_trs_shd.g_rec_type) is

269: -- Internal Table Handler Use Only.
270: --
271: -- {End Of Comments}
272: -- ----------------------------------------------------------------------------
273: Procedure convert_defs(p_rec in out nocopy hr_trs_shd.g_rec_type) is
274: --
275: l_proc varchar2(72) := g_package||'convert_defs';
276: --
277: Begin

Line 288: hr_trs_shd.g_old_rec.transaction_id;

284: -- is being used then we must set to the 'current' argument value.
285: --
286: If (p_rec.transaction_id = hr_api.g_number) then
287: p_rec.transaction_id :=
288: hr_trs_shd.g_old_rec.transaction_id;
289: End If;
290: If (p_rec.api_name = hr_api.g_varchar2) then
291: p_rec.api_name :=
292: hr_trs_shd.g_old_rec.api_name;

Line 292: hr_trs_shd.g_old_rec.api_name;

288: hr_trs_shd.g_old_rec.transaction_id;
289: End If;
290: If (p_rec.api_name = hr_api.g_varchar2) then
291: p_rec.api_name :=
292: hr_trs_shd.g_old_rec.api_name;
293: End If;
294: If (p_rec.api_display_name = hr_api.g_varchar2) then
295: p_rec.api_display_name :=
296: hr_trs_shd.g_old_rec.api_display_name;

Line 296: hr_trs_shd.g_old_rec.api_display_name;

292: hr_trs_shd.g_old_rec.api_name;
293: End If;
294: If (p_rec.api_display_name = hr_api.g_varchar2) then
295: p_rec.api_display_name :=
296: hr_trs_shd.g_old_rec.api_display_name;
297: End If;
298: If (p_rec.processing_order = hr_api.g_number) then
299: p_rec.processing_order :=
300: hr_trs_shd.g_old_rec.processing_order;

Line 300: hr_trs_shd.g_old_rec.processing_order;

296: hr_trs_shd.g_old_rec.api_display_name;
297: End If;
298: If (p_rec.processing_order = hr_api.g_number) then
299: p_rec.processing_order :=
300: hr_trs_shd.g_old_rec.processing_order;
301: End If;
302: If (p_rec.item_type = hr_api.g_varchar2) then
303: p_rec.item_type :=
304: hr_trs_shd.g_old_rec.item_type;

Line 304: hr_trs_shd.g_old_rec.item_type;

300: hr_trs_shd.g_old_rec.processing_order;
301: End If;
302: If (p_rec.item_type = hr_api.g_varchar2) then
303: p_rec.item_type :=
304: hr_trs_shd.g_old_rec.item_type;
305: End If;
306: If (p_rec.item_key = hr_api.g_varchar2) then
307: p_rec.item_key :=
308: hr_trs_shd.g_old_rec.item_key;

Line 308: hr_trs_shd.g_old_rec.item_key;

304: hr_trs_shd.g_old_rec.item_type;
305: End If;
306: If (p_rec.item_key = hr_api.g_varchar2) then
307: p_rec.item_key :=
308: hr_trs_shd.g_old_rec.item_key;
309: End If;
310: If (p_rec.activity_id = hr_api.g_number) then
311: p_rec.activity_id :=
312: hr_trs_shd.g_old_rec.activity_id;

Line 312: hr_trs_shd.g_old_rec.activity_id;

308: hr_trs_shd.g_old_rec.item_key;
309: End If;
310: If (p_rec.activity_id = hr_api.g_number) then
311: p_rec.activity_id :=
312: hr_trs_shd.g_old_rec.activity_id;
313: End If;
314: If (p_rec.creator_person_id = hr_api.g_number) then
315: p_rec.creator_person_id :=
316: hr_trs_shd.g_old_rec.creator_person_id;

Line 316: hr_trs_shd.g_old_rec.creator_person_id;

312: hr_trs_shd.g_old_rec.activity_id;
313: End If;
314: If (p_rec.creator_person_id = hr_api.g_number) then
315: p_rec.creator_person_id :=
316: hr_trs_shd.g_old_rec.creator_person_id;
317: End If;
318: If (p_rec.update_person_id = hr_api.g_number) then
319: p_rec.update_person_id :=
320: hr_trs_shd.g_old_rec.update_person_id;

Line 320: hr_trs_shd.g_old_rec.update_person_id;

316: hr_trs_shd.g_old_rec.creator_person_id;
317: End If;
318: If (p_rec.update_person_id = hr_api.g_number) then
319: p_rec.update_person_id :=
320: hr_trs_shd.g_old_rec.update_person_id;
321: End If;
322:
323: If (p_rec.pk1 = hr_api.g_varchar2) then
324: p_rec.pk1 := hr_trs_shd.g_old_rec.pk1;

Line 324: p_rec.pk1 := hr_trs_shd.g_old_rec.pk1;

320: hr_trs_shd.g_old_rec.update_person_id;
321: End If;
322:
323: If (p_rec.pk1 = hr_api.g_varchar2) then
324: p_rec.pk1 := hr_trs_shd.g_old_rec.pk1;
325: End If;
326: If (p_rec.pk2 = hr_api.g_varchar2) then
327: p_rec.pk2 := hr_trs_shd.g_old_rec.pk2;
328: End If;

Line 327: p_rec.pk2 := hr_trs_shd.g_old_rec.pk2;

323: If (p_rec.pk1 = hr_api.g_varchar2) then
324: p_rec.pk1 := hr_trs_shd.g_old_rec.pk1;
325: End If;
326: If (p_rec.pk2 = hr_api.g_varchar2) then
327: p_rec.pk2 := hr_trs_shd.g_old_rec.pk2;
328: End If;
329: If (p_rec.pk3 = hr_api.g_varchar2) then
330: p_rec.pk3 := hr_trs_shd.g_old_rec.pk3;
331: End If;

Line 330: p_rec.pk3 := hr_trs_shd.g_old_rec.pk3;

326: If (p_rec.pk2 = hr_api.g_varchar2) then
327: p_rec.pk2 := hr_trs_shd.g_old_rec.pk2;
328: End If;
329: If (p_rec.pk3 = hr_api.g_varchar2) then
330: p_rec.pk3 := hr_trs_shd.g_old_rec.pk3;
331: End If;
332: If (p_rec.pk4 = hr_api.g_varchar2) then
333: p_rec.pk4 := hr_trs_shd.g_old_rec.pk4;
334: End If;

Line 333: p_rec.pk4 := hr_trs_shd.g_old_rec.pk4;

329: If (p_rec.pk3 = hr_api.g_varchar2) then
330: p_rec.pk3 := hr_trs_shd.g_old_rec.pk3;
331: End If;
332: If (p_rec.pk4 = hr_api.g_varchar2) then
333: p_rec.pk4 := hr_trs_shd.g_old_rec.pk4;
334: End If;
335: If (p_rec.pk5 = hr_api.g_varchar2) then
336: p_rec.pk5 := hr_trs_shd.g_old_rec.pk5;
337: End If;

Line 336: p_rec.pk5 := hr_trs_shd.g_old_rec.pk5;

332: If (p_rec.pk4 = hr_api.g_varchar2) then
333: p_rec.pk4 := hr_trs_shd.g_old_rec.pk4;
334: End If;
335: If (p_rec.pk5 = hr_api.g_varchar2) then
336: p_rec.pk5 := hr_trs_shd.g_old_rec.pk5;
337: End If;
338: If (p_rec.information_category = hr_api.g_varchar2) then
339: p_rec.information_category := hr_trs_shd.g_old_rec.information_category;
340: End If;

Line 339: p_rec.information_category := hr_trs_shd.g_old_rec.information_category;

335: If (p_rec.pk5 = hr_api.g_varchar2) then
336: p_rec.pk5 := hr_trs_shd.g_old_rec.pk5;
337: End If;
338: If (p_rec.information_category = hr_api.g_varchar2) then
339: p_rec.information_category := hr_trs_shd.g_old_rec.information_category;
340: End If;
341: If (p_rec.information1 = hr_api.g_varchar2) then
342: p_rec.information1 := hr_trs_shd.g_old_rec.information1;
343: End If;

Line 342: p_rec.information1 := hr_trs_shd.g_old_rec.information1;

338: If (p_rec.information_category = hr_api.g_varchar2) then
339: p_rec.information_category := hr_trs_shd.g_old_rec.information_category;
340: End If;
341: If (p_rec.information1 = hr_api.g_varchar2) then
342: p_rec.information1 := hr_trs_shd.g_old_rec.information1;
343: End If;
344: If (p_rec.information2 = hr_api.g_varchar2) then
345: p_rec.information2 := hr_trs_shd.g_old_rec.information2;
346: End If;

Line 345: p_rec.information2 := hr_trs_shd.g_old_rec.information2;

341: If (p_rec.information1 = hr_api.g_varchar2) then
342: p_rec.information1 := hr_trs_shd.g_old_rec.information1;
343: End If;
344: If (p_rec.information2 = hr_api.g_varchar2) then
345: p_rec.information2 := hr_trs_shd.g_old_rec.information2;
346: End If;
347: If (p_rec.information3 = hr_api.g_varchar2) then
348: p_rec.information3 := hr_trs_shd.g_old_rec.information3;
349: End If;

Line 348: p_rec.information3 := hr_trs_shd.g_old_rec.information3;

344: If (p_rec.information2 = hr_api.g_varchar2) then
345: p_rec.information2 := hr_trs_shd.g_old_rec.information2;
346: End If;
347: If (p_rec.information3 = hr_api.g_varchar2) then
348: p_rec.information3 := hr_trs_shd.g_old_rec.information3;
349: End If;
350: If (p_rec.information4 = hr_api.g_varchar2) then
351: p_rec.information4 := hr_trs_shd.g_old_rec.information4;
352: End If;

Line 351: p_rec.information4 := hr_trs_shd.g_old_rec.information4;

347: If (p_rec.information3 = hr_api.g_varchar2) then
348: p_rec.information3 := hr_trs_shd.g_old_rec.information3;
349: End If;
350: If (p_rec.information4 = hr_api.g_varchar2) then
351: p_rec.information4 := hr_trs_shd.g_old_rec.information4;
352: End If;
353: If (p_rec.information5 = hr_api.g_varchar2) then
354: p_rec.information5 := hr_trs_shd.g_old_rec.information5;
355: End If;

Line 354: p_rec.information5 := hr_trs_shd.g_old_rec.information5;

350: If (p_rec.information4 = hr_api.g_varchar2) then
351: p_rec.information4 := hr_trs_shd.g_old_rec.information4;
352: End If;
353: If (p_rec.information5 = hr_api.g_varchar2) then
354: p_rec.information5 := hr_trs_shd.g_old_rec.information5;
355: End If;
356: If (p_rec.information6 = hr_api.g_varchar2) then
357: p_rec.information6 := hr_trs_shd.g_old_rec.information6;
358: End If;

Line 357: p_rec.information6 := hr_trs_shd.g_old_rec.information6;

353: If (p_rec.information5 = hr_api.g_varchar2) then
354: p_rec.information5 := hr_trs_shd.g_old_rec.information5;
355: End If;
356: If (p_rec.information6 = hr_api.g_varchar2) then
357: p_rec.information6 := hr_trs_shd.g_old_rec.information6;
358: End If;
359: If (p_rec.information7 = hr_api.g_varchar2) then
360: p_rec.information7 := hr_trs_shd.g_old_rec.information7;
361: End If;

Line 360: p_rec.information7 := hr_trs_shd.g_old_rec.information7;

356: If (p_rec.information6 = hr_api.g_varchar2) then
357: p_rec.information6 := hr_trs_shd.g_old_rec.information6;
358: End If;
359: If (p_rec.information7 = hr_api.g_varchar2) then
360: p_rec.information7 := hr_trs_shd.g_old_rec.information7;
361: End If;
362: If (p_rec.information8 = hr_api.g_varchar2) then
363: p_rec.information8 := hr_trs_shd.g_old_rec.information8;
364: End If;

Line 363: p_rec.information8 := hr_trs_shd.g_old_rec.information8;

359: If (p_rec.information7 = hr_api.g_varchar2) then
360: p_rec.information7 := hr_trs_shd.g_old_rec.information7;
361: End If;
362: If (p_rec.information8 = hr_api.g_varchar2) then
363: p_rec.information8 := hr_trs_shd.g_old_rec.information8;
364: End If;
365: If (p_rec.information9 = hr_api.g_varchar2) then
366: p_rec.information9 := hr_trs_shd.g_old_rec.information9;
367: End If;

Line 366: p_rec.information9 := hr_trs_shd.g_old_rec.information9;

362: If (p_rec.information8 = hr_api.g_varchar2) then
363: p_rec.information8 := hr_trs_shd.g_old_rec.information8;
364: End If;
365: If (p_rec.information9 = hr_api.g_varchar2) then
366: p_rec.information9 := hr_trs_shd.g_old_rec.information9;
367: End If;
368: If (p_rec.information10 = hr_api.g_varchar2) then
369: p_rec.information10 := hr_trs_shd.g_old_rec.information10;
370: End If;

Line 369: p_rec.information10 := hr_trs_shd.g_old_rec.information10;

365: If (p_rec.information9 = hr_api.g_varchar2) then
366: p_rec.information9 := hr_trs_shd.g_old_rec.information9;
367: End If;
368: If (p_rec.information10 = hr_api.g_varchar2) then
369: p_rec.information10 := hr_trs_shd.g_old_rec.information10;
370: End If;
371: If (p_rec.information11 = hr_api.g_varchar2) then
372: p_rec.information11 := hr_trs_shd.g_old_rec.information11;
373: End If;

Line 372: p_rec.information11 := hr_trs_shd.g_old_rec.information11;

368: If (p_rec.information10 = hr_api.g_varchar2) then
369: p_rec.information10 := hr_trs_shd.g_old_rec.information10;
370: End If;
371: If (p_rec.information11 = hr_api.g_varchar2) then
372: p_rec.information11 := hr_trs_shd.g_old_rec.information11;
373: End If;
374: If (p_rec.information12 = hr_api.g_varchar2) then
375: p_rec.information12:= hr_trs_shd.g_old_rec.information12;
376: End If;

Line 375: p_rec.information12:= hr_trs_shd.g_old_rec.information12;

371: If (p_rec.information11 = hr_api.g_varchar2) then
372: p_rec.information11 := hr_trs_shd.g_old_rec.information11;
373: End If;
374: If (p_rec.information12 = hr_api.g_varchar2) then
375: p_rec.information12:= hr_trs_shd.g_old_rec.information12;
376: End If;
377: If (p_rec.information13 = hr_api.g_varchar2) then
378: p_rec.information13 := hr_trs_shd.g_old_rec.information1;
379: End If;

Line 378: p_rec.information13 := hr_trs_shd.g_old_rec.information1;

374: If (p_rec.information12 = hr_api.g_varchar2) then
375: p_rec.information12:= hr_trs_shd.g_old_rec.information12;
376: End If;
377: If (p_rec.information13 = hr_api.g_varchar2) then
378: p_rec.information13 := hr_trs_shd.g_old_rec.information1;
379: End If;
380: If (p_rec.information14 = hr_api.g_varchar2) then
381: p_rec.information14 := hr_trs_shd.g_old_rec.information14;
382: End If;

Line 381: p_rec.information14 := hr_trs_shd.g_old_rec.information14;

377: If (p_rec.information13 = hr_api.g_varchar2) then
378: p_rec.information13 := hr_trs_shd.g_old_rec.information1;
379: End If;
380: If (p_rec.information14 = hr_api.g_varchar2) then
381: p_rec.information14 := hr_trs_shd.g_old_rec.information14;
382: End If;
383: If (p_rec.information15= hr_api.g_varchar2) then
384: p_rec.information15 := hr_trs_shd.g_old_rec.information15;
385: End If;

Line 384: p_rec.information15 := hr_trs_shd.g_old_rec.information15;

380: If (p_rec.information14 = hr_api.g_varchar2) then
381: p_rec.information14 := hr_trs_shd.g_old_rec.information14;
382: End If;
383: If (p_rec.information15= hr_api.g_varchar2) then
384: p_rec.information15 := hr_trs_shd.g_old_rec.information15;
385: End If;
386: If (p_rec.information16 = hr_api.g_varchar2) then
387: p_rec.information16 := hr_trs_shd.g_old_rec.information16;
388: End If;

Line 387: p_rec.information16 := hr_trs_shd.g_old_rec.information16;

383: If (p_rec.information15= hr_api.g_varchar2) then
384: p_rec.information15 := hr_trs_shd.g_old_rec.information15;
385: End If;
386: If (p_rec.information16 = hr_api.g_varchar2) then
387: p_rec.information16 := hr_trs_shd.g_old_rec.information16;
388: End If;
389: If (p_rec.information17 = hr_api.g_varchar2) then
390: p_rec.information17 := hr_trs_shd.g_old_rec.information17;
391: End If;

Line 390: p_rec.information17 := hr_trs_shd.g_old_rec.information17;

386: If (p_rec.information16 = hr_api.g_varchar2) then
387: p_rec.information16 := hr_trs_shd.g_old_rec.information16;
388: End If;
389: If (p_rec.information17 = hr_api.g_varchar2) then
390: p_rec.information17 := hr_trs_shd.g_old_rec.information17;
391: End If;
392: If (p_rec.information18 = hr_api.g_varchar2) then
393: p_rec.information18 := hr_trs_shd.g_old_rec.information18;
394: End If;

Line 393: p_rec.information18 := hr_trs_shd.g_old_rec.information18;

389: If (p_rec.information17 = hr_api.g_varchar2) then
390: p_rec.information17 := hr_trs_shd.g_old_rec.information17;
391: End If;
392: If (p_rec.information18 = hr_api.g_varchar2) then
393: p_rec.information18 := hr_trs_shd.g_old_rec.information18;
394: End If;
395: If (p_rec.information19 = hr_api.g_varchar2) then
396: p_rec.information19 := hr_trs_shd.g_old_rec.information19;
397: End If;

Line 396: p_rec.information19 := hr_trs_shd.g_old_rec.information19;

392: If (p_rec.information18 = hr_api.g_varchar2) then
393: p_rec.information18 := hr_trs_shd.g_old_rec.information18;
394: End If;
395: If (p_rec.information19 = hr_api.g_varchar2) then
396: p_rec.information19 := hr_trs_shd.g_old_rec.information19;
397: End If;
398: If (p_rec.information20= hr_api.g_varchar2) then
399: p_rec.information20 := hr_trs_shd.g_old_rec.information20;
400: End If;

Line 399: p_rec.information20 := hr_trs_shd.g_old_rec.information20;

395: If (p_rec.information19 = hr_api.g_varchar2) then
396: p_rec.information19 := hr_trs_shd.g_old_rec.information19;
397: End If;
398: If (p_rec.information20= hr_api.g_varchar2) then
399: p_rec.information20 := hr_trs_shd.g_old_rec.information20;
400: End If;
401: If (p_rec.information21 = hr_api.g_varchar2) then
402: p_rec.information21 := hr_trs_shd.g_old_rec.information21;
403: End If;

Line 402: p_rec.information21 := hr_trs_shd.g_old_rec.information21;

398: If (p_rec.information20= hr_api.g_varchar2) then
399: p_rec.information20 := hr_trs_shd.g_old_rec.information20;
400: End If;
401: If (p_rec.information21 = hr_api.g_varchar2) then
402: p_rec.information21 := hr_trs_shd.g_old_rec.information21;
403: End If;
404: If (p_rec.information22 = hr_api.g_varchar2) then
405: p_rec.information22 := hr_trs_shd.g_old_rec.information22;
406: End If;

Line 405: p_rec.information22 := hr_trs_shd.g_old_rec.information22;

401: If (p_rec.information21 = hr_api.g_varchar2) then
402: p_rec.information21 := hr_trs_shd.g_old_rec.information21;
403: End If;
404: If (p_rec.information22 = hr_api.g_varchar2) then
405: p_rec.information22 := hr_trs_shd.g_old_rec.information22;
406: End If;
407: If (p_rec.information23 = hr_api.g_varchar2) then
408: p_rec.information23 := hr_trs_shd.g_old_rec.information23;
409: End If;

Line 408: p_rec.information23 := hr_trs_shd.g_old_rec.information23;

404: If (p_rec.information22 = hr_api.g_varchar2) then
405: p_rec.information22 := hr_trs_shd.g_old_rec.information22;
406: End If;
407: If (p_rec.information23 = hr_api.g_varchar2) then
408: p_rec.information23 := hr_trs_shd.g_old_rec.information23;
409: End If;
410: If (p_rec.information24 = hr_api.g_varchar2) then
411: p_rec.information24 := hr_trs_shd.g_old_rec.information24;
412: End If;

Line 411: p_rec.information24 := hr_trs_shd.g_old_rec.information24;

407: If (p_rec.information23 = hr_api.g_varchar2) then
408: p_rec.information23 := hr_trs_shd.g_old_rec.information23;
409: End If;
410: If (p_rec.information24 = hr_api.g_varchar2) then
411: p_rec.information24 := hr_trs_shd.g_old_rec.information24;
412: End If;
413: If (p_rec.information25 = hr_api.g_varchar2) then
414: p_rec.information25 := hr_trs_shd.g_old_rec.information25;
415: End If;

Line 414: p_rec.information25 := hr_trs_shd.g_old_rec.information25;

410: If (p_rec.information24 = hr_api.g_varchar2) then
411: p_rec.information24 := hr_trs_shd.g_old_rec.information24;
412: End If;
413: If (p_rec.information25 = hr_api.g_varchar2) then
414: p_rec.information25 := hr_trs_shd.g_old_rec.information25;
415: End If;
416: If (p_rec.information26 = hr_api.g_varchar2) then
417: p_rec.information26 := hr_trs_shd.g_old_rec.information26;
418: End If;

Line 417: p_rec.information26 := hr_trs_shd.g_old_rec.information26;

413: If (p_rec.information25 = hr_api.g_varchar2) then
414: p_rec.information25 := hr_trs_shd.g_old_rec.information25;
415: End If;
416: If (p_rec.information26 = hr_api.g_varchar2) then
417: p_rec.information26 := hr_trs_shd.g_old_rec.information26;
418: End If;
419: If (p_rec.information27 = hr_api.g_varchar2) then
420: p_rec.information27 := hr_trs_shd.g_old_rec.information27;
421: End If;

Line 420: p_rec.information27 := hr_trs_shd.g_old_rec.information27;

416: If (p_rec.information26 = hr_api.g_varchar2) then
417: p_rec.information26 := hr_trs_shd.g_old_rec.information26;
418: End If;
419: If (p_rec.information27 = hr_api.g_varchar2) then
420: p_rec.information27 := hr_trs_shd.g_old_rec.information27;
421: End If;
422: If (p_rec.information28 = hr_api.g_varchar2) then
423: p_rec.information28 := hr_trs_shd.g_old_rec.information28;
424: End If;

Line 423: p_rec.information28 := hr_trs_shd.g_old_rec.information28;

419: If (p_rec.information27 = hr_api.g_varchar2) then
420: p_rec.information27 := hr_trs_shd.g_old_rec.information27;
421: End If;
422: If (p_rec.information28 = hr_api.g_varchar2) then
423: p_rec.information28 := hr_trs_shd.g_old_rec.information28;
424: End If;
425: If (p_rec.information29 = hr_api.g_varchar2) then
426: p_rec.information29 := hr_trs_shd.g_old_rec.information29;
427: End If;

Line 426: p_rec.information29 := hr_trs_shd.g_old_rec.information29;

422: If (p_rec.information28 = hr_api.g_varchar2) then
423: p_rec.information28 := hr_trs_shd.g_old_rec.information28;
424: End If;
425: If (p_rec.information29 = hr_api.g_varchar2) then
426: p_rec.information29 := hr_trs_shd.g_old_rec.information29;
427: End If;
428: If (p_rec.information30 = hr_api.g_varchar2) then
429: p_rec.information30 := hr_trs_shd.g_old_rec.information30;
430: End If;

Line 429: p_rec.information30 := hr_trs_shd.g_old_rec.information30;

425: If (p_rec.information29 = hr_api.g_varchar2) then
426: p_rec.information29 := hr_trs_shd.g_old_rec.information29;
427: End If;
428: If (p_rec.information30 = hr_api.g_varchar2) then
429: p_rec.information30 := hr_trs_shd.g_old_rec.information30;
430: End If;
431:
432:
433: --

Line 443: p_rec in out nocopy hr_trs_shd.g_rec_type,

439: -- |---------------------------------< upd >----------------------------------|
440: -- ----------------------------------------------------------------------------
441: Procedure upd
442: (
443: p_rec in out nocopy hr_trs_shd.g_rec_type,
444: p_validate in boolean default false
445: ) is
446: --
447: l_proc varchar2(72) := g_package||'upd';

Line 463: hr_trs_shd.lck

459: End If;
460: --
461: -- We must lock the row which we need to update.
462: --
463: hr_trs_shd.lck
464: (
465: p_rec.transaction_step_id,
466: p_rec.object_version_number
467: );

Line 568: l_rec hr_trs_shd.g_rec_type;

564:
565:
566: ) is
567: --
568: l_rec hr_trs_shd.g_rec_type;
569: l_proc varchar2(72) := g_package||'upd';
570: --
571: Begin
572: hr_utility.set_location('Entering:'||l_proc, 5);

Line 578: hr_trs_shd.convert_args

574: -- Call conversion function to turn arguments into the
575: -- l_rec structure.
576: --
577: l_rec :=
578: hr_trs_shd.convert_args
579: (
580: p_transaction_step_id,
581: p_transaction_id,
582: p_api_name,