Routines for i_db_inv.kb


AddPersonToInv

File Name

i_db_inv.kb

Syntax

AddPersonToInv (VAL invlist: LIST OF IS_InventoryRec, REF people_id: INTEGER)

Parameters

invlist - list of assets

people_id - ID of person to be associated with the list of assets

Returns

SQL return result

Side Effects

None

Description

This function associates the selected person with a list of assets.

Dialog Forms Called

None


ConstructInvUpdate

File Name

i_db_inv.kb

Syntax

ConstructInvUpdate(REF update: InvUpdateRec, VAL iid: INTEGER, VAL wHdl: WINDOW, VAL organization_ID: STRING)

Parameters

update - inventory update record

iid - inventory ID

wHdl - parent window handle

organization_id - organization ID

Returns

SQL return result

Side Effects

None

Description

This function builds an inventory update record.

Dialog Forms Called

None


DeleteContainerFromTree

File Name

i_db_inv.kb

Syntax

DeleteContainerFromTree( VAL parent: STRING, VAL child: STRING )

Parameters

parent - parent ID in pm_object_tree

child - child ID in pm_object_tree

Returns

SQLDelete result

Side Effects

None

Description

This function deletes a record association from pm_object_tree.

Dialog Forms Called

None


DeleteInv_ConnectionRec

File Name

i_db_inv.kb

Syntax

DeleteInv_ConnectionRec(VAL InTran: BOOLEAN, REF BeforeRec: Inv_ConnectionRec)

Parameters

InTran - in a transaction or not

BeforeRec - connection associated with an asset

Returns

SQL return result

Side Effects

None

Description

This function deletes a connection associated with a asset.

Dialog Forms Called

None


DeleteInv_PeopleRec

File Name

i_db_inv.kb

Syntax

DeleteInv_PeopleRec(VAL InTran: BOOLEAN, REF BeforeRec: Inv_PeopleRec)

Parameters

InTran - in a transaction or not

BeforeRec - user associated with asset

Returns

SQL return result

Side Effects

None

Description

This function deletes a user/asset association.

Dialog Forms Called

None


DeleteInvalidContainer

File Name

i_db_inv.kb

Syntax

DeleteInvalidContainer(VAL Parent: STRING, VAL child: STRING )

Parameters

parent- parent ID in pm_object_tree

child - child ID in pm_object_tree

Returns

Integer

Side Effects

None

Description

This function deletes a specific container tree record from the pm_object_tree. This function is used for validating containers in a secure environment.

Dialog Forms Called

None


DeleteInvRec

File Name

i_db_inv.kb

Syntax

DeleteInvRec(VAL InTran: BOOLEAN, REF BeforeRec: IS_InventoryRec)

Parameters

InTran - in a transaction or not

BeforeRec - old inventory record

Returns

SQL return result

Side Effects

None

Description

This function deletes an inventory record.

Dialog Forms Called

None


DeletePersonFromInv

File Name

i_db_inv.kb

Syntax

DeletePersonFromInv(VAL invlist: LIST OF IS_InventoryRec, REF people_id: INTEGER)

Parameters

invlist - list of assets

people_id - ID of person to be deleted

Returns

SQL return result

Side Effects

None

Description

This function deletes the selected person for a list of assets.

Dialog Forms Called

None


DeletePM_Object

File Name

i_db_inv.kb

Syntax

DeletePM_Object(VAL InTran: BOOLEAN, REF DeleteRec: PM_ObjectRec)

Parameters

InTran - in a transaction or not

DeleteRec - pm_object (container) record to be deleted

Returns

SQL return result

Side Effects

None

Description

This function deletes a pm_object record.

Dialog Forms Called

None


DuplicateAssetTag

File Name

i_db_inv.kb

Syntax

DuplicateAssetTag(VAL newTag: STRING, VAL oldID: INTEGER)

Parameters

newTag - asset tag

oldID - inventory ID

Returns

SQL return result

Side Effects

None

Description

This procedure checks to see if the inventory_id already exists.

Dialog Forms Called

None


GetAssetTag

File Name

i_db_inv.kb

Syntax

GetAssetTag ( VAL is_inventory_id: INTEGER )

Parameters

is_inventory_id - ID of selected asset

Returns

asset_tag

Side Effects

None

Description

This function retrieves the asset tag.

Dialog Forms Called

None


GetAssetVisibleOrg

File Name

i_db_inv.kb

Syntax

GetAssetVisibleOrg(VAL inv_id: INTEGER): INTEGER

Parameters

inv_id- is_inventory_id

Returns

integer

Side Effects

None

Description

This function returns the visible organization id associated with the given inventory record.

Dialog Forms Called

None


GetDeletedOrNotDeletedInvRecByID

File Name

i_db_inv.kb

Syntax

GetDeletedOrNotDeletedInvRecByID( VAL get_deleted: BOOLEAN, VAL is_inventory_id: INTEGER, REF InvRec: IS_InventoryRec )

Parameters

get_deleted - deleted field

is_inventory_id - inventory ID

InvRec - inventory record

Returns

is_inventory record , SQLSelectInto return result

Side Effects

None

Description

This function gets an is_inventory record for deleted and undeleted assets by is_inventory_id.

Dialog Forms Called

None


GetDelInvID

File Name

i_db_inv.kb

Syntax

GetDelInvID(VAL asset_tag: STRING)

Parameters

asset_tag - asset tag

Returns

is_inventory_id

Side Effects

None

Description

This function gets a deleted asset's is_inventory_id based on the asset tag.

Dialog Forms Called

None


GetInv_ConnectionRec

File Name

i_db_inv.kb

Syntax

GetInv_ConnectionRec( REF ic: Inv_ConnectionRec )

Parameters

ic - inventory connection record

Returns

SQL return result

Side Effects

None

Description

This function retrieves an inv_connection_id.

Dialog Forms Called

None


GetInv_ConnectionRecs

File Name

i_db_inv.kb

Syntax

GetInv_ConnectionRecs(REF inv_connectionList: LIST OF inv_connectionRec, VAL where: STRING)

Parameters

where - selection criteria against inventory connection

inv_connectionList - list of connections associated with an asset

Returns

SQL return result

Side Effects

None

Description

This function retrieves a list of connections associated with a particular asset.

Dialog Forms Called

None


GetInv_People_IDExternal_Map

File Name

i_db_inv.kb

Syntax

GetInv_People_IDExternal_Map( VAL isinventoryid: INTEGER )

Parameters

isinventoryid - inventory ID

Returns

inv_people_id

Side Effects

None

Description

This function gets an inv_people_id based on the is_inventory_id.

Dialog Forms Called

None


GetInv_People_IDFromInv_People

File Name

i_db_inv.kb

Syntax

GetInv_People_IDFromInv_People( VAL peopleid: INTEGER, VAL invpeopleid: INTEGER )

Parameters

peopleid - people ID

invpeopleid - inventory ID

Returns

inv_people_id

Side Effects

None

Description

This function gets an inv_people_id based on the people ID and the inventory ID.

Dialog Forms Called

None


GetInv_PeopleRecs

File Name

i_db_inv.kb

Syntax

GetInv_PeopleRecs(REF inv_peopleList: LIST OF inv_PeopleRec, VAL id: INTEGER)

Parameters

inv_peopleList - list of users associated with an asset

id - asset ID

Returns

SQL return result

Side Effects

None

Description

This function retrieves a list of users associated with a particular asset.

Dialog Forms Called

None


GetInvContractList

File Name

i_db_inv.kb

Syntax

GetInvContractList(REF kList: LIST OF InvContractRec, VAL is_inventory_id: INTEGER)

Parameters

klist - list of contracts associated with selected asset

is_inventory_id - ID of selected asset

Returns

SQLSelect success or failure

Side Effects

None

Description

This function is used to retrieve a list of contracts associated with the asset ID specified.

Dialog Forms Called

None


GetInvList

File Name

i_db_inv.kb

Syntax

GetInvList( VAL tablename: STRING, VAL id: STRING, REF invlist: LIST OF IS_InventoryRec, VAL visorg: STRING)

Parameters

tablename - table name

id - ID related to table name

invlist - list of assets

visorg - supported organization ID

Returns

SQL return result, invlist

Side Effects

None

Description

This function retrieves a list of assets based on the table name and ID.

Dialog Forms Called

None


GetInvPeopleList

File Name

i_db_inv.kb

Syntax

GetInvPeopleList(VAL people_id: INTEGER, REF newinvlist: LIST OF Inv_PeopleRec)

Parameters

people_id - ID of person

newinvlist - list of assets associated with the person

Returns

SQL return result

Side Effects

None

Description

This function retrieves a list of assets that are associated with the selected person.

Dialog Forms Called

None


GetPM_ObjectIDRec

File Name

i_db_inv.kb

Syntax

GetPM_ObjectIDRec(REF ktype: PM_ObjectRec)

Parameters

ktype - pm_object (container) record

Returns

SQL return result

Side Effects

None

Description

This function retrieves a container record for a selected pm_object_id.

Dialog Forms Called

None


GetPM_ObjectRec

File Name

i_db_inv.kb

Syntax

GetPM_ObjectRec(REF ktype: PM_ObjectRec)

Parameters

ktype - pm_object (container) record

Returns

SQL return result

Side Effects

None

Description

This function retrieves a container record for a selected inventory_id.

Dialog Forms Called

None


GetSomeInvListPC

File Name

i_db_inv.kb

Syntax

GetSomeInvListPC(VAL where: STRING, VAL people_where:STRING, VAL connection_where:STRING, REF ktypeList: LIST OF IS_InventoryRec)

Parameters

where - selection criteria against IS_Inventory

people_where - selection criteria for people to create subselect

connection_where - selection criteria for connections to create subselect

Returns

list of inventory records; integer indicating success or failure

Side Effects

None

Description

This function returns a list of inventory records matching criteria against the IS_Inventory table, as well as criteria for people and connections.

Dialog Forms Called

None


GetSomePMOList

File Name

i_db_inv.kb

Syntax

GetSomePMOList(REF lst: LIST OF PM_ObjectRec, VAL where: STRING)

Parameters

lst - list of PM_Object records

where - Where clause of select string

Returns

lst, SQLSelect return result

Side Effects

None

Description

This function returns a list of PM_Object records based on the Where clause.

Dialog Forms Called

None


InsertInv_ConnectionRec

File Name

i_db_inv.kb

Syntax

InsertInv_ConnectionRec(VAL G_Flag: BOOLEAN, VAL InTran: BOOLEAN, REF InsertRec: Inv_ConnectionRec)

Parameters

G_Flag - global flag

InTran - in a transaction or not

InsertRec - connection to be associated with an asset

Returns

SQL return result

Side Effects

None

Description

This function associates a connection with an asset.

Dialog Forms Called

None


InsertInv_PeopleRec

File Name

i_db_inv.kb

Syntax

InsertInv_PeopleRec(VAL G_Flag: BOOLEAN, VAL InTran: BOOLEAN, REF InsertRec: Inv_PeopleRec)

Parameters

G_Flag - global flag

InTran - in a transaction or not

InsertRec - new record associating a person with an asset

Returns

SQL return result

Side Effects

None

Description

This function inserts a new record associating a user with an asset.

Dialog Forms Called

None


InsertInvRec

File Name

i_db_inv.kb

Syntax

InsertInvRec(VAL InTran: BOOLEAN,REF InsertRec: IS_InventoryRec)

Parameters

InTran - in a transaction or not

InsertRec - inventory record

Returns

SQL return result

Side Effects

None

Description

This function inserts a new inventory record.

Dialog Forms Called

None


InsertPM_Object

File Name

i_db_inv.kb

Syntax

InsertPM_Object(VAL InTran: BOOLEAN, REF InsertRec: PM_ObjectRec)

Parameters

InTran - in a transaction or not

InsertRec - pm_object (container) record to be inserted

Returns

SQL return result

Side Effects

None

Description

This function inserts a new pm_object record.

Dialog Forms Called

None


NextAssetTag

File Name

i_db_inv.kb

Syntax

NextAssetTag( REF newTag: STRING )

Parameters

newTag - new asset tag

organization_id - supported organization of asset

Returns

new asset tag

Side Effects

None

Description

This function gets a new asset tag. Asset copy uses this function.

Dialog Forms Called

None


NumberListOfInventoryItems

File Name

i_db_inv.kb

Syntax

NumberListOfInventoryItems(REF updateList: LIST OF InvUpdateRec)

Parameters

updateList - list of inventory update records

Returns

Integer indicating success or failure

Side Effects

None

Description

This gets the next number in the different inventory tables.

Dialog Forms Called

None


PurgeInvRec

File Name

i_db_inv.kb

Syntax

PurgeInvRec(VAL InTran: BOOLEAN,REF PurgeRec: IS_InventoryRec)

Parameters

InTran - in a transaction or not

PurgeRec - is_inventory record to be purged

Returns

SQLDelete return result

Side Effects

None

Description

This function deletes an is_inventory record from the is_inventory table.

Dialog Forms Called

None


UpdateAssetLocTo

File Name

i_db_inv.kb

Syntax

UpdateAssetLocTo(VAL invlist: LIST OF IS_InventoryRec, REF location_namea: STRING, REF location_nameb: STRING)

Parameters

invlist - list of assets

location_namea - orginal location

location_nameb - new location

Returns

SQL return result

Side Effects

None

Description

This function updates the location for a list of assets.

Dialog Forms Called

None


UpdateAssetOrgTo

File Name

i_db_inv.kb

Syntax

UpdateAssetOrgTo(VAL invlist: LIST OF IS_InventoryRec, REF beforeorgfrom: STRING, REF beforeorgto: STRING)

Parameters

invlist - list of assets

beforeorgfrom - orginal organization

beforeorgto - new organization

Returns

SQL return result

Side Effects

None

Description

This function updates the organization for a list of assets.

Dialog Forms Called

None


UpdateInv_ConnectionRec

File Name

i_db_inv.kb

Syntax

UpdateInv_ConnectionRec(VAL InTran: BOOLEAN, REF BeforeRec: Inv_ConnectionRec, REF AfterRec: Inv_ConnectionRec)

Parameters

InTran - in a transaction or not

BeforeRec - old connection associated with an asset

AfterRec - new connection associated with an asset

Returns

SQL return result

Side Effects

None

Description

This function updates a connection associated with a asset.

Dialog Forms Called

None


UpdateInv_PeopleRec

File Name

i_db_inv.kb

Syntax

UpdateInv_PeopleRec(VAL InTran: BOOLEAN, REF BeforeRec: Inv_PeopleRec, REF AfterRec: Inv_PeopleRec)

Parameters

InTran - in a transaction or not

BeforeRec - old record of user associated with selected asset

AfterRec - new record of user associated with selected asset

Returns

SQL return result

Side Effects

None

Description

This function updates a user associated with an asset.

Dialog Forms Called

None


UpdateInvRec

File Name

i_db_inv.kb

Syntax

UpdateInvRec(VAL InTran: BOOLEAN, REF BeforeRec: IS_InventoryRec, REF AfterRec: IS_InventoryRec)

Parameters

InTran - in a transaction or not

BeforeRec - old inventory record

AfterRec - new inventory record

Returns

SQL return result

Side Effects

None

Description

This function updates an inventory record. If the ID is not in the table, then the inventory record is added.

Dialog Forms Called

None


UpdateListOfInv_ConnectionRec

File Name

i_db_inv.kb

Syntax

UpdateListOfInv_ConnectionRec(VAL G_Flag: BOOLEAN, VAL InTran: BOOLEAN, REF BeforeList: LIST OF Inv_ConnectionRec, REF AfterList: List OF Inv_ConnectionRec)

Parameters

G_Flag - global flag

InTran - in a transaction or not

BeforeList - old list of connections associated with an asset

AfterList - new list of connections associated with an asset

Returns

SQL return result

Side Effects

None

Description

This function updates a list of connections associated with an asset.

Dialog Forms Called

None


UpdateListOfInv_PeopleRec

File Name

i_db_inv.kb

Syntax

UpdateListOfInv_PeopleRec(VAL G_Flag: BOOLEAN, VAL InTran: BOOLEAN, REF BeforeList: LIST OF Inv_PeopleRec, REF AfterList: List OF Inv_PeopleRec)

Parameters

G_Flag - global flag

InTran - in a transaction or not

BeforeList - old list of users associated with selected asset

AfterList - new list of users associated with selected asset

Returns

SQL return result

Side Effects

None

Description

This function updates a list of users associated with an asset.

Dialog Forms Called

None


UpdateListOfInvRec

File Name

i_db_inv.kb

Syntax

UpdateListOfInvRec(VAL InTran: BOOLEAN, REF BeforeList: LIST OF IS_InventoryRec, REF AfterList: LIST OF IS_InventoryRec)

Parameters

InTran - in a transaction or not

BeforeList - old list of assets

AfterList - new list of assets

Returns

SQL return result

Side Effects

None

Description

This function updates a list of assets.

Dialog Forms Called

None


UpdatePM_Object

File Name

i_db_inv.kb

Syntax

UpdatePM_Object(VAL InTran: BOOLEAN, REF BeforeRec: PM_ObjectRec, REF AfterRec: PM_ObjectRec)

Parameters

InTran - in a transaction or not

BeforeRec - old container record

AfterRec - new container record

Returns

SQL return result

Side Effects

None

Description

This function updates a container record.

Dialog Forms Called

None