APPS.MSC_X_WFNOTIFY_PKG dependencies on MSC_X_EXCEPTION_DETAILS

Line 91: from msc_x_exception_details ex

87: ex.line_number,
88: ex.end_order_number,
89: ex.end_order_rel_number,
90: ex.end_order_line_number
91: from msc_x_exception_details ex
92: where ex.plan_id = -1
93: and ex.exception_group in (1,2,3,4,5,6,7,8,9,10) --exclude user define exceptions
94: and ex.version = 'CURRENT'; --indicate the current run of the netting engine
95:

Line 262: l_item_desc msc_x_exception_details.item_description%type;

258: l_company_site_id Number;
259: l_company_site_name msc_sup_dem_entries.publisher_site_name%type;
260: l_item_id Number;
261: l_item_name msc_items.item_name%type;
262: l_item_desc msc_x_exception_details.item_description%type;
263: l_exception_group Number;
264: l_exception_type Number;
265: l_exception_type_name fnd_lookup_values.meaning%type;
266: l_supplier_id Number;

Line 307: l_exception_basis msc_x_exception_details.exception_basis%type;

303: l_planner_code Varchar2(500);
304: l_message_name Varchar2(100);
305: l_exist Number;
306: l_independent NUMBER; -- Bug #6242828
307: l_exception_basis msc_x_exception_details.exception_basis%type;
308:
309: t_ex_detail_id number_arr;
310: t_sr_ins_id number_arr;
311: t_company_id number_arr;

Line 890: update msc_x_exception_details

886: --Reset the records for which the workflows have been
887: --kicked off, to prevent the create duplicate wf items
888: --dbms_output.put_line('Done with wf notifications');
889: begin
890: update msc_x_exception_details
891: set version = null, last_update_login = null
892: where plan_id = -1
893: and version = 'CURRENT'
894: and exception_group in (1,2,3,4,5,6,7,8,9,10);