213: PRAGMA RESTRICT_REFERENCES
214: (get_currency_format, WNDS);
215:
216: FUNCTION GET_CONTACTS_TYPE_LIST(
217: p_person_id IN per_contact_relationships.person_id%TYPE
218: ,p_contact_id IN per_contact_relationships.contact_person_id%TYPE
219: ,p_effective_date IN DATE DEFAULT TRUNC(SYSDATE))
220: RETURN VARCHAR2;
221:
214: (get_currency_format, WNDS);
215:
216: FUNCTION GET_CONTACTS_TYPE_LIST(
217: p_person_id IN per_contact_relationships.person_id%TYPE
218: ,p_contact_id IN per_contact_relationships.contact_person_id%TYPE
219: ,p_effective_date IN DATE DEFAULT TRUNC(SYSDATE))
220: RETURN VARCHAR2;
221:
222: FUNCTION is_emergency_contact(
219: ,p_effective_date IN DATE DEFAULT TRUNC(SYSDATE))
220: RETURN VARCHAR2;
221:
222: FUNCTION is_emergency_contact(
223: p_person_id IN per_contact_relationships.person_id%TYPE
224: ,p_contact_id IN per_contact_relationships.contact_person_id%TYPE
225: ,p_effective_date IN DATE DEFAULT TRUNC(SYSDATE))
226: RETURN NUMBER;
227:
220: RETURN VARCHAR2;
221:
222: FUNCTION is_emergency_contact(
223: p_person_id IN per_contact_relationships.person_id%TYPE
224: ,p_contact_id IN per_contact_relationships.contact_person_id%TYPE
225: ,p_effective_date IN DATE DEFAULT TRUNC(SYSDATE))
226: RETURN NUMBER;
227:
228: -- ------------------------------------------------------------------------