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_GLRJED_XMLP_PKG

Source


1 PACKAGE GL_GLRJED_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: GLRJEDS.pls 120.0 2007/12/27 14:39:14 vijranga noship $ */
3 	P_CONC_REQUEST_ID	number;
4 	P_LEDGER_ID	varchar2(15);
5 	P_KIND	varchar2(1);
6 	P_LEDGER_CURRENCY	varchar2(15);
7 	P_ACTUAL_FLAG	varchar2(1);
8 	P_BUD_ENC_TYPE_ID	number;
9 	P_START_PERIOD	varchar2(15);
10 	P_END_PERIOD	varchar2(15);
11 	P_MIN_FLEX	varchar2(1000);
12 	P_MAX_FLEX	varchar2(1000);
13 	P_ORDER_TYPE	varchar2(1);
14 	P_PAGE_SIZE	number;
15 	P_ACCESS_SET_ID	number;
16 	P_CURRENCY_TYPE	varchar2(1);
17 	P_ENTERED_CURRENCY	varchar2(15);
18 	STRUCT_NUM	varchar2(15):= '101' ;
19 	ACCESS_SET_NAME	varchar2(30);
20 	SELECT_ALL	varchar2(1000) := '(CC.SEGMENT1 || ''\n'' || SEGMENT2 || ''\n'' ||
21 	SEGMENT3 || ''\n'' || SEGMENT4 || ''\n'' || SEGMENT5 || ''\n'' || SEGMENT6 || ''\n'' ||
22 	SEGMENT7 || ''\n'' || SEGMENT8 || ''\n'' || SEGMENT9 || ''\n'' || SEGMENT10 || ''\n'' ||
23 	SEGMENT11 || ''\n'' || SEGMENT12 || ''\n'' || SEGMENT13 || ''\n'' || SEGMENT14 || ''\n'' ||
24 	SEGMENT15 || ''\n'' || SEGMENT16 || ''\n'' || SEGMENT17 || ''\n'' || SEGMENT18 || ''\n'' ||
25 	SEGMENT19 || ''\n'' || SEGMENT20 || ''\n'' || SEGMENT21 || ''\n'' || SEGMENT22 || ''\n'' ||
26 	SEGMENT23 || ''\n'' || SEGMENT24 || ''\n'' || SEGMENT25 || ''\n'' || SEGMENT26 || ''\n'' ||
27 	SEGMENT27 || ''\n'' || SEGMENT28 || ''\n'' || SEGMENT29 || ''\n'' || SEGMENT30)' ;
28 	WHERE_FLEX	varchar2(4000) := 'CC.SEGMENT11 BETWEEN  ''00'' and ''11''' ;
29 	ORDERBY_BAL	varchar2(50) := 'CC.SEGMENT10' ;
30 	ORDERBY_ACCT	varchar2(30) := 'CC.SEGMENT10' ;
31 	ORDERBY_ALL	varchar2(800) := 'CC.SEGMENT1, CC.SEGMENT2, CC.SEGMENT3, CC.SEGMENT4, CC.SEGMENT5, CC.SEGMENT6,
32 	CC.SEGMENT7, CC.SEGMENT8, CC.SEGMENT9, CC.SEGMENT10, CC.SEGMENT11, CC.SEGMENT12, CC.SEGMENT13, CC.SEGMENT14,
33 	CC.SEGMENT15, CC.SEGMENT16, CC.SEGMENT17, CC.SEGMENT18, CC.SEGMENT19, CC.SEGMENT20, CC.SEGMENT21, CC.SEGMENT22,
34 	CC.SEGMENT23, CC.SEGMENT24, CC.SEGMENT25, CC.SEGMENT26, CC.SEGMENT27, CC.SEGMENT28, CC.SEGMENT29, CC.SEGMENT30' ;
35 	WHERE_ACTUAL_TYPE	varchar2(100) := 'budget_version_id = 1000' ;
36 	WHERE_CURRENCY_CODE	varchar2(200) := 'jeh.currency_code <> ''STAT''' ;
37 	SELECT_REFERENCE	varchar2(50) := 'jeh.external_reference' ;
38 	SELECT_CR	varchar2(500) := 'jel.accounted_cr' ;
39 	SELECT_DR	varchar2(500) := 'jel.accounted_dr' ;
40 	ORDER_BY	varchar2(5000) := 'cc.segment11, cc.segment12, cc.segment13, cc.segment14,
41 	cc.segment1, cc.segment2, cc.segment3, cc.segment4, cc.segment5, cc.segment6, cc.segment7,
42 	cc.segment8, cc.segment9, cc.segment10, cc.segment11, cc.segment12, cc.segment13, cc.segment14,
43 	cc.segment15, cc.segment16, cc.segment17, cc.segment18, cc.segment19, cc.segment20, cc.segment21,
44 	cc.segment22, cc.segment23, cc.segment24, cc.segment25, cc.segment26, cc.segment27, cc.segment28,
45 	cc.segment29, cc.segment30, src.user_je_source_name, cat.user_je_category_name, jeb.name, jeh.name' ;
46 	ORDERBY_BAL2	varchar2(800) := 'cc.segment1, cc.segment2, cc.segment3, cc.segment4, cc.segment5,
47 	cc.segment6, cc.segment7, cc.segment8, cc.segment9, cc.segment10, cc.segment11, cc.segment12,
48 	cc.segment13, cc.segment14, cc.segment15, cc.segment16, cc.segment17, cc.segment18, cc.segment19,
49 	cc.segment20, cc.segment21, cc.segment22, cc.segment23, cc.segment24, cc.segment25, cc.segment26,
50 	cc.segment27, cc.segment28, cc.segment29, cc.segment30' ;
51 	ORDERBY_ACCT2	varchar2(800) := 'cc.segment1, cc.segment2, cc.segment3, cc.segment4, cc.segment5,
52 	cc.segment6, cc.segment7, cc.segment8, cc.segment9, cc.segment10, cc.segment11, cc.segment12,
53 	cc.segment13, cc.segment14, cc.segment15, cc.segment16, cc.segment17, cc.segment18, cc.segment19,
54 	cc.segment20, cc.segment21, cc.segment22, cc.segment23, cc.segment24, cc.segment25, cc.segment26,
55 	cc.segment27, cc.segment28, cc.segment29, cc.segment30' ;
56 	WHERE_CURRENCY_BAL	varchar2(100) := '1 = 1' ;
57 	SECURITY_FILTER_STR	varchar2(150) := ' ';
58 	RESULTING_CURRENCY	varchar2(15);
59 	WHERE_DAS_BAL	varchar2(600);
60 	WHERE_DAS_JE	varchar2(600);
61 	SELECT_BEGIN_DR	varchar2(100) := 'sum(nvl(bal.begin_balance_dr,0))' ;
62 	SELECT_BEGIN_CR	varchar2(100) := 'sum(nvl(bal.begin_balance_cr,0))' ;
63 	SELECT_END_DR	varchar2(200) := 'sum(nvl(bal.begin_balance_dr,0) + nvl(bal.period_net_dr,0))' ;
64 	SELECT_END_CR	varchar2(200) := 'sum(nvl(bal.begin_balance_cr,0) + nvl(bal.period_net_cr,0))' ;
65 	PARAM_ACCT_FROM	varchar2(1000);
66 	PARAM_ACCT_TO	varchar2(1000);
67 	PARAM_PERIOD_FROM	varchar2(15);
68 	PARAM_PERIOD_TO	varchar2(15);
69 	PARAM_REFERENCE_TYPE	varchar2(80);
70 	DR_MEANING	varchar2(80);
71 	CR_MEANING	varchar2(80);
72 	PARAM_CURRENCY_TYPE	varchar2(1);
73 	function AfterReport return boolean  ;
74 	function begin_balformula(BEGIN_DR in number, BEGIN_CR in number) return number  ;
75 	function end_balformula(END_DR in number, END_CR in number) return number  ;
76 	function BUD_ENC_TYPE_NAMEFormula return VARCHAR2  ;
77 	function DISP_ACTUAL_FLAGFormula return VARCHAR2  ;
78 	function START_EFFECTIVE_PERIOD_NUMForm return Number ;
79 	function END_EFFECTIVE_PERIOD_NUMFormul return Number ;
80 	function BeforeReport return boolean  ;
81 	procedure gl_get_effective_num (tledger_id       IN NUMBER,
82                                 tperiod_name     IN VARCHAR2,
83                                 teffnum          OUT NOCOPY NUMBER,
84                                 errbuf           OUT NOCOPY VARCHAR2)
85  ;
86 	function g_maingroupfilter(FLEX_SECURE in varchar2) return boolean  ;
87 	function begin_bal_dr_crformula(BEGIN_DR in number, BEGIN_CR in number) return char  ;
88 	function end_bal_dr_crformula(END_DR in number, END_CR in number) return char  ;
89 	Function STRUCT_NUM_p return varchar2;
90 	Function ACCESS_SET_NAME_p return varchar2;
91 	Function SELECT_ALL_p return varchar2;
92 	Function WHERE_FLEX_p return varchar2;
93 	Function ORDERBY_BAL_p return varchar2;
94 	Function ORDERBY_ACCT_p return varchar2;
95 	Function ORDERBY_ALL_p return varchar2;
96 	Function WHERE_ACTUAL_TYPE_p return varchar2;
97 	Function WHERE_CURRENCY_CODE_p return varchar2;
98 	Function SELECT_REFERENCE_p return varchar2;
99 	Function SELECT_CR_p return varchar2;
100 	Function SELECT_DR_p return varchar2;
101 	Function ORDER_BY_p return varchar2;
102 	Function ORDERBY_BAL2_p return varchar2;
103 	Function ORDERBY_ACCT2_p return varchar2;
104 	Function WHERE_CURRENCY_BAL_p return varchar2;
105 	Function SECURITY_FILTER_STR_p return varchar2;
106 	Function RESULTING_CURRENCY_p return varchar2;
107 	Function WHERE_DAS_BAL_p return varchar2;
108 	Function WHERE_DAS_JE_p return varchar2;
109 	Function SELECT_BEGIN_DR_p return varchar2;
110 	Function SELECT_BEGIN_CR_p return varchar2;
111 	Function SELECT_END_DR_p return varchar2;
112 	Function SELECT_END_CR_p return varchar2;
113 	Function PARAM_ACCT_FROM_p return varchar2;
114 	Function PARAM_ACCT_TO_p return varchar2;
115 	Function PARAM_PERIOD_FROM_p return varchar2;
116 	Function PARAM_PERIOD_TO_p return varchar2;
117 	Function PARAM_REFERENCE_TYPE_p return varchar2;
118 	Function DR_MEANING_p return varchar2;
119 	Function CR_MEANING_p return varchar2;
120 	Function PARAM_CURRENCY_TYPE_p return varchar2;
121 END GL_GLRJED_XMLP_PKG;
122 
123