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;