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.CSM_PROFILE_PKG dependencies on FND_APPLICATION

Line 19: p_application_id fnd_application.application_id%type default null)

15:
16: Function value_specific(p_profile_option_name in varchar2,
17: p_user_id in fnd_user.user_id%type,
18: p_responsibility_id fnd_user_resp_groups.responsibility_id%type default null,
19: p_application_id fnd_application.application_id%type default null)
20: return varchar2
21: is
22: l_retvalue varchar2(255);
23: l_user_id fnd_user.user_id%type;

Line 25: l_application_id fnd_application.application_id%type;

21: is
22: l_retvalue varchar2(255);
23: l_user_id fnd_user.user_id%type;
24: l_responsibility_id fnd_user_resp_groups.responsibility_id%type;
25: l_application_id fnd_application.application_id%type;
26:
27: -- will always return 1 row as of now for a publication
28: cursor l_resp_app_id_csr(c_user_id NUMBER)
29: is

Line 60: p_application_id fnd_application.application_id%type default null)

56: end value_specific;
57:
58: function get_master_organization_id (p_user_id in fnd_user.user_id%type,
59: p_responsibility_id fnd_user_resp_groups.responsibility_id%type default null,
60: p_application_id fnd_application.application_id%type default null)
61: return number
62: IS
63: begin
64: -- return fnd_profile.value('ASO_PRODUCT_ORGANIZATION_ID');

Line 71: p_application_id fnd_application.application_id%type default null)

67: end get_master_organization_id;
68:
69: function get_service_validation_org(p_user_id in fnd_user.user_id%type,
70: p_responsibility_id fnd_user_resp_groups.responsibility_id%type default null,
71: p_application_id fnd_application.application_id%type default null)
72: return number
73: IS
74: l_profile_option_value NUMBER;
75:

Line 100: p_application_id fnd_application.application_id%type default null)

96: end get_service_validation_org;
97:
98: function get_organization_id(p_user_id in 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: return number
102: IS
103: l_profile_option_value NUMBER;
104:

Line 129: p_application_id fnd_application.application_id%type default null

125: end get_organization_id;
126:
127: Function get_category_set_id(p_user_id fnd_user.user_id%type,
128: p_responsibility_id fnd_user_resp_groups.responsibility_id%type default null,
129: p_application_id fnd_application.application_id%type default null
130: )
131: return number
132: IS
133: l_profile_option_value NUMBER;

Line 159: p_application_id fnd_application.application_id%type default null

155: END get_category_set_id;
156:
157: Function get_category_id(p_user_id fnd_user.user_id%type,
158: p_responsibility_id fnd_user_resp_groups.responsibility_id%type default null,
159: p_application_id fnd_application.application_id%type default null
160: )
161: return number
162: IS
163: l_profile_option_value NUMBER;

Line 189: p_application_id fnd_application.application_id%type default null

185: END get_category_id;
186:
187: Function get_history_count(p_user_id fnd_user.user_id%type,
188: p_responsibility_id fnd_user_resp_groups.responsibility_id%type default null,
189: p_application_id fnd_application.application_id%type default null
190: )
191: return NUMBER
192: IS
193: l_profile_option_value NUMBER;

Line 224: p_application_id fnd_application.application_id%type default null)

220: END get_history_count;
221:
222: function get_org_id(p_user_id in fnd_user.user_id%type,
223: p_responsibility_id fnd_user_resp_groups.responsibility_id%type default null,
224: p_application_id fnd_application.application_id%type default null)
225: return number
226: is
227: begin
228: return value_specific('CS_SR_ORG_ID', p_user_id, p_responsibility_id,

Line 293: p_application_id fnd_application.application_id%type default null)

289: end GetDefaultStatusResponsibility;
290:
291: Function get_change_completed_tasks (p_user_id in fnd_user.user_id%type,
292: p_responsibility_id fnd_user_resp_groups.responsibility_id%type default null,
293: p_application_id fnd_application.application_id%type default null)
294: return varchar2 IS
295: l_profile_option_value NUMBER;
296:
297: CURSOR l_profile_opt_value_csr(p_userid IN NUMBER) IS

Line 321: p_application_id fnd_application.application_id%type default null)

317: end get_change_completed_tasks;
318:
319: Function show_new_mail_only(p_user_id in fnd_user.user_id%type,
320: p_responsibility_id fnd_user_resp_groups.responsibility_id%type default null,
321: p_application_id fnd_application.application_id%type default null)
322: return varchar2 IS
323: l_profile_option_value NUMBER;
324:
325: CURSOR l_profile_opt_value_csr(p_userid IN NUMBER) IS

Line 350: p_application_id fnd_application.application_id%type default null)

346:
347:
348: Function get_task_history_days(p_user_id in fnd_user.user_id%type,
349: p_responsibility_id fnd_user_resp_groups.responsibility_id%type default null,
350: p_application_id fnd_application.application_id%type default null)
351: return number IS
352: l_profile_option_value NUMBER;
353:
354: BEGIN

Line 368: p_application_id fnd_application.application_id%type default null

364: end get_task_history_days;
365:
366: Function get_max_attachment_size(p_user_id fnd_user.user_id%type,
367: p_responsibility_id fnd_user_resp_groups.responsibility_id%type default null,
368: p_application_id fnd_application.application_id%type default null
369: )
370: return NUMBER
371: IS
372: l_profile_option_value NUMBER;

Line 398: p_application_id fnd_application.application_id%TYPE DEFAULT NULL

394: END get_max_attachment_size;
395:
396: FUNCTION get_max_ib_at_location(p_user_id fnd_user.user_id%TYPE,
397: p_responsibility_id fnd_user_resp_groups.responsibility_id%TYPE DEFAULT NULL,
398: p_application_id fnd_application.application_id%TYPE DEFAULT NULL
399: )
400: RETURN NUMBER
401: IS
402: l_profile_option_value NUMBER;

Line 433: p_application_id fnd_application.application_id%TYPE DEFAULT NULL

429: END get_max_ib_at_location;
430:
431: FUNCTION get_max_readings_per_counter(p_user_id fnd_user.user_id%TYPE,
432: p_responsibility_id fnd_user_resp_groups.responsibility_id%TYPE DEFAULT NULL,
433: p_application_id fnd_application.application_id%TYPE DEFAULT NULL
434: )
435: RETURN NUMBER
436: IS
437: l_profile_option_value NUMBER;

Line 470: p_application_id fnd_application.application_id%TYPE DEFAULT NULL

466: END get_max_readings_per_counter;
467:
468: FUNCTION Get_Route_Data_To_Owner(p_user_id fnd_user.user_id%TYPE DEFAULT NULL,
469: p_responsibility_id fnd_user_resp_groups.responsibility_id%TYPE DEFAULT NULL,
470: p_application_id fnd_application.application_id%TYPE DEFAULT NULL
471: )
472: RETURN VARCHAR2
473: IS
474: l_profile_option_value VARCHAR2(1);