1 PACKAGE BODY PSB_PSBBGASR_XMLP_PKG AS
2 /* $Header: PSBBGASRB.pls 120.1 2008/02/22 07:58:25 vijranga noship $ */
3 FUNCTION BEFOREREPORT RETURN BOOLEAN IS
4 BEGIN
5 IF P_SET_OF_BOOKS_ID IS NULL THEN
6 FND_MESSAGE.SET_NAME('PSB'
7 ,'PSB_ALL');
8 CP_SET_OF_BOOKS_NAME := FND_MESSAGE.GET;
9 FND_MESSAGE.SET_NAME('PSB'
10 ,'PSB_ALL');
11 CP_BUDGET_GROUP_NAME := FND_MESSAGE.GET;
12 ELSE
13 SELECT
14 NAME
15 INTO CP_SET_OF_BOOKS_NAME
16 FROM
17 GL_SETS_OF_BOOKS
18 WHERE SET_OF_BOOKS_ID = P_SET_OF_BOOKS_ID;
19 IF P_BUDGET_GROUP_ID IS NULL THEN
20 FND_MESSAGE.SET_NAME('PSB'
21 ,'PSB_ALL');
22 CP_BUDGET_GROUP_NAME := FND_MESSAGE.GET;
23 ELSE
24 SELECT
25 NAME
26 INTO CP_BUDGET_GROUP_NAME
27 FROM
28 PSB_BUDGET_GROUPS
29 WHERE BUDGET_GROUP_ID = P_BUDGET_GROUP_ID;
30 END IF;
31 END IF;
32 SELECT
33 MEANING
34 INTO CP_PRINT_SUBGROUPS
35 FROM
36 FND_LOOKUPS
37 WHERE LOOKUP_TYPE = 'YES_NO'
38 AND LOOKUP_CODE = P_PRINT_SUBGROUPS_FLAG;
39 FND_MESSAGE.SET_NAME('PSB'
40 ,'PSB_NO_DATA_FOUND');
41 CP_NO_DATA_FOUND := FND_MESSAGE.GET;
42 FND_MESSAGE.SET_NAME('PSB'
43 ,'PSB_END_OF_REPORT');
44 CP_END_OF_REPORT := FND_MESSAGE.GET;
45 P_CONC_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
46 /*SRW.USER_EXIT('FND SRWINIT')*/NULL;
47 RETURN (TRUE);
48 END BEFOREREPORT;
49
50 FUNCTION CF_FLEXFIELD_HIGHFORMULA(COA_ID IN NUMBER
51 ,FLEXDATA_HIGH IN VARCHAR2
52 ,CF_FLEXFIELD_HIGH IN VARCHAR2) RETURN VARCHAR2 IS
53 BEGIN
54 /*SRW.REFERENCE(COA_ID)*/NULL;
55 /*SRW.REFERENCE(FLEXDATA_HIGH)*/NULL;
56 /*SRW.USER_EXIT('FND FLEXRIDVAL
57 CODE = "GL#"
58 NUM = ":coa_id"
59 APPL_SHORT_NAME = "SQLGL"
60 DATA = ":flexdata_high"
61 VALUE = ":cf_flexfield_high"
62 DISPLAY = "ALL"')*/NULL;
63 RETURN (CF_FLEXFIELD_HIGH);
64 END CF_FLEXFIELD_HIGHFORMULA;
65
66 FUNCTION CF_FLEXFIELD_LOWFORMULA(COA_ID IN NUMBER
67 ,FLEXDATA_LOW IN VARCHAR2
68 ,CF_FLEXFIELD_LOW IN VARCHAR2) RETURN VARCHAR2 IS
69 BEGIN
70 /*SRW.REFERENCE(COA_ID)*/NULL;
71 /*SRW.REFERENCE(FLEXDATA_LOW)*/NULL;
72 /*SRW.USER_EXIT('FND FLEXRIDVAL
73 CODE = "GL#"
74 NUM = ":coa_id"
75 APPL_SHORT_NAME = "SQLGL"
76 DATA = ":flexdata_low"
77 VALUE = ":cf_flexfield_low"
78 DISPLAY = "ALL"')*/NULL;
79 RETURN (CF_FLEXFIELD_LOW);
80 END CF_FLEXFIELD_LOWFORMULA;
81
82 FUNCTION AFTERREPORT RETURN BOOLEAN IS
83 BEGIN
84 /*SRW.USER_EXIT('FND SRWEXIT')*/NULL;
85 RETURN (TRUE);
86 END AFTERREPORT;
87
88 FUNCTION CF_USER_EXIT_DUMMYFORMULA(COA_ID IN NUMBER) RETURN NUMBER IS
89 BEGIN
90 /*SRW.REFERENCE(COA_ID)*/NULL;
91 /*SRW.USER_EXIT('FND FLEXRSQL
92 CODE = "GL#"
93 NUM = ":coa_id"
94 APPL_SHORT_NAME = "SQLGL"
95 OUTPUT = ":CP_FLEXDATA"
96 TABLEALIAS = "lines" ')*/NULL;
97 RETURN (COA_ID);
98 END CF_USER_EXIT_DUMMYFORMULA;
99
100 FUNCTION BETWEENPAGE RETURN BOOLEAN IS
101 BEGIN
102 RETURN (TRUE);
103 END BETWEENPAGE;
104
105 FUNCTION CP_FLEXDATA_HIGH_P RETURN VARCHAR2 IS
106 BEGIN
107 RETURN CP_FLEXDATA_HIGH;
108 END CP_FLEXDATA_HIGH_P;
109
110 FUNCTION CP_FLEXDATA_LOW_P RETURN VARCHAR2 IS
111 BEGIN
112 RETURN CP_FLEXDATA_LOW;
113 END CP_FLEXDATA_LOW_P;
114
115 FUNCTION P_STRUCT_NUM_P RETURN NUMBER IS
116 BEGIN
117 RETURN P_STRUCT_NUM;
118 END P_STRUCT_NUM_P;
119
120 FUNCTION CP_SET_OF_BOOKS_NAME_P RETURN VARCHAR2 IS
121 BEGIN
122 RETURN CP_SET_OF_BOOKS_NAME;
123 END CP_SET_OF_BOOKS_NAME_P;
124
125 FUNCTION CP_BUDGET_GROUP_NAME_P RETURN VARCHAR2 IS
126 BEGIN
127 RETURN CP_BUDGET_GROUP_NAME;
128 END CP_BUDGET_GROUP_NAME_P;
129
130 FUNCTION CP_PRINT_SUBGROUPS_P RETURN VARCHAR2 IS
131 BEGIN
132 RETURN CP_PRINT_SUBGROUPS;
133 END CP_PRINT_SUBGROUPS_P;
134
135 FUNCTION CP_NO_DATA_FOUND_P RETURN VARCHAR2 IS
136 BEGIN
137 RETURN CP_NO_DATA_FOUND;
138 END CP_NO_DATA_FOUND_P;
139
140 FUNCTION CP_END_OF_REPORT_P RETURN VARCHAR2 IS
141 BEGIN
142 RETURN CP_END_OF_REPORT;
143 END CP_END_OF_REPORT_P;
144
145 END PSB_PSBBGASR_XMLP_PKG;
146
147
148
149
150
151