DBA Data[Home] [Help]

PACKAGE: APPS.GL_GLXACDAL_XMLP_PKG

Source


1 PACKAGE GL_GLXACDAL_XMLP_PKG AUTHID CURRENT_USER 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