1 PACKAGE ar_obalrev_pkg AUTHID CURRENT_USER AS
2 -- $Header: AROBRRPS.pls 120.7 2007/12/27 11:19:41 sgudupat noship $
3 -- ****************************************************************************************
4 -- Copyright (c) 2000 Oracle Solution Services (India) Product Development
5 -- All rights reserved
6 -- ****************************************************************************************
7 --
8 -- PROGRAM NAME
9 -- AROBRRPS.pls
10 --
11 -- DESCRIPTION
12 -- This script creates the package specification of ar_obalrev_pkg.
13 -- This package is used to generate AR Open balance Revaluation Report for Slovakia.
14 --
15 -- USAGE
16 -- To install How to Install
17 -- To execute How to Execute
18 --
19 --FUNCTION DESCRIPTION
20 -- beforereport It is a public function used to intialize global variables
21 -- which will be used to build the queries in the Data Template Dynamically
22 --
23 --
24 -- exch_rate_calc It is a public function which returns exchange rate, by taking P_AS_OF_DATE,
25 -- p_exchange_rate_type,gc_func_currency , and currency as parameter
26 --
27 --
28 -- amtduefilter It is a public function which returns boolean value
29 -- which will be used to fetch the data in Data Template Dynamically
30 --
31 -- DEPENDENCIES
32 -- None.
33 --
34 --
35 -- LAST UPDATE DATE 16-MAR-2007
36 -- Date the program has been modified for the last time
37 --
38 -- HISTORY
39 -- =======
40 --
41 -- VERSION DATE AUTHOR(S) DESCRIPTION
42 -- ------- ----------- ------------------- ---------------------------
43 -- 1.0 11-MAR-2007 Mallikarjun Gupta Creation
44 -- 1.1 24-Dec-2007 Ravi Kiran G Modified to pick CM details
45 --****************************************************************************************
46
47
48 --******************************************************
49 --Variables to Hold the Parameter Values
50 --******************************************************
51 P_ORG_ID NUMBER(10);
52 P_AS_OF_DATE VARCHAR2(30);
53 P_EXCHANGE_RATE_TYPE VARCHAR2(150);
54 P_CURRENCY VARCHAR2(150);
55 P_DUMMY VARCHAR2(15);
56 P_EXCHANGE_RATE VARCHAR2(20);
57 P_INCL_DOMESTIC_INV VARCHAR2(15);
58 P_CUSTOMER VARCHAR2(30);
59
60 --*******************************************************
61 --Constants to obtain dynamic values
62 --*******************************************************
63
64 gd_date_to1 DATE;
65 gd_date_to VARCHAR2(30);
66 gc_ledger_id VARCHAR2(30);
67 gc_trx_date_where VARCHAR2(300);
68 gc_trx_date_where1 VARCHAR2(300);
69 gc_exchange_rate_type VARCHAR2(30);
70 gc_func_currency VARCHAR2(15);
71 gc_currency_where VARCHAR2(300);
72 gc_incl_domestic_inv_where VARCHAR2(300);
73 gc_customer_where VARCHAR2(300);
74 gc_ou_where VARCHAR2(300);
75 gc_currency_where1 VARCHAR2(300);
76 gc_incl_domestic_inv_where1 VARCHAR2(300);
77 gc_customer_where1 VARCHAR2(300);
78 gc_ou_where1 VARCHAR2(300);
79 gc_customer_name VARCHAR2(30);
80 gc_ou_name VARCHAR2(300);
81 var2 VARCHAR2(100) :=0;
82
83 --*******************************************************
84 --Public Functions
85 --*******************************************************
86
87 FUNCTION beforereport RETURN BOOLEAN;
88 FUNCTION get_rate(p_currency IN VARCHAR2) RETURN NUMBER;
89 FUNCTION amtduefilter(p_amt_due IN NUMBER) RETURN BOOLEAN;
90 FUNCTION test(inv_num VARCHAR2 , amount NUMBER) RETURN NUMBER;
91
92
93 END ar_obalrev_pkg;