eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_UNDO dependencies on MSC_UNDO_SUMMARY

Line 34: from msc_undo_summary

30: sr_instance_id,
31: table_changed,
32: action,
33: last_update_date
34: from msc_undo_summary
35: where undo_id = v_undo_id;
36:
37: cursor c_dtl(v_plan_id number, v_undo_id number) is
38: select column_changed,

Line 47: from msc_undo_summary

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
47: from msc_undo_summary
48: where plan_id = v_plan_id
49: and ( undo_id = v_undo_id
50: or parent_id = v_undo_id )
51: and table_changed = 3

Line 94: from msc_undo_summary

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
95: where plan_id = l_plan_id
96: and parent_id = l_undo_id));
97:
98: Delete from msc_undo_summary

Line 98: Delete from msc_undo_summary

94: from msc_undo_summary
95: where plan_id = l_plan_id
96: and parent_id = l_undo_id));
97:
98: Delete from msc_undo_summary
99: where plan_id = l_plan_id
100: and (undo_id = l_undo_id
101: or parent_id = l_undo_id);
102: else

Line 103: Delete from msc_undo_summary

99: where plan_id = l_plan_id
100: and (undo_id = l_undo_id
101: or parent_id = l_undo_id);
102: else
103: Delete from msc_undo_summary
104: where plan_id = l_plan_id
105: and undo_id = l_undo_id;
106:
107: Delete from msc_undo_summary

Line 107: Delete from msc_undo_summary

103: Delete from msc_undo_summary
104: where plan_id = l_plan_id
105: and undo_id = l_undo_id;
106:
107: Delete from msc_undo_summary
108: where plan_id = l_plan_id
109: and undo_id = l_undo_id;
110: end if;
111: Exception

Line 167: from msc_undo_summary

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
168: where plan_id = l_plan_id
169: and parent_id = l_undo_id));
170:
171: Delete from msc_undo_summary

Line 171: Delete from msc_undo_summary

167: from msc_undo_summary
168: where plan_id = l_plan_id
169: and parent_id = l_undo_id));
170:
171: Delete from msc_undo_summary
172: where plan_id = l_plan_id
173: and (undo_id = l_undo_id
174: or parent_id = l_undo_id);
175: else

Line 180: Delete from msc_undo_summary

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
181: where plan_id = l_plan_id
182: and undo_id = l_undo_id;
183:
184: end if;

Line 197: Delete from msc_undo_summary

193: End ;
194:
195: elsif (l_action in (3)) then
196: Begin
197: Delete from msc_undo_summary
198: where plan_id = l_plan_id
199: and undo_id = l_undo_id;
200: Exception
201: When others then

Line 274: select MSC_UNDO_SUMMARY_S.nextval

270: return;
271: end if;
272: BEGIN
273: if ( table_changed in (1,2,5,6,7) ) then
274: select MSC_UNDO_SUMMARY_S.nextval
275: into v_undo_id
276: from dual;
277: else
278: v_undo_id := undo_id;

Line 280: --Insert a record into MSC_UNDO_SUMMARY

276: from dual;
277: else
278: v_undo_id := undo_id;
279: end if;
280: --Insert a record into MSC_UNDO_SUMMARY
281: INSERT INTO MSC_UNDO_SUMMARY (
282: undo_id,
283: plan_id,
284: sr_instance_id,

Line 281: INSERT INTO MSC_UNDO_SUMMARY (

277: else
278: v_undo_id := undo_id;
279: end if;
280: --Insert a record into MSC_UNDO_SUMMARY
281: INSERT INTO MSC_UNDO_SUMMARY (
282: undo_id,
283: plan_id,
284: sr_instance_id,
285: created_by,

Line 396: SELECT MSC_UNDO_SUMMARY_S.nextval

392: ||' Invalid Action passed to MSC_UNDO.add_bookmark';
393: FND_MSG_PUB.count_and_get(p_count =>x_msg_count,
394: p_data=>x_msg_data );
395: ELSE
396: SELECT MSC_UNDO_SUMMARY_S.nextval
397: INTO v_undo_id
398: from dual;
399:
400: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 402: --Insert a record into MSC_UNDO_SUMMARY

398: from dual;
399:
400: x_return_status := FND_API.G_RET_STS_SUCCESS;
401:
402: --Insert a record into MSC_UNDO_SUMMARY
403: INSERT INTO MSC_UNDO_SUMMARY (
404: undo_id,
405: plan_id,
406: sr_instance_id,

Line 403: INSERT INTO MSC_UNDO_SUMMARY (

399:
400: x_return_status := FND_API.G_RET_STS_SUCCESS;
401:
402: --Insert a record into MSC_UNDO_SUMMARY
403: INSERT INTO MSC_UNDO_SUMMARY (
404: undo_id,
405: plan_id,
406: sr_instance_id,
407: created_by,

Line 461: from msc_undo_summary a,

457: a.transaction_id,
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);

Line 536: from msc_undo_summary

532: --Msc_supplier_capacities
533: /*
534: Delete from msc_supplier_capacities
535: where transaction_id in (select transaction_id
536: from msc_undo_summary
537: where plan_id = p_plan_id
538: and (undo_id = p_undo_id or parent_id = p_undo_id))
539: and plan_id = p_plan_id ;
540: */

Line 547: from msc_undo_summary

543: status = 0,
544: applied = 2
545: where plan_id = p_plan_id
546: and transaction_id in (select transaction_id
547: from msc_undo_summary
548: where plan_id = p_plan_id
549: and (undo_id = p_undo_id or parent_id = p_undo_id));
550: elsif ( p_table_changed in ( 4, 8) ) then
551: --Msc_net_resource_Avail

Line 684: from msc_undo_summary a,

680: a.transaction_id,
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);

Line 870: from msc_undo_summary_v

866: cursor c_mst (l_undo_id NUMBER) is
867: select plan_id, sr_instance_id, transaction_id, table_changed, action,
868: last_updated_by, last_update_date, identifier1_name, identifier2_name,
869: identifier3_name
870: from msc_undo_summary_v
871: where undo_id = l_undo_id;
872:
873: cursor c_noundo_same1 (v_plan_id number,
874: v_sr_instance_id number,

Line 879: from msc_undo_summary

875: v_table_changed number,
876: v_user number,
877: v_date date) is
878: select count(undo_id)
879: from msc_undo_summary
880: where plan_id = v_plan_id
881: and sr_instance_id = v_sr_instance_id
882: and table_changed = v_table_changed
883: and last_updated_by = v_user

Line 895: from msc_undo_summary

891: v_table_changed number,
892: v_user number,
893: v_date date) is
894: select count(undo_id)
895: from msc_undo_summary
896: where plan_id = v_plan_id
897: and sr_instance_id = v_sr_instance_id
898: and transaction_id = v_transaction_id
899: and table_changed = v_table_changed

Line 909: from msc_undo_summary

905: cursor c_noundo_diff1 (v_plan_id number, v_sr_instance_id number,
906: v_table_changed number, v_user number,
907: v_date date) is
908: select count(undo_id)
909: from msc_undo_summary
910: where plan_id = v_plan_id
911: and sr_instance_id = v_sr_instance_id
912: and table_changed = v_table_changed
913: and last_updated_by <> v_user

Line 922: from msc_undo_summary

918: cursor c_noundo_diff2 (v_plan_id number, v_sr_instance_id number,
919: v_transaction_id number, v_table_changed number,
920: v_user number, v_date date) is
921: select count(undo_id)
922: from msc_undo_summary
923: where plan_id = v_plan_id
924: and sr_instance_id = v_sr_instance_id
925: and transaction_id = v_transaction_id
926: and table_changed = v_table_changed

Line 942: from msc_undo_summary

938: and plan_id = v_plan_id ;
939:
940: cursor c_olprun (v_plan_id number) is
941: select undo_id
942: from msc_undo_summary
943: where plan_id = v_plan_id
944: and action = 4;
945:
946: v_temp number;