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_STATUSES_PKG dependencies on AS_LEADS_ALL

Line 676: Create_Temp_Index('AS_LEADS_ALL','LEAD_ID,STATUS,CLOSE_REASON',G_INDEX_SUFFIX2);

672: Create_Temp_Index('AS_SALES_LEADS','SALES_LEAD_ID,STATUS_CODE,CLOSE_REASON',G_INDEX_SUFFIX1);
673: Create_Temp_Index('AS_ACCESSES_ALL_ALL','ACCESS_ID,DELETE_FLAG,SALES_LEAD_ID',G_INDEX_SUFFIX1);
674:
675: --Create temporary indexes for opportunities
676: Create_Temp_Index('AS_LEADS_ALL','LEAD_ID,STATUS,CLOSE_REASON',G_INDEX_SUFFIX2);
677: Create_Temp_Index('AS_ACCESSES_ALL_ALL','ACCESS_ID,DELETE_FLAG,LEAD_ID',G_INDEX_SUFFIX2);
678: EXCEPTION
679: WHEN others THEN
680: ERRBUF := SQLERRM;

Line 701: Drop_Temp_Index('AS_LEADS_ALL',G_INDEX_SUFFIX2);

697: Drop_Temp_Index('AS_SALES_LEADS',G_INDEX_SUFFIX1);
698: Drop_Temp_Index('AS_ACCESSES_ALL_ALL',G_INDEX_SUFFIX1);
699:
700: -- Drop temporary index for Opportunities
701: Drop_Temp_Index('AS_LEADS_ALL',G_INDEX_SUFFIX2);
702: Drop_Temp_Index('AS_ACCESSES_ALL_ALL',G_INDEX_SUFFIX2);
703: EXCEPTION when others then
704: null;
705: END POST_UPDATE;

Line 858: -- Get maximum number of possible rows in as_leads_all

854: END IF;
855:
856:
857: --
858: -- Get maximum number of possible rows in as_leads_all
859: --
860:
861: -- Initialize start ID value
862: l_start_id := 0;

Line 1192: ( SELECT /+ INDEX(lds AS_LEADS_ALL_MT2)/ 1

1188: WHERE acc.ACCESS_ID >= l_count
1189: AND acc.ACCESS_ID < l_count+G_BATCH_SIZE
1190: AND acc.ACCESS_ID < l_max_id
1191: AND (l_opp_flag = 'Y' AND EXISTS
1192: ( SELECT /*+ INDEX(lds AS_LEADS_ALL_MT2)*/ 1
1193: FROM AS_LEADS_ALL lds
1194: WHERE lds.lead_id = acc.lead_id
1195: AND lds.status = X_STATUS_CODE
1196: AND acc.lead_id is not null ))

Line 1193: FROM AS_LEADS_ALL lds

1189: AND acc.ACCESS_ID < l_count+G_BATCH_SIZE
1190: AND acc.ACCESS_ID < l_max_id
1191: AND (l_opp_flag = 'Y' AND EXISTS
1192: ( SELECT /*+ INDEX(lds AS_LEADS_ALL_MT2)*/ 1
1193: FROM AS_LEADS_ALL lds
1194: WHERE lds.lead_id = acc.lead_id
1195: AND lds.status = X_STATUS_CODE
1196: AND acc.lead_id is not null ))
1197: AND acc.lead_id is not null;

Line 1220: acc.OPEN_FLAG = (SELECT /+ INDEX(lds AS_LEADS_ALL_MT2)/ st.opp_open_status_flag

1216:
1217:
1218: UPDATE /*+ INDEX(acc AS_ACCESSES_ALL_ALL_MT2)*/ AS_ACCESSES_ALL acc
1219: SET object_version_number = nvl(object_version_number,0) + 1,
1220: acc.OPEN_FLAG = (SELECT /*+ INDEX(lds AS_LEADS_ALL_MT2)*/ st.opp_open_status_flag
1221: FROM AS_STATUSES_B st,AS_LEADS_ALL lds
1222: WHERE st.status_code = lds.status
1223: AND lds.lead_id = acc.lead_id
1224: AND acc.lead_id is not null

Line 1221: FROM AS_STATUSES_B st,AS_LEADS_ALL lds

1217:
1218: UPDATE /*+ INDEX(acc AS_ACCESSES_ALL_ALL_MT2)*/ AS_ACCESSES_ALL acc
1219: SET object_version_number = nvl(object_version_number,0) + 1,
1220: acc.OPEN_FLAG = (SELECT /*+ INDEX(lds AS_LEADS_ALL_MT2)*/ st.opp_open_status_flag
1221: FROM AS_STATUSES_B st,AS_LEADS_ALL lds
1222: WHERE st.status_code = lds.status
1223: AND lds.lead_id = acc.lead_id
1224: AND acc.lead_id is not null
1225: AND st.opp_flag = 'Y'),

Line 1337: -- Get maximum number of possible rows in as_leads_all

1333: END IF;
1334:
1335:
1336: --
1337: -- Get maximum number of possible rows in as_leads_all
1338: --
1339:
1340: -- Initialize start ID value
1341: l_start_id := 0;

Line 1769: from as_leads_all;

1765: from dual;
1766:
1767: CURSOR Get_SL_Min_Id IS
1768: select min(lead_id)
1769: from as_leads_all;
1770:
1771: BEGIN
1772:
1773: --

Line 1789: -- Get maximum number of possible rows in as_leads_all

1785: END IF;
1786:
1787:
1788: --
1789: -- Get maximum number of possible rows in as_leads_all
1790: --
1791:
1792: -- Initialize start ID value
1793: l_start_id := 0;

Line 2034: from as_leads_all;

2030:
2031:
2032: CURSOR Get_L_Min_Id IS
2033: select min(lead_id)
2034: from as_leads_all;
2035:
2036: CURSOR Get_L_Next_Val IS
2037: select AS_LEADS_S.nextval
2038: from dual;

Line 2101: execute immediate 'UPDATE /+ INDEX(ld AS_LEADS_ALL_MT2)/ AS_LEADS_ALL ld

2097: FND_FILE.PUT_LINE(FND_FILE.LOG,'Current loop count:' || l_count);
2098: end if;
2099: -- update statements for opptys here
2100: If Upper(X_STATUS_CODE) = 'ALL' THEN
2101: execute immediate 'UPDATE /*+ INDEX(ld AS_LEADS_ALL_MT2)*/ AS_LEADS_ALL ld
2102: SET ld.close_reason = (DECODE((SELECT opp_open_status_flag
2103: FROM AS_STATUSES_B st
2104: WHERE st.status_code = ld.status
2105: AND st.opp_flag = ''Y''),''Y'',NULL,''N'',nvl(ld.CLOSE_REASON,''NOT_SPECIFIED'')))

Line 2114: execute immediate 'UPDATE /+ INDEX(ld AS_LEADS_ALL_MT2)/ AS_LEADS_ALL ld

2110: AND ld.lead_id < :l_count1+:G_BATCH_SIZE
2111: AND ld.lead_id < :l_max_id
2112: AND ld.status is not null' using l_last_updated_by,l_last_update_login,l_count,l_count,G_BATCH_SIZE,l_max_id ;
2113: ELSIF Upper(X_OPEN_FLAG) = 'Y' THEN
2114: execute immediate 'UPDATE /*+ INDEX(ld AS_LEADS_ALL_MT2)*/ AS_LEADS_ALL ld
2115: SET ld.close_reason = null
2116: , ld.last_update_date = sysdate
2117: , ld.last_updated_by = :l_last_updated_by
2118: , ld.last_update_login = :l_last_update_login

Line 2126: execute immediate 'UPDATE /+ INDEX(ld AS_LEADS_ALL_MT2)/ AS_LEADS_ALL ld

2122: AND ld.status = :X_STATUS_CODE
2123: AND ld.status is not null
2124: AND ld.close_reason is not null' using l_last_updated_by,l_last_update_login,l_count,l_count,G_BATCH_SIZE,l_max_id,X_STATUS_CODE ;
2125: ELSIF Upper(X_OPEN_FLAG) = 'N' THEN
2126: execute immediate 'UPDATE /*+ INDEX(ld AS_LEADS_ALL_MT2)*/ AS_LEADS_ALL ld
2127: SET ld.close_reason = ''NOT_SPECIFIED''
2128: , ld.last_update_date = sysdate
2129: , ld.last_updated_by = :l_last_updated_by
2130: , ld.last_update_login = :l_last_update_login