1 package ibe_customer_pvt AUTHID CURRENT_USER as
2 /* $Header: IBEVACTS.pls 120.5 2005/11/18 18:18:27 mannamra ship $ */
3
4 G_PKG_NAME CONSTANT VARCHAR2(30) := 'ibe_customer_pvt';
5
6 -- procedure set_bank_acct_end_date --This API has been removed mannamra: 10/07/2005
7
8
9 procedure setOptInOutPreference(
10 p_party_id IN NUMBER,
11 p_preference IN VARCHAR2,
12 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
13 p_commit IN VARCHAR2 := FND_API.G_FALSE,
14 p_api IN NUMBER,
15 x_return_status OUT NOCOPY VARCHAR2,
16 x_msg_count OUT NOCOPY NUMBER,
17 x_msg_data OUT NOCOPY VARCHAR2
18 );
19
20 -- function to Get Credit Card Type Given The Number
21
22 function Get_Credit_Card_Type(
23 --fix 2861827
24 --p_Credit_Card_Number NUMBER
25 p_Credit_Card_Number VARCHAR2
26 ) RETURN VARCHAR2;
27
28
29 -- Get the primary credit card info for a given party id for
30 -- an enabled credit card type.
31 -- If primary credit card does not exists then get the
32 -- credit card info of the first credit card.
33 -- If the credit card type is not enabled then don't return anything.
34
35 procedure get_default_credit_card_info(
36 p_api_version IN NUMBER,
37 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
38 p_commit IN VARCHAR2 := FND_API.G_FALSE,
39 p_cust_account_id IN NUMBER,
40 p_party_id IN NUMBER,
41 p_mini_site_id IN NUMBER,
42 x_return_status OUT NOCOPY VARCHAR2,
43 x_msg_count OUT NOCOPY NUMBER,
44 x_msg_data OUT NOCOPY VARCHAR2,
45 x_cc_assignment_id OUT NOCOPY NUMBER
46 );
47
48 -- This procedure updates the primary credit card id if it already exists,
49 -- it also sets the primary credit card id if it does not exists.
50
51 /*procedure set_primary_credit_card_id: mannamra: 11/14/2005 : Bug 4725304: This API has been modified to query
52 IBY schema*/
53
54
55 -- This procedure gets the primary credit card id if it already exists
56
57 procedure get_primary_credit_card_id(p_username IN VARCHAR2,
58 x_credit_card_id OUT NOCOPY NUMBER);
59
60
61 -- This procedure creates a new credit card by calling
62 -- arp_bank_pkg.process_bank_account. It also sets the
63 -- new credit card id as primary credit card if a primary
64 -- credit card id does not exists.
65
66 /*procedure create_credit_card : mannamra: 11/14/2005 : Bug 4725304: This API can be obsoleted because it is used to create a credit card in AP's
67 @ Bank Accouts' schema but going forward credit cards will be stored in
68 @ iPayment schema. IBE_PAYMENT_INT_PVT.saveCC() will be used to perform this
69 operation.*/
70
71
72 end ibe_customer_pvt;