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_WS_SNO_PUBLISH dependencies on MSC_BIS_RES_SUMMARY

Line 1552: DELETE FROM MSC_BIS_RES_SUMMARY WHERE PLAN_ID=PlanIdVar;

1548:
1549:
1550: -- delete records from MSC_RES_SUMMARY table for the given PlanId, if any
1551: BEGIN
1552: DELETE FROM MSC_BIS_RES_SUMMARY WHERE PLAN_ID=PlanIdVar;
1553: EXCEPTION WHEN others THEN
1554: NULL; -- do nothing
1555: END;
1556:

Line 1566: INSERT INTO MSC_BIS_RES_SUMMARY (PLAN_ID,

1562:
1563: BEGIN
1564: -- CODE GOES HERE
1565: -- insert records from MSC_INT_ASCP_MACHINE_UTIL
1566: INSERT INTO MSC_BIS_RES_SUMMARY (PLAN_ID,
1567: ORGANIZATION_ID,
1568: SR_INSTANCE_ID,
1569: DEPARTMENT_ID,
1570: RESOURCE_ID,

Line 1630: INSERT INTO MSC_BIS_RES_SUMMARY (PLAN_ID,

1626:
1627: BEGIN
1628: -- CODE GOES HERE
1629: -- insert records from MSC_INT_ASCP_LABOUR_UTIL
1630: INSERT INTO MSC_BIS_RES_SUMMARY (PLAN_ID,
1631: ORGANIZATION_ID,
1632: SR_INSTANCE_ID,
1633: DEPARTMENT_ID,
1634: RESOURCE_ID,