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_USER

Line 17: p_user_id in fnd_user.user_id%type,

13: G_RESP_LEVEL_ID CONSTANT NUMBER := 10003;
14: G_USER_LEVEL_ID CONSTANT NUMBER := 10004;
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

Line 18: p_responsibility_id fnd_user_resp_groups.responsibility_id%type default null,

14: G_USER_LEVEL_ID CONSTANT NUMBER := 10004;
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);

Line 23: l_user_id fnd_user.user_id%type;

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;
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

Line 24: l_responsibility_id fnd_user_resp_groups.responsibility_id%type;

20: return varchar2
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)

Line 58: function get_master_organization_id (p_user_id in fnd_user.user_id%type,

54:
55: return l_retvalue;
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

Line 59: p_responsibility_id fnd_user_resp_groups.responsibility_id%type default null,

55: return l_retvalue;
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

Line 69: function get_service_validation_org(p_user_id in fnd_user.user_id%type,

65: return value_specific('ASO_PRODUCT_ORGANIZATION_ID', p_user_id,
66: p_responsibility_id, p_application_id);
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

Line 70: p_responsibility_id fnd_user_resp_groups.responsibility_id%type default null,

66: p_responsibility_id, p_application_id);
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;

Line 98: function get_organization_id(p_user_id in fnd_user.user_id%type,

94: return value_specific('CS_INV_VALIDATION_ORG', p_user_id,
95: p_responsibility_id, p_application_id);
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

Line 99: p_responsibility_id fnd_user_resp_groups.responsibility_id%type default null,

95: p_responsibility_id, p_application_id);
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;

Line 127: Function get_category_set_id(p_user_id fnd_user.user_id%type,

123: return value_specific('CS_INV_VALIDATION_ORG', p_user_id,
124: p_responsibility_id, p_application_id);
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

Line 128: p_responsibility_id fnd_user_resp_groups.responsibility_id%type default null,

124: p_responsibility_id, p_application_id);
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

Line 157: Function get_category_id(p_user_id fnd_user.user_id%type,

153: return value_specific('CSM_ITEM_CATEGORY_SET_FILTER', p_user_id,
154: p_responsibility_id, p_application_id);
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

Line 158: p_responsibility_id fnd_user_resp_groups.responsibility_id%type default null,

154: p_responsibility_id, p_application_id);
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

Line 187: Function get_history_count(p_user_id fnd_user.user_id%type,

183: return value_specific('CSM_ITEM_CATEGORY_FILTER', p_user_id,
184: p_responsibility_id, p_application_id);
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

Line 188: p_responsibility_id fnd_user_resp_groups.responsibility_id%type default null,

184: p_responsibility_id, p_application_id);
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

Line 222: function get_org_id(p_user_id in fnd_user.user_id%type,

218: WHEN OTHERS THEN
219: RETURN 0;
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

Line 223: p_responsibility_id fnd_user_resp_groups.responsibility_id%type default null,

219: RETURN 0;
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

Line 279: function GetDefaultStatusResponsibility(p_user_id fnd_user.user_id%type) return number IS

275: RETURN l_return_val;
276: end GetProfileAt;
277:
278:
279: function GetDefaultStatusResponsibility(p_user_id fnd_user.user_id%type) return number IS
280: BEGIN
281: -- commented for bug 3255962
282: -- IF v_CurrentUser <> nvl(ASG_BASE.get_user_name, csm_util_pkg.get_user_name(p_user_id)) THEN
283: -- v_CurrentUser := nvl(ASG_BASE.get_user_name, csm_util_pkg.get_user_name(p_user_id));

Line 291: Function get_change_completed_tasks (p_user_id in fnd_user.user_id%type,

287: -- END IF;
288: return v_DefaultStatusResponsibility;
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;

Line 292: p_responsibility_id fnd_user_resp_groups.responsibility_id%type default null,

288: return v_DefaultStatusResponsibility;
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:

Line 319: Function show_new_mail_only(p_user_id in fnd_user.user_id%type,

315: return value_specific('CSF_M_CHANGE_COMPLETED_TASKS', p_user_id,
316: p_responsibility_id, p_application_id);
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;

Line 320: p_responsibility_id fnd_user_resp_groups.responsibility_id%type default null,

316: p_responsibility_id, p_application_id);
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:

Line 348: Function get_task_history_days(p_user_id in fnd_user.user_id%type,

344: p_responsibility_id, p_application_id);
345: end show_new_mail_only;
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;

Line 349: p_responsibility_id fnd_user_resp_groups.responsibility_id%type default null,

345: end show_new_mail_only;
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:

Line 366: Function get_max_attachment_size(p_user_id fnd_user.user_id%type,

362: WHEN OTHERS THEN
363: RETURN 0;
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

Line 367: p_responsibility_id fnd_user_resp_groups.responsibility_id%type default null,

363: RETURN 0;
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

Line 396: FUNCTION get_max_ib_at_location(p_user_id fnd_user.user_id%TYPE,

392: return value_specific('CSM_MAX_ATTACHMENT_SIZE', p_user_id,
393: p_responsibility_id, p_application_id);
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

Line 397: p_responsibility_id fnd_user_resp_groups.responsibility_id%TYPE DEFAULT NULL,

393: p_responsibility_id, p_application_id);
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

Line 431: FUNCTION get_max_readings_per_counter(p_user_id fnd_user.user_id%TYPE,

427: WHEN OTHERS THEN
428: RETURN 0;
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

Line 432: p_responsibility_id fnd_user_resp_groups.responsibility_id%TYPE DEFAULT NULL,

428: RETURN 0;
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

Line 468: FUNCTION Get_Route_Data_To_Owner(p_user_id fnd_user.user_id%TYPE DEFAULT NULL,

464: WHEN OTHERS THEN
465: RETURN 0;
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

Line 469: p_responsibility_id fnd_user_resp_groups.responsibility_id%TYPE DEFAULT NULL,

465: RETURN 0;
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

Line 491: FUNCTION Get_Mobile_Query_Schema( p_responsibility_id fnd_user_resp_groups.responsibility_id%TYPE DEFAULT NULL

487: --This function is used by Mobile Query and should not be used by others.
488: --The function gets the profile value for csm mobile query schema directly from the base table
489: --without using FND API
490:
491: FUNCTION Get_Mobile_Query_Schema( p_responsibility_id fnd_user_resp_groups.responsibility_id%TYPE DEFAULT NULL
492: )
493: RETURN VARCHAR2
494: IS
495: l_profile_option_value VARCHAR2(255) := NULL;

Line 538: FUNCTION Get_download_inventory_flag(p_user_id fnd_user.user_id%TYPE DEFAULT NULL,

534: WHEN OTHERS THEN
535: RETURN NULL;
536: END Get_Mobile_Query_Schema;
537:
538: FUNCTION Get_download_inventory_flag(p_user_id fnd_user.user_id%TYPE DEFAULT NULL,
539: p_responsibility_id fnd_user_resp_groups.responsibility_id%TYPE DEFAULT NULL,
540: p_application_id fnd_application.application_id%TYPE DEFAULT NULL
541: )
542: RETURN VARCHAR2

Line 539: p_responsibility_id fnd_user_resp_groups.responsibility_id%TYPE DEFAULT NULL,

535: RETURN NULL;
536: END Get_Mobile_Query_Schema;
537:
538: FUNCTION Get_download_inventory_flag(p_user_id fnd_user.user_id%TYPE DEFAULT NULL,
539: p_responsibility_id fnd_user_resp_groups.responsibility_id%TYPE DEFAULT NULL,
540: p_application_id fnd_application.application_id%TYPE DEFAULT NULL
541: )
542: RETURN VARCHAR2
543: IS