1 PACKAGE BODY PSB_PSBRPWDS_XMLP_PKG AS
2 /* $Header: PSBRPWDSB.pls 120.0 2008/01/07 10:53:05 vijranga noship $ */
3 FUNCTION BEFOREREPORT RETURN BOOLEAN IS
4 BEGIN
5 P_CONC_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
6 /*SRW.USER_EXIT('FND SRWINIT')*/NULL;
7 IF P_SET_OF_BOOKS_ID IS NULL THEN
8 FND_MESSAGE.SET_NAME('PSB'
9 ,'PSB_ALL');
10 CP_SET_OF_BOOKS_NAME := FND_MESSAGE.GET;
11 FND_MESSAGE.SET_NAME('PSB'
12 ,'PSB_ALL');
13 CP_TOP_BUDGET_GROUP_NAME := FND_MESSAGE.GET;
14 ELSE
15 SELECT
16 NAME
17 INTO CP_SET_OF_BOOKS_NAME
18 FROM
19 GL_SETS_OF_BOOKS
20 WHERE SET_OF_BOOKS_ID = P_SET_OF_BOOKS_ID;
21 IF P_BUDGET_GROUP_ID IS NULL THEN
22 FND_MESSAGE.SET_NAME('PSB'
23 ,'PSB_ALL');
24 CP_TOP_BUDGET_GROUP_NAME := FND_MESSAGE.GET;
25 ELSE
26 SELECT
27 NAME
28 INTO CP_TOP_BUDGET_GROUP_NAME
29 FROM
30 PSB_BUDGET_GROUPS
31 WHERE BUDGET_GROUP_ID = P_BUDGET_GROUP_ID;
32 END IF;
33 END IF;
34 IF P_DISTRIBUTION_RULE_ID IS NULL THEN
35 FND_MESSAGE.SET_NAME('PSB'
36 ,'PSB_ALL');
37 CP_DISTRIBUTION_RULE_NAME := FND_MESSAGE.GET;
38 ELSE
39 SELECT
40 NAME
41 INTO CP_DISTRIBUTION_RULE_NAME
42 FROM
43 PSB_WS_DISTRIBUTION_RULES
44 WHERE DISTRIBUTION_RULE_ID = P_DISTRIBUTION_RULE_ID;
45 END IF;
46 FND_MESSAGE.SET_NAME('PSB'
47 ,'PSB_NO_DATA_FOUND');
48 CP_NO_DATA_FOUND := FND_MESSAGE.GET;
49 FND_MESSAGE.SET_NAME('PSB'
50 ,'PSB_END_OF_REPORT');
51 CP_END_OF_REPORT := FND_MESSAGE.GET;
52 RETURN (TRUE);
53 END BEFOREREPORT;
54
55 FUNCTION AFTERREPORT RETURN BOOLEAN IS
56 BEGIN
57 /*SRW.USER_EXIT('FND SRWEXIT')*/NULL;
58 RETURN (TRUE);
59 END AFTERREPORT;
60
61 FUNCTION BETWEENPAGE RETURN BOOLEAN IS
62 BEGIN
63 RETURN (TRUE);
64 END BETWEENPAGE;
65
66 FUNCTION BEFOREPFORM RETURN BOOLEAN IS
67 BEGIN
68 RETURN (TRUE);
69 END BEFOREPFORM;
70
71 FUNCTION CF_DISTRIBUTION_RULE_IDFORMULA(RULE_ID IN NUMBER) RETURN NUMBER IS
72 BEGIN
73 CP_DISTRIBUTION_RULE_ID := RULE_ID;
74 RETURN CP_DISTRIBUTION_RULE_ID;
75 END CF_DISTRIBUTION_RULE_IDFORMULA;
76
77 FUNCTION AFTERPFORM RETURN BOOLEAN IS
78 BEGIN
79 RETURN (TRUE);
80 END AFTERPFORM;
81
82 FUNCTION CP_DISTRIBUTION_RULE_ID_P RETURN NUMBER IS
83 BEGIN
84 RETURN CP_DISTRIBUTION_RULE_ID;
85 END CP_DISTRIBUTION_RULE_ID_P;
86
87 FUNCTION CP_SET_OF_BOOKS_NAME_P RETURN VARCHAR2 IS
88 BEGIN
89 RETURN CP_SET_OF_BOOKS_NAME;
90 END CP_SET_OF_BOOKS_NAME_P;
91
92 FUNCTION CP_TOP_BUDGET_GROUP_NAME_P RETURN VARCHAR2 IS
93 BEGIN
94 RETURN CP_TOP_BUDGET_GROUP_NAME;
95 END CP_TOP_BUDGET_GROUP_NAME_P;
96
97 FUNCTION CP_NO_DATA_FOUND_P RETURN VARCHAR2 IS
98 BEGIN
99 RETURN CP_NO_DATA_FOUND;
100 END CP_NO_DATA_FOUND_P;
101
102 FUNCTION CP_END_OF_REPORT_P RETURN VARCHAR2 IS
103 BEGIN
104 RETURN CP_END_OF_REPORT;
105 END CP_END_OF_REPORT_P;
106
107 FUNCTION CP_DISTRIBUTION_RULE_NAME_P RETURN VARCHAR2 IS
108 BEGIN
109 RETURN CP_DISTRIBUTION_RULE_NAME;
110 END CP_DISTRIBUTION_RULE_NAME_P;
111
112 END PSB_PSBRPWDS_XMLP_PKG;
113
114
115
116
117
[Home] [Help]