APPS.MST_PQ_WORKS dependencies on MST_PERSONAL_QUERY_RESULTS

Line 65: l_insert_str VARCHAR2(200) ; --:= 'INSERT INTO MST_PERSONAL_QUERY_RESULTS ';

61: l_fetch_required BOOLEAN ;
62: l_changed CONSTANT VARCHAR2(4):='@<~#';
63:
64: l_user NUMBER ; --:= TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
65: l_insert_str VARCHAR2(200) ; --:= 'INSERT INTO MST_PERSONAL_QUERY_RESULTS ';
66: l_insert_Col VARCHAR2(200) ;
67: l_select_str VARCHAR2(2000);
68: l_executed NUMBER ;
69: l_update_str VARCHAR2(500);

Line 76: l_insert_str := 'INSERT INTO MST_PERSONAL_QUERY_RESULTS ';

72: related_field_notfound EXCEPTION;
73: BEGIN
74: l_fetch_required := TRUE;
75: l_user := TO_NUMBER(FND_PROFILE.VALUE('USER_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';

Line 78: l_delete_str := 'DELETE MST_PERSONAL_QUERY_RESULTS WHERE QUERY_ID = :P_QUERY_ID AND PLAN_ID=:P_PLAN_ID';

74: l_fetch_required := TRUE;
75: l_user := TO_NUMBER(FND_PROFILE.VALUE('USER_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

Line 853: DELETE mst_personal_query_results

849:
850: PROCEDURE remove_query(P_QUERY_ID IN NUMBER,
851: P_QUERY_TYPE IN NUMBER) IS
852: BEGIN
853: DELETE mst_personal_query_results
854: WHERE query_id = p_query_id;
855: --IF p_query_type IN (1,2,3,4) THEN
856: DELETE mst_selection_criteria
857: WHERE query_id = p_query_id;

Line 887: DELETE mst_personal_query_results

883: ELSIF P_QUERY_TYPE = 4 THEN
884: DELETE MST_EXCEP_SELECTION_CRITERIA
885: WHERE query_id = p_query_id;
886: END IF;
887: DELETE mst_personal_query_results
888: WHERE query_id = p_query_id;
889:
890: DELETE mst_selection_criteria
891: WHERE query_id = p_query_id;