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_RGXROWD_XMLP_PKG

Source


1 PACKAGE GL_RGXROWD_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: RGXROWDS.pls 120.0 2007/12/27 15:37:07 vijranga noship $ */
3 	P_ACCESS_SET_ID	number;
4 	P_ROW_SET_ID	number;
5 	P_FLEXDATA_LOW	varchar2(2500):='SEGMENT1_LOW||''\n''||SEGMENT2_LOW||''\n''||SEGMENT3_LOW||''\n''||SEGMENT4_LOW||''\n''||SEGMENT5_LOW||''\n''||SEGMENT6_LOW||''\n''||
6 	SEGMENT7_LOW||''\n''||SEGMENT8_LOW||''\n''||SEGMENT9_LOW||''\n''||SEGMENT10_LOW||''\n''||SEGMENT11_LOW||''\n''||SEGMENT12_LOW||''\n''||SEGMENT13_LOW||''\n''||
7 	SEGMENT14_LOW||''\n''||SEGMENT15_LOW||''\n''||SEGMENT16_LOW||''\n''||SEGMENT17_LOW||''\n''||SEGMENT18_LOW||''\n''||SEGMENT19_LOW||''\n''||SEGMENT20_LOW||''\n''||
8 	SEGMENT21_LOW||''\n''||SEGMENT22_LOW||''\n''||SEGMENT23_LOW||''\n''||SEGMENT24_LOW||''\n''||SEGMENT25_LOW||''\n''||SEGMENT26_LOW||''\n''||SEGMENT27_LOW||''\n''||
9 	SEGMENT28_LOW||''\n''||SEGMENT29_LOW||''\n''||SEGMENT30_LOW||''\n''||SEGMENT_ATTRIBUTE1_LOW||''\n''||SEGMENT_ATTRIBUTE2_LOW||''\n''||SEGMENT_ATTRIBUTE3_LOW||''\n''||
10 	SEGMENT_ATTRIBUTE4_LOW||''\n''||SEGMENT_ATTRIBUTE5_LOW';
11 	P_FLEXDATA_HIGH	varchar2(2500):='SEGMENT1_HIGH||''\n''||SEGMENT2_HIGH||''\n''||SEGMENT3_HIGH||''\n''||SEGMENT4_HIGH||
12 	''\n''||SEGMENT5_HIGH||''\n''||SEGMENT6_HIGH||''\n''||SEGMENT7_HIGH||''\n''||SEGMENT8_HIGH||''\n''||
13 	SEGMENT9_HIGH||''\n''||SEGMENT10_HIGH||''\n''||SEGMENT11_HIGH||''\n''||SEGMENT12_HIGH||''\n''||
14 	SEGMENT13_HIGH||''\n''||SEGMENT14_HIGH||''\n''||SEGMENT15_HIGH||''\n''||SEGMENT16_HIGH||''\n''||
15 	SEGMENT17_HIGH||''\n''||SEGMENT18_HIGH||''\n''||SEGMENT19_HIGH||''\n''||SEGMENT20_HIGH||''\n''||
16 	SEGMENT21_HIGH||''\n''||SEGMENT22_HIGH||''\n''||SEGMENT23_HIGH||''\n''||SEGMENT24_HIGH||''\n''||
17 	SEGMENT25_HIGH||''\n''||SEGMENT26_HIGH||''\n''||SEGMENT27_HIGH||''\n''||SEGMENT28_HIGH||''\n''||
18 	SEGMENT29_TYPE||''\n''||SEGMENT30_HIGH||''\n''||SEGMENT_ATTRIBUTE1_HIGH||''\n''||SEGMENT_ATTRIBUTE2_HIGH||
19 	''\n''||SEGMENT_ATTRIBUTE3_HIGH||''\n''||SEGMENT_ATTRIBUTE4_HIGH';
20 	P_FLEX_LPROMPT	varchar2(2500);
21 	P_CONC_REQUEST_ID	number;
22 	P_FLEXDATA_TYPE	varchar2(2500):='SEGMENT1_LOW||''\n''||SEGMENT2_LOW||''\n''||SEGMENT1_TYPE||''\n''||
23 	SEGMENT2_TYPE||''\n''||SEGMENT3_TYPE||''\n''||SEGMENT4_TYPE||''\n''||SEGMENT5_TYPE||''\n''||SEGMENT6_TYPE||
24        ''\n''||SEGMENT7_TYPE||''\n''||SEGMENT8_TYPE||''\n''||SEGMENT9_TYPE||''\n''||SEGMENT10_TYPE||''\n''||SEGMENT11_TYPE||
25        ''\n''||SEGMENT12_TYPE||''\n''||SEGMENT13_TYPE||''\n''||SEGMENT14_TYPE||''\n''||SEGMENT15_TYPE||''\n''||SEGMENT16_TYPE||''\n''||
26        SEGMENT17_TYPE||''\n''||SEGMENT18_TYPE||''\n''||SEGMENT19_TYPE||''\n''||SEGMENT20_TYPE||''\n''||SEGMENT21_TYPE||''\n''||SEGMENT22_TYPE||
27        ''\n''||SEGMENT23_TYPE||''\n''||SEGMENT24_TYPE||''\n''||SEGMENT25_TYPE||''\n''||SEGMENT26_TYPE||''\n''||SEGMENT27_TYPE||''\n''||SEGMENT28_TYPE||''\n''||SEGMENT29_TYPE||''\n''||SEGMENT30_TYPE||
28        ''\n''||SEGMENT_ATTRIBUTE1_TYPE||''\n''||SEGMENT_ATTRIBUTE2_TYPE||''\n''||SEGMENT_ATTRIBUTE3_TYPE||''\n''||SEGMENT_ATTRIBUTE4_TYPE||''\n''||SEGMENT_ATTRIBUTE5_TYPE';
29 	P_FLEXDATA_LOW2	varchar2(988):='||''\n''||SEGMENT_ATTRIBUTE6_LOW||''\n''||SEGMENT_ATTRIBUTE7_LOW||''\n''||SEGMENT_ATTRIBUTE8_LOW||''\n''|| SEGMENT_ATTRIBUTE9_LOW||''\n''||
30 	SEGMENT_ATTRIBUTE10_LOW||''\n''||SEGMENT_ATTRIBUTE11_LOW||''\n''||SEGMENT_ATTRIBUTE12_LOW||''\n''||SEGMENT_ATTRIBUTE13_LOW||''\n''||SEGMENT_ATTRIBUTE14_LOW||''\n''||SEGMENT_ATTRIBUTE15_LOW||
31 	''\n''||SEGMENT_ATTRIBUTE16_LOW||''\n''||SEGMENT_ATTRIBUTE17_LOW||''\n''||SEGMENT_ATTRIBUTE18_LOW||''\n''||SEGMENT_ATTRIBUTE19_LOW||''\n''||SEGMENT_ATTRIBUTE20_LOW';
32 	P_FLEXDATA_HIGH2	varchar2(988):='||''\n''||SEGMENT_ATTRIBUTE5_HIGH||''\n''||SEGMENT_ATTRIBUTE6_HIGH||''\n''||SEGMENT_ATTRIBUTE7_HIGH||''\n''||SEGMENT_ATTRIBUTE8_HIGH||''\n''||
33 	SEGMENT_ATTRIBUTE9_HIGH||''\n''||SEGMENT_ATTRIBUTE10_HIGH||''\n''||SEGMENT_ATTRIBUTE11_HIGH||''\n''||
34 	SEGMENT_ATTRIBUTE12_HIGH||''\n''||SEGMENT_ATTRIBUTE13_HIGH||''\n''||SEGMENT_ATTRIBUTE14_HIGH||
35 	''\n''||SEGMENT_ATTRIBUTE15_HIGH||''\n''||SEGMENT_ATTRIBUTE16_HIGH||''\n''||SEGMENT_ATTRIBUTE17_HIGH||
36 	''\n''||SEGMENT_ATTRIBUTE18_HIGH||''\n''||SEGMENT_ATTRIBUTE19_HIGH||''\n''||SEGMENT_ATTRIBUTE20_HIGH';
37 	P_FLEXDATA_HIGH3	varchar2(988):='||''\n''||SEGMENT_ATTRIBUTE21_HIGH||''\n''||SEGMENT_ATTRIBUTE22_HIGH||''\n''||SEGMENT_ATTRIBUTE23_HIGH||''\n''||SEGMENT_ATTRIBUTE24_HIGH||''\n''||
38 	SEGMENT_ATTRIBUTE25_HIGH||''\n''||SEGMENT_ATTRIBUTE26_HIGH||''\n''||SEGMENT_ATTRIBUTE27_HIGH||''\n''||SEGMENT_ATTRIBUTE28_HIGH||''\n''||SEGMENT_ATTRIBUTE29_HIGH||''\n''||SEGMENT_ATTRIBUTE30_HIGH||
39 	''\n''||SEGMENT_ATTRIBUTE31_HIGH||''\n''||SEGMENT_ATTRIBUTE32_HIGH||''\n''||SEGMENT_ATTRIBUTE33_HIGH||''\n''||SEGMENT_ATTRIBUTE34_HIGH||''\n''||SEGMENT_ATTRIBUTE35_HIGH||''\n''||SEGMENT_ATTRIBUTE36_HIGH||
40 	''\n''||SEGMENT_ATTRIBUTE37_HIGH||''\n''||SEGMENT_ATTRIBUTE38_HIGH||''\n''||SEGMENT_ATTRIBUTE39_HIGH||''\n''||SEGMENT_ATTRIBUTE40_HIGH||''\n''||SEGMENT_ATTRIBUTE41_HIGH||''\n''||SEGMENT_ATTRIBUTE42_HIGH';
41 	P_FLEXDATA_TYPE2	varchar2(988):='||''\n''||SEGMENT_ATTRIBUTE6_TYPE||''\n''||SEGMENT_ATTRIBUTE7_TYPE||''\n''||SEGMENT_ATTRIBUTE8_TYPE||''\n''|| SEGMENT_ATTRIBUTE9_TYPE||''\n''||SEGMENT_ATTRIBUTE10_TYPE||
42 	''\n''||SEGMENT_ATTRIBUTE11_TYPE||''\n''||SEGMENT_ATTRIBUTE12_TYPE||''\n''|| SEGMENT_ATTRIBUTE13_TYPE||''\n''||SEGMENT_ATTRIBUTE14_TYPE||''\n''||SEGMENT_ATTRIBUTE15_TYPE||''\n''||SEGMENT_ATTRIBUTE16_TYPE||''\n''||
43 	SEGMENT_ATTRIBUTE17_TYPE||''\n''||SEGMENT_ATTRIBUTE18_TYPE||''\n''||SEGMENT_ATTRIBUTE19_TYPE||''\n''||SEGMENT_ATTRIBUTE20_TYPE';
44 	P_FLEXDATA_TYPE3	varchar2(988):='||''\n''||SEGMENT_ATTRIBUTE21_TYPE||''\n''||SEGMENT_ATTRIBUTE22_TYPE||''\n''||SEGMENT_ATTRIBUTE23_TYPE||''\n''||SEGMENT_ATTRIBUTE24_TYPE||''\n''|| SEGMENT_ATTRIBUTE25_TYPE||
45 	''\n''||SEGMENT_ATTRIBUTE26_TYPE||''\n''||SEGMENT_ATTRIBUTE27_TYPE||''\n''||SEGMENT_ATTRIBUTE28_TYPE||''\n''||SEGMENT_ATTRIBUTE29_TYPE||''\n''||SEGMENT_ATTRIBUTE30_TYPE||''\n''||SEGMENT_ATTRIBUTE31_TYPE||''\n''||
46 	SEGMENT_ATTRIBUTE32_TYPE||''\n''|| SEGMENT_ATTRIBUTE33_TYPE||''\n''||SEGMENT_ATTRIBUTE34_TYPE||''\n''||SEGMENT_ATTRIBUTE35_TYPE||''\n''||SEGMENT_ATTRIBUTE36_TYPE||''\n''|| SEGMENT_ATTRIBUTE37_TYPE||''\n''||
47 	SEGMENT_ATTRIBUTE38_TYPE||''\n''||SEGMENT_ATTRIBUTE39_TYPE||''\n''||SEGMENT_ATTRIBUTE40_TYPE||''\n''|| SEGMENT_ATTRIBUTE41_TYPE||''\n''||SEGMENT_ATTRIBUTE42_TYPE';
48 	P_FLEXDATA_LOW3	varchar2(988):='||''\n''||SEGMENT_ATTRIBUTE21_LOW||''\n''||SEGMENT_ATTRIBUTE22_LOW||''\n''||SEGMENT_ATTRIBUTE23_LOW||''\n''||SEGMENT_ATTRIBUTE24_LOW||''\n''|| SEGMENT_ATTRIBUTE25_LOW||''\n''||
49 	SEGMENT_ATTRIBUTE26_LOW||''\n''||SEGMENT_ATTRIBUTE27_LOW||''\n''||SEGMENT_ATTRIBUTE28_LOW||''\n''|| SEGMENT_ATTRIBUTE29_LOW||''\n''||SEGMENT_ATTRIBUTE30_LOW||''\n''||SEGMENT_ATTRIBUTE31_LOW||''\n''||
50 	SEGMENT_ATTRIBUTE32_LOW||''\n''||SEGMENT_ATTRIBUTE33_LOW||''\n''||SEGMENT_ATTRIBUTE34_LOW||''\n''||SEGMENT_ATTRIBUTE35_LOW||''\n''||SEGMENT_ATTRIBUTE36_LOW||''\n''||SEGMENT_ATTRIBUTE37_LOW||''\n''||SEGMENT_ATTRIBUTE38_LOW||
51 	''\n''||SEGMENT_ATTRIBUTE39_LOW||''\n''||SEGMENT_ATTRIBUTE40_LOW||''\n''||SEGMENT_ATTRIBUTE41_LOW||''\n''||SEGMENT_ATTRIBUTE42_LOW';
52 	P_FLEX_LPROMPT2	varchar2(988);
53 	P_FLEX_LPROMPT3	varchar2(988);
54 	C_STRUCT_NUM	number;
55 	C_ID_FLEX_CODE	varchar2(4) := 'GLLE' ;
56 	C_INDUSTRY_TYPE	varchar2(1) := 'C' ;
57 	C_ATTRIBUTE_FLAG	varchar2(1) := 'N' ;
58 	C_DELIMITER varchar2(10);
59 	function BeforeReport return boolean  ;
60 	function AfterReport return boolean  ;
61 	function c_flex_lowformula(C_DATA_LOW in varchar2) return varchar2  ;
62 	function c_flex_highformula(C_DATA_HIGH in varchar2) return varchar2  ;
63 	function c_flex_typeformula(C_DATA_TYPE in varchar2) return varchar2  ;
64 	Function C_STRUCT_NUM_p return number;
65 	Function C_ID_FLEX_CODE_p return varchar2;
66 	Function C_INDUSTRY_TYPE_p return varchar2;
67 	Function C_ATTRIBUTE_FLAG_p return varchar2;
68 END GL_RGXROWD_XMLP_PKG;
69 
70