APPS.MSC_UNDO dependencies on MSC_UNDO_DETAILS

Line 42: from msc_undo_details

38: select column_changed,
39: old_value,
40: new_value,
41: column_type
42: from msc_undo_details
43: where plan_id = v_plan_id
44: and undo_id = v_undo_id;
45: cursor c_supp (v_plan_id number, v_undo_id number) is
46: select undo_id,transaction_id, sr_instance_id

Line 90: Delete from msc_undo_details

86: Begin
87: -- if (l_table_changed in ( 3,4) ) then
88: -- cholpon
89: if (l_table_changed in ( 3,4, 8 ) ) then
90: Delete from msc_undo_details
91: where plan_id = l_plan_id
92: and (undo_id = l_undo_id
93: or undo_id in ( select undo_id
94: from msc_undo_summary

Line 163: Delete from msc_undo_details

159: --end undo update table
160: Begin
161: if (l_table_changed in (3,4) ) then
162:
163: Delete from msc_undo_details
164: where plan_id = l_plan_id
165: and (undo_id = l_undo_id
166: or undo_id in ( select undo_id
167: from msc_undo_summary

Line 176: Delete from msc_undo_details

172: where plan_id = l_plan_id
173: and (undo_id = l_undo_id
174: or parent_id = l_undo_id);
175: else
176: Delete from msc_undo_details
177: where plan_id = l_plan_id
178: and undo_id = l_undo_id;
179:
180: Delete from msc_undo_summary

Line 327: INSERT INTO MSC_UNDO_DETAILS (

323: l_old_value := changed_values(i).Old_Value ;
324: l_new_value := changed_values(i).New_Value ;
325:
326: BEGIN
327: INSERT INTO MSC_UNDO_DETAILS (
328: UNDO_ID,
329: PLAN_ID,
330: COLUMN_CHANGED,
331: COLUMN_CHANGED_TEXT,

Line 462: msc_undo_details b

458: b.old_value,
459: a.action,
460: b.column_changed
461: from msc_undo_summary a,
462: msc_undo_details b
463: where a.undo_id = b.undo_id (+)
464: and (a.undo_id = l_undo_id
465: or a.parent_id = l_undo_id);
466:

Line 685: msc_undo_details b

681: b.old_value,
682: a.action,
683: b.column_changed
684: from msc_undo_summary a,
685: msc_undo_details b
686: where a.undo_id = b.undo_id (+)
687: and (a.undo_id = l_undo_id
688: or a.parent_id = l_undo_id);
689: l_column_name varchar2(30);