[Home] [Help]
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy psp_pee_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --
110: Exception
111: When hr_api.check_integrity_violated Then
112: -- A check constraint has been violated
113: --
114: psp_pee_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.parent_integrity_violated Then
117: -- Parent integrity has been violated
118: --
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.parent_integrity_violated Then
117: -- Parent integrity has been violated
118: --
119: psp_pee_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When hr_api.unique_integrity_violated Then
122: -- Unique integrity has been violated
123: --
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When hr_api.unique_integrity_violated Then
122: -- Unique integrity has been violated
123: --
124: psp_pee_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When Others Then
127: --
128: Raise;
160: --
161: -- {End Of Comments}
162: -- ----------------------------------------------------------------------------
163: Procedure pre_update
164: (p_rec in psp_pee_shd.g_rec_type
165: ) is
166: --
167: l_proc varchar2(72) := g_package||'pre_update';
168: --
204: --
205: -- {End Of Comments}
206: -- ----------------------------------------------------------------------------
207: Procedure post_update
208: (p_rec in psp_pee_shd.g_rec_type
209: ) is
210: --
211: l_proc varchar2(72) := g_package||'post_update';
212: --
279: => p_rec.attribute14
280: ,p_attribute15
281: => p_rec.attribute15
282: ,p_batch_name_o
283: => psp_pee_shd.g_old_rec.batch_name
284: ,p_object_version_number_o
285: => psp_pee_shd.g_old_rec.object_version_number
286: ,p_distribution_date_o
287: => psp_pee_shd.g_old_rec.distribution_date
281: => p_rec.attribute15
282: ,p_batch_name_o
283: => psp_pee_shd.g_old_rec.batch_name
284: ,p_object_version_number_o
285: => psp_pee_shd.g_old_rec.object_version_number
286: ,p_distribution_date_o
287: => psp_pee_shd.g_old_rec.distribution_date
288: ,p_person_id_o
289: => psp_pee_shd.g_old_rec.person_id
283: => psp_pee_shd.g_old_rec.batch_name
284: ,p_object_version_number_o
285: => psp_pee_shd.g_old_rec.object_version_number
286: ,p_distribution_date_o
287: => psp_pee_shd.g_old_rec.distribution_date
288: ,p_person_id_o
289: => psp_pee_shd.g_old_rec.person_id
290: ,p_assignment_id_o
291: => psp_pee_shd.g_old_rec.assignment_id
285: => psp_pee_shd.g_old_rec.object_version_number
286: ,p_distribution_date_o
287: => psp_pee_shd.g_old_rec.distribution_date
288: ,p_person_id_o
289: => psp_pee_shd.g_old_rec.person_id
290: ,p_assignment_id_o
291: => psp_pee_shd.g_old_rec.assignment_id
292: ,p_currency_code_o
293: => psp_pee_shd.g_old_rec.currency_code
287: => psp_pee_shd.g_old_rec.distribution_date
288: ,p_person_id_o
289: => psp_pee_shd.g_old_rec.person_id
290: ,p_assignment_id_o
291: => psp_pee_shd.g_old_rec.assignment_id
292: ,p_currency_code_o
293: => psp_pee_shd.g_old_rec.currency_code
294: ,p_distribution_amount_o
295: => psp_pee_shd.g_old_rec.distribution_amount
289: => psp_pee_shd.g_old_rec.person_id
290: ,p_assignment_id_o
291: => psp_pee_shd.g_old_rec.assignment_id
292: ,p_currency_code_o
293: => psp_pee_shd.g_old_rec.currency_code
294: ,p_distribution_amount_o
295: => psp_pee_shd.g_old_rec.distribution_amount
296: ,p_business_group_id_o
297: => psp_pee_shd.g_old_rec.business_group_id
291: => psp_pee_shd.g_old_rec.assignment_id
292: ,p_currency_code_o
293: => psp_pee_shd.g_old_rec.currency_code
294: ,p_distribution_amount_o
295: => psp_pee_shd.g_old_rec.distribution_amount
296: ,p_business_group_id_o
297: => psp_pee_shd.g_old_rec.business_group_id
298: ,p_set_of_books_id_o
299: => psp_pee_shd.g_old_rec.set_of_books_id
293: => psp_pee_shd.g_old_rec.currency_code
294: ,p_distribution_amount_o
295: => psp_pee_shd.g_old_rec.distribution_amount
296: ,p_business_group_id_o
297: => psp_pee_shd.g_old_rec.business_group_id
298: ,p_set_of_books_id_o
299: => psp_pee_shd.g_old_rec.set_of_books_id
300: ,p_gl_code_combination_id_o
301: => psp_pee_shd.g_old_rec.gl_code_combination_id
295: => psp_pee_shd.g_old_rec.distribution_amount
296: ,p_business_group_id_o
297: => psp_pee_shd.g_old_rec.business_group_id
298: ,p_set_of_books_id_o
299: => psp_pee_shd.g_old_rec.set_of_books_id
300: ,p_gl_code_combination_id_o
301: => psp_pee_shd.g_old_rec.gl_code_combination_id
302: ,p_project_id_o
303: => psp_pee_shd.g_old_rec.project_id
297: => psp_pee_shd.g_old_rec.business_group_id
298: ,p_set_of_books_id_o
299: => psp_pee_shd.g_old_rec.set_of_books_id
300: ,p_gl_code_combination_id_o
301: => psp_pee_shd.g_old_rec.gl_code_combination_id
302: ,p_project_id_o
303: => psp_pee_shd.g_old_rec.project_id
304: ,p_task_id_o
305: => psp_pee_shd.g_old_rec.task_id
299: => psp_pee_shd.g_old_rec.set_of_books_id
300: ,p_gl_code_combination_id_o
301: => psp_pee_shd.g_old_rec.gl_code_combination_id
302: ,p_project_id_o
303: => psp_pee_shd.g_old_rec.project_id
304: ,p_task_id_o
305: => psp_pee_shd.g_old_rec.task_id
306: ,p_award_id_o
307: => psp_pee_shd.g_old_rec.award_id
301: => psp_pee_shd.g_old_rec.gl_code_combination_id
302: ,p_project_id_o
303: => psp_pee_shd.g_old_rec.project_id
304: ,p_task_id_o
305: => psp_pee_shd.g_old_rec.task_id
306: ,p_award_id_o
307: => psp_pee_shd.g_old_rec.award_id
308: ,p_expenditure_organization_i_o
309: => psp_pee_shd.g_old_rec.expenditure_organization_id
303: => psp_pee_shd.g_old_rec.project_id
304: ,p_task_id_o
305: => psp_pee_shd.g_old_rec.task_id
306: ,p_award_id_o
307: => psp_pee_shd.g_old_rec.award_id
308: ,p_expenditure_organization_i_o
309: => psp_pee_shd.g_old_rec.expenditure_organization_id
310: ,p_expenditure_type_o
311: => psp_pee_shd.g_old_rec.expenditure_type
305: => psp_pee_shd.g_old_rec.task_id
306: ,p_award_id_o
307: => psp_pee_shd.g_old_rec.award_id
308: ,p_expenditure_organization_i_o
309: => psp_pee_shd.g_old_rec.expenditure_organization_id
310: ,p_expenditure_type_o
311: => psp_pee_shd.g_old_rec.expenditure_type
312: ,p_attribute_category_o
313: => psp_pee_shd.g_old_rec.attribute_category
307: => psp_pee_shd.g_old_rec.award_id
308: ,p_expenditure_organization_i_o
309: => psp_pee_shd.g_old_rec.expenditure_organization_id
310: ,p_expenditure_type_o
311: => psp_pee_shd.g_old_rec.expenditure_type
312: ,p_attribute_category_o
313: => psp_pee_shd.g_old_rec.attribute_category
314: ,p_attribute1_o
315: => psp_pee_shd.g_old_rec.attribute1
309: => psp_pee_shd.g_old_rec.expenditure_organization_id
310: ,p_expenditure_type_o
311: => psp_pee_shd.g_old_rec.expenditure_type
312: ,p_attribute_category_o
313: => psp_pee_shd.g_old_rec.attribute_category
314: ,p_attribute1_o
315: => psp_pee_shd.g_old_rec.attribute1
316: ,p_attribute2_o
317: => psp_pee_shd.g_old_rec.attribute2
311: => psp_pee_shd.g_old_rec.expenditure_type
312: ,p_attribute_category_o
313: => psp_pee_shd.g_old_rec.attribute_category
314: ,p_attribute1_o
315: => psp_pee_shd.g_old_rec.attribute1
316: ,p_attribute2_o
317: => psp_pee_shd.g_old_rec.attribute2
318: ,p_attribute3_o
319: => psp_pee_shd.g_old_rec.attribute3
313: => psp_pee_shd.g_old_rec.attribute_category
314: ,p_attribute1_o
315: => psp_pee_shd.g_old_rec.attribute1
316: ,p_attribute2_o
317: => psp_pee_shd.g_old_rec.attribute2
318: ,p_attribute3_o
319: => psp_pee_shd.g_old_rec.attribute3
320: ,p_attribute4_o
321: => psp_pee_shd.g_old_rec.attribute4
315: => psp_pee_shd.g_old_rec.attribute1
316: ,p_attribute2_o
317: => psp_pee_shd.g_old_rec.attribute2
318: ,p_attribute3_o
319: => psp_pee_shd.g_old_rec.attribute3
320: ,p_attribute4_o
321: => psp_pee_shd.g_old_rec.attribute4
322: ,p_attribute5_o
323: => psp_pee_shd.g_old_rec.attribute5
317: => psp_pee_shd.g_old_rec.attribute2
318: ,p_attribute3_o
319: => psp_pee_shd.g_old_rec.attribute3
320: ,p_attribute4_o
321: => psp_pee_shd.g_old_rec.attribute4
322: ,p_attribute5_o
323: => psp_pee_shd.g_old_rec.attribute5
324: ,p_attribute6_o
325: => psp_pee_shd.g_old_rec.attribute6
319: => psp_pee_shd.g_old_rec.attribute3
320: ,p_attribute4_o
321: => psp_pee_shd.g_old_rec.attribute4
322: ,p_attribute5_o
323: => psp_pee_shd.g_old_rec.attribute5
324: ,p_attribute6_o
325: => psp_pee_shd.g_old_rec.attribute6
326: ,p_attribute7_o
327: => psp_pee_shd.g_old_rec.attribute7
321: => psp_pee_shd.g_old_rec.attribute4
322: ,p_attribute5_o
323: => psp_pee_shd.g_old_rec.attribute5
324: ,p_attribute6_o
325: => psp_pee_shd.g_old_rec.attribute6
326: ,p_attribute7_o
327: => psp_pee_shd.g_old_rec.attribute7
328: ,p_attribute8_o
329: => psp_pee_shd.g_old_rec.attribute8
323: => psp_pee_shd.g_old_rec.attribute5
324: ,p_attribute6_o
325: => psp_pee_shd.g_old_rec.attribute6
326: ,p_attribute7_o
327: => psp_pee_shd.g_old_rec.attribute7
328: ,p_attribute8_o
329: => psp_pee_shd.g_old_rec.attribute8
330: ,p_attribute9_o
331: => psp_pee_shd.g_old_rec.attribute9
325: => psp_pee_shd.g_old_rec.attribute6
326: ,p_attribute7_o
327: => psp_pee_shd.g_old_rec.attribute7
328: ,p_attribute8_o
329: => psp_pee_shd.g_old_rec.attribute8
330: ,p_attribute9_o
331: => psp_pee_shd.g_old_rec.attribute9
332: ,p_attribute10_o
333: => psp_pee_shd.g_old_rec.attribute10
327: => psp_pee_shd.g_old_rec.attribute7
328: ,p_attribute8_o
329: => psp_pee_shd.g_old_rec.attribute8
330: ,p_attribute9_o
331: => psp_pee_shd.g_old_rec.attribute9
332: ,p_attribute10_o
333: => psp_pee_shd.g_old_rec.attribute10
334: ,p_attribute11_o
335: => psp_pee_shd.g_old_rec.attribute11
329: => psp_pee_shd.g_old_rec.attribute8
330: ,p_attribute9_o
331: => psp_pee_shd.g_old_rec.attribute9
332: ,p_attribute10_o
333: => psp_pee_shd.g_old_rec.attribute10
334: ,p_attribute11_o
335: => psp_pee_shd.g_old_rec.attribute11
336: ,p_attribute12_o
337: => psp_pee_shd.g_old_rec.attribute12
331: => psp_pee_shd.g_old_rec.attribute9
332: ,p_attribute10_o
333: => psp_pee_shd.g_old_rec.attribute10
334: ,p_attribute11_o
335: => psp_pee_shd.g_old_rec.attribute11
336: ,p_attribute12_o
337: => psp_pee_shd.g_old_rec.attribute12
338: ,p_attribute13_o
339: => psp_pee_shd.g_old_rec.attribute13
333: => psp_pee_shd.g_old_rec.attribute10
334: ,p_attribute11_o
335: => psp_pee_shd.g_old_rec.attribute11
336: ,p_attribute12_o
337: => psp_pee_shd.g_old_rec.attribute12
338: ,p_attribute13_o
339: => psp_pee_shd.g_old_rec.attribute13
340: ,p_attribute14_o
341: => psp_pee_shd.g_old_rec.attribute14
335: => psp_pee_shd.g_old_rec.attribute11
336: ,p_attribute12_o
337: => psp_pee_shd.g_old_rec.attribute12
338: ,p_attribute13_o
339: => psp_pee_shd.g_old_rec.attribute13
340: ,p_attribute14_o
341: => psp_pee_shd.g_old_rec.attribute14
342: ,p_attribute15_o
343: => psp_pee_shd.g_old_rec.attribute15
337: => psp_pee_shd.g_old_rec.attribute12
338: ,p_attribute13_o
339: => psp_pee_shd.g_old_rec.attribute13
340: ,p_attribute14_o
341: => psp_pee_shd.g_old_rec.attribute14
342: ,p_attribute15_o
343: => psp_pee_shd.g_old_rec.attribute15
344: );
345: --
339: => psp_pee_shd.g_old_rec.attribute13
340: ,p_attribute14_o
341: => psp_pee_shd.g_old_rec.attribute14
342: ,p_attribute15_o
343: => psp_pee_shd.g_old_rec.attribute15
344: );
345: --
346: exception
347: --
399: --
400: -- {End Of Comments}
401: -- ----------------------------------------------------------------------------
402: Procedure convert_defs
403: (p_rec in out nocopy psp_pee_shd.g_rec_type
404: ) is
405: --
406: Begin
407: --
411: -- is being used then we must set to the 'current' argument value.
412: --
413: If (p_rec.batch_name = hr_api.g_varchar2) then
414: p_rec.batch_name :=
415: psp_pee_shd.g_old_rec.batch_name;
416: End If;
417: If (p_rec.distribution_date = hr_api.g_date) then
418: p_rec.distribution_date :=
419: psp_pee_shd.g_old_rec.distribution_date;
415: psp_pee_shd.g_old_rec.batch_name;
416: End If;
417: If (p_rec.distribution_date = hr_api.g_date) then
418: p_rec.distribution_date :=
419: psp_pee_shd.g_old_rec.distribution_date;
420: End If;
421: If (p_rec.person_id = hr_api.g_number) then
422: p_rec.person_id :=
423: psp_pee_shd.g_old_rec.person_id;
419: psp_pee_shd.g_old_rec.distribution_date;
420: End If;
421: If (p_rec.person_id = hr_api.g_number) then
422: p_rec.person_id :=
423: psp_pee_shd.g_old_rec.person_id;
424: End If;
425: If (p_rec.assignment_id = hr_api.g_number) then
426: p_rec.assignment_id :=
427: psp_pee_shd.g_old_rec.assignment_id;
423: psp_pee_shd.g_old_rec.person_id;
424: End If;
425: If (p_rec.assignment_id = hr_api.g_number) then
426: p_rec.assignment_id :=
427: psp_pee_shd.g_old_rec.assignment_id;
428: End If;
429: If (p_rec.currency_code = hr_api.g_varchar2) then
430: p_rec.currency_code :=
431: psp_pee_shd.g_old_rec.currency_code;
427: psp_pee_shd.g_old_rec.assignment_id;
428: End If;
429: If (p_rec.currency_code = hr_api.g_varchar2) then
430: p_rec.currency_code :=
431: psp_pee_shd.g_old_rec.currency_code;
432: End If;
433: If (p_rec.distribution_amount = hr_api.g_number) then
434: p_rec.distribution_amount :=
435: psp_pee_shd.g_old_rec.distribution_amount;
431: psp_pee_shd.g_old_rec.currency_code;
432: End If;
433: If (p_rec.distribution_amount = hr_api.g_number) then
434: p_rec.distribution_amount :=
435: psp_pee_shd.g_old_rec.distribution_amount;
436: End If;
437: If (p_rec.business_group_id = hr_api.g_number) then
438: p_rec.business_group_id :=
439: psp_pee_shd.g_old_rec.business_group_id;
435: psp_pee_shd.g_old_rec.distribution_amount;
436: End If;
437: If (p_rec.business_group_id = hr_api.g_number) then
438: p_rec.business_group_id :=
439: psp_pee_shd.g_old_rec.business_group_id;
440: End If;
441: If (p_rec.set_of_books_id = hr_api.g_number) then
442: p_rec.set_of_books_id :=
443: psp_pee_shd.g_old_rec.set_of_books_id;
439: psp_pee_shd.g_old_rec.business_group_id;
440: End If;
441: If (p_rec.set_of_books_id = hr_api.g_number) then
442: p_rec.set_of_books_id :=
443: psp_pee_shd.g_old_rec.set_of_books_id;
444: End If;
445: If (p_rec.gl_code_combination_id = hr_api.g_number) then
446: p_rec.gl_code_combination_id :=
447: psp_pee_shd.g_old_rec.gl_code_combination_id;
443: psp_pee_shd.g_old_rec.set_of_books_id;
444: End If;
445: If (p_rec.gl_code_combination_id = hr_api.g_number) then
446: p_rec.gl_code_combination_id :=
447: psp_pee_shd.g_old_rec.gl_code_combination_id;
448: End If;
449: If (p_rec.project_id = hr_api.g_number) then
450: p_rec.project_id :=
451: psp_pee_shd.g_old_rec.project_id;
447: psp_pee_shd.g_old_rec.gl_code_combination_id;
448: End If;
449: If (p_rec.project_id = hr_api.g_number) then
450: p_rec.project_id :=
451: psp_pee_shd.g_old_rec.project_id;
452: End If;
453: If (p_rec.task_id = hr_api.g_number) then
454: p_rec.task_id :=
455: psp_pee_shd.g_old_rec.task_id;
451: psp_pee_shd.g_old_rec.project_id;
452: End If;
453: If (p_rec.task_id = hr_api.g_number) then
454: p_rec.task_id :=
455: psp_pee_shd.g_old_rec.task_id;
456: End If;
457: If (p_rec.award_id = hr_api.g_number) then
458: p_rec.award_id :=
459: psp_pee_shd.g_old_rec.award_id;
455: psp_pee_shd.g_old_rec.task_id;
456: End If;
457: If (p_rec.award_id = hr_api.g_number) then
458: p_rec.award_id :=
459: psp_pee_shd.g_old_rec.award_id;
460: End If;
461: If (p_rec.expenditure_organization_id = hr_api.g_number) then
462: p_rec.expenditure_organization_id :=
463: psp_pee_shd.g_old_rec.expenditure_organization_id;
459: psp_pee_shd.g_old_rec.award_id;
460: End If;
461: If (p_rec.expenditure_organization_id = hr_api.g_number) then
462: p_rec.expenditure_organization_id :=
463: psp_pee_shd.g_old_rec.expenditure_organization_id;
464: End If;
465: If (p_rec.expenditure_type = hr_api.g_varchar2) then
466: p_rec.expenditure_type :=
467: psp_pee_shd.g_old_rec.expenditure_type;
463: psp_pee_shd.g_old_rec.expenditure_organization_id;
464: End If;
465: If (p_rec.expenditure_type = hr_api.g_varchar2) then
466: p_rec.expenditure_type :=
467: psp_pee_shd.g_old_rec.expenditure_type;
468: End If;
469: If (p_rec.attribute_category = hr_api.g_varchar2) then
470: p_rec.attribute_category :=
471: psp_pee_shd.g_old_rec.attribute_category;
467: psp_pee_shd.g_old_rec.expenditure_type;
468: End If;
469: If (p_rec.attribute_category = hr_api.g_varchar2) then
470: p_rec.attribute_category :=
471: psp_pee_shd.g_old_rec.attribute_category;
472: End If;
473: If (p_rec.attribute1 = hr_api.g_varchar2) then
474: p_rec.attribute1 :=
475: psp_pee_shd.g_old_rec.attribute1;
471: psp_pee_shd.g_old_rec.attribute_category;
472: End If;
473: If (p_rec.attribute1 = hr_api.g_varchar2) then
474: p_rec.attribute1 :=
475: psp_pee_shd.g_old_rec.attribute1;
476: End If;
477: If (p_rec.attribute2 = hr_api.g_varchar2) then
478: p_rec.attribute2 :=
479: psp_pee_shd.g_old_rec.attribute2;
475: psp_pee_shd.g_old_rec.attribute1;
476: End If;
477: If (p_rec.attribute2 = hr_api.g_varchar2) then
478: p_rec.attribute2 :=
479: psp_pee_shd.g_old_rec.attribute2;
480: End If;
481: If (p_rec.attribute3 = hr_api.g_varchar2) then
482: p_rec.attribute3 :=
483: psp_pee_shd.g_old_rec.attribute3;
479: psp_pee_shd.g_old_rec.attribute2;
480: End If;
481: If (p_rec.attribute3 = hr_api.g_varchar2) then
482: p_rec.attribute3 :=
483: psp_pee_shd.g_old_rec.attribute3;
484: End If;
485: If (p_rec.attribute4 = hr_api.g_varchar2) then
486: p_rec.attribute4 :=
487: psp_pee_shd.g_old_rec.attribute4;
483: psp_pee_shd.g_old_rec.attribute3;
484: End If;
485: If (p_rec.attribute4 = hr_api.g_varchar2) then
486: p_rec.attribute4 :=
487: psp_pee_shd.g_old_rec.attribute4;
488: End If;
489: If (p_rec.attribute5 = hr_api.g_varchar2) then
490: p_rec.attribute5 :=
491: psp_pee_shd.g_old_rec.attribute5;
487: psp_pee_shd.g_old_rec.attribute4;
488: End If;
489: If (p_rec.attribute5 = hr_api.g_varchar2) then
490: p_rec.attribute5 :=
491: psp_pee_shd.g_old_rec.attribute5;
492: End If;
493: If (p_rec.attribute6 = hr_api.g_varchar2) then
494: p_rec.attribute6 :=
495: psp_pee_shd.g_old_rec.attribute6;
491: psp_pee_shd.g_old_rec.attribute5;
492: End If;
493: If (p_rec.attribute6 = hr_api.g_varchar2) then
494: p_rec.attribute6 :=
495: psp_pee_shd.g_old_rec.attribute6;
496: End If;
497: If (p_rec.attribute7 = hr_api.g_varchar2) then
498: p_rec.attribute7 :=
499: psp_pee_shd.g_old_rec.attribute7;
495: psp_pee_shd.g_old_rec.attribute6;
496: End If;
497: If (p_rec.attribute7 = hr_api.g_varchar2) then
498: p_rec.attribute7 :=
499: psp_pee_shd.g_old_rec.attribute7;
500: End If;
501: If (p_rec.attribute8 = hr_api.g_varchar2) then
502: p_rec.attribute8 :=
503: psp_pee_shd.g_old_rec.attribute8;
499: psp_pee_shd.g_old_rec.attribute7;
500: End If;
501: If (p_rec.attribute8 = hr_api.g_varchar2) then
502: p_rec.attribute8 :=
503: psp_pee_shd.g_old_rec.attribute8;
504: End If;
505: If (p_rec.attribute9 = hr_api.g_varchar2) then
506: p_rec.attribute9 :=
507: psp_pee_shd.g_old_rec.attribute9;
503: psp_pee_shd.g_old_rec.attribute8;
504: End If;
505: If (p_rec.attribute9 = hr_api.g_varchar2) then
506: p_rec.attribute9 :=
507: psp_pee_shd.g_old_rec.attribute9;
508: End If;
509: If (p_rec.attribute10 = hr_api.g_varchar2) then
510: p_rec.attribute10 :=
511: psp_pee_shd.g_old_rec.attribute10;
507: psp_pee_shd.g_old_rec.attribute9;
508: End If;
509: If (p_rec.attribute10 = hr_api.g_varchar2) then
510: p_rec.attribute10 :=
511: psp_pee_shd.g_old_rec.attribute10;
512: End If;
513: If (p_rec.attribute11 = hr_api.g_varchar2) then
514: p_rec.attribute11 :=
515: psp_pee_shd.g_old_rec.attribute11;
511: psp_pee_shd.g_old_rec.attribute10;
512: End If;
513: If (p_rec.attribute11 = hr_api.g_varchar2) then
514: p_rec.attribute11 :=
515: psp_pee_shd.g_old_rec.attribute11;
516: End If;
517: If (p_rec.attribute12 = hr_api.g_varchar2) then
518: p_rec.attribute12 :=
519: psp_pee_shd.g_old_rec.attribute12;
515: psp_pee_shd.g_old_rec.attribute11;
516: End If;
517: If (p_rec.attribute12 = hr_api.g_varchar2) then
518: p_rec.attribute12 :=
519: psp_pee_shd.g_old_rec.attribute12;
520: End If;
521: If (p_rec.attribute13 = hr_api.g_varchar2) then
522: p_rec.attribute13 :=
523: psp_pee_shd.g_old_rec.attribute13;
519: psp_pee_shd.g_old_rec.attribute12;
520: End If;
521: If (p_rec.attribute13 = hr_api.g_varchar2) then
522: p_rec.attribute13 :=
523: psp_pee_shd.g_old_rec.attribute13;
524: End If;
525: If (p_rec.attribute14 = hr_api.g_varchar2) then
526: p_rec.attribute14 :=
527: psp_pee_shd.g_old_rec.attribute14;
523: psp_pee_shd.g_old_rec.attribute13;
524: End If;
525: If (p_rec.attribute14 = hr_api.g_varchar2) then
526: p_rec.attribute14 :=
527: psp_pee_shd.g_old_rec.attribute14;
528: End If;
529: If (p_rec.attribute15 = hr_api.g_varchar2) then
530: p_rec.attribute15 :=
531: psp_pee_shd.g_old_rec.attribute15;
527: psp_pee_shd.g_old_rec.attribute14;
528: End If;
529: If (p_rec.attribute15 = hr_api.g_varchar2) then
530: p_rec.attribute15 :=
531: psp_pee_shd.g_old_rec.attribute15;
532: End If;
533: --
534: End convert_defs;
535: --
536: -- ----------------------------------------------------------------------------
537: -- |---------------------------------< upd >----------------------------------|
538: -- ----------------------------------------------------------------------------
539: Procedure upd
540: (p_rec in out nocopy psp_pee_shd.g_rec_type
541: ) is
542: --
543: l_proc varchar2(72) := g_package||'upd';
544: --
546: hr_utility.set_location('Entering:'||l_proc, 5);
547: --
548: -- We must lock the row which we need to update.
549: --
550: psp_pee_shd.lck
551: (p_rec.external_effort_line_id
552: ,p_rec.object_version_number
553: );
554: --
621: ,p_attribute14 in varchar2 default hr_api.g_varchar2
622: ,p_attribute15 in varchar2 default hr_api.g_varchar2
623: ) is
624: --
625: l_rec psp_pee_shd.g_rec_type;
626: l_proc varchar2(72) := g_package||'upd';
627: --
628: Begin
629: hr_utility.set_location('Entering:'||l_proc, 5);
631: -- Call conversion function to turn arguments into the
632: -- l_rec structure.
633: --
634: l_rec :=
635: psp_pee_shd.convert_args
636: (p_external_effort_line_id
637: ,p_batch_name
638: ,p_object_version_number
639: ,p_distribution_date