PACKAGE: APPS.PSB_PSBOTGLR_XMLP_PKG

Source

1 PACKAGE PSB_PSBOTGLR_XMLP_PKG AS
2 /* $Header: PSBOTGLRS.pls 120.0 2008/01/07 10:29:21 vijranga noship $ */
3   P_WORKSHEET_ID VARCHAR2(40);
4   P_CONC_REQUEST_ID VARCHAR2(15) := '0';
5   P_ORDER_BY1 VARCHAR2(30);
6   P_ORDER_BY2 VARCHAR2(30);
7   P_ORDER_BY3 VARCHAR2(30);
8   P_GL_BUDGET_SET_ID NUMBER;
9   P_BUDGET_SOURCE_TYPE VARCHAR2(2);
10   P_BUDGET_YEAR_ID NUMBER;
11   P_UNPOSTED VARCHAR2(1);
12   P_CURRENCY_CODE VARCHAR2(32767);
13   CP_1 NUMBER;
14   SELECT_DR VARCHAR2(500) := 'INTR.ENTERED_DR';
15   CP_CURRENCY_CODE VARCHAR2(15) := 'USD';
16   CP_SOB_NAME VARCHAR2(30) := 'No Company Name';
17   SELECT_CR VARCHAR2(500) := 'INTR.ENTERED_CR';
18   SELECT_ALL VARCHAR2(1000) := '(CC.SEGMENT1 || ''\n'' || SEGMENT2 || ''\n'' || SEGMENT3
19   || ''\n'' || SEGMENT4 || ''\n'' || SEGMENT5 || ''\n'' || SEGMENT6 || ''\n'' || SEGMENT7
20   || ''\n'' || SEGMENT8 || ''\n'' || SEGMENT9 || ''\n'' || SEGMENT10 || ''\n'' || SEGMENT11
21   || ''\n'' || SEGMENT12 || ''\n'' || SEGMENT13 || ''\n'' || SEGMENT14 || ''\n'' || SEGMENT15
22   || ''\n'' || SEGMENT16 || ''\n'' || SEGMENT17 || ''\n'' || SEGMENT18 || ''\n'' || SEGMENT19
23   || ''\n'' || SEGMENT20 || ''\n'' || SEGMENT21 || ''\n'' || SEGMENT22 || ''\n'' || SEGMENT23
24   || ''\n'' || SEGMENT24 || ''\n'' || SEGMENT25 || ''\n'' || SEGMENT26 || ''\n'' || SEGMENT27
25   || ''\n'' || SEGMENT28 || ''\n'' || SEGMENT29 || ''\n'' || SEGMENT30)';
26   STRUCT_NUM VARCHAR2(15) := '101';
27   C_NLS_END_OF_REPORT VARCHAR2(80);
28   C_NLS_NO_DATA_EXISTS VARCHAR2(80);
29   CP_BUDGET_STAGE VARCHAR2(30) := 'Not Found';
30   CP_BUDGET_YEAR VARCHAR2(30) := 'Not Found';
31   CP_BUDGET_NAME VARCHAR2(30) := 'Not Found';
32   CP_CATEGORY VARCHAR2(30) := 'Not Found';
33   CP_SUMMDET VARCHAR2(30) := 'Not Found';
34   ACCOUNTING_SEGMENT VARCHAR2(1000) := '(segment1||''\n''||segment2||''\n''||segment3||''\n''||segment4
35   ||''\n''||segment5||''\n''||segment6||''\n''||segment7||''\n''||segment8||''\n''||segment9||''\n''||
36   segment10||''\n''||segment11||''\n''||segment12||''\n''||segment13||''\n''||segment14||''\n''||segment15||''\n''||
37   segment16||''\n''||segment17||''\n''||segment18||''\n''||segment19||''\n''||segment20||''\n''||segment21||''\n''||
38   segment22||''\n''||segment23||''\n''||segment24||''\n''||segment25||''\n''||segment26||''\n''||segment27||''\n''||
39   segment28||''\n''||segment29||''\n''||segment30)';
40   CP_SORT VARCHAR2(100);
41   CP_BUDGET_SET_NAME VARCHAR2(80);
42   CP_REVISION_TYPE VARCHAR2(80);
43   CP_PERMANENT_REVISION VARCHAR2(80);
44   CP_BUDGET_YEAR_ID NUMBER;
45   CP_BUDGET_SET_ID NUMBER;
46   FUNCTION BEFOREREPORT RETURN BOOLEAN;
47   FUNCTION AFTERREPORT RETURN BOOLEAN;
48   FUNCTION GET_NLS_STRINGS RETURN BOOLEAN;
49   FUNCTION BEFOREPFORM RETURN BOOLEAN;
50   FUNCTION AFTERPFORM RETURN BOOLEAN;
51   FUNCTION BETWEENPAGE RETURN BOOLEAN;
52   FUNCTION CP_1_P RETURN NUMBER;
53   FUNCTION SELECT_DR_P RETURN VARCHAR2;
54   FUNCTION CP_CURRENCY_CODE_P RETURN VARCHAR2;
55   FUNCTION CP_SOB_NAME_P RETURN VARCHAR2;
56   FUNCTION SELECT_CR_P RETURN VARCHAR2;
57   FUNCTION SELECT_ALL_P RETURN VARCHAR2;
58   FUNCTION STRUCT_NUM_P RETURN VARCHAR2;
59   FUNCTION C_NLS_END_OF_REPORT_P RETURN VARCHAR2;
60   FUNCTION C_NLS_NO_DATA_EXISTS_P RETURN VARCHAR2;
61   FUNCTION CP_BUDGET_STAGE_P RETURN VARCHAR2;
62   FUNCTION CP_BUDGET_YEAR_P RETURN VARCHAR2;
63   FUNCTION CP_BUDGET_NAME_P RETURN VARCHAR2;
64   FUNCTION CP_CATEGORY_P RETURN VARCHAR2;
65   FUNCTION CP_SUMMDET_P RETURN VARCHAR2;
66   FUNCTION ACCOUNTING_SEGMENT_P RETURN VARCHAR2;
67   FUNCTION CP_SORT_P RETURN VARCHAR2;
68   FUNCTION CP_BUDGET_SET_NAME_P RETURN VARCHAR2;
69   FUNCTION CP_REVISION_TYPE_P RETURN VARCHAR2;
70   FUNCTION CP_PERMANENT_REVISION_P RETURN VARCHAR2;
71   FUNCTION CP_BUDGET_YEAR_ID_P RETURN NUMBER;
72   FUNCTION CP_BUDGET_SET_ID_P RETURN NUMBER;
73 END PSB_PSBOTGLR_XMLP_PKG;
74 
75 
76 
77 
78 
79