The following lines contain the word 'select', 'insert', 'update' or 'delete':
UPDATE MTH_ASSET_ERR SET
REPROCESS_READY_YN = p_reprocess_ready_yn
,ASSET_PK = p_asset_pk
,ASSET_NUMBER = p_asset_number
,ASSET_GROUP = p_asset_group
,MAINTENANCE_ORG_CODE = p_maintenance_org_code
,ASSET_GROUP_ID = p_asset_group_id
,SYSTEM_FK = p_system_fk
,ASSET_DESCRIPTION = p_asset_description
,SERIAL_NUMBER = p_serial_number
,ASSET_CATEGORY = p_asset_category
,OWNING_DEPARTMENT = p_owning_department
,ASSET_CRITICALITY = p_asset_criticality
,ACTIVE_FLAG = p_active_flag
,MAINTAINABLE_FLAG = p_maintainable_flag
,MTTR = p_mttr
,MTBF = p_mtbf
,ASSET_LOCATION = p_asset_location
,USER_ATTR1 = p_user_attr1
,USER_ATTR2 = p_user_attr2
,USER_ATTR3 = p_user_attr3
,USER_ATTR4 = p_user_attr4
,USER_ATTR5 = p_user_attr5
,USER_MEASURE1 = p_user_measure1
,USER_MEASURE2 = p_user_measure2
,USER_MEASURE3 = p_user_measure3
,USER_MEASURE4 = p_user_measure4
,USER_MEASURE5 = p_user_measure5
WHERE ROWID = p_rowid;
INSERT INTO MTH_ASSET_ERR (
REPROCESS_READY_YN
,ASSET_PK
,ASSET_NUMBER
,ASSET_GROUP
,MAINTENANCE_ORG_CODE
,ASSET_GROUP_ID
,SYSTEM_FK
,ASSET_DESCRIPTION
,SERIAL_NUMBER
,ASSET_CATEGORY
,OWNING_DEPARTMENT
,ASSET_CRITICALITY
,ACTIVE_FLAG
,MAINTAINABLE_FLAG
,MTTR
,MTBF
,ASSET_LOCATION
,USER_ATTR1
,USER_ATTR2
,USER_ATTR3
,USER_ATTR4
,USER_ATTR5
,USER_MEASURE1
,USER_MEASURE2
,USER_MEASURE3
,USER_MEASURE4
,USER_MEASURE5
) VALUES (
p_reprocess_ready_yn
,p_asset_pk
,p_asset_number
,p_asset_group
,p_maintenance_org_code
,p_asset_group_id
,p_system_fk
,p_asset_description
,p_serial_number
,p_asset_category
,p_owning_department
,p_asset_criticality
,p_active_flag
,p_maintainable_flag
,p_mttr
,p_mtbf
,p_asset_location
,p_user_attr1
,p_user_attr2
,p_user_attr3
,p_user_attr4
,p_user_attr5
,p_user_measure1
,p_user_measure2
,p_user_measure3
,p_user_measure4
,p_user_measure5
);
UPDATE MTH_DAY_ERR SET
REPROCESS_READY_YN = p_reprocess_ready_yn
,REPORT_DATE = fnd_date.canonical_to_date(p_report_date)
,USER_ATTR1 = p_user_attr1
,USER_ATTR2 = p_user_attr2
,USER_ATTR3 = p_user_attr3
,USER_ATTR4 = p_user_attr4
,USER_ATTR5 = p_user_attr5
,USER_MEASURE1 = p_user_measure1
,USER_MEASURE2 = p_user_measure2
,USER_MEASURE3 = p_user_measure3
,USER_MEASURE4 = p_user_measure4
,USER_MEASURE5 = p_user_measure5
,SYSTEM_FK = p_system_fk
WHERE ROWID = p_rowid;
UPDATE MTH_DIM_HIERARCHY_ERR SET
REPROCESS_READY_YN = p_reprocess_ready_yn
,DIMENSION_NAME = p_dimension_name
,HIERARCHY_NAME = p_hierarchy_name
,CATEGORY_SET_NAME = p_category_set_name
,HIERARCHY_DISPLAY_NAME = p_hierarchy_display_name
,NUMBER_OF_LEVEL = p_number_of_level
,PROCESSING_FLAG = p_processing_flag
WHERE ROWID = p_rowid;
INSERT INTO MTH_DIM_HIERARCHY_ERR (
REPROCESS_READY_YN
,DIMENSION_NAME
,HIERARCHY_NAME
,CATEGORY_SET_NAME
,HIERARCHY_DISPLAY_NAME
,NUMBER_OF_LEVEL
,PROCESSING_FLAG
) VALUES (
p_reprocess_ready_yn
,p_dimension_name
,p_hierarchy_name
,p_category_set_name
,p_hierarchy_display_name
,p_number_of_level
,p_processing_flag
);
UPDATE MTH_DIM_LEVEL_LOOKUP_ERR SET
REPROCESS_READY_YN = p_reprocess_ready_yn
,HIERARCHY_NAME = p_hierarchy_name
,DIMENSION_NAME = p_dimension_name
,LEVEL_NUM = p_level_num
,LEVEL_TYPE = p_level_type
,LEVEL_NAME = p_level_name
WHERE ROWID = p_rowid;
INSERT INTO MTH_DIM_LEVEL_LOOKUP_ERR (
REPROCESS_READY_YN
,HIERARCHY_NAME
,DIMENSION_NAME
,LEVEL_NUM
,LEVEL_TYPE
,LEVEL_NAME
) VALUES (
p_reprocess_ready_yn
,p_hierarchy_name
,p_dimension_name
,p_level_num
,p_level_type
,p_level_name
);
UPDATE MTH_ENTITY_PLANNED_USAGE_ERR SET
REPROCESS_READY_YN = p_reprocess_ready_yn
,ENTITY_FK = p_entity_fk
,SUSTAIN_ASPECT_FK = p_sustain_aspect_fk
,PERIOD_OF_USAGE = p_period_of_usage
,ENTITY_TYPE = p_entity_type
,PLANNED_USAGE = p_planned_usage
WHERE ROWID = p_rowid;
INSERT INTO MTH_ENTITY_PLANNED_USAGE_ERR (
REPROCESS_READY_YN
,ENTITY_FK
,SUSTAIN_ASPECT_FK
,PERIOD_OF_USAGE
,ENTITY_TYPE
,PLANNED_USAGE
) VALUES (
p_reprocess_ready_yn
,p_entity_fk
,p_sustain_aspect_fk
,p_period_of_usage
,p_entity_type
,p_planned_usage
);
UPDATE MTH_EQUIPMENTS_ERR SET
REPROCESS_READY_YN = p_reprocess_ready_yn
,EQUIPMENT_PK = p_equipment_pk
,EBS_ORGANIZATION_ID = p_ebs_organization_id
,EBS_EQUIPMENT_ID = p_ebs_equipment_id
,SYSTEM_FK = p_system_fk
,USER_ATTR1 = p_user_attr1
,USER_ATTR2 = p_user_attr2
,USER_ATTR3 = p_user_attr3
,USER_ATTR4 = p_user_attr4
,USER_ATTR5 = p_user_attr5
,USER_MEASURE1 = p_user_measure1
,USER_MEASURE2 = p_user_measure2
,USER_MEASURE3 = p_user_measure3
,USER_MEASURE4 = p_user_measure4
,USER_MEASURE5 = p_user_measure5
,FIXED_ASSET_VALUE = p_fixed_asset_value
,EQUIPMENT_NAME = p_equipment_name
,EQUIPMENT_DESCRIPTION = p_equipment_description
,SOURCE_ORG_CODE = p_source_org_code
,STD_UTILIZATION = p_std_utilization
,STD_EFFICIENCY = p_std_efficiency
,EQUIPMENT_CRITICALITY = p_equipment_criticality
,SERIAL_NUMBER = p_serial_number
,PRODUCTION_EQUIPMENT = p_production_equipment
,EQUIPMENT_MANUFACTURER = p_equipment_manufacturer
,MODEL_NUMBER = p_model_number
,INSTALLATION_DATE = fnd_date.canonical_to_date(p_installation_date)
,LAST_CALIBRATED = fnd_date.canonical_to_date(p_last_calibrated)
,POWER_RATING = p_power_rating
,STANDARD_CAPACITY = p_standard_capacity
,STD_CYCLE_TIME = p_std_cycle_time
,STATUS = p_status
,LOCATION = p_location
WHERE ROWID = p_rowid;
INSERT INTO MTH_EQUIPMENTS_ERR (
REPROCESS_READY_YN
,EQUIPMENT_PK
,EBS_ORGANIZATION_ID
,EBS_EQUIPMENT_ID
,SYSTEM_FK
,USER_ATTR1
,USER_ATTR2
,USER_ATTR3
,USER_ATTR4
,USER_ATTR5
,USER_MEASURE1
,USER_MEASURE2
,USER_MEASURE3
,USER_MEASURE4
,USER_MEASURE5
,FIXED_ASSET_VALUE
,EQUIPMENT_NAME
,EQUIPMENT_DESCRIPTION
,SOURCE_ORG_CODE
,STD_UTILIZATION
,STD_EFFICIENCY
,EQUIPMENT_CRITICALITY
,SERIAL_NUMBER
,PRODUCTION_EQUIPMENT
,EQUIPMENT_MANUFACTURER
,MODEL_NUMBER
,INSTALLATION_DATE
,LAST_CALIBRATED
,POWER_RATING
,STANDARD_CAPACITY
,STD_CYCLE_TIME
,STATUS
,LOCATION
) VALUES (
p_reprocess_ready_yn
,p_equipment_pk
,p_ebs_organization_id
,p_ebs_equipment_id
,p_system_fk
,p_user_attr1
,p_user_attr2
,p_user_attr3
,p_user_attr4
,p_user_attr5
,p_user_measure1
,p_user_measure2
,p_user_measure3
,p_user_measure4
,p_user_measure5
,p_fixed_asset_value
,p_equipment_name
,p_equipment_description
,p_source_org_code
,p_std_utilization
,p_std_efficiency
,p_equipment_criticality
,p_serial_number
,p_production_equipment
,p_equipment_manufacturer
,p_model_number
,fnd_date.canonical_to_date(p_installation_date)
,fnd_date.canonical_to_date(p_last_calibrated)
,p_power_rating
,p_standard_capacity
,p_std_cycle_time
,p_status
,p_location
);
UPDATE MTH_EQUIPMENT_REASON_SETUP_ERR SET
REPROCESS_READY_YN = p_reprocess_ready_yn
,EQUIPMENT_FK = p_equipment_fk
,REASON_TYPE = p_reason_type
,REASON_CODE = p_reason_code
,EXPECTED_UP_TIME = p_expected_up_time
WHERE ROWID = p_rowid;
INSERT INTO MTH_EQUIPMENT_REASON_SETUP_ERR (
REPROCESS_READY_YN
,EQUIPMENT_FK
,REASON_TYPE
,REASON_CODE
,EXPECTED_UP_TIME
) VALUES (
p_reprocess_ready_yn
,p_equipment_fk
,p_reason_type
,p_reason_code
,p_expected_up_time
);
UPDATE MTH_EQUIPMENT_SHIFTS_ERR SET
REPROCESS_READY_YN = p_reprocess_ready_yn
,ENTITY_PK = p_entity_pk
,ENTITY_TYPE = p_entity_type
,LINE_NUM = p_line_num
,FROM_DATE = fnd_date.canonical_to_date(p_from_date)
,TO_DATE = fnd_date.canonical_to_date(p_to_date)
,SHIFT_WORKDAY_FK = p_shift_workday_fk
,AVAILABILITY_FLAG = p_availability_flag
,REASON = p_reason
WHERE ROWID = p_rowid;
INSERT INTO MTH_EQUIPMENT_SHIFTS_ERR (
REPROCESS_READY_YN
,ENTITY_PK
,ENTITY_TYPE
,LINE_NUM
,FROM_DATE
,TO_DATE
,SHIFT_WORKDAY_FK
,AVAILABILITY_FLAG
,REASON
) VALUES (
p_reprocess_ready_yn
,p_entity_pk
,p_entity_type
,p_line_num
,fnd_date.canonical_to_date(p_from_date)
,fnd_date.canonical_to_date(p_to_date)
,p_shift_workday_fk
,p_availability_flag
,p_reason
);
UPDATE MTH_EQUIP_ENTITIES_ERR SET
REPROCESS_READY_YN = p_reprocess_ready_yn
,ENTITY_PK = p_entity_pk
,ENTITY_NAME = p_entity_name
,ENTITY_TYPE = p_entity_type
,SYSTEM_FK = p_system_fk
,SOURCE_ORG_CODE = p_source_org_code
,PRODUCTION_ENTITY = p_production_entity
,BUSINESS_FUNCTION = p_business_function
,DESCRIPTION = p_description
,STATUS = p_status
,AREA = p_area
,HEAD_COUNT = p_head_count
,EFFECTIVE_DATE = fnd_date.canonical_to_date(p_effective_date)
,USER_ATTR1 = p_user_attr1
,USER_ATTR2 = p_user_attr2
,USER_ATTR3 = p_user_attr3
,USER_ATTR4 = p_user_attr4
,USER_ATTR5 = p_user_attr5
,USER_MEASURE1 = p_user_measure1
,USER_MEASURE2 = p_user_measure2
,USER_MEASURE3 = p_user_measure3
,USER_MEASURE4 = p_user_measure4
,USER_MEASURE5 = p_user_measure5
WHERE ROWID = p_rowid;
INSERT INTO MTH_EQUIP_ENTITIES_ERR (
REPROCESS_READY_YN
,ENTITY_PK
,ENTITY_NAME
,ENTITY_TYPE
,SYSTEM_FK
,SOURCE_ORG_CODE
,PRODUCTION_ENTITY
,BUSINESS_FUNCTION
,DESCRIPTION
,STATUS
,AREA
,HEAD_COUNT
,EFFECTIVE_DATE
,USER_ATTR1
,USER_ATTR2
,USER_ATTR3
,USER_ATTR4
,USER_ATTR5
,USER_MEASURE1
,USER_MEASURE2
,USER_MEASURE3
,USER_MEASURE4
,USER_MEASURE5
) VALUES (
p_reprocess_ready_yn
,p_entity_pk
,p_entity_name
,p_entity_type
,p_system_fk
,p_source_org_code
,p_production_entity
,p_business_function
,p_description
,p_status
,p_area
,p_head_count
,fnd_date.canonical_to_date(p_effective_date)
,p_user_attr1
,p_user_attr2
,p_user_attr3
,p_user_attr4
,p_user_attr5
,p_user_measure1
,p_user_measure2
,p_user_measure3
,p_user_measure4
,p_user_measure5
);
UPDATE MTH_EQUIP_HIERARCHY_ERR SET
REPROCESS_READY_YN = p_reprocess_ready_yn
,HIERARCHY_NAME = p_hierarchy_name
,LEVEL_NUM = p_level_num
,LEVEL_FK = p_level_fk
,PARENT_FK = p_parent_fk
,SYSTEM_FK = p_system_fk
,EFFECTIVE_DATE = fnd_date.canonical_to_date(p_effective_date)
WHERE ROWID = p_rowid;
INSERT INTO MTH_EQUIP_HIERARCHY_ERR (
REPROCESS_READY_YN
,HIERARCHY_NAME
,LEVEL_NUM
,LEVEL_FK
,PARENT_FK
,SYSTEM_FK
,EFFECTIVE_DATE
) VALUES (
p_reprocess_ready_yn
,p_hierarchy_name
,p_level_num
,p_level_fk
,p_parent_fk
,p_system_fk
,fnd_date.canonical_to_date(p_effective_date)
);
UPDATE MTH_EQUIP_OUTPUT_ERR SET
REPROCESS_READY_YN = p_reprocess_ready_yn
,EQUIPMENT_FK = p_equipment_fk
,ITEM_FK = p_item_fk
,SHIFT_WORKDAY_FK = p_shift_workday_fk
,WORKORDER_FK = p_workorder_fk
,READING_TIME = fnd_date.canonical_to_date(p_reading_time)
,QTY_COMPLETED = p_qty_completed
,QTY_SCRAP = p_qty_scrap
,QTY_REJECTED = p_qty_rejected
,QTY_REWORK = p_qty_rework
,QTY_UOM = p_qty_uom
,QTY_GOOD = p_qty_good
,QTY_OUTPUT = p_qty_output
,SYSTEM_FK = p_system_fk
,USER_DIM1_FK = p_user_dim1_fk
,USER_DIM2_FK = p_user_dim2_fk
,USER_DIM3_FK = p_user_dim3_fk
,USER_DIM4_FK = p_user_dim4_fk
,USER_DIM5_FK = p_user_dim5_fk
,USER_ATTR1 = p_user_attr1
,USER_ATTR2 = p_user_attr2
,USER_ATTR3 = p_user_attr3
,USER_ATTR4 = p_user_attr4
,USER_ATTR5 = p_user_attr5
,USER_MEASURE1 = p_user_measure1
,USER_MEASURE2 = p_user_measure2
,USER_MEASURE3 = p_user_measure3
,USER_MEASURE4 = p_user_measure4
,USER_MEASURE5 = p_user_measure5
,RECIPE_NUM = p_recipe_num
,RECIPE_VERSION = p_recipe_version
,SEGMENT_FK = p_segment_fk
,SCRAP_REASON_CODE = p_scrap_reason_code
WHERE ROWID = p_rowid;
INSERT INTO MTH_EQUIP_OUTPUT_ERR (
REPROCESS_READY_YN
,EQUIPMENT_FK
,ITEM_FK
,SHIFT_WORKDAY_FK
,WORKORDER_FK
,READING_TIME
,QTY_COMPLETED
,QTY_SCRAP
,QTY_REJECTED
,QTY_REWORK
,QTY_UOM
,QTY_GOOD
,QTY_OUTPUT
,SYSTEM_FK
,USER_DIM1_FK
,USER_DIM2_FK
,USER_DIM3_FK
,USER_DIM4_FK
,USER_DIM5_FK
,USER_ATTR1
,USER_ATTR2
,USER_ATTR3
,USER_ATTR4
,USER_ATTR5
,USER_MEASURE1
,USER_MEASURE2
,USER_MEASURE3
,USER_MEASURE4
,USER_MEASURE5
,RECIPE_NUM
,RECIPE_VERSION
,SEGMENT_FK
,SCRAP_REASON_CODE
) VALUES (
p_reprocess_ready_yn
,p_equipment_fk
,p_item_fk
,p_shift_workday_fk
,p_workorder_fk
,fnd_date.canonical_to_date(p_reading_time)
,p_qty_completed
,p_qty_scrap
,p_qty_rejected
,p_qty_rework
,p_qty_uom
,p_qty_good
,p_qty_output
,p_system_fk
,p_user_dim1_fk
,p_user_dim2_fk
,p_user_dim3_fk
,p_user_dim4_fk
,p_user_dim5_fk
,p_user_attr1
,p_user_attr2
,p_user_attr3
,p_user_attr4
,p_user_attr5
,p_user_measure1
,p_user_measure2
,p_user_measure3
,p_user_measure4
,p_user_measure5
,p_recipe_num
,p_recipe_version
,p_segment_fk
,p_scrap_reason_code
);
UPDATE MTH_EQUIP_PROD_SCHEDULE_ERR SET
REPROCESS_READY_YN = p_reprocess_ready_yn
,EQUIP_SCHEDULE_PK = p_equip_schedule_pk
,EQUIPMENT_FK = p_equipment_fk
,WORKORDER_FK = p_workorder_fk
,SEGMENT_FK = p_segment_fk
,SHIFT_WORKDAY_FK = p_shift_workday_fk
,ITEM_FK = p_item_fk
,SCHEDULE_FROM_DATE = fnd_date.canonical_to_date(p_schedule_from_date)
,SCHEDULE_TO_DATE = fnd_date.canonical_to_date(p_schedule_to_date)
,PLANNED_QTY_G = p_planned_qty_g
,PLANNED_QTY_SG = p_planned_qty_sg
,PRIMARY_UOM = p_primary_uom
,SECONDARY_UOM = p_secondary_uom
,SYSTEM_FK = p_system_fk
,USER_DIM1_FK = p_user_dim1_fk
,USER_DIM2_FK = p_user_dim2_fk
,USER_DIM3_FK = p_user_dim3_fk
,USER_DIM4_FK = p_user_dim4_fk
,USER_DIM5_FK = p_user_dim5_fk
,USER_ATTR1 = p_user_attr1
,USER_ATTR2 = p_user_attr2
,USER_ATTR3 = p_user_attr3
,USER_ATTR4 = p_user_attr4
,USER_ATTR5 = p_user_attr5
,USER_MEASURE1 = p_user_measure1
,USER_MEASURE2 = p_user_measure2
,USER_MEASURE3 = p_user_measure3
,USER_MEASURE4 = p_user_measure4
,USER_MEASURE5 = p_user_measure5
WHERE ROWID = p_rowid;
INSERT INTO MTH_EQUIP_PROD_SCHEDULE_ERR (
REPROCESS_READY_YN
,EQUIP_SCHEDULE_PK
,EQUIPMENT_FK
,WORKORDER_FK
,SEGMENT_FK
,SHIFT_WORKDAY_FK
,ITEM_FK
,SCHEDULE_FROM_DATE
,SCHEDULE_TO_DATE
,PLANNED_QTY_G
,PLANNED_QTY_SG
,PRIMARY_UOM
,SECONDARY_UOM
,SYSTEM_FK
,USER_DIM1_FK
,USER_DIM2_FK
,USER_DIM3_FK
,USER_DIM4_FK
,USER_DIM5_FK
,USER_ATTR1
,USER_ATTR2
,USER_ATTR3
,USER_ATTR4
,USER_ATTR5
,USER_MEASURE1
,USER_MEASURE2
,USER_MEASURE3
,USER_MEASURE4
,USER_MEASURE5
) VALUES (
p_reprocess_ready_yn
,p_equip_schedule_pk
,p_equipment_fk
,p_workorder_fk
,p_segment_fk
,p_shift_workday_fk
,p_item_fk
,fnd_date.canonical_to_date(p_schedule_from_date)
,fnd_date.canonical_to_date(p_schedule_to_date)
,p_planned_qty_g
,p_planned_qty_sg
,p_primary_uom
,p_secondary_uom
,p_system_fk
,p_user_dim1_fk
,p_user_dim2_fk
,p_user_dim3_fk
,p_user_dim4_fk
,p_user_dim5_fk
,p_user_attr1
,p_user_attr2
,p_user_attr3
,p_user_attr4
,p_user_attr5
,p_user_measure1
,p_user_measure2
,p_user_measure3
,p_user_measure4
,p_user_measure5
);
UPDATE MTH_EQUIP_STANDARD_RATES_ERR SET
REPROCESS_READY_YN = p_reprocess_ready_yn
,EQUIPMENT_FK = p_equipment_fk
,SHIFT_WORKDAY_FK = p_shift_workday_fk
,ITEM_FK = p_item_fk
,STANDARD_RATE_1 = p_standard_rate_1
,STANDARD_RATE_2 = p_standard_rate_2
,STANDARD_RATE_3 = p_standard_rate_3
,SOURCE_ORG_CODE = p_source_org_code
,SYSTEM_FK = p_system_fk
,USER_DIM1_FK = p_user_dim1_fk
,USER_DIM2_FK = p_user_dim2_fk
,USER_DIM3_FK = p_user_dim3_fk
,USER_DIM4_FK = p_user_dim4_fk
,USER_DIM5_FK = p_user_dim5_fk
,USER_ATTR1 = p_user_attr1
,USER_ATTR2 = p_user_attr2
,USER_ATTR3 = p_user_attr3
,USER_ATTR4 = p_user_attr4
,USER_ATTR5 = p_user_attr5
,USER_MEASURE1 = p_user_measure1
,USER_MEASURE2 = p_user_measure2
,USER_MEASURE3 = p_user_measure3
,USER_MEASURE4 = p_user_measure4
,USER_MEASURE5 = p_user_measure5
,RECIPE_NUM = p_recipe_num
,RECIPE_VERSION = p_recipe_version
WHERE ROWID = p_rowid;
INSERT INTO MTH_EQUIP_STANDARD_RATES_ERR (
REPROCESS_READY_YN
,EQUIPMENT_FK
,SHIFT_WORKDAY_FK
,ITEM_FK
,STANDARD_RATE_1
,STANDARD_RATE_2
,STANDARD_RATE_3
,SOURCE_ORG_CODE
,SYSTEM_FK
,USER_DIM1_FK
,USER_DIM2_FK
,USER_DIM3_FK
,USER_DIM4_FK
,USER_DIM5_FK
,USER_ATTR1
,USER_ATTR2
,USER_ATTR3
,USER_ATTR4
,USER_ATTR5
,USER_MEASURE1
,USER_MEASURE2
,USER_MEASURE3
,USER_MEASURE4
,USER_MEASURE5
,RECIPE_NUM
,RECIPE_VERSION
) VALUES (
p_reprocess_ready_yn
,p_equipment_fk
,p_shift_workday_fk
,p_item_fk
,p_standard_rate_1
,p_standard_rate_2
,p_standard_rate_3
,p_source_org_code
,p_system_fk
,p_user_dim1_fk
,p_user_dim2_fk
,p_user_dim3_fk
,p_user_dim4_fk
,p_user_dim5_fk
,p_user_attr1
,p_user_attr2
,p_user_attr3
,p_user_attr4
,p_user_attr5
,p_user_measure1
,p_user_measure2
,p_user_measure3
,p_user_measure4
,p_user_measure5
,p_recipe_num
,p_recipe_version
);
UPDATE MTH_EQUIP_STATUSES_ERR SET
REPROCESS_READY_YN = p_reprocess_ready_yn
,EQUIPMENT_FK = p_equipment_fk
,SHIFT_WORKDAY_FK = p_shift_workday_fk
,FROM_DATE = fnd_date.canonical_to_date(p_from_date)
,TO_DATE = fnd_date.canonical_to_date(p_to_date)
,STATUS = p_status
,SYSTEM_FK = p_system_fk
,USER_DIM1_FK = p_user_dim1_fk
,USER_DIM2_FK = p_user_dim2_fk
,USER_DIM3_FK = p_user_dim3_fk
,USER_DIM4_FK = p_user_dim4_fk
,USER_DIM5_FK = p_user_dim5_fk
,USER_ATTR1 = p_user_attr1
,USER_ATTR2 = p_user_attr2
,USER_ATTR3 = p_user_attr3
,USER_ATTR4 = p_user_attr4
,USER_ATTR5 = p_user_attr5
,USER_MEASURE1 = p_user_measure1
,USER_MEASURE2 = p_user_measure2
,USER_MEASURE3 = p_user_measure3
,USER_MEASURE4 = p_user_measure4
,USER_MEASURE5 = p_user_measure5
,DOWNTIME_REASON_CODE = p_downtime_reason_code
WHERE ROWID = p_rowid;
INSERT INTO MTH_EQUIP_STATUSES_ERR (
REPROCESS_READY_YN
,EQUIPMENT_FK
,SHIFT_WORKDAY_FK
,FROM_DATE
,TO_DATE
,STATUS
,SYSTEM_FK
,USER_DIM1_FK
,USER_DIM2_FK
,USER_DIM3_FK
,USER_DIM4_FK
,USER_DIM5_FK
,USER_ATTR1
,USER_ATTR2
,USER_ATTR3
,USER_ATTR4
,USER_ATTR5
,USER_MEASURE1
,USER_MEASURE2
,USER_MEASURE3
,USER_MEASURE4
,USER_MEASURE5
,DOWNTIME_REASON_CODE
) VALUES (
p_reprocess_ready_yn
,p_equipment_fk
,p_shift_workday_fk
,fnd_date.canonical_to_date(p_from_date)
,fnd_date.canonical_to_date(p_to_date)
,p_status
,p_system_fk
,p_user_dim1_fk
,p_user_dim2_fk
,p_user_dim3_fk
,p_user_dim4_fk
,p_user_dim5_fk
,p_user_attr1
,p_user_attr2
,p_user_attr3
,p_user_attr4
,p_user_attr5
,p_user_measure1
,p_user_measure2
,p_user_measure3
,p_user_measure4
,p_user_measure5
,p_downtime_reason_code
);
UPDATE MTH_EVENT_ACTION_SETUP_ERR SET
REPROCESS_READY_YN = p_reprocess_ready_yn
,EQUIPMENT_FK = p_equipment_fk
,EVENT_TYPE_CODE = p_event_type_code
,REASON_CODE = p_reason_code
,ACTION_TYPE_CODE = p_action_type_code
,PERSONNEL_FK = p_personnel_fk
,ACTION_HANDLER_CODE = p_action_handler_code
,EMAIL_NOTIFICATION = p_email_notification
,MOBILE_NOTIFICATION = p_mobile_notification
,DOMAIN_NAME = p_domain_name
WHERE ROWID = p_rowid;
INSERT INTO MTH_EVENT_ACTION_SETUP_ERR (
REPROCESS_READY_YN
,EQUIPMENT_FK
,EVENT_TYPE_CODE
,REASON_CODE
,ACTION_TYPE_CODE
,PERSONNEL_FK
,ACTION_HANDLER_CODE
,EMAIL_NOTIFICATION
,MOBILE_NOTIFICATION
,DOMAIN_NAME
) VALUES (
p_reprocess_ready_yn
,p_equipment_fk
,p_event_type_code
,p_reason_code
,p_action_type_code
,p_personnel_fk
,p_action_handler_code
,p_email_notification
,p_mobile_notification
,p_domain_name
);
UPDATE MTH_ITEMS_ERR SET
REPROCESS_READY_YN = p_reprocess_ready_yn
,ITEM_PK = p_item_pk
,SYSTEM_FK = p_system_fk
,SOURCE_ORG_CODE = p_source_org_code
,ITEM_NAME = p_item_name
,PRIMARY_UOM = p_primary_uom
,SECONDARY_UOM = p_secondary_uom
,EBS_ITEM_ID = p_ebs_item_id
,EBS_ORG_ID = p_ebs_org_id
,DESCRIPTION = p_description
,UNIT_WEIGHT = p_unit_weight
,WEIGHT_UOM = p_weight_uom
,UNIT_VOLUME = p_unit_volume
,VOLUME_UOM = p_volume_uom
,BASE_ITEM = p_base_item
,USER_ATTR1 = p_user_attr1
,USER_ATTR2 = p_user_attr2
,USER_ATTR3 = p_user_attr3
,USER_ATTR4 = p_user_attr4
,USER_ATTR5 = p_user_attr5
,USER_ATTR6 = p_user_attr6
,USER_ATTR7 = p_user_attr7
,USER_ATTR8 = p_user_attr8
,USER_ATTR9 = p_user_attr9
,USER_ATTR10 = p_user_attr10
,USER_ATTR11 = p_user_attr11
,USER_ATTR12 = p_user_attr12
,USER_ATTR13 = p_user_attr13
,USER_ATTR14 = p_user_attr14
,USER_ATTR15 = p_user_attr15
,USER_ATTR16 = p_user_attr16
,USER_ATTR17 = p_user_attr17
,USER_ATTR18 = p_user_attr18
,USER_ATTR19 = p_user_attr19
,USER_ATTR20 = p_user_attr20
,USER_MEASURE1 = p_user_measure1
,USER_MEASURE2 = p_user_measure2
,USER_MEASURE3 = p_user_measure3
,USER_MEASURE4 = p_user_measure4
,USER_MEASURE5 = p_user_measure5
,USER_ATTR21 = p_user_attr21
,USER_ATTR22 = p_user_attr22
,USER_ATTR23 = p_user_attr23
,USER_ATTR24 = p_user_attr24
,USER_ATTR25 = p_user_attr25
,USER_ATTR26 = p_user_attr26
,USER_ATTR27 = p_user_attr27
,USER_ATTR28 = p_user_attr28
,USER_ATTR29 = p_user_attr29
,USER_ATTR30 = p_user_attr30
WHERE ROWID = p_rowid;
INSERT INTO MTH_ITEMS_ERR (
REPROCESS_READY_YN
,ITEM_PK
,SYSTEM_FK
,SOURCE_ORG_CODE
,ITEM_NAME
,PRIMARY_UOM
,SECONDARY_UOM
,EBS_ITEM_ID
,EBS_ORG_ID
,DESCRIPTION
,UNIT_WEIGHT
,WEIGHT_UOM
,UNIT_VOLUME
,VOLUME_UOM
,BASE_ITEM
,USER_ATTR1
,USER_ATTR2
,USER_ATTR3
,USER_ATTR4
,USER_ATTR5
,USER_ATTR6
,USER_ATTR7
,USER_ATTR8
,USER_ATTR9
,USER_ATTR10
,USER_ATTR11
,USER_ATTR12
,USER_ATTR13
,USER_ATTR14
,USER_ATTR15
,USER_ATTR16
,USER_ATTR17
,USER_ATTR18
,USER_ATTR19
,USER_ATTR20
,USER_MEASURE1
,USER_MEASURE2
,USER_MEASURE3
,USER_MEASURE4
,USER_MEASURE5
,USER_ATTR21
,USER_ATTR22
,USER_ATTR23
,USER_ATTR24
,USER_ATTR25
,USER_ATTR26
,USER_ATTR27
,USER_ATTR28
,USER_ATTR29
,USER_ATTR30
) VALUES (
p_reprocess_ready_yn
,p_item_pk
,p_system_fk
,p_source_org_code
,p_item_name
,p_primary_uom
,p_secondary_uom
,p_ebs_item_id
,p_ebs_org_id
,p_description
,p_unit_weight
,p_weight_uom
,p_unit_volume
,p_volume_uom
,p_base_item
,p_user_attr1
,p_user_attr2
,p_user_attr3
,p_user_attr4
,p_user_attr5
,p_user_attr6
,p_user_attr7
,p_user_attr8
,p_user_attr9
,p_user_attr10
,p_user_attr11
,p_user_attr12
,p_user_attr13
,p_user_attr14
,p_user_attr15
,p_user_attr16
,p_user_attr17
,p_user_attr18
,p_user_attr19
,p_user_attr20
,p_user_measure1
,p_user_measure2
,p_user_measure3
,p_user_measure4
,p_user_measure5
,p_user_attr21
,p_user_attr22
,p_user_attr23
,p_user_attr24
,p_user_attr25
,p_user_attr26
,p_user_attr27
,p_user_attr28
,p_user_attr29
,p_user_attr30
);
UPDATE MTH_ITEM_CATEGORIES_ERR SET
REPROCESS_READY_YN = p_reprocess_ready_yn
,CATEGORY_PK = p_category_pk
,SYSTEM_FK = p_system_fk
,CATEGORY_NAME = p_category_name
,DESCRIPTION = p_description
,EBS_CATEGORY_ID = p_ebs_category_id
,USER_ATTR1 = p_user_attr1
,USER_ATTR2 = p_user_attr2
,USER_ATTR3 = p_user_attr3
,USER_ATTR4 = p_user_attr4
,USER_ATTR5 = p_user_attr5
,USER_MEASURE1 = p_user_measure1
,USER_MEASURE2 = p_user_measure2
,USER_MEASURE3 = p_user_measure3
,USER_MEASURE4 = p_user_measure4
,USER_MEASURE5 = p_user_measure5
,SEGMENT1 = p_segment1
,SEGMENT2 = p_segment2
,SEGMENT3 = p_segment3
,SEGMENT4 = p_segment4
,SEGMENT5 = p_segment5
,SEGMENT6 = p_segment6
,SEGMENT7 = p_segment7
,SEGMENT8 = p_segment8
,SEGMENT9 = p_segment9
,SEGMENT10 = p_segment10
,SEGMENT11 = p_segment11
,SEGMENT12 = p_segment12
,SEGMENT13 = p_segment13
,SEGMENT14 = p_segment14
,SEGMENT15 = p_segment15
,SEGMENT16 = p_segment16
,SEGMENT17 = p_segment17
,SEGMENT18 = p_segment18
,SEGMENT19 = p_segment19
,SEGMENT20 = p_segment20
WHERE ROWID = p_rowid;
INSERT INTO MTH_ITEM_CATEGORIES_ERR (
REPROCESS_READY_YN
,CATEGORY_PK
,SYSTEM_FK
,CATEGORY_NAME
,DESCRIPTION
,EBS_CATEGORY_ID
,USER_ATTR1
,USER_ATTR2
,USER_ATTR3
,USER_ATTR4
,USER_ATTR5
,USER_MEASURE1
,USER_MEASURE2
,USER_MEASURE3
,USER_MEASURE4
,USER_MEASURE5
,SEGMENT1
,SEGMENT2
,SEGMENT3
,SEGMENT4
,SEGMENT5
,SEGMENT6
,SEGMENT7
,SEGMENT8
,SEGMENT9
,SEGMENT10
,SEGMENT11
,SEGMENT12
,SEGMENT13
,SEGMENT14
,SEGMENT15
,SEGMENT16
,SEGMENT17
,SEGMENT18
,SEGMENT19
,SEGMENT20
) VALUES (
p_reprocess_ready_yn
,p_category_pk
,p_system_fk
,p_category_name
,p_description
,p_ebs_category_id
,p_user_attr1
,p_user_attr2
,p_user_attr3
,p_user_attr4
,p_user_attr5
,p_user_measure1
,p_user_measure2
,p_user_measure3
,p_user_measure4
,p_user_measure5
,p_segment1
,p_segment2
,p_segment3
,p_segment4
,p_segment5
,p_segment6
,p_segment7
,p_segment8
,p_segment9
,p_segment10
,p_segment11
,p_segment12
,p_segment13
,p_segment14
,p_segment15
,p_segment16
,p_segment17
,p_segment18
,p_segment19
,p_segment20
);
UPDATE MTH_ITEM_COST_ERR SET
REPROCESS_READY_YN = p_reprocess_ready_yn
,SYSTEM_FK = p_system_fk
,ITEM_FK = p_item_fk
,ITEM_COST = p_item_cost
,FROM_DATE = fnd_date.canonical_to_date(p_from_date)
,TO_DATE = fnd_date.canonical_to_date(p_to_date)
,COST_ELEMENT = p_cost_element
,USER_ATTR1 = p_user_attr1
,USER_ATTR2 = p_user_attr2
,USER_ATTR3 = p_user_attr3
,USER_ATTR4 = p_user_attr4
,USER_ATTR5 = p_user_attr5
WHERE ROWID = p_rowid;
INSERT INTO MTH_ITEM_COST_ERR (
REPROCESS_READY_YN
,SYSTEM_FK
,ITEM_FK
,ITEM_COST
,FROM_DATE
,TO_DATE
,COST_ELEMENT
,USER_ATTR1
,USER_ATTR2
,USER_ATTR3
,USER_ATTR4
,USER_ATTR5
) VALUES (
p_reprocess_ready_yn
,p_system_fk
,p_item_fk
,p_item_cost
,fnd_date.canonical_to_date(p_from_date)
,fnd_date.canonical_to_date(p_to_date)
,p_cost_element
,p_user_attr1
,p_user_attr2
,p_user_attr3
,p_user_attr4
,p_user_attr5
);
UPDATE MTH_ITEM_HIERARCHY_ERR SET
REPROCESS_READY_YN = p_reprocess_ready_yn
,LEVEL_FK = p_level_fk
,PARENT_FK = p_parent_fk
,HIERARCHY_NAME = p_hierarchy_name
,LEVEL_NUM = p_level_num
,SYSTEM_FK = p_system_fk
WHERE ROWID = p_rowid;
INSERT INTO MTH_ITEM_HIERARCHY_ERR (
REPROCESS_READY_YN
,LEVEL_FK
,PARENT_FK
,HIERARCHY_NAME
,LEVEL_NUM
,SYSTEM_FK
) VALUES (
p_reprocess_ready_yn
,p_level_fk
,p_parent_fk
,p_hierarchy_name
,p_level_num
,p_system_fk
);
p_last_update_date IN VARCHAR2,
p_rowid IN ROWID
) IS
BEGIN
IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
UPDATE MTH_METER_READINGS_ERR SET
REPROCESS_READY_YN = p_reprocess_ready_yn
,METER_READINGS_ERR_PK_KEY = p_meter_readings_err_pk_key
,METER_CODE = p_meter_code
,FROM_TIME = fnd_date.canonical_to_date(p_from_time)
,TO_TIME = fnd_date.canonical_to_date(p_to_time)
,USAGE_VALUE = p_usage_value
,TAG_CODE = p_tag_code
,ERR_SOURCE = p_err_source
,CREATION_DATE = fnd_date.canonical_to_date(p_creation_date)
,LAST_UPDATE_DATE = fnd_date.canonical_to_date(p_last_update_date)
WHERE ROWID = p_rowid;
INSERT INTO MTH_METER_READINGS_ERR (
REPROCESS_READY_YN
,METER_READINGS_ERR_PK_KEY
,METER_CODE
,FROM_TIME
,TO_TIME
,USAGE_VALUE
,TAG_CODE
,ERR_SOURCE
,CREATION_DATE
,LAST_UPDATE_DATE
) VALUES (
p_reprocess_ready_yn
,p_meter_readings_err_pk_key
,p_meter_code
,fnd_date.canonical_to_date(p_from_time)
,fnd_date.canonical_to_date(p_to_time)
,p_usage_value
,p_tag_code
,p_err_source
,fnd_date.canonical_to_date(p_creation_date)
,fnd_date.canonical_to_date(p_last_update_date)
);
UPDATE MTH_MTL_CONSUMED_TXN_LOT_ERR SET
REPROCESS_READY_YN = p_reprocess_ready_yn
,WO_MAT_TXN_FK = p_wo_mat_txn_fk
,PRODUCT_LOT = p_product_lot
,PRODUCT_SUBLOT = p_product_sublot
,PRODUCT_SERIAL_NO = p_product_serial_no
,TRANSACTION_QTY = p_transaction_qty
,TRANSACTION_QTY_G = p_transaction_qty_g
,TRANSACTION_QTY_SG = p_transaction_qty_sg
,TRANSACTION_UOM = p_transaction_uom
,PRIMARY_UOM = p_primary_uom
,SECONDARY_UOM = p_secondary_uom
,MATERIAL_LOT = p_material_lot
,MATERIAL_SUBLOT = p_material_sublot
,MATERIAL_SERIAL_NO = p_material_serial_no
,SYSTEM_FK = p_system_fk
,USER_DIM1_FK = p_user_dim1_fk
,USER_DIM2_FK = p_user_dim2_fk
,USER_DIM3_FK = p_user_dim3_fk
,USER_DIM4_FK = p_user_dim4_fk
,USER_DIM5_FK = p_user_dim5_fk
,USER_ATTR1 = p_user_attr1
,USER_ATTR2 = p_user_attr2
,USER_ATTR3 = p_user_attr3
,USER_ATTR4 = p_user_attr4
,USER_ATTR5 = p_user_attr5
,USER_MEASURE1 = p_user_measure1
,USER_MEASURE2 = p_user_measure2
,USER_MEASURE3 = p_user_measure3
,USER_MEASURE4 = p_user_measure4
,USER_MEASURE5 = p_user_measure5
,GRADE = p_grade
WHERE ROWID = p_rowid;
INSERT INTO MTH_MTL_CONSUMED_TXN_LOT_ERR (
REPROCESS_READY_YN
,WO_MAT_TXN_FK
,PRODUCT_LOT
,PRODUCT_SUBLOT
,PRODUCT_SERIAL_NO
,TRANSACTION_QTY
,TRANSACTION_QTY_G
,TRANSACTION_QTY_SG
,TRANSACTION_UOM
,PRIMARY_UOM
,SECONDARY_UOM
,MATERIAL_LOT
,MATERIAL_SUBLOT
,MATERIAL_SERIAL_NO
,SYSTEM_FK
,USER_DIM1_FK
,USER_DIM2_FK
,USER_DIM3_FK
,USER_DIM4_FK
,USER_DIM5_FK
,USER_ATTR1
,USER_ATTR2
,USER_ATTR3
,USER_ATTR4
,USER_ATTR5
,USER_MEASURE1
,USER_MEASURE2
,USER_MEASURE3
,USER_MEASURE4
,USER_MEASURE5
,GRADE
) VALUES (
p_reprocess_ready_yn
,p_wo_mat_txn_fk
,p_product_lot
,p_product_sublot
,p_product_serial_no
,p_transaction_qty
,p_transaction_qty_g
,p_transaction_qty_sg
,p_transaction_uom
,p_primary_uom
,p_secondary_uom
,p_material_lot
,p_material_sublot
,p_material_serial_no
,p_system_fk
,p_user_dim1_fk
,p_user_dim2_fk
,p_user_dim3_fk
,p_user_dim4_fk
,p_user_dim5_fk
,p_user_attr1
,p_user_attr2
,p_user_attr3
,p_user_attr4
,p_user_attr5
,p_user_measure1
,p_user_measure2
,p_user_measure3
,p_user_measure4
,p_user_measure5
,p_grade
);
UPDATE MTH_MTL_PRODUCED_TXN_LOT_ERR SET
REPROCESS_READY_YN = p_reprocess_ready_yn
,WO_COMP_FK = p_wo_comp_fk
,TRANSACTION_QTY = p_transaction_qty
,TRANSACTION_QTY_G = p_transaction_qty_g
,TRANSACTION_QTY_SG = p_transaction_qty_sg
,PRODUCT_LOT = p_product_lot
,PRODUCT_SUBLOT = p_product_sublot
,PRODUCT_SERIAL_NO = p_product_serial_no
,TRANSACTION_UOM = p_transaction_uom
,PRIMARY_UOM = p_primary_uom
,SECONDARY_UOM = p_secondary_uom
,SYSTEM_FK = p_system_fk
,USER_DIM1_FK = p_user_dim1_fk
,USER_DIM2_FK = p_user_dim2_fk
,USER_DIM3_FK = p_user_dim3_fk
,USER_DIM4_FK = p_user_dim4_fk
,USER_DIM5_FK = p_user_dim5_fk
,USER_ATTR1 = p_user_attr1
,USER_ATTR2 = p_user_attr2
,USER_ATTR3 = p_user_attr3
,USER_ATTR4 = p_user_attr4
,USER_ATTR5 = p_user_attr5
,USER_MEASURE1 = p_user_measure1
,USER_MEASURE2 = p_user_measure2
,USER_MEASURE3 = p_user_measure3
,USER_MEASURE4 = p_user_measure4
,USER_MEASURE5 = p_user_measure5
,GRADE = p_grade
WHERE ROWID = p_rowid;
INSERT INTO MTH_MTL_PRODUCED_TXN_LOT_ERR (
REPROCESS_READY_YN
,WO_COMP_FK
,TRANSACTION_QTY
,TRANSACTION_QTY_G
,TRANSACTION_QTY_SG
,PRODUCT_LOT
,PRODUCT_SUBLOT
,PRODUCT_SERIAL_NO
,TRANSACTION_UOM
,PRIMARY_UOM
,SECONDARY_UOM
,SYSTEM_FK
,USER_DIM1_FK
,USER_DIM2_FK
,USER_DIM3_FK
,USER_DIM4_FK
,USER_DIM5_FK
,USER_ATTR1
,USER_ATTR2
,USER_ATTR3
,USER_ATTR4
,USER_ATTR5
,USER_MEASURE1
,USER_MEASURE2
,USER_MEASURE3
,USER_MEASURE4
,USER_MEASURE5
,GRADE
) VALUES (
p_reprocess_ready_yn
,p_wo_comp_fk
,p_transaction_qty
,p_transaction_qty_g
,p_transaction_qty_sg
,p_product_lot
,p_product_sublot
,p_product_serial_no
,p_transaction_uom
,p_primary_uom
,p_secondary_uom
,p_system_fk
,p_user_dim1_fk
,p_user_dim2_fk
,p_user_dim3_fk
,p_user_dim4_fk
,p_user_dim5_fk
,p_user_attr1
,p_user_attr2
,p_user_attr3
,p_user_attr4
,p_user_attr5
,p_user_measure1
,p_user_measure2
,p_user_measure3
,p_user_measure4
,p_user_measure5
,p_grade
);
UPDATE MTH_PERIOD_ERR SET
REPROCESS_READY_YN = p_reprocess_ready_yn
,HIERARCHY_NAME = p_hierarchy_name
,NAME = p_name
,USER_ATTR1 = p_user_attr1
,USER_ATTR2 = p_user_attr2
,USER_ATTR3 = p_user_attr3
,USER_ATTR4 = p_user_attr4
,USER_ATTR5 = p_user_attr5
,USER_MEASURE1 = p_user_measure1
,USER_MEASURE2 = p_user_measure2
,USER_MEASURE3 = p_user_measure3
,USER_MEASURE4 = p_user_measure4
,USER_MEASURE5 = p_user_measure5
,SYSTEM_FK = p_system_fk
,END_DATE = fnd_date.canonical_to_date(p_end_date)
,START_DATE = fnd_date.canonical_to_date(p_start_date)
WHERE ROWID = p_rowid;
UPDATE MTH_PERSONNEL_ERR SET
REPROCESS_READY_YN = p_reprocess_ready_yn
,PERSONNEL_PK = p_personnel_pk
,EBS_PERSONNEL_ID = p_ebs_personnel_id
,EBS_ORGANIZATION_ID = p_ebs_organization_id
,FIRST_NAME = p_first_name
,LAST_NAME = p_last_name
,SYSTEM_FK = p_system_fk
,RESOURCE_FK = p_resource_fk
,PERSONNEL_DESCRIPTION = p_personnel_description
,USER_ATTR1 = p_user_attr1
,USER_ATTR2 = p_user_attr2
,USER_ATTR3 = p_user_attr3
,USER_ATTR4 = p_user_attr4
,USER_ATTR5 = p_user_attr5
,USER_MEASURE1 = p_user_measure1
,USER_MEASURE2 = p_user_measure2
,USER_MEASURE3 = p_user_measure3
,USER_MEASURE4 = p_user_measure4
,USER_MEASURE5 = p_user_measure5
,SOURCE_ORG_CODE = p_source_org_code
,MIDDLE_NAME = p_middle_name
,KNOWN_AS = p_known_as
,FULL_NAME = p_full_name
,TITLE = p_title
,SEX = p_sex
,EMAIL_ADDRESS = p_email_address
,WORK_TELEPHONE = p_work_telephone
,MOBILE_PHONE_NUMBER = p_mobile_phone_number
,EFFECTIVE_START_DATE = fnd_date.canonical_to_date(p_effective_start_date)
,EFFECTIVE_END_DATE = fnd_date.canonical_to_date(p_effective_end_date)
WHERE ROWID = p_rowid;
INSERT INTO MTH_PERSONNEL_ERR (
REPROCESS_READY_YN
,PERSONNEL_PK
,EBS_PERSONNEL_ID
,EBS_ORGANIZATION_ID
,FIRST_NAME
,LAST_NAME
,SYSTEM_FK
,RESOURCE_FK
,PERSONNEL_DESCRIPTION
,USER_ATTR1
,USER_ATTR2
,USER_ATTR3
,USER_ATTR4
,USER_ATTR5
,USER_MEASURE1
,USER_MEASURE2
,USER_MEASURE3
,USER_MEASURE4
,USER_MEASURE5
,SOURCE_ORG_CODE
,MIDDLE_NAME
,KNOWN_AS
,FULL_NAME
,TITLE
,SEX
,EMAIL_ADDRESS
,WORK_TELEPHONE
,MOBILE_PHONE_NUMBER
,EFFECTIVE_START_DATE
,EFFECTIVE_END_DATE
) VALUES (
p_reprocess_ready_yn
,p_personnel_pk
,p_ebs_personnel_id
,p_ebs_organization_id
,p_first_name
,p_last_name
,p_system_fk
,p_resource_fk
,p_personnel_description
,p_user_attr1
,p_user_attr2
,p_user_attr3
,p_user_attr4
,p_user_attr5
,p_user_measure1
,p_user_measure2
,p_user_measure3
,p_user_measure4
,p_user_measure5
,p_source_org_code
,p_middle_name
,p_known_as
,p_full_name
,p_title
,p_sex
,p_email_address
,p_work_telephone
,p_mobile_phone_number
,fnd_date.canonical_to_date(p_effective_start_date)
,fnd_date.canonical_to_date(p_effective_end_date)
);
UPDATE MTH_PRODUCTION_SCHEDULES_ERR SET
REPROCESS_READY_YN = p_reprocess_ready_yn
,WORKORDER_PK = p_workorder_pk
,SYSTEM_FK = p_system_fk
,WORKORDER_TYPE = p_workorder_type
,STATUS = p_status
,PLANNED_START_DATE = fnd_date.canonical_to_date(p_planned_start_date)
,PLANNED_COMPLETION_DATE = fnd_date.canonical_to_date(p_planned_completion_date)
,ACTUAL_START_DATE = fnd_date.canonical_to_date(p_actual_start_date)
,ACTUAL_COMPLETION_DATE = fnd_date.canonical_to_date(p_actual_completion_date)
,DATE_RELEASED = fnd_date.canonical_to_date(p_date_released)
,ERP_ACTUAL_START_DATE = fnd_date.canonical_to_date(p_erp_actual_start_date)
,ERP_ACTUAL_COMPLETION_DATE = fnd_date.canonical_to_date(p_erp_actual_completion_date)
,EBS_ENTITY_ID = p_ebs_entity_id
,EBS_ORGANIZATION_ID = p_ebs_organization_id
,BOM_REVISION = p_bom_revision
,ROUTING_REVISION = p_routing_revision
,BOM_REVISION_DATE = fnd_date.canonical_to_date(p_bom_revision_date)
,ROUTING_REVISION_DATE = fnd_date.canonical_to_date(p_routing_revision_date)
,ALTERNATE_BOM_DESIGNATOR = p_alternate_bom_designator
,ALTERNATE_ROUTING_DESIGNATOR = p_alternate_routing_designator
,COMPLETION_SUBINVENTORY = p_completion_subinventory
,COMPLETION_LOCATOR_ID = p_completion_locator_id
,DEMAND_CLASS = p_demand_class
,SCHEDULE_GROUP_ID = p_schedule_group_id
,BUILD_SEQUENCE = p_build_sequence
,WORKORDER_NAME = p_workorder_name
,DEMAND_SOURCE_HEADER_ID = p_demand_source_header_id
,DEMAND_SOURCE_LINE = p_demand_source_line
,DEMAND_SOURCE_DELIVERY = p_demand_source_delivery
,DEMAND_SOURCE_TYPE = p_demand_source_type
,KANBAN_CARD_ID = p_kanban_card_id
,LINE_CODE = p_line_code
,PARENT_WORKORDER_ID = p_parent_workorder_id
,PARENT_OPERATION_SEQ_NUM = p_parent_operation_seq_num
,SOURCE_ORG_CODE = p_source_org_code
,USER_DIM1_FK = p_user_dim1_fk
,USER_DIM2_FK = p_user_dim2_fk
,USER_DIM3_FK = p_user_dim3_fk
,USER_DIM4_FK = p_user_dim4_fk
,USER_DIM5_FK = p_user_dim5_fk
,USER_ATTR1 = p_user_attr1
,USER_ATTR2 = p_user_attr2
,USER_ATTR3 = p_user_attr3
,USER_ATTR4 = p_user_attr4
,USER_ATTR5 = p_user_attr5
,USER_ATTR6 = p_user_attr6
,USER_ATTR7 = p_user_attr7
,USER_ATTR8 = p_user_attr8
,USER_ATTR9 = p_user_attr9
,USER_ATTR10 = p_user_attr10
,USER_ATTR11 = p_user_attr11
,USER_ATTR12 = p_user_attr12
,USER_ATTR13 = p_user_attr13
,USER_ATTR14 = p_user_attr14
,USER_ATTR15 = p_user_attr15
,USER_ATTR16 = p_user_attr16
,USER_ATTR17 = p_user_attr17
,USER_ATTR18 = p_user_attr18
,USER_ATTR19 = p_user_attr19
,USER_ATTR20 = p_user_attr20
,USER_MEASURE1 = p_user_measure1
,USER_MEASURE2 = p_user_measure2
,USER_MEASURE3 = p_user_measure3
,USER_MEASURE4 = p_user_measure4
,USER_MEASURE5 = p_user_measure5
,RECIPE_NUM = p_recipe_num
,RECIPE_VERSION = p_recipe_version
,FORMULA_NUM = p_formula_num
,FORMULA_VERSION = p_formula_version
,REQ_COMPLETION_DATE = fnd_date.canonical_to_date(p_req_completion_date)
,BATCH_TYPE = p_batch_type
,TERMINATED_IND = p_terminated_ind
WHERE ROWID = p_rowid;
INSERT INTO MTH_PRODUCTION_SCHEDULES_ERR (
REPROCESS_READY_YN
,WORKORDER_PK
,SYSTEM_FK
,WORKORDER_TYPE
,STATUS
,PLANNED_START_DATE
,PLANNED_COMPLETION_DATE
,ACTUAL_START_DATE
,ACTUAL_COMPLETION_DATE
,DATE_RELEASED
,ERP_ACTUAL_START_DATE
,ERP_ACTUAL_COMPLETION_DATE
,EBS_ENTITY_ID
,EBS_ORGANIZATION_ID
,BOM_REVISION
,ROUTING_REVISION
,BOM_REVISION_DATE
,ROUTING_REVISION_DATE
,ALTERNATE_BOM_DESIGNATOR
,ALTERNATE_ROUTING_DESIGNATOR
,COMPLETION_SUBINVENTORY
,COMPLETION_LOCATOR_ID
,DEMAND_CLASS
,SCHEDULE_GROUP_ID
,BUILD_SEQUENCE
,WORKORDER_NAME
,DEMAND_SOURCE_HEADER_ID
,DEMAND_SOURCE_LINE
,DEMAND_SOURCE_DELIVERY
,DEMAND_SOURCE_TYPE
,KANBAN_CARD_ID
,LINE_CODE
,PARENT_WORKORDER_ID
,PARENT_OPERATION_SEQ_NUM
,SOURCE_ORG_CODE
,USER_DIM1_FK
,USER_DIM2_FK
,USER_DIM3_FK
,USER_DIM4_FK
,USER_DIM5_FK
,USER_ATTR1
,USER_ATTR2
,USER_ATTR3
,USER_ATTR4
,USER_ATTR5
,USER_ATTR6
,USER_ATTR7
,USER_ATTR8
,USER_ATTR9
,USER_ATTR10
,USER_ATTR11
,USER_ATTR12
,USER_ATTR13
,USER_ATTR14
,USER_ATTR15
,USER_ATTR16
,USER_ATTR17
,USER_ATTR18
,USER_ATTR19
,USER_ATTR20
,USER_MEASURE1
,USER_MEASURE2
,USER_MEASURE3
,USER_MEASURE4
,USER_MEASURE5
,RECIPE_NUM
,RECIPE_VERSION
,FORMULA_NUM
,FORMULA_VERSION
,REQ_COMPLETION_DATE
,BATCH_TYPE
,TERMINATED_IND
) VALUES (
p_reprocess_ready_yn
,p_workorder_pk
,p_system_fk
,p_workorder_type
,p_status
,fnd_date.canonical_to_date(p_planned_start_date)
,fnd_date.canonical_to_date(p_planned_completion_date)
,fnd_date.canonical_to_date(p_actual_start_date)
,fnd_date.canonical_to_date(p_actual_completion_date)
,fnd_date.canonical_to_date(p_date_released)
,fnd_date.canonical_to_date(p_erp_actual_start_date)
,fnd_date.canonical_to_date(p_erp_actual_completion_date)
,p_ebs_entity_id
,p_ebs_organization_id
,p_bom_revision
,p_routing_revision
,fnd_date.canonical_to_date(p_bom_revision_date)
,fnd_date.canonical_to_date(p_routing_revision_date)
,p_alternate_bom_designator
,p_alternate_routing_designator
,p_completion_subinventory
,p_completion_locator_id
,p_demand_class
,p_schedule_group_id
,p_build_sequence
,p_workorder_name
,p_demand_source_header_id
,p_demand_source_line
,p_demand_source_delivery
,p_demand_source_type
,p_kanban_card_id
,p_line_code
,p_parent_workorder_id
,p_parent_operation_seq_num
,p_source_org_code
,p_user_dim1_fk
,p_user_dim2_fk
,p_user_dim3_fk
,p_user_dim4_fk
,p_user_dim5_fk
,p_user_attr1
,p_user_attr2
,p_user_attr3
,p_user_attr4
,p_user_attr5
,p_user_attr6
,p_user_attr7
,p_user_attr8
,p_user_attr9
,p_user_attr10
,p_user_attr11
,p_user_attr12
,p_user_attr13
,p_user_attr14
,p_user_attr15
,p_user_attr16
,p_user_attr17
,p_user_attr18
,p_user_attr19
,p_user_attr20
,p_user_measure1
,p_user_measure2
,p_user_measure3
,p_user_measure4
,p_user_measure5
,p_recipe_num
,p_recipe_version
,p_formula_num
,p_formula_version
,fnd_date.canonical_to_date(p_req_completion_date)
,p_batch_type
,p_terminated_ind
);
UPDATE MTH_PRODUCTION_SEGMENTS_ERR SET
REPROCESS_READY_YN = p_reprocess_ready_yn
,WORKORDER_FK = p_workorder_fk
,SEGMENT_PK = p_segment_pk
,ITEM_FK = p_item_fk
,START_QUANTITY_G = p_start_quantity_g
,START_QUANTITY_SG = p_start_quantity_sg
,PRIMARY_UOM = p_primary_uom
,SECONDARY_UOM = p_secondary_uom
,ACTUAL_COMP_QTY_G = p_actual_comp_qty_g
,ACTUAL_COMP_QTY_SG = p_actual_comp_qty_sg
,ACTUAL_REJECTED_QTY_G = p_actual_rejected_qty_g
,ACTUAL_REWORKED_QTY_G = p_actual_reworked_qty_g
,ACTUAL_SCRAP_QTY_G = p_actual_scrap_qty_g
,ACTUAL_REJECTED_QTY_SG = p_actual_rejected_qty_sg
,ACTUAL_REWORKED_QTY_SG = p_actual_reworked_qty_sg
,ACTUAL_SCRAP_QTY_SG = p_actual_scrap_qty_sg
,ACTUAL_START_DATE = fnd_date.canonical_to_date(p_actual_start_date)
,ACTUAL_COMPLETION_DATE = fnd_date.canonical_to_date(p_actual_completion_date)
,SYSTEM_FK = p_system_fk
,USER_DIM1_FK = p_user_dim1_fk
,USER_DIM2_FK = p_user_dim2_fk
,USER_DIM3_FK = p_user_dim3_fk
,USER_DIM4_FK = p_user_dim4_fk
,USER_DIM5_FK = p_user_dim5_fk
,USER_ATTR1 = p_user_attr1
,USER_ATTR2 = p_user_attr2
,USER_ATTR3 = p_user_attr3
,USER_ATTR4 = p_user_attr4
,USER_ATTR5 = p_user_attr5
,USER_MEASURE1 = p_user_measure1
,USER_MEASURE2 = p_user_measure2
,USER_MEASURE3 = p_user_measure3
,USER_MEASURE4 = p_user_measure4
,USER_MEASURE5 = p_user_measure5
,SEGMENT_STATUS = p_segment_status
,PLANNED_START_DATE = fnd_date.canonical_to_date(p_planned_start_date)
,PLANNED_COMPLETION_DATE = fnd_date.canonical_to_date(p_planned_completion_date)
,REQ_COMPLETION_DATE = fnd_date.canonical_to_date(p_req_completion_date)
WHERE ROWID = p_rowid;
INSERT INTO MTH_PRODUCTION_SEGMENTS_ERR (
REPROCESS_READY_YN
,WORKORDER_FK
,SEGMENT_PK
,ITEM_FK
,START_QUANTITY_G
,START_QUANTITY_SG
,PRIMARY_UOM
,SECONDARY_UOM
,ACTUAL_COMP_QTY_G
,ACTUAL_COMP_QTY_SG
,ACTUAL_REJECTED_QTY_G
,ACTUAL_REWORKED_QTY_G
,ACTUAL_SCRAP_QTY_G
,ACTUAL_REJECTED_QTY_SG
,ACTUAL_REWORKED_QTY_SG
,ACTUAL_SCRAP_QTY_SG
,ACTUAL_START_DATE
,ACTUAL_COMPLETION_DATE
,SYSTEM_FK
,USER_DIM1_FK
,USER_DIM2_FK
,USER_DIM3_FK
,USER_DIM4_FK
,USER_DIM5_FK
,USER_ATTR1
,USER_ATTR2
,USER_ATTR3
,USER_ATTR4
,USER_ATTR5
,USER_MEASURE1
,USER_MEASURE2
,USER_MEASURE3
,USER_MEASURE4
,USER_MEASURE5
,SEGMENT_STATUS
,PLANNED_START_DATE
,PLANNED_COMPLETION_DATE
,REQ_COMPLETION_DATE
) VALUES (
p_reprocess_ready_yn
,p_workorder_fk
,p_segment_pk
,p_item_fk
,p_start_quantity_g
,p_start_quantity_sg
,p_primary_uom
,p_secondary_uom
,p_actual_comp_qty_g
,p_actual_comp_qty_sg
,p_actual_rejected_qty_g
,p_actual_reworked_qty_g
,p_actual_scrap_qty_g
,p_actual_rejected_qty_sg
,p_actual_reworked_qty_sg
,p_actual_scrap_qty_sg
,fnd_date.canonical_to_date(p_actual_start_date)
,fnd_date.canonical_to_date(p_actual_completion_date)
,p_system_fk
,p_user_dim1_fk
,p_user_dim2_fk
,p_user_dim3_fk
,p_user_dim4_fk
,p_user_dim5_fk
,p_user_attr1
,p_user_attr2
,p_user_attr3
,p_user_attr4
,p_user_attr5
,p_user_measure1
,p_user_measure2
,p_user_measure3
,p_user_measure4
,p_user_measure5
,p_segment_status
,fnd_date.canonical_to_date(p_planned_start_date)
,fnd_date.canonical_to_date(p_planned_completion_date)
,fnd_date.canonical_to_date(p_req_completion_date)
);
UPDATE MTH_PROD_MTL_CONSUMED_ERR SET
REPROCESS_READY_YN = p_reprocess_ready_yn
,WO_MAT_REQ_PK = p_wo_mat_req_pk
,PRODUCT_FK = p_product_fk
,MATERIAL_FK = p_material_fk
,SEGMENT_FK = p_segment_fk
,PRIMARY_UOM = p_primary_uom
,SECONDARY_UOM = p_secondary_uom
,REQUIRED_QTY_G = p_required_qty_g
,REQUIRED_QTY_SG = p_required_qty_sg
,ACTUAL_QTY_G = p_actual_qty_g
,ACTUAL_QTY_SG = p_actual_qty_sg
,UNIT_STANDARD_QTY_G = p_unit_standard_qty_g
,UNIT_STANDARD_QTY_SG = p_unit_standard_qty_sg
,REQUIRED_BY_DATE = fnd_date.canonical_to_date(p_required_by_date)
,SOURCE_ORG_CODE = p_source_org_code
,SYSTEM_FK = p_system_fk
,USER_DIM1_FK = p_user_dim1_fk
,USER_DIM2_FK = p_user_dim2_fk
,USER_DIM3_FK = p_user_dim3_fk
,USER_DIM4_FK = p_user_dim4_fk
,USER_DIM5_FK = p_user_dim5_fk
,USER_ATTR1 = p_user_attr1
,USER_ATTR2 = p_user_attr2
,USER_ATTR3 = p_user_attr3
,USER_ATTR4 = p_user_attr4
,USER_ATTR5 = p_user_attr5
,USER_MEASURE1 = p_user_measure1
,USER_MEASURE2 = p_user_measure2
,USER_MEASURE3 = p_user_measure3
,USER_MEASURE4 = p_user_measure4
,USER_MEASURE5 = p_user_measure5
,WORKORDER_FK = p_workorder_fk
,MAT_SCRAP_QTY_G = p_mat_scrap_qty_g
,MAT_SCRAP_QTY_SG = p_mat_scrap_qty_sg
WHERE ROWID = p_rowid;
INSERT INTO MTH_PROD_MTL_CONSUMED_ERR (
REPROCESS_READY_YN
,WO_MAT_REQ_PK
,PRODUCT_FK
,MATERIAL_FK
,SEGMENT_FK
,PRIMARY_UOM
,SECONDARY_UOM
,REQUIRED_QTY_G
,REQUIRED_QTY_SG
,ACTUAL_QTY_G
,ACTUAL_QTY_SG
,UNIT_STANDARD_QTY_G
,UNIT_STANDARD_QTY_SG
,REQUIRED_BY_DATE
,SOURCE_ORG_CODE
,SYSTEM_FK
,USER_DIM1_FK
,USER_DIM2_FK
,USER_DIM3_FK
,USER_DIM4_FK
,USER_DIM5_FK
,USER_ATTR1
,USER_ATTR2
,USER_ATTR3
,USER_ATTR4
,USER_ATTR5
,USER_MEASURE1
,USER_MEASURE2
,USER_MEASURE3
,USER_MEASURE4
,USER_MEASURE5
,WORKORDER_FK
,MAT_SCRAP_QTY_G
,MAT_SCRAP_QTY_SG
) VALUES (
p_reprocess_ready_yn
,p_wo_mat_req_pk
,p_product_fk
,p_material_fk
,p_segment_fk
,p_primary_uom
,p_secondary_uom
,p_required_qty_g
,p_required_qty_sg
,p_actual_qty_g
,p_actual_qty_sg
,p_unit_standard_qty_g
,p_unit_standard_qty_sg
,fnd_date.canonical_to_date(p_required_by_date)
,p_source_org_code
,p_system_fk
,p_user_dim1_fk
,p_user_dim2_fk
,p_user_dim3_fk
,p_user_dim4_fk
,p_user_dim5_fk
,p_user_attr1
,p_user_attr2
,p_user_attr3
,p_user_attr4
,p_user_attr5
,p_user_measure1
,p_user_measure2
,p_user_measure3
,p_user_measure4
,p_user_measure5
,p_workorder_fk
,p_mat_scrap_qty_g
,p_mat_scrap_qty_sg
);
UPDATE MTH_PROD_MTL_CONSUMED_TXN_ERR SET
REPROCESS_READY_YN = p_reprocess_ready_yn
,WO_MAT_TXN_PK = p_wo_mat_txn_pk
,WORKORDER_FK = p_workorder_fk
,PRODUCT_FK = p_product_fk
,MATERIAL_FK = p_material_fk
,SEGMENT_FK = p_segment_fk
,TRANSACTION_QTY = p_transaction_qty
,TRANSACTION_QTY_G = p_transaction_qty_g
,TRANSACTION_QTY_SG = p_transaction_qty_sg
,TRANSACTION_UOM = p_transaction_uom
,PRIMARY_UOM = p_primary_uom
,SECONDARY_UOM = p_secondary_uom
,TRANSACTION_DATE = fnd_date.canonical_to_date(p_transaction_date)
,SYSTEM_FK = p_system_fk
,SOURCE_ORG_CODE = p_source_org_code
,USER_DIM1_FK = p_user_dim1_fk
,USER_DIM2_FK = p_user_dim2_fk
,USER_DIM3_FK = p_user_dim3_fk
,USER_DIM4_FK = p_user_dim4_fk
,USER_DIM5_FK = p_user_dim5_fk
,USER_ATTR1 = p_user_attr1
,USER_ATTR2 = p_user_attr2
,USER_ATTR3 = p_user_attr3
,USER_ATTR4 = p_user_attr4
,USER_ATTR5 = p_user_attr5
,USER_MEASURE1 = p_user_measure1
,USER_MEASURE2 = p_user_measure2
,USER_MEASURE3 = p_user_measure3
,USER_MEASURE4 = p_user_measure4
,USER_MEASURE5 = p_user_measure5
WHERE ROWID = p_rowid;
INSERT INTO MTH_PROD_MTL_CONSUMED_TXN_ERR (
REPROCESS_READY_YN
,WO_MAT_TXN_PK
,WORKORDER_FK
,PRODUCT_FK
,MATERIAL_FK
,SEGMENT_FK
,TRANSACTION_QTY
,TRANSACTION_QTY_G
,TRANSACTION_QTY_SG
,TRANSACTION_UOM
,PRIMARY_UOM
,SECONDARY_UOM
,TRANSACTION_DATE
,SYSTEM_FK
,SOURCE_ORG_CODE
,USER_DIM1_FK
,USER_DIM2_FK
,USER_DIM3_FK
,USER_DIM4_FK
,USER_DIM5_FK
,USER_ATTR1
,USER_ATTR2
,USER_ATTR3
,USER_ATTR4
,USER_ATTR5
,USER_MEASURE1
,USER_MEASURE2
,USER_MEASURE3
,USER_MEASURE4
,USER_MEASURE5
) VALUES (
p_reprocess_ready_yn
,p_wo_mat_txn_pk
,p_workorder_fk
,p_product_fk
,p_material_fk
,p_segment_fk
,p_transaction_qty
,p_transaction_qty_g
,p_transaction_qty_sg
,p_transaction_uom
,p_primary_uom
,p_secondary_uom
,fnd_date.canonical_to_date(p_transaction_date)
,p_system_fk
,p_source_org_code
,p_user_dim1_fk
,p_user_dim2_fk
,p_user_dim3_fk
,p_user_dim4_fk
,p_user_dim5_fk
,p_user_attr1
,p_user_attr2
,p_user_attr3
,p_user_attr4
,p_user_attr5
,p_user_measure1
,p_user_measure2
,p_user_measure3
,p_user_measure4
,p_user_measure5
);
UPDATE MTH_PROD_MTL_PRODUCED_ERR SET
REPROCESS_READY_YN = p_reprocess_ready_yn
,WORKORDER_FK = p_workorder_fk
,ITEM_FK = p_item_fk
,START_QUANTITY_G = p_start_quantity_g
,SYSTEM_FK = p_system_fk
,START_QUANTITY_SG = p_start_quantity_sg
,EXPECTED_YIELD = p_expected_yield
,PRIMARY_UOM = p_primary_uom
,SECONDARY_UOM = p_secondary_uom
,ACTUAL_COMP_QTY_G = p_actual_comp_qty_g
,ACTUAL_COMP_QTY_SG = p_actual_comp_qty_sg
,ACTUAL_REJECTED_QTY_G = p_actual_rejected_qty_g
,ACTUAL_REJECTED_QTY_SG = p_actual_rejected_qty_sg
,ACTUAL_REWORKED_QTY_G = p_actual_reworked_qty_g
,ACTUAL_REWORKED_QTY_SG = p_actual_reworked_qty_sg
,ACTUAL_SCRAP_QTY_G = p_actual_scrap_qty_g
,ACTUAL_SCRAP_QTY_SG = p_actual_scrap_qty_sg
,ITEM_TYPE_CODE = p_item_type_code
,USER_DIM1_FK = p_user_dim1_fk
,USER_DIM2_FK = p_user_dim2_fk
,USER_DIM3_FK = p_user_dim3_fk
,USER_DIM4_FK = p_user_dim4_fk
,USER_DIM5_FK = p_user_dim5_fk
,USER_ATTR1 = p_user_attr1
,USER_ATTR2 = p_user_attr2
,USER_ATTR3 = p_user_attr3
,USER_ATTR4 = p_user_attr4
,USER_ATTR5 = p_user_attr5
,USER_MEASURE1 = p_user_measure1
,USER_MEASURE2 = p_user_measure2
,USER_MEASURE3 = p_user_measure3
,USER_MEASURE4 = p_user_measure4
,USER_MEASURE5 = p_user_measure5
,WIP_PLAN_QTY_G = p_wip_plan_qty_g
,WIP_PLAN_QTY_SG = p_wip_plan_qty_sg
,CONTRIBUTE_YIELD_FLAG = p_contribute_yield_flag
WHERE ROWID = p_rowid;
INSERT INTO MTH_PROD_MTL_PRODUCED_ERR (
REPROCESS_READY_YN
,WORKORDER_FK
,ITEM_FK
,START_QUANTITY_G
,SYSTEM_FK
,START_QUANTITY_SG
,EXPECTED_YIELD
,PRIMARY_UOM
,SECONDARY_UOM
,ACTUAL_COMP_QTY_G
,ACTUAL_COMP_QTY_SG
,ACTUAL_REJECTED_QTY_G
,ACTUAL_REJECTED_QTY_SG
,ACTUAL_REWORKED_QTY_G
,ACTUAL_REWORKED_QTY_SG
,ACTUAL_SCRAP_QTY_G
,ACTUAL_SCRAP_QTY_SG
,ITEM_TYPE_CODE
,USER_DIM1_FK
,USER_DIM2_FK
,USER_DIM3_FK
,USER_DIM4_FK
,USER_DIM5_FK
,USER_ATTR1
,USER_ATTR2
,USER_ATTR3
,USER_ATTR4
,USER_ATTR5
,USER_MEASURE1
,USER_MEASURE2
,USER_MEASURE3
,USER_MEASURE4
,USER_MEASURE5
,WIP_PLAN_QTY_G
,WIP_PLAN_QTY_SG
,CONTRIBUTE_YIELD_FLAG
) VALUES (
p_reprocess_ready_yn
,p_workorder_fk
,p_item_fk
,p_start_quantity_g
,p_system_fk
,p_start_quantity_sg
,p_expected_yield
,p_primary_uom
,p_secondary_uom
,p_actual_comp_qty_g
,p_actual_comp_qty_sg
,p_actual_rejected_qty_g
,p_actual_rejected_qty_sg
,p_actual_reworked_qty_g
,p_actual_reworked_qty_sg
,p_actual_scrap_qty_g
,p_actual_scrap_qty_sg
,p_item_type_code
,p_user_dim1_fk
,p_user_dim2_fk
,p_user_dim3_fk
,p_user_dim4_fk
,p_user_dim5_fk
,p_user_attr1
,p_user_attr2
,p_user_attr3
,p_user_attr4
,p_user_attr5
,p_user_measure1
,p_user_measure2
,p_user_measure3
,p_user_measure4
,p_user_measure5
,p_wip_plan_qty_g
,p_wip_plan_qty_sg
,p_contribute_yield_flag
);
UPDATE MTH_PROD_MTL_PRODUCED_TXN_ERR SET
REPROCESS_READY_YN = p_reprocess_ready_yn
,WO_COMP_PK = p_wo_comp_pk
,WORKORDER_FK = p_workorder_fk
,ITEM_FK = p_item_fk
,SEGMENT_FK = p_segment_fk
,TRANSACTION_TYPE = p_transaction_type
,TRANSACTION_QTY = p_transaction_qty
,TRANSACTION_QTY_G = p_transaction_qty_g
,TRANSACTION_QTY_SG = p_transaction_qty_sg
,TRANSACTION_UOM = p_transaction_uom
,PRIMARY_UOM = p_primary_uom
,SECONDARY_UOM = p_secondary_uom
,TRANSACTION_DATE = fnd_date.canonical_to_date(p_transaction_date)
,SOURCE_ORG_CODE = p_source_org_code
,SYSTEM_FK = p_system_fk
,USER_DIM1_FK = p_user_dim1_fk
,USER_DIM2_FK = p_user_dim2_fk
,USER_DIM3_FK = p_user_dim3_fk
,USER_DIM4_FK = p_user_dim4_fk
,USER_DIM5_FK = p_user_dim5_fk
,USER_ATTR1 = p_user_attr1
,USER_ATTR2 = p_user_attr2
,USER_ATTR3 = p_user_attr3
,USER_ATTR4 = p_user_attr4
,USER_ATTR5 = p_user_attr5
,USER_MEASURE1 = p_user_measure1
,USER_MEASURE2 = p_user_measure2
,USER_MEASURE3 = p_user_measure3
,USER_MEASURE4 = p_user_measure4
,USER_MEASURE5 = p_user_measure5
WHERE ROWID = p_rowid;
INSERT INTO MTH_PROD_MTL_PRODUCED_TXN_ERR (
REPROCESS_READY_YN
,WO_COMP_PK
,WORKORDER_FK
,ITEM_FK
,SEGMENT_FK
,TRANSACTION_TYPE
,TRANSACTION_QTY
,TRANSACTION_QTY_G
,TRANSACTION_QTY_SG
,TRANSACTION_UOM
,PRIMARY_UOM
,SECONDARY_UOM
,TRANSACTION_DATE
,SOURCE_ORG_CODE
,SYSTEM_FK
,USER_DIM1_FK
,USER_DIM2_FK
,USER_DIM3_FK
,USER_DIM4_FK
,USER_DIM5_FK
,USER_ATTR1
,USER_ATTR2
,USER_ATTR3
,USER_ATTR4
,USER_ATTR5
,USER_MEASURE1
,USER_MEASURE2
,USER_MEASURE3
,USER_MEASURE4
,USER_MEASURE5
) VALUES (
p_reprocess_ready_yn
,p_wo_comp_pk
,p_workorder_fk
,p_item_fk
,p_segment_fk
,p_transaction_type
,p_transaction_qty
,p_transaction_qty_g
,p_transaction_qty_sg
,p_transaction_uom
,p_primary_uom
,p_secondary_uom
,fnd_date.canonical_to_date(p_transaction_date)
,p_source_org_code
,p_system_fk
,p_user_dim1_fk
,p_user_dim2_fk
,p_user_dim3_fk
,p_user_dim4_fk
,p_user_dim5_fk
,p_user_attr1
,p_user_attr2
,p_user_attr3
,p_user_attr4
,p_user_attr5
,p_user_measure1
,p_user_measure2
,p_user_measure3
,p_user_measure4
,p_user_measure5
);
UPDATE MTH_PROD_SEGMENTS_TXN_ERR SET
REPROCESS_READY_YN = p_reprocess_ready_yn
,WORKORDER_FK = p_workorder_fk
,FROM_SEGMENT_FK = p_from_segment_fk
,TO_SEGMENT_FK = p_to_segment_fk
,ITEM_FK = p_item_fk
,SYSTEM_FK = p_system_fk
,TRANSACTION_DATE = fnd_date.canonical_to_date(p_transaction_date)
,TRANSACTION_QTY = p_transaction_qty
,TRANSACTION_QTY_G = p_transaction_qty_g
,TRANSACTION_QTY_SG = p_transaction_qty_sg
,PRIMARY_UOM = p_primary_uom
,SECONDARY_UOM = p_secondary_uom
,TRANSACTION_UOM = p_transaction_uom
,FROM_STEP_TYPE = p_from_step_type
,TO_STEP_TYPE = p_to_step_type
,USER_DIM1_FK = p_user_dim1_fk
,USER_DIM2_FK = p_user_dim2_fk
,USER_DIM3_FK = p_user_dim3_fk
,USER_DIM4_FK = p_user_dim4_fk
,USER_DIM5_FK = p_user_dim5_fk
,USER_ATTR1 = p_user_attr1
,USER_ATTR2 = p_user_attr2
,USER_ATTR3 = p_user_attr3
,USER_ATTR4 = p_user_attr4
,USER_ATTR5 = p_user_attr5
,USER_MEASURE1 = p_user_measure1
,USER_MEASURE2 = p_user_measure2
,USER_MEASURE3 = p_user_measure3
,USER_MEASURE4 = p_user_measure4
,USER_MEASURE5 = p_user_measure5
,SUB_SEGMENT_FK = p_sub_segment_fk
WHERE ROWID = p_rowid;
INSERT INTO MTH_PROD_SEGMENTS_TXN_ERR (
REPROCESS_READY_YN
,WORKORDER_FK
,FROM_SEGMENT_FK
,TO_SEGMENT_FK
,ITEM_FK
,SYSTEM_FK
,TRANSACTION_DATE
,TRANSACTION_QTY
,TRANSACTION_QTY_G
,TRANSACTION_QTY_SG
,PRIMARY_UOM
,SECONDARY_UOM
,TRANSACTION_UOM
,FROM_STEP_TYPE
,TO_STEP_TYPE
,USER_DIM1_FK
,USER_DIM2_FK
,USER_DIM3_FK
,USER_DIM4_FK
,USER_DIM5_FK
,USER_ATTR1
,USER_ATTR2
,USER_ATTR3
,USER_ATTR4
,USER_ATTR5
,USER_MEASURE1
,USER_MEASURE2
,USER_MEASURE3
,USER_MEASURE4
,USER_MEASURE5
,SUB_SEGMENT_FK
) VALUES (
p_reprocess_ready_yn
,p_workorder_fk
,p_from_segment_fk
,p_to_segment_fk
,p_item_fk
,p_system_fk
,fnd_date.canonical_to_date(p_transaction_date)
,p_transaction_qty
,p_transaction_qty_g
,p_transaction_qty_sg
,p_primary_uom
,p_secondary_uom
,p_transaction_uom
,p_from_step_type
,p_to_step_type
,p_user_dim1_fk
,p_user_dim2_fk
,p_user_dim3_fk
,p_user_dim4_fk
,p_user_dim5_fk
,p_user_attr1
,p_user_attr2
,p_user_attr3
,p_user_attr4
,p_user_attr5
,p_user_measure1
,p_user_measure2
,p_user_measure3
,p_user_measure4
,p_user_measure5
,p_sub_segment_fk
);
UPDATE MTH_PROD_SUB_SEGMENTS_ERR SET
REPROCESS_READY_YN = p_reprocess_ready_yn
,SUB_SEGMENT_PK = p_sub_segment_pk
,SEGMENT_FK = p_segment_fk
,SYSTEM_FK = p_system_fk
,DESCRIPTION = p_description
,ACTUAL_START_DATE = fnd_date.canonical_to_date(p_actual_start_date)
,ACTUAL_COMPLETION_DATE = fnd_date.canonical_to_date(p_actual_completion_date)
,PLANNED_START_DATE = fnd_date.canonical_to_date(p_planned_start_date)
,PLANNED_COMPLETION_DATE = fnd_date.canonical_to_date(p_planned_completion_date)
,USER_ATTR1 = p_user_attr1
,USER_ATTR2 = p_user_attr2
,USER_ATTR3 = p_user_attr3
,USER_ATTR4 = p_user_attr4
,USER_ATTR5 = p_user_attr5
,USER_MEASURE1 = p_user_measure1
,USER_MEASURE2 = p_user_measure2
,USER_MEASURE3 = p_user_measure3
,USER_MEASURE4 = p_user_measure4
,USER_MEASURE5 = p_user_measure5
WHERE ROWID = p_rowid;
INSERT INTO MTH_PROD_SUB_SEGMENTS_ERR (
REPROCESS_READY_YN
,SUB_SEGMENT_PK
,SEGMENT_FK
,SYSTEM_FK
,DESCRIPTION
,ACTUAL_START_DATE
,ACTUAL_COMPLETION_DATE
,PLANNED_START_DATE
,PLANNED_COMPLETION_DATE
,USER_ATTR1
,USER_ATTR2
,USER_ATTR3
,USER_ATTR4
,USER_ATTR5
,USER_MEASURE1
,USER_MEASURE2
,USER_MEASURE3
,USER_MEASURE4
,USER_MEASURE5
) VALUES (
p_reprocess_ready_yn
,p_sub_segment_pk
,p_segment_fk
,p_system_fk
,p_description
,fnd_date.canonical_to_date(p_actual_start_date)
,fnd_date.canonical_to_date(p_actual_completion_date)
,fnd_date.canonical_to_date(p_planned_start_date)
,fnd_date.canonical_to_date(p_planned_completion_date)
,p_user_attr1
,p_user_attr2
,p_user_attr3
,p_user_attr4
,p_user_attr5
,p_user_measure1
,p_user_measure2
,p_user_measure3
,p_user_measure4
,p_user_measure5
);
UPDATE MTH_QUARTER_ERR SET
REPROCESS_READY_YN = p_reprocess_ready_yn
,HIERARCHY_NAME = p_hierarchy_name
,NAME = p_name
,USER_ATTR1 = p_user_attr1
,USER_ATTR2 = p_user_attr2
,USER_ATTR3 = p_user_attr3
,USER_ATTR4 = p_user_attr4
,USER_ATTR5 = p_user_attr5
,USER_MEASURE1 = p_user_measure1
,USER_MEASURE2 = p_user_measure2
,USER_MEASURE3 = p_user_measure3
,USER_MEASURE4 = p_user_measure4
,USER_MEASURE5 = p_user_measure5
,SYSTEM_FK = p_system_fk
,END_DATE = fnd_date.canonical_to_date(p_end_date)
,START_DATE = fnd_date.canonical_to_date(p_start_date)
WHERE ROWID = p_rowid;
UPDATE MTH_RESOURCES_ERR SET
REPROCESS_READY_YN = p_reprocess_ready_yn
,RESOURCE_PK = p_resource_pk
,RESOURCE_TYPE = p_resource_type
,EBS_RESOURCE_ID = p_ebs_resource_id
,EBS_DEPARTMENT_ID = p_ebs_department_id
,EBS_ORGANIZATION_ID = p_ebs_organization_id
,USAGE_UOM = p_usage_uom
,CAPACITY_UNITS = p_capacity_units
,AVAILABLE_24_HOUR_FLAG = p_available_24_hour_flag
,SYSTEM_FK = p_system_fk
,DISABLE_DATE = fnd_date.canonical_to_date(p_disable_date)
,RESOURCE_NAME = p_resource_name
,USER_ATTR1 = p_user_attr1
,USER_ATTR2 = p_user_attr2
,USER_ATTR3 = p_user_attr3
,USER_ATTR4 = p_user_attr4
,USER_ATTR5 = p_user_attr5
,USER_ATTR6 = p_user_attr6
,USER_ATTR7 = p_user_attr7
,USER_ATTR8 = p_user_attr8
,USER_ATTR9 = p_user_attr9
,USER_ATTR10 = p_user_attr10
,USER_ATTR11 = p_user_attr11
,USER_ATTR12 = p_user_attr12
,USER_ATTR13 = p_user_attr13
,USER_ATTR14 = p_user_attr14
,USER_ATTR15 = p_user_attr15
,USER_ATTR16 = p_user_attr16
,USER_ATTR17 = p_user_attr17
,USER_ATTR18 = p_user_attr18
,USER_ATTR19 = p_user_attr19
,USER_ATTR20 = p_user_attr20
,USER_MEASURE1 = p_user_measure1
,USER_MEASURE2 = p_user_measure2
,USER_MEASURE3 = p_user_measure3
,USER_MEASURE4 = p_user_measure4
,USER_MEASURE5 = p_user_measure5
,SOURCE_ORG_CODE = p_source_org_code
,RESOURCE_DESCRIPTION = p_resource_description
,STD_UTILIZATION = p_std_utilization
,STD_EFFICIENCY = p_std_efficiency
,PRODUCTION_RESOURCE = p_production_resource
,STATUS = p_status
,BUSINESS_FUNCTION = p_business_function
WHERE ROWID = p_rowid;
INSERT INTO MTH_RESOURCES_ERR (
REPROCESS_READY_YN
,RESOURCE_PK
,RESOURCE_TYPE
,EBS_RESOURCE_ID
,EBS_DEPARTMENT_ID
,EBS_ORGANIZATION_ID
,USAGE_UOM
,CAPACITY_UNITS
,AVAILABLE_24_HOUR_FLAG
,SYSTEM_FK
,DISABLE_DATE
,RESOURCE_NAME
,USER_ATTR1
,USER_ATTR2
,USER_ATTR3
,USER_ATTR4
,USER_ATTR5
,USER_ATTR6
,USER_ATTR7
,USER_ATTR8
,USER_ATTR9
,USER_ATTR10
,USER_ATTR11
,USER_ATTR12
,USER_ATTR13
,USER_ATTR14
,USER_ATTR15
,USER_ATTR16
,USER_ATTR17
,USER_ATTR18
,USER_ATTR19
,USER_ATTR20
,USER_MEASURE1
,USER_MEASURE2
,USER_MEASURE3
,USER_MEASURE4
,USER_MEASURE5
,SOURCE_ORG_CODE
,RESOURCE_DESCRIPTION
,STD_UTILIZATION
,STD_EFFICIENCY
,PRODUCTION_RESOURCE
,STATUS
,BUSINESS_FUNCTION
) VALUES (
p_reprocess_ready_yn
,p_resource_pk
,p_resource_type
,p_ebs_resource_id
,p_ebs_department_id
,p_ebs_organization_id
,p_usage_uom
,p_capacity_units
,p_available_24_hour_flag
,p_system_fk
,fnd_date.canonical_to_date(p_disable_date)
,p_resource_name
,p_user_attr1
,p_user_attr2
,p_user_attr3
,p_user_attr4
,p_user_attr5
,p_user_attr6
,p_user_attr7
,p_user_attr8
,p_user_attr9
,p_user_attr10
,p_user_attr11
,p_user_attr12
,p_user_attr13
,p_user_attr14
,p_user_attr15
,p_user_attr16
,p_user_attr17
,p_user_attr18
,p_user_attr19
,p_user_attr20
,p_user_measure1
,p_user_measure2
,p_user_measure3
,p_user_measure4
,p_user_measure5
,p_source_org_code
,p_resource_description
,p_std_utilization
,p_std_efficiency
,p_production_resource
,p_status
,p_business_function
);
UPDATE MTH_RESOURCE_COST_ERR SET
REPROCESS_READY_YN = p_reprocess_ready_yn
,RESOURCE_FK = p_resource_fk
,FROM_DATE = fnd_date.canonical_to_date(p_from_date)
,TO_DATE = fnd_date.canonical_to_date(p_to_date)
,COST_ELEMENT = p_cost_element
,COST = p_cost
,SYSTEM_FK = p_system_fk
,USER_ATTR1 = p_user_attr1
,USER_ATTR2 = p_user_attr2
,USER_ATTR3 = p_user_attr3
,USER_ATTR4 = p_user_attr4
,USER_ATTR5 = p_user_attr5
WHERE ROWID = p_rowid;
INSERT INTO MTH_RESOURCE_COST_ERR (
REPROCESS_READY_YN
,RESOURCE_FK
,FROM_DATE
,TO_DATE
,COST_ELEMENT
,COST
,SYSTEM_FK
,USER_ATTR1
,USER_ATTR2
,USER_ATTR3
,USER_ATTR4
,USER_ATTR5
) VALUES (
p_reprocess_ready_yn
,p_resource_fk
,fnd_date.canonical_to_date(p_from_date)
,fnd_date.canonical_to_date(p_to_date)
,p_cost_element
,p_cost
,p_system_fk
,p_user_attr1
,p_user_attr2
,p_user_attr3
,p_user_attr4
,p_user_attr5
);
UPDATE MTH_RESOURCE_REQUIREMENTS_ERR SET
REPROCESS_READY_YN = p_reprocess_ready_yn
,WORKORDER_FK = p_workorder_fk
,PRODUCT_FK = p_product_fk
,RESOURCE_FK = p_resource_fk
,SEGMENT_FK = p_segment_fk
,PLANNED_USAGE_QTY = p_planned_usage_qty
,USAGE_UOM = p_usage_uom
,UNIT_STANDARD_QTY = p_unit_standard_qty
,SOURCE_ORG_CODE = p_source_org_code
,SYSTEM_FK = p_system_fk
,USER_DIM1_FK = p_user_dim1_fk
,USER_DIM2_FK = p_user_dim2_fk
,USER_DIM3_FK = p_user_dim3_fk
,USER_DIM4_FK = p_user_dim4_fk
,USER_DIM5_FK = p_user_dim5_fk
,USER_ATTR1 = p_user_attr1
,USER_ATTR2 = p_user_attr2
,USER_ATTR3 = p_user_attr3
,USER_ATTR4 = p_user_attr4
,USER_ATTR5 = p_user_attr5
,USER_MEASURE1 = p_user_measure1
,USER_MEASURE2 = p_user_measure2
,USER_MEASURE3 = p_user_measure3
,USER_MEASURE4 = p_user_measure4
,USER_MEASURE5 = p_user_measure5
,SUB_SEGMENT_FK = p_sub_segment_fk
WHERE ROWID = p_rowid;
INSERT INTO MTH_RESOURCE_REQUIREMENTS_ERR (
REPROCESS_READY_YN
,WORKORDER_FK
,PRODUCT_FK
,RESOURCE_FK
,SEGMENT_FK
,PLANNED_USAGE_QTY
,USAGE_UOM
,UNIT_STANDARD_QTY
,SOURCE_ORG_CODE
,SYSTEM_FK
,USER_DIM1_FK
,USER_DIM2_FK
,USER_DIM3_FK
,USER_DIM4_FK
,USER_DIM5_FK
,USER_ATTR1
,USER_ATTR2
,USER_ATTR3
,USER_ATTR4
,USER_ATTR5
,USER_MEASURE1
,USER_MEASURE2
,USER_MEASURE3
,USER_MEASURE4
,USER_MEASURE5
,SUB_SEGMENT_FK
) VALUES (
p_reprocess_ready_yn
,p_workorder_fk
,p_product_fk
,p_resource_fk
,p_segment_fk
,p_planned_usage_qty
,p_usage_uom
,p_unit_standard_qty
,p_source_org_code
,p_system_fk
,p_user_dim1_fk
,p_user_dim2_fk
,p_user_dim3_fk
,p_user_dim4_fk
,p_user_dim5_fk
,p_user_attr1
,p_user_attr2
,p_user_attr3
,p_user_attr4
,p_user_attr5
,p_user_measure1
,p_user_measure2
,p_user_measure3
,p_user_measure4
,p_user_measure5
,p_sub_segment_fk
);
UPDATE MTH_RESOURCE_TXN_ERR SET
REPROCESS_READY_YN = p_reprocess_ready_yn
,WORKORDER_FK = p_workorder_fk
,RESOURCE_FK = p_resource_fk
,PRODUCT_FK = p_product_fk
,SEGMENT_FK = p_segment_fk
,USAGE_QTY = p_usage_qty
,USAGE_UOM = p_usage_uom
,TRANSACTION_DATE = fnd_date.canonical_to_date(p_transaction_date)
,SOURCE_ORG_CODE = p_source_org_code
,SYSTEM_FK = p_system_fk
,USER_DIM1_FK = p_user_dim1_fk
,USER_DIM2_FK = p_user_dim2_fk
,USER_DIM3_FK = p_user_dim3_fk
,USER_DIM4_FK = p_user_dim4_fk
,USER_DIM5_FK = p_user_dim5_fk
,USER_ATTR1 = p_user_attr1
,USER_ATTR2 = p_user_attr2
,USER_ATTR3 = p_user_attr3
,USER_ATTR4 = p_user_attr4
,USER_ATTR5 = p_user_attr5
,USER_MEASURE1 = p_user_measure1
,USER_MEASURE2 = p_user_measure2
,USER_MEASURE3 = p_user_measure3
,USER_MEASURE4 = p_user_measure4
,USER_MEASURE5 = p_user_measure5
,SUB_SEGMENT_FK = p_sub_segment_fk
WHERE ROWID = p_rowid;
INSERT INTO MTH_RESOURCE_TXN_ERR (
REPROCESS_READY_YN
,WORKORDER_FK
,RESOURCE_FK
,PRODUCT_FK
,SEGMENT_FK
,USAGE_QTY
,USAGE_UOM
,TRANSACTION_DATE
,SOURCE_ORG_CODE
,SYSTEM_FK
,USER_DIM1_FK
,USER_DIM2_FK
,USER_DIM3_FK
,USER_DIM4_FK
,USER_DIM5_FK
,USER_ATTR1
,USER_ATTR2
,USER_ATTR3
,USER_ATTR4
,USER_ATTR5
,USER_MEASURE1
,USER_MEASURE2
,USER_MEASURE3
,USER_MEASURE4
,USER_MEASURE5
,SUB_SEGMENT_FK
) VALUES (
p_reprocess_ready_yn
,p_workorder_fk
,p_resource_fk
,p_product_fk
,p_segment_fk
,p_usage_qty
,p_usage_uom
,fnd_date.canonical_to_date(p_transaction_date)
,p_source_org_code
,p_system_fk
,p_user_dim1_fk
,p_user_dim2_fk
,p_user_dim3_fk
,p_user_dim4_fk
,p_user_dim5_fk
,p_user_attr1
,p_user_attr2
,p_user_attr3
,p_user_attr4
,p_user_attr5
,p_user_measure1
,p_user_measure2
,p_user_measure3
,p_user_measure4
,p_user_measure5
,p_sub_segment_fk
);
UPDATE MTH_TAG_MASTER_ERR SET
REPROCESS_READY_YN = p_reprocess_ready_yn
,STATUS = p_status
,DATA_TYPE = p_data_type
,ORDER_TYPE = p_order_type
,READING_TYPE = p_reading_type
,INITIAL_VALUE = p_initial_value
,TAG_DATA_SOURCE_NAME = p_tag_data_source_name
,TAG_CODE = p_tag_code
,TAG_TYPE = p_tag_type
,PLANT_FK_KEY = p_plant_fk_key
,PLC_IDENTIFIER = p_plc_identifier
,TAG_ALIAS = p_tag_alias
,EQUIPMENT_FK_KEY = p_equipment_fk_key
,DESCRIPTION = p_description
,UOM = p_uom
,IS_CUMULATIVE = p_is_cumulative
,MAX_RESET_VALUE = p_max_reset_value
,FREQUENCY_IN_MINUTES = p_frequency_in_minutes
,USER_ATTR1 = p_user_attr1
,USER_ATTR2 = p_user_attr2
,USER_ATTR3 = p_user_attr3
,USER_ATTR4 = p_user_attr4
,USER_ATTR5 = p_user_attr5
,RESET_AFTER_JOB = p_reset_after_job
WHERE ROWID = p_rowid;
INSERT INTO MTH_TAG_MASTER_ERR (
REPROCESS_READY_YN
,STATUS
,DATA_TYPE
,ORDER_TYPE
,READING_TYPE
,INITIAL_VALUE
,TAG_DATA_SOURCE_NAME
,TAG_CODE
,TAG_TYPE
,PLANT_FK_KEY
,PLC_IDENTIFIER
,TAG_ALIAS
,EQUIPMENT_FK_KEY
,DESCRIPTION
,UOM
,IS_CUMULATIVE
,MAX_RESET_VALUE
,FREQUENCY_IN_MINUTES
,USER_ATTR1
,USER_ATTR2
,USER_ATTR3
,USER_ATTR4
,USER_ATTR5
,RESET_AFTER_JOB
) VALUES (
p_reprocess_ready_yn
,p_status
,p_data_type
,p_order_type
,p_reading_type
,p_initial_value
,p_tag_data_source_name
,p_tag_code
,p_tag_type
,p_plant_fk_key
,p_plc_identifier
,p_tag_alias
,p_equipment_fk_key
,p_description
,p_uom
,p_is_cumulative
,p_max_reset_value
,p_frequency_in_minutes
,p_user_attr1
,p_user_attr2
,p_user_attr3
,p_user_attr4
,p_user_attr5
,p_reset_after_job
);
UPDATE MTH_TIME_HIERARCHY_ERR SET
REPROCESS_READY_YN = p_reprocess_ready_yn
,HIERARCHY_NAME = p_hierarchy_name
,CHILD_FK = p_child_fk
,PARENT_FK = p_parent_fk
,LEVEL_NUMBER_OF_CHILD = p_level_number_of_child
,SYSTEM_FK = p_system_fk
WHERE ROWID = p_rowid;
UPDATE MTH_USER_DIM_ENTITIES_ERR SET
REPROCESS_READY_YN = p_reprocess_ready_yn
,DIMENSION_NAME = p_dimension_name
,ENTITY_PK = p_entity_pk
,ENTITY_NAME = p_entity_name
,ENTITY_TYPE = p_entity_type
,USER_ATTR1 = p_user_attr1
,USER_ATTR2 = p_user_attr2
,USER_ATTR3 = p_user_attr3
,USER_ATTR4 = p_user_attr4
,USER_ATTR5 = p_user_attr5
,USER_MEASURE1 = p_user_measure1
,USER_MEASURE2 = p_user_measure2
,USER_MEASURE3 = p_user_measure3
,USER_MEASURE4 = p_user_measure4
,USER_MEASURE5 = p_user_measure5
,SYSTEM_FK = p_system_fk
WHERE ROWID = p_rowid;
INSERT INTO MTH_USER_DIM_ENTITIES_ERR (
REPROCESS_READY_YN
,DIMENSION_NAME
,ENTITY_PK
,ENTITY_NAME
,ENTITY_TYPE
,USER_ATTR1
,USER_ATTR2
,USER_ATTR3
,USER_ATTR4
,USER_ATTR5
,USER_MEASURE1
,USER_MEASURE2
,USER_MEASURE3
,USER_MEASURE4
,USER_MEASURE5
,SYSTEM_FK
) VALUES (
p_reprocess_ready_yn
,p_dimension_name
,p_entity_pk
,p_entity_name
,p_entity_type
,p_user_attr1
,p_user_attr2
,p_user_attr3
,p_user_attr4
,p_user_attr5
,p_user_measure1
,p_user_measure2
,p_user_measure3
,p_user_measure4
,p_user_measure5
,p_system_fk
);
UPDATE MTH_USER_DIM_HIERARCHY_ERR SET
REPROCESS_READY_YN = p_reprocess_ready_yn
,DIMENSION_NAME = p_dimension_name
,HIERARCHY_NAME = p_hierarchy_name
,LEVEL_NUM = p_level_num
,LEVEL_FK = p_level_fk
,PARENT_FK = p_parent_fk
,SYSTEM_FK = p_system_fk
WHERE ROWID = p_rowid;
INSERT INTO MTH_USER_DIM_HIERARCHY_ERR (
REPROCESS_READY_YN
,DIMENSION_NAME
,HIERARCHY_NAME
,LEVEL_NUM
,LEVEL_FK
,PARENT_FK
,SYSTEM_FK
) VALUES (
p_reprocess_ready_yn
,p_dimension_name
,p_hierarchy_name
,p_level_num
,p_level_fk
,p_parent_fk
,p_system_fk
);
UPDATE MTH_WEEK_ERR SET
REPROCESS_READY_YN = p_reprocess_ready_yn
,HIERARCHY_NAME = p_hierarchy_name
,NAME = p_name
,USER_ATTR1 = p_user_attr1
,USER_ATTR2 = p_user_attr2
,USER_ATTR3 = p_user_attr3
,USER_ATTR4 = p_user_attr4
,USER_ATTR5 = p_user_attr5
,USER_MEASURE1 = p_user_measure1
,USER_MEASURE2 = p_user_measure2
,USER_MEASURE3 = p_user_measure3
,USER_MEASURE4 = p_user_measure4
,USER_MEASURE5 = p_user_measure5
,SYSTEM_FK = p_system_fk
,END_DATE = fnd_date.canonical_to_date(p_end_date)
,START_DATE = fnd_date.canonical_to_date(p_start_date)
WHERE ROWID = p_rowid;
UPDATE MTH_WORKDAY_SHIFTS_ERR SET
REPROCESS_READY_YN = p_reprocess_ready_yn
,SHIFT_DATE = fnd_date.canonical_to_date(p_shift_date)
,SOURCE_ORG_CODE = p_source_org_code
,USER_ATTR1 = p_user_attr1
,USER_ATTR2 = p_user_attr2
,USER_ATTR3 = p_user_attr3
,USER_ATTR4 = p_user_attr4
,USER_ATTR5 = p_user_attr5
,USER_MEASURE1 = p_user_measure1
,USER_MEASURE2 = p_user_measure2
,USER_MEASURE3 = p_user_measure3
,USER_MEASURE4 = p_user_measure4
,USER_MEASURE5 = p_user_measure5
,SHIFT_WORKDAY_PK = p_shift_workday_pk
,SYSTEM_FK = p_system_fk
,FROM_DATE = fnd_date.canonical_to_date(p_from_date)
,TO_DATE = fnd_date.canonical_to_date(p_to_date)
,SHIFT_NUM = p_shift_num
,SHIFT_NAME = p_shift_name
,SHIFT_TYPE = p_shift_type
,GRAVEYARD_SHIFT = p_graveyard_shift
WHERE ROWID = p_rowid;
INSERT INTO MTH_WORKDAY_SHIFTS_ERR (
REPROCESS_READY_YN
,SHIFT_DATE
,SOURCE_ORG_CODE
,USER_ATTR1
,USER_ATTR2
,USER_ATTR3
,USER_ATTR4
,USER_ATTR5
,USER_MEASURE1
,USER_MEASURE2
,USER_MEASURE3
,USER_MEASURE4
,USER_MEASURE5
,SHIFT_WORKDAY_PK
,SYSTEM_FK
,FROM_DATE
,TO_DATE
,SHIFT_NUM
,SHIFT_NAME
,SHIFT_TYPE
,GRAVEYARD_SHIFT
) VALUES (
p_reprocess_ready_yn
,fnd_date.canonical_to_date(p_shift_date)
,p_source_org_code
,p_user_attr1
,p_user_attr2
,p_user_attr3
,p_user_attr4
,p_user_attr5
,p_user_measure1
,p_user_measure2
,p_user_measure3
,p_user_measure4
,p_user_measure5
,p_shift_workday_pk
,p_system_fk
,fnd_date.canonical_to_date(p_from_date)
,fnd_date.canonical_to_date(p_to_date)
,p_shift_num
,p_shift_name
,p_shift_type
,p_graveyard_shift
);
UPDATE MTH_WO_SALES_ORDERS_ERR SET
REPROCESS_READY_YN = p_reprocess_ready_yn
,WORKORDER_FK = p_workorder_fk
,SALESORDER_NUMBER = p_salesorder_number
,SALESORDER_LNUMBER = p_salesorder_lnumber
,CUSTOMER = p_customer
,REQUESTED_DATE = fnd_date.canonical_to_date(p_requested_date)
,PROMISED_DATE = fnd_date.canonical_to_date(p_promised_date)
,SCHEDULED_SHIP_DATE = fnd_date.canonical_to_date(p_scheduled_ship_date)
,SYSTEM_FK = p_system_fk
,QUANTITY_G = p_quantity_g
,PRIMARY_UOM = p_primary_uom
,PRODUCT_FK = p_product_fk
,USER_DIM1_FK = p_user_dim1_fk
,USER_DIM2_FK = p_user_dim2_fk
,USER_DIM3_FK = p_user_dim3_fk
,USER_DIM4_FK = p_user_dim4_fk
,USER_DIM5_FK = p_user_dim5_fk
,USER_ATTR1 = p_user_attr1
,USER_ATTR2 = p_user_attr2
,USER_ATTR3 = p_user_attr3
,USER_ATTR4 = p_user_attr4
,USER_ATTR5 = p_user_attr5
,USER_MEASURE1 = p_user_measure1
,USER_MEASURE2 = p_user_measure2
,USER_MEASURE3 = p_user_measure3
,USER_MEASURE4 = p_user_measure4
,USER_MEASURE5 = p_user_measure5
,RESERVATION_PK = p_reservation_pk
WHERE ROWID = p_rowid;
INSERT INTO MTH_WO_SALES_ORDERS_ERR (
REPROCESS_READY_YN
,WORKORDER_FK
,SALESORDER_NUMBER
,SALESORDER_LNUMBER
,CUSTOMER
,REQUESTED_DATE
,PROMISED_DATE
,SCHEDULED_SHIP_DATE
,SYSTEM_FK
,QUANTITY_G
,PRIMARY_UOM
,PRODUCT_FK
,USER_DIM1_FK
,USER_DIM2_FK
,USER_DIM3_FK
,USER_DIM4_FK
,USER_DIM5_FK
,USER_ATTR1
,USER_ATTR2
,USER_ATTR3
,USER_ATTR4
,USER_ATTR5
,USER_MEASURE1
,USER_MEASURE2
,USER_MEASURE3
,USER_MEASURE4
,USER_MEASURE5
,RESERVATION_PK
) VALUES (
p_reprocess_ready_yn
,p_workorder_fk
,p_salesorder_number
,p_salesorder_lnumber
,p_customer
,fnd_date.canonical_to_date(p_requested_date)
,fnd_date.canonical_to_date(p_promised_date)
,fnd_date.canonical_to_date(p_scheduled_ship_date)
,p_system_fk
,p_quantity_g
,p_primary_uom
,p_product_fk
,p_user_dim1_fk
,p_user_dim2_fk
,p_user_dim3_fk
,p_user_dim4_fk
,p_user_dim5_fk
,p_user_attr1
,p_user_attr2
,p_user_attr3
,p_user_attr4
,p_user_attr5
,p_user_measure1
,p_user_measure2
,p_user_measure3
,p_user_measure4
,p_user_measure5
,p_reservation_pk
);
UPDATE MTH_YEAR_ERR SET
REPROCESS_READY_YN = p_reprocess_ready_yn
,HIERARCHY_NAME = p_hierarchy_name
,NAME = p_name
,USER_ATTR1 = p_user_attr1
,USER_ATTR2 = p_user_attr2
,USER_ATTR3 = p_user_attr3
,USER_ATTR4 = p_user_attr4
,USER_ATTR5 = p_user_attr5
,USER_MEASURE1 = p_user_measure1
,USER_MEASURE2 = p_user_measure2
,USER_MEASURE3 = p_user_measure3
,USER_MEASURE4 = p_user_measure4
,USER_MEASURE5 = p_user_measure5
,SYSTEM_FK = p_system_fk
,END_DATE = fnd_date.canonical_to_date(p_end_date)
,START_DATE = fnd_date.canonical_to_date(p_start_date)
WHERE ROWID = p_rowid;