[Home] [Help]
PACKAGE: APPS.GL_GLXRCTRS_XMLP_PKG
Source
1 PACKAGE GL_GLXRCTRS_XMLP_PKG AS
2 /* $Header: GLXRCTRSS.pls 120.0 2007/12/27 15:08:11 vijranga noship $ */
3 C_BASE_CURR varchar2(15);
4 C_STRUCT_NUM varchar2(15);
5 C_WHERE_FLEX varchar2(10000);
6 C_WHERE_ACCT varchar2(300);
7 C_SELECT_COMP varchar2(600);
8 C_SELECT_ACCT varchar2(600);
9 C_SELECT_DET_COMP varchar2(600);
10 C_SELECT_DET_ACCT varchar2(600);
11 P_CONC_REQUEST_ID number;
12 C_ORDERBY_COMP varchar2(240);
13 C_ORDERBY_ACCT varchar2(240);
14 P_START_DATE date;
15 P_END_DATE date;
16 P_AMOUNT_TYPE varchar2(10);
17 P_FLEX_FROM varchar2(900);
18 P_FLEX_TO varchar2(900);
19 P_LEDGER_CURRENCY varchar2(15);
20 P_PERIOD_TO varchar2(15);
21 P_PERIOD_FROM varchar2(15);
22 P_LEDGER_ID number;
23 CP_EFF_PERIOD_START number;
24 C_LEDGER_NAME varchar2(50);
25 P_ACCESS_SET_ID number;
26 C_ACCESS_SET_NAME varchar2(40);
27 P_LEDGER_NAME varchar2(40);
28 C_WHERE_REC_STATUS varchar2(100);
29 P_REC_UNREC varchar2(1);
30 C_ACC_FLEX varchar2(600):='(c.SEGMENT1||''\n''||c.SEGMENT2||''\n''||c.SEGMENT3||''\n''||c.SEGMENT4||''\n''||c.SEGMENT5||''\n''||c.SEGMENT6||''\n''||c.SEGMENT7||''\n''||c.SEGMENT8||''\n''||c.SEGMENT9||''\n''||c.SEGMENT10||''\n''
31 ||c.SEGMENT11||''\n''||c.SEGMENT12||''\n''||c.SEGMENT13||''\n''||c.SEGMENT14||''\n''||c.SEGMENT15||''\n''||c.SEGMENT16||''\n''||c.SEGMENT17||''\n''||c.SEGMENT18||''\n''||c.SEGMENT19||''\n''||c.SEGMENT20||''\n''||c.SEGMENT21||
32 ''\n''||c.SEGMENT22||''\n''||c.SEGMENT23||''\n''||c.SEGMENT24||''\n''||c.SEGMENT25||''\n''||c.SEGMENT26||''\n''||c.SEGMENT27||''\n''||c.SEGMENT28||''\n''||c.SEGMENT29||''\n''||c.SEGMENT30)';
33 CP_COUNT_REC number := 0 ;
34 C_WHERE_DATE varchar2(240);
35 --C_WHERE_CURRENCY varchar2(240);
36 C_WHERE_CURRENCY varchar2(240):=' ';
37 C_WHERE_REF varchar2(240);
38 C_RECON_ID number;
39 C_LOGIN_ID number;
40 CP_period_start date;
41 CP_period_end date;
42 CP_start_date varchar2(20);
43 CP_end_date varchar2(20);
44 CP_EFF_PERIOD_END number;
45 COUNT_ROWS number;
46 --C_WHERE_DAS varchar2(600);
47 C_WHERE_DAS varchar2(600):=' ';
48 C_JGZZ_RECON_FLAG varchar2(50);
49 function BeforeReport return boolean ;
50 function AfterReport return boolean ;
51 function P_AMOUNT_TYPEValidTrigger return boolean ;
52 function CF_sysdate_dateFormula return Char ;
53 Function CP_COUNT_REC_p return number;
54 Function C_WHERE_DATE_p return varchar2;
55 Function C_WHERE_CURRENCY_p return varchar2;
56 Function C_WHERE_REF_p return varchar2;
57 Function C_RECON_ID_p return number;
58 Function C_LOGIN_ID_p return number;
59 Function CP_period_start_p return date;
60 Function CP_period_end_p return date;
61 Function CP_start_date_p return varchar2;
62 Function CP_end_date_p return varchar2;
63 Function CP_EFF_PERIOD_END_p return number;
64 Function COUNT_ROWS_p return number;
65 Function C_WHERE_DAS_p return varchar2;
66 Function C_JGZZ_RECON_FLAG_p return varchar2;
67 END GL_GLXRCTRS_XMLP_PKG;
68