[Home] [Help]
PACKAGE: APPS.JG_ZZ_RTCE_DT_PKG
Source
1 PACKAGE JG_ZZ_RTCE_DT_PKG 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 ;