PACKAGE: APPS.GHR_BREAKDOWN_RPT

Source

1 PACKAGE ghr_breakdown_rpt AS
2 /* $Header: ghbrkdwn.pkh 120.1 2005/07/01 02:12:40 asubrahm noship $ */
3 --
4   PROCEDURE Set_Effective_Date(p_date IN DATE);
5 
6   FUNCTION Effective_Date RETURN DATE;
7 
8   PROCEDURE Set_Agency(p_agency IN VARCHAR2,
9                        p_subelm IN VARCHAR2);
10 
11   FUNCTION Agency_Subelement RETURN VARCHAR2;
12 
13   PROCEDURE Set_By_Clause(p_name     IN VARCHAR2);
14 
15   PROCEDURE Set_within_clause(p_name IN VARCHAR2);
16 
17   PROCEDURE set_for_clause(p_value IN NUMBER);
18 
19   FUNCTION get_for_clause RETURN NUMBER;
20 
21   PROCEDURE set_extra_clause(p_name IN VARCHAR2);
22 
23   PROCEDURE set_hierarchy(p_org_strver_id IN NUMBER);
24 
25   FUNCTION get_hierarchy_level(p_position_id IN NUMBER, p_effective_date IN DATE)
26   RETURN NUMBER;
27 
28   FUNCTION get_hierarchy_codes (p_ASG_rowid IN ROWID, p_effective_date IN DATE,
29                                 p_mode IN VARCHAR2 := 'PARENTS')
30   RETURN VARCHAR2;
31 
32   PROCEDURE process(p_breakdown_criteria_id IN NUMBER := NULL);
33 
34   PROCEDURE Delete_Temp_Data;
35 
36   FUNCTION decode_lookup(p_lookup_type  IN VARCHAR2,
37                          p_lookup_code  IN VARCHAR2)
38   RETURN VARCHAR2;
39 
40   Procedure return_special_information
41   (p_person_id       in  number
42   ,p_structure_name  in  varchar2
43   ,p_effective_date  in  date
44   ,p_special_info    OUT NOCOPY ghr_api.special_information_type
45   );
46 
47   l_effective_date      DATE   NOT NULL     := SYSDATE;
48 
49   PRAGMA RESTRICT_REFERENCES(Effective_Date,             WNDS, WNPS);
50   PRAGMA RESTRICT_REFERENCES(Agency_Subelement,          WNDS, WNPS);
51   PRAGMA RESTRICT_REFERENCES(ghr_breakdown_rpt,          WNDS, WNPS);
52   -- Removed pragma (it's not needed in 8.1 according to bug# 1014743)
53   -- PRAGMA RESTRICT_REFERENCES(decode_lookup,              WNDS, WNPS);
54   PRAGMA RESTRICT_REFERENCES(get_hierarchy_level,        WNDS, WNPS);
55   PRAGMA RESTRICT_REFERENCES(get_hierarchy_codes,        WNDS, WNPS);
56   PRAGMA RESTRICT_REFERENCES(get_for_clause,             WNDS, WNPS);
57   PRAGMA RESTRICT_REFERENCES(get_hierarchy_codes,        WNDS, WNPS);
58   PRAGMA RESTRICT_REFERENCES(return_special_information, WNDS, WNPS);
59 
60   -- bug 657712
61   FUNCTION get_org_struct_name(
62                    p_org_structure_version_id      per_org_structure_versions.org_structure_version_id%TYPE)
63     RETURN VARCHAR2;
64 
65 END ghr_breakdown_rpt;