APPS.MSC_NETCHANGE_PKG dependencies on MSC_NEC_EXC_DTL_TEMP

Line 1226: insert into msc_nec_exc_dtl_temp(

1222:
1223: if g_need_insert_temp then
1224:
1225: -- insert summary rows which are grouped by exc_type
1226: insert into msc_nec_exc_dtl_temp(
1227: query_id,
1228: status,
1229: plan_id,
1230: exception_type,

Line 1251: from msc_nec_exc_dtl_temp

1247: -1,
1248: trunc(sysdate),
1249: -1,
1250: -1
1251: from msc_nec_exc_dtl_temp
1252: where query_id = g_excp_query_id
1253: and exception_detail_id is not null
1254: group by query_id,
1255: status,

Line 1267: insert into msc_nec_exc_dtl_temp(

1263: -1,
1264: -1 ;
1265:
1266: -- insert summary rows which are grouped by exc_group
1267: insert into msc_nec_exc_dtl_temp(
1268: query_id,
1269: status,
1270: plan_id,
1271: exception_group,

Line 1290: from msc_nec_exc_dtl_temp

1286: -1,
1287: trunc(sysdate),
1288: -1,
1289: -1
1290: from msc_nec_exc_dtl_temp
1291: where query_id = g_excp_query_id
1292: and exception_detail_id is null
1293: group by query_id,
1294: status,

Line 2189: ' insert into msc_nec_exc_dtl_temp( '||

2185: sql_statement varchar2(32000);
2186: begin
2187:
2188: sql_statement :=
2189: ' insert into msc_nec_exc_dtl_temp( '||
2190: ' query_id, '||
2191: ' status, '||
2192: ' exception_detail_id,' ||
2193: ' plan_id,' ||