1 PACKAGE GMF_AP_GET_VENDOR_SITES AUTHID CURRENT_USER AS
2 /* $Header: gmfvndis.pls 120.0 2005/08/30 15:27:51 sschinch noship $ */
3 PROCEDURE AP_GET_VENDOR_SITES
4 (ST_DATE IN OUT NOCOPY DATE,
5 EN_DATE IN OUT NOCOPY DATE,
6 VNDORID IN OUT NOCOPY NUMBER,
7 VNDOR_SITE_ID IN OUT NOCOPY NUMBER,
8 LST_UPDT_DT IN OUT NOCOPY DATE,
9 LST_UPDT_BY IN OUT NOCOPY NUMBER,
10 VNDOR_SITE_CD IN OUT NOCOPY VARCHAR2,
11 LST_UPDT_LOGIN OUT NOCOPY NUMBER,
12 CREATE_DAT IN OUT NOCOPY DATE,
13 CREATE_BY IN OUT NOCOPY NUMBER,
14 PUR_SITE_FLG OUT NOCOPY VARCHAR2,
15 RFQ_ONLY_SITE_FLG OUT NOCOPY VARCHAR2,
16 PAY_SITE_FLG OUT NOCOPY VARCHAR2,
17 ATTN_AR_FLG OUT NOCOPY VARCHAR2,
18 ADDR_LN1 OUT NOCOPY VARCHAR2,
19 ADDR_LN2 OUT NOCOPY VARCHAR2,
20 ADDR_LN3 OUT NOCOPY VARCHAR2,
21 CTY OUT NOCOPY VARCHAR2,
22 STAT OUT NOCOPY VARCHAR2,
23 ZP OUT NOCOPY VARCHAR2,
24 PROV OUT NOCOPY VARCHAR2,
25 CTRY OUT NOCOPY VARCHAR2,
26 AREA_CD OUT NOCOPY VARCHAR2,
27 TEL_PH OUT NOCOPY VARCHAR2,
28 CUST_NUM OUT NOCOPY VARCHAR2,
29 SHIP_LOC_ID OUT NOCOPY NUMBER,
30 BILL_LOC_ID OUT NOCOPY NUMBER,
31 SHIP_VIA_LKUP_CD OUT NOCOPY VARCHAR2,
32 FRGHT_TERMS_LKUP_CD OUT NOCOPY VARCHAR2,
33 FOB_LKUP_CODE OUT NOCOPY VARCHAR2,
34 INACT_DAT OUT NOCOPY DATE,
35 FAX_NUM OUT NOCOPY VARCHAR2,
36 FAX_AREA_CD OUT NOCOPY VARCHAR2,
37 TELX OUT NOCOPY VARCHAR2,
38 PMT_MTHD_LKUP_CD OUT NOCOPY VARCHAR2,
39 BK_AC_NAM OUT NOCOPY VARCHAR2,
40 BK_AC_NUM OUT NOCOPY VARCHAR2,
41 BK_NUM OUT NOCOPY VARCHAR2,
42 BK_AC_TYPE OUT NOCOPY VARCHAR2,
43 TMS_DAT_BASIS OUT NOCOPY VARCHAR2,
44 T_TERMS_ID OUT NOCOPY NUMBER,
45 ATTR_CATEG OUT NOCOPY VARCHAR2,
46 ATT1 OUT NOCOPY VARCHAR2,
47 ATT2 OUT NOCOPY VARCHAR2,
48 ATT3 OUT NOCOPY VARCHAR2,
49 ATT4 OUT NOCOPY VARCHAR2,
50 ATT5 OUT NOCOPY VARCHAR2,
51 ROW_TO_FETCH IN OUT NOCOPY NUMBER,
52 ERROR_STATUS OUT NOCOPY NUMBER,
53 CREATION_DATE OUT NOCOPY VARCHAR2,
54 CREATED_BY OUT NOCOPY NUMBER,
55 LAST_UPDATE_DATE OUT NOCOPY VARCHAR2,
56 LAST_UPDATED_BY OUT NOCOPY NUMBER,
57 PORG_ID IN OUT NOCOPY NUMBER);
58 END GMF_AP_GET_VENDOR_SITES;
[Home] [Help]