1 PACKAGE IBE_CUSTOMER_ACCT_PVT AUTHID CURRENT_USER AS
2 /* $Header: IBEVCACS.pls 120.0.12020000.1 2012/06/27 07:43:47 appldev ship $ */
3
4
5 -- This API is to retrieve a valid InvoiceTo/ShipTo Party'siteId for
6 -- the logged in user.
7 -- It follows following Rules to fetch the valid value.
8 -- For instance to fetch invoiceTo partySiteId
9 -- a) check if the user has a Primary BillTo Address and return id
10 -- b) If the user does not have a Primary BillTo Address,
11 -- then get the first "non-primary" BillTo Address.
12 -- c_ If the user does not have valid "BillTo Address",
13 -- then get the first "valid" address (SHIP_TO or any other site-use-type)
14
15 PROCEDURE GetPartySiteId(
16 p_api_version_number IN NUMBER := 1,
17 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
18 p_commit IN VARCHAR2 := FND_API.G_FALSE,
19 p_party_id IN NUMBER,
20 p_site_use_type IN VARCHAR2,
21 x_party_site_id OUT NOCOPY NUMBER,
22 x_return_status OUT NOCOPY VARCHAR2,
23 x_msg_count OUT NOCOPY NUMBER,
24 x_msg_data OUT NOCOPY VARCHAR2);
25
26 /*
27 PROCEDURE Create_Party_Site_Use(
28 p_api_version_number IN NUMBER := 1,
29 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
30 p_commit IN VARCHAR2 := FND_API.G_FALSE,
31 p_party_site_id IN NUMBER,
32 p_party_site_use_type IN VARCHAR2,
33 x_party_site_use_id OUT NOCOPY NUMBER,
34 x_return_status OUT NOCOPY VARCHAR2,
35 x_msg_count OUT NOCOPY NUMBER,
36 x_msg_data OUT NOCOPY VARCHAR2);
37 */
38
39 PROCEDURE create_cust_account_role(
40 p_api_version_number IN NUMBER := 1,
41 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
42 p_commit IN VARCHAR2 := FND_API.G_FALSE,
43 p_party_id IN NUMBER,
44 p_cust_acct_id IN NUMBER,
45 p_cust_acct_site_id IN NUMBER,
46 p_role_type IN VARCHAR2,
47 x_cust_acct_role_id OUT NOCOPY NUMBER,
48 x_return_status OUT NOCOPY VARCHAR2,
49 x_msg_count OUT NOCOPY NUMBER,
50 x_msg_data OUT NOCOPY VARCHAR2);
51
52
53 PROCEDURE Create_Cust_Acct_Site(
54 p_api_version_number IN NUMBER := 1
55 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
56 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
57 ,p_partysite_id IN NUMBER
58 ,p_custacct_id IN NUMBER
59 ,p_custacct_type IN VARCHAR2
60 ,x_custacct_site_id OUT NOCOPY NUMBER
61 ,x_return_status OUT NOCOPY VARCHAR2
62 ,x_msg_count OUT NOCOPY NUMBER
63 ,x_msg_data OUT NOCOPY VARCHAR2);
64
65
66
67 PROCEDURE Create_Cust_Acct_Site_Use(
68 p_api_version_number IN NUMBER := 1
69 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
70 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
71 ,p_cust_account_Id IN NUMBER
72 ,p_party_site_Id IN NUMBER
73 ,p_cust_acct_site_id IN NUMBER
74 ,p_acct_site_type IN VARCHAR2
75 ,x_cust_acct_site_id OUT NOCOPY NUMBER
76 ,x_custacct_site_use_id OUT NOCOPY NUMBER
77 ,x_return_status OUT NOCOPY VARCHAR2
78 ,x_msg_count OUT NOCOPY NUMBER
79 ,x_msg_data OUT NOCOPY VARCHAR2);
80
81
82 -- This API returns the InvoiceToOrgId or ShipToOrgId
83 -- for the Order.
84
85 PROCEDURE Get_Cust_Account_Site_Use(
86 p_api_version_number IN NUMBER := 1
87 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
88 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
89 ,p_cust_acct_id IN NUMBER
90 ,p_party_id IN NUMBER
91 ,p_siteuse_type IN VARCHAR2
92 ,p_partysite_id IN NUMBER := FND_API.G_MISS_NUM
93 ,x_siteuse_id OUT NOCOPY NUMBER
94 ,x_return_status OUT NOCOPY VARCHAR2
95 ,x_msg_count OUT NOCOPY NUMBER
96 ,x_msg_data OUT NOCOPY VARCHAR2);
97
98
99 -- This Procedure is to retrieve the cust_acct_role_id for a given user.
100 -- This valus would be invoice_to_contactid at oe_order_headers_all table.
101 -- If the invoice_to_org_id is retrieved from any of the valid line level values, then
102 -- invoice_to_contact_id would be maintained as null.
103
104 PROCEDURE Get_Cust_Acct_Role(
105 p_api_version_number IN NUMBER := 1
106 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
107 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
108 ,p_party_id IN NUMBER
109 ,p_acctsite_type IN VARCHAR2
110 ,p_sold_to_orgid IN NUMBER
111 ,p_custacct_siteuse_id IN NUMBER := FND_API.G_MISS_NUM
112 ,x_cust_acct_role_id OUT NOCOPY NUMBER
113 ,x_return_status OUT NOCOPY VARCHAR2
114 ,x_msg_count OUT NOCOPY NUMBER
115 ,x_msg_data OUT NOCOPY VARCHAR2);
116
117 -- This API would give Customer, Contact details of an Order/Order Line.
118 -- The InvocieToOrgId and InvoiceToContactId from
119 -- oe_order_headers_all/ oe_order-lines_all would be the
120 -- IN parameters for this API.
121
122 PROCEDURE GetCustomerAcctData(
123 p_api_version_number IN NUMBER := 1
124 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
125 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
126 ,p_invoice_to_org_id IN NUMBER := FND_API.G_MISS_NUM
127 ,p_invoice_to_contact_id IN NUMBER := FND_API.G_MISS_NUM
128 ,p_contact_party_id IN NUMBER := FND_API.G_MISS_NUM
129 ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
130 ,x_cust_account_id OUT NOCOPY NUMBER
131 ,x_cust_party_name OUT NOCOPY VARCHAR2
132 ,x_cust_party_id OUT NOCOPY NUMBER
133 ,x_cust_party_type OUT NOCOPY VARCHAR2
134 ,x_contact_party_id OUT NOCOPY NUMBER
135 ,x_contact_party_name OUT NOCOPY VARCHAR2
136 ,x_contact_phone OUT NOCOPY VARCHAR2
137 ,x_contact_email OUT NOCOPY VARCHAR2
138 ,x_party_site_id OUT NOCOPY NUMBER
139 ,x_partysite_status OUT NOCOPY VARCHAR2
140 ,x_return_status OUT NOCOPY VARCHAR2
141 ,x_msg_count OUT NOCOPY NUMBER
142 ,x_msg_data OUT NOCOPY VARCHAR2);
143
144
145 END IBE_CUSTOMER_ACCT_PVT;