DBA Data[Home] [Help]

APPS.MSC_CL_SCE_COLLECTION dependencies on FND_USER

Line 2228: from fnd_user fu

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))
2230: -- ================================================================================
2231: -- Pull only if Collection Parameter is set to "Users and User Company Association"
2232: -- ================================================================================

Line 2244: fnd_user fu

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'
2248: from msc_company_users mcu

Line 2262: fnd_user fu,

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
2266: and mscu.sr_company_id = mcil.sr_company_id

Line 2288: fnd_user fu

2284: fu.description description,
2285: fu.email_address email_address,
2286: fu.fax fax
2287: from msc_company_users mcu,
2288: fnd_user fu
2289: where mcu.user_id = fu.user_id
2290: and mcu.sr_instance_id = p_sr_instance_id;
2291:
2292: CURSOR validUsers IS

Line 2297: fnd_user fu,

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
2301: and mscu.sr_company_id = mcil.sr_company_id

Line 2317: fnd_user fu

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'
2321: from msc_company_users mcu

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

2370: --============================================
2371: BEGIN
2372: FOR C1 in newUsers LOOP
2373: Begin
2374: FND_USER_PKG.createUser( x_user_name => C1.user_name,
2375: x_owner => 'CUST',
2376: x_unencrypted_password => 'welcome',
2377: x_start_date => C1.start_date,
2378: x_end_date => C1.end_date,

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

2388: LOG_MESSAGE(SQLERRM);
2389:
2390: c_passwd := build_passwd ;
2391:
2392: FND_USER_PKG.createUser( x_user_name => C1.user_name,
2393: x_owner => 'CUST',
2394: x_unencrypted_password => c_passwd,
2395: x_start_date => C1.start_date,
2396: x_end_date => C1.end_date,

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

2406: -- Once the user is created, assign MSCX_SC_PLANNER responsibility
2407: -- to the user
2408: --==========================================================================
2409:
2410: Fnd_User_Resp_Groups_Api.LOAD_ROW ( x_user_name => C1.user_name,
2411: x_resp_key => 'MSCX_SC_PLANNER',
2412: x_app_short_name => 'MSC',
2413: x_security_group => 'STANDARD',
2414: x_owner => NULL,

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

2426: LOG_MESSAGE(SQLERRM);
2427: ROLLBACK;
2428: RAISE;
2429: WHEN OTHERS THEN
2430: LOG_MESSAGE('ERROR while creating a new user using FND_USER_PKG.createUser API');
2431: LOG_MESSAGE(SQLERRM);
2432: ROLLBACK;
2433: RAISE;
2434: END;

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

2516:
2517: BEGIN
2518:
2519: FOR C1 IN validUsersUpdate LOOP
2520: FND_USER_PKG.UpdateUser( x_user_name => C1.user_name,
2521: x_owner => 'CUST',
2522: x_start_date => C1.start_date,
2523: x_end_date => C1.end_date,
2524: x_description => C1.description,