[Home] [Help]
PACKAGE: APPS.ASO_PAYMENT_INT
Source
1 PACKAGE ASO_PAYMENT_INT AUTHID CURRENT_USER as
2 /* $Header: asoipays.pls 120.5 2010/05/28 08:38:29 akushwah ship $ */
3 -- Start of Comments
4 -- Package name : ASO_PAYMENT_INT
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 -- Record Type:
11 -- CC_TRXN_REC_TPYE
12 -- CC_TRXN_OUT _REC_TYPE
13
14 TYPE CC_Trxn_Rec_Type IS RECORD
15 (
16 merchant_id VARCHAR2(80),
17 credit_card_code VARCHAR2(80),
18 credit_card_num VARCHAR2(80),
19 credit_card_expiration_date DATE,
20 credit_card_holder_name VARCHAR2(80),
21 invoice_to_address1 VARCHAR2(80) := FND_API.G_MISS_CHAR,
22 invoice_to_address2 VARCHAR2(80) := FND_API.G_MISS_CHAR,
23 invoice_to_address3 VARCHAR2(80) := FND_API.G_MISS_CHAR,
24 invoice_to_address4 VARCHAR2(80) := FND_API.G_MISS_CHAR,
25 invoice_to_city VARCHAR2(80) := FND_API.G_MISS_CHAR,
26 invoice_to_county VARCHAR2(80) := FND_API.G_MISS_CHAR,
27 invoice_to_state VARCHAR2(80) := FND_API.G_MISS_CHAR,
28 invoice_to_country VARCHAR2(80) := FND_API.G_MISS_CHAR,
29 invoice_to_PostalCode VARCHAR2(40) := FND_API.G_MISS_CHAR,
30 tangible_id VARCHAR2(80),
31 tangible_amount NUMBER,
32 currency_code VARCHAR2(80),
33 pmt_mode VARCHAR2(30) := FND_API.G_MISS_CHAR,
34 Settlement_date DATE := FND_API.G_MISS_DATE,
35 check_flag VARCHAR2(30) := FND_API.G_MISS_CHAR,
36 auth_type VARCHAR2(80),
37 RefInfo VARCHAR2(80),
38 cvv2 VARCHAR2(10) := FND_API.G_MISS_CHAR
39 );
40
41 G_MISS_CC_Trxn_Rec_Type CC_Trxn_Rec_Type;
42
43
44 TYPE CC_Trxn_Out_Rec_Type IS RECORD
45 (
46 status NUMBER,
47 err_code VARCHAR2(80),
48 err_message VARCHAR2(255),
49 NLS_LANG VARCHAR2(80),
50 trxn_id NUMBER,
51 trxn_date DATE,
52 auth_code VARCHAR2(80),
53 err_location NUMBER,
54 bep_err_code VARCHAR2(80),
55 bep_err_message VARCHAR2(255)
56 );
57
58 G_MISS_CC_Trxn_Out_Rec_Type CC_Trxn_Out_Rec_Type;
59
60
61
62 FUNCTION Get_payment_term_id( p_qte_header_id NUMBER,
63 p_qte_line_id NUMBER
64 )
65 RETURN NUMBER;
66
67 PROCEDURE create_iby_payment(p_payment_rec IN aso_quote_pub.payment_rec_type,
68 db_payment_rec IN aso_quote_pub.payment_rec_type := aso_quote_pub.G_MISS_PAYMENT_REC,
69 p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,
70 x_payment_rec OUT NOCOPY aso_quote_pub.payment_rec_type,
71 x_return_status OUT NOCOPY varchar2,
72 x_msg_count OUT NOCOPY number,
73 x_msg_data OUT NOCOPY varchar2);
74
75
76 PROCEDURE create_payment_row(p_payment_rec IN aso_quote_pub.payment_rec_type,
77 x_payment_rec OUT NOCOPY aso_quote_pub.payment_rec_type,
78 x_return_status OUT NOCOPY varchar2,
79 x_msg_count OUT NOCOPY number,
80 x_msg_data OUT NOCOPY varchar2);
81
82 PROCEDURE update_payment_row(p_payment_rec IN aso_quote_pub.payment_rec_type,
83 x_payment_rec OUT NOCOPY aso_quote_pub.payment_rec_type,
84 x_return_status OUT NOCOPY varchar2,
85 x_msg_count OUT NOCOPY number,
86 x_msg_data OUT NOCOPY varchar2);
87
88 PROCEDURE delete_payment_row(p_payment_rec IN aso_quote_pub.payment_rec_type,
89 x_return_status OUT NOCOPY varchar2,
90 x_msg_count OUT NOCOPY number,
91 x_msg_data OUT NOCOPY varchar2);
92
93 PROCEDURE PURGE_ASO_PAYMENTS_DATA; -- Code added for Bug 9746746
94
95 End ASO_PAYMENT_INT;
96