[Home] [Help]
PACKAGE: APPS.CSM_PROFILE_PKG
Source
1 PACKAGE CSM_PROFILE_PKG AUTHID CURRENT_USER AS
2 /* $Header: csmuprfs.pls 120.5.12020000.2 2013/04/09 11:05:31 saradhak ship $ */
3
4 --
5 -- Purpose: Briefly explain the functionality of the package
6 -- This package will contain routines getting profile values
7 -- MODIFICATION HISTORY
8 -- Person Date Comments
9 -- --------- ------ ------------------------------------------
10 -- Melvin P 04/30/02 Base creation
11 -- Enter package declarations as shown below
12
13 g_CLIENT_WINS CONSTANT varchar2(30) := 'CLIENT_WINS';
14 g_SERVER_WINS CONSTANT varchar2(30) := 'SERVER_WINS';
15 g_JTM_APPL_CONFLICT_RULE CONSTANT varchar2(30) := 'JTM_APPL_CONFLICT_RULE';
16 g_CSF_M_HISTORY_DAYS CONSTANT NUMBER := 7;
17
18 Function value_specific(p_profile_option_name in varchar2,
19 p_user_id fnd_user.user_id%type,
20 p_responsibility_id fnd_user_resp_groups.responsibility_id%type default null,
21 p_application_id fnd_application.application_id%type default null
22 )
23 return varchar2;
24
25 Function get_master_organization_id(p_user_id fnd_user.user_id%type,
26 p_responsibility_id fnd_user_resp_groups.responsibility_id%type default null,
27 p_application_id fnd_application.application_id%type default null
28 )
29 return number;
30
31 function get_service_validation_org(p_user_id in fnd_user.user_id%type,
32 p_responsibility_id fnd_user_resp_groups.responsibility_id%type default null,
33 p_application_id fnd_application.application_id%type default null)
34 return number;
35
36 Function get_organization_id(p_user_id fnd_user.user_id%type,
37 p_responsibility_id fnd_user_resp_groups.responsibility_id%type default null,
38 p_application_id fnd_application.application_id%type default null
39 )
40 return number;
41
42 Function get_category_set_id(p_user_id fnd_user.user_id%type,
43 p_responsibility_id fnd_user_resp_groups.responsibility_id%type default null,
44 p_application_id fnd_application.application_id%type default null
45 )
46 return number;
47
48 Function get_category_id(p_user_id fnd_user.user_id%type,
49 p_responsibility_id fnd_user_resp_groups.responsibility_id%type default null,
50 p_application_id fnd_application.application_id%type default null
51 )
52 return number;
53
54 Function get_history_count(p_user_id fnd_user.user_id%type,
55 p_responsibility_id fnd_user_resp_groups.responsibility_id%type default null,
56 p_application_id fnd_application.application_id%type default null
57 )
58 return number;
59
60 Function get_org_id(p_user_id fnd_user.user_id%type,
61 p_responsibility_id fnd_user_resp_groups.responsibility_id%type default null,
62 p_application_id fnd_application.application_id%type default null
63 )
64 return number;
65
66 Function GetDefaultStatusResponsibility( p_user_id fnd_user.user_id%type) return number;
67
68 Function get_change_completed_tasks(p_user_id fnd_user.user_id%type,
69 p_responsibility_id fnd_user_resp_groups.responsibility_id%type default null,
70 p_application_id fnd_application.application_id%type default null
71 )
72 return varchar2;
73
74 Function show_new_mail_only(p_user_id fnd_user.user_id%type,
75 p_responsibility_id fnd_user_resp_groups.responsibility_id%type default null,
76 p_application_id fnd_application.application_id%type default null
77 )
78 return varchar2;
79
80 Function get_task_history_days(p_user_id fnd_user.user_id%type,
81 p_responsibility_id fnd_user_resp_groups.responsibility_id%type default null,
82 p_application_id fnd_application.application_id%type default null
83 )
84 return number;
85
86 Function get_max_attachment_size(p_user_id fnd_user.user_id%type,
87 p_responsibility_id fnd_user_resp_groups.responsibility_id%type default null,
88 p_application_id fnd_application.application_id%type default null
89 )
90 return number;
91
92 Function get_max_ib_at_location(p_user_id fnd_user.user_id%type,
93 p_responsibility_id fnd_user_resp_groups.responsibility_id%type default null,
94 p_application_id fnd_application.application_id%type default null
95 )
96 return NUMBER;
97
98 FUNCTION get_max_readings_per_counter(p_user_id fnd_user.user_id%TYPE,
99 p_responsibility_id fnd_user_resp_groups.responsibility_id%TYPE DEFAULT NULL,
100 p_application_id fnd_application.application_id%TYPE DEFAULT NULL
101 )
102 RETURN NUMBER;
103
104 FUNCTION Get_Route_Data_To_Owner(p_user_id fnd_user.user_id%TYPE DEFAULT NULL,
105 p_responsibility_id fnd_user_resp_groups.responsibility_id%TYPE DEFAULT NULL,
106 p_application_id fnd_application.application_id%TYPE DEFAULT NULL
107 )
108 RETURN VARCHAR2;
109
110 FUNCTION Get_Mobile_Query_Schema( p_responsibility_id fnd_user_resp_groups.responsibility_id%TYPE DEFAULT NULL
111 )
112 RETURN VARCHAR2;
113
114 FUNCTION Get_download_inventory_flag(p_user_id fnd_user.user_id%TYPE DEFAULT NULL,
115 p_responsibility_id fnd_user_resp_groups.responsibility_id%TYPE DEFAULT NULL,
116 p_application_id fnd_application.application_id%TYPE DEFAULT NULL
117 )
118 RETURN VARCHAR2;
119
120 END CSM_PROFILE_PKG; -- Package spec
121
122