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 187: ' from msc_trading_partners mtp '||

183: -- ======================================================================================
184:
185: lv_sql_stmt:= ' delete msc_trading_partner_maps mtpm '||
186: ' where exists (select 1 '||
187: ' from msc_trading_partners mtp '||
188: ' where mtp.partner_type = 3'||
189: ' and mtp.sr_instance_id = :v_sr_instance_id'||
190: ' and mtp.partner_id = mtpm.tp_key '||
191: ' )'||

Line 232: ' from msc_trading_partners mtp '||

228: -- ======================================================================================
229:
230: lv_sql_stmt:= ' delete msc_trading_partner_maps mtpm '||
231: ' where exists (select 1 '||
232: ' from msc_trading_partners mtp '||
233: ' where mtp.partner_type = 3'||
234: ' and mtp.sr_instance_id = :v_sr_instance_id'||
235: ' and mtp.partner_id = mtpm.tp_key '||
236: ' )'||

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

717: UNION
718:
719: -- Add Sites from msc_st_trading_partner_sites for CUSTOMERS
720: -- This step is required because for Oracle ERP data there won't be
721: -- any record in msc_trading_partners for Supplier and Customer Sites.
722:
723: select mcil.company_id company_id,
724: mstp.LOCATION company_site_name
725: from msc_st_trading_partner_sites mstp,

Line 1673: from msc_trading_partners mtp,

1669: -- ==== Cursor for 'Trading Partner' maps
1670: cursor newTpMap is
1671: select DISTINCT mtp.partner_id,
1672: mcr.relationship_id
1673: from msc_trading_partners mtp,
1674: msc_tp_id_lid mtil,
1675: msc_company_id_lid mcil,
1676: msc_company_relationships mcr
1677: where mtp.partner_id = mtil.tp_id

Line 1715: msc_trading_partners mtp

1711: select DISTINCT mtp.partner_id,
1712: mcs.company_site_id
1713: from msc_company_sites mcs,
1714: msc_company_site_id_lid mcsil,
1715: msc_trading_partners mtp
1716: where mcs.company_site_id = mcsil.company_site_id
1717: -- Process for the current instance only
1718: and mcsil.sr_instance_id = p_instance_id
1719: -- Join for Organization