DBA Data[Home] [Help]

PACKAGE: APPS.GL_GLRGNJ_XMLP_PKG

Source


1 PACKAGE GL_GLRGNJ_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: GLRGNJS.pls 120.0 2007/12/27 14:37:18 vijranga noship $ */
3 	P_CONC_REQUEST_ID	number;
4 	P_JE_SOURCE_NAME	varchar2(25);
5 	STAT varchar2(120);
6 	P_PERIOD_NAME	varchar2(15);
7 	P_BATCH_NAME	varchar2(100);
8 	P_POSTING_STATUS	varchar2(1);
9 	P_CURRENCY_CODE	varchar2(15);
10 	P_START_DATE	date;
11 	P_END_DATE	date;
12 	P_PAGESIZE	number;
13 	P_KIND	varchar2(1);
14 	P_LEDGER_ID	number;
15 	P_ACCESS_SET_ID	number;
16 		FLEXDATA	varchar2(5000) := '(segment1||''\n''||segment2||''\n''||
17 		segment3||''\n''||segment4||''\n''||segment5||''\n''||segment6||''\n''||
18 		segment7||''\n''||segment8||''\n''||segment9||''\n''||segment10||''\n''||
19 		segment11||''\n''||segment12||''\n''||segment13||''\n''||segment14||''\n''||
20 		segment15||''\n''||segment16||''\n''||segment17||''\n''||segment18||''\n''||
21 		segment19||''\n''||segment20||''\n''||segment21||''\n''||segment22||''\n''||
22 		segment23||''\n''||segment24||''\n''||segment25||''\n''||segment26||''\n''||
23 		segment27||''\n''||segment28||''\n''||segment29||''\n''||segment30)' ;
24 	POSTING_STATUS_SELECT	varchar2(1000) := 'reference_1' ;
25 	POSTING_STATUS_WHERE	varchar2(1000) := '1 = 1' ;
26 	PERIOD_WHERE	varchar2(1000) := '1 = 1' ;
27 	CURRENCY_WHERE	varchar2(100) := '1 = 1' ;
28 	STRUCT_NUM	varchar2(15) := '50105' ;
29 	PARAM_LEDGER_NAME	varchar2(30);
30 	INV_FLEX_MSG	varchar2(100);
31 	WIDTH	number := 19 ;
32 	JE_USER_SOURCE_DSP	varchar2(25);
33 	ACCESS_SET_NAME	varchar2(30);
34 	DAS_WHERE	varchar2(600);
35 	LEDGER_FROM	varchar2(50);
36 	LEDGER_WHERE	varchar2(150):=' ';
37 	PARAM_LEDGER_TYPE	varchar2(1) := 'S' ;
38 	CONSOLIDATION_LEDGER_FLAG	varchar2(1);
39 	PARAM_CURRENCY	varchar2(15);
40 	PARAM_PERIOD_NAME	varchar2(15);
41 	PARAM_START_DATE	date;
42 	PARAM_END_DATE	date;
43 	PARAM_REFERENCE_TYPE	varchar2(80);
44 	PARAM_POSTING_STATUS	varchar2(80);
45 	PERIOD_FROM	varchar2(15);
46 	PERIOD_TO	varchar2(15);
47 	function BeforeReport return boolean  ;
48 	function AfterReport return boolean  ;
49 	function g_linesgroupfilter(FLEXDATA_SECURE in varchar2) return boolean  ;
50 	Function FLEXDATA_p return varchar2;
51 	Function POSTING_STATUS_SELECT_p return varchar2;
52 	Function POSTING_STATUS_WHERE_p return varchar2;
53 	Function PERIOD_WHERE_p return varchar2;
54 	Function CURRENCY_WHERE_p return varchar2;
55 	Function STRUCT_NUM_p return varchar2;
56 	Function PARAM_LEDGER_NAME_p return varchar2;
57 	Function INV_FLEX_MSG_p return varchar2;
58 	Function WIDTH_p return number;
59 	Function JE_USER_SOURCE_DSP_p return varchar2;
60 	Function ACCESS_SET_NAME_p return varchar2;
61 	Function DAS_WHERE_p return varchar2;
62 	Function LEDGER_FROM_p return varchar2;
63 	Function LEDGER_WHERE_p return varchar2;
64 	Function PARAM_LEDGER_TYPE_p return varchar2;
65 	Function CONSOLIDATION_LEDGER_FLAG_p return varchar2;
66 	Function PARAM_CURRENCY_p return varchar2;
67 	Function PARAM_PERIOD_NAME_p return varchar2;
68 	Function PARAM_START_DATE_p return date;
69 	Function PARAM_END_DATE_p return date;
70 	Function PARAM_REFERENCE_TYPE_p return varchar2;
71 	Function PARAM_POSTING_STATUS_p return varchar2;
72 	Function PERIOD_FROM_p return varchar2;
73 	Function PERIOD_TO_p return varchar2;
74 END GL_GLRGNJ_XMLP_PKG;
75