[Home] [Help]
450: AND tu.team_id = t.team_id
451: AND tu.usage IN ('SALES','PRM')
452: AND tm.team_member_id = trr.role_resource_id
453: AND tm.delete_flag <> 'Y'
454: AND tm.resource_type = 'INDIVIDUAL'
455: AND trr.role_resource_type = 'RS_TEAM_MEMBER'
456: AND trr.delete_flag <> 'Y'
457: AND SYSDATE BETWEEN trr.start_date_active
458: AND NVL(trr.end_date_active,SYSDATE)
885: WHEN OTHERS THEN
886: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_STLEAD || AS_GAR.G_IND_UPD || AS_GAR.G_GENERAL_EXCEPTION);
887: AS_GAR.LOG('SALES_LEAD_ID/SALESFORCE_ID/SALESGROUP_ID/ORG_ID - ' || l_sales_lead_id(i) || '/' || l_salesforce_id(i) || '/' || l_sales_group_id(i) );
888: END;
889: END LOOP; -- for each record individually
890: COMMIT;
891: END IF;
892: END; -- end of deadlock exception
893: WHEN OTHERS THEN
1080: ,l_org_id(i)
1081: ,DECODE(STS.opp_open_status_flag, 'Y', 'Y', NULL)
1082: ,L.lead_rank_score
1083: ,L.creation_date
1084: FROM DUAL, AS_SALES_LEADS L, AS_STATUSES_B STS
1085: WHERE L.sales_lead_id = l_sales_lead_id(i)
1086: AND L.status_code = STS.status_code
1087: AND NOT EXISTS ( SELECT 'X'
1088: FROM AS_ACCESSES_ALL_ALL AA
1155: ,l_org_id(i)
1156: ,DECODE(STS.opp_open_status_flag, 'Y', 'Y', NULL)
1157: ,L.lead_rank_score
1158: ,L.creation_date
1159: FROM DUAL,AS_SALES_LEADS L, AS_STATUSES_B STS
1160: WHERE L.sales_lead_id = l_sales_lead_id(i)
1161: AND L.status_code = STS.status_code
1162: AND NOT EXISTS ( SELECT 'X'
1163: FROM AS_ACCESSES_ALL_ALL AA
1172: EXCEPTION
1173: WHEN OTHERS THEN
1174: NULL;
1175: END;
1176: END LOOP; /* loop for DUP_VAL_ON_INDEX individual insert */
1177: COMMIT;
1178: WHEN OTHERS THEN
1179: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSACC || AS_GAR.G_BULK_INS, SQLERRM, TO_CHAR(SQLCODE));
1180: x_errbuf := SQLERRM;
2192: p_terr_globals.request_id,
2193: L.status_open_flag,
2194: L.lead_rank_score,
2195: L.creation_date
2196: FROM DUAL ,
2197: AS_SALES_LEADS L
2198: WHERE L.sales_lead_id = l_sales_lead_id(i)
2199: AND NOT EXISTS ( select 'X'
2200: from AS_ACCESSES_ALL_ALL aa
2268: p_terr_globals.request_id,
2269: L.status_open_flag,
2270: L.lead_rank_score,
2271: L.creation_date
2272: FROM DUAL ,
2273: AS_SALES_LEADS L
2274: WHERE L.sales_lead_id = l_sales_lead_id(i)
2275: AND NOT EXISTS ( select 'X'
2276: from AS_ACCESSES_ALL_ALL aa