1 PACKAGE OE_BULK_ACK_PVT AS
2 /* $Header: OEBVACKS.pls 120.0 2005/06/01 03:06:19 appldev noship $ */
3
4 FUNCTION Get_Address_ID(p_key IN NUMBER
5 ,p_site_use_code IN VARCHAR2)
6 RETURN NUMBER;
7
8 FUNCTION Get_Address1(p_key IN NUMBER
9 ,p_site_use_code IN VARCHAR2)
10 RETURN VARCHAR2;
11
12 FUNCTION Get_Address2(p_key IN NUMBER
13 ,p_site_use_code IN VARCHAR2)
14 RETURN VARCHAR2;
15
16 FUNCTION Get_Address3(p_key IN NUMBER
17 ,p_site_use_code IN VARCHAR2)
18 RETURN VARCHAR2;
19
20 FUNCTION Get_Address4(p_key IN NUMBER
21 ,p_site_use_code IN VARCHAR2)
22 RETURN VARCHAR2;
23
24 FUNCTION Get_State(p_key IN NUMBER
25 ,p_site_use_code IN VARCHAR2)
26 RETURN VARCHAR2;
27
28 FUNCTION Get_City(p_key IN NUMBER
29 ,p_site_use_code IN VARCHAR2)
30 RETURN VARCHAR2;
31
32 FUNCTION Get_Zip(p_key IN NUMBER
33 ,p_site_use_code IN VARCHAR2)
34 RETURN VARCHAR2;
35
36 FUNCTION Get_Country(p_key IN NUMBER
37 ,p_site_use_code IN VARCHAR2)
38 RETURN VARCHAR2;
39
40 FUNCTION Get_County(p_key IN NUMBER
41 ,p_site_use_code IN VARCHAR2)
42 RETURN VARCHAR2;
43
44 FUNCTION Get_Province(p_key IN NUMBER
45 ,p_site_use_code IN VARCHAR2)
46 RETURN VARCHAR2;
47
48 FUNCTION Get_Location(p_key IN NUMBER
49 ,p_site_use_code IN VARCHAR2)
50 RETURN VARCHAR2;
51
52 FUNCTION Get_EDI_Location(p_key IN NUMBER
53 ,p_site_use_code IN VARCHAR2)
54 RETURN VARCHAR2;
55
56 PROCEDURE Process_Acknowledgments
57 (p_batch_id IN NUMBER
58 ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
59
60 END OE_BULK_ACK_PVT;