1 PACKAGE igs_pe_relationships_pkg AS
2 /* $Header: IGSNI41S.pls 120.1 2005/07/06 08:46:00 appldev ship $ */
3
4
5 PROCEDURE creatupdate_party_relationship(
6 p_action IN VARCHAR2 ,
7 p_subject_id IN NUMBER ,
8 p_object_id IN NUMBER ,
9 p_party_relationship_type IN VARCHAR2 ,
10 p_relationship_code IN VARCHAR2 ,
11 p_comments IN VARCHAR2 ,
12 p_start_date IN DATE,
13 p_end_date IN DATE,
14 p_last_update_date IN OUT NOCOPY DATE ,
15 p_return_status OUT NOCOPY VARCHAR2 ,
16 p_msg_count OUT NOCOPY NUMBER,
17 p_msg_data OUT NOCOPY VARCHAR2 ,
18 p_party_relationship_id IN OUT NOCOPY VARCHAR2 ,
19 p_party_id OUT NOCOPY NUMBER ,
20 p_party_number OUT NOCOPY VARCHAR2,
21 p_caller IN VARCHAR2 DEFAULT 'NOT_FAMILY',
22 P_Object_Version_Number IN OUT NOCOPY NUMBER ,
23 P_Primary IN VARCHAR2 DEFAULT NULL,
24 P_Secondary IN VARCHAR2 DEFAULT NULL,
25 P_Joint_Salutation IN VARCHAR2 DEFAULT NULL ,
26 P_Next_To_Kin IN VARCHAR2 DEFAULT NULL,
27 P_Rep_Faculty IN VARCHAR2 DEFAULT NULL,
28 P_Rep_Staff IN VARCHAR2 DEFAULT NULL,
29 P_Rep_Student IN VARCHAR2 DEFAULT NULL,
30 P_Rep_Alumni IN VARCHAR2 DEFAULT NULL,
31 p_directional_flag IN VARCHAR2 DEFAULT NULL,
32 p_emergency_contact_flag IN VARCHAR2 DEFAULT NULL
33 ) ;
34
35 PROCEDURE copy_address_and_usage(p_subject_id IN NUMBER,
36 p_object_id IN NUMBER ,
37 p_validate OUT NOCOPY BOOLEAN);
38
39 END igs_pe_relationships_pkg;