[Home] [Help]
1037: ,SYSDATE
1038: ,'Y'
1039: ,l_org_id(i)
1040: ,DECODE(STS.opp_open_status_flag, 'Y', 'Y', NULL)
1041: FROM DUAL, AS_LEADS_ALL L, AS_STATUSES_B STS
1042: WHERE L.lead_id = l_lead_id(i)
1043: AND L.status = STS.status_code
1044: AND NOT EXISTS ( SELECT 'X'
1045: FROM AS_ACCESSES_ALL_ALL AA
1108: ,SYSDATE
1109: ,'Y'
1110: ,l_org_id(i)
1111: ,DECODE(STS.opp_open_status_flag, 'Y', 'Y', NULL)
1112: FROM DUAL,AS_LEADS_ALL L, AS_STATUSES_B STS
1113: WHERE L.lead_id = l_lead_id(i)
1114: AND L.status = STS.status_code
1115: AND NOT EXISTS ( SELECT 'X'
1116: FROM AS_ACCESSES_ALL_ALL AA
1784: IF l_last > l_lead_id.LAST THEN
1785: l_last := l_lead_id.LAST;
1786: END IF;
1787: WHILE l_attempts < 3 LOOP
1788: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'UPDATE AS_LEADS_ALL');
1789: BEGIN
1790: FORALL i in l_first .. l_last
1791: UPDATE AS_LEADS_ALL sl
1792: SET sl.object_version_number = nvl(sl.object_version_number,0) + 1,
1787: WHILE l_attempts < 3 LOOP
1788: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'UPDATE AS_LEADS_ALL');
1789: BEGIN
1790: FORALL i in l_first .. l_last
1791: UPDATE AS_LEADS_ALL sl
1792: SET sl.object_version_number = nvl(sl.object_version_number,0) + 1,
1793: sl.last_update_date = SYSDATE,
1794: sl.last_updated_by = p_terr_globals.user_id,
1795: sl.last_update_login = p_terr_globals.last_update_login,
1816: l_attempts := l_attempts +1;
1817: IF l_attempts = 3 THEN
1818: FOR i IN l_first .. l_last LOOP
1819: BEGIN
1820: UPDATE AS_LEADS_ALL sl
1821: SET sl.object_version_number = nvl(sl.object_version_number,0) + 1,
1822: sl.last_update_date = SYSDATE,
1823: sl.last_updated_by = p_terr_globals.user_id,
1824: sl.last_update_login = p_terr_globals.last_update_login,