APPS.MST_PQ_WORKS dependencies on MST_PERSONAL_QUERIES

Line 31: FROM MST_PERSONAL_QUERIES

27: CURSOR CUR_QUERY IS
28: SELECT QUERY_TYPE , PUBLIC_FLAG,
29: AND_OR_FLAG , APPLIES_TO,
30: EXECUTE_FLAG
31: FROM MST_PERSONAL_QUERIES
32: WHERE QUERY_ID = P_QUERY_ID;
33:
34: CURSOR cur_definition IS
35: SELECT msc.QUERY_ID , msc.FIELD_NAME ,

Line 80: l_update_str := 'UPDATE MST_PERSONAL_QUERIES SET EXECUTE_FLAG = 2 WHERE QUERY_ID = :P_QUERY_ID';

76: l_insert_str := 'INSERT INTO MST_PERSONAL_QUERY_RESULTS ';
77: BEGIN
78: l_delete_str := 'DELETE MST_PERSONAL_QUERY_RESULTS WHERE QUERY_ID = :P_QUERY_ID AND PLAN_ID=:P_PLAN_ID';
79: EXECUTE IMMEDIATE(l_delete_str) USING p_query_id,p_plan_id;
80: l_update_str := 'UPDATE MST_PERSONAL_QUERIES SET EXECUTE_FLAG = 2 WHERE QUERY_ID = :P_QUERY_ID';
81: l_executed:= execute_dyn_sql(l_update_str, p_query_id);
82: EXCEPTION
83: WHEN no_data_Found THEN
84: NULL;

Line 869: DELETE mst_personal_queries

865: P_QUERY_TYPE IN NUMBER) IS
866: --pragma autonomous_transaction;
867: BEGIN
868:
869: DELETE mst_personal_queries
870: WHERE query_id = p_query_id;
871: IF NOT sql%FOUND THEN
872: RETURN;
873: END IF;

Line 903: UPDATE mst_personal_queries

899: p_query_name IN VARCHAR2,
900: p_description IN VARCHAR2,
901: p_public_flag IN NUMBER) IS
902: BEGIN
903: UPDATE mst_personal_queries
904: SET query_name = p_query_name,
905: description = p_description,
906: public_flag = p_public_flag
907: WHERE query_id = p_query_id;

Line 4213: SELECT 'x' FROM mst_personal_queries

4209: END insert_excep_selection;
4210:
4211: PROCEDURE save_query_result(p_query_id IN NUMBER) IS
4212: CURSOR query_def IS
4213: SELECT 'x' FROM mst_personal_queries
4214: WHERE query_id = p_query_id
4215: FOR UPDATE OF execute_flag NOWAIT;
4216: l_dummy VARCHAR2(1);
4217: BEGIN

Line 4221: UPDATE mst_personal_queries

4217: BEGIN
4218: OPEN query_def;
4219: FETCH query_def INTO l_dummy;
4220: IF query_def%FOUND THEN
4221: UPDATE mst_personal_queries
4222: SET execute_flag = 1
4223: WHERE CURRENT OF query_def;
4224: commit;
4225: END IF;

Line 4235: FROM mst_personal_queries

4231:
4232: PROCEDURE clear_temp_query(p_query_id IN NUMBER) IS
4233: CURSOR cur_temp_qry IS
4234: SELECT query_id, query_type
4235: FROM mst_personal_queries
4236: WHERE query_id = p_query_id; -- Temp. Query
4237:
4238: l_temp_qry cur_temp_qry%ROWTYPE;
4239: