1 PACKAGE PER_PERRPRBD_XMLP_PKG AS
2 /* $Header: PERRPRBDS.pls 120.1 2007/12/06 11:32:13 amakrish noship $ */
3 P_BUSINESS_GROUP_ID VARCHAR2(40);
4
5 P_SESSION_DATE DATE;
6
7 P_CONC_REQUEST_ID NUMBER;
8
9 P_BUDGET_ID NUMBER;
10
11 P_BUDGET_VERSION_ID NUMBER;
12
13 P_START_TIME_PERIOD_ID NUMBER;
14
15 P_END_TIME_PERIOD_ID NUMBER;
16
17 C_END_VALUE NUMBER;
18
19 C_AMOUNT NUMBER;
20
21 C_PERCENTAGE VARCHAR2(32767);
22
23 C_BUSINESS_GROUP_NAME VARCHAR2(60);
24
25 C_REPORT_SUBTITLE VARCHAR2(60);
26
27 C_BUDGET_NAME VARCHAR2(30);
28
29 C_BUDGET_VERSION VARCHAR2(30);
30
31 C_START_PERIOD_NAME VARCHAR2(60);
32
33 C_END_PERIOD_NAME VARCHAR2(60);
34
35 C_UNIT VARCHAR2(30);
36
37 FUNCTION BEFOREREPORT RETURN BOOLEAN;
38
39 FUNCTION C_START_VALUEFORMULA(ORGANIZATION_ID IN NUMBER
40 ,JOB_ID IN NUMBER
41 ,POSITION_ID IN NUMBER
42 ,GRADE_ID IN NUMBER
43 ,START_DATE IN DATE
44 ,END_DATE IN DATE
45 ,BUDGET_VALUE IN NUMBER) RETURN NUMBER;
46
47 FUNCTION AFTERREPORT RETURN BOOLEAN;
48
49 FUNCTION C_END_VALUE_P RETURN NUMBER;
50
51 FUNCTION C_AMOUNT_P RETURN NUMBER;
52
53 FUNCTION C_PERCENTAGE_P RETURN VARCHAR2;
54
55 FUNCTION C_BUSINESS_GROUP_NAME_P RETURN VARCHAR2;
56
57 FUNCTION C_REPORT_SUBTITLE_P RETURN VARCHAR2;
58
59 FUNCTION C_BUDGET_NAME_P RETURN VARCHAR2;
60
61 FUNCTION C_BUDGET_VERSION_P RETURN VARCHAR2;
62
63 FUNCTION C_START_PERIOD_NAME_P RETURN VARCHAR2;
64
65 FUNCTION C_END_PERIOD_NAME_P RETURN VARCHAR2;
66
67 FUNCTION C_UNIT_P RETURN VARCHAR2;
68
69 FUNCTION GET_BUDGET(P_BUDGET_ID IN NUMBER) RETURN VARCHAR2;
70
71 FUNCTION GET_BUDGET_VERSION(P_BUDGET_ID IN NUMBER
72 ,P_BUDGET_VERSION_ID IN NUMBER) RETURN VARCHAR2;
73
74 PROCEDURE GET_TIME_PERIOD(P_TIME_PERIOD_ID IN NUMBER
75 ,P_PERIOD_NAME OUT NOCOPY VARCHAR2
76 ,P_START_DATE OUT NOCOPY DATE
77 ,P_END_DATE OUT NOCOPY DATE);
78
79 FUNCTION GET_BUSINESS_GROUP(P_BUSINESS_GROUP_ID IN NUMBER) RETURN VARCHAR2;
80
81 PROCEDURE GET_ACTUALS(P_UNIT IN VARCHAR2
82 ,P_BUS_GROUP_ID IN NUMBER
83 ,P_ORGANISATION_ID IN NUMBER
84 ,P_JOB_ID IN NUMBER
85 ,P_POSITION_ID IN NUMBER
86 ,P_GRADE_ID IN NUMBER
87 ,P_START_DATE IN DATE
88 ,P_END_DATE IN DATE
89 ,P_ACTUAL_VAL IN NUMBER
90 ,P_ACTUAL_START_VAL OUT NOCOPY NUMBER
91 ,P_ACTUAL_END_VAL OUT NOCOPY NUMBER
92 ,P_VARIANCE_AMOUNT OUT NOCOPY NUMBER
93 ,P_VARIANCE_PERCENT OUT NOCOPY VARCHAR2);
94
95 END PER_PERRPRBD_XMLP_PKG;