DBA Data[Home] [Help]

PACKAGE: APPS.GL_CASH_CLR_ACCT_ANAL_RPT_PKG

Source


1 PACKAGE GL_CASH_CLR_ACCT_ANAL_RPT_PKG AUTHID CURRENT_USER AS
2 /* $Header: glxccaas.pls 120.0.12010000.2 2009/04/29 09:57:24 kmotepal ship $ */
3 
4   --
5   -- Report parameters
6   --
7   data_access_set_id_param         VARCHAR2(30);
8   ledger_id_param                  VARCHAR2(15);
9   coa_id_param                     NUMBER(30);
10  -- acct_param                       VARCHAR2(50);--Commented as part of bug8446559
11   acct_param                       VARCHAR2(240);--Added as part of bug8446559
12   ccid_param                       VARCHAR2(50);
13   period_from_param                VARCHAR2(15);
14   period_to_param                  VARCHAR2(15);
15   rept_type_param                  VARCHAR2(20);
16 
17   --
18   -- Global variables declaration. These variables are used for dynamically
19   -- builiding the queries in the report.
20   --
21   gc_ap_uncleared_query            VARCHAR2(2500);
22   gc_ap_cleared_query              VARCHAR2(2500);
23   gc_gl_uncleared_query            VARCHAR2(2500);
24   gn_effective_period_num_from     NUMBER;
25   gn_effective_period_num_to       NUMBER;
26   gc_access_where                  VARCHAR2(250);
27 
28   --
29   -- Function
30   --   before_report
31   -- Purpose
32   --   Used for dynamically builiding the queries in the report
33   -- Notes
34   --
35   FUNCTION before_report    RETURN BOOLEAN;
36 
37   --
38   -- Function
39   --   access_set_name
40   -- Purpose
41   --   Used to retrieve the access set name
42   -- Notes
43   --
44   FUNCTION access_set_name  RETURN VARCHAR2;
45 
46   --
47   -- Function
48   --   ledger_name
49   -- Purpose
50   --   Used to retrieve the ledger name
51   -- Notes
52   --
53   FUNCTION  ledger_name      RETURN VARCHAR2;
54 
55 END GL_CASH_CLR_ACCT_ANAL_RPT_PKG;