eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_TIPS_API dependencies on HR_TIPS

Line 1: package body hr_tips_api as

1: package body hr_tips_api as
2: /* $Header: hrtipapi.pkb 120.2 2005/08/04 21:34:39 raranjan noship $ */
3: --
4: --
5: -- private function

Line 39: l_screen hr_tips.screen%type default null;

35: ,p_default boolean default true
36: ) return varchar2 is
37: --
38:
39: l_screen hr_tips.screen%type default null;
40: l_field hr_tips.field%type default null;
41: l_lang_code hr_tips.language_code%type default null;
42: --
43:

Line 40: l_field hr_tips.field%type default null;

36: ) return varchar2 is
37: --
38:
39: l_screen hr_tips.screen%type default null;
40: l_field hr_tips.field%type default null;
41: l_lang_code hr_tips.language_code%type default null;
42: --
43:
44: -- For performance improvement:

Line 41: l_lang_code hr_tips.language_code%type default null;

37: --
38:
39: l_screen hr_tips.screen%type default null;
40: l_field hr_tips.field%type default null;
41: l_lang_code hr_tips.language_code%type default null;
42: --
43:
44: -- For performance improvement:
45: -- We assume that the database attributes, screen, field and language_code

Line 49: from hr_tips t

45: -- We assume that the database attributes, screen, field and language_code
46: -- are loaded to the database in upper case. Thus, we can use the index.
47: cursor csr_get_tip(p_bg NUMBER) is
48: select t.text
49: from hr_tips t
50: where t.screen = l_screen
51: and t.field = l_field
52: and t.language_code = l_lang_code
53: and t.business_group_id = p_bg;

Line 57: from hr_tips t

53: and t.business_group_id = p_bg;
54: --
55: cursor csr_get_tip_default is
56: select t.text
57: from hr_tips t
58: where t.screen = l_screen
59: and t.field = l_field
60: and t.language_code = l_lang_code
61: and t.business_group_id is null;

Line 111: l_screen hr_tips.screen%type default null;

107: ,p_business_group_id number default null
108: ,p_default boolean default true
109: ) return TipRecTable is
110: --
111: l_screen hr_tips.screen%type default null;
112: l_lang_code hr_tips.language_code%type default null;
113: --
114:
115: -- For performance improvement:

Line 112: l_lang_code hr_tips.language_code%type default null;

108: ,p_default boolean default true
109: ) return TipRecTable is
110: --
111: l_screen hr_tips.screen%type default null;
112: l_lang_code hr_tips.language_code%type default null;
113: --
114:
115: -- For performance improvement:
116: -- We assume that the database attributes, screen and language_code

Line 121: from hr_tips t

117: -- are loaded to the database in upper case. Thus, we can use the index.
118:
119: cursor csr_get_all_tips(p_bg NUMBER) is
120: select t.field, t.text
121: from hr_tips t
122: where t.screen = l_screen
123: and t.language_code = l_lang_code
124: and t.business_group_id = p_bg
125: and t.field NOT IN ('DISCLAIMER', 'INSTRUCTIONS');

Line 129: from hr_tips t

125: and t.field NOT IN ('DISCLAIMER', 'INSTRUCTIONS');
126: --
127: cursor csr_get_all_tips_default(p_bg NUMBER) is
128: select t.field, t.text
129: from hr_tips t
130: where t.screen = l_screen
131: and t.language_code = l_lang_code
132: and t.field NOT IN ('DISCLAIMER', 'INSTRUCTIONS')
133: and ((t.business_group_id is null and not exists (select 'Y'

Line 134: from hr_tips

130: where t.screen = l_screen
131: and t.language_code = l_lang_code
132: and t.field NOT IN ('DISCLAIMER', 'INSTRUCTIONS')
133: and ((t.business_group_id is null and not exists (select 'Y'
134: from hr_tips
135: where screen = l_screen
136: and language_code = l_lang_code
137: and business_group_id = p_bg
138: and field = t.field))

Line 182: l_screen hr_tips.screen%type default null;

178: ,p_instruction_name varchar2 default 'INSTRUCTIONS'
179: ,p_default boolean default true
180: ) return varchar2 is
181: --
182: l_screen hr_tips.screen%type default null;
183: l_lang_code hr_tips.language_code%type default null;
184: l_instruction_name hr_tips.field%type default null;
185: --
186:

Line 183: l_lang_code hr_tips.language_code%type default null;

179: ,p_default boolean default true
180: ) return varchar2 is
181: --
182: l_screen hr_tips.screen%type default null;
183: l_lang_code hr_tips.language_code%type default null;
184: l_instruction_name hr_tips.field%type default null;
185: --
186:
187: -- For performance improvement:

Line 184: l_instruction_name hr_tips.field%type default null;

180: ) return varchar2 is
181: --
182: l_screen hr_tips.screen%type default null;
183: l_lang_code hr_tips.language_code%type default null;
184: l_instruction_name hr_tips.field%type default null;
185: --
186:
187: -- For performance improvement:
188: -- We assume that the database attributes, screen,field and language_code

Line 193: from hr_tips t

189: -- are loaded to the database in upper case. Thus, we can use the index.
190:
191: cursor csr_get_instructions(p_default_bg NUMBER) IS
192: select t.text
193: from hr_tips t
194: where t.screen = l_screen
195: and t.field = l_instruction_name
196: and t.language_code = l_lang_code
197: and (NVL(t.business_group_id,-1) = NVL(p_business_group_id,-1)

Line 243: l_screen hr_tips.screen%type default null;

239: ,p_default boolean default true
240: ) return varchar2 is
241: --
242: --
243: l_screen hr_tips.screen%type default null;
244: l_lang_code hr_tips.language_code%type default null;
245: --
246: -- For performance improvement:
247: -- We assume that the database attributes, screen and language_code

Line 244: l_lang_code hr_tips.language_code%type default null;

240: ) return varchar2 is
241: --
242: --
243: l_screen hr_tips.screen%type default null;
244: l_lang_code hr_tips.language_code%type default null;
245: --
246: -- For performance improvement:
247: -- We assume that the database attributes, screen and language_code
248: -- are loaded to the database in upper case. Thus, we can use the index.

Line 252: from hr_tips t

248: -- are loaded to the database in upper case. Thus, we can use the index.
249:
250: cursor csr_get_disclaimer(p_default_bg NUMBER) is
251: select t.text
252: from hr_tips t
253: where t.screen = l_screen
254: and t.field = 'DISCLAIMER'
255: and t.language_code = l_lang_code
256: and (NVL(t.business_group_id,0) = NVL(p_business_group_id,0)

Line 287: end hr_tips_api;

283: return l_text;
284:
285: end;
286: --
287: end hr_tips_api;