APPS.AS_ATA_NEW_PUB dependencies on AS_TERR_RESOURCES_TMP

Line 137: --fix for bug(5869095) --populating as_terr_resources_tmp table

133: ,x_return_status => l_return_status);
134: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_ACCOUNT || AS_GAR.G_END);
135: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_ACCOUNT || AS_GAR.G_RETURN_STATUS || l_return_status);
136:
137: --fix for bug(5869095) --populating as_terr_resources_tmp table
138:
139: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_oracle_schema || '.AS_TERR_RESOURCES_TMP REUSE STORAGE';
140:
141: INSERT /*+ append parallel(AS_TERR_RESOURCES_TMP) */

Line 139: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_oracle_schema || '.AS_TERR_RESOURCES_TMP REUSE STORAGE';

135: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_ACCOUNT || AS_GAR.G_RETURN_STATUS || l_return_status);
136:
137: --fix for bug(5869095) --populating as_terr_resources_tmp table
138:
139: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_oracle_schema || '.AS_TERR_RESOURCES_TMP REUSE STORAGE';
140:
141: INSERT /*+ append parallel(AS_TERR_RESOURCES_TMP) */
142: INTO AS_TERR_RESOURCES_TMP
143: (RESOURCE_ID,

Line 141: INSERT /*+ append parallel(AS_TERR_RESOURCES_TMP) */

137: --fix for bug(5869095) --populating as_terr_resources_tmp table
138:
139: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_oracle_schema || '.AS_TERR_RESOURCES_TMP REUSE STORAGE';
140:
141: INSERT /*+ append parallel(AS_TERR_RESOURCES_TMP) */
142: INTO AS_TERR_RESOURCES_TMP
143: (RESOURCE_ID,
144: RESOURCE_TYPE,
145: PARTY_ID,

Line 142: INTO AS_TERR_RESOURCES_TMP

138:
139: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_oracle_schema || '.AS_TERR_RESOURCES_TMP REUSE STORAGE';
140:
141: INSERT /*+ append parallel(AS_TERR_RESOURCES_TMP) */
142: INTO AS_TERR_RESOURCES_TMP
143: (RESOURCE_ID,
144: RESOURCE_TYPE,
145: PARTY_ID,
146: TERR_ID)

Line 164: dbms_stats.gather_table_stats('OSM','AS_TERR_RESOURCES_TMP',

160: );
161:
162: COMMIT;
163:
164: dbms_stats.gather_table_stats('OSM','AS_TERR_RESOURCES_TMP',
165: estimate_percent=>10, degree=>8, granularity=>'GLOBAL', cascade=>TRUE) ;
166: COMMIT;
167:
168: --fix for bug(5869095) --populating as_terr_resources_tmp table

Line 168: --fix for bug(5869095) --populating as_terr_resources_tmp table

164: dbms_stats.gather_table_stats('OSM','AS_TERR_RESOURCES_TMP',
165: estimate_percent=>10, degree=>8, granularity=>'GLOBAL', cascade=>TRUE) ;
166: COMMIT;
167:
168: --fix for bug(5869095) --populating as_terr_resources_tmp table
169:
170:
171: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
172: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_ACCOUNT, l_errbuf, l_retcode);