DBA Data[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;