[Home] [Help]
PACKAGE: APPS.AR_AGG_VAT_STMT_PKG
Source
1 PACKAGE AR_AGG_VAT_STMT_PKG AUTHID CURRENT_USER
2 -- $Header: araggvatstmtps.pls 120.0 2007/12/13 10:03:17 sgudupat noship $
3 -- ****************************************************************************
4 -- Copyright (c) 2000 Oracle Solution Services (India) Product Development
5 -- All rights reserved
6 -- ****************************************************************************
7 --
8 -- PROGRAM NAME
9 -- araggvatstmtps.pls
10 --
11 -- DESCRIPTION
12 -- This script creates the package specification of ar_agg_vat_stmt_pkg.
13 -- This package is used to generate Aggregate VAT Statement.
14 --
15 -- USAGE
16 --
17 -- DEPENDENCIES
18 -- None.
19 --
20 -- CALLED BY
21 -- DataTemplate Extract in Aggregate VAT Statement.
22 --
23 --
24 -- LAST UPDATE DATE 10-JAN-2007
25 -- Date the program has been modified for the last time
26 --
27 -- HISTORY
28 -- =======
29 --
30 -- VERSION DATE AUTHOR(S) DESCRIPTION
31 -- ------- ----------- -------------- ---------------------------------
32 -- 1.00 10-JAN-2007 Sandeep Creation
33 --
34 -- ****************************************************************************
35 AS
36 P_LEDGER_ID NUMBER;
37 P_ORG_ID NUMBER;
38 P_PERIOD_FROM VARCHAR2(30);
39 P_PERIOD_TO VARCHAR2(30);
40 P_REPORT_TYPE VARCHAR2(30);
41
42 FUNCTION get_rate(p_invoice_currency_code IN VARCHAR2
43 ,p_ship_date_actual IN DATE
44 ,p_exchange_rate_type IN VARCHAR2)
45 RETURN NUMBER;
46
47 END AR_AGG_VAT_STMT_PKG;