PACKAGE: APPS.IGS_GE_GEN_002

Source

1 PACKAGE IGS_GE_GEN_002 AUTHID CURRENT_USER AS
2 /* $Header: IGSGE02S.pls 115.6 2002/11/29 00:31:40 nsidana ship $ */
3 
4 FUNCTION GENP_GET_DELIMIT_STR(
5   p_input_str IN VARCHAR2 ,
6   p_element_num IN NUMBER ,
7   p_delimiter IN VARCHAR2 DEFAULT ',')
8 RETURN VARCHAR2 ;
9  PRAGMA RESTRICT_REFERENCES(GENP_GET_DELIMIT_STR, WNDS,WNPS);
10 
11 
12 FUNCTION genp_get_initials(
13   p_given_names IN VARCHAR2 )
14 RETURN VARCHAR2 ;
15 PRAGMA RESTRICT_REFERENCES(genp_get_initials, WNDS,WNPS);
16 
17 
18 FUNCTION genp_get_mail_addr(
19   p_person_id  NUMBER ,
20   p_org_unit_cd  VARCHAR2 ,
21   p_institution_cd  VARCHAR2 ,
22   p_location_cd  VARCHAR2 ,
23   p_addr_type  VARCHAR2 ,
24   p_case_type  VARCHAR2 DEFAULT 'UPPER',
25   p_phone_no  VARCHAR2 DEFAULT 'Y',
26   p_name_style  VARCHAR2 DEFAULT 'CONTEXT',
27   p_inc_addr  VARCHAR2 DEFAULT 'Y')
28 RETURN VARCHAR2 ;
29 
30 FUNCTION genp_get_nxt_prsn_id(
31   p_person_id OUT NOCOPY NUMBER ,
32   p_message_name OUT NOCOPY VARCHAR2 )
33 RETURN BOOLEAN ;
34 
35 FUNCTION GENP_GET_PDV_NAME(
36   p_person_id IN NUMBER ,
37   p_field_name IN VARCHAR2 )
38 RETURN VARCHAR2 ;
39 
40 FUNCTION genp_get_person_name(
41   p_person_id IN NUMBER ,
42   p_surname OUT NOCOPY VARCHAR2 ,
43   p_given_names OUT NOCOPY VARCHAR2 ,
44   p_title OUT NOCOPY VARCHAR2 ,
45   p_oracle_username OUT NOCOPY VARCHAR2 ,
46   p_preferred_given_name OUT NOCOPY VARCHAR2 ,
47   p_full_name OUT NOCOPY VARCHAR2 ,
48   p_preferred_name OUT NOCOPY VARCHAR2 ,
49   p_title_name OUT NOCOPY VARCHAR2 ,
50   p_initial_name OUT NOCOPY VARCHAR2 ,
51   p_message_name OUT NOCOPY VARCHAR2 )
52 RETURN BOOLEAN ;
53 
54 FUNCTION genp_get_prsn_email(
55   p_person_id IN NUMBER ,
56   p_email_addr OUT NOCOPY VARCHAR2 ,
57   p_message_name OUT NOCOPY VARCHAR2 )
58 RETURN BOOLEAN ;
59 
60 FUNCTION genp_get_prsn_names(
61   p_person_id IN NUMBER ,
62   p_surname OUT NOCOPY VARCHAR2 ,
63   p_given_names OUT NOCOPY VARCHAR2 ,
64   p_title OUT NOCOPY VARCHAR2 ,
65   p_oracle_username OUT NOCOPY VARCHAR2 ,
66   p_preferred_given_name OUT NOCOPY VARCHAR2 ,
67   p_full_name OUT NOCOPY VARCHAR2 ,
68   p_preferred_name OUT NOCOPY VARCHAR2 ,
69   p_title_name OUT NOCOPY VARCHAR2 ,
70   p_initial_name OUT NOCOPY VARCHAR2 ,
71   p_context_block_name OUT NOCOPY VARCHAR2 ,
72   p_message_name OUT NOCOPY VARCHAR2 )
73 RETURN BOOLEAN ;
74 
75 END IGS_GE_GEN_002;