[Home] [Help]
PACKAGE: APPS.IEM_GETCUST_PVT
Source
1 PACKAGE IEM_GETCUST_PVT AUTHID CURRENT_USER as
2 /* $Header: iemgcsts.pls 115.7 2002/12/06 03:14:06 sboorela shipped $*/
3 -- Start of Comments
4 -- API name : 'GetCustomerInfo`
5 -- Purpose : Returns Customer FirstName LastName
6 -- Pre-reqs : None
7 -- Parameters :
8 -- IN
9 -- p_email IN VARCHAR2 Required
10 -- p_api_version_number IN NUMBER Required
11 -- p_init_msg_list IN VARCHAR2 Optional Default =FND_API_G_FALSE
12 -- p_commit IN VARCHAR2 Optional Default =FND_API.G_FALSE
13 -- p_email IN VARCHAR2 Required
14 --
15 -- OUT:
16 -- p_party_id OUT NUMBER
17 -- p_customer_name OUT VARCHAR2
18 -- p_first_name OUT VARCHAR2
19 -- p_last_name OUT VARCHAR2
20 -- x_return_status OUT VARCHAR2
21 -- x_msg_count OUT NUMBER
22 -- x_msg_data OUT VARCHAR2
23 --
24 -- Version : Current version 1.0
25 -- Note:
26 --
27 -- End of Comments
28
29 TYPE cust_rec_type IS RECORD (
30 owner_table_id number,
31 party_type varchar2(30),
32 email_address varchar2(500));
33
34 TYPE cust_rec_tbl IS TABLE OF cust_rec_type
35 INDEX BY BINARY_INTEGER;
36
37 PROCEDURE GetCustomerInfo(
38 P_Api_Version_Number IN NUMBER,
39 P_Init_Msg_List IN VARCHAR2 ,
40 P_Commit IN VARCHAR2 ,
41 p_email IN VARCHAR2,
42 p_party_id OUT NOCOPY NUMBER,
43 p_customer_name OUT NOCOPY VARCHAR2,
44 p_first_name OUT NOCOPY VARCHAR2,
45 p_last_name OUT NOCOPY VARCHAR2,
46 x_msg_count OUT NOCOPY NUMBER,
47 x_return_status OUT NOCOPY VARCHAR2,
48 x_msg_data OUT NOCOPY VARCHAR2);
49
50 PROCEDURE GetCustomerId(
51 P_Api_Version_Number IN NUMBER,
52 p_email IN VARCHAR2,
53 p_party_id OUT NOCOPY NUMBER,
54 x_msg_count OUT NOCOPY NUMBER,
55 x_return_status OUT NOCOPY VARCHAR2,
56 x_msg_data OUT NOCOPY VARCHAR2);
57
58 PROCEDURE CustomerSearch(
59 P_Api_Version_Number IN NUMBER,
60 p_email IN VARCHAR2,
61 x_party_id OUT NOCOPY NUMBER,
62 x_msg_count OUT NOCOPY NUMBER,
63 x_return_status OUT NOCOPY VARCHAR2,
64 x_msg_data OUT NOCOPY VARCHAR2);
65 End IEM_GETCUST_PVT;