eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.GL_GLXRLCOA_XMLP_PKG

Source


1 PACKAGE GL_GLXRLCOA_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: GLXRLCOAS.pls 120.0 2007/12/27 15:12:50 vijranga noship $ */
3 	P_CONC_REQUEST_ID	number;
4 	P_STRUCT_NUM	varchar2(15);
5 	P_FLEX_HIGH	varchar2(1000);
6 	P_FLEX_LOW	varchar2(1000);
7 	P_ORDERBY_SEG	number;
8 	--FLEX_SELECT_ALL	varchar2(1000) := := '(SEGMENT1 || '\n' || SEGMENT2 || '\n' || SEGMENT3 || '\n' || SEGMENT4 || '\n' || SEGMENT5 || '\n' || SEGMENT6 || '\n' || SEGMENT7 || '\n' || SEGMENT8 || '\n' || SEGMENT9 || '\n' || SEGMENT10 || '\n' ||
9 	--	SEGMENT11 || '\n' || SEGMENT12 || '\n' || SEGMENT13 || '\n' || SEGMENT14 || '\n' || SEGMENT15 || '\n' || SEGMENT16 || '\n' || SEGMENT17 || '\n' || SEGMENT18 || '\n' || SEGMENT19 || '\n' || SEGMENT20 || '\n' ||
10 	--SEGMENT21 || '\n' || SEGMENT22 || '\n' ||
11 	--SEGMENT23 || '\n' || SEGMENT24 || '\n' || SEGMENT25 || '\n' || SEGMENT26 || '\n' || SEGMENT27 || '\n' || SEGMENT28 || '\n' || SEGMENT29 || '\n' || SEGMENT30)' ;
12 
13 	FLEX_SELECT_ALL	varchar2(1000) := '(SEGMENT1 || ''\n'' || SEGMENT2 || ''\n'' || SEGMENT3 || ''\n'' || SEGMENT4 || ''\n'' || SEGMENT5 || ''\n'' || SEGMENT6 || ''\n'' ||
14 	SEGMENT7 || ''\n'' || SEGMENT8 || ''\n'' || SEGMENT9 || ''\n'' || SEGMENT10 || ''\n'' || SEGMENT11 || ''\n'' || SEGMENT12 || ''\n'' || SEGMENT13 || ''\n'' || SEGMENT14
15 	|| ''\n'' || SEGMENT15 || ''\n'' || SEGMENT16 || ''\n'' || SEGMENT17 || ''\n'' || SEGMENT18 || ''\n'' || SEGMENT19 || ''\n'' || SEGMENT20 || ''\n'' || SEGMENT21 || ''\n'' || SEGMENT22 || ''\n'' || SEGMENT23 || ''\n'' || SEGMENT24 || ''\n''
16 	|| SEGMENT25
17 	|| ''\n'' || SEGMENT26 || ''\n'' || SEGMENT27 || ''\n'' || SEGMENT28 || ''\n'' || SEGMENT29 || ''\n'' || SEGMENT30)';
18 	--FLEX_SELECT_BAL	varchar2(600) := := '(segment11 ||'\n' || segment12)' ;
19 	FLEX_SELECT_BAL	varchar2(600) := '(segment11 ||''\n'' || segment12)' ;
20 	--FLEX_SELECT_SEG	varchar2(600) := := '(segment11 ||'\n' || segment12)' ;
21 	FLEX_SELECT_SEG	varchar2(600) := '(segment11 ||''\n'' || segment12)' ;
22 	FLEX_ORDERBY_ALL	varchar2(1000) := 'SEGMENT1,  SEGMENT2, SEGMENT3,  SEGMENT4, SEGMENT5, SEGMENT6, SEGMENT7, SEGMENT8, SEGMENT9, SEGMENT10, SEGMENT11, SEGMENT12, SEGMENT13, SEGMENT14, SEGMENT15, SEGMENT16, SEGMENT17, SEGMENT18, SEGMENT19, SEGMENT20,
23 	SEGMENT21, SEGMENT22, SEGMENT23, SEGMENT24, SEGMENT25, SEGMENT26, SEGMENT27, SEGMENT28, SEGMENT29, SEGMENT30' ;
24 	FLEX_ORDERBY_BAL	varchar2(600) := 'SEGMENT10' ;
25 	FLEX_ORDERBY_SEG	varchar2(600) := 'SEGMENT10' ;
26 	--FLEX_WHERE_ALL	varchar2(4000) := := 'SEGMENT1 BETWEEN '00' AND '11'' ;
27 	FLEX_WHERE_ALL	varchar2(4000) := 'SEGMENT1 BETWEEN ''00'' AND ''11''' ;
28 	--FLEX_NODATA_SELECT_ALL	varchar2(1000) := := '(SEGMENT1 || '\n' || SEGMENT2 || '\n' || SEGMENT3 || '\n' || SEGMENT4 || '\n' || SEGMENT5 || '\n' || SEGMENT6 || '\n' || SEGMENT7 || '\n' || SEGMENT8 || '\n' || SEGMENT9 || '\n'
29 --	|| SEGMENT10 || '\n' || SEGMENT11 || '\n' ||
30 --	SEGMENT12 || '\n' || SEGMENT13 || '\n' || SEGMENT14 || '\n' || SEGMENT15 || '\n' || SEGMENT16 || '\n' || SEGMENT17 || '\n' || SEGMENT18 || '\n' || SEGMENT19 || '\n' || SEGMENT20 || '\n' || SEGMENT21 || '\n' || SEGMENT22
31 --	|| '\n' || SEGMENT23 || '\n' || SEGMENT24 || '\n' ||
32 --	SEGMENT25 || '\n' || SEGMENT26 || '\n' || SEGMENT27 || '\n' || SEGMENT28 || '\n' || SEGMENT29 || '\n' || SEGMENT30)' ;
33 
34 	FLEX_NODATA_SELECT_ALL	varchar2(1000) := '(SEGMENT1 || ''\n'' || SEGMENT2 || ''\n'' || SEGMENT3 || ''\n'' || SEGMENT4 || ''\n'' || SEGMENT5 || ''\n'' || SEGMENT6 || ''\n'' || SEGMENT7 || ''\n'' || SEGMENT8 || ''\n''
35 	|| SEGMENT9 || ''\n'' || SEGMENT10 || ''\n'' ||
36 	SEGMENT11 || ''\n'' || SEGMENT12 || ''\n'' || SEGMENT13 || ''\n'' || SEGMENT14 || ''\n'' || SEGMENT15 || ''\n'' || SEGMENT16 || ''\n'' || SEGMENT17 || ''\n'' || SEGMENT18 || ''\n'' || SEGMENT19 || ''\n'' || SEGMENT20
37 	|| ''\n'' || SEGMENT21 || ''\n'' || SEGMENT22 || ''\n'' ||
38 	SEGMENT23 || ''\n'' || SEGMENT24 || ''\n'' || SEGMENT25 || ''\n'' || SEGMENT26 || ''\n'' || SEGMENT27 || ''\n'' || SEGMENT28 || ''\n'' || SEGMENT29 || ''\n'' || SEGMENT30)';
39 
40 	function AfterReport return boolean  ;
41 	function BeforeReport return boolean  ;
42 	Function FLEX_SELECT_ALL_p return varchar2;
43 	Function FLEX_SELECT_BAL_p return varchar2;
44 	Function FLEX_SELECT_SEG_p return varchar2;
45 	Function FLEX_ORDERBY_ALL_p return varchar2;
46 	Function FLEX_ORDERBY_BAL_p return varchar2;
47 	Function FLEX_ORDERBY_SEG_p return varchar2;
48 	Function FLEX_WHERE_ALL_p return varchar2;
49 	Function FLEX_NODATA_SELECT_ALL_p return varchar2;
50 END GL_GLXRLCOA_XMLP_PKG;
51 
52