PACKAGE: APPS.JG_ZZ_RTCE_DT_PKG

Source

1 PACKAGE JG_ZZ_RTCE_DT_PKG AUTHID CURRENT_USER AS
2 /* $Header: jgzztoarntrls.pls 120.4 2006/05/12 15:52:19 rpokkula ship $*/
3 
4   P_REPORTING_ENTITY_ID           number;
5   P_FISCAL_YEAR                   number;
6   P_DEC_TYPE                      varchar2(1);
7   P_MIN_INV_AMT                   number;
8   P_CALLED_FROM                   varchar2(40);
9   gv_country                      XLE_FIRSTPARTY_INFORMATION_V.country%type ;
10   gv_currency_code                gl_ledger_le_v.currency_code%type;
11   gv_tax_reg_num                  ar_system_parameters.tax_registration_number%type;
12   gn_legal_entity_id              number;
13   gv_repent_id_number             XLE_FIRSTPARTY_INFORMATION_V.registration_number%type;
14   gv_repent_trn                   JG_ZZ_VAT_REP_ENTITIES.TAX_REGISTRATION_NUMBER%type;
15   gd_period_start_date            date;
16   gd_period_end_date              date;
17   gv_repent_name                  XLE_FIRSTPARTY_INFORMATION_V.name%type;
18   gv_repent_address_line_1        XLE_FIRSTPARTY_INFORMATION_V.address_line_1%type ;
19   gv_repent_address_line_2        XLE_FIRSTPARTY_INFORMATION_V.address_line_2%type ;
20   gv_repent_address_line_3        XLE_FIRSTPARTY_INFORMATION_V.address_line_3%type ;
21   gv_repent_town_or_city          XLE_FIRSTPARTY_INFORMATION_V.town_or_city%type ;
22   gv_repent_postal_code           XLE_FIRSTPARTY_INFORMATION_V.postal_code%type ;
23   gv_repent_phone_number          varchar2(600);
24   gv_tax_office_location          xle_legalauth_v.city%type ;
25   gv_tax_office_number            xle_legalauth_v.address2%type ;
26   gv_tax_office_code              xle_legalauth_v.address3%type ;
27   gn_tot_customers                number;
28   gv_chart_of_accounts_id         number(15);
29   gv_ledger_id                    number(15);
30   gv_balancing_segment_value      jg_zz_vat_rep_entities.balancing_segment_value%type ;
31   gv_prev_fiscal_code             VARCHAR2(20) ;
32 
33   function  BeforeReport              return boolean  ;
34   function  get_bsv(ccid number)      return varchar2 ;
35   function  cf_currency_code          return varchar2 ;
36   function  cf_country                return varchar2 ;
37   function  cf_tax_reg_num            return varchar2 ;
38   function  cf_legal_entity_id        return number   ;
39   function  cf_repent_id_number       return varchar2 ;
40   function  cf_repent_trn             return varchar2 ;
41   function  cf_period_start_date      return date     ;
42   function  cf_period_end_date        return date     ;
43   function  cf_repent_name            return varchar2 ;
44   function  cf_repent_address_line_1  return varchar2 ;
45   function  cf_repent_address_line_2  return varchar2 ;
46   function  cf_repent_address_line_3  return varchar2 ;
47   function  cf_repent_town_or_city    return varchar2 ;
48   function  cf_repent_postal_code     return varchar2 ;
49   function  cf_repent_phone_number    return varchar2 ;
50   function  cf_tax_office_location    return varchar2 ;
51   function  cf_tax_office_number      return varchar2 ;
52   function  cf_tax_office_code        return varchar2 ;
53   function  cf_prev_fiscal_code       return varchar2 ;
54   function cf_total_amount(taxable_amount in number,
55                            tax_amount in number,
56                            exempt_amount in number,
57                            nontaxable_amount in number) return number  ;
58 END JG_ZZ_RTCE_DT_PKG ;