369:
370: /*Record type for contact details*/
371: TYPE contact_details IS RECORD
372: (
373: CONTACT_RELATIONSHIP_ID PER_CONTACT_RELATIONSHIPS.CONTACT_RELATIONSHIP_ID%TYPE,
374: CONTACT_PERSON_ID PER_CONTACT_RELATIONSHIPS.CONTACT_PERSON_ID%TYPE,
375: CONTACT_FULL_NAME PER_ALL_PEOPLE_F.FULL_NAME%TYPE,
376: CONTACT_TYPE PER_CONTACT_RELATIONSHIPS.CONTACT_TYPE%TYPE,
377: CONTACT_TYPE_DESC HR_LEG_LOOKUPS.MEANING%TYPE, -- 'CONTACT'
370: /*Record type for contact details*/
371: TYPE contact_details IS RECORD
372: (
373: CONTACT_RELATIONSHIP_ID PER_CONTACT_RELATIONSHIPS.CONTACT_RELATIONSHIP_ID%TYPE,
374: CONTACT_PERSON_ID PER_CONTACT_RELATIONSHIPS.CONTACT_PERSON_ID%TYPE,
375: CONTACT_FULL_NAME PER_ALL_PEOPLE_F.FULL_NAME%TYPE,
376: CONTACT_TYPE PER_CONTACT_RELATIONSHIPS.CONTACT_TYPE%TYPE,
377: CONTACT_TYPE_DESC HR_LEG_LOOKUPS.MEANING%TYPE, -- 'CONTACT'
378: PRIMARY_CONTACT_FLAG PER_CONTACT_RELATIONSHIPS.PRIMARY_CONTACT_FLAG%TYPE,
372: (
373: CONTACT_RELATIONSHIP_ID PER_CONTACT_RELATIONSHIPS.CONTACT_RELATIONSHIP_ID%TYPE,
374: CONTACT_PERSON_ID PER_CONTACT_RELATIONSHIPS.CONTACT_PERSON_ID%TYPE,
375: CONTACT_FULL_NAME PER_ALL_PEOPLE_F.FULL_NAME%TYPE,
376: CONTACT_TYPE PER_CONTACT_RELATIONSHIPS.CONTACT_TYPE%TYPE,
377: CONTACT_TYPE_DESC HR_LEG_LOOKUPS.MEANING%TYPE, -- 'CONTACT'
378: PRIMARY_CONTACT_FLAG PER_CONTACT_RELATIONSHIPS.PRIMARY_CONTACT_FLAG%TYPE,
379: DATE_START varchar2(10),
380: START_LIFE_REASON_ID PER_CONTACT_RELATIONSHIPS.START_LIFE_REASON_ID%TYPE,
374: CONTACT_PERSON_ID PER_CONTACT_RELATIONSHIPS.CONTACT_PERSON_ID%TYPE,
375: CONTACT_FULL_NAME PER_ALL_PEOPLE_F.FULL_NAME%TYPE,
376: CONTACT_TYPE PER_CONTACT_RELATIONSHIPS.CONTACT_TYPE%TYPE,
377: CONTACT_TYPE_DESC HR_LEG_LOOKUPS.MEANING%TYPE, -- 'CONTACT'
378: PRIMARY_CONTACT_FLAG PER_CONTACT_RELATIONSHIPS.PRIMARY_CONTACT_FLAG%TYPE,
379: DATE_START varchar2(10),
380: START_LIFE_REASON_ID PER_CONTACT_RELATIONSHIPS.START_LIFE_REASON_ID%TYPE,
381: DATE_END varchar2(10),
382: END_LIFE_REASON_ID PER_CONTACT_RELATIONSHIPS.END_LIFE_REASON_ID%TYPE,
376: CONTACT_TYPE PER_CONTACT_RELATIONSHIPS.CONTACT_TYPE%TYPE,
377: CONTACT_TYPE_DESC HR_LEG_LOOKUPS.MEANING%TYPE, -- 'CONTACT'
378: PRIMARY_CONTACT_FLAG PER_CONTACT_RELATIONSHIPS.PRIMARY_CONTACT_FLAG%TYPE,
379: DATE_START varchar2(10),
380: START_LIFE_REASON_ID PER_CONTACT_RELATIONSHIPS.START_LIFE_REASON_ID%TYPE,
381: DATE_END varchar2(10),
382: END_LIFE_REASON_ID PER_CONTACT_RELATIONSHIPS.END_LIFE_REASON_ID%TYPE,
383: RLTD_PER_RSDS_W_DSGNTR_FLAG PER_CONTACT_RELATIONSHIPS.RLTD_PER_RSDS_W_DSGNTR_FLAG%TYPE,
384: PERSONAL_FLAG PER_CONTACT_RELATIONSHIPS.PERSONAL_FLAG%TYPE,
378: PRIMARY_CONTACT_FLAG PER_CONTACT_RELATIONSHIPS.PRIMARY_CONTACT_FLAG%TYPE,
379: DATE_START varchar2(10),
380: START_LIFE_REASON_ID PER_CONTACT_RELATIONSHIPS.START_LIFE_REASON_ID%TYPE,
381: DATE_END varchar2(10),
382: END_LIFE_REASON_ID PER_CONTACT_RELATIONSHIPS.END_LIFE_REASON_ID%TYPE,
383: RLTD_PER_RSDS_W_DSGNTR_FLAG PER_CONTACT_RELATIONSHIPS.RLTD_PER_RSDS_W_DSGNTR_FLAG%TYPE,
384: PERSONAL_FLAG PER_CONTACT_RELATIONSHIPS.PERSONAL_FLAG%TYPE,
385: SEQUENCE_NUMBER PER_CONTACT_RELATIONSHIPS.SEQUENCE_NUMBER%TYPE,
386: CONT_ATTRIBUTE_CATEGORY PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE_CATEGORY%TYPE,
379: DATE_START varchar2(10),
380: START_LIFE_REASON_ID PER_CONTACT_RELATIONSHIPS.START_LIFE_REASON_ID%TYPE,
381: DATE_END varchar2(10),
382: END_LIFE_REASON_ID PER_CONTACT_RELATIONSHIPS.END_LIFE_REASON_ID%TYPE,
383: RLTD_PER_RSDS_W_DSGNTR_FLAG PER_CONTACT_RELATIONSHIPS.RLTD_PER_RSDS_W_DSGNTR_FLAG%TYPE,
384: PERSONAL_FLAG PER_CONTACT_RELATIONSHIPS.PERSONAL_FLAG%TYPE,
385: SEQUENCE_NUMBER PER_CONTACT_RELATIONSHIPS.SEQUENCE_NUMBER%TYPE,
386: CONT_ATTRIBUTE_CATEGORY PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE_CATEGORY%TYPE,
387: CONT_ATTRIBUTE1 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE1%TYPE,
380: START_LIFE_REASON_ID PER_CONTACT_RELATIONSHIPS.START_LIFE_REASON_ID%TYPE,
381: DATE_END varchar2(10),
382: END_LIFE_REASON_ID PER_CONTACT_RELATIONSHIPS.END_LIFE_REASON_ID%TYPE,
383: RLTD_PER_RSDS_W_DSGNTR_FLAG PER_CONTACT_RELATIONSHIPS.RLTD_PER_RSDS_W_DSGNTR_FLAG%TYPE,
384: PERSONAL_FLAG PER_CONTACT_RELATIONSHIPS.PERSONAL_FLAG%TYPE,
385: SEQUENCE_NUMBER PER_CONTACT_RELATIONSHIPS.SEQUENCE_NUMBER%TYPE,
386: CONT_ATTRIBUTE_CATEGORY PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE_CATEGORY%TYPE,
387: CONT_ATTRIBUTE1 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE1%TYPE,
388: CONT_ATTRIBUTE2 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE2%TYPE,
381: DATE_END varchar2(10),
382: END_LIFE_REASON_ID PER_CONTACT_RELATIONSHIPS.END_LIFE_REASON_ID%TYPE,
383: RLTD_PER_RSDS_W_DSGNTR_FLAG PER_CONTACT_RELATIONSHIPS.RLTD_PER_RSDS_W_DSGNTR_FLAG%TYPE,
384: PERSONAL_FLAG PER_CONTACT_RELATIONSHIPS.PERSONAL_FLAG%TYPE,
385: SEQUENCE_NUMBER PER_CONTACT_RELATIONSHIPS.SEQUENCE_NUMBER%TYPE,
386: CONT_ATTRIBUTE_CATEGORY PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE_CATEGORY%TYPE,
387: CONT_ATTRIBUTE1 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE1%TYPE,
388: CONT_ATTRIBUTE2 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE2%TYPE,
389: CONT_ATTRIBUTE3 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE3%TYPE,
382: END_LIFE_REASON_ID PER_CONTACT_RELATIONSHIPS.END_LIFE_REASON_ID%TYPE,
383: RLTD_PER_RSDS_W_DSGNTR_FLAG PER_CONTACT_RELATIONSHIPS.RLTD_PER_RSDS_W_DSGNTR_FLAG%TYPE,
384: PERSONAL_FLAG PER_CONTACT_RELATIONSHIPS.PERSONAL_FLAG%TYPE,
385: SEQUENCE_NUMBER PER_CONTACT_RELATIONSHIPS.SEQUENCE_NUMBER%TYPE,
386: CONT_ATTRIBUTE_CATEGORY PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE_CATEGORY%TYPE,
387: CONT_ATTRIBUTE1 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE1%TYPE,
388: CONT_ATTRIBUTE2 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE2%TYPE,
389: CONT_ATTRIBUTE3 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE3%TYPE,
390: CONT_ATTRIBUTE4 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE4%TYPE,
383: RLTD_PER_RSDS_W_DSGNTR_FLAG PER_CONTACT_RELATIONSHIPS.RLTD_PER_RSDS_W_DSGNTR_FLAG%TYPE,
384: PERSONAL_FLAG PER_CONTACT_RELATIONSHIPS.PERSONAL_FLAG%TYPE,
385: SEQUENCE_NUMBER PER_CONTACT_RELATIONSHIPS.SEQUENCE_NUMBER%TYPE,
386: CONT_ATTRIBUTE_CATEGORY PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE_CATEGORY%TYPE,
387: CONT_ATTRIBUTE1 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE1%TYPE,
388: CONT_ATTRIBUTE2 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE2%TYPE,
389: CONT_ATTRIBUTE3 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE3%TYPE,
390: CONT_ATTRIBUTE4 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE4%TYPE,
391: CONT_ATTRIBUTE5 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE5%TYPE,
384: PERSONAL_FLAG PER_CONTACT_RELATIONSHIPS.PERSONAL_FLAG%TYPE,
385: SEQUENCE_NUMBER PER_CONTACT_RELATIONSHIPS.SEQUENCE_NUMBER%TYPE,
386: CONT_ATTRIBUTE_CATEGORY PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE_CATEGORY%TYPE,
387: CONT_ATTRIBUTE1 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE1%TYPE,
388: CONT_ATTRIBUTE2 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE2%TYPE,
389: CONT_ATTRIBUTE3 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE3%TYPE,
390: CONT_ATTRIBUTE4 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE4%TYPE,
391: CONT_ATTRIBUTE5 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE5%TYPE,
392: CONT_ATTRIBUTE6 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE6%TYPE,
385: SEQUENCE_NUMBER PER_CONTACT_RELATIONSHIPS.SEQUENCE_NUMBER%TYPE,
386: CONT_ATTRIBUTE_CATEGORY PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE_CATEGORY%TYPE,
387: CONT_ATTRIBUTE1 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE1%TYPE,
388: CONT_ATTRIBUTE2 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE2%TYPE,
389: CONT_ATTRIBUTE3 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE3%TYPE,
390: CONT_ATTRIBUTE4 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE4%TYPE,
391: CONT_ATTRIBUTE5 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE5%TYPE,
392: CONT_ATTRIBUTE6 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE6%TYPE,
393: CONT_ATTRIBUTE7 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE7%TYPE,
386: CONT_ATTRIBUTE_CATEGORY PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE_CATEGORY%TYPE,
387: CONT_ATTRIBUTE1 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE1%TYPE,
388: CONT_ATTRIBUTE2 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE2%TYPE,
389: CONT_ATTRIBUTE3 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE3%TYPE,
390: CONT_ATTRIBUTE4 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE4%TYPE,
391: CONT_ATTRIBUTE5 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE5%TYPE,
392: CONT_ATTRIBUTE6 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE6%TYPE,
393: CONT_ATTRIBUTE7 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE7%TYPE,
394: CONT_ATTRIBUTE8 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE8%TYPE,
387: CONT_ATTRIBUTE1 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE1%TYPE,
388: CONT_ATTRIBUTE2 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE2%TYPE,
389: CONT_ATTRIBUTE3 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE3%TYPE,
390: CONT_ATTRIBUTE4 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE4%TYPE,
391: CONT_ATTRIBUTE5 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE5%TYPE,
392: CONT_ATTRIBUTE6 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE6%TYPE,
393: CONT_ATTRIBUTE7 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE7%TYPE,
394: CONT_ATTRIBUTE8 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE8%TYPE,
395: CONT_ATTRIBUTE9 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE9%TYPE,
388: CONT_ATTRIBUTE2 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE2%TYPE,
389: CONT_ATTRIBUTE3 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE3%TYPE,
390: CONT_ATTRIBUTE4 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE4%TYPE,
391: CONT_ATTRIBUTE5 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE5%TYPE,
392: CONT_ATTRIBUTE6 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE6%TYPE,
393: CONT_ATTRIBUTE7 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE7%TYPE,
394: CONT_ATTRIBUTE8 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE8%TYPE,
395: CONT_ATTRIBUTE9 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE9%TYPE,
396: CONT_ATTRIBUTE10 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE10%TYPE,
389: CONT_ATTRIBUTE3 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE3%TYPE,
390: CONT_ATTRIBUTE4 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE4%TYPE,
391: CONT_ATTRIBUTE5 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE5%TYPE,
392: CONT_ATTRIBUTE6 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE6%TYPE,
393: CONT_ATTRIBUTE7 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE7%TYPE,
394: CONT_ATTRIBUTE8 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE8%TYPE,
395: CONT_ATTRIBUTE9 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE9%TYPE,
396: CONT_ATTRIBUTE10 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE10%TYPE,
397: CONT_ATTRIBUTE11 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE11%TYPE,
390: CONT_ATTRIBUTE4 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE4%TYPE,
391: CONT_ATTRIBUTE5 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE5%TYPE,
392: CONT_ATTRIBUTE6 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE6%TYPE,
393: CONT_ATTRIBUTE7 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE7%TYPE,
394: CONT_ATTRIBUTE8 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE8%TYPE,
395: CONT_ATTRIBUTE9 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE9%TYPE,
396: CONT_ATTRIBUTE10 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE10%TYPE,
397: CONT_ATTRIBUTE11 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE11%TYPE,
398: CONT_ATTRIBUTE12 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE12%TYPE,
391: CONT_ATTRIBUTE5 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE5%TYPE,
392: CONT_ATTRIBUTE6 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE6%TYPE,
393: CONT_ATTRIBUTE7 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE7%TYPE,
394: CONT_ATTRIBUTE8 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE8%TYPE,
395: CONT_ATTRIBUTE9 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE9%TYPE,
396: CONT_ATTRIBUTE10 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE10%TYPE,
397: CONT_ATTRIBUTE11 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE11%TYPE,
398: CONT_ATTRIBUTE12 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE12%TYPE,
399: CONT_ATTRIBUTE13 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE13%TYPE,
392: CONT_ATTRIBUTE6 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE6%TYPE,
393: CONT_ATTRIBUTE7 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE7%TYPE,
394: CONT_ATTRIBUTE8 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE8%TYPE,
395: CONT_ATTRIBUTE9 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE9%TYPE,
396: CONT_ATTRIBUTE10 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE10%TYPE,
397: CONT_ATTRIBUTE11 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE11%TYPE,
398: CONT_ATTRIBUTE12 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE12%TYPE,
399: CONT_ATTRIBUTE13 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE13%TYPE,
400: CONT_ATTRIBUTE14 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE14%TYPE,
393: CONT_ATTRIBUTE7 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE7%TYPE,
394: CONT_ATTRIBUTE8 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE8%TYPE,
395: CONT_ATTRIBUTE9 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE9%TYPE,
396: CONT_ATTRIBUTE10 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE10%TYPE,
397: CONT_ATTRIBUTE11 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE11%TYPE,
398: CONT_ATTRIBUTE12 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE12%TYPE,
399: CONT_ATTRIBUTE13 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE13%TYPE,
400: CONT_ATTRIBUTE14 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE14%TYPE,
401: CONT_ATTRIBUTE15 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE15%TYPE,
394: CONT_ATTRIBUTE8 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE8%TYPE,
395: CONT_ATTRIBUTE9 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE9%TYPE,
396: CONT_ATTRIBUTE10 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE10%TYPE,
397: CONT_ATTRIBUTE11 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE11%TYPE,
398: CONT_ATTRIBUTE12 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE12%TYPE,
399: CONT_ATTRIBUTE13 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE13%TYPE,
400: CONT_ATTRIBUTE14 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE14%TYPE,
401: CONT_ATTRIBUTE15 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE15%TYPE,
402: CONT_ATTRIBUTE16 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE16%TYPE,
395: CONT_ATTRIBUTE9 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE9%TYPE,
396: CONT_ATTRIBUTE10 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE10%TYPE,
397: CONT_ATTRIBUTE11 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE11%TYPE,
398: CONT_ATTRIBUTE12 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE12%TYPE,
399: CONT_ATTRIBUTE13 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE13%TYPE,
400: CONT_ATTRIBUTE14 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE14%TYPE,
401: CONT_ATTRIBUTE15 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE15%TYPE,
402: CONT_ATTRIBUTE16 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE16%TYPE,
403: CONT_ATTRIBUTE17 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE17%TYPE,
396: CONT_ATTRIBUTE10 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE10%TYPE,
397: CONT_ATTRIBUTE11 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE11%TYPE,
398: CONT_ATTRIBUTE12 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE12%TYPE,
399: CONT_ATTRIBUTE13 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE13%TYPE,
400: CONT_ATTRIBUTE14 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE14%TYPE,
401: CONT_ATTRIBUTE15 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE15%TYPE,
402: CONT_ATTRIBUTE16 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE16%TYPE,
403: CONT_ATTRIBUTE17 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE17%TYPE,
404: CONT_ATTRIBUTE18 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE18%TYPE,
397: CONT_ATTRIBUTE11 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE11%TYPE,
398: CONT_ATTRIBUTE12 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE12%TYPE,
399: CONT_ATTRIBUTE13 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE13%TYPE,
400: CONT_ATTRIBUTE14 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE14%TYPE,
401: CONT_ATTRIBUTE15 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE15%TYPE,
402: CONT_ATTRIBUTE16 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE16%TYPE,
403: CONT_ATTRIBUTE17 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE17%TYPE,
404: CONT_ATTRIBUTE18 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE18%TYPE,
405: CONT_ATTRIBUTE19 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE19%TYPE,
398: CONT_ATTRIBUTE12 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE12%TYPE,
399: CONT_ATTRIBUTE13 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE13%TYPE,
400: CONT_ATTRIBUTE14 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE14%TYPE,
401: CONT_ATTRIBUTE15 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE15%TYPE,
402: CONT_ATTRIBUTE16 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE16%TYPE,
403: CONT_ATTRIBUTE17 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE17%TYPE,
404: CONT_ATTRIBUTE18 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE18%TYPE,
405: CONT_ATTRIBUTE19 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE19%TYPE,
406: CONT_ATTRIBUTE20 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE20%TYPE,
399: CONT_ATTRIBUTE13 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE13%TYPE,
400: CONT_ATTRIBUTE14 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE14%TYPE,
401: CONT_ATTRIBUTE15 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE15%TYPE,
402: CONT_ATTRIBUTE16 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE16%TYPE,
403: CONT_ATTRIBUTE17 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE17%TYPE,
404: CONT_ATTRIBUTE18 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE18%TYPE,
405: CONT_ATTRIBUTE19 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE19%TYPE,
406: CONT_ATTRIBUTE20 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE20%TYPE,
407: THIRD_PARTY_PAY_FLAG PER_CONTACT_RELATIONSHIPS.THIRD_PARTY_PAY_FLAG%TYPE,
400: CONT_ATTRIBUTE14 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE14%TYPE,
401: CONT_ATTRIBUTE15 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE15%TYPE,
402: CONT_ATTRIBUTE16 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE16%TYPE,
403: CONT_ATTRIBUTE17 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE17%TYPE,
404: CONT_ATTRIBUTE18 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE18%TYPE,
405: CONT_ATTRIBUTE19 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE19%TYPE,
406: CONT_ATTRIBUTE20 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE20%TYPE,
407: THIRD_PARTY_PAY_FLAG PER_CONTACT_RELATIONSHIPS.THIRD_PARTY_PAY_FLAG%TYPE,
408: BONDHOLDER_FLAG PER_CONTACT_RELATIONSHIPS.BONDHOLDER_FLAG%TYPE,
401: CONT_ATTRIBUTE15 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE15%TYPE,
402: CONT_ATTRIBUTE16 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE16%TYPE,
403: CONT_ATTRIBUTE17 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE17%TYPE,
404: CONT_ATTRIBUTE18 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE18%TYPE,
405: CONT_ATTRIBUTE19 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE19%TYPE,
406: CONT_ATTRIBUTE20 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE20%TYPE,
407: THIRD_PARTY_PAY_FLAG PER_CONTACT_RELATIONSHIPS.THIRD_PARTY_PAY_FLAG%TYPE,
408: BONDHOLDER_FLAG PER_CONTACT_RELATIONSHIPS.BONDHOLDER_FLAG%TYPE,
409: DEPENDENT_FLAG PER_CONTACT_RELATIONSHIPS.DEPENDENT_FLAG%TYPE,
402: CONT_ATTRIBUTE16 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE16%TYPE,
403: CONT_ATTRIBUTE17 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE17%TYPE,
404: CONT_ATTRIBUTE18 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE18%TYPE,
405: CONT_ATTRIBUTE19 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE19%TYPE,
406: CONT_ATTRIBUTE20 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE20%TYPE,
407: THIRD_PARTY_PAY_FLAG PER_CONTACT_RELATIONSHIPS.THIRD_PARTY_PAY_FLAG%TYPE,
408: BONDHOLDER_FLAG PER_CONTACT_RELATIONSHIPS.BONDHOLDER_FLAG%TYPE,
409: DEPENDENT_FLAG PER_CONTACT_RELATIONSHIPS.DEPENDENT_FLAG%TYPE,
410: BENEFICIARY_FLAG PER_CONTACT_RELATIONSHIPS.BENEFICIARY_FLAG%TYPE,
403: CONT_ATTRIBUTE17 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE17%TYPE,
404: CONT_ATTRIBUTE18 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE18%TYPE,
405: CONT_ATTRIBUTE19 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE19%TYPE,
406: CONT_ATTRIBUTE20 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE20%TYPE,
407: THIRD_PARTY_PAY_FLAG PER_CONTACT_RELATIONSHIPS.THIRD_PARTY_PAY_FLAG%TYPE,
408: BONDHOLDER_FLAG PER_CONTACT_RELATIONSHIPS.BONDHOLDER_FLAG%TYPE,
409: DEPENDENT_FLAG PER_CONTACT_RELATIONSHIPS.DEPENDENT_FLAG%TYPE,
410: BENEFICIARY_FLAG PER_CONTACT_RELATIONSHIPS.BENEFICIARY_FLAG%TYPE,
411: PARTY_ID PER_CONTACT_RELATIONSHIPS.PARTY_ID%TYPE,
404: CONT_ATTRIBUTE18 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE18%TYPE,
405: CONT_ATTRIBUTE19 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE19%TYPE,
406: CONT_ATTRIBUTE20 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE20%TYPE,
407: THIRD_PARTY_PAY_FLAG PER_CONTACT_RELATIONSHIPS.THIRD_PARTY_PAY_FLAG%TYPE,
408: BONDHOLDER_FLAG PER_CONTACT_RELATIONSHIPS.BONDHOLDER_FLAG%TYPE,
409: DEPENDENT_FLAG PER_CONTACT_RELATIONSHIPS.DEPENDENT_FLAG%TYPE,
410: BENEFICIARY_FLAG PER_CONTACT_RELATIONSHIPS.BENEFICIARY_FLAG%TYPE,
411: PARTY_ID PER_CONTACT_RELATIONSHIPS.PARTY_ID%TYPE,
412: CONT_INFORMATION_CATEGORY PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION_CATEGORY%TYPE,
405: CONT_ATTRIBUTE19 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE19%TYPE,
406: CONT_ATTRIBUTE20 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE20%TYPE,
407: THIRD_PARTY_PAY_FLAG PER_CONTACT_RELATIONSHIPS.THIRD_PARTY_PAY_FLAG%TYPE,
408: BONDHOLDER_FLAG PER_CONTACT_RELATIONSHIPS.BONDHOLDER_FLAG%TYPE,
409: DEPENDENT_FLAG PER_CONTACT_RELATIONSHIPS.DEPENDENT_FLAG%TYPE,
410: BENEFICIARY_FLAG PER_CONTACT_RELATIONSHIPS.BENEFICIARY_FLAG%TYPE,
411: PARTY_ID PER_CONTACT_RELATIONSHIPS.PARTY_ID%TYPE,
412: CONT_INFORMATION_CATEGORY PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION_CATEGORY%TYPE,
413: CONT_INFORMATION1 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION1%TYPE,
406: CONT_ATTRIBUTE20 PER_CONTACT_RELATIONSHIPS.CONT_ATTRIBUTE20%TYPE,
407: THIRD_PARTY_PAY_FLAG PER_CONTACT_RELATIONSHIPS.THIRD_PARTY_PAY_FLAG%TYPE,
408: BONDHOLDER_FLAG PER_CONTACT_RELATIONSHIPS.BONDHOLDER_FLAG%TYPE,
409: DEPENDENT_FLAG PER_CONTACT_RELATIONSHIPS.DEPENDENT_FLAG%TYPE,
410: BENEFICIARY_FLAG PER_CONTACT_RELATIONSHIPS.BENEFICIARY_FLAG%TYPE,
411: PARTY_ID PER_CONTACT_RELATIONSHIPS.PARTY_ID%TYPE,
412: CONT_INFORMATION_CATEGORY PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION_CATEGORY%TYPE,
413: CONT_INFORMATION1 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION1%TYPE,
414: CONT_INFORMATION2 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION2%TYPE,
407: THIRD_PARTY_PAY_FLAG PER_CONTACT_RELATIONSHIPS.THIRD_PARTY_PAY_FLAG%TYPE,
408: BONDHOLDER_FLAG PER_CONTACT_RELATIONSHIPS.BONDHOLDER_FLAG%TYPE,
409: DEPENDENT_FLAG PER_CONTACT_RELATIONSHIPS.DEPENDENT_FLAG%TYPE,
410: BENEFICIARY_FLAG PER_CONTACT_RELATIONSHIPS.BENEFICIARY_FLAG%TYPE,
411: PARTY_ID PER_CONTACT_RELATIONSHIPS.PARTY_ID%TYPE,
412: CONT_INFORMATION_CATEGORY PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION_CATEGORY%TYPE,
413: CONT_INFORMATION1 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION1%TYPE,
414: CONT_INFORMATION2 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION2%TYPE,
415: CONT_INFORMATION3 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION3%TYPE,
408: BONDHOLDER_FLAG PER_CONTACT_RELATIONSHIPS.BONDHOLDER_FLAG%TYPE,
409: DEPENDENT_FLAG PER_CONTACT_RELATIONSHIPS.DEPENDENT_FLAG%TYPE,
410: BENEFICIARY_FLAG PER_CONTACT_RELATIONSHIPS.BENEFICIARY_FLAG%TYPE,
411: PARTY_ID PER_CONTACT_RELATIONSHIPS.PARTY_ID%TYPE,
412: CONT_INFORMATION_CATEGORY PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION_CATEGORY%TYPE,
413: CONT_INFORMATION1 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION1%TYPE,
414: CONT_INFORMATION2 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION2%TYPE,
415: CONT_INFORMATION3 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION3%TYPE,
416: CONT_INFORMATION4 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION4%TYPE,
409: DEPENDENT_FLAG PER_CONTACT_RELATIONSHIPS.DEPENDENT_FLAG%TYPE,
410: BENEFICIARY_FLAG PER_CONTACT_RELATIONSHIPS.BENEFICIARY_FLAG%TYPE,
411: PARTY_ID PER_CONTACT_RELATIONSHIPS.PARTY_ID%TYPE,
412: CONT_INFORMATION_CATEGORY PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION_CATEGORY%TYPE,
413: CONT_INFORMATION1 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION1%TYPE,
414: CONT_INFORMATION2 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION2%TYPE,
415: CONT_INFORMATION3 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION3%TYPE,
416: CONT_INFORMATION4 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION4%TYPE,
417: CONT_INFORMATION5 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION5%TYPE,
410: BENEFICIARY_FLAG PER_CONTACT_RELATIONSHIPS.BENEFICIARY_FLAG%TYPE,
411: PARTY_ID PER_CONTACT_RELATIONSHIPS.PARTY_ID%TYPE,
412: CONT_INFORMATION_CATEGORY PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION_CATEGORY%TYPE,
413: CONT_INFORMATION1 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION1%TYPE,
414: CONT_INFORMATION2 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION2%TYPE,
415: CONT_INFORMATION3 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION3%TYPE,
416: CONT_INFORMATION4 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION4%TYPE,
417: CONT_INFORMATION5 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION5%TYPE,
418: CONT_INFORMATION6 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION6%TYPE,
411: PARTY_ID PER_CONTACT_RELATIONSHIPS.PARTY_ID%TYPE,
412: CONT_INFORMATION_CATEGORY PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION_CATEGORY%TYPE,
413: CONT_INFORMATION1 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION1%TYPE,
414: CONT_INFORMATION2 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION2%TYPE,
415: CONT_INFORMATION3 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION3%TYPE,
416: CONT_INFORMATION4 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION4%TYPE,
417: CONT_INFORMATION5 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION5%TYPE,
418: CONT_INFORMATION6 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION6%TYPE,
419: CONT_INFORMATION7 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION7%TYPE,
412: CONT_INFORMATION_CATEGORY PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION_CATEGORY%TYPE,
413: CONT_INFORMATION1 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION1%TYPE,
414: CONT_INFORMATION2 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION2%TYPE,
415: CONT_INFORMATION3 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION3%TYPE,
416: CONT_INFORMATION4 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION4%TYPE,
417: CONT_INFORMATION5 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION5%TYPE,
418: CONT_INFORMATION6 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION6%TYPE,
419: CONT_INFORMATION7 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION7%TYPE,
420: CONT_INFORMATION8 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION8%TYPE,
413: CONT_INFORMATION1 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION1%TYPE,
414: CONT_INFORMATION2 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION2%TYPE,
415: CONT_INFORMATION3 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION3%TYPE,
416: CONT_INFORMATION4 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION4%TYPE,
417: CONT_INFORMATION5 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION5%TYPE,
418: CONT_INFORMATION6 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION6%TYPE,
419: CONT_INFORMATION7 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION7%TYPE,
420: CONT_INFORMATION8 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION8%TYPE,
421: CONT_INFORMATION9 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION9%TYPE,
414: CONT_INFORMATION2 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION2%TYPE,
415: CONT_INFORMATION3 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION3%TYPE,
416: CONT_INFORMATION4 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION4%TYPE,
417: CONT_INFORMATION5 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION5%TYPE,
418: CONT_INFORMATION6 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION6%TYPE,
419: CONT_INFORMATION7 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION7%TYPE,
420: CONT_INFORMATION8 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION8%TYPE,
421: CONT_INFORMATION9 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION9%TYPE,
422: CONT_INFORMATION10 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION10%TYPE,
415: CONT_INFORMATION3 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION3%TYPE,
416: CONT_INFORMATION4 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION4%TYPE,
417: CONT_INFORMATION5 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION5%TYPE,
418: CONT_INFORMATION6 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION6%TYPE,
419: CONT_INFORMATION7 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION7%TYPE,
420: CONT_INFORMATION8 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION8%TYPE,
421: CONT_INFORMATION9 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION9%TYPE,
422: CONT_INFORMATION10 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION10%TYPE,
423: CONT_INFORMATION11 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION11%TYPE,
416: CONT_INFORMATION4 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION4%TYPE,
417: CONT_INFORMATION5 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION5%TYPE,
418: CONT_INFORMATION6 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION6%TYPE,
419: CONT_INFORMATION7 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION7%TYPE,
420: CONT_INFORMATION8 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION8%TYPE,
421: CONT_INFORMATION9 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION9%TYPE,
422: CONT_INFORMATION10 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION10%TYPE,
423: CONT_INFORMATION11 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION11%TYPE,
424: CONT_INFORMATION12 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION12%TYPE,
417: CONT_INFORMATION5 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION5%TYPE,
418: CONT_INFORMATION6 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION6%TYPE,
419: CONT_INFORMATION7 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION7%TYPE,
420: CONT_INFORMATION8 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION8%TYPE,
421: CONT_INFORMATION9 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION9%TYPE,
422: CONT_INFORMATION10 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION10%TYPE,
423: CONT_INFORMATION11 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION11%TYPE,
424: CONT_INFORMATION12 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION12%TYPE,
425: CONT_INFORMATION13 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION13%TYPE,
418: CONT_INFORMATION6 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION6%TYPE,
419: CONT_INFORMATION7 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION7%TYPE,
420: CONT_INFORMATION8 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION8%TYPE,
421: CONT_INFORMATION9 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION9%TYPE,
422: CONT_INFORMATION10 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION10%TYPE,
423: CONT_INFORMATION11 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION11%TYPE,
424: CONT_INFORMATION12 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION12%TYPE,
425: CONT_INFORMATION13 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION13%TYPE,
426: CONT_INFORMATION14 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION14%TYPE,
419: CONT_INFORMATION7 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION7%TYPE,
420: CONT_INFORMATION8 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION8%TYPE,
421: CONT_INFORMATION9 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION9%TYPE,
422: CONT_INFORMATION10 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION10%TYPE,
423: CONT_INFORMATION11 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION11%TYPE,
424: CONT_INFORMATION12 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION12%TYPE,
425: CONT_INFORMATION13 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION13%TYPE,
426: CONT_INFORMATION14 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION14%TYPE,
427: CONT_INFORMATION15 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION15%TYPE,
420: CONT_INFORMATION8 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION8%TYPE,
421: CONT_INFORMATION9 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION9%TYPE,
422: CONT_INFORMATION10 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION10%TYPE,
423: CONT_INFORMATION11 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION11%TYPE,
424: CONT_INFORMATION12 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION12%TYPE,
425: CONT_INFORMATION13 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION13%TYPE,
426: CONT_INFORMATION14 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION14%TYPE,
427: CONT_INFORMATION15 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION15%TYPE,
428: CONT_INFORMATION16 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION16%TYPE,
421: CONT_INFORMATION9 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION9%TYPE,
422: CONT_INFORMATION10 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION10%TYPE,
423: CONT_INFORMATION11 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION11%TYPE,
424: CONT_INFORMATION12 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION12%TYPE,
425: CONT_INFORMATION13 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION13%TYPE,
426: CONT_INFORMATION14 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION14%TYPE,
427: CONT_INFORMATION15 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION15%TYPE,
428: CONT_INFORMATION16 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION16%TYPE,
429: CONT_INFORMATION17 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION17%TYPE,
422: CONT_INFORMATION10 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION10%TYPE,
423: CONT_INFORMATION11 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION11%TYPE,
424: CONT_INFORMATION12 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION12%TYPE,
425: CONT_INFORMATION13 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION13%TYPE,
426: CONT_INFORMATION14 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION14%TYPE,
427: CONT_INFORMATION15 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION15%TYPE,
428: CONT_INFORMATION16 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION16%TYPE,
429: CONT_INFORMATION17 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION17%TYPE,
430: CONT_INFORMATION18 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION18%TYPE,
423: CONT_INFORMATION11 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION11%TYPE,
424: CONT_INFORMATION12 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION12%TYPE,
425: CONT_INFORMATION13 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION13%TYPE,
426: CONT_INFORMATION14 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION14%TYPE,
427: CONT_INFORMATION15 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION15%TYPE,
428: CONT_INFORMATION16 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION16%TYPE,
429: CONT_INFORMATION17 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION17%TYPE,
430: CONT_INFORMATION18 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION18%TYPE,
431: CONT_INFORMATION19 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION19%TYPE,
424: CONT_INFORMATION12 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION12%TYPE,
425: CONT_INFORMATION13 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION13%TYPE,
426: CONT_INFORMATION14 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION14%TYPE,
427: CONT_INFORMATION15 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION15%TYPE,
428: CONT_INFORMATION16 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION16%TYPE,
429: CONT_INFORMATION17 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION17%TYPE,
430: CONT_INFORMATION18 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION18%TYPE,
431: CONT_INFORMATION19 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION19%TYPE,
432: CONT_INFORMATION20 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION20%TYPE
425: CONT_INFORMATION13 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION13%TYPE,
426: CONT_INFORMATION14 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION14%TYPE,
427: CONT_INFORMATION15 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION15%TYPE,
428: CONT_INFORMATION16 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION16%TYPE,
429: CONT_INFORMATION17 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION17%TYPE,
430: CONT_INFORMATION18 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION18%TYPE,
431: CONT_INFORMATION19 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION19%TYPE,
432: CONT_INFORMATION20 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION20%TYPE
433: );
426: CONT_INFORMATION14 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION14%TYPE,
427: CONT_INFORMATION15 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION15%TYPE,
428: CONT_INFORMATION16 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION16%TYPE,
429: CONT_INFORMATION17 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION17%TYPE,
430: CONT_INFORMATION18 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION18%TYPE,
431: CONT_INFORMATION19 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION19%TYPE,
432: CONT_INFORMATION20 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION20%TYPE
433: );
434:
427: CONT_INFORMATION15 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION15%TYPE,
428: CONT_INFORMATION16 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION16%TYPE,
429: CONT_INFORMATION17 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION17%TYPE,
430: CONT_INFORMATION18 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION18%TYPE,
431: CONT_INFORMATION19 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION19%TYPE,
432: CONT_INFORMATION20 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION20%TYPE
433: );
434:
435: /*Record type for contact address details*/
428: CONT_INFORMATION16 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION16%TYPE,
429: CONT_INFORMATION17 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION17%TYPE,
430: CONT_INFORMATION18 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION18%TYPE,
431: CONT_INFORMATION19 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION19%TYPE,
432: CONT_INFORMATION20 PER_CONTACT_RELATIONSHIPS.CONT_INFORMATION20%TYPE
433: );
434:
435: /*Record type for contact address details*/
436: TYPE CONTACT_ADDRESS_DETAILS is RECORD
434:
435: /*Record type for contact address details*/
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,
435: /*Record type for contact address details*/
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,