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.MST_AUDIT_REP_EXCP dependencies on MST_EXCEPTIONS_S

Line 41: VALUES (mst_exceptions_s.nextval, plan_idIn, 700, 704, 0, userIdIn,

37: --Create fresh entry for exception and keep exception_id for updates in details table
38: INSERT INTO mst_exceptions (exception_id, plan_id, exception_group, exception_type, exception_count,
39: created_by, last_updated_by, LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,
40: CREATION_DATE)
41: VALUES (mst_exceptions_s.nextval, plan_idIn, 700, 704, 0, userIdIn,
42: userIdIn,-1,sysdate, sysdate);
43:
44: SELECT exception_id INTO excptnId
45: FROM mst_exceptions

Line 126: VALUES (mst_exceptions_s.nextval, plan_idIn, 900, 900, 0, userIdIn,

122: --Create fresh entry for exception and keep exception_id for updates in details table
123: INSERT INTO mst_exceptions (exception_id, plan_id, exception_group, exception_type, exception_count,
124: created_by, last_updated_by, LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,
125: CREATION_DATE)
126: VALUES (mst_exceptions_s.nextval, plan_idIn, 900, 900, 0, userIdIn,
127: userIdIn,-1,sysdate, sysdate);
128:
129: SELECT exception_id INTO excptnId
130: FROM mst_exceptions

Line 207: VALUES (mst_exceptions_s.nextval, plan_idIn, 200, 219, 0, userIdIn,

203: --Create fresh entry for exception and keep exception_id for updates in details table
204: INSERT INTO mst_exceptions (exception_id, plan_id, exception_group, exception_type, exception_count,
205: created_by, last_updated_by, LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,
206: CREATION_DATE)
207: VALUES (mst_exceptions_s.nextval, plan_idIn, 200, 219, 0, userIdIn,
208: userIdIn,-1,sysdate, sysdate);
209:
210: SELECT exception_id INTO excptnId
211: FROM mst_exceptions

Line 406: VALUES (mst_exceptions_s.nextval, plan_idIn, 900, 902, 0,userIdIn,

402: --insert entry in mst_exceptions
403: INSERT INTO mst_exceptions (exception_id, plan_id, exception_group, exception_type, exception_count,
404: created_by, last_updated_by, LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,
405: CREATION_DATE)
406: VALUES (mst_exceptions_s.nextval, plan_idIn, 900, 902, 0,userIdIn,
407: userIdIn,-1,sysdate, sysdate);
408:
409: SELECT exception_id INTO excptnId
410: FROM mst_exceptions

Line 600: VALUES (mst_exceptions_s.nextval, plan_idIn, 900, 903, 0, userIdIn,

596: --insert entry in mst_exceptions
597: INSERT INTO mst_exceptions (exception_id, plan_id, exception_group, exception_type, exception_count,
598: created_by, last_updated_by, LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,
599: CREATION_DATE)
600: VALUES (mst_exceptions_s.nextval, plan_idIn, 900, 903, 0, userIdIn,
601: userIdIn,-1,sysdate, sysdate);
602:
603:
604: SELECT exception_id INTO excptnId

Line 769: VALUES (mst_exceptions_s.nextval, plan_idIn, 900, 904, 0, userIdIn,

765: --insert entry in mst_exceptions
766: INSERT INTO mst_exceptions (exception_id, plan_id, exception_group, exception_type, exception_count,
767: created_by, last_updated_by, LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,
768: CREATION_DATE)
769: VALUES (mst_exceptions_s.nextval, plan_idIn, 900, 904, 0, userIdIn,
770: userIdIn,-1,sysdate, sysdate);
771:
772: SELECT exception_id INTO excptnId
773: FROM mst_exceptions

Line 906: VALUES (mst_exceptions_s.nextval, plan_idIn, 900, 905, 0, userIdIn,

902: --insert entry in mst_exceptions
903: INSERT INTO mst_exceptions (exception_id, plan_id, exception_group, exception_type, exception_count,
904: created_by, last_updated_by, LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,
905: CREATION_DATE)
906: VALUES (mst_exceptions_s.nextval, plan_idIn, 900, 905, 0, userIdIn,
907: userIdIn,-1,sysdate, sysdate);
908:
909: SELECT exception_id INTO excptnId
910: FROM mst_exceptions

Line 1035: VALUES (mst_exceptions_s.nextval, plan_idIn, 100, 104, 0, userIdIn,

1031: --Create fresh entry for exception and keep exception_id for updates in details table
1032: INSERT INTO mst_exceptions (exception_id, plan_id, exception_group, exception_type, exception_count,
1033: created_by, last_updated_by, LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,
1034: CREATION_DATE)
1035: VALUES (mst_exceptions_s.nextval, plan_idIn, 100, 104, 0, userIdIn,
1036: userIdIn,-1,sysdate, sysdate);
1037:
1038: SELECT exception_id INTO excptnId
1039: FROM mst_exceptions

Line 1174: VALUES (mst_exceptions_s.nextval, plan_idIn, 100, 105, 0, userIdIn,

1170: --Create fresh entry for exception and keep exception_id for updates in details table
1171: INSERT INTO mst_exceptions (exception_id, plan_id, exception_group, exception_type, exception_count,
1172: created_by, last_updated_by, LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,
1173: CREATION_DATE)
1174: VALUES (mst_exceptions_s.nextval, plan_idIn, 100, 105, 0, userIdIn,
1175: userIdIn,-1,sysdate, sysdate);
1176:
1177: SELECT exception_id INTO excptnId
1178: FROM mst_exceptions

Line 1400: VALUES (mst_exceptions_s.nextval,plan_idIn, 400, 404, 0, userIdIn,

1396: --insert entry in mst_exceptions
1397: INSERT INTO mst_exceptions (exception_id, plan_id, exception_group, exception_type, exception_count,
1398: created_by, last_updated_by, LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,
1399: CREATION_DATE)
1400: VALUES (mst_exceptions_s.nextval,plan_idIn, 400, 404, 0, userIdIn,
1401: userIdIn,-1,sysdate, sysdate);
1402:
1403: SELECT exception_id INTO excptnId
1404: FROM mst_exceptions

Line 1600: VALUES (mst_exceptions_s.nextval, plan_idIn, 400, 405, 0, userIdIn,

1596: --insert entry in mst_exceptions
1597: INSERT INTO mst_exceptions (exception_id, plan_id, exception_group, exception_type, exception_count,
1598: created_by, last_updated_by, LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,
1599: CREATION_DATE)
1600: VALUES (mst_exceptions_s.nextval, plan_idIn, 400, 405, 0, userIdIn,
1601: userIdIn,-1,sysdate, sysdate);
1602:
1603: SELECT exception_id INTO excptnId
1604: FROM mst_exceptions