[Home] [Help]
PACKAGE: APPS.GL_GLXACDAL_XMLP_PKG
Source
1 PACKAGE GL_GLXACDAL_XMLP_PKG AS
2 /* $Header: GLXACDALS.pls 120.0 2007/12/27 14:42:44 vijranga noship $ */
3 P_CONC_REQUEST_ID number;
4 P_STRUCT_NUM varchar2(15);
5 P_DATE date;
6 P_FLEX_LOW varchar2(1000);
7 P_FLEX_HIGH varchar2(1000);
8 FLEX_SELECT_ALL varchar2(1000) := '(SEGMENT1 || ''\n'' || SEGMENT2 || ''\n'' || SEGMENT3 || ''\n'' ||
9 SEGMENT4 || ''\n'' || SEGMENT5 || ''\n'' || SEGMENT6 || ''\n'' || SEGMENT7 || ''\n'' || SEGMENT8 || ''\n'' ||
10 SEGMENT9 || ''\n'' || SEGMENT10 || ''\n'' || SEGMENT11 || ''\n'' || SEGMENT12 || ''\n'' || SEGMENT13 ||
11 ''\n'' || SEGMENT14 || ''\n'' || SEGMENT15 || ''\n'' || SEGMENT16 || ''\n'' || SEGMENT17 || ''\n'' ||
12 SEGMENT18 || ''\n'' || SEGMENT19 || ''\n'' || SEGMENT20 || ''\n'' || SEGMENT21 || ''\n'' || SEGMENT22 || ''\n'' ||
13 SEGMENT23 || ''\n'' || SEGMENT24 || ''\n'' || SEGMENT25 || ''\n'' || SEGMENT26 || ''\n'' || SEGMENT27 ||
14 ''\n'' || SEGMENT28 || ''\n'' || SEGMENT29 || ''\n'' || SEGMENT30)' ;
15 FLEX_WHERE_ALL varchar2(4000) := 'SEGMENT1 between ''00'' and ''11''' ;
16 FLEX_ORDERBY_ALL varchar2(1000) := 'SEGMENT1, SEGMENT2, SEGMENT3, SEGMENT4, SEGMENT5, SEGMENT6,
17 SEGMENT7, SEGMENT8, SEGMENT9, SEGMENT10, SEGMENT11, SEGMENT12, SEGMENT13, SEGMENT14, SEGMENT15, SEGMENT16,
18 SEGMENT17, SEGMENT18, SEGMENT19, SEGMENT20, SEGMENT21, SEGMENT22, SEGMENT23, SEGMENT24, SEGMENT25,
19 SEGMENT26, SEGMENT27, SEGMENT28, SEGMENT29, SEGMENT30' ;
20 FLEX_NODATA_SELECT_BAL varchar2(600) := '(SEGMENT10 || ''\n'' || SEGMENT11)' ;
21 COA_NAME varchar2(30);
22 function BeforeReport return boolean ;
23 function AfterReport return boolean ;
24 Function FLEX_SELECT_ALL_p return varchar2;
25 Function FLEX_WHERE_ALL_p return varchar2;
26 Function FLEX_ORDERBY_ALL_p return varchar2;
27 Function FLEX_NODATA_SELECT_BAL_p return varchar2;
28 Function COA_NAME_p return varchar2;
29 END GL_GLXACDAL_XMLP_PKG;
30
31