APPS.MSC_CL_SCE_COLLECTION dependencies on MSC_TRADING_PARTNERS

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 67: -- Update msc_trading_partners.

63: p_status := MSC_CL_COLLECTION.G_ERROR;
64: END;
65:
66: -- =======================================
67: -- Update msc_trading_partners.
68: -- Update all records where
69: -- sr_company_id = -1 (This indicates OEM)
70: -- and partner_name = v_my_company_old_name
71: -- ========================================

Line 73: update msc_trading_partners

69: -- sr_company_id = -1 (This indicates OEM)
70: -- and partner_name = v_my_company_old_name
71: -- ========================================
72: BEGIN
73: update msc_trading_partners
74: set partner_name = v_my_company_new_name
75: where
76: partner_name = v_my_company_old_name
77: and partner_type in (G_SUPPLIER, G_CUSTOMER)

Line 81: LOG_MESSAGE('Error while updating Company Name in msc_trading_partners');

77: and partner_type in (G_SUPPLIER, G_CUSTOMER)
78: and sr_tp_id = -1
79: and nvl(company_id, 1) <> 1;
80: EXCEPTION WHEN OTHERS THEN
81: LOG_MESSAGE('Error while updating Company Name in msc_trading_partners');
82: ROLLBACK;
83: p_status := MSC_CL_COLLECTION.G_ERROR;
84: END;
85: end if;

Line 166: ' from msc_trading_partners mtp '||

162: -- ======================================================================================
163:
164: lv_sql_stmt:= ' delete msc_trading_partner_maps mtpm '||
165: ' where exists (select 1 '||
166: ' from msc_trading_partners mtp '||
167: ' where mtp.partner_type = 3'||
168: ' and mtp.sr_instance_id = :v_sr_instance_id'||
169: ' and mtp.partner_id = mtpm.tp_key '||
170: ' )'||

Line 211: ' from msc_trading_partners mtp '||

207: -- ======================================================================================
208:
209: lv_sql_stmt:= ' delete msc_trading_partner_maps mtpm '||
210: ' where exists (select 1 '||
211: ' from msc_trading_partners mtp '||
212: ' where mtp.partner_type = 3'||
213: ' and mtp.sr_instance_id = :v_sr_instance_id'||
214: ' and mtp.partner_id = mtpm.tp_key '||
215: ' )'||

Line 638: -- any record in msc_trading_partners for Supplier and Customer Sites.

634: UNION
635:
636: -- Add Sites from msc_st_trading_partner_sites for CUSTOMERS
637: -- This step is required because for Oracle ERP data there won't be
638: -- any record in msc_trading_partners for Supplier and Customer Sites.
639:
640: select mcil.company_id company_id,
641: mstp.LOCATION company_site_name
642: from msc_st_trading_partner_sites mstp,

Line 1590: from msc_trading_partners mtp,

1586: -- ==== Cursor for 'Trading Partner' maps
1587: cursor newTpMap is
1588: select DISTINCT mtp.partner_id,
1589: mcr.relationship_id
1590: from msc_trading_partners mtp,
1591: msc_tp_id_lid mtil,
1592: msc_company_id_lid mcil,
1593: msc_company_relationships mcr
1594: where mtp.partner_id = mtil.tp_id

Line 1632: msc_trading_partners mtp

1628: select DISTINCT mtp.partner_id,
1629: mcs.company_site_id
1630: from msc_company_sites mcs,
1631: msc_company_site_id_lid mcsil,
1632: msc_trading_partners mtp
1633: where mcs.company_site_id = mcsil.company_site_id
1634: -- Process for the current instance only
1635: and mcsil.sr_instance_id = p_instance_id
1636: -- Join for Organization