1 PACKAGE ARP_CORRECT_CC_ERRORS AUTHID CURRENT_USER AS
2 /*$Header: ARCCCORS.pls 120.1.12010000.2 2009/01/28 02:55:26 vpusulur ship $ */
3
4 PROCEDURE cc_auto_correct(
5 errbuf IN OUT NOCOPY VARCHAR2,
6 retcode IN OUT NOCOPY VARCHAR2,
7 p_request_id IN NUMBER,
8 p_mode IN VARCHAR2);
9
10 PROCEDURE cc_auto_correct_cover(p_request_id IN NUMBER,
11 p_mode IN VARCHAR2);
12
13 PROCEDURE obtain_alternate_payment(p_cc_trx_id IN NUMBER,
14 p_cc_trx_category IN VARCHAR2,
15 p_error_notes IN VARCHAR2);
16
17 PROCEDURE reauthorize(p_cc_trx_id IN NUMBER,
18 p_cc_trx_category IN VARCHAR2,
19 p_payment_trxn_extension_id IN NUMBER,
20 p_error_notes IN VARCHAR2);
21
22 PROCEDURE retry(p_cc_trx_id IN NUMBER,
23 p_cc_trx_category IN VARCHAR2,
24 p_payment_trxn_extension_id IN NUMBER,
25 p_error_notes IN VARCHAR2);
26 PROCEDURE lock_table_nowait(p_key IN NUMBER,
27 p_object_version_number IN NUMBER DEFAULT NULL,
28 p_table_name IN VARCHAR2,
29 p_trx_number IN VARCHAR2);
30
31 PROCEDURE correct_funds_error(p_cc_trx_id IN NUMBER,
32 p_cc_trx_category IN VARCHAR2,
33 p_corrective_action In VARCHAR2,
34 p_instrument_number IN VARCHAR2,
35 p_expiration_date IN VARCHAR2,
36 p_error_notes IN VARCHAR2);
37
38 FUNCTION get_collector_name (
39 p_customer_id IN NUMBER,
40 p_customer_site_use_id IN NUMBER)
41 RETURN VARCHAR2;
42 FUNCTION cc_mapping_exist (
43 p_cc_error_code IN ar_cc_error_mappings.cc_error_code%TYPE,
44 p_cc_trx_category IN ar_cc_error_mappings.cc_trx_category%TYPE,
45 p_receipt_method_id IN ar_cc_error_mappings.receipt_method_id%TYPE)
46 RETURN VARCHAR2;
47 END ARP_CORRECT_CC_ERRORS;