1 PACKAGE xla_retrive_ccid_pkg AUTHID CURRENT_USER AS
2 /* $Header: xlarccid.pkh 120.1.12010000.2 2009/08/05 12:40:07 karamakr noship $
3 ===========================================================================+
4 | Copyright (c) 2001-2002 Oracle Corporation |
5 | Redwood Shores, CA, USA |
6 | All rights reserved. |
7 +============================================================================+
8 | PACKAGE NAME |
9 | xla_retrive_ccid_pkg |
10 | |
11 | DESCRIPTION |
12 | Package specification for the Retrive CCID's Program. |
13 | |
14 | HISTORY |
15 | 04/08/2008 T.Venkata Vamsi Krishna Created |
16 | |
17 +===========================================================================*/
18 TYPE t_array_number IS TABLE OF NUMBER
19 INDEX BY BINARY_INTEGER;
20
21 TYPE t_array_ccid IS TABLE OF NUMBER
22 INDEX BY BINARY_INTEGER;
23
24 PROCEDURE get_ccid_information (
25 errbuf OUT NOCOPY VARCHAR2,
26 retcode OUT NOCOPY VARCHAR2,
27 p_application_id IN NUMBER,
28 p_acc_batch_id IN NUMBER,
29 p_ledger_id IN NUMBER,
30 p_parent_request_id IN NUMBER
31 );
32
33 PROCEDURE get_thread_ccid_inf (
34 p_min_num IN NUMBER,
35 p_max_num IN NUMBER,
36 p_out_ccid OUT NOCOPY t_xla_array_ccid_inf,
37 p_application_id IN NUMBER,
38 p_acc_batch_id IN NUMBER,
39 p_ledger_id IN NUMBER,
40 p_parent_request_id IN NUMBER
41 );
42
43 PROCEDURE get_ccid_seq (
44 p_coa_num IN NUMBER,
45 p_ccid_seq_out OUT NOCOPY t_xla_array_ccid_seq_inf
46 );
47
48 PROCEDURE collect_ccid_inf (
49 p_application_id IN NUMBER,
50 p_acc_batch_id IN NUMBER,
51 p_ledger_id IN NUMBER,
52 p_parent_request_id IN NUMBER,
53 p_parallel_processes IN NUMBER
54 );
55
56 PROCEDURE update_ccid_inf (
57 p_parent_request_id IN NUMBER,
58 p_from_ccid OUT NOCOPY NUMBER,
59 p_to_ccid OUT NOCOPY NUMBER,
60 p_ledger_id OUT NOCOPY NUMBER
61 );
62 END xla_retrive_ccid_pkg;