1 PACKAGE CE_BNK_STMT_RECON_RPT_PKG AUTHID CURRENT_USER
2 -- $Header: CEBNKSTMTRECONS.pls 120.1 2008/04/04 07:06:00 kbabu noship $
3 --*************************************************************************
4 -- Copyright (c) 2000 Oracle Solution Services (India) Product Development
5 -- All rights reserved
6 --*************************************************************************
7 --
8 --
9 -- PROGRAM NAME
10 -- CEBNKSTMTRECONS.pls
11 --
12 -- DESCRIPTION
13 -- This script creates the package specification of CEBNKSTMTRECONS.
14 -- This package is used by the 'Israel - Bank Statement Reconciliation' report.
15 --
16 -- USAGE
17 -- To execute This can be applied by running this script at SQL*Plus.
18 --
19 -- PROGRAM LIST DESCRIPTION
20 --
21 -- beforeReportTrigger It is a public function which is run just after the
22 -- queries are parsed and before queries are executed.
23 --
24 -- DEPENDENCIES
25 -- None
26 --
27 -- CALLED BY
28 -- None
29 --
30 -- LAST UPDATE DATE 10-FEB-2007
31 --
32 --
33 -- HISTORY
34 -- =======
35 --
36 -- VERSION DATE AUTHOR(S) DESCRIPTION
37 -- ------- ----------- --------------- ------------------------------------
38 -- Draft1A 10-FEB-2007 Harsh Poddar Draft Version
39 --************************************************************************
40
41 AS
42 P_BANK_ACCOUNT_ID NUMBER;
43 P_ACC_PERIOD_FROM VARCHAR2(50);
44 P_ACC_PERIOD_TO VARCHAR2(50);
45 P_CLOSE_BALANCE NUMBER;
46 gc_bank_account_name VARCHAR2(30);
47 gc_currency_code VARCHAR2(5);
48 gc_from_date VARCHAR2(30);
49 gc_to_date VARCHAR2(30);
50 gn_sob_id NUMBER;
51 gc_trx_type_payment VARCHAR2(30);
52 gc_trx_type_receipt VARCHAR2(30);
53 gc_origin_accounted VARCHAR2(30);
54 gc_origin_bank_stmt VARCHAR2(30);
55
56 FUNCTION beforeReportTrigger RETURN BOOLEAN;
57
58 END CE_BNK_STMT_RECON_RPT_PKG;