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_GLRGNL_XMLP_PKG

Source


1 PACKAGE GL_GLRGNL_XMLP_PKG AS
2 /* $Header: GLRGNLS.pls 120.0 2007/12/27 14:38:21 vijranga noship $ */
3 	P_CONC_REQUEST_ID	number;
4 	P_PAGE_SIZE	number;
5 	P_CURRENCY_TYPE	varchar2(15);
6 	P_ACTUAL_FLAG	varchar2(1);
7 	P_BUD_ENC_TYPE_ID	number;
8 	P_START_PERIOD	varchar2(15);
9 	P_END_PERIOD	varchar2(15);
10 	P_MIN_FLEX	varchar2(1000);
11 	P_MAX_FLEX	varchar2(1000);
12 	P_KIND	varchar2(1);
13 	P_LEDGER_ID	number;
14 	P_ACCESS_SET_ID	number;
15 	P_LEDGER_CURRENCY	varchar2(32767);
16 	P_ENTERED_CURRENCY	varchar2(40);
17 	P_CURRENCY_CODE	varchar2(40);
18 	CP_1	number;
19 	OLD_CCID	number;
20 	OLD_END_DR	number;
21 	OLD_END_CR	number;
22 	LAST_PERIOD_YEAR	number := 0 ;
23 	--STRUCT_NUM	varchar2(15) := := '101' ;
24 	STRUCT_NUM	varchar2(15) := '101' ;
25 
26 	SELECT_ALL	varchar2(1000) := '(CC.SEGMENT1 || ''\n'' || SEGMENT2 || ''\n'' || SEGMENT3 || ''\n'' || SEGMENT4 || ''\n'' || SEGMENT5 || ''\n'' || SEGMENT6 || ''\n'' || SEGMENT7 || ''\n'' || SEGMENT8 || ''\n'' ||
27 	SEGMENT9 || ''\n'' || SEGMENT10 || ''\n'' || SEGMENT11 || ''\n'' || SEGMENT12 || ''\n'' || SEGMENT13 || ''\n'' || SEGMENT14 || ''\n'' || SEGMENT15 || ''\n'' || SEGMENT16 || ''\n'' || SEGMENT17 || ''\n'' || SEGMENT18 || ''\n'' || SEGMENT19 ||
28 	''\n'' || SEGMENT20 || ''\n'' || SEGMENT21 || ''\n'' || SEGMENT22 || ''\n'' || SEGMENT23 || ''\n'' || SEGMENT24 || ''\n'' || SEGMENT25 || ''\n'' || SEGMENT26 || ''\n'' || SEGMENT27 || ''\n'' || SEGMENT28 ||
29 	''\n'' || SEGMENT29 || ''\n'' || SEGMENT30)' ;
30 	--WHERE	varchar2(4000) := := 'CC.SEGMENT11 BETWEEN  '00' and '11'' ;
31 	--l_WHERE	varchar2(4000) := 'CC.SEGMENT11 BETWEEN  '00' and '11'' ;
32 	l_WHERE	varchar2(4000) := 'CC.SEGMENT11 BETWEEN  ''00'' and ''11''' ;
33 	--ORDERBY_BAL	varchar2(50) := := 'CC.SEGMENT10' ;
34 	ORDERBY_BAL	varchar2(50) := 'CC.SEGMENT10' ;
35 	--ORDERBY_ACCT	varchar2(50) := := 'CC.SEGMENT10' ;
36 	ORDERBY_ACCT	varchar2(50) := 'CC.SEGMENT10' ;
37 
38 	ORDERBY_ALL	varchar2(800) := 'CC.SEGMENT1, CC.SEGMENT2, CC.SEGMENT3,
39 	CC.SEGMENT4, CC.SEGMENT5, CC.SEGMENT6,
40 	CC.SEGMENT7, CC.SEGMENT8, CC.SEGMENT9, CC.SEGMENT10, CC.SEGMENT11, CC.SEGMENT12, CC.SEGMENT13,
41 	CC.SEGMENT14, CC.SEGMENT15, CC.SEGMENT16, CC.SEGMENT17, CC.SEGMENT18, CC.SEGMENT19,
42 	CC.SEGMENT20, CC.SEGMENT21, CC.SEGMENT22, CC.SEGMENT23, CC.SEGMENT24, CC.SEGMENT25, CC.SEGMENT26,
43 	CC.SEGMENT27, CC.SEGMENT28, CC.SEGMENT29, CC.SEGMENT30' ;
44 
45 	SELECT_BAL	varchar2(1000) := '(CC.SEGMENT1 || ''\n'' || SEGMENT2 || ''\n'' || SEGMENT3 || ''\n'' || SEGMENT4 || ''\n'' || SEGMENT5 ||
46 	''\n'' || SEGMENT6 || ''\n'' || SEGMENT7 || ''\n'' || SEGMENT8 || ''\n'' || SEGMENT9 || ''\n'' || SEGMENT10 || ''\n'' || SEGMENT11 || ''\n'' ||
47 	SEGMENT12 || ''\n'' || SEGMENT13 || ''\n'' || SEGMENT14 || ''\n'' || SEGMENT15 || ''\n'' || SEGMENT16 || ''\n'' || SEGMENT17 || ''\n'' ||
48 	SEGMENT18 || ''\n'' || SEGMENT19 || ''\n'' || SEGMENT20 || ''\n'' || SEGMENT21 || ''\n'' || SEGMENT22 || ''\n'' || SEGMENT23 || ''\n'' || SEGMENT24 || ''\n'' ||
49 	SEGMENT25 || ''\n'' || SEGMENT26 || ''\n'' || SEGMENT27 || ''\n'' || SEGMENT28 || ''\n'' || SEGMENT29 || ''\n'' || SEGMENT30)' ;
50 
51 	EXCLAIMATION_POINT	varchar2(1);
52 	--STAR	varchar2(1) := := '*' ;
53 	STAR	varchar2(1) := '*' ;
54 	--WHERE_ACTUAL_TYPE	varchar2(100) := := 'budget_version_id = 1000' ;
55 	WHERE_ACTUAL_TYPE	varchar2(100) := 'budget_version_id = 1000' ;
56 	--WHERE_CURRENCY_CODE	varchar2(100) := := 'jeh.currency_code <> 'STAT'' ;
57 	--WHERE_CURRENCY_CODE	varchar2(100) := 'jeh.currency_code <> 'STAT'' ;
58 	WHERE_CURRENCY_CODE	varchar2(100) := 'jeh.currency_code <> ''STAT''' ;
59 	--SELECT_REFERENCE	varchar2(50) := := 'jeh.external_reference' ;
60 	SELECT_REFERENCE	varchar2(50) := 'jeh.external_reference' ;
61 	--WHERE_INDEX	varchar2(100) := := 'cc.segment11 between '0123456789012345' and '0123456789012345'' ;
62 	WHERE_INDEX	varchar2(100) := 'cc.segment11 between ''0123456789012345'' and ''0123456789012345''' ;
63 	--SELECT_CR	varchar2(500) := := 'nvl(jel.accounted_cr, 0)' ;
64 	SELECT_CR	varchar2(500) := 'nvl(jel.accounted_cr, 0)' ;
65 	--SELECT_DR	varchar2(500) := := 'nvl(jel.accounted_dr, 0)' ;
66 	SELECT_DR	varchar2(500) := 'nvl(jel.accounted_dr, 0)' ;
67 
68 	ORDERBY_BAL2	varchar2(600) := 'cc.segment1, cc.segment2, cc.segment3, cc.segment4, cc.segment5, cc.segment6, cc.segment7,
69 	cc.segment8, cc.segment9, cc.segment10, cc.segment11, cc.segment12, cc.segment13, cc.segment14, cc.segment15, cc.segment16, cc.segment17, cc.segment18, cc.segment19, cc.segment20, cc.segment21, cc.segment22, cc.segment23
70 	, cc.segment24, cc.segment25, cc.segment26, cc.segment27, cc.segment28, cc.segment29, cc.segment30' ;
71 
72 	ORDERBY_ACCT2	varchar2(800) := 'cc.segment1, cc.segment2, cc.segment3, cc.segment4, cc.segment5, cc.segment6, cc.segment7, cc.segment8, cc.segment9, cc.segment10, cc.segment11, cc.segment12, cc.segment13, cc.segment14,
73 	cc.segment15, cc.segment16, cc.segment17, cc.segment18, cc.segment19, cc.segment20, cc.segment21, cc.segment22, cc.segment23, cc.segment24, cc.segment25, cc.segment26, cc.segment27, cc.segment28, cc.segment29, cc.segment30' ;
74 	WHERE_DAS	varchar2(600);
75 	ACCESS_SET_NAME	varchar2(30);
76 	RESULTING_CURRENCY	varchar2(15);
77 	function BeforeReport return boolean  ;
78 	function AfterReport return boolean  ;
79 	function OLD_CCIDFormula return Number  ;
80 	function OLD_END_DRFormula return Number  ;
81 	function OLD_END_CRFormula return Number  ;
82 	function new_recordformula(ccid in number) return varchar2  ;
83 	function bad_startformula(new_record in varchar2, period_num in number, period_year in number, begin_dr in number, begin_cr in number, period_dr in number, period_cr in number) return varchar2  ;
84 	function bad_endformula(period_dr in number, total_dr in number, period_cr in number, total_cr in number, template_id in number) return varchar2  ;
85 	function BUD_ENC_TYPE_NAMEFormula return VARCHAR2  ;
86 	function DISP_ACTUAL_FLAGFormula return VARCHAR2  ;
87 	function START_DATEFormula return Date ;
88 	function END_DATEFormula return Date ;
89 	function DISP_CRFormula return VARCHAR2  ;
90 	function begin_balformula(BEGIN_CR in number, BEGIN_DR in number) return number  ;
91 	function end_balformula(BEGIN_CR in number, PERIOD_CR in number, BEGIN_DR in number, PERIOD_DR in number) return number  ;
92 	function accounted_balformula(ACCOUNTED_CR in number, ACCOUNTED_DR in number) return number  ;
93 	function LAST_PERIOD_YEARFormula return Number  ;
94 	procedure gl_get_period_dates (tledger_id IN NUMBER,
95                                  tperiod_name     IN VARCHAR2,
96                                  tstart_date      OUT NOCOPY DATE,
97                                  tend_date        OUT NOCOPY DATE,
98                                  errbuf           OUT NOCOPY VARCHAR2)
99    ;
100 	procedure gl_get_eff_period_num (tledger_id       IN NUMBER,
101                                 tperiod_name     IN VARCHAR2,
102                                 teffnum          OUT NOCOPY NUMBER,
103                                 errbuf           OUT NOCOPY VARCHAR2)
104  ;
105 	function START_EFF_PERIOD_NUMFormula return Number ;
106 	function END_EFF_PERIOD_NUMFormula return Number ;
107 	function g_balancing_segmentgroupfilter(BAL_SECURE in varchar2) return boolean  ;
108 	function g_accounting_flexfieldgroupfil(FLEX_SECURE in varchar2) return boolean  ;
109 	function BeforePForm return boolean  ;
110 	function AfterPForm return boolean  ;
111 	function BetweenPage return boolean  ;
112 	Function CP_1_p return number;
113 	Function OLD_CCID_p return number;
114 	Function OLD_END_DR_p return number;
115 	Function OLD_END_CR_p return number;
116 	Function LAST_PERIOD_YEAR_p return number;
117 	Function STRUCT_NUM_p return varchar2;
118 	Function SELECT_ALL_p return varchar2;
119 	Function WHERE_p return varchar2;
120 	Function ORDERBY_BAL_p return varchar2;
121 	Function ORDERBY_ACCT_p return varchar2;
122 	Function ORDERBY_ALL_p return varchar2;
123 	Function SELECT_BAL_p return varchar2;
124 	Function EXCLAIMATION_POINT_p return varchar2;
125 	Function STAR_p return varchar2;
126 	Function WHERE_ACTUAL_TYPE_p return varchar2;
127 	Function WHERE_CURRENCY_CODE_p return varchar2;
128 	Function SELECT_REFERENCE_p return varchar2;
129 	Function WHERE_INDEX_p return varchar2;
130 	Function SELECT_CR_p return varchar2;
131 	Function SELECT_DR_p return varchar2;
132 	Function ORDERBY_BAL2_p return varchar2;
133 	Function ORDERBY_ACCT2_p return varchar2;
134 	Function WHERE_DAS_p return varchar2;
135 	Function ACCESS_SET_NAME_p return varchar2;
136 	Function RESULTING_CURRENCY_p return varchar2;
137 END GL_GLRGNL_XMLP_PKG;
138 
139