1 PACKAGE OE_PAYMENT_TRXN_UTIL AUTHID CURRENT_USER AS
2 /*$Header: OEXUPTXS.pls 120.8.12020000.3 2013/01/30 14:07:01 kadiraju ship $*/
3
4 g_CC_Security_Code_Use VARCHAR2(20); --Verify the length!
5 g_old_bill_to_site NUMBER := null;
6
7 Procedure Create_Payment_Trxn( p_header_id IN NUMBER,
8 P_line_id IN NUMBER,
9 p_cust_id IN NUMBER,
10 P_site_use_id IN NUMBER,
11 P_payment_trx_id IN NUMBER,
12 P_payment_type_code IN VARCHAR2,
13 p_payment_number IN NUMBER, --Newly added
14 P_card_number IN VARCHAR2 DEFAULT NULL,
15 p_card_code IN VARCHAR2 DEFAULT NULL,
16 P_card_holder_name IN VARCHAR2 DEFAULT NULL,
17 P_exp_date IN VARCHAR2 DEFAULT NULL,
18 P_instrument_security_code IN VARCHAR2 DEFAULT NULL,
19 P_credit_card_approval_code IN VARCHAR2 DEFAULT NULL,
20 P_credit_card_approval_date IN DATE DEFAULT NULL,
21 p_instrument_id IN NUMBER DEFAULT NULL,
22 p_instrument_assignment_id IN NUMBER DEFAULT NULL,
23 p_receipt_method_id IN NUMBER,
24 p_update_card_flag IN VARCHAR2 DEFAULT 'N',
25 P_x_trxn_extension_id IN OUT NOCOPY NUMBER,
26 X_return_status OUT NOCOPY VARCHAR2,
27 X_msg_count OUT NOCOPY NUMBER,
28 X_msg_data OUT NOCOPY VARCHAR2);
29
30 Procedure Update_Payment_Trxn( p_header_id IN NUMBER,
31 P_line_id IN NUMBER,
32 p_cust_id IN NUMBER,
33 P_site_use_id IN NUMBER,
34 p_payment_trx_id IN NUMBER,
35 p_payment_type_code IN VARCHAR2,
36 p_payment_number IN NUMBER, --New
37 p_card_number IN VARCHAR2,
38 P_card_code IN VARCHAR2,
39 p_card_holder_name IN VARCHAR2,
40 p_exp_date IN DATE,
41 p_instrument_security_code IN VARCHAR2,
42 --Bug 7460481 starts
43 P_credit_card_approval_code IN VARCHAR2 DEFAULT NULL,
44 P_credit_card_approval_date IN DATE DEFAULT NULL,
45 --Bug 7460481 ends
46 p_instrument_id IN NUMBER DEFAULT NULL,
47 p_instrument_assignment_id IN NUMBER DEFAULT NULL,
48 p_receipt_method_id IN NUMBER,
49 p_update_card_flag IN VARCHAR2 DEFAULT 'N',
50 p_trxn_extension_id IN OUT NOCOPY NUMBER, --bug 4885313
51 X_return_status OUT NOCOPY VARCHAR2,
52 X_msg_count OUT NOCOPY NUMBER,
53 X_msg_data OUT NOCOPY VARCHAR2);
54
55 Procedure Copy_Payment_Trxn( p_header_id IN NUMBER,
56 P_line_id IN NUMBER,
57 p_cust_id IN NUMBER,
58 P_site_use_id IN NUMBER,
59 p_trxn_extension_id IN NUMBER,
60 x_trxn_extension_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 Procedure Get_Payment_Trxn_Info(p_header_id IN NUMBER,
66 P_trxn_extension_id IN NUMBER,
67 P_payment_type_code IN VARCHAR2,
68 X_credit_card_number OUT NOCOPY VARCHAR2,
69 X_credit_card_holder_name OUT NOCOPY VARCHAR2,
70 X_credit_card_expiration_date OUT NOCOPY VARCHAR2,
71 X_credit_card_code OUT NOCOPY VARCHAR2,
72 X_credit_card_approval_code OUT NOCOPY VARCHAR2,
73 X_credit_card_approval_date OUT NOCOPY VARCHAR2,
74 X_bank_account_number OUT NOCOPY VARCHAR2,
75 --X_check_number OUT NOCOPY VARCHAR2,
76 X_instrument_security_code OUT NOCOPY VARCHAR2,
77 X_instrument_id OUT NOCOPY NUMBER,
78 X_instrument_assignment_id OUT NOCOPY NUMBER,
79 X_return_status OUT NOCOPY VARCHAR2,
80 X_msg_count OUT NOCOPY NUMBER,
81 X_msg_data OUT NOCOPY VARCHAR2);
82 PROCEDURE Delete_Payment_Trxn
83 (
84 p_header_id IN NUMBER,
85 p_line_id IN NUMBER,
86 p_payment_number IN NUMBER,
87 x_return_status OUT NOCOPY VARCHAR2,
88 x_msg_count OUT NOCOPY NUMBER,
89 x_msg_data OUT NOCOPY VARCHAR2,
90 p_trxn_extension_id IN NUMBER,
91 P_site_use_id IN NUMBER
92 );
93
94
95 FUNCTION Get_CC_Security_Code_Use RETURN VARCHAR2;
96 FUNCTION Get_Settled_Flag(p_Trxn_Extension_Id Number) RETURN VARCHAR2;
97 --CC Reversal ER#16014135 Start
98 PROCEDURE Reverse_CreditCard_Auth
99 ( p_header_id IN NUMBER
100 , p_line_id IN NUMBER DEFAULT NULL
101 , p_msg_count OUT NOCOPY NUMBER
102 , p_msg_data OUT NOCOPY VARCHAR2
103 , p_return_status OUT NOCOPY VARCHAR2
104 , p_new_trxn_extension_id IN NUMBER DEFAULT NULL
105 );
106 --CC Reversal ER#16014135 End
107
108 END OE_PAYMENT_TRXN_UTIL;