DBA Data[Home] [Help]

APPS.MSC_DRP_UTIL dependencies on MSC_FORM_QUERY

Line 1214: select msc_form_query_s.nextval

1210:
1211: if length(p_list) > 1500 then
1212: -- 5898008, where clause in folder block has length limit < 2000
1213:
1214: select msc_form_query_s.nextval
1215: into p_query_id
1216: from dual;
1217:
1218: forall a in 1..nvl(p_id.last,0)

Line 1219: insert into msc_form_query

1215: into p_query_id
1216: from dual;
1217:
1218: forall a in 1..nvl(p_id.last,0)
1219: insert into msc_form_query
1220: (QUERY_ID,
1221: LAST_UPDATE_DATE,
1222: LAST_UPDATED_BY,
1223: CREATION_DATE,

Line 1237: ' from msc_form_query '||

1233: -1,
1234: p_id(a));
1235:
1236: p_list := ' select number1 '||
1237: ' from msc_form_query '||
1238: ' where query_id ='||p_query_id ;
1239: end if; -- if length(p_list) > 2000 then
1240:
1241: return p_list;