[Home] [Help]
235: ',p_end_id='||p_end_id ||
236: ',p_debug_flag='||p_debug_flag);
237: END IF;
238:
239: l_user_id := FND_GLOBAL.user_id;
240:
241: IF l_user_id IS NULL THEN
242: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
243: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, l_module_name,
283: UPDATE AS_ACCESSES_ALL_ALL -- @@
284: SET DELETE_FLAG = 'Y',
285: LAST_UPDATED_BY = l_user_id,
286: LAST_UPDATE_DATE = sysdate,
287: LAST_UPDATE_LOGIN = FND_GLOBAL.conc_login_id
288: WHERE lead_id = l_lead_id AND -- @@
289: salesforce_id = uniq_steam_rec.salesforce_id AND
290: nvl(sales_group_id, -37) = nvl(uniq_steam_rec.sales_group_id, -37) AND
291: nvl(partner_customer_id, -37) = nvl(uniq_steam_rec.partner_customer_id, -37) AND
301: OWNER_FLAG = uniq_steam_rec.owner_flag,
302: CONTRIBUTOR_FLAG = uniq_steam_rec.contributor_flag,
303: LAST_UPDATED_BY = l_user_id,
304: LAST_UPDATE_DATE = sysdate,
305: LAST_UPDATE_LOGIN = FND_GLOBAL.conc_login_id
306: WHERE access_id = l_access_id;
307: END LOOP;
308: ---- @@
309: IF (p_debug_flag = 'Y' AND
453: ',p_end_id='||p_end_id ||
454: ',p_debug_flag='||p_debug_flag);
455: END IF;
456:
457: l_user_id := FND_GLOBAL.user_id;
458:
459: IF l_user_id IS NULL THEN
460: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
461: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, l_module_name,
498: UPDATE AS_ACCESSES_ALL_ALL -- @@
499: SET DELETE_FLAG = 'Y',
500: LAST_UPDATED_BY = l_user_id,
501: LAST_UPDATE_DATE = sysdate,
502: LAST_UPDATE_LOGIN = FND_GLOBAL.conc_login_id
503: WHERE sales_lead_id = l_sales_lead_id AND -- @@
504: salesforce_id = uniq_steam_rec.salesforce_id AND
505: nvl(sales_group_id, -37) = nvl(uniq_steam_rec.sales_group_id, -37) AND
506: access_id <> l_access_id AND
514: OWNER_FLAG = uniq_steam_rec.owner_flag,
515: CONTRIBUTOR_FLAG = uniq_steam_rec.contributor_flag,
516: LAST_UPDATED_BY = l_user_id,
517: LAST_UPDATE_DATE = sysdate,
518: LAST_UPDATE_LOGIN = FND_GLOBAL.conc_login_id
519: WHERE access_id = l_access_id;
520: END LOOP;
521:
522: IF (p_debug_flag = 'Y' AND
1090: ',p_end_id='||p_end_id ||
1091: ',p_debug_flag='||p_debug_flag);
1092: END IF;
1093:
1094: l_user_id := FND_GLOBAL.user_id;
1095:
1096: IF l_user_id IS NULL THEN
1097: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1098: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, l_module_name,
1136: UPDATE AS_ACCESSES_ALL_ALL -- @@
1137: SET DELETE_FLAG = 'Y',
1138: LAST_UPDATED_BY = l_user_id,
1139: LAST_UPDATE_DATE = sysdate,
1140: LAST_UPDATE_LOGIN = FND_GLOBAL.conc_login_id
1141: WHERE customer_id = l_party_id AND -- @@
1142: lead_id IS NULL AND
1143: sales_lead_id IS NULL AND
1144: salesforce_id = uniq_steam_rec.salesforce_id AND
1156: OWNER_FLAG = uniq_steam_rec.owner_flag,
1157: CONTRIBUTOR_FLAG = uniq_steam_rec.contributor_flag,
1158: LAST_UPDATED_BY = l_user_id,
1159: LAST_UPDATE_DATE = sysdate,
1160: LAST_UPDATE_LOGIN = FND_GLOBAL.conc_login_id
1161: WHERE access_id = l_access_id;
1162: END LOOP;
1163:
1164: IF (p_debug_flag = 'Y' AND
1536: l_uncommitted_opps NUMBER := 0;
1537:
1538: BEGIN
1539: l_custfix_count := 0;
1540: l_user_id := FND_GLOBAL.user_id;
1541: IF l_user_id IS NULL THEN
1542: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1543: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, l_module_name,
1544: 'Opportunities: Error: Global User Id is not set');
1659: UPDATE AS_ACCESSES_ALL
1660: SET CUSTOMER_ID = l_customer_id(i),
1661: LAST_UPDATED_BY = l_user_id,
1662: LAST_UPDATE_DATE = sysdate,
1663: LAST_UPDATE_LOGIN = FND_GLOBAL.conc_login_id
1664: WHERE LEAD_ID = l_lead_id(i) AND
1665: nvl(CUSTOMER_ID, -37) <> l_customer_id(i);
1666: l_custfix_count := SQL%ROWCOUNT;
1667: