1 PACKAGE GMF_AR_GET_SITE_USES AUTHID CURRENT_USER AS
2 /* $Header: gmfsitus.pls 115.2 2002/11/11 00:43:35 rseshadr ship $ */
3 PROCEDURE AR_GET_SITE_USES (CUST_ID IN OUT NOCOPY NUMBER,
4 ADDRESSID IN OUT NOCOPY NUMBER,
5 SITEUSEID IN OUT NOCOPY NUMBER,
6 START_DATE IN OUT NOCOPY DATE,
7 END_DATE IN OUT NOCOPY DATE,
8 SITE_USE_CD IN OUT NOCOPY VARCHAR2,
9 PRIMARY_FLAG OUT NOCOPY VARCHAR2,
10 STATUS OUT NOCOPY VARCHAR2,
11 LOCATION_CD IN OUT NOCOPY VARCHAR2,
12 CONTACT_ID OUT NOCOPY NUMBER,
13 BILLTO_SITEUSE_ID OUT NOCOPY NUMBER,
14 SIC_CD OUT NOCOPY VARCHAR2,
15 PAYMENT_TERM_ID OUT NOCOPY NUMBER,
16 PAYMENT_TERM_CD OUT NOCOPY VARCHAR2,
17 GSA_INDICATOR OUT NOCOPY VARCHAR2,
18 SHIP_PARTIAL OUT NOCOPY VARCHAR2,
19 SHIP_VIA OUT NOCOPY VARCHAR2,
20 FOB_CD OUT NOCOPY VARCHAR2,
21 ORDER_TYPE OUT NOCOPY VARCHAR2,
22 PRICE_LIST OUT NOCOPY VARCHAR2,
23 FREIGHT_TERMS OUT NOCOPY VARCHAR2,
24 WAREHOUSE_ID OUT NOCOPY NUMBER,
25 PRIMARY_SALESREP_ID OUT NOCOPY NUMBER,
26 ATTR_CATEGORY OUT NOCOPY VARCHAR2,
27 ATT1 OUT NOCOPY VARCHAR2,
28 ATT2 OUT NOCOPY VARCHAR2,
29 ATT3 OUT NOCOPY VARCHAR2,
30 ATT4 OUT NOCOPY VARCHAR2,
31 ATT5 OUT NOCOPY VARCHAR2,
32 ATT6 OUT NOCOPY VARCHAR2,
33 ATT7 OUT NOCOPY VARCHAR2,
34 ATT8 OUT NOCOPY VARCHAR2,
35 ATT9 OUT NOCOPY VARCHAR2,
36 ATT10 OUT NOCOPY VARCHAR2,
37 ATT11 OUT NOCOPY VARCHAR2,
38 ATT12 OUT NOCOPY VARCHAR2,
39 ATT13 OUT NOCOPY VARCHAR2,
40 ATT14 OUT NOCOPY VARCHAR2,
41 ATT15 OUT NOCOPY VARCHAR2,
42 ATT16 OUT NOCOPY VARCHAR2,
43 ATT17 OUT NOCOPY VARCHAR2,
44 ATT18 OUT NOCOPY VARCHAR2,
45 ATT19 OUT NOCOPY VARCHAR2,
46 ATT20 OUT NOCOPY VARCHAR2,
47 ATT21 OUT NOCOPY VARCHAR2,
48 ATT22 OUT NOCOPY VARCHAR2,
49 ATT23 OUT NOCOPY VARCHAR2,
50 ATT24 OUT NOCOPY VARCHAR2,
51 ORIG_SYSTEM_REFERENCE OUT NOCOPY VARCHAR2, /* PCR#508958 */
52 TAX_REFERENCE OUT NOCOPY VARCHAR2,
53 TAX_CD OUT NOCOPY VARCHAR2,
54 CREATED_BY OUT NOCOPY NUMBER,
55 CREATION_DATE OUT NOCOPY DATE,
56 LAST_UPDATE_DATE OUT NOCOPY DATE,
57 LAST_UPDATED_BY OUT NOCOPY NUMBER,
58 ROW_TO_FETCH IN OUT NOCOPY NUMBER,
59 ERROR_STATUS OUT NOCOPY NUMBER,
60 BILL_LOCATION_CD OUT NOCOPY VARCHAR2,
61 PORG_ID IN OUT NOCOPY NUMBER
62 );
63 END GMF_AR_GET_SITE_USES;
[Home] [Help]