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_QUA_BUS dependencies on PER_QUALIFICATIONS

Line 23: p_qualification_id in per_qualifications.qualification_id%TYPE

19: --
20: --
21: procedure set_security_group_id
22: (
23: p_qualification_id in per_qualifications.qualification_id%TYPE
24: ,p_associated_column1 in varchar2 default null
25: ) is
26: --
27: -- Declare cursor

Line 32: , per_qualifications qua

28: --
29: cursor csr_sec_grp is
30: select inf.org_information14
31: from hr_organization_information inf
32: , per_qualifications qua
33: where qua.qualification_id = p_qualification_id
34: and inf.organization_id = qua.business_group_id
35: and inf.org_information_context || '' = 'Business Group Information';
36: --

Line 91: , per_qualifications qua

87: --
88: cursor csr_leg_code is
89: select pbg.legislation_code
90: from per_business_groups_perf pbg
91: , per_qualifications qua
92: where qua.qualification_id = p_qualification_id
93: and pbg.business_group_id (+) = qua.business_group_id;
94: --
95: -- Declare local variables

Line 194: per_qua_shd.constraint_error('PER_QUALIFICATIONS_PK');

190: <> nvl(per_qua_shd.g_old_rec.qualification_id,hr_api.g_number)) then
191: --
192: -- raise error as PK has changed
193: --
194: per_qua_shd.constraint_error('PER_QUALIFICATIONS_PK');
195: --
196: elsif not l_api_updating then
197: --
198: -- check if PK is null

Line 204: per_qua_shd.constraint_error('PER_QUALIFICATIONS_PK');

200: if p_qualification_id is not null then
201: --
202: -- raise error as PK is not null
203: --
204: per_qua_shd.constraint_error('PER_QUALIFICATIONS_PK');
205: --
206: end if;
207: --
208: end if;

Line 278: per_qua_shd.constraint_error('PER_QUALIFICATIONS_FK2');

274: --
275: -- raise error as FK does not relate to PK in per_qualification_types
276: -- table.
277: --
278: per_qua_shd.constraint_error('PER_QUALIFICATIONS_FK2');
279: --
280: end if;
281: --
282: close c1;

Line 371: (p_associated_column1 => 'PER_QUALIFICATIONS.PERSON_ID'

367: --and p_attendance_id is not null)) then
368: --
369: hr_utility.set_message(801,'HR_51833_QUA_PER_ATT_ID');
370: hr_multi_message.add
371: (p_associated_column1 => 'PER_QUALIFICATIONS.PERSON_ID'
372: ,p_associated_column2 => 'PER_QUALIFICATIONS.PARTY_ID'
373: ,p_associated_column3 => 'PER_QUALIFICATIONS.ATTENDANCE_ID'
374: );
375: --

Line 372: ,p_associated_column2 => 'PER_QUALIFICATIONS.PARTY_ID'

368: --
369: hr_utility.set_message(801,'HR_51833_QUA_PER_ATT_ID');
370: hr_multi_message.add
371: (p_associated_column1 => 'PER_QUALIFICATIONS.PERSON_ID'
372: ,p_associated_column2 => 'PER_QUALIFICATIONS.PARTY_ID'
373: ,p_associated_column3 => 'PER_QUALIFICATIONS.ATTENDANCE_ID'
374: );
375: --
376: end if;

Line 373: ,p_associated_column3 => 'PER_QUALIFICATIONS.ATTENDANCE_ID'

369: hr_utility.set_message(801,'HR_51833_QUA_PER_ATT_ID');
370: hr_multi_message.add
371: (p_associated_column1 => 'PER_QUALIFICATIONS.PERSON_ID'
372: ,p_associated_column2 => 'PER_QUALIFICATIONS.PARTY_ID'
373: ,p_associated_column3 => 'PER_QUALIFICATIONS.ATTENDANCE_ID'
374: );
375: --
376: end if;
377: --

Line 392: (p_associated_column1 => 'PER_QUALIFICATIONS.PERSON_ID'

388: --
389: close c1;
390: hr_utility.set_message(801,'HR_51834_QUA_PER_ID_INV');
391: hr_multi_message.add
392: (p_associated_column1 => 'PER_QUALIFICATIONS.PERSON_ID'
393: );
394: --
395: else
396: --

Line 411: per_qua_shd.constraint_error('PER_QUALIFICATIONS_FK1');

407: fetch c2 into l_dummy;
408: if c2%notfound then
409: --
410: close c2;
411: per_qua_shd.constraint_error('PER_QUALIFICATIONS_FK1');
412: --
413: end if;
414: --
415: close c2;

Line 473: l_party_id per_qualifications.party_id%TYPE;

469: ,p_effective_date in date
470: )is
471: --
472: l_proc varchar2(72) := g_package||'chk_party_id';
473: l_party_id per_qualifications.party_id%TYPE;
474: l_party_id2 per_qualifications.party_id%TYPE;
475: l_person_id per_establishment_attendances.person_id%TYPE;
476: --
477: --

Line 474: l_party_id2 per_qualifications.party_id%TYPE;

470: )is
471: --
472: l_proc varchar2(72) := g_package||'chk_party_id';
473: l_party_id per_qualifications.party_id%TYPE;
474: l_party_id2 per_qualifications.party_id%TYPE;
475: l_person_id per_establishment_attendances.person_id%TYPE;
476: --
477: --
478: -- cursor to check that the party_id maches person_id

Line 505: (p_check_column1 => 'PER_QUALIFICATIONS.PERSON_ID'

501: --
502: --
503: if p_rec.person_id is not null then
504: if hr_multi_message.no_all_inclusive_error
505: (p_check_column1 => 'PER_QUALIFICATIONS.PERSON_ID'
506: ,p_check_column2 => 'PER_QUALIFICATIONS.PARTY_ID'
507: ) then
508: open csr_get_party_id;
509: fetch csr_get_party_id into l_party_id;

Line 506: ,p_check_column2 => 'PER_QUALIFICATIONS.PARTY_ID'

502: --
503: if p_rec.person_id is not null then
504: if hr_multi_message.no_all_inclusive_error
505: (p_check_column1 => 'PER_QUALIFICATIONS.PERSON_ID'
506: ,p_check_column2 => 'PER_QUALIFICATIONS.PARTY_ID'
507: ) then
508: open csr_get_party_id;
509: fetch csr_get_party_id into l_party_id;
510: close csr_get_party_id;

Line 517: (p_associated_column1 => 'PER_QUALIFICATIONS.PERSON_ID'

513: if p_rec.party_id <> nvl(l_party_id,-1) then
514: hr_utility.set_message(800, 'HR_289343_PERSONPARTY_MISMATCH');
515: hr_utility.set_location(l_proc,30);
516: hr_multi_message.add
517: (p_associated_column1 => 'PER_QUALIFICATIONS.PERSON_ID'
518: ,p_associated_column2 => 'PER_QUALIFICATIONS.PARTY_ID'
519: );
520: end if;
521: else

Line 518: ,p_associated_column2 => 'PER_QUALIFICATIONS.PARTY_ID'

514: hr_utility.set_message(800, 'HR_289343_PERSONPARTY_MISMATCH');
515: hr_utility.set_location(l_proc,30);
516: hr_multi_message.add
517: (p_associated_column1 => 'PER_QUALIFICATIONS.PERSON_ID'
518: ,p_associated_column2 => 'PER_QUALIFICATIONS.PARTY_ID'
519: );
520: end if;
521: else
522: --

Line 532: (p_check_column1 => 'PER_QUALIFICATIONS.ATTENDANCE_ID'

528: end if; --end if for no_all_inclusive_error
529: else
530: if p_rec.attendance_id is not null then
531: if hr_multi_message.no_all_inclusive_error
532: (p_check_column1 => 'PER_QUALIFICATIONS.ATTENDANCE_ID'
533: ,p_check_column2 => 'PER_QUALIFICATIONS.PARTY_ID'
534: ) then
535: open csr_attendances;
536: fetch csr_attendances into l_party_id,l_person_id;

Line 533: ,p_check_column2 => 'PER_QUALIFICATIONS.PARTY_ID'

529: else
530: if p_rec.attendance_id is not null then
531: if hr_multi_message.no_all_inclusive_error
532: (p_check_column1 => 'PER_QUALIFICATIONS.ATTENDANCE_ID'
533: ,p_check_column2 => 'PER_QUALIFICATIONS.PARTY_ID'
534: ) then
535: open csr_attendances;
536: fetch csr_attendances into l_party_id,l_person_id;
537: close csr_attendances;

Line 544: (p_associated_column1 => 'PER_QUALIFICATIONS.ATTENDANCE_ID'

540: if p_rec.party_id <> l_party_id then
541: hr_utility.set_message(800, 'PER_289342_PARTY_ID_INVALID');
542: hr_utility.set_location(l_proc,70);
543: hr_multi_message.add
544: (p_associated_column1 => 'PER_QUALIFICATIONS.ATTENDANCE_ID'
545: ,p_associated_column2 => 'PER_QUALIFICATIONS.PARTY_ID'
546: );
547: end if;
548: else

Line 545: ,p_associated_column2 => 'PER_QUALIFICATIONS.PARTY_ID'

541: hr_utility.set_message(800, 'PER_289342_PARTY_ID_INVALID');
542: hr_utility.set_location(l_proc,70);
543: hr_multi_message.add
544: (p_associated_column1 => 'PER_QUALIFICATIONS.ATTENDANCE_ID'
545: ,p_associated_column2 => 'PER_QUALIFICATIONS.PARTY_ID'
546: );
547: end if;
548: else
549: --

Line 563: (p_associated_column1 => 'PER_QUALIFICATIONS.PERSON_ID'

559: /* chk_person_id ensures that this does not occur*/
560: hr_utility.set_message(800, 'HR_289341_CHK_PERSON_OR_PARTY');
561: hr_utility.set_location(l_proc,90);
562: hr_multi_message.add
563: (p_associated_column1 => 'PER_QUALIFICATIONS.PERSON_ID'
564: ,p_associated_column2 => 'PER_QUALIFICATIONS.PARTY_ID'
565: ,p_associated_column3 => 'PER_QUALIFICATIONS.ATTENDANCE_ID'
566: );
567: else

Line 564: ,p_associated_column2 => 'PER_QUALIFICATIONS.PARTY_ID'

560: hr_utility.set_message(800, 'HR_289341_CHK_PERSON_OR_PARTY');
561: hr_utility.set_location(l_proc,90);
562: hr_multi_message.add
563: (p_associated_column1 => 'PER_QUALIFICATIONS.PERSON_ID'
564: ,p_associated_column2 => 'PER_QUALIFICATIONS.PARTY_ID'
565: ,p_associated_column3 => 'PER_QUALIFICATIONS.ATTENDANCE_ID'
566: );
567: else
568: open csr_valid_party_id;

Line 565: ,p_associated_column3 => 'PER_QUALIFICATIONS.ATTENDANCE_ID'

561: hr_utility.set_location(l_proc,90);
562: hr_multi_message.add
563: (p_associated_column1 => 'PER_QUALIFICATIONS.PERSON_ID'
564: ,p_associated_column2 => 'PER_QUALIFICATIONS.PARTY_ID'
565: ,p_associated_column3 => 'PER_QUALIFICATIONS.ATTENDANCE_ID'
566: );
567: else
568: open csr_valid_party_id;
569: fetch csr_valid_party_id into l_party_id2;

Line 575: (p_associated_column1 => 'PER_QUALIFICATIONS.PARTY_ID'

571: close csr_valid_party_id;
572: hr_utility.set_message(800, 'PER_289342_PARTY_ID_INVALID');
573: hr_utility.set_location(l_proc,100);
574: hr_multi_message.add
575: (p_associated_column1 => 'PER_QUALIFICATIONS.PARTY_ID'
576: );
577: else
578: close csr_valid_party_id;
579: end if;

Line 658: (p_associated_column1 => 'PER_QUALIFICATIONS.STATUS'

654: --
655: exception
656: when app_exception.application_exception then
657: if hr_multi_message.exception_add
658: (p_associated_column1 => 'PER_QUALIFICATIONS.STATUS'
659: ) then
660: --
661: hr_utility.set_location(' Leaving:'||l_proc, 11);
662: --

Line 845: (p_associated_column1 => 'PER_QUALIFICATIONS.START_DATE'

841: --
842: exception
843: when app_exception.application_exception then
844: if hr_multi_message.exception_add
845: (p_associated_column1 => 'PER_QUALIFICATIONS.START_DATE'
846: ,p_associated_column2 => 'PER_QUALIFICATIONS.AWARDED_DATE'
847: ) then
848: --
849: hr_utility.set_location(' Leaving:'||l_proc, 11);

Line 846: ,p_associated_column2 => 'PER_QUALIFICATIONS.AWARDED_DATE'

842: exception
843: when app_exception.application_exception then
844: if hr_multi_message.exception_add
845: (p_associated_column1 => 'PER_QUALIFICATIONS.START_DATE'
846: ,p_associated_column2 => 'PER_QUALIFICATIONS.AWARDED_DATE'
847: ) then
848: --
849: hr_utility.set_location(' Leaving:'||l_proc, 11);
850: --

Line 928: (p_associated_column1 => 'PER_QUALIFICATIONS.FEE'

924: -- having been set.
925: --
926: hr_utility.set_message(801,'HR_51840_QUA_FEE_CURRENCY');
927: hr_multi_message.add
928: (p_associated_column1 => 'PER_QUALIFICATIONS.FEE'
929: ,p_associated_column2 => 'PER_QUALIFICATIONS.FEE_CURRENCY'
930: );
931: --
932: end if;

Line 929: ,p_associated_column2 => 'PER_QUALIFICATIONS.FEE_CURRENCY'

925: --
926: hr_utility.set_message(801,'HR_51840_QUA_FEE_CURRENCY');
927: hr_multi_message.add
928: (p_associated_column1 => 'PER_QUALIFICATIONS.FEE'
929: ,p_associated_column2 => 'PER_QUALIFICATIONS.FEE_CURRENCY'
930: );
931: --
932: end if;
933: --

Line 950: (p_associated_column1 => 'PER_QUALIFICATIONS.FEE_CURRENCY'

946: close c1;
947: hr_utility.set_message(801,'HR_51855_QUA_CCY_INV');
948: --
949: hr_multi_message.add
950: (p_associated_column1 => 'PER_QUALIFICATIONS.FEE_CURRENCY'
951: );
952: else
953: --
954: close c1;

Line 1111: (p_check_column1 => 'PER_QUALIFICATIONS.ATTENDANCE_ID'

1107: if ((p_start_date is not null
1108: or p_end_date is not null)
1109: and p_attendance_id is not null) then
1110: if hr_multi_message.no_all_inclusive_error
1111: (p_check_column1 => 'PER_QUALIFICATIONS.ATTENDANCE_ID'
1112: ) then
1113: --
1114: -- Only carry out test on establishment attendance dates if attendance_id
1115: -- is not null.

Line 1128: (p_associated_column1 => 'PER_QUALIFICATIONS.ATTENDANCE_ID'

1124: --
1125: close c1;
1126: hr_utility.set_message(801,'HR_51841_QUA_DATES_OUT_ESA');
1127: hr_multi_message.add
1128: (p_associated_column1 => 'PER_QUALIFICATIONS.ATTENDANCE_ID'
1129: ,p_associated_column2 => 'PER_QUALIFICATIONS.START_DATE'
1130: ,p_associated_column3 => 'PER_QUALIFICATIONS.END_DATE'
1131: );
1132: --

Line 1129: ,p_associated_column2 => 'PER_QUALIFICATIONS.START_DATE'

1125: close c1;
1126: hr_utility.set_message(801,'HR_51841_QUA_DATES_OUT_ESA');
1127: hr_multi_message.add
1128: (p_associated_column1 => 'PER_QUALIFICATIONS.ATTENDANCE_ID'
1129: ,p_associated_column2 => 'PER_QUALIFICATIONS.START_DATE'
1130: ,p_associated_column3 => 'PER_QUALIFICATIONS.END_DATE'
1131: );
1132: --
1133: else

Line 1130: ,p_associated_column3 => 'PER_QUALIFICATIONS.END_DATE'

1126: hr_utility.set_message(801,'HR_51841_QUA_DATES_OUT_ESA');
1127: hr_multi_message.add
1128: (p_associated_column1 => 'PER_QUALIFICATIONS.ATTENDANCE_ID'
1129: ,p_associated_column2 => 'PER_QUALIFICATIONS.START_DATE'
1130: ,p_associated_column3 => 'PER_QUALIFICATIONS.END_DATE'
1131: );
1132: --
1133: else
1134: --

Line 1165: (p_associated_column1 => 'PER_QUALIFICATIONS.QUALIFICATION_ID'

1161: --
1162: close c2;
1163: hr_utility.set_message(801,'HR_51842_QUA_SUB_DATES');
1164: hr_multi_message.add
1165: (p_associated_column1 => 'PER_QUALIFICATIONS.QUALIFICATION_ID'
1166: ,p_associated_column2 => 'PER_QUALIFICATIONS.START_DATE'
1167: ,p_associated_column3 => 'PER_QUALIFICATIONS.END_DATE'
1168: );
1169: --

Line 1166: ,p_associated_column2 => 'PER_QUALIFICATIONS.START_DATE'

1162: close c2;
1163: hr_utility.set_message(801,'HR_51842_QUA_SUB_DATES');
1164: hr_multi_message.add
1165: (p_associated_column1 => 'PER_QUALIFICATIONS.QUALIFICATION_ID'
1166: ,p_associated_column2 => 'PER_QUALIFICATIONS.START_DATE'
1167: ,p_associated_column3 => 'PER_QUALIFICATIONS.END_DATE'
1168: );
1169: --
1170: else

Line 1167: ,p_associated_column3 => 'PER_QUALIFICATIONS.END_DATE'

1163: hr_utility.set_message(801,'HR_51842_QUA_SUB_DATES');
1164: hr_multi_message.add
1165: (p_associated_column1 => 'PER_QUALIFICATIONS.QUALIFICATION_ID'
1166: ,p_associated_column2 => 'PER_QUALIFICATIONS.START_DATE'
1167: ,p_associated_column3 => 'PER_QUALIFICATIONS.END_DATE'
1168: );
1169: --
1170: else
1171: --

Line 1250: (p_associated_column1 => 'PER_QUALIFICATIONS.QUALIFICATION_ID'

1246: close c1;
1247:
1248: hr_utility.set_message(801,'HR_51842_QUA_SUB_DATES');
1249: hr_multi_message.add
1250: (p_associated_column1 => 'PER_QUALIFICATIONS.QUALIFICATION_ID'
1251: ,p_associated_column2 => 'PER_QUALIFICATIONS.START_DATE'
1252: ,p_associated_column3 => 'PER_QUALIFICATIONS.END_DATE'
1253: );
1254: --

Line 1251: ,p_associated_column2 => 'PER_QUALIFICATIONS.START_DATE'

1247:
1248: hr_utility.set_message(801,'HR_51842_QUA_SUB_DATES');
1249: hr_multi_message.add
1250: (p_associated_column1 => 'PER_QUALIFICATIONS.QUALIFICATION_ID'
1251: ,p_associated_column2 => 'PER_QUALIFICATIONS.START_DATE'
1252: ,p_associated_column3 => 'PER_QUALIFICATIONS.END_DATE'
1253: );
1254: --
1255: else

Line 1252: ,p_associated_column3 => 'PER_QUALIFICATIONS.END_DATE'

1248: hr_utility.set_message(801,'HR_51842_QUA_SUB_DATES');
1249: hr_multi_message.add
1250: (p_associated_column1 => 'PER_QUALIFICATIONS.QUALIFICATION_ID'
1251: ,p_associated_column2 => 'PER_QUALIFICATIONS.START_DATE'
1252: ,p_associated_column3 => 'PER_QUALIFICATIONS.END_DATE'
1253: );
1254: --
1255: else
1256: --

Line 1305: (p_check_column1 => 'PER_QUALIFICATIONS.START_DATE'

1301: --
1302: hr_utility.set_location('Entering:'||l_proc,5);
1303: --
1304: if hr_multi_message.no_all_inclusive_error
1305: (p_check_column1 => 'PER_QUALIFICATIONS.START_DATE'
1306: ) then
1307: l_api_updating := per_qua_shd.api_updating
1308: (p_qualification_id => p_qualification_id,
1309: p_object_version_number => p_object_version_number);

Line 1342: (p_associated_column1 => 'PER_QUALIFICATIONS.START_DATE'

1338: --
1339: exception
1340: when app_exception.application_exception then
1341: if hr_multi_message.exception_add
1342: (p_associated_column1 => 'PER_QUALIFICATIONS.START_DATE'
1343: ,p_associated_column2 => 'PER_QUALIFICATIONS.PROJECTED_COMPLETION_DATE'
1344: ) then
1345: --
1346: hr_utility.set_location(' Leaving:'||l_proc, 11);

Line 1343: ,p_associated_column2 => 'PER_QUALIFICATIONS.PROJECTED_COMPLETION_DATE'

1339: exception
1340: when app_exception.application_exception then
1341: if hr_multi_message.exception_add
1342: (p_associated_column1 => 'PER_QUALIFICATIONS.START_DATE'
1343: ,p_associated_column2 => 'PER_QUALIFICATIONS.PROJECTED_COMPLETION_DATE'
1344: ) then
1345: --
1346: hr_utility.set_location(' Leaving:'||l_proc, 11);
1347: --

Line 1425: (p_associated_column1 => 'PER_QUALIFICATIONS.TUITION_METHOD'

1421: --
1422: exception
1423: when app_exception.application_exception then
1424: if hr_multi_message.exception_add
1425: (p_associated_column1 => 'PER_QUALIFICATIONS.TUITION_METHOD'
1426: ) then
1427: --
1428: hr_utility.set_location(' Leaving:'||l_proc, 11);
1429: --

Line 1484: (p_check_column1 => 'PER_QUALIFICATIONS.ATTENDANCE_ID'

1480: --
1481: hr_utility.set_location('Entering:'||l_proc,5);
1482: --
1483: if hr_multi_message.no_all_inclusive_error
1484: (p_check_column1 => 'PER_QUALIFICATIONS.ATTENDANCE_ID'
1485: ) then
1486: --
1487: l_api_updating := per_qua_shd.api_updating
1488: (p_qualification_id => p_qualification_id,

Line 1530: (p_associated_column1 => 'PER_QUALIFICATIONS.ATTENDANCE_ID'

1526: --
1527: exception
1528: when app_exception.application_exception then
1529: if hr_multi_message.exception_add
1530: (p_associated_column1 => 'PER_QUALIFICATIONS.ATTENDANCE_ID'
1531: ) then
1532: --
1533: hr_utility.set_location(' Leaving:'||l_proc, 11);
1534: --

Line 1595: (p_check_column1 => 'PER_QUALIFICATIONS.PERSON_ID'

1591: --
1592: hr_utility.set_location('Entering:'||l_proc,5);
1593: --
1594: if hr_multi_message.no_all_inclusive_error
1595: (p_check_column1 => 'PER_QUALIFICATIONS.PERSON_ID'
1596: ) then
1597: --
1598: l_api_updating := per_qua_shd.api_updating
1599: (p_qualification_id => p_qualification_id,

Line 1652: (p_associated_column1 => 'PER_QUALIFICATIONS.PERSON_ID'

1648: --
1649: exception
1650: when app_exception.application_exception then
1651: if hr_multi_message.exception_add
1652: (p_associated_column1 => 'PER_QUALIFICATIONS.PERSON_ID'
1653: ) then
1654: --
1655: hr_utility.set_location(' Leaving:'||l_proc, 11);
1656: --

Line 1704: (p_check_column1 => 'PER_QUALIFICATIONS.QUALIFICATION_ID'

1700: --
1701: hr_utility.set_location('Entering:'||l_proc,5);
1702: --
1703: if hr_multi_message.no_all_inclusive_error
1704: (p_check_column1 => 'PER_QUALIFICATIONS.QUALIFICATION_ID'
1705: ) then
1706: --
1707: -- check if referenced records exist in the PER_SUBJECTS_TAKEN table.
1708: --

Line 1731: (p_associated_column1 => 'PER_QUALIFICATIONS.QUALIFICATION_ID'

1727: --
1728: exception
1729: when app_exception.application_exception then
1730: if hr_multi_message.exception_add
1731: (p_associated_column1 => 'PER_QUALIFICATIONS.QUALIFICATION_ID'
1732: ) then
1733: --
1734: hr_utility.set_location(' Leaving:'||l_proc, 11);
1735: --

Line 1901: ,p_descflex_name => 'PER_QUALIFICATIONS'

1897: -- b) During insert.
1898: --
1899: hr_dflex_utility.ins_or_upd_descflex_attribs
1900: (p_appl_short_name => 'PER'
1901: ,p_descflex_name => 'PER_QUALIFICATIONS'
1902: ,p_attribute_category => p_rec.attribute_category
1903: ,p_attribute1_name => 'ATTRIBUTE1'
1904: ,p_attribute1_value => p_rec.attribute1
1905: ,p_attribute2_name => 'ATTRIBUTE2'