APPS.AS_GAR_LEADS_PUB dependencies on AS_SALES_LEADS

Line 1043: FROM DUAL, AS_SALES_LEADS L, AS_STATUSES_B STS

1039: ,l_org_id(i)
1040: ,DECODE(STS.opp_open_status_flag, 'Y', 'Y', NULL)
1041: ,L.lead_rank_score
1042: ,L.creation_date
1043: FROM DUAL, AS_SALES_LEADS L, AS_STATUSES_B STS
1044: WHERE L.sales_lead_id = l_sales_lead_id(i)
1045: AND L.status_code = STS.status_code
1046: AND NOT EXISTS ( SELECT 'X'
1047: FROM AS_ACCESSES_ALL_ALL AA

Line 1118: FROM DUAL,AS_SALES_LEADS L, AS_STATUSES_B STS

1114: ,l_org_id(i)
1115: ,DECODE(STS.opp_open_status_flag, 'Y', 'Y', NULL)
1116: ,L.lead_rank_score
1117: ,L.creation_date
1118: FROM DUAL,AS_SALES_LEADS L, AS_STATUSES_B STS
1119: WHERE L.sales_lead_id = l_sales_lead_id(i)
1120: AND L.status_code = STS.status_code
1121: AND NOT EXISTS ( SELECT 'X'
1122: FROM AS_ACCESSES_ALL_ALL AA

Line 1769: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'UPDATE AS_SALES_LEADS');

1765: IF l_last > l_sales_lead_id.LAST THEN
1766: l_last := l_sales_lead_id.LAST;
1767: END IF;
1768: WHILE l_attempts < 3 LOOP
1769: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'UPDATE AS_SALES_LEADS');
1770: BEGIN
1771: FORALL i in l_first .. l_last
1772: UPDATE AS_SALES_LEADS sl
1773: SET sl.last_update_date = SYSDATE,

Line 1772: UPDATE AS_SALES_LEADS sl

1768: WHILE l_attempts < 3 LOOP
1769: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'UPDATE AS_SALES_LEADS');
1770: BEGIN
1771: FORALL i in l_first .. l_last
1772: UPDATE AS_SALES_LEADS sl
1773: SET sl.last_update_date = SYSDATE,
1774: sl.last_updated_by = p_terr_globals.user_id,
1775: sl.last_update_login = p_terr_globals.last_update_login,
1776: sl.request_id = p_terr_globals.request_id,

Line 1801: UPDATE AS_SALES_LEADS sl

1797: l_attempts := l_attempts +1;
1798: IF l_attempts = 3 THEN
1799: FOR i IN l_first .. l_last LOOP
1800: BEGIN
1801: UPDATE AS_SALES_LEADS sl
1802: SET sl.last_update_date = SYSDATE,
1803: sl.last_updated_by = p_terr_globals.user_id,
1804: sl.last_update_login = p_terr_globals.last_update_login,
1805: sl.request_id = p_terr_globals.request_id,

Line 1827: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'UPDATE AS_SALES_LEADS', SQLERRM, TO_CHAR(SQLCODE));

1823: COMMIT;
1824: END IF;
1825: END; -- end of deadlock exception
1826: WHEN OTHERS THEN
1827: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'UPDATE AS_SALES_LEADS', SQLERRM, TO_CHAR(SQLCODE));
1828: x_errbuf := SQLERRM;
1829: x_retcode := SQLCODE;
1830: x_return_status := FND_API.G_RET_STS_ERROR;
1831: RAISE;