[Home] [Help]
PACKAGE: APPS.GL_GLYRLBGE_XMLP_PKG
Source
1 PACKAGE GL_GLYRLBGE_XMLP_PKG AS
2 /* $Header: GLYRLBGES.pls 120.0 2007/12/27 15:26:37 vijranga noship $ */
3 P_LEDGER_ID varchar2(40);
4 P_PERIOD_NAME varchar2(40);
5 P_START_ACCOUNT varchar2(40);
6 P_END_ACCOUNT varchar2(40);
7 P_COMPANY varchar2(40);
8 P_CURRENCY_CODE varchar2(40);
9 P_CONC_REQUEST_ID number;
10
11 P_MINPRECISION number;
12 P_PRECISION number;
13 P_LEDGER_NAME varchar2(30);
14 P_CURRENCY_TYPE varchar2(32767);
15 P_LEDGER_CURRENCY varchar2(32767);
16 P_ENTERED_CURRENCY varchar2(32767);
17 P_CHART_OF_ACCOUNTS_ID number;
18 P_ACCESS_SET_ID number;
19 BEGIN_CR_SELECT varchar2(1000) := '1' ;
20 CURRENCY_NAME varchar2(80) := 'US Dollars' ;
21 ACCOUNTING_SEGMENT_WHERE varchar2(1000) := '1 = 1' ;
22 BEGIN_DR_SELECT varchar2(1000) := '1' ;
23 END_DR_SELECT varchar2(1000) := '1' ;
24 FIRST_PERIOD_NAME varchar2(40);
25 ACCOUNTING_ORDERBY varchar2(1000) := '1' ;
26 BALANCING_ORDERBY varchar2(1000) := '1' ;
27 BALANCING_SEGMENT_WHERE varchar2(1000) := '1 = 1' ;
28 STRUCT_NUM varchar2(40) := '50104' ;
29 BALANCING_SEGMENT varchar2(5000) := 'cc.segment1' ;
30 PER_DR_SELECT varchar2(1000) := '1' ;
31 ACCOUNTING_SEGMENT varchar2(5000) := 'cc.segment2' ;
32 END_CR_SELECT varchar2(1000) := '1' ;
33 PER_CR_SELECT varchar2(1000) := '1' ;
34 TRANSLATE_WHERE varchar2(200);
35 C_industry_code varchar2(20);
36 CURRENCY_WHERE varchar2(1000) := '1 = 1' ;
37 ACCESS_WHERE varchar2(2000) := '1 = 1' ;
38 ACTUAL_CURRENCY varchar2(20);
39 ACCESS_NAME varchar2(30);
40 function BeforeReport return boolean ;
41 function net_crformula(NET in number) return number ;
42 function comp_net_crformula(COMP_NET in number) return number ;
43 function cl_net_crformula(CL_NET in number) return number ;
44 function sc_net_crformula(SC_NET in number) return number ;
45 function gr_net_crformula(GR_NET in number) return number ;
46 procedure gl_get_ledger_info ( ledgerid in number,
47 coaid out NOCOPY number,
48 ledgername out NOCOPY varchar2,
49 func_curr out NOCOPY varchar2,
50 errbuf out NOCOPY varchar2)
51 ;
52 procedure gl_get_first_period(tledger_id in number,
53 tperiod_name in varchar2,
54 tfirst_period out NOCOPY varchar2,
55 errbuf out NOCOPY varchar2)
56
57 ;
58 function grand_net_crformula(GRAND_NET in number) return number ;
59 function c_bal_lpromptformula(C_BAL_LPROMPT in varchar2) return varchar2 ;
60 procedure get_industry_code ;
61 function set_display_for_gov return boolean ;
62 function set_display_for_core return boolean ;
63 function g_maingroupfilter(ACCT_SECURE in varchar2, BEGIN_CR in number, BEGIN_DR in number, PER_DR in number, PER_CR in number) return boolean ;
64 function g_companygroupfilter(BAL_SECURE in varchar2) return boolean ;
65 function G_ClassGroupFilter return boolean ;
66 function zero_indicatorformula(BEGIN_CR in number, BEGIN_DR in number, PER_DR in number, PER_CR in number) return number ;
67 function g_sub_classgroupfilter(BEGIN_CR in number, BEGIN_DR in number, PER_DR in number, PER_CR in number) return boolean ;
68 function g_groupsgroupfilter(BEGIN_CR in number, BEGIN_DR in number, PER_DR in number, PER_CR in number) return boolean ;
69 function company_lprompt_ndformula(COMPANY_LPROMPT_ND in varchar2) return char ;
70 function AfterReport return boolean ;
71 Function BEGIN_CR_SELECT_p return varchar2;
72 Function CURRENCY_NAME_p return varchar2;
73 Function ACCOUNTING_SEGMENT_WHERE_p return varchar2;
74 Function BEGIN_DR_SELECT_p return varchar2;
75 Function END_DR_SELECT_p return varchar2;
76 Function FIRST_PERIOD_NAME_p return varchar2;
77 Function ACCOUNTING_ORDERBY_p return varchar2;
78 Function BALANCING_ORDERBY_p return varchar2;
79 Function BALANCING_SEGMENT_WHERE_p return varchar2;
80 Function STRUCT_NUM_p return varchar2;
81 Function BALANCING_SEGMENT_p return varchar2;
82 Function PER_DR_SELECT_p return varchar2;
83 Function ACCOUNTING_SEGMENT_p return varchar2;
84 Function END_CR_SELECT_p return varchar2;
85 Function PER_CR_SELECT_p return varchar2;
86 Function TRANSLATE_WHERE_p return varchar2;
87 Function C_industry_code_p return varchar2;
88 Function CURRENCY_WHERE_p return varchar2;
89 Function ACCESS_WHERE_p return varchar2;
90 Function ACTUAL_CURRENCY_p return varchar2;
91 Function ACCESS_NAME_p return varchar2;
92 END GL_GLYRLBGE_XMLP_PKG;
93
94