[Home] [Help]
PACKAGE: APPS.GHR_BREAKDOWN_RPT
Source
1 PACKAGE ghr_breakdown_rpt AUTHID CURRENT_USER 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;