[Home] [Help]
PACKAGE: APPS.JE_ES_MODELO_EXT_PKG
Source
1 PACKAGE je_es_modelo_ext_pkg
2 -- $Header: jeesmodeloexts.pls 120.4.12010000.2 2008/08/04 12:26:33 vgadde ship $
3 AS
4
5 FUNCTION before_Report RETURN BOOLEAN;
6
7 FUNCTION after_Report RETURN BOOLEAN;
8
9 FUNCTION format_amount (p_amount IN NUMBER ) RETURN CHAR;
10
11 P_REPORT_NAME VARCHAR2(30);
12 P_VAT_REP_ENTITY_ID NUMBER;
13 P_TAX_YEAR NUMBER;
14 P_TAX_PERIOD VARCHAR2(20);
15 P_MODELO VARCHAR2(20);
16 P_SOURCE VARCHAR2(20);
17 P_CONTACT_TEL VARCHAR2(150);
18 P_CONTACT_NAME VARCHAR2(150);
19 P_TAX_OFFICE VARCHAR2(150); --Applicable if modelo = 349
20 P_CONTACT_TEL_CODE VARCHAR2(150); --Applicable if modelo = 415
21 P_REFERENCE_NUMBER VARCHAR2(150); --Applicable if modelo = 347, 349
22 P_MAIN_ACTIVITY VARCHAR2(150); --Applicable if modelo = 415
23 P_MAIN_ACTIVITY_CD VARCHAR2(150); --Applicable if modelo = 415
24 P_SECOND_ACTIVITY VARCHAR2(150); --Applicable if modelo = 415
25 P_SECOND_ACTIVITY_CD VARCHAR2(150); --Applicable if modelo = 415
26 P_TOTAL_PURCHASES VARCHAR2(150); --Applicable if modelo = 415
27 P_TOTAL_SALES VARCHAR2(150); --Applicable if modelo = 415
28 P_TAX_OFF_REG_CODES VARCHAR2(150); --Applicable if modelo = 415
29 P_MEDIUM VARCHAR2(150); --Applicable if modelo = 347
30 P_FROM_PERIOD gl_periods.period_name%type; -- Applicable for modelo=349 AR for Annual reports
31 P_TO_PERIOD gl_periods.period_name%type; -- Applicable for modelo=349 AR for Annual reports
32 P_DISPLAY_PERIOD varchar2 (10); -- Applicable for modelo=349 AR for Annual reports
33 --
34 P_FORMAT_TYPE VARCHAR2(150); -- 349
35 P_PRV_REFERENCE_NUMBER VARCHAR2(150);
36 --
37 P_MIN_VALUE NUMBER;
38 --
39 P_REC_COUNT NUMBER;
40 --
41 P_ORG_ID NUMBER;
42
43 END je_es_modelo_ext_pkg;