DBA Data[Home] [Help]

PACKAGE: APPS.GL_CASH_CLR_ACCT_ANAL_RPT_PKG

Source


1 PACKAGE GL_CASH_CLR_ACCT_ANAL_RPT_PKG AS
2 /* $Header: glxccaas.pls 120.0.12000000.1 2007/10/23 17:10:50 sgudupat noship $ */
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);
11   ccid_param                       VARCHAR2(50);
12   period_from_param                VARCHAR2(15);
13   period_to_param                  VARCHAR2(15);
14   rept_type_param                  VARCHAR2(20);
15 
16   --
17   -- Global variables declaration. These variables are used for dynamically
18   -- builiding the queries in the report.
19   --
20   gc_ap_uncleared_query            VARCHAR2(2500);
21   gc_ap_cleared_query              VARCHAR2(2500);
22   gc_gl_uncleared_query            VARCHAR2(2500);
23   gn_effective_period_num_from     NUMBER;
24   gn_effective_period_num_to       NUMBER;
25   gc_access_where                  VARCHAR2(250);
26 
27   --
28   -- Function
29   --   before_report
30   -- Purpose
31   --   Used for dynamically builiding the queries in the report
32   -- Notes
33   --
34   FUNCTION before_report    RETURN BOOLEAN;
35 
36   --
37   -- Function
38   --   access_set_name
39   -- Purpose
40   --   Used to retrieve the access set name
41   -- Notes
42   --
43   FUNCTION access_set_name  RETURN VARCHAR2;
44 
45   --
46   -- Function
47   --   ledger_name
48   -- Purpose
49   --   Used to retrieve the ledger name
50   -- Notes
51   --
52   FUNCTION  ledger_name      RETURN VARCHAR2;
53 
54 END GL_CASH_CLR_ACCT_ANAL_RPT_PKG;