PACKAGE: APPS.JE_ITWHYE_AP_PKG

Source

1 PACKAGE je_itwhye_ap_pkg AUTHID CURRENT_USER AS
2 -- $Header: JEITWHYLS.pls 120.0.12010000.6 2009/09/02 14:11:31 suresing noship $
3 -- ****************************************************************************************
4 -- Copyright (c)  2000    Oracle            Product Development
5 -- All rights reserved
6 -- ****************************************************************************************
7 --
8 -- PROGRAM NAME
9 --  JEITWHYLS.pls
10 --
11 -- DESCRIPTION
12 --  This script creates the package Specfication of je_itwhye_ap_pkg Package
13 --  This package is used to Italian Withholding Yearly  extract Report. .
14 -- LAST UPDATE DATE   12-NOV-2008
15 --   Date the program has been modified for the last time
16 --
17 -- HISTORY
18 -- =======
19 --
20 -- VERSION DATE        AUTHOR(S)         DESCRIPTION
21 -- ------- ----------- ---------------   ------------------------------------
22 -- 1.0     12-NOV-2008 SURESH SINGH M Creation
23 --****************************************************************************************
24    g_num_request_id       NUMBER         := fnd_global.conc_request_id;
25    p_year                 VARCHAR2 (4);
26    p_order_by			  VARCHAR2 (10);
27    lp_order_by			  VARCHAR2 (32767);
28    errbuf				 VARCHAR2 (32767);
29    errcode				 NUMBER;
30    p_supplier_name_from   VARCHAR2 (240);
31    p_supplier_name_to     VARCHAR2 (240);
32    p_debug_switch         VARCHAR2 (1);
33    p_trace_switch         VARCHAR2 (1);
34    p_conc_request_id      NUMBER;
35    p_legal_entity_id      NUMBER;
36    p_org_id               NUMBER;
37    cp_set_of_books_id     NUMBER;
38    cp_currency_code       VARCHAR2 (10);
39    cp_currencycode        VARCHAR2 (10);
40    cp_comm_num			  VARCHAR2(60);
41    cp_year_start_date     DATE;
42    cp_year_end_date       DATE;
43    cp_precision           NUMBER;
44    cp_dummy_taxid         NUMBER;
45    g_irpef 				  VARCHAR2(10) ;
46    g_inps 				  VARCHAR2(10) ;
47    ln_amount_etrd   NUMBER;
48 
49    FUNCTION beforereport
50       RETURN BOOLEAN;
51 
52    FUNCTION afterreport
53       RETURN BOOLEAN;
54 
55    FUNCTION cp_precision_p
56       RETURN NUMBER;
57 
58    FUNCTION cp_irpef_p
59       RETURN VARCHAR2;
60 
61    FUNCTION cp_inps_p
62       RETURN VARCHAR2;
63 
64 	FUNCTION cp_start_date
65 	   RETURN VARCHAR2;
66 
67 	FUNCTION cp_end_date
68 	   RETURN VARCHAR2;
69 
70   PROCEDURE je_withholding(errbuf OUT NOCOPY VARCHAR2
71                                     ,errcode OUT NOCOPY NUMBER
72 									,p_legal_entity_id  NUMBER
73 									,cp_year_start_date VARCHAR2
74 									,cp_year_end_date VARCHAR2
75 									,p_order_by  VARCHAR2
76 									);
77 
78 END je_itwhye_ap_pkg;