1 PACKAGE JG_ZZ_JOURNAL_AR_PKG
2 /* $Header: jgzzjournalars.pls 120.10.12020000.2 2012/07/08 16:11:20 abhijsar ship $ */
3 AS
4 P_VAT_REP_ENTITY_ID NUMBER;
5 -- P_PERIOD VARCHAR2(10);
6 P_Period Jg_Zz_Vat_Rep_Status.Tax_Calendar_Period%Type;
7 P_Period_To Jg_Zz_Vat_Rep_Status.Tax_Calendar_Period%Type; -- Bug8267272
8 P_DOCUMENT_SEQUENCE_NAME_FROM VARCHAR2(100);
9 P_DOCUMENT_SEQUENCE_NAME_TO VARCHAR2(100);
10 P_CUSTOMER_NAME_FROM VARCHAR2(360);
11 P_CUSTOMER_NAME_TO VARCHAR2(360);
12 P_DETAIL_SUMMARY VARCHAR2(10);
13 P_TAX_TYPE VARCHAR2(100);
14 P_TAX_REGISTER_TYPE VARCHAR2(100);
15 P_SEQUENCE VARCHAR2(10);
16 P_VAT_REGISTER_ID NUMBER;
17 P_REPORT_NAME VARCHAR2(10);
18 P_BALANCING_SEGMENT VARCHAR2(100);
19 P_CHART_OF_ACCOUNT_ID NUMBER;
20 P_FIRST_PAGE_NUM NUMBER;
21 l_err_msg VARCHAR2(5000);
22
23 FUNCTION beforeReport RETURN BOOLEAN;
24 FUNCTION get_sequence_number RETURN NUMBER;
25 PROCEDURE jebedv07(p_vat_rep_entity_id IN NUMBER
26 ,P_Period In VARCHAR2
27 ,P_Document_Sequence_Name_From In VARCHAR2
28 ,p_document_sequence_name_to IN VARCHAR2
29 ,p_customer_name_from IN VARCHAR2
30 ,p_customer_name_to IN VARCHAR2
31 ,p_detail_summary IN VARCHAR2
32 ,x_err_msg OUT NOCOPY VARCHAR2);
33 PROCEDURE jeitarsv(p_vat_rep_entity_id IN NUMBER
34 ,p_period IN VARCHAR2
35 ,p_vat_register_id IN NUMBER
36 ,x_err_msg OUT NOCOPY VARCHAR2);
37 PROCEDURE jeitrdvr(p_vat_rep_entity_id IN NUMBER
38 ,p_period IN VARCHAR2
39 ,p_vat_register_id IN NUMBER
40 ,x_err_msg OUT NOCOPY VARCHAR2);
41 PROCEDURE jeesrrvr(p_vat_rep_entity_id IN NUMBER
42 ,p_period IN VARCHAR2
43 ,p_period_to IN VARCHAR2 -- Bug8267272 Start
44 ,p_tax_type IN VARCHAR2
45 ,p_tax_register_type IN VARCHAR2
46 ,p_sequence IN VARCHAR2
47 ,x_err_msg OUT NOCOPY VARCHAR2);
48
49 g_jeitrdvr_prel_alert_1 VARCHAR2(500) := 'The register has selected one or more transactions with dates earlier than '
50 || 'the last committed through-date of this register ';
51 g_jeitrdvr_prel_alert_2 VARCHAR2(500) := '. Please review those transactions before the final run to verify that they are '
52 || 'reported properly on the current register.';
53 g_jeitarsv_prel_alert_1 VARCHAR2(500) := 'The register has selected one or more transactions with dates earlier than '
54 || 'the last committed through-date of this register ';
55 g_jeitarsv_prel_alert_2 VARCHAR2(500) := '. Please review those transactions before the final run to verify that they are '
56 || 'reported properly on the current register.';
57
58 END JG_ZZ_JOURNAL_AR_PKG;