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 294: -- msc_companies.

290: COMMIT;
291:
292: -- Collect Company Information
293: -- This step is commented out since we do not require any Company attributes in
294: -- msc_companies.
295:
296: -- LOG_MESSAGE('Collecting Companies');
297: -- COLLECT_COMPANIES;
298:

Line 342: p_my_company msc_companies.company_name%TYPE;

338:
339: END LOG_MESSAGE;
340:
341: FUNCTION GET_MY_COMPANY return VARCHAR2 IS
342: p_my_company msc_companies.company_name%TYPE;
343: BEGIN
344:
345: /* Get the name of the own Company */
346: /* This name is seeded with company_is = 1 in msc_companies */

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

342: p_my_company msc_companies.company_name%TYPE;
343: BEGIN
344:
345: /* Get the name of the own Company */
346: /* This name is seeded with company_is = 1 in msc_companies */
347: BEGIN
348: select company_name into p_my_company
349: from msc_companies
350: where company_id = 1;

Line 349: from msc_companies

345: /* Get the name of the own Company */
346: /* This name is seeded with company_is = 1 in msc_companies */
347: BEGIN
348: select company_name into p_my_company
349: from msc_companies
350: where company_id = 1;
351: EXCEPTION
352: WHEN OTHERS THEN
353: return 'My Company';

Line 370: msc_companies mc

366: CURSOR updateCompanyNames IS
367: SELECT mc.company_id, mtps.company_name
368: FROM msc_st_trading_partners mtps,
369: msc_company_id_lid mcil,
370: msc_companies mc
371: WHERE mtps.sr_instance_id = v_sr_instance_id
372: AND mcil.sr_instance_id = mtps.sr_instance_id
373: AND mcil.partner_type = decode(mtps.partner_type, G_SUPPLIER, G_CUSTOMER, G_CUSTOMER, G_SUPPLIER)
374: AND mcil.sr_company_id = mtps.company_id

Line 395: -- update msc_companies table

391: CLOSE updateCompanyNames;
392:
393:
394: LOG_MESSAGE('No. of company name change records = '||a_company_id.COUNT);
395: -- update msc_companies table
396: -- Perform this step only if some data is fetched
397: IF a_company_id.COUNT > 0 THEN
398: FOR i IN 1..a_company_id.COUNT LOOP
399:

Line 401: UPDATE msc_companies

397: IF a_company_id.COUNT > 0 THEN
398: FOR i IN 1..a_company_id.COUNT LOOP
399:
400: BEGIN
401: UPDATE msc_companies
402: SET company_name = a_company_name(i),
403: last_update_date = p_current_date,
404: last_updated_by = p_current_user,
405: last_update_login = p_current_user

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

493: close newCompCursor;
494:
495: -- LOG_MESSAGE('Bulk Collected new Company names');
496:
497: /* Bulk insert the new Companies in msc_companies */
498: /* Do this step only if there is data fetched for insert */
499:
500: if names.LAST > 0 then
501: BEGIN

Line 503: insert into msc_companies

499:
500: if names.LAST > 0 then
501: BEGIN
502: FORALL i IN names.FIRST..names.LAST
503: insert into msc_companies
504: (COMPANY_ID ,
505: COMPANY_NAME ,
506: CREATION_DATE ,
507: CREATED_BY ,

Line 513: ( msc_companies_s.nextval,

509: LAST_UPDATED_BY ,
510: LAST_UPDATE_LOGIN
511: )
512: values
513: ( msc_companies_s.nextval,
514: names(i),
515: p_current_date,
516: p_current_user,
517: p_current_date,

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

523: LOG_MESSAGE('Error while creating new companies');
524: LOG_MESSAGE('========================================');
525: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_NEW_COMP_ERR');
526: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CREATE_NEW_COMPANIES');
527: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPANIES');
528: LOG_MESSAGE(FND_MESSAGE.GET);
529:
530: LOG_MESSAGE(SQLERRM);
531: END;

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

530: LOG_MESSAGE(SQLERRM);
531: END;
532: COMMIT;
533: --Bug 5155944: Analysing the table to improve performance
534: msc_analyse_tables_pk.analyse_table( 'MSC_COMPANIES');
535: END IF;
536:
537: END CREATE_NEW_COMPANIES;
538:

Line 551: msc_companies mc

547: G_CUSTOMER, G_SUPPLIER,
548: mst.partner_type) partner_type,
549: mc.company_id company_id
550: from msc_st_trading_partners mst,
551: msc_companies mc
552: where nvl(mst.company_name, v_my_company) = mc.company_name
553: and mst.sr_instance_id = v_sr_instance_id
554: MINUS
555: select mcil.sr_instance_id,

Line 630: msc_companies mc1,

626: select mc1.company_id subject_id,
627: mc2.company_id object_id,
628: mst.partner_type relationship_type
629: from msc_st_trading_partners mst,
630: msc_companies mc1,
631: msc_companies mc2
632: where nvl(mst.company_name, v_my_company) = mc2.company_name
633: and nvl(mst.partner_name, v_my_company) = mc1.company_name
634: and mst.sr_instance_id = v_sr_instance_id

Line 631: msc_companies mc2

627: mc2.company_id object_id,
628: mst.partner_type relationship_type
629: from msc_st_trading_partners mst,
630: msc_companies mc1,
631: msc_companies mc2
632: where nvl(mst.company_name, v_my_company) = mc2.company_name
633: and nvl(mst.partner_name, v_my_company) = mc1.company_name
634: and mst.sr_instance_id = v_sr_instance_id
635: -- Do not include Inventory Organizations in relationship records.

Line 712: msc_companies mc

708: CURSOR newCompSites IS
709: Select mc.company_id company_id,
710: mst.organization_code company_site_name
711: from msc_st_trading_partners mst,
712: msc_companies mc
713: where nvl(mst.company_name, v_my_company) = mc.company_name
714: and mst.sr_instance_id = v_sr_instance_id
715: and mst.partner_type = 3
716: