[Home] [Help]
PACKAGE: APPS.GL_GLXCOCRR_XMLP_PKG
Source
1 PACKAGE GL_GLXCOCRR_XMLP_PKG AS
2 /* $Header: GLXCOCRRS.pls 120.0 2007/12/27 14:52:08 vijranga noship $ */
3 P_CONC_REQUEST_ID number;
4 P_COA_MAPPING_ID number;
5 TO_CHART_OF_ACCOUNTS_ID varchar2(15) := '50105' ;
6 SELECT_FROM_FLEX_LOW varchar2(1000) := '(cfm.segment1_low||''\n''||cfm.segment2_low||''\n''||cfm.segment3_low||''\n''||cfm.segment4_low||''\n''||cfm.segment5_low||''\n''||cfm.segment6_low||''\n''||cfm.segment7_low||''\n''||cfm.segment8_low||
7 ''\n''||cfm.segment9_low||''\n''||cfm.segment10_low||''\n''||cfm.segment11_low||''\n''||cfm.segment12_low||''\n''||cfm.segment13_low||''\n''||cfm.segment14_low||''\n''||cfm.segment15_low||''\n''||cfm.segment16_low||''\n''||
8 cfm.segment17_low||''\n''||cfm.segment18_low||''\n''||cfm.segment19_low||''\n''||cfm.segment20_low||''\n''||cfm.segment21_low||''\n''||cfm.segment22_low||''\n''||cfm.segment23_low||''\n''||cfm.segment24_low||''\n''||cfm.segment25_low||
9 ''\n''||cfm.segment26_low||''\n''||cfm.segment27_low||''\n''||cfm.segment28_low||''\n''||cfm.segment29_low||''\n''||cfm.segment30_low)' ;
10 ORDERBY_FROM_FLEX_LOW varchar2(1000) := '(cfm.segment1_low||''\n''||cfm.segment2_low||''\n''||cfm.segment3_low||''\n''||cfm.segment4_low||''\n''||cfm.segment5_low||''\n''||cfm.segment6_low||''\n''||cfm.segment7_low||''\n''||cfm.segment8_low||
11 ''\n''||cfm.segment9_low||''\n''||cfm.segment10_low||''\n''||cfm.segment11_low||''\n''||cfm.segment12_low||''\n''||cfm.segment13_low||''\n''||cfm.segment14_low||''\n''||cfm.segment15_low||''\n''||cfm.segment16_low||''\n''||
12 cfm.segment17_low||''\n''||cfm.segment18_low||''\n''||cfm.segment19_low||''\n''||cfm.segment20_low||''\n''||cfm.segment21_low||''\n''||cfm.segment22_low||''\n''||cfm.segment23_low||''\n''||cfm.segment24_low||''\n''||cfm.segment25_low||
13 ''\n''||cfm.segment26_low||''\n''||cfm.segment27_low||''\n''||cfm.segment28_low||''\n''||cfm.segment29_low||''\n''||cfm.segment30_low)' ;
14 SELECT_TO_FLEX varchar2(1000) := '(CC.SEGMENT1 || ''\n'' || CC.SEGMENT2 || ''\n'' || CC.SEGMENT3 || ''\n'' || CC.SEGMENT4 || ''\n'' || CC.SEGMENT5 || ''\n'' || CC.SEGMENT6 || ''\n'' || CC.SEGMENT7 || ''\n'' || CC.SEGMENT8 || ''\n'' ||
15 CC.SEGMENT9 || ''\n'' || CC.SEGMENT10 || ''\n'' || CC.SEGMENT11 || ''\n'' || CC.SEGMENT12 || ''\n'' || CC.SEGMENT13 || ''\n'' || CC.SEGMENT14 || ''\n'' || CC.SEGMENT15 || ''\n'' || CC.SEGMENT16 || ''\n'' || CC.SEGMENT17 || ''\n'' ||
16 CC.SEGMENT18 || ''\n'' || CC.SEGMENT19 || ''\n'' || CC.SEGMENT20 || ''\n'' || CC.SEGMENT21 || ''\n'' || CC.SEGMENT22 || ''\n'' || CC.SEGMENT23 || ''\n'' || CC.SEGMENT24 || ''\n'' || CC.SEGMENT25 || ''\n'' || CC.SEGMENT26 || ''\n'' ||
17 CC.SEGMENT27 || ''\n'' || CC.SEGMENT28 || ''\n'' || CC.SEGMENT29 || ''\n'' || CC.SEGMENT30)';
18 ORDERBY_TO_FLEX varchar2(1000) := 'cc.segment1, cc.segment2, cc.segment3, cc.segment4, cc.segment5, cc.segment6, cc.segment7, cc.segment8, cc.segment9, cc.segment10, cc.segment11, cc.segment12, cc.segment13, cc.segment14, cc.segment15,
19 cc.segment16, cc.segment17, cc.segment18, cc.segment19, cc.segment20, cc.segment21, cc.segment22, cc.segment23, cc.segment24, cc.segment25, cc.segment26, cc.segment27, cc.segment28, cc.segment29, cc.segment30' ;
20 FROM_CHART_OF_ACCOUNTS_ID varchar2(25);
21 COA_MAP_NAME varchar2(33);
22 COA_MAP_DESCRIPTION varchar2(240);
23 START_DATE date;
24 END_DATE date;
25 SELECT_FROM_FLEX_HIGH varchar2(1000) := '(cfm.segment1_high||''\n''||cfm.segment2_high||''\n''||cfm.segment3_high||''\n''||cfm.segment4_high||''\n''||cfm.segment5_high||''\n''||cfm.segment6_high||''\n''||cfm.segment7_high||''\n''||
26 cfm.segment8_high||''\n''||cfm.segment9_high||''\n''||cfm.segment10_high||''\n''||cfm.segment11_high||''\n''||cfm.segment12_high||''\n''||cfm.segment13_high||''\n''||cfm.segment14_high||''\n''||cfm.segment15_high||''\n''||
27 cfm.segment16_high||''\n''||cfm.segment17_high||''\n''||cfm.segment18_high||''\n''||cfm.segment19_high||''\n''||cfm.segment20_high||''\n''||cfm.segment21_high||''\n''||cfm.segment22_high||''\n''||cfm.segment23_high||''\n''||
28 cfm.segment24_high||''\n''||cfm.segment25_high||''\n''||cfm.segment26_high||''\n''||cfm.segment27_high||''\n''||cfm.segment28_high||''\n''||cfm.segment29_high||''\n''||cfm.segment30_high)' ;
29 ORDERBY_FROM_FLEX_HIGH varchar2(1000) := '(cfm.segment1_high||''\n''||cfm.segment2_high||''\n''||cfm.segment3_high||''\n''||cfm.segment4_high||''\n''||cfm.segment5_high||''\n''||cfm.segment6_high||''\n''||cfm.segment7_high||''\n''||
30 cfm.segment8_high||''\n''||cfm.segment9_high||''\n''||cfm.segment10_high||''\n''||cfm.segment11_high||''\n''||cfm.segment12_high||''\n''||cfm.segment13_high||''\n''||cfm.segment14_high||''\n''||cfm.segment15_high||''\n''||
31 cfm.segment16_high||''\n''||cfm.segment17_high||''\n''||cfm.segment18_high||''\n''||cfm.segment19_high||''\n''||cfm.segment20_high||''\n''||cfm.segment21_high||''\n''||cfm.segment22_high||''\n''||cfm.segment23_high||''\n''||
32 cfm.segment24_high||''\n''||cfm.segment25_high||''\n''||cfm.segment26_high||''\n''||cfm.segment27_high||''\n''||cfm.segment28_high||''\n''||cfm.segment29_high||''\n''||cfm.segment30_high)';
33 ADB_USED varchar2(1);
34 TO_COA_NAME varchar2(30);
35 FROM_COA_NAME varchar2(30);
36 function from_flexfield_lowformula(FROM_FLEXFIELD_LOW in varchar2) return varchar2 ;
37 function AfterReport return boolean ;
38 function from_flexfield_highformula(FROM_FLEXFIELD_HIGH in varchar2) return varchar2 ;
39 function BeforeReport return boolean ;
40 procedure gl_get_mapping_info(
41 map_id NUMBER, map_name OUT NOCOPY VARCHAR2,
42 from_coa_id OUT NOCOPY NUMBER, to_coa_id OUT NOCOPY NUMBER,
43 description OUT NOCOPY VARCHAR2,start_date_active OUT NOCOPY DATE,
44 end_date_active OUT NOCOPY DATE,
45 errbuf OUT NOCOPY VARCHAR2) ;
46 FUNCTION B_COA_NAME(x_segment NUMBER) RETURN VARCHAR ;
47 Function TO_CHART_OF_ACCOUNTS_ID_p return varchar2;
48 Function SELECT_FROM_FLEX_LOW_p return varchar2;
49 Function ORDERBY_FROM_FLEX_LOW_p return varchar2;
50 Function SELECT_TO_FLEX_p return varchar2;
51 Function ORDERBY_TO_FLEX_p return varchar2;
52 Function FROM_CHART_OF_ACCOUNTS_ID_p return varchar2;
53 Function COA_MAP_NAME_p return varchar2;
54 Function COA_MAP_DESCRIPTION_p return varchar2;
55 Function START_DATE_p return date;
56 Function END_DATE_p return date;
57 Function SELECT_FROM_FLEX_HIGH_p return varchar2;
58 Function ORDERBY_FROM_FLEX_HIGH_p return varchar2;
59 Function ADB_USED_p return varchar2;
60 Function TO_COA_NAME_p return varchar2;
61 Function FROM_COA_NAME_p return varchar2;
62 END GL_GLXCOCRR_XMLP_PKG;
63
64