1 PACKAGE PER_POS_BGT_PKG AUTHID CURRENT_USER AS
2 /* $Header: pebgt03t.pkh 115.0 99/07/17 18:47:22 porting ship $ */
3 --
4 /* PROCEDURE GET_HOLDERS: Calculates the number of people holding
5 a position and returns the holders name and emp no if only one
6 else returns an appropriate message if number of holders is zero
7 or greater than one to X_HOLDER_NAME.
8 */
9 procedure get_holders(X_POSITION_ID NUMBER,
10 X_ORGANIZATION_ID NUMBER,
11 X_BUSINESS_GROUP_ID NUMBER,
12 X_NO_OF_HOLDERS IN OUT VARCHAR2,
13 X_HOLDER_NAME IN OUT VARCHAR2,
14 X_HOLDER_EMP_NO IN OUT VARCHAR2) ;
15 /* PROCEDURE GET_BUDGET_VALUE: Returns the budgeted value for the position.
16 */
17 PROCEDURE GET_BUDGET_VALUE(X_BUDGET_VALUE IN OUT NUMBER,
18 X_BUDGET_VALUE_ID IN OUT NUMBER,
19 X_POSITION_ID NUMBER,
20 X_BUDGET_VERSION_ID NUMBER,
21 X_TIME_PERIOD_ID NUMBER) ;
22 /* PROCEDURE GET_PERIOD_START: Returns the count as of the start date for the
23 selected period.
24 */
25 --
26 --
27 -- Changed datatype from VARCHAR2 to DATE for X_START_DATE. PASHUN. 31-10-1997.
28 -- BUG : 572545.
29 --
30 --
31 PROCEDURE GET_PERIOD_START(X_PERIOD_START IN OUT NUMBER,
32 X_POSITION_ID NUMBER,
33 X_BUSINESS_GROUP_ID NUMBER,
34 X_START_DATE DATE,
35 X_UNIT VARCHAR2) ;
36 /* PROCEDURE GET_PERIOD_END: Returns the count as of the end date for the
37 selected period
38 */
39 --
40 --
41 -- Changed datatype from VARCHAR2 to DATE for X_END_DATE. PASHUN. 31-10-1997.
42 -- BUG : 572545.
43 --
44 --
45 PROCEDURE GET_PERIOD_END(X_PERIOD_END IN OUT NUMBER,
46 X_POSITION_ID NUMBER,
47 X_BUSINESS_GROUP_ID NUMBER,
48 X_END_DATE DATE,
49 X_UNIT VARCHAR2) ;
50 /* PROCEDURE GET_STARTERS: Calculates the number of persons attaining
51 a position within a period.
52 */
53 --
54 --
55 -- Changed datatype from VARCHAR2 to DATE for X_END_DATE and X_START_DATE.
56 -- PASHUN. 31-10-1997. BUG : 572545.
57 --
58 --
59 PROCEDURE GET_STARTERS(X_STARTERS IN OUT NUMBER,
60 X_POSITION_ID NUMBER,
61 X_BUSINESS_GROUP_ID NUMBER,
62 X_START_DATE DATE,
63 X_END_DATE DATE,
64 X_UNIT VARCHAR2) ;
65 /* PROCEDURE GET_LEAVERS: Calculates the number of persons leaving
66 a position within a period.
67 */
68 --
69 --
70 -- Changed datatype from VARCHAR2 to DATE for X_START_DATE and X_END_DATE.
71 -- PASHUN. 31-10-1997. BUG : 572545.
72 --
73 --
74 PROCEDURE GET_LEAVERS(X_LEAVERS IN OUT NUMBER,
75 X_POSITION_ID NUMBER,
76 X_BUSINESS_GROUP_ID NUMBER,
77 X_START_DATE DATE,
78 X_END_DATE DATE,
79 X_UNIT VARCHAR2) ;
80 /* PROCEDURE POPULATE_FIELDS: Calls all the other procedures within
81 the package allowing for only one
82 server side trip.
83 */
84 --
85 --
86 -- Changed datatype from VARCHAR2 to DATE for X_START_DATE and X_END_DATE.
87 -- PASHUN. 31-10-1997. BUG : 572545.
88 --
89 --
90 PROCEDURE POPULATE_FIELDS(X_VARIANCE IN OUT NUMBER,
91 X_LEAVERS IN OUT NUMBER,
92 X_STARTERS IN OUT NUMBER,
93 X_PERIOD_END IN OUT NUMBER,
94 X_PERIOD_START IN OUT NUMBER,
95 X_BUDGET_VALUE IN OUT NUMBER,
96 X_BUDGET_VALUE_ID IN OUT NUMBER,
97 X_POSITION_ID NUMBER,
98 X_BUSINESS_GROUP_ID NUMBER,
99 X_START_DATE DATE,
100 X_END_DATE DATE,
101 X_UNIT VARCHAR2,
102 X_BUDGET_VERSION_ID NUMBER,
103 X_TIME_PERIOD_ID NUMBER) ;
104 END PER_POS_BGT_PKG;