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