Routines for i_db_hst.kb


GenerateMovedEvent

File Name

i_db_hst.kb

Syntax

GenerateMovedEvent(VAL table: STRING, VAL oldID: STRING, VAL newID: STRING, VAL iid: INTEGER, VAL event_id: INTEGER, REF histBeforeList: LIST OF Inventory_HistoryRec, REF histAfterList: LIST OF Inventory_HistoryRec)

Parameters

table - table name

oldID - old ID depending on the table

newID - new ID depending on the table

iid - inventory ID

event_id - event ID

histBeforeList - old list of inventory history records

histAfterList - new list of inventory history records

Returns

histBeforeList, histAfterList, function result

Side Effects

None

Description

This function is used to create moved events.

Dialog Forms Called

None


GenerateMovedEvent2

File Name

i_db_hst.kb

Syntax

GenerateMovedEvent2(VAL table: STRING, VAL oldID: STRING, VAL newID: STRING, VAL iid: INTEGER, VAL event_id: INTEGER, REF histBeforeList: LIST OF Inventory_HistoryRec, REF histAfterList: LIST OF Inventory_HistoryRec)

Parameters

table - table name

oldID - old category ID

newID - new category ID

iid - is_inventory_id

event_id - event ID

histBeforeList - list of old inventory history records

histAfterList - list of new inventory history records

Returns

histBeforeList, histAfterList, list insert was successful or not

Side Effects

None

Description

This function inserts a new inventory history record in the list for a moved event.

Dialog Forms Called

None


GetHist

File Name

i_db_hst.kb

Syntax

GetHist(REF lst: LIST OF Inventory_HistoryRec, VAL iid: INTEGER)

Parameters

lst - list of inventory history records

iid - inventory ID

Returns

lst, SQLSelect return result

Side Effects

None

Description

This function returns the list of inventory history records for a selected asset.

Dialog Forms Called

None


GetInvHist

File Name

i_db_hst.kb

Syntax

GetInvHist(REF histList: LIST OF HistViewRec,VAL is_inventory_id: INTEGER)

Parameters

None

Returns

Integer for success or failure

Side Effects

None

Description

This function returns a list of inventory history records for the selected inventory ID.

Dialog Forms Called

None


GetInvHistRec

File Name

i_db_hst.kb

Syntax

GetInvHistRec( VAL inv_hist_id: INTEGER, REF newinvrec: Inventory_HistoryRec)

Parameters

inv_hist_id - inventory history ID

newinvrec - new inventory history record

Returns

result of SQLSelectInto

Side Effects

None

Description

This function gets an inventory history record based on the inventory history ID.

Dialog Forms Called

None


GetSomeInvHist

File Name

i_db_hst.kb

Syntax

GetSomeInvHist(VAL where: STRING, REF lst: LIST OF HistViewRec)

Parameters

where - WHERE clause of select statement

lst - list of inventory history view records

Returns

lst, SQLSelectInto return result

Side Effects

None

Description

This function returns a list of inventory history view records based on the WHERE clause.

Dialog Forms Called

None


InsertMovedEventsForInv

File Name

i_db_hst.kb

Syntax

InsertMovedEventsForInv(VAL before: IS_InventoryRec, VAL after: IS_InventoryRec)

Parameters

before - old inventory record

after - new inventory record

Returns

result of UpdateListOfHistRec

Side Effects

None

Description

This function updates a list of inventory history records for moved events.

Dialog Forms Called

None