[Home] [Help]
2141: IF ( p_user_company_mode = COMPANY_ONLY OR
2142: p_user_company_mode = USER_AND_COMPANY) THEN
2143:
2144: v_sql_stmt :=
2145: ' insert into msc_st_company_users '
2146: ||' ( user_name ,'
2147: ||' sr_company_id ,'
2148: ||' sr_instance_id ,'
2149: ||' partner_type ,'
2221: description,
2222: email_address,
2223: fax,
2224: user_guid -- Bug#12863892 fp of 9754732
2225: from msc_st_company_users mscu
2226: where mscu.sr_instance_id = p_sr_instance_id
2227: and not exists (select '1'
2228: from fnd_user fu
2229: where fu.user_name = UPPER(mscu.user_name))
2239: --===============================================================================================
2240:
2241: CURSOR invalidUsers IS
2242: select distinct mscu.user_name user_name
2243: from msc_st_company_users mscu,
2244: fnd_user fu
2245: where UPPER(mscu.user_name) = fu.user_name
2246: and mscu.sr_instance_id = p_sr_instance_id
2247: and exists (select '1'
2257: mscu.end_date end_date,
2258: mscu.description description,
2259: mscu.email_address email_address,
2260: mscu.fax fax
2261: from msc_st_company_users mscu,
2262: fnd_user fu,
2263: msc_company_id_lid mcil
2264: where mscu.sr_instance_id = p_sr_instance_id
2265: and UPPER(mscu.user_name) = fu.user_name
2292: CURSOR validUsers IS
2293: select fu.user_id user_id,
2294: mscu.sr_instance_id sr_instance_id,
2295: mcil.company_id company_id
2296: from msc_st_company_users mscu,
2297: fnd_user fu,
2298: msc_company_id_lid mcil
2299: where mscu.sr_instance_id = p_sr_instance_id
2300: and UPPER(mscu.user_name) = fu.user_name
2312:
2313: select fu.user_id user_id,
2314: mscu.sr_instance_id sr_instance_id,
2315: 1 company_id
2316: from msc_st_company_users mscu,
2317: fnd_user fu
2318: where UPPER(mscu.user_name) = fu.user_name
2319: and mscu.sr_company_id = -1
2320: and not exists (select '1'