APPS.MSC_CL_SCE_COLLECTION dependencies on FND_USER

Line 2142: from fnd_user fu

2138: fax
2139: from msc_st_company_users mscu
2140: where mscu.sr_instance_id = p_sr_instance_id
2141: and not exists (select '1'
2142: from fnd_user fu
2143: where fu.user_name = UPPER(mscu.user_name))
2144: -- ================================================================================
2145: -- Pull only if Collection Parameter is set to "Users and User Company Association"
2146: -- ================================================================================

Line 2158: fnd_user fu

2154:
2155: CURSOR invalidUsers IS
2156: select distinct mscu.user_name user_name
2157: from msc_st_company_users mscu,
2158: fnd_user fu
2159: where UPPER(mscu.user_name) = fu.user_name
2160: and mscu.sr_instance_id = p_sr_instance_id
2161: and exists (select '1'
2162: from msc_company_users mcu

Line 2176: fnd_user fu,

2172: mscu.description description,
2173: mscu.email_address email_address,
2174: mscu.fax fax
2175: from msc_st_company_users mscu,
2176: fnd_user fu,
2177: msc_company_id_lid mcil
2178: where mscu.sr_instance_id = p_sr_instance_id
2179: and UPPER(mscu.user_name) = fu.user_name
2180: and mscu.sr_company_id = mcil.sr_company_id

Line 2202: fnd_user fu

2198: fu.description description,
2199: fu.email_address email_address,
2200: fu.fax fax
2201: from msc_company_users mcu,
2202: fnd_user fu
2203: where mcu.user_id = fu.user_id
2204: and mcu.sr_instance_id = p_sr_instance_id;
2205:
2206: CURSOR validUsers IS

Line 2211: fnd_user fu,

2207: select fu.user_id user_id,
2208: mscu.sr_instance_id sr_instance_id,
2209: mcil.company_id company_id
2210: from msc_st_company_users mscu,
2211: fnd_user fu,
2212: msc_company_id_lid mcil
2213: where mscu.sr_instance_id = p_sr_instance_id
2214: and UPPER(mscu.user_name) = fu.user_name
2215: and mscu.sr_company_id = mcil.sr_company_id

Line 2231: fnd_user fu

2227: select fu.user_id user_id,
2228: mscu.sr_instance_id sr_instance_id,
2229: 1 company_id
2230: from msc_st_company_users mscu,
2231: fnd_user fu
2232: where UPPER(mscu.user_name) = fu.user_name
2233: and mscu.sr_company_id = -1
2234: and not exists (select '1'
2235: from msc_company_users mcu

Line 2288: FND_USER_PKG.createUser( x_user_name => C1.user_name,

2284: --============================================
2285: BEGIN
2286: FOR C1 in newUsers LOOP
2287: Begin
2288: FND_USER_PKG.createUser( x_user_name => C1.user_name,
2289: x_owner => 'CUST',
2290: x_unencrypted_password => 'welcome',
2291: x_start_date => C1.start_date,
2292: x_end_date => C1.end_date,

Line 2305: FND_USER_PKG.createUser( x_user_name => C1.user_name,

2301: LOG_MESSAGE(SQLERRM);
2302:
2303: c_passwd := build_passwd ;
2304:
2305: FND_USER_PKG.createUser( x_user_name => C1.user_name,
2306: x_owner => 'CUST',
2307: x_unencrypted_password => c_passwd,
2308: x_start_date => C1.start_date,
2309: x_end_date => C1.end_date,

Line 2322: Fnd_User_Resp_Groups_Api.LOAD_ROW ( x_user_name => C1.user_name,

2318: -- Once the user is created, assign MSCX_SC_PLANNER responsibility
2319: -- to the user
2320: --==========================================================================
2321:
2322: Fnd_User_Resp_Groups_Api.LOAD_ROW ( x_user_name => C1.user_name,
2323: x_resp_key => 'MSCX_SC_PLANNER',
2324: x_app_short_name => 'MSC',
2325: x_security_group => 'STANDARD',
2326: x_owner => NULL,

Line 2342: LOG_MESSAGE('ERROR while creating a new user using FND_USER_PKG.createUser API');

2338: LOG_MESSAGE(SQLERRM);
2339: ROLLBACK;
2340: RAISE;
2341: WHEN OTHERS THEN
2342: LOG_MESSAGE('ERROR while creating a new user using FND_USER_PKG.createUser API');
2343: LOG_MESSAGE(SQLERRM);
2344: ROLLBACK;
2345: RAISE;
2346: END;

Line 2432: FND_USER_PKG.UpdateUser( x_user_name => C1.user_name,

2428:
2429: BEGIN
2430:
2431: FOR C1 IN validUsersUpdate LOOP
2432: FND_USER_PKG.UpdateUser( x_user_name => C1.user_name,
2433: x_owner => 'CUST',
2434: x_start_date => C1.start_date,
2435: x_end_date => C1.end_date,
2436: x_description => C1.description,