1 PACKAGE ap_open_bal_rev_rpt_pkg
2 -- $Header: APOBRRPS.pls 120.4 2008/01/25 11:22:04 sgudupat noship $
3 -- ****************************************************************************************
4 -- Copyright (c) 2000 Oracle Corporation Product Development
5 -- All rights reserved
6 -- ****************************************************************************************
7 --
8 -- PROGRAM NAME
9 -- APOBRRPS.pls
10 --
11 -- DESCRIPTION
12 -- This script creates the package specification of AP_OPEN_BAL_REV_RPT_PKG.
13 -- This package is used to generate AP Open Balances Revaluation Report.
14 --
15 -- USAGE
16 -- To install How to Install
17 -- To execute How to Execute
18 --
19 -- DEPENDENCIES
20 -- None.
21 --
22 -- beforereport It is a public function used to intialize global variables
23 -- which will be used to build the quries in the Data Template Dynamically
24 --
25 --
26 -- exch_rate_calc It is a public function which returns exchange rate, by taking P_AS_OF_DATE,
27 -- p_exchange_rate_type,gc_func_currency , and currency as parameter
28 --
29 --
30 -- amtduefilter It is a public function which returns boolean value
31 -- which will be used to fetch the data in Data Template Dynamically
32 --
33 --
34 -- LAST UPDATE DATE 25-JAN-2008
35 -- Date the program has been modified for the last time
36 --
37 -- HISTORY
38 -- =======
39 --
40 -- VERSION DATE AUTHOR(S) DESCRIPTION
41 -- ------- ----------- --------------- ------------------------------------
42 -- 1.0 21-FEB-2007 Praveen Gollu Creation
43 -- 1.1 25-JAN-2008 Sandeep G Fix for Bug #6773558
44 --****************************************************************************************
45 /*=========================================
46
47 Variables to Hold the Parameter Values
48
49 =========================================*/
50 AS
51 p_as_of_date DATE;
52 p_exchange_rate_type VARCHAR2 (30);
53 p_currency VARCHAR2 (15);
54 p_exchange_rate VARCHAR2 (15);
55 p_include_domestic_inv VARCHAR2 (1);
56 p_supplier VARCHAR2 (240);
57 p_org_id NUMBER;
58 /*=========================================
59
60 Global Variables
61
62 =========================================*/
63 gc_func_currency VARCHAR2 (15);
64 gc_ledger_id VARCHAR2 (30);
65 gc_include_dom_inv VARCHAR2 (500);
66 gc_supplier VARCHAR2 (100);
67 gc_currency VARCHAR2 (100);
68 gc_ou_where VARCHAR2 (30);
69 gc_supplier_name VARCHAR2 (100);
70 gc_operating_name VARCHAR2 (100);
71
72 /*=========================================
73
74 Public Functions
75
76 =========================================*/
77 FUNCTION beforereport
78 RETURN BOOLEAN;
79
80 FUNCTION exch_rate_calc (currency IN VARCHAR2)
81 RETURN NUMBER;
82
83 FUNCTION amtduefilter (p_amt_due IN NUMBER)
84 RETURN BOOLEAN;
85
86 FUNCTION amtduereval (
87 func_curr_amt IN NUMBER,
88 exch_rate IN NUMBER,
89 tran_curr IN VARCHAR
90 )
91 RETURN NUMBER;
92
93 FUNCTION vat_calc_amt (
94 prepay_amt_app IN NUMBER,
95 tax_amt IN NUMBER,
96 inv_amt IN NUMBER
97 )
98 RETURN NUMBER;
99 END ap_open_bal_rev_rpt_pkg;