[Home] [Help]
PACKAGE: APPS.JE_ES_MODELO_EXT_PKG
Source
1 PACKAGE je_es_modelo_ext_pkg
2 --$Header: jeesmodeloexts.pls 120.13.12020000.2 2012/07/18 12:57:58 rshergil noship $
3 AS
4
5 FUNCTION before_Report RETURN BOOLEAN;
6
7 FUNCTION after_Report RETURN BOOLEAN;
8
9 --Added for Modelo 340
10 --BUG 8946271
11 FUNCTION getKeyID (countryCode IN VARCHAR2) RETURN NUMBER ;
12
13
14 FUNCTION format_amount (p_amount IN NUMBER ) RETURN CHAR;
15
16 P_REPORT_NAME VARCHAR2(30);
17 P_VAT_REP_ENTITY_ID NUMBER;
18 P_TAX_YEAR NUMBER;
19 P_TAX_PERIOD VARCHAR2(20);
20 P_TAX_PERIOD_TO VARCHAR2(20);
21 P_MODELO VARCHAR2(20);
22 P_SOURCE VARCHAR2(20);
23 P_CONTACT_TEL VARCHAR2(150);
24 P_CONTACT_NAME VARCHAR2(150);
25 P_TAX_OFFICE VARCHAR2(150); --Applicable if modelo = 349
26 P_CONTACT_TEL_CODE VARCHAR2(150); --Applicable if modelo = 415
27 P_REFERENCE_NUMBER VARCHAR2(150); --Applicable if modelo = 347, 349
28 P_MAIN_ACTIVITY VARCHAR2(150); --Applicable if modelo = 415
29 P_MAIN_ACTIVITY_CD VARCHAR2(150); --Applicable if modelo = 415
30 P_SECOND_ACTIVITY VARCHAR2(150); --Applicable if modelo = 415
31 P_SECOND_ACTIVITY_CD VARCHAR2(150); --Applicable if modelo = 415
32 P_TOTAL_PURCHASES VARCHAR2(150); --Applicable if modelo = 415
33 P_TOTAL_SALES VARCHAR2(150); --Applicable if modelo = 415
34 P_TAX_OFF_REG_CODES VARCHAR2(150); --Applicable if modelo = 415
35 P_MEDIUM VARCHAR2(150); --Applicable if modelo = 347, 340
36 P_FROM_PERIOD gl_periods.period_name%type; -- Applicable for modelo=349 AR for Annual reports
37 P_TO_PERIOD gl_periods.period_name%type; -- Applicable for modelo=349 AR for Annual reports
38 P_DISPLAY_PERIOD varchar2 (10); -- Applicable for modelo=349 AR for Annual reports
39 --
40 P_FORMAT_TYPE VARCHAR2(150); -- 349
41 P_PRV_REFERENCE_NUMBER VARCHAR2(150);
42 --
43 P_MIN_VALUE VARCHAR2(20);-- NUMBER;
44 --
45 P_REC_COUNT NUMBER;
46 --
47 P_ORG_ID NUMBER;
48 -- FH: Added for Modelo 415
49 P_P_NIF VARCHAR2(10);
50 P_STREET_TYPE VARCHAR2(2);
51 P_STREET_NAME VARCHAR2(25);
52 P_STREET_NUMBER VARCHAR2(5);
53 P_POSTAL_CODE VARCHAR2(5);
54 P_CITY VARCHAR2(15);
55 P_VOUCHER VARCHAR2(13);
56
57 -- Added for Modelo 340
58 P_340_PERIOD VARCHAR2(2); -- Applicable if modelo = 340 for Annual Reports
59 P_ELEC_CODE VARCHAR2(16); -- Applicable if modelo = 340 for Annual Reports
60 P_340_START_DATE DATE; -- Applicable if modelo = 340 for Annual Reports
61 P_340_END_DATE DATE; -- Applicable if modelo = 340 for Annual Reports
62 P_SUBSTITUTION VARCHAR2(1); -- Applicable if modelo = 340 for Annual Reports
63 P_DRIVING_DATE VARCHAR2(30); -- Applicable if modelo = 340
64 -- Added for Modelo 347
65 P_MIN_CASH_AMOUNT_VALUE NUMBER;
66
67 -- BUG 9765740 Spanish Modelo 349 ESL EPL Changes
68 P_CHANGE_PERIODICITY VARCHAR2(1);
69 G_MIN_VALUE NUMBER;
70 -- Bug 13986531
71 P_COLLECTIVE VARCHAR2(1);
72 END je_es_modelo_ext_pkg;