eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.HR_HEAD_COUNT

Source


1 PACKAGE HR_HEAD_COUNT AUTHID CURRENT_USER AS
2 /* $Header: perhdcnt.pkh 120.0.12010000.1 2008/07/28 05:42:31 appldev ship $ */
3 
4 TYPE HQOrgTableType is record
5   (rev_start_val 			NUMBER
6   ,nonrev_start_val 		NUMBER
7   ,rev_perm 				NUMBER
8   ,nonrev_perm 			NUMBER
9   ,rev_cont 				NUMBER
10   ,nonrev_cont 			NUMBER
11   ,rev_temp 				NUMBER
12   ,nonrev_temp 			NUMBER
13   ,rev_nh 				NUMBER
14   ,nonrev_nh 				NUMBER
15   ,rev_cur_nh 				NUMBER
16   ,nonrev_cur_nh 			NUMBER
17   ,rev_transfer_in 			NUMBER
18   ,nonrev_transfer_in 		NUMBER
19   ,rev_transfer_out 		NUMBER
20   ,nonrev_transfer_out 		NUMBER
21   ,rev_open_offers 			NUMBER
22   ,nonrev_open_offers 		NUMBER
23   ,rev_accepted_offers 		NUMBER
24   ,nonrev_accepted_offers 	NUMBER
25   ,rev_vacant_FTE 			NUMBER
26   ,nonrev_vacant_FTE 		NUMBER
27   ,rev_vol_term 			NUMBER
28   ,nonrev_vol_term 			NUMBER
29   ,rev_invol_term 			NUMBER
30   ,nonrev_invol_term 		NUMBER
31   ,rev_cur_term 			NUMBER
32   ,nonrev_cur_term 			NUMBER
33   ,rev_end_val 			NUMBER
34   ,nonrev_end_val 			NUMBER);
35 --
36 TYPE HQOrgTable is TABLE of HQOrgTableType
37 Index by binary_integer;
38 --
39 HQOrgData HQOrgTable;
40 --
41 function get_rev_start_val(p_org_structure_element_id NUMBER) return NUMBER;
42 PRAGMA RESTRICT_REFERENCES(get_rev_start_val,WNDS,WNPS);
43 --
44 function get_nonrev_start_val(p_org_structure_element_id NUMBER) return NUMBER;
45 PRAGMA RESTRICT_REFERENCES(get_nonrev_start_val,WNDS,WNPS);
46 --
47 function get_rev_perm(p_org_structure_element_id NUMBER) return NUMBER;
48 PRAGMA RESTRICT_REFERENCES(get_rev_perm,WNDS,WNPS);
49 --
50 function get_nonrev_perm(p_org_structure_element_id NUMBER) return NUMBER;
51 PRAGMA RESTRICT_REFERENCES(get_nonrev_perm,WNDS,WNPS);
52 --
53 function get_rev_cont(p_org_structure_element_id NUMBER) return NUMBER;
54 PRAGMA RESTRICT_REFERENCES(get_rev_cont,WNDS,WNPS);
55 --
56 function get_nonrev_cont(p_org_structure_element_id NUMBER) return NUMBER;
57 PRAGMA RESTRICT_REFERENCES(get_nonrev_cont,WNDS,WNPS);
58 --
59 function get_rev_temp(p_org_structure_element_id NUMBER) return NUMBER;
60 PRAGMA RESTRICT_REFERENCES(get_rev_temp,WNDS,WNPS);
61 --
62 function get_nonrev_temp(p_org_structure_element_id NUMBER) return NUMBER;
63 PRAGMA RESTRICT_REFERENCES(get_nonrev_temp,WNDS,WNPS);
64 --
65 function get_rev_cur_nh(p_org_structure_element_id NUMBER) return NUMBER;
66 PRAGMA RESTRICT_REFERENCES(get_rev_cur_nh,WNDS,WNPS);
67 --
68 function get_nonrev_cur_nh(p_org_structure_element_id NUMBER) return NUMBER;
69 PRAGMA RESTRICT_REFERENCES(get_nonrev_cur_nh,WNDS,WNPS);
70 --
71 function get_rev_nh(p_org_structure_element_id NUMBER) return NUMBER;
72 PRAGMA RESTRICT_REFERENCES(get_rev_nh,WNDS,WNPS);
73 --
74 function get_nonrev_nh(p_org_structure_element_id NUMBER) return NUMBER;
75 PRAGMA RESTRICT_REFERENCES(get_nonrev_nh,WNDS,WNPS);
76 --
77 function get_rev_transfer_in(p_org_structure_element_id NUMBER) return NUMBER;
78 PRAGMA RESTRICT_REFERENCES(get_rev_transfer_in,WNDS,WNPS);
79 --
80 function get_nonrev_transfer_in(p_org_structure_element_id NUMBER) return NUMBER;
81 PRAGMA RESTRICT_REFERENCES(get_nonrev_transfer_in,WNDS,WNPS);
82 --
83 function get_rev_transfer_out(p_org_structure_element_id NUMBER) return NUMBER;
84 PRAGMA RESTRICT_REFERENCES(get_rev_transfer_out,WNDS,WNPS);
85 --
86 function get_nonrev_transfer_out(p_org_structure_element_id NUMBER) return NUMBER;
87 PRAGMA RESTRICT_REFERENCES(get_nonrev_transfer_out,WNDS,WNPS);
88 --
89 function get_rev_open_offers(p_org_structure_element_id NUMBER) return NUMBER;
90 PRAGMA RESTRICT_REFERENCES(get_rev_open_offers,WNDS,WNPS);
91 --
92 function get_nonrev_open_offers(p_org_structure_element_id NUMBER) return NUMBER;
93 PRAGMA RESTRICT_REFERENCES(get_nonrev_open_offers,WNDS,WNPS);
94 --
95 function get_rev_accepted_offers(p_org_structure_element_id NUMBER) return NUMBER;
96 PRAGMA RESTRICT_REFERENCES(get_rev_accepted_offers,WNDS,WNPS);
97 --
98 function get_nonrev_accepted_offers(p_org_structure_element_id NUMBER) return NUMBER;
99 PRAGMA RESTRICT_REFERENCES(get_nonrev_accepted_offers,WNDS,WNPS);
100 --
101 function get_rev_vacant_FTE(p_org_structure_element_id NUMBER) return NUMBER;
102 PRAGMA RESTRICT_REFERENCES(get_rev_vacant_FTE,WNDS,WNPS);
103 --
104 function get_nonrev_vacant_FTE(p_org_structure_element_id NUMBER) return NUMBER;
105 PRAGMA RESTRICT_REFERENCES(get_nonrev_vacant_FTE,WNDS,WNPS);
106 --
107 function get_rev_vol_term(p_org_structure_element_id NUMBER) return NUMBER;
108 PRAGMA RESTRICT_REFERENCES(get_rev_vol_term,WNDS,WNPS);
109 --
110 function get_nonrev_vol_term(p_org_structure_element_id NUMBER) return NUMBER;
111 PRAGMA RESTRICT_REFERENCES(get_nonrev_vol_term,WNDS,WNPS);
112 --
113 function get_rev_invol_term(p_org_structure_element_id NUMBER) return NUMBER;
114 PRAGMA RESTRICT_REFERENCES(get_rev_invol_term,WNDS,WNPS);
115 --
116 function get_nonrev_invol_term(p_org_structure_element_id NUMBER) return NUMBER;
117 PRAGMA RESTRICT_REFERENCES(get_nonrev_invol_term,WNDS,WNPS);
118 --
119 function get_rev_cur_term(p_org_structure_element_id NUMBER) return NUMBER;
120 PRAGMA RESTRICT_REFERENCES(get_rev_invol_term,WNDS,WNPS);
121 --
122 function get_nonrev_cur_term(p_org_structure_element_id NUMBER) return NUMBER;
123 PRAGMA RESTRICT_REFERENCES(get_nonrev_invol_term,WNDS,WNPS);
124 --
125 function get_rev_end_val(p_org_structure_element_id NUMBER) return NUMBER;
126 PRAGMA RESTRICT_REFERENCES(get_rev_end_val,WNDS,WNPS);
127 --
128 function get_nonrev_end_val(p_org_structure_element_id NUMBER) return NUMBER;
129 PRAGMA RESTRICT_REFERENCES(get_nonrev_end_val,WNDS,WNPS);
130 --
131 function get_rev_change(p_org_structure_element_id NUMBER) return NUMBER;
132 PRAGMA RESTRICT_REFERENCES(get_rev_change,WNDS,WNPS);
133 --
134 function get_nonrev_change(p_org_structure_element_id NUMBER) return NUMBER;
135 PRAGMA RESTRICT_REFERENCES(get_nonrev_change,WNDS,WNPS);
136 --
137 function get_rev_pct_change(p_org_structure_element_id NUMBER) return NUMBER;
138 PRAGMA RESTRICT_REFERENCES(get_rev_pct_change,WNDS,WNPS);
139 --
140 function get_nonrev_pct_change(p_org_structure_element_id NUMBER) return NUMBER;
141 PRAGMA RESTRICT_REFERENCES(get_nonrev_pct_change,WNDS,WNPS);
142 --
143 --
144 procedure populate_headcount_table
145 ( P_BUSINESS_GROUP_ID         	IN NUMBER
146 , P_TOP_ORGANIZATION_ID       	IN NUMBER
147 , P_ORGANIZATION_STRUCTURE_ID 	IN NUMBER
148 , P_BUDGET              	IN VARCHAR2
149 , P_ROLL_UP              	IN VARCHAR2
150 , P_REPORT_DATE_FROM           	IN DATE
151 , P_REPORT_DATE_TO             	IN DATE
152 , P_REPORT_DATE              	IN DATE
153 , P_INCLUDE_ASG_TYPE         	IN VARCHAR2
154 , P_INCLUDE_TOP_ORG         	IN VARCHAR2
155 , P_WORKER_TYPE         	IN VARCHAR2
156 , P_DAYS_PRIOR_TO_END_DATE      IN NUMBER
157 , P_JOB_CATEGORY         	IN VARCHAR2 default 'RG');
158 
159 END HR_HEAD_COUNT;