APPS.MSC_PERS_QUERIES dependencies on MSC_PERSONAL_QUERIES

Line 608: update msc_personal_queries

604: msc_get_name.execute_dsql(l_sql_stmt);
605: end if;
606:
607:
608: update msc_personal_queries
609: set execute_flag = 1,
610: EXECUTION_DATE = TRUNC(SYSDATE)
611: where query_id = l_temp_query_id ;
612: --where query_id = p_query_id ;

Line 718: from msc_personal_queries

714: l_name varchar2(80);
715: begin
716: select query_name
717: into l_name
718: from msc_personal_queries
719: where query_id = p_query_id;
720:
721: return l_name;
722: exception

Line 732: from msc_personal_queries

728: l_name number;
729: begin
730: select query_type
731: into l_name
732: from msc_personal_queries
733: where query_id = p_query_id;
734:
735: return l_name;
736: exception

Line 765: from msc_personal_queries

761: QUERY_TYPE, PUBLIC_FLAG, AND_OR_FLAG, EXECUTE_FLAG,
762: CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE,
763: LAST_UPDATED_BY, LAST_UPDATE_LOGIN, PLAN_TYPE,
764: AUTO_RELEASE,GROUP_ID,UPDATED_FLAG
765: from msc_personal_queries
766: where query_id = p_query;
767:
768: cursor c_pq_types (p_query in number) is
769: select QUERY_ID, SOURCE_TYPE, OBJECT_TYPE,

Line 799: cursor c_query is select msc_personal_queries_s.nextval from dual;

795: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN
796: from msc_among_values
797: where folder_id = p_query_id;
798:
799: cursor c_query is select msc_personal_queries_s.nextval from dual;
800: --5746041 bugfix, changed from msc_form_query_s to msc_personal_queries_s
801:
802: CURSOR c_group_by(p_query_id IN NUMBER) IS
803: SELECT distinct ATTRIBUTE_NAME group_by

Line 800: --5746041 bugfix, changed from msc_form_query_s to msc_personal_queries_s

796: from msc_among_values
797: where folder_id = p_query_id;
798:
799: cursor c_query is select msc_personal_queries_s.nextval from dual;
800: --5746041 bugfix, changed from msc_form_query_s to msc_personal_queries_s
801:
802: CURSOR c_group_by(p_query_id IN NUMBER) IS
803: SELECT distinct ATTRIBUTE_NAME group_by
804: FROM MSC_WORKLIST_GROUPBY

Line 827: INSERT INTO msc_personal_queries( QUERY_ID, QUERY_NAME, DESCRIPTION,

823: if rec_pers_queries.query_type not in (7,8) then -- org/customer_list
824: l_save_as_query_id := -1 * l_save_as_query_id;
825: end if;
826:
827: INSERT INTO msc_personal_queries( QUERY_ID, QUERY_NAME, DESCRIPTION,
828: QUERY_TYPE, PUBLIC_FLAG, AND_OR_FLAG, EXECUTE_FLAG,
829: CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE,
830: LAST_UPDATED_BY, LAST_UPDATE_LOGIN, PLAN_TYPE,
831: AUTO_RELEASE,GROUP_ID,UPDATED_FLAG)

Line 973: delete from msc_personal_queries

969: procedure delete_query(p_query_id in number,
970: p_query_name in varchar2 default null) is
971: PRAGMA AUTONOMOUS_TRANSACTION;
972: begin
973: delete from msc_personal_queries
974: where query_id = p_query_id;
975:
976: delete from msc_pq_types
977: where query_id = p_query_id;