APPS.MSC_WS_SNO_PUBLISH dependencies on MSC_INT_ITEM_TRAVEL_DISTANCE

Line 2253: TO_DATE( MSC_INT_ITEM_TRAVEL_DISTANCE.Period_End,'YYYY-MM-DD' )-1/86400,

2249: SR_INSTANCE_ID,
2250: INVENTORY_ITEM_ID,
2251: PERIOD_TYPE, -- DETAIL_LEVEL
2252: 1, --PERIOD_TYPE
2253: TO_DATE( MSC_INT_ITEM_TRAVEL_DISTANCE.Period_End,'YYYY-MM-DD' )-1/86400,
2254: TRANSPORTATION_MODE,
2255: ITEM_TRAVEL_DISTANCE,
2256: 0,
2257: 0,

Line 2268: FROM MSC_INT_ITEM_TRAVEL_DISTANCE

2264: -23453, --CUSTOMER_SITE_ID
2265: SYSDATE, '-1',
2266: SYSDATE, '-1',
2267: -1
2268: FROM MSC_INT_ITEM_TRAVEL_DISTANCE
2269: WHERE PLAN_ID=PlanIdVar;
2270: EXCEPTION WHEN others THEN
2271: g_ErrorCode := 'ERROR_UPDATE_BIS_INV_DETAIL_001011' || ' : ' || SQLERRM;
2272: raise;

Line 3200: -- ... first clear the records from MSC_INT_ITEM_TRAVEL_DISTANCE table for the given PlanIdVar if any

3196:
3197:
3198: -- call SET_ASCP_BIS_INV_DETAIL ( procedure #8 ) -- IN for SOP - however ...
3199:
3200: -- ... first clear the records from MSC_INT_ITEM_TRAVEL_DISTANCE table for the given PlanIdVar if any
3201: -- ... 'cause for SOP there should not be any in there
3202: BEGIN
3203: DELETE FROM MSC_INT_ITEM_TRAVEL_DISTANCE WHERE PLAN_ID=PlanIdVar;
3204: EXCEPTION WHEN others THEN

Line 3203: DELETE FROM MSC_INT_ITEM_TRAVEL_DISTANCE WHERE PLAN_ID=PlanIdVar;

3199:
3200: -- ... first clear the records from MSC_INT_ITEM_TRAVEL_DISTANCE table for the given PlanIdVar if any
3201: -- ... 'cause for SOP there should not be any in there
3202: BEGIN
3203: DELETE FROM MSC_INT_ITEM_TRAVEL_DISTANCE WHERE PLAN_ID=PlanIdVar;
3204: EXCEPTION WHEN others THEN
3205: NULL; -- do nothing
3206: END;
3207: