1 PACKAGE HR_VIEW_ALERT_TRNSLT AUTHID CURRENT_USER AS
2 /* $Header: pervatsl.pkh 115.2 2003/05/27 09:43:09 jrstewar noship $ */
3 --
4 -- -----------------------------------------------------------------------
5 --
6 -- Globals used to cache location code.
7 --
8 g_location_code VARCHAR2(60);
9 g_location_language VARCHAR2(4);
10 g_location_id NUMBER;
11 --
12 FUNCTION location(p_language IN VARCHAR2
13 ,p_location_id IN NUMBER)
14 RETURN VARCHAR2;
15 --
16 FUNCTION organization(p_language IN VARCHAR2
17 ,p_organization_id IN NUMBER)
18 RETURN VARCHAR2;
19 --
20 FUNCTION job(p_job_id IN NUMBER)
21 RETURN VARCHAR2;
22 --
23 FUNCTION position(p_position_id IN NUMBER)
24 RETURN VARCHAR2;
25 --
26 FUNCTION grade(p_grade_id IN NUMBER)
27 RETURN VARCHAR2;
28 --
29 FUNCTION psn_lng_decode_lookup(p_lookup_type IN VARCHAR2
30 ,p_lookup_code IN VARCHAR2
31 ,p_person_id IN NUMBER)
32
33 RETURN fnd_lookup_values.meaning%TYPE;
34 --
35 FUNCTION psn_sup_lng_location(p_person_id IN NUMBER
36 ,p_location_id IN NUMBER)
37 RETURN VARCHAR2;
38 --
39 FUNCTION psn_lng_location(p_person_id IN NUMBER
40 ,p_location_id IN NUMBER)
41 RETURN VARCHAR2;
42 --
43 FUNCTION psn_lng_organization(p_person_id IN NUMBER
44 ,p_organization_id IN NUMBER)
45 RETURN VARCHAR2;
46 --
47 FUNCTION psn_sup_lng_organization(p_person_id IN NUMBER
48 ,p_organization_id IN NUMBER)
49 RETURN VARCHAR2;
50 --
51 FUNCTION psn_lng_job(p_person_id IN NUMBER
52 ,p_job_id IN NUMBER)
53 RETURN VARCHAR2;
54 --
55 FUNCTION psn_sup_lng_job(p_person_id IN NUMBER
56 ,p_job_id IN NUMBER)
57 RETURN VARCHAR2;
58 --
59 FUNCTION psn_lng_position(p_person_id IN NUMBER
60 ,p_position_id IN NUMBER)
61 RETURN VARCHAR2;
62 --
63 FUNCTION psn_sup_lng_position(p_person_id IN NUMBER
64 ,p_position_id IN NUMBER)
65 RETURN VARCHAR2;
66
67 FUNCTION psn_lng_grade(p_person_id IN NUMBER
68 ,p_grade_id IN NUMBER)
69 RETURN VARCHAR2;
70 --
71 FUNCTION psn_sup_lng_grade(p_person_id IN NUMBER
72 ,p_grade_id IN NUMBER)
73 RETURN VARCHAR2;
74 --
75 FUNCTION asg_lng_decode_lookup(p_lookup_type IN VARCHAR2
76 ,p_lookup_code IN VARCHAR2
77 ,p_assignment_id IN NUMBER)
78 RETURN fnd_lookup_values.meaning%TYPE;
79 --
80 FUNCTION asg_lng_location(p_assignment_id IN NUMBER
81 ,p_location_id IN NUMBER)
82 RETURN VARCHAR2;
83 --
84 FUNCTION asg_lng_organization(p_assignment_id IN NUMBER
85 ,p_organization_id IN NUMBER)
86 RETURN VARCHAR2;
87 --
88 FUNCTION asg_sup_lng_decode_lookup(p_lookup_type IN VARCHAR2
89 ,p_lookup_code IN VARCHAR2
90 ,p_assignment_id IN NUMBER)
91 RETURN fnd_lookup_values.meaning%TYPE;
92 --
93 FUNCTION asg_sup_lng_location(p_assignment_id IN NUMBER
94 ,p_location_id IN NUMBER)
95 RETURN VARCHAR2;
96 --
97 FUNCTION asg_sup_lng_organization(p_assignment_id IN NUMBER
98 ,p_organization_id IN NUMBER)
99 RETURN VARCHAR2;
100 --
101 FUNCTION asg_sup_lng_job(p_assignment_id IN NUMBER
102 ,p_job_id IN NUMBER)
103 RETURN VARCHAR2;
104 --
105 FUNCTION asg_sup_lng_position(p_assignment_id IN NUMBER
106 ,p_position_id IN NUMBER)
107 RETURN VARCHAR2;
108 --
109 FUNCTION asg_sup_lng_grade(p_assignment_id IN NUMBER
110 ,p_grade_id IN NUMBER)
111 RETURN VARCHAR2;
112 --
113 FUNCTION pasg_sup_lng_decode_lookup(p_lookup_type IN VARCHAR2
114 ,p_lookup_code IN VARCHAR2
115 ,p_assignment_id IN NUMBER)
116 RETURN fnd_lookup_values.meaning%TYPE;
117 --
118 FUNCTION pasg_sup_lng_location(p_assignment_id IN NUMBER
119 ,p_location_id IN NUMBER)
120 RETURN VARCHAR2;
121 --
122 FUNCTION pasg_sup_lng_organization(p_assignment_id IN NUMBER
123 ,p_organization_id IN NUMBER)
124 RETURN VARCHAR2;
125 --
126 FUNCTION pasg_sup_lng_job(p_assignment_id IN NUMBER
127 ,p_job_id IN NUMBER)
128 RETURN VARCHAR2;
129 --
130 FUNCTION pasg_sup_lng_position(p_assignment_id IN NUMBER
131 ,p_position_id IN NUMBER)
132 RETURN VARCHAR2;
133 --
134 FUNCTION pasg_sup_lng_grade(p_assignment_id IN NUMBER
135 ,p_grade_id IN NUMBER)
136 RETURN VARCHAR2;
137 --
138 END HR_VIEW_ALERT_TRNSLT;