25: p_employee_category hr_lookups.meaning%type default null,
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;
906: PERIOD_MONTHS PER_PREVIOUS_EMPLOYERS.PERIOD_MONTHS%TYPE
907: );
908:
909: TYPE DELIV_METHOD_INFO is RECORD
910: (DELIVERY_METHOD_ID PER_PERSON_DLVRY_METHODS.DELIVERY_METHOD_ID%TYPE,
911: DATE_START varchar2(10),
912: DATE_END varchar2(10),
913: COMM_DLVRY_METHOD PER_PERSON_DLVRY_METHODS.COMM_DLVRY_METHOD%TYPE,
914: COMM_DLVRY_METHOD_DESC HR_LOOKUPS.MEANING%TYPE,
909: TYPE DELIV_METHOD_INFO is RECORD
910: (DELIVERY_METHOD_ID PER_PERSON_DLVRY_METHODS.DELIVERY_METHOD_ID%TYPE,
911: DATE_START varchar2(10),
912: DATE_END varchar2(10),
913: COMM_DLVRY_METHOD PER_PERSON_DLVRY_METHODS.COMM_DLVRY_METHOD%TYPE,
914: COMM_DLVRY_METHOD_DESC HR_LOOKUPS.MEANING%TYPE,
915: PREFERRED_FLAG PER_PERSON_DLVRY_METHODS.PREFERRED_FLAG%TYPE,
916: ATTRIBUTE_CATEGORY PER_PERSON_DLVRY_METHODS.ATTRIBUTE_CATEGORY%TYPE,
917: ATTRIBUTE1 PER_PERSON_DLVRY_METHODS.ATTRIBUTE1%TYPE,
911: DATE_START varchar2(10),
912: DATE_END varchar2(10),
913: COMM_DLVRY_METHOD PER_PERSON_DLVRY_METHODS.COMM_DLVRY_METHOD%TYPE,
914: COMM_DLVRY_METHOD_DESC HR_LOOKUPS.MEANING%TYPE,
915: PREFERRED_FLAG PER_PERSON_DLVRY_METHODS.PREFERRED_FLAG%TYPE,
916: ATTRIBUTE_CATEGORY PER_PERSON_DLVRY_METHODS.ATTRIBUTE_CATEGORY%TYPE,
917: ATTRIBUTE1 PER_PERSON_DLVRY_METHODS.ATTRIBUTE1%TYPE,
918: ATTRIBUTE2 PER_PERSON_DLVRY_METHODS.ATTRIBUTE2%TYPE,
919: ATTRIBUTE3 PER_PERSON_DLVRY_METHODS.ATTRIBUTE3%TYPE,
912: DATE_END varchar2(10),
913: COMM_DLVRY_METHOD PER_PERSON_DLVRY_METHODS.COMM_DLVRY_METHOD%TYPE,
914: COMM_DLVRY_METHOD_DESC HR_LOOKUPS.MEANING%TYPE,
915: PREFERRED_FLAG PER_PERSON_DLVRY_METHODS.PREFERRED_FLAG%TYPE,
916: ATTRIBUTE_CATEGORY PER_PERSON_DLVRY_METHODS.ATTRIBUTE_CATEGORY%TYPE,
917: ATTRIBUTE1 PER_PERSON_DLVRY_METHODS.ATTRIBUTE1%TYPE,
918: ATTRIBUTE2 PER_PERSON_DLVRY_METHODS.ATTRIBUTE2%TYPE,
919: ATTRIBUTE3 PER_PERSON_DLVRY_METHODS.ATTRIBUTE3%TYPE,
920: ATTRIBUTE4 PER_PERSON_DLVRY_METHODS.ATTRIBUTE4%TYPE,
913: COMM_DLVRY_METHOD PER_PERSON_DLVRY_METHODS.COMM_DLVRY_METHOD%TYPE,
914: COMM_DLVRY_METHOD_DESC HR_LOOKUPS.MEANING%TYPE,
915: PREFERRED_FLAG PER_PERSON_DLVRY_METHODS.PREFERRED_FLAG%TYPE,
916: ATTRIBUTE_CATEGORY PER_PERSON_DLVRY_METHODS.ATTRIBUTE_CATEGORY%TYPE,
917: ATTRIBUTE1 PER_PERSON_DLVRY_METHODS.ATTRIBUTE1%TYPE,
918: ATTRIBUTE2 PER_PERSON_DLVRY_METHODS.ATTRIBUTE2%TYPE,
919: ATTRIBUTE3 PER_PERSON_DLVRY_METHODS.ATTRIBUTE3%TYPE,
920: ATTRIBUTE4 PER_PERSON_DLVRY_METHODS.ATTRIBUTE4%TYPE,
921: ATTRIBUTE5 PER_PERSON_DLVRY_METHODS.ATTRIBUTE5%TYPE,
914: COMM_DLVRY_METHOD_DESC HR_LOOKUPS.MEANING%TYPE,
915: PREFERRED_FLAG PER_PERSON_DLVRY_METHODS.PREFERRED_FLAG%TYPE,
916: ATTRIBUTE_CATEGORY PER_PERSON_DLVRY_METHODS.ATTRIBUTE_CATEGORY%TYPE,
917: ATTRIBUTE1 PER_PERSON_DLVRY_METHODS.ATTRIBUTE1%TYPE,
918: ATTRIBUTE2 PER_PERSON_DLVRY_METHODS.ATTRIBUTE2%TYPE,
919: ATTRIBUTE3 PER_PERSON_DLVRY_METHODS.ATTRIBUTE3%TYPE,
920: ATTRIBUTE4 PER_PERSON_DLVRY_METHODS.ATTRIBUTE4%TYPE,
921: ATTRIBUTE5 PER_PERSON_DLVRY_METHODS.ATTRIBUTE5%TYPE,
922: ATTRIBUTE6 PER_PERSON_DLVRY_METHODS.ATTRIBUTE6%TYPE,
915: PREFERRED_FLAG PER_PERSON_DLVRY_METHODS.PREFERRED_FLAG%TYPE,
916: ATTRIBUTE_CATEGORY PER_PERSON_DLVRY_METHODS.ATTRIBUTE_CATEGORY%TYPE,
917: ATTRIBUTE1 PER_PERSON_DLVRY_METHODS.ATTRIBUTE1%TYPE,
918: ATTRIBUTE2 PER_PERSON_DLVRY_METHODS.ATTRIBUTE2%TYPE,
919: ATTRIBUTE3 PER_PERSON_DLVRY_METHODS.ATTRIBUTE3%TYPE,
920: ATTRIBUTE4 PER_PERSON_DLVRY_METHODS.ATTRIBUTE4%TYPE,
921: ATTRIBUTE5 PER_PERSON_DLVRY_METHODS.ATTRIBUTE5%TYPE,
922: ATTRIBUTE6 PER_PERSON_DLVRY_METHODS.ATTRIBUTE6%TYPE,
923: ATTRIBUTE7 PER_PERSON_DLVRY_METHODS.ATTRIBUTE7%TYPE,
916: ATTRIBUTE_CATEGORY PER_PERSON_DLVRY_METHODS.ATTRIBUTE_CATEGORY%TYPE,
917: ATTRIBUTE1 PER_PERSON_DLVRY_METHODS.ATTRIBUTE1%TYPE,
918: ATTRIBUTE2 PER_PERSON_DLVRY_METHODS.ATTRIBUTE2%TYPE,
919: ATTRIBUTE3 PER_PERSON_DLVRY_METHODS.ATTRIBUTE3%TYPE,
920: ATTRIBUTE4 PER_PERSON_DLVRY_METHODS.ATTRIBUTE4%TYPE,
921: ATTRIBUTE5 PER_PERSON_DLVRY_METHODS.ATTRIBUTE5%TYPE,
922: ATTRIBUTE6 PER_PERSON_DLVRY_METHODS.ATTRIBUTE6%TYPE,
923: ATTRIBUTE7 PER_PERSON_DLVRY_METHODS.ATTRIBUTE7%TYPE,
924: ATTRIBUTE8 PER_PERSON_DLVRY_METHODS.ATTRIBUTE8%TYPE,
917: ATTRIBUTE1 PER_PERSON_DLVRY_METHODS.ATTRIBUTE1%TYPE,
918: ATTRIBUTE2 PER_PERSON_DLVRY_METHODS.ATTRIBUTE2%TYPE,
919: ATTRIBUTE3 PER_PERSON_DLVRY_METHODS.ATTRIBUTE3%TYPE,
920: ATTRIBUTE4 PER_PERSON_DLVRY_METHODS.ATTRIBUTE4%TYPE,
921: ATTRIBUTE5 PER_PERSON_DLVRY_METHODS.ATTRIBUTE5%TYPE,
922: ATTRIBUTE6 PER_PERSON_DLVRY_METHODS.ATTRIBUTE6%TYPE,
923: ATTRIBUTE7 PER_PERSON_DLVRY_METHODS.ATTRIBUTE7%TYPE,
924: ATTRIBUTE8 PER_PERSON_DLVRY_METHODS.ATTRIBUTE8%TYPE,
925: ATTRIBUTE9 PER_PERSON_DLVRY_METHODS.ATTRIBUTE9%TYPE,
918: ATTRIBUTE2 PER_PERSON_DLVRY_METHODS.ATTRIBUTE2%TYPE,
919: ATTRIBUTE3 PER_PERSON_DLVRY_METHODS.ATTRIBUTE3%TYPE,
920: ATTRIBUTE4 PER_PERSON_DLVRY_METHODS.ATTRIBUTE4%TYPE,
921: ATTRIBUTE5 PER_PERSON_DLVRY_METHODS.ATTRIBUTE5%TYPE,
922: ATTRIBUTE6 PER_PERSON_DLVRY_METHODS.ATTRIBUTE6%TYPE,
923: ATTRIBUTE7 PER_PERSON_DLVRY_METHODS.ATTRIBUTE7%TYPE,
924: ATTRIBUTE8 PER_PERSON_DLVRY_METHODS.ATTRIBUTE8%TYPE,
925: ATTRIBUTE9 PER_PERSON_DLVRY_METHODS.ATTRIBUTE9%TYPE,
926: ATTRIBUTE10 PER_PERSON_DLVRY_METHODS.ATTRIBUTE10%TYPE,
919: ATTRIBUTE3 PER_PERSON_DLVRY_METHODS.ATTRIBUTE3%TYPE,
920: ATTRIBUTE4 PER_PERSON_DLVRY_METHODS.ATTRIBUTE4%TYPE,
921: ATTRIBUTE5 PER_PERSON_DLVRY_METHODS.ATTRIBUTE5%TYPE,
922: ATTRIBUTE6 PER_PERSON_DLVRY_METHODS.ATTRIBUTE6%TYPE,
923: ATTRIBUTE7 PER_PERSON_DLVRY_METHODS.ATTRIBUTE7%TYPE,
924: ATTRIBUTE8 PER_PERSON_DLVRY_METHODS.ATTRIBUTE8%TYPE,
925: ATTRIBUTE9 PER_PERSON_DLVRY_METHODS.ATTRIBUTE9%TYPE,
926: ATTRIBUTE10 PER_PERSON_DLVRY_METHODS.ATTRIBUTE10%TYPE,
927: ATTRIBUTE11 PER_PERSON_DLVRY_METHODS.ATTRIBUTE11%TYPE,
920: ATTRIBUTE4 PER_PERSON_DLVRY_METHODS.ATTRIBUTE4%TYPE,
921: ATTRIBUTE5 PER_PERSON_DLVRY_METHODS.ATTRIBUTE5%TYPE,
922: ATTRIBUTE6 PER_PERSON_DLVRY_METHODS.ATTRIBUTE6%TYPE,
923: ATTRIBUTE7 PER_PERSON_DLVRY_METHODS.ATTRIBUTE7%TYPE,
924: ATTRIBUTE8 PER_PERSON_DLVRY_METHODS.ATTRIBUTE8%TYPE,
925: ATTRIBUTE9 PER_PERSON_DLVRY_METHODS.ATTRIBUTE9%TYPE,
926: ATTRIBUTE10 PER_PERSON_DLVRY_METHODS.ATTRIBUTE10%TYPE,
927: ATTRIBUTE11 PER_PERSON_DLVRY_METHODS.ATTRIBUTE11%TYPE,
928: ATTRIBUTE12 PER_PERSON_DLVRY_METHODS.ATTRIBUTE12%TYPE,
921: ATTRIBUTE5 PER_PERSON_DLVRY_METHODS.ATTRIBUTE5%TYPE,
922: ATTRIBUTE6 PER_PERSON_DLVRY_METHODS.ATTRIBUTE6%TYPE,
923: ATTRIBUTE7 PER_PERSON_DLVRY_METHODS.ATTRIBUTE7%TYPE,
924: ATTRIBUTE8 PER_PERSON_DLVRY_METHODS.ATTRIBUTE8%TYPE,
925: ATTRIBUTE9 PER_PERSON_DLVRY_METHODS.ATTRIBUTE9%TYPE,
926: ATTRIBUTE10 PER_PERSON_DLVRY_METHODS.ATTRIBUTE10%TYPE,
927: ATTRIBUTE11 PER_PERSON_DLVRY_METHODS.ATTRIBUTE11%TYPE,
928: ATTRIBUTE12 PER_PERSON_DLVRY_METHODS.ATTRIBUTE12%TYPE,
929: ATTRIBUTE13 PER_PERSON_DLVRY_METHODS.ATTRIBUTE13%TYPE,
922: ATTRIBUTE6 PER_PERSON_DLVRY_METHODS.ATTRIBUTE6%TYPE,
923: ATTRIBUTE7 PER_PERSON_DLVRY_METHODS.ATTRIBUTE7%TYPE,
924: ATTRIBUTE8 PER_PERSON_DLVRY_METHODS.ATTRIBUTE8%TYPE,
925: ATTRIBUTE9 PER_PERSON_DLVRY_METHODS.ATTRIBUTE9%TYPE,
926: ATTRIBUTE10 PER_PERSON_DLVRY_METHODS.ATTRIBUTE10%TYPE,
927: ATTRIBUTE11 PER_PERSON_DLVRY_METHODS.ATTRIBUTE11%TYPE,
928: ATTRIBUTE12 PER_PERSON_DLVRY_METHODS.ATTRIBUTE12%TYPE,
929: ATTRIBUTE13 PER_PERSON_DLVRY_METHODS.ATTRIBUTE13%TYPE,
930: ATTRIBUTE14 PER_PERSON_DLVRY_METHODS.ATTRIBUTE14%TYPE,
923: ATTRIBUTE7 PER_PERSON_DLVRY_METHODS.ATTRIBUTE7%TYPE,
924: ATTRIBUTE8 PER_PERSON_DLVRY_METHODS.ATTRIBUTE8%TYPE,
925: ATTRIBUTE9 PER_PERSON_DLVRY_METHODS.ATTRIBUTE9%TYPE,
926: ATTRIBUTE10 PER_PERSON_DLVRY_METHODS.ATTRIBUTE10%TYPE,
927: ATTRIBUTE11 PER_PERSON_DLVRY_METHODS.ATTRIBUTE11%TYPE,
928: ATTRIBUTE12 PER_PERSON_DLVRY_METHODS.ATTRIBUTE12%TYPE,
929: ATTRIBUTE13 PER_PERSON_DLVRY_METHODS.ATTRIBUTE13%TYPE,
930: ATTRIBUTE14 PER_PERSON_DLVRY_METHODS.ATTRIBUTE14%TYPE,
931: ATTRIBUTE15 PER_PERSON_DLVRY_METHODS.ATTRIBUTE15%TYPE,
924: ATTRIBUTE8 PER_PERSON_DLVRY_METHODS.ATTRIBUTE8%TYPE,
925: ATTRIBUTE9 PER_PERSON_DLVRY_METHODS.ATTRIBUTE9%TYPE,
926: ATTRIBUTE10 PER_PERSON_DLVRY_METHODS.ATTRIBUTE10%TYPE,
927: ATTRIBUTE11 PER_PERSON_DLVRY_METHODS.ATTRIBUTE11%TYPE,
928: ATTRIBUTE12 PER_PERSON_DLVRY_METHODS.ATTRIBUTE12%TYPE,
929: ATTRIBUTE13 PER_PERSON_DLVRY_METHODS.ATTRIBUTE13%TYPE,
930: ATTRIBUTE14 PER_PERSON_DLVRY_METHODS.ATTRIBUTE14%TYPE,
931: ATTRIBUTE15 PER_PERSON_DLVRY_METHODS.ATTRIBUTE15%TYPE,
932: ATTRIBUTE16 PER_PERSON_DLVRY_METHODS.ATTRIBUTE16%TYPE,
925: ATTRIBUTE9 PER_PERSON_DLVRY_METHODS.ATTRIBUTE9%TYPE,
926: ATTRIBUTE10 PER_PERSON_DLVRY_METHODS.ATTRIBUTE10%TYPE,
927: ATTRIBUTE11 PER_PERSON_DLVRY_METHODS.ATTRIBUTE11%TYPE,
928: ATTRIBUTE12 PER_PERSON_DLVRY_METHODS.ATTRIBUTE12%TYPE,
929: ATTRIBUTE13 PER_PERSON_DLVRY_METHODS.ATTRIBUTE13%TYPE,
930: ATTRIBUTE14 PER_PERSON_DLVRY_METHODS.ATTRIBUTE14%TYPE,
931: ATTRIBUTE15 PER_PERSON_DLVRY_METHODS.ATTRIBUTE15%TYPE,
932: ATTRIBUTE16 PER_PERSON_DLVRY_METHODS.ATTRIBUTE16%TYPE,
933: ATTRIBUTE17 PER_PERSON_DLVRY_METHODS.ATTRIBUTE17%TYPE,
926: ATTRIBUTE10 PER_PERSON_DLVRY_METHODS.ATTRIBUTE10%TYPE,
927: ATTRIBUTE11 PER_PERSON_DLVRY_METHODS.ATTRIBUTE11%TYPE,
928: ATTRIBUTE12 PER_PERSON_DLVRY_METHODS.ATTRIBUTE12%TYPE,
929: ATTRIBUTE13 PER_PERSON_DLVRY_METHODS.ATTRIBUTE13%TYPE,
930: ATTRIBUTE14 PER_PERSON_DLVRY_METHODS.ATTRIBUTE14%TYPE,
931: ATTRIBUTE15 PER_PERSON_DLVRY_METHODS.ATTRIBUTE15%TYPE,
932: ATTRIBUTE16 PER_PERSON_DLVRY_METHODS.ATTRIBUTE16%TYPE,
933: ATTRIBUTE17 PER_PERSON_DLVRY_METHODS.ATTRIBUTE17%TYPE,
934: ATTRIBUTE18 PER_PERSON_DLVRY_METHODS.ATTRIBUTE18%TYPE,
927: ATTRIBUTE11 PER_PERSON_DLVRY_METHODS.ATTRIBUTE11%TYPE,
928: ATTRIBUTE12 PER_PERSON_DLVRY_METHODS.ATTRIBUTE12%TYPE,
929: ATTRIBUTE13 PER_PERSON_DLVRY_METHODS.ATTRIBUTE13%TYPE,
930: ATTRIBUTE14 PER_PERSON_DLVRY_METHODS.ATTRIBUTE14%TYPE,
931: ATTRIBUTE15 PER_PERSON_DLVRY_METHODS.ATTRIBUTE15%TYPE,
932: ATTRIBUTE16 PER_PERSON_DLVRY_METHODS.ATTRIBUTE16%TYPE,
933: ATTRIBUTE17 PER_PERSON_DLVRY_METHODS.ATTRIBUTE17%TYPE,
934: ATTRIBUTE18 PER_PERSON_DLVRY_METHODS.ATTRIBUTE18%TYPE,
935: ATTRIBUTE19 PER_PERSON_DLVRY_METHODS.ATTRIBUTE19%TYPE,
928: ATTRIBUTE12 PER_PERSON_DLVRY_METHODS.ATTRIBUTE12%TYPE,
929: ATTRIBUTE13 PER_PERSON_DLVRY_METHODS.ATTRIBUTE13%TYPE,
930: ATTRIBUTE14 PER_PERSON_DLVRY_METHODS.ATTRIBUTE14%TYPE,
931: ATTRIBUTE15 PER_PERSON_DLVRY_METHODS.ATTRIBUTE15%TYPE,
932: ATTRIBUTE16 PER_PERSON_DLVRY_METHODS.ATTRIBUTE16%TYPE,
933: ATTRIBUTE17 PER_PERSON_DLVRY_METHODS.ATTRIBUTE17%TYPE,
934: ATTRIBUTE18 PER_PERSON_DLVRY_METHODS.ATTRIBUTE18%TYPE,
935: ATTRIBUTE19 PER_PERSON_DLVRY_METHODS.ATTRIBUTE19%TYPE,
936: ATTRIBUTE20 PER_PERSON_DLVRY_METHODS.ATTRIBUTE20%TYPE
929: ATTRIBUTE13 PER_PERSON_DLVRY_METHODS.ATTRIBUTE13%TYPE,
930: ATTRIBUTE14 PER_PERSON_DLVRY_METHODS.ATTRIBUTE14%TYPE,
931: ATTRIBUTE15 PER_PERSON_DLVRY_METHODS.ATTRIBUTE15%TYPE,
932: ATTRIBUTE16 PER_PERSON_DLVRY_METHODS.ATTRIBUTE16%TYPE,
933: ATTRIBUTE17 PER_PERSON_DLVRY_METHODS.ATTRIBUTE17%TYPE,
934: ATTRIBUTE18 PER_PERSON_DLVRY_METHODS.ATTRIBUTE18%TYPE,
935: ATTRIBUTE19 PER_PERSON_DLVRY_METHODS.ATTRIBUTE19%TYPE,
936: ATTRIBUTE20 PER_PERSON_DLVRY_METHODS.ATTRIBUTE20%TYPE
937: );
930: ATTRIBUTE14 PER_PERSON_DLVRY_METHODS.ATTRIBUTE14%TYPE,
931: ATTRIBUTE15 PER_PERSON_DLVRY_METHODS.ATTRIBUTE15%TYPE,
932: ATTRIBUTE16 PER_PERSON_DLVRY_METHODS.ATTRIBUTE16%TYPE,
933: ATTRIBUTE17 PER_PERSON_DLVRY_METHODS.ATTRIBUTE17%TYPE,
934: ATTRIBUTE18 PER_PERSON_DLVRY_METHODS.ATTRIBUTE18%TYPE,
935: ATTRIBUTE19 PER_PERSON_DLVRY_METHODS.ATTRIBUTE19%TYPE,
936: ATTRIBUTE20 PER_PERSON_DLVRY_METHODS.ATTRIBUTE20%TYPE
937: );
938:
931: ATTRIBUTE15 PER_PERSON_DLVRY_METHODS.ATTRIBUTE15%TYPE,
932: ATTRIBUTE16 PER_PERSON_DLVRY_METHODS.ATTRIBUTE16%TYPE,
933: ATTRIBUTE17 PER_PERSON_DLVRY_METHODS.ATTRIBUTE17%TYPE,
934: ATTRIBUTE18 PER_PERSON_DLVRY_METHODS.ATTRIBUTE18%TYPE,
935: ATTRIBUTE19 PER_PERSON_DLVRY_METHODS.ATTRIBUTE19%TYPE,
936: ATTRIBUTE20 PER_PERSON_DLVRY_METHODS.ATTRIBUTE20%TYPE
937: );
938:
939: TYPE ASSIGNMENT_EXTRA_INFO is RECORD
932: ATTRIBUTE16 PER_PERSON_DLVRY_METHODS.ATTRIBUTE16%TYPE,
933: ATTRIBUTE17 PER_PERSON_DLVRY_METHODS.ATTRIBUTE17%TYPE,
934: ATTRIBUTE18 PER_PERSON_DLVRY_METHODS.ATTRIBUTE18%TYPE,
935: ATTRIBUTE19 PER_PERSON_DLVRY_METHODS.ATTRIBUTE19%TYPE,
936: ATTRIBUTE20 PER_PERSON_DLVRY_METHODS.ATTRIBUTE20%TYPE
937: );
938:
939: TYPE ASSIGNMENT_EXTRA_INFO is RECORD
940: (