APPS.MSC_UPDATE_RESOURCE dependencies on MSC_UNDO

Line 331: net_res_columns msc_undo.changeRGType;

327: Function insert_undo_data(undo_type number,
328: j number default null,
329: v_undo_parent_id number default null) return number is
330: v_undo_id number;
331: net_res_columns msc_undo.changeRGType;
332: x_return_sts varchar2(100);
333: x_msg_count number;
334: x_msg_data varchar2(200);
335: i number;

Line 338: select msc_undo_summary_s.nextval

334: x_msg_data varchar2(200);
335: i number;
336: begin
337:
338: select msc_undo_summary_s.nextval
339: into v_undo_id
340: from dual;
341:
342: if undo_type = 2 then -- update

Line 379: msc_undo.store_undo(4, --means msc_net_resource_avail

375: end if;
376:
377: end if;
378:
379: msc_undo.store_undo(4, --means msc_net_resource_avail
380: undo_type, --2 is update , 1 is insert a record
381: g_tmp_tab(k).transaction_id,
382: g_plan_id,
383: g_instance_id,

Line 404: net_res_columns msc_undo.changeRGType;

400: v_old_to_time varchar2, v_new_to_time varchar2,
401: v_old_units varchar2, v_new_units varchar2,
402: v_undo_parent_id number default null) return number is
403: v_undo_id number;
404: net_res_columns msc_undo.changeRGType;
405: x_return_sts varchar2(100);
406: x_msg_count number;
407: x_msg_data varchar2(200);
408: begin

Line 409: select msc_undo_summary_s.nextval

405: x_return_sts varchar2(100);
406: x_msg_count number;
407: x_msg_data varchar2(200);
408: begin
409: select msc_undo_summary_s.nextval
410: into v_undo_id
411: from dual;
412:
413: if undo_type = 2 then -- update

Line 451: msc_undo.store_undo(8, --means msc_net_resource_avail

447: net_res_columns(i).column_type := 'NUMBER';
448: net_res_columns(i).new_value := to_char(v_new_units);
449: end if;
450:
451: msc_undo.store_undo(8, --means msc_net_resource_avail
452: undo_type, --2 is update , 1 is insert a record
453: v_trx_id,
454: g_plan_id,
455: g_instance_id,