1 PACKAGE ARP_AUTO_ACCOUNTING_BR AS
2 /* $Header: ARTEAABS.pls 120.2 2004/11/03 23:25:07 anukumar ship $ */
3
4 /* =======================================================================
5 | PUBLIC Data Types
6 * ======================================================================*/
7 SUBTYPE ae_sys_rec_type IS ARP_ACCT_MAIN.ae_sys_rec_type;
8
9 --
10 -- global error buffer
11 --
12 g_errorbuf VARCHAR2(1000);
13 g_error_buffer VARCHAR2(1000);
14
15 -- Public user-defined exceptions
16 --
17 no_ccid EXCEPTION;
18
19
20 ----------------------------------------------------------------------------
21 --
22 -- PROCEDURE NAME: do_autoaccounting
23 --
24 -- DECSRIPTION:
25 -- Server-side entry point for autoaccounting.
26 --
27 -- ARGUMENTS:
28 -- IN:
29 -- mode: May be I(nsert), U(pdate), D(elete), or (G)et
30 -- account_class: REC, UNPAIDREC, FACTOR, REMITTANCE
31 -- customer_trx_id: NULL if not applicable
32 -- request_id: NULL if not applicable
33 -- passed_ccid: Code comination ID to use if supplied
34 -- cust_trx_type_id (G)
35 -- receipt_method_id (G)
36 -- bank_account_id (G)
37 --
38 -- IN/OUT:
39 -- ccid
40 -- concat_segments
41 -- failure_count
42 --
43 -- OUT:
44 --
45 -- NOTES:
46 -- If mode is not (G)et, raises the exception
47 -- arp_auto_accounting.no_ccid if autoaccounting could not derive a
48 -- valid code combination. The public variable g_error_buffer is
49 -- populated for more information. In (G)et mode, check the value
50 -- assigned to p_ccid. If it is -1, then no ccid was found.
51 --
52 -- Raises the exception NO_DATA_FOUND if no rows were selected for
53 -- processing.
54 --
55 -- Exception raised if Oracle error.
56 -- App_exception is raised for all other fatal errors and a message
57 -- is put on the AOL stack. The public variable g_error_buffer is
58 -- populated for both types of errors.
59 --
60 -- HISTORY:
61 --
62 --
63 PROCEDURE do_autoaccounting ( p_mode IN VARCHAR2,
64 p_account_class IN VARCHAR2,
65 p_customer_trx_id IN NUMBER,
66 p_receivable_application_id IN NUMBER,
67 p_br_unpaid_ccid IN NUMBER,
68 p_cust_trx_type_id IN NUMBER,
69 p_site_use_id IN NUMBER,
70 p_receipt_method_id IN NUMBER,
71 p_bank_account_id IN NUMBER,
72 p_ccid IN OUT NOCOPY NUMBER,
73 p_concat_segments IN OUT NOCOPY VARCHAR2,
74 p_failure_count IN OUT NOCOPY NUMBER );
75
76 FUNCTION query_autoacc_def( p_account_class IN VARCHAR2,
77 p_table_name IN VARCHAR2 )
78 RETURN BOOLEAN;
79
80 FUNCTION search_glcc_for_ccid( p_system_info IN
81 arp_trx_global.system_info_rec_type,
82 p_segment_table IN fnd_flex_ext.SegmentArray,
83 p_segment_cnt IN BINARY_INTEGER )
84 RETURN BINARY_INTEGER ;
85
86 FUNCTION search_glcc_for_ccid( p_system_info IN
87 arp_trx_global.system_info_rec_type,
88 p_segment_table IN fnd_flex_ext.SegmentArray,
89 p_segment_cnt IN BINARY_INTEGER,
90 p_account_class IN
91 ra_cust_trx_line_gl_dist.account_class%type,
92 p_concat_segments IN VARCHAR2 )
93 RETURN BINARY_INTEGER;
94
95 PROCEDURE test_build_sql;
96 PROCEDURE init;
97
98 END ARP_AUTO_ACCOUNTING_BR;