1 PACKAGE BODY MSCX_UI_UTILITIES AS
2 -- $Header: MSCXUIPB.pls 120.1 2006/01/05 04:09:13 pragarwa noship $
3
4
5 FUNCTION GET_RESPONSIBILITY_KEY
6 return varchar2 is
7 l_resp_key varchar2(30);
8 begin
9 select responsibility_key into l_resp_key
10 from fnd_responsibility
11 where responsibility_id=fnd_global.resp_id
12 and application_id=724;
13 return l_resp_key;
14 end GET_RESPONSIBILITY_KEY;
15
16
17 FUNCTION GET_USER_NAME(grantee_key number)
18 return varchar2 is
19 l_user_name varchar2(100);
20 begin
21 select user_name into l_user_name
22 from fnd_user
23 where user_id=grantee_key;
24 --dbms_output.put_line('user name is ' || l_user_name);
25 return l_user_name;
26 end GET_USER_NAME;
27
28
29 FUNCTION GET_RESPONSIBILITY_NAME(grantee_key number)
30 return varchar2 is
31 l_resp_name varchar2(100);
32 begin
33 select responsibility_name into l_resp_name
34 from fnd_responsibility_vl
35 where responsibility_id=grantee_key;
36 return l_resp_name;
37 end GET_RESPONSIBILITY_NAME;
38
39 FUNCTION GET_GROUP_NAME(grantee_key number)
40 return varchar2 is
41 l_group_name varchar2(100);
42 begin
43 select group_name into l_group_name
44 from msc_groups
45 where group_id=grantee_key;
46 return l_group_name;
47 end GET_GROUP_NAME;
48
49 FUNCTION GET_COMPANY_NAME(grantee_key number)
50 return varchar2 is
51 l_company_name varchar2(1000);
52 begin
53 select company_name into l_company_name
54 from msc_companies
55 where company_id=grantee_key;
56 return l_company_name;
57 end GET_COMPANY_NAME;
58
59
60 FUNCTION GET_SITE_NAME(p_site_id number)
61 return varchar2 is
62 l_site_name varchar2(30);
63 begin
64 select distinct(company_site_name) into l_site_name
65 from msc_company_sites
66 where company_site_id=p_site_id;
67 return l_site_name;
68 end GET_SITE_NAME;
69
70 FUNCTION GET_ITEM_NAME(p_item_id number)
71 return varchar2 is
72 l_item_name varchar2(250);
73 begin
74 select item_name into l_item_name
75 from msc_items
76 where inventory_item_id=p_item_id;
77 return l_item_name;
78 end GET_ITEM_NAME;
79
80
81 FUNCTION GET_ORDER_TYPE_MEANING(p_order_type number)
82 return varchar2 is
83 l_meaning varchar2(80);
84 begin
85 if p_order_type is null then
86 return null;
87 else
88 select meaning into l_meaning
89 from fnd_lookup_values
90 where lookup_type='MSC_X_ORDER_TYPE'
91 and language=userenv('lang')
92 and lookup_code=to_char(p_order_type);
93 return l_meaning;
94 end if;
95 end GET_ORDER_TYPE_MEANING;
96
97
98 FUNCTION GET_GRANTEE_TYPE_MEANING(p_grantee_type varchar2)
99 return varchar2 is
100 l_meaning varchar2(80);
101 begin
102 select meaning into l_meaning
103 from fnd_lookup_values
104 where lookup_type='MSC_X_GRANTEE_TYPE'
105 and language=userenv('lang')
106 and lookup_code=p_grantee_type;
107 return l_meaning;
108 end GET_GRANTEE_TYPE_MEANING;
109
110 FUNCTION GET_PRIVILEGE_MEANING(p_privilege varchar2)
111 return varchar2 is
112 l_meaning varchar2(80);
113 begin
114 select meaning into l_meaning
115 from fnd_lookup_values
116 where lookup_type='MSC_X_PRIVILEGE_TYPE'
117 and language=userenv('lang')
118 and lookup_code=p_privilege;
119 return l_meaning;
120 end GET_PRIVILEGE_MEANING;
121
122
123 END MSCX_UI_UTILITIES ;
124
125