26: p_employment_category hr_lookups.meaning%type default null,
27: p_phone_id per_phones.phone_id%type default null,
28: p_qualification_id per_qualifications.qualification_id%type default null,
29: p_delivery_method_id per_person_dlvry_methods.delivery_method_id%type default null,
30: p_address_id per_addresses.address_id%type default null);
31:
32: -- Search criteria as table type
33: Type srch_criteria is table of srch_criteria_record INDEX BY BINARY_INTEGER;
34:
436: TYPE CONTACT_ADDRESS_DETAILS is RECORD
437: (
438: CONTACT_RELATIONSHIP_ID PER_CONTACT_RELATIONSHIPS.CONTACT_RELATIONSHIP_ID%TYPE,
439: CONTACT_PERSON_ID PER_CONTACT_RELATIONSHIPS.CONTACT_PERSON_ID%TYPE,
440: ADDRESS_ID PER_ADDRESSES.ADDRESS_ID%TYPE,
441: DATE_FROM varchar2(10),
442: PRIMARY_FLAG PER_ADDRESSES.PRIMARY_FLAG%TYPE,
443: STYLE PER_ADDRESSES.STYLE%TYPE,
444: STYLE_DESC VARCHAR2(100), -- FROM FLEXFIELDS
438: CONTACT_RELATIONSHIP_ID PER_CONTACT_RELATIONSHIPS.CONTACT_RELATIONSHIP_ID%TYPE,
439: CONTACT_PERSON_ID PER_CONTACT_RELATIONSHIPS.CONTACT_PERSON_ID%TYPE,
440: ADDRESS_ID PER_ADDRESSES.ADDRESS_ID%TYPE,
441: DATE_FROM varchar2(10),
442: PRIMARY_FLAG PER_ADDRESSES.PRIMARY_FLAG%TYPE,
443: STYLE PER_ADDRESSES.STYLE%TYPE,
444: STYLE_DESC VARCHAR2(100), -- FROM FLEXFIELDS
445: ADDRESS_LINE1 PER_ADDRESSES.ADDRESS_LINE1%TYPE,
446: ADDRESS_LINE2 PER_ADDRESSES.ADDRESS_LINE2%TYPE,
439: CONTACT_PERSON_ID PER_CONTACT_RELATIONSHIPS.CONTACT_PERSON_ID%TYPE,
440: ADDRESS_ID PER_ADDRESSES.ADDRESS_ID%TYPE,
441: DATE_FROM varchar2(10),
442: PRIMARY_FLAG PER_ADDRESSES.PRIMARY_FLAG%TYPE,
443: STYLE PER_ADDRESSES.STYLE%TYPE,
444: STYLE_DESC VARCHAR2(100), -- FROM FLEXFIELDS
445: ADDRESS_LINE1 PER_ADDRESSES.ADDRESS_LINE1%TYPE,
446: ADDRESS_LINE2 PER_ADDRESSES.ADDRESS_LINE2%TYPE,
447: ADDRESS_LINE3 PER_ADDRESSES.ADDRESS_LINE3%TYPE,
441: DATE_FROM varchar2(10),
442: PRIMARY_FLAG PER_ADDRESSES.PRIMARY_FLAG%TYPE,
443: STYLE PER_ADDRESSES.STYLE%TYPE,
444: STYLE_DESC VARCHAR2(100), -- FROM FLEXFIELDS
445: ADDRESS_LINE1 PER_ADDRESSES.ADDRESS_LINE1%TYPE,
446: ADDRESS_LINE2 PER_ADDRESSES.ADDRESS_LINE2%TYPE,
447: ADDRESS_LINE3 PER_ADDRESSES.ADDRESS_LINE3%TYPE,
448: ADDRESS_TYPE PER_ADDRESSES.ADDRESS_TYPE%TYPE,
449: ADDRESS_TYPE_DESC FND_LOOKUP_VALUES.MEANING%TYPE, --(BASED ON LANG /'ADDRESS_TYPE')
442: PRIMARY_FLAG PER_ADDRESSES.PRIMARY_FLAG%TYPE,
443: STYLE PER_ADDRESSES.STYLE%TYPE,
444: STYLE_DESC VARCHAR2(100), -- FROM FLEXFIELDS
445: ADDRESS_LINE1 PER_ADDRESSES.ADDRESS_LINE1%TYPE,
446: ADDRESS_LINE2 PER_ADDRESSES.ADDRESS_LINE2%TYPE,
447: ADDRESS_LINE3 PER_ADDRESSES.ADDRESS_LINE3%TYPE,
448: ADDRESS_TYPE PER_ADDRESSES.ADDRESS_TYPE%TYPE,
449: ADDRESS_TYPE_DESC FND_LOOKUP_VALUES.MEANING%TYPE, --(BASED ON LANG /'ADDRESS_TYPE')
450: COUNTRY PER_ADDRESSES.COUNTRY%TYPE,
443: STYLE PER_ADDRESSES.STYLE%TYPE,
444: STYLE_DESC VARCHAR2(100), -- FROM FLEXFIELDS
445: ADDRESS_LINE1 PER_ADDRESSES.ADDRESS_LINE1%TYPE,
446: ADDRESS_LINE2 PER_ADDRESSES.ADDRESS_LINE2%TYPE,
447: ADDRESS_LINE3 PER_ADDRESSES.ADDRESS_LINE3%TYPE,
448: ADDRESS_TYPE PER_ADDRESSES.ADDRESS_TYPE%TYPE,
449: ADDRESS_TYPE_DESC FND_LOOKUP_VALUES.MEANING%TYPE, --(BASED ON LANG /'ADDRESS_TYPE')
450: COUNTRY PER_ADDRESSES.COUNTRY%TYPE,
451: COUNTRY_DESC FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE,
444: STYLE_DESC VARCHAR2(100), -- FROM FLEXFIELDS
445: ADDRESS_LINE1 PER_ADDRESSES.ADDRESS_LINE1%TYPE,
446: ADDRESS_LINE2 PER_ADDRESSES.ADDRESS_LINE2%TYPE,
447: ADDRESS_LINE3 PER_ADDRESSES.ADDRESS_LINE3%TYPE,
448: ADDRESS_TYPE PER_ADDRESSES.ADDRESS_TYPE%TYPE,
449: ADDRESS_TYPE_DESC FND_LOOKUP_VALUES.MEANING%TYPE, --(BASED ON LANG /'ADDRESS_TYPE')
450: COUNTRY PER_ADDRESSES.COUNTRY%TYPE,
451: COUNTRY_DESC FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE,
452: DATE_TO varchar2(10),
446: ADDRESS_LINE2 PER_ADDRESSES.ADDRESS_LINE2%TYPE,
447: ADDRESS_LINE3 PER_ADDRESSES.ADDRESS_LINE3%TYPE,
448: ADDRESS_TYPE PER_ADDRESSES.ADDRESS_TYPE%TYPE,
449: ADDRESS_TYPE_DESC FND_LOOKUP_VALUES.MEANING%TYPE, --(BASED ON LANG /'ADDRESS_TYPE')
450: COUNTRY PER_ADDRESSES.COUNTRY%TYPE,
451: COUNTRY_DESC FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE,
452: DATE_TO varchar2(10),
453: POSTAL_CODE PER_ADDRESSES.POSTAL_CODE%TYPE,
454: REGION_1 PER_ADDRESSES.REGION_1%TYPE,
449: ADDRESS_TYPE_DESC FND_LOOKUP_VALUES.MEANING%TYPE, --(BASED ON LANG /'ADDRESS_TYPE')
450: COUNTRY PER_ADDRESSES.COUNTRY%TYPE,
451: COUNTRY_DESC FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE,
452: DATE_TO varchar2(10),
453: POSTAL_CODE PER_ADDRESSES.POSTAL_CODE%TYPE,
454: REGION_1 PER_ADDRESSES.REGION_1%TYPE,
455: REGION_1_DESC VARCHAR2(240),
456: REGION_2 PER_ADDRESSES.REGION_2%TYPE,
457: REGION_2_DESC VARCHAR2(240),
450: COUNTRY PER_ADDRESSES.COUNTRY%TYPE,
451: COUNTRY_DESC FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE,
452: DATE_TO varchar2(10),
453: POSTAL_CODE PER_ADDRESSES.POSTAL_CODE%TYPE,
454: REGION_1 PER_ADDRESSES.REGION_1%TYPE,
455: REGION_1_DESC VARCHAR2(240),
456: REGION_2 PER_ADDRESSES.REGION_2%TYPE,
457: REGION_2_DESC VARCHAR2(240),
458: REGION_3 PER_ADDRESSES.REGION_3%TYPE,
452: DATE_TO varchar2(10),
453: POSTAL_CODE PER_ADDRESSES.POSTAL_CODE%TYPE,
454: REGION_1 PER_ADDRESSES.REGION_1%TYPE,
455: REGION_1_DESC VARCHAR2(240),
456: REGION_2 PER_ADDRESSES.REGION_2%TYPE,
457: REGION_2_DESC VARCHAR2(240),
458: REGION_3 PER_ADDRESSES.REGION_3%TYPE,
459: REGION_3_DESC VARCHAR2(240),
460: TELEPHONE_NUMBER_1 PER_ADDRESSES.TELEPHONE_NUMBER_1%TYPE,
454: REGION_1 PER_ADDRESSES.REGION_1%TYPE,
455: REGION_1_DESC VARCHAR2(240),
456: REGION_2 PER_ADDRESSES.REGION_2%TYPE,
457: REGION_2_DESC VARCHAR2(240),
458: REGION_3 PER_ADDRESSES.REGION_3%TYPE,
459: REGION_3_DESC VARCHAR2(240),
460: TELEPHONE_NUMBER_1 PER_ADDRESSES.TELEPHONE_NUMBER_1%TYPE,
461: TELEPHONE_NUMBER_2 PER_ADDRESSES.TELEPHONE_NUMBER_2%TYPE,
462: TELEPHONE_NUMBER_3 PER_ADDRESSES.TELEPHONE_NUMBER_3%TYPE,
456: REGION_2 PER_ADDRESSES.REGION_2%TYPE,
457: REGION_2_DESC VARCHAR2(240),
458: REGION_3 PER_ADDRESSES.REGION_3%TYPE,
459: REGION_3_DESC VARCHAR2(240),
460: TELEPHONE_NUMBER_1 PER_ADDRESSES.TELEPHONE_NUMBER_1%TYPE,
461: TELEPHONE_NUMBER_2 PER_ADDRESSES.TELEPHONE_NUMBER_2%TYPE,
462: TELEPHONE_NUMBER_3 PER_ADDRESSES.TELEPHONE_NUMBER_3%TYPE,
463: TOWN_OR_CITY PER_ADDRESSES.TOWN_OR_CITY%TYPE,
464: TOWN_OR_CITY_DESC VARCHAR2(240),
457: REGION_2_DESC VARCHAR2(240),
458: REGION_3 PER_ADDRESSES.REGION_3%TYPE,
459: REGION_3_DESC VARCHAR2(240),
460: TELEPHONE_NUMBER_1 PER_ADDRESSES.TELEPHONE_NUMBER_1%TYPE,
461: TELEPHONE_NUMBER_2 PER_ADDRESSES.TELEPHONE_NUMBER_2%TYPE,
462: TELEPHONE_NUMBER_3 PER_ADDRESSES.TELEPHONE_NUMBER_3%TYPE,
463: TOWN_OR_CITY PER_ADDRESSES.TOWN_OR_CITY%TYPE,
464: TOWN_OR_CITY_DESC VARCHAR2(240),
465: ADDR_ATTRIBUTE_CATEGORY PER_ADDRESSES.ADDR_ATTRIBUTE_CATEGORY%TYPE,
458: REGION_3 PER_ADDRESSES.REGION_3%TYPE,
459: REGION_3_DESC VARCHAR2(240),
460: TELEPHONE_NUMBER_1 PER_ADDRESSES.TELEPHONE_NUMBER_1%TYPE,
461: TELEPHONE_NUMBER_2 PER_ADDRESSES.TELEPHONE_NUMBER_2%TYPE,
462: TELEPHONE_NUMBER_3 PER_ADDRESSES.TELEPHONE_NUMBER_3%TYPE,
463: TOWN_OR_CITY PER_ADDRESSES.TOWN_OR_CITY%TYPE,
464: TOWN_OR_CITY_DESC VARCHAR2(240),
465: ADDR_ATTRIBUTE_CATEGORY PER_ADDRESSES.ADDR_ATTRIBUTE_CATEGORY%TYPE,
466: ADDR_ATTRIBUTE1 PER_ADDRESSES.ADDR_ATTRIBUTE1%TYPE,
459: REGION_3_DESC VARCHAR2(240),
460: TELEPHONE_NUMBER_1 PER_ADDRESSES.TELEPHONE_NUMBER_1%TYPE,
461: TELEPHONE_NUMBER_2 PER_ADDRESSES.TELEPHONE_NUMBER_2%TYPE,
462: TELEPHONE_NUMBER_3 PER_ADDRESSES.TELEPHONE_NUMBER_3%TYPE,
463: TOWN_OR_CITY PER_ADDRESSES.TOWN_OR_CITY%TYPE,
464: TOWN_OR_CITY_DESC VARCHAR2(240),
465: ADDR_ATTRIBUTE_CATEGORY PER_ADDRESSES.ADDR_ATTRIBUTE_CATEGORY%TYPE,
466: ADDR_ATTRIBUTE1 PER_ADDRESSES.ADDR_ATTRIBUTE1%TYPE,
467: ADDR_ATTRIBUTE2 PER_ADDRESSES.ADDR_ATTRIBUTE2%TYPE,
461: TELEPHONE_NUMBER_2 PER_ADDRESSES.TELEPHONE_NUMBER_2%TYPE,
462: TELEPHONE_NUMBER_3 PER_ADDRESSES.TELEPHONE_NUMBER_3%TYPE,
463: TOWN_OR_CITY PER_ADDRESSES.TOWN_OR_CITY%TYPE,
464: TOWN_OR_CITY_DESC VARCHAR2(240),
465: ADDR_ATTRIBUTE_CATEGORY PER_ADDRESSES.ADDR_ATTRIBUTE_CATEGORY%TYPE,
466: ADDR_ATTRIBUTE1 PER_ADDRESSES.ADDR_ATTRIBUTE1%TYPE,
467: ADDR_ATTRIBUTE2 PER_ADDRESSES.ADDR_ATTRIBUTE2%TYPE,
468: ADDR_ATTRIBUTE3 PER_ADDRESSES.ADDR_ATTRIBUTE3%TYPE,
469: ADDR_ATTRIBUTE4 PER_ADDRESSES.ADDR_ATTRIBUTE4%TYPE,
462: TELEPHONE_NUMBER_3 PER_ADDRESSES.TELEPHONE_NUMBER_3%TYPE,
463: TOWN_OR_CITY PER_ADDRESSES.TOWN_OR_CITY%TYPE,
464: TOWN_OR_CITY_DESC VARCHAR2(240),
465: ADDR_ATTRIBUTE_CATEGORY PER_ADDRESSES.ADDR_ATTRIBUTE_CATEGORY%TYPE,
466: ADDR_ATTRIBUTE1 PER_ADDRESSES.ADDR_ATTRIBUTE1%TYPE,
467: ADDR_ATTRIBUTE2 PER_ADDRESSES.ADDR_ATTRIBUTE2%TYPE,
468: ADDR_ATTRIBUTE3 PER_ADDRESSES.ADDR_ATTRIBUTE3%TYPE,
469: ADDR_ATTRIBUTE4 PER_ADDRESSES.ADDR_ATTRIBUTE4%TYPE,
470: ADDR_ATTRIBUTE5 PER_ADDRESSES.ADDR_ATTRIBUTE5%TYPE,
463: TOWN_OR_CITY PER_ADDRESSES.TOWN_OR_CITY%TYPE,
464: TOWN_OR_CITY_DESC VARCHAR2(240),
465: ADDR_ATTRIBUTE_CATEGORY PER_ADDRESSES.ADDR_ATTRIBUTE_CATEGORY%TYPE,
466: ADDR_ATTRIBUTE1 PER_ADDRESSES.ADDR_ATTRIBUTE1%TYPE,
467: ADDR_ATTRIBUTE2 PER_ADDRESSES.ADDR_ATTRIBUTE2%TYPE,
468: ADDR_ATTRIBUTE3 PER_ADDRESSES.ADDR_ATTRIBUTE3%TYPE,
469: ADDR_ATTRIBUTE4 PER_ADDRESSES.ADDR_ATTRIBUTE4%TYPE,
470: ADDR_ATTRIBUTE5 PER_ADDRESSES.ADDR_ATTRIBUTE5%TYPE,
471: ADDR_ATTRIBUTE6 PER_ADDRESSES.ADDR_ATTRIBUTE6%TYPE,
464: TOWN_OR_CITY_DESC VARCHAR2(240),
465: ADDR_ATTRIBUTE_CATEGORY PER_ADDRESSES.ADDR_ATTRIBUTE_CATEGORY%TYPE,
466: ADDR_ATTRIBUTE1 PER_ADDRESSES.ADDR_ATTRIBUTE1%TYPE,
467: ADDR_ATTRIBUTE2 PER_ADDRESSES.ADDR_ATTRIBUTE2%TYPE,
468: ADDR_ATTRIBUTE3 PER_ADDRESSES.ADDR_ATTRIBUTE3%TYPE,
469: ADDR_ATTRIBUTE4 PER_ADDRESSES.ADDR_ATTRIBUTE4%TYPE,
470: ADDR_ATTRIBUTE5 PER_ADDRESSES.ADDR_ATTRIBUTE5%TYPE,
471: ADDR_ATTRIBUTE6 PER_ADDRESSES.ADDR_ATTRIBUTE6%TYPE,
472: ADDR_ATTRIBUTE7 PER_ADDRESSES.ADDR_ATTRIBUTE7%TYPE,
465: ADDR_ATTRIBUTE_CATEGORY PER_ADDRESSES.ADDR_ATTRIBUTE_CATEGORY%TYPE,
466: ADDR_ATTRIBUTE1 PER_ADDRESSES.ADDR_ATTRIBUTE1%TYPE,
467: ADDR_ATTRIBUTE2 PER_ADDRESSES.ADDR_ATTRIBUTE2%TYPE,
468: ADDR_ATTRIBUTE3 PER_ADDRESSES.ADDR_ATTRIBUTE3%TYPE,
469: ADDR_ATTRIBUTE4 PER_ADDRESSES.ADDR_ATTRIBUTE4%TYPE,
470: ADDR_ATTRIBUTE5 PER_ADDRESSES.ADDR_ATTRIBUTE5%TYPE,
471: ADDR_ATTRIBUTE6 PER_ADDRESSES.ADDR_ATTRIBUTE6%TYPE,
472: ADDR_ATTRIBUTE7 PER_ADDRESSES.ADDR_ATTRIBUTE7%TYPE,
473: ADDR_ATTRIBUTE8 PER_ADDRESSES.ADDR_ATTRIBUTE8%TYPE,
466: ADDR_ATTRIBUTE1 PER_ADDRESSES.ADDR_ATTRIBUTE1%TYPE,
467: ADDR_ATTRIBUTE2 PER_ADDRESSES.ADDR_ATTRIBUTE2%TYPE,
468: ADDR_ATTRIBUTE3 PER_ADDRESSES.ADDR_ATTRIBUTE3%TYPE,
469: ADDR_ATTRIBUTE4 PER_ADDRESSES.ADDR_ATTRIBUTE4%TYPE,
470: ADDR_ATTRIBUTE5 PER_ADDRESSES.ADDR_ATTRIBUTE5%TYPE,
471: ADDR_ATTRIBUTE6 PER_ADDRESSES.ADDR_ATTRIBUTE6%TYPE,
472: ADDR_ATTRIBUTE7 PER_ADDRESSES.ADDR_ATTRIBUTE7%TYPE,
473: ADDR_ATTRIBUTE8 PER_ADDRESSES.ADDR_ATTRIBUTE8%TYPE,
474: ADDR_ATTRIBUTE9 PER_ADDRESSES.ADDR_ATTRIBUTE9%TYPE,
467: ADDR_ATTRIBUTE2 PER_ADDRESSES.ADDR_ATTRIBUTE2%TYPE,
468: ADDR_ATTRIBUTE3 PER_ADDRESSES.ADDR_ATTRIBUTE3%TYPE,
469: ADDR_ATTRIBUTE4 PER_ADDRESSES.ADDR_ATTRIBUTE4%TYPE,
470: ADDR_ATTRIBUTE5 PER_ADDRESSES.ADDR_ATTRIBUTE5%TYPE,
471: ADDR_ATTRIBUTE6 PER_ADDRESSES.ADDR_ATTRIBUTE6%TYPE,
472: ADDR_ATTRIBUTE7 PER_ADDRESSES.ADDR_ATTRIBUTE7%TYPE,
473: ADDR_ATTRIBUTE8 PER_ADDRESSES.ADDR_ATTRIBUTE8%TYPE,
474: ADDR_ATTRIBUTE9 PER_ADDRESSES.ADDR_ATTRIBUTE9%TYPE,
475: ADDR_ATTRIBUTE10 PER_ADDRESSES.ADDR_ATTRIBUTE10%TYPE,
468: ADDR_ATTRIBUTE3 PER_ADDRESSES.ADDR_ATTRIBUTE3%TYPE,
469: ADDR_ATTRIBUTE4 PER_ADDRESSES.ADDR_ATTRIBUTE4%TYPE,
470: ADDR_ATTRIBUTE5 PER_ADDRESSES.ADDR_ATTRIBUTE5%TYPE,
471: ADDR_ATTRIBUTE6 PER_ADDRESSES.ADDR_ATTRIBUTE6%TYPE,
472: ADDR_ATTRIBUTE7 PER_ADDRESSES.ADDR_ATTRIBUTE7%TYPE,
473: ADDR_ATTRIBUTE8 PER_ADDRESSES.ADDR_ATTRIBUTE8%TYPE,
474: ADDR_ATTRIBUTE9 PER_ADDRESSES.ADDR_ATTRIBUTE9%TYPE,
475: ADDR_ATTRIBUTE10 PER_ADDRESSES.ADDR_ATTRIBUTE10%TYPE,
476: ADDR_ATTRIBUTE11 PER_ADDRESSES.ADDR_ATTRIBUTE11%TYPE,
469: ADDR_ATTRIBUTE4 PER_ADDRESSES.ADDR_ATTRIBUTE4%TYPE,
470: ADDR_ATTRIBUTE5 PER_ADDRESSES.ADDR_ATTRIBUTE5%TYPE,
471: ADDR_ATTRIBUTE6 PER_ADDRESSES.ADDR_ATTRIBUTE6%TYPE,
472: ADDR_ATTRIBUTE7 PER_ADDRESSES.ADDR_ATTRIBUTE7%TYPE,
473: ADDR_ATTRIBUTE8 PER_ADDRESSES.ADDR_ATTRIBUTE8%TYPE,
474: ADDR_ATTRIBUTE9 PER_ADDRESSES.ADDR_ATTRIBUTE9%TYPE,
475: ADDR_ATTRIBUTE10 PER_ADDRESSES.ADDR_ATTRIBUTE10%TYPE,
476: ADDR_ATTRIBUTE11 PER_ADDRESSES.ADDR_ATTRIBUTE11%TYPE,
477: ADDR_ATTRIBUTE12 PER_ADDRESSES.ADDR_ATTRIBUTE12%TYPE,
470: ADDR_ATTRIBUTE5 PER_ADDRESSES.ADDR_ATTRIBUTE5%TYPE,
471: ADDR_ATTRIBUTE6 PER_ADDRESSES.ADDR_ATTRIBUTE6%TYPE,
472: ADDR_ATTRIBUTE7 PER_ADDRESSES.ADDR_ATTRIBUTE7%TYPE,
473: ADDR_ATTRIBUTE8 PER_ADDRESSES.ADDR_ATTRIBUTE8%TYPE,
474: ADDR_ATTRIBUTE9 PER_ADDRESSES.ADDR_ATTRIBUTE9%TYPE,
475: ADDR_ATTRIBUTE10 PER_ADDRESSES.ADDR_ATTRIBUTE10%TYPE,
476: ADDR_ATTRIBUTE11 PER_ADDRESSES.ADDR_ATTRIBUTE11%TYPE,
477: ADDR_ATTRIBUTE12 PER_ADDRESSES.ADDR_ATTRIBUTE12%TYPE,
478: ADDR_ATTRIBUTE13 PER_ADDRESSES.ADDR_ATTRIBUTE13%TYPE,
471: ADDR_ATTRIBUTE6 PER_ADDRESSES.ADDR_ATTRIBUTE6%TYPE,
472: ADDR_ATTRIBUTE7 PER_ADDRESSES.ADDR_ATTRIBUTE7%TYPE,
473: ADDR_ATTRIBUTE8 PER_ADDRESSES.ADDR_ATTRIBUTE8%TYPE,
474: ADDR_ATTRIBUTE9 PER_ADDRESSES.ADDR_ATTRIBUTE9%TYPE,
475: ADDR_ATTRIBUTE10 PER_ADDRESSES.ADDR_ATTRIBUTE10%TYPE,
476: ADDR_ATTRIBUTE11 PER_ADDRESSES.ADDR_ATTRIBUTE11%TYPE,
477: ADDR_ATTRIBUTE12 PER_ADDRESSES.ADDR_ATTRIBUTE12%TYPE,
478: ADDR_ATTRIBUTE13 PER_ADDRESSES.ADDR_ATTRIBUTE13%TYPE,
479: ADDR_ATTRIBUTE14 PER_ADDRESSES.ADDR_ATTRIBUTE14%TYPE,
472: ADDR_ATTRIBUTE7 PER_ADDRESSES.ADDR_ATTRIBUTE7%TYPE,
473: ADDR_ATTRIBUTE8 PER_ADDRESSES.ADDR_ATTRIBUTE8%TYPE,
474: ADDR_ATTRIBUTE9 PER_ADDRESSES.ADDR_ATTRIBUTE9%TYPE,
475: ADDR_ATTRIBUTE10 PER_ADDRESSES.ADDR_ATTRIBUTE10%TYPE,
476: ADDR_ATTRIBUTE11 PER_ADDRESSES.ADDR_ATTRIBUTE11%TYPE,
477: ADDR_ATTRIBUTE12 PER_ADDRESSES.ADDR_ATTRIBUTE12%TYPE,
478: ADDR_ATTRIBUTE13 PER_ADDRESSES.ADDR_ATTRIBUTE13%TYPE,
479: ADDR_ATTRIBUTE14 PER_ADDRESSES.ADDR_ATTRIBUTE14%TYPE,
480: ADDR_ATTRIBUTE15 PER_ADDRESSES.ADDR_ATTRIBUTE15%TYPE,
473: ADDR_ATTRIBUTE8 PER_ADDRESSES.ADDR_ATTRIBUTE8%TYPE,
474: ADDR_ATTRIBUTE9 PER_ADDRESSES.ADDR_ATTRIBUTE9%TYPE,
475: ADDR_ATTRIBUTE10 PER_ADDRESSES.ADDR_ATTRIBUTE10%TYPE,
476: ADDR_ATTRIBUTE11 PER_ADDRESSES.ADDR_ATTRIBUTE11%TYPE,
477: ADDR_ATTRIBUTE12 PER_ADDRESSES.ADDR_ATTRIBUTE12%TYPE,
478: ADDR_ATTRIBUTE13 PER_ADDRESSES.ADDR_ATTRIBUTE13%TYPE,
479: ADDR_ATTRIBUTE14 PER_ADDRESSES.ADDR_ATTRIBUTE14%TYPE,
480: ADDR_ATTRIBUTE15 PER_ADDRESSES.ADDR_ATTRIBUTE15%TYPE,
481: ADDR_ATTRIBUTE16 PER_ADDRESSES.ADDR_ATTRIBUTE16%TYPE,
474: ADDR_ATTRIBUTE9 PER_ADDRESSES.ADDR_ATTRIBUTE9%TYPE,
475: ADDR_ATTRIBUTE10 PER_ADDRESSES.ADDR_ATTRIBUTE10%TYPE,
476: ADDR_ATTRIBUTE11 PER_ADDRESSES.ADDR_ATTRIBUTE11%TYPE,
477: ADDR_ATTRIBUTE12 PER_ADDRESSES.ADDR_ATTRIBUTE12%TYPE,
478: ADDR_ATTRIBUTE13 PER_ADDRESSES.ADDR_ATTRIBUTE13%TYPE,
479: ADDR_ATTRIBUTE14 PER_ADDRESSES.ADDR_ATTRIBUTE14%TYPE,
480: ADDR_ATTRIBUTE15 PER_ADDRESSES.ADDR_ATTRIBUTE15%TYPE,
481: ADDR_ATTRIBUTE16 PER_ADDRESSES.ADDR_ATTRIBUTE16%TYPE,
482: ADDR_ATTRIBUTE17 PER_ADDRESSES.ADDR_ATTRIBUTE17%TYPE,
475: ADDR_ATTRIBUTE10 PER_ADDRESSES.ADDR_ATTRIBUTE10%TYPE,
476: ADDR_ATTRIBUTE11 PER_ADDRESSES.ADDR_ATTRIBUTE11%TYPE,
477: ADDR_ATTRIBUTE12 PER_ADDRESSES.ADDR_ATTRIBUTE12%TYPE,
478: ADDR_ATTRIBUTE13 PER_ADDRESSES.ADDR_ATTRIBUTE13%TYPE,
479: ADDR_ATTRIBUTE14 PER_ADDRESSES.ADDR_ATTRIBUTE14%TYPE,
480: ADDR_ATTRIBUTE15 PER_ADDRESSES.ADDR_ATTRIBUTE15%TYPE,
481: ADDR_ATTRIBUTE16 PER_ADDRESSES.ADDR_ATTRIBUTE16%TYPE,
482: ADDR_ATTRIBUTE17 PER_ADDRESSES.ADDR_ATTRIBUTE17%TYPE,
483: ADDR_ATTRIBUTE18 PER_ADDRESSES.ADDR_ATTRIBUTE18%TYPE,
476: ADDR_ATTRIBUTE11 PER_ADDRESSES.ADDR_ATTRIBUTE11%TYPE,
477: ADDR_ATTRIBUTE12 PER_ADDRESSES.ADDR_ATTRIBUTE12%TYPE,
478: ADDR_ATTRIBUTE13 PER_ADDRESSES.ADDR_ATTRIBUTE13%TYPE,
479: ADDR_ATTRIBUTE14 PER_ADDRESSES.ADDR_ATTRIBUTE14%TYPE,
480: ADDR_ATTRIBUTE15 PER_ADDRESSES.ADDR_ATTRIBUTE15%TYPE,
481: ADDR_ATTRIBUTE16 PER_ADDRESSES.ADDR_ATTRIBUTE16%TYPE,
482: ADDR_ATTRIBUTE17 PER_ADDRESSES.ADDR_ATTRIBUTE17%TYPE,
483: ADDR_ATTRIBUTE18 PER_ADDRESSES.ADDR_ATTRIBUTE18%TYPE,
484: ADDR_ATTRIBUTE19 PER_ADDRESSES.ADDR_ATTRIBUTE19%TYPE,
477: ADDR_ATTRIBUTE12 PER_ADDRESSES.ADDR_ATTRIBUTE12%TYPE,
478: ADDR_ATTRIBUTE13 PER_ADDRESSES.ADDR_ATTRIBUTE13%TYPE,
479: ADDR_ATTRIBUTE14 PER_ADDRESSES.ADDR_ATTRIBUTE14%TYPE,
480: ADDR_ATTRIBUTE15 PER_ADDRESSES.ADDR_ATTRIBUTE15%TYPE,
481: ADDR_ATTRIBUTE16 PER_ADDRESSES.ADDR_ATTRIBUTE16%TYPE,
482: ADDR_ATTRIBUTE17 PER_ADDRESSES.ADDR_ATTRIBUTE17%TYPE,
483: ADDR_ATTRIBUTE18 PER_ADDRESSES.ADDR_ATTRIBUTE18%TYPE,
484: ADDR_ATTRIBUTE19 PER_ADDRESSES.ADDR_ATTRIBUTE19%TYPE,
485: ADDR_ATTRIBUTE20 PER_ADDRESSES.ADDR_ATTRIBUTE20%TYPE,
478: ADDR_ATTRIBUTE13 PER_ADDRESSES.ADDR_ATTRIBUTE13%TYPE,
479: ADDR_ATTRIBUTE14 PER_ADDRESSES.ADDR_ATTRIBUTE14%TYPE,
480: ADDR_ATTRIBUTE15 PER_ADDRESSES.ADDR_ATTRIBUTE15%TYPE,
481: ADDR_ATTRIBUTE16 PER_ADDRESSES.ADDR_ATTRIBUTE16%TYPE,
482: ADDR_ATTRIBUTE17 PER_ADDRESSES.ADDR_ATTRIBUTE17%TYPE,
483: ADDR_ATTRIBUTE18 PER_ADDRESSES.ADDR_ATTRIBUTE18%TYPE,
484: ADDR_ATTRIBUTE19 PER_ADDRESSES.ADDR_ATTRIBUTE19%TYPE,
485: ADDR_ATTRIBUTE20 PER_ADDRESSES.ADDR_ATTRIBUTE20%TYPE,
486: ADD_INFORMATION13 PER_ADDRESSES.ADD_INFORMATION13%TYPE,
479: ADDR_ATTRIBUTE14 PER_ADDRESSES.ADDR_ATTRIBUTE14%TYPE,
480: ADDR_ATTRIBUTE15 PER_ADDRESSES.ADDR_ATTRIBUTE15%TYPE,
481: ADDR_ATTRIBUTE16 PER_ADDRESSES.ADDR_ATTRIBUTE16%TYPE,
482: ADDR_ATTRIBUTE17 PER_ADDRESSES.ADDR_ATTRIBUTE17%TYPE,
483: ADDR_ATTRIBUTE18 PER_ADDRESSES.ADDR_ATTRIBUTE18%TYPE,
484: ADDR_ATTRIBUTE19 PER_ADDRESSES.ADDR_ATTRIBUTE19%TYPE,
485: ADDR_ATTRIBUTE20 PER_ADDRESSES.ADDR_ATTRIBUTE20%TYPE,
486: ADD_INFORMATION13 PER_ADDRESSES.ADD_INFORMATION13%TYPE,
487: ADD_INFORMATION14 PER_ADDRESSES.ADD_INFORMATION14%TYPE,
480: ADDR_ATTRIBUTE15 PER_ADDRESSES.ADDR_ATTRIBUTE15%TYPE,
481: ADDR_ATTRIBUTE16 PER_ADDRESSES.ADDR_ATTRIBUTE16%TYPE,
482: ADDR_ATTRIBUTE17 PER_ADDRESSES.ADDR_ATTRIBUTE17%TYPE,
483: ADDR_ATTRIBUTE18 PER_ADDRESSES.ADDR_ATTRIBUTE18%TYPE,
484: ADDR_ATTRIBUTE19 PER_ADDRESSES.ADDR_ATTRIBUTE19%TYPE,
485: ADDR_ATTRIBUTE20 PER_ADDRESSES.ADDR_ATTRIBUTE20%TYPE,
486: ADD_INFORMATION13 PER_ADDRESSES.ADD_INFORMATION13%TYPE,
487: ADD_INFORMATION14 PER_ADDRESSES.ADD_INFORMATION14%TYPE,
488: ADD_INFORMATION15 PER_ADDRESSES.ADD_INFORMATION15%TYPE,
481: ADDR_ATTRIBUTE16 PER_ADDRESSES.ADDR_ATTRIBUTE16%TYPE,
482: ADDR_ATTRIBUTE17 PER_ADDRESSES.ADDR_ATTRIBUTE17%TYPE,
483: ADDR_ATTRIBUTE18 PER_ADDRESSES.ADDR_ATTRIBUTE18%TYPE,
484: ADDR_ATTRIBUTE19 PER_ADDRESSES.ADDR_ATTRIBUTE19%TYPE,
485: ADDR_ATTRIBUTE20 PER_ADDRESSES.ADDR_ATTRIBUTE20%TYPE,
486: ADD_INFORMATION13 PER_ADDRESSES.ADD_INFORMATION13%TYPE,
487: ADD_INFORMATION14 PER_ADDRESSES.ADD_INFORMATION14%TYPE,
488: ADD_INFORMATION15 PER_ADDRESSES.ADD_INFORMATION15%TYPE,
489: ADD_INFORMATION16 PER_ADDRESSES.ADD_INFORMATION16%TYPE,
482: ADDR_ATTRIBUTE17 PER_ADDRESSES.ADDR_ATTRIBUTE17%TYPE,
483: ADDR_ATTRIBUTE18 PER_ADDRESSES.ADDR_ATTRIBUTE18%TYPE,
484: ADDR_ATTRIBUTE19 PER_ADDRESSES.ADDR_ATTRIBUTE19%TYPE,
485: ADDR_ATTRIBUTE20 PER_ADDRESSES.ADDR_ATTRIBUTE20%TYPE,
486: ADD_INFORMATION13 PER_ADDRESSES.ADD_INFORMATION13%TYPE,
487: ADD_INFORMATION14 PER_ADDRESSES.ADD_INFORMATION14%TYPE,
488: ADD_INFORMATION15 PER_ADDRESSES.ADD_INFORMATION15%TYPE,
489: ADD_INFORMATION16 PER_ADDRESSES.ADD_INFORMATION16%TYPE,
490: ADD_INFORMATION17 PER_ADDRESSES.ADD_INFORMATION17%TYPE,
483: ADDR_ATTRIBUTE18 PER_ADDRESSES.ADDR_ATTRIBUTE18%TYPE,
484: ADDR_ATTRIBUTE19 PER_ADDRESSES.ADDR_ATTRIBUTE19%TYPE,
485: ADDR_ATTRIBUTE20 PER_ADDRESSES.ADDR_ATTRIBUTE20%TYPE,
486: ADD_INFORMATION13 PER_ADDRESSES.ADD_INFORMATION13%TYPE,
487: ADD_INFORMATION14 PER_ADDRESSES.ADD_INFORMATION14%TYPE,
488: ADD_INFORMATION15 PER_ADDRESSES.ADD_INFORMATION15%TYPE,
489: ADD_INFORMATION16 PER_ADDRESSES.ADD_INFORMATION16%TYPE,
490: ADD_INFORMATION17 PER_ADDRESSES.ADD_INFORMATION17%TYPE,
491: ADD_INFORMATION18 PER_ADDRESSES.ADD_INFORMATION18%TYPE,
484: ADDR_ATTRIBUTE19 PER_ADDRESSES.ADDR_ATTRIBUTE19%TYPE,
485: ADDR_ATTRIBUTE20 PER_ADDRESSES.ADDR_ATTRIBUTE20%TYPE,
486: ADD_INFORMATION13 PER_ADDRESSES.ADD_INFORMATION13%TYPE,
487: ADD_INFORMATION14 PER_ADDRESSES.ADD_INFORMATION14%TYPE,
488: ADD_INFORMATION15 PER_ADDRESSES.ADD_INFORMATION15%TYPE,
489: ADD_INFORMATION16 PER_ADDRESSES.ADD_INFORMATION16%TYPE,
490: ADD_INFORMATION17 PER_ADDRESSES.ADD_INFORMATION17%TYPE,
491: ADD_INFORMATION18 PER_ADDRESSES.ADD_INFORMATION18%TYPE,
492: ADD_INFORMATION19 PER_ADDRESSES.ADD_INFORMATION19%TYPE,
485: ADDR_ATTRIBUTE20 PER_ADDRESSES.ADDR_ATTRIBUTE20%TYPE,
486: ADD_INFORMATION13 PER_ADDRESSES.ADD_INFORMATION13%TYPE,
487: ADD_INFORMATION14 PER_ADDRESSES.ADD_INFORMATION14%TYPE,
488: ADD_INFORMATION15 PER_ADDRESSES.ADD_INFORMATION15%TYPE,
489: ADD_INFORMATION16 PER_ADDRESSES.ADD_INFORMATION16%TYPE,
490: ADD_INFORMATION17 PER_ADDRESSES.ADD_INFORMATION17%TYPE,
491: ADD_INFORMATION18 PER_ADDRESSES.ADD_INFORMATION18%TYPE,
492: ADD_INFORMATION19 PER_ADDRESSES.ADD_INFORMATION19%TYPE,
493: ADD_INFORMATION20 PER_ADDRESSES.ADD_INFORMATION20%TYPE,
486: ADD_INFORMATION13 PER_ADDRESSES.ADD_INFORMATION13%TYPE,
487: ADD_INFORMATION14 PER_ADDRESSES.ADD_INFORMATION14%TYPE,
488: ADD_INFORMATION15 PER_ADDRESSES.ADD_INFORMATION15%TYPE,
489: ADD_INFORMATION16 PER_ADDRESSES.ADD_INFORMATION16%TYPE,
490: ADD_INFORMATION17 PER_ADDRESSES.ADD_INFORMATION17%TYPE,
491: ADD_INFORMATION18 PER_ADDRESSES.ADD_INFORMATION18%TYPE,
492: ADD_INFORMATION19 PER_ADDRESSES.ADD_INFORMATION19%TYPE,
493: ADD_INFORMATION20 PER_ADDRESSES.ADD_INFORMATION20%TYPE,
494: PARTY_ID PER_ADDRESSES.PARTY_ID%TYPE,
487: ADD_INFORMATION14 PER_ADDRESSES.ADD_INFORMATION14%TYPE,
488: ADD_INFORMATION15 PER_ADDRESSES.ADD_INFORMATION15%TYPE,
489: ADD_INFORMATION16 PER_ADDRESSES.ADD_INFORMATION16%TYPE,
490: ADD_INFORMATION17 PER_ADDRESSES.ADD_INFORMATION17%TYPE,
491: ADD_INFORMATION18 PER_ADDRESSES.ADD_INFORMATION18%TYPE,
492: ADD_INFORMATION19 PER_ADDRESSES.ADD_INFORMATION19%TYPE,
493: ADD_INFORMATION20 PER_ADDRESSES.ADD_INFORMATION20%TYPE,
494: PARTY_ID PER_ADDRESSES.PARTY_ID%TYPE,
495: DERIVED_LOCALE PER_ADDRESSES.DERIVED_LOCALE%TYPE,
488: ADD_INFORMATION15 PER_ADDRESSES.ADD_INFORMATION15%TYPE,
489: ADD_INFORMATION16 PER_ADDRESSES.ADD_INFORMATION16%TYPE,
490: ADD_INFORMATION17 PER_ADDRESSES.ADD_INFORMATION17%TYPE,
491: ADD_INFORMATION18 PER_ADDRESSES.ADD_INFORMATION18%TYPE,
492: ADD_INFORMATION19 PER_ADDRESSES.ADD_INFORMATION19%TYPE,
493: ADD_INFORMATION20 PER_ADDRESSES.ADD_INFORMATION20%TYPE,
494: PARTY_ID PER_ADDRESSES.PARTY_ID%TYPE,
495: DERIVED_LOCALE PER_ADDRESSES.DERIVED_LOCALE%TYPE,
496: GEOMETRY PER_ADDRESSES.GEOMETRY%TYPE,
489: ADD_INFORMATION16 PER_ADDRESSES.ADD_INFORMATION16%TYPE,
490: ADD_INFORMATION17 PER_ADDRESSES.ADD_INFORMATION17%TYPE,
491: ADD_INFORMATION18 PER_ADDRESSES.ADD_INFORMATION18%TYPE,
492: ADD_INFORMATION19 PER_ADDRESSES.ADD_INFORMATION19%TYPE,
493: ADD_INFORMATION20 PER_ADDRESSES.ADD_INFORMATION20%TYPE,
494: PARTY_ID PER_ADDRESSES.PARTY_ID%TYPE,
495: DERIVED_LOCALE PER_ADDRESSES.DERIVED_LOCALE%TYPE,
496: GEOMETRY PER_ADDRESSES.GEOMETRY%TYPE,
497: COMMENTS PER_ADDRESSES.COMMENTS%TYPE
490: ADD_INFORMATION17 PER_ADDRESSES.ADD_INFORMATION17%TYPE,
491: ADD_INFORMATION18 PER_ADDRESSES.ADD_INFORMATION18%TYPE,
492: ADD_INFORMATION19 PER_ADDRESSES.ADD_INFORMATION19%TYPE,
493: ADD_INFORMATION20 PER_ADDRESSES.ADD_INFORMATION20%TYPE,
494: PARTY_ID PER_ADDRESSES.PARTY_ID%TYPE,
495: DERIVED_LOCALE PER_ADDRESSES.DERIVED_LOCALE%TYPE,
496: GEOMETRY PER_ADDRESSES.GEOMETRY%TYPE,
497: COMMENTS PER_ADDRESSES.COMMENTS%TYPE
498: );
491: ADD_INFORMATION18 PER_ADDRESSES.ADD_INFORMATION18%TYPE,
492: ADD_INFORMATION19 PER_ADDRESSES.ADD_INFORMATION19%TYPE,
493: ADD_INFORMATION20 PER_ADDRESSES.ADD_INFORMATION20%TYPE,
494: PARTY_ID PER_ADDRESSES.PARTY_ID%TYPE,
495: DERIVED_LOCALE PER_ADDRESSES.DERIVED_LOCALE%TYPE,
496: GEOMETRY PER_ADDRESSES.GEOMETRY%TYPE,
497: COMMENTS PER_ADDRESSES.COMMENTS%TYPE
498: );
499:
492: ADD_INFORMATION19 PER_ADDRESSES.ADD_INFORMATION19%TYPE,
493: ADD_INFORMATION20 PER_ADDRESSES.ADD_INFORMATION20%TYPE,
494: PARTY_ID PER_ADDRESSES.PARTY_ID%TYPE,
495: DERIVED_LOCALE PER_ADDRESSES.DERIVED_LOCALE%TYPE,
496: GEOMETRY PER_ADDRESSES.GEOMETRY%TYPE,
497: COMMENTS PER_ADDRESSES.COMMENTS%TYPE
498: );
499:
500:
493: ADD_INFORMATION20 PER_ADDRESSES.ADD_INFORMATION20%TYPE,
494: PARTY_ID PER_ADDRESSES.PARTY_ID%TYPE,
495: DERIVED_LOCALE PER_ADDRESSES.DERIVED_LOCALE%TYPE,
496: GEOMETRY PER_ADDRESSES.GEOMETRY%TYPE,
497: COMMENTS PER_ADDRESSES.COMMENTS%TYPE
498: );
499:
500:
501:
501:
502: /*Record type for address details*/
503: TYPE ADDRESS_DETAILS is RECORD
504: (
505: ADDRESS_ID PER_ADDRESSES.ADDRESS_ID%TYPE,
506: DATE_FROM varchar2(10),
507: PRIMARY_FLAG PER_ADDRESSES.PRIMARY_FLAG%TYPE,
508: STYLE PER_ADDRESSES.STYLE%TYPE,
509: STYLE_DESC VARCHAR2(100), -- FROM FLEXFIELDS
503: TYPE ADDRESS_DETAILS is RECORD
504: (
505: ADDRESS_ID PER_ADDRESSES.ADDRESS_ID%TYPE,
506: DATE_FROM varchar2(10),
507: PRIMARY_FLAG PER_ADDRESSES.PRIMARY_FLAG%TYPE,
508: STYLE PER_ADDRESSES.STYLE%TYPE,
509: STYLE_DESC VARCHAR2(100), -- FROM FLEXFIELDS
510: ADDRESS_LINE1 PER_ADDRESSES.ADDRESS_LINE1%TYPE,
511: ADDRESS_LINE2 PER_ADDRESSES.ADDRESS_LINE2%TYPE,
504: (
505: ADDRESS_ID PER_ADDRESSES.ADDRESS_ID%TYPE,
506: DATE_FROM varchar2(10),
507: PRIMARY_FLAG PER_ADDRESSES.PRIMARY_FLAG%TYPE,
508: STYLE PER_ADDRESSES.STYLE%TYPE,
509: STYLE_DESC VARCHAR2(100), -- FROM FLEXFIELDS
510: ADDRESS_LINE1 PER_ADDRESSES.ADDRESS_LINE1%TYPE,
511: ADDRESS_LINE2 PER_ADDRESSES.ADDRESS_LINE2%TYPE,
512: ADDRESS_LINE3 PER_ADDRESSES.ADDRESS_LINE3%TYPE,
506: DATE_FROM varchar2(10),
507: PRIMARY_FLAG PER_ADDRESSES.PRIMARY_FLAG%TYPE,
508: STYLE PER_ADDRESSES.STYLE%TYPE,
509: STYLE_DESC VARCHAR2(100), -- FROM FLEXFIELDS
510: ADDRESS_LINE1 PER_ADDRESSES.ADDRESS_LINE1%TYPE,
511: ADDRESS_LINE2 PER_ADDRESSES.ADDRESS_LINE2%TYPE,
512: ADDRESS_LINE3 PER_ADDRESSES.ADDRESS_LINE3%TYPE,
513: ADDRESS_TYPE PER_ADDRESSES.ADDRESS_TYPE%TYPE,
514: ADDRESS_TYPE_DESC FND_LOOKUP_VALUES.MEANING%TYPE, --(BASED ON LANG /'ADDRESS_TYPE')
507: PRIMARY_FLAG PER_ADDRESSES.PRIMARY_FLAG%TYPE,
508: STYLE PER_ADDRESSES.STYLE%TYPE,
509: STYLE_DESC VARCHAR2(100), -- FROM FLEXFIELDS
510: ADDRESS_LINE1 PER_ADDRESSES.ADDRESS_LINE1%TYPE,
511: ADDRESS_LINE2 PER_ADDRESSES.ADDRESS_LINE2%TYPE,
512: ADDRESS_LINE3 PER_ADDRESSES.ADDRESS_LINE3%TYPE,
513: ADDRESS_TYPE PER_ADDRESSES.ADDRESS_TYPE%TYPE,
514: ADDRESS_TYPE_DESC FND_LOOKUP_VALUES.MEANING%TYPE, --(BASED ON LANG /'ADDRESS_TYPE')
515: COUNTRY PER_ADDRESSES.COUNTRY%TYPE,
508: STYLE PER_ADDRESSES.STYLE%TYPE,
509: STYLE_DESC VARCHAR2(100), -- FROM FLEXFIELDS
510: ADDRESS_LINE1 PER_ADDRESSES.ADDRESS_LINE1%TYPE,
511: ADDRESS_LINE2 PER_ADDRESSES.ADDRESS_LINE2%TYPE,
512: ADDRESS_LINE3 PER_ADDRESSES.ADDRESS_LINE3%TYPE,
513: ADDRESS_TYPE PER_ADDRESSES.ADDRESS_TYPE%TYPE,
514: ADDRESS_TYPE_DESC FND_LOOKUP_VALUES.MEANING%TYPE, --(BASED ON LANG /'ADDRESS_TYPE')
515: COUNTRY PER_ADDRESSES.COUNTRY%TYPE,
516: COUNTRY_DESC FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE,
509: STYLE_DESC VARCHAR2(100), -- FROM FLEXFIELDS
510: ADDRESS_LINE1 PER_ADDRESSES.ADDRESS_LINE1%TYPE,
511: ADDRESS_LINE2 PER_ADDRESSES.ADDRESS_LINE2%TYPE,
512: ADDRESS_LINE3 PER_ADDRESSES.ADDRESS_LINE3%TYPE,
513: ADDRESS_TYPE PER_ADDRESSES.ADDRESS_TYPE%TYPE,
514: ADDRESS_TYPE_DESC FND_LOOKUP_VALUES.MEANING%TYPE, --(BASED ON LANG /'ADDRESS_TYPE')
515: COUNTRY PER_ADDRESSES.COUNTRY%TYPE,
516: COUNTRY_DESC FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE,
517: DATE_TO varchar2(10),
511: ADDRESS_LINE2 PER_ADDRESSES.ADDRESS_LINE2%TYPE,
512: ADDRESS_LINE3 PER_ADDRESSES.ADDRESS_LINE3%TYPE,
513: ADDRESS_TYPE PER_ADDRESSES.ADDRESS_TYPE%TYPE,
514: ADDRESS_TYPE_DESC FND_LOOKUP_VALUES.MEANING%TYPE, --(BASED ON LANG /'ADDRESS_TYPE')
515: COUNTRY PER_ADDRESSES.COUNTRY%TYPE,
516: COUNTRY_DESC FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE,
517: DATE_TO varchar2(10),
518: POSTAL_CODE PER_ADDRESSES.POSTAL_CODE%TYPE,
519: REGION_1 PER_ADDRESSES.REGION_1%TYPE,
514: ADDRESS_TYPE_DESC FND_LOOKUP_VALUES.MEANING%TYPE, --(BASED ON LANG /'ADDRESS_TYPE')
515: COUNTRY PER_ADDRESSES.COUNTRY%TYPE,
516: COUNTRY_DESC FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE,
517: DATE_TO varchar2(10),
518: POSTAL_CODE PER_ADDRESSES.POSTAL_CODE%TYPE,
519: REGION_1 PER_ADDRESSES.REGION_1%TYPE,
520: REGION_1_DESC VARCHAR2(240),
521: REGION_2 PER_ADDRESSES.REGION_2%TYPE,
522: REGION_2_DESC VARCHAR2(240),
515: COUNTRY PER_ADDRESSES.COUNTRY%TYPE,
516: COUNTRY_DESC FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE,
517: DATE_TO varchar2(10),
518: POSTAL_CODE PER_ADDRESSES.POSTAL_CODE%TYPE,
519: REGION_1 PER_ADDRESSES.REGION_1%TYPE,
520: REGION_1_DESC VARCHAR2(240),
521: REGION_2 PER_ADDRESSES.REGION_2%TYPE,
522: REGION_2_DESC VARCHAR2(240),
523: REGION_3 PER_ADDRESSES.REGION_3%TYPE,
517: DATE_TO varchar2(10),
518: POSTAL_CODE PER_ADDRESSES.POSTAL_CODE%TYPE,
519: REGION_1 PER_ADDRESSES.REGION_1%TYPE,
520: REGION_1_DESC VARCHAR2(240),
521: REGION_2 PER_ADDRESSES.REGION_2%TYPE,
522: REGION_2_DESC VARCHAR2(240),
523: REGION_3 PER_ADDRESSES.REGION_3%TYPE,
524: REGION_3_DESC VARCHAR2(240),
525: TELEPHONE_NUMBER_1 PER_ADDRESSES.TELEPHONE_NUMBER_1%TYPE,
519: REGION_1 PER_ADDRESSES.REGION_1%TYPE,
520: REGION_1_DESC VARCHAR2(240),
521: REGION_2 PER_ADDRESSES.REGION_2%TYPE,
522: REGION_2_DESC VARCHAR2(240),
523: REGION_3 PER_ADDRESSES.REGION_3%TYPE,
524: REGION_3_DESC VARCHAR2(240),
525: TELEPHONE_NUMBER_1 PER_ADDRESSES.TELEPHONE_NUMBER_1%TYPE,
526: TELEPHONE_NUMBER_2 PER_ADDRESSES.TELEPHONE_NUMBER_2%TYPE,
527: TELEPHONE_NUMBER_3 PER_ADDRESSES.TELEPHONE_NUMBER_3%TYPE,
521: REGION_2 PER_ADDRESSES.REGION_2%TYPE,
522: REGION_2_DESC VARCHAR2(240),
523: REGION_3 PER_ADDRESSES.REGION_3%TYPE,
524: REGION_3_DESC VARCHAR2(240),
525: TELEPHONE_NUMBER_1 PER_ADDRESSES.TELEPHONE_NUMBER_1%TYPE,
526: TELEPHONE_NUMBER_2 PER_ADDRESSES.TELEPHONE_NUMBER_2%TYPE,
527: TELEPHONE_NUMBER_3 PER_ADDRESSES.TELEPHONE_NUMBER_3%TYPE,
528: TOWN_OR_CITY PER_ADDRESSES.TOWN_OR_CITY%TYPE,
529: TOWN_OR_CITY_DESC VARCHAR2(240),
522: REGION_2_DESC VARCHAR2(240),
523: REGION_3 PER_ADDRESSES.REGION_3%TYPE,
524: REGION_3_DESC VARCHAR2(240),
525: TELEPHONE_NUMBER_1 PER_ADDRESSES.TELEPHONE_NUMBER_1%TYPE,
526: TELEPHONE_NUMBER_2 PER_ADDRESSES.TELEPHONE_NUMBER_2%TYPE,
527: TELEPHONE_NUMBER_3 PER_ADDRESSES.TELEPHONE_NUMBER_3%TYPE,
528: TOWN_OR_CITY PER_ADDRESSES.TOWN_OR_CITY%TYPE,
529: TOWN_OR_CITY_DESC VARCHAR2(240),
530: ADDR_ATTRIBUTE_CATEGORY PER_ADDRESSES.ADDR_ATTRIBUTE_CATEGORY%TYPE,
523: REGION_3 PER_ADDRESSES.REGION_3%TYPE,
524: REGION_3_DESC VARCHAR2(240),
525: TELEPHONE_NUMBER_1 PER_ADDRESSES.TELEPHONE_NUMBER_1%TYPE,
526: TELEPHONE_NUMBER_2 PER_ADDRESSES.TELEPHONE_NUMBER_2%TYPE,
527: TELEPHONE_NUMBER_3 PER_ADDRESSES.TELEPHONE_NUMBER_3%TYPE,
528: TOWN_OR_CITY PER_ADDRESSES.TOWN_OR_CITY%TYPE,
529: TOWN_OR_CITY_DESC VARCHAR2(240),
530: ADDR_ATTRIBUTE_CATEGORY PER_ADDRESSES.ADDR_ATTRIBUTE_CATEGORY%TYPE,
531: ADDR_ATTRIBUTE1 PER_ADDRESSES.ADDR_ATTRIBUTE1%TYPE,
524: REGION_3_DESC VARCHAR2(240),
525: TELEPHONE_NUMBER_1 PER_ADDRESSES.TELEPHONE_NUMBER_1%TYPE,
526: TELEPHONE_NUMBER_2 PER_ADDRESSES.TELEPHONE_NUMBER_2%TYPE,
527: TELEPHONE_NUMBER_3 PER_ADDRESSES.TELEPHONE_NUMBER_3%TYPE,
528: TOWN_OR_CITY PER_ADDRESSES.TOWN_OR_CITY%TYPE,
529: TOWN_OR_CITY_DESC VARCHAR2(240),
530: ADDR_ATTRIBUTE_CATEGORY PER_ADDRESSES.ADDR_ATTRIBUTE_CATEGORY%TYPE,
531: ADDR_ATTRIBUTE1 PER_ADDRESSES.ADDR_ATTRIBUTE1%TYPE,
532: ADDR_ATTRIBUTE2 PER_ADDRESSES.ADDR_ATTRIBUTE2%TYPE,
526: TELEPHONE_NUMBER_2 PER_ADDRESSES.TELEPHONE_NUMBER_2%TYPE,
527: TELEPHONE_NUMBER_3 PER_ADDRESSES.TELEPHONE_NUMBER_3%TYPE,
528: TOWN_OR_CITY PER_ADDRESSES.TOWN_OR_CITY%TYPE,
529: TOWN_OR_CITY_DESC VARCHAR2(240),
530: ADDR_ATTRIBUTE_CATEGORY PER_ADDRESSES.ADDR_ATTRIBUTE_CATEGORY%TYPE,
531: ADDR_ATTRIBUTE1 PER_ADDRESSES.ADDR_ATTRIBUTE1%TYPE,
532: ADDR_ATTRIBUTE2 PER_ADDRESSES.ADDR_ATTRIBUTE2%TYPE,
533: ADDR_ATTRIBUTE3 PER_ADDRESSES.ADDR_ATTRIBUTE3%TYPE,
534: ADDR_ATTRIBUTE4 PER_ADDRESSES.ADDR_ATTRIBUTE4%TYPE,
527: TELEPHONE_NUMBER_3 PER_ADDRESSES.TELEPHONE_NUMBER_3%TYPE,
528: TOWN_OR_CITY PER_ADDRESSES.TOWN_OR_CITY%TYPE,
529: TOWN_OR_CITY_DESC VARCHAR2(240),
530: ADDR_ATTRIBUTE_CATEGORY PER_ADDRESSES.ADDR_ATTRIBUTE_CATEGORY%TYPE,
531: ADDR_ATTRIBUTE1 PER_ADDRESSES.ADDR_ATTRIBUTE1%TYPE,
532: ADDR_ATTRIBUTE2 PER_ADDRESSES.ADDR_ATTRIBUTE2%TYPE,
533: ADDR_ATTRIBUTE3 PER_ADDRESSES.ADDR_ATTRIBUTE3%TYPE,
534: ADDR_ATTRIBUTE4 PER_ADDRESSES.ADDR_ATTRIBUTE4%TYPE,
535: ADDR_ATTRIBUTE5 PER_ADDRESSES.ADDR_ATTRIBUTE5%TYPE,
528: TOWN_OR_CITY PER_ADDRESSES.TOWN_OR_CITY%TYPE,
529: TOWN_OR_CITY_DESC VARCHAR2(240),
530: ADDR_ATTRIBUTE_CATEGORY PER_ADDRESSES.ADDR_ATTRIBUTE_CATEGORY%TYPE,
531: ADDR_ATTRIBUTE1 PER_ADDRESSES.ADDR_ATTRIBUTE1%TYPE,
532: ADDR_ATTRIBUTE2 PER_ADDRESSES.ADDR_ATTRIBUTE2%TYPE,
533: ADDR_ATTRIBUTE3 PER_ADDRESSES.ADDR_ATTRIBUTE3%TYPE,
534: ADDR_ATTRIBUTE4 PER_ADDRESSES.ADDR_ATTRIBUTE4%TYPE,
535: ADDR_ATTRIBUTE5 PER_ADDRESSES.ADDR_ATTRIBUTE5%TYPE,
536: ADDR_ATTRIBUTE6 PER_ADDRESSES.ADDR_ATTRIBUTE6%TYPE,
529: TOWN_OR_CITY_DESC VARCHAR2(240),
530: ADDR_ATTRIBUTE_CATEGORY PER_ADDRESSES.ADDR_ATTRIBUTE_CATEGORY%TYPE,
531: ADDR_ATTRIBUTE1 PER_ADDRESSES.ADDR_ATTRIBUTE1%TYPE,
532: ADDR_ATTRIBUTE2 PER_ADDRESSES.ADDR_ATTRIBUTE2%TYPE,
533: ADDR_ATTRIBUTE3 PER_ADDRESSES.ADDR_ATTRIBUTE3%TYPE,
534: ADDR_ATTRIBUTE4 PER_ADDRESSES.ADDR_ATTRIBUTE4%TYPE,
535: ADDR_ATTRIBUTE5 PER_ADDRESSES.ADDR_ATTRIBUTE5%TYPE,
536: ADDR_ATTRIBUTE6 PER_ADDRESSES.ADDR_ATTRIBUTE6%TYPE,
537: ADDR_ATTRIBUTE7 PER_ADDRESSES.ADDR_ATTRIBUTE7%TYPE,
530: ADDR_ATTRIBUTE_CATEGORY PER_ADDRESSES.ADDR_ATTRIBUTE_CATEGORY%TYPE,
531: ADDR_ATTRIBUTE1 PER_ADDRESSES.ADDR_ATTRIBUTE1%TYPE,
532: ADDR_ATTRIBUTE2 PER_ADDRESSES.ADDR_ATTRIBUTE2%TYPE,
533: ADDR_ATTRIBUTE3 PER_ADDRESSES.ADDR_ATTRIBUTE3%TYPE,
534: ADDR_ATTRIBUTE4 PER_ADDRESSES.ADDR_ATTRIBUTE4%TYPE,
535: ADDR_ATTRIBUTE5 PER_ADDRESSES.ADDR_ATTRIBUTE5%TYPE,
536: ADDR_ATTRIBUTE6 PER_ADDRESSES.ADDR_ATTRIBUTE6%TYPE,
537: ADDR_ATTRIBUTE7 PER_ADDRESSES.ADDR_ATTRIBUTE7%TYPE,
538: ADDR_ATTRIBUTE8 PER_ADDRESSES.ADDR_ATTRIBUTE8%TYPE,
531: ADDR_ATTRIBUTE1 PER_ADDRESSES.ADDR_ATTRIBUTE1%TYPE,
532: ADDR_ATTRIBUTE2 PER_ADDRESSES.ADDR_ATTRIBUTE2%TYPE,
533: ADDR_ATTRIBUTE3 PER_ADDRESSES.ADDR_ATTRIBUTE3%TYPE,
534: ADDR_ATTRIBUTE4 PER_ADDRESSES.ADDR_ATTRIBUTE4%TYPE,
535: ADDR_ATTRIBUTE5 PER_ADDRESSES.ADDR_ATTRIBUTE5%TYPE,
536: ADDR_ATTRIBUTE6 PER_ADDRESSES.ADDR_ATTRIBUTE6%TYPE,
537: ADDR_ATTRIBUTE7 PER_ADDRESSES.ADDR_ATTRIBUTE7%TYPE,
538: ADDR_ATTRIBUTE8 PER_ADDRESSES.ADDR_ATTRIBUTE8%TYPE,
539: ADDR_ATTRIBUTE9 PER_ADDRESSES.ADDR_ATTRIBUTE9%TYPE,
532: ADDR_ATTRIBUTE2 PER_ADDRESSES.ADDR_ATTRIBUTE2%TYPE,
533: ADDR_ATTRIBUTE3 PER_ADDRESSES.ADDR_ATTRIBUTE3%TYPE,
534: ADDR_ATTRIBUTE4 PER_ADDRESSES.ADDR_ATTRIBUTE4%TYPE,
535: ADDR_ATTRIBUTE5 PER_ADDRESSES.ADDR_ATTRIBUTE5%TYPE,
536: ADDR_ATTRIBUTE6 PER_ADDRESSES.ADDR_ATTRIBUTE6%TYPE,
537: ADDR_ATTRIBUTE7 PER_ADDRESSES.ADDR_ATTRIBUTE7%TYPE,
538: ADDR_ATTRIBUTE8 PER_ADDRESSES.ADDR_ATTRIBUTE8%TYPE,
539: ADDR_ATTRIBUTE9 PER_ADDRESSES.ADDR_ATTRIBUTE9%TYPE,
540: ADDR_ATTRIBUTE10 PER_ADDRESSES.ADDR_ATTRIBUTE10%TYPE,
533: ADDR_ATTRIBUTE3 PER_ADDRESSES.ADDR_ATTRIBUTE3%TYPE,
534: ADDR_ATTRIBUTE4 PER_ADDRESSES.ADDR_ATTRIBUTE4%TYPE,
535: ADDR_ATTRIBUTE5 PER_ADDRESSES.ADDR_ATTRIBUTE5%TYPE,
536: ADDR_ATTRIBUTE6 PER_ADDRESSES.ADDR_ATTRIBUTE6%TYPE,
537: ADDR_ATTRIBUTE7 PER_ADDRESSES.ADDR_ATTRIBUTE7%TYPE,
538: ADDR_ATTRIBUTE8 PER_ADDRESSES.ADDR_ATTRIBUTE8%TYPE,
539: ADDR_ATTRIBUTE9 PER_ADDRESSES.ADDR_ATTRIBUTE9%TYPE,
540: ADDR_ATTRIBUTE10 PER_ADDRESSES.ADDR_ATTRIBUTE10%TYPE,
541: ADDR_ATTRIBUTE11 PER_ADDRESSES.ADDR_ATTRIBUTE11%TYPE,
534: ADDR_ATTRIBUTE4 PER_ADDRESSES.ADDR_ATTRIBUTE4%TYPE,
535: ADDR_ATTRIBUTE5 PER_ADDRESSES.ADDR_ATTRIBUTE5%TYPE,
536: ADDR_ATTRIBUTE6 PER_ADDRESSES.ADDR_ATTRIBUTE6%TYPE,
537: ADDR_ATTRIBUTE7 PER_ADDRESSES.ADDR_ATTRIBUTE7%TYPE,
538: ADDR_ATTRIBUTE8 PER_ADDRESSES.ADDR_ATTRIBUTE8%TYPE,
539: ADDR_ATTRIBUTE9 PER_ADDRESSES.ADDR_ATTRIBUTE9%TYPE,
540: ADDR_ATTRIBUTE10 PER_ADDRESSES.ADDR_ATTRIBUTE10%TYPE,
541: ADDR_ATTRIBUTE11 PER_ADDRESSES.ADDR_ATTRIBUTE11%TYPE,
542: ADDR_ATTRIBUTE12 PER_ADDRESSES.ADDR_ATTRIBUTE12%TYPE,
535: ADDR_ATTRIBUTE5 PER_ADDRESSES.ADDR_ATTRIBUTE5%TYPE,
536: ADDR_ATTRIBUTE6 PER_ADDRESSES.ADDR_ATTRIBUTE6%TYPE,
537: ADDR_ATTRIBUTE7 PER_ADDRESSES.ADDR_ATTRIBUTE7%TYPE,
538: ADDR_ATTRIBUTE8 PER_ADDRESSES.ADDR_ATTRIBUTE8%TYPE,
539: ADDR_ATTRIBUTE9 PER_ADDRESSES.ADDR_ATTRIBUTE9%TYPE,
540: ADDR_ATTRIBUTE10 PER_ADDRESSES.ADDR_ATTRIBUTE10%TYPE,
541: ADDR_ATTRIBUTE11 PER_ADDRESSES.ADDR_ATTRIBUTE11%TYPE,
542: ADDR_ATTRIBUTE12 PER_ADDRESSES.ADDR_ATTRIBUTE12%TYPE,
543: ADDR_ATTRIBUTE13 PER_ADDRESSES.ADDR_ATTRIBUTE13%TYPE,
536: ADDR_ATTRIBUTE6 PER_ADDRESSES.ADDR_ATTRIBUTE6%TYPE,
537: ADDR_ATTRIBUTE7 PER_ADDRESSES.ADDR_ATTRIBUTE7%TYPE,
538: ADDR_ATTRIBUTE8 PER_ADDRESSES.ADDR_ATTRIBUTE8%TYPE,
539: ADDR_ATTRIBUTE9 PER_ADDRESSES.ADDR_ATTRIBUTE9%TYPE,
540: ADDR_ATTRIBUTE10 PER_ADDRESSES.ADDR_ATTRIBUTE10%TYPE,
541: ADDR_ATTRIBUTE11 PER_ADDRESSES.ADDR_ATTRIBUTE11%TYPE,
542: ADDR_ATTRIBUTE12 PER_ADDRESSES.ADDR_ATTRIBUTE12%TYPE,
543: ADDR_ATTRIBUTE13 PER_ADDRESSES.ADDR_ATTRIBUTE13%TYPE,
544: ADDR_ATTRIBUTE14 PER_ADDRESSES.ADDR_ATTRIBUTE14%TYPE,
537: ADDR_ATTRIBUTE7 PER_ADDRESSES.ADDR_ATTRIBUTE7%TYPE,
538: ADDR_ATTRIBUTE8 PER_ADDRESSES.ADDR_ATTRIBUTE8%TYPE,
539: ADDR_ATTRIBUTE9 PER_ADDRESSES.ADDR_ATTRIBUTE9%TYPE,
540: ADDR_ATTRIBUTE10 PER_ADDRESSES.ADDR_ATTRIBUTE10%TYPE,
541: ADDR_ATTRIBUTE11 PER_ADDRESSES.ADDR_ATTRIBUTE11%TYPE,
542: ADDR_ATTRIBUTE12 PER_ADDRESSES.ADDR_ATTRIBUTE12%TYPE,
543: ADDR_ATTRIBUTE13 PER_ADDRESSES.ADDR_ATTRIBUTE13%TYPE,
544: ADDR_ATTRIBUTE14 PER_ADDRESSES.ADDR_ATTRIBUTE14%TYPE,
545: ADDR_ATTRIBUTE15 PER_ADDRESSES.ADDR_ATTRIBUTE15%TYPE,
538: ADDR_ATTRIBUTE8 PER_ADDRESSES.ADDR_ATTRIBUTE8%TYPE,
539: ADDR_ATTRIBUTE9 PER_ADDRESSES.ADDR_ATTRIBUTE9%TYPE,
540: ADDR_ATTRIBUTE10 PER_ADDRESSES.ADDR_ATTRIBUTE10%TYPE,
541: ADDR_ATTRIBUTE11 PER_ADDRESSES.ADDR_ATTRIBUTE11%TYPE,
542: ADDR_ATTRIBUTE12 PER_ADDRESSES.ADDR_ATTRIBUTE12%TYPE,
543: ADDR_ATTRIBUTE13 PER_ADDRESSES.ADDR_ATTRIBUTE13%TYPE,
544: ADDR_ATTRIBUTE14 PER_ADDRESSES.ADDR_ATTRIBUTE14%TYPE,
545: ADDR_ATTRIBUTE15 PER_ADDRESSES.ADDR_ATTRIBUTE15%TYPE,
546: ADDR_ATTRIBUTE16 PER_ADDRESSES.ADDR_ATTRIBUTE16%TYPE,
539: ADDR_ATTRIBUTE9 PER_ADDRESSES.ADDR_ATTRIBUTE9%TYPE,
540: ADDR_ATTRIBUTE10 PER_ADDRESSES.ADDR_ATTRIBUTE10%TYPE,
541: ADDR_ATTRIBUTE11 PER_ADDRESSES.ADDR_ATTRIBUTE11%TYPE,
542: ADDR_ATTRIBUTE12 PER_ADDRESSES.ADDR_ATTRIBUTE12%TYPE,
543: ADDR_ATTRIBUTE13 PER_ADDRESSES.ADDR_ATTRIBUTE13%TYPE,
544: ADDR_ATTRIBUTE14 PER_ADDRESSES.ADDR_ATTRIBUTE14%TYPE,
545: ADDR_ATTRIBUTE15 PER_ADDRESSES.ADDR_ATTRIBUTE15%TYPE,
546: ADDR_ATTRIBUTE16 PER_ADDRESSES.ADDR_ATTRIBUTE16%TYPE,
547: ADDR_ATTRIBUTE17 PER_ADDRESSES.ADDR_ATTRIBUTE17%TYPE,
540: ADDR_ATTRIBUTE10 PER_ADDRESSES.ADDR_ATTRIBUTE10%TYPE,
541: ADDR_ATTRIBUTE11 PER_ADDRESSES.ADDR_ATTRIBUTE11%TYPE,
542: ADDR_ATTRIBUTE12 PER_ADDRESSES.ADDR_ATTRIBUTE12%TYPE,
543: ADDR_ATTRIBUTE13 PER_ADDRESSES.ADDR_ATTRIBUTE13%TYPE,
544: ADDR_ATTRIBUTE14 PER_ADDRESSES.ADDR_ATTRIBUTE14%TYPE,
545: ADDR_ATTRIBUTE15 PER_ADDRESSES.ADDR_ATTRIBUTE15%TYPE,
546: ADDR_ATTRIBUTE16 PER_ADDRESSES.ADDR_ATTRIBUTE16%TYPE,
547: ADDR_ATTRIBUTE17 PER_ADDRESSES.ADDR_ATTRIBUTE17%TYPE,
548: ADDR_ATTRIBUTE18 PER_ADDRESSES.ADDR_ATTRIBUTE18%TYPE,
541: ADDR_ATTRIBUTE11 PER_ADDRESSES.ADDR_ATTRIBUTE11%TYPE,
542: ADDR_ATTRIBUTE12 PER_ADDRESSES.ADDR_ATTRIBUTE12%TYPE,
543: ADDR_ATTRIBUTE13 PER_ADDRESSES.ADDR_ATTRIBUTE13%TYPE,
544: ADDR_ATTRIBUTE14 PER_ADDRESSES.ADDR_ATTRIBUTE14%TYPE,
545: ADDR_ATTRIBUTE15 PER_ADDRESSES.ADDR_ATTRIBUTE15%TYPE,
546: ADDR_ATTRIBUTE16 PER_ADDRESSES.ADDR_ATTRIBUTE16%TYPE,
547: ADDR_ATTRIBUTE17 PER_ADDRESSES.ADDR_ATTRIBUTE17%TYPE,
548: ADDR_ATTRIBUTE18 PER_ADDRESSES.ADDR_ATTRIBUTE18%TYPE,
549: ADDR_ATTRIBUTE19 PER_ADDRESSES.ADDR_ATTRIBUTE19%TYPE,
542: ADDR_ATTRIBUTE12 PER_ADDRESSES.ADDR_ATTRIBUTE12%TYPE,
543: ADDR_ATTRIBUTE13 PER_ADDRESSES.ADDR_ATTRIBUTE13%TYPE,
544: ADDR_ATTRIBUTE14 PER_ADDRESSES.ADDR_ATTRIBUTE14%TYPE,
545: ADDR_ATTRIBUTE15 PER_ADDRESSES.ADDR_ATTRIBUTE15%TYPE,
546: ADDR_ATTRIBUTE16 PER_ADDRESSES.ADDR_ATTRIBUTE16%TYPE,
547: ADDR_ATTRIBUTE17 PER_ADDRESSES.ADDR_ATTRIBUTE17%TYPE,
548: ADDR_ATTRIBUTE18 PER_ADDRESSES.ADDR_ATTRIBUTE18%TYPE,
549: ADDR_ATTRIBUTE19 PER_ADDRESSES.ADDR_ATTRIBUTE19%TYPE,
550: ADDR_ATTRIBUTE20 PER_ADDRESSES.ADDR_ATTRIBUTE20%TYPE,
543: ADDR_ATTRIBUTE13 PER_ADDRESSES.ADDR_ATTRIBUTE13%TYPE,
544: ADDR_ATTRIBUTE14 PER_ADDRESSES.ADDR_ATTRIBUTE14%TYPE,
545: ADDR_ATTRIBUTE15 PER_ADDRESSES.ADDR_ATTRIBUTE15%TYPE,
546: ADDR_ATTRIBUTE16 PER_ADDRESSES.ADDR_ATTRIBUTE16%TYPE,
547: ADDR_ATTRIBUTE17 PER_ADDRESSES.ADDR_ATTRIBUTE17%TYPE,
548: ADDR_ATTRIBUTE18 PER_ADDRESSES.ADDR_ATTRIBUTE18%TYPE,
549: ADDR_ATTRIBUTE19 PER_ADDRESSES.ADDR_ATTRIBUTE19%TYPE,
550: ADDR_ATTRIBUTE20 PER_ADDRESSES.ADDR_ATTRIBUTE20%TYPE,
551: ADD_INFORMATION13 PER_ADDRESSES.ADD_INFORMATION13%TYPE,
544: ADDR_ATTRIBUTE14 PER_ADDRESSES.ADDR_ATTRIBUTE14%TYPE,
545: ADDR_ATTRIBUTE15 PER_ADDRESSES.ADDR_ATTRIBUTE15%TYPE,
546: ADDR_ATTRIBUTE16 PER_ADDRESSES.ADDR_ATTRIBUTE16%TYPE,
547: ADDR_ATTRIBUTE17 PER_ADDRESSES.ADDR_ATTRIBUTE17%TYPE,
548: ADDR_ATTRIBUTE18 PER_ADDRESSES.ADDR_ATTRIBUTE18%TYPE,
549: ADDR_ATTRIBUTE19 PER_ADDRESSES.ADDR_ATTRIBUTE19%TYPE,
550: ADDR_ATTRIBUTE20 PER_ADDRESSES.ADDR_ATTRIBUTE20%TYPE,
551: ADD_INFORMATION13 PER_ADDRESSES.ADD_INFORMATION13%TYPE,
552: ADD_INFORMATION14 PER_ADDRESSES.ADD_INFORMATION14%TYPE,
545: ADDR_ATTRIBUTE15 PER_ADDRESSES.ADDR_ATTRIBUTE15%TYPE,
546: ADDR_ATTRIBUTE16 PER_ADDRESSES.ADDR_ATTRIBUTE16%TYPE,
547: ADDR_ATTRIBUTE17 PER_ADDRESSES.ADDR_ATTRIBUTE17%TYPE,
548: ADDR_ATTRIBUTE18 PER_ADDRESSES.ADDR_ATTRIBUTE18%TYPE,
549: ADDR_ATTRIBUTE19 PER_ADDRESSES.ADDR_ATTRIBUTE19%TYPE,
550: ADDR_ATTRIBUTE20 PER_ADDRESSES.ADDR_ATTRIBUTE20%TYPE,
551: ADD_INFORMATION13 PER_ADDRESSES.ADD_INFORMATION13%TYPE,
552: ADD_INFORMATION14 PER_ADDRESSES.ADD_INFORMATION14%TYPE,
553: ADD_INFORMATION15 PER_ADDRESSES.ADD_INFORMATION15%TYPE,
546: ADDR_ATTRIBUTE16 PER_ADDRESSES.ADDR_ATTRIBUTE16%TYPE,
547: ADDR_ATTRIBUTE17 PER_ADDRESSES.ADDR_ATTRIBUTE17%TYPE,
548: ADDR_ATTRIBUTE18 PER_ADDRESSES.ADDR_ATTRIBUTE18%TYPE,
549: ADDR_ATTRIBUTE19 PER_ADDRESSES.ADDR_ATTRIBUTE19%TYPE,
550: ADDR_ATTRIBUTE20 PER_ADDRESSES.ADDR_ATTRIBUTE20%TYPE,
551: ADD_INFORMATION13 PER_ADDRESSES.ADD_INFORMATION13%TYPE,
552: ADD_INFORMATION14 PER_ADDRESSES.ADD_INFORMATION14%TYPE,
553: ADD_INFORMATION15 PER_ADDRESSES.ADD_INFORMATION15%TYPE,
554: ADD_INFORMATION16 PER_ADDRESSES.ADD_INFORMATION16%TYPE,
547: ADDR_ATTRIBUTE17 PER_ADDRESSES.ADDR_ATTRIBUTE17%TYPE,
548: ADDR_ATTRIBUTE18 PER_ADDRESSES.ADDR_ATTRIBUTE18%TYPE,
549: ADDR_ATTRIBUTE19 PER_ADDRESSES.ADDR_ATTRIBUTE19%TYPE,
550: ADDR_ATTRIBUTE20 PER_ADDRESSES.ADDR_ATTRIBUTE20%TYPE,
551: ADD_INFORMATION13 PER_ADDRESSES.ADD_INFORMATION13%TYPE,
552: ADD_INFORMATION14 PER_ADDRESSES.ADD_INFORMATION14%TYPE,
553: ADD_INFORMATION15 PER_ADDRESSES.ADD_INFORMATION15%TYPE,
554: ADD_INFORMATION16 PER_ADDRESSES.ADD_INFORMATION16%TYPE,
555: ADD_INFORMATION17 PER_ADDRESSES.ADD_INFORMATION17%TYPE,
548: ADDR_ATTRIBUTE18 PER_ADDRESSES.ADDR_ATTRIBUTE18%TYPE,
549: ADDR_ATTRIBUTE19 PER_ADDRESSES.ADDR_ATTRIBUTE19%TYPE,
550: ADDR_ATTRIBUTE20 PER_ADDRESSES.ADDR_ATTRIBUTE20%TYPE,
551: ADD_INFORMATION13 PER_ADDRESSES.ADD_INFORMATION13%TYPE,
552: ADD_INFORMATION14 PER_ADDRESSES.ADD_INFORMATION14%TYPE,
553: ADD_INFORMATION15 PER_ADDRESSES.ADD_INFORMATION15%TYPE,
554: ADD_INFORMATION16 PER_ADDRESSES.ADD_INFORMATION16%TYPE,
555: ADD_INFORMATION17 PER_ADDRESSES.ADD_INFORMATION17%TYPE,
556: ADD_INFORMATION18 PER_ADDRESSES.ADD_INFORMATION18%TYPE,
549: ADDR_ATTRIBUTE19 PER_ADDRESSES.ADDR_ATTRIBUTE19%TYPE,
550: ADDR_ATTRIBUTE20 PER_ADDRESSES.ADDR_ATTRIBUTE20%TYPE,
551: ADD_INFORMATION13 PER_ADDRESSES.ADD_INFORMATION13%TYPE,
552: ADD_INFORMATION14 PER_ADDRESSES.ADD_INFORMATION14%TYPE,
553: ADD_INFORMATION15 PER_ADDRESSES.ADD_INFORMATION15%TYPE,
554: ADD_INFORMATION16 PER_ADDRESSES.ADD_INFORMATION16%TYPE,
555: ADD_INFORMATION17 PER_ADDRESSES.ADD_INFORMATION17%TYPE,
556: ADD_INFORMATION18 PER_ADDRESSES.ADD_INFORMATION18%TYPE,
557: ADD_INFORMATION19 PER_ADDRESSES.ADD_INFORMATION19%TYPE,
550: ADDR_ATTRIBUTE20 PER_ADDRESSES.ADDR_ATTRIBUTE20%TYPE,
551: ADD_INFORMATION13 PER_ADDRESSES.ADD_INFORMATION13%TYPE,
552: ADD_INFORMATION14 PER_ADDRESSES.ADD_INFORMATION14%TYPE,
553: ADD_INFORMATION15 PER_ADDRESSES.ADD_INFORMATION15%TYPE,
554: ADD_INFORMATION16 PER_ADDRESSES.ADD_INFORMATION16%TYPE,
555: ADD_INFORMATION17 PER_ADDRESSES.ADD_INFORMATION17%TYPE,
556: ADD_INFORMATION18 PER_ADDRESSES.ADD_INFORMATION18%TYPE,
557: ADD_INFORMATION19 PER_ADDRESSES.ADD_INFORMATION19%TYPE,
558: ADD_INFORMATION20 PER_ADDRESSES.ADD_INFORMATION20%TYPE,
551: ADD_INFORMATION13 PER_ADDRESSES.ADD_INFORMATION13%TYPE,
552: ADD_INFORMATION14 PER_ADDRESSES.ADD_INFORMATION14%TYPE,
553: ADD_INFORMATION15 PER_ADDRESSES.ADD_INFORMATION15%TYPE,
554: ADD_INFORMATION16 PER_ADDRESSES.ADD_INFORMATION16%TYPE,
555: ADD_INFORMATION17 PER_ADDRESSES.ADD_INFORMATION17%TYPE,
556: ADD_INFORMATION18 PER_ADDRESSES.ADD_INFORMATION18%TYPE,
557: ADD_INFORMATION19 PER_ADDRESSES.ADD_INFORMATION19%TYPE,
558: ADD_INFORMATION20 PER_ADDRESSES.ADD_INFORMATION20%TYPE,
559: PARTY_ID PER_ADDRESSES.PARTY_ID%TYPE,
552: ADD_INFORMATION14 PER_ADDRESSES.ADD_INFORMATION14%TYPE,
553: ADD_INFORMATION15 PER_ADDRESSES.ADD_INFORMATION15%TYPE,
554: ADD_INFORMATION16 PER_ADDRESSES.ADD_INFORMATION16%TYPE,
555: ADD_INFORMATION17 PER_ADDRESSES.ADD_INFORMATION17%TYPE,
556: ADD_INFORMATION18 PER_ADDRESSES.ADD_INFORMATION18%TYPE,
557: ADD_INFORMATION19 PER_ADDRESSES.ADD_INFORMATION19%TYPE,
558: ADD_INFORMATION20 PER_ADDRESSES.ADD_INFORMATION20%TYPE,
559: PARTY_ID PER_ADDRESSES.PARTY_ID%TYPE,
560: DERIVED_LOCALE PER_ADDRESSES.DERIVED_LOCALE%TYPE,
553: ADD_INFORMATION15 PER_ADDRESSES.ADD_INFORMATION15%TYPE,
554: ADD_INFORMATION16 PER_ADDRESSES.ADD_INFORMATION16%TYPE,
555: ADD_INFORMATION17 PER_ADDRESSES.ADD_INFORMATION17%TYPE,
556: ADD_INFORMATION18 PER_ADDRESSES.ADD_INFORMATION18%TYPE,
557: ADD_INFORMATION19 PER_ADDRESSES.ADD_INFORMATION19%TYPE,
558: ADD_INFORMATION20 PER_ADDRESSES.ADD_INFORMATION20%TYPE,
559: PARTY_ID PER_ADDRESSES.PARTY_ID%TYPE,
560: DERIVED_LOCALE PER_ADDRESSES.DERIVED_LOCALE%TYPE,
561: GEOMETRY PER_ADDRESSES.GEOMETRY%TYPE,
554: ADD_INFORMATION16 PER_ADDRESSES.ADD_INFORMATION16%TYPE,
555: ADD_INFORMATION17 PER_ADDRESSES.ADD_INFORMATION17%TYPE,
556: ADD_INFORMATION18 PER_ADDRESSES.ADD_INFORMATION18%TYPE,
557: ADD_INFORMATION19 PER_ADDRESSES.ADD_INFORMATION19%TYPE,
558: ADD_INFORMATION20 PER_ADDRESSES.ADD_INFORMATION20%TYPE,
559: PARTY_ID PER_ADDRESSES.PARTY_ID%TYPE,
560: DERIVED_LOCALE PER_ADDRESSES.DERIVED_LOCALE%TYPE,
561: GEOMETRY PER_ADDRESSES.GEOMETRY%TYPE,
562: COMMENTS PER_ADDRESSES.COMMENTS%TYPE
555: ADD_INFORMATION17 PER_ADDRESSES.ADD_INFORMATION17%TYPE,
556: ADD_INFORMATION18 PER_ADDRESSES.ADD_INFORMATION18%TYPE,
557: ADD_INFORMATION19 PER_ADDRESSES.ADD_INFORMATION19%TYPE,
558: ADD_INFORMATION20 PER_ADDRESSES.ADD_INFORMATION20%TYPE,
559: PARTY_ID PER_ADDRESSES.PARTY_ID%TYPE,
560: DERIVED_LOCALE PER_ADDRESSES.DERIVED_LOCALE%TYPE,
561: GEOMETRY PER_ADDRESSES.GEOMETRY%TYPE,
562: COMMENTS PER_ADDRESSES.COMMENTS%TYPE
563:
556: ADD_INFORMATION18 PER_ADDRESSES.ADD_INFORMATION18%TYPE,
557: ADD_INFORMATION19 PER_ADDRESSES.ADD_INFORMATION19%TYPE,
558: ADD_INFORMATION20 PER_ADDRESSES.ADD_INFORMATION20%TYPE,
559: PARTY_ID PER_ADDRESSES.PARTY_ID%TYPE,
560: DERIVED_LOCALE PER_ADDRESSES.DERIVED_LOCALE%TYPE,
561: GEOMETRY PER_ADDRESSES.GEOMETRY%TYPE,
562: COMMENTS PER_ADDRESSES.COMMENTS%TYPE
563:
564: );
557: ADD_INFORMATION19 PER_ADDRESSES.ADD_INFORMATION19%TYPE,
558: ADD_INFORMATION20 PER_ADDRESSES.ADD_INFORMATION20%TYPE,
559: PARTY_ID PER_ADDRESSES.PARTY_ID%TYPE,
560: DERIVED_LOCALE PER_ADDRESSES.DERIVED_LOCALE%TYPE,
561: GEOMETRY PER_ADDRESSES.GEOMETRY%TYPE,
562: COMMENTS PER_ADDRESSES.COMMENTS%TYPE
563:
564: );
565: /*Record type for person extra information details*/
558: ADD_INFORMATION20 PER_ADDRESSES.ADD_INFORMATION20%TYPE,
559: PARTY_ID PER_ADDRESSES.PARTY_ID%TYPE,
560: DERIVED_LOCALE PER_ADDRESSES.DERIVED_LOCALE%TYPE,
561: GEOMETRY PER_ADDRESSES.GEOMETRY%TYPE,
562: COMMENTS PER_ADDRESSES.COMMENTS%TYPE
563:
564: );
565: /*Record type for person extra information details*/
566: TYPE PERSON_EXTRA_INFO_DETAILS IS RECORD