1 PACKAGE ghr_complaints2_pkg AUTHID CURRENT_USER AS
2 /* $Header: ghrcomp2.pkh 115.4 2004/02/27 03:02:19 sumarimu noship $ */
3
4 PROCEDURE get_fullname_ssn (p_complainant_person_id IN NUMBER
5 ,p_effective_date IN DATE
6 ,p_full_name IN OUT NOCOPY VARCHAR2
7 ,p_ssn IN OUT NOCOPY VARCHAR2);
8
9 PROCEDURE get_asg_ids (p_complainant_person_id IN NUMBER
10 ,p_effective_date IN DATE
11 ,p_asg_id IN OUT NOCOPY NUMBER
12 ,p_posn_id IN OUT NOCOPY NUMBER
13 ,p_grade_id IN OUT NOCOPY NUMBER
14 ,p_job_id IN OUT NOCOPY NUMBER);
15
16 PROCEDURE fetch_peopleei(
17 p_person_id IN NUMBER
18 ,p_information_type IN VARCHAR2
19 ,p_date_effective IN DATE
20 ,p_information1 IN OUT NOCOPY VARCHAR2
21 ,p_information2 IN OUT NOCOPY VARCHAR2
22 ,p_information3 IN OUT NOCOPY VARCHAR2
23 ,p_information4 IN OUT NOCOPY VARCHAR2
24 ,p_information5 IN OUT NOCOPY VARCHAR2
25 ,p_information6 IN OUT NOCOPY VARCHAR2
26 ,p_information7 IN OUT NOCOPY VARCHAR2
27 ,p_information8 IN OUT NOCOPY VARCHAR2
28 ,p_information9 IN OUT NOCOPY VARCHAR2
29 ,p_information10 IN OUT NOCOPY VARCHAR2
30 ,p_information11 IN OUT NOCOPY VARCHAR2
31 ,p_information12 IN OUT NOCOPY VARCHAR2
32 ,p_information13 IN OUT NOCOPY VARCHAR2
33 ,p_information14 IN OUT NOCOPY VARCHAR2
34 ,p_information15 IN OUT NOCOPY VARCHAR2
35 ,p_information16 IN OUT NOCOPY VARCHAR2
36 ,p_information17 IN OUT NOCOPY VARCHAR2
37 ,p_information18 IN OUT NOCOPY VARCHAR2
38 ,p_information19 IN OUT NOCOPY VARCHAR2
39 ,p_information20 IN OUT NOCOPY VARCHAR2
40 ,p_information21 IN OUT NOCOPY VARCHAR2
41 ,p_information22 IN OUT NOCOPY VARCHAR2
42 ,p_information23 IN OUT NOCOPY VARCHAR2
43 ,p_information24 IN OUT NOCOPY VARCHAR2
44 ,p_information25 IN OUT NOCOPY VARCHAR2
45 ,p_information26 IN OUT NOCOPY VARCHAR2
46 ,p_information27 IN OUT NOCOPY VARCHAR2
47 ,p_information28 IN OUT NOCOPY VARCHAR2
48 ,p_information29 IN OUT NOCOPY VARCHAR2
49 ,p_information30 IN OUT NOCOPY VARCHAR2);
50
51 PROCEDURE fetch_asgei(
52 p_assignment_id IN NUMBER
53 ,p_information_type IN VARCHAR2
54 ,p_date_effective IN DATE
55 ,p_information1 IN OUT NOCOPY VARCHAR2
56 ,p_information2 IN OUT NOCOPY VARCHAR2
57 ,p_information3 IN OUT NOCOPY VARCHAR2
58 ,p_information4 IN OUT NOCOPY VARCHAR2
59 ,p_information5 IN OUT NOCOPY VARCHAR2
60 ,p_information6 IN OUT NOCOPY VARCHAR2
61 ,p_information7 IN OUT NOCOPY VARCHAR2
62 ,p_information8 IN OUT NOCOPY VARCHAR2
63 ,p_information9 IN OUT NOCOPY VARCHAR2
64 ,p_information10 IN OUT NOCOPY VARCHAR2
65 ,p_information11 IN OUT NOCOPY VARCHAR2
66 ,p_information12 IN OUT NOCOPY VARCHAR2
67 ,p_information13 IN OUT NOCOPY VARCHAR2
68 ,p_information14 IN OUT NOCOPY VARCHAR2
69 ,p_information15 IN OUT NOCOPY VARCHAR2
70 ,p_information16 IN OUT NOCOPY VARCHAR2
71 ,p_information17 IN OUT NOCOPY VARCHAR2
72 ,p_information18 IN OUT NOCOPY VARCHAR2
73 ,p_information19 IN OUT NOCOPY VARCHAR2
74 ,p_information20 IN OUT NOCOPY VARCHAR2
75 ,p_information21 IN OUT NOCOPY VARCHAR2
76 ,p_information22 IN OUT NOCOPY VARCHAR2
77 ,p_information23 IN OUT NOCOPY VARCHAR2
78 ,p_information24 IN OUT NOCOPY VARCHAR2
79 ,p_information25 IN OUT NOCOPY VARCHAR2
80 ,p_information26 IN OUT NOCOPY VARCHAR2
81 ,p_information27 IN OUT NOCOPY VARCHAR2
82 ,p_information28 IN OUT NOCOPY VARCHAR2
83 ,p_information29 IN OUT NOCOPY VARCHAR2
84 ,p_information30 IN OUT NOCOPY VARCHAR2);
85
86 PROCEDURE fetch_positionei(
87 p_position_id IN NUMBER
88 ,p_information_type IN VARCHAR2
89 ,p_date_effective IN DATE
90 ,p_information1 IN OUT NOCOPY VARCHAR2
91 ,p_information2 IN OUT NOCOPY VARCHAR2
92 ,p_information3 IN OUT NOCOPY VARCHAR2
93 ,p_information4 IN OUT NOCOPY VARCHAR2
94 ,p_information5 IN OUT NOCOPY VARCHAR2
95 ,p_information6 IN OUT NOCOPY VARCHAR2
96 ,p_information7 IN OUT NOCOPY VARCHAR2
97 ,p_information8 IN OUT NOCOPY VARCHAR2
98 ,p_information9 IN OUT NOCOPY VARCHAR2
99 ,p_information10 IN OUT NOCOPY VARCHAR2
100 ,p_information11 IN OUT NOCOPY VARCHAR2
101 ,p_information12 IN OUT NOCOPY VARCHAR2
102 ,p_information13 IN OUT NOCOPY VARCHAR2
103 ,p_information14 IN OUT NOCOPY VARCHAR2
104 ,p_information15 IN OUT NOCOPY VARCHAR2
105 ,p_information16 IN OUT NOCOPY VARCHAR2
106 ,p_information17 IN OUT NOCOPY VARCHAR2
107 ,p_information18 IN OUT NOCOPY VARCHAR2
108 ,p_information19 IN OUT NOCOPY VARCHAR2
109 ,p_information20 IN OUT NOCOPY VARCHAR2
110 ,p_information21 IN OUT NOCOPY VARCHAR2
111 ,p_information22 IN OUT NOCOPY VARCHAR2
112 ,p_information23 IN OUT NOCOPY VARCHAR2
113 ,p_information24 IN OUT NOCOPY VARCHAR2
114 ,p_information25 IN OUT NOCOPY VARCHAR2
115 ,p_information26 IN OUT NOCOPY VARCHAR2
116 ,p_information27 IN OUT NOCOPY VARCHAR2
117 ,p_information28 IN OUT NOCOPY VARCHAR2
118 ,p_information29 IN OUT NOCOPY VARCHAR2
119 ,p_information30 IN OUT NOCOPY VARCHAR2);
120 --
121 FUNCTION get_poi_desc (p_personnel_office_id IN NUMBER)
122 RETURN VARCHAR2;
123
124 PROCEDURE get_grade_details (p_grade_id IN NUMBER
125 ,p_grade_name IN OUT NOCOPY VARCHAR2
126 ,p_pay_plan IN OUT NOCOPY VARCHAR2
127 ,p_grade_or_level IN OUT NOCOPY VARCHAR2);
128
129 FUNCTION get_consolidated_count (p_consolidated_complaint_id IN NUMBER
130 ,p_complaint_id IN NUMBER)
131 RETURN NUMBER;
132
133 FUNCTION get_docket_number (p_consolidated_complaint_id IN NUMBER)
134 RETURN VARCHAR2;
135
136 FUNCTION mixed_complaint(p_complaint_id IN NUMBER)
137 RETURN BOOLEAN;
138
139 FUNCTION remand_complaint(p_complaint_id IN NUMBER)
140 RETURN BOOLEAN;
141
142 FUNCTION get_window_title(p_complaint_id IN NUMBER
143 ,p_effective_date IN DATE)
144 RETURN VARCHAR2;
145
146 FUNCTION get_lookup_code(p_application_id fnd_common_lookups.application_id%TYPE
147 ,p_lookup_type fnd_common_lookups.lookup_type%TYPE
148 ,p_meaning fnd_common_lookups.meaning%TYPE)
149 RETURN VARCHAR2;
150
151 FUNCTION get_lookup_meaning(p_application_id fnd_common_lookups.application_id%TYPE
152 ,p_lookup_type fnd_common_lookups.lookup_type%TYPE
153 ,p_lookup_code fnd_common_lookups.lookup_code%TYPE)
154 RETURN VARCHAR2;
155
156 FUNCTION CA_REC_EXISTS(p_complaint_id IN NUMBER)
157 RETURN BOOLEAN;
158
159 FUNCTION LTR_CLAIM_CHK(p_complaint_id IN NUMBER)
160 RETURN BOOLEAN;
161
162 FUNCTION CLAIM_CHK(p_complaint_id IN NUMBER)
163 RETURN BOOLEAN;
164
165 FUNCTION PCOM_INIT_CHK(p_complaint_id IN NUMBER)
166 RETURN BOOLEAN;
167
168 FUNCTION BASIS_CHK(p_compl_claim_id IN NUMBER)
169 RETURN BOOLEAN;
170
171 FUNCTION claim_exists(p_complaint_id IN NUMBER)
172 RETURN BOOLEAN;
173
174
175 END ghr_complaints2_pkg;