1 PACKAGE CS_CREDIT_CARD_ASSIGNMENT AUTHID CURRENT_USER AS
2 /* $Header: csccasgs.pls 120.0 2010/09/06 10:10:59 spamujul noship $ */
3 PROCEDURE Create_Card_Wrapper(
4 p_commit IN VARCHAR2,
5 p_owner_id IN iby_creditcard.card_owner_id%TYPE,
6 p_holder_name IN iby_creditcard.chname%TYPE,
7 p_billing_address_id IN iby_creditcard.addressid%TYPE,
8 p_address_type IN VARCHAR2,
9 p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,
10 p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,
11 p_card_number IN iby_creditcard.ccnumber%TYPE,
12 p_expiry_date IN iby_creditcard.expirydate%TYPE,
13 p_instr_type IN iby_creditcard.instrument_type%TYPE,
14 p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,
15 p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,
16 p_issuer IN iby_creditcard.card_issuer_code%TYPE,
17 p_fi_name IN iby_creditcard.finame%TYPE,
18 p_single_use IN iby_creditcard.single_use_flag%TYPE,
19 p_info_only IN iby_creditcard.information_only_flag%TYPE,
20 p_purpose IN iby_creditcard.card_purpose%TYPE,
21 p_desc IN iby_creditcard.description%TYPE,
22 p_active_flag IN iby_creditcard.active_flag%TYPE,
23 p_inactive_date IN iby_creditcard.inactive_date%TYPE,
24 p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE,
25 p_attribute_category IN iby_creditcard.attribute_category%TYPE,
26 p_attribute1 IN iby_creditcard.attribute1%TYPE,
27 p_attribute2 IN iby_creditcard.attribute2%TYPE,
28 p_attribute3 IN iby_creditcard.attribute3%TYPE,
29 p_attribute4 IN iby_creditcard.attribute4%TYPE,
30 p_attribute5 IN iby_creditcard.attribute5%TYPE,
31 p_attribute6 IN iby_creditcard.attribute6%TYPE,
32 p_attribute7 IN iby_creditcard.attribute7%TYPE,
33 p_attribute8 IN iby_creditcard.attribute8%TYPE,
34 p_attribute9 IN iby_creditcard.attribute9%TYPE,
35 p_attribute10 IN iby_creditcard.attribute10%TYPE,
36 p_attribute11 IN iby_creditcard.attribute11%TYPE,
37 p_attribute12 IN iby_creditcard.attribute12%TYPE,
38 p_attribute13 IN iby_creditcard.attribute13%TYPE,
39 p_attribute14 IN iby_creditcard.attribute14%TYPE,
40 p_attribute15 IN iby_creditcard.attribute15%TYPE,
41 p_attribute16 IN iby_creditcard.attribute16%TYPE,
42 p_attribute17 IN iby_creditcard.attribute17%TYPE,
43 p_attribute18 IN iby_creditcard.attribute18%TYPE,
44 p_attribute19 IN iby_creditcard.attribute19%TYPE,
45 p_attribute20 IN iby_creditcard.attribute20%TYPE,
46 p_attribute21 IN iby_creditcard.attribute21%TYPE,
47 p_attribute22 IN iby_creditcard.attribute22%TYPE,
48 p_attribute23 IN iby_creditcard.attribute23%TYPE,
49 p_attribute24 IN iby_creditcard.attribute24%TYPE,
50 p_attribute25 IN iby_creditcard.attribute25%TYPE,
51 p_attribute26 IN iby_creditcard.attribute26%TYPE,
52 p_attribute27 IN iby_creditcard.attribute27%TYPE,
53 p_attribute28 IN iby_creditcard.attribute28%TYPE,
54 p_attribute29 IN iby_creditcard.attribute29%TYPE,
55 p_attribute30 IN iby_creditcard.attribute30%TYPE,
56 x_result_code OUT NOCOPY VARCHAR2,
57 x_return_status OUT NOCOPY VARCHAR2,
58 x_instr_id OUT NOCOPY iby_creditcard.instrid%TYPE,
59
p_cust_account_id IN iby_external_payers_all.cust_account_id%TYPE,
60 p_org_id IN iby_external_payers_all.org_id%TYPE,
61 p_org_type IN iby_external_payers_all.org_type%TYPE,
62 p_payment_function IN iby_external_payers_all.payment_function%TYPE,
63 x_assignment_id OUT NOCOPY NUMBER,
64
65 p_cust_accnt_site_id IN NUMBER
66 );
67 END CS_CREDIT_CARD_ASSIGNMENT;