DBA Data[Home] [Help]

APPS.MSC_PURGE_LID dependencies on MSC_JOB_OPERATION_NETWORKS

Line 991: DELETE_MSC_TABLE('MSC_JOB_OPERATION_NETWORKS', v_instance_id, -1);

987: p_where_str => NULL );
988:
989: -------- Delete OSFM tables ---------------------------
990:
991: DELETE_MSC_TABLE('MSC_JOB_OPERATION_NETWORKS', v_instance_id, -1);
992: DELETE_MSC_TABLE('MSC_JOB_OPERATIONS', v_instance_id, -1);
993: DELETE_MSC_TABLE('MSC_JOB_REQUIREMENT_OPS', v_instance_id, -1);
994: DELETE_MSC_TABLE('MSC_JOB_OP_RESOURCES', v_instance_id, -1);
995:

Line 1205: DELETE FROM MSC_JOB_OPERATION_NETWORKS

1201: WHERE plan_id = -1 and
1202: sr_instance_id = v_instance_id and
1203: TRANSACTION_ID = lv_supplyId;
1204:
1205: DELETE FROM MSC_JOB_OPERATION_NETWORKS
1206: WHERE plan_id = -1 and
1207: sr_instance_id = v_instance_id and
1208: TRANSACTION_ID = lv_supplyId;
1209: