DBA Data[Home] [Help]

PACKAGE: APPS.IGS_PE_RELATIONSHIPS_PKG

Source


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;