PACKAGE: APPS.HR_HEAD_COUNT_SUMMARY

Source

1 PACKAGE HR_HEAD_COUNT_SUMMARY AUTHID CURRENT_USER AS
2 /* $Header: perhdsum.pkh 115.6 2003/04/27 23:23:27 asahay noship $ */
3 
4 TYPE HQOrgTableType is record
5   (rev_start_val 		NUMBER
6   ,nonrev_start_val 		NUMBER
7   ,rev_end_val 			NUMBER
8   ,nonrev_end_val 		NUMBER
9   ,rev_nh 			NUMBER
10   ,nonrev_nh 			NUMBER
11   ,rev_term 			NUMBER
12   ,nonrev_term 			NUMBER);
13 --
14 TYPE HQOrgTable is TABLE of HQOrgTableType
15 Index by binary_integer;
16 --
17 HQOrgData HQOrgTable;
18 --
19 function get_rev_start_val(p_organization_id NUMBER) return NUMBER;
20 PRAGMA RESTRICT_REFERENCES(get_rev_start_val,WNDS,WNPS);
21 --
22 function get_nonrev_start_val(p_organization_id NUMBER) return NUMBER;
23 PRAGMA RESTRICT_REFERENCES(get_nonrev_start_val,WNDS,WNPS);
24 --
25 function get_rev_end_val(p_organization_id NUMBER) return NUMBER;
26 PRAGMA RESTRICT_REFERENCES(get_rev_end_val,WNDS,WNPS);
27 --
28 function get_nonrev_end_val(p_organization_id NUMBER) return NUMBER;
29 PRAGMA RESTRICT_REFERENCES(get_nonrev_end_val,WNDS,WNPS);
30 --
31 function get_rev_nh(p_organization_id NUMBER) return NUMBER;
32 PRAGMA RESTRICT_REFERENCES(get_rev_nh,WNDS,WNPS);
33 --
34 function get_nonrev_nh(p_organization_id NUMBER) return NUMBER;
35 PRAGMA RESTRICT_REFERENCES(get_nonrev_nh,WNDS,WNPS);
36 --
37 function get_rev_term(p_organization_id NUMBER) return NUMBER;
38 PRAGMA RESTRICT_REFERENCES(get_rev_term,WNDS,WNPS);
39 --
40 function get_nonrev_term(p_organization_id NUMBER) return NUMBER;
41 PRAGMA RESTRICT_REFERENCES(get_nonrev_term,WNDS,WNPS);
42 --
43 function get_rev_net_change(p_organization_id NUMBER) return NUMBER;
44 PRAGMA RESTRICT_REFERENCES(get_rev_net_change,WNDS,WNPS);
45 --
46 function get_nonrev_net_change(p_organization_id NUMBER) return NUMBER;
47 PRAGMA RESTRICT_REFERENCES(get_nonrev_net_change,WNDS,WNPS);
48 --
49 function get_rev_other_net(p_organization_id NUMBER) return NUMBER;
50 PRAGMA RESTRICT_REFERENCES(get_rev_other_net,WNDS,WNPS);
51 --
52 function get_nonrev_other_net(p_organization_id NUMBER) return NUMBER;
53 PRAGMA RESTRICT_REFERENCES(get_nonrev_other_net,WNDS,WNPS);
54 --
55 --
56 procedure populate_summary_table
57 ( P_BUSINESS_GROUP_ID         IN NUMBER
58 , P_TOP_ORGANIZATION_ID       IN NUMBER
59 , P_ORGANIZATION_STRUCTURE_ID IN NUMBER
60 , P_BUDGET                    IN VARCHAR2
61 , P_ROLL_UP                   IN VARCHAR2
62 , P_INCLUDE_TOP_ORG           IN VARCHAR2
63 , P_REPORT_DATE_FROM          IN DATE
64 , P_REPORT_DATE_TO            IN DATE
65 , P_REPORT_DATE               IN DATE
66 , P_INCLUDE_ASG_TYPE	      IN VARCHAR2
67 , P_JOB_CATEGORY              IN VARCHAR2 default 'RG');
68 
69 END HR_HEAD_COUNT_SUMMARY;