[Home] [Help]
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy pqp_shp_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --
62: --
63: -- Increment the object version
64: p_rec.object_version_number := p_rec.object_version_number + 1;
65: --
66: pqp_shp_shd.g_api_dml := true; -- Set the api dml status
67: --
68: -- Update the pqp_service_history_periods Row
69: --
70: update pqp_service_history_periods
127: ,shp_information19 = p_rec.shp_information19
128: ,shp_information20 = p_rec.shp_information20
129: where service_history_period_id = p_rec.service_history_period_id;
130: --
131: pqp_shp_shd.g_api_dml := false; -- Unset the api dml status
132: --
133: hr_utility.set_location(' Leaving:'||l_proc, 10);
134: --
135: Exception
134: --
135: Exception
136: When hr_api.check_integrity_violated Then
137: -- A check constraint has been violated
138: pqp_shp_shd.g_api_dml := false; -- Unset the api dml status
139: pqp_shp_shd.constraint_error
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
141: When hr_api.parent_integrity_violated Then
142: -- Parent integrity has been violated
135: Exception
136: When hr_api.check_integrity_violated Then
137: -- A check constraint has been violated
138: pqp_shp_shd.g_api_dml := false; -- Unset the api dml status
139: pqp_shp_shd.constraint_error
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
141: When hr_api.parent_integrity_violated Then
142: -- Parent integrity has been violated
143: pqp_shp_shd.g_api_dml := false; -- Unset the api dml status
139: pqp_shp_shd.constraint_error
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
141: When hr_api.parent_integrity_violated Then
142: -- Parent integrity has been violated
143: pqp_shp_shd.g_api_dml := false; -- Unset the api dml status
144: pqp_shp_shd.constraint_error
145: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
146: When hr_api.unique_integrity_violated Then
147: -- Unique integrity has been violated
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
141: When hr_api.parent_integrity_violated Then
142: -- Parent integrity has been violated
143: pqp_shp_shd.g_api_dml := false; -- Unset the api dml status
144: pqp_shp_shd.constraint_error
145: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
146: When hr_api.unique_integrity_violated Then
147: -- Unique integrity has been violated
148: pqp_shp_shd.g_api_dml := false; -- Unset the api dml status
144: pqp_shp_shd.constraint_error
145: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
146: When hr_api.unique_integrity_violated Then
147: -- Unique integrity has been violated
148: pqp_shp_shd.g_api_dml := false; -- Unset the api dml status
149: pqp_shp_shd.constraint_error
150: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
151: When Others Then
152: pqp_shp_shd.g_api_dml := false; -- Unset the api dml status
145: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
146: When hr_api.unique_integrity_violated Then
147: -- Unique integrity has been violated
148: pqp_shp_shd.g_api_dml := false; -- Unset the api dml status
149: pqp_shp_shd.constraint_error
150: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
151: When Others Then
152: pqp_shp_shd.g_api_dml := false; -- Unset the api dml status
153: Raise;
148: pqp_shp_shd.g_api_dml := false; -- Unset the api dml status
149: pqp_shp_shd.constraint_error
150: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
151: When Others Then
152: pqp_shp_shd.g_api_dml := false; -- Unset the api dml status
153: Raise;
154: End update_dml;
155: --
156: -- ----------------------------------------------------------------------------
185: --
186: -- {End Of Comments}
187: -- ----------------------------------------------------------------------------
188: Procedure pre_update
189: (p_rec in pqp_shp_shd.g_rec_type
190: ) is
191: --
192: l_proc varchar2(72) := g_package||'pre_update';
193: --
230: -- {End Of Comments}
231: -- ----------------------------------------------------------------------------
232: Procedure post_update
233: (
234: p_rec in pqp_shp_shd.g_rec_type
235: ) is
236: --
237: l_proc varchar2(72) := g_package||'post_update';
238: --
355: => p_rec.shp_information19
356: ,p_shp_information20
357: => p_rec.shp_information20
358: ,p_business_group_id_o
359: => pqp_shp_shd.g_old_rec.business_group_id
360: ,p_assignment_id_o
361: => pqp_shp_shd.g_old_rec.assignment_id
362: ,p_start_date_o
363: => pqp_shp_shd.g_old_rec.start_date
357: => p_rec.shp_information20
358: ,p_business_group_id_o
359: => pqp_shp_shd.g_old_rec.business_group_id
360: ,p_assignment_id_o
361: => pqp_shp_shd.g_old_rec.assignment_id
362: ,p_start_date_o
363: => pqp_shp_shd.g_old_rec.start_date
364: ,p_end_date_o
365: => pqp_shp_shd.g_old_rec.end_date
359: => pqp_shp_shd.g_old_rec.business_group_id
360: ,p_assignment_id_o
361: => pqp_shp_shd.g_old_rec.assignment_id
362: ,p_start_date_o
363: => pqp_shp_shd.g_old_rec.start_date
364: ,p_end_date_o
365: => pqp_shp_shd.g_old_rec.end_date
366: ,p_employer_name_o
367: => pqp_shp_shd.g_old_rec.employer_name
361: => pqp_shp_shd.g_old_rec.assignment_id
362: ,p_start_date_o
363: => pqp_shp_shd.g_old_rec.start_date
364: ,p_end_date_o
365: => pqp_shp_shd.g_old_rec.end_date
366: ,p_employer_name_o
367: => pqp_shp_shd.g_old_rec.employer_name
368: ,p_employer_address_o
369: => pqp_shp_shd.g_old_rec.employer_address
363: => pqp_shp_shd.g_old_rec.start_date
364: ,p_end_date_o
365: => pqp_shp_shd.g_old_rec.end_date
366: ,p_employer_name_o
367: => pqp_shp_shd.g_old_rec.employer_name
368: ,p_employer_address_o
369: => pqp_shp_shd.g_old_rec.employer_address
370: ,p_employer_type_o
371: => pqp_shp_shd.g_old_rec.employer_type
365: => pqp_shp_shd.g_old_rec.end_date
366: ,p_employer_name_o
367: => pqp_shp_shd.g_old_rec.employer_name
368: ,p_employer_address_o
369: => pqp_shp_shd.g_old_rec.employer_address
370: ,p_employer_type_o
371: => pqp_shp_shd.g_old_rec.employer_type
372: ,p_employer_subtype_o
373: => pqp_shp_shd.g_old_rec.employer_subtype
367: => pqp_shp_shd.g_old_rec.employer_name
368: ,p_employer_address_o
369: => pqp_shp_shd.g_old_rec.employer_address
370: ,p_employer_type_o
371: => pqp_shp_shd.g_old_rec.employer_type
372: ,p_employer_subtype_o
373: => pqp_shp_shd.g_old_rec.employer_subtype
374: ,p_period_years_o
375: => pqp_shp_shd.g_old_rec.period_years
369: => pqp_shp_shd.g_old_rec.employer_address
370: ,p_employer_type_o
371: => pqp_shp_shd.g_old_rec.employer_type
372: ,p_employer_subtype_o
373: => pqp_shp_shd.g_old_rec.employer_subtype
374: ,p_period_years_o
375: => pqp_shp_shd.g_old_rec.period_years
376: ,p_period_days_o
377: => pqp_shp_shd.g_old_rec.period_days
371: => pqp_shp_shd.g_old_rec.employer_type
372: ,p_employer_subtype_o
373: => pqp_shp_shd.g_old_rec.employer_subtype
374: ,p_period_years_o
375: => pqp_shp_shd.g_old_rec.period_years
376: ,p_period_days_o
377: => pqp_shp_shd.g_old_rec.period_days
378: ,p_description_o
379: => pqp_shp_shd.g_old_rec.description
373: => pqp_shp_shd.g_old_rec.employer_subtype
374: ,p_period_years_o
375: => pqp_shp_shd.g_old_rec.period_years
376: ,p_period_days_o
377: => pqp_shp_shd.g_old_rec.period_days
378: ,p_description_o
379: => pqp_shp_shd.g_old_rec.description
380: ,p_continuous_service_o
381: => pqp_shp_shd.g_old_rec.continuous_service
375: => pqp_shp_shd.g_old_rec.period_years
376: ,p_period_days_o
377: => pqp_shp_shd.g_old_rec.period_days
378: ,p_description_o
379: => pqp_shp_shd.g_old_rec.description
380: ,p_continuous_service_o
381: => pqp_shp_shd.g_old_rec.continuous_service
382: ,p_all_assignments_o
383: => pqp_shp_shd.g_old_rec.all_assignments
377: => pqp_shp_shd.g_old_rec.period_days
378: ,p_description_o
379: => pqp_shp_shd.g_old_rec.description
380: ,p_continuous_service_o
381: => pqp_shp_shd.g_old_rec.continuous_service
382: ,p_all_assignments_o
383: => pqp_shp_shd.g_old_rec.all_assignments
384: ,p_object_version_number_o
385: => pqp_shp_shd.g_old_rec.object_version_number
379: => pqp_shp_shd.g_old_rec.description
380: ,p_continuous_service_o
381: => pqp_shp_shd.g_old_rec.continuous_service
382: ,p_all_assignments_o
383: => pqp_shp_shd.g_old_rec.all_assignments
384: ,p_object_version_number_o
385: => pqp_shp_shd.g_old_rec.object_version_number
386: ,p_shp_attribute_category_o
387: => pqp_shp_shd.g_old_rec.shp_attribute_category
381: => pqp_shp_shd.g_old_rec.continuous_service
382: ,p_all_assignments_o
383: => pqp_shp_shd.g_old_rec.all_assignments
384: ,p_object_version_number_o
385: => pqp_shp_shd.g_old_rec.object_version_number
386: ,p_shp_attribute_category_o
387: => pqp_shp_shd.g_old_rec.shp_attribute_category
388: ,p_shp_attribute1_o
389: => pqp_shp_shd.g_old_rec.shp_attribute1
383: => pqp_shp_shd.g_old_rec.all_assignments
384: ,p_object_version_number_o
385: => pqp_shp_shd.g_old_rec.object_version_number
386: ,p_shp_attribute_category_o
387: => pqp_shp_shd.g_old_rec.shp_attribute_category
388: ,p_shp_attribute1_o
389: => pqp_shp_shd.g_old_rec.shp_attribute1
390: ,p_shp_attribute2_o
391: => pqp_shp_shd.g_old_rec.shp_attribute2
385: => pqp_shp_shd.g_old_rec.object_version_number
386: ,p_shp_attribute_category_o
387: => pqp_shp_shd.g_old_rec.shp_attribute_category
388: ,p_shp_attribute1_o
389: => pqp_shp_shd.g_old_rec.shp_attribute1
390: ,p_shp_attribute2_o
391: => pqp_shp_shd.g_old_rec.shp_attribute2
392: ,p_shp_attribute3_o
393: => pqp_shp_shd.g_old_rec.shp_attribute3
387: => pqp_shp_shd.g_old_rec.shp_attribute_category
388: ,p_shp_attribute1_o
389: => pqp_shp_shd.g_old_rec.shp_attribute1
390: ,p_shp_attribute2_o
391: => pqp_shp_shd.g_old_rec.shp_attribute2
392: ,p_shp_attribute3_o
393: => pqp_shp_shd.g_old_rec.shp_attribute3
394: ,p_shp_attribute4_o
395: => pqp_shp_shd.g_old_rec.shp_attribute4
389: => pqp_shp_shd.g_old_rec.shp_attribute1
390: ,p_shp_attribute2_o
391: => pqp_shp_shd.g_old_rec.shp_attribute2
392: ,p_shp_attribute3_o
393: => pqp_shp_shd.g_old_rec.shp_attribute3
394: ,p_shp_attribute4_o
395: => pqp_shp_shd.g_old_rec.shp_attribute4
396: ,p_shp_attribute5_o
397: => pqp_shp_shd.g_old_rec.shp_attribute5
391: => pqp_shp_shd.g_old_rec.shp_attribute2
392: ,p_shp_attribute3_o
393: => pqp_shp_shd.g_old_rec.shp_attribute3
394: ,p_shp_attribute4_o
395: => pqp_shp_shd.g_old_rec.shp_attribute4
396: ,p_shp_attribute5_o
397: => pqp_shp_shd.g_old_rec.shp_attribute5
398: ,p_shp_attribute6_o
399: => pqp_shp_shd.g_old_rec.shp_attribute6
393: => pqp_shp_shd.g_old_rec.shp_attribute3
394: ,p_shp_attribute4_o
395: => pqp_shp_shd.g_old_rec.shp_attribute4
396: ,p_shp_attribute5_o
397: => pqp_shp_shd.g_old_rec.shp_attribute5
398: ,p_shp_attribute6_o
399: => pqp_shp_shd.g_old_rec.shp_attribute6
400: ,p_shp_attribute7_o
401: => pqp_shp_shd.g_old_rec.shp_attribute7
395: => pqp_shp_shd.g_old_rec.shp_attribute4
396: ,p_shp_attribute5_o
397: => pqp_shp_shd.g_old_rec.shp_attribute5
398: ,p_shp_attribute6_o
399: => pqp_shp_shd.g_old_rec.shp_attribute6
400: ,p_shp_attribute7_o
401: => pqp_shp_shd.g_old_rec.shp_attribute7
402: ,p_shp_attribute8_o
403: => pqp_shp_shd.g_old_rec.shp_attribute8
397: => pqp_shp_shd.g_old_rec.shp_attribute5
398: ,p_shp_attribute6_o
399: => pqp_shp_shd.g_old_rec.shp_attribute6
400: ,p_shp_attribute7_o
401: => pqp_shp_shd.g_old_rec.shp_attribute7
402: ,p_shp_attribute8_o
403: => pqp_shp_shd.g_old_rec.shp_attribute8
404: ,p_shp_attribute9_o
405: => pqp_shp_shd.g_old_rec.shp_attribute9
399: => pqp_shp_shd.g_old_rec.shp_attribute6
400: ,p_shp_attribute7_o
401: => pqp_shp_shd.g_old_rec.shp_attribute7
402: ,p_shp_attribute8_o
403: => pqp_shp_shd.g_old_rec.shp_attribute8
404: ,p_shp_attribute9_o
405: => pqp_shp_shd.g_old_rec.shp_attribute9
406: ,p_shp_attribute10_o
407: => pqp_shp_shd.g_old_rec.shp_attribute10
401: => pqp_shp_shd.g_old_rec.shp_attribute7
402: ,p_shp_attribute8_o
403: => pqp_shp_shd.g_old_rec.shp_attribute8
404: ,p_shp_attribute9_o
405: => pqp_shp_shd.g_old_rec.shp_attribute9
406: ,p_shp_attribute10_o
407: => pqp_shp_shd.g_old_rec.shp_attribute10
408: ,p_shp_attribute11_o
409: => pqp_shp_shd.g_old_rec.shp_attribute11
403: => pqp_shp_shd.g_old_rec.shp_attribute8
404: ,p_shp_attribute9_o
405: => pqp_shp_shd.g_old_rec.shp_attribute9
406: ,p_shp_attribute10_o
407: => pqp_shp_shd.g_old_rec.shp_attribute10
408: ,p_shp_attribute11_o
409: => pqp_shp_shd.g_old_rec.shp_attribute11
410: ,p_shp_attribute12_o
411: => pqp_shp_shd.g_old_rec.shp_attribute12
405: => pqp_shp_shd.g_old_rec.shp_attribute9
406: ,p_shp_attribute10_o
407: => pqp_shp_shd.g_old_rec.shp_attribute10
408: ,p_shp_attribute11_o
409: => pqp_shp_shd.g_old_rec.shp_attribute11
410: ,p_shp_attribute12_o
411: => pqp_shp_shd.g_old_rec.shp_attribute12
412: ,p_shp_attribute13_o
413: => pqp_shp_shd.g_old_rec.shp_attribute13
407: => pqp_shp_shd.g_old_rec.shp_attribute10
408: ,p_shp_attribute11_o
409: => pqp_shp_shd.g_old_rec.shp_attribute11
410: ,p_shp_attribute12_o
411: => pqp_shp_shd.g_old_rec.shp_attribute12
412: ,p_shp_attribute13_o
413: => pqp_shp_shd.g_old_rec.shp_attribute13
414: ,p_shp_attribute14_o
415: => pqp_shp_shd.g_old_rec.shp_attribute14
409: => pqp_shp_shd.g_old_rec.shp_attribute11
410: ,p_shp_attribute12_o
411: => pqp_shp_shd.g_old_rec.shp_attribute12
412: ,p_shp_attribute13_o
413: => pqp_shp_shd.g_old_rec.shp_attribute13
414: ,p_shp_attribute14_o
415: => pqp_shp_shd.g_old_rec.shp_attribute14
416: ,p_shp_attribute15_o
417: => pqp_shp_shd.g_old_rec.shp_attribute15
411: => pqp_shp_shd.g_old_rec.shp_attribute12
412: ,p_shp_attribute13_o
413: => pqp_shp_shd.g_old_rec.shp_attribute13
414: ,p_shp_attribute14_o
415: => pqp_shp_shd.g_old_rec.shp_attribute14
416: ,p_shp_attribute15_o
417: => pqp_shp_shd.g_old_rec.shp_attribute15
418: ,p_shp_attribute16_o
419: => pqp_shp_shd.g_old_rec.shp_attribute16
413: => pqp_shp_shd.g_old_rec.shp_attribute13
414: ,p_shp_attribute14_o
415: => pqp_shp_shd.g_old_rec.shp_attribute14
416: ,p_shp_attribute15_o
417: => pqp_shp_shd.g_old_rec.shp_attribute15
418: ,p_shp_attribute16_o
419: => pqp_shp_shd.g_old_rec.shp_attribute16
420: ,p_shp_attribute17_o
421: => pqp_shp_shd.g_old_rec.shp_attribute17
415: => pqp_shp_shd.g_old_rec.shp_attribute14
416: ,p_shp_attribute15_o
417: => pqp_shp_shd.g_old_rec.shp_attribute15
418: ,p_shp_attribute16_o
419: => pqp_shp_shd.g_old_rec.shp_attribute16
420: ,p_shp_attribute17_o
421: => pqp_shp_shd.g_old_rec.shp_attribute17
422: ,p_shp_attribute18_o
423: => pqp_shp_shd.g_old_rec.shp_attribute18
417: => pqp_shp_shd.g_old_rec.shp_attribute15
418: ,p_shp_attribute16_o
419: => pqp_shp_shd.g_old_rec.shp_attribute16
420: ,p_shp_attribute17_o
421: => pqp_shp_shd.g_old_rec.shp_attribute17
422: ,p_shp_attribute18_o
423: => pqp_shp_shd.g_old_rec.shp_attribute18
424: ,p_shp_attribute19_o
425: => pqp_shp_shd.g_old_rec.shp_attribute19
419: => pqp_shp_shd.g_old_rec.shp_attribute16
420: ,p_shp_attribute17_o
421: => pqp_shp_shd.g_old_rec.shp_attribute17
422: ,p_shp_attribute18_o
423: => pqp_shp_shd.g_old_rec.shp_attribute18
424: ,p_shp_attribute19_o
425: => pqp_shp_shd.g_old_rec.shp_attribute19
426: ,p_shp_attribute20_o
427: => pqp_shp_shd.g_old_rec.shp_attribute20
421: => pqp_shp_shd.g_old_rec.shp_attribute17
422: ,p_shp_attribute18_o
423: => pqp_shp_shd.g_old_rec.shp_attribute18
424: ,p_shp_attribute19_o
425: => pqp_shp_shd.g_old_rec.shp_attribute19
426: ,p_shp_attribute20_o
427: => pqp_shp_shd.g_old_rec.shp_attribute20
428: ,p_shp_information_category_o
429: => pqp_shp_shd.g_old_rec.shp_information_category
423: => pqp_shp_shd.g_old_rec.shp_attribute18
424: ,p_shp_attribute19_o
425: => pqp_shp_shd.g_old_rec.shp_attribute19
426: ,p_shp_attribute20_o
427: => pqp_shp_shd.g_old_rec.shp_attribute20
428: ,p_shp_information_category_o
429: => pqp_shp_shd.g_old_rec.shp_information_category
430: ,p_shp_information1_o
431: => pqp_shp_shd.g_old_rec.shp_information1
425: => pqp_shp_shd.g_old_rec.shp_attribute19
426: ,p_shp_attribute20_o
427: => pqp_shp_shd.g_old_rec.shp_attribute20
428: ,p_shp_information_category_o
429: => pqp_shp_shd.g_old_rec.shp_information_category
430: ,p_shp_information1_o
431: => pqp_shp_shd.g_old_rec.shp_information1
432: ,p_shp_information2_o
433: => pqp_shp_shd.g_old_rec.shp_information2
427: => pqp_shp_shd.g_old_rec.shp_attribute20
428: ,p_shp_information_category_o
429: => pqp_shp_shd.g_old_rec.shp_information_category
430: ,p_shp_information1_o
431: => pqp_shp_shd.g_old_rec.shp_information1
432: ,p_shp_information2_o
433: => pqp_shp_shd.g_old_rec.shp_information2
434: ,p_shp_information3_o
435: => pqp_shp_shd.g_old_rec.shp_information3
429: => pqp_shp_shd.g_old_rec.shp_information_category
430: ,p_shp_information1_o
431: => pqp_shp_shd.g_old_rec.shp_information1
432: ,p_shp_information2_o
433: => pqp_shp_shd.g_old_rec.shp_information2
434: ,p_shp_information3_o
435: => pqp_shp_shd.g_old_rec.shp_information3
436: ,p_shp_information4_o
437: => pqp_shp_shd.g_old_rec.shp_information4
431: => pqp_shp_shd.g_old_rec.shp_information1
432: ,p_shp_information2_o
433: => pqp_shp_shd.g_old_rec.shp_information2
434: ,p_shp_information3_o
435: => pqp_shp_shd.g_old_rec.shp_information3
436: ,p_shp_information4_o
437: => pqp_shp_shd.g_old_rec.shp_information4
438: ,p_shp_information5_o
439: => pqp_shp_shd.g_old_rec.shp_information5
433: => pqp_shp_shd.g_old_rec.shp_information2
434: ,p_shp_information3_o
435: => pqp_shp_shd.g_old_rec.shp_information3
436: ,p_shp_information4_o
437: => pqp_shp_shd.g_old_rec.shp_information4
438: ,p_shp_information5_o
439: => pqp_shp_shd.g_old_rec.shp_information5
440: ,p_shp_information6_o
441: => pqp_shp_shd.g_old_rec.shp_information6
435: => pqp_shp_shd.g_old_rec.shp_information3
436: ,p_shp_information4_o
437: => pqp_shp_shd.g_old_rec.shp_information4
438: ,p_shp_information5_o
439: => pqp_shp_shd.g_old_rec.shp_information5
440: ,p_shp_information6_o
441: => pqp_shp_shd.g_old_rec.shp_information6
442: ,p_shp_information7_o
443: => pqp_shp_shd.g_old_rec.shp_information7
437: => pqp_shp_shd.g_old_rec.shp_information4
438: ,p_shp_information5_o
439: => pqp_shp_shd.g_old_rec.shp_information5
440: ,p_shp_information6_o
441: => pqp_shp_shd.g_old_rec.shp_information6
442: ,p_shp_information7_o
443: => pqp_shp_shd.g_old_rec.shp_information7
444: ,p_shp_information8_o
445: => pqp_shp_shd.g_old_rec.shp_information8
439: => pqp_shp_shd.g_old_rec.shp_information5
440: ,p_shp_information6_o
441: => pqp_shp_shd.g_old_rec.shp_information6
442: ,p_shp_information7_o
443: => pqp_shp_shd.g_old_rec.shp_information7
444: ,p_shp_information8_o
445: => pqp_shp_shd.g_old_rec.shp_information8
446: ,p_shp_information9_o
447: => pqp_shp_shd.g_old_rec.shp_information9
441: => pqp_shp_shd.g_old_rec.shp_information6
442: ,p_shp_information7_o
443: => pqp_shp_shd.g_old_rec.shp_information7
444: ,p_shp_information8_o
445: => pqp_shp_shd.g_old_rec.shp_information8
446: ,p_shp_information9_o
447: => pqp_shp_shd.g_old_rec.shp_information9
448: ,p_shp_information10_o
449: => pqp_shp_shd.g_old_rec.shp_information10
443: => pqp_shp_shd.g_old_rec.shp_information7
444: ,p_shp_information8_o
445: => pqp_shp_shd.g_old_rec.shp_information8
446: ,p_shp_information9_o
447: => pqp_shp_shd.g_old_rec.shp_information9
448: ,p_shp_information10_o
449: => pqp_shp_shd.g_old_rec.shp_information10
450: ,p_shp_information11_o
451: => pqp_shp_shd.g_old_rec.shp_information11
445: => pqp_shp_shd.g_old_rec.shp_information8
446: ,p_shp_information9_o
447: => pqp_shp_shd.g_old_rec.shp_information9
448: ,p_shp_information10_o
449: => pqp_shp_shd.g_old_rec.shp_information10
450: ,p_shp_information11_o
451: => pqp_shp_shd.g_old_rec.shp_information11
452: ,p_shp_information12_o
453: => pqp_shp_shd.g_old_rec.shp_information12
447: => pqp_shp_shd.g_old_rec.shp_information9
448: ,p_shp_information10_o
449: => pqp_shp_shd.g_old_rec.shp_information10
450: ,p_shp_information11_o
451: => pqp_shp_shd.g_old_rec.shp_information11
452: ,p_shp_information12_o
453: => pqp_shp_shd.g_old_rec.shp_information12
454: ,p_shp_information13_o
455: => pqp_shp_shd.g_old_rec.shp_information13
449: => pqp_shp_shd.g_old_rec.shp_information10
450: ,p_shp_information11_o
451: => pqp_shp_shd.g_old_rec.shp_information11
452: ,p_shp_information12_o
453: => pqp_shp_shd.g_old_rec.shp_information12
454: ,p_shp_information13_o
455: => pqp_shp_shd.g_old_rec.shp_information13
456: ,p_shp_information14_o
457: => pqp_shp_shd.g_old_rec.shp_information14
451: => pqp_shp_shd.g_old_rec.shp_information11
452: ,p_shp_information12_o
453: => pqp_shp_shd.g_old_rec.shp_information12
454: ,p_shp_information13_o
455: => pqp_shp_shd.g_old_rec.shp_information13
456: ,p_shp_information14_o
457: => pqp_shp_shd.g_old_rec.shp_information14
458: ,p_shp_information15_o
459: => pqp_shp_shd.g_old_rec.shp_information15
453: => pqp_shp_shd.g_old_rec.shp_information12
454: ,p_shp_information13_o
455: => pqp_shp_shd.g_old_rec.shp_information13
456: ,p_shp_information14_o
457: => pqp_shp_shd.g_old_rec.shp_information14
458: ,p_shp_information15_o
459: => pqp_shp_shd.g_old_rec.shp_information15
460: ,p_shp_information16_o
461: => pqp_shp_shd.g_old_rec.shp_information16
455: => pqp_shp_shd.g_old_rec.shp_information13
456: ,p_shp_information14_o
457: => pqp_shp_shd.g_old_rec.shp_information14
458: ,p_shp_information15_o
459: => pqp_shp_shd.g_old_rec.shp_information15
460: ,p_shp_information16_o
461: => pqp_shp_shd.g_old_rec.shp_information16
462: ,p_shp_information17_o
463: => pqp_shp_shd.g_old_rec.shp_information17
457: => pqp_shp_shd.g_old_rec.shp_information14
458: ,p_shp_information15_o
459: => pqp_shp_shd.g_old_rec.shp_information15
460: ,p_shp_information16_o
461: => pqp_shp_shd.g_old_rec.shp_information16
462: ,p_shp_information17_o
463: => pqp_shp_shd.g_old_rec.shp_information17
464: ,p_shp_information18_o
465: => pqp_shp_shd.g_old_rec.shp_information18
459: => pqp_shp_shd.g_old_rec.shp_information15
460: ,p_shp_information16_o
461: => pqp_shp_shd.g_old_rec.shp_information16
462: ,p_shp_information17_o
463: => pqp_shp_shd.g_old_rec.shp_information17
464: ,p_shp_information18_o
465: => pqp_shp_shd.g_old_rec.shp_information18
466: ,p_shp_information19_o
467: => pqp_shp_shd.g_old_rec.shp_information19
461: => pqp_shp_shd.g_old_rec.shp_information16
462: ,p_shp_information17_o
463: => pqp_shp_shd.g_old_rec.shp_information17
464: ,p_shp_information18_o
465: => pqp_shp_shd.g_old_rec.shp_information18
466: ,p_shp_information19_o
467: => pqp_shp_shd.g_old_rec.shp_information19
468: ,p_shp_information20_o
469: => pqp_shp_shd.g_old_rec.shp_information20
463: => pqp_shp_shd.g_old_rec.shp_information17
464: ,p_shp_information18_o
465: => pqp_shp_shd.g_old_rec.shp_information18
466: ,p_shp_information19_o
467: => pqp_shp_shd.g_old_rec.shp_information19
468: ,p_shp_information20_o
469: => pqp_shp_shd.g_old_rec.shp_information20
470: );
471: --
465: => pqp_shp_shd.g_old_rec.shp_information18
466: ,p_shp_information19_o
467: => pqp_shp_shd.g_old_rec.shp_information19
468: ,p_shp_information20_o
469: => pqp_shp_shd.g_old_rec.shp_information20
470: );
471: --
472: exception
473: --
525: --
526: -- {End Of Comments}
527: -- ----------------------------------------------------------------------------
528: Procedure convert_defs
529: (p_rec in out nocopy pqp_shp_shd.g_rec_type
530: ) is
531: --
532: Begin
533: --
537: -- is being used then we must set to the 'current' argument value.
538: --
539: If (p_rec.business_group_id = hr_api.g_number) then
540: p_rec.business_group_id :=
541: pqp_shp_shd.g_old_rec.business_group_id;
542: End If;
543: If (p_rec.assignment_id = hr_api.g_number) then
544: p_rec.assignment_id :=
545: pqp_shp_shd.g_old_rec.assignment_id;
541: pqp_shp_shd.g_old_rec.business_group_id;
542: End If;
543: If (p_rec.assignment_id = hr_api.g_number) then
544: p_rec.assignment_id :=
545: pqp_shp_shd.g_old_rec.assignment_id;
546: End If;
547: If (p_rec.start_date = hr_api.g_date) then
548: p_rec.start_date :=
549: pqp_shp_shd.g_old_rec.start_date;
545: pqp_shp_shd.g_old_rec.assignment_id;
546: End If;
547: If (p_rec.start_date = hr_api.g_date) then
548: p_rec.start_date :=
549: pqp_shp_shd.g_old_rec.start_date;
550: End If;
551: If (p_rec.end_date = hr_api.g_date) then
552: p_rec.end_date :=
553: pqp_shp_shd.g_old_rec.end_date;
549: pqp_shp_shd.g_old_rec.start_date;
550: End If;
551: If (p_rec.end_date = hr_api.g_date) then
552: p_rec.end_date :=
553: pqp_shp_shd.g_old_rec.end_date;
554: End If;
555: If (p_rec.employer_name = hr_api.g_varchar2) then
556: p_rec.employer_name :=
557: pqp_shp_shd.g_old_rec.employer_name;
553: pqp_shp_shd.g_old_rec.end_date;
554: End If;
555: If (p_rec.employer_name = hr_api.g_varchar2) then
556: p_rec.employer_name :=
557: pqp_shp_shd.g_old_rec.employer_name;
558: End If;
559: If (p_rec.employer_address = hr_api.g_varchar2) then
560: p_rec.employer_address :=
561: pqp_shp_shd.g_old_rec.employer_address;
557: pqp_shp_shd.g_old_rec.employer_name;
558: End If;
559: If (p_rec.employer_address = hr_api.g_varchar2) then
560: p_rec.employer_address :=
561: pqp_shp_shd.g_old_rec.employer_address;
562: End If;
563: If (p_rec.employer_type = hr_api.g_varchar2) then
564: p_rec.employer_type :=
565: pqp_shp_shd.g_old_rec.employer_type;
561: pqp_shp_shd.g_old_rec.employer_address;
562: End If;
563: If (p_rec.employer_type = hr_api.g_varchar2) then
564: p_rec.employer_type :=
565: pqp_shp_shd.g_old_rec.employer_type;
566: End If;
567: If (p_rec.employer_subtype = hr_api.g_varchar2) then
568: p_rec.employer_subtype :=
569: pqp_shp_shd.g_old_rec.employer_subtype;
565: pqp_shp_shd.g_old_rec.employer_type;
566: End If;
567: If (p_rec.employer_subtype = hr_api.g_varchar2) then
568: p_rec.employer_subtype :=
569: pqp_shp_shd.g_old_rec.employer_subtype;
570: End If;
571: If (p_rec.period_years = hr_api.g_number) then
572: p_rec.period_years :=
573: pqp_shp_shd.g_old_rec.period_years;
569: pqp_shp_shd.g_old_rec.employer_subtype;
570: End If;
571: If (p_rec.period_years = hr_api.g_number) then
572: p_rec.period_years :=
573: pqp_shp_shd.g_old_rec.period_years;
574: End If;
575: If (p_rec.period_days = hr_api.g_number) then
576: p_rec.period_days :=
577: pqp_shp_shd.g_old_rec.period_days;
573: pqp_shp_shd.g_old_rec.period_years;
574: End If;
575: If (p_rec.period_days = hr_api.g_number) then
576: p_rec.period_days :=
577: pqp_shp_shd.g_old_rec.period_days;
578: End If;
579: If (p_rec.description = hr_api.g_varchar2) then
580: p_rec.description :=
581: pqp_shp_shd.g_old_rec.description;
577: pqp_shp_shd.g_old_rec.period_days;
578: End If;
579: If (p_rec.description = hr_api.g_varchar2) then
580: p_rec.description :=
581: pqp_shp_shd.g_old_rec.description;
582: End If;
583: If (p_rec.continuous_service = hr_api.g_varchar2) then
584: p_rec.continuous_service :=
585: pqp_shp_shd.g_old_rec.continuous_service;
581: pqp_shp_shd.g_old_rec.description;
582: End If;
583: If (p_rec.continuous_service = hr_api.g_varchar2) then
584: p_rec.continuous_service :=
585: pqp_shp_shd.g_old_rec.continuous_service;
586: End If;
587: If (p_rec.all_assignments = hr_api.g_varchar2) then
588: p_rec.all_assignments :=
589: pqp_shp_shd.g_old_rec.all_assignments;
585: pqp_shp_shd.g_old_rec.continuous_service;
586: End If;
587: If (p_rec.all_assignments = hr_api.g_varchar2) then
588: p_rec.all_assignments :=
589: pqp_shp_shd.g_old_rec.all_assignments;
590: End If;
591: If (p_rec.shp_attribute_category = hr_api.g_varchar2) then
592: p_rec.shp_attribute_category :=
593: pqp_shp_shd.g_old_rec.shp_attribute_category;
589: pqp_shp_shd.g_old_rec.all_assignments;
590: End If;
591: If (p_rec.shp_attribute_category = hr_api.g_varchar2) then
592: p_rec.shp_attribute_category :=
593: pqp_shp_shd.g_old_rec.shp_attribute_category;
594: End If;
595: If (p_rec.shp_attribute1 = hr_api.g_varchar2) then
596: p_rec.shp_attribute1 :=
597: pqp_shp_shd.g_old_rec.shp_attribute1;
593: pqp_shp_shd.g_old_rec.shp_attribute_category;
594: End If;
595: If (p_rec.shp_attribute1 = hr_api.g_varchar2) then
596: p_rec.shp_attribute1 :=
597: pqp_shp_shd.g_old_rec.shp_attribute1;
598: End If;
599: If (p_rec.shp_attribute2 = hr_api.g_varchar2) then
600: p_rec.shp_attribute2 :=
601: pqp_shp_shd.g_old_rec.shp_attribute2;
597: pqp_shp_shd.g_old_rec.shp_attribute1;
598: End If;
599: If (p_rec.shp_attribute2 = hr_api.g_varchar2) then
600: p_rec.shp_attribute2 :=
601: pqp_shp_shd.g_old_rec.shp_attribute2;
602: End If;
603: If (p_rec.shp_attribute3 = hr_api.g_varchar2) then
604: p_rec.shp_attribute3 :=
605: pqp_shp_shd.g_old_rec.shp_attribute3;
601: pqp_shp_shd.g_old_rec.shp_attribute2;
602: End If;
603: If (p_rec.shp_attribute3 = hr_api.g_varchar2) then
604: p_rec.shp_attribute3 :=
605: pqp_shp_shd.g_old_rec.shp_attribute3;
606: End If;
607: If (p_rec.shp_attribute4 = hr_api.g_varchar2) then
608: p_rec.shp_attribute4 :=
609: pqp_shp_shd.g_old_rec.shp_attribute4;
605: pqp_shp_shd.g_old_rec.shp_attribute3;
606: End If;
607: If (p_rec.shp_attribute4 = hr_api.g_varchar2) then
608: p_rec.shp_attribute4 :=
609: pqp_shp_shd.g_old_rec.shp_attribute4;
610: End If;
611: If (p_rec.shp_attribute5 = hr_api.g_varchar2) then
612: p_rec.shp_attribute5 :=
613: pqp_shp_shd.g_old_rec.shp_attribute5;
609: pqp_shp_shd.g_old_rec.shp_attribute4;
610: End If;
611: If (p_rec.shp_attribute5 = hr_api.g_varchar2) then
612: p_rec.shp_attribute5 :=
613: pqp_shp_shd.g_old_rec.shp_attribute5;
614: End If;
615: If (p_rec.shp_attribute6 = hr_api.g_varchar2) then
616: p_rec.shp_attribute6 :=
617: pqp_shp_shd.g_old_rec.shp_attribute6;
613: pqp_shp_shd.g_old_rec.shp_attribute5;
614: End If;
615: If (p_rec.shp_attribute6 = hr_api.g_varchar2) then
616: p_rec.shp_attribute6 :=
617: pqp_shp_shd.g_old_rec.shp_attribute6;
618: End If;
619: If (p_rec.shp_attribute7 = hr_api.g_varchar2) then
620: p_rec.shp_attribute7 :=
621: pqp_shp_shd.g_old_rec.shp_attribute7;
617: pqp_shp_shd.g_old_rec.shp_attribute6;
618: End If;
619: If (p_rec.shp_attribute7 = hr_api.g_varchar2) then
620: p_rec.shp_attribute7 :=
621: pqp_shp_shd.g_old_rec.shp_attribute7;
622: End If;
623: If (p_rec.shp_attribute8 = hr_api.g_varchar2) then
624: p_rec.shp_attribute8 :=
625: pqp_shp_shd.g_old_rec.shp_attribute8;
621: pqp_shp_shd.g_old_rec.shp_attribute7;
622: End If;
623: If (p_rec.shp_attribute8 = hr_api.g_varchar2) then
624: p_rec.shp_attribute8 :=
625: pqp_shp_shd.g_old_rec.shp_attribute8;
626: End If;
627: If (p_rec.shp_attribute9 = hr_api.g_varchar2) then
628: p_rec.shp_attribute9 :=
629: pqp_shp_shd.g_old_rec.shp_attribute9;
625: pqp_shp_shd.g_old_rec.shp_attribute8;
626: End If;
627: If (p_rec.shp_attribute9 = hr_api.g_varchar2) then
628: p_rec.shp_attribute9 :=
629: pqp_shp_shd.g_old_rec.shp_attribute9;
630: End If;
631: If (p_rec.shp_attribute10 = hr_api.g_varchar2) then
632: p_rec.shp_attribute10 :=
633: pqp_shp_shd.g_old_rec.shp_attribute10;
629: pqp_shp_shd.g_old_rec.shp_attribute9;
630: End If;
631: If (p_rec.shp_attribute10 = hr_api.g_varchar2) then
632: p_rec.shp_attribute10 :=
633: pqp_shp_shd.g_old_rec.shp_attribute10;
634: End If;
635: If (p_rec.shp_attribute11 = hr_api.g_varchar2) then
636: p_rec.shp_attribute11 :=
637: pqp_shp_shd.g_old_rec.shp_attribute11;
633: pqp_shp_shd.g_old_rec.shp_attribute10;
634: End If;
635: If (p_rec.shp_attribute11 = hr_api.g_varchar2) then
636: p_rec.shp_attribute11 :=
637: pqp_shp_shd.g_old_rec.shp_attribute11;
638: End If;
639: If (p_rec.shp_attribute12 = hr_api.g_varchar2) then
640: p_rec.shp_attribute12 :=
641: pqp_shp_shd.g_old_rec.shp_attribute12;
637: pqp_shp_shd.g_old_rec.shp_attribute11;
638: End If;
639: If (p_rec.shp_attribute12 = hr_api.g_varchar2) then
640: p_rec.shp_attribute12 :=
641: pqp_shp_shd.g_old_rec.shp_attribute12;
642: End If;
643: If (p_rec.shp_attribute13 = hr_api.g_varchar2) then
644: p_rec.shp_attribute13 :=
645: pqp_shp_shd.g_old_rec.shp_attribute13;
641: pqp_shp_shd.g_old_rec.shp_attribute12;
642: End If;
643: If (p_rec.shp_attribute13 = hr_api.g_varchar2) then
644: p_rec.shp_attribute13 :=
645: pqp_shp_shd.g_old_rec.shp_attribute13;
646: End If;
647: If (p_rec.shp_attribute14 = hr_api.g_varchar2) then
648: p_rec.shp_attribute14 :=
649: pqp_shp_shd.g_old_rec.shp_attribute14;
645: pqp_shp_shd.g_old_rec.shp_attribute13;
646: End If;
647: If (p_rec.shp_attribute14 = hr_api.g_varchar2) then
648: p_rec.shp_attribute14 :=
649: pqp_shp_shd.g_old_rec.shp_attribute14;
650: End If;
651: If (p_rec.shp_attribute15 = hr_api.g_varchar2) then
652: p_rec.shp_attribute15 :=
653: pqp_shp_shd.g_old_rec.shp_attribute15;
649: pqp_shp_shd.g_old_rec.shp_attribute14;
650: End If;
651: If (p_rec.shp_attribute15 = hr_api.g_varchar2) then
652: p_rec.shp_attribute15 :=
653: pqp_shp_shd.g_old_rec.shp_attribute15;
654: End If;
655: If (p_rec.shp_attribute16 = hr_api.g_varchar2) then
656: p_rec.shp_attribute16 :=
657: pqp_shp_shd.g_old_rec.shp_attribute16;
653: pqp_shp_shd.g_old_rec.shp_attribute15;
654: End If;
655: If (p_rec.shp_attribute16 = hr_api.g_varchar2) then
656: p_rec.shp_attribute16 :=
657: pqp_shp_shd.g_old_rec.shp_attribute16;
658: End If;
659: If (p_rec.shp_attribute17 = hr_api.g_varchar2) then
660: p_rec.shp_attribute17 :=
661: pqp_shp_shd.g_old_rec.shp_attribute17;
657: pqp_shp_shd.g_old_rec.shp_attribute16;
658: End If;
659: If (p_rec.shp_attribute17 = hr_api.g_varchar2) then
660: p_rec.shp_attribute17 :=
661: pqp_shp_shd.g_old_rec.shp_attribute17;
662: End If;
663: If (p_rec.shp_attribute18 = hr_api.g_varchar2) then
664: p_rec.shp_attribute18 :=
665: pqp_shp_shd.g_old_rec.shp_attribute18;
661: pqp_shp_shd.g_old_rec.shp_attribute17;
662: End If;
663: If (p_rec.shp_attribute18 = hr_api.g_varchar2) then
664: p_rec.shp_attribute18 :=
665: pqp_shp_shd.g_old_rec.shp_attribute18;
666: End If;
667: If (p_rec.shp_attribute19 = hr_api.g_varchar2) then
668: p_rec.shp_attribute19 :=
669: pqp_shp_shd.g_old_rec.shp_attribute19;
665: pqp_shp_shd.g_old_rec.shp_attribute18;
666: End If;
667: If (p_rec.shp_attribute19 = hr_api.g_varchar2) then
668: p_rec.shp_attribute19 :=
669: pqp_shp_shd.g_old_rec.shp_attribute19;
670: End If;
671: If (p_rec.shp_attribute20 = hr_api.g_varchar2) then
672: p_rec.shp_attribute20 :=
673: pqp_shp_shd.g_old_rec.shp_attribute20;
669: pqp_shp_shd.g_old_rec.shp_attribute19;
670: End If;
671: If (p_rec.shp_attribute20 = hr_api.g_varchar2) then
672: p_rec.shp_attribute20 :=
673: pqp_shp_shd.g_old_rec.shp_attribute20;
674: End If;
675: If (p_rec.shp_information_category = hr_api.g_varchar2) then
676: p_rec.shp_information_category :=
677: pqp_shp_shd.g_old_rec.shp_information_category;
673: pqp_shp_shd.g_old_rec.shp_attribute20;
674: End If;
675: If (p_rec.shp_information_category = hr_api.g_varchar2) then
676: p_rec.shp_information_category :=
677: pqp_shp_shd.g_old_rec.shp_information_category;
678: End If;
679: If (p_rec.shp_information1 = hr_api.g_varchar2) then
680: p_rec.shp_information1 :=
681: pqp_shp_shd.g_old_rec.shp_information1;
677: pqp_shp_shd.g_old_rec.shp_information_category;
678: End If;
679: If (p_rec.shp_information1 = hr_api.g_varchar2) then
680: p_rec.shp_information1 :=
681: pqp_shp_shd.g_old_rec.shp_information1;
682: End If;
683: If (p_rec.shp_information2 = hr_api.g_varchar2) then
684: p_rec.shp_information2 :=
685: pqp_shp_shd.g_old_rec.shp_information2;
681: pqp_shp_shd.g_old_rec.shp_information1;
682: End If;
683: If (p_rec.shp_information2 = hr_api.g_varchar2) then
684: p_rec.shp_information2 :=
685: pqp_shp_shd.g_old_rec.shp_information2;
686: End If;
687: If (p_rec.shp_information3 = hr_api.g_varchar2) then
688: p_rec.shp_information3 :=
689: pqp_shp_shd.g_old_rec.shp_information3;
685: pqp_shp_shd.g_old_rec.shp_information2;
686: End If;
687: If (p_rec.shp_information3 = hr_api.g_varchar2) then
688: p_rec.shp_information3 :=
689: pqp_shp_shd.g_old_rec.shp_information3;
690: End If;
691: If (p_rec.shp_information4 = hr_api.g_varchar2) then
692: p_rec.shp_information4 :=
693: pqp_shp_shd.g_old_rec.shp_information4;
689: pqp_shp_shd.g_old_rec.shp_information3;
690: End If;
691: If (p_rec.shp_information4 = hr_api.g_varchar2) then
692: p_rec.shp_information4 :=
693: pqp_shp_shd.g_old_rec.shp_information4;
694: End If;
695: If (p_rec.shp_information5 = hr_api.g_varchar2) then
696: p_rec.shp_information5 :=
697: pqp_shp_shd.g_old_rec.shp_information5;
693: pqp_shp_shd.g_old_rec.shp_information4;
694: End If;
695: If (p_rec.shp_information5 = hr_api.g_varchar2) then
696: p_rec.shp_information5 :=
697: pqp_shp_shd.g_old_rec.shp_information5;
698: End If;
699: If (p_rec.shp_information6 = hr_api.g_varchar2) then
700: p_rec.shp_information6 :=
701: pqp_shp_shd.g_old_rec.shp_information6;
697: pqp_shp_shd.g_old_rec.shp_information5;
698: End If;
699: If (p_rec.shp_information6 = hr_api.g_varchar2) then
700: p_rec.shp_information6 :=
701: pqp_shp_shd.g_old_rec.shp_information6;
702: End If;
703: If (p_rec.shp_information7 = hr_api.g_varchar2) then
704: p_rec.shp_information7 :=
705: pqp_shp_shd.g_old_rec.shp_information7;
701: pqp_shp_shd.g_old_rec.shp_information6;
702: End If;
703: If (p_rec.shp_information7 = hr_api.g_varchar2) then
704: p_rec.shp_information7 :=
705: pqp_shp_shd.g_old_rec.shp_information7;
706: End If;
707: If (p_rec.shp_information8 = hr_api.g_varchar2) then
708: p_rec.shp_information8 :=
709: pqp_shp_shd.g_old_rec.shp_information8;
705: pqp_shp_shd.g_old_rec.shp_information7;
706: End If;
707: If (p_rec.shp_information8 = hr_api.g_varchar2) then
708: p_rec.shp_information8 :=
709: pqp_shp_shd.g_old_rec.shp_information8;
710: End If;
711: If (p_rec.shp_information9 = hr_api.g_varchar2) then
712: p_rec.shp_information9 :=
713: pqp_shp_shd.g_old_rec.shp_information9;
709: pqp_shp_shd.g_old_rec.shp_information8;
710: End If;
711: If (p_rec.shp_information9 = hr_api.g_varchar2) then
712: p_rec.shp_information9 :=
713: pqp_shp_shd.g_old_rec.shp_information9;
714: End If;
715: If (p_rec.shp_information10 = hr_api.g_varchar2) then
716: p_rec.shp_information10 :=
717: pqp_shp_shd.g_old_rec.shp_information10;
713: pqp_shp_shd.g_old_rec.shp_information9;
714: End If;
715: If (p_rec.shp_information10 = hr_api.g_varchar2) then
716: p_rec.shp_information10 :=
717: pqp_shp_shd.g_old_rec.shp_information10;
718: End If;
719: If (p_rec.shp_information11 = hr_api.g_varchar2) then
720: p_rec.shp_information11 :=
721: pqp_shp_shd.g_old_rec.shp_information11;
717: pqp_shp_shd.g_old_rec.shp_information10;
718: End If;
719: If (p_rec.shp_information11 = hr_api.g_varchar2) then
720: p_rec.shp_information11 :=
721: pqp_shp_shd.g_old_rec.shp_information11;
722: End If;
723: If (p_rec.shp_information12 = hr_api.g_varchar2) then
724: p_rec.shp_information12 :=
725: pqp_shp_shd.g_old_rec.shp_information12;
721: pqp_shp_shd.g_old_rec.shp_information11;
722: End If;
723: If (p_rec.shp_information12 = hr_api.g_varchar2) then
724: p_rec.shp_information12 :=
725: pqp_shp_shd.g_old_rec.shp_information12;
726: End If;
727: If (p_rec.shp_information13 = hr_api.g_varchar2) then
728: p_rec.shp_information13 :=
729: pqp_shp_shd.g_old_rec.shp_information13;
725: pqp_shp_shd.g_old_rec.shp_information12;
726: End If;
727: If (p_rec.shp_information13 = hr_api.g_varchar2) then
728: p_rec.shp_information13 :=
729: pqp_shp_shd.g_old_rec.shp_information13;
730: End If;
731: If (p_rec.shp_information14 = hr_api.g_varchar2) then
732: p_rec.shp_information14 :=
733: pqp_shp_shd.g_old_rec.shp_information14;
729: pqp_shp_shd.g_old_rec.shp_information13;
730: End If;
731: If (p_rec.shp_information14 = hr_api.g_varchar2) then
732: p_rec.shp_information14 :=
733: pqp_shp_shd.g_old_rec.shp_information14;
734: End If;
735: If (p_rec.shp_information15 = hr_api.g_varchar2) then
736: p_rec.shp_information15 :=
737: pqp_shp_shd.g_old_rec.shp_information15;
733: pqp_shp_shd.g_old_rec.shp_information14;
734: End If;
735: If (p_rec.shp_information15 = hr_api.g_varchar2) then
736: p_rec.shp_information15 :=
737: pqp_shp_shd.g_old_rec.shp_information15;
738: End If;
739: If (p_rec.shp_information16 = hr_api.g_varchar2) then
740: p_rec.shp_information16 :=
741: pqp_shp_shd.g_old_rec.shp_information16;
737: pqp_shp_shd.g_old_rec.shp_information15;
738: End If;
739: If (p_rec.shp_information16 = hr_api.g_varchar2) then
740: p_rec.shp_information16 :=
741: pqp_shp_shd.g_old_rec.shp_information16;
742: End If;
743: If (p_rec.shp_information17 = hr_api.g_varchar2) then
744: p_rec.shp_information17 :=
745: pqp_shp_shd.g_old_rec.shp_information17;
741: pqp_shp_shd.g_old_rec.shp_information16;
742: End If;
743: If (p_rec.shp_information17 = hr_api.g_varchar2) then
744: p_rec.shp_information17 :=
745: pqp_shp_shd.g_old_rec.shp_information17;
746: End If;
747: If (p_rec.shp_information18 = hr_api.g_varchar2) then
748: p_rec.shp_information18 :=
749: pqp_shp_shd.g_old_rec.shp_information18;
745: pqp_shp_shd.g_old_rec.shp_information17;
746: End If;
747: If (p_rec.shp_information18 = hr_api.g_varchar2) then
748: p_rec.shp_information18 :=
749: pqp_shp_shd.g_old_rec.shp_information18;
750: End If;
751: If (p_rec.shp_information19 = hr_api.g_varchar2) then
752: p_rec.shp_information19 :=
753: pqp_shp_shd.g_old_rec.shp_information19;
749: pqp_shp_shd.g_old_rec.shp_information18;
750: End If;
751: If (p_rec.shp_information19 = hr_api.g_varchar2) then
752: p_rec.shp_information19 :=
753: pqp_shp_shd.g_old_rec.shp_information19;
754: End If;
755: If (p_rec.shp_information20 = hr_api.g_varchar2) then
756: p_rec.shp_information20 :=
757: pqp_shp_shd.g_old_rec.shp_information20;
753: pqp_shp_shd.g_old_rec.shp_information19;
754: End If;
755: If (p_rec.shp_information20 = hr_api.g_varchar2) then
756: p_rec.shp_information20 :=
757: pqp_shp_shd.g_old_rec.shp_information20;
758: End If;
759: --
760: End convert_defs;
761: --
763: -- |---------------------------------< upd >----------------------------------|
764: -- ----------------------------------------------------------------------------
765: Procedure upd
766: (
767: p_rec in out nocopy pqp_shp_shd.g_rec_type
768: ) is
769: --
770: l_proc varchar2(72) := g_package||'upd';
771: --
773: hr_utility.set_location('Entering:'||l_proc, 5);
774: --
775: -- We must lock the row which we need to update.
776: --
777: pqp_shp_shd.lck
778: (p_rec.service_history_period_id
779: ,p_rec.object_version_number
780: );
781: --
869: ,p_shp_information19 in varchar2 default hr_api.g_varchar2
870: ,p_shp_information20 in varchar2 default hr_api.g_varchar2
871: ) is
872: --
873: l_rec pqp_shp_shd.g_rec_type;
874: l_proc varchar2(72) := g_package||'upd';
875: --
876: Begin
877: hr_utility.set_location('Entering:'||l_proc, 5);
879: -- Call conversion function to turn arguments into the
880: -- l_rec structure.
881: --
882: l_rec :=
883: pqp_shp_shd.convert_args
884: (p_service_history_period_id
885: ,p_business_group_id
886: ,p_assignment_id
887: ,p_start_date