1 PACKAGE HR_BPL_ALERT_TRNSLT AUTHID CURRENT_USER AS
2 /* $Header: perbatsl.pkh 115.3 2003/06/03 16:00:19 jrstewar noship $ */
3 --
4 -- -----------------------------------------------------------------------
5 --
6 -- Globals used to cache location code.
7 --
8 g_location_code VARCHAR2(60);
9 g_location_language VARCHAR2(10);
10 g_location_id NUMBER;
11 --
12 -- -----------------------------------------------------------------------
13 --
14 -- Globals used to cache organization name.
15 --
16 g_organization_id NUMBER;
17 g_organization_language VARCHAR2(10);
18 g_organization_name VARCHAR2(240);
19 --
20 -- -----------------------------------------------------------------------
21 --
22 -- Globals used to cache job_name.
23 --
24 g_job_id NUMBER;
25 g_job_code VARCHAR2(60);
26 g_job_name VARCHAR2(240);
27 --
28 -- -----------------------------------------------------------------------
29 --
30 -- Globals used to cache position_name.
31 --
32 g_position_id NUMBER;
33 g_position_code VARCHAR2(60);
34 g_position_name VARCHAR2(240);
35 --
36 -- -----------------------------------------------------------------------
37 --
38 -- Globals used to cache grade_name.
39 --
40 g_grade_id NUMBER;
41 g_grade_code VARCHAR2(60);
42 g_grade_name VARCHAR2(240);
43
44 FUNCTION location(p_language IN VARCHAR2
45 ,p_location_id IN NUMBER)
46 RETURN VARCHAR2;
47 --
48 FUNCTION organization(p_language IN VARCHAR2
49 ,p_organization_id IN NUMBER)
50 RETURN VARCHAR2;
51 --
52 FUNCTION job(p_job_id IN NUMBER)
53 RETURN VARCHAR2;
54 --
55 FUNCTION position(p_position_id IN NUMBER)
56 RETURN VARCHAR2;
57 --
58 FUNCTION grade(p_grade_id IN NUMBER)
59 RETURN VARCHAR2;
60 --
61 FUNCTION psn_lng_decode_lookup(p_lookup_type IN VARCHAR2
62 ,p_lookup_code IN VARCHAR2
63 ,p_person_id IN NUMBER)
64
65 RETURN fnd_lookup_values.meaning%TYPE;
66 --
67 FUNCTION psn_lng_location(p_person_id IN NUMBER
68 ,p_location_id IN NUMBER)
69 RETURN VARCHAR2;
70 --
71 FUNCTION psn_sup_lng_location(p_person_id IN NUMBER
72 ,p_location_id IN NUMBER)
73 RETURN VARCHAR2;
74 --
75 FUNCTION psn_lng_organization(p_person_id IN NUMBER
76 ,p_organization_id IN NUMBER)
77 RETURN VARCHAR2;
78 --
79 FUNCTION psn_sup_lng_organization(p_person_id IN NUMBER
80 ,p_organization_id IN NUMBER)
81 RETURN VARCHAR2;
82 --
83 FUNCTION psn_lng_job(p_person_id IN NUMBER
84 ,p_job_id IN NUMBER)
85 RETURN VARCHAR2;
86 --
87 FUNCTION psn_sup_lng_job(p_person_id IN NUMBER
88 ,p_job_id IN NUMBER)
89 RETURN VARCHAR2;
90 --
91 FUNCTION psn_lng_position(p_person_id IN NUMBER
92 ,p_position_id IN NUMBER)
93 RETURN VARCHAR2;
94 --
95 FUNCTION psn_sup_lng_position(p_person_id IN NUMBER
96 ,p_position_id IN NUMBER)
97 RETURN VARCHAR2;
98
99 FUNCTION psn_lng_grade(p_person_id IN NUMBER
100 ,p_grade_id IN NUMBER)
101 RETURN VARCHAR2;
102 --
103 FUNCTION psn_sup_lng_grade(p_person_id IN NUMBER
104 ,p_grade_id IN NUMBER)
105 RETURN VARCHAR2;
106 --
107
108 FUNCTION asg_lng_decode_lookup(p_lookup_type IN VARCHAR2
109 ,p_lookup_code IN VARCHAR2
110 ,p_assignment_id IN NUMBER)
111
112 RETURN fnd_lookup_values.meaning%TYPE;
113 --
114 FUNCTION asg_lng_location(p_assignment_id IN NUMBER
115 ,p_location_id IN NUMBER)
116 RETURN VARCHAR2;
117 --
118 FUNCTION asg_lng_organization(p_assignment_id IN NUMBER
119 ,p_organization_id IN NUMBER)
120 RETURN VARCHAR2;
121 --
122 FUNCTION asg_sup_lng_decode_lookup(p_lookup_type IN VARCHAR2
123 ,p_lookup_code IN VARCHAR2
124 ,p_assignment_id IN NUMBER)
125
126 RETURN fnd_lookup_values.meaning%TYPE;
127 --
128 FUNCTION asg_sup_lng_location(p_assignment_id IN NUMBER
129 ,p_location_id IN NUMBER)
130 RETURN VARCHAR2;
131 --
132 FUNCTION asg_sup_lng_organization(p_assignment_id IN NUMBER
133 ,p_organization_id IN NUMBER)
134 RETURN VARCHAR2;
135 --
136 FUNCTION asg_sup_lng_job(p_assignment_id IN NUMBER
137 ,p_job_id IN NUMBER)
138 RETURN VARCHAR2;
139 --
140 FUNCTION asg_sup_lng_position(p_assignment_id IN NUMBER
141 ,p_position_id IN NUMBER)
142 RETURN VARCHAR2;
143 --
144 FUNCTION asg_sup_lng_grade(p_assignment_id IN NUMBER
145 ,p_grade_id IN NUMBER)
146 RETURN VARCHAR2;
147 --
148 FUNCTION pasg_sup_lng_decode_lookup(p_lookup_type IN VARCHAR2
149 ,p_lookup_code IN VARCHAR2
150 ,p_assignment_id IN NUMBER)
151
152 RETURN fnd_lookup_values.meaning%TYPE;
153 --
154 FUNCTION pasg_sup_lng_location(p_assignment_id IN NUMBER
155 ,p_location_id IN NUMBER)
156 RETURN VARCHAR2;
157 --
158 FUNCTION pasg_sup_lng_organization(p_assignment_id IN NUMBER
159 ,p_organization_id IN NUMBER)
160 RETURN VARCHAR2;
161 --
162 FUNCTION pasg_sup_lng_job(p_assignment_id IN NUMBER
163 ,p_job_id IN NUMBER)
164 RETURN VARCHAR2;
165 --
166 FUNCTION pasg_sup_lng_position(p_assignment_id IN NUMBER
167 ,p_position_id IN NUMBER)
168 RETURN VARCHAR2;
169 --
170 FUNCTION pasg_sup_lng_grade(p_assignment_id IN NUMBER
171 ,p_grade_id IN NUMBER)
172 RETURN VARCHAR2;
173
174 END HR_BPL_ALERT_TRNSLT;