1 PACKAGE arp_xla_extract_main_pkg AUTHID CURRENT_USER AS
2 /* $Header: ARPXLEXS.pls 120.8.12010000.4 2009/02/23 22:45:25 ankausha ship $ */
3
4 max_array_size NUMBER := 999;
5
6 --{Get GL segment info
7 TYPE seg_qual_table IS TABLE OF VARCHAR2(200) INDEX BY BINARY_INTEGER;
8
9 pg_bal_qual seg_qual_table;
10 pg_nat_qual seg_qual_table;
11
12 FUNCTION the_segment_value(p_coa_id IN NUMBER,
13 p_qual_code IN VARCHAR2,
14 p_ccid IN NUMBER)
15 RETURN VARCHAR2;
16 --}
17
18 --{
19 pg_ed_trx seg_qual_table;
20 pg_uned_trx seg_qual_table;
21
22 FUNCTION ed_uned_trx(p_type IN VARCHAR2,
23 p_org_id IN NUMBER)
24 RETURN NUMBER;
25 --}
26 /*------------------------------------------------------+
27 | Procedure name : Extract |
28 +------------------------------------------------------+
29 | Parameter : accounting mode |
30 | D for Draft |
31 | F for final |
32 | |
33 | Purpose : Extract the AR accounting lines based |
34 | on xla events passed by XLA_EVENTS_GT |
35 | This routine is launched by XLA accounting |
36 | program in extract phase |
37 | |
38 | Modification history |
39 +------------------------------------------------------*/
40 --BUG#4387467
41 PROCEDURE extract(p_application_id IN NUMBER
42 ,p_accounting_mode IN VARCHAR2);
43
44 PROCEDURE extract(p_accounting_mode IN VARCHAR2);
45
46
47 /*------------------------------------------------------+
48 | Procedure name : Posting control id in postprocessing|
49 +------------------------------------------------------+
50 | Parameter : accounting mode |
51 | D for Draft |
52 | F for final |
53 | |
54 | Purpose : Stamping the posting control id in AR |
55 | AR posting entities only for Final mode. |
56 | This is used in the post acctg process |
57 | |
58 | Modification history |
59 +------------------------------------------------------*/
60 --BUG#4387467
61 PROCEDURE postprocessing(p_application_id IN NUMBER
62 ,p_accounting_mode IN VARCHAR2);
63
64 PROCEDURE flag_the_posting_id(p_accounting_mode IN VARCHAR2);
65
66 /*-----------------------------------------------+
67 | Stub of postaccounting for future enhancement |
68 +-----------------------------------------------*/
69 PROCEDURE postaccounting
70 (p_application_id IN NUMBER,
71 p_ledger_id IN NUMBER,
72 p_process_category IN VARCHAR2,
73 p_end_date IN DATE,
74 p_accounting_mode IN VARCHAR2,
75 p_valuation_method IN VARCHAR2,
76 p_security_id_int_1 IN NUMBER,
77 p_security_id_int_2 IN NUMBER,
78 p_security_id_int_3 IN NUMBER,
79 p_security_id_char_1 IN NUMBER,
80 p_security_id_char_2 IN NUMBER,
81 p_security_id_char_3 IN NUMBER,
82 p_report_request_id IN NUMBER);
83
84
85
86 /*------------------------------------------------------+
87 | Procedure name : Document locking in pre accounting |
88 +------------------------------------------------------+
89 | Parameter : None |
90 | |
91 | Purpose : Locking the records concerned in a |
92 | particular accounting program process. |
93 | |
94 | Modification history |
95 +------------------------------------------------------*/
96 --BUG#4387467
97 PROCEDURE preaccounting
98 (p_application_id IN NUMBER
99 ,p_ledger_id IN NUMBER
100 ,p_process_category IN VARCHAR2
101 ,p_end_date IN DATE
102 ,p_accounting_mode IN VARCHAR2
103 ,p_valuation_method IN VARCHAR2
104 ,p_security_id_int_1 IN NUMBER
105 ,p_security_id_int_2 IN NUMBER
106 ,p_security_id_int_3 IN NUMBER
107 ,p_security_id_char_1 IN VARCHAR2
108 ,p_security_id_char_2 IN VARCHAR2
109 ,p_security_id_char_3 IN VARCHAR2
110 ,p_report_request_id IN NUMBER);
111
112 -- This is stub out, keep this in order not to break the current code
113 PROCEDURE lock_documents_for_xla;
114
115
116 /*------------------------------------------------------+
117 | Workflow subscription |
118 +------------------------------------------------------*/
119 ----------------------------------------
120 -- Procedure name : locking_status
121 ----------------------------------------
122 -- Parameter : Workflow rule function subscription
123 -- standard parameters.
124 -- Purpose : Allow the procedure extract
125 -- to be called in Workflow 2.6
126 -- History : Is replaced by preaccounting procedure
127 ----------------------------------------
128 FUNCTION locking_status
129 (p_subscription_guid IN RAW,
130 p_event IN OUT NOCOPY wf_event_t)
131 RETURN VARCHAR2;
132
133 ----------------------------------
134 -- Procedure name : extract_status
135 ----------------------------------
136 -- Parameter : Workflow rule function subscription
137 -- standard parameters.
138 -- Purpose : Allow the procedure extract
139 -- to be called in Workflow 2.6
140 -- Modification history:Is replaced by extract procedure
141 ----------------------------------
142 FUNCTION extract_status
143 (p_subscription_guid IN RAW,
144 p_event IN OUT NOCOPY wf_event_t)
145 RETURN VARCHAR2;
146
147 --------------------------------------
148 -- Procedure name : posting_ctl_status
149 --------------------------------------
150 -- Parameter : Workflow rule function subscription
151 -- standard parameters.
152 -- Purpose : Allow the procedure flag_the_posting_id
153 -- to be called in Workflow 2.6
154 -- Modification history: Is replaced by postprocessing
155 ------------------------------------------------------
156 FUNCTION posting_ctl_status
157 (p_subscription_guid IN RAW,
158 p_event IN OUT NOCOPY wf_event_t)
159 RETURN VARCHAR2;
160
161 ------------------------
162 -- Extract procedures --
163 ------------------------
164 PROCEDURE load_header_data_ctlgd(p_application_id IN NUMBER DEFAULT 222);
165 PROCEDURE load_header_data_adj(p_application_id IN NUMBER DEFAULT 222);
166 PROCEDURE load_header_data_crh(p_application_id IN NUMBER DEFAULT 222);
167 PROCEDURE load_header_data_th(p_application_id IN NUMBER DEFAULT 222);
168 PROCEDURE load_line_data_ctlgd(p_application_id IN NUMBER DEFAULT 222);
169 PROCEDURE load_line_data_adj(p_application_id IN NUMBER DEFAULT 222);
170 PROCEDURE load_line_data_crh(p_application_id IN NUMBER DEFAULT 222);
171 PROCEDURE load_line_data_th(p_application_id IN NUMBER DEFAULT 222);
172 PROCEDURE load_line_data_crh_mf(p_application_id IN NUMBER DEFAULT 222);
173 PROCEDURE load_line_data_app_to_trx(p_application_id IN NUMBER DEFAULT 222);
174 PROCEDURE load_line_data_app_from_cr(p_application_id IN NUMBER DEFAULT 222);
175 PROCEDURE load_line_data_app_from_cm(p_application_id IN NUMBER DEFAULT 222);
176 PROCEDURE load_line_data_app_unid(p_application_id IN NUMBER DEFAULT 222);
177 PROCEDURE load_line_data_mcd(p_application_id IN NUMBER DEFAULT 222);
178
179 -----------------------------
180 -- Function get_glr_ccid
181 -- bug 7694448
182 -----------------------------
183 -- Parameter : p_ra_id, p_gain_loss_identifier
184 -- Purpose : fetch the ccid for exch_gain, exch_loss depending
185 -- on the input parameter gain_loss_identifier (possible
186 -- values EXCH_GAIN,EXCH_LOSS)
187 -- for a given receivable_application_id using caching
188 -- to overcome performance bottlenecks
189 -------------------------------------------------------------------
190 FUNCTION get_glr_ccid
191 ( p_ra_id IN NUMBER, p_gain_loss_identifier in VARCHAR) RETURN NUMBER;
192
193 END;