[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;