1 PACKAGE xla_accounting_pub_pkg AUTHID CURRENT_USER AS
2 -- $Header: xlaappub.pkh 120.8 2008/01/01 15:22:00 svellani ship $
3 /*===========================================================================+
4 | Copyright (c) 2001-2002 Oracle Corporation |
5 | Redwood Shores, CA, USA |
6 | All rights reserved. |
7 +============================================================================+
8 | PACKAGE NAME |
9 | xla_accounting_pub_pkg |
10 | |
11 | DESCRIPTION |
12 | Package specification for the accounting Prgram that contains public |
13 | APIs. |
14 | |
15 | HISTORY |
16 | 11/08/2002 S. Singhania Created |
17 | 07/22/2003 S. Singhania Added NOCOPY hint to the OUT parameters|
18 | 08/05/2003 S. Singhania Added P_ENTITY_ID and P_ACCOUNTING_FLAG|
19 | to ACCOUNTING_PROGRAM_DOCUMENT |
20 | 09/22/2003 S. Singhania Added p_source_application to the API |
21 | ACCOUNTING_PROGRAM_BATCH |
22 | 10/14/2003 S. Singhania Added semicolon to the EXIT statement. |
23 | (Bug # 3165900) |
24 | 04/27/2005 V. Kumar Bug 4323078. Overloaded the procedure |
25 | accounting_program_document |
26 +===========================================================================*/
27
28 --============================================================================
29 --
30 --
31 --
32 --============================================================================
33 PROCEDURE accounting_program_batch
34 (p_source_application_id IN NUMBER
35 ,p_application_id IN NUMBER
36 ,p_ledger_id IN NUMBER
37 ,p_process_category IN VARCHAR2
38 ,p_end_date IN DATE
39 ,p_accounting_flag IN VARCHAR2
40 ,p_accounting_mode IN VARCHAR2
41 ,p_error_only_flag IN VARCHAR2
42 ,p_transfer_flag IN VARCHAR2
43 ,p_gl_posting_flag IN VARCHAR2
44 ,p_gl_batch_name IN VARCHAR2
45 ,p_valuation_method IN VARCHAR2
46 ,p_security_id_int_1 IN NUMBER
47 ,p_security_id_int_2 IN NUMBER
48 ,p_security_id_int_3 IN NUMBER
49 ,p_security_id_char_1 IN VARCHAR2
50 ,p_security_id_char_2 IN VARCHAR2
51 ,p_security_id_char_3 IN VARCHAR2
52 ,p_accounting_batch_id OUT NOCOPY NUMBER
53 ,p_errbuf OUT NOCOPY VARCHAR2
54 ,p_retcode OUT NOCOPY NUMBER);
55
56
57 --============================================================================
58 --
59 --
60 --
61 --============================================================================
62 PROCEDURE accounting_program_document
63 (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
64 ,p_application_id IN NUMBER DEFAULT NULL
65 ,p_entity_id IN NUMBER
66 ,p_accounting_flag IN VARCHAR2 DEFAULT 'Y'
67 ,p_accounting_mode IN VARCHAR2
68 ,p_transfer_flag IN VARCHAR2
69 ,p_gl_posting_flag IN VARCHAR2
70 ,p_offline_flag IN VARCHAR2
71 ,p_accounting_batch_id OUT NOCOPY NUMBER
72 ,p_errbuf OUT NOCOPY VARCHAR2
73 ,p_retcode OUT NOCOPY NUMBER
74 ,p_request_id OUT NOCOPY NUMBER);
75
76 --============================================================================
77 --
78 -- Overloaded with extra valuation_method parameter
79 --
80 --============================================================================
81 PROCEDURE accounting_program_document
82 (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
83 ,p_application_id IN NUMBER DEFAULT NULL
84 ,p_valuation_method IN VARCHAR2
85 ,p_entity_id IN NUMBER
86 ,p_accounting_flag IN VARCHAR2 DEFAULT 'Y'
87 ,p_accounting_mode IN VARCHAR2
88 ,p_transfer_flag IN VARCHAR2
89 ,p_gl_posting_flag IN VARCHAR2
90 ,p_offline_flag IN VARCHAR2
91 ,p_accounting_batch_id OUT NOCOPY NUMBER
92 ,p_errbuf OUT NOCOPY VARCHAR2
93 ,p_retcode OUT NOCOPY NUMBER
94 ,p_request_id OUT NOCOPY NUMBER);
95
96 --============================================================================
97 --
98 --
99 --
100 --============================================================================
101 PROCEDURE accounting_program_doc_batch
102 (p_application_id IN INTEGER
103 ,p_accounting_mode IN VARCHAR2
104 ,p_gl_posting_flag IN VARCHAR2
105 ,p_accounting_batch_id IN OUT NOCOPY INTEGER
106 ,p_errbuf IN OUT NOCOPY VARCHAR2
107 ,p_retcode IN OUT NOCOPY INTEGER
108 );
109
110 --============================================================================
111 --
112 --
113 --
114 --============================================================================
115 PROCEDURE accounting_program_events
116 (p_application_id IN INTEGER
117 ,p_accounting_mode IN VARCHAR2
118 ,p_gl_posting_flag IN VARCHAR2
119 ,p_accounting_batch_id IN OUT NOCOPY INTEGER
120 ,p_errbuf IN OUT NOCOPY VARCHAR2
121 ,p_retcode IN OUT NOCOPY INTEGER
122 );
123
124 FUNCTION is_historic_upgrade_running(p_ledger_id IN NUMBER)
125 RETURN BOOLEAN;
126
127 END xla_accounting_pub_pkg; -- end of package spec.