PACKAGE BODY: APPS.ETRM_STATIC

Source

1 package body etrm_static as
2   function index_url return varchar2 is
3   begin
4     return g_index_url;
5   end index_url;
6 
7   function base_url return varchar2 is
8   begin
9     return g_base_url;
10   end base_url;
11 
12   function legal_text return varchar2 is
13     cursor cur_version is
14       select release_name
15       from fnd_product_groups
16       order by release_name;
17 
18     v_version         fnd_product_groups.release_name%type;
19   begin
20     v_version := '11i';
21     for v_rec in cur_version loop
22       v_version := v_rec.release_name;
23     end loop;
24 
25     if (regexp_instr(v_version, '[[:space:]]*11', 1, 1, 0, 'i') > 0)
26     then
27       return g_legal_text1_r11 || g_legal_text2;
28     else
29       return g_legal_text1_r12 || g_legal_text2;
30     end if;
31   end legal_text;
32 
33   function product_dependency_text return varchar2 is
34   begin
35     return g_product_dependency_text;
36   end product_dependency_text;
37 
38   function help_text return varchar2 is
39   begin
40     return g_help_text;
41   end help_text;
42 
43   function etrm_home1 return varchar2 is
44   begin
45     return g_etrm_home1;
46   end etrm_home1;
47 
48   function etrm_home2 return varchar2 is
49   begin
50     return g_etrm_home2;
51   end etrm_home2;
52 
53 end etrm_static;