CheckForAddApprovalRoutings

Check For Additional Approval Routings

Major Business Rule

Object Name: B3000830

Parent DLL: CMFGBASE

Location: Client/Server

Language: C

1.Functional Description
This business function will check  records with the same Order Type (DCTO) and Branch (MMCU) in table
F4808 and return a specific value in the Additional Group Exists field depending on the existence of
any records with a Group Number higher than the one passed to the program.

1.1Purpose
This business function is called from P4818 if the Order Approval Complete flag is equal to '1' (all
records for the same Order Number have an Approval Status equal to 'A').  If the returned value in the
Additional Group Exists field is equal to '1', then Program P48181 will be called to add more records
to table F4818.

1.2Setup Notes and Prerequisites
There might be many records with the same Key List (Order Type, Branch, and Group Number). A pointer
should be set at the beginning of a Group Number higher than the one passed for the same Order Type,
Branch.  Two conditions might exist:

• No records exist with a Group Number higher than the one passed for the same Order Type, Branch.  In
this case, set Additional Group Exists field to '0'
• At least one record exists with a Group Number higher than the one passed for the same Order Type,
Branch.  In this case, set Additional Group Exists field to '1'

1.3Special Logic
The Additional Group Exists field should be used in the design specs for Program 'P48181'.  This
program is in the development phase.

2.Technical Specifications

2.4Processing
The primary key to Table F4808 is: Order Type (DCTO), Branch (MMCU), Group Number (GRPG), and
Sequence Number (OSEQ).
• Initialize the flag Additional Group Exists (EV01) to 0
• Set the pointer at the first record with a Group Number higher than the one passed from the Program
P4818 for the same Order Type, Branch (there might be none)
• One of the following conditions will be met:

• no records exist for a Group Number higher than the one passed (for the same Order Type,
Branch), set Additional Group Exists flag to '0'
• at least one record exists with a Group Number higher than the one passed ( for the same Order
Type, Branch), set the Additional Group Exists flag to '1'

Data Structure

D3000830 - Check For Additional Approval Routings

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szOrderType	DCTO	char	NONE	NONE
A user defined code (00/DT) that identifies the type of document. This code also indicates the origin of the transaction. J.D. Edwards has reserved document type codes for vouchers, invoices, receipts, and time sheets, which create automatic offset entries during the post program. (These entries are not self-balancing when you originally enter them.) The following document types are defined by J.D. Edwards and should not be changed: P Accounts Payable documents R Accounts Receivable documents T Payroll documents I Inventory documents O Purchase Order Processing documents J General Accounting/Joint Interest Billing documents S Sales Order Processing documents
szBranch	MMCU	char	NONE	NONE
A code that represents a high-level business unit. Use this code to refer to a branch or plant that might have departments or jobs, which represent lower-level business units, subordinate to it. For example: o Branch/Plant (MMCU) o Dept A (MCU) o Dept B (MCU) o Job 123 (MCU) Business unit security is based on the higher-level business unit.
mnGroupNumber	GRPG	MATH_NUMERIC	NONE	NONE
A number used to combine similar records.
cAdditionalGroupExists	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.
cSuppressErrorMessages	EV01	char	NONE	NONE
An option that specifies the type of processing for an event.

Related Functions

None

Related Tables

F4808 Order Routing Approval Master