[Home] [Help]
PACKAGE: APPS.GL_GLRGNJ_XMLP_PKG
Source
1 PACKAGE GL_GLRGNJ_XMLP_PKG 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