[Home] [Help]
PACKAGE: APPS.GL_SEL_SEG_TURNOVER_RPT_PKG
Source
1 PACKAGE GL_SEL_SEG_TURNOVER_RPT_PKG AS
2 -- $Header: glxssegs.pls 120.0.12000000.1 2007/10/23 16:28:29 sgudupat noship $
3 /*=========================================
4 Variables to Hold the Parameter Values
5 =========================================*/
6 LEDGER_ID_PARAM NUMBER;
7 PERIOD_FROM_PARAM VARCHAR2(30);
8 PERIOD_TO_PARAM VARCHAR2(30);
9 ADDITIONAL_SEGMENT_NUM1_PARAM NUMBER;
10 ADDITIONAL_SEGMENT_NUM2_PARAM NUMBER;
11 ACCT_FROM_PARAM VARCHAR2(50);
12 ACCT_TO_PARAM VARCHAR2(50);
13 BALANCE_TYPE_PARAM VARCHAR2(30);
14 BUDGETNAME_ENCUMBRANCETYPE NUMBER;
15 LEDGER_CURRENCY_PARAM VARCHAR2(30);
16 CURRENCY_TYPE_PARAM VARCHAR2(30);
17 ENTERED_CURRENCY_PARAM VARCHAR2(30);
18 ACCESS_SET_ID_PARAM NUMBER;
19 COA_ID_PARAM NUMBER;
20 PRINT_INTERNAL_DOC_NUM_PARAM VARCHAR2(30);
21 PRINT_JRNL_DETAIL_PARAM VARCHAR2(30);
22 USER_PARAM_1 VARCHAR2(30);
23 USER_PARAM_2 VARCHAR2(30);
24 USER_PARAM_3 VARCHAR2(30);
25 USER_PARAM_4 VARCHAR2(30);
26
27 /*=========================================
28 Lexical Variables to obtain dynamic values
29 =========================================*/
30
31 GC_BEGIN_DR_SELECT VARCHAR2(1000);
32 GC_BEGIN_CR_SELECT VARCHAR2(1000);
33 GC_PERIOD_DR_SELECT VARCHAR2(1000);
34 GC_PERIOD_CR_SELECT VARCHAR2(1000);
35
36 GC_BALANCE_WHERE VARCHAR2(500);
37 GC_TRANSLATE_WHERE VARCHAR2(500);
38 GC_SECURITY_WHERE VARCHAR2(500);
39 GC_DAS_BAL_WHERE VARCHAR2(500);
40 GC_DAS_JE_WHERE VARCHAR2(500);
41 GC_CURRENCY_WHERE VARCHAR2(500);
42 GC_NONZERO_WHERE VARCHAR2(500);
43 GC_SUBORD_SEG_WHERE VARCHAR2(100);
44 GC_RESULTING_CURRENCY VARCHAR2(10);
45 GC_PER_EFF_FROM_NUM NUMBER;
46 GC_PER_EFF_TO_NUM NUMBER;
47 GC_INT_DOC_NUM VARCHAR2(100);
48
49 gc_additional_segment_name1 VARCHAR2(30);
50 gc_additional_segment_name2 VARCHAR2(30);
51 gc_data_access_set_name VARCHAR2(30);
52
53 /*=========================================
54 Public Functions
55 =========================================*/
56
57 FUNCTION beforereport RETURN BOOLEAN;
58 FUNCTION int_doc_number(p_je_header_id IN NUMBER
59 ,p_je_line_num IN NUMBER) RETURN VARCHAR2;
60
61 END GL_SEL_SEG_TURNOVER_RPT_PKG;