[Home] [Help]
PACKAGE: APPS.JL_BR_SPED_DATA_EXTRACT_PKG
Source
1 PACKAGE JL_BR_SPED_DATA_EXTRACT_PKG AUTHID CURRENT_USER AS
2 /* $Header: jlbrases.pls 120.4 2011/02/07 13:07:03 mkandula ship $ */
3
4
5 --Globals for report parameters.
6
7
8 g_ledger_id GL_LEDGERS.LEDGER_ID%TYPE;
9 g_chart_of_accounts_id GL_LEDGERS.chart_of_accounts_id%TYPE;
10 g_accounting_type VARCHAR2(30); --represents 'Centralized' or 'Decentralized'
11 g_legal_entity_id XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE;
12 g_establishment_id XLE_ETB_PROFILES.ESTABLISHMENT_ID%TYPE;
13 g_period_name GL_PERIODS.PERIOD_NAME%TYPE;
14 g_start_date GL_PERIODS.START_DATE%TYPE;
15 g_end_date GL_PERIODS.END_DATE%TYPE;
16 g_adj_start_date GL_PERIODS.START_DATE%TYPE;
17 g_adj_end_date GL_PERIODS.END_DATE%TYPE;
18 g_special_situation_indicator VARCHAR2(30);
19 g_bookkeeping_type VARCHAR2(3);
20 g_participant_type JL_BR_SPED_PARTIC_CODES.PARTICIPANT_TYPE%TYPE;
21 g_accounting_segment_type VARCHAR2(30);
22 g_coa_mapping_id gl_coa_mappings.coa_mapping_id%TYPE;
23 g_balance_statement_request_id fnd_concurrent_requests.request_id%TYPE;
24 g_agglutination_code_source VARCHAR2(30);
25 g_income_statement_request_id fnd_concurrent_requests.request_id%TYPE;
26 g_journal_for_rtf NUMBER;
27 g_hash_code VARCHAR2(200); -- auxillary book
28 g_acct_stmt_ident VARCHAR2(200);
29 g_acct_stmt_header VARCHAR2(200);
30 g_gen_sped_text_file VARCHAR2(3);
31
32 g_inscription_source VARCHAR2(50);
33 g_le_state_reg_code VARCHAR2(100);
34 g_le_municipal_reg_code VARCHAR2(100);
35 g_state_tax_id VARCHAR2(100);
36 g_ebtax_state_reg_code VARCHAR2(100);
37 g_municipal_reg_tax_id VARCHAR2(100);
38 g_ebtax_municipal_reg_code VARCHAR2(100);
39
40 --Globals for other values
41
42 g_company_name VARCHAR2(250);
43 g_segment_attribute_type fnd_segment_attribute_values.segment_attribute_type%TYPE;
44 g_bsv_segment fnd_segment_attribute_values.application_column_name%TYPE;
45 g_account_segment fnd_segment_attribute_values.application_column_name%TYPE;
46 g_cost_center_segment fnd_segment_attribute_values.application_column_name%TYPE;
47
48 g_period_set_name gl_sets_of_books.period_set_name%TYPE;
49 g_accounted_period_type gl_sets_of_books.accounted_period_type%TYPE;
50 g_currency_code gl_sets_of_books.currency_code%TYPE;
51 g_account_value_set_id fnd_id_flex_segments.flex_value_set_id%TYPE;
52 g_cost_center_value_set_id fnd_id_flex_segments.flex_value_set_id%TYPE;
53
54 g_balance_statement_report_id rg_reports.report_id%TYPE;
55 g_income_statement_report_id rg_reports.report_id%TYPE;
56
57 g_ar_auxbook_exist number;
58 g_ap_auxbook_exist number;
59 g_ap_ar_auxbook_exist number;
60
61 g_account_qualifier_position NUMBER;
62 g_sped_qualifier_position NUMBER;
63 g_exclusion_qualifier_position NUMBER; --variable to capture SPED Exclusion qualifier position. added as part of new enhancement.
64 g_closing_period_flag VARCHAR2(1);
65 g_adjustment_period_name GL_PERIODS.PERIOD_NAME%TYPE;
66 g_adjustment_period_start_date GL_PERIODS.START_DATE%TYPE;
67 g_adjustment_period_end_date GL_PERIODS.END_DATE%TYPE;
68
69 --Globals for Conc Prg variables
70
71 g_concurrent_request_id NUMBER;
72 g_created_by NUMBER(15);
73 g_creation_date DATE;
74 g_last_updated_by NUMBER(15);
75 g_last_update_date DATE;
76 g_last_update_login NUMBER(15);
77
78
79 -- Globals for log
80
81 g_current_runtime_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
82 g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
83 g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
84 g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
85 g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
86 g_level_error CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
87 g_level_exception CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
88 g_error_buffer VARCHAR2(100);
89 g_debug_flag VARCHAR2(1);
90 g_pkg_name CONSTANT VARCHAR2(30) := 'JL_BR_SPED_DATA_EXTRACT';
91 g_module_name CONSTANT VARCHAR2(30) := 'JL_SPED';
92 g_errbuf VARCHAR2(2000);
93 g_retcode NUMBER;
94
95
96 PROCEDURE main ( errbuf OUT NOCOPY VARCHAR2,
97 retcode OUT NOCOPY NUMBER,
98 p_accounting_type VARCHAR2,
99 p_legal_entity_id XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE,
100 p_chart_of_accounts_id GL_SETS_OF_BOOKS.chart_of_accounts_id%TYPE,
101 p_ledger_id GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID%TYPE,
102 p_establishment_id XLE_ETB_PROFILES.ESTABLISHMENT_ID%TYPE,
103 p_is_special_situation VARCHAR2,
104 p_is_special_situation_dummy VARCHAR2,
105 p_is_special_situation_dummy1 VARCHAR2,
106 p_period_type VARCHAR2,
107 p_period_type_dummy VARCHAR2,
108 p_period_type_dummy1 VARCHAR2,
109 p_period_name GL_PERIOD_STATUSES.PERIOD_NAME%TYPE,
110 p_adjustment_period_name GL_PERIOD_STATUSES.PERIOD_NAME%TYPE,
111 p_special_situation_indicator VARCHAR2,
112 p_start_date VARCHAR2,
113 p_end_date VARCHAR2,
114 p_bookkeeping_type VARCHAR2,
115 p_bookkeeping_type_dummy VARCHAR2,
116 p_bookkeeping_type_dummy1 VARCHAR2,
117 p_bookkeeping_type_dummy2 VARCHAR2,
118 p_participant_type JL_BR_SPED_PARTIC_CODES.PARTICIPANT_TYPE%TYPE,
119 p_participant_type_dummy JL_BR_SPED_PARTIC_CODES.PARTICIPANT_TYPE%TYPE,
120 p_accounting_segment_type VARCHAR2,
121 p_coa_mapping_id VARCHAR2,
122 p_balance_statement_request_id fnd_concurrent_requests.request_id%TYPE,
123 p_income_statement_request_id fnd_concurrent_requests.request_id%TYPE,
124 p_agglutination_code_source VARCHAR2,
125 p_journal_for_rtf NUMBER,
126 p_acct_stmt_ident VARCHAR2,
127 p_acct_stmt_ident_dummy VARCHAR2,
128 p_acct_stmt_header VARCHAR2,
129 p_hash_code VARCHAR2, -- auxillary book
130 p_inscription_source VARCHAR2,
131 p_inscription_source_dummy varchar2,
132 p_inscription_source_dummy1 varchar2,
133 p_le_state_reg_code VARCHAR2,
134 p_le_municipal_reg_code VARCHAR2,
135 p_state_tax_id NUMBER,
136 p_ebtax_state_reg_code VARCHAR2,
137 p_municipal_reg_tax_id NUMBER,
138 p_ebtax_municipal_reg_code VARCHAR2,
139 p_revert_negative_journals VARCHAR2,
140 p_gen_sped_text_file VARCHAR2) ;
141 FUNCTION get_segment_value(ccid NUMBER,segment_code VARCHAR2) RETURN VARCHAR2;
142 FUNCTION get_account_type(p_flex_Value_id fnd_flex_values.flex_value_id%TYPE) RETURN VARCHAR2;
143 FUNCTION get_participant_code (p_je_header_id gl_je_headers.je_header_id%TYPE,
144 p_je_line_num gl_je_lines.je_line_num%TYPE,
145 p_journal_source gl_je_headers.je_source%TYPE,
146 p_je_line_ccid gl_je_lines.code_combination_id%TYPE,
147 p_third_party_id NUMBER,
148 p_third_party_site_id NUMBER) RETURN VARCHAR2;
149
150 END JL_BR_SPED_DATA_EXTRACT_PKG;
151
152