DBA Data[Home] [Help]

APPS.MSC_CL_OTHER_ODS_LOAD dependencies on MSC_WO_OPERATION_REL

Line 5270: DELETE MSC_WO_OPERATION_REL

5266:
5267: FOR c_rec IN c_del LOOP
5268: BEGIN
5269:
5270: DELETE MSC_WO_OPERATION_REL
5271: WHERE SR_INSTANCE_ID= c_rec.sr_instance_id
5272: AND SUPPLY_ID = c_rec.supply_id
5273: AND FROM_OP_SEQ_NUM = c_rec.FROM_OP_SEQ_NUM
5274: AND nvl(FROM_OP_RES_SEQ_NUM,-1) = nvl(c_rec.FROM_OP_RES_SEQ_NUM,-1)

Line 5294: UPDATE MSC_WO_OPERATION_REL

5290: FOR c_rec IN c1 LOOP
5291:
5292: BEGIN
5293: IF MSC_CL_COLLECTION.v_is_legacy_refresh THEN
5294: UPDATE MSC_WO_OPERATION_REL
5295: SET
5296: PRECEDENCE_CONSTRAINT = c_rec.PRECEDENCE_CONSTRAINT,
5297: FROM_OP_DESC = c_rec.FROM_OP_DESC,
5298: TO_OP_DESC = c_rec.TO_OP_DESC,

Line 5317: INSERT INTO MSC_WO_OPERATION_REL (

5313:
5314: END IF;
5315: IF (MSC_CL_COLLECTION.v_is_complete_refresh or MSC_CL_COLLECTION.v_is_partial_refresh) OR (MSC_CL_COLLECTION.v_is_legacy_refresh AND SQL%NOTFOUND) THEN
5316:
5317: INSERT INTO MSC_WO_OPERATION_REL (
5318: SUPPLY_ID,
5319: PRECEDENCE_CONSTRAINT,
5320: MIN_SEPARATION,
5321: MIN_SEP_TIME_UNIT,