APPS.MSC_HP_UTIL dependencies on MSC_FORM_QUERY

Line 202: insert into msc_form_query(query_id, number1, char1,

198: while nvl(i, 0) > 0 loop
199: t := trim(substr(s, 1, i - 1));
200: if (length(t) > 0) then
201: if (p_filter_type in (ft_organization, ft_category, ft_department, ft_resource)) then
202: insert into msc_form_query(query_id, number1, char1,
203: created_by, creation_date, last_update_date, last_updated_by, last_update_login)
204: values (p_query_id, p_filter_type, trim(substr(s, 1, i - 1)),
205: fnd_global.user_id, sysdate, sysdate, fnd_global.user_id, fnd_global.login_id);
206: end if;

Line 209: insert into msc_form_query(query_id, number1, number2,

205: fnd_global.user_id, sysdate, sysdate, fnd_global.user_id, fnd_global.login_id);
206: end if;
207:
208: if (p_filter_type in (ft_exception, ft_item)) then
209: insert into msc_form_query(query_id, number1, number2,
210: created_by, creation_date, last_update_date, last_updated_by, last_update_login)
211: values (p_query_id, p_filter_type, trim(substr(s, 1, i - 1)),
212: fnd_global.user_id, sysdate, sysdate, fnd_global.user_id, fnd_global.login_id);
213: end if;