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