APPS.AS_GAR_OPPTYS_PUB dependencies on AS_SALES_CREDITS_DENORM

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;