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_ORG_DETAIL

Line 915: -- delete records from MSC_BIS_ORG_DETAIL table for the given PlanId, if any

911: /* implementation start here */
912: -- init global variables
913: g_ErrorCode := '';
914:
915: -- delete records from MSC_BIS_ORG_DETAIL table for the given PlanId, if any
916: BEGIN
917: DELETE FROM MSC_BIS_ORG_DETAIL WHERE PLAN_ID=PlanIdVar;
918: EXCEPTION WHEN others THEN
919: NULL; -- do nothing

Line 917: DELETE FROM MSC_BIS_ORG_DETAIL WHERE PLAN_ID=PlanIdVar;

913: g_ErrorCode := '';
914:
915: -- delete records from MSC_BIS_ORG_DETAIL table for the given PlanId, if any
916: BEGIN
917: DELETE FROM MSC_BIS_ORG_DETAIL WHERE PLAN_ID=PlanIdVar;
918: EXCEPTION WHEN others THEN
919: NULL; -- do nothing
920: END;
921:

Line 924: INSERT INTO MSC_BIS_ORG_DETAIL (PLAN_ID,

920: END;
921:
922: BEGIN
923: -- CODE GOES HERE
924: INSERT INTO MSC_BIS_ORG_DETAIL (PLAN_ID,
925: SR_INSTANCE_ID,
926: ORGANIZATION_ID,
927: DETAIL_DATE,
928: FACILITY_COST,