[Home] [Help]
PACKAGE: APPS.HR_BIS_ORG_PERF
Source
1 PACKAGE HR_BIS_ORG_PERF AUTHID CURRENT_USER AS
2 /* $Header: hrbisorg.pkh 115.5 2002/04/17 03:43:55 pkm ship $ */
3
4 TYPE OrgPerfTableType is record
5 (start_val NUMBER
6 ,end_val NUMBER
7 ,gains NUMBER
8 ,ended NUMBER
9 ,transfered_out NUMBER
10 ,suspended NUMBER
11 ,sep_reason NUMBER
12 ,others NUMBER
13 ,name VARCHAR2(200));
14 --
15 TYPE OrgPerfTable is TABLE of OrgPerfTableType
16 Index by binary_integer;
17 --
18 OrgPerfData OrgPerfTable;
19 --
20 function get_start(p_organization_id NUMBER) return NUMBER;
21 PRAGMA RESTRICT_REFERENCES(get_start,WNDS,WNPS);
22 --
23 function get_end(p_organization_id NUMBER) return NUMBER;
24 PRAGMA RESTRICT_REFERENCES(get_end,WNDS,WNPS);
25 --
26 function get_increase(p_organization_id NUMBER) return NUMBER;
27 PRAGMA RESTRICT_REFERENCES(get_increase,WNDS,WNPS);
28 --
29 function get_pct_increase(p_organization_id NUMBER) return NUMBER;
30 PRAGMA RESTRICT_REFERENCES(get_pct_increase,WNDS,WNPS);
31 --
32 function get_gains(p_organization_id NUMBER) return NUMBER;
33 PRAGMA RESTRICT_REFERENCES(get_gains,WNDS,WNPS);
34 --
35 function get_ended(p_organization_id NUMBER) return NUMBER;
36 PRAGMA RESTRICT_REFERENCES(get_ended,WNDS,WNPS);
37 --
38 function get_transfered_out(p_organization_id NUMBER) return NUMBER;
39 PRAGMA RESTRICT_REFERENCES(get_transfered_out,WNDS,WNPS);
40 --
41 function get_suspended(p_organization_id NUMBER) return NUMBER;
42 PRAGMA RESTRICT_REFERENCES(get_suspended,WNDS,WNPS);
43 --
44 function get_sep_reason(p_organization_id NUMBER) return NUMBER;
45 PRAGMA RESTRICT_REFERENCES(get_sep_reason,WNDS,WNPS);
46 --
47 function get_others(p_organization_id NUMBER) return NUMBER;
48 PRAGMA RESTRICT_REFERENCES(get_others,WNDS,WNPS);
49 --
50 function get_sep_pct_increase(p_organization_id NUMBER) return NUMBER;
51 PRAGMA RESTRICT_REFERENCES(get_sep_pct_increase,WNDS,WNPS);
52 --
53 procedure populate_manpower_table
54 ( p_org_param_id IN NUMBER
55 , p_budget_metric IN VARCHAR2
56 , p_business_group_id IN NUMBER
57 , p_top_org IN NUMBER
58 , p_start_date IN DATE
59 , p_end_date IN DATE);
60 --
61 procedure populate_separations_table
62 ( p_org_param_id IN NUMBER
63 , p_budget_metric IN VARCHAR2
64 , p_business_group_id IN NUMBER
65 , p_top_org IN NUMBER
66 , p_start_date IN DATE
67 , p_end_date IN DATE
68 , p_leaving_reason IN VARCHAR2);
69 --
70 procedure populate_budget_table
71 ( p_budget_id IN NUMBER
72 , p_business_group_id IN NUMBER
73 , p_report_date IN DATE);
74 --
75
76 -- cbridge, 28/06/2001 added for pqh budget reports
77 procedure populate_pqh_budget_table
78 ( p_budget_id IN NUMBER
79 , p_business_group_id IN NUMBER
80 , p_budget_metric IN VARCHAR2
81 , p_budget_unit IN NUMBER
82 , p_report_date IN DATE);
83 --
84
85
86
87
88 END HR_BIS_ORG_PERF;