1 PACKAGE BODY GMF_AR_GET_CUST_ADDRESSES AS
2 /* $Header: gmfcuadb.pls 120.0 2005/09/08 09:16:12 sschinch noship $ */
3
4 PROCEDURE AR_GET_CUST_ADDRESSES (CUST_ID IN OUT NOCOPY NUMBER,
5 ADDRESSID IN OUT NOCOPY NUMBER,
6 START_DATE IN OUT NOCOPY DATE,
7 END_DATE IN OUT NOCOPY DATE,
8 STATUS OUT NOCOPY VARCHAR2,
9 COUNTRY OUT NOCOPY VARCHAR2,
10 ADDRESS1 OUT NOCOPY VARCHAR2,
11 ADDRESS2 OUT NOCOPY VARCHAR2,
12 ADDRESS3 OUT NOCOPY VARCHAR2,
13 ADDRESS4 OUT NOCOPY VARCHAR2,
14 CITY OUT NOCOPY VARCHAR2,
15 ZIPCODE OUT NOCOPY VARCHAR2,
16 STATE OUT NOCOPY VARCHAR2,
17 PROVINCE OUT NOCOPY VARCHAR2,
18 COUNTY OUT NOCOPY VARCHAR2,
19 ATTR_CATEGORY OUT NOCOPY VARCHAR2,
20 ATT1 OUT NOCOPY VARCHAR2,
21 ATT2 OUT NOCOPY VARCHAR2,
22 ATT3 OUT NOCOPY VARCHAR2,
23 ATT4 OUT NOCOPY VARCHAR2,
24 ATT5 OUT NOCOPY VARCHAR2,
25 ATT6 OUT NOCOPY VARCHAR2,
26 ATT7 OUT NOCOPY VARCHAR2,
27 ATT8 OUT NOCOPY VARCHAR2,
28 ATT9 OUT NOCOPY VARCHAR2,
29 ATT10 OUT NOCOPY VARCHAR2,
30 ATT11 OUT NOCOPY VARCHAR2,
31 ATT12 OUT NOCOPY VARCHAR2,
32 ATT13 OUT NOCOPY VARCHAR2,
33 ATT14 OUT NOCOPY VARCHAR2,
34 ATT15 OUT NOCOPY VARCHAR2,
35 BILL_TO_FLAG OUT NOCOPY VARCHAR2,
36 SHIP_TO_FLAG OUT NOCOPY VARCHAR2,
37 MARKETING_FLAG OUT NOCOPY VARCHAR2,
38 LOCATION_ID OUT NOCOPY NUMBER,
39 CUST_PROSPECT_CD OUT NOCOPY VARCHAR2,
40 CREATED_BY OUT NOCOPY NUMBER,
41 CREATION_DATE OUT NOCOPY DATE,
42 LAST_UPDATE_DATE OUT NOCOPY DATE,
43 LAST_UPDATED_BY OUT NOCOPY NUMBER,
44 ROW_TO_FETCH IN OUT NOCOPY NUMBER,
45 ERROR_STATUS OUT NOCOPY NUMBER,
46 PORG_ID IN OUT NOCOPY NUMBER) IS
47 BEGIN
48 NULL;
49 END AR_GET_CUST_ADDRESSES;
50 END GMF_AR_GET_CUST_ADDRESSES;
[Home] [Help]