1 PACKAGE ARW_SEARCH_CUSTOMERS AS
2 /*$Header: ARWCUSRS.pls 120.6.12010000.3 2009/01/08 06:54:21 avepati ship $*/
3 --
4
5 TYPE cust_rec IS RECORD (
6 cus_seq_num BINARY_INTEGER := 0,
7 addr_cnt BINARY_INTEGER := 0
8 );
9
10 TYPE rev_cust_rec IS RECORD (
11 customer_id hz_cust_accounts.cust_account_id%TYPE,
12 addr_cnt BINARY_INTEGER := 0
13 );
14
15 TYPE addr_rec IS RECORD (
16 customer_id hz_cust_acct_sites.cust_account_id%TYPE,
17 addr_seq_num BINARY_INTEGER := 0,
18 total_score NUMBER(15) := 0
19 );
20
21 TYPE customer_rectype IS RECORD (
22 customer_id ari_customer_search_v.customer_id%TYPE,
23 DETAILS_LEVEL ari_customer_search_v.DETAILS_LEVEL%TYPE,
24 CUSTOMER_NUMBER ari_customer_search_v.CUSTOMER_NUMBER%TYPE,
25 CUSTOMER_NAME ari_customer_search_v.CUSTOMER_NAME%TYPE,
26 ADDRESS_ID hz_cust_acct_sites.cust_acct_site_id%TYPE,
27 CONCATENATED_ADDRESS ari_customer_search_v.CONCATENATED_ADDRESS%TYPE,
28 CONTACT_NAME ar_cust_search_gt.CONTACT_NAME%TYPE,
29 CONTACT_PHONE ar_cust_search_gt.CONTACT_PHONE%TYPE,
30 BILL_TO_SITE_USE_ID hz_cust_site_uses.SITE_USE_ID%type,
31 SITE_USES ar_cust_search_gt.SITE_USES%TYPE,
32 ORG_ID ari_customer_search_v.ORG_ID%TYPE,
33 SELECTED VARCHAR2(2),
34 LOCATION VARCHAR2(4000)
35 );
36
37 TYPE cust_tab IS TABLE OF cust_rec INDEX BY BINARY_INTEGER;
38
39 TYPE rev_cust_tab IS TABLE OF rev_cust_rec INDEX BY BINARY_INTEGER;
40
41 TYPE addr_tab IS TABLE OF addr_rec INDEX BY BINARY_INTEGER;
42
43 TYPE customer_tabletype IS TABLE OF customer_rectype INDEX BY BINARY_INTEGER;
44
45 --
46
47 FUNCTION search_customers(
48 i_keyword IN varchar2 DEFAULT null,
49 i_first_row IN binary_integer DEFAULT 1,
50 i_last_row IN binary_integer DEFAULT null
51 ) RETURN customer_tabletype;
52 --
53 PROCEDURE ari_search ( i_keyword IN varchar2,
54 i_name_num IN VARCHAR2,
55 x_status OUT NOCOPY VARCHAR2,
56 x_msg_count OUT NOCOPY NUMBER,
57 x_msg_data OUT NOCOPY VARCHAR2 );
58 --
59
60 TYPE CustSite_rec_type IS RECORD (
61 CustomerId NUMBER,
62 SiteUseId NUMBER
63 );
64
65 TYPE CustSite_tbl IS TABLE of CustSite_rec_type INDEX BY BINARY_INTEGER;
66
67 -- Bug# 5858769
68 -- Provision to select sites
69 PROCEDURE initialize_account_sites ( p_custsite_rec_tbl in CustSite_tbl,
70 p_party_id in number,
71 p_session_id in number,
72 p_user_id in number ,
73 p_org_id in number ,
74 p_is_internal_user in varchar2
75 );
76
77
78 PROCEDURE init_acct_sites_anon_login ( p_customer_id in number,
79 p_site_use_id in number,
80 p_party_id in number,
81 p_session_id in number,
82 p_user_id in number ,
83 p_org_id in number ,
84 p_is_internal_user in varchar2
85 );
86 PROCEDURE update_account_sites ( p_customer_id in number,
87 p_session_id in number,
88 p_user_id in number ,
89 p_org_id in number ,
90 p_is_internal_user in varchar2
91 );
92
93 END arw_search_customers;