[Home] [Help]
PACKAGE: APPS.FV_SLA_UTL_PROCESSING_PKG
Source
1 PACKAGE fv_sla_utl_processing_pkg AUTHID CURRENT_USER AS
2 --$Header: FVXLAUTS.pls 120.8.12020000.4 2013/02/13 14:50:32 snama ship $
3
4 g_CurrentEventId NUMBER;
5 ----Ledger Variables
6 TYPE LedgerRecType IS RECORD
7 (
8 ledger_id gl_ledgers.ledger_id%TYPE,
9 ledger_name gl_ledgers.name%TYPE,
10 coaid gl_ledgers.chart_of_accounts_id%TYPE,
11 accounting_seg_num fnd_id_flex_segments.segment_num%TYPE,
12 accounting_seg_name fnd_id_flex_segments.application_column_name%TYPE,
13 balancing_seg_num fnd_id_flex_segments.segment_num%TYPE,
14 balancing_seg_name fnd_id_flex_segments.application_column_name%TYPE,
15 bfy_segment_num fnd_id_flex_segments.segment_num%TYPE,
16 bfy_segment_name fnd_id_flex_segments.application_column_name%TYPE,
17 fyr_segment_id NUMBER,
18 currency_code gl_ledgers.currency_code%TYPE
19 );
20 TYPE LedgerTabType IS TABLE OF LedgerRecType INDEX BY BINARY_INTEGER;
21
22 TYPE fv_ref_detail IS TABLE OF FV_EXTRACT_DETAIL_GT%ROWTYPE
23 INDEX BY BINARY_INTEGER;
24
25 TYPE OrgRecType IS RECORD
26 (
27 org_id fv_operating_units_all.org_id%TYPE,
28 dit_flag fv_operating_units_all.dit_flag%TYPE,
29 cash_account fv_operating_units_all.dit_confirm_cash_account%TYPE
30 );
31 TYPE OrgTabType IS TABLE OF OrgRecType INDEX BY BINARY_INTEGER;
32
33 TYPE BankRecType IS RECORD
34 (
35 bank_acct_use_id ce_bank_acct_uses_all.bank_acct_use_id%TYPE,
36 cash_bank_account_ccid ce_gl_accounts_ccid.ap_asset_ccid%TYPE,
37 cash_bank_natural_account VARCHAR2(100),
38 cash_clearing_ccid ce_gl_accounts_ccid.cash_clearing_ccid%TYPE,
39 cash_clearing_natural_account VARCHAR2(100)
40 );
41 TYPE BankTabType IS TABLE OF BankRecType INDEX BY BINARY_INTEGER;
42
43 PROCEDURE trace
44 (
45 p_level IN NUMBER,
46 p_procedure_name IN VARCHAR2,
47 p_debug_info IN VARCHAR2
48 );
49
50 PROCEDURE INSERT_FV_XLA_ACC_ERRORS
51 (
52 p_appli_s_name IN VARCHAR2
53 ,p_msg_name IN VARCHAR2
54 ,p_entity_id IN NUMBER
55 ,p_event_id IN NUMBER
56 ,p_ledger_id IN NUMBER
57 );
58 PROCEDURE stack_error
59 (
60 p_program_name IN VARCHAR2,
61 p_location IN VARCHAR2,
62 p_error_message IN VARCHAR2
63 );
64
65 PROCEDURE get_ledger_info
66 (
67 p_ledger_id IN NUMBER,
68 p_ledger_rec OUT NOCOPY LedgerRecType,
69 p_error_code OUT NOCOPY NUMBER,
70 p_error_desc OUT NOCOPY VARCHAR2
71 );
72
73 PROCEDURE get_segment_values
74 (
75 p_ledger_id IN NUMBER,
76 p_ccid IN NUMBER,
77 p_fund_value OUT NOCOPY VARCHAR2,
78 p_account_value OUT NOCOPY VARCHAR2,
79 p_bfy_value OUT NOCOPY VARCHAR2,
80 p_error_code OUT NOCOPY NUMBER,
81 p_error_desc OUT NOCOPY VARCHAR2
82 );
83
84 PROCEDURE get_fund_details
85 (
86 p_application_id IN NUMBER,
87 p_ledger_id IN NUMBER,
88 p_fund_value IN VARCHAR2,
89 p_gl_date IN DATE,
90 p_fund_category OUT NOCOPY fv_fund_parameters.fund_category%TYPE,
91 p_fund_status OUT NOCOPY VARCHAR2,
92 p_fund_time_frame OUT NOCOPY fv_treasury_symbols.time_frame%TYPE,
93 p_treasury_symbol_id OUT NOCOPY fv_fund_parameters.treasury_symbol_id%TYPE,
94 p_treasury_symbol OUT NOCOPY fv_treasury_symbols.treasury_symbol%TYPE,
95 p_no_pya_acct_flag OUT NOCOPY fv_treasury_symbols.no_pya_acct_flag%TYPE,
96 p_error_code OUT NOCOPY NUMBER,
97 p_error_desc OUT NOCOPY VARCHAR2
98 );
99
100 PROCEDURE get_fund_details
101 (
102 p_application_id IN NUMBER,
103 p_ledger_id IN NUMBER,
104 p_fund_value IN VARCHAR2,
105 p_gl_date IN DATE,
106 p_appor_category OUT NOCOPY fv_fund_parameters.fund_category%TYPE,
107 p_direct_or_reimb OUT NOCOPY fv_fund_parameters.fund_category%TYPE,
108 p_fund_status OUT NOCOPY VARCHAR2,
109 p_fund_time_frame OUT NOCOPY fv_treasury_symbols.time_frame%TYPE,
110 p_treasury_symbol_id OUT NOCOPY fv_fund_parameters.treasury_symbol_id%TYPE,
111 p_treasury_symbol OUT NOCOPY fv_treasury_symbols.treasury_symbol%TYPE,
112 p_no_pya_acct_flag OUT NOCOPY fv_treasury_symbols.no_pya_acct_flag%TYPE,
113 p_fund_type OUT NOCOPY fv_treasury_symbols.fund_type%TYPE,
114 p_error_code OUT NOCOPY NUMBER,
115 p_error_desc OUT NOCOPY VARCHAR2
116 );
117
118 PROCEDURE get_prior_year_status
119 (
120 p_application_id IN NUMBER,
121 p_ledger_id IN NUMBER,
122 p_bfy_value IN VARCHAR2,
123 p_gl_date IN DATE,
124 p_pya OUT NOCOPY VARCHAR2,
125 p_pya_type OUT NOCOPY VARCHAR2,
126 p_error_code OUT NOCOPY NUMBER,
127 p_error_desc OUT NOCOPY VARCHAR2
128 );
129
130 PROCEDURE dump_gt_table
131 (
132 p_fv_extract_detail IN fv_ref_detail,
133 p_error_code OUT NOCOPY NUMBER,
134 p_error_desc OUT NOCOPY VARCHAR2
135 );
136 PROCEDURE dump_gt_table
137 (
138 p_error_code OUT NOCOPY NUMBER,
139 p_error_desc OUT NOCOPY VARCHAR2
140 );
141 PROCEDURE init_extract_record
142 (
143 p_application_id IN NUMBER,
144 p_fv_extract_detail IN OUT NOCOPY fv_extract_detail_gt%ROWTYPE
145 );
146 PROCEDURE get_sla_doc_balances
147 (
148 p_called_from IN VARCHAR2,
149 p_trx_amount IN NUMBER,
150 p_ordered_amount IN NUMBER,
151 p_delivered_amount IN NUMBER,
152 p_billed_amount IN NUMBER,
153 p_4801_bal OUT NOCOPY NUMBER,
154 p_4802_bal OUT NOCOPY NUMBER,
155 p_4901_bal OUT NOCOPY NUMBER,
156 p_4902_bal OUT NOCOPY NUMBER,
157 p_error_code OUT NOCOPY NUMBER,
158 p_error_desc OUT NOCOPY VARCHAR2
159 );
160 PROCEDURE get_anticipated_ts_amt
161 (
162 p_ledger_id IN NUMBER,
163 p_gl_date IN DATE,
164 p_treasury_symbol_id IN VARCHAR2,
165 p_anticipated_amt OUT NOCOPY NUMBER,
166 p_error_code OUT NOCOPY NUMBER,
167 p_error_desc OUT NOCOPY VARCHAR2
168 );
169 PROCEDURE pya_processor
170 (
171 p_application_id IN NUMBER,
172 p_error_code OUT NOCOPY NUMBER,
173 p_error_desc OUT NOCOPY VARCHAR2
174 );
175 PROCEDURE check_errors
176 (
177 p_application_id IN NUMBER,
178 p_error_code OUT NOCOPY NUMBER,
179 p_error_desc OUT NOCOPY VARCHAR2
180 );
181 PROCEDURE get_org_info
182 (
183 p_org_id IN NUMBER,
184 p_org_rec OUT NOCOPY OrgRecType,
185 p_error_code OUT NOCOPY NUMBER,
186 p_error_desc OUT NOCOPY VARCHAR2
187 );
188 PROCEDURE get_bank_account_info
189 (
190 p_bank_acct_use_id IN NUMBER,
191 p_bank_rec OUT NOCOPY BankRecType,
192 p_error_code OUT NOCOPY NUMBER,
193 p_error_desc OUT NOCOPY VARCHAR2
194 );
195 FUNCTION get_bank_cash_account
196 (
197 p_bank_acct_use_id IN NUMBER
198 ) RETURN VARCHAR2;
199 PROCEDURE get_fed_non_fed_ind
200 (
201 p_cust_vend_id IN NUMBER,
202 p_cust_or_vend IN VARCHAR2,
203 p_fed_non_fed_ind OUT NOCOPY VARCHAR2,
204 p_error_code OUT NOCOPY NUMBER,
205 p_error_desc OUT NOCOPY VARCHAR2
206 );
207 /*
208 CLM Wrapper API
209 */
210 PROCEDURE get_fund_information
211 (
212 p_ledger_id IN NUMBER,
213 p_ccid IN NUMBER,
214 p_fiscal_year OUT NOCOPY NUMBER,
215 p_fund_cancellation_date OUT NOCOPY DATE,
216 p_fund_start_date OUT NOCOPY DATE,
217 p_fund_end_date OUT NOCOPY DATE,
218 p_non_annual_fund_flag OUT NOCOPY VARCHAR2,
219 p_error_code OUT NOCOPY NUMBER,
220 p_error_desc OUT NOCOPY VARCHAR2
221 );
222
223 END fv_sla_utl_processing_pkg; -- Package spec