APPS.MSC_PQ_UTILS dependencies on MSC_PQ_TYPES

Line 24: FROM MSC_PQ_TYPES pqt,

20: PROCEDURE set_top_action(p_plan_id IN NUMBER, p_query_id IN NUMBER);
21:
22: CURSOR detailQCur(p_query_id IN NUMBER) IS
23: SELECT pqt.DETAIL_QUERY_ID query_id,mpq.query_type
24: FROM MSC_PQ_TYPES pqt,
25: msc_personal_queries mpq
26: WHERE pqt.query_id = p_query_id
27: AND mpq.query_id = pqt.DETAIL_QUERY_ID;
28:

Line 31: FROM MSC_PQ_TYPES pqt

27: AND mpq.query_id = pqt.DETAIL_QUERY_ID;
28:
29: CURSOR WlExcepCur(p_query_id IN NUMBER) IS
30: SELECT 1
31: FROM MSC_PQ_TYPES pqt
32: WHERE pqt.query_id = p_query_id
33: AND pqt.DETAIL_QUERY_ID IS NULL;
34:
35: FUNCTION Get_Pref(p_plan_id NUMBER, p_preference in varchar2) RETURN NUMBER is

Line 779: -- for a specific category_id ( msc_pq_types.object_type)

775: RAISE;
776: END Parse_exceptions;
777:
778: -- for criticality matrix , this function returns where clause
779: -- for a specific category_id ( msc_pq_types.object_type)
780: FUNCTION build_where_clause_new(p_query_id IN NUMBER DEFAULT NULL,
781: p_source_type IN NUMBER DEFAULT NULL,
782: P_object_type IN NUMBER DEFAULT NULL)
783: RETURN VARCHAR2 IS

Line 806: FROM msc_pq_types

802: AND object_type = p_object_type;
803:
804: CURSOR c_and_or (p_object_type NUMBER) IS
805: SELECT COUNT(*)
806: FROM msc_pq_types
807: WHERE query_id = p_query_id
808: AND source_type = p_source_type
809: AND object_type = p_object_type
810: AND NVL(and_or_flag,1) = 1;

Line 943: FROM msc_pq_types

939: AND NVL(and_or_flag,1) = 1;
940:
941: CURSOR c_excp_and_or (p_object_type NUMBER) IS
942: SELECT COUNT(*)
943: FROM msc_pq_types
944: WHERE query_id = p_query_id
945: AND source_type = p_source_type
946: AND object_type = p_object_type
947: AND NVL(and_or_flag,1) = 1;

Line 1109: FROM msc_pq_types

1105: SELECT object_type,
1106: source_type,
1107: sequence_id,
1108: and_or_flag
1109: FROM msc_pq_types
1110: WHERE query_id = p_query_id
1111: AND active_flag = 1
1112: ORDER BY sequence_id;
1113:

Line 1764: FROM msc_pq_types mpt

1760: OR (mpq.query_type = 6)); --loads
1761:
1762: CURSOR c_ord_qry(p_query_id IN NUMBER) IS
1763: SELECT mpt.source_type, mpt.object_type, mpt.sequence_id
1764: FROM msc_pq_types mpt
1765: WHERE mpt.query_id = p_query_id
1766: AND mpt.active_flag = 1;
1767:
1768: CURSOR c_validate_ord(p_query_id IN NUMBER,

Line 1774: msc_pq_types mpt,

1770: P_object_type IN NUMBER,
1771: P_sequence_id IN NUMBER) IS
1772: SELECT COUNT(*)
1773: FROM msc_selection_criteria msc,
1774: msc_pq_types mpt,
1775: msc_personal_queries mpq
1776: WHERE (mpq.query_id = mpt.query_id
1777: AND mpq.query_id = p_query_id
1778: AND mpt.active_flag = 1

Line 2364: FROM MSC_PQ_TYPES pqt

2360:
2361: PROCEDURE set_top_action(p_plan_id IN NUMBER, p_query_id IN NUMBER) IS
2362: cursor c_top_priority(p_PRIORITY in number) is
2363: SELECT nvl(pqt.DETAIL_QUERY_ID, pqt.query_id) query_id
2364: FROM MSC_PQ_TYPES pqt
2365: WHERE pqt.query_id = p_query_id
2366: and pqt.PRIORITY = p_priority;
2367: --AND pqt.DETAIL_QUERY_ID is not null;
2368: