[Home] [Help]
PACKAGE: APPS.GL_GLRFGNJ_XMLP_PKG
Source
1 PACKAGE GL_GLRFGNJ_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: GLRFGNJS.pls 120.0 2007/12/27 14:36:23 vijranga noship $ */
3 P_CONC_REQUEST_ID number;
4 P_JE_SOURCE_NAME varchar2(25);
5 STAT varchar2(100);
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_PAGESIZE number;
11 P_START_DATE date;
12 P_END_DATE date;
13 P_KIND varchar2(1);
14 P_LEDGER_ID number;
15 P_ACCESS_SET_ID number;
16
17 FLEXDATA varchar2(5000) := '(segment1||''\n''||segment2||''\n''||segment3||''\n''||
18 segment4||''\n''||segment5||''\n''||segment6||''\n''||segment7||''\n''||segment8||''\n''||segment9||
19 ''\n''||segment10||''\n''||segment11||''\n''||segment12||''\n''||segment13||''\n''||segment14||''\n''||
20 segment15||''\n''||segment16||''\n''||segment17||''\n''||segment18||''\n''||segment19||''\n''||
21 segment20||''\n''||segment21||''\n''||segment22||''\n''||segment23||''\n''||segment24||''\n''||segment25
22 ||''\n''||segment26||''\n''||segment27||''\n''||segment28||''\n''||segment29||''\n''||segment30)' ;
23 POSTING_STATUS_SELECT varchar2(1000) := 'reference_1' ;
24 POSTING_STATUS_WHERE varchar2(1000) := '1 = 1' ;
25 PERIOD_WHERE varchar2(1000) := '1 = 1' ;
26 STRUCT_NUM varchar2(15) := '50105' ;
27 PARAM_LEDGER_NAME varchar2(30);
28 INV_FLEX_MSG varchar2(100);
29 DEBIT_DSP varchar2(240);
30 CREDIT_DSP varchar2(240);
31 WIDTH number := 19 ;
32 DAS_WHERE varchar2(600);
33 ACCESS_SET_NAME varchar2(30);
34 PARAM_LEDGER_TYPE varchar2(1) := 'S' ;
35 CURR_FORMAT_MASK varchar2(100);
36 THOUSANDS_SEPARATOR varchar2(80);
37 MIXED_PRECISION number;
38 LEDGER_WHERE varchar2(150):= ' ';
39 LEDGER_FROM varchar2(50):= ' ';
40 CONSOLIDATION_LEDGER_FLAG varchar2(1) := 'S' ;
41 PARAM_LEDGER_CURR varchar2(15);
42 function BeforeReport return boolean ;
43 function AfterReport return boolean ;
44 function ent_x_drcrformula(DR_CR in number, ENTERED_AMOUNT in number) return number ;
45 function acct_x_drcrformula(DR_CR in number, ACCOUNTED_AMOUNT in varchar2) return number ;
46 function dr_cr_dspformula(DR_CR in number) return varchar2 ;
47 function g_linesgroupfilter(FLEXDATA_SECURE in varchar2) return boolean ;
48 --function gl_format_currency(amount number)(Amount NUMBER) return varchar2 ;
49 function gl_format_currency(amount in number)return varchar2 ;
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 STRUCT_NUM_p return varchar2;
55 Function PARAM_LEDGER_NAME_p return varchar2;
56 Function INV_FLEX_MSG_p return varchar2;
57 Function DEBIT_DSP_p return varchar2;
58 Function CREDIT_DSP_p return varchar2;
59 Function WIDTH_p return number;
60 Function DAS_WHERE_p return varchar2;
61 Function ACCESS_SET_NAME_p return varchar2;
62 Function PARAM_LEDGER_TYPE_p return varchar2;
63 Function CURR_FORMAT_MASK_p return varchar2;
64 Function THOUSANDS_SEPARATOR_p return varchar2;
65 Function MIXED_PRECISION_p return number;
66 Function LEDGER_WHERE_p return varchar2;
67 Function LEDGER_FROM_p return varchar2;
68 Function CONSOLIDATION_LEDGER_FLAG_p return varchar2;
69 Function PARAM_LEDGER_CURR_p return varchar2;
70 END GL_GLRFGNJ_XMLP_PKG;
71
72