1 PACKAGE ARP_PROCESS_CHARGEBACK AUTHID CURRENT_USER AS
2 /* $Header: ARCECBS.pls 120.6.12020000.2 2012/07/25 06:43:32 ashlkuma ship $*/
3
4 FUNCTION revision RETURN VARCHAR2;
5
6 PROCEDURE reverse_chargeback(
7 p_cb_ct_id IN ra_customer_trx.customer_trx_id%TYPE,
8 p_reversal_gl_date IN DATE,
9 p_reversal_date IN DATE,
10 p_module_name IN VARCHAR2,
11 p_module_version IN VARCHAR2,
12 p_type IN VARCHAR2 DEFAULT 'TRANSACTION');
13 --
14 FUNCTION validate_cb_reversal (
15 p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
16 p_ass_cr_id IN ar_adjustments.associated_cash_receipt_id%TYPE,
17 p_ct_count IN NUMBER, p_module_name IN VARCHAR2,
18 p_module_version IN VARCHAR2 ) RETURN BOOLEAN;
19 --
20 FUNCTION validate_cb_reversal ( p_ct_id IN ra_customer_trx.customer_trx_id%TYPE,
21 p_module_name IN VARCHAR2,
22 p_module_version IN VARCHAR2 ) RETURN BOOLEAN;
23
24 procedure create_chargeback(
25 p_amount IN NUMBER
26 , p_acctd_amount IN NUMBER
27 , p_trx_date IN DATE
28 , p_gl_id_ar_trade IN NUMBER
29 , p_gl_date IN DATE
30 , p_attribute_category IN VARCHAR2
31 , p_attribute1 IN VARCHAR2
32 , p_attribute2 IN VARCHAR2
33 , p_attribute3 IN VARCHAR2
34 , p_attribute4 IN VARCHAR2
35 , p_attribute5 IN VARCHAR2
36 , p_attribute6 IN VARCHAR2
37 , p_attribute7 IN VARCHAR2
38 , p_attribute8 IN VARCHAR2
39 , p_attribute9 IN VARCHAR2
40 , p_attribute10 IN VARCHAR2
41 , p_attribute11 IN VARCHAR2
42 , p_attribute12 IN VARCHAR2
43 , p_attribute13 IN VARCHAR2
44 , p_attribute14 IN VARCHAR2
45 , p_attribute15 IN VARCHAR2
46 , p_cust_trx_type_id IN NUMBER
47 , p_set_of_books_id IN NUMBER
48 , p_reason_code IN VARCHAR2
49 , p_comments IN VARCHAR2
50 , p_def_ussgl_trx_code_context IN VARCHAR2
51 , p_def_ussgl_transaction_code IN VARCHAR2
52 -- For AR_PAYMENT_SCHEDULES
53 , p_due_date IN DATE
54 , p_customer_id IN NUMBER
55 , p_cr_trx_number IN VARCHAR2
56 , p_cash_receipt_id IN NUMBER
57 , p_inv_trx_number IN VARCHAR2
58 , p_apply_date IN DATE
59 , p_receipt_gl_date IN DATE
60 -- We get rest of the TRX info with this ID
61 , p_app_customer_trx_id IN NUMBER
62 , p_app_terms_sequence_number IN NUMBER
63 , p_form_name IN VARCHAR2
64 , p_out_trx_number OUT NOCOPY VARCHAR2
65 , p_out_customer_trx_id OUT NOCOPY NUMBER
66 , p_doc_sequence_value IN OUT NOCOPY NUMBER
67 , p_doc_sequence_id IN OUT NOCOPY NUMBER
68 , p_exchange_rate_type IN VARCHAR2
69 , p_exchange_date IN DATE
70 , p_exchange_rate IN NUMBER
71 , p_currency_code IN VARCHAR2
72 , p_remit_to_address_id IN NUMBER DEFAULT 0
73 , p_bill_to_site_use_id IN NUMBER DEFAULT 0
74 , p_interface_header_context IN VARCHAR2 DEFAULT NULL
75 , p_interface_header_attribute1 IN VARCHAR2 DEFAULT NULL
76 , p_interface_header_attribute2 IN VARCHAR2 DEFAULT NULL
77 , p_interface_header_attribute3 IN VARCHAR2 DEFAULT NULL
78 , p_interface_header_attribute4 IN VARCHAR2 DEFAULT NULL
79 , p_interface_header_attribute5 IN VARCHAR2 DEFAULT NULL
80 , p_interface_header_attribute6 IN VARCHAR2 DEFAULT NULL
81 , p_interface_header_attribute7 IN VARCHAR2 DEFAULT NULL
82 , p_interface_header_attribute8 IN VARCHAR2 DEFAULT NULL
83 , p_interface_header_attribute9 IN VARCHAR2 DEFAULT NULL
84 , p_interface_header_attribute10 IN VARCHAR2 DEFAULT NULL
85 , p_interface_header_attribute11 IN VARCHAR2 DEFAULT NULL
86 , p_interface_header_attribute12 IN VARCHAR2 DEFAULT NULL
87 , p_interface_header_attribute13 IN VARCHAR2 DEFAULT NULL
88 , p_interface_header_attribute14 IN VARCHAR2 DEFAULT NULL
89 , p_interface_header_attribute15 IN VARCHAR2 DEFAULT NULL
90 , p_internal_notes IN VARCHAR2 DEFAULT NULL
91 , p_customer_reference IN VARCHAR2 DEFAULT NULL
92 , p_legal_entity_id IN NUMBER DEFAULT NULL
93 );
94
95 PROCEDURE update_chargeback (
96 p_customer_trx_id IN NUMBER
97 , p_comments IN VARCHAR2
98 , p_DEFAULT_USSGL_TRX_CODE IN VARCHAR2
99 , p_reason_code IN VARCHAR2
100 , p_ATTRIBUTE_CATEGORY IN VARCHAR2
101 , p_attribute1 IN VARCHAR2
102 , p_attribute2 IN VARCHAR2
103 , p_attribute3 IN VARCHAR2
104 , p_attribute4 IN VARCHAR2
105 , p_attribute5 IN VARCHAR2
106 , p_attribute6 IN VARCHAR2
107 , p_attribute7 IN VARCHAR2
108 , p_attribute8 IN VARCHAR2
109 , p_attribute9 IN VARCHAR2
110 , p_attribute10 IN VARCHAR2
111 , p_attribute11 IN VARCHAR2
112 , p_attribute12 IN VARCHAR2
113 , p_attribute13 IN VARCHAR2
114 , p_attribute14 IN VARCHAR2
115 , p_attribute15 IN VARCHAR2
116 );
117
118 PROCEDURE delete_chargeback (
119 p_customer_trx_id IN NUMBER
120 , p_apply_date IN DATE
121 , p_gl_date IN DATE
122 , p_module_name IN VARCHAR2
123 , p_module_version IN VARCHAR2
124 , p_type IN VARCHAR2 DEFAULT 'TRANSACTION');
125
126
127 PROCEDURE create_payment_extension(p_assignment_id IN NUMBER,
128 p_customer_id IN NUMBER,
129 p_receipt_method_id IN NUMBER,
130 p_org_id IN NUMBER,
131 p_customer_site_use_id IN NUMBER,
132 p_chargeback_number IN VARCHAR2,
133 p_customer_trx_id IN NUMBER,
134 x_msg_count OUT NOCOPY NUMBER,
135 x_msg_data OUT NOCOPY VARCHAR2,
136 x_return_status OUT NOCOPY VARCHAR2,
137 o_payment_trxn_extension_id OUT NOCOPY NUMBER,
138 p_chargeback_date IN DATE DEFAULT NULL);
139
140 END ARP_PROCESS_CHARGEBACK;