APPS.AS_GAR_OPPTYS_PUB dependencies on AS_SALES_CREDITS

Line 1510: AND NOT EXISTS (SELECT 1 FROM AS_SALES_CREDITS SCR

1506: WHERE W.trans_object_id = ACC.lead_id
1507: AND W.worker_id = l_worker_id
1508: AND W.resource_id = ACC.salesforce_id
1509: AND W.group_id = ACC.sales_group_id)
1510: AND NOT EXISTS (SELECT 1 FROM AS_SALES_CREDITS SCR
1511: WHERE SCR.LEAD_ID = ACC.LEAD_ID
1512: AND SCR.SALESFORCE_ID = ACC.SALESFORCE_ID
1513: AND SCR.SALESGROUP_ID = ACC.SALES_GROUP_ID )
1514: AND ROWNUM < G_DEL_REC;

Line 1534: AND NOT EXISTS (SELECT 1 FROM AS_SALES_CREDITS SCR

1530: WHERE W.trans_object_id = ACC.lead_id
1531: AND W.worker_id = l_worker_id
1532: AND W.resource_id = ACC.salesforce_id
1533: AND W.group_id = ACC.sales_group_id)
1534: AND NOT EXISTS (SELECT 1 FROM AS_SALES_CREDITS SCR
1535: WHERE SCR.LEAD_ID = ACC.LEAD_ID
1536: AND SCR.SALESFORCE_ID = ACC.SALESFORCE_ID
1537: AND SCR.SALESGROUP_ID = ACC.SALES_GROUP_ID )
1538: AND ROWNUM < G_DEL_REC;

Line 1568: AND NOT EXISTS (SELECT 1 FROM AS_SALES_CREDITS SCR

1564: WHERE W.trans_object_id = ACC.lead_id
1565: AND W.resource_id = ACC.salesforce_id
1566: AND W.worker_id = l_worker_id
1567: AND W.group_id = ACC.sales_group_id)
1568: AND NOT EXISTS (SELECT 1 FROM AS_SALES_CREDITS SCR
1569: WHERE SCR.LEAD_ID = ACC.LEAD_ID
1570: AND SCR.SALESFORCE_ID = ACC.SALESFORCE_ID
1571: AND SCR.SALESGROUP_ID = ACC.SALES_GROUP_ID );
1572: COMMIT;

Line 1588: AND NOT EXISTS (SELECT 1 FROM AS_SALES_CREDITS SCR

1584: WHERE W.trans_object_id = ACC.lead_id
1585: AND W.resource_id = ACC.salesforce_id
1586: AND W.worker_id = l_worker_id
1587: AND W.group_id = ACC.sales_group_id)
1588: AND NOT EXISTS (SELECT 1 FROM AS_SALES_CREDITS SCR
1589: WHERE SCR.LEAD_ID = ACC.LEAD_ID
1590: AND SCR.SALESFORCE_ID = ACC.SALESFORCE_ID
1591: AND SCR.SALESGROUP_ID = ACC.SALES_GROUP_ID );
1592: EXCEPTION

Line 1853: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'UPDATE AS_SALES_CREDITS_DENORM');

1849: x_return_status := FND_API.G_RET_STS_ERROR;
1850: RAISE;
1851: END;
1852: END LOOP;
1853: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'UPDATE AS_SALES_CREDITS_DENORM');
1854: WHILE l_attempts < 3 LOOP
1855: BEGIN
1856: FORALL i in l_first .. l_last
1857: UPDATE AS_SALES_CREDITS_DENORM scd

Line 1857: UPDATE AS_SALES_CREDITS_DENORM scd

1853: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'UPDATE AS_SALES_CREDITS_DENORM');
1854: WHILE l_attempts < 3 LOOP
1855: BEGIN
1856: FORALL i in l_first .. l_last
1857: UPDATE AS_SALES_CREDITS_DENORM scd
1858: SET scd.object_version_number = nvl(scd.object_version_number,0) + 1,
1859: scd.last_update_date = SYSDATE,
1860: scd.last_updated_by = p_terr_globals.user_id,
1861: scd.last_update_login = p_terr_globals.last_update_login,

Line 1886: UPDATE AS_SALES_CREDITS_DENORM scd

1882: l_attempts := l_attempts +1;
1883: IF l_attempts = 3 THEN
1884: FOR i IN l_first .. l_last LOOP
1885: BEGIN
1886: UPDATE AS_SALES_CREDITS_DENORM scd
1887: SET scd.object_version_number = nvl(scd.object_version_number,0) + 1,
1888: scd.last_update_date = SYSDATE,
1889: scd.last_updated_by = p_terr_globals.user_id,
1890: scd.last_update_login = p_terr_globals.last_update_login,

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

1908: COMMIT;
1909: END IF;
1910: END; -- end of deadlock exception
1911: WHEN OTHERS THEN
1912: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'UPDATE AS_SALES_CREDITS_DENORM', SQLERRM, TO_CHAR(SQLCODE));
1913: x_errbuf := SQLERRM;
1914: x_retcode := SQLCODE;
1915: x_return_status := FND_API.G_RET_STS_ERROR;
1916: RAISE;