APPS.MSC_CL_SETUP_ODS_LOAD dependencies on MSC_PARTNER_CONTACTS

Line 2876: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_PARTNER_CONTACTS', MSC_CL_COLLECTION.v_instance_id, NULL);

2872:
2873: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh OR MSC_CL_COLLECTION.v_is_legacy_refresh OR MSC_CL_COLLECTION.v_is_cont_refresh) THEN
2874:
2875: IF NOT MSC_CL_COLLECTION.v_is_legacy_refresh THEN
2876: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_PARTNER_CONTACTS', MSC_CL_COLLECTION.v_instance_id, NULL);
2877: END IF;
2878:
2879: FOR c_rec IN c4 LOOP
2880:

Line 2885: delete from MSC_PARTNER_CONTACTS where

2881: if(MSC_CL_COLLECTION.v_is_legacy_refresh) then
2882:
2883: if (c_rec.DELETED_FLAG =MSC_UTIL.SYS_YES) then
2884:
2885: delete from MSC_PARTNER_CONTACTS where
2886: partner_id=c_rec.PARTNER_ID
2887: and nvl(partner_site_id,-99999)=nvl(c_rec.PARTNER_SITE_ID,-99999)
2888: and partner_type=c_rec.PARTNER_TYPE
2889: and SR_INSTANCE_ID =MSC_CL_COLLECTION.v_instance_id

Line 2892: UPDATE MSC_PARTNER_CONTACTS

2888: and partner_type=c_rec.PARTNER_TYPE
2889: and SR_INSTANCE_ID =MSC_CL_COLLECTION.v_instance_id
2890: and c_rec.DELETED_FLAG =MSC_UTIL.SYS_YES;
2891: else
2892: UPDATE MSC_PARTNER_CONTACTS
2893: set Name=c_rec.NAME,
2894: DISPLAY_NAME =c_rec.DISPLAY_NAME,
2895: EMAIL = c_rec.EMAIL,
2896: FAX = c_rec.FAX,

Line 2921: INSERT INTO MSC_PARTNER_CONTACTS

2917: lv_old_partner_type <> c_rec.partner_type THEN
2918:
2919: BEGIN
2920:
2921: INSERT INTO MSC_PARTNER_CONTACTS
2922: ( PARTNER_ID,
2923: PARTNER_SITE_ID,
2924: PARTNER_TYPE,
2925: NAME,

Line 2959: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PARTNER_CONTACTS');

2955:
2956: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2957: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2958: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRADING_PARTNER');
2959: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PARTNER_CONTACTS');
2960: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2961:
2962: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2963: RAISE;

Line 2971: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PARTNER_CONTACTS');

2967:
2968: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2969: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2970: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRADING_PARTNER');
2971: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PARTNER_CONTACTS');
2972: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2973:
2974: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2975: FND_MESSAGE.SET_TOKEN('COLUMN', 'PARTNER_ID');