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.PER_CAG_UPD dependencies on PER_CAG_SHD

Line 56: Procedure update_dml(p_rec in out nocopy per_cag_shd.g_rec_type) is

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

Line 138: per_cag_shd.constraint_error

134: --
135: Exception
136: When hr_api.check_integrity_violated Then
137: -- A check constraint has been violated
138: per_cag_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When hr_api.parent_integrity_violated Then
141: -- Parent integrity has been violated
142: per_cag_shd.constraint_error

Line 142: per_cag_shd.constraint_error

138: per_cag_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When hr_api.parent_integrity_violated Then
141: -- Parent integrity has been violated
142: per_cag_shd.constraint_error
143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
144: When hr_api.unique_integrity_violated Then
145: -- Unique integrity has been violated
146: per_cag_shd.constraint_error

Line 146: per_cag_shd.constraint_error

142: per_cag_shd.constraint_error
143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
144: When hr_api.unique_integrity_violated Then
145: -- Unique integrity has been violated
146: per_cag_shd.constraint_error
147: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
148: When Others Then
149: Raise;
150: End update_dml;

Line 184: Procedure pre_update(p_rec in per_cag_shd.g_rec_type) is

180: -- Internal Row Handler Use Only.
181: --
182: -- {End Of Comments}
183: -- ----------------------------------------------------------------------------
184: Procedure pre_update(p_rec in per_cag_shd.g_rec_type) is
185: --
186: l_proc varchar2(72) := g_package||'pre_update';
187: --
188: Begin

Line 226: Procedure post_update(p_rec in per_cag_shd.g_rec_type) is

222: -- Internal Row Handler Use Only.
223: --
224: -- {End Of Comments}
225: -- ----------------------------------------------------------------------------
226: Procedure post_update(p_rec in per_cag_shd.g_rec_type) is
227: --
228: l_proc varchar2(72) := g_package||'post_update';
229: --
230: Begin

Line 298: p_business_group_id_o =>per_cag_shd.g_old_rec.business_group_id,

294: p_attribute17 =>p_rec.attribute17,
295: p_attribute18 =>p_rec.attribute18,
296: p_attribute19 =>p_rec.attribute19,
297: p_attribute20 =>p_rec.attribute20,
298: p_business_group_id_o =>per_cag_shd.g_old_rec.business_group_id,
299: p_object_version_number_o =>per_cag_shd.g_old_rec.object_version_number,
300: p_name_o =>per_cag_shd.g_old_rec.name,
301: p_status_o =>per_cag_shd.g_old_rec.status,
302: p_cag_number_o =>per_cag_shd.g_old_rec.cag_number,

Line 299: p_object_version_number_o =>per_cag_shd.g_old_rec.object_version_number,

295: p_attribute18 =>p_rec.attribute18,
296: p_attribute19 =>p_rec.attribute19,
297: p_attribute20 =>p_rec.attribute20,
298: p_business_group_id_o =>per_cag_shd.g_old_rec.business_group_id,
299: p_object_version_number_o =>per_cag_shd.g_old_rec.object_version_number,
300: p_name_o =>per_cag_shd.g_old_rec.name,
301: p_status_o =>per_cag_shd.g_old_rec.status,
302: p_cag_number_o =>per_cag_shd.g_old_rec.cag_number,
303: p_description_o =>per_cag_shd.g_old_rec.description,

Line 300: p_name_o =>per_cag_shd.g_old_rec.name,

296: p_attribute19 =>p_rec.attribute19,
297: p_attribute20 =>p_rec.attribute20,
298: p_business_group_id_o =>per_cag_shd.g_old_rec.business_group_id,
299: p_object_version_number_o =>per_cag_shd.g_old_rec.object_version_number,
300: p_name_o =>per_cag_shd.g_old_rec.name,
301: p_status_o =>per_cag_shd.g_old_rec.status,
302: p_cag_number_o =>per_cag_shd.g_old_rec.cag_number,
303: p_description_o =>per_cag_shd.g_old_rec.description,
304: p_start_date_o =>per_cag_shd.g_old_rec.start_date,

Line 301: p_status_o =>per_cag_shd.g_old_rec.status,

297: p_attribute20 =>p_rec.attribute20,
298: p_business_group_id_o =>per_cag_shd.g_old_rec.business_group_id,
299: p_object_version_number_o =>per_cag_shd.g_old_rec.object_version_number,
300: p_name_o =>per_cag_shd.g_old_rec.name,
301: p_status_o =>per_cag_shd.g_old_rec.status,
302: p_cag_number_o =>per_cag_shd.g_old_rec.cag_number,
303: p_description_o =>per_cag_shd.g_old_rec.description,
304: p_start_date_o =>per_cag_shd.g_old_rec.start_date,
305: p_end_date_o =>per_cag_shd.g_old_rec.end_date,

Line 302: p_cag_number_o =>per_cag_shd.g_old_rec.cag_number,

298: p_business_group_id_o =>per_cag_shd.g_old_rec.business_group_id,
299: p_object_version_number_o =>per_cag_shd.g_old_rec.object_version_number,
300: p_name_o =>per_cag_shd.g_old_rec.name,
301: p_status_o =>per_cag_shd.g_old_rec.status,
302: p_cag_number_o =>per_cag_shd.g_old_rec.cag_number,
303: p_description_o =>per_cag_shd.g_old_rec.description,
304: p_start_date_o =>per_cag_shd.g_old_rec.start_date,
305: p_end_date_o =>per_cag_shd.g_old_rec.end_date,
306: p_employer_organization_id_o =>per_cag_shd.g_old_rec.employer_organization_id,

Line 303: p_description_o =>per_cag_shd.g_old_rec.description,

299: p_object_version_number_o =>per_cag_shd.g_old_rec.object_version_number,
300: p_name_o =>per_cag_shd.g_old_rec.name,
301: p_status_o =>per_cag_shd.g_old_rec.status,
302: p_cag_number_o =>per_cag_shd.g_old_rec.cag_number,
303: p_description_o =>per_cag_shd.g_old_rec.description,
304: p_start_date_o =>per_cag_shd.g_old_rec.start_date,
305: p_end_date_o =>per_cag_shd.g_old_rec.end_date,
306: p_employer_organization_id_o =>per_cag_shd.g_old_rec.employer_organization_id,
307: p_employer_signatory_o =>per_cag_shd.g_old_rec.employer_signatory,

Line 304: p_start_date_o =>per_cag_shd.g_old_rec.start_date,

300: p_name_o =>per_cag_shd.g_old_rec.name,
301: p_status_o =>per_cag_shd.g_old_rec.status,
302: p_cag_number_o =>per_cag_shd.g_old_rec.cag_number,
303: p_description_o =>per_cag_shd.g_old_rec.description,
304: p_start_date_o =>per_cag_shd.g_old_rec.start_date,
305: p_end_date_o =>per_cag_shd.g_old_rec.end_date,
306: p_employer_organization_id_o =>per_cag_shd.g_old_rec.employer_organization_id,
307: p_employer_signatory_o =>per_cag_shd.g_old_rec.employer_signatory,
308: p_bargaining_organization_id_o =>per_cag_shd.g_old_rec.bargaining_organization_id,

Line 305: p_end_date_o =>per_cag_shd.g_old_rec.end_date,

301: p_status_o =>per_cag_shd.g_old_rec.status,
302: p_cag_number_o =>per_cag_shd.g_old_rec.cag_number,
303: p_description_o =>per_cag_shd.g_old_rec.description,
304: p_start_date_o =>per_cag_shd.g_old_rec.start_date,
305: p_end_date_o =>per_cag_shd.g_old_rec.end_date,
306: p_employer_organization_id_o =>per_cag_shd.g_old_rec.employer_organization_id,
307: p_employer_signatory_o =>per_cag_shd.g_old_rec.employer_signatory,
308: p_bargaining_organization_id_o =>per_cag_shd.g_old_rec.bargaining_organization_id,
309: p_bargaining_unit_signatory_o =>per_cag_shd.g_old_rec.bargaining_unit_signatory,

Line 306: p_employer_organization_id_o =>per_cag_shd.g_old_rec.employer_organization_id,

302: p_cag_number_o =>per_cag_shd.g_old_rec.cag_number,
303: p_description_o =>per_cag_shd.g_old_rec.description,
304: p_start_date_o =>per_cag_shd.g_old_rec.start_date,
305: p_end_date_o =>per_cag_shd.g_old_rec.end_date,
306: p_employer_organization_id_o =>per_cag_shd.g_old_rec.employer_organization_id,
307: p_employer_signatory_o =>per_cag_shd.g_old_rec.employer_signatory,
308: p_bargaining_organization_id_o =>per_cag_shd.g_old_rec.bargaining_organization_id,
309: p_bargaining_unit_signatory_o =>per_cag_shd.g_old_rec.bargaining_unit_signatory,
310: p_jurisdiction_o =>per_cag_shd.g_old_rec.jurisdiction,

Line 307: p_employer_signatory_o =>per_cag_shd.g_old_rec.employer_signatory,

303: p_description_o =>per_cag_shd.g_old_rec.description,
304: p_start_date_o =>per_cag_shd.g_old_rec.start_date,
305: p_end_date_o =>per_cag_shd.g_old_rec.end_date,
306: p_employer_organization_id_o =>per_cag_shd.g_old_rec.employer_organization_id,
307: p_employer_signatory_o =>per_cag_shd.g_old_rec.employer_signatory,
308: p_bargaining_organization_id_o =>per_cag_shd.g_old_rec.bargaining_organization_id,
309: p_bargaining_unit_signatory_o =>per_cag_shd.g_old_rec.bargaining_unit_signatory,
310: p_jurisdiction_o =>per_cag_shd.g_old_rec.jurisdiction,
311: p_authorizing_body_o =>per_cag_shd.g_old_rec.authorizing_body,

Line 308: p_bargaining_organization_id_o =>per_cag_shd.g_old_rec.bargaining_organization_id,

304: p_start_date_o =>per_cag_shd.g_old_rec.start_date,
305: p_end_date_o =>per_cag_shd.g_old_rec.end_date,
306: p_employer_organization_id_o =>per_cag_shd.g_old_rec.employer_organization_id,
307: p_employer_signatory_o =>per_cag_shd.g_old_rec.employer_signatory,
308: p_bargaining_organization_id_o =>per_cag_shd.g_old_rec.bargaining_organization_id,
309: p_bargaining_unit_signatory_o =>per_cag_shd.g_old_rec.bargaining_unit_signatory,
310: p_jurisdiction_o =>per_cag_shd.g_old_rec.jurisdiction,
311: p_authorizing_body_o =>per_cag_shd.g_old_rec.authorizing_body,
312: p_authorized_date_o =>per_cag_shd.g_old_rec.authorized_date,

Line 309: p_bargaining_unit_signatory_o =>per_cag_shd.g_old_rec.bargaining_unit_signatory,

305: p_end_date_o =>per_cag_shd.g_old_rec.end_date,
306: p_employer_organization_id_o =>per_cag_shd.g_old_rec.employer_organization_id,
307: p_employer_signatory_o =>per_cag_shd.g_old_rec.employer_signatory,
308: p_bargaining_organization_id_o =>per_cag_shd.g_old_rec.bargaining_organization_id,
309: p_bargaining_unit_signatory_o =>per_cag_shd.g_old_rec.bargaining_unit_signatory,
310: p_jurisdiction_o =>per_cag_shd.g_old_rec.jurisdiction,
311: p_authorizing_body_o =>per_cag_shd.g_old_rec.authorizing_body,
312: p_authorized_date_o =>per_cag_shd.g_old_rec.authorized_date,
313: p_cag_information_category_o =>per_cag_shd.g_old_rec.cag_information_category,

Line 310: p_jurisdiction_o =>per_cag_shd.g_old_rec.jurisdiction,

306: p_employer_organization_id_o =>per_cag_shd.g_old_rec.employer_organization_id,
307: p_employer_signatory_o =>per_cag_shd.g_old_rec.employer_signatory,
308: p_bargaining_organization_id_o =>per_cag_shd.g_old_rec.bargaining_organization_id,
309: p_bargaining_unit_signatory_o =>per_cag_shd.g_old_rec.bargaining_unit_signatory,
310: p_jurisdiction_o =>per_cag_shd.g_old_rec.jurisdiction,
311: p_authorizing_body_o =>per_cag_shd.g_old_rec.authorizing_body,
312: p_authorized_date_o =>per_cag_shd.g_old_rec.authorized_date,
313: p_cag_information_category_o =>per_cag_shd.g_old_rec.cag_information_category,
314: p_cag_information1_o =>per_cag_shd.g_old_rec.cag_information1,

Line 311: p_authorizing_body_o =>per_cag_shd.g_old_rec.authorizing_body,

307: p_employer_signatory_o =>per_cag_shd.g_old_rec.employer_signatory,
308: p_bargaining_organization_id_o =>per_cag_shd.g_old_rec.bargaining_organization_id,
309: p_bargaining_unit_signatory_o =>per_cag_shd.g_old_rec.bargaining_unit_signatory,
310: p_jurisdiction_o =>per_cag_shd.g_old_rec.jurisdiction,
311: p_authorizing_body_o =>per_cag_shd.g_old_rec.authorizing_body,
312: p_authorized_date_o =>per_cag_shd.g_old_rec.authorized_date,
313: p_cag_information_category_o =>per_cag_shd.g_old_rec.cag_information_category,
314: p_cag_information1_o =>per_cag_shd.g_old_rec.cag_information1,
315: p_cag_information2_o =>per_cag_shd.g_old_rec.cag_information2,

Line 312: p_authorized_date_o =>per_cag_shd.g_old_rec.authorized_date,

308: p_bargaining_organization_id_o =>per_cag_shd.g_old_rec.bargaining_organization_id,
309: p_bargaining_unit_signatory_o =>per_cag_shd.g_old_rec.bargaining_unit_signatory,
310: p_jurisdiction_o =>per_cag_shd.g_old_rec.jurisdiction,
311: p_authorizing_body_o =>per_cag_shd.g_old_rec.authorizing_body,
312: p_authorized_date_o =>per_cag_shd.g_old_rec.authorized_date,
313: p_cag_information_category_o =>per_cag_shd.g_old_rec.cag_information_category,
314: p_cag_information1_o =>per_cag_shd.g_old_rec.cag_information1,
315: p_cag_information2_o =>per_cag_shd.g_old_rec.cag_information2,
316: p_cag_information3_o =>per_cag_shd.g_old_rec.cag_information3,

Line 313: p_cag_information_category_o =>per_cag_shd.g_old_rec.cag_information_category,

309: p_bargaining_unit_signatory_o =>per_cag_shd.g_old_rec.bargaining_unit_signatory,
310: p_jurisdiction_o =>per_cag_shd.g_old_rec.jurisdiction,
311: p_authorizing_body_o =>per_cag_shd.g_old_rec.authorizing_body,
312: p_authorized_date_o =>per_cag_shd.g_old_rec.authorized_date,
313: p_cag_information_category_o =>per_cag_shd.g_old_rec.cag_information_category,
314: p_cag_information1_o =>per_cag_shd.g_old_rec.cag_information1,
315: p_cag_information2_o =>per_cag_shd.g_old_rec.cag_information2,
316: p_cag_information3_o =>per_cag_shd.g_old_rec.cag_information3,
317: p_cag_information4_o =>per_cag_shd.g_old_rec.cag_information4,

Line 314: p_cag_information1_o =>per_cag_shd.g_old_rec.cag_information1,

310: p_jurisdiction_o =>per_cag_shd.g_old_rec.jurisdiction,
311: p_authorizing_body_o =>per_cag_shd.g_old_rec.authorizing_body,
312: p_authorized_date_o =>per_cag_shd.g_old_rec.authorized_date,
313: p_cag_information_category_o =>per_cag_shd.g_old_rec.cag_information_category,
314: p_cag_information1_o =>per_cag_shd.g_old_rec.cag_information1,
315: p_cag_information2_o =>per_cag_shd.g_old_rec.cag_information2,
316: p_cag_information3_o =>per_cag_shd.g_old_rec.cag_information3,
317: p_cag_information4_o =>per_cag_shd.g_old_rec.cag_information4,
318: p_cag_information5_o =>per_cag_shd.g_old_rec.cag_information5,

Line 315: p_cag_information2_o =>per_cag_shd.g_old_rec.cag_information2,

311: p_authorizing_body_o =>per_cag_shd.g_old_rec.authorizing_body,
312: p_authorized_date_o =>per_cag_shd.g_old_rec.authorized_date,
313: p_cag_information_category_o =>per_cag_shd.g_old_rec.cag_information_category,
314: p_cag_information1_o =>per_cag_shd.g_old_rec.cag_information1,
315: p_cag_information2_o =>per_cag_shd.g_old_rec.cag_information2,
316: p_cag_information3_o =>per_cag_shd.g_old_rec.cag_information3,
317: p_cag_information4_o =>per_cag_shd.g_old_rec.cag_information4,
318: p_cag_information5_o =>per_cag_shd.g_old_rec.cag_information5,
319: p_cag_information6_o =>per_cag_shd.g_old_rec.cag_information6,

Line 316: p_cag_information3_o =>per_cag_shd.g_old_rec.cag_information3,

312: p_authorized_date_o =>per_cag_shd.g_old_rec.authorized_date,
313: p_cag_information_category_o =>per_cag_shd.g_old_rec.cag_information_category,
314: p_cag_information1_o =>per_cag_shd.g_old_rec.cag_information1,
315: p_cag_information2_o =>per_cag_shd.g_old_rec.cag_information2,
316: p_cag_information3_o =>per_cag_shd.g_old_rec.cag_information3,
317: p_cag_information4_o =>per_cag_shd.g_old_rec.cag_information4,
318: p_cag_information5_o =>per_cag_shd.g_old_rec.cag_information5,
319: p_cag_information6_o =>per_cag_shd.g_old_rec.cag_information6,
320: p_cag_information7_o =>per_cag_shd.g_old_rec.cag_information7,

Line 317: p_cag_information4_o =>per_cag_shd.g_old_rec.cag_information4,

313: p_cag_information_category_o =>per_cag_shd.g_old_rec.cag_information_category,
314: p_cag_information1_o =>per_cag_shd.g_old_rec.cag_information1,
315: p_cag_information2_o =>per_cag_shd.g_old_rec.cag_information2,
316: p_cag_information3_o =>per_cag_shd.g_old_rec.cag_information3,
317: p_cag_information4_o =>per_cag_shd.g_old_rec.cag_information4,
318: p_cag_information5_o =>per_cag_shd.g_old_rec.cag_information5,
319: p_cag_information6_o =>per_cag_shd.g_old_rec.cag_information6,
320: p_cag_information7_o =>per_cag_shd.g_old_rec.cag_information7,
321: p_cag_information8_o =>per_cag_shd.g_old_rec.cag_information8,

Line 318: p_cag_information5_o =>per_cag_shd.g_old_rec.cag_information5,

314: p_cag_information1_o =>per_cag_shd.g_old_rec.cag_information1,
315: p_cag_information2_o =>per_cag_shd.g_old_rec.cag_information2,
316: p_cag_information3_o =>per_cag_shd.g_old_rec.cag_information3,
317: p_cag_information4_o =>per_cag_shd.g_old_rec.cag_information4,
318: p_cag_information5_o =>per_cag_shd.g_old_rec.cag_information5,
319: p_cag_information6_o =>per_cag_shd.g_old_rec.cag_information6,
320: p_cag_information7_o =>per_cag_shd.g_old_rec.cag_information7,
321: p_cag_information8_o =>per_cag_shd.g_old_rec.cag_information8,
322: p_cag_information9_o =>per_cag_shd.g_old_rec.cag_information9,

Line 319: p_cag_information6_o =>per_cag_shd.g_old_rec.cag_information6,

315: p_cag_information2_o =>per_cag_shd.g_old_rec.cag_information2,
316: p_cag_information3_o =>per_cag_shd.g_old_rec.cag_information3,
317: p_cag_information4_o =>per_cag_shd.g_old_rec.cag_information4,
318: p_cag_information5_o =>per_cag_shd.g_old_rec.cag_information5,
319: p_cag_information6_o =>per_cag_shd.g_old_rec.cag_information6,
320: p_cag_information7_o =>per_cag_shd.g_old_rec.cag_information7,
321: p_cag_information8_o =>per_cag_shd.g_old_rec.cag_information8,
322: p_cag_information9_o =>per_cag_shd.g_old_rec.cag_information9,
323: p_cag_information10_o =>per_cag_shd.g_old_rec.cag_information10,

Line 320: p_cag_information7_o =>per_cag_shd.g_old_rec.cag_information7,

316: p_cag_information3_o =>per_cag_shd.g_old_rec.cag_information3,
317: p_cag_information4_o =>per_cag_shd.g_old_rec.cag_information4,
318: p_cag_information5_o =>per_cag_shd.g_old_rec.cag_information5,
319: p_cag_information6_o =>per_cag_shd.g_old_rec.cag_information6,
320: p_cag_information7_o =>per_cag_shd.g_old_rec.cag_information7,
321: p_cag_information8_o =>per_cag_shd.g_old_rec.cag_information8,
322: p_cag_information9_o =>per_cag_shd.g_old_rec.cag_information9,
323: p_cag_information10_o =>per_cag_shd.g_old_rec.cag_information10,
324: p_cag_information11_o =>per_cag_shd.g_old_rec.cag_information11,

Line 321: p_cag_information8_o =>per_cag_shd.g_old_rec.cag_information8,

317: p_cag_information4_o =>per_cag_shd.g_old_rec.cag_information4,
318: p_cag_information5_o =>per_cag_shd.g_old_rec.cag_information5,
319: p_cag_information6_o =>per_cag_shd.g_old_rec.cag_information6,
320: p_cag_information7_o =>per_cag_shd.g_old_rec.cag_information7,
321: p_cag_information8_o =>per_cag_shd.g_old_rec.cag_information8,
322: p_cag_information9_o =>per_cag_shd.g_old_rec.cag_information9,
323: p_cag_information10_o =>per_cag_shd.g_old_rec.cag_information10,
324: p_cag_information11_o =>per_cag_shd.g_old_rec.cag_information11,
325: p_cag_information12_o =>per_cag_shd.g_old_rec.cag_information12,

Line 322: p_cag_information9_o =>per_cag_shd.g_old_rec.cag_information9,

318: p_cag_information5_o =>per_cag_shd.g_old_rec.cag_information5,
319: p_cag_information6_o =>per_cag_shd.g_old_rec.cag_information6,
320: p_cag_information7_o =>per_cag_shd.g_old_rec.cag_information7,
321: p_cag_information8_o =>per_cag_shd.g_old_rec.cag_information8,
322: p_cag_information9_o =>per_cag_shd.g_old_rec.cag_information9,
323: p_cag_information10_o =>per_cag_shd.g_old_rec.cag_information10,
324: p_cag_information11_o =>per_cag_shd.g_old_rec.cag_information11,
325: p_cag_information12_o =>per_cag_shd.g_old_rec.cag_information12,
326: p_cag_information13_o =>per_cag_shd.g_old_rec.cag_information13,

Line 323: p_cag_information10_o =>per_cag_shd.g_old_rec.cag_information10,

319: p_cag_information6_o =>per_cag_shd.g_old_rec.cag_information6,
320: p_cag_information7_o =>per_cag_shd.g_old_rec.cag_information7,
321: p_cag_information8_o =>per_cag_shd.g_old_rec.cag_information8,
322: p_cag_information9_o =>per_cag_shd.g_old_rec.cag_information9,
323: p_cag_information10_o =>per_cag_shd.g_old_rec.cag_information10,
324: p_cag_information11_o =>per_cag_shd.g_old_rec.cag_information11,
325: p_cag_information12_o =>per_cag_shd.g_old_rec.cag_information12,
326: p_cag_information13_o =>per_cag_shd.g_old_rec.cag_information13,
327: p_cag_information14_o =>per_cag_shd.g_old_rec.cag_information14,

Line 324: p_cag_information11_o =>per_cag_shd.g_old_rec.cag_information11,

320: p_cag_information7_o =>per_cag_shd.g_old_rec.cag_information7,
321: p_cag_information8_o =>per_cag_shd.g_old_rec.cag_information8,
322: p_cag_information9_o =>per_cag_shd.g_old_rec.cag_information9,
323: p_cag_information10_o =>per_cag_shd.g_old_rec.cag_information10,
324: p_cag_information11_o =>per_cag_shd.g_old_rec.cag_information11,
325: p_cag_information12_o =>per_cag_shd.g_old_rec.cag_information12,
326: p_cag_information13_o =>per_cag_shd.g_old_rec.cag_information13,
327: p_cag_information14_o =>per_cag_shd.g_old_rec.cag_information14,
328: p_cag_information15_o =>per_cag_shd.g_old_rec.cag_information15,

Line 325: p_cag_information12_o =>per_cag_shd.g_old_rec.cag_information12,

321: p_cag_information8_o =>per_cag_shd.g_old_rec.cag_information8,
322: p_cag_information9_o =>per_cag_shd.g_old_rec.cag_information9,
323: p_cag_information10_o =>per_cag_shd.g_old_rec.cag_information10,
324: p_cag_information11_o =>per_cag_shd.g_old_rec.cag_information11,
325: p_cag_information12_o =>per_cag_shd.g_old_rec.cag_information12,
326: p_cag_information13_o =>per_cag_shd.g_old_rec.cag_information13,
327: p_cag_information14_o =>per_cag_shd.g_old_rec.cag_information14,
328: p_cag_information15_o =>per_cag_shd.g_old_rec.cag_information15,
329: p_cag_information16_o =>per_cag_shd.g_old_rec.cag_information16,

Line 326: p_cag_information13_o =>per_cag_shd.g_old_rec.cag_information13,

322: p_cag_information9_o =>per_cag_shd.g_old_rec.cag_information9,
323: p_cag_information10_o =>per_cag_shd.g_old_rec.cag_information10,
324: p_cag_information11_o =>per_cag_shd.g_old_rec.cag_information11,
325: p_cag_information12_o =>per_cag_shd.g_old_rec.cag_information12,
326: p_cag_information13_o =>per_cag_shd.g_old_rec.cag_information13,
327: p_cag_information14_o =>per_cag_shd.g_old_rec.cag_information14,
328: p_cag_information15_o =>per_cag_shd.g_old_rec.cag_information15,
329: p_cag_information16_o =>per_cag_shd.g_old_rec.cag_information16,
330: p_cag_information17_o =>per_cag_shd.g_old_rec.cag_information17,

Line 327: p_cag_information14_o =>per_cag_shd.g_old_rec.cag_information14,

323: p_cag_information10_o =>per_cag_shd.g_old_rec.cag_information10,
324: p_cag_information11_o =>per_cag_shd.g_old_rec.cag_information11,
325: p_cag_information12_o =>per_cag_shd.g_old_rec.cag_information12,
326: p_cag_information13_o =>per_cag_shd.g_old_rec.cag_information13,
327: p_cag_information14_o =>per_cag_shd.g_old_rec.cag_information14,
328: p_cag_information15_o =>per_cag_shd.g_old_rec.cag_information15,
329: p_cag_information16_o =>per_cag_shd.g_old_rec.cag_information16,
330: p_cag_information17_o =>per_cag_shd.g_old_rec.cag_information17,
331: p_cag_information18_o =>per_cag_shd.g_old_rec.cag_information18,

Line 328: p_cag_information15_o =>per_cag_shd.g_old_rec.cag_information15,

324: p_cag_information11_o =>per_cag_shd.g_old_rec.cag_information11,
325: p_cag_information12_o =>per_cag_shd.g_old_rec.cag_information12,
326: p_cag_information13_o =>per_cag_shd.g_old_rec.cag_information13,
327: p_cag_information14_o =>per_cag_shd.g_old_rec.cag_information14,
328: p_cag_information15_o =>per_cag_shd.g_old_rec.cag_information15,
329: p_cag_information16_o =>per_cag_shd.g_old_rec.cag_information16,
330: p_cag_information17_o =>per_cag_shd.g_old_rec.cag_information17,
331: p_cag_information18_o =>per_cag_shd.g_old_rec.cag_information18,
332: p_cag_information19_o =>per_cag_shd.g_old_rec.cag_information19,

Line 329: p_cag_information16_o =>per_cag_shd.g_old_rec.cag_information16,

325: p_cag_information12_o =>per_cag_shd.g_old_rec.cag_information12,
326: p_cag_information13_o =>per_cag_shd.g_old_rec.cag_information13,
327: p_cag_information14_o =>per_cag_shd.g_old_rec.cag_information14,
328: p_cag_information15_o =>per_cag_shd.g_old_rec.cag_information15,
329: p_cag_information16_o =>per_cag_shd.g_old_rec.cag_information16,
330: p_cag_information17_o =>per_cag_shd.g_old_rec.cag_information17,
331: p_cag_information18_o =>per_cag_shd.g_old_rec.cag_information18,
332: p_cag_information19_o =>per_cag_shd.g_old_rec.cag_information19,
333: p_cag_information20_o =>per_cag_shd.g_old_rec.cag_information20,

Line 330: p_cag_information17_o =>per_cag_shd.g_old_rec.cag_information17,

326: p_cag_information13_o =>per_cag_shd.g_old_rec.cag_information13,
327: p_cag_information14_o =>per_cag_shd.g_old_rec.cag_information14,
328: p_cag_information15_o =>per_cag_shd.g_old_rec.cag_information15,
329: p_cag_information16_o =>per_cag_shd.g_old_rec.cag_information16,
330: p_cag_information17_o =>per_cag_shd.g_old_rec.cag_information17,
331: p_cag_information18_o =>per_cag_shd.g_old_rec.cag_information18,
332: p_cag_information19_o =>per_cag_shd.g_old_rec.cag_information19,
333: p_cag_information20_o =>per_cag_shd.g_old_rec.cag_information20,
334: p_attribute_category_o =>per_cag_shd.g_old_rec.attribute_category,

Line 331: p_cag_information18_o =>per_cag_shd.g_old_rec.cag_information18,

327: p_cag_information14_o =>per_cag_shd.g_old_rec.cag_information14,
328: p_cag_information15_o =>per_cag_shd.g_old_rec.cag_information15,
329: p_cag_information16_o =>per_cag_shd.g_old_rec.cag_information16,
330: p_cag_information17_o =>per_cag_shd.g_old_rec.cag_information17,
331: p_cag_information18_o =>per_cag_shd.g_old_rec.cag_information18,
332: p_cag_information19_o =>per_cag_shd.g_old_rec.cag_information19,
333: p_cag_information20_o =>per_cag_shd.g_old_rec.cag_information20,
334: p_attribute_category_o =>per_cag_shd.g_old_rec.attribute_category,
335: p_attribute1_o =>per_cag_shd.g_old_rec.attribute1,

Line 332: p_cag_information19_o =>per_cag_shd.g_old_rec.cag_information19,

328: p_cag_information15_o =>per_cag_shd.g_old_rec.cag_information15,
329: p_cag_information16_o =>per_cag_shd.g_old_rec.cag_information16,
330: p_cag_information17_o =>per_cag_shd.g_old_rec.cag_information17,
331: p_cag_information18_o =>per_cag_shd.g_old_rec.cag_information18,
332: p_cag_information19_o =>per_cag_shd.g_old_rec.cag_information19,
333: p_cag_information20_o =>per_cag_shd.g_old_rec.cag_information20,
334: p_attribute_category_o =>per_cag_shd.g_old_rec.attribute_category,
335: p_attribute1_o =>per_cag_shd.g_old_rec.attribute1,
336: p_attribute2_o =>per_cag_shd.g_old_rec.attribute2,

Line 333: p_cag_information20_o =>per_cag_shd.g_old_rec.cag_information20,

329: p_cag_information16_o =>per_cag_shd.g_old_rec.cag_information16,
330: p_cag_information17_o =>per_cag_shd.g_old_rec.cag_information17,
331: p_cag_information18_o =>per_cag_shd.g_old_rec.cag_information18,
332: p_cag_information19_o =>per_cag_shd.g_old_rec.cag_information19,
333: p_cag_information20_o =>per_cag_shd.g_old_rec.cag_information20,
334: p_attribute_category_o =>per_cag_shd.g_old_rec.attribute_category,
335: p_attribute1_o =>per_cag_shd.g_old_rec.attribute1,
336: p_attribute2_o =>per_cag_shd.g_old_rec.attribute2,
337: p_attribute3_o =>per_cag_shd.g_old_rec.attribute3,

Line 334: p_attribute_category_o =>per_cag_shd.g_old_rec.attribute_category,

330: p_cag_information17_o =>per_cag_shd.g_old_rec.cag_information17,
331: p_cag_information18_o =>per_cag_shd.g_old_rec.cag_information18,
332: p_cag_information19_o =>per_cag_shd.g_old_rec.cag_information19,
333: p_cag_information20_o =>per_cag_shd.g_old_rec.cag_information20,
334: p_attribute_category_o =>per_cag_shd.g_old_rec.attribute_category,
335: p_attribute1_o =>per_cag_shd.g_old_rec.attribute1,
336: p_attribute2_o =>per_cag_shd.g_old_rec.attribute2,
337: p_attribute3_o =>per_cag_shd.g_old_rec.attribute3,
338: p_attribute4_o =>per_cag_shd.g_old_rec.attribute4,

Line 335: p_attribute1_o =>per_cag_shd.g_old_rec.attribute1,

331: p_cag_information18_o =>per_cag_shd.g_old_rec.cag_information18,
332: p_cag_information19_o =>per_cag_shd.g_old_rec.cag_information19,
333: p_cag_information20_o =>per_cag_shd.g_old_rec.cag_information20,
334: p_attribute_category_o =>per_cag_shd.g_old_rec.attribute_category,
335: p_attribute1_o =>per_cag_shd.g_old_rec.attribute1,
336: p_attribute2_o =>per_cag_shd.g_old_rec.attribute2,
337: p_attribute3_o =>per_cag_shd.g_old_rec.attribute3,
338: p_attribute4_o =>per_cag_shd.g_old_rec.attribute4,
339: p_attribute5_o =>per_cag_shd.g_old_rec.attribute5,

Line 336: p_attribute2_o =>per_cag_shd.g_old_rec.attribute2,

332: p_cag_information19_o =>per_cag_shd.g_old_rec.cag_information19,
333: p_cag_information20_o =>per_cag_shd.g_old_rec.cag_information20,
334: p_attribute_category_o =>per_cag_shd.g_old_rec.attribute_category,
335: p_attribute1_o =>per_cag_shd.g_old_rec.attribute1,
336: p_attribute2_o =>per_cag_shd.g_old_rec.attribute2,
337: p_attribute3_o =>per_cag_shd.g_old_rec.attribute3,
338: p_attribute4_o =>per_cag_shd.g_old_rec.attribute4,
339: p_attribute5_o =>per_cag_shd.g_old_rec.attribute5,
340: p_attribute6_o =>per_cag_shd.g_old_rec.attribute6,

Line 337: p_attribute3_o =>per_cag_shd.g_old_rec.attribute3,

333: p_cag_information20_o =>per_cag_shd.g_old_rec.cag_information20,
334: p_attribute_category_o =>per_cag_shd.g_old_rec.attribute_category,
335: p_attribute1_o =>per_cag_shd.g_old_rec.attribute1,
336: p_attribute2_o =>per_cag_shd.g_old_rec.attribute2,
337: p_attribute3_o =>per_cag_shd.g_old_rec.attribute3,
338: p_attribute4_o =>per_cag_shd.g_old_rec.attribute4,
339: p_attribute5_o =>per_cag_shd.g_old_rec.attribute5,
340: p_attribute6_o =>per_cag_shd.g_old_rec.attribute6,
341: p_attribute7_o =>per_cag_shd.g_old_rec.attribute7,

Line 338: p_attribute4_o =>per_cag_shd.g_old_rec.attribute4,

334: p_attribute_category_o =>per_cag_shd.g_old_rec.attribute_category,
335: p_attribute1_o =>per_cag_shd.g_old_rec.attribute1,
336: p_attribute2_o =>per_cag_shd.g_old_rec.attribute2,
337: p_attribute3_o =>per_cag_shd.g_old_rec.attribute3,
338: p_attribute4_o =>per_cag_shd.g_old_rec.attribute4,
339: p_attribute5_o =>per_cag_shd.g_old_rec.attribute5,
340: p_attribute6_o =>per_cag_shd.g_old_rec.attribute6,
341: p_attribute7_o =>per_cag_shd.g_old_rec.attribute7,
342: p_attribute8_o =>per_cag_shd.g_old_rec.attribute8,

Line 339: p_attribute5_o =>per_cag_shd.g_old_rec.attribute5,

335: p_attribute1_o =>per_cag_shd.g_old_rec.attribute1,
336: p_attribute2_o =>per_cag_shd.g_old_rec.attribute2,
337: p_attribute3_o =>per_cag_shd.g_old_rec.attribute3,
338: p_attribute4_o =>per_cag_shd.g_old_rec.attribute4,
339: p_attribute5_o =>per_cag_shd.g_old_rec.attribute5,
340: p_attribute6_o =>per_cag_shd.g_old_rec.attribute6,
341: p_attribute7_o =>per_cag_shd.g_old_rec.attribute7,
342: p_attribute8_o =>per_cag_shd.g_old_rec.attribute8,
343: p_attribute9_o =>per_cag_shd.g_old_rec.attribute9,

Line 340: p_attribute6_o =>per_cag_shd.g_old_rec.attribute6,

336: p_attribute2_o =>per_cag_shd.g_old_rec.attribute2,
337: p_attribute3_o =>per_cag_shd.g_old_rec.attribute3,
338: p_attribute4_o =>per_cag_shd.g_old_rec.attribute4,
339: p_attribute5_o =>per_cag_shd.g_old_rec.attribute5,
340: p_attribute6_o =>per_cag_shd.g_old_rec.attribute6,
341: p_attribute7_o =>per_cag_shd.g_old_rec.attribute7,
342: p_attribute8_o =>per_cag_shd.g_old_rec.attribute8,
343: p_attribute9_o =>per_cag_shd.g_old_rec.attribute9,
344: p_attribute10_o =>per_cag_shd.g_old_rec.attribute10,

Line 341: p_attribute7_o =>per_cag_shd.g_old_rec.attribute7,

337: p_attribute3_o =>per_cag_shd.g_old_rec.attribute3,
338: p_attribute4_o =>per_cag_shd.g_old_rec.attribute4,
339: p_attribute5_o =>per_cag_shd.g_old_rec.attribute5,
340: p_attribute6_o =>per_cag_shd.g_old_rec.attribute6,
341: p_attribute7_o =>per_cag_shd.g_old_rec.attribute7,
342: p_attribute8_o =>per_cag_shd.g_old_rec.attribute8,
343: p_attribute9_o =>per_cag_shd.g_old_rec.attribute9,
344: p_attribute10_o =>per_cag_shd.g_old_rec.attribute10,
345: p_attribute11_o =>per_cag_shd.g_old_rec.attribute11,

Line 342: p_attribute8_o =>per_cag_shd.g_old_rec.attribute8,

338: p_attribute4_o =>per_cag_shd.g_old_rec.attribute4,
339: p_attribute5_o =>per_cag_shd.g_old_rec.attribute5,
340: p_attribute6_o =>per_cag_shd.g_old_rec.attribute6,
341: p_attribute7_o =>per_cag_shd.g_old_rec.attribute7,
342: p_attribute8_o =>per_cag_shd.g_old_rec.attribute8,
343: p_attribute9_o =>per_cag_shd.g_old_rec.attribute9,
344: p_attribute10_o =>per_cag_shd.g_old_rec.attribute10,
345: p_attribute11_o =>per_cag_shd.g_old_rec.attribute11,
346: p_attribute12_o =>per_cag_shd.g_old_rec.attribute12,

Line 343: p_attribute9_o =>per_cag_shd.g_old_rec.attribute9,

339: p_attribute5_o =>per_cag_shd.g_old_rec.attribute5,
340: p_attribute6_o =>per_cag_shd.g_old_rec.attribute6,
341: p_attribute7_o =>per_cag_shd.g_old_rec.attribute7,
342: p_attribute8_o =>per_cag_shd.g_old_rec.attribute8,
343: p_attribute9_o =>per_cag_shd.g_old_rec.attribute9,
344: p_attribute10_o =>per_cag_shd.g_old_rec.attribute10,
345: p_attribute11_o =>per_cag_shd.g_old_rec.attribute11,
346: p_attribute12_o =>per_cag_shd.g_old_rec.attribute12,
347: p_attribute13_o =>per_cag_shd.g_old_rec.attribute13,

Line 344: p_attribute10_o =>per_cag_shd.g_old_rec.attribute10,

340: p_attribute6_o =>per_cag_shd.g_old_rec.attribute6,
341: p_attribute7_o =>per_cag_shd.g_old_rec.attribute7,
342: p_attribute8_o =>per_cag_shd.g_old_rec.attribute8,
343: p_attribute9_o =>per_cag_shd.g_old_rec.attribute9,
344: p_attribute10_o =>per_cag_shd.g_old_rec.attribute10,
345: p_attribute11_o =>per_cag_shd.g_old_rec.attribute11,
346: p_attribute12_o =>per_cag_shd.g_old_rec.attribute12,
347: p_attribute13_o =>per_cag_shd.g_old_rec.attribute13,
348: p_attribute14_o =>per_cag_shd.g_old_rec.attribute14,

Line 345: p_attribute11_o =>per_cag_shd.g_old_rec.attribute11,

341: p_attribute7_o =>per_cag_shd.g_old_rec.attribute7,
342: p_attribute8_o =>per_cag_shd.g_old_rec.attribute8,
343: p_attribute9_o =>per_cag_shd.g_old_rec.attribute9,
344: p_attribute10_o =>per_cag_shd.g_old_rec.attribute10,
345: p_attribute11_o =>per_cag_shd.g_old_rec.attribute11,
346: p_attribute12_o =>per_cag_shd.g_old_rec.attribute12,
347: p_attribute13_o =>per_cag_shd.g_old_rec.attribute13,
348: p_attribute14_o =>per_cag_shd.g_old_rec.attribute14,
349: p_attribute15_o =>per_cag_shd.g_old_rec.attribute15,

Line 346: p_attribute12_o =>per_cag_shd.g_old_rec.attribute12,

342: p_attribute8_o =>per_cag_shd.g_old_rec.attribute8,
343: p_attribute9_o =>per_cag_shd.g_old_rec.attribute9,
344: p_attribute10_o =>per_cag_shd.g_old_rec.attribute10,
345: p_attribute11_o =>per_cag_shd.g_old_rec.attribute11,
346: p_attribute12_o =>per_cag_shd.g_old_rec.attribute12,
347: p_attribute13_o =>per_cag_shd.g_old_rec.attribute13,
348: p_attribute14_o =>per_cag_shd.g_old_rec.attribute14,
349: p_attribute15_o =>per_cag_shd.g_old_rec.attribute15,
350: p_attribute16_o =>per_cag_shd.g_old_rec.attribute16,

Line 347: p_attribute13_o =>per_cag_shd.g_old_rec.attribute13,

343: p_attribute9_o =>per_cag_shd.g_old_rec.attribute9,
344: p_attribute10_o =>per_cag_shd.g_old_rec.attribute10,
345: p_attribute11_o =>per_cag_shd.g_old_rec.attribute11,
346: p_attribute12_o =>per_cag_shd.g_old_rec.attribute12,
347: p_attribute13_o =>per_cag_shd.g_old_rec.attribute13,
348: p_attribute14_o =>per_cag_shd.g_old_rec.attribute14,
349: p_attribute15_o =>per_cag_shd.g_old_rec.attribute15,
350: p_attribute16_o =>per_cag_shd.g_old_rec.attribute16,
351: p_attribute17_o =>per_cag_shd.g_old_rec.attribute17,

Line 348: p_attribute14_o =>per_cag_shd.g_old_rec.attribute14,

344: p_attribute10_o =>per_cag_shd.g_old_rec.attribute10,
345: p_attribute11_o =>per_cag_shd.g_old_rec.attribute11,
346: p_attribute12_o =>per_cag_shd.g_old_rec.attribute12,
347: p_attribute13_o =>per_cag_shd.g_old_rec.attribute13,
348: p_attribute14_o =>per_cag_shd.g_old_rec.attribute14,
349: p_attribute15_o =>per_cag_shd.g_old_rec.attribute15,
350: p_attribute16_o =>per_cag_shd.g_old_rec.attribute16,
351: p_attribute17_o =>per_cag_shd.g_old_rec.attribute17,
352: p_attribute18_o =>per_cag_shd.g_old_rec.attribute18,

Line 349: p_attribute15_o =>per_cag_shd.g_old_rec.attribute15,

345: p_attribute11_o =>per_cag_shd.g_old_rec.attribute11,
346: p_attribute12_o =>per_cag_shd.g_old_rec.attribute12,
347: p_attribute13_o =>per_cag_shd.g_old_rec.attribute13,
348: p_attribute14_o =>per_cag_shd.g_old_rec.attribute14,
349: p_attribute15_o =>per_cag_shd.g_old_rec.attribute15,
350: p_attribute16_o =>per_cag_shd.g_old_rec.attribute16,
351: p_attribute17_o =>per_cag_shd.g_old_rec.attribute17,
352: p_attribute18_o =>per_cag_shd.g_old_rec.attribute18,
353: p_attribute19_o =>per_cag_shd.g_old_rec.attribute19,

Line 350: p_attribute16_o =>per_cag_shd.g_old_rec.attribute16,

346: p_attribute12_o =>per_cag_shd.g_old_rec.attribute12,
347: p_attribute13_o =>per_cag_shd.g_old_rec.attribute13,
348: p_attribute14_o =>per_cag_shd.g_old_rec.attribute14,
349: p_attribute15_o =>per_cag_shd.g_old_rec.attribute15,
350: p_attribute16_o =>per_cag_shd.g_old_rec.attribute16,
351: p_attribute17_o =>per_cag_shd.g_old_rec.attribute17,
352: p_attribute18_o =>per_cag_shd.g_old_rec.attribute18,
353: p_attribute19_o =>per_cag_shd.g_old_rec.attribute19,
354: p_attribute20_o =>per_cag_shd.g_old_rec.attribute20

Line 351: p_attribute17_o =>per_cag_shd.g_old_rec.attribute17,

347: p_attribute13_o =>per_cag_shd.g_old_rec.attribute13,
348: p_attribute14_o =>per_cag_shd.g_old_rec.attribute14,
349: p_attribute15_o =>per_cag_shd.g_old_rec.attribute15,
350: p_attribute16_o =>per_cag_shd.g_old_rec.attribute16,
351: p_attribute17_o =>per_cag_shd.g_old_rec.attribute17,
352: p_attribute18_o =>per_cag_shd.g_old_rec.attribute18,
353: p_attribute19_o =>per_cag_shd.g_old_rec.attribute19,
354: p_attribute20_o =>per_cag_shd.g_old_rec.attribute20
355: );

Line 352: p_attribute18_o =>per_cag_shd.g_old_rec.attribute18,

348: p_attribute14_o =>per_cag_shd.g_old_rec.attribute14,
349: p_attribute15_o =>per_cag_shd.g_old_rec.attribute15,
350: p_attribute16_o =>per_cag_shd.g_old_rec.attribute16,
351: p_attribute17_o =>per_cag_shd.g_old_rec.attribute17,
352: p_attribute18_o =>per_cag_shd.g_old_rec.attribute18,
353: p_attribute19_o =>per_cag_shd.g_old_rec.attribute19,
354: p_attribute20_o =>per_cag_shd.g_old_rec.attribute20
355: );
356: --

Line 353: p_attribute19_o =>per_cag_shd.g_old_rec.attribute19,

349: p_attribute15_o =>per_cag_shd.g_old_rec.attribute15,
350: p_attribute16_o =>per_cag_shd.g_old_rec.attribute16,
351: p_attribute17_o =>per_cag_shd.g_old_rec.attribute17,
352: p_attribute18_o =>per_cag_shd.g_old_rec.attribute18,
353: p_attribute19_o =>per_cag_shd.g_old_rec.attribute19,
354: p_attribute20_o =>per_cag_shd.g_old_rec.attribute20
355: );
356: --
357: exception

Line 354: p_attribute20_o =>per_cag_shd.g_old_rec.attribute20

350: p_attribute16_o =>per_cag_shd.g_old_rec.attribute16,
351: p_attribute17_o =>per_cag_shd.g_old_rec.attribute17,
352: p_attribute18_o =>per_cag_shd.g_old_rec.attribute18,
353: p_attribute19_o =>per_cag_shd.g_old_rec.attribute19,
354: p_attribute20_o =>per_cag_shd.g_old_rec.attribute20
355: );
356: --
357: exception
358: --

Line 417: Procedure convert_defs(p_rec in out nocopy per_cag_shd.g_rec_type) is

413: -- Internal Row Handler Use Only.
414: --
415: -- {End Of Comments}
416: -- ----------------------------------------------------------------------------
417: Procedure convert_defs(p_rec in out nocopy per_cag_shd.g_rec_type) is
418: --
419: l_proc varchar2(72) := g_package||'convert_defs';
420: --
421: Begin

Line 432: per_cag_shd.g_old_rec.business_group_id;

428: -- is being used then we must set to the 'current' argument value.
429: --
430: If (p_rec.business_group_id = hr_api.g_number) then
431: p_rec.business_group_id :=
432: per_cag_shd.g_old_rec.business_group_id;
433: End If;
434: If (p_rec.name = hr_api.g_varchar2) then
435: p_rec.name :=
436: per_cag_shd.g_old_rec.name;

Line 436: per_cag_shd.g_old_rec.name;

432: per_cag_shd.g_old_rec.business_group_id;
433: End If;
434: If (p_rec.name = hr_api.g_varchar2) then
435: p_rec.name :=
436: per_cag_shd.g_old_rec.name;
437: End If;
438: If (p_rec.status = hr_api.g_varchar2) then
439: p_rec.status :=
440: per_cag_shd.g_old_rec.status;

Line 440: per_cag_shd.g_old_rec.status;

436: per_cag_shd.g_old_rec.name;
437: End If;
438: If (p_rec.status = hr_api.g_varchar2) then
439: p_rec.status :=
440: per_cag_shd.g_old_rec.status;
441: End If;
442:
443:
444: If (p_rec.cag_number = hr_api.g_number) then

Line 446: per_cag_shd.g_old_rec.cag_number;

442:
443:
444: If (p_rec.cag_number = hr_api.g_number) then
445: p_rec.cag_number :=
446: per_cag_shd.g_old_rec.cag_number;
447: End If;
448: If (p_rec.description = hr_api.g_varchar2) then
449: p_rec.description :=
450: per_cag_shd.g_old_rec.description;

Line 450: per_cag_shd.g_old_rec.description;

446: per_cag_shd.g_old_rec.cag_number;
447: End If;
448: If (p_rec.description = hr_api.g_varchar2) then
449: p_rec.description :=
450: per_cag_shd.g_old_rec.description;
451: End If;
452: If (p_rec.start_date = hr_api.g_date) then
453: p_rec.start_date :=
454: per_cag_shd.g_old_rec.start_date;

Line 454: per_cag_shd.g_old_rec.start_date;

450: per_cag_shd.g_old_rec.description;
451: End If;
452: If (p_rec.start_date = hr_api.g_date) then
453: p_rec.start_date :=
454: per_cag_shd.g_old_rec.start_date;
455: End If;
456: If (p_rec.end_date = hr_api.g_date) then
457: p_rec.end_date :=
458: per_cag_shd.g_old_rec.end_date;

Line 458: per_cag_shd.g_old_rec.end_date;

454: per_cag_shd.g_old_rec.start_date;
455: End If;
456: If (p_rec.end_date = hr_api.g_date) then
457: p_rec.end_date :=
458: per_cag_shd.g_old_rec.end_date;
459: End If;
460: If (p_rec.employer_organization_id = hr_api.g_number) then
461: p_rec.employer_organization_id :=
462: per_cag_shd.g_old_rec.employer_organization_id;

Line 462: per_cag_shd.g_old_rec.employer_organization_id;

458: per_cag_shd.g_old_rec.end_date;
459: End If;
460: If (p_rec.employer_organization_id = hr_api.g_number) then
461: p_rec.employer_organization_id :=
462: per_cag_shd.g_old_rec.employer_organization_id;
463: End If;
464: If (p_rec.employer_signatory = hr_api.g_varchar2) then
465: p_rec.employer_signatory :=
466: per_cag_shd.g_old_rec.employer_signatory;

Line 466: per_cag_shd.g_old_rec.employer_signatory;

462: per_cag_shd.g_old_rec.employer_organization_id;
463: End If;
464: If (p_rec.employer_signatory = hr_api.g_varchar2) then
465: p_rec.employer_signatory :=
466: per_cag_shd.g_old_rec.employer_signatory;
467: End If;
468: If (p_rec.bargaining_organization_id = hr_api.g_number) then
469: p_rec.bargaining_organization_id :=
470: per_cag_shd.g_old_rec.bargaining_organization_id;

Line 470: per_cag_shd.g_old_rec.bargaining_organization_id;

466: per_cag_shd.g_old_rec.employer_signatory;
467: End If;
468: If (p_rec.bargaining_organization_id = hr_api.g_number) then
469: p_rec.bargaining_organization_id :=
470: per_cag_shd.g_old_rec.bargaining_organization_id;
471: End If;
472: If (p_rec.bargaining_unit_signatory = hr_api.g_varchar2) then
473: p_rec.bargaining_unit_signatory :=
474: per_cag_shd.g_old_rec.bargaining_unit_signatory;

Line 474: per_cag_shd.g_old_rec.bargaining_unit_signatory;

470: per_cag_shd.g_old_rec.bargaining_organization_id;
471: End If;
472: If (p_rec.bargaining_unit_signatory = hr_api.g_varchar2) then
473: p_rec.bargaining_unit_signatory :=
474: per_cag_shd.g_old_rec.bargaining_unit_signatory;
475: End If;
476: If (p_rec.jurisdiction = hr_api.g_varchar2) then
477: p_rec.jurisdiction :=
478: per_cag_shd.g_old_rec.jurisdiction;

Line 478: per_cag_shd.g_old_rec.jurisdiction;

474: per_cag_shd.g_old_rec.bargaining_unit_signatory;
475: End If;
476: If (p_rec.jurisdiction = hr_api.g_varchar2) then
477: p_rec.jurisdiction :=
478: per_cag_shd.g_old_rec.jurisdiction;
479: End If;
480: If (p_rec.authorizing_body = hr_api.g_varchar2) then
481: p_rec.authorizing_body :=
482: per_cag_shd.g_old_rec.authorizing_body;

Line 482: per_cag_shd.g_old_rec.authorizing_body;

478: per_cag_shd.g_old_rec.jurisdiction;
479: End If;
480: If (p_rec.authorizing_body = hr_api.g_varchar2) then
481: p_rec.authorizing_body :=
482: per_cag_shd.g_old_rec.authorizing_body;
483: End If;
484: If (p_rec.authorized_date = hr_api.g_date) then
485: p_rec.authorized_date :=
486: per_cag_shd.g_old_rec.authorized_date;

Line 486: per_cag_shd.g_old_rec.authorized_date;

482: per_cag_shd.g_old_rec.authorizing_body;
483: End If;
484: If (p_rec.authorized_date = hr_api.g_date) then
485: p_rec.authorized_date :=
486: per_cag_shd.g_old_rec.authorized_date;
487: End If;
488: If (p_rec.cag_information_category = hr_api.g_varchar2) then
489: p_rec.cag_information_category :=
490: per_cag_shd.g_old_rec.cag_information_category;

Line 490: per_cag_shd.g_old_rec.cag_information_category;

486: per_cag_shd.g_old_rec.authorized_date;
487: End If;
488: If (p_rec.cag_information_category = hr_api.g_varchar2) then
489: p_rec.cag_information_category :=
490: per_cag_shd.g_old_rec.cag_information_category;
491: End If;
492: If (p_rec.cag_information1 = hr_api.g_varchar2) then
493: p_rec.cag_information1 :=
494: per_cag_shd.g_old_rec.cag_information1;

Line 494: per_cag_shd.g_old_rec.cag_information1;

490: per_cag_shd.g_old_rec.cag_information_category;
491: End If;
492: If (p_rec.cag_information1 = hr_api.g_varchar2) then
493: p_rec.cag_information1 :=
494: per_cag_shd.g_old_rec.cag_information1;
495: End If;
496: If (p_rec.cag_information2 = hr_api.g_varchar2) then
497: p_rec.cag_information2 :=
498: per_cag_shd.g_old_rec.cag_information2;

Line 498: per_cag_shd.g_old_rec.cag_information2;

494: per_cag_shd.g_old_rec.cag_information1;
495: End If;
496: If (p_rec.cag_information2 = hr_api.g_varchar2) then
497: p_rec.cag_information2 :=
498: per_cag_shd.g_old_rec.cag_information2;
499: End If;
500: If (p_rec.cag_information3 = hr_api.g_varchar2) then
501: p_rec.cag_information3 :=
502: per_cag_shd.g_old_rec.cag_information3;

Line 502: per_cag_shd.g_old_rec.cag_information3;

498: per_cag_shd.g_old_rec.cag_information2;
499: End If;
500: If (p_rec.cag_information3 = hr_api.g_varchar2) then
501: p_rec.cag_information3 :=
502: per_cag_shd.g_old_rec.cag_information3;
503: End If;
504: If (p_rec.cag_information4 = hr_api.g_varchar2) then
505: p_rec.cag_information4 :=
506: per_cag_shd.g_old_rec.cag_information4;

Line 506: per_cag_shd.g_old_rec.cag_information4;

502: per_cag_shd.g_old_rec.cag_information3;
503: End If;
504: If (p_rec.cag_information4 = hr_api.g_varchar2) then
505: p_rec.cag_information4 :=
506: per_cag_shd.g_old_rec.cag_information4;
507: End If;
508: If (p_rec.cag_information5 = hr_api.g_varchar2) then
509: p_rec.cag_information5 :=
510: per_cag_shd.g_old_rec.cag_information5;

Line 510: per_cag_shd.g_old_rec.cag_information5;

506: per_cag_shd.g_old_rec.cag_information4;
507: End If;
508: If (p_rec.cag_information5 = hr_api.g_varchar2) then
509: p_rec.cag_information5 :=
510: per_cag_shd.g_old_rec.cag_information5;
511: End If;
512: If (p_rec.cag_information6 = hr_api.g_varchar2) then
513: p_rec.cag_information6 :=
514: per_cag_shd.g_old_rec.cag_information6;

Line 514: per_cag_shd.g_old_rec.cag_information6;

510: per_cag_shd.g_old_rec.cag_information5;
511: End If;
512: If (p_rec.cag_information6 = hr_api.g_varchar2) then
513: p_rec.cag_information6 :=
514: per_cag_shd.g_old_rec.cag_information6;
515: End If;
516: If (p_rec.cag_information7 = hr_api.g_varchar2) then
517: p_rec.cag_information7 :=
518: per_cag_shd.g_old_rec.cag_information7;

Line 518: per_cag_shd.g_old_rec.cag_information7;

514: per_cag_shd.g_old_rec.cag_information6;
515: End If;
516: If (p_rec.cag_information7 = hr_api.g_varchar2) then
517: p_rec.cag_information7 :=
518: per_cag_shd.g_old_rec.cag_information7;
519: End If;
520: If (p_rec.cag_information8 = hr_api.g_varchar2) then
521: p_rec.cag_information8 :=
522: per_cag_shd.g_old_rec.cag_information8;

Line 522: per_cag_shd.g_old_rec.cag_information8;

518: per_cag_shd.g_old_rec.cag_information7;
519: End If;
520: If (p_rec.cag_information8 = hr_api.g_varchar2) then
521: p_rec.cag_information8 :=
522: per_cag_shd.g_old_rec.cag_information8;
523: End If;
524: If (p_rec.cag_information9 = hr_api.g_varchar2) then
525: p_rec.cag_information9 :=
526: per_cag_shd.g_old_rec.cag_information9;

Line 526: per_cag_shd.g_old_rec.cag_information9;

522: per_cag_shd.g_old_rec.cag_information8;
523: End If;
524: If (p_rec.cag_information9 = hr_api.g_varchar2) then
525: p_rec.cag_information9 :=
526: per_cag_shd.g_old_rec.cag_information9;
527: End If;
528: If (p_rec.cag_information10 = hr_api.g_varchar2) then
529: p_rec.cag_information10 :=
530: per_cag_shd.g_old_rec.cag_information10;

Line 530: per_cag_shd.g_old_rec.cag_information10;

526: per_cag_shd.g_old_rec.cag_information9;
527: End If;
528: If (p_rec.cag_information10 = hr_api.g_varchar2) then
529: p_rec.cag_information10 :=
530: per_cag_shd.g_old_rec.cag_information10;
531: End If;
532: If (p_rec.cag_information11 = hr_api.g_varchar2) then
533: p_rec.cag_information11 :=
534: per_cag_shd.g_old_rec.cag_information11;

Line 534: per_cag_shd.g_old_rec.cag_information11;

530: per_cag_shd.g_old_rec.cag_information10;
531: End If;
532: If (p_rec.cag_information11 = hr_api.g_varchar2) then
533: p_rec.cag_information11 :=
534: per_cag_shd.g_old_rec.cag_information11;
535: End If;
536: If (p_rec.cag_information12 = hr_api.g_varchar2) then
537: p_rec.cag_information12 :=
538: per_cag_shd.g_old_rec.cag_information12;

Line 538: per_cag_shd.g_old_rec.cag_information12;

534: per_cag_shd.g_old_rec.cag_information11;
535: End If;
536: If (p_rec.cag_information12 = hr_api.g_varchar2) then
537: p_rec.cag_information12 :=
538: per_cag_shd.g_old_rec.cag_information12;
539: End If;
540: If (p_rec.cag_information13 = hr_api.g_varchar2) then
541: p_rec.cag_information13 :=
542: per_cag_shd.g_old_rec.cag_information13;

Line 542: per_cag_shd.g_old_rec.cag_information13;

538: per_cag_shd.g_old_rec.cag_information12;
539: End If;
540: If (p_rec.cag_information13 = hr_api.g_varchar2) then
541: p_rec.cag_information13 :=
542: per_cag_shd.g_old_rec.cag_information13;
543: End If;
544: If (p_rec.cag_information14 = hr_api.g_varchar2) then
545: p_rec.cag_information14 :=
546: per_cag_shd.g_old_rec.cag_information14;

Line 546: per_cag_shd.g_old_rec.cag_information14;

542: per_cag_shd.g_old_rec.cag_information13;
543: End If;
544: If (p_rec.cag_information14 = hr_api.g_varchar2) then
545: p_rec.cag_information14 :=
546: per_cag_shd.g_old_rec.cag_information14;
547: End If;
548: If (p_rec.cag_information15 = hr_api.g_varchar2) then
549: p_rec.cag_information15 :=
550: per_cag_shd.g_old_rec.cag_information15;

Line 550: per_cag_shd.g_old_rec.cag_information15;

546: per_cag_shd.g_old_rec.cag_information14;
547: End If;
548: If (p_rec.cag_information15 = hr_api.g_varchar2) then
549: p_rec.cag_information15 :=
550: per_cag_shd.g_old_rec.cag_information15;
551: End If;
552: If (p_rec.cag_information16 = hr_api.g_varchar2) then
553: p_rec.cag_information16 :=
554: per_cag_shd.g_old_rec.cag_information16;

Line 554: per_cag_shd.g_old_rec.cag_information16;

550: per_cag_shd.g_old_rec.cag_information15;
551: End If;
552: If (p_rec.cag_information16 = hr_api.g_varchar2) then
553: p_rec.cag_information16 :=
554: per_cag_shd.g_old_rec.cag_information16;
555: End If;
556: If (p_rec.cag_information17 = hr_api.g_varchar2) then
557: p_rec.cag_information17 :=
558: per_cag_shd.g_old_rec.cag_information17;

Line 558: per_cag_shd.g_old_rec.cag_information17;

554: per_cag_shd.g_old_rec.cag_information16;
555: End If;
556: If (p_rec.cag_information17 = hr_api.g_varchar2) then
557: p_rec.cag_information17 :=
558: per_cag_shd.g_old_rec.cag_information17;
559: End If;
560: If (p_rec.cag_information18 = hr_api.g_varchar2) then
561: p_rec.cag_information18 :=
562: per_cag_shd.g_old_rec.cag_information18;

Line 562: per_cag_shd.g_old_rec.cag_information18;

558: per_cag_shd.g_old_rec.cag_information17;
559: End If;
560: If (p_rec.cag_information18 = hr_api.g_varchar2) then
561: p_rec.cag_information18 :=
562: per_cag_shd.g_old_rec.cag_information18;
563: End If;
564: If (p_rec.cag_information19 = hr_api.g_varchar2) then
565: p_rec.cag_information19 :=
566: per_cag_shd.g_old_rec.cag_information19;

Line 566: per_cag_shd.g_old_rec.cag_information19;

562: per_cag_shd.g_old_rec.cag_information18;
563: End If;
564: If (p_rec.cag_information19 = hr_api.g_varchar2) then
565: p_rec.cag_information19 :=
566: per_cag_shd.g_old_rec.cag_information19;
567: End If;
568: If (p_rec.cag_information20 = hr_api.g_varchar2) then
569: p_rec.cag_information20 :=
570: per_cag_shd.g_old_rec.cag_information20;

Line 570: per_cag_shd.g_old_rec.cag_information20;

566: per_cag_shd.g_old_rec.cag_information19;
567: End If;
568: If (p_rec.cag_information20 = hr_api.g_varchar2) then
569: p_rec.cag_information20 :=
570: per_cag_shd.g_old_rec.cag_information20;
571: End If;
572: If (p_rec.attribute_category = hr_api.g_varchar2) then
573: p_rec.attribute_category :=
574: per_cag_shd.g_old_rec.attribute_category;

Line 574: per_cag_shd.g_old_rec.attribute_category;

570: per_cag_shd.g_old_rec.cag_information20;
571: End If;
572: If (p_rec.attribute_category = hr_api.g_varchar2) then
573: p_rec.attribute_category :=
574: per_cag_shd.g_old_rec.attribute_category;
575: End If;
576: If (p_rec.attribute1 = hr_api.g_varchar2) then
577: p_rec.attribute1 :=
578: per_cag_shd.g_old_rec.attribute1;

Line 578: per_cag_shd.g_old_rec.attribute1;

574: per_cag_shd.g_old_rec.attribute_category;
575: End If;
576: If (p_rec.attribute1 = hr_api.g_varchar2) then
577: p_rec.attribute1 :=
578: per_cag_shd.g_old_rec.attribute1;
579: End If;
580: If (p_rec.attribute2 = hr_api.g_varchar2) then
581: p_rec.attribute2 :=
582: per_cag_shd.g_old_rec.attribute2;

Line 582: per_cag_shd.g_old_rec.attribute2;

578: per_cag_shd.g_old_rec.attribute1;
579: End If;
580: If (p_rec.attribute2 = hr_api.g_varchar2) then
581: p_rec.attribute2 :=
582: per_cag_shd.g_old_rec.attribute2;
583: End If;
584: If (p_rec.attribute3 = hr_api.g_varchar2) then
585: p_rec.attribute3 :=
586: per_cag_shd.g_old_rec.attribute3;

Line 586: per_cag_shd.g_old_rec.attribute3;

582: per_cag_shd.g_old_rec.attribute2;
583: End If;
584: If (p_rec.attribute3 = hr_api.g_varchar2) then
585: p_rec.attribute3 :=
586: per_cag_shd.g_old_rec.attribute3;
587: End If;
588: If (p_rec.attribute4 = hr_api.g_varchar2) then
589: p_rec.attribute4 :=
590: per_cag_shd.g_old_rec.attribute4;

Line 590: per_cag_shd.g_old_rec.attribute4;

586: per_cag_shd.g_old_rec.attribute3;
587: End If;
588: If (p_rec.attribute4 = hr_api.g_varchar2) then
589: p_rec.attribute4 :=
590: per_cag_shd.g_old_rec.attribute4;
591: End If;
592: If (p_rec.attribute5 = hr_api.g_varchar2) then
593: p_rec.attribute5 :=
594: per_cag_shd.g_old_rec.attribute5;

Line 594: per_cag_shd.g_old_rec.attribute5;

590: per_cag_shd.g_old_rec.attribute4;
591: End If;
592: If (p_rec.attribute5 = hr_api.g_varchar2) then
593: p_rec.attribute5 :=
594: per_cag_shd.g_old_rec.attribute5;
595: End If;
596: If (p_rec.attribute6 = hr_api.g_varchar2) then
597: p_rec.attribute6 :=
598: per_cag_shd.g_old_rec.attribute6;

Line 598: per_cag_shd.g_old_rec.attribute6;

594: per_cag_shd.g_old_rec.attribute5;
595: End If;
596: If (p_rec.attribute6 = hr_api.g_varchar2) then
597: p_rec.attribute6 :=
598: per_cag_shd.g_old_rec.attribute6;
599: End If;
600: If (p_rec.attribute7 = hr_api.g_varchar2) then
601: p_rec.attribute7 :=
602: per_cag_shd.g_old_rec.attribute7;

Line 602: per_cag_shd.g_old_rec.attribute7;

598: per_cag_shd.g_old_rec.attribute6;
599: End If;
600: If (p_rec.attribute7 = hr_api.g_varchar2) then
601: p_rec.attribute7 :=
602: per_cag_shd.g_old_rec.attribute7;
603: End If;
604: If (p_rec.attribute8 = hr_api.g_varchar2) then
605: p_rec.attribute8 :=
606: per_cag_shd.g_old_rec.attribute8;

Line 606: per_cag_shd.g_old_rec.attribute8;

602: per_cag_shd.g_old_rec.attribute7;
603: End If;
604: If (p_rec.attribute8 = hr_api.g_varchar2) then
605: p_rec.attribute8 :=
606: per_cag_shd.g_old_rec.attribute8;
607: End If;
608: If (p_rec.attribute9 = hr_api.g_varchar2) then
609: p_rec.attribute9 :=
610: per_cag_shd.g_old_rec.attribute9;

Line 610: per_cag_shd.g_old_rec.attribute9;

606: per_cag_shd.g_old_rec.attribute8;
607: End If;
608: If (p_rec.attribute9 = hr_api.g_varchar2) then
609: p_rec.attribute9 :=
610: per_cag_shd.g_old_rec.attribute9;
611: End If;
612: If (p_rec.attribute10 = hr_api.g_varchar2) then
613: p_rec.attribute10 :=
614: per_cag_shd.g_old_rec.attribute10;

Line 614: per_cag_shd.g_old_rec.attribute10;

610: per_cag_shd.g_old_rec.attribute9;
611: End If;
612: If (p_rec.attribute10 = hr_api.g_varchar2) then
613: p_rec.attribute10 :=
614: per_cag_shd.g_old_rec.attribute10;
615: End If;
616: If (p_rec.attribute11 = hr_api.g_varchar2) then
617: p_rec.attribute11 :=
618: per_cag_shd.g_old_rec.attribute11;

Line 618: per_cag_shd.g_old_rec.attribute11;

614: per_cag_shd.g_old_rec.attribute10;
615: End If;
616: If (p_rec.attribute11 = hr_api.g_varchar2) then
617: p_rec.attribute11 :=
618: per_cag_shd.g_old_rec.attribute11;
619: End If;
620: If (p_rec.attribute12 = hr_api.g_varchar2) then
621: p_rec.attribute12 :=
622: per_cag_shd.g_old_rec.attribute12;

Line 622: per_cag_shd.g_old_rec.attribute12;

618: per_cag_shd.g_old_rec.attribute11;
619: End If;
620: If (p_rec.attribute12 = hr_api.g_varchar2) then
621: p_rec.attribute12 :=
622: per_cag_shd.g_old_rec.attribute12;
623: End If;
624: If (p_rec.attribute13 = hr_api.g_varchar2) then
625: p_rec.attribute13 :=
626: per_cag_shd.g_old_rec.attribute13;

Line 626: per_cag_shd.g_old_rec.attribute13;

622: per_cag_shd.g_old_rec.attribute12;
623: End If;
624: If (p_rec.attribute13 = hr_api.g_varchar2) then
625: p_rec.attribute13 :=
626: per_cag_shd.g_old_rec.attribute13;
627: End If;
628: If (p_rec.attribute14 = hr_api.g_varchar2) then
629: p_rec.attribute14 :=
630: per_cag_shd.g_old_rec.attribute14;

Line 630: per_cag_shd.g_old_rec.attribute14;

626: per_cag_shd.g_old_rec.attribute13;
627: End If;
628: If (p_rec.attribute14 = hr_api.g_varchar2) then
629: p_rec.attribute14 :=
630: per_cag_shd.g_old_rec.attribute14;
631: End If;
632: If (p_rec.attribute15 = hr_api.g_varchar2) then
633: p_rec.attribute15 :=
634: per_cag_shd.g_old_rec.attribute15;

Line 634: per_cag_shd.g_old_rec.attribute15;

630: per_cag_shd.g_old_rec.attribute14;
631: End If;
632: If (p_rec.attribute15 = hr_api.g_varchar2) then
633: p_rec.attribute15 :=
634: per_cag_shd.g_old_rec.attribute15;
635: End If;
636: If (p_rec.attribute16 = hr_api.g_varchar2) then
637: p_rec.attribute16 :=
638: per_cag_shd.g_old_rec.attribute16;

Line 638: per_cag_shd.g_old_rec.attribute16;

634: per_cag_shd.g_old_rec.attribute15;
635: End If;
636: If (p_rec.attribute16 = hr_api.g_varchar2) then
637: p_rec.attribute16 :=
638: per_cag_shd.g_old_rec.attribute16;
639: End If;
640: If (p_rec.attribute17 = hr_api.g_varchar2) then
641: p_rec.attribute17 :=
642: per_cag_shd.g_old_rec.attribute17;

Line 642: per_cag_shd.g_old_rec.attribute17;

638: per_cag_shd.g_old_rec.attribute16;
639: End If;
640: If (p_rec.attribute17 = hr_api.g_varchar2) then
641: p_rec.attribute17 :=
642: per_cag_shd.g_old_rec.attribute17;
643: End If;
644: If (p_rec.attribute18 = hr_api.g_varchar2) then
645: p_rec.attribute18 :=
646: per_cag_shd.g_old_rec.attribute18;

Line 646: per_cag_shd.g_old_rec.attribute18;

642: per_cag_shd.g_old_rec.attribute17;
643: End If;
644: If (p_rec.attribute18 = hr_api.g_varchar2) then
645: p_rec.attribute18 :=
646: per_cag_shd.g_old_rec.attribute18;
647: End If;
648: If (p_rec.attribute19 = hr_api.g_varchar2) then
649: p_rec.attribute19 :=
650: per_cag_shd.g_old_rec.attribute19;

Line 650: per_cag_shd.g_old_rec.attribute19;

646: per_cag_shd.g_old_rec.attribute18;
647: End If;
648: If (p_rec.attribute19 = hr_api.g_varchar2) then
649: p_rec.attribute19 :=
650: per_cag_shd.g_old_rec.attribute19;
651: End If;
652: If (p_rec.attribute20 = hr_api.g_varchar2) then
653: p_rec.attribute20 :=
654: per_cag_shd.g_old_rec.attribute20;

Line 654: per_cag_shd.g_old_rec.attribute20;

650: per_cag_shd.g_old_rec.attribute19;
651: End If;
652: If (p_rec.attribute20 = hr_api.g_varchar2) then
653: p_rec.attribute20 :=
654: per_cag_shd.g_old_rec.attribute20;
655: End If;
656: --
657: hr_utility.set_location(' Leaving:'||l_proc, 10);
658: --

Line 666: p_rec in out nocopy per_cag_shd.g_rec_type

662: -- |---------------------------------< upd >----------------------------------|
663: -- ----------------------------------------------------------------------------
664: Procedure upd
665: (
666: p_rec in out nocopy per_cag_shd.g_rec_type
667: ) is
668: --
669: l_proc varchar2(72) := g_package||'upd';
670: --

Line 676: per_cag_shd.lck

672: hr_utility.set_location('Entering:'||l_proc, 5);
673: --
674: -- We must lock the row which we need to update.
675: --
676: per_cag_shd.lck
677: (
678: p_rec.collective_agreement_id,
679: p_rec.object_version_number
680: );

Line 769: l_rec per_cag_shd.g_rec_type;

765: p_attribute19 in varchar2 default hr_api.g_varchar2,
766: p_attribute20 in varchar2 default hr_api.g_varchar2
767: ) is
768: --
769: l_rec per_cag_shd.g_rec_type;
770: l_proc varchar2(72) := g_package||'upd';
771: --
772: Begin
773: hr_utility.set_location('Entering:'||l_proc, 5);

Line 779: per_cag_shd.convert_args

775: -- Call conversion function to turn arguments into the
776: -- l_rec structure.
777: --
778: l_rec :=
779: per_cag_shd.convert_args
780: (
781: p_collective_agreement_id,
782: p_business_group_id,
783: p_object_version_number,