DBA Data[Home] [Help]

APPS.MSC_DRP_UTIL dependencies on MSC_FORM_QUERY

Line 1205: select msc_form_query_s.nextval

1201:
1202: if length(p_list) > 1500 then
1203: -- 5898008, where clause in folder block has length limit < 2000
1204:
1205: select msc_form_query_s.nextval
1206: into p_query_id
1207: from dual;
1208:
1209: forall a in 1..nvl(p_id.last,0)

Line 1210: insert into msc_form_query

1206: into p_query_id
1207: from dual;
1208:
1209: forall a in 1..nvl(p_id.last,0)
1210: insert into msc_form_query
1211: (QUERY_ID,
1212: LAST_UPDATE_DATE,
1213: LAST_UPDATED_BY,
1214: CREATION_DATE,

Line 1228: ' from msc_form_query '||

1224: -1,
1225: p_id(a));
1226:
1227: p_list := ' select number1 '||
1228: ' from msc_form_query '||
1229: ' where query_id ='||p_query_id ;
1230: end if; -- if length(p_list) > 2000 then
1231:
1232: return p_list;