DBA Data[Home] [Help]

APPS.JTF_DIAGNOSTIC_COREAPI dependencies on FND_USER

Line 1954: || ' , FND_USER d'

1950: || ' , nvl(d.user_name,to_char(c.last_updated_by)) "Updated
By"'
1951: || ' from fnd_profile_options a'
1952: || ' , FND_PROFILE_OPTIONS_TL b'
1953: || ' , FND_PROFILE_OPTION_VALUES c'
1954: || ' , FND_USER d'
1955: || ' , FND_USER e'
1956: || ' , FND_RESPONSIBILITY_TL g'
1957: || ' , FND_APPLICATION h'
1958: || ' where a.application_id = nvl(' || nvl(p_application_id,'null')

Line 1955: || ' , FND_USER e'

1951: || ' from fnd_profile_options a'
1952: || ' , FND_PROFILE_OPTIONS_TL b'
1953: || ' , FND_PROFILE_OPTION_VALUES c'
1954: || ' , FND_USER d'
1955: || ' , FND_USER e'
1956: || ' , FND_RESPONSIBILITY_TL g'
1957: || ' , FND_APPLICATION h'
1958: || ' where a.application_id = nvl(' || nvl(p_application_id,'null')
1959: || ' , a.application_id)'

Line 2054: l_user_name fnd_user.user_name%type;

2050: procedure Set_Client_html(p_user_name varchar2, p_resp_id number,
2051: p_app_id number, p_sec_grp_id number) is
2052: l_cursor integer;
2053: l_num_rows integer;
2054: l_user_name fnd_user.user_name%type;
2055: l_user_id number;
2056: l_app_id number;
2057: l_counter integer;
2058: l_appl_vers fnd_product_groups.release_name%type;

Line 2068: from fnd_user where user_name = l_user_name;

2064: begin
2065: l_user_name := upper(p_user_name);
2066: begin
2067: select user_id into l_user_id
2068: from fnd_user where user_name = l_user_name;
2069: exception
2070: when others then
2071: raise inv_user;
2072: end;

Line 2076: 'from fnd_user_responsibility rg '||

2072: end;
2073: l_appl_vers := get_db_apps_version; -- sets g_appl_version
2074: if g_appl_version = '11.0' or g_appl_version = '10.7' then
2075: sqltxt := 'select rg.application_id '||
2076: 'from fnd_user_responsibility rg '||
2077: 'where rg.responsibility_id = '||to_char(p_resp_id)||' '||
2078: 'and rg.user_id = '||to_char(l_user_id);
2079: elsif g_appl_version = '11.5' then
2080: sqltxt := 'select rg.responsibility_application_id '||

Line 2081: 'from fnd_user_resp_groups rg '||

2077: 'where rg.responsibility_id = '||to_char(p_resp_id)||' '||
2078: 'and rg.user_id = '||to_char(l_user_id);
2079: elsif g_appl_version = '11.5' then
2080: sqltxt := 'select rg.responsibility_application_id '||
2081: 'from fnd_user_resp_groups rg '||
2082: 'where rg.responsibility_id = '||to_char(p_resp_id)||' '||
2083: 'and rg.user_id = '||to_char(l_user_id);
2084: end if;
2085: begin

Line 4064: fnd_user u

4060: fnd_profile_options o,
4061: fnd_profile_options_tl ot,
4062: fnd_application_tl a,
4063: fnd_responsibility_tl r,
4064: fnd_user u
4065: where o.application_id = nvl(p_application_id, o.application_id)
4066: and o.profile_option_name = nvl(p_short_name, o.profile_option_name)
4067: and v.LEVEL_VALUE =
4068: decode(level_id, 10004, u.user_id, 10003, r.responsibility_id,

Line 4106: fnd_user u

4102: fnd_profile_options o,
4103: fnd_profile_options_tl ot,
4104: fnd_application_tl a,
4105: fnd_responsibility_tl r,
4106: fnd_user u
4107: where o.application_id = nvl(p_application_id, o.application_id)
4108: and o.profile_option_name = nvl(p_short_name, o.profile_option_name)
4109: and v.LEVEL_VALUE =
4110: decode(level_id, 10004, u.user_id, 10003, r.responsibility_id,

Line 4221: l_user_name fnd_user.user_name%type;

4217: procedure Set_Client_text(p_user_name varchar2, p_resp_id number,
4218: p_app_id number, p_sec_grp_id number) is
4219: l_cursor integer;
4220: l_num_rows integer;
4221: l_user_name fnd_user.user_name%type;
4222: l_user_id number;
4223: l_app_id number;
4224: l_counter integer;
4225: l_appl_vers fnd_product_groups.release_name%type;

Line 4235: from fnd_user where user_name = l_user_name;

4231: begin
4232: l_user_name := upper(p_user_name);
4233: begin
4234: select user_id into l_user_id
4235: from fnd_user where user_name = l_user_name;
4236: exception
4237: when others then
4238: raise inv_user;
4239: end;

Line 4243: 'from fnd_user_responsibility rg '||

4239: end;
4240: l_appl_vers := get_db_apps_version; -- sets g_appl_version
4241: if g_appl_version = '11.0' or g_appl_version = '10.7' then
4242: sqltxt := 'select rg.application_id '||
4243: 'from fnd_user_responsibility rg '||
4244: 'where rg.responsibility_id = '||to_char(p_resp_id)||' '||
4245: 'and rg.user_id = '||to_char(l_user_id);
4246: elsif g_appl_version = '11.5' then
4247: sqltxt := 'select rg.responsibility_application_id '||

Line 4248: 'from fnd_user_resp_groups rg '||

4244: 'where rg.responsibility_id = '||to_char(p_resp_id)||' '||
4245: 'and rg.user_id = '||to_char(l_user_id);
4246: elsif g_appl_version = '11.5' then
4247: sqltxt := 'select rg.responsibility_application_id '||
4248: 'from fnd_user_resp_groups rg '||
4249: 'where rg.responsibility_id = '||to_char(p_resp_id)||' '||
4250: 'and rg.user_id = '||to_char(l_user_id);
4251: end if;
4252: begin