APPS.MSC_CL_SCE_COLLECTION dependencies on MSC_COMPANY_USERS

Line 2177: LOG_MESSAGE('Error while pulling msc_company_users data from '||p_instance_id||' (sr_instance_id)');

2173: -- Collect the records
2174: BEGIN
2175: EXECUTE IMMEDIATE v_sql_stmt USING p_instance_id, p_user_company_mode;
2176: EXCEPTION WHEN OTHERS THEN
2177: LOG_MESSAGE('Error while pulling msc_company_users data from '||p_instance_id||' (sr_instance_id)');
2178: LOG_MESSAGE(SQLERRM);
2179: p_return_status := FALSE;
2180: END;
2181:

Line 2248: from msc_company_users mcu

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
2249: where mcu.user_id = fu.user_id
2250: and nvl(mcu.sr_instance_id, -999) <> mscu.sr_instance_id
2251: );
2252:

Line 2270: from msc_company_users mcu

2266: and mscu.sr_company_id = mcil.sr_company_id
2267: and mscu.sr_instance_id = mcil.sr_instance_id
2268: and mscu.partner_type = mcil.partner_type
2269: and not exists (select '1'
2270: from msc_company_users mcu
2271: where mcu.user_id = fu.user_id
2272: and nvl(mcu.sr_instance_id, -999) <> mscu.sr_instance_id
2273: )
2274: -- ==========================================================

Line 2287: from msc_company_users mcu,

2283: fu.end_date end_date,
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:

Line 2306: from msc_company_users mcu

2302: and mscu.sr_instance_id = mcil.sr_instance_id
2303: and mscu.partner_type = mcil.partner_type
2304: and mscu.sr_company_id <>-1
2305: and not exists (select '1'
2306: from msc_company_users mcu
2307: where mcu.user_id = fu.user_id
2308: and nvl(mcu.sr_instance_id, -999) <> mscu.sr_instance_id
2309: )
2310:

Line 2321: from msc_company_users mcu

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
2322: where mcu.user_id = fu.user_id
2323: and nvl(mcu.sr_instance_id, -999) <> mscu.sr_instance_id
2324: )
2325:

Line 2331: from msc_company_users mcu

2327: MINUS
2328: select mcu.user_id,
2329: mcu.sr_instance_id,
2330: mcu.company_id
2331: from msc_company_users mcu
2332: where sr_instance_id = p_sr_instance_id;
2333:
2334:
2335: a_user_name users;

Line 2458: UPDATE msc_company_users mcu

2454:
2455: IF a_user_id.COUNT > 0 THEN
2456: BEGIN
2457: FORALL i in 1..a_user_id.COUNT
2458: UPDATE msc_company_users mcu
2459: set
2460: company_id = a_company_id(i)
2461: where mcu.user_id = a_user_id(i)
2462: and mcu.sr_instance_id = a_instance_id(i);

Line 2465: LOG_MESSAGE('Error while updating msc_company_users');

2461: where mcu.user_id = a_user_id(i)
2462: and mcu.sr_instance_id = a_instance_id(i);
2463:
2464: EXCEPTION WHEN OTHERS THEN
2465: LOG_MESSAGE('Error while updating msc_company_users');
2466: LOG_MESSAGE(SQLERRM);
2467: RAISE;
2468: END;
2469: END IF;

Line 2495: INSERT INTO MSC_COMPANY_USERS

2491: IF a_ins_count.COUNT > 0 THEN
2492: BEGIN
2493:
2494: FORALL i in 1..a_ins_count.COUNT
2495: INSERT INTO MSC_COMPANY_USERS
2496: ( USER_ID,
2497: COMPANY_ID,
2498: SR_INSTANCE_ID
2499: )

Line 2507: LOG_MESSAGE('Error while inserting records in msc_company_users');

2503: a_ins_instance_id(i)
2504: );
2505:
2506: EXCEPTION WHEN OTHERS THEN
2507: LOG_MESSAGE('Error while inserting records in msc_company_users');
2508: LOG_MESSAGE(SQLERRM);
2509: RAISE;
2510: END;
2511: END IF;