APPS.MSC_CL_SCE_COLLECTION dependencies on MSC_COMPANY_USERS

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

2088: -- Collect the records
2089: BEGIN
2090: EXECUTE IMMEDIATE v_sql_stmt USING p_instance_id, p_user_company_mode;
2091: EXCEPTION WHEN OTHERS THEN
2092: LOG_MESSAGE('Error while pulling msc_company_users data from '||p_instance_id||' (sr_instance_id)');
2093: LOG_MESSAGE(SQLERRM);
2094: p_return_status := FALSE;
2095: END;
2096:

Line 2162: from msc_company_users mcu

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
2163: where mcu.user_id = fu.user_id
2164: and nvl(mcu.sr_instance_id, -999) <> mscu.sr_instance_id
2165: );
2166:

Line 2184: from msc_company_users mcu

2180: and mscu.sr_company_id = mcil.sr_company_id
2181: and mscu.sr_instance_id = mcil.sr_instance_id
2182: and mscu.partner_type = mcil.partner_type
2183: and not exists (select '1'
2184: from msc_company_users mcu
2185: where mcu.user_id = fu.user_id
2186: and nvl(mcu.sr_instance_id, -999) <> mscu.sr_instance_id
2187: )
2188: -- ==========================================================

Line 2201: from msc_company_users mcu,

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

Line 2220: from msc_company_users mcu

2216: and mscu.sr_instance_id = mcil.sr_instance_id
2217: and mscu.partner_type = mcil.partner_type
2218: and mscu.sr_company_id <>-1
2219: and not exists (select '1'
2220: from msc_company_users mcu
2221: where mcu.user_id = fu.user_id
2222: and nvl(mcu.sr_instance_id, -999) <> mscu.sr_instance_id
2223: )
2224:

Line 2235: from msc_company_users mcu

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
2236: where mcu.user_id = fu.user_id
2237: and nvl(mcu.sr_instance_id, -999) <> mscu.sr_instance_id
2238: )
2239:

Line 2245: from msc_company_users mcu

2241: MINUS
2242: select mcu.user_id,
2243: mcu.sr_instance_id,
2244: mcu.company_id
2245: from msc_company_users mcu
2246: where sr_instance_id = p_sr_instance_id;
2247:
2248:
2249: a_user_name users;

Line 2370: UPDATE msc_company_users mcu

2366:
2367: IF a_user_id.COUNT > 0 THEN
2368: BEGIN
2369: FORALL i in 1..a_user_id.COUNT
2370: UPDATE msc_company_users mcu
2371: set
2372: company_id = a_company_id(i)
2373: where mcu.user_id = a_user_id(i)
2374: and mcu.sr_instance_id = a_instance_id(i);

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

2373: where mcu.user_id = a_user_id(i)
2374: and mcu.sr_instance_id = a_instance_id(i);
2375:
2376: EXCEPTION WHEN OTHERS THEN
2377: LOG_MESSAGE('Error while updating msc_company_users');
2378: LOG_MESSAGE(SQLERRM);
2379: RAISE;
2380: END;
2381: END IF;

Line 2407: INSERT INTO MSC_COMPANY_USERS

2403: IF a_ins_count.COUNT > 0 THEN
2404: BEGIN
2405:
2406: FORALL i in 1..a_ins_count.COUNT
2407: INSERT INTO MSC_COMPANY_USERS
2408: ( USER_ID,
2409: COMPANY_ID,
2410: SR_INSTANCE_ID
2411: )

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

2415: a_ins_instance_id(i)
2416: );
2417:
2418: EXCEPTION WHEN OTHERS THEN
2419: LOG_MESSAGE('Error while inserting records in msc_company_users');
2420: LOG_MESSAGE(SQLERRM);
2421: RAISE;
2422: END;
2423: END IF;