Routines for i_rpt_db.kb


DeleteReportAttribRec

File Name

i_rpt_db.kb

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


DeleteReportDetailRec

File Name

i_rpt_db.kb

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


DeleteReportHObjRec

File Name

i_rpt_db.kb

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


DeleteReportIObjRec

File Name

i_rpt_db.kb

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


DeleteReportTreeRec

File Name

i_rpt_db.kb

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


DeleteReportWWDetailRec

File Name

i_rpt_db.kb

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


GetAttribDataType

File Name

i_rpt_db.kb

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


GetChildRecords

File Name

i_rpt_db.kb

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


GetHObjName

File Name

i_rpt_db.kb

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


GetIObjName

File Name

i_rpt_db.kb

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


GetReportAttribList

File Name

i_rpt_db.kb

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


GetReportClassID

File Name

i_rpt_db.kb

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


GetReportClassList

File Name

i_rpt_db.kb

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


GetReportDetailID

File Name

i_rpt_db.kb

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


GetReportDetailList

File Name

i_rpt_db.kb

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


GetReportModelList

File Name

i_rpt_db.kb

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


GetReportTreeList

File Name

i_rpt_db.kb

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


GetSomeIValueList

File Name

i_rpt_db.kb

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


GetSomePValueList

File Name

i_rpt_db.kb

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


GetSomeReportDetailList

File Name

i_rpt_db.kb

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


GetSomeReportInvContractList

File Name

i_rpt_db.kb

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


GetSomeReportInvHistList

File Name

i_rpt_db.kb

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


GetSomeReportInvList

File Name

i_rpt_db.kb

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


GetSomeReportInvValList

File Name

i_rpt_db.kb

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


HasSomeContractList

File Name

i_rpt_db.kb

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


HasSomeHistList

File Name

i_rpt_db.kb

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


HasSomeIValueList

File Name

i_rpt_db.kb

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


HasSomePValueList

File Name

i_rpt_db.kb

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


HasSomeValList

File Name

i_rpt_db.kb

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


InsertReportAttribRec

File Name

i_rpt_db.kb

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


InsertReportDetailRec

File Name

i_rpt_db.kb

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


InsertReportHObjRec

File Name

i_rpt_db.kb

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


InsertReportIObjRec

File Name

i_rpt_db.kb

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


InsertReportTreeRec

File Name

i_rpt_db.kb

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


InsertReportWWDetailRec

File Name

i_rpt_db.kb

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


ISParentNode

File Name

i_rpt_db.kb

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


UpdateListOfReportAttribRec

File Name

i_rpt_db.kb

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


UpdateListofReportDetailRec

File Name

i_rpt_db.kb

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


UpdateListOfReportHObjRec

File Name

i_rpt_db.kb

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


UpdateListOfReportIObjRec

File Name

i_rpt_db.kb

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


UpdateListOfReportTreeRec

File Name

i_rpt_db.kb

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


UpdateListofReportWWDetailRec

File Name

i_rpt_db.kb

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


UpdateReportAttribRec

File Name

i_rpt_db.kb

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


UpdateReportDetailRec

File Name

i_rpt_db.kb

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


UpdateReportHObjRec

File Name

i_rpt_db.kb

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


UpdateReportIObjRec

File Name

i_rpt_db.kb

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


UpdateReportTreeRec

File Name

i_rpt_db.kb

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


UpdateReportWWDetailRec

File Name

i_rpt_db.kb

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