F3293DeleteAIREditGroup

F3293 Delete AIR Edit Group

Minor Business Rule

Object Name: B3200250

Parent DLL: CMFG

Location: Client/Server

Language: C

1.Functional Description

1.1Purpose
This function is used to delete an edit group from a set of Assembly Inclusion Rules. All rules from
the deletion point (i.e. beginning rule number passed in through input parameters) are "moved up",
i.e. rule number is decremented by 1 to fill in the gap left by the deleted group. Any associated Rule
Values (F32921) or Rule Ranges (F32922) rows are also updated to the new rule number.

1.2Setup Notes and Prerequisites
No special setup for this function.

1.3Special Logic
There is no special logic within this function.

2.Technical Specifications
2.4Processing

A. Using the key values passed in as input parameters, select all rows from F3293 for the Configured
Item, Branch/Plant, and Rule Type.  Read all selected rows; skip processing any rows with a rule
number less than or equal to the beginning rule number passed in as input.
B. For each edit group selected for processing (i.e. edit groups with rule numbers greater than the
beginning rule number), decrement the edit group rule number by 1.  Read F3293 with the new key value.
If the record exists, overwrite the record; if the record does not already exist on F3293, write a
new F3293 row into the table. (B3200090-Update Assembly Inclusion Rule" business function is used for
this update).
C. At an edit group break, any "leftover" rules (i.e. rules which were not overwritten) from an edit
group should be deleted (B3200130-Delete Assembly Inclusion Rule" business function is used for this
delete).
D. At the end of processing all selected rows, the last edit group for this Configured Item,
Branch/Plant, and Rule Type should be deleted because it has been re-written with a new (decremented) rule
number.
E. For each F3293 row processed, select all rows from the Rule Values (F32921) table with the same
Configured Item, Branch/Plant, Rule Type and Rule Number if the Selection Values (ATIV) column contains
*VALUE or *VALUES. Write new values records for all rows retrieved with the new rule number using the
F32921 Update Rule Values business function (B3200160).  Values records for the "old" rule number
should be deleted after the new records are written.
F. For each F3293 row processed, select all rows from the Rule Ranges (F32922) table with the same
Configured Item, Branch/Plant, Rule Type and Rule Number if the Selection Values (ATIV) column contains
*RANGE or *RANGES.  Write new ranges records for all rows retrieved with the new rule number using the
F32922 Update Rule Ranges business function (B3200170). Ranges records for the "old" rule number
should be deleted after the new records are written.

Data Structure

D3200250 - F3293 Delete AIR Edit Group

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnConfiguredItemShort	KIT	MATH_NUMERIC	NONE	NONE
The system provides for three separate item numbers. 1. Item Number (short) - An eight-digit, computer assigned, completely non-significant item number. 2. 2nd Item Number - The 25-digit, free form, user defined alphanumeric item number. 3. 3rd Item Number - Another 25-digit, free form, user defined alphanumeric item number.
szBranchPlant	MCU	char	NONE	NONE
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit might be a warehouse location, job, project, work center, branch, or plant. You can assign a business unit to a document, entity, or person for purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by business unit to track equipment by responsible department. Business unit security might prevent you from viewing information about business units for which you have no authority.
cRuleType	ATOT	char	NONE	NONE
A value that identifies whether the resulting value of the assembly inclusion rule is a part number, price, routing operation, or calculated value. The valid values are: P Part List Q Work Order Component C Calculation H Hot Spot X Price/Cost Adjustment R Route Sheet
mnBegRuleNumber	ATO#	MATH_NUMERIC	NONE	NONE
The number associated with a set of cross-segment editing rules or assembly inclusion rules.
cSuppressErrorMessages	EV01	char	NONE	NONE
An option that specifies the type of processing for an event.
szErrorMessageID	DTAI	char	NONE	NONE
A code that identifies and defines a unit of information. It is an alphanumeric code up to 8 characters long that does not allow blanks or special characters such as %, &, or +. You create new data items using system codes 55-59. You cannot change the alias.

Related Functions

B3200090 F3293 Update Assembly Inclusion Rule
B3200130 F3293 Delete Assembly Inclusion Rule
B3200160 F32921 Update Rule Values
B3200170 F32922 Update Rule Ranges

Related Tables

F32921 Cross Segment Editing Rules - Values
F32922 Cross Segment Editing Rules - Range
F3293 Assembly Inclusions Rules