DBA Data[Home] [Help]

APPS.CSM_PROFILE_PKG dependencies on FND_USER

Line 19: p_user_id fnd_user.user_id%type,

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;

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

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:

Line 25: Function get_master_organization_id(p_user_id fnd_user.user_id%type,

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;

Line 26: p_responsibility_id fnd_user_resp_groups.responsibility_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:

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

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:

Line 32: p_responsibility_id fnd_user_resp_groups.responsibility_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,

Line 36: Function get_organization_id(p_user_id 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;

Line 37: 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:

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

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;

Line 43: p_responsibility_id fnd_user_resp_groups.responsibility_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:

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

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;

Line 49: p_responsibility_id fnd_user_resp_groups.responsibility_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:

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

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;

Line 55: p_responsibility_id fnd_user_resp_groups.responsibility_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:

Line 60: Function get_org_id(p_user_id fnd_user.user_id%type,

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;

Line 61: p_responsibility_id fnd_user_resp_groups.responsibility_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:

Line 66: Function GetDefaultStatusResponsibility( p_user_id fnd_user.user_id%type) return number;

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

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

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;

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

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:

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

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;

Line 75: p_responsibility_id fnd_user_resp_groups.responsibility_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:

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

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;

Line 81: p_responsibility_id fnd_user_resp_groups.responsibility_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:

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

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;

Line 87: p_responsibility_id fnd_user_resp_groups.responsibility_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:

Line 92: Function get_max_ib_at_location(p_user_id fnd_user.user_id%type,

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;

Line 93: p_responsibility_id fnd_user_resp_groups.responsibility_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:

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

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;

Line 99: p_responsibility_id fnd_user_resp_groups.responsibility_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:

Line 104: FUNCTION Get_Route_Data_To_Owner(p_user_id fnd_user.user_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;

Line 105: p_responsibility_id fnd_user_resp_groups.responsibility_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:

Line 110: FUNCTION Get_Mobile_Query_Schema( 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,

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

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;

Line 115: 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: