DBA Data[Home] [Help]

APPS.MSC_SCN_ACTIVITY_WF dependencies on FND_USER

Line 62: select user_name into l_itemowner from fnd_user where user_id=userId; --WF owner

58: end if;
59:
60: select MSC_FORM_QUERY_S.nextval into l_itemkey from dual;
61:
62: select user_name into l_itemowner from fnd_user where user_id=userId; --WF owner
63:
64: open c_activityinfo(p_activity_id);
65: fetch c_activityinfo into l_activity_name, l_finish_by, l_priority, l_status,
66: l_owner, l_alternate_owner, l_act_comment, l_scenario_name ,l_scenario_set_name;

Line 72: select user_name into l_owner_name from fnd_user where user_id = l_owner;

68:
69: --dbms_output.put_line('p_activity_id='||p_activity_id ||'l_activity_name='||l_activity_name);
70:
71: begin
72: select user_name into l_owner_name from fnd_user where user_id = l_owner;
73: select user_name into l_alt_owner_name from fnd_user where user_id = l_alternate_owner;
74: select meaning into l_status_name from mfg_lookups where lookup_type like 'MSC_SCN_ACTIVITY_STATES' and lookup_code=l_status;
75:
76: exception when others then

Line 73: select user_name into l_alt_owner_name from fnd_user where user_id = l_alternate_owner;

69: --dbms_output.put_line('p_activity_id='||p_activity_id ||'l_activity_name='||l_activity_name);
70:
71: begin
72: select user_name into l_owner_name from fnd_user where user_id = l_owner;
73: select user_name into l_alt_owner_name from fnd_user where user_id = l_alternate_owner;
74: select meaning into l_status_name from mfg_lookups where lookup_type like 'MSC_SCN_ACTIVITY_STATES' and lookup_code=l_status;
75:
76: exception when others then
77: null;