File Name
Syntax
DeleteReportAttribRec(VAL InTran: BOOLEAN, REF DeleteRec: ReportAttribRec): INTEGER
Parameters
inTran: if already in a transaction or not
DeleteRec: report attribute record
Returns
INTEGER: success or failure
Side Effects
None
Description
This function deletes a report attribute record from the report_attrib table.
Dialog Forms Called
None
File Name
Syntax
DeleteReportDetailRec(VAL InTran: BOOLEAN, REF DeleteRec: ReportDetailRec): INTEGER
Parameters
inTran: if already in a transaction or not
DeleteRec: report detail record to be deleted
Returns
Nothing
Side Effects
None
Description
This function deltes the report detail record from the report_detail table.
Dialog Forms Called
None
File Name
Syntax
DeleteReportHObjRec(VAL InTran: BOOLEAN, REF DeleteRec: ReportHObjRec): INTEGER
Parameters
inTran: if already in a transaction or not
InsertRec: report hobj(category) record to be deleted
Returns
INTEGER: success or failure
Side Effects
None
Description
This function deletes the report hobj record from the report_h_obj table.
Dialog Forms Called
None
File Name
Syntax
DeleteReportIObjRec(VAL InTran: BOOLEAN, REF DeleteRec: ReportIObjRec): INTEGER
Parameters
inTran: if already in a transaction or not
DeleteRec: report iobj(model) record
Returns
INTEGER: success or failure
Side Effects
None
Description
This function deletes a report iobj(model) record from the report_i_obj table.
Dialog Forms Called
None
File Name
Syntax
DeleteReportTreeRec(VAL InTran: BOOLEAN, REF DeleteRec: ReportTreeRec): INTEGER
Parameters
inTran: if already in a transaction or not
DeleteRec: report tree record
Returns
INTEGER: success or failure
Side Effects
None
Description
This function deletes a report tree record from the report_tree table.
Dialog Forms Called
None
File Name
Syntax
DeleteReportWWDetailRec(VAL InTran: BOOLEAN, REF DeleteRec: ReportWWDetailRec): INTEGER
Parameters
inTran: if already in a transaction or not
DeleteRec: ww report detail record to be deleted
Returns
INTEGER: success or failure
Side Effects
None
Description
This function deltes the report detail record from the report_detail table.
Dialog Forms Called
None
File Name
Syntax
GetAttribDataType(VAL id: INTEGER): STRING
Parameters
id: attribute id
Returns
STRING: attribute data type
Side Effects
None
Description
This function gets the attribute data type by selecting based on the attribute id.
Dialog Forms Called
None
File Name
Syntax
GetChildRecords(VAL nodeid: STRING, VAL tree: STRING): LIST OF STRING
Parameters
nodeid: node id in tree
tree: tree name eg. organization, location, connection etc.
Returns
LIST OF STRING: children records
Side Effects
None
Description
This function gets the child nodes of a parent tree node.
Dialog Forms Called
None
File Name
Syntax
GetHObjName(VAL hobj_id: STRING): STRING
Parameters
hobj_id: hobj(category) id
Returns
STRING: category name
Side Effects
None
Description
This function gets the hobj(category) name by selecting based on the hobj(category) id.
Dialog Forms Called
None
File Name
Syntax
GetIObjName(VAL iobj_id: STRING): STRING
Parameters
iobj_id: iobj(model) id
Returns
STRING: model name
Side Effects
None
Description
This function gets the iobj(model) name by selecting based on the iobj(model) id.
Dialog Forms Called
None
File Name
Syntax
GetReportAttribList(REF kList: LIST OF ReportAttribRec, VAL id: INTEGER): INTEGER
Parameters
kist: list of report attribute records
id: report hobj id
Returns
INTEGER: success or failure
Side Effects
None
Description
This function gets the report attribute records using the report_h_obj id.
Dialog Forms Called
None
File Name
Syntax
GetReportClassID(VAL detail_id: STRING, VAL hobj_id: STRING): INTEGER
Parameters
detail_id: report detail id
hobj_id: hobj(category) id
Returns
INTEGER: report hobj id
Side Effects
None
Description
This function gets the report hobj(category) id by selecting based on the report detail id and the hobj(category) id.
Dialog Forms Called
None
File Name
Syntax
GetReportClassList(REF kList: LIST OF ReportHObjRec, VAL id: INTEGER): INTEGER
Parameters
kist: report hobj(category) record
id: report detail id
Returns
INTEGER: success or failure
Side Effects
None
Description
This function gets the report hobj(category) records using the report_detail id.
Dialog Forms Called
None
File Name
Syntax
GetReportDetailID(VAL name: STRING): INTEGER
Parameters
name: report name
Returns
INTEGER: report detail id
Side Effects
None
Description
This function gets the report detail id by selecting based on the report name.
Dialog Forms Called
None
File Name
Syntax
GetReportDetailList(REF ktypeList: LIST OF ReportDetailRec, VAL whdl: WINDOW): INTEGER
Parameters
ktypeList: report detail record
whdl: window handle record
Returns
INTEGER: success or failure
Side Effects
None
Description
This function gets the report detail records when in secure mode
Dialog Forms Called
None
File Name
Syntax
GetReportModelList(REF kList: LIST OF ReportIObjRec, VAL id: INTEGER): INTEGER
Parameters
kist: list of report iobj(model) records
id: report hobj id
Returns
INTEGER: success or failure
Side Effects
None
Description
This function gets the report iobj(model) records using the report_h_obj id.
Dialog Forms Called
None
File Name
Syntax
GetReportTreeList(REF locList: LIST OF ReportTreeRec, REF orgList: LIST OF ReportTreeRec, REF conList: LIST OF ReportTreeRec, VAL id: INTEGER): INTEGER
Parameters
loclist: list of report tree records for locations
orgList: list of report tree records for organizations
conlist: list of report tree records for connections
id: report detail id
Returns
INTEGER: success or failure
Side Effects
None
Description
This function gets the location, organization, and connection record associated with the specified report detail id.
Dialog Forms Called
None
File Name
Syntax
GetSomeIValueList(VAL where: STRING, REF ktypelist: LIST OF IsaAttribRec): INTEGER
Parameters
where: where clause of select string
ktypelist: attribute value record
Returns
INTEGER: success or failure
Side Effects
None
Description
This function gets the attribute details by selecting using a specified where clause from the i_attrib_value table.
Dialog Forms Called
None
File Name
Syntax
GetSomePValueList(VAL where: STRING, REF ktypelist: LIST OF PhysAttribRec): INTEGER
Parameters
where: where clause of select string
ktypelist: attribute value record
Returns
INTEGER: success or failure
Side Effects
None
Description
This function gets the attribute details by selecting using a specified where clause from the pm_attrib_value table.
Dialog Forms Called
None
File Name
Syntax
GetSomeReportDetailList(REF ktypeList: LIST OF ReportDetailRec, VAL where: STRING): INTEGER
Parameters
ktypeList: report detail record
where: where clause of the select statement
Returns
INTEGER: success or failure
Side Effects
None
Description
This function gets a specific report detail record using the where clause.
Dialog Forms Called
None
File Name
Syntax
GetSomeReportInvContractList(VAL where: STRING, REF ktypelist: LIST OF IS_InventoryRec, VAL orderby: STRING, VAL massasset: ReportInstRec): INTEGER
Parameters
where: where clause of select string
ktypelist: list of inventory records
orderby: orderby clause of select string
massasset: report instance data
Returns
INTEGER: success or failure
Side Effects
None
Description
This function selects a list of matching inventory records. Used in advanced asset search to select assets based on entered contract search criteria.
Dialog Forms Called
None
File Name
Syntax
GetSomeReportInvHistList(VAL where: STRING, REF ktypelist: LIST OF IS_InventoryRec, VAL orderby: STRING, VAL massasset: ReportInstRec): INTEGER
Parameters
where: where clause of select string
ktypelist: list of inventory records
orderby: orderby clause of select string
massasset: report instance data
Returns
INTEGER: success or failure
Side Effects
None
Description
This function selects a list of matching inventory records. Used in advanced asset search to select assets based on entered event history search criteria.
Dialog Forms Called
None
File Name
Syntax
GetSomeReportInvList(VAL where: STRING, REF ktypelist: LIST OF IS_InventoryRec, VAL orderby: STRING, VAL massasset: ReportInstRec): INTEGER
Parameters
where: where clause of select string
ktypelist: list of inventory records
orderby: orderby clause of select string
massasset: report instance data
Returns
INTEGER: success or failure
Side Effects
None
Description
This function selects a list of matching inventory records. Used in advanced asset search to select assets based on entered inventory search criteria.
Dialog Forms Called
None
File Name
Syntax
GetSomeReportInvValList(VAL where: STRING, REF ktypelist: LIST OF IS_InventoryRec, VAL orderby: STRING, VAL massasset: ReportInstRec): INTEGER
Parameters
where: where clause of select string
ktypelist: list of inventory records
orderby: orderby clause of select string
massasset: report instance data
Returns
INTEGER: success or failure
Side Effects
None
Description
This function selects a list of matching inventory records. Used in advanced asset search to select assets based on entered valuation search criteria.
Dialog Forms Called
None
File Name
Syntax
HasSomeContractList(VAL where: STRING): BOOLEAN
Parameters
where: where clause of select string
Returns
BOOLEAN: exists or doesn't exist
Side Effects
None
Description
This function selects a list of matching contracts using the where clause to determine if there are existing matching contracts.
Dialog Forms Called
None
File Name
Syntax
HasSomeHistList(VAL where: STRING): BOOLEAN
Parameters
where: where clause of select string
Returns
BOOLEAN: exits or doesn't exist
Side Effects
None
Description
This function selects a list of matching events using the where clause to determine if there are existing matching events.
Dialog Forms Called
None
File Name
Syntax
HasSomeIValueList(VAL where: STRING): BOOLEAN
Parameters
where: where clause of select string
Returns
BOOLEAN: exists or doesn't exist
Side Effects
None
Description
This function selects a list of matching attributes using the where clause to determine if there are existing matching attributes.
Dialog Forms Called
None
File Name
Syntax
HasSomePValueList(VAL where: STRING): BOOLEAN
Parameters
where: where clause of select string
Returns
BOOLEAN: exists or doesn't exist
Side Effects
None
Description
This function selects a list of matching attributes using the where clause to determine if there are existing matching attributes.
Dialog Forms Called
None
File Name
Syntax
HasSomeValList(VAL where: STRING): BOOLEAN
Parameters
where: where clause of select string
Returns
BOOLEAN: exits or doesn't exist
Side Effects
None
Description
This function selects a list of matching valuation records using the where clause to determine if there are existing matching valuation records.
Dialog Forms Called
None
File Name
Syntax
InsertReportAttribRec(VAL InTran: BOOLEAN, REF InsertRec: ReportAttribRec): INTEGER
Parameters
inTran: if already in a transaction or not
InsertRec: report attribute record
Returns
INTEGER: success or failure
Side Effects
None
Description
This function inserts a report attribute record into the report_attrib table.
Dialog Forms Called
None
File Name
Syntax
InsertReportDetailRec(VAL InTran: BOOLEAN, REF InsertRec: ReportDetailRec): INTEGER
Parameters
inTran: if already in a transaction or not
InsertRec: report detail record to be inserted
Returns
Nothing
Side Effects
None
Description
This function inserts the report detail record into the report_detail table.
Dialog Forms Called
None
File Name
Syntax
InsertReportHObjRec(VAL InTran: BOOLEAN, REF InsertRec: ReportHObjRec): INTEGER
Parameters
inTran: if already in a transaction or not
InsertRec: report hobj(category) record to be inserted
Returns
INTEGER: success or failure
Side Effects
None
Description
This function inserts the report hobj record into the report_h_obj table.
Dialog Forms Called
None
File Name
Syntax
InsertReportIObjRec(VAL InTran: BOOLEAN, REF InsertRec: ReportIObjRec): INTEGER
Parameters
inTran: if already in a transaction or not
InsertRec: report iobj(model) record
Returns
INTEGER: success or failure
Side Effects
None
Description
This function inserts a report iobj(model) record into the report_i_obj table.
Dialog Forms Called
None
File Name
Syntax
InsertReportTreeRec(VAL InTran: BOOLEAN, REF InsertRec: ReportTreeRec): INTEGER
Parameters
inTran: if already in a transaction or not
InsertRec: report tree record
Returns
INTEGER: success or failure
Side Effects
None
Description
This function inserts a report tree record into the report_tree table.
Dialog Forms Called
None
File Name
Syntax
InsertReportWWDetailRec(VAL InTran: BOOLEAN, REF InsertRec: ReportWWDetailRec): INTEGER
Parameters
inTran: if already in a transaction or not
BeforeRec: ww report detail record
Returns
INTEGER: success or failure
Side Effects
None
Description
This function inserts a report detail record in the report_detail table.
Dialog Forms Called
None
File Name
Syntax
ISParentNode(VAL nodeid: STRING, VAL tree: STRING): BOOLEAN
Parameters
nodeid: node id in tree
tree: tree name eg. organization, location, connection etc.
Returns
BOOLEAN: TRUE or FALSE
Side Effects
None
Description
This function determines whether a node is the parent node or not.
Dialog Forms Called
None
File Name
Syntax
UpdateListOfReportAttribRec(VAL InTran: BOOLEAN, REF BeforeList: LIST OF ReportAttribRec, REF AfterList: LIST OF ReportAttribRec): INTEGER
Parameters
inTran: if already in a transaction or not
BeforeList: list of old report attribute records
AfterList: list of new report attribute records
Returns
INTEGER: success or failure
Side Effects
None
Description
This function updates a list of report attribute records in the report_attrib table.
Dialog Forms Called
None
File Name
Syntax
UpdateListofReportDetailRec(VAL InTran: BOOLEAN, REF BeforeList: LIST OF ReportDetailRec, AfterList: LIST OF ReportDetailRec): INTEGER)
Parameters
inTran: if already in a transaction or not
Beforelist: list of old report detail records
Afterlist: list of new report detail records
Returns
INTEGER: success or failure
Side Effects
None
Description
This function updates a list of report detail records in the report_detail table.
Dialog Forms Called
None
File Name
Syntax
UpdateListOfReportHObjRec(VAL InTran: BOOLEAN, REF BeforeList: LIST OF ReportHObjRec, AfterList: LIST OF ReportHObjRec): INTEGER
Parameters
inTran: if already in a transaction or not
BeforeList: list of old report hobj(category) records to be updated
AfterList: list of new report hobj(category) records to be updated
Returns
INTEGER: success or failure
Side Effects
None
Description
This function updates the list of report hobj records in the report_h_obj table.
Dialog Forms Called
None
File Name
Syntax
UpdateListOfReportIObjRec(VAL InTran: BOOLEAN, REF BeforeList: LIST OF ReportIObjRec, REF AfterList: LIST OF ReportIObjRec): INTEGER
Parameters
inTran: if already in a transaction or not
BeforeList: list of old report iobj(model) records
AfterList: list of new report iobj(model) records
Returns
INTEGER: success or failure
Side Effects
None
Description
This function updates a list of report iobj(model) records in the report_i_obj table.
Dialog Forms Called
None
File Name
Syntax
UpdateListOfReportTreeRec(VAL InTran: BOOLEAN, REF BeforeList: LIST OF ReportTreeRec, REF AfterList: LIST OF ReportTreeRec): INTEGER
Parameters
inTran: if already in a transaction or not
BeforeRec: list of old report tree records
AfterRec: list of new report tree records
Returns
INTEGER: success or failure
Side Effects
None
Description
This function updates a list of report tree records in the report_tree table.
Dialog Forms Called
None
File Name
Syntax
UpdateListofReportWWDetailRec(VAL InTran: BOOLEAN, REF BeforeList: LIST OF ReportWWDetailRec, AfterList: LIST OF ReportWWDetailRec): INTEGER)
Parameters
inTran: if already in a transaction or not
Beforelist: list of old ww report detail records
Afterlist: list of new ww report detail records
Returns
INTEGER: success or failure
Side Effects
None
Description
This function updates a list of report detail records in the report_detail table.
Dialog Forms Called
None
File Name
Syntax
UpdateReportAttribRec(VAL InTran: BOOLEAN, REF BeforeRec: ReportAttribRec, REF AfterRec: ReportAttribRec): INTEGER
Parameters
inTran: if already in a transaction or not
BeforeRec: old report attribute record
AfterRec: new report attribute record
Returns
INTEGER: success or failure
Side Effects
None
Description
This function updates a report attribute record in the report_attrib table.
Dialog Forms Called
None
File Name
Syntax
UpdateReportDetailRec(VAL InTran: BOOLEAN, REF BeforeRec: ReportDetailRec, AfterRec: ReportDetailRec): INTEGER)
Parameters
inTran: if already in a transaction or not
BeforeRec: old report detail record
AfterRec: new report detail record
Returns
INTEGER: success or failure
Side Effects
None
Description
This function updates the report detail record in the report_detail table.
Dialog Forms Called
None
File Name
Syntax
UpdateReportHObjRec(VAL InTran: BOOLEAN, REF BeforeRec: ReportHObjRec, AfterRec: ReportHObjRec): INTEGER
Parameters
inTran: if already in a transaction or not
BeforeRec: old report hobj(category) record to be updated
AfterRec: new report hobj(category) record to be updated
Returns
INTEGER: success or failure
Side Effects
None
Description
This function updates the report hobj record in the report_h_obj table.
Dialog Forms Called
None
File Name
Syntax
UpdateReportIObjRec(VAL InTran: BOOLEAN, REF BeforeRec: ReportIObjRec, REF AfterRec: ReportIObjRec): INTEGER
Parameters
inTran: if already in a transaction or not
BeforeRec: old report iobj(model) record
AfterRec: new report iobj(model) record
Returns
INTEGER: success or failure
Side Effects
None
Description
This function updates a report iobj(model) record in the report_i_obj table.
Dialog Forms Called
None
File Name
Syntax
UpdateReportTreeRec(VAL InTran: BOOLEAN, REF BeforeRec: ReportTreeRec, REF AfterRec: ReportTreeRec): INTEGER
Parameters
inTran: if already in a transaction or not
BeforeRec: old report tree record
AfterRec: new report tree record
Returns
INTEGER: success or failure
Side Effects
None
Description
This function updates a report tree record in the report_tree table.
Dialog Forms Called
None
File Name
Syntax
UpdateReportWWDetailRec(VAL InTran: BOOLEAN, REF BeforeRec: ReportWWDetailRec, AfterRec: ReportDetailRec): INTEGER)
Parameters
inTran: if already in a transaction or not
BeforeRec: old report detail record
AfterRec: new report detail record
Returns
INTEGER: success or failure
Side Effects
None
Description
This function updates the report detail record in the report_detail table.
Dialog Forms Called
None