[Home] [Help]
PACKAGE: APPS.OKL_REPORT_GENERATOR_PVT
Source
1 PACKAGE okl_report_generator_pvt AUTHID CURRENT_USER AS
2 /* $Header: OKLRRPTS.pls 120.4.12010000.3 2008/11/14 08:30:10 nikshah ship $*/
3
4 ---------------------------------------------------------------------------
5 -- GLOBAL DATASTRUCTURES
6 ---------------------------------------------------------------------------
7 ---------------------------------------------------------------------------
8 -- GLOBAL VARIABLES
9 ---------------------------------------------------------------------------
10 g_app_name CONSTANT VARCHAR2(3) := okl_api.g_app_name;
11 g_unexpected_error CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
12 g_sqlerrm_token CONSTANT VARCHAR2(200) := 'SQLERRM';
13 g_sqlcode_token CONSTANT VARCHAR2(200) := 'SQLCODE';
14 g_pkg_name CONSTANT VARCHAR2(200) := 'OKL_REPORTS_PVT';
15 g_col_name_token CONSTANT VARCHAR2(200) := okl_api.g_col_name_token;
16 g_parent_table_token CONSTANT VARCHAR2(200) := okl_api.g_parent_table_token;
17 g_child_table_token CONSTANT VARCHAR2(200) := okl_api.g_child_table_token;
18 g_no_parent_record CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
19 g_invalid_value CONSTANT VARCHAR2(200) := okl_api.g_invalid_value;
20 g_required_value CONSTANT VARCHAR2(200) := okl_api.g_required_value;
21 g_representation_type VARCHAR2(20) := 'PRIMARY';
22 g_exception_halt_validation EXCEPTION;
23
24 ---------------------------------------------------------------------------
25 -- Procedures and Functions
26 ---------------------------------------------------------------------------
27 ---------------------------------------------------------------------------
28 -- GLOBAL DATASTRUCTURES
29 ---------------------------------------------------------------------------
30 TYPE reports_gt_tbl_type IS TABLE OF okl_g_reports_gt%ROWTYPE
31 INDEX BY BINARY_INTEGER;
32
33 p_report_id NUMBER;
34 p_ledger_id NUMBER;
35 p_book_class_code VARCHAR2(30);
36 p_report_type VARCHAR2(15);
37 p_report_type_code VARCHAR2(15);
38 p_gl_period_from VARCHAR2(15);
39 p_gl_period_to VARCHAR2(15);
40 p_drill1_yn VARCHAR2(1);
41 p_drill2_yn VARCHAR2(1);
42 p_summary_yn VARCHAR2(1);
43
44 FUNCTION generate_gross_inv_recon_rpt RETURN BOOLEAN;
45
46 END OKL_REPORT_GENERATOR_PVT;