PACKAGE: APPS.PSB_PSBBGASR_XMLP_PKG

Source

1 PACKAGE PSB_PSBBGASR_XMLP_PKG AS
2 /* $Header: PSBBGASRS.pls 120.1 2008/02/22 07:59:08 vijranga noship $ */
3   P_SET_OF_BOOKS_ID NUMBER;
4 
5   P_CONC_REQUEST_ID NUMBER := 0;
6 
7   P_BUDGET_GROUP_ID NUMBER;
8 
9   P_PRINT_SUBGROUPS_FLAG VARCHAR2(1);
10 
11   CP_FLEXDATA_HIGH VARCHAR2(1000) := '(lines.segment1_high || ''\n'' ||
12   lines.segment2_high || ''\n'' || lines.segment3_high || ''\n'' ||
13   lines.segment4_high || ''\n'' || lines.segment5_high || ''\n'' ||
14   lines.segment6_high || ''\n'' || lines.segment7_high || ''\n'' ||
15   lines.segment8_high || ''\n'' || lines.segment9_high || ''\n'' ||
16   lines.segment10_high || ''\n'' || lines.segment11_high || ''\n'' ||
17   lines.segment12_high || ''\n'' || lines.segment13_high || ''\n'' ||
18   lines.segment14_high || ''\n'' || lines.segment15_high || ''\n'' ||
19   lines.segment16_high || ''\n'' || lines.segment17_high || ''\n'' ||
20   lines.segment18_high || ''\n'' || lines.segment19_high || ''\n'' || lines.segment20_high || ''\n'' ||
21   lines.segment21_high || ''\n'' || lines.segment22_high || ''\n'' || lines.segment23_high || ''\n'' ||
22   lines.segment24_high || ''\n'' || lines.segment25_high || ''\n'' || lines.segment26_high || ''\n'' ||
23   lines.segment27_high || ''\n'' || lines.segment28_high || ''\n'' || lines.segment29_high || ''\n'' ||
24   lines.segment30_high)';
25 
26   CP_FLEXDATA_LOW VARCHAR2(1000) := '(lines.segment1_low || ''\n'' || lines.segment2_low || ''\n'' ||
27 lines.segment3_low || ''\n'' || lines.segment4_low || ''\n'' || lines.segment5_low || ''\n'' ||
28 lines.segment6_low || ''\n'' || lines.segment7_low || ''\n'' || lines.segment8_low || ''\n'' ||
29 lines.segment9_low || ''\n'' || lines.segment10_low || ''\n'' || lines.segment11_low || ''\n'' ||
30 lines.segment12_low || ''\n'' || lines.segment13_low || ''\n'' || lines.segment14_low || ''\n'' ||
31 lines.segment15_low || ''\n'' || lines.segment16_low || ''\n'' || lines.segment17_low || ''\n'' ||
32 lines.segment18_low || ''\n'' || lines.segment19_low || ''\n'' || lines.segment20_low || ''\n'' ||
33 lines.segment21_low || ''\n'' || lines.segment22_low || ''\n'' || lines.segment23_low || ''\n'' ||
34 lines.segment24_low || ''\n'' || lines.segment25_low || ''\n'' || lines.segment26_low || ''\n'' ||
35 lines.segment27_low || ''\n'' || lines.segment28_low || ''\n'' || lines.segment29_low || ''\n'' ||
36 lines.segment30_low)';
37 
38   P_STRUCT_NUM NUMBER := 101;
39 
40   CP_SET_OF_BOOKS_NAME VARCHAR2(30);
41 
42   CP_BUDGET_GROUP_NAME VARCHAR2(80);
43 
44   CP_PRINT_SUBGROUPS VARCHAR2(80);
45 
46   CP_NO_DATA_FOUND VARCHAR2(50);
47 
48   CP_END_OF_REPORT VARCHAR2(50);
49 
50   FUNCTION BEFOREREPORT RETURN BOOLEAN;
51 
52   FUNCTION CF_FLEXFIELD_HIGHFORMULA(COA_ID IN NUMBER
53                                    ,FLEXDATA_HIGH IN VARCHAR2
54                                    ,CF_FLEXFIELD_HIGH IN VARCHAR2) RETURN VARCHAR2;
55 
56   FUNCTION CF_FLEXFIELD_LOWFORMULA(COA_ID IN NUMBER
57                                   ,FLEXDATA_LOW IN VARCHAR2
58                                   ,CF_FLEXFIELD_LOW IN VARCHAR2) RETURN VARCHAR2;
59 
60   FUNCTION AFTERREPORT RETURN BOOLEAN;
61 
62   FUNCTION CF_USER_EXIT_DUMMYFORMULA(COA_ID IN NUMBER) RETURN NUMBER;
63 
64   FUNCTION BETWEENPAGE RETURN BOOLEAN;
65 
66   FUNCTION CP_FLEXDATA_HIGH_P RETURN VARCHAR2;
67 
68   FUNCTION CP_FLEXDATA_LOW_P RETURN VARCHAR2;
69 
70   FUNCTION P_STRUCT_NUM_P RETURN NUMBER;
71 
72   FUNCTION CP_SET_OF_BOOKS_NAME_P RETURN VARCHAR2;
73 
74   FUNCTION CP_BUDGET_GROUP_NAME_P RETURN VARCHAR2;
75 
76   FUNCTION CP_PRINT_SUBGROUPS_P RETURN VARCHAR2;
77 
78   FUNCTION CP_NO_DATA_FOUND_P RETURN VARCHAR2;
79 
80   FUNCTION CP_END_OF_REPORT_P RETURN VARCHAR2;
81 
82 END PSB_PSBBGASR_XMLP_PKG;
83 
84 
85 
86 
87 
88