APPS.MSC_CL_SETUP_ODS_LOAD dependencies on MSC_PARTNER_CONTACTS

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

2862:
2863: 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
2864:
2865: IF NOT MSC_CL_COLLECTION.v_is_legacy_refresh THEN
2866: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_PARTNER_CONTACTS', MSC_CL_COLLECTION.v_instance_id, NULL);
2867: END IF;
2868:
2869: FOR c_rec IN c4 LOOP
2870:

Line 2875: delete from MSC_PARTNER_CONTACTS where

2871: if(MSC_CL_COLLECTION.v_is_legacy_refresh) then
2872:
2873: if (c_rec.DELETED_FLAG =MSC_UTIL.SYS_YES) then
2874:
2875: delete from MSC_PARTNER_CONTACTS where
2876: partner_id=c_rec.PARTNER_ID
2877: and nvl(partner_site_id,-99999)=nvl(c_rec.PARTNER_SITE_ID,-99999)
2878: and partner_type=c_rec.PARTNER_TYPE
2879: and SR_INSTANCE_ID =MSC_CL_COLLECTION.v_instance_id

Line 2882: UPDATE MSC_PARTNER_CONTACTS

2878: and partner_type=c_rec.PARTNER_TYPE
2879: and SR_INSTANCE_ID =MSC_CL_COLLECTION.v_instance_id
2880: and c_rec.DELETED_FLAG =MSC_UTIL.SYS_YES;
2881: else
2882: UPDATE MSC_PARTNER_CONTACTS
2883: set Name=c_rec.NAME,
2884: DISPLAY_NAME =c_rec.DISPLAY_NAME,
2885: EMAIL = c_rec.EMAIL,
2886: FAX = c_rec.FAX,

Line 2911: INSERT INTO MSC_PARTNER_CONTACTS

2907: lv_old_partner_type <> c_rec.partner_type THEN
2908:
2909: BEGIN
2910:
2911: INSERT INTO MSC_PARTNER_CONTACTS
2912: ( PARTNER_ID,
2913: PARTNER_SITE_ID,
2914: PARTNER_TYPE,
2915: NAME,

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

2945:
2946: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2947: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2948: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRADING_PARTNER');
2949: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PARTNER_CONTACTS');
2950: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2951:
2952: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2953: RAISE;

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

2957:
2958: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2959: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2960: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRADING_PARTNER');
2961: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PARTNER_CONTACTS');
2962: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2963:
2964: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2965: FND_MESSAGE.SET_TOKEN('COLUMN', 'PARTNER_ID');