File Name
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
File Name
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
File Name
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
File Name
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
File Name
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
File Name
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
File Name
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
File Name
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
File Name
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
File Name
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
File Name
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
File Name
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
File Name
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
File Name
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
File Name
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
File Name
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
File Name
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
File Name
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
File Name
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
File Name
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
File Name
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
File Name
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
File Name
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
File Name
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
File Name
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
File Name
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
File Name
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
File Name
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
File Name
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
File Name
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
File Name
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
File Name
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
File Name
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
File Name
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
File Name
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
File Name
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
File Name
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
File Name
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
File Name
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
File Name
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
File Name
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
File Name
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