1 PACKAGE GMF_AR_GET_CUST_ADDRESSES AUTHID CURRENT_USER AS
2 /* $Header: gmfcuads.pls 115.1 99/07/16 04:16:36 porting shi $ */
3 PROCEDURE AR_GET_CUST_ADDRESSES(CUST_ID IN OUT NUMBER,
4 ADDRESSID IN OUT NUMBER,
5 START_DATE IN OUT DATE,
6 END_DATE IN OUT DATE,
7 STATUS OUT VARCHAR2,
8 COUNTRY OUT VARCHAR2,
9 ADDRESS1 OUT VARCHAR2,
10 ADDRESS2 OUT VARCHAR2,
11 ADDRESS3 OUT VARCHAR2,
12 ADDRESS4 OUT VARCHAR2,
13 CITY OUT VARCHAR2,
14 ZIPCODE OUT VARCHAR2,
15 STATE OUT VARCHAR2,
16 PROVINCE OUT VARCHAR2,
17 COUNTY OUT VARCHAR2,
18 ATTR_CATEGORY OUT VARCHAR2,
19 ATT1 OUT VARCHAR2,
20 ATT2 OUT VARCHAR2,
21 ATT3 OUT VARCHAR2,
22 ATT4 OUT VARCHAR2,
23 ATT5 OUT VARCHAR2,
24 ATT6 OUT VARCHAR2,
25 ATT7 OUT VARCHAR2,
26 ATT8 OUT VARCHAR2,
27 ATT9 OUT VARCHAR2,
28 ATT10 OUT VARCHAR2,
29 ATT11 OUT VARCHAR2,
30 ATT12 OUT VARCHAR2,
31 ATT13 OUT VARCHAR2,
32 ATT14 OUT VARCHAR2,
33 ATT15 OUT VARCHAR2,
34 BILL_TO_FLAG OUT VARCHAR2,
35 SHIP_TO_FLAG OUT VARCHAR2,
36 MARKETING_FLAG OUT VARCHAR2,
37 LOCATION_ID OUT NUMBER,
38 CUST_PROSPECT_CD OUT VARCHAR2,
39 CREATED_BY OUT NUMBER,
40 CREATION_DATE OUT DATE,
41 LAST_UPDATE_DATE OUT DATE,
42 LAST_UPDATED_BY OUT NUMBER,
43 ROW_TO_FETCH IN OUT NUMBER,
44 ERROR_STATUS OUT NUMBER,
45 PORG_ID IN OUT NUMBER);
46 END GMF_AR_GET_CUST_ADDRESSES;