APPS.MST_WB_UTIL dependencies on MST_EXCEPTIONS

Line 5745: delete from MST_EXCEPTIONS

5741:
5742: delete from MST_EXCEPTION_DETAILS
5743: where plan_id = p_plan_id;
5744:
5745: delete from MST_EXCEPTIONS
5746: where plan_id = p_plan_id;
5747:
5748: delete from MST_FILES
5749: where plan_id = p_plan_id;

Line 5912: from mst_exceptions

5908:
5909: cursor Cur_Exp_Details (l_Plan_Id IN NUMBER, l_Dummy IN NUMBER)
5910: is
5911: select exception_type
5912: from mst_exceptions
5913: where plan_id = l_plan_id
5914: and exception_count_context = l_dummy;
5915:
5916: type number_tab_type is table of number index by binary_integer;

Line 5920: execute immediate 'update mst_exceptions

5916: type number_tab_type is table of number index by binary_integer;
5917: l_Exception_Type_Tab number_tab_type;
5918: l_Count_Tab number_tab_type;
5919: begin
5920: execute immediate 'update mst_exceptions
5921: set exception_count_context = -9999
5922: where '||p_Exp_Summary_Where_Clause;
5923:
5924: open Cur_Exp_Details (p_Plan_Id, -9999);

Line 5936: update mst_exceptions

5932: where '||replace(p_Exp_Details_Where_Clause,'!~!',l_Exception_Type_Tab(i))
5933: into l_Count_Tab(i);
5934: end loop;
5935: forall i in 1..l_Exception_Type_Tab.last
5936: update mst_exceptions
5937: set exception_count_context = l_count_Tab(i)
5938: where Plan_id = p_Plan_Id
5939: and exception_type = l_Exception_Type_Tab(i);
5940: commit;