Purge Interface Tables

2. 'Purge Interface Tables' concurrent program:

MSCPST module: Purge Interface Tables

This concurrent program deletes the records from the MSC staging tables.

It takes instance_code as a 1st parameter and deletes records for the instance only when st_status for this instance is not in G_ST_PULLING,G_ST_COLLECTING and G_ST_PRE_PROCESSING (if the tables are not currently in use).If the instance_code is null then it will delete records from all instances after checking the st_status.
It also takes a 2nd parameter , whether to delete only errored out records or all legacy data. The check for st_status before deletion will only take place when 'delete only rejected records’ parameter is set to NO.

This package (file name = MSCCLPSB.pls) is used to PURGE LEGACY DATA OF INTERFACE TABLES
It is deleting records from the following tables:
MSC_ST_BOMS
MSC_ST_BOM_COMPONENTS
MSC_ST_CALENDARS
MSC_ST_CALENDAR_EXCEPTIONS
MSC_ST_CATEGORY_SETS
MSC_ST_COMPANY_USERS
MSC_ST_COMPONENT_SUBSTITUTES
MSC_ST_CO_PRODUCTS
MSC_ST_DEMANDS
MSC_ST_DEMAND_CLASSES
MSC_ST_DEPARTMENT_RESOURCES
MSC_ST_DESIGNATORS
MSC_ST_GROUPS
MSC_ST_GROUP_COMPANIES
MSC_ST_INTERORG_SHIP_METHODS
MSC_ST_ITEM_CATEGORIES
MSC_ST_ITEM_CUSTOMERS
MSC_ST_ITEM_SOURCING
MSC_ST_ITEM_SUBSTITUTES
MSC_ST_ITEM_SUPPLIERS
MSC_ST_LOCATION_ASSOCIATIONS
MSC_ST_OPERATION_NETWORKS
MSC_ST_OPERATION_RESOURCES
MSC_ST_PARTNER_CONTACTS
MSC_ST_PLANNERS
MSC_ST_PROJECT_TASKS
MSC_ST_RESERVATIONS
MSC_ST_RESOURCE_CHANGES
MSC_ST_RESOURCE_GROUPS
MSC_ST_RESOURCE_REQUIREMENTS
MSC_ST_RESOURCE_SHIFTS
MSC_ST_ROUTINGS
MSC_ST_ROUTING_OPERATIONS
MSC_ST_SAFETY_STOCKS
MSC_ST_SALES_ORDERS
MSC_ST_SHIFT_EXCEPTIONS
MSC_ST_SHIFT_TIMES
MSC_ST_SUB_INVENTORIES
MSC_ST_SUPPLIER_CAPACITIES
MSC_ST_SUPPLIER_FLEX_FENCES
MSC_ST_SUPPLIES
MSC_ST_SYSTEM_ITEMS
MSC_ST_TRADING_PARTNERS
MSC_ST_TRADING_PARTNER_SITES
MSC_ST_UNITS_OF_MEASURE
MSC_ST_UOM_CLASS_CONVERSIONS
MSC_ST_UOM_CONVERSIONS
MSC_ST_WORKDAY_PATTERNS