Business Processes for the Party Entity

The Party Entity has the following basic BPs:

• Add a Party Object
• Modify a Party Object
• Delete a Party Object
• Retrieve a Party Object

Since the Party Entity can have many different roles (Customer, Supplier, Person etc.) the above BPs affect more than one table.

An Object is a record or a set of records (in one or more tables) that "inherits the structure" of an Entity

This BP adds a gParty record and - if needed - adds gPerson, sCustomer, pSupplier and hEmloyee records to the database.

Name

BP_Party_add

Call

BP_Party_add(LOCAL p_R_gParty is Record of gParty, LOCAL p_R_gPerson is Record of gPerson, LOCAL p_R_sCustomer is Record of sCustomer, LOCAL p_R_pSupplier is Record of pSupplier, LOCAL p_R_hEmployee is Record of hEmployee, LOCAL p_sUserPK is string, p_sReturnPK is string, p_sErrorMessage is string)

Returns

• True or
• False

Flow

1. Start a transaction
2. Call BP_Party_add_private, passing to it the SAME variables it received
3. BP_Party_add_private returns true (if everything was OK) or false (if there was an error)
4. IF true then COMMIT ELSE ROLLBACK

Other Data Returned

• p_sReturnPK - see the call - returns the PK of the Party Entity, if the add was successful
• p_sErrorMessage - see the call - returns the error, if the add was not successful

This BP modifies a gParty record and - if needed - adds, modifies or deletes gPerson, sCustomer, pSupplier and hEmloyee records from the database.

Name

BP_Party_modify

Call

BP_Party_modify(LOCAL p_R_gParty is Record of gParty, LOCAL p_R_gPerson is Record of gPerson, LOCAL p_R_sCustomer is Record of sCustomer, LOCAL p_R_pSupplier is Record of pSupplier, LOCAL p_R_hEmployee is Record of hEmployee, LOCAL p_sUserPK is string, p_sErrorMessage is string)

Returns

• True or
• False

Flow

1. Start a transaction
2. Call BP_Party_modify_private, passing to it the SAME variables it received
3. BP_Party_modify_private returns true (if everything was OK) or false (if there was an error)
4. IF true then COMMIT ELSE ROLLBACK

Other Data Returned

• p_sErrorMessage - see the call - returns the error, if the add was not successful

This BP deletes a gParty record and - if needed - deletes gPerson, sCustomer, pSupplier and hEmloyee records from the database.

Name

BP_Party_delete

Call

BP_Party_delete(LOCAL p_sPartyPK is string, LOCAL p_sUserPK is string, p_sErrorMessage is string)

Returns

• True or
• False

Flow

1. Start a transaction
2. Call BP_Party_delete_private, passing to it the SAME variables it received
3. BP_Party_delete_private returns true (if everything was OK) or false (if there was an error)
4. IF true then COMMIT ELSE ROLLBACK

Other Data Returned

• p_sErrorMessage - see the call - returns the error, if the add was not successful

This BP gets a gParty record by its PK and fills the record buffer.

Name

BP_Party_get

Call

BP_Party_get(LOCAL p_sPartyPK is string, p_sErrorMessage is string)

Returns

• True or
• False

Flow

Just a simple HReadSeekFirst()

Other Data Returned

• p_sErrorMessage - see the call - returns the error, if there was an Exception or Error