DBA Data[Home] [Help]

PACKAGE: APPS.GL_GLXRLFBL_XMLP_PKG

Source


1 PACKAGE GL_GLXRLFBL_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: GLXRLFBLS.pls 120.0 2007/12/27 15:13:44 vijranga noship $ */
3 	P_CONC_REQUEST_ID	number;
4 	P_LEDGER_ID	number;
5 	P_ACCESS_SET_ID	number;
6 	STRUCT_NUM	varchar2(15);
7 	LEDGER_NAME	varchar2(30);
8 	FLEX_SELECT_ALL_LOW	varchar2(1000) := '(gbfr.SEGMENT1_LOW || ''\n'' || gbfr.SEGMENT2_LOW || ''\n'' || gbfr.SEGMENT3_LOW || ''\n'' || gbfr.SEGMENT4_LOW || ''\n'' || gbfr.SEGMENT5_LOW || ''\n'' || gbfr.SEGMENT6_LOW || ''\n'' ||
9 	gbfr.SEGMENT7_LOW || ''\n'' || gbfr.SEGMENT8_LOW || ''\n'' || gbfr.SEGMENT9_LOW || ''\n'' || gbfr.SEGMENT10_LOW || ''\n'' || gbfr.SEGMENT11_LOW || ''\n'' || gbfr.SEGMENT12_LOW || ''\n'' || gbfr.SEGMENT13_LOW || ''\n'' || gbfr.SEGMENT14_LOW ||
10 	''\n'' || gbfr.SEGMENT15_LOW || ''\n'' || gbfr.SEGMENT16_LOW || ''\n'' || gbfr.SEGMENT17_LOW || ''\n'' || gbfr.SEGMENT18_LOW || ''\n'' || gbfr.SEGMENT19_LOW || ''\n'' || gbfr.SEGMENT20_LOW || ''\n'' || gbfr.SEGMENT21_LOW || ''\n'' ||
11 	gbfr.SEGMENT22_LOW || ''\n'' || gbfr.SEGMENT23_LOW || ''\n'' || gbfr.SEGMENT24_LOW || ''\n'' || gbfr.SEGMENT25_LOW || ''\n'' || gbfr.SEGMENT26_LOW || ''\n'' || gbfr.SEGMENT27_LOW || ''\n'' || gbfr.SEGMENT28_LOW || ''\n'' ||
12 	gbfr.SEGMENT29_LOW || ''\n'' || gbfr.SEGMENT30_LOW)' ;
13 
14 	FLEX_SELECT_ALL_HIGH	varchar2(1000) := '(gbfr.SEGMENT1_HIGH || ''\n'' || gbfr.SEGMENT2_HIGH || ''\n'' || gbfr.SEGMENT3_HIGH || ''\n'' || gbfr.SEGMENT4_HIGH || ''\n'' || gbfr.SEGMENT5_HIGH || ''\n'' || gbfr.SEGMENT6_HIGH ||
15 	''\n'' || gbfr.SEGMENT7_HIGH || ''\n'' || gbfr.SEGMENT8_HIGH || ''\n'' || gbfr.SEGMENT9_HIGH || ''\n'' || gbfr.SEGMENT10_HIGH || ''\n'' || gbfr.SEGMENT11_HIGH || ''\n'' || gbfr.SEGMENT12_HIGH || ''\n'' || gbfr.SEGMENT13_HIGH
16 	|| ''\n'' || gbfr.SEGMENT14_HIGH || ''\n'' || gbfr.SEGMENT15_HIGH || ''\n'' || gbfr.SEGMENT16_HIGH || ''\n'' || gbfr.SEGMENT17_HIGH || ''\n'' || gbfr.SEGMENT18_HIGH || ''\n'' || gbfr.SEGMENT19_HIGH || ''\n'' ||
17 	gbfr.SEGMENT20_HIGH || ''\n'' || gbfr.SEGMENT21_HIGH || ''\n'' || gbfr.SEGMENT22_HIGH || ''\n'' || gbfr.SEGMENT23_HIGH || ''\n'' || gbfr.SEGMENT24_HIGH || ''\n'' || gbfr.SEGMENT25_HIGH || ''\n'' ||
18 	gbfr.SEGMENT26_HIGH || ''\n'' || gbfr.SEGMENT27_HIGH || ''\n'' || gbfr.SEGMENT28_HIGH || ''\n'' || gbfr.SEGMENT29_HIGH || ''\n'' || gbfr.SEGMENT30_HIGH)' ;
19 
20 	ACCESS_SET_NAME	varchar2(30);
21 	function BeforeReport return boolean  ;
22 	function AfterReport return boolean  ;
23 	function flex_field_all_lowformula(FLEX_FIELD_ALL_LOW in varchar2) return varchar2  ;
24 	function flex_field_all_highformula(FLEX_FIELD_ALL_HIGH in varchar2) return varchar2  ;
25 	Function STRUCT_NUM_p return varchar2;
26 	Function LEDGER_NAME_p return varchar2;
27 	Function FLEX_SELECT_ALL_LOW_p return varchar2;
28 	Function FLEX_SELECT_ALL_HIGH_p return varchar2;
29 	Function ACCESS_SET_NAME_p return varchar2;
30 END GL_GLXRLFBL_XMLP_PKG;
31 
32