[Home] [Help]
PACKAGE: APPS.HR_NL_LAW_SAMEN_REPORT
Source
1 PACKAGE HR_NL_LAW_SAMEN_REPORT AUTHID CURRENT_USER AS
2 /* $Header: pernllsr.pkh 115.5 2002/08/24 14:17:48 gpadmasa noship $ */
3 --
4
5 TYPE HQOrgTableType is record
6 (
7 total NUMBER
8 ,ls_total NUMBER
9 ,acht_total NUMBER
10 ,full_time NUMBER
11 ,acht_full_time NUMBER
12 ,part_time NUMBER
13 ,acht_part_time NUMBER
14 ,total_hired NUMBER
15 ,acht_hired NUMBER
16 ,terminated NUMBER
17 ,acht_terminated NUMBER
18 ,current_total NUMBER
19 ,last_acht_total NUMBER
20 ,last_perc_acht NUMBER
21 ,perc_acht NUMBER
22 ,perc_full_time NUMBER
23 ,perc_acht_ftime NUMBER
24 ,perc_part_time NUMBER
25 ,perc_acht_ptime NUMBER
26 ,perc_acht_hired NUMBER
27 ,perc_acht_term NUMBER
28 );
29
30 TYPE HQOrgTable is TABLE of HQOrgTableType
31 Index by binary_integer;
32 --
33 HQOrgData HQOrgTable;
34 --
35 function get_total(p_organization_id NUMBER) return NUMBER;
36 PRAGMA RESTRICT_REFERENCES(get_total,WNDS,WNPS);
37 --
38 function get_ls_total(p_organization_id NUMBER) return NUMBER;
39 PRAGMA RESTRICT_REFERENCES(get_ls_total,WNDS,WNPS);
40 --
41 function get_acht_total(p_organization_id NUMBER) return NUMBER;
42 PRAGMA RESTRICT_REFERENCES(get_acht_total,WNDS,WNPS);
43 --
44 function get_full_time(p_organization_id NUMBER) return NUMBER;
45 PRAGMA RESTRICT_REFERENCES(get_full_time,WNDS,WNPS);
46 --
47 function get_acht_full_time(p_organization_id NUMBER) return NUMBER;
48 PRAGMA RESTRICT_REFERENCES(get_acht_full_time,WNDS,WNPS);
49 --
50 function get_part_time(p_organization_id NUMBER) return NUMBER;
51 PRAGMA RESTRICT_REFERENCES(get_part_time,WNDS,WNPS);
52 --
53 function get_acht_part_time(p_organization_id NUMBER) return NUMBER;
54 PRAGMA RESTRICT_REFERENCES(get_acht_part_time,WNDS,WNPS);
55
56 function get_total_hired(p_organization_id NUMBER) return NUMBER;
57 PRAGMA RESTRICT_REFERENCES(get_total_hired,WNDS,WNPS);
58 --
59 function get_acht_hired(p_organization_id NUMBER) return NUMBER;
60 PRAGMA RESTRICT_REFERENCES(get_acht_hired,WNDS,WNPS);
61 --
62 function get_terminated(p_organization_id NUMBER) return NUMBER;
63 PRAGMA RESTRICT_REFERENCES(get_terminated,WNDS,WNPS);
64 --
65 function get_acht_terminated(p_organization_id NUMBER) return NUMBER;
66 PRAGMA RESTRICT_REFERENCES(get_acht_terminated,WNDS,WNPS);
67 --
68 function get_current_total(p_organization_id NUMBER) return NUMBER;
69 PRAGMA RESTRICT_REFERENCES(get_current_total,WNDS,WNPS);
70 --
71 function get_last_acht_total(p_organization_id NUMBER) return NUMBER;
72 PRAGMA RESTRICT_REFERENCES(get_last_acht_total,WNDS,WNPS);
73 --
74 function get_last_perc_acht(p_organization_id NUMBER) return NUMBER;
75 PRAGMA RESTRICT_REFERENCES(get_last_perc_acht,WNDS,WNPS);
76 --
77 function get_perc_acht(p_organization_id NUMBER) return NUMBER;
78 PRAGMA RESTRICT_REFERENCES(get_perc_acht,WNDS,WNPS);
79
80 function get_perc_full_time(p_organization_id NUMBER) return NUMBER;
81 PRAGMA RESTRICT_REFERENCES(get_perc_full_time,WNDS,WNPS);
82 --
83 function get_perc_acht_ftime(p_organization_id NUMBER) return NUMBER;
84 PRAGMA RESTRICT_REFERENCES(get_perc_acht_ftime,WNDS,WNPS);
85 --
86 function get_perc_part_time(p_organization_id NUMBER) return NUMBER;
87 PRAGMA RESTRICT_REFERENCES(get_perc_part_time,WNDS,WNPS);
88 --
89 function get_perc_acht_ptime(p_organization_id NUMBER) return NUMBER;
90 PRAGMA RESTRICT_REFERENCES(get_perc_acht_ptime,WNDS,WNPS);
91 --
92 function get_perc_acht_hired(p_organization_id NUMBER) return NUMBER;
93 PRAGMA RESTRICT_REFERENCES(get_perc_acht_hired,WNDS,WNPS);
94 --
95 function get_perc_acht_term(p_organization_id NUMBER) return NUMBER;
96 PRAGMA RESTRICT_REFERENCES(get_perc_acht_term,WNDS,WNPS);
97 --
98 procedure populate_lawsamen_table
99 ( P_BUSINESS_GROUP_ID IN NUMBER
100 , P_TOP_ORGANIZATION_ID IN NUMBER
101 , P_ORGANIZATION_STRUCTURE_ID IN NUMBER
102 , P_ROLL_UP IN VARCHAR2
103 , P_REPORT_YEAR IN NUMBER
104 , P_REGION IN VARCHAR2);
105
106 procedure calculate_values
107 ( P_REPORT_YEAR IN NUMBER
108 , P_ORGANIZATION_ID IN NUMBER
109 , P_BUSINESS_GROUP_ID IN NUMBER
110 , P_TOPORG_ID IN NUMBER);
111
112 END HR_NL_LAW_SAMEN_REPORT;
113