1 PACKAGE GMF_AR_GET_CONTACT AUTHID CURRENT_USER AS
2 /* $Header: gmfcucns.pls 115.0 99/07/16 04:16:44 porting shi $ */
3 PROCEDURE ar_get_contact(cust_id IN OUT number,
4 addressid IN OUT number,
5 contactid IN OUT number,
6 location_code IN varchar2,
7 stat_us IN OUT varchar2,
8 start_date IN OUT date,
9 end_date IN OUT date,
10 contactno OUT varchar2,
11 lastname OUT varchar2,
12 firstname OUT varchar2,
13 sufx OUT varchar2,
14 mailaddid OUT number,
15 dontmailflag OUT varchar2,
16 mailstop OUT varchar2,
17 emailadd OUT varchar2,
18 nativelang OUT varchar2,
19 otherlang1 OUT varchar2,
20 otherlang2 OUT varchar2,
21 title OUT varchar2,
22 jobtitle OUT varchar2,
23 jobtitlecode OUT varchar2,
24 matchgroupid OUT number,
25 primaryrole OUT varchar2,
26 rank OUT varchar2,
27 managedby OUT number,
28 decisionmakeflag OUT varchar2,
29 referenceuseflag OUT varchar2,
30 contactkey OUT varchar2,
31 contactperinfo OUT varchar2,
32 attcatagory OUT varchar2,
33 att1 OUT varchar2,
34 att2 OUT varchar2,
35 att3 OUT varchar2,
36 att4 OUT varchar2,
37 att5 OUT varchar2,
38 att6 OUT varchar2,
39 att7 OUT varchar2,
40 att8 OUT varchar2,
41 att9 OUT varchar2,
42 att10 OUT varchar2,
43 att11 OUT varchar2,
44 att12 OUT varchar2,
45 att13 OUT varchar2,
46 att14 OUT varchar2,
47 att15 OUT varchar2,
48 att16 OUT varchar2,
49 att17 OUT varchar2,
50 att18 OUT varchar2,
51 att19 OUT varchar2,
52 att20 OUT varchar2,
53 att21 OUT varchar2,
54 att22 OUT varchar2,
55 att23 OUT varchar2,
56 att24 OUT varchar2,
57 att25 OUT varchar2,
58 orgsysreference OUT varchar2,
59 created_by OUT number,
60 creation_date OUT date,
61 last_update_date OUT date,
62 last_updated_by OUT number,
63 row_to_fetch IN OUT number,
64 error_status OUT number);
65 END GMF_AR_GET_CONTACT;