eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AS_GAR_LEADS_PUB dependencies on AS_SALES_LEADS

Line 1084: FROM DUAL, AS_SALES_LEADS L, AS_STATUSES_B STS

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

Line 1159: FROM DUAL,AS_SALES_LEADS L, AS_STATUSES_B STS

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

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

1806: IF l_last > l_sales_lead_id.LAST THEN
1807: l_last := l_sales_lead_id.LAST;
1808: END IF;
1809: WHILE l_attempts < 3 LOOP
1810: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'UPDATE AS_SALES_LEADS');
1811: BEGIN
1812: FORALL i in l_first .. l_last
1813: UPDATE AS_SALES_LEADS sl
1814: SET sl.last_update_date = SYSDATE,

Line 1813: UPDATE AS_SALES_LEADS sl

1809: WHILE l_attempts < 3 LOOP
1810: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'UPDATE AS_SALES_LEADS');
1811: BEGIN
1812: FORALL i in l_first .. l_last
1813: UPDATE AS_SALES_LEADS sl
1814: SET sl.last_update_date = SYSDATE,
1815: sl.last_updated_by = p_terr_globals.user_id,
1816: sl.last_update_login = p_terr_globals.last_update_login,
1817: sl.request_id = p_terr_globals.request_id,

Line 1842: UPDATE AS_SALES_LEADS sl

1838: l_attempts := l_attempts +1;
1839: IF l_attempts = 3 THEN
1840: FOR i IN l_first .. l_last LOOP
1841: BEGIN
1842: UPDATE AS_SALES_LEADS sl
1843: SET sl.last_update_date = SYSDATE,
1844: sl.last_updated_by = p_terr_globals.user_id,
1845: sl.last_update_login = p_terr_globals.last_update_login,
1846: sl.request_id = p_terr_globals.request_id,

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

1864: COMMIT;
1865: END IF;
1866: END; -- end of deadlock exception
1867: WHEN OTHERS THEN
1868: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'UPDATE AS_SALES_LEADS', SQLERRM, TO_CHAR(SQLCODE));
1869: x_errbuf := SQLERRM;
1870: x_retcode := SQLCODE;
1871: x_return_status := FND_API.G_RET_STS_ERROR;
1872: RAISE;

Line 2197: AS_SALES_LEADS L

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
2201: where aa.sales_lead_id is not null

Line 2273: AS_SALES_LEADS L

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
2277: where aa.sales_lead_id is not null

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

2361: RAISE;
2362: END;
2363: END LOOP;
2364:
2365: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'UPDATE AS_SALES_LEADS');
2366: l_attempts := 1;
2367: WHILE l_attempts < 3 LOOP
2368: BEGIN
2369: FORALL i in l_first .. l_last

Line 2370: UPDATE AS_SALES_LEADS sl SET

2366: l_attempts := 1;
2367: WHILE l_attempts < 3 LOOP
2368: BEGIN
2369: FORALL i in l_first .. l_last
2370: UPDATE AS_SALES_LEADS sl SET
2371: sl.last_update_date = SYSDATE,
2372: sl.last_updated_by = p_terr_globals.user_id,
2373: sl.last_update_login = p_terr_globals.last_update_login,
2374: sl.request_id = p_terr_globals.request_id,

Line 2384: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'UPDATE AS_SALES_LEADS::' || AS_GAR.G_N_ROWS_PROCESSED || l_first || ' - '|| l_last);

2380: sl.assign_to_person_id = l_person_id
2381: WHERE sl.sales_lead_id = l_sales_lead_id(i) ;
2382: COMMIT;
2383: l_attempts := 3;
2384: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'UPDATE AS_SALES_LEADS::' || AS_GAR.G_N_ROWS_PROCESSED || l_first || ' - '|| l_last);
2385: EXCEPTION
2386: WHEN deadlock_detected THEN
2387: BEGIN
2388: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'UPDATE AS_SALES_LEADS::' || AS_GAR.G_DEADLOCK ||l_attempts );

Line 2388: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'UPDATE AS_SALES_LEADS::' || AS_GAR.G_DEADLOCK ||l_attempts );

2384: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'UPDATE AS_SALES_LEADS::' || AS_GAR.G_N_ROWS_PROCESSED || l_first || ' - '|| l_last);
2385: EXCEPTION
2386: WHEN deadlock_detected THEN
2387: BEGIN
2388: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'UPDATE AS_SALES_LEADS::' || AS_GAR.G_DEADLOCK ||l_attempts );
2389: l_attempts := l_attempts +1;
2390: ROLLBACK;
2391: IF l_attempts = 3 THEN
2392: FOR i IN l_first .. l_last LOOP

Line 2394: UPDATE AS_SALES_LEADS sl SET

2390: ROLLBACK;
2391: IF l_attempts = 3 THEN
2392: FOR i IN l_first .. l_last LOOP
2393: BEGIN
2394: UPDATE AS_SALES_LEADS sl SET
2395: sl.last_update_date = SYSDATE,
2396: sl.last_updated_by = p_terr_globals.user_id,
2397: sl.last_update_login = p_terr_globals.last_update_login,
2398: sl.request_id = p_terr_globals.request_id,

Line 2408: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'ROW-BY-ROW UPDATE AS_SALES_LEADS', SQLERRM, TO_CHAR(SQLCODE));

2404: sl.assign_to_person_id = l_person_id
2405: WHERE sl.sales_lead_id = l_sales_lead_id(i) ;
2406: EXCEPTION
2407: WHEN OTHERS THEN
2408: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'ROW-BY-ROW UPDATE AS_SALES_LEADS', SQLERRM, TO_CHAR(SQLCODE));
2409: END;
2410: END LOOP;
2411: COMMIT;
2412: END IF;

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

2411: COMMIT;
2412: END IF;
2413: END; -- end of deadlock exception
2414: WHEN OTHERS THEN
2415: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'UPDATE AS_SALES_LEADS', SQLERRM, TO_CHAR(SQLCODE));
2416: x_errbuf := SQLERRM;
2417: x_retcode := SQLCODE;
2418: x_return_status := FND_API.G_RET_STS_ERROR;
2419: RAISE;

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

2743: IF l_last > l_sales_lead_id.LAST THEN
2744: l_last := l_sales_lead_id.LAST;
2745: END IF;
2746: WHILE l_attempts < 3 LOOP
2747: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'UPDATE AS_SALES_LEADS');
2748: BEGIN
2749: FORALL i in l_first .. l_last
2750: UPDATE AS_SALES_LEADS sl SET
2751: sl.last_update_date = SYSDATE,

Line 2750: UPDATE AS_SALES_LEADS sl SET

2746: WHILE l_attempts < 3 LOOP
2747: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'UPDATE AS_SALES_LEADS');
2748: BEGIN
2749: FORALL i in l_first .. l_last
2750: UPDATE AS_SALES_LEADS sl SET
2751: sl.last_update_date = SYSDATE,
2752: sl.last_updated_by = p_terr_globals.user_id,
2753: sl.last_update_login = p_terr_globals.last_update_login,
2754: sl.request_id = p_terr_globals.request_id,

Line 2779: UPDATE AS_SALES_LEADS sl SET

2775: l_attempts := l_attempts +1;
2776: IF l_attempts = 3 THEN
2777: FOR i IN l_first .. l_last LOOP
2778: BEGIN
2779: UPDATE AS_SALES_LEADS sl SET
2780: sl.last_update_date = SYSDATE,
2781: sl.last_updated_by = p_terr_globals.user_id,
2782: sl.last_update_login = p_terr_globals.last_update_login,
2783: sl.request_id = p_terr_globals.request_id,

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

2801: COMMIT;
2802: END IF;
2803: END; -- end of deadlock exception
2804: WHEN OTHERS THEN
2805: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'UPDATE AS_SALES_LEADS', SQLERRM, TO_CHAR(SQLCODE));
2806: x_errbuf := SQLERRM;
2807: x_retcode := SQLCODE;
2808: x_return_status := FND_API.G_RET_STS_ERROR;
2809: RAISE;