PACKAGE: APPS.CE_BNK_STMT_IMP_RPT_PKG

Source

1 PACKAGE CE_BNK_STMT_IMP_RPT_PKG AUTHID CURRENT_USER
2 -- $Header: CEBNKSTMTIMPS.pls 120.2 2008/04/04 07:07:02 kbabu noship $
3 --*************************************************************************
4 -- Copyright (c)  2000    Oracle Solution Services (India)  Product Development
5 -- All rights reserved
6 --*************************************************************************
7 --
8 --
9 -- PROGRAM NAME
10 --  CEBNKSTMTIMPS.pls
11 --
12 -- DESCRIPTION
13 --   This script creates the package specification of CEBNKSTMTIMPS.
14 --   This package is used by the 'Bank Statement Import Validation - Israel' 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   20-DEC-2006
31 --
32 --
33 -- HISTORY
34 -- =======
35 --
36 -- VERSION DATE        AUTHOR(S)         DESCRIPTION
37 -- ------- ----------- ---------------   ------------------------------------
38 -- Draft1A 20-DEC-2006 Harsh Poddar  Draft Version
39 --************************************************************************
40 
41 AS
42     p_bank_branch_id              NUMBER;
43     p_bank_account_id             VARCHAR2(50);
44     p_statement_num		          VARCHAR2(50);
45     gc_bank_branch_name           VARCHAR2(300);
46     gc_bank_account_num           VARCHAR2(30);
47     gc_status_current		      VARCHAR2(30);
48     gc_status_latest		      VARCHAR2(30);
49     gc_control_totals		      VARCHAR2(1500);
50     gc_from_and_where		      VARCHAR2(500);
51     gn_total_cr			          NUMBER;
52     gn_total_dr		              NUMBER;
53 
54     lc_uploaded_select_columns    VARCHAR2(500);
55     lc_uploaded_where_conditions  VARCHAR2(500);
56     lc_uploaded_group_by	      VARCHAR2(200);
57     lc_latest_bank_acc_num        VARCHAR2(50);
58     lc_latest_bank_acc_from       VARCHAR2(50);
59     lc_latest_bank_acc_where	  VARCHAR2(1000);
60 
61   FUNCTION beforeReportTrigger RETURN BOOLEAN;
62 
63 END CE_BNK_STMT_IMP_RPT_PKG;