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.

[Home] [Help]

APPS.MSC_WS_SNO_PUBLISH dependencies on MSC_BIS_RES_SUMMARY

Line 1443: DELETE FROM MSC_BIS_RES_SUMMARY WHERE PLAN_ID=PlanIdVar;

1439:
1440:
1441: -- delete records from MSC_RES_SUMMARY table for the given PlanId, if any
1442: BEGIN
1443: DELETE FROM MSC_BIS_RES_SUMMARY WHERE PLAN_ID=PlanIdVar;
1444: EXCEPTION WHEN others THEN
1445: NULL; -- do nothing
1446: END;
1447:

Line 1457: INSERT INTO MSC_BIS_RES_SUMMARY (PLAN_ID,

1453:
1454: BEGIN
1455: -- CODE GOES HERE
1456: -- insert records from MSC_INT_ASCP_MACHINE_UTIL
1457: INSERT INTO MSC_BIS_RES_SUMMARY (PLAN_ID,
1458: ORGANIZATION_ID,
1459: SR_INSTANCE_ID,
1460: DEPARTMENT_ID,
1461: RESOURCE_ID,

Line 1499: INSERT INTO MSC_BIS_RES_SUMMARY (PLAN_ID,

1495:
1496: BEGIN
1497: -- CODE GOES HERE
1498: -- insert records from MSC_INT_ASCP_LABOUR_UTIL
1499: INSERT INTO MSC_BIS_RES_SUMMARY (PLAN_ID,
1500: ORGANIZATION_ID,
1501: SR_INSTANCE_ID,
1502: DEPARTMENT_ID,
1503: RESOURCE_ID,