eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_CL_SCE_COLLECTION dependencies on MSC_COMPANIES

Line 12: from msc_companies mc;

8: where sr_instance_id = p_sr_instance_id
9: and company_name is not null
10: MINUS
11: SELECT mc.company_name
12: from msc_companies mc;
13:
14: names companyNames;
15: v_my_company msc_companies.company_name%TYPE;
16: v_sr_instance_id NUMBER;

Line 15: v_my_company msc_companies.company_name%TYPE;

11: SELECT mc.company_name
12: from msc_companies mc;
13:
14: names companyNames;
15: v_my_company msc_companies.company_name%TYPE;
16: v_sr_instance_id NUMBER;
17: lv_sql_stmt VARCHAR2(2048);
18: lv_sql_stmt1 VARCHAR2(2048);
19:

Line 30: v_my_company_old_name msc_companies.company_name%TYPE;

26: G_MSC_CONFIGURATION VARCHAR2(20) := nvl(fnd_profile.value('MSC_X_CONFIGURATION'), G_CONF_APS);
27:
28: PROCEDURE PROCESS_COMPANY_CHANGE(p_status OUT NOCOPY NUMBER) IS
29:
30: v_my_company_old_name msc_companies.company_name%TYPE;
31: v_my_company_new_name msc_companies.company_name%TYPE;
32:
33: BEGIN
34: -- ========== Get My company's old Name ============

Line 31: v_my_company_new_name msc_companies.company_name%TYPE;

27:
28: PROCEDURE PROCESS_COMPANY_CHANGE(p_status OUT NOCOPY NUMBER) IS
29:
30: v_my_company_old_name msc_companies.company_name%TYPE;
31: v_my_company_new_name msc_companies.company_name%TYPE;
32:
33: BEGIN
34: -- ========== Get My company's old Name ============
35: v_my_company_old_name := MSC_CL_SCE_COLLECTION.GET_MY_COMPANY;

Line 48: -- ========== Update msc_companies and msc_trading_partners with new name ===

44: v_my_company_new_name := fnd_profile.value('MSC_X_COMPANY_NAME');
45: -- LOG_MESSAGE('The OEM''s Company new name is :'||v_my_company_new_name);
46: --LOG_MESSAGE('The OEM''s Company old name is :'||v_my_company_old_name);
47:
48: -- ========== Update msc_companies and msc_trading_partners with new name ===
49:
50: if v_my_company_new_name <> v_my_company_old_name then
51:
52: -- dbms_output.put_line('In Here');

Line 54: -- ==== Update msc_companies ====

50: if v_my_company_new_name <> v_my_company_old_name then
51:
52: -- dbms_output.put_line('In Here');
53:
54: -- ==== Update msc_companies ====
55: BEGIN
56: update msc_companies
57: set company_name = v_my_company_new_name
58: where company_id = G_OEM_ID;

Line 56: update msc_companies

52: -- dbms_output.put_line('In Here');
53:
54: -- ==== Update msc_companies ====
55: BEGIN
56: update msc_companies
57: set company_name = v_my_company_new_name
58: where company_id = G_OEM_ID;
59:
60: EXCEPTION WHEN OTHERS THEN

Line 61: LOG_MESSAGE('Error while updating Company Name in msc_companies');

57: set company_name = v_my_company_new_name
58: where company_id = G_OEM_ID;
59:
60: EXCEPTION WHEN OTHERS THEN
61: LOG_MESSAGE('Error while updating Company Name in msc_companies');
62: ROLLBACK;
63: p_status := MSC_CL_COLLECTION.G_ERROR;
64: END;
65:

Line 273: -- msc_companies.

269: COMMIT;
270:
271: -- Collect Company Information
272: -- This step is commented out since we do not require any Company attributes in
273: -- msc_companies.
274:
275: -- LOG_MESSAGE('Collecting Companies');
276: -- COLLECT_COMPANIES;
277:

Line 321: p_my_company msc_companies.company_name%TYPE;

317:
318: END LOG_MESSAGE;
319:
320: FUNCTION GET_MY_COMPANY return VARCHAR2 IS
321: p_my_company msc_companies.company_name%TYPE;
322: BEGIN
323:
324: /* Get the name of the own Company */
325: /* This name is seeded with company_is = 1 in msc_companies */

Line 325: /* This name is seeded with company_is = 1 in msc_companies */

321: p_my_company msc_companies.company_name%TYPE;
322: BEGIN
323:
324: /* Get the name of the own Company */
325: /* This name is seeded with company_is = 1 in msc_companies */
326: BEGIN
327: select company_name into p_my_company
328: from msc_companies
329: where company_id = 1;

Line 328: from msc_companies

324: /* Get the name of the own Company */
325: /* This name is seeded with company_is = 1 in msc_companies */
326: BEGIN
327: select company_name into p_my_company
328: from msc_companies
329: where company_id = 1;
330: EXCEPTION
331: WHEN OTHERS THEN
332: return 'My Company';

Line 414: /* Bulk insert the new Companies in msc_companies */

410: close newCompCursor;
411:
412: -- LOG_MESSAGE('Bulk Collected new Company names');
413:
414: /* Bulk insert the new Companies in msc_companies */
415: /* Do this step only if there is data fetched for insert */
416:
417: if names.LAST > 0 then
418: BEGIN

Line 420: insert into msc_companies

416:
417: if names.LAST > 0 then
418: BEGIN
419: FORALL i IN names.FIRST..names.LAST
420: insert into msc_companies
421: (COMPANY_ID ,
422: COMPANY_NAME ,
423: CREATION_DATE ,
424: CREATED_BY ,

Line 430: ( msc_companies_s.nextval,

426: LAST_UPDATED_BY ,
427: LAST_UPDATE_LOGIN
428: )
429: values
430: ( msc_companies_s.nextval,
431: names(i),
432: p_current_date,
433: p_current_user,
434: p_current_date,

Line 444: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPANIES');

440: LOG_MESSAGE('Error while creating new companies');
441: LOG_MESSAGE('========================================');
442: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_NEW_COMP_ERR');
443: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CREATE_NEW_COMPANIES');
444: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPANIES');
445: LOG_MESSAGE(FND_MESSAGE.GET);
446:
447: LOG_MESSAGE(SQLERRM);
448: END;

Line 451: msc_analyse_tables_pk.analyse_table( 'MSC_COMPANIES');

447: LOG_MESSAGE(SQLERRM);
448: END;
449: COMMIT;
450: --Bug 5155944: Analysing the table to improve performance
451: msc_analyse_tables_pk.analyse_table( 'MSC_COMPANIES');
452: END IF;
453:
454: END CREATE_NEW_COMPANIES;
455:

Line 468: msc_companies mc

464: G_CUSTOMER, G_SUPPLIER,
465: mst.partner_type) partner_type,
466: mc.company_id company_id
467: from msc_st_trading_partners mst,
468: msc_companies mc
469: where nvl(mst.company_name, v_my_company) = mc.company_name
470: and mst.sr_instance_id = v_sr_instance_id
471: MINUS
472: select mcil.sr_instance_id,

Line 547: msc_companies mc1,

543: select mc1.company_id subject_id,
544: mc2.company_id object_id,
545: mst.partner_type relationship_type
546: from msc_st_trading_partners mst,
547: msc_companies mc1,
548: msc_companies mc2
549: where nvl(mst.company_name, v_my_company) = mc2.company_name
550: and nvl(mst.partner_name, v_my_company) = mc1.company_name
551: and mst.sr_instance_id = v_sr_instance_id

Line 548: msc_companies mc2

544: mc2.company_id object_id,
545: mst.partner_type relationship_type
546: from msc_st_trading_partners mst,
547: msc_companies mc1,
548: msc_companies mc2
549: where nvl(mst.company_name, v_my_company) = mc2.company_name
550: and nvl(mst.partner_name, v_my_company) = mc1.company_name
551: and mst.sr_instance_id = v_sr_instance_id
552: -- Do not include Inventory Organizations in relationship records.

Line 629: msc_companies mc

625: CURSOR newCompSites IS
626: Select mc.company_id company_id,
627: mst.organization_code company_site_name
628: from msc_st_trading_partners mst,
629: msc_companies mc
630: where nvl(mst.company_name, v_my_company) = mc.company_name
631: and mst.sr_instance_id = v_sr_instance_id
632: and mst.partner_type = 3
633: